An American pilot who was caught over the alcohol limit before a flight from Edinburgh to New York has been jailed for 10 months.