Skip to content

STCs that may be installed · 46

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

STC ST00555ATInstallation of Airshow 210 system.AIRCRAFT RECONFIG TECHNOLOGIES, LLC · Lists 737 Series STC SA4842SWModification of air to air heat exchanger (P/N 182820-2 Series 2).Honeywell International Inc. · Lists 737 Series STC SA270NWInstallation of modified seat.Aviation Technical Services · Lists 737 Series STC ST01162NYInstallation of Literature Pockets.Magee Plastics Company · Lists 737 Series STC SA2607SOInstallation of coffee maker P/N 416-1001-29.B/E Aerospace Inc. · Lists 737 Series STC SA2608SOInstallation of rail assembly, P/N 416-0201-15.B/E Aerospace Inc. · Lists 737 Series STC SA3058SOInstallation of coffee maker 416-0001-23 and rail assembly 416-0201-5B/E Aerospace Inc. · Lists 737 Series STC ST01476ATInstallation of coffee maker.B/E Aerospace Inc. · Lists 737 Series STC ST01778ATInstallation of espresso maker p/n 3510-0066-01.B/E Aerospace Inc. · Lists 737 Series STC SA629GLInstallation of Grimes galley, Model 1545LW unit 2 and unit 4.B/E Aerospace · Lists 737 Series STC ST01332ATInstallation of Galley Service Carts.Champ International, Inc. · Lists 737 Series STC ST09870SCInstallation of Mechanical Window Shades.Lou Martin & Associates · Lists 737 Series STC ST00033ATInstallation of a single Mode S system and provisions for a TCAS II system.General Aerospace, Inc · Lists 737 Series STC SA4532NMInstallation of Coltech, CTD-80 ATSCALL, enabling company calling of selected aircraft via company selected radio.Avtech Corporation · Lists 737 Series STC ST4532NMInstallation of Coltech CTD-80 ATSCALL, enabling company calling of selected aircraft via company selected radio.Avtech Corporation · Lists 737 Series STC ST00774NYInstallation of a passenger cabin Liquor/beverage service cart P/N E500170. (757-222) (767-222) (727-222) (737 SERIES 222, 291, 322, 522) (747-100 SERIES 238B)Driessen Aircraft Interior Systems USA, Inc · Lists 737 Series STC ST02052ATInstallation of a single Collins GNLU910A flight management system, along with global navigation satellite system sensor.General Aerospace, Inc · Lists 737 Series STC SA02034ATManufacture of tray carrier, P/N 2282-506.BFE Services · Lists 737 Series STC ST01968ATManufacture of inserts for galley stowageJK Aerospace, Inc. · Lists 737 Series STC SA01916ATManufacture of Tray Carrier P/N 1839-501.BFE Services · Lists 737 Series STC SA2534SOInstallation of window shades, acoustic panes and reveals.Magee Plastics Company · Lists 737 Series STC ST179CHInstallation of cargo container curtain.Plastic Composites Corp · Lists 737 Series STC SA00056LAInstallation of Weber Coffeemaker, P/N 870130-415.Monogram Systems · Lists 737 Series STC SA6090NMInstallation of emergency vision assurance system (EVAS).VisionSafe Corporation · Lists 737 Series STC SA370NWRemoval of passenger interior, installation of cargo compartment liners and cargo tie down equipment.Western Metal Products · Lists 737 Series STC SA2589CEInstall Bennetts Seat Converter Stowage Compartment on passenger seat(s).John's Aircraft and Upholstery · Lists 737 Series STC SA1029NWInstallation of a cargo system.Western Metal Products · Lists 737 Series STC SA1258EAInstallation of Cosco model78-( ) child restraint system. (172M S/N 17263459 - 17267584)Miller Stuart R · Lists 737 Series STC SA1052SOInstallation of GE battery P/N43B022RB36 in place of Marathon P/N CA-727-7, CA-727-20, or CA-27-20 batteries or SAFT P/N23180 batteries; or installation of GE battery P/N 43B020RB10 replacing Marathon P/N CA-727-7, CA-727-20 or CA-27-20 or SAFT P/N 23186 or 23180 batteries.General Electric Company · Lists 737 Series STC SA1082NWInstallation of auxiliary fuel tanks in the aft cargo compartment. (737 series -2K9A)Rogerson ATS · Lists 737 Series

Engine · Pratt & Whitney JT8D-17

STC SE2930SOInstallation of an alternate gearbox cover seal utilizing an aluminum retainer .040-inch thick with a molded-in-place elastomeric seal contoured to fit the main housing/cover flange interface.Parker O-Seal Division · Lists JT8D Series STC SE497NEInstallation of oil tank filler neck check valve assembly.Aviation Components Support STC SE3916NMInstallation of CADC bleed valve supports brackets, P/N B10002 or RB10003, as a replacement part for P&W P/N 578273.Aeroparts Mfg & Repair · Lists JT8D Series STC SE79WEInstallation of CADC bleed valve support brackets, P/N B10001 or RB10006, as a replacement part for P&W P/N 493317 used on JT8D-1, -5, -7, -9, -9A, -15 and -17 engines.Aeroparts Mfg & Repair · Lists JT8D Series STC SE00049AT-DInstallation of Intermediate Compressor Case (JT8D SERIES)Aero Component Technologies · Lists JT8D Series STC SE59GLInstallation of O-ring face seal P/N-s 1-1337-700, -701, 1-1633-700, -701, 1-1738-700, -701; and/or 1-2233-700, 701.Rexnord, Inc STC SE86WEReplace the airoils on P&WA P/Ns 495051, 478351, 583751, 653851, 653951, 572451, 583351, 653751, 653151, 676951, 728951, 709951, 710751, 627751, 737271, 578551, 738271, 747171, 792871, 786471, 583751, 777971, 780591, 782571, 793181, 799771, 794481, 794491 , 798781, and 799191.Chromizing Company STC SE557NEInstallation of oil tank shuttle valve.Stockbridge William D STC SE2666SOModification of the anti-ice mount bracket.Cook Airtomic STC SE593NEInstallation of a Select Controls Inc. Engine Oil Shuttle Valve, P/N 2057-1-001. (See Eligibility List)Basken Valve Corporation · Lists JT8D Series STC SE1930SOInstallation of power control shaft bushing.Cook Airtomic Division · Lists JT8D Series STC SE83WEInstallation of heat shield assembly P/N 408-007 as a replacement part for P&W P/N499941 or 749609 used on JT8D-1, -5, -7, -9, -9A, -15 and -17 engines.Hughes Helicopter · Lists JT8D Series STC SE84WEInstallation of heat shield assembly 408-008 as a replacement part for P&W No. 586918 used on JT8D-1, -5, -7, -9, -9A, -15 and -17 engines.Hughes Helicopter · Lists JT8D Series STC SE67WEInstallation of fuel control rod end bearings.Triumph Corporation · Lists JT8D Series STC SA2627WEInstallation of fuel control rod end bearings.Triumph Corporation · Lists JT8D Series STC SE5058NMIncorporation of feather seals into platforms of the first stage nozzle guide vanes, P&W P/N 653751, 737271, 738271, 747171, 792871, 786471, and 798771.Chromizing Company