N910FX
STCs that may be installed · 109
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 = '8680920'
UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '52114')
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 = '8680920'
UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '52114')
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_numberRun 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.
Engine · Pratt & Whitney Canada PW120
STC SE792NEInstallation of oil tank filler neck check valve P/N TSA-100 SA.STC SE00097LAInstallation of strainer element, P/N 90220, as a replacement for strainer element, P/N 3106403-01, in the oil pressure transfer tube assembly.STC SE01045ATInstallation of engine ignition leadSTC 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.STC 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.STC 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.STC 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.STC 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.STC 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.