N76DN
STCs that may be installed · 391
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 = '8143007'
UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '52033')
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 = '8143007'
UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '52033')
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 · Sikorsky S-76B
STC SH2416SOInstallation of the Honeywell LSZ-850 Lightning Sensor System.STC SH2429SOInstallation of a Cabin Lighting Control System.STC SH2430SOInstallation of a Precise Flight Pulselite System.STC SH2431SOInstallation of Recognition Lights.STC SH2433SOInstallation of a Global Wulfsberg Flitefone VI System.STC SH2564SOInstallation of a UNS-1A compact flight management system.STC SH2682SOInstallation of the ELT-100HM emergency locator transmitter.STC SH2738SOInstallation of a Collins RMI-36 indicator system.STC SH1559SOInstallation of the King Gold Crown III KXP 756 transponder.STC SH2599SOModification of forward keel beam at Station 37.75.STC SH2600SOModify cabin floor to add six inspection holes.STC SH2601SOAddition of hinge to fuel cell filler cap.STC SH1868SOInstallation of King KNR-634 (pilots) VOR system.STC SH1869SOInstallation of King KNR-634 (copilots) VOR system.STC SH1870SOInstallation of King KDM-706A (pilots) distance measuring equipment.STC SH2357SOInstallation of a power monitor panel (INSCO).STC SH2415SOInstallation of the Honeywell Primus-870 weather radar.STC SH2512SOInstallation of a Single Wulfsberg Global GNS 500A series 4 VLF/Omega system.STC SH2517SOInstallation of interior.STC SH2807SOInstallation of a Universal Navigation system CVR-80 cockpit voice recorder.STC SH2900SOInstallation of a Honeywell P-700 radar system.STC SH2758SOInstallation of provisions for rappelling and fast roping equipment.STC SH2847SOInstallation of a Honeywell data nav III system.STC SH1552SOInstallation of the Collins Proline II dual TDR-90 transponders.STC SH2358SOInstallation of gearbox inspection lights.STC SH2361SOInstallation of a fixed landing light.STC SH2412SOInstallation of the Honeywell Dual EDZ-705 Electronic Flight System(EFIS).STC SH2570SOInstallation of an external power overvoltage monitor.STC SH2615SOInstallation of a Logo light system.STC SH2736SOInstallation of a Collins ADF-462 automatic direction finder.STC SH2737SOInstallation of a Dual/Single ALT-55B altimeter system.STC SH2745SOInstallation of Wakman analog clocks.STC SH2749SOInstallation of a radio altitude warning system.STC SH2750SOInstallation of a Wulfsburg FM radio system.STC SH2752SOInstallation of an ARC-159 UHF communications system.STC SH2753SOInstallation of a Baker audio system.STC SH2760SOInstallation of a cargo hook load indicating system.STC SH2846SOInstallation of a Collins DF-301E direction finder system.STC SH2848SOInstallation of a Racal MK-II Nav management system.STC SH2806SOInstallation of a Bendix 5 tube EFIS 10 system.STC SH1557SOInstallation of the King Gold Crown III KNR 634 pilot's VHF NAV system to include appropriate interface with the SPERRY SPZ7000 automated flight control system.STC SH1558SOInstallation of the King Gold Crown III KNR 634 co-pilot's VHF NAV system to include appropriate interface with the Sperry SPZ 7000 automated flight control system.STC SH1562SOInstallation of the King Gold Crown III KDM 706A distance measuring equipment to include appropriate interface with the SPERRY 7000 automated flight control system.STC SH1668SOInstallation of the Bendix VNS-40A No. 1 VHF communications transceiver system.STC SH1669SOInstallation of the Bendix VCS-41A No. 1 navigation system to include appropriate interface with the SPERRY SPZ-7000 automatic flight control system.STC SH1670SOInstallation of the Bendix dual TRS-42A transponder system.STC SH1671SOInstallation of the Bendix DFS-43A ADF directional finder system to include appropriate interface with the SPERRY SPZ7000 automated flight control system.STC SH1672SOInstallation of the Bendix DMS-44A No. 1 DME distance measurement system to include appropriate interface with the SPERRY SPZ-7000 automatic flight control system.STC SH1673SOInstallation of the Bendix VCS-40A No. 2 VHF communication transceiver system.STC SH1674SOInstallation of the Bendix VNS-41A, No. 2 navigation system to include appropriate interface with the SPERRY SPZ7000 automtic flight control system.