Hi UTME83,
The first place I would start your research is the tutorial post here which has all the basic information, steps, and guidelines you will need all in one place that will help you make the best possible choices … and know how and why to avoid the worst ones.
You can see my thoughts about airbeds in this article but at the very least I believe you are getting poor information from your Chiropractor if he is recommending a specific brand which is not the “best value” in airbeds (although they do the best job at marketing). Purchasing a mattress based on the name on the label is one of the worst ways to choose a mattress.
You can see more of my thoughts about Tempurpedic in post #2 here and the other posts it links to. While the “value” of a mattress purchase depends on the parts of each person’s personal value equation that are most important to them … for most people a Tempurpedic (even at discounted prices) wouldn’t be good value compared to the many other options you have available that use the same or better quality materials at much lower prices.
I don’t recommend any specific materials (this is a personal preference that is unique to each person) and both Sleep Number and Tempurpedic would be included in the list of major manufacturers I would tend to avoid (see this article).
While the type of materials and components that each person prefers may be very different … I do “recommend” that no matter which materials or components you prefer or which mattress is the best “match” for you in terms of PPP (Posture and alignment, Pressure relief, and Personal preferences) that you make sure you know the quality of all the materials in your mattress because every type of material and component has higher quality more durable versions and lower quality less durable versions. You read more about the things to look for in a “perfect” mattress in post #2 here.
Once you get to step 3 in the guidelines if you let me know your city or zip code I’d be happy to to link you to a list of the better options or possibilities I’m aware of in your area.
Phoenix