Providing connectivity to unmanned aerial vehicle-user equipment (UAV-UE), such as drones or flying taxis, is a major challenge for tomorrow’s cellular systems. In this paper, the use of coordinated multi-point (CoMP) transmission for providing seamless connectivity to UAV-UEs is investigated. In particular, a network of clustered ground base stations (BSs) that cooperatively serve a number of UAV-UEs is considered. Two scenarios are studied: scenarios with static, hovering UAV-UEs and scenarios with mobile UAV-UEs. Under a maximum ratio transmission, a novel framework is developed and leveraged to derive upper and lower bounds on the UAV-UE coverage probability for both scenarios. Using the derived results, the effects of various system parameters such as collaboration distance, UAV-UE altitude, and UAV-UE speed on the achievable performance are studied. Results reveal that, for both static and mobile UAV-UEs, when the BS antennas are tilted downwards, the coverage probability of a high-altitude UAV-UE is upper bounded by that of ground user equipments (UEs) regardless of the transmission scheme. Moreover, for low signal-to-interference-ratio thresholds, it is shown that CoMP transmission can improve the coverage probability of UAV-UEs, e.g., from 28% under the nearest association scheme to 60% for an average of 2.5 collaborating BSs. Meanwhile, key results on mobile UAV-UEs unveil that not only the spatial displacements of UAV-UEs but also their vertical motions affect their handover rate and coverage probability. In particular, UAV-UEs that have frequent vertical movements and high direction switch rates are expected to have low handover probability and handover rate. Finally, the effect of the UAV-UE vertical movements on its coverage probability is marginal if the UAV-UE retains the same mean altitude.