N566SW
STCs that may be installed · 72
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 = '3260203'
UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '52116')
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 = '3260203'
UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '52116')
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 · Embraer EMB-120ER
STC ST411CHInstall forward lavatory panels, Models 1145, 1146, 1147.STC ST09243ACInstallation of provisions for a New Systems P/N NS 20004-1 Air Call system.STC ST09318SCNew Systems P/N NS20004-1 Air Call (SELCAL) unit.STC ST105CHInstallation of a Sundstrand Mark VI ground proximity warning system (GPWS) Mark VI.STC ST57CHInstallation of Sundstrand Mark VI, Ground Proximity Warning System.STC ST412CHInstallation of MAPCO Model 1144.STC ST320CHInstallation of landing gear harnesses and proximity switch.STC ST235CHInstallation of MAPCO Model 1140 galley.STC ST169CHInstallation of trim proximity sensor.
Engine · Pratt & Whitney Canada PW118
STC SE2805SOInstallation of an oil tank safety cap adapter which is intended to prevent loss of oil in the event of loss or damage to the oil filler cap.STC SE00023ENInstallation of Oil Tank Filler Neck Check Valve, Part Number TSA100Sa, Parts List Rev A dated 7/3/1997.STC SE01638NYInstallation of HP Turbine vanes with improved cooling.STC SE00344LAInstallation of Western Filter Corp. oil filter element, P/N WF334638, as a replacement for the P&W Canada filter element, P/N 3112895-01, in the lubrication system.STC SE792NEInstallation of oil tank filler neck check valve P/N TSA-100 SA.STC SE00097LAInstallation of strainer element, P/N 90220, as a replacement for strainer element, P/N 3106403-01, in the oil pressure transfer tube assembly.STC SE01045ATInstallation of engine ignition leadSTC SE00074LAInstallation of Puroflow filter element, P/N 11-11064, as a replacement for P&W Canada filter element, P/N3029315 (and optional numbers) in the reduction gearbox scavenge oil filtering system.STC SE00075LAInstallation of Puroflow filter element, P/N 11-11065, as a replacement for P&W Canada filter element, P/N3112895-01, in the reduction gearbox scavenge oil filtering system.STC SE00076LAInstallation of Puroflow filter element, P/N 11-11084, as a replacement for P&W Canada filter element, P/N3035681 (and optional part numbers) in the engine fuel filtering system.STC SE00079LAInstallation of Puroflow filter element, P/N 11-11085, as a replacement for P&W Canada filter element, P/N3035728 (and optional part numbers) in the engine fuel filtering system.STC SE00082LAInstallation of Puroflow filter element, P/N 11-11102, as a replacement for P&W Canada filter element, P/N3038454, in the engine fuel filtering system.STC SE00083LAInstallation of Puroflow filter element, P/N 70-106, as a replacement for P&W Canada filter element, P/N3034190, in the reduction gearbox scavenge oil filtering system.