...
AND Z983.FIELD_ID IN (16,19,230,90,106,122,138,239,98,114,130,146 ) –
/* These are the only fields requested for this report/* - all data fields described here :
*/
AND Y05.AIRCRAFT_ID NOT IN (SELECT Q01.AIRCRAFT_ID
FROM Q01_AIRCRFT_FLGHT_ATHTY Q01
WHERE Q01.TYPE_OF_AUTHORITY_CD IN ('H','I','F'))AND TO_NUMBER(TO_CHAR(Y05.DATE_START_DTE,'YYYYMM') ) = 202107
...