Jump to main content.

EF AIRS/AFS Logo Query Form User's Guide

AIRS/AFS contains both emissions and compliance data on air pollution point sources regulated by the U.S. EPA and/or state and local air regulatory agencies. This information is used by states in preparation of State Implementation Plans (SIPs) to track the compliance status of point sources with various regulatory programs, and report emissions estimates for pollutants regulated under the Clean Air Act.

This is a brief user's guide to the AIRS/AFS Query Form. Use the form to select a variety of different query options and output options detailed below. Contact Us for additional queries or suggestions that you would find useful.

Select more than one query option at a time to speed up the query and make the retrieval more focused. Only those facilities matching all specified criteria will be retrieved.

Facility Identification Search Option

Facility Name

Enter the complete or partial facility name to retrieve all facilities with that name. Select the "Containing" option when entering a partial name for a better retrieval the first time you access the data. When an "Exact Match" option is specified for a facility name, do not specify another option; only one facility will be retrieved.

AFS Plant ID

Enter the complete or partial AFS Plant ID to retrieve all facilities with that ID. The AFS_PLANT_ID is only unique within a county. If you do not enter a county using the county name option from geography, you will have more than one facility with the same ID. Select the "Containing" option when entering a partial ID for a better retrieval the first time you access the data.

CDS Plant ID

Enter the complete or partial CDS Plant ID to retrieve all facilities with that ID. The CDS_PLANT_ID is only unique within a county. If you do not enter a county using the county name option from geography, you will have more than one facility with the same ID. Select the "Containing" option when entering a partial ID for a better retrieval the first time you access the data.

NEDS Plant ID

Enter the complete or partial NEDS Plant ID to retrieve all facilities with that ID. The NEDS_PLANT_ID is only unique within a county. If you do not enter a county using the county name option from geography, you will have more than one facility with the same ID. Select the "Containing" option when entering a partial ID for a better retrieval the first time you access the data.


Geography Search Option

Select from four geographical search options: ZIP Code, City, County, State, and EPA Region.

ZIP Code

The ZIP code entry can be five digits or fewer.

Address

Enter a complete or partial street address.

City

Enter a complete or partial city name.

County

Enter a complete or partial county name.

State

Enter a two-character state postal abbreviation. A list of the postal abbreviations and the state names is provided below:

AK = Alaska AL = Alabama AR = Arkansas
AS = American Samoa AZ = Arizona CA = California
CN = Canada CO = Colorado CT = Connecticut
DC = District of Columbia DE = Delaware FC = Other Foreign Countries
FL = Florida FM = Federated States of Micronesia GA = Georgia
GU = Guam HI = Hawaii IA = Iowa
ID = Idaho IL = Illinois IN = Indiana
IQ = Misc. U.S. Pacific Islands IT = All Indian Tribes KS = Kansas
KY = Kentucky LA = Louisiana MA = Massachusetts
MD = Maryland ME = Maine MH = Marshall Island
MI = Michigan MN = Minnesota MO = Missouri
MP = Northern Mariana Islands MQ = Midway Island MS = Mississippi
MT = Montana NC = North Carolina ND = North Dakota
NE = Nebraska NH = New Hampshire NJ = New Jersey
NM = New Mexico NV = Nevada NY = New York
OH = Ohio OK = Oklahoma OR = Oregon
PA = Pennsylvania PR = Puerto Rico PW = Palau, Republic of
RI = Rhode Island SC = South Carolina SD = South Dakota
TN = Tennessee TX = Texas UT = Utah
VA = Virginia VI = Virgin Islands VT = Vermont
WA = Washington WI = Wisconsin WQ = Wake Island
WV = West Virginia WY = Wyoming

Region

Enter the two digit numeric value for the EPA Region. A list of the EPA Regions and the states in those regions is provided below:

REGION STATES
Region 01 Maine, New Hampshire, Vermont, Massachusetts, Rhode Island, Connecticut
Region 02 New York, New Jersey, Puerto Rico, Virgin Islands
Region 03 Pennsylvania, Delaware, District of Columbia, Maryland, Virginia, West Virginia
Region 04 Kentucky, Tennessee, North Carolina, South Carolina, Mississippi, Alabama, Georgia, Florida
Region 05 Minnesota, Wisconsin, Illinois, Michigan, Indiana, Ohio
Region 06 New Mexico, Texas, Oklahoma, Arkansas, Louisiana
Region 07 Nebraska, Kansas, Iowa, Missouri
Region 08 Montana, North Dakota, Wyoming, South Dakota, Utah, Colorado
Region 09 California, Nevada, Arizona, Hawaii
Region 10 Washington, Oregon, Idaho, Alaska


Standard Industrial Code (SIC) Search Option

SIC Description

Enter a complete or partial SIC description to obtain a list of all SIC codes under that description. For example, entering "metal" will retrieve all facilities with SIC codes that have "metal" somewhere in the SIC description. Click on "Use AIRS SIC Code Values" to retrieve data from AIRS or "Use Facility Identification SIC Code Values" to retrieve data from the Facility Identification Tables.

SIC Code

The SIC Code entry can be four digits or fewer. If it is more than four digits, an error message will appear. The first two digits in the code define a major business sector, and the last two digits denote a facility's specialty within the major sector. Click on "Use AIRS SIC Code Values" to retrieve data from AIRS or "Use Facility Identification SIC Code Values" to retrieve data from the Facility Identification Tables.


Search Values Option

Click on "Use Multisystem facility information to perform facility search" to identify facilities, using facility information from all program systems. Click on "Use AIRS facility information to perform facility search" to identify facilities, using only AIRS facility information.


Pollutant Name Search Option

Pollutant Name

Enter a complete or partial pollutant (chemical) name. There can be various common names for the same chemical, so if the name you enter is not listed under that name for the facility, the AIRS query will not retrieve a facility that you might want to see.

Chemical Abstract Service (CAS) Number

Use the "Click Here" link to select a CAS Number, or enter the chemical's CAS Number in the field.


Output Selection List

The output, organized by facility, shows the facility information first in a label format, followed by a tabular listing of the additional information.

Default Output

The default output lists the following facility information:

Plant Emissions Inventory

The output, organized by facility, shows the facility information first in a label format, followed by a tabular listing of the additional information.

Facility Information:

Additional Tabular Output:


Usage Constraints

Information in the AIRS database can be freely accessed through the use of this query. The complexity of the query is up to the user. Queries that return a large volume of data may terminate prematurely due to system limitations. The constraints established for the enviro user account (the query uses this to connect to the Oracle database) are:

Develop queries that return small batches of data and terminate the session as soon as the queries have been executed, so that others can access the database.


Return to:

 

Local Navigation

Jump to main content.