AD 2012-10-52

Registered aircraft · 2,750

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-52')
    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-52')
  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.

N1276AAir Land Ventures 3 LLC · Berwyn, PABuilt 2007 · S/N T20608794N127JEGillian Michael · Batavia, ILBuilt 2006 · S/N T20608678N1289UKavak Air Inc · Middletown, DEBuilt 1982 · S/N 21064682N1296MThacker Thomas L Trustee · Hurricane, UTBuilt 2008 · S/N T20608803N129ELTrooien-Smith Construction LLC · Seeley Lake, MTBuilt 1978 · S/N U20604374N12DUWoodtick Summit Aviation LLC · Redmond, ORBuilt 1979 · S/N U20605202N12PFRucker Gary R · Kingman, AZBuilt 1977 · S/N 21062401N1301LFox Aircraft LLC · Bethel, AKBuilt 1980 · S/N 20700641N130CPCivil Air Patrol · Maxwell Afb, ALBuilt 2014 · S/N T20609133N130DWAttoyac Air LLC · Gonzales, TXBuilt 2021 · S/N T20609662N130SJAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1999 · S/N T20608130N131DTAerownership North American Services Inc Trustee · Wilmington, DEBuilt 2017 · S/N T20609239N131TTCharlie Kilo Enterprises Inc · Melbourne, FLBuilt 1979 · S/N U20605010N1323DEl LLC · Center, COBuilt 2008 · S/N T20608805N1327EDeguerin Dick · Houston, TXBuilt 2006 · S/N T20608689N1327KLoveland Aviation LLC · Scottsdale, AZBuilt 2006 · S/N T20608690N13291Conspec Inc · Wichita, KSBuilt 2006 · S/N T20608694N1330GNorth Plains Honey Co LLC · Bozeman, MTBuilt 2006 · S/N T20608696N1331MRegistered aircraftBuilt 1985 · S/N 21064903N135GVreeland Equipment Rental LLC · Dayton, OHBuilt 1999 · S/N T20608077N135TSN135ts LLC · Lima, OHBuilt 2003 · S/N T20608413N13709Personal Wings Inc · San Diego, CABuilt 2007 · S/N T20608706N137TSArk Aviation LLC · Moncks Corner, SCBuilt 2003 · S/N T20608415N139BBTrejo Nahomy · Socorro, TXBuilt 1979 · S/N 21063712N13KSNolt Ivan · Mount Solon, VABuilt 1974 · S/N 21060202N13TNMcdaniel Robert M · Tonasket, WABuilt 1977 · S/N 21062428N13WNRegistered aircraftBuilt 2026 · S/N T20609838N1410URuffcorn Aviation Co · Bettondorf, IABuilt 1982 · S/N 21064693N141CPCivil Air Patrol · Maxwell Afb, ALBuilt 2014 · S/N T20609135N1423WMaricopa County Sheriffs Office · Phoenix, AZBuilt 2014 · S/N T20609150N143GBDocinator Aviation LLC · Edmond, OKBuilt 2012 · S/N T20609047N143GMNby Productions · Bristow, VABuilt 2010 · S/N T20608971N143GSPxw Services · Bristow, VABuilt 2010 · S/N T20608970N1447LHall Daniel W · Westlake Village, CABuilt 2008 · S/N T20608815N144GRegistration Pending · Waco, TXRegistration pendingBuilt 2020 · S/N T20609598N144WPDresel Av LLC · Fayetteville, ARBuilt 1973 · S/N 21059900N1450CFreeland Christopher G · Brownwood, TXBuilt 1970 · S/N T21059318N1458HMosle Air LLC · Far Hills, NJBuilt 2007 · S/N T20608765N1460TJlj Aviation LLC · Amarillo, TXBuilt 2007 · S/N T20608767N147GWAllen Air LLC · Creola, ALBuilt 2011 · S/N T20609022N147PASetki Air LLC · Wilmington, DEBuilt 2024 · S/N T20609772N147SASteeda Autosports Inc · Pompano Beach, FLBuilt 2014 · S/N T20609155N147TXTexas Department Of Transportation · Austin, TXBuilt 1979 · S/N U20604987N1488TTanana Leasing LLC · Fairbanks, AKS/N T20608541N148DWVantage Aviation USA LLC · Tampa, FLBuilt 2013 · S/N T20609091N1494CFour C'S Equipment Leasing LLC · Fresno, CABuilt 1978 · S/N 21063065N149DWRbf Aero · Wilmington, DEBuilt 2013 · S/N T20609097N14JEN14je LLC · White Springs, FLBuilt 1975 · S/N 21060792N14NNAms Aviation LLC · South Bend, INBuilt 1980 · S/N U20605374N14WLTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N T20609857
Back to AD 2012-10-52