OpenAirDocs.org
AD 2008-06-28 R1

Registered aircraft · 16,295

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.

N146AFIn A Bind LLC · Conway, SCS/N 8727N146DB4405 LLC · Jenks, OKBuilt 1999 · S/N 3257100N146DMValiair Lc Trustee · Casper, WYBuilt 2024 · S/N 10233N146GSKyser LLC · Wilmington, DEBuilt 2007 · S/N 2393N146JJValiair Ltd Co Trustee · Casper, WYBuilt 2002 · S/N 1265N146JPMartin John A · Grand Prairie, TXBuilt 2005 · S/N 40.481N146NCHills Jason · Bothell, WABuilt 1998 · S/N 4636176N146PTCoco Aircraft Inc · Merritt Island, FLBuilt 1979 · S/N 28-7916307N146RFValiair Limited Co Trustee · Casper, WYBuilt 2011 · S/N 4636502N146SBN146sb LLC · Vienna, VABuilt 2007 · S/N 2574N146TSMile-High Enterprises LLC · Wilmington, DEBuilt 2008 · S/N 40.970N146WTLevanders Aircraft II LLC · Grand Island, NEBuilt 2002 · S/N 0324N146XBrown Scott D · Bushnell, FLBuilt 2003 · S/N 3232010N1473KTailwinds Aviation LLC · Punta Gorda, FLBuilt 2007 · S/N 41773N147GArcher Aero LLC · Wilmington, DEBuilt 2019 · S/N 2881111N147GTFlying W Aviation LLC · Bossier City, LABuilt 2004 · S/N 1069N147KB1869 Holding Inc Owner Trustee · Wilmington, DEBuilt 2006 · S/N 1869N147LD1944 Holding Inc Trustee · Wilmington, DEBuilt 2004 · S/N 0937N147LKSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2005 · S/N 1687N147MDDym Flights LLC · Pembroke Pines, FLBuilt 2025 · S/N 10839N147PBGrh Inc · Wilmington, DEBuilt 2005 · S/N 1291N147PGAscent Aviation Inc · Duluth, MNBuilt 2008 · S/N 1918N147SPollock Aviation LLC · Clinton, OHBuilt 2022 · S/N 8699N147VC0689 Holdings Inc Trustee · Wilmington, DEBuilt 2003 · S/N 0689N147WLRj Aviation LLC · Linden, CABuilt 2005 · S/N 1454N1486HLynn John · Coffee Creek, MTS/N 28-7716026N1487CDuley Brian · Lago Vista, TXBuilt 2003 · S/N 0571N1488HDeplazes Anthony · Rugby, NDS/N 28-7716027N148AParagon Flight Training Co · Fort Myers, FLBuilt 2025 · S/N 28020203N148CDAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2000 · S/N 1044N148CZJ5 Aviation LLC · San Diego, CABuilt 2012 · S/N 3888N148FCDepartment Of Agriculture & Consumer Scvs · Tallahassee, FLBuilt 2022 · S/N 2881520N148KMRstl LLC · Minster, OHS/N 28-7990342N148LHFarmingdale State University · Farmingdale, NYBuilt 2003 · S/N 2842191N148MBRosenberg Benjamin E · Mantoloking, NJBuilt 2024 · S/N 10291N148SWHess Daniel A · Cookeville, TNBuilt 2004 · S/N 0987N148TSLazy Dog Aviation LLC · North Myrtle Beach, SCBuilt 2005 · S/N 1451N148TTBoard Of Trustees Western Michigan University · Battle Creek, MIBuilt 2018 · S/N 4496428N1490CCloudsurfers LLC · Goreville, ILBuilt 2003 · S/N 0507N1490HKoepke Jeffrey J · Waterford, WIS/N 28-7790316N1490WTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1976 · S/N 28-7690282N1492CArrow Aviation Partners LLC · Crown Point, INBuilt 2003 · S/N 0567N149CKValiair Limited Co Trustee · Casper, WYBuilt 2009 · S/N 3388N149DQuilliam Kevin · Arnold, MDBuilt 2004 · S/N 0835N149LBWilde Timothy · Biloxi, MSBuilt 2008 · S/N 411064N149LHFarmingdale State University · Farmingdale, NYBuilt 2003 · S/N 2842192N149MMJsk Leasing LLC · Valparaiso, INBuilt 2008 · S/N 4692046N14ANFreedom Okc Aircraft LLC · Oklahoma City, OKBuilt 2024 · S/N 10065N14BCSrdo Advanced Wound Care Associates Pllc · Dallas, TXS/N 4636014N14DHDenisenkov Dmitry · Seattle, WABuilt 2008 · S/N 3000
Back to AD 2008-06-28 R1