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.

N29190Mountain Helicopters LLC · Salt Lake City, UTBuilt 1973 · S/N 21059830N291MWHeritage Aviation Management Ltd · Conroe, TXBuilt 2020 · S/N T20609601N29210Hawkes Brian R · Hamilton, MTBuilt 1968 · S/N U206-1165N29542Giannakakis Peter J · Monroe, MIBuilt 1973 · S/N 21059866N295CSLarsen Levitation LLC · Wasilla, AKBuilt 2020 · S/N T20609595N295FAStationair Amphib LLC · Jefferson City, MOBuilt 1980 · S/N U20605482N29631Registered aircraftBuilt 1973 · S/N 21059873N29674Snflk Leasing LLC · Andrews, TXBuilt 1973 · S/N 21059875N296CS1928 LLC · Salmon, IDBuilt 2020 · S/N T20609596N296DEDouble T Flyers LLC · Fort Worth, TXBuilt 2020 · S/N T20609619N296FSD7 Roofing LLC · New Baden, ILBuilt 2016 · S/N T20609236N296PBChurch Aviation LLC · Christmas Valley, ORBuilt 2015 · S/N T20609175N297BCUnderwood David · Sarasota, FLFirst renewal noticeBuilt 2007 · S/N T20608764N297CMHeritage Aviation Management Ltd · Conroe, TXBuilt 2020 · S/N T20609602N297DRMingus Mason · Scottsville, KYBuilt 1978 · S/N 62398N297ZEnovi LLC · Las Vegas, NVBuilt 1981 · S/N U20606223N298PN206 Cat Air LLC · Salem, ORBuilt 2001 · S/N T20608298N299KCKings County Sheriff'S Office · Hanford, CABuilt 2000 · S/N T20608177N299MCN299mc LLC · Auburn, WABuilt 2014 · S/N T20609122N299SPNorth Dakota Highway Patrol · Bismarck, NDBuilt 2007 · S/N T20608797N29AJWest Alabama Aviation Leasing LLC · Tuscaloosa, ALBuilt 2014 · S/N T20609119N29NPCrown Air LLC · Bend, ORBuilt 2010 · S/N T20608974N29PMAlly Mohamed Yacoob · Fort Lauderdale, FLS/N U20605769N2DMWiley Post LLC · Lewes, DEBuilt 1970 · S/N 21059305N2GTT20608770 Inc Trustee · Wilmington, DES/N T20608770N2KDElliott Frank F · Mojave, CAFirst renewal noticeBuilt 1969 · S/N T210-0436N2PSUnited States Department Of The Interior · Boise, IDS/N T20609243N2SLLowe Aviation LLC · Bountiful, UTBuilt 1977 · S/N 21061908N30038Stockyard LLC · Wilmington, DEBuilt 1973 · S/N 21059879N3005YGreen Acres Aviation LLC · Berryville, ARBuilt 2022 · S/N T20609681N300HCPs Air LLC · Evansville, INBuilt 1983 · S/N 21064804N301EBQuesnel William G · Truckee, CABuilt 1978 · S/N 21062524N30268Rudd Terry R · Clarkston, WABuilt 1973 · S/N 21059903N30280Emery Clint L · Texarkana, ARBuilt 1973 · S/N 21059907N302STManagement Support Services LLC · Naturita, COBuilt 1968 · S/N T210-0350N302WDAmado'S Holdings LLC · Rice, MNBuilt 2016 · S/N T20609241N30374Canihan William R · Novato, CABuilt 1973 · S/N 21059918N303HBFly The Coop LLC · Newton, KSBuilt 2019 · S/N T20609577N3040MAustin 206 Aviation LLC · Americus, GABuilt 2023 · S/N T20609732N30453Lehman Land Management LLC · Vernon, TXBuilt 1973 · S/N 21059923N30516J A Sutherland Inc · Ukiah, CABuilt 1973 · S/N 21059927N30530Banegas Jose C Zankiz · Fort Myers, FLBuilt 1973 · S/N 21059929N305JGAbeona-Adeona Aviation LLC · Wilmington, DEBuilt 2023 · S/N T20609718N305MTMtc Air LLC · Homestead, FLBuilt 2025 · S/N T20609809N305WAMy Way Aviation LLC · Weston, FLS/N 21065002N305WTToro Procurement LLC · San Angelo, TXBuilt 2015 · S/N T20609164N30644Registered aircraftBuilt 1973 · S/N 21059949N306CSSecurity Alert Aviation LLC · Gilroy, CABuilt 2016 · S/N T20609225N30777Huff Charles Christopher · Midland, TXBuilt 1973 · S/N 21059959N307CSDetwiler Jeffrey D · Lancaster, PABuilt 2013 · S/N T20609105
Back to AD 2012-10-52