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.

N264ME618 Aviation LLC · Kosse, TXBuilt 2000 · S/N T20608200N26509Bell Air LLC · Belleville, KSBuilt 1998 · S/N T2068004N2650VSampson Merle A · Inver Grove Height, MNBuilt 1998 · S/N T2068005N2656SPierini William C · Chico, CABuilt 1976 · S/N 21061346N266BBJk Air LLC · Duncan, OKBuilt 1999 · S/N T20608082N2673SWilliams Randall S · Chico, CABuilt 1976 · S/N 21061348N267ABConcrete Experts LLC · Colorado Springs, COBuilt 2007 · S/N T20608792N267JMMathews Development Co · Santa Rosa Beach, FLBuilt 1999 · S/N T20608132N268HPFlorida Highway Patrol · Tampa, FLBuilt 2005 · S/N T20608579N26NZBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N T20608401N26PMHill Capital Leasing LLC · Scottsdale, AZBuilt 1977 · S/N 21061791N26VRReed Edward · Marcellus, MIBuilt 2005 · S/N T20608563N2704WSpillman David T · Flagstaff, AZBuilt 1967 · S/N U2060690N270MEMm Aviation LLC · Casa Grande, AZBuilt 2000 · S/N T20608213N270MRFurtado William J III DBA · Fremont, CABuilt 1976 · S/N 21061660N270SPSan Pedro Aviation LLC · San Antonio, TXBuilt 2025 · S/N T20609815N271JLSouthwest Aviation Enterprises · Haslet, TXBuilt 2024 · S/N T20609778N271LDVan Well Trucking LLC · Dallas, ORBuilt 2010 · S/N T20608977N273METopel Holdings LLC · Scottsdale, AZBuilt 2000 · S/N T20608217N2743JColman Scott · Tampa, FLBuilt 1976 · S/N 21061690N274CPCivil Air Patrol · Maxwell Afb, ALBuilt 2014 · S/N T20609127N274HAPacific Rain Inc · Arroyo Grande, CABuilt 1981 · S/N 21064274N278JHRaytheon Co · Tucson, AZBuilt 2007 · S/N T20608715N278TMBuena Vista Aviation LLC · Fresno, CABuilt 2023 · S/N T20609728N27BSl Leasing Group LLC · Barnesville, GABuilt 1975 · S/N 21061108N27DVDodson International Parts Inc · Rantoul, KSBuilt 1999 · S/N T20608111N27GPFlying Colors Airparts Inc · Leesburg, FLBuilt 1977 · S/N U20604105N27VANorton Mark H Trustee · Stateline, NVBuilt 2015 · S/N T20609170N2814QGill Robert L · Dixon, CABuilt 1975 · S/N U20602998N281WSWight David · Alvin, TXBuilt 2006 · S/N T20608611N28206Huey David G · Sumas, WABuilt 2008 · S/N T20608830N2829JSunrise Aviation LLC · Las Vegas, NVBuilt 2008 · S/N T20608801N283RDBengtson Douglas Richard · Woodinville, WABuilt 1981 · S/N 21064320N283TBNance Joseph W · Fort Collins, COBuilt 1977 · S/N U20603956N2856QFoster Aaron J · Missoula, MTBuilt 1975 · S/N U20603005N285DVJohnson Jeffrey L · Fargo, NDBuilt 2000 · S/N T20608171N285JLLink Air Service LLC · Minong, WIS/N T20608373N286TCJb Aviation LLC · Waxahachie, TXBuilt 1986 · S/N 21065001N2874EMoutafian Adom · Los Gatos, CAS/N 21062773N288JYNational Aircraft Leasing Corp · Greenville, DEBuilt 2009 · S/N T20608913N28LZLindemann Thomas · Gustine, CABuilt 1981 · S/N U20606531N28RSElohim Airparts Sales LLC · Naples, FLBuilt 1970 · S/N 21059316N29003R J Kielty Plumbing Heating And Cooling Inc · New Port Richey, FLS/N 21059778N29084D E C Holdings · Hansen, IDBuilt 1972 · S/N 21059798N29113Figueroa Angel Lara · Winfield, ALBuilt 1973 · S/N 21059806N29138Allen Brent H · Mammoth Lakes, CABuilt 1973 · S/N 21059815N29151Inland Aerial Surveys Inc · Riverside, CABuilt 1968 · S/N U206-1121N29164Iturriria John · Kuna, IDBuilt 1968 · S/N U206-1133N29176Tgr Helicopters · Fresno, CABuilt 1973 · S/N 21059828N29188Rugger Investment Group LLC · Tustin, CABuilt 1968 · S/N U206-1153
Back to AD 2012-10-52