Air Emissions

How to Download Your Data

1. Go to https://www.epa.gov/enviro/tri-ez-search.
2. Scroll down and click on “Flat (Denormalized) Form R – A flat view of the TRI database that contains a majority of the available TRI information.
3. Select the following variables from the list of data elements provided.
   1. Reporting Year
   2. b. In the row immediately below Air Total Release check the box above SUM
   3. Primary NAICS Code
4. Scroll to the bottom of the page and click on “STEP 3: Enter Search Criteria”
5. On the next page:
   1. For Reporting Year – switch Operator Definition to “Between.” In the Search Value field, enter the first year shown in the Sector Snapshots chart, followed by “AND”, and the last year shown in the Sector Snapshots chart. For example, if the first year is 1996 and the last year is 2022, enter “1996 AND 2022” in the Search Value field.
   2. For Primary NAICS Code – switch Operator to “Beginning with,” and enter 3364 (Aerospace Product and Parts Manufacturing) under Search Value. Then check the last box to the right under “Where Only.”
   3. Click on “Search database” or “Output to CSV File”

Criteria Air Pollutants

How to Download Your Data

Note: The data are available in a tab or comma-delimited text format that must be imported into a program that will allow you to analyze the file (such as Excel).

1. Go to: Get Air Emissions Data | US EPA which has a table with yearly data tables. Download the data years desired.
2. In the “Table of Air Emissions Data by Year and Time”, select the relevant NEI file under the Triennial NEI column for years within the range of the Snapshot Sectors Graphic.
3. For 1996 – 2005, select the file with “naics” or “sics” in the file name. For example, for 2000, use the “2000sicsummarymade09” file, but for 2005, use the “naics_summary.zip” file.
4. For 2008 and onwards, click the “Data Summaries” hyperlink, then download the “Facility-level by Pollutant” File.
5. Aerospace manufacturing facilities are grouped under SIC codes 3711, 3713, 3714, 3715, 3716, 3724, 3728, 3761, 3764, and 3769 for the years 1996 and 1999 and NAICS codes beginning with 3364 from 2002 onwards.
6. Using the SIC and NAICS variables, filter for paper products facilities, then sum total emissions of CO, NOX, VOC, PM10, NH3, and SO2 in each year to arrive at the totals shown in this chart.

Greenhouse Gases

How to Download Your Data

1. Go to https://www.epa.gov/ghgreporting/ghg-reporting-program-data-sets
2. Click the “Data Summary Spreadsheets” link. In the resulting ZIP file, open the spreadsheet, “ghgp_data_by_year.xlsx.” Navigate to the first worksheet, “Direct Emitters.”
3. Apply a filter to Column K (Primary NAICS Code), displaying only the values for NAICS Codes beginning with 3364.
4. With the filter from Step 3 applied, for each year, 2011 onwards, sum the relevant column of “Total reported direct emissions.” For example, Column U corresponds to 2011, Column T corresponds to 2012, etc.
5. For 2010 data, open the spreadsheet, “ghgp_data_2010” from the ZIP file. Repeat Steps 3 and 4 in this file.

Hazardous Waste Generation

How to Download Your Data

1. Go to https://rcrainfo.epa.gov/rcrainfoweb/action/modules/br/naics/view
2. Repeat the following steps for each reporting cycle. You will be able to access data for one year and one NAICS code at a time. For each reporting cycle, the output for NAICS 3364 is equal to the value shown in this chart.
   1. NAICS code: 3364 AEROSPACE PRODUCT AND PARTS MANUFACTURING
   2. Reporting cycles: Select each year individually that is presented on the Sector Snapshots graphic.
   3. You do not need to change the “Generators to Include” dropdown or the “Location” dropdown before hitting submit.

Production-Related Waste Managed

How to Download Your Data

1. Go to https://www.epa.gov/enviro/tri-ez-search.
2. Scroll down and click on “Flat (Denormalized) Form R – A flat view of the TRI database that contains a majority of the available TRI information.
3. Select the following variables from the list of data elements provided.
   1. Reporting Year
   2. In the row immediately below Total Production Related Waste check the box above SUM
   3. Primary NAICS Code
4. Scroll to the bottom of the page and click on “STEP 3: Enter Search Criteria”
5. On the next page:
   1. For Reporting Year – switch Operator Definition to “Between.” In the Search Value field, enter the first year shown in the Sector Snapshots chart, followed by “AND”, and the last year shown in the Sector Snapshots chart. For example, if the first year is 1996 and the last year is 2022, enter “1996 AND 2022” in the Search Value field.
   2. For Primary NAICS Code – switch Operator to “Beginning with,” and enter 3364 (Aerospace Product and Parts Manufacturing) under Search Value. Then check the last box to the right under “Where Only.”
   3. Click on “Search database” or “Output to CSV File”

Recycling of Waste Chemicals

How to Download Your Data

1. Go to https://www.epa.gov/enviro/tri-ez-search.
2. Scroll down and click on “Flat (Denormalized) Form R – A flat view of the TRI database that contains a majority of the available TRI information.
3. Select the following variables from the list of data elements provided.
   1. Reporting Year
   2. In the row immediately below Recycling Onsite Current Year Quantity check the box above SUM
   3. Primary NAICS Code
