{"current_page":1,"data":[{"id":9123103,"change_date":"2025-07-24 21:41:00","inspection_id":"85188425","dot_number":"4046731","report_state":"OK","report_number":"J206155510","insp_date":"2025-07-09 00:00:00","insp_start_time":"0829","insp_end_time":"0909","registration_date":"2025-07-24 00:00:00","region":"CT","ci_status_code":"C","location":"49069","location_desc":"1 MILE SOUTH OF CHOUTEAU","county_code_state":"OK","county_code":"097","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"HOLLIDAY SAND","shipping_paper_number":"810068234","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"111007","viol_total":"7","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"790558","transaction_code":"C","transaction_date":"2025-07-09 00:00:00","upload_date":"2025-07-24 00:00:00","upload_first_byte":"0","upload_dot_number":"04046731","upload_search_indicator":null,"census_search_date":"2025-07-11 21:39:00","snet_input_date":"2025-07-09 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-07-11 21:39:00","insp_carrier_name":"JOHN CAMPBELL TRUCKING LLC","insp_carrier_street":"3000 SOUTH 74TH STREET WEST","insp_carrier_city":"MUSKOGEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74401","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-07-14T10:47:04.000000Z","updated_at":"2025-07-30T10:00:41.000000Z","inspection_violations":[{"id":14952206,"change_date":"2025-07-24 21:41:00","inspection_id":"85188425","insp_violation_id":"267626235","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"208057181","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-27T10:44:10.000000Z","updated_at":"2025-07-28T10:48:36.000000Z","normalized_code":"39617CPI"},{"id":14952207,"change_date":"2025-07-24 21:41:00","inspection_id":"85188425","insp_violation_id":"267626236","seq_no":"2","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"208057182","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-27T10:44:10.000000Z","updated_at":"2025-07-28T10:48:36.000000Z","normalized_code":"39617CPI"},{"id":14952208,"change_date":"2025-07-24 21:41:00","inspection_id":"85188425","insp_violation_id":"267626237","seq_no":"3","part_no":"393","part_no_section":"11B-CSSRR","insp_viol_unit":"2","insp_unit_id":"208057182","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-27T10:44:10.000000Z","updated_at":"2025-07-28T10:48:36.000000Z","normalized_code":"39311BCSSRR"},{"id":14952209,"change_date":"2025-07-24 21:41:00","inspection_id":"85188425","insp_violation_id":"267626238","seq_no":"4","part_no":"393","part_no_section":"11B-CSLRR","insp_viol_unit":"2","insp_unit_id":"208057182","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-27T10:44:10.000000Z","updated_at":"2025-07-28T10:48:36.000000Z","normalized_code":"39311BCSLRR"},{"id":14952210,"change_date":"2025-07-24 21:41:00","inspection_id":"85188425","insp_violation_id":"267626239","seq_no":"5","part_no":"396","part_no_section":"3A1-OAL","insp_viol_unit":"2","insp_unit_id":"208057182","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-27T10:44:10.000000Z","updated_at":"2025-07-28T10:48:36.000000Z","normalized_code":"3963A1OAL"},{"id":14952211,"change_date":"2025-07-24 21:41:00","inspection_id":"85188425","insp_violation_id":"267626240","seq_no":"6","part_no":"393","part_no_section":"48A-BMBCAD","insp_viol_unit":"2","insp_unit_id":"208057182","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-27T10:44:10.000000Z","updated_at":"2025-07-28T10:48:36.000000Z","normalized_code":"39348ABMBCAD"},{"id":14952212,"change_date":"2025-07-24 21:41:00","inspection_id":"85188425","insp_violation_id":"267626241","seq_no":"7","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"208057181","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-27T10:44:10.000000Z","updated_at":"2025-07-28T10:48:36.000000Z","normalized_code":"39378AWS"}],"inspection_per_units":[{"id":15197028,"change_date":"2025-07-24 21:41:00","inspection_id":"85188425","insp_unit_id":"208057181","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"169","insp_unit_license":"C3370","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XP5DB8X8VN429211","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-27T09:46:29.000000Z","updated_at":"2025-07-28T09:45:50.000000Z"},{"id":15197029,"change_date":"2025-07-24 21:41:00","inspection_id":"85188425","insp_unit_id":"208057182","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EADU","insp_unit_company":"TR4","insp_unit_license":"CT662","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1E1F9U2805RD36959","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-27T09:46:29.000000Z","updated_at":"2025-07-28T09:45:50.000000Z"}]},{"id":8630693,"change_date":"2025-05-28 21:43:00","inspection_id":"84667947","dot_number":"4046731","report_state":"OK","report_number":"P113155645","insp_date":"2025-05-14 00:00:00","insp_start_time":"1242","insp_end_time":"1334","registration_date":"2025-05-27 00:00:00","region":"CT","ci_status_code":"C","location":"73CRT","location_desc":"CREEK TP @ MM 29","county_code_state":"OK","county_code":"145","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"GREENHILL MATERIALS","shipping_paper_number":"640692","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-05-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"112007","viol_total":"7","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"784913","transaction_code":"C","transaction_date":"2025-05-14 00:00:00","upload_date":"2025-05-28 00:00:00","upload_first_byte":"0","upload_dot_number":"04046731","upload_search_indicator":"M","census_search_date":"2025-05-14 21:41:00","snet_input_date":"2025-05-14 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-05-14 21:41:00","insp_carrier_name":"JOHN CAMPBELL TRUCKING LLC","insp_carrier_street":"3000 SOUTH 74TH STREET WEST","insp_carrier_city":"MUSKOGEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74401","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-05-17T10:05:09.000000Z","updated_at":"2025-06-01T10:00:31.000000Z","inspection_violations":[{"id":13979406,"change_date":"2025-05-28 21:43:00","inspection_id":"84667947","insp_violation_id":"266519459","seq_no":"1","part_no":"393","part_no_section":"47B-BMBCBD","insp_viol_unit":"1","insp_unit_id":"207104555","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-31T10:17:05.000000Z","updated_at":"2025-06-01T10:17:41.000000Z","normalized_code":"39347BBMBCBD"},{"id":13979407,"change_date":"2025-05-28 21:43:00","inspection_id":"84667947","insp_violation_id":"266519460","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"207104556","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-31T10:17:05.000000Z","updated_at":"2025-06-01T10:17:41.000000Z","normalized_code":"39347E"},{"id":13979408,"change_date":"2025-05-28 21:43:00","inspection_id":"84667947","insp_violation_id":"266519461","seq_no":"3","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"2","insp_unit_id":"207104556","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-31T10:17:05.000000Z","updated_at":"2025-06-01T10:17:41.000000Z","normalized_code":"39353BB"},{"id":13979409,"change_date":"2025-05-28 21:43:00","inspection_id":"84667947","insp_violation_id":"266519462","seq_no":"4","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"207104556","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-31T10:17:05.000000Z","updated_at":"2025-06-01T10:17:41.000000Z","normalized_code":"39347E"},{"id":13979410,"change_date":"2025-05-28 21:43:00","inspection_id":"84667947","insp_violation_id":"266519463","seq_no":"5","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"2","insp_unit_id":"207104556","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-05-31T10:17:05.000000Z","updated_at":"2025-06-01T10:17:41.000000Z","normalized_code":"3963A1BOS"},{"id":13979411,"change_date":"2025-05-28 21:43:00","inspection_id":"84667947","insp_violation_id":"266519464","seq_no":"6","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"207104555","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-31T10:17:05.000000Z","updated_at":"2025-06-01T10:17:41.000000Z","normalized_code":"39617CPI"},{"id":13979412,"change_date":"2025-05-28 21:43:00","inspection_id":"84667947","insp_violation_id":"266519465","seq_no":"7","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"207104556","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-31T10:17:05.000000Z","updated_at":"2025-06-01T10:17:41.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":14317261,"change_date":"2025-05-28 21:43:00","inspection_id":"84667947","insp_unit_id":"207104555","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"169","insp_unit_license":"C3370","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XP5DB8X8VN429211","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-31T09:46:48.000000Z","updated_at":"2025-06-01T09:47:10.000000Z"},{"id":14317262,"change_date":"2025-05-28 21:43:00","inspection_id":"84667947","insp_unit_id":"207104556","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EADU","insp_unit_company":"TR4","insp_unit_license":"CT662","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1E1F9U2805RD36959","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-31T09:46:48.000000Z","updated_at":"2025-06-01T09:47:10.000000Z"}]},{"id":7219341,"change_date":"2024-12-02 21:39:00","inspection_id":"83183379","dot_number":"4046731","report_state":"OK","report_number":"J206155119","insp_date":"2024-11-15 00:00:00","insp_start_time":"0842","insp_end_time":"1045","registration_date":"2024-12-02 00:00:00","region":"CT","ci_status_code":"C","location":"73069","location_desc":"U.S. 69 AND BAKERS ROAD","county_code_state":"OK","county_code":"145","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MUSKOGEE SAND","shipping_paper_number":"32056","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":"2024-11-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"119500","viol_total":"11","oos_total":"4","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"767742","transaction_code":"C","transaction_date":"2024-11-18 00:00:00","upload_date":"2024-12-02 00:00:00","upload_first_byte":"0","upload_dot_number":"04046731","upload_search_indicator":"M","census_search_date":"2024-11-18 21:41:00","snet_input_date":"2024-11-15 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-11-18 21:41:00","insp_carrier_name":"JOHN CAMPBELL TRUCKING LLC","insp_carrier_street":"3000 S 74TH ST W","insp_carrier_city":"MUSKOGEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74401","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:46:30.000000Z","updated_at":"2025-03-17T20:46:30.000000Z","inspection_violations":[{"id":11282704,"change_date":"2024-12-02 21:39:00","inspection_id":"83183379","insp_violation_id":"263171957","seq_no":"3","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"204133496","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:49.000000Z","updated_at":"2025-03-17T22:00:49.000000Z","normalized_code":"39617CPI"},{"id":11282705,"change_date":"2024-12-02 21:39:00","inspection_id":"83183379","insp_violation_id":"263171958","seq_no":"4","part_no":"393","part_no_section":"209E-SPSLA","insp_viol_unit":"1","insp_unit_id":"204133496","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:49.000000Z","updated_at":"2025-03-17T22:00:49.000000Z","normalized_code":"393209ESPSLA"},{"id":11282706,"change_date":"2024-12-02 21:39:00","inspection_id":"83183379","insp_violation_id":"263171959","seq_no":"5","part_no":"393","part_no_section":"43A-TPV","insp_viol_unit":"1","insp_unit_id":"204133496","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:00:49.000000Z","updated_at":"2025-03-17T22:00:49.000000Z","normalized_code":"39343ATPV"},{"id":11282707,"change_date":"2024-12-02 21:39:00","inspection_id":"83183379","insp_violation_id":"263171960","seq_no":"6","part_no":"396","part_no_section":"3A1","insp_viol_unit":"1","insp_unit_id":"204133496","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:49.000000Z","updated_at":"2025-03-17T22:00:49.000000Z","normalized_code":"3963A1"},{"id":11282708,"change_date":"2024-12-02 21:39:00","inspection_id":"83183379","insp_violation_id":"263171961","seq_no":"7","part_no":"393","part_no_section":"100B-C","insp_viol_unit":"2","insp_unit_id":"204133495","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:00:49.000000Z","updated_at":"2025-03-17T22:00:49.000000Z","normalized_code":"393100BC"},{"id":11282709,"change_date":"2024-12-02 21:39:00","inspection_id":"83183379","insp_violation_id":"263171962","seq_no":"8","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"204133495","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:49.000000Z","updated_at":"2025-03-17T22:00:49.000000Z","normalized_code":"39617CPI"},{"id":11282710,"change_date":"2024-12-02 21:39:00","inspection_id":"83183379","insp_violation_id":"263171963","seq_no":"9","part_no":"393","part_no_section":"205A-WRBH","insp_viol_unit":"2","insp_unit_id":"204133495","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:00:49.000000Z","updated_at":"2025-03-17T22:00:49.000000Z","normalized_code":"393205AWRBH"},{"id":11282711,"change_date":"2024-12-02 21:39:00","inspection_id":"83183379","insp_violation_id":"263171964","seq_no":"10","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"204133495","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:00:49.000000Z","updated_at":"2025-03-17T22:00:49.000000Z","normalized_code":"39375A3TAOL"},{"id":11282712,"change_date":"2024-12-02 21:39:00","inspection_id":"83183379","insp_violation_id":"263171965","seq_no":"11","part_no":"393","part_no_section":"205C-WR","insp_viol_unit":"2","insp_unit_id":"204133495","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:49.000000Z","updated_at":"2025-03-17T22:00:49.000000Z","normalized_code":"393205CWR"},{"id":11282713,"change_date":"2024-12-02 21:39:00","inspection_id":"83183379","insp_violation_id":"263171966","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:49.000000Z","updated_at":"2025-03-17T22:00:49.000000Z","normalized_code":"3922SLLEWA1"},{"id":11282714,"change_date":"2024-12-02 21:39:00","inspection_id":"83183379","insp_violation_id":"263171967","seq_no":"2","part_no":"392","part_no_section":"2-SLLEWA3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:49.000000Z","updated_at":"2025-03-17T22:00:49.000000Z","normalized_code":"3922SLLEWA3"}],"inspection_per_units":[{"id":11644654,"change_date":"2024-12-02 21:39:00","inspection_id":"83183379","insp_unit_id":"204133495","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CMTR","insp_unit_company":"531","insp_unit_license":"CW8989","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1C918CW80LD386017","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:39.000000Z","updated_at":"2025-03-17T23:43:39.000000Z"},{"id":11644655,"change_date":"2024-12-02 21:39:00","inspection_id":"83183379","insp_unit_id":"204133496","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"165","insp_unit_license":"C3335","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FUY7XYBXMP386803","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:39.000000Z","updated_at":"2025-03-17T23:43:39.000000Z"}]},{"id":3982909,"change_date":"2023-09-15 21:40:00","inspection_id":"79673744","dot_number":"4046731","report_state":"OK","report_number":"J206154356","insp_date":"2023-09-14 00:00:00","insp_start_time":"0915","insp_end_time":"0927","registration_date":null,"region":"CT","ci_status_code":"C","location":"73051","location_desc":"S.H. 51 AND MUSKOGEE TP","county_code_state":"OK","county_code":"145","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"HOLLIDAY SAND","shipping_paper_number":"810039943","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-15 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":"722562","transaction_code":"A","transaction_date":"2023-09-15 00:00:00","upload_date":"2023-09-15 00:00:00","upload_first_byte":"0","upload_dot_number":"04046731","upload_search_indicator":"M","census_search_date":"2023-09-15 21:40:00","snet_input_date":"2023-09-14 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-09-15 21:40:00","insp_carrier_name":"JOHN CAMPBELL TRUCKING LLC","insp_carrier_street":"3000 S 74TH ST W","insp_carrier_city":"MUSKOGEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74401","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:41:35.000000Z","updated_at":"2025-03-17T19:41:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6404215,"change_date":"2023-09-15 21:40:00","inspection_id":"79673744","insp_unit_id":"197077480","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"164","insp_unit_license":"C2597","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XP5DB9X4WN454297","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:46.000000Z","updated_at":"2025-03-17T22:53:46.000000Z"},{"id":6404216,"change_date":"2023-09-15 21:40:00","inspection_id":"79673744","insp_unit_id":"197077481","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRVS","insp_unit_company":"TR3","insp_unit_license":"CT229","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1T91F3923X1247195","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:46.000000Z","updated_at":"2025-03-17T22:53:46.000000Z"}]},{"id":3374374,"change_date":"2023-06-27 21:40:00","inspection_id":"78992805","dot_number":"4046731","report_state":"OK","report_number":"Y600200954","insp_date":"2023-06-23 00:00:00","insp_start_time":"0938","insp_end_time":"1015","registration_date":null,"region":"CT","ci_status_code":"C","location":"73069","location_desc":"US69 \/ 60TH ST N","county_code_state":"OK","county_code":"145","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MUSKOGEE SAND","shipping_paper_number":"646627","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"4","oos_total":"0","driver_viol_total":"4","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"714482","transaction_code":"A","transaction_date":"2023-06-23 00:00:00","upload_date":"2023-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"04046731","upload_search_indicator":null,"census_search_date":"2023-06-27 21:40:00","snet_input_date":"2023-06-23 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-06-27 21:40:00","insp_carrier_name":"JOHN CAMPBELL TRUCKING LLC","insp_carrier_street":"3000 S 74TH ST W","insp_carrier_city":"MUSKOGEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74401","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:29:47.000000Z","updated_at":"2025-03-17T19:29:47.000000Z","inspection_violations":[{"id":5203343,"change_date":"2023-06-27 21:40:00","inspection_id":"78992805","insp_violation_id":"253722334","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:10.000000Z","updated_at":"2025-03-17T21:31:10.000000Z","normalized_code":"3922"},{"id":5203344,"change_date":"2023-06-27 21:40:00","inspection_id":"78992805","insp_violation_id":"253722335","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:10.000000Z","updated_at":"2025-03-17T21:31:10.000000Z","normalized_code":"3922"},{"id":5203345,"change_date":"2023-06-27 21:40:00","inspection_id":"78992805","insp_violation_id":"253722336","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:10.000000Z","updated_at":"2025-03-17T21:31:10.000000Z","normalized_code":"3922"},{"id":5203346,"change_date":"2023-06-27 21:40:00","inspection_id":"78992805","insp_violation_id":"253722337","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:10.000000Z","updated_at":"2025-03-17T21:31:10.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5424414,"change_date":"2023-06-27 21:40:00","inspection_id":"78992805","insp_unit_id":"195694623","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"C2597","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XP5DB9X4WN454297","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:47.000000Z","updated_at":"2025-03-17T22:45:47.000000Z"},{"id":5424415,"change_date":"2023-06-27 21:40:00","inspection_id":"78992805","insp_unit_id":"195694624","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRVS","insp_unit_company":null,"insp_unit_license":"CT229","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1T91F3923X1247195","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:47.000000Z","updated_at":"2025-03-17T22:45:47.000000Z"}]},{"id":3303525,"change_date":"2023-06-30 21:40:00","inspection_id":"78913399","dot_number":"4046731","report_state":"OK","report_number":"J206154209","insp_date":"2023-06-16 00:00:00","insp_start_time":"0648","insp_end_time":"0716","registration_date":"2023-06-30 00:00:00","region":"CT","ci_status_code":"C","location":"49069","location_desc":"1 MILE SOUTH OF CHOUTEAU","county_code_state":"OK","county_code":"097","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MUSKOGEE SAND","shipping_paper_number":"646029","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-06-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"713577","transaction_code":"C","transaction_date":"2023-06-16 00:00:00","upload_date":"2023-06-30 00:00:00","upload_first_byte":"0","upload_dot_number":"04046731","upload_search_indicator":"M","census_search_date":"2023-06-16 21:40:00","snet_input_date":"2023-06-16 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-06-16 21:40:00","insp_carrier_name":"JOHN CAMPBELL TRUCKING LLC","insp_carrier_street":"3000 S 74TH ST W","insp_carrier_city":"MUSKOGEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74401","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:28:30.000000Z","updated_at":"2025-03-17T19:28:30.000000Z","inspection_violations":[{"id":5094442,"change_date":"2023-06-30 21:40:00","inspection_id":"78913399","insp_violation_id":"253813857","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"195779356","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:39.000000Z","updated_at":"2025-03-17T21:30:39.000000Z","normalized_code":"39378"},{"id":5094443,"change_date":"2023-06-30 21:40:00","inspection_id":"78913399","insp_violation_id":"253813858","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195779356","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:39.000000Z","updated_at":"2025-03-17T21:30:39.000000Z","normalized_code":"3939A"},{"id":5094444,"change_date":"2023-06-30 21:40:00","inspection_id":"78913399","insp_violation_id":"253813859","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195779356","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:39.000000Z","updated_at":"2025-03-17T21:30:39.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":5310985,"change_date":"2023-06-30 21:40:00","inspection_id":"78913399","insp_unit_id":"195779356","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"C2597","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XP5DB9X4WN454297","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:54.000000Z","updated_at":"2025-03-17T22:44:54.000000Z"},{"id":5310986,"change_date":"2023-06-30 21:40:00","inspection_id":"78913399","insp_unit_id":"195779357","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRVS","insp_unit_company":null,"insp_unit_license":"CT229","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1T91F3923X1247195","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:54.000000Z","updated_at":"2025-03-17T22:44:54.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/4046731\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/4046731\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/4046731\/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\/4046731\/inspections","per_page":100,"prev_page_url":null,"to":6,"total":6}