Building numbers list on street

Normally, you don't need a special software with spacial queries. If the street numbers are correctly tagged, the link between the number and its street is already in OSM. To simplify, currently they are two methods to link the street number of a building to its street (also documented in the wiki) (which method is used is a contributor decision):
- two tags "addr:housenumber=< a number>" + "addr:street=< the street name>" set on the same OSM element, a node or a closed way (a polygon) or a relation (most probably a relation for a multipolygon)
- one tag "addr:housenumber=< a number>" set on the OSM element, node or way like above, and attached to a relation of type "associatedStreet" with the role "house" and where the street name is the relation tag "name". The polyline(s) of the street itself is(are) also member of this relation with the role "street" (see the wiki). So, once you find an OSM node or way with a tag "addr:housenumber", you can check if it is part of a relation "associatedStreet" and get the related street.

Statistically, the second method with a relation is much less popular than the first (less intuitive and newcomers are relunctant to edit/create relations) and is present only on some areas (like in France), this depends on how the method is popularized locally. So basically, if you find a housenumber without one of the two methods listed above, we generally consider this as incomplete in OSM. But sSome people still consider that the street can be linked by the distance between the OSM element and the nearest street (way tagged "highway") but there is a large consensus to consider this as too vague/imprecise and leading to errors especially near intersections- Geofabrik is providing a slippy map, OSM Inspector, showing if the address can be linked to a street and by which method here : http://tools.geofabrik.de/osmi/

What you should do first is download the OSM data (or some sample) into JOSM and look up how addresses are tagged in your area of interest.