That's perfectly fine. You can always present your new passport at check-in (where it matters). Most airline requires that the name you use for booking matches the name on your passport so things can be a bit tricky if the names on both passports are different. In most cases the airlines can handle this as well.