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.

N345MJM & M Aero LLC · Half Moon Bay, CABuilt 2024 · S/N 9761N345PGN345pg LLC · Chicago, ILBuilt 2001 · S/N TH-2016N345PKWatch Ya Head Aviation I LLC · Zionsville, INBuilt 2020 · S/N 2192N345TFWilkinson Mark A · Lincoln, MABuilt 2004 · S/N 29-0345N345TSUncle Bob Consulting LLC · Antioch, ILBuilt 2005 · S/N 1569N345USAvion Solutions Group LLC · Apex, NCBuilt 2005 · S/N 29-0403N345WLMillionair Ride LLC · San Antonio, TXBuilt 2022 · S/N 8724N345WZEntroair LLC · Hilliard, OHBuilt 2021 · S/N 5028N345XWjd Aviation LLC · Gadsden, ALBuilt 2019 · S/N 1958N346CHAce Flight Center Inc · St Thomas, VIBuilt 1979 · S/N 402C0029N346DWValiair Lc Trustee · Casper, WYBuilt 1979 · S/N 340A0742N346ENorth Coast Aeronautical LLC · Cleveland, OHBuilt 1984 · S/N EA-409N346FSRichard C Reed · Snyder, TXS/N 340A0790N346MCSkyway Aviation LLC · Purvis, MSS/N 340A-0425N346RNSchroll Charles E · Tucson, AZBuilt 1969 · S/N P206-0567N3473GThayer John P · Columbus, GABuilt 1976 · S/N 310R0847N347AAci Aviation Holdings LLC · Abbeville, LABuilt 2017 · S/N 1541N347ABTropical Transport Services Ltd Inc · San Juan, PRBuilt 1980 · S/N 402C0347N347CDCulkin Daniel J Trustee · Edmond, OKBuilt 2005 · S/N 1360N347CPNwr Aviation LLC · Scottsdale, AZBuilt 2008 · S/N 3044N347DCSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2015 · S/N 1104N347JADepete Joseph G · Louisville, KYBuilt 1978 · S/N 340A0448N347SRVenture North Aviation LLC · Cloquet, MNBuilt 2007 · S/N 2575N348ATCharitable Giving Center · Las Vegas, NVBuilt 2010 · S/N 0023N348BWRegina Miller Group Inc · Santa Monica, CABuilt 2025 · S/N 11016N348CD348 Charlie Delta LLC · Ames, IABuilt 2007 · S/N 2389N348LCChannel Larry E · Las Cruces, NMBuilt 2015 · S/N L2K-212N348SBVector Victor Aviation LLC · Geneva, ILBuilt 2019 · S/N 4824N348TSTuchman Holdings LLC · Englewood, NJBuilt 2011 · S/N 3800N3494QRodcon Aircraft Sales LLC · Kalispell, MTBuilt 1967 · S/N 320E-0094N349RFPhase 2 Ventures LLC · Seattle, WABuilt 2003 · S/N ES-102-FBN349RPMiranda Gary R · Vancouver, WABuilt 1998 · S/N E-3202N34ADPremiere Aviation Inc · Concord, CABuilt 1975 · S/N 421C-0036N34AHElastapro Silicone Sheeting LLC · Santa Fe Springs, CABuilt 2024 · S/N 9783N34ALVy Strategies LLC · Dublin, GABuilt 2017 · S/N 1516N34AWValiair Lc Trustee · Casper, WYBuilt 1976 · S/N 340A0097N34BTWilliams Charles R · Wadsworth, OHBuilt 1973 · S/N 21060130N34CDCannon David A · Magnolia, TXBuilt 2002 · S/N 0148N34CKJaycox Chad Trustee · Venice, FLBuilt 2023 · S/N 9144N34DBRegistered aircraftBuilt 2003 · S/N 29-0300N34FRFront Runner Capital LLC · Newark, DEBuilt 2024 · S/N 9945N34GCPhillips Stuart G · Woodside, CABuilt 1982 · S/N EA-283N34KBReilly Donald H · Micco, FLBuilt 1978 · S/N 21062656N34KFRsb Properties LLC · Lewes, DES/N P21000700N34KMBravo Adventures LLC · Scottsdale, AZBuilt 1981 · S/N EA-207N34NYKeys Robert · Menifee, CABuilt 1973 · S/N 340-0196N34RInfinity Welding And Fabrication LLC · Celina, TXBuilt 2002 · S/N L2K-174N34TGTri W Inc · Shepherd, MTBuilt 2002 · S/N 0386N34TLAmeagle Aviation LLC · Coventry, CTBuilt 1977 · S/N 340A0423N34TNCirrus Sr22t 10713 Inc Owner Trustee · Wilmington, DEBuilt 2025 · S/N 10713
Back to AD 2012-10-13