OpenAirDocs.org
AD 2012-10-13

Registered aircraft · 13,307

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:2012-10-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-10-13')
  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.

N144GPIzquierdo Javier · Navasota, TXBuilt 2012 · S/N ES-217N144JCJackson Construction Aviation LLC · Quitman, TXBuilt 1977 · S/N 340A0360N144LCPruetts Food Inc · Broken Bow, OKBuilt 2004 · S/N 41019N144PTHill Howard H Trustee · Portage, WIBuilt 1990 · S/N E-2553N144TDDahlberg Thomas K · Belvidere, ILBuilt 1999 · S/N E-3289N144TEEhlenbach Aviation LLC · Kildeer, ILBuilt 2007 · S/N 2507N144WPDresel Av LLC · Fayetteville, ARBuilt 1973 · S/N 21059900N1450CFreeland Christopher G · Brownwood, TXBuilt 1970 · S/N T21059318N1457CHillen Air Corp · Dothan, ALBuilt 2003 · S/N 0547N1457MStevenson William E · Sutton, AKBuilt 1970 · S/N U20601457N145AJKearns William A · Spokane, WABuilt 2006 · S/N 2082N145EJKovamees Carl · Middleton, MAS/N 3383N145JGGeldermann Bert E · Friday Harbor, WABuilt 2005 · S/N L2K-230N145SRTiger Jones Aircraft Inc · Tampa, FLBuilt 2022 · S/N 9010N145TTVenture Air Solutions Inc · Dallas, GABuilt 1977 · S/N 402B1333N1468CBruegman Colt Trustee · Wheatland, WYBuilt 2003 · S/N 0574N146BUSaltwater Aviation LLC · Friday Harbor, WABuilt 1984 · S/N 46-8408057N146DMValiair Lc Trustee · Casper, WYBuilt 2024 · S/N 10233N146GSKyser LLC · Wilmington, DEBuilt 2007 · S/N 2393N146LLRichard Richard D · Broussard, LABuilt 2009 · S/N 222N146MSMagnolia Partners Aviation LLC · Lockesburg, ARBuilt 1984 · S/N 46-8408032N146SBN146sb LLC · Vienna, VABuilt 2007 · S/N 2574N146TAShamash Micah I · Larkspur, COBuilt 1980 · S/N EA-176N146VBHappyface246vb LLC · Hollywood, FLBuilt 2018 · S/N T24002146N146WTLevanders Aircraft II LLC · Grand Island, NEBuilt 2002 · S/N 0324N146ZUtah State University · Logan, UTBuilt 1982 · S/N TJ-426N146ZFNo Boundry Airplane LLC · Council Bluffs, IABuilt 1984 · S/N 46-8408002N147DTGabriella Elena Inc · Winnetka, ILBuilt 1998 · S/N E-3163N147GTFlying 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 1291N147PWBarr Tammy D · Spicewood, TXBuilt 2001 · S/N E-3420N147TXTexas Department Of Transportation · Austin, TXBuilt 1979 · S/N U20604987N147VC0689 Holdings Inc Trustee · Wilmington, DEBuilt 2003 · S/N 0689N147WDDarroh Harold W · Richmond, TXBuilt 1979 · S/N TK-102N147WLRj Aviation LLC · Linden, CABuilt 2005 · S/N 1454N1487CDuley Brian · Lago Vista, TXBuilt 2003 · S/N 0571N148BDMaroon Mountain Aviation LLC · Edwards, COS/N 0369N148CPKnepper Andrew M · Woodville, OHBuilt 2019 · S/N 1994N148CZJ5 Aviation LLC · San Diego, CABuilt 2012 · S/N 3888N148DSEast Ramp Aviation LLC · Baton Rouge, LABuilt 1986 · S/N TH-1439N148LCJ W Venture Aviation LLC · Concord, NCBuilt 2010 · S/N 0048N148MBRosenberg Benjamin E · Mantoloking, NJBuilt 2024 · S/N 10291N148MDPodaddy Enterprises LLC · Acworth, GABuilt 2017 · S/N 1480N148SWHess Daniel A · Cookeville, TNBuilt 2004 · S/N 0987N148TSLazy Dog Aviation LLC · North Myrtle Beach, SCBuilt 2005 · S/N 1451N1490CCloudsurfers LLC · Goreville, ILBuilt 2003 · S/N 0507
Back to AD 2012-10-13