[{"_id":"5d7f4aa4d2394d86aacbfbe0","aeroplanes":[{"_id":"5d7f4aa4d2394d86aacbfbd8","capacity":1442,"flights":[{"_id":"5d7f4aa4d2394d86aacbfbd7","arrival_time":"2003-07-29","departure_time":"1984-09-19","gate_number":6,"seats":[{"_id":"5d7f4aa4d2394d86aacbfbd6","price":1779,"ticket":null,"type":"A"}]}],"model":"Blue writer second all capital become."},{"_id":"5d7f4aa4d2394d86aacbfbdf","capacity":240,"flights":[{"_id":"5d7f4aa4d2394d86aacbfbde","airport_id_as_dest":"5d7f49f1d2394d86aacb7d26","airport_id_as_source":"5d7f49f1d2394d86aacb7cc9","arrival_time":"2009-04-30","departure_date":"2016-05-07","gate_number":2,"seats":[{"_id":"5d7f4aa4d2394d86aacbfbdd","price":1896,"ticket":{"_id":"5d7f4aa4d2394d86aacbfbdc","agent_id":"5d7f49f1d2394d86aacb7cf2","boarding_pass":{"_id":"5d7f4aa4d2394d86aacbfbdb"},"pnr":{"_id":"5d7f4aa4d2394d86aacbfbda","name":"Breanna","passenger_id":"5d7f49f1d2394d86aacb7d3a","services":[{"_id":"5d7f4aa4d2394d86aacbfbd9","service":"Dawn "}]}},"type":"A"}]}],"model":"Stand system pattern write."}],"name":"Raise billion order close.","type":"Asd-1-3"}]

db.collection.aggregate([{$project:{type:1,name:1,aeroplanes:{$filter:{input:"$aeroplanes",as:"a1",cond:{$ne:[{$map:{input:"$$a1.flights",as:"a2",in:{$cond:[{$eq:[{$filter:{input:"$$a2.seats",as:"a3",cond:{$eq:["$$a3.ticket",null]}}},[]]},"NO_DATA",{_id:"$$a2._id",arrival_time:"$$a2.arrival_time",departure_time:"$$a2.departure_time",gate_number:"$$a2.gate_number",model:"$$a2.model",seats:{$filter:{input:"$$a2.seats",as:"a3",cond:{$eq:["$$a3.ticket",null]}}}}]}}},["NO_DATA"]]}},}}}])