OpenAirDocs.org
AD 2008-06-28 R1

Registered aircraft · 16,284

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
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.

N949KCParamus Flying Club Inc · Fairfield, NJBuilt 2008 · S/N 40.949N949KLSkydancer Inc · Brevard, NCBuilt 2017 · S/N 4471N949MMNorth Star Equipment LLC · Ponchatoula, LABuilt 2025 · S/N 11040N949WBBirdwin LLC · Buras, LABuilt 2003 · S/N 0447N94AKWestern Aviation LLC · Bloomfield, MIBuilt 1996 · S/N 32-46043N94DCaelesti Libertas LLC · Pittsford, NYBuilt 1982 · S/N 32R-8229050N94EBFlyboyz LLC · Helena, MTBuilt 2021 · S/N 5094N94RSBoard Of Trustees Of Western Michigan University · Battle Creek, MIBuilt 2006 · S/N 1668N94TFWildblue LLC · Edgerton, MOBuilt 1994 · S/N 3213074N94WAVidal Aviation LLC · Gaithersburg, MDS/N 2843118N950GLance Windel Construction LLC · Ardmore, OKBuilt 2000 · S/N 46-97009N950MTMiddle Tennessee State University Aerospace · Murfreesboro, TNBuilt 2023 · S/N 40.1241N950TIsnim LLC · Hartsville, SCBuilt 2004 · S/N 4697185N950TFAir Fleet Holdings LLC · Missoula, MTBuilt 2025 · S/N 2881950N9512CDe Aviation Inc · La Porte, TXBuilt 1978 · S/N 28-7816487N9513CAgri Business Aviation Inc · Sparta, ILBuilt 1978 · S/N 28-7890418N951CDSea To Sky LLC · Diberville, MSBuilt 2006 · S/N 1833N951DTMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 2005 · S/N 1560N951MTMiddle Tennessee State University Aerospace · Murfreesboro, TNBuilt 2023 · S/N 40.1242N951NDUniversity Of North Dakota · Grand Forks, NDBuilt 2025 · S/N 2881925N951PBHare Aviation LLC · Haddam, CTBuilt 2005 · S/N 1449N951PRPrp Aviation LLC · Ocala, FLBuilt 2025 · S/N 10971N951SYYucht Steven · Gainesville, FLBuilt 2024 · S/N 4636838N951TBNeurological Consultants LLC · Newark, DEBuilt 2005 · S/N 4697225N951TFAir Fleet Holdings LLC · Missoula, MTBuilt 2025 · S/N 2881951N9526KReyn/Craft Wildside Aviation LLC · Athens, ILS/N 28-7690257N9527Xie Zhuopeng · Irvine, CABuilt 2006 · S/N 2117N952AArcher Aero LLC · Wilmington, DEBuilt 2015 · S/N 2843804N952CF A Phoenix LLC · Eldorado, WIBuilt 2002 · S/N 0422N952DAEppes Michael Scott · Austin, TXBuilt 1995 · S/N 3213103N952DSAnderson James B IV Trustee · Glendale, AZBuilt 2000 · S/N 1102N952GTimely Equipment Rental LLC · Dexter, MOBuilt 2014 · S/N 4697553N952NDUniversity Of North Dakota · Grand Forks, NDBuilt 2020 · S/N 2881370N952PMAir Dixon LLC · Encinitas, CABuilt 2009 · S/N 4697405N952RTOmega Management Services Inc · North Port, FLBuilt 2006 · S/N 1875N952SBGator Wings LLC · Naples, FLS/N 4314N952SVAquitaine Enterprises LLC · Saint Louis, MOBuilt 2022 · S/N 8728N952TFAir Fleet Holdings LLC · Missoula, MTBuilt 2025 · S/N 2881952N9536MDsn Holdings LLC · La Crosse, WIBuilt 2014 · S/N 4143N9537CArcher II LLC · Kenosha, WIBuilt 1978 · S/N 28-7890420N9538CCobb Janet · Saint Joseph, MOBuilt 1978 · S/N 28-7890421N953ABColumbia Asset Trust Corp Trustee · Wichita, KSBuilt 2011 · S/N 3815N953CMonaghan Management Corp · Greenwood Village, COBuilt 2009 · S/N 4692107N953CMSjfnw LLC · Daniel Island, SCBuilt 2007 · S/N 4697313N953EGCrc Aviation LLC · Laconia, NHBuilt 2007 · S/N 2417N953GArcher Flight LLC · Wilmington, DEBuilt 2018 · S/N 2881081N953MBRegistered aircraftBuilt 2006 · S/N 2149N953MTMiddle Tennessee State University Aerospace · Murfreesboro, TNBuilt 2022 · S/N 40.1234N953TFAir Fleet Holdings LLC · Missoula, MTBuilt 2025 · S/N 2881953N9542DSandberg Joseph A · Mount Laurel, NJS/N 28-7690180
Back to AD 2008-06-28 R1