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.

N347CDCulkin Daniel J Trustee · Edmond, OKBuilt 2005 · S/N 1360N347CPNwr Aviation LLC · Scottsdale, AZBuilt 2008 · S/N 3044N347DProfessional Training Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 2843840N347DWSnoopy Air LLC · Branch, LABuilt 1996 · S/N 4636059N347EPEauclaire Aircrafts LLC · Weston, MAS/N 10688N347JHJohn Harvey Pc · Savannah, GABuilt 1999 · S/N 1009N347LPGti In The Air LLC · Atlanta, GABuilt 2025 · S/N 11082N347MKNorth Star Aviation · Mankato, MNBuilt 2020 · S/N 2881417N347SRVenture North Aviation LLC · Cloquet, MNBuilt 2007 · S/N 2575N3487QIsrael Jonathan · Huntington Beach, CABuilt 1977 · S/N 28-7716159N348CD348 Charlie Delta LLC · Ames, IABuilt 2007 · S/N 2389N348DProfessional Training Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 2843841N348MKNorth Star Aviation · Mankato, MNBuilt 2020 · S/N 2881418N348SBVector Victor Aviation LLC · Geneva, ILBuilt 2019 · S/N 4824N348TSTuchman Holdings LLC · Englewood, NJBuilt 2011 · S/N 3800N349AFSky Safety Inc · San Antonio, TXBuilt 2009 · S/N 40.1059N349BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2023 · S/N 2881690N349CDRabdau Brandan Joseph · Land O Lakes, FLBuilt 2005 · S/N 1509N349DProfessional Training Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 2843842N349DSMiddle Tennessee State University · Murfreesboro, TNBuilt 2010 · S/N 40.1081N349MAMa Sammy · S San Fran, CABuilt 2004 · S/N 3257349N349MKNorth Star Aviation · Mankato, MNBuilt 2020 · S/N 2881419N349NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2025 · S/N 2881902N34ASHickory Lane Corp · Farmingdale, NYBuilt 2021 · S/N 2686N34CDCannon David A · Magnolia, TXBuilt 2002 · S/N 0148N34EFAjv Air LLC · Berlin, NJBuilt 2025 · S/N 10830N34EHWisconsin Aviation Inc · Watertown, WIBuilt 1993 · S/N 3448031N34KGEldon Jensen Funeral Properties Inc · Lemmon, SDBuilt 1983 · S/N 34-8333059N34MFDavis Aviation Inc · Brandon, MSBuilt 1975 · S/N LW-163N34MVElysium Fleet Mgmt LLC · Menlo Park, CABuilt 1983 · S/N 32R-8413006N34PFAircraft Trustee Services Inc Trustee · Dover, DES/N 3449228N34SUSouthern Utah University · Cedar City, UTBuilt 2023 · S/N 9504N34TGTri W Inc · Shepherd, MTBuilt 2002 · S/N 0386N34TW34 Tango Whiskey LLC-S · Carmel, INBuilt 2005 · S/N 40.501N34WGWings Of Grace Inc · Vonore, TNBuilt 2004 · S/N 0824N34XTGwk Aviation LLC · Fort Smith, ARBuilt 2005 · S/N 3255034N34ZXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1997 · S/N 3449010N3501SRynearson John L Trustee · Scottsdale, AZBuilt 2006 · S/N 41588N3502MRyskoski Randall J · Germantown, WIBuilt 1978 · S/N 28-7890307N350ARAbode Construction Inc · Marion, IABuilt 1990 · S/N 4622109N350ASSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2003 · S/N 40.343N350AUChristiansen Aviation LLC · Wilmington, DEBuilt 2024 · S/N 4496575N350AZTuckerman David B · Lake Stevens, WABuilt 2018 · S/N 4636738N350BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2023 · S/N 2881691N350BLAustin Neal · Fort Myers, FLBuilt 2003 · S/N 42006N350BTAeroventure LLC · Middletown, DEBuilt 2006 · S/N 42537N350CAMajors Donald G Jr · Cave Creek, AZBuilt 2002 · S/N 3257279N350CGWesco Resources Inc · Billings, MTBuilt 2016 · S/N 4636691N350CSCrosswinds Properties Of Nh LLC · Meredith, NHBuilt 2015 · S/N 4636654N350CWPrivate Flight LLC · Wilmington, DEBuilt 2006 · S/N 42520
Back to AD 2008-06-28 R1