Supplemental type certificates
49,113 STCs, most recently changed first. Search by what an STC changes, its holder or a model.
Query with SQL
duckdb -csv -c "SELECT stc_number, description, holder, status, status_date FROM 'https://openairdocs.org/data/latest/faa_stc.parquet' ORDER BY status_date DESC NULLS LAST, 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 stc_number, description, holder, status, status_date FROM 'https://openairdocs.org/data/latest/faa_stc.parquet' ORDER BY status_date DESC NULLS LAST, stc_number
Run 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 SA1614SWInstallation of IDC 570-24929-002 encoding altimeter or Smith's WL-1350 AM/MS-1(-2) encoding altimeter.STC SA1615SWInstallation of encoding altimeter/alerting system.STC SA1616SWInstallation of Sperry AA-210 radar altimeter system.STC SA1628SWInstallation of RCA AVQ-21 weather radarSTC SA1641SWInstallation of Sperry SPZ-200 autopilot and Stars IVC flight director systemSTC SA1646SWInstallation of Sunair ASB-100 HF system.STC SA1647SWInstallation of Sperry stars IVB flight director.STC SA1674SWInstallation of Smith's encoding altimeter and alerting system.STC SA1693SWInstallation of Bendix M-4D autopilot system.STC SA1703SWInstallation of 5V light source.STC SA1708SWInstallation of ASB 125P/SAC-69 HF Comm.STC SA1710SWInstallation of Bendix RDR-1200 weathervision system.STC SA1711SWInstallation of RCA AVQ-47 weather radar.STC SA1762SWInstallation of a single PC-17 inverter.STC SA1804SWInstallation of 110 V outlet and wiring.STC SA1805SWInstallation of Foxboro fuel flow signal conditioning unit PC-260.STC SA1814SWInstallation of a dual baro scale altimeter.STC SA1816SWInstallation of King flight phone.STC SA1817SWInstallation of Collins ALT-50 radar altimeterSTC SA1818SWInstallation of Aerosonics encoding altimeter and alerter.STC SA1849SWInstallation of dual ASB 100A high frequency radios.STC SA1851SWInstallation of -501 single encoding altimeter and alerter system.STC SA1857SWInstallation of B.F. Goodrich type 25S de-ice boot.STC SA1859SWInstallation of RDR-100 weather radarSTC SA1872SWModification of Hamilton Standard temperature control system.STC SA1941SWModification of the basic King Gold Crown avionics.STC SA2247SWInstallation of oxygen cylinder, P/N 6350 A20 00B.STC SA2263SWModification of ECS mixing chamber.STC SA2266SWFabrication and installation of wing panel flap actuator access.STC SA2268SWInstallation of #2 VHF comm antenna.STC SA2269SWInstallation of King KRA 405 radar altimeter.STC SA2274SWInstallation of heated windshield.STC SA2295SWInstallation of alternate interstage turbine temperature indicator. P/N 935A-6012.STC SA2309SWInstallation of Sperry TP114B transponder.STC SA2315SWInstallation of dual FDS-112B flight director system.STC SA2317SWInstallation of IDC RAD/BAR encoding altimeter with altitude alerting.STC SA2565SOInstallation of Dual S TRA-67 Mode Transponders system.STC SA2697CEInstallation of MK V ground proximity warning system.STC SA2698SOInstallation of provisions for a CAS-81 TCASSTC SA2721SOInstallation of a dual TRA-67 Mode S Transponder system.STC SA2725SOInstallation of CAS-81 TCAS II system.STC SA2726SOInstallation of CAS-81 TCAS II system.STC SA2727SOInstallation of Dual TRA-67 Model S Transponder system.STC SA2733SOInstallation of CAS-81TCAS II system.STC SA2734SOInstallation of a CAS-81 TCAS IISTC SA2741SOInstallation of CAS-81 TCAS II system and compatible Mode S transponders.STC SA2797SOInstallation of the Bendix/King CAS-81 TCAS II system and dual Bendix/King TRA-67 Mode S transponders.STC SA2802SOInstallation of a CAS-81 TCAS II system and dual Bendix/King TRA-67 Mode S transponders.STC SA2860SOInstallation of a CAS-81 TCAS II system and dual Bendix/King TRA-67 Mode S transponders.STC SA2916SOInstallation of dual TRA-67 Mode S transponder system.