The "at" and "from" versions express essentially the same thought.
However, the focus is slightly different: "at (the airport)" concentrates on the point at which the pick-up will occur, while "from (the airport)" has an added nuance – that after the pick-up, you will then progress to some other location (probably your starting-point).