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.

N22BVForgotten Coast Flyers LLC · Apalachicola, FLBuilt 2020 · S/N 2642N22CAN22ca LLC · Ennis, MTBuilt 2008 · S/N 421003N22CE0 To 100 Aviation LLC · Palmetto Bay, FLBuilt 2020 · S/N 4918N22CG316 Extreme LLC · Basalt, COBuilt 1979 · S/N 441-0119N22CKAdams Ventures LLC · Lowell, ARBuilt 1982 · S/N 32R-8213048N22CXMount Vernon Air LLC · Ewing, ILS/N 4622066N22CYHughes Jason David · Hickory, NCBuilt 2008 · S/N 3085N22DBSalisbury Mark J · Green Cove Springs, FLBuilt 2002 · S/N 0205N22DMM1 Aviation LLC · Trenton, NJFirst renewal noticeBuilt 2007 · S/N 2886N22EGEsm Aviation LLC · Pomona, NYBuilt 2006 · S/N 2234N22FARosen Barry W · West Hollywood, CABuilt 2003 · S/N 0782N22GXKiser Raymond Paul · Sebring, FLBuilt 2004 · S/N 0980N22HSCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11607N22KHTrue Aviation LLC · Charlottesville, VABuilt 2002 · S/N 0198N22MVJm Aviation Holdings LLC · Loudonville, NYBuilt 2024 · S/N 4636843N22NDynamic Avlease Inc · Bridgewater, VABuilt 1973 · S/N LW48N22QQSkywest Leasing Inc · St George, UTBuilt 2004 · S/N 40.447N22QTAlameda Aero Club · Alameda, CABuilt 2005 · S/N 40.491N22RSLechner Douglas K · Needham, INBuilt 1976 · S/N 28-7690187N22SYSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1997 · S/N 4636122N22VCVictorcharlie LLC · Weston, MABuilt 2005 · S/N 1341N22VGGreenway Group LLC · Suwanee, GAS/N 0459N22WEWings Over Saluda Institute LLC · Wilmington, DEBuilt 2022 · S/N 9023N22WUPlane Pro Aviation LLC · Shelby, NCBuilt 2006 · S/N 1647N22WXCisneros Corina · Belmont, NHBuilt 2002 · S/N 0281N22XDNokes James · Woodbury, TNBuilt 2003 · S/N 0531N22XJSmile Air LLC · Vidalia, GABuilt 2012 · S/N 3835N22ZFEastern Stearman Inc Trustee · Leesburg, VABuilt 2006 · S/N 1902N22ZMAbkw Air Sunshine LLC · Wilmington, DEBuilt 2007 · S/N 2684N2304DBb4 Leasing LLC · Lees Summit, MOBuilt 2010 · S/N 4692154N230CARinehart Investment Group LLC · Forest Lake, MNBuilt 2011 · S/N 3821N230CDAcronut Cardinals LLC · Glen Allen, VABuilt 2001 · S/N 1121N230DCUtah State University · Logan, UTBuilt 2008 · S/N 40.966N230DSWestward Wind Ltd · Wilmington, DEBuilt 2005 · S/N 40.599N230EValiair Ltd Co Trustee · Casper, WYS/N 9522N230SRNational Auto Solutions LLC · Gallatin, TNBuilt 2007 · S/N 2361N230SUBoelte Aviation LLC · Wilmington, DEBuilt 2026 · S/N 4496639N230SX2z West LLC · Alpine, WYBuilt 2004 · S/N 41045N230UBoard Of Regents · Norman, OKBuilt 2024 · S/N 4496587N230WAWing Nuts Fling Club Ltd · North Chesterfield, VABuilt 2013 · S/N 2229N230WJCenter Ice Scouting LLC · Crestwood, KYBuilt 2007 · S/N 2539N23138Donaldson Docks Inc · Estherville, IAS/N 32R-8529010N2313QRegistered aircraftBuilt 2010 · S/N 4636474N23152Wasserman Air LLC · Tustin, CABuilt 2023 · S/N 9189N2316KAverett University · Danville, VABuilt 2010 · S/N 2843683N2316XJnj Aviation Inc · Wilmington, DEBuilt 2010 · S/N 4636487N2317MHilton Head Flyers LLC · Liberty, SCBuilt 1977 · S/N 28-7816277N231CDPaton Neil E · Avila Beach, CABuilt 2001 · S/N 1125N231CMQet Aircraft Services LLC · Rancho Viejo, TXBuilt 2002 · S/N 4697146N231DSFolkvord Svein · Brighton, MIBuilt 2007 · S/N 40.830
Back to AD 2008-06-28 R1