For transporting diesel OCS CP uses/used cars in the 400000 to about 400370-ish
series of tank cars and a new series in the 4156xx to 4157xx range. The latter
group of cars is slowly replacing the former, but some of the 400000 series
were spotted by me this this year. The numbers are accurate as they are backed
by photos, but I don't have access to a list of equipment to provide the exact
ranges. There were some fuel tanks (diesel and gasoline, or just diesel) on
flatcars in the 404860 to 404899 range to service work crews.
Most water service cars are/were in the 415xxx series.
Mark