Skip to content

STCs that may be installed · 681

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

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 = '3980100' UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '54069') 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

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 = '3980100'
      UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '54069')
    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 = '3980100'
    UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '54069')
  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

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.

Airframe · Gulfstream Aerospace G-1159A

STC SA2181SOInstallation of a GNS-500A series 4 with NDB-2 and AFIS.Gulfstream Aerospace Corporation STC SA2182SOInstallation of modifications to the Dual DElco C-6 to Phase III software and -041 hardware changes.Gulfstream Aerospace Corporation STC SA3479NMInstallation of cabin observer seatGulfstream Aerospace Corporation STC SA3652NM-DInstallation of a Dual Universal UNS-1A and a Single Universal UNS-1jr Flight Management Systems.Gulfstream Aerospace Corporation STC SA2093SOInstallation of dual Sperry electronics flight instrument system EDZ-803 with multi function display.Gulfstream Aerospace Corporation STC SA2094SOInstallation of the triple Honeywell NAV. II Nav. Management System.Page AvJet Corp STC SA2092SOInstallation of a Collins VNI-80A vertical navigation indicator system.Gulfstream Aerospace Corporation STC SA1165GLInstallation of a Bendix EFS-10 electronic flight instrument system EFIS.Gulfstream Aerospace Corporation STC SA3650NM-DInstallation of a Dual Universal Navigation Corporation UNS-1 Integrated Flight Management System.Gulfstream Aerospace Corporation STC SA3651NM-DInstallation of a Dual Honeywell YG-1779B Laser Inertial Reference System.Gulfstream Aerospace Corporation STC SA2964NM-DInstallation of a Dual Universal Navigation Corporation UNS-1 Integrated Flight Management System.Gulfstream Aerospace Corporation STC SA3444NMInstallation of Sperry PRIMUS-90 Multi-Color Weather Radar SystemGulfstream Aerospace Corporation STC SA1999SOInstallation of Dual Bendix MLS-21, microwave landing system.Gulfstream Aerospace Corporation STC SA3118NMInstallation of Dual Sperry EDZ-801/-803 Electronic Flight Instrument System with Sperry Primus-800/MDZ-800 Multi-Function ColoradarGulfstream Aerospace Corporation STC SA3435NMInstallation of Cockpit JumpseatGulfstream Aerospace Corporation STC SA2024SOInstallation of Universal Navigation System. (UNS-1)Gulfstream Aerospace Corporation STC SA2025SOInstallation of Sperry electronic flight instrument system.Gulfstream Aerospace Corporation STC SA2000SOInstallation of Sperry EDZ-801 electronic flight instrument system.Gulfstream Aerospace Corporation STC SA1857NMInstallation of dual Sperry ADZ-800 digital air data computers and a Sperry VN-800 or VN-801 V-NAV system.Gulfstream Aerospace Corporation STC SA1863NMInstallation of dual Collins EFIS-85 electronic flight instrument systems.Gulfstream Aerospace Corporation STC SA1868NMInstallation of observer seat.Gulfstream Aerospace Corporation STC SA1873NMInstallation of oxygen system.Gulfstream Aerospace Corporation STC SA1959NMInstallation of crew and passenger diluter-demand oxygen system; MSN 366Gulfstream Aerospace Corporation STC SA2008NMInstallation of Class B Aft Baggage CompartmentGulfstream Aerospace Corporation STC SA2032NMInstallation of Triple Honeywell YG1779A Laser Inertial Reference SystemGulfstream Aerospace Corporation STC SA2037NMInstallation of Single Delco CIV-AX Inertial Navigation SystemGulfstream Aerospace Corporation STC SA2038NMInstallation of Single Tracor 7800 Omega/VLF Navigation SystemGulfstream Aerospace Corporation STC SA2039NMInstallation of a Single Garrett AirNav-400 wìth a Tracor 7800 Omega/VLF Sensor Integrated Flight Management/Navigation System (FMS)Gulfstream Aerospace Corporation STC SA2264NMInstallation of dual Collins EFIS-86 electronic flight instruments systems.Gulfstream Aerospace Corporation STC SA2266NMInstallation of dual Bendix EFS-10 electronic flight instruments systems.Gulfstream Aerospace Corporation STC SA2275WEInstallation of dual Honeywell Laseref Inertial Reference SystemsGulfstream Aerospace Corporation STC SA2276NMInstallation of dual Global GNS-1000 Flight Management Systems and one NDB-2 navigation data bank.Gulfstream Aerospace Corporation STC SA2423NMInstallation of Dual Universal Navigation Corporation UNS-1 Integrated Flight Management SystemGulfstream Aerospace Corporation STC SA2489NMInstallation of Triple Honeywell Lasernav II Navigation Management Systems with Global NBD-2 Navigation Data Bank InterfaceGulfstream Aerospace Corporation STC SA3409NMInstallation of Lavatory Smoke Detector and Fire ExtinguisherGulfstream Aerospace Corporation STC SA3403NMInstallation of Dual Bendix EFS-10 Electronic Flight Instrument System with Bendix RDS-86 Digital Color Weather Radar SystemGulfstream Aerospace Corporation STC SA3404NMInstallation of Triple Honeywell YG-1779B Laser Inertial Reference SystemGulfstream Aerospace Corporation STC SA3405NMInstallation of a Dual Universal UNS-1 and a Single Universal UNS-1jr Flight Management SystemGulfstream Aerospace Corporation STC SA4605SWInstallation of one or two jump seats.Tosington Enterprises STC SA1944SOInstallation of the Dual Sperry EDZ-803, electronic flight instrument system.Gulfstream Aerospace Corporation STC SA1940SOInstallation of the dual Sperry EDZ-803, electronic flight instrument system.Gulfstream Aerospace Corporation STC SA1904SOInstallation of cabin interior.Gulfstream Aerospace Corporation STC SA1907SOInstallation of Gulfstream Attitude and Heading Transfer System.Gulfstream Aerospace Corporation STC SA1908SOInstallation of Allied/Bendix EFS-10 electronic flight system with flight director.Gulfstream Aerospace Corporation STC SA1905SOInstallation of Dual Sperry EDZ-801, electronic flight instrument system.Gulfstream Aerospace Corporation STC SA1898SOInstallation of Dual Allied/Bendix EFS-10, electronic flight system.Gulfstream Aerospace Corporation STC SA1885SOInstallation of Sperry EDZ-803, electronic flight instrument system.Gulfstream Aerospace Corporation STC SA1878SOInstallation of a cabin interior.Gulfstream Aerospace Corporation STC SA1881SOInstallation of a cabin interior.Gulfstream Aerospace Corporation STC SA1873SOInstallation of the Sperry EDZ-801, Electronic Flight Instrument System.Gulfstream Aerospace Corporation