N37KB
STCs that may be installed · 589
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 = '1151538'
UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '17032')
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 = '1151538'
UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '17032')
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 · Beech V35
STC SA4302NMInstallation of Electronics Int'l digital automatic engine analyzer.STC SA2682NMReplacement of original powerplant with a Continental IO-550-B engine& McCauley D3A32C409-82NDB-2propeller with associated spinner assembly.STC SA2501CEInstallation of Bendix/King MLS-21Microwave Landing System.STC SA2305CEInstallation of Sperry MLS-910Microwave Landing System.STC SA3862NM PAGE 1Installation of Electronics International Primary TIT/EGT/CHT instruments, remote switches and associated accessories.STC SA3256NMInstallation of FC-10 or FT-10digital fuel flow indicating system.STC SA2798NMInstallation of modified exhaust heat muffler.STC SA2771NMInstallation of photovoltaic battery charging system.STC SA660WEInstallation of HRD-type fire extinguishing system. (AND STC SA111WE)STC SA6081SW-DInstallation of S-TEC system 65 two axis automatic flight guidance system, Model ST-365.STC SA1455NMInstallation of a flame proof auxiliary heater-dryer, Model12-1600.STC SA1822CEInstallation of airborne auxiliary dry air pump.STC SA180GLInstall Norton Company radar pod P/N 4133X.STC SA1826NMInstallation of Safe Flight model SC-150 lift detector system.STC SA1500SWInstallation of Mitchell Automatic Flight System Mode1 AK437 consisting of Century IV Autopilot with Trim and AK437/FD consisting of Century IV Autopilot/Flight Director with TrimSTC SA1722SWInstallation of Mitchell automatic flight system Model AK402 consisting Of Century IIB autopilot with optional radio coupler.STC SA1744SWInstallation of Mitchell automatic flight system Model AK409 consisting of Century I autopilot with optional omni tracker.STC SA1501SWInstallation of Mitchell automatic flight system AK383 consisting of Century III autopilot with optional command automatic electric pitch trim,radio coupler, and glide slope coupler.STC SA1269SWInstallation of Mitchell automatic flight system Model AK328 consisting of Century I autopilot with optional omni tracking system.STC SA925SWInstallation of Mitchell automatic flight system AK263 cons. of Century II autopilot with optional radio coupler.STC SA824SWInstallation of Mitchell automatic flight system Model AK248 consisting of Century II autopilot with optional radio coupler.STC SA882SWInstallation of Mitchell automatic flight system AK260 consisting of Century III autopilot with optional radio coupler, automatic pitch trim,and automatic aileron stabilizer.STC SA93GLInstall left hand side window, P/N W-2048 or W/T-2048.STC SA94GLInstall right side door window,P/N W-2049 or W/T-2049.STC SA638SWInstallation of Mitchell automatic flight system Model AK202,consisting of Century III autopilot with optional automatic pitch trim and radio coupler.STC SA701SWInstallation of Mitchell automatic flight system Model 205 consisting of Century II autopilot, automatic aileron stabilizer and radio coupler.STC SA754SWInstallation of Mitchell automatic aileron stabilizer Model AK203.STC SA3034SW-DInstallation of Mitchell automatic flight system Model AK503 consisting of a Century IV autopilot or AK503FD consisting of a Century IV flight director autopilot with optional remote annunciator.STC SA3172SW-DInstallation of Mitchell Yaw Damper System Model YK631.STC SA3159SW-DInstallation of Mitchell Automatic Flight System Model AK409 consisting of Century I Autopilot with Optional Omni TrackerSTC SA3117SW-DInstallation of Mitchell automatic flight system Model 328 consisting of Century I Autopilot with Optional Omni TrackerSTC SA3292SW-DInstallation of Mitchell command electric trim model AK726.STC SA4598SWInstallation of TI9100 Loran C navigation unit.STC SA2190NM PAGE 1Installation of electronics International Digital Volt/Amp Gauges and Accessories.STC SA5209SW-DInstallation of S-TEC System 40/50 single and two axis automatic flight guidance system Model ST-186-40/50.STC SA3310SW-DInstallation of Mitchell automatic flight system AK804 consisting of Century41 autopilot or AK804FD consisting of Century 41 autopilot flight director.STC SA3324SW-DInstallation of Mitchell automatic flight system AK803 consisting of Century21 autopilot.STC SA3327SWInstallation of Mitchell automatic flight system AK805 consisting of Century21 autopilot.STC SA3328SWInstallation of Mitchell automatic flight system AK806/FD consisting of Century 41/flight director autopilot.STC SA3401SW-DInstallation of Mitchell automatic flight system Model AK906 consisting of a Century 31autopilot.STC SA5179SW-DInstallation of S-TEC System 60 pitch stabilizer system Model ST-054 with optional automatic electric trim system.STC SA2058NMInstallation of a removable nose cowl doorSTC SA4085SWInstallation of S-TEC System 60 single axis automatic flight guidance system model ST-001.STC SA1411NMInstallation of a camera port and a view finder holeSTC SA4558SWInstallation of S-TEC yaw damper system, Model ST-072.STC SA4139SWInstallation of S-TEC system 60 two axis flight guidance system Model ST-007 with optional autotrim systemSTC SA4416SWInstallation of S-TEC system 60 pitch stabilization system, model ST-054 with optional autotrim systemSTC SA152NWInstallation of deck and glare shield (with or without instrument lights).STC SA4323WEInstallation of a ventral fin trim tab.STC SA328GLInstallation of Norton radome kit No. 4222X.