Task: Text to Code
Input (English): What is the id and name of the aircraft that can cover the maximum distance?
Output (English): SELECT aid ,  name FROM Aircraft ORDER BY distance DESC LIMIT 1