Registered aircraft · 16,280

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

N438CDSquibb Daniel · Xenia, OHBuilt 2005 · S/N 1404 N438CRKilo Alpha 438 LLC · Edgewater, FLBuilt 1978 · S/N BB438 N438GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881178 N438PABird Acquisition LLC · Phoenix, AZS/N 4496083 N438PCJaml Aviation LLC · Happy Valley, ORBuilt 2010 · S/N 3625 N438RMRocky Mountain College · Billings, MTBuilt 2019 · S/N 2881095 N438SErie Aviation LLC · Salem, ORBuilt 1981 · S/N BB-886 N438SLGriffith Aviation Inc · Griffith, INBuilt 1979 · S/N 28-7916276 N438SR10sm Clr LLC · Oklahoma City, OKBuilt 2007 · S/N 2567 N4390SCandace A Larned Enterprises Inc · Long Beach, CABuilt 1985 · S/N 28-8516031 N4390WWurster Gregory J · Creston, IABuilt 1986 · S/N 32R-8629005 N4392XMountain View Aviation Inc · Honesdale, PABuilt 1975 · S/N 28-7690004 N43948Jl3 Aviation LLC · Blue Springs, NEBuilt 1977 · S/N 28-7890030 N43954Georgetown Aircraft Rental Inc · Granger, TXBuilt 1977 · S/N 28-7890032 N43956Freeflight Aviation LLC · Allentown, NJBuilt 1977 · S/N 28-7890033 N43957Ocbc Ventures Aviation LLC · Los Angeles, CABuilt 1977 · S/N 28-7890034 N43959Explore Gourmet LLC · Wyandanch, NYBuilt 1977 · S/N 28-7890035 N43983Bas Part Sales LLC · Greeley, COBuilt 1977 · S/N 28-7890038 N43984New England Flyers LLC · Franklin, MAS/N 28-7890039 N439CALima Delta Co Trustee · New Castle, DEBuilt 2008 · S/N 40.907 N439NKSt Louis Aircraft Partners LLC · Saint Louis, MOBuilt 2004 · S/N 0919 N439WAA W Peterson Inc · Warren, MNBuilt 1977 · S/N LW-216 N43CHMatus Richard J · Fort Worth, TXBuilt 1994 · S/N 4622176 N43CKV12 Promotions LLC · Orlando, FLBuilt 2022 · S/N 8742 N43DFParagon Flight Training Co · Fort Myers, FLBuilt 2024 · S/N 28020200 N43ESN43es LLC · Akron, OHBuilt 2025 · S/N 11098 N43GRN43gr LLC · Phoenix, AZS/N 1531 N43GTDon Avion LLC · Cedar Park, TXBuilt 1978 · S/N 441-0043 N43JMOsage Air LLC · Greenville, SCBuilt 2020 · S/N 2544 N43LCRoy Mark A · Sanger, TXBuilt 1976 · S/N 28-7790203 N43LDIrongate Aviation LLC · Raymond, NHBuilt 2021 · S/N 5093 N43LMHorton Scott · Yorba Linda, CABuilt 2009 · S/N 40.1047 N43PCOlsen Air LLC · Hendricks, MNBuilt 1977 · S/N LW-253 N43PFCollum Aviation LLC · Milton, FLBuilt 1979 · S/N 28-7916362 N43PSGround Speed Aviation LLC · Lewes, DEBuilt 2018 · S/N 2411 N43SEAir Zamunda LLC · Rutherford, NJBuilt 2003 · S/N 40.313 N43TMMkt Development LLC · Venedocia, OHBuilt 2012 · S/N 3838 N43TTBluewater Islands Inc · Cape Coral, FLBuilt 2009 · S/N 411149 N43VMN43vm LLC · Fremont, CABuilt 2000 · S/N 46-97005 N43VUFlying Legal LLC · Cortlandt Manor, NYBuilt 2018 · S/N 2441 N43WWMaxxum Financial Group Inc · Destrehan, LABuilt 1981 · S/N 32R-8113048 N44006Martin Seth J · Kingman, INBuilt 1977 · S/N 28-7816021 N4400ACae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2019 · S/N 2881107 N4400DCae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2019 · S/N 2881108 N4400FCae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2019 · S/N 2881139 N4400PCae Oxford Aviation Academy Phoenix Inc · Mesa, AZBuilt 2013 · S/N 2843711 N4400SCae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2013 · S/N 2843712 N4400WCae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2013 · S/N 2843713 N4401ECae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2019 · S/N 2881141 N4401NCae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2019 · S/N 2881203

Back to AD 2008-06-28 R1