>Surely there must be a way to do this with one SQL string?

Absolutely, if you don't care what you get for failoc and faistatus:

Select Max(recseq) As recseq, Max(failoc), Max(faistatus) From webprddt6.drawmfai Where part no = '860637-001' Group By partno