N987AK
STCs that may be installed · 328
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 = '3022087')
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 = '3022087') 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 · Mcdonnell Douglas DC-9-87
STC SA3698SWInstallation of Plumly airborne floor proximity lighting system.STC SA3921SW-DInstallation of modified galley units.STC SA2172CEInstallation of Luminescent Systems floor proximity emergency escape path marking system.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 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 SA4565SWInstallation of sunvisor assembly windshield and inner pane accoustic cabin window.STC SA3623WEInstallation of stretcher carrier P/N 2003.STC SA36NWInstallation of Sundstrand Ground Proximity Warning SystemSTC SA1003SWModification of 721B galley to 721B-1 galley and installation.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 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 SA7053NMInstallation of lavatory smoke detection system.STC ST01685LAInstallation of Collins Communications Management Unit and VHF Data Radio Transceiver (ACARS/VDR)STC SA3317NMInstallation of management control unit.