N997DL
STCs that may be installed · 265
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 = '3023688'
UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '52053')
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 = '3023688'
UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '52053')
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 JT8D series
STC SE00049AT-DInstallation of Intermediate Compressor Case (JT8D SERIES)STC SE00048AT-DModification of compressor intermediate case diaphragm to permit acceptable of a 7th stage airseal ring.STC SE2787CEInstallation of P/N T92871 first stage turbine vanes.STC SE1683GLInstallation of Rexnord O-Ring face seal P/N's 1-1337-701, 1-1633-701, 1-1738-701, and/or1-2233-701.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.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.STC SE557NEInstallation of oil tank shuttle valve.STC SE2666SOModification of the anti-ice mount bracket.STC SE593NEInstallation of a Select Controls Inc. Engine Oil Shuttle Valve, P/N 2057-1-001. (See Eligibility List)STC SE1930SOInstallation of power control shaft bushing.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.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.STC SE67WEInstallation of fuel control rod end bearings.STC SA2627WEInstallation of fuel control rod end bearings.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.