Database
[{"departures":[{"movement":{"airport":{"icao":"EHAM","iata":"AMS","name":"Amsterdam"},"scheduledTimeLocal":"2020-05-23 12:25+01:00","scheduledTimeUtc":"2020-05-23 11:25Z","quality":["Basic"]},"number":"KL 1446","status":"CanceledUncertain","codeshareStatus":"IsOperator","isCargo":false,"aircraft":{"model":"Embraer 190"},"airline":{"name":"KLM"}},{"movement":{"airport":{"icao":"EGLL","iata":"LHR","name":"London"},"scheduledTimeLocal":"2020-05-23 14:50+01:00","scheduledTimeUtc":"2020-05-23 13:50Z","quality":["Basic"]},"number":"BA 1309","status":"Unknown","codeshareStatus":"IsOperator","isCargo":false,"aircraft":{"model":"Airbus A319"},"airline":{"name":"British Airways"}}],"arrivals":[{"movement":{"airport":{"icao":"LFPG","iata":"CDG","name":"Paris"},"scheduledTimeLocal":"2020-05-23 21:10+01:00","scheduledTimeUtc":"2020-05-23 20:10Z","quality":["Basic"]},"number":"AF 1472","status":"Unknown","codeshareStatus":"Unknown","isCargo":false,"aircraft":{"model":"Embraer 170"},"airline":{"name":"Air France"}},{"movement":{"airport":{"icao":"EHAM","iata":"AMS","name":"Amsterdam"},"scheduledTimeLocal":"2020-05-23 22:15+01:00","scheduledTimeUtc":"2020-05-23 21:15Z","quality":["Basic"]},"number":"KL 1451","status":"CanceledUncertain","codeshareStatus":"IsOperator","isCargo":false,"aircraft":{"model":"Boeing 737-700"},"airline":{"name":"KLM"}}]}]
Query
db.collection.find({},{arrivals:{$elemMatch:{"number":"KL 1451","movement.scheduledTimeLocal":{$regex:"2020-05-23"}}}})