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.

N206PQHogue LLC · Paso Robles, CABuilt 2001 · S/N T20608299N206RAAcord Transportation Inc · Chandler, OKBuilt 2021 · S/N T20609654N206RCPaloma Aviation LLC · Fruitland, IDBuilt 1974 · S/N U20602431N206RPFinley Aviation LLC · Fort Worth, TXBuilt 2005 · S/N T20608516N206RR206 Adventures LLC · San Juan, PRBuilt 2013 · S/N T20609102N206SJUrbana Aviation LLC · Woodstock, OHBuilt 1998 · S/N T20608007N206SNDye Seed Ranch Inc · Spokane Valley, WABuilt 1979 · S/N U20605101N206TBAir Supply LLC · Tuscumbia, ALBuilt 2025 · S/N T20609813N206TZTeton Leasing LLC · Polatello, IDBuilt 1979 · S/N U20605165N206UESmith Peter I Trustee DBA · Ocala, FLS/N T20608744N206VBN206vb LLC · Batavia, OHBuilt 2013 · S/N T20609084N206VSBos Ranch LLC · Reno, NVBuilt 1999 · S/N T20608030N206WKKaw Corp · Mcallen, TXBuilt 2001 · S/N T20608318N206WPMorrison Richard Lee Trustee · Anchorage, AKBuilt 1980 · S/N U20605897N206WTSevere Clear Aviation LLC · Hagerstown, MDBuilt 1976 · S/N U20603613N206WYAerotrust Services Corp Owner Trustee · Wilmington, DEBuilt 2000 · S/N T20608187N206XKennedy Benjamin · Boulder, COBuilt 1968 · S/N P206-0479N206XPAirborne Flyer LLC · Ashland, NHBuilt 1983 · S/N U20606701N206YPIm Aviation LLC · Laredo, TXBuilt 2020 · S/N T20609620N2070SThompson Robert V Trustee · Crawford, COBuilt 1975 · S/N 21061037N2076SWarden Air LLC · Warden, WABuilt 1975 · S/N 21061043N207ALU S Imaging Flight Ops LLC · Bartow, FLBuilt 2015 · S/N T20609163N207BHElevation Squad Inc · York, PABuilt 1982 · S/N 20700735N207CCAbaco Fire Rescue Association Inc · Lewes, DEBuilt 1979 · S/N 20700488N207DAKolb Austin · Phoenixville, PAS/N 20700607N207DFDouble R Air LLC · Miami, FLBuilt 1978 · S/N 20700430N207DLRegistered aircraftBuilt 1981 · S/N 20700712N207GHBridgeview Aviation LLC · Southfield, MIS/N 20700709N207GRBlue Sky Telluride LLC · Telluride, COBuilt 1979 · S/N 20700563N207SRJaars Inc · Waxhaw, NCS/N 20700623N207TFPhotos Unlimited Inc · Rancho Cordova, CABuilt 1978 · S/N 20700492N2083SDave Schmauderer · Woodland, CAS/N 21061049N2084SSecondhand Flying LLC · Ogden, UTBuilt 1975 · S/N 21061050N2085SRichards John · Casa Grande, AZBuilt 1975 · S/N 21061051N208DGDelta Golf Aviation LLC · Pompton Plains, NJBuilt 2008 · S/N T20608866N208FT423 East Young LLC · Warrensburg, MOBuilt 2005 · S/N T20608573N208WPCassidy Ryan H · Seattle, WABuilt 1980 · S/N U20605836N2092SMidwest Airmotive Inc · Mount Sterling, KYBuilt 1975 · S/N 21061058N2095JAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 2005 · S/N T20608554N2095SMrk Aviation LLC · Delray Beach, FLBuilt 2004 · S/N T20608442N2099YThompson And Harvey Holdings LLC · Orcutt, CABuilt 2004 · S/N T20608444N209CSMat Air LLC · Bridgeport, TXBuilt 2011 · S/N T20609002N20ADDdd Partnership · Davis, CABuilt 2020 · S/N T20609612N20CNRegistration Pending · Bedford, PARegistration pendingBuilt 2019 · S/N T20609584N20HLCs&P Rocky Mountain Inc · Cypress, TXS/N 21061877N2101ZPico'S Plane LLC · Rockport, MEBuilt 2007 · S/N T20608712N2109JRaf Ks LLC · Wichita, KSBuilt 2007 · S/N T20608717N210AAMeckley Sean H · Seattle, WABuilt 1982 · S/N 21064690N210ABRudy Schmitt · Brookshire, TXS/N 21059209N210ARVjc Air LLC · Katy, TXBuilt 1975 · S/N 21061077
Back to AD 2012-10-52