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.

N307JHRoundy Joseph · Three Forks, MTBuilt 1980 · S/N 207-00584N307RJGv Air Inc · Medford, ORBuilt 2012 · S/N T20609060N308AROverstreet Investments Inc · Boonville, MOBuilt 2024 · S/N T20609756N308BCMike Kilo Foxtrot LLC · Wilmington, DEBuilt 1979 · S/N 21063618N308CPCivil Air Patrol · Maxwell Afb, ALBuilt 2014 · S/N T20609128N308DMD&M Aircraft Co Inc · Thonotosassa, FLBuilt 2023 · S/N T20609745N30942Polar Bear Aviation LLC · Batesville, MSBuilt 1973 · S/N 21059979N309DKNby Productions · Bristow, VABuilt 2021 · S/N T20609643N30HDRegistered aircraftS/N 21063234N30VGGeoterra Inc · Eugene, ORBuilt 1980 · S/N 21063856N30WLSkydive Coolidge Inc · Tempe, AZBuilt 1966 · S/N P206-0275N311TGTg Air LLC · Fishers, INBuilt 2021 · S/N T20609653N312KKHowser Donald Marvin III · Granbury, TXBuilt 2004 · S/N T20608472N312SCBarker Family Investments Management Co LLC · Tyler, TXBuilt 1981 · S/N 21064474N313GBBurnett Gregory C · Rogersville, MOBuilt 1977 · S/N 21061986N3148PSky Hi Aviation LLC · Wilmington, DEBuilt 1977 · S/N 210-61945N314MEJfw Ranch Consulting LLC · Albuquerque, NMS/N T20608222N3156XBack Country Aviation LLC · Jupiter, FLS/N 20700376N3160LKo Hee Sun · Norwood, NJBuilt 1975 · S/N U20602815N316RWFour States Tire & Service Inc · Cortez, COBuilt 1979 · S/N 21063447N317MSHolley Melissa T · Baton Rouge, LABuilt 2019 · S/N T20609563N319CSRas Airways LLC · Garland, TXBuilt 2016 · S/N T20609219N31SJCpc Aviation LLC · Algona, IAS/N T20608296N321BPCenturion Air Inc · Ridgewood, NJS/N 21063986N321LGLaughing Gull Aviation Inc · Fort Lauderdale, FLBuilt 1978 · S/N 21062769N321PCStene Aviation Inc · Polson, MTS/N 21062813N322LKFindley Air LLC · Temecula, CABuilt 1974 · S/N 21060344N32331Sowers Richard M · Reno, NVBuilt 1980 · S/N 21064188N323CPCivil Air Patrol · Maxwell Afb, ALBuilt 2014 · S/N T20609129N323DASky West Aviation Inc Trustee · Albuquerque, NMBuilt 1982 · S/N 21064753N323RTRoyal Blue LLC · Franklin, TNS/N T20609731N324BKing Ag Leasing Inc · Sudan, TXBuilt 2005 · S/N T20608526N324MGSilver Eagle II LLC · Carson City, NVBuilt 2023 · S/N T20609723N324SMMaverick II LLC · Midvale, UTBuilt 2021 · S/N T20609666N325DDQuick Michael D · Middletown, CAS/N 21062748N325LCCervantes-Galdeano Lorenzo · Ingalls, KSBuilt 2005 · S/N T20608536N3279NTips Frederick J III · San Antonio, TXBuilt 1974 · S/N 21060452N327BWCessna N327bw LLC · Telluride, COBuilt 1974 · S/N 21060166N327MTHayden LLC · Tiburon, CABuilt 2019 · S/N T20609559N329CPCivil Air Patrol · Maxwell Afb, ALBuilt 2014 · S/N T20609130N329CSOvercast 329 LLC · Jonesboro, ARBuilt 2021 · S/N T20609637N32HSFarm Boy Aviation LLC · Boynton Beach, FLBuilt 2006 · S/N T20608645N32MCCook Tracy L · Prosper, TXBuilt 1974 · S/N 21060482N32MTHeading 406 LLC · Kalispell, MTBuilt 2021 · S/N T20609652N32PSDepartment Of The Interior · Boise, IDBuilt 2021 · S/N T20609651N33189Schrage Rodney L · Steamboat Springs, COBuilt 1975 · S/N U20602659N331CBN331cb LLC · Great Falls, MTBuilt 1979 · S/N 21063747N333BCMcfadden John L · Cresson, TXBuilt 1977 · S/N 21061848N333DAFavor Michael D · Chico, CABuilt 1976 · S/N 21061289N333GKCenturion210 LLC · Amherst, NHBuilt 1976 · S/N 21061282
Back to AD 2012-10-52