**ULS Database Public Access Files**

The Universal Licensing System (ULS) public access files are available
for download. These files contain application data or license data, and
anyone can download them directly to their own computer. Data is
downloaded as a zipped file. Any of the popular \"zip\" utilities can be
used to unzip the file. Unzipping a downloaded file causes a number of
data files to be stored on your computer. Each zipped file contains a
set of data files named *xx*.dat where *xx* are 2 unique characters to
indicate the content of the specific data file.

***Zipped Files.*** The zipped file contains either complete application
data or license data for a specific radio service, and contains all the
licenses or applications that exist for that radio service
[or]{.underline} daily application data or license data that contains
only the previous day's transactions; i.e., those applications or
licenses that were brand new or modified "yesterday." The name of each
downloaded file identifies its content. The naming convention for
complete files is *c_sssss.*zip where *c* indicates the content ("L" for
licenses or "A" for applications), ss*sss* indicates the service (such
as "aircr" for aircraft). For example a_amat.zip contains a file having
all application data for the Amateur radio service. The naming
convention for daily files is *c_ss_ddd*.zip where *c* indicates the
content ("L" for licenses or "A" for applications), *ss* indicates the
service (such as "am" for amateur) and *ddd* is the day of the week. For
example, l_am_wed.zip contains new or changed amateur licenses from
Wednesday.

The ULS zipped public access files can be reached by going to the
"Downloads" section of the ULS home page. Under the "Downloads" section
are two hyperlinks -- "Databases" and "Daily Transaction Files". Click
on either link as appropriate. The complete files are created early
Sunday morning and the daily files are created early Tuesday through
Saturday mornings. The file created on Tuesday contains Monday data;
Wednesday contains Tuesday data and so on.

**NOTE:** A file size of 160 bytes indicates that there were no new or
modified applications or licenses for that radio service for that day.

***Data Files.*** The dat files produced by unzipping a downloaded file
will vary depending on which radio service data you selected and whether
you are downloading applications or licenses. Each data file contains a
specific type of data (e.g., names and addresses, location data) and the
data is pipe-separated. Each record type starts with the same unique
2-character record type code that identifies the table from which the
data was extracted. The last data field is not followed by a \"\|\".

Each data file has a name of the form *xx*.DAT*,* where *xx* indicates
which table the data came from. In fact, each data file has the same
name as its corresponding table; for example, file FR.dat contains the
data from table PUBACC_FR. Look for the FR tab in the excel spreadsheet
that is available on the Public Access web page.

***Definition Files.*** Three files containing definitions are available
for downloading:

-   pa_ddef*nn*.xls is an Excel file containing definitions of the data
    fields in the database tables where *nn* is a number that increases
    as the file is updated.

-   pa_ddef*nn*.sql contains the SQL for the table definitions where
    *nn* is a number that increases as the file is updated.

-   pa_codes*n*.doc contains meanings of codes for the code data
    elements in the tables where *n* is a number that increases as the
    file is updated.

    **Available Services**

    Public access files are created for all of the radio services that
    are contained in ULS. As additional services are added to ULS,
    public access files will be made available for those as well. The
    file pa_ddef*nn*.sql has all the SQL table definitions for Amateur,
    Aircraft, GMRS, FRC, Ship, Paging, Cellular, Coast & Ground, Land
    Mobile, BRS/EBS, Microwave and Market-based applications and
    licenses. In addition, since transfers of control or assignments can
    cross multiple radio services, a separate file is created which
    contains these applications. Once these applications are
    consummated, each of the licenses will be updated appropriately. The
    next day, those licenses will be contained in the appropriate
    service's daily zip file.

# Data Files

Each data file has the same name as the table the data was extracted
from; for example, hd.dat contains the data from table PUBACC_HD.
Following are tables that summarize the available data tables associated
with the following services:

-   Table 1 summarizes the tables for the Aircraft, GMRS, Amateur, Ship
    and FRC services that are filed for using FCC Form 605.

