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.

N479WPSnow Hill Aviation LLC · Baroda, MIBuilt 2022 · S/N 40.NC175 N484MFPeregrine Howard Aeroflight Owner LLC · New Orleans, LAS/N 40.NC369 N487SAInvestment Properties Expeditions LLC · Rockville, MDBuilt 2021 · S/N 40.NC147 N488SAWild Blue Yonder LLC · South Bend, INBuilt 2021 · S/N 40.NC157 N499BWGallagher Homes LLC · Chapel Hill, NCBuilt 2018 · S/N 40.NC020 N505WSDhsr Transport LLC · Millburn, NJBuilt 2022 · S/N 40.NC193 N512BLSteel Aviation Inc · Phillipsburg, OHBuilt 2022 · S/N 40.NC192 N514BLSkywwarrior Flight Training LLC · Pensacola, FLBuilt 2022 · S/N 40.NC213 N514LAWhiskey Tango Aviation LLC · Hampstead, NCBuilt 2020 · S/N 40.NC114 N515GGHess Ronald · Monte Sereno, CABuilt 2019 · S/N 40.NC068 N515NGLift Aircraft LLC · Carmel, INBuilt 2018 · S/N 40.NC022 N517BLSkywarrior Flight Training LLC · Pensacola, FLBuilt 2002 · S/N 40.NC197 N518BLSkywarrior Flight Training LLC · Pensacola, FLBuilt 2023 · S/N 40.NC216 N518LABaydog Aviation LLC · Annapolis, MDBuilt 2021 · S/N 40.NC131 N519LAVyzerion LLC · Potomoc Falls, VABuilt 2020 · S/N 40.NC119 N523BLSkywarrior Flight Training LLC · Pensacola, FLBuilt 2023 · S/N 40.NC217 N523LAFlight Stars Az LLC · Tempe, AZBuilt 2024 · S/N 40.NC323 N524LATrois Fils Aviation LLC · Lexington, KYBuilt 2024 · S/N 40.NC324 N528PATas Aircraft Sales LLC · Troutdale, ORBuilt 2024 · S/N 40.NC321 N529LAKutter 706 LLC · Kingman, AZBuilt 2023 · S/N 40.NC290 N531HJN531hj LLC · Akron, OHBuilt 2021 · S/N 40.NC136 N532LLift Aircraft LLC · Carmel, INBuilt 2023 · S/N 40.NC274 N533LLift Aircraft LLC · Carmel, INBuilt 2024 · S/N 40.NC337 N533LAClearsky Aviation LLC · Hartford, CTBuilt 2024 · S/N 40.NC303 N538SASr20 Holdings LLC · Saint Louis, MOBuilt 2022 · S/N 40.NC198 N540RALady In Blue LLC · Inola, OKBuilt 2018 · S/N 40.NC027 N541SABinarie Leasing LLC · Greenwood, INBuilt 2024 · S/N 40.NC299 N548LAFeldman Timothy S · Loveland, COBuilt 2022 · S/N 40.NC199 N552PADelta Foxtrot LLC · Oviedo, FLBuilt 2024 · S/N 40.NC322 N566RGDiamond Aircraft Sales U S A Inc · London OntarioS/N 40.NC354 N567RGRockhill Group Inc · Molino, FLS/N 40.NC355 N568SAClampitt Harold · Hampshire, ILBuilt 2023 · S/N 40.NC236 N578LAShqiponjat LLC · Folly Beach, SCBuilt 2024 · S/N 40.NC318 N579RGDiamond Aircraft Sales U S A Inc · London OntarioS/N 40.NC356 N580RGRockhill Group Inc · Molino, FLBuilt 2025 · S/N 40.NC357 N582RGRockhill Group Inc · Molino, FLS/N 40.NC358 N585MFPeregrine Howard Aeroflight Owner LLC · New Orleans, LAS/N 40.NC370 N587SAEagle 5 LLC · Madison, WIBuilt 2023 · S/N 40.NC278 N602RFRva Flyboys LLC · Glen Allen, VABuilt 2021 · S/N 40.NC143 N603NGDouble Anchor Aviation LLC · Studio City, CABuilt 2024 · S/N 40.NC344 N614DFN14vb LLC · Bradenton, FLBuilt 2022 · S/N 40.NC218 N623PSNnk Holdings LLC · San Antonio, TXBuilt 2024 · S/N 40.NC291 N624PSSpruills Aviation LLC · Mount Pleasant, SCBuilt 2024 · S/N 40.NC300 N627PSSymphony Of Sora LLC · Albany, NYBuilt 2023 · S/N 40.NC257 N637PAAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 2023 · S/N 40.NC233 N640EZShavit Chuck · Lexington, MABuilt 2022 · S/N 40.NC187 N642DZAkapella Aviation LLC · Chapel Hill, NCBuilt 2023 · S/N 40.NC283 N644LABlackburn Matthew · Charleston, SCBuilt 2023 · S/N 40.NC228 N650LAVonaviation Group I 650la LLC · Lewes, DEBuilt 2022 · S/N 40.NC210 N656LLift Aircraft LLC · Carmel, INBuilt 2019 · S/N 40.NC058

Back to AD 2013-08-21