{"current_page":1,"data":[{"id":12068234,"change_date":"2026-06-01 21:41:00","inspection_id":"88010293","dot_number":"3201573","report_state":"MT","report_number":"U433501194","insp_date":"2026-05-26 00:00:00","insp_start_time":"0834","insp_end_time":"0849","registration_date":null,"region":"MD","ci_status_code":"C","location":null,"location_desc":"BIGFORK MT","county_code_state":"MT","county_code":"047","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-01 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","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":"3443698","transaction_code":"A","transaction_date":"2026-06-01 00:00:00","upload_date":"2026-06-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":null,"census_search_date":"2026-06-01 21:41:00","snet_input_date":"2026-05-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-01 21:41:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"330 SUMMERHAYS STREET","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-05T09:39:07.000000Z","updated_at":"2026-06-11T09:31:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20973011,"change_date":"2026-06-01 21:41:00","inspection_id":"88010293","insp_unit_id":"213854026","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":null,"insp_unit_license":"FS4299","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1JJV532DXEL789361","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-05T09:15:40.000000Z","updated_at":"2026-06-11T09:03:04.000000Z"},{"id":20973012,"change_date":"2026-06-01 21:41:00","inspection_id":"88010293","insp_unit_id":"213854027","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"FP6049","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYD49X6SJ169889","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-05T09:15:40.000000Z","updated_at":"2026-06-11T09:03:04.000000Z"}]},{"id":11988016,"change_date":"2026-05-22 08:07:00","inspection_id":"87925668","dot_number":"3201573","report_state":"KY","report_number":"CV44105737","insp_date":"2026-05-20 00:00:00","insp_start_time":"2108","insp_end_time":"2144","registration_date":null,"region":"CT","ci_status_code":"C","location":"9814","location_desc":"KUTTAWA","county_code_state":"KY","county_code":"143","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"RYAM","shipping_paper_number":"184820","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-05-22 08:07:00","post_acc_ind":"N","gross_comb_veh_wt":"121000","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":"2346656","transaction_code":"A","transaction_date":"2026-05-21 00:00:00","upload_date":"2026-05-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2026-05-21 00:00:00","source_office":"2KYS001","mcmis_add_date":"2026-05-22 08:07:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"330 SUMMERHAYS STREET","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"176815","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-25T09:41:04.000000Z","updated_at":"2026-06-02T09:31:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20840784,"change_date":"2026-05-22 08:07:00","inspection_id":"87925668","insp_unit_id":"213693046","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"107","insp_unit_license":"FY7100","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYD49X2SJ169890","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-25T09:18:54.000000Z","updated_at":"2026-06-02T09:04:01.000000Z"},{"id":20840785,"change_date":"2026-05-22 08:07:00","inspection_id":"87925668","insp_unit_id":"213693047","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"5243","insp_unit_license":"FZ0090","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3H3V532K6RS094045","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-25T09:18:54.000000Z","updated_at":"2026-06-02T09:04:01.000000Z"}]},{"id":11864389,"change_date":"2026-05-09 21:35:00","inspection_id":"87801090","dot_number":"3201573","report_state":"IN","report_number":"8527003027","insp_date":"2026-05-04 00:00:00","insp_start_time":"1807","insp_end_time":"1836","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MISHAWAKA IN","county_code_state":"IN","county_code":null,"insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CAT","shipping_paper_number":"122243454","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-09 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3291339","transaction_code":"A","transaction_date":"2026-05-09 00:00:00","upload_date":"2026-05-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":null,"census_search_date":"2026-05-09 21:35:00","snet_input_date":"2026-05-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-09 21:35:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"330 SUMMERHAYS STREET","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-12T09:39:35.000000Z","updated_at":"2026-05-20T09:30:31.000000Z","inspection_violations":[{"id":20636798,"change_date":"2026-05-09 21:35:00","inspection_id":"87801090","insp_violation_id":"274149909","seq_no":"1","part_no":"392","part_no_section":"2-SLLS4","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-12T09:58:47.000000Z","updated_at":"2026-05-20T09:42:16.000000Z","normalized_code":"3922SLLS4"}],"inspection_per_units":[{"id":20630540,"change_date":"2026-05-09 21:35:00","inspection_id":"87801090","insp_unit_id":"213461931","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"107","insp_unit_license":"FY7100","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYD49X2SJ169890","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-12T09:15:50.000000Z","updated_at":"2026-05-20T09:02:21.000000Z"},{"id":20630541,"change_date":"2026-05-09 21:35:00","inspection_id":"87801090","insp_unit_id":"213461932","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"5176","insp_unit_license":"FW8358","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1JJV532D1HL971745","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-12T09:15:50.000000Z","updated_at":"2026-05-20T09:02:21.000000Z"}]},{"id":11769069,"change_date":"2026-04-28 21:39:00","inspection_id":"87699743","dot_number":"3201573","report_state":"MT","report_number":"U552001107","insp_date":"2026-04-28 00:00:00","insp_start_time":"1540","insp_end_time":"1557","registration_date":null,"region":"MD","ci_status_code":"C","location":"ARMGTN","location_desc":"ARMINGTON MT","county_code_state":"MT","county_code":"013","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"GENERAL MILLS","shipping_paper_number":"89849735","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-28 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"3225785","transaction_code":"A","transaction_date":"2026-04-28 00:00:00","upload_date":"2026-04-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":null,"census_search_date":"2026-04-28 21:39:00","snet_input_date":"2026-04-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-28 21:39:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"330 SUMMERHAYS STREET","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-01T09:40:26.000000Z","updated_at":"2026-05-09T09:30:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20475117,"change_date":"2026-04-28 21:39:00","inspection_id":"87699743","insp_unit_id":"213266013","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"001","insp_unit_license":"AN1113","insp_unit_license_state":"ID","insp_unit_vehicle_id_number":"1XKYDP9X5HJ141768","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-01T09:20:31.000000Z","updated_at":"2026-05-09T09:03:15.000000Z"},{"id":20475118,"change_date":"2026-04-28 21:39:00","inspection_id":"87699743","insp_unit_id":"213266014","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"1020572ST","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"1GR1P0625TK805869","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-01T09:20:31.000000Z","updated_at":"2026-05-09T09:03:15.000000Z"}]},{"id":11732163,"change_date":"2026-04-23 21:39:00","inspection_id":"87660494","dot_number":"3201573","report_state":"NM","report_number":"4004Q34973","insp_date":"2026-04-22 00:00:00","insp_start_time":"0820","insp_end_time":"0842","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"I-40 EB","county_code_state":"NM","county_code":"001","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CHEP","shipping_paper_number":"3683944889","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":"2026-04-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2294788","transaction_code":"A","transaction_date":"2026-04-22 00:00:00","upload_date":"2026-04-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":null,"census_search_date":"2026-04-23 21:39:00","snet_input_date":"2026-04-23 00:00:00","source_office":"2NMS001","mcmis_add_date":"2026-04-23 21:39:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"PO BOX 222","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:41:25.000000Z","updated_at":"2026-05-04T09:31:14.000000Z","inspection_violations":[{"id":20395951,"change_date":"2026-04-23 21:39:00","inspection_id":"87660494","insp_violation_id":"273805618","seq_no":"1","part_no":"392","part_no_section":"2-SLLS1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"1109952","created_at":"2026-04-27T10:02:43.000000Z","updated_at":"2026-05-04T09:43:27.000000Z","normalized_code":"3922SLLS1"}],"inspection_per_units":[{"id":20414170,"change_date":"2026-04-23 21:39:00","inspection_id":"87660494","insp_unit_id":"213183535","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"TRK 104","insp_unit_license":"FR6327","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYD49X2SJ169887","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:19:51.000000Z","updated_at":"2026-05-04T09:04:13.000000Z"},{"id":20414171,"change_date":"2026-04-23 21:39:00","inspection_id":"87660494","insp_unit_id":"213183536","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"TRL 5241","insp_unit_license":"FZ0088","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3H3V532K2RS094043","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:19:51.000000Z","updated_at":"2026-05-04T09:04:13.000000Z"}]},{"id":11679650,"change_date":"2026-04-17 21:41:00","inspection_id":"87604935","dot_number":"3201573","report_state":"MO","report_number":"W210001637","insp_date":"2026-04-16 00:00:00","insp_start_time":"1413","insp_end_time":"1434","registration_date":null,"region":"CD","ci_status_code":"C","location":"D4E","location_desc":"JOPLIN MO","county_code_state":"MO","county_code":"145","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"OLAM CHILE PEPPERS","shipping_paper_number":"2749128942","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-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","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":"3172721","transaction_code":"A","transaction_date":"2026-04-17 00:00:00","upload_date":"2026-04-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":null,"census_search_date":"2026-04-17 21:41:00","snet_input_date":"2026-04-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-17 21:41:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"330 SUMMERHAYS STREET","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:33:13.000000Z","updated_at":"2026-04-28T09:30:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20308895,"change_date":"2026-04-17 21:41:00","inspection_id":"87604935","insp_unit_id":"213069805","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"71500","insp_unit_license":"K825697","insp_unit_license_state":"AR","insp_unit_vehicle_id_number":"3HSDJAPR9GN187885","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:06:58.000000Z","updated_at":"2026-04-28T09:03:34.000000Z"},{"id":20308896,"change_date":"2026-04-17 21:41:00","inspection_id":"87604935","insp_unit_id":"213069806","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VAN GUARD","insp_unit_company":"5211","insp_unit_license":"HT5967","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5V8VC5329MM106997","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:06:58.000000Z","updated_at":"2026-04-28T09:03:34.000000Z"}]},{"id":11344597,"change_date":"2026-03-11 21:38:00","inspection_id":"87262425","dot_number":"3201573","report_state":"IA","report_number":"000P16CWSM","insp_date":"2026-03-10 00:00:00","insp_start_time":"0934","insp_end_time":"1005","registration_date":null,"region":"CT","ci_status_code":"C","location":"39","location_desc":"39 - I35 SB MM 212 NORTHWOOD","county_code_state":"IA","county_code":"195","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"NONE","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-03-11 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","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":"1393357","transaction_code":"A","transaction_date":"2026-03-11 00:00:00","upload_date":"2026-03-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2026-03-10 00:00:00","source_office":"3IAS001","mcmis_add_date":"2026-03-11 21:38:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"330 SUMMERHAYS STREET","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"176815","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-14T09:38:17.000000Z","updated_at":"2026-03-22T09:32:21.000000Z","inspection_violations":[{"id":19104265,"change_date":"2026-03-11 21:38:00","inspection_id":"87262425","insp_violation_id":"272336824","seq_no":"1","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"212084761","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-14T09:55:20.000000Z","updated_at":"2026-03-22T09:52:42.000000Z","normalized_code":"3939"},{"id":19104266,"change_date":"2026-03-11 21:38:00","inspection_id":"87262425","insp_violation_id":"272336825","seq_no":"2","part_no":"395","part_no_section":"15G02","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-14T09:55:20.000000Z","updated_at":"2026-03-22T09:52:43.000000Z","normalized_code":"39515G02"}],"inspection_per_units":[{"id":19414006,"change_date":"2026-03-11 21:38:00","inspection_id":"87262425","insp_unit_id":"212084761","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"14","insp_unit_license":"FY5938","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3HSDJAPR4EN755022","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-14T09:14:56.000000Z","updated_at":"2026-03-22T09:11:05.000000Z"},{"id":19414007,"change_date":"2026-03-11 21:38:00","inspection_id":"87262425","insp_unit_id":"212084762","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"5175","insp_unit_license":"FW8357","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1JJV532DXHL971744","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-14T09:14:56.000000Z","updated_at":"2026-03-22T09:11:05.000000Z"}]},{"id":11321490,"change_date":"2026-03-09 21:36:00","inspection_id":"87238159","dot_number":"3201573","report_state":"MN","report_number":"1675000876","insp_date":"2026-03-02 00:00:00","insp_start_time":"0756","insp_end_time":"0845","registration_date":null,"region":"CS","ci_status_code":"C","location":"CLKGVN","location_desc":"CLARKS GROVE MN","county_code_state":"MN","county_code":"047","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CLEAR CREEK EXPRESS LLC","shipping_paper_number":"629734","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-03-09 21:36:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2980781","transaction_code":"A","transaction_date":"2026-03-08 00:00:00","upload_date":"2026-03-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":null,"census_search_date":"2026-03-09 21:36:00","snet_input_date":"2026-03-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-09 21:36:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"330 SUMMERHAYS STREET","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-12T09:40:19.000000Z","updated_at":"2026-03-20T09:30:11.000000Z","inspection_violations":[{"id":19056038,"change_date":"2026-03-09 21:36:00","inspection_id":"87238159","insp_violation_id":"272282430","seq_no":"1","part_no":"393","part_no_section":"43A-TPV","insp_viol_unit":"1","insp_unit_id":"212037727","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-03-12T10:01:36.000000Z","updated_at":"2026-03-20T09:43:06.000000Z","normalized_code":"39343ATPV"},{"id":19056039,"change_date":"2026-03-09 21:36:00","inspection_id":"87238159","insp_violation_id":"272282431","seq_no":"2","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"882616750024","created_at":"2026-03-12T10:01:36.000000Z","updated_at":"2026-03-20T09:43:06.000000Z","normalized_code":"3922SLLEWA1"}],"inspection_per_units":[{"id":19370567,"change_date":"2026-03-09 21:36:00","inspection_id":"87238159","insp_unit_id":"212037727","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"103","insp_unit_license":"FA4020","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYD49X0SJ169886","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-12T09:21:02.000000Z","updated_at":"2026-03-20T09:02:44.000000Z"},{"id":19370568,"change_date":"2026-03-09 21:36:00","inspection_id":"87238159","insp_unit_id":"212037728","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"UNIT-5231","insp_unit_license":"FT8804","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1JJV532D6PL372130","insp_unit_decal":"Y","insp_unit_decal_number":"36076062","created_at":"2026-03-12T09:21:02.000000Z","updated_at":"2026-03-20T09:02:44.000000Z"}]},{"id":11235811,"change_date":"2026-02-26 21:41:00","inspection_id":"87148270","dot_number":"3201573","report_state":"MT","report_number":"U716901447","insp_date":"2026-02-20 00:00:00","insp_start_time":"0745","insp_end_time":"0830","registration_date":null,"region":"MS","ci_status_code":"C","location":"BILLBN","location_desc":"BILLINGS MT","county_code_state":"MT","county_code":"111","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"BLOUNT FINE FOODS","shipping_paper_number":"281608","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-02-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"115000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2938327","transaction_code":"A","transaction_date":"2026-02-26 00:00:00","upload_date":"2026-02-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":null,"census_search_date":"2026-02-26 21:41:00","snet_input_date":"2026-02-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-26 21:41:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"330 SUMMERHAYS STREET","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-01T10:38:59.000000Z","updated_at":"2026-03-09T09:31:37.000000Z","inspection_violations":[{"id":18866537,"change_date":"2026-02-26 21:41:00","inspection_id":"87148270","insp_violation_id":"272052267","seq_no":"1","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"2","insp_unit_id":"211850158","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-01T10:56:41.000000Z","updated_at":"2026-03-09T09:44:23.000000Z","normalized_code":"3939ALSML"},{"id":18866538,"change_date":"2026-02-26 21:41:00","inspection_id":"87148270","insp_violation_id":"272052268","seq_no":"2","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"1","insp_unit_id":"211850157","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-01T10:56:41.000000Z","updated_at":"2026-03-09T09:44:23.000000Z","normalized_code":"3939ALRLI"}],"inspection_per_units":[{"id":19207264,"change_date":"2026-02-26 21:41:00","inspection_id":"87148270","insp_unit_id":"211850157","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"10","insp_unit_license":"AN1113","insp_unit_license_state":"ID","insp_unit_vehicle_id_number":"1XKYDP9X5HJ141768","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-01T10:15:42.000000Z","updated_at":"2026-03-09T09:07:52.000000Z"},{"id":19207265,"change_date":"2026-02-26 21:41:00","inspection_id":"87148270","insp_unit_id":"211850158","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"160","insp_unit_license":"7881TN","insp_unit_license_state":"ID","insp_unit_vehicle_id_number":"1UYVS253XEU029408","insp_unit_decal":"Y","insp_unit_decal_number":"36085656","created_at":"2026-03-01T10:15:42.000000Z","updated_at":"2026-03-09T09:07:52.000000Z"}]},{"id":10809492,"change_date":"2026-01-20 21:39:00","inspection_id":"86836559","dot_number":"3201573","report_state":"ID","report_number":"3887001948","insp_date":"2026-01-19 00:00:00","insp_start_time":"1527","insp_end_time":"1538","registration_date":null,"region":"MS","ci_status_code":"C","location":null,"location_desc":"FRUITLAND ID","county_code_state":"ID","county_code":"075","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":"U","pen_cen_match":"I","final_status_date":"2026-01-20 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"115000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2792172","transaction_code":"A","transaction_date":"2026-01-20 00:00:00","upload_date":"2026-01-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":null,"census_search_date":"2026-01-20 21:39:00","snet_input_date":"2026-01-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-20 21:39:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"330 SUMMERHAYS STREET","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-23T10:36:13.000000Z","updated_at":"2026-01-31T10:30:26.000000Z","inspection_violations":[{"id":18068371,"change_date":"2026-01-20 21:39:00","inspection_id":"86836559","insp_violation_id":"271302362","seq_no":"1","part_no":"392","part_no_section":"2-SLLS3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-23T10:42:27.000000Z","updated_at":"2026-01-31T10:37:30.000000Z","normalized_code":"3922SLLS3"}],"inspection_per_units":[{"id":18150315,"change_date":"2026-01-20 21:39:00","inspection_id":"86836559","insp_unit_id":"211174451","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"10","insp_unit_license":"AN1113","insp_unit_license_state":"ID","insp_unit_vehicle_id_number":"1XKYDP9X5HJ141768","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-24T10:08:17.000000Z","updated_at":"2026-01-31T10:02:46.000000Z"},{"id":18150316,"change_date":"2026-01-20 21:39:00","inspection_id":"86836559","insp_unit_id":"211174452","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"160","insp_unit_license":"7881TN","insp_unit_license_state":"ID","insp_unit_vehicle_id_number":"1UYVS253XEU029408","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-24T10:08:17.000000Z","updated_at":"2026-01-31T10:02:46.000000Z"}]},{"id":10774184,"change_date":"2026-01-15 21:40:00","inspection_id":"86799566","dot_number":"3201573","report_state":"ND","report_number":"TR60002452","insp_date":"2026-01-13 00:00:00","insp_start_time":"1038","insp_end_time":"1101","registration_date":null,"region":"CS","ci_status_code":"C","location":"APPLEB","location_desc":"BISMARCK ND","county_code_state":"ND","county_code":"015","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","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":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-01-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"119200","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2768235","transaction_code":"A","transaction_date":"2026-01-14 00:00:00","upload_date":"2026-01-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":null,"census_search_date":"2026-01-15 21:40:00","snet_input_date":"2026-01-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-15 21:40:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"330 SUMMERHAYS STREET","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-18T10:44:25.000000Z","updated_at":"2026-01-26T10:30:20.000000Z","inspection_violations":[{"id":18001605,"change_date":"2026-01-15 21:40:00","inspection_id":"86799566","insp_violation_id":"271221148","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"211101370","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-18T11:00:46.000000Z","updated_at":"2026-01-26T10:30:41.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":18086826,"change_date":"2026-01-15 21:40:00","inspection_id":"86799566","insp_unit_id":"211101370","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"108","insp_unit_license":"FZ0087","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"4V4NC9EHXSN681309","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-18T10:16:46.000000Z","updated_at":"2026-01-26T10:00:23.000000Z"},{"id":18086827,"change_date":"2026-01-15 21:40:00","inspection_id":"86799566","insp_unit_id":"211101371","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":null,"insp_unit_license":"466665ST","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"1JJV532D2DL775128","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-18T10:16:46.000000Z","updated_at":"2026-01-26T10:00:23.000000Z"}]},{"id":10570149,"change_date":"2026-01-05 21:37:00","inspection_id":"86708002","dot_number":"3201573","report_state":"IA","report_number":"000P14RQQ6","insp_date":"2026-01-03 00:00:00","insp_start_time":"0946","insp_end_time":"1005","registration_date":null,"region":"CT","ci_status_code":"C","location":"45","location_desc":"45 - HWY 218 NB MM 29 PILOT GR","county_code_state":"IA","county_code":"111","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MEDLIN'S BALE CARRIERS","shipping_paper_number":"2015979403","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-01-05 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1386324","transaction_code":"A","transaction_date":"2026-01-05 00:00:00","upload_date":"2026-01-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2026-01-03 00:00:00","source_office":"3IAS001","mcmis_add_date":"2026-01-05 21:37:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"330 SUMMERHAYS STREET","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"176815","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-08T10:34:20.000000Z","updated_at":"2026-01-16T10:30:32.000000Z","inspection_violations":[{"id":17755384,"change_date":"2026-01-05 21:37:00","inspection_id":"86708002","insp_violation_id":"271013640","seq_no":"1","part_no":"393","part_no_section":"11TL","insp_viol_unit":"1","insp_unit_id":"210913061","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-08T10:38:13.000000Z","updated_at":"2026-01-16T10:31:00.000000Z","normalized_code":"39311TL"},{"id":17755385,"change_date":"2026-01-05 21:37:00","inspection_id":"86708002","insp_violation_id":"271013641","seq_no":"2","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"210913061","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-08T10:38:13.000000Z","updated_at":"2026-01-16T10:31:00.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":17711168,"change_date":"2026-01-05 21:37:00","inspection_id":"86708002","insp_unit_id":"210913061","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"106","insp_unit_license":"FP6049","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYD49X6SJ169889","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-08T10:05:42.000000Z","updated_at":"2026-01-16T10:00:42.000000Z"},{"id":17711169,"change_date":"2026-01-05 21:37:00","inspection_id":"86708002","insp_unit_id":"210913062","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VANG","insp_unit_company":"5234","insp_unit_license":"FS7032","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5V8VA532XPM305759","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-08T10:05:42.000000Z","updated_at":"2026-01-16T10:00:42.000000Z"}]},{"id":10482014,"change_date":"2026-03-13 21:37:00","inspection_id":"86616043","dot_number":"3201573","report_state":"PA","report_number":"C703535166","insp_date":"2025-12-17 00:00:00","insp_start_time":"0815","insp_end_time":"0845","registration_date":"2026-03-13 00:00:00","region":"ES","ci_status_code":"C","location":"015","location_desc":"PA","county_code_state":"PA","county_code":"031","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","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":"U","pen_cen_match":"I","final_status_date":"2026-03-13 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3002274","transaction_code":"C","transaction_date":"2026-03-13 00:00:00","upload_date":"2026-03-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":null,"census_search_date":"2026-03-13 21:37:00","snet_input_date":"2025-12-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-12-19 21:39:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"PO BOX 222","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-22T10:32:08.000000Z","updated_at":"2026-03-24T09:30:05.000000Z","inspection_violations":[{"id":19149790,"change_date":"2026-03-13 21:37:00","inspection_id":"86616043","insp_violation_id":"272386425","seq_no":"1","part_no":"392","part_no_section":"2-SLLUP","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-03-16T10:00:54.000000Z","updated_at":"2026-03-24T09:42:41.000000Z","normalized_code":"3922SLLUP"}],"inspection_per_units":[{"id":19472714,"change_date":"2026-03-13 21:37:00","inspection_id":"86616043","insp_unit_id":"212120479","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":null,"insp_unit_company":"83","insp_unit_license":"FR0347","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYD49X6SJ169892","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-16T09:17:00.000000Z","updated_at":"2026-03-24T09:05:07.000000Z"},{"id":19472715,"change_date":"2026-03-13 21:37:00","inspection_id":"86616043","insp_unit_id":"212120480","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"1442","insp_unit_license":"606514ST","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"1JJV532D5JL046374","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-16T09:17:00.000000Z","updated_at":"2026-03-24T09:05:07.000000Z"}]},{"id":9923164,"change_date":"2025-10-13 21:37:00","inspection_id":"86028760","dot_number":"3201573","report_state":"MT","report_number":"U840700327","insp_date":"2025-10-07 00:00:00","insp_start_time":"0634","insp_end_time":"0650","registration_date":null,"region":"MD","ci_status_code":"C","location":"BUTTE","location_desc":"BUTTE MT","county_code_state":"MT","county_code":"093","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","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":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-10-13 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"2402333","transaction_code":"A","transaction_date":"2025-10-13 00:00:00","upload_date":"2025-10-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":null,"census_search_date":"2025-10-13 21:37:00","snet_input_date":"2025-10-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-13 21:37:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"330 SUMMERHAYS STREET","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-16T10:00:34.000000Z","updated_at":"2025-10-17T10:00:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16469772,"change_date":"2025-10-13 21:37:00","inspection_id":"86028760","insp_unit_id":"209432653","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"109","insp_unit_license":"LR2323","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"4V4BC9EJ3TN698010","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-16T09:45:43.000000Z","updated_at":"2025-10-17T09:45:35.000000Z"},{"id":16469773,"change_date":"2025-10-13 21:37:00","inspection_id":"86028760","insp_unit_id":"209432654","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNKNOWN","insp_unit_company":null,"insp_unit_license":"FS4299","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1JJV532DXEL789361","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-16T09:45:43.000000Z","updated_at":"2025-10-17T09:45:35.000000Z"}]},{"id":9860251,"change_date":"2025-10-06 21:39:00","inspection_id":"85962651","dot_number":"3201573","report_state":"TN","report_number":"I033460089","insp_date":"2025-10-04 00:00:00","insp_start_time":"0931","insp_end_time":"0947","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"SMYRNA TN","county_code_state":"TN","county_code":"149","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"GOPHER RESOURCES","shipping_paper_number":"SHPT112253","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":"2025-10-06 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"1","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":"2370224","transaction_code":"A","transaction_date":"2025-10-05 00:00:00","upload_date":"2025-10-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":null,"census_search_date":"2025-10-06 21:39:00","snet_input_date":"2025-10-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-06 21:39:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"330 SUMMERHAYS STREET","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-09T10:00:27.000000Z","updated_at":"2025-10-10T10:00:14.000000Z","inspection_violations":[{"id":16242503,"change_date":"2025-10-06 21:39:00","inspection_id":"85962651","insp_violation_id":"269108724","seq_no":"1","part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"251942456","created_at":"2025-10-09T10:15:46.000000Z","updated_at":"2025-10-10T10:15:25.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":16352823,"change_date":"2025-10-06 21:39:00","inspection_id":"85962651","insp_unit_id":"209307517","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"105","insp_unit_license":"VF4152","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYD49X4SJ169888","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-09T09:45:33.000000Z","updated_at":"2025-10-10T09:45:16.000000Z"},{"id":16352824,"change_date":"2025-10-06 21:39:00","inspection_id":"85962651","insp_unit_id":"209307518","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"5241","insp_unit_license":"FZ0088","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3H3V532K2RS094043","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-09T09:45:33.000000Z","updated_at":"2025-10-10T09:45:16.000000Z"}]},{"id":9859074,"change_date":"2025-10-05 21:33:00","inspection_id":"85961397","dot_number":"3201573","report_state":"IN","report_number":"8879004219","insp_date":"2025-10-01 00:00:00","insp_start_time":"1830","insp_end_time":"1855","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"LAKE STATION IN","county_code_state":"IN","county_code":"089","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"AMERICAN INTERNATIONAL FOODS","shipping_paper_number":"250926022","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":"2025-10-05 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","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":"2368918","transaction_code":"A","transaction_date":"2025-10-05 00:00:00","upload_date":"2025-10-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":null,"census_search_date":"2025-10-05 21:33:00","snet_input_date":"2025-10-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-05 21:33:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"330 SUMMERHAYS STREET","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-08T10:01:30.000000Z","updated_at":"2025-10-09T10:00:21.000000Z","inspection_violations":[{"id":16239120,"change_date":"2025-10-05 21:33:00","inspection_id":"85961397","insp_violation_id":"269104885","seq_no":"1","part_no":"392","part_no_section":"2-SLLS3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-08T10:17:42.000000Z","updated_at":"2025-10-09T10:15:35.000000Z","normalized_code":"3922SLLS3"}],"inspection_per_units":[{"id":16350542,"change_date":"2025-10-05 21:33:00","inspection_id":"85961397","insp_unit_id":"209305053","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"107","insp_unit_license":"FY7100","insp_unit_license_state":"ID","insp_unit_vehicle_id_number":"1XKYD49X2SJ169890","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-08T09:46:52.000000Z","updated_at":"2025-10-09T09:45:29.000000Z"},{"id":16350543,"change_date":"2025-10-05 21:33:00","inspection_id":"85961397","insp_unit_id":"209305054","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"5181","insp_unit_license":"FY9043","insp_unit_license_state":"ID","insp_unit_vehicle_id_number":"1UYVS2536J3464202","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-08T09:46:52.000000Z","updated_at":"2025-10-09T09:45:29.000000Z"}]},{"id":9765531,"change_date":"2025-09-24 21:41:00","inspection_id":"85863167","dot_number":"3201573","report_state":"OH","report_number":"1339000645","insp_date":"2025-09-23 00:00:00","insp_start_time":"0642","insp_end_time":"0716","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"LIMA OH","county_code_state":"OH","county_code":"003","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CEDAR RIVER MILL","shipping_paper_number":"036863700027309","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-09-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","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":"2319916","transaction_code":"A","transaction_date":"2025-09-24 00:00:00","upload_date":"2025-09-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":null,"census_search_date":"2025-09-24 21:41:00","snet_input_date":"2025-09-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-24 21:41:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"330 SUMMERHAYS STREET","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-26T10:01:09.000000Z","updated_at":"2025-09-28T10:00:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16177674,"change_date":"2025-09-24 21:41:00","inspection_id":"85863167","insp_unit_id":"209117368","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH M","insp_unit_company":"106","insp_unit_license":"FP6049","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYD49X6SJ169889","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-27T09:46:19.000000Z","updated_at":"2025-09-29T09:45:35.000000Z"},{"id":16177675,"change_date":"2025-09-24 21:41:00","inspection_id":"85863167","insp_unit_id":"209117369","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"535873","insp_unit_license":"1020574ST","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"1GR1P0627TK805873","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-27T09:46:19.000000Z","updated_at":"2025-09-29T09:45:35.000000Z"}]},{"id":9507631,"change_date":"2025-08-26 21:40:00","inspection_id":"85592691","dot_number":"3201573","report_state":"SD","report_number":"5620002354","insp_date":"2025-08-26 00:00:00","insp_start_time":"1018","insp_end_time":"1053","registration_date":null,"region":"CD","ci_status_code":"C","location":"JEFFNB","location_desc":"JEFFERSON SD","county_code_state":"SD","county_code":"127","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"RAYNOR GARAGE DOORS","shipping_paper_number":"108290","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-08-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"2179343","transaction_code":"A","transaction_date":"2025-08-26 00:00:00","upload_date":"2025-08-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":null,"census_search_date":"2025-08-26 21:40:00","snet_input_date":"2025-08-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-26 21:40:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"330 SUMMERHAYS STREET","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-29T10:43:02.000000Z","updated_at":"2025-09-05T10:46:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15689168,"change_date":"2025-08-26 21:40:00","inspection_id":"85592691","insp_unit_id":"208584380","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"109","insp_unit_license":"LR2323","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"4V4BC9EJ3TN698010","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-29T09:46:38.000000Z","updated_at":"2025-09-05T09:45:42.000000Z"},{"id":15689169,"change_date":"2025-08-26 21:40:00","inspection_id":"85592691","insp_unit_id":"208584381","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VAN GUARD","insp_unit_company":"521","insp_unit_license":"HT5967","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5V8VC5329MM106997","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-29T09:46:38.000000Z","updated_at":"2025-09-05T09:45:42.000000Z"}]},{"id":8962112,"change_date":"2025-06-23 21:40:00","inspection_id":"85018893","dot_number":"3201573","report_state":"NM","report_number":"9520P4RHKQ","insp_date":"2025-06-20 00:00:00","insp_start_time":"1340","insp_end_time":"1403","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"GALLUP PORT OF ENTRY","county_code_state":"NM","county_code":"031","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"US MERCHANT","shipping_paper_number":"708815","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-06-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","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":"2197754","transaction_code":"A","transaction_date":"2025-06-20 00:00:00","upload_date":"2025-06-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":null,"census_search_date":"2025-06-23 21:40:00","snet_input_date":"2025-06-23 00:00:00","source_office":"2NMS001","mcmis_add_date":"2025-06-23 21:40:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"PO BOX 222","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"523404711","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-28T10:00:33.000000Z","updated_at":"2025-06-28T10:00:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14690697,"change_date":"2025-06-23 21:40:00","inspection_id":"85018893","insp_unit_id":"207508399","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"UNIT-83","insp_unit_license":"FR0347","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYD49X6SJ169892","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-26T09:45:36.000000Z","updated_at":"2025-06-27T09:46:01.000000Z"},{"id":14690698,"change_date":"2025-06-23 21:40:00","inspection_id":"85018893","insp_unit_id":"207508400","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"UNIT-5231","insp_unit_license":"FT8804","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1JJV532D6PL372130","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-26T09:45:36.000000Z","updated_at":"2025-06-27T09:46:01.000000Z"}]},{"id":8816613,"change_date":"2025-06-04 21:41:00","inspection_id":"84864308","dot_number":"3201573","report_state":"NE","report_number":"T456000655","insp_date":"2025-06-03 00:00:00","insp_start_time":"1018","insp_end_time":"1034","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ON US HWY 20, 1356 FEET EAST O","county_code_state":"NE","county_code":"089","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MAGRIS TALC USA","shipping_paper_number":"S182290","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-06-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","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":"816479","transaction_code":"A","transaction_date":"2025-06-04 00:00:00","upload_date":"2025-06-04 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-06-03 00:00:00","source_office":"3NES001","mcmis_add_date":"2025-06-04 21:41:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"PO BOX 222","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"176815","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-07T10:01:07.000000Z","updated_at":"2025-06-09T10:00:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14432893,"change_date":"2025-06-04 21:41:00","inspection_id":"84864308","insp_unit_id":"207225245","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"106","insp_unit_license":"FP6049","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYD49X6SJ169889","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-07T09:46:17.000000Z","updated_at":"2025-06-08T09:45:55.000000Z"},{"id":14432894,"change_date":"2025-06-04 21:41:00","inspection_id":"84864308","insp_unit_id":"207225246","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"5177","insp_unit_license":"FW8359","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1JJV532D3HL971746","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-07T09:46:17.000000Z","updated_at":"2025-06-08T09:45:55.000000Z"}]},{"id":8212629,"change_date":"2025-03-26 21:40:00","inspection_id":"84228153","dot_number":"3201573","report_state":"IA","report_number":"000P131VWN","insp_date":"2025-03-25 00:00:00","insp_start_time":"1526","insp_end_time":"1550","registration_date":null,"region":"CT","ci_status_code":"C","location":"45","location_desc":"45 - HWY 218 NB MM 29 PILOT GR","county_code_state":"IA","county_code":"111","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"REFRESCO BEVERAGES US INC","shipping_paper_number":"85598879","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-03-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"121300","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":"1354262","transaction_code":"A","transaction_date":"2025-03-26 00:00:00","upload_date":"2025-03-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-03-25 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-03-26 21:40:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"330 SUMMERHAYS STREET","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"176815","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-29T10:21:15.000000Z","updated_at":"2025-03-30T10:35:52.000000Z","inspection_violations":[{"id":12881997,"change_date":"2025-03-26 21:40:00","inspection_id":"84228153","insp_violation_id":"265259449","seq_no":"1","part_no":"390","part_no_section":"19B2-BIENNIAL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-28T10:58:02.000000Z","updated_at":"2025-03-29T10:39:09.000000Z","normalized_code":"39019B2BIENNIAL"},{"id":12881998,"change_date":"2025-03-26 21:40:00","inspection_id":"84228153","insp_violation_id":"265259450","seq_no":"2","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"8GNA25032515344","created_at":"2025-03-28T10:58:02.000000Z","updated_at":"2025-03-29T10:39:09.000000Z","normalized_code":"3922SLLEWA1"}],"inspection_per_units":[{"id":13280125,"change_date":"2025-03-26 21:40:00","inspection_id":"84228153","insp_unit_id":"205994543","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"103","insp_unit_license":"FA4020","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYD49X0SJ169886","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-29T10:08:32.000000Z","updated_at":"2025-03-30T10:04:35.000000Z"},{"id":13280126,"change_date":"2025-03-26 21:40:00","inspection_id":"84228153","insp_unit_id":"205994544","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VANR","insp_unit_company":"5233","insp_unit_license":"FT0323","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5V8VA5328PM305758","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-29T10:08:32.000000Z","updated_at":"2025-03-30T10:04:35.000000Z"}]},{"id":8130127,"change_date":"2025-03-17 21:39:00","inspection_id":"84140750","dot_number":"3201573","report_state":"IN","report_number":"9005000551","insp_date":"2025-03-13 00:00:00","insp_start_time":"0556","insp_end_time":"0629","registration_date":null,"region":"ED","ci_status_code":"C","location":"5370E","location_desc":"TERRE HAUTE IN","county_code_state":"IN","county_code":"167","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"4M WORLD BUSINESS","shipping_paper_number":"507283510","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-03-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","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":"1478452","transaction_code":"A","transaction_date":"2025-03-16 00:00:00","upload_date":"2025-03-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":null,"census_search_date":"2025-03-17 21:39:00","snet_input_date":"2025-03-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-17 21:39:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"330 SUMMERHAYS STREET","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-21T10:16:20.000000Z","updated_at":"2025-03-21T10:16:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13127544,"change_date":"2025-03-17 21:39:00","inspection_id":"84140750","insp_unit_id":"205828184","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"105","insp_unit_license":"VF4152","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYD49X4SJ169888","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-21T09:50:09.000000Z","updated_at":"2025-03-21T09:57:25.000000Z"},{"id":13127545,"change_date":"2025-03-17 21:39:00","inspection_id":"84140750","insp_unit_id":"205828185","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"5178","insp_unit_license":"FW2657","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1JJV532D5HL971747","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-21T09:50:09.000000Z","updated_at":"2025-03-21T09:57:25.000000Z"}]},{"id":8084722,"change_date":"2025-03-11 21:41:00","inspection_id":"84092917","dot_number":"3201573","report_state":"NE","report_number":"T035000768","insp_date":"2025-03-11 00:00:00","insp_start_time":"1339","insp_end_time":"1350","registration_date":null,"region":"CT","ci_status_code":"C","location":"9","location_desc":"NORTH PLATTE WEST BOUND","county_code_state":"NE","county_code":"111","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"RAYNOR GARGE DOORS","shipping_paper_number":"105926","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-03-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"810011","transaction_code":"A","transaction_date":"2025-03-11 00:00:00","upload_date":"2025-03-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-03-11 00:00:00","source_office":"3NES001","mcmis_add_date":"2025-03-11 21:41:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"PO BOX 222","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"176815","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:06:15.000000Z","updated_at":"2025-03-17T21:06:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13053125,"change_date":"2025-03-11 21:41:00","inspection_id":"84092917","insp_unit_id":"205737508","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"FR6327","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYD49X2SJ169887","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:17.000000Z","updated_at":"2025-03-17T23:59:17.000000Z"},{"id":13053126,"change_date":"2025-03-11 21:41:00","inspection_id":"84092917","insp_unit_id":"205737509","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GRDN","insp_unit_company":null,"insp_unit_license":"711722ST","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"1GR1A0620LT155103","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:17.000000Z","updated_at":"2025-03-17T23:59:17.000000Z"}]},{"id":7871709,"change_date":"2025-02-14 21:40:00","inspection_id":"83869191","dot_number":"3201573","report_state":"IN","report_number":"6215000471","insp_date":"2025-02-11 00:00:00","insp_start_time":"1703","insp_end_time":"1741","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"KNIGHTSTOWN IN","county_code_state":"IN","county_code":"065","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"GENERAL MILLS OPERATIONS","shipping_paper_number":"20953832292","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":"2025-02-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"2","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":"1362473","transaction_code":"A","transaction_date":"2025-02-14 00:00:00","upload_date":"2025-02-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":null,"census_search_date":"2025-02-14 21:40:00","snet_input_date":"2025-02-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-14 21:40:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"330 SUMMERHAYS STREET","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:01:34.000000Z","updated_at":"2025-03-17T21:01:34.000000Z","inspection_violations":[{"id":12302360,"change_date":"2025-02-14 21:40:00","inspection_id":"83869191","insp_violation_id":"264522674","seq_no":"1","part_no":"392","part_no_section":"2-SLLFC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:05.000000Z","updated_at":"2025-03-17T22:06:05.000000Z","normalized_code":"3922SLLFC"},{"id":12302361,"change_date":"2025-02-14 21:40:00","inspection_id":"83869191","insp_violation_id":"264522675","seq_no":"2","part_no":"395","part_no_section":"24","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:05.000000Z","updated_at":"2025-03-17T22:06:05.000000Z","normalized_code":"39524"}],"inspection_per_units":[{"id":12705166,"change_date":"2025-02-14 21:40:00","inspection_id":"83869191","insp_unit_id":"205327816","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"051","insp_unit_license":"FS4829","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYD49X4SJ169891","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:21.000000Z","updated_at":"2025-03-17T23:55:21.000000Z"},{"id":12705167,"change_date":"2025-02-14 21:40:00","inspection_id":"83869191","insp_unit_id":"205327817","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"5177","insp_unit_license":"FW8359","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1JJV532D3HL971746","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:21.000000Z","updated_at":"2025-03-17T23:55:21.000000Z"}]},{"id":7699643,"change_date":"2025-01-24 21:39:00","inspection_id":"83688318","dot_number":"3201573","report_state":"SD","report_number":"HP15900038","insp_date":"2025-01-24 00:00:00","insp_start_time":"0905","insp_end_time":"0911","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"MITCHELL SD","county_code_state":"SD","county_code":"035","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SOFIDEL","shipping_paper_number":"1566754","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-01-24 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"600000","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":"1283513","transaction_code":"A","transaction_date":"2025-01-24 00:00:00","upload_date":"2025-01-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":null,"census_search_date":"2025-01-24 21:39:00","snet_input_date":"2025-01-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-24 21:39:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"330 SUMMERHAYS STREET","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:57:57.000000Z","updated_at":"2025-03-17T20:57:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12424751,"change_date":"2025-01-24 21:39:00","inspection_id":"83688318","insp_unit_id":"204988064","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"FS4829","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYD49X4SJ169891","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:05.000000Z","updated_at":"2025-03-17T23:52:05.000000Z"},{"id":12424752,"change_date":"2025-01-24 21:39:00","inspection_id":"83688318","insp_unit_id":"204988065","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":null,"insp_unit_license":"FT8804","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1JJV532D6PL372130","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:05.000000Z","updated_at":"2025-03-17T23:52:05.000000Z"}]},{"id":7709104,"change_date":"2025-01-25 21:33:00","inspection_id":"83698259","dot_number":"3201573","report_state":"NM","report_number":"5370P0OHL3","insp_date":"2025-01-24 00:00:00","insp_start_time":"1334","insp_end_time":"1405","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"TEXICO PORT OF ENTRY","county_code_state":"NM","county_code":"009","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"RAYNOR GARAGE DOOR","shipping_paper_number":"105358","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-25 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","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":"2143603","transaction_code":"A","transaction_date":"2025-01-24 00:00:00","upload_date":"2025-01-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":null,"census_search_date":"2025-01-25 21:33:00","snet_input_date":"2025-01-25 00:00:00","source_office":"2NMS001","mcmis_add_date":"2025-01-25 21:33:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"PO BOX 222","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:58:18.000000Z","updated_at":"2025-03-17T20:58:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12440121,"change_date":"2025-01-25 21:33:00","inspection_id":"83698259","insp_unit_id":"205006472","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"TRK 23","insp_unit_license":"FX8123","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"4V4NC9EH3RN662000","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:18.000000Z","updated_at":"2025-03-17T23:52:18.000000Z"},{"id":12440122,"change_date":"2025-01-25 21:33:00","inspection_id":"83698259","insp_unit_id":"205006473","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"TRL 5178","insp_unit_license":"FW2657","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1JJV532D5HL971747","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:18.000000Z","updated_at":"2025-03-17T23:52:18.000000Z"}]},{"id":7691696,"change_date":"2025-01-23 21:38:00","inspection_id":"83680000","dot_number":"3201573","report_state":"MO","report_number":"W132007541","insp_date":"2025-01-23 00:00:00","insp_start_time":"0933","insp_end_time":"1004","registration_date":null,"region":"CS","ci_status_code":"C","location":"D4E","location_desc":"JOPLIN MO","county_code_state":"MO","county_code":"145","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"HEINEKEN USA INCORPORATED\/DHL BEVPROS","shipping_paper_number":"1010086627","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-01-23 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","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":"1280237","transaction_code":"A","transaction_date":"2025-01-23 00:00:00","upload_date":"2025-01-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":null,"census_search_date":"2025-01-23 21:38:00","snet_input_date":"2025-01-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-23 21:38:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"330 SUMMERHAYS STREET","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:57:54.000000Z","updated_at":"2025-03-17T20:57:54.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12411694,"change_date":"2025-01-23 21:38:00","inspection_id":"83680000","insp_unit_id":"204972018","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"105","insp_unit_license":"VF4152","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYD49X4SJ169888","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:58.000000Z","updated_at":"2025-03-17T23:51:58.000000Z"},{"id":12411695,"change_date":"2025-01-23 21:38:00","inspection_id":"83680000","insp_unit_id":"204972019","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"5179","insp_unit_license":"FW2658","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1JJV532D7HL971748","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:58.000000Z","updated_at":"2025-03-17T23:51:58.000000Z"}]},{"id":7607137,"change_date":"2025-01-13 21:46:00","inspection_id":"83591381","dot_number":"3201573","report_state":"NE","report_number":"T478001104","insp_date":"2025-01-12 00:00:00","insp_start_time":"0920","insp_end_time":"0939","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ON US HWY 20, 2298 FEET EAST O","county_code_state":"NE","county_code":"089","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"HUBBARDB FEEDS INCORPATED","shipping_paper_number":"5287516","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-13 21:46:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"805868","transaction_code":"A","transaction_date":"2025-01-13 00:00:00","upload_date":"2025-01-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-01-13 00:00:00","source_office":"3NES001","mcmis_add_date":"2025-01-13 21:46:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"PO BOX 222","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"176815","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:56:07.000000Z","updated_at":"2025-03-17T20:56:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12274643,"change_date":"2025-01-13 21:46:00","inspection_id":"83591381","insp_unit_id":"204783572","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"106","insp_unit_license":"FP6049","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYD49X6SJ169889","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:27.000000Z","updated_at":"2025-03-17T23:50:27.000000Z"},{"id":12274644,"change_date":"2025-01-13 21:46:00","inspection_id":"83591381","insp_unit_id":"204783573","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VANR","insp_unit_company":"5211","insp_unit_license":"HT5967","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5V8VC5329MM106997","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:27.000000Z","updated_at":"2025-03-17T23:50:27.000000Z"}]},{"id":7551468,"change_date":"2025-01-06 21:38:00","inspection_id":"83532784","dot_number":"3201573","report_state":"SD","report_number":"1620000699","insp_date":"2025-01-05 00:00:00","insp_start_time":"1232","insp_end_time":"1255","registration_date":null,"region":"CS","ci_status_code":"C","location":"SUFLSW","location_desc":"VALLEY SPRINGS SD","county_code_state":"SD","county_code":"099","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CEREAL BYEPRODUCTS COMPANY","shipping_paper_number":"233741","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-01-06 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","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":"1217614","transaction_code":"A","transaction_date":"2025-01-05 00:00:00","upload_date":"2025-01-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":null,"census_search_date":"2025-01-06 21:38:00","snet_input_date":"2025-01-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-06 21:38:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"330 SUMMERHAYS STREET","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:54:54.000000Z","updated_at":"2025-03-17T20:54:54.000000Z","inspection_violations":[{"id":11803318,"change_date":"2025-01-06 21:38:00","inspection_id":"83532784","insp_violation_id":"263762875","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"B124019-HP","created_at":"2025-03-17T22:03:32.000000Z","updated_at":"2025-03-17T22:03:32.000000Z","normalized_code":"3922SLLEWA1"}],"inspection_per_units":[{"id":12184114,"change_date":"2025-01-06 21:38:00","inspection_id":"83532784","insp_unit_id":"204657859","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"011","insp_unit_license":"VF4152","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYD49X4SJ169888","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:29.000000Z","updated_at":"2025-03-17T23:49:29.000000Z"},{"id":12184115,"change_date":"2025-01-06 21:38:00","inspection_id":"83532784","insp_unit_id":"204657860","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"5140","insp_unit_license":"FS4299","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1JJV532DXEL789361","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:29.000000Z","updated_at":"2025-03-17T23:49:29.000000Z"}]},{"id":7553422,"change_date":"2025-01-06 21:39:00","inspection_id":"83534844","dot_number":"3201573","report_state":"SD","report_number":"5730000340","insp_date":"2025-01-05 00:00:00","insp_start_time":"1227","insp_end_time":"1258","registration_date":null,"region":"MS","ci_status_code":"C","location":"TILFRD","location_desc":"TILFORD SD","county_code_state":"SD","county_code":"093","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"GENERAL MILLS OPERATIONS","shipping_paper_number":"2095298422","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-01-06 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1220057","transaction_code":"A","transaction_date":"2025-01-06 00:00:00","upload_date":"2025-01-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":null,"census_search_date":"2025-01-06 21:39:00","snet_input_date":"2025-01-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-06 21:39:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"330 SUMMERHAYS STREET","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:54:55.000000Z","updated_at":"2025-03-17T20:54:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12187383,"change_date":"2025-01-06 21:39:00","inspection_id":"83534844","insp_unit_id":"204661438","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":null,"insp_unit_license":"TEMP","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3H3V532K4RS094044","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:32.000000Z","updated_at":"2025-03-17T23:49:32.000000Z"},{"id":12187384,"change_date":"2025-01-06 21:39:00","inspection_id":"83534844","insp_unit_id":"204661439","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"83","insp_unit_license":"FR0347","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYD49X6SJ169892","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:32.000000Z","updated_at":"2025-03-17T23:49:32.000000Z"}]},{"id":7508521,"change_date":"2024-12-27 21:38:00","inspection_id":"83487738","dot_number":"3201573","report_state":"IA","report_number":"000P15WDBD","insp_date":"2024-12-26 00:00:00","insp_start_time":"1239","insp_end_time":"1320","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"US 30 E 5 MM","county_code_state":"IA","county_code":"085","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"PIONEER HI-BRED","shipping_paper_number":"1410298594","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":"2024-12-27 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"120300","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1343375","transaction_code":"A","transaction_date":"2024-12-27 00:00:00","upload_date":"2024-12-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-12-26 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-12-27 21:38:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"330 SUMMERHAYS STREET","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"176815","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:52:41.000000Z","updated_at":"2025-03-17T20:52:41.000000Z","inspection_violations":[{"id":11733873,"change_date":"2024-12-27 21:38:00","inspection_id":"83487738","insp_violation_id":"263670739","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:09.000000Z","updated_at":"2025-03-17T22:03:09.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":12113034,"change_date":"2024-12-27 21:38:00","inspection_id":"83487738","insp_unit_id":"204571621","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"107","insp_unit_license":"FY7100","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYD49X2SJ169890","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:43.000000Z","updated_at":"2025-03-17T23:48:43.000000Z"},{"id":12113035,"change_date":"2024-12-27 21:38:00","inspection_id":"83487738","insp_unit_id":"204571622","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"5231","insp_unit_license":"FT8804","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1JJV532D6PL372130","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:43.000000Z","updated_at":"2025-03-17T23:48:43.000000Z"}]},{"id":7401851,"change_date":"2024-12-12 21:41:00","inspection_id":"83375632","dot_number":"3201573","report_state":"SD","report_number":"5810000822","insp_date":"2024-12-12 00:00:00","insp_start_time":"0851","insp_end_time":"0920","registration_date":null,"region":"MS","ci_status_code":"C","location":"TILFRD","location_desc":"TILFORD SD","county_code_state":"SD","county_code":"093","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MONTANA FLOUR AND GRAIN, INC","shipping_paper_number":"43652","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":"2024-12-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"121000","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":"1149410","transaction_code":"A","transaction_date":"2024-12-12 00:00:00","upload_date":"2024-12-12 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":null,"census_search_date":"2024-12-12 21:41:00","snet_input_date":"2024-12-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-12-12 21:41:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"330 SUMMERHAYS STREET","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:50:43.000000Z","updated_at":"2025-03-17T20:50:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11940637,"change_date":"2024-12-12 21:41:00","inspection_id":"83375632","insp_unit_id":"204341576","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"83","insp_unit_license":"FR037","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYD49X6SJ169892","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:51.000000Z","updated_at":"2025-03-17T23:46:51.000000Z"},{"id":11940638,"change_date":"2024-12-12 21:41:00","inspection_id":"83375632","insp_unit_id":"204341577","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"535103","insp_unit_license":"711722ST","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"1GR1A0620LT155103","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:51.000000Z","updated_at":"2025-03-17T23:46:51.000000Z"}]},{"id":7003906,"change_date":"2024-10-21 21:41:00","inspection_id":"82955058","dot_number":"3201573","report_state":"NE","report_number":"T236000022","insp_date":"2024-10-18 00:00:00","insp_start_time":"1519","insp_end_time":"1532","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"ON I- 80, 658 FEET EAST OF MIL","county_code_state":"NE","county_code":"033","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"QUALITY OVERHEAD DOOR","shipping_paper_number":"R5542530B XR005","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-10-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","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":"800019","transaction_code":"A","transaction_date":"2024-10-21 00:00:00","upload_date":"2024-10-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-10-21 00:00:00","source_office":"3NES001","mcmis_add_date":"2024-10-21 21:41:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"PO BOX 222","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"176815","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:42:14.000000Z","updated_at":"2025-03-17T20:42:14.000000Z","inspection_violations":[{"id":10928480,"change_date":"2024-10-21 21:41:00","inspection_id":"82955058","insp_violation_id":"262461351","seq_no":"1","part_no":"392","part_no_section":"2MI","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":"2025-03-17T21:59:01.000000Z","updated_at":"2025-03-17T21:59:01.000000Z","normalized_code":"3922MI"},{"id":10928481,"change_date":"2024-10-21 21:41:00","inspection_id":"82955058","insp_violation_id":"262461352","seq_no":"2","part_no":"395","part_no_section":"24D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:01.000000Z","updated_at":"2025-03-17T21:59:01.000000Z","normalized_code":"39524D"},{"id":10928482,"change_date":"2024-10-21 21:41:00","inspection_id":"82955058","insp_violation_id":"262461353","seq_no":"3","part_no":"395","part_no_section":"22H1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:01.000000Z","updated_at":"2025-03-17T21:59:01.000000Z","normalized_code":"39522H1"}],"inspection_per_units":[{"id":11297104,"change_date":"2024-10-21 21:41:00","inspection_id":"82955058","insp_unit_id":"203504031","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"108","insp_unit_license":"FZ0087","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"4V4NC9EHXSN681309","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:58.000000Z","updated_at":"2025-03-17T23:39:58.000000Z"},{"id":11297105,"change_date":"2024-10-21 21:41:00","inspection_id":"82955058","insp_unit_id":"203504032","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"5232","insp_unit_license":"FT8803","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1JJV532D8PL372131","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:58.000000Z","updated_at":"2025-03-17T23:39:58.000000Z"}]},{"id":6779387,"change_date":"2024-09-20 21:42:00","inspection_id":"82716177","dot_number":"3201573","report_state":"NM","report_number":"4304O7BGSH","insp_date":"2024-09-19 00:00:00","insp_start_time":"1323","insp_end_time":"1343","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"LORDSBURG PORT OF ENTRY","county_code_state":"NM","county_code":"023","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"LUCID AMP","shipping_paper_number":"4500084477","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":"2024-09-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"2118082","transaction_code":"A","transaction_date":"2024-09-19 00:00:00","upload_date":"2024-09-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":null,"census_search_date":"2024-09-20 21:42:00","snet_input_date":"2024-09-20 00:00:00","source_office":"2NMS001","mcmis_add_date":"2024-09-20 21:42:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"PO BOX 222","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"523404711","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:37:23.000000Z","updated_at":"2025-03-17T20:37:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10932186,"change_date":"2024-09-20 21:42:00","inspection_id":"82716177","insp_unit_id":"203049981","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KWMT","insp_unit_company":"UNIT83","insp_unit_license":"FR0347","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYD49X6SJ169892","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:15.000000Z","updated_at":"2025-03-17T23:36:15.000000Z"},{"id":10932187,"change_date":"2024-09-20 21:42:00","inspection_id":"82716177","insp_unit_id":"203049982","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"UNIT5232","insp_unit_license":"FT8803","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1JJV532D9PL372131","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:15.000000Z","updated_at":"2025-03-17T23:36:15.000000Z"}]},{"id":6718913,"change_date":"2024-09-13 21:41:00","inspection_id":"82651704","dot_number":"3201573","report_state":"UT","report_number":"24GD001597","insp_date":"2024-09-12 00:00:00","insp_start_time":"0711","insp_end_time":"0726","registration_date":null,"region":"MD","ci_status_code":"C","location":"UT91","location_desc":"HELPER UT","county_code_state":"UT","county_code":"007","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"RAYNOR GARAGE DOORS","shipping_paper_number":"R5542530B","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":"2024-09-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","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":"843675","transaction_code":"A","transaction_date":"2024-09-13 00:00:00","upload_date":"2024-09-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":null,"census_search_date":"2024-09-13 21:41:00","snet_input_date":"2024-09-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-13 21:41:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"330 SUMMERHAYS STREET","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:36:09.000000Z","updated_at":"2025-03-17T20:36:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10833948,"change_date":"2024-09-13 21:41:00","inspection_id":"82651704","insp_unit_id":"202907854","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"051","insp_unit_license":"FS4829","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYD49X4SJ169891","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:10.000000Z","updated_at":"2025-03-17T23:35:10.000000Z"},{"id":10833949,"change_date":"2024-09-13 21:41:00","inspection_id":"82651704","insp_unit_id":"202907855","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"5175","insp_unit_license":"FW8357","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1JJV532DXHL971744","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:10.000000Z","updated_at":"2025-03-17T23:35:10.000000Z"}]},{"id":6423550,"change_date":"2024-08-08 21:42:00","inspection_id":"82337065","dot_number":"3201573","report_state":"IL","report_number":"4037081045","insp_date":"2024-08-07 00:00:00","insp_start_time":"0422","insp_end_time":"0444","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I-80","county_code_state":"IL","county_code":"099","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"ALFAHAY LLC","shipping_paper_number":"1037812925","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-08-08 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"121000","viol_total":"2","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":"2345112","transaction_code":"A","transaction_date":"2024-08-07 00:00:00","upload_date":"2024-08-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-08-07 00:00:00","source_office":"3ILS001","mcmis_add_date":"2024-08-08 21:42:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"330 SUMMERHAYS STREET","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"176815","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:30:16.000000Z","updated_at":"2025-03-17T20:30:16.000000Z","inspection_violations":[{"id":9973886,"change_date":"2024-08-08 21:42:00","inspection_id":"82337065","insp_violation_id":"261091220","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":"99","citation_number":null,"created_at":"2025-03-17T21:54:14.000000Z","updated_at":"2025-03-17T21:54:14.000000Z","normalized_code":"3922"},{"id":9973887,"change_date":"2024-08-08 21:42:00","inspection_id":"82337065","insp_violation_id":"261091221","seq_no":"2","part_no":"393","part_no_section":"55(d)(1)","insp_viol_unit":"1","insp_unit_id":"202302485","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:54:14.000000Z","updated_at":"2025-03-17T21:54:14.000000Z","normalized_code":"39355D1"}],"inspection_per_units":[{"id":10352515,"change_date":"2024-08-08 21:42:00","inspection_id":"82337065","insp_unit_id":"202302485","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"011","insp_unit_license":"VF4152","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYD49X4SJ169888","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:18.000000Z","updated_at":"2025-03-17T23:30:18.000000Z"},{"id":10352516,"change_date":"2024-08-08 21:42:00","inspection_id":"82337065","insp_unit_id":"202302486","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABA","insp_unit_company":"535092","insp_unit_license":"935008ST","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"1JJV532D7RL435092","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:18.000000Z","updated_at":"2025-03-17T23:30:18.000000Z"}]},{"id":6327881,"change_date":"2024-07-29 21:41:00","inspection_id":"82234667","dot_number":"3201573","report_state":"SD","report_number":"5540001854","insp_date":"2024-07-26 00:00:00","insp_start_time":"0555","insp_end_time":"0615","registration_date":null,"region":"CD","ci_status_code":"C","location":"JEFFNB","location_desc":"JEFFERSON SD","county_code_state":"SD","county_code":"127","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"RAYNOR GARAGE DOORS","shipping_paper_number":"102749","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":"2024-07-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"692397","transaction_code":"A","transaction_date":"2024-07-28 00:00:00","upload_date":"2024-07-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":null,"census_search_date":"2024-07-29 21:41:00","snet_input_date":"2024-07-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-29 21:41:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"330 SUMMERHAYS STREET","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:28:15.000000Z","updated_at":"2025-03-17T20:28:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10196576,"change_date":"2024-07-29 21:41:00","inspection_id":"82234667","insp_unit_id":"202108387","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"107","insp_unit_license":"TEMP","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYD49X2SJ169890","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:37.000000Z","updated_at":"2025-03-17T23:28:37.000000Z"},{"id":10196577,"change_date":"2024-07-29 21:41:00","inspection_id":"82234667","insp_unit_id":"202108388","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"5179","insp_unit_license":"FW2658","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1JJV532D7HL971748","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:37.000000Z","updated_at":"2025-03-17T23:28:37.000000Z"}]},{"id":6559162,"change_date":"2024-08-26 21:41:00","inspection_id":"82481648","dot_number":"3201573","report_state":"MN","report_number":"1641000243","insp_date":"2024-07-26 00:00:00","insp_start_time":"0840","insp_end_time":"0928","registration_date":null,"region":"CD","ci_status_code":"C","location":"WTHTN","location_desc":"WORTHINGTON MN","county_code_state":"MN","county_code":"105","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"N\/A","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-08-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"1","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":"784413","transaction_code":"A","transaction_date":"2024-08-26 00:00:00","upload_date":"2024-08-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":null,"census_search_date":"2024-08-26 21:41:00","snet_input_date":"2024-07-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-26 21:41:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"330 SUMMERHAYS STREET","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:32:50.000000Z","updated_at":"2025-03-17T20:32:50.000000Z","inspection_violations":[{"id":10192169,"change_date":"2024-08-26 21:41:00","inspection_id":"82481648","insp_violation_id":"261398498","seq_no":"1","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"202576690","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:55:19.000000Z","updated_at":"2025-03-17T21:55:19.000000Z","normalized_code":"39345D"}],"inspection_per_units":[{"id":10574341,"change_date":"2024-08-26 21:41:00","inspection_id":"82481648","insp_unit_id":"202576690","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"51","insp_unit_license":"FS4829","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYD49X4SJ169891","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:31.000000Z","updated_at":"2025-03-17T23:32:31.000000Z"},{"id":10574342,"change_date":"2024-08-26 21:41:00","inspection_id":"82481648","insp_unit_id":"202576691","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNKNOWN","insp_unit_company":"5222","insp_unit_license":"FW8254","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1JJV532D6NL325905","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:31.000000Z","updated_at":"2025-03-17T23:32:31.000000Z"}]},{"id":6109506,"change_date":"2024-06-30 21:33:00","inspection_id":"82000346","dot_number":"3201573","report_state":"NM","report_number":"5370O50BJR","insp_date":"2024-06-28 00:00:00","insp_start_time":"0925","insp_end_time":"1000","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"TEXICO PORT OF ENTRY","county_code_state":"NM","county_code":"009","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"RAYNOR GARAGE DOORS","shipping_paper_number":"102356","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":"2024-06-30 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","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":"2099212","transaction_code":"A","transaction_date":"2024-06-28 00:00:00","upload_date":"2024-06-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":null,"census_search_date":"2024-06-30 21:33:00","snet_input_date":"2024-06-30 00:00:00","source_office":"2NMS001","mcmis_add_date":"2024-06-30 21:33:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"PO BOX 222","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:23:46.000000Z","updated_at":"2025-03-17T20:23:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9840636,"change_date":"2024-06-30 21:33:00","inspection_id":"82000346","insp_unit_id":"201660967","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"TRK 20","insp_unit_license":"FW0090","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"4V4NC9EH6RN630075","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:57.000000Z","updated_at":"2025-03-17T23:24:57.000000Z"},{"id":9840637,"change_date":"2024-06-30 21:33:00","inspection_id":"82000346","insp_unit_id":"201660968","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"TRL 5177","insp_unit_license":"FW8359","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1JJV532D3HL971746","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:57.000000Z","updated_at":"2025-03-17T23:24:57.000000Z"}]},{"id":6069206,"change_date":"2024-06-25 21:41:00","inspection_id":"81957088","dot_number":"3201573","report_state":"SD","report_number":"HP11200016","insp_date":"2024-06-25 00:00:00","insp_start_time":"1155","insp_end_time":"1201","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"BRISTOL SD","county_code_state":"SD","county_code":"037","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":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-06-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"599240","transaction_code":"A","transaction_date":"2024-06-25 00:00:00","upload_date":"2024-06-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":null,"census_search_date":"2024-06-25 21:41:00","snet_input_date":"2024-06-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-06-25 21:41:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"330 SUMMERHAYS STREET","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:22:59.000000Z","updated_at":"2025-03-17T20:22:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9775357,"change_date":"2024-06-25 21:41:00","inspection_id":"81957088","insp_unit_id":"201573627","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"07","insp_unit_license":"IA0022533","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYD49XXKJ244559","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:16.000000Z","updated_at":"2025-03-17T23:24:16.000000Z"},{"id":9775358,"change_date":"2024-06-25 21:41:00","inspection_id":"81957088","insp_unit_id":"201573628","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":null,"insp_unit_license":"606513ST","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"1JJV532D3JL046373","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:16.000000Z","updated_at":"2025-03-17T23:24:16.000000Z"}]},{"id":6003233,"change_date":"2024-06-17 21:42:00","inspection_id":"81885947","dot_number":"3201573","report_state":"UT","report_number":"24KF001272","insp_date":"2024-06-11 00:00:00","insp_start_time":"1347","insp_end_time":"1519","registration_date":null,"region":"MD","ci_status_code":"C","location":"UT70","location_desc":"MONTICELLO UT","county_code_state":"UT","county_code":"037","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"TICONA","shipping_paper_number":"2403271747","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-06-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","viol_total":"2","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":"575141","transaction_code":"A","transaction_date":"2024-06-17 00:00:00","upload_date":"2024-06-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":null,"census_search_date":"2024-06-17 21:42:00","snet_input_date":"2024-06-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-06-17 21:42:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"330 SUMMERHAYS STREET","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:21:50.000000Z","updated_at":"2025-03-17T20:21:50.000000Z","inspection_violations":[{"id":9313402,"change_date":"2024-06-17 21:42:00","inspection_id":"81885947","insp_violation_id":"260110731","seq_no":"1","part_no":"395","part_no_section":"22(h)(4)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:03.000000Z","updated_at":"2025-03-17T21:51:03.000000Z","normalized_code":"39522H4"},{"id":9313403,"change_date":"2024-06-17 21:42:00","inspection_id":"81885947","insp_violation_id":"260110732","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"C247000259","created_at":"2025-03-17T21:51:03.000000Z","updated_at":"2025-03-17T21:51:03.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9669119,"change_date":"2024-06-17 21:42:00","inspection_id":"81885947","insp_unit_id":"201418023","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"23","insp_unit_license":"FX8123","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"4V4NC9EH3RN662000","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:12.000000Z","updated_at":"2025-03-17T23:23:12.000000Z"},{"id":9669120,"change_date":"2024-06-17 21:42:00","inspection_id":"81885947","insp_unit_id":"201418024","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"5177","insp_unit_license":"FW8359","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1JJV532D3HL971746","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:12.000000Z","updated_at":"2025-03-17T23:23:12.000000Z"}]},{"id":5844298,"change_date":"2024-05-27 21:34:00","inspection_id":"81713306","dot_number":"3201573","report_state":"AZ","report_number":"1089200013","insp_date":"2024-05-16 00:00:00","insp_start_time":"1818","insp_end_time":"1846","registration_date":null,"region":"MS","ci_status_code":"C","location":null,"location_desc":"HEBER AZ","county_code_state":"AZ","county_code":"017","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CLEAR CREEK EXP. LLC","shipping_paper_number":"271671265","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":"2024-05-27 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"1","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":"516583","transaction_code":"A","transaction_date":"2024-05-27 00:00:00","upload_date":"2024-05-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":null,"census_search_date":"2024-05-27 21:34:00","snet_input_date":"2024-05-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-27 21:34:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"330 SUMMERHAYS STREET","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:18:38.000000Z","updated_at":"2025-03-17T20:18:38.000000Z","inspection_violations":[{"id":9057759,"change_date":"2024-05-27 21:34:00","inspection_id":"81713306","insp_violation_id":"259732886","seq_no":"1","part_no":"395","part_no_section":"24","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:45.000000Z","updated_at":"2025-03-17T21:49:45.000000Z","normalized_code":"39524"}],"inspection_per_units":[{"id":9412468,"change_date":"2024-05-27 21:34:00","inspection_id":"81713306","insp_unit_id":"201088021","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"103","insp_unit_license":"FA4020","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYD49X0SJ169886","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:41.000000Z","updated_at":"2025-03-17T23:20:41.000000Z"},{"id":9412469,"change_date":"2024-05-27 21:34:00","inspection_id":"81713306","insp_unit_id":"201088022","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CIMC VEHIC","insp_unit_company":"5234","insp_unit_license":"FS7032","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5V8VA532XPM305759","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:41.000000Z","updated_at":"2025-03-17T23:20:41.000000Z"}]},{"id":5791537,"change_date":"2024-05-20 21:42:00","inspection_id":"81655935","dot_number":"3201573","report_state":"NM","report_number":"5370O3R89H","insp_date":"2024-05-14 00:00:00","insp_start_time":"0720","insp_end_time":"0755","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"TEXICO PORT OF ENTRY","county_code_state":"NM","county_code":"009","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"RAYNOR GARAGE DOOR","shipping_paper_number":"101627","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":"2024-05-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","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":"2091045","transaction_code":"A","transaction_date":"2024-05-15 00:00:00","upload_date":"2024-05-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":null,"census_search_date":"2024-05-20 21:42:00","snet_input_date":"2024-05-16 00:00:00","source_office":"2NMS001","mcmis_add_date":"2024-05-20 21:42:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"PO BOX 222","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:17:31.000000Z","updated_at":"2025-03-17T20:17:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9327976,"change_date":"2024-05-20 21:42:00","inspection_id":"81655935","insp_unit_id":"200979427","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"TRK 103","insp_unit_license":"FA4020","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYD49X0SJ169886","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:50.000000Z","updated_at":"2025-03-17T23:19:50.000000Z"},{"id":9327977,"change_date":"2024-05-20 21:42:00","inspection_id":"81655935","insp_unit_id":"200979428","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VANGUARD","insp_unit_company":"TRL 5234","insp_unit_license":"FS7032","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5V8VA532XPM305759","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:50.000000Z","updated_at":"2025-03-17T23:19:50.000000Z"}]},{"id":5685992,"change_date":"2024-05-07 21:42:00","inspection_id":"81541530","dot_number":"3201573","report_state":"MT","report_number":"U610000355","insp_date":"2024-05-03 00:00:00","insp_start_time":"1807","insp_end_time":"1901","registration_date":null,"region":"MD","ci_status_code":"C","location":"BRODUS","location_desc":"BROADUS MT","county_code_state":"MT","county_code":"075","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"N\/A","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-05-07 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"101000","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":"462077","transaction_code":"A","transaction_date":"2024-05-07 00:00:00","upload_date":"2024-05-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":null,"census_search_date":"2024-05-07 21:42:00","snet_input_date":"2024-05-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-07 21:42:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"330 SUMMERHAYS STREET","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:15:28.000000Z","updated_at":"2025-03-17T20:15:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9158315,"change_date":"2024-05-07 21:42:00","inspection_id":"81541530","insp_unit_id":"200761513","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"011","insp_unit_license":"VF4152","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYD49XXJJ183325","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:13.000000Z","updated_at":"2025-03-17T23:18:13.000000Z"},{"id":9158316,"change_date":"2024-05-07 21:42:00","inspection_id":"81541530","insp_unit_id":"200761514","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":"5171","insp_unit_license":"FW3283","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1JJV532D2HL946899","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:13.000000Z","updated_at":"2025-03-17T23:18:13.000000Z"}]},{"id":5581612,"change_date":"2024-04-25 21:42:00","inspection_id":"81427954","dot_number":"3201573","report_state":"MT","report_number":"U584300537","insp_date":"2024-04-18 00:00:00","insp_start_time":"1610","insp_end_time":"1640","registration_date":null,"region":"MD","ci_status_code":"C","location":"BILLEB","location_desc":"BILLINGS MT","county_code_state":"MT","county_code":"111","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SPECIALTY MINERALS","shipping_paper_number":"3623129","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":"2024-04-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"423270","transaction_code":"C","transaction_date":"2024-04-24 00:00:00","upload_date":"2024-04-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":null,"census_search_date":"2024-04-24 21:41:00","snet_input_date":"2024-04-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-04-24 21:41:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"330 SUMMERHAYS STREET","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:28.000000Z","updated_at":"2025-03-17T20:13:28.000000Z","inspection_violations":[{"id":8628538,"change_date":"2024-04-25 21:42:00","inspection_id":"81427954","insp_violation_id":"259137153","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"200572051","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:47:48.000000Z","updated_at":"2025-03-17T21:47:48.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":8990925,"change_date":"2024-04-25 21:42:00","inspection_id":"81427954","insp_unit_id":"200572051","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"77","insp_unit_license":"FR8598","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYD49X3JJ183327","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:40.000000Z","updated_at":"2025-03-17T23:16:40.000000Z"},{"id":8990926,"change_date":"2024-04-25 21:42:00","inspection_id":"81427954","insp_unit_id":"200572052","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"5140","insp_unit_license":"FS4299","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1JJV532DXEL789361","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:40.000000Z","updated_at":"2025-03-17T23:16:40.000000Z"}]},{"id":5495328,"change_date":"2024-04-12 21:39:00","inspection_id":"81333952","dot_number":"3201573","report_state":"SD","report_number":"5870000007","insp_date":"2024-04-11 00:00:00","insp_start_time":"1727","insp_end_time":"1750","registration_date":null,"region":"MD","ci_status_code":"C","location":"TILFRD","location_desc":"TILFORD SD","county_code_state":"SD","county_code":"093","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"STARBUCKS COFFEE CO.","shipping_paper_number":"9764659","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":"2024-04-12 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"391255","transaction_code":"A","transaction_date":"2024-04-11 00:00:00","upload_date":"2024-04-12 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":null,"census_search_date":"2024-04-12 21:39:00","snet_input_date":"2024-04-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-04-12 21:39:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"330 SUMMERHAYS STREET","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:11:34.000000Z","updated_at":"2025-03-17T20:11:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8851790,"change_date":"2024-04-12 21:39:00","inspection_id":"81333952","insp_unit_id":"200364362","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"9","insp_unit_license":"FR6327","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"4V4NC9EJ8LN235924","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:21.000000Z","updated_at":"2025-03-17T23:15:21.000000Z"},{"id":8851791,"change_date":"2024-04-12 21:39:00","inspection_id":"81333952","insp_unit_id":"200364363","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNKNOWN","insp_unit_company":"5222","insp_unit_license":"FW8254","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1JJV532D6NL325905","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:21.000000Z","updated_at":"2025-03-17T23:15:21.000000Z"}]},{"id":5495597,"change_date":"2024-04-12 21:39:00","inspection_id":"81334243","dot_number":"3201573","report_state":"MN","report_number":"0548000025","insp_date":"2024-04-06 00:00:00","insp_start_time":"1544","insp_end_time":"1630","registration_date":null,"region":"CD","ci_status_code":"C","location":"WTHTN","location_desc":"WORTHINGTON MN","county_code_state":"MN","county_code":"105","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"BRENNTAG","shipping_paper_number":"470393569","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-04-12 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"3","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":"391480","transaction_code":"A","transaction_date":"2024-04-12 00:00:00","upload_date":"2024-04-12 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":null,"census_search_date":"2024-04-12 21:39:00","snet_input_date":"2024-04-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-04-12 21:39:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"330 SUMMERHAYS STREET","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:11:34.000000Z","updated_at":"2025-03-17T20:11:34.000000Z","inspection_violations":[{"id":8488346,"change_date":"2024-04-12 21:39:00","inspection_id":"81334243","insp_violation_id":"258893870","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200364905","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"NONE","created_at":"2025-03-17T21:47:08.000000Z","updated_at":"2025-03-17T21:47:08.000000Z","normalized_code":"3939A"},{"id":8488347,"change_date":"2024-04-12 21:39:00","inspection_id":"81334243","insp_violation_id":"258893871","seq_no":"2","part_no":"393","part_no_section":"55(c)(1)","insp_viol_unit":"1","insp_unit_id":"200364905","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"NONE","created_at":"2025-03-17T21:47:08.000000Z","updated_at":"2025-03-17T21:47:08.000000Z","normalized_code":"39355C1"},{"id":8488348,"change_date":"2024-04-12 21:39:00","inspection_id":"81334243","insp_violation_id":"258893872","seq_no":"3","part_no":"395","part_no_section":"8(e)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"NONE","created_at":"2025-03-17T21:47:08.000000Z","updated_at":"2025-03-17T21:47:08.000000Z","normalized_code":"3958E1"}],"inspection_per_units":[{"id":8852267,"change_date":"2024-04-12 21:39:00","inspection_id":"81334243","insp_unit_id":"200364905","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"51","insp_unit_license":"FS4829","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYD49X5FJ430998","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:21.000000Z","updated_at":"2025-03-17T23:15:21.000000Z"},{"id":8852268,"change_date":"2024-04-12 21:39:00","inspection_id":"81334243","insp_unit_id":"200364906","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"5178","insp_unit_license":"FW2657","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1JJV532D5HL971747","insp_unit_decal":"Y","insp_unit_decal_number":"34042461","created_at":"2025-03-17T23:15:21.000000Z","updated_at":"2025-03-17T23:15:21.000000Z"}]},{"id":5406970,"change_date":"2024-04-01 21:39:00","inspection_id":"81237121","dot_number":"3201573","report_state":"SD","report_number":"5780000107","insp_date":"2024-03-29 00:00:00","insp_start_time":"1129","insp_end_time":"1151","registration_date":null,"region":"MD","ci_status_code":"C","location":"TILFRD","location_desc":"TILFORD SD","county_code_state":"SD","county_code":"093","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"BLUELINX CORPORATION","shipping_paper_number":"862862","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":"2024-04-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"361461","transaction_code":"A","transaction_date":"2024-04-01 00:00:00","upload_date":"2024-04-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":null,"census_search_date":"2024-04-01 21:39:00","snet_input_date":"2024-03-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-04-01 21:39:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"330 SUMMERHAYS STREET","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:09:51.000000Z","updated_at":"2025-03-17T20:09:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8708522,"change_date":"2024-04-01 21:39:00","inspection_id":"81237121","insp_unit_id":"200172230","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"1","insp_unit_license":"FR0347","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYD49X7FJ424121","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:59.000000Z","updated_at":"2025-03-17T23:13:59.000000Z"},{"id":8708523,"change_date":"2024-04-01 21:39:00","inspection_id":"81237121","insp_unit_id":"200172231","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"5161","insp_unit_license":"FW3282","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1JJV532D7GL841435","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:59.000000Z","updated_at":"2025-03-17T23:13:59.000000Z"}]},{"id":5232845,"change_date":"2024-03-07 21:38:00","inspection_id":"81047493","dot_number":"3201573","report_state":"NM","report_number":"3884O1UDKR","insp_date":"2024-03-06 00:00:00","insp_start_time":"1100","insp_end_time":"1145","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"ON US HWY 54 157 FT S OF NM HW","county_code_state":"NM","county_code":"037","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"RYANOR GARAGE DOOR","shipping_paper_number":"100447","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-03-07 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"2078241","transaction_code":"A","transaction_date":"2024-03-06 00:00:00","upload_date":"2024-03-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":null,"census_search_date":"2024-03-07 21:38:00","snet_input_date":"2024-03-07 00:00:00","source_office":"2NMS001","mcmis_add_date":"2024-03-07 21:38:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"PO BOX 222","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:06:14.000000Z","updated_at":"2025-03-17T20:06:14.000000Z","inspection_violations":[{"id":8068485,"change_date":"2024-03-07 21:38:00","inspection_id":"81047493","insp_violation_id":"258258704","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"9665142","created_at":"2025-03-17T21:45:00.000000Z","updated_at":"2025-03-17T21:45:00.000000Z","normalized_code":"3922"},{"id":8068486,"change_date":"2024-03-07 21:38:00","inspection_id":"81047493","insp_violation_id":"258258705","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"199800676","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:00.000000Z","updated_at":"2025-03-17T21:45:00.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":8426003,"change_date":"2024-03-07 21:38:00","inspection_id":"81047493","insp_unit_id":"199800676","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"TRK 7","insp_unit_license":"FP6049","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYD49XXKJ244559","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:21.000000Z","updated_at":"2025-03-17T23:11:21.000000Z"},{"id":8426004,"change_date":"2024-03-07 21:38:00","inspection_id":"81047493","insp_unit_id":"199800677","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"TRL 5232","insp_unit_license":"FT8803","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1JJV532D8PL372131","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:21.000000Z","updated_at":"2025-03-17T23:11:21.000000Z"}]},{"id":5113585,"change_date":"2024-02-22 21:42:00","inspection_id":"80917394","dot_number":"3201573","report_state":"IL","report_number":"4178780009","insp_date":"2024-02-20 00:00:00","insp_start_time":"1342","insp_end_time":"1345","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I-80","county_code_state":"IL","county_code":"063","insp_level_id":"3","service_center":"MW","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"53200","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":"2307940","transaction_code":"A","transaction_date":"2024-02-20 00:00:00","upload_date":"2024-02-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-02-20 00:00:00","source_office":"3ILS001","mcmis_add_date":"2024-02-22 21:42:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"330 SUMMERHAYS STREET","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"176815","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:03:50.000000Z","updated_at":"2025-03-17T20:03:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8232620,"change_date":"2024-02-22 21:42:00","inspection_id":"80917394","insp_unit_id":"199552377","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"6","insp_unit_license":"FA4020","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYD49X0HJ145550","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:37.000000Z","updated_at":"2025-03-17T23:09:37.000000Z"}]},{"id":5066833,"change_date":"2024-02-16 21:41:00","inspection_id":"80866383","dot_number":"3201573","report_state":"CO","report_number":"1133770003","insp_date":"2024-02-07 00:00:00","insp_start_time":"1556","insp_end_time":"1715","registration_date":null,"region":"MS","ci_status_code":"C","location":null,"location_desc":"GENOA CO","county_code_state":"CO","county_code":"073","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"GOLDEN DC","shipping_paper_number":"503102707","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":"2024-02-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","viol_total":"2","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":"243881","transaction_code":"A","transaction_date":"2024-02-15 00:00:00","upload_date":"2024-02-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":null,"census_search_date":"2024-02-16 21:41:00","snet_input_date":"2024-02-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-02-16 21:41:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"330 SUMMERHAYS STREET","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:03:04.000000Z","updated_at":"2025-03-17T20:03:04.000000Z","inspection_violations":[{"id":7809724,"change_date":"2024-02-16 21:41:00","inspection_id":"80866383","insp_violation_id":"257874407","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"6477055","created_at":"2025-03-17T21:43:46.000000Z","updated_at":"2025-03-17T21:43:46.000000Z","normalized_code":"3922"},{"id":7809725,"change_date":"2024-02-16 21:41:00","inspection_id":"80866383","insp_violation_id":"257874408","seq_no":"2","part_no":"395","part_no_section":"24","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:46.000000Z","updated_at":"2025-03-17T21:43:46.000000Z","normalized_code":"39524"}],"inspection_per_units":[{"id":8156379,"change_date":"2024-02-16 21:41:00","inspection_id":"80866383","insp_unit_id":"199455543","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"23","insp_unit_license":"24T026814","insp_unit_license_state":"NM","insp_unit_vehicle_id_number":"4V4NC9EH3RN662000","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:57.000000Z","updated_at":"2025-03-17T23:08:57.000000Z"},{"id":8156380,"change_date":"2024-02-16 21:41:00","inspection_id":"80866383","insp_unit_id":"199455544","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CIMC VEHIC","insp_unit_company":"5234","insp_unit_license":"FS7032","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5V8VA532XPM305759","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:57.000000Z","updated_at":"2025-03-17T23:08:57.000000Z"}]},{"id":4954017,"change_date":"2024-02-01 21:43:00","inspection_id":"80743000","dot_number":"3201573","report_state":"NM","report_number":"8096O0UPNP","insp_date":"2024-01-30 00:00:00","insp_start_time":"1945","insp_end_time":"1959","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"GALLUP PORT OF ENTRY","county_code_state":"NM","county_code":"031","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"GOODYEAR PLANT","shipping_paper_number":"400033069","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":"2024-02-01 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","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":"2069736","transaction_code":"A","transaction_date":"2024-01-31 00:00:00","upload_date":"2024-02-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":null,"census_search_date":"2024-02-01 21:43:00","snet_input_date":"2024-02-01 00:00:00","source_office":"2NMS001","mcmis_add_date":"2024-02-01 21:43:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"PO BOX 222","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:00:51.000000Z","updated_at":"2025-03-17T20:00:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7972780,"change_date":"2024-02-01 21:43:00","inspection_id":"80743000","insp_unit_id":"199219514","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"UNIT 9","insp_unit_license":"FR6327","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"4V4NC9EJ8LN235924","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:16.000000Z","updated_at":"2025-03-17T23:07:16.000000Z"},{"id":7972781,"change_date":"2024-02-01 21:43:00","inspection_id":"80743000","insp_unit_id":"199219515","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"UNIT 5145","insp_unit_license":"FS4300","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1JJV532D9EL789366","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:16.000000Z","updated_at":"2025-03-17T23:07:16.000000Z"}]},{"id":4927096,"change_date":"2024-01-30 21:40:00","inspection_id":"80713328","dot_number":"3201573","report_state":"MT","report_number":"HP20580007","insp_date":"2024-01-24 00:00:00","insp_start_time":"1134","insp_end_time":"1246","registration_date":null,"region":"MS","ci_status_code":"C","location":null,"location_desc":"GOLDCREEK MT","county_code_state":"MT","county_code":"077","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"0","shipping_paper_number":"0","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":"2024-01-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","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":"203587","transaction_code":"A","transaction_date":"2024-01-30 00:00:00","upload_date":"2024-01-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":null,"census_search_date":"2024-01-30 21:40:00","snet_input_date":"2024-01-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-01-30 21:40:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"330 SUMMERHAYS STREET","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:00:27.000000Z","updated_at":"2025-03-17T20:00:27.000000Z","inspection_violations":[{"id":7589114,"change_date":"2024-01-30 21:40:00","inspection_id":"80713328","insp_violation_id":"257550401","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"510 B250109","created_at":"2025-03-17T21:42:38.000000Z","updated_at":"2025-03-17T21:42:38.000000Z","normalized_code":"3922"},{"id":7589115,"change_date":"2024-01-30 21:40:00","inspection_id":"80713328","insp_violation_id":"257550402","seq_no":"2","part_no":"395","part_no_section":"8E1PC-OOS","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:38.000000Z","updated_at":"2025-03-17T21:42:38.000000Z","normalized_code":"3958E1PCOOS"}],"inspection_per_units":[{"id":7929037,"change_date":"2024-01-30 21:40:00","inspection_id":"80713328","insp_unit_id":"199162220","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"77","insp_unit_license":"FR8598","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYD49X3JJ183327","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:52.000000Z","updated_at":"2025-03-17T23:06:52.000000Z"},{"id":7929038,"change_date":"2024-01-30 21:40:00","inspection_id":"80713328","insp_unit_id":"199162221","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"5178","insp_unit_license":"FW2657","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1JJV532D5HL971747","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:52.000000Z","updated_at":"2025-03-17T23:06:52.000000Z"}]},{"id":4847114,"change_date":"2024-01-17 21:44:00","inspection_id":"80625991","dot_number":"3201573","report_state":"MT","report_number":"U743500262","insp_date":"2024-01-16 00:00:00","insp_start_time":"1710","insp_end_time":"1735","registration_date":null,"region":"MS","ci_status_code":"C","location":"CLRWTR","location_desc":"CLEARWATER MT","county_code_state":"MT","county_code":"063","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","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":"2024-01-17 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"181014","transaction_code":"A","transaction_date":"2024-01-17 00:00:00","upload_date":"2024-01-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":null,"census_search_date":"2024-01-17 21:44:00","snet_input_date":"2024-01-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-01-17 21:44:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"330 SUMMERHAYS STREET","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:58:49.000000Z","updated_at":"2025-03-17T19:58:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7798720,"change_date":"2024-01-17 21:44:00","inspection_id":"80625991","insp_unit_id":"198989990","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"9","insp_unit_license":"FR6327","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"4V4NC9EJ8LN235924","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:42.000000Z","updated_at":"2025-03-17T23:05:42.000000Z"},{"id":7798721,"change_date":"2024-01-17 21:44:00","inspection_id":"80625991","insp_unit_id":"198989991","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VAN GUARD","insp_unit_company":"5233","insp_unit_license":"FT0323","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5V8VA5328PM305758","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:42.000000Z","updated_at":"2025-03-17T23:05:42.000000Z"}]},{"id":4047795,"change_date":"2023-09-26 21:43:00","inspection_id":"79745921","dot_number":"3201573","report_state":"SD","report_number":"HP08500010","insp_date":"2023-09-23 00:00:00","insp_start_time":"0919","insp_end_time":"0931","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"SD","county_code":"019","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"INLAND 465","shipping_paper_number":"1470377","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":"I","final_status_date":"2023-09-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"114000","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":"652419","transaction_code":"C","transaction_date":"2023-09-26 00:00:00","upload_date":"2023-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-09-25 00:00:00","source_office":"4SDS001","mcmis_add_date":"2023-09-25 21:41:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"330 SUMMERHAYS STREET","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"176815","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:42:48.000000Z","updated_at":"2025-03-17T19:42:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6508558,"change_date":"2023-09-26 21:43:00","inspection_id":"79745921","insp_unit_id":"197255097","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"51","insp_unit_license":"FS4829","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYD49X5FJ430998","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:37.000000Z","updated_at":"2025-03-17T22:54:37.000000Z"},{"id":6508559,"change_date":"2023-09-26 21:43:00","inspection_id":"79745921","insp_unit_id":"197255098","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"5232","insp_unit_license":"FT8803","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1JJV532D8PL372131","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:37.000000Z","updated_at":"2025-03-17T22:54:37.000000Z"}]},{"id":4046402,"change_date":"2023-09-25 21:41:00","inspection_id":"79744371","dot_number":"3201573","report_state":"NE","report_number":"T137000516","insp_date":"2023-09-19 00:00:00","insp_start_time":"1009","insp_end_time":"1028","registration_date":null,"region":"CT","ci_status_code":"C","location":"12","location_desc":"WAVERLY WEST BOUND","county_code_state":"NE","county_code":"025","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"RAYNOR GARAGE DOOR","shipping_paper_number":"98628","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":"2023-09-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"770784","transaction_code":"A","transaction_date":"2023-09-19 00:00:00","upload_date":"2023-09-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":null,"census_search_date":"2023-09-25 21:41:00","snet_input_date":"2023-09-20 00:00:00","source_office":"3NES001","mcmis_add_date":"2023-09-25 21:41:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"PO BOX 222","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:42:47.000000Z","updated_at":"2025-03-17T19:42:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6506073,"change_date":"2023-09-25 21:41:00","inspection_id":"79744371","insp_unit_id":"197217884","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"4","insp_unit_license":"FP6050","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYD49X3GJ482762","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:36.000000Z","updated_at":"2025-03-17T22:54:36.000000Z"},{"id":6506074,"change_date":"2023-09-25 21:41:00","inspection_id":"79744371","insp_unit_id":"197217885","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"636094","insp_unit_license":"935006ST","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"1JJV532D0RL435094","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:36.000000Z","updated_at":"2025-03-17T22:54:36.000000Z"}]},{"id":3992243,"change_date":"2023-09-18 21:38:00","inspection_id":"79684227","dot_number":"3201573","report_state":"MN","report_number":"0AER000896","insp_date":"2023-09-15 00:00:00","insp_start_time":"0916","insp_end_time":"0940","registration_date":null,"region":"CT","ci_status_code":"C","location":"WTHTN","location_desc":"WORTHINGTON SCALE","county_code_state":"MN","county_code":"105","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"RAYNOR","shipping_paper_number":"98505","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-09-18 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","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":"1410116","transaction_code":"A","transaction_date":"2023-09-15 00:00:00","upload_date":"2023-09-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-09-18 00:00:00","source_office":"3MNS001","mcmis_add_date":"2023-09-18 21:38:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"PO BOX 222","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"176815","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:41:39.000000Z","updated_at":"2025-03-17T19:41:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6419374,"change_date":"2023-09-18 21:38:00","inspection_id":"79684227","insp_unit_id":"197099070","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"4","insp_unit_license":"FP6050","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYD49X3GJ482762","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:53.000000Z","updated_at":"2025-03-17T22:53:53.000000Z"},{"id":6419375,"change_date":"2023-09-18 21:38:00","inspection_id":"79684227","insp_unit_id":"197099071","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"1420","insp_unit_license":"466664ST","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"1JJV532D4DL775129","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:53.000000Z","updated_at":"2025-03-17T22:53:53.000000Z"}]},{"id":3724639,"change_date":"2023-08-11 21:39:00","inspection_id":"79385891","dot_number":"3201573","report_state":"WA","report_number":"W420006127","insp_date":"2023-08-10 00:00:00","insp_start_time":"1237","insp_end_time":"1307","registration_date":null,"region":"PT","ci_status_code":"C","location":"SC64","location_desc":"LIBERTY LAKE (SPOKANE POE)","county_code_state":"WA","county_code":"063","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"P\/U IN SPOKANE","shipping_paper_number":"NONE","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-08-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"2586194","transaction_code":"A","transaction_date":"2023-08-10 00:00:00","upload_date":"2023-08-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-08-11 00:00:00","source_office":"4WAS001","mcmis_add_date":"2023-08-11 21:39:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"PO BOX 222","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"176815","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:28.000000Z","updated_at":"2025-03-17T19:36:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5989070,"change_date":"2023-08-11 21:39:00","inspection_id":"79385891","insp_unit_id":"196491228","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"77","insp_unit_license":"FR8598","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYD49X3JJ183327","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:19.000000Z","updated_at":"2025-03-17T22:50:19.000000Z"},{"id":5989071,"change_date":"2023-08-11 21:39:00","inspection_id":"79385891","insp_unit_id":"196491229","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"5127","insp_unit_license":"FW2657","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1JJV532D5HL971747","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:19.000000Z","updated_at":"2025-03-17T22:50:19.000000Z"}]},{"id":3572025,"change_date":"2023-07-24 21:41:00","inspection_id":"79214952","dot_number":"3201573","report_state":"SD","report_number":"0680000129","insp_date":"2023-07-24 00:00:00","insp_start_time":"0941","insp_end_time":"1001","registration_date":null,"region":"MD","ci_status_code":"C","location":null,"location_desc":"HOT SPRINGSSD","county_code_state":"SD","county_code":"047","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"OVERHEAD DOOR COMPANY","shipping_paper_number":"5232","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":"2023-07-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","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":"33851","transaction_code":"A","transaction_date":"2023-07-24 00:00:00","upload_date":"2023-07-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":null,"census_search_date":"2023-07-24 21:41:00","snet_input_date":"2023-07-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-07-24 21:41:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"330 SUMMERHAYS STREET","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:33:33.000000Z","updated_at":"2025-03-17T19:33:33.000000Z","inspection_violations":[{"id":5508184,"change_date":"2023-07-24 21:41:00","inspection_id":"79214952","insp_violation_id":"254219449","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"196141559","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARN","created_at":"2025-03-17T21:32:33.000000Z","updated_at":"2025-03-17T21:32:33.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":5743511,"change_date":"2023-07-24 21:41:00","inspection_id":"79214952","insp_unit_id":"196141558","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":null,"insp_unit_license":"FW0090","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"4V4NC9EH6RN630075","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:19.000000Z","updated_at":"2025-03-17T22:48:19.000000Z"},{"id":5743512,"change_date":"2023-07-24 21:41:00","inspection_id":"79214952","insp_unit_id":"196141559","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":null,"insp_unit_license":"FT8803","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1JJV532D8PL372131","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:19.000000Z","updated_at":"2025-03-17T22:48:19.000000Z"}]},{"id":3536889,"change_date":"2023-07-18 21:43:00","inspection_id":"79175517","dot_number":"3201573","report_state":"WY","report_number":"TBJD000203","insp_date":"2023-07-17 00:00:00","insp_start_time":"1725","insp_end_time":"1754","registration_date":null,"region":"MT","ci_status_code":"C","location":"ML29","location_desc":"POWELL ROADSIDE","county_code_state":"WY","county_code":"029","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"071723","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":"2023-07-18 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"433944","transaction_code":"A","transaction_date":"2023-07-18 00:00:00","upload_date":"2023-07-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-07-17 00:00:00","source_office":"4WYS001","mcmis_add_date":"2023-07-18 21:43:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"330 SUMMERHAYS STREET","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"176815","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:50.000000Z","updated_at":"2025-03-17T19:32:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5687217,"change_date":"2023-07-18 21:43:00","inspection_id":"79175517","insp_unit_id":"196063895","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"FP6049","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYD49X3GJ482759","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:53.000000Z","updated_at":"2025-03-17T22:47:53.000000Z"},{"id":5687218,"change_date":"2023-07-18 21:43:00","inspection_id":"79175517","insp_unit_id":"196063896","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VANR","insp_unit_company":"5234","insp_unit_license":"FS7032","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5V8VA532XPM305759","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:53.000000Z","updated_at":"2025-03-17T22:47:53.000000Z"}]},{"id":3486154,"change_date":"2023-07-12 21:40:00","inspection_id":"79118742","dot_number":"3201573","report_state":"KY","report_number":"CV44662644","insp_date":"2023-07-11 00:00:00","insp_start_time":"1545","insp_end_time":"1615","registration_date":null,"region":"ET","ci_status_code":"C","location":"9811","location_desc":"LONDON","county_code_state":"KY","county_code":"125","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"BODY ARMOR","shipping_paper_number":"0000032188","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":"2023-07-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"2174295","transaction_code":"A","transaction_date":"2023-07-12 00:00:00","upload_date":"2023-07-12 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-07-12 00:00:00","source_office":"2KYS001","mcmis_add_date":"2023-07-12 21:40:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"330 SUMMERHAYS STREET","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"176815","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:03.000000Z","updated_at":"2025-03-17T19:32:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5605694,"change_date":"2023-07-12 21:40:00","inspection_id":"79118742","insp_unit_id":"195950967","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"011","insp_unit_license":"VF4152","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYD49XXJJ183325","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:15.000000Z","updated_at":"2025-03-17T22:47:15.000000Z"},{"id":5605695,"change_date":"2023-07-12 21:40:00","inspection_id":"79118742","insp_unit_id":"195950968","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"5221","insp_unit_license":"HV3172","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1JJV532D4NL325904","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:15.000000Z","updated_at":"2025-03-17T22:47:15.000000Z"}]},{"id":3303552,"change_date":"2023-06-16 21:40:00","inspection_id":"78913432","dot_number":"3201573","report_state":"OK","report_number":"PE16200170","insp_date":"2023-06-16 00:00:00","insp_start_time":"0856","insp_end_time":"0948","registration_date":null,"region":"CT","ci_status_code":"C","location":"36035","location_desc":"BRAMAN SCALES","county_code_state":"OK","county_code":"071","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"WASTE MANAGEMENT","shipping_paper_number":"06142306","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":"2023-06-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"713580","transaction_code":"A","transaction_date":"2023-06-16 00:00:00","upload_date":"2023-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-06-16 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-06-16 21:40:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"330 SUMMERHAYS STREET","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"176815","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:28:30.000000Z","updated_at":"2025-03-17T19:28:30.000000Z","inspection_violations":[{"id":5094474,"change_date":"2023-06-16 21:40:00","inspection_id":"78913432","insp_violation_id":"253551295","seq_no":"1","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"195539306","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:39.000000Z","updated_at":"2025-03-17T21:30:39.000000Z","normalized_code":"39355E"}],"inspection_per_units":[{"id":5311028,"change_date":"2023-06-16 21:40:00","inspection_id":"78913432","insp_unit_id":"195539305","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"20","insp_unit_license":"FW0090","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"4V4NC9EH6RN630075","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:54.000000Z","updated_at":"2025-03-17T22:44:54.000000Z"},{"id":5311029,"change_date":"2023-06-16 21:40:00","inspection_id":"78913432","insp_unit_id":"195539306","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"5171","insp_unit_license":"DC6607","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1JJV532D2HL946899","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:54.000000Z","updated_at":"2025-03-17T22:44:54.000000Z"}]},{"id":3013390,"change_date":"2023-05-10 21:42:00","inspection_id":"78585726","dot_number":"3201573","report_state":"IN","report_number":"7703003013","insp_date":"2023-05-09 00:00:00","insp_start_time":"1522","insp_end_time":"1550","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-64 WB NR 72 MM","county_code_state":"IN","county_code":"123","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"PEPSI","shipping_paper_number":"33870424","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":"I","final_status_date":"2023-05-10 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2188824","transaction_code":"A","transaction_date":"2023-05-10 00:00:00","upload_date":"2023-05-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-05-10 00:00:00","source_office":"3INS001","mcmis_add_date":"2023-05-10 21:42:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"330 SUMMERHAYS STREET","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"176815","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:22:39.000000Z","updated_at":"2025-03-17T19:22:39.000000Z","inspection_violations":[{"id":4628144,"change_date":"2023-05-10 21:42:00","inspection_id":"78585726","insp_violation_id":"252748082","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:34.000000Z","updated_at":"2025-03-17T21:28:34.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4848214,"change_date":"2023-05-10 21:42:00","inspection_id":"78585726","insp_unit_id":"194858085","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"77","insp_unit_license":"FR8598","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYD49X3JJ183327","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:12.000000Z","updated_at":"2025-03-17T22:41:12.000000Z"},{"id":4848215,"change_date":"2023-05-10 21:42:00","inspection_id":"78585726","insp_unit_id":"194858086","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"5171","insp_unit_license":"DC6607","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1JJV532D2HL946899","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:12.000000Z","updated_at":"2025-03-17T22:41:12.000000Z"}]},{"id":2934039,"change_date":"2023-05-01 21:40:00","inspection_id":"78496167","dot_number":"3201573","report_state":"CO","report_number":"5492002601","insp_date":"2023-05-01 00:00:00","insp_start_time":"1348","insp_end_time":"1405","registration_date":null,"region":"MT","ci_status_code":"C","location":"I70","location_desc":"I70 MP119","county_code_state":"CO","county_code":"075","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"CENTRAL ORIENTA","shipping_paper_number":"386982400568667","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":"I","final_status_date":"2023-05-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"1241631","transaction_code":"A","transaction_date":"2023-05-01 00:00:00","upload_date":"2023-05-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-05-01 00:00:00","source_office":"4COS001","mcmis_add_date":"2023-05-01 21:40:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"PO BOX 222","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"176815","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:20:56.000000Z","updated_at":"2025-03-17T19:20:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4720972,"change_date":"2023-05-01 21:40:00","inspection_id":"78496167","insp_unit_id":"194681687","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"51","insp_unit_license":"FS4829","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYD49X5FJ430998","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:14.000000Z","updated_at":"2025-03-17T22:40:14.000000Z"},{"id":4720973,"change_date":"2023-05-01 21:40:00","inspection_id":"78496167","insp_unit_id":"194681688","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"5221","insp_unit_license":"HV3172","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1JJV532D4NL325904","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:14.000000Z","updated_at":"2025-03-17T22:40:14.000000Z"}]},{"id":2897983,"change_date":"2023-04-26 21:41:00","inspection_id":"78455371","dot_number":"3201573","report_state":"NM","report_number":"4609N36PP4","insp_date":"2023-04-24 00:00:00","insp_start_time":"1900","insp_end_time":"2000","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"OROGRANDE PORT OF ENTRY","county_code_state":"NM","county_code":"035","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"RAYNOR GARAGE DOORS","shipping_paper_number":"96405","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":"2023-04-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1998332","transaction_code":"A","transaction_date":"2023-04-25 00:00:00","upload_date":"2023-04-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":null,"census_search_date":"2023-04-26 21:41:00","snet_input_date":"2023-04-26 00:00:00","source_office":"2NMS001","mcmis_add_date":"2023-04-26 21:41:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"PO BOX 222","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:20:07.000000Z","updated_at":"2025-03-17T19:20:07.000000Z","inspection_violations":[{"id":4447570,"change_date":"2023-04-26 21:41:00","inspection_id":"78455371","insp_violation_id":"252455931","seq_no":"1","part_no":"393","part_no_section":"209(b)","insp_viol_unit":"1","insp_unit_id":"194598627","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:44.000000Z","updated_at":"2025-03-17T21:27:44.000000Z","normalized_code":"393209B"},{"id":4447571,"change_date":"2023-04-26 21:41:00","inspection_id":"78455371","insp_violation_id":"252455932","seq_no":"2","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"194598627","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:44.000000Z","updated_at":"2025-03-17T21:27:44.000000Z","normalized_code":"3965B"},{"id":4447572,"change_date":"2023-04-26 21:41:00","inspection_id":"78455371","insp_violation_id":"252455933","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"194598627","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:44.000000Z","updated_at":"2025-03-17T21:27:44.000000Z","normalized_code":"3963A1"},{"id":4447573,"change_date":"2023-04-26 21:41:00","inspection_id":"78455371","insp_violation_id":"252455934","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"194598627","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:44.000000Z","updated_at":"2025-03-17T21:27:44.000000Z","normalized_code":"3963A1"},{"id":4447574,"change_date":"2023-04-26 21:41:00","inspection_id":"78455371","insp_violation_id":"252455935","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"194598627","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:27:44.000000Z","updated_at":"2025-03-17T21:27:44.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":4662115,"change_date":"2023-04-26 21:41:00","inspection_id":"78455371","insp_unit_id":"194598627","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"UNIT 10","insp_unit_license":"FS0251","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYDP9X7GJ492017","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:46.000000Z","updated_at":"2025-03-17T22:39:46.000000Z"},{"id":4662116,"change_date":"2023-04-26 21:41:00","inspection_id":"78455371","insp_unit_id":"194598628","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"UNIT5161","insp_unit_license":"CM4720","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1JJV532D7GL841435","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:46.000000Z","updated_at":"2025-03-17T22:39:46.000000Z"}]},{"id":2788771,"change_date":"2023-04-12 21:41:00","inspection_id":"78331553","dot_number":"3201573","report_state":"MT","report_number":"J655001826","insp_date":"2023-04-11 00:00:00","insp_start_time":"1609","insp_end_time":"1635","registration_date":"2023-04-12 00:00:00","region":"MT","ci_status_code":"C","location":"655","location_desc":"BUTTE SCALE","county_code_state":"MT","county_code":"093","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"RAYNOR GARAGE DOORS","shipping_paper_number":"96242","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":"I","final_status_date":"2023-04-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"991262","transaction_code":"A","transaction_date":"2023-04-11 00:00:00","upload_date":"2023-04-12 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-04-12 00:00:00","source_office":"4MTS001","mcmis_add_date":"2023-04-12 21:41:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"PO BOX 222","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"176815","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:18:04.000000Z","updated_at":"2025-03-17T19:18:04.000000Z","inspection_violations":[{"id":4278850,"change_date":"2023-04-12 21:41:00","inspection_id":"78331553","insp_violation_id":"252180160","seq_no":"1","part_no":"395","part_no_section":"8(e)(1)","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":"2025-03-17T21:26:58.000000Z","updated_at":"2025-03-17T21:26:58.000000Z","normalized_code":"3958E1"},{"id":4278851,"change_date":"2023-04-12 21:41:00","inspection_id":"78331553","insp_violation_id":"252180161","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"194350561","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:58.000000Z","updated_at":"2025-03-17T21:26:58.000000Z","normalized_code":"39395A"},{"id":4278852,"change_date":"2023-04-12 21:41:00","inspection_id":"78331553","insp_violation_id":"252180162","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194350561","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:58.000000Z","updated_at":"2025-03-17T21:26:58.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":4488715,"change_date":"2023-04-12 21:41:00","inspection_id":"78331553","insp_unit_id":"194350561","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"FS0251","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYDP9X7GJ492017","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:23.000000Z","updated_at":"2025-03-17T22:38:23.000000Z"},{"id":4488716,"change_date":"2023-04-12 21:41:00","inspection_id":"78331553","insp_unit_id":"194350562","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"HV3172","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1JJV532D4NL325904","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:23.000000Z","updated_at":"2025-03-17T22:38:23.000000Z"}]},{"id":2717534,"change_date":"2023-04-11 12:04:00","inspection_id":"78251055","dot_number":"3201573","report_state":"NE","report_number":"ZV00001537","insp_date":"2023-03-31 00:00:00","insp_start_time":"0940","insp_end_time":"0954","registration_date":null,"region":"CT","ci_status_code":"C","location":"FREMNT","location_desc":"FREMONT SCALE","county_code_state":"NE","county_code":"053","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"INTERNATIONAL PAPER","shipping_paper_number":"2013826490","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":"I","final_status_date":"2023-04-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"115000","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":"756926","transaction_code":"C","transaction_date":"2023-04-07 00:00:00","upload_date":"2023-04-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-04-03 00:00:00","source_office":"3NES001","mcmis_add_date":"2023-04-03 21:40:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"PO BOX 222","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"176815","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:16:38.000000Z","updated_at":"2025-03-17T19:16:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4373799,"change_date":"2023-04-11 12:04:00","inspection_id":"78251055","insp_unit_id":"194307006","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"535105","insp_unit_license":"711724ST","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"1GR1A0624LT155105","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:26.000000Z","updated_at":"2025-03-17T22:37:26.000000Z"},{"id":4373800,"change_date":"2023-04-11 12:04:00","inspection_id":"78251055","insp_unit_id":"194307007","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"4","insp_unit_license":"FP6050","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYD49X3GJ482762","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:26.000000Z","updated_at":"2025-03-17T22:37:26.000000Z"}]},{"id":2380045,"change_date":"2023-02-15 21:38:00","inspection_id":"77866320","dot_number":"3201573","report_state":"IA","report_number":"000TT6ZVK1","insp_date":"2023-02-14 00:00:00","insp_start_time":"0720","insp_end_time":"0735","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 218 NB FROM FLOYD","county_code_state":"IA","county_code":"067","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"INTERNATIONAL PAPER","shipping_paper_number":"5159","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":"2023-02-15 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"1262708","transaction_code":"A","transaction_date":"2023-02-15 00:00:00","upload_date":"2023-02-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-02-14 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-02-15 21:38:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"330 SUMMERHAYS STREET","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"176815","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:10:40.000000Z","updated_at":"2025-03-17T19:10:40.000000Z","inspection_violations":[{"id":3664447,"change_date":"2023-02-15 21:38:00","inspection_id":"77866320","insp_violation_id":"251154782","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:17.000000Z","updated_at":"2025-03-17T21:24:17.000000Z","normalized_code":"3922"},{"id":3664448,"change_date":"2023-02-15 21:38:00","inspection_id":"77866320","insp_violation_id":"251154783","seq_no":"2","part_no":"395","part_no_section":"24(d)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:17.000000Z","updated_at":"2025-03-17T21:24:17.000000Z","normalized_code":"39524D"}],"inspection_per_units":[{"id":3829840,"change_date":"2023-02-15 21:38:00","inspection_id":"77866320","insp_unit_id":"193417062","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"11","insp_unit_license":"VF4152","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYD49XXJJ183325","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:25.000000Z","updated_at":"2025-03-17T22:33:25.000000Z"},{"id":3829841,"change_date":"2023-02-15 21:38:00","inspection_id":"77866320","insp_unit_id":"193417063","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"232","insp_unit_license":"FT8803","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1JJV532D8PL372131","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:25.000000Z","updated_at":"2025-03-17T22:33:25.000000Z"}]},{"id":2285587,"change_date":"2023-02-02 21:42:00","inspection_id":"77758491","dot_number":"3201573","report_state":"IA","report_number":"000TT76ZDL","insp_date":"2023-01-31 00:00:00","insp_start_time":"1120","insp_end_time":"1155","registration_date":null,"region":"CT","ci_status_code":"C","location":"02","location_desc":"02 - I80 EB MM 115 VAN METER","county_code_state":"IA","county_code":"049","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"BAYER PRODUCTION SUPPLY LLC","shipping_paper_number":"833169670","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":"2023-02-02 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"115000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1260730","transaction_code":"A","transaction_date":"2023-02-02 00:00:00","upload_date":"2023-02-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-01-31 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-02-02 21:42:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"330 SUMMERHAYS STREET","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"176815","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:51.000000Z","updated_at":"2025-03-17T19:08:51.000000Z","inspection_violations":[{"id":3524584,"change_date":"2023-02-02 21:42:00","inspection_id":"77758491","insp_violation_id":"250920788","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:39.000000Z","updated_at":"2025-03-17T21:23:39.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3678373,"change_date":"2023-02-02 21:42:00","inspection_id":"77758491","insp_unit_id":"193199929","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"8","insp_unit_license":"FJ5745","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKTD49XX5J089364","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:21.000000Z","updated_at":"2025-03-17T22:32:21.000000Z"},{"id":3678374,"change_date":"2023-02-02 21:42:00","inspection_id":"77758491","insp_unit_id":"193199930","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VANG","insp_unit_company":"5233","insp_unit_license":"FT0323","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5V8VA5328PM305758","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:21.000000Z","updated_at":"2025-03-17T22:32:21.000000Z"}]},{"id":2106915,"change_date":"2023-01-10 21:40:00","inspection_id":"77554235","dot_number":"3201573","report_state":"OH","report_number":"1621002129","insp_date":"2023-01-06 00:00:00","insp_start_time":"1155","insp_end_time":"1225","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"OH","county_code":"053","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"HUBBELL","shipping_paper_number":"827580250","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":"I","final_status_date":"2023-01-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","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":"1634069","transaction_code":"A","transaction_date":"2023-01-06 00:00:00","upload_date":"2023-01-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-01-10 00:00:00","source_office":"3OHS001","mcmis_add_date":"2023-01-10 21:40:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"PO BOX 222","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340-4711","insp_colonia":null,"docket_number":"176815","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:05:30.000000Z","updated_at":"2025-03-17T19:05:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3390604,"change_date":"2023-01-10 21:40:00","inspection_id":"77554235","insp_unit_id":"192788976","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"3","insp_unit_license":"FP6049","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYD49X3GJ482759","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:18.000000Z","updated_at":"2025-03-17T22:30:18.000000Z"},{"id":3390605,"change_date":"2023-01-10 21:40:00","inspection_id":"77554235","insp_unit_id":"192788977","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"5231","insp_unit_license":"IR7291","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1JJV532D6PL372130","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:18.000000Z","updated_at":"2025-03-17T22:30:18.000000Z"}]},{"id":2044882,"change_date":"2022-12-30 21:37:00","inspection_id":"77483114","dot_number":"3201573","report_state":"NE","report_number":"00XN004439","insp_date":"2022-12-30 00:00:00","insp_start_time":"1018","insp_end_time":"1051","registration_date":null,"region":"CT","ci_status_code":"C","location":"WEB","location_desc":"WAVERLY EAST BOUND","county_code_state":"NE","county_code":"025","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"KRAFT HEINZ FOOD COMPANY","shipping_paper_number":"2078865220","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":"I","final_status_date":"2022-12-30 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"750869","transaction_code":"A","transaction_date":"2022-12-30 00:00:00","upload_date":"2022-12-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-12-30 00:00:00","source_office":"3NES001","mcmis_add_date":"2022-12-30 21:37:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"PO BOX 222","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340-4711","insp_colonia":null,"docket_number":"176815","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:04:21.000000Z","updated_at":"2025-03-17T19:04:21.000000Z","inspection_violations":[{"id":3167380,"change_date":"2022-12-30 21:37:00","inspection_id":"77483114","insp_violation_id":"250332680","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"192648106","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"EB4002780","created_at":"2025-03-17T21:22:01.000000Z","updated_at":"2025-03-17T21:22:01.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":3289388,"change_date":"2022-12-30 21:37:00","inspection_id":"77483114","insp_unit_id":"192648106","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"77","insp_unit_license":"FR8598","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYD49X3JJ183327","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:32.000000Z","updated_at":"2025-03-17T22:29:32.000000Z"},{"id":3289389,"change_date":"2022-12-30 21:37:00","inspection_id":"77483114","insp_unit_id":"192648107","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"5171","insp_unit_license":"DC6607","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1JJV532D2HL946899","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:32.000000Z","updated_at":"2025-03-17T22:29:32.000000Z"}]},{"id":1015770,"change_date":"2022-08-11 21:38:00","inspection_id":"76295860","dot_number":"3201573","report_state":"IA","report_number":"000TT6LPMZ","insp_date":"2022-08-10 00:00:00","insp_start_time":"1115","insp_end_time":"1140","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"EB HWY 9 FOREST CITY","county_code_state":"IA","county_code":"189","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CLEAR CREEK EXPRESS","shipping_paper_number":"92877","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":"2022-08-11 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"1237204","transaction_code":"A","transaction_date":"2022-08-11 00:00:00","upload_date":"2022-08-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-08-10 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-08-11 21:38:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"330 SUMMERHAYS STREET","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"176815","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:45:28.000000Z","updated_at":"2025-03-17T18:45:28.000000Z","inspection_violations":[{"id":1599299,"change_date":"2022-08-11 21:38:00","inspection_id":"76295860","insp_violation_id":"247653338","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:30.000000Z","updated_at":"2025-03-17T21:14:30.000000Z","normalized_code":"3922"},{"id":1599300,"change_date":"2022-08-11 21:38:00","inspection_id":"76295860","insp_violation_id":"247653339","seq_no":"2","part_no":"395","part_no_section":"8(e)(1)","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":"2025-03-17T21:14:30.000000Z","updated_at":"2025-03-17T21:14:30.000000Z","normalized_code":"3958E1"}],"inspection_per_units":[{"id":1634259,"change_date":"2022-08-11 21:38:00","inspection_id":"76295860","insp_unit_id":"190257208","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"06","insp_unit_license":"FA4020","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYD49X0HJ145550","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:17.000000Z","updated_at":"2025-03-17T22:18:17.000000Z"},{"id":1634260,"change_date":"2022-08-11 21:38:00","inspection_id":"76295860","insp_unit_id":"190257209","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VANG","insp_unit_company":"1416","insp_unit_license":"355265ST","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"5V8VA53238M802640","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:17.000000Z","updated_at":"2025-03-17T22:18:17.000000Z"}]},{"id":838222,"change_date":"2022-07-18 21:42:00","inspection_id":"76088282","dot_number":"3201573","report_state":"NE","report_number":"HP00005146","insp_date":"2022-07-16 00:00:00","insp_start_time":"1517","insp_end_time":"1537","registration_date":null,"region":"CT","ci_status_code":"C","location":"GREENW","location_desc":"GREENWOOD","county_code_state":"NE","county_code":"025","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"RAYNOR GARAGE DOOR","shipping_paper_number":"92423","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-07-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"736171","transaction_code":"A","transaction_date":"2022-07-18 00:00:00","upload_date":"2022-07-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-07-18 00:00:00","source_office":"3NES001","mcmis_add_date":"2022-07-18 21:42:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"330 SUMMERHAYS STREET","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"176815","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:42:21.000000Z","updated_at":"2025-03-17T18:42:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1348756,"change_date":"2022-07-18 21:42:00","inspection_id":"76088282","insp_unit_id":"189827082","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"51","insp_unit_license":"FS4829","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYD49X5FJ430998","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:28.000000Z","updated_at":"2025-03-17T22:16:28.000000Z"},{"id":1348757,"change_date":"2022-07-18 21:42:00","inspection_id":"76088282","insp_unit_id":"189827083","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"6152","insp_unit_license":"687369ST","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"1GRAA0625GT612512","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:28.000000Z","updated_at":"2025-03-17T22:16:28.000000Z"}]},{"id":688314,"change_date":"2022-06-24 21:39:00","inspection_id":"75912742","dot_number":"3201573","report_state":"IL","report_number":"4070200162","insp_date":"2022-06-11 00:00:00","insp_start_time":"1330","insp_end_time":"1424","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"US RTE 30 E\/B AT AGNEW RD","county_code_state":"IL","county_code":"195","insp_level_id":"3","service_center":"MW","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":"2022-06-24 21:39:00","post_acc_ind":"Y","gross_comb_veh_wt":"92000","viol_total":"3","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":"2179135","transaction_code":"A","transaction_date":"2022-06-11 00:00:00","upload_date":"2022-06-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":null,"census_search_date":"2022-06-24 21:39:00","snet_input_date":"2022-06-11 00:00:00","source_office":"3ILS001","mcmis_add_date":"2022-06-24 21:39:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"330 SUMMERHAYS STREET","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:39:49.000000Z","updated_at":"2025-03-17T18:39:49.000000Z","inspection_violations":[{"id":1083099,"change_date":"2022-06-24 21:39:00","inspection_id":"75912742","insp_violation_id":"246706362","seq_no":"1","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"N","defect_verification_id":"4","citation_number":"-","created_at":"2025-03-17T21:12:06.000000Z","updated_at":"2025-03-17T21:12:06.000000Z","normalized_code":"3958A1"},{"id":1083100,"change_date":"2022-06-24 21:39:00","inspection_id":"75912742","insp_violation_id":"246706363","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"56286","created_at":"2025-03-17T21:12:06.000000Z","updated_at":"2025-03-17T21:12:06.000000Z","normalized_code":"3922"},{"id":1083101,"change_date":"2022-06-24 21:39:00","inspection_id":"75912742","insp_violation_id":"246706364","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"43","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"56287","created_at":"2025-03-17T21:12:06.000000Z","updated_at":"2025-03-17T21:12:06.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1105754,"change_date":"2022-06-24 21:39:00","inspection_id":"75912742","insp_unit_id":"189449836","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"-","insp_unit_license":"FR8598","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKADB9XX4J059355","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:00.000000Z","updated_at":"2025-03-17T22:15:00.000000Z"},{"id":1105755,"change_date":"2022-06-24 21:39:00","inspection_id":"75912742","insp_unit_id":"189449837","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"539189","insp_unit_license":"847841ST","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"1JJV532DXNL339189","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:00.000000Z","updated_at":"2025-03-17T22:15:00.000000Z"}]},{"id":564471,"change_date":"2022-06-08 21:40:00","inspection_id":"75765775","dot_number":"3201573","report_state":"KS","report_number":"HP05040428","insp_date":"2022-06-07 00:00:00","insp_start_time":"1255","insp_end_time":"1320","registration_date":null,"region":"CT","ci_status_code":"C","location":"SG","location_desc":"SEDGWICK COUNTY - 173","county_code_state":"KS","county_code":"173","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"ALBAUGH","shipping_paper_number":"7895","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":"2022-06-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"121000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1252155","transaction_code":"A","transaction_date":"2022-06-08 00:00:00","upload_date":"2022-06-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-06-07 00:00:00","source_office":"3KSS001","mcmis_add_date":"2022-06-08 21:40:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"330 SUMMERHAYS STREET","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"176815","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:37:44.000000Z","updated_at":"2025-03-17T18:37:44.000000Z","inspection_violations":[{"id":886537,"change_date":"2022-06-08 21:40:00","inspection_id":"75765775","insp_violation_id":"246303345","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:11.000000Z","updated_at":"2025-03-17T21:11:11.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":908111,"change_date":"2022-06-08 21:40:00","inspection_id":"75765775","insp_unit_id":"189117026","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"10","insp_unit_license":"FS0251","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYDP9X7GJ492017","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:47.000000Z","updated_at":"2025-03-17T22:13:47.000000Z"},{"id":908112,"change_date":"2022-06-08 21:40:00","inspection_id":"75765775","insp_unit_id":"189117027","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"1","insp_unit_license":"IR7291","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1JJV532D6PL372130","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:47.000000Z","updated_at":"2025-03-17T22:13:47.000000Z"}]},{"id":432177,"change_date":"2022-05-19 21:42:00","inspection_id":"75608446","dot_number":"3201573","report_state":"IA","report_number":"000TT8CHL8","insp_date":"2022-05-18 00:00:00","insp_start_time":"1047","insp_end_time":"1144","registration_date":null,"region":"CT","ci_status_code":"C","location":"01","location_desc":"01 - I80 WB MM 151 MITCHELLVIL","county_code_state":"IA","county_code":"099","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"RAYNOR GARAGE DOOR COMPANY","shipping_paper_number":"91679","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":"2022-05-19 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1225618","transaction_code":"A","transaction_date":"2022-05-19 00:00:00","upload_date":"2022-05-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-05-18 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-05-19 21:42:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"330 SUMMERHAYS STREET","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"176815","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:35:10.000000Z","updated_at":"2025-03-17T18:35:10.000000Z","inspection_violations":[{"id":678371,"change_date":"2022-05-19 21:42:00","inspection_id":"75608446","insp_violation_id":"245916915","seq_no":"1","part_no":"395","part_no_section":"8(e)(1)","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":"2025-03-17T21:10:11.000000Z","updated_at":"2025-03-17T21:10:11.000000Z","normalized_code":"3958E1"},{"id":678372,"change_date":"2022-05-19 21:42:00","inspection_id":"75608446","insp_violation_id":"245916916","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"188788848","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:11.000000Z","updated_at":"2025-03-17T21:10:11.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":696865,"change_date":"2022-05-19 21:42:00","inspection_id":"75608446","insp_unit_id":"188788847","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"06","insp_unit_license":"FA4020","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYD49X0HJ145550","insp_unit_decal":"Y","insp_unit_decal_number":"31386236","created_at":"2025-03-17T22:12:29.000000Z","updated_at":"2025-03-17T22:12:29.000000Z"},{"id":696866,"change_date":"2022-05-19 21:42:00","inspection_id":"75608446","insp_unit_id":"188788848","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"W05974","insp_unit_license":"297771Z","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1JJV532D4EL815260","insp_unit_decal":"Y","insp_unit_decal_number":"31386237","created_at":"2025-03-17T22:12:29.000000Z","updated_at":"2025-03-17T22:12:29.000000Z"}]},{"id":326927,"change_date":"2022-05-05 21:41:00","inspection_id":"75482919","dot_number":"3201573","report_state":"MS","report_number":"1012010679","insp_date":"2022-05-04 00:00:00","insp_start_time":"1435","insp_end_time":"1459","registration_date":null,"region":"CT","ci_status_code":"C","location":"T-94","location_desc":"IUKA SCALE US 72 WEST","county_code_state":"MS","county_code":"141","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":null,"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":"964046","transaction_code":"A","transaction_date":"2022-05-04 00:00:00","upload_date":"2022-05-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-05-05 00:00:00","source_office":"2MSS002","mcmis_add_date":"2022-05-05 21:41:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"330 SUMMERHAYS STREET","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"176815","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:33:19.000000Z","updated_at":"2025-03-17T18:33:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":528752,"change_date":"2022-05-05 21:41:00","inspection_id":"75482919","insp_unit_id":"188521917","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"10","insp_unit_license":"FS0251","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYDP9X7GJ492017","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:26.000000Z","updated_at":"2025-03-17T22:11:26.000000Z"},{"id":528753,"change_date":"2022-05-05 21:41:00","inspection_id":"75482919","insp_unit_id":"188521918","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VANG","insp_unit_company":"5234","insp_unit_license":"R133162","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"5V8VA5328PM305758","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:26.000000Z","updated_at":"2025-03-17T22:11:26.000000Z"}]},{"id":101128,"change_date":"2022-04-04 21:40:00","inspection_id":"75211724","dot_number":"3201573","report_state":"WI","report_number":"2674001060","insp_date":"2022-04-03 00:00:00","insp_start_time":"1014","insp_end_time":"1055","registration_date":null,"region":"CT","ci_status_code":"C","location":"S16","location_desc":"MADISON SWEF","county_code_state":"WI","county_code":"025","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"CHELAN","shipping_paper_number":"56602","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":"I","final_status_date":"2022-04-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"856668","transaction_code":"A","transaction_date":"2022-04-04 00:00:00","upload_date":"2022-04-04 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-04-04 00:00:00","source_office":"3WIS001","mcmis_add_date":"2022-04-04 21:40:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"330 SUMMERHAYS STREET","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340","insp_colonia":null,"docket_number":"176815","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:29:26.000000Z","updated_at":"2025-03-17T18:29:26.000000Z","inspection_violations":[{"id":148849,"change_date":"2022-04-04 21:40:00","inspection_id":"75211724","insp_violation_id":"244942906","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"187968753","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:07:46.000000Z","updated_at":"2025-03-17T21:07:46.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":163748,"change_date":"2022-04-04 21:40:00","inspection_id":"75211724","insp_unit_id":"187968752","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"77","insp_unit_license":"FR8598","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKADB9XX4J059355","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:13.000000Z","updated_at":"2025-03-17T22:09:13.000000Z"},{"id":163749,"change_date":"2022-04-04 21:40:00","inspection_id":"75211724","insp_unit_id":"187968753","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"5322","insp_unit_license":"786352","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"1UYVS25347U004135","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:13.000000Z","updated_at":"2025-03-17T22:09:13.000000Z"}]},{"id":82721,"change_date":"2022-03-31 21:41:00","inspection_id":"75189342","dot_number":"3201573","report_state":"MT","report_number":"F663008863","insp_date":"2022-03-30 00:00:00","insp_start_time":"2254","insp_end_time":"2315","registration_date":null,"region":"MT","ci_status_code":"C","location":"HAUGAN","location_desc":"HAUGAN","county_code_state":"MT","county_code":"061","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"SHIPLEY SALES","shipping_paper_number":"65832","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":"I","final_status_date":"2022-03-31 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"953561","transaction_code":"A","transaction_date":"2022-03-30 00:00:00","upload_date":"2022-03-31 00:00:00","upload_first_byte":"0","upload_dot_number":"03201573","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-03-31 00:00:00","source_office":"4MTS001","mcmis_add_date":"2022-03-31 21:41:00","insp_carrier_name":"CLEAR CREEK EXPRESS LLC","insp_carrier_street":"PO BOX 222","insp_carrier_city":"TIFFIN","insp_carrier_state":"IA","insp_carrier_zip_code":"52340-4711","insp_colonia":null,"docket_number":"176815","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:29:06.000000Z","updated_at":"2025-03-17T18:29:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":134216,"change_date":"2022-03-31 21:41:00","inspection_id":"75189342","insp_unit_id":"187923771","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"77","insp_unit_license":"FR8598","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKADB9XX4J059355","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:02.000000Z","updated_at":"2025-03-17T22:09:02.000000Z"},{"id":134217,"change_date":"2022-03-31 21:41:00","inspection_id":"75189342","insp_unit_id":"187923772","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"5322","insp_unit_license":"786352","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"1UYVS25347U004135","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:02.000000Z","updated_at":"2025-03-17T22:09:02.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3201573\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3201573\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3201573\/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\/3201573\/inspections","per_page":100,"prev_page_url":null,"to":79,"total":79}