N231AS
STCs that may be installed · 357
Approved for this aircraft’s airframe or engine model. The registry doesn’t record which STCs an aircraft has; its records do. In force first, then newest.
Query with SQL
duckdb -csv -c "SELECT m.matched_by, s.stc_number, s.description, s.holder, s.status, s.status_date, m.matched_model
FROM (
SELECT stc_number, min(side) AS side, arg_min(matched_by, side) AS matched_by, arg_min(matched_model, side) AS matched_model
FROM (SELECT stc_number, 1 AS side, 'airframe' AS matched_by, matched_model FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_stc.parquet' WHERE aircraft_model_code = '5870220'
UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '17019')
GROUP BY stc_number
) m JOIN 'https://openairdocs.org/data/latest/faa_stc.parquet' s USING (stc_number)
ORDER BY m.side, s.status = 'Current' DESC, s.status_date DESC, s.stc_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.
SELECT m.matched_by, s.stc_number, s.description, s.holder, s.status, s.status_date, m.matched_model
FROM (
SELECT stc_number, min(side) AS side, arg_min(matched_by, side) AS matched_by, arg_min(matched_model, side) AS matched_model
FROM (SELECT stc_number, 1 AS side, 'airframe' AS matched_by, matched_model FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_stc.parquet' WHERE aircraft_model_code = '5870220'
UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '17019')
GROUP BY stc_number
) m JOIN 'https://openairdocs.org/data/latest/faa_stc.parquet' s USING (stc_number)
ORDER BY m.side, s.status = 'Current' DESC, s.status_date DESC, s.stc_numberRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
Airframe · Mooney M20K
STC SA3341NMInstallation of Spoilers, Inc hydraulically operated wing spoiler systemSTC SA3457SW-DInstallation of Century automatic flight system Model AK962 consisting of a Century 2110/2130/2131 autopilot.STC SA3561NMInstallation of ARNAV systems FC-10 or FT-10 digital fuel flow indicating system.STC SA6099SW-DInstallation of S-TEC System 65 two axis automatic flight guidance system, Model ST-384.STC SA5228SW-DInstallation of S-TEC yaw damper system, Model ST-112.STC SA5394SW-DInstallation of S-TEC yaw damper system, model ST-320.STC SA3445SW-DInstallation of Century atuomatic flight system, model AK950 consisting of a Century 2010/2030/2031 autopilot.STC SA3445SWDInstallation of Century automatic flight system, Model AK950 consisting of a Century 2010/2030/2031 autopilot.STC SA5278SW-DInstallation of S-TEC System 60 two axis automatic flight guidance system, Model ST-114, with optional automatic electric trim system.STC SA6079SW-DInstallation of S-TEC System 65 two axis automatic flight guidance system, Model ST-369.STC SA6073SW-DInstallation of S-TEC system 40/50 single and two axis automatic flight guidance systems model ST-334-40/50.STC SA6073SWDInstallation of S-TEC system 40/50 single and two axis automatic flight guidance systems Model ST-334-40/50.STC SA6065SW-DInstallation of S-TEC system 60 pitch stabilization system Model ST-336, with optional automatic electric trim systemSTC SA6065SWDInstallation of S-TEC system 60 pitch stabilization system Model ST-336.STC SA3338NMInstallation of Spoilers, Inc hydraulically operated wing spoiler systemSTC SA3325NMInstallation of Spoiler, Inc hydraulically operated wing spoiler systemSTC SA5392SW-DInstallation of S-TEC system 60 two axis automatic flight guidance system, Model ST-319, with optional automatic electric trim system.STC SA5393SW-DInstallation of S-TEC System 60 single axis automatic flight guidance system, model ST-318.STC SA5395SW-DInstallation of S-TEC manual electric trim system, model ST-322.STC SA5222SW-DInstallation of S-TEC system 40/50 single and two axis automatic flight guidance systems, model ST-192-40/50.STC SA5222SWDInstallation of S-TEC System40/50 single and two axis automatic flight guidance systems, Model ST-192-40/50.STC SA3049SW-DInstallation of Mitchell automatic flight system model AK475 consisting of Century I autopilot with optional omni tracker.STC SA3049SWDMitchell automatic flight system AK475 consisting of Century I autopilot with optional omni tracker.STC SA1418SOReplacement of rotor vanes in Airborne 211CC and 212CW vacuum pumps. (See limitations)STC SA2190NM PAGE 1Installation of electronics International Digital Volt/Amp Gauges and Accessories.STC SA3308SW-DInstallation of Mitchell automatic flight system AK802 consisting of Century 21 autopilot.STC SA3308SWDInstallation of Mitchell automatic flight system AK802 consisting of Century 21 autopilot.STC SA3325SW-DMitchell automatic flight system AK807 consisting of Century 41 autopilot flight direcotr autopilot.STC SA3325SWDMitchell automatic flight system AK807 consisting of Century 41 autopilot flight director autopilot.STC SA3382SW-DMitchell automatic flight system consisting of Century 31 autopilot.STC SA3382SWDMitchell automatic flight system consisting of Century 31 autopilot.STC SA3326SW-DInstallation of Mitchell command electric system model AK808.STC SA3326SWDInstallation of Mitchell command electric system Model AK808.STC SA1557CEDInstallation of KAS 297 altitude select option.STC SA1561CEDInstallation of KAP 100 single axis, KAP 150 two-axis, or FKC 150 two-axis flight control system.STC SA1771CEDInstallation of King KFC 200 flight control system (2 axis), with or without flight director. (M20J s/n 24-1368, 24-1419 and up) (M20K s/n 25-0740, 25-0791 and up)STC SA5141SW-DInstallation of S-TEC system 60 pitch stabilization system Model ST-116 with optional automatic electric trim system.STC SA2052NMInstallation of Beryl D'Shannon Aviation Specialties Engine Crankcase Breather Air-Oil SeperatorSTC SA4658SWInstallation of Texas Instruments, Inc. Loran C Model TI 9100.STC SA5141SWDS-TEC System 60 pitch stabilization system ST-116 with optional automatic electric trim system.STC SA4712SWInstallation of S-TEC yaw damper system model ST-112STC SA4713SWInstallation of S-TEC Corporation System 60 two axis automatic flight guidance system Model ST-114 with optional autotrim system and with optional flight director steering horizon.STC SA334SWInstallation of InterAv Alternator.STC SA1570WEInstallation of Brittain NAV-2 flight control system.STC SA1584WEInstallation of Brittain Model B-6 flight control system.STC SA1780WEInstallation of Brittain Industries LSA-5 flight control system.STC SA1785WEInstallation of Brittain Industries B2C flight control system.STC SA1786WEInstallation of Brittain Industries B-6 flight control system.STC SA1-615Installation of Fram lube oil filter Model PB55-1.STC SA1177WEWECO carburetor temperature monitor.