Skip to content

Registered aircraft · 467

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

N1926EEmbry Riddle Aeronautical Univ Inc · Prescott, AZBuilt 2025 · S/N 42.N581 N195DASolstice Aviation LLC · Clemson, SCBuilt 2019 · S/N 40.NC035 N1962FFabair Inc · Wilmington, DEBuilt 2022 · S/N 40.NC186 N19TSPremier Aircraft Sales Inc · Fort Lauderdale, FLBuilt 2026 · S/N 42.N617 N1PPLevel One Trauma Pllc · Sherman, TXBuilt 2016 · S/N 42.N201 N202ZZRaccoon Air LLC · San Francisco, CABuilt 2023 · S/N 40.NC245 N2030BInternational Air Services Inc Trustee · Carson City, NVBuilt 2023 · S/N 40.N612 N212SADiamond Aircraft Sales U S A Inc · London OntarioBuilt 2026 · S/N 42.N623 N216DAVonaviation Group V N216da LLC · Lewes, DEBuilt 2021 · S/N 40.NC156 N218LAOriginblue LLC · Albuquerque, NMBuilt 2023 · S/N 40.NC248 N21UPSilverhawk Security Specialists Inc · Lincoln, NEBuilt 2021 · S/N 40.NC134 N224PABlack Throated Wind LLC · Saratoga Springs, NYBuilt 2024 · S/N 40.NC308 N225NGLift Aircraft LLC · Carmel, INBuilt 2018 · S/N 40.NC019 N227PSRudkin Joshua P · Loveland, COBuilt 2023 · S/N 40.NC247 N227SKAlf Ix LLC · Chicago, ILBuilt 2026 · S/N 42.N615 N230PASl Aviation LLC · Lakeville, MNBuilt 2023 · S/N 42.N516 N233AVWestwind School Of Aeronautics Phoenix LLC DBA · Goodyear, AZBuilt 2023 · S/N 42.N498 N234LACoastal Flight Instruction LLC · Lewes, DEBuilt 2023 · S/N 40.NC224 N234LMRegistered aircraftBuilt 2025 · S/N 42.N578 N237BLSkywarrior Flight Training LLC · Pensacola, FLBuilt 2022 · S/N 40.NC204 N238PSRegistered aircraftBuilt 2023 · S/N 40.NC249 N240BLSkywarrior Flight Training LLC · Pensacola, FLBuilt 2021 · S/N 40.NC163 N241BLSkywarrior Flight Training LLC · Pensacola, FLBuilt 2022 · S/N 40.NC201 N242BLTake Flight Aviation LLC · Montgomery, NYBuilt 2021 · S/N 42.N437 N243ASSkyline Aviation Inc · San Angelo, TXBuilt 2023 · S/N 40.NC256 N243BLTake Flight Aviation LLC · Montgomery, NYBuilt 2023 · S/N 40.NC221 N244BLTake Flight Aviation LLC · Montgomery, NYBuilt 2023 · S/N 40.NC222 N245BLSteel Aviation Inc · Phillipsburg, OHBuilt 2021 · S/N 40.NC159 N245LAWaypoint Da40ng LLC · Boise, IDBuilt 2022 · S/N 40.NC215 N246CFArq Aviation LLC · Wilmington, NCBuilt 2014 · S/N 42.N151 N246PDBgr Aviation LLC · Greenwood, SCBuilt 2021 · S/N 40.NC142 N246SASjmoss Investments LLC · Katy, TXBuilt 2022 · S/N 40.NC183 N247DAGraves Aviation LLC · Houston, TXBuilt 2021 · S/N 40.NC160 N248BLSkywarrior Flight Training LLC · Pensacola, FLBuilt 2022 · S/N 40.NC207 N248PKStuart Karon · Newton, MABuilt 2021 · S/N 40.NC139 N251BLSkywarrior Flight Training LLC · Pensacola, FLBuilt 2021 · S/N 40.NC164 N251LASr Aviation Holdings LLC · Osceola, WIBuilt 2022 · S/N 40.NC191 N251PAFlight Stars Az LLC · Mesa, AZBuilt 2020 · S/N 40.NC103 N252DAHyer Da20 LLC · Dallas, TXBuilt 2020 · S/N 40.NC122 N254DADoma Air LLC · Charlotte, NCBuilt 2021 · S/N 40.NC144 N254SAGrow Aviation LLC · Lancaster, OHBuilt 2024 · S/N 40.NC325 N255DAWestern Sky Aviation LLC · Kirkland, WABuilt 2021 · S/N 40.NC145 N257LAAa Aviation LLC · Nashville, TNBuilt 2023 · S/N 42.N507 N259RGDiamond Aircraft Sales U S A Inc · London OntarioS/N 40.NC351 N25HSSkyline Aviation Inc · San Angelo, TXBuilt 2013 · S/N 42.N114 N261RGDiamond Aircraft Sales USA Inc · London OntarioS/N 40.NC352 N263DADiamond Aircraft Sales U S A Inc · London OntarioS/N 40.NC333 N265BLAspen Higher Learning Flight Academy Inc · Aspen, COBuilt 2024 · S/N 40.NC305 N265PSMyflight Five LLC · Lake Mary, FLBuilt 2025 · S/N 42.N605 N268LACatbird Management LLC · Raleigh, NCBuilt 2022 · S/N 40.NC178

Back to AD 2016-22-06