This is the first time he has visited his aunt.
Can be said before he visits or when he is there.
This was the first time he had visited her aunt.
<This time I'm telling you about> was the first time he had viisted his aunt.
Used by a writer narrator to bring the reader into the present of the story. A little like "Now was the time he knew he had to visit his aunt". Tense shifting for effect.
It / this will be the first time he is visiting / will visit his aunt.
Said before he goes (or when on his way).