{"current_page":1,"data":[{"id":12035781,"change_date":"2026-05-28 21:41:00","inspection_id":"87976103","dot_number":"2117962","report_state":"CA","report_number":"UE03004906","insp_date":"2026-05-26 00:00:00","insp_start_time":"1715","insp_end_time":"1749","registration_date":null,"region":"PS","ci_status_code":"C","location":"391","location_desc":"CA","county_code_state":"CA","county_code":"001","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":"U","pen_cen_match":"I","final_status_date":"2026-05-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"3417442","transaction_code":"A","transaction_date":"2026-05-28 00:00:00","upload_date":"2026-05-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02117962","upload_search_indicator":null,"census_search_date":"2026-05-28 21:41:00","snet_input_date":"2026-05-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-28 21:41:00","insp_carrier_name":"BAY EXPRESS INC","insp_carrier_street":"1259 MAGIC SANDS WAY","insp_carrier_city":"TURLOCK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-01T09:39:50.000000Z","updated_at":"2026-06-08T09:30:39.000000Z","inspection_violations":[{"id":20944329,"change_date":"2026-05-28 21:41:00","inspection_id":"87976103","insp_violation_id":"274547249","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"213788791","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-06-01T09:59:03.000000Z","updated_at":"2026-06-08T09:42:13.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":20919715,"change_date":"2026-05-28 21:41:00","inspection_id":"87976103","insp_unit_id":"213788791","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"143 RED","insp_unit_license":"ZP36254","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLDR3KSKD3780","insp_unit_decal":"Y","insp_unit_decal_number":"36187322","created_at":"2026-06-01T09:17:01.000000Z","updated_at":"2026-06-08T09:02:07.000000Z"}]},{"id":11774688,"change_date":"2026-04-28 21:40:00","inspection_id":"87705646","dot_number":"2117962","report_state":"CA","report_number":"UEQG004059","insp_date":"2026-04-28 00:00:00","insp_start_time":"0740","insp_end_time":"0806","registration_date":null,"region":"PT","ci_status_code":"C","location":"420","location_desc":"N\/B SR-99 N\/O LERDO","county_code_state":"CA","county_code":"029","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"DEBUT DEVELOPMENT","shipping_paper_number":"8VO63MET","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16266815","transaction_code":"A","transaction_date":"2026-04-28 00:00:00","upload_date":"2026-04-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02117962","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-04-28 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-04-28 21:40:00","insp_carrier_name":"BAY EXPRESS INC","insp_carrier_street":"1259 MAGIC SANDS WAY","insp_carrier_city":"TURLOCK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"738202","insp_interstate":"Y","insp_carrier_state_id":"568777","created_at":"2026-05-01T09:40:36.000000Z","updated_at":"2026-05-09T09:31:32.000000Z","inspection_violations":[{"id":20474855,"change_date":"2026-04-28 21:40:00","inspection_id":"87705646","insp_violation_id":"273917686","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":"RW43564","created_at":"2026-05-01T10:02:31.000000Z","updated_at":"2026-05-09T09:43:23.000000Z","normalized_code":"3922SLLS2"},{"id":20474856,"change_date":"2026-04-28 21:40:00","inspection_id":"87705646","insp_violation_id":"273917687","seq_no":"2","part_no":"395","part_no_section":"24D-ELDPT","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-01T10:02:31.000000Z","updated_at":"2026-05-09T09:43:23.000000Z","normalized_code":"39524DELDPT"}],"inspection_per_units":[{"id":20484431,"change_date":"2026-04-28 21:40:00","inspection_id":"87705646","insp_unit_id":"213277496","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"139","insp_unit_license":"ZP25012","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD51FSGG3409","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-01T09:21:07.000000Z","updated_at":"2026-05-09T09:04:26.000000Z"},{"id":20484432,"change_date":"2026-04-28 21:40:00","inspection_id":"87705646","insp_unit_id":"213277497","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"145","insp_unit_license":"4VE3138","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H3V532C5KR437742","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-01T09:21:07.000000Z","updated_at":"2026-05-09T09:04:26.000000Z"}]},{"id":11876003,"change_date":"2026-05-11 21:39:00","inspection_id":"87813323","dot_number":"2117962","report_state":"MS","report_number":"3003011128","insp_date":"2026-04-26 00:00:00","insp_start_time":"0732","insp_end_time":"0755","registration_date":null,"region":"CT","ci_status_code":"C","location":"Y-99","location_desc":"BOVINA SCALE I-20 EAST","county_code_state":"MS","county_code":"149","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"RESTORATION HARDWARE","shipping_paper_number":"205092707","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-05-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":null,"viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1145950","transaction_code":"A","transaction_date":"2026-04-26 00:00:00","upload_date":"2026-05-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02117962","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-05-07 00:00:00","source_office":"2MSS002","mcmis_add_date":"2026-05-11 21:39:00","insp_carrier_name":"BAY EXPRESS INC","insp_carrier_street":"1259 MAGIC SANDS WAY","insp_carrier_city":"TURLOCK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"738202","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-13T13:15:29.000000Z","updated_at":"2026-05-22T09:31:00.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20649400,"change_date":"2026-05-11 21:39:00","inspection_id":"87813323","insp_unit_id":"213484317","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"143","insp_unit_license":"ZP36254","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLDR3KSKD3780","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-13T13:05:14.000000Z","updated_at":"2026-05-22T09:03:41.000000Z"},{"id":20649401,"change_date":"2026-05-11 21:39:00","inspection_id":"87813323","insp_unit_id":"213484318","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"404","insp_unit_license":"4UN5028","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H3V532CXGT101045","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-13T13:05:14.000000Z","updated_at":"2026-05-22T09:03:41.000000Z"}]},{"id":11751706,"change_date":"2026-04-26 21:33:00","inspection_id":"87681573","dot_number":"2117962","report_state":"AZ","report_number":"4308002483","insp_date":"2026-04-24 00:00:00","insp_start_time":"0543","insp_end_time":"0630","registration_date":null,"region":"MS","ci_status_code":"C","location":null,"location_desc":"KINGMAN AZ","county_code_state":"AZ","county_code":"015","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"RESTORATION HARDWARE","shipping_paper_number":"205092707","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-04-26 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"121220","viol_total":"3","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3214527","transaction_code":"A","transaction_date":"2026-04-25 00:00:00","upload_date":"2026-04-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02117962","upload_search_indicator":null,"census_search_date":"2026-04-26 21:33:00","snet_input_date":"2026-04-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-26 21:33:00","insp_carrier_name":"BAY EXPRESS INC","insp_carrier_street":"1259 MAGIC SANDS WAY","insp_carrier_city":"TURLOCK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-29T09:40:12.000000Z","updated_at":"2026-05-07T09:30:08.000000Z","inspection_violations":[{"id":20432783,"change_date":"2026-04-26 21:33:00","inspection_id":"87681573","insp_violation_id":"273861774","seq_no":"1","part_no":"393","part_no_section":"55C2-B","insp_viol_unit":"2","insp_unit_id":"213231415","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-29T10:00:01.000000Z","updated_at":"2026-05-07T09:39:12.000000Z","normalized_code":"39355C2B"},{"id":20432784,"change_date":"2026-04-26 21:33:00","inspection_id":"87681573","insp_violation_id":"273861775","seq_no":"2","part_no":"395","part_no_section":"22G-ELDMFV","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-29T10:00:01.000000Z","updated_at":"2026-05-07T09:39:12.000000Z","normalized_code":"39522GELDMFV"},{"id":20432785,"change_date":"2026-04-26 21:33:00","inspection_id":"87681573","insp_violation_id":"273861776","seq_no":"3","part_no":"392","part_no_section":"2-SLLSIV","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-29T10:00:01.000000Z","updated_at":"2026-05-07T09:39:12.000000Z","normalized_code":"3922SLLSIV"}],"inspection_per_units":[{"id":20446405,"change_date":"2026-04-26 21:33:00","inspection_id":"87681573","insp_unit_id":"213231414","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"143","insp_unit_license":"ZP36254","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLDR3KSKD3780","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-29T09:17:43.000000Z","updated_at":"2026-05-07T09:02:06.000000Z"},{"id":20446406,"change_date":"2026-04-26 21:33:00","inspection_id":"87681573","insp_unit_id":"213231415","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"404","insp_unit_license":"4UN5028","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H3V532CXGT101045","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-29T09:17:43.000000Z","updated_at":"2026-05-07T09:02:06.000000Z"}]},{"id":11753244,"change_date":"2026-04-26 21:33:00","inspection_id":"87683197","dot_number":"2117962","report_state":"GA","report_number":"1332000922","insp_date":"2026-04-23 00:00:00","insp_start_time":"2259","insp_end_time":"2323","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MORROW GA","county_code_state":"GA","county_code":"063","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"RADEFF DESIGN STUDIOS","shipping_paper_number":"3329151","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-04-26 21:33: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":"3215852","transaction_code":"A","transaction_date":"2026-04-26 00:00:00","upload_date":"2026-04-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02117962","upload_search_indicator":null,"census_search_date":"2026-04-26 21:33:00","snet_input_date":"2026-04-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-26 21:33:00","insp_carrier_name":"BAY EXPRESS INC","insp_carrier_street":"1259 MAGIC SANDS WAY","insp_carrier_city":"TURLOCK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-29T09:40:16.000000Z","updated_at":"2026-05-07T09:30:21.000000Z","inspection_violations":[{"id":20435668,"change_date":"2026-04-26 21:33:00","inspection_id":"87683197","insp_violation_id":"273865042","seq_no":"1","part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"W02E112500","created_at":"2026-04-29T10:00:06.000000Z","updated_at":"2026-05-07T09:39:38.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":20448955,"change_date":"2026-04-26 21:33:00","inspection_id":"87683197","insp_unit_id":"213234169","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"405","insp_unit_license":"4VE3138","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H3V532C5KR437742","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-29T09:17:47.000000Z","updated_at":"2026-05-07T09:02:28.000000Z"},{"id":20448956,"change_date":"2026-04-26 21:33:00","inspection_id":"87683197","insp_unit_id":"213234170","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"139","insp_unit_license":"ZP25012","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD51FSGG3409","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-29T09:17:47.000000Z","updated_at":"2026-05-07T09:02:28.000000Z"}]},{"id":10850565,"change_date":"2026-01-23 21:40:00","inspection_id":"86879496","dot_number":"2117962","report_state":"CA","report_number":"NB9A004712","insp_date":"2026-01-23 00:00:00","insp_start_time":"0800","insp_end_time":"0900","registration_date":null,"region":"PT","ci_status_code":"C","location":"465","location_desc":"305 N KILROY RD","county_code_state":"CA","county_code":"099","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":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-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"121220","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":"16142550","transaction_code":"A","transaction_date":"2026-01-23 00:00:00","upload_date":"2026-01-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02117962","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-01-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-01-23 21:40:00","insp_carrier_name":"BAY EXPRESS INC","insp_carrier_street":"1259 MAGIC SANDS WAY","insp_carrier_city":"TURLOCK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"738202","insp_interstate":"Y","insp_carrier_state_id":"568777","created_at":"2026-01-26T10:37:39.000000Z","updated_at":"2026-02-03T10:30:53.000000Z","inspection_violations":[{"id":18151513,"change_date":"2026-01-23 21:40:00","inspection_id":"86879496","insp_violation_id":"271405155","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"211269440","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-26T10:43:44.000000Z","updated_at":"2026-02-04T10:36:38.000000Z","normalized_code":"39347E"},{"id":18151514,"change_date":"2026-01-23 21:40:00","inspection_id":"86879496","insp_violation_id":"271405156","seq_no":"2","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"2","insp_unit_id":"211269440","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-26T10:43:44.000000Z","updated_at":"2026-02-04T10:36:38.000000Z","normalized_code":"39353BB"}],"inspection_per_units":[{"id":18230857,"change_date":"2026-01-23 21:40:00","inspection_id":"86879496","insp_unit_id":"211269439","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"143","insp_unit_license":"ZP36254","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLDR3KSKD3780","insp_unit_decal":"Y","insp_unit_decal_number":"35891611","created_at":"2026-01-26T10:10:00.000000Z","updated_at":"2026-02-03T10:03:22.000000Z"},{"id":18230858,"change_date":"2026-01-23 21:40:00","inspection_id":"86879496","insp_unit_id":"211269440","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"404","insp_unit_license":"4UN5028","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H3V532CXGT101045","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-26T10:10:00.000000Z","updated_at":"2026-02-03T10:03:22.000000Z"}]},{"id":10850655,"change_date":"2026-01-23 21:40:00","inspection_id":"86879588","dot_number":"2117962","report_state":"CA","report_number":"NB9A004713","insp_date":"2026-01-23 00:00:00","insp_start_time":"0900","insp_end_time":"1000","registration_date":null,"region":"PT","ci_status_code":"C","location":"465","location_desc":"305 N KILROY RD","county_code_state":"CA","county_code":"099","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":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-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16142562","transaction_code":"A","transaction_date":"2026-01-23 00:00:00","upload_date":"2026-01-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02117962","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-01-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-01-23 21:40:00","insp_carrier_name":"BAY EXPRESS INC","insp_carrier_street":"1259 MAGIC SANDS WAY","insp_carrier_city":"TURLOCK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"738202","insp_interstate":"Y","insp_carrier_state_id":"568777","created_at":"2026-01-26T10:37:39.000000Z","updated_at":"2026-02-03T10:30:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18231008,"change_date":"2026-01-23 21:40:00","inspection_id":"86879588","insp_unit_id":"211269604","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"141","insp_unit_license":"YP62819","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJHHDR6KLKE3838","insp_unit_decal":"Y","insp_unit_decal_number":"35891612","created_at":"2026-01-26T10:10:00.000000Z","updated_at":"2026-02-03T10:03:22.000000Z"},{"id":18231009,"change_date":"2026-01-23 21:40:00","inspection_id":"86879588","insp_unit_id":"211269605","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"403","insp_unit_license":"4TT6091","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2536FP223305","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-26T10:10:00.000000Z","updated_at":"2026-02-03T10:03:22.000000Z"}]},{"id":10850564,"change_date":"2026-01-23 21:40:00","inspection_id":"86879495","dot_number":"2117962","report_state":"CA","report_number":"NB9A004711","insp_date":"2026-01-09 00:00:00","insp_start_time":"0800","insp_end_time":"0900","registration_date":null,"region":"PT","ci_status_code":"C","location":"465","location_desc":"305 N KILROY RD","county_code_state":"CA","county_code":"099","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":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-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"58800","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":"16142785","transaction_code":"A","transaction_date":"2026-01-23 00:00:00","upload_date":"2026-01-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02117962","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-01-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-01-23 21:40:00","insp_carrier_name":"BAY EXPRESS INC","insp_carrier_street":"1259 MAGIC SANDS WAY","insp_carrier_city":"TURLOCK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"738202","insp_interstate":"Y","insp_carrier_state_id":"568777","created_at":"2026-01-26T10:37:39.000000Z","updated_at":"2026-02-03T10:30:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18230855,"change_date":"2026-01-23 21:40:00","inspection_id":"86879495","insp_unit_id":"211269437","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"139","insp_unit_license":"ZP25012","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD51FSGG3409","insp_unit_decal":"Y","insp_unit_decal_number":"35891589","created_at":"2026-01-26T10:10:00.000000Z","updated_at":"2026-02-03T10:03:22.000000Z"},{"id":18230856,"change_date":"2026-01-23 21:40:00","inspection_id":"86879495","insp_unit_id":"211269438","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"405","insp_unit_license":"4VE3138","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H3V532C5KR437742","insp_unit_decal":"Y","insp_unit_decal_number":"35891590","created_at":"2026-01-26T10:10:00.000000Z","updated_at":"2026-02-03T10:03:22.000000Z"}]},{"id":9985482,"change_date":"2025-10-20 21:39:00","inspection_id":"86094934","dot_number":"2117962","report_state":"NM","report_number":"6242P81N6F","insp_date":"2025-10-16 00:00:00","insp_start_time":"1806","insp_end_time":"1819","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"GALLUP PORT OF ENTRY","county_code_state":"NM","county_code":"031","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"RESTORATION HARDWARE","shipping_paper_number":"196955268","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-10-20 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":"2225113","transaction_code":"A","transaction_date":"2025-10-17 00:00:00","upload_date":"2025-10-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02117962","upload_search_indicator":null,"census_search_date":"2025-10-20 21:39:00","snet_input_date":"2025-10-20 00:00:00","source_office":"2NMS001","mcmis_add_date":"2025-10-20 21:39:00","insp_carrier_name":"BAY EXPRESS INC","insp_carrier_street":"P O BOX 1811","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-23T10:00:40.000000Z","updated_at":"2025-10-24T10:00:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16581405,"change_date":"2025-10-20 21:39:00","inspection_id":"86094934","insp_unit_id":"209554873","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"UNIT 141","insp_unit_license":"YP62819","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJHHDR6KLKE3838","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-23T09:45:43.000000Z","updated_at":"2025-10-24T09:46:06.000000Z"},{"id":16581406,"change_date":"2025-10-20 21:39:00","inspection_id":"86094934","insp_unit_id":"209554874","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"UNIT 403","insp_unit_license":"4TT6091","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2536FP223305","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-23T09:45:43.000000Z","updated_at":"2025-10-24T09:46:06.000000Z"}]},{"id":9953613,"change_date":"2025-10-15 21:40:00","inspection_id":"86061314","dot_number":"2117962","report_state":"CA","report_number":"UCSG000287","insp_date":"2025-10-14 00:00:00","insp_start_time":"1338","insp_end_time":"1352","registration_date":null,"region":"PT","ci_status_code":"C","location":"223","location_desc":"DONNER PASS IF","county_code_state":"CA","county_code":"057","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-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16019281","transaction_code":"A","transaction_date":"2025-10-14 00:00:00","upload_date":"2025-10-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02117962","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-10-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-10-15 21:40:00","insp_carrier_name":"BAY EXPRESS INC","insp_carrier_street":"1259 MAGIC SANDS WAY","insp_carrier_city":"TURLOCK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"738202","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-18T10:02:01.000000Z","updated_at":"2025-10-19T10:01:20.000000Z","inspection_violations":[{"id":16434949,"change_date":"2025-10-15 21:40:00","inspection_id":"86061314","insp_violation_id":"269326829","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"209492917","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-18T10:18:14.000000Z","updated_at":"2025-10-19T10:17:15.000000Z","normalized_code":"3922SLLSR"},{"id":16434950,"change_date":"2025-10-15 21:40:00","inspection_id":"86061314","insp_violation_id":"269326830","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"209492917","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA482941","created_at":"2025-10-18T10:18:14.000000Z","updated_at":"2025-10-19T10:17:15.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":16523923,"change_date":"2025-10-15 21:40:00","inspection_id":"86061314","insp_unit_id":"209492917","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"YP62819","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJHHDR6KLKE3838","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-18T09:47:19.000000Z","updated_at":"2025-10-19T09:46:38.000000Z"},{"id":16523924,"change_date":"2025-10-15 21:40:00","inspection_id":"86061314","insp_unit_id":"209492918","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":null,"insp_unit_license":"4UN5028","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H3V532CXGT101045","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-18T09:47:19.000000Z","updated_at":"2025-10-19T09:46:38.000000Z"}]},{"id":9950213,"change_date":"2025-10-15 21:39:00","inspection_id":"86057782","dot_number":"2117962","report_state":"NM","report_number":"3563P7XFD2","insp_date":"2025-10-12 00:00:00","insp_start_time":"1147","insp_end_time":"1207","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"LORDSBURG PORT OF ENTRY","county_code_state":"NM","county_code":"023","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"NETAFIM USA","shipping_paper_number":"5700565765","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-10-15 21:39: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":"2223753","transaction_code":"A","transaction_date":"2025-10-12 00:00:00","upload_date":"2025-10-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02117962","upload_search_indicator":null,"census_search_date":"2025-10-15 21:39:00","snet_input_date":"2025-10-14 00:00:00","source_office":"2NMS001","mcmis_add_date":"2025-10-15 21:39:00","insp_carrier_name":"BAY EXPRESS INC","insp_carrier_street":"P O BOX 1811","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-18T10:01:57.000000Z","updated_at":"2025-10-19T10:01:00.000000Z","inspection_violations":[{"id":16428786,"change_date":"2025-10-15 21:39:00","inspection_id":"86057782","insp_violation_id":"269317824","seq_no":"1","part_no":"393","part_no_section":"207B","insp_viol_unit":"2","insp_unit_id":"209486060","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-18T10:18:03.000000Z","updated_at":"2025-10-19T10:16:36.000000Z","normalized_code":"393207B"}],"inspection_per_units":[{"id":16518387,"change_date":"2025-10-15 21:39:00","inspection_id":"86057782","insp_unit_id":"209486059","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"UNIT143","insp_unit_license":"ZP36254","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLDR3KSKD3780","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-18T09:47:14.000000Z","updated_at":"2025-10-19T09:46:12.000000Z"},{"id":16518388,"change_date":"2025-10-15 21:39:00","inspection_id":"86057782","insp_unit_id":"209486060","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"UNIT404","insp_unit_license":"4UN5028","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H3V532CXGT101045","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-18T09:47:14.000000Z","updated_at":"2025-10-19T09:46:12.000000Z"}]},{"id":9848521,"change_date":"2025-10-03 21:39:00","inspection_id":"85950330","dot_number":"2117962","report_state":"LA","report_number":"LALNS00908","insp_date":"2025-10-02 00:00:00","insp_start_time":"0535","insp_end_time":"0556","registration_date":null,"region":"CD","ci_status_code":"C","location":"87","location_desc":"ARCADIA LA","county_code_state":"LA","county_code":"013","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-10-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2362996","transaction_code":"A","transaction_date":"2025-10-03 00:00:00","upload_date":"2025-10-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02117962","upload_search_indicator":null,"census_search_date":"2025-10-03 21:39:00","snet_input_date":"2025-10-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-03 21:39:00","insp_carrier_name":"BAY EXPRESS INC","insp_carrier_street":"1259 MAGIC SANDS WAY","insp_carrier_city":"TURLOCK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-05T10:02:17.000000Z","updated_at":"2025-10-08T10:00:45.000000Z","inspection_violations":[{"id":16219372,"change_date":"2025-10-03 21:39:00","inspection_id":"85950330","insp_violation_id":"269080839","seq_no":"1","part_no":"392","part_no_section":"22A-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-05T10:18:12.000000Z","updated_at":"2025-10-08T10:16:16.000000Z","normalized_code":"39222AD"},{"id":16219373,"change_date":"2025-10-03 21:39:00","inspection_id":"85950330","insp_violation_id":"269080840","seq_no":"2","part_no":"392","part_no_section":"22B-DFPWD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-05T10:18:12.000000Z","updated_at":"2025-10-08T10:16:16.000000Z","normalized_code":"39222BDFPWD"}],"inspection_per_units":[{"id":16332521,"change_date":"2025-10-03 21:39:00","inspection_id":"85950330","insp_unit_id":"209284672","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"143","insp_unit_license":"ZP36254","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLDR3KSKD3780","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-05T09:47:14.000000Z","updated_at":"2025-10-08T09:45:54.000000Z"},{"id":16332522,"change_date":"2025-10-03 21:39:00","inspection_id":"85950330","insp_unit_id":"209284673","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"404","insp_unit_license":"4UN5028","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H3V532CXGT101045","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-05T09:47:14.000000Z","updated_at":"2025-10-08T09:45:54.000000Z"}]},{"id":9670625,"change_date":"2025-09-12 21:50:00","inspection_id":"85763673","dot_number":"2117962","report_state":"CA","report_number":"NCNY007850","insp_date":"2025-08-21 00:00:00","insp_start_time":"0800","insp_end_time":"0901","registration_date":null,"region":"PT","ci_status_code":"C","location":"465","location_desc":"305 N KILROY","county_code_state":"CA","county_code":"099","insp_level_id":"5","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":"2025-09-12 21:50: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":"15978544","transaction_code":"A","transaction_date":"2025-08-29 00:00:00","upload_date":"2025-09-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02117962","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-08-21 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-12 21:50:00","insp_carrier_name":"BAY EXPRESS INC","insp_carrier_street":"1259 MAGIC SANDS WAY","insp_carrier_city":"TURLOCK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"738202","insp_interstate":"Y","insp_carrier_state_id":"568777","created_at":"2025-09-16T10:48:42.000000Z","updated_at":"2025-09-16T10:48:42.000000Z","inspection_violations":[{"id":15854894,"change_date":"2025-09-12 21:50:00","inspection_id":"85763673","insp_violation_id":"268670286","seq_no":"1","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"2","insp_unit_id":"208930726","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-14T11:58:20.000000Z","updated_at":"2025-09-16T10:51:56.000000Z","normalized_code":"39345DB"}],"inspection_per_units":[{"id":16003515,"change_date":"2025-09-12 21:50:00","inspection_id":"85763673","insp_unit_id":"208930725","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"139\/RED","insp_unit_license":"ZP25012","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD51FSGG3409","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-15T09:54:04.000000Z","updated_at":"2025-09-16T09:56:41.000000Z"},{"id":16003516,"change_date":"2025-09-12 21:50:00","inspection_id":"85763673","insp_unit_id":"208930726","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"405\/VAN","insp_unit_license":"4VE3138","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H3V532C5KR437742","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-15T09:54:04.000000Z","updated_at":"2025-09-16T09:56:41.000000Z"}]},{"id":9275559,"change_date":"2025-07-29 21:39:00","inspection_id":"85348623","dot_number":"2117962","report_state":"KY","report_number":"CV44395917","insp_date":"2025-07-29 00:00:00","insp_start_time":"1231","insp_end_time":"1313","registration_date":null,"region":"CT","ci_status_code":"C","location":"9813","location_desc":"EDDYVILLE","county_code_state":"KY","county_code":"143","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"SNAK KING","shipping_paper_number":"104565","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-07-29 21:39: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":"2294640","transaction_code":"A","transaction_date":"2025-07-29 00:00:00","upload_date":"2025-07-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02117962","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-07-29 00:00:00","source_office":"2KYS001","mcmis_add_date":"2025-07-29 21:39:00","insp_carrier_name":"BAY EXPRESS INC","insp_carrier_street":"1259 MAGIC SANDS WAY","insp_carrier_city":"TURLOCK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"738202","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-01T10:42:05.000000Z","updated_at":"2025-08-04T10:00:35.000000Z","inspection_violations":[{"id":15035010,"change_date":"2025-07-29 21:39:00","inspection_id":"85348623","insp_violation_id":"267719079","seq_no":"1","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"208134031","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-01T10:44:20.000000Z","updated_at":"2025-08-02T10:42:40.000000Z","normalized_code":"3939ALFTSI"},{"id":15035011,"change_date":"2025-07-29 21:39:00","inspection_id":"85348623","insp_violation_id":"267719080","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"208134032","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-01T10:44:20.000000Z","updated_at":"2025-08-02T10:42:40.000000Z","normalized_code":"39347E"}],"inspection_per_units":[{"id":15269256,"change_date":"2025-07-29 21:39:00","inspection_id":"85348623","insp_unit_id":"208134031","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"143","insp_unit_license":"ZP36254","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLDR3KSKD3780","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-01T09:45:44.000000Z","updated_at":"2025-08-02T09:45:43.000000Z"},{"id":15269257,"change_date":"2025-07-29 21:39:00","inspection_id":"85348623","insp_unit_id":"208134032","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"404","insp_unit_license":"4UN5028","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H3V532CXGT101045","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-01T09:45:44.000000Z","updated_at":"2025-08-02T09:45:43.000000Z"}]},{"id":9213942,"change_date":"2025-07-22 21:42:00","inspection_id":"85283716","dot_number":"2117962","report_state":"SD","report_number":"5640000538","insp_date":"2025-07-21 00:00:00","insp_start_time":"1800","insp_end_time":"1854","registration_date":null,"region":"MD","ci_status_code":"C","location":"TILFRD","location_desc":"TILFORD SD","county_code_state":"SD","county_code":"093","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CONSOLIDATED ELECTRICAL DISTRIBUTORS","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-07-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"122999","viol_total":"17","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2025759","transaction_code":"A","transaction_date":"2025-07-22 00:00:00","upload_date":"2025-07-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02117962","upload_search_indicator":null,"census_search_date":"2025-07-22 21:42:00","snet_input_date":"2025-07-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-22 21:42:00","insp_carrier_name":"BAY EXPRESS INC","insp_carrier_street":"1259 MAGIC SANDS WAY","insp_carrier_city":"TURLOCK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-25T10:45:58.000000Z","updated_at":"2025-07-27T10:40:49.000000Z","inspection_violations":[{"id":14903754,"change_date":"2025-07-22 21:42:00","inspection_id":"85283716","insp_violation_id":"267568083","seq_no":"1","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"2","insp_unit_id":"208007959","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-07-25T10:47:35.000000Z","updated_at":"2025-07-26T10:42:34.000000Z","normalized_code":"39353BB"},{"id":14903755,"change_date":"2025-07-22 21:42:00","inspection_id":"85283716","insp_violation_id":"267568084","seq_no":"2","part_no":"393","part_no_section":"55E-B","insp_viol_unit":"2","insp_unit_id":"208007959","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-07-25T10:47:35.000000Z","updated_at":"2025-07-26T10:42:34.000000Z","normalized_code":"39355EB"},{"id":14903756,"change_date":"2025-07-22 21:42:00","inspection_id":"85283716","insp_violation_id":"267568085","seq_no":"3","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"1","insp_unit_id":"208007958","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-07-25T10:47:35.000000Z","updated_at":"2025-07-26T10:42:34.000000Z","normalized_code":"3939ALLPL"},{"id":14903757,"change_date":"2025-07-22 21:42:00","inspection_id":"85283716","insp_violation_id":"267568086","seq_no":"4","part_no":"393","part_no_section":"47A-BCLMBD","insp_viol_unit":"1","insp_unit_id":"208007958","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-25T10:47:35.000000Z","updated_at":"2025-07-26T10:42:34.000000Z","normalized_code":"39347ABCLMBD"},{"id":14903758,"change_date":"2025-07-22 21:42:00","inspection_id":"85283716","insp_violation_id":"267568087","seq_no":"5","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"208007959","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-07-25T10:47:35.000000Z","updated_at":"2025-07-26T10:42:34.000000Z","normalized_code":"39347E"},{"id":14903759,"change_date":"2025-07-22 21:42:00","inspection_id":"85283716","insp_violation_id":"267568088","seq_no":"6","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"208007959","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-07-25T10:47:35.000000Z","updated_at":"2025-07-26T10:42:34.000000Z","normalized_code":"39347E"},{"id":14903760,"change_date":"2025-07-22 21:42:00","inspection_id":"85283716","insp_violation_id":"267568089","seq_no":"7","part_no":"393","part_no_section":"201A-FRMC","insp_viol_unit":"2","insp_unit_id":"208007959","insp_violation_category_id":"19","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"WARNING","created_at":"2025-07-25T10:47:35.000000Z","updated_at":"2025-07-26T10:42:34.000000Z","normalized_code":"393201AFRMC"},{"id":14903761,"change_date":"2025-07-22 21:42:00","inspection_id":"85283716","insp_violation_id":"267568090","seq_no":"8","part_no":"393","part_no_section":"201A-VLRB","insp_viol_unit":"2","insp_unit_id":"208007959","insp_violation_category_id":"19","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"B1244783-HP","created_at":"2025-07-25T10:47:35.000000Z","updated_at":"2025-07-26T10:42:34.000000Z","normalized_code":"393201AVLRB"},{"id":14903762,"change_date":"2025-07-22 21:42:00","inspection_id":"85283716","insp_violation_id":"267568091","seq_no":"9","part_no":"393","part_no_section":"207A-SAPPCBLM","insp_viol_unit":"2","insp_unit_id":"208007959","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-07-25T10:47:35.000000Z","updated_at":"2025-07-26T10:42:34.000000Z","normalized_code":"393207ASAPPCBLM"},{"id":14903763,"change_date":"2025-07-22 21:42:00","inspection_id":"85283716","insp_violation_id":"267568092","seq_no":"10","part_no":"395","part_no_section":"8E-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"B1244783-HP","created_at":"2025-07-25T10:47:35.000000Z","updated_at":"2025-07-26T10:42:34.000000Z","normalized_code":"3958EHOSPD"},{"id":14903764,"change_date":"2025-07-22 21:42:00","inspection_id":"85283716","insp_violation_id":"267568093","seq_no":"11","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"2","insp_unit_id":"208007959","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"B1244783-HP","created_at":"2025-07-25T10:47:35.000000Z","updated_at":"2025-07-26T10:42:34.000000Z","normalized_code":"3963A1BOS"},{"id":14903765,"change_date":"2025-07-22 21:42:00","inspection_id":"85283716","insp_violation_id":"267568094","seq_no":"12","part_no":"393","part_no_section":"28-WS-6","insp_viol_unit":"2","insp_unit_id":"208007959","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-07-25T10:47:35.000000Z","updated_at":"2025-07-26T10:42:34.000000Z","normalized_code":"39328WS6"},{"id":14903766,"change_date":"2025-07-22 21:42:00","inspection_id":"85283716","insp_violation_id":"267568095","seq_no":"13","part_no":"393","part_no_section":"47A-BCLMBD","insp_viol_unit":"1","insp_unit_id":"208007958","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-07-25T10:47:35.000000Z","updated_at":"2025-07-26T10:42:34.000000Z","normalized_code":"39347ABCLMBD"},{"id":14903767,"change_date":"2025-07-22 21:42:00","inspection_id":"85283716","insp_violation_id":"267568096","seq_no":"14","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"208007959","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-07-25T10:47:35.000000Z","updated_at":"2025-07-26T10:42:34.000000Z","normalized_code":"39347E"},{"id":14903768,"change_date":"2025-07-22 21:42:00","inspection_id":"85283716","insp_violation_id":"267568097","seq_no":"15","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"208007959","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-07-25T10:47:35.000000Z","updated_at":"2025-07-26T10:42:34.000000Z","normalized_code":"39347E"},{"id":14903769,"change_date":"2025-07-22 21:42:00","inspection_id":"85283716","insp_violation_id":"267568098","seq_no":"16","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"208007958","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-07-25T10:47:35.000000Z","updated_at":"2025-07-26T10:42:34.000000Z","normalized_code":"3965BL"},{"id":14903770,"change_date":"2025-07-22 21:42:00","inspection_id":"85283716","insp_violation_id":"267568099","seq_no":"17","part_no":"396","part_no_section":"9D2-FTF","insp_viol_unit":"1","insp_unit_id":"208007958","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-07-25T10:47:35.000000Z","updated_at":"2025-07-26T10:42:34.000000Z","normalized_code":"3969D2FTF"}],"inspection_per_units":[{"id":15153320,"change_date":"2025-07-22 21:42:00","inspection_id":"85283716","insp_unit_id":"208007958","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"YP62819","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJHHDR6KLKE3838","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-25T09:46:40.000000Z","updated_at":"2025-07-26T09:45:50.000000Z"},{"id":15153321,"change_date":"2025-07-22 21:42:00","inspection_id":"85283716","insp_unit_id":"208007959","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNKNOWN","insp_unit_company":null,"insp_unit_license":"4TT6091","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2536FP223305","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-25T09:46:40.000000Z","updated_at":"2025-07-26T09:45:50.000000Z"}]},{"id":9231791,"change_date":"2025-07-24 21:40:00","inspection_id":"85302668","dot_number":"2117962","report_state":"MT","report_number":"U568201495","insp_date":"2025-07-20 00:00:00","insp_start_time":"0756","insp_end_time":"0842","registration_date":null,"region":"MD","ci_status_code":"C","location":"BILLEB","location_desc":"BILLINGS MT","county_code_state":"MT","county_code":"111","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CONSOLIDATIED ELECTRICAL DISTRIBUTORS","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-07-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120300","viol_total":"5","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2034196","transaction_code":"A","transaction_date":"2025-07-23 00:00:00","upload_date":"2025-07-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02117962","upload_search_indicator":null,"census_search_date":"2025-07-24 21:40:00","snet_input_date":"2025-07-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-24 21:40:00","insp_carrier_name":"BAY EXPRESS INC","insp_carrier_street":"1259 MAGIC SANDS WAY","insp_carrier_city":"TURLOCK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-27T10:41:47.000000Z","updated_at":"2025-07-30T10:00:22.000000Z","inspection_violations":[{"id":14944859,"change_date":"2025-07-24 21:40:00","inspection_id":"85302668","insp_violation_id":"267616524","seq_no":"1","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"208048235","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-27T10:43:59.000000Z","updated_at":"2025-07-28T10:48:06.000000Z","normalized_code":"39345DB"},{"id":14944860,"change_date":"2025-07-24 21:40:00","inspection_id":"85302668","insp_violation_id":"267616525","seq_no":"2","part_no":"396","part_no_section":"3A1-BALR","insp_viol_unit":"1","insp_unit_id":"208048235","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-27T10:43:59.000000Z","updated_at":"2025-07-28T10:48:06.000000Z","normalized_code":"3963A1BALR"},{"id":14944861,"change_date":"2025-07-24 21:40:00","inspection_id":"85302668","insp_violation_id":"267616526","seq_no":"3","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"208048235","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-27T10:43:59.000000Z","updated_at":"2025-07-28T10:48:06.000000Z","normalized_code":"39395A4EEUS"},{"id":14944862,"change_date":"2025-07-24 21:40:00","inspection_id":"85302668","insp_violation_id":"267616527","seq_no":"4","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"2","insp_unit_id":"208048236","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-27T10:43:59.000000Z","updated_at":"2025-07-28T10:48:06.000000Z","normalized_code":"39345B2BAIR"},{"id":14944863,"change_date":"2025-07-24 21:40:00","inspection_id":"85302668","insp_violation_id":"267616528","seq_no":"5","part_no":"393","part_no_section":"201A-VLRB","insp_viol_unit":"2","insp_unit_id":"208048236","insp_violation_category_id":"19","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-27T10:43:59.000000Z","updated_at":"2025-07-28T10:48:06.000000Z","normalized_code":"393201AVLRB"}],"inspection_per_units":[{"id":15190149,"change_date":"2025-07-24 21:40:00","inspection_id":"85302668","insp_unit_id":"208048235","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"YP62819","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJHHDR6KLKE3838","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-27T09:46:25.000000Z","updated_at":"2025-07-28T09:45:24.000000Z"},{"id":15190150,"change_date":"2025-07-24 21:40:00","inspection_id":"85302668","insp_unit_id":"208048236","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNKNOWN","insp_unit_company":null,"insp_unit_license":"4TT6091","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2536FP223305","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-27T09:46:25.000000Z","updated_at":"2025-07-28T09:45:24.000000Z"}]},{"id":8594611,"change_date":"2025-05-10 21:33:00","inspection_id":"84629756","dot_number":"2117962","report_state":"GA","report_number":"1419000870","insp_date":"2025-05-03 00:00:00","insp_start_time":"1250","insp_end_time":"1312","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"VILLA RICA GA","county_code_state":"GA","county_code":"097","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SIEMENS","shipping_paper_number":"104400026130","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-05-10 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"120999","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":"1708218","transaction_code":"A","transaction_date":"2025-05-10 00:00:00","upload_date":"2025-05-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02117962","upload_search_indicator":null,"census_search_date":"2025-05-10 21:33:00","snet_input_date":"2025-05-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-10 21:33:00","insp_carrier_name":"BAY EXPRESS INC","insp_carrier_street":"1259 MAGIC SANDS WAY","insp_carrier_city":"TURLOCK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-13T10:02:18.000000Z","updated_at":"2025-05-14T10:00:26.000000Z","inspection_violations":[{"id":13652951,"change_date":"2025-05-10 21:33:00","inspection_id":"84629756","insp_violation_id":"266138347","seq_no":"1","part_no":"392","part_no_section":"2-INAT","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"W01E713994","created_at":"2025-05-13T10:22:53.000000Z","updated_at":"2025-05-14T10:17:05.000000Z","normalized_code":"3922INAT"}],"inspection_per_units":[{"id":14029196,"change_date":"2025-05-10 21:33:00","inspection_id":"84629756","insp_unit_id":"206786475","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"140","insp_unit_license":"ZP36254","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLDR3KSKD3780","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-13T09:47:47.000000Z","updated_at":"2025-05-14T09:45:20.000000Z"},{"id":14029197,"change_date":"2025-05-10 21:33:00","inspection_id":"84629756","insp_unit_id":"206786476","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"404","insp_unit_license":"4UN5028","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H3V532CXGT101045","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-13T09:47:47.000000Z","updated_at":"2025-05-14T09:45:20.000000Z"}]},{"id":7540110,"change_date":"2025-01-03 21:38:00","inspection_id":"83520828","dot_number":"2117962","report_state":"GA","report_number":"1243000181","insp_date":"2024-12-31 00:00:00","insp_start_time":"0815","insp_end_time":"0845","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"LITHONIA GA","county_code_state":"GA","county_code":"089","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"JAK TRANSFER ,INC","shipping_paper_number":"30188952","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-01-03 21:38: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":"1211923","transaction_code":"A","transaction_date":"2025-01-03 00:00:00","upload_date":"2025-01-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02117962","upload_search_indicator":null,"census_search_date":"2025-01-03 21:38:00","snet_input_date":"2024-12-31 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-03 21:38:00","insp_carrier_name":"BAY EXPRESS INC","insp_carrier_street":"1259 MAGIC SANDS WAY","insp_carrier_city":"TURLOCK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:54:51.000000Z","updated_at":"2025-03-17T20:54:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12165102,"change_date":"2025-01-03 21:38:00","inspection_id":"83520828","insp_unit_id":"204634614","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"142","insp_unit_license":"ZP13821","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLDR9KSKD3783","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:19.000000Z","updated_at":"2025-03-17T23:49:19.000000Z"},{"id":12165103,"change_date":"2025-01-03 21:38:00","inspection_id":"83520828","insp_unit_id":"204634615","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VAN GUARD","insp_unit_company":"401","insp_unit_license":"4TY9207","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5V8VC5324KM905373","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:19.000000Z","updated_at":"2025-03-17T23:49:19.000000Z"}]},{"id":7296647,"change_date":"2024-11-28 21:33:00","inspection_id":"83264967","dot_number":"2117962","report_state":"AZ","report_number":"4308001225","insp_date":"2024-11-21 00:00:00","insp_start_time":"1038","insp_end_time":"1155","registration_date":null,"region":"MS","ci_status_code":"C","location":"AZ4057","location_desc":"KINGMAN AZ","county_code_state":"AZ","county_code":"015","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"COMPASS HEALTH BRANDS","shipping_paper_number":"001","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-11-28 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"121220","viol_total":"15","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":"1100989","transaction_code":"A","transaction_date":"2024-11-28 00:00:00","upload_date":"2024-11-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02117962","upload_search_indicator":null,"census_search_date":"2024-11-28 21:33:00","snet_input_date":"2024-11-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-28 21:33:00","insp_carrier_name":"BAY EXPRESS INC","insp_carrier_street":"1259 MAGIC SANDS WAY","insp_carrier_city":"TURLOCK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:48:12.000000Z","updated_at":"2025-03-17T20:48:12.000000Z","inspection_violations":[{"id":11409850,"change_date":"2024-11-28 21:33:00","inspection_id":"83264967","insp_violation_id":"263134431","seq_no":"9","part_no":"395","part_no_section":"8E-HOSPDOOS","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:28.000000Z","updated_at":"2025-03-17T22:01:28.000000Z","normalized_code":"3958EHOSPDOOS"},{"id":11409851,"change_date":"2024-11-28 21:33:00","inspection_id":"83264967","insp_violation_id":"263134432","seq_no":"10","part_no":"395","part_no_section":"8E-HOSPDOOS","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:28.000000Z","updated_at":"2025-03-17T22:01:28.000000Z","normalized_code":"3958EHOSPDOOS"},{"id":11409852,"change_date":"2024-11-28 21:33:00","inspection_id":"83264967","insp_violation_id":"263134433","seq_no":"11","part_no":"395","part_no_section":"24","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:28.000000Z","updated_at":"2025-03-17T22:01:28.000000Z","normalized_code":"39524"},{"id":11409853,"change_date":"2024-11-28 21:33:00","inspection_id":"83264967","insp_violation_id":"263134434","seq_no":"12","part_no":"395","part_no_section":"3A2-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:28.000000Z","updated_at":"2025-03-17T22:01:28.000000Z","normalized_code":"3953A2HOSPD"},{"id":11409854,"change_date":"2024-11-28 21:33:00","inspection_id":"83264967","insp_violation_id":"263134435","seq_no":"13","part_no":"395","part_no_section":"3A2-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:28.000000Z","updated_at":"2025-03-17T22:01:28.000000Z","normalized_code":"3953A2HOSPD"},{"id":11409855,"change_date":"2024-11-28 21:33:00","inspection_id":"83264967","insp_violation_id":"263134436","seq_no":"14","part_no":"395","part_no_section":"3A1-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:28.000000Z","updated_at":"2025-03-17T22:01:28.000000Z","normalized_code":"3953A1HOSPD"},{"id":11409856,"change_date":"2024-11-28 21:33:00","inspection_id":"83264967","insp_violation_id":"263134437","seq_no":"15","part_no":"395","part_no_section":"3A1-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:28.000000Z","updated_at":"2025-03-17T22:01:28.000000Z","normalized_code":"3953A1HOSPD"},{"id":11409857,"change_date":"2024-11-28 21:33:00","inspection_id":"83264967","insp_violation_id":"263134438","seq_no":"1","part_no":"392","part_no_section":"2-SLLMF","insp_viol_unit":"2","insp_unit_id":"204092286","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:28.000000Z","updated_at":"2025-03-17T22:01:28.000000Z","normalized_code":"3922SLLMF"},{"id":11409858,"change_date":"2024-11-28 21:33:00","inspection_id":"83264967","insp_violation_id":"263134439","seq_no":"2","part_no":"393","part_no_section":"11A1-CSURR","insp_viol_unit":"1","insp_unit_id":"204092285","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:28.000000Z","updated_at":"2025-03-17T22:01:28.000000Z","normalized_code":"39311A1CSURR"},{"id":11409859,"change_date":"2024-11-28 21:33:00","inspection_id":"83264967","insp_violation_id":"263134440","seq_no":"3","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"2","insp_unit_id":"204092286","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:28.000000Z","updated_at":"2025-03-17T22:01:28.000000Z","normalized_code":"39345DB"},{"id":11409860,"change_date":"2024-11-28 21:33:00","inspection_id":"83264967","insp_violation_id":"263134441","seq_no":"4","part_no":"395","part_no_section":"30B2-ELDDFC24","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:28.000000Z","updated_at":"2025-03-17T22:01:28.000000Z","normalized_code":"39530B2ELDDFC24"},{"id":11409861,"change_date":"2024-11-28 21:33:00","inspection_id":"83264967","insp_violation_id":"263134442","seq_no":"5","part_no":"395","part_no_section":"22G-ELDMFV","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:28.000000Z","updated_at":"2025-03-17T22:01:28.000000Z","normalized_code":"39522GELDMFV"},{"id":11409862,"change_date":"2024-11-28 21:33:00","inspection_id":"83264967","insp_violation_id":"263134443","seq_no":"6","part_no":"392","part_no_section":"2-SLLSIV","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:28.000000Z","updated_at":"2025-03-17T22:01:28.000000Z","normalized_code":"3922SLLSIV"},{"id":11409863,"change_date":"2024-11-28 21:33:00","inspection_id":"83264967","insp_violation_id":"263134444","seq_no":"7","part_no":"395","part_no_section":"24","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:28.000000Z","updated_at":"2025-03-17T22:01:28.000000Z","normalized_code":"39524"},{"id":11409864,"change_date":"2024-11-28 21:33:00","inspection_id":"83264967","insp_violation_id":"263134445","seq_no":"8","part_no":"395","part_no_section":"8E-HOSPDOOS","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:28.000000Z","updated_at":"2025-03-17T22:01:28.000000Z","normalized_code":"3958EHOSPDOOS"}],"inspection_per_units":[{"id":11769878,"change_date":"2024-11-28 21:33:00","inspection_id":"83264967","insp_unit_id":"204092285","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"142","insp_unit_license":"ZP13821","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLDR9KSKD3783","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:58.000000Z","updated_at":"2025-03-17T23:44:58.000000Z"},{"id":11769879,"change_date":"2024-11-28 21:33:00","inspection_id":"83264967","insp_unit_id":"204092286","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CIMC VEHIC","insp_unit_company":null,"insp_unit_license":"4TY9207","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5V8VC5324KM905373","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:58.000000Z","updated_at":"2025-03-17T23:44:58.000000Z"}]},{"id":7014644,"change_date":"2024-10-22 21:41:00","inspection_id":"82966382","dot_number":"2117962","report_state":"PA","report_number":"E906429656","insp_date":"2024-10-22 00:00:00","insp_start_time":"0815","insp_end_time":"0900","registration_date":null,"region":"ET","ci_status_code":"C","location":"207","location_desc":"I83 SB MM 34.1 NEWBERRY TWP -","county_code_state":"PA","county_code":"133","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":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-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"18500","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":"2474131","transaction_code":"A","transaction_date":"2024-10-22 00:00:00","upload_date":"2024-10-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02117962","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-10-22 00:00:00","source_office":"1PAS001","mcmis_add_date":"2024-10-22 21:41:00","insp_carrier_name":"BAY EXPRESS INC","insp_carrier_street":"P O BOX 1811","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"738202","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:42:17.000000Z","updated_at":"2025-03-17T20:42:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11313998,"change_date":"2024-10-22 21:41:00","inspection_id":"82966382","insp_unit_id":"203526192","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"143","insp_unit_license":"ZP36254","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLDR3KSKD3780","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:08.000000Z","updated_at":"2025-03-17T23:40:08.000000Z"},{"id":11313999,"change_date":"2024-10-22 21:41:00","inspection_id":"82966382","insp_unit_id":"203526193","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUN","insp_unit_company":"404","insp_unit_license":"4UN5028","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H3V532CXGT101045","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:08.000000Z","updated_at":"2025-03-17T23:40:08.000000Z"}]},{"id":5439488,"change_date":"2024-04-04 21:43:00","inspection_id":"81272763","dot_number":"2117962","report_state":"CA","report_number":"NB9A004253","insp_date":"2024-04-02 00:00:00","insp_start_time":"1400","insp_end_time":"1500","registration_date":null,"region":"PT","ci_status_code":"C","location":"465","location_desc":"305 N KILROY RD","county_code_state":"CA","county_code":"099","insp_level_id":"5","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":"2024-04-04 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"121220","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":"15304469","transaction_code":"A","transaction_date":"2024-04-02 00:00:00","upload_date":"2024-04-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02117962","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-04-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-04-04 21:43:00","insp_carrier_name":"BAY EXPRESS INC","insp_carrier_street":"1259 MAGIC SANDS WAY","insp_carrier_city":"TURLOCK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"738202","insp_interstate":"Y","insp_carrier_state_id":"568777","created_at":"2025-03-17T20:10:20.000000Z","updated_at":"2025-03-17T20:10:20.000000Z","inspection_violations":[{"id":8397784,"change_date":"2024-04-04 21:43:00","inspection_id":"81272763","insp_violation_id":"258758601","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"200246767","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:37.000000Z","updated_at":"2025-03-17T21:46:37.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":8762016,"change_date":"2024-04-04 21:43:00","inspection_id":"81272763","insp_unit_id":"200246767","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"142\/RD","insp_unit_license":"ZP13821","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLDR9KSKD3783","insp_unit_decal":"Y","insp_unit_decal_number":"33828395","created_at":"2025-03-17T23:14:30.000000Z","updated_at":"2025-03-17T23:14:30.000000Z"},{"id":8762017,"change_date":"2024-04-04 21:43:00","inspection_id":"81272763","insp_unit_id":"200246768","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VANGU","insp_unit_company":"401\/WHT","insp_unit_license":"4TY9207","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5V8VC5324KM905373","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:30.000000Z","updated_at":"2025-03-17T23:14:30.000000Z"}]},{"id":5439489,"change_date":"2024-04-04 21:43:00","inspection_id":"81272764","dot_number":"2117962","report_state":"CA","report_number":"NB9A004254","insp_date":"2024-04-02 00:00:00","insp_start_time":"1500","insp_end_time":"1600","registration_date":null,"region":"PT","ci_status_code":"C","location":"465","location_desc":"305 N KILROY RD","county_code_state":"CA","county_code":"099","insp_level_id":"5","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":"2024-04-04 21:43: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":"15304160","transaction_code":"A","transaction_date":"2024-04-02 00:00:00","upload_date":"2024-04-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02117962","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-04-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-04-04 21:43:00","insp_carrier_name":"BAY EXPRESS INC","insp_carrier_street":"1259 MAGIC SANDS WAY","insp_carrier_city":"TURLOCK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"738202","insp_interstate":"Y","insp_carrier_state_id":"568777","created_at":"2025-03-17T20:10:20.000000Z","updated_at":"2025-03-17T20:10:20.000000Z","inspection_violations":[{"id":8397785,"change_date":"2024-04-04 21:43:00","inspection_id":"81272764","insp_violation_id":"258758602","seq_no":"1","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"200246769","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:37.000000Z","updated_at":"2025-03-17T21:46:37.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":8762018,"change_date":"2024-04-04 21:43:00","inspection_id":"81272764","insp_unit_id":"200246769","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"139\/RD","insp_unit_license":"XP51366","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD51FSGG3409","insp_unit_decal":"Y","insp_unit_decal_number":"33828394","created_at":"2025-03-17T23:14:30.000000Z","updated_at":"2025-03-17T23:14:30.000000Z"},{"id":8762019,"change_date":"2024-04-04 21:43:00","inspection_id":"81272764","insp_unit_id":"200246770","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"404\/WHT","insp_unit_license":"4UN5028","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H3V532CXGT101045","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:30.000000Z","updated_at":"2025-03-17T23:14:30.000000Z"}]},{"id":5439490,"change_date":"2024-04-04 21:43:00","inspection_id":"81272765","dot_number":"2117962","report_state":"CA","report_number":"NB9A004255","insp_date":"2024-04-02 00:00:00","insp_start_time":"1600","insp_end_time":"1700","registration_date":null,"region":"PT","ci_status_code":"C","location":"465","location_desc":"305 N KILROY RD","county_code_state":"CA","county_code":"099","insp_level_id":"5","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":"2024-04-04 21:43: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":"15302691","transaction_code":"A","transaction_date":"2024-04-02 00:00:00","upload_date":"2024-04-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02117962","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-04-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-04-04 21:43:00","insp_carrier_name":"BAY EXPRESS INC","insp_carrier_street":"1259 MAGIC SANDS WAY","insp_carrier_city":"TURLOCK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"738202","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:10:20.000000Z","updated_at":"2025-03-17T20:10:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8762020,"change_date":"2024-04-04 21:43:00","inspection_id":"81272765","insp_unit_id":"200246771","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"141\/RED","insp_unit_license":"YP62819","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJHHDR6KLKE3838","insp_unit_decal":"Y","insp_unit_decal_number":"33828393","created_at":"2025-03-17T23:14:30.000000Z","updated_at":"2025-03-17T23:14:30.000000Z"},{"id":8762021,"change_date":"2024-04-04 21:43:00","inspection_id":"81272765","insp_unit_id":"200246772","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"403\/WHT","insp_unit_license":"4TT6091","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2536FP223305","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:30.000000Z","updated_at":"2025-03-17T23:14:30.000000Z"}]},{"id":5184827,"change_date":"2024-02-29 21:48:00","inspection_id":"80994762","dot_number":"2117962","report_state":"CA","report_number":"UEH7005290","insp_date":"2024-02-29 00:00:00","insp_start_time":"0808","insp_end_time":"0827","registration_date":null,"region":"PT","ci_status_code":"C","location":"252","location_desc":"SB SR99 @ GRANTLINE RD","county_code_state":"CA","county_code":"067","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-29 21:48:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"3","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15264366","transaction_code":"A","transaction_date":"2024-02-29 00:00:00","upload_date":"2024-02-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02117962","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-02-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-02-29 21:48:00","insp_carrier_name":"BAY EXPRESS INC","insp_carrier_street":"1259 MAGIC SANDS WAY","insp_carrier_city":"TURLOCK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"738202","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:05:20.000000Z","updated_at":"2025-03-17T20:05:20.000000Z","inspection_violations":[{"id":7990837,"change_date":"2024-02-29 21:48:00","inspection_id":"80994762","insp_violation_id":"258142977","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:37.000000Z","updated_at":"2025-03-17T21:44:37.000000Z","normalized_code":"3922"},{"id":7990838,"change_date":"2024-02-29 21:48:00","inspection_id":"80994762","insp_violation_id":"258142978","seq_no":"2","part_no":"395","part_no_section":"30(b)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:37.000000Z","updated_at":"2025-03-17T21:44:37.000000Z","normalized_code":"39530B1"},{"id":7990839,"change_date":"2024-02-29 21:48:00","inspection_id":"80994762","insp_violation_id":"258142979","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"199700745","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"JP75049","created_at":"2025-03-17T21:44:37.000000Z","updated_at":"2025-03-17T21:44:37.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8348241,"change_date":"2024-02-29 21:48:00","inspection_id":"80994762","insp_unit_id":"199700744","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"XP51366","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD51FSGG3409","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:38.000000Z","updated_at":"2025-03-17T23:10:38.000000Z"},{"id":8348242,"change_date":"2024-02-29 21:48:00","inspection_id":"80994762","insp_unit_id":"199700745","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":null,"insp_unit_license":"NONE","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H3V532C5KR437742","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:38.000000Z","updated_at":"2025-03-17T23:10:38.000000Z"}]},{"id":4108422,"change_date":"2023-10-02 21:42:00","inspection_id":"79813436","dot_number":"2117962","report_state":"CA","report_number":"NE4V004660","insp_date":"2023-09-21 00:00:00","insp_start_time":"1657","insp_end_time":"1750","registration_date":null,"region":"PT","ci_status_code":"C","location":"875","location_desc":"MT. PASS IF","county_code_state":"CA","county_code":"071","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"JD HORICON FINISHED GOODS","shipping_paper_number":"5001459106","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-02 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15081109","transaction_code":"A","transaction_date":"2023-09-21 00:00:00","upload_date":"2023-10-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02117962","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-09-21 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-10-02 21:42:00","insp_carrier_name":"BAY EXPRESS INC","insp_carrier_street":"1259 MAGIC SANDS WAY","insp_carrier_city":"TURLOCK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"738202","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:44:02.000000Z","updated_at":"2025-03-17T19:44:02.000000Z","inspection_violations":[{"id":6357485,"change_date":"2023-10-02 21:42:00","inspection_id":"79813436","insp_violation_id":"255612200","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"197358358","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:38.000000Z","updated_at":"2025-03-17T21:36:38.000000Z","normalized_code":"39345B2"},{"id":6357486,"change_date":"2023-10-02 21:42:00","inspection_id":"79813436","insp_violation_id":"255612201","seq_no":"2","part_no":"395","part_no_section":"8(e)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:38.000000Z","updated_at":"2025-03-17T21:36:38.000000Z","normalized_code":"3958E1"},{"id":6357487,"change_date":"2023-10-02 21:42:00","inspection_id":"79813436","insp_violation_id":"255612202","seq_no":"3","part_no":"395","part_no_section":"26(b)","insp_viol_unit":"1","insp_unit_id":"197358357","insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:38.000000Z","updated_at":"2025-03-17T21:36:38.000000Z","normalized_code":"39526B"}],"inspection_per_units":[{"id":6605860,"change_date":"2023-10-02 21:42:00","inspection_id":"79813436","insp_unit_id":"197358357","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"141\/RED","insp_unit_license":"YP62189","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD68ESFV9270","insp_unit_decal":"Y","insp_unit_decal_number":"32932993","created_at":"2025-03-17T22:55:26.000000Z","updated_at":"2025-03-17T22:55:26.000000Z"},{"id":6605861,"change_date":"2023-10-02 21:42:00","inspection_id":"79813436","insp_unit_id":"197358358","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"403\/WHT","insp_unit_license":"4TT6091","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2536FP223305","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:26.000000Z","updated_at":"2025-03-17T22:55:26.000000Z"}]},{"id":3257855,"change_date":"2023-07-24 21:42:00","inspection_id":"78861415","dot_number":"2117962","report_state":"NM","report_number":"8096N4HSJF","insp_date":"2023-06-10 00:00:00","insp_start_time":"2120","insp_end_time":"2215","registration_date":"2023-07-22 00:00:00","region":"MT","ci_status_code":"C","location":null,"location_desc":"GALLUP PORT OF ENTRY","county_code_state":"NM","county_code":"031","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"LYNDEN LOGISTICS","shipping_paper_number":"6090118","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-12 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":"2011258","transaction_code":"C","transaction_date":"2023-06-11 00:00:00","upload_date":"2023-07-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02117962","upload_search_indicator":null,"census_search_date":"2023-06-12 21:40:00","snet_input_date":"2023-06-12 00:00:00","source_office":"2NMS001","mcmis_add_date":"2023-06-12 21:40:00","insp_carrier_name":"BAY EXPRESS INC","insp_carrier_street":"P O BOX 1811","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:27:23.000000Z","updated_at":"2025-03-17T19:27:23.000000Z","inspection_violations":[{"id":5022614,"change_date":"2023-07-24 21:42:00","inspection_id":"78861415","insp_violation_id":"254232100","seq_no":"1","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"196153164","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:22.000000Z","updated_at":"2025-03-17T21:30:22.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":5238976,"change_date":"2023-07-24 21:42:00","inspection_id":"78861415","insp_unit_id":"196153164","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"UNIT138","insp_unit_license":"XP23808","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLD50ELFH6949","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:17.000000Z","updated_at":"2025-03-17T22:44:17.000000Z"},{"id":5238977,"change_date":"2023-07-24 21:42:00","inspection_id":"78861415","insp_unit_id":"196153165","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VANGUARD","insp_unit_company":"UNIT 401","insp_unit_license":"4TY9207","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5V8VC5324KM905373","insp_unit_decal":"Y","insp_unit_decal_number":"32649782","created_at":"2025-03-17T22:44:17.000000Z","updated_at":"2025-03-17T22:44:17.000000Z"}]},{"id":2674430,"change_date":"2023-03-28 21:40:00","inspection_id":"78200665","dot_number":"2117962","report_state":"NC","report_number":"0006518830","insp_date":"2023-03-28 00:00:00","insp_start_time":"1142","insp_end_time":"1159","registration_date":null,"region":"ET","ci_status_code":"C","location":"STATES","location_desc":"STATESVILLE WEIGH STATION I-40","county_code_state":"NC","county_code":"097","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2052458","transaction_code":"A","transaction_date":"2023-03-28 00:00:00","upload_date":"2023-03-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02117962","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-03-28 00:00:00","source_office":"2NCS001","mcmis_add_date":"2023-03-28 21:40:00","insp_carrier_name":"BAY EXPRESS INC","insp_carrier_street":"1259 MAGIC SANDS WAY","insp_carrier_city":"TURLOCK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"738202","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:15:54.000000Z","updated_at":"2025-03-17T19:15:54.000000Z","inspection_violations":[{"id":4109663,"change_date":"2023-03-28 21:40:00","inspection_id":"78200665","insp_violation_id":"251899443","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:14.000000Z","updated_at":"2025-03-17T21:26:14.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":4305887,"change_date":"2023-03-28 21:40:00","inspection_id":"78200665","insp_unit_id":"194093857","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"140","insp_unit_license":"XP81434","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD57FSGG3396","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:56.000000Z","updated_at":"2025-03-17T22:36:56.000000Z"},{"id":4305888,"change_date":"2023-03-28 21:40:00","inspection_id":"78200665","insp_unit_id":"194093858","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUN","insp_unit_company":null,"insp_unit_license":"4TW3362","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H3V532CXHT418017","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:56.000000Z","updated_at":"2025-03-17T22:36:56.000000Z"}]},{"id":2135982,"change_date":"2023-01-12 21:42:00","inspection_id":"77587553","dot_number":"2117962","report_state":"CA","report_number":"NDVK000406","insp_date":"2023-01-05 00:00:00","insp_start_time":"0800","insp_end_time":"0930","registration_date":null,"region":"PT","ci_status_code":"C","location":"465","location_desc":"MODESTO AREA","county_code_state":"CA","county_code":"099","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":"2023-01-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14738215","transaction_code":"A","transaction_date":"2023-01-06 00:00:00","upload_date":"2023-01-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02117962","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-01-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-01-12 21:42:00","insp_carrier_name":"BAY EXPRESS INC","insp_carrier_street":"1259 MAGIC SANDS WAY","insp_carrier_city":"TURLOCK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"738202","insp_interstate":"Y","insp_carrier_state_id":"568777","created_at":"2025-03-17T19:05:55.000000Z","updated_at":"2025-03-17T19:05:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3437641,"change_date":"2023-01-12 21:42:00","inspection_id":"77587553","insp_unit_id":"192856952","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"138","insp_unit_license":"XP23808","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLD50ELFH6949","insp_unit_decal":"Y","insp_unit_decal_number":"32153205","created_at":"2025-03-17T22:30:38.000000Z","updated_at":"2025-03-17T22:30:38.000000Z"},{"id":3437642,"change_date":"2023-01-12 21:42:00","inspection_id":"77587553","insp_unit_id":"192856953","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VANR","insp_unit_company":"401","insp_unit_license":"4TY9207","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5V8VC5324KM905373","insp_unit_decal":"Y","insp_unit_decal_number":"32153206","created_at":"2025-03-17T22:30:38.000000Z","updated_at":"2025-03-17T22:30:38.000000Z"}]},{"id":2135983,"change_date":"2023-01-12 21:42:00","inspection_id":"77587554","dot_number":"2117962","report_state":"CA","report_number":"NDVK000407","insp_date":"2023-01-05 00:00:00","insp_start_time":"0931","insp_end_time":"1100","registration_date":null,"region":"PT","ci_status_code":"C","location":"465","location_desc":"MODESTO AREA","county_code_state":"CA","county_code":"099","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":"2023-01-12 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":"14738228","transaction_code":"A","transaction_date":"2023-01-06 00:00:00","upload_date":"2023-01-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02117962","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-01-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-01-12 21:42:00","insp_carrier_name":"BAY EXPRESS INC","insp_carrier_street":"1259 MAGIC SANDS WAY","insp_carrier_city":"TURLOCK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"738202","insp_interstate":"Y","insp_carrier_state_id":"568777","created_at":"2025-03-17T19:05:55.000000Z","updated_at":"2025-03-17T19:05:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3437643,"change_date":"2023-01-12 21:42:00","inspection_id":"77587554","insp_unit_id":"192856954","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"139","insp_unit_license":"XP51366","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD51FSGG3409","insp_unit_decal":"Y","insp_unit_decal_number":"32153207","created_at":"2025-03-17T22:30:38.000000Z","updated_at":"2025-03-17T22:30:38.000000Z"},{"id":3437644,"change_date":"2023-01-12 21:42:00","inspection_id":"77587554","insp_unit_id":"192856955","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"403","insp_unit_license":"4TT6091","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2536FP223305","insp_unit_decal":"Y","insp_unit_decal_number":"32153208","created_at":"2025-03-17T22:30:38.000000Z","updated_at":"2025-03-17T22:30:38.000000Z"}]},{"id":1970233,"change_date":"2022-12-19 21:40:00","inspection_id":"77398136","dot_number":"2117962","report_state":"AR","report_number":"C703003111","insp_date":"2022-12-19 00:00:00","insp_start_time":"1030","insp_end_time":"1100","registration_date":null,"region":"CT","ci_status_code":"C","location":"24","location_desc":"ROADSIDE","county_code_state":"AR","county_code":"047","insp_level_id":"3","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"NORDSTROM DC#499","shipping_paper_number":"499770121622-1","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-12-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1436276","transaction_code":"A","transaction_date":"2022-12-19 00:00:00","upload_date":"2022-12-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02117962","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-12-19 00:00:00","source_office":"2ARS001","mcmis_add_date":"2022-12-19 21:40:00","insp_carrier_name":"BAY EXPRESS INC","insp_carrier_street":"1259 MAGIC SANDS WAY","insp_carrier_city":"TURLOCK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"738202","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:02:57.000000Z","updated_at":"2025-03-17T19:02:57.000000Z","inspection_violations":[{"id":3059125,"change_date":"2022-12-19 21:40:00","inspection_id":"77398136","insp_violation_id":"250157256","seq_no":"1","part_no":"395","part_no_section":"8(e)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"400A0312039","created_at":"2025-03-17T21:21:31.000000Z","updated_at":"2025-03-17T21:21:31.000000Z","normalized_code":"3958E1"}],"inspection_per_units":[{"id":3169609,"change_date":"2022-12-19 21:40:00","inspection_id":"77398136","insp_unit_id":"192478988","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"139\/RED","insp_unit_license":"XP51366","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD51FSGG3409","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:41.000000Z","updated_at":"2025-03-17T22:28:41.000000Z"},{"id":3169610,"change_date":"2022-12-19 21:40:00","inspection_id":"77398136","insp_unit_id":"192478989","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"4TT6091","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2536FP223305","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:41.000000Z","updated_at":"2025-03-17T22:28:41.000000Z"}]},{"id":1188669,"change_date":"2022-08-31 21:43:00","inspection_id":"76497289","dot_number":"2117962","report_state":"CA","report_number":"NEEU000426","insp_date":"2022-08-29 00:00:00","insp_start_time":"1820","insp_end_time":"1854","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","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-08-31 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14576139","transaction_code":"A","transaction_date":"2022-08-29 00:00:00","upload_date":"2022-08-31 00:00:00","upload_first_byte":"0","upload_dot_number":"02117962","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-08-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-08-31 21:43:00","insp_carrier_name":"BAY EXPRESS INC","insp_carrier_street":"1259 MAGIC SANDS WAY","insp_carrier_city":"TURLOCK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"738202","insp_interstate":"Y","insp_carrier_state_id":"568777","created_at":"2025-03-17T18:48:37.000000Z","updated_at":"2025-03-17T18:48:37.000000Z","inspection_violations":[{"id":1884899,"change_date":"2022-08-31 21:43:00","inspection_id":"76497289","insp_violation_id":"248146621","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"190666751","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:43.000000Z","updated_at":"2025-03-17T21:15:43.000000Z","normalized_code":"39347E"},{"id":1884900,"change_date":"2022-08-31 21:43:00","inspection_id":"76497289","insp_violation_id":"248146622","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"190666751","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:43.000000Z","updated_at":"2025-03-17T21:15:43.000000Z","normalized_code":"39353B"},{"id":1884901,"change_date":"2022-08-31 21:43:00","inspection_id":"76497289","insp_violation_id":"248146623","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"190666751","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:15:43.000000Z","updated_at":"2025-03-17T21:15:43.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":1911914,"change_date":"2022-08-31 21:43:00","inspection_id":"76497289","insp_unit_id":"190666750","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"139\/RED","insp_unit_license":"XP51366","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD51FSGG3409","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:09.000000Z","updated_at":"2025-03-17T22:20:09.000000Z"},{"id":1911915,"change_date":"2022-08-31 21:43:00","inspection_id":"76497289","insp_unit_id":"190666751","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"402\/WHITE","insp_unit_license":"4TW3362","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H3V532CXHT418017","insp_unit_decal":"Y","insp_unit_decal_number":"31480377","created_at":"2025-03-17T22:20:09.000000Z","updated_at":"2025-03-17T22:20:09.000000Z"}]},{"id":1188522,"change_date":"2022-08-31 21:43:00","inspection_id":"76497125","dot_number":"2117962","report_state":"CA","report_number":"NEEU000411","insp_date":"2022-08-24 00:00:00","insp_start_time":"1948","insp_end_time":"2026","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","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-08-31 21:43: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":"14572712","transaction_code":"A","transaction_date":"2022-08-24 00:00:00","upload_date":"2022-08-31 00:00:00","upload_first_byte":"0","upload_dot_number":"02117962","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-08-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-08-31 21:43:00","insp_carrier_name":"BAY EXPRESS INC","insp_carrier_street":"1259 MAGIC SANDS WAY","insp_carrier_city":"TURLOCK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"738202","insp_interstate":"Y","insp_carrier_state_id":"568777","created_at":"2025-03-17T18:48:37.000000Z","updated_at":"2025-03-17T18:48:37.000000Z","inspection_violations":[{"id":1884802,"change_date":"2022-08-31 21:43:00","inspection_id":"76497125","insp_violation_id":"248146500","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"190666474","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:15:43.000000Z","updated_at":"2025-03-17T21:15:43.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":1911688,"change_date":"2022-08-31 21:43:00","inspection_id":"76497125","insp_unit_id":"190666474","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"139\/RED","insp_unit_license":"XP51366","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD51FSGG3409","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:09.000000Z","updated_at":"2025-03-17T22:20:09.000000Z"},{"id":1911689,"change_date":"2022-08-31 21:43:00","inspection_id":"76497125","insp_unit_id":"190666475","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"403\/WHITE","insp_unit_license":"4TT6091","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2536FP223305","insp_unit_decal":"Y","insp_unit_decal_number":"31480363","created_at":"2025-03-17T22:20:09.000000Z","updated_at":"2025-03-17T22:20:09.000000Z"}]},{"id":1189718,"change_date":"2022-08-31 21:43:00","inspection_id":"76498484","dot_number":"2117962","report_state":"CA","report_number":"UE7F001268","insp_date":"2022-08-24 00:00:00","insp_start_time":"2213","insp_end_time":"2257","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-31 21:43: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":"14572622","transaction_code":"A","transaction_date":"2022-08-25 00:00:00","upload_date":"2022-08-31 00:00:00","upload_first_byte":"0","upload_dot_number":"02117962","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-08-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-08-31 21:43:00","insp_carrier_name":"BAY EXPRESS INC","insp_carrier_street":"1259 MAGIC SANDS WAY","insp_carrier_city":"TURLOCK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"738202","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:48:37.000000Z","updated_at":"2025-03-17T18:48:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1913590,"change_date":"2022-08-31 21:43:00","inspection_id":"76498484","insp_unit_id":"190668714","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"139","insp_unit_license":"XP51366","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD51FSGG3409","insp_unit_decal":"Y","insp_unit_decal_number":"31479854","created_at":"2025-03-17T22:20:09.000000Z","updated_at":"2025-03-17T22:20:09.000000Z"}]},{"id":1040742,"change_date":"2022-08-15 21:38:00","inspection_id":"76324712","dot_number":"2117962","report_state":"CA","report_number":"NEEU000379","insp_date":"2022-08-12 00:00:00","insp_start_time":"1622","insp_end_time":"1658","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","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-08-15 21:38: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":"14547727","transaction_code":"A","transaction_date":"2022-08-12 00:00:00","upload_date":"2022-08-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02117962","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-08-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-08-15 21:38:00","insp_carrier_name":"BAY EXPRESS INC","insp_carrier_street":"1259 MAGIC SANDS WAY","insp_carrier_city":"TURLOCK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"738202","insp_interstate":"Y","insp_carrier_state_id":"568777","created_at":"2025-03-17T18:46:08.000000Z","updated_at":"2025-03-17T18:46:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1675144,"change_date":"2022-08-15 21:38:00","inspection_id":"76324712","insp_unit_id":"190316843","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"138\/WHT\/3X","insp_unit_license":"XP23808","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLD50ELFH6949","insp_unit_decal":"Y","insp_unit_decal_number":"31480331","created_at":"2025-03-17T22:18:34.000000Z","updated_at":"2025-03-17T22:18:34.000000Z"},{"id":1675145,"change_date":"2022-08-15 21:38:00","inspection_id":"76324712","insp_unit_id":"190316844","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VANR","insp_unit_company":"401\/WHT\/2X","insp_unit_license":"4TY9207","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5V8VC5324KM905373","insp_unit_decal":"Y","insp_unit_decal_number":"31480332","created_at":"2025-03-17T22:18:34.000000Z","updated_at":"2025-03-17T22:18:34.000000Z"}]},{"id":909069,"change_date":"2022-07-27 21:41:00","inspection_id":"76170758","dot_number":"2117962","report_state":"CA","report_number":"NE02001916","insp_date":"2022-07-25 00:00:00","insp_start_time":"1957","insp_end_time":"2015","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","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-07-27 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":"14524241","transaction_code":"A","transaction_date":"2022-07-25 00:00:00","upload_date":"2022-07-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02117962","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-07-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-07-27 21:41:00","insp_carrier_name":"BAY EXPRESS INC","insp_carrier_street":"1259 MAGIC SANDS WAY","insp_carrier_city":"TURLOCK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"738202","insp_interstate":"Y","insp_carrier_state_id":"568777","created_at":"2025-03-17T18:43:42.000000Z","updated_at":"2025-03-17T18:43:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1463347,"change_date":"2022-07-27 21:41:00","inspection_id":"76170758","insp_unit_id":"190003250","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"141\/RED3X","insp_unit_license":"YP62819","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJHHDR6KLKE3838","insp_unit_decal":"Y","insp_unit_decal_number":"31479702","created_at":"2025-03-17T22:17:12.000000Z","updated_at":"2025-03-17T22:17:12.000000Z"}]},{"id":611140,"change_date":"2022-06-14 21:43:00","inspection_id":"75821402","dot_number":"2117962","report_state":"CA","report_number":"NCCL003814","insp_date":"2022-06-09 00:00:00","insp_start_time":"1037","insp_end_time":"1105","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-14 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14467435","transaction_code":"A","transaction_date":"2022-06-09 00:00:00","upload_date":"2022-06-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02117962","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-06-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-06-14 21:43:00","insp_carrier_name":"BAY EXPRESS INC","insp_carrier_street":"1259 MAGIC SANDS WAY","insp_carrier_city":"TURLOCK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"738202","insp_interstate":"Y","insp_carrier_state_id":"568777","created_at":"2025-03-17T18:38:27.000000Z","updated_at":"2025-03-17T18:38:27.000000Z","inspection_violations":[{"id":961307,"change_date":"2022-06-14 21:43:00","inspection_id":"75821402","insp_violation_id":"246469510","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"189252810","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:32.000000Z","updated_at":"2025-03-17T21:11:32.000000Z","normalized_code":"3922"},{"id":961308,"change_date":"2022-06-14 21:43:00","inspection_id":"75821402","insp_violation_id":"246469511","seq_no":"2","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"189252810","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:11:32.000000Z","updated_at":"2025-03-17T21:11:32.000000Z","normalized_code":"39375A3"},{"id":961309,"change_date":"2022-06-14 21:43:00","inspection_id":"75821402","insp_violation_id":"246469512","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"189252810","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:32.000000Z","updated_at":"2025-03-17T21:11:32.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":983017,"change_date":"2022-06-14 21:43:00","inspection_id":"75821402","insp_unit_id":"189252810","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"140 RED 3X","insp_unit_license":"XP81434","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD57FSGG3396","insp_unit_decal":"Y","insp_unit_decal_number":"31107405","created_at":"2025-03-17T22:14:14.000000Z","updated_at":"2025-03-17T22:14:14.000000Z"}]},{"id":569400,"change_date":"2022-06-08 21:41:00","inspection_id":"75771403","dot_number":"2117962","report_state":"CA","report_number":"UE7F001242","insp_date":"2022-06-06 00:00:00","insp_start_time":"1840","insp_end_time":"1901","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","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":"2022-06-08 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":"14460363","transaction_code":"A","transaction_date":"2022-06-07 00:00:00","upload_date":"2022-06-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02117962","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-06-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-06-08 21:41:00","insp_carrier_name":"BAY EXPRESS INC","insp_carrier_street":"1259 MAGIC SANDS WAY","insp_carrier_city":"TURLOCK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"738202","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:37:46.000000Z","updated_at":"2025-03-17T18:37:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":915783,"change_date":"2022-06-08 21:41:00","inspection_id":"75771403","insp_unit_id":"189129869","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3X","insp_unit_license":"XP51366","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD51FSGG3409","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:51.000000Z","updated_at":"2025-03-17T22:13:51.000000Z"},{"id":915784,"change_date":"2022-06-08 21:41:00","inspection_id":"75771403","insp_unit_id":"189129870","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"2X","insp_unit_license":"4UN5028","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H3V532CXGT101045","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:51.000000Z","updated_at":"2025-03-17T22:13:51.000000Z"}]},{"id":14780,"change_date":"2022-03-21 21:32:00","inspection_id":"75100402","dot_number":"2117962","report_state":"CA","report_number":"NE7S000750","insp_date":"2022-03-18 00:00:00","insp_start_time":"1510","insp_end_time":"1540","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","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-03-21 21:32:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14351984","transaction_code":"A","transaction_date":"2022-03-18 00:00:00","upload_date":"2022-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02117962","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-03-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-03-21 21:32:00","insp_carrier_name":"BAY EXPRESS INC","insp_carrier_street":"1601 SOUTH AIRPORT WAY","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95206","insp_colonia":null,"docket_number":"738202","insp_interstate":"Y","insp_carrier_state_id":"568777","created_at":"2025-03-17T18:27:47.000000Z","updated_at":"2025-03-17T18:27:47.000000Z","inspection_violations":[{"id":20809,"change_date":"2022-03-21 21:32:00","inspection_id":"75100402","insp_violation_id":"244689695","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"187741264","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"KL 40807","created_at":"2025-03-17T21:07:15.000000Z","updated_at":"2025-03-17T21:07:15.000000Z","normalized_code":"3963A1"},{"id":20810,"change_date":"2022-03-21 21:32:00","inspection_id":"75100402","insp_violation_id":"244689696","seq_no":"2","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"187741264","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"KL 40807","created_at":"2025-03-17T21:07:15.000000Z","updated_at":"2025-03-17T21:07:15.000000Z","normalized_code":"39345B2"},{"id":20811,"change_date":"2022-03-21 21:32:00","inspection_id":"75100402","insp_violation_id":"244689697","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"187741264","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:15.000000Z","updated_at":"2025-03-17T21:07:15.000000Z","normalized_code":"3939A"},{"id":20812,"change_date":"2022-03-21 21:32:00","inspection_id":"75100402","insp_violation_id":"244689698","seq_no":"4","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"187741265","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:15.000000Z","updated_at":"2025-03-17T21:07:15.000000Z","normalized_code":"39347E"},{"id":20813,"change_date":"2022-03-21 21:32:00","inspection_id":"75100402","insp_violation_id":"244689699","seq_no":"5","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"187741265","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:15.000000Z","updated_at":"2025-03-17T21:07:15.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":23967,"change_date":"2022-03-21 21:32:00","inspection_id":"75100402","insp_unit_id":"187741264","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"RED\/3AX","insp_unit_license":"XP51366","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD51FSGG3409","insp_unit_decal":"Y","insp_unit_decal_number":"30788834","created_at":"2025-03-17T22:08:24.000000Z","updated_at":"2025-03-17T22:08:24.000000Z"},{"id":23968,"change_date":"2022-03-21 21:32:00","inspection_id":"75100402","insp_unit_id":"187741265","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"WHITE\/2AX","insp_unit_license":"4UN5028","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H3V532CXGT101045","insp_unit_decal":"Y","insp_unit_decal_number":"30788835","created_at":"2025-03-17T22:08:24.000000Z","updated_at":"2025-03-17T22:08:24.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2117962\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2117962\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2117962\/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\/2117962\/inspections","per_page":100,"prev_page_url":null,"to":38,"total":38}