SCHEMA:
CREATE TABLE Aircraft (aid VARCHAR, name VARCHAR, distance VARCHAR)
USER:
Show the id and name of the aircraft with the maximum distance.

QUERY:
SELECT aid, name FROM Aircraft ORDER BY distance DESC LIMIT 1