N697BJ
STCs that may be installed · 354
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 = '302206C'
UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '52051')
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 = '302206C'
UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '52051')
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.
Airframe · Mcdonnell Douglas DC-9-32
STC SA2728WEIncorporation of Holcombe Industries HI-LITE SYSTEM P/N 50-1001 for emergency evacuation slide lighting. (707 AIRPLANES EQUIPPED WITH BOEING P/N 65-11685 AND 65-68862 FORWARD THRUST REVERSER DOORS)STC SA1380SOInstallation of interior sidewall panels and carpet panels.STC SA1545SOModify the wing fuel quantity system to install a new compensator and modify an existing probe.STC SA1258EAInstallation of Cosco model78-( ) child restraint system. (172M S/N 17263459 - 17267584)STC SA1691NMInstallation of a class dividerSTC SA4739SWInstallation of Dual Tracor 7800 Omega/VLF navigation system with dual B&D TAS computers.STC SA4616SWModify existing forward single flight attendant seat.STC SA4617SWModify existing aft double flight attendant seats on the pressure bulkhead (plug door)STC SA4565SWInstallation of sunvisor assembly windshield and inner pane accoustic cabin window.STC SA862EAAddition of airspeed select function to speed command/ autothrottle system.STC ST248GLInstallation of Collins Model FPC flight profile comparator, P/N622-2615-500, and Harowe barometric altitude rate computer, P/N 4030-03-1.STC SA3623WEInstallation of stretcher carrier P/N 2003.STC ST921SOFabrication and installation of baggage stowage rack, P/N 325100.STC ST856SOInstallation of Bendix ground proximity warning system.STC SA2106WEModification consists of interior arrangement, various passenger entertainment systems and avionics equipment.STC SA36NWInstallation of Sundstrand Ground Proximity Warning SystemSTC SA1003SWModification of 721B galley to 721B-1 galley and installation.STC SA10GLInstallation of Gayston Model 800LG and 800SG static dischargers on transport category airplanes.STC SA2541WEInstallation of tail cone slide cover.STC SA829CEInstall Butler National Corporation flight recorder/communications interface unit.STC SA2330WEInstallation of battery-powered emergency exit lighting in tail- cone.STC ST627SOInstallation of cargo accommodations.STC SA1784WEInstallation of underseat baggage restraint system.STC SA1797WEInstallation of underseat baggage restraint system.STC SA1895WEInstallation of a second observer seat in flight crew compartment.STC SA333SOBeverage bar.STC SA457CELockheed Aircraft service 109D flight recorder relocated.STC SA508CEInstallation of Safe Flight P/N 1300-33 SCAT computer in lieu of P/N 1300-32.STC SA520CEInstallation of airborne engine vibration monitoring system.STC SA580EAInstallation of Collins Radio CLC Type 560F-3 area navigation system.STC SA730CEInstall altitude alerting system.STC SA752CEInstall Bendix gyro horizon, P/N1978130-2, and Bendix inverter, P/N 1964771-2.STC ST399SOAddition of underseat luggage restraint.STC ST00050LA-DInstallation of Burns aerospace corp flight attendent seat.STC ST00389LA-DInstallation of first class seats with GTE Airfone handset.STC ST00434LA-DInstallation of a Hamilton Standard Digital cabin pressure control system.STC SA2542SOInstallation of Cargo Door
Engine · Pratt & Whitney JT8D-15
STC SE1622GLInstallation of Ametek 8TJ124GGR1 digital mass fuel flow transmitter.STC SE2930SOInstallation of an alternate gearbox cover seal utilizing an aluminum retainer .040-inch thick with a molded-in-place elastomeric seal contoured to fit the main housing/cover flange interface.STC SE497NEInstallation of oil tank filler neck check valve assembly.STC SE3916NMInstallation of CADC bleed valve supports brackets, P/N B10002 or RB10003, as a replacement part for P&W P/N 578273.STC SE79WEInstallation of CADC bleed valve support brackets, P/N B10001 or RB10006, as a replacement part for P&W P/N 493317 used on JT8D-1, -5, -7, -9, -9A, -15 and -17 engines.STC SE00049AT-DInstallation of Intermediate Compressor Case (JT8D SERIES)STC SE2787CEInstallation of P/N T92871 first stage turbine vanes.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.