AD 2012-10-13

Registered aircraft · 13,306

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-13')
    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-13')
  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.

N565SPattarini James Martin · Houston, TXBuilt 2003 · S/N 0576N565TVCca LLC · Wellston, OKBuilt 2007 · S/N 2708N565TX22t-10685 LLC · Austin, TXBuilt 2025 · S/N 10685N566BLGuardian Health Clinic LLC · Rayville, LABuilt 2022 · S/N 8560N566EAKbs Air LLC · Madison, MSBuilt 2021 · S/N 2460N566SRFutures Aviation Services LLC · Sunny Isles Beach, FLBuilt 2007 · S/N 2864N566TLBilly D Lide LLC · Streetman, TXBuilt 2026 · S/N 11153N566TTLochhead Aviation LLC · Scottsdale, AZBuilt 2017 · S/N 1587N56722Tri-Valley Advisors Inc · Pleasanton, CABuilt 2026 · S/N 11497N5677XKas Properties LLC · Jennings, LABuilt 1993 · S/N E-2797N567ABPiper Aviation LLC · Lewes, DEBuilt 2001 · S/N 0030N567ATIko Aero Services LLC · Natchez, MSBuilt 2006 · S/N 2188N567CTAvion Sr22 LLC · Schaumburg, ILBuilt 2008 · S/N 3205N567DEclipse Inc · Sharon Springs, KSBuilt 1980 · S/N P21000665N567DMAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2007 · S/N 2353N567DTCenturion Aviation Inc · Kalispell, MTBuilt 1978 · S/N 21062856N567JGRapid River Aviation LLC · Boulder City, NVS/N U20604816N567JJCarefree Coach LLC · Thayne, WYBuilt 2005 · S/N 41077N567KCWelch Darrnell M · Hillman, MIBuilt 1987 · S/N 4608071N567MB1 And 3 Lc · Jenks, OKBuilt 2002 · S/N 40052N567MGHay-Con Aviation LLC · Winter Park, FLBuilt 2007 · S/N 2446N567PAS & H Aviation LLC · Beaumont, TXBuilt 2007 · S/N 2640N567PFD & W Air LLC · Broken Arrow, OKBuilt 2011 · S/N 0077N567PMValiair Limited Company Trustee · Casper, WYBuilt 2018 · S/N 1748N567RTBoac 1 LLC · Knoxville, TNBuilt 2022 · S/N 8844N567SRGoal Aircrafts Corp · Orlando, FLBuilt 2006 · S/N 2097N5680CSea Spray Aviation LLC · New Smyrna Beach, FLBuilt 1978 · S/N 414A0218N5688C5688c LLC · Glendale, AZBuilt 1978 · S/N 414A0221N568HBKurreck Tim R · Caldwell, IDBuilt 1977 · S/N 21061864N568SRHaney Jeffrey · Carrollton, GABuilt 2004 · S/N 1083N568TWWestray James H · Gainesville, GABuilt 1981 · S/N 340A1252N568YSpectrapower LLC · Livermore, CABuilt 2007 · S/N 3RX083N5690CTailwinds Aircraft Holdings LLC · Harrisburg, NEBuilt 1979 · S/N 414A0222N5690ZGold Aviation LLC · Greenville, SCBuilt 1990 · S/N TH-1594N5695DVista Air LLC · Boxborough, MABuilt 2026 · S/N 11395N569DBBarnes Daniel · Valparaiso, INBuilt 2013 · S/N ES-210N569JMInternational Air Services Inc Trustee · Carson City, NVBuilt 1981 · S/N 414A0425N569KCross Timbers Aviation LLC · Bedford, TXBuilt 1999 · S/N 30-0026N569PGSavvy Investing LLC · Greencastle, INBuilt 2008 · S/N 3003N569SFTaylor Bruce L Jr · Irondale, ALBuilt 2011 · S/N 3739N56AHSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2007 · S/N 2781N56APCka Investments LLC · Mcallen, TXS/N 2768N56BKoch & Koch Inc · Grass Valley, CABuilt 1994 · S/N TH-1730N56BMAtlas Aero LLC · Fargo, NDBuilt 2014 · S/N 4085N56CMFamily Practice Associates LLC · Ulysses, KSS/N 310R1422N56DACirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11556N56DCAero Services Lc · Woods Cross, UTBuilt 1967 · S/N T210-0280N56GKMatan Kai LLC · West Hollywood, CAS/N 414A0847N56GLRainosek Kevin · Granbury, TXBuilt 1994 · S/N EA-572N56HDouble D International LLC · Miami, FLBuilt 1977 · S/N 414-0941
Back to AD 2012-10-13