AI Analysis: Railway industry inventory of equipment in service by mainline companies

Executive Summary

Canada's mainline railway equipment inventory has undergone a dramatic long-term contraction since the late 1980s, with total freight cars falling 60.5% from a peak of 119,359 units in 1988 to just 45,153 in 2024, and total locomotives declining 32.9% over the same period. The dataset, covering four company groupings from 1986 to 2024, is heavily right-skewed — a median of just 23 units versus a mean of 3,590 reflects that a small number of large freight car categories dominate the overall counts. Structural shifts in fleet composition are also evident, including the near-complete transition to diesel locomotives and the virtual disappearance of cabooses and box cars.

Key Findings

• Total freight cars declined 60.5% from a peak of 119,359 units in 1988 to 45,153 units in 2024, representing the most dramatic fleet reduction in the dataset.
• Box cars experienced the steepest category-level decline, falling 84.4% from 39,543 units in 1986 to just 6,186 units in 2024.
• Total locomotives dropped 32.9% from 3,427 units in 1986 to 2,299 in 2024, the smallest relative decline among tracked equipment categories.
• Hopper cars showed the greatest resilience among freight car types, declining only 34.8% from 27,663 to 18,048 units over the 39-year period.
• The dataset is heavily right-skewed, with a median value of just 23 units compared to a mean of 3,590, and at least 25% of all records reporting zero units of equipment.
• A perfect correlation (r=1.0) between diesel freight locomotives and total freight locomotives confirms that diesel power has completely dominated the freight locomotive fleet.
• The strongest negative correlation (r=-0.966) between diesel passenger locomotives and 'other' passenger locomotive types reflects a decisive fleet-wide shift to diesel technology across the 1986–2024 period.