First, note that the LoRa modems support a wider range of spreading factors and bandwidths than is defined in the LoRaWAN spec. We are obviously restricted to those.
For planning purposes, use the 30 sec. maximum air-time per day. Don't count on being able to use more than that. This translates for a 10 byte payload in 12 frames on SF12 to 500 on SF7. If your application requires more, you need to modify something: smaller payload, move closer to the gateway, etc. Or different technology.
Hint: don't use json in your payload!
The duty-cycle regulations per band limit the minimum interval you can use between frames.
Also note that there are two high-speed channels available, that will increase your number of frames over 500: SF7BW250 and FSK (50kbps in Europe). This works great at small distance, e.g. in and around your house.