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.

N914DUDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 62782 N914NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 31161 N915ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29516 N915DUDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 62783 N915NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 33227 N916ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29517 N916DUDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 64884 N916NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 31163 N917ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29518 N917DUDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 63530 N917NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 29572 N918ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29519 N918DUDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 64885 N918NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 33228 N919ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29520 N919DUDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 63531 N919NNBank Of Utah Owner Trustee · Salt Lake City, UTBuilt 2013 · S/N 29573 N919RATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 30174 N920ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29521 N920DUBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 63533 N920NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 31165 N921ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29522 N921DUBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 63532 N921NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 33229 N922ANAmerican Airlines Inc · Forth Worth, TXBuilt 1999 · S/N 29523 N922DZBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 64886 N922NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 29574 N923ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29524 N923DZDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 64887 N923NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 31167 N924ANWilmington Trust Co Trustee · Wilmington, DEBuilt 1999 · S/N 29525 N924DZBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 63536 N924NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 33486 N925ANWilmington Trust Co Trustee · Wilmington, DEBuilt 1999 · S/N 29526 N925DZBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 63535 N925NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 31169 N926ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29527 N926DZBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 63534 N926NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 33321 N927ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30077 N927DZBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 64888 N927NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 31171 N928ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29528 N928DUBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 63537 N928NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 31172 N929ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30078 N929DZBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 63538 N929NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 33322 N930ANAmerican Airlines Inc · Ft. Worth, TXBuilt 2000 · S/N 29529 N930DZBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 63539

Back to AD 2016-22-13