You shoul try North Carolina State Archives, unless you know that he moved to another state after the war. Confederate veterans normally applied to their current state of residence, as long as that state granted relief to former Confederate soldiers.