Which tense is correct? "Bob wanted to know if he is/was a father"

Solution 1:

Was

You're talking about an event in the past since "wanted" is in the past. Three years ago is not the present, so "is" can't be used. It's that simple.