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.

N717JB737 Cessna Inc · Naples, FLS/N 2128N717JKKallathesis Aviation LLC · Wake Forest, NCBuilt 2022 · S/N 8869N717KGLive & Let Fly LLC · Dayton, MNBuilt 2023 · S/N 9518N717KKKelly Aviation Of Naples LLC · The Villages, FLBuilt 2024 · S/N 10123N717MDMoore Don L · Longwood, FLBuilt 2023 · S/N 9389N717MRSt Johns Aviation Partners II · Beaumont, TXBuilt 1980 · S/N P21000601N717MSSahin Holding LLC · Fountain Hills, AZBuilt 2018 · S/N 1698N717PGMc Consultants LLC · Isle Of Palms, SCBuilt 2005 · S/N 1711N717PTQuail Land Co LLC · Goldthwaite, TXBuilt 2022 · S/N 8592N717SNM2 Companies LLC · Loveland, COBuilt 2016 · S/N 1254N717SUMouki Aviation LLC · South Lake Tahoe, CABuilt 2004 · S/N 0969N717TVPinkert Sy · Silverthorne, COBuilt 1978 · S/N 310R1341N717VMTir Holdings LLC · Safety Harbor, FLBuilt 2007 · S/N 2364N717VZGoldberg James J · Cornelius, NCBuilt 2020 · S/N 2146N717WHCelebrity Aviation LLC · Tupelo, MSBuilt 2004 · S/N 1201N717WTCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11609N717ZStephanie Air LLC · Chester Springs, PABuilt 2023 · S/N 9520N717ZTAngry Biscuit Management LLC · Austin, TXBuilt 2014 · S/N 0888N718AJGranados Air LLC · West Palm Beach, FLBuilt 2019 · S/N 4830N718BLRdm Aviation LLC · Mount Pleasant, SCBuilt 2018 · S/N 4624N718BPBaywater Publishing LLC · San Mateo, CABuilt 2013 · S/N 0609N718CLBlue Sky Holdings LLC · Brule, NEBuilt 2019 · S/N 4818N718DEDelta Echo Aviation Series LLC Series N718de · Shavano Park, TXBuilt 2014 · S/N 0950N718EMRlss Aviation Holdings LLC · Nashville, TNBuilt 2018 · S/N 1806N718JBJ & B Aviation LLC · Rochester, MNBuilt 2014 · S/N 0657N718PTTechnology Transportation Co Inc · La Crosse, WIBuilt 2003 · S/N 29-0294N718SAAsank Aviation LLC · Las Vegas, NVBuilt 2021 · S/N 2458N718SBSouthernbelle LLC · Santa Rosa Beach, FLBuilt 2017 · S/N 1578N718SGLb Eagle Aviation LLC · Manhattan Beach, CABuilt 2026 · S/N 11313N718SPCirrusly LLC · Edmond, OKBuilt 2015 · S/N 4185N718SRLone Mountain Aircraft LLC · Springfield, OHBuilt 2006 · S/N 2252N718TLBuildup LLC · Naples, FLFirst renewal noticeBuilt 2014 · S/N 4103N719CSDavis Robert · Presque Isle, MEBuilt 2012 · S/N 3832N719DCRosse Bradley E · Concord, MABuilt 2006 · S/N 2069N719EDWerner Thomas · Grand Island, NEBuilt 2007 · S/N 2758N719JDGround Effect LLC · Missoula, MTS/N 0470N719KSMakai Investments LLC · Boulder, COBuilt 2022 · S/N 8989N719LLTownsend Robert E · Newberg, ORBuilt 2016 · S/N 1421N719LMPurcell Daniel G · Spotsylvania, VAS/N 0590N719LPTactical Innovations LLC · Beckley, WVBuilt 2015 · S/N 1000N719RKIziair LLC · Mclean, VABuilt 2026 · S/N 11114N719SRAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2006 · S/N 2269N719TMInnovative Flight Systems LLC · Lewes, DEBuilt 2026 · S/N 11500N719TSCrawford Michael · Carlsbad, CABuilt 2012 · S/N 0327N71AZHolsinger Law LLC · Denver, COBuilt 2003 · S/N ES-050N71BFPlane Fun Inc Tr Trustee · Snellville, GAS/N 29-0412N71CVGo To Fly LLC · North Miami, FLBuilt 2020 · S/N 4976N71JBSl Air LLC · South Portland, MEBuilt 2022 · S/N 8838N71LXRdd Enterprises LLC · Redmond, ORS/N 101N71MKWyeth Patrick · Chino Valley, AZBuilt 1980 · S/N P21000590
Back to AD 2012-10-13