|
This web page describes how to get list of the public that holds Amateur Radio or GMRS licenses from the FCC website for a specific city and/or state. Once the list is obtained as a file from the FCC download site, the call sign, name and address information can be extracted to an Excel CSV (Comma Separated Value) file for viewing in Excel.
How to Get Licensee Data from the FCC
Read the instructions and enter your E-Mail address and then click on the Download button. In a few minutes, you will get an E-Mail acknowledging your query and then slightly later, an e-mail with a URL link which will bring up a screen as a text file that you can save to your PC. Note, When you click on the URL with the download listing, there is a period at the end which will likely result in an error message in getting the URL page. Delete that period and try again. When you get the download listing, go to file and select "Save As" on your browser file line and save it to your hard drive. For the Amateur licenses, there are usually 5 or more formats that are listed in the download. The one with the EN as the first 2 characters of the line is the format that contains the names and addresses. There is a field for E-Mail but it is blank, I suspect to keep spammers from using it. There is a Perl script that will filter out all but the EN records and yield a CSV file that can be brought into Excel. You can then sort any way you want. The file you get from the FCC is almost sorted by call sign, but not totally. The Perl script has been converted to an executable. Below is a link to a ZIP file that contains the original Perl script (filter-fcc.pl), the executable (filter-fcc-exe) and a readme file (AAAreadme.txt) that contains these instructions. Click here for ZIP file - 326 KB Zip File The output file from the Perl script has the following comma delimited format: CALL SIGN, "NAME: LAST,FIRST", NAME: FIRST LAST, FIRST, MI, LAST, SUFFIX, STREET, CITY, STATE, ZIP, PO BOX. The data has been edited so that names and addresses appear in lower case with the first character upcased. The PO BOX field does not appear to be used for that.
How to Use the Filter Program filter-fcc.exeThe executable, filter-fcc.exe, was generated from file filter-fcc.pl, which is a Perl script that reads a file that has been downloaded from the FCC license search page.Copy file filter-fcc.exe to the directory where you have placed the file that you have extraced from the FCC web site. This just makes it easier to use. The best way to use the executable is to open a command line window (go to Start->run...-> and enter cmd in the field next to Open: and then click on OK). CD to the directory where you have placed the executable and the downloaded FCC file. The format for using this executable file is the following string typed at the command line prompt: prompt:\> filter-fcc <optional input file name> <optional output file name> Note, do NOT include the < and > characters around the file name. If you do not put the file names on the command line, the program will ask for them. If you make the output file name file type, csv, as in fcc-out.csv, it will automatically be recognized as an Excel file when you either double click on it or open Excel and read it in that way. After you input the output file name, the program will echo the file names you entered. If there are records in the input file that have NO street address, those records will be indicated in the command line window by printing the call sign and name of the person. This is just for your reference if you are going to use this as a mailing list. The output csv file will be written to the same directory as the input file unless you have included an optional path in the file name. Note, an output file name with the same name as the input file name is not allowed. If the output file name were the same as the input file, the output file would delete the input file, and you may want to use that for some other purpose.
If you have any questions or problems, please contact me:
|