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.

N333HRWilson Alan E Trustee · Erie, COBuilt 1974 · S/N 21060412N333LB333lb LLC · Fort Worth, TXBuilt 1978 · S/N 21062890N333PSDoran Jeffrey T · Westerville, OHS/N 21060834N335JWN335jw LLC · Hilton Head Island, SCBuilt 2019 · S/N T20609579N335SFRamont Ronald G Jr Trustee · Modesto, CABuilt 1977 · S/N 21062413N338SAGonzalez Jesse · Colorado Springs, COBuilt 1999 · S/N T20608041N338WSWinsors Wings LLC · Rogersville, MOBuilt 2008 · S/N T20608828N33AGSory Bailey B IV · Bozeman, MTS/N 21061637N33BBHendricks Timothy J · Telluride, COBuilt 1976 · S/N U20603632N33SQJohnston H Kenneth II · Wheatland, WYBuilt 1966 · S/N T210-0056N33UT402wd Holdings LLC · Corpus Christi, TXS/N 21061177N340CSTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N T20609840N3422Hergenrather Michael · Spring, TXS/N U20602920N3422LAwsm Inc · Grand Canyon, AZBuilt 1967 · S/N U206-0722N342CSTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N T20609842N3432FBierschwale Land Co LLC · Mason, TXBuilt 1977 · S/N 21062407N3441LBarlow Dwight D · Monte Vista, COBuilt 1966 · S/N U206-0741N3447LHulst Damon M · Santa Barbara, CABuilt 1966 · S/N U206-0747N344AJQualitair LLC Trustee · MichelstadtBuilt 1980 · S/N 21063891N345DPBack Country Hacks LLC · Olalla, WABuilt 2001 · S/N T20608269N3463LLrh Equipment LLC · Pendleton, ORBuilt 1966 · S/N U206-0763N346CKCk Contracting Inc · Kings Mountain, NCBuilt 2021 · S/N T20609664N346JHRobertson Timothy A · Lewistown, MTBuilt 2008 · S/N T20608814N346RNSchroll Charles E · Tucson, AZBuilt 1969 · S/N P206-0567N34BTWilliams Charles R · Wadsworth, OHBuilt 1973 · S/N 21060130N34KBReilly Donald H · Micco, FLBuilt 1978 · S/N 21062656N34PLMoonglow Aviation LLC · Toledo, OHBuilt 2003 · S/N T20608403N35014Trionz LLC · Artesia, NMBuilt 2002 · S/N T20608303N3506HHorn Marcia L · Erie, COS/N T20608312N3506YCascade Commodities LLC · Saint Paul, MNBuilt 2001 · S/N T20608311N3510PFlying Gilley Ranch LLC · Tryon, OKS/N T20608306N3510TTextron Aviation Inc · Wichita, KSBuilt 1985 · S/N T20608319N351JAHutchins William · Kennesaw, GABuilt 2008 · S/N T20608820N3530CBig Horn Tire Inc · Gillette, WYS/N T20608287N3532YEdwin C Poss Inc · Clayton, GABuilt 2001 · S/N T20608290N35343Oconner Thomas Anthony · White Salmon, WABuilt 2001 · S/N T20608284N3536MBj Air Northwest LLC · Quincy, WAS/N T20608302N3538RUS Department Of Homeland Security · Washington, DCBuilt 2001 · S/N T20608341N3542ZBlack Duck Enterprises LLC · West Creek, NJS/N T20608336N35438Kern County Sheriffs Department · Bakersfield, CABuilt 2001 · S/N T20608329N3543BUS Department Of Homeland Security · Washington, DCBuilt 2001 · S/N T20608330N35440Norwood Jon D · Damon, TXBuilt 2001 · S/N T20608327N35443Registered aircraftBuilt 1973 · S/N 21059992N3547TAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2001 · S/N T20608322N354BSStevenson Bill · Sunrise Beach, TXS/N 210-60381N355CWLevare Aviation Inc · Hillsborough, NJBuilt 2008 · S/N T20608817N355SRMoonglow Aviation LLC · Dover, DEBuilt 2004 · S/N T20608458N355YPlussa Mark George · Clermont, FLBuilt 1980 · S/N 21064137N356SFSheehan Aviation Family Enterprises LLC · Boise, IDS/N T20608496N357DRImsar LLC · Springville, UTBuilt 2019 · S/N T20609590
Back to AD 2012-10-52