Mcdonnell-Douglas DC-10-10F
STCs that may be installed · 160
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 ('3022111')
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 ('3022111')
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 SA3368WEInstallation of eight-abreast coach seating in forward cabin behind the first class section, and associated oxygen and electrical system modifications.STC SA3212WEInstallation of forward cargo compartment positive vent sump drain.STC SA2987WEInstallation of cabin lounge swivel seats and adjustable table with removable top.STC SA2948WEInstallation of buffet/bar and bustle assembly.STC SA2985WEModification of installed G1 and G1A galleys (Dale P/Ns CAG-11000, CF-10-1, CAG-10000, CF-7000).STC SA2924WEInstallation of wheeled refrigerated module, P/N 73011000.STC SA2524WEInstallation of lounge seats, four-place divan, L-shaped bar, and cocktail tables.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-10F