Skip to content

Registered aircraft · 3,203

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

N100VEEpcvip Air LLC · Wilmington, DEBuilt 2012 · S/N 8113 N101CNCorporate Flight Management Inc DBA · Smyrna, TNBuilt 2022 · S/N 7625 N101DUBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 50020 N102DUBank Of Utah Trustee · Salt Lake City, UTS/N 50021 N103DUDelta Air Lines Inc · Atlanta, GAS/N 50022 N104DUDelta Air Lines Inc · Atlanta, GAS/N 50023 N105DUBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 50024 N105JSBank Of Utah Trustee · Salt Lake City, UTBuilt 2021 · S/N 43709 N106DUBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 50025 N107DUBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 50026 N108DQBank Of Utah Trustee · Salt Lake City, UTS/N 50027 N109DUBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 50028 N109JSBank Of Utah Trustee · Salt Lake City, UTBuilt 2021 · S/N 43712 N110DUBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 50029 N110JSBank Of Utah Trustee · Salt Lake City, UTBuilt 2021 · S/N 43755 N111NGBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 50030 N11206United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30578 N112DUBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 50031 N112VLBank Of Utah Trustee · Salt Lake City, UTS/N 8011 N113DQBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 50032 N114DUBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 50033 N115AMAlc B379 122019 LLC · Camden, DEBuilt 2021 · S/N 43371 N115DUBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 50034 N116DUDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 50035 N117DUBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 50036 N118DUBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 50037 N119DUBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 50038 N120DUBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 50039 N121DUBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 50040 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 N122DUBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 50041 N123DQBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 50042 N124DUBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 50043 N125DUBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 50044 N126DUBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 50045 N127DUBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 50046 N128DUBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 50047 N129DUDelta Air Lines Inc · Atlanta, GAS/N 50048 N130DUDelta Air Lines Inc · Atlanta, GABuilt 2020 · S/N 50049 N131DUDelta Air Lines Inc · Atlanta, GABuilt 2020 · S/N 50050 N13227United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28788 N13248Umb Bank Na Trustee · Salt Lake City, UTBuilt 1999 · S/N 28808 N132DUDelta Air Lines Inc · Atlanta, GABuilt 2020 · S/N 50051 N133DUDelta Air Lines Inc · Atlanta, GABuilt 2020 · S/N 50052 N134DUDelta Air Lines Inc · Atlanta, GABuilt 2020 · S/N 50053 N135DQDelta Air Lines Inc · Atlanta, GABuilt 2020 · S/N 50054

Back to AD 2020-21-02