Supplemental type certificates
49,114 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 SR02104NY-DInstallation of a Universal Cockpit Display (UCD) SystemSTC SR02105NY-DInstallation of Gooseneck Lighting System.STC SR02106NY-DInstallation of a Heads-Up Technologies CMS-400A checklist management system.STC SR02107NY-DInstallation of a Honeywell JetMap II System.STC SR02108NY-DInstallation of an executive VIP interiorSTC SR02110NY-DInstallation of a Honeywell Chadwick Model 15175 VXP system.STC SR02112NY-DInstallation of a Main Gear Box Oil Drip Pan modificationSTC SR02113NY-DInstallation of Cockpit Provisional Storage ContainersSTC SR02115NY-DInstallation of External Camera SystemSTC SR02117NY-DInstallation of a Honeywell Primus 660 Weather RadarSTC SR02118NY-DInstallation of a Replacement Retractable Boarding StepSTC SR02119NY-DInstallation of an Utility LavatorySTC SR02121NY-DInstallation of a shelves (Station 643 and/or Station 520)STC SR02122NY-DInstallation of High Intensity Strobe Lights.STC SR02123NY-DInstallation of provisions for a Euroavionics Euronav IV systemSTC SR02124NY-DInstallation of Jettisonable windows (Cabin &/or Emergency Exit)STC SR02125NY-DInstallation of Cockpit Pressure Refueling Control SystemSTC SR02126NY-DInstallation of a SkyTrac Systems ISAT-100 system.STC SR02127NY-DInstallation of a HF-9000 High Frequency Communications SystemSTC SR02128NY-DInstallation of FLIR Systems, Inc. Star Safire III FLIRSTC SR02129NY-DInstallation of Keystone Helicopter Corp. Silencer Wall Panel SystemSTC SR02130NY-DInstallation of Garmin GMX 200 Multi-Function DisplaySTC SR02131NY-DInstallation of Keystone Helicoper Corp. Deluxe VIP Interior.STC SR02132NY-DInstallation of Ramp Gap BridgeSTC SR02133NY-DInstallation of Side Facing Utility SeatSTC SR02208NY-DInstallation of a LavatorySTC SR02400NY-DInstallation of Helicopter Emergency Egress Lighting System (HEELS).STC SR02401NY-DInstallation of SAR Operator s SeatSTC SR02402NY-DInstallation of Alternate Utility Interior.STC SR02403NY-DInstallation of Chelton TETRA TransceiverSTC SR02404NY-DInstallation of Scene Lights.STC SR02405NY-DInstallation of Logo LightsSTC SR02406NY-DInstallation of a Honeywell Primus 701A Weather RadarSTC SR02407NY-DInstallation of an Auxiliary DC Power System.STC SR02408NY-DInstallation of a Spectrolab Nightsun II XP SearchlightSTC SR02409NY-DInstallation of a Polycon Wireless Intercom SystemSTC SR02410NY-DInstallation of a Mission Audio SystemSTC SR02411NY-DInstallation of a Wescam MX-15iSTC SR02412NY-DInstallation of a Saab Airborne Transponder SystemSTC SR02413NY-DInstallation of the Wulfsberg Flexcomm II Communication SystemSTC SR02414NY-DInstallation of a GKN Sliding Cabin Entry DoorSTC SR02415NY-DInstallation of a Chelton 935-2 V/UHF Direction FinderSTC SR02416NY-DInstallation of Honeywell KHF 1050 HF Communication SystemSTC SR02417NY-DInstallation of Honeywell KHF 1050 HF Communication SystemSTC SR02418NY-DInstallation of a Universal Cockpit Display (UCD) SystemSTC SR02419NY-DInstallation of Corporate Interior.STC SR02420NY-DInstallation of an AvVisor Plus Cabin Information Display SystemSTC SR02421NY-DInstallation of Center Console Four Inch ExtensionSTC SR02422NY-DInstallation of Aft RackSTC SR02423NY-DInstallation of Dimmer/Balance Box Modification.