Registered aircraft · 46

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-03-19') 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-03-19') 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-03-19')
    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-03-19')
  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-03-19')
  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-03-19')
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.

N121RSWilmington Trust Co Trustee · Wilmington, DEBuilt 2020 · S/N 70042 N1711MBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 70024 N176QSRegistered aircraftBuilt 2021 · S/N 70096 N177QSRegistered aircraftBuilt 2021 · S/N 70106 N178QSRegistered aircraftBuilt 2022 · S/N 70116 N179QSRegistered aircraftBuilt 2022 · S/N 70137 N17JSJs Ventures 17 Corp · West Palm Beach, FLBuilt 2024 · S/N 70184 N180QSRegistered aircraftBuilt 2023 · S/N 70140 N181QSRegistered aircraftBuilt 2023 · S/N 70154 N182QSRegistered aircraftBuilt 2023 · S/N 70160 N183QSRegistered aircraftBuilt 2023 · S/N 70162 N184QSRegistered aircraftBuilt 2023 · S/N 70163 N185QSRegistered aircraftBuilt 2024 · S/N 70183 N1FNBank Of Utah Trustee · Salt Lake City, UTBuilt 2020 · S/N 70055 N203JECsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2019 · S/N 70007 N235DXEws V LLC · Coraopolis, PABuilt 2023 · S/N 70151 N2777RTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2020 · S/N 70050 N302AGWilmington Trust Company Trustee · Wilmington, DEBuilt 2023 · S/N 70173 N369WWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2021 · S/N 70103 N393BXIac Falcon Holdings III LLC · New York, NYBuilt 2021 · S/N 70081 N40WRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2024 · S/N 70180 N48ENWilmington Trust Co Trustee · Wilmington, DEBuilt 2020 · S/N 70060 N512GLRtw Goco LLC · New York, NYBuilt 2021 · S/N 70077 N520EMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2021 · S/N 70104 N577KQTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2020 · S/N 70071 N580KCRegistered aircraftBuilt 2019 · S/N 70010 N62LVAmb Group LLC · Atlanta, GABuilt 2020 · S/N 70044 N646AKBank Of Utah Trustee · Salt Lake City, UTBuilt 2020 · S/N 70039 N6LBN6lb LLC · Dover, DEBuilt 2018 · S/N 70006 N70EWEwa Holdings LLC · Teterboro, NJBuilt 2019 · S/N 70012 N71100Wilmington Trust Co Trustee · Wilmington, DEBuilt 2019 · S/N 70011 N729KFKw Flight LLC · Bozeman, MTBuilt 2019 · S/N 70029 N729VSRegistered aircraftBuilt 2019 · S/N 70028 N750PBGlobal Support LLC · Salt Lake City, UTBuilt 2023 · S/N 70150 N752AVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2019 · S/N 70016 N755AJCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2022 · S/N 70114 N807LATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2020 · S/N 70065 N810KJRise & Shine Air LLC · Wilmington, DEBuilt 2019 · S/N 70015 N818BAAc Logistics LLC · Salt Lake City, UTBuilt 2020 · S/N 70018 N885AQAcg 6000 LLC · New York, NYBuilt 2020 · S/N 70008 N888GXBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 70036 N919FGN919fg LLC · Urbana, ILBuilt 2019 · S/N 70025 N955JSMjmm Ventures LLC · Las Vegas, NVBuilt 2022 · S/N 70121 N97DQDuquesne Global LLC · New York, NYBuilt 2020 · S/N 70051 N980GGMaple Seven LLC · New York, NYBuilt 2022 · S/N 70130 N998RTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2020 · S/N 70019

Back to AD 2022-03-19