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.

N218CCSotally Tober LLC · Wilmington, DEBuilt 1979 · S/N 21063297N218SGMg Air Ventures LLC · Tucson, AZBuilt 2017 · S/N T20609518N219BTDacy Justin A · Boerne, TXBuilt 1976 · S/N 21061568N219CSFlorida Department Of Law Enforcement · Tallahassee, FLBuilt 2020 · S/N T20609599N2202NAlcyone Trust Corp Trustee · Wichita, KSBuilt 2005 · S/N T20608562N2206RKahonees Travel Services LLC · Pleasanton, TXBuilt 1968 · S/N T210-0356N2209RPilotsgirl LLC · Goldsboro, NCBuilt 1968 · S/N T210-0359N220TJJaco Oil Co · Bakersfield, CAS/N 21063139N220WBWells Propane Inc · Wells, NVBuilt 1974 · S/N 210-60194N2210RCarroll James K · Paso Robles, CAS/N T210-0360N22121Registration Pending · Georgetown, TXRegistration pendingBuilt 1972 · S/N 21059711N2217RParke Mike D · Twin Falls, IDBuilt 1968 · S/N T210-0367N221DWDm Private Aviation LLC · Kaukauna, WIBuilt 2026 · S/N T20609848N221JTThompson Joseph · Marion, INBuilt 2017 · S/N T20609520N22206Slater Craig W · Brick, NJBuilt 2022 · S/N T20609682N22232Engeseth James Jr · Parker, COBuilt 1972 · S/N 21059730N2223SDavis Aaron B · Lascassas, TNBuilt 1976 · S/N 21061168N2226RChampion Crane Service Inc · Des Moines, IABuilt 1968 · S/N T210-0376N222FGoddspeed LLC · Encinitas, CABuilt 2000 · S/N T20608154N222LSLj Bickford Companies LLC · Wasilla, AKBuilt 1972 · S/N U206-01751N222SGPacific Aviation Aircraft Management Inc · Fresno, CAS/N 210-64410N2234RJones Lennis William III · Rule, TXBuilt 1968 · S/N T210-0384N2235SN2235s LLC · Overland Park, KSBuilt 1976 · S/N 21061180N2236RSouthern Skies Aviation Inc · Cedar City, UTS/N T210-0386N223SCSurdex Corp · Chesterfield, MOBuilt 1973 · S/N U20601999N223TB416b Heritage Hills Dr LLC · Palm Harbor, FLS/N T20609211N22412Time Flies LLC · Oak Brook, ILBuilt 2007 · S/N T20608737N2241RHappy Landings Aero LLC · Wilmington, DEBuilt 1968 · S/N T210-0391N2241XMandes George · Homer, AKS/N T20608736N22459Hatch Leasing Company LLC · Flagstaff, AZBuilt 1972 · S/N 21059754N2246RMontgomery Brian · Houston, TXBuilt 1968 · S/N T210-0396N2247SCarnes Andrew P · Wichita Falls, TXBuilt 1976 · S/N 21061191N2248RVan Heemst Jeffrey A · West Palm Beach, FLFirst renewal noticeBuilt 1968 · S/N T210-0398N2249SDlw Flight Services LLC · Waterloo, ILBuilt 1976 · S/N 21061193N224CSAtb Special Purpose LLC · Laredo, TXBuilt 2016 · S/N T20609221N224KAChambers William Melvin Jr · Azle, TXBuilt 1979 · S/N 21063812N224PKValiair Lc Trustee · Casper, WYBuilt 1980 · S/N 21064016N2252RStout Walt · White Hills, AZBuilt 1968 · S/N T210-0402N2252SSpider Lips Aviation LLC · Fischer, TXBuilt 1976 · S/N 21061196N2255HWinged Vision Inc · Gaithersburg, MDBuilt 2007 · S/N T20608738N2255MCooper Gary D · Fayetteville, ARBuilt 2007 · S/N T20608739N2259RLarson Lianne N · Irvine, CABuilt 1968 · S/N T210-0409N2259SFaireyfam Aviation LLC · Saint George, UTBuilt 1976 · S/N 21061203N225EBEbac LLC · Wichita, KSBuilt 2025 · S/N T20609819N225METvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N T20608190N225VPAerotrust Services Corp Trustee · Wilmington, DEBuilt 2025 · S/N T20609833N2260SWheeler Eugene N · Livermore, CABuilt 1976 · S/N 21061204N2261RPetik Jason P · Sidney, NEBuilt 1968 · S/N T210-0411N2262SKoch Phillip E · Eldon, MOBuilt 1976 · S/N 21061206N22650Sackett Gary G · Millcreek, UTFirst renewal noticeBuilt 1972 · S/N 21059767
Back to AD 2012-10-52