{"current_page":1,"data":[{"id":4828735,"change_date":"2024-01-12 21:44:00","inspection_id":"80605919","dot_number":"3108026","report_state":"CA","report_number":"UEBO000743","insp_date":"2024-01-11 00:00:00","insp_start_time":"0430","insp_end_time":"1622","registration_date":null,"region":"PT","ci_status_code":"C","location":"656","location_desc":"DESERT HILLS IF","county_code_state":"CA","county_code":"065","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"DOMINO SUGAR","shipping_paper_number":"0801559416","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-12 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"117500","viol_total":"4","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15197793","transaction_code":"A","transaction_date":"2024-01-11 00:00:00","upload_date":"2024-01-12 00:00:00","upload_first_byte":"0","upload_dot_number":"03108026","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-01-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-01-12 21:44:00","insp_carrier_name":"ARORA EXPRESS INC","insp_carrier_street":"6625 W BEECHWOOD AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93722","insp_colonia":null,"docket_number":"81197","insp_interstate":"Y","insp_carrier_state_id":"529212","created_at":"2025-03-17T19:58:26.000000Z","updated_at":"2025-03-17T19:58:26.000000Z","inspection_violations":[{"id":7445811,"change_date":"2024-01-12 21:44:00","inspection_id":"80605919","insp_violation_id":"257331085","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"198952127","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:41:57.000000Z","updated_at":"2025-03-17T21:41:57.000000Z","normalized_code":"3922"},{"id":7445812,"change_date":"2024-01-12 21:44:00","inspection_id":"80605919","insp_violation_id":"257331086","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198952126","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:57.000000Z","updated_at":"2025-03-17T21:41:57.000000Z","normalized_code":"3922"},{"id":7445813,"change_date":"2024-01-12 21:44:00","inspection_id":"80605919","insp_violation_id":"257331087","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"198952127","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:57.000000Z","updated_at":"2025-03-17T21:41:57.000000Z","normalized_code":"3922"},{"id":7445814,"change_date":"2024-01-12 21:44:00","inspection_id":"80605919","insp_violation_id":"257331088","seq_no":"4","part_no":"395","part_no_section":"8(e)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:57.000000Z","updated_at":"2025-03-17T21:41:57.000000Z","normalized_code":"3958E1"}],"inspection_per_units":[{"id":7768899,"change_date":"2024-01-12 21:44:00","inspection_id":"80605919","insp_unit_id":"198952126","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"304\/WHT","insp_unit_license":"YP00472","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR6NSMW4935","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:25.000000Z","updated_at":"2025-03-17T23:05:25.000000Z"},{"id":7768900,"change_date":"2024-01-12 21:44:00","inspection_id":"80605919","insp_unit_id":"198952127","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"666421\/WHT","insp_unit_license":"5814KT","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1JJV532D4GL927656","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:25.000000Z","updated_at":"2025-03-17T23:05:25.000000Z"}]},{"id":4138086,"change_date":"2023-10-05 21:40:00","inspection_id":"79846246","dot_number":"3108026","report_state":"CA","report_number":"ND7U007007","insp_date":"2023-09-27 00:00:00","insp_start_time":"0729","insp_end_time":"0859","registration_date":null,"region":"PT","ci_status_code":"C","location":"875","location_desc":"MOUNTAIN PASS CVEF","county_code_state":"CA","county_code":"071","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"NA","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120500","viol_total":"4","oos_total":"3","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15085672","transaction_code":"A","transaction_date":"2023-09-27 00:00:00","upload_date":"2023-10-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03108026","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-09-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-10-05 21:40:00","insp_carrier_name":"ARORA EXPRESS INC","insp_carrier_street":"6625 W BEECHWOOD AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93722","insp_colonia":null,"docket_number":"81197","insp_interstate":"Y","insp_carrier_state_id":"NONE","created_at":"2025-03-17T19:44:30.000000Z","updated_at":"2025-03-17T19:44:30.000000Z","inspection_violations":[{"id":6405708,"change_date":"2023-10-05 21:40:00","inspection_id":"79846246","insp_violation_id":"255688936","seq_no":"1","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"197424925","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"LD05930","created_at":"2025-03-17T21:36:54.000000Z","updated_at":"2025-03-17T21:36:54.000000Z","normalized_code":"39345D"},{"id":6405709,"change_date":"2023-10-05 21:40:00","inspection_id":"79846246","insp_violation_id":"255688937","seq_no":"2","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"197424925","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:36:54.000000Z","updated_at":"2025-03-17T21:36:54.000000Z","normalized_code":"39375A3"},{"id":6405710,"change_date":"2023-10-05 21:40:00","inspection_id":"79846246","insp_violation_id":"255688938","seq_no":"3","part_no":"393","part_no_section":"75(a)(1)","insp_viol_unit":"1","insp_unit_id":"197424925","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:54.000000Z","updated_at":"2025-03-17T21:36:54.000000Z","normalized_code":"39375A1"},{"id":6405711,"change_date":"2023-10-05 21:40:00","inspection_id":"79846246","insp_violation_id":"255688939","seq_no":"4","part_no":"395","part_no_section":"8(e)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:36:54.000000Z","updated_at":"2025-03-17T21:36:54.000000Z","normalized_code":"3958E1"}],"inspection_per_units":[{"id":6653914,"change_date":"2023-10-05 21:40:00","inspection_id":"79846246","insp_unit_id":"197424925","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHT 304","insp_unit_license":"YP00472","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR6NSMW4935","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:48.000000Z","updated_at":"2025-03-17T22:55:48.000000Z"},{"id":6653915,"change_date":"2023-10-05 21:40:00","inspection_id":"79846246","insp_unit_id":"197424926","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"WHT 554569","insp_unit_license":"4UP4453","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H3V532K3PS042062","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:48.000000Z","updated_at":"2025-03-17T22:55:48.000000Z"}]},{"id":4139037,"change_date":"2023-10-05 21:40:00","inspection_id":"79847262","dot_number":"3108026","report_state":"CA","report_number":"UET6001343","insp_date":"2023-09-27 00:00:00","insp_start_time":"1120","insp_end_time":"1145","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":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15086069","transaction_code":"A","transaction_date":"2023-09-27 00:00:00","upload_date":"2023-10-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03108026","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-09-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-10-05 21:40:00","insp_carrier_name":"ARORA EXPRESS INC","insp_carrier_street":"6625 W BEECHWOOD AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93722","insp_colonia":null,"docket_number":"81197","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:44:30.000000Z","updated_at":"2025-03-17T19:44:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6655403,"change_date":"2023-10-05 21:40:00","inspection_id":"79847262","insp_unit_id":"197426582","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHT 304","insp_unit_license":"YP00472","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR6NSMW4935","insp_unit_decal":"Y","insp_unit_decal_number":"32932691","created_at":"2025-03-17T22:55:50.000000Z","updated_at":"2025-03-17T22:55:50.000000Z"},{"id":6655404,"change_date":"2023-10-05 21:40:00","inspection_id":"79847262","insp_unit_id":"197426583","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"WHT 554569","insp_unit_license":"4UP4453","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H3V532K3PS042062","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:50.000000Z","updated_at":"2025-03-17T22:55:50.000000Z"}]},{"id":3887659,"change_date":"2023-09-01 21:39:00","inspection_id":"79567916","dot_number":"3108026","report_state":"NM","report_number":"5944N6RB8S","insp_date":"2023-08-31 00:00:00","insp_start_time":"0855","insp_end_time":"0930","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"RATON PORT OF ENTRY","county_code_state":"NM","county_code":"007","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MOLSON COORS","shipping_paper_number":"11997175","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"121000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2032514","transaction_code":"A","transaction_date":"2023-08-31 00:00:00","upload_date":"2023-09-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03108026","upload_search_indicator":null,"census_search_date":"2023-09-01 21:39:00","snet_input_date":"2023-09-01 00:00:00","source_office":"2NMS001","mcmis_add_date":"2023-09-01 21:39:00","insp_carrier_name":"ARORA EXPRESS INC","insp_carrier_street":"6625 W BEECHWOOD AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93722","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:39:42.000000Z","updated_at":"2025-03-17T19:39:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6250223,"change_date":"2023-09-01 21:39:00","inspection_id":"79567916","insp_unit_id":"196862469","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"UNIT307","insp_unit_license":"YP20161","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X5NJ102219","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:31.000000Z","updated_at":"2025-03-17T22:52:31.000000Z"},{"id":6250224,"change_date":"2023-09-01 21:39:00","inspection_id":"79567916","insp_unit_id":"196862470","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"UNITTA148482","insp_unit_license":"P399785","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V532C5FT02W34","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:31.000000Z","updated_at":"2025-03-17T22:52:31.000000Z"}]},{"id":2938785,"change_date":"2023-05-01 21:40:00","inspection_id":"78501327","dot_number":"3108026","report_state":"CA","report_number":"UFCR002375","insp_date":"2023-04-29 00:00:00","insp_start_time":"1915","insp_end_time":"1945","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"14880684","transaction_code":"A","transaction_date":"2023-04-29 00:00:00","upload_date":"2023-05-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03108026","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-04-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-05-01 21:40:00","insp_carrier_name":"ARORA EXPRESS INC","insp_carrier_street":"6625 W BEECHWOOD AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93722","insp_colonia":null,"docket_number":"81197","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:20:57.000000Z","updated_at":"2025-03-17T19:20:57.000000Z","inspection_violations":[{"id":4512988,"change_date":"2023-05-01 21:40:00","inspection_id":"78501327","insp_violation_id":"252558224","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194690778","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:01.000000Z","updated_at":"2025-03-17T21:28:01.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":4728474,"change_date":"2023-05-01 21:40:00","inspection_id":"78501327","insp_unit_id":"194690778","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"XP54521","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X1LJ395520","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:16.000000Z","updated_at":"2025-03-17T22:40:16.000000Z"}]},{"id":2978366,"change_date":"2023-05-05 21:42:00","inspection_id":"78546339","dot_number":"3108026","report_state":"SD","report_number":"A003036737","insp_date":"2023-04-28 00:00:00","insp_start_time":"1206","insp_end_time":"1320","registration_date":null,"region":"CT","ci_status_code":"C","location":"JPOE","location_desc":"JEFFERSON PORT OF ENTRY","county_code_state":"SD","county_code":"127","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"OLD DUTCH FOODS INC","shipping_paper_number":"1013672","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-05-05 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"641787","transaction_code":"A","transaction_date":"2023-04-28 00:00:00","upload_date":"2023-05-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03108026","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-05-04 00:00:00","source_office":"4SDS001","mcmis_add_date":"2023-05-05 21:42:00","insp_carrier_name":"ARORA EXPRESS INC","insp_carrier_street":"6625 W BEECHWOOD AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93722","insp_colonia":null,"docket_number":"81197","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:21:54.000000Z","updated_at":"2025-03-17T19:21:54.000000Z","inspection_violations":[{"id":4571391,"change_date":"2023-05-05 21:42:00","inspection_id":"78546339","insp_violation_id":"252657102","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":"WARNING","created_at":"2025-03-17T21:28:18.000000Z","updated_at":"2025-03-17T21:28:18.000000Z","normalized_code":"3958E1"},{"id":4571392,"change_date":"2023-05-05 21:42:00","inspection_id":"78546339","insp_violation_id":"252657103","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"194780107","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:28:18.000000Z","updated_at":"2025-03-17T21:28:18.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":4792011,"change_date":"2023-05-05 21:42:00","inspection_id":"78546339","insp_unit_id":"194780107","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"305","insp_unit_license":"YP00493","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X1NJ481042","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:46.000000Z","updated_at":"2025-03-17T22:40:46.000000Z"},{"id":4792012,"change_date":"2023-05-05 21:42:00","inspection_id":"78546339","insp_unit_id":"194780108","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"163401","insp_unit_license":"P579622","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAP0624HT107836","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:46.000000Z","updated_at":"2025-03-17T22:40:46.000000Z"}]},{"id":2713856,"change_date":"2023-04-03 21:39:00","inspection_id":"78246797","dot_number":"3108026","report_state":"AR","report_number":"758C000536","insp_date":"2023-04-02 00:00:00","insp_start_time":"1915","insp_end_time":"1955","registration_date":null,"region":"CT","ci_status_code":"C","location":"17-301","location_desc":"CRAWFORD COUNTY(ALMA EAST STN)","county_code_state":"AR","county_code":"033","insp_level_id":"2","service_center":"SH","census_source_id":"4","insp_facility":"F","shipper_name":"ROSS STORES INC","shipping_paper_number":"350147","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-04-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1452005","transaction_code":"A","transaction_date":"2023-04-03 00:00:00","upload_date":"2023-04-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03108026","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-04-03 00:00:00","source_office":"2ARS001","mcmis_add_date":"2023-04-03 21:39:00","insp_carrier_name":"ARORA EXPRESS INC","insp_carrier_street":"6625 W BEECHWOOD AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93722","insp_colonia":null,"docket_number":"81197","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:16:37.000000Z","updated_at":"2025-03-17T19:16:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4367433,"change_date":"2023-04-03 21:39:00","inspection_id":"78246797","insp_unit_id":"194182168","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"304","insp_unit_license":"YP00472","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR6NSMW4935","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:23.000000Z","updated_at":"2025-03-17T22:37:23.000000Z"},{"id":4367434,"change_date":"2023-04-03 21:39:00","inspection_id":"78246797","insp_unit_id":"194182169","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"808869","insp_unit_license":"PC15616","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1JJV532D9RL404488","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:23.000000Z","updated_at":"2025-03-17T22:37:23.000000Z"}]},{"id":2737075,"change_date":"2023-04-04 21:43:00","inspection_id":"78273033","dot_number":"3108026","report_state":"CA","report_number":"UFG0000760","insp_date":"2023-03-31 00:00:00","insp_start_time":"1130","insp_end_time":"1201","registration_date":null,"region":"PT","ci_status_code":"C","location":"480","location_desc":"VISALIA","county_code_state":"CA","county_code":"107","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-04 21:43: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":"14844207","transaction_code":"A","transaction_date":"2023-03-31 00:00:00","upload_date":"2023-04-04 00:00:00","upload_first_byte":"0","upload_dot_number":"03108026","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-03-31 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-04-04 21:43:00","insp_carrier_name":"ARORA EXPRESS INC","insp_carrier_street":"6625 W BEECHWOOD AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93722","insp_colonia":null,"docket_number":"81197","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:17:01.000000Z","updated_at":"2025-03-17T19:17:01.000000Z","inspection_violations":[{"id":4202251,"change_date":"2023-04-04 21:43:00","inspection_id":"78273033","insp_violation_id":"252053592","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":"MD91986","created_at":"2025-03-17T21:26:41.000000Z","updated_at":"2025-03-17T21:26:41.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4405873,"change_date":"2023-04-04 21:43:00","inspection_id":"78273033","insp_unit_id":"194234032","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"304","insp_unit_license":"YP00472","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR6NSMW4935","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:41.000000Z","updated_at":"2025-03-17T22:37:41.000000Z"},{"id":4405874,"change_date":"2023-04-04 21:43:00","inspection_id":"78273033","insp_unit_id":"194234033","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"HMKD803424","insp_unit_license":"P862457","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1JJV532D4NL334361","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:41.000000Z","updated_at":"2025-03-17T22:37:41.000000Z"}]},{"id":2568614,"change_date":"2023-03-13 21:43:00","inspection_id":"78081124","dot_number":"3108026","report_state":"TX","report_number":"6J590AGU0P","insp_date":"2023-03-06 00:00:00","insp_start_time":"0845","insp_end_time":"0925","registration_date":null,"region":"CT","ci_status_code":"C","location":"2A101","location_desc":"IH 10 EASTBOUND BROOKSHIRE","county_code_state":"TX","county_code":"473","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ROSS","shipping_paper_number":"1015490","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-13 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"8928549","transaction_code":"A","transaction_date":"2023-03-13 00:00:00","upload_date":"2023-03-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03108026","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-03-06 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-03-13 21:43:00","insp_carrier_name":"ARORA EXPRESS INC","insp_carrier_street":"6625 W BEECHWOOD AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93722","insp_colonia":null,"docket_number":"81197","insp_interstate":"Y","insp_carrier_state_id":"1000610","created_at":"2025-03-17T19:14:05.000000Z","updated_at":"2025-03-17T19:14:05.000000Z","inspection_violations":[{"id":3950979,"change_date":"2023-03-13 21:43:00","inspection_id":"78081124","insp_violation_id":"251636905","seq_no":"1","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"193849449","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:32.000000Z","updated_at":"2025-03-17T21:25:32.000000Z","normalized_code":"39345D"}],"inspection_per_units":[{"id":4134225,"change_date":"2023-03-13 21:43:00","inspection_id":"78081124","insp_unit_id":"193849449","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"302","insp_unit_license":"XP54521","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X1LJ395520","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:38.000000Z","updated_at":"2025-03-17T22:35:38.000000Z"},{"id":4134226,"change_date":"2023-03-13 21:43:00","inspection_id":"78081124","insp_unit_id":"193849450","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"674285","insp_unit_license":"BA5318","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1JJV532DXJL040098","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:38.000000Z","updated_at":"2025-03-17T22:35:38.000000Z"}]},{"id":2504825,"change_date":"2023-03-03 21:41:00","inspection_id":"78008311","dot_number":"3108026","report_state":"CA","report_number":"NDFA004330","insp_date":"2023-02-27 00:00:00","insp_start_time":"1706","insp_end_time":"1738","registration_date":null,"region":"PT","ci_status_code":"C","location":"424","location_desc":"GRAPEVINE IF","county_code_state":"CA","county_code":"029","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"FRITO LAY","shipping_paper_number":"64268535","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-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"6","oos_total":"3","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"5","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14805820","transaction_code":"A","transaction_date":"2023-02-28 00:00:00","upload_date":"2023-03-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03108026","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-02-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-03-03 21:41:00","insp_carrier_name":"ARORA EXPRESS INC","insp_carrier_street":"6625 W BEECHWOOD AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93722","insp_colonia":null,"docket_number":"81197","insp_interstate":"Y","insp_carrier_state_id":"529212","created_at":"2025-03-17T19:12:54.000000Z","updated_at":"2025-03-17T19:12:54.000000Z","inspection_violations":[{"id":3853502,"change_date":"2023-03-03 21:41:00","inspection_id":"78008311","insp_violation_id":"251477728","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"KR29047","created_at":"2025-03-17T21:25:05.000000Z","updated_at":"2025-03-17T21:25:05.000000Z","normalized_code":"38323A2"},{"id":3853503,"change_date":"2023-03-03 21:41:00","inspection_id":"78008311","insp_violation_id":"251477729","seq_no":"2","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"193705769","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"KR29047","created_at":"2025-03-17T21:25:05.000000Z","updated_at":"2025-03-17T21:25:05.000000Z","normalized_code":"39345"},{"id":3853504,"change_date":"2023-03-03 21:41:00","inspection_id":"78008311","insp_violation_id":"251477730","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193705769","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:05.000000Z","updated_at":"2025-03-17T21:25:05.000000Z","normalized_code":"3922"},{"id":3853505,"change_date":"2023-03-03 21:41:00","inspection_id":"78008311","insp_violation_id":"251477731","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"193705769","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-03-17T21:25:05.000000Z","updated_at":"2025-03-17T21:25:05.000000Z","normalized_code":"3963A1"},{"id":3853506,"change_date":"2023-03-03 21:41:00","inspection_id":"78008311","insp_violation_id":"251477732","seq_no":"5","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"193705769","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-03-17T21:25:05.000000Z","updated_at":"2025-03-17T21:25:05.000000Z","normalized_code":"39345B2"},{"id":3853507,"change_date":"2023-03-03 21:41:00","inspection_id":"78008311","insp_violation_id":"251477733","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"193705770","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"KR29047","created_at":"2025-03-17T21:25:05.000000Z","updated_at":"2025-03-17T21:25:05.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":4030955,"change_date":"2023-03-03 21:41:00","inspection_id":"78008311","insp_unit_id":"193705769","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"302","insp_unit_license":"XP54521","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X1LJ395520","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:54.000000Z","updated_at":"2025-03-17T22:34:54.000000Z"},{"id":4030956,"change_date":"2023-03-03 21:41:00","inspection_id":"78008311","insp_unit_id":"193705770","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"673733","insp_unit_license":"BA2105","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1JJV532D1JL039812","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:54.000000Z","updated_at":"2025-03-17T22:34:54.000000Z"}]},{"id":2441506,"change_date":"2023-02-23 21:41:00","inspection_id":"77936268","dot_number":"3108026","report_state":"CA","report_number":"NDLY005860","insp_date":"2023-02-22 00:00:00","insp_start_time":"1430","insp_end_time":"1443","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"3","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14796837","transaction_code":"A","transaction_date":"2023-02-22 00:00:00","upload_date":"2023-02-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03108026","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-02-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-23 21:41:00","insp_carrier_name":"ARORA EXPRESS INC","insp_carrier_street":"6625 W BEECHWOOD AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93722","insp_colonia":null,"docket_number":"81197","insp_interstate":"Y","insp_carrier_state_id":"529212","created_at":"2025-03-17T19:11:44.000000Z","updated_at":"2025-03-17T19:11:44.000000Z","inspection_violations":[{"id":3759240,"change_date":"2023-02-23 21:41:00","inspection_id":"77936268","insp_violation_id":"251314843","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193560284","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA299285","created_at":"2025-03-17T21:24:41.000000Z","updated_at":"2025-03-17T21:24:41.000000Z","normalized_code":"3939A"},{"id":3759241,"change_date":"2023-02-23 21:41:00","inspection_id":"77936268","insp_violation_id":"251314844","seq_no":"2","part_no":"395","part_no_section":"8","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:24:41.000000Z","updated_at":"2025-03-17T21:24:41.000000Z","normalized_code":"3958"},{"id":3759242,"change_date":"2023-02-23 21:41:00","inspection_id":"77936268","insp_violation_id":"251314845","seq_no":"3","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"193560284","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:41.000000Z","updated_at":"2025-03-17T21:24:41.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":3929240,"change_date":"2023-02-23 21:41:00","inspection_id":"77936268","insp_unit_id":"193560284","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"305\/WHT","insp_unit_license":"YP00493","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X1NJ481042","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:08.000000Z","updated_at":"2025-03-17T22:34:08.000000Z"}]},{"id":2377414,"change_date":"2023-02-15 21:38:00","inspection_id":"77863286","dot_number":"3108026","report_state":"AR","report_number":"768C000376","insp_date":"2023-02-14 00:00:00","insp_start_time":"2006","insp_end_time":"2100","registration_date":null,"region":"CT","ci_status_code":"C","location":"17-301","location_desc":"CRAWFORD COUNTY(ALMA EAST STN)","county_code_state":"AR","county_code":"033","insp_level_id":"2","service_center":"SH","census_source_id":"4","insp_facility":"F","shipper_name":"WAYFAIR","shipping_paper_number":"9Q18A194029354","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-02-15 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"3","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1444293","transaction_code":"A","transaction_date":"2023-02-15 00:00:00","upload_date":"2023-02-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03108026","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-02-15 00:00:00","source_office":"2ARS001","mcmis_add_date":"2023-02-15 21:38:00","insp_carrier_name":"ARORA EXPRESS INC","insp_carrier_street":"6625 W BEECHWOOD AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93722","insp_colonia":null,"docket_number":"81197","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:10:23.000000Z","updated_at":"2025-03-17T19:10:23.000000Z","inspection_violations":[{"id":3660766,"change_date":"2023-02-15 21:38:00","inspection_id":"77863286","insp_violation_id":"251149169","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":null,"created_at":"2025-03-17T21:24:17.000000Z","updated_at":"2025-03-17T21:24:17.000000Z","normalized_code":"3958E1"},{"id":3660767,"change_date":"2023-02-15 21:38:00","inspection_id":"77863286","insp_violation_id":"251149170","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"400A0396216","created_at":"2025-03-17T21:24:17.000000Z","updated_at":"2025-03-17T21:24:17.000000Z","normalized_code":"3922"},{"id":3660768,"change_date":"2023-02-15 21:38:00","inspection_id":"77863286","insp_violation_id":"251149171","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193411272","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:17.000000Z","updated_at":"2025-03-17T21:24:17.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":3825461,"change_date":"2023-02-15 21:38:00","inspection_id":"77863286","insp_unit_id":"193411272","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"305","insp_unit_license":"YP00493","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X1NJ481042","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:24.000000Z","updated_at":"2025-03-17T22:33:24.000000Z"},{"id":3825462,"change_date":"2023-02-15 21:38:00","inspection_id":"77863286","insp_unit_id":"193411273","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"1","insp_unit_license":"BT4401","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3H3V532K5PS074222","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:24.000000Z","updated_at":"2025-03-17T22:33:24.000000Z"}]},{"id":2153413,"change_date":"2023-01-17 21:42:00","inspection_id":"77607943","dot_number":"3108026","report_state":"NM","report_number":"8096N0ENHH","insp_date":"2023-01-14 00:00:00","insp_start_time":"1830","insp_end_time":"1845","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"GALLUP PORT OF ENTRY","county_code_state":"NM","county_code":"031","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"LEPRINO FOODS","shipping_paper_number":"945070","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-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"1972003","transaction_code":"A","transaction_date":"2023-01-15 00:00:00","upload_date":"2023-01-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03108026","upload_search_indicator":null,"census_search_date":"2023-01-17 21:42:00","snet_input_date":"2023-01-17 00:00:00","source_office":"2NMS001","mcmis_add_date":"2023-01-17 21:42:00","insp_carrier_name":"ARORA EXPRESS INC","insp_carrier_street":"6625 W BEECHWOOD AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93722","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:06:16.000000Z","updated_at":"2025-03-17T19:06:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3464773,"change_date":"2023-01-17 21:42:00","inspection_id":"77607943","insp_unit_id":"192895338","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"OOO307","insp_unit_license":"YP20161","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X5NJ102219","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:49.000000Z","updated_at":"2025-03-17T22:30:49.000000Z"},{"id":3464774,"change_date":"2023-01-17 21:42:00","inspection_id":"77607943","insp_unit_id":"192895339","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"OOO209765","insp_unit_license":"PA42886","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1DW1A5329NSA97297","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:49.000000Z","updated_at":"2025-03-17T22:30:49.000000Z"}]},{"id":1915511,"change_date":"2022-12-09 21:40:00","inspection_id":"77335488","dot_number":"3108026","report_state":"TN","report_number":"TFFA000055","insp_date":"2022-12-08 00:00:00","insp_start_time":"1530","insp_end_time":"1641","registration_date":null,"region":"CT","ci_status_code":"C","location":"75","location_desc":"I24 (SAM'S PARKING LOT)","county_code_state":"TN","county_code":"149","insp_level_id":"2","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"ROSS STORES, INC.","shipping_paper_number":"1004830","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":"Y","pen_cen_match":"I","final_status_date":"2022-12-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","viol_total":"5","oos_total":"3","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1616240","transaction_code":"A","transaction_date":"2022-12-08 00:00:00","upload_date":"2022-12-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03108026","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-12-09 00:00:00","source_office":"2TNS001","mcmis_add_date":"2022-12-09 21:40:00","insp_carrier_name":"ARORA EXPRESS INC","insp_carrier_street":"6625 W BEECHWOOD AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93722","insp_colonia":null,"docket_number":"81197","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:01:53.000000Z","updated_at":"2025-03-17T19:01:53.000000Z","inspection_violations":[{"id":2978423,"change_date":"2022-12-09 21:40:00","inspection_id":"77335488","insp_violation_id":"250025403","seq_no":"1","part_no":"395","part_no_section":"3(a)(3)(ii)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:08.000000Z","updated_at":"2025-03-17T21:21:08.000000Z","normalized_code":"3953A3II"},{"id":2978424,"change_date":"2022-12-09 21:40:00","inspection_id":"77335488","insp_violation_id":"250025404","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"192356589","insp_violation_category_id":"26","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:21:08.000000Z","updated_at":"2025-03-17T21:21:08.000000Z","normalized_code":"39378"},{"id":2978425,"change_date":"2022-12-09 21:40:00","inspection_id":"77335488","insp_violation_id":"250025405","seq_no":"3","part_no":"393","part_no_section":"65","insp_viol_unit":"1","insp_unit_id":"192356589","insp_violation_category_id":"18","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:21:08.000000Z","updated_at":"2025-03-17T21:21:08.000000Z","normalized_code":"39365"},{"id":2978426,"change_date":"2022-12-09 21:40:00","inspection_id":"77335488","insp_violation_id":"250025406","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192356589","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:08.000000Z","updated_at":"2025-03-17T21:21:08.000000Z","normalized_code":"3939A"},{"id":2978427,"change_date":"2022-12-09 21:40:00","inspection_id":"77335488","insp_violation_id":"250025407","seq_no":"5","part_no":"392","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"192356590","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:21:08.000000Z","updated_at":"2025-03-17T21:21:08.000000Z","normalized_code":"3929"}],"inspection_per_units":[{"id":3082048,"change_date":"2022-12-09 21:40:00","inspection_id":"77335488","insp_unit_id":"192356589","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"301","insp_unit_license":"XP98437","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X4KJ253791","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:06.000000Z","updated_at":"2025-03-17T22:28:06.000000Z"},{"id":3082049,"change_date":"2022-12-09 21:40:00","inspection_id":"77335488","insp_unit_id":"192356590","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"HMKD800452","insp_unit_license":"P853510","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1JJV532D0ML227127","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:06.000000Z","updated_at":"2025-03-17T22:28:06.000000Z"}]},{"id":1915407,"change_date":"2022-12-09 21:40:00","inspection_id":"77335363","dot_number":"3108026","report_state":"TN","report_number":"TEUN000175","insp_date":"2022-12-07 00:00:00","insp_start_time":"1306","insp_end_time":"1347","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"I24","county_code_state":"TN","county_code":"149","insp_level_id":"3","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"JB HUNT","shipping_paper_number":"00000","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":"Y","pen_cen_match":"I","final_status_date":"2022-12-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1616075","transaction_code":"A","transaction_date":"2022-12-07 00:00:00","upload_date":"2022-12-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03108026","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-12-09 00:00:00","source_office":"2TNS001","mcmis_add_date":"2022-12-09 21:40:00","insp_carrier_name":"ARORA EXPRESS INC","insp_carrier_street":"6625 W BEECHWOOD AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93722","insp_colonia":null,"docket_number":"81197","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:01:53.000000Z","updated_at":"2025-03-17T19:01:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3081873,"change_date":"2022-12-09 21:40:00","inspection_id":"77335363","insp_unit_id":"192356366","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"301","insp_unit_license":"XP98437","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X4KJ253791","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:06.000000Z","updated_at":"2025-03-17T22:28:06.000000Z"},{"id":3081874,"change_date":"2022-12-09 21:40:00","inspection_id":"77335363","insp_unit_id":"192356367","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"HMKD800452","insp_unit_license":"P853510","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":null,"insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:06.000000Z","updated_at":"2025-03-17T22:28:06.000000Z"}]},{"id":1874786,"change_date":"2022-12-05 21:40:00","inspection_id":"77288777","dot_number":"3108026","report_state":"CA","report_number":"NE46002030","insp_date":"2022-12-03 00:00:00","insp_start_time":"0101","insp_end_time":"0136","registration_date":null,"region":"PT","ci_status_code":"C","location":"424","location_desc":"GRAPEVINE IF","county_code_state":"CA","county_code":"029","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"FED EX","shipping_paper_number":"00923","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14696539","transaction_code":"A","transaction_date":"2022-12-03 00:00:00","upload_date":"2022-12-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03108026","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-12-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-12-05 21:40:00","insp_carrier_name":"ARORA EXPRESS INC","insp_carrier_street":"6625 W BEECHWOOD AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93722","insp_colonia":null,"docket_number":"81197","insp_interstate":"Y","insp_carrier_state_id":"529212","created_at":"2025-03-17T19:01:08.000000Z","updated_at":"2025-03-17T19:01:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3017702,"change_date":"2022-12-05 21:40:00","inspection_id":"77288777","insp_unit_id":"192267325","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"304","insp_unit_license":"YP00472","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR6NSMW4935","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:39.000000Z","updated_at":"2025-03-17T22:27:39.000000Z"},{"id":3017703,"change_date":"2022-12-05 21:40:00","inspection_id":"77288777","insp_unit_id":"192267326","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"FEDZ558634","insp_unit_license":"PA14582","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GR1P0625MJ233936","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:39.000000Z","updated_at":"2025-03-17T22:27:39.000000Z"}]},{"id":1804727,"change_date":"2022-11-23 21:39:00","inspection_id":"77208664","dot_number":"3108026","report_state":"AR","report_number":"A524004448","insp_date":"2022-11-23 00:00:00","insp_start_time":"1715","insp_end_time":"1750","registration_date":null,"region":"CT","ci_status_code":"C","location":"60","location_desc":"PULASKI COUNTY","county_code_state":"AR","county_code":"119","insp_level_id":"3","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"ROSS DRESS FOR LESS","shipping_paper_number":"1002823","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-11-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"1431631","transaction_code":"A","transaction_date":"2022-11-23 00:00:00","upload_date":"2022-11-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03108026","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-11-23 00:00:00","source_office":"2ARS001","mcmis_add_date":"2022-11-23 21:39:00","insp_carrier_name":"ARORA EXPRESS INC","insp_carrier_street":"6625 W BEECHWOOD AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93722","insp_colonia":null,"docket_number":"81197","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:59:58.000000Z","updated_at":"2025-03-17T18:59:58.000000Z","inspection_violations":[{"id":2823415,"change_date":"2022-11-23 21:39:00","inspection_id":"77208664","insp_violation_id":"249764128","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"500A0443797","created_at":"2025-03-17T21:20:24.000000Z","updated_at":"2025-03-17T21:20:24.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2902920,"change_date":"2022-11-23 21:39:00","inspection_id":"77208664","insp_unit_id":"192105051","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"306\/WHT","insp_unit_license":"YP00495","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR8NSMW4936","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:52.000000Z","updated_at":"2025-03-17T22:26:52.000000Z"},{"id":2902921,"change_date":"2022-11-23 21:39:00","inspection_id":"77208664","insp_unit_id":"192105052","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"807485","insp_unit_license":"PC10328","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1JJV532D2PL403095","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:52.000000Z","updated_at":"2025-03-17T22:26:52.000000Z"}]},{"id":1785745,"change_date":"2022-11-21 21:41:00","inspection_id":"77187001","dot_number":"3108026","report_state":"TN","report_number":"TFHZ000007","insp_date":"2022-11-18 00:00:00","insp_start_time":"0935","insp_end_time":"0956","registration_date":null,"region":"ET","ci_status_code":"C","location":"SCALES","location_desc":"THP 5 I-81 GREENE SCALES","county_code_state":"TN","county_code":"059","insp_level_id":"3","service_center":"SH","census_source_id":"4","insp_facility":"F","shipper_name":"EAST PENN MANUFACTURING CO","shipping_paper_number":"T1775908","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":"Y","pen_cen_match":"I","final_status_date":"2022-11-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118200","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1612707","transaction_code":"A","transaction_date":"2022-11-18 00:00:00","upload_date":"2022-11-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03108026","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-11-21 00:00:00","source_office":"2TNS001","mcmis_add_date":"2022-11-21 21:41:00","insp_carrier_name":"ARORA EXPRESS INC","insp_carrier_street":"6625 W BEECHWOOD AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93722","insp_colonia":null,"docket_number":"81197","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:59:38.000000Z","updated_at":"2025-03-17T18:59:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2872619,"change_date":"2022-11-21 21:41:00","inspection_id":"77187001","insp_unit_id":"192062147","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KWDT","insp_unit_company":"307","insp_unit_license":"YP20161","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X5NJ102219","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:39.000000Z","updated_at":"2025-03-17T22:26:39.000000Z"},{"id":2872620,"change_date":"2022-11-21 21:41:00","inspection_id":"77187001","insp_unit_id":"192062148","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"666366","insp_unit_license":"5759KT","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1JJV532D1GL927601","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:39.000000Z","updated_at":"2025-03-17T22:26:39.000000Z"}]},{"id":1634697,"change_date":"2022-10-31 21:40:00","inspection_id":"77013679","dot_number":"3108026","report_state":"TN","report_number":"5Z19104700","insp_date":"2022-10-28 00:00:00","insp_start_time":"1130","insp_end_time":"1230","registration_date":null,"region":"ET","ci_status_code":"C","location":"S","location_desc":"GREENE COUNTY SCALES","county_code_state":"TN","county_code":"059","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"WESTROCK","shipping_paper_number":"567789","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-31 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"71200","viol_total":"3","oos_total":"1","driver_viol_total":"3","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1608449","transaction_code":"A","transaction_date":"2022-10-28 00:00:00","upload_date":"2022-10-31 00:00:00","upload_first_byte":"0","upload_dot_number":"03108026","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-10-28 00:00:00","source_office":"2TNS001","mcmis_add_date":"2022-10-31 21:40:00","insp_carrier_name":"ARORA EXPRESS INC","insp_carrier_street":"6625 W BEECHWOOD AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93722","insp_colonia":null,"docket_number":"81197","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:56:42.000000Z","updated_at":"2025-03-17T18:56:42.000000Z","inspection_violations":[{"id":2565077,"change_date":"2022-10-31 21:40:00","inspection_id":"77013679","insp_violation_id":"249335165","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:07.000000Z","updated_at":"2025-03-17T21:19:07.000000Z","normalized_code":"3922"},{"id":2565078,"change_date":"2022-10-31 21:40:00","inspection_id":"77013679","insp_violation_id":"249335166","seq_no":"2","part_no":"395","part_no_section":"22(g)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:07.000000Z","updated_at":"2025-03-17T21:19:07.000000Z","normalized_code":"39522G"},{"id":2565079,"change_date":"2022-10-31 21:40:00","inspection_id":"77013679","insp_violation_id":"249335167","seq_no":"3","part_no":"395","part_no_section":"8(e)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:07.000000Z","updated_at":"2025-03-17T21:19:07.000000Z","normalized_code":"3958E1"}],"inspection_per_units":[{"id":2629388,"change_date":"2022-10-31 21:40:00","inspection_id":"77013679","insp_unit_id":"191717949","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"307","insp_unit_license":"YP20161","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X5NJ102219","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:01.000000Z","updated_at":"2025-03-17T22:25:01.000000Z"},{"id":2629389,"change_date":"2022-10-31 21:40:00","inspection_id":"77013679","insp_unit_id":"191717950","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"JBHZ671760","insp_unit_license":"9861L0","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1JJV532D5HL012736","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:01.000000Z","updated_at":"2025-03-17T22:25:01.000000Z"}]},{"id":1106777,"change_date":"2022-08-22 21:43:00","inspection_id":"76402168","dot_number":"3108026","report_state":"CA","report_number":"UDD0001923","insp_date":"2022-08-20 00:00:00","insp_start_time":"2045","insp_end_time":"2111","registration_date":null,"region":"PT","ci_status_code":"C","location":"424","location_desc":"GCVEF","county_code_state":"CA","county_code":"029","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-22 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"14558763","transaction_code":"A","transaction_date":"2022-08-20 00:00:00","upload_date":"2022-08-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03108026","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-08-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-08-22 21:43:00","insp_carrier_name":"ARORA EXPRESS INC","insp_carrier_street":"6625 W BEECHWOOD AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93722","insp_colonia":null,"docket_number":"81197","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:47:13.000000Z","updated_at":"2025-03-17T18:47:13.000000Z","inspection_violations":[{"id":1744157,"change_date":"2022-08-22 21:43:00","inspection_id":"76402168","insp_violation_id":"247907908","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190475110","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-03-17T21:15:09.000000Z","updated_at":"2025-03-17T21:15:09.000000Z","normalized_code":"3939A"},{"id":1744158,"change_date":"2022-08-22 21:43:00","inspection_id":"76402168","insp_violation_id":"247907909","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"190475110","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-03-17T21:15:09.000000Z","updated_at":"2025-03-17T21:15:09.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":1780482,"change_date":"2022-08-22 21:43:00","inspection_id":"76402168","insp_unit_id":"190475110","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"XP98437","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X4KJ253791","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:15.000000Z","updated_at":"2025-03-17T22:19:15.000000Z"}]},{"id":889435,"change_date":"2022-07-25 21:40:00","inspection_id":"76147837","dot_number":"3108026","report_state":"CA","report_number":"UFEV001876","insp_date":"2022-07-24 00:00:00","insp_start_time":"0745","insp_end_time":"0809","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"840452716","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-07-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"114000","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":"14519319","transaction_code":"A","transaction_date":"2022-07-24 00:00:00","upload_date":"2022-07-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03108026","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-07-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-07-25 21:40:00","insp_carrier_name":"ARORA EXPRESS INC","insp_carrier_street":"6625 W BEECHWOOD AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93722","insp_colonia":null,"docket_number":"81197","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:43:23.000000Z","updated_at":"2025-03-17T18:43:23.000000Z","inspection_violations":[{"id":1400831,"change_date":"2022-07-25 21:40:00","inspection_id":"76147837","insp_violation_id":"247298896","seq_no":"1","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"KR57566","created_at":"2025-03-17T21:13:39.000000Z","updated_at":"2025-03-17T21:13:39.000000Z","normalized_code":"3958A1"}],"inspection_per_units":[{"id":1432008,"change_date":"2022-07-25 21:40:00","inspection_id":"76147837","insp_unit_id":"189954529","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"WHI","insp_unit_license":"XP98437","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X4KJ253791","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:00.000000Z","updated_at":"2025-03-17T22:17:00.000000Z"},{"id":1432009,"change_date":"2022-07-25 21:40:00","inspection_id":"76147837","insp_unit_id":"189954530","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"WHI","insp_unit_license":"5038015","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1UYVS5235N2502319","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:00.000000Z","updated_at":"2025-03-17T22:17:00.000000Z"}]},{"id":828315,"change_date":"2022-07-18 21:42:00","inspection_id":"76076749","dot_number":"3108026","report_state":"NE","report_number":"0175001132","insp_date":"2022-07-15 00:00:00","insp_start_time":"0850","insp_end_time":"0928","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"MM188.5 WB I80","county_code_state":"NE","county_code":"111","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"LAPP USA","shipping_paper_number":"412345679101557","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":null,"post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"3","oos_total":"1","driver_viol_total":"3","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"736112","transaction_code":"C","transaction_date":"2022-07-18 00:00:00","upload_date":"2022-07-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03108026","upload_search_indicator":"M","census_search_date":"2022-07-18 21:42:00","snet_input_date":"2022-07-15 00:00:00","source_office":"3NES001","mcmis_add_date":"2022-07-15 21:40:00","insp_carrier_name":"ARORA EXPRESS INC","insp_carrier_street":"6625 W BEECHWOOD AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93722","insp_colonia":null,"docket_number":"81197","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:42:17.000000Z","updated_at":"2025-03-17T18:42:17.000000Z","inspection_violations":[{"id":1305354,"change_date":"2022-07-18 21:42:00","inspection_id":"76076749","insp_violation_id":"247150905","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"EA4201085","created_at":"2025-03-17T21:13:10.000000Z","updated_at":"2025-03-17T21:13:10.000000Z","normalized_code":"3922"},{"id":1305355,"change_date":"2022-07-18 21:42:00","inspection_id":"76076749","insp_violation_id":"247150906","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:10.000000Z","updated_at":"2025-03-17T21:13:10.000000Z","normalized_code":"3922"},{"id":1305356,"change_date":"2022-07-18 21:42:00","inspection_id":"76076749","insp_violation_id":"247150907","seq_no":"3","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"EA4201085","created_at":"2025-03-17T21:13:10.000000Z","updated_at":"2025-03-17T21:13:10.000000Z","normalized_code":"3958A1"}],"inspection_per_units":[{"id":1332574,"change_date":"2022-07-18 21:42:00","inspection_id":"76076749","insp_unit_id":"189827061","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"304","insp_unit_license":"YP00472","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR6NSMW4935","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:22.000000Z","updated_at":"2025-03-17T22:16:22.000000Z"},{"id":1332575,"change_date":"2022-07-18 21:42:00","inspection_id":"76076749","insp_unit_id":"189827062","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"215","insp_unit_license":"4TN8246","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GR1A0624MW318626","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:22.000000Z","updated_at":"2025-03-17T22:16:22.000000Z"}]},{"id":632983,"change_date":"2022-06-16 21:43:00","inspection_id":"75847485","dot_number":"3108026","report_state":"CA","report_number":"NB7B000575","insp_date":"2022-06-15 00:00:00","insp_start_time":"1354","insp_end_time":"1439","registration_date":null,"region":"PT","ci_status_code":"C","location":"435","location_desc":"5249 N. CORNELIA AVE.","county_code_state":"CA","county_code":"019","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":"2022-06-16 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120500","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":"14471776","transaction_code":"A","transaction_date":"2022-06-15 00:00:00","upload_date":"2022-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03108026","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-06-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-06-16 21:43:00","insp_carrier_name":"ARORA EXPRESS INC","insp_carrier_street":"6625 W BEECHWOOD AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93722","insp_colonia":null,"docket_number":"81197","insp_interstate":"Y","insp_carrier_state_id":"529212","created_at":"2025-03-17T18:38:49.000000Z","updated_at":"2025-03-17T18:38:49.000000Z","inspection_violations":[{"id":995603,"change_date":"2022-06-16 21:43:00","inspection_id":"75847485","insp_violation_id":"246537200","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"189309553","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:38.000000Z","updated_at":"2025-03-17T21:11:38.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":1017856,"change_date":"2022-06-16 21:43:00","inspection_id":"75847485","insp_unit_id":"189309552","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"306","insp_unit_license":"YP00495","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR8NSMW4936","insp_unit_decal":"Y","insp_unit_decal_number":"31127153","created_at":"2025-03-17T22:14:27.000000Z","updated_at":"2025-03-17T22:14:27.000000Z"},{"id":1017857,"change_date":"2022-06-16 21:43:00","inspection_id":"75847485","insp_unit_id":"189309553","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"222","insp_unit_license":"4TN8630","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GR1A0628MW223292","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:27.000000Z","updated_at":"2025-03-17T22:14:27.000000Z"}]},{"id":620962,"change_date":"2022-06-15 21:41:00","inspection_id":"75833125","dot_number":"3108026","report_state":"CA","report_number":"NB7B000573","insp_date":"2022-06-14 00:00:00","insp_start_time":"1503","insp_end_time":"1548","registration_date":null,"region":"PT","ci_status_code":"C","location":"435","location_desc":"5249 N. CORNELIA AVE.","county_code_state":"CA","county_code":"019","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":"2022-06-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118200","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14469885","transaction_code":"A","transaction_date":"2022-06-14 00:00:00","upload_date":"2022-06-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03108026","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-06-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-06-15 21:41:00","insp_carrier_name":"ARORA EXPRESS INC","insp_carrier_street":"6625 W BEECHWOOD AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93722","insp_colonia":null,"docket_number":"81197","insp_interstate":"Y","insp_carrier_state_id":"529212","created_at":"2025-03-17T18:38:46.000000Z","updated_at":"2025-03-17T18:38:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":998786,"change_date":"2022-06-15 21:41:00","inspection_id":"75833125","insp_unit_id":"189279283","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"305","insp_unit_license":"YP00493","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X1NJ481042","insp_unit_decal":"Y","insp_unit_decal_number":"31127151","created_at":"2025-03-17T22:14:20.000000Z","updated_at":"2025-03-17T22:14:20.000000Z"},{"id":998787,"change_date":"2022-06-15 21:41:00","inspection_id":"75833125","insp_unit_id":"189279284","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"218","insp_unit_license":"275949F","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GR1A062XMW318629","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:20.000000Z","updated_at":"2025-03-17T22:14:20.000000Z"}]},{"id":620963,"change_date":"2022-06-15 21:41:00","inspection_id":"75833126","dot_number":"3108026","report_state":"CA","report_number":"NB7B000574","insp_date":"2022-06-14 00:00:00","insp_start_time":"1552","insp_end_time":"1641","registration_date":null,"region":"PT","ci_status_code":"C","location":"435","location_desc":"5249 N. CORNELIA AVE.","county_code_state":"CA","county_code":"019","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":"2022-06-15 21:41: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":"14469597","transaction_code":"A","transaction_date":"2022-06-14 00:00:00","upload_date":"2022-06-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03108026","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-06-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-06-15 21:41:00","insp_carrier_name":"ARORA EXPRESS INC","insp_carrier_street":"6625 W BEECHWOOD AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93722","insp_colonia":null,"docket_number":"81197","insp_interstate":"Y","insp_carrier_state_id":"529212","created_at":"2025-03-17T18:38:46.000000Z","updated_at":"2025-03-17T18:38:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":998788,"change_date":"2022-06-15 21:41:00","inspection_id":"75833126","insp_unit_id":"189279285","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"310","insp_unit_license":"YP30415","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDRXNSNC1939","insp_unit_decal":"Y","insp_unit_decal_number":"31127152","created_at":"2025-03-17T22:14:20.000000Z","updated_at":"2025-03-17T22:14:20.000000Z"},{"id":998789,"change_date":"2022-06-15 21:41:00","inspection_id":"75833126","insp_unit_id":"189279286","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"226","insp_unit_license":"5038016","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1UYVS2535N2693319","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:20.000000Z","updated_at":"2025-03-17T22:14:20.000000Z"}]},{"id":442190,"change_date":"2022-05-20 21:41:00","inspection_id":"75620154","dot_number":"3108026","report_state":"NM","report_number":"7741M3U1CC","insp_date":"2022-05-18 00:00:00","insp_start_time":"0100","insp_end_time":"0130","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":"NEW STAR LOGISTICS","shipping_paper_number":"3681952523","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"121300","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":"1907320","transaction_code":"A","transaction_date":"2022-05-19 00:00:00","upload_date":"2022-05-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03108026","upload_search_indicator":null,"census_search_date":"2022-05-20 21:41:00","snet_input_date":"2022-05-19 00:00:00","source_office":"2NMS001","mcmis_add_date":"2022-05-20 21:41:00","insp_carrier_name":"ARORA EXPRESS INC","insp_carrier_street":"6625 W BEECHWOOD AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93722","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:35:35.000000Z","updated_at":"2025-03-17T18:35:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":712658,"change_date":"2022-05-20 21:41:00","inspection_id":"75620154","insp_unit_id":"188811831","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"310","insp_unit_license":"YP30415","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDRXNSNC1939","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:34.000000Z","updated_at":"2025-03-17T22:12:34.000000Z"},{"id":712659,"change_date":"2022-05-20 21:41:00","inspection_id":"75620154","insp_unit_id":"188811832","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"801863","insp_unit_license":"P855664","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1JJV532D3ML238705","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:34.000000Z","updated_at":"2025-03-17T22:12:34.000000Z"}]},{"id":41982,"change_date":"2022-04-18 21:40:00","inspection_id":"75138812","dot_number":"3108026","report_state":"KY","report_number":"CV44302228","insp_date":"2022-03-24 00:00:00","insp_start_time":"1900","insp_end_time":"1939","registration_date":"2022-04-18 00:00:00","region":"CD","ci_status_code":"C","location":"9815","location_desc":"FRANKLIN","county_code_state":"KY","county_code":"213","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"GEMCO, INC","shipping_paper_number":"221021","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-03-25 21:31: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":"2091520","transaction_code":"C","transaction_date":"2022-03-25 00:00:00","upload_date":"2022-04-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03108026","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-03-25 00:00:00","source_office":"2KYS001","mcmis_add_date":"2022-03-25 21:31:00","insp_carrier_name":"ARORA EXPRESS INC","insp_carrier_street":"6625 W BEECHWOOD AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93722","insp_colonia":null,"docket_number":"81197","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:28:24.000000Z","updated_at":"2025-03-17T18:28:24.000000Z","inspection_violations":[{"id":59865,"change_date":"2022-04-18 21:40:00","inspection_id":"75138812","insp_violation_id":"245204667","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DZ43954","created_at":"2025-03-17T21:07:21.000000Z","updated_at":"2025-03-17T21:07:21.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":67474,"change_date":"2022-04-18 21:40:00","inspection_id":"75138812","insp_unit_id":"188192184","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"310","insp_unit_license":"YP30415","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDRXNSNC1939","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:40.000000Z","updated_at":"2025-03-17T22:08:40.000000Z"},{"id":67475,"change_date":"2022-04-18 21:40:00","inspection_id":"75138812","insp_unit_id":"188192185","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"222","insp_unit_license":"4TN8630","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GR1A0628MW223292","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:40.000000Z","updated_at":"2025-03-17T22:08:40.000000Z"}]}],"first_page_url":"https:\/\/www.searchcarriers.com\/company\/3108026\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/www.searchcarriers.com\/company\/3108026\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/www.searchcarriers.com\/company\/3108026\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next »","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/www.searchcarriers.com\/company\/3108026\/inspections","per_page":100,"prev_page_url":null,"to":27,"total":27}