Well in fact it's very easy
https://isrcsearch.ifpi.org/#!/search chose advanced and searched for Paul McCartney. Chose Release name The 7" Singles and Recordings per page 100 and Show releases.
Add all to the chart, go to next page and Add all to chart and continue.
Click on cart, Download as csv.
Now you use excel, open an empty sheet, chose data, chose from CSV of the file you have downloaded and import the data.
And now you have the data in the spreadsheet.
Do this for the Beatles, solo, sons, granddaughter, wives, dark horse, apple, etc. and you'll have something like 10.000 numbers and thus all the masters and the releases they are found on. Only artist name and no year, title etc. to get them all and not only a specific album, year etc.
Very easy but takes only a short time to do it. Next time you can search for releases from 2023 alone and then update your big personal database.
You'll be suprised and find various new masters and new remixes you didn't know about.
In less than a minute I have grabbed the entire set of masternumbers from the McCartney 7" singles box. A few are shown below:
Uncle Albert / Admiral Halsey GBCCS2200001
Too Many People GBCCS2200002
The Back Seat of My Car GBCCS2200003
The Mess GBCCS2200004
Helen Wheels GBCCS2200005
Sally G GBCCS2200006
Love In Song GBCCS2200007
Venus And Mars/Rock Show GBCCS2200008
GB= Great Britain CCS is Record company 22 is 2022 and 00001 is masters done in this series. CCS is used for McCartney releases. Read more about ISRC here:
https://isrc.ifpi.org/en/
I really wonder why noone has used this database to make "the book". You get the artist, song, mix/remix/remaster, year, running time, release title, releasenumber and more.