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.

N2203VSnyder Jeffrey L · Annapolis, MDBuilt 1979 · S/N 28-7916326N2204DOvercast Dan · Columbia City, ORBuilt 1978 · S/N 28-7916149N2204XAirgo Inc · Centralia, ILBuilt 1979 · S/N 44-7995281N2205MArthur Aircraft LLC · Sparta, ILBuilt 1977 · S/N 28-7890232N22061Happy Trails Flighttraining & Charters LLC · Helena, MTBuilt 1978 · S/N 28-7916059N2206DLassiter James D · Silas, ALBuilt 1978 · S/N 28-7990164N2207ZArcuri Aviation Enterprises Inc · Westminster, MDBuilt 1979 · S/N 28-7916385N2209VChinn Timothy D · Austin, TXBuilt 1979 · S/N 28-7990343N220ADSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2010 · S/N 3697N220AMLungley George · New Albany, OHBuilt 2010 · S/N 3635N220AURunamuck LLC · New Orleans, LABuilt 2025 · S/N 4496617N220BLSolera Aviation LLC · Bozeman, MTBuilt 2025 · S/N 2881957N220CDChiller Aviation LLC · Missoula, MTS/N 0019N220CEMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881530N220EBJag Aviation LLC · South Easton, MABuilt 2024 · S/N 10325N220FLChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 4496479N220GKHotel Bravo Aviation LLC · Alexandria, OHBuilt 2009 · S/N 3437N220GMBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 3449362N220JGArchies Wings LLC · Umatilla, FLBuilt 1978 · S/N 28-7990067N220KALexatys LLC · Laurel, DEBuilt 1982 · S/N 34-8233151N220KCAvanti Air Co · Troy, MIBuilt 1989 · S/N 3433137N220MRAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2011 · S/N 3779N220SRBriar Flyer LLC · Bedford, NHBuilt 2002 · S/N 0391N220TGSeneca Tank Inc · Des Moines, IABuilt 2002 · S/N 3449265N220THJak Enterprises LLC · Brooklet, GABuilt 2005 · S/N 1574N220TTShannair LLC · Saint Louis, MOS/N BB-462N220UM3k Aviation LLC · Birmingham, MIBuilt 2004 · S/N 4697183N220VVSmith Peter I Trustee DBA · Ocala, FLBuilt 1989 · S/N 3433140N220WJaw Air LLC · Fargo, NDS/N 4622052N220WXMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881540N2210XDraco Flight School DBA · Chino, CABuilt 1979 · S/N 28-7916351N2211CChampigny Jean-Pierre · Harrison, NYBuilt 1982 · S/N 28-8290097N2211ZN2211z LLC · Lake Worth, FLBuilt 1979 · S/N 28-7916389N2214MWings Flying Club Inc · South Bend, INBuilt 1977 · S/N 28-7890234N2214XElm Air LLC · Satellite Beach, FLBuilt 2003 · S/N 1319N2215ZAjb Holdings LLC · Rock Hill, SCBuilt 1979 · S/N 28-7990406N2216YPacific Union College · Angwin, CABuilt 1979 · S/N 44-7995290N22175Johnson Richard E · Duluth, MNBuilt 1978 · S/N 28-7916062N2217DDaytona Jets LLC · Daytona Beach, FLBuilt 1978 · S/N 44-7995137N2217KRoss Mitchell B · Ledyard, CTBuilt 1978 · S/N 28-7916226N2218XHoward Jerald L · Glendive, MTBuilt 1979 · S/N 28-7916354N22193Registered aircraftBuilt 1978 · S/N 28-7990069N22199Charlie Whiskey Flying LLC · Seattle, WABuilt 1978 · S/N 28-7990070N2219YRegion Flyers LLC · Valparaiso, INS/N 28-7916363N221AHBahama Services Inc · Fort Lauderdale, FLBuilt 2000 · S/N 32-46158N221AWChapman Lawrence N · Placerville, CAS/N 0758N221BLPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010036N221BMOne Bravo Mike LLC · Wilmington, DEBuilt 2006 · S/N 1901N221CDJaffee Robert · Victoria, MNBuilt 2001 · S/N 0093N221EDRegistration Pending · Christiansburg, VARegistration pendingBuilt 2022 · S/N 8774
Back to AD 2008-06-28 R1