How do i find out what houses are owned by limited liability partnerships then find out who the general partners are so i can get a list of all the partners

That sounds like a search going from the General to the Specific.

It would be easier to go from the Specific to the General.

If you have a specific Property in mind, then your Secretary of State will have as a Public Record, all the Registered Owners of the Partnership or Corporation IF it does business in Arizona. But Real Estate could be owned by an artificial entity located almost anywhere.