CREATE TABLE table_15827397_1 (locomotive_type VARCHAR2, status VARCHAR2)

Which locomotive type has a status in static display
SELECT locomotive_type FROM table_15827397_1 WHERE status = "Static display"
SELECT "locomotive_type" FROM "table_15827397_1" WHERE "Static display" = "status"