OpenAirDocs.org
AD 2008-06-28 R1

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

N615JPBeyer Munch Enterprises LLC · San Antonio, TXBuilt 2007 · S/N 2401N615LMPerrett Construction Ltd · Valentine, NEBuilt 2002 · S/N 0412N615MBTango Sierra LLC · Kalispell, MTBuilt 2013 · S/N 4029N615PWCardiac LLC · Amarillo, TXBuilt 2004 · S/N 1157N615TDDivide By Zero LLC · Cameron, MTBuilt 2003 · S/N 1343N615WMcnamara Donald James · Sunriver, ORBuilt 2012 · S/N 4636556N615WASanderson Aviation2 LLC · Flower Mound, TXBuilt 2015 · S/N 4697594N6162CHeller Casey · Williston, NDBuilt 2003 · S/N 0619N6162DFriedman Steve · Atlanta, GABuilt 2011 · S/N 4636523N6162XCapital Holdings 149 LLC · Kearney, NEBuilt 2005 · S/N 1371N616ACN616ac LLC · Westfield, MABuilt 2021 · S/N 28020038N616ADArcher Aircraft LLC · Wilmington, DEBuilt 2013 · S/N 2843736N616ARCenturion Flyers LLC · Spokane, WABuilt 2006 · S/N 3257423N616ASBrozzo Ralph A · Midland, MIBuilt 2005 · S/N 1428N616AWAtd Pilot Training Lllc · Kansas City, MOBuilt 1976 · S/N 28-7790171N616CWDixie Air LLC · Russell Springs, KYBuilt 2005 · S/N 1620N616DAHorizons 20 LLC · Cape Coral, FLFirst renewal noticeBuilt 2007 · S/N 1854N616JMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2014 · S/N 4636616N616JNBatten Aviation LLC · Lancaster, OHBuilt 2011 · S/N 3770N616MB6mb Partners LLC · Burleson, TXBuilt 2009 · S/N 3493N616MLUtah State University · Logan, UTBuilt 2009 · S/N 40.1067N616PCPork Chop Aviation II LLC · Hilliard, OHBuilt 2023 · S/N 28020117N616SPAdmiral Aviation Holdings Lp · Summerville, SCBuilt 2023 · S/N 9753N616VJV2j LLC · Bloomfield Hills, MIBuilt 2024 · S/N 9860N616VTNamendorf Michael · New Hyde Park, NYBuilt 1979 · S/N 28-7916500N616XSmreh Air LLC · Wilmington, DEBuilt 2022 · S/N 8817N616YCirrus Design Corp · Duluth, MNS/N 11689N616ZW16 Paws LLC · Navarre, FLBuilt 2022 · S/N 5141N6171ZTennessee Valley Aviation LLC · Fayetteville, TNBuilt 2003 · S/N 0635N617CPDaccarett Miguel S · Chicago, ILS/N 3363N617DATafo Creamery Holdings LLC · Sandy, UTBuilt 2007 · S/N 1867N617DTCacoum LLC · Boca Raton, FLBuilt 2015 · S/N 4193N617ELFly Ivy LLC · Brighton, MABuilt 2025 · S/N 10495N617JAYale Companies LLC DBA · Fishers, INBuilt 2026 · S/N 28020265N617JJAviazione Leoni LLC · Miami, FLBuilt 2009 · S/N 3482N617LWCirrus Design Corp · Duluth, MNS/N 11911N617RTAccess Aero LLC · Manakin Sabot, VABuilt 2011 · S/N 40.1114N617SSN617ss LLC · Sylvania, OHBuilt 2009 · S/N 411127N617THCain Daniel · Topsail Beach, NCBuilt 2020 · S/N 4876N6185HSargent Patrick S · Bicknell, INBuilt 1977 · S/N 28-7890215N6188JRaveesh Cn · Gladstone, MIBuilt 1976 · S/N 28-7690367N6188XKorotkov Dmitry V · Rocklin, CAS/N 0629N618ABCss Enterprises Inc · Middletown, DEBuilt 2010 · S/N 3649N618AJCvm Leasing LLC · Angola, NYBuilt 2016 · S/N 4327N618ALDrifting Dirt LLC · Lewes, DEBuilt 2014 · S/N 4064N618BDSandhu Sky Ventures LLC · Livermore, CABuilt 1989 · S/N 4622047N618CJYou Are Too Nosey LLC · Wilmington, DES/N 41032N618FTFlorida Institute Of Technology · Melbourne, FLBuilt 1985 · S/N 28-8516048N618GDd Air LLC · Lititz, PABuilt 2006 · S/N 41619N618JABolle Aviation LLC · Clare, MIS/N 4595
Back to AD 2008-06-28 R1