{"current_page":1,"data":[{"id":11696637,"change_date":"2026-04-20 21:38:00","inspection_id":"87622972","dot_number":"3543395","report_state":"OK","report_number":"A300151972","insp_date":"2026-04-20 00:00:00","insp_start_time":"0930","insp_end_time":"1000","registration_date":null,"region":"CT","ci_status_code":"C","location":"34081","location_desc":"US 81\/ADDINGTON","county_code_state":"OK","county_code":"067","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-20 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"212500","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":"818323","transaction_code":"A","transaction_date":"2026-04-20 00:00:00","upload_date":"2026-04-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03543395","upload_search_indicator":null,"census_search_date":"2026-04-20 21:38:00","snet_input_date":"2026-04-20 00:00:00","source_office":"2OKS001","mcmis_add_date":"2026-04-20 21:38:00","insp_carrier_name":"S&P CLEARING AND ENERGY SERVICES LLC","insp_carrier_street":"442 E LANKFORD AVE","insp_carrier_city":"BENNINGTON","insp_carrier_state":"OK","insp_carrier_zip_code":"74723","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:35:57.000000Z","updated_at":"2026-05-01T09:30:58.000000Z","inspection_violations":[{"id":20323538,"change_date":"2026-04-20 21:38:00","inspection_id":"87622972","insp_violation_id":"273718759","seq_no":"1","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:51:46.000000Z","updated_at":"2026-05-01T09:42:18.000000Z","normalized_code":"3922SLL"}],"inspection_per_units":[{"id":20355867,"change_date":"2026-04-20 21:38:00","inspection_id":"87622972","insp_unit_id":"213113146","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETE","insp_unit_company":null,"insp_unit_license":"3LX381","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XPEP4EXXTD785850","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:11:17.000000Z","updated_at":"2026-05-01T09:03:51.000000Z"},{"id":20355868,"change_date":"2026-04-20 21:38:00","inspection_id":"87622972","insp_unit_id":"213113147","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PITTS","insp_unit_company":null,"insp_unit_license":"BV9417","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5JYLB5537NPP21813","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:11:17.000000Z","updated_at":"2026-05-01T09:03:51.000000Z"}]},{"id":11543163,"change_date":"2026-04-01 21:40:00","inspection_id":"87465653","dot_number":"3543395","report_state":"OK","report_number":"C813153814","insp_date":"2026-03-31 00:00:00","insp_start_time":"1230","insp_end_time":"1340","registration_date":null,"region":"CT","ci_status_code":"C","location":"25076","location_desc":"SH 76 \/ LINDSAY","county_code_state":"OK","county_code":"049","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"38000","viol_total":"7","oos_total":"2","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"816988","transaction_code":"A","transaction_date":"2026-03-31 00:00:00","upload_date":"2026-04-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03543395","upload_search_indicator":null,"census_search_date":"2026-04-01 21:40:00","snet_input_date":"2026-03-31 00:00:00","source_office":"2OKS001","mcmis_add_date":"2026-04-01 21:40:00","insp_carrier_name":"S&P CLEARING AND ENERGY SERVICES LLC","insp_carrier_street":"442 E LANKFORD AVE","insp_carrier_city":"BENNINGTON","insp_carrier_state":"OK","insp_carrier_zip_code":"74723","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-04T09:43:31.000000Z","updated_at":"2026-04-12T09:32:29.000000Z","inspection_violations":[{"id":19500777,"change_date":"2026-04-01 21:40:00","inspection_id":"87465653","insp_violation_id":"272794464","seq_no":"1","part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-03T10:13:20.000000Z","updated_at":"2026-04-11T09:48:12.000000Z","normalized_code":"38323A2LCDLN"},{"id":19500778,"change_date":"2026-04-01 21:40:00","inspection_id":"87465653","insp_violation_id":"272794465","seq_no":"2","part_no":"391","part_no_section":"41A-MCPC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-03T10:13:20.000000Z","updated_at":"2026-04-11T09:48:12.000000Z","normalized_code":"39141AMCPC"},{"id":19500779,"change_date":"2026-04-01 21:40:00","inspection_id":"87465653","insp_violation_id":"272794466","seq_no":"3","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"212479296","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-03T10:13:20.000000Z","updated_at":"2026-04-11T09:48:12.000000Z","normalized_code":"39021TB1MC"},{"id":19500780,"change_date":"2026-04-01 21:40:00","inspection_id":"87465653","insp_violation_id":"272794467","seq_no":"4","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"212479296","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-03T10:13:20.000000Z","updated_at":"2026-04-11T09:48:12.000000Z","normalized_code":"39021TB2DOT"},{"id":19500781,"change_date":"2026-04-01 21:40:00","inspection_id":"87465653","insp_violation_id":"272794468","seq_no":"5","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"212479296","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-03T10:13:20.000000Z","updated_at":"2026-04-11T09:48:12.000000Z","normalized_code":"39617CPI"},{"id":19500782,"change_date":"2026-04-01 21:40:00","inspection_id":"87465653","insp_violation_id":"272794469","seq_no":"6","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"212479296","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-03T10:13:20.000000Z","updated_at":"2026-04-11T09:48:12.000000Z","normalized_code":"39395A1"},{"id":19500783,"change_date":"2026-04-01 21:40:00","inspection_id":"87465653","insp_violation_id":"272794470","seq_no":"7","part_no":"393","part_no_section":"205C-WR","insp_viol_unit":"2","insp_unit_id":"212479297","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-04-03T10:13:20.000000Z","updated_at":"2026-04-11T09:48:12.000000Z","normalized_code":"393205CWR"}],"inspection_per_units":[{"id":19779477,"change_date":"2026-04-01 21:40:00","inspection_id":"87465653","insp_unit_id":"212479296","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"XGZ2237","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT8W3DT9TED72287","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-04T09:21:46.000000Z","updated_at":"2026-04-12T09:11:20.000000Z"},{"id":19779478,"change_date":"2026-04-01 21:40:00","inspection_id":"87465653","insp_unit_id":"212479297","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LOAD","insp_unit_company":null,"insp_unit_license":"NOTAG","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4ZEGH3424P1287072","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-04T09:21:46.000000Z","updated_at":"2026-04-12T09:11:20.000000Z"}]},{"id":11083687,"change_date":"2026-02-09 21:38:00","inspection_id":"86994983","dot_number":"3543395","report_state":"OK","report_number":"N914154905","insp_date":"2026-02-09 00:00:00","insp_start_time":"0915","insp_end_time":"0935","registration_date":null,"region":"CT","ci_status_code":"C","location":"009081","location_desc":"US 81 AND JENSEN NB","county_code_state":"OK","county_code":"017","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","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":"212500","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":"811717","transaction_code":"A","transaction_date":"2026-02-09 00:00:00","upload_date":"2026-02-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03543395","upload_search_indicator":null,"census_search_date":"2026-02-09 21:38:00","snet_input_date":"2026-02-09 00:00:00","source_office":"2OKS001","mcmis_add_date":"2026-02-09 21:38:00","insp_carrier_name":"S&P CLEARING AND ENERGY SERVICES LLC","insp_carrier_street":"442 E LANKFORD AVE","insp_carrier_city":"BENNINGTON","insp_carrier_state":"OK","insp_carrier_zip_code":"74723","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":[{"id":18552967,"change_date":"2026-02-09 21:38:00","inspection_id":"86994983","insp_violation_id":"271679105","seq_no":"1","part_no":"392","part_no_section":"2-SLLS1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-12T10:50:28.000000Z","updated_at":"2026-02-20T10:39:07.000000Z","normalized_code":"3922SLLS1"}],"inspection_per_units":[{"id":18899842,"change_date":"2026-02-09 21:38:00","inspection_id":"86994983","insp_unit_id":"211519102","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETE","insp_unit_company":"1044","insp_unit_license":"3LX381","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XPEP4EXXTD785850","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-12T10:13:37.000000Z","updated_at":"2026-02-20T10:03:49.000000Z"},{"id":18899843,"change_date":"2026-02-09 21:38:00","inspection_id":"86994983","insp_unit_id":"211519103","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PITTS","insp_unit_company":"000","insp_unit_license":"BV9417","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5JYLB5537NPP2183","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-12T10:13:37.000000Z","updated_at":"2026-02-20T10:03:49.000000Z"}]},{"id":10230217,"change_date":"2025-11-18 21:39:00","inspection_id":"86352360","dot_number":"3543395","report_state":"OK","report_number":"V900173026","insp_date":"2025-11-18 00:00:00","insp_start_time":"0916","insp_end_time":"0936","registration_date":null,"region":"CT","ci_status_code":"C","location":"25019","location_desc":"SH 19 .5E N3050","county_code_state":"OK","county_code":"049","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-11-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"212500","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":"804016","transaction_code":"A","transaction_date":"2025-11-18 00:00:00","upload_date":"2025-11-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03543395","upload_search_indicator":null,"census_search_date":"2025-11-18 21:39:00","snet_input_date":"2025-11-18 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-11-18 21:39:00","insp_carrier_name":"S&P CLEARING AND ENERGY SERVICES LLC","insp_carrier_street":"442 E LANKFORD AVE","insp_carrier_city":"BENNINGTON","insp_carrier_state":"OK","insp_carrier_zip_code":"74723","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-21T10:31:53.000000Z","updated_at":"2025-11-23T10:31:00.000000Z","inspection_violations":[{"id":17007346,"change_date":"2025-11-18 21:39:00","inspection_id":"86352360","insp_violation_id":"270041430","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-21T10:33:00.000000Z","updated_at":"2025-11-23T10:31:22.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":17048290,"change_date":"2025-11-18 21:39:00","inspection_id":"86352360","insp_unit_id":"210103738","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"3LX381","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XPEP4EXXTD785850","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-21T10:01:59.000000Z","updated_at":"2025-11-23T10:01:12.000000Z"},{"id":17048291,"change_date":"2025-11-18 21:39:00","inspection_id":"86352360","insp_unit_id":"210103739","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PITTS","insp_unit_company":null,"insp_unit_license":"BV9417","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5JYLB5537NPP21813","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-21T10:01:59.000000Z","updated_at":"2025-11-23T10:01:12.000000Z"}]},{"id":7392912,"change_date":"2024-12-13 21:41:00","inspection_id":"83366282","dot_number":"3543395","report_state":"TX","report_number":"70V99DKF0V","insp_date":"2024-12-03 00:00:00","insp_start_time":"0840","insp_end_time":"0931","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0075 IN COLLIN CO. (226-256","county_code_state":"TX","county_code":"085","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-12-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"186820","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":"9444355","transaction_code":"C","transaction_date":"2024-12-13 00:00:00","upload_date":"2024-12-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03543395","upload_search_indicator":"M","census_search_date":"2024-12-11 21:41:00","snet_input_date":"2024-12-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-12-11 21:41:00","insp_carrier_name":"S&P CLEARING AND ENERGY SERVICES LLC","insp_carrier_street":"442 E LANKFORD AVE","insp_carrier_city":"BENNINGTON","insp_carrier_state":"OK","insp_carrier_zip_code":"74723","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1054399","created_at":"2025-03-17T20:50:19.000000Z","updated_at":"2025-03-17T20:50:19.000000Z","inspection_violations":[{"id":11549536,"change_date":"2024-12-13 21:41:00","inspection_id":"83366282","insp_violation_id":"263453129","seq_no":"1","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"204375692","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:13.000000Z","updated_at":"2025-03-17T22:02:13.000000Z","normalized_code":"39617C"},{"id":11549537,"change_date":"2024-12-13 21:41:00","inspection_id":"83366282","insp_violation_id":"263453130","seq_no":"2","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"204375693","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:13.000000Z","updated_at":"2025-03-17T22:02:13.000000Z","normalized_code":"39617C"},{"id":11549538,"change_date":"2024-12-13 21:41:00","inspection_id":"83366282","insp_violation_id":"263453131","seq_no":"3","part_no":"393","part_no_section":"209E","insp_viol_unit":"1","insp_unit_id":"204375692","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:13.000000Z","updated_at":"2025-03-17T22:02:13.000000Z","normalized_code":"393209E"},{"id":11549539,"change_date":"2024-12-13 21:41:00","inspection_id":"83366282","insp_violation_id":"263453132","seq_no":"5","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"204375692","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:13.000000Z","updated_at":"2025-03-17T22:02:13.000000Z","normalized_code":"39360D"}],"inspection_per_units":[{"id":11925994,"change_date":"2024-12-13 21:41:00","inspection_id":"83366282","insp_unit_id":"204375692","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"3JY221","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XPTD49X5ED224002","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:41.000000Z","updated_at":"2025-03-17T23:46:41.000000Z"},{"id":11925995,"change_date":"2024-12-13 21:41:00","inspection_id":"83366282","insp_unit_id":"204375693","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PITT","insp_unit_company":null,"insp_unit_license":"CT2729","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5JYLB553XMPP21478","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:41.000000Z","updated_at":"2025-03-17T23:46:41.000000Z"}]},{"id":7240269,"change_date":"2024-11-20 21:41:00","inspection_id":"83205386","dot_number":"3543395","report_state":"OK","report_number":"B509154904","insp_date":"2024-11-20 00:00:00","insp_start_time":"1325","insp_end_time":"1350","registration_date":null,"region":"CT","ci_status_code":"C","location":"35022","location_desc":"RAVIA","county_code_state":"OK","county_code":"069","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":"2024-11-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"180000","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":"768222","transaction_code":"A","transaction_date":"2024-11-20 00:00:00","upload_date":"2024-11-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03543395","upload_search_indicator":"M","census_search_date":"2024-11-20 21:41:00","snet_input_date":"2024-11-20 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-11-20 21:41:00","insp_carrier_name":"S&P CLEARING AND ENERGY SERVICES LLC","insp_carrier_street":"442 E LANKFORD AVE","insp_carrier_city":"BENNINGTON","insp_carrier_state":"OK","insp_carrier_zip_code":"74723","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:47:13.000000Z","updated_at":"2025-03-17T20:47:13.000000Z","inspection_violations":[{"id":11317483,"change_date":"2024-11-20 21:41:00","inspection_id":"83205386","insp_violation_id":"262998981","seq_no":"1","part_no":"392","part_no_section":"2-SLLTL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:56.000000Z","updated_at":"2025-03-17T22:00:56.000000Z","normalized_code":"3922SLLTL"}],"inspection_per_units":[{"id":11678380,"change_date":"2024-11-20 21:41:00","inspection_id":"83205386","insp_unit_id":"203973166","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"P2022","insp_unit_license":"3GS094","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XPCP4EX5ND814665","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:01.000000Z","updated_at":"2025-03-17T23:44:01.000000Z"},{"id":11678381,"change_date":"2024-11-20 21:41:00","inspection_id":"83205386","insp_unit_id":"203973167","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHER","insp_unit_company":"H2","insp_unit_license":"BV9417","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5JYLB5537NPP21813","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:01.000000Z","updated_at":"2025-03-17T23:44:01.000000Z"}]},{"id":6172959,"change_date":"2024-07-09 21:42:00","inspection_id":"82068703","dot_number":"3543395","report_state":"SD","report_number":"5500001373","insp_date":"2024-07-09 00:00:00","insp_start_time":"0934","insp_end_time":"1036","registration_date":null,"region":"CD","ci_status_code":"C","location":"JEFFNB","location_desc":"JEFFERSON SD","county_code_state":"SD","county_code":"127","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"S&P CLEARING AND ENERGY SERVICES LLC","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-07-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"36000","viol_total":"4","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":"638305","transaction_code":"A","transaction_date":"2024-07-09 00:00:00","upload_date":"2024-07-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03543395","upload_search_indicator":null,"census_search_date":"2024-07-09 21:42:00","snet_input_date":"2024-07-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-09 21:42:00","insp_carrier_name":"S&P CLEARING AND ENERGY SERVICES LLC","insp_carrier_street":"442 E LANKFORD AVE","insp_carrier_city":"BENNINGTON","insp_carrier_state":"OK","insp_carrier_zip_code":"74723","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:25:01.000000Z","updated_at":"2025-03-17T20:25:01.000000Z","inspection_violations":[{"id":9585366,"change_date":"2024-07-09 21:42:00","inspection_id":"82068703","insp_violation_id":"260530480","seq_no":"1","part_no":"395","part_no_section":"8(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:52:24.000000Z","updated_at":"2025-03-17T21:52:24.000000Z","normalized_code":"3958A"},{"id":9585367,"change_date":"2024-07-09 21:42:00","inspection_id":"82068703","insp_violation_id":"260530481","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"201787835","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:52:24.000000Z","updated_at":"2025-03-17T21:52:24.000000Z","normalized_code":"39617C"},{"id":9585368,"change_date":"2024-07-09 21:42:00","inspection_id":"82068703","insp_violation_id":"260530482","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"201787835","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:52:24.000000Z","updated_at":"2025-03-17T21:52:24.000000Z","normalized_code":"39617C"},{"id":9585369,"change_date":"2024-07-09 21:42:00","inspection_id":"82068703","insp_violation_id":"260530483","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201787835","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:52:24.000000Z","updated_at":"2025-03-17T21:52:24.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9944339,"change_date":"2024-07-09 21:42:00","inspection_id":"82068703","insp_unit_id":"201787835","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"1","insp_unit_license":"10422V","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FD8W3HT4KED71472","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:02.000000Z","updated_at":"2025-03-17T23:26:02.000000Z"},{"id":9944340,"change_date":"2024-07-09 21:42:00","inspection_id":"82068703","insp_unit_id":"201787836","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":"2","insp_unit_license":"TEMP","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4ZEGH2829P1282826","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:02.000000Z","updated_at":"2025-03-17T23:26:02.000000Z"}]},{"id":5400941,"change_date":"2024-03-29 21:38:00","inspection_id":"81230497","dot_number":"3543395","report_state":"TX","report_number":"V241309641","insp_date":"2024-03-27 00:00:00","insp_start_time":"1350","insp_end_time":"1400","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM1763 SB","county_code_state":"TX","county_code":"487","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"XX","shipping_paper_number":"EMPTY","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-03-29 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"212500","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":"9235127","transaction_code":"A","transaction_date":"2024-03-29 00:00:00","upload_date":"2024-03-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03543395","upload_search_indicator":"M","census_search_date":"2024-03-29 21:38:00","snet_input_date":"2024-03-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-03-29 21:38:00","insp_carrier_name":"S&P CLEARING AND ENERGY SERVICES LLC","insp_carrier_street":"442 E LANKFORD AVE","insp_carrier_city":"BENNINGTON","insp_carrier_state":"OK","insp_carrier_zip_code":"74723","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1054399","created_at":"2025-03-17T20:09:49.000000Z","updated_at":"2025-03-17T20:09:49.000000Z","inspection_violations":[{"id":8335206,"change_date":"2024-03-29 21:38:00","inspection_id":"81230497","insp_violation_id":"258661152","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"200159554","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:19.000000Z","updated_at":"2025-03-17T21:46:19.000000Z","normalized_code":"39345B2"},{"id":8335207,"change_date":"2024-03-29 21:38:00","inspection_id":"81230497","insp_violation_id":"258661153","seq_no":"2","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"2","insp_unit_id":"200159554","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:19.000000Z","updated_at":"2025-03-17T21:46:19.000000Z","normalized_code":"39345D"},{"id":8335208,"change_date":"2024-03-29 21:38:00","inspection_id":"81230497","insp_violation_id":"258661154","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"200159553","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:19.000000Z","updated_at":"2025-03-17T21:46:19.000000Z","normalized_code":"39617C"},{"id":8335209,"change_date":"2024-03-29 21:38:00","inspection_id":"81230497","insp_violation_id":"258661155","seq_no":"4","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"200159554","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:19.000000Z","updated_at":"2025-03-17T21:46:19.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":8698657,"change_date":"2024-03-29 21:38:00","inspection_id":"81230497","insp_unit_id":"200159553","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"HL1","insp_unit_license":"3GS094","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XPCP4EX5ND814665","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:54.000000Z","updated_at":"2025-03-17T23:13:54.000000Z"},{"id":8698658,"change_date":"2024-03-29 21:38:00","inspection_id":"81230497","insp_unit_id":"200159554","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"0","insp_unit_license":"BV9417","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5JYLB5537NPP21813","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:54.000000Z","updated_at":"2025-03-17T23:13:54.000000Z"}]},{"id":4636273,"change_date":"2024-12-04 21:42:00","inspection_id":"80395773","dot_number":"3543395","report_state":"TX","report_number":"V231254953","insp_date":"2023-12-10 00:00:00","insp_start_time":"1255","insp_end_time":"1337","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-20 MM413 WB","county_code_state":"TX","county_code":"367","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"-","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":"Y","pen_cen_match":null,"final_status_date":"2023-12-14 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"184500","viol_total":"6","oos_total":"2","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9148227","transaction_code":"C","transaction_date":"2024-12-04 00:00:00","upload_date":"2024-12-04 00:00:00","upload_first_byte":"0","upload_dot_number":"03543395","upload_search_indicator":"M","census_search_date":"2023-12-14 21:44:00","snet_input_date":"2023-12-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-12-14 21:44:00","insp_carrier_name":"S&P CLEARING AND ENERGY SERVICES LLC","insp_carrier_street":"442 E LANKFORD AVE","insp_carrier_city":"BENNINGTON","insp_carrier_state":"OK","insp_carrier_zip_code":"74723","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1054399","created_at":"2025-03-17T19:54:36.000000Z","updated_at":"2025-03-17T19:54:36.000000Z","inspection_violations":[{"id":7168728,"change_date":"2024-12-04 21:42:00","inspection_id":"80395773","insp_violation_id":"263239453","seq_no":"1","part_no":"392","part_no_section":"16","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:38.000000Z","updated_at":"2025-03-17T21:40:38.000000Z","normalized_code":"39216"},{"id":7168729,"change_date":"2024-12-04 21:42:00","inspection_id":"80395773","insp_violation_id":"263239454","seq_no":"2","part_no":"393","part_no_section":"11TL","insp_viol_unit":"1","insp_unit_id":"204187999","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:38.000000Z","updated_at":"2025-03-17T21:40:38.000000Z","normalized_code":"39311TL"},{"id":7168730,"change_date":"2024-12-04 21:42:00","inspection_id":"80395773","insp_violation_id":"263239455","seq_no":"3","part_no":"393","part_no_section":"75A3","insp_viol_unit":"2","insp_unit_id":"204188000","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:40:38.000000Z","updated_at":"2025-03-17T21:40:38.000000Z","normalized_code":"39375A3"},{"id":7168731,"change_date":"2024-12-04 21:42:00","inspection_id":"80395773","insp_violation_id":"263239456","seq_no":"4","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"204188000","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:38.000000Z","updated_at":"2025-03-17T21:40:38.000000Z","normalized_code":"3939"},{"id":7168732,"change_date":"2024-12-04 21:42:00","inspection_id":"80395773","insp_violation_id":"263239457","seq_no":"5","part_no":"393","part_no_section":"9TS","insp_viol_unit":"2","insp_unit_id":"204188000","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-03-17T21:40:38.000000Z","updated_at":"2025-03-17T21:40:38.000000Z","normalized_code":"3939TS"},{"id":7168733,"change_date":"2024-12-04 21:42:00","inspection_id":"80395773","insp_violation_id":"263239458","seq_no":"6","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"204187999","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:38.000000Z","updated_at":"2025-03-17T21:40:38.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":7457017,"change_date":"2024-12-04 21:42:00","inspection_id":"80395773","insp_unit_id":"204187999","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"003P","insp_unit_license":"3JY221","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XPTD49X5ED224002","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:41.000000Z","updated_at":"2025-03-17T23:02:41.000000Z"},{"id":7457018,"change_date":"2024-12-04 21:42:00","inspection_id":"80395773","insp_unit_id":"204188000","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PITT","insp_unit_company":"T003P","insp_unit_license":"CT2729","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5JYLB553XMPP21478","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:41.000000Z","updated_at":"2025-03-17T23:02:41.000000Z"}]},{"id":4312552,"change_date":"2023-11-27 21:41:00","inspection_id":"80039116","dot_number":"3543395","report_state":"OK","report_number":"X200171695","insp_date":"2023-10-23 00:00:00","insp_start_time":"1000","insp_end_time":"1040","registration_date":"2023-11-27 00:00:00","region":"CT","ci_status_code":"C","location":"09CR","location_desc":"US 81\/W DIVISION","county_code_state":"OK","county_code":"017","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"N\/A","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-10-30 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"37990","viol_total":"6","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"726440","transaction_code":"C","transaction_date":"2023-10-23 00:00:00","upload_date":"2023-11-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03543395","upload_search_indicator":"M","census_search_date":"2023-10-30 21:43:00","snet_input_date":"2023-10-23 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-10-30 21:43:00","insp_carrier_name":"S&P CLEARING AND ENERGY SERVICES LLC","insp_carrier_street":"442 E LANKFORD AVE","insp_carrier_city":"BENNINGTON","insp_carrier_state":"OK","insp_carrier_zip_code":"74723","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:48:23.000000Z","updated_at":"2025-03-17T19:48:23.000000Z","inspection_violations":[{"id":6671029,"change_date":"2023-11-27 21:41:00","inspection_id":"80039116","insp_violation_id":"256559677","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:07.000000Z","updated_at":"2025-03-17T21:38:07.000000Z","normalized_code":"38323A2"},{"id":6671030,"change_date":"2023-11-27 21:41:00","inspection_id":"80039116","insp_violation_id":"256559678","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"198210450","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:07.000000Z","updated_at":"2025-03-17T21:38:07.000000Z","normalized_code":"39395A"},{"id":6671031,"change_date":"2023-11-27 21:41:00","inspection_id":"80039116","insp_violation_id":"256559679","seq_no":"3","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"198210450","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:07.000000Z","updated_at":"2025-03-17T21:38:07.000000Z","normalized_code":"39395F"},{"id":6671032,"change_date":"2023-11-27 21:41:00","inspection_id":"80039116","insp_violation_id":"256559680","seq_no":"4","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"198210450","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:07.000000Z","updated_at":"2025-03-17T21:38:07.000000Z","normalized_code":"39021TB"},{"id":6671033,"change_date":"2023-11-27 21:41:00","inspection_id":"80039116","insp_violation_id":"256559681","seq_no":"5","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"198210450","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:07.000000Z","updated_at":"2025-03-17T21:38:07.000000Z","normalized_code":"39617C"},{"id":6671034,"change_date":"2023-11-27 21:41:00","inspection_id":"80039116","insp_violation_id":"256559682","seq_no":"6","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"198210451","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:07.000000Z","updated_at":"2025-03-17T21:38:07.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":6935867,"change_date":"2023-11-27 21:41:00","inspection_id":"80039116","insp_unit_id":"198210450","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"SZC9548","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT8W3DT5PEC58048","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:13.000000Z","updated_at":"2025-03-17T22:58:13.000000Z"},{"id":6935868,"change_date":"2023-11-27 21:41:00","inspection_id":"80039116","insp_unit_id":"198210451","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DELCO","insp_unit_company":null,"insp_unit_license":"41495Z2","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5WWGF2824N6021770","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:13.000000Z","updated_at":"2025-03-17T22:58:13.000000Z"}]},{"id":3905179,"change_date":"2023-10-17 21:42:00","inspection_id":"79587502","dot_number":"3543395","report_state":"TX","report_number":"V231136122","insp_date":"2023-08-30 00:00:00","insp_start_time":"1215","insp_end_time":"1248","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH146 MM424","county_code_state":"TX","county_code":"291","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"LUFKIN JOB SITE","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":"Y","pen_cen_match":null,"final_status_date":"2023-09-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"212500","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":"9067251","transaction_code":"C","transaction_date":"2023-10-17 00:00:00","upload_date":"2023-10-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03543395","upload_search_indicator":"M","census_search_date":"2023-09-05 21:41:00","snet_input_date":"2023-08-30 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-09-05 21:41:00","insp_carrier_name":"S&P CLEARING AND ENERGY SERVICES LLC","insp_carrier_street":"442 E LANKFORD AVE","insp_carrier_city":"BENNINGTON","insp_carrier_state":"OK","insp_carrier_zip_code":"74723","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1054399","created_at":"2025-03-17T19:40:04.000000Z","updated_at":"2025-03-17T19:40:04.000000Z","inspection_violations":[{"id":6036048,"change_date":"2023-10-17 21:42:00","inspection_id":"79587502","insp_violation_id":"255892369","seq_no":"1","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"197606183","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:12.000000Z","updated_at":"2025-03-17T21:35:12.000000Z","normalized_code":"39360D"},{"id":6036049,"change_date":"2023-10-17 21:42:00","inspection_id":"79587502","insp_violation_id":"255892370","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"197606184","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:12.000000Z","updated_at":"2025-03-17T21:35:12.000000Z","normalized_code":"3939A"},{"id":6036050,"change_date":"2023-10-17 21:42:00","inspection_id":"79587502","insp_violation_id":"255892371","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"197606184","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:12.000000Z","updated_at":"2025-03-17T21:35:12.000000Z","normalized_code":"3939A"},{"id":6036051,"change_date":"2023-10-17 21:42:00","inspection_id":"79587502","insp_violation_id":"255892372","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"197606184","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:12.000000Z","updated_at":"2025-03-17T21:35:12.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6279307,"change_date":"2023-10-17 21:42:00","inspection_id":"79587502","insp_unit_id":"197606183","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"01","insp_unit_license":"3FW877","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XPTD40X3CD137497","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:44.000000Z","updated_at":"2025-03-17T22:52:44.000000Z"},{"id":6279308,"change_date":"2023-10-17 21:42:00","inspection_id":"79587502","insp_unit_id":"197606184","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PITT","insp_unit_company":"T01","insp_unit_license":"CT2729","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5JYLB553XMPP21478","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:44.000000Z","updated_at":"2025-03-17T22:52:44.000000Z"}]},{"id":3264558,"change_date":"2023-06-14 21:42:00","inspection_id":"78869170","dot_number":"3543395","report_state":"TX","report_number":"6LQF0MBXRO","insp_date":"2023-06-07 00:00:00","insp_start_time":"1514","insp_end_time":"1532","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0180 IN SCURRY CO. (338-374","county_code_state":"TX","county_code":"415","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"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":"2023-06-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"190500","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9002054","transaction_code":"C","transaction_date":"2023-06-14 00:00:00","upload_date":"2023-06-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03543395","upload_search_indicator":"M","census_search_date":"2023-06-12 21:41:00","snet_input_date":"2023-06-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-06-12 21:41:00","insp_carrier_name":"S&P CLEARING AND ENERGY SERVICES LLC","insp_carrier_street":"442 E LANKFORD AVE","insp_carrier_city":"BENNINGTON","insp_carrier_state":"OK","insp_carrier_zip_code":"74723","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1054399","created_at":"2025-03-17T19:27:41.000000Z","updated_at":"2025-03-17T19:27:41.000000Z","inspection_violations":[{"id":5034465,"change_date":"2023-06-14 21:42:00","inspection_id":"78869170","insp_violation_id":"253508551","seq_no":"1","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"195501159","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:23.000000Z","updated_at":"2025-03-17T21:30:23.000000Z","normalized_code":"39360D"},{"id":5034466,"change_date":"2023-06-14 21:42:00","inspection_id":"78869170","insp_violation_id":"253508552","seq_no":"2","part_no":"395","part_no_section":"8(f)(1)","insp_viol_unit":"1","insp_unit_id":"195501159","insp_violation_category_id":"3","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:23.000000Z","updated_at":"2025-03-17T21:30:23.000000Z","normalized_code":"3958F1"},{"id":5034467,"change_date":"2023-06-14 21:42:00","inspection_id":"78869170","insp_violation_id":"253508553","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:23.000000Z","updated_at":"2025-03-17T21:30:23.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":5249949,"change_date":"2023-06-14 21:42:00","inspection_id":"78869170","insp_unit_id":"195501159","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"1","insp_unit_license":"3FW877","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XPTD40X3CD137497","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:22.000000Z","updated_at":"2025-03-17T22:44:22.000000Z"},{"id":5249950,"change_date":"2023-06-14 21:42:00","inspection_id":"78869170","insp_unit_id":"195501160","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"1","insp_unit_license":"CT2729","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5JYLB553XMPP21478","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:22.000000Z","updated_at":"2025-03-17T22:44:22.000000Z"}]},{"id":3178753,"change_date":"2023-05-31 21:42:00","inspection_id":"78772242","dot_number":"3543395","report_state":"OK","report_number":"E300153812","insp_date":"2023-05-31 00:00:00","insp_start_time":"0717","insp_end_time":"0805","registration_date":null,"region":"CT","ci_status_code":"C","location":"26019","location_desc":"S.H. 19 W OF BRADLEY","county_code_state":"OK","county_code":"051","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-31 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"36000","viol_total":"10","oos_total":"3","driver_viol_total":"3","driver_oos_total":"1","vehicle_viol_total":"7","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"711714","transaction_code":"A","transaction_date":"2023-05-31 00:00:00","upload_date":"2023-05-31 00:00:00","upload_first_byte":"0","upload_dot_number":"03543395","upload_search_indicator":"M","census_search_date":"2023-05-31 21:42:00","snet_input_date":"2023-05-31 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-05-31 21:42:00","insp_carrier_name":"S&P CLEARING AND ENERGY SERVICES LLC","insp_carrier_street":"442 E LANKFORD AVE","insp_carrier_city":"BENNINGTON","insp_carrier_state":"OK","insp_carrier_zip_code":"74723","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:25:47.000000Z","updated_at":"2025-03-17T19:25:47.000000Z","inspection_violations":[{"id":4898478,"change_date":"2023-05-31 21:42:00","inspection_id":"78772242","insp_violation_id":"253179282","seq_no":"10","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195227131","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:46.000000Z","updated_at":"2025-03-17T21:29:46.000000Z","normalized_code":"3922"},{"id":4898479,"change_date":"2023-05-31 21:42:00","inspection_id":"78772242","insp_violation_id":"253179283","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:46.000000Z","updated_at":"2025-03-17T21:29:46.000000Z","normalized_code":"38323A2"},{"id":4898480,"change_date":"2023-05-31 21:42:00","inspection_id":"78772242","insp_violation_id":"253179284","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:46.000000Z","updated_at":"2025-03-17T21:29:46.000000Z","normalized_code":"3922"},{"id":4898481,"change_date":"2023-05-31 21:42:00","inspection_id":"78772242","insp_violation_id":"253179285","seq_no":"3","part_no":"391","part_no_section":"41(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:46.000000Z","updated_at":"2025-03-17T21:29:46.000000Z","normalized_code":"39141A1"},{"id":4898482,"change_date":"2023-05-31 21:42:00","inspection_id":"78772242","insp_violation_id":"253179286","seq_no":"4","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"195227131","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:46.000000Z","updated_at":"2025-03-17T21:29:46.000000Z","normalized_code":"39021TB"},{"id":4898483,"change_date":"2023-05-31 21:42:00","inspection_id":"78772242","insp_violation_id":"253179287","seq_no":"5","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"195227132","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:29:46.000000Z","updated_at":"2025-03-17T21:29:46.000000Z","normalized_code":"39343"},{"id":4898484,"change_date":"2023-05-31 21:42:00","inspection_id":"78772242","insp_violation_id":"253179288","seq_no":"6","part_no":"393","part_no_section":"110","insp_viol_unit":"2","insp_unit_id":"195227132","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:29:46.000000Z","updated_at":"2025-03-17T21:29:46.000000Z","normalized_code":"393110"},{"id":4898485,"change_date":"2023-05-31 21:42:00","inspection_id":"78772242","insp_violation_id":"253179289","seq_no":"7","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"195227132","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:46.000000Z","updated_at":"2025-03-17T21:29:46.000000Z","normalized_code":"3922"},{"id":4898486,"change_date":"2023-05-31 21:42:00","inspection_id":"78772242","insp_violation_id":"253179290","seq_no":"8","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"195227131","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:46.000000Z","updated_at":"2025-03-17T21:29:46.000000Z","normalized_code":"39617C"},{"id":4898487,"change_date":"2023-05-31 21:42:00","inspection_id":"78772242","insp_violation_id":"253179291","seq_no":"9","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"195227132","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:46.000000Z","updated_at":"2025-03-17T21:29:46.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":5112817,"change_date":"2023-05-31 21:42:00","inspection_id":"78772242","insp_unit_id":"195227131","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"SZC9546","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT8W3DT7PEC58049","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:17.000000Z","updated_at":"2025-03-17T22:43:17.000000Z"},{"id":5112818,"change_date":"2023-05-31 21:42:00","inspection_id":"78772242","insp_unit_id":"195227132","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LOAD","insp_unit_company":null,"insp_unit_license":"1450T65","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4ZEGH28822N127582","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:17.000000Z","updated_at":"2025-03-17T22:43:17.000000Z"}]},{"id":2726282,"change_date":"2023-05-01 21:39:00","inspection_id":"78261015","dot_number":"3543395","report_state":"OK","report_number":"B509153828","insp_date":"2023-04-04 00:00:00","insp_start_time":"1155","insp_end_time":"1220","registration_date":null,"region":"CT","ci_status_code":"C","location":"10199","location_desc":"DICKSON","county_code_state":"OK","county_code":"019","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":"2023-04-04 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"186500","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":"704866","transaction_code":"C","transaction_date":"2023-04-21 00:00:00","upload_date":"2023-05-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03543395","upload_search_indicator":"M","census_search_date":"2023-04-04 21:42:00","snet_input_date":"2023-04-04 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-04-04 21:42:00","insp_carrier_name":"S&P CLEARING AND ENERGY SERVICES LLC","insp_carrier_street":"442 E LANKFORD AVE","insp_carrier_city":"BENNINGTON","insp_carrier_state":"OK","insp_carrier_zip_code":"74723","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:16:57.000000Z","updated_at":"2025-03-17T19:16:57.000000Z","inspection_violations":[{"id":4188979,"change_date":"2023-05-01 21:39:00","inspection_id":"78261015","insp_violation_id":"252536097","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:36.000000Z","updated_at":"2025-03-17T21:26:36.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4388187,"change_date":"2023-05-01 21:39:00","inspection_id":"78261015","insp_unit_id":"194671458","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"11","insp_unit_license":"3FW877","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XPTD40X3CD137497","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:32.000000Z","updated_at":"2025-03-17T22:37:32.000000Z"},{"id":4388188,"change_date":"2023-05-01 21:39:00","inspection_id":"78261015","insp_unit_id":"194671459","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PITZ","insp_unit_company":"11T","insp_unit_license":"CT2729","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5JYLB553XMPP21478","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:32.000000Z","updated_at":"2025-03-17T22:37:32.000000Z"}]},{"id":1123210,"change_date":"2022-08-24 21:39:00","inspection_id":"76421400","dot_number":"3543395","report_state":"OK","report_number":"N914153183","insp_date":"2022-08-23 00:00:00","insp_start_time":"1520","insp_end_time":"1620","registration_date":null,"region":"CT","ci_status_code":"C","location":"009081","location_desc":"US 81 AND BRITTON","county_code_state":"OK","county_code":"017","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-24 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"30000","viol_total":"21","oos_total":"6","driver_viol_total":"3","driver_oos_total":"2","vehicle_viol_total":"18","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"681669","transaction_code":"A","transaction_date":"2022-08-24 00:00:00","upload_date":"2022-08-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03543395","upload_search_indicator":"M","census_search_date":"2022-08-24 21:39:00","snet_input_date":"2022-08-23 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-08-24 21:39:00","insp_carrier_name":"S&P CLEARING AND ENERGY SERVICES LLC","insp_carrier_street":"442 E LANKFORD AVE","insp_carrier_city":"BENNINGTON","insp_carrier_state":"OK","insp_carrier_zip_code":"74723","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:47:32.000000Z","updated_at":"2025-03-17T18:47:32.000000Z","inspection_violations":[{"id":1773754,"change_date":"2022-08-24 21:39:00","inspection_id":"76421400","insp_violation_id":"247956188","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"42","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:15.000000Z","updated_at":"2025-03-17T21:15:15.000000Z","normalized_code":"3922"},{"id":1773755,"change_date":"2022-08-24 21:39:00","inspection_id":"76421400","insp_violation_id":"247956189","seq_no":"2","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:15.000000Z","updated_at":"2025-03-17T21:15:15.000000Z","normalized_code":"38323A2"},{"id":1773756,"change_date":"2022-08-24 21:39:00","inspection_id":"76421400","insp_violation_id":"247956190","seq_no":"3","part_no":"391","part_no_section":"11(b)(4)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:15.000000Z","updated_at":"2025-03-17T21:15:15.000000Z","normalized_code":"39111B4"},{"id":1773757,"change_date":"2022-08-24 21:39:00","inspection_id":"76421400","insp_violation_id":"247956191","seq_no":"4","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"190513022","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:15.000000Z","updated_at":"2025-03-17T21:15:15.000000Z","normalized_code":"39021TB"},{"id":1773758,"change_date":"2022-08-24 21:39:00","inspection_id":"76421400","insp_violation_id":"247956192","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190513022","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:15.000000Z","updated_at":"2025-03-17T21:15:15.000000Z","normalized_code":"3922"},{"id":1773759,"change_date":"2022-08-24 21:39:00","inspection_id":"76421400","insp_violation_id":"247956193","seq_no":"6","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"190513022","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:15.000000Z","updated_at":"2025-03-17T21:15:15.000000Z","normalized_code":"39617C"},{"id":1773760,"change_date":"2022-08-24 21:39:00","inspection_id":"76421400","insp_violation_id":"247956194","seq_no":"7","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"190513022","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:15.000000Z","updated_at":"2025-03-17T21:15:15.000000Z","normalized_code":"39395F"},{"id":1773761,"change_date":"2022-08-24 21:39:00","inspection_id":"76421400","insp_violation_id":"247956195","seq_no":"8","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"190513023","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:15:15.000000Z","updated_at":"2025-03-17T21:15:15.000000Z","normalized_code":"39343"},{"id":1773762,"change_date":"2022-08-24 21:39:00","inspection_id":"76421400","insp_violation_id":"247956196","seq_no":"9","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"190513023","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:15.000000Z","updated_at":"2025-03-17T21:15:15.000000Z","normalized_code":"39348A"},{"id":1773763,"change_date":"2022-08-24 21:39:00","inspection_id":"76421400","insp_violation_id":"247956197","seq_no":"10","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"190513023","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:15.000000Z","updated_at":"2025-03-17T21:15:15.000000Z","normalized_code":"39348A"},{"id":1773764,"change_date":"2022-08-24 21:39:00","inspection_id":"76421400","insp_violation_id":"247956198","seq_no":"11","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"190513023","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:15.000000Z","updated_at":"2025-03-17T21:15:15.000000Z","normalized_code":"39348A"},{"id":1773765,"change_date":"2022-08-24 21:39:00","inspection_id":"76421400","insp_violation_id":"247956199","seq_no":"12","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"190513023","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:15.000000Z","updated_at":"2025-03-17T21:15:15.000000Z","normalized_code":"39348A"},{"id":1773766,"change_date":"2022-08-24 21:39:00","inspection_id":"76421400","insp_violation_id":"247956200","seq_no":"13","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"190513023","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:15:15.000000Z","updated_at":"2025-03-17T21:15:15.000000Z","normalized_code":"3963A1"},{"id":1773767,"change_date":"2022-08-24 21:39:00","inspection_id":"76421400","insp_violation_id":"247956201","seq_no":"14","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"190513023","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:15.000000Z","updated_at":"2025-03-17T21:15:15.000000Z","normalized_code":"39617C"},{"id":1773768,"change_date":"2022-08-24 21:39:00","inspection_id":"76421400","insp_violation_id":"247956202","seq_no":"15","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"2","insp_unit_id":"190513023","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:15:15.000000Z","updated_at":"2025-03-17T21:15:15.000000Z","normalized_code":"39375A"},{"id":1773769,"change_date":"2022-08-24 21:39:00","inspection_id":"76421400","insp_violation_id":"247956203","seq_no":"16","part_no":"393","part_no_section":"75(a)(1)","insp_viol_unit":"2","insp_unit_id":"190513023","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:15.000000Z","updated_at":"2025-03-17T21:15:15.000000Z","normalized_code":"39375A1"},{"id":1773770,"change_date":"2022-08-24 21:39:00","inspection_id":"76421400","insp_violation_id":"247956204","seq_no":"17","part_no":"393","part_no_section":"75(a)(1)","insp_viol_unit":"2","insp_unit_id":"190513023","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:15.000000Z","updated_at":"2025-03-17T21:15:15.000000Z","normalized_code":"39375A1"},{"id":1773771,"change_date":"2022-08-24 21:39:00","inspection_id":"76421400","insp_violation_id":"247956205","seq_no":"18","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"190513023","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:15.000000Z","updated_at":"2025-03-17T21:15:15.000000Z","normalized_code":"3939A"},{"id":1773772,"change_date":"2022-08-24 21:39:00","inspection_id":"76421400","insp_violation_id":"247956206","seq_no":"19","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"190513023","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:15.000000Z","updated_at":"2025-03-17T21:15:15.000000Z","normalized_code":"3939A"},{"id":1773773,"change_date":"2022-08-24 21:39:00","inspection_id":"76421400","insp_violation_id":"247956207","seq_no":"20","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"190513023","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:15:15.000000Z","updated_at":"2025-03-17T21:15:15.000000Z","normalized_code":"3939A"},{"id":1773774,"change_date":"2022-08-24 21:39:00","inspection_id":"76421400","insp_violation_id":"247956208","seq_no":"21","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"190513023","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:15.000000Z","updated_at":"2025-03-17T21:15:15.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1806488,"change_date":"2022-08-24 21:39:00","inspection_id":"76421400","insp_unit_id":"190513022","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"000","insp_unit_license":"PWR2408","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1GC4YNEY2MF300115","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:27.000000Z","updated_at":"2025-03-17T22:19:27.000000Z"},{"id":1806489,"change_date":"2022-08-24 21:39:00","inspection_id":"76421400","insp_unit_id":"190513023","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LEGEN","insp_unit_company":"000","insp_unit_license":"9943JT","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5D3BG3220DE104288","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:27.000000Z","updated_at":"2025-03-17T22:19:27.000000Z"}]},{"id":626206,"change_date":"2022-06-16 21:42:00","inspection_id":"75839384","dot_number":"3543395","report_state":"OK","report_number":"S614152485","insp_date":"2022-06-16 00:00:00","insp_start_time":"0645","insp_end_time":"0735","registration_date":null,"region":"CT","ci_status_code":"C","location":"15003","location_desc":"1 EAST OF SH 48","county_code_state":"OK","county_code":"029","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":null,"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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-16 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"18150","viol_total":"9","oos_total":"4","driver_viol_total":"3","driver_oos_total":"1","vehicle_viol_total":"6","vehicle_oos_total":"3","hazmat_viol_total":"2","hazmat_oos_total":"2","snet_sequence_id":"674143","transaction_code":"A","transaction_date":"2022-06-16 00:00:00","upload_date":"2022-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03543395","upload_search_indicator":"M","census_search_date":"2022-06-16 21:42:00","snet_input_date":"2022-06-16 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-06-16 21:42:00","insp_carrier_name":"S&P CLEARING AND ENERGY SERVICES LLC","insp_carrier_street":"442 E LANKFORD AVE","insp_carrier_city":"BENNINGTON","insp_carrier_state":"OK","insp_carrier_zip_code":"74723","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:38:47.000000Z","updated_at":"2025-03-17T18:38:47.000000Z","inspection_violations":[{"id":982272,"change_date":"2022-06-16 21:42:00","inspection_id":"75839384","insp_violation_id":"246512184","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:37.000000Z","updated_at":"2025-03-17T21:11:37.000000Z","normalized_code":"3922"},{"id":982273,"change_date":"2022-06-16 21:42:00","inspection_id":"75839384","insp_violation_id":"246512185","seq_no":"2","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"189290858","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:37.000000Z","updated_at":"2025-03-17T21:11:37.000000Z","normalized_code":"39021TB"},{"id":982274,"change_date":"2022-06-16 21:42:00","inspection_id":"75839384","insp_violation_id":"246512186","seq_no":"3","part_no":"177","part_no_section":"817(a)","insp_viol_unit":"1","insp_unit_id":"189290858","insp_violation_category_id":"31","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:11:37.000000Z","updated_at":"2025-03-17T21:11:37.000000Z","normalized_code":"177817A"},{"id":982275,"change_date":"2022-06-16 21:42:00","inspection_id":"75839384","insp_violation_id":"246512187","seq_no":"4","part_no":"177","part_no_section":"823(a)","insp_viol_unit":"1","insp_unit_id":"189290858","insp_violation_category_id":"32","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:11:37.000000Z","updated_at":"2025-03-17T21:11:37.000000Z","normalized_code":"177823A"},{"id":982276,"change_date":"2022-06-16 21:42:00","inspection_id":"75839384","insp_violation_id":"246512188","seq_no":"5","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"189290859","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:11:37.000000Z","updated_at":"2025-03-17T21:11:37.000000Z","normalized_code":"39343"},{"id":982277,"change_date":"2022-06-16 21:42:00","inspection_id":"75839384","insp_violation_id":"246512189","seq_no":"6","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:37.000000Z","updated_at":"2025-03-17T21:11:37.000000Z","normalized_code":"38323A2"},{"id":982278,"change_date":"2022-06-16 21:42:00","inspection_id":"75839384","insp_violation_id":"246512190","seq_no":"7","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"189290859","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:37.000000Z","updated_at":"2025-03-17T21:11:37.000000Z","normalized_code":"3922"},{"id":982279,"change_date":"2022-06-16 21:42:00","inspection_id":"75839384","insp_violation_id":"246512191","seq_no":"8","part_no":"391","part_no_section":"41(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:37.000000Z","updated_at":"2025-03-17T21:11:37.000000Z","normalized_code":"39141A1"},{"id":982280,"change_date":"2022-06-16 21:42:00","inspection_id":"75839384","insp_violation_id":"246512192","seq_no":"9","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"189290858","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:37.000000Z","updated_at":"2025-03-17T21:11:37.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":1006366,"change_date":"2022-06-16 21:42:00","inspection_id":"75839384","insp_unit_id":"189290858","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"PWR3947","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1GC4YNEY7MF302362","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:23.000000Z","updated_at":"2025-03-17T22:14:23.000000Z"},{"id":1006367,"change_date":"2022-06-16 21:42:00","inspection_id":"75839384","insp_unit_id":"189290859","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DNJ","insp_unit_company":null,"insp_unit_license":"NONE","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1GC4YNEY7MF302362","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:23.000000Z","updated_at":"2025-03-17T22:14:23.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3543395\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3543395\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3543395\/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\/3543395\/inspections","per_page":100,"prev_page_url":null,"to":16,"total":16}