select the city Atlanta[GA] Beijing Chicago[IL] Dallas Fort Worth[TX] Dubai Frankfurt Hong Kong London Los Angeles[CA] Moscow New York[NY] Paris San Francisco[CA] Sao Paulo Seattle[WA] Sydney Tashkent Tokyo Washington D.C.[DC] select DISTINCT B.CITY_CODE, cbb.getCodeName(B.CITY_CODE, '1002EN', '1005') CITY_HNAME FROM ( SELECT ORGAPO AIRPORT FROM CYB_INFLIGHTSERVICE UNION SELECT DESTAPO FROM CYB_INFLIGHTSERVICE ) A LEFT OUTER JOIN CYB_CITY B ON A.AIRPORT = B.AIRPORT_CODE AND B.AS_GUBUN = 'A' WHERE B.NATION_CODE <> 'KR' ORDER BY 2

Route Flight No. Days operated KOSMO SLEEPER SEAT PRESTIGE PLUS SEAT AVOD In-seat power supply

View all available routes (This flight schedule is valid until 10 Dec. 2008)

Route Flight No. Days operated KOSMO SLEEPER SEAT PRESTIGE PLUS SEAT AVOD In-seat power supply