Skip to content

Registered aircraft · 152

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-06-02') 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-06-02') 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-06-02')
    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-06-02')
  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-06-02')
  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-06-02')
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 N126NGFjr Consulting Inc · Reno, NVBuilt 2015 · S/N 42.N186 N135DAStella Gem LLC · Belmont, CAS/N 42.N435 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 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 N181CWDiamond 42 N123 Magic Carpet Inc Trustee · Wilmington, DEBuilt 2014 · S/N 42 N123 N1836TAndromeda Air LLC · Houston, TXBuilt 2014 · S/N 42.N159 N190TMN190tm Inc Trustee · Wilmington, DES/N 42.N407 N1926EEmbry Riddle Aeronautical Univ Inc · Prescott, AZBuilt 2025 · S/N 42.N581 N19TSPremier Aircraft Sales Inc · Fort Lauderdale, FLBuilt 2026 · S/N 42.N617 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 N242BLTake Flight Aviation LLC · Montgomery, NYBuilt 2021 · S/N 42.N437 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 N26ZTHuang Zitai · Frisco, TXBuilt 2021 · S/N 42.N427 N272MBYankee Lima One LLC · Bolingbrook, ILBuilt 2008 · S/N 42.AC117 N294DMMarkquart Air LLC · Chippewa Falls, WIS/N 42.N413 N295RAFlight Stars LLC · Prescott, AZBuilt 2016 · S/N 42.N215 N296SKAlf Ix LLC · Chicago, ILBuilt 2025 · S/N 42.N609 N302EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2023 · S/N 42.N527 N303ERDiamond Aircraft Sales U S A Inc · London OntarioS/N 42.N625 N303SWSkywarrior Flight Training LLC · Pensacola, FLBuilt 2016 · S/N 42.N202 N304ERDiamond Aircraft Sales U S A Inc · London OntarioS/N 42.N626 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

Back to AD 2013-06-02