FccLicenseResources



LMR Application Activity RollUp for Public Safety and Private/Commerical Entities [ published weekly / Monday 13:00 ET ]

Download the Application activity roll-up for Public Safety and Private/Commercial LMR Entities a zipped MS-Access (2003) database [ ~22 MB Zipped / ~400 MB UnZipped ].

The Application Tracking Roll-Up database captures FCC license asset add, modify, and delete actions taken by new or existing licensees. It lets you know who is active in reconfiguring their system/network to accommodate new (or modify/remove existing) services and/or activities.

You can use Microsoft Access (2003+) or Excel (2007+) to use reference queries or write your own custom queries to:

  • Find all new frequency/location assets being added for a specific state
  • Find all new frequency/location assets being added by radio service code(s)
  • Find all new Nationwide/Statewide/Countywide frequency/location assets being added
  • Examine the deduced type of radio system a licensee is operating as well as their eligibility activity ( for what purpose they are using their radios )
  • Find stale application activity that can be used to deduce business prospects
  • Determine contact information ( name, address, phone, email ) for both the (L) licensee and (CL) licensee contact ( usually a licensing service entity )
  • Create your own custom queries by modifying the provided reference queries to mine information specific to your business
  • A nice on-line synopsis of weekly FCC application/license grant activity ( by state ), including frequency/location assets, is provided here.

    See also the FAQs for the Application Tracking Roll-Up database.



    LMR WhitePages for Public Safety and Private/Commerical Entities [ published monthly ]

    Download the WhitePages for Private, Public Safety and Private/Commercial LMR Entities a zipped MS-Access (2003) database [ ~130 MB Zipped / ~1.6 GB UnZipped ].

    This database provides information about an LMR licensee's call sign(s), operating emission mask(s), a guess about the type of system they are operating, where the licensee is located, their contact information, and much more...

    You can use Microsoft Access (2003+) or Excel (2007+) to write your own custom queries to find operating stations by:

  • License/call-sign grant or expire dates - find recent license grants or imminent license expirations
  • State, county, city, zipcode
  • Contact name, phone, fax, email
  • Part 90 eligibility rule and eligibility activity (what they will do with the radios)
  • RSC - Radio Service Code
  • Timezone
  • County latitude/longitude centroid
  • Type of system being operated by emissions code
  • MTA, BEA, EA, FIPS
  • Census population
  • Sample queries are provided that allow you to find licensees by State/County/City as well as which licenses are about to expire and which licenses have recently granted. You can modify these queries to suit your specific needs. Once you download the WhitePages database, you will be able to work (search, sort, filter, print) without an Internet connection using your local Microsoft Office tools.

    Should you desire to download the LMR WhitePages database and write your own custom queries ( as well as read the FAQs ) then download the Guidelines When Using the VisualLMR WhitePages (.pdf) to get step-by-step instructions.

    Three Important Notes:

  • It is likely that the licensee’s contact address is at a different location than that of their transmitter’s location(s) – possibly in a different state. The WhitePages does not enumerate a licensee's transmitter location/frequency information -- the dataset would be too large to publish as one downloadable image – which is a primary goal.
  • However, once you do use the LMR WhitePages to search and identify a population of call signs, you can then use the VisualCallSign tool to display details on transmitter frequencies, locations, ERPs, antenna heights, etc. for each of the call signs. And, when you enumerate the assets for a given call sign, you can then click through an asset to use the VisualSpectrumFinder that enumerates adjacent and co-channel entities in a given operating radius.
  • Normally, the WhitePages database is updated monthly. License assets without a deducible location state and/or location city are listed in both Public Safety as well as Private/Commercial white pages. The { l_lmcomm, l_lmpriv, l_micro, a_lease, and a_lease_608 } FCC ULS datasets are used to generate the WhitePages; (A) active and (E) expired licenses are considered, (T) terminated and (C) cancelled licenses are not.

    A nice on-line synopsis of weekly FCC license grant activity ( by state ), including frequency/location assets, is provided here.

    See the FCC ULS Database Images Updated timestamp at the bottom of all VisualLmr pages.



  • NarrowBandingTools

    ITCAP provides public tools for licensees that must consider narrowbanding requirements. The Narrowband License Status Tool and Narrowband Summary Tracker can be useful for vendors and radio-service shops to find narrowbanding prospects.

    These tools allow you to specify search criteria by State/County/City and visually display licensees that have/have-not meet the 2013.01.01 narrowbanding requirement. Moreover, they allow you to export an Excel workbook that very nicely summarizes the results of your search. This is one of the few online visual tools offered by the US Government for LMR. This is really nice work.

    The Narrowband License Status Tool (NLST) allows users to view VHF and UHF licensing data that is subject to the FCC Narrowbanding mandate. The data can be mapped as a Google Maps overlay with colored pushpins corresponding to how the transmitters are licensed. In addition, Microsoft Excel and Google Earth KMZ reports can be created to archive the information. The data used for this tool is updated weekly from the FCC's database -- ITCAP.

    ITCAP also has a search tool that will allow you to visually map licensed transmitters by radio service code, call sign, FRN, and/or tower structure; this tool is a nice piece of visual work.



    FCC ULS ( Universal Licensing System ) - How to Get the Data

  • The FCC Universal Licensing System (ULS) database
  • FCC Documentation on ULS Public Access databases
  • FCC ULS SQL Table Schemas
  • Scripts for downloading the FCC ULS database using the open source SqlLite database; Python codebase; must be adapted for LMCOMM/LMPRIV/et al.
  • Scripts for downloading the FCC ULS database using the open source MySql database; dated and must be adapted for LMCOMM/LMPRIV/et al.

  • FCC ULS License Search
  • FCC SUSS installing and running the software


  • 47 CFR [FCC] Rules

  • GPO e-CFR ( most current )
  • GPO CFRs by Year


  • Web Tools for LMR Engineers

  • RabbitEars TowerQuery - A nice piece of visual work. ( Looking for FCC registered tower structures ? )
  • Dailywireless.Org - Summary of tower/antenna location web tools. ( Looking for FCC registered tower structures ? )
  • Google Map "Quiet Zones" ( See if you will be operating near a radio telescope. )
  • FCC Vacated Channel Search Engine ( PS/CII entities looking at 854-860 MHz (Interleaved)? )
  • FCC Market Based License Search ( Need to consider/find Market/EA based licenses ? )
  • FCC Site/Market Based License Search ( Site-Specific/Market based licenses ? )
  • FCC Geographic Frequency Search ( Site-Specific, NationWide, Continental )
  • FCC Canadian Line A/C Border Region Checker ( Planning to operate near the Canadian border ? )
  • FCC TOWAIR Determination ( Planning to operate near an airport ? )
  • FCC HAAT Calculator
  • FCC Terminal Coordinate tool finds a final coordinate from DMSD/Azimuth/Distance.
  • FCC Distance Between tool finds the distance between to coordinates.
  • FCC Distance to CAN/MEX border tool finds the distance between a coordinate and border.
  • FCC Generic Tools


  • FCC Developer Web Services

    The "Rebooted" FCC has published a set of web services for developers. These tools appear to provide M2M access to license data and documents -- not geographic/geospatial tools that can assist a LMR engineer in spectrum planning.

    The blogs surrounding this work seem to suggest that it has incomplete functionality and the underlying datasets are stale. It looks like the FCC hired a few summer interns, that have since left, and the work is now dormant. It also appears that the FCC is not a participant in the developer blogs that they sponsor -- it does not appear that they reply to user posts that they publically solicit.

    Here is a real FCC gem for developers that are encouraged to try all this new web service API work:

    "Users seeking a record of a particular license are urged to utilize the Commission's official databases, such as the Universal Licensing System (ULS), International Bureau Filing System (IBFS), Experimental Licensing System (ELS) Cable Operations and Licensing System (COALS) and Consolidated Data Base System (CDBS), instead." -- http://www.fcc.gov/developers/license-view-api. -- Really?



    Map