Skip to content

Registered aircraft · 5,440

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

N160FEFederal Express Corp · Memphis, TNBuilt 2018 · S/N 63098 N160LDRegistered aircraftBuilt 1989 · S/N 1115 N160UPUnited Parcel Service Co · Louisville, KYBuilt 2004 · S/N 0849 N161AAAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 7085 N161FEFederal Express Corp · Memphis, TNBuilt 2018 · S/N 43553 N161MMRye & Olive LLC · Naples, FLBuilt 2003 · S/N 1511 N161RBower Fredrick S · Watervliet, MIS/N TE-365 N161UPUnited Parcel Service Co · Louisville, KYBuilt 2004 · S/N MSN 0850 N161UWAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 1403 N1621WColeman Alan · Tyler, TXBuilt 1972 · S/N TC-1455 N1624K4kla LLC · Pittsfield, MABuilt 2001 · S/N 1457 N1625Saba Rock Transportation LLC · Corona Del Mar, CABuilt 1998 · S/N 1358 N162AAAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 6621 N162FEFederal Express Corp · Memphis, TNBuilt 2018 · S/N 43632 N162NBorgen Brian K · Osage Beach, MOBuilt 1966 · S/N TE-154 N162UPUnited Parcel Service Co · Louisville, KYBuilt 2005 · S/N 0851 N162UWAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 1412 N163AAAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 6866 N163FEFederal Express Corp · Memphis, TNBuilt 2018 · S/N 62499 N163JWGo Vector One LLC · Pls Vrds Est, CABuilt 1988 · S/N 1071 N163MDArad Energy LLC · Conroe, TXBuilt 1996 · S/N 1302 N163QGofly Trading LLC · Opa Locka, FLBuilt 1964 · S/N TC-671 N163UPUnited Parcel Service Co · Louisville, KYBuilt 2005 · S/N 0852 N163USAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 1417 N164FEFederal Express Corp · Memphis, TNBuilt 2018 · S/N 43554 N164HAUas Transervices Inc · Boca Raton, FLBuilt 1968 · S/N U-60 N164NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 6909 N164TSBank Of Utah Trustee · Salt Lake City, UTS/N 21119 N164UPUnited Parcel Service Co · Louisville, KYBuilt 2005 · S/N 0853 N1659WTrim Aire Aviation Inc · Mexia, TXBuilt 1973 · S/N TC-1475 N165FEFederal Express Corp · Memphis, TNBuilt 2018 · S/N 62500 N165NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 6956 N165RWCw Aircraft LLC · Atlanta, GABuilt 1964 · S/N TC-683 N165TSBank Of Utah Trustee · Salt Lake City, UTS/N 21523 N165UPUnited Parcel Service Co · Louisville, KYBuilt 2005 · S/N 0854 N165USAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 1431 N165YVAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-165 N166ACAtlanta Aviation Academy Inc · Lawrenceville, GABuilt 1979 · S/N ME263 N166FEFederal Express Corp · Memphis, TNBuilt 2018 · S/N 43633 N166NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 6973 N166UPUnited Parcel Service Co · Louisville, KYBuilt 2005 · S/N 0861 N167ANAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 7013 N167AWPlane Fun Inc Tr Trustee · Snellville, GABuilt 1978 · S/N 340A0537 N167FEFederal Express Corp · Memphis, TNBuilt 2018 · S/N 63099 N167NGohman Charles Scott · Salinas, CAS/N TE-137 N167UPUnited Parcel Service Co · Louisville, KYBuilt 2005 · S/N 0862 N167USBank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N 1442 N1683WAirsouth Aviation Services Inc · Little Rock, ARS/N TC-1526 N168FEFederal Express Corp · Memphis, TNBuilt 2018 · S/N 63100 N168UPUnited Parcel Service Co · Louisville, KYBuilt 2005 · S/N 0863

Back to AD 95-26-15 R1