We really enjoyed our stay in the airstream - it's a small space so be prepared for that, especially if you've got a suitcase you need to get in and out of daily. We stayed for two nights and it felt like the perfect amount of time. It's a bit expensive for the amount of space/amenities you're getting, but there are not a lot of lodging options on the North Shore and the airstream is a fun and unique experience.
The inside of the trailer was very cute, very clean, and the bed was comfy. My favorite part of the stay was that you are close enough to the water to hear the ocean. We weren't bothered by not having A/C, the temperature at night was comfortable. The shower and toilet are standard for a trailer, small but clean, and we had plenty of hot water. The area beside the airstream has a firepit, a covered picnic table, and chairs - we didn't use these things because we were so busy, but they're nice options to have! We didn't have any communication with the host(s) at all, but we didn't have any issues that we needed to reach out to them about.
The location is a good spot to base yourself if you want to explore the North Shore of Oahu - you can easily go into nearby Haleiwa or travel further east or west. The airstream is located on the grounds of the North Shore Stables - it is a bit confusing to navigate to the airstream at the back of the property if you first arrive to check-in after dark, as there's no lighting or signage. We had hoped to arrive earlier but picking up the rental car at the airport took much longer than expected, and even rushing to get to the North Shore, it was dark by the time we arrived. I'd suggest trying to get there with a little light left to make it easier!
Overall, we recommend staying here if you're looking for a unique and cozy place to stay and don't require a lot of space or frills. The airstream has a lot of character and is in a nice, quiet location right on the ocean.