As far as the ATF goes, once they get a firearm and S/N, they start with the manufacturer, then the distributor, and then the dealer that sold the firearm. I am not aware of any process where the ATF can figure out the guns purchased by an individual based on the individual’s name.
This may not be the case if a local jurisdiction or state has some sort of registry.