Skip to content

Registered aircraft · 547

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

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:91-05-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:91-05-21') ORDER BY n_number

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:91-05-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:91-05-21')
  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:91-05-21')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:91-05-21')
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.

N101FEFederal Express Corp · Memphis, TNBuilt 2013 · S/N 42706 N102DADelta Air Lines Inc · Atlanta, GABuilt 1982 · S/N 22214 N102FEFederal Express Corp · Memphis, TNBuilt 2013 · S/N 42707 N103FEFederal Express Corp · Memphis, TNBuilt 2013 · S/N 43544 N105FEFederal Express Corp · Memphis, TNBuilt 2019 · S/N 64055 N106FEFederal Express Corp · Memphis, TNBuilt 2014 · S/N 42709 N107FEFederal Express Corp · Memphis, TNBuilt 2014 · S/N 44377 N108FEFederal Express Corp · Memphis, TNBuilt 2014 · S/N 44378 N109FEFederal Express Corp · Memphis, TNBuilt 2014 · S/N 42710 N110FEFederal Express Corp · Memphis, TNBuilt 2014 · S/N 43542 N111FEFederal Express Corp · Memphis, TNBuilt 2020 · S/N 64060 N112FEFederal Express Corp · Memphis, TNBuilt 2015 · S/N 43543 N113FEFederal Express Corp · Memphis, TNBuilt 2015 · S/N 42711 N114FEFederal Express Corp · Memphis, TNBuilt 2015 · S/N 42712 N115FEFederal Express Corp · Memphis, TNBuilt 2015 · S/N 42713 N117FEFederal Express Corp · Memphis, TNBuilt 2015 · S/N 44379 N118FEFederal Express Corp · Memphis, TNBuilt 2015 · S/N 42714 N119FEFederal Express Corp · Memphis, TNBuilt 2019 · S/N 64057 N120FEFederal Express Corporation · Memphis, TNBuilt 2015 · S/N 44380 N1217AAndromeda Leasing I LLC · Purchase, NYBuilt 1992 · S/N 25865 N121FEFederal Express Corp · Memphis, TNBuilt 2015 · S/N 43545 N1229AAndromeda Leasing I LLC · Purchase, NYBuilt 1999 · S/N 28884 N122FEFederal Express Corp · Memphis, TNBuilt 2015 · S/N 42715 N123FEFederal Express Corp · Memphis, TNBuilt 2015 · S/N 42716 N124FEFederal Express Corp · Memphis, TNBuilt 2015 · S/N 43546 N125FEFederal Express Corp · Memphis, TNBuilt 2015 · S/N 42717 N126FEFederal Express Corp · Memphis, TNBuilt 2015 · S/N 42718 N127FEFederal Express Corp · Memphis, TNBuilt 2015 · S/N 43547 N128FEFederal Express Corp · Memphis, TNBuilt 2015 · S/N 42719 N129FEFederal Express Corp · Memphis, TNBuilt 2015 · S/N 43548 N130FEFederal Express Corp · Memphis, TNBuilt 2016 · S/N 42720 N131FEFederal Express Corp · Memphis, TNBuilt 2016 · S/N 61205 N1321AAndromeda Leasing I LLC · Purchase, NYBuilt 1995 · S/N 27957 N1327AMsn 26328 LLC · Purchase, NYBuilt 1996 · S/N 26328 N132FEFederal Express Corp · Memphis, TNBuilt 2016 · S/N 42721 N133FEFederal Express Corp · Memphis, TNBuilt 2016 · S/N 43549 N134FEFederal Express Corp · Memphis, TNBuilt 2016 · S/N 43550 N135FEFederal Express Corp · Memphis, TNBuilt 2016 · S/N 42722 N1361AMsn 26265 LLC · Purchase, NYBuilt 1995 · S/N 26265 N136FEFederal Express Corp · Memphis, TNBuilt 2019 · S/N 64058 N137FEFederal Express Corp · Memphis, TNBuilt 2016 · S/N 61206 N1381AMsn 27615 LLC · Purchase, NYBuilt 1997 · S/N 27615 N138FEFederal Express Corp · Memphis, TNBuilt 2016 · S/N 42723 N139FEFederal Express Corp · Memphis, TNBuilt 2016 · S/N 43538 N1409AMsn 27959 LLC · Purchase, NYBuilt 1996 · S/N 27960 N140FEFederal Express Corp · Memphis, TNBuilt 2016 · S/N 43541 N141FEFederal Express Corp · Memphis, TNBuilt 2016 · S/N 42724 N1427AAndromeda Leasing I LLC · Purchase, NYBuilt 1996 · S/N 28098 N142FEFederal Express Corp · Memphis, TNBuilt 2016 · S/N 42725 N1439AAndromeda Leasing I LLC · Purchase, NYBuilt 1997 · S/N 28495

Back to AD 91-05-21