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.

N245TFAir Fleet Holdings LLC · Addison, TXBuilt 2024 · S/N 4496595N245TPStrable Sam · Cecil, OHBuilt 1999 · S/N 2843301N245WCAbsolutes LLC · Arlington, VABuilt 2026 · S/N 11363N245WPEberhard Air LLC · Venice, CABuilt 2019 · S/N 4840N2460QHamilton Aviation Group LLC · Lula, GABuilt 1977 · S/N 28-7790398N2460UAccelerated Aviation Instruction LLC · Owatonna, MNBuilt 1979 · S/N 28-8090048N2461QJessi Air Ltd · West Salem, OHBuilt 1977 · S/N 28-7790399N2464WOktela Steven L · Melbourne, FLS/N 3213093N2466GIreland Jeffrey L · Shobonier, ILBuilt 2004 · S/N 1244N2468SStolen Hours LLC · Sanford, NCBuilt 2004 · S/N 1090N246ADBialas Robert E II · Fort Worth, TXBuilt 1968 · S/N 28R-30423N246BJJas Aviation LLC · East Hartford, CTBuilt 2005 · S/N 1438N246BSCk Leasing Services LLC · Wilmington, DEBuilt 2016 · S/N 2324N246CBCalifornia Baptist University · Riverside, CABuilt 2017 · S/N 2881002N246CDPlane Advantage LLC · Canton, OHBuilt 2001 · S/N 1147N246CMHarmon David · Abilene, TXBuilt 2013 · S/N 3929N246DBOps Check LLC · Niceville, FLS/N 2704N246DXAndiamo Ten LLC · Cleveland, TNS/N 3105N246EMRjmr Capital Holdings LLC · Tyler, TXBuilt 2020 · S/N 4913N246FAInternational Air Services Inc Trustee · Carson City, NVS/N 1153N246FBFb Management LLC · Plymouth Meeting, PABuilt 2025 · S/N 10800N246GMSky Scrapers LLC · Derry, NHBuilt 2002 · S/N 0260N246LRegistered aircraftBuilt 2023 · S/N 4636825N246MTKolquist Consulting LLC · Hermantown, MNBuilt 2003 · S/N 0760N246NDGlobal Aviation Corp · Farmingdale, NYBuilt 1999 · S/N 2842056N246PLRff Holdings LLC · Paris, MOBuilt 2023 · S/N 9219N246PTShultz L Edward · Brentwood, TNBuilt 2017 · S/N 4505N246TJLally Glen Joseph · Pleasanton, CAS/N 0382N246TLVoler Vy LLC · Morristown, NJBuilt 2022 · S/N 8819N246TWMr Dent Inc · Manheim, PAS/N 0725N2471USchroeder Nyla R · Minneapolis, MNBuilt 1979 · S/N 28-8090049N2473WCahill Chad · Edmond, OKBuilt 1985 · S/N 28-8590073N2473YFunderburg Erskine R · Pell City, ALBuilt 1985 · S/N 28-8590074N2476MPremier Flight Center LLC · Hartford, CTBuilt 1977 · S/N 28-7816286N2477SAverett University · Danville, VABuilt 2012 · S/N 2843700N2478VKozura Ronald J · Pine Grove, PABuilt 1985 · S/N 28-8516057N247CDMiddle Tennessee State University · Murfreesboro, TNBuilt 2014 · S/N 40.1193N247CPTl Sierra Properties LLC · Mammoth Lakes, CABuilt 2008 · S/N 3166N247DMGrimmett Lester · Clinton, MSBuilt 2005 · S/N 41506N247DSNetwork Spares LLC · Wilmington, DEBuilt 2011 · S/N 40.1117N247ESBank Of Utah Trustee · Salt Lake City, UTBuilt 2024 · S/N 9898N247GMSijan LLC · Marriottsville, MDBuilt 2022 · S/N 8753N247LVRlv Aviation LLC · Valdosta, GABuilt 2025 · S/N 10854N247MCGray Gary Mario DBA · Tampa, FLBuilt 2008 · S/N 411060N247MGGeorgia Aviation Authority · Eastman, GABuilt 2024 · S/N 2881710N247PCSky Pilot LLC · Naples, FLBuilt 2015 · S/N 2286N247SRPsalmbird Aviation LLC · Ormond Beach, FLBuilt 2007 · S/N 2457N247TFVisionary Holdings LLC · Missoula, MTBuilt 2025 · S/N 4496612N247TJNicholas Sol · Colorado Springs, COBuilt 2014 · S/N 4697561N247TSCrosswind Aviation LLC · Enid, OKBuilt 2015 · S/N 4280
Back to AD 2008-06-28 R1