USA Banner

Official US Government Icon

Official websites use .gov
A .gov website belongs to an official government organization in the United States.

Secure Site Icon

Secure .gov websites use HTTPS
A lock ( ) or https:// means you’ve safely connected to the .gov website. Share sensitive information only on official, secure websites.

U.S. Department of Transportation U.S. Department of Transportation Icon United States Department of Transportation United States Department of Transportation

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):

  1. Open Excel and click "File" then "Open". This will start the "Open" dialog box.
  2. Select the data TXT file and click "Open".
  3. 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.
  4. In the second dialog:
    1. Specify the delimiter as "Tab".
    2. Set the "Text Qualifier" to "{none}".
    3. Make sure "Treat consecutive delimiters as one" is turned off.
  5. In the third dialog set "Column data format" to "General".
  6. Click "Finish" to import the data.