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.

N858NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 30904 N859AMUmb Bank Na Trustee · Salt Lake City, UTBuilt 2003 · S/N 32796 N859NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 29555 N860NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 40583 N861GAWorld Atlantic Leasing LLC · Miami Springs, FLBuilt 1987 · S/N 49557 N861NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 31109 N862AVAircol 23 · Wilmington, DEBuilt 2011 · S/N 4862 N862NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 30905 N863NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 30903 N864NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 31111 N86534United Airlines Inc · Chicago, ILBuilt 2016 · S/N 62750 N86584Aero Specialists Inc · Eloy, AZBuilt 1942 · S/N 4935 N865FSkybus Jet Cargo Inc · Las Vegas, NVBuilt 1969 · S/N 46088 N865NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 29554 N866NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 40584 N867NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 40762 N868NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 40763 N869NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 40764 N8704Yankee Air Force Inc · Belleville, MIBuilt 1944 · S/N 33048 N870NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 40765 N8713MSouthwest Airlines Co · Dallas, TXBuilt 2017 · S/N 36984 N871NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 31127 N872NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 33219 N872SJHeavylift Cargo Airlines Inc · Kingman, AZS/N 46067 N873NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 40766 N874AAAntares Aviation LLC · Boca Raton, FLBuilt 1978 · S/N 21386 N874NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 31129 N874TWUnited States Government · Washington, DCBuilt 1989 · S/N 24524 N87507United Airlines Inc · Chicago, ILBuilt 2008 · S/N 31637 N87512United Airlines Inc · Chicago, ILBuilt 2008 · S/N 33458 N87513United Airlines Inc · Chicago, ILBuilt 2008 · S/N 31621 N87527United Airlines Inc · Chicago, ILBuilt 2010 · S/N 38701 N87531United Airlines Inc · Chicago, ILBuilt 2011 · S/N 39999 N875AMWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2014 · S/N 36705 N875NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 33220 N876NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 40767 N877MGPeters Gary · Clarkston, WABuilt 1949 · S/N 20806 N877NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 31131 N878NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 40768 N879NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 31133 N880NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 40769 N881NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 31135 N882NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 33221 N882TPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1945 · S/N 32644 N883GAFalcon Commercial Aviation LLC · Miami, FLBuilt 1988 · S/N 49710 N883NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31137 N884EATvpx Ars Inc Trustee · North Salt Lake, UTBuilt 1994 · S/N 387 N884NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 33222 N885NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31139 N886NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 33223

Back to AD 74-08-09 R2