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.

N725WTJ&E Adventures LLC · Conroe, TXBuilt 2024 · S/N 10099N726BWBoberts LLC · Beach Lake, PABuilt 2010 · S/N 4636478N726CCStk Flight LLC · New Palestine, INBuilt 2006 · S/N 1848N726CDCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11544N726DFTactical Aviation LLC · Brownstown, MIBuilt 1981 · S/N 28-8216023N726DNNelson Aero LLC · East Helena, MTBuilt 2006 · S/N 41684N726EGAtterrissage LLC · Healdsburg, CABuilt 2004 · S/N 1442N726KRE&E LLC · Johnston, IABuilt 2018 · S/N 4592N726NDUniversity Of North Dakota · Grand Forks, NDBuilt 2021 · S/N 2881488N726PBN411b LLC · Griffin, GABuilt 2017 · S/N 4551N726PDBuchanan Thomas Steven · Hilton Head Island, SCBuilt 2022 · S/N 8529N726PMAlpine View LLC · Williston, NDBuilt 2004 · S/N 0981N726TXKelk Air LLC · Wellington, FLBuilt 2009 · S/N 2028N726WAWestern Aircraft Inc · Boise, IDBuilt 2025 · S/N 4697726N726ZMission Park Air LLC · Marion, IABuilt 2016 · S/N 4357N727ACLong Island Aviators LLC · Seaford, NYBuilt 1977 · S/N 28-7890128N727BRN727br LLC · Winnetka, ILBuilt 2022 · S/N 8567N727CAPhenix Air LLC · Elberfeld, INBuilt 2026 · S/N 11233N727CCAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2007 · S/N 40.840N727CDN727cd LLC · Clearwater, FLBuilt 2001 · S/N 0021N727CEHuston Aviation LLC · Fort Worth, TXBuilt 2008 · S/N 4692064N727DEKennett Aerospace LLC · Kennett, MOBuilt 1978 · S/N 28-7816572N727GRParth Aviation LLC · Terre Haute, INBuilt 2006 · S/N 3246238N727HGShirin Aviation LLC · Los Angeles, CABuilt 2017 · S/N 4489N727JKSky 21 LLC · Lexington, NCBuilt 2020 · S/N 4926N727KWilliam L Schmidt Attorney At Law Pc · Fresno, CABuilt 1994 · S/N 4622178N727LFLanier Equipment Leasing LLC · Gainesville, GABuilt 1978 · S/N 44-7995197N727MTKryptonite Industries LLC · Golden, COBuilt 1978 · S/N LW-271N727MZLmb Aire LLC · Howell, MIBuilt 2004 · S/N 40.435N727PWSteven Bennett Trustee · Boise, IDBuilt 2004 · S/N 1196N727SPinnacle Aviation Services LLC · Key Largo, FLS/N 1316N727SLRegistered aircraftBuilt 2006 · S/N 1773N727SRMid-Way Regional 2023 LLC · Columbia Falls, MTBuilt 2007 · S/N 2613N727WDCorts Juanita · Baton Rouge, LABuilt 2005 · S/N 1569N727ZZScott Shawn R · Bluffton, SCBuilt 2005 · S/N 1590N728AMeridian Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843791N728BJBarefoot Boats LLC · Greensboro, GABuilt 2016 · S/N 4320N728CDKukeeza LLC · Williston, NDBuilt 2002 · S/N 1262N728DEMaximize It Consulting LLC · Mesa, AZBuilt 2007 · S/N 40.838N728NDUniversity Of North Dakota · Grand Forks, NDBuilt 2017 · S/N 2843886N728SJHighland Aviation LLC · Flagstaff, AZBuilt 1981 · S/N 32R8129011N728SMMasters In Flight LLC · Friday Harbor, WABuilt 2005 · S/N 41087N728SRSouthside Tire Co Inc · Antigo, WIBuilt 2007 · S/N 2546N728TBAtd Pilot Training LLC · Kansas City, MOBuilt 1978 · S/N 28-7816536N728WFReigh Galen R · Williamsburg, PABuilt 1979 · S/N 28-7916371N729AJEdwards 729aj LLC · Dublin, OHBuilt 2015 · S/N 4208N729CDOmega Skyways LLC · North Bethesda, MDBuilt 2001 · S/N 0025N729JRJbj Air Services LLC · Virginia Beach, VABuilt 2007 · S/N 2344N729JSJackson Christopher F · Vancouver, WABuilt 2004 · S/N 0819N729NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2018 · S/N 2881024
Back to AD 2008-06-28 R1