{"current_page":1,"data":[{"id":11778603,"change_date":"2026-04-29 21:39:00","inspection_id":"87709746","dot_number":"1234537","report_state":"SD","report_number":"5430002541","insp_date":"2026-04-29 00:00:00","insp_start_time":"0934","insp_end_time":"1002","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"SALEM SD","county_code_state":"SD","county_code":"087","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"406","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-04-29 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":"3230083","transaction_code":"A","transaction_date":"2026-04-29 00:00:00","upload_date":"2026-04-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01234537","upload_search_indicator":null,"census_search_date":"2026-04-29 21:39:00","snet_input_date":"2026-04-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-29 21:39:00","insp_carrier_name":"APPEL OIL COMPANY","insp_carrier_street":"833 WEST 3RD STREET","insp_carrier_city":"REDFIELD","insp_carrier_state":"SD","insp_carrier_zip_code":"57469","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-05-02T09:41:00.000000Z","updated_at":"2026-05-10T09:30:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20490801,"change_date":"2026-04-29 21:39:00","inspection_id":"87709746","insp_unit_id":"213285566","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"25835C","insp_unit_license_state":"SD","insp_unit_vehicle_id_number":"1M1AN07Y2EM016119","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-02T09:19:11.000000Z","updated_at":"2026-05-10T09:03:02.000000Z"},{"id":20490802,"change_date":"2026-04-29 21:39:00","inspection_id":"87709746","insp_unit_id":"213285567","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"U155441","insp_unit_license_state":"SD","insp_unit_vehicle_id_number":"558MSB441MB006286","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-02T09:19:11.000000Z","updated_at":"2026-05-10T09:03:02.000000Z"}]},{"id":10586212,"change_date":"2026-01-07 21:38:00","inspection_id":"86724857","dot_number":"1234537","report_state":"SD","report_number":"0750001179","insp_date":"2026-01-07 00:00:00","insp_start_time":"1100","insp_end_time":"1133","registration_date":null,"region":"CS","ci_status_code":"C","location":"WOLSEY","location_desc":"WOLSEY SD","county_code_state":"SD","county_code":"005","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SUNOCO LP","shipping_paper_number":"0020273","cargo_tank":"306","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-07 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"2733491","transaction_code":"A","transaction_date":"2026-01-07 00:00:00","upload_date":"2026-01-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01234537","upload_search_indicator":null,"census_search_date":"2026-01-07 21:38:00","snet_input_date":"2026-01-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-07 21:38:00","insp_carrier_name":"APPEL OIL COMPANY","insp_carrier_street":"833 WEST 3RD STREET","insp_carrier_city":"REDFIELD","insp_carrier_state":"SD","insp_carrier_zip_code":"57469","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-01-10T10:34:37.000000Z","updated_at":"2026-01-18T10:31:39.000000Z","inspection_violations":[{"id":17793798,"change_date":"2026-01-07 21:38:00","inspection_id":"86724857","insp_violation_id":"271055360","seq_no":"1","part_no":"107","part_no_section":"620B-HMAMC","insp_viol_unit":"1","insp_unit_id":"210948059","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2026-01-10T10:38:48.000000Z","updated_at":"2026-01-18T10:31:36.000000Z","normalized_code":"107620BHMAMC"},{"id":17793799,"change_date":"2026-01-07 21:38:00","inspection_id":"86724857","insp_violation_id":"271055361","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"210948059","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2026-01-10T10:38:48.000000Z","updated_at":"2026-01-18T10:31:36.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":17745068,"change_date":"2026-01-07 21:38:00","inspection_id":"86724857","insp_unit_id":"210948059","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"1","insp_unit_license":"25836C","insp_unit_license_state":"SD","insp_unit_vehicle_id_number":"2HSFMAMRXXC086392","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-10T10:06:07.000000Z","updated_at":"2026-01-18T10:01:01.000000Z"},{"id":17745069,"change_date":"2026-01-07 21:38:00","inspection_id":"86724857","insp_unit_id":"210948060","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNKNOWN","insp_unit_company":"04","insp_unit_license":"U107938","insp_unit_license_state":"SD","insp_unit_vehicle_id_number":"OMS678610","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-10T10:06:07.000000Z","updated_at":"2026-01-18T10:01:01.000000Z"}]},{"id":10114480,"change_date":"2025-11-04 21:39:00","inspection_id":"86230647","dot_number":"1234537","report_state":"SD","report_number":"0440000472","insp_date":"2025-11-03 00:00:00","insp_start_time":"1417","insp_end_time":"1436","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"ABERDEEN SD","county_code_state":"SD","county_code":"013","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"GROWMARK INC","shipping_paper_number":"0026558","cargo_tank":"406","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-04 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"100000","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":"2498948","transaction_code":"A","transaction_date":"2025-11-04 00:00:00","upload_date":"2025-11-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01234537","upload_search_indicator":null,"census_search_date":"2025-11-04 21:39:00","snet_input_date":"2025-11-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-04 21:39:00","insp_carrier_name":"APPEL OIL COMPANY","insp_carrier_street":"833 WEST 3RD STREET","insp_carrier_city":"REDFIELD","insp_carrier_state":"SD","insp_carrier_zip_code":"57469","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-11-07T10:31:13.000000Z","updated_at":"2025-11-08T10:30:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16821794,"change_date":"2025-11-04 21:39:00","inspection_id":"86230647","insp_unit_id":"209820766","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"726","insp_unit_license":"53719C","insp_unit_license_state":"SD","insp_unit_vehicle_id_number":"1M1PN4NY4TM001087","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-07T10:01:29.000000Z","updated_at":"2025-11-08T10:00:30.000000Z"},{"id":16821795,"change_date":"2025-11-04 21:39:00","inspection_id":"86230647","insp_unit_id":"209820767","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNKNOWN","insp_unit_company":"251","insp_unit_license":"U187456","insp_unit_license_state":"SD","insp_unit_vehicle_id_number":"558MSB448SB008940","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-07T10:01:29.000000Z","updated_at":"2025-11-08T10:00:30.000000Z"}]},{"id":6959255,"change_date":"2024-10-15 21:42:00","inspection_id":"82907485","dot_number":"1234537","report_state":"SD","report_number":"0430000084","insp_date":"2024-10-11 00:00:00","insp_start_time":"0951","insp_end_time":"1025","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"MOUNT VERNON SD","county_code_state":"SD","county_code":"035","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"406","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-15 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":"937173","transaction_code":"A","transaction_date":"2024-10-11 00:00:00","upload_date":"2024-10-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01234537","upload_search_indicator":null,"census_search_date":"2024-10-15 21:42:00","snet_input_date":"2024-10-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-15 21:42:00","insp_carrier_name":"APPEL OIL COMPANY","insp_carrier_street":"833 WEST 3RD STREET","insp_carrier_city":"REDFIELD","insp_carrier_state":"SD","insp_carrier_zip_code":"57469","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:41:04.000000Z","updated_at":"2025-03-17T20:41:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11224594,"change_date":"2024-10-15 21:42:00","inspection_id":"82907485","insp_unit_id":"203410106","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"25835C","insp_unit_license_state":"SD","insp_unit_vehicle_id_number":"1M1AN07Y2EM016119","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:11.000000Z","updated_at":"2025-03-17T23:39:11.000000Z"},{"id":11224595,"change_date":"2024-10-15 21:42:00","inspection_id":"82907485","insp_unit_id":"203410107","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNKNOWN","insp_unit_company":"211","insp_unit_license":"U155441","insp_unit_license_state":"SD","insp_unit_vehicle_id_number":"558MSB441MB006286","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:11.000000Z","updated_at":"2025-03-17T23:39:11.000000Z"}]},{"id":6570994,"change_date":"2024-08-27 21:42:00","inspection_id":"82494195","dot_number":"1234537","report_state":"SD","report_number":"HP18600009","insp_date":"2024-08-27 00:00:00","insp_start_time":"0723","insp_end_time":"0737","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ABERDEEN SD","county_code_state":"SD","county_code":"013","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SUNOCO","shipping_paper_number":"CC49591","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-08-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"100000","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":"788565","transaction_code":"A","transaction_date":"2024-08-27 00:00:00","upload_date":"2024-08-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01234537","upload_search_indicator":null,"census_search_date":"2024-08-27 21:42:00","snet_input_date":"2024-08-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-27 21:42:00","insp_carrier_name":"APPEL OIL COMPANY","insp_carrier_street":"833 WEST 3RD STREET","insp_carrier_city":"REDFIELD","insp_carrier_state":"SD","insp_carrier_zip_code":"57469","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:33:11.000000Z","updated_at":"2025-03-17T20:33:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10593802,"change_date":"2024-08-27 21:42:00","inspection_id":"82494195","insp_unit_id":"202600931","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"25837C","insp_unit_license_state":"SD","insp_unit_vehicle_id_number":"1M1PN4GY1PM011398","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:44.000000Z","updated_at":"2025-03-17T23:32:44.000000Z"},{"id":10593803,"change_date":"2024-08-27 21:42:00","inspection_id":"82494195","insp_unit_id":"202600932","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MACK TRAIL","insp_unit_company":null,"insp_unit_license":"U155441","insp_unit_license_state":"SD","insp_unit_vehicle_id_number":"558MSB441MB006286","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:44.000000Z","updated_at":"2025-03-17T23:32:44.000000Z"}]},{"id":6139388,"change_date":"2024-07-03 21:39:00","inspection_id":"82032507","dot_number":"1234537","report_state":"SD","report_number":"5310000536","insp_date":"2024-07-03 00:00:00","insp_start_time":"1231","insp_end_time":"1255","registration_date":null,"region":"CD","ci_status_code":"C","location":"MM103S","location_desc":"DELL RAPIDS SD","county_code_state":"SD","county_code":"101","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ONEOK HYDROCARBON","shipping_paper_number":"07\/002","cargo_tank":"406","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-07-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"136000","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":"624613","transaction_code":"A","transaction_date":"2024-07-03 00:00:00","upload_date":"2024-07-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01234537","upload_search_indicator":null,"census_search_date":"2024-07-03 21:39:00","snet_input_date":"2024-07-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-03 21:39:00","insp_carrier_name":"APPEL OIL COMPANY","insp_carrier_street":"833 WEST 3RD STREET","insp_carrier_city":"REDFIELD","insp_carrier_state":"SD","insp_carrier_zip_code":"57469","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:24:15.000000Z","updated_at":"2025-03-17T20:24:15.000000Z","inspection_violations":[{"id":9531655,"change_date":"2024-07-03 21:39:00","inspection_id":"82032507","insp_violation_id":"260457139","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201720867","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:52:07.000000Z","updated_at":"2025-03-17T21:52:07.000000Z","normalized_code":"3939A"},{"id":9531656,"change_date":"2024-07-03 21:39:00","inspection_id":"82032507","insp_violation_id":"260457140","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201720867","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:52:07.000000Z","updated_at":"2025-03-17T21:52:07.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":9889053,"change_date":"2024-07-03 21:39:00","inspection_id":"82032507","insp_unit_id":"201720867","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"25835C","insp_unit_license_state":"SD","insp_unit_vehicle_id_number":"1M1AN07Y2EM016119","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:28.000000Z","updated_at":"2025-03-17T23:25:28.000000Z"},{"id":9889054,"change_date":"2024-07-03 21:39:00","inspection_id":"82032507","insp_unit_id":"201720868","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"U124449","insp_unit_license_state":"SD","insp_unit_vehicle_id_number":"558MEBZ4XHB003635","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:28.000000Z","updated_at":"2025-03-17T23:25:28.000000Z"}]},{"id":5981181,"change_date":"2024-06-13 21:41:00","inspection_id":"81862034","dot_number":"1234537","report_state":"SD","report_number":"5310000496","insp_date":"2024-06-13 00:00:00","insp_start_time":"1255","insp_end_time":"1312","registration_date":null,"region":"CD","ci_status_code":"C","location":"MTCHLE","location_desc":"MITCHELL SD","county_code_state":"SD","county_code":"061","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ONEOK HYDROCARBON","shipping_paper_number":"0039922","cargo_tank":"406","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-06-13 21:41: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":"568336","transaction_code":"A","transaction_date":"2024-06-13 00:00:00","upload_date":"2024-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01234537","upload_search_indicator":null,"census_search_date":"2024-06-13 21:41:00","snet_input_date":"2024-06-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-06-13 21:41:00","insp_carrier_name":"APPEL OIL COMPANY","insp_carrier_street":"833 WEST 3RD STREET","insp_carrier_city":"REDFIELD","insp_carrier_state":"SD","insp_carrier_zip_code":"57469","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:21:25.000000Z","updated_at":"2025-03-17T20:21:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9633963,"change_date":"2024-06-13 21:41:00","inspection_id":"81862034","insp_unit_id":"201373693","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"19279V","insp_unit_license_state":"SD","insp_unit_vehicle_id_number":"1M1AJ06Y96N005479","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:51.000000Z","updated_at":"2025-03-17T23:22:51.000000Z"},{"id":9633964,"change_date":"2024-06-13 21:41:00","inspection_id":"81862034","insp_unit_id":"201373694","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MACK TRAIL","insp_unit_company":"211","insp_unit_license":"U124449","insp_unit_license_state":"SD","insp_unit_vehicle_id_number":"558MEBZ4XHB003635","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:51.000000Z","updated_at":"2025-03-17T23:22:51.000000Z"}]},{"id":3935418,"change_date":"2023-09-12 21:40:00","inspection_id":"79621141","dot_number":"1234537","report_state":"SD","report_number":"MCA2104763","insp_date":"2023-09-08 00:00:00","insp_start_time":"1031","insp_end_time":"1109","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"WOLSEY SCALE SITE","county_code_state":"SD","county_code":"005","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"NUSTAR PIPELINE OPERATING PARTNERSHIP L P","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":null,"post_acc_ind":"N","gross_comb_veh_wt":"80000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"651145","transaction_code":"C","transaction_date":"2023-09-12 00:00:00","upload_date":"2023-09-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01234537","upload_search_indicator":"M","census_search_date":"2023-09-12 21:40:00","snet_input_date":"2023-09-08 00:00:00","source_office":"4SDS001","mcmis_add_date":"2023-09-08 21:41:00","insp_carrier_name":"APPEL OIL COMPANY","insp_carrier_street":"833 WEST 3RD STREET","insp_carrier_city":"REDFIELD","insp_carrier_state":"SD","insp_carrier_zip_code":"57469","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:40:29.000000Z","updated_at":"2025-03-17T19:40:29.000000Z","inspection_violations":[{"id":6083088,"change_date":"2023-09-12 21:40:00","inspection_id":"79621141","insp_violation_id":"255222808","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"197017010","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:35:26.000000Z","updated_at":"2025-03-17T21:35:26.000000Z","normalized_code":"3939A"},{"id":6083089,"change_date":"2023-09-12 21:40:00","inspection_id":"79621141","insp_violation_id":"255222809","seq_no":"2","part_no":"393","part_no_section":"75(a)(2)","insp_viol_unit":"1","insp_unit_id":"197017009","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":"WARNING","created_at":"2025-03-17T21:35:26.000000Z","updated_at":"2025-03-17T21:35:26.000000Z","normalized_code":"39375A2"}],"inspection_per_units":[{"id":6328025,"change_date":"2023-09-12 21:40:00","inspection_id":"79621141","insp_unit_id":"197017009","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"IHC","insp_unit_license":"19280V","insp_unit_license_state":"SD","insp_unit_vehicle_id_number":"2HSFMAMRXXC086392","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:09.000000Z","updated_at":"2025-03-17T22:53:09.000000Z"},{"id":6328026,"change_date":"2023-09-12 21:40:00","inspection_id":"79621141","insp_unit_id":"197017010","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":"FRU","insp_unit_license":"U107938","insp_unit_license_state":"SD","insp_unit_vehicle_id_number":"OMS678610","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:09.000000Z","updated_at":"2025-03-17T22:53:09.000000Z"}]},{"id":225930,"change_date":"2022-04-21 21:42:00","inspection_id":"75362585","dot_number":"1234537","report_state":"SD","report_number":"HP17303888","insp_date":"2022-04-11 00:00:00","insp_start_time":"1557","insp_end_time":"1619","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"MITCHELL","county_code_state":"SD","county_code":"035","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"APPEL OIL COMPANY","shipping_paper_number":"002115","cargo_tank":"406","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":"2022-04-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":null,"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":"615275","transaction_code":"A","transaction_date":"2022-04-21 00:00:00","upload_date":"2022-04-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01234537","upload_search_indicator":"M","census_search_date":"2022-04-21 21:42:00","snet_input_date":"2022-04-20 00:00:00","source_office":"4SDS001","mcmis_add_date":"2022-04-21 21:42:00","insp_carrier_name":"APPEL OIL COMPANY","insp_carrier_street":"833 WEST 3RD STREET","insp_carrier_city":"REDFIELD","insp_carrier_state":"SD","insp_carrier_zip_code":"57469","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:31:32.000000Z","updated_at":"2025-03-17T18:31:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":366397,"change_date":"2022-04-21 21:42:00","inspection_id":"75362585","insp_unit_id":"188275444","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"19228V","insp_unit_license_state":"SD","insp_unit_vehicle_id_number":"1M1AN07Y2EM016119","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:28.000000Z","updated_at":"2025-03-17T22:10:28.000000Z"},{"id":366398,"change_date":"2022-04-21 21:42:00","inspection_id":"75362585","insp_unit_id":"188275445","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":null,"insp_unit_license":"U155441","insp_unit_license_state":"SD","insp_unit_vehicle_id_number":"558MSB441MB006286","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:28.000000Z","updated_at":"2025-03-17T22:10:28.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1234537\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1234537\/inspections?page=1","links":[{"url":null,"label":"&laquo; Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1234537\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next &raquo;","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/searchcarriers.com\/company\/1234537\/inspections","per_page":100,"prev_page_url":null,"to":9,"total":9}