AD 2012-10-13

Registered aircraft · 13,306

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.

N776BRWillow Tree Tennessee LLC · Lakeland, TNBuilt 2019 · S/N 1904N776BWN776bw LLC · Alpine, WYBuilt 2022 · S/N 8986N776CDTriple Crown Aviation LLC · Las Vegas, NVBuilt 2004 · S/N 1039N776CMNewman Air LLC · Sherborn, MABuilt 1998 · S/N 1N776DSullivan Dennis · Santa Ana, CABuilt 1969 · S/N D-9063TN776DADavisair Inc · Raleigh, NCBuilt 1993 · S/N TH-1697N776DNPdn Aviation LLC · West Chester, PABuilt 2026 · S/N 11262N776JDSr22 LLC · Chubbuck, IDBuilt 2017 · S/N 1567N776JEJde Higher Cause LLC · Jenison, MIBuilt 2025 · S/N 11108N776PMHoudashell Investments LLC · Amarillo, TXS/N 3480N776TMAero Performance LLC · Scooba, MSBuilt 1976 · S/N 21061480N776XBere Matthew Robert · Dallas, TXBuilt 2015 · S/N 1016N776YDRapp Larry · Elbow Lake, MNBuilt 1988 · S/N E-2463N7772LJerez John J · Bonita, CABuilt 1996 · S/N 29-0093N7772TVista Haven Leasing LLC · San Antonio, TXBuilt 2022 · S/N 8615N7773HCirrus 7773h LLC · Wilmington, DEBuilt 2003 · S/N 0723N7774BAdair Aviation LLC · Broken Arrow, OKBuilt 1981 · S/N U20606224N7774PBlack Scorpion LLC · Helena, MTBuilt 1997 · S/N LIV-072N7774ZLaw Office Of Yossi Noudel · Encino, CABuilt 2005 · S/N 1345N7776HAcevedo Adriel · San Antonio, TXBuilt 1976 · S/N 21061194N7776TBlue Horizons Holdings LLC · Wilmington, DEBuilt 2012 · S/N 0387N77770Bredder Brett A · Brighton, COS/N 320D0058N7778GDgt Management Company LLC · New Bern, NCBuilt 2015 · S/N 1145N7778TTayara LLC · Durham, NCBuilt 2013 · S/N 0507N7779XNorcal Flight Services LLC · Palo Alto, CABuilt 2014 · S/N 3RX126N777AJV-R Holdings LLC · Sauget, ILBuilt 2008 · S/N 3132N777AVOverwatch Aero LLC · Santa Maria, CABuilt 2012 · S/N 0278N777BMJet Air Of South Florida Inc · Deerfield Beach, FLBuilt 1978 · S/N 21063156N777CL777cl Aviation LLC · Sheridan, WYBuilt 2019 · S/N 4758N777DPittsburgh Institute Of Aeronautics · West Mifflin, PABuilt 1981 · S/N 340A-1257N777DLShamrock Kelly Energy Inc · Blanco, TXBuilt 1979 · S/N P21000373N777EConner Ernest A · Dallas, TXBuilt 1981 · S/N TJ-347N777EVSelldorff John · Chatham, MABuilt 1990 · S/N E-2520N777FYQualitair LLC Trustee · ChelstadtBuilt 1979 · S/N P21000276N777GBFc Sr Capital LLC · Anaheim, CABuilt 2018 · S/N 4637N777GVPerry Robert A · Tucson, AZBuilt 2002 · S/N 0235N777HSJohnson Erik L · Long Beach, CABuilt 1975 · S/N 21060835N777JJh Industries Inc · Fort Mohave, AZS/N 0344N777MGreen Airplane LLC · Denver, COBuilt 2018 · S/N 1811N777MYGraham Elmer R Jr · Graford, TXBuilt 2000 · S/N E-3328N777NHS And S Airlink · Troy, MIBuilt 1978 · S/N 340A-0415N777NKTaylor Jonathan K II · Granbury, TXBuilt 1996 · S/N E-2996N777NLOrthoair LLC · Union City, TNBuilt 2007 · S/N 2885N777PCPhase Three Marketing LLC · Helena, MTBuilt 2002 · S/N LIV-481-PN777PSSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2001 · S/N 0097N777RPParis Air Conditioning Co · Paris, TXBuilt 1974 · S/N 414-0636N777RYMacair Aviation LLC · Xenia, OHBuilt 2003 · S/N 0777N777VMiso Enteprises LLC · Wilmington, DES/N 310R0267N777VBArizona Thunderbolts LLC · Scottsdale, AZBuilt 1992 · S/N EA-539N777VFZammit Flight Resources LLC · Sheridan, WYBuilt 1977 · S/N 414-0946
Back to AD 2012-10-13