16 hours, MIA-MBJ on USAirways some years ago for a 5th anniversary trip. CLT-MBJ diverted to MIA for hydraulic leak 40 miles out from MBJ as "MBJ doesn't have crash foam." We waited an hour+ on the plane while they waited on the part, finally deplaning after an hour or so. Turns out MIA didn't have the needed part. They'd bring one in from another airport.
1st attempt, someone forgot to put the part on another plane bound for MIA. 2nd + 3rd attempts, weather prevented landing. By this time we were watching the weather channel and doubted anything could land for some time.
By the time US put the part in a taxi in...Palm Beach, I think? the crew was illegal and the flight cancelled at 11:30 pm. They offered a hotel and shuttle but after standing in line with raining blowing in under the cover for an hour, we realized we would have gotten to the hotel at 3:00 and had to be back at 6:00 (long line to make arrangements, a crying bride, antsy kids on a mission trip, 1 shuttle, 40 minute round trip, 180 people). We gave up and catnapped in MIA until we finally departed. Our anniversary present was a looped recording of the mayor of Miami welcoming us to MIA that got burned into our brains forever. The flight the next morning was smooth sailing.
For the next couple of years, the FAs on that flight recognized us as having shared the "MBJ doesn't have crash foam" flight :-)