Question: have arrived or had arrived?
Answer: This is simple past tense. He had arrived yesterday is grammatically wrong. Had arrived is past participle. (With reference to the example given)We use participles when we speak about actions that are done before certain other specified actions.