Skip to content

Registered aircraft · 149

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:2000-22-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:2000-22-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:2000-22-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:2000-22-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:2000-22-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:2000-22-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.

N120JMSouth Aircraft Leasing Inc · Wilmington, DEBuilt 1988 · S/N 48311 N141WEOmega Air Inc · San Antonio, TXS/N 46661 N17085Bc Aircraft Leasing LLC · Albuquerque, NMBuilt 1975 · S/N 47957 N235ULAircraft Endeavors LLC · San Antonio, TXBuilt 1976 · S/N 46956 N250UPUnited Parcel Service Co · Louisville, KYBuilt 1995 · S/N 48745 N251UPUnited Parcel Service Co · Louisville, KYBuilt 1995 · S/N 48744 N252UPUnited Parcel Service Co · Louisville, KYBuilt 1996 · S/N 48768 N253UPUnited Parcel Service Co · Louisville, KYS/N 48439 N254UPUnited Parcel Service Co · Louisville, KYBuilt 1993 · S/N 48406 N255UPUnited Parcel Service Co · Louisville, KYBuilt 1992 · S/N 48404 N256UPUnited Parcel Service Co · Louisville, KYBuilt 1992 · S/N 48405 N257UPUnited Parcel Service Co · Louisville, KYBuilt 1992 · S/N 48451 N258UPUnited Parcel Service Co · Louisville, KYBuilt 1991 · S/N 48416 N260UPUnited Parcel Service Co · Louisville, KYBuilt 1992 · S/N 48418 N261UPUnited Parcel Service Co · Louisville, KYBuilt 2001 · S/N 48805 N262UPUnited Parcel Service Co · Louisville, KYBuilt 2001 · S/N 48806 N263UPUnited Parcel Service Co · Louisville, KYBuilt 1998 · S/N 48782 N264DEAircraft Endeavors LLC · San Antonio, TXBuilt 1978 · S/N 46985 N264UPUnited Parcel Service Co · Louisville, KYBuilt 2000 · S/N 48800 N265UPUnited Parcel Service Co · Louisville, KYBuilt 2001 · S/N 48803 N273UPUnited Parcel Service Co · Louisville, KYBuilt 1994 · S/N 48574 N274UPUnited Parcel Service Co · Louisville, KYBuilt 1994 · S/N 48575 N275UPUnited Parcel Service Co · Louisville, KYBuilt 1997 · S/N 48774 N276UPUnited Parcel Service Co · Louisville, KYBuilt 1996 · S/N 48579 N278UPUnited Parcel Service Co · Louisville, KYBuilt 1995 · S/N 48577 N281UPUnited Parcel Service Co · Louisville, KYBuilt 1993 · S/N 48538 N284UPUnited Parcel Service Co · Louisville, KYBuilt 1997 · S/N 48541 N286UPUnited Parcel Service Co · Louisville, KYBuilt 1991 · S/N 48453 N287UPUnited Parcel Service Co · Louisville, KYBuilt 1994 · S/N 48539 N288UPUnited Parcel Service Co · Louisville, KYBuilt 1997 · S/N 48540 N289UPUnited Parcel Service Co · Louisville, KYBuilt 1992 · S/N 48455 N290UPUnited Parcel Service Co · Louisville, KYBuilt 1992 · S/N 48456 N291UPUnited Parcel Service Co · Louisville, KYBuilt 1992 · S/N 48477 N292UPUnited Parcel Service Co · Louisville, KYBuilt 1993 · S/N 48566 N293UPUnited Parcel Service Co · Louisville, KYBuilt 1991 · S/N 48473 N294UPUnited Parcel Service Co · Louisville, KYBuilt 1991 · S/N 48472 N303FEFederal Express Corporation · Memphis, TNBuilt 1973 · S/N 46802 N304FEFederal Express Corporation · Memphis, TNBuilt 1978 · S/N 46992 N306FEFederal Express Corp · Memphis, TNBuilt 1985 · S/N 48287 N307FEFederal Express Corp · Memphis, TNBuilt 1986 · S/N 48291 N308FEFederal Express Corp · Memphis, TNBuilt 1986 · S/N 48297 N315FEFederal Express Corp · Memphis, TNBuilt 1988 · S/N 48313 N316FEFederal Express Corp · Memphis, TNBuilt 1988 · S/N 48314 N318FEFederal Express Corp · Memphis, TNBuilt 1979 · S/N 46837 N319FEFederal Express Corp · Memphis, TNBuilt 1980 · S/N 47820 N320FEFederal Express Corp · Memphis, TNBuilt 1980 · S/N 47835 N321FEFederal Express Corp · Memphis, TNBuilt 1980 · S/N 47836 N330AUProject Orbis International Inc · New York, NYBuilt 1973 · S/N 46800 N367FEFederal Express Corporation · Memphis, TNBuilt 1971 · S/N 46605 N369FEFederal Express Corporation · Memphis, TNBuilt 1972 · S/N 46607

Back to AD 2000-22-21