Skip to content

Registered aircraft · 315

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:2013-08-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:2013-08-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:2013-08-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:2013-08-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:2013-08-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:2013-08-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.

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 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 N259RGDiamond Aircraft Sales U S A Inc · London OntarioS/N 40.NC351 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 N268LACatbird Management LLC · Raleigh, NCBuilt 2022 · S/N 40.NC178 N268PALone Star Diamond Aerospace Inc · Rockwall, TXBuilt 2024 · S/N 40.NC298 N269PAMcdonough Scott · Longboat Key, FLBuilt 2024 · S/N 40.NC310 N269PSHarvey Specter Investments LLC · Marble Falls, TXBuilt 2025 · S/N 40.NC363 N271CKSkipi Arres LLC · Lakewood, COBuilt 2022 · S/N 40.NC189 N273LATake Flight Aviation LLC · Montgomery, NYBuilt 2023 · S/N 40.NC271 N274LABell Aviation LLC · Virginia Beach, VABuilt 2022 · S/N 40.NC174 N275SBAntelope Aircraft LLC · New Orleans, LABuilt 2021 · S/N 40.NC137 N276BLAspen Higher Learning Flight Academy Inc · Aspen, COBuilt 2024 · S/N 40.NC306 N27CDGeneral Service Co Inc · Goldsboro, NCBuilt 2020 · S/N 40.NC118 N297LAAdam Errington LLC · Vero Beach, FLBuilt 2020 · S/N 40.NC101 N29MTVoyager29 Inc Trustee · Wilmington, DEBuilt 2022 · S/N 40.NC185 N301MJEchowhiskey LLC · Troutman, NCBuilt 2023 · S/N 40.NC229 N310TFTitan Enoch LLC · Amarillo, TXBuilt 2022 · S/N 40.NC209 N311AFAspen Higher Learning Flight Academy Inc · Aspen, COBuilt 2025 · S/N 40.NC365 N312JAb Air LLC · Medley, FLBuilt 2022 · S/N 40.NC170 N314KYElkhorn Creek Aviation LLC · Georgetown, KYBuilt 2022 · S/N 40.NC168 N315PSMiller Drew · Gustine, TXBuilt 2024 · S/N 40.NC295 N316LLift Aircraft LLC · Carmel, INBuilt 2023 · S/N 40.NC281 N316PSSkyline Aviation Inc · San Angelo, TXBuilt 2024 · S/N 40.NC327 N317PSDreams Take Flight LLC · Orlando, FLBuilt 2023 · S/N 40.NC270 N318PSWalton Warren A · Kitty Hawk, NCBuilt 2024 · S/N 40.NC328 N320WBWasp Creek Holdings LLC · Austin, TXBuilt 2020 · S/N 40.N520 N322PSRockhill Group Inc · Molino, FLBuilt 2025 · S/N 40.NC359 N324PSDial-Up Media LLC · Ladera Ranch, CAS/N 40.NC364 N327PSRockhill Group Inc · Molino, FLBuilt 2025 · S/N 40.NC360 N328WBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2020 · S/N 40.N522 N332AFAspen Higher Learning Flight Academy Inc · Aspen, COBuilt 2025 · S/N 40.NC366 N334PAArapahoe 1880 LLC · Orlando, FLBuilt 2024 · S/N 40.NC297 N334WBTdt Marketing LLC · Queen Creek, AZBuilt 2021 · S/N 40.N523

Back to AD 2013-08-21