OpenAirDocs.org
AD 2008-06-28 R1

Registered aircraft · 16,284

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.

N941VFN941vf LLC · Nokomis, FLBuilt 2026 · S/N 11247N942AMSchwerman Joseph · Queensbury, NYBuilt 2025 · S/N 10699N942BMegkat Equipment LLC · Lewes, DEBuilt 2012 · S/N 4636538N942CDRustad Zachary · Lincoln, NEBuilt 2002 · S/N 1195N942LCRegistered aircraftBuilt 2001 · S/N 3257265N942SRBoat Inc · Pompano Beach, FLBuilt 2008 · S/N 3326N9431COsgood Air LLC · Ransom, KSBuilt 1978 · S/N 28-7890411N943CDStans Homestore Inc · Beatrice, NEBuilt 2005 · S/N 1327N943KMByram Interests LLC · Shreveport, LABuilt 2010 · S/N 4697429N943NDUniversity Of North Dakota · Grand Forks, NDBuilt 2025 · S/N 2881922N943RBRb Ffhm LLC · Fresno, CABuilt 2007 · S/N 4636427N944EVSouthlake Aviation LLC · Arden, NCBuilt 2025 · S/N 2881867N944HCHarrison Contracting Co Inc · Villa Rica, GABuilt 2007 · S/N 2659N944LSJmb Air LLC · Algona, IABuilt 1979 · S/N BB-604N944SJ & J Aviation LLC · Kokomo, INBuilt 2000 · S/N 4636306N944TFCornerstone Leasing Of The Texas Panhandle LLC · Panhandle, TXBuilt 1976 · S/N LW-177N9454CPuglia Frank V · El Cajon, CABuilt 1978 · S/N 28-7816477N945BDRegistered aircraftBuilt 2016 · S/N 4397N945CDLunex Power Inc · Tampa, FLBuilt 2005 · S/N 1699N945DBHoskins Joshua C · Frisco, TXBuilt 2000 · S/N 2843312N945LBAllegro Jeff · Upper Lake, CABuilt 1979 · S/N 28-7990404N945PSs Leasing LLC · Bethlehem, CTBuilt 2006 · S/N 1909N945PCErdman Aviation LLC · Mather, CABuilt 2008 · S/N 40.945N945SEC9 Equipment LLC · Phoenixville, PABuilt 2007 · S/N 2394N945TLShirley Mae LLC · Franklin, MIBuilt 2004 · S/N 40.413N945TRFred S Willis Jr Md · Covington, LABuilt 2006 · S/N 2169N945WTL & N Aero LLC · Minden, NVBuilt 2012 · S/N 3831N9461CClub Cherokee Inc · Crystal, MNBuilt 1978 · S/N 28-7890412N9463KRegistered aircraftBuilt 1976 · S/N 28-7690253N9467CDominy Alan L · The Woodlands, TXBuilt 1978 · S/N 28-7890413N946CDLsu Services LLC · South Salt Lake, UTBuilt 2006 · S/N 1839N946DPDp Mirage LLC · Brentwood, TNBuilt 1999 · S/N 46-36240N946DSErickson Merton H · Port Orange, FLBuilt 2008 · S/N 40.984N946USSweet Aviation LLC · Fort Wayne, INBuilt 2008 · S/N 40.946N947CDDavis Brian T · Prescott, AZS/N 1725N947KAKensington Aviation LLC · Warsaw, INBuilt 2022 · S/N 8904N947THHonky Tonk Aviation LLC · Camden, DEBuilt 2006 · S/N 1903N947USOperation No Person Left Behind Outdoors Inc · Libertytown, MDBuilt 2008 · S/N 40.947N9480CDave Gross Inc · Midland, TXBuilt 1978 · S/N 28-7816480N9482CSchuetz Ray · Davie, FLBuilt 1978 · S/N 28-7816481N9483CCnczilla Co · Royersford, PABuilt 1978 · S/N 28-7816482N9486CRhodes Ryan · Dallas, TXBuilt 1978 · S/N 28-7890415N9487KInverted Air LLC · Mesa, AZBuilt 1976 · S/N 28-7690254N948CDSouth Delta Aviation Inc · West Helena, ARBuilt 2004 · S/N 1065N948EACaiman Capital LLC · Redondo Beach, CAS/N 3152N948FBDye James R · Munster, INBuilt 1998 · S/N 3449057N948HCHarrison Contracting Company Inc · Villa Rica, GAS/N 0712N948MCCimm Aviation LLC · Woodstock, GABuilt 2026 · S/N 11163N948SRAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2006 · S/N 2036N949GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881225
Back to AD 2008-06-28 R1