{"current_page":1,"data":[{"id":12066100,"change_date":"2026-06-01 21:41:00","inspection_id":"88008049","dot_number":"1079656","report_state":"OK","report_number":"R600000297","insp_date":"2026-06-01 00:00:00","insp_start_time":"0908","insp_end_time":"0955","registration_date":null,"region":"CS","ci_status_code":"C","location":"055CTY","location_desc":"OK","county_code_state":"OK","county_code":"109","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"135412","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-06-01 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"39900","viol_total":"8","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3441725","transaction_code":"A","transaction_date":"2026-06-01 00:00:00","upload_date":"2026-06-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01079656","upload_search_indicator":null,"census_search_date":"2026-06-01 21:41:00","snet_input_date":"2026-06-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-01 21:41:00","insp_carrier_name":"JOE'S HOTSHOT AND TRUCKING LLC","insp_carrier_street":"4893 N ALFADALE ROAD","insp_carrier_city":"EL RENO","insp_carrier_state":"OK","insp_carrier_zip_code":"73036","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-05T09:39:03.000000Z","updated_at":"2026-06-12T09:30:58.000000Z","inspection_violations":[{"id":20994833,"change_date":"2026-06-01 21:41:00","inspection_id":"88008049","insp_violation_id":"274617596","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"213850097","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-05T09:55:39.000000Z","updated_at":"2026-06-12T09:41:49.000000Z","normalized_code":"39378"},{"id":20994835,"change_date":"2026-06-01 21:41:00","inspection_id":"88008049","insp_violation_id":"274617598","seq_no":"4","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"2","insp_unit_id":"213850098","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-06-05T09:55:39.000000Z","updated_at":"2026-06-12T09:41:49.000000Z","normalized_code":"3963A1BOS"},{"id":20994834,"change_date":"2026-06-01 21:41:00","inspection_id":"88008049","insp_violation_id":"274617597","seq_no":"3","part_no":"393","part_no_section":"43D-B","insp_viol_unit":"2","insp_unit_id":"213850098","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-06-05T09:55:39.000000Z","updated_at":"2026-06-12T09:41:49.000000Z","normalized_code":"39343DB"},{"id":20994832,"change_date":"2026-06-01 21:41:00","inspection_id":"88008049","insp_violation_id":"274617595","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"213850097","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-05T09:55:39.000000Z","updated_at":"2026-06-12T09:41:49.000000Z","normalized_code":"3922SLLSR"},{"id":20994836,"change_date":"2026-06-01 21:41:00","inspection_id":"88008049","insp_violation_id":"274617599","seq_no":"5","part_no":"393","part_no_section":"42A-BM","insp_viol_unit":"2","insp_unit_id":"213850098","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-05T09:55:39.000000Z","updated_at":"2026-06-12T09:41:49.000000Z","normalized_code":"39342ABM"},{"id":20994837,"change_date":"2026-06-01 21:41:00","inspection_id":"88008049","insp_violation_id":"274617600","seq_no":"6","part_no":"393","part_no_section":"42A-BM","insp_viol_unit":"2","insp_unit_id":"213850098","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-05T09:55:39.000000Z","updated_at":"2026-06-12T09:41:49.000000Z","normalized_code":"39342ABM"},{"id":20994838,"change_date":"2026-06-01 21:41:00","inspection_id":"88008049","insp_violation_id":"274617601","seq_no":"7","part_no":"393","part_no_section":"42A-BM","insp_viol_unit":"2","insp_unit_id":"213850098","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-05T09:55:39.000000Z","updated_at":"2026-06-12T09:41:49.000000Z","normalized_code":"39342ABM"},{"id":20994839,"change_date":"2026-06-01 21:41:00","inspection_id":"88008049","insp_violation_id":"274617602","seq_no":"8","part_no":"393","part_no_section":"42A-BM","insp_viol_unit":"2","insp_unit_id":"213850098","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-05T09:55:39.000000Z","updated_at":"2026-06-12T09:41:49.000000Z","normalized_code":"39342ABM"}],"inspection_per_units":[{"id":20969643,"change_date":"2026-06-01 21:41:00","inspection_id":"88008049","insp_unit_id":"213850098","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"T-19","insp_unit_license":"8711JK","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"16VGX4025C2613019","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-05T09:15:33.000000Z","updated_at":"2026-06-12T09:02:21.000000Z"},{"id":20969642,"change_date":"2026-06-01 21:41:00","inspection_id":"88008049","insp_unit_id":"213850097","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"70","insp_unit_license":"3GV438","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3C63RRGL0LG219443","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-05T09:15:33.000000Z","updated_at":"2026-06-12T09:02:21.000000Z"}]},{"id":11836479,"change_date":"2026-05-06 21:40:00","inspection_id":"87771839","dot_number":"1079656","report_state":"KS","report_number":"0313003349","insp_date":"2026-05-04 00:00:00","insp_start_time":"1000","insp_end_time":"1020","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ANTHONY KS","county_code_state":"KS","county_code":"077","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"WOOLSEY","shipping_paper_number":"NO BOL#","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-05-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"29500","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":"3267177","transaction_code":"A","transaction_date":"2026-05-05 00:00:00","upload_date":"2026-05-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01079656","upload_search_indicator":null,"census_search_date":"2026-05-06 21:40:00","snet_input_date":"2026-05-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-06 21:40:00","insp_carrier_name":"JOE'S HOTSHOT AND TRUCKING LLC","insp_carrier_street":"4893 N ALFADALE ROAD","insp_carrier_city":"EL RENO","insp_carrier_state":"OK","insp_carrier_zip_code":"73036","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-09T09:40:12.000000Z","updated_at":"2026-05-16T13:23:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20585092,"change_date":"2026-05-06 21:40:00","inspection_id":"87771839","insp_unit_id":"213406193","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"73","insp_unit_license":"3NS651","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FD0X5HT3REF25797","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-09T09:18:17.000000Z","updated_at":"2026-05-16T12:31:26.000000Z"},{"id":20585093,"change_date":"2026-05-06 21:40:00","inspection_id":"87771839","insp_unit_id":"213406194","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNKNOWN","insp_unit_company":null,"insp_unit_license":"NOREG","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"00000000000000000","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-09T09:18:17.000000Z","updated_at":"2026-05-16T12:31:26.000000Z"}]},{"id":11417906,"change_date":"2026-03-19 21:39:00","inspection_id":"87333636","dot_number":"1079656","report_state":"OK","report_number":"N914154984","insp_date":"2026-03-19 00:00:00","insp_start_time":"0830","insp_end_time":"0855","registration_date":null,"region":"CT","ci_status_code":"C","location":"009CRD","location_desc":"BANNER RD NB WILSHIRE","county_code_state":"OK","county_code":"017","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"000","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-03-19 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"152000","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":"815501","transaction_code":"A","transaction_date":"2026-03-19 00:00:00","upload_date":"2026-03-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01079656","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-03-19 00:00:00","source_office":"2OKS001","mcmis_add_date":"2026-03-19 21:39:00","insp_carrier_name":"JOE'S HOTSHOT AND TRUCKING LLC","insp_carrier_street":"4893 N ALFADALE ROAD","insp_carrier_city":"EL RENO","insp_carrier_state":"OK","insp_carrier_zip_code":"73036","insp_colonia":null,"docket_number":"503295","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-22T09:50:53.000000Z","updated_at":"2026-03-30T09:32:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19558472,"change_date":"2026-03-19 21:39:00","inspection_id":"87333636","insp_unit_id":"212221237","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"40","insp_unit_license":"735112","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XPDDB9X2XD476130","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-22T09:32:31.000000Z","updated_at":"2026-03-30T09:06:40.000000Z"},{"id":19558473,"change_date":"2026-03-19 21:39:00","inspection_id":"87333636","insp_unit_id":"212221238","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLK","insp_unit_company":"T-12","insp_unit_license":"3376GZ","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1TKB053337B061779","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-22T09:32:31.000000Z","updated_at":"2026-03-30T09:06:40.000000Z"}]},{"id":11398406,"change_date":"2026-03-26 21:40:00","inspection_id":"87313337","dot_number":"1079656","report_state":"OK","report_number":"X900201957","insp_date":"2026-03-17 00:00:00","insp_start_time":"0740","insp_end_time":"0830","registration_date":"2026-03-26 00:00:00","region":"CT","ci_status_code":"C","location":"09081","location_desc":"US 81 N\/B AT HWY 3","county_code_state":"OK","county_code":"017","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"EMPTY","shipping_paper_number":"EMPTY","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-03-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"39900","viol_total":"4","oos_total":"2","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"815254","transaction_code":"C","transaction_date":"2026-03-17 00:00:00","upload_date":"2026-03-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01079656","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2026-03-17 00:00:00","source_office":"2OKS001","mcmis_add_date":"2026-03-17 21:39:00","insp_carrier_name":"JOE'S HOTSHOT AND TRUCKING LLC","insp_carrier_street":"4893 N ALFADALE ROAD","insp_carrier_city":"EL RENO","insp_carrier_state":"OK","insp_carrier_zip_code":"73036","insp_colonia":null,"docket_number":"503295","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-20T09:42:35.000000Z","updated_at":"2026-04-06T09:32:08.000000Z","inspection_violations":[{"id":19393453,"change_date":"2026-03-26 21:40:00","inspection_id":"87313337","insp_violation_id":"272662901","seq_no":"1","part_no":"392","part_no_section":"2-SLLS1","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":"2026-03-29T10:23:19.000000Z","updated_at":"2026-04-06T09:56:02.000000Z","normalized_code":"3922SLLS1"},{"id":19393454,"change_date":"2026-03-26 21:40:00","inspection_id":"87313337","insp_violation_id":"272662902","seq_no":"2","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"1","insp_unit_id":"212357601","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-29T10:23:19.000000Z","updated_at":"2026-04-06T09:56:02.000000Z","normalized_code":"3939ALRLI"},{"id":19393455,"change_date":"2026-03-26 21:40:00","inspection_id":"87313337","insp_violation_id":"272662903","seq_no":"3","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"212357602","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-03-29T10:23:19.000000Z","updated_at":"2026-04-06T09:56:02.000000Z","normalized_code":"39375A3TAOL"},{"id":19393456,"change_date":"2026-03-26 21:40:00","inspection_id":"87313337","insp_violation_id":"272662904","seq_no":"4","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"212357602","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-03-29T10:23:19.000000Z","updated_at":"2026-04-06T09:56:02.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":19675874,"change_date":"2026-03-26 21:40:00","inspection_id":"87313337","insp_unit_id":"212357601","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"3GV438","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3C63RRGL0LG219443","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-29T09:50:58.000000Z","updated_at":"2026-04-06T09:12:01.000000Z"},{"id":19675875,"change_date":"2026-03-26 21:40:00","inspection_id":"87313337","insp_unit_id":"212357602","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":null,"insp_unit_license":"8711JK","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"16VGX4025C2613019","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-29T09:50:58.000000Z","updated_at":"2026-04-06T09:12:01.000000Z"}]},{"id":8796341,"change_date":"2025-06-12 21:41:00","inspection_id":"84842795","dot_number":"1079656","report_state":"OK","report_number":"X900201418","insp_date":"2025-06-02 00:00:00","insp_start_time":"1010","insp_end_time":"1045","registration_date":"2025-06-12 00:00:00","region":"CT","ci_status_code":"C","location":"09081","location_desc":"US 81 N\/B 164TH ST","county_code_state":"OK","county_code":"017","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","shipping_paper_number":"M\/C","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-06-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"135560","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"786945","transaction_code":"C","transaction_date":"2025-06-02 00:00:00","upload_date":"2025-06-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01079656","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-06-02 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-06-02 21:39:00","insp_carrier_name":"JOE'S HOTSHOT AND TRUCKING LLC","insp_carrier_street":"4893 N ALFADALE ROAD","insp_carrier_city":"EL RENO","insp_carrier_state":"OK","insp_carrier_zip_code":"73036","insp_colonia":null,"docket_number":"503295","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-05T10:00:29.000000Z","updated_at":"2025-06-16T10:00:25.000000Z","inspection_violations":[{"id":14235520,"change_date":"2025-06-12 21:41:00","inspection_id":"84842795","insp_violation_id":"266811194","seq_no":"1","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"207356121","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-17T10:17:08.000000Z","updated_at":"2025-06-17T10:19:01.000000Z","normalized_code":"3939ALHLI"},{"id":14235521,"change_date":"2025-06-12 21:41:00","inspection_id":"84842795","insp_violation_id":"266811195","seq_no":"2","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"207356121","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-17T10:17:08.000000Z","updated_at":"2025-06-17T10:19:01.000000Z","normalized_code":"39378AWS"},{"id":14235522,"change_date":"2025-06-12 21:41:00","inspection_id":"84842795","insp_violation_id":"266811196","seq_no":"3","part_no":"393","part_no_section":"9A-LSLIWR","insp_viol_unit":"2","insp_unit_id":"207356122","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-06-17T10:17:08.000000Z","updated_at":"2025-06-17T10:19:01.000000Z","normalized_code":"3939ALSLIWR"},{"id":14235523,"change_date":"2025-06-12 21:41:00","inspection_id":"84842795","insp_violation_id":"266811197","seq_no":"4","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"2","insp_unit_id":"207356122","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-17T10:17:08.000000Z","updated_at":"2025-06-17T10:19:01.000000Z","normalized_code":"3939ALCL"}],"inspection_per_units":[{"id":14547310,"change_date":"2025-06-12 21:41:00","inspection_id":"84842795","insp_unit_id":"207356121","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"41","insp_unit_license":"735111","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XP5DB9X11D562763","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-15T09:46:28.000000Z","updated_at":"2025-06-16T09:45:34.000000Z"},{"id":14547311,"change_date":"2025-06-12 21:41:00","inspection_id":"84842795","insp_unit_id":"207356122","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VIKI","insp_unit_company":null,"insp_unit_license":"6751JZ","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1V9CR4621EN062987","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-15T09:46:28.000000Z","updated_at":"2025-06-16T09:45:34.000000Z"}]},{"id":6851599,"change_date":"2024-09-30 21:41:00","inspection_id":"82793056","dot_number":"1079656","report_state":"OK","report_number":"U200164429","insp_date":"2024-09-30 00:00:00","insp_start_time":"1220","insp_end_time":"1237","registration_date":null,"region":"CT","ci_status_code":"C","location":"037081","location_desc":"KINGFISHER","county_code_state":"OK","county_code":"073","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"135560","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":"763025","transaction_code":"A","transaction_date":"2024-09-30 00:00:00","upload_date":"2024-09-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01079656","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-09-30 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-09-30 21:41:00","insp_carrier_name":"JOE'S HOTSHOT AND TRUCKING LLC","insp_carrier_street":"4893 N ALFADALE ROAD","insp_carrier_city":"EL RENO","insp_carrier_state":"OK","insp_carrier_zip_code":"73036","insp_colonia":null,"docket_number":"503295","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:39:01.000000Z","updated_at":"2025-03-17T20:39:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11049163,"change_date":"2024-09-30 21:41:00","inspection_id":"82793056","insp_unit_id":"203191924","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"41","insp_unit_license":"3LB143","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XP5DB9X11D562763","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:24.000000Z","updated_at":"2025-03-17T23:37:24.000000Z"},{"id":11049164,"change_date":"2024-09-30 21:41:00","inspection_id":"82793056","insp_unit_id":"203191925","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VIKI","insp_unit_company":"T-40","insp_unit_license":"6751JZ","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1V9CR4621EN062987","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:24.000000Z","updated_at":"2025-03-17T23:37:24.000000Z"}]},{"id":6596693,"change_date":"2024-08-29 21:43:00","inspection_id":"82521822","dot_number":"1079656","report_state":"OK","report_number":"C813153396","insp_date":"2024-08-29 00:00:00","insp_start_time":"1020","insp_end_time":"1040","registration_date":null,"region":"CT","ci_status_code":"C","location":"09081","location_desc":"SH 3 \/ US 81","county_code_state":"OK","county_code":"017","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","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-08-29 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"38000","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":"759656","transaction_code":"A","transaction_date":"2024-08-29 00:00:00","upload_date":"2024-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01079656","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-08-29 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-08-29 21:43:00","insp_carrier_name":"JOE'S HOTSHOT AND TRUCKING LLC","insp_carrier_street":"4893 N ALFADALE ROAD","insp_carrier_city":"EL RENO","insp_carrier_state":"OK","insp_carrier_zip_code":"73036","insp_colonia":null,"docket_number":"503295","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:33:42.000000Z","updated_at":"2025-03-17T20:33:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10635103,"change_date":"2024-08-29 21:43:00","inspection_id":"82521822","insp_unit_id":"202654754","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"72","insp_unit_license":"3HN076","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3C63RRGL5NG316043","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:10.000000Z","updated_at":"2025-03-17T23:33:10.000000Z"},{"id":10635104,"change_date":"2024-08-29 21:43:00","inspection_id":"82521822","insp_unit_id":"202654755","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"24","insp_unit_license":"6780JZ","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"16VGX4027D2674549","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:10.000000Z","updated_at":"2025-03-17T23:33:10.000000Z"}]},{"id":6298866,"change_date":"2024-07-30 21:44:00","inspection_id":"82203635","dot_number":"1079656","report_state":"OK","report_number":"Y200200247","insp_date":"2024-07-24 00:00:00","insp_start_time":"1022","insp_end_time":"1047","registration_date":"2024-07-29 00:00:00","region":"CT","ci_status_code":"C","location":"037033","location_desc":"SH33 1\/2E N2720","county_code_state":"OK","county_code":"073","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","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":"2024-07-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"128000","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":"755514","transaction_code":"C","transaction_date":"2024-07-24 00:00:00","upload_date":"2024-07-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01079656","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-07-24 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-07-24 21:42:00","insp_carrier_name":"JOE'S HOTSHOT AND TRUCKING LLC","insp_carrier_street":"4893 N ALFADALE ROAD","insp_carrier_city":"EL RENO","insp_carrier_state":"OK","insp_carrier_zip_code":"73036","insp_colonia":null,"docket_number":"503295","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:27:26.000000Z","updated_at":"2025-03-17T20:27:26.000000Z","inspection_violations":[{"id":9782494,"change_date":"2024-07-30 21:44:00","inspection_id":"82203635","insp_violation_id":"260919771","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":null,"created_at":"2025-03-17T21:53:20.000000Z","updated_at":"2025-03-17T21:53:20.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10149334,"change_date":"2024-07-30 21:44:00","inspection_id":"82203635","insp_unit_id":"202147761","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"19","insp_unit_license":"2PR344","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XP5DB9X3WN442917","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:08.000000Z","updated_at":"2025-03-17T23:28:08.000000Z"},{"id":10149335,"change_date":"2024-07-30 21:44:00","inspection_id":"82203635","insp_unit_id":"202147762","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DORS","insp_unit_company":"T28","insp_unit_license":"5373KZ","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5JYDF5323EE085602","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:08.000000Z","updated_at":"2025-03-17T23:28:08.000000Z"}]},{"id":6287611,"change_date":"2024-07-30 21:43:00","inspection_id":"82191583","dot_number":"1079656","report_state":"OK","report_number":"N914154065","insp_date":"2024-07-23 00:00:00","insp_start_time":"0915","insp_end_time":"0950","registration_date":"2024-07-29 00:00:00","region":"CT","ci_status_code":"C","location":"009081","location_desc":"US 81 NB AND MEMORIAL","county_code_state":"OK","county_code":"017","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"162000","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":"755253","transaction_code":"C","transaction_date":"2024-07-26 00:00:00","upload_date":"2024-07-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01079656","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-07-23 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-07-23 21:42:00","insp_carrier_name":"JOE'S HOTSHOT AND TRUCKING LLC","insp_carrier_street":"4893 N ALFADALE ROAD","insp_carrier_city":"EL RENO","insp_carrier_state":"OK","insp_carrier_zip_code":"73036","insp_colonia":null,"docket_number":"503295","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:27:23.000000Z","updated_at":"2025-03-17T20:27:23.000000Z","inspection_violations":[{"id":9765653,"change_date":"2024-07-30 21:43:00","inspection_id":"82191583","insp_violation_id":"260919217","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":null,"created_at":"2025-03-17T21:53:15.000000Z","updated_at":"2025-03-17T21:53:15.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10131045,"change_date":"2024-07-30 21:43:00","inspection_id":"82191583","insp_unit_id":"202147326","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"40","insp_unit_license":"2WY438","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XPDDB9X2XD476130","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:58.000000Z","updated_at":"2025-03-17T23:27:58.000000Z"},{"id":10131046,"change_date":"2024-07-30 21:43:00","inspection_id":"82191583","insp_unit_id":"202147327","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLK","insp_unit_company":"T-12","insp_unit_license":"3376GZ","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XPDDB9X2XD476130","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:58.000000Z","updated_at":"2025-03-17T23:27:58.000000Z"}]},{"id":5909349,"change_date":"2024-06-04 21:42:00","inspection_id":"81783881","dot_number":"1079656","report_state":"OK","report_number":"S100152354","insp_date":"2024-06-04 00:00:00","insp_start_time":"1410","insp_end_time":"1440","registration_date":null,"region":"CT","ci_status_code":"C","location":"22060","location_desc":"5W SEILING","county_code_state":"OK","county_code":"043","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-04 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"39000","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":"749826","transaction_code":"A","transaction_date":"2024-06-04 00:00:00","upload_date":"2024-06-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01079656","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-06-04 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-06-04 21:42:00","insp_carrier_name":"JOE'S HOTSHOT AND TRUCKING LLC","insp_carrier_street":"4893 N ALFADALE ROAD","insp_carrier_city":"EL RENO","insp_carrier_state":"OK","insp_carrier_zip_code":"73036","insp_colonia":null,"docket_number":"503295","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:19:50.000000Z","updated_at":"2025-03-17T20:19:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9517861,"change_date":"2024-06-04 21:42:00","inspection_id":"81783881","insp_unit_id":"201225193","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"72","insp_unit_license":"3HN076","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3C63RRGL5NG316043","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:43.000000Z","updated_at":"2025-03-17T23:21:43.000000Z"},{"id":9517862,"change_date":"2024-06-04 21:42:00","inspection_id":"81783881","insp_unit_id":"201225194","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"24","insp_unit_license":"6780JZ","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"16VGX4027D2674549","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:43.000000Z","updated_at":"2025-03-17T23:21:43.000000Z"}]},{"id":5896273,"change_date":"2024-06-06 21:41:00","inspection_id":"81769796","dot_number":"1079656","report_state":"OK","report_number":"S100152350","insp_date":"2024-06-03 00:00:00","insp_start_time":"1337","insp_end_time":"1400","registration_date":"2024-06-06 00:00:00","region":"CT","ci_status_code":"C","location":"06270","location_desc":"4SE OAKWOOD","county_code_state":"OK","county_code":"011","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"DRILLCO","shipping_paper_number":"130027","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":"2024-06-03 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"148000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"749685","transaction_code":"C","transaction_date":"2024-06-03 00:00:00","upload_date":"2024-06-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01079656","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-06-03 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-06-03 21:42:00","insp_carrier_name":"JOE'S HOTSHOT AND TRUCKING LLC","insp_carrier_street":"4893 N ALFADALE ROAD","insp_carrier_city":"EL RENO","insp_carrier_state":"OK","insp_carrier_zip_code":"73036","insp_colonia":null,"docket_number":"503295","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:19:30.000000Z","updated_at":"2025-03-17T20:19:30.000000Z","inspection_violations":[{"id":9142568,"change_date":"2024-06-06 21:41:00","inspection_id":"81769796","insp_violation_id":"259940950","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":null,"created_at":"2025-03-17T21:50:14.000000Z","updated_at":"2025-03-17T21:50:14.000000Z","normalized_code":"3922"},{"id":9142569,"change_date":"2024-06-06 21:41:00","inspection_id":"81769796","insp_violation_id":"259940951","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201266969","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:14.000000Z","updated_at":"2025-03-17T21:50:14.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9496837,"change_date":"2024-06-06 21:41:00","inspection_id":"81769796","insp_unit_id":"201266969","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"41","insp_unit_license":"3CA864","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XP5DB9X11D562763","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:32.000000Z","updated_at":"2025-03-17T23:21:32.000000Z"},{"id":9496838,"change_date":"2024-06-06 21:41:00","inspection_id":"81769796","insp_unit_id":"201266970","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRANS","insp_unit_company":"T17","insp_unit_license":"8694JK","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1TTE5130371083439","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:32.000000Z","updated_at":"2025-03-17T23:21:32.000000Z"}]},{"id":5806794,"change_date":"2024-05-21 21:46:00","inspection_id":"81672485","dot_number":"1079656","report_state":"OK","report_number":"M407155706","insp_date":"2024-05-20 00:00:00","insp_start_time":"1650","insp_end_time":"1703","registration_date":null,"region":"CT","ci_status_code":"C","location":"30283","location_desc":"U.S. 64 JCT","county_code_state":"OK","county_code":"059","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-21 21:46:00","post_acc_ind":"N","gross_comb_veh_wt":"152000","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":"748108","transaction_code":"A","transaction_date":"2024-05-21 00:00:00","upload_date":"2024-05-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01079656","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-05-20 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-05-21 21:46:00","insp_carrier_name":"JOE'S HOTSHOT AND TRUCKING LLC","insp_carrier_street":"4893 N ALFADALE ROAD","insp_carrier_city":"EL RENO","insp_carrier_state":"OK","insp_carrier_zip_code":"73036","insp_colonia":null,"docket_number":"503295","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:17:52.000000Z","updated_at":"2025-03-17T20:17:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9352101,"change_date":"2024-05-21 21:46:00","inspection_id":"81672485","insp_unit_id":"201010732","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"41","insp_unit_license":"3CA864","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XP5DB9X11D562763","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:06.000000Z","updated_at":"2025-03-17T23:20:06.000000Z"},{"id":9352102,"change_date":"2024-05-21 21:46:00","inspection_id":"81672485","insp_unit_id":"201010733","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRANS","insp_unit_company":null,"insp_unit_license":"8694JK","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1TTE5130371083439","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:06.000000Z","updated_at":"2025-03-17T23:20:06.000000Z"}]},{"id":5750546,"change_date":"2024-05-15 21:42:00","inspection_id":"81611707","dot_number":"1079656","report_state":"AR","report_number":"5590000084","insp_date":"2024-05-15 00:00:00","insp_start_time":"1310","insp_end_time":"1345","registration_date":null,"region":"CD","ci_status_code":"C","location":"301","location_desc":"VAN BUREN AR","county_code_state":"AR","county_code":"033","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"ACS PLAYGROUND ADVENTURES","shipping_paper_number":"129791","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-05-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"39900","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":"484924","transaction_code":"A","transaction_date":"2024-05-15 00:00:00","upload_date":"2024-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01079656","upload_search_indicator":null,"census_search_date":"2024-05-15 21:42:00","snet_input_date":"2024-05-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-15 21:42:00","insp_carrier_name":"JOE'S HOTSHOT AND TRUCKING LLC","insp_carrier_street":"4893 N ALFADALE ROAD","insp_carrier_city":"EL RENO","insp_carrier_state":"OK","insp_carrier_zip_code":"73036","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:16:42.000000Z","updated_at":"2025-03-17T20:16:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9262205,"change_date":"2024-05-15 21:42:00","inspection_id":"81611707","insp_unit_id":"200896161","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":"70","insp_unit_license":"3GV438","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3C63RRGL0LG219443","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:12.000000Z","updated_at":"2025-03-17T23:19:12.000000Z"},{"id":9262206,"change_date":"2024-05-15 21:42:00","inspection_id":"81611707","insp_unit_id":"200896162","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIG TEX","insp_unit_company":null,"insp_unit_license":"8711JK","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"16VGX4025C2613019","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:12.000000Z","updated_at":"2025-03-17T23:19:12.000000Z"}]},{"id":5575258,"change_date":"2024-04-30 21:41:00","inspection_id":"81420992","dot_number":"1079656","report_state":"OK","report_number":"V900172139","insp_date":"2024-04-23 00:00:00","insp_start_time":"0726","insp_end_time":"0750","registration_date":"2024-04-30 00:00:00","region":"CT","ci_status_code":"C","location":"44076","location_desc":"SH 76 \/ NW 8TH (BLANCHARD)","county_code_state":"OK","county_code":"087","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","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":"744714","transaction_code":"C","transaction_date":"2024-04-23 00:00:00","upload_date":"2024-04-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01079656","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-04-23 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-04-23 21:41:00","insp_carrier_name":"JOE'S HOTSHOT AND TRUCKING LLC","insp_carrier_street":"4893 N ALFADALE ROAD","insp_carrier_city":"EL RENO","insp_carrier_state":"OK","insp_carrier_zip_code":"73036","insp_colonia":null,"docket_number":"503295","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:10.000000Z","updated_at":"2025-03-17T20:13:10.000000Z","inspection_violations":[{"id":8616697,"change_date":"2024-04-30 21:41:00","inspection_id":"81420992","insp_violation_id":"259223411","seq_no":"1","part_no":"392","part_no_section":"16(a)","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:47:43.000000Z","updated_at":"2025-03-17T21:47:43.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":8980662,"change_date":"2024-04-30 21:41:00","inspection_id":"81420992","insp_unit_id":"200649469","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"45","insp_unit_license":"2TT556","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1NP5LB0X36D652398","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:34.000000Z","updated_at":"2025-03-17T23:16:34.000000Z"}]},{"id":5317771,"change_date":"2024-03-19 21:45:00","inspection_id":"81140169","dot_number":"1079656","report_state":"OK","report_number":"N914153875","insp_date":"2024-03-19 00:00:00","insp_start_time":"1340","insp_end_time":"1400","registration_date":null,"region":"CT","ci_status_code":"C","location":"009081","location_desc":"US 81 NB AND 44TH","county_code_state":"OK","county_code":"017","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-19 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"130000","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":"740920","transaction_code":"A","transaction_date":"2024-03-19 00:00:00","upload_date":"2024-03-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01079656","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-03-19 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-03-19 21:45:00","insp_carrier_name":"JOE'S HOTSHOT AND TRUCKING LLC","insp_carrier_street":"4893 N ALFADALE ROAD","insp_carrier_city":"EL RENO","insp_carrier_state":"OK","insp_carrier_zip_code":"73036","insp_colonia":null,"docket_number":"503295","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:07:56.000000Z","updated_at":"2025-03-17T20:07:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8564316,"change_date":"2024-03-19 21:45:00","inspection_id":"81140169","insp_unit_id":"199981653","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"19","insp_unit_license":"2PR344","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XP5DB9X3WN442917","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:36.000000Z","updated_at":"2025-03-17T23:12:36.000000Z"},{"id":8564317,"change_date":"2024-03-19 21:45:00","inspection_id":"81140169","insp_unit_id":"199981654","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DORS","insp_unit_company":"T-28","insp_unit_license":"5373KZ","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5JYDF5323EE085602","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:36.000000Z","updated_at":"2025-03-17T23:12:36.000000Z"}]},{"id":4421386,"change_date":"2023-11-27 21:41:00","inspection_id":"80159470","dot_number":"1079656","report_state":"OK","report_number":"A910153247","insp_date":"2023-11-13 00:00:00","insp_start_time":"1035","insp_end_time":"1110","registration_date":"2023-11-20 00:00:00","region":"CT","ci_status_code":"C","location":"026081","location_desc":"2 S RUSH SPRINGS \/ US 81","county_code_state":"OK","county_code":"051","insp_level_id":"2","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":"N","pen_cen_match":null,"final_status_date":"2023-11-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"128000","viol_total":"6","oos_total":"3","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"728403","transaction_code":"C","transaction_date":"2023-11-14 00:00:00","upload_date":"2023-11-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01079656","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-11-13 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-11-14 21:41:00","insp_carrier_name":"JOE'S HOTSHOT AND TRUCKING LLC","insp_carrier_street":"4893 N ALFADALE ROAD","insp_carrier_city":"EL RENO","insp_carrier_state":"OK","insp_carrier_zip_code":"73036","insp_colonia":null,"docket_number":"503295","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:50:40.000000Z","updated_at":"2025-03-17T19:50:40.000000Z","inspection_violations":[{"id":6841046,"change_date":"2023-11-27 21:41:00","inspection_id":"80159470","insp_violation_id":"256556502","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:59.000000Z","updated_at":"2025-03-17T21:38:59.000000Z","normalized_code":"39216A"},{"id":6841047,"change_date":"2023-11-27 21:41:00","inspection_id":"80159470","insp_violation_id":"256556503","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198207739","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:59.000000Z","updated_at":"2025-03-17T21:38:59.000000Z","normalized_code":"3939A"},{"id":6841048,"change_date":"2023-11-27 21:41:00","inspection_id":"80159470","insp_violation_id":"256556504","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198207739","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:59.000000Z","updated_at":"2025-03-17T21:38:59.000000Z","normalized_code":"3939A"},{"id":6841049,"change_date":"2023-11-27 21:41:00","inspection_id":"80159470","insp_violation_id":"256556505","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"198207740","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:38:59.000000Z","updated_at":"2025-03-17T21:38:59.000000Z","normalized_code":"3939A"},{"id":6841050,"change_date":"2023-11-27 21:41:00","inspection_id":"80159470","insp_violation_id":"256556506","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"198207740","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:38:59.000000Z","updated_at":"2025-03-17T21:38:59.000000Z","normalized_code":"3939A"},{"id":6841051,"change_date":"2023-11-27 21:41:00","inspection_id":"80159470","insp_violation_id":"256556507","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"198207740","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:38:59.000000Z","updated_at":"2025-03-17T21:38:59.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":7110254,"change_date":"2023-11-27 21:41:00","inspection_id":"80159470","insp_unit_id":"198207739","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"19","insp_unit_license":"2PR344","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XP5DB9X3WN442917","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:43.000000Z","updated_at":"2025-03-17T22:59:43.000000Z"},{"id":7110255,"change_date":"2023-11-27 21:41:00","inspection_id":"80159470","insp_unit_id":"198207740","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VIKI","insp_unit_company":"33","insp_unit_license":"AK8445","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1V9DS5329JN062197","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:43.000000Z","updated_at":"2025-03-17T22:59:43.000000Z"}]},{"id":4311801,"change_date":"2023-11-27 21:41:00","inspection_id":"80038275","dot_number":"1079656","report_state":"OK","report_number":"I904155167","insp_date":"2023-10-30 00:00:00","insp_start_time":"1215","insp_end_time":"1237","registration_date":"2023-11-27 00:00:00","region":"CT","ci_status_code":"C","location":"26081","location_desc":"US 81 & 62 CHICKASKA","county_code_state":"OK","county_code":"051","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"NA","shipping_paper_number":"NA","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-10-30 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"130000","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":"727156","transaction_code":"C","transaction_date":"2023-10-30 00:00:00","upload_date":"2023-11-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01079656","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-10-30 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-10-30 21:42:00","insp_carrier_name":"JOE'S HOTSHOT AND TRUCKING LLC","insp_carrier_street":"4893 N ALFADALE ROAD","insp_carrier_city":"EL RENO","insp_carrier_state":"OK","insp_carrier_zip_code":"73036","insp_colonia":null,"docket_number":"503295","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:48:22.000000Z","updated_at":"2025-03-17T19:48:22.000000Z","inspection_violations":[{"id":6669727,"change_date":"2023-11-27 21:41:00","inspection_id":"80038275","insp_violation_id":"256557391","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:06.000000Z","updated_at":"2025-03-17T21:38:06.000000Z","normalized_code":"3922"},{"id":6669728,"change_date":"2023-11-27 21:41:00","inspection_id":"80038275","insp_violation_id":"256557392","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:06.000000Z","updated_at":"2025-03-17T21:38:06.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6934596,"change_date":"2023-11-27 21:41:00","inspection_id":"80038275","insp_unit_id":"198208552","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"18","insp_unit_license":"2NV913","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XP5DB9XXTN420215","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:11.000000Z","updated_at":"2025-03-17T22:58:11.000000Z"},{"id":6934597,"change_date":"2023-11-27 21:41:00","inspection_id":"80038275","insp_unit_id":"198208553","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DORS","insp_unit_company":"T28","insp_unit_license":"5373KZ","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5JYDF5323EE085602","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:11.000000Z","updated_at":"2025-03-17T22:58:11.000000Z"}]},{"id":3878514,"change_date":"2023-08-31 21:42:00","inspection_id":"79557612","dot_number":"1079656","report_state":"OK","report_number":"I904155099","insp_date":"2023-08-30 00:00:00","insp_start_time":"1312","insp_end_time":"1337","registration_date":null,"region":"CT","ci_status_code":"C","location":"26081","location_desc":"US 81 & 152 W MINCO","county_code_state":"OK","county_code":"051","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"NA","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-08-31 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"38000","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":"721098","transaction_code":"A","transaction_date":"2023-08-31 00:00:00","upload_date":"2023-08-31 00:00:00","upload_first_byte":"0","upload_dot_number":"01079656","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-08-30 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-08-31 21:42:00","insp_carrier_name":"JOE'S HOTSHOT AND TRUCKING LLC","insp_carrier_street":"4893 N ALFADALE ROAD","insp_carrier_city":"EL RENO","insp_carrier_state":"OK","insp_carrier_zip_code":"73036","insp_colonia":null,"docket_number":"503295","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:39:25.000000Z","updated_at":"2025-03-17T19:39:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6235326,"change_date":"2023-08-31 21:42:00","inspection_id":"79557612","insp_unit_id":"196841015","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"72","insp_unit_license":"3HN076","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3C63RRGL5NG316043","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:24.000000Z","updated_at":"2025-03-17T22:52:24.000000Z"},{"id":6235327,"change_date":"2023-08-31 21:42:00","inspection_id":"79557612","insp_unit_id":"196841016","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"24","insp_unit_license":"6780JZ","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"16VGX4027D2674549","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:24.000000Z","updated_at":"2025-03-17T22:52:24.000000Z"}]},{"id":3293065,"change_date":"2023-06-22 21:41:00","inspection_id":"78901467","dot_number":"1079656","report_state":"OK","report_number":"X200171454","insp_date":"2023-06-14 00:00:00","insp_start_time":"0957","insp_end_time":"1015","registration_date":"2023-06-22 00:00:00","region":"CT","ci_status_code":"C","location":"06270","location_desc":"US270\/1.5 W WATONGA","county_code_state":"OK","county_code":"011","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"148000","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":"713207","transaction_code":"C","transaction_date":"2023-06-15 00:00:00","upload_date":"2023-06-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01079656","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-06-14 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-06-15 21:42:00","insp_carrier_name":"JOES HOTSHOT & TRUCKING LLC","insp_carrier_street":"4893 N ALFADALE ROAD","insp_carrier_city":"EL RENO","insp_carrier_state":"OK","insp_carrier_zip_code":"73036","insp_colonia":null,"docket_number":"503295","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:28:10.000000Z","updated_at":"2025-03-17T19:28:10.000000Z","inspection_violations":[{"id":5077927,"change_date":"2023-06-22 21:41:00","inspection_id":"78901467","insp_violation_id":"253640877","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:30:35.000000Z","updated_at":"2025-03-17T21:30:35.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5294135,"change_date":"2023-06-22 21:41:00","inspection_id":"78901467","insp_unit_id":"195623051","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"41","insp_unit_license":"3CA864","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XP5DB9X11D562763","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:43.000000Z","updated_at":"2025-03-17T22:44:43.000000Z"},{"id":5294136,"change_date":"2023-06-22 21:41:00","inspection_id":"78901467","insp_unit_id":"195623052","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRANS","insp_unit_company":"T17","insp_unit_license":"8694JK","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1TTE5130371083439","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:43.000000Z","updated_at":"2025-03-17T22:44:43.000000Z"}]},{"id":1797114,"change_date":"2022-11-28 21:41:00","inspection_id":"77199989","dot_number":"1079656","report_state":"OK","report_number":"S100151352","insp_date":"2022-11-22 00:00:00","insp_start_time":"1046","insp_end_time":"1104","registration_date":"2022-11-28 00:00:00","region":"CT","ci_status_code":"C","location":"05040","location_desc":"ELK CITY","county_code_state":"OK","county_code":"009","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"130000","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":"691845","transaction_code":"C","transaction_date":"2022-11-22 00:00:00","upload_date":"2022-11-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01079656","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-11-22 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-11-22 21:41:00","insp_carrier_name":"JOES HOTSHOT & TRUCKING LLC","insp_carrier_street":"4893 N ALFADALE ROAD","insp_carrier_city":"EL RENO","insp_carrier_state":"OK","insp_carrier_zip_code":"73036","insp_colonia":null,"docket_number":"503295","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:59:41.000000Z","updated_at":"2025-03-17T18:59:41.000000Z","inspection_violations":[{"id":2809784,"change_date":"2022-11-28 21:41:00","inspection_id":"77199989","insp_violation_id":"249794360","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"N477306","created_at":"2025-03-17T21:20:16.000000Z","updated_at":"2025-03-17T21:20:16.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":2890563,"change_date":"2022-11-28 21:41:00","inspection_id":"77199989","insp_unit_id":"192136828","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"19","insp_unit_license":"2PR344","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XP5DB9X3WN442917","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:48.000000Z","updated_at":"2025-03-17T22:26:48.000000Z"},{"id":2890564,"change_date":"2022-11-28 21:41:00","inspection_id":"77199989","insp_unit_id":"192136829","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VIKI","insp_unit_company":"T33","insp_unit_license":"AK8445","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1V9DS5329JN062197","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:48.000000Z","updated_at":"2025-03-17T22:26:48.000000Z"}]},{"id":1386679,"change_date":"2022-09-28 21:40:00","inspection_id":"76727150","dot_number":"1079656","report_state":"OK","report_number":"C106153241","insp_date":"2022-09-28 00:00:00","insp_start_time":"1103","insp_end_time":"1140","registration_date":null,"region":"CT","ci_status_code":"C","location":"440TP","location_desc":"BLANCHARD","county_code_state":"OK","county_code":"087","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","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-09-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"163250","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":"685790","transaction_code":"A","transaction_date":"2022-09-28 00:00:00","upload_date":"2022-09-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01079656","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-09-28 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-09-28 21:40:00","insp_carrier_name":"JOES HOTSHOT & TRUCKING LLC","insp_carrier_street":"4893 N ALFADALE ROAD","insp_carrier_city":"EL RENO","insp_carrier_state":"OK","insp_carrier_zip_code":"73036","insp_colonia":null,"docket_number":"503295","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:52:19.000000Z","updated_at":"2025-03-17T18:52:19.000000Z","inspection_violations":[{"id":2190934,"change_date":"2022-09-28 21:40:00","inspection_id":"76727150","insp_violation_id":"248693928","seq_no":"1","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"191142980","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:02.000000Z","updated_at":"2025-03-17T21:17:02.000000Z","normalized_code":"39360C"},{"id":2190935,"change_date":"2022-09-28 21:40:00","inspection_id":"76727150","insp_violation_id":"248693929","seq_no":"2","part_no":"393","part_no_section":"51","insp_viol_unit":"1","insp_unit_id":"191142980","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:02.000000Z","updated_at":"2025-03-17T21:17:02.000000Z","normalized_code":"39351"}],"inspection_per_units":[{"id":2232833,"change_date":"2022-09-28 21:40:00","inspection_id":"76727150","insp_unit_id":"191142980","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"41","insp_unit_license":"3CA864","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XP5DB9X11D562763","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:16.000000Z","updated_at":"2025-03-17T22:22:16.000000Z"},{"id":2232834,"change_date":"2022-09-28 21:40:00","inspection_id":"76727150","insp_unit_id":"191142981","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRANS","insp_unit_company":null,"insp_unit_license":"8694JK","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1TTE5130371083439","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:16.000000Z","updated_at":"2025-03-17T22:22:16.000000Z"}]},{"id":1357680,"change_date":"2022-09-27 21:40:00","inspection_id":"76693781","dot_number":"1079656","report_state":"TX","report_number":"6EHA0AFYF3","insp_date":"2022-09-19 00:00:00","insp_start_time":"1000","insp_end_time":"1055","registration_date":"2022-09-27 00:00:00","region":"CT","ci_status_code":"C","location":"5C001","location_desc":"IH 20 LORAINE","county_code_state":"TX","county_code":"335","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-23 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"148000","viol_total":"6","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8780523","transaction_code":"C","transaction_date":"2022-09-23 00:00:00","upload_date":"2022-09-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01079656","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-09-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-09-23 21:38:00","insp_carrier_name":"JOES HOTSHOT & TRUCKING LLC","insp_carrier_street":"4893 N ALFADALE ROAD","insp_carrier_city":"EL RENO","insp_carrier_state":"OK","insp_carrier_zip_code":"73036","insp_colonia":null,"docket_number":"503295","insp_interstate":"Y","insp_carrier_state_id":"0267005","created_at":"2025-03-17T18:51:40.000000Z","updated_at":"2025-03-17T18:51:40.000000Z","inspection_violations":[{"id":2149617,"change_date":"2022-09-27 21:40:00","inspection_id":"76693781","insp_violation_id":"248678009","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"191128704","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:49.000000Z","updated_at":"2025-03-17T21:16:49.000000Z","normalized_code":"39347E"},{"id":2149618,"change_date":"2022-09-27 21:40:00","inspection_id":"76693781","insp_violation_id":"248678010","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"191128704","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:49.000000Z","updated_at":"2025-03-17T21:16:49.000000Z","normalized_code":"39353B"},{"id":2149619,"change_date":"2022-09-27 21:40:00","inspection_id":"76693781","insp_violation_id":"248678011","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"191128704","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:49.000000Z","updated_at":"2025-03-17T21:16:49.000000Z","normalized_code":"39378"},{"id":2149620,"change_date":"2022-09-27 21:40:00","inspection_id":"76693781","insp_violation_id":"248678012","seq_no":"4","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"191128704","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:49.000000Z","updated_at":"2025-03-17T21:16:49.000000Z","normalized_code":"39311"},{"id":2149621,"change_date":"2022-09-27 21:40:00","inspection_id":"76693781","insp_violation_id":"248678013","seq_no":"5","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"191128704","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:49.000000Z","updated_at":"2025-03-17T21:16:49.000000Z","normalized_code":"3965B"},{"id":2149622,"change_date":"2022-09-27 21:40:00","inspection_id":"76693781","insp_violation_id":"248678014","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"191128705","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:49.000000Z","updated_at":"2025-03-17T21:16:49.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":2186257,"change_date":"2022-09-27 21:40:00","inspection_id":"76693781","insp_unit_id":"191128704","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"11","insp_unit_license":"2WB810","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XP5DB9X2XD480176","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:58.000000Z","updated_at":"2025-03-17T22:21:58.000000Z"},{"id":2186258,"change_date":"2022-09-27 21:40:00","inspection_id":"76693781","insp_unit_id":"191128705","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VIKI","insp_unit_company":"27","insp_unit_license":"5274KZ","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1V9DS5331FN062758","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:58.000000Z","updated_at":"2025-03-17T22:21:58.000000Z"}]},{"id":964146,"change_date":"2022-08-12 21:39:00","inspection_id":"76235793","dot_number":"1079656","report_state":"OK","report_number":"A910152627","insp_date":"2022-08-04 00:00:00","insp_start_time":"0955","insp_end_time":"1022","registration_date":"2022-08-11 00:00:00","region":"CT","ci_status_code":"C","location":"037081","location_desc":"EXXON AND US81","county_code_state":"OK","county_code":"073","insp_level_id":"2","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":"N","pen_cen_match":null,"final_status_date":"2022-08-04 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"179500","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":"679328","transaction_code":"C","transaction_date":"2022-08-04 00:00:00","upload_date":"2022-08-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01079656","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-08-04 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-08-04 21:42:00","insp_carrier_name":"JOES HOTSHOT & TRUCKING LLC","insp_carrier_street":"4893 N ALFADALE ROAD","insp_carrier_city":"EL RENO","insp_carrier_state":"OK","insp_carrier_zip_code":"73036","insp_colonia":null,"docket_number":"503295","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:44:44.000000Z","updated_at":"2025-03-17T18:44:44.000000Z","inspection_violations":[{"id":1519364,"change_date":"2022-08-12 21:39:00","inspection_id":"76235793","insp_violation_id":"247680386","seq_no":"1","part_no":"393","part_no_section":"203(c)","insp_viol_unit":"1","insp_unit_id":"190279931","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:09.000000Z","updated_at":"2025-03-17T21:14:09.000000Z","normalized_code":"393203C"},{"id":1519365,"change_date":"2022-08-12 21:39:00","inspection_id":"76235793","insp_violation_id":"247680387","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"190279932","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:09.000000Z","updated_at":"2025-03-17T21:14:09.000000Z","normalized_code":"3939A"},{"id":1519366,"change_date":"2022-08-12 21:39:00","inspection_id":"76235793","insp_violation_id":"247680388","seq_no":"3","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:09.000000Z","updated_at":"2025-03-17T21:14:09.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":1551229,"change_date":"2022-08-12 21:39:00","inspection_id":"76235793","insp_unit_id":"190279931","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"58","insp_unit_license":"3AD080","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XKWDB0X86J122104","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:46.000000Z","updated_at":"2025-03-17T22:17:46.000000Z"},{"id":1551230,"change_date":"2022-08-12 21:39:00","inspection_id":"76235793","insp_unit_id":"190279932","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONT","insp_unit_company":"5","insp_unit_license":"8722FI","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"13N24840411512115","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:46.000000Z","updated_at":"2025-03-17T22:17:46.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1079656\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1079656\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1079656\/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\/1079656\/inspections","per_page":100,"prev_page_url":null,"to":23,"total":23}