Locomotive type one has status static display
No. Name Livery Locomotive type Wheel Arrangement Builder Year built Status
Shuzenji Romney Railway
real text text text text text real text
1-15827397-1
Locomotives
Locomotives
1 Northern Rock II Highland Railway green Steam 2-6-2 Ravenglass & Eskdale Railway 1989 In traffic
2 Ernest W. Twining Dark blue Steam 4-6-2 G & S Co. 1950 Static display
3 John Southland II Two-tone red Diesel B-B TMA Engineering 1988 In traffic
4 Cumbria Brunswick green Steam 2-6-2 Ravenglass & Eskdale Railway 1992 In traffic
5 City of Birmingham Two-tone green Diesel 0-6-0 TMA Engineering 1992 In traffic
table_15827397_1
SELECT Locomotive type FROM table WHERE Status = Static display
Static display