Skip to content

STCs that may be installed · 494

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 = '3022082' UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '52053') 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 = '3022082'
      UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '52053')
    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 = '3022082'
    UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '52053')
  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 · Mcdonnell Douglas DC-9-82(MD-82)

STC SA7827SWInstallation of provisions for traffic alert and collision avoidance system(TCAS).ACSS (Aviation Communication and Surveillance Syst STC SA7897SWInstallation of single Honeywell TCAS computer, dual VSI/TRA displays, and gables speaker assembly. STC SA7827SW and Dual Mode S transponders are required with this modification.ACSS (Aviation Communication and Surveillance Syst STC ST09974SCInstallation of radomeApplied Aerodynamics Inc.STC ST09270SCInstallation of Trimble TNL 2101 I/O Navigation System.FreeFlight Systems · Lists DC-9 Series STC ST00608ATInstallation of a Trimble TNL 2100T global positioning system.JanzAir Consulting Services STC ST01455ATInstallation of Advanced Aircraft Extinguishers (AAE's) smoke detection and fire suppression systems in lower cargo compartments.AAE, Ltd.STC ST01928T-DInstallation of Collins VHF-700 transceivers and CMU-900 ACARS. Approved AFM Supplement, AFM-01031 dtd 7/18/01 is a required part of this STC.TIMCO STC ST00974NYInstallation of Claircom Air Terminal systems.Claircom Communications Group LP STC ST02224ATManufacture of a Sterling Beverage System (SBS) portable beverage dispensing system, P/N 12-0001, in accordancd with SBS, Inc., Master Drawing List Report No. 20001, dtd 6/30/00, or later FAA approved revision. Aircraft installation in accordance with SBS Drawing No. 12012, "Galley Interface Criteria," dtd 11/14/00, or later FAA approved revision. Model applicability listed on AML No. ST02224AT is a required part of this STC.Sterling Beverage Systems, Inc STC SA6061NMInstallation of electrothermal upper wing anti-ice system.Honeywell International Inc.STC ST09850SCInstallation of left and right wing trailing edge interconnect wire harness system.Aviation Devices & Electronic Components LLC STC ST00757NYInstallation of a passenger cabin food service cart P/N E500161 or P/N E500161, Rev C.Driessen Aircraft Interior Systems USA, Inc STC ST02294ATReconfiguration of passenger seating arrangement to 8 FC/135 TC.Aero Design Services, Inc STC SA9030NM-DInstallation of Puritan Bennett Aero Systems -- ACCTV Landscape System.Thales Avionics In-Flight Systems, LLC STC ST09831SCInstallation of Wing Anti-Ice Thermostat/Anticipator.Honeywell International STC ST00093BOInstallation of a Simmonds Precision Fire Detection and Suppression System.Simmonds Precision Products Inc STC SA9008NM-DInstallation of In-Flight Phone Generation II passenger air-to ground telephone system.Santa Barbara Aerospace STC SA8024NMInstallation of replacement air cycle machine nozzle assembly.Repairtech Intl STC SA8025NMInstallation of replacement air cycle machine nozzle assembly.Repairtech Intl STC ST01901ATInstallation of a smoke detection and fire suppression system in the lower cargo compartments.Jetaire Aerospace & Technology Inc STC ST9436SC-DInstallation of Teledyne Aircraft Communications Addressing and Reporting System (ACARS).American Airlines Inc STC ST9437SC-DInstallation of interior modifications.American Airlines Inc STC SA2212WEInstallation of emblem lights mounted on trailing edge of wing tips.DeVore Aviation Corporation of America, a New Mexico Corporation STC ST01091NYInstallation of Duty Free Cart P/N MK511 or Video Cart P/N MK511-01.Iacobucci USA Inc STC ST9429SC-DModification of aircraft flight and service interphone system.American Airlines Inc STC SA9015NM-DInstallation of claircom Passenger phone system.AT&T Wireless Services STC SA2518SOInstallation of a forward and an aft coatroom.Pemco Aeroplex Inc · Lists DC-9 Series STC ST00282LA-DInstallation of Barry Controls Aerospace active tuned mass absorber system.Barry Controls STC SA1040NEInstallation of the Claircom air to ground telephone system.Claircom Communications Group L.P.STC SA2685CEInstall Collins TCAS II.Rockwell Collins Inc STC ST00880NYInstallation of a Digital Fuel Quantity Indicator System.Innovative Solutions & Support, Inc. · Lists DC-9 Series STC ST00997NYInstallation of 12 inch half size meal carts P/N MK208.Iacobucci USA Inc STC ST9426SC-DInstallation of a Thommen Revue 8-day mechanical wind up clock.American Airlines Inc STC ST00973NYInterior arrangement of passenger seating and emergency equipment.Claircom Communications Group L.P.STC ST0953SCInstallation of Digital Flight Data Recorder Expanded Parameter Upgrade for DFDR Systems.Aircraft Systems & Mfg STC ST09535SCInstallation of Digital Flight Data Recorder expanded parameter upgrade for ARINC 542A, ARINC 573, or ARINC 717 DFDR 18 sensor upgrade.Aircraft Systems & Mfg STC SA4265SWInstallation of Litton LTN-72RL INS/ANS navigation system.Gulfstream Aerospace Corporation STC ST9423SC-DInstall new passenger seats equipped with powerports and floor proximity emergency escape path lighting in a 14 First and 125 Coach class configuration.American Airlines Inc STC ST00920NYInstallation of equal aircraft formula, control number AE3000-A, dated 7/1/98.International Marketing, Inc STC ST9422SC-DInstall new Passenger seats equipped with powerports and floor proximity emergency escape path lighting in a 20 First and 113 Coach class configuration.American Airlines Inc STC ST00509LAInstallation of US Technical labatory fluid re-cycling system.Ice Management Systems, Inc STC ST01729ATInstall business class seats.Midwest Express Airlines STC ST9421SC-DInstallation of a Dexter Wilson New Generation Lighted Checklist, part number 028808-001 or 028808-002.American Airlines Inc STC ST00927CHInstallation of a Honeywell electronic flight instrument system, digital flight guidance computer, and central aural warning system.Midwest Express Airlines STC ST00295NYInstallation of Claircom air to ground telephone system.Claircom Communications Group L.P.STC ST01241ATInstallation of the Lord NXV active noise and vibration control system.Lord Corporation · Lists DC-9 Series STC SA3993SW-DInstall system in passenger cabin to provide electrical power at passenger seats.American Airlines Inc STC ST00828NYInstallation of Magee Plastics Company sidewall panels.Magee Plastics Company STC SA3999SW-DReconfigure the First Class cabin to 20 seats with new closet and AFT cart stowage unit and install electrical power to First Class passenger seats for the purpose of providing power for use of personal electronic devices.American Airlines Inc STC SA2684CEInstall dual Collins mode S transponders.Rockwell Collins Inc