OpenAirDocs.org
AD 2008-06-28 R1

Registered aircraft · 16,284

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.

N888ADAlirio Land Services · Miami Gardens, FLBuilt 1968 · S/N 28R-30913N888AJFaraci Nick G · New York, NYS/N 0078N888BMDeverapalli Vishnu Reddy · Duluth, GABuilt 1977 · S/N 28-7890282N888BYAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 2007 · S/N 4697304N888CCStevens Terry L · New Plymouth, OHBuilt 1979 · S/N 28-7916324N888DNTravelsafely LLC · Columbia, MDBuilt 2008 · S/N 3122N888EJInternational Air Services Inc Trustee · Carson City, NVS/N 2816082N888EPValiair Lc Trustee · Casper, WYS/N 0190N888ETBank Of Utah Trustee · Salt Lake City, UTBuilt 1977 · S/N BB-258N888GMStevens Ryan · Presque Isle, MEBuilt 1977 · S/N 28-7716264N888HJAviation Company Inc · Cheyenne, WYBuilt 1979 · S/N BB444N888LVAllies Aviation LLC · Fort Walton Beach, FLBuilt 2016 · S/N 4355N888MEShah Aviation Enterprises LLC · Saint Augustine, FLBuilt 2017 · S/N 2374N888NMNational Machinery LLC · Tiffin, OHS/N 32R-8529012N888PKHimes Island Air LLC · Fairfax, VAS/N 4697062N888QCShipley Ryan Paul · Keller, TXBuilt 1977 · S/N 28-7716175N888SGBlairwood LLC · Akron, OHBuilt 2003 · S/N 0762N888SSRegistration Pending · Houston, TXRegistration pendingBuilt 2005 · S/N 1302N888SXDove Aviation LLC · Jackson, MSFirst renewal noticeBuilt 2017 · S/N 4466N888VFLiaboe Mark Osborne · Dubuque, IAS/N 34-8233073N888VPKokomo Aircraft Sales And Leasing LLC · Kokomo, INBuilt 1994 · S/N 3213073N888VTPam Aire LLC · Cedar Hill, TXBuilt 1968 · S/N 28R-30842N888WKSp Aviation LLC · Upper Brookville, NYBuilt 2026 · S/N 11470N888YBIdea Cooks LLC · Boulder, COBuilt 2006 · S/N 41668N888YMV1 Aviation LLC · Little Rock, ARBuilt 2005 · S/N 1437N888YWJoerithan & Mp Aviation LLC · Whittier, CABuilt 2006 · S/N 40.689N888ZLAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 2006 · S/N 2204N888ZTRev Aircraft LLC · Wilmington, DEBuilt 1978 · S/N LW315N8890FSchoenherr Aviation LLC · Washington, MIS/N 28-7790271N8892KKalche Aviation LLC · Baton Rouge, LABuilt 2001 · S/N 4697081N8899ERgp Aviation LLC · Wilmington, DES/N 28-7690215N889BLGranite Plane Lease Inc · Worcester, MABuilt 2008 · S/N 4697379N889DSTeton Avjet LLC · Driggs, IDBuilt 2007 · S/N 40.889N889LDSkydance Aviation LLC · Norfolk, VABuilt 2004 · S/N 1434N889MAFreedom Fund US LLC · Fort Lauderdale, FLBuilt 2016 · S/N 4697616N889NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2025 · S/N 4496602N889SRAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2006 · S/N 2130N889TJJenkins Thomas S · Beaufort, SCBuilt 2022 · S/N 8944N889TMEfusa Vii LLC · Glenwood Springs, COBuilt 2006 · S/N 2231N88BM350 Aviation LLC · Fort Lauderdale, FLBuilt 2004 · S/N 0798N88CEN3mf LLC · Lewes, DEBuilt 2006 · S/N 42536N88CRN88cr LLC · Davie, FLS/N 9432N88GWWav Series LLC · Batavia, ILBuilt 1980 · S/N 441-0187N88KKPilot Country Airport X05 LLC · Spring Hill, FLBuilt 2019 · S/N 4798N88LHTupper Aviation LLC · Jackson, NJBuilt 2025 · S/N 10947N88MTFlight Company LLC · Rome, GABuilt 1981 · S/N BB-830N88PGBoyer Joseph A · Knoxville, TNBuilt 1980 · S/N 32R-8013060N88QTOrthoairways LLC · Westlake, TXBuilt 1981 · S/N 441-0228N88RARusso Mark · Stevensville, MTBuilt 1996 · S/N 4636034N88SMAerox Aviation LLC · Holmdel, NJBuilt 2025 · S/N 10880
Back to AD 2008-06-28 R1