{"current_page":1,"data":[{"id":12281348,"change_date":"2026-06-25 21:51:00","inspection_id":"88241155","dot_number":"498853","report_state":"OK","report_number":"R200162541","insp_date":"2026-06-25 00:00:00","insp_start_time":"1040","insp_end_time":"1110","registration_date":null,"region":"CD","ci_status_code":"C","location":"12271","location_desc":"OK","county_code_state":"OK","county_code":"023","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"SPECTRUM PAINT","shipping_paper_number":"205893","cargo_tank":"EXE","hazmat_placard_req":"Y","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-25 21:51:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3621669","transaction_code":"A","transaction_date":"2026-06-25 00:00:00","upload_date":"2026-06-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":null,"census_search_date":"2026-06-25 21:51:00","snet_input_date":"2026-06-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-25 21:51:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-28T09:39:50.000000Z","updated_at":"2026-07-06T09:32:38.000000Z","inspection_violations":[{"id":21565226,"change_date":null,"inspection_id":"88241155","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"106B-C","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-07-13T03:31:35.000000Z","updated_at":"2026-07-13T03:31:35.000000Z","normalized_code":"393106BC"}],"inspection_per_units":[{"id":21528495,"change_date":null,"inspection_id":"88241155","insp_unit_id":"sms-backfill-794170395-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENW","insp_unit_company":null,"insp_unit_license":"3NC123","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2NKHHJ7H0LM413250","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-07-13T03:28:54.000000Z","updated_at":"2026-07-13T03:28:54.000000Z"}]},{"id":12248997,"change_date":"2026-06-22 21:39:00","inspection_id":"88207345","dot_number":"498853","report_state":"SC","report_number":"0411000571","insp_date":"2026-06-22 00:00:00","insp_start_time":"1035","insp_end_time":"1130","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"SANTEE SC","county_code_state":"SC","county_code":"075","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SPECTRUM PAINT","shipping_paper_number":"205594","cargo_tank":null,"hazmat_placard_req":"Y","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-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"1","hazmat_oos_total":"0","snet_sequence_id":"3593815","transaction_code":"A","transaction_date":"2026-06-22 00:00:00","upload_date":"2026-06-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":null,"census_search_date":"2026-06-22 21:39:00","snet_input_date":"2026-06-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-22 21:39:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-25T09:38:51.000000Z","updated_at":"2026-07-03T09:30:49.000000Z","inspection_violations":[{"id":21565614,"change_date":null,"inspection_id":"88207345","insp_violation_id":null,"seq_no":null,"part_no":"172","part_no_section":"602B3-HMER","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-07-13T03:31:35.000000Z","updated_at":"2026-07-13T03:31:35.000000Z","normalized_code":"172602B3HMER"}],"inspection_per_units":[{"id":21524815,"change_date":null,"inspection_id":"88207345","insp_unit_id":"sms-backfill-793866105-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"240637","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1FDWF6DC5PDF07796","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-07-13T03:28:54.000000Z","updated_at":"2026-07-13T03:28:54.000000Z"}]},{"id":12163949,"change_date":"2026-06-11 21:42:00","inspection_id":"88113931","dot_number":"498853","report_state":"MO","report_number":"1410001119","insp_date":"2026-06-09 00:00:00","insp_start_time":"1045","insp_end_time":"1145","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"SPRINGFIELD MO","county_code_state":"MO","county_code":"077","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/A CARRIER","shipping_paper_number":"204514","cargo_tank":null,"hazmat_placard_req":"Y","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-11 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"4","oos_total":"2","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"3","hazmat_oos_total":"1","snet_sequence_id":"3521092","transaction_code":"A","transaction_date":"2026-06-11 00:00:00","upload_date":"2026-06-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":null,"census_search_date":"2026-06-11 21:42:00","snet_input_date":"2026-06-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-11 21:42:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"5727 S GARNETT ROAD","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74146","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-15T09:41:37.000000Z","updated_at":"2026-06-22T09:31:22.000000Z","inspection_violations":[{"id":21563291,"change_date":null,"inspection_id":"88113931","insp_violation_id":null,"seq_no":null,"part_no":"177","part_no_section":"817A-HMPSPMC","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-07-13T03:31:35.000000Z","updated_at":"2026-07-13T03:31:35.000000Z","normalized_code":"177817AHMPSPMC"},{"id":21563292,"change_date":null,"inspection_id":"88113931","insp_violation_id":null,"seq_no":null,"part_no":"177","part_no_section":"823A-HMPMCM","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-07-13T03:31:35.000000Z","updated_at":"2026-07-13T03:31:35.000000Z","normalized_code":"177823AHMPMCM"},{"id":21563293,"change_date":null,"inspection_id":"88113931","insp_violation_id":null,"seq_no":null,"part_no":"177","part_no_section":"834A-HMC","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"39","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-07-13T03:31:35.000000Z","updated_at":"2026-07-13T03:31:35.000000Z","normalized_code":"177834AHMC"},{"id":21563294,"change_date":null,"inspection_id":"88113931","insp_violation_id":null,"seq_no":null,"part_no":"391","part_no_section":"39111B4CLHA","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-07-13T03:31:35.000000Z","updated_at":"2026-07-13T03:31:35.000000Z","normalized_code":"39111B4CLHA"}],"inspection_per_units":[{"id":21523551,"change_date":null,"inspection_id":"88113931","insp_unit_id":"sms-backfill-793025379-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"3NC123","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2NKHHJ7H0LM413250","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-07-13T03:28:54.000000Z","updated_at":"2026-07-13T03:28:54.000000Z"}]},{"id":12084725,"change_date":"2026-06-04 21:46:00","inspection_id":"88027598","dot_number":"498853","report_state":"OK","report_number":"P113156207","insp_date":"2026-06-03 00:00:00","insp_start_time":"0619","insp_end_time":"0649","registration_date":null,"region":"CS","ci_status_code":"C","location":"19044","location_desc":"OK","county_code_state":"OK","county_code":"037","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"203898","cargo_tank":"OTH","hazmat_placard_req":"Y","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-03 21:36:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3457255","transaction_code":"C","transaction_date":"2026-06-04 00:00:00","upload_date":"2026-06-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":null,"census_search_date":"2026-06-03 21:36:00","snet_input_date":"2026-06-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-03 21:36:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-06T09:40:41.000000Z","updated_at":"2026-06-16T09:30:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21526716,"change_date":null,"inspection_id":"88027598","insp_unit_id":"sms-backfill-792248382-1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"3JA440","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XKYDP9X7RJ267146","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-07-13T03:28:54.000000Z","updated_at":"2026-07-13T03:28:54.000000Z"},{"id":21530323,"change_date":null,"inspection_id":"88027598","insp_unit_id":"sms-backfill-792248382-2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"4451LR","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1GRAA962XHB702234","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-07-13T03:28:54.000000Z","updated_at":"2026-07-13T03:28:54.000000Z"}]},{"id":12035647,"change_date":"2026-05-28 21:41:00","inspection_id":"87975962","dot_number":"498853","report_state":"OK","report_number":"N214153237","insp_date":"2026-05-28 00:00:00","insp_start_time":"0710","insp_end_time":"0739","registration_date":null,"region":"CS","ci_status_code":"C","location":"040","location_desc":"OK","county_code_state":"OK","county_code":"135","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SAME AS CARRIER","shipping_paper_number":"203442","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-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"3417320","transaction_code":"A","transaction_date":"2026-05-28 00:00:00","upload_date":"2026-05-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":null,"census_search_date":"2026-05-28 21:41:00","snet_input_date":"2026-05-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-28 21:41:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-01T09:39:50.000000Z","updated_at":"2026-06-08T09:30:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21526765,"change_date":null,"inspection_id":"87975962","insp_unit_id":"sms-backfill-791783658-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"3MM144","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2NK4HJ7X5TM218458","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-07-13T03:28:54.000000Z","updated_at":"2026-07-13T03:28:54.000000Z"}]},{"id":11985393,"change_date":"2026-05-22 08:07:00","inspection_id":"87922863","dot_number":"498853","report_state":"OK","report_number":"W500174623","insp_date":"2026-05-21 00:00:00","insp_start_time":"0750","insp_end_time":"0805","registration_date":null,"region":"CS","ci_status_code":"C","location":"06840","location_desc":"OK","county_code_state":"OK","county_code":"135","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"GEMINI","shipping_paper_number":"BL268448","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-22 08:07:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"3377662","transaction_code":"A","transaction_date":"2026-05-21 00:00:00","upload_date":"2026-05-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":null,"census_search_date":"2026-05-22 08:07:00","snet_input_date":"2026-05-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-22 08:07:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-25T09:41:01.000000Z","updated_at":"2026-06-02T09:31:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21528981,"change_date":null,"inspection_id":"87922863","insp_unit_id":"sms-backfill-791305767-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"3MM144","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2NK4HJ7X5TM218458","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-07-13T03:28:54.000000Z","updated_at":"2026-07-13T03:28:54.000000Z"}]},{"id":11789711,"change_date":"2026-06-29 21:42:00","inspection_id":"87721460","dot_number":"498853","report_state":"OK","report_number":"V700173551","insp_date":"2026-04-29 00:00:00","insp_start_time":"2300","insp_end_time":"2300","registration_date":null,"region":"CS","ci_status_code":"C","location":"12271","location_desc":"OK","county_code_state":"OK","county_code":"023","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"MC","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":"U","pen_cen_match":"I","final_status_date":"2026-04-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"3237206","transaction_code":"C","transaction_date":"2026-06-29 00:00:00","upload_date":"2026-06-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":null,"census_search_date":"2026-04-30 21:40:00","snet_input_date":"2026-04-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-30 21:40:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-03T09:40:50.000000Z","updated_at":"2026-07-10T09:30:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21337465,"change_date":null,"inspection_id":"87721460","insp_unit_id":"sms-backfill-789493140-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENW","insp_unit_company":null,"insp_unit_license":"3NC123","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2NKHHJ7H0LM413250","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-06-29T03:28:42.000000Z","updated_at":"2026-06-29T03:28:42.000000Z"}]},{"id":11802024,"change_date":"2026-05-01 21:40:00","inspection_id":"87735115","dot_number":"498853","report_state":"SC","report_number":"0408000761","insp_date":"2026-04-27 00:00:00","insp_start_time":"1221","insp_end_time":"1254","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"SUMMERVILLE SC","county_code_state":"SC","county_code":"015","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"NONE","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":"U","pen_cen_match":"I","final_status_date":"2026-05-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"6","oos_total":"0","driver_viol_total":"5","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3240435","transaction_code":"A","transaction_date":"2026-04-30 00:00:00","upload_date":"2026-05-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":null,"census_search_date":"2026-05-01 21:40:00","snet_input_date":"2026-04-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-01 21:40:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-04T09:41:18.000000Z","updated_at":"2026-05-12T09:30:43.000000Z","inspection_violations":[{"id":21386677,"change_date":null,"inspection_id":"87735115","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-06-29T03:31:08.000000Z","updated_at":"2026-06-29T03:31:08.000000Z","normalized_code":"3922SLLLR"},{"id":21386678,"change_date":null,"inspection_id":"87735115","insp_violation_id":null,"seq_no":null,"part_no":"395","part_no_section":"30B2-ELDDFC24","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-06-29T03:31:08.000000Z","updated_at":"2026-06-29T03:31:08.000000Z","normalized_code":"39530B2ELDDFC24"}],"inspection_per_units":[{"id":21337587,"change_date":null,"inspection_id":"87735115","insp_unit_id":"sms-backfill-789616035-1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"3GC220","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XKYDP9X4NJ144432","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-06-29T03:28:42.000000Z","updated_at":"2026-06-29T03:28:42.000000Z"},{"id":21341901,"change_date":null,"inspection_id":"87735115","insp_unit_id":"sms-backfill-789616035-2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"BX1141","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1GRAA96268D432293","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-06-29T03:28:42.000000Z","updated_at":"2026-06-29T03:28:42.000000Z"}]},{"id":11488711,"change_date":"2026-03-26 21:40:00","inspection_id":"87408282","dot_number":"498853","report_state":"OK","report_number":"W500174496","insp_date":"2026-03-26 00:00:00","insp_start_time":"0940","insp_end_time":"1005","registration_date":null,"region":"CT","ci_status_code":"C","location":"06840","location_desc":"INTERSTATE 40 2 W OF SALLISAW","county_code_state":"OK","county_code":"135","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SPECTUM PAINT","shipping_paper_number":"198093","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-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"816483","transaction_code":"A","transaction_date":"2026-03-26 00:00:00","upload_date":"2026-03-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":"M","census_search_date":"2026-03-26 21:40:00","snet_input_date":"2026-03-26 00:00:00","source_office":"2OKS001","mcmis_add_date":"2026-03-26 21:40:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-29T09:54:17.000000Z","updated_at":"2026-04-06T09:32:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20327834,"change_date":null,"inspection_id":"87408282","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENW","insp_unit_company":null,"insp_unit_license":"3NC123","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2NKHHJ7H0LM413250","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-04-20T03:15:53.000000Z","updated_at":"2026-04-20T03:15:53.000000Z"}]},{"id":11266232,"change_date":"2026-03-02 21:38:00","inspection_id":"87180294","dot_number":"498853","report_state":"OK","report_number":"K300182639","insp_date":"2026-03-02 00:00:00","insp_start_time":"0940","insp_end_time":"1013","registration_date":null,"region":"CT","ci_status_code":"C","location":"74075","location_desc":"US 75 \/ W 3900 RD","county_code_state":"OK","county_code":"147","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"195929","cargo_tank":null,"hazmat_placard_req":"Y","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-02 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"813633","transaction_code":"A","transaction_date":"2026-03-02 00:00:00","upload_date":"2026-03-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":null,"census_search_date":"2026-03-02 21:38:00","snet_input_date":"2026-03-02 00:00:00","source_office":"2OKS001","mcmis_add_date":"2026-03-02 21:38:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-05T10:39:01.000000Z","updated_at":"2026-03-13T09:31:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20331372,"change_date":null,"inspection_id":"87180294","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"3NC123","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2NKHHJ7H0LM413250","insp_unit_decal":null,"insp_unit_decal_number":"36078273","created_at":"2026-04-20T03:15:53.000000Z","updated_at":"2026-04-20T03:15:53.000000Z"}]},{"id":11083647,"change_date":"2026-02-09 21:38:00","inspection_id":"86994943","dot_number":"498853","report_state":"OK","report_number":"V700173392","insp_date":"2026-02-05 00:00:00","insp_start_time":"0930","insp_end_time":"1004","registration_date":null,"region":"CT","ci_status_code":"C","location":"61375","location_desc":"INTP - SH 375","county_code_state":"OK","county_code":"121","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"Y","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-02-09 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"811680","transaction_code":"A","transaction_date":"2026-02-05 00:00:00","upload_date":"2026-02-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":null,"census_search_date":"2026-02-09 21:38:00","snet_input_date":"2026-02-05 00:00:00","source_office":"2OKS001","mcmis_add_date":"2026-02-09 21:38:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-12T10:36:59.000000Z","updated_at":"2026-02-20T10:30:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19452034,"change_date":null,"inspection_id":"86994943","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENW","insp_unit_company":null,"insp_unit_license":"3NC123","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2NKHHJ7H0LM413250","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-03-16T03:15:23.000000Z","updated_at":"2026-03-16T03:15:23.000000Z"}]},{"id":10823706,"change_date":"2026-01-21 21:37:00","inspection_id":"86851384","dot_number":"498853","report_state":"MO","report_number":"W149007160","insp_date":"2026-01-19 00:00:00","insp_start_time":"0958","insp_end_time":"1025","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"JASPER MO","county_code_state":"MO","county_code":"097","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SPECTRUM PAINT","shipping_paper_number":"99424","cargo_tank":null,"hazmat_placard_req":"Y","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-01-21 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2795591","transaction_code":"A","transaction_date":"2026-01-21 00:00:00","upload_date":"2026-01-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":null,"census_search_date":"2026-01-21 21:37:00","snet_input_date":"2026-01-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-21 21:37:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-24T10:36:45.000000Z","updated_at":"2026-02-01T10:30:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19084791,"change_date":null,"inspection_id":"86851384","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"3JA440","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XKYDP9X7RJ267146","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-23T04:15:17.000000Z","updated_at":"2026-02-23T04:15:17.000000Z"},{"id":19091419,"change_date":null,"inspection_id":"86851384","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"4451LR","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1GRAA962XHB702234","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-23T04:15:17.000000Z","updated_at":"2026-02-23T04:15:17.000000Z"}]},{"id":10606713,"change_date":"2026-01-09 21:38:00","inspection_id":"86746353","dot_number":"498853","report_state":"VA","report_number":"6277005325","insp_date":"2026-01-07 00:00:00","insp_start_time":"1035","insp_end_time":"1100","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"DANVILLE VA","county_code_state":"VA","county_code":"143","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-01-09 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"2743007","transaction_code":"A","transaction_date":"2026-01-09 00:00:00","upload_date":"2026-01-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":null,"census_search_date":"2026-01-09 21:38:00","snet_input_date":"2026-01-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-09 21:38:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-12T10:34:40.000000Z","updated_at":"2026-01-20T10:30:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19086701,"change_date":null,"inspection_id":"86746353","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"3MA411","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2NK4HJ7X4TM213929","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-23T04:15:17.000000Z","updated_at":"2026-02-23T04:15:17.000000Z"}]},{"id":10618837,"change_date":"2026-01-11 21:33:00","inspection_id":"86759143","dot_number":"498853","report_state":"SC","report_number":"0316003067","insp_date":"2026-01-07 00:00:00","insp_start_time":"0914","insp_end_time":"0950","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MARION SC","county_code_state":"SC","county_code":"067","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"01072026","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-01-11 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"119000","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":"2749601","transaction_code":"A","transaction_date":"2026-01-10 00:00:00","upload_date":"2026-01-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":null,"census_search_date":"2026-01-11 21:33:00","snet_input_date":"2026-01-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-11 21:33:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-14T10:34:52.000000Z","updated_at":"2026-01-22T10:30:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19086292,"change_date":null,"inspection_id":"86759143","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"3GC220","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XKYDP9X4NJ144432","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-23T04:15:17.000000Z","updated_at":"2026-02-23T04:15:17.000000Z"},{"id":19093132,"change_date":null,"inspection_id":"86759143","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"CW1784","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1GR1A9628RT616755","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-23T04:15:17.000000Z","updated_at":"2026-02-23T04:15:17.000000Z"}]},{"id":10399074,"change_date":"2025-12-16 21:38:00","inspection_id":"86529240","dot_number":"498853","report_state":"IA","report_number":"000P13X68W","insp_date":"2025-12-09 00:00:00","insp_start_time":"1243","insp_end_time":"1310","registration_date":null,"region":"CT","ci_status_code":"C","location":"44","location_desc":"44 - JCT HWY 71\/20 EARLY","county_code_state":"IA","county_code":"161","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SPECTRUM PAINT COMPANY","shipping_paper_number":"190061","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-12-10 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1383981","transaction_code":"C","transaction_date":"2025-12-10 00:00:00","upload_date":"2025-12-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":"M","census_search_date":"2025-12-10 21:38:00","snet_input_date":"2025-12-09 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-12-10 21:38:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-13T10:31:38.000000Z","updated_at":"2025-12-27T10:30:35.000000Z","inspection_violations":[{"id":18489868,"change_date":null,"inspection_id":"86529240","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"48(a)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39348A"}],"inspection_per_units":[{"id":18751810,"change_date":null,"inspection_id":"86529240","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENW","insp_unit_company":null,"insp_unit_license":"3NC123","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2NKHHJ7H0LM413250","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":10363574,"change_date":"2025-12-05 21:43:00","inspection_id":"86492100","dot_number":"498853","report_state":"OK","report_number":"N214153131","insp_date":"2025-12-04 00:00:00","insp_start_time":"0720","insp_end_time":"0747","registration_date":null,"region":"CT","ci_status_code":"C","location":"040","location_desc":"I40 EB 307, 1 W SALLISAW","county_code_state":"OK","county_code":"135","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SAME AS CARRIER","shipping_paper_number":"189758","cargo_tank":null,"hazmat_placard_req":"Y","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-12-05 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"805609","transaction_code":"A","transaction_date":"2025-12-04 00:00:00","upload_date":"2025-12-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":"M","census_search_date":"2025-12-05 21:43:00","snet_input_date":"2025-12-04 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-12-05 21:43:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-08T10:32:04.000000Z","updated_at":"2025-12-09T10:31:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18673630,"change_date":null,"inspection_id":"86492100","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"3MM144","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2NK4HJ7X5TM218458","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":10316184,"change_date":"2025-12-01 21:39:00","inspection_id":"86442736","dot_number":"498853","report_state":"OK","report_number":"D900000676","insp_date":"2025-11-26 00:00:00","insp_start_time":"0927","insp_end_time":"0958","registration_date":null,"region":"CT","ci_status_code":"C","location":"05535","location_desc":"I-35 SB & BRITTON","county_code_state":"OK","county_code":"109","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"189296","cargo_tank":null,"hazmat_placard_req":"Y","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-12-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","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":"805121","transaction_code":"A","transaction_date":"2025-12-01 00:00:00","upload_date":"2025-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":"M","census_search_date":"2025-12-01 21:39:00","snet_input_date":"2025-11-26 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-12-01 21:39:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-04T10:30:34.000000Z","updated_at":"2025-12-05T10:30:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18750818,"change_date":null,"inspection_id":"86442736","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENW","insp_unit_company":null,"insp_unit_license":"3MM129","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XKYDP9X1KJ238117","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18835357,"change_date":null,"inspection_id":"86442736","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"BX1141","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1GRAA96268D432293","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":10155068,"change_date":"2025-11-08 21:33:00","inspection_id":"86273424","dot_number":"498853","report_state":"AR","report_number":"8220000418","insp_date":"2025-11-07 00:00:00","insp_start_time":"1110","insp_end_time":"1136","registration_date":null,"region":"CS","ci_status_code":"C","location":"302","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":"SPECTRUMPAINT","shipping_paper_number":"187920","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-11-08 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"2518302","transaction_code":"A","transaction_date":"2025-11-08 00:00:00","upload_date":"2025-11-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":null,"census_search_date":"2025-11-08 21:33:00","snet_input_date":"2025-11-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-08 21:33:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-11T10:31:49.000000Z","updated_at":"2025-11-12T10:30:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18670924,"change_date":null,"inspection_id":"86273424","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"3MM144","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2NK4HJ7X5TM218458","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":9863240,"change_date":"2025-10-06 21:40:00","inspection_id":"85965830","dot_number":"498853","report_state":"SC","report_number":"0313003742","insp_date":"2025-10-06 00:00:00","insp_start_time":"0840","insp_end_time":"0935","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"DUNCAN SC","county_code_state":"SC","county_code":"083","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SPECTRUM PAINT","shipping_paper_number":"185245","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-10-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2373033","transaction_code":"A","transaction_date":"2025-10-06 00:00:00","upload_date":"2025-10-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":null,"census_search_date":"2025-10-06 21:40:00","snet_input_date":"2025-10-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-06 21:40:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-09T10:00:46.000000Z","updated_at":"2025-10-10T10:00:51.000000Z","inspection_violations":[{"id":18481207,"change_date":null,"inspection_id":"85965830","insp_violation_id":null,"seq_no":null,"part_no":"177","part_no_section":"801-HMHCNP","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"177801HMHCNP"}],"inspection_per_units":[{"id":18745146,"change_date":null,"inspection_id":"85965830","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"3JA441","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2NK4HJ7X5RM266275","insp_unit_decal":null,"insp_unit_decal_number":"35828086","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":9837430,"change_date":"2025-10-02 21:42:00","inspection_id":"85938653","dot_number":"498853","report_state":"OK","report_number":"K200182724","insp_date":"2025-10-01 00:00:00","insp_start_time":"0948","insp_end_time":"1020","registration_date":null,"region":"CT","ci_status_code":"C","location":"019044","location_desc":"TURNER TURNPIKE WB MM 215","county_code_state":"OK","county_code":"037","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"184925","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-02 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1","hazmat_oos_total":"0","snet_sequence_id":"799466","transaction_code":"A","transaction_date":"2025-10-02 00:00:00","upload_date":"2025-10-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":"M","census_search_date":"2025-10-02 21:42:00","snet_input_date":"2025-10-01 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-10-02 21:42:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-05T10:01:54.000000Z","updated_at":"2025-10-05T10:01:54.000000Z","inspection_violations":[{"id":18480684,"change_date":null,"inspection_id":"85938653","insp_violation_id":null,"seq_no":null,"part_no":"172","part_no_section":"602A-HMER","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"172602AHMER"},{"id":18480685,"change_date":null,"inspection_id":"85938653","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39378AWS"},{"id":18480686,"change_date":null,"inspection_id":"85938653","insp_violation_id":null,"seq_no":null,"part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":18744820,"change_date":null,"inspection_id":"85938653","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"3MM144","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2NK4HJ7X5TM218458","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":9691174,"change_date":"2025-09-16 21:39:00","inspection_id":"85785403","dot_number":"498853","report_state":"AR","report_number":"3830000058","insp_date":"2025-09-11 00:00:00","insp_start_time":"0815","insp_end_time":"0855","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":"183479","shipping_paper_number":"SPECTRUM PAINT","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-09-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"2281080","transaction_code":"A","transaction_date":"2025-09-15 00:00:00","upload_date":"2025-09-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":null,"census_search_date":"2025-09-16 21:39:00","snet_input_date":"2025-09-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-16 21:39:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-18T10:00:57.000000Z","updated_at":"2025-09-23T10:00:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18665282,"change_date":null,"inspection_id":"85785403","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"3ER016","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2NKHHJ7H0LM413250","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":9214356,"change_date":"2025-07-22 21:42:00","inspection_id":"85284156","dot_number":"498853","report_state":"MO","report_number":"W217004485","insp_date":"2025-07-22 00:00:00","insp_start_time":"1030","insp_end_time":"1055","registration_date":null,"region":"CD","ci_status_code":"C","location":"D4E","location_desc":"JOPLIN MO","county_code_state":"MO","county_code":"145","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"179779","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-07-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"2026517","transaction_code":"A","transaction_date":"2025-07-22 00:00:00","upload_date":"2025-07-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":null,"census_search_date":"2025-07-22 21:42:00","snet_input_date":"2025-07-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-22 21:42:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-25T10:45:58.000000Z","updated_at":"2025-07-27T10:40:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18659526,"change_date":null,"inspection_id":"85284156","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"3ER016","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2NKHHJ7H0LM413250","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":9140944,"change_date":"2025-07-14 21:40:00","inspection_id":"85207279","dot_number":"498853","report_state":"OK","report_number":"P113155700","insp_date":"2025-07-14 00:00:00","insp_start_time":"0951","insp_end_time":"1013","registration_date":null,"region":"CT","ci_status_code":"C","location":"72044","location_desc":"I-44 @ YALE","county_code_state":"OK","county_code":"143","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"179145","cargo_tank":null,"hazmat_placard_req":"Y","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-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"791063","transaction_code":"A","transaction_date":"2025-07-14 00:00:00","upload_date":"2025-07-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":"M","census_search_date":"2025-07-14 21:40:00","snet_input_date":"2025-07-14 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-07-14 21:40:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-18T10:45:45.000000Z","updated_at":"2025-07-18T10:45:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18658648,"change_date":null,"inspection_id":"85207279","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"3ER016","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2NKHHJ7H0LM413250","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":9123183,"change_date":"2025-07-11 21:39:00","inspection_id":"85188510","dot_number":"498853","report_state":"OK","report_number":"P313152214","insp_date":"2025-07-10 00:00:00","insp_start_time":"0901","insp_end_time":"0925","registration_date":null,"region":"CT","ci_status_code":"C","location":"51MTP","location_desc":"MTP\/S GATE","county_code_state":"OK","county_code":"101","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"178945","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":"33000","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":"790622","transaction_code":"A","transaction_date":"2025-07-10 00:00:00","upload_date":"2025-07-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":null,"census_search_date":"2025-07-11 21:39:00","snet_input_date":"2025-07-10 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-07-11 21:39:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-14T10:47:04.000000Z","updated_at":"2025-07-16T10:44:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18736060,"change_date":null,"inspection_id":"85188510","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"3KP728","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2NKHHJ7X6JM181791","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8896534,"change_date":"2025-06-24 21:40:00","inspection_id":"84949091","dot_number":"498853","report_state":"KS","report_number":"HP93463728","insp_date":"2025-06-12 00:00:00","insp_start_time":"1030","insp_end_time":"1110","registration_date":"2025-06-24 00:00:00","region":"CT","ci_status_code":"C","location":"#26A","location_desc":"SOUTH HAVEN M.C.I.S. #26A","county_code_state":"KS","county_code":"191","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"M.C.","shipping_paper_number":"77173","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1364276","transaction_code":"C","transaction_date":"2025-06-24 00:00:00","upload_date":"2025-06-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":null,"census_search_date":"2025-06-13 21:40:00","snet_input_date":"2025-06-12 00:00:00","source_office":"3KSS001","mcmis_add_date":"2025-06-13 21:40:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-16T10:01:13.000000Z","updated_at":"2025-06-28T10:00:43.000000Z","inspection_violations":[{"id":18456050,"change_date":null,"inspection_id":"84949091","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39347E"},{"id":18456051,"change_date":null,"inspection_id":"84949091","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"53B-B","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39353BB"},{"id":18456052,"change_date":null,"inspection_id":"84949091","insp_violation_id":null,"seq_no":null,"part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3963A1BOS"}],"inspection_per_units":[{"id":18733236,"change_date":null,"inspection_id":"84949091","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"3JA440","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XKYDP9X7RJ267146","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18816625,"change_date":null,"inspection_id":"84949091","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"4451LR","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1GRAA962XHB702234","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8392789,"change_date":"2025-04-16 21:41:00","inspection_id":"84417253","dot_number":"498853","report_state":"NC","report_number":"0006749011","insp_date":"2025-04-16 00:00:00","insp_start_time":"0838","insp_end_time":"0900","registration_date":null,"region":"ET","ci_status_code":"C","location":"HALIFA","location_desc":"HALIFAX WEIGH STATION, I-95, N","county_code_state":"NC","county_code":"083","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"173350","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-04-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"2281144","transaction_code":"A","transaction_date":"2025-04-16 00:00:00","upload_date":"2025-04-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":null,"census_search_date":"2025-04-16 21:41:00","snet_input_date":"2025-04-16 00:00:00","source_office":"2NCS001","mcmis_add_date":"2025-04-16 21:41:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-19T10:19:24.000000Z","updated_at":"2025-04-20T10:25:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18726598,"change_date":null,"inspection_id":"84417253","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"3DY197","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2NKHHJ7XXLM377574","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8343025,"change_date":"2025-04-25 21:36:00","inspection_id":"84364757","dot_number":"498853","report_state":"OK","report_number":"PS01000110","insp_date":"2025-04-10 00:00:00","insp_start_time":"1015","insp_end_time":"1105","registration_date":"2025-04-23 00:00:00","region":"CT","ci_status_code":"C","location":"36035","location_desc":"I35 TONKAWA SCALES","county_code_state":"OK","county_code":"071","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SPECTRUM PAINT","shipping_paper_number":"172935","cargo_tank":null,"hazmat_placard_req":"Y","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-04-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"781366","transaction_code":"C","transaction_date":"2025-04-10 00:00:00","upload_date":"2025-04-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":"M","census_search_date":"2025-04-10 21:41:00","snet_input_date":"2025-04-10 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-04-10 21:41:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-14T10:28:21.000000Z","updated_at":"2025-04-29T10:02:08.000000Z","inspection_violations":[{"id":18446270,"change_date":null,"inspection_id":"84364757","insp_violation_id":null,"seq_no":null,"part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"38323A2LCDLN"}],"inspection_per_units":[{"id":18648209,"change_date":null,"inspection_id":"84364757","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"3JA440","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XKYDP9X7RJ267146","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18808585,"change_date":null,"inspection_id":"84364757","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"BX1141","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1GRAA96268D432293","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8142586,"change_date":"2025-03-18 21:39:00","inspection_id":"84153980","dot_number":"498853","report_state":"AR","report_number":"8060000529","insp_date":"2025-03-17 00:00:00","insp_start_time":"1220","insp_end_time":"1241","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"FAYETTEVILLE AR","county_code_state":"AR","county_code":"143","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SPECTRUM PAINT","shipping_paper_number":"171288","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-03-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"1484397","transaction_code":"A","transaction_date":"2025-03-18 00:00:00","upload_date":"2025-03-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":null,"census_search_date":"2025-03-18 21:39:00","snet_input_date":"2025-03-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-18 21:39:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-21T10:29:25.000000Z","updated_at":"2025-03-22T10:29:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18645510,"change_date":null,"inspection_id":"84153980","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"3KP728","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2NKHHJ7X6JM181791","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8055594,"change_date":"2025-03-07 21:39:00","inspection_id":"84062097","dot_number":"498853","report_state":"OK","report_number":"R200161837","insp_date":"2025-03-06 00:00:00","insp_start_time":"1055","insp_end_time":"1120","registration_date":null,"region":"CT","ci_status_code":"C","location":"12271","location_desc":"HUGO SCALES","county_code_state":"OK","county_code":"023","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"SPECTRUM PAINT","shipping_paper_number":"99624","cargo_tank":null,"hazmat_placard_req":"Y","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-03-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"777834","transaction_code":"A","transaction_date":"2025-03-06 00:00:00","upload_date":"2025-03-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":"M","census_search_date":"2025-03-07 21:39:00","snet_input_date":"2025-03-06 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-03-07 21:39:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:05:26.000000Z","updated_at":"2025-03-17T21:05:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18722158,"change_date":null,"inspection_id":"84062097","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"3ER016","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2NKHHJ7H0LM413250","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7986401,"change_date":"2025-02-28 21:40:00","inspection_id":"83989406","dot_number":"498853","report_state":"VA","report_number":"F114000209","insp_date":"2025-02-27 00:00:00","insp_start_time":"1342","insp_end_time":"1456","registration_date":null,"region":"ES","ci_status_code":"C","location":"CARSCS","location_desc":"PETERSBURG VA","county_code_state":"VA","county_code":"149","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SPECTRUM PAINTS","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-02-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"1409846","transaction_code":"A","transaction_date":"2025-02-28 00:00:00","upload_date":"2025-02-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":null,"census_search_date":"2025-02-28 21:40:00","snet_input_date":"2025-02-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-28 21:40:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:04:04.000000Z","updated_at":"2025-03-17T21:04:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18721219,"change_date":null,"inspection_id":"83989406","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH M","insp_unit_company":null,"insp_unit_license":"3JA442","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2NK4HJ7X9RM267137","insp_unit_decal":null,"insp_unit_decal_number":"35015038","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7727364,"change_date":"2025-01-28 21:39:00","inspection_id":"83717392","dot_number":"498853","report_state":"KS","report_number":"HP03204193","insp_date":"2025-01-27 00:00:00","insp_start_time":"0758","insp_end_time":"0830","registration_date":null,"region":"CT","ci_status_code":"C","location":"WB","location_desc":"WABAUNSEE COUNTY - 197","county_code_state":"KS","county_code":"197","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"168169","cargo_tank":null,"hazmat_placard_req":"Y","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-01-28 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1350892","transaction_code":"A","transaction_date":"2025-01-27 00:00:00","upload_date":"2025-01-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":null,"census_search_date":"2025-01-28 21:39:00","snet_input_date":"2025-01-27 00:00:00","source_office":"3KSS001","mcmis_add_date":"2025-01-28 21:39:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:58:41.000000Z","updated_at":"2025-03-17T20:58:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18717881,"change_date":null,"inspection_id":"83717392","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"3JD136","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2NK4HJ7X6RM336351","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7683763,"change_date":"2025-01-22 21:39:00","inspection_id":"83671723","dot_number":"498853","report_state":"NC","report_number":"0006702417","insp_date":"2025-01-21 00:00:00","insp_start_time":"0750","insp_end_time":"0813","registration_date":null,"region":"ET","ci_status_code":"C","location":"LUMBER","location_desc":"LUMBERTON WEIGH STATION, I-95,","county_code_state":"NC","county_code":"155","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"SPECTRUM PAINT","shipping_paper_number":"167865","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-01-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2253643","transaction_code":"A","transaction_date":"2025-01-22 00:00:00","upload_date":"2025-01-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":"M","census_search_date":"2025-01-22 21:39:00","snet_input_date":"2025-01-22 00:00:00","source_office":"2NCS001","mcmis_add_date":"2025-01-22 21:39:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:57:52.000000Z","updated_at":"2025-03-17T20:57:52.000000Z","inspection_violations":[{"id":18435589,"change_date":null,"inspection_id":"83671723","insp_violation_id":null,"seq_no":null,"part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":18639595,"change_date":null,"inspection_id":"83671723","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"3GC220","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XKYDP9X4NJ144432","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18799083,"change_date":null,"inspection_id":"83671723","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"CW1784","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1GR1A9628RT616755","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7681129,"change_date":"2025-01-22 21:39:00","inspection_id":"83668971","dot_number":"498853","report_state":"MO","report_number":"W132007534","insp_date":"2025-01-21 00:00:00","insp_start_time":"0945","insp_end_time":"1018","registration_date":null,"region":"CS","ci_status_code":"C","location":"D4E","location_desc":"JOPLIN MO","county_code_state":"MO","county_code":"145","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SPECTRUM PAINT #999","shipping_paper_number":"MULTIPLE","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-01-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1273657","transaction_code":"A","transaction_date":"2025-01-21 00:00:00","upload_date":"2025-01-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":null,"census_search_date":"2025-01-22 21:39:00","snet_input_date":"2025-01-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-22 21:39:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:57:51.000000Z","updated_at":"2025-03-17T20:57:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18717261,"change_date":null,"inspection_id":"83668971","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"3JA440","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XKYDP9X7RJ267146","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18799045,"change_date":null,"inspection_id":"83668971","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"4451LR","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1GRAA962XHB702234","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7651584,"change_date":"2025-01-17 21:40:00","inspection_id":"83637907","dot_number":"498853","report_state":"OK","report_number":"H900150811","insp_date":"2025-01-17 00:00:00","insp_start_time":"1316","insp_end_time":"1337","registration_date":null,"region":"CT","ci_status_code":"C","location":"49412","location_desc":"US 412 @ MM1","county_code_state":"OK","county_code":"097","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"S\/A CARRIER","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":"2025-01-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"773647","transaction_code":"A","transaction_date":"2025-01-17 00:00:00","upload_date":"2025-01-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":"M","census_search_date":"2025-01-17 21:40:00","snet_input_date":"2025-01-17 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-01-17 21:40:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:57:02.000000Z","updated_at":"2025-03-17T20:57:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18716847,"change_date":null,"inspection_id":"83637907","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"3BS002","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XKYDP9X1KJ238117","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18798581,"change_date":null,"inspection_id":"83637907","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"BX1141","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1GRAA96268D432293","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7573928,"change_date":"2025-01-08 21:39:00","inspection_id":"83556443","dot_number":"498853","report_state":"OK","report_number":"P113155494","insp_date":"2025-01-08 00:00:00","insp_start_time":"0820","insp_end_time":"0845","registration_date":null,"region":"CT","ci_status_code":"C","location":"72044","location_desc":"I-44 @ MEMORIAL","county_code_state":"OK","county_code":"143","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"167041","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-01-08 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"773023","transaction_code":"A","transaction_date":"2025-01-08 00:00:00","upload_date":"2025-01-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":"M","census_search_date":"2025-01-08 21:39:00","snet_input_date":"2025-01-08 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-01-08 21:39:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:55:18.000000Z","updated_at":"2025-03-17T20:55:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18715766,"change_date":null,"inspection_id":"83556443","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"3KP728","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2NKHHJ7X6JM181791","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7580074,"change_date":"2025-01-09 21:40:00","inspection_id":"83562848","dot_number":"498853","report_state":"SC","report_number":"0314004724","insp_date":"2025-01-06 00:00:00","insp_start_time":"0754","insp_end_time":"0759","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"GAFFNEY SC","county_code_state":"SC","county_code":"021","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SPECTRUM PAINT","shipping_paper_number":"166866","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-01-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1230074","transaction_code":"A","transaction_date":"2025-01-09 00:00:00","upload_date":"2025-01-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":null,"census_search_date":"2025-01-09 21:40:00","snet_input_date":"2025-01-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-09 21:40:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:55:38.000000Z","updated_at":"2025-03-17T20:55:38.000000Z","inspection_violations":[{"id":18434004,"change_date":null,"inspection_id":"83562848","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2-SLLSWZ","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3922SLLSWZ"}],"inspection_per_units":[{"id":18638133,"change_date":null,"inspection_id":"83562848","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH M","insp_unit_company":null,"insp_unit_license":"3JA442","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2NK4HJ7X9RM267137","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7472178,"change_date":"2024-12-20 21:40:00","inspection_id":"83449547","dot_number":"498853","report_state":"NC","report_number":"0006710535","insp_date":"2024-12-20 00:00:00","insp_start_time":"0805","insp_end_time":"0820","registration_date":null,"region":"ET","ci_status_code":"C","location":"HALIFA","location_desc":"HALIFAX WEIGH STATION, I-95, N","county_code_state":"NC","county_code":"083","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"2243062","transaction_code":"A","transaction_date":"2024-12-20 00:00:00","upload_date":"2024-12-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":"M","census_search_date":"2024-12-20 21:40:00","snet_input_date":"2024-12-20 00:00:00","source_office":"2NCS001","mcmis_add_date":"2024-12-20 21:40:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:51:57.000000Z","updated_at":"2025-03-17T20:51:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18714260,"change_date":null,"inspection_id":"83449547","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"3DY197","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2NKHHJ7XXLM377574","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7439487,"change_date":"2024-12-30 21:39:00","inspection_id":"83415210","dot_number":"498853","report_state":"KS","report_number":"HP02743199","insp_date":"2024-12-16 00:00:00","insp_start_time":"0816","insp_end_time":"0850","registration_date":null,"region":"CT","ci_status_code":"C","location":"WB","location_desc":"WABAUNSEE COUNTY - 197","county_code_state":"KS","county_code":"197","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SPECTRUM PAINT","shipping_paper_number":"165882","cargo_tank":null,"hazmat_placard_req":"Y","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-12-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1347643","transaction_code":"C","transaction_date":"2024-12-30 00:00:00","upload_date":"2024-12-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":"M","census_search_date":"2024-12-17 21:39:00","snet_input_date":"2024-12-16 00:00:00","source_office":"3KSS001","mcmis_add_date":"2024-12-17 21:39:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:51:12.000000Z","updated_at":"2025-03-17T20:51:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18636154,"change_date":null,"inspection_id":"83415210","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"3JD136","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2NK4HJ7X6RM336351","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7123212,"change_date":"2024-11-05 21:38:00","inspection_id":"83081492","dot_number":"498853","report_state":"SC","report_number":"0393000456","insp_date":"2024-11-05 00:00:00","insp_start_time":"1227","insp_end_time":"1248","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"SUMMERVILLE SC","county_code_state":"SC","county_code":"015","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SPECTRUM PAINT","shipping_paper_number":"163301","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-11-05 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1022310","transaction_code":"A","transaction_date":"2024-11-05 00:00:00","upload_date":"2024-11-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":null,"census_search_date":"2024-11-05 21:38:00","snet_input_date":"2024-11-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-05 21:38:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:44:38.000000Z","updated_at":"2025-03-17T20:44:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18709413,"change_date":null,"inspection_id":"83081492","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"3JA442","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2NK4HJ7X9RM267137","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6909919,"change_date":"2024-10-08 21:41:00","inspection_id":"82855023","dot_number":"498853","report_state":"SC","report_number":"0358000002","insp_date":"2024-10-08 00:00:00","insp_start_time":"0735","insp_end_time":"0825","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"HOLLY HILL SC","county_code_state":"SC","county_code":"075","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SPECTRUM PAINT","shipping_paper_number":"160718","cargo_tank":null,"hazmat_placard_req":"Y","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-10-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"3","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":"924389","transaction_code":"A","transaction_date":"2024-10-08 00:00:00","upload_date":"2024-10-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":null,"census_search_date":"2024-10-08 21:41:00","snet_input_date":"2024-10-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-08 21:41:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:40:14.000000Z","updated_at":"2025-03-17T20:40:14.000000Z","inspection_violations":[{"id":18422819,"change_date":null,"inspection_id":"82855023","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39360C"},{"id":18422820,"change_date":null,"inspection_id":"82855023","insp_violation_id":null,"seq_no":null,"part_no":"395","part_no_section":"3(a)(3)(ii)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3953A3II"}],"inspection_per_units":[{"id":18628814,"change_date":null,"inspection_id":"82855023","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"3JA441","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2NK4HJ7X5RM266275","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6916952,"change_date":"2024-10-09 21:40:00","inspection_id":"82862476","dot_number":"498853","report_state":"US","report_number":"1279000039","insp_date":"2024-10-02 00:00:00","insp_start_time":"1017","insp_end_time":"1051","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"DORCHESTER SC","county_code_state":"SC","county_code":"035","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SPECTRUM","shipping_paper_number":"03302059","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-10-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"926304","transaction_code":"A","transaction_date":"2024-10-09 00:00:00","upload_date":"2024-10-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":null,"census_search_date":"2024-10-09 21:40:00","snet_input_date":"2024-10-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-09 21:40:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:40:16.000000Z","updated_at":"2025-03-17T20:40:16.000000Z","inspection_violations":[{"id":18422942,"change_date":null,"inspection_id":"82862476","insp_violation_id":null,"seq_no":null,"part_no":"395","part_no_section":"24","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39524"},{"id":18422943,"change_date":null,"inspection_id":"82862476","insp_violation_id":null,"seq_no":null,"part_no":"395","part_no_section":"3(a)(3)(ii)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3953A3II"}],"inspection_per_units":[{"id":18706622,"change_date":null,"inspection_id":"82862476","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"3JA441","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2NK4HJ7X5RM266275","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6808534,"change_date":"2024-09-24 21:42:00","inspection_id":"82747407","dot_number":"498853","report_state":"KS","report_number":"HP02743157","insp_date":"2024-09-23 00:00:00","insp_start_time":"0816","insp_end_time":"0838","registration_date":null,"region":"CT","ci_status_code":"C","location":"WB","location_desc":"WABAUNSEE COUNTY - 197","county_code_state":"KS","county_code":"197","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SPECTRUM PAINT","shipping_paper_number":"159124","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1338776","transaction_code":"A","transaction_date":"2024-09-23 00:00:00","upload_date":"2024-09-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":null,"census_search_date":"2024-09-24 21:42:00","snet_input_date":"2024-09-23 00:00:00","source_office":"3KSS001","mcmis_add_date":"2024-09-24 21:42:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:38:12.000000Z","updated_at":"2025-03-17T20:38:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18705121,"change_date":null,"inspection_id":"82747407","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"3JD136","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2NK4HJ7X6RM336351","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6816867,"change_date":"2024-09-25 21:41:00","inspection_id":"82756300","dot_number":"498853","report_state":"NC","report_number":"0006686238","insp_date":"2024-09-17 00:00:00","insp_start_time":"1530","insp_end_time":"1550","registration_date":null,"region":"ET","ci_status_code":"C","location":"LUMBER","location_desc":"LUMBERTON WEIGH STATION I-95 N","county_code_state":"NC","county_code":"155","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"2220754","transaction_code":"A","transaction_date":"2024-09-25 00:00:00","upload_date":"2024-09-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":"M","census_search_date":"2024-09-25 21:41:00","snet_input_date":"2024-09-25 00:00:00","source_office":"2NCS001","mcmis_add_date":"2024-09-25 21:41:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:38:14.000000Z","updated_at":"2025-03-17T20:38:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18705254,"change_date":null,"inspection_id":"82756300","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"3DY197","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2NKHHJX8JM181792","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6495127,"change_date":"2024-08-17 21:32:00","inspection_id":"82413489","dot_number":"498853","report_state":"NC","report_number":"0006676632","insp_date":"2024-08-16 00:00:00","insp_start_time":"0908","insp_end_time":"0938","registration_date":null,"region":"ET","ci_status_code":"C","location":"HALIFA","location_desc":"HALIFAX WEIGH STATION, I-95, N","county_code_state":"NC","county_code":"083","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"155673","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-17 21:32:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"2209916","transaction_code":"A","transaction_date":"2024-08-16 00:00:00","upload_date":"2024-08-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":"M","census_search_date":"2024-08-17 21:32:00","snet_input_date":"2024-08-16 00:00:00","source_office":"2NCS001","mcmis_add_date":"2024-08-17 21:32:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:31:36.000000Z","updated_at":"2025-03-17T20:31:36.000000Z","inspection_violations":[{"id":18415170,"change_date":null,"inspection_id":"82413489","insp_violation_id":null,"seq_no":null,"part_no":"383","part_no_section":"71H","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"38371H"}],"inspection_per_units":[{"id":18623224,"change_date":null,"inspection_id":"82413489","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"3DY197","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2NKHHJ7XXLM377574","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6007349,"change_date":"2024-06-17 21:43:00","inspection_id":"81890447","dot_number":"498853","report_state":"OK","report_number":"K300181698","insp_date":"2024-06-17 00:00:00","insp_start_time":"1013","insp_end_time":"1048","registration_date":null,"region":"CT","ci_status_code":"C","location":"72020","location_desc":"SH 20 \/ US 75","county_code_state":"OK","county_code":"143","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"151489","cargo_tank":null,"hazmat_placard_req":"Y","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-17 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"751294","transaction_code":"A","transaction_date":"2024-06-17 00:00:00","upload_date":"2024-06-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":"M","census_search_date":"2024-06-17 21:43:00","snet_input_date":"2024-06-17 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-06-17 21:43:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:21:51.000000Z","updated_at":"2025-03-17T20:21:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18694282,"change_date":null,"inspection_id":"81890447","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"3ER016","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2NKHHJ7H0LM413250","insp_unit_decal":null,"insp_unit_decal_number":"33981047","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5390068,"change_date":"2024-03-28 21:41:00","inspection_id":"81218638","dot_number":"498853","report_state":"OK","report_number":"P313151389","insp_date":"2024-03-28 00:00:00","insp_start_time":"0835","insp_end_time":"0905","registration_date":null,"region":"CT","ci_status_code":"C","location":"51MTP","location_desc":"MTP\/ I40","county_code_state":"OK","county_code":"101","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"146361","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-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"742002","transaction_code":"A","transaction_date":"2024-03-28 00:00:00","upload_date":"2024-03-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":"M","census_search_date":"2024-03-28 21:41:00","snet_input_date":"2024-03-28 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-03-28 21:41:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:09:27.000000Z","updated_at":"2025-03-17T20:09:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18607688,"change_date":null,"inspection_id":"81218638","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"3KP728","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2NKHHJ7X6JM181791","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5381359,"change_date":"2024-03-27 21:42:00","inspection_id":"81209211","dot_number":"498853","report_state":"NE","report_number":"T557000750","insp_date":"2024-03-27 00:00:00","insp_start_time":"0730","insp_end_time":"0805","registration_date":null,"region":"CT","ci_status_code":"C","location":"11","location_desc":"WAVERLY EAST BOUND","county_code_state":"NE","county_code":"025","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SPECTRUM PAINT","shipping_paper_number":"146315","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-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"784693","transaction_code":"A","transaction_date":"2024-03-27 00:00:00","upload_date":"2024-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":"M","census_search_date":"2024-03-27 21:42:00","snet_input_date":"2024-03-27 00:00:00","source_office":"3NES001","mcmis_add_date":"2024-03-27 21:42:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:09:25.000000Z","updated_at":"2025-03-17T20:09:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18607567,"change_date":null,"inspection_id":"81209211","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"3JD136","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2NK4HJ7X6RM336351","insp_unit_decal":null,"insp_unit_decal_number":"33716139","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5390656,"change_date":"2024-03-28 21:41:00","inspection_id":"81219280","dot_number":"498853","report_state":"KS","report_number":"HP01160254","insp_date":"2024-03-25 00:00:00","insp_start_time":"0920","insp_end_time":"0940","registration_date":null,"region":"CT","ci_status_code":"C","location":"WB","location_desc":"WABAUNSEE COUNTY - 197","county_code_state":"KS","county_code":"197","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"146139","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-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1320314","transaction_code":"A","transaction_date":"2024-03-25 00:00:00","upload_date":"2024-03-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":null,"census_search_date":"2024-03-28 21:41:00","snet_input_date":"2024-03-25 00:00:00","source_office":"3KSS001","mcmis_add_date":"2024-03-28 21:41:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:09:28.000000Z","updated_at":"2025-03-17T20:09:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18607696,"change_date":null,"inspection_id":"81219280","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"3JD136","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2NK4HJ7X6RM336351","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":4697659,"change_date":"2023-12-23 21:32:00","inspection_id":"80462930","dot_number":"498853","report_state":"NC","report_number":"0006606300","insp_date":"2023-12-21 00:00:00","insp_start_time":"0746","insp_end_time":"0817","registration_date":null,"region":"ET","ci_status_code":"C","location":"HALIFA","location_desc":"HALIFAX WEIGH STATION, I-95, N","county_code_state":"NC","county_code":"083","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-12-23 21:32:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"2140420","transaction_code":"A","transaction_date":"2023-12-23 00:00:00","upload_date":"2023-12-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":"M","census_search_date":"2023-12-23 21:32:00","snet_input_date":"2023-12-23 00:00:00","source_office":"2NCS001","mcmis_add_date":"2023-12-23 21:32:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:55:49.000000Z","updated_at":"2025-03-17T19:55:49.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":4442061,"change_date":"2023-11-16 21:42:00","inspection_id":"80182191","dot_number":"498853","report_state":"OK","report_number":"W600170932","insp_date":"2023-11-16 00:00:00","insp_start_time":"0902","insp_end_time":"0933","registration_date":null,"region":"CT","ci_status_code":"C","location":"051060","location_desc":"SH 51\/ FAIRGROUNDS","county_code_state":"OK","county_code":"119","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"139618","cargo_tank":null,"hazmat_placard_req":"Y","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-11-16 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"728927","transaction_code":"A","transaction_date":"2023-11-16 00:00:00","upload_date":"2023-11-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":"M","census_search_date":"2023-11-16 21:42:00","snet_input_date":"2023-11-16 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-11-16 21:42:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:51:01.000000Z","updated_at":"2025-03-17T19:51:01.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":4441910,"change_date":"2023-11-27 21:41:00","inspection_id":"80182011","dot_number":"498853","report_state":"OK","report_number":"X900200311","insp_date":"2023-11-15 00:00:00","insp_start_time":"1205","insp_end_time":"1230","registration_date":"2023-11-27 00:00:00","region":"CT","ci_status_code":"C","location":"09040","location_desc":"I40 WB CZECH HALL ROAD","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":"139651","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-11-16 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"728753","transaction_code":"C","transaction_date":"2023-11-16 00:00:00","upload_date":"2023-11-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":"M","census_search_date":"2023-11-16 21:42:00","snet_input_date":"2023-11-15 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-11-16 21:42:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:51:01.000000Z","updated_at":"2025-03-17T19:51:01.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":4172388,"change_date":"2023-10-11 21:40:00","inspection_id":"79884114","dot_number":"498853","report_state":"NC","report_number":"0006583677","insp_date":"2023-10-11 00:00:00","insp_start_time":"1340","insp_end_time":"1410","registration_date":null,"region":"ET","ci_status_code":"C","location":"GASTON","location_desc":"GASTON COUNTY WEIGH STATION I-","county_code_state":"NC","county_code":"071","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"2116804","transaction_code":"A","transaction_date":"2023-10-11 00:00:00","upload_date":"2023-10-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":"M","census_search_date":"2023-10-11 21:40:00","snet_input_date":"2023-10-11 00:00:00","source_office":"2NCS001","mcmis_add_date":"2023-10-11 21:40:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:45:29.000000Z","updated_at":"2025-03-17T19:45:29.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":4130311,"change_date":"2023-10-05 21:39:00","inspection_id":"79837601","dot_number":"498853","report_state":"MO","report_number":"W172003506","insp_date":"2023-10-05 00:00:00","insp_start_time":"0730","insp_end_time":"0748","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"PLATTE CITY MO","county_code_state":"MO","county_code":"165","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"137017","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2023-10-05 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"63660","transaction_code":"A","transaction_date":"2023-10-05 00:00:00","upload_date":"2023-10-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":null,"census_search_date":"2023-10-05 21:39:00","snet_input_date":"2023-10-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-10-05 21:39:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:44:27.000000Z","updated_at":"2025-03-17T19:44:27.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":4059119,"change_date":"2023-09-26 21:42:00","inspection_id":"79758512","dot_number":"498853","report_state":"LA","report_number":"LAQC000052","insp_date":"2023-09-22 00:00:00","insp_start_time":"0921","insp_end_time":"0955","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"LA","county_code":"017","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-09-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1181730","transaction_code":"A","transaction_date":"2023-09-26 00:00:00","upload_date":"2023-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":"M","census_search_date":"2023-09-26 21:42:00","snet_input_date":"2023-09-26 00:00:00","source_office":"2LAS001","mcmis_add_date":"2023-09-26 21:42:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:42:51.000000Z","updated_at":"2025-03-17T19:42:51.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3555782,"change_date":"2023-07-20 21:41:00","inspection_id":"79196644","dot_number":"498853","report_state":"OK","report_number":"X900200110","insp_date":"2023-07-19 00:00:00","insp_start_time":"1325","insp_end_time":"1405","registration_date":null,"region":"CT","ci_status_code":"C","location":"JKT","location_desc":"JKT N\/B NW 39TH STREET","county_code_state":"OK","county_code":"017","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"M\/C","shipping_paper_number":"BL186491","cargo_tank":null,"hazmat_placard_req":"Y","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-07-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"716895","transaction_code":"A","transaction_date":"2023-07-20 00:00:00","upload_date":"2023-07-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":"M","census_search_date":"2023-07-20 21:41:00","snet_input_date":"2023-07-19 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-07-20 21:41:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:33:11.000000Z","updated_at":"2025-03-17T19:33:11.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3554916,"change_date":"2023-07-20 21:41:00","inspection_id":"79195667","dot_number":"498853","report_state":"NC","report_number":"0006558334","insp_date":"2023-07-19 00:00:00","insp_start_time":"1345","insp_end_time":"1415","registration_date":null,"region":"ET","ci_status_code":"C","location":"I-85 N","location_desc":"I-85 NORTHBOUND","county_code_state":"NC","county_code":"045","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-07-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"2091978","transaction_code":"A","transaction_date":"2023-07-20 00:00:00","upload_date":"2023-07-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":"M","census_search_date":"2023-07-20 21:41:00","snet_input_date":"2023-07-20 00:00:00","source_office":"2NCS001","mcmis_add_date":"2023-07-20 21:41:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:33:11.000000Z","updated_at":"2025-03-17T19:33:11.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3383215,"change_date":"2023-06-28 21:42:00","inspection_id":"79002830","dot_number":"498853","report_state":"VA","report_number":"6118001751","insp_date":"2023-06-28 00:00:00","insp_start_time":"1245","insp_end_time":"1315","registration_date":null,"region":"ET","ci_status_code":"C","location":"CARSCS","location_desc":"CARSON SCALES SOUTH","county_code_state":"VA","county_code":"149","insp_level_id":"1","service_center":"EA","census_source_id":"4","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":"I","final_status_date":"2023-06-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"868566","transaction_code":"A","transaction_date":"2023-06-28 00:00:00","upload_date":"2023-06-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":"M","census_search_date":"2023-06-28 21:42:00","snet_input_date":"2023-06-28 00:00:00","source_office":"1VAS001","mcmis_add_date":"2023-06-28 21:42:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:30:08.000000Z","updated_at":"2025-03-17T19:30:08.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3332398,"change_date":"2023-07-14 21:40:00","inspection_id":"78945777","dot_number":"498853","report_state":"SC","report_number":"H358000650","insp_date":"2023-06-20 00:00:00","insp_start_time":"0910","insp_end_time":"1006","registration_date":"2023-07-13 00:00:00","region":"ET","ci_status_code":"C","location":null,"location_desc":"I-95 SB ORANGEBURG COUNTY","county_code_state":"SC","county_code":"075","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SPECTRUM PAINT","shipping_paper_number":"130786","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1089547","transaction_code":"C","transaction_date":"2023-06-20 00:00:00","upload_date":"2023-07-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":null,"census_search_date":"2023-06-21 21:42:00","snet_input_date":"2023-06-20 00:00:00","source_office":"2SCS001","mcmis_add_date":"2023-06-21 21:42:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:28:56.000000Z","updated_at":"2025-03-17T19:28:56.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3332805,"change_date":"2023-06-21 21:42:00","inspection_id":"78946233","dot_number":"498853","report_state":"SC","report_number":"W194003788","insp_date":"2023-06-20 00:00:00","insp_start_time":"0650","insp_end_time":"0725","registration_date":null,"region":"ET","ci_status_code":"C","location":"110","location_desc":"I-95 SB ROADSIDE","county_code_state":"SC","county_code":"033","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SPECTRUM PAINT","shipping_paper_number":"130834","cargo_tank":null,"hazmat_placard_req":"Y","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-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1089304","transaction_code":"A","transaction_date":"2023-06-20 00:00:00","upload_date":"2023-06-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":null,"census_search_date":"2023-06-21 21:42:00","snet_input_date":"2023-06-20 00:00:00","source_office":"2SCS001","mcmis_add_date":"2023-06-21 21:42:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:28:56.000000Z","updated_at":"2025-03-17T19:28:56.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3282618,"change_date":"2023-06-14 21:41:00","inspection_id":"78889640","dot_number":"498853","report_state":"NC","report_number":"0006545586","insp_date":"2023-06-14 00:00:00","insp_start_time":"1140","insp_end_time":"1215","registration_date":null,"region":"ET","ci_status_code":"C","location":"GASTON","location_desc":"GASTON COUNTY WEIGH STATION I-","county_code_state":"NC","county_code":"071","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2078905","transaction_code":"A","transaction_date":"2023-06-14 00:00:00","upload_date":"2023-06-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":"M","census_search_date":"2023-06-14 21:41:00","snet_input_date":"2023-06-14 00:00:00","source_office":"2NCS001","mcmis_add_date":"2023-06-14 21:41:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:28:06.000000Z","updated_at":"2025-03-17T19:28:06.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3163321,"change_date":"2023-06-06 21:44:00","inspection_id":"78754745","dot_number":"498853","report_state":"OK","report_number":"P113154559","insp_date":"2023-05-22 00:00:00","insp_start_time":"0823","insp_end_time":"0848","registration_date":"2023-06-06 00:00:00","region":"CT","ci_status_code":"C","location":"72044","location_desc":"I-44 @ 193RD E AVE","county_code_state":"OK","county_code":"143","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"128999","cargo_tank":null,"hazmat_placard_req":"Y","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-05-30 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"710996","transaction_code":"C","transaction_date":"2023-05-22 00:00:00","upload_date":"2023-06-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":null,"census_search_date":"2023-05-30 21:42:00","snet_input_date":"2023-05-22 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-05-30 21:42:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:25:42.000000Z","updated_at":"2025-03-17T19:25:42.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2851070,"change_date":"2023-04-20 21:42:00","inspection_id":"78402004","dot_number":"498853","report_state":"NC","report_number":"0006526739","insp_date":"2023-04-20 00:00:00","insp_start_time":"0820","insp_end_time":"0830","registration_date":null,"region":"ET","ci_status_code":"C","location":"HALIFA","location_desc":"HALIFAX WEIGH STATION, I-95, N","county_code_state":"NC","county_code":"083","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"2060668","transaction_code":"A","transaction_date":"2023-04-20 00:00:00","upload_date":"2023-04-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":"M","census_search_date":"2023-04-20 21:42:00","snet_input_date":"2023-04-20 00:00:00","source_office":"2NCS001","mcmis_add_date":"2023-04-20 21:42:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:19:17.000000Z","updated_at":"2025-03-17T19:19:17.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2827197,"change_date":"2023-04-18 21:41:00","inspection_id":"78375084","dot_number":"498853","report_state":"US","report_number":"1489210099","insp_date":"2023-04-13 00:00:00","insp_start_time":"0852","insp_end_time":"0915","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"I 80 WAVERLY, NE SCALE HOUSE","county_code_state":"NE","county_code":"025","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"SPECTRUM PAINT","shipping_paper_number":"126488","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-04-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"16726","transaction_code":"A","transaction_date":"2023-04-13 00:00:00","upload_date":"2023-04-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":null,"census_search_date":"2023-04-18 21:41:00","snet_input_date":"2023-04-13 00:00:00","source_office":"3IAD001","mcmis_add_date":"2023-04-18 21:41:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:18:54.000000Z","updated_at":"2025-03-17T19:18:54.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2542664,"change_date":"2023-03-09 21:42:00","inspection_id":"78051182","dot_number":"498853","report_state":"OK","report_number":"P113154431","insp_date":"2023-03-06 00:00:00","insp_start_time":"0831","insp_end_time":"0855","registration_date":null,"region":"CT","ci_status_code":"C","location":"72044","location_desc":"I-44 @ MEMORIAL","county_code_state":"OK","county_code":"143","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"124103","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"701850","transaction_code":"A","transaction_date":"2023-03-06 00:00:00","upload_date":"2023-03-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":null,"census_search_date":"2023-03-09 21:42:00","snet_input_date":"2023-03-06 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-03-09 21:42:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:13:40.000000Z","updated_at":"2025-03-17T19:13:40.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2284908,"change_date":"2023-02-21 21:41:00","inspection_id":"77757661","dot_number":"498853","report_state":"OK","report_number":"W500171956","insp_date":"2023-02-02 00:00:00","insp_start_time":"0920","insp_end_time":"0945","registration_date":null,"region":"CT","ci_status_code":"C","location":"06840","location_desc":"2 MILES WEST OF SALLISAW","county_code_state":"OK","county_code":"135","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SPECTUM PAINTS","shipping_paper_number":"122024","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-02 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"698298","transaction_code":"C","transaction_date":"2023-02-15 00:00:00","upload_date":"2023-02-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":"M","census_search_date":"2023-02-02 21:42:00","snet_input_date":"2023-02-02 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-02-02 21:42:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:51.000000Z","updated_at":"2025-03-17T19:08:51.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2264208,"change_date":"2023-01-31 21:43:00","inspection_id":"77734174","dot_number":"498853","report_state":"NC","report_number":"0006499492","insp_date":"2023-01-30 00:00:00","insp_start_time":"1120","insp_end_time":"1145","registration_date":null,"region":"ET","ci_status_code":"C","location":"US 17","location_desc":"US 17 SB NEAR SR 1184","county_code_state":"NC","county_code":"019","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SPECTRUM PAINT-KNIGHTDALE","shipping_paper_number":"121828","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-01-31 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"2033220","transaction_code":"A","transaction_date":"2023-01-30 00:00:00","upload_date":"2023-01-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":"M","census_search_date":"2023-01-31 21:43:00","snet_input_date":"2023-01-30 00:00:00","source_office":"2NCS001","mcmis_add_date":"2023-01-31 21:43:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:28.000000Z","updated_at":"2025-03-17T19:08:28.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2182289,"change_date":"2023-01-19 21:44:00","inspection_id":"77640808","dot_number":"498853","report_state":"MO","report_number":"DT02006346","insp_date":"2023-01-17 00:00:00","insp_start_time":"1005","insp_end_time":"1025","registration_date":null,"region":"CT","ci_status_code":"C","location":"D44","location_desc":"I-44 AND SAFARI","county_code_state":"MO","county_code":"109","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"011723","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-01-19 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"2054306","transaction_code":"A","transaction_date":"2023-01-17 00:00:00","upload_date":"2023-01-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":null,"census_search_date":"2023-01-19 21:44:00","snet_input_date":"2023-01-19 00:00:00","source_office":"3MOS001","mcmis_add_date":"2023-01-19 21:44:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:06:55.000000Z","updated_at":"2025-03-17T19:06:55.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2140247,"change_date":"2023-01-13 21:40:00","inspection_id":"77592372","dot_number":"498853","report_state":"OK","report_number":"N214152499","insp_date":"2023-01-13 00:00:00","insp_start_time":"1020","insp_end_time":"1042","registration_date":null,"region":"CT","ci_status_code":"C","location":"040","location_desc":"I40 EB 307, 1 W SALLISAW","county_code_state":"OK","county_code":"135","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SPECTRUM PAINT","shipping_paper_number":"120873","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"696564","transaction_code":"A","transaction_date":"2023-01-13 00:00:00","upload_date":"2023-01-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":"M","census_search_date":"2023-01-13 21:40:00","snet_input_date":"2023-01-13 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-01-13 21:40:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:06:12.000000Z","updated_at":"2025-03-17T19:06:12.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2129489,"change_date":"2023-01-12 21:42:00","inspection_id":"77580147","dot_number":"498853","report_state":"NC","report_number":"0006493983","insp_date":"2023-01-12 00:00:00","insp_start_time":"0700","insp_end_time":"0709","registration_date":null,"region":"ET","ci_status_code":"C","location":"LUMBER","location_desc":"LUMBERTON WEIGH STATION I-95 S","county_code_state":"NC","county_code":"155","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"2028024","transaction_code":"A","transaction_date":"2023-01-12 00:00:00","upload_date":"2023-01-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":"M","census_search_date":"2023-01-12 21:42:00","snet_input_date":"2023-01-12 00:00:00","source_office":"2NCS001","mcmis_add_date":"2023-01-12 21:42:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:05:53.000000Z","updated_at":"2025-03-17T19:05:53.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2044519,"change_date":"2022-12-30 21:37:00","inspection_id":"77482695","dot_number":"498853","report_state":"OK","report_number":"C606150369","insp_date":"2022-12-30 00:00:00","insp_start_time":"1113","insp_end_time":"1216","registration_date":null,"region":"CT","ci_status_code":"C","location":"64375","location_desc":"5 MI N OF ANTLERS","county_code_state":"OK","county_code":"127","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"119827","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-30 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"695204","transaction_code":"A","transaction_date":"2022-12-30 00:00:00","upload_date":"2022-12-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":"M","census_search_date":"2022-12-30 21:37:00","snet_input_date":"2022-12-30 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-12-30 21:37:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:04:21.000000Z","updated_at":"2025-03-17T19:04:21.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":1761513,"change_date":"2022-11-17 21:40:00","inspection_id":"77158917","dot_number":"498853","report_state":"AR","report_number":"B740000815","insp_date":"2022-11-17 00:00:00","insp_start_time":"1200","insp_end_time":"1230","registration_date":null,"region":"CT","ci_status_code":"C","location":"23","location_desc":"FAULKNER COUNTY","county_code_state":"AR","county_code":"045","insp_level_id":"3","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"SPECTRUM PAINT","shipping_paper_number":"117124","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-11-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"1430574","transaction_code":"A","transaction_date":"2022-11-17 00:00:00","upload_date":"2022-11-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":"M","census_search_date":"2022-11-17 21:40:00","snet_input_date":"2022-11-17 00:00:00","source_office":"2ARS001","mcmis_add_date":"2022-11-17 21:40:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:59:15.000000Z","updated_at":"2025-03-17T18:59:15.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":1705978,"change_date":"2022-11-09 21:40:00","inspection_id":"77095351","dot_number":"498853","report_state":"NC","report_number":"0006473094","insp_date":"2022-11-09 00:00:00","insp_start_time":"0645","insp_end_time":"0720","registration_date":null,"region":"ET","ci_status_code":"C","location":"HILLSB","location_desc":"HILLSBOROUGH WEIGH STATION I-4","county_code_state":"NC","county_code":"135","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"SPECTRUM PAINT - KNIGHTDA","shipping_paper_number":"116657","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"2007133","transaction_code":"A","transaction_date":"2022-11-09 00:00:00","upload_date":"2022-11-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":"M","census_search_date":"2022-11-09 21:40:00","snet_input_date":"2022-11-09 00:00:00","source_office":"2NCS001","mcmis_add_date":"2022-11-09 21:40:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:11.000000Z","updated_at":"2025-03-17T18:58:11.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":1377414,"change_date":"2022-09-27 21:40:00","inspection_id":"76716393","dot_number":"498853","report_state":"KS","report_number":"HP01160174","insp_date":"2022-09-26 00:00:00","insp_start_time":"0940","insp_end_time":"1000","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"EB SCALES","county_code_state":"KS","county_code":"197","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","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":"2022-09-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"1264916","transaction_code":"A","transaction_date":"2022-09-26 00:00:00","upload_date":"2022-09-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":null,"census_search_date":"2022-09-27 21:40:00","snet_input_date":"2022-09-26 00:00:00","source_office":"3KSS001","mcmis_add_date":"2022-09-27 21:40:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:52:01.000000Z","updated_at":"2025-03-17T18:52:01.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":728473,"change_date":"2022-06-30 21:41:00","inspection_id":"75960092","dot_number":"498853","report_state":"OK","report_number":"P113154061","insp_date":"2022-06-30 00:00:00","insp_start_time":"0859","insp_end_time":"0929","registration_date":null,"region":"CT","ci_status_code":"C","location":"49069","location_desc":"US 69 @ US 412","county_code_state":"OK","county_code":"097","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"108990","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","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":"675464","transaction_code":"A","transaction_date":"2022-06-30 00:00:00","upload_date":"2022-06-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":"M","census_search_date":"2022-06-30 21:41:00","snet_input_date":"2022-06-30 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-06-30 21:41:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:40:31.000000Z","updated_at":"2025-03-17T18:40:31.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":658394,"change_date":"2022-06-21 21:42:00","inspection_id":"75877584","dot_number":"498853","report_state":"SC","report_number":"W188005809","insp_date":"2022-06-21 00:00:00","insp_start_time":"0857","insp_end_time":"0910","registration_date":null,"region":"ET","ci_status_code":"C","location":"110","location_desc":"I-95 SB ROADSIDE","county_code_state":"SC","county_code":"075","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1037373","transaction_code":"A","transaction_date":"2022-06-21 00:00:00","upload_date":"2022-06-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":null,"census_search_date":"2022-06-21 21:42:00","snet_input_date":"2022-06-21 00:00:00","source_office":"2SCS001","mcmis_add_date":"2022-06-21 21:42:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:39:13.000000Z","updated_at":"2025-03-17T18:39:13.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":459086,"change_date":"2022-05-23 21:42:00","inspection_id":"75640458","dot_number":"498853","report_state":"OK","report_number":"P113153998","insp_date":"2022-05-23 00:00:00","insp_start_time":"1230","insp_end_time":"1256","registration_date":null,"region":"CT","ci_status_code":"C","location":"66066","location_desc":"SH 66 @ EW 520","county_code_state":"OK","county_code":"131","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"106566","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"671661","transaction_code":"A","transaction_date":"2022-05-23 00:00:00","upload_date":"2022-05-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":"M","census_search_date":"2022-05-23 21:42:00","snet_input_date":"2022-05-23 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-05-23 21:42:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:35:41.000000Z","updated_at":"2025-03-17T18:35:41.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":405418,"change_date":"2022-05-17 21:42:00","inspection_id":"75576604","dot_number":"498853","report_state":"NC","report_number":"0006419268","insp_date":"2022-05-17 00:00:00","insp_start_time":"0700","insp_end_time":"0730","registration_date":null,"region":"ET","ci_status_code":"C","location":"LUMBER","location_desc":"LUMBERTON WEIGH STATION I-95 S","county_code_state":"NC","county_code":"155","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"SPECTRUM PAINT-KNIGHTDALE","shipping_paper_number":"106292","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1952975","transaction_code":"A","transaction_date":"2022-05-17 00:00:00","upload_date":"2022-05-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":"M","census_search_date":"2022-05-17 21:42:00","snet_input_date":"2022-05-17 00:00:00","source_office":"2NCS001","mcmis_add_date":"2022-05-17 21:42:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:34:46.000000Z","updated_at":"2025-03-17T18:34:46.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":471107,"change_date":"2022-05-24 21:43:00","inspection_id":"75654810","dot_number":"498853","report_state":"US","report_number":"1552000345","insp_date":"2022-03-28 00:00:00","insp_start_time":"1217","insp_end_time":"1249","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-95 N SCALE","county_code_state":"SC","county_code":"035","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-05-24 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"964","transaction_code":"C","transaction_date":"2022-03-28 00:00:00","upload_date":"2022-05-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00498853","upload_search_indicator":null,"census_search_date":"2022-05-24 21:43:00","snet_input_date":"2022-03-30 00:00:00","source_office":"2SCD001","mcmis_add_date":"2022-05-24 21:43:00","insp_carrier_name":"SPECTRUM PAINT COMPANY","insp_carrier_street":"15247 E SKELLY DR","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:35:58.000000Z","updated_at":"2025-03-17T18:35:58.000000Z","inspection_violations":[],"inspection_per_units":[]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/498853\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/498853\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/498853\/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\/498853\/inspections","per_page":100,"prev_page_url":null,"to":78,"total":78}