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.

N605LMBst Cirrus LLC · Mooresville, NCBuilt 2017 · S/N 4530N605MHSteinberg Kenneth R · Longport, NJBuilt 2005 · S/N 1469N605PTLoguidice Kevin · Hillsborough, NCBuilt 2018 · S/N 1692N605RMClear Prop Aviation LLC · Palo Alto, CABuilt 2014 · S/N 4133N605TFOpportunity Knocks LLC · Sioux Falls, SDBuilt 2024 · S/N 10217N605WKJ4 Aviation LLC · Brooks, GABuilt 2025 · S/N 10994N60636Allard Michael L · Penrose, COS/N 21060596N6067TSullivan Patrick V · Chicago, ILBuilt 2002 · S/N E-3467N6069PAirborne Helicopters LLC · Hendrum, MNBuilt 1978 · S/N P21000136N606BCBell Camp Inc · Lubbock, TXFirst renewal noticeBuilt 1980 · S/N EA-72N606CTPkck Plane LLC · Newton, MABuilt 2019 · S/N 4852N606KHWood & Wood Aviation LLC · Boaz, ALBuilt 2016 · S/N 4418N606MFAtaraxia Aircraft Holdings LLC · Greenville, SCS/N 3799N606PPAndriopulos Salguero Inc · Hialeah, FLS/N 414-0416N606REPebblebrook Aviation LLC · Ellinwood, KSBuilt 1982 · S/N TJ-430N606WMHolt Timothy L · Foristell, MOBuilt 1995 · S/N 29-0070N6071BRoss Bryan L · Marion, MSBuilt 2003 · S/N 0566N607GSGaines Robert G · Howell, MIBuilt 1982 · S/N TK-147N607JDJd 707 Air LLC · Edgerton, OHBuilt 1978 · S/N 414A0071N607PCCidale David R · Grand Island, NYBuilt 2005 · S/N 1624N607TL100% Made In The USA Bully Tools Inc · Steubenville, OHBuilt 2024 · S/N 9853N6083BListo Aviation LLC · Lewes, DEFirst renewal noticeBuilt 1978 · S/N 21062677N6084BCenturion Aviation Ltd · Salina, KSBuilt 1978 · S/N 21062678N6088PSide Deck Event Management LLC · Lexington, SCBuilt 1978 · S/N P21000141N608AEFreedom Aviation LLC · Weatherford, TXBuilt 2003 · S/N 0611N608CAPlane Goat Resources LLC · Canyon Lake, TXBuilt 2026 · S/N 11107N608CDHorizon Ventures Inc · Fayetteville, ARBuilt 2006 · S/N 2076N608FDMjd Yuma Enterprises LLC · Yuma, AZBuilt 1981 · S/N 21064261N608JSJuliet Sierra Enterprises LLC · Dallas, TXBuilt 2026 · S/N 11144N608SRMachugh Cliffton D · Albany, ORBuilt 2007 · S/N 2520N6094BT 210 Telluride Corp · Aspen, COBuilt 1978 · S/N 21062681N6098XKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1978 · S/N 310R1266N6099WGriffith Aviation Co · Tulsa, OKBuilt 1981 · S/N P21000713N609AEGundersen Erik · Chino Hills, CABuilt 2003 · S/N 0609N609AYAikawa Medical Management Co Inc Trustee · Cheyenne, WYBuilt 2022 · S/N 0920N609CThorson Gregory · Mequon, WIBuilt 2003 · S/N 0440N609CDCavu Aviation LLC · Huntsville, ALBuilt 2004 · S/N 0948N609DWith Pride Aviation LLC · Farmingdale, NYBuilt 2025 · S/N 10609N609KGGeiger Aviation LLC · Wilmington, DEFirst renewal noticeBuilt 2005 · S/N 1731N609MRScudder Aviation LLC · Enid, OKBuilt 2018 · S/N 4654N609RLT And B Mgmt LLC · Las Vegas, NVBuilt 1979 · S/N 21063802N60AMCleveland Flying Inc · Cleveland, MSS/N CE-764N60CFArq Aviation LLC · Wilmington, NCBuilt 2024 · S/N 10153N60DMDatom Inc · Culver City, CABuilt 1979 · S/N 340A0711N60DNNlw Inc · Indianapolis, INBuilt 2025 · S/N 10798N60DRSudeep Singh Flllp · Clovis, CABuilt 1978 · S/N E-1214N60DWJohnson Boyd · Apple Valley, MNBuilt 1981 · S/N P21000696N60EDawson Aircraft Inc · Clinton, ARBuilt 1979 · S/N 340A0663N60HSProfile Holdings Inc · Newmarket, NHBuilt 2022 · S/N 8642N60JHRdu Aviation LLC · Raleigh, NCBuilt 2013 · S/N 0529
Back to AD 2012-10-13