Sikorsky S-76B
STCs that may be installed · 333
In force first, then newest. The registry doesn’t record which STCs an aircraft has.
Query with SQL
duckdb -csv -c "SELECT s.stc_number, s.description, s.holder, s.status, s.status_date, m.matched_model
FROM (
SELECT stc_number, min(matched_model) AS matched_model
FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_stc.parquet'
WHERE aircraft_model_code IN ('8143007')
GROUP BY stc_number
) m JOIN 'https://openairdocs.org/data/latest/faa_stc.parquet' s USING (stc_number)
ORDER BY 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 s.stc_number, s.description, s.holder, s.status, s.status_date, m.matched_model
FROM (
SELECT stc_number, min(matched_model) AS matched_model
FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_stc.parquet'
WHERE aircraft_model_code IN ('8143007')
GROUP BY stc_number
) m JOIN 'https://openairdocs.org/data/latest/faa_stc.parquet' s USING (stc_number)
ORDER BY 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.
STC SH1675SOInstallation of the Bendix DMS-44A2 DME distance measurement equipment to include appropriate interface with the SPERRY 7000 automated flight control system.STC SH1726SOInstallation of a Ryan WX-10A stormscope.STC SA4302NMInstallation of Electronics Int'l digital automatic engine analyzer.STC SH2598SORelocation of external power receptacle.STC SH2602SOModification of web on bulkhead at Station 255.STC SH2571SOInstallation of a Foxtronics battery temperature monitor system.STC SH2537SOInstallation of an emergency medical service.STC SH2516SOInstallation of condensed master switch panel.STC SH2360SOInstallation of a search light switch on collective stick.STC SH2362SOInstallation of a dual static inverter AC power system.STC SH2225SOInstallation of a UNS-1A NMS.STC SH1856SOInstallation of a UNS-1/JR-FMS/NMS.STC SH1857SOInstallation of UNS-1/FMS.STC SH2086SOInstallation of the Bendix RDS-84 weather radar system.STC SH2055SOInstallation of Foxboro SC-14 fuel management system.STC SH5408SWInstallation of Loran-C Navigator Model 7000.STC SH2011SOInstallation of Bendix RDS-86 weather radar system.STC SH1678SOInstallation of Bendix electronic flight system(EFIS-10).STC SH1983SOInstallation of King KPI-552 PNI system.STC SH1984SOInstallation of King KPI-553A PNI system.STC SH1985SOInstallation of Sperry C-12 gyrosyn compass system.STC SA1950SOInstallation of Evergreen Systems International true airspeed data acquisition system Model 581.STC SH1945SOInstallation of tailcone standpipe.STC SH1946SOInstallation of a GNS-500A VLF/OMEGA navigation system.STC SH1947SOInstallation of a UNS-1-JR interfaced with ONI-7000 Loran C receiver.STC SH1555SOInstallation of the King Gold Crown III KTR 908 pilot's communication system.STC SH1556SOInstallation of the King Gold Crown III KTR 908 co-pilot's communication system.STC SH1560SOInstallation of the King Gold Crown III KDF 806 automatic direction finder(System #1).STC SH1561SOInstallation of the King Gold Crown III KDF 806 automatic direction finder (System #2).STC SH1866SOInstallation of King KNS-660 (pilots) flight management system.STC SH1867SOInstallation of King KNS-660 (copilots) flight management system.STC SH1872SOInstallation of King GC-361A radar graphic unit.STC SR01348NYInstallation of boarding steps IAW Key Tech Engineering Services Installation Drawing List IDL00203, Rev B, dated 1/16/01.
Back to Sikorsky S-76B