U.S. Department of Transportation

DOT Data Hub Open Data API

The departmental open data platform, served from both data.transportation.gov and datahub.transportation.gov on Socrata SODA 2.1. For travel and aviation this is where the DOT Office of the Assistant Secretary for Aviation and International Affairs publishes the Consumer Airfare Report city-pair fare tables (Tables 1, 1a, 2, 5, 6 and 7), the Airline Quarterly Financial Review, and international seat and passenger reports. 1,542 datasets enumerated in the DCAT-US 1.1 document at /data.json. Datasets are licensed Public Domain U.S. Government (USGOV_WORKS). Verified anonymously with HTTP 200 on 2026-07-28 against /resource/4f3n-jbg2.json and /resource/tfrh-tu9e.json — no app token required for the volumes tested.

Documentation GitHub

Documentation

📖

Documentation

https://dev.socrata.com/docs/endpoints.html

📖

APIReference

https://dev.socrata.com/docs/queries/

Other Resources

🔗

Portal

https://data.transportation.gov/

🔗

Portal

https://datahub.transportation.gov/

🔗

APICatalog

https://data.transportation.gov/data.json

🔗

StatusPage

https://status.socrata.com/

🔗

License

https://www.usa.gov/government-works

🔗

AgentSkill

https://raw.githubusercontent.com/api-evangelist/us-dot/refs/heads/main/skills/us-dot-query-bts-aviation-statistics.md

Work with this as data

Every API here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for apis

7 MCP tools reach this

find_apisBrowse and filter every API in the catalog.
get_api_artifactsOne API's artifacts, grouped by type.
get_openapiThe primary OpenAPI for this API.
find_similar_apisAPIs that look like this one.
apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
resolveTurn a domain, URL or GitHub org into the provider it belongs to.
find_cohortsEvery scored population of providers in the catalog.

All 92 tools →

Call it yourself

curl for this page

This API

curl "https://apis.io/api/v1/apis/dot-data-hub-soda-api"

All apis

curl "https://apis.io/api/v1/apis?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have.

API entry from apis.yml

aid: us-dot:dot-data-hub-soda-api
name: DOT Data Hub Open Data API
description: The departmental open data platform, served from both data.transportation.gov and datahub.transportation.gov
  on Socrata SODA 2.1. For travel and aviation this is where the DOT Office of the Assistant Secretary
  for Aviation and International Affairs publishes the Consumer Airfare Report city-pair fare tables (Tables
  1, 1a, 2, 5, 6 and 7), the Airline Quarterly Financial Review, and international seat and passenger
  reports. 1,542 datasets enumerated in the DCAT-US 1.1 document at /data.json. Datasets are licensed
  Public Domain U.S. Government (USGOV_WORKS). Verified anonymously with HTTP 200 on 2026-07-28 against
  /resource/4f3n-jbg2.json and /resource/tfrh-tu9e.json — no app token required for the volumes tested.
humanURL: https://data.transportation.gov/
baseURL: https://datahub.transportation.gov/resource
tags:
- Open Data
- Aviation
- Airfares
- Airlines
- Statistics
properties:
- type: Documentation
  url: https://dev.socrata.com/docs/endpoints.html
- type: APIReference
  url: https://dev.socrata.com/docs/queries/
- type: Portal
  url: https://data.transportation.gov/
- type: Portal
  url: https://datahub.transportation.gov/
- type: APICatalog
  url: https://data.transportation.gov/data.json
- type: StatusPage
  url: https://status.socrata.com/
- type: License
  url: https://www.usa.gov/government-works
- type: AgentSkill
  name: Query BTS and DOT open data with SoQL
  url: skills/us-dot-query-bts-aviation-statistics.md