AD 75-08-17
Registered aircraft · 209
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:75-08-17')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-08-17')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:75-08-17') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-08-17') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N422BNAntares Aviation LLC · Boca Raton, FLN438AAFrontera Flight Holding Inc · Dover, DEN438BNAntares Aviation LLC · Boca Raton, FLN44503Frontera Flight Holdings Inc · Dover, DEN465TWSierra American Corp · Wilmington, DEN467TWSierra American Corp · Wilmington, DEN471EVGugu Ltd · Bellevue, WAN472EVFletcher Aviation Services LLC · Bismarck, NDN481FLIfl Group Inc · Waterford, MIN482AAArctic One LLC · Fairbanks, AKN483AArctic One LLC · Fairbanks, AKN502DADodson International Parts Inc · Rantoul, KSN520TCDodson International Parts Inc · Rantoul, KSN521FLIfl Group Inc · Waterford, MIN522AXBc Aircraft Leasing LLC · Albuquerque, NMN553AAFrontera Flight Holdings Inc · Dover, DEN556AAFrontera Flight Holding Inc · Dover, DEN557ANPac Blue Aerospace · Fairbanks, AKN558AAPac Blue Aerospace · Fairbanks, AKN560AAPac Blue Aerospace · Fairbanks, AKN561AAPac Blue Aerospace · Fairbanks, AKN566AAFrontera Flight Holding Inc · Dover, DEN572AA727x Aerospace Corp · Lewes, DEN573AAPac Blue Aerospace · Fairbanks, AKN574AAPac Blue Aerospace · Fairbanks, AKN576AAFronteraflight Holdings Inc · Dover, DEN581AAFrontera Flight Holding Inc · Dover, DEN583AAPac Blue Aerospace · Fairbanks, AKN585AAPac Blue Aerospace · Fairbanks, AKN586AAAerothrust Holdings Leasing LLC · Miami, FLN590AAFrontera Flight Holdings Inc · Dover, DEN595AAPac Blue Aerospace · Fairbanks, AKN603AXBc Aircraft Leasing LLC · Albuquerque, NMN612AXBc Aircraft Leasing LLC · Albuquerque, NMN615PA2d Aviation Corp · Frisco, TXN617USLogistic Air Inc · Reno, NVN618USLogistic Air Inc · Reno, NVN621AXBc Aircraft Leasing LLC · Albuquerque, NMN637SHPacific Aircorp 49741 Inc · San Francisco, CAFirst renewal noticeN68UPRoyal Air Freight Inc · Waterford, MIN697BJTexas Air And Space Museum Inc · Amarillo, TXN708AAWorld Aviation Services LLC · Medley, FLN720CKKalitta Charters II LLC · Ypsilanti, MIN721MNBd Md-87 LLC · Longwood, FLN724CKKalitta Charters II LLC · Ypsilanti, MIN726USUSA Jet Airlines Inc · Belleville, MIN727HLAviation Sales And Charter LLC · Dover, DEN727NKAntares Aviation LLC · Boca Raton, FLN727USUSA Jet Airlines Inc · Belleville, MIN727YKFayaka Airways LLC · San Francisco, CANon-citizen corporation, flight hours not reported
Back to AD 75-08-17