{"current_page":1,"data":[{"id":12000556,"change_date":"2026-05-23 21:34:00","inspection_id":"87938992","dot_number":"1468683","report_state":"MI","report_number":"DUBOL00502","insp_date":"2026-05-22 00:00:00","insp_start_time":"1900","insp_end_time":"1935","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"125","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-23 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"3","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3387619","transaction_code":"A","transaction_date":"2026-05-23 00:00:00","upload_date":"2026-05-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01468683","upload_search_indicator":null,"census_search_date":"2026-05-23 21:34:00","snet_input_date":"2026-05-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-23 21:34:00","insp_carrier_name":"SLOAN PETROLEUM TRANSPORT LLC","insp_carrier_street":"50 LAPORTE AVE","insp_carrier_city":"YPSILANTI","insp_carrier_state":"MI","insp_carrier_zip_code":"48198","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-05-26T09:42:15.000000Z","updated_at":"2026-06-03T09:30:08.000000Z","inspection_violations":[{"id":20879513,"change_date":"2026-05-23 21:34:00","inspection_id":"87938992","insp_violation_id":"274460537","seq_no":"1","part_no":"392","part_no_section":"2-SLLML","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-05-26T10:04:16.000000Z","updated_at":"2026-06-03T09:39:42.000000Z","normalized_code":"3922SLLML"},{"id":20879514,"change_date":"2026-05-23 21:34:00","inspection_id":"87938992","insp_violation_id":"274460538","seq_no":"2","part_no":"392","part_no_section":"2-INAT","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-05-26T10:04:16.000000Z","updated_at":"2026-06-03T09:39:42.000000Z","normalized_code":"3922INAT"},{"id":20879515,"change_date":"2026-05-23 21:34:00","inspection_id":"87938992","insp_violation_id":"274460539","seq_no":"3","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-26T10:04:16.000000Z","updated_at":"2026-06-03T09:39:42.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":20861478,"change_date":"2026-05-23 21:34:00","inspection_id":"87938992","insp_unit_id":"213718298","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"4","insp_unit_license":"BE11243","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN4GY0KM005655","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-26T09:20:13.000000Z","updated_at":"2026-06-03T09:01:37.000000Z"},{"id":20861479,"change_date":"2026-05-23 21:34:00","inspection_id":"87938992","insp_unit_id":"213718299","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":null,"insp_unit_license":"E962674","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1H4T04225LL007904","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-26T09:20:13.000000Z","updated_at":"2026-06-03T09:01:37.000000Z"}]},{"id":10599831,"change_date":"2026-01-08 21:40:00","inspection_id":"86739139","dot_number":"1468683","report_state":"MI","report_number":"POWED05632","insp_date":"2026-01-06 00:00:00","insp_start_time":"1155","insp_end_time":"1220","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"NB I-275 @ MICHIGAN AVE","county_code_state":"MI","county_code":"163","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"GEN OIL","shipping_paper_number":"89558","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":null,"final_status_date":"2026-01-08 21:40: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":"1255476","transaction_code":"A","transaction_date":"2026-01-06 00:00:00","upload_date":"2026-01-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01468683","upload_search_indicator":null,"census_search_date":"2026-01-08 21:40:00","snet_input_date":"2026-01-06 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-01-08 21:40:00","insp_carrier_name":"SLOAN PETROLEUM TRANSPORT LLC","insp_carrier_street":"50 LAPORTE AVE","insp_carrier_city":"YPSILANTI","insp_carrier_state":"MI","insp_carrier_zip_code":"48198","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-01-11T10:34:45.000000Z","updated_at":"2026-01-19T10:30:47.000000Z","inspection_violations":[{"id":17819262,"change_date":"2026-01-08 21:40:00","inspection_id":"86739139","insp_violation_id":"271087327","seq_no":"1","part_no":"393","part_no_section":"9A-LTSIR","insp_viol_unit":"1","insp_unit_id":"210978829","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-11T10:39:20.000000Z","updated_at":"2026-01-19T10:31:26.000000Z","normalized_code":"3939ALTSIR"},{"id":17819263,"change_date":"2026-01-08 21:40:00","inspection_id":"86739139","insp_violation_id":"271087328","seq_no":"2","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"2","insp_unit_id":"210978830","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-11T10:39:20.000000Z","updated_at":"2026-01-19T10:31:26.000000Z","normalized_code":"3939ALSLI"}],"inspection_per_units":[{"id":17770498,"change_date":"2026-01-08 21:40:00","inspection_id":"86739139","insp_unit_id":"210978829","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"N\/A","insp_unit_license":"BE45744","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN4GY7LM01537","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-11T10:06:13.000000Z","updated_at":"2026-01-19T10:00:56.000000Z"},{"id":17770499,"change_date":"2026-01-08 21:40:00","inspection_id":"86739139","insp_unit_id":"210978830","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TREMC","insp_unit_company":"N\/A","insp_unit_license":"F269443","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1T9JAAM29TS588034","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-11T10:06:13.000000Z","updated_at":"2026-01-19T10:00:56.000000Z"}]},{"id":10297556,"change_date":"2025-12-04 21:38:00","inspection_id":"86423109","dot_number":"1468683","report_state":"MI","report_number":"POWED05571","insp_date":"2025-11-25 00:00:00","insp_start_time":"1235","insp_end_time":"1320","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"NB I-275 @ US-12","county_code_state":"MI","county_code":"163","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MULTI","shipping_paper_number":"11\/25\/2025","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":"N","pen_cen_match":null,"final_status_date":"2025-11-26 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"1252129","transaction_code":"C","transaction_date":"2025-11-25 00:00:00","upload_date":"2025-12-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01468683","upload_search_indicator":null,"census_search_date":"2025-11-26 21:38:00","snet_input_date":"2025-11-25 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-11-26 21:38:00","insp_carrier_name":"SLOAN PETROLEUM TRANSPORT LLC","insp_carrier_street":"50 LAPORTE AVE","insp_carrier_city":"YPSILANTI","insp_carrier_state":"MI","insp_carrier_zip_code":"48198","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-11-29T10:31:40.000000Z","updated_at":"2025-12-08T10:30:43.000000Z","inspection_violations":[{"id":17323344,"change_date":"2025-12-04 21:38:00","inspection_id":"86423109","insp_violation_id":"270464217","seq_no":"1","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"210416228","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-07T10:32:11.000000Z","updated_at":"2025-12-08T10:31:18.000000Z","normalized_code":"3939ALIL"},{"id":17323345,"change_date":"2025-12-04 21:38:00","inspection_id":"86423109","insp_violation_id":"270464218","seq_no":"2","part_no":"393","part_no_section":"11A1-LIL","insp_viol_unit":"1","insp_unit_id":"210416228","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-07T10:32:11.000000Z","updated_at":"2025-12-08T10:31:18.000000Z","normalized_code":"39311A1LIL"},{"id":17323346,"change_date":"2025-12-04 21:38:00","inspection_id":"86423109","insp_violation_id":"270464219","seq_no":"3","part_no":"107","part_no_section":"620B-HMAMC","insp_viol_unit":"1","insp_unit_id":"210416228","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-07T10:32:11.000000Z","updated_at":"2025-12-08T10:31:18.000000Z","normalized_code":"107620BHMAMC"},{"id":17323347,"change_date":"2025-12-04 21:38:00","inspection_id":"86423109","insp_violation_id":"270464220","seq_no":"4","part_no":"396","part_no_section":"9D2-FTF","insp_viol_unit":"1","insp_unit_id":"210416228","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4620590","created_at":"2025-12-07T10:32:11.000000Z","updated_at":"2025-12-08T10:31:18.000000Z","normalized_code":"3969D2FTF"}],"inspection_per_units":[{"id":17292893,"change_date":"2025-12-04 21:38:00","inspection_id":"86423109","insp_unit_id":"210416228","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"14","insp_unit_license":"BC04337","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN3GY0LM007014","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-07T10:01:28.000000Z","updated_at":"2025-12-08T10:00:52.000000Z"},{"id":17292894,"change_date":"2025-12-04 21:38:00","inspection_id":"86423109","insp_unit_id":"210416229","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"70","insp_unit_license":"E962675","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HLA3A7B7P7H56893","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-07T10:01:28.000000Z","updated_at":"2025-12-08T10:00:52.000000Z"}]},{"id":10200676,"change_date":"2025-12-04 21:38:00","inspection_id":"86321519","dot_number":"1468683","report_state":"MI","report_number":"POWED05546","insp_date":"2025-11-12 00:00:00","insp_start_time":"1645","insp_end_time":"1715","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"NB I-275 @ MICHIGAN AVE","county_code_state":"MI","county_code":"163","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SUNOCO","shipping_paper_number":"381331","cargo_tank":"307","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-11-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"728600","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1250500","transaction_code":"C","transaction_date":"2025-11-12 00:00:00","upload_date":"2025-12-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01468683","upload_search_indicator":null,"census_search_date":"2025-11-14 21:40:00","snet_input_date":"2025-11-12 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-11-14 21:40:00","insp_carrier_name":"SLOAN PETROLEUM TRANSPORT LLC","insp_carrier_street":"50 LAPORTE AVE","insp_carrier_city":"YPSILANTI","insp_carrier_state":"MI","insp_carrier_zip_code":"48198","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-11-17T10:31:27.000000Z","updated_at":"2025-12-08T10:30:32.000000Z","inspection_violations":[{"id":17319952,"change_date":"2025-12-04 21:38:00","inspection_id":"86321519","insp_violation_id":"270463578","seq_no":"1","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"210415657","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-07T10:32:05.000000Z","updated_at":"2025-12-08T10:30:56.000000Z","normalized_code":"3939ALHLI"},{"id":17319953,"change_date":"2025-12-04 21:38:00","inspection_id":"86321519","insp_violation_id":"270463579","seq_no":"2","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"210415657","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-07T10:32:05.000000Z","updated_at":"2025-12-08T10:30:56.000000Z","normalized_code":"3939ALFTSI"},{"id":17319954,"change_date":"2025-12-04 21:38:00","inspection_id":"86321519","insp_violation_id":"270463580","seq_no":"3","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"210415657","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-07T10:32:05.000000Z","updated_at":"2025-12-08T10:30:56.000000Z","normalized_code":"3939ALFTSI"}],"inspection_per_units":[{"id":17290063,"change_date":"2025-12-04 21:38:00","inspection_id":"86321519","insp_unit_id":"210415657","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"N\/A","insp_unit_license":"BE11243","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN4GY0KM005655","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-07T10:01:26.000000Z","updated_at":"2025-12-08T10:00:39.000000Z"},{"id":17290064,"change_date":"2025-12-04 21:38:00","inspection_id":"86321519","insp_unit_id":"210415658","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":"8","insp_unit_license":"E962674","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1H4T04225LL007904","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-07T10:01:26.000000Z","updated_at":"2025-12-08T10:00:39.000000Z"}]},{"id":9583700,"change_date":"2025-09-03 21:40:00","inspection_id":"85672501","dot_number":"1468683","report_state":"MI","report_number":"HARRK01578","insp_date":"2025-09-02 00:00:00","insp_start_time":"0935","insp_end_time":"1030","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB I-94 REST AREA","county_code_state":"MI","county_code":"163","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"BUCKEYE","shipping_paper_number":"1107397","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","viol_total":"3","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1238779","transaction_code":"A","transaction_date":"2025-09-02 00:00:00","upload_date":"2025-09-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01468683","upload_search_indicator":null,"census_search_date":"2025-09-03 21:40:00","snet_input_date":"2025-09-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-09-03 21:40:00","insp_carrier_name":"SLOAN PETROLEUM TRANSPORT LLC","insp_carrier_street":"50 LAPORTE AVE","insp_carrier_city":"YPSILANTI","insp_carrier_state":"MI","insp_carrier_zip_code":"48198","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-09-06T10:43:30.000000Z","updated_at":"2025-09-10T10:44:55.000000Z","inspection_violations":[{"id":18475702,"change_date":null,"inspection_id":"85672501","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"207F-SLAS","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"393207FSLAS"}],"inspection_per_units":[{"id":15821513,"change_date":"2025-09-03 21:40:00","inspection_id":"85672501","insp_unit_id":"208730168","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"1","insp_unit_license":"BD89553","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HSDJAPR9EN070577","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:47:36.000000Z","updated_at":"2025-09-09T09:47:36.000000Z"},{"id":15821514,"change_date":"2025-09-03 21:40:00","inspection_id":"85672501","insp_unit_id":"208730169","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CUAS","insp_unit_company":"67","insp_unit_license":"E717752","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1C9A1B2B1TS001267","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:47:36.000000Z","updated_at":"2025-09-09T09:47:36.000000Z"}]},{"id":8978200,"change_date":"2025-06-25 21:39:00","inspection_id":"85035949","dot_number":"1468683","report_state":"US","report_number":"1997000051","insp_date":"2025-06-24 00:00:00","insp_start_time":"1015","insp_end_time":"1110","registration_date":null,"region":"ED","ci_status_code":"C","location":"3","location_desc":"BELLEVILLE MI","county_code_state":"MI","county_code":"163","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"ENERGY TRANSFER","shipping_paper_number":"553340","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":"2025-06-25 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"6","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1911027","transaction_code":"A","transaction_date":"2025-06-25 00:00:00","upload_date":"2025-06-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01468683","upload_search_indicator":null,"census_search_date":"2025-06-25 21:39:00","snet_input_date":"2025-06-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-25 21:39:00","insp_carrier_name":"SLOAN PETROLEUM TRANSPORT LLC","insp_carrier_street":"50 LAPORTE AVE","insp_carrier_city":"YPSILANTI","insp_carrier_state":"MI","insp_carrier_zip_code":"48198","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-06-28T10:01:01.000000Z","updated_at":"2025-06-30T10:00:17.000000Z","inspection_violations":[{"id":14431172,"change_date":"2025-06-25 21:39:00","inspection_id":"85035949","insp_violation_id":"267029598","seq_no":"1","part_no":"393","part_no_section":"48A-BIBD","insp_viol_unit":"2","insp_unit_id":"207540846","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-28T10:16:49.000000Z","updated_at":"2025-06-29T10:15:28.000000Z","normalized_code":"39348ABIBD"},{"id":14431173,"change_date":"2025-06-25 21:39:00","inspection_id":"85035949","insp_violation_id":"267029599","seq_no":"2","part_no":"173","part_no_section":"24B1-HMBPMC","insp_viol_unit":"2","insp_unit_id":"207540846","insp_violation_category_id":"37","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-06-28T10:16:49.000000Z","updated_at":"2025-06-29T10:15:28.000000Z","normalized_code":"17324B1HMBPMC"},{"id":14431174,"change_date":"2025-06-25 21:39:00","inspection_id":"85035949","insp_violation_id":"267029600","seq_no":"3","part_no":"107","part_no_section":"620B-HMAMC","insp_viol_unit":"1","insp_unit_id":"207540845","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-28T10:16:49.000000Z","updated_at":"2025-06-29T10:15:28.000000Z","normalized_code":"107620BHMAMC"},{"id":14431175,"change_date":"2025-06-25 21:39:00","inspection_id":"85035949","insp_violation_id":"267029601","seq_no":"4","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"207540845","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-28T10:16:49.000000Z","updated_at":"2025-06-29T10:15:28.000000Z","normalized_code":"39347E"},{"id":14431176,"change_date":"2025-06-25 21:39:00","inspection_id":"85035949","insp_violation_id":"267029602","seq_no":"5","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"1","insp_unit_id":"207540845","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-28T10:16:49.000000Z","updated_at":"2025-06-29T10:15:28.000000Z","normalized_code":"39353BB"},{"id":14431177,"change_date":"2025-06-25 21:39:00","inspection_id":"85035949","insp_violation_id":"267029603","seq_no":"6","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"1","insp_unit_id":"207540845","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-06-28T10:16:49.000000Z","updated_at":"2025-06-29T10:15:28.000000Z","normalized_code":"3963A1BOS"}],"inspection_per_units":[{"id":14720939,"change_date":"2025-06-25 21:39:00","inspection_id":"85035949","insp_unit_id":"207540845","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"14","insp_unit_license":"BC04337","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN3GY0LM007014","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-28T09:46:10.000000Z","updated_at":"2025-06-29T09:45:26.000000Z"},{"id":14720940,"change_date":"2025-06-25 21:39:00","inspection_id":"85035949","insp_unit_id":"207540846","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL CO.,","insp_unit_company":"70","insp_unit_license":"E962675","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HLA3A7B7P7H56893","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-28T09:46:10.000000Z","updated_at":"2025-06-29T09:45:26.000000Z"}]},{"id":8978201,"change_date":"2025-06-25 21:39:00","inspection_id":"85035950","dot_number":"1468683","report_state":"US","report_number":"1997000052","insp_date":"2025-06-24 00:00:00","insp_start_time":"1115","insp_end_time":"1150","registration_date":null,"region":"ED","ci_status_code":"C","location":"3","location_desc":"BELLEVILLE MI","county_code_state":"MI","county_code":"163","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MPLX TERMINALS LLC","shipping_paper_number":"334563659","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-06-25 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"1911026","transaction_code":"A","transaction_date":"2025-06-25 00:00:00","upload_date":"2025-06-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01468683","upload_search_indicator":null,"census_search_date":"2025-06-25 21:39:00","snet_input_date":"2025-06-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-25 21:39:00","insp_carrier_name":"SLOAN PETROLEUM TRANSPORT LLC","insp_carrier_street":"50 LAPORTE AVE","insp_carrier_city":"YPSILANTI","insp_carrier_state":"MI","insp_carrier_zip_code":"48198","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-06-28T10:01:01.000000Z","updated_at":"2025-06-30T10:00:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14720941,"change_date":"2025-06-25 21:39:00","inspection_id":"85035950","insp_unit_id":"207540847","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"NONE","insp_unit_license":"BD89553","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HSDJAPR9EN070577","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-28T09:46:10.000000Z","updated_at":"2025-06-29T09:45:26.000000Z"},{"id":14720942,"change_date":"2025-06-25 21:39:00","inspection_id":"85035950","insp_unit_id":"207540848","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CUSTOM ASS","insp_unit_company":"67","insp_unit_license":"E717752","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1C9A1B2B1TS001267","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-28T09:46:10.000000Z","updated_at":"2025-06-29T09:45:26.000000Z"}]},{"id":8200977,"change_date":"2025-03-25 12:44:00","inspection_id":"84215319","dot_number":"1468683","report_state":"MI","report_number":"BALLB05084","insp_date":"2025-03-24 00:00:00","insp_start_time":"1420","insp_end_time":"1505","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"GRATIOT @ MCNICHOLS","county_code_state":"MI","county_code":"163","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MPLX TERMINALS","shipping_paper_number":"20250317","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":"N","pen_cen_match":null,"final_status_date":"2025-03-25 12:44:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1214772","transaction_code":"A","transaction_date":"2025-03-24 00:00:00","upload_date":"2025-03-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01468683","upload_search_indicator":null,"census_search_date":"2025-03-25 12:44:00","snet_input_date":"2025-03-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-03-25 12:44:00","insp_carrier_name":"SLOAN PETROLEUM TRANSPORT LLC","insp_carrier_street":"50 LAPORTE AVE","insp_carrier_city":"YPSILANTI","insp_carrier_state":"MI","insp_carrier_zip_code":"48198","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-28T10:14:46.000000Z","updated_at":"2025-03-29T10:19:28.000000Z","inspection_violations":[{"id":12859623,"change_date":"2025-03-25 12:44:00","inspection_id":"84215319","insp_violation_id":"265233023","seq_no":"1","part_no":"392","part_no_section":"2-SLLSOA","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4475188","created_at":"2025-03-28T10:32:03.000000Z","updated_at":"2025-03-28T10:47:54.000000Z","normalized_code":"3922SLLSOA"},{"id":12859624,"change_date":"2025-03-25 12:44:00","inspection_id":"84215319","insp_violation_id":"265233024","seq_no":"2","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"205970987","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-28T10:32:03.000000Z","updated_at":"2025-03-28T10:47:54.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":13258893,"change_date":"2025-03-25 12:44:00","inspection_id":"84215319","insp_unit_id":"205970986","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"14","insp_unit_license":"BC04337","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN3GY0LM007014","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-28T10:04:52.000000Z","updated_at":"2025-03-29T09:57:28.000000Z"},{"id":13258894,"change_date":"2025-03-25 12:44:00","inspection_id":"84215319","insp_unit_id":"205970987","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"70","insp_unit_license":"E962675","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HLA3A7B7P7H56893","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-28T10:04:52.000000Z","updated_at":"2025-03-29T09:57:28.000000Z"}]},{"id":6658501,"change_date":"2024-09-17 21:45:00","inspection_id":"82587503","dot_number":"1468683","report_state":"MI","report_number":"LOPEL01680","insp_date":"2024-09-04 00:00:00","insp_start_time":"1245","insp_end_time":"1315","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB I-94 @ MIDDLEBELT RD","county_code_state":"MI","county_code":"163","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SHELL OIL CO","shipping_paper_number":"10688355","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-05 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"100000","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":"1193577","transaction_code":"C","transaction_date":"2024-09-04 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01468683","upload_search_indicator":null,"census_search_date":"2024-09-05 21:43:00","snet_input_date":"2024-09-04 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-09-05 21:43:00","insp_carrier_name":"SLOAN PETROLEUM TRANSPORT LLC","insp_carrier_street":"50 LAPORTE AVE","insp_carrier_city":"YPSILANTI","insp_carrier_state":"MI","insp_carrier_zip_code":"48198","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:34:54.000000Z","updated_at":"2025-03-17T20:34:54.000000Z","inspection_violations":[{"id":10361135,"change_date":"2024-09-17 21:45:00","inspection_id":"82587503","insp_violation_id":"261867626","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"202981676","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:13.000000Z","updated_at":"2025-03-17T21:56:13.000000Z","normalized_code":"3922"},{"id":10361136,"change_date":"2024-09-17 21:45:00","inspection_id":"82587503","insp_violation_id":"261867627","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202981675","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:13.000000Z","updated_at":"2025-03-17T21:56:13.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":10735379,"change_date":"2024-09-17 21:45:00","inspection_id":"82587503","insp_unit_id":"202981675","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"BB85275","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN4GY7KM007919","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:11.000000Z","updated_at":"2025-03-17T23:34:11.000000Z"},{"id":10735380,"change_date":"2024-09-17 21:45:00","inspection_id":"82587503","insp_unit_id":"202981676","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CUAS","insp_unit_company":"01","insp_unit_license":"D191934","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1C9A1A2B4JS001075","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:11.000000Z","updated_at":"2025-03-17T23:34:11.000000Z"}]},{"id":6152546,"change_date":"2024-07-05 21:36:00","inspection_id":"82046591","dot_number":"1468683","report_state":"MI","report_number":"RAMSB01940","insp_date":"2024-07-05 00:00:00","insp_start_time":"0745","insp_end_time":"0920","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I94 WB AT BELLEVILLE RD","county_code_state":"MI","county_code":"163","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"PBF HOLDING COMPANY LLC","shipping_paper_number":"523573","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":"2024-07-05 21:36:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"9","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1184880","transaction_code":"A","transaction_date":"2024-07-05 00:00:00","upload_date":"2024-07-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01468683","upload_search_indicator":null,"census_search_date":"2024-07-05 21:36:00","snet_input_date":"2024-07-05 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-07-05 21:36:00","insp_carrier_name":"SLOAN PETROLEUM TRANSPORT LLC","insp_carrier_street":"50 LAPORTE AVE","insp_carrier_city":"YPSILANTI","insp_carrier_state":"MI","insp_carrier_zip_code":"48198","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:24:37.000000Z","updated_at":"2025-03-17T20:24:37.000000Z","inspection_violations":[{"id":9548756,"change_date":"2024-07-05 21:36:00","inspection_id":"82046591","insp_violation_id":"260481307","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4390968","created_at":"2025-03-17T21:52:13.000000Z","updated_at":"2025-03-17T21:52:13.000000Z","normalized_code":"3922"},{"id":9548757,"change_date":"2024-07-05 21:36:00","inspection_id":"82046591","insp_violation_id":"260481308","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201747063","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:13.000000Z","updated_at":"2025-03-17T21:52:13.000000Z","normalized_code":"3922"},{"id":9548758,"change_date":"2024-07-05 21:36:00","inspection_id":"82046591","insp_violation_id":"260481309","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"201747063","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:13.000000Z","updated_at":"2025-03-17T21:52:13.000000Z","normalized_code":"39617C"},{"id":9548759,"change_date":"2024-07-05 21:36:00","inspection_id":"82046591","insp_violation_id":"260481310","seq_no":"4","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"201747063","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:13.000000Z","updated_at":"2025-03-17T21:52:13.000000Z","normalized_code":"39395F"},{"id":9548760,"change_date":"2024-07-05 21:36:00","inspection_id":"82046591","insp_violation_id":"260481311","seq_no":"5","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"201747063","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:13.000000Z","updated_at":"2025-03-17T21:52:13.000000Z","normalized_code":"39347E"},{"id":9548761,"change_date":"2024-07-05 21:36:00","inspection_id":"82046591","insp_violation_id":"260481312","seq_no":"6","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"201747063","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:13.000000Z","updated_at":"2025-03-17T21:52:13.000000Z","normalized_code":"39353B"},{"id":9548762,"change_date":"2024-07-05 21:36:00","inspection_id":"82046591","insp_violation_id":"260481313","seq_no":"7","part_no":"393","part_no_section":"43(a)","insp_viol_unit":"1","insp_unit_id":"201747063","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4390968","created_at":"2025-03-17T21:52:13.000000Z","updated_at":"2025-03-17T21:52:13.000000Z","normalized_code":"39343A"},{"id":9548763,"change_date":"2024-07-05 21:36:00","inspection_id":"82046591","insp_violation_id":"260481314","seq_no":"8","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"201747064","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4390968","created_at":"2025-03-17T21:52:13.000000Z","updated_at":"2025-03-17T21:52:13.000000Z","normalized_code":"3922"},{"id":9548764,"change_date":"2024-07-05 21:36:00","inspection_id":"82046591","insp_violation_id":"260481315","seq_no":"9","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"201747064","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:13.000000Z","updated_at":"2025-03-17T21:52:13.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":9910634,"change_date":"2024-07-05 21:36:00","inspection_id":"82046591","insp_unit_id":"201747063","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"14","insp_unit_license":"BC04337","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN3GY0LM007014","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:45.000000Z","updated_at":"2025-03-17T23:25:45.000000Z"},{"id":9910635,"change_date":"2024-07-05 21:36:00","inspection_id":"82046591","insp_unit_id":"201747064","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"70","insp_unit_license":"C449679","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HLA3A7B7P7H56893","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:45.000000Z","updated_at":"2025-03-17T23:25:45.000000Z"}]},{"id":5543901,"change_date":"2024-04-18 21:40:00","inspection_id":"81386934","dot_number":"1468683","report_state":"MI","report_number":"POWED04706","insp_date":"2024-04-17 00:00:00","insp_start_time":"1710","insp_end_time":"1740","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SB I-275 @ MICHIGAN AVE","county_code_state":"MI","county_code":"163","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SHELL OIL","shipping_paper_number":"10672532","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":null,"final_status_date":"2024-04-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"1174211","transaction_code":"A","transaction_date":"2024-04-17 00:00:00","upload_date":"2024-04-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01468683","upload_search_indicator":null,"census_search_date":"2024-04-18 21:40:00","snet_input_date":"2024-04-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-04-18 21:40:00","insp_carrier_name":"SLOAN PETROLEUM TRANSPORT LLC","insp_carrier_street":"50 LAPORTE AVE","insp_carrier_city":"YPSILANTI","insp_carrier_state":"MI","insp_carrier_zip_code":"48198","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:12:43.000000Z","updated_at":"2025-03-17T20:12:43.000000Z","inspection_violations":[{"id":8566533,"change_date":"2024-04-18 21:40:00","inspection_id":"81386934","insp_violation_id":"259009765","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200466621","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:31.000000Z","updated_at":"2025-03-17T21:47:31.000000Z","normalized_code":"3939A"},{"id":8566534,"change_date":"2024-04-18 21:40:00","inspection_id":"81386934","insp_violation_id":"259009766","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200466621","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:31.000000Z","updated_at":"2025-03-17T21:47:31.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":8930249,"change_date":"2024-04-18 21:40:00","inspection_id":"81386934","insp_unit_id":"200466621","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"N\/Q","insp_unit_license":"BC76918","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HSDJAPR9EN070577","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:07.000000Z","updated_at":"2025-03-17T23:16:07.000000Z"},{"id":8930250,"change_date":"2024-04-18 21:40:00","inspection_id":"81386934","insp_unit_id":"200466622","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CUAS","insp_unit_company":"N\/A","insp_unit_license":"E717752","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1C9A1B2B1TS001267","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:07.000000Z","updated_at":"2025-03-17T23:16:07.000000Z"}]},{"id":5499657,"change_date":"2024-04-12 21:40:00","inspection_id":"81338674","dot_number":"1468683","report_state":"MI","report_number":"LOPEL01558","insp_date":"2024-04-11 00:00:00","insp_start_time":"1520","insp_end_time":"1600","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WICK RD @ ECORSE RD","county_code_state":"MI","county_code":"163","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"PBF HOLDING","shipping_paper_number":"370171","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":"N","pen_cen_match":null,"final_status_date":"2024-04-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"100000","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":"1173379","transaction_code":"A","transaction_date":"2024-04-11 00:00:00","upload_date":"2024-04-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01468683","upload_search_indicator":null,"census_search_date":"2024-04-12 21:40:00","snet_input_date":"2024-04-11 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-04-12 21:40:00","insp_carrier_name":"SLOAN PETROLEUM TRANSPORT LLC","insp_carrier_street":"50 LAPORTE AVE","insp_carrier_city":"YPSILANTI","insp_carrier_state":"MI","insp_carrier_zip_code":"48198","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:11:35.000000Z","updated_at":"2025-03-17T20:11:35.000000Z","inspection_violations":[{"id":8494669,"change_date":"2024-04-12 21:40:00","inspection_id":"81338674","insp_violation_id":"258903499","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200373603","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:08.000000Z","updated_at":"2025-03-17T21:47:08.000000Z","normalized_code":"3939A"},{"id":8494670,"change_date":"2024-04-12 21:40:00","inspection_id":"81338674","insp_violation_id":"258903500","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"200373604","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:08.000000Z","updated_at":"2025-03-17T21:47:08.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":8858909,"change_date":"2024-04-12 21:40:00","inspection_id":"81338674","insp_unit_id":"200373603","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"19","insp_unit_license":"BB85275","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN4GY7KM007919","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:24.000000Z","updated_at":"2025-03-17T23:15:24.000000Z"},{"id":8858910,"change_date":"2024-04-12 21:40:00","inspection_id":"81338674","insp_unit_id":"200373604","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"70","insp_unit_license":"C449679","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HLA3A7B7P7H56893","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:24.000000Z","updated_at":"2025-03-17T23:15:24.000000Z"}]},{"id":4803004,"change_date":"2024-01-10 21:44:00","inspection_id":"80577813","dot_number":"1468683","report_state":"MI","report_number":"LITTJ04803","insp_date":"2024-01-09 00:00:00","insp_start_time":"1150","insp_end_time":"1210","registration_date":null,"region":"ET","ci_status_code":"C","location":"210R3","location_desc":"BELLEVILLE REST AREA","county_code_state":"MI","county_code":"163","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"ETP","shipping_paper_number":"508165","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":null,"final_status_date":"2024-01-10 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","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":"1160140","transaction_code":"A","transaction_date":"2024-01-09 00:00:00","upload_date":"2024-01-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01468683","upload_search_indicator":null,"census_search_date":"2024-01-10 21:44:00","snet_input_date":"2024-01-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-01-10 21:44:00","insp_carrier_name":"SLOAN PETROLEUM TRANSPORT LLC","insp_carrier_street":"50 LAPORTE AVE","insp_carrier_city":"YPSILANTI","insp_carrier_state":"MI","insp_carrier_zip_code":"48198","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:58:00.000000Z","updated_at":"2025-03-17T19:58:00.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7727617,"change_date":"2024-01-10 21:44:00","inspection_id":"80577813","insp_unit_id":"198898589","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"19","insp_unit_license":"BB85275","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN4GY7KM007919","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:03.000000Z","updated_at":"2025-03-17T23:05:03.000000Z"},{"id":7727618,"change_date":"2024-01-10 21:44:00","inspection_id":"80577813","insp_unit_id":"198898590","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LBT","insp_unit_company":"20","insp_unit_license":"E717775","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4J8T04322TT025901","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:03.000000Z","updated_at":"2025-03-17T23:05:03.000000Z"}]},{"id":4125189,"change_date":"2023-10-04 21:41:00","inspection_id":"79832062","dot_number":"1468683","report_state":"MI","report_number":"LOPEL01429","insp_date":"2023-10-03 00:00:00","insp_start_time":"1410","insp_end_time":"1445","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB I-94 @ VINING RD","county_code_state":"MI","county_code":"163","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"BUCKEYE","shipping_paper_number":"648782","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"103000","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":"1148398","transaction_code":"A","transaction_date":"2023-10-03 00:00:00","upload_date":"2023-10-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01468683","upload_search_indicator":null,"census_search_date":"2023-10-04 21:41:00","snet_input_date":"2023-10-03 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-10-04 21:41:00","insp_carrier_name":"SLOAN PETROLEUM TRANSPORT LLC","insp_carrier_street":"50 LAPORTE AVE","insp_carrier_city":"YPSILANTI","insp_carrier_state":"MI","insp_carrier_zip_code":"48198","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:44:26.000000Z","updated_at":"2025-03-17T19:44:26.000000Z","inspection_violations":[{"id":6384094,"change_date":"2023-10-04 21:41:00","inspection_id":"79832062","insp_violation_id":"255656381","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197396783","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:47.000000Z","updated_at":"2025-03-17T21:36:47.000000Z","normalized_code":"3939A"},{"id":6384095,"change_date":"2023-10-04 21:41:00","inspection_id":"79832062","insp_violation_id":"255656382","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"197396784","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:47.000000Z","updated_at":"2025-03-17T21:36:47.000000Z","normalized_code":"3939A"},{"id":6384096,"change_date":"2023-10-04 21:41:00","inspection_id":"79832062","insp_violation_id":"255656383","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"197396784","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:47.000000Z","updated_at":"2025-03-17T21:36:47.000000Z","normalized_code":"3922"},{"id":6384097,"change_date":"2023-10-04 21:41:00","inspection_id":"79832062","insp_violation_id":"255656384","seq_no":"4","part_no":"107","part_no_section":"620(b)","insp_viol_unit":"1","insp_unit_id":"197396783","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:47.000000Z","updated_at":"2025-03-17T21:36:47.000000Z","normalized_code":"107620B"}],"inspection_per_units":[{"id":6632566,"change_date":"2023-10-04 21:41:00","inspection_id":"79832062","insp_unit_id":"197396783","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"BC04337","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN3GY0LM007014","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:38.000000Z","updated_at":"2025-03-17T22:55:38.000000Z"},{"id":6632567,"change_date":"2023-10-04 21:41:00","inspection_id":"79832062","insp_unit_id":"197396784","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"70","insp_unit_license":"C449679","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HLA3A7B7P7H56893","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:38.000000Z","updated_at":"2025-03-17T22:55:38.000000Z"}]},{"id":2709079,"change_date":"2023-03-31 21:41:00","inspection_id":"78241349","dot_number":"1468683","report_state":"MI","report_number":"POWED04118","insp_date":"2023-03-30 00:00:00","insp_start_time":"1940","insp_end_time":"2005","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"EB I-94 @ TELEGRAPH","county_code_state":"MI","county_code":"163","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"HIGHPOINT","shipping_paper_number":"481567","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":null,"final_status_date":"2023-03-31 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"164000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1120209","transaction_code":"A","transaction_date":"2023-03-30 00:00:00","upload_date":"2023-03-31 00:00:00","upload_first_byte":"0","upload_dot_number":"01468683","upload_search_indicator":null,"census_search_date":"2023-03-31 21:41:00","snet_input_date":"2023-03-30 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-03-31 21:41:00","insp_carrier_name":"SLOAN PETROLEUM TRANSPORT LLC","insp_carrier_street":"50 LAPORTE AVE","insp_carrier_city":"YPSILANTI","insp_carrier_state":"MI","insp_carrier_zip_code":"48198","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:16:36.000000Z","updated_at":"2025-03-17T19:16:36.000000Z","inspection_violations":[{"id":4160924,"change_date":"2023-03-31 21:41:00","inspection_id":"78241349","insp_violation_id":"251987877","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194171138","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:31.000000Z","updated_at":"2025-03-17T21:26:31.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":4359806,"change_date":"2023-03-31 21:41:00","inspection_id":"78241349","insp_unit_id":"194171138","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"N\/A","insp_unit_license":"BC04337","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN3GY0LM007014","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:19.000000Z","updated_at":"2025-03-17T22:37:19.000000Z"},{"id":4359807,"change_date":"2023-03-31 21:41:00","inspection_id":"78241349","insp_unit_id":"194171139","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LBT","insp_unit_company":"1728","insp_unit_license":"D956868","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1H4T04225LL007904","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:19.000000Z","updated_at":"2025-03-17T22:37:19.000000Z"}]},{"id":2436080,"change_date":"2023-02-23 21:40:00","inspection_id":"77930291","dot_number":"1468683","report_state":"MI","report_number":"LITTJ04347","insp_date":"2023-02-22 00:00:00","insp_start_time":"1225","insp_end_time":"1250","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-94 W\/B @ BELLEVILLE","county_code_state":"MI","county_code":"163","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"HIGH POINTE","shipping_paper_number":"334311509","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":"N","pen_cen_match":null,"final_status_date":"2023-02-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"162000","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1114711","transaction_code":"A","transaction_date":"2023-02-22 00:00:00","upload_date":"2023-02-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01468683","upload_search_indicator":null,"census_search_date":"2023-02-23 21:40:00","snet_input_date":"2023-02-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-02-23 21:40:00","insp_carrier_name":"SLOAN PETROLEUM TRANSPORT LLC","insp_carrier_street":"50 LAPORTE AVE","insp_carrier_city":"YPSILANTI","insp_carrier_state":"MI","insp_carrier_zip_code":"48198","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:11:28.000000Z","updated_at":"2025-03-17T19:11:28.000000Z","inspection_violations":[{"id":3750505,"change_date":"2023-02-23 21:40:00","inspection_id":"77930291","insp_violation_id":"251302462","seq_no":"1","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"193549109","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:40.000000Z","updated_at":"2025-03-17T21:24:40.000000Z","normalized_code":"39375C"},{"id":3750506,"change_date":"2023-02-23 21:40:00","inspection_id":"77930291","insp_violation_id":"251302463","seq_no":"2","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"193549109","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:40.000000Z","updated_at":"2025-03-17T21:24:40.000000Z","normalized_code":"39375C"},{"id":3750507,"change_date":"2023-02-23 21:40:00","inspection_id":"77930291","insp_violation_id":"251302464","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193549109","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:40.000000Z","updated_at":"2025-03-17T21:24:40.000000Z","normalized_code":"3939A"},{"id":3750508,"change_date":"2023-02-23 21:40:00","inspection_id":"77930291","insp_violation_id":"251302465","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"193549110","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:40.000000Z","updated_at":"2025-03-17T21:24:40.000000Z","normalized_code":"3939A"},{"id":3750509,"change_date":"2023-02-23 21:40:00","inspection_id":"77930291","insp_violation_id":"251302466","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"193549110","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:40.000000Z","updated_at":"2025-03-17T21:24:40.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":3920561,"change_date":"2023-02-23 21:40:00","inspection_id":"77930291","insp_unit_id":"193549109","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"NONE","insp_unit_license":"BC04337","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN3GY0LM007014","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:05.000000Z","updated_at":"2025-03-17T22:34:05.000000Z"},{"id":3920562,"change_date":"2023-02-23 21:40:00","inspection_id":"77930291","insp_unit_id":"193549110","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LBT","insp_unit_company":"1728","insp_unit_license":"D956868","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1H4T04225LL007904","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:05.000000Z","updated_at":"2025-03-17T22:34:05.000000Z"}]},{"id":2337421,"change_date":"2023-02-10 21:40:00","inspection_id":"77817443","dot_number":"1468683","report_state":"MI","report_number":"LOPEL01235","insp_date":"2023-02-08 00:00:00","insp_start_time":"1910","insp_end_time":"1950","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB I-94 @ MIDDLEBELT RD","county_code_state":"MI","county_code":"163","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"HIGH POINTE OIL","shipping_paper_number":"334306703","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":"N","pen_cen_match":null,"final_status_date":"2023-02-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"101000","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1112859","transaction_code":"C","transaction_date":"2023-02-08 00:00:00","upload_date":"2023-02-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01468683","upload_search_indicator":null,"census_search_date":"2023-02-09 21:40:00","snet_input_date":"2023-02-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-02-09 21:40:00","insp_carrier_name":"SLOAN PETROLEUM TRANSPORT LLC","insp_carrier_street":"50 LAPORTE AVE","insp_carrier_city":"YPSILANTI","insp_carrier_state":"MI","insp_carrier_zip_code":"48198","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:09:40.000000Z","updated_at":"2025-03-17T19:09:40.000000Z","inspection_violations":[{"id":3600496,"change_date":"2023-02-10 21:40:00","inspection_id":"77817443","insp_violation_id":"251069976","seq_no":"1","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"193341644","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:00.000000Z","updated_at":"2025-03-17T21:24:00.000000Z","normalized_code":"39345D"},{"id":3600497,"change_date":"2023-02-10 21:40:00","inspection_id":"77817443","insp_violation_id":"251069977","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"193341645","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:00.000000Z","updated_at":"2025-03-17T21:24:00.000000Z","normalized_code":"3922"},{"id":3600498,"change_date":"2023-02-10 21:40:00","inspection_id":"77817443","insp_violation_id":"251069978","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"193341645","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:00.000000Z","updated_at":"2025-03-17T21:24:00.000000Z","normalized_code":"3939A"},{"id":3600499,"change_date":"2023-02-10 21:40:00","inspection_id":"77817443","insp_violation_id":"251069979","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"193341645","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:00.000000Z","updated_at":"2025-03-17T21:24:00.000000Z","normalized_code":"3939A"},{"id":3600500,"change_date":"2023-02-10 21:40:00","inspection_id":"77817443","insp_violation_id":"251069980","seq_no":"5","part_no":"396","part_no_section":"9(d)(2)","insp_viol_unit":"1","insp_unit_id":"193341644","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:00.000000Z","updated_at":"2025-03-17T21:24:00.000000Z","normalized_code":"3969D2"}],"inspection_per_units":[{"id":3761064,"change_date":"2023-02-10 21:40:00","inspection_id":"77817443","insp_unit_id":"193341644","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"19","insp_unit_license":"BB85275","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN4GY7KM007919","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:57.000000Z","updated_at":"2025-03-17T22:32:57.000000Z"},{"id":3761065,"change_date":"2023-02-10 21:40:00","inspection_id":"77817443","insp_unit_id":"193341645","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"477","insp_unit_license":"C449679","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HLA3A7B7P7H56893","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:57.000000Z","updated_at":"2025-03-17T22:32:57.000000Z"}]},{"id":2244004,"change_date":"2023-01-31 21:43:00","inspection_id":"77711378","dot_number":"1468683","report_state":"MI","report_number":"HADZM03476","insp_date":"2023-01-26 00:00:00","insp_start_time":"1650","insp_end_time":"1720","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"EB I-96 @ I-75","county_code_state":"MI","county_code":"163","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"BUCKEYE","shipping_paper_number":"630625","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"1111121","transaction_code":"C","transaction_date":"2023-01-26 00:00:00","upload_date":"2023-01-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01468683","upload_search_indicator":null,"census_search_date":"2023-01-27 21:41:00","snet_input_date":"2023-01-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-01-27 21:41:00","insp_carrier_name":"SLOAN PETROLEUM TRANSPORT LLC","insp_carrier_street":"50 LAPORTE AVE","insp_carrier_city":"YPSILANTI","insp_carrier_state":"MI","insp_carrier_zip_code":"48198","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:06.000000Z","updated_at":"2025-03-17T19:08:06.000000Z","inspection_violations":[{"id":3465527,"change_date":"2023-01-31 21:43:00","inspection_id":"77711378","insp_violation_id":"250871431","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:23:23.000000Z","updated_at":"2025-03-17T21:23:23.000000Z","normalized_code":"3922"},{"id":3465528,"change_date":"2023-01-31 21:43:00","inspection_id":"77711378","insp_violation_id":"250871432","seq_no":"2","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"193155109","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:23.000000Z","updated_at":"2025-03-17T21:23:23.000000Z","normalized_code":"39345D"},{"id":3465529,"change_date":"2023-01-31 21:43:00","inspection_id":"77711378","insp_violation_id":"250871433","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"193155110","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:23.000000Z","updated_at":"2025-03-17T21:23:23.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3611763,"change_date":"2023-01-31 21:43:00","inspection_id":"77711378","insp_unit_id":"193155109","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"19","insp_unit_license":"BB85275","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN4GY7KM007919","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:54.000000Z","updated_at":"2025-03-17T22:31:54.000000Z"},{"id":3611764,"change_date":"2023-01-31 21:43:00","inspection_id":"77711378","insp_unit_id":"193155110","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"477","insp_unit_license":"C449679","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HLA3A7B7P7H56893","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:54.000000Z","updated_at":"2025-03-17T22:31:54.000000Z"}]},{"id":1842851,"change_date":"2022-11-30 21:40:00","inspection_id":"77252208","dot_number":"1468683","report_state":"MI","report_number":"LOPEL01164","insp_date":"2022-11-29 00:00:00","insp_start_time":"1850","insp_end_time":"1935","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB I-94 @ MIDDLEBELT RD","county_code_state":"MI","county_code":"163","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MARATHON","shipping_paper_number":"334283788","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":"N","pen_cen_match":null,"final_status_date":"2022-11-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"103000","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1103710","transaction_code":"A","transaction_date":"2022-11-29 00:00:00","upload_date":"2022-11-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01468683","upload_search_indicator":null,"census_search_date":"2022-11-30 21:40:00","snet_input_date":"2022-11-29 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-11-30 21:40:00","insp_carrier_name":"SLOAN PETROLEUM TRANSPORT LLC","insp_carrier_street":"50 LAPORTE AVE","insp_carrier_city":"YPSILANTI","insp_carrier_state":"MI","insp_carrier_zip_code":"48198","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:00:42.000000Z","updated_at":"2025-03-17T19:00:42.000000Z","inspection_violations":[{"id":2874379,"change_date":"2022-11-30 21:40:00","inspection_id":"77252208","insp_violation_id":"249850570","seq_no":"1","part_no":"107","part_no_section":"620(b)","insp_viol_unit":"1","insp_unit_id":"192192711","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:39.000000Z","updated_at":"2025-03-17T21:20:39.000000Z","normalized_code":"107620B"},{"id":2874380,"change_date":"2022-11-30 21:40:00","inspection_id":"77252208","insp_violation_id":"249850571","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"192192712","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:20:39.000000Z","updated_at":"2025-03-17T21:20:39.000000Z","normalized_code":"3939A"},{"id":2874381,"change_date":"2022-11-30 21:40:00","inspection_id":"77252208","insp_violation_id":"249850572","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"192192712","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:39.000000Z","updated_at":"2025-03-17T21:20:39.000000Z","normalized_code":"3939A"},{"id":2874382,"change_date":"2022-11-30 21:40:00","inspection_id":"77252208","insp_violation_id":"249850573","seq_no":"4","part_no":"393","part_no_section":"75(a)(1)","insp_viol_unit":"2","insp_unit_id":"192192712","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:39.000000Z","updated_at":"2025-03-17T21:20:39.000000Z","normalized_code":"39375A1"},{"id":2874383,"change_date":"2022-11-30 21:40:00","inspection_id":"77252208","insp_violation_id":"249850574","seq_no":"5","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"192192712","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:39.000000Z","updated_at":"2025-03-17T21:20:39.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":2965041,"change_date":"2022-11-30 21:40:00","inspection_id":"77252208","insp_unit_id":"192192711","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"19","insp_unit_license":"BB85275","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN4GY7KM007919","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:18.000000Z","updated_at":"2025-03-17T22:27:18.000000Z"},{"id":2965042,"change_date":"2022-11-30 21:40:00","inspection_id":"77252208","insp_unit_id":"192192712","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LBT","insp_unit_company":"1728","insp_unit_license":"D956868","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1H4T04225LL007904","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:18.000000Z","updated_at":"2025-03-17T22:27:18.000000Z"}]},{"id":1572648,"change_date":"2022-10-21 21:39:00","inspection_id":"76942442","dot_number":"1468683","report_state":"MI","report_number":"LOPEL01099","insp_date":"2022-10-20 00:00:00","insp_start_time":"1400","insp_end_time":"1445","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB I-94 @ MIDDLEBELT RD","county_code_state":"MI","county_code":"163","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"PBF HOLDING","shipping_paper_number":"359070","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":"N","pen_cen_match":null,"final_status_date":"2022-10-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"105000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1098988","transaction_code":"A","transaction_date":"2022-10-20 00:00:00","upload_date":"2022-10-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01468683","upload_search_indicator":null,"census_search_date":"2022-10-21 21:39:00","snet_input_date":"2022-10-20 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-10-21 21:39:00","insp_carrier_name":"SLOAN PETROLEUM TRANSPORT LLC","insp_carrier_street":"50 LAPORTE AVE","insp_carrier_city":"YPSILANTI","insp_carrier_state":"MI","insp_carrier_zip_code":"48198","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:55:36.000000Z","updated_at":"2025-03-17T18:55:36.000000Z","inspection_violations":[{"id":2472554,"change_date":"2022-10-21 21:39:00","inspection_id":"76942442","insp_violation_id":"249178505","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191576289","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:34.000000Z","updated_at":"2025-03-17T21:18:34.000000Z","normalized_code":"3939A"},{"id":2472555,"change_date":"2022-10-21 21:39:00","inspection_id":"76942442","insp_violation_id":"249178506","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191576289","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:34.000000Z","updated_at":"2025-03-17T21:18:34.000000Z","normalized_code":"3939A"},{"id":2472556,"change_date":"2022-10-21 21:39:00","inspection_id":"76942442","insp_violation_id":"249178507","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191576289","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:34.000000Z","updated_at":"2025-03-17T21:18:34.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":2531005,"change_date":"2022-10-21 21:39:00","inspection_id":"76942442","insp_unit_id":"191576289","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"351055","insp_unit_license":"BC76918","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HSDJAPR9EN070577","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:21.000000Z","updated_at":"2025-03-17T22:24:21.000000Z"},{"id":2531006,"change_date":"2022-10-21 21:39:00","inspection_id":"76942442","insp_unit_id":"191576290","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"182","insp_unit_license":"D958793","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1PMA24420H1008182","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:21.000000Z","updated_at":"2025-03-17T22:24:21.000000Z"}]},{"id":1170197,"change_date":"2022-08-30 21:40:00","inspection_id":"76476104","dot_number":"1468683","report_state":"MI","report_number":"LOPEL01048","insp_date":"2022-08-29 00:00:00","insp_start_time":"1815","insp_end_time":"1900","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB I-94 @ MIDDLEBELT RD","county_code_state":"MI","county_code":"163","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MPLX TERMINALS","shipping_paper_number":"334254213","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"104000","viol_total":"3","oos_total":"2","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1092194","transaction_code":"A","transaction_date":"2022-08-29 00:00:00","upload_date":"2022-08-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01468683","upload_search_indicator":null,"census_search_date":"2022-08-30 21:40:00","snet_input_date":"2022-08-29 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-08-30 21:40:00","insp_carrier_name":"SLOAN PETROLEUM TRANSPORT LLC","insp_carrier_street":"50 LAPORTE AVE","insp_carrier_city":"YPSILANTI","insp_carrier_state":"MI","insp_carrier_zip_code":"48198","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:48:18.000000Z","updated_at":"2025-03-17T18:48:18.000000Z","inspection_violations":[{"id":1854808,"change_date":"2022-08-30 21:40:00","inspection_id":"76476104","insp_violation_id":"248094593","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:34.000000Z","updated_at":"2025-03-17T21:15:34.000000Z","normalized_code":"3922"},{"id":1854809,"change_date":"2022-08-30 21:40:00","inspection_id":"76476104","insp_violation_id":"248094594","seq_no":"2","part_no":"383","part_no_section":"93(b)(3)","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:34.000000Z","updated_at":"2025-03-17T21:15:34.000000Z","normalized_code":"38393B3"},{"id":1854810,"change_date":"2022-08-30 21:40:00","inspection_id":"76476104","insp_violation_id":"248094595","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190622786","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:15:34.000000Z","updated_at":"2025-03-17T21:15:34.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":1881820,"change_date":"2022-08-30 21:40:00","inspection_id":"76476104","insp_unit_id":"190622786","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"BC04337","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN3GY0LM007014","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:57.000000Z","updated_at":"2025-03-17T22:19:57.000000Z"},{"id":1881821,"change_date":"2022-08-30 21:40:00","inspection_id":"76476104","insp_unit_id":"190622787","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"477","insp_unit_license":"C449679","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HLA3A7B7P7H56893","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:57.000000Z","updated_at":"2025-03-17T22:19:57.000000Z"}]},{"id":573415,"change_date":"2022-06-09 21:42:00","inspection_id":"75776138","dot_number":"1468683","report_state":"MI","report_number":"POWED03700","insp_date":"2022-06-06 00:00:00","insp_start_time":"1205","insp_end_time":"1235","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB I-94 @ SOUTHFIELD","county_code_state":"MI","county_code":"163","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1079061","transaction_code":"A","transaction_date":"2022-06-06 00:00:00","upload_date":"2022-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01468683","upload_search_indicator":null,"census_search_date":"2022-06-09 21:42:00","snet_input_date":"2022-06-06 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-06-09 21:42:00","insp_carrier_name":"SLOAN PETROLEUM TRANSPORT LLC","insp_carrier_street":"50 LAPORTE AVE","insp_carrier_city":"YPSILANTI","insp_carrier_state":"MI","insp_carrier_zip_code":"48198","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:37:47.000000Z","updated_at":"2025-03-17T18:37:47.000000Z","inspection_violations":[{"id":896944,"change_date":"2022-06-09 21:42:00","inspection_id":"75776138","insp_violation_id":"246327207","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"189140496","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:12.000000Z","updated_at":"2025-03-17T21:11:12.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":922133,"change_date":"2022-06-09 21:42:00","inspection_id":"75776138","insp_unit_id":"189140496","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"19","insp_unit_license":"BB85275","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN4GY7KM007919","insp_unit_decal":"Y","insp_unit_decal_number":"31293161","created_at":"2025-03-17T22:13:53.000000Z","updated_at":"2025-03-17T22:13:53.000000Z"}]},{"id":395277,"change_date":"2022-06-09 21:42:00","inspection_id":"75564765","dot_number":"1468683","report_state":"MI","report_number":"LITTJ03983","insp_date":"2022-05-13 00:00:00","insp_start_time":"1435","insp_end_time":"1500","registration_date":null,"region":"ET","ci_status_code":"C","location":"210R3","location_desc":"BELLEVILLE REST AREA","county_code_state":"MI","county_code":"163","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"S\/C","shipping_paper_number":"452954","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":"N","pen_cen_match":null,"final_status_date":"2022-05-16 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1075563","transaction_code":"C","transaction_date":"2022-05-13 00:00:00","upload_date":"2022-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01468683","upload_search_indicator":null,"census_search_date":"2022-05-16 21:43:00","snet_input_date":"2022-05-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-05-16 21:43:00","insp_carrier_name":"SLOAN PETROLEUM TRANSPORT LLC","insp_carrier_street":"50 LAPORTE AVE","insp_carrier_city":"YPSILANTI","insp_carrier_state":"MI","insp_carrier_zip_code":"48198","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:34:27.000000Z","updated_at":"2025-03-17T18:34:27.000000Z","inspection_violations":[{"id":617150,"change_date":"2022-06-09 21:42:00","inspection_id":"75564765","insp_violation_id":"246337197","seq_no":"1","part_no":"180","part_no_section":"405(c)","insp_viol_unit":"2","insp_unit_id":"189148289","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:54.000000Z","updated_at":"2025-03-17T21:09:54.000000Z","normalized_code":"180405C"}],"inspection_per_units":[{"id":638663,"change_date":"2022-06-09 21:42:00","inspection_id":"75564765","insp_unit_id":"189148288","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"19","insp_unit_license":"BB85275","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN4GY7KM007919","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:06.000000Z","updated_at":"2025-03-17T22:12:06.000000Z"},{"id":638664,"change_date":"2022-06-09 21:42:00","inspection_id":"75564765","insp_unit_id":"189148289","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"7","insp_unit_license":"C449679","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HLA3A7B7P7H56893","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:06.000000Z","updated_at":"2025-03-17T22:12:06.000000Z"}]},{"id":278312,"change_date":"2022-06-09 21:42:00","inspection_id":"75425098","dot_number":"1468683","report_state":"MI","report_number":"LOPEL00820","insp_date":"2022-04-27 00:00:00","insp_start_time":"1850","insp_end_time":"1925","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB I-94 @ MIDDLEBELT RD","county_code_state":"MI","county_code":"163","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"EXXON MOBIL","shipping_paper_number":"612366","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-28 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"103000","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":"1073803","transaction_code":"C","transaction_date":"2022-04-27 00:00:00","upload_date":"2022-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01468683","upload_search_indicator":null,"census_search_date":"2022-04-28 21:39:00","snet_input_date":"2022-04-27 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-04-28 21:39:00","insp_carrier_name":"SLOAN PETROLEUM TRANSPORT LLC","insp_carrier_street":"50 LAPORTE AVE","insp_carrier_city":"YPSILANTI","insp_carrier_state":"MI","insp_carrier_zip_code":"48198","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:32:17.000000Z","updated_at":"2025-03-17T18:32:17.000000Z","inspection_violations":[{"id":431165,"change_date":"2022-06-09 21:42:00","inspection_id":"75425098","insp_violation_id":"246337249","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:05.000000Z","updated_at":"2025-03-17T21:09:05.000000Z","normalized_code":"39216A"},{"id":431166,"change_date":"2022-06-09 21:42:00","inspection_id":"75425098","insp_violation_id":"246337250","seq_no":"2","part_no":"107","part_no_section":"620(b)","insp_viol_unit":"1","insp_unit_id":"189148311","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:05.000000Z","updated_at":"2025-03-17T21:09:05.000000Z","normalized_code":"107620B"},{"id":431167,"change_date":"2022-06-09 21:42:00","inspection_id":"75425098","insp_violation_id":"246337251","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189148311","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:05.000000Z","updated_at":"2025-03-17T21:09:05.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":450654,"change_date":"2022-06-09 21:42:00","inspection_id":"75425098","insp_unit_id":"189148311","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"11","insp_unit_license":"BC33046","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HSDJSJR9DH177426","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:59.000000Z","updated_at":"2025-03-17T22:10:59.000000Z"},{"id":450655,"change_date":"2022-06-09 21:42:00","inspection_id":"75425098","insp_unit_id":"189148312","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LBT","insp_unit_company":"1728","insp_unit_license":"D956868","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1H4T04225LL007904","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:59.000000Z","updated_at":"2025-03-17T22:10:59.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1468683\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1468683\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1468683\/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\/1468683\/inspections","per_page":100,"prev_page_url":null,"to":24,"total":24}