{"current_page":1,"data":[{"id":12065983,"change_date":"2026-06-01 21:41:00","inspection_id":"88007929","dot_number":"1470307","report_state":"SD","report_number":"1620001440","insp_date":"2026-06-01 00:00:00","insp_start_time":"0815","insp_end_time":"0835","registration_date":null,"region":"CD","ci_status_code":"C","location":"SUFLSW","location_desc":"VALLEY SPRINGS SD","county_code_state":"SD","county_code":"099","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SELF","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-01 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"38000","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":"3440905","transaction_code":"A","transaction_date":"2026-06-01 00:00:00","upload_date":"2026-06-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01470307","upload_search_indicator":null,"census_search_date":"2026-06-01 21:41:00","snet_input_date":"2026-06-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-01 21:41:00","insp_carrier_name":"B&B GAS PIPING PLUS LLC","insp_carrier_street":"1210 EAST 12TH STREET","insp_carrier_city":"FAIRMONT","insp_carrier_state":"MN","insp_carrier_zip_code":"56031","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-05T09:39:03.000000Z","updated_at":"2026-06-12T09:30:54.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20969455,"change_date":"2026-06-01 21:41:00","inspection_id":"88007929","insp_unit_id":"213849892","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"YCJ8746","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1GT4UTEY6TF202008","insp_unit_decal":"Y","insp_unit_decal_number":"36437780","created_at":"2026-06-05T09:15:33.000000Z","updated_at":"2026-06-12T09:02:21.000000Z"},{"id":20969456,"change_date":"2026-06-01 21:41:00","inspection_id":"88007929","insp_unit_id":"213849893","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNKNOWN","insp_unit_company":null,"insp_unit_license":"CSV6660","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1J9BS3239TH030006","insp_unit_decal":"Y","insp_unit_decal_number":"36437781","created_at":"2026-06-05T09:15:33.000000Z","updated_at":"2026-06-12T09:02:21.000000Z"}]},{"id":10776771,"change_date":"2026-01-15 21:41:00","inspection_id":"86802275","dot_number":"1470307","report_state":"SD","report_number":"5380000066","insp_date":"2026-01-12 00:00:00","insp_start_time":"0750","insp_end_time":"0833","registration_date":null,"region":"CS","ci_status_code":"C","location":"SUFLSW","location_desc":"VALLEY SPRINGS SD","county_code_state":"SD","county_code":"099","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"B&B","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-01-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"41100","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":"2770585","transaction_code":"A","transaction_date":"2026-01-15 00:00:00","upload_date":"2026-01-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01470307","upload_search_indicator":null,"census_search_date":"2026-01-15 21:41:00","snet_input_date":"2026-01-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-15 21:41:00","insp_carrier_name":"B&B GAS PIPING PLUS LLC","insp_carrier_street":"1210 EAST 12TH STREET","insp_carrier_city":"FAIRMONT","insp_carrier_state":"MN","insp_carrier_zip_code":"56031","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-18T10:45:04.000000Z","updated_at":"2026-01-26T10:30:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18092787,"change_date":"2026-01-15 21:41:00","inspection_id":"86802275","insp_unit_id":"211106697","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"YBZ3132","insp_unit_license_state":"MS","insp_unit_vehicle_id_number":"1GT49TEY3MF118764","insp_unit_decal":"Y","insp_unit_decal_number":"36109541","created_at":"2026-01-18T10:16:53.000000Z","updated_at":"2026-01-26T10:00:47.000000Z"},{"id":18092788,"change_date":"2026-01-15 21:41:00","inspection_id":"86802275","insp_unit_id":"211106698","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"NEVADA AIR","insp_unit_company":null,"insp_unit_license":"CSK5369","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"5JWTC2832RN587651","insp_unit_decal":"Y","insp_unit_decal_number":"36109541","created_at":"2026-01-18T10:16:53.000000Z","updated_at":"2026-01-26T10:00:47.000000Z"}]},{"id":9643817,"change_date":"2025-09-10 21:40:00","inspection_id":"85735534","dot_number":"1470307","report_state":"IA","report_number":"000P120F3Q","insp_date":"2025-09-08 00:00:00","insp_start_time":"1158","insp_end_time":"1215","registration_date":null,"region":"CT","ci_status_code":"C","location":"39","location_desc":"39 - I35 SB MM 212 NORTHWOOD","county_code_state":"IA","county_code":"195","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"B&B GAS PIPING PLUS LLC","shipping_paper_number":"SELF","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":"2025-09-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"40000","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":"1373933","transaction_code":"A","transaction_date":"2025-09-10 00:00:00","upload_date":"2025-09-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01470307","upload_search_indicator":"M","census_search_date":"2025-09-10 21:40:00","snet_input_date":"2025-09-08 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-09-10 21:40:00","insp_carrier_name":"B&B GAS PIPING PLUS LLC","insp_carrier_street":"1210 EAST 12TH STREET","insp_carrier_city":"FAIRMONT","insp_carrier_state":"MN","insp_carrier_zip_code":"56031","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-13T10:47:37.000000Z","updated_at":"2025-09-13T10:47:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15933984,"change_date":"2025-09-10 21:40:00","inspection_id":"85735534","insp_unit_id":"208851378","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"142","insp_unit_license":"YCB8122","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1GT49TEY5NF177364","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-13T10:00:24.000000Z","updated_at":"2025-09-13T10:00:24.000000Z"},{"id":15933985,"change_date":"2025-09-10 21:40:00","inspection_id":"85735534","insp_unit_id":"208851379","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CUSM","insp_unit_company":"237","insp_unit_license":"CSR0561","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"5JWTC2833SN604088","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-13T10:00:24.000000Z","updated_at":"2025-09-13T10:00:24.000000Z"}]},{"id":9545983,"change_date":"2025-08-29 21:40:00","inspection_id":"85633344","dot_number":"1470307","report_state":"IA","report_number":"000P13DLH0","insp_date":"2025-08-25 00:00:00","insp_start_time":"1818","insp_end_time":"1842","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 60 SB 39MM - SHELDON","county_code_state":"IA","county_code":"141","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"PRIVATE","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":"N","pen_cen_match":null,"final_status_date":"2025-08-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"24000","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":"1371993","transaction_code":"A","transaction_date":"2025-08-29 00:00:00","upload_date":"2025-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01470307","upload_search_indicator":"M","census_search_date":"2025-08-29 21:40:00","snet_input_date":"2025-08-25 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-08-29 21:40:00","insp_carrier_name":"B&B GAS PIPING PLUS LLC","insp_carrier_street":"1210 EAST 12TH STREET","insp_carrier_city":"FAIRMONT","insp_carrier_state":"MN","insp_carrier_zip_code":"56031","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-06T10:42:31.000000Z","updated_at":"2025-09-06T10:42:31.000000Z","inspection_violations":[{"id":15583642,"change_date":"2025-08-29 21:40:00","inspection_id":"85633344","insp_violation_id":"268343995","seq_no":"1","part_no":"395","part_no_section":"8F01","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-06T10:46:17.000000Z","updated_at":"2025-09-06T10:46:17.000000Z","normalized_code":"3958F01"}],"inspection_per_units":[{"id":15755937,"change_date":"2025-08-29 21:40:00","inspection_id":"85633344","insp_unit_id":"208658997","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"152","insp_unit_license":"YCG6758","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1GT4UTEY7SF187744","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:46:51.000000Z","updated_at":"2025-09-09T09:46:51.000000Z"},{"id":15755938,"change_date":"2025-08-29 21:40:00","inspection_id":"85633344","insp_unit_id":"208658998","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FELLING","insp_unit_company":"231","insp_unit_license":"CSB1952","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"5FTCF3322N1007405","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:46:51.000000Z","updated_at":"2025-09-09T09:46:51.000000Z"}]},{"id":9141530,"change_date":"2025-07-14 21:40:00","inspection_id":"85207892","dot_number":"1470307","report_state":"NE","report_number":"T409000495","insp_date":"2025-07-14 00:00:00","insp_start_time":"1000","insp_end_time":"1030","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ON STATE HWY 14, 2112 FEET EAS","county_code_state":"NE","county_code":"107","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"B&B (WORK TRUCK)","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"35000","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":"819998","transaction_code":"A","transaction_date":"2025-07-14 00:00:00","upload_date":"2025-07-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01470307","upload_search_indicator":"M","census_search_date":"2025-07-14 21:40:00","snet_input_date":"2025-07-14 00:00:00","source_office":"3NES001","mcmis_add_date":"2025-07-14 21:40:00","insp_carrier_name":"B&B GAS PIPING PLUS LLC","insp_carrier_street":"1210 EAST 12TH STREET","insp_carrier_city":"FAIRMONT","insp_carrier_state":"MN","insp_carrier_zip_code":"56031","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-18T10:45:45.000000Z","updated_at":"2025-07-18T10:45:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15011285,"change_date":"2025-07-14 21:40:00","inspection_id":"85207892","insp_unit_id":"207856121","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"YCG6758","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1GT4UTEY7SF187744","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-17T09:45:31.000000Z","updated_at":"2025-07-18T09:45:51.000000Z"},{"id":15011286,"change_date":"2025-07-14 21:40:00","inspection_id":"85207892","insp_unit_id":"207856122","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNIT","insp_unit_company":null,"insp_unit_license":"6842CTA","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"56JTE2838GA150207","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-17T09:45:31.000000Z","updated_at":"2025-07-18T09:45:51.000000Z"}]},{"id":7334867,"change_date":"2024-12-04 21:41:00","inspection_id":"83305228","dot_number":"1470307","report_state":"SD","report_number":"5290002265","insp_date":"2024-12-04 00:00:00","insp_start_time":"0752","insp_end_time":"0819","registration_date":null,"region":"CS","ci_status_code":"C","location":"SUFLSW","location_desc":"VALLEY SPRINGS SD","county_code_state":"SD","county_code":"099","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SELF","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-12-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19150","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":"1118095","transaction_code":"A","transaction_date":"2024-12-04 00:00:00","upload_date":"2024-12-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01470307","upload_search_indicator":null,"census_search_date":"2024-12-04 21:41:00","snet_input_date":"2024-12-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-12-04 21:41:00","insp_carrier_name":"B&B GAS PIPING PLUS LLC","insp_carrier_street":"1210 EAST 12TH STREET","insp_carrier_city":"FAIRMONT","insp_carrier_state":"MN","insp_carrier_zip_code":"56031","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:49:00.000000Z","updated_at":"2025-03-17T20:49:00.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11832470,"change_date":"2024-12-04 21:41:00","inspection_id":"83305228","insp_unit_id":"204171817","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"YCD7654","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1GT59TEY5PF248408","insp_unit_decal":"Y","insp_unit_decal_number":"34692695","created_at":"2025-03-17T23:45:39.000000Z","updated_at":"2025-03-17T23:45:39.000000Z"},{"id":11832471,"change_date":"2024-12-04 21:41:00","inspection_id":"83305228","insp_unit_id":"204171818","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"6042CTV","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"5JWTC142XLN534128","insp_unit_decal":"Y","insp_unit_decal_number":"34692696","created_at":"2025-03-17T23:45:39.000000Z","updated_at":"2025-03-17T23:45:39.000000Z"}]},{"id":7129986,"change_date":"2024-11-06 21:39:00","inspection_id":"83088667","dot_number":"1470307","report_state":"ND","report_number":"TR97002245","insp_date":"2024-11-04 00:00:00","insp_start_time":"1207","insp_end_time":"1254","registration_date":null,"region":"CS","ci_status_code":"C","location":"MOORTN","location_desc":"MOORETON ND","county_code_state":"ND","county_code":"077","insp_level_id":"1","service_center":"WE","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":"2024-11-06 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"35000","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":"1025143","transaction_code":"A","transaction_date":"2024-11-06 00:00:00","upload_date":"2024-11-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01470307","upload_search_indicator":null,"census_search_date":"2024-11-06 21:39:00","snet_input_date":"2024-11-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-06 21:39:00","insp_carrier_name":"B&B GAS PIPING PLUS LLC","insp_carrier_street":"1210 EAST 12TH STREET","insp_carrier_city":"FAIRMONT","insp_carrier_state":"MN","insp_carrier_zip_code":"56031","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:44:40.000000Z","updated_at":"2025-03-17T20:44:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11499881,"change_date":"2024-11-06 21:39:00","inspection_id":"83088667","insp_unit_id":"203753406","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"142","insp_unit_license":"YCB8122","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1GT49TEY5NF177364","insp_unit_decal":"Y","insp_unit_decal_number":"34694462","created_at":"2025-03-17T23:42:07.000000Z","updated_at":"2025-03-17T23:42:07.000000Z"},{"id":11499882,"change_date":"2024-11-06 21:39:00","inspection_id":"83088667","insp_unit_id":"203753407","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNITED","insp_unit_company":"219","insp_unit_license":"6355CTH","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"56JTE2838HA154727","insp_unit_decal":"Y","insp_unit_decal_number":"34694463","created_at":"2025-03-17T23:42:07.000000Z","updated_at":"2025-03-17T23:42:07.000000Z"}]},{"id":6111878,"change_date":"2024-07-01 21:43:00","inspection_id":"82002962","dot_number":"1470307","report_state":"MN","report_number":"0209000008","insp_date":"2024-06-25 00:00:00","insp_start_time":"1354","insp_end_time":"1440","registration_date":null,"region":"CD","ci_status_code":"C","location":"WTHTN","location_desc":"WORTHINGTON MN","county_code_state":"MN","county_code":"105","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","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":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-07-01 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"34025","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"614909","transaction_code":"A","transaction_date":"2024-07-01 00:00:00","upload_date":"2024-07-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01470307","upload_search_indicator":null,"census_search_date":"2024-07-01 21:43:00","snet_input_date":"2024-06-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-01 21:43:00","insp_carrier_name":"B&B GAS PIPING PLUS LLC","insp_carrier_street":"1210 EAST 12TH STREET","insp_carrier_city":"FAIRMONT","insp_carrier_state":"MN","insp_carrier_zip_code":"56031","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:23:47.000000Z","updated_at":"2025-03-17T20:23:47.000000Z","inspection_violations":[{"id":9487851,"change_date":"2024-07-01 21:43:00","inspection_id":"82002962","insp_violation_id":"260395876","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:51:55.000000Z","updated_at":"2025-03-17T21:51:55.000000Z","normalized_code":"38323A2"}],"inspection_per_units":[{"id":9844604,"change_date":"2024-07-01 21:43:00","inspection_id":"82002962","insp_unit_id":"201665683","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"YBW4397","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1GT42UCY0KF189317","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:58.000000Z","updated_at":"2025-03-17T23:24:58.000000Z"},{"id":9844605,"change_date":"2024-07-01 21:43:00","inspection_id":"82002962","insp_unit_id":"201665684","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNITED MFG","insp_unit_company":null,"insp_unit_license":"2326CXT","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"56JTE2834EA138651","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:58.000000Z","updated_at":"2025-03-17T23:24:58.000000Z"}]},{"id":5318186,"change_date":"2024-03-19 21:45:00","inspection_id":"81140648","dot_number":"1470307","report_state":"IA","report_number":"000P132Z4V","insp_date":"2024-03-14 00:00:00","insp_start_time":"1035","insp_end_time":"1055","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":"B&B GAS","shipping_paper_number":"TOOLS","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-19 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"38000","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":"1306053","transaction_code":"A","transaction_date":"2024-03-15 00:00:00","upload_date":"2024-03-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01470307","upload_search_indicator":"M","census_search_date":"2024-03-19 21:45:00","snet_input_date":"2024-03-14 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-03-19 21:45:00","insp_carrier_name":"B&B GAS PIPING PLUS LLC","insp_carrier_street":"1210 EAST 12TH STREET","insp_carrier_city":"FAIRMONT","insp_carrier_state":"MN","insp_carrier_zip_code":"56031","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:07:56.000000Z","updated_at":"2025-03-17T20:07:56.000000Z","inspection_violations":[{"id":8204858,"change_date":"2024-03-19 21:45:00","inspection_id":"81140648","insp_violation_id":"258463141","seq_no":"1","part_no":"395","part_no_section":"8(f)(12)","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:45:41.000000Z","updated_at":"2025-03-17T21:45:41.000000Z","normalized_code":"3958F12"}],"inspection_per_units":[{"id":8565023,"change_date":"2024-03-19 21:45:00","inspection_id":"81140648","insp_unit_id":"199982708","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"YCB8129","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1GT49TEY4NF178067","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:39.000000Z","updated_at":"2025-03-17T23:12:39.000000Z"},{"id":8565024,"change_date":"2024-03-19 21:45:00","inspection_id":"81140648","insp_unit_id":"199982709","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"HMDE","insp_unit_company":null,"insp_unit_license":"CSK5369","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"5JWTC2832RN587651","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:39.000000Z","updated_at":"2025-03-17T23:12:39.000000Z"}]},{"id":5267692,"change_date":"2024-03-12 21:39:00","inspection_id":"81085399","dot_number":"1470307","report_state":"IA","report_number":"000P1698CT","insp_date":"2024-03-11 00:00:00","insp_start_time":"0721","insp_end_time":"0801","registration_date":null,"region":"CT","ci_status_code":"C","location":"39","location_desc":"39 - I35 SB MM 212 NORTHWOOD","county_code_state":"IA","county_code":"195","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"MISC","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-12 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"39000","viol_total":"4","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1305752","transaction_code":"A","transaction_date":"2024-03-12 00:00:00","upload_date":"2024-03-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01470307","upload_search_indicator":"M","census_search_date":"2024-03-12 21:39:00","snet_input_date":"2024-03-11 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-03-12 21:39:00","insp_carrier_name":"B&B GAS PIPING PLUS LLC","insp_carrier_street":"1210 EAST 12TH STREET","insp_carrier_city":"FAIRMONT","insp_carrier_state":"MN","insp_carrier_zip_code":"56031","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:07:04.000000Z","updated_at":"2025-03-17T20:07:04.000000Z","inspection_violations":[{"id":8123548,"change_date":"2024-03-12 21:39:00","inspection_id":"81085399","insp_violation_id":"258338990","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:45:17.000000Z","updated_at":"2025-03-17T21:45:17.000000Z","normalized_code":"3922"},{"id":8123549,"change_date":"2024-03-12 21:39:00","inspection_id":"81085399","insp_violation_id":"258338991","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199872626","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:17.000000Z","updated_at":"2025-03-17T21:45:17.000000Z","normalized_code":"3922"},{"id":8123550,"change_date":"2024-03-12 21:39:00","inspection_id":"81085399","insp_violation_id":"258338992","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"199872627","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"1WIN24031107394","created_at":"2025-03-17T21:45:17.000000Z","updated_at":"2025-03-17T21:45:17.000000Z","normalized_code":"3939A"},{"id":8123551,"change_date":"2024-03-12 21:39:00","inspection_id":"81085399","insp_violation_id":"258338993","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"199872627","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:17.000000Z","updated_at":"2025-03-17T21:45:17.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":8482631,"change_date":"2024-03-12 21:39:00","inspection_id":"81085399","insp_unit_id":"199872626","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"143","insp_unit_license":"YCB8129","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1GT49TEY4NF178067","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:52.000000Z","updated_at":"2025-03-17T23:11:52.000000Z"},{"id":8482632,"change_date":"2024-03-12 21:39:00","inspection_id":"81085399","insp_unit_id":"199872627","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CUSM","insp_unit_company":"69","insp_unit_license":"CSK5369","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"5JWTC2832RN587651","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:52.000000Z","updated_at":"2025-03-17T23:11:52.000000Z"}]},{"id":4845964,"change_date":"2024-01-17 21:43:00","inspection_id":"80624745","dot_number":"1470307","report_state":"SD","report_number":"1620000104","insp_date":"2024-01-16 00:00:00","insp_start_time":"0935","insp_end_time":"1000","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"VALLEY SPRINGS SD","county_code_state":"SD","county_code":"137","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SELF","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-01-17 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"17000","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":"179812","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":"01470307","upload_search_indicator":null,"census_search_date":"2024-01-17 21:43:00","snet_input_date":"2024-01-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-01-17 21:43:00","insp_carrier_name":"B&B GAS PIPING PLUS LLC","insp_carrier_street":"1210 EAST 12TH STREET","insp_carrier_city":"FAIRMONT","insp_carrier_state":"MN","insp_carrier_zip_code":"56031","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:58:49.000000Z","updated_at":"2025-03-17T19:58:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7796752,"change_date":"2024-01-17 21:43:00","inspection_id":"80624745","insp_unit_id":"198987572","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"YBW4397","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1GT42UCY0KF189317","insp_unit_decal":"Y","insp_unit_decal_number":"33737625","created_at":"2025-03-17T23:05:41.000000Z","updated_at":"2025-03-17T23:05:41.000000Z"},{"id":7796753,"change_date":"2024-01-17 21:43:00","inspection_id":"80624745","insp_unit_id":"198987573","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNKNOWN","insp_unit_company":null,"insp_unit_license":"6042CTV","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"5JWTC142XLN534128","insp_unit_decal":"Y","insp_unit_decal_number":"33737626","created_at":"2025-03-17T23:05:41.000000Z","updated_at":"2025-03-17T23:05:41.000000Z"}]},{"id":4632661,"change_date":"2023-12-14 21:43:00","inspection_id":"80391760","dot_number":"1470307","report_state":"MN","report_number":"0AER001082","insp_date":"2023-12-14 00:00:00","insp_start_time":"1441","insp_end_time":"1516","registration_date":null,"region":"CT","ci_status_code":"C","location":"WTHTN","location_desc":"WORTHINGTON SCALE","county_code_state":"MN","county_code":"105","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"F","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":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-12-14 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"35000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1426260","transaction_code":"A","transaction_date":"2023-12-14 00:00:00","upload_date":"2023-12-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01470307","upload_search_indicator":null,"census_search_date":"2023-12-14 21:43:00","snet_input_date":"2023-12-14 00:00:00","source_office":"3MNS001","mcmis_add_date":"2023-12-14 21:43:00","insp_carrier_name":"B&B GAS PIPING PLUS LLC","insp_carrier_street":"1210 EAST 12TH STREET","insp_carrier_city":"FAIRMONT","insp_carrier_state":"MN","insp_carrier_zip_code":"56031","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:54:34.000000Z","updated_at":"2025-03-17T19:54:34.000000Z","inspection_violations":[{"id":7160110,"change_date":"2023-12-14 21:43:00","inspection_id":"80391760","insp_violation_id":"256888773","seq_no":"1","part_no":"393","part_no_section":"43(d)","insp_viol_unit":"2","insp_unit_id":"198511626","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:40:37.000000Z","updated_at":"2025-03-17T21:40:37.000000Z","normalized_code":"39343D"}],"inspection_per_units":[{"id":7451174,"change_date":"2023-12-14 21:43:00","inspection_id":"80391760","insp_unit_id":"198511625","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"142","insp_unit_license":"YCB8122","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1GT49TEY5NF177364","insp_unit_decal":"Y","insp_unit_decal_number":"33429951","created_at":"2025-03-17T23:02:39.000000Z","updated_at":"2025-03-17T23:02:39.000000Z"},{"id":7451175,"change_date":"2023-12-14 21:43:00","inspection_id":"80391760","insp_unit_id":"198511626","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNITED","insp_unit_company":"219","insp_unit_license":"6355CTH","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"56JTE2838HA154727","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:39.000000Z","updated_at":"2025-03-17T23:02:39.000000Z"}]},{"id":4044419,"change_date":"2023-09-26 21:43:00","inspection_id":"79742165","dot_number":"1470307","report_state":"IA","report_number":"000TT20C5D","insp_date":"2023-09-21 00:00:00","insp_start_time":"0800","insp_end_time":"0818","registration_date":null,"region":"CT","ci_status_code":"C","location":"39","location_desc":"39 - I35 SB MM 212 NORTHWOOD","county_code_state":"IA","county_code":"195","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"B&B GAS PIPING PLUS LLC","shipping_paper_number":"SELF","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"35000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"1","hazmat_oos_total":"1","snet_sequence_id":"1289879","transaction_code":"C","transaction_date":"2023-09-23 00:00:00","upload_date":"2023-09-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01470307","upload_search_indicator":"M","census_search_date":"2023-09-25 21:40:00","snet_input_date":"2023-09-21 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-09-25 21:40:00","insp_carrier_name":"B&B GAS PIPING PLUS LLC","insp_carrier_street":"1210 EAST 12TH STREET","insp_carrier_city":"FAIRMONT","insp_carrier_state":"MN","insp_carrier_zip_code":"56031","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:42:46.000000Z","updated_at":"2025-03-17T19:42:46.000000Z","inspection_violations":[{"id":6260258,"change_date":"2023-09-26 21:43:00","inspection_id":"79742165","insp_violation_id":"255495393","seq_no":"1","part_no":"177","part_no_section":"834(a)","insp_viol_unit":"1","insp_unit_id":"197249193","insp_violation_category_id":"34","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:36:14.000000Z","updated_at":"2025-03-17T21:36:14.000000Z","normalized_code":"177834A"}],"inspection_per_units":[{"id":6502624,"change_date":"2023-09-26 21:43:00","inspection_id":"79742165","insp_unit_id":"197249193","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"YCB8129","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1GT49TEY4NF178067","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:34.000000Z","updated_at":"2025-03-17T22:54:34.000000Z"},{"id":6502625,"change_date":"2023-09-26 21:43:00","inspection_id":"79742165","insp_unit_id":"197249194","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNITED","insp_unit_company":"215","insp_unit_license":"6842CTA","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"56JTE2838GA150207","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:34.000000Z","updated_at":"2025-03-17T22:54:34.000000Z"}]},{"id":3151484,"change_date":"2023-05-26 21:39:00","inspection_id":"78741356","dot_number":"1470307","report_state":"MN","report_number":"00ZE003546","insp_date":"2023-05-25 00:00:00","insp_start_time":"1623","insp_end_time":"1649","registration_date":null,"region":"CT","ci_status_code":"C","location":"WTHTN","location_desc":"WORTHINGTON SCALE","county_code_state":"MN","county_code":"105","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-05-26 21:39: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":"1","vehicle_oos_total":"0","hazmat_viol_total":"1","hazmat_oos_total":"0","snet_sequence_id":"1389918","transaction_code":"A","transaction_date":"2023-05-25 00:00:00","upload_date":"2023-05-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01470307","upload_search_indicator":null,"census_search_date":"2023-05-26 21:39:00","snet_input_date":"2023-05-26 00:00:00","source_office":"3MNS001","mcmis_add_date":"2023-05-26 21:39:00","insp_carrier_name":"B&B GAS PIPING PLUS LLC","insp_carrier_street":"1210 EAST 12TH STREET","insp_carrier_city":"FAIRMONT","insp_carrier_state":"MN","insp_carrier_zip_code":"56031","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:25:22.000000Z","updated_at":"2025-03-17T19:25:22.000000Z","inspection_violations":[{"id":4852160,"change_date":"2023-05-26 21:39:00","inspection_id":"78741356","insp_violation_id":"253105282","seq_no":"1","part_no":"173","part_no_section":"24(f)(1)","insp_viol_unit":"2","insp_unit_id":"195165219","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:34.000000Z","updated_at":"2025-03-17T21:29:34.000000Z","normalized_code":"17324F1"}],"inspection_per_units":[{"id":5068313,"change_date":"2023-05-26 21:39:00","inspection_id":"78741356","insp_unit_id":"195165218","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"142","insp_unit_license":"YCB8122","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1GT49TEY5NF177364","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:56.000000Z","updated_at":"2025-03-17T22:42:56.000000Z"},{"id":5068314,"change_date":"2023-05-26 21:39:00","inspection_id":"78741356","insp_unit_id":"195165219","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNITED","insp_unit_company":"219","insp_unit_license":"6355CTH","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"56JTE2838HA154727","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:56.000000Z","updated_at":"2025-03-17T22:42:56.000000Z"}]},{"id":2287311,"change_date":"2023-02-03 21:41:00","inspection_id":"77760473","dot_number":"1470307","report_state":"SD","report_number":"HP09700260","insp_date":"2023-01-31 00:00:00","insp_start_time":"0938","insp_end_time":"0959","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SIOUX FALLS PORT OF ENTRY","county_code_state":"SD","county_code":"099","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"SELF","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-02-02 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"35000","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":"635610","transaction_code":"C","transaction_date":"2023-02-03 00:00:00","upload_date":"2023-02-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01470307","upload_search_indicator":"M","census_search_date":"2023-02-02 21:42:00","snet_input_date":"2023-02-02 00:00:00","source_office":"4SDS001","mcmis_add_date":"2023-02-02 21:42:00","insp_carrier_name":"B&B GAS PIPING PLUS LLC","insp_carrier_street":"1210 EAST 12TH STREET","insp_carrier_city":"FAIRMONT","insp_carrier_state":"MN","insp_carrier_zip_code":"56031","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:52.000000Z","updated_at":"2025-03-17T19:08:52.000000Z","inspection_violations":[{"id":3527545,"change_date":"2023-02-03 21:41:00","inspection_id":"77760473","insp_violation_id":"250950184","seq_no":"1","part_no":"395","part_no_section":"8","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:23:40.000000Z","updated_at":"2025-03-17T21:23:40.000000Z","normalized_code":"3958"}],"inspection_per_units":[{"id":3681446,"change_date":"2023-02-03 21:41:00","inspection_id":"77760473","insp_unit_id":"193227402","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"YCD2928","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1GT49TEY7NF355842","insp_unit_decal":"Y","insp_unit_decal_number":"32391393","created_at":"2025-03-17T22:32:23.000000Z","updated_at":"2025-03-17T22:32:23.000000Z"},{"id":3681447,"change_date":"2023-02-03 21:41:00","inspection_id":"77760473","insp_unit_id":"193227403","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNIT","insp_unit_company":null,"insp_unit_license":"6802CTA","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"56JTE2838GA148781","insp_unit_decal":"Y","insp_unit_decal_number":"32391394","created_at":"2025-03-17T22:32:23.000000Z","updated_at":"2025-03-17T22:32:23.000000Z"}]},{"id":1860674,"change_date":"2022-12-02 21:41:00","inspection_id":"77272638","dot_number":"1470307","report_state":"IA","report_number":"000TT73JVL","insp_date":"2022-11-28 00:00:00","insp_start_time":"0741","insp_end_time":"0756","registration_date":null,"region":"CT","ci_status_code":"C","location":"39","location_desc":"39 - I35 SB MM 212 NORTHWOOD","county_code_state":"IA","county_code":"195","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"M7B GAS PIPING PLUS LLC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"35000","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":"1252615","transaction_code":"A","transaction_date":"2022-12-01 00:00:00","upload_date":"2022-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01470307","upload_search_indicator":"M","census_search_date":"2022-12-02 21:41:00","snet_input_date":"2022-11-28 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-12-02 21:41:00","insp_carrier_name":"B&B GAS PIPING PLUS LLC","insp_carrier_street":"1210 EAST 12TH STREET","insp_carrier_city":"FAIRMONT","insp_carrier_state":"MN","insp_carrier_zip_code":"56031","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:01:04.000000Z","updated_at":"2025-03-17T19:01:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2994236,"change_date":"2022-12-02 21:41:00","inspection_id":"77272638","insp_unit_id":"192233785","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"143","insp_unit_license":"YVB8129","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1GT49TEY4NF178067","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:29.000000Z","updated_at":"2025-03-17T22:27:29.000000Z"},{"id":2994237,"change_date":"2022-12-02 21:41:00","inspection_id":"77272638","insp_unit_id":"192233786","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CUSM","insp_unit_company":"215","insp_unit_license":"6842CTA","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"56JTE2838GA150207","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:29.000000Z","updated_at":"2025-03-17T22:27:29.000000Z"}]},{"id":1731369,"change_date":"2022-11-14 21:42:00","inspection_id":"77124698","dot_number":"1470307","report_state":"SD","report_number":"5300000029","insp_date":"2022-11-14 00:00:00","insp_start_time":"0822","insp_end_time":"0833","registration_date":null,"region":"CT","ci_status_code":"C","location":"MC20","location_desc":"SIOUX FALLS PORT OF ENTRY","county_code_state":"SD","county_code":"099","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"SELF","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-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"41000","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":"631350","transaction_code":"A","transaction_date":"2022-11-14 00:00:00","upload_date":"2022-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01470307","upload_search_indicator":null,"census_search_date":"2022-11-14 21:42:00","snet_input_date":"2022-11-14 00:00:00","source_office":"4SDS001","mcmis_add_date":"2022-11-14 21:42:00","insp_carrier_name":"B&B GAS PIPING PLUS LLC","insp_carrier_street":"1210 EAST 12TH STREET","insp_carrier_city":"FAIRMONT","insp_carrier_state":"MN","insp_carrier_zip_code":"56031","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:34.000000Z","updated_at":"2025-03-17T18:58:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2785767,"change_date":"2022-11-14 21:42:00","inspection_id":"77124698","insp_unit_id":"191937091","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"YCB8129","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1GT49TEY4NF178067","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:04.000000Z","updated_at":"2025-03-17T22:26:04.000000Z"},{"id":2785768,"change_date":"2022-11-14 21:42:00","inspection_id":"77124698","insp_unit_id":"191937092","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":null,"insp_unit_license":"6842CTA","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"56JTE2838GA150207","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:04.000000Z","updated_at":"2025-03-17T22:26:04.000000Z"}]},{"id":1698096,"change_date":"2022-11-08 21:38:00","inspection_id":"77086282","dot_number":"1470307","report_state":"SD","report_number":"0031005528","insp_date":"2022-11-03 00:00:00","insp_start_time":"1152","insp_end_time":"1210","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"PLANKINTON TRUCK CHECK","county_code_state":"SD","county_code":"003","insp_level_id":"2","service_center":"WE","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":"N","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":"39300","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":"630682","transaction_code":"A","transaction_date":"2022-11-07 00:00:00","upload_date":"2022-11-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01470307","upload_search_indicator":"M","census_search_date":"2022-11-08 21:38:00","snet_input_date":"2022-11-07 00:00:00","source_office":"4SDS001","mcmis_add_date":"2022-11-08 21:38:00","insp_carrier_name":"B&B GAS PIPING PLUS LLC","insp_carrier_street":"1210 EAST 12TH STREET","insp_carrier_city":"FAIRMONT","insp_carrier_state":"MN","insp_carrier_zip_code":"56031","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:57:49.000000Z","updated_at":"2025-03-17T18:57:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2732149,"change_date":"2022-11-08 21:38:00","inspection_id":"77086282","insp_unit_id":"191862837","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"YBZ3133","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1GT49TEY2MF118822","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:42.000000Z","updated_at":"2025-03-17T22:25:42.000000Z"},{"id":2732150,"change_date":"2022-11-08 21:38:00","inspection_id":"77086282","insp_unit_id":"191862838","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"5586CTD","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"576GF3522H1030224","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:42.000000Z","updated_at":"2025-03-17T22:25:42.000000Z"}]},{"id":1648262,"change_date":"2022-11-08 21:38:00","inspection_id":"77029261","dot_number":"1470307","report_state":"SD","report_number":"5300000015","insp_date":"2022-11-01 00:00:00","insp_start_time":"0839","insp_end_time":"0851","registration_date":null,"region":"CT","ci_status_code":"C","location":"MC20","location_desc":"SIOUX FALLS PORT OF ENTRY","county_code_state":"SD","county_code":"099","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"SELF","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-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":null,"viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"630182","transaction_code":"C","transaction_date":"2022-11-08 00:00:00","upload_date":"2022-11-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01470307","upload_search_indicator":"M","census_search_date":"2022-11-01 21:40:00","snet_input_date":"2022-11-01 00:00:00","source_office":"4SDS001","mcmis_add_date":"2022-11-01 21:40:00","insp_carrier_name":"B&B GAS PIPING PLUS LLC","insp_carrier_street":"1210 EAST 12TH STREET","insp_carrier_city":"FAIRMONT","insp_carrier_state":"MN","insp_carrier_zip_code":"56031","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":[],"inspection_per_units":[{"id":2652253,"change_date":"2022-11-08 21:38:00","inspection_id":"77029261","insp_unit_id":"191863406","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"YBW7884","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1GT59TEYXLF235521","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":2652254,"change_date":"2022-11-08 21:38:00","inspection_id":"77029261","insp_unit_id":"191863407","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"FELL","insp_unit_company":null,"insp_unit_license":"CSE0709","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"5FTCE2923P1010403","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":1645853,"change_date":"2022-11-01 21:40:00","inspection_id":"77026459","dot_number":"1470307","report_state":"IA","report_number":"000TTDB1TQ","insp_date":"2022-10-27 00:00:00","insp_start_time":"0924","insp_end_time":"0938","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 169 NB","county_code_state":"IA","county_code":"109","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"B&B GAS PIPING","shipping_paper_number":"SELF","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"38000","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":"1249302","transaction_code":"A","transaction_date":"2022-10-31 00:00:00","upload_date":"2022-10-31 00:00:00","upload_first_byte":"0","upload_dot_number":"01470307","upload_search_indicator":"M","census_search_date":"2022-11-01 21:40:00","snet_input_date":"2022-10-27 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-11-01 21:40:00","insp_carrier_name":"B&B GAS PIPING PLUS LLC","insp_carrier_street":"1210 EAST 12TH STREET","insp_carrier_city":"FAIRMONT","insp_carrier_state":"MN","insp_carrier_zip_code":"56031","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:57:02.000000Z","updated_at":"2025-03-17T18:57:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2648048,"change_date":"2022-11-01 21:40:00","inspection_id":"77026459","insp_unit_id":"191745267","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"1","insp_unit_license":"YBZ3132","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1GT49TEY3MF118764","insp_unit_decal":"Y","insp_unit_decal_number":"32041481","created_at":"2025-03-17T22:25:09.000000Z","updated_at":"2025-03-17T22:25:09.000000Z"},{"id":2648049,"change_date":"2022-11-01 21:40:00","inspection_id":"77026459","insp_unit_id":"191745268","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNITED","insp_unit_company":"2","insp_unit_license":"2490CTU","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"56JTE2832MA173106","insp_unit_decal":"Y","insp_unit_decal_number":"32041482","created_at":"2025-03-17T22:25:09.000000Z","updated_at":"2025-03-17T22:25:09.000000Z"}]},{"id":1542927,"change_date":"2022-10-18 21:40:00","inspection_id":"76908039","dot_number":"1470307","report_state":"MO","report_number":"W031004860","insp_date":"2022-10-17 00:00:00","insp_start_time":"1113","insp_end_time":"1145","registration_date":null,"region":"CT","ci_status_code":"C","location":"H2S","location_desc":"I-35 EAGLEVILLE","county_code_state":"MO","county_code":"081","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"F","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":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-10-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"39300","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":"2037743","transaction_code":"A","transaction_date":"2022-10-18 00:00:00","upload_date":"2022-10-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01470307","upload_search_indicator":"M","census_search_date":"2022-10-18 21:40:00","snet_input_date":"2022-10-18 00:00:00","source_office":"3MOS001","mcmis_add_date":"2022-10-18 21:40:00","insp_carrier_name":"B&B GAS PIPING PLUS LLC","insp_carrier_street":"1210 EAST 12TH STREET","insp_carrier_city":"FAIRMONT","insp_carrier_state":"MN","insp_carrier_zip_code":"56031","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:55:10.000000Z","updated_at":"2025-03-17T18:55:10.000000Z","inspection_violations":[{"id":2427541,"change_date":"2022-10-18 21:40:00","inspection_id":"76908039","insp_violation_id":"249099811","seq_no":"1","part_no":"395","part_no_section":"8(f)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:19.000000Z","updated_at":"2025-03-17T21:18:19.000000Z","normalized_code":"3958F1"}],"inspection_per_units":[{"id":2482939,"change_date":"2022-10-18 21:40:00","inspection_id":"76908039","insp_unit_id":"191503799","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"141","insp_unit_license":"YBZ3133","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1GT49TEY2MF118822","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:01.000000Z","updated_at":"2025-03-17T22:24:01.000000Z"},{"id":2482940,"change_date":"2022-10-18 21:40:00","inspection_id":"76908039","insp_unit_id":"191503800","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"218","insp_unit_license":"5586CTD","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"576GF3522H1030224","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:01.000000Z","updated_at":"2025-03-17T22:24:01.000000Z"}]},{"id":1304616,"change_date":"2022-09-16 21:41:00","inspection_id":"76632058","dot_number":"1470307","report_state":"NE","report_number":"00MU001572","insp_date":"2022-09-14 00:00:00","insp_start_time":"1510","insp_end_time":"1545","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"WEST OF PLAINVIEW","county_code_state":"NE","county_code":"003","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":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-09-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"22300","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":"741487","transaction_code":"A","transaction_date":"2022-09-14 00:00:00","upload_date":"2022-09-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01470307","upload_search_indicator":null,"census_search_date":"2022-09-16 21:41:00","snet_input_date":"2022-09-15 00:00:00","source_office":"3NES001","mcmis_add_date":"2022-09-16 21:41:00","insp_carrier_name":"B&B GAS PIPING PLUS LLC","insp_carrier_street":"1210 EAST 12TH STREET","insp_carrier_city":"FAIRMONT","insp_carrier_state":"MN","insp_carrier_zip_code":"56031","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:50:49.000000Z","updated_at":"2025-03-17T18:50:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2099815,"change_date":"2022-09-16 21:41:00","inspection_id":"76632058","insp_unit_id":"190946726","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"YBW7884","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1GT59TEYXLF235521","insp_unit_decal":"Y","insp_unit_decal_number":"31719324","created_at":"2025-03-17T22:21:23.000000Z","updated_at":"2025-03-17T22:21:23.000000Z"},{"id":2099816,"change_date":"2022-09-16 21:41:00","inspection_id":"76632058","insp_unit_id":"190946727","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"HHTC","insp_unit_company":null,"insp_unit_license":"6042CTV","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"5JWTC142XLN534128","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:23.000000Z","updated_at":"2025-03-17T22:21:23.000000Z"}]},{"id":1240867,"change_date":"2022-09-08 21:39:00","inspection_id":"76557895","dot_number":"1470307","report_state":"SD","report_number":"0020085729","insp_date":"2022-09-07 00:00:00","insp_start_time":"0750","insp_end_time":"0816","registration_date":null,"region":"CT","ci_status_code":"C","location":"MC20","location_desc":"SIOUX FALLS PORT OF ENTRY","county_code_state":"SD","county_code":"099","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"SELF","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-09-08 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"13025","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":"626429","transaction_code":"A","transaction_date":"2022-09-08 00:00:00","upload_date":"2022-09-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01470307","upload_search_indicator":"M","census_search_date":"2022-09-08 21:39:00","snet_input_date":"2022-09-08 00:00:00","source_office":"4SDS001","mcmis_add_date":"2022-09-08 21:39:00","insp_carrier_name":"B&B GAS PIPING PLUS LLC","insp_carrier_street":"1210 EAST 12TH STREET","insp_carrier_city":"FAIRMONT","insp_carrier_state":"MN","insp_carrier_zip_code":"56031","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:49:40.000000Z","updated_at":"2025-03-17T18:49:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1996974,"change_date":"2022-09-08 21:39:00","inspection_id":"76557895","insp_unit_id":"190791936","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"132","insp_unit_license":"YBW4397","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1GT42UCY0KF189317","insp_unit_decal":"Y","insp_unit_decal_number":"31752553","created_at":"2025-03-17T22:20:44.000000Z","updated_at":"2025-03-17T22:20:44.000000Z"},{"id":1996975,"change_date":"2022-09-08 21:39:00","inspection_id":"76557895","insp_unit_id":"190791937","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":"214","insp_unit_license":"6802CTA","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"56JTE2838GA148781","insp_unit_decal":"Y","insp_unit_decal_number":"31752554","created_at":"2025-03-17T22:20:44.000000Z","updated_at":"2025-03-17T22:20:44.000000Z"}]},{"id":658963,"change_date":"2022-06-21 21:42:00","inspection_id":"75878275","dot_number":"1470307","report_state":"IA","report_number":"000TT7FWRG","insp_date":"2022-06-06 00:00:00","insp_start_time":"1110","insp_end_time":"1134","registration_date":null,"region":"CT","ci_status_code":"C","location":"37","location_desc":"37 - I29 SB MM 132 SALIX","county_code_state":"IA","county_code":"193","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"B & B GAS PIPING PLUS","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"35000","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":"1229626","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":"01470307","upload_search_indicator":"M","census_search_date":"2022-06-21 21:42:00","snet_input_date":"2022-06-06 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-06-21 21:42:00","insp_carrier_name":"B&B GAS PIPING PLUS LLC","insp_carrier_street":"1210 EAST 12TH STREET","insp_carrier_city":"FAIRMONT","insp_carrier_state":"MN","insp_carrier_zip_code":"56031","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:39:13.000000Z","updated_at":"2025-03-17T18:39:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1059066,"change_date":"2022-06-21 21:42:00","inspection_id":"75878275","insp_unit_id":"189375878","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNITED","insp_unit_company":"219","insp_unit_license":"6355CTH","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"56JTE2838HA154727","insp_unit_decal":"Y","insp_unit_decal_number":"31339247","created_at":"2025-03-17T22:14:42.000000Z","updated_at":"2025-03-17T22:14:42.000000Z"},{"id":1059067,"change_date":"2022-06-21 21:42:00","inspection_id":"75878275","insp_unit_id":"189375879","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"142","insp_unit_license":"YCB8122","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1GT49TEY5NF177364","insp_unit_decal":"Y","insp_unit_decal_number":"31339246","created_at":"2025-03-17T22:14:42.000000Z","updated_at":"2025-03-17T22:14:42.000000Z"}]},{"id":419084,"change_date":"2022-05-18 21:43:00","inspection_id":"75592847","dot_number":"1470307","report_state":"IA","report_number":"000TT83KN3","insp_date":"2022-05-17 00:00:00","insp_start_time":"0754","insp_end_time":"0830","registration_date":null,"region":"CT","ci_status_code":"C","location":"39","location_desc":"39 - I35 SB MM 212 NORTHWOOD","county_code_state":"IA","county_code":"195","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"B&B GAS PIPING PLUS LLC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-18 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"34025","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1225554","transaction_code":"A","transaction_date":"2022-05-18 00:00:00","upload_date":"2022-05-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01470307","upload_search_indicator":"M","census_search_date":"2022-05-18 21:43:00","snet_input_date":"2022-05-17 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-05-18 21:43:00","insp_carrier_name":"B&B GAS PIPING PLUS LLC","insp_carrier_street":"1210 EAST 12TH STREET","insp_carrier_city":"FAIRMONT","insp_carrier_state":"MN","insp_carrier_zip_code":"56031","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:34:50.000000Z","updated_at":"2025-03-17T18:34:50.000000Z","inspection_violations":[{"id":655927,"change_date":"2022-05-18 21:43:00","inspection_id":"75592847","insp_violation_id":"245878231","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188758123","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:04.000000Z","updated_at":"2025-03-17T21:10:04.000000Z","normalized_code":"3922"},{"id":655928,"change_date":"2022-05-18 21:43:00","inspection_id":"75592847","insp_violation_id":"245878232","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"188758124","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:10:04.000000Z","updated_at":"2025-03-17T21:10:04.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":676405,"change_date":"2022-05-18 21:43:00","inspection_id":"75592847","insp_unit_id":"188758123","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"132","insp_unit_license":"YBW4397","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1GT42UCY0KF189317","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:21.000000Z","updated_at":"2025-03-17T22:12:21.000000Z"},{"id":676406,"change_date":"2022-05-18 21:43:00","inspection_id":"75592847","insp_unit_id":"188758124","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HMDE","insp_unit_company":"214","insp_unit_license":"6802CTA","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"56JTE2838GA148781","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:21.000000Z","updated_at":"2025-03-17T22:12:21.000000Z"}]},{"id":349667,"change_date":"2022-05-09 21:42:00","inspection_id":"75510274","dot_number":"1470307","report_state":"SD","report_number":"0523005119","insp_date":"2022-05-09 00:00:00","insp_start_time":"1020","insp_end_time":"1033","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SIOUX FALLS PORT OF ENTRY","county_code_state":"SD","county_code":"099","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"SELF","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-05-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"39000","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":"616708","transaction_code":"A","transaction_date":"2022-05-09 00:00:00","upload_date":"2022-05-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01470307","upload_search_indicator":"M","census_search_date":"2022-05-09 21:42:00","snet_input_date":"2022-05-09 00:00:00","source_office":"4SDS001","mcmis_add_date":"2022-05-09 21:42:00","insp_carrier_name":"B&B GAS PIPING PLUS LLC","insp_carrier_street":"1210 EAST 12TH STREET","insp_carrier_city":"FAIRMONT","insp_carrier_state":"MN","insp_carrier_zip_code":"56031","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:33:39.000000Z","updated_at":"2025-03-17T18:33:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":565628,"change_date":"2022-05-09 21:42:00","inspection_id":"75510274","insp_unit_id":"188584085","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"142","insp_unit_license":"YCB8122","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1GT49TEY5NF177364","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:41.000000Z","updated_at":"2025-03-17T22:11:41.000000Z"},{"id":565629,"change_date":"2022-05-09 21:42:00","inspection_id":"75510274","insp_unit_id":"188584086","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":"221","insp_unit_license":"CHT8236","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"47SF272T511018335","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:41.000000Z","updated_at":"2025-03-17T22:11:41.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1470307\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1470307\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1470307\/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\/1470307\/inspections","per_page":100,"prev_page_url":null,"to":26,"total":26}