-   Table 2 summarizes the tables for the Market-based, Paging,
    Cellular, Coast & Ground, Land Mobile, Microwave and BRS/EBS
    services.

    Paging, Cellular, Coast & Ground, Land Mobile, Microwave and BRS/EBS
    services are referred to as site-based to distinguish them from
    market-based services. Applications related to these services are
    filed using FCC Form 601.

-   Table 3 summarizes the tables for Assignments and Transfers and
    Spectrum Leasing, FCC Form 603.

-   Table 4 summarizes the radio services included in each public access
    download file.

Note that these tables show the hierarchy of the data tables for each
service, and which data tables are required (R) or optional (O) for the
applications and licenses within a service.

**Table 1. Public Access Tables for the Aircraft, GMRS, Amateur, Ship
and FRC Services**

  --------------------------------------------------------------------------------------------------------------------------------------------------------------------
  **Tables**                      **Table Contents**    **Aircraft**             **GMRS**             **Amateur**             **Ship**             **FRC**   
  --------------- ---- ---- -- -- --------------------- -------------- --------- ---------- --------- ------------- --------- ---------- --------- --------- ---------
  **Hierarchy**                                         **App**        **Lic**   **App**    **Lic**   **App**       **Lic**   **App**    **Lic**   **App**   **Lic**

  HD                              Main Form 605 data    R              R         R          R         R             R         R          R         R         R
                                  that carries over to                                                                                                       
                                  the license                                                                                                                

                  AD              Main Form 605 data    R                        R                    R                       R                    R         
                                  that does not carry                                                                                                        
                                  over to the license                                                                                                        

                  RE              Application return or O                        O                    O                       O                    O         
                                  dismissal reasons                                                                                                          

                  EN              Names and addresses   R              R         R          R         R             R         R          R         R         R

                  IA              International                                                                                                    O         O
                                  Addresses                                                                                                                  

                  CO              FCC Comments          O              O         O          O         O             O         O          O         O         O

                  HS              Application/License   R              R         R          R         R             R         R          R         R         R
                                  History                                                                                                                    

                  SC              License Level Canned                 O                    O                       O                    O                   O
                                  Special Conditions                                                                                                         

                  SF              License Level Free                   O                    O                       O                    O                   O
                                  Form Special                                                                                                               
                                  Conditions                                                                                                                 

                  AC              Aircraft data         R              R                                                                                     

                  AM              Amateur data                                                        R             R                                        

                       VC         Requested vanity call                                               O                                                      
                                  sign                                                                                                                       

                  SH              Ship data                                                                                   R          R                   

                       SE         Ship Exemption                                                                              O          O                   

                       SV         Ship Voyage                                                                                 O          O                   

                  FA              FRC data                                                                                                         R         R

                  AT              Attachment            O                        O                    O                       O                    O         
                                  information                                                                                                                

                  LA              License Attachment                   O                    O                       O                    O                   O
                                  information                                                                                                                
  --------------------------------------------------------------------------------------------------------------------------------------------------------------------

