If you are looking for the Tanach in Hebrew, this is probably the best app out there --
Totally Tanach - the Hebrew/English Bible for iPhone, iPod touch, and iPad on the iTunes App Store
Its not cheap (by app standards) at $9.99, but it is worth it.
I use the Blule Letter Bible app for IPad. It uses a combination of downloadable bibles/ online bibles and resources, commentaries dictionaries etc, and its all free. To many functions to list here check it out.
For some reason the Bible HD app crashes on my iPad after the initial opening screen, even after a removal/reinstall several times, so I have given up on that one.
You might also want to check out the newly released Accordance app. It is a release they wanted to get out to satisfy huge demand from their Mac desktop users, so there are a few little issues they are working on to quickly squash, but they have done a fantastic job at bringing over their powerful search engine.
so how can I find one that does not require wireless service to use???