SCHEMA:
CREATE TABLE table_name_39 (aircraft VARCHAR, type VARCHAR)
USER:
Which aircraft has heavy transport?

QUERY:
SELECT aircraft FROM table_name_39 WHERE type = "heavy transport"