Gas Distribution, Gas Gathering, Gas Transmission, Hazardous Liquids, Liquefied Natural Gas (LNG), and Underground Natural Gas Storage (UNGS) Annual Report Data
The Code of Federal Regulations (49 CFR Parts 191, 195) requires operators gas distribution, gas gathering, gas transmission, hazardous liquid, LNG, and UNGS to submit annual reports to PHMSA. Annual reports include information such as total pipeline mileage, facilities, commodities transported, miles by material, and installation dates. These annual reports are widely used by safety researchers, government agencies, industry professionals, and by PHMSA personnel for inspection planning.
Failure to report may result in enforcement action including civil penalties under 49 U.S.C. § 60122 and 49 CFR § 190.223.
Data in the ZIP file is updated monthly and will change in response to supplemental reports from the operators.
How to Access Files
The annual report ZIP files listed under the "Related Downloads" section, each contain two files: 1) a file containing a description of the fields/columns, and 2) a file appended with the year containing the data.
Download, extract, and save the files from the needed ZIP file from the list on the right.
To load the data file into MS Excel (or MS Access):
- Open Excel and click "File" then "Open". This will start the "Open" dialog box.
- Select the data TXT file and click "Open".
- Excel will start the Text Import Wizard and display the first dialog. Excel is smart enough to figure out that the file is a delimited file, so no adjustments are necessary on the first dialog.
- In the second dialog:
- Specify the delimiter as "Tab".
- Set the "Text Qualifier" to "{none}".
- Make sure "Treat consecutive delimiters as one" is turned off.
- In the third dialog set "Column data format" to "General".
- Click "Finish" to import the data.
Related Links
- Underground Natural Gas Storage (UNGS) Facility (ZIP)
- Gas Distribution Annual Data - 2010 to present (ZIP)
- Gas Distribution Annual Data - 2004 to 2009 (ZIP)
- Gas Distribution Annual Data - 1970 to 2003 (ZIP)
- Hazardous Liquid Annual Data - 2010 to present (ZIP)
- Hazardous Liquid Annual Data - 2004 to 2009 (ZIP)
- Reporting-Regulated Gas Gathering (RRGG) Annual Data – 2022 to present (ZIP)
- Gas Transmission & Gathering Annual Data - 2010 to present (ZIP)
- Gas Transmission & Gathering Annual Data - 2001 to 2009 (ZIP)
- Gas Transmission & Gathering Annual Data - 1970 to 2000 (ZIP)
- Liquefied Natural Gas (LNG) Annual Data - 2010 to present (ZIP)