Still looks the same. Is this what you mean?
SELECT userairportservices.usr_id_users, userairportservices.airport_id_airport, airport.airport_code, airport.airport_name, MAX(if(service_id_service=1, 1, 0)) AS JET, MAX(if(service_id_service=2, 1, 0)) AS GROUND, MAX(if(service_id_service=3, 1, 0)) AS GLYCOL
FROM airport LEFT JOIN userairportservices ON userairportservices.airport_id_airport = airport.airport_id
WHERE userairportservices.usr_id_users = usr_id
GROUP BY airport_id_airport LIMIT 0, 30
Dave