This study fills the noted gap in comparative analyses of spent nuclear fuel (SNF) by assessing inventories from two key nuclear power regions, the USA and Canada, using a comprehensive analytical framework and standardized data from 2009 to 2021. In the USA, SNF inventory increased by 14.7 % in fuel assembly weight and 47 % in residual heavy metal content compared to Canada, in line with their use of light water reactors. Canada's SNF production is directly correlated to its nuclear power output, influenced by the lower burnup of natural uranium fuel used in CANDU reactors (R2 = 0.57; p-value < 0.05) while the USA shows insignificant correlation, likely due to a variety of reactor types and higher burnup rates (R2 = 0.008; p-value > 0.05). Further, the study identifies a strong negative correlation between uranium mine production and SNF inventory in the USA, indicating a reliance on imports amidst negligible domestic mining. In contrast, Canada also exhibits moderate negative dependency due to its position as a major uranium exporting jurisdiction. The obtained negative correlations with coal rents in both countries indicate a shift towards more nuclear energy use, impacting economic growth and energy patterns. The developed predictive models indicate a higher future SNF increase in Canada than in the USA. These findings are essential for planning the transition from temporary to permanent SNF disposal, ensuring safe long term management of radioactive waste.