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.

N210TRMora Ricardo A · El Paso, TXBuilt 1977 · S/N 21061745N210VCruiser LLC · Munger, MIS/N 21062675N210VBHoogendyk Robert · Big Bear City, CABuilt 1979 · S/N 21063776N210VJV J Wings Inc · Wilmington, DES/N 21063387N210VVHeesacker Stephen L Trustee · Los Altos, CABuilt 1979 · S/N 21063214N210WRegistration Pending · Colorado Springs, CORegistration pendingS/N 21059417N210WCWeeks Curtis E · Cotulla, TXBuilt 1982 · S/N 21064759N210WJRude Daniel · Leesburg, VABuilt 1982 · S/N 21064734N210WTBarlowe James M · Enumclaw, WABuilt 1971 · S/N 21059528N210WZHogue Tool & Machine Inc · Paso Robles, CABuilt 1973 · S/N 21060039N210XPAnderson Andre A · El Paso, TXBuilt 1970 · S/N 21059336N2118ASouth Dakota Highway Patrol · Pierre, SDBuilt 2004 · S/N T20608451N2118SAbes Erika · El Paso, TXBuilt 1975 · S/N 21061081N211CFGoudreau Sean · Mount Dora, FLBuilt 1978 · S/N 21063013N211FJFox Point Airways LLC · Sheridan, WYBuilt 2006 · S/N T20608673N211GTB & B Crane Service LLC · North Myrtle Beach, SCBuilt 2011 · S/N T20609008N211LR & G Schatz Farms Inc · Lockeford, CABuilt 1979 · S/N 21063183N211LCSuddarth Steven Craig · Edgewood, NMBuilt 1974 · S/N 21060364N211PAPiedmont Air Services LLC · Helena, MTBuilt 1981 · S/N U20606415N2122SBobo Construction LLC · Pullman, WABuilt 1975 · S/N 21061084N212FSTrinity River Lumber Co · Weaverville, CAS/N T20609720N212KTLanier Howard W · Willis, TXS/N P206-0349N212TSParkside Automotive & Truck Service · Mountain Top, PABuilt 1980 · S/N 21064214N212ZSkies The Limit LLC · Fuquay Varina, NCBuilt 2016 · S/N T20609228N2134UDean Steel Buildings Inc · Fort Myers, FLBuilt 1982 · S/N 21064775N2137H3 Pandas LLC · Farmington, NMBuilt 2007 · S/N T20608721N2138BSouthwest Aviation Enterprises · Haslet, TXBuilt 2003 · S/N T20608437N2138SStamm Roy Peter · Woodstock, GABuilt 1975 · S/N 21061099N213GCEastern Stearman Inc Trustee · Leesburg, VABuilt 1978 · S/N 21062368N2143SBaiocchi Ken P · San Jose, CABuilt 1975 · S/N 21061104N2145RCabernet To Cactus LLC · Scottsdale, AZBuilt 2003 · S/N T20608427N2145SHenry James · Bonita, CABuilt 1975 · S/N 21061106N2148WSav LLC · Shelton, WABuilt 2003 · S/N T20608421N21493Macmillan Robert J · Merritt Island, FLBuilt 2003 · S/N T20608423N214MHShadow Ventures LLC · Chesapeake, VAS/N T20608214N214VWMilford Aviation LLC · Greensburg, INBuilt 2008 · S/N T20608837N2150KCarey David John II · Mccall, IDBuilt 2003 · S/N T20608407N2156NTerryair LLC · Missoula, MTBuilt 2003 · S/N T20608409N2159PKiehn Real Estate LLC · Santa Barbara, CABuilt 2003 · S/N T20608432N215VBBravo Air Ventures LLC · Salt Lake City, UTBuilt 2015 · S/N T20609210N2162WHelicopter Applicators LLC · Pembroke, NHBuilt 2004 · S/N T20608439N216CCSuncoast Nursery & Tiki Huts Inc · Homestead, FLBuilt 2016 · S/N T20609227N216CPCivil Air Patrol · Maxwell Afb, ALBuilt 2014 · S/N T20609138N216LHHackbarth Lee A · Bend, ORBuilt 1981 · S/N U20606057N216NBNby Productions · Bristow, VABuilt 2018 · S/N T20609527N216SBMorotti John M · Las Vegas, NVBuilt 2004 · S/N T20608463N2175SMichael Lauder K · Littleton, COBuilt 1975 · S/N 21061136N217DLValiair Lc Trustee · Casper, WYS/N T20608224N2181SGreer Kenneth R · Pittsburgh, PABuilt 1975 · S/N 21061142N2186ZNational Products Inc · Seattle, WABuilt 2005 · S/N T20608559
Back to AD 2012-10-52