4. Scroll to the bottom of the page and click on “STEP 3: Enter Search Criteria”
5. On the next page:
   1. For Reporting Year – switch Operator Definition to “Between.” In the Search Value field, enter the first year shown in the Sector Snapshots chart, followed by “AND”, and the last year shown in the Sector Snapshots chart. For example, if the first year is 1996 and the last year is 2022, enter “1996 AND 2022” in the Search Value field.
   2. For Primary NAICS Code – switch Operator to “Beginning with,” and enter 3364 (Aerospace Product and Parts Manufacturing) under Search Value. Then check the last box to the right under “Where Only.”
   3. Click on “Search database” or “Output to CSV File”

Releases to Land

How to Download Your Data

1. Go to https://www.epa.gov/enviro/tri-ez-search.
2. Scroll down and click on “Flat (Denormalized) Form R – A flat view of the TRI database that contains a majority of the available TRI information.
3. Select the following variables from the list of data elements provided
   1. Reporting Year
   2. In the row immediately below Land Total Release check the box above SUM
   3. Primary NAICS Code
4. Scroll to the bottom of the page and click on “STEP 3: Enter Search Criteria”
5. On the next page:
   1. For Reporting Year – switch Operator Definition to “Between.” In the Search Value field, enter the first year shown in the Sector Snapshots chart, followed by “AND”, and the last year shown in the Sector Snapshots chart. For example, if the first year is 1996 and the last year is 2022, enter “1996 AND 2022” in the Search Value field.
   2. For Primary NAICS Code – switch Operator to “Beginning with,” and enter 3364 (Aerospace Product and Parts Manufacturing) under Search Value. Then check the last box to the right under “Where Only.”
   3. Click on “Search database” or “Output to CSV File”

Water Discharges

How to Download Your Data

1. Go to https://www.epa.gov/enviro/tri-ez-search.
2. Scroll down and click on “Flat (Denormalized) Form R – A flat view of the TRI database that contains a majority of the available TRI information.
3. Select the following variables from the list of data elements provided.
   1. Reporting Year
   2. In the row immediately below Water Total Release check the box above SUM
   3. Primary NAICS Code
4. Scroll to the bottom of the page and click on “STEP 3: Enter Search Criteria”
5. On the next page:
   1. For Reporting Year – switch Operator Definition to “Between.” In the Search Value field, enter the first year shown in the Sector Snapshots chart, followed by “AND”, and the last year shown in the Sector Snapshots chart. For example, if the first year is 1996 and the last year is 2022, enter “1996 AND 2022” in the Search Value field.
   2. For Primary NAICS Code – switch Operator to “Beginning with,” and enter 3364 (Aerospace Product and Parts Manufacturing) under Search Value. Then check the last box to the right under “Where Only.”
   3. Click on “Search database” or “Output to CSV File”

Dollar Value of Gross Output

How to Download Your Data

1. Go to GDP by Industry | U.S. Bureau of Economic Analysis (BEA)
2. Click on Underlying Detail Tables, Annual, 1997-2022
3. Select “Gross Output by Industry.”
4. Select “U.Gross Output by Industry (A),” then click the button that says, “Next Step.” The resulting data table will then load.
5. Select “Modify” in the upper-right-hand corner of the table. In the resulting window:
   1. Set the scale as “Billions”
   2. Set the start year as “1997-A”
   3. Set the end year as the last year presented in the Sector Snapshots graphic.
   4. In the code list, select only “(3364) Aerospace product and parts manufacturing.” Do not select any other item in this menu, doing so may double count.
   5. Click “Refresh Table”
6. Line 1 of the resulting table, labeled “Aerospace product and parts manufacturing” provides the corresponding data shown in this chart for each year.
7. (Optional) Download the dataset in XLS, CSV, or PDF format.

Employment

How to Download Your Data

Note: The data are available in a comma-delimited text format that must be imported into a software package that will allow you to analyze the file.

1. Go to https://www.census.gov/programs-surveys/cbp/data/datasets.html
2. Click on any link labeled “County Business Patterns: YEAR.” On the resulting page, click the “Complete U.S. File” link and download the corresponding file. Repeat this process for each year corresponding to years presented in the Sectors Snapshot graphic.
3. Open each file in a software package of your choice that can process comma-delimited text files. Repeat the steps below for each file.
4. For entities with suppressed data, the Census Bureau replaces all employment values with zeroes, and this underestimates the total number of employees in each sector. Using your software package, replace the suppression flags with the midpoint of the Data Suppression Flag employment ranges per the table below.

   Empflag Data Suppression Flag	Employment Size Class		Midpoint
   	Min	Max
   A	0	19	10
   B	20	99	60
   C	100	249	175
   E	250	499	375
   F	500	999	750
   G	1000	2,499	1,750
   H	2,500	4,999	3,750
   I	5000	9,999	7,500
   J	10,000	24,999	17,500
   K	25,000	49,999	37,500
   L	50,000	99,999	75,000
   M	100,000	>100,000	100,000

5. In your software package, filter the data for NAICS codes that begin with 3364.
6. With the filter in place, aggregate the “emp” column across all records.

Production

How to Download Your Data

1. Go to https://gama.aero/facts-and-statistics/quarterly-shipments-and-billings/
2. Under “Aircraft shipment reports,” click on each year from 2000 – 2019. Doing so will open a PDF report for each year.
3. For reports from 2002 onwards, go to the table titled “Airplane Shipments, by Type Manufactured in United States.” In the 2000 and 2001 reports, go to the table titled “Shipments by Type” and “US Shipments by Type,” respectively.
4. The “Year-To-Date Grand Totals” in these tables represent the values shown in this chart.