What about the flight numbers?
SELECT flno FROM Flight WHERE origin   =   "Los Angeles" AND destination   =   "Honolulu"
flight numbers refers to flno; origin of the flight refers to Los Angeles; destination of the flight refers to Honolulu;