{"current_page":1,"data":[{"id":12174836,"change_date":"2026-06-12 21:41:00","inspection_id":"88129669","dot_number":"234407","report_state":"US","report_number":"1587000143","insp_date":"2026-06-11 00:00:00","insp_start_time":"0945","insp_end_time":"1011","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ROSEVILLE MN","county_code_state":"MN","county_code":"123","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MARATHON","shipping_paper_number":"1336780","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-06-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"68000","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":"3531540","transaction_code":"A","transaction_date":"2026-06-12 00:00:00","upload_date":"2026-06-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00234407","upload_search_indicator":null,"census_search_date":"2026-06-12 21:41:00","snet_input_date":"2026-06-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-12 21:41:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"1500 RIVERVIEW DRIVE","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-16T09:43:39.000000Z","updated_at":"2026-06-23T09:31:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21147398,"change_date":"2026-06-12 21:41:00","inspection_id":"88129669","insp_unit_id":"214075803","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":null,"insp_unit_license":"YCE6192","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"5KKMBPFM4RLVE4702","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-16T09:20:45.000000Z","updated_at":"2026-06-23T09:03:02.000000Z"}]},{"id":12219278,"change_date":"2026-06-18 21:41:00","inspection_id":"88176907","dot_number":"234407","report_state":"MN","report_number":"0263001322","insp_date":"2026-06-11 00:00:00","insp_start_time":"0907","insp_end_time":"1027","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ROGERS MN","county_code_state":"MN","county_code":"053","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"WSTRN RFNG TERMINALS LLC","shipping_paper_number":"242548251","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-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"10","oos_total":"1","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3568348","transaction_code":"A","transaction_date":"2026-06-17 00:00:00","upload_date":"2026-06-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00234407","upload_search_indicator":null,"census_search_date":"2026-06-18 21:41:00","snet_input_date":"2026-06-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-18 21:41:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"1500 RIVERVIEW DRIVE","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-21T09:43:31.000000Z","updated_at":"2026-06-29T09:30:26.000000Z","inspection_violations":[{"id":21267765,"change_date":"2026-06-18 21:41:00","inspection_id":"88176907","insp_violation_id":"274986036","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWG1","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-21T10:04:42.000000Z","updated_at":"2026-06-29T09:41:59.000000Z","normalized_code":"3922SLLEWG1"},{"id":21267766,"change_date":"2026-06-18 21:41:00","inspection_id":"88176907","insp_violation_id":"274986037","seq_no":"2","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-21T10:04:42.000000Z","updated_at":"2026-06-29T09:41:59.000000Z","normalized_code":"3922SLLEWA1"},{"id":21267767,"change_date":"2026-06-18 21:41:00","inspection_id":"88176907","insp_violation_id":"274986038","seq_no":"3","part_no":"393","part_no_section":"17A2-LDSML","insp_viol_unit":"2","insp_unit_id":"214166479","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-21T10:04:42.000000Z","updated_at":"2026-06-29T09:41:59.000000Z","normalized_code":"39317A2LDSML"},{"id":21267768,"change_date":"2026-06-18 21:41:00","inspection_id":"88176907","insp_violation_id":"274986039","seq_no":"4","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":"882602630313","created_at":"2026-06-21T10:04:42.000000Z","updated_at":"2026-06-29T09:41:59.000000Z","normalized_code":"3922SLLEWA1"},{"id":21267769,"change_date":"2026-06-18 21:41:00","inspection_id":"88176907","insp_violation_id":"274986040","seq_no":"5","part_no":"393","part_no_section":"9A-LTSIR","insp_viol_unit":"1","insp_unit_id":"214166478","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-21T10:04:42.000000Z","updated_at":"2026-06-29T09:41:59.000000Z","normalized_code":"3939ALTSIR"},{"id":21267770,"change_date":"2026-06-18 21:41:00","inspection_id":"88176907","insp_violation_id":"274986041","seq_no":"6","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"214166478","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-21T10:04:42.000000Z","updated_at":"2026-06-29T09:41:59.000000Z","normalized_code":"3922SLLSR"},{"id":21267771,"change_date":"2026-06-18 21:41:00","inspection_id":"88176907","insp_violation_id":"274986042","seq_no":"7","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"1","insp_unit_id":"214166478","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-21T10:04:42.000000Z","updated_at":"2026-06-29T09:41:59.000000Z","normalized_code":"3939ALSLI"},{"id":21267772,"change_date":"2026-06-18 21:41:00","inspection_id":"88176907","insp_violation_id":"274986043","seq_no":"8","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"214166478","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-21T10:04:42.000000Z","updated_at":"2026-06-29T09:41:59.000000Z","normalized_code":"3922SLLSR"},{"id":21267773,"change_date":"2026-06-18 21:41:00","inspection_id":"88176907","insp_violation_id":"274986044","seq_no":"9","part_no":"393","part_no_section":"45B2-BHTD","insp_viol_unit":"2","insp_unit_id":"214166479","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-06-21T10:04:42.000000Z","updated_at":"2026-06-29T09:41:59.000000Z","normalized_code":"39345B2BHTD"},{"id":21267774,"change_date":"2026-06-18 21:41:00","inspection_id":"88176907","insp_violation_id":"274986045","seq_no":"10","part_no":"396","part_no_section":"9D2-FTF","insp_viol_unit":"1","insp_unit_id":"214166478","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-21T10:04:42.000000Z","updated_at":"2026-06-29T09:41:59.000000Z","normalized_code":"3969D2FTF"}],"inspection_per_units":[{"id":21221680,"change_date":"2026-06-18 21:41:00","inspection_id":"88176907","insp_unit_id":"214166478","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"118","insp_unit_license":"PAS8169","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1XKWD49X0PR256994","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-21T09:19:18.000000Z","updated_at":"2026-06-29T09:01:17.000000Z"},{"id":21221681,"change_date":"2026-06-18 21:41:00","inspection_id":"88176907","insp_unit_id":"214166479","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLAR MFG.","insp_unit_company":"1747","insp_unit_license":"1803STL","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1PMA24427E5011522","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-21T09:19:18.000000Z","updated_at":"2026-06-29T09:01:17.000000Z"}]},{"id":11882610,"change_date":"2026-05-12 21:39:00","inspection_id":"87820294","dot_number":"234407","report_state":"MN","report_number":"0460000462","insp_date":"2026-05-05 00:00:00","insp_start_time":"1155","insp_end_time":"1239","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"WASECA MN","county_code_state":"MN","county_code":"161","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"263371","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-12 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3302404","transaction_code":"A","transaction_date":"2026-05-11 00:00:00","upload_date":"2026-05-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00234407","upload_search_indicator":null,"census_search_date":"2026-05-12 21:39:00","snet_input_date":"2026-05-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-12 21:39:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"1500 RIVERVIEW DRIVE","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-14T12:39:25.000000Z","updated_at":"2026-05-23T09:30:32.000000Z","inspection_violations":[{"id":20667086,"change_date":"2026-05-12 21:39:00","inspection_id":"87820294","insp_violation_id":"274189769","seq_no":"2","part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2026-05-14T12:58:34.000000Z","updated_at":"2026-05-23T09:43:41.000000Z","normalized_code":"3922SLLTCD"},{"id":20667085,"change_date":"2026-05-12 21:39:00","inspection_id":"87820294","insp_violation_id":"274189768","seq_no":"1","part_no":"391","part_no_section":"11B4-CLHA","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"WARNING","created_at":"2026-05-14T12:58:34.000000Z","updated_at":"2026-05-23T09:43:41.000000Z","normalized_code":"39111B4CLHA"}],"inspection_per_units":[{"id":20660453,"change_date":"2026-05-12 21:39:00","inspection_id":"87820294","insp_unit_id":"213497557","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"118","insp_unit_license":"YBR3807","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"2NP3LJ0X0GM326071","insp_unit_decal":"Y","insp_unit_decal_number":"36359963","created_at":"2026-05-14T12:01:21.000000Z","updated_at":"2026-05-23T09:03:04.000000Z"}]},{"id":11706084,"change_date":"2026-04-21 21:38:00","inspection_id":"87632781","dot_number":"234407","report_state":"MN","report_number":"1715000216","insp_date":"2026-04-14 00:00:00","insp_start_time":"0812","insp_end_time":"0842","registration_date":null,"region":"CD","ci_status_code":"C","location":"CLKGVN","location_desc":"CLARKS GROVE MN","county_code_state":"MN","county_code":"047","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"1 CARGO TANK","cargo_tank":"331","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-21 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3186619","transaction_code":"A","transaction_date":"2026-04-20 00:00:00","upload_date":"2026-04-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00234407","upload_search_indicator":null,"census_search_date":"2026-04-21 21:38:00","snet_input_date":"2026-04-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-21 21:38:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"1500 RIVERVIEW DRIVE","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:37:22.000000Z","updated_at":"2026-05-02T09:30:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20371401,"change_date":"2026-04-21 21:38:00","inspection_id":"87632781","insp_unit_id":"213131289","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"YCC3619","insp_unit_license":"YCC3619","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1FVACXFEXPHUB4471","insp_unit_decal":"Y","insp_unit_decal_number":"36360026","created_at":"2026-04-27T09:13:32.000000Z","updated_at":"2026-05-02T09:02:34.000000Z"}]},{"id":11692455,"change_date":"2026-04-20 21:37:00","inspection_id":"87618562","dot_number":"234407","report_state":"MN","report_number":"0073000533","insp_date":"2026-04-13 00:00:00","insp_start_time":"0821","insp_end_time":"0832","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"EAGAN MN","county_code_state":"MN","county_code":"037","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-04-20 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"3183214","transaction_code":"A","transaction_date":"2026-04-19 00:00:00","upload_date":"2026-04-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00234407","upload_search_indicator":null,"census_search_date":"2026-04-20 21:37:00","snet_input_date":"2026-04-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-20 21:37:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"1500 RIVERVIEW DRIVE","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:35:22.000000Z","updated_at":"2026-05-01T09:30:24.000000Z","inspection_violations":[{"id":20314428,"change_date":"2026-04-20 21:37:00","inspection_id":"87618562","insp_violation_id":"273708867","seq_no":"1","part_no":"392","part_no_section":"16-D","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-04-27T09:50:35.000000Z","updated_at":"2026-05-01T09:41:15.000000Z","normalized_code":"39216D"}],"inspection_per_units":[{"id":20349028,"change_date":"2026-04-20 21:37:00","inspection_id":"87618562","insp_unit_id":"213104544","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"38","insp_unit_license":"YTE5677","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"3AKJHTDV6PSUK2350","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:10:27.000000Z","updated_at":"2026-05-01T09:02:56.000000Z"},{"id":20349029,"change_date":"2026-04-20 21:37:00","inspection_id":"87618562","insp_unit_id":"213104545","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MAC LTT","insp_unit_company":"1755","insp_unit_license":"9921STU","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"558MTBR21LK005285","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:10:27.000000Z","updated_at":"2026-05-01T09:02:56.000000Z"}]},{"id":11572602,"change_date":"2026-04-06 21:37:00","inspection_id":"87496558","dot_number":"234407","report_state":"MN","report_number":"0444000787","insp_date":"2026-03-30 00:00:00","insp_start_time":"1022","insp_end_time":"1125","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"MARSHALL MN","county_code_state":"MN","county_code":"083","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MAGELLAN PIPE LINE, LP","shipping_paper_number":"385292","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-06 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"3117153","transaction_code":"A","transaction_date":"2026-04-05 00:00:00","upload_date":"2026-04-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00234407","upload_search_indicator":null,"census_search_date":"2026-04-06 21:37:00","snet_input_date":"2026-03-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-06 21:37:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"1500 RIVERVIEW DRIVE","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-09T09:49:02.000000Z","updated_at":"2026-04-17T09:32:46.000000Z","inspection_violations":[{"id":19564581,"change_date":"2026-04-06 21:37:00","inspection_id":"87496558","insp_violation_id":"272884014","seq_no":"1","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"2","insp_unit_id":"212556545","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2026-04-08T10:13:13.000000Z","updated_at":"2026-04-18T10:37:01.000000Z","normalized_code":"39345DB"}],"inspection_per_units":[{"id":19834479,"change_date":"2026-04-06 21:37:00","inspection_id":"87496558","insp_unit_id":"212556544","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"33","insp_unit_license":"YTE0249","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"3AKJHTDVXNDNC8670","insp_unit_decal":"Y","insp_unit_decal_number":"36075411","created_at":"2026-04-09T09:42:51.000000Z","updated_at":"2026-04-18T09:14:51.000000Z"},{"id":19834480,"change_date":"2026-04-06 21:37:00","inspection_id":"87496558","insp_unit_id":"212556545","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLAR MFG.","insp_unit_company":"1744","insp_unit_license":"STB0475","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1PMA24427B5009443","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-09T09:42:51.000000Z","updated_at":"2026-04-18T09:14:51.000000Z"}]},{"id":11422684,"change_date":"2026-03-20 21:39:00","inspection_id":"87338495","dot_number":"234407","report_state":"WI","report_number":"2641009024","insp_date":"2026-03-17 00:00:00","insp_start_time":"1556","insp_end_time":"1620","registration_date":null,"region":"CD","ci_status_code":"C","location":"S63","location_desc":"MENOMONIE WI","county_code_state":"WI","county_code":"033","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-03-20 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"109220","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":"3028172","transaction_code":"A","transaction_date":"2026-03-19 00:00:00","upload_date":"2026-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00234407","upload_search_indicator":null,"census_search_date":"2026-03-20 21:39:00","snet_input_date":"2026-03-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-20 21:39:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"1500 RIVERVIEW DRIVE","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-23T09:46:29.000000Z","updated_at":"2026-03-31T09:30:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19567729,"change_date":"2026-03-20 21:39:00","inspection_id":"87338495","insp_unit_id":"212230874","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"YTE7551","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"3AKJHHDR6SSWE9302","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-23T09:29:56.000000Z","updated_at":"2026-03-31T09:08:15.000000Z"},{"id":19567730,"change_date":"2026-03-20 21:39:00","inspection_id":"87338495","insp_unit_id":"212230875","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLAR MFG.","insp_unit_company":null,"insp_unit_license":"STC6729","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1PMKA4429S7133080","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-23T09:29:56.000000Z","updated_at":"2026-03-31T09:08:15.000000Z"}]},{"id":11350342,"change_date":"2026-03-12 21:39:00","inspection_id":"87268409","dot_number":"234407","report_state":"MN","report_number":"0485000861","insp_date":"2026-03-05 00:00:00","insp_start_time":"1615","insp_end_time":"1627","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"DENNISON MN","county_code_state":"MN","county_code":"049","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-03-12 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"58000","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":"2993407","transaction_code":"A","transaction_date":"2026-03-11 00:00:00","upload_date":"2026-03-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00234407","upload_search_indicator":null,"census_search_date":"2026-03-12 21:39:00","snet_input_date":"2026-03-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-12 21:39:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"1500 RIVERVIEW DRIVE","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-15T09:39:50.000000Z","updated_at":"2026-03-23T09:30:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19425233,"change_date":"2026-03-12 21:39:00","inspection_id":"87268409","insp_unit_id":"212095785","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"123","insp_unit_license":"YBY5764","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"3ALHC5DV9KDKA8644","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-15T09:19:35.000000Z","updated_at":"2026-03-23T09:08:21.000000Z"}]},{"id":11256443,"change_date":"2026-02-28 21:34:00","inspection_id":"87169949","dot_number":"234407","report_state":"WI","report_number":"2431004982","insp_date":"2026-02-25 00:00:00","insp_start_time":"1120","insp_end_time":"1230","registration_date":null,"region":"CS","ci_status_code":"C","location":"S61","location_desc":"HUDSON WI","county_code_state":"WI","county_code":"109","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"WSTRM RFNG TERMINALS LLC","shipping_paper_number":"242512225","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-02-28 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"121220","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":"2945679","transaction_code":"A","transaction_date":"2026-02-27 00:00:00","upload_date":"2026-02-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00234407","upload_search_indicator":null,"census_search_date":"2026-02-28 21:34:00","snet_input_date":"2026-02-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-28 21:34:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"1500 RIVERVIEW DRIVE","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-03T10:39:19.000000Z","updated_at":"2026-03-11T09:30:13.000000Z","inspection_violations":[{"id":18914688,"change_date":"2026-02-28 21:34:00","inspection_id":"87169949","insp_violation_id":"272112388","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"211896792","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-03T10:57:02.000000Z","updated_at":"2026-03-11T09:38:44.000000Z","normalized_code":"39347E"},{"id":18914689,"change_date":"2026-02-28 21:34:00","inspection_id":"87169949","insp_violation_id":"272112389","seq_no":"2","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"2","insp_unit_id":"211896792","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-03T10:57:02.000000Z","updated_at":"2026-03-11T09:38:44.000000Z","normalized_code":"39345DB"},{"id":18914690,"change_date":"2026-02-28 21:34:00","inspection_id":"87169949","insp_violation_id":"272112390","seq_no":"3","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"1","insp_unit_id":"211896791","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-03T10:57:02.000000Z","updated_at":"2026-03-11T09:38:44.000000Z","normalized_code":"3939ALSLI"},{"id":18914691,"change_date":"2026-02-28 21:34:00","inspection_id":"87169949","insp_violation_id":"272112391","seq_no":"4","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"211896792","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-03T10:57:02.000000Z","updated_at":"2026-03-11T09:38:44.000000Z","normalized_code":"39347E"},{"id":18914692,"change_date":"2026-02-28 21:34:00","inspection_id":"87169949","insp_violation_id":"272112392","seq_no":"5","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"2","insp_unit_id":"211896792","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-03T10:57:02.000000Z","updated_at":"2026-03-11T09:38:44.000000Z","normalized_code":"39353BB"}],"inspection_per_units":[{"id":19247337,"change_date":"2026-02-28 21:34:00","inspection_id":"87169949","insp_unit_id":"211896791","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"40","insp_unit_license":"YTE7551","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"3AKJHHDR6SSWE9302","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-03T10:15:29.000000Z","updated_at":"2026-03-11T09:02:10.000000Z"},{"id":19247338,"change_date":"2026-02-28 21:34:00","inspection_id":"87169949","insp_unit_id":"211896792","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLAR MFG.","insp_unit_company":"1742","insp_unit_license":"9933STU","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1PMA2442145004001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-03T10:15:29.000000Z","updated_at":"2026-03-11T09:02:10.000000Z"}]},{"id":10585454,"change_date":"2026-01-07 21:38:00","inspection_id":"86724067","dot_number":"234407","report_state":"MN","report_number":"0191000545","insp_date":"2025-12-31 00:00:00","insp_start_time":"1015","insp_end_time":"1034","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"LITCHFIELD MN","county_code_state":"MN","county_code":"093","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"850012478","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-01-07 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"2729921","transaction_code":"A","transaction_date":"2026-01-06 00:00:00","upload_date":"2026-01-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00234407","upload_search_indicator":null,"census_search_date":"2026-01-07 21:38:00","snet_input_date":"2025-12-31 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-07 21:38:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"1500 RIVERVIEW DRIVE","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-10T10:34:37.000000Z","updated_at":"2026-01-18T10:31:15.000000Z","inspection_violations":[{"id":17792413,"change_date":"2026-01-07 21:38:00","inspection_id":"86724067","insp_violation_id":"271052926","seq_no":"1","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"210946238","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2026-01-10T10:38:45.000000Z","updated_at":"2026-01-18T10:31:28.000000Z","normalized_code":"3922SLLEQP"}],"inspection_per_units":[{"id":17743781,"change_date":"2026-01-07 21:38:00","inspection_id":"86724067","insp_unit_id":"210946238","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"91","insp_unit_license":"PAW7221","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1XP5DB9X3MD303972","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-10T10:06:06.000000Z","updated_at":"2026-01-18T10:00:56.000000Z"},{"id":17743782,"change_date":"2026-01-07 21:38:00","inspection_id":"86724067","insp_unit_id":"210946239","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":"1749","insp_unit_license":"STE2486","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1PMA24525F5013396","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-10T10:06:06.000000Z","updated_at":"2026-01-18T10:00:56.000000Z"}]},{"id":10553208,"change_date":"2026-01-02 21:35:00","inspection_id":"86690200","dot_number":"234407","report_state":"MN","report_number":"0230000137","insp_date":"2025-12-26 00:00:00","insp_start_time":"1310","insp_end_time":"1341","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"ALBERT LEA MN","county_code_state":"MN","county_code":"047","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"WATERFORD OIL COMPANY","shipping_paper_number":"PROPANE","cargo_tank":"331","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-01-02 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2716078","transaction_code":"A","transaction_date":"2026-01-01 00:00:00","upload_date":"2026-01-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00234407","upload_search_indicator":null,"census_search_date":"2026-01-02 21:35:00","snet_input_date":"2025-12-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-02 21:35:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"1500 RIVERVIEW DRIVE","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-05T10:33:31.000000Z","updated_at":"2026-01-13T10:30:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17680210,"change_date":"2026-01-02 21:35:00","inspection_id":"86690200","insp_unit_id":"210878804","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"YCC3619","insp_unit_license":"YCC3619","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1FVACXFEXPHUB4471","insp_unit_decal":"Y","insp_unit_decal_number":"35792773","created_at":"2026-01-05T10:05:02.000000Z","updated_at":"2026-01-13T10:00:11.000000Z"}]},{"id":10156102,"change_date":"2025-11-09 21:34:00","inspection_id":"86274533","dot_number":"234407","report_state":"WI","report_number":"5034006908","insp_date":"2025-11-06 00:00:00","insp_start_time":"1246","insp_end_time":"1334","registration_date":null,"region":"CS","ci_status_code":"C","location":"S61","location_desc":"HUDSON WI","county_code_state":"WI","county_code":"109","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"WESTERN REFINING CO","shipping_paper_number":"20251104","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-11-09 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"119200","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":"2519719","transaction_code":"A","transaction_date":"2025-11-08 00:00:00","upload_date":"2025-11-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00234407","upload_search_indicator":null,"census_search_date":"2025-11-09 21:34:00","snet_input_date":"2025-11-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-09 21:34:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"1500 RIVERVIEW DRIVE","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-12T10:30:23.000000Z","updated_at":"2025-11-13T10:30:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16908396,"change_date":"2025-11-09 21:34:00","inspection_id":"86274533","insp_unit_id":"209923679","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"40","insp_unit_license":"YTE7551","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"3AKJHHDR6SSWE9302","insp_unit_decal":"Y","insp_unit_decal_number":"35807309","created_at":"2025-11-12T10:00:28.000000Z","updated_at":"2025-11-13T10:00:11.000000Z"},{"id":16908397,"change_date":"2025-11-09 21:34:00","inspection_id":"86274533","insp_unit_id":"209923680","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLAR MFG.","insp_unit_company":"1759","insp_unit_license":"STC6729","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1PMKA4429S7133080","insp_unit_decal":"Y","insp_unit_decal_number":"35807310","created_at":"2025-11-12T10:00:28.000000Z","updated_at":"2025-11-13T10:00:11.000000Z"}]},{"id":10159178,"change_date":"2025-11-10 21:38:00","inspection_id":"86277800","dot_number":"234407","report_state":"MN","report_number":"0025000665","insp_date":"2025-11-03 00:00:00","insp_start_time":"1011","insp_end_time":"1108","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"OAKDALE MN","county_code_state":"MN","county_code":"163","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"NA","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-11-10 21:38: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":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2522451","transaction_code":"A","transaction_date":"2025-11-09 00:00:00","upload_date":"2025-11-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00234407","upload_search_indicator":null,"census_search_date":"2025-11-10 21:38:00","snet_input_date":"2025-11-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-10 21:38:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"1500 RIVERVIEW DRIVE","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-13T10:30:27.000000Z","updated_at":"2025-11-14T10:30:08.000000Z","inspection_violations":[{"id":16862746,"change_date":"2025-11-10 21:38:00","inspection_id":"86277800","insp_violation_id":"269836794","seq_no":"1","part_no":"393","part_no_section":"55E-B","insp_viol_unit":"2","insp_unit_id":"209930187","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-13T10:30:43.000000Z","updated_at":"2025-11-14T10:30:18.000000Z","normalized_code":"39355EB"}],"inspection_per_units":[{"id":16914129,"change_date":"2025-11-10 21:38:00","inspection_id":"86277800","insp_unit_id":"209930186","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"YTE0249","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"3AKJHTDVXNDNC8670","insp_unit_decal":"Y","insp_unit_decal_number":"35791368","created_at":"2025-11-13T10:00:30.000000Z","updated_at":"2025-11-14T10:00:10.000000Z"},{"id":16914130,"change_date":"2025-11-10 21:38:00","inspection_id":"86277800","insp_unit_id":"209930187","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLAR MFG.","insp_unit_company":null,"insp_unit_license":"9933STU","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1PMA2442145004001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-13T10:00:30.000000Z","updated_at":"2025-11-14T10:00:10.000000Z"}]},{"id":9944098,"change_date":"2025-10-15 21:38:00","inspection_id":"86051300","dot_number":"234407","report_state":"MN","report_number":"0300000482","insp_date":"2025-10-08 00:00:00","insp_start_time":"1115","insp_end_time":"1141","registration_date":null,"region":"CD","ci_status_code":"C","location":"MVRA","location_desc":"LE SUEUR MN","county_code_state":"MN","county_code":"079","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":"331","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-10-15 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2412261","transaction_code":"A","transaction_date":"2025-10-14 00:00:00","upload_date":"2025-10-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00234407","upload_search_indicator":null,"census_search_date":"2025-10-15 21:38:00","snet_input_date":"2025-10-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-15 21:38:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"1500 RIVERVIEW DRIVE","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-18T10:01:38.000000Z","updated_at":"2025-10-19T10:00:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16506375,"change_date":"2025-10-15 21:38:00","inspection_id":"86051300","insp_unit_id":"209473995","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"400","insp_unit_license":"YCE1414","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"2NPMHJ7X0RM661622","insp_unit_decal":"Y","insp_unit_decal_number":"35792018","created_at":"2025-10-18T09:47:02.000000Z","updated_at":"2025-10-19T09:45:07.000000Z"}]},{"id":9873638,"change_date":"2025-10-07 21:40:00","inspection_id":"85976722","dot_number":"234407","report_state":"MN","report_number":"0134000388","insp_date":"2025-09-30 00:00:00","insp_start_time":"1021","insp_end_time":"1040","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"KILKENNY MN","county_code_state":"MN","county_code":"079","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-10-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"35000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2373746","transaction_code":"A","transaction_date":"2025-10-06 00:00:00","upload_date":"2025-10-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00234407","upload_search_indicator":null,"census_search_date":"2025-10-07 21:40:00","snet_input_date":"2025-09-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-07 21:40:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"1500 RIVERVIEW DRIVE","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-10T10:02:15.000000Z","updated_at":"2025-10-11T10:00:25.000000Z","inspection_violations":[{"id":16273411,"change_date":"2025-10-07 21:40:00","inspection_id":"85976722","insp_violation_id":"269139916","seq_no":"1","part_no":"392","part_no_section":"2-SLLS3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-10T10:18:21.000000Z","updated_at":"2025-10-11T10:15:52.000000Z","normalized_code":"3922SLLS3"}],"inspection_per_units":[{"id":16379637,"change_date":"2025-10-07 21:40:00","inspection_id":"85976722","insp_unit_id":"209334490","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"YCE1414","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"2NPMHJ7X0RM661622","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-10T09:47:41.000000Z","updated_at":"2025-10-11T09:45:35.000000Z"}]},{"id":9046442,"change_date":"2025-07-02 21:39:00","inspection_id":"85107461","dot_number":"234407","report_state":"MN","report_number":"0287000897","insp_date":"2025-06-25 00:00:00","insp_start_time":"1348","insp_end_time":"1410","registration_date":null,"region":"CD","ci_status_code":"C","location":"CLKGVN","location_desc":"CLARKS GROVE MN","county_code_state":"MN","county_code":"047","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-07-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"1940276","transaction_code":"A","transaction_date":"2025-07-01 00:00:00","upload_date":"2025-07-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00234407","upload_search_indicator":null,"census_search_date":"2025-07-02 21:39:00","snet_input_date":"2025-06-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-02 21:39:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"1500 RIVERVIEW DRIVE","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-07T10:07:12.000000Z","updated_at":"2025-07-07T10:07:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14840291,"change_date":"2025-07-02 21:39:00","inspection_id":"85107461","insp_unit_id":"207669599","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"YBR3807","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"2NP3LJ0X0GM326071","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-05T09:46:04.000000Z","updated_at":"2025-07-06T09:45:15.000000Z"}]},{"id":8967235,"change_date":"2025-06-24 21:40:00","inspection_id":"85024324","dot_number":"234407","report_state":"MN","report_number":"0073000340","insp_date":"2025-06-17 00:00:00","insp_start_time":"0839","insp_end_time":"0914","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"SAINT PAUL PARK MN","county_code_state":"MN","county_code":"163","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MARATHON","shipping_paper_number":null,"cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-06-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","viol_total":"2","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":"1904989","transaction_code":"A","transaction_date":"2025-06-23 00:00:00","upload_date":"2025-06-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00234407","upload_search_indicator":null,"census_search_date":"2025-06-24 21:40:00","snet_input_date":"2025-06-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-24 21:40:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"1500 RIVERVIEW DRIVE","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-28T10:00:46.000000Z","updated_at":"2025-06-28T10:00:46.000000Z","inspection_violations":[{"id":14407993,"change_date":"2025-06-24 21:40:00","inspection_id":"85024324","insp_violation_id":"267002056","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"207519052","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-06-27T10:17:09.000000Z","updated_at":"2025-06-28T10:16:55.000000Z","normalized_code":"39375A3TAOL"},{"id":14407994,"change_date":"2025-06-24 21:40:00","inspection_id":"85024324","insp_violation_id":"267002057","seq_no":"2","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"207519053","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-06-27T10:17:09.000000Z","updated_at":"2025-06-28T10:16:55.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":14701526,"change_date":"2025-06-24 21:40:00","inspection_id":"85024324","insp_unit_id":"207519052","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"YTE0249","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"3AKJHTDVXNDNC8670","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-27T09:46:31.000000Z","updated_at":"2025-06-28T09:45:16.000000Z"},{"id":14701527,"change_date":"2025-06-24 21:40:00","inspection_id":"85024324","insp_unit_id":"207519053","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLAR MFG.","insp_unit_company":null,"insp_unit_license":"STB0475","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1PMA24427B5009443","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-27T09:46:31.000000Z","updated_at":"2025-06-28T09:45:16.000000Z"}]},{"id":8916794,"change_date":"2025-06-17 21:41:00","inspection_id":"84970628","dot_number":"234407","report_state":"MN","report_number":"0485000538","insp_date":"2025-06-10 00:00:00","insp_start_time":"0723","insp_end_time":"0831","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ORONOCO MN","county_code_state":"MN","county_code":"109","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"242423683","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-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"119220","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1873662","transaction_code":"A","transaction_date":"2025-06-16 00:00:00","upload_date":"2025-06-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00234407","upload_search_indicator":null,"census_search_date":"2025-06-17 21:41:00","snet_input_date":"2025-06-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-17 21:41:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"1500 RIVERVIEW DRIVE","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-20T10:00:52.000000Z","updated_at":"2025-06-22T10:00:21.000000Z","inspection_violations":[{"id":14303042,"change_date":"2025-06-17 21:41:00","inspection_id":"84970628","insp_violation_id":"266882090","seq_no":"1","part_no":"393","part_no_section":"55E-B","insp_viol_unit":"2","insp_unit_id":"207420596","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-20T10:16:29.000000Z","updated_at":"2025-06-21T10:17:12.000000Z","normalized_code":"39355EB"}],"inspection_per_units":[{"id":14612058,"change_date":"2025-06-17 21:41:00","inspection_id":"84970628","insp_unit_id":"207420595","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":"39","insp_unit_license":"YTF0938","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"3BHJBPDV7SDWE6821","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-20T09:46:02.000000Z","updated_at":"2025-06-22T09:45:29.000000Z"},{"id":14612059,"change_date":"2025-06-17 21:41:00","inspection_id":"84970628","insp_unit_id":"207420596","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLAR MFG.","insp_unit_company":"1752","insp_unit_license":"1079STM","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1PMA24529F5014485","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-20T09:46:02.000000Z","updated_at":"2025-06-22T09:45:29.000000Z"}]},{"id":8545085,"change_date":"2025-05-05 21:39:00","inspection_id":"84577962","dot_number":"234407","report_state":"MN","report_number":"0287000763","insp_date":"2025-04-28 00:00:00","insp_start_time":"0955","insp_end_time":"1045","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ROCHESTER MN","county_code_state":"MN","county_code":"109","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":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-05-05 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"57220","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1684602","transaction_code":"A","transaction_date":"2025-05-05 00:00:00","upload_date":"2025-05-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00234407","upload_search_indicator":null,"census_search_date":"2025-05-05 21:39:00","snet_input_date":"2025-04-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-05 21:39:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"1500 RIVERVIEW DRIVE","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-08T10:02:58.000000Z","updated_at":"2025-05-09T10:20:57.000000Z","inspection_violations":[{"id":13537072,"change_date":"2025-05-05 21:39:00","inspection_id":"84577962","insp_violation_id":"266000335","seq_no":"2","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"206637610","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-05-08T10:20:46.000000Z","updated_at":"2025-05-09T10:36:02.000000Z","normalized_code":"39378AWS"},{"id":13537073,"change_date":"2025-05-05 21:39:00","inspection_id":"84577962","insp_violation_id":"266000336","seq_no":"3","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-05-08T10:20:46.000000Z","updated_at":"2025-05-09T10:36:02.000000Z","normalized_code":"3922SLLS2"},{"id":13537074,"change_date":"2025-05-05 21:39:00","inspection_id":"84577962","insp_violation_id":"266000337","seq_no":"1","part_no":"178","part_no_section":"345-6-HMP","insp_viol_unit":"1","insp_unit_id":"206637610","insp_violation_category_id":"37","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-05-08T10:20:46.000000Z","updated_at":"2025-05-09T10:36:02.000000Z","normalized_code":"1783456HMP"}],"inspection_per_units":[{"id":13895339,"change_date":"2025-05-05 21:39:00","inspection_id":"84577962","insp_unit_id":"206637610","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"YBP2538","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1M2AX07Y18M003128","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-08T09:50:50.000000Z","updated_at":"2025-05-09T09:53:04.000000Z"}]},{"id":8260332,"change_date":"2025-07-17 21:41:00","inspection_id":"84277823","dot_number":"234407","report_state":"MN","report_number":"1611000581","insp_date":"2025-03-25 00:00:00","insp_start_time":"1110","insp_end_time":"1146","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"CARLTON MN","county_code_state":"MN","county_code":"017","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-04-01 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":"1537820","transaction_code":"C","transaction_date":"2025-04-01 00:00:00","upload_date":"2025-07-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00234407","upload_search_indicator":null,"census_search_date":"2025-04-01 21:39:00","snet_input_date":"2025-03-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-01 21:39:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"1500 RIVERVIEW DRIVE","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-04T10:20:40.000000Z","updated_at":"2025-07-21T10:42:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15065593,"change_date":"2025-07-17 21:41:00","inspection_id":"84277823","insp_unit_id":"207924808","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"38","insp_unit_license":"YTE5677","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"3AKJHTDV6PSUK2350","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-20T09:46:22.000000Z","updated_at":"2025-07-21T09:45:09.000000Z"},{"id":15065594,"change_date":"2025-07-17 21:41:00","inspection_id":"84277823","insp_unit_id":"207924809","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":"1755","insp_unit_license":"9921STU","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"558MTBR21LK005285","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-20T09:46:22.000000Z","updated_at":"2025-07-21T09:45:09.000000Z"}]},{"id":7743025,"change_date":"2025-01-30 21:40:00","inspection_id":"83733807","dot_number":"234407","report_state":"MN","report_number":"0263000572","insp_date":"2025-01-23 00:00:00","insp_start_time":"1036","insp_end_time":"1059","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"SAVAGE MN","county_code_state":"MN","county_code":"139","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-01-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"58000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1300969","transaction_code":"A","transaction_date":"2025-01-30 00:00:00","upload_date":"2025-01-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00234407","upload_search_indicator":null,"census_search_date":"2025-01-30 21:40:00","snet_input_date":"2025-01-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-30 21:40:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"1500 RIVERVIEW DRIVE","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:59:06.000000Z","updated_at":"2025-03-17T20:59:06.000000Z","inspection_violations":[{"id":12098555,"change_date":"2025-01-30 21:40:00","inspection_id":"83733807","insp_violation_id":"264246657","seq_no":"1","part_no":"392","part_no_section":"16-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:59.000000Z","updated_at":"2025-03-17T22:04:59.000000Z","normalized_code":"39216D"},{"id":12098556,"change_date":"2025-01-30 21:40:00","inspection_id":"83733807","insp_violation_id":"264246658","seq_no":"2","part_no":"392","part_no_section":"2-SLLT","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"882502630049","created_at":"2025-03-17T22:04:59.000000Z","updated_at":"2025-03-17T22:04:59.000000Z","normalized_code":"3922SLLT"}],"inspection_per_units":[{"id":12495302,"change_date":"2025-01-30 21:40:00","inspection_id":"83733807","insp_unit_id":"205072780","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"121","insp_unit_license":"YBV6186","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1FVHCYFE4KHKL1245","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:55.000000Z","updated_at":"2025-03-17T23:52:55.000000Z"}]},{"id":7667655,"change_date":"2025-01-21 21:39:00","inspection_id":"83654892","dot_number":"234407","report_state":"MN","report_number":"2690000339","insp_date":"2025-01-14 00:00:00","insp_start_time":"0900","insp_end_time":"0930","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"LAKE ELMO MN","county_code_state":"MN","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","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":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-01-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1272237","transaction_code":"A","transaction_date":"2025-01-21 00:00:00","upload_date":"2025-01-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00234407","upload_search_indicator":null,"census_search_date":"2025-01-21 21:39:00","snet_input_date":"2025-01-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-21 21:39:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"1500 RIVERVIEW DRIVE","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:57:26.000000Z","updated_at":"2025-03-17T20:57:26.000000Z","inspection_violations":[{"id":11980903,"change_date":"2025-01-21 21:39:00","inspection_id":"83654892","insp_violation_id":"264092402","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"204926388","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"N\/A","created_at":"2025-03-17T22:04:25.000000Z","updated_at":"2025-03-17T22:04:25.000000Z","normalized_code":"3922SLLSR"},{"id":11980904,"change_date":"2025-01-21 21:39:00","inspection_id":"83654892","insp_violation_id":"264092403","seq_no":"2","part_no":"392","part_no_section":"2-SLLTL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:25.000000Z","updated_at":"2025-03-17T22:04:25.000000Z","normalized_code":"3922SLLTL"}],"inspection_per_units":[{"id":12372749,"change_date":"2025-01-21 21:39:00","inspection_id":"83654892","insp_unit_id":"204926387","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLAR MFG.","insp_unit_company":"1749","insp_unit_license":"1837STL","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1PMA24525F5013396","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:32.000000Z","updated_at":"2025-03-17T23:51:32.000000Z"},{"id":12372750,"change_date":"2025-01-21 21:39:00","inspection_id":"83654892","insp_unit_id":"204926388","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"91","insp_unit_license":"PAM0516","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1XP5DB9X3MD303972","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:32.000000Z","updated_at":"2025-03-17T23:51:32.000000Z"}]},{"id":7515442,"change_date":"2024-12-30 21:38:00","inspection_id":"83494940","dot_number":"234407","report_state":"MN","report_number":"0230000095","insp_date":"2024-12-24 00:00:00","insp_start_time":"0723","insp_end_time":"0750","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"ELLENDALE MN","county_code_state":"MN","county_code":"147","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"1075","shipping_paper_number":"1075","cargo_tank":"331","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-12-30 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1202524","transaction_code":"A","transaction_date":"2024-12-30 00:00:00","upload_date":"2024-12-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00234407","upload_search_indicator":null,"census_search_date":"2024-12-30 21:38:00","snet_input_date":"2024-12-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-12-30 21:38:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"1500 RIVERVIEW DRIVE","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:52:43.000000Z","updated_at":"2025-03-17T20:52:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12124738,"change_date":"2024-12-30 21:38:00","inspection_id":"83494940","insp_unit_id":"204584954","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"YCC3619","insp_unit_license":"YCC3619","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1FVACXFEXPHUB4471","insp_unit_decal":"Y","insp_unit_decal_number":"34665205","created_at":"2025-03-17T23:48:50.000000Z","updated_at":"2025-03-17T23:48:50.000000Z"}]},{"id":7324985,"change_date":"2024-12-03 21:39:00","inspection_id":"83294790","dot_number":"234407","report_state":"MN","report_number":"0300000242","insp_date":"2024-11-26 00:00:00","insp_start_time":"1011","insp_end_time":"1058","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"GLENCOE MN","county_code_state":"MN","county_code":"085","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"WSTRN RFNG TERMINAL LLC","shipping_paper_number":"242364440, 2423","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-12-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"119200","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1112940","transaction_code":"A","transaction_date":"2024-12-03 00:00:00","upload_date":"2024-12-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00234407","upload_search_indicator":null,"census_search_date":"2024-12-03 21:39:00","snet_input_date":"2024-11-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-12-03 21:39:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"1500 RIVERVIEW DRIVE","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:48:57.000000Z","updated_at":"2025-03-17T20:48:57.000000Z","inspection_violations":[{"id":11452687,"change_date":"2024-12-03 21:39:00","inspection_id":"83294790","insp_violation_id":"263188223","seq_no":"1","part_no":"178","part_no_section":"345-8A-HMP","insp_viol_unit":"2","insp_unit_id":"204145722","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:41.000000Z","updated_at":"2025-03-17T22:01:41.000000Z","normalized_code":"1783458AHMP"},{"id":11452688,"change_date":"2024-12-03 21:39:00","inspection_id":"83294790","insp_violation_id":"263188224","seq_no":"2","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"2","insp_unit_id":"204145722","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:41.000000Z","updated_at":"2025-03-17T22:01:41.000000Z","normalized_code":"39345DB"},{"id":11452689,"change_date":"2024-12-03 21:39:00","inspection_id":"83294790","insp_violation_id":"263188225","seq_no":"3","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"204145721","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:41.000000Z","updated_at":"2025-03-17T22:01:41.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":11816456,"change_date":"2024-12-03 21:39:00","inspection_id":"83294790","insp_unit_id":"204145721","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"28","insp_unit_license":"YTD5696","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1XKWD49X7KJ240945","insp_unit_decal":"Y","insp_unit_decal_number":"34664095","created_at":"2025-03-17T23:45:30.000000Z","updated_at":"2025-03-17T23:45:30.000000Z"},{"id":11816457,"change_date":"2024-12-03 21:39:00","inspection_id":"83294790","insp_unit_id":"204145722","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLAR MFG.","insp_unit_company":null,"insp_unit_license":"STB0475","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1PMA24427B5009443","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:30.000000Z","updated_at":"2025-03-17T23:45:30.000000Z"}]},{"id":7244538,"change_date":"2024-11-21 21:40:00","inspection_id":"83209845","dot_number":"234407","report_state":"MN","report_number":"0098000187","insp_date":"2024-11-14 00:00:00","insp_start_time":"1127","insp_end_time":"1206","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"ROSEVILLE MN","county_code_state":"MN","county_code":"123","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-11-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"121220","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":"1074871","transaction_code":"A","transaction_date":"2024-11-21 00:00:00","upload_date":"2024-11-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00234407","upload_search_indicator":null,"census_search_date":"2024-11-21 21:40:00","snet_input_date":"2024-11-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-21 21:40:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"1500 RIVERVIEW DRIVE","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:47:15.000000Z","updated_at":"2025-03-17T20:47:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11685175,"change_date":"2024-11-21 21:40:00","inspection_id":"83209845","insp_unit_id":"203981649","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"36","insp_unit_license":"YTE0256","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"3AKJGNDR1NDNP1574","insp_unit_decal":"Y","insp_unit_decal_number":"34664933","created_at":"2025-03-17T23:44:08.000000Z","updated_at":"2025-03-17T23:44:08.000000Z"},{"id":11685176,"change_date":"2024-11-21 21:40:00","inspection_id":"83209845","insp_unit_id":"203981650","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLAR MFG.","insp_unit_company":null,"insp_unit_license":"STB4469","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1PMKA4422P7121781","insp_unit_decal":"Y","insp_unit_decal_number":"34664934","created_at":"2025-03-17T23:44:08.000000Z","updated_at":"2025-03-17T23:44:08.000000Z"}]},{"id":6957889,"change_date":"2024-10-15 21:42:00","inspection_id":"82906008","dot_number":"234407","report_state":"MN","report_number":"0263000391","insp_date":"2024-10-08 00:00:00","insp_start_time":"0927","insp_end_time":"1041","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"SOUTH SAINT PAUL MN","county_code_state":"MN","county_code":"037","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"123","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":"U","pen_cen_match":"I","final_status_date":"2024-10-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"58000","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"946089","transaction_code":"A","transaction_date":"2024-10-15 00:00:00","upload_date":"2024-10-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00234407","upload_search_indicator":null,"census_search_date":"2024-10-15 21:42:00","snet_input_date":"2024-10-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-15 21:42:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"1500 RIVERVIEW DRIVE","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:41:03.000000Z","updated_at":"2025-03-17T20:41:03.000000Z","inspection_violations":[{"id":10848242,"change_date":"2024-10-15 21:42:00","inspection_id":"82906008","insp_violation_id":"262345602","seq_no":"2","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":"882402630566","created_at":"2025-03-17T21:58:35.000000Z","updated_at":"2025-03-17T21:58:35.000000Z","normalized_code":"3922"},{"id":10848243,"change_date":"2024-10-15 21:42:00","inspection_id":"82906008","insp_violation_id":"262345603","seq_no":"3","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":"WARNING","created_at":"2025-03-17T21:58:35.000000Z","updated_at":"2025-03-17T21:58:35.000000Z","normalized_code":"3922"},{"id":10848244,"change_date":"2024-10-15 21:42:00","inspection_id":"82906008","insp_violation_id":"262345604","seq_no":"4","part_no":"173","part_no_section":"24(b)(1)","insp_viol_unit":"1","insp_unit_id":"203406848","insp_violation_category_id":"37","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"NA","created_at":"2025-03-17T21:58:35.000000Z","updated_at":"2025-03-17T21:58:35.000000Z","normalized_code":"17324B1"},{"id":10848245,"change_date":"2024-10-15 21:42:00","inspection_id":"82906008","insp_violation_id":"262345605","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"882402630566","created_at":"2025-03-17T21:58:35.000000Z","updated_at":"2025-03-17T21:58:35.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":11222427,"change_date":"2024-10-15 21:42:00","inspection_id":"82906008","insp_unit_id":"203406848","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"YBY5764","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"3ALHC5DV9KDKA8644","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:11.000000Z","updated_at":"2025-03-17T23:39:11.000000Z"}]},{"id":6364265,"change_date":"2024-08-01 21:40:00","inspection_id":"82273495","dot_number":"234407","report_state":"MN","report_number":"1642000021","insp_date":"2024-07-26 00:00:00","insp_start_time":"1159","insp_end_time":"1312","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"MARSHALL MN","county_code_state":"MN","county_code":"083","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MAGELLEN PIPELINE COMPANY, LP.","shipping_paper_number":"585191","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-08-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","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":"706687","transaction_code":"A","transaction_date":"2024-08-01 00:00:00","upload_date":"2024-08-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00234407","upload_search_indicator":null,"census_search_date":"2024-08-01 21:40:00","snet_input_date":"2024-07-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-01 21:40:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"1500 RIVERVIEW DRIVE","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:29:04.000000Z","updated_at":"2025-03-17T20:29:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10255870,"change_date":"2024-08-01 21:40:00","inspection_id":"82273495","insp_unit_id":"202182244","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"37","insp_unit_license":"YTE5678","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"3AKJHTDVXPSUK2349","insp_unit_decal":"Y","insp_unit_decal_number":"34365160","created_at":"2025-03-17T23:29:15.000000Z","updated_at":"2025-03-17T23:29:15.000000Z"},{"id":10255871,"change_date":"2024-08-01 21:40:00","inspection_id":"82273495","insp_unit_id":"202182245","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLAR MFG.","insp_unit_company":"1750","insp_unit_license":"1854STL","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1PMA24520F5014486","insp_unit_decal":"Y","insp_unit_decal_number":"34365161","created_at":"2025-03-17T23:29:15.000000Z","updated_at":"2025-03-17T23:29:15.000000Z"}]},{"id":6032534,"change_date":"2024-06-20 21:43:00","inspection_id":"81917517","dot_number":"234407","report_state":"MN","report_number":"0485000090","insp_date":"2024-06-14 00:00:00","insp_start_time":"0823","insp_end_time":"0957","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ORONOCO MN","county_code_state":"MN","county_code":"109","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"242310888","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-06-20 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"119200","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"585065","transaction_code":"A","transaction_date":"2024-06-20 00:00:00","upload_date":"2024-06-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00234407","upload_search_indicator":null,"census_search_date":"2024-06-20 21:43:00","snet_input_date":"2024-06-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-06-20 21:43:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"1500 RIVERVIEW DRIVE","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:22:16.000000Z","updated_at":"2025-03-17T20:22:16.000000Z","inspection_violations":[{"id":9358522,"change_date":"2024-06-20 21:43:00","inspection_id":"81917517","insp_violation_id":"260202503","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":"WARNING","created_at":"2025-03-17T21:51:15.000000Z","updated_at":"2025-03-17T21:51:15.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9716301,"change_date":"2024-06-20 21:43:00","inspection_id":"81917517","insp_unit_id":"201497693","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"118","insp_unit_license":"PAS8169","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1XKWD49X0PR256994","insp_unit_decal":"Y","insp_unit_decal_number":"34041906","created_at":"2025-03-17T23:23:41.000000Z","updated_at":"2025-03-17T23:23:41.000000Z"},{"id":9716302,"change_date":"2024-06-20 21:43:00","inspection_id":"81917517","insp_unit_id":"201497694","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLAR MFG.","insp_unit_company":"1747","insp_unit_license":"1803STL","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1PMA24427E5011522","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:41.000000Z","updated_at":"2025-03-17T23:23:41.000000Z"}]},{"id":6002760,"change_date":"2024-06-17 21:42:00","inspection_id":"81885419","dot_number":"234407","report_state":"MN","report_number":"0254000106","insp_date":"2024-06-11 00:00:00","insp_start_time":"1410","insp_end_time":"1507","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"WANAMINGO MN","county_code_state":"MN","county_code":"049","insp_level_id":"1","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":"U","pen_cen_match":"I","final_status_date":"2024-06-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"58740","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":"574597","transaction_code":"A","transaction_date":"2024-06-17 00:00:00","upload_date":"2024-06-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00234407","upload_search_indicator":null,"census_search_date":"2024-06-17 21:42:00","snet_input_date":"2024-06-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-06-17 21:42:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"1500 RIVERVIEW DRIVE","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:21:50.000000Z","updated_at":"2025-03-17T20:21:50.000000Z","inspection_violations":[{"id":9312618,"change_date":"2024-06-17 21:42:00","inspection_id":"81885419","insp_violation_id":"260109813","seq_no":"1","part_no":"178","part_no_section":"345-6","insp_viol_unit":"1","insp_unit_id":"201417123","insp_violation_category_id":"37","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:51:03.000000Z","updated_at":"2025-03-17T21:51:03.000000Z","normalized_code":"1783456"},{"id":9312619,"change_date":"2024-06-17 21:42:00","inspection_id":"81885419","insp_violation_id":"260109814","seq_no":"2","part_no":"107","part_no_section":"620(b)","insp_viol_unit":"1","insp_unit_id":"201417123","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:51:03.000000Z","updated_at":"2025-03-17T21:51:03.000000Z","normalized_code":"107620B"},{"id":9312620,"change_date":"2024-06-17 21:42:00","inspection_id":"81885419","insp_violation_id":"260109815","seq_no":"3","part_no":"173","part_no_section":"24(b)(1)","insp_viol_unit":"1","insp_unit_id":"201417123","insp_violation_category_id":"37","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"WARNING","created_at":"2025-03-17T21:51:03.000000Z","updated_at":"2025-03-17T21:51:03.000000Z","normalized_code":"17324B1"},{"id":9312621,"change_date":"2024-06-17 21:42:00","inspection_id":"81885419","insp_violation_id":"260109816","seq_no":"4","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"201417123","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:51:03.000000Z","updated_at":"2025-03-17T21:51:03.000000Z","normalized_code":"39347E"},{"id":9312622,"change_date":"2024-06-17 21:42:00","inspection_id":"81885419","insp_violation_id":"260109817","seq_no":"5","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"201417123","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:51:03.000000Z","updated_at":"2025-03-17T21:51:03.000000Z","normalized_code":"39353B"},{"id":9312623,"change_date":"2024-06-17 21:42:00","inspection_id":"81885419","insp_violation_id":"260109818","seq_no":"6","part_no":"177","part_no_section":"823(a)","insp_viol_unit":"1","insp_unit_id":"201417123","insp_violation_category_id":"39","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"WARNING","created_at":"2025-03-17T21:51:03.000000Z","updated_at":"2025-03-17T21:51:03.000000Z","normalized_code":"177823A"}],"inspection_per_units":[{"id":9668336,"change_date":"2024-06-17 21:42:00","inspection_id":"81885419","insp_unit_id":"201417123","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"115","insp_unit_license":"YBN7985","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1NPCLP0X6FD269754","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:12.000000Z","updated_at":"2025-03-17T23:23:12.000000Z"}]},{"id":5904817,"change_date":"2024-06-04 21:41:00","inspection_id":"81778979","dot_number":"234407","report_state":"MN","report_number":"0485000068","insp_date":"2024-05-29 00:00:00","insp_start_time":"0718","insp_end_time":"0905","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ORONOCO MN","county_code_state":"MN","county_code":"109","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"242305302","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-06-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"115000","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"536887","transaction_code":"A","transaction_date":"2024-06-04 00:00:00","upload_date":"2024-06-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00234407","upload_search_indicator":null,"census_search_date":"2024-06-04 21:41:00","snet_input_date":"2024-05-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-06-04 21:41:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"1500 RIVERVIEW DRIVE","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:19:49.000000Z","updated_at":"2025-03-17T20:19:49.000000Z","inspection_violations":[{"id":9156707,"change_date":"2024-06-04 21:41:00","inspection_id":"81778979","insp_violation_id":"259883106","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"201215840","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:50:15.000000Z","updated_at":"2025-03-17T21:50:15.000000Z","normalized_code":"39347E"},{"id":9156708,"change_date":"2024-06-04 21:41:00","inspection_id":"81778979","insp_violation_id":"259883107","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"201215840","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:50:15.000000Z","updated_at":"2025-03-17T21:50:15.000000Z","normalized_code":"3963A1"},{"id":9156709,"change_date":"2024-06-04 21:41:00","inspection_id":"81778979","insp_violation_id":"259883108","seq_no":"3","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"201215840","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:50:15.000000Z","updated_at":"2025-03-17T21:50:15.000000Z","normalized_code":"39353B"},{"id":9156710,"change_date":"2024-06-04 21:41:00","inspection_id":"81778979","insp_violation_id":"259883109","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"201215840","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"WARNING","created_at":"2025-03-17T21:50:15.000000Z","updated_at":"2025-03-17T21:50:15.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":9510727,"change_date":"2024-06-04 21:41:00","inspection_id":"81778979","insp_unit_id":"201215840","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"2","insp_unit_license":"PAP8071","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1XKWDB9X08J222039","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:40.000000Z","updated_at":"2025-03-17T23:21:40.000000Z"},{"id":9510728,"change_date":"2024-06-04 21:41:00","inspection_id":"81778979","insp_unit_id":"201215841","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLAR MFG.","insp_unit_company":null,"insp_unit_license":"9732STT","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1PMA2442595008298","insp_unit_decal":"Y","insp_unit_decal_number":"34041896","created_at":"2025-03-17T23:21:40.000000Z","updated_at":"2025-03-17T23:21:40.000000Z"}]},{"id":5864164,"change_date":"2024-05-29 21:40:00","inspection_id":"81734675","dot_number":"234407","report_state":"MN","report_number":"0073000093","insp_date":"2024-05-23 00:00:00","insp_start_time":"0918","insp_end_time":"0953","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"SOUTH SAINT PAUL MN","county_code_state":"MN","county_code":"037","insp_level_id":"1","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":"U","pen_cen_match":"I","final_status_date":"2024-05-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"522875","transaction_code":"A","transaction_date":"2024-05-29 00:00:00","upload_date":"2024-05-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00234407","upload_search_indicator":null,"census_search_date":"2024-05-29 21:40:00","snet_input_date":"2024-05-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-29 21:40:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"1500 RIVERVIEW DRIVE","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:19:03.000000Z","updated_at":"2025-03-17T20:19:03.000000Z","inspection_violations":[{"id":9091772,"change_date":"2024-05-29 21:40:00","inspection_id":"81734675","insp_violation_id":"259781005","seq_no":"1","part_no":"180","part_no_section":"415","insp_viol_unit":"1","insp_unit_id":"201128851","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:56.000000Z","updated_at":"2025-03-17T21:49:56.000000Z","normalized_code":"180415"},{"id":9091773,"change_date":"2024-05-29 21:40:00","inspection_id":"81734675","insp_violation_id":"259781006","seq_no":"2","part_no":"172","part_no_section":"602(c)","insp_viol_unit":"1","insp_unit_id":"201128851","insp_violation_category_id":"38","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:56.000000Z","updated_at":"2025-03-17T21:49:56.000000Z","normalized_code":"172602C"}],"inspection_per_units":[{"id":9444875,"change_date":"2024-05-29 21:40:00","inspection_id":"81734675","insp_unit_id":"201128851","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"YTE0257","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"3AKJGNDR3NDNP1575","insp_unit_decal":"Y","insp_unit_decal_number":"34043309","created_at":"2025-03-17T23:20:58.000000Z","updated_at":"2025-03-17T23:20:58.000000Z"},{"id":9444876,"change_date":"2024-05-29 21:40:00","inspection_id":"81734675","insp_unit_id":"201128852","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLAR MFG.","insp_unit_company":"1751","insp_unit_license":"1896STL","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1PMA24522G5014698","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:58.000000Z","updated_at":"2025-03-17T23:20:58.000000Z"}]},{"id":5832939,"change_date":"2024-05-24 21:38:00","inspection_id":"81701087","dot_number":"234407","report_state":"MN","report_number":"1661000068","insp_date":"2024-05-18 00:00:00","insp_start_time":"0930","insp_end_time":"0948","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"EAGAN MN","county_code_state":"MN","county_code":"037","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","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":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-05-24 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"510503","transaction_code":"A","transaction_date":"2024-05-24 00:00:00","upload_date":"2024-05-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00234407","upload_search_indicator":null,"census_search_date":"2024-05-24 21:38:00","snet_input_date":"2024-05-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-24 21:38:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"1500 RIVERVIEW DRIVE","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:18:17.000000Z","updated_at":"2025-03-17T20:18:17.000000Z","inspection_violations":[{"id":9038535,"change_date":"2024-05-24 21:38:00","inspection_id":"81701087","insp_violation_id":"259706766","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:40.000000Z","updated_at":"2025-03-17T21:49:40.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":9394113,"change_date":"2024-05-24 21:38:00","inspection_id":"81701087","insp_unit_id":"201064993","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"451","insp_unit_license":"YTE7543","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1XP5DU9XX7N885451","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:30.000000Z","updated_at":"2025-03-17T23:20:30.000000Z"},{"id":9394114,"change_date":"2024-05-24 21:38:00","inspection_id":"81701087","insp_unit_id":"201064994","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLAR MFG.","insp_unit_company":"1747","insp_unit_license":"9933STU","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1PMA2442145004001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:30.000000Z","updated_at":"2025-03-17T23:20:30.000000Z"}]},{"id":5582206,"change_date":"2024-04-24 21:41:00","inspection_id":"81428602","dot_number":"234407","report_state":"MN","report_number":"1618000009","insp_date":"2024-04-18 00:00:00","insp_start_time":"1416","insp_end_time":"1431","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ALBERT LEA MN","county_code_state":"MN","county_code":"047","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"2070","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-04-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"119200","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"424043","transaction_code":"A","transaction_date":"2024-04-24 00:00:00","upload_date":"2024-04-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00234407","upload_search_indicator":null,"census_search_date":"2024-04-24 21:41:00","snet_input_date":"2024-04-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-04-24 21:41:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"1500 RIVERVIEW DRIVE","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:28.000000Z","updated_at":"2025-03-17T20:13:28.000000Z","inspection_violations":[{"id":8629466,"change_date":"2024-04-24 21:41:00","inspection_id":"81428602","insp_violation_id":"259098334","seq_no":"1","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"200542752","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:47:48.000000Z","updated_at":"2025-03-17T21:47:48.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":8991895,"change_date":"2024-04-24 21:41:00","inspection_id":"81428602","insp_unit_id":"200542752","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"35","insp_unit_license":"YTE0257","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"3AKJGNDR3NDNP1575","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:40.000000Z","updated_at":"2025-03-17T23:16:40.000000Z"},{"id":8991896,"change_date":"2024-04-24 21:41:00","inspection_id":"81428602","insp_unit_id":"200542753","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLAR MFG.","insp_unit_company":"1751","insp_unit_license":"1896STL","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1PMA24522G5014698","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:40.000000Z","updated_at":"2025-03-17T23:16:40.000000Z"}]},{"id":5307191,"change_date":"2024-03-18 21:38:00","inspection_id":"81128533","dot_number":"234407","report_state":"MN","report_number":"0ACZ003901","insp_date":"2024-03-18 00:00:00","insp_start_time":"0751","insp_end_time":"0828","registration_date":null,"region":"CT","ci_status_code":"C","location":"LKCTY","location_desc":"LAKE CITY","county_code_state":"MN","county_code":"157","insp_level_id":"2","service_center":"MW","census_source_id":"4","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2024-03-18 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","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":"1441075","transaction_code":"A","transaction_date":"2024-03-18 00:00:00","upload_date":"2024-03-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00234407","upload_search_indicator":null,"census_search_date":"2024-03-18 21:38:00","snet_input_date":"2024-03-18 00:00:00","source_office":"3MNS001","mcmis_add_date":"2024-03-18 21:38:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"PO BOX 508","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:07:53.000000Z","updated_at":"2025-03-17T20:07:53.000000Z","inspection_violations":[{"id":8184461,"change_date":"2024-03-18 21:38:00","inspection_id":"81128533","insp_violation_id":"258433806","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:45:34.000000Z","updated_at":"2025-03-17T21:45:34.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8547047,"change_date":"2024-03-18 21:38:00","inspection_id":"81128533","insp_unit_id":"199959424","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"23","insp_unit_license":"YTC7557","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1XKZD49X4GJ481723","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:28.000000Z","updated_at":"2025-03-17T23:12:28.000000Z"},{"id":8547048,"change_date":"2024-03-18 21:38:00","inspection_id":"81128533","insp_unit_id":"199959425","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"1752","insp_unit_license":"1079STM","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1PMA24529F5014485","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:28.000000Z","updated_at":"2025-03-17T23:12:28.000000Z"}]},{"id":4849449,"change_date":"2024-01-17 21:44:00","inspection_id":"80628543","dot_number":"234407","report_state":"MN","report_number":"0AEQ000601","insp_date":"2024-01-17 00:00:00","insp_start_time":"1011","insp_end_time":"1041","registration_date":null,"region":"CT","ci_status_code":"C","location":"GRTFL","location_desc":"GRANITE FALLS","county_code_state":"MN","county_code":"023","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"MAGELLAN PIPELINE CO., LLP","shipping_paper_number":"575721","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":"2024-01-17 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"1","hazmat_oos_total":"0","snet_sequence_id":"1430699","transaction_code":"A","transaction_date":"2024-01-17 00:00:00","upload_date":"2024-01-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00234407","upload_search_indicator":null,"census_search_date":"2024-01-17 21:44:00","snet_input_date":"2024-01-17 00:00:00","source_office":"3MNS001","mcmis_add_date":"2024-01-17 21:44:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"PO BOX 508","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:58:50.000000Z","updated_at":"2025-03-17T19:58:50.000000Z","inspection_violations":[{"id":7476253,"change_date":"2024-01-17 21:44:00","inspection_id":"80628543","insp_violation_id":"257377393","seq_no":"1","part_no":"172","part_no_section":"516(c)(6)","insp_viol_unit":"2","insp_unit_id":"198995865","insp_violation_category_id":"32","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:02.000000Z","updated_at":"2025-03-17T21:42:02.000000Z","normalized_code":"172516C6"}],"inspection_per_units":[{"id":7802579,"change_date":"2024-01-17 21:44:00","inspection_id":"80628543","insp_unit_id":"198995864","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"30","insp_unit_license":"YTD5052","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"3AKJGBDV2KSKR7689","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:44.000000Z","updated_at":"2025-03-17T23:05:44.000000Z"},{"id":7802580,"change_date":"2024-01-17 21:44:00","inspection_id":"80628543","insp_unit_id":"198995865","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":null,"insp_unit_license":"1854STL","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1PMA24520F5014486","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:44.000000Z","updated_at":"2025-03-17T23:05:44.000000Z"}]},{"id":4261936,"change_date":"2023-10-23 21:42:00","inspection_id":"79983101","dot_number":"234407","report_state":"MN","report_number":"00XG003288","insp_date":"2023-10-22 00:00:00","insp_start_time":"1001","insp_end_time":"1013","registration_date":null,"region":"CT","ci_status_code":"C","location":"NRFLD","location_desc":"NORTHFIELD","county_code_state":"MN","county_code":"131","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-10-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1416752","transaction_code":"A","transaction_date":"2023-10-22 00:00:00","upload_date":"2023-10-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00234407","upload_search_indicator":null,"census_search_date":"2023-10-23 21:42:00","snet_input_date":"2023-10-23 00:00:00","source_office":"3MNS001","mcmis_add_date":"2023-10-23 21:42:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"PO BOX 508","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:47:24.000000Z","updated_at":"2025-03-17T19:47:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6854045,"change_date":"2023-10-23 21:42:00","inspection_id":"79983101","insp_unit_id":"197697696","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"YCE1414","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"2NPMHJ7X0RM661622","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:27.000000Z","updated_at":"2025-03-17T22:57:27.000000Z"}]},{"id":4115194,"change_date":"2023-10-03 21:41:00","inspection_id":"79820950","dot_number":"234407","report_state":"MN","report_number":"0ADV001633","insp_date":"2023-10-03 00:00:00","insp_start_time":"0909","insp_end_time":"1000","registration_date":null,"region":"CT","ci_status_code":"C","location":"FLSCL","location_desc":"FOREST LAKE SCALE","county_code_state":"MN","county_code":"003","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"242231292","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":"I","final_status_date":"2023-10-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"1413142","transaction_code":"A","transaction_date":"2023-10-03 00:00:00","upload_date":"2023-10-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00234407","upload_search_indicator":null,"census_search_date":"2023-10-03 21:41:00","snet_input_date":"2023-10-03 00:00:00","source_office":"3MNS001","mcmis_add_date":"2023-10-03 21:41:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"PO BOX 508","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:44:05.000000Z","updated_at":"2025-03-17T19:44:05.000000Z","inspection_violations":[{"id":6366957,"change_date":"2023-10-03 21:41:00","inspection_id":"79820950","insp_violation_id":"255627591","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197373110","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:42.000000Z","updated_at":"2025-03-17T21:36:42.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6616437,"change_date":"2023-10-03 21:41:00","inspection_id":"79820950","insp_unit_id":"197373110","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"38","insp_unit_license":"YTE5677","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"3AKJHTDV6PSUK2350","insp_unit_decal":"Y","insp_unit_decal_number":"33430823","created_at":"2025-03-17T22:55:31.000000Z","updated_at":"2025-03-17T22:55:31.000000Z"},{"id":6616438,"change_date":"2023-10-03 21:41:00","inspection_id":"79820950","insp_unit_id":"197373111","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MAC","insp_unit_company":"1755","insp_unit_license":"9921STU","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"558MTBR21LK005285","insp_unit_decal":"Y","insp_unit_decal_number":"33430824","created_at":"2025-03-17T22:55:31.000000Z","updated_at":"2025-03-17T22:55:31.000000Z"}]},{"id":3723571,"change_date":"2023-08-11 21:39:00","inspection_id":"79384697","dot_number":"234407","report_state":"MN","report_number":"0AED000968","insp_date":"2023-08-11 00:00:00","insp_start_time":"1034","insp_end_time":"1105","registration_date":null,"region":"CT","ci_status_code":"C","location":"WNMNG","location_desc":"WANAMINGO","county_code_state":"MN","county_code":"049","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-08-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"58000","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":"1403496","transaction_code":"A","transaction_date":"2023-08-11 00:00:00","upload_date":"2023-08-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00234407","upload_search_indicator":null,"census_search_date":"2023-08-11 21:39:00","snet_input_date":"2023-08-11 00:00:00","source_office":"3MNS001","mcmis_add_date":"2023-08-11 21:39:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"PO BOX 508","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:28.000000Z","updated_at":"2025-03-17T19:36:28.000000Z","inspection_violations":[{"id":5741916,"change_date":"2023-08-11 21:39:00","inspection_id":"79384697","insp_violation_id":"254604838","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196488652","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:37.000000Z","updated_at":"2025-03-17T21:33:37.000000Z","normalized_code":"3939A"},{"id":5741917,"change_date":"2023-08-11 21:39:00","inspection_id":"79384697","insp_violation_id":"254604839","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196488652","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:37.000000Z","updated_at":"2025-03-17T21:33:37.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":5987226,"change_date":"2023-08-11 21:39:00","inspection_id":"79384697","insp_unit_id":"196488652","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"122","insp_unit_license":"YCD0900","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"3ALHCYD25LDLW9425","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:19.000000Z","updated_at":"2025-03-17T22:50:19.000000Z"}]},{"id":3706313,"change_date":"2023-08-09 21:42:00","inspection_id":"79365552","dot_number":"234407","report_state":"MN","report_number":"0AED000960","insp_date":"2023-08-09 00:00:00","insp_start_time":"1020","insp_end_time":"1107","registration_date":null,"region":"CT","ci_status_code":"C","location":"WNMNG","location_desc":"WANAMINGO","county_code_state":"MN","county_code":"049","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-08-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1","hazmat_oos_total":"0","snet_sequence_id":"1402999","transaction_code":"A","transaction_date":"2023-08-09 00:00:00","upload_date":"2023-08-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00234407","upload_search_indicator":null,"census_search_date":"2023-08-09 21:42:00","snet_input_date":"2023-08-09 00:00:00","source_office":"3MNS001","mcmis_add_date":"2023-08-09 21:42:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"PO BOX 508","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:06.000000Z","updated_at":"2025-03-17T19:36:06.000000Z","inspection_violations":[{"id":5714493,"change_date":"2023-08-09 21:42:00","inspection_id":"79365552","insp_violation_id":"254557877","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:33:27.000000Z","updated_at":"2025-03-17T21:33:27.000000Z","normalized_code":"39216A"},{"id":5714494,"change_date":"2023-08-09 21:42:00","inspection_id":"79365552","insp_violation_id":"254557878","seq_no":"2","part_no":"172","part_no_section":"201(d)","insp_viol_unit":"1","insp_unit_id":"196446477","insp_violation_category_id":"31","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:27.000000Z","updated_at":"2025-03-17T21:33:27.000000Z","normalized_code":"172201D"},{"id":5714495,"change_date":"2023-08-09 21:42:00","inspection_id":"79365552","insp_violation_id":"254557879","seq_no":"3","part_no":"107","part_no_section":"620(b)","insp_viol_unit":"1","insp_unit_id":"196446477","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:27.000000Z","updated_at":"2025-03-17T21:33:27.000000Z","normalized_code":"107620B"}],"inspection_per_units":[{"id":5959189,"change_date":"2023-08-09 21:42:00","inspection_id":"79365552","insp_unit_id":"196446477","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"YCC3619","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1FVACXFEXPHUB4471","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:04.000000Z","updated_at":"2025-03-17T22:50:04.000000Z"}]},{"id":2966282,"change_date":"2023-05-04 21:41:00","inspection_id":"78532388","dot_number":"234407","report_state":"WI","report_number":"2690002076","insp_date":"2023-05-03 00:00:00","insp_start_time":"0552","insp_end_time":"0630","registration_date":null,"region":"CT","ci_status_code":"C","location":"04(32)","location_desc":"CAMPBELL (TOWN)","county_code_state":"WI","county_code":"063","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"MAGELLAN PIPELINE COMPANY, L.P.","shipping_paper_number":"871576","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":"I","final_status_date":"2023-05-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","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":"892774","transaction_code":"A","transaction_date":"2023-05-04 00:00:00","upload_date":"2023-05-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00234407","upload_search_indicator":"M","census_search_date":"2023-05-04 21:41:00","snet_input_date":"2023-05-04 00:00:00","source_office":"3WIS001","mcmis_add_date":"2023-05-04 21:41:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"PO BOX 508","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:21:50.000000Z","updated_at":"2025-03-17T19:21:50.000000Z","inspection_violations":[{"id":4552200,"change_date":"2023-05-04 21:41:00","inspection_id":"78532388","insp_violation_id":"252625239","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"194753490","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:13.000000Z","updated_at":"2025-03-17T21:28:13.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4772988,"change_date":"2023-05-04 21:41:00","inspection_id":"78532388","insp_unit_id":"194753489","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"23","insp_unit_license":"YTC7557","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1XKZD49X4GJ481723","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:37.000000Z","updated_at":"2025-03-17T22:40:37.000000Z"},{"id":4772989,"change_date":"2023-05-04 21:41:00","inspection_id":"78532388","insp_unit_id":"194753490","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":null,"insp_unit_license":"STB0475","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1PMA24427B5009443","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:37.000000Z","updated_at":"2025-03-17T22:40:37.000000Z"}]},{"id":2841862,"change_date":"2023-04-19 21:42:00","inspection_id":"78391697","dot_number":"234407","report_state":"MN","report_number":"0AES000570","insp_date":"2023-04-15 00:00:00","insp_start_time":"0730","insp_end_time":"0756","registration_date":null,"region":"CT","ci_status_code":"C","location":"MNDHT","location_desc":"MENDOTA HEIGHTS","county_code_state":"MN","county_code":"037","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"WATERFORD OIL","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-04-19 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"121220","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1382559","transaction_code":"A","transaction_date":"2023-04-15 00:00:00","upload_date":"2023-04-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00234407","upload_search_indicator":null,"census_search_date":"2023-04-19 21:42:00","snet_input_date":"2023-04-17 00:00:00","source_office":"3MNS001","mcmis_add_date":"2023-04-19 21:42:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"PO BOX 508","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:19:14.000000Z","updated_at":"2025-03-17T19:19:14.000000Z","inspection_violations":[{"id":4359799,"change_date":"2023-04-19 21:42:00","inspection_id":"78391697","insp_violation_id":"252317712","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:27:20.000000Z","updated_at":"2025-03-17T21:27:20.000000Z","normalized_code":"3922"},{"id":4359800,"change_date":"2023-04-19 21:42:00","inspection_id":"78391697","insp_violation_id":"252317713","seq_no":"2","part_no":"395","part_no_section":"24(d)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:20.000000Z","updated_at":"2025-03-17T21:27:20.000000Z","normalized_code":"39524D"}],"inspection_per_units":[{"id":4573530,"change_date":"2023-04-19 21:42:00","inspection_id":"78391697","insp_unit_id":"194475597","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"36","insp_unit_license":"YTE0256","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"3AKJGNDR1NDNP1574","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:04.000000Z","updated_at":"2025-03-17T22:39:04.000000Z"},{"id":4573531,"change_date":"2023-04-19 21:42:00","inspection_id":"78391697","insp_unit_id":"194475598","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"1751","insp_unit_license":"1896STL","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1PMA24522G5014698","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:04.000000Z","updated_at":"2025-03-17T22:39:04.000000Z"}]},{"id":2543862,"change_date":"2023-03-09 21:42:00","inspection_id":"78052572","dot_number":"234407","report_state":"MN","report_number":"00VM007893","insp_date":"2023-03-09 00:00:00","insp_start_time":"0800","insp_end_time":"0835","registration_date":null,"region":"CT","ci_status_code":"C","location":"CRLTN","location_desc":"CARLTON","county_code_state":"MN","county_code":"017","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"242173204","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":"I","final_status_date":"2023-03-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1375533","transaction_code":"A","transaction_date":"2023-03-09 00:00:00","upload_date":"2023-03-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00234407","upload_search_indicator":null,"census_search_date":"2023-03-09 21:42:00","snet_input_date":"2023-03-09 00:00:00","source_office":"3MNS001","mcmis_add_date":"2023-03-09 21:42:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"PO BOX 508","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:13:40.000000Z","updated_at":"2025-03-17T19:13:40.000000Z","inspection_violations":[{"id":3912252,"change_date":"2023-03-09 21:42:00","inspection_id":"78052572","insp_violation_id":"251572337","seq_no":"1","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"193793135","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:21.000000Z","updated_at":"2025-03-17T21:25:21.000000Z","normalized_code":"39360D"},{"id":3912253,"change_date":"2023-03-09 21:42:00","inspection_id":"78052572","insp_violation_id":"251572338","seq_no":"2","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"193793135","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:21.000000Z","updated_at":"2025-03-17T21:25:21.000000Z","normalized_code":"39360C"},{"id":3912254,"change_date":"2023-03-09 21:42:00","inspection_id":"78052572","insp_violation_id":"251572339","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193793135","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:21.000000Z","updated_at":"2025-03-17T21:25:21.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4094466,"change_date":"2023-03-09 21:42:00","inspection_id":"78052572","insp_unit_id":"193793135","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"28","insp_unit_license":"YTD5696","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1XKWD49X7KJ240945","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:20.000000Z","updated_at":"2025-03-17T22:35:20.000000Z"},{"id":4094467,"change_date":"2023-03-09 21:42:00","inspection_id":"78052572","insp_unit_id":"193793136","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MAC","insp_unit_company":"1754","insp_unit_license":"9725STT","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"558MTBR27KK004575","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:20.000000Z","updated_at":"2025-03-17T22:35:20.000000Z"}]},{"id":2155133,"change_date":"2023-01-17 21:42:00","inspection_id":"77609982","dot_number":"234407","report_state":"MN","report_number":"0AEP000355","insp_date":"2023-01-17 00:00:00","insp_start_time":"1304","insp_end_time":"1320","registration_date":null,"region":"CT","ci_status_code":"C","location":"ESTBL","location_desc":"EAST BETHEL","county_code_state":"MN","county_code":"003","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-01-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","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":"1368915","transaction_code":"A","transaction_date":"2023-01-17 00:00:00","upload_date":"2023-01-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00234407","upload_search_indicator":null,"census_search_date":"2023-01-17 21:42:00","snet_input_date":"2023-01-17 00:00:00","source_office":"3MNS001","mcmis_add_date":"2023-01-17 21:42:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"PO BOX 508","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:06:17.000000Z","updated_at":"2025-03-17T19:06:17.000000Z","inspection_violations":[{"id":3330718,"change_date":"2023-01-17 21:42:00","inspection_id":"77609982","insp_violation_id":"250600229","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:22:45.000000Z","updated_at":"2025-03-17T21:22:45.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3467816,"change_date":"2023-01-17 21:42:00","inspection_id":"77609982","insp_unit_id":"192899166","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"28","insp_unit_license":"YTD5696","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1XKWD49X7KJ240945","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:52.000000Z","updated_at":"2025-03-17T22:30:52.000000Z"},{"id":3467817,"change_date":"2023-01-17 21:42:00","inspection_id":"77609982","insp_unit_id":"192899167","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MAC","insp_unit_company":"1754","insp_unit_license":"9725STT","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"558MTBR27KK004575","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:52.000000Z","updated_at":"2025-03-17T22:30:52.000000Z"}]},{"id":1903263,"change_date":"2022-12-08 21:41:00","inspection_id":"77321151","dot_number":"234407","report_state":"MN","report_number":"00XJ003411","insp_date":"2022-12-07 00:00:00","insp_start_time":"1415","insp_end_time":"1434","registration_date":null,"region":"CT","ci_status_code":"C","location":"CLKGV","location_desc":"CLARKS GROVE","county_code_state":"MN","county_code":"047","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"242150696","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-12-08 21:41: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":"1364342","transaction_code":"A","transaction_date":"2022-12-07 00:00:00","upload_date":"2022-12-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00234407","upload_search_indicator":null,"census_search_date":"2022-12-08 21:41:00","snet_input_date":"2022-12-08 00:00:00","source_office":"3MNS001","mcmis_add_date":"2022-12-08 21:41:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"PO BOX 508","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:01:49.000000Z","updated_at":"2025-03-17T19:01:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3062913,"change_date":"2022-12-08 21:41:00","inspection_id":"77321151","insp_unit_id":"192330810","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"YTE0249","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"3AKJHTDVXNDNC8670","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:58.000000Z","updated_at":"2025-03-17T22:27:58.000000Z"},{"id":3062914,"change_date":"2022-12-08 21:41:00","inspection_id":"77321151","insp_unit_id":"192330811","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MACO","insp_unit_company":null,"insp_unit_license":"9921STU","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"558MTBR21LK005285","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:58.000000Z","updated_at":"2025-03-17T22:27:58.000000Z"}]},{"id":1797818,"change_date":"2022-11-29 21:41:00","inspection_id":"77200805","dot_number":"234407","report_state":"MN","report_number":"0ACO000223","insp_date":"2022-11-22 00:00:00","insp_start_time":"1106","insp_end_time":"1152","registration_date":null,"region":"CT","ci_status_code":"C","location":"STCRX","location_desc":"ST. CROIX WEIGH STATION","county_code_state":"MN","county_code":"163","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"MARATHON PETROLEUM COMPANY","shipping_paper_number":"242146857","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-11-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"1","hazmat_oos_total":"0","snet_sequence_id":"1362406","transaction_code":"C","transaction_date":"2022-11-29 00:00:00","upload_date":"2022-11-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00234407","upload_search_indicator":null,"census_search_date":"2022-11-22 21:41:00","snet_input_date":"2022-11-22 00:00:00","source_office":"3MNS001","mcmis_add_date":"2022-11-22 21:41:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"PO BOX 508","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:59:41.000000Z","updated_at":"2025-03-17T18:59:41.000000Z","inspection_violations":[{"id":2810607,"change_date":"2022-11-29 21:41:00","inspection_id":"77200805","insp_violation_id":"249829606","seq_no":"1","part_no":"177","part_no_section":"817(e)","insp_viol_unit":"1","insp_unit_id":"192172469","insp_violation_category_id":"31","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:16.000000Z","updated_at":"2025-03-17T21:20:16.000000Z","normalized_code":"177817E"},{"id":2810608,"change_date":"2022-11-29 21:41:00","inspection_id":"77200805","insp_violation_id":"249829607","seq_no":"2","part_no":"107","part_no_section":"620(b)","insp_viol_unit":"1","insp_unit_id":"192172469","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:16.000000Z","updated_at":"2025-03-17T21:20:16.000000Z","normalized_code":"107620B"}],"inspection_per_units":[{"id":2891771,"change_date":"2022-11-29 21:41:00","inspection_id":"77200805","insp_unit_id":"192172469","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"22","insp_unit_license":"YTC7553","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1XPBDP9X9FD265991","insp_unit_decal":"Y","insp_unit_decal_number":"EARNED","created_at":"2025-03-17T22:26:48.000000Z","updated_at":"2025-03-17T22:26:48.000000Z"},{"id":2891772,"change_date":"2022-11-29 21:41:00","inspection_id":"77200805","insp_unit_id":"192172470","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"1745","insp_unit_license":"9932STU","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1PMA2442595008298","insp_unit_decal":"Y","insp_unit_decal_number":"EARNED","created_at":"2025-03-17T22:26:48.000000Z","updated_at":"2025-03-17T22:26:48.000000Z"}]},{"id":1764498,"change_date":"2022-11-17 21:40:00","inspection_id":"77162414","dot_number":"234407","report_state":"MN","report_number":"0AET000251","insp_date":"2022-11-17 00:00:00","insp_start_time":"1022","insp_end_time":"1142","registration_date":null,"region":"CT","ci_status_code":"C","location":"STCRX","location_desc":"ST. CROIX WEIGH STATION","county_code_state":"MN","county_code":"163","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-11-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"115000","viol_total":"8","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1361620","transaction_code":"A","transaction_date":"2022-11-17 00:00:00","upload_date":"2022-11-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00234407","upload_search_indicator":null,"census_search_date":"2022-11-17 21:40:00","snet_input_date":"2022-11-17 00:00:00","source_office":"3MNS001","mcmis_add_date":"2022-11-17 21:40:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"PO BOX 508","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:59:16.000000Z","updated_at":"2025-03-17T18:59:16.000000Z","inspection_violations":[{"id":2762852,"change_date":"2022-11-17 21:40:00","inspection_id":"77162414","insp_violation_id":"249661917","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192011922","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:00.000000Z","updated_at":"2025-03-17T21:20:00.000000Z","normalized_code":"3922"},{"id":2762853,"change_date":"2022-11-17 21:40:00","inspection_id":"77162414","insp_violation_id":"249661918","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"192011922","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:00.000000Z","updated_at":"2025-03-17T21:20:00.000000Z","normalized_code":"39347E"},{"id":2762854,"change_date":"2022-11-17 21:40:00","inspection_id":"77162414","insp_violation_id":"249661919","seq_no":"3","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"192011922","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:00.000000Z","updated_at":"2025-03-17T21:20:00.000000Z","normalized_code":"39353B"},{"id":2762855,"change_date":"2022-11-17 21:40:00","inspection_id":"77162414","insp_violation_id":"249661920","seq_no":"4","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"192011922","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:00.000000Z","updated_at":"2025-03-17T21:20:00.000000Z","normalized_code":"39345B2"},{"id":2762856,"change_date":"2022-11-17 21:40:00","inspection_id":"77162414","insp_violation_id":"249661921","seq_no":"5","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"192011923","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:20:00.000000Z","updated_at":"2025-03-17T21:20:00.000000Z","normalized_code":"39375A3"},{"id":2762857,"change_date":"2022-11-17 21:40:00","inspection_id":"77162414","insp_violation_id":"249661922","seq_no":"6","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"192011923","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:00.000000Z","updated_at":"2025-03-17T21:20:00.000000Z","normalized_code":"39347E"},{"id":2762858,"change_date":"2022-11-17 21:40:00","inspection_id":"77162414","insp_violation_id":"249661923","seq_no":"7","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"192011923","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:00.000000Z","updated_at":"2025-03-17T21:20:00.000000Z","normalized_code":"39353B"},{"id":2762859,"change_date":"2022-11-17 21:40:00","inspection_id":"77162414","insp_violation_id":"249661924","seq_no":"8","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"192011922","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:20:00.000000Z","updated_at":"2025-03-17T21:20:00.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":2838640,"change_date":"2022-11-17 21:40:00","inspection_id":"77162414","insp_unit_id":"192011922","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"2","insp_unit_license":"PAP8071","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1XKWDB9X08J222039","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:24.000000Z","updated_at":"2025-03-17T22:26:24.000000Z"},{"id":2838641,"change_date":"2022-11-17 21:40:00","inspection_id":"77162414","insp_unit_id":"192011923","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"1743","insp_unit_license":"2897STE","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1PMA2442195008508","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:24.000000Z","updated_at":"2025-03-17T22:26:24.000000Z"}]},{"id":1696521,"change_date":"2022-11-08 21:38:00","inspection_id":"77084424","dot_number":"234407","report_state":"MN","report_number":"0ACH003459","insp_date":"2022-11-05 00:00:00","insp_start_time":"0646","insp_end_time":"0657","registration_date":null,"region":"CT","ci_status_code":"C","location":"MNDHT","location_desc":"MENDOTA HEIGHTS","county_code_state":"MN","county_code":"037","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-11-08 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","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":"1360079","transaction_code":"A","transaction_date":"2022-11-05 00:00:00","upload_date":"2022-11-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00234407","upload_search_indicator":null,"census_search_date":"2022-11-08 21:38:00","snet_input_date":"2022-11-08 00:00:00","source_office":"3MNS001","mcmis_add_date":"2022-11-08 21:38:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"PO BOX 508","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:57:48.000000Z","updated_at":"2025-03-17T18:57:48.000000Z","inspection_violations":[{"id":2658950,"change_date":"2022-11-08 21:38:00","inspection_id":"77084424","insp_violation_id":"249490378","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:19:30.000000Z","updated_at":"2025-03-17T21:19:30.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2729399,"change_date":"2022-11-08 21:38:00","inspection_id":"77084424","insp_unit_id":"191858868","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"35","insp_unit_license":"YTE0257","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"3AKJGNDR3NDNP1575","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:41.000000Z","updated_at":"2025-03-17T22:25:41.000000Z"},{"id":2729400,"change_date":"2022-11-08 21:38:00","inspection_id":"77084424","insp_unit_id":"191858869","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"1751","insp_unit_license":"1896STL","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1PMA24522G5014698","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:41.000000Z","updated_at":"2025-03-17T22:25:41.000000Z"}]},{"id":1647173,"change_date":"2022-11-01 21:40:00","inspection_id":"77028016","dot_number":"234407","report_state":"MN","report_number":"00YS002101","insp_date":"2022-10-31 00:00:00","insp_start_time":"1201","insp_end_time":"1310","registration_date":null,"region":"CT","ci_status_code":"C","location":"RCHTR","location_desc":"ROCHESTER","county_code_state":"MN","county_code":"109","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":"854654","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":"I","final_status_date":"2022-11-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","viol_total":"3","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1359240","transaction_code":"A","transaction_date":"2022-10-31 00:00:00","upload_date":"2022-11-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00234407","upload_search_indicator":null,"census_search_date":"2022-11-01 21:40:00","snet_input_date":"2022-11-01 00:00:00","source_office":"3MNS001","mcmis_add_date":"2022-11-01 21:40:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"PO BOX 508","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:57:03.000000Z","updated_at":"2025-03-17T18:57:03.000000Z","inspection_violations":[{"id":2585070,"change_date":"2022-11-01 21:40:00","inspection_id":"77028016","insp_violation_id":"249369581","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:19:11.000000Z","updated_at":"2025-03-17T21:19:11.000000Z","normalized_code":"3922"},{"id":2585071,"change_date":"2022-11-01 21:40:00","inspection_id":"77028016","insp_violation_id":"249369582","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191748443","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:11.000000Z","updated_at":"2025-03-17T21:19:11.000000Z","normalized_code":"3922"},{"id":2585072,"change_date":"2022-11-01 21:40:00","inspection_id":"77028016","insp_violation_id":"249369583","seq_no":"3","part_no":"393","part_no_section":"110(b)","insp_viol_unit":"2","insp_unit_id":"191748444","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:19:11.000000Z","updated_at":"2025-03-17T21:19:11.000000Z","normalized_code":"393110B"}],"inspection_per_units":[{"id":2650361,"change_date":"2022-11-01 21:40:00","inspection_id":"77028016","insp_unit_id":"191748443","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"23","insp_unit_license":"YTC7557","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1XKZD49X4GJ481723","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:11.000000Z","updated_at":"2025-03-17T22:25:11.000000Z"},{"id":2650362,"change_date":"2022-11-01 21:40:00","inspection_id":"77028016","insp_unit_id":"191748444","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"1752","insp_unit_license":"1079STM","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1PMA24529F5014485","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:11.000000Z","updated_at":"2025-03-17T22:25:11.000000Z"}]},{"id":1581081,"change_date":"2022-10-24 21:40:00","inspection_id":"76952149","dot_number":"234407","report_state":"MN","report_number":"00ZE003235","insp_date":"2022-10-22 00:00:00","insp_start_time":"0950","insp_end_time":"1014","registration_date":null,"region":"CT","ci_status_code":"C","location":"WTRVL","location_desc":"WATERVILLE","county_code_state":"MN","county_code":"079","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":"331","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-10-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1357452","transaction_code":"A","transaction_date":"2022-10-22 00:00:00","upload_date":"2022-10-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00234407","upload_search_indicator":null,"census_search_date":"2022-10-24 21:40:00","snet_input_date":"2022-10-24 00:00:00","source_office":"3MNS001","mcmis_add_date":"2022-10-24 21:40:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"PO BOX 508","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:55:53.000000Z","updated_at":"2025-03-17T18:55:53.000000Z","inspection_violations":[{"id":2484366,"change_date":"2022-10-24 21:40:00","inspection_id":"76952149","insp_violation_id":"249200252","seq_no":"1","part_no":"385","part_no_section":"415(a)(1)","insp_viol_unit":"1","insp_unit_id":"191596927","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:40.000000Z","updated_at":"2025-03-17T21:18:40.000000Z","normalized_code":"385415A1"}],"inspection_per_units":[{"id":2544518,"change_date":"2022-10-24 21:40:00","inspection_id":"76952149","insp_unit_id":"191596927","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"YCC3619","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1FVACXFEXPHUB4471","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:26.000000Z","updated_at":"2025-03-17T22:24:26.000000Z"}]},{"id":1354655,"change_date":"2022-09-23 21:38:00","inspection_id":"76690241","dot_number":"234407","report_state":"MN","report_number":"00XG002967","insp_date":"2022-09-22 00:00:00","insp_start_time":"0832","insp_end_time":"0936","registration_date":null,"region":"CT","ci_status_code":"C","location":"WSECA","location_desc":"WASECA","county_code_state":"MN","county_code":"161","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"WATERFORD OIL CO","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-09-23 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"58000","viol_total":"4","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"2","hazmat_oos_total":"0","snet_sequence_id":"1351822","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":"00234407","upload_search_indicator":null,"census_search_date":"2022-09-23 21:38:00","snet_input_date":"2022-09-23 00:00:00","source_office":"3MNS001","mcmis_add_date":"2022-09-23 21:38:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"PO BOX 508","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:51:39.000000Z","updated_at":"2025-03-17T18:51:39.000000Z","inspection_violations":[{"id":2144160,"change_date":"2022-09-23 21:38:00","inspection_id":"76690241","insp_violation_id":"248612015","seq_no":"1","part_no":"172","part_no_section":"602(c)(1)","insp_viol_unit":"1","insp_unit_id":"191067831","insp_violation_category_id":"38","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:49.000000Z","updated_at":"2025-03-17T21:16:49.000000Z","normalized_code":"172602C1"},{"id":2144161,"change_date":"2022-09-23 21:38:00","inspection_id":"76690241","insp_violation_id":"248612016","seq_no":"2","part_no":"177","part_no_section":"817(e)","insp_viol_unit":"1","insp_unit_id":"191067831","insp_violation_category_id":"31","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:49.000000Z","updated_at":"2025-03-17T21:16:49.000000Z","normalized_code":"177817E"},{"id":2144162,"change_date":"2022-09-23 21:38:00","inspection_id":"76690241","insp_violation_id":"248612017","seq_no":"3","part_no":"180","part_no_section":"407(a)","insp_viol_unit":"1","insp_unit_id":"191067831","insp_violation_category_id":"35","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:49.000000Z","updated_at":"2025-03-17T21:16:49.000000Z","normalized_code":"180407A"},{"id":2144163,"change_date":"2022-09-23 21:38:00","inspection_id":"76690241","insp_violation_id":"248612018","seq_no":"4","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:16:49.000000Z","updated_at":"2025-03-17T21:16:49.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2181235,"change_date":"2022-09-23 21:38:00","inspection_id":"76690241","insp_unit_id":"191067831","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"123","insp_unit_license":"YBY5764","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"3ALHC5DV9KDKA8644","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:56.000000Z","updated_at":"2025-03-17T22:21:56.000000Z"}]},{"id":1205981,"change_date":"2022-09-02 21:39:00","inspection_id":"76517518","dot_number":"234407","report_state":"MN","report_number":"0ACT001880","insp_date":"2022-09-01 00:00:00","insp_start_time":"1622","insp_end_time":"1707","registration_date":null,"region":"CT","ci_status_code":"C","location":"ARDHL","location_desc":"ARDEN HILLS","county_code_state":"MN","county_code":"123","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"NA","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-09-02 21:39:00","post_acc_ind":"Y","gross_comb_veh_wt":"58000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"1","hazmat_oos_total":"0","snet_sequence_id":"1348559","transaction_code":"A","transaction_date":"2022-09-01 00:00:00","upload_date":"2022-09-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00234407","upload_search_indicator":null,"census_search_date":"2022-09-02 21:39:00","snet_input_date":"2022-09-02 00:00:00","source_office":"3MNS001","mcmis_add_date":"2022-09-02 21:39:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"PO BOX 508","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:48:57.000000Z","updated_at":"2025-03-17T18:48:57.000000Z","inspection_violations":[{"id":1912422,"change_date":"2022-09-02 21:39:00","inspection_id":"76517518","insp_violation_id":"248197361","seq_no":"1","part_no":"177","part_no_section":"817(e)","insp_viol_unit":"1","insp_unit_id":"190708880","insp_violation_category_id":"31","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:49.000000Z","updated_at":"2025-03-17T21:15:49.000000Z","normalized_code":"177817E"},{"id":1912423,"change_date":"2022-09-02 21:39:00","inspection_id":"76517518","insp_violation_id":"248197362","seq_no":"2","part_no":"396","part_no_section":"7","insp_viol_unit":"1","insp_unit_id":"190708880","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:49.000000Z","updated_at":"2025-03-17T21:15:49.000000Z","normalized_code":"3967"}],"inspection_per_units":[{"id":1939439,"change_date":"2022-09-02 21:39:00","inspection_id":"76517518","insp_unit_id":"190708880","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"120","insp_unit_license":"YBR3844","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1FVHCYFE0JHJU6658","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:19.000000Z","updated_at":"2025-03-17T22:20:19.000000Z"}]},{"id":1134078,"change_date":"2022-08-25 21:42:00","inspection_id":"76434116","dot_number":"234407","report_state":"IA","report_number":"000TT66GJ8","insp_date":"2022-08-24 00:00:00","insp_start_time":"1510","insp_end_time":"1530","registration_date":null,"region":"CT","ci_status_code":"C","location":"15","location_desc":"15 - I380 NB MM 51 BRANDON","county_code_state":"IA","county_code":"019","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"IRE","shipping_paper_number":"4052219650","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-08-25 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","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":"1238898","transaction_code":"A","transaction_date":"2022-08-25 00:00:00","upload_date":"2022-08-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00234407","upload_search_indicator":"M","census_search_date":"2022-08-25 21:42:00","snet_input_date":"2022-08-24 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-08-25 21:42:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"1500 RIVERVIEW DRIVE","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:47:36.000000Z","updated_at":"2025-03-17T18:47:36.000000Z","inspection_violations":[{"id":1792254,"change_date":"2022-08-25 21:42:00","inspection_id":"76434116","insp_violation_id":"247991856","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:15:19.000000Z","updated_at":"2025-03-17T21:15:19.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1823882,"change_date":"2022-08-25 21:42:00","inspection_id":"76434116","insp_unit_id":"190540281","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"28","insp_unit_license":"YTD5696","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1XKWD49X7KJ240945","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:33.000000Z","updated_at":"2025-03-17T22:19:33.000000Z"},{"id":1823883,"change_date":"2022-08-25 21:42:00","inspection_id":"76434116","insp_unit_id":"190540282","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MAC","insp_unit_company":"1754","insp_unit_license":"9725STT","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"558MTBR27KK004575","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:33.000000Z","updated_at":"2025-03-17T22:19:33.000000Z"}]},{"id":1062655,"change_date":"2022-08-17 21:40:00","inspection_id":"76350874","dot_number":"234407","report_state":"IA","report_number":"000TT85SBG","insp_date":"2022-08-16 00:00:00","insp_start_time":"1355","insp_end_time":"1415","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 63 LIME SPRINGS","county_code_state":"IA","county_code":"089","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"IOWA RENEWABLE ENERGY","shipping_paper_number":"4052219659","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-08-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"1237920","transaction_code":"A","transaction_date":"2022-08-17 00:00:00","upload_date":"2022-08-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00234407","upload_search_indicator":"M","census_search_date":"2022-08-17 21:40:00","snet_input_date":"2022-08-16 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-08-17 21:40:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"1500 RIVERVIEW DRIVE","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:46:30.000000Z","updated_at":"2025-03-17T18:46:30.000000Z","inspection_violations":[{"id":1676949,"change_date":"2022-08-17 21:40:00","inspection_id":"76350874","insp_violation_id":"247789313","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190370322","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:49.000000Z","updated_at":"2025-03-17T21:14:49.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1709865,"change_date":"2022-08-17 21:40:00","inspection_id":"76350874","insp_unit_id":"190370321","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"1752","insp_unit_license":"1079STM","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1PMA24529F5014485","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:46.000000Z","updated_at":"2025-03-17T22:18:46.000000Z"},{"id":1709866,"change_date":"2022-08-17 21:40:00","inspection_id":"76350874","insp_unit_id":"190370322","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"23","insp_unit_license":"YTC7557","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1XKZD49X4GJ481723","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:46.000000Z","updated_at":"2025-03-17T22:18:46.000000Z"}]},{"id":971713,"change_date":"2022-08-05 21:40:00","inspection_id":"76244681","dot_number":"234407","report_state":"IA","report_number":"000TT6JGS8","insp_date":"2022-08-04 00:00:00","insp_start_time":"0745","insp_end_time":"0815","registration_date":null,"region":"CT","ci_status_code":"C","location":"16","location_desc":"16 - I380 SB MM 53 BRANDON","county_code_state":"IA","county_code":"019","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"WSTRN RFNG TERMINALS LLC","shipping_paper_number":"242117385","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":"120000","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":"1","hazmat_oos_total":"0","snet_sequence_id":"1236315","transaction_code":"A","transaction_date":"2022-08-05 00:00:00","upload_date":"2022-08-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00234407","upload_search_indicator":"M","census_search_date":"2022-08-05 21:40:00","snet_input_date":"2022-08-04 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-08-05 21:40:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"1500 RIVERVIEW DRIVE","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","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":1532599,"change_date":"2022-08-05 21:40:00","inspection_id":"76244681","insp_violation_id":"247539454","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:14:14.000000Z","updated_at":"2025-03-17T21:14:14.000000Z","normalized_code":"3922"},{"id":1532600,"change_date":"2022-08-05 21:40:00","inspection_id":"76244681","insp_violation_id":"247539455","seq_no":"2","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"190154329","insp_violation_category_id":"16","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":"39355E"},{"id":1532601,"change_date":"2022-08-05 21:40:00","inspection_id":"76244681","insp_violation_id":"247539456","seq_no":"3","part_no":"177","part_no_section":"817(e)","insp_viol_unit":"1","insp_unit_id":"190154328","insp_violation_category_id":"31","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":"177817E"}],"inspection_per_units":[{"id":1563457,"change_date":"2022-08-05 21:40:00","inspection_id":"76244681","insp_unit_id":"190154328","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"28","insp_unit_license":"YTD5696","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1XKWD49X7KJ240945","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:50.000000Z","updated_at":"2025-03-17T22:17:50.000000Z"},{"id":1563458,"change_date":"2022-08-05 21:40:00","inspection_id":"76244681","insp_unit_id":"190154329","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MAC","insp_unit_company":"1754","insp_unit_license":"9725STT","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"558MTBR27KK004575","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:50.000000Z","updated_at":"2025-03-17T22:17:50.000000Z"}]},{"id":957696,"change_date":"2022-08-03 21:42:00","inspection_id":"76228295","dot_number":"234407","report_state":"WI","report_number":"2641006132","insp_date":"2022-08-02 00:00:00","insp_start_time":"0757","insp_end_time":"0816","registration_date":null,"region":"CT","ci_status_code":"C","location":"S63","location_desc":"MENOMONIE SWEF","county_code_state":"WI","county_code":"033","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"F","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":"I","final_status_date":"2022-08-03 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","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":"867704","transaction_code":"A","transaction_date":"2022-08-03 00:00:00","upload_date":"2022-08-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00234407","upload_search_indicator":"M","census_search_date":"2022-08-03 21:42:00","snet_input_date":"2022-08-03 00:00:00","source_office":"3WIS001","mcmis_add_date":"2022-08-03 21:42:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"PO BOX 508","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:44:27.000000Z","updated_at":"2025-03-17T18:44:27.000000Z","inspection_violations":[{"id":1509039,"change_date":"2022-08-03 21:42:00","inspection_id":"76228295","insp_violation_id":"247494131","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"190118821","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:09.000000Z","updated_at":"2025-03-17T21:14:09.000000Z","normalized_code":"39395A"},{"id":1509040,"change_date":"2022-08-03 21:42:00","inspection_id":"76228295","insp_violation_id":"247494132","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190118821","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:09.000000Z","updated_at":"2025-03-17T21:14:09.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1541114,"change_date":"2022-08-03 21:42:00","inspection_id":"76228295","insp_unit_id":"190118821","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"YTE0248","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1XKWD40X3JJ219957","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:42.000000Z","updated_at":"2025-03-17T22:17:42.000000Z"},{"id":1541115,"change_date":"2022-08-03 21:42:00","inspection_id":"76228295","insp_unit_id":"190118822","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":null,"insp_unit_license":"9917STU","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1PMA24426D5010943","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:42.000000Z","updated_at":"2025-03-17T22:17:42.000000Z"}]},{"id":660639,"change_date":"2022-06-21 21:42:00","inspection_id":"75880214","dot_number":"234407","report_state":"MN","report_number":"00YU003079","insp_date":"2022-06-21 00:00:00","insp_start_time":"1316","insp_end_time":"1403","registration_date":null,"region":"CT","ci_status_code":"C","location":"BFFLK","location_desc":"BUFFALO LAKE","county_code_state":"MN","county_code":"129","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"BUSHMILL ETHANOL INC.","shipping_paper_number":"850006763","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":"I","final_status_date":"2022-06-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","viol_total":"6","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"3","hazmat_oos_total":"0","snet_sequence_id":"1335079","transaction_code":"A","transaction_date":"2022-06-21 00:00:00","upload_date":"2022-06-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00234407","upload_search_indicator":null,"census_search_date":"2022-06-21 21:42:00","snet_input_date":"2022-06-21 00:00:00","source_office":"3MNS001","mcmis_add_date":"2022-06-21 21:42:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"PO BOX 508","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:39:28.000000Z","updated_at":"2025-03-17T18:39:28.000000Z","inspection_violations":[{"id":1039432,"change_date":"2022-06-21 21:42:00","inspection_id":"75880214","insp_violation_id":"246621269","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":"882204390169","created_at":"2025-03-17T21:11:50.000000Z","updated_at":"2025-03-17T21:11:50.000000Z","normalized_code":"39216A"},{"id":1039433,"change_date":"2022-06-21 21:42:00","inspection_id":"75880214","insp_violation_id":"246621270","seq_no":"2","part_no":"177","part_no_section":"817(e)","insp_viol_unit":"1","insp_unit_id":"189380116","insp_violation_category_id":"31","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:50.000000Z","updated_at":"2025-03-17T21:11:50.000000Z","normalized_code":"177817E"},{"id":1039434,"change_date":"2022-06-21 21:42:00","inspection_id":"75880214","insp_violation_id":"246621271","seq_no":"3","part_no":"172","part_no_section":"602(c)(1)","insp_viol_unit":"1","insp_unit_id":"189380116","insp_violation_category_id":"38","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:50.000000Z","updated_at":"2025-03-17T21:11:50.000000Z","normalized_code":"172602C1"},{"id":1039435,"change_date":"2022-06-21 21:42:00","inspection_id":"75880214","insp_violation_id":"246621272","seq_no":"4","part_no":"172","part_no_section":"328(d)","insp_viol_unit":"2","insp_unit_id":"189380117","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:50.000000Z","updated_at":"2025-03-17T21:11:50.000000Z","normalized_code":"172328D"},{"id":1039436,"change_date":"2022-06-21 21:42:00","inspection_id":"75880214","insp_violation_id":"246621273","seq_no":"5","part_no":"393","part_no_section":"55(d)(3)","insp_viol_unit":"2","insp_unit_id":"189380117","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:50.000000Z","updated_at":"2025-03-17T21:11:50.000000Z","normalized_code":"39355D3"},{"id":1039437,"change_date":"2022-06-21 21:42:00","inspection_id":"75880214","insp_violation_id":"246621274","seq_no":"6","part_no":"107","part_no_section":"620(b)","insp_viol_unit":"1","insp_unit_id":"189380116","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:50.000000Z","updated_at":"2025-03-17T21:11:50.000000Z","normalized_code":"107620B"}],"inspection_per_units":[{"id":1061849,"change_date":"2022-06-21 21:42:00","inspection_id":"75880214","insp_unit_id":"189380116","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"18","insp_unit_license":"YTC4011","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1XPVDP9X4ED224809","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:44.000000Z","updated_at":"2025-03-17T22:14:44.000000Z"},{"id":1061850,"change_date":"2022-06-21 21:42:00","inspection_id":"75880214","insp_unit_id":"189380117","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"1745","insp_unit_license":"9932STU","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1PMA2442595008298","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:44.000000Z","updated_at":"2025-03-17T22:14:44.000000Z"}]},{"id":558680,"change_date":"2022-06-07 21:38:00","inspection_id":"75758806","dot_number":"234407","report_state":"MN","report_number":"0ACZ002073","insp_date":"2022-06-07 00:00:00","insp_start_time":"0419","insp_end_time":"0520","registration_date":null,"region":"CT","ci_status_code":"C","location":"RCHTR","location_desc":"ROCHESTER","county_code_state":"MN","county_code":"109","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-06-07 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","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":"1332456","transaction_code":"A","transaction_date":"2022-06-07 00:00:00","upload_date":"2022-06-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00234407","upload_search_indicator":null,"census_search_date":"2022-06-07 21:38:00","snet_input_date":"2022-06-07 00:00:00","source_office":"3MNS001","mcmis_add_date":"2022-06-07 21:38:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"PO BOX 508","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:37:29.000000Z","updated_at":"2025-03-17T18:37:29.000000Z","inspection_violations":[{"id":877933,"change_date":"2022-06-07 21:38:00","inspection_id":"75758806","insp_violation_id":"246286724","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:07.000000Z","updated_at":"2025-03-17T21:11:07.000000Z","normalized_code":"3922"},{"id":877934,"change_date":"2022-06-07 21:38:00","inspection_id":"75758806","insp_violation_id":"246286725","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"189102231","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:07.000000Z","updated_at":"2025-03-17T21:11:07.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":898895,"change_date":"2022-06-07 21:38:00","inspection_id":"75758806","insp_unit_id":"189102230","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"23","insp_unit_license":"YTC7557","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1XKZD49X4GJ481723","insp_unit_decal":"Y","insp_unit_decal_number":"31347101","created_at":"2025-03-17T22:13:44.000000Z","updated_at":"2025-03-17T22:13:44.000000Z"},{"id":898896,"change_date":"2022-06-07 21:38:00","inspection_id":"75758806","insp_unit_id":"189102231","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"1752","insp_unit_license":"1079STM","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1PMA24529F5014485","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:44.000000Z","updated_at":"2025-03-17T22:13:44.000000Z"}]},{"id":539920,"change_date":"2022-06-03 21:40:00","inspection_id":"75736794","dot_number":"234407","report_state":"MN","report_number":"0ACH003208","insp_date":"2022-06-02 00:00:00","insp_start_time":"1800","insp_end_time":"1853","registration_date":null,"region":"CT","ci_status_code":"C","location":"STCRX","location_desc":"ST. CROIX WEIGH STATION","county_code_state":"MN","county_code":"163","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"F","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":"I","final_status_date":"2022-06-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"121220","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"1","hazmat_oos_total":"0","snet_sequence_id":"1331980","transaction_code":"A","transaction_date":"2022-06-02 00:00:00","upload_date":"2022-06-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00234407","upload_search_indicator":null,"census_search_date":"2022-06-03 21:40:00","snet_input_date":"2022-06-03 00:00:00","source_office":"3MNS001","mcmis_add_date":"2022-06-03 21:40:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"PO BOX 508","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:37:06.000000Z","updated_at":"2025-03-17T18:37:06.000000Z","inspection_violations":[{"id":852725,"change_date":"2022-06-03 21:40:00","inspection_id":"75736794","insp_violation_id":"246240428","seq_no":"1","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"189057457","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:02.000000Z","updated_at":"2025-03-17T21:11:02.000000Z","normalized_code":"39355E"},{"id":852726,"change_date":"2022-06-03 21:40:00","inspection_id":"75736794","insp_violation_id":"246240429","seq_no":"2","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"189057457","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:02.000000Z","updated_at":"2025-03-17T21:11:02.000000Z","normalized_code":"39375C"},{"id":852727,"change_date":"2022-06-03 21:40:00","inspection_id":"75736794","insp_violation_id":"246240430","seq_no":"3","part_no":"178","part_no_section":"345-11(b)(1)","insp_viol_unit":"2","insp_unit_id":"189057457","insp_violation_category_id":"36","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:02.000000Z","updated_at":"2025-03-17T21:11:02.000000Z","normalized_code":"17834511B1"}],"inspection_per_units":[{"id":868884,"change_date":"2022-06-03 21:40:00","inspection_id":"75736794","insp_unit_id":"189057456","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"36","insp_unit_license":"YTE0256","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"3AKJGNDR1NDNP1574","insp_unit_decal":"Y","insp_unit_decal_number":"31348943","created_at":"2025-03-17T22:13:33.000000Z","updated_at":"2025-03-17T22:13:33.000000Z"},{"id":868885,"change_date":"2022-06-03 21:40:00","inspection_id":"75736794","insp_unit_id":"189057457","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":null,"insp_unit_license":"9933STU","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1PMA2442145004001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:33.000000Z","updated_at":"2025-03-17T22:13:33.000000Z"}]},{"id":472851,"change_date":"2022-05-24 21:43:00","inspection_id":"75656978","dot_number":"234407","report_state":"MN","report_number":"00XJ003168","insp_date":"2022-05-24 00:00:00","insp_start_time":"0805","insp_end_time":"0824","registration_date":null,"region":"CT","ci_status_code":"C","location":"DNDS","location_desc":"DUNDAS","county_code_state":"MN","county_code":"131","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"TANK","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-24 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"58000","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":"1330471","transaction_code":"A","transaction_date":"2022-05-24 00:00:00","upload_date":"2022-05-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00234407","upload_search_indicator":null,"census_search_date":"2022-05-24 21:43:00","snet_input_date":"2022-05-24 00:00:00","source_office":"3MNS001","mcmis_add_date":"2022-05-24 21:43:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"PO BOX 508","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:35:59.000000Z","updated_at":"2025-03-17T18:35:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":760310,"change_date":"2022-05-24 21:43:00","inspection_id":"75656978","insp_unit_id":"188884952","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"122","insp_unit_license":"YBY5763","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"3ALHCYD25LDLW9425","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:53.000000Z","updated_at":"2025-03-17T22:12:53.000000Z"}]},{"id":146621,"change_date":"2022-04-11 21:41:00","inspection_id":"75267746","dot_number":"234407","report_state":"MN","report_number":"0ACG002102","insp_date":"2022-04-11 00:00:00","insp_start_time":"0849","insp_end_time":"0910","registration_date":null,"region":"CT","ci_status_code":"C","location":"MPLGV","location_desc":"MAPLE GROVE","county_code_state":"MN","county_code":"053","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-04-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"133220","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":"1322974","transaction_code":"A","transaction_date":"2022-04-11 00:00:00","upload_date":"2022-04-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00234407","upload_search_indicator":null,"census_search_date":"2022-04-11 21:41:00","snet_input_date":"2022-04-11 00:00:00","source_office":"3MNS001","mcmis_add_date":"2022-04-11 21:41:00","insp_carrier_name":"WATERFORD OIL CO INC","insp_carrier_street":"PO BOX 508","insp_carrier_city":"NORTHFIELD","insp_carrier_state":"MN","insp_carrier_zip_code":"55057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:30:08.000000Z","updated_at":"2025-03-17T18:30:08.000000Z","inspection_violations":[{"id":216806,"change_date":"2022-04-11 21:41:00","inspection_id":"75267746","insp_violation_id":"245072852","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:08:01.000000Z","updated_at":"2025-03-17T21:08:01.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":237517,"change_date":"2022-04-11 21:41:00","inspection_id":"75267746","insp_unit_id":"188083276","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"29","insp_unit_license":"YTD3841","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"3AKJGBDV0KSKR7688","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:38.000000Z","updated_at":"2025-03-17T22:09:38.000000Z"},{"id":237518,"change_date":"2022-04-11 21:41:00","inspection_id":"75267746","insp_unit_id":"188083277","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"1747","insp_unit_license":"1803STL","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1PMA24427E5011522","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:38.000000Z","updated_at":"2025-03-17T22:09:38.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/234407\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/234407\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/234407\/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\/234407\/inspections","per_page":100,"prev_page_url":null,"to":60,"total":60}