{"current_page":1,"data":[{"id":10325735,"change_date":"2025-12-01 21:40:00","inspection_id":"86452549","dot_number":"2895103","report_state":"CA","report_number":"UEO4000423","insp_date":"2025-11-28 00:00:00","insp_start_time":"0703","insp_end_time":"0724","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":"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":"2025-12-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16074589","transaction_code":"A","transaction_date":"2025-11-28 00:00:00","upload_date":"2025-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02895103","upload_search_indicator":null,"census_search_date":"2025-12-01 21:40:00","snet_input_date":"2025-11-28 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-01 21:40:00","insp_carrier_name":"ANDRE FARMING CO INC","insp_carrier_street":"17493 AVE 20","insp_carrier_city":"MADERA","insp_carrier_state":"CA","insp_carrier_zip_code":"93637","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-04T10:30:47.000000Z","updated_at":"2025-12-05T10:31:59.000000Z","inspection_violations":[{"id":17270162,"change_date":"2025-12-01 21:40:00","inspection_id":"86452549","insp_violation_id":"270381279","seq_no":"1","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"210344645","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RK92435","created_at":"2025-12-04T10:31:16.000000Z","updated_at":"2025-12-05T10:32:40.000000Z","normalized_code":"3939ALHLI"}],"inspection_per_units":[{"id":17243852,"change_date":"2025-12-01 21:40:00","inspection_id":"86452549","insp_unit_id":"210344645","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"97 WHT","insp_unit_license":"9G59983","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGBDV6ELFU1962","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-04T10:00:50.000000Z","updated_at":"2025-12-05T10:02:29.000000Z"},{"id":17243853,"change_date":"2025-12-01 21:40:00","inspection_id":"86452549","insp_unit_id":"210344646","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WESTM","insp_unit_company":"T101\/TANK","insp_unit_license":"4RX5471","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"16WTE40224A134984","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-04T10:00:50.000000Z","updated_at":"2025-12-05T10:02:29.000000Z"}]},{"id":10048618,"change_date":"2025-10-27 21:39:00","inspection_id":"86161282","dot_number":"2895103","report_state":"CA","report_number":"ND7N010056","insp_date":"2025-10-23 00:00:00","insp_start_time":"1009","insp_end_time":"1030","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":"2","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16033543","transaction_code":"A","transaction_date":"2025-10-23 00:00:00","upload_date":"2025-10-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02895103","upload_search_indicator":null,"census_search_date":"2025-10-27 21:39:00","snet_input_date":"2025-10-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-10-27 21:39:00","insp_carrier_name":"ANDRE FARMING CO INC","insp_carrier_street":"17493 AVE 20","insp_carrier_city":"MADERA","insp_carrier_state":"CA","insp_carrier_zip_code":"93637","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"484742","created_at":"2025-10-30T10:00:51.000000Z","updated_at":"2025-11-01T10:01:22.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16696855,"change_date":"2025-10-27 21:39:00","inspection_id":"86161282","insp_unit_id":"209680895","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"97 WHT","insp_unit_license":"9G59983","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGBDV6ELFU1962","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-30T09:45:56.000000Z","updated_at":"2025-10-31T09:46:40.000000Z"},{"id":16696856,"change_date":"2025-10-27 21:39:00","inspection_id":"86161282","insp_unit_id":"209680896","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WESTM","insp_unit_company":"T101 TANK","insp_unit_license":"4RX5471","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"16WTE40224A134984","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-30T09:45:56.000000Z","updated_at":"2025-10-31T09:46:40.000000Z"}]},{"id":9841646,"change_date":"2025-10-02 21:42:00","inspection_id":"85943143","dot_number":"2895103","report_state":"CA","report_number":"ND7N009941","insp_date":"2025-09-30 00:00:00","insp_start_time":"0818","insp_end_time":"0904","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":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-10-02 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16000572","transaction_code":"A","transaction_date":"2025-09-30 00:00:00","upload_date":"2025-10-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02895103","upload_search_indicator":null,"census_search_date":"2025-10-02 21:42:00","snet_input_date":"2025-09-30 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-10-02 21:42:00","insp_carrier_name":"ANDRE FARMING CO INC","insp_carrier_street":"17493 AVE 20","insp_carrier_city":"MADERA","insp_carrier_state":"CA","insp_carrier_zip_code":"93637","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"484742","created_at":"2025-10-05T10:02:00.000000Z","updated_at":"2025-10-05T10:02:00.000000Z","inspection_violations":[{"id":16205897,"change_date":"2025-10-02 21:42:00","inspection_id":"85943143","insp_violation_id":"269066965","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"209271930","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RK91969","created_at":"2025-10-05T10:17:49.000000Z","updated_at":"2025-10-05T10:17:49.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":16320042,"change_date":"2025-10-02 21:42:00","inspection_id":"85943143","insp_unit_id":"209271930","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"97 WHT","insp_unit_license":"9G59983","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGBDV6ELFU1962","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-05T09:47:03.000000Z","updated_at":"2025-10-05T09:47:03.000000Z"},{"id":16320043,"change_date":"2025-10-02 21:42:00","inspection_id":"85943143","insp_unit_id":"209271931","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WESTM","insp_unit_company":"T101 TANK","insp_unit_license":"4RX5471","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"16WTE40224A134984","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-05T09:47:03.000000Z","updated_at":"2025-10-05T09:47:03.000000Z"}]},{"id":8635619,"change_date":"2025-05-14 21:42:00","inspection_id":"84672891","dot_number":"2895103","report_state":"CA","report_number":"UD7O002999","insp_date":"2025-05-14 00:00:00","insp_start_time":"0520","insp_end_time":"0526","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":"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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-14 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":"15819364","transaction_code":"A","transaction_date":"2025-05-14 00:00:00","upload_date":"2025-05-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02895103","upload_search_indicator":null,"census_search_date":"2025-05-14 21:42:00","snet_input_date":"2025-05-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-05-14 21:42:00","insp_carrier_name":"ANDRE FARMING CO INC","insp_carrier_street":"17493 AVE 20","insp_carrier_city":"MADERA","insp_carrier_state":"CA","insp_carrier_zip_code":"93637","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-17T10:05:32.000000Z","updated_at":"2025-05-18T10:07:00.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14101143,"change_date":"2025-05-14 21:42:00","inspection_id":"84672891","insp_unit_id":"206864157","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"97\/WHI","insp_unit_license":"9G59983","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGBDV6ELFU1962","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-17T09:49:26.000000Z","updated_at":"2025-05-18T09:52:43.000000Z"},{"id":14101144,"change_date":"2025-05-14 21:42:00","inspection_id":"84672891","insp_unit_id":"206864158","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WESTM","insp_unit_company":"T101\/TANK","insp_unit_license":"4RX5471","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"16WTE40224A134984","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-17T09:49:26.000000Z","updated_at":"2025-05-18T09:52:43.000000Z"}]},{"id":8594086,"change_date":"2025-05-09 21:42:00","inspection_id":"84629219","dot_number":"2895103","report_state":"CA","report_number":"UFEV003304","insp_date":"2025-05-09 00:00:00","insp_start_time":"0715","insp_end_time":"0728","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":"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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"102000","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":"15814096","transaction_code":"A","transaction_date":"2025-05-09 00:00:00","upload_date":"2025-05-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02895103","upload_search_indicator":null,"census_search_date":"2025-05-09 21:42:00","snet_input_date":"2025-05-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-05-09 21:42:00","insp_carrier_name":"ANDRE FARMING CO INC","insp_carrier_street":"17493 AVE 20","insp_carrier_city":"MADERA","insp_carrier_state":"CA","insp_carrier_zip_code":"93637","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-12T10:03:11.000000Z","updated_at":"2025-05-13T10:03:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14028319,"change_date":"2025-05-09 21:42:00","inspection_id":"84629219","insp_unit_id":"206785591","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"97","insp_unit_license":"9G59983","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGBDV6ELFU1962","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-12T09:48:59.000000Z","updated_at":"2025-05-13T09:49:21.000000Z"},{"id":14028320,"change_date":"2025-05-09 21:42:00","inspection_id":"84629219","insp_unit_id":"206785592","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WESTM","insp_unit_company":null,"insp_unit_license":"4RX5471","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"16WTE40224A134984","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-12T09:48:59.000000Z","updated_at":"2025-05-13T09:49:21.000000Z"}]},{"id":8333809,"change_date":"2025-04-09 21:41:00","inspection_id":"84355024","dot_number":"2895103","report_state":"CA","report_number":"N9PI009012","insp_date":"2025-04-08 00:00:00","insp_start_time":"0853","insp_end_time":"0920","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":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-04-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"124000","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":"15773616","transaction_code":"A","transaction_date":"2025-04-08 00:00:00","upload_date":"2025-04-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02895103","upload_search_indicator":null,"census_search_date":"2025-04-09 21:41:00","snet_input_date":"2025-04-08 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-04-09 21:41:00","insp_carrier_name":"ANDRE FARMING CO INC","insp_carrier_street":"17493 AVE 20","insp_carrier_city":"MADERA","insp_carrier_state":"CA","insp_carrier_zip_code":"93637","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"484742","created_at":"2025-04-12T10:24:43.000000Z","updated_at":"2025-04-14T10:26:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13518040,"change_date":"2025-04-09 21:41:00","inspection_id":"84355024","insp_unit_id":"206230584","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"TANK TRL","insp_unit_license":"TH9083","insp_unit_license_state":"ID","insp_unit_vehicle_id_number":"1PMS14324H1048029","insp_unit_decal":"Y","insp_unit_decal_number":"35070610","created_at":"2025-04-12T10:14:52.000000Z","updated_at":"2025-04-13T10:07:58.000000Z"},{"id":13518039,"change_date":"2025-04-09 21:41:00","inspection_id":"84355024","insp_unit_id":"206230583","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHT 98","insp_unit_license":"9G76127","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGBDVXJSJX9680","insp_unit_decal":"Y","insp_unit_decal_number":"35070609","created_at":"2025-04-12T10:14:52.000000Z","updated_at":"2025-04-13T10:07:58.000000Z"}]},{"id":7913967,"change_date":"2025-02-19 21:41:00","inspection_id":"83913518","dot_number":"2895103","report_state":"CA","report_number":"NEUU000334","insp_date":"2025-02-19 00:00:00","insp_start_time":"0810","insp_end_time":"0910","registration_date":null,"region":"PT","ci_status_code":"C","location":"450","location_desc":"CHOWCHILLA","county_code_state":"CA","county_code":"039","insp_level_id":"5","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":"N","pen_cen_match":null,"final_status_date":"2025-02-19 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":"15709100","transaction_code":"A","transaction_date":"2025-02-19 00:00:00","upload_date":"2025-02-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02895103","upload_search_indicator":null,"census_search_date":"2025-02-19 21:41:00","snet_input_date":"2025-02-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-19 21:41:00","insp_carrier_name":"ANDRE FARMING CO INC","insp_carrier_street":"17493 AVE 20","insp_carrier_city":"MADERA","insp_carrier_state":"CA","insp_carrier_zip_code":"93637","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"484742","created_at":"2025-03-17T21:02:24.000000Z","updated_at":"2025-03-17T21:02:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12774682,"change_date":"2025-02-19 21:41:00","inspection_id":"83913518","insp_unit_id":"205409136","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"75","insp_unit_license":"9F50514","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5KJJAVDV5GLHB9128","insp_unit_decal":"Y","insp_unit_decal_number":"34777519","created_at":"2025-03-17T23:56:06.000000Z","updated_at":"2025-03-17T23:56:06.000000Z"},{"id":12774683,"change_date":"2025-02-19 21:41:00","inspection_id":"83913518","insp_unit_id":"205409137","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WESTM","insp_unit_company":"T101","insp_unit_license":"4RX5471","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"16WTE40224A134984","insp_unit_decal":"Y","insp_unit_decal_number":"34777518","created_at":"2025-03-17T23:56:06.000000Z","updated_at":"2025-03-17T23:56:06.000000Z"}]},{"id":7913968,"change_date":"2025-02-19 21:41:00","inspection_id":"83913519","dot_number":"2895103","report_state":"CA","report_number":"NEUU000335","insp_date":"2025-02-19 00:00:00","insp_start_time":"0915","insp_end_time":"1008","registration_date":null,"region":"PT","ci_status_code":"C","location":"450","location_desc":"CHOWCHILLA","county_code_state":"CA","county_code":"039","insp_level_id":"5","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":"N","pen_cen_match":null,"final_status_date":"2025-02-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15709163","transaction_code":"A","transaction_date":"2025-02-19 00:00:00","upload_date":"2025-02-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02895103","upload_search_indicator":null,"census_search_date":"2025-02-19 21:41:00","snet_input_date":"2025-02-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-19 21:41:00","insp_carrier_name":"ANDRE FARMING CO INC","insp_carrier_street":"17493 AVE 20","insp_carrier_city":"MADERA","insp_carrier_state":"CA","insp_carrier_zip_code":"93637","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:02:24.000000Z","updated_at":"2025-03-17T21:02:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12774684,"change_date":"2025-02-19 21:41:00","inspection_id":"83913519","insp_unit_id":"205409138","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"2","insp_unit_license":"9E56416","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5KJJABDR2BPAX9855","insp_unit_decal":"Y","insp_unit_decal_number":"34777520","created_at":"2025-03-17T23:56:06.000000Z","updated_at":"2025-03-17T23:56:06.000000Z"},{"id":12774685,"change_date":"2025-02-19 21:41:00","inspection_id":"83913519","insp_unit_id":"205409139","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"COZA","insp_unit_company":"T12","insp_unit_license":"1WU5324","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1C9W4420651167019","insp_unit_decal":"Y","insp_unit_decal_number":"34777521","created_at":"2025-03-17T23:56:06.000000Z","updated_at":"2025-03-17T23:56:06.000000Z"}]},{"id":7913969,"change_date":"2025-02-19 21:41:00","inspection_id":"83913520","dot_number":"2895103","report_state":"CA","report_number":"NEUU000336","insp_date":"2025-02-19 00:00:00","insp_start_time":"1010","insp_end_time":"1038","registration_date":null,"region":"PT","ci_status_code":"C","location":"450","location_desc":"CHOWCHILLA","county_code_state":"CA","county_code":"039","insp_level_id":"5","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":"N","pen_cen_match":null,"final_status_date":"2025-02-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"15709244","transaction_code":"A","transaction_date":"2025-02-19 00:00:00","upload_date":"2025-02-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02895103","upload_search_indicator":null,"census_search_date":"2025-02-19 21:41:00","snet_input_date":"2025-02-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-19 21:41:00","insp_carrier_name":"ANDRE FARMING CO INC","insp_carrier_street":"17493 AVE 20","insp_carrier_city":"MADERA","insp_carrier_state":"CA","insp_carrier_zip_code":"93637","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"484742","created_at":"2025-03-17T21:02:24.000000Z","updated_at":"2025-03-17T21:02:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12774686,"change_date":"2025-02-19 21:41:00","inspection_id":"83913520","insp_unit_id":"205409140","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"97","insp_unit_license":"9G59983","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGBDV6ELFU1962","insp_unit_decal":"Y","insp_unit_decal_number":"34777522","created_at":"2025-03-17T23:56:06.000000Z","updated_at":"2025-03-17T23:56:06.000000Z"}]},{"id":7373204,"change_date":"2024-12-09 21:42:00","inspection_id":"83345657","dot_number":"2895103","report_state":"CA","report_number":"N9PI008652","insp_date":"2024-12-04 00:00:00","insp_start_time":"1056","insp_end_time":"1146","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":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-12-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"124000","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":"15620501","transaction_code":"A","transaction_date":"2024-12-04 00:00:00","upload_date":"2024-12-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02895103","upload_search_indicator":null,"census_search_date":"2024-12-09 21:42:00","snet_input_date":"2024-12-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-12-09 21:42:00","insp_carrier_name":"ANDRE FARMING CO INC","insp_carrier_street":"17493 AVE 20","insp_carrier_city":"MADERA","insp_carrier_state":"CA","insp_carrier_zip_code":"93637","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"484742","created_at":"2025-03-17T20:49:49.000000Z","updated_at":"2025-03-17T20:49:49.000000Z","inspection_violations":[{"id":11520713,"change_date":"2024-12-09 21:42:00","inspection_id":"83345657","insp_violation_id":"263345352","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"204281486","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RK89436","created_at":"2025-03-17T22:02:06.000000Z","updated_at":"2025-03-17T22:02:06.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":11894427,"change_date":"2024-12-09 21:42:00","inspection_id":"83345657","insp_unit_id":"204281486","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHT 98","insp_unit_license":"9G76127","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGBDVXJSJX9680","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:19.000000Z","updated_at":"2025-03-17T23:46:19.000000Z"},{"id":11894428,"change_date":"2024-12-09 21:42:00","inspection_id":"83345657","insp_unit_id":"204281487","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"TANK T118","insp_unit_license":"TJ4281","insp_unit_license_state":"ID","insp_unit_vehicle_id_number":"1PMS1432481034339","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:19.000000Z","updated_at":"2025-03-17T23:46:19.000000Z"}]},{"id":7310197,"change_date":"2024-11-30 21:33:00","inspection_id":"83279237","dot_number":"2895103","report_state":"CA","report_number":"ND65008897","insp_date":"2024-11-04 00:00:00","insp_start_time":"0902","insp_end_time":"0954","registration_date":null,"region":"PT","ci_status_code":"C","location":"875","location_desc":"MT. PASS JPOE CVEF","county_code_state":"CA","county_code":"071","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"BLUE DIAMOND HILL GYPSUM","shipping_paper_number":"221066","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","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-11-30 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"15610521","transaction_code":"A","transaction_date":"2024-11-04 00:00:00","upload_date":"2024-11-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02895103","upload_search_indicator":null,"census_search_date":"2024-11-30 21:33:00","snet_input_date":"2024-11-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-11-30 21:33:00","insp_carrier_name":"ANDRE FARMING CO INC","insp_carrier_street":"17493 AVE 20","insp_carrier_city":"MADERA","insp_carrier_state":"CA","insp_carrier_zip_code":"93637","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:48:35.000000Z","updated_at":"2025-03-17T20:48:35.000000Z","inspection_violations":[{"id":11427995,"change_date":"2024-11-30 21:33:00","inspection_id":"83279237","insp_violation_id":"263155696","seq_no":"1","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"204116804","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-03-17T22:01:34.000000Z","updated_at":"2025-03-17T22:01:34.000000Z","normalized_code":"39345B2BAIR"}],"inspection_per_units":[{"id":11792137,"change_date":"2024-11-30 21:33:00","inspection_id":"83279237","insp_unit_id":"204116804","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHT,63","insp_unit_license":"WP69119","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLDV5FSGP2702","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:13.000000Z","updated_at":"2025-03-17T23:45:13.000000Z"},{"id":11792138,"change_date":"2024-11-30 21:33:00","inspection_id":"83279237","insp_unit_id":"204116805","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WESE","insp_unit_company":"WHT,B1","insp_unit_license":"4VU1731","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5DN154420CB000332","insp_unit_decal":"Y","insp_unit_decal_number":"34520272","created_at":"2025-03-17T23:45:13.000000Z","updated_at":"2025-03-17T23:45:13.000000Z"}]},{"id":7041110,"change_date":"2024-10-24 21:42:00","inspection_id":"82994453","dot_number":"2895103","report_state":"CA","report_number":"NEUU000242","insp_date":"2024-10-24 00:00:00","insp_start_time":"1116","insp_end_time":"1155","registration_date":null,"region":"PT","ci_status_code":"C","location":"450","location_desc":"CHOWCHILLA","county_code_state":"CA","county_code":"039","insp_level_id":"5","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":"N","pen_cen_match":null,"final_status_date":"2024-10-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"15570197","transaction_code":"A","transaction_date":"2024-10-24 00:00:00","upload_date":"2024-10-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02895103","upload_search_indicator":null,"census_search_date":"2024-10-24 21:42:00","snet_input_date":"2024-10-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-10-24 21:42:00","insp_carrier_name":"ANDRE FARMING CO INC","insp_carrier_street":"17493 AVE 20","insp_carrier_city":"MADERA","insp_carrier_state":"CA","insp_carrier_zip_code":"93637","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"484742","created_at":"2025-03-17T20:42:59.000000Z","updated_at":"2025-03-17T20:42:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11355764,"change_date":"2024-10-24 21:42:00","inspection_id":"82994453","insp_unit_id":"203578270","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"97\/WHT","insp_unit_license":"9G59983","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGBDV6ELFU1962","insp_unit_decal":"Y","insp_unit_decal_number":"34477768","created_at":"2025-03-17T23:40:36.000000Z","updated_at":"2025-03-17T23:40:36.000000Z"}]},{"id":4980023,"change_date":"2024-02-05 21:40:00","inspection_id":"80771460","dot_number":"2895103","report_state":"CA","report_number":"ND7N007544","insp_date":"2024-02-02 00:00:00","insp_start_time":"1657","insp_end_time":"1721","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":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-02-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15223902","transaction_code":"A","transaction_date":"2024-02-02 00:00:00","upload_date":"2024-02-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02895103","upload_search_indicator":null,"census_search_date":"2024-02-05 21:40:00","snet_input_date":"2024-02-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-02-05 21:40:00","insp_carrier_name":"ANDRE FARMING CO INC","insp_carrier_street":"17493 AVE 20","insp_carrier_city":"MADERA","insp_carrier_state":"CA","insp_carrier_zip_code":"93637","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:01:35.000000Z","updated_at":"2025-03-17T20:01:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8015178,"change_date":"2024-02-05 21:40:00","inspection_id":"80771460","insp_unit_id":"199274643","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WEST","insp_unit_company":"67 WT\/RED","insp_unit_license":"ZP09679","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5KJJAEDV9HPHU9702","insp_unit_decal":"Y","insp_unit_decal_number":"33535254","created_at":"2025-03-17T23:07:40.000000Z","updated_at":"2025-03-17T23:07:40.000000Z"},{"id":8015179,"change_date":"2024-02-05 21:40:00","inspection_id":"80771460","insp_unit_id":"199274644","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"T102 TANK","insp_unit_license":"4NG2135","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1PMS1432181034024","insp_unit_decal":"Y","insp_unit_decal_number":"33535255","created_at":"2025-03-17T23:07:40.000000Z","updated_at":"2025-03-17T23:07:40.000000Z"}]},{"id":4843041,"change_date":"2024-01-16 21:45:00","inspection_id":"80621563","dot_number":"2895103","report_state":"CA","report_number":"NC20006317","insp_date":"2024-01-12 00:00:00","insp_start_time":"1244","insp_end_time":"1302","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":"2","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-01-16 21:45: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":"15199806","transaction_code":"A","transaction_date":"2024-01-12 00:00:00","upload_date":"2024-01-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02895103","upload_search_indicator":null,"census_search_date":"2024-01-16 21:45:00","snet_input_date":"2024-01-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-01-16 21:45:00","insp_carrier_name":"ANDRE FARMING CO INC","insp_carrier_street":"17493 AVE 20","insp_carrier_city":"MADERA","insp_carrier_state":"CA","insp_carrier_zip_code":"93637","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"484742","created_at":"2025-03-17T19:58:48.000000Z","updated_at":"2025-03-17T19:58:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7792173,"change_date":"2024-01-16 21:45:00","inspection_id":"80621563","insp_unit_id":"198982100","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"T118\/TANK","insp_unit_license":"TJ4281","insp_unit_license_state":"ID","insp_unit_vehicle_id_number":"1PMS1432481034339","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:39.000000Z","updated_at":"2025-03-17T23:05:39.000000Z"},{"id":7792174,"change_date":"2024-01-16 21:45:00","inspection_id":"80621563","insp_unit_id":"198982101","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"75\/WHT","insp_unit_license":"9F50514","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5KJJAVDV5GLHB9128","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:39.000000Z","updated_at":"2025-03-17T23:05:39.000000Z"}]},{"id":4583320,"change_date":"2023-12-07 21:41:00","inspection_id":"80337522","dot_number":"2895103","report_state":"CA","report_number":"UBGO003886","insp_date":"2023-12-06 00:00:00","insp_start_time":"1040","insp_end_time":"1105","registration_date":null,"region":"PT","ci_status_code":"C","location":"480","location_desc":"VISALIA","county_code_state":"CA","county_code":"107","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":"N","pen_cen_match":null,"final_status_date":"2023-12-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"5","oos_total":"2","driver_viol_total":"3","driver_oos_total":"2","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15157879","transaction_code":"A","transaction_date":"2023-12-06 00:00:00","upload_date":"2023-12-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02895103","upload_search_indicator":null,"census_search_date":"2023-12-07 21:41:00","snet_input_date":"2023-12-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-12-07 21:41:00","insp_carrier_name":"ANDRE FARMING CO INC","insp_carrier_street":"17493 AVE 20","insp_carrier_city":"MADERA","insp_carrier_state":"CA","insp_carrier_zip_code":"93637","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"484742","created_at":"2025-03-17T19:53:45.000000Z","updated_at":"2025-03-17T19:53:45.000000Z","inspection_violations":[{"id":7089617,"change_date":"2023-12-07 21:41:00","inspection_id":"80337522","insp_violation_id":"256778931","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"LC22517","created_at":"2025-03-17T21:40:15.000000Z","updated_at":"2025-03-17T21:40:15.000000Z","normalized_code":"3922"},{"id":7089618,"change_date":"2023-12-07 21:41:00","inspection_id":"80337522","insp_violation_id":"256778932","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":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:15.000000Z","updated_at":"2025-03-17T21:40:15.000000Z","normalized_code":"3922"},{"id":7089619,"change_date":"2023-12-07 21:41:00","inspection_id":"80337522","insp_violation_id":"256778933","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"49","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:15.000000Z","updated_at":"2025-03-17T21:40:15.000000Z","normalized_code":"3922"},{"id":7089620,"change_date":"2023-12-07 21:41:00","inspection_id":"80337522","insp_violation_id":"256778934","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"198407284","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CU058023","created_at":"2025-03-17T21:40:15.000000Z","updated_at":"2025-03-17T21:40:15.000000Z","normalized_code":"3922"},{"id":7089621,"change_date":"2023-12-07 21:41:00","inspection_id":"80337522","insp_violation_id":"256778935","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198407283","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:15.000000Z","updated_at":"2025-03-17T21:40:15.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7371961,"change_date":"2023-12-07 21:41:00","inspection_id":"80337522","insp_unit_id":"198407283","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"90","insp_unit_license":"ZP09680","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGEDVXGDGX7461","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:57.000000Z","updated_at":"2025-03-17T23:01:57.000000Z"},{"id":7371962,"change_date":"2023-12-07 21:41:00","inspection_id":"80337522","insp_unit_id":"198407284","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WESE","insp_unit_company":"B1","insp_unit_license":"4LK2993","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5DN154420CB000332","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:57.000000Z","updated_at":"2025-03-17T23:01:57.000000Z"}]},{"id":4148502,"change_date":"2023-10-06 21:41:00","inspection_id":"79857832","dot_number":"2895103","report_state":"CA","report_number":"NDLY006900","insp_date":"2023-10-03 00:00:00","insp_start_time":"1503","insp_end_time":"1523","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":"ANDRE FARMING","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":"2023-10-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"6","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15088314","transaction_code":"A","transaction_date":"2023-10-03 00:00:00","upload_date":"2023-10-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02895103","upload_search_indicator":null,"census_search_date":"2023-10-06 21:41:00","snet_input_date":"2023-10-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-10-06 21:41:00","insp_carrier_name":"ANDRE FARMING CO INC","insp_carrier_street":"17493 AVE 20","insp_carrier_city":"MADERA","insp_carrier_state":"CA","insp_carrier_zip_code":"93637","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0484742","created_at":"2025-03-17T19:44:56.000000Z","updated_at":"2025-03-17T19:44:56.000000Z","inspection_violations":[{"id":6422103,"change_date":"2023-10-06 21:41:00","inspection_id":"79857832","insp_violation_id":"255714133","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"197447076","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"DA247559","created_at":"2025-03-17T21:36:59.000000Z","updated_at":"2025-03-17T21:36:59.000000Z","normalized_code":"39375A3"},{"id":6422104,"change_date":"2023-10-06 21:41:00","inspection_id":"79857832","insp_violation_id":"255714134","seq_no":"2","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"197447076","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:59.000000Z","updated_at":"2025-03-17T21:36:59.000000Z","normalized_code":"39348A"},{"id":6422105,"change_date":"2023-10-06 21:41:00","inspection_id":"79857832","insp_violation_id":"255714135","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"197447076","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:59.000000Z","updated_at":"2025-03-17T21:36:59.000000Z","normalized_code":"39347E"},{"id":6422106,"change_date":"2023-10-06 21:41:00","inspection_id":"79857832","insp_violation_id":"255714136","seq_no":"4","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"197447076","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:59.000000Z","updated_at":"2025-03-17T21:36:59.000000Z","normalized_code":"39347E"},{"id":6422107,"change_date":"2023-10-06 21:41:00","inspection_id":"79857832","insp_violation_id":"255714137","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"197447076","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"DA247559","created_at":"2025-03-17T21:36:59.000000Z","updated_at":"2025-03-17T21:36:59.000000Z","normalized_code":"3963A1"},{"id":6422108,"change_date":"2023-10-06 21:41:00","inspection_id":"79857832","insp_violation_id":"255714138","seq_no":"6","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"197447076","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:59.000000Z","updated_at":"2025-03-17T21:36:59.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":6670497,"change_date":"2023-10-06 21:41:00","inspection_id":"79857832","insp_unit_id":"197447075","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"96\/WHT","insp_unit_license":"9G59989","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGBDVXELFR5779","insp_unit_decal":"Y","insp_unit_decal_number":"33229357","created_at":"2025-03-17T22:55:57.000000Z","updated_at":"2025-03-17T22:55:57.000000Z"},{"id":6670498,"change_date":"2023-10-06 21:41:00","inspection_id":"79857832","insp_unit_id":"197447076","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"THE T","insp_unit_company":"13\/WHT","insp_unit_license":"4UM3578","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1T92P4528FB073632","insp_unit_decal":"Y","insp_unit_decal_number":"33229358","created_at":"2025-03-17T22:55:57.000000Z","updated_at":"2025-03-17T22:55:57.000000Z"}]},{"id":3612937,"change_date":"2023-07-27 21:41:00","inspection_id":"79260874","dot_number":"2895103","report_state":"CA","report_number":"NBH0006700","insp_date":"2023-07-26 00:00:00","insp_start_time":"0912","insp_end_time":"0947","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":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":"2023-07-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14998668","transaction_code":"A","transaction_date":"2023-07-26 00:00:00","upload_date":"2023-07-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02895103","upload_search_indicator":null,"census_search_date":"2023-07-27 21:41:00","snet_input_date":"2023-07-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-07-27 21:41:00","insp_carrier_name":"ANDRE FARMING CO INC","insp_carrier_street":"17493 AVE 20","insp_carrier_city":"MADERA","insp_carrier_state":"CA","insp_carrier_zip_code":"93637","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"484742","created_at":"2025-03-17T19:34:14.000000Z","updated_at":"2025-03-17T19:34:14.000000Z","inspection_violations":[{"id":5573373,"change_date":"2023-07-27 21:41:00","inspection_id":"79260874","insp_violation_id":"254329355","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196236491","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"KR59553","created_at":"2025-03-17T21:32:49.000000Z","updated_at":"2025-03-17T21:32:49.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5809035,"change_date":"2023-07-27 21:41:00","inspection_id":"79260874","insp_unit_id":"196236491","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"96\/WHT","insp_unit_license":"9G59989","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGBDVXELFR5779","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:51.000000Z","updated_at":"2025-03-17T22:48:51.000000Z"},{"id":5809036,"change_date":"2023-07-27 21:41:00","inspection_id":"79260874","insp_unit_id":"196236492","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"T118\/CHROME","insp_unit_license":"TJ4281","insp_unit_license_state":"ID","insp_unit_vehicle_id_number":"1PMS1432481034339","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:51.000000Z","updated_at":"2025-03-17T22:48:51.000000Z"}]},{"id":3409296,"change_date":"2023-06-29 21:43:00","inspection_id":"79032201","dot_number":"2895103","report_state":"CA","report_number":"UC8B001581","insp_date":"2023-06-28 00:00:00","insp_start_time":"1427","insp_end_time":"1438","registration_date":null,"region":"PT","ci_status_code":"C","location":"480","location_desc":"VISALIA AREA","county_code_state":"CA","county_code":"107","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-29 21:43: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":"14963730","transaction_code":"A","transaction_date":"2023-06-28 00:00:00","upload_date":"2023-06-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02895103","upload_search_indicator":null,"census_search_date":"2023-06-29 21:43:00","snet_input_date":"2023-06-28 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-06-29 21:43:00","insp_carrier_name":"ANDRE FARMING CO INC","insp_carrier_street":"17493 AVE 20","insp_carrier_city":"MADERA","insp_carrier_state":"CA","insp_carrier_zip_code":"93637","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"484742","created_at":"2025-03-17T19:30:34.000000Z","updated_at":"2025-03-17T19:30:34.000000Z","inspection_violations":[{"id":5256196,"change_date":"2023-06-29 21:43:00","inspection_id":"79032201","insp_violation_id":"253807392","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195773219","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:23.000000Z","updated_at":"2025-03-17T21:31:23.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5481574,"change_date":"2023-06-29 21:43:00","inspection_id":"79032201","insp_unit_id":"195773219","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHT 3X","insp_unit_license":"9F33941","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGEDVXGDGX7461","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:15.000000Z","updated_at":"2025-03-17T22:46:15.000000Z"},{"id":5481575,"change_date":"2023-06-29 21:43:00","inspection_id":"79032201","insp_unit_id":"195773220","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WESE","insp_unit_company":"BELT FLOOR","insp_unit_license":"4LK2993","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5DN154420CB000332","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:15.000000Z","updated_at":"2025-03-17T22:46:15.000000Z"}]},{"id":3266131,"change_date":"2023-06-12 21:41:00","inspection_id":"78870859","dot_number":"2895103","report_state":"CA","report_number":"NDS4004201","insp_date":"2023-06-10 00:00:00","insp_start_time":"0657","insp_end_time":"0719","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":"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":"2023-06-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14939547","transaction_code":"A","transaction_date":"2023-06-10 00:00:00","upload_date":"2023-06-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02895103","upload_search_indicator":null,"census_search_date":"2023-06-12 21:41:00","snet_input_date":"2023-06-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-06-12 21:41:00","insp_carrier_name":"ANDRE FARMING CO INC","insp_carrier_street":"17493 AVE 20","insp_carrier_city":"MADERA","insp_carrier_state":"CA","insp_carrier_zip_code":"93637","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:27:42.000000Z","updated_at":"2025-03-17T19:27:42.000000Z","inspection_violations":[{"id":5037369,"change_date":"2023-06-12 21:41:00","inspection_id":"78870859","insp_violation_id":"253455426","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"195455797","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:24.000000Z","updated_at":"2025-03-17T21:30:24.000000Z","normalized_code":"39347E"},{"id":5037370,"change_date":"2023-06-12 21:41:00","inspection_id":"78870859","insp_violation_id":"253455427","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"195455797","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:24.000000Z","updated_at":"2025-03-17T21:30:24.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":5252508,"change_date":"2023-06-12 21:41:00","inspection_id":"78870859","insp_unit_id":"195455797","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WESTM","insp_unit_company":"TNK\/2006","insp_unit_license":"0569TI","insp_unit_license_state":"ID","insp_unit_vehicle_id_number":"16WTE40296A135553","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:24.000000Z","updated_at":"2025-03-17T22:44:24.000000Z"},{"id":5252509,"change_date":"2023-06-12 21:41:00","inspection_id":"78870859","insp_unit_id":"195455798","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"97\/WHT","insp_unit_license":"WP64177","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGBDV6ELFU1962","insp_unit_decal":"Y","insp_unit_decal_number":"32495196","created_at":"2025-03-17T22:44:24.000000Z","updated_at":"2025-03-17T22:44:24.000000Z"}]},{"id":3136040,"change_date":"2023-05-24 21:41:00","inspection_id":"78723956","dot_number":"2895103","report_state":"CA","report_number":"UBVF003006","insp_date":"2023-05-24 00:00:00","insp_start_time":"0646","insp_end_time":"0707","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":"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":"2023-05-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14916654","transaction_code":"A","transaction_date":"2023-05-24 00:00:00","upload_date":"2023-05-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02895103","upload_search_indicator":null,"census_search_date":"2023-05-24 21:41:00","snet_input_date":"2023-05-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-05-24 21:41:00","insp_carrier_name":"ANDRE FARMING CO INC","insp_carrier_street":"17493 AVE 20","insp_carrier_city":"MADERA","insp_carrier_state":"CA","insp_carrier_zip_code":"93637","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"484742","created_at":"2025-03-17T19:25:00.000000Z","updated_at":"2025-03-17T19:25:00.000000Z","inspection_violations":[{"id":4828401,"change_date":"2023-05-24 21:41:00","inspection_id":"78723956","insp_violation_id":"253066195","seq_no":"1","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":null,"created_at":"2025-03-17T21:29:28.000000Z","updated_at":"2025-03-17T21:29:28.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5043974,"change_date":"2023-05-24 21:41:00","inspection_id":"78723956","insp_unit_id":"195131015","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"97 WHT","insp_unit_license":"9G59983","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGBDV6ELFU1962","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:45.000000Z","updated_at":"2025-03-17T22:42:45.000000Z"},{"id":5043975,"change_date":"2023-05-24 21:41:00","inspection_id":"78723956","insp_unit_id":"195131016","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"1122 TANK","insp_unit_license":"TJ922","insp_unit_license_state":"ID","insp_unit_vehicle_id_number":"1PMS14322D1042580","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:45.000000Z","updated_at":"2025-03-17T22:42:45.000000Z"}]},{"id":2172178,"change_date":"2023-01-18 21:40:00","inspection_id":"77629338","dot_number":"2895103","report_state":"CA","report_number":"NBH0005786","insp_date":"2023-01-12 00:00:00","insp_start_time":"0637","insp_end_time":"0705","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":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":"2023-01-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14743711","transaction_code":"A","transaction_date":"2023-01-12 00:00:00","upload_date":"2023-01-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02895103","upload_search_indicator":null,"census_search_date":"2023-01-18 21:40:00","snet_input_date":"2023-01-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-01-18 21:40:00","insp_carrier_name":"ANDRE FARMING CO INC","insp_carrier_street":"17493 AVE 20","insp_carrier_city":"MADERA","insp_carrier_state":"CA","insp_carrier_zip_code":"93637","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:06:38.000000Z","updated_at":"2025-03-17T19:06:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3496356,"change_date":"2023-01-18 21:40:00","inspection_id":"77629338","insp_unit_id":"192937258","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"91","insp_unit_license":"9E49091","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGEDV7ESFR5471","insp_unit_decal":"Y","insp_unit_decal_number":"32168164","created_at":"2025-03-17T22:31:05.000000Z","updated_at":"2025-03-17T22:31:05.000000Z"},{"id":3496357,"change_date":"2023-01-18 21:40:00","inspection_id":"77629338","insp_unit_id":"192937259","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"T118","insp_unit_license":"TJ4281","insp_unit_license_state":"ID","insp_unit_vehicle_id_number":"1PMS1432481034339","insp_unit_decal":"Y","insp_unit_decal_number":"32168165","created_at":"2025-03-17T22:31:05.000000Z","updated_at":"2025-03-17T22:31:05.000000Z"}]},{"id":1874592,"change_date":"2022-12-05 21:40:00","inspection_id":"77288560","dot_number":"2895103","report_state":"CA","report_number":"ND6B004043","insp_date":"2022-11-21 00:00:00","insp_start_time":"1411","insp_end_time":"1433","registration_date":null,"region":"PT","ci_status_code":"C","location":"880","location_desc":"CACHE CREEK","county_code_state":"CA","county_code":"029","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"BLUE DIAMOND HILL GYPSUM","shipping_paper_number":"175467","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-12-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14694549","transaction_code":"A","transaction_date":"2022-11-21 00:00:00","upload_date":"2022-12-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02895103","upload_search_indicator":null,"census_search_date":"2022-12-05 21:40:00","snet_input_date":"2022-11-21 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-12-05 21:40:00","insp_carrier_name":"ANDRE FARMING CO INC","insp_carrier_street":"17493 AVE 20","insp_carrier_city":"MADERA","insp_carrier_state":"CA","insp_carrier_zip_code":"93637","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:01:08.000000Z","updated_at":"2025-03-17T19:01:08.000000Z","inspection_violations":[{"id":2919283,"change_date":"2022-12-05 21:40:00","inspection_id":"77288560","insp_violation_id":"249926653","seq_no":"1","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"1","insp_unit_id":"192266970","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:20:53.000000Z","updated_at":"2025-03-17T21:20:53.000000Z","normalized_code":"393207A"}],"inspection_per_units":[{"id":3017399,"change_date":"2022-12-05 21:40:00","inspection_id":"77288560","insp_unit_id":"192266970","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"63","insp_unit_license":"WP69119","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLDV5FSGP2702","insp_unit_decal":"Y","insp_unit_decal_number":"31896849","created_at":"2025-03-17T22:27:39.000000Z","updated_at":"2025-03-17T22:27:39.000000Z"},{"id":3017400,"change_date":"2022-12-05 21:40:00","inspection_id":"77288560","insp_unit_id":"192266971","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WESE","insp_unit_company":"T324","insp_unit_license":"4RD3587","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5DN154429JB000410","insp_unit_decal":"Y","insp_unit_decal_number":"31896850","created_at":"2025-03-17T22:27:39.000000Z","updated_at":"2025-03-17T22:27:39.000000Z"}]},{"id":1628608,"change_date":"2022-10-28 21:40:00","inspection_id":"77006609","dot_number":"2895103","report_state":"CA","report_number":"UF0X000614","insp_date":"2022-10-28 00:00:00","insp_start_time":"0610","insp_end_time":"0700","registration_date":null,"region":"PT","ci_status_code":"C","location":"480","location_desc":"SB SR-99 N\/OF AVENUE 184","county_code_state":"CA","county_code":"107","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ANDRE FARMING","shipping_paper_number":"40058689","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14654592","transaction_code":"A","transaction_date":"2022-10-28 00:00:00","upload_date":"2022-10-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02895103","upload_search_indicator":null,"census_search_date":"2022-10-28 21:40:00","snet_input_date":"2022-10-28 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-10-28 21:40:00","insp_carrier_name":"ANDRE FARMING CO INC","insp_carrier_street":"17493 AVE 20","insp_carrier_city":"MADERA","insp_carrier_state":"CA","insp_carrier_zip_code":"93637","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:56:40.000000Z","updated_at":"2025-03-17T18:56:40.000000Z","inspection_violations":[{"id":2557577,"change_date":"2022-10-28 21:40:00","inspection_id":"77006609","insp_violation_id":"249322147","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":"LV14635","created_at":"2025-03-17T21:19:01.000000Z","updated_at":"2025-03-17T21:19:01.000000Z","normalized_code":"3922"},{"id":2557578,"change_date":"2022-10-28 21:40:00","inspection_id":"77006609","insp_violation_id":"249322148","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":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:01.000000Z","updated_at":"2025-03-17T21:19:01.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2620085,"change_date":"2022-10-28 21:40:00","inspection_id":"77006609","insp_unit_id":"191704789","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"90","insp_unit_license":"9F33941","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGEDVXGDGX7461","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:59.000000Z","updated_at":"2025-03-17T22:24:59.000000Z"},{"id":2620086,"change_date":"2022-10-28 21:40:00","inspection_id":"77006609","insp_unit_id":"191704790","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WESE","insp_unit_company":null,"insp_unit_license":"4LK2993","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5DN154420CB000332","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:59.000000Z","updated_at":"2025-03-17T22:24:59.000000Z"}]},{"id":1619959,"change_date":"2022-10-27 21:42:00","inspection_id":"76996745","dot_number":"2895103","report_state":"CA","report_number":"ND6B003952","insp_date":"2022-10-24 00:00:00","insp_start_time":"1242","insp_end_time":"1315","registration_date":null,"region":"PT","ci_status_code":"C","location":"880","location_desc":"CACHE CREEK","county_code_state":"CA","county_code":"029","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"BLUE DIAMOND HILL GYPSUM","shipping_paper_number":"173298","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-10-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"118300","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14652476","transaction_code":"A","transaction_date":"2022-10-24 00:00:00","upload_date":"2022-10-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02895103","upload_search_indicator":null,"census_search_date":"2022-10-27 21:42:00","snet_input_date":"2022-10-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-10-27 21:42:00","insp_carrier_name":"ANDRE FARMING CO INC","insp_carrier_street":"17493 AVE 20","insp_carrier_city":"MADERA","insp_carrier_state":"CA","insp_carrier_zip_code":"93637","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:56:21.000000Z","updated_at":"2025-03-17T18:56:21.000000Z","inspection_violations":[{"id":2544378,"change_date":"2022-10-27 21:42:00","inspection_id":"76996745","insp_violation_id":"249300468","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"191686011","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:00.000000Z","updated_at":"2025-03-17T21:19:00.000000Z","normalized_code":"39345B2"},{"id":2544379,"change_date":"2022-10-27 21:42:00","inspection_id":"76996745","insp_violation_id":"249300469","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191686011","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:00.000000Z","updated_at":"2025-03-17T21:19:00.000000Z","normalized_code":"3939A"},{"id":2544380,"change_date":"2022-10-27 21:42:00","inspection_id":"76996745","insp_violation_id":"249300470","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"191686012","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:00.000000Z","updated_at":"2025-03-17T21:19:00.000000Z","normalized_code":"39347E"},{"id":2544381,"change_date":"2022-10-27 21:42:00","inspection_id":"76996745","insp_violation_id":"249300471","seq_no":"4","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"191686012","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:00.000000Z","updated_at":"2025-03-17T21:19:00.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":2606449,"change_date":"2022-10-27 21:42:00","inspection_id":"76996745","insp_unit_id":"191686011","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"58","insp_unit_license":"XP77613","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD65FSGA6106","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:52.000000Z","updated_at":"2025-03-17T22:24:52.000000Z"},{"id":2606450,"change_date":"2022-10-27 21:42:00","inspection_id":"76996745","insp_unit_id":"191686012","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WESTE","insp_unit_company":"T310","insp_unit_license":"4NS1676","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5DN144825FB001509","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:52.000000Z","updated_at":"2025-03-17T22:24:52.000000Z"}]},{"id":1502762,"change_date":"2022-10-12 21:42:00","inspection_id":"76861758","dot_number":"2895103","report_state":"CA","report_number":"NC20004435","insp_date":"2022-10-07 00:00:00","insp_start_time":"0910","insp_end_time":"0926","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":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":"2022-10-12 21:42: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":"14631401","transaction_code":"A","transaction_date":"2022-10-07 00:00:00","upload_date":"2022-10-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02895103","upload_search_indicator":null,"census_search_date":"2022-10-12 21:42:00","snet_input_date":"2022-10-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-10-12 21:42:00","insp_carrier_name":"ANDRE FARMING CO INC","insp_carrier_street":"17493 AVE 20","insp_carrier_city":"MADERA","insp_carrier_state":"CA","insp_carrier_zip_code":"93637","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"484742","created_at":"2025-03-17T18:54:27.000000Z","updated_at":"2025-03-17T18:54:27.000000Z","inspection_violations":[{"id":2366826,"change_date":"2022-10-12 21:42:00","inspection_id":"76861758","insp_violation_id":"248998638","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"191413954","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:52.000000Z","updated_at":"2025-03-17T21:17:52.000000Z","normalized_code":"39347E"},{"id":2366827,"change_date":"2022-10-12 21:42:00","inspection_id":"76861758","insp_violation_id":"248998639","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"191413954","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:52.000000Z","updated_at":"2025-03-17T21:17:52.000000Z","normalized_code":"39347E"},{"id":2366828,"change_date":"2022-10-12 21:42:00","inspection_id":"76861758","insp_violation_id":"248998640","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"191413954","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:52.000000Z","updated_at":"2025-03-17T21:17:52.000000Z","normalized_code":"39347E"},{"id":2366829,"change_date":"2022-10-12 21:42:00","inspection_id":"76861758","insp_violation_id":"248998641","seq_no":"4","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"191413954","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:52.000000Z","updated_at":"2025-03-17T21:17:52.000000Z","normalized_code":"39353B"},{"id":2366830,"change_date":"2022-10-12 21:42:00","inspection_id":"76861758","insp_violation_id":"248998642","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"191413954","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"DA298723","created_at":"2025-03-17T21:17:52.000000Z","updated_at":"2025-03-17T21:17:52.000000Z","normalized_code":"3963A1"},{"id":2366831,"change_date":"2022-10-12 21:42:00","inspection_id":"76861758","insp_violation_id":"248998643","seq_no":"6","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"191413953","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:52.000000Z","updated_at":"2025-03-17T21:17:52.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":2418925,"change_date":"2022-10-12 21:42:00","inspection_id":"76861758","insp_unit_id":"191413953","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"75\/WHT","insp_unit_license":"9F50514","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5KJJAVDV5GLHB9128","insp_unit_decal":"Y","insp_unit_decal_number":"31836915","created_at":"2025-03-17T22:23:34.000000Z","updated_at":"2025-03-17T22:23:34.000000Z"},{"id":2418926,"change_date":"2022-10-12 21:42:00","inspection_id":"76861758","insp_unit_id":"191413954","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"T118\/TANK","insp_unit_license":"TJ4281","insp_unit_license_state":"ID","insp_unit_vehicle_id_number":"1PMS1432481034339","insp_unit_decal":"Y","insp_unit_decal_number":"31836916","created_at":"2025-03-17T22:23:34.000000Z","updated_at":"2025-03-17T22:23:34.000000Z"}]},{"id":1379400,"change_date":"2022-09-27 21:40:00","inspection_id":"76718761","dot_number":"2895103","report_state":"NV","report_number":"7194181167","insp_date":"2022-09-27 00:00:00","insp_start_time":"0750","insp_end_time":"0845","registration_date":null,"region":"PT","ci_status_code":"C","location":"2","location_desc":"GARSON","county_code_state":"NV","county_code":"031","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"WESTWAY FEED PRODUCTS","shipping_paper_number":"TFR-004371","cargo_tank":"NON","hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"139000","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":"722661","transaction_code":"A","transaction_date":"2022-09-27 00:00:00","upload_date":"2022-09-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02895103","upload_search_indicator":"M","census_search_date":"2022-09-27 21:40:00","snet_input_date":"2022-09-27 00:00:00","source_office":"4NVS001","mcmis_add_date":"2022-09-27 21:40:00","insp_carrier_name":"ANDRE FARMING CO INC","insp_carrier_street":"17493 AVE 20","insp_carrier_city":"MADERA","insp_carrier_state":"CA","insp_carrier_zip_code":"93637","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:52:02.000000Z","updated_at":"2025-03-17T18:52:02.000000Z","inspection_violations":[{"id":2180143,"change_date":"2022-09-27 21:40:00","inspection_id":"76718761","insp_violation_id":"248675586","seq_no":"1","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"191126675","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:01.000000Z","updated_at":"2025-03-17T21:17:01.000000Z","normalized_code":"39345D"},{"id":2180144,"change_date":"2022-09-27 21:40:00","inspection_id":"76718761","insp_violation_id":"248675587","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"191126675","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:17:01.000000Z","updated_at":"2025-03-17T21:17:01.000000Z","normalized_code":"3963A1"},{"id":2180145,"change_date":"2022-09-27 21:40:00","inspection_id":"76718761","insp_violation_id":"248675588","seq_no":"3","part_no":"392","part_no_section":"9a(a)(2)","insp_viol_unit":"1","insp_unit_id":"191126675","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:17:01.000000Z","updated_at":"2025-03-17T21:17:01.000000Z","normalized_code":"3929AA2"}],"inspection_per_units":[{"id":2221445,"change_date":"2022-09-27 21:40:00","inspection_id":"76718761","insp_unit_id":"191126675","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"XP77613","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD65FSGA6106","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:13.000000Z","updated_at":"2025-03-17T22:22:13.000000Z"},{"id":2221446,"change_date":"2022-09-27 21:40:00","inspection_id":"76718761","insp_unit_id":"191126676","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"T209","insp_unit_license":"TK4980","insp_unit_license_state":"ID","insp_unit_vehicle_id_number":"1UNST5345BS082454","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:13.000000Z","updated_at":"2025-03-17T22:22:13.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2895103\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2895103\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2895103\/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\/2895103\/inspections","per_page":100,"prev_page_url":null,"to":26,"total":26}