Skip to content

Registered aircraft · 2,916

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:74-08-09-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:74-08-09-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:74-08-09-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:74-08-09-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:74-08-09-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:74-08-09-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.

N826NNAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 31089 N826VVOmega Air Inc · San Antonio, TXS/N 47826 N827BETrans Executive Airlines Of Hawaii Inc · Honolulu, HIBuilt 1988 · S/N SH3746 N827JBJetblue Airways Corp · Long Island City, NYBuilt 2013 · S/N 5677 N827NNAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 33209 N828AHAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1984 · S/N 415 N828JBJetblue Airways Corp · Long Island City, NYBuilt 2013 · S/N 5723 N829NNAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 33210 N829WWHemisphere Aerospace Investments LLC · Waco, TXS/N 27503 N8300GUS Special Operations Command · Tampa, FLBuilt 1991 · S/N 298 N8306Omega Air Inc · Selma, TXS/N 48306 N8308Omega Air Inc · Selma, TXS/N 48308 N830FETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 1239 N830NNAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 31091 N8310Omega Air Inc · Selma, TXS/N 48310 N831NNAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 33211 N832FEFederal Express Corp · Memphis, TNS/N 1472 N832NNAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 33521 N832USUSA Jet Airlines Inc · Belleville, MIBuilt 1991 · S/N 53259 N833NNAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 31093 N833USUSA Jet Airlines Inc · Belleville, MIBuilt 1991 · S/N 53215 N834ASAersale Inc · Coral Gables, FLS/N 28834 N834JBJetblue Airways Corp · Long Island City, NYBuilt 2013 · S/N 5782 N834NNAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 29576 N834USUSA Jet Airlines Inc · Belleville, MIBuilt 1990 · S/N 53115 N835NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2010 · S/N 29577 N835USUSA Jet Airlines Inc · Belleville, MIBuilt 1990 · S/N 53172 N836NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 31095 N836USUSA Jet Airlines Inc · Belleville, MIBuilt 1991 · S/N 53214 N837EXBank Of Utah Trustee · Salt Lake City, UTFirst renewal noticeS/N 217 N837NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 30908 N837USUSA Jet Airlines Inc · Belleville, MIBuilt 1991 · S/N 53257 N837VABank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4558 N838DCorsair Two LLC · Hillsboro, ORBuilt 1958 · S/N 45347 N838NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 31097 N839EXBank Of Utah Trustee · Salt Lake City, UTFirst renewal noticeBuilt 1990 · S/N 226 N839NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 29557 N839SYBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 42083 N840NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 33518 N840SYBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 42084 N841NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 30914 N842NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 31099 N842USUSA Jet Airlines Inc · Belleville, MIBuilt 1992 · S/N 53380 N843NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 30906 N844NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 33212 N844THN844th LLC · California, MDBuilt 1944 · S/N 13070 N845AMWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2014 · S/N 36706 N845NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 40579 N846NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 31101 N847NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 29575

Back to AD 74-08-09 R2