Skip to content

Registered aircraft · 1,131

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

N872DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 31983 N872NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 33219 N873DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 31984 N873NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 40766 N874DNDelta Air Lines Inc · Atlanta, GABuilt 2017 · S/N 31985 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 N875DNDelta Air Lines Inc · Atlanta, GABuilt 2017 · S/N 31986 N875NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 33220 N876DNDelta Air Lines Inc · Atlanta, GAFirst renewal noticeS/N 31987 N876NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 40767 N877DNDelta Air Lines Inc · Atlanta, GAFirst renewal noticeBuilt 2017 · S/N 31988 N877NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 31131 N878DNDelta Air Lines Inc · Atlanta, GABuilt 2017 · S/N 31989 N878NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 40768 N879DNDelta Air Lines Inc · Atlanta, GABuilt 2017 · S/N 31990 N879NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 31133 N880DNDelta Air Lines Inc · Atlanta, GABuilt 2017 · S/N 31991 N880NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 40769 N881DNDelta Air Lines Inc · Atlanta, GABuilt 2017 · S/N 31992 N881NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 31135 N882DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 31994 N882NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 33221 N883DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 31993 N883NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31137 N884DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 31995 N884NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 33222 N885DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 31996 N885NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31139 N886DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 31998 N886NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 33223 N887DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 31997 N887NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31141 N888DUDelta Air Lines Inc · Atlanta, GABuilt 2017 · S/N 31999 N889DNDelta Air Lines Inc · Atlanta, GABuilt 2017 · S/N 62774 N889NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 33314 N890DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 62775 N890NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31143 N891DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 32001 N891NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 33315 N892DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 32000 N892NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31145 N893DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 32002 N893NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 33316 N894DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 62776

Back to AD 2016-22-13