Skip to content

Registered aircraft · 231

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

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 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 N110DUBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 50029 N111NGBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 50030 N112DUBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 50031 N113DQBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 50032 N114DUBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 50033 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 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 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 N136DQDelta Air Lines Inc · Atlanta, GABuilt 2020 · S/N 50055 N137DUDelta Air Lines Inc · Atlanta, GABuilt 2020 · S/N 50056 N138DUDelta Air Lines Inc · Atlanta, GABuilt 2020 · S/N 50057 N139DUDelta Air Lines Inc · Atlanta, GAS/N 50058 N140DUDelta Air Lines Inc · Atlanta, GAS/N 50059 N141DUDelta Air Lines Inc · Atlanta, GAS/N 50061 N142DUDelta Air Lines Inc · Atlanta, GABuilt 2022 · S/N 50060 N143DUDelta Air Lines Inc · Atlanta, GABuilt 2022 · S/N 50063 N144DUDelta Air Lines Inc · Atlanta, GABuilt 2022 · S/N 50064 N145DQDelta Air Lines Inc · Atlanta, GABuilt 2022 · S/N 50065 N175BZWilmington Trust Co Trustee · Wilmington, DEBuilt 2019 · S/N 55058 N176BZWilmington Trust Co Trustee · Wilmington, DEBuilt 2019 · S/N 55060 N178BZWilmington Trust Co Trustee · Wilmington, DEBuilt 2019 · S/N 55062 N179BZWilmington Trust Company Trustee · Wilmington, DEBuilt 2019 · S/N 55063 N181BZWilmington Trust Co Trustee · Wilmington, DEBuilt 2020 · S/N 55074

Back to AD 2022-11-21