{"current_page":1,"data":[{"id":12467875,"change_date":"2026-07-16 21:42:00","inspection_id":"88428834","dot_number":"4142374","report_state":"IA","report_number":"287R000082","insp_date":"2026-07-16 00:00:00","insp_start_time":"0803","insp_end_time":"0900","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"IA","county_code_state":"IA","county_code":"039","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SCOUT FREIGHT","shipping_paper_number":"258589","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-16 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25680","viol_total":"9","oos_total":"2","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"8","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3768335","transaction_code":"A","transaction_date":"2026-07-16 00:00:00","upload_date":"2026-07-16 00:00:00","upload_first_byte":"0","upload_dot_number":"04142374","upload_search_indicator":null,"census_search_date":"2026-07-16 21:42:00","snet_input_date":"2026-07-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-16 21:42:00","insp_carrier_name":"CONNECTING CARGO USA LLC","insp_carrier_street":"1515 E MAIN STREET","insp_carrier_city":"EAGLE LAKE","insp_carrier_state":"TX","insp_carrier_zip_code":"77434","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-19T09:41:10.000000Z","updated_at":"2026-07-27T09:31:01.000000Z","inspection_violations":[{"id":21706707,"change_date":"2026-07-16 21:42:00","inspection_id":"88428834","insp_violation_id":"275549150","seq_no":"1","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"214650724","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-19T10:04:06.000000Z","updated_at":"2026-07-27T09:43:30.000000Z","normalized_code":"39360D"},{"id":21706708,"change_date":"2026-07-16 21:42:00","inspection_id":"88428834","insp_violation_id":"275549151","seq_no":"2","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"214650724","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-19T10:04:06.000000Z","updated_at":"2026-07-27T09:43:30.000000Z","normalized_code":"39360C"},{"id":21706709,"change_date":"2026-07-16 21:42:00","inspection_id":"88428834","insp_violation_id":"275549152","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"214650724","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-19T10:04:06.000000Z","updated_at":"2026-07-27T09:43:30.000000Z","normalized_code":"39378"},{"id":21706711,"change_date":"2026-07-16 21:42:00","inspection_id":"88428834","insp_violation_id":"275549154","seq_no":"5","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"214650725","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-19T10:04:06.000000Z","updated_at":"2026-07-27T09:43:30.000000Z","normalized_code":"39617CPI"},{"id":21706712,"change_date":"2026-07-16 21:42:00","inspection_id":"88428834","insp_violation_id":"275549155","seq_no":"6","part_no":"393","part_no_section":"11A1-LLPL","insp_viol_unit":"2","insp_unit_id":"214650725","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-19T10:04:06.000000Z","updated_at":"2026-07-27T09:43:30.000000Z","normalized_code":"39311A1LLPL"},{"id":21706713,"change_date":"2026-07-16 21:42:00","inspection_id":"88428834","insp_violation_id":"275549156","seq_no":"7","part_no":"393","part_no_section":"48A-BIHE","insp_viol_unit":"2","insp_unit_id":"214650725","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-19T10:04:06.000000Z","updated_at":"2026-07-27T09:43:30.000000Z","normalized_code":"39348ABIHE"},{"id":21706714,"change_date":"2026-07-16 21:42:00","inspection_id":"88428834","insp_violation_id":"275549157","seq_no":"8","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"2","insp_unit_id":"214650725","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-07-19T10:04:06.000000Z","updated_at":"2026-07-27T09:43:30.000000Z","normalized_code":"3963A1BOS"},{"id":21706715,"change_date":"2026-07-16 21:42:00","inspection_id":"88428834","insp_violation_id":"275549158","seq_no":"9","part_no":"395","part_no_section":"8A1-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-19T10:04:06.000000Z","updated_at":"2026-07-27T09:43:30.000000Z","normalized_code":"3958A1HOSP"},{"id":21706710,"change_date":"2026-07-16 21:42:00","inspection_id":"88428834","insp_violation_id":"275549153","seq_no":"4","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"214650724","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-19T10:04:06.000000Z","updated_at":"2026-07-27T09:43:30.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":21655437,"change_date":"2026-07-16 21:42:00","inspection_id":"88428834","insp_unit_id":"214650724","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"11","insp_unit_license":"WRX2036","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C6UR5FL0PG612119","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-19T09:20:27.000000Z","updated_at":"2026-07-27T09:02:38.000000Z"},{"id":21655438,"change_date":"2026-07-16 21:42:00","inspection_id":"88428834","insp_unit_id":"214650725","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"P J TRAILE","insp_unit_company":"01","insp_unit_license":"221743N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4P53F4927T1429325","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-19T09:20:27.000000Z","updated_at":"2026-07-27T09:02:38.000000Z"}]},{"id":12183144,"change_date":"2026-08-20 21:49:00","inspection_id":"88138580","dot_number":"4142374","report_state":"AL","report_number":"1303000231","insp_date":"2026-06-13 00:00:00","insp_start_time":"1057","insp_end_time":"1210","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"STEELE AL","county_code_state":"AL","county_code":null,"insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"FLOWSERVE CORPORATION","shipping_paper_number":"76815","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-14 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"28190","viol_total":"16","oos_total":"6","driver_viol_total":"5","driver_oos_total":"4","vehicle_viol_total":"11","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3538269","transaction_code":"C","transaction_date":"2026-06-13 00:00:00","upload_date":"2026-08-20 00:00:00","upload_first_byte":"0","upload_dot_number":"04142374","upload_search_indicator":null,"census_search_date":"2026-06-14 21:33:00","snet_input_date":"2026-06-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-14 21:33:00","insp_carrier_name":"CONNECTING CARGO USA LLC","insp_carrier_street":"1515 E MAIN STREET","insp_carrier_city":"EAGLE LAKE","insp_carrier_state":"TX","insp_carrier_zip_code":"77434","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-17T09:41:46.000000Z","updated_at":"2026-08-23T09:38:28.000000Z","inspection_violations":[{"id":21203414,"change_date":"2026-08-20 21:49:00","inspection_id":"88138580","insp_violation_id":"276235556","seq_no":"5","part_no":"395","part_no_section":"8A1-HOSP","insp_viol_unit":"D","insp_unit_id":"214649847","insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"U6745472","created_at":"2026-06-17T10:01:50.000000Z","updated_at":"2026-08-23T09:55:01.000000Z","normalized_code":"3958A1HOSP"},{"id":21203417,"change_date":"2026-08-20 21:49:00","inspection_id":"88138580","insp_violation_id":"276235559","seq_no":"8","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"215248599","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-17T10:01:50.000000Z","updated_at":"2026-08-23T09:55:01.000000Z","normalized_code":"39021TB1MC"},{"id":21203418,"change_date":"2026-08-20 21:49:00","inspection_id":"88138580","insp_violation_id":"276235560","seq_no":"9","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"215248599","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"U6745472","created_at":"2026-06-17T10:01:50.000000Z","updated_at":"2026-08-23T09:55:01.000000Z","normalized_code":"39021TB2DOT"},{"id":21203419,"change_date":"2026-08-20 21:49:00","inspection_id":"88138580","insp_violation_id":"276235561","seq_no":"10","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"215248599","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"NV0145265","created_at":"2026-06-17T10:01:50.000000Z","updated_at":"2026-08-23T09:55:01.000000Z","normalized_code":"3922SLLIFTA"},{"id":21203420,"change_date":"2026-08-20 21:49:00","inspection_id":"88138580","insp_violation_id":"276235562","seq_no":"11","part_no":"392","part_no_section":"2-SLLIRP","insp_viol_unit":"1","insp_unit_id":"215248599","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-17T10:01:50.000000Z","updated_at":"2026-08-23T09:55:01.000000Z","normalized_code":"3922SLLIRP"},{"id":21203421,"change_date":"2026-08-20 21:49:00","inspection_id":"88138580","insp_violation_id":"276235563","seq_no":"12","part_no":"393","part_no_section":"9A-LTSIR","insp_viol_unit":"1","insp_unit_id":"215248599","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-17T10:01:50.000000Z","updated_at":"2026-08-23T09:55:01.000000Z","normalized_code":"3939ALTSIR"},{"id":21203422,"change_date":"2026-08-20 21:49:00","inspection_id":"88138580","insp_violation_id":"276235564","seq_no":"13","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"215248599","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-17T10:01:50.000000Z","updated_at":"2026-08-23T09:55:01.000000Z","normalized_code":"39395A1"},{"id":21203423,"change_date":"2026-08-20 21:49:00","inspection_id":"88138580","insp_violation_id":"276235565","seq_no":"14","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"215248599","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-17T10:01:50.000000Z","updated_at":"2026-08-23T09:55:01.000000Z","normalized_code":"39395F"},{"id":21203424,"change_date":"2026-08-20 21:49:00","inspection_id":"88138580","insp_violation_id":"276235566","seq_no":"15","part_no":"393","part_no_section":"75B-TF","insp_viol_unit":"1","insp_unit_id":"215248599","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-06-17T10:01:50.000000Z","updated_at":"2026-08-23T09:55:01.000000Z","normalized_code":"39375BTF"},{"id":21203412,"change_date":"2026-08-20 21:49:00","inspection_id":"88138580","insp_violation_id":"276235554","seq_no":"3","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"215248599","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"U6745471","created_at":"2026-06-17T10:01:50.000000Z","updated_at":"2026-08-23T09:55:01.000000Z","normalized_code":"39617CPI"},{"id":21203425,"change_date":"2026-08-20 21:49:00","inspection_id":"88138580","insp_violation_id":"276235567","seq_no":"16","part_no":"393","part_no_section":"205C-WR","insp_viol_unit":"2","insp_unit_id":"215248600","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-06-17T10:01:50.000000Z","updated_at":"2026-08-23T09:55:01.000000Z","normalized_code":"393205CWR"},{"id":21203416,"change_date":"2026-08-20 21:49:00","inspection_id":"88138580","insp_violation_id":"276235558","seq_no":"7","part_no":"391","part_no_section":"11B2-Q","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"54","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"U6745471","created_at":"2026-06-17T10:01:50.000000Z","updated_at":"2026-08-23T09:55:01.000000Z","normalized_code":"39111B2Q"},{"id":21203410,"change_date":"2026-08-20 21:49:00","inspection_id":"88138580","insp_violation_id":"276235552","seq_no":"1","part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"U6745469","created_at":"2026-06-17T10:01:50.000000Z","updated_at":"2026-08-23T09:55:01.000000Z","normalized_code":"38323A2LCDLN"},{"id":21203413,"change_date":"2026-08-20 21:49:00","inspection_id":"88138580","insp_violation_id":"276235555","seq_no":"4","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"215248600","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-17T10:01:50.000000Z","updated_at":"2026-08-23T09:55:01.000000Z","normalized_code":"39617CPI"},{"id":21203415,"change_date":"2026-08-20 21:49:00","inspection_id":"88138580","insp_violation_id":"276235557","seq_no":"6","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":"214649847","insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"U6745470","created_at":"2026-06-17T10:01:50.000000Z","updated_at":"2026-08-23T09:55:01.000000Z","normalized_code":"39141APC"},{"id":21203411,"change_date":"2026-08-20 21:49:00","inspection_id":"88138580","insp_violation_id":"276235553","seq_no":"2","part_no":"392","part_no_section":"8-D","insp_viol_unit":"D","insp_unit_id":"215028755","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"U6745470","created_at":"2026-06-17T10:01:50.000000Z","updated_at":"2026-08-23T09:55:01.000000Z","normalized_code":"3928D"}],"inspection_per_units":[{"id":21161525,"change_date":"2026-08-20 21:49:00","inspection_id":"88138580","insp_unit_id":"215248599","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":"3380","insp_unit_license":"TMP58CNF","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3D73Y4CL5BG553380","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-17T09:18:57.000000Z","updated_at":"2026-08-23T09:14:06.000000Z"},{"id":21161526,"change_date":"2026-08-20 21:49:00","inspection_id":"88138580","insp_unit_id":"215248600","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":"7742","insp_unit_license":"052128N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4P53F4929S1417742","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-17T09:18:57.000000Z","updated_at":"2026-08-23T09:14:06.000000Z"}]},{"id":12163405,"change_date":"2026-08-07 21:40:00","inspection_id":"88113335","dot_number":"4142374","report_state":"AL","report_number":"1440004647","insp_date":"2026-06-10 00:00:00","insp_start_time":"0443","insp_end_time":"0656","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"GOOD HOPE AL","county_code_state":"AL","county_code":"043","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"CURB TECHNOLOGIES","shipping_paper_number":"0367533","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-11 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"22000","viol_total":"16","oos_total":"4","driver_viol_total":"4","driver_oos_total":"2","vehicle_viol_total":"12","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3523723","transaction_code":"C","transaction_date":"2026-06-11 00:00:00","upload_date":"2026-08-07 00:00:00","upload_first_byte":"0","upload_dot_number":"04142374","upload_search_indicator":null,"census_search_date":"2026-06-11 21:42:00","snet_input_date":"2026-06-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-11 21:42:00","insp_carrier_name":"CONNECTING CARGO USA LLC","insp_carrier_street":"1515 E MAIN STREET","insp_carrier_city":"EAGLE LAKE","insp_carrier_state":"TX","insp_carrier_zip_code":"77434","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-15T09:41:36.000000Z","updated_at":"2026-08-18T09:30:03.000000Z","inspection_violations":[{"id":21168793,"change_date":"2026-08-07 21:40:00","inspection_id":"88113335","insp_violation_id":"275983833","seq_no":"3","part_no":"395","part_no_section":"8A1-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"U8234761","created_at":"2026-06-15T10:03:10.000000Z","updated_at":"2026-08-19T09:39:13.000000Z","normalized_code":"3958A1HOSP"},{"id":21168794,"change_date":"2026-08-07 21:40:00","inspection_id":"88113335","insp_violation_id":"275983834","seq_no":"4","part_no":"392","part_no_section":"2-SLLED","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"U8234762","created_at":"2026-06-15T10:03:10.000000Z","updated_at":"2026-08-19T09:39:13.000000Z","normalized_code":"3922SLLED"},{"id":21168795,"change_date":"2026-08-07 21:40:00","inspection_id":"88113335","insp_violation_id":"275983835","seq_no":"5","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"215028924","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-15T10:03:10.000000Z","updated_at":"2026-08-19T09:39:13.000000Z","normalized_code":"39021TB1MC"},{"id":21168796,"change_date":"2026-08-07 21:40:00","inspection_id":"88113335","insp_violation_id":"275983836","seq_no":"6","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"215028924","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-15T10:03:10.000000Z","updated_at":"2026-08-19T09:39:13.000000Z","normalized_code":"39021TB2DOT"},{"id":21168797,"change_date":"2026-08-07 21:40:00","inspection_id":"88113335","insp_violation_id":"275983837","seq_no":"7","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"215028924","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-15T10:03:10.000000Z","updated_at":"2026-08-19T09:39:13.000000Z","normalized_code":"39378AWS"},{"id":21168803,"change_date":"2026-08-07 21:40:00","inspection_id":"88113335","insp_violation_id":"275983843","seq_no":"13","part_no":"392","part_no_section":"2-SLLML","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"~W002941","created_at":"2026-06-15T10:03:10.000000Z","updated_at":"2026-08-19T09:39:13.000000Z","normalized_code":"3922SLLML"},{"id":21168800,"change_date":"2026-08-07 21:40:00","inspection_id":"88113335","insp_violation_id":"275983840","seq_no":"10","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"215028924","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-15T10:03:10.000000Z","updated_at":"2026-08-19T09:39:13.000000Z","normalized_code":"3922SLLSR"},{"id":21168801,"change_date":"2026-08-07 21:40:00","inspection_id":"88113335","insp_violation_id":"275983841","seq_no":"11","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"2","insp_unit_id":"215028925","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-06-15T10:03:10.000000Z","updated_at":"2026-08-19T09:39:13.000000Z","normalized_code":"3939ALTSI"},{"id":21168802,"change_date":"2026-08-07 21:40:00","inspection_id":"88113335","insp_violation_id":"275983842","seq_no":"12","part_no":"393","part_no_section":"80A","insp_viol_unit":"1","insp_unit_id":"215028924","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-15T10:03:10.000000Z","updated_at":"2026-08-19T09:39:13.000000Z","normalized_code":"39380A"},{"id":21168804,"change_date":"2026-08-07 21:40:00","inspection_id":"88113335","insp_violation_id":"275983844","seq_no":"14","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"215028924","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-15T10:03:10.000000Z","updated_at":"2026-08-19T09:39:13.000000Z","normalized_code":"3922SLLSR"},{"id":21168798,"change_date":"2026-08-07 21:40:00","inspection_id":"88113335","insp_violation_id":"275983838","seq_no":"8","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"215028924","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-15T10:03:10.000000Z","updated_at":"2026-08-19T09:39:13.000000Z","normalized_code":"39395F"},{"id":21168805,"change_date":"2026-08-07 21:40:00","inspection_id":"88113335","insp_violation_id":"275983845","seq_no":"15","part_no":"393","part_no_section":"104B-C","insp_viol_unit":"2","insp_unit_id":"215028925","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-15T10:03:10.000000Z","updated_at":"2026-08-19T09:39:13.000000Z","normalized_code":"393104BC"},{"id":21168799,"change_date":"2026-08-07 21:40:00","inspection_id":"88113335","insp_violation_id":"275983839","seq_no":"9","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"215028924","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-15T10:03:10.000000Z","updated_at":"2026-08-19T09:39:13.000000Z","normalized_code":"39617CPI"},{"id":21168791,"change_date":"2026-08-07 21:40:00","inspection_id":"88113335","insp_violation_id":"275983831","seq_no":"1","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"U8234760","created_at":"2026-06-15T10:03:10.000000Z","updated_at":"2026-08-19T09:39:13.000000Z","normalized_code":"39141APC"},{"id":21168792,"change_date":"2026-08-07 21:40:00","inspection_id":"88113335","insp_violation_id":"275983832","seq_no":"2","part_no":"393","part_no_section":"43DBMA","insp_viol_unit":"2","insp_unit_id":"215028925","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-06-15T10:03:10.000000Z","updated_at":"2026-08-19T09:39:13.000000Z","normalized_code":"39343DBMA"},{"id":21168806,"change_date":"2026-08-07 21:40:00","inspection_id":"88113335","insp_violation_id":"275983846","seq_no":"16","part_no":"393","part_no_section":"87A-FPLA","insp_viol_unit":"2","insp_unit_id":"215028925","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-15T10:03:10.000000Z","updated_at":"2026-08-19T09:39:13.000000Z","normalized_code":"39387AFPLA"}],"inspection_per_units":[{"id":21128122,"change_date":"2026-08-07 21:40:00","inspection_id":"88113335","insp_unit_id":"215028925","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAILMAX","insp_unit_company":"V2295","insp_unit_license":"YBV9581","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"7WL3H4026ST002295","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-15T09:19:31.000000Z","updated_at":"2026-08-18T09:00:56.000000Z"},{"id":21128121,"change_date":"2026-08-07 21:40:00","inspection_id":"88113335","insp_unit_id":"215028924","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":"V6054","insp_unit_license":"YBV9581","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C6UR5DL5GG336054","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-15T09:19:31.000000Z","updated_at":"2026-08-18T09:00:56.000000Z"}]},{"id":11894917,"change_date":"2026-05-13 21:42:00","inspection_id":"87833292","dot_number":"4142374","report_state":"NE","report_number":"T351000047","insp_date":"2026-05-13 00:00:00","insp_start_time":"0830","insp_end_time":"0932","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"KEARNEY NE","county_code_state":"NE","county_code":"019","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"PRESTON RENTALS LLC","shipping_paper_number":"32560678","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"24680","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3312572","transaction_code":"A","transaction_date":"2026-05-13 00:00:00","upload_date":"2026-05-13 00:00:00","upload_first_byte":"0","upload_dot_number":"04142374","upload_search_indicator":null,"census_search_date":"2026-05-13 21:42:00","snet_input_date":"2026-05-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-13 21:42:00","insp_carrier_name":"CONNECTING CARGO USA LLC","insp_carrier_street":"2918 W GRAND PWY N STE 150","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77449","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-15T12:26:52.000000Z","updated_at":"2026-05-24T09:31:02.000000Z","inspection_violations":[{"id":20690099,"change_date":"2026-05-13 21:42:00","inspection_id":"87833292","insp_violation_id":"274223086","seq_no":"2","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"EB5600402C09","created_at":"2026-05-15T12:59:07.000000Z","updated_at":"2026-05-24T09:44:26.000000Z","normalized_code":"3922SLL"},{"id":20690098,"change_date":"2026-05-13 21:42:00","inspection_id":"87833292","insp_violation_id":"274223085","seq_no":"1","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-15T12:59:07.000000Z","updated_at":"2026-05-24T09:44:26.000000Z","normalized_code":"3922SLL"}],"inspection_per_units":[{"id":20680670,"change_date":"2026-05-13 21:42:00","inspection_id":"87833292","insp_unit_id":"213523744","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"DODGE CHRY","insp_unit_company":"001","insp_unit_license":"WRX2036","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C6UR5FL0PG612119","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-15T12:13:32.000000Z","updated_at":"2026-05-24T09:04:07.000000Z"},{"id":20680671,"change_date":"2026-05-13 21:42:00","inspection_id":"87833292","insp_unit_id":"213523745","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"P.J. TRAIL","insp_unit_company":"001","insp_unit_license":"221743N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4P53F4927T1429325","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-15T12:13:32.000000Z","updated_at":"2026-05-24T09:04:07.000000Z"}]},{"id":11904550,"change_date":"2026-05-14 21:42:00","inspection_id":"87843511","dot_number":"4142374","report_state":"CO","report_number":"1678490021","insp_date":"2026-05-12 00:00:00","insp_start_time":"1211","insp_end_time":"1300","registration_date":null,"region":"MD","ci_status_code":"C","location":null,"location_desc":"VAIL CO","county_code_state":"CO","county_code":"037","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"PRESTON RENTALS LLC","shipping_paper_number":"NV-000921","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-14 21:42:00","post_acc_ind":"Y","gross_comb_veh_wt":"25680","viol_total":"3","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3317536","transaction_code":"A","transaction_date":"2026-05-13 00:00:00","upload_date":"2026-05-14 00:00:00","upload_first_byte":"0","upload_dot_number":"04142374","upload_search_indicator":null,"census_search_date":"2026-05-14 21:42:00","snet_input_date":"2026-05-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-14 21:42:00","insp_carrier_name":"CONNECTING CARGO USA LLC","insp_carrier_street":"1515 E MAIN STREET","insp_carrier_city":"EAGLE LAKE","insp_carrier_state":"TX","insp_carrier_zip_code":"77434","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-16T13:32:48.000000Z","updated_at":"2026-05-25T09:30:46.000000Z","inspection_violations":[{"id":20708134,"change_date":"2026-05-14 21:42:00","inspection_id":"87843511","insp_violation_id":"274247972","seq_no":"3","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"6571144","created_at":"2026-05-16T13:12:43.000000Z","updated_at":"2026-05-25T09:42:24.000000Z","normalized_code":"3922SLL"},{"id":20708132,"change_date":"2026-05-14 21:42:00","inspection_id":"87843511","insp_violation_id":"274247970","seq_no":"1","part_no":"392","part_no_section":"2-INAT","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"6571144","created_at":"2026-05-16T13:12:43.000000Z","updated_at":"2026-05-25T09:42:24.000000Z","normalized_code":"3922INAT"},{"id":20708133,"change_date":"2026-05-14 21:42:00","inspection_id":"87843511","insp_violation_id":"274247971","seq_no":"2","part_no":"392","part_no_section":"16-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"6571144","created_at":"2026-05-16T13:12:43.000000Z","updated_at":"2026-05-25T09:42:24.000000Z","normalized_code":"39216D"}],"inspection_per_units":[{"id":20696188,"change_date":"2026-05-14 21:42:00","inspection_id":"87843511","insp_unit_id":"213543723","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"NONE","insp_unit_license":"WRX2036","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C6UR5FL0PG612119","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-16T12:44:40.000000Z","updated_at":"2026-05-25T09:03:04.000000Z"},{"id":20696189,"change_date":"2026-05-14 21:42:00","inspection_id":"87843511","insp_unit_id":"213543724","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"PJ TRAILER","insp_unit_company":"11","insp_unit_license":"221743N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4P53F4927T1429325","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-16T12:44:40.000000Z","updated_at":"2026-05-25T09:03:04.000000Z"}]},{"id":11830798,"change_date":"2026-05-05 21:40:00","inspection_id":"87765868","dot_number":"4142374","report_state":"TX","report_number":"V262313138","insp_date":"2026-05-04 00:00:00","insp_start_time":"0745","insp_end_time":"0833","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"11134  TX35","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BRIGHTON HEAD TRU-DEGE","shipping_paper_number":"80072738","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-05-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25680","viol_total":"14","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"14","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9944186","transaction_code":"A","transaction_date":"2026-05-05 00:00:00","upload_date":"2026-05-05 00:00:00","upload_first_byte":"0","upload_dot_number":"04142374","upload_search_indicator":"M","census_search_date":"2026-05-05 21:40:00","snet_input_date":"2026-05-04 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-05-05 21:40:00","insp_carrier_name":"CONNECTING CARGO USA LLC","insp_carrier_street":"1515 E MAIN STREET","insp_carrier_city":"EAGLE LAKE","insp_carrier_state":"TX","insp_carrier_zip_code":"77434","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1083591","created_at":"2026-05-08T09:40:35.000000Z","updated_at":"2026-05-15T12:19:02.000000Z","inspection_violations":[{"id":20574768,"change_date":"2026-05-05 21:40:00","inspection_id":"87765868","insp_violation_id":"274063996","seq_no":"1","part_no":"393","part_no_section":"43D","insp_viol_unit":"2","insp_unit_id":"213394801","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2026-05-08T10:01:42.000000Z","updated_at":"2026-05-15T12:44:09.000000Z","normalized_code":"39343D"},{"id":20574769,"change_date":"2026-05-05 21:40:00","inspection_id":"87765868","insp_violation_id":"274063997","seq_no":"2","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"213394800","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-08T10:01:42.000000Z","updated_at":"2026-05-15T12:44:09.000000Z","normalized_code":"39360D"},{"id":20574770,"change_date":"2026-05-05 21:40:00","inspection_id":"87765868","insp_violation_id":"274063998","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"213394800","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-08T10:01:42.000000Z","updated_at":"2026-05-15T12:44:09.000000Z","normalized_code":"39378"},{"id":20574771,"change_date":"2026-05-05 21:40:00","inspection_id":"87765868","insp_violation_id":"274063999","seq_no":"4","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"213394801","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-08T10:01:42.000000Z","updated_at":"2026-05-15T12:44:09.000000Z","normalized_code":"3939"},{"id":20574772,"change_date":"2026-05-05 21:40:00","inspection_id":"87765868","insp_violation_id":"274064000","seq_no":"5","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"213394801","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-08T10:01:42.000000Z","updated_at":"2026-05-15T12:44:09.000000Z","normalized_code":"3939"},{"id":20574773,"change_date":"2026-05-05 21:40:00","inspection_id":"87765868","insp_violation_id":"274064001","seq_no":"6","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"213394801","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-08T10:01:42.000000Z","updated_at":"2026-05-15T12:44:09.000000Z","normalized_code":"3939"},{"id":20574774,"change_date":"2026-05-05 21:40:00","inspection_id":"87765868","insp_violation_id":"274064002","seq_no":"7","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"213394801","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-08T10:01:42.000000Z","updated_at":"2026-05-15T12:44:09.000000Z","normalized_code":"3939"},{"id":20574775,"change_date":"2026-05-05 21:40:00","inspection_id":"87765868","insp_violation_id":"274064003","seq_no":"8","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"213394801","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-08T10:01:42.000000Z","updated_at":"2026-05-15T12:44:09.000000Z","normalized_code":"3939"},{"id":20574776,"change_date":"2026-05-05 21:40:00","inspection_id":"87765868","insp_violation_id":"274064004","seq_no":"9","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"213394800","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-08T10:01:42.000000Z","updated_at":"2026-05-15T12:44:09.000000Z","normalized_code":"39395A"},{"id":20574777,"change_date":"2026-05-05 21:40:00","inspection_id":"87765868","insp_violation_id":"274064005","seq_no":"10","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"213394800","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-08T10:01:42.000000Z","updated_at":"2026-05-15T12:44:09.000000Z","normalized_code":"39395F"},{"id":20574778,"change_date":"2026-05-05 21:40:00","inspection_id":"87765868","insp_violation_id":"274064006","seq_no":"11","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"213394800","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-08T10:01:42.000000Z","updated_at":"2026-05-15T12:44:09.000000Z","normalized_code":"39395F"},{"id":20574779,"change_date":"2026-05-05 21:40:00","inspection_id":"87765868","insp_violation_id":"274064007","seq_no":"12","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"213394801","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-08T10:01:42.000000Z","updated_at":"2026-05-15T12:44:09.000000Z","normalized_code":"39617C"},{"id":20574780,"change_date":"2026-05-05 21:40:00","inspection_id":"87765868","insp_violation_id":"274064008","seq_no":"13","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"213394800","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-08T10:01:42.000000Z","updated_at":"2026-05-15T12:44:09.000000Z","normalized_code":"39617C"},{"id":20574781,"change_date":"2026-05-05 21:40:00","inspection_id":"87765868","insp_violation_id":"274064009","seq_no":"14","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"2","insp_unit_id":"213394801","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2026-05-08T10:01:42.000000Z","updated_at":"2026-05-15T12:44:09.000000Z","normalized_code":"3963A1BOS"}],"inspection_per_units":[{"id":20575598,"change_date":"2026-05-05 21:40:00","inspection_id":"87765868","insp_unit_id":"213394800","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"1","insp_unit_license":"WRX2036","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C6UR5FL0PG612119","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-08T09:18:32.000000Z","updated_at":"2026-05-15T11:58:31.000000Z"},{"id":20575599,"change_date":"2026-05-05 21:40:00","inspection_id":"87765868","insp_unit_id":"213394801","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PJTM","insp_unit_company":"11","insp_unit_license":"221743N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4P53F4927T1429325","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-08T09:18:32.000000Z","updated_at":"2026-05-15T11:58:31.000000Z"}]},{"id":11751751,"change_date":"2026-04-26 21:33:00","inspection_id":"87681623","dot_number":"4142374","report_state":"OH","report_number":"1251001190","insp_date":"2026-04-24 00:00:00","insp_start_time":"1145","insp_end_time":"1245","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"NEW SPRINGFIELD OH","county_code_state":"OH","county_code":"099","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"RITCHE BROS","shipping_paper_number":"85398","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-04-26 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"25860","viol_total":"14","oos_total":"2","driver_viol_total":"5","driver_oos_total":"1","vehicle_viol_total":"9","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3214460","transaction_code":"A","transaction_date":"2026-04-25 00:00:00","upload_date":"2026-04-26 00:00:00","upload_first_byte":"0","upload_dot_number":"04142374","upload_search_indicator":null,"census_search_date":"2026-04-26 21:33:00","snet_input_date":"2026-04-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-26 21:33:00","insp_carrier_name":"CONNECTING CARGO USA LLC","insp_carrier_street":"1515 E MAIN STREET","insp_carrier_city":"EAGLE LAKE","insp_carrier_state":"TX","insp_carrier_zip_code":"77434","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-29T09:40:12.000000Z","updated_at":"2026-05-07T09:30:08.000000Z","inspection_violations":[{"id":20432893,"change_date":"2026-04-26 21:33:00","inspection_id":"87681623","insp_violation_id":"273861892","seq_no":"3","part_no":"395","part_no_section":"8E-HOSPDOOS","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-29T10:00:01.000000Z","updated_at":"2026-05-07T09:39:16.000000Z","normalized_code":"3958EHOSPDOOS"},{"id":20432891,"change_date":"2026-04-26 21:33:00","inspection_id":"87681623","insp_violation_id":"273861890","seq_no":"1","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"213231499","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-29T10:00:01.000000Z","updated_at":"2026-05-07T09:39:16.000000Z","normalized_code":"39021TB1MC"},{"id":20432894,"change_date":"2026-04-26 21:33:00","inspection_id":"87681623","insp_violation_id":"273861893","seq_no":"4","part_no":"395","part_no_section":"8E-HOSPDOOS","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-29T10:00:01.000000Z","updated_at":"2026-05-07T09:39:16.000000Z","normalized_code":"3958EHOSPDOOS"},{"id":20432896,"change_date":"2026-04-26 21:33:00","inspection_id":"87681623","insp_violation_id":"273861895","seq_no":"6","part_no":"395","part_no_section":"8E-HOSPDOOS","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-29T10:00:01.000000Z","updated_at":"2026-05-07T09:39:16.000000Z","normalized_code":"3958EHOSPDOOS"},{"id":20432897,"change_date":"2026-04-26 21:33:00","inspection_id":"87681623","insp_violation_id":"273861896","seq_no":"7","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"213231499","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-29T10:00:01.000000Z","updated_at":"2026-05-07T09:39:16.000000Z","normalized_code":"39360D"},{"id":20432898,"change_date":"2026-04-26 21:33:00","inspection_id":"87681623","insp_violation_id":"273861897","seq_no":"8","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"213231499","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-29T10:00:01.000000Z","updated_at":"2026-05-07T09:39:16.000000Z","normalized_code":"39395A1"},{"id":20432899,"change_date":"2026-04-26 21:33:00","inspection_id":"87681623","insp_violation_id":"273861898","seq_no":"9","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"2","insp_unit_id":"213231500","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-29T10:00:01.000000Z","updated_at":"2026-05-07T09:39:16.000000Z","normalized_code":"3939ALCL"},{"id":20432900,"change_date":"2026-04-26 21:33:00","inspection_id":"87681623","insp_violation_id":"273861899","seq_no":"10","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"2","insp_unit_id":"213231500","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-29T10:00:01.000000Z","updated_at":"2026-05-07T09:39:16.000000Z","normalized_code":"3939ALSLI"},{"id":20432901,"change_date":"2026-04-26 21:33:00","inspection_id":"87681623","insp_violation_id":"273861900","seq_no":"11","part_no":"393","part_no_section":"43DBMA","insp_viol_unit":"2","insp_unit_id":"213231500","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-04-29T10:00:01.000000Z","updated_at":"2026-05-07T09:39:16.000000Z","normalized_code":"39343DBMA"},{"id":20432902,"change_date":"2026-04-26 21:33:00","inspection_id":"87681623","insp_violation_id":"273861901","seq_no":"12","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"213231499","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-29T10:00:01.000000Z","updated_at":"2026-05-07T09:39:16.000000Z","normalized_code":"39395F"},{"id":20432903,"change_date":"2026-04-26 21:33:00","inspection_id":"87681623","insp_violation_id":"273861902","seq_no":"13","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"213231500","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-29T10:00:01.000000Z","updated_at":"2026-05-07T09:39:16.000000Z","normalized_code":"3939ALIL"},{"id":20432904,"change_date":"2026-04-26 21:33:00","inspection_id":"87681623","insp_violation_id":"273861903","seq_no":"14","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"2","insp_unit_id":"213231500","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-29T10:00:01.000000Z","updated_at":"2026-05-07T09:39:16.000000Z","normalized_code":"3939ALLPL"},{"id":20432892,"change_date":"2026-04-26 21:33:00","inspection_id":"87681623","insp_violation_id":"273861891","seq_no":"2","part_no":"395","part_no_section":"8E-HOSPDOOS","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-29T10:00:01.000000Z","updated_at":"2026-05-07T09:39:16.000000Z","normalized_code":"3958EHOSPDOOS"},{"id":20432895,"change_date":"2026-04-26 21:33:00","inspection_id":"87681623","insp_violation_id":"273861894","seq_no":"5","part_no":"395","part_no_section":"8E-HOSPDOOS","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-29T10:00:01.000000Z","updated_at":"2026-05-07T09:39:16.000000Z","normalized_code":"3958EHOSPDOOS"}],"inspection_per_units":[{"id":20446479,"change_date":"2026-04-26 21:33:00","inspection_id":"87681623","insp_unit_id":"213231499","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":"11","insp_unit_license":"WRX2036","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C6UR5FL0PG612119","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-29T09:17:43.000000Z","updated_at":"2026-05-07T09:02:06.000000Z"},{"id":20446480,"change_date":"2026-04-26 21:33:00","inspection_id":"87681623","insp_unit_id":"213231500","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNKNOWN","insp_unit_company":"11","insp_unit_license":"221743N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4P53F4927T1429325","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-29T09:17:43.000000Z","updated_at":"2026-05-07T09:02:06.000000Z"}]},{"id":11709399,"change_date":"2026-04-21 21:39:00","inspection_id":"87636285","dot_number":"4142374","report_state":"KY","report_number":"CV43095684","insp_date":"2026-04-21 00:00:00","insp_start_time":"1134","insp_end_time":"1215","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"LONDON","county_code_state":"KY","county_code":"125","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"CONNECTING CARGO USA LLC","shipping_paper_number":"9963","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"5","oos_total":"2","driver_viol_total":"3","driver_oos_total":"2","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2341557","transaction_code":"A","transaction_date":"2026-04-21 00:00:00","upload_date":"2026-04-21 00:00:00","upload_first_byte":"0","upload_dot_number":"04142374","upload_search_indicator":"M","census_search_date":"2026-04-21 21:39:00","snet_input_date":"2026-04-21 00:00:00","source_office":"2KYS001","mcmis_add_date":"2026-04-21 21:39:00","insp_carrier_name":"CONNECTING CARGO USA LLC","insp_carrier_street":"1515 E MAIN STREET","insp_carrier_city":"EAGLE LAKE","insp_carrier_state":"TX","insp_carrier_zip_code":"77434","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:37:50.000000Z","updated_at":"2026-05-02T09:30:54.000000Z","inspection_violations":[{"id":20350898,"change_date":"2026-04-21 21:39:00","inspection_id":"87636285","insp_violation_id":"273749647","seq_no":"2","part_no":"391","part_no_section":"11B2-Q","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"54","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":"FG87415","created_at":"2026-04-27T09:55:14.000000Z","updated_at":"2026-05-02T09:42:56.000000Z","normalized_code":"39111B2Q"},{"id":20350897,"change_date":"2026-04-21 21:39:00","inspection_id":"87636285","insp_violation_id":"273749646","seq_no":"1","part_no":"392","part_no_section":"2-SLLSIV","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:55:14.000000Z","updated_at":"2026-05-02T09:42:56.000000Z","normalized_code":"3922SLLSIV"},{"id":20350900,"change_date":"2026-04-21 21:39:00","inspection_id":"87636285","insp_violation_id":"273749649","seq_no":"4","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"213137739","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:55:14.000000Z","updated_at":"2026-05-02T09:42:56.000000Z","normalized_code":"39021TB1MC"},{"id":20350901,"change_date":"2026-04-21 21:39:00","inspection_id":"87636285","insp_violation_id":"273749650","seq_no":"5","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"213137739","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:55:14.000000Z","updated_at":"2026-05-02T09:42:56.000000Z","normalized_code":"3922SLLSR"},{"id":20350899,"change_date":"2026-04-21 21:39:00","inspection_id":"87636285","insp_violation_id":"273749648","seq_no":"3","part_no":"395","part_no_section":"8K2-HOSRC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2026-04-27T09:55:14.000000Z","updated_at":"2026-05-02T09:42:56.000000Z","normalized_code":"3958K2HOSRC"}],"inspection_per_units":[{"id":20376734,"change_date":"2026-04-21 21:39:00","inspection_id":"87636285","insp_unit_id":"213137739","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":null,"insp_unit_license":"WVW9884","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C63RRGL0SG570769","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:14:10.000000Z","updated_at":"2026-05-02T09:03:17.000000Z"},{"id":20376735,"change_date":"2026-04-21 21:39:00","inspection_id":"87636285","insp_unit_id":"213137740","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"128319N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"7WL3H4022ST00205","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:14:10.000000Z","updated_at":"2026-05-02T09:03:17.000000Z"}]},{"id":11083461,"change_date":"2026-02-09 21:38:00","inspection_id":"86994751","dot_number":"4142374","report_state":"OK","report_number":"PB10154477","insp_date":"2026-02-05 00:00:00","insp_start_time":"0840","insp_end_time":"0945","registration_date":null,"region":"CT","ci_status_code":"C","location":"09040","location_desc":"EL RENO SCALES","county_code_state":"OK","county_code":"017","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"US FLOW","shipping_paper_number":"SO-21058","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-09 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"21885","viol_total":"4","oos_total":"2","driver_viol_total":"2","driver_oos_total":"2","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"811506","transaction_code":"A","transaction_date":"2026-02-05 00:00:00","upload_date":"2026-02-09 00:00:00","upload_first_byte":"0","upload_dot_number":"04142374","upload_search_indicator":null,"census_search_date":"2026-02-09 21:38:00","snet_input_date":"2026-02-05 00:00:00","source_office":"2OKS001","mcmis_add_date":"2026-02-09 21:38:00","insp_carrier_name":"CONNECTING CARGO USA LLC","insp_carrier_street":"1515 E MAIN STREET","insp_carrier_city":"EAGLE LAKE","insp_carrier_state":"TX","insp_carrier_zip_code":"77434","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-12T10:36:59.000000Z","updated_at":"2026-02-20T10:30:44.000000Z","inspection_violations":[{"id":18552619,"change_date":"2026-02-09 21:38:00","inspection_id":"86994751","insp_violation_id":"271678658","seq_no":"1","part_no":"391","part_no_section":"11B2-Q","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"54","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-12T10:50:28.000000Z","updated_at":"2026-02-20T10:39:05.000000Z","normalized_code":"39111B2Q"},{"id":18552620,"change_date":"2026-02-09 21:38:00","inspection_id":"86994751","insp_violation_id":"271678659","seq_no":"2","part_no":"395","part_no_section":"8A1-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-12T10:50:28.000000Z","updated_at":"2026-02-20T10:39:05.000000Z","normalized_code":"3958A1HOSP"},{"id":18552621,"change_date":"2026-02-09 21:38:00","inspection_id":"86994751","insp_violation_id":"271678660","seq_no":"3","part_no":"390","part_no_section":"21TE-LCMVINFO","insp_viol_unit":"1","insp_unit_id":"211518609","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-12T10:50:28.000000Z","updated_at":"2026-02-20T10:39:05.000000Z","normalized_code":"39021TELCMVINFO"},{"id":18552622,"change_date":"2026-02-09 21:38:00","inspection_id":"86994751","insp_violation_id":"271678661","seq_no":"4","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"211518610","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-12T10:50:28.000000Z","updated_at":"2026-02-20T10:39:05.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":18899452,"change_date":"2026-02-09 21:38:00","inspection_id":"86994751","insp_unit_id":"211518609","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"01","insp_unit_license":"RBXP53","insp_unit_license_state":"FL","insp_unit_vehicle_id_number":"3C6UR5CL2RG292597","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-12T10:13:37.000000Z","updated_at":"2026-02-20T10:03:47.000000Z"},{"id":18899453,"change_date":"2026-02-09 21:38:00","inspection_id":"86994751","insp_unit_id":"211518610","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MAXXD","insp_unit_company":"02","insp_unit_license":"FLUE53","insp_unit_license_state":"FL","insp_unit_vehicle_id_number":"5R8GC4023KM063967","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-12T10:13:37.000000Z","updated_at":"2026-02-20T10:03:47.000000Z"}]},{"id":10619855,"change_date":"2026-01-11 21:33:00","inspection_id":"86760235","dot_number":"4142374","report_state":"TN","report_number":"I038970218","insp_date":"2026-01-09 00:00:00","insp_start_time":"1756","insp_end_time":"2004","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"GORDONSVILLE TN","county_code_state":"TN","county_code":"159","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"CHERY INDUSTRIAL","shipping_paper_number":"CHERY-CINY-7516","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-01-11 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"3","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2750626","transaction_code":"A","transaction_date":"2026-01-11 00:00:00","upload_date":"2026-01-11 00:00:00","upload_first_byte":"0","upload_dot_number":"04142374","upload_search_indicator":null,"census_search_date":"2026-01-11 21:33:00","snet_input_date":"2026-01-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-11 21:33:00","insp_carrier_name":"CONNECTING CARGO USA LLC","insp_carrier_street":"1515 E MAIN STREET","insp_carrier_city":"EAGLE LAKE","insp_carrier_state":"TX","insp_carrier_zip_code":"77434","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-14T10:34:53.000000Z","updated_at":"2026-01-22T10:30:12.000000Z","inspection_violations":[{"id":17855851,"change_date":"2026-01-11 21:33:00","inspection_id":"86760235","insp_violation_id":"271129382","seq_no":"1","part_no":"395","part_no_section":"8E-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-14T10:40:11.000000Z","updated_at":"2026-01-22T10:30:24.000000Z","normalized_code":"3958EHOSPD"},{"id":17855852,"change_date":"2026-01-11 21:33:00","inspection_id":"86760235","insp_violation_id":"271129383","seq_no":"2","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"211016701","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-14T10:40:11.000000Z","updated_at":"2026-01-22T10:30:24.000000Z","normalized_code":"39021TB2DOT"},{"id":17855853,"change_date":"2026-01-11 21:33:00","inspection_id":"86760235","insp_violation_id":"271129384","seq_no":"3","part_no":"393","part_no_section":"40A-B","insp_viol_unit":"2","insp_unit_id":"211016702","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-14T10:40:11.000000Z","updated_at":"2026-01-22T10:30:24.000000Z","normalized_code":"39340AB"}],"inspection_per_units":[{"id":17805043,"change_date":"2026-01-11 21:33:00","inspection_id":"86760235","insp_unit_id":"211016702","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIG TEX","insp_unit_company":"02","insp_unit_license":"JN806L","insp_unit_license_state":"FL","insp_unit_vehicle_id_number":"16V3F4820P6230626","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-14T10:07:05.000000Z","updated_at":"2026-01-24T10:00:18.000000Z"},{"id":17805042,"change_date":"2026-01-11 21:33:00","inspection_id":"86760235","insp_unit_id":"211016701","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":"1","insp_unit_license":"RBXN26","insp_unit_license_state":"FL","insp_unit_vehicle_id_number":"3C6UR5FL7RG117547","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-14T10:07:05.000000Z","updated_at":"2026-01-24T10:00:18.000000Z"}]},{"id":9059316,"change_date":"2025-07-03 21:34:00","inspection_id":"85120953","dot_number":"4142374","report_state":"CA","report_number":"UEIG000588","insp_date":"2025-07-02 00:00:00","insp_start_time":"1025","insp_end_time":"1213","registration_date":null,"region":"PT","ci_status_code":"C","location":"130","location_desc":"5 SB SOUTH MAIN ST OFF RAMP","county_code_state":"CA","county_code":"103","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-03 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"24","oos_total":"12","driver_viol_total":"2","driver_oos_total":"2","vehicle_viol_total":"22","vehicle_oos_total":"10","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15883934","transaction_code":"A","transaction_date":"2025-07-02 00:00:00","upload_date":"2025-07-03 00:00:00","upload_first_byte":"0","upload_dot_number":"04142374","upload_search_indicator":null,"census_search_date":"2025-07-03 21:34:00","snet_input_date":"2025-07-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-07-03 21:34:00","insp_carrier_name":"CONNECTING CARGO USA LLC","insp_carrier_street":"1515 E MAIN STREET","insp_carrier_city":"EAGLE LAKE","insp_carrier_state":"TX","insp_carrier_zip_code":"77434","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-07T10:07:37.000000Z","updated_at":"2025-07-07T10:07:37.000000Z","inspection_violations":[{"id":14579880,"change_date":"2025-07-03 21:34:00","inspection_id":"85120953","insp_violation_id":"267197900","seq_no":"1","part_no":"392","part_no_section":"2-SLLED","insp_viol_unit":"2","insp_unit_id":"207695283","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-06T10:16:58.000000Z","updated_at":"2025-07-07T10:15:49.000000Z","normalized_code":"3922SLLED"},{"id":14579881,"change_date":"2025-07-03 21:34:00","inspection_id":"85120953","insp_violation_id":"267197901","seq_no":"2","part_no":"392","part_no_section":"2-SLLED","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"SB67042","created_at":"2025-07-06T10:16:58.000000Z","updated_at":"2025-07-07T10:15:49.000000Z","normalized_code":"3922SLLED"},{"id":14579882,"change_date":"2025-07-03 21:34:00","inspection_id":"85120953","insp_violation_id":"267197902","seq_no":"3","part_no":"395","part_no_section":"8A1-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"SB67042","created_at":"2025-07-06T10:16:58.000000Z","updated_at":"2025-07-07T10:15:49.000000Z","normalized_code":"3958A1HOSP"},{"id":14579883,"change_date":"2025-07-03 21:34:00","inspection_id":"85120953","insp_violation_id":"267197903","seq_no":"4","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"207695282","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-06T10:16:58.000000Z","updated_at":"2025-07-07T10:15:49.000000Z","normalized_code":"39021TB1MC"},{"id":14579884,"change_date":"2025-07-03 21:34:00","inspection_id":"85120953","insp_violation_id":"267197904","seq_no":"5","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"207695282","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-06T10:16:58.000000Z","updated_at":"2025-07-07T10:15:49.000000Z","normalized_code":"39021TB2DOT"},{"id":14579885,"change_date":"2025-07-03 21:34:00","inspection_id":"85120953","insp_violation_id":"267197905","seq_no":"6","part_no":"392","part_no_section":"2-SLLIRP","insp_viol_unit":"1","insp_unit_id":"207695282","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-06T10:16:58.000000Z","updated_at":"2025-07-07T10:15:49.000000Z","normalized_code":"3922SLLIRP"},{"id":14579886,"change_date":"2025-07-03 21:34:00","inspection_id":"85120953","insp_violation_id":"267197906","seq_no":"7","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"207695283","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-06T10:16:58.000000Z","updated_at":"2025-07-07T10:15:49.000000Z","normalized_code":"3922SLLSR"},{"id":14579887,"change_date":"2025-07-03 21:34:00","inspection_id":"85120953","insp_violation_id":"267197907","seq_no":"8","part_no":"393","part_no_section":"43D-B","insp_viol_unit":"2","insp_unit_id":"207695283","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-06T10:16:58.000000Z","updated_at":"2025-07-07T10:15:49.000000Z","normalized_code":"39343DB"},{"id":14579888,"change_date":"2025-07-03 21:34:00","inspection_id":"85120953","insp_violation_id":"267197908","seq_no":"9","part_no":"393","part_no_section":"43DBMA","insp_viol_unit":"2","insp_unit_id":"207695283","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-06T10:16:58.000000Z","updated_at":"2025-07-07T10:15:49.000000Z","normalized_code":"39343DBMA"},{"id":14579889,"change_date":"2025-07-03 21:34:00","inspection_id":"85120953","insp_violation_id":"267197909","seq_no":"10","part_no":"393","part_no_section":"209D-STPAL","insp_viol_unit":"1","insp_unit_id":"207695282","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-06T10:16:58.000000Z","updated_at":"2025-07-07T10:15:49.000000Z","normalized_code":"393209DSTPAL"},{"id":14579890,"change_date":"2025-07-03 21:34:00","inspection_id":"85120953","insp_violation_id":"267197910","seq_no":"11","part_no":"393","part_no_section":"75C-TAOTD-LT1\/32","insp_viol_unit":"2","insp_unit_id":"207695283","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-06T10:16:58.000000Z","updated_at":"2025-07-07T10:15:49.000000Z","normalized_code":"39375CTAOTDLT1\/32"},{"id":14579891,"change_date":"2025-07-03 21:34:00","inspection_id":"85120953","insp_violation_id":"267197911","seq_no":"12","part_no":"393","part_no_section":"75C-TAOTD-LT1\/32","insp_viol_unit":"2","insp_unit_id":"207695283","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-06T10:16:58.000000Z","updated_at":"2025-07-07T10:15:49.000000Z","normalized_code":"39375CTAOTDLT1\/32"},{"id":14579892,"change_date":"2025-07-03 21:34:00","inspection_id":"85120953","insp_violation_id":"267197912","seq_no":"13","part_no":"393","part_no_section":"205C-WR","insp_viol_unit":"1","insp_unit_id":"207695282","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-06T10:16:58.000000Z","updated_at":"2025-07-07T10:15:49.000000Z","normalized_code":"393205CWR"},{"id":14579893,"change_date":"2025-07-03 21:34:00","inspection_id":"85120953","insp_violation_id":"267197913","seq_no":"14","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"207695282","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-06T10:16:58.000000Z","updated_at":"2025-07-07T10:15:49.000000Z","normalized_code":"39395A1"},{"id":14579894,"change_date":"2025-07-03 21:34:00","inspection_id":"85120953","insp_violation_id":"267197914","seq_no":"15","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"207695282","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-06T10:16:58.000000Z","updated_at":"2025-07-07T10:15:49.000000Z","normalized_code":"39395F"},{"id":14579895,"change_date":"2025-07-03 21:34:00","inspection_id":"85120953","insp_violation_id":"267197915","seq_no":"16","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"207695282","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-06T10:16:58.000000Z","updated_at":"2025-07-07T10:15:49.000000Z","normalized_code":"3939ALCL"},{"id":14579896,"change_date":"2025-07-03 21:34:00","inspection_id":"85120953","insp_violation_id":"267197916","seq_no":"17","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"2","insp_unit_id":"207695283","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-06T10:16:58.000000Z","updated_at":"2025-07-07T10:15:49.000000Z","normalized_code":"3939ALRLI"},{"id":14579897,"change_date":"2025-07-03 21:34:00","inspection_id":"85120953","insp_violation_id":"267197917","seq_no":"18","part_no":"396","part_no_section":"5-HL","insp_viol_unit":"2","insp_unit_id":"207695283","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-06T10:16:58.000000Z","updated_at":"2025-07-07T10:15:49.000000Z","normalized_code":"3965HL"},{"id":14579898,"change_date":"2025-07-03 21:34:00","inspection_id":"85120953","insp_violation_id":"267197918","seq_no":"19","part_no":"393","part_no_section":"48A-BMBCHE","insp_viol_unit":"2","insp_unit_id":"207695283","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-06T10:16:58.000000Z","updated_at":"2025-07-07T10:15:49.000000Z","normalized_code":"39348ABMBCHE"},{"id":14579899,"change_date":"2025-07-03 21:34:00","inspection_id":"85120953","insp_violation_id":"267197919","seq_no":"20","part_no":"393","part_no_section":"47A-BCFSHE","insp_viol_unit":"2","insp_unit_id":"207695283","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-06T10:16:58.000000Z","updated_at":"2025-07-07T10:15:49.000000Z","normalized_code":"39347ABCFSHE"},{"id":14579900,"change_date":"2025-07-03 21:34:00","inspection_id":"85120953","insp_violation_id":"267197920","seq_no":"21","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"1","insp_unit_id":"207695282","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-06T10:16:58.000000Z","updated_at":"2025-07-07T10:15:49.000000Z","normalized_code":"3963A1BOS"},{"id":14579901,"change_date":"2025-07-03 21:34:00","inspection_id":"85120953","insp_violation_id":"267197921","seq_no":"22","part_no":"393","part_no_section":"207A-SUBL","insp_viol_unit":"2","insp_unit_id":"207695283","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-06T10:16:58.000000Z","updated_at":"2025-07-07T10:15:49.000000Z","normalized_code":"393207ASUBL"},{"id":14579902,"change_date":"2025-07-03 21:34:00","inspection_id":"85120953","insp_violation_id":"267197922","seq_no":"23","part_no":"393","part_no_section":"48A-BIHE","insp_viol_unit":"2","insp_unit_id":"207695283","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-06T10:16:58.000000Z","updated_at":"2025-07-07T10:15:49.000000Z","normalized_code":"39348ABIHE"},{"id":14579903,"change_date":"2025-07-03 21:34:00","inspection_id":"85120953","insp_violation_id":"267197923","seq_no":"24","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"207695282","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-06T10:16:58.000000Z","updated_at":"2025-07-07T10:15:49.000000Z","normalized_code":"3922SLLUCR"}],"inspection_per_units":[{"id":14864164,"change_date":"2025-07-03 21:34:00","inspection_id":"85120953","insp_unit_id":"207695282","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":null,"insp_unit_license":"XCC9927","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3D73Y4CL7BG541005","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-06T09:46:20.000000Z","updated_at":"2025-07-07T09:45:33.000000Z"},{"id":14864165,"change_date":"2025-07-03 21:34:00","inspection_id":"85120953","insp_unit_id":"207695283","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LAMAR","insp_unit_company":null,"insp_unit_license":"704249M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5RVH83821KP081657","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-06T09:46:20.000000Z","updated_at":"2025-07-07T09:45:33.000000Z"}]},{"id":9009497,"change_date":"2025-06-27 21:38:00","inspection_id":"85068673","dot_number":"4142374","report_state":"UT","report_number":"25PP001053","insp_date":"2025-06-26 00:00:00","insp_start_time":"0926","insp_end_time":"1048","registration_date":null,"region":"MD","ci_status_code":"C","location":null,"location_desc":"NORTH SALT LAKE UT","county_code_state":"UT","county_code":"011","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ADVANCED DRAINING SYSTEMS, INC","shipping_paper_number":"D03-7643644","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-06-27 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"29990","viol_total":"7","oos_total":"5","driver_viol_total":"0","driver_oos_total":"2","vehicle_viol_total":"0","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1922128","transaction_code":"A","transaction_date":"2025-06-27 00:00:00","upload_date":"2025-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"04142374","upload_search_indicator":null,"census_search_date":"2025-06-27 21:38:00","snet_input_date":"2025-06-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-27 21:38:00","insp_carrier_name":"CONNECTING CARGO USA LLC","insp_carrier_street":"1515 E MAIN STREET","insp_carrier_city":"EAGLE LAKE","insp_carrier_state":"TX","insp_carrier_zip_code":"77434","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-30T10:01:18.000000Z","updated_at":"2025-07-03T10:00:15.000000Z","inspection_violations":[{"id":14482429,"change_date":"2025-06-27 21:38:00","inspection_id":"85068673","insp_violation_id":"267087656","seq_no":"1","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"207599607","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-30T10:17:35.000000Z","updated_at":"2025-07-02T10:15:27.000000Z","normalized_code":"39395A4EEUS"},{"id":14482430,"change_date":"2025-06-27 21:38:00","inspection_id":"85068673","insp_violation_id":"267087657","seq_no":"2","part_no":"393","part_no_section":"11A1-LCHL","insp_viol_unit":"1","insp_unit_id":"207599607","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-30T10:17:35.000000Z","updated_at":"2025-07-02T10:15:27.000000Z","normalized_code":"39311A1LCHL"},{"id":14482431,"change_date":"2025-06-27 21:38:00","inspection_id":"85068673","insp_violation_id":"267087658","seq_no":"3","part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-30T10:17:35.000000Z","updated_at":"2025-07-02T10:15:27.000000Z","normalized_code":"38323A2LCDLN"},{"id":14482432,"change_date":"2025-06-27 21:38:00","inspection_id":"85068673","insp_violation_id":"267087659","seq_no":"4","part_no":"393","part_no_section":"23-LEU","insp_viol_unit":"2","insp_unit_id":"207599608","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-06-30T10:17:35.000000Z","updated_at":"2025-07-02T10:15:27.000000Z","normalized_code":"39323LEU"},{"id":14482433,"change_date":"2025-06-27 21:38:00","inspection_id":"85068673","insp_violation_id":"267087660","seq_no":"5","part_no":"395","part_no_section":"8A1-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-30T10:17:35.000000Z","updated_at":"2025-07-02T10:15:27.000000Z","normalized_code":"3958A1HOSP"},{"id":14482434,"change_date":"2025-06-27 21:38:00","inspection_id":"85068673","insp_violation_id":"267087661","seq_no":"6","part_no":"393","part_no_section":"9A-LSLIWR","insp_viol_unit":"2","insp_unit_id":"207599608","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-06-30T10:17:35.000000Z","updated_at":"2025-07-02T10:15:27.000000Z","normalized_code":"3939ALSLIWR"},{"id":14482435,"change_date":"2025-06-27 21:38:00","inspection_id":"85068673","insp_violation_id":"267087662","seq_no":"7","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"2","insp_unit_id":"207599608","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-06-30T10:17:35.000000Z","updated_at":"2025-07-02T10:15:27.000000Z","normalized_code":"3939ALTSI"}],"inspection_per_units":[{"id":14775502,"change_date":"2025-06-27 21:38:00","inspection_id":"85068673","insp_unit_id":"207599607","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"COURIER","insp_unit_company":"02","insp_unit_license":"WHY2429","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT8W3DT6EEA14986","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-01T09:47:33.000000Z","updated_at":"2025-07-01T09:49:16.000000Z"},{"id":14775503,"change_date":"2025-06-27 21:38:00","inspection_id":"85068673","insp_unit_id":"207599608","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PJ TRAILER","insp_unit_company":null,"insp_unit_license":"459496M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4P53F4926R1407258","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-01T09:47:33.000000Z","updated_at":"2025-07-01T09:49:16.000000Z"}]},{"id":7573394,"change_date":"2025-01-08 21:39:00","inspection_id":"83555887","dot_number":"4142374","report_state":"AL","report_number":"MBJP006350","insp_date":"2025-01-08 00:00:00","insp_start_time":"1415","insp_end_time":"1455","registration_date":null,"region":"CT","ci_status_code":"C","location":"05","location_desc":"STOCKTON","county_code_state":"AL","county_code":"003","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"KIH LLC","shipping_paper_number":"S25-21","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-01-08 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1037774","transaction_code":"A","transaction_date":"2025-01-08 00:00:00","upload_date":"2025-01-08 00:00:00","upload_first_byte":"0","upload_dot_number":"04142374","upload_search_indicator":null,"census_search_date":"2025-01-08 21:39:00","snet_input_date":"2025-01-08 00:00:00","source_office":"2ALS001","mcmis_add_date":"2025-01-08 21:39:00","insp_carrier_name":"CONNECTING CARGO USA LLC","insp_carrier_street":"2918 W GRAND PWY N STE 150","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77449","insp_colonia":null,"docket_number":"158851","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:55:18.000000Z","updated_at":"2025-03-17T20:55:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12219466,"change_date":"2025-01-08 21:39:00","inspection_id":"83555887","insp_unit_id":"204705211","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"40DVWR","insp_unit_license_state":"FL","insp_unit_vehicle_id_number":"1FT7W2BT2KED65088","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:52.000000Z","updated_at":"2025-03-17T23:49:52.000000Z"},{"id":12219467,"change_date":"2025-01-08 21:39:00","inspection_id":"83555887","insp_unit_id":"204705212","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PARM","insp_unit_company":null,"insp_unit_license":"CJ21RW","insp_unit_license_state":"FL","insp_unit_vehicle_id_number":"4P53F4924R1411468","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:52.000000Z","updated_at":"2025-03-17T23:49:52.000000Z"}]},{"id":7393338,"change_date":"2024-12-13 21:41:00","inspection_id":"83366735","dot_number":"4142374","report_state":"TX","report_number":"V241584657","insp_date":"2024-12-04 00:00:00","insp_start_time":"1320","insp_end_time":"1538","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"TX114 EB","county_code_state":"TX","county_code":"121","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ISCO-KINGMAN","shipping_paper_number":"53142851LN","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-12-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"12","oos_total":"4","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"10","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9445435","transaction_code":"C","transaction_date":"2024-12-13 00:00:00","upload_date":"2024-12-13 00:00:00","upload_first_byte":"0","upload_dot_number":"04142374","upload_search_indicator":"M","census_search_date":"2024-12-11 21:41:00","snet_input_date":"2024-12-04 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-12-11 21:41:00","insp_carrier_name":"CONNECTING CARGO USA LLC","insp_carrier_street":"1515 E MAIN STREET","insp_carrier_city":"EAGLE LAKE","insp_carrier_state":"TX","insp_carrier_zip_code":"77434","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1083591","created_at":"2025-03-17T20:50:19.000000Z","updated_at":"2025-03-17T20:50:19.000000Z","inspection_violations":[{"id":11550914,"change_date":"2024-12-13 21:41:00","inspection_id":"83366735","insp_violation_id":"263454708","seq_no":"1","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"204376452","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:13.000000Z","updated_at":"2025-03-17T22:02:13.000000Z","normalized_code":"39021A"},{"id":11550915,"change_date":"2024-12-13 21:41:00","inspection_id":"83366735","insp_violation_id":"263454709","seq_no":"2","part_no":"393","part_no_section":"110B","insp_viol_unit":"2","insp_unit_id":"204376453","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-03-17T22:02:13.000000Z","updated_at":"2025-03-17T22:02:13.000000Z","normalized_code":"393110B"},{"id":11550916,"change_date":"2024-12-13 21:41:00","inspection_id":"83366735","insp_violation_id":"263454710","seq_no":"3","part_no":"393","part_no_section":"43D","insp_viol_unit":"2","insp_unit_id":"204376453","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-03-17T22:02:13.000000Z","updated_at":"2025-03-17T22:02:13.000000Z","normalized_code":"39343D"},{"id":11550917,"change_date":"2024-12-13 21:41:00","inspection_id":"83366735","insp_violation_id":"263454711","seq_no":"4","part_no":"393","part_no_section":"48A","insp_viol_unit":"2","insp_unit_id":"204376453","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:13.000000Z","updated_at":"2025-03-17T22:02:13.000000Z","normalized_code":"39348A"},{"id":11550918,"change_date":"2024-12-13 21:41:00","inspection_id":"83366735","insp_violation_id":"263454712","seq_no":"5","part_no":"393","part_no_section":"48A","insp_viol_unit":"2","insp_unit_id":"204376453","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:13.000000Z","updated_at":"2025-03-17T22:02:13.000000Z","normalized_code":"39348A"},{"id":11550919,"change_date":"2024-12-13 21:41:00","inspection_id":"83366735","insp_violation_id":"263454713","seq_no":"6","part_no":"393","part_no_section":"48A","insp_viol_unit":"2","insp_unit_id":"204376453","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:13.000000Z","updated_at":"2025-03-17T22:02:13.000000Z","normalized_code":"39348A"},{"id":11550920,"change_date":"2024-12-13 21:41:00","inspection_id":"83366735","insp_violation_id":"263454714","seq_no":"7","part_no":"393","part_no_section":"48A","insp_viol_unit":"2","insp_unit_id":"204376453","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:13.000000Z","updated_at":"2025-03-17T22:02:13.000000Z","normalized_code":"39348A"},{"id":11550921,"change_date":"2024-12-13 21:41:00","inspection_id":"83366735","insp_violation_id":"263454715","seq_no":"8","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"204376453","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:13.000000Z","updated_at":"2025-03-17T22:02:13.000000Z","normalized_code":"3939"},{"id":11550922,"change_date":"2024-12-13 21:41:00","inspection_id":"83366735","insp_violation_id":"263454716","seq_no":"9","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"204376453","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:13.000000Z","updated_at":"2025-03-17T22:02:13.000000Z","normalized_code":"3939"},{"id":11550923,"change_date":"2024-12-13 21:41:00","inspection_id":"83366735","insp_violation_id":"263454717","seq_no":"10","part_no":"395","part_no_section":"8F01","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:13.000000Z","updated_at":"2025-03-17T22:02:13.000000Z","normalized_code":"3958F01"},{"id":11550924,"change_date":"2024-12-13 21:41:00","inspection_id":"83366735","insp_violation_id":"263454718","seq_no":"11","part_no":"395","part_no_section":"8K2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T22:02:13.000000Z","updated_at":"2025-03-17T22:02:13.000000Z","normalized_code":"3958K2"},{"id":11550925,"change_date":"2024-12-13 21:41:00","inspection_id":"83366735","insp_violation_id":"263454719","seq_no":"12","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"2","insp_unit_id":"204376453","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-03-17T22:02:13.000000Z","updated_at":"2025-03-17T22:02:13.000000Z","normalized_code":"3963A1BOS"}],"inspection_per_units":[{"id":11926648,"change_date":"2024-12-13 21:41:00","inspection_id":"83366735","insp_unit_id":"204376452","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"02","insp_unit_license":"93ELBM","insp_unit_license_state":"FL","insp_unit_vehicle_id_number":"3C63RRHL9NG133453","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:41.000000Z","updated_at":"2025-03-17T23:46:41.000000Z"},{"id":11926649,"change_date":"2024-12-13 21:41:00","inspection_id":"83366735","insp_unit_id":"204376453","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"RAW","insp_unit_company":null,"insp_unit_license":"TZM77U","insp_unit_license_state":"NJ","insp_unit_vehicle_id_number":"3EVGF4029R1109995","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:41.000000Z","updated_at":"2025-03-17T23:46:41.000000Z"}]},{"id":5569832,"change_date":"2024-04-22 21:41:00","inspection_id":"81415090","dot_number":"4142374","report_state":"CA","report_number":"UFG0001106","insp_date":"2024-04-20 00:00:00","insp_start_time":"1135","insp_end_time":"1224","registration_date":null,"region":"PT","ci_status_code":"C","location":"481","location_desc":"TULARE, CA","county_code_state":"CA","county_code":"107","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25680","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15328501","transaction_code":"A","transaction_date":"2024-04-20 00:00:00","upload_date":"2024-04-22 00:00:00","upload_first_byte":"0","upload_dot_number":"04142374","upload_search_indicator":null,"census_search_date":"2024-04-22 21:41:00","snet_input_date":"2024-04-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-04-22 21:41:00","insp_carrier_name":"CONNECTING CARGO USA LLC","insp_carrier_street":"14504 BRIAR FORREST DRIVE APT 524","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77077","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:08.000000Z","updated_at":"2025-03-17T20:13:08.000000Z","inspection_violations":[{"id":8608242,"change_date":"2024-04-22 21:41:00","inspection_id":"81415090","insp_violation_id":"259068310","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"MS54474","created_at":"2025-03-17T21:47:42.000000Z","updated_at":"2025-03-17T21:47:42.000000Z","normalized_code":"3922"},{"id":8608243,"change_date":"2024-04-22 21:41:00","inspection_id":"81415090","insp_violation_id":"259068311","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200517649","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:42.000000Z","updated_at":"2025-03-17T21:47:42.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8971874,"change_date":"2024-04-22 21:41:00","inspection_id":"81415090","insp_unit_id":"200517649","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"TTN8153","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C6UR5CL9RG102651","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:29.000000Z","updated_at":"2025-03-17T23:16:29.000000Z"},{"id":8971875,"change_date":"2024-04-22 21:41:00","inspection_id":"81415090","insp_unit_id":"200517650","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PETE","insp_unit_company":"25","insp_unit_license":"401061M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3P9WAMX25P3043130","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:29.000000Z","updated_at":"2025-03-17T23:16:29.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/4142374\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/4142374\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/4142374\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next »","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/searchcarriers.com\/company\/4142374\/inspections","per_page":100,"prev_page_url":null,"to":15,"total":15}