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.

N142FCDepartment Of Agriculture & Consumer Services · Tallahassee, FLBuilt 1982 · S/N 28-8290177N142KMDearing Michael P · Anderson, TXBuilt 2008 · S/N 411082N142LHFarmingdale State University · Farmingdale, NYBuilt 2003 · S/N 4496177N142NDSkyblue Aviation Cr Inc · Merritt Island, FLBuilt 1989 · S/N 2841229N142SFN142sf LLC · Scottsdale, AZS/N 1527N1432CKnoxville Flyers Inc · Knoxville, TNBuilt 2003 · S/N 1332N1438TFreedom Flyers II LLC · Islip, NYBuilt 2014 · S/N 4636615N1439CRempler David · Chandler, AZS/N 41618N143CGavin Lauren Aviation LLC · Miami, FLBuilt 2008 · S/N 3224N143CDCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11353N143DEAac 585 LLC · Kennesaw, GABuilt 1979 · S/N BB-585N143FCDepartment Of Agriculture & Consumer Services · Tallahassee, FLBuilt 1982 · S/N 28-8290178N143LAMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 2009 · S/N 4636459N143PPBolch James R · Vero Beach, FLBuilt 2015 · S/N 4636664N143RJDelta Tango Aviation LLC · Saint Louis, MOBuilt 2003 · S/N 1276N143SBRegistered aircraftBuilt 2012 · S/N 2219N143TERegistered aircraftBuilt 2007 · S/N 1884N143TJFlying J Aero LLC · Hinsdale, ILBuilt 2005 · S/N 40.591N143TTJ&W Outdoors LLC · Modesto, CABuilt 2010 · S/N 411154N1440UPiper Aircraft Inc · Vero Beach, FLBuilt 2025 · S/N 28020248N1442EMt Zephyr Enterprises LLC · Yorktown, VABuilt 2006 · S/N 41698N1443TGrasso John A · Mount Laurel, NJBuilt 2007 · S/N 42534N1444NTruair LLC · Wilmington, DEBuilt 2007 · S/N 41764N14456Waller Harley Tp · Boston, MABuilt 2006 · S/N 41679N1445HNelson Joshua M · Eagle, IDBuilt 1999 · S/N 3257092N1446CFour Six Chuck LLC · Maynard, MABuilt 2003 · S/N 0480N1447CAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 2003 · S/N 0498N144AMStardust Aviation LLC · Farmingdale, NYBuilt 2021 · S/N 28020016N144CTCti Aircraft Leasing LLC · Memphis, TNS/N 2881298N144HPButler Christopher E · Fort Lauderdale, FLBuilt 2008 · S/N 4692044N144JKLong Island Aviators LLC · Seaford, NYBuilt 1981 · S/N 34-8133010N144LCPruetts Food Inc · Broken Bow, OKBuilt 2004 · S/N 41019N144RUG&M Aircraft Inc · Wheat Ridge, COBuilt 1979 · S/N 44-7995323N144TEEhlenbach Aviation LLC · Kildeer, ILBuilt 2007 · S/N 2507N1452WMaxair LLC · Appleton, WIBuilt 2006 · S/N 41584N1454DCavu Aircraft LLC · Olympia, WABuilt 2007 · S/N 41743N1457CHillen Air Corp · Dothan, ALBuilt 2003 · S/N 0547N145AJKearns William A · Spokane, WABuilt 2006 · S/N 2082N145ARPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010047N145AWSteere Anna · New Albany, OHBuilt 2004 · S/N 1402N145CDLyons Timothy Covington Michael Palomo · Rotterdam Junction, NYS/N 1020N145EJKovamees Carl · Middleton, MAS/N 3383N145LYQuarter To Two Flying Club Inc · Williamsport, PABuilt 2000 · S/N 28-43335N145PGBurns James J · East Greenwich, RIBuilt 2008 · S/N 1916N145SRTiger Jones Aircraft Inc · Tampa, FLBuilt 2022 · S/N 9010N145WWWings Over Texas Holdings LLC · Denton, TXBuilt 2002 · S/N 4496145N1461HJohnson Kent W · Clemons, IAS/N 28-7790313N1463CLatta Lutz M · San Francisco, CABuilt 2003 · S/N 1356N1468CBruegman Colt Trustee · Wheatland, WYBuilt 2003 · S/N 0574N1469WIrwin Alfred Homer · Lizella, GABuilt 2007 · S/N 41733
Back to AD 2008-06-28 R1