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.

N856DNDelta Air Lines Inc · Atlanta, GABuilt 2016 · S/N 31967 N856NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 31107 N8570WSouthwest Airlines Co · Dallas, TXBuilt 2018 · S/N 36952 N8571ZSouthwest Airlines Co · Dallas, TXBuilt 2018 · S/N 36957 N8572XSouthwest Airlines Co · Dallas, TXBuilt 2018 · S/N 64251 N8573ZSouthwest Airlines Co · Dallas, TXBuilt 2018 · S/N 64250 N8574ZBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 63588 N8575ZSouthwest Airlines Co · Dallas, TXBuilt 2018 · S/N 63589 N8576ZBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 63590 N8577ZBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 64350 N8578QBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 64349 N8579ZBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 63591 N857DZDelta Air Lines Inc · Atlanta, GABuilt 2016 · S/N 31968 N857NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 30907 N8580ZBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 64347 N8581ZBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 64348 N8582ZBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 64801 N8583ZBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 64799 N8584ZBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 64800 N858DZBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 31969 N858NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 30904 N859AMUmb Bank Na Trustee · Salt Lake City, UTBuilt 2003 · S/N 32796 N859DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 31970 N859NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 29555 N860DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 31971 N860NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 40583 N861DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2016 · S/N 31973 N861NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 31109 N862DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 31972 N862NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 30905 N863DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2016 · S/N 31975 N863NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 30903 N864DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2016 · S/N 31974 N864NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 31111 N86534United Airlines Inc · Chicago, ILBuilt 2016 · S/N 62750 N865DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2016 · S/N 31976 N865NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 29554 N866DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2016 · S/N 31977 N866NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 40584 N867DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2016 · S/N 31979 N867NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 40762 N868DNDelta Air Lines Inc · Atlanta, GABuilt 2016 · S/N 31978 N868NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 40763 N869DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2016 · S/N 31980 N869NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 40764 N870DNDelta Air Lines Inc · Atlanta, GABuilt 2017 · S/N 31981 N870NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 40765 N8713MSouthwest Airlines Co · Dallas, TXBuilt 2017 · S/N 36984 N871DNUmb Bank Na Trustee · Salt Lake City, UTS/N 31982 N871NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 31127

Back to AD 2016-22-13