APTA Vehicle Database - Transit Fleet Inventory

Name: APTA Vehicle Database - Transit Fleet Inventory
Creator: American Public Transportation Association
License: APTA statistical publication reuse terms / site copyright notice

Fleet inventory records from the APTA Vehicle Database for U.S. and Canadian public transportation agencies. One row is a vehicle fleet group with agency, geography, mode, manufacturer, model, vehicle type, accessibility, propulsion, dimensions, seating, cost, and vehicle-count fields; a verification query found 7,705 rows, 365 agencies, 14 modes, and vehicle build years from 1870 through 2031.

american-public-transportation-association-vehicle-fleet·35 columns·225 KB·APTA statistical publication reuse terms / site copyright notice·updated 1d ago

Source: American Public Transportation Association · connector code

Schema

member_id	int64
transit_agency_name	string
city	string
state	string
country	string
new_2025_data	string
last_data_submission	string
fleetid	int64
mode_code	string
mode_name	string
year_built	int64
status	string
manufacturer_code	string
manufacturer_name	string
model	string
vehicle_type	string
vehicle_type_name	string
wheelchair_accessible	string
vehicle_floor_height	string
on_vehicle_accessibility_equipment	string
platform_height	string
platform_accessibility_equipment	string
seats_number_of	int64
length_in_feet	int64
width_in_inches	int64
power_type_code	string
power_type_name	string
engine_manufacturer_code	string
engine_manufacturer_name	string
amount_paid_per_vehicle	int64
total_vehicles_number_of	int64
active_vehicles_number_of	int64
rehabilitated_vehicles_number_of	int64
vehicles_to_be_rehabilitated_number_of	int64
canadianindex	int64

Get this dataset on your machine

subsets sync --bundle medium clones the mid-size tiers as queryable local tables — use --bundle large for the widest tier

pip install subsetsio
subsets sync --bundle small   # or medium, or large
subsets serve   # search + SQL at http://localhost:8080

Free and open — the data syncs straight from the public bucket, and search + SQL run entirely on your machine. See docs →

Query it locally

Full docs →

Bash

subsets serve   # local API on http://localhost:8080
curl -s -X POST "http://localhost:8080/query" \
  -H "Content-Type: application/json" \
  -d '{"sql": "SELECT * FROM \"american-public-transportation-association-vehicle-fleet\" LIMIT 5"}'

No account, no API key — the data syncs straight from bundles.subsets.io and every query runs on your machine. See the local API reference.