This paper presents Cluster On-Demand Distance Vector Routing (CODV) algorithm for distributed aggregation service in mobile ad hoc sensor networks to achieve important networking requirements, including network scalability, load balancing, loss tolerance, and prolonged lifetime. CODV allows users to express simple queries and have them executed at the cluster heads within the networks of mobile wireless sensors. The distributed aggregation collected and processed by a cluster head transmits to the original observers who wish to request the integrated aggregation service. We also include a performance study demonstrating the advantages of our approach over traditional aggregation methods in ad hoc sensor networks.