Skip to content

STCs that may be installed · 126

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 = '5265015' UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '54591') 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 = '5265015'
      UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '54591')
    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 = '5265015'
    UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '54591')
  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 · Lockheed L-1011-385-1-15

STC SA358NEInstallation of PTC Aerospace No. 88801-1 Singl-Serv food carts.B/E Aerospace STC ST01004NYInstallation of cargo restraint straps.Airline Container Manufacturing Co Inc · Lists L-1011 Series STC SA2693SOInstallation of mid-cabin galley P/N 331100-1/-2, or P/N 331100-101/-102.B/E Aerospace STC ST00506ATInstallation of L.H. lower deck galley and aft service center galleys.B/E Aerospace STC ST02258ATInstallation of a smoke detection and fire suppression system in lower cargo compartments.Jetaire Aerospace & Technology Inc STC ST02220ATManufacture of merchandise sales cart, P/N CNF023-101-( ) for galley stowage.JK Aerospace, Inc.STC ST02093ATInstallation of a smoke detection and fire suppression system in the lower cargo compartments.AAE, Ltd.STC SA9049NM-DInstallation of PTC model 950 business class seats and Weber model 4001 tourist class seats.Airbase Service, Inc STC ST01092NYInstallation of two (2) Hi-8VTRs.Vid-Air Services Inc · Lists L-1011 Series STC ST01093NYInstallation of One (1) 21-inch Plasma Display Monitor.Vid-Air Services Inc · Lists L-1011 Series STC ST01803ATInstallation of RTD-44D 8.33 kHz VHF AlliedSignal Quantum Line communication system.Newport Aeronautical Development STC SA08011NMModification to inlcude both provisions only, or for carriage and launch.Orbital Sciences Corporation STC ST00866NYInstallation of a Vickers P/N A49 magnetic chip detector in Pratt & Whitney ST6L-73 APU.Vickers Inc · Lists L-1011 Series STC ST01283ATInstallation of Ametek Aerospace Products fuel flow transmitter P/N 8TJ124GGN3 and Ametek Aerospace Products fuel used indicator P/N 10620N()F().AMETEK Aerospace · Lists L-1011 Series STC ST00695CHInstall 354 maximum passenger arrangement. (L-1011-385-1-15 193N-1205 ONLY)American Intl Airways, Inc STC SA3870SWRemanufacture of Hamilton Standard air conditioning heat exchanger P/N 733949 by replacing core assyemblyLimco-Airepair, Inc STC SA7884SWRecore of Englehard P/N D-19751-1 ozone converters.Limco-Airepair, Inc · Lists L-1011 Series STC SA3987NMInstallation of Piston-shoe assembly, p/n 700003.California Precision Hydraulics, Inc STC ST625CHInstallation of replacement coffee maker over-temperature switch.Aircraft Food Service Equipment Repair STC ST01103ATIncrease in Maximum Design Landing Weight from 368,000 lbs. to 380,000 lbs.Newport Aeronautical Dvlpmt STC ST00977ATInstallation of global positioning system monitoring unit.ARINC Inc · Lists L-1011 Series STC ST00847ATInstallation of main deck cargo door, main deck floor modification/ cargo handling and restraint system, 9g cargo bulkhead, Class E cargo compartment and courier seating(with lavatory/galley storage and crew bunks).Newport Aeronautical Dvlpmt STC SA3313SOInstallation of a 302 passenger seating configuration.Delta Airlines Inc · Lists L-1011 Series STC ST00099ATInstallation of a data link system.Delta Airlines Inc · Lists L-1011 Series STC ST00046BOInstallation of BFGoodrich 50209- series fuel quantity indicating system in-tank wiring harness.Simmonds Precision Products Inc STC ST00427ATInstallation of an airshow cabin video information system.Delta Airlines Inc · Lists L-1011 Series STC ST00767ATReconfiguration of a 295-passenger configuration to an interior arrangement for 260 passengers.Delta Airlines Inc · Lists L-1011 Series STC ST00668ATInstallation of a Trimble Model TNL-8100 GPS navigation system.Rich Intl Airways STC ST00097ATInstallation of a data link printer.Delta Airlines Inc · Lists L-1011 Series STC ST208CHInstallation of a Rosemount model0861CAG angle of attack sensor.Rosemount Aerospace Inc STC ST00056ATInstallation of a 295-passenger seating configuration. (L-1011 Series 250, 500)Delta Airlines Inc · Lists L-1011 Series STC ST00224NYInstallation of GC200 beverage maker. (757-27B) (737-317) (DHC-8 SERIES ALL SERIES)Godfrey Aerospace Inc STC ST00546ATInstallation of 3-tier folding cart.BFE Services · Lists L-1011 Series STC SA3165SOInstallation of a Garrett GAR101L1011 dual heat exchanger.AlliedSignal Airline Service · Lists L-1011 Series STC ST00249ATInstallation of two drawer tray carrier P/N 2397-502, and three drawer tray carrier, P/N 2396-502.BFE Services · Lists L-1011 Series STC ST00233ATInstallation of tray carriers.BFE Services · Lists L-1011 Series STC SA2198CEInstallation of lavatory smoke detection and fire extinguishing systems.AAE, Ltd.STC SA5671NMInstallation of a wheelchair stowage unit.Steel Products Inc STC ST00031ATInstallation of a 225-passenger seating configuration. (L-1011 SERIES 500)Delta Airlines Inc · Lists L-1011 Series STC ST00030ATInstallation of a 295-passenger seating configuration.Delta Airlines Inc · Lists L-1011 Series STC SA3266SOInstallation of a passenger entertainment video system.Rich Intl Airways · Lists L-1011 Series STC SA3207SOInstallation of a 217 passenger seating configuration.Delta Airlines Inc · Lists L-1011 Series STC SA7596SWInstallation of electrically controlled passenger seatsWeber Aircraft · Lists L-1011 Series STC SA5476NMInstallation of floor proximity emergency escape path markings system.Intl Valve Co · Lists L-1011 Series STC SA2827SOInstallation of a second Litton LTN-211 VLF/Omega system.Avitas Engineering · Lists L-1011 Series STC SA2826SOInstallation of dual Bendix TRA-67 mode S transponders.Delta Airlines Inc · Lists L-1011 Series STC SA2771SOInstallation of utility cart P/N 2398-501.BFE Services STC SA2238SORemoval and replacement of the floor assembly in Air Cruisers' slide/rafts.Eastern Airlines, Inc · Lists L-1011 Series STC SA2096SOInstallation of a low-pass filter, P/N 24-FI-0198, between the No. 2 VHF communications transceiver and the antenna.Eastern Airlines, Inc · Lists L-1011 Series STC SA3700SWInstallation of Plumly airborne floor proximity lighting system.Intl Aircraft Certification Service