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.

N60MKAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1981 · S/N P21000670N60PKWexcap Leasing LLC · Centerville, UTS/N 21064916N60PPJaams LLC · Shafter, CABuilt 1976 · S/N 340A0073N60PZRbj Tn Holdings LLC · Sheridan, WYBuilt 2016 · S/N 1275N60RSVolare Alto LLC · Sanford, NCBuilt 1980 · S/N P21000521N60SHBas Part Sales LLC · Greeley, COBuilt 1980 · S/N TJ-267N60UHSecret Destinations LLC · Gretna, LABuilt 2011 · S/N 3784N60WHSan Clemente David Paul · Edgewater, FLBuilt 1976 · S/N 340A0083N6100YRamsay Allan Trustee · Modesto, CABuilt 1981 · S/N 21064250N6102WPlane Blessings LLC · Montrose, COBuilt 1981 · S/N P21000715N6103YQualitair LLC Trustee · MichelstadtBuilt 2003 · S/N 0634N6105XKramer James W Jr · Eynon, PABuilt 2003 · S/N 0618N6106CB & S Aviation Enterprises LLC · Atlantic Beach, FLBuilt 2003 · S/N 0601N6107QKk Equipment Leasing LLC · Seguin, TXBuilt 2003 · S/N 0633N6109RBas Part Sales LLC · Greeley, COBuilt 1965 · S/N T210-0009N610CDChalin Flight Services LLC · Wilmington, DEBuilt 2019 · S/N 4759N610CFCarbon Air LLC · Cypress, TXBuilt 2021 · S/N 2278N610GBSierra Zulu Aircraft Holdings LLC · Lake Elmo, MNFirst renewal noticeBuilt 2013 · S/N 0444N610KCU S Imaging Flight Ops LLC · Bartow, FLBuilt 1981 · S/N 21064258N610PPPoolside Aviation LLC · Pottstown, PABuilt 2025 · S/N 11028N6112ABarreto Manufacturing Inc · La Grande, ORS/N 21063498N6116NWalker Stephen · Fairhope, ALBuilt 2022 · S/N 8843N61170Rusty Pilot Holdings LLC · Citrus Heights, CABuilt 1974 · S/N 21060602N6119ABrender Ronald F Trustee · West Lafayette, INBuilt 1979 · S/N 21063502N611AWLess Swelling Equals Less Pain LLC · Brewerton, NYBuilt 2025 · S/N 11020N611CCTjc Productions LLC · Ogden, UTBuilt 1979 · S/N 21063600N611CDPj Aviation LLC · Lake Worth, FLBuilt 2005 · S/N 1599N611CTBrown Jed A · Laredo, TXBuilt 2008 · S/N 2911N611ESGs Flying Club LLC · Bethlehem, PABuilt 2008 · S/N 3053N611KFRegistered aircraftBuilt 2023 · S/N 9041N611KGProckter Aviation LLC · Lagrangeville, NYBuilt 2005 · S/N 1551N611PGWrightson Properties LLC · Ft Lauderdale, FLBuilt 1985 · S/N 21064911N611PMYankaitis Michael J · Mosinee, WIBuilt 2005 · S/N ES-117N611RAH & K Acquisitions LLC · Peoria, AZBuilt 2014 · S/N 0914N611RJRj 400 LLC · Iowa City, IAS/N 41044N611RMRm Management Corp · Johnson City, TNBuilt 2004 · S/N 1133N611RPParish Oil Co Inc · Columbia City, INFirst renewal noticeBuilt 2017 · S/N 1498N611RTGrutza Robert J · Maysville, KYBuilt 2007 · S/N 2523N611VRRex Vinod · Sunnyvale, CABuilt 2004 · S/N 0924N611WBDelicious Epiphany LLC · Fort Wayne, INBuilt 2022 · S/N 9006N611WSFreedom Flight Service LLC · Glendale, AZBuilt 1975 · S/N 21061134N6121XCrawford Products Co Inc · Huntington Beach, CABuilt 2015 · S/N 1082N6126CM20k LLC · Minot, NDBuilt 1978 · S/N 310R1293N6126YCruise Flight Aviation Inc · Denver, COBuilt 1981 · S/N 21064260N61275K & K Adventures Inc · Wilmington, DEBuilt 1974 · S/N 21060604N612CTGl One LLC · Ankeny, IABuilt 2008 · S/N 3062N612EZCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 4734N612JJDelaware Aircraft Trust Trustee · New Castle, DEBuilt 2025 · S/N 10508N612JMPerformance Aviation LLC · Zionsville, INBuilt 2010 · S/N 3692N612JRQ & A Company LLC · Newport, RIBuilt 1980 · S/N 340A0927
Back to AD 2012-10-13