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.

N2480VLyons Emily A · Homewood, ALBuilt 1985 · S/N 28-8590075N2485XLostetter Evan · Bakersfield, CABuilt 1985 · S/N 28-8516069N2488MMeads Rodney L · Camden, NCBuilt 1977 · S/N 28-7816289N2488PPs Engineering Inc · Lenoir City, TNBuilt 1999 · S/N 2843282N248AMDesfosse Donald J Trustee · Andover, MABuilt 1996 · S/N 3246054N248APRegistered aircraftBuilt 2006 · S/N 42541N248ASLlama Cirrus LLC · Concord, MABuilt 2017 · S/N 4537N248CBCalifornia Baptist University · Riverside, CABuilt 2017 · S/N 2881003N248CDTroiano Mark Q · Port Orange, FLBuilt 2001 · S/N 1148N248CGStahura Conveyor Products Inc · Lewisville, NCBuilt 2001 · S/N 0092N248CPSomerville Derek J · Murray, KYBuilt 2006 · S/N 1736N248DAJb Air Services LLC · Brighton, COBuilt 2003 · S/N 4697156N248DGWhinery Kevin D · La Habra, CABuilt 2005 · S/N 1359N248DMMontana 248dm LLC · Kalispell, MTBuilt 2002 · S/N 0374N248DSMichiana Air Activities Inc · Osceola, INBuilt 2011 · S/N 40.1118N248GFollett Enterprises LLC · Vlg Of Lakewd, ILBuilt 2005 · S/N 1261N248JSBergeson Aviation Enterprises LLC · Superior, COBuilt 2020 · S/N 2640N248LKTwelve Forty-Eight Aviation LLC · Camden, DEBuilt 2025 · S/N 10819N248MGGeorgia Aviation Authority · Eastman, GABuilt 2024 · S/N 2881711N248PCTrident Aircraft Inc · Easton, MDBuilt 2015 · S/N 2287N248PZPapa Zulu LLC · Belmont, MABuilt 2025 · S/N 10569N248RGVisionx Transportation Inc · Glendale, CABuilt 2015 · S/N 2277N248SGSierra Golf Aviation LLC · Branchburg, NJBuilt 2025 · S/N 10876N248SHWaldron Aviation LLC · Fort Lauderdale, FLBuilt 2002 · S/N 0146N248TFVisionary Holdings LLC · Missoula, MTBuilt 2025 · S/N 4496613N2490MDmld Corp · Wilmington, DEBuilt 1977 · S/N 28-7890254N2490YSheboygan Flight Plane III LLC · Sheboygan, WIBuilt 1985 · S/N 28-8590077N2494MJbbs Enterprises Inc · Middletown, DEBuilt 1977 · S/N 28-7890255N249CPearson Aviation LLC · Montoursville, PABuilt 2008 · S/N 4692023N249CBCalifornia Baptist University · Riverside, CABuilt 2023 · S/N 2881636N249CKCarolina Landing LLC · Cambridge, MDBuilt 2003 · S/N 0766N249DSMountain Aviation LLC · Salem, VABuilt 2002 · S/N 40.249N249FBK4m Aviation LLC · Marksville, LABuilt 1999 · S/N 4636221N249JAEagle Aviation LLC · Indianapolis, INBuilt 2021 · S/N 28020028N249MGGeorgia Aviation Authority · Eastman, GABuilt 2024 · S/N 2881712N249NDPlane Nonsense Inc · Middletown, DEBuilt 1999 · S/N 2842059N249TMSchellberg Steven A · Port Matilda, PABuilt 2003 · S/N 1333N249WFWifa (Washington International Flight Academy) LLC · Gaithersburg, MDBuilt 1976 · S/N 28-7690114N249WM249 Aviation LLC · Richland, MSBuilt 1975 · S/N LW-139N249WSSmith Charles L III · Petaluma, CABuilt 2004 · S/N 0975N24AWalker John D · Neosho, MOBuilt 1976 · S/N LW-210N24ATBobwhite Aviation LLC · Atlanta, GABuilt 2019 · S/N 4768N24CAWoodford Aviation Inc Trustee · Wilmington, DEBuilt 2023 · S/N 9318N24CRTop Flying LLC · Dover, DEBuilt 2008 · S/N 2923N24EBRfto LLC · Carthage, ILBuilt 2026 · S/N 11267N24EERomana Mathieu G · Miami Springs, FLBuilt 2008 · S/N 3276N24EGParent Claude · Austin, TXBuilt 2020 · S/N 4877N24ENEkman Co LLC · Chapin, SCBuilt 2019 · S/N 4769N24KXGuiot Laurent P · Culver City, CABuilt 2015 · S/N 2278N24LFPro Star Aircraft Sales LLC · Londonderry, NHBuilt 2023 · S/N 9549
Back to AD 2008-06-28 R1