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.

N6468Charlie Sierra Aviation LLC · Norwalk, IABuilt 2002 · S/N 0419N646ABInternet Strategies LLC · Glenview, ILBuilt 2023 · S/N 9369N646AFFlight1 Technical Training Services LLC · Myrtle Beach, SCBuilt 2026 · S/N 11355N646DRWilderness Aircraft Co LLC · Bloomington, MNBuilt 1980 · S/N BB-646N646FTFlorida Institute Of Technology · Melbourne, FLBuilt 2013 · S/N 2843706N646HCGraber Air LLC · Atglen, PABuilt 2007 · S/N 4636433N646KWHely Aviation LLC · Columbus, INBuilt 2000 · S/N 32-46173N646NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2019 · S/N 2881143N646VAFieldspring Aviation LLC · Santa Clarita, CABuilt 2026 · S/N 11361N647CABilli The Flying Cat LLC · Atlanta, GABuilt 1978 · S/N 28-7890312N647CDGomez Enrique Jose · Pinecrest, FLBuilt 2005 · S/N 1724N647DSSkyshare LLC · Prescott, AZBuilt 2006 · S/N 40.647N647FTFlorida Institute Of Technology · Melbourne, FLBuilt 2013 · S/N 2843707N647MAHot Wings Aviation LLC · Fishers, INBuilt 2026 · S/N 28020267N647MDKuehn Lawrence · Arlington Heights, ILBuilt 2007 · S/N 1772N647SEHaley Kenneth R · Claremore, OKBuilt 2005 · S/N 3232047N647SJRegistered aircraftBuilt 2013 · S/N 4636581N647YDFaukner Andrew L · Modesto, CAS/N 287816499N648ACHey Clinic Pa · Raleigh, NCBuilt 2010 · S/N 3648N648CDurant Cecil John · Arlington, TXBuilt 2003 · S/N 0441N648CB648cb LLC · Columbus, OHS/N 0648N648DSAmerican Asset Leasing LLC · Aurora, ORBuilt 2006 · S/N 40.616N648FTFlorida Institute Of Technology · Melbourne, FLBuilt 2013 · S/N 2843708N648NDUniversity Of North Dakota · Grand Forks, NDBuilt 2019 · S/N 2881164N648TStefaniak Paul B · Richmond, TXBuilt 1995 · S/N 4636002N649CDSouthcap Brokerage Altanta Inc · Inlet Beach, FLBuilt 2005 · S/N 1709N649FTFlorida Institute Of Technology · Melbourne, FLBuilt 2013 · S/N 2843709N649JCDeja Air LLC · Morristown, TNBuilt 1980 · S/N BB-649N649NDUniversity Of North Dakota · Grand Forks, NDBuilt 2019 · S/N 2881165N64AAProspect Aviation Montana LLC · Missoula, MTBuilt 2016 · S/N 4697608N64BEMlc Aviation LLC · Sheridan, WYBuilt 2024 · S/N 10288N64CDKerr Martin · Greensburg, PABuilt 2005 · S/N 1589N64MROne Mike Romeo Leasing LLC · Las Vegas, NVBuilt 2003 · S/N 0724N64SGCamp Illahee Inc · Brevard, NCBuilt 2006 · S/N 42549N64SUEllison Stephen R · Lampasas, TXBuilt 2008 · S/N 40.994N64TGWilliamson Russell Haire Jr · Memphis, TNBuilt 2012 · S/N 3845N64TWPlane Fun LLC · Garretson, SDS/N 4636054N64TZChapel Hill Flying Club DBA · Sanford, NCBuilt 1981 · S/N 28-8216081N64VUKoosh Air LLC · Edmond, OKBuilt 2025 · S/N 10825N64WDAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1996 · S/N 3246027N6500GConsultant Services LLC · Stillwater, MNBuilt 2004 · S/N 42045N6500VBlue Marble Aviation LLC · Center Valley, PABuilt 2003 · S/N 42033N6501CGcbc LLC · Norman, OKBuilt 1978 · S/N 28-7816428N6501UMoses Hunter K · Georgetown, TXBuilt 2004 · S/N 42040N6501ZJ&M Aviation Enterprises LLC · Greendale, WIBuilt 2003 · S/N 42007N65029Woodberry Robert A · Mineral, VABuilt 2004 · S/N 41024N6502ABelair Two LLC · Lancaster, PABuilt 2004 · S/N 42048N6502HSimpson Equipment Leasing LLC · Hays, KSBuilt 2004 · S/N 42037N6502XFalcon Way Partners LLC · East Helena, MTBuilt 2004 · S/N 42039N65031Miller Lewis W · Setauket, NYBuilt 2004 · S/N 42060
Back to AD 2008-06-28 R1