The rapid advancement of fifth-generation (5G)-and-beyond networks coupled with unmanned aerial vehicles (UAVs) has opened up exciting possibilities for diverse applications and cutting-edge technologies, revolutionizing the way connections, communications, and innovations unfold in the digital age. This paper presents a comprehensive survey of the deployment scenarios, applications, emerging technologies, regulatory aspects, research trends, and challenges associated with the use of UAVs in 5G-and-beyond networks. It begins with a succinct background and motivation, followed by a systematic UAV classification and a review of relevant works. The survey covers UAV deployment scenarios, including single and multiple UAV configurations. The categorization of UAV applications in 5G is presented, along with investigations into emerging technologies for enhancing UAV communications. Regulatory considerations encompassing flight guidelines, spectrum allocation, privacy, and safety are discussed. Moreover, light is shed on the latest research trends and open challenges in the field, with promising directions for future investigations identified, concluding with a summary of key findings and contributions. This survey serves as a valuable resource for researchers, practitioners, and policymakers in the UAV and communication domains. Additionally, it offers a comprehensive foundation for informed decision-making, fostering collaboration, and driving advancements in UAV and communication technologies to address the evolving needs of our interconnected world.