Registered aircraft · 201

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-26-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:2021-26-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:2021-26-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:2021-26-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:2021-26-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:2021-26-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.

N100JMatterhorn Aviation LLC · Arroyo Grande, CABuilt 2019 · S/N 123 N100TSPandion LLC · Ponte Vedra Beach, FLBuilt 2023 · S/N 320 N100YRCutter Swiss Aircraft LLC · Phoenix, AZS/N 626 N107PJPc-24 LLC · Park City, UTBuilt 2018 · S/N 107 N10MVLas Madronas Aviation LLC · Incline Village, NVBuilt 2020 · S/N 190 N114HAHoward Air LLC · Appleton, WIBuilt 2021 · S/N 212 N117VKFalcon Aircraft Leasing LLC · Phoenix, AZBuilt 2018 · S/N 117 N124FSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 101 N124WFWinco Foods LLC · Boise, IDBuilt 2025 · S/N 595 N126AFRigi Inc · Portsmouth, NHBuilt 2019 · S/N 126 N127UHU-Haul Business Consultants Inc · Phoenix, AZBuilt 2019 · S/N 127 N12AJLexa International Corp · New York, NYNon-citizen corporation, flight hours not reportedBuilt 2025 · S/N 561 N140SXCrc Aviation LLC · Reno, NVBuilt 2019 · S/N 140 N144TARegistered aircraftBuilt 2019 · S/N 144 N154AFRigi Inc · Portsmouth, NHBuilt 2019 · S/N 154 N158AFRigi Inc · Portsmouth, NHBuilt 2019 · S/N 158 N169MMPilatus Aircraft USA Ltd · Broomfield, COS/N 640 N169TTTtd Travel LLC · Terre Haute, INBuilt 2025 · S/N 585 N1718ARegistration Pending · North Salt Lake, UTRegistration pendingBuilt 2023 · S/N 319 N176MCBarnes Chris · Eagle, IDBuilt 2018 · S/N 109 N17HARegistered aircraftBuilt 2019 · S/N 129 N17PJYb Aviation LLC · Apex, NCBuilt 2024 · S/N 520 N1868CPilatus Aircraft USA Ltd · Broomfield, COBuilt 2026 · S/N 638 N18JRNorfolk Holdings Fl LLC · Prides Crossing, MAS/N 609 N192BLAir Bravo Lima II LLC · Morriston, FLBuilt 2023 · S/N 326 N194PJGuidry Aviation LLC · Breaux Bridge, LABuilt 2020 · S/N 194 N196AHCharlotte Mecklenburg Hospital Authority DBA · Charlotte, NCBuilt 2020 · S/N 196 N198XKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2020 · S/N 198 N201PEPc-Mcn LLC · Macon, GABuilt 2020 · S/N 168 N2024BWizteon Aviation LLC · Coeur D Alene, IDBuilt 2025 · S/N 553 N21KHLive Free And Fly Nh LLC · Portsmouth, NHBuilt 2025 · S/N 569 N220AFWashington International Aviation LLC · Rockville, MDBuilt 2025 · S/N 557 N220RSBergmantwo LLC · Vandalia, OHBuilt 2022 · S/N 260 N224CRChristopher Ranch LLC · Gilroy, CABuilt 2021 · S/N 239 N224DEOtter Air Services LLC · Grand Rapids, MIBuilt 2023 · S/N 313 N224FPThistle Air 24 LLC · Vienna, VABuilt 2021 · S/N 216 N224WACook Childrens Health Enterprises · Fort Worth, TXBuilt 2018 · S/N 102 N225AFSandell Scott D · Portsmouth, NHBuilt 2021 · S/N 225 N225DEOtter Air Services LLC · Grand Rapids, MIBuilt 2023 · S/N 334 N227VJPriority Air LLC · Little Rock, ARBuilt 2021 · S/N 227 N22PBGreat Basin Advisors LLC · Truckee, CABuilt 2021 · S/N 254 N231SVDirect Ventures Management LLC · Knoxville, TNBuilt 2021 · S/N 231 N233SVVref LLC · Clinton, TNBuilt 2020 · S/N 192 N23NLN&L Capital Holdings LLC · Newark, DEBuilt 2023 · S/N 312 N240FTPilatus Aircraft USA Ltd · Broomfield, COS/N 633 N240JJHg Air 1 LLC · Effingham, ILBuilt 2019 · S/N 150 N240MWArchangel Air LLC · Vienna, OHBuilt 2018 · S/N 122 N240WCWilson Construction Co · Canby, ORBuilt 2022 · S/N 273 N242GBBank Of Utah Trustee · Salt Lake City, UTBuilt 2025 · S/N 579 N242PCShotgun Ranch Aviation LLC · Post, ORBuilt 2023 · S/N 336

Back to AD 2021-26-21