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.

N312WCRegistered aircraftBuilt 2019 · S/N 2492N3130RN738yc LLC · Fresno, CABuilt 1969 · S/N 28R-31115N3131MAir Service LLC · Wilmington, DEBuilt 2006 · S/N 4636382N3132VMaloney-Lyons LLC · Mobile, ALBuilt 2006 · S/N 4697255N3133QLearn 2 Fly Ct LLC · Simsbury, CTBuilt 1977 · S/N 28-7716138N3134FSignature Aviation Group LLC · Columbia, MOBuilt 2012 · S/N 4692183N3135RSerna Alvaro V · San Antonio, TXBuilt 1969 · S/N 28R-31117N3135Y3135y LLC · Rexburg, IDBuilt 2006 · S/N 4697258N3137TProject Funding Corp · Stockton, CABuilt 2006 · S/N 4697257N31385Registration Pending · Missoula, MTRegistration pendingBuilt 1978 · S/N 28-7816554N3138BBuck Enterprises LLC · Henderson, NVBuilt 2006 · S/N 3255044N31399G&M Aircraft Inc · Wheat Ridge, COBuilt 1978 · S/N 28-7816556N313ACAero Craft Of Bloomington LLC · Bloomington, ILBuilt 1977 · S/N 28-7816013N313AFK2 Aviation LLC · Greenwood Village, COBuilt 2009 · S/N 40.1053N313AKCirrus Design Corp · Duluth, MNS/N 11760N313CTAlmar Aviation LLC · Greenville, KYBuilt 1979 · S/N BB-461N313DCRegistered aircraftBuilt 1978 · S/N 28-7816591N313DG3dg Aviation LLC · Louisville, KYBuilt 2005 · S/N 1592N313JMFlatiron Air LLC · Hotchkiss, COBuilt 1983 · S/N 441-0312N313LCShort Carl R · Issaquah, WABuilt 2008 · S/N 3046N313LFFuller Aviation LLC · Delray Beach, FLBuilt 2025 · S/N 10784N313MHHarder-Diesslin Development Group LLC · Salida, COBuilt 2010 · S/N 3619N313NRDawn Patrol LLC · Portsmouth, NHBuilt 2024 · S/N 10209N313PPMw Collins Inc · Cobbtown, GABuilt 2006 · S/N 3255051N313SRTrust Your Fronts LLC · Miami, OKBuilt 2006 · S/N 1978N313TF313tf Aviation LLC · Superior, WIBuilt 2004 · S/N 1237N313VBVernor Air LLC · Harbor Springs, MIBuilt 2016 · S/N 4361N313VJCirrus Design Corp · Alcoa, TNBuilt 2021 · S/N 2734N313ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881640N31400Druidia Group LLC · Downingtown, PABuilt 1978 · S/N 28-7816557N3140GBynum Aviation LLC · New Albany, MSS/N 3257433N31416Pterosaur Holdings LLC · Scarsdale, NYBuilt 2018 · S/N 4665N3143JLyden Air LLC · Walbridge, OHBuilt 2006 · S/N 3257427N3149QClear Air LLC · Ashford, CTBuilt 1977 · S/N 28-7790439N314AAlien Air LLC · Missoula, MTBuilt 2006 · S/N 2061N314AFStanback Clarence F · Newport Coast, CAS/N 40.1054N314CPWilbury LLC · Las Vegas, NVBuilt 2008 · S/N 3234N314DSFlyers Unlimited LLC · Tucson, AZBuilt 2005 · S/N 1705N314GFMcauliffe Garrett · Seattle, WABuilt 2008 · S/N 4697357N314JBBratton Johnny B · Williamsport, TNBuilt 1999 · S/N 2843226N314KD314 Aviation LLC · Carlisle, PABuilt 2024 · S/N 10165N314MRMiller Aviation LLC DBA · Huntington, INBuilt 1976 · S/N LW-184N314NETee Philip · Far Hills, NJS/N 287716112N314PKKelsey Excavating Inc · Davis, ILBuilt 2006 · S/N 1779N314PLWkj Enterprises LLC · Boulder, COBuilt 2011 · S/N 4636521N314RDMeyer Ronnie G · Sidney, NEBuilt 2006 · S/N 1648N314SEZaludek Joseph S · Eugene, ORBuilt 2003 · S/N 40.328N314YFOcana Investments LLC · Hendersonville, TNBuilt 2015 · S/N 2302N3151GMtc Aviation LLC · New Harmony, UTS/N 4636390N3151HD S R D Investments LLC · Oklahoma City, OKBuilt 2006 · S/N 3257428
Back to AD 2008-06-28 R1