Hope this is not off-topic as asking for data-sources.
I am developing an app for flights booking and status, I have everything ready but I would like to have an image displaying for each major city in the world e.g:
Obviously each image should be of the same height and width.
So is there some database/API-service which I can use to retrieve those images using the city code (Metropolitan Area) e.g. ROM for Rome, QSF for San Francisco or airport code e.g. JFK for John F. Kennedy International Airport in New York (US), LCY for London City Airport in London (UK)?
Note: If you know an API-service I need it to be in JSON, instead if you know a DB it must be MySQL or SQL based