Transportation data

Realtime queries over transport-equipment and operator registers, four blocks: aircraft registration (Transport Canada's civil aircraft register CCARCS-RIACC — a five-slot contains-search plus the four-block per-aircraft record, ready for fleet inventories and owner due diligence; plus the EU Air Safety List's official download catalog — third-country carriers banned or restricted, machine-readable XLSX master + 24 language PDFs, the files themselves on the batch pipeline), port state control (Paris MoU current detentions, the ban list, low-performance ISM companies and the historical inspection flow — official ship×management-company edges), shipping emissions (the THETIS-MRV catalog of EU shipping emission-report files), and motor carriers (the US FMCSA carrier full-history book — dot_number is the US transport-compliance universe's hard key, joining straight onto CSA/SMS). All commands run locally on your machine with no credentials: no platform-side quota, each upstream's own limits apply, and repeats within a cache lifetime are served from your local cache without hitting it.

Commands at a glance

Every direct-lookup face in this domain — each has its own section below (one-line positioning / parameters / a real example / boundaries).

Command Jurisdiction What it answers
transportation ca_ccar_aircraft CA Canadian civil-aircraft record by ADet id (four blocks flattened into one dict — aircraft/manufacturer/registration/owner; unmapped labels ride snake_cased under extra_fields, never dropped)
transportation ca_ccar_search CA Canadian civil aircraft register search (CCARCS-RIACC five-slot contains — owner/mark/model/serial; case-sensitive; adet_id joins the per-aircraft record)
transportation euasl_datasets EU EU Air Safety List official download catalog
transportation paris_mou_bans GLOBAL Paris MoU banned ships (embedded management company)
transportation paris_mou_detentions GLOBAL Paris MoU current detentions snapshot
transportation paris_mou_inspections GLOBAL Paris MoU historical inspections window search
transportation paris_mou_low_performance_companies GLOBAL Paris MoU low-performance ISM companies
transportation thetis_mrv_datasets EU EU shipping MRV emission-report file catalog (THETIS-MRV)
transportation us_fmcsa_carriers US US FMCSA carrier full history (4,528,322 rows × 53 columns — dot_number is the CSA/SMS join hard key; DUNS "0" sentinel; a full-history book incl. exited carriers, not an actives register)

Realtime queries

The examples below are real command output, excerpts only, unmodified. Queries are realtime — running a command returns whatever the official source holds at that moment, so figures shift as upstreams update.

The examples below omit the leading executable name — prepend agentdata (or python -m agentdata ) for a full command.

transportation ca_ccar_aircraft

Canadian civil-aircraft record by ADet id (four blocks flattened into one dict — aircraft/manufacturer/registration/owner; unmapped labels ride snake_cased under extra_fields, never dropped)

Parameters:

Flag Required Meaning
--id yes Numeric ADet id (required — from the adet_id column of ca_ccar_search rows, not the registration mark; the ~500k id space has holes, a miss is a legal empty, never guess)

Note:--id is the numeric ADet id (the adet_id column of search rows), not the registration mark — the ~500k id space has holes, a miss parses to a legal empty (aircraft null), never guess an id; non-digits are walled locally; natural-person owner names/addresses ship verbatim with zero enrichment (the raw batch line strips contact details separately — a domain red line).

$ transportation ca_ccar_aircraft --id 538042
{
  "reason": "CCAR 单机档案 ADet 538042:C-FCEU——Airbus A321-211(s/n 5808,AIRBUS S.A.S. FRANCE 2013 年制),Commercial 登记、机主 Air Canada 2023-10-23 起(最近证书 2025-02-12),基地 CYUL Quebec;四块(aircraft/manufacturer/registration/registered owner)展平一 dict,未映射标签(mail_recipient 等)snake_case 挂 extra_fields 不丢",
  "result": {
    "aircraft": {
      "mark": "C-FCEU", "common_name": "Airbus", "model_name": "A321-211", "serial_number": "5808",
      "eligibility_basis": "CAR Standard 507.02, 507.03 - Type Certificate - A166", "category": "Aeroplane",
      "engine": "2, Turbo Fan", "max_take_off_weight": "93000 kg",
      "address_24bit": "Bin=110000000000010111000101, Octal=60002705, Hex=C005C5",
      "regional_office": "Dorval", "year_imported": "2023", "base_of_operations": "CYUL, Quebec, CANADA",
      "manufacturer": "AIRBUS S.A.S.", "country_of_manufacture": "FRANCE", "year_of_manufacture": "2013",
      "type_of_registration": "Commercial", "owner_registered_since": "2023-10-23",
      "latest_certificate_issued": "2025-02-12",
      "owner_name": "Air Canada", "owner_address": "7373 de la Côte-Vertu Blvd.",
      "owner_city": "Saint-Laurent", "owner_postal_code": "H4S 1Z3", "owner_country": "CANADA",
      "extra_fields": { "province_territory_state": "Quebec", "region": "Quebec", "mail_recipient": "Yes" }
    },
    "params": { "adet_id": "538042" }
  },
  "evidence": [
    { "quote": "C-FCEU — owner Air Canada, 7373 de la Côte-Vertu Blvd., Saint-Laurent H4S 1Z3; base CYUL, Quebec, CANADA",
      "url": "https://wwwapps.tc.gc.ca/Applications/ADet/ADet.aspx?id=538042&hs=N&l=eng" }
  ],
  "source": { "provider": "ca_ccar", "execution": "local", "from_cache": false, "observed_at": "2026-11-11T03:03:28.033Z" }
}

**Reading it:**Four blocks in one: the page's aircraft / manufacturer / registration / registered-owner <h2> blocks flatten into a single dict — mark/model/serial, the manufacturer trio (name/country/year), registration type / owner-since / latest certificate, and the owner name+address all present; extra_fields is the catch-all for unmapped labels (here province/region/mail_recipient — upstream redesigns add labels without losing fields); address_24bit carries Bin/Octal/Hex forms. Owner name+address ship verbatim from the public register (same precedent as us_fmcsa company_officer).

Canadian civil aircraft register search (CCARCS-RIACC five-slot contains — owner/mark/model/serial; case-sensitive; adet_id joins the per-aircraft record)

Parameters:

Flag Required Meaning
--owner no Owner-name substring (upstream slot on=
--mark no Registration-mark substring (upstream slot m=
--common-name no Manufacturer common-name substring (upstream slot cn=
--model-name no Model-name substring (upstream slot mn=
--serial-number no Serial-number substring (upstream slot sn=
--limit no Rows, 1-500 (local politeness cap, default 200; print=y ships the whole result set in one page with no paging protocol, total_matched always carries the true count; at least one of the five slots is walled locally)

**Note:**All five slots (--owner / --mark / --common-name / --model-name / --serial-number) are optional but at least one is required (a bare empty query would drag the whole register — walled locally); contains is case-sensitive: the register stores display-case strings matched as raw substrings, so query in uppercase ("AIR CANADA" 269 rows vs "Air Canada" 0 — pinned live 2026-11-11); --limit is a 1-500 local politeness cap (default 200).

$ transportation ca_ccar_search --owner "AIR CANADA" --limit 3
{
  "reason": "CCAR 册内检索 owner=\"AIR CANADA\":全册 269 架匹配,行帽 3(示例行 2/3)——mark/机型/序号/机主/登记日 + adet_id(接 ca_ccar_aircraft 的 join 键);contains 大小写敏感:owner=\"Air Canada\" 0 行(册存显示形原样匹配)",
  "result": {
    "rows": [
      { "adet_id": "538042", "mark": "C-FCEU", "common_name": "Airbus", "model_name": "A321-211", "serial_number": "5808", "owner": "Air Canada", "owner_registered_since": "2023-10-23" },
      { "adet_id": "538532", "mark": "C-FCQD", "common_name": "Airbus", "model_name": "A320-214", "serial_number": "3155", "owner": "Air Canada", "owner_registered_since": "2024-03-27" }
    ],
    "total_matched": 269,
    "limit_applied": 3,
    "params": { "owner": "AIR CANADA" },
    "upstream_params": { "cn": "||", "mn": "||", "sn": "||", "on": "|AIR CANADA|", "m": "||", "rfr": "RchSimp.aspx", "print": "y" }
  },
  "evidence": [
    { "quote": "C-FCEU(A321-211,s/n 5808)— owner Air Canada since 2023-10-23(269 行之一)",
      "url": "https://wwwapps.tc.gc.ca/Applications/RchSimp/RchSimpRes.aspx" }
  ],
  "source": { "provider": "ca_ccar", "execution": "local", "from_cache": false, "observed_at": "2026-11-11T03:03:16.704Z" }
}

**Reading it:**The interactive page is a shell: the POST form 302-redirects to a stateless bare GET (RchSimpRes.aspx five pipe-wrapped contains slots — cn/mn/sn/on/m), and print=y returns the whole result set in one page (269 rows / 365KB measured; the interactive view shows 10/page with no pager) — no ViewState, no cookies; total_matched always carries the true count with rows capped locally by --limit; upstream_params hangs the pipe-wrapped wire form (replayable as-is) while params echoes the logical criteria; adet_id joins ca_ccar_aircraft for the per-aircraft drill-down.

transportation euasl_datasets

EU Air Safety List official download catalog

**Note:**A zero-parameter catalog face — one call returns all 25 files, no filters, no paging; the document UUIDs are publish-time content ids, not stable keys, and rotate on every republication (link form /document/download/<uuid>_<lang>?filename=…), so reconcile against this listing and never guess file names; the XLSX/PDF files themselves are not downloadable through this face (the batch pipeline fetches them).

$ transportation euasl_datasets
{
  "reason": "EU 航空安全禁飞名单官方下载目录:25 件跨 24 种官方语言——机读 XLSX 主件(附件 A=运营禁令承运人、附件 B=限制条件运营)排第一,其余为各语言 PDF rendition;文档 UUID 随每次再公布轮换——收割按本清单对账勿猜文件名;文件本体走批线",
  "result": {
    "rows": [
      { "document_id": "67b75752-d144-4366-9f4a-c04157840211", "language": "en", "file_name": "air-safety-list.xlsx", "format": "xlsx", "download_path": "/document/download/67b75752-d144-4366-9f4a-c04157840211_en?filename=air-safety-list.xlsx" },
      { "document_id": "3195fabb-7575-4db9-85b9-ec5a77b481aa", "language": "bg", "file_name": "air-safety-list_bg.pdf", "format": "pdf", "download_path": "/document/download/3195fabb-7575-4db9-85b9-ec5a77b481aa_bg?filename=air-safety-list_bg.pdf" },
      { "document_id": "3195fabb-7575-4db9-85b9-ec5a77b481aa", "language": "cs", "file_name": "air-safety-list_cs.pdf", "format": "pdf", "download_path": "/document/download/3195fabb-7575-4db9-85b9-ec5a77b481aa_cs?filename=air-safety-list_cs.pdf" }
    ],
    "count": 25,
    "master": { "file_name": "air-safety-list.xlsx", "download_path": "/document/download/67b75752-d144-4366-9f4a-c04157840211_en?filename=air-safety-list.xlsx" }
  },
  "evidence": [
    { "quote": "air-safety-list.xlsx (xlsx, en):/document/download/67b75752-d144-4366-9f4a-c04157840211_en?filename=air-safety-list.xlsx",
      "url": "https://transport.ec.europa.eu/transport-themes/eu-air-safety-list_en" }
  ],
  "source": { "provider": "euasl", "execution": "local", "from_cache": false, "observed_at": "2026-11-02T07:44:03.071Z" }
}

Reading it:master carries the machine-readable XLSX row (same as the first row); the other 24 rows are official-language PDF renditions (language = ISO-639-1 code; the hr rendition carries an _2 suffix on the filename while the language token stays the path segment); download_path is a site path — prepend the transport.ec.europa.eu host for the direct file link. The list itself: Annex A = third-country carriers under an operating ban (~188), Annex B = carriers operating under restrictions and conditions (AIR KORYO / IRAN AIR).

transportation paris_mou_bans

Paris MoU banned ships (embedded management company)

**Note:**Of the 486 rows, 310 carry the management-company key — the rest have null company columns (the upstream leaves them unlinked), so never assume a company edge on every row; the list rolls daily; this face is the ban list, single detention events live in the paris_mou_inspections flow.

$ transportation paris_mou_bans
{
  "reason": "Paris MoU 禁令名单:486 行,其中 310 行带 ISM 管理公司 IMO 号(如 SELAM / IMO 9418286 → Unimarin Denizcilik / 公司 IMO 5322090,10/09/2026 禁令)——船×管理公司官方边直出,公司键可比对航运公司档",
  "result": {
    "rows": [
      { "id": 7489690651, "imo_number": "9418286", "ship_name": "SELAM", "flag_code": "KN", "flag_name": "Saint Kitts and Nevis", "ban_date": "10/09/2026", "ban_occurrence": "First", "ban_order_status": { "type": "VALIDATED", "description": "Validated", "effectDate": null, "expiryDate": null, "active": true, "id": "VALIDATED" }, "ban_reason": { "type": "MULTIPLE_OF_DETENTIONS", "description": "Multiple detentions", "effectDate": null, "expiryDate": null, "multipleDetentionsReason": true, "active": true, "id": "MULTIPLE_OF_DETENTIONS" }, "minimum_duration": { "name": "THREE_MONTHS", "message": "Three months " }, "banning_authority": "Italy", "company_imo_number": "5322090", "company_name": "Unimarin Denizcilik", "company_address": null, "company_city": null, "company_country_code": "TR", "company_country_name": "Turkiye" }
    ],
    "count": 486
  },
  "evidence": [
    { "quote": "SELAM(IMO 9418286,KN):10/09/2026 First禁令(Italy)→ Unimarin Denizcilik(公司 IMO 5322090)",
      "url": "https://portal.emsa.europa.eu/o/portlet-public/rest/ban/getBanShips.json" }
  ],
  "source": { "provider": "paris_mou", "execution": "local", "from_cache": true, "fetched_at": "2026-10-30T01:22:57.677Z" }
}

**Reading it:**One row per ship ban, with the ISM management-company quartet embedded (company_imo_number / company_name / country) — an official ship×management-company edge straight from the source, whose company IMO key joins directly against shipping-company registers; ban_order_status / ban_reason / minimum_duration are structured enums (VALIDATED / MULTIPLE_OF_DETENTIONS / THREE_MONTHS), and ban_occurrence (First/Second/…) marks the recidivism tier.

transportation paris_mou_detentions

Paris MoU current detentions snapshot

**Note:**A rolling current-state snapshot — today's 52 ships shift tomorrow (new detentions in, releases out), it is not a historical ledger; coverage is limited to ports of Paris MoU member authorities; for detention history use the paris_mou_inspections windowed search.

$ transportation paris_mou_detentions
{
  "reason": "Paris MoU 当前滞留:52 船在滞(如 SANTOS TRADER / IMO 9404431,29/10/2026 滞留于 DE Brake)——现行态快照当日滚动;船 IMO 号=资产键",
  "result": {
    "rows": [
      { "id": 7589901219, "imo_number": "9404431", "ship_name": "SANTOS TRADER", "ship_type": "Bulk carrier", "flag_code": "MH", "flag_name": "Marshall Islands", "detention_date": "29/10/2026", "detention_port": "Brake", "detention_country_code": "DE", "reporting_authority": "Germany" },
      { "id": 7592889849, "imo_number": "1111959", "ship_name": "JIN FOISON", "ship_type": "Bulk carrier", "flag_code": "SG", "flag_name": "Singapore", "detention_date": "29/10/2026", "detention_port": "Gdynia", "detention_country_code": "PL", "reporting_authority": "Poland" }
    ],
    "count": 52
  },
  "evidence": [
    { "quote": "SANTOS TRADER(IMO 9404431,MH,Bulk carrier):29/10/2026 滞留于 DE Brake",
      "url": "https://portal.emsa.europa.eu/o/portlet-public/rest/detention/getCurrentDetentions.json" }
  ],
  "source": { "provider": "paris_mou", "execution": "local", "from_cache": true, "fetched_at": "2026-10-30T03:08:16.277Z" }
}

**Reading it:**One row per ship currently under detention: the ship IMO number (the asset key) plus ship type, flag, and the detention date/port/authority — the 52 rows here are the full global detention list as of today; take the ship IMO number to vessel registers or company faces for asset matching.

transportation paris_mou_inspections

Paris MoU historical inspections window search

Parameters:

Flag Required Meaning
--period-min yes Window start dd/mm/yyyy (upstream periodMin; STRICT day-first — wrong order silently returns zero; required)
--period-max yes Window end dd/mm/yyyy (upstream periodMax; window <= 3 years enforced locally — longer windows silently empty upstream; required)
--psc-inspection-regime no Inspection regime (upstream pscInspectionRegime; 1 = PSC default, the only live value — 0 → poisoned 200 empty / 2 → HTTP 500; non-1 walled locally with the evidence)
--page no Page number (upstream page; the paging switch — this face always sends it, without it upstream ignores limit and dumps the whole window)
--start no Row offset within page (upstream start; page+start+limit = start-offset paging, page 1/2 verified zero overlap)
--limit no Rows (default 50, politeness cap 500; upstream fully honors 1000)
--ism-company-name no ISM management-company name filter (upstream ismCompanyName)
--ism-company-imo-number no ISM company IMO number filter, 7-digit zero-padded (upstream ismCompanyImoNumber, e.g. 0052193; both padded/unpadded forms accepted upstream — passed through verbatim)

Note:--period-min / --period-max are required and demand strict dd/mm/yyyy date order — a reversed window silently returns 0 rows; the window spans at most 3 years (a local wall); --psc-inspection-regime 1 is the only live value — 0 draws a poisoned 200 empty and 2 an HTTP 500 upstream, so non-1 values are walled locally with the evidence (measured in the 0.3.20 audit); page via --page (always sent on this face) or --start, with --limit default 50 and politeness cap 500 (the upstream fully honors 1000).

$ transportation paris_mou_inspections --period-min 01/01/2026 --period-max 01/10/2026 --psc-inspection-regime 1
{
  "reason": "Paris MoU 历史检查流:窗 01/01/2026–01/10/2026 本页 50 行 / 全窗 13,181——窗统计:13181 检/12175 船/517 滞留/1900 ISM 缺陷;首行 AAL DAMMAM(IMO 9963554)01/10/2026 @Canada Trois Rivieres 3 缺陷——id 键可逐检深查(getInspectionDetail)",
  "result": {
    "rows": [
      { "id": 7540826008, "imo_number": "9963554", "ship_name": "AAL DAMMAM", "ship_type": "General cargo/multipurpose", "flag_code": "PT", "flag_name": "Portugal", "age": 2, "inspection_date": "01/10/2026", "inspection_type": "Initial inspection", "member_state": "Canada", "port_name": "Trois Rivieres", "port_and_ms": "Canada - Trois Rivieres", "ndeficiencies": 3, "results_desc": "" },
      { "id": 7531600985, "imo_number": "8317978", "ship_name": "AB MOLY", "ship_type": "General cargo/multipurpose", "flag_code": "SL", "flag_name": "Sierra Leone", "age": 43, "inspection_date": "01/10/2026", "inspection_type": "More detailed inspection", "member_state": "Romania", "port_name": "Braila", "port_and_ms": "Romania - Braila", "ndeficiencies": 6, "results_desc": "" }
    ],
    "count": 50,
    "total": 13181,
    "resume": { "ships": 12175, "inspections": 13181, "detentions": 517, "ism_deficiencies": 1900, "non_ism_deficiencies": 40110, "bans": 14 },
    "paging": { "page": 1, "start": 0, "limit": 50 }
  },
  "evidence": [
    { "quote": "AAL DAMMAM(IMO 9963554,PT):01/10/2026 @Canada Trois Rivieres——3 缺陷(Initial inspection)",
      "url": "https://portal.emsa.europa.eu/o/portlet-public/rest/inspection/getPublicInspections.json" }
  ],
  "source": { "provider": "paris_mou", "execution": "local", "from_cache": false, "observed_at": "2026-10-30T03:10:13.697Z" }
}

Reading it:reason carries the window statistics (this window: 13,181 inspections / 12,175 ships / 517 detentions / 1,900 ISM deficiencies) — use it directly to size a window's risk surface; result.resume is the same data in structured form (with non_ism_deficiencies / bans too); one row = one inspection, the id key supports per-inspection drill-down (upstream getInspectionDetail); --ism-company-imo-number / --ism-company-name narrow the flow to a given management company.

transportation paris_mou_low_performance_companies

Paris MoU low-performance ISM companies

**Note:**The list holds only LOW-tier companies — higher-risk performance tiers are not on this face; effect_date is the listing date (it can long predate today, the first example 2012 — years-long low performance), and a null expiry_date means still listed; address columns are null for some rows.

$ transportation paris_mou_low_performance_companies
{
  "reason": "Paris MoU 低表现 ISM 公司:65 家(25 国/地区),100% 带 IMO 公司号(如 Apeejay Shipping Ltd / IMO 0052193,India,LOW,08/10/2012 入榜)——滚动 6 月窗公司风险属性名单",
  "result": {
    "rows": [
      { "id": 18885, "imo_number": "0052193", "name": "Apeejay Shipping Ltd", "address": "Apeejay House, 15, Park Street", "city": "Kolkata", "country_code": "IN", "country_name": "India", "performance": "LOW", "effect_date": "08/10/2012", "expiry_date": null, "status": "ACTIVE" },
      { "id": 22066, "imo_number": "0099721", "name": "JADROLINIJA RIJEKA", "address": null, "city": null, "country_code": "HR", "country_name": "Croatia", "performance": "LOW", "effect_date": "01/11/2023", "expiry_date": null, "status": "ACTIVE" }
    ],
    "count": 65
  },
  "evidence": [
    { "quote": "Apeejay Shipping Ltd(IMO 0052193,India,LOW,入榜 08/10/2012)",
      "url": "https://portal.emsa.europa.eu/o/portlet-public/rest/companyperformance/getLowPerformance6MonthsISMCompanies.json" }
  ],
  "source": { "provider": "paris_mou", "execution": "local", "from_cache": true, "fetched_at": "2026-10-30T01:23:12.938Z" }
}

**Reading it:**One row per ISM management company: the company IMO number (7-digit zero-padded, e.g. 0052193) plus address, country, performance / effect_date / status — a rolling 6-month-window list of 65 companies, ready-made for shipping-company risk due diligence; the company IMO key cross-joins the other Paris MoU faces (the ISM columns of bans/inspections).

transportation thetis_mrv_datasets

EU shipping MRV emission-report file catalog (THETIS-MRV)

**Note:**A zero-parameter catalog face — one call returns all 8 periods' current files, no filters, no paging; version numbers jump as the upstream regenerates (at capture time 2025 was already v76, 2024 v254), so reconcile against this listing and never guess file names; the XLSX files themselves are not downloadable through this face.

$ transportation thetis_mrv_datasets
{
  "reason": "THETIS-MRV 排放申报件目录:8 个申报期(2018-2025)× 8 件版本化发布件——最新 2025 v76(29-10-2026 05:27:07 再生成);版本账本滚动跳变,收割按清单对账勿猜文件名;XLSX 本体走批线",
  "result": {
    "rows": [
      { "reporting_period": 2025, "version": 76, "generation_date": "29-10-2026 05:27:07", "file_name": "2025-v76-29102026-EU MRV Publication of information", "download_path": "/api/public-emission-report/reporting-period-document/binary/2025/76" },
      { "reporting_period": 2024, "version": 254, "generation_date": "28-10-2026 05:21:34", "file_name": "2024-v254-28102026-EU MRV Publication of information", "download_path": "/api/public-emission-report/reporting-period-document/binary/2024/254" }
    ],
    "count": 8,
    "reporting_periods": [2025, 2024, 2023, 2022, 2021, 2020, 2019, 2018]
  },
  "evidence": [
    { "quote": "2025 v76(29-10-2026 05:27:07):2025-v76-29102026-EU MRV Publication of information",
      "url": "https://mrv.emsa.europa.eu/api/public-emission-report/downloadable-files" }
  ],
  "source": { "provider": "thetis_mrv", "execution": "local", "from_cache": true, "fetched_at": "2026-10-29T09:07:36.581Z" }
}

**Reading it:**One row per reporting period = its currently published file: version, regeneration timestamp, file name and download path; the reporting_periods array lists every period on the shelf (2018–2025); download_path is relative — prepend the mrv.emsa.europa.eu host for the direct file link.

transportation us_fmcsa_carriers

US FMCSA carrier full history (4,528,322 rows × 53 columns — dot_number is the CSA/SMS join hard key; DUNS "0" sentinel; a full-history book incl. exited carriers, not an actives register)

Parameters:

Flag Required Meaning
--where no Raw SoQL filter (upstream param $where), e.g. dot_number='963305' or legal_name like 'WINSUPPLY%' — dot_number is the US transport-compliance universe's hard key (CSA/SMS join straight onto it); status_code is the lifecycle ('A' = active; a full-history book keeps exited carriers)
--limit no Rows, 1–500 (politeness cap, default 20; Socrata echoes no total and none is faked — the 4,528,322 corpus rides the reason; the 53-column view omits null fields per row)
--offset no Row offset ≥0
--order no Sort column [ASC

**Note:**A full-history book, not an actives-only list: 4,528,322 rows = active + inactive carriers (the status_code lifecycle, 'A' = active) — screening the exited ones is exactly the point; the raw SoQL channel is the same contract ($where raw / $limit 1-500 / $offset / $order, no total echoed, none faked). The 53-column view omits null fields per row — a fully-loaded row ships ~53 keys, a bare one fewer. Walk-aways: the sibling dataset 4a2k-zf79 is dead (403), and SMS Input kjg3-diqy is a neighboring input face, not this one. TTL 7d (batch-refresh census posture).

$ transportation us_fmcsa_carriers --where "dot_number='963305'" --limit 3
{
  "ok": true,
  "domain": "transportation",
  "tool": "us_fmcsa_carriers",
  "input": { "where": "dot_number='963305'", "limit": 3, "offset": 0, "order": null },
  "from_cache": false,
  "reason": "FMCSA carrier census: 1 rows returned (from offset=0; Socrata echoes no total) — dot_number key (sample #963305, WINSUPPLY SALIDA CO CO [A], SALIDA, CO, officers MICHAEL KIRKLAND / SHAWN SAMUELSON; 53 keys on this row — Socrata omits null fields per row); corpus 4,528,322 active+historical (live count 2026-11-09); dun_bradstreet_no = the rare official DUNS cross-key",
  "result": {
    "rows": [
      {
        "dot_number": "963305", "legal_name": "WINSUPPLY SALIDA CO CO", "status_code": "A",
        "dun_bradstreet_no": "0",
        "phy_street": "338 OAK ST", "phy_city": "SALIDA", "phy_state": "CO", "phy_zip": "81201", "phy_country": "US", "phy_cnty": "015",
        "carrier_mailing_street": "3110 KETTERING BLVD", "carrier_mailing_city": "DAYTON", "carrier_mailing_state": "OH", "carrier_mailing_zip": "45439", "carrier_mailing_country": "US", "carrier_mailing_cnty": "113",
        "company_officer_1": "MICHAEL KIRKLAND", "company_officer_2": "SHAWN SAMUELSON",
        "phone": "7195300501", "email_address": "amkolb@winsupplyinc.com",
        "carrier_operation": "C", "classdef": "PRIVATE PROPERTY", "fleetsize": "B",
        "truck_units": "2", "power_units": "2", "bus_units": "0", "owntruck": "2",
        "total_drivers": "3", "total_cdl": "0", "total_intrastate_drivers": "3",
        "interstate_beyond_100_miles": "0", "interstate_within_100_miles": "0",
        "intrastate_beyond_100_miles": "0", "intrastate_within_100_miles": "3",
        "hm_ind": "N", "carship": "C",
        "crgo_genfreight": "X", "crgo_metalsheet": "X", "crgo_bldgmat": "X", "crgo_construct": "X", "crgo_waterwell": "X", "crgo_cargoothr": "X", "crgo_cargoothr_desc": "PLUMPING SUPPLIES",
        "mcs150_date": "20240509", "mcs150_mileage": "37000", "mcs150_mileage_year": "2023", "mcs150_update_code_id": "1",
        "add_date": "20010620", "mcsipdate": "20101211", "mcsipstep": "0",
        "phy_omc_region": "08", "safety_inv_terr": "J",
        "driver_inter_total": "0"
      }
    ],
    "count": 1,
    "limit_applied": 3,
    "params": { "$limit": 3, "$offset": 0, "$where": "dot_number='963305'" }
  },
  "evidence": [
    { "quote": "DOT 963305 — WINSUPPLY SALIDA CO CO (SALIDA, CO; status A, carrier_operation C, 2 trucks/2 power/0 bus)", "url": "https://data.transportation.gov/resource/az4n-8mr2.json" }
  ],
  "source": { "provider": "us_fmcsa", "execution": "local", "from_cache": false, "observed_at": "2026-11-09T08:28:27.160Z" },
  "request_id": "85b729ce-8464-4867-9a27-e14d64677246",
  "query": { "source": "raw", "upstream": { "$limit": 3, "$offset": 0, "$where": "dot_number='963305'" } },
  "jurisdiction": "US"
}

*Reading it:dot_number is the hard key of the US transport-compliance universe — CSA/SMS safety-performance systems join straight onto it. dun_bradstreet_no = the rare official DUNS cross-key (this sample row's '0' is the upstream's placeholder sentinel — ship it verbatim, honest-null semantics, not a real DUNS). Dual address blocks: phy_ (the physical operating address, CO here) vs carrier_mailing_ (the mailing address, OH here — WinSupply's group HQ) routinely differ; for due diligence the phy block is the operating fact. company_officer_1/2 ship verbatim (the public-register precedent). The three fleet families truck/power/bus units + owntruck, the mcs150 mileage year-window (37,000 miles in 2023), the hm_ind hazardous-materials flag + sixteen crgo_ cargo-class flags (six here + the free-text PLUMPING SUPPLIES). Carriers without a safety rating naturally lack safety_rating — the column sits in the view and appears only when populated (Socrata's per-row null omission).

The fine print

  • CCAR contains is case-sensitive: the register stores display-case strings matched as raw substrings — query owners in uppercase ("AIR CANADA" 269 rows vs "Air Canada" 0); the ADet id space has holes, a miss is a legal empty, take ids from search rows and never guess.
  • The catalog faces (euasl/thetis_mrv) give coordinates only: file UUIDs/versions rotate on every upstream republication, reconcile against the listing and never guess file names; the XLSX/PDF bodies travel on the batch pipeline, not through these faces.