The NPA NXX Active Code List (NNACL) is composed of data files that help you maintain your internal operations, processes, and databases at peak efficiency with a complete listing of all active NPA NXX codes within the North American Numbering Plan area. Keep track of the ever changing world of these assignments through the NNACL. NNACL subscribers may also subscribe to the NPA NXX Activity Guide (NNAG) for monthly data modifications to supplement the quarterly NNACL.

This product is a useful resource for:

• Telemarketers, credit card companies, customer service groups, and others maintaining customer lists/databases
• PBX maintenance staff
• Database administrators 
• Any party needing to confirm if a given NPA NXX has been assigned

The NPA NXX Active Code List lists all NPA NXX assignments that are active (in service) as of the product date. Data provided includes the assigned service provider (OCN) of the NPA NXX, the type of service that is provided (e.g. wireless) by the assigned service provider, the associated Rate Center and State/Province/Country, and a Portability Indicator. Also included is a file that can be used to translate the Operating Company Number (OCN) to a company name. A user-friendly and dynamic “search” program to facilitate data selection and extraction is also provided with each issue of the product. A general information section explains the data in greater detail.

NPA NXXs in the United States are also often assigned at the Thousands-Block level (e.g. line numbers 0000- 0999, 1000-1999, etc.). Where such has occurred, the assigned service provider (OCN) of the block within the NPA NXX and all the data noted above at the NPA NXX level is provided.

As of this writing, approximately 205,000 NPA NXX records and over 850,000 blocks have been assigned and are included in the NNACL. The example provided at the end of this description is a depiction of results from the user interface provided with each copy of the NNACL. Results from queries generated through this interface can be downloaded to your local environment using various user-controlled options. Fixed-width ASCII files data feels are also included with each product should you which to directly use the data from such files in lieu of the user interface. This data can be locally imported into Excel, loaded into locally developed databases, and/or read with applications that can read text files (e.g. Notepad, Microsoft® Word). Reading and processing of the data is a local consideration, based on user needs, processing environment, etc.

Note that companies regulated in the United States by the Federal Communications Commission (FCC) and/or individual state regulatory commissions and, in Canada, by the Canadian Radio-television Telecommunications Commission (CRTC), for the most part, participate in telephone number portability (i.e. a subscriber assigned a phone number, under most circumstances, can have that number managed by any service provider that serves that area). However, the company assigned a numbering resource is the only company that can assign line numbers from that resource to new subscribers, but once subscribers are assigned a numbering resource, they can “port’ their numbers to another provider. At times, this may cross over type of service as well (e.g. wireline to wireless and the reverse) however; the NNACL does not contain individual line level data. However, it does contain the primary company for the numbering resource (the assigned OCN). Also, from a type of service standpoint (disregarding the service provider), a high percentage of line level data is within the type of service defined by the assigned service provider.

Download a sample NNACL

If there is need to reference or track changes that occur between quarterly issuances of the NNACL, the NPA NXX Activity Guide (NNAG), with records formatted the same as in the NNACL, provides (only) activity (i.e. adds/deletes, changes to data), and is issued monthly. An integration application to directly update the NNACL data with the NNAG data is not provided due to the wide range of user environments and uses of the data; such must be developed by the user if needed. Due to the vast diversity among user environments integration of the data into your local environment is your responsibility; however, TRA can assist your staff through explanation of the data, etc.