Mcdonnell Douglas MD-10-10F
STCs that may be installed · 59
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 ('3022112')
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 ('3022112')
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 ST02643ATManufacture of service carts for galley stowage.STC ST01417LAInstallation of a third landing gear down/lock indication system.STC ST01495CHInstallation of Rosemount Aerospace Model 0861DV1 angle of attack sensors.STC ST02480ATInstallation of a Courier seat module (CSM), p/n CSM-010-010-019 (2-place). Approved for installation on serial number 46633 ONLY.STC SA3626WERevision of DC-10 fire/overheat detection system to allow intermixing of Systron Donner fire detectors with Edison detectors in the fan, core, and pylon sections of the CF6 engines.STC SA3432WEInstallation of fire/overhead detection system.STC ST01134LAInstallation of Unit Load Device center of gravity offset limit kit.STC ST01072LAInstallation of a red cover fuel shut-off handle assembly.STC SA36NWInstallation of Sundstrand Ground Proximity Warning System
Back to Mcdonnell Douglas MD-10-10F