without sample data, it's hard to tell, but my guess is that you're missing a WHERE clause...

SELECT PartNumber, SerialNumber, MAX(InspectionDate) AS LastInspection

FROM MyTable

WHERE PartNumber IS NOT NULL

GROUP BY PartNumber, SerialNumber

ORDER BY PartNumber, SerialNumber;