Skip to content

Registered aircraft · 896

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

N160UPUnited Parcel Service Co · Louisville, KYBuilt 2004 · S/N 0849 N161FEFederal Express Corp · Memphis, TNBuilt 2018 · S/N 43553 N161UPUnited Parcel Service Co · Louisville, KYBuilt 2004 · S/N MSN 0850 N162FEFederal Express Corp · Memphis, TNBuilt 2018 · S/N 43632 N162UPUnited Parcel Service Co · Louisville, KYBuilt 2005 · S/N 0851 N163FEFederal Express Corp · Memphis, TNBuilt 2018 · S/N 62499 N163UPUnited Parcel Service Co · Louisville, KYBuilt 2005 · S/N 0852 N164FEFederal Express Corp · Memphis, TNBuilt 2018 · S/N 43554 N164UPUnited Parcel Service Co · Louisville, KYBuilt 2005 · S/N 0853 N165FEFederal Express Corp · Memphis, TNBuilt 2018 · S/N 62500 N165UPUnited Parcel Service Co · Louisville, KYBuilt 2005 · S/N 0854 N166FEFederal Express Corp · Memphis, TNBuilt 2018 · S/N 43633 N166UPUnited Parcel Service Co · Louisville, KYBuilt 2005 · S/N 0861 N167FEFederal Express Corp · Memphis, TNBuilt 2018 · S/N 63099 N167UPUnited Parcel Service Co · Louisville, KYBuilt 2005 · S/N 0862 N168FEFederal Express Corp · Memphis, TNBuilt 2018 · S/N 63100 N168UPUnited Parcel Service Co · Louisville, KYBuilt 2005 · S/N 0863 N169DZDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 29689 N169FEFederal Express Corp · Memphis, TNBuilt 2018 · S/N 63101 N169UPUnited Parcel Service Co · Louisville, KYBuilt 2006 · S/N 0864 N1709AAndromeda Leasing I LLC · Purchase, NYS/N 24086 N170FEFederal Express Corp · Memphis, TNBuilt 2018 · S/N 63102 N170UPUnited Parcel Service Co · Louisville, KYBuilt 2006 · S/N 0865 N17104United Airlines Inc · Chicago, ILBuilt 1994 · S/N 27294 N17105United Airlines Inc · Chicago, ILBuilt 1994 · S/N 27295 N17122United Airlines Inc · Chicago, ILBuilt 1997 · S/N 27564 N17126United Airlines Inc · Chicago, ILBuilt 1998 · S/N 27566 N17128United Airlines Inc · Chicago, ILBuilt 1998 · S/N 27567 N17133United Airlines Inc · Chicago, ILBuilt 1998 · S/N 29282 N17139United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30352 N171DNDelta Air Lines Inc · Atlanta, GABuilt 1990 · S/N 24759 N171DZDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 29690 N171UAUnited Airlines Inc · Chicago, ILBuilt 1989 · S/N 24322 N171UPUnited Parcel Service Co · Louisville, KYBuilt 2006 · S/N 0866 N172AJWilmington Trust Co Trustee · Wilmington, DEBuilt 2002 · S/N 32400 N172DNDelta Air Lines Inc · Atlanta, GABuilt 1990 · S/N 24775 N172DZDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 29691 N172FEFederal Express Corp · Memphis, TNBuilt 2019 · S/N 63103 N172UPUnited Parcel Service Co · Louisville, KYBuilt 2006 · S/N 0867 N173DZDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 29692 N173FEFederal Express Corp · Memphis, TNBuilt 2019 · S/N 63104 N173UPUnited Parcel Service Co · Louisville, KYBuilt 2006 · S/N 0868 N174DNDelta Air Lines Inc · Atlanta, GABuilt 1990 · S/N 24802 N174DZDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 29693 N174FEFederal Express Corp · Memphis, TNBuilt 2019 · S/N 63105 N174UPUnited Parcel Service Co · Louisville, KYBuilt 2006 · S/N 0869 N175DNDelta Air Lines Inc · Atlanta, GABuilt 1990 · S/N 24803 N175DZDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 29696 N175FEFederal Express Corp · Memphis, TNBuilt 2019 · S/N 63106 N176DZDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 29697

Back to AD 85-14-02 R2