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.

N587CPBear Automation Inc · Fayetteville, ARBuilt 2008 · S/N 3354N587DFTardis Leasing LLC · Fort Myers, FLBuilt 2006 · S/N 4697247N587DGLsm Aviation LLC · Rome, GABuilt 2011 · S/N 3745N587KAtp Aircraft 3 LLC · Wilmington, DEBuilt 2017 · S/N 2843928N587MALong Island Aviators LLC · Seaford, NYBuilt 2002 · S/N 2843517N587MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2008 · S/N 40.971N587PGMirasoles Produce USA LLC · Palmhurst, TXBuilt 2008 · S/N 1940N587PUOcf Air LLC · Phoenix, AZBuilt 2010 · S/N 2048N587TWAircraft Security Corp · Laredo, TXBuilt 1979 · S/N BB-587N5882FGo Fly Mi LLC · Saginaw, MIBuilt 1976 · S/N 28-7790140N5886FBacktoeden LLC · Casper, WYBuilt 1976 · S/N 28-7790141N5886MLexington Surgical Consultants LLC · San Juan, PRBuilt 2014 · S/N 2248N5889VJust Plane Fun LLC · Lac Du Flambeau, WIBuilt 1977 · S/N 28-7790507N588CTLynn Johnny Wayne · Indian Trail, NCBuilt 2008 · S/N 3207N588LAPiper 3 LLC · Chestnut Ridge, NYBuilt 2023 · S/N 28020106N588MCPowell Jonathan M · Chattanooga, TNBuilt 1999 · S/N 3449111N588MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2008 · S/N 40.974N588NDChristiansen Aviation LLC · Wilmington, DEBuilt 2006 · S/N 4496233N588PFBurke Farm Management Service Inc · Waynesboro, GABuilt 2009 · S/N 411145N588SRSojo Air LLC · Abilene, TXBuilt 2007 · S/N 2351N588SWMountain Lion Aviation LLC · Truckee, CABuilt 2018 · S/N 2449N5890VEller Patricia E · Lutz, FLBuilt 1977 · S/N 28-7790508N5897VMacair Aviation LLC · Xenia, OHBuilt 1977 · S/N 28-7716212N5898VMaxair Inc · Coxs Creek, KYBuilt 1977 · S/N 28-7716213N589APa28 Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843765N589CACordeiro Aviation LLC · Mount Airy, MDS/N 2078N589CTNorton Vickie R · Huntington Beach, CABuilt 2008 · S/N 3203N589DSDelta State University · Cleveland, MSBuilt 2023 · S/N 9256N589LAPiper 3 LLC · Chestnut Ridge, NYBuilt 2023 · S/N 28020107N589MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2008 · S/N 40.978N589NDUniversity Of North Dakota John D Odegard School · Grand Forks, NDBuilt 2026 · S/N 4496635N589PUS&U Property Investments LLC · Wellington, FLBuilt 2010 · S/N 2050N589RCSkyflite LLC · Hillsboro, ORBuilt 2004 · S/N 0871N589SCSpartan Education LLC · Tulsa, OKBuilt 2020 · S/N 2881407N589SRBe Happy LLC · Nashua, NHBuilt 2006 · S/N 2273N589TFam Vans Inc · Fountain Valley, CAS/N 40.503N58ACAlto Cirrus LLC · Coral Gables, FLBuilt 2021 · S/N 5040N58BCDkg LLC · Helena, MTBuilt 1989 · S/N 4622058N58BTValiair Lc Trustee · Casper, WYBuilt 2007 · S/N 4697289N58QDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeS/N BL8N58VGQualitair LLC Trustee · MichelstadtBuilt 2006 · S/N 41640N5900VFagen Aaron J · Granite Falls, MNS/N 28-7790510N59019Kousa LLC · Mount Tabor, NJBuilt 1998 · S/N 4636148N5903VIllinois Valley Flying Club · Peru, ILBuilt 1977 · S/N 28-7790511N5907Summit Aviation Group LLC · Monument, COBuilt 2007 · S/N 2388N590CDInternational Air Services Inc Trustee · Carson City, NVBuilt 2004 · S/N 0957N590DSDelta State University · Cleveland, MSBuilt 2023 · S/N 9270N590GStar 5 Airlines LLC · Houston, TXBuilt 2013 · S/N 4636611N590MTMiddle Tennessee State University · Murfreesboro, TNS/N 40.980N590NDChristiansen Aviation LLC · Wilmington, DEBuilt 2009 · S/N 4496269
Back to AD 2008-06-28 R1