Pompey,
I don't know of a web site with all the details you require, but for MS & NAS parts , etc. the following book may be of use:
Aircraft Hardware Standards Manual and Engineering Reference
by S J Dzik
ISBN 0879940123
I think Amazon.com has some sample pages available.
The AGS part numbers in this book are for MS / NAS / etc. For company stanadard AGS parts (i.e. where a company assigns its own part number to a normal MS or NAS part) you will have to request access to the company standard parts manual on a case-by-case basis.
Regards,
Rikman