{"current_page":1,"data":[{"id":12246438,"change_date":"2026-06-22 21:39:00","inspection_id":"88204631","dot_number":"753725","report_state":"MI","report_number":"HOLLM04989","insp_date":"2026-06-22 00:00:00","insp_start_time":"0740","insp_end_time":"0803","registration_date":null,"region":"ES","ci_status_code":"C","location":"132","location_desc":"MI","county_code_state":"MI","county_code":"075","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"334667541","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":"U","pen_cen_match":"I","final_status_date":"2026-06-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"156000","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":"3592600","transaction_code":"A","transaction_date":"2026-06-22 00:00:00","upload_date":"2026-06-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00753725","upload_search_indicator":null,"census_search_date":"2026-06-22 21:39:00","snet_input_date":"2026-06-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-22 21:39:00","insp_carrier_name":"ROYAL GAS & OIL CO","insp_carrier_street":"1710 HILTON ROAD","insp_carrier_city":"FERNDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48220","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-25T09:38:43.000000Z","updated_at":"2026-07-03T09:30:28.000000Z","inspection_violations":[{"id":21315825,"change_date":"2026-06-22 21:39:00","inspection_id":"88204631","insp_violation_id":"275045581","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-25T09:55:47.000000Z","updated_at":"2026-07-03T09:42:11.000000Z","normalized_code":"3922SLLEWA1"},{"id":21315826,"change_date":"2026-06-22 21:39:00","inspection_id":"88204631","insp_violation_id":"275045582","seq_no":"2","part_no":"393","part_no_section":"9A-LTSIR","insp_viol_unit":"1","insp_unit_id":"214216462","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-25T09:55:47.000000Z","updated_at":"2026-07-03T09:42:11.000000Z","normalized_code":"3939ALTSIR"},{"id":21315827,"change_date":"2026-06-22 21:39:00","inspection_id":"88204631","insp_violation_id":"275045583","seq_no":"3","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"1","insp_unit_id":"214216462","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-25T09:55:47.000000Z","updated_at":"2026-07-03T09:42:11.000000Z","normalized_code":"3939ALSLI"}],"inspection_per_units":[{"id":21267081,"change_date":"2026-06-22 21:39:00","inspection_id":"88204631","insp_unit_id":"214216462","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"RC32648","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN4GY8RM045220","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-25T09:16:02.000000Z","updated_at":"2026-07-05T09:01:17.000000Z"},{"id":21267082,"change_date":"2026-06-22 21:39:00","inspection_id":"88204631","insp_unit_id":"214216463","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCOA","insp_unit_company":null,"insp_unit_license":"E715002","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"558MEBT61GK003001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-25T09:16:02.000000Z","updated_at":"2026-07-05T09:01:17.000000Z"}]},{"id":11909056,"change_date":"2026-05-14 21:42:00","inspection_id":"87848232","dot_number":"753725","report_state":"MI","report_number":"REBIM99398","insp_date":"2026-05-14 00:00:00","insp_start_time":"1130","insp_end_time":"1236","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"049","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"BP PRODUCTS NORTH AMERICA","shipping_paper_number":"0001157098","cargo_tank":"OTH","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"164600","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":"3324204","transaction_code":"A","transaction_date":"2026-05-14 00:00:00","upload_date":"2026-05-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00753725","upload_search_indicator":null,"census_search_date":"2026-05-14 21:42:00","snet_input_date":"2026-05-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-14 21:42:00","insp_carrier_name":"ROYAL GAS & OIL CO","insp_carrier_street":"1710 HILTON ROAD","insp_carrier_city":"FERNDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48220","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-16T13:32:54.000000Z","updated_at":"2026-05-25T09:31:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20703442,"change_date":"2026-05-14 21:42:00","inspection_id":"87848232","insp_unit_id":"213552438","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"RC32648","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN4GY8RM045220","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-16T12:44:51.000000Z","updated_at":"2026-05-25T09:03:57.000000Z"},{"id":20703443,"change_date":"2026-05-14 21:42:00","inspection_id":"87848232","insp_unit_id":"213552439","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCOA","insp_unit_company":null,"insp_unit_license":"E715002","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"558MEBT61GK003001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-16T12:44:51.000000Z","updated_at":"2026-05-25T09:03:57.000000Z"}]},{"id":11744795,"change_date":"2026-04-24 21:41:00","inspection_id":"87674242","dot_number":"753725","report_state":"MI","report_number":"HOLLM04877","insp_date":"2026-04-21 00:00:00","insp_start_time":"1035","insp_end_time":"1110","registration_date":null,"region":"ET","ci_status_code":"C","location":"132","location_desc":"I-94 W\/B GRASS LAKE SCALE","county_code_state":"MI","county_code":"075","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"334647985","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":"2026-04-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"156000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1267464","transaction_code":"A","transaction_date":"2026-04-21 00:00:00","upload_date":"2026-04-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00753725","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-04-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-04-24 21:41:00","insp_carrier_name":"ROYAL GAS & OIL CO","insp_carrier_street":"1710 HILTON ROAD","insp_carrier_city":"FERNDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48220","insp_colonia":null,"docket_number":"341009","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:42:35.000000Z","updated_at":"2026-05-05T09:31:36.000000Z","inspection_violations":[{"id":20419325,"change_date":"2026-04-24 21:41:00","inspection_id":"87674242","insp_violation_id":"273837614","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T10:06:50.000000Z","updated_at":"2026-05-05T09:44:39.000000Z","normalized_code":"3922SLLEWA1"}],"inspection_per_units":[{"id":20435018,"change_date":"2026-04-24 21:41:00","inspection_id":"87674242","insp_unit_id":"213210094","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"RC32648","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN4GY8RM045220","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:21:36.000000Z","updated_at":"2026-05-05T09:04:37.000000Z"},{"id":20435019,"change_date":"2026-04-24 21:41:00","inspection_id":"87674242","insp_unit_id":"213210095","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":null,"insp_unit_license":"E715002","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"558MEBT61GK003001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:21:36.000000Z","updated_at":"2026-05-05T09:04:37.000000Z"}]},{"id":11652607,"change_date":"2026-04-15 21:39:00","inspection_id":"87582160","dot_number":"753725","report_state":"OH","report_number":"3217000381","insp_date":"2026-04-13 00:00:00","insp_start_time":"1130","insp_end_time":"1222","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"BOWLING GREEN OH","county_code_state":"OH","county_code":"173","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MPLX TERMINALS","shipping_paper_number":"20260409","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-04-15 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"104000","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":"3157365","transaction_code":"A","transaction_date":"2026-04-14 00:00:00","upload_date":"2026-04-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00753725","upload_search_indicator":null,"census_search_date":"2026-04-15 21:39:00","snet_input_date":"2026-04-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-15 21:39:00","insp_carrier_name":"ROYAL GAS & OIL CO","insp_carrier_street":"1710 HILTON ROAD","insp_carrier_city":"FERNDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48220","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-26T09:30:33.000000Z","updated_at":"2026-04-26T09:30:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20269583,"change_date":"2026-04-15 21:39:00","inspection_id":"87582160","insp_unit_id":"213026723","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"45222","insp_unit_license":"RC32647","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN4GY1RM045222","insp_unit_decal":"Y","insp_unit_decal_number":"36291504","created_at":"2026-04-26T09:03:03.000000Z","updated_at":"2026-04-26T09:03:03.000000Z"},{"id":20269584,"change_date":"2026-04-15 21:39:00","inspection_id":"87582160","insp_unit_id":"213026724","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL CO.,","insp_unit_company":"71037","insp_unit_license":"E715001","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5HTAM432727H66510","insp_unit_decal":"Y","insp_unit_decal_number":"36291505","created_at":"2026-04-26T09:03:03.000000Z","updated_at":"2026-04-26T09:03:03.000000Z"}]},{"id":11461144,"change_date":"2026-03-24 21:39:00","inspection_id":"87379133","dot_number":"753725","report_state":"OH","report_number":"3272001678","insp_date":"2026-03-23 00:00:00","insp_start_time":"0632","insp_end_time":"0655","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MILAN OH","county_code_state":"OH","county_code":"043","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"BP PRODUCTS NORTH AMERICA","shipping_paper_number":"100982","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-03-24 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3057027","transaction_code":"A","transaction_date":"2026-03-24 00:00:00","upload_date":"2026-03-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00753725","upload_search_indicator":null,"census_search_date":"2026-03-24 21:39:00","snet_input_date":"2026-03-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-24 21:39:00","insp_carrier_name":"ROYAL GAS & OIL CO","insp_carrier_street":"1710 HILTON ROAD","insp_carrier_city":"FERNDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48220","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-27T09:45:13.000000Z","updated_at":"2026-04-04T09:30:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19630333,"change_date":"2026-03-24 21:39:00","inspection_id":"87379133","insp_unit_id":"212301129","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"49502","insp_unit_license":"RC38125","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN4GY8SM049502","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-27T09:22:55.000000Z","updated_at":"2026-04-04T09:03:46.000000Z"},{"id":19630334,"change_date":"2026-03-24 21:39:00","inspection_id":"87379133","insp_unit_id":"212301130","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLAR MFG.","insp_unit_company":"2024","insp_unit_license":"F062677","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1PMKA4427S7174257","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-27T09:22:55.000000Z","updated_at":"2026-04-04T09:03:46.000000Z"}]},{"id":10812914,"change_date":"2026-02-04 21:39:00","inspection_id":"86840109","dot_number":"753725","report_state":"MI","report_number":"WILLD04095","insp_date":"2026-01-16 00:00:00","insp_start_time":"1115","insp_end_time":"1150","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"FORT & SCHAEFER","county_code_state":"MI","county_code":"163","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-01-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"104000","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":"1256759","transaction_code":"C","transaction_date":"2026-01-16 00:00:00","upload_date":"2026-01-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00753725","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-01-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-01-20 21:40:00","insp_carrier_name":"ROYAL GAS & OIL CO","insp_carrier_street":"1710 HILTON ROAD","insp_carrier_city":"FERNDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48220","insp_colonia":null,"docket_number":"341009","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-23T10:36:26.000000Z","updated_at":"2026-02-15T10:30:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18369438,"change_date":"2026-02-04 21:39:00","inspection_id":"86840109","insp_unit_id":"211440360","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"RB70248","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN4GY6SM049501","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-07T10:10:58.000000Z","updated_at":"2026-02-15T10:04:50.000000Z"},{"id":18369439,"change_date":"2026-02-04 21:39:00","inspection_id":"86840109","insp_unit_id":"211440361","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":null,"insp_unit_license":"E714995","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5HTAB486777L69692","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-07T10:10:58.000000Z","updated_at":"2026-02-15T10:04:50.000000Z"}]},{"id":9450699,"change_date":"2025-08-19 21:40:00","inspection_id":"85532877","dot_number":"753725","report_state":"MI","report_number":"POWEL04002","insp_date":"2025-08-18 00:00:00","insp_start_time":"0830","insp_end_time":"0910","registration_date":null,"region":"ET","ci_status_code":"C","location":"122","location_desc":"FOWLERVILLE SCALE W\/B","county_code_state":"MI","county_code":"093","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"BUCKEYE TERMINALS","shipping_paper_number":"1104539","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-08-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"157200","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1236941","transaction_code":"A","transaction_date":"2025-08-18 00:00:00","upload_date":"2025-08-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00753725","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-08-18 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-08-19 21:40:00","insp_carrier_name":"ROYAL GAS & OIL CO","insp_carrier_street":"1710 HILTON ROAD","insp_carrier_city":"FERNDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48220","insp_colonia":null,"docket_number":"341009","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-23T10:46:30.000000Z","updated_at":"2025-08-23T10:46:30.000000Z","inspection_violations":[{"id":15390122,"change_date":"2025-08-19 21:40:00","inspection_id":"85532877","insp_violation_id":"268118590","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-22T10:45:00.000000Z","updated_at":"2025-08-23T10:48:20.000000Z","normalized_code":"3922SLLEWA1"}],"inspection_per_units":[{"id":15583726,"change_date":"2025-08-19 21:40:00","inspection_id":"85532877","insp_unit_id":"208472527","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"45220","insp_unit_license":"RC32648","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN4GY8RM045220","insp_unit_decal":"Y","insp_unit_decal_number":"35457113","created_at":"2025-08-22T09:46:42.000000Z","updated_at":"2025-08-23T09:46:07.000000Z"},{"id":15583727,"change_date":"2025-08-19 21:40:00","inspection_id":"85532877","insp_unit_id":"208472528","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"3016","insp_unit_license":"E715002","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"558MEBT61GK003001","insp_unit_decal":"Y","insp_unit_decal_number":"35457112","created_at":"2025-08-22T09:46:42.000000Z","updated_at":"2025-08-23T09:46:07.000000Z"}]},{"id":8979660,"change_date":"2025-06-25 21:39:00","inspection_id":"85037489","dot_number":"753725","report_state":"US","report_number":"1997000057","insp_date":"2025-06-25 00:00:00","insp_start_time":"1120","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":"EXXON MOBIL","shipping_paper_number":"38987","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":"172600","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":"1913061","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":"00753725","upload_search_indicator":null,"census_search_date":"2025-06-25 21:39:00","snet_input_date":"2025-06-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-25 21:39:00","insp_carrier_name":"ROYAL GAS & OIL CO","insp_carrier_street":"1710 HILTON ROAD","insp_carrier_city":"FERNDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48220","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-28T10:01:02.000000Z","updated_at":"2025-06-30T10:00:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14723401,"change_date":"2025-06-25 21:39:00","inspection_id":"85037489","insp_unit_id":"207543761","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"54202","insp_unit_license":"RC25765","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN4GYXSM054202","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-28T09:46:12.000000Z","updated_at":"2025-06-29T09:45:35.000000Z"},{"id":14723402,"change_date":"2025-06-25 21:39:00","inspection_id":"85037489","insp_unit_id":"207543762","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLAR MFG.","insp_unit_company":"2025","insp_unit_license":"F175013","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1PMKA4669S7174258","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-28T09:46:12.000000Z","updated_at":"2025-06-29T09:45:35.000000Z"}]},{"id":8338038,"change_date":"2025-04-10 21:41:00","inspection_id":"84359442","dot_number":"753725","report_state":"OH","report_number":"3217000126","insp_date":"2025-04-09 00:00:00","insp_start_time":"0706","insp_end_time":"0726","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"TOLEDO OH","county_code_state":"OH","county_code":"095","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MLX TERMINALS","shipping_paper_number":"20250406","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-04-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1576161","transaction_code":"A","transaction_date":"2025-04-10 00:00:00","upload_date":"2025-04-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00753725","upload_search_indicator":null,"census_search_date":"2025-04-10 21:41:00","snet_input_date":"2025-04-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-10 21:41:00","insp_carrier_name":"ROYAL GAS & OIL CO","insp_carrier_street":"1710 HILTON ROAD","insp_carrier_city":"FERNDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48220","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-14T10:27:59.000000Z","updated_at":"2025-04-14T10:27:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13526230,"change_date":"2025-04-10 21:41:00","inspection_id":"84359442","insp_unit_id":"206238175","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"49502","insp_unit_license":"RC38125","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN4GY8SM049502","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-13T10:10:24.000000Z","updated_at":"2025-04-14T09:53:42.000000Z"},{"id":13526231,"change_date":"2025-04-10 21:41:00","inspection_id":"84359442","insp_unit_id":"206238176","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLAR MFG.","insp_unit_company":"2024","insp_unit_license":"F062677","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1PMKA4427S7174257","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-13T10:10:24.000000Z","updated_at":"2025-04-14T09:53:42.000000Z"}]},{"id":7488817,"change_date":"2024-12-23 21:39:00","inspection_id":"83467114","dot_number":"753725","report_state":"MI","report_number":"SAHIW02487","insp_date":"2024-12-22 00:00:00","insp_start_time":"1900","insp_end_time":"2000","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"NB-I-75 @ W GRAND BLVD","county_code_state":"MI","county_code":"163","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"BP","shipping_paper_number":"0001058032","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"4","oos_total":"3","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1205136","transaction_code":"A","transaction_date":"2024-12-22 00:00:00","upload_date":"2024-12-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00753725","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-12-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-12-23 21:39:00","insp_carrier_name":"ROYAL GAS & OIL CO","insp_carrier_street":"1710 HILTON ROAD","insp_carrier_city":"FERNDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48220","insp_colonia":null,"docket_number":"341009","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:52:19.000000Z","updated_at":"2025-03-17T20:52:19.000000Z","inspection_violations":[{"id":11707188,"change_date":"2024-12-23 21:39:00","inspection_id":"83467114","insp_violation_id":"263637232","seq_no":"1","part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"X4468889","created_at":"2025-03-17T22:03:02.000000Z","updated_at":"2025-03-17T22:03:02.000000Z","normalized_code":"38323A2LCDLN"},{"id":11707189,"change_date":"2024-12-23 21:39:00","inspection_id":"83467114","insp_violation_id":"263637233","seq_no":"2","part_no":"391","part_no_section":"45A-MCEM","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4468889","created_at":"2025-03-17T22:03:02.000000Z","updated_at":"2025-03-17T22:03:02.000000Z","normalized_code":"39145AMCEM"},{"id":11707190,"change_date":"2024-12-23 21:39:00","inspection_id":"83467114","insp_violation_id":"263637234","seq_no":"3","part_no":"393","part_no_section":"47A-BSF","insp_viol_unit":"2","insp_unit_id":"204535247","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"WARNING","created_at":"2025-03-17T22:03:02.000000Z","updated_at":"2025-03-17T22:03:02.000000Z","normalized_code":"39347ABSF"},{"id":11707191,"change_date":"2024-12-23 21:39:00","inspection_id":"83467114","insp_violation_id":"263637235","seq_no":"4","part_no":"393","part_no_section":"47A-BSF","insp_viol_unit":"2","insp_unit_id":"204535247","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"WARNING","created_at":"2025-03-17T22:03:02.000000Z","updated_at":"2025-03-17T22:03:02.000000Z","normalized_code":"39347ABSF"}],"inspection_per_units":[{"id":12081808,"change_date":"2024-12-23 21:39:00","inspection_id":"83467114","insp_unit_id":"204535246","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"RC32648","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN4GY8RM045220","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:25.000000Z","updated_at":"2025-03-17T23:48:25.000000Z"},{"id":12081809,"change_date":"2024-12-23 21:39:00","inspection_id":"83467114","insp_unit_id":"204535247","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":null,"insp_unit_license":"E715002","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"558MEBT61GK003001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:25.000000Z","updated_at":"2025-03-17T23:48:25.000000Z"}]},{"id":5929748,"change_date":"2024-06-06 21:41:00","inspection_id":"81806199","dot_number":"753725","report_state":"MI","report_number":"FELDW00307","insp_date":"2024-06-03 00:00:00","insp_start_time":"0725","insp_end_time":"0810","registration_date":null,"region":"ET","ci_status_code":"C","location":"132","location_desc":"GRASS LAKE SCALE W\/B","county_code_state":"MI","county_code":"075","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"US ENERGY DISTRIBUTION","shipping_paper_number":"10678337","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":"2024-06-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"156350","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":"1180874","transaction_code":"A","transaction_date":"2024-06-03 00:00:00","upload_date":"2024-06-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00753725","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-06-03 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-06-06 21:41:00","insp_carrier_name":"ROYAL GAS & OIL CO","insp_carrier_street":"1710 HILTON ROAD","insp_carrier_city":"FERNDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48220","insp_colonia":null,"docket_number":"341009","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:20:15.000000Z","updated_at":"2025-03-17T20:20:15.000000Z","inspection_violations":[{"id":9195361,"change_date":"2024-06-06 21:41:00","inspection_id":"81806199","insp_violation_id":"259942882","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201268560","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:26.000000Z","updated_at":"2025-03-17T21:50:26.000000Z","normalized_code":"3922"},{"id":9195362,"change_date":"2024-06-06 21:41:00","inspection_id":"81806199","insp_violation_id":"259942883","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"201268561","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:26.000000Z","updated_at":"2025-03-17T21:50:26.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9550957,"change_date":"2024-06-06 21:41:00","inspection_id":"81806199","insp_unit_id":"201268560","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"BLUE","insp_unit_license":"RC32648","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN4GY8RM045220","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:04.000000Z","updated_at":"2025-03-17T23:22:04.000000Z"},{"id":9550958,"change_date":"2024-06-06 21:41:00","inspection_id":"81806199","insp_unit_id":"201268561","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":null,"insp_unit_license":"E715002","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"558MEBT61GK003001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:04.000000Z","updated_at":"2025-03-17T23:22:04.000000Z"}]},{"id":5114488,"change_date":"2024-02-22 21:43:00","inspection_id":"80918402","dot_number":"753725","report_state":"MI","report_number":"POWED04609","insp_date":"2024-02-21 00:00:00","insp_start_time":"1925","insp_end_time":"1955","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"NB 275 ANN ARBOR RD","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":"2\/21\/2024","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-02-22 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"1166025","transaction_code":"A","transaction_date":"2024-02-21 00:00:00","upload_date":"2024-02-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00753725","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-02-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-22 21:43:00","insp_carrier_name":"ROYAL GAS & OIL CO","insp_carrier_street":"1710 HILTON ROAD","insp_carrier_city":"FERNDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48220","insp_colonia":null,"docket_number":"341009","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:03:51.000000Z","updated_at":"2025-03-17T20:03:51.000000Z","inspection_violations":[{"id":7886694,"change_date":"2024-02-22 21:43:00","inspection_id":"80918402","insp_violation_id":"257985547","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199554700","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:07.000000Z","updated_at":"2025-03-17T21:44:07.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":8234169,"change_date":"2024-02-22 21:43:00","inspection_id":"80918402","insp_unit_id":"199554700","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"15374","insp_unit_license":"RC01201","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN4GY7LM015374","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:37.000000Z","updated_at":"2025-03-17T23:09:37.000000Z"},{"id":8234170,"change_date":"2024-02-22 21:43:00","inspection_id":"80918402","insp_unit_id":"199554701","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLR","insp_unit_company":"2014","insp_unit_license":"E715003","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1PMA24769F5013255","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:37.000000Z","updated_at":"2025-03-17T23:09:37.000000Z"}]},{"id":5063388,"change_date":"2024-02-15 21:42:00","inspection_id":"80862654","dot_number":"753725","report_state":"MI","report_number":"DAWDD03331","insp_date":"2024-02-14 00:00:00","insp_start_time":"1027","insp_end_time":"1051","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB I-94 AT M-39","county_code_state":"MI","county_code":"163","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"ROYAL GAS & OIL CO","shipping_paper_number":"10665554","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-02-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"164000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1164970","transaction_code":"A","transaction_date":"2024-02-14 00:00:00","upload_date":"2024-02-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00753725","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-02-14 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-15 21:42:00","insp_carrier_name":"ROYAL GAS & OIL CO","insp_carrier_street":"1710 HILTON ROAD","insp_carrier_city":"FERNDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48220","insp_colonia":null,"docket_number":"341009","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:03:03.000000Z","updated_at":"2025-03-17T20:03:03.000000Z","inspection_violations":[{"id":7804510,"change_date":"2024-02-15 21:42:00","inspection_id":"80862654","insp_violation_id":"257866701","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:43:45.000000Z","updated_at":"2025-03-17T21:43:45.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8150719,"change_date":"2024-02-15 21:42:00","inspection_id":"80862654","insp_unit_id":"199448463","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"5656","insp_unit_license":"RB70248","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN4GY2KM005656","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:54.000000Z","updated_at":"2025-03-17T23:08:54.000000Z"},{"id":8150720,"change_date":"2024-02-15 21:42:00","inspection_id":"80862654","insp_unit_id":"199448464","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"NONE","insp_unit_license":"E714995","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5HTAB486777L69692","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:54.000000Z","updated_at":"2025-03-17T23:08:54.000000Z"}]},{"id":4284041,"change_date":"2023-10-25 21:42:00","inspection_id":"80007569","dot_number":"753725","report_state":"MI","report_number":"POWEL03360","insp_date":"2023-10-24 00:00:00","insp_start_time":"1130","insp_end_time":"1154","registration_date":null,"region":"ET","ci_status_code":"C","location":"122","location_desc":"FOWLERVILLE SCALE W\/B","county_code_state":"MI","county_code":"093","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MPLX TERMINALS","shipping_paper_number":"334390237","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":"2023-10-25 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1150794","transaction_code":"A","transaction_date":"2023-10-24 00:00:00","upload_date":"2023-10-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00753725","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-10-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-10-25 21:42:00","insp_carrier_name":"ROYAL GAS & OIL COMPANY INC","insp_carrier_street":"1710 HILTON ROAD","insp_carrier_city":"FERNDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48220","insp_colonia":null,"docket_number":"341009","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:47:50.000000Z","updated_at":"2025-03-17T19:47:50.000000Z","inspection_violations":[{"id":6626181,"change_date":"2023-10-25 21:42:00","inspection_id":"80007569","insp_violation_id":"256041401","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:56.000000Z","updated_at":"2025-03-17T21:37:56.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6889839,"change_date":"2023-10-25 21:42:00","inspection_id":"80007569","insp_unit_id":"197745412","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"45221","insp_unit_license":"RC32649","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN4GYXRM045221","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:45.000000Z","updated_at":"2025-03-17T22:57:45.000000Z"},{"id":6889840,"change_date":"2023-10-25 21:42:00","inspection_id":"80007569","insp_unit_id":"197745413","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"71093","insp_unit_license":"E714998","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5HTAM452727H66438","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:45.000000Z","updated_at":"2025-03-17T22:57:45.000000Z"}]},{"id":4184733,"change_date":"2023-10-12 21:41:00","inspection_id":"79897754","dot_number":"753725","report_state":"MI","report_number":"LULAN02084","insp_date":"2023-10-11 00:00:00","insp_start_time":"1020","insp_end_time":"1100","registration_date":null,"region":"ET","ci_status_code":"C","location":"122","location_desc":"FOWLERVILLE SCALE W\/B","county_code_state":"MI","county_code":"093","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"S\/C","shipping_paper_number":"N\/A","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1149087","transaction_code":"A","transaction_date":"2023-10-11 00:00:00","upload_date":"2023-10-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00753725","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-10-11 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-10-12 21:41:00","insp_carrier_name":"ROYAL GAS & OIL CO","insp_carrier_street":"1710 HILTON ROAD","insp_carrier_city":"FERNDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48220","insp_colonia":null,"docket_number":"341009","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:45:50.000000Z","updated_at":"2025-03-17T19:45:50.000000Z","inspection_violations":[{"id":6478494,"change_date":"2023-10-12 21:41:00","inspection_id":"79897754","insp_violation_id":"255803515","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:12.000000Z","updated_at":"2025-03-17T21:37:12.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6729657,"change_date":"2023-10-12 21:41:00","inspection_id":"79897754","insp_unit_id":"197527907","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"RC01201","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN4GY7LM015374","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:24.000000Z","updated_at":"2025-03-17T22:56:24.000000Z"},{"id":6729658,"change_date":"2023-10-12 21:41:00","inspection_id":"79897754","insp_unit_id":"197527908","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLR","insp_unit_company":null,"insp_unit_license":"E715003","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1PMA24769F5013255","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:24.000000Z","updated_at":"2025-03-17T22:56:24.000000Z"}]},{"id":3522313,"change_date":"2023-07-17 21:41:00","inspection_id":"79159093","dot_number":"753725","report_state":"MI","report_number":"MORGZ03193","insp_date":"2023-07-17 00:00:00","insp_start_time":"1025","insp_end_time":"1045","registration_date":null,"region":"ET","ci_status_code":"C","location":"FIXED","location_desc":"EB94 AT SCALES","county_code_state":"MI","county_code":"075","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MPLX","shipping_paper_number":"20230709","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1135617","transaction_code":"A","transaction_date":"2023-07-17 00:00:00","upload_date":"2023-07-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00753725","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-07-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-07-17 21:41:00","insp_carrier_name":"ROYAL GAS & OIL CO","insp_carrier_street":"1710 HILTON ROAD","insp_carrier_city":"FERNDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48220","insp_colonia":null,"docket_number":"341009","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:46.000000Z","updated_at":"2025-03-17T19:32:46.000000Z","inspection_violations":[{"id":5431163,"change_date":"2023-07-17 21:41:00","inspection_id":"79159093","insp_violation_id":"254097026","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"196031889","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:12.000000Z","updated_at":"2025-03-17T21:32:12.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":5663496,"change_date":"2023-07-17 21:41:00","inspection_id":"79159093","insp_unit_id":"196031889","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"819019","insp_unit_license":"PWT2256","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1XPBDP9X6JD498333","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:41.000000Z","updated_at":"2025-03-17T22:47:41.000000Z"},{"id":5663497,"change_date":"2023-07-17 21:41:00","inspection_id":"79159093","insp_unit_id":"196031890","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"1337","insp_unit_license":"E714999","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5HTAB442287H72874","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:41.000000Z","updated_at":"2025-03-17T22:47:41.000000Z"}]},{"id":3522499,"change_date":"2023-07-17 21:41:00","inspection_id":"79159313","dot_number":"753725","report_state":"MI","report_number":"LULAN01891","insp_date":"2023-07-17 00:00:00","insp_start_time":"1100","insp_end_time":"1135","registration_date":null,"region":"ET","ci_status_code":"C","location":"122","location_desc":"FOWLERVILLE SCALE W\/B","county_code_state":"MI","county_code":"093","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"US ENERGY DISTRIBUTION LLC","shipping_paper_number":"10642386","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1135695","transaction_code":"A","transaction_date":"2023-07-17 00:00:00","upload_date":"2023-07-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00753725","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-07-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-07-17 21:41:00","insp_carrier_name":"ROYAL GAS & OIL CO","insp_carrier_street":"1710 HILTON ROAD","insp_carrier_city":"FERNDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48220","insp_colonia":null,"docket_number":"341009","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:46.000000Z","updated_at":"2025-03-17T19:32:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5663808,"change_date":"2023-07-17 21:41:00","inspection_id":"79159313","insp_unit_id":"196032299","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":null,"insp_unit_license":"E714994","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5HTAB486987L72417","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:41.000000Z","updated_at":"2025-03-17T22:47:41.000000Z"},{"id":5663809,"change_date":"2023-07-17 21:41:00","inspection_id":"79159313","insp_unit_id":"196032300","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"15734","insp_unit_license":"RC01201","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN4GY7LM015374","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:41.000000Z","updated_at":"2025-03-17T22:47:41.000000Z"}]},{"id":3365308,"change_date":"2023-06-26 21:41:00","inspection_id":"78982764","dot_number":"753725","report_state":"MI","report_number":"POWEL03212","insp_date":"2023-06-24 00:00:00","insp_start_time":"1050","insp_end_time":"1115","registration_date":null,"region":"ET","ci_status_code":"C","location":"122","location_desc":"FOWLERVILLE SCALE W\/B","county_code_state":"MI","county_code":"093","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MPLX TERMINALS","shipping_paper_number":"334351755","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":"2023-06-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118200","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1132138","transaction_code":"A","transaction_date":"2023-06-24 00:00:00","upload_date":"2023-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00753725","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-06-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-06-26 21:41:00","insp_carrier_name":"ROYAL GAS & OIL CO","insp_carrier_street":"1710 HILTON ROAD","insp_carrier_city":"FERNDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48220","insp_colonia":null,"docket_number":"341009","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:29:44.000000Z","updated_at":"2025-03-17T19:29:44.000000Z","inspection_violations":[{"id":5188806,"change_date":"2023-06-26 21:41:00","inspection_id":"78982764","insp_violation_id":"253699610","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:05.000000Z","updated_at":"2025-03-17T21:31:05.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5409738,"change_date":"2023-06-26 21:41:00","inspection_id":"78982764","insp_unit_id":"195674476","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"75853","insp_unit_license":"RC19370","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AW02Y7GM075853","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:40.000000Z","updated_at":"2025-03-17T22:45:40.000000Z"},{"id":5409739,"change_date":"2023-06-26 21:41:00","inspection_id":"78982764","insp_unit_id":"195674477","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"71093","insp_unit_license":"E714998","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5HTAM452727H66438","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:40.000000Z","updated_at":"2025-03-17T22:45:40.000000Z"}]},{"id":2872962,"change_date":"2023-04-24 21:41:00","inspection_id":"78426821","dot_number":"753725","report_state":"MI","report_number":"NESBA00397","insp_date":"2023-04-21 00:00:00","insp_start_time":"1145","insp_end_time":"1205","registration_date":null,"region":"ET","ci_status_code":"C","location":"212","location_desc":"PONTIAC SCALE S\/B","county_code_state":"MI","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MARDET","shipping_paper_number":"33430936","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1123117","transaction_code":"A","transaction_date":"2023-04-21 00:00:00","upload_date":"2023-04-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00753725","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-04-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-04-24 21:41:00","insp_carrier_name":"ROYAL GAS & OIL COMPANY INC","insp_carrier_street":"1710 HILTON ROAD","insp_carrier_city":"FERNDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48220","insp_colonia":null,"docket_number":"341009","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:19:42.000000Z","updated_at":"2025-03-17T19:19:42.000000Z","inspection_violations":[{"id":4409309,"change_date":"2023-04-24 21:41:00","inspection_id":"78426821","insp_violation_id":"252394288","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194544084","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:35.000000Z","updated_at":"2025-03-17T21:27:35.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":4622480,"change_date":"2023-04-24 21:41:00","inspection_id":"78426821","insp_unit_id":"194544084","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"819019","insp_unit_license":"PWT2256","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1XPBDP9X6JD498333","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:28.000000Z","updated_at":"2025-03-17T22:39:28.000000Z"},{"id":4622481,"change_date":"2023-04-24 21:41:00","inspection_id":"78426821","insp_unit_id":"194544085","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"1337","insp_unit_license":"E714999","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5HTAB442287H72874","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:28.000000Z","updated_at":"2025-03-17T22:39:28.000000Z"}]},{"id":1955354,"change_date":"2022-12-15 21:38:00","inspection_id":"77381178","dot_number":"753725","report_state":"MI","report_number":"PEIFM05102","insp_date":"2022-12-15 00:00:00","insp_start_time":"0340","insp_end_time":"0400","registration_date":null,"region":"ET","ci_status_code":"C","location":"141","location_desc":"MONROE SCALE N\/B","county_code_state":"MI","county_code":"115","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"ET","shipping_paper_number":"473479","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":"2022-12-15 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"1105957","transaction_code":"A","transaction_date":"2022-12-15 00:00:00","upload_date":"2022-12-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00753725","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-12-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-12-15 21:38:00","insp_carrier_name":"ROYAL GAS & OIL COMPANY INC","insp_carrier_street":"1710 HILTON ROAD","insp_carrier_city":"FERNDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48220","insp_colonia":null,"docket_number":"341009","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:02:35.000000Z","updated_at":"2025-03-17T19:02:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3146070,"change_date":"2022-12-15 21:38:00","inspection_id":"77381178","insp_unit_id":"192445598","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"15374","insp_unit_license":"RC01201","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN4GY7LM015374","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:33.000000Z","updated_at":"2025-03-17T22:28:33.000000Z"},{"id":3146071,"change_date":"2022-12-15 21:38:00","inspection_id":"77381178","insp_unit_id":"192445599","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLR","insp_unit_company":null,"insp_unit_license":"E715003","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1PMA24769F5013255","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:33.000000Z","updated_at":"2025-03-17T22:28:33.000000Z"}]},{"id":1707721,"change_date":"2022-11-09 21:40:00","inspection_id":"77097367","dot_number":"753725","report_state":"MI","report_number":"POWED03909","insp_date":"2022-11-07 00:00:00","insp_start_time":"1525","insp_end_time":"1538","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB I-94 @ TELEGRAGH","county_code_state":"MI","county_code":"163","insp_level_id":"2","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-11-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"60600","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":"1101472","transaction_code":"A","transaction_date":"2022-11-07 00:00:00","upload_date":"2022-11-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00753725","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-11-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-11-09 21:40:00","insp_carrier_name":"ROYAL GAS & OIL COMPANY INC","insp_carrier_street":"1710 HILTON ROAD","insp_carrier_city":"FERNDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48220","insp_colonia":null,"docket_number":"341009","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:11.000000Z","updated_at":"2025-03-17T18:58:11.000000Z","inspection_violations":[{"id":2675853,"change_date":"2022-11-09 21:40:00","inspection_id":"77097367","insp_violation_id":"249518972","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191883569","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:34.000000Z","updated_at":"2025-03-17T21:19:34.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2747259,"change_date":"2022-11-09 21:40:00","inspection_id":"77097367","insp_unit_id":"191883569","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"8903","insp_unit_license":"RB72600","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN4GY8KM008903","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:48.000000Z","updated_at":"2025-03-17T22:25:48.000000Z"}]},{"id":1365979,"change_date":"2022-09-26 21:39:00","inspection_id":"76703351","dot_number":"753725","report_state":"MI","report_number":"MATTJ01483","insp_date":"2022-09-14 00:00:00","insp_start_time":"1200","insp_end_time":"1230","registration_date":null,"region":"ET","ci_status_code":"C","location":"121","location_desc":"FOWLERVILLE SCALE E\/B","county_code_state":"MI","county_code":"093","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"US ENERGY DISTRIBUTION","shipping_paper_number":"10611556","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-26 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"1096120","transaction_code":"A","transaction_date":"2022-09-22 00:00:00","upload_date":"2022-09-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00753725","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-09-14 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-09-26 21:39:00","insp_carrier_name":"ROYAL GAS & OIL COMPANY INC","insp_carrier_street":"1710 HILTON ROAD","insp_carrier_city":"FERNDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48220","insp_colonia":null,"docket_number":"341009","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:51:57.000000Z","updated_at":"2025-03-17T18:51:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2199626,"change_date":"2022-09-26 21:39:00","inspection_id":"76703351","insp_unit_id":"191095225","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"15374","insp_unit_license":"RC01201","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN4GY7LM015374","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:03.000000Z","updated_at":"2025-03-17T22:22:03.000000Z"},{"id":2199627,"change_date":"2022-09-26 21:39:00","inspection_id":"76703351","insp_unit_id":"191095226","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":null,"insp_unit_license":"E715003","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1PMA24769F5013255","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:03.000000Z","updated_at":"2025-03-17T22:22:03.000000Z"}]},{"id":1216391,"change_date":"2022-09-06 21:42:00","inspection_id":"76529733","dot_number":"753725","report_state":"MI","report_number":"COPEK01592","insp_date":"2022-09-02 00:00:00","insp_start_time":"1105","insp_end_time":"1150","registration_date":null,"region":"ET","ci_status_code":"C","location":"212","location_desc":"PONTIAC SCALE S\/B","county_code_state":"MI","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"ENERGY TRANSFER","shipping_paper_number":"463070","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":"2022-09-06 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"1","hazmat_oos_total":"0","snet_sequence_id":"1093172","transaction_code":"A","transaction_date":"2022-09-02 00:00:00","upload_date":"2022-09-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00753725","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-09-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-09-06 21:42:00","insp_carrier_name":"ROYAL GAS & OIL COMPANY INC","insp_carrier_street":"1710 HILTON ROAD","insp_carrier_city":"FERNDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48220","insp_colonia":null,"docket_number":"341009","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:49:01.000000Z","updated_at":"2025-03-17T18:49:01.000000Z","inspection_violations":[{"id":1926607,"change_date":"2022-09-06 21:42:00","inspection_id":"76529733","insp_violation_id":"248223765","seq_no":"1","part_no":"172","part_no_section":"602(c)(1)","insp_viol_unit":"1","insp_unit_id":"190734236","insp_violation_category_id":"38","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:54.000000Z","updated_at":"2025-03-17T21:15:54.000000Z","normalized_code":"172602C1"},{"id":1926608,"change_date":"2022-09-06 21:42:00","inspection_id":"76529733","insp_violation_id":"248223766","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190734236","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:54.000000Z","updated_at":"2025-03-17T21:15:54.000000Z","normalized_code":"3939A"},{"id":1926609,"change_date":"2022-09-06 21:42:00","inspection_id":"76529733","insp_violation_id":"248223767","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190734236","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:54.000000Z","updated_at":"2025-03-17T21:15:54.000000Z","normalized_code":"3939A"},{"id":1926610,"change_date":"2022-09-06 21:42:00","inspection_id":"76529733","insp_violation_id":"248223768","seq_no":"4","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"190734236","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:54.000000Z","updated_at":"2025-03-17T21:15:54.000000Z","normalized_code":"39378"},{"id":1926611,"change_date":"2022-09-06 21:42:00","inspection_id":"76529733","insp_violation_id":"248223769","seq_no":"5","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"190734236","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4102558","created_at":"2025-03-17T21:15:54.000000Z","updated_at":"2025-03-17T21:15:54.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":1956852,"change_date":"2022-09-06 21:42:00","inspection_id":"76529733","insp_unit_id":"190734236","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"8903","insp_unit_license":"RB72600","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN4GY8KM008903","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:27.000000Z","updated_at":"2025-03-17T22:20:27.000000Z"},{"id":1956853,"change_date":"2022-09-06 21:42:00","inspection_id":"76529733","insp_unit_id":"190734237","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"2013","insp_unit_license":"E715000","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1PMA24769E5012556","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:27.000000Z","updated_at":"2025-03-17T22:20:27.000000Z"}]},{"id":1007556,"change_date":"2022-08-10 21:39:00","inspection_id":"76286361","dot_number":"753725","report_state":"MI","report_number":"HAMIZ00863","insp_date":"2022-08-09 00:00:00","insp_start_time":"1120","insp_end_time":"1138","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75 & DIXIE HWY","county_code_state":"MI","county_code":"115","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"1088240","transaction_code":"A","transaction_date":"2022-08-09 00:00:00","upload_date":"2022-08-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00753725","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-08-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-08-10 21:39:00","insp_carrier_name":"ROYAL GAS & OIL COMPANY INC","insp_carrier_street":"1710 HILTON ROAD","insp_carrier_city":"FERNDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48220","insp_colonia":null,"docket_number":"341009","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:45:25.000000Z","updated_at":"2025-03-17T18:45:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1620810,"change_date":"2022-08-10 21:39:00","inspection_id":"76286361","insp_unit_id":"190237941","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"019130","insp_unit_license":"PWT2243","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1XPBDP9X3LD686293","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:13.000000Z","updated_at":"2025-03-17T22:18:13.000000Z"}]},{"id":973298,"change_date":"2022-08-05 21:40:00","inspection_id":"76246593","dot_number":"753725","report_state":"MI","report_number":"LITTJ04122","insp_date":"2022-08-03 00:00:00","insp_start_time":"1720","insp_end_time":"1750","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-94 E\/B @ I-275","county_code_state":"MI","county_code":"163","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"PETROLEUM TRADERS","shipping_paper_number":"334246600","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":"2022-08-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"154000","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":"1087279","transaction_code":"A","transaction_date":"2022-08-03 00:00:00","upload_date":"2022-08-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00753725","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-08-03 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-08-05 21:40:00","insp_carrier_name":"ROYAL GAS & OIL COMPANY INC","insp_carrier_street":"1710 HILTON ROAD","insp_carrier_city":"FERNDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48220","insp_colonia":null,"docket_number":"341009","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:44:47.000000Z","updated_at":"2025-03-17T18:44:47.000000Z","inspection_violations":[{"id":1534857,"change_date":"2022-08-05 21:40:00","inspection_id":"76246593","insp_violation_id":"247543172","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"190158054","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:14.000000Z","updated_at":"2025-03-17T21:14:14.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":1566168,"change_date":"2022-08-05 21:40:00","inspection_id":"76246593","insp_unit_id":"190158053","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"819022","insp_unit_license":"PWT2382","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1XPCDP0X4JD498249","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:52.000000Z","updated_at":"2025-03-17T22:17:52.000000Z"},{"id":1566169,"change_date":"2022-08-05 21:40:00","inspection_id":"76246593","insp_unit_id":"190158054","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"3016","insp_unit_license":"D380291","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"558MEBT61GK003001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:52.000000Z","updated_at":"2025-03-17T22:17:52.000000Z"}]},{"id":884233,"change_date":"2022-07-25 21:39:00","inspection_id":"76141927","dot_number":"753725","report_state":"OH","report_number":"3217300866","insp_date":"2022-07-25 00:00:00","insp_start_time":"1140","insp_end_time":"1215","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROADSIDE I 75","county_code_state":"OH","county_code":"173","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER - RESIDUE","shipping_paper_number":"2346518","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-07-25 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1608197","transaction_code":"A","transaction_date":"2022-07-25 00:00:00","upload_date":"2022-07-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00753725","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-07-25 00:00:00","source_office":"3OHS001","mcmis_add_date":"2022-07-25 21:39:00","insp_carrier_name":"ROYAL GAS & OIL COMPANY INC","insp_carrier_street":"1710 HILTON ROAD","insp_carrier_city":"FERNDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48220","insp_colonia":null,"docket_number":"341009","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:43:21.000000Z","updated_at":"2025-03-17T18:43:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1423451,"change_date":"2022-07-25 21:39:00","inspection_id":"76141927","insp_unit_id":"189942276","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"75853","insp_unit_license":"RB31278","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AW02Y7GM075853","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:56.000000Z","updated_at":"2025-03-17T22:16:56.000000Z"},{"id":1423452,"change_date":"2022-07-25 21:39:00","inspection_id":"76141927","insp_unit_id":"189942277","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"71093","insp_unit_license":"D173810","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5HTAM452727H66438","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:56.000000Z","updated_at":"2025-03-17T22:16:56.000000Z"}]},{"id":828347,"change_date":"2022-07-15 21:40:00","inspection_id":"76076791","dot_number":"753725","report_state":"OH","report_number":"3217300855","insp_date":"2022-07-15 00:00:00","insp_start_time":"0915","insp_end_time":"0945","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROADSIDE CR508","county_code_state":"OH","county_code":"095","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"MPLX TERMINALS","shipping_paper_number":"604049927","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-07-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1606776","transaction_code":"A","transaction_date":"2022-07-15 00:00:00","upload_date":"2022-07-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00753725","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-07-15 00:00:00","source_office":"3OHS001","mcmis_add_date":"2022-07-15 21:40:00","insp_carrier_name":"ROYAL GAS & OIL COMPANY INC","insp_carrier_street":"1710 HILTON ROAD","insp_carrier_city":"FERNDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48220","insp_colonia":null,"docket_number":"341009","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:42:17.000000Z","updated_at":"2025-03-17T18:42:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1332632,"change_date":"2022-07-15 21:40:00","inspection_id":"76076791","insp_unit_id":"189801905","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"819019","insp_unit_license":"PWT2256","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1XPBDP9X6JD498333","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:22.000000Z","updated_at":"2025-03-17T22:16:22.000000Z"},{"id":1332633,"change_date":"2022-07-15 21:40:00","inspection_id":"76076791","insp_unit_id":"189801906","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"1337","insp_unit_license":"D173807","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5HTAB442287H72874","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:22.000000Z","updated_at":"2025-03-17T22:16:22.000000Z"}]},{"id":809031,"change_date":"2022-07-20 21:41:00","inspection_id":"76054006","dot_number":"753725","report_state":"MI","report_number":"KIRKB03540","insp_date":"2022-07-12 00:00:00","insp_start_time":"1335","insp_end_time":"1415","registration_date":null,"region":"ET","ci_status_code":"C","location":"121","location_desc":"FOWLERVILLE SCALE E\/B","county_code_state":"MI","county_code":"093","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"S\/C","shipping_paper_number":"334239789","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":"2022-07-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"168000","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":"1","hazmat_oos_total":"0","snet_sequence_id":"1083583","transaction_code":"C","transaction_date":"2022-07-19 00:00:00","upload_date":"2022-07-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00753725","upload_search_indicator":"M","census_search_date":"2022-07-20 21:41:00","snet_input_date":"2022-07-12 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-07-13 21:40:00","insp_carrier_name":"ROYAL GAS & OIL COMPANY INC","insp_carrier_street":"1710 HILTON ROAD","insp_carrier_city":"FERNDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48220","insp_colonia":null,"docket_number":"341009","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:41:57.000000Z","updated_at":"2025-03-17T18:41:57.000000Z","inspection_violations":[{"id":1275402,"change_date":"2022-07-20 21:41:00","inspection_id":"76054006","insp_violation_id":"247204855","seq_no":"1","part_no":"107","part_no_section":"620(b)","insp_viol_unit":"1","insp_unit_id":"189874437","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:59.000000Z","updated_at":"2025-03-17T21:12:59.000000Z","normalized_code":"107620B"},{"id":1275403,"change_date":"2022-07-20 21:41:00","inspection_id":"76054006","insp_violation_id":"247204856","seq_no":"2","part_no":"172","part_no_section":"602(a)","insp_viol_unit":"1","insp_unit_id":"189874437","insp_violation_category_id":"38","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:59.000000Z","updated_at":"2025-03-17T21:12:59.000000Z","normalized_code":"172602A"},{"id":1275404,"change_date":"2022-07-20 21:41:00","inspection_id":"76054006","insp_violation_id":"247204857","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"189874438","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:59.000000Z","updated_at":"2025-03-17T21:12:59.000000Z","normalized_code":"3922"},{"id":1275405,"change_date":"2022-07-20 21:41:00","inspection_id":"76054006","insp_violation_id":"247204858","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"189874438","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:59.000000Z","updated_at":"2025-03-17T21:12:59.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":1301996,"change_date":"2022-07-20 21:41:00","inspection_id":"76054006","insp_unit_id":"189874437","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"911894","insp_unit_license":"PWT2384","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1XPCD40X3KD609681","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:11.000000Z","updated_at":"2025-03-17T22:16:11.000000Z"},{"id":1301997,"change_date":"2022-07-20 21:41:00","inspection_id":"76054006","insp_unit_id":"189874438","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"3016","insp_unit_license":"D380291","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"558MEBT61GK003001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:11.000000Z","updated_at":"2025-03-17T22:16:11.000000Z"}]},{"id":359124,"change_date":"2022-05-10 21:40:00","inspection_id":"75521254","dot_number":"753725","report_state":"OH","report_number":"3217300800","insp_date":"2022-05-10 00:00:00","insp_start_time":"1215","insp_end_time":"1250","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROADSIDE CR 508","county_code_state":"OH","county_code":"095","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER - RESIDUE","shipping_paper_number":null,"cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-05-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1596074","transaction_code":"A","transaction_date":"2022-05-10 00:00:00","upload_date":"2022-05-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00753725","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-05-10 00:00:00","source_office":"3OHS001","mcmis_add_date":"2022-05-10 21:40:00","insp_carrier_name":"ROYAL GAS & OIL COMPANY INC","insp_carrier_street":"1710 HILTON ROAD","insp_carrier_city":"FERNDALE","insp_carrier_state":"MI","insp_carrier_zip_code":"48220","insp_colonia":null,"docket_number":"341009","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:33:42.000000Z","updated_at":"2025-03-17T18:33:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":580795,"change_date":"2022-05-10 21:40:00","inspection_id":"75521254","insp_unit_id":"188606460","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"019130","insp_unit_license":"PWT2243","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1XPBDP9X3LD686293","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:46.000000Z","updated_at":"2025-03-17T22:11:46.000000Z"},{"id":580796,"change_date":"2022-05-10 21:40:00","inspection_id":"75521254","insp_unit_id":"188606461","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"1336","insp_unit_license":"D173812","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5HTAB442987H72872","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:46.000000Z","updated_at":"2025-03-17T22:11:46.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/753725\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/753725\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/753725\/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\/753725\/inspections","per_page":100,"prev_page_url":null,"to":29,"total":29}