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.

N715MLM & M Family Holdings LLC · San Francisco, CABuilt 2025 · S/N 10573 N715RDHalls Aviation LLC · Charleston, SCBuilt 1980 · S/N BB-707 N715RLNofziger Medical Consulting LLC · Stryker, OHBuilt 2004 · S/N 1141 N715SCRunamuck LLC · New Orleans, LABuilt 2023 · S/N 2881625 N715SRSch Aviation Inc Trustee · NorfolkBuilt 2006 · S/N 2284 N715TA715 Aviation LLC · Franklin, MABuilt 2021 · S/N 2742 N715WTAscend Amigos LLC · Alpine, WYBuilt 2006 · S/N 1974 N715YAKansas Aviation LLC · Lawrence, KSBuilt 2019 · S/N 4853 N715YJQuintet Capital LLC · Marysville, OHBuilt 2026 · S/N 11345 N716APButler Aviation Inc · Houma, LABuilt 1978 · S/N BB-448 N716BLMcl Aviation LLC · Pinehurst, NCBuilt 2005 · S/N 1314 N716BSOz Fund Investments LLC · Charleston, WVBuilt 2019 · S/N 4869 N716CCRichmond Wheeler LLC · Marshfield, WIBuilt 1981 · S/N 441-0213 N716CDSky-Vu Flyers Inc · Fishers, INBuilt 2001 · S/N 0039 N716DRT A S K Aviation LLC · Panama City Beach, FLBuilt 2002 · S/N 0272 N716GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881460 N716JDMyers Drew E · Norton, MABuilt 2005 · S/N 1598 N716JKWood Oscar Eugene III · Alexandria, VAS/N 42566 N716JMAtec Aviation LLC · Jupiter, FLBuilt 2017 · S/N 4636716 N716KPSpirit Travel Air LLC · Saint Charles, MOBuilt 2004 · S/N 1075 N716NDUniversity Of North Dakota · Grand Forks, NDBuilt 2017 · S/N 2843885 N716PVOptimum G7 Aviation LLC · Sterling, VABuilt 2024 · S/N 10236 N716RGGarrett Robert S · Dallas, TXBuilt 1983 · S/N 32R-8413003 N716SMConquest Flight LLC · Pottstown, PABuilt 1977 · S/N 441-0004 N716WFly Away LLC · Hattiesburg, MSBuilt 2023 · S/N 9401 N716XXUbiquitair LLC · San Antonio, TXBuilt 2026 · S/N 11336 N7171FFriedrich Richard L · Georgetown, TXFirst renewal noticeBuilt 1976 · S/N 28-7790184 N7171XUnion Hill Aviation Inc · Wilmington, DEBuilt 2004 · S/N 0838 N717AGDerstine Air Service LLC · Souderton, PABuilt 2007 · S/N 1792 N717AHGrace By Air LLC · Hogansville, GABuilt 2012 · S/N 3894 N717APLone Mountain Aircraft LLC · Vandalia, OHBuilt 2008 · S/N 3289 N717AUPiper Aircraft Inc · Vero Beach, FLS/N 4496655 N717BGRye Aviation Services LLC · Palm City, FLBuilt 2017 · S/N 4548 N717DFSb Aviation Corp · New York, NYBuilt 2010 · S/N 3605 N717EGHeritage Leasing Inc · Albertville, ALS/N 0704 N717GMAlbatross Aviation LLC · Tazewell, TNBuilt 1997 · S/N 46-36118 N717JB737 Cessna Inc · Naples, FLS/N 2128 N717PGMc Consultants LLC · Isle Of Palms, SCBuilt 2005 · S/N 1711 N717SHMkb Leasing LLC · Saint Louis, MOBuilt 2010 · S/N 2057 N717SKLava Rock Properties LLC · Saint George, UTS/N 4636053 N717SUMouki Aviation LLC · South Lake Tahoe, CABuilt 2004 · S/N 0969 N717VMTir Holdings LLC · Safety Harbor, FLBuilt 2007 · S/N 2364 N717VTN717vt LLC · Wayne, PABuilt 1982 · S/N 28-8316029 N717WHCelebrity Aviation LLC · Tupelo, MSBuilt 2004 · S/N 1201 N717WMBoard Of Trustees Of Western Michigan University · Kalamazoo, MIBuilt 2024 · S/N 9955 N717ZStephanie Air LLC · Chester Springs, PABuilt 2023 · S/N 9520 N7182NCornerstone Aviation LLC · Springboro, OHBuilt 2018 · S/N 2438 N7185FBrw Aircraft Inc · Matawan, NJBuilt 1976 · S/N 28-7790186 N718AJGranados Air LLC · West Palm Beach, FLBuilt 2019 · S/N 4830 N718BLRdm Aviation LLC · Mount Pleasant, SCBuilt 2018 · S/N 4624

Back to AD 2008-06-28 R1