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.

N389TDParagon Air Group · Fort Worth, TXBuilt 2023 · S/N T20609727N38PFSycan Corp DBA · Paso Robles, CABuilt 1980 · S/N 21063979N390RSSchoene Edward C · Springfield Center, NYBuilt 1976 · S/N 21061514N391MState Of Montana Dept Of Natural Resources · Helena, MTBuilt 2025 · S/N T20609820N391PT7640 Drilling LLC · Amarillo, TXBuilt 1973 · S/N 21060097N3939GThree Niner Gulf L L C · Denver, COBuilt 1967 · S/N U206-0939N393DW3 Delta Whiskey LLC · Superior, WIBuilt 1979 · S/N U20605261N39501Jw & Jl Aviation LLC · Phoenix, AZBuilt 1982 · S/N U206-06452N395MEYqa Capital Management LLC · Murfreesboro, TNBuilt 2000 · S/N T20608233N3962GJoe Sanchez Farms Inc · Walnut Grove, CABuilt 1967 · S/N U206-0962N3968QTundra Wings Ministries · Wasilla, AKBuilt 1975 · S/N U20603037N397DJRickenbach Andreas N · Truckee, CABuilt 1967 · S/N U206-0881N397TCBravo & Bravo LLC · Greenville, MEBuilt 2003 · S/N T20608397N3992GFlat Earth LLC · Kalispell, MTS/N U2060992N3995GCutting Edge Design & Contracting-Sc Inc · Elgin, SCBuilt 1968 · S/N U206-0995N399KMCustodio Olga · San Antonio, TXBuilt 1973 · S/N 21059982N39BEAberdeen Flying Service · Aberdeen, SDBuilt 1984 · S/N 21064889N3BKTextron Aviation Inc · Wichita, KSS/N T20609882N3KKKraussman Daniel J · San Antonio, TXBuilt 1978 · S/N 21062752N402CPA & A Drug Co · Fremont, NEBuilt 2009 · S/N T20608923N405DBSn 0048 LLC · Wilmington, DEBuilt 2006 · S/N T20608622N408EBNby Productions · Bristow, VABuilt 2021 · S/N T20609650N40PWCrowther Sally Elliott · Kirkland, WABuilt 2019 · S/N T20609586N4102LWiplinger Robert D · Inver Grove Height, MNBuilt 1973 · S/N U20602093N410TAJ Azteca Express Inc · Eagle Pass, TXBuilt 2003 · S/N T20608410N411CVTextron Aviation Inc · Wichita, KSBuilt 2016 · S/N T20609251N411KWEscondido Aviation LLC · Marfa, TXBuilt 2011 · S/N T20609034N411TTRambod Marc · Taos Ski Valley, NMBuilt 1975 · S/N 21060861N4137CN4137c Inc · Redwood City, CABuilt 1979 · S/N 21063566N413CVCivil Air Patrol · Maxwell Afb, ALBuilt 2016 · S/N T20609248N414CVCivil Air Patrol · Maxwell Afb, ALBuilt 2016 · S/N T20609250N4169WSebago Flight Service Inc · Cumberland, MEBuilt 2014 · S/N T20609154N417PDDagenais Paul Robert · Escanaba, MIBuilt 2021 · S/N T20609632N4194QJacques Jerry J · Iliamna, AKS/N U2061359N41ARobertson Roy E · Marion, IABuilt 1978 · S/N 21062798N41CEWhats Up Doc Aviation LLC · Alexander, ARBuilt 1978 · S/N 21062872N4210MParagon Air Group · Fort Worth, TXBuilt 1998 · S/N T20608009N4216QFoulkrod Freebird LLC · Buda, TXBuilt 1975 · S/N U20603040N42178Montana Dept Of Transportation · Helena, MTBuilt 1999 · S/N T20608032N4218UJakks Inc · Wilmington, DEBuilt 1999 · S/N T20608035N422RKGulf Coast Aerial Mapping Co Inc · Gonzales, LABuilt 1979 · S/N U20605347N422SWLarson Daniel · Mora, MNBuilt 1977 · S/N 21062164N423RCConcord Trailer World Inc · Concord, CABuilt 2019 · S/N T20609592N424FARobinson Todd Allen · San Luis Obispo, CABuilt 2003 · S/N T20608424N430DMNwa Leasing Group LLC · Springdale, ARBuilt 2012 · S/N T20609078N430MBDbbsx LLC · Kalispell, MTBuilt 2022 · S/N T20609699N432FWFlorida Fish & Wildlife Conservation Commission · Lakeland, FLBuilt 2022 · S/N T20609690N433LPJl Fuertes LLC · Miami, FLBuilt 2022 · S/N T20609705N433TAM7 LLC · Idaho Falls, IDS/N T20608433N435CKHycas LLC · Bountiful, UTBuilt 2016 · S/N T20609223
Back to AD 2012-10-52