Mcdonnell Douglas DC-10-15
STCs that may be installed · 131
In force first, then newest. The registry doesn’t record which STCs an aircraft has.
Query with SQL
duckdb -csv -c "SELECT s.stc_number, s.description, s.holder, s.status, s.status_date, m.matched_model
FROM (
SELECT stc_number, min(matched_model) AS matched_model
FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_stc.parquet'
WHERE aircraft_model_code IN ('3022118')
GROUP BY stc_number
) m JOIN 'https://openairdocs.org/data/latest/faa_stc.parquet' s USING (stc_number)
ORDER BY 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 s.stc_number, s.description, s.holder, s.status, s.status_date, m.matched_model
FROM (
SELECT stc_number, min(matched_model) AS matched_model
FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_stc.parquet'
WHERE aircraft_model_code IN ('3022118')
GROUP BY stc_number
) m JOIN 'https://openairdocs.org/data/latest/faa_stc.parquet' s USING (stc_number)
ORDER BY 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.
STC SA3888SWRemanufacture of Airesearch oil cooler heat exchanger P/N 158440 by replacing core assembly.STC SA7859SWRecore of Englehard P/N D19563 ozone converters.STC ST00414LAInstallation of flap handle transmitter and flap position transmitters.STC ST01225ATInstallation of an Aircraft Communication Addressing and Reporting System (ACARS).STC ST01393ATInstallation of Liquid Crystal Display Electronic Attitude Direction Indicators and Horizontal Situation Indicators(EADI/EHSI).STC SA3985NMInstallation of Piston-shoe assembly p/n 700003.STC ST01268ATInstallation of a mixed class seating arrangement with 14 first class and 338 tourist seats.STC ST01026ATInstallation of global positioning system monitoring unit.STC ST179CHInstallation of cargo container curtain.STC SA8913SWInstallation of Weed model A9806 Total Air Temperature Probe.STC ST00456ATInstallation of a Gull fuel quantity indicating system.STC ST00629ATModification of fuel quantity indicating system from metric to English units.STC SA3278SOInstallation of a modified smoke barrier in Class E cargo compartment.STC SA2779CEInstallation of Collins TCAS II traffic alert and collision avoidance system.STC ST00232ATInstallation of tray carriers.STC SA3970SW-DInstall a Litton LTN-2001 global positioning satellite sensor unit(GPSSU) with dual wiring provisions.STC SA5214NMInstallation of AMI model 2055 cabin attendant seat.STC SA3864SWRelocate passenger emergency oxygen from seatback to center console between passengers.STC SA3929SW-DReplace the single Litton LTN-51 INS with a LTN-72STC SA3699SWInstallation of Plumly airborne floor proximity lighting 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 SA5881SWInstallation of class divider.STC SA1258EAInstallation of Cosco model78-( ) child restraint system. (172M S/N 17263459 - 17267584)STC SA1342SOInstallation of Aero Systems CD-3000 fuel management computer.STC SA4566SWInstallation of inner pane, accoustic cabin window.STC SA108NWInstallation of Mark IV visual entertainment system.STC SA132NWInstallation of Sundstrand Visual Entertainment SystemSTC SA285NWFactory installation of Xenon light in Sundstrand Visual Entertainment System installations.STC SA36NWInstallation of Sundstrand Ground Proximity Warning SystemSTC SA3918SW-DInstallation of Hughes-Avicom audio/game entertainment system.STC ST00743LA-DInstallation of control column and rudder pedal, position sensors for Flight Data Recorder Expanded Parameters.
Back to Mcdonnell Douglas DC-10-15