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.

N2468YGv Air Inc · Medford, ORBuilt 2011 · S/N T20609005N2469H69h LLC · Ocean City, MDBuilt 2025 · S/N T20609822N246APT & N Holdings LLC · Tyler, TXBuilt 2019 · S/N T20609564N246ECKnight Air LLC · Wausau, WIS/N 21062435N246MEWyoming Seaplanes LLC · Alpine, WYBuilt 2000 · S/N T20608194N2477XLecce Aviation LLC · Williamsport, PABuilt 2007 · S/N T20608762N2478AEnnair LLC · Kalispell, MTBuilt 2007 · S/N T20608763N247CBDream Machine Leasing LLC · Glenbrook, NVBuilt 1981 · S/N U20606194N2480SAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1976 · S/N 21061299N248HSLitchfield Lantz · Las Vegas, NVBuilt 1978 · S/N 21062726N248RCMckinley I Blake Jr · Spokane Valley, WAFirst renewal noticeBuilt 1999 · S/N T20608141N248RRWalter Air Co LLC · Oakdale, CABuilt 2004 · S/N T20608481N2492SSierra Hotel Aircraft LLC · Wilmington, DEBuilt 1976 · S/N 21061302N2498SKatz Michael R Trustee · Merritt Island, FLBuilt 1976 · S/N 21061306N249FMValiair Limited Co Trustee · Casper, WYBuilt 2002 · S/N T20608374N249TARkl Consulting LLC · Keizer, ORBuilt 2018 · S/N T20609526N24CHDagostini Robert A · Mount Aukum, CABuilt 1975 · S/N 21060793N24GLTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N T20609851N24HSSandoval Ernest D · Cave Creek, AZBuilt 1978 · S/N 21062755N24NHBeyer Roger · Paw Paw, MIBuilt 1981 · S/N 21064545N2501SGonzales Gerald · Dallas, TXS/N 21061307N2508SErnst Don A · San Luis Obispo, CABuilt 1976 · S/N 21061311N250MELake Superior Aviation Llp · Duluth, MNBuilt 2000 · S/N T20608189N251DPDisa Air LLC · Laredo, TXBuilt 2022 · S/N T20609693N25206Megwetch Aviation LLC · Auburn, MEBuilt 2025 · S/N T20609823N2525XTolbert Mark A · Canandaigua, NYBuilt 1977 · S/N 21061803N252CPCivil Air Patrol · Maxwell Afb, ALBuilt 2014 · S/N T20609126N252LTAerownership North American Services Inc Trustee · Wilmington, DEBuilt 2022 · S/N T20609695N252SWSymns Robert A · Aguila, AZBuilt 1978 · S/N 21063029N2538SBarbo Walter A · Aurora, COBuilt 1976 · S/N 21061322N253JGFly Good Land Gooder Holdings LLC · Tomah, WIBuilt 2023 · S/N T20609753N254CSVallencourt Construction Co Inc · Green Cove Springs, FLBuilt 2017 · S/N T20609254N255TMGiles Durham K · Davis, CABuilt 2012 · S/N T20609068N256MBMunobraca LLC · Mcallen, TXBuilt 1999 · S/N T20608116N2580SArizona Production Machinery & Supply · Casa Grande, AZBuilt 1976 · S/N 21061333N2588TAircraft Trustee Services Inc Trustee · Dover, DEBuilt 2006 · S/N T20608590N259BWPinal County Sheriffs Office · Florence, AZBuilt 2007 · S/N T20608727N259PHPbh Air Adventures LLC · Cedar City, UTBuilt 2024 · S/N T20609770N25GPAir Data Solutions LLC · Natchitoches, LABuilt 1975 · S/N U20602889N25PYAir4je LLC · West Chester, PABuilt 2017 · S/N T20609521N260RDAircraft Trustee Services Inc Trustee · Dover, DEBuilt 2019 · S/N T20609567N2616SMontana Alpha Omega Ranch LLC · Miles City, MTBuilt 1976 · S/N 21061342N261CPCivil Air Patrol · Maxwell Afb, ALBuilt 2011 · S/N T20609025N2626ZJf Aviation LLC · Minot, NDBuilt 2007 · S/N T20608761N262CACompass Aviation Inc · Shelby, NCBuilt 1981 · S/N U20606094N262SHTextron Aviation Inc · Wichita, KSS/N T20609860N2638ULindsey Aviation Services · Haslet, TXBuilt 1999 · S/N T20608061N263MECommercial Aerial Images Inc · Costa Mesa, CABuilt 2000 · S/N T20608199N263RCRichland County Sheriffs Department · Columbia, SCBuilt 2013 · S/N T20609107N2642SReich Stephen Barry · Kentfield, CABuilt 1976 · S/N 21061345
Back to AD 2012-10-52