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.

N678HCMckisson Holdings LLC · Renton, WABuilt 1980 · S/N EA-180N678JKCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11557N678JSGolden Pegasus LLC · Hughson, CABuilt 1978 · S/N 414A0090N678PCComplete Rv LLC · Kalispell, MTBuilt 2001 · S/N 0104N678PGDbar N881pg LLC · San Angelo, TXBuilt 2024 · S/N 9881N678PHOctothorpe Aero LLC · Kennesaw, GABuilt 2022 · S/N 8712N678SBTvpx Ars Inc Owner Trustee · North Salt Lake, UTBuilt 2025 · S/N 10634N678SRDc Air LLC · Dover, DEBuilt 2025 · S/N 10667N678TCRfpc Properties LLC · Nashville, TNBuilt 2011 · S/N 0102N678TX22t-10617 LLC · Austin, TXBuilt 2025 · S/N 10617N678ZBas Part Sales LLC · Greeley, COBuilt 2002 · S/N 0311N67909Hyannis Air Service Inc DBA · Hyannis, MABuilt 1981 · S/N 402C0449N6792GGrimmett Donna G · Tomball, TXS/N 29-0012N6797YFar West Ranches Inc · Brawley, CABuilt 1995 · S/N E-2974N679BJPpcm LLC · Altamonte Springs, FLBuilt 2024 · S/N 10320N679CDHsc Aviation LLC · Gig Harbor, WABuilt 2006 · S/N 1785N679JBLaughing Giraffe Aviation LLC · Millsboro, DEBuilt 2021 · S/N 2374N679LMLone Mountain Aircraft LLC · Vandalia, OHBuilt 2005 · S/N 1679N67ALAlan Gaudenti · Groveland, CABuilt 1988 · S/N E-2420N67AMR&R 22t1 LLC · Wilmington, DEBuilt 2020 · S/N 4922N67CDAspen Aircraft LLC · Oklahoma City, OKS/N E-2554N67CHPrestige Aviation LLC · Lake Havasu City, AZBuilt 1981 · S/N 21064354N67DFSusens Dennis W · Columbia Falls, MTBuilt 1998 · S/N 98191N67EPViner Kevin Patrick · Encinitas, CAS/N P21000032N67ERWhitfield Michael L · Leander, TXBuilt 1976 · S/N TJ-43N67GSMcmillian William C · Reno, NVBuilt 2013 · S/N 167TN67GXDivision Of Aerodynamics LLC · Littleton, COBuilt 2005 · S/N 29-0344N67JDSchweizer Jack · Grants Pass, ORBuilt 2008 · S/N ESP-214-13N67MZMain Flyer LLC · Fort Lauderdale, FLBuilt 2007 · S/N 2498N67PKNexsys Eletronics Inc · Independence, ORBuilt 2020 · S/N 1N67RKRiley Matthew · Xenia, OHS/N 310Q1107N67RZModular Aviation LLC · Saratoga Springs, UTBuilt 1981 · S/N 414A0817N67SAE And J Medical Consulting LLC · Lima, OHBuilt 2004 · S/N 0978N67TZKac Air LLC · Rindge, NHBuilt 2016 · S/N 4318N67VMCreeque Alley Ventures LLC · Missoula, MTBuilt 1980 · S/N P21000568N67ZTJazzz Air LLC · Arvada, COBuilt 2023 · S/N 9433N68007N68007 LLC · Stratford, CTBuilt 2007 · S/N 2354N6801THoffman Peter · Monrovia, CABuilt 1984 · S/N EA-429N680PBoren John D · Martinsville, INBuilt 2005 · S/N 1441N680SBSair LLC · Carmel, INBuilt 2025 · S/N 11007N680SCCotton Row Aviation LLC · Hilton Head Island, SCBuilt 2025 · S/N 10885N6814RBbc414a LLC · Alton Bay, NHBuilt 1981 · S/N 414A0638N6815TL A Flyers LLC · Monticello, ARBuilt 1981 · S/N 414A0645N6816BMystic Dreams LLC · Mount Juliet, TNBuilt 1978 · S/N 21062837N6817DGlasscock Charles W Jr · Elm Grove, LABuilt 1981 · S/N 414A0656N6818XBlue Skys Aero LLC · Vermilion, OHBuilt 1981 · S/N 414A0663N681CWalker Jabir Salim · Louisville, KYBuilt 2006 · S/N 2101N681CDSwift Bruce I · Ambler, PABuilt 2006 · S/N 1751N681JKBirdwell Jarrod · Houston, TXBuilt 2014 · S/N 0893N681MBBerger James B · Warrenton, VABuilt 2010 · S/N 3664
Back to AD 2012-10-13