That is just a Archimedes' screw. Well known way before DaVinci.
It's cool that DaVinci got to the conclusion that if moves water it can move air, thou.
There original design used materials from the time, but with an enough powerful engine you can probably make it fly.