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.

N894NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31147 N895DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 32003 N895NNWilmingtontrust Co Trustee · Wilmington, DEBuilt 2012 · S/N 31149 N896DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 62777 N896NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 33224 N897DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 32004 N897NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 33318 N898DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 62778 N898NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 33225 N899DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 32005 N899NNBank Of Utah Owner Trustee · Salt Lake City, UTBuilt 2012 · S/N 31151 N900DUDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 62779 N901ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29503 N901DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 32006 N901NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 33226 N902ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29504 N902DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 62780 N902NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31154 N903ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29505 N903DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 32007 N903NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 31153 N904ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29506 N904DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 32008 N904NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 33317 N905ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29507 N905DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 32009 N905NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31156 N906ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29508 N906DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 64879 N906NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 31155 N907ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29509 N907DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 32010 N907NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 31158 N908ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29510 N908DNDelta Air Lines Inc · Atlanta, GAS/N 64881 N908NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31157 N909ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29511 N909DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 64880 N909NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31159 N910ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29512 N910DUDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 32011 N910NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 31160 N911DQDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 64882 N912ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29513 N912DUDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 64883 N912NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 33319 N913ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29514 N913DUDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 62781 N913NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 29571 N914ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29515

Back to AD 2016-22-13