Skip to content

Registered aircraft · 257

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

N111REX Aviation Group LLC · Beverly Hills, CABuilt 1988 · S/N 49670 N120JMSouth Aircraft Leasing Inc · Wilmington, DEBuilt 1988 · S/N 48311 N141WEOmega Air Inc · San Antonio, TXS/N 46661 N158JPAerotrust Services Corp Trustee · Wilmington, DES/N 53195 N17085Bc Aircraft Leasing LLC · Albuquerque, NMBuilt 1975 · S/N 47957 N218JPAerotrust Services Corp Trustee · Wilmington, DES/N 53305 N235ULAircraft Endeavors LLC · San Antonio, TXBuilt 1976 · S/N 46956 N264DEAircraft Endeavors LLC · San Antonio, TXBuilt 1978 · S/N 46985 N287KBCsds Asset Management LLC · Marana, AZBuilt 1987 · S/N 49768 N291EACorsair Two LLC · Hillsboro, ORBuilt 1991 · S/N 53039 N292EACorsair Two LLC · Hillsboro, ORBuilt 1991 · S/N 53208 N293EACorsair Two LLC · Hillsboro, ORBuilt 1991 · S/N 53209 N294EACorsair Two LLC · Hillsboro, ORBuilt 1991 · S/N 53210 N295EACorsair Two LLC · Hillsboro, ORBuilt 1991 · S/N 53211 N296EACorsair Two LLC · Hillsboro, ORBuilt 1991 · S/N 53212 N297EACorsair Two LLC · Hillsboro, ORBuilt 1991 · S/N 53213 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 N438AAFrontera Flight Holding Inc · Dover, DEBuilt 1987 · S/N 49456 N44503Frontera Flight Holdings Inc · Dover, DEBuilt 1989 · S/N 49797 N475HAHawaiian Airlines Inc · Honolulu, HIBuilt 2001 · S/N 55121 N476HAHawaiian Airlines Inc · Honolulu, HIBuilt 2001 · S/N 55118 N477HAHawaiian Airlines Inc · Honolulu, HIBuilt 2001 · S/N 55122 N478HAHawaiian Airlines Inc · Honolulu, HIBuilt 2001 · S/N 55123 N479HAHawaiian Airlines Inc · Honolulu, HIBuilt 2001 · S/N 55124 N480HAHawaiian Airlines Inc · Honolulu, HIBuilt 2001 · S/N 55125 N482AAArctic One LLC · Fairbanks, AKBuilt 1988 · S/N 49675 N483AArctic One LLC · Fairbanks, AKBuilt 1988 · S/N 49676 N483HAHawaiian Airlines Inc · Honolulu, HIBuilt 2001 · S/N 55128 N484HAHawaiian Airlines Inc · Honolulu, HIBuilt 2001 · S/N 55129 N485HAHawaiian Airlines Inc · Honolulu, HIBuilt 2001 · S/N 55130 N486HAHawaiian Airlines Inc · Honolulu, HIBuilt 2001 · S/N 55131 N487HAHawaiian Airlines Inc · Honolulu, HIBuilt 2001 · S/N 55132 N488HAHawaiian Airlines Inc · Honolulu, HIBuilt 1998 · S/N 55001 N489HAHawaiian Airlines Inc · Honolulu, HIBuilt 1998 · S/N 55002 N490HAHawaiian Airlines Inc · Honolulu, HIBuilt 2000 · S/N 55151 N491HAHawaiian Airlines Inc · Honolulu, HIBuilt 2003 · S/N 55175 N492HAHawaiian Airlines Inc · Honolulu, HIBuilt 2004 · S/N 55181

Back to AD 2015-02-05