When n1ql query has s.day = 7 - there are no flights returned. Decrement the value to start at 0 and it works fine.