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.

N234DPConnect 4 Ventures LLC · Woodberry Forest, VABuilt 2024 · S/N 10214N234ETAir Fergie LLC · Camden, DEBuilt 2026 · S/N 11257N234HKExplore Aviation LLC · Santa Barbara, CABuilt 2006 · S/N 1746N234JFaliero Bryan K · Greenville, SCBuilt 2025 · S/N 10754N234KMMurray Edward L · Hoover, ALS/N 28-7990043N234KTCessna 182 LLC · Kitty Hawk, NCBuilt 2004 · S/N 41023N234LBCirrus Design Corp · Duluth, MNS/N 11828N234PAJuliet Two LLC · Ocean Ridge, FLBuilt 1978 · S/N 28-7816677N234PDAccurite Machine & Manufacturing Inc · Louisville, KYBuilt 2004 · S/N 1167N234PGSpeer Aircraft LLC · Evansville, INBuilt 2004 · S/N 0935N234PMDiamond Enterprises LLC · Lincoln, NEBuilt 2005 · S/N 4697200N234SRFrings Airplane Company LLC · Madison, WIBuilt 2025 · S/N 10748N234XLCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11503N235CCYale Companies LLC DBA · Indianapolis, INBuilt 2021 · S/N 2881504N235DLPegasus Royalty Group LLC · Bozeman, MTBuilt 2006 · S/N 41571N235DTEntech Instruments Inc · Simi Valley, CAS/N 411066N235DWAir 4 LLC · Oakland, MES/N 41766N235DYValiair Lc Trustee · Casper, WYS/N 11709N235FYSpace Coast Aircraft Co · Merritt Island, FLBuilt 1989 · S/N 2841285N235JARabosky Gary · Frenchtown, NJBuilt 2008 · S/N 411102N235JLKm Aero Holdings LLC · Wilmington, DEBuilt 2006 · S/N 41701N235MTBeacon Aviation LLC · Chatham, MAS/N 41754N235PAGood Flight Aviation LLC · Stockton, CABuilt 1978 · S/N 28-7816678N235SKInde Aviation LLC · Chesterfield, VABuilt 2023 · S/N 9372N235SLNce Inc · Tucson, AZBuilt 2007 · S/N 41746N235SRDraco Flight School DBA · Chino, CABuilt 2003 · S/N 2842182N235TPSvl Aviation LLC · Delray Beach, FLBuilt 1985 · S/N 28-8516036N235TWSalcedo Enrique · San Diego, CABuilt 2003 · S/N 4697157N2361QLong Lawrence R · South Whitley, INS/N 28-7716100N23653Gales Charles R · Cleverdale, NYBuilt 1968 · S/N 28R-30691N2365SIe3 Enterprise LLC · Elk Grove, CABuilt 2011 · S/N 4636490N2366WAir-Mods Flight Academy · Robbinsville, NJS/N 28-8516046N2369AValiair Lc Trustee · Casper, WYBuilt 2024 · S/N 4636851N2369XChristiansen Aviation LLC · Wilmington, DEBuilt 2011 · S/N 4496291N236BLPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010037N236DProfessional Training Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 2843824N236DCGilbert Gerald · Falls Church, VABuilt 2012 · S/N 3836N236DSLoberg Kirk · Jonesboro, ARS/N 40.271N236DYCirrus Design Corp · Duluth, MNS/N 11711N236FYSpace Coast Aircraft Co · Merritt Island, FLBuilt 2000 · S/N 2842023N236LLaux Air LLC · Missoula, MTBuilt 2004 · S/N 0810N236MABountiful Flight LLC · Woods Cross, UTBuilt 2004 · S/N 40.425N236MGGeorgia Aviation Authority · Eastman, GABuilt 2025 · S/N 2881984N236MTPiper Aircraft Inc · Vero Beach, FLS/N 4496659N236PAGreene James · Hudson, SDBuilt 1978 · S/N 28-7816679N236RSSchoombee Clinton John · Murrieta, CABuilt 2004 · S/N 41003N236SDMoss Steven · Las Vegas, NVBuilt 2006 · S/N 40.696N236TTPoole Mark · Meriden, CTBuilt 1981 · S/N 32R-8113110N236ZKMaximum Ceiling Aviation LLC · Farmingdale, NYS/N 2843401N2375MValentine Ronald F Jr · Santa Maria, CABuilt 1977 · S/N 28-7816280
Back to AD 2008-06-28 R1