NALENND™ NPA NXX to Zip Code Database

This comprehensive NPA NXX to ZIP Code database provides the solution to a common problem, where can I get a list of all ZIP Codes for an NPA NXX?

United States NPA NXX Telephone Area Codes and Exchanges to 5-digit ZIP Code cross reference. This comprehensive NPA NXX to ZIP Code database provides the solution to a common problem, where can I get a list of all ZIP Codes for an NPA NXX?

You can use this data for many purposes but the two most common uses are; finding all telephone exchanges in a particular ZIP Code and finding all ZIP Codes used in a particular telephone exchange.

NPA NXX to ZIP Code Record Layout

NPA NXX/ZIP Code master file		NPA NXX/ZIP Code data samples
Field Name	Data Type	Description
NPA	CHAR (3)	The 3-Digit area code.
NXX	CHAR (3)	The 3-digit exchange prefix.
ZIP	CHAR (5)	5-Digit United States ZIP Code.
STATE	CHAR (2)	Two character state abbreviation.
CITY	VARCHAR (128)	Name of city or locale identified by the 5-digit Zip code.
FIPSCOUNTY	CHAR (5)	5-digit code commonly referred to as the FIPS county code. The first two digits of this code are the unique 2-digit numeric code for a U.S. state as specified in Ansi INCITS 38:200x (formerly FIPS 5-2) followed by the 3-digit numeric code that uniquely identifies the county or equivalent division as specified in Ansi INCITS 31:200x (formerly FIPS 6-4)
FIPSPLACE	CHAR (5)	5-digit code commonly referred to as the FIPS Place Code. Formerly the FIPS 55 Place Code, this code is being replaced by the newer Ansi INCITS 446-2008 feature code but continues to be used to uniquely identify locations within the United States.
RC	CHAR (10)	10-character Rate Center abbreviated name identifying local service area where the NPA NXX is assigned.
MTA	NUMBER	The Major Trading Area the Rate Center is located in. MTAs are used by the FCC to defined coverage of spectrum licenses for certain services.