**Table 2. Public Access Tables for the Market-based and Site-based
Services**

  ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  **Tables**                          **Table          **Market-based**             **Paging**             **Cellular**             **Micro\             **Land\              **Coast &            **BRS/EBS**   
                                      Contents**                                                                                    wave**               Mobile**             Ground**                           
  --------------- ---- ---- ---- ---- ---------------- ------------------ --------- ------------ --------- -------------- --------- ---------- --------- ---------- --------- ---------- --------- ------------- ---------
  **Hierarchy**                                        **App**            **Lic**   **App**      **Lic**   **App**        **Lic**   **App**    **Lic**   **App**    **Lic**   **App**    **Lic**   **App**       **Lic**

  HD                                  Main Form 601    R                  R         R            R         R              R         R          R         R          R         R          R         R             R
                                      data that                                                                                                                                                                  
                                      carries over to                                                                                                                                                            
                                      license                                                                                                                                                                    

                  AD                  Main Form 601    R                            R                      R                        R                    R                    R                    R             
                                      data that does                                                                                                                                                             
                                      not carry over                                                                                                                                                             
                                      to license                                                                                                                                                                 

                  A2                  Additional                                                                                    R                                                              R             
                                      Application data                                                                                                                                                           
                                      that does not                                                                                                                                                              
                                      carry over to                                                                                                                                                              
                                      the license                                                                                                                                                                

                  RE                  Application      O                            O                      O                        O                    O                    O                    O             
                                      return or                                                                                                                                                                  
                                      dismissal                                                                                                                                                                  
                                      reasons                                                                                                                                                                    

                  EN                  Names and        R                  R         R            R         R              R         R          R         R          R         R          R         R             R
                                      addresses                                                                                                                                                                  

                  CO                  FCC Comments     O                  O         O            O         O              O         O          O         O          O         O          O         O             O

                  HS                  Application and  R                  R         R            R         R              R         R          R         R          R         R          R         R             R
                                      License history                                                                                                                                                            

                  IR                  IRAC status                                                                         O         O          O                    O                    O                       O

                  CS                  COSER status                                                                        O         O          O                    O                    O                       O

                  LM                  Land Mobile                                                                                                        O          R                                            
                                      administrative                                                                                                                                                             
                                      data                                                                                                                                                                       

                  MW                  Microwave                                                                                     O          R                                                                 
                                      administrative                                                                                                                                                             
                                      data                                                                                                                                                                       

                  MI                  BRS/EBS                                                                                                                                                      O             R
                                      administrative                                                                                                                                                             
                                      data                                                                                                                                                                       

                  CG                  Coast & Ground                                                                                                                          O          R                       
                                      administrative                                                                                                                                                             
                                      data                                                                                                                                                                       

                  BC                  Broadcast Call                                                                                O          O         O          O                              O             O
                                      Signs                                                                                                                                                                      

                  AS                  Associated Call                                                                                                    O          O                              O             O
                                      Signs                                                                                                                                                                      

                  FC                  Frequency                                                                                     O                    O                    O                                  
                                      Coordination                                                                                                                                                               

                  SC                  License Level                       O                      O                        O         O          O                    O                    O                       O
                                      Canned Special                                                                                                                                                             
                                      Conditions                                                                                                                                                                 

                  SF                  License Level                       O                      O                        O         O          O                    O                    O                       O
                                      Free Form                                                                                                                                                                  
                                      Special                                                                                                                                                                    
                                      Conditions                                                                                                                                                                 

                  BO                  License build                       R                                               R                                                                                      
                                      out data                                                                                                                                                                   

                  UA                  Unreserved Area                                                      O              O                                                                                      

                  CP                  Control point                                 O            O         O              O         O          O         O          O         O          O         O             O
                                      data                                                                                                                                                                       

                  SI                  SID number                                                           O              O                                                                                      

                  MK                  Market data      R                  R                                O              O                                                                                      

                  TL                  Tribal Lands     O                  O                                                                                                                                      
                                      data                                                                                                                                                                       

                  AG                  Agreement        O                                                                                                                                                         

                  AP                  Agreement Party  O                                                                                                                                                         

                       MP             P&D market data  O                  O                                                                                                                                      

                            MF        Disaggregated    O                  O                                                                                                                                      
                                      frequency data                                                                                                                                                             

                            MC        Partition        O                  O                                                                                                                                      
                                      coordinates                                                                                                                                                                

                  LO                  Location data    O                  O         O            R         O              R         O          R         O          R         O          R         O             R

                       L2             Additional                                                                                    O          O         O          O                              O             O
                                      Location data                                                                                                                                                              

                       OP             Area of                                                                                                            O          O         O          O         O             O
                                      operation text                                                                                                                                                             

                                                                                                                                                                                                                 

                       LS             Location Level                                             O                        O         O          O                    O                    O                       O
                                      Canned Special                                                                                                                                                             
                                      Conditions                                                                                                                                                                 

                       LF             Location Level                                             O                        O         O          O                    O                    O                       O
                                      Free Form                                                                                                                                                                  
                                      Special                                                                                                                                                                    
                                      Conditions                                                                                                                                                                 

                       BL             Location build                                                                      R                                                                                      
                                      out data                                                                                                                                                                   

                       AN             Antenna data                                  O            R         O              R         O          R         O          R         O          R         O             R

                            RC        Receiver data                                                                                 O          O                                                                 

                            RZ        Receive Zone                                                                                                                                                 O             O
                                      data                                                                                                                                                                       

                            FR        Frequency data                      R         O            R         O              R         O          R         O          R         O          R         O             R

                            F2        Additional                                                                                    O          O                                                   O             R
                                      frequency data                                                                                                                                                             

                            FT        Frequency Type                                                                                                                                               O             O

                                 FS   Frequency Level                                            O                        O         O          O                    O                    O                       O
                                      Canned Special                                                                                                                                                             
                                      Conditions                                                                                                                                                                 

                                 FF   Frequency Level                                            O                        O         O          O                    O                    O                       O
                                      Free Form                                                                                                                                                                  
                                      Special                                                                                                                                                                    
                                      Conditions                                                                                                                                                                 

                                 BF   Frequency build                                            R                                             R                    R                    R                       R
                                      out data                                                                                                                                                                   

                                 RA   Radial data                                   O            O         O              R                                                                                      

                                 EM   Emission data                                 O            O         O              O         O          R         O          R         O          R         O             R

                                 PC   Points of Com                                                        O              O                                                                                      
                                      data                                                                                                                                                                       

                  PA                  Paths                                                                                         O          R                                                                 

                       SG             Segments                                                                                      O          R                                                                 

                  AT                  Attachment       O                            O                      O                        O                    O                    O                    O             
                                      information                                                                                                                                                                

                  LA                  License                             O                      O                        O                    O                    O                    O                       O
                                      Attachment Info                                                                                                                                                            

                  BE                  BRS/EBS Specific                                                                                                                                             R             
                                      Questions                                                                                                                                                                  

                  ME                  MEA Number                                                                                                                                                   R             

                  MH                  Channel Plan                                                                                                                                                 R             
                                      Information                                                                                                                                                                
  ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

