Skip to content

Registered aircraft · 2,000

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

N105JSBank Of Utah Trustee · Salt Lake City, UTBuilt 2021 · S/N 43709 N109JSBank Of Utah Trustee · Salt Lake City, UTBuilt 2021 · S/N 43712 N110JSBank Of Utah Trustee · Salt Lake City, UTBuilt 2021 · S/N 43755 N11206United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30578 N115AMAlc B379 122019 LLC · Camden, DEBuilt 2021 · S/N 43371 N12216United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28776 N12218United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28778 N12221United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28930 N12225United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28934 N12238United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28804 N13227United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28788 N13248Umb Bank Na Trustee · Salt Lake City, UTBuilt 1999 · S/N 28808 N14214United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28774 N14219United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28781 N14228United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28792 N14230United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28794 N14231United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28795 N14235United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28947 N14237United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28802 N14240United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28952 N14242United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28805 N14249United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28809 N14250United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28957 N154TSFalcon Aviation Holdings LLC · Hawthorne, CABuilt 2002 · S/N 30515 N16217United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28777 N16234United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28946 N17229Umb Bank Na Trustee · Salt Lake City, UTBuilt 1999 · S/N 28793 N17233United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28943 N17244United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28954 N17245United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28955 N17254Wilmington Trust Co Trustee · Wilmington, DEBuilt 2021 · S/N 43436 N17262Wilmington Trust Co Trustee · Wilmington, DEBuilt 2021 · S/N 66594 N17264Wilmington Trust Co Trustee · Wilmington, DEBuilt 2021 · S/N 66596 N17265Wilmington Trust Co Trustee · Wilmington, DEBuilt 2021 · S/N 64454 N17272United Airlines Inc · Chicago, ILBuilt 2022 · S/N 67527 N17279United Airlines Inc · Chicago, ILBuilt 2022 · S/N 64613 N17285United Airlines Inc · Chicago, ILBuilt 2022 · S/N 61853 N17289United Airlines Inc · Chicago, ILBuilt 2023 · S/N 60712 N17294United Airlines Inc · Chicago, ILBuilt 2023 · S/N 67551 N17296Umb Bank Na Trustee · Salt Lake City, UTBuilt 2023 · S/N 67556 N17300Umb Bank Na Trustee · Salt Lake City, UTBuilt 2023 · S/N 43466 N17301Umb Bank Na Trustee · Salt Lake City, UTBuilt 2023 · S/N 67554 N17302Umb Bank Na Trustee · Salt Lake City, UTBuilt 2023 · S/N 67559 N17303Umb Bank Na Trustee · Salt Lake City, UTBuilt 2023 · S/N 67561 N17306Umb Bank Na Trustee · Salt Lake City, UTBuilt 2023 · S/N 67565 N17309Umb Bank Na Trustee · Salt Lake City, UTBuilt 2023 · S/N 67563 N17310Wilmington Trust Co Trustee · Wilmington, DEBuilt 2023 · S/N 67566 N17311Umb Bank Na Trustee · Salt Lake City, UTBuilt 2023 · S/N 67567 N17312United Airlines Inc · Chicago, ILBuilt 2019 · S/N 64609 N17314Wilmington Trust Co Trustee · Wilmington, DEBuilt 2023 · S/N 67569

Back to AD 2021-16-15