AD 75-05-01
Registered aircraft · 920
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-05-01')
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-05-01')
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-05-01') 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-05-01') 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.
N384DADelta Air Lines Inc · Atlanta, GAN385DNDelta Air Lines Inc · Atlanta, GAN386DADelta Air Lines Inc · Atlanta, GAN38727United Airlines Inc · Chicago, ILN387DADelta Air Lines Inc · Atlanta, GAN388DADelta Air Lines Inc · Atlanta, GAN389DADelta Air Lines Inc · Atlanta, GAN390DADelta Air Lines Inc · Atlanta, GAN391DADelta Air Lines Inc · Atlanta, GAN39297United Airlines Inc · Chicago, ILN392DADelta Air Lines Inc · Atlanta, GAN393DADelta Air Lines Inc · Atlanta, GAN394DADelta Air Lines Inc · Atlanta, GAN395DNDelta Air Lines Inc · Atlanta, GAN396DADelta Air Lines Inc · Atlanta, GAN39726United Airlines Inc · Chicago, ILN39728United Airlines Inc · Chicago, ILN397DADelta Air Lines Inc · Atlanta, GAN398DADelta Air Lines Inc · Atlanta, GAN399DADelta Air Lines Inc · Atlanta, GAN403YKNorthern Air Cargo LLC · Anchorage, AKN404KZWilmington Trust Co Trustee · Wilmington, DEN405CKKalitta Charters II LLC · Ypsilanti, MIN405KZWilmington Trust Co Trustee · Wilmington, DEN405YKNas Aircraft Leasing Company LLC · Anchorage, AKN406CKKalitta Charters II LLC · Ypsilanti, MIN406KZWilmington Trust Co Trustee · Wilmington, DEN409YKAircraft 25859 LLC · Lake Mary, FLN422BNAntares Aviation LLC · Boca Raton, FLN429MCAtlas Air Inc · Purchase, NYN438BNAntares Aviation LLC · Boca Raton, FLN438GTAtlas Air Inc · White Plains, NYN439GTAtlas Air Inc · White Plains, NYN440KHAircraft 28889 LLC · Lake Mary, FLN442KHAircraft 28888 LLC · Lake Mary, FLN444HECsc Delaware Trust Co Trustee · Wilmington, DEN454PCOmega Air Inc · San Antonio, TXN464MCAtlas Air Inc · Purchase, NYN465MCAtlas Air Inc · Purchase, NYN465TWSierra American Corp · Wilmington, DEN467TWSierra American Corp · Wilmington, DEN471DSBoeing Co · Renton, WAN471EVGugu Ltd · Bellevue, WAN471MCAtlas Air Inc · White Plains, NYN472EVFletcher Aviation Services LLC · Bismarck, NDN475USUS Department Of Homeland Security · Arlington, VAN477USUS Department Of Homeland Security · Arlington, VAN480MCAtlas Air Inc · Purchase, NYN481MCAtlas Air Inc · Purchase, NYN482MCAtlas Air Inc · Purchase, NY
Back to AD 75-05-01