OpenAirDocs.org
AD 2008-06-28 R1

Registered aircraft · 16,284

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.

N8675EBarbarich Allen G · Las Vegas, NVBuilt 1976 · S/N 28-7690186N867ATCxk1 LLC · Wilmington, DEBuilt 2026 · S/N 4496626N867CDMoonset Ranch LLC · Missoula, MTBuilt 2002 · S/N 0195N867CTTessos Air Service Inc · Wilmington, DEBuilt 1976 · S/N 28-7790079N867DSStarboard Light Aviation LLC · Dover, DES/N 40.867N867PProfessional Training Aircraft LLC · Wilmington, DEBuilt 2018 · S/N 2843948N867PUTrustees Of Purdue University · West Lafayette, INBuilt 2021 · S/N 2881497N867RGKc Air Services LLC · Wilmington, DEBuilt 2009 · S/N 3376N867SLSafeco Leasing LLC · Port Alsworth, AKS/N BB-867N868CDNational Test Pilot School · Mojave, CABuilt 2002 · S/N 0245N868CKSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2009 · S/N 3412N868EAtlas Aircrafts LLC · Coral Springs, FLBuilt 2005 · S/N 40.569N868PProfessional Training Aircraft LLC · Wilmington, DEBuilt 2018 · S/N 2843949N868SRKelley Patrick Barrett · Salida, COBuilt 2007 · S/N 2860N868TWMhs Leasing LLC · Jonesboro, ARBuilt 2008 · S/N 3060N868UInter American University Of Puerto Rico · Bayamon, PRBuilt 2026 · S/N 28020268N868USMel Aviation LLC · Johns Creek, GABuilt 2007 · S/N 40.868N869ATCxk1 LLC · Wilmington, DEBuilt 2026 · S/N 4496627N869BCInter American University Of Puerto Rico · Bayamon, PRBuilt 2026 · S/N 28020269N869GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881468N869JBJd3 Aviation LLC · Tulsa, OKBuilt 2008 · S/N 2910N869MErw Aviation LLC · Marshall, TXBuilt 2010 · S/N 4636476N869MAGoose Aviation Co · Farmingdale, NYS/N 28-8316060N869MPGerhold Electric Inc · Jupiter, FLBuilt 2006 · S/N 1895N869SFPhoenix Rising Aviation LLC · Marlboro, NJBuilt 2026 · S/N 11382N869SMNwg LLC · Draper, UTBuilt 2007 · S/N 2596N869TASheeptick LLC · Conrad, MTBuilt 2022 · S/N 2881545N869WMBoard Of Trustees Of Western Michigan University · Kalamazoo, MIBuilt 2024 · S/N 10252N86AHAhydro LLC · Naples, FLBuilt 2011 · S/N 3754N86DEHardwood Transport LLC · Caledonia, NYBuilt 2008 · S/N 411027N86EWLt Cirrus LLC · Southborough, MABuilt 2021 · S/N 5013N86GESierra Delta Holdings LLC · Dallas, TXBuilt 2008 · S/N 2947N86HCN86hc LLC · Rochelle, ILBuilt 1997 · S/N 3257025N86JKMartin Christopher M · Mount Vernon, OHBuilt 2003 · S/N 0525N86KCMalick Jewell E · Heath, TXBuilt 2006 · S/N 41617N86LPFields To Flight LLC · Walnut Creek, CABuilt 2008 · S/N 411089N86MJCirrus Design Corp · Duluth, MNBuilt 2010 · S/N 3711N86NXQuinn Dana S Trustee · East Harwich, MABuilt 2002 · S/N 0236N86PFCti Aircraft Leasing LLC · Memphis, TNS/N 2881299N86PZKre Investments LLC · Texarkana, ARBuilt 2023 · S/N 9353N86TUFosaaen Karl · Albany, ORBuilt 1979 · S/N 28-7916535N86WBHarris Michael G · New Orleans, LABuilt 2004 · S/N 1173N86WTSdgt LLC · Roseburg, ORS/N 41628N870AMMojo Medical LLC · Webb City, MOBuilt 2004 · S/N 2843604N870BREva Flight Training Academy · Mather, CABuilt 2013 · S/N 40.1187N870CACarver Aero LLC · Muscatine, IABuilt 2002 · S/N 4496127N870CDZugski LLC · Nederland, COBuilt 2002 · S/N 0305N870CHBuzz Light LLC · Baton Rouge, LABuilt 2024 · S/N 10009N870CVValiair Lc Trustee · Casper, WYBuilt 2021 · S/N 5000N870GSBoard Of Trustees Of Western Michigan University · Battle Creek, MIBuilt 2023 · S/N 4496557
Back to AD 2008-06-28 R1