CREATE TABLE table_203_538 (id DECIMAL, "flight" TEXT, "date" TEXT, "payload nickname" TEXT, "payload" TEXT, "orbit" TEXT, "result" TEXT)

the only flight on november 27th
SELECT "flight" FROM table_203_538 WHERE "date" = 'november 27, 1997'
SELECT "flight" FROM "table_203_538" WHERE "date" = 'november 27, 1997'