Skip to content

Registered aircraft · 774

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:2002-14-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:2002-14-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:2002-14-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:2002-14-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:2002-14-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:2002-14-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.

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 N873NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 40766 N874NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 31129 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 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 N883NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31137 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 N887NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31141 N889NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 33314 N890NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31143 N891NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 33315 N892NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31145 N893NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 33316 N894NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31147 N895NNWilmingtontrust Co Trustee · Wilmington, DEBuilt 2012 · S/N 31149 N896NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 33224 N897NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 33318 N898NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 33225 N899NNBank Of Utah Owner Trustee · Salt Lake City, UTBuilt 2012 · S/N 31151 N901ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29503 N901NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 33226 N902ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29504 N902NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31154 N903ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29505 N903NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 31153 N904ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29506 N904NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 33317 N905ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29507 N905NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31156 N906ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29508 N906NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 31155 N907ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29509 N907NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 31158 N908ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29510

Back to AD 2002-14-21