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.

N65035Vimco Aviation LLC · El Paso, TXBuilt 2004 · S/N 42052N6503CPotts Phillip G · Chattanooga, TNBuilt 2003 · S/N 42015N65042Blueventure LLC · Morganton, NCBuilt 2004 · S/N 42042N6504CBraddy James R Jr · Sunnyvale, TXBuilt 1978 · S/N 28-7890377N6504DAirmart Aircraft Holdings Inc · Oak Ridge, NCS/N 42035N6504HPlane Fun Inc Tr Trustee · Snellville, GABuilt 2004 · S/N 41010N6504XMarc Pauls · Charlotte, NCBuilt 2004 · S/N 42056N6504ZAlbertson Robbie H · Easley, SCBuilt 2003 · S/N 42024N6505VElg Air LLC · Birmingham, ALS/N 42053N6505ZJames Bryan C · Fredericksburg, TXBuilt 2004 · S/N 42044N6507CBollum Justin Keith · Chevy Chase, MDS/N 28-7816533N6507YJudge Allen · Lebanon, ILBuilt 2004 · S/N 41008N6508ALynch John Z · Elon, NCBuilt 2004 · S/N 42038N6508FDi Ioia Mickey · Glen Mills, PABuilt 2004 · S/N 42061N6509AStockard Ryan · Abilene, TXBuilt 2004 · S/N 41006N6509YColumbia 400 LLC · Reno, NVBuilt 2004 · S/N 41009N6509ZQualitair LLC Trustee · MichelstadtBuilt 2003 · S/N 42020N650FTFlorida Institute Of Technology · Melbourne, FLBuilt 2013 · S/N 2843710N650KCPastor Stephen · Montgomery, TXBuilt 2014 · S/N 4636650N650NDUniversity Of North Dakota · Grand Forks, NDBuilt 2019 · S/N 2881147N650SEStone Archer LLC · Hempstead, TXBuilt 2007 · S/N 2843650N650SREndpoints & Evidence LLC · Surf City, NCBuilt 2006 · S/N 2221N65105Hall Herb · Leawood, KSBuilt 2004 · S/N 42059N6510V1903 Aviation LLC · Saint Augustine, FLS/N 42029N6510YSaginaw LLC · Missoula, MTBuilt 2004 · S/N 42057N6512RCeresa Glen · Watsonville, CABuilt 2003 · S/N 42014N6512ZNuvo Concepts Corp · El Paso, TXBuilt 2003 · S/N 42017N65131Bas Part Sales LLC · Greeley, COBuilt 2003 · S/N 42027N6513GMarno Aviation LLC · El Paso, TXBuilt 2003 · S/N 42025N651BSBoard Of Trustees Of Western Michigan University · Battle Creek, MIBuilt 2006 · S/N 1711N651CPN651cp LLC · Sylacauga, ALBuilt 2010 · S/N 3670N651JRSumar Electrical Systems Inc · Warren, OHS/N 3491N651KStone Aviation Holdings LLC · Conway, SCBuilt 2009 · S/N 2032N651KCPacific Flight Aviation LLC · Costa Mesa, CABuilt 2007 · S/N 2843651N651MMEcr Aviation LLC · Elizabeth, NJS/N 1960N651TM305 Sky LLC · Boca Raton, FLBuilt 1981 · S/N BB-804N651XCWoodland Air LLC · Grand Rapids, MIBuilt 2003 · S/N 0475N6529CRainey David K · Franklin, TXBuilt 1978 · S/N 28-7816433N652CDCameronair LLC · Ann Arbor, MIBuilt 2006 · S/N 1794N652DXJja Aviation Group LLC · Sharpsville, PABuilt 2023 · S/N 9357N652FTFlorida Institute Of Technology Inc · Melbourne, FLBuilt 2024 · S/N 28020170N652JMRed Raider Asset Holdings LLC · Austin, TXBuilt 2019 · S/N 4806N652MHCirrus Aviation Services LLC · Colorado Springs, COBuilt 2007 · S/N 2891N652TBCirrus Design Corp · Duluth, MNS/N 11730N652WMBoard Of Trustees Of Western Michigan University · Kalamazoo, MIBuilt 2024 · S/N 9843N6531CDorr Juergen W · Mundelein, ILBuilt 1978 · S/N 28-7890380N6532CQuartarolo Pete · Santa Rosa, CABuilt 1978 · S/N 28-7890381N653BWSmall Frank · Collegedale, TNS/N 1195N653DENippert Dwight A · Lancaster, OHBuilt 2020 · S/N 4989N653DGWatson Dallas C · Guthrie, OKBuilt 2003 · S/N 0522
Back to AD 2008-06-28 R1