**Table 3. Public Access Tables for Assignment and Transfer and Spectrum
Lease Applications**

  ------------------------------------------------------------------------------------------
  **Tables**                              **Table Contents**           **AA/TC**   **LL**
  --------------- ---- ----- ---- ---- -- ---------------------------- ----------- ---------
  **Hierarchy**                                                        **App**     **App**

                  HD                      Main Form 603 data that      R           R
                                          carries over to the license              

                       AD                 Main Form 603 data that does R           R
                                          not carry over to license                

                       A2                 Additional Application                   O
                                          Detail                                   

                       RE                 Application return or        O           O
                                          dismissal reasons                        

                       CF                 Multiple call signs or file  O           O
                                          numbers affected by this                 
                                          application                              

                       EN                 Names and addresses for      R           R
                                          licensees, contacts,                     
                                          transferees, assignees,                  
                                          transferors, assignors,                  
                                          owners                                   

                       CO                 FCC comments                 O           O

                       HS                 Application and License      R           R
                                          history                                  

                       TA                 Transfer/Assignment data     R           

                       BD                 Designated Entity            R           

                       MK                 Market data                  O           

                             MP           Partition market data        O           

                                  MF      Disaggregated frequency data O           

                                  MC      Partition coordinates        O           

                       AT                 Attachment information       O           O
  ------------------------------------------------------------------------------------------

Since data can differ from service to service, you will find that
particular columns in certain tables will always be null for some
services but contain data for other services.

