{"current_page":1,"data":[{"id":12385363,"change_date":"2026-07-08 21:41:00","inspection_id":"88348516","dot_number":"1687447","report_state":"CA","report_number":"UECR000518","insp_date":"2026-07-08 00:00:00","insp_start_time":"0940","insp_end_time":"1016","registration_date":null,"region":"PD","ci_status_code":"C","location":"859","location_desc":"CA","county_code_state":"CA","county_code":"047","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"E G PRIME FOODS INC","shipping_paper_number":"379368","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-08 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":"3709199","transaction_code":"A","transaction_date":"2026-07-08 00:00:00","upload_date":"2026-07-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01687447","upload_search_indicator":null,"census_search_date":"2026-07-08 21:41:00","snet_input_date":"2026-07-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-08 21:41:00","insp_carrier_name":"ADRIAN MERCADO","insp_carrier_street":"6203 ESTAVEZ ST","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93307","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-11T09:39:41.000000Z","updated_at":"2026-07-19T09:31:13.000000Z","inspection_violations":[{"id":21552976,"change_date":"2026-07-08 21:41:00","inspection_id":"88348516","insp_violation_id":"275360487","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"00SN001L1","created_at":"2026-07-11T09:57:04.000000Z","updated_at":"2026-07-19T09:43:15.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":21505699,"change_date":"2026-07-08 21:41:00","inspection_id":"88348516","insp_unit_id":"214499468","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"23\/WHI","insp_unit_license":"YP69571","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLDR0HSHZ9105","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-11T09:15:52.000000Z","updated_at":"2026-07-19T09:02:42.000000Z"},{"id":21505700,"change_date":"2026-07-08 21:41:00","inspection_id":"88348516","insp_unit_id":"214499469","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"R04","insp_unit_license":"4JP2735","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS24869U569101","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-11T09:15:52.000000Z","updated_at":"2026-07-19T09:02:42.000000Z"}]},{"id":10560505,"change_date":"2026-01-02 21:35:00","inspection_id":"86697803","dot_number":"1687447","report_state":"CA","report_number":"NF8B002480","insp_date":"2025-12-31 00:00:00","insp_start_time":"1044","insp_end_time":"1114","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":"STA ISABEL TRANSPORT","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":"N","pen_cen_match":null,"final_status_date":"2026-01-02 21:35: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":"16114841","transaction_code":"A","transaction_date":"2025-12-31 00:00:00","upload_date":"2026-01-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01687447","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-12-31 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-01-02 21:35:00","insp_carrier_name":"ADRIAN MERCADO","insp_carrier_street":"6203 ESTAVEZ ST","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93307","insp_colonia":null,"docket_number":"619842","insp_interstate":"Y","insp_carrier_state_id":"358430","created_at":"2026-01-05T10:33:40.000000Z","updated_at":"2026-01-13T10:30:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17692694,"change_date":"2026-01-02 21:35:00","inspection_id":"86697803","insp_unit_id":"210893924","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"WHT\/2R58","insp_unit_license":"4NC3782","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS24591U509601","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-05T10:05:10.000000Z","updated_at":"2026-01-13T10:00:57.000000Z"},{"id":17692693,"change_date":"2026-01-02 21:35:00","inspection_id":"86697803","insp_unit_id":"210893923","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHT\/23","insp_unit_license":"YP69571","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLDR0HSHZ9105","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-05T10:05:10.000000Z","updated_at":"2026-01-13T10:00:57.000000Z"}]},{"id":10321052,"change_date":"2025-12-01 21:39:00","inspection_id":"86447771","dot_number":"1687447","report_state":"CA","report_number":"NBH0009574","insp_date":"2025-11-24 00:00:00","insp_start_time":"0850","insp_end_time":"0913","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":"2025-12-01 21:39: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":"16071362","transaction_code":"A","transaction_date":"2025-11-24 00:00:00","upload_date":"2025-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01687447","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-11-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-01 21:39:00","insp_carrier_name":"ADRIAN MERCADO","insp_carrier_street":"6203 ESTAVEZ ST","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93307","insp_colonia":null,"docket_number":"619842","insp_interstate":"Y","insp_carrier_state_id":"358430","created_at":"2025-12-04T10:30:41.000000Z","updated_at":"2025-12-05T10:31:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17236469,"change_date":"2025-12-01 21:39:00","inspection_id":"86447771","insp_unit_id":"210336914","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"23\/WHT","insp_unit_license":"YP69571","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLDR0HSHZ9105","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-04T10:00:42.000000Z","updated_at":"2025-12-05T10:01:49.000000Z"},{"id":17236470,"change_date":"2025-12-01 21:39:00","inspection_id":"86447771","insp_unit_id":"210336915","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"R03\/WHT","insp_unit_license":"4NC3782","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS24591U509601","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-04T10:00:42.000000Z","updated_at":"2025-12-05T10:01:49.000000Z"}]},{"id":10049402,"change_date":"2025-10-27 21:39:00","inspection_id":"86162078","dot_number":"1687447","report_state":"CA","report_number":"UDM0002467","insp_date":"2025-10-26 00:00:00","insp_start_time":"2315","insp_end_time":"2330","registration_date":null,"region":"PT","ci_status_code":"C","location":"541","location_desc":"CASTAIC IF","county_code_state":"CA","county_code":"037","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-10-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16034097","transaction_code":"A","transaction_date":"2025-10-26 00:00:00","upload_date":"2025-10-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01687447","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-10-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-10-27 21:39:00","insp_carrier_name":"ADRIAN MERCADO","insp_carrier_street":"6203 ESTAVEZ ST","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93307","insp_colonia":null,"docket_number":"619842","insp_interstate":"Y","insp_carrier_state_id":"0358430","created_at":"2025-10-30T10:00:52.000000Z","updated_at":"2025-11-01T10:01:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16698080,"change_date":"2025-10-27 21:39:00","inspection_id":"86162078","insp_unit_id":"209682196","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHT\/23","insp_unit_license":"YP69571","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLDR0HSHZ9105","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-30T09:45:58.000000Z","updated_at":"2025-10-31T09:46:47.000000Z"},{"id":16698081,"change_date":"2025-10-27 21:39:00","inspection_id":"86162078","insp_unit_id":"209682197","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"R03","insp_unit_license":"4NC8782","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5HTAM2525F7D80353","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-30T09:45:58.000000Z","updated_at":"2025-10-31T09:46:47.000000Z"}]},{"id":6615844,"change_date":"2024-08-30 21:41:00","inspection_id":"82542097","dot_number":"1687447","report_state":"CA","report_number":"ND6B005627","insp_date":"2024-08-27 00:00:00","insp_start_time":"0938","insp_end_time":"1002","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":"CHAMBERLAIN GROUP","shipping_paper_number":"001238100072620","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-08-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15504098","transaction_code":"A","transaction_date":"2024-08-27 00:00:00","upload_date":"2024-08-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01687447","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-08-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-08-30 21:41:00","insp_carrier_name":"ADRIAN MERCADO","insp_carrier_street":"6203 ESTAVEZ ST","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93307","insp_colonia":null,"docket_number":"619842","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:34:06.000000Z","updated_at":"2025-03-17T20:34:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10666506,"change_date":"2024-08-30 21:41:00","inspection_id":"82542097","insp_unit_id":"202694741","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"23","insp_unit_license":"YP69571","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLDR0HSHZ9105","insp_unit_decal":"Y","insp_unit_decal_number":"34208855","created_at":"2025-03-17T23:33:28.000000Z","updated_at":"2025-03-17T23:33:28.000000Z"},{"id":10666507,"change_date":"2024-08-30 21:41:00","inspection_id":"82542097","insp_unit_id":"202694742","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"T53125","insp_unit_license":"4PK2590","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532WX6L011631","insp_unit_decal":"Y","insp_unit_decal_number":"34208856","created_at":"2025-03-17T23:33:28.000000Z","updated_at":"2025-03-17T23:33:28.000000Z"}]},{"id":5413962,"change_date":"2024-04-02 21:42:00","inspection_id":"81244793","dot_number":"1687447","report_state":"AZ","report_number":"6145000186","insp_date":"2024-03-27 00:00:00","insp_start_time":"1017","insp_end_time":"1050","registration_date":null,"region":"MS","ci_status_code":"C","location":null,"location_desc":"COCHISE AZ","county_code_state":"AZ","county_code":"003","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"S.F.S. CORP","shipping_paper_number":"S2024167","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-04-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":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"363595","transaction_code":"A","transaction_date":"2024-04-02 00:00:00","upload_date":"2024-04-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01687447","upload_search_indicator":null,"census_search_date":"2024-04-02 21:42:00","snet_input_date":"2024-03-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-04-02 21:42:00","insp_carrier_name":"ADRIAN MERCADO","insp_carrier_street":"6203 ESTAVEZ ST","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93307","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:09:53.000000Z","updated_at":"2025-03-17T20:09:53.000000Z","inspection_violations":[{"id":8357555,"change_date":"2024-04-02 21:42:00","inspection_id":"81244793","insp_violation_id":"258695120","seq_no":"1","part_no":"395","part_no_section":"24","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:26.000000Z","updated_at":"2025-03-17T21:46:26.000000Z","normalized_code":"39524"}],"inspection_per_units":[{"id":8719971,"change_date":"2024-04-02 21:42:00","inspection_id":"81244793","insp_unit_id":"200189352","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"23","insp_unit_license":"YP69571","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLDR0HSHZ9105","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:05.000000Z","updated_at":"2025-03-17T23:14:05.000000Z"},{"id":8719972,"change_date":"2024-04-02 21:42:00","inspection_id":"81244793","insp_unit_id":"200189353","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"53125","insp_unit_license":"4PK2590","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532WX6L011631","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:05.000000Z","updated_at":"2025-03-17T23:14:05.000000Z"}]},{"id":5253829,"change_date":"2024-03-11 21:42:00","inspection_id":"81070280","dot_number":"1687447","report_state":"AZ","report_number":"E970200025","insp_date":"2024-03-01 00:00:00","insp_start_time":"1835","insp_end_time":"1859","registration_date":null,"region":"MS","ci_status_code":"C","location":"AZEREB","location_desc":"EHRENBERG AZ","county_code_state":"AZ","county_code":"012","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"E & J GALLO WINERY","shipping_paper_number":"129481","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-03-11 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"299643","transaction_code":"A","transaction_date":"2024-03-07 00:00:00","upload_date":"2024-03-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01687447","upload_search_indicator":null,"census_search_date":"2024-03-11 21:42:00","snet_input_date":"2024-03-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-03-11 21:42:00","insp_carrier_name":"ADRIAN MERCADO","insp_carrier_street":"6203 ESTAVEZ ST","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93307","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:06:42.000000Z","updated_at":"2025-03-17T20:06:42.000000Z","inspection_violations":[{"id":8102769,"change_date":"2024-03-11 21:42:00","inspection_id":"81070280","insp_violation_id":"258305456","seq_no":"1","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"199842909","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:11.000000Z","updated_at":"2025-03-17T21:45:11.000000Z","normalized_code":"39360C"},{"id":8102770,"change_date":"2024-03-11 21:42:00","inspection_id":"81070280","insp_violation_id":"258305457","seq_no":"2","part_no":"395","part_no_section":"24","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:11.000000Z","updated_at":"2025-03-17T21:45:11.000000Z","normalized_code":"39524"}],"inspection_per_units":[{"id":8460194,"change_date":"2024-03-11 21:42:00","inspection_id":"81070280","insp_unit_id":"199842909","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"YP69571","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLDR0HSHZ9105","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:41.000000Z","updated_at":"2025-03-17T23:11:41.000000Z"},{"id":8460195,"change_date":"2024-03-11 21:42:00","inspection_id":"81070280","insp_unit_id":"199842910","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":null,"insp_unit_license":"4PK2590","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532WX6L011631","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:41.000000Z","updated_at":"2025-03-17T23:11:41.000000Z"}]},{"id":2607189,"change_date":"2023-03-17 21:43:00","inspection_id":"78124981","dot_number":"1687447","report_state":"CA","report_number":"NCVL004960","insp_date":"2023-03-14 00:00:00","insp_start_time":"1141","insp_end_time":"1213","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":"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-03-17 21:43: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":"14821266","transaction_code":"A","transaction_date":"2023-03-14 00:00:00","upload_date":"2023-03-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01687447","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-03-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-03-17 21:43:00","insp_carrier_name":"ADRIAN MERCADO","insp_carrier_street":"6203 ESTAVEZ ST","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93307","insp_colonia":null,"docket_number":"619842","insp_interstate":"Y","insp_carrier_state_id":"358430","created_at":"2025-03-17T19:14:50.000000Z","updated_at":"2025-03-17T19:14:50.000000Z","inspection_violations":[{"id":4012314,"change_date":"2023-03-17 21:43:00","inspection_id":"78124981","insp_violation_id":"251743433","seq_no":"1","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"193942575","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"VERBAL","created_at":"2025-03-17T21:25:48.000000Z","updated_at":"2025-03-17T21:25:48.000000Z","normalized_code":"39345"}],"inspection_per_units":[{"id":4196961,"change_date":"2023-03-17 21:43:00","inspection_id":"78124981","insp_unit_id":"193942575","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"23","insp_unit_license":"YP69571","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLDR0HSHZ9105","insp_unit_decal":"Y","insp_unit_decal_number":"32160472","created_at":"2025-03-17T22:36:06.000000Z","updated_at":"2025-03-17T22:36:06.000000Z"},{"id":4196962,"change_date":"2023-03-17 21:43:00","inspection_id":"78124981","insp_unit_id":"193942576","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"T53125","insp_unit_license":"4PK2590","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532WX6L011631","insp_unit_decal":"Y","insp_unit_decal_number":"32160471","created_at":"2025-03-17T22:36:06.000000Z","updated_at":"2025-03-17T22:36:06.000000Z"}]},{"id":2458550,"change_date":"2023-02-27 21:41:00","inspection_id":"77955732","dot_number":"1687447","report_state":"UT","report_number":"23RE000271","insp_date":"2023-02-24 00:00:00","insp_start_time":"1106","insp_end_time":"1125","registration_date":null,"region":"MT","ci_status_code":"C","location":"ST G","location_desc":"ST GEORGE PORT OF ENTRY NB","county_code_state":"UT","county_code":"053","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"GERBER CHILDRENS WEAR LLC","shipping_paper_number":"004721330017980","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-27 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":"874741","transaction_code":"A","transaction_date":"2023-02-24 00:00:00","upload_date":"2023-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01687447","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-02-24 00:00:00","source_office":"4UTS001","mcmis_add_date":"2023-02-27 21:41:00","insp_carrier_name":"ADRIAN MERCADO","insp_carrier_street":"6203 ESTAVEZ ST","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93307","insp_colonia":null,"docket_number":"619842","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:11:50.000000Z","updated_at":"2025-03-17T19:11:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3956926,"change_date":"2023-02-27 21:41:00","inspection_id":"77955732","insp_unit_id":"193599687","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"23","insp_unit_license":"YP69571","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLDR0HSHZ9105","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:21.000000Z","updated_at":"2025-03-17T22:34:21.000000Z"},{"id":3956927,"change_date":"2023-02-27 21:41:00","inspection_id":"77955732","insp_unit_id":"193599688","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"53125","insp_unit_license":"4PK2590","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532WX6L011631","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:21.000000Z","updated_at":"2025-03-17T22:34:21.000000Z"}]},{"id":1799600,"change_date":"2022-11-22 21:41:00","inspection_id":"77202826","dot_number":"1687447","report_state":"UT","report_number":"23RE000104","insp_date":"2022-11-19 00:00:00","insp_start_time":"1048","insp_end_time":"1120","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"ST GEORGE PORT OF ENTRY SB","county_code_state":"UT","county_code":"053","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CIRCLE C SIX","shipping_paper_number":"135017","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-11-22 21:41: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":"865648","transaction_code":"A","transaction_date":"2022-11-19 00:00:00","upload_date":"2022-11-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01687447","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-11-19 00:00:00","source_office":"4UTS001","mcmis_add_date":"2022-11-22 21:41:00","insp_carrier_name":"ADRIAN MERCADO","insp_carrier_street":"6203 ESTAVEZ ST","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93307","insp_colonia":null,"docket_number":"619842","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:59:42.000000Z","updated_at":"2025-03-17T18:59:42.000000Z","inspection_violations":[{"id":2813969,"change_date":"2022-11-22 21:41:00","inspection_id":"77202826","insp_violation_id":"249749705","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"N225200923","created_at":"2025-03-17T21:20:16.000000Z","updated_at":"2025-03-17T21:20:16.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2894887,"change_date":"2022-11-22 21:41:00","inspection_id":"77202826","insp_unit_id":"192094418","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2012","insp_unit_license":"XP62332","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLCK99LAE0109","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:48.000000Z","updated_at":"2025-03-17T22:26:48.000000Z"},{"id":2894888,"change_date":"2022-11-22 21:41:00","inspection_id":"77202826","insp_unit_id":"192094419","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"53125","insp_unit_license":"4PK2590","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532WX6L011631","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:48.000000Z","updated_at":"2025-03-17T22:26:48.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1687447\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1687447\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1687447\/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\/1687447\/inspections","per_page":100,"prev_page_url":null,"to":10,"total":10}