How to get a list of nodes with infinite loops?

Following a migration of a huge website I manage, lots of pages are showing up the "Oops!" infinite loop message. These are easily fixed on a per-node basis, but the problem is we don't know how many nodes are affected, so we're only able to fix the infinite loops as people report them, which they don't always do. (Editors will see the "oops" message and can report/fix it but anonymous users just get a "this page has a redirect loop" ERR_TOO_MANY_REDIRECTS message and simply can't access the page and think the site is broken.)

Is there a way to get a list of all the pages affected so that I can go through and remove the redirects? I was thinking maybe some PHP could compare all the redirect paths with the path alias for each node, and show an edit link to said node if there is a match. My PHP isn't good enough to do that though... I've tried Views but can't see anything built-in that would do what I want.