**Table 4. Radio Services Included in Download Files**

  ---------------------------------------------------------------------------
  **Download File**        **Radio     **Radio Service Description**
                           Service**   
  ------------------------ ----------- --------------------------------------
  **Aircraft - 47 CFR Part             
  87**                                 

                           AC          Aircraft

                                       

                                       

  **Amateur Radio                      
  Service**                            

                           HA          Amateur

                           HV          Vanity

                                       

                                       

  **Antenna Structure                  
  Registration**                       

                           N/A         

                                       

                                       

  **Airport Facilities --              
  47 CFR Part 17**                     

                           N/A         

                                       

                                       

  **Assignments and                    
  Transfers**                          

                           AL          All

                                       

                                       

  **BRS & EBS (Formerly                
  known as MDS/ITFS)**                 

                           BR          Multipoint Distribution Service (MDS
                                       and MMDS)

                           ED          Instructional Television Fixed Service

                                       

                                       

  **Cellular -- 47 CFR                 
  Part 22**                            

                           CL          Cellular

                                       

                                       

  **Comm. Radio and                    
  Restricted                           
  Radiotelephone - FRC**               

                           CM          Commercial Operator

                           RR          Restricted Operator

                                       

                                       

  **General Mobile Radio               
  Service (GMRS)**                     

                           ZA          General Mobile Radio (GMRS)

                                       

                                       

  **Land Mobile -                      
  Private**                            

                           GB          Business, 806-821/851-866 MHz,
                                       Conventional

                           GE          Public Safety/Special Emergency and
                                       Public Safety, National

                           GF          Public Safety Ntl Plan,
                                       821-824/866-869 MHz, Conv.

                           GI          Other Indust/Land Transp,
                                       896-901/935-940 MHz, Conv.

                           GJ          Business and Industrial/Land
                                       Transportation (809 - 824 and 8

                           GO          Other Indust/Land Transp,
                                       806-821/851-866 MHz, Conv.

                           GP          Public Safety/Spec Emerg,
                                       806-821/851-866 MHz, Conv.

                           GU          Business, 896-901/935-940 MHz,
                                       Conventional

                           IG          Industrial/Business Pool, Conventional

                           IQ          DSRC / Intelligent Transportation
                                       Service

                           LP          Broadcast Auxiliary Low Power

                           LV          Low Power Wireless Assist Video
                                       Devices

                           PA          Public Safety 4940-4990 MHz Band

                           PW          Public Safety Pool, Conventional

                           QM          Non-Nationwide Public Safety/Mutual
                                       Aid, 220 MHz

                           RP          Broadcast Auxiliary Remote Pickup

                           RS          Land Mobile Radiolocation

                           SL          Public Safety 700 MHZ Band-State
                                       License

                           YB          Business, 806-821/851-866 MHz, Trunked

                           YE          Public Safety/Special Emergency and
                                       Public Safety, National

                           YF          Public Safety Ntl Plan,
                                       821-824/866-869 MHz, Trunked

                           YG          Industrial/Business Pool, Trunked

                           YI          Other Indust/Land Transp.
                                       896-901/935-940 MHz, Trunked

                           YJ          Business and Industrial/Land
                                       Transportation (809 - 824 and 8

                           YO          Other Indust/Land Transp.
                                       806-821/851-866 MHz, Trunked

                           YP          Public Safety/Spec Emerg,
                                       806-821/851-866 MHz, Trunked

                           YU          Business, 896-901/935-940 MHz, Trunked

                           YW          Public Safety Pool, Trunked

                           GB          Business, 806-821/851-866 MHz,
                                       Conventional

                           GE          Public Safety/Special Emergency and
                                       Public Safety, National

                           GF          Public Safety Ntl Plan,
                                       821-824/866-869 MHz, Conv.

                           GI          Other Indust/Land Transp,
                                       896-901/935-940 MHz, Conv.

                           GJ          Business and Industrial/Land
                                       Transportation (809 - 824 and 8

                           GO          Other Indust/Land Transp,
                                       806-821/851-866 MHz, Conv.

                           GP          Public Safety/Spec Emerg,
                                       806-821/851-866 MHz, Conv.

                           GU          Business, 896-901/935-940 MHz,
                                       Conventional

                           IG          Industrial/Business Pool, Conventional

                           IQ          DSRC / Intelligent Transportation
                                       Service

                           LV          Low Power Wireless Assist Video
                                       Devices

                           PA          Public Safety 4940-4990 MHz Band

                           PW          Public Safety Pool, Conventional

                           QM          Non-Nationwide Public Safety/Mutual
                                       Aid, 220 MHz

                           RS          Land Mobile Radiolocation

                           SL          Public Safety 700 MHZ Band-State
                                       License

                           YB          Business, 806-821/851-866 MHz, Trunked

                           YE          Public Safety/Special Emergency and
                                       Public Safety, National

                           YF          Public Safety Ntl Plan,
                                       821-824/866-869 MHz, Trunked

                           YG          Industrial/Business Pool, Trunked

                           YI          Other Indust/Land Transp.
                                       896-901/935-940 MHz, Trunked

                           YJ          Business and Industrial/Land
                                       Transportation (809 - 824 and 8

                           YO          Other Indust/Land Transp.
                                       806-821/851-866 MHz, Trunked

                           YP          Public Safety/Spec Emerg,
                                       806-821/851-866 MHz, Trunked

                           YU          Business, 896-901/935-940 MHz, Trunked

                           YW          Public Safety Pool, Trunked

                                       

                                       

  **Land Mobile -                      
  Commercial**                         

                           GL          900 MHz Conventional SMR (SMR,
                                       Site-Specific)

                           GM          800 MHz Conventional SMR (SMR,
                                       Site-specific)

                           GR          SMR, 896-901/935-940 MHz, Conventional

                           GS          Private Carrier Paging, 929-930 MHz

                           GX          SMR, 806-821/851-866 MHz, Conventional

                           IK          Industrial/Business Pool - Commercial,
                                       Conventional

                           LN          902-928 MHz Location Narrowband
                                       (Non-multilateration)

                           LW          902-928 MHz Location Wideband
                                       (Grandfathered AVM)

                           NC          Nationwide Commercial 5 Channel, 220
                                       MHz

                           QD          Non-Nationwide Data, 220 MHz

                           QO          Non-Nationwide Other, 220 MHz

                           QT          Non-Nationwide 5 Channel Trunked, 220
                                       MHz

                           YK          Industrial/Business Pool - Commercial,
                                       Trunked

                           YL          900 MHz Trunked SMR (SMR,
                                       Site-Specific)

                           YM          800 MHz Trunked SMR (SMR,
                                       Site-specific)

                           YS          SMR, 896-901/935-940 MHz, Trunked

                           YX          SMR, 806-821/851-866 MHz, Trunked

                                       

                                       

  **Land Mobile -                      
  Broadcast Auxiliary**                

                           LP          Broadcast Auxiliary Low Power

                           RP          Broadcast Auxiliary Remote Pickup

                                       

                                       

  **Maritime Coast &                   
  Aviation Ground**                    

                           AA          Aviation Auxiliary Group

                           AF          Aeronautical and Fixed

                           AR          Aviation Radionavigation

                           MA          Marine Auxiliary Group

                           MC          Coastal Group

                           MK          Alaska Group

                           MR          Marine Radiolocation Land

                                       

                                       

  **Market Based                       
  Services**                           

                           BC          1670-1675 MHz Band, Market Area

                           CN          PCS Narrowband

                           CP          Part 22 VHF/UHF Paging (excluding
                                       931MHz)

                           CW          PCS Broadband

                           CX          Cellular, Auctioned

                           CY          1910-1915/1990-1995 MHz Bands, Market
                                       Area

                           CZ          Part 22 931 MHZ Paging

                           DV          Multichannel Video Distribution AND
                                       Data Service

                           GC          929-931 MHz Band, Auctioned

                           GW          General Wireless Communications
                                       Service

                           LD          Local Multipoint Distribution Service

                           LS          Location and Monitoring Service,
                                       Multilateration (LMS)

                           MS          Multiple Address Service, Auctioned

                           PC          Public Coast Stations, Auctioned

                           QA          220-222 MHz Band, Auctioned

                           TN          39 Ghz, Auctioned

                           TZ          24 GHz Service

                           WS          Wireless Communications Service

                           WX          700 MHz Guard Band

                           WZ          700 MHz Lower Band

                           YC          SMR, 806-821/851-866 MHz, Auctioned

                           YD          SMR, 896-901/935-940 MHz, Auctioned

                           YH          SMR, 806-821/851-866 MHz, Auctioned
                                       (Rebanded YC license)

                           ZV          218-219 MHz Service

                                       

                                       

  **Microwave - 47 CFR                 
  Part 74 and 101**                    

                           AB          Aural Microwave Booster

                           AI          Aural Intercity Relay

                           AS          Aural Studio Transmitter Link

                           CE          Digital Electronic Message Service -
                                       Common Carrier

                           CF          Common Carrier Fixed Point to Point
                                       Microwave

                           CT          Local Television Transmission

                           MG          Microwave Industrial/Business Pool

                           MM          Millimeter Wave 70/80/90 GHz Service

                           MW          Microwave Public Safety Pool

                           PE          Digital Electronic Message Service -
                                       Private

                           TB          TV Microwave Booster

                           TI          TV Intercity Relay

                           TP          TV Pickup

                           TS          TV Studio Transmitter Link

                           TT          TV Translator Relay

                           WA          Microwave Aviation

                           WM          Microwave Marine

                           WR          Microwave Radiolocation

                                       

                                       

  **Ownership**                        

                           N/A         

                                       

                                       

  **Paging - 47 CFR Part               
  22**                                 

                           CA          Commercial Air-ground Radiotelephone

                           CB          BETRS

                           CD          Paging and Radiotelephone

                           CG          General Aviation Air-ground
                                       Radiotelephone

                           CO          Offshore Radiotelephone

                           CR          Rural Radiotelephone

                                       

                                       

  **Ship - 47 CFR Part                 
  80**                                 

                           SA          Ship Recreational or Voluntarily
                                       Equipped

                           SB          Ship Compulsory Equipped

                           SE          Ship Exemption

                                       

                                       

  **Spectrum Leasing**                 

                           AL          All
  ---------------------------------------------------------------------------

**Using the Data**

Data can be joined whenever the column name is the same in both tables.
The primary column for joining license data is the call sign. The
primary column for joining application data is ULS file number. In
addition to the call sign or ULS file number, each application and
license has been assigned a unique, 9-digit system identifier. This
system identifier is useful in cases where a call sign has been
reassigned, insofar as it allows you to differentiate between the active
call sign and the call sign that has expired or been cancelled or
terminated. (This situation occurs commonly with Amateur vanity
licenses.)

License data for site-based services can be joined by the following
combination of columns:

call_sign

call_sign and location_number

call_sign, location_number and antenna_number

call_sign, location_number, antenna_number and frequency_number

call_sign, path number, location_number and antenna_number

call_sign, path_number and segment_number

License data for market-based services can be joined by the following
combination of columns:

call_sign and market code

call_sign, market_code and market_partition_code

call_sign, market_code, market_partition_code and
undefined_partitioned_area

call_sign, market_code, market_partition_code and defined_partition_code

The unique system identifier can be used in place of the call_sign or in
conjunction with it.

Application data can be joined using the columns above with
uls_file_number replacing call_sign. The unique system identifier can be
used in place of the uls_file_number or in conjunction with it.