2022 NTD Annual Data - Vehicles (Age Distribution)
This dataset details vehicle types and ages for each transit agency reporting to the NTD. Non-dedicated fleets do not report Year of Manufacture and are thus excluded from the Age Distribution table.
Agencies do not report Useful Life Benchmark for non-dedicated fleets or fleets for which the agency does not have capital replacement responsibility. These fleets are excluded from calculations of the percentage of vehicles meeting or exceeding their useful life.
In versions of the data tables from before 2014, you can find data on vehicles in the file called "Age Distribution of Active Vehicle Inventory."
In years 2014-2021, you can find this data in the "Vehicles" data table on NTD Program website, at https://transit.dot.gov/ntd/ntd-data.
If you have any other questions about this table, please contact the NTD Help Desk at NTDHelp@dot.gov.
Querying over HTTP
Splitgraph serves as an HTTP API that lets you run SQL queries directly on
this data to power Web applications. For example:
curl https://data.splitgraph.com/sql/query/ddn \
-H "Content-Type: application/json" \
-d@-<<EOF
{"sql": "
SELECT *
FROM \"datahub-transportation-gov/2022-ntd-annual-data-vehicles-age-distribution-6abt-uhgq\".\"2022_ntd_annual_data_vehicles_age_distribution\"
LIMIT 100
"}
EOF
See the Splitgraph documentation
for more information.