@yuppicide thanks for the pics. These superguns are not documented very well on the internet and I'll try do the same eventually when I get mine out of storage. If you could, please also snap some pics of the stick internals along with the "front" side of the supergun itself where the controller inputs are. Curious if yours is wired to 25 or 15 pins. I think the only difference would be the connector itself as even in my case there are 15 or less live pins on the DB25 end, so it becomes a little more work for me to mod or wire up other input devices to account for this.
I believe your stick has a different color scheme than mine for whatever that is worth. Either way, very cool that you have one considering the scarcity and demand these days. It even looks like the stick case is in good shape also, so that's a big bonus.
Forgot to comment prior re: round connector next to the yellow composite video plug. This is indeed for RGB. However as suggested earlier you will want to be careful what you plug this connector into as-is, at least until you get a reading for voltage with live video signal coming out of this output. What I used to do years ago was take a SCART cable connected to this port, run it through an RGB to YUV converter and connect to a component input on a consumer grade CRT. Pretty decent results from memory but it's 480i in the end and that may or may not be a desired result in your case. Thankfully there are many easy ways to pull video from JAMMA these days (plus attenuated audio for that matter) and we don't necessarily need to go the same route as OEM design for this device. As long as it powers on and provides safe voltage to your board(s), you should have the hard parts of this process handled well. Thankfully it comes equipped with a switching power supply, so we're good on that end.
Looking forward to seeing your end results with this supergun.