The Condor is one of the largest and heaviest helicopters in the game. Although it should be usable as troop transport, it is useless at it since it can only carry one passenger. It has the heaviest lift capacity out of all helicopters, it is only equaled by the Jade Wind or Lucky Ladies but they are the same vehicle with different names and paint jobs.
It is extremely rarely found around the Amazons and almost nowhere else. The only place to see a Condor for certain is the first 'Rescue Carmona' contract and it is possible that Ewan was piloting it and not a VZA pilot since it has a PMC icon over the cockpit. It is available for purchase from the Pirates.
The Lucky Ladies must be a variation of a Mi-26 design, like the Condor.
The Condor is based on the Mil Mi-26 "Halo," the largest and most powerful helicopter to have gone into production.