EntityQuery condition on translation status
This should do what you want.  Note that the id's will load the default language, you will need to use getTranslation(langCode) to get the translated node.

$query = \Drupal::entityQuery('node');
$query-&gt;condition('status', 0);
$query-&gt;condition('type', YOUR_TYPE);
$query-&gt;condition('langcode', 'de');
$ids = $query-&gt;execute();