This Gem reads a list of processed visa applications from the German consulate. It contains a binary to check if a specific application has been processed yet.
$ gem install visa_check
$ visa_check 1234567