Skip to content

Registered aircraft · 134

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

N101SWSkywarrior Flight Training LLC · Pensacola, FLBuilt 2016 · S/N 42.N214 N107NGMccarren Aviation LLC · Green Bay, WIBuilt 2015 · S/N 42.N171 N108NGRockhill Aerospace Inc · Molino, FLBuilt 2015 · S/N 42.N172 N112NGWestern United Aviation LLC · Yacolt, WAS/N 42.N192 N116NGCarolina Garuda Services LLC · Wilson, NCBuilt 2011 · S/N 40.N016 N119APParker Stephen H · Marfa, TXBuilt 2011 · S/N 31031 N125NGNovember Golf LLC · Provo, UTBuilt 2015 · S/N 40.N261 N126NGFjr Consulting Inc · Reno, NVBuilt 2015 · S/N 42.N186 N141DACinden LLC · Nashua, NHBuilt 2016 · S/N 42.N219 N142GSFort Wayne Aircraft LLC · Fort Wayne, INBuilt 2012 · S/N 42.NC003 N142NGFive Star Marketing Inc · Raleigh, NCBuilt 2006 · S/N 42.082 N143NGTiger Aggie Air LLC · Fredericksburg, TXBuilt 2013 · S/N 40.N143 N147TSTreacy Jonathan T · Oxford, MEBuilt 2006 · S/N 42.AC007 N151MABridgewater State University · New Bedford, MABuilt 2005 · S/N 42.063 N153TSAirplane Holding LLC · Huntington Station, NYBuilt 2006 · S/N 42.118 N168PFJetnexa Eleven LLC · Gilbert, AZBuilt 2022 · S/N 42.N500 N176TSOld Glory Inc · Tulsa, OKBuilt 2006 · S/N 42.176 N181CWDiamond 42 N123 Magic Carpet Inc Trustee · Wilmington, DEBuilt 2014 · S/N 42 N123 N1836TAndromeda Air LLC · Houston, TXBuilt 2014 · S/N 42.N159 N1926EEmbry Riddle Aeronautical Univ Inc · Prescott, AZBuilt 2025 · S/N 42.N581 N1PPLevel One Trauma Pllc · Sherman, TXBuilt 2016 · S/N 42.N201 N212SADiamond Aircraft Sales U S A Inc · London OntarioBuilt 2026 · S/N 42.N623 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 N234LMRegistered aircraftBuilt 2025 · S/N 42.N578 N236TSFisher Curtis R · Mankato, MNBuilt 2006 · S/N 42.AC022 N246CFArq Aviation LLC · Wilmington, NCBuilt 2014 · S/N 42.N151 N257LARegistration Pending · Nashville, TNRegistration pendingBuilt 2023 · S/N 42.N507 N25HSSkyline Aviation Inc · San Angelo, TXBuilt 2013 · S/N 42.N114 N265PSMyflight Five LLC · Lake Mary, FLBuilt 2025 · S/N 42.N605 N272MBYankee Lima One LLC · Bolingbrook, ILBuilt 2008 · S/N 42.AC117 N27SJ0x1b LLC · Brooklyn, NYBuilt 2006 · S/N 42.AC014 N296SKAlf Ix LLC · Chicago, ILBuilt 2025 · S/N 42.N609 N302EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2023 · S/N 42.N527 N303SWSkywarrior Flight Training LLC · Pensacola, FLBuilt 2016 · S/N 42.N202 N304SWSkywarrior Flight Training LLC · Pensacola, FLBuilt 2016 · S/N 42.N203 N305EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2016 · S/N 42.N205 N306EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2016 · S/N 42.N206 N308EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2016 · S/N 42.N210 N309EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2016 · S/N 42.N211 N311EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2016 · S/N 42.N212 N311LHWingsleasing LLC · Wichita, KSBuilt 2005 · S/N 42.036 N312EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2016 · S/N 42.N213 N313EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2024 · S/N 42.N535 N314EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2024 · S/N 42.N536 N3150AOklahoma Aviation LLC · Bethany, OKS/N 42.N223 N315XAJetnexa Thirteen LLC · Gilbert, AZBuilt 2025 · S/N 42.N590 N318EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2024 · S/N 42.N539 N319EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2024 · S/N 42.N547

Back to AD 2014-08-10