N950MD
STCs that may be installed · 109
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 = '8780610'
UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '01588')
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 = '8780610'
UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '01588')
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 · Swearingen SA227-AT
STC SA1243SOInstallation of a Bendix FCS-8700B automatic flight control system including optional flight director.STC SA1684CEInstallation of Collins AP-106 autopilot system with various flight director systems.STC SA1677CEInstallation of Sperry SPZ-500 automatic flight control system.STC SA1678CEInstallation of Sperry AA-200 radio altimeter system with Sperry VA-100 advisory.STC SA36NWInstallation of Sundstrand Ground Proximity Warning SystemSTC SA00281BO PAGE 2Installation of Avidyne Corporation MLX770 MultiLink Broadcast Transceiver P/N 700-00163-( ), Sensor Systems Inc. Antenna P/N S67-1575-109, or equivalent, and optional Avidyne Mounting Tray P/N 700-00165-000STC SA01933LAInstallation of Garmin Model 400W / 500W Series GPS-WAAS Navigation SystemSTC SA01229SEInstallation of CNX80 GPS WAAS Navigator with integrated VHF Navigation and Communication radios.