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.

N766SBAirhawk2 LLC · Cannon Beach, ORBuilt 2018 · S/N 4639N7670FAkaya LLC · Sherman Oaks, CABuilt 1976 · S/N 28-7790214N7672JWeiner Johannes · New Paltz, NYBuilt 1969 · S/N 28R-31103N7674JAerofeather Aviation Inc · Suffolk, VABuilt 1968 · S/N 28R-31074N7675JDimmlich Scot A · Conyers, GABuilt 1968 · S/N 28R-31075N7677DSteel Aviation Inc · Phillipsburg, OHBuilt 2008 · S/N 2936N7679FScott Field Flying Club LLC · Elgin, IABuilt 1976 · S/N 28-7790215N767AUAuburn University · Auburn, ALBuilt 2019 · S/N 4496456N767CVNcv LLC · Jacksonville, FLBuilt 2001 · S/N 3257234N767LAN767la LLC · Philadelphia, PABuilt 2025 · S/N 28020219N767NDUniversity Of North Dakota · Grand Forks, NDBuilt 2018 · S/N 2881035N767PAPurdue Aviation LLC · West Lafayette, INBuilt 2002 · S/N 4496114N767TPNuage Holdings LLC · Sioux Falls, SDBuilt 2001 · S/N 4697036N767ZZRegistered aircraftBuilt 2007 · S/N 2410N7680FMag Avionics LLC · Woodlands, TXBuilt 1976 · S/N 28-7790217N7682JAv Serv LLC · Dover, DEBuilt 1969 · S/N 28R-31083N7686JCovic Craig A · Cordova, TNBuilt 1969 · S/N 28R-31087N7688Jte Properties LLC · Azle, TXBuilt 1996 · S/N 4636055N7688FLittle House In The Big Woods LLC · Nashville, INBuilt 1976 · S/N 28-7790219N7688JClapp Rollyn D · Volga, SDBuilt 1969 · S/N 28R-31266N7689FRed Arrow Aviation LLC · Santa Teresa, NMS/N 28-7790220N768AMeridian Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843793N768CDSears William R · Lexington, MABuilt 2004 · S/N 1041N768NDUniversity Of North Dakota · Grand Forks, NDBuilt 2017 · S/N 2843897N7690JFox Two LLC · Camino, CABuilt 1969 · S/N 28R-31071N7690UPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020278N7692JFlying Wings Of Louisiana · Denham Springs, LAS/N 28R-31092N76957Airplane Flyers LLC · Nixa, MOBuilt 1975 · S/N 28-7690098N7697FTogether Again LLC · Charlotte, NCBuilt 1976 · S/N 28-7790222N7698FProfessional Pilot Training · Eagle Lake, TXBuilt 1976 · S/N 28-7790223N7698JMetz Mark A · Ida, MIBuilt 1969 · S/N 28R-31098N7699JHamilton John B · Stafford, VABuilt 1969 · S/N 28R-31099N769AMeridian Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843794N769CDSutherland James N · Terrebonne, ORBuilt 2004 · S/N 0932N769GMN373hp LLC · Ladera Ranch, CABuilt 2021 · S/N 2881448N769KVFalcon Aviation Inc · West Jefferson, OHBuilt 2023 · S/N 9623N769LSFlystar LLC · Tampa, FLBuilt 2006 · S/N 40.663N769LZMontana 1204 LLC · Rock Valley, IABuilt 2003 · S/N 3255012N769NDN769nd LLC · Sidney, MTBuilt 2016 · S/N 2843861N769SROwll Aviation LLC · Baton Rouge, LABuilt 2007 · S/N 2769N769VCValley Aircraft Capital LLC · Manvel, NDBuilt 2021 · S/N 2719N769WMBoard Of Trustees Of Western Michigan University · Kalamazoo, MIBuilt 2024 · S/N 10086N76ADWerner Richard · Syosset, NYBuilt 1975 · S/N 28-7690019N76AHOrthoplane LLC · Kalamazoo, MIBuilt 2004 · S/N 3232029N76ALAldeen Leo · Houston, TXBuilt 2021 · S/N 5057N76AVCirrus Design Corp · Duluth, MNS/N 11843N76BYViper Aeronautics LLC · Lincoln, NEBuilt 2002 · S/N 0145N76DBarrett Todd · Palm Harbor, FLS/N 1176N76DHKarapelou James M · Allentown, PABuilt 1995 · S/N 2843019N76DMHendrix Aviation Inc · Plantation, FLBuilt 1977 · S/N 28-7890110
Back to AD 2008-06-28 R1