Extract zipcode , latitude and longitude information from a PBF file

My project requirement :
I have a project requirement where I need to create a database for the country of the United States of America containing the following columns:
Zip code
Latitude(of zip code)
Longitude(of zip code)
Zip code 1 ( which is at a distance of 10 miles from zip code)
Zip code 2 (which is at a distance of 25 miles from zip code)
Zip code 3 (which is at a distance of 50 miles from zip code)

My approach :
1.Download the OSM file (in PBF format ) for the country of united states of America
2.Convert the PBF file into a format which contains the zip code, latitude, and longitude information of USA.
3.Extract the information into the database

My Research
I tried using the site https://mygeodata.cloud/converter/osm-to-xlsx to convert pbf file into excel file. However, it had size limitations and I could not use it for free. I also searched the internet for various other formats in which the PBF file could be converted. I haven’t got any such file format.

My Question :
I have downloaded the OSM(PBF) file for the entire country of the United States of America from http://download.geofabrik.de

Does these files contain the following information :
All zip codes in the USA
Latitude
Longitude

In which format can I convert the PBF file so that I can get the above information? Can I get a converter for free which allows the conversion so that I can extract all the relevant information for my database?

Any help will be appreciated

Can you explain what the latitude of a zip code would be? My understanding is that a zip code is described by a closed ring, not by a single position.
Do you want to be able to retrieve the zip code for a given lat/lon pair or do want to draw the zip code area?

OSM really isn’t the right tool for this. There are several zip code databases on the internet which you will find much, much easier to use. Downloading OSM for the US to get zip codes is a bit like memorising the entire Bible to get a recipe for unleavened bread.

Cross-posted here

ZIP codes are not described by an area. They’re an attribute assigned to each specific address by the US Postal Service. If you plot the locations of a single ZIP code on a map, it’s often a very messy distribution and not something that could be easily described by a polygon. This site gives a bit of information about the problems with trying to group ZIP codes into polygons, including overlap, inconsistency, and a lack of contiguousness.

Hello! How can I find out United States zip codes? Is everything ok with this https://worldpostalcode.com/united-states/ site? This is the first time I registered on the Amazon website and I need a zip code to deliver the parcel. And since I live alone, I have no one to ask. Moreover, it is different from my old one from the UK. I hope you will help me, so where can I find it?

Go to https://tools.usps.com/zip-code-lookup.htm?byaddress and enter your address. You can leave the zip code field and other fields like business name, apartment number, etc. blank.