Just found out about this site which shows Structurally deficient bridges on google, they even break down the bridge with the average daily traffic (doesn't show % of truck traffic tho), year built, ratings and even the last date of inspection (which I'm hoping is not up to date in Mass since they are out of cycle).
There is also a table that breaks down the states. I'm not sure if I should be happy or that Rhode Island and Massachusetts are near the top of the list.
