My Macbook Air fan is really loud
If the SMC reset did not work it seems likely it could be a hardware problem. I would guess it's going into a fail safe mode causing the fans to always run full speed. This could happen if a temperature sensor malfunctioned , I would recommend taking the system into an Apple Authorized Service provider.