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.

N8251SAirlife Aviation LLC · Elkridge, MDS/N 28-8316081N8252EMiami Flight Training LLC · Miami, FLBuilt 1980 · S/N 28-8016373N8252GJb Flight LLC · Indianapolis, INBuilt 1982 · S/N 34-8233179N8252ZHodges Albert H Executor · Lyons, GAS/N 28-8116011N8253AArcher N8253a LLC · Orange, CTBuilt 1980 · S/N 28-8190013N82542Registered aircraftS/N 32R-8213059N8254JParis Air Inc · Vero Beach, FLBuilt 1982 · S/N 28-8216186N82554Garnet Aviation LLC · Fort Worth, TXBuilt 1982 · S/N 28-8290160N82557Zehm Laura L · Monterey, CABuilt 1982 · S/N 28-8290161N8255MPhoenix Wings LLC · Oakland, FLBuilt 1980 · S/N 32R-8013128N8256EWilliams Evan H · Sebastopol, CABuilt 1980 · S/N 28-8116014N8256VZ-Tech Research LLC · Greenville, TXBuilt 1980 · S/N 28-8116018N8256XSkyriders Inc · Pocatello, IDBuilt 1980 · S/N 28-8190016N8257GDraco Flight School Inc · Chino, CABuilt 1982 · S/N 28-8290162N8258LWiesner Loren A Jr · Cameron, WIBuilt 1980 · S/N 28-8116022N8258NK&G Transit LLC · Fort Mc Coy, FLBuilt 1980 · S/N 28-8116023N8259BDunn Patrick E · Marthasville, MOBuilt 1980 · S/N 28-8190021N8259TNsa Ops LLC · Kahului, HIBuilt 1980 · S/N 28-8190024N825AN7045x LLC · Farmingdale, NYBuilt 2008 · S/N 4692043N825AKWilkerson Clifton · Paris, TXBuilt 2007 · S/N 1811N825CD825cd LLC · Camarillo, CABuilt 2002 · S/N 0189N825CQPremier Pilot Training LLC · Camp Hill, PAS/N 9880N825DWWakeham Dirk Damon · Dallas, TXBuilt 2011 · S/N 4697463N825FWRegistered aircraftBuilt 2005 · S/N 1368N825HADiamond Aviations LLC · De Witt, IABuilt 2009 · S/N 3561N825JBGauthier Daniel A · South Bend, INBuilt 2006 · S/N 1696N825KASav Aviation LLC · Jacksonville, TXS/N BB-825N825PBPalm Beach Aircraft Services Inc · Lantana, FLS/N 28-7890442N825PDEleftheria Air LLC · Clover, SCBuilt 2023 · S/N 9403N825PFClaw Holdings LLC · Frisco, TXBuilt 1983 · S/N 4410327N825SPConquest 2 Aviation LLC · Haines City, FLBuilt 1979 · S/N 441-0127N825TGDodenhoff Robert M · Middletown, CTBuilt 2002 · S/N 0328N825TRGap Aviation LLC · Carencro, LABuilt 2016 · S/N 4317N825USTactical Integrated Training Solutions LLC · Colorado Springs, COBuilt 2007 · S/N 40.825N825XSktr Ac LLC · Fallbrook, CABuilt 2006 · S/N 3255043N8260VRed Rifle Aviation LLC · Richmond, TXBuilt 1980 · S/N 28-8116029N8260YNew Peach Aviation LLC · Brooks, GABuilt 1980 · S/N 28-8116031N8261FDaniels Neil Alan · Balaton, MNS/N 28-7790235N8261HOxford Flying Club Inc · Oxford, CTBuilt 1980 · S/N 28-8190025N8261SHoffmann David M · Mauston, WIBuilt 1980 · S/N 28-8190027N82629Dgf & Associates Inc · Irving, TXS/N 28-8216225N8262ASnider Jay T · Grove City, OHBuilt 1980 · S/N 28-8116033N8262ESee Robert W · Catawba, NCBuilt 1980 · S/N 28-8190033N8262HRegistration Pending · Bucyrus, OHRegistration pendingBuilt 1980 · S/N 28-8190034N8262KHesston College · Hesston, KSBuilt 1982 · S/N 28-8290165N8262SWisconsin Aviation - Four Lakes Inc · Madison, WIBuilt 1980 · S/N 28-8190035N8262UHorton Air Ventures LLC · Eustis, FLBuilt 1980 · S/N 28-8190036N8263MKent State University · Stow, OHBuilt 1981 · S/N 44-8195026N8264VRuby Jeffrey Steven · Sharon, SCBuilt 1980 · S/N 28-8116035N8265CDelgado Francisco Trustee · Carmel, INBuilt 1980 · S/N 28-8190037
Back to AD 2008-06-28 R1