Is it possible to manipulate colonies to let them work as harbor/airport?

no, but i wish it was

Will connecting a colony to an airfield allow air trade?

Ed,
no i don't think so. But there has been a discussion about that a few days ago. Thread was about blocking trade by air-sup.