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.

N357HRMartin Hein Ranch Co · Visalia, CABuilt 2012 · S/N T20609050N35877Turbine Conversions Ltd · Nunica, MIBuilt 1975 · S/N U20602777N358GMTextron Aviation Inc · Wichita, KSS/N T20609873N35909Flight1 Hsw LLC · Norwood, COBuilt 1975 · S/N U20602792N35932Tmzk Holdings LLC-1 · North Fort Myers, FLBuilt 1975 · S/N U20602808N35957Cortez Flying Service Inc · Cortez, COBuilt 1975 · S/N U20602829N35VAN27ax LLC · Tulsa, OKBuilt 2019 · S/N T20609561N361MState Of Montana Dept Of Natural Resources · Helena, MTBuilt 2025 · S/N T20609811N361SPTextron Aviation Inc · Wichita, KSS/N T20609876N362MState Of Montana Dept Of Natural Resources · Helena, MTBuilt 2025 · S/N T20609812N365PBTruck Force One LLC · Homestead, FLBuilt 2022 · S/N T20609712N367DKBonner Carl · Farmville, NCBuilt 2019 · S/N T20609582N367TZEquipco LLC · Kalispell, MTBuilt 2015 · S/N T20609167N369BGBrantley George · Carlsbad, NMBuilt 2021 · S/N T20609636N369CVVan Bortel Aircraft Inc · Arlington, TXBuilt 2005 · S/N T20608560N369HCCornerstone Mapping Inc · Roca, NEBuilt 1980 · S/N 21064049N36RHRobin Hood Aviation LLC · Dunn, NCBuilt 2018 · S/N T20609539N36XArchangel Aviation LLC · Cleburne, TXBuilt 1976 · S/N 21061650N371MALets Fly LLC · Eugene, ORBuilt 1999 · S/N T20608028N373MAKropf Kevin G · Montrose, COBuilt 1999 · S/N T20608117N373PJRock Creek Corp · Henderson, NVBuilt 1978 · S/N 21062887N3744WTextron Aviation Inc · Wichita, KSS/N T20609863N3746Nickravesh Niknam J · Saratoga, CABuilt 1975 · S/N U20602818N374MEKelley Aviation LLC · Crescent, IABuilt 2000 · S/N T20608223N375SRN375sr LLC · Hickory, NCBuilt 2020 · S/N T20609616N376MESpirit Air Inc · Salmon, IDBuilt 2000 · S/N T20608225N377CSFreetown Partners LLC · Newark, DES/N T20609137N377GKCholla Civil Construction LLC · Mesa, AZBuilt 2020 · S/N T20609615N377HAGrasse Louis Phillip Trustee · Saint Louis, MOBuilt 2004 · S/N T20608499N377MEBrandywine Enterprises Lp · Beverly Hills, CABuilt 2000 · S/N T20608226N378CSKerr Tractor Gp LLC · Beaumont, TXBuilt 2022 · S/N T20609678N378HDept Of The Interior · Boise, IDS/N T20608242N378MECamelot Aviation LLC · Phoenix, AZBuilt 2000 · S/N T20608228N378SStarr William E · Eagle River, AKBuilt 1979 · S/N U20604967N379DTN379dt LLC · Naples, FLBuilt 2007 · S/N T20608777N37DPTurbo Time LLC · Mesa, AZBuilt 1976 · S/N 210-61452N37EWKundel Andrew R · Muscatine, IAS/N U20602997N37JFNexga Aircraft Inc · Greensboro, NCBuilt 2009 · S/N T20608934N37PB37pb Inc · Seattle, WABuilt 1972 · S/N 21059737N3810Nerio Antonio · Eagle Pass, TXBuilt 2013 · S/N T20609096N381DSFlightpath Investments LLC · Ottumwa, IABuilt 1974 · S/N 21060255N3821GI Am Alpha & Omega LLC · Sparks, NVS/N U206-0821N3841GWhetzel Michael L · Ukiah, CABuilt 1967 · S/N U206-0841N384MGMissionary Air Group Inc · Burlington, NCBuilt 1979 · S/N U20605272N385CSCosmos Holdings Group LLC · Newark, DEBuilt 2016 · S/N T20609231N385TDHomestead Helicopters Inc · Missoula, MTBuilt 1965 · S/N T210-0072N3875GBurnett Ross L · Riggins, IDBuilt 1967 · S/N U206-0875N388UTFree Bird Air LLC · La Crosse, WIS/N T20608620N3891GTangent Aviation LLC · Oro Valley, AZBuilt 1967 · S/N U206-0891N3895GMike Kilo Aviation LLC · Garden Ridge, TXBuilt 1967 · S/N U206-0895
Back to AD 2012-10-52