交通数据
运输器物与运营人登记册的实时查询,四块:航空器登记(加拿大交通部民用航空器登记册 CCARCS-RIACC——册内五槽 contains 检索 + 单机四块档案,机队盘点与机主尽调直查;EU 航空安全禁飞名单官方下载目录——被禁/受限第三国承运人,机读 XLSX 主件+24 语言 PDF,文件本体走批线)、港口国监督(Paris MoU 当前滞留、禁令名单、低表现 ISM 公司与历史检查流——船×管理公司官方边直出)、船舶排放(THETIS-MRV 欧盟船舶排放申报件目录)、机动车承运人(US FMCSA 承运人全史册——dot_number 是 US 运输合规宇宙的硬键,CSA/SMS 直 join)。全部命令在你的机器上本地执行、无需任何凭证:平台侧不设配额,按各上游规则限流;重复查询在缓存有效期内由本机缓存直接应答。
命令一览
本域全部直查面,每条在下文都有自己的分区(一行定位 / 参数 / 真机示例 / 边界)。
| 命令 |
辖域 |
回答什么 |
transportation ca_ccar_aircraft |
CA |
加拿大民用航空器单机档案(ADet 四块展平:aircraft/manufacturer/registration/owner 一 dict;未映射标签 snake_case 挂 extra_fields 不丢) |
transportation ca_ccar_search |
CA |
加拿大民用航空器登记册检索(CCARCS-RIACC 五槽 contains——机主/标志/机型/序号;大小写敏感;adet_id 接单机档案面) |
transportation euasl_datasets |
EU |
EU 航空安全禁飞名单官方下载目录 |
transportation paris_mou_bans |
GLOBAL |
Paris MoU 禁令船名单(内嵌管理公司) |
transportation paris_mou_detentions |
GLOBAL |
Paris MoU 当前滞留船快照 |
transportation paris_mou_inspections |
GLOBAL |
Paris MoU 历史检查流窗检索 |
transportation paris_mou_low_performance_companies |
GLOBAL |
Paris MoU 低表现 ISM 公司名单 |
transportation thetis_mrv_datasets |
EU |
EU 船舶排放申报批量件目录(THETIS-MRV) |
transportation us_fmcsa_carriers |
US |
美国 FMCSA 承运人全史册(4,528,322 行 53 列——dot_number=CSA/SMS join 硬键;DUNS "0" 哨兵;全史册含停业,非在营册) |
实时查询
以下均为真实运行命令的原样输出,仅节选部分行。查询是实时的——你运行时拿到的就是官方数据源当时的数据,数字随上游更新而变化。
以下示例省略行首的可执行名——补上 agentdata (或 python -m agentdata )即为完整命令。
transportation ca_ccar_aircraft
加拿大民用航空器单机档案(ADet 四块展平:aircraft/manufacturer/registration/owner 一 dict;未映射标签 snake_case 挂 extra_fields 不丢)
参数:
| 旗标 |
必填 |
说明 |
--id |
是 |
ADet 数字 id(必填——来自 ca_ccar_search 行的 adet_id 列,非登记标志 mark;~50 万 id 空间有洞,未命中=legal empty 不补不猜) |
注意:--id 是 ADet 数字 id(search 行的 adet_id 列),非登记标志 mark——~50 万 id 空间有洞,未命中=legal empty(aircraft 为 null),不猜 id;非数字本地墙拒;自然人机主名/址照录公开册零增补(raw 批线入批时另剥联系方式=域红线)。
$ 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" }
}
**怎么读:**四块合一:网页的 aircraft / manufacturer / registration / registered owner 四个 <h2> 块展平成一个 dict——mark/机型/序号、制造方三件(名/国/年)、登记类型/机主起登日/最近证书、机主名址一应俱全;extra_fields 是未映射标签的兜底(本例 province/region/mail_recipient——上游改版加标签不丢字段);address_24bit 带 Bin/Octal/Hex 三形。机主名址 verbatim 照录公开册(us_fmcsa company_officer 同例)。
transportation ca_ccar_search
加拿大民用航空器登记册检索(CCARCS-RIACC 五槽 contains——机主/标志/机型/序号;大小写敏感;adet_id 接单机档案面)
参数:
| 旗标 |
必填 |
说明 |
--owner |
否 |
机主名子串(上游槽 on= |
--mark |
否 |
登记标志子串(上游槽 m= |
--common-name |
否 |
制造商常用名子串(上游槽 cn= |
--model-name |
否 |
机型名子串(上游槽 mn= |
--serial-number |
否 |
序号子串(上游槽 sn= |
--limit |
否 |
返回行数 1–500(本地礼貌帽,默认 200;print=y 一页全量无翻页协议,total_matched 恒真值;五槽至少一槽本地墙) |
注意:五槽(--owner/--mark/--common-name/--model-name/--serial-number)全可选但至少一槽(空查询会拖整册——本地墙);contains 大小写敏感:册存显示形原样子串匹配,owner 用大写形("AIR CANADA" 269 行 / "Air Canada" 0 行——2026-11-11 真机定谳);--limit 1-500 本地礼貌帽(默认 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" }
}
**怎么读:**交互页只是壳:POST 表单 302 后真形是无状态裸 GET(RchSimpRes.aspx 五槽管道包裹 contains——cn/mn/sn/on/m),print=y 一页全量(269 行/365KB 实测;交互页 10 行/页且无翻页链)——免 ViewState 免 cookie;total_matched 恒真值,行由本地 --limit 帽截;upstream_params 挂管道包裹的线真形(重放直用),params 是逻辑条件回显;adet_id 接 ca_ccar_aircraft 逐机深查。
transportation euasl_datasets
EU 航空安全禁飞名单官方下载目录
**注意:**零参数目录面——一次调用返回全部 25 件,无过滤无分页;文档 UUID 是发布时内容 id 而非稳定键,每次再公布即轮换(链接形 /document/download/<uuid>_<lang>?filename=…),对账以此清单为准、勿猜文件名;XLSX/PDF 本体不经此面下载(批线管线取)。
$ 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" }
}
怎么读:master 直接给机读 XLSX 行(与首行同值);其余 24 行是官方语言 PDF rendition(language=ISO-639-1 码;hr 版文件名带 _2 后缀、语言 token 仍是路径段);download_path 是站内径——拼 transport.ec.europa.eu 主机即文件直链。名单本体:附件 A=被运营禁令覆盖的第三国承运人(~188 家)、附件 B=限制条件下运营(AIR KORYO / IRAN AIR)。
transportation paris_mou_bans
Paris MoU 禁令船名单(内嵌管理公司)
**注意:**486 行中 310 行带管理公司键——其余行公司列为 null(上游未挂),勿假设每行都有公司边;名单当日滚动;本面是禁令名单,单次滞留事件在 paris_mou_inspections 流里。
$ 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" }
}
怎么读:一行=一船禁令,且内嵌 ISM 管理公司四元组(company_imo_number / company_name / 国别)——船×管理公司的官方边直出,公司 IMO 键可直接比对航运公司档;ban_order_status / ban_reason / minimum_duration 是结构化枚举(VALIDATED / MULTIPLE_OF_DETENTIONS / THREE_MONTHS),ban_occurrence(First/Second/…)标累犯层级。
transportation paris_mou_detentions
Paris MoU 当前滞留船快照
**注意:**现行态快照当日滚动——今日 52 船明日即变(新滞留进、解除出),非历史账;范围限 Paris MoU 成员当局的港口;要滞留历史走 paris_mou_inspections 窗口检索。
$ 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" }
}
**怎么读:**一行=一船当前在滞:船 IMO 号(资产键)+ 船型 + 船旗 + 滞留日期/港口/主管当局——本日 52 行就是当前全球在滞全量;船 IMO 号拿去船舶档案/公司面比对资产。
transportation paris_mou_inspections
Paris MoU 历史检查流窗检索
参数:
| 旗标 |
必填 |
说明 |
--period-min |
是 |
窗起 dd/mm/yyyy(上游参 periodMin;日/月/年严格序——写错序上游静默回 0 行;必填) |
--period-max |
是 |
窗止 dd/mm/yyyy(上游参 periodMax;窗≤3 年本地墙——超窗上游静默空回;必填) |
--psc-inspection-regime |
否 |
检查制度(上游参 pscInspectionRegime;1=PSC 默认制度,唯一活值——0→200 毒空/2→HTTP 500,非 1 本地墙拒附证据) |
--page |
否 |
页码(上游参 page;翻页开关——本面恒发,不带则上游无视 limit 整窗倾倒) |
--start |
否 |
页内行偏移(上游参 start;page+start+limit=start 偏移翻页,page1/page2 实测零重叠) |
--limit |
否 |
返回行数(默认 50,礼貌档 500;上游 1000 全量兑现) |
--ism-company-name |
否 |
ISM 管理公司名过滤(上游参 ismCompanyName) |
--ism-company-imo-number |
否 |
ISM 公司 IMO 号过滤,7 位零填充(上游参 ismCompanyImoNumber,如 0052193;零填充/非填充两形上游均收,透传不规范化) |
注意:--period-min / --period-max 必填且严格 dd/mm/yyyy 日序——错序静默回 0 行,窗最长 3 年(本地墙);--psc-inspection-regime 1 是唯一活值——0 上游回 200 毒空、2 回 HTTP 500,非 1 本地墙拒附证据(0.3.20 审计实测);翻页走 --page(本面恒发)或 --start,--limit 默认 50、礼貌档 500(上游 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" }
}
怎么读:reason 自带窗统计(本窗 13,181 检 / 12,175 船 / 517 滞留 / 1,900 ISM 缺陷)——评估一个窗口的风险面直接用它;result.resume 是同数据的结构化形态(还带 non_ism_deficiencies / bans);一行=一次检查,id 键可逐检深查(上游 getInspectionDetail);--ism-company-imo-number / --ism-company-name 可把流收窄到指定管理公司。
transportation paris_mou_low_performance_companies
Paris MoU 低表现 ISM 公司名单
**注意:**名单只含 LOW 档公司——更高风险表现级别不在此面;effect_date 是入榜日期(可远早于当下,首例 2012——长年低表现),expiry_date 为 null=仍在榜;地址列部分为 null。
$ 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" }
}
**怎么读:**一行=一家 ISM 管理公司:公司 IMO 号(7 位零填充,如 0052193)+ 地址 + 国别 + performance / effect_date / status——65 家滚动 6 月窗名单,尽调航运公司风险属性直接用;公司 IMO 键与其他 Paris MoU 面(bans/inspections 的 ISM 列)互查。
transportation thetis_mrv_datasets
EU 船舶排放申报批量件目录(THETIS-MRV)
**注意:**零参数目录面——一次调用返回全部 8 期当前件,无过滤无分页;版本号随上游再生成滚动跳变(本期捕获时 2025 已 v76、2024 已 v254),对账以此清单为准、勿猜文件名;XLSX 本体不经此面下载。
$ 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" }
}
怎么读:一期一行=该申报期当前发布件:版本号+再生成时间+文件名+下载径;reporting_periods 数组给全部在架期(2018–2025);download_path 是相对径——拼 mrv.emsa.europa.eu 主机即文件直链。
transportation us_fmcsa_carriers
美国 FMCSA 承运人全史册(4,528,322 行 53 列——dot_number=CSA/SMS join 硬键;DUNS "0" 哨兵;全史册含停业,非在营册)
参数:
| 旗标 |
必填 |
说明 |
--where |
否 |
原文 SoQL 过滤(上游参数 $where;例 dot_number='963305' 或 legal_name like 'WINSUPPLY%'——dot_number=US 运输合规宇宙硬键(CSA/SMS 直 join),status_code 生命周期('A'=活跃,全史册含停业)任意组合) |
--limit |
否 |
返回行数 1–500(礼让帽,默认 20;Socrata 不回 total 不伪造——语料 4,528,322 骑 reason;53 列视图逐行省 null) |
--offset |
否 |
行偏移 ≥0 |
--order |
否 |
排序列 [ASC |
**注意:**全史册非在册专集:4,528,322 行=活跃+停业承运人(status_code 生命周期,'A'=活跃),筛查退册主体正是价值所在;SoQL 原文通道同契约($where 原文/$limit 1-500/$offset/$order,无 total 回显不伪造)。53 列视图逐行省 null——满载行 ~53 键,裸行更少。walk-away:邻集数据集 4a2k-zf79 已死(403)勿走;SMS Input kjg3-diqy 是邻输入面非本面。TTL 7d(批刷新普查姿态)。
$ 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"
}
**怎么读:*dot_number 是 US 运输合规宇宙的硬键——CSA/SMS 安全绩效系直 join。dun_bradstreet_no = 全库罕见的官方 DUNS 直键(样本行 '0' 是上游占位哨兵→诚实 null 語义照录,非真 DUNS)。双址块:phy_(实际运营址,本例 CO)与 carrier_mailing_(邮寄址,本例 OH——WinSupply 集团总部)常不同,尽调地址以 phy 为运营事实。company_officer_1/2 照录(公开册先例)。车队三型 truck/power/bus units + owntruck,mcs150 里程年窗(2023 年 37,000 英里),hm_ind 危险品旗 + crgo_ 十六货类旗(本例六旗+自述 PLUMPING SUPPLIES)。无安全评级承运人天然缺 safety_rating——列在 view、有值才现(Socrata 逐行省 null)。
使用边界
- CCAR contains 大小写敏感:登记册存显示形原样子串匹配——机主用大写形("AIR CANADA" 269 行 / "Air Canada" 0 行);ADet id 空间有洞,未命中=合法空,id 取自检索行勿猜。
- 目录面(euasl/thetis_mrv)只给坐标:文件 UUID/版本号随上游再公布轮换,对账以清单为准、勿猜文件名;XLSX/PDF 本体走批线不经面下载。