Unfortunately there is no way of knowing exactly, as they all look similar, have no branding, and are sold by a variety of different front shops that change names constantly. Your best bet is to go on amazon and buy 3-5 adapters from different sellers that look like this one: https://www.amazon.com/Zer-one-Controller-Converter-Compatible/dp/B07W91HMQJ/ref=sr_1_14?crid=1ZO1HO9F8QA7B&keywords=ps1%2F2+to+ps3+adapter&qid=1640652493&sprefix=ps1%2F2+to+ps3+adapte%2Caps%2C135&sr=8-14
Then test them all and return the ones that don't work. To test them you should use Ace Combat 2 in Retroarch. Plug in the controller and see what it is recognized as. The adapters that work will usually recognize as "Playstation 3 controller" (as opposed to USB controller or similar).
In Retroarch when you have booted the game go into the Retroarch menu and go to OPTIONS and then PLAYER ONE and switch the controller type from "Standard" to "Analog". DO NOT go into "Controllers" or mess with any other kind of binding.
Then in the Ace Combat 2 settings menu go to controller configuration and you should see the dual flight stick on the screen and then be able to test all the functions and analog movement of each stick.