OpenAirDocs.org
N707TG

STCs that may be installed · 68

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

Airframe · Embraer EMB-120ER

STC ST411CHInstall forward lavatory panels, Models 1145, 1146, 1147.Midwest Aircraft ProductsSTC ST09243ACInstallation of provisions for a New Systems P/N NS 20004-1 Air Call system.New SystemsSTC ST09318SCNew Systems P/N NS20004-1 Air Call (SELCAL) unit.New SystemsSTC ST105CHInstallation of a Sundstrand Mark VI ground proximity warning system (GPWS) Mark VI.BF Goodrich AerospaceSTC ST57CHInstallation of Sundstrand Mark VI, Ground Proximity Warning System.BF Goodrich AerospaceSTC ST412CHInstallation of MAPCO Model 1144.Midwest Aircraft ProductsSTC ST320CHInstallation of landing gear harnesses and proximity switch.Aviation Technologies GroupSTC ST235CHInstallation of MAPCO Model 1140 galley.Midwest Aircraft ProductsSTC ST169CHInstallation of trim proximity sensor.Aviation Technologies Group

Engine · Pratt & Whitney Canada PW119B

STC SE2805SOInstallation of an oil tank safety cap adapter which is intended to prevent loss of oil in the event of loss or damage to the oil filler cap.Jet Avion CorporationSTC SE00344LAInstallation of Western Filter Corp. oil filter element, P/N WF334638, as a replacement for the P&W Canada filter element, P/N 3112895-01, in the lubrication system.Western Filter CorporationSTC SE00097LAInstallation of strainer element, P/N 90220, as a replacement for strainer element, P/N 3106403-01, in the oil pressure transfer tube assembly.Ejay Filtration, IncSTC SE00074LAInstallation of Puroflow filter element, P/N 11-11064, as a replacement for P&W Canada filter element, P/N3029315 (and optional numbers) in the reduction gearbox scavenge oil filtering system.Puroflow CorporationSTC SE00075LAInstallation of Puroflow filter element, P/N 11-11065, as a replacement for P&W Canada filter element, P/N3112895-01, in the reduction gearbox scavenge oil filtering system.Puroflow CorporationSTC SE00076LAInstallation of Puroflow filter element, P/N 11-11084, as a replacement for P&W Canada filter element, P/N3035681 (and optional part numbers) in the engine fuel filtering system.Puroflow CorporationSTC SE00079LAInstallation of Puroflow filter element, P/N 11-11085, as a replacement for P&W Canada filter element, P/N3035728 (and optional part numbers) in the engine fuel filtering system.Puroflow CorporationSTC SE00082LAInstallation of Puroflow filter element, P/N 11-11102, as a replacement for P&W Canada filter element, P/N3038454, in the engine fuel filtering system.Puroflow CorporationSTC SE00083LAInstallation of Puroflow filter element, P/N 70-106, as a replacement for P&W Canada filter element, P/N3034190, in the reduction gearbox scavenge oil filtering system.Puroflow Corporation
Back to N707TG