Mcdonnell Douglas DC-10-10
STCs that may be installed · 322
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 ('3022110')
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 ('3022110')
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 SA2853WERetractable tiedown assemblies.STC SA3407WEInstallation of Lermer Apparatebau GMBH beverage cart No. L15701.STC SA3367WEInstallation of nine-abreast coach seating and associated oxygen and electrical system modification.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 SA3127WEInstallation of first class passenger seats incorporating unitized oxygen systems.STC SA3067WEInstallation of lower lobe food service modules, P/Ns 818720, 820130, 820140, 820150.STC SA2611WEInstallation of three Litton LTN-51 inertial navigation systems, an inertial navigation switching unit and two Sperry horizontal situation indicators.STC SA2888WEInstallation of three Litton LTN-51 or LTN-72 inertial navigation systems.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 SA2893WEInstallation of Hermes LD-3 Kool- flite refrigerated cargo container.STC SA2524WEInstallation of lounge seats, four-place divan, L-shaped bar, and cocktail tables.STC SA969EAInstallation of Inflight movie projection assembly P/N 10270, Super 8mm IMPAK system.STC SA2395WEInstallation of coffee bar cart, P/N 801000.STC SA36NWInstallation of Sundstrand Ground Proximity Warning SystemSTC ST734SOInstallation of NAL Val-Pack coat-room, P/N 10621-1.STC SA10GLInstallation of Gayston Model 800LG and 800SG static dischargers on transport category airplanes.STC 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-10