STCs that may be installed · 721

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

STC ST00518SEModification and installation of a Hughes Avicom Video Entertainment System.America West Airlines STC ST01577ATInstallation of a Seat Mounted Emergency Escape Path Lighting System.Delta Airlines Inc STC ST00492SEInstallation of the Zonal Drying SystemCTT Systems AB STC ST00689NYInstallation of Magee Plastics ceiling panels.Magee Plastics Company STC SA8426SWRecore of Airesearch P/N 160176 APU oil coolerLimco-Airepair, Inc STC SA8933SWRecore of Airesearch P/N 194274 heat exchanger used on Boeing 757 air conditioning system.Limco-Airepair, Inc STC ST01405ATInstallation of an Allied Signal/ Bendix Weather Radar System.Delta Airlines Inc STC ST01406ATInstallation of a Center VHF System.Delta Airlines Inc STC ST00833ATInstallation of a 183-passenger seating configuration.Delta Airlines Inc STC ST01347ATInstallation of a 219-Passenger Seat Interior.MAEAAS, Inc STC ST00333LAInstallation of windscreen.Monogram Systems STC ST01331ATInstallation of the AlliedSignal Enhanced Ground Proximity Warning System. (757-200 S/N 22918, 22919, 25013, 25035)Delta Airlines Inc STC ST625CHInstallation of replacement coffee maker over-temperature switch.Aircraft Food Service Equipment Repair STC ST00027LBInstallation of piston and shoe assembly, P/N 700017.California Precision Hydraulics, Inc STC ST01187ATInstallation of Global Positioning System Monitoring Unit.ARINC Inc STC ST492CHInstallation of replacement coffee maker gaskets.Aircraft Food Service Equipment Repair STC ST00254SEInstallation of a Soft Class Divider(Curtain)Flight Structures Inc STC ST402CHInstallation of a 199 passenger capacity coach seating military configuration.American Trans Air STC ST00764ATInstallation of smoke detectors, Model No. 473108, in a B757 lower deck cargo compartment.Walter Kidde Aerospace STC SA00095LAInstallation of Weber galleys G2C(P/N 871455-405), G2D (P/N831333-408 and G4B (P/N 831334-407).Monogram Systems STC SA7016NM-DModification of an existing approved interior configuration, installation of electrically operated seats and installa- tion of individual in-seat video system.Tramco Inc STC ST09050SCModification of Boeing p/n 3145-2 oxygen tank support assembly and replacement of hardware associated with the operation of Boeing P/N 20054-350 T-bolt.Southern Aeroparts, Inc STC ST338CHInstallation of replacement lavatory cartridge heater.Aircraft Food Service Equipment Repair STC ST339CHInstallation of replacement immersion heater.Aircraft Food Service Equipment Repair STC SA1665GLInstallation of Norton Radome P/N 4910.Norton Company STC ST311CHInstallation of a Rosemount model 0851HH pitot probe.Rosemount Aerospace Inc STC ST00138ATInstallation of a Collins TCAS II system.Collins Aviation Service STC ST00037LBInstallation of In-Flight Phone Corp. Passenger Air-to-Ground Communication System.In-Flight Phone Corporation STC SA3979SW-DInstall an Interstate 9001 Global Positioning System (GPS) Navigation and Landing System (GNLS).American Airlines Inc STC SA1702GLInstallation of Bendix/King TCAS II(Model CAS-81).American Trans Air STC ST00451ATInstallation of Folding Cart Assembly, P/N 2498-502.BFE Services STC ST00405ATDesign, fabricate, and install a composite fuselage interior liner with subcomponent composite circumferential supports.Advanced Technology & Research, Inc STC SA8725SWInstallation of executive interiorAssociated Air Center STC SA1727GLInstallation of air-to-ground communication systems.In-Flight Phone Corporation STC ST00346ATInstallation of a 180/182 passenger seating configuration.Delta Airlines Inc STC ST00271ATModification of interior to O First Class, 216 tourist class seating configuration.Aero Design Services, Inc STC ST00241ATInstallation of a 180-passenger seating configuration.Delta Airlines Inc STC SA3974SW-DInstall new passenger seats at the Type III overwing emergency exits, for increased accessAmerican Airlines Inc STC ST54CHInstallation of antennas for air-to- ground communication systems.In-Flight Phone Corporation STC ST00156ATInstallation of interior configuration.Aero Design Services, Inc STC SA4780NMInstallation of Matsushita Avionics Systems Inc Video Entertainment SystemFlight Structures Inc.STC SA5671NMInstallation of a wheelchair stowage unit.Steel Products Inc STC SA3307SOModification of interior configuration to 0 first class, 205 tourist class.Aero Design Services, Inc STC SA3309SOInstallation of an extended time standby power system.Challenge Air Cargo, Inc STC SA3972SW-DModify the passenger cabin interior configuration from 12 first class and182 coach class to 22 first class and166 coach class seats, and install new galley closet and flight attendant seatsAmerican Airlines Inc STC SA5750NMInstallation of a windscreen and a triple seat.Flight Structures Inc STC SA5751NMInstallation of closet provisions.Flight Structures Inc.STC SA5754NMInstallation of three galleys.Flight Structures Inc.STC SA5731NMInstallation of a windscreen which includes a flight attendant seat.Flight Structures Inc STC SA5543NMInstallation of Teledyne Controls digital flight data acquisition unit.Teledyne Controls

Back to N780FD