N87KB
STCs that may be installed · 641
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 = '2730173'
UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '33902')
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 = '2730173'
UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '33902')
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 · Dassault MYSTERE-FALCON 50
STC SA4305SWInstallation of rear radio rack.STC SA4479SWInstallation of dual global VLF/Omega systems, GNS-500A-III.STC SA4480SWInstallation of Collins H.F. Communications Systems, Model 718U-5M.STC SA4481SWInstallation of 2-inch standby altimeter and 2-inch standby mach airspeed indicatorSTC SA4482SWInstallation of Baker passenger address system and autoflite passenger briefing system.STC SA4483SWInstallation of Dual H.T. Instruments Electric Clock.STC SA4484SWInstallation of Motorola Selcal System, Model NA-135.STC SA4485SWInstallation of J.E.T. PS-835 emergency power system.STC SA4486SWInstallation of Sundstrand cockpit voice recorder, Model AV-557-C.STC SA4489SWInstallation of Dual Collins radio altimeters, ALT-55.STC SA4490SWInstallation of RCA weather radar, Primus 400 and Data NAV III.STC SA4491SWInstallation of Delco Carousel IV-AX inertial navigation system.STC SA4492SWInstallation of Dual Collins transponders, TDR-90.STC SA4493SWInstallation of Dual Collins DME transceivers, DME-40.STC SA4494SWInstallation of Wulfsburg Flitefone IIIC, Airborne telephone system.STC SA4495SWInstallation of Dual Baker electronics audio systems, Model M1035-CEKR.STC SA4496SWInstallation of Collins flight profile advisory FPA-80.STC SA4497SWInstallation of J.E.T. emergency horizon and power supply.STC SA4498SWInstallation of three (3) Collins VHF communications transceivers Model VHF-20BSTC SA4499SWInstallation of Dual Collins ADF-60 systems.STC SA4500SWInstallation of three (3) Collins VHF Navigation receivers, Model VIR-30STC SA4501SWInstallation of Navigation switching system.STC SA4502SWInstallation of directional gyro switching.STC SA4503SWInstallation of vertical gyro switching.STC SA4507SWInstallation of oxygen systemSTC SA4510SWInstallation of Endevco engine vibration system.STC ST00259NY-DUpdate dual global Wulfsberg systems GNS-X navigation management systems to Program 23.STC ST00307NY-DInstallationo f an AlliedSignal CAS-67A TCAS II system.STC ST00491NY-DInstallation of Dual Universal Avionics UNS-1D Flight Management Systems.STC ST00495NY-DInstallation of AlliedSignal Dual GNS-Xis Flight Management Systems.STC ST00496NY-DUpdate of Collins Radio Dual EFIS-86C (4/14) Electronic Flight Instrument Systems.STC ST00706NY-DInstallation of Universal Avionics Systems Corporation Dual UNS-1D Flight Management Systems.STC ST00713NY-DCabin Seating and Seating Placarding.STC SA8312SW-DInstallation of the Automatic Cabin Electrical Load Shed SystemSTC ST09304SC-DInstallation of the Inertial Reference System Modifications.STC ST00797WIInstallation of dual Universal Avionics Systems Corp. UNS-1D Flight Management Systems.STC ST01048CH-DInstallation of an AlliedSignal Avionics MK-VII Enhanced Ground Proximity Warning System.STC SA7051SW-DInstallation of control wheel modification.STC ST01042CHInstallation of dual Universal UNS-1K Flight Management Systems.STC ST00942NYInstallation of a placard to reduce maximum seating capacity from 10 passengers to 9 passengers.STC SA8261SW-DInstallation of the GNS-XES Flight Management System.STC ST00747WIInstallation of a Dual Universal UNS-1K Flight Management System.STC SA7315SW-DInstallation of the UNS-1B integrated flight management system.STC ST00734NY-DInstallation of AlliedSignal Dual MST-67A Mode S Transponders and Single CAS-67A TCASII System.STC ST00735NY-DInstallation of AlliedSignal Enhanced Ground Proximity Warning System.STC SA8306SW-DInstallation of UNS-1C Flight Management System.STC SA8294SW-DInstallation of reduced vertical separation minimum (RVSM) capability.STC SA8302SW-DInstallation of UNS-1D Flight Management System.STC ST00878NYInstallation of placard to limit occupancy of existing jump seat to crew members only.STC SA8260SW-DInstallation of Collins Pro Line 4 Avionics System.