N201CZ
STCs that may be installed · 431
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 = '5870219'
UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '41515')
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 = '5870219'
UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '41515')
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 M20J
STC SA563NEInstallation of Auto-Vac 2 auxiliary vacuum system.STC SA3341NMInstallation of Spoilers, Inc hydraulically operated wing spoiler systemSTC SA3456SW-DInstallation of Century automatic flight systems, Model AK961 consisting of a Century 2110/2130/2131 autopilot.STC SA6098SW-DInstallation of S-TEC System 65 two axis automatic flight guidance system, Model ST-383.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 SA5276SW-DInstallation of S-TEC system 60 two axis automatic flight guidance system model ST-015 with optional automatic electric trim system.STC SA5276SWDInstallation of S-TEC system 60 two axis automatic flight guidance system Model ST-015 with optional automatic electric trim system.STC SA6080SW-DInstallation of S-TEC System 65 two axis automatic flight guidance system.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 SA3266NMInstallation of ARNAV Systems FC-10 or FT-10 digital fuel flow indicating system.STC SA6070SW-DInstallation of S-TEC system 60 pitch stabilization system, Model ST-335, with optional automatic electric trim systemSTC SA6070SWDInstallation of S-TEC system 60 pitch stabilization system, Model ST-335.STC SA6052SW-DInstallation of S-TEC system 60 two axis automatic flight guidance system, model ST-333, with optional automatic electric trim systemSTC SA6052SWDInstallation of S-TEC System 60 two axis automatic flight guidance system, Model ST-333.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 SA5134SW-DInstallation of S-TEC system 60 pitch stabiization system Model ST-049 with optional automatic electric trim.STC SA5134SWDS-TEC System 60 pitch stabilization system ST-049 with optional automatic electric trim.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 SA3048SW-DInstallation of Mitchell automatic flight system model AK476 consisting of Century IIB autopilot with optional radio coupler.STC SA3048SWDMitchell automatic flight system AK476 consisting of Century IIB autopilot with optional radio coupler.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 SA3047SW-DInstallation of Mitchell automatic flight system model AK523 consisting of Century III autopilot with optional radio coupler and glide slope couplerSTC SA3047SWDMitchell automatic flight system AK523 consisting of Century III autopilot with optional radio and glide slope couplers.STC SA3064SW-DInstallation of Mitchell command electric trim system model AK541.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 SA225NEReplace original wheel brake discs with discs modified in accordance with Aviation Services.STC SA3307SW-DInstallation of Mitchell automatic flight system AK801 consisting of Century 41 autopilot or model AK801FD consisting of Century 41 flight director autopilot.STC SA3307SWDInstallation of Mitchell automatic flight system AK801 consisting of Century 41 autopilot or Model AK801FD consisting of Century 41 flight director autopilot.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 SA3383SW-DInstallation of Mitchell automatic flight system, Model AK 884 consisting of a Century 31 autopilot.STC SA3383SWDInstallation of Mitchell automatic flight system, Model AK884 consisting of a Century 31 autopilot.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 SA4658SWInstallation of Texas Instruments, Inc. Loran C Model TI 9100.STC SA4470NMInstallation of flap gap seals.STC SA4176SWInstallation of S-TEC system 60 two axis flight guidance system, Model ST-015, with optional autotrim systemSTC SA4131SWInstallation of S-TEC system 60 single axis automatic flight guidance system, Model ST-004.STC SA4387SWInstallation of S-TEC system 60 pitch stabilization system Model ST-049STC SA4712SWInstallation of S-TEC yaw damper system model ST-112STC SA334SWInstallation of InterAv Alternator.STC SA1641CEInstallation safe flight SC-150 stall warning and angle of attack indicating system.STC SA4177SWInstallation of S-TEC manual electric trim system, Model ST-022.