{"current_page":1,"data":[{"id":12326991,"change_date":"2026-06-30 21:40:00","inspection_id":"88285215","dot_number":"3370817","report_state":"CA","report_number":"NFAC002743","insp_date":"2026-06-26 00:00:00","insp_start_time":"1730","insp_end_time":"1755","registration_date":null,"region":"PD","ci_status_code":"C","location":"147","location_desc":"CA","county_code_state":"CA","county_code":"093","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"TRINIDAD BONHAM CORP","shipping_paper_number":"8096840","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-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"3656875","transaction_code":"A","transaction_date":"2026-06-30 00:00:00","upload_date":"2026-06-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03370817","upload_search_indicator":null,"census_search_date":"2026-06-30 21:40:00","snet_input_date":"2026-06-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-30 21:40:00","insp_carrier_name":"ESTEEM FREIGHTWAYS LLC","insp_carrier_street":"10024 MOUNT BLANC LN","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95219","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-03T09:41:31.000000Z","updated_at":"2026-07-11T09:31:11.000000Z","inspection_violations":[{"id":21453683,"change_date":"2026-06-30 21:40:00","inspection_id":"88285215","insp_violation_id":"275226730","seq_no":"1","part_no":"395","part_no_section":"8E-HOSPDELDT","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-03T10:02:39.000000Z","updated_at":"2026-07-11T09:41:46.000000Z","normalized_code":"3958EHOSPDELDT"}],"inspection_per_units":[{"id":21408712,"change_date":"2026-06-30 21:40:00","inspection_id":"88285215","insp_unit_id":"214376339","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"683\/WHT","insp_unit_license":"ZP51915","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X6RJ385185","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-05T09:18:12.000000Z","updated_at":"2026-07-11T09:02:39.000000Z"},{"id":21408713,"change_date":"2026-06-30 21:40:00","inspection_id":"88285215","insp_unit_id":"214376340","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"A18\/WHT","insp_unit_license":"4ST7491","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2537L2884219","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-05T09:18:12.000000Z","updated_at":"2026-07-11T09:02:39.000000Z"}]},{"id":11219884,"change_date":"2026-02-24 21:40:00","inspection_id":"87131577","dot_number":"3370817","report_state":"CA","report_number":"NCV6009310","insp_date":"2026-02-11 00:00:00","insp_start_time":"1341","insp_end_time":"1354","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CHELAN FRESH MARKETING","shipping_paper_number":"82514","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":null,"final_status_date":"2026-02-24 21:40: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":"16181358","transaction_code":"A","transaction_date":"2026-02-11 00:00:00","upload_date":"2026-02-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03370817","upload_search_indicator":null,"census_search_date":"2026-02-24 21:40:00","snet_input_date":"2026-02-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-02-24 21:40:00","insp_carrier_name":"ESTEEM FREIGHTWAYS LLC","insp_carrier_street":"10024 MOUNT BLANC LN","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95219","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-27T10:38:09.000000Z","updated_at":"2026-03-07T10:31:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19165011,"change_date":"2026-02-24 21:40:00","inspection_id":"87131577","insp_unit_id":"211804000","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"683\/WHT","insp_unit_license":"ZP51915","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X6RJ385185","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-27T10:13:26.000000Z","updated_at":"2026-03-07T10:04:07.000000Z"},{"id":19165012,"change_date":"2026-02-24 21:40:00","inspection_id":"87131577","insp_unit_id":"211804001","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"A18\/WHT","insp_unit_license":"4ST7491","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2537L2884219","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-27T10:13:26.000000Z","updated_at":"2026-03-07T10:04:07.000000Z"}]},{"id":10204931,"change_date":"2025-11-14 21:41:00","inspection_id":"86325919","dot_number":"3370817","report_state":"CA","report_number":"NELC004336","insp_date":"2025-11-08 00:00:00","insp_start_time":"1943","insp_end_time":"2033","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"RIVER POINT","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":"N","pen_cen_match":null,"final_status_date":"2025-11-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"16059356","transaction_code":"A","transaction_date":"2025-11-14 00:00:00","upload_date":"2025-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03370817","upload_search_indicator":null,"census_search_date":"2025-11-14 21:41:00","snet_input_date":"2025-11-08 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-11-14 21:41:00","insp_carrier_name":"ESTEEM FREIGHTWAYS LLC","insp_carrier_street":"10024 MOUNT BLANC LN","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95219","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-17T10:31:35.000000Z","updated_at":"2025-11-18T10:31:16.000000Z","inspection_violations":[{"id":16956128,"change_date":"2025-11-14 21:41:00","inspection_id":"86325919","insp_violation_id":"269969982","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"210040875","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-17T10:32:17.000000Z","updated_at":"2025-11-18T10:32:31.000000Z","normalized_code":"39347E"},{"id":16956129,"change_date":"2025-11-14 21:41:00","inspection_id":"86325919","insp_violation_id":"269969983","seq_no":"2","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"2","insp_unit_id":"210040875","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-17T10:32:17.000000Z","updated_at":"2025-11-18T10:32:31.000000Z","normalized_code":"39353BB"}],"inspection_per_units":[{"id":16999480,"change_date":"2025-11-14 21:41:00","inspection_id":"86325919","insp_unit_id":"210040874","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"683\/WHT","insp_unit_license":"ZP51915","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X6RJ385185","insp_unit_decal":"Y","insp_unit_decal_number":"35609853","created_at":"2025-11-17T10:01:27.000000Z","updated_at":"2025-11-18T10:01:52.000000Z"},{"id":16999481,"change_date":"2025-11-14 21:41:00","inspection_id":"86325919","insp_unit_id":"210040875","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"A18\/WHT","insp_unit_license":"4ST7491","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2537L2884219","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-17T10:01:27.000000Z","updated_at":"2025-11-18T10:01:52.000000Z"}]},{"id":9789521,"change_date":"2025-09-26 21:39:00","inspection_id":"85888311","dot_number":"3370817","report_state":"OR","report_number":"AW07680199","insp_date":"2025-09-26 00:00:00","insp_start_time":"1131","insp_end_time":"1147","registration_date":null,"region":"PD","ci_status_code":"C","location":"10-07","location_desc":"MYRTLE CREEK OR","county_code_state":"OR","county_code":"019","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-09-26 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"118200","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":"2332859","transaction_code":"A","transaction_date":"2025-09-26 00:00:00","upload_date":"2025-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03370817","upload_search_indicator":null,"census_search_date":"2025-09-26 21:39:00","snet_input_date":"2025-09-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-26 21:39:00","insp_carrier_name":"ESTEEM FREIGHTWAYS LLC","insp_carrier_street":"10024 MOUNT BLANC LN","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95219","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-30T10:01:00.000000Z","updated_at":"2025-09-30T10:01:00.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16221278,"change_date":"2025-09-26 21:39:00","inspection_id":"85888311","insp_unit_id":"209165101","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"683","insp_unit_license":"ZP51915","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X6RJ385185","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-29T09:47:38.000000Z","updated_at":"2025-09-30T09:45:28.000000Z"},{"id":16221279,"change_date":"2025-09-26 21:39:00","inspection_id":"85888311","insp_unit_id":"209165102","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"A18","insp_unit_license":"4ST7491","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2537L2884219","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-29T09:47:38.000000Z","updated_at":"2025-09-30T09:45:28.000000Z"}]},{"id":9660258,"change_date":"2025-09-12 21:50:00","inspection_id":"85752677","dot_number":"3370817","report_state":"CA","report_number":"NDN9006640","insp_date":"2025-09-04 00:00:00","insp_start_time":"1814","insp_end_time":"1825","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"TWIN RIVER","shipping_paper_number":"8513","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":null,"final_status_date":"2025-09-11 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":"15977381","transaction_code":"C","transaction_date":"2025-09-04 00:00:00","upload_date":"2025-09-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03370817","upload_search_indicator":null,"census_search_date":"2025-09-11 21:42:00","snet_input_date":"2025-09-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-11 21:42:00","insp_carrier_name":"ESTEEM FREIGHTWAYS LLC","insp_carrier_street":"10024 MOUNT BLANC LN","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95219","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-13T10:48:09.000000Z","updated_at":"2025-09-16T10:48:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16001478,"change_date":"2025-09-12 21:50:00","inspection_id":"85752677","insp_unit_id":"208929141","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"WHT","insp_unit_license":"ZP51915","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X6RJ385185","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-15T09:54:03.000000Z","updated_at":"2025-09-16T09:56:33.000000Z"},{"id":16001479,"change_date":"2025-09-12 21:50:00","inspection_id":"85752677","insp_unit_id":"208929142","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"WHT","insp_unit_license":"4WR1350","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2538K2594909","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-15T09:54:03.000000Z","updated_at":"2025-09-16T09:56:33.000000Z"}]},{"id":9463207,"change_date":"2025-08-20 21:40:00","inspection_id":"85545964","dot_number":"3370817","report_state":"CA","report_number":"NC0J007414","insp_date":"2025-08-12 00:00:00","insp_start_time":"1754","insp_end_time":"1849","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"J.C. CHEYNE CO","shipping_paper_number":"CC80825","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":null,"final_status_date":"2025-08-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"15944879","transaction_code":"A","transaction_date":"2025-08-12 00:00:00","upload_date":"2025-08-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03370817","upload_search_indicator":null,"census_search_date":"2025-08-20 21:40:00","snet_input_date":"2025-08-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-08-20 21:40:00","insp_carrier_name":"ESTEEM FREIGHTWAYS LLC","insp_carrier_street":"10024 MOUNT BLANC LN","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95219","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-23T10:46:54.000000Z","updated_at":"2025-08-25T10:42:22.000000Z","inspection_violations":[{"id":15416756,"change_date":"2025-08-20 21:40:00","inspection_id":"85545964","insp_violation_id":"268149617","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOLTIS","insp_viol_unit":"2","insp_unit_id":"208497141","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"DA304205","created_at":"2025-08-23T10:49:22.000000Z","updated_at":"2025-08-24T10:48:07.000000Z","normalized_code":"39375A3TAOLTIS"}],"inspection_per_units":[{"id":15606194,"change_date":"2025-08-20 21:40:00","inspection_id":"85545964","insp_unit_id":"208497140","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"GRY","insp_unit_license":"ZP16762","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X3LJ359103","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-23T09:46:47.000000Z","updated_at":"2025-08-24T09:46:15.000000Z"},{"id":15606195,"change_date":"2025-08-20 21:40:00","inspection_id":"85545964","insp_unit_id":"208497141","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"WHT","insp_unit_license":"4TW2881","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2536N2419806","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-23T09:46:47.000000Z","updated_at":"2025-08-24T09:46:15.000000Z"}]},{"id":9146073,"change_date":"2025-07-14 21:41:00","inspection_id":"85212598","dot_number":"3370817","report_state":"CA","report_number":"NDZX003869","insp_date":"2025-06-26 00:00:00","insp_start_time":"1811","insp_end_time":"1818","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CIRCLE C","shipping_paper_number":"80552","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":null,"final_status_date":"2025-07-14 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":"15897768","transaction_code":"A","transaction_date":"2025-06-26 00:00:00","upload_date":"2025-07-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03370817","upload_search_indicator":null,"census_search_date":"2025-07-14 21:41:00","snet_input_date":"2025-06-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-07-14 21:41:00","insp_carrier_name":"ESTEEM FREIGHTWAYS LLC","insp_carrier_street":"10024 MOUNT BLANC LN","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95219","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-18T10:45:51.000000Z","updated_at":"2025-07-18T10:45:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15019635,"change_date":"2025-07-14 21:41:00","inspection_id":"85212598","insp_unit_id":"207865194","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"WHT","insp_unit_license":"ZP51915","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X6RJ385185","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-17T09:45:35.000000Z","updated_at":"2025-07-18T09:46:19.000000Z"},{"id":15019636,"change_date":"2025-07-14 21:41:00","inspection_id":"85212598","insp_unit_id":"207865195","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"WHT","insp_unit_license":"4TW2881","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"UNKNOWN","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-17T09:45:35.000000Z","updated_at":"2025-07-18T09:46:19.000000Z"}]},{"id":8986617,"change_date":"2025-06-26 21:40:00","inspection_id":"85044758","dot_number":"3370817","report_state":"OR","report_number":"AP41270419","insp_date":"2025-06-25 00:00:00","insp_start_time":"1914","insp_end_time":"2016","registration_date":null,"region":"PD","ci_status_code":"C","location":"24-08","location_desc":"WOODBURN OR","county_code_state":"OR","county_code":"047","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"COSTEAUX FRENCH BAKERY","shipping_paper_number":"CM-CX-RAL-0623","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-06-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"118200","viol_total":"4","oos_total":"2","driver_viol_total":"0","driver_oos_total":"2","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1916499","transaction_code":"A","transaction_date":"2025-06-25 00:00:00","upload_date":"2025-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03370817","upload_search_indicator":null,"census_search_date":"2025-06-26 21:40:00","snet_input_date":"2025-06-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-26 21:40:00","insp_carrier_name":"ESTEEM FREIGHTWAYS LLC","insp_carrier_street":"10024 MOUNT BLANC LN","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95219","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-30T10:00:51.000000Z","updated_at":"2025-06-30T10:00:51.000000Z","inspection_violations":[{"id":14450404,"change_date":"2025-06-26 21:40:00","inspection_id":"85044758","insp_violation_id":"267049330","seq_no":"1","part_no":"395","part_no_section":"8E-HOSPDOOS","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-29T10:16:29.000000Z","updated_at":"2025-06-30T10:17:07.000000Z","normalized_code":"3958EHOSPDOOS"},{"id":14450405,"change_date":"2025-06-26 21:40:00","inspection_id":"85044758","insp_violation_id":"267049331","seq_no":"2","part_no":"395","part_no_section":"3A1-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-29T10:16:29.000000Z","updated_at":"2025-06-30T10:17:07.000000Z","normalized_code":"3953A1HOSPD"},{"id":14450406,"change_date":"2025-06-26 21:40:00","inspection_id":"85044758","insp_violation_id":"267049332","seq_no":"3","part_no":"395","part_no_section":"8E-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-29T10:16:29.000000Z","updated_at":"2025-06-30T10:17:07.000000Z","normalized_code":"3958EHOSPD"},{"id":14450407,"change_date":"2025-06-26 21:40:00","inspection_id":"85044758","insp_violation_id":"267049333","seq_no":"4","part_no":"395","part_no_section":"8E-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-29T10:16:29.000000Z","updated_at":"2025-06-30T10:17:07.000000Z","normalized_code":"3958EHOSPD"}],"inspection_per_units":[{"id":14737657,"change_date":"2025-06-26 21:40:00","inspection_id":"85044758","insp_unit_id":"207557519","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"4599","insp_unit_license":"4TW2881","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"UNKNOWN","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-29T09:46:10.000000Z","updated_at":"2025-07-01T09:46:58.000000Z"},{"id":14737656,"change_date":"2025-06-26 21:40:00","inspection_id":"85044758","insp_unit_id":"207557518","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"683","insp_unit_license":"ZP51915","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X6RJ385185","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-29T09:46:10.000000Z","updated_at":"2025-07-01T09:46:58.000000Z"}]},{"id":8997081,"change_date":"2025-06-26 21:41:00","inspection_id":"85055782","dot_number":"3370817","report_state":"CA","report_number":"NC0J007127","insp_date":"2025-06-19 00:00:00","insp_start_time":"1935","insp_end_time":"1943","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CIRCLE C","shipping_paper_number":"MULT","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":null,"final_status_date":"2025-06-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"15868082","transaction_code":"A","transaction_date":"2025-06-19 00:00:00","upload_date":"2025-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03370817","upload_search_indicator":null,"census_search_date":"2025-06-26 21:41:00","snet_input_date":"2025-06-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-26 21:41:00","insp_carrier_name":"ESTEEM FREIGHTWAYS LLC","insp_carrier_street":"10024 MOUNT BLANC LN","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95219","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-30T10:01:04.000000Z","updated_at":"2025-06-30T10:01:04.000000Z","inspection_violations":[{"id":14466463,"change_date":"2025-06-26 21:41:00","inspection_id":"85055782","insp_violation_id":"267070256","seq_no":"1","part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RC53005","created_at":"2025-06-29T10:16:52.000000Z","updated_at":"2025-06-30T10:18:14.000000Z","normalized_code":"38323A2LCDLN"}],"inspection_per_units":[{"id":14755094,"change_date":"2025-06-26 21:41:00","inspection_id":"85055782","insp_unit_id":"207578064","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"683\/WHT","insp_unit_license":"ZP51915","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X6RJ385185","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-29T09:46:20.000000Z","updated_at":"2025-07-01T09:47:59.000000Z"},{"id":14755095,"change_date":"2025-06-26 21:41:00","inspection_id":"85055782","insp_unit_id":"207578065","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"4599\/WHT","insp_unit_license":"4TW2881","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2536N2419806","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-29T09:46:20.000000Z","updated_at":"2025-07-01T09:47:59.000000Z"}]},{"id":8999898,"change_date":"2025-06-26 21:41:00","inspection_id":"85058648","dot_number":"3370817","report_state":"CA","report_number":"NELC003743","insp_date":"2025-06-16 00:00:00","insp_start_time":"1934","insp_end_time":"1940","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CIRCLE C MARKETING","shipping_paper_number":"CC80481","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":null,"final_status_date":"2025-06-26 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":"15874862","transaction_code":"A","transaction_date":"2025-06-16 00:00:00","upload_date":"2025-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03370817","upload_search_indicator":null,"census_search_date":"2025-06-26 21:41:00","snet_input_date":"2025-06-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-26 21:41:00","insp_carrier_name":"ESTEEM FREIGHTWAYS LLC","insp_carrier_street":"10024 MOUNT BLANC LN","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95219","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-30T10:01:07.000000Z","updated_at":"2025-06-30T10:01:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14759640,"change_date":"2025-06-26 21:41:00","inspection_id":"85058648","insp_unit_id":"207582849","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"683\/WHT","insp_unit_license":"ZP51915","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X6RJ385185","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-29T09:46:23.000000Z","updated_at":"2025-07-01T09:48:16.000000Z"},{"id":14759641,"change_date":"2025-06-26 21:41:00","inspection_id":"85058648","insp_unit_id":"207582850","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"4599\/WHT","insp_unit_license":"4TW2881","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2536N2419806","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-29T09:46:23.000000Z","updated_at":"2025-07-01T09:48:16.000000Z"}]},{"id":8782733,"change_date":"2025-05-30 21:41:00","inspection_id":"84828380","dot_number":"3370817","report_state":"CA","report_number":"NDZX003663","insp_date":"2025-05-29 00:00:00","insp_start_time":"1837","insp_end_time":"1852","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CG ROXANNE","shipping_paper_number":"15700701","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":null,"final_status_date":"2025-05-30 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":"15842663","transaction_code":"A","transaction_date":"2025-05-29 00:00:00","upload_date":"2025-05-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03370817","upload_search_indicator":null,"census_search_date":"2025-05-30 21:41:00","snet_input_date":"2025-05-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-05-30 21:41:00","insp_carrier_name":"ESTEEM FREIGHTWAYS LLC","insp_carrier_street":"10024 MOUNT BLANC LN","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95219","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-04T10:01:11.000000Z","updated_at":"2025-06-04T10:01:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14369922,"change_date":"2025-05-30 21:41:00","inspection_id":"84828380","insp_unit_id":"207157821","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"683\/WHT","insp_unit_license":"ZP51915","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X6RJ385185","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-02T09:46:25.000000Z","updated_at":"2025-06-03T09:46:12.000000Z"},{"id":14369923,"change_date":"2025-05-30 21:41:00","inspection_id":"84828380","insp_unit_id":"207157822","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"A18\/WHT","insp_unit_license":"4ST7491","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2537L2884219","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-02T09:46:25.000000Z","updated_at":"2025-06-03T09:46:12.000000Z"}]},{"id":8621017,"change_date":"2025-05-13 21:41:00","inspection_id":"84657824","dot_number":"3370817","report_state":"CA","report_number":"NCV6008150","insp_date":"2025-05-07 00:00:00","insp_start_time":"0942","insp_end_time":"1012","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"1","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"2","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15816689","transaction_code":"A","transaction_date":"2025-05-12 00:00:00","upload_date":"2025-05-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03370817","upload_search_indicator":null,"census_search_date":"2025-05-13 21:41:00","snet_input_date":"2025-05-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-05-13 21:41:00","insp_carrier_name":"ESTEEM FREIGHTWAYS LLC","insp_carrier_street":"10024 MOUNT BLANC LN","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95219","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-17T10:04:19.000000Z","updated_at":"2025-05-17T10:09:33.000000Z","inspection_violations":[{"id":13707602,"change_date":"2025-05-13 21:41:00","inspection_id":"84657824","insp_violation_id":"266200111","seq_no":"1","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"2","insp_unit_id":"206837479","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA712986","created_at":"2025-05-16T10:36:31.000000Z","updated_at":"2025-05-18T10:26:41.000000Z","normalized_code":"3939ALTSI"},{"id":13707603,"change_date":"2025-05-13 21:41:00","inspection_id":"84657824","insp_violation_id":"266200112","seq_no":"2","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"2","insp_unit_id":"206837479","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-16T10:36:31.000000Z","updated_at":"2025-05-18T10:26:41.000000Z","normalized_code":"3963A1BOS"}],"inspection_per_units":[{"id":14076428,"change_date":"2025-05-13 21:41:00","inspection_id":"84657824","insp_unit_id":"206837478","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"681\/GRAY","insp_unit_license":"ZP16762","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X3LJ359103","insp_unit_decal":"Y","insp_unit_decal_number":"35053235","created_at":"2025-05-16T09:49:51.000000Z","updated_at":"2025-05-17T09:51:35.000000Z"},{"id":14076429,"change_date":"2025-05-13 21:41:00","inspection_id":"84657824","insp_unit_id":"206837479","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"4599\/WHT","insp_unit_license":"4TW2881","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2536N2419806","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-16T09:49:51.000000Z","updated_at":"2025-05-17T09:51:35.000000Z"}]},{"id":8621069,"change_date":"2025-05-13 21:41:00","inspection_id":"84657878","dot_number":"3370817","report_state":"CA","report_number":"NCU6004544","insp_date":"2025-05-07 00:00:00","insp_start_time":"1026","insp_end_time":"1038","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"1","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-13 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":"15816705","transaction_code":"A","transaction_date":"2025-05-12 00:00:00","upload_date":"2025-05-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03370817","upload_search_indicator":null,"census_search_date":"2025-05-13 21:41:00","snet_input_date":"2025-05-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-05-13 21:41:00","insp_carrier_name":"ESTEEM FREIGHTWAYS LLC","insp_carrier_street":"10024 MOUNT BLANC LN","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95219","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-17T10:04:19.000000Z","updated_at":"2025-05-17T10:09:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14076507,"change_date":"2025-05-13 21:41:00","inspection_id":"84657878","insp_unit_id":"206837560","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"681\/GRY","insp_unit_license":"ZP16762","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X3LJ359103","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-16T09:49:51.000000Z","updated_at":"2025-05-17T09:51:36.000000Z"},{"id":14076508,"change_date":"2025-05-13 21:41:00","inspection_id":"84657878","insp_unit_id":"206837561","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"4599\/WHT","insp_unit_license":"4TW2881","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2536N2419806","insp_unit_decal":"Y","insp_unit_decal_number":"35052615","created_at":"2025-05-16T09:49:51.000000Z","updated_at":"2025-05-17T09:51:36.000000Z"}]},{"id":7645320,"change_date":"2025-01-17 21:39:00","inspection_id":"83631239","dot_number":"3370817","report_state":"OR","report_number":"AP42810224","insp_date":"2025-01-16 00:00:00","insp_start_time":"1210","insp_end_time":"1236","registration_date":null,"region":"PS","ci_status_code":"C","location":"30-06","location_desc":"UMATILLA OR","county_code_state":"OR","county_code":"059","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"NONE","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":"U","pen_cen_match":"I","final_status_date":"2025-01-17 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":"1256718","transaction_code":"A","transaction_date":"2025-01-16 00:00:00","upload_date":"2025-01-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03370817","upload_search_indicator":null,"census_search_date":"2025-01-17 21:39:00","snet_input_date":"2025-01-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-17 21:39:00","insp_carrier_name":"ESTEEM FREIGHTWAYS LLC","insp_carrier_street":"10024 MOUNT BLANC LN","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95219","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:57:00.000000Z","updated_at":"2025-03-17T20:57:00.000000Z","inspection_violations":[{"id":11945554,"change_date":"2025-01-17 21:39:00","inspection_id":"83631239","insp_violation_id":"264047789","seq_no":"1","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CE495189","created_at":"2025-03-17T22:04:13.000000Z","updated_at":"2025-03-17T22:04:13.000000Z","normalized_code":"3922SLL"}],"inspection_per_units":[{"id":12335961,"change_date":"2025-01-17 21:39:00","inspection_id":"83631239","insp_unit_id":"204883556","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"681","insp_unit_license":"ZP16762","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X3LJ359103","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:09.000000Z","updated_at":"2025-03-17T23:51:09.000000Z"},{"id":12335962,"change_date":"2025-01-17 21:39:00","inspection_id":"83631239","insp_unit_id":"204883557","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"53132","insp_unit_license":"4PN9954","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532D8HL961794","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:09.000000Z","updated_at":"2025-03-17T23:51:09.000000Z"}]},{"id":7676729,"change_date":"2025-01-21 21:40:00","inspection_id":"83664402","dot_number":"3370817","report_state":"CA","report_number":"NC0J006635","insp_date":"2025-01-11 00:00:00","insp_start_time":"1733","insp_end_time":"1751","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"WALTS","shipping_paper_number":"4500261380","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":null,"final_status_date":"2025-01-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"3","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15669454","transaction_code":"A","transaction_date":"2025-01-17 00:00:00","upload_date":"2025-01-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03370817","upload_search_indicator":null,"census_search_date":"2025-01-21 21:40:00","snet_input_date":"2025-01-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-01-21 21:40:00","insp_carrier_name":"ESTEEM FREIGHTWAYS LLC","insp_carrier_street":"10024 MOUNT BLANC LN","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95219","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:57:29.000000Z","updated_at":"2025-03-17T20:57:29.000000Z","inspection_violations":[{"id":11997009,"change_date":"2025-01-21 21:40:00","inspection_id":"83664402","insp_violation_id":"264112349","seq_no":"1","part_no":"393","part_no_section":"45B2-BHTD","insp_viol_unit":"2","insp_unit_id":"204943877","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:04:26.000000Z","updated_at":"2025-03-17T22:04:26.000000Z","normalized_code":"39345B2BHTD"},{"id":11997010,"change_date":"2025-01-21 21:40:00","inspection_id":"83664402","insp_violation_id":"264112350","seq_no":"2","part_no":"393","part_no_section":"45B2-BHTD","insp_viol_unit":"2","insp_unit_id":"204943877","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA304563","created_at":"2025-03-17T22:04:26.000000Z","updated_at":"2025-03-17T22:04:26.000000Z","normalized_code":"39345B2BHTD"},{"id":11997011,"change_date":"2025-01-21 21:40:00","inspection_id":"83664402","insp_violation_id":"264112351","seq_no":"3","part_no":"393","part_no_section":"48A-BIBD","insp_viol_unit":"2","insp_unit_id":"204943877","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:26.000000Z","updated_at":"2025-03-17T22:04:26.000000Z","normalized_code":"39348ABIBD"}],"inspection_per_units":[{"id":12387499,"change_date":"2025-01-21 21:40:00","inspection_id":"83664402","insp_unit_id":"204943876","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"681\/GRY","insp_unit_license":"ZP16762","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X3LJ359103","insp_unit_decal":"Y","insp_unit_decal_number":"34755289","created_at":"2025-03-17T23:51:42.000000Z","updated_at":"2025-03-17T23:51:42.000000Z"},{"id":12387500,"change_date":"2025-01-21 21:40:00","inspection_id":"83664402","insp_unit_id":"204943877","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"18\/WHT","insp_unit_license":"4ST7491","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2537L2884219","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:42.000000Z","updated_at":"2025-03-17T23:51:42.000000Z"}]},{"id":7676995,"change_date":"2025-01-21 21:40:00","inspection_id":"83664670","dot_number":"3370817","report_state":"CA","report_number":"NCT2006588","insp_date":"2025-01-11 00:00:00","insp_start_time":"1958","insp_end_time":"2009","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"WALT'S","shipping_paper_number":"4500261380","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":null,"final_status_date":"2025-01-21 21:40: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":"15671334","transaction_code":"A","transaction_date":"2025-01-17 00:00:00","upload_date":"2025-01-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03370817","upload_search_indicator":null,"census_search_date":"2025-01-21 21:40:00","snet_input_date":"2025-01-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-01-21 21:40:00","insp_carrier_name":"ESTEEM FREIGHTWAYS LLC","insp_carrier_street":"10024 MOUNT BLANC LN","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95219","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:57:29.000000Z","updated_at":"2025-03-17T20:57:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12387905,"change_date":"2025-01-21 21:40:00","inspection_id":"83664670","insp_unit_id":"204944286","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"681\/GRY","insp_unit_license":"ZP16762","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X3LJ359103","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:42.000000Z","updated_at":"2025-03-17T23:51:42.000000Z"},{"id":12387906,"change_date":"2025-01-21 21:40:00","inspection_id":"83664670","insp_unit_id":"204944287","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"18\/WHT","insp_unit_license":"4ST7491","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2537L2884219","insp_unit_decal":"Y","insp_unit_decal_number":"34754960","created_at":"2025-03-17T23:51:42.000000Z","updated_at":"2025-03-17T23:51:42.000000Z"}]},{"id":7578115,"change_date":"2025-01-09 21:39:00","inspection_id":"83560789","dot_number":"3370817","report_state":"WA","report_number":"X836000735","insp_date":"2025-01-07 00:00:00","insp_start_time":"1248","insp_end_time":"1317","registration_date":null,"region":"PS","ci_status_code":"C","location":null,"location_desc":"ELLENSBURG WA","county_code_state":"WA","county_code":"037","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","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":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-01-09 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"94000","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":"1228009","transaction_code":"A","transaction_date":"2025-01-09 00:00:00","upload_date":"2025-01-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03370817","upload_search_indicator":null,"census_search_date":"2025-01-09 21:39:00","snet_input_date":"2025-01-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-09 21:39:00","insp_carrier_name":"ESTEEM FREIGHTWAYS LLC","insp_carrier_street":"10024 MOUNT BLANC LN","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95219","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:55:19.000000Z","updated_at":"2025-03-17T20:55:19.000000Z","inspection_violations":[{"id":11846647,"change_date":"2025-01-09 21:39:00","inspection_id":"83560789","insp_violation_id":"263830116","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"204718309","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:44.000000Z","updated_at":"2025-03-17T22:03:44.000000Z","normalized_code":"39617CPI"},{"id":11846648,"change_date":"2025-01-09 21:39:00","inspection_id":"83560789","insp_violation_id":"263830117","seq_no":"2","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"204718310","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:44.000000Z","updated_at":"2025-03-17T22:03:44.000000Z","normalized_code":"39617CPI"},{"id":11846649,"change_date":"2025-01-09 21:39:00","inspection_id":"83560789","insp_violation_id":"263830118","seq_no":"3","part_no":"392","part_no_section":"2-SLLCP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"5A0085373","created_at":"2025-03-17T22:03:44.000000Z","updated_at":"2025-03-17T22:03:44.000000Z","normalized_code":"3922SLLCP"}],"inspection_per_units":[{"id":12227148,"change_date":"2025-01-09 21:39:00","inspection_id":"83560789","insp_unit_id":"204718309","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"ZP16762","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X3LJ359103","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:58.000000Z","updated_at":"2025-03-17T23:49:58.000000Z"},{"id":12227149,"change_date":"2025-01-09 21:39:00","inspection_id":"83560789","insp_unit_id":"204718310","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNKNOWN","insp_unit_company":null,"insp_unit_license":"4ST7491","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2537L2884219","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:58.000000Z","updated_at":"2025-03-17T23:49:58.000000Z"}]},{"id":7046319,"change_date":"2024-10-25 21:40:00","inspection_id":"83000018","dot_number":"3370817","report_state":"WA","report_number":"2116000799","insp_date":"2024-10-24 00:00:00","insp_start_time":"2150","insp_end_time":"0007","registration_date":null,"region":"PD","ci_status_code":"C","location":"X861","location_desc":"RIDGEFIELD WA","county_code_state":"WA","county_code":"011","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"UNITED STATES COLD STORAGE OF CALIFORNIA","shipping_paper_number":"68360","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-10-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","viol_total":"12","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"986311","transaction_code":"A","transaction_date":"2024-10-25 00:00:00","upload_date":"2024-10-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03370817","upload_search_indicator":null,"census_search_date":"2024-10-25 21:40:00","snet_input_date":"2024-10-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-25 21:40:00","insp_carrier_name":"ESTEEM FREIGHTWAYS LLC","insp_carrier_street":"10024 MOUNT BLANC LN","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95219","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:43:00.000000Z","updated_at":"2025-03-17T20:43:00.000000Z","inspection_violations":[{"id":10997675,"change_date":"2024-10-25 21:40:00","inspection_id":"83000018","insp_violation_id":"262558474","seq_no":"1","part_no":"393","part_no_section":"55E-B","insp_viol_unit":"2","insp_unit_id":"203587903","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:18.000000Z","updated_at":"2025-03-17T21:59:18.000000Z","normalized_code":"39355EB"},{"id":10997676,"change_date":"2024-10-25 21:40:00","inspection_id":"83000018","insp_violation_id":"262558475","seq_no":"2","part_no":"396","part_no_section":"3A1-BALR","insp_viol_unit":"1","insp_unit_id":"203587902","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:59:18.000000Z","updated_at":"2025-03-17T21:59:18.000000Z","normalized_code":"3963A1BALR"},{"id":10997677,"change_date":"2024-10-25 21:40:00","inspection_id":"83000018","insp_violation_id":"262558476","seq_no":"3","part_no":"396","part_no_section":"3A1-F","insp_viol_unit":"1","insp_unit_id":"203587902","insp_violation_category_id":"18","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:59:18.000000Z","updated_at":"2025-03-17T21:59:18.000000Z","normalized_code":"3963A1F"},{"id":10997678,"change_date":"2024-10-25 21:40:00","inspection_id":"83000018","insp_violation_id":"262558477","seq_no":"4","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"203587902","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:18.000000Z","updated_at":"2025-03-17T21:59:18.000000Z","normalized_code":"3939ALFTSI"},{"id":10997679,"change_date":"2024-10-25 21:40:00","inspection_id":"83000018","insp_violation_id":"262558478","seq_no":"5","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"2","insp_unit_id":"203587903","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:18.000000Z","updated_at":"2025-03-17T21:59:18.000000Z","normalized_code":"3965BL"},{"id":10997680,"change_date":"2024-10-25 21:40:00","inspection_id":"83000018","insp_violation_id":"262558479","seq_no":"6","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"2","insp_unit_id":"203587903","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:18.000000Z","updated_at":"2025-03-17T21:59:18.000000Z","normalized_code":"39345B2BAIR"},{"id":10997681,"change_date":"2024-10-25 21:40:00","inspection_id":"83000018","insp_violation_id":"262558480","seq_no":"7","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"2","insp_unit_id":"203587903","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:18.000000Z","updated_at":"2025-03-17T21:59:18.000000Z","normalized_code":"39345B2BAIR"},{"id":10997682,"change_date":"2024-10-25 21:40:00","inspection_id":"83000018","insp_violation_id":"262558481","seq_no":"8","part_no":"393","part_no_section":"47D2-BLTBD","insp_viol_unit":"2","insp_unit_id":"203587903","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:18.000000Z","updated_at":"2025-03-17T21:59:18.000000Z","normalized_code":"39347D2BLTBD"},{"id":10997683,"change_date":"2024-10-25 21:40:00","inspection_id":"83000018","insp_violation_id":"262558482","seq_no":"9","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"203587902","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:18.000000Z","updated_at":"2025-03-17T21:59:18.000000Z","normalized_code":"39345DB"},{"id":10997684,"change_date":"2024-10-25 21:40:00","inspection_id":"83000018","insp_violation_id":"262558483","seq_no":"10","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"203587902","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:18.000000Z","updated_at":"2025-03-17T21:59:18.000000Z","normalized_code":"39378AWS"},{"id":10997685,"change_date":"2024-10-25 21:40:00","inspection_id":"83000018","insp_violation_id":"262558484","seq_no":"11","part_no":"395","part_no_section":"34A1-ELDDFN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:18.000000Z","updated_at":"2025-03-17T21:59:18.000000Z","normalized_code":"39534A1ELDDFN"},{"id":10997686,"change_date":"2024-10-25 21:40:00","inspection_id":"83000018","insp_violation_id":"262558485","seq_no":"12","part_no":"395","part_no_section":"8E1PC","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:59:18.000000Z","updated_at":"2025-03-17T21:59:18.000000Z","normalized_code":"3958E1PC"}],"inspection_per_units":[{"id":11364170,"change_date":"2024-10-25 21:40:00","inspection_id":"83000018","insp_unit_id":"203587902","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"681","insp_unit_license":"ZP16762","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X3LJ359103","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:39.000000Z","updated_at":"2025-03-17T23:40:39.000000Z"},{"id":11364171,"change_date":"2024-10-25 21:40:00","inspection_id":"83000018","insp_unit_id":"203587903","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"A18","insp_unit_license":"4ST7491","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2537L2884219","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:39.000000Z","updated_at":"2025-03-17T23:40:39.000000Z"}]},{"id":6835413,"change_date":"2024-09-27 21:40:00","inspection_id":"82775849","dot_number":"3370817","report_state":"OR","report_number":"AP36700190","insp_date":"2024-09-27 00:00:00","insp_start_time":"0851","insp_end_time":"0928","registration_date":null,"region":"PD","ci_status_code":"C","location":"30-06","location_desc":"UMATILLA OR","county_code_state":"OR","county_code":"059","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-09-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52350","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"892300","transaction_code":"A","transaction_date":"2024-09-27 00:00:00","upload_date":"2024-09-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03370817","upload_search_indicator":null,"census_search_date":"2024-09-27 21:40:00","snet_input_date":"2024-09-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-27 21:40:00","insp_carrier_name":"ESTEEM FREIGHTWAYS LLC","insp_carrier_street":"10024 MOUNT BLANC LN","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95219","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:38:38.000000Z","updated_at":"2025-03-17T20:38:38.000000Z","inspection_violations":[{"id":10646975,"change_date":"2024-09-27 21:40:00","inspection_id":"82775849","insp_violation_id":"262068848","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":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:34.000000Z","updated_at":"2025-03-17T21:57:34.000000Z","normalized_code":"3958A1"}],"inspection_per_units":[{"id":11023019,"change_date":"2024-09-27 21:40:00","inspection_id":"82775849","insp_unit_id":"203161084","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"681","insp_unit_license":"ZP16762","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X3LJ359103","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:09.000000Z","updated_at":"2025-03-17T23:37:09.000000Z"},{"id":11023020,"change_date":"2024-09-27 21:40:00","inspection_id":"82775849","insp_unit_id":"203161085","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"4599 WHI","insp_unit_license":"4TW2881","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2536N2419806","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:09.000000Z","updated_at":"2025-03-17T23:37:09.000000Z"}]},{"id":6833030,"change_date":"2026-02-25 21:48:00","inspection_id":"82773303","dot_number":"3370817","report_state":"WA","report_number":"2124000182","insp_date":"2024-09-25 00:00:00","insp_start_time":"1036","insp_end_time":"1130","registration_date":null,"region":"PD","ci_status_code":"C","location":null,"location_desc":"KITTITAS WA","county_code_state":"WA","county_code":"037","insp_level_id":"2","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-09-27 21:39:00","post_acc_ind":"Y","gross_comb_veh_wt":"118200","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":"889721","transaction_code":"C","transaction_date":"2024-09-27 00:00:00","upload_date":"2026-02-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03370817","upload_search_indicator":null,"census_search_date":"2024-09-27 21:39:00","snet_input_date":"2024-09-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-27 21:39:00","insp_carrier_name":"ESTEEM FREIGHTWAYS LLC","insp_carrier_street":"10024 MOUNT BLANC LN","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95219","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:38:37.000000Z","updated_at":"2026-03-08T09:31:29.000000Z","inspection_violations":[{"id":18839598,"change_date":"2026-02-25 21:48:00","inspection_id":"82773303","insp_violation_id":"272018974","seq_no":"1","part_no":"393","part_no_section":"11A1-LLPL","insp_viol_unit":"2","insp_unit_id":"211821593","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-28T10:56:36.000000Z","updated_at":"2026-03-08T09:48:52.000000Z","normalized_code":"39311A1LLPL"},{"id":18839599,"change_date":"2026-02-25 21:48:00","inspection_id":"82773303","insp_violation_id":"272018975","seq_no":"2","part_no":"393","part_no_section":"11A1-LRLM","insp_viol_unit":"1","insp_unit_id":"211821592","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-28T10:56:36.000000Z","updated_at":"2026-03-08T09:48:52.000000Z","normalized_code":"39311A1LRLM"},{"id":18839600,"change_date":"2026-02-25 21:48:00","inspection_id":"82773303","insp_violation_id":"272018976","seq_no":"3","part_no":"395","part_no_section":"3A3II","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-02-28T10:56:36.000000Z","updated_at":"2026-03-08T09:48:52.000000Z","normalized_code":"3953A3II"}],"inspection_per_units":[{"id":19190056,"change_date":"2026-02-25 21:48:00","inspection_id":"82773303","insp_unit_id":"211821592","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"680","insp_unit_license":"YP77341","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49XXPJ265211","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-28T10:15:20.000000Z","updated_at":"2026-03-08T09:07:08.000000Z"},{"id":19190057,"change_date":"2026-02-25 21:48:00","inspection_id":"82773303","insp_unit_id":"211821593","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIG TEX","insp_unit_company":"45","insp_unit_license":"4TW4881","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"16V1F3023M2098316","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-28T10:15:20.000000Z","updated_at":"2026-03-08T09:07:08.000000Z"}]},{"id":6821418,"change_date":"2024-09-25 21:42:00","inspection_id":"82761084","dot_number":"3370817","report_state":"CA","report_number":"UDL9003080","insp_date":"2024-09-24 00:00:00","insp_start_time":"0923","insp_end_time":"0931","registration_date":null,"region":"PT","ci_status_code":"C","location":"131","location_desc":"COTTONWOOD IF","county_code_state":"CA","county_code":"103","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"TRINIDAD BENHAM CORP","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-09-25 21:42: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":"15533635","transaction_code":"A","transaction_date":"2024-09-24 00:00:00","upload_date":"2024-09-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03370817","upload_search_indicator":null,"census_search_date":"2024-09-25 21:42:00","snet_input_date":"2024-09-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-09-25 21:42:00","insp_carrier_name":"ESTEEM FREIGHTWAYS LLC","insp_carrier_street":"10024 MOUNT BLANC LN","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95219","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:38:33.000000Z","updated_at":"2025-03-17T20:38:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11000267,"change_date":"2024-09-25 21:42:00","inspection_id":"82761084","insp_unit_id":"203134123","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"680 BLU","insp_unit_license":"YP77343","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X8PJ163602","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:57.000000Z","updated_at":"2025-03-17T23:36:57.000000Z"},{"id":11000268,"change_date":"2024-09-25 21:42:00","inspection_id":"82761084","insp_unit_id":"203134124","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"4599 WHI","insp_unit_license":"4TW2881","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2536N2419806","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:57.000000Z","updated_at":"2025-03-17T23:36:57.000000Z"}]},{"id":6800773,"change_date":"2024-09-23 21:41:00","inspection_id":"82739174","dot_number":"3370817","report_state":"CA","report_number":"UEA3000436","insp_date":"2024-09-20 00:00:00","insp_start_time":"1840","insp_end_time":"1849","registration_date":null,"region":"PT","ci_status_code":"C","location":"131","location_desc":"COTTONWOOD IF","county_code_state":"CA","county_code":"103","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"WELCOME MARKET","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-09-23 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":"15530149","transaction_code":"A","transaction_date":"2024-09-20 00:00:00","upload_date":"2024-09-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03370817","upload_search_indicator":null,"census_search_date":"2024-09-23 21:41:00","snet_input_date":"2024-09-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-09-23 21:41:00","insp_carrier_name":"ESTEEM FREIGHTWAYS LLC","insp_carrier_street":"10024 MOUNT BLANC LN","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95219","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:38:09.000000Z","updated_at":"2025-03-17T20:38:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10966878,"change_date":"2024-09-23 21:41:00","inspection_id":"82739174","insp_unit_id":"203091906","insp_unit_type_id":"9","insp_unit_number":"1","insp_unit_make":"UTIL","insp_unit_company":"WHT","insp_unit_license":"4ST7491","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2537L2884219","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:36.000000Z","updated_at":"2025-03-17T23:36:36.000000Z"},{"id":10966879,"change_date":"2024-09-23 21:41:00","inspection_id":"82739174","insp_unit_id":"203091907","insp_unit_type_id":"11","insp_unit_number":"2","insp_unit_make":"KW","insp_unit_company":"681\/SIL","insp_unit_license":"ZP16762","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X3LJ359103","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:36.000000Z","updated_at":"2025-03-17T23:36:36.000000Z"}]},{"id":6649418,"change_date":"2024-09-04 21:43:00","inspection_id":"82577821","dot_number":"3370817","report_state":"CA","report_number":"NF8R000324","insp_date":"2024-09-03 00:00:00","insp_start_time":"2154","insp_end_time":"2230","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CIRCLE MARKET","shipping_paper_number":"CC78162","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":null,"final_status_date":"2024-09-04 21:43: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":"15509822","transaction_code":"A","transaction_date":"2024-09-03 00:00:00","upload_date":"2024-09-04 00:00:00","upload_first_byte":"0","upload_dot_number":"03370817","upload_search_indicator":null,"census_search_date":"2024-09-04 21:43:00","snet_input_date":"2024-09-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-09-04 21:43:00","insp_carrier_name":"ESTEEM FREIGHTWAYS LLC","insp_carrier_street":"10024 MOUNT BLANC LN","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95219","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:34:51.000000Z","updated_at":"2025-03-17T20:34:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10720665,"change_date":"2024-09-04 21:43:00","inspection_id":"82577821","insp_unit_id":"202762992","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"681","insp_unit_license":"ZP16762","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X3LJ359103","insp_unit_decal":"Y","insp_unit_decal_number":"34212725","created_at":"2025-03-17T23:34:02.000000Z","updated_at":"2025-03-17T23:34:02.000000Z"},{"id":10720666,"change_date":"2024-09-04 21:43:00","inspection_id":"82577821","insp_unit_id":"202762993","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"18","insp_unit_license":"4ST7491","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2537L2884219","insp_unit_decal":"Y","insp_unit_decal_number":"34212726","created_at":"2025-03-17T23:34:02.000000Z","updated_at":"2025-03-17T23:34:02.000000Z"}]},{"id":6661490,"change_date":"2024-09-05 21:43:00","inspection_id":"82590646","dot_number":"3370817","report_state":"CA","report_number":"UF5T001078","insp_date":"2024-08-30 00:00:00","insp_start_time":"2215","insp_end_time":"2227","registration_date":null,"region":"PT","ci_status_code":"C","location":"424","location_desc":"GRAPEVINE IF","county_code_state":"CA","county_code":"029","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"KISKA FARMS","shipping_paper_number":"186567","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-05 21:43: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":"15511523","transaction_code":"A","transaction_date":"2024-08-30 00:00:00","upload_date":"2024-09-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03370817","upload_search_indicator":null,"census_search_date":"2024-09-05 21:43:00","snet_input_date":"2024-08-30 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-09-05 21:43:00","insp_carrier_name":"ESTEEM FREIGHTWAYS LLC","insp_carrier_street":"10024 MOUNT BLANC LN","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95219","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"557430","created_at":"2025-03-17T20:35:11.000000Z","updated_at":"2025-03-17T20:35:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10740238,"change_date":"2024-09-05 21:43:00","inspection_id":"82590646","insp_unit_id":"202788779","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"680","insp_unit_license":"YP77341","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49XXPJ265211","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:14.000000Z","updated_at":"2025-03-17T23:34:14.000000Z"},{"id":10740239,"change_date":"2024-09-05 21:43:00","inspection_id":"82590646","insp_unit_id":"202788780","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"4599","insp_unit_license":"4TW2881","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2536N2419806","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:14.000000Z","updated_at":"2025-03-17T23:34:14.000000Z"}]},{"id":6493910,"change_date":"2024-08-17 21:32:00","inspection_id":"82412184","dot_number":"3370817","report_state":"OR","report_number":"AP43760149","insp_date":"2024-08-16 00:00:00","insp_start_time":"1930","insp_end_time":"2036","registration_date":null,"region":"PD","ci_status_code":"C","location":"15-06","location_desc":"ASHLAND  OR","county_code_state":"OR","county_code":"029","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"BREW DR. KOMBUCHA","shipping_paper_number":"52827401LN","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-08-17 21:32:00","post_acc_ind":"N","gross_comb_veh_wt":"118200","viol_total":"4","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":"752637","transaction_code":"A","transaction_date":"2024-08-16 00:00:00","upload_date":"2024-08-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03370817","upload_search_indicator":null,"census_search_date":"2024-08-17 21:32:00","snet_input_date":"2024-08-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-17 21:32:00","insp_carrier_name":"ESTEEM FREIGHTWAYS LLC","insp_carrier_street":"10024 MOUNT BLANC LN","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95219","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:31:36.000000Z","updated_at":"2025-03-17T20:31:36.000000Z","inspection_violations":[{"id":10083947,"change_date":"2024-08-17 21:32:00","inspection_id":"82412184","insp_violation_id":"261246997","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:54:48.000000Z","updated_at":"2025-03-17T21:54:48.000000Z","normalized_code":"3958E1"},{"id":10083948,"change_date":"2024-08-17 21:32:00","inspection_id":"82412184","insp_violation_id":"261246998","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:54:48.000000Z","updated_at":"2025-03-17T21:54:48.000000Z","normalized_code":"3958E1"},{"id":10083949,"change_date":"2024-08-17 21:32:00","inspection_id":"82412184","insp_violation_id":"261246999","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":null,"created_at":"2025-03-17T21:54:48.000000Z","updated_at":"2025-03-17T21:54:48.000000Z","normalized_code":"3958E1"},{"id":10083950,"change_date":"2024-08-17 21:32:00","inspection_id":"82412184","insp_violation_id":"261247000","seq_no":"4","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:54:48.000000Z","updated_at":"2025-03-17T21:54:48.000000Z","normalized_code":"3958E1"}],"inspection_per_units":[{"id":10467868,"change_date":"2024-08-17 21:32:00","inspection_id":"82412184","insp_unit_id":"202445545","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"680","insp_unit_license":"YP77341","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49XXPJ265211","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:26.000000Z","updated_at":"2025-03-17T23:31:26.000000Z"},{"id":10467869,"change_date":"2024-08-17 21:32:00","inspection_id":"82412184","insp_unit_id":"202445546","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"18","insp_unit_license":"4ST7491","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2537L2884219","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:26.000000Z","updated_at":"2025-03-17T23:31:26.000000Z"}]},{"id":6254541,"change_date":"2024-07-18 21:41:00","inspection_id":"82156201","dot_number":"3370817","report_state":"CA","report_number":"UDL9002966","insp_date":"2024-07-16 00:00:00","insp_start_time":"1505","insp_end_time":"1514","registration_date":null,"region":"PT","ci_status_code":"C","location":"131","location_desc":"COTTONWOOD IF","county_code_state":"CA","county_code":"103","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-18 21:41: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":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15445189","transaction_code":"A","transaction_date":"2024-07-16 00:00:00","upload_date":"2024-07-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03370817","upload_search_indicator":null,"census_search_date":"2024-07-18 21:41:00","snet_input_date":"2024-07-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-07-18 21:41:00","insp_carrier_name":"ESTEEM FREIGHTWAYS LLC","insp_carrier_street":"10024 MOUNT BLANC LN","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95219","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:26:39.000000Z","updated_at":"2025-03-17T20:26:39.000000Z","inspection_violations":[{"id":9715950,"change_date":"2024-07-18 21:41:00","inspection_id":"82156201","insp_violation_id":"260722845","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"201958664","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:53:00.000000Z","updated_at":"2025-03-17T21:53:00.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10077517,"change_date":"2024-07-18 21:41:00","inspection_id":"82156201","insp_unit_id":"201958663","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"681 SIL","insp_unit_license":"ZP16762","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X3LJ359103","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:26.000000Z","updated_at":"2025-03-17T23:27:26.000000Z"},{"id":10077518,"change_date":"2024-07-18 21:41:00","inspection_id":"82156201","insp_unit_id":"201958664","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"18 WHI","insp_unit_license":"4ST7491","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2537L2884219","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:26.000000Z","updated_at":"2025-03-17T23:27:26.000000Z"}]},{"id":6013941,"change_date":"2025-06-21 21:34:00","inspection_id":"81897480","dot_number":"3370817","report_state":"AZ","report_number":"1003800286","insp_date":"2024-06-12 00:00:00","insp_start_time":"0802","insp_end_time":"0835","registration_date":null,"region":"MS","ci_status_code":"C","location":null,"location_desc":"BUCKEYE AZ","county_code_state":"AZ","county_code":"013","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-18 21:42: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":"578751","transaction_code":"C","transaction_date":"2024-06-18 00:00:00","upload_date":"2025-06-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03370817","upload_search_indicator":null,"census_search_date":"2024-06-18 21:42:00","snet_input_date":"2024-06-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-06-18 21:42:00","insp_carrier_name":"ESTEEM FREIGHTWAYS LLC","insp_carrier_street":"10024 MOUNT BLANC LN","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95219","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:21:53.000000Z","updated_at":"2025-06-25T10:00:04.000000Z","inspection_violations":[{"id":14364655,"change_date":"2025-06-21 21:34:00","inspection_id":"81897480","insp_violation_id":"266955763","seq_no":"1","part_no":"392","part_no_section":"2-SLLCP","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-06-24T10:15:53.000000Z","updated_at":"2025-06-25T10:15:04.000000Z","normalized_code":"3922SLLCP"}],"inspection_per_units":[{"id":14665146,"change_date":"2025-06-21 21:34:00","inspection_id":"81897480","insp_unit_id":"207481451","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"680","insp_unit_license":"YP77341","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49XXPJ265211","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-24T09:45:45.000000Z","updated_at":"2025-06-25T09:45:03.000000Z"},{"id":14665147,"change_date":"2025-06-21 21:34:00","inspection_id":"81897480","insp_unit_id":"207481452","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"45","insp_unit_license":"4TW288A","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2536N2419806","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-24T09:45:45.000000Z","updated_at":"2025-06-25T09:45:03.000000Z"}]},{"id":5711280,"change_date":"2024-05-09 21:42:00","inspection_id":"81569153","dot_number":"3370817","report_state":"OR","report_number":"AASF008189","insp_date":"2024-05-08 00:00:00","insp_start_time":"1925","insp_end_time":"2008","registration_date":null,"region":"PT","ci_status_code":"C","location":"3005","location_desc":"EMIGRANT HILL - 18 MI E PENDLE","county_code_state":"OR","county_code":"059","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"CANAM FRESH","shipping_paper_number":"216905","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":"2024-05-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"53200","viol_total":"3","oos_total":"2","driver_viol_total":"3","driver_oos_total":"2","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1248364","transaction_code":"A","transaction_date":"2024-05-08 00:00:00","upload_date":"2024-05-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03370817","upload_search_indicator":null,"census_search_date":"2024-05-09 21:42:00","snet_input_date":"2024-05-09 00:00:00","source_office":"4ORS001","mcmis_add_date":"2024-05-09 21:42:00","insp_carrier_name":"ESTEEM FREIGHTWAYS LLC","insp_carrier_street":"10024 MOUNT BLANC LN","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95219","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"273145","created_at":"2025-03-17T20:15:54.000000Z","updated_at":"2025-03-17T20:15:54.000000Z","inspection_violations":[{"id":8835076,"change_date":"2024-05-09 21:42:00","inspection_id":"81569153","insp_violation_id":"259411945","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:48:43.000000Z","updated_at":"2025-03-17T21:48:43.000000Z","normalized_code":"3958E1"},{"id":8835077,"change_date":"2024-05-09 21:42:00","inspection_id":"81569153","insp_violation_id":"259411946","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":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:43.000000Z","updated_at":"2025-03-17T21:48:43.000000Z","normalized_code":"3958E1"},{"id":8835078,"change_date":"2024-05-09 21:42:00","inspection_id":"81569153","insp_violation_id":"259411947","seq_no":"3","part_no":"395","part_no_section":"3(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:43.000000Z","updated_at":"2025-03-17T21:48:43.000000Z","normalized_code":"3953A2"}],"inspection_per_units":[{"id":9199023,"change_date":"2024-05-09 21:42:00","inspection_id":"81569153","insp_unit_id":"200815623","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"680","insp_unit_license":"YP77341","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49XXPJ265211","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:36.000000Z","updated_at":"2025-03-17T23:18:36.000000Z"},{"id":9199024,"change_date":"2024-05-09 21:42:00","inspection_id":"81569153","insp_unit_id":"200815624","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"A18","insp_unit_license":"4ST7491","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":null,"insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:36.000000Z","updated_at":"2025-03-17T23:18:36.000000Z"}]},{"id":5108786,"change_date":"2024-02-22 21:41:00","inspection_id":"80912149","dot_number":"3370817","report_state":"WA","report_number":"2116000211","insp_date":"2024-02-20 00:00:00","insp_start_time":"2130","insp_end_time":"2206","registration_date":null,"region":"PS","ci_status_code":"C","location":null,"location_desc":"RIDGEFIELD WA","county_code_state":"WA","county_code":"011","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"COSTCO WHOLESALE","shipping_paper_number":"S17818","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-02-22 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":"261956","transaction_code":"A","transaction_date":"2024-02-22 00:00:00","upload_date":"2024-02-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03370817","upload_search_indicator":null,"census_search_date":"2024-02-22 21:41:00","snet_input_date":"2024-02-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-02-22 21:41:00","insp_carrier_name":"ESTEEM FREIGHTWAYS LLC","insp_carrier_street":"10024 MOUNT BLANC LN","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95219","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:03:49.000000Z","updated_at":"2025-03-17T20:03:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8224977,"change_date":"2024-02-22 21:41:00","inspection_id":"80912149","insp_unit_id":"199540843","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"1611","insp_unit_license":"XP39832","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLD56GLHA6462","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:31.000000Z","updated_at":"2025-03-17T23:09:31.000000Z"},{"id":8224978,"change_date":"2024-02-22 21:41:00","inspection_id":"80912149","insp_unit_id":"199540844","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"1649","insp_unit_license":"4SL5916","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2530K3699714","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:31.000000Z","updated_at":"2025-03-17T23:09:31.000000Z"}]},{"id":5183628,"change_date":"2024-02-29 21:48:00","inspection_id":"80993496","dot_number":"3370817","report_state":"CA","report_number":"N92M005558","insp_date":"2024-02-17 00:00:00","insp_start_time":"0944","insp_end_time":"0959","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ANDERSON ORGANICS","shipping_paper_number":"33427","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":null,"final_status_date":"2024-02-29 21:48: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":"15262292","transaction_code":"A","transaction_date":"2024-02-28 00:00:00","upload_date":"2024-02-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03370817","upload_search_indicator":null,"census_search_date":"2024-02-29 21:48:00","snet_input_date":"2024-02-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-02-29 21:48:00","insp_carrier_name":"ESTEEM FREIGHTWAYS LLC","insp_carrier_street":"10024 MOUNT BLANC LN","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95219","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:05:19.000000Z","updated_at":"2025-03-17T20:05:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8346463,"change_date":"2024-02-29 21:48:00","inspection_id":"80993496","insp_unit_id":"199698766","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"GRY\/681","insp_unit_license":"ZP16762","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X3LJ359103","insp_unit_decal":"Y","insp_unit_decal_number":"33507262","created_at":"2025-03-17T23:10:37.000000Z","updated_at":"2025-03-17T23:10:37.000000Z"},{"id":8346464,"change_date":"2024-02-29 21:48:00","inspection_id":"80993496","insp_unit_id":"199698767","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"WHT\/681A","insp_unit_license":"4ST7491","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2537L2884219","insp_unit_decal":"Y","insp_unit_decal_number":"33507263","created_at":"2025-03-17T23:10:37.000000Z","updated_at":"2025-03-17T23:10:37.000000Z"}]},{"id":5013294,"change_date":"2024-02-08 21:44:00","inspection_id":"80807922","dot_number":"3370817","report_state":"CA","report_number":"NEL1002274","insp_date":"2024-02-07 00:00:00","insp_start_time":"1321","insp_end_time":"1401","registration_date":null,"region":"PT","ci_status_code":"C","location":"131","location_desc":"COTTONWOOD IF","county_code_state":"CA","county_code":"103","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"WINNERAM INTERNATIONAL","shipping_paper_number":"287564","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-08 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":"15229092","transaction_code":"A","transaction_date":"2024-02-07 00:00:00","upload_date":"2024-02-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03370817","upload_search_indicator":null,"census_search_date":"2024-02-08 21:44:00","snet_input_date":"2024-02-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-02-08 21:44:00","insp_carrier_name":"ESTEEM FREIGHTWAYS LLC","insp_carrier_street":"10024 MOUNT BLANC LN","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95219","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:02:03.000000Z","updated_at":"2025-03-17T20:02:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8068963,"change_date":"2024-02-08 21:44:00","inspection_id":"80807922","insp_unit_id":"199344075","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1611\/WHT","insp_unit_license":"XP39832","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLD56GLHA6462","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:07.000000Z","updated_at":"2025-03-17T23:08:07.000000Z"},{"id":8068964,"change_date":"2024-02-08 21:44:00","inspection_id":"80807922","insp_unit_id":"199344076","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"1649\/WHT","insp_unit_license":"4SL5916","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2530K3699714","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:07.000000Z","updated_at":"2025-03-17T23:08:07.000000Z"}]},{"id":4904606,"change_date":"2024-03-25 21:41:00","inspection_id":"80688879","dot_number":"3370817","report_state":"CA","report_number":"NCNK006941","insp_date":"2024-01-22 00:00:00","insp_start_time":"1906","insp_end_time":"2036","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"VENTURA COASTAL","shipping_paper_number":"102515","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":null,"final_status_date":"2024-01-25 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"6","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15213279","transaction_code":"C","transaction_date":"2024-03-25 00:00:00","upload_date":"2024-03-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03370817","upload_search_indicator":null,"census_search_date":"2024-01-25 21:44:00","snet_input_date":"2024-01-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-01-25 21:44:00","insp_carrier_name":"ESTEEM FREIGHTWAYS LLC","insp_carrier_street":"10024 MOUNT BLANC LN","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95219","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"557430","created_at":"2025-03-17T20:00:00.000000Z","updated_at":"2025-03-17T20:00:00.000000Z","inspection_violations":[{"id":7557231,"change_date":"2024-03-25 21:41:00","inspection_id":"80688879","insp_violation_id":"258571214","seq_no":"1","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"200076741","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:25.000000Z","updated_at":"2025-03-17T21:42:25.000000Z","normalized_code":"39355E"},{"id":7557232,"change_date":"2024-03-25 21:41:00","inspection_id":"80688879","insp_violation_id":"258571215","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"200076741","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:25.000000Z","updated_at":"2025-03-17T21:42:25.000000Z","normalized_code":"39347E"},{"id":7557233,"change_date":"2024-03-25 21:41:00","inspection_id":"80688879","insp_violation_id":"258571216","seq_no":"3","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"200076741","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:25.000000Z","updated_at":"2025-03-17T21:42:25.000000Z","normalized_code":"39353B"},{"id":7557234,"change_date":"2024-03-25 21:41:00","inspection_id":"80688879","insp_violation_id":"258571217","seq_no":"4","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"200076741","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:25.000000Z","updated_at":"2025-03-17T21:42:25.000000Z","normalized_code":"39347E"},{"id":7557235,"change_date":"2024-03-25 21:41:00","inspection_id":"80688879","insp_violation_id":"258571218","seq_no":"5","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"200076741","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:25.000000Z","updated_at":"2025-03-17T21:42:25.000000Z","normalized_code":"39348A"},{"id":7557236,"change_date":"2024-03-25 21:41:00","inspection_id":"80688879","insp_violation_id":"258571219","seq_no":"6","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"200076741","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA247623","created_at":"2025-03-17T21:42:25.000000Z","updated_at":"2025-03-17T21:42:25.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":7892273,"change_date":"2024-03-25 21:41:00","inspection_id":"80688879","insp_unit_id":"200076740","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"BLU\/680","insp_unit_license":"YP77341","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49XXPJ265211","insp_unit_decal":"Y","insp_unit_decal_number":"33534137","created_at":"2025-03-17T23:06:32.000000Z","updated_at":"2025-03-17T23:06:32.000000Z"},{"id":7892274,"change_date":"2024-03-25 21:41:00","inspection_id":"80688879","insp_unit_id":"200076741","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"WHT\/4599","insp_unit_license":"4TW2881","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2536N2419806","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:32.000000Z","updated_at":"2025-03-17T23:06:32.000000Z"}]},{"id":4501605,"change_date":"2023-11-27 21:43:00","inspection_id":"80247579","dot_number":"3370817","report_state":"CA","report_number":"UECE005414","insp_date":"2023-11-26 00:00:00","insp_start_time":"1050","insp_end_time":"1115","registration_date":null,"region":"PT","ci_status_code":"C","location":"252","location_desc":"I-5 N\/B SOF FLORIN","county_code_state":"CA","county_code":"067","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BOILING POINT RESTAURANT","shipping_paper_number":"12443393","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":"2023-11-27 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"15144847","transaction_code":"A","transaction_date":"2023-11-26 00:00:00","upload_date":"2023-11-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03370817","upload_search_indicator":null,"census_search_date":"2023-11-27 21:43:00","snet_input_date":"2023-11-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-11-27 21:43:00","insp_carrier_name":"ESTEEM FREIGHTWAYS LLC","insp_carrier_street":"10024 MOUNT BLANC LN","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95219","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"557430","created_at":"2025-03-17T19:52:09.000000Z","updated_at":"2025-03-17T19:52:09.000000Z","inspection_violations":[{"id":6968136,"change_date":"2023-11-27 21:43:00","inspection_id":"80247579","insp_violation_id":"256581928","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":"MC60883","created_at":"2025-03-17T21:39:38.000000Z","updated_at":"2025-03-17T21:39:38.000000Z","normalized_code":"3922"},{"id":6968137,"change_date":"2023-11-27 21:43:00","inspection_id":"80247579","insp_violation_id":"256581929","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"49","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"MC60883","created_at":"2025-03-17T21:39:38.000000Z","updated_at":"2025-03-17T21:39:38.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7240152,"change_date":"2023-11-27 21:43:00","inspection_id":"80247579","insp_unit_id":"198229290","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"YP77341","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49XXPJ265211","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:50.000000Z","updated_at":"2025-03-17T23:00:50.000000Z"},{"id":7240153,"change_date":"2023-11-27 21:43:00","inspection_id":"80247579","insp_unit_id":"198229291","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"4TW2881","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2536N2419806","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:50.000000Z","updated_at":"2025-03-17T23:00:50.000000Z"}]},{"id":3849919,"change_date":"2023-08-28 21:43:00","inspection_id":"79525900","dot_number":"3370817","report_state":"CA","report_number":"NC0J004800","insp_date":"2023-08-15 00:00:00","insp_start_time":"1644","insp_end_time":"1703","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"TSW NURSERY","shipping_paper_number":"22073","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":null,"final_status_date":"2023-08-28 21:43: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":"15039689","transaction_code":"A","transaction_date":"2023-08-25 00:00:00","upload_date":"2023-08-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03370817","upload_search_indicator":null,"census_search_date":"2023-08-28 21:43:00","snet_input_date":"2023-08-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-28 21:43:00","insp_carrier_name":"ESTEEM FREIGHTWAYS LLC","insp_carrier_street":"968 WOODRIDGE CT","insp_carrier_city":"YUBA CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"95993","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:56.000000Z","updated_at":"2025-03-17T19:38:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6190191,"change_date":"2023-08-28 21:43:00","inspection_id":"79525900","insp_unit_id":"196770794","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"680\/BLU","insp_unit_license":"YP77341","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49XXPJ265211","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:01.000000Z","updated_at":"2025-03-17T22:52:01.000000Z"},{"id":6190192,"change_date":"2023-08-28 21:43:00","inspection_id":"79525900","insp_unit_id":"196770795","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"4599\/WHT","insp_unit_license":"4TW2881","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2536N2419806","insp_unit_decal":"Y","insp_unit_decal_number":"32836462","created_at":"2025-03-17T22:52:01.000000Z","updated_at":"2025-03-17T22:52:01.000000Z"}]},{"id":3851227,"change_date":"2023-08-28 21:43:00","inspection_id":"79527284","dot_number":"3370817","report_state":"CA","report_number":"NDZX001703","insp_date":"2023-08-15 00:00:00","insp_start_time":"1555","insp_end_time":"1627","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"TSW NURSERY","shipping_paper_number":"22073","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":null,"final_status_date":"2023-08-28 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"15038092","transaction_code":"A","transaction_date":"2023-08-25 00:00:00","upload_date":"2023-08-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03370817","upload_search_indicator":null,"census_search_date":"2023-08-28 21:43:00","snet_input_date":"2023-08-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-28 21:43:00","insp_carrier_name":"ESTEEM FREIGHTWAYS LLC","insp_carrier_street":"968 WOODRIDGE CT","insp_carrier_city":"YUBA CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"95993","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:56.000000Z","updated_at":"2025-03-17T19:38:56.000000Z","inspection_violations":[{"id":5949538,"change_date":"2023-08-28 21:43:00","inspection_id":"79527284","insp_violation_id":"254936650","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"196773011","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:48.000000Z","updated_at":"2025-03-17T21:34:48.000000Z","normalized_code":"3963A1"},{"id":5949539,"change_date":"2023-08-28 21:43:00","inspection_id":"79527284","insp_violation_id":"254936651","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"196773011","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:48.000000Z","updated_at":"2025-03-17T21:34:48.000000Z","normalized_code":"39347E"},{"id":5949540,"change_date":"2023-08-28 21:43:00","inspection_id":"79527284","insp_violation_id":"254936652","seq_no":"3","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"196773011","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:48.000000Z","updated_at":"2025-03-17T21:34:48.000000Z","normalized_code":"39353B"},{"id":5949541,"change_date":"2023-08-28 21:43:00","inspection_id":"79527284","insp_violation_id":"254936653","seq_no":"4","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"196773011","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:48.000000Z","updated_at":"2025-03-17T21:34:48.000000Z","normalized_code":"39347E"},{"id":5949542,"change_date":"2023-08-28 21:43:00","inspection_id":"79527284","insp_violation_id":"254936654","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"196773011","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA302782","created_at":"2025-03-17T21:34:48.000000Z","updated_at":"2025-03-17T21:34:48.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":6192211,"change_date":"2023-08-28 21:43:00","inspection_id":"79527284","insp_unit_id":"196773010","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"580\/BLU","insp_unit_license":"YP77341","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49XXPJ265211","insp_unit_decal":"Y","insp_unit_decal_number":"32835406","created_at":"2025-03-17T22:52:02.000000Z","updated_at":"2025-03-17T22:52:02.000000Z"},{"id":6192212,"change_date":"2023-08-28 21:43:00","inspection_id":"79527284","insp_unit_id":"196773011","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"4599\/WHT","insp_unit_license":"4TW2881","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2536N2419806","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:02.000000Z","updated_at":"2025-03-17T22:52:02.000000Z"}]},{"id":3369967,"change_date":"2023-06-26 21:41:00","inspection_id":"78987896","dot_number":"3370817","report_state":"CA","report_number":"NCU6002520","insp_date":"2023-05-19 00:00:00","insp_start_time":"1135","insp_end_time":"1153","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"NA","shipping_paper_number":"150968","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":null,"final_status_date":"2023-06-26 21:41: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":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14959381","transaction_code":"A","transaction_date":"2023-05-19 00:00:00","upload_date":"2023-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03370817","upload_search_indicator":null,"census_search_date":"2023-06-26 21:41:00","snet_input_date":"2023-05-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-06-26 21:41:00","insp_carrier_name":"ESTEEM FREIGHTWAYS LLC","insp_carrier_street":"968 WOODRIDGE CT","insp_carrier_city":"YUBA CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"95993","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:29:46.000000Z","updated_at":"2025-03-17T19:29:46.000000Z","inspection_violations":[{"id":5197488,"change_date":"2023-06-26 21:41:00","inspection_id":"78987896","insp_violation_id":"253712596","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"195684541","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:06.000000Z","updated_at":"2025-03-17T21:31:06.000000Z","normalized_code":"39347E"}],"inspection_per_units":[{"id":5417376,"change_date":"2023-06-26 21:41:00","inspection_id":"78987896","insp_unit_id":"195684540","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"680\/BLU","insp_unit_license":"YP77341","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49XXPJ265211","insp_unit_decal":"Y","insp_unit_decal_number":"32449013","created_at":"2025-03-17T22:45:44.000000Z","updated_at":"2025-03-17T22:45:44.000000Z"},{"id":5417377,"change_date":"2023-06-26 21:41:00","inspection_id":"78987896","insp_unit_id":"195684541","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"4599\/WHT","insp_unit_license":"4TW2881","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2536N2419806","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:44.000000Z","updated_at":"2025-03-17T22:45:44.000000Z"}]},{"id":124213,"change_date":"2022-04-06 21:41:00","inspection_id":"75240893","dot_number":"3370817","report_state":"CA","report_number":"NCRM003723","insp_date":"2022-04-05 00:00:00","insp_start_time":"1730","insp_end_time":"1801","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"MISSION GRADE IF","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"RPF PACK WAREHOUSE","shipping_paper_number":"815860000007809","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":null,"final_status_date":"2022-04-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"4","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14373848","transaction_code":"A","transaction_date":"2022-04-05 00:00:00","upload_date":"2022-04-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03370817","upload_search_indicator":null,"census_search_date":"2022-04-06 21:41:00","snet_input_date":"2022-04-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-04-06 21:41:00","insp_carrier_name":"ESTEEM FREIGHTWAYS LLC","insp_carrier_street":"968 WOODRIDGE CT","insp_carrier_city":"YUBA CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"95993","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:29:48.000000Z","updated_at":"2025-03-17T18:29:48.000000Z","inspection_violations":[{"id":184341,"change_date":"2022-04-06 21:41:00","inspection_id":"75240893","insp_violation_id":"245015298","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"188029206","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:07:55.000000Z","updated_at":"2025-03-17T21:07:55.000000Z","normalized_code":"3963A1"},{"id":184342,"change_date":"2022-04-06 21:41:00","inspection_id":"75240893","insp_violation_id":"245015299","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"188029206","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:55.000000Z","updated_at":"2025-03-17T21:07:55.000000Z","normalized_code":"3963A1"},{"id":184343,"change_date":"2022-04-06 21:41:00","inspection_id":"75240893","insp_violation_id":"245015300","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"188029206","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:55.000000Z","updated_at":"2025-03-17T21:07:55.000000Z","normalized_code":"3963A1"},{"id":184344,"change_date":"2022-04-06 21:41:00","inspection_id":"75240893","insp_violation_id":"245015301","seq_no":"4","part_no":"392","part_no_section":"9(a)(1)","insp_viol_unit":"2","insp_unit_id":"188029207","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:07:55.000000Z","updated_at":"2025-03-17T21:07:55.000000Z","normalized_code":"3929A1"}],"inspection_per_units":[{"id":201093,"change_date":"2022-04-06 21:41:00","inspection_id":"75240893","insp_unit_id":"188029206","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"1140\/WHT","insp_unit_license":"XP71053","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X8GJ101648","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:26.000000Z","updated_at":"2025-03-17T22:09:26.000000Z"},{"id":201094,"change_date":"2022-04-06 21:41:00","inspection_id":"75240893","insp_unit_id":"188029207","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"4599\/WHT","insp_unit_license":"4TW2881","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2536N2419806","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:26.000000Z","updated_at":"2025-03-17T22:09:26.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3370817\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3370817\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3370817\/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\/3370817\/inspections","per_page":100,"prev_page_url":null,"to":37,"total":37}