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.

N4446Bauermeister Aida · Ham Richmond SurrBuilt 2007 · S/N 41756N444ADApex Aviation Holding LLC · Kalispell, MTBuilt 1980 · S/N BB-733N444AHPhalanx Pc LLC · Austin, TXBuilt 2006 · S/N 2137N444AKWareing Flight Services LLC · Sturgis, SDBuilt 1984 · S/N 441-0334N444CTLeseviciute Audrone · Stamford, CTBuilt 2004 · S/N 3232032N444CVCloud Punchers LLC · Cary, NCBuilt 2017 · S/N 4527N444DEHail Rob A · El Dorado Springs, MOBuilt 1982 · S/N 32R-8213034N444FGFrancis Andrew J III · Spring, TXBuilt 1981 · S/N 28-8190283N444GFDirty Side Down Aviation LLC · Georgetown, TXBuilt 2025 · S/N 10721N444JHCirrusly Fast J2911 LLC · Duson, LABuilt 2016 · S/N 4376N444LPierwest Aviation LLC · Tulsa, OKBuilt 1980 · S/N LW-344N444MFChampagne Cruises Ltd · St Thomas, VIBuilt 2002 · S/N 0174N444MGGeorgia Aviation Authority · Eastman, GABuilt 2023 · S/N 4496562N444NPJc Aviation LLC · Raleigh, NCBuilt 2026 · S/N 11204N444RRAccess Yacht Sales Inc · Norwalk, CTBuilt 2006 · S/N 4697278N444UJAmbush Aviation LLC · Anabel, MOBuilt 2005 · S/N 1348N444VRBarber Casey John · Visalia, CABuilt 2003 · S/N 0788N4455Sanders Russell · Canton, GAS/N 41048N445BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2021 · S/N 4496527N445BLBlue Line Aviation LLC · Smithfield, NCBuilt 2025 · S/N 4496599N445CDMockingbird Wings LLC · Wilmington, DEBuilt 2007 · S/N 2504N445DHOhio University · Albany, OHBuilt 2005 · S/N 2842233N445MAPvl Development LLC · Nashville, TNBuilt 2008 · S/N 4636442N445MGGeorgia Aviation Authority · Eastman, GABuilt 2025 · S/N 4496598N445MKNorth Star Aviation · Mankato, MNBuilt 2015 · S/N 4496383N445NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2025 · S/N 2881891N445PASkywest Leasing Inc · St George, UTBuilt 2001 · S/N 2843500N445ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881672N4468FIdahi Aviation LLC · Eagle, IDBuilt 2004 · S/N 41043N446BDAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2007 · S/N 2366N446BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2023 · S/N 4496553N446BLBlue Line Aviation LLC · Smithfield, NCBuilt 2025 · S/N 4496600N446CDMichiana Air Activities Inc · Osceola, INBuilt 2004 · S/N 1446N446CPOn Eagles Wings Aviation LLC · Ponte Vedra Beach, FLBuilt 2008 · S/N 3297N446DBJhc Airplane LLC · Palo Alto, CAS/N 40.273N446DCAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2004 · S/N 40.446N446DSFun Air LLC · Houston, TXBuilt 2002 · S/N 40.246N446JCSaf Aviation LLC · Lakewood Ranch, FLBuilt 2022 · S/N 4636806N446MARegistration Pending · New York, NYRegistration pendingBuilt 2025 · S/N 4697721N446MKNorth Star Aviation · Mankato, MNBuilt 2018 · S/N 4496448N446MTValiair Lc Trustee · Casper, WYBuilt 2025 · S/N 10708N446NCKhk Management Services LLC · Norcross, GABuilt 2010 · S/N 4636469N446PAHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2001 · S/N 4496086N446RHN446rh LLC · Helena, MTS/N 32R-8129025N446RMRocky Mountain College · Billings, MTBuilt 2023 · S/N 28020111N446SBIll Fly Away LLC · Goshen, INBuilt 2005 · S/N 40.488N446SESouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2007 · S/N 3257446N446SKFlying Montana LLC · Bozeman, MTBuilt 2006 · S/N 41714N4473XSlipstream Aviation LLC · Calera, ALBuilt 1975 · S/N 28-7690018N4474FN44107 LLC · Marlton, NJBuilt 1976 · S/N 28-7790029
Back to AD 2008-06-28 R1