Is there any site where in you can search the Passenger traffic moving in and out of a city?

No because that would be illegal. They wouldn't let a stranger look at a city's individual data as they might be extremists and/or part of an enemy country planning for something :P