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.

N206AGDesevarg Inc · Appleton, WIBuilt 2020 · S/N T20609618N206AMLiu Ke · Millburn, NJBuilt 2003 · S/N T20608436N206AZGrant Investments LLC · Bakersfield, CABuilt 2015 · S/N T20609176N206BABoeing Company · Mesaon, AZBuilt 1973 · S/N U20602034N206BDBge Aviation LLC · Camden, ARBuilt 2018 · S/N T20609541N206BSBlue Star Gas Fleet Services Co · Central Point, ORBuilt 1968 · S/N P206-0434N206CTextron Aviation Inc · Wichita, KSS/N T20609864N206CCCharlie Charlie LLC · Wasilla, AKBuilt 2019 · S/N T20609574N206CTDe Creeft Joseph M · Homer, AKBuilt 1981 · S/N U206-06090N206CVC & C Transportation Inc · Benton, LABuilt 2000 · S/N T20608164N206DKFly Waveboard Inc Trustee · Wilmington, DEBuilt 2009 · S/N T20608949N206DMBushwood Air LLC · Coeur D Alene, IDBuilt 1976 · S/N U20603512N206DTSchons Jeffrey · Pacific City, ORBuilt 2006 · S/N T20608662N206DVBowman And Dehn Enterprises Inc · Georgetown, DEBuilt 2007 · S/N T20608724N206DWAlaskan Start Aviation LLC · Midland, TXBuilt 1999 · S/N T20608145N206DYMorgan Farms LLC · Nyssa, ORBuilt 2006 · S/N T20608684N206EAAbrams Edward L · Roxbury, CTBuilt 2000 · S/N T20608186N206EEHastings Ranch Vineyard · Paso Robles, CABuilt 2005 · S/N T20608505N206EKKoch & Koch Inc · Grass Valley, CABuilt 1981 · S/N U20606291N206EMHoopes Turf Farm Inc · Ulysses, PABuilt 2011 · S/N T20608995N206ETTorgerson Eric L · Ethridge, MTS/N T20608872N206GSmith Air LLC · Cascade, IDBuilt 1979 · S/N U20605268N206GAPrijatel Thomas J · Cordova, AKBuilt 1979 · S/N U20605288N206GESheldon Graham · Bellevue, WABuilt 2018 · S/N T20609536N206GVSawtooth Flying Service · Mccall, IDBuilt 1978 · S/N U20604833N206HMilestone Aviation LLC · Vail, COBuilt 2022 · S/N T20609684N206HDBarry Adventure Travel Inc · Pagosa Springs, COBuilt 2018 · S/N T20609554N206HGSeecat LLC · Palo Alto, CABuilt 2011 · S/N T20608994N206HHSawtooth Flying Service Inc · Mccall, IDBuilt 1980 · S/N U20605675N206HJRauch Peter · Austin, TXBuilt 2007 · S/N T20608713N206HMDma Aviation Services LLC · Wilmington, DEBuilt 2021 · S/N T20609672N206JWMarley William Jay Jr · Homer, AKBuilt 1981 · S/N U20606283N206KDStubblefield Fancho F Jr Trustee · Amity, ORBuilt 1979 · S/N U20604981N206LWestern Air Pilots LLC · Mountain Home, ARBuilt 2004 · S/N T20608498N206LEFort Worth And Western Air Express LLC · Southlake, TXBuilt 2008 · S/N T20608810N206LGHotel Kilo Aviation LLC · Anchorage, AKBuilt 2007 · S/N T20608714N206LLMoondog Motorsports LLC · Missoula, MTBuilt 2012 · S/N T20609058N206MBAircraft Trustee Services Inc Trustee · Dover, DEBuilt 2023 · S/N T20609746N206MDAuction Aviation Inc · Boulder City, NVBuilt 1999 · S/N T20608014N206MESouthwest Erosion Control · Mckinney, TXBuilt 2025 · S/N T20609816N206MFMission Aviation Fellowship · Nampa, IDBuilt 2015 · S/N T20609160N206MNMartin Nelson & Co Inc · Seattle, WABuilt 2006 · S/N T20608646N206MTBlue Spruce LLC · Bigfork, MTBuilt 1999 · S/N T20608076N206MVBrownlie Michael V · Chandler, AZS/N U20606539N206MWZaludy Aviation LLC · Paynesville, MNS/N T20608314N206MZKtbr Holdings LLC · Statesboro, GABuilt 2005 · S/N T20608551N206PDRockwell Collins Inc · Cedar Rapids, IABuilt 1977 · S/N 676N206PFPatriot Fuels Inc · Alexander, NDBuilt 2025 · S/N T20609817N206PJIllingworth Paul John · Georgetown, TXBuilt 2008 · S/N T20608876N206PMTunnel Aviation LLC · Tunnel Hill, GABuilt 2002 · S/N T20608376
Back to AD 2012-10-52