Skip to content

Registered aircraft · 100

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

N784HAHawaiian Airlines Inc · Seattle, WABuilt 2025 · S/N 66432 N806AAAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 40624 N820ALAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 40639 N821ANAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 40640 N823ANAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 40641 N824ANAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 40643 N825AAAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 40644 N826ANAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 40649 N827ANAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 40647 N828AAAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 40648 N829ANAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 40651 N830ANAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 40650 N831AAAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 40652 N832AAAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 40638 N833AAAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 40645 N835ANWilmington Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 40655 N836AAWilmington Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 40654 N837ANWilmington Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 40658 N838AAWilmington Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 40659 N839AAWilmington Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 40646 N840ANAmerican Airlines Inc · Fort Worth, TXBuilt 2019 · S/N 40656 N841ANAmerican Airlines Inc · Fort Worth, TXBuilt 2019 · S/N 40657 N842AAWilmington Trust Company Trustee · Wilmington, DEBuilt 2025 · S/N 66007 N843ANWilmington Trust Co Owner Trustee · Wilmington, DEBuilt 2025 · S/N 66008 N844MCWilmington Trust Company Trustee · Wilmington, DEBuilt 2025 · S/N 66009 N845MDWilmington Trust Co Trustee · Wilmington, DEBuilt 2025 · S/N 66010 N846ANWilmington Trust Co Trustee · Wilmington, DEBuilt 2025 · S/N 66011 N847MFAmerican Airlines Inc · Fort Worth, TXBuilt 2025 · S/N 66012 N848ANAmerican Airlines Inc · Fort Worth, TXBuilt 2025 · S/N 66013 N850ANAmerican Airlines Inc · Fort Worth, TXBuilt 2025 · S/N 66019 N850GTAtlas Air Inc · Purchase, NYBuilt 2012 · S/N 37570 N851GTAtlas Air Inc · Purchase, NYBuilt 2012 · S/N 37565 N851MKAmerican Airlines Inc · Fort Worth, TXBuilt 2025 · S/N 66020 N852GTAtlas Air Inc · Purchase, NYBuilt 2012 · S/N 37571 N852MLAmerican Airlines Inc · Fort Worth, TXBuilt 2025 · S/N 66021 N853GTAtlas Air Inc · Purchase, NYBuilt 2012 · S/N 37572 N854GTAtlas Air Inc · Purchase, NYBuilt 2013 · S/N 37566 N855GTAtlas Air Inc · Purchase, NYBuilt 2013 · S/N 37567 N856GTWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 37561 N857GTAtlas Air Inc · Purchase, NYBuilt 2011 · S/N 37568 N858GTWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 37569 N859GTAtlas Air Inc · Purchase, NYBuilt 2015 · S/N 62441 N864GTUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 60117 N865GTUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 60118 N868GTUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 60119 N894BAUnited States Air Force · Wpafb, OHBuilt 2016 · S/N 42416 N895BAUnited States Air Force · Wpafb, OHBuilt 2016 · S/N 42417 N947BABank Of Utah Trustee · Salt Lake City, UTS/N 35507 N964AMWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 35307 N965AMWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 35308

Back to AD 2012-19-08