Yes, Appradio and app radio extensions, using the pioneer USB iphone cable
yes, you can load videos on your SD car and play it. it's in the owners manual....
http://www.pioneerelectronics.com/PUSA/Car/GPS-Navigation/AVIC-Z140BH
http://avic411.com/index.php?/topic/34825-z140bh-unable-to-play-moviesvideos-from-sd-or-usb/