{"current_page":1,"data":[{"id":12233685,"change_date":"2026-06-19 21:38:00","inspection_id":"88191272","dot_number":"309440","report_state":"NH","report_number":"1305000359","insp_date":"2026-06-19 00:00:00","insp_start_time":"1230","insp_end_time":"1245","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"NH","county_code_state":"NH","county_code":"015","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"BELLAVANCE BEVERAGE CO INC","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":"Y","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-19 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3581415","transaction_code":"A","transaction_date":"2026-06-19 00:00:00","upload_date":"2026-06-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00309440","upload_search_indicator":null,"census_search_date":"2026-06-19 21:38:00","snet_input_date":"2026-06-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-19 21:38:00","insp_carrier_name":"BELLAVANCE BEVERAGE CO INC","insp_carrier_street":"46 PETTENGILL ROAD","insp_carrier_city":"LONDONDERRY","insp_carrier_state":"NH","insp_carrier_zip_code":"03053","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-22T09:41:26.000000Z","updated_at":"2026-06-30T09:30:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21245568,"change_date":"2026-06-19 21:38:00","inspection_id":"88191272","insp_unit_id":"214192192","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"5347","insp_unit_license":"AH3358","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"3ALHCYFE6RDVD5480","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-22T09:18:41.000000Z","updated_at":"2026-06-30T09:01:46.000000Z"}]},{"id":12154019,"change_date":"2026-06-10 21:45:00","inspection_id":"88103447","dot_number":"309440","report_state":"NH","report_number":"1305000275","insp_date":"2026-04-21 00:00:00","insp_start_time":"1305","insp_end_time":"1335","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"NH","county_code_state":"NH","county_code":"015","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"BELLAVANCE BEVERAGE CO INC","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":"Y","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-10 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"78350","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":"3512017","transaction_code":"A","transaction_date":"2026-06-10 00:00:00","upload_date":"2026-06-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00309440","upload_search_indicator":null,"census_search_date":"2026-06-10 21:45:00","snet_input_date":"2026-04-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-10 21:45:00","insp_carrier_name":"BELLAVANCE BEVERAGE CO INC","insp_carrier_street":"46 PETTENGILL ROAD","insp_carrier_city":"LONDONDERRY","insp_carrier_state":"NH","insp_carrier_zip_code":"03053","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-13T09:41:36.000000Z","updated_at":"2026-06-21T09:32:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21112674,"change_date":"2026-06-10 21:45:00","inspection_id":"88103447","insp_unit_id":"214024983","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":null,"insp_unit_company":"5219","insp_unit_license":"7AP955","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"3AKJHLDR8PSUF8409","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-13T09:18:08.000000Z","updated_at":"2026-06-21T09:03:37.000000Z"},{"id":21112675,"change_date":"2026-06-10 21:45:00","inspection_id":"88103447","insp_unit_id":"214024984","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VAN GUARD","insp_unit_company":null,"insp_unit_license":"T511728","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"5V8VA4523PM310731","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-13T09:18:08.000000Z","updated_at":"2026-06-21T09:03:37.000000Z"}]},{"id":11581545,"change_date":"2026-04-07 21:38:00","inspection_id":"87506024","dot_number":"309440","report_state":"NH","report_number":"1313001102","insp_date":"2026-04-02 00:00:00","insp_start_time":"1323","insp_end_time":"1355","registration_date":"2026-04-02 00:00:00","region":"ED","ci_status_code":"C","location":"237","location_desc":"NH","county_code_state":"NH","county_code":"015","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"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":"Y","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-07 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"3123953","transaction_code":"A","transaction_date":"2026-04-07 00:00:00","upload_date":"2026-04-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00309440","upload_search_indicator":null,"census_search_date":"2026-04-07 21:38:00","snet_input_date":"2026-04-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-07 21:38:00","insp_carrier_name":"BELLAVANCE BEVERAGE CO INC","insp_carrier_street":"46 PETTENGILL ROAD","insp_carrier_city":"LONDONDERRY","insp_carrier_state":"NH","insp_carrier_zip_code":"03053","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-10T09:43:07.000000Z","updated_at":"2026-04-17T09:50:51.000000Z","inspection_violations":[{"id":19585921,"change_date":"2026-04-07 21:38:00","inspection_id":"87506024","insp_violation_id":"272908774","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"212575090","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-04-09T10:16:33.000000Z","updated_at":"2026-04-18T10:41:52.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":19850779,"change_date":"2026-04-07 21:38:00","inspection_id":"87506024","insp_unit_id":"212575090","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":null,"insp_unit_company":"214472","insp_unit_license":"3880624","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALHCYFE5KDKM4754","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-10T09:22:20.000000Z","updated_at":"2026-04-18T09:28:04.000000Z"}]},{"id":12149928,"change_date":"2026-06-10 21:44:00","inspection_id":"88099007","dot_number":"309440","report_state":"NH","report_number":"0995001199","insp_date":"2026-03-24 00:00:00","insp_start_time":"0550","insp_end_time":"0615","registration_date":null,"region":"ED","ci_status_code":"C","location":"237","location_desc":"NH","county_code_state":"NH","county_code":"015","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"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":"Y","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-10 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"3510937","transaction_code":"A","transaction_date":"2026-06-10 00:00:00","upload_date":"2026-06-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00309440","upload_search_indicator":null,"census_search_date":"2026-06-10 21:44:00","snet_input_date":"2026-03-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-10 21:44:00","insp_carrier_name":"BELLAVANCE BEVERAGE CO INC","insp_carrier_street":"46 PETTENGILL ROAD","insp_carrier_city":"LONDONDERRY","insp_carrier_state":"NH","insp_carrier_zip_code":"03053","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-13T09:41:31.000000Z","updated_at":"2026-06-21T09:31:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21106482,"change_date":"2026-06-10 21:44:00","inspection_id":"88099007","insp_unit_id":"214018036","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":null,"insp_unit_company":null,"insp_unit_license":"7AP849","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"3ALHCYFE5PDNM9310","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-13T09:17:58.000000Z","updated_at":"2026-06-21T09:02:33.000000Z"}]},{"id":12149690,"change_date":"2026-06-10 21:44:00","inspection_id":"88098749","dot_number":"309440","report_state":"NH","report_number":"1201000270","insp_date":"2026-03-23 00:00:00","insp_start_time":"1018","insp_end_time":"1035","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"NH","county_code_state":"NH","county_code":"015","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"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":"Y","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-10 21:44: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":"3510704","transaction_code":"A","transaction_date":"2026-06-10 00:00:00","upload_date":"2026-06-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00309440","upload_search_indicator":null,"census_search_date":"2026-06-10 21:44:00","snet_input_date":"2026-03-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-10 21:44:00","insp_carrier_name":"BELLAVANCE BEVERAGE CO INC","insp_carrier_street":"46 PETTENGILL ROAD","insp_carrier_city":"LONDONDERRY","insp_carrier_state":"NH","insp_carrier_zip_code":"03053","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-13T09:41:31.000000Z","updated_at":"2026-06-21T09:31:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21106196,"change_date":"2026-06-10 21:44:00","inspection_id":"88098749","insp_unit_id":"214017711","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":null,"insp_unit_company":"5220","insp_unit_license":"AH3616","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"3AKJHLDR4PSUF8410","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-13T09:17:57.000000Z","updated_at":"2026-06-21T09:02:28.000000Z"},{"id":21106197,"change_date":"2026-06-10 21:44:00","inspection_id":"88098749","insp_unit_id":"214017712","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":null,"insp_unit_company":null,"insp_unit_license":"T511728","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"5V8VA4523PM310731","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-13T09:17:57.000000Z","updated_at":"2026-06-21T09:02:28.000000Z"}]},{"id":12149316,"change_date":"2026-06-10 21:44:00","inspection_id":"88098336","dot_number":"309440","report_state":"NH","report_number":"1201000208","insp_date":"2026-01-28 00:00:00","insp_start_time":"1341","insp_end_time":"1352","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"NH","county_code_state":"NH","county_code":"015","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"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":"Y","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-10 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"3510557","transaction_code":"A","transaction_date":"2026-06-10 00:00:00","upload_date":"2026-06-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00309440","upload_search_indicator":null,"census_search_date":"2026-06-10 21:44:00","snet_input_date":"2026-01-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-10 21:44:00","insp_carrier_name":"BELLAVANCE BEVERAGE CO INC","insp_carrier_street":"46 PETTENGILL ROAD","insp_carrier_city":"LONDONDERRY","insp_carrier_state":"NH","insp_carrier_zip_code":"03053","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-13T09:41:30.000000Z","updated_at":"2026-06-21T09:31:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21105761,"change_date":"2026-06-10 21:44:00","inspection_id":"88098336","insp_unit_id":"214017209","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"AH4009","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"3ALHCYFE5PDUJ5817","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-13T09:17:56.000000Z","updated_at":"2026-06-21T09:02:28.000000Z"}]},{"id":10077262,"change_date":"2025-10-30 21:42:00","inspection_id":"86191379","dot_number":"309440","report_state":"NH","report_number":"0953007320","insp_date":"2025-07-03 00:00:00","insp_start_time":"0535","insp_end_time":"0555","registration_date":null,"region":"ED","ci_status_code":"C","location":"061","location_desc":"NH","county_code_state":"NH","county_code":"011","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"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":"U","pen_cen_match":"I","final_status_date":"2025-10-30 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2479410","transaction_code":"A","transaction_date":"2025-10-30 00:00:00","upload_date":"2025-10-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00309440","upload_search_indicator":null,"census_search_date":"2025-10-30 21:42:00","snet_input_date":"2025-07-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-30 21:42:00","insp_carrier_name":"BELLAVANCE BEVERAGE CO INC","insp_carrier_street":"46 PETTENGILL ROAD","insp_carrier_city":"LONDONDERRY","insp_carrier_state":"NH","insp_carrier_zip_code":"03053","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-02T11:02:11.000000Z","updated_at":"2025-11-03T11:00:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16752378,"change_date":"2025-10-30 21:42:00","inspection_id":"86191379","insp_unit_id":"209738738","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"AH3359","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"3ALHCYFEXRDVD5479","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-02T10:47:30.000000Z","updated_at":"2025-11-03T10:46:00.000000Z"}]},{"id":7943247,"change_date":"2025-02-24 21:40:00","inspection_id":"83944256","dot_number":"309440","report_state":"NH","report_number":"1291004072","insp_date":"2025-02-21 00:00:00","insp_start_time":"1115","insp_end_time":"1130","registration_date":null,"region":"ET","ci_status_code":"C","location":"023","location_desc":"KEENE (TRUCK LANES N\/B)","county_code_state":"NH","county_code":"005","insp_level_id":"3","service_center":"EA","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":"Y","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-02-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"282595","transaction_code":"A","transaction_date":"2025-02-21 00:00:00","upload_date":"2025-02-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00309440","upload_search_indicator":null,"census_search_date":"2025-02-24 21:40:00","snet_input_date":"2025-02-21 00:00:00","source_office":"1NHS001","mcmis_add_date":"2025-02-24 21:40:00","insp_carrier_name":"BELLAVANCE BEVERAGE CO INC","insp_carrier_street":"46 PETTENGILL ROAD","insp_carrier_city":"LONDONDERRY","insp_carrier_state":"NH","insp_carrier_zip_code":"03053","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:03:14.000000Z","updated_at":"2025-03-17T21:03:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12822681,"change_date":"2025-02-24 21:40:00","inspection_id":"83944256","insp_unit_id":"205465289","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"5202","insp_unit_license":"AH4009","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"3ALHCYFE5PDUJ5817","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:39.000000Z","updated_at":"2025-03-17T23:56:39.000000Z"}]},{"id":7841088,"change_date":"2025-02-11 21:40:00","inspection_id":"83837166","dot_number":"309440","report_state":"NH","report_number":"1313000162","insp_date":"2025-02-10 00:00:00","insp_start_time":"1417","insp_end_time":"1440","registration_date":null,"region":"ET","ci_status_code":"C","location":"032","location_desc":"21 JONES ROAD MILFORD","county_code_state":"NH","county_code":"011","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"BELLAVANCE BEVERAGE CO INC","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":"Y","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-02-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"78350","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":"282223","transaction_code":"A","transaction_date":"2025-02-10 00:00:00","upload_date":"2025-02-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00309440","upload_search_indicator":null,"census_search_date":"2025-02-11 21:40:00","snet_input_date":"2025-02-10 00:00:00","source_office":"1NHS001","mcmis_add_date":"2025-02-11 21:40:00","insp_carrier_name":"BELLAVANCE BEVERAGE CO INC","insp_carrier_street":"46 PETTENGILL ROAD","insp_carrier_city":"LONDONDERRY","insp_carrier_state":"NH","insp_carrier_zip_code":"03053","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:01:08.000000Z","updated_at":"2025-03-17T21:01:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12654685,"change_date":"2025-02-11 21:40:00","inspection_id":"83837166","insp_unit_id":"205267686","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"5220","insp_unit_license":"AH3616","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"3AKJHLDR4PSUF8410","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:45.000000Z","updated_at":"2025-03-17T23:54:45.000000Z"},{"id":12654686,"change_date":"2025-02-11 21:40:00","inspection_id":"83837166","insp_unit_id":"205267687","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VANG","insp_unit_company":"1","insp_unit_license":"T714055","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"5V8VA3620PM310730","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:45.000000Z","updated_at":"2025-03-17T23:54:45.000000Z"}]},{"id":7726218,"change_date":"2025-01-28 21:39:00","inspection_id":"83716176","dot_number":"309440","report_state":"NH","report_number":"0896001177","insp_date":"2025-01-27 00:00:00","insp_start_time":"1309","insp_end_time":"1325","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"RTE. 101 MARLBOROUGH DOT SHEDS","county_code_state":"NH","county_code":"005","insp_level_id":"3","service_center":"EA","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":"Y","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-01-28 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"53220","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":"281911","transaction_code":"A","transaction_date":"2025-01-27 00:00:00","upload_date":"2025-01-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00309440","upload_search_indicator":null,"census_search_date":"2025-01-28 21:39:00","snet_input_date":"2025-01-27 00:00:00","source_office":"1NHS001","mcmis_add_date":"2025-01-28 21:39:00","insp_carrier_name":"BELLAVANCE BEVERAGE CO INC","insp_carrier_street":"46 PETTENGILL ROAD","insp_carrier_city":"LONDONDERRY","insp_carrier_state":"NH","insp_carrier_zip_code":"03053","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:58:41.000000Z","updated_at":"2025-03-17T20:58:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12467990,"change_date":"2025-01-28 21:39:00","inspection_id":"83716176","insp_unit_id":"205039811","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"AH3870","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"3ALHCYFE7RDUT9927","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:34.000000Z","updated_at":"2025-03-17T23:52:34.000000Z"}]},{"id":6890436,"change_date":"2024-10-04 21:39:00","inspection_id":"82834237","dot_number":"309440","report_state":"NH","report_number":"0953007167","insp_date":"2024-10-04 00:00:00","insp_start_time":"0653","insp_end_time":"0720","registration_date":null,"region":"ET","ci_status_code":"C","location":"031","location_desc":"MERRIMACK","county_code_state":"NH","county_code":"011","insp_level_id":"3","service_center":"EA","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":"N","pen_cen_match":null,"final_status_date":"2024-10-04 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"3","oos_total":"2","driver_viol_total":"3","driver_oos_total":"2","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"279226","transaction_code":"A","transaction_date":"2024-10-04 00:00:00","upload_date":"2024-10-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00309440","upload_search_indicator":null,"census_search_date":"2024-10-04 21:39:00","snet_input_date":"2024-10-04 00:00:00","source_office":"1NHS001","mcmis_add_date":"2024-10-04 21:39:00","insp_carrier_name":"BELLAVANCE BEVERAGE CO INC","insp_carrier_street":"46 PETTENGILL ROAD","insp_carrier_city":"LONDONDERRY","insp_carrier_state":"NH","insp_carrier_zip_code":"03053","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:39:49.000000Z","updated_at":"2025-03-17T20:39:49.000000Z","inspection_violations":[{"id":10734818,"change_date":"2024-10-04 21:39:00","inspection_id":"82834237","insp_violation_id":"262191362","seq_no":"1","part_no":"392","part_no_section":"2","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:57:58.000000Z","updated_at":"2025-03-17T21:57:58.000000Z","normalized_code":"3922"},{"id":10734819,"change_date":"2024-10-04 21:39:00","inspection_id":"82834237","insp_violation_id":"262191363","seq_no":"2","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:58.000000Z","updated_at":"2025-03-17T21:57:58.000000Z","normalized_code":"38323A2"},{"id":10734820,"change_date":"2024-10-04 21:39:00","inspection_id":"82834237","insp_violation_id":"262191364","seq_no":"3","part_no":"391","part_no_section":"11(b)(4)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:58.000000Z","updated_at":"2025-03-17T21:57:58.000000Z","normalized_code":"39111B4"}],"inspection_per_units":[{"id":11112515,"change_date":"2024-10-04 21:39:00","inspection_id":"82834237","insp_unit_id":"203271979","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"7AP849","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"3ALHCYFE5PDNM9310","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:04.000000Z","updated_at":"2025-03-17T23:38:04.000000Z"}]},{"id":6793507,"change_date":"2024-09-23 21:40:00","inspection_id":"82731510","dot_number":"309440","report_state":"NH","report_number":"1291003778","insp_date":"2024-09-19 00:00:00","insp_start_time":"1342","insp_end_time":"1405","registration_date":null,"region":"ET","ci_status_code":"C","location":"009","location_desc":"DUBLIN","county_code_state":"NH","county_code":"005","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","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":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"278904","transaction_code":"A","transaction_date":"2024-09-19 00:00:00","upload_date":"2024-09-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00309440","upload_search_indicator":null,"census_search_date":"2024-09-23 21:40:00","snet_input_date":"2024-09-19 00:00:00","source_office":"1NHS001","mcmis_add_date":"2024-09-23 21:40:00","insp_carrier_name":"BELLAVANCE BEVERAGE CO INC","insp_carrier_street":"46 PETTENGILL ROAD","insp_carrier_city":"LONDONDERRY","insp_carrier_state":"NH","insp_carrier_zip_code":"03053","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:37:46.000000Z","updated_at":"2025-03-17T20:37:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10955061,"change_date":"2024-09-23 21:40:00","inspection_id":"82731510","insp_unit_id":"203077711","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"5019","insp_unit_license":"7AP560","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"3ALHCYFE9PDNM9309","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:30.000000Z","updated_at":"2025-03-17T23:36:30.000000Z"}]},{"id":6594558,"change_date":"2024-08-29 21:42:00","inspection_id":"82519250","dot_number":"309440","report_state":"NH","report_number":"1291003713","insp_date":"2024-08-28 00:00:00","insp_start_time":"1505","insp_end_time":"1550","registration_date":null,"region":"ET","ci_status_code":"C","location":"029","location_desc":"MARLBORO","county_code_state":"NH","county_code":"005","insp_level_id":"1","service_center":"EA","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":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"53250","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":"278016","transaction_code":"A","transaction_date":"2024-08-28 00:00:00","upload_date":"2024-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00309440","upload_search_indicator":null,"census_search_date":"2024-08-29 21:42:00","snet_input_date":"2024-08-28 00:00:00","source_office":"1NHS001","mcmis_add_date":"2024-08-29 21:42:00","insp_carrier_name":"BELLAVANCE BEVERAGE CO INC","insp_carrier_street":"46 PETTENGILL ROAD","insp_carrier_city":"LONDONDERRY","insp_carrier_state":"NH","insp_carrier_zip_code":"03053","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:33:41.000000Z","updated_at":"2025-03-17T20:33:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10631664,"change_date":"2024-08-29 21:42:00","inspection_id":"82519250","insp_unit_id":"202649519","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"5309","insp_unit_license":"AH3870","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"3ALHCYFE7RDUT9927","insp_unit_decal":"Y","insp_unit_decal_number":"34407650","created_at":"2025-03-17T23:33:07.000000Z","updated_at":"2025-03-17T23:33:07.000000Z"}]},{"id":5894461,"change_date":"2024-06-03 21:42:00","inspection_id":"81767517","dot_number":"309440","report_state":"NH","report_number":"1291003493","insp_date":"2024-05-28 00:00:00","insp_start_time":"1439","insp_end_time":"1455","registration_date":null,"region":"ET","ci_status_code":"C","location":"009","location_desc":"DUBLIN","county_code_state":"NH","county_code":"005","insp_level_id":"3","service_center":"EA","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":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-03 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"275492","transaction_code":"A","transaction_date":"2024-05-28 00:00:00","upload_date":"2024-06-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00309440","upload_search_indicator":null,"census_search_date":"2024-06-03 21:42:00","snet_input_date":"2024-05-28 00:00:00","source_office":"1NHS001","mcmis_add_date":"2024-06-03 21:42:00","insp_carrier_name":"BELLAVANCE BEVERAGE CO INC","insp_carrier_street":"46 PETTENGILL ROAD","insp_carrier_city":"LONDONDERRY","insp_carrier_state":"NH","insp_carrier_zip_code":"03053","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:19:29.000000Z","updated_at":"2025-03-17T20:19:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9494141,"change_date":"2024-06-03 21:42:00","inspection_id":"81767517","insp_unit_id":"201194674","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"4910","insp_unit_license":"AH3612","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"3ALHCYFE2MDMP9888","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:28.000000Z","updated_at":"2025-03-17T23:21:28.000000Z"}]},{"id":5752301,"change_date":"2024-05-15 21:43:00","inspection_id":"81613608","dot_number":"309440","report_state":"NH","report_number":"0940000690","insp_date":"2024-05-14 00:00:00","insp_start_time":"1327","insp_end_time":"1340","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"TRUCK LANES NB ROUTE 12","county_code_state":"NH","county_code":"005","insp_level_id":"3","service_center":"EA","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":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-15 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"53220","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":"274982","transaction_code":"A","transaction_date":"2024-05-14 00:00:00","upload_date":"2024-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00309440","upload_search_indicator":null,"census_search_date":"2024-05-15 21:43:00","snet_input_date":"2024-05-14 00:00:00","source_office":"1NHS001","mcmis_add_date":"2024-05-15 21:43:00","insp_carrier_name":"BELLAVANCE BEVERAGE CO INC","insp_carrier_street":"46 PETTENGILL ROAD","insp_carrier_city":"LONDONDERRY","insp_carrier_state":"NH","insp_carrier_zip_code":"03053","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:16:42.000000Z","updated_at":"2025-03-17T20:16:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9264962,"change_date":"2024-05-15 21:43:00","inspection_id":"81613608","insp_unit_id":"200899720","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"5349","insp_unit_license":"AH3356","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"3ALHCYFEXRDVD5482","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:12.000000Z","updated_at":"2025-03-17T23:19:12.000000Z"}]},{"id":5284530,"change_date":"2024-03-14 21:41:00","inspection_id":"81103674","dot_number":"309440","report_state":"NH","report_number":"0940000676","insp_date":"2024-03-13 00:00:00","insp_start_time":"0844","insp_end_time":"0900","registration_date":null,"region":"ET","ci_status_code":"C","location":"023","location_desc":"ROUTE 9\/ASHBROOK ROAD-KEENE","county_code_state":"NH","county_code":"005","insp_level_id":"3","service_center":"EA","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":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"53220","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":"273620","transaction_code":"A","transaction_date":"2024-03-13 00:00:00","upload_date":"2024-03-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00309440","upload_search_indicator":null,"census_search_date":"2024-03-14 21:41:00","snet_input_date":"2024-03-13 00:00:00","source_office":"1NHS001","mcmis_add_date":"2024-03-14 21:41:00","insp_carrier_name":"BELLAVANCE BEVERAGE CO INC","insp_carrier_street":"46 PETTENGILL ROAD","insp_carrier_city":"LONDONDERRY","insp_carrier_state":"NH","insp_carrier_zip_code":"03053","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:07:28.000000Z","updated_at":"2025-03-17T20:07:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8509779,"change_date":"2024-03-14 21:41:00","inspection_id":"81103674","insp_unit_id":"199908374","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"5346","insp_unit_license":"AH3359","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"3ALHCYFEXRDVD5479","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:06.000000Z","updated_at":"2025-03-17T23:12:06.000000Z"}]},{"id":4692412,"change_date":"2023-12-22 21:41:00","inspection_id":"80457204","dot_number":"309440","report_state":"NH","report_number":"1128001344","insp_date":"2023-12-21 00:00:00","insp_start_time":"1205","insp_end_time":"1221","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"FRANCESTOWN","county_code_state":"NH","county_code":"011","insp_level_id":"3","service_center":"EA","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":"Y","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-12-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"271913","transaction_code":"A","transaction_date":"2023-12-21 00:00:00","upload_date":"2023-12-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00309440","upload_search_indicator":null,"census_search_date":"2023-12-22 21:41:00","snet_input_date":"2023-12-21 00:00:00","source_office":"1NHS001","mcmis_add_date":"2023-12-22 21:41:00","insp_carrier_name":"BELLAVANCE BEVERAGE CO INC","insp_carrier_street":"46 PETTENGILL ROAD","insp_carrier_city":"LONDONDERRY","insp_carrier_state":"NH","insp_carrier_zip_code":"03053","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:55:47.000000Z","updated_at":"2025-03-17T19:55:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7547568,"change_date":"2023-12-22 21:41:00","inspection_id":"80457204","insp_unit_id":"198638597","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"4910","insp_unit_license":"AH3612","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"3ALHCYFE2MDMP9888","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:28.000000Z","updated_at":"2025-03-17T23:03:28.000000Z"}]},{"id":4597152,"change_date":"2023-12-11 21:40:00","inspection_id":"80352697","dot_number":"309440","report_state":"NH","report_number":"0850000942","insp_date":"2023-12-08 00:00:00","insp_start_time":"1345","insp_end_time":"1445","registration_date":null,"region":"ET","ci_status_code":"C","location":"237","location_desc":"LONDONDERRY","county_code_state":"NH","county_code":"015","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"BELLAVANCE BEVERAGE CO INC","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":"Y","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-12-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"53220","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"271550","transaction_code":"A","transaction_date":"2023-12-08 00:00:00","upload_date":"2023-12-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00309440","upload_search_indicator":null,"census_search_date":"2023-12-11 21:40:00","snet_input_date":"2023-12-08 00:00:00","source_office":"1NHS001","mcmis_add_date":"2023-12-11 21:40:00","insp_carrier_name":"BELLAVANCE BEVERAGE CO INC","insp_carrier_street":"46 PETTENGILL ROAD","insp_carrier_city":"LONDONDERRY","insp_carrier_state":"NH","insp_carrier_zip_code":"03053","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:53:50.000000Z","updated_at":"2025-03-17T19:53:50.000000Z","inspection_violations":[{"id":7110119,"change_date":"2023-12-11 21:40:00","inspection_id":"80352697","insp_violation_id":"256808797","seq_no":"1","part_no":"383","part_no_section":"95(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:21.000000Z","updated_at":"2025-03-17T21:40:21.000000Z","normalized_code":"38395A"}],"inspection_per_units":[{"id":7394008,"change_date":"2023-12-11 21:40:00","inspection_id":"80352697","insp_unit_id":"198435177","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"4441","insp_unit_license":"AH3599","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"3ALHCYCY6HDJC7851","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:08.000000Z","updated_at":"2025-03-17T23:02:08.000000Z"}]},{"id":4567360,"change_date":"2023-12-06 21:41:00","inspection_id":"80319989","dot_number":"309440","report_state":"NH","report_number":"0945003791","insp_date":"2023-12-05 00:00:00","insp_start_time":"1200","insp_end_time":"1245","registration_date":null,"region":"ET","ci_status_code":"C","location":"237","location_desc":"WINDHAM SCALES NORTHBOUND","county_code_state":"NH","county_code":"015","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"BELLAVANCE BEVERAGE CO INC","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":"Y","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-12-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"271452","transaction_code":"A","transaction_date":"2023-12-05 00:00:00","upload_date":"2023-12-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00309440","upload_search_indicator":null,"census_search_date":"2023-12-06 21:41:00","snet_input_date":"2023-12-05 00:00:00","source_office":"1NHS001","mcmis_add_date":"2023-12-06 21:41:00","insp_carrier_name":"BELLAVANCE BEVERAGE CO INC","insp_carrier_street":"46 PETTENGILL ROAD","insp_carrier_city":"LONDONDERRY","insp_carrier_state":"NH","insp_carrier_zip_code":"03053","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:53:23.000000Z","updated_at":"2025-03-17T19:53:23.000000Z","inspection_violations":[{"id":7065589,"change_date":"2023-12-06 21:41:00","inspection_id":"80319989","insp_violation_id":"256737593","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198369710","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:09.000000Z","updated_at":"2025-03-17T21:40:09.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":7345831,"change_date":"2023-12-06 21:41:00","inspection_id":"80319989","insp_unit_id":"198369710","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"AH3617","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"2NKHHM6X7GM110532","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:44.000000Z","updated_at":"2025-03-17T23:01:44.000000Z"}]},{"id":4180032,"change_date":"2023-10-12 21:41:00","inspection_id":"79892473","dot_number":"309440","report_state":"NH","report_number":"0940000596","insp_date":"2023-10-12 00:00:00","insp_start_time":"0620","insp_end_time":"0630","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROUTE 9\/31 HILLSBORO","county_code_state":"NH","county_code":"011","insp_level_id":"3","service_center":"EA","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":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-10-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"53250","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":"270022","transaction_code":"A","transaction_date":"2023-10-12 00:00:00","upload_date":"2023-10-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00309440","upload_search_indicator":null,"census_search_date":"2023-10-12 21:41:00","snet_input_date":"2023-10-12 00:00:00","source_office":"1NHS001","mcmis_add_date":"2023-10-12 21:41:00","insp_carrier_name":"BELLAVANCE BEVERAGE CO INC","insp_carrier_street":"46 PETTENGILL ROAD","insp_carrier_city":"LONDONDERRY","insp_carrier_state":"NH","insp_carrier_zip_code":"03053","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:45:48.000000Z","updated_at":"2025-03-17T19:45:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6721814,"change_date":"2023-10-12 21:41:00","inspection_id":"79892473","insp_unit_id":"197515593","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"5309","insp_unit_license":"AH3870","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"3ALHCYFE7RDUT9927","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:22.000000Z","updated_at":"2025-03-17T22:56:22.000000Z"}]},{"id":3989347,"change_date":"2023-09-18 21:38:00","inspection_id":"79680907","dot_number":"309440","report_state":"NH","report_number":"1291002987","insp_date":"2023-09-16 00:00:00","insp_start_time":"0635","insp_end_time":"0655","registration_date":null,"region":"ET","ci_status_code":"C","location":"009","location_desc":"DUBLIN","county_code_state":"NH","county_code":"005","insp_level_id":"3","service_center":"EA","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":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-18 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"269259","transaction_code":"A","transaction_date":"2023-09-16 00:00:00","upload_date":"2023-09-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00309440","upload_search_indicator":null,"census_search_date":"2023-09-18 21:38:00","snet_input_date":"2023-09-16 00:00:00","source_office":"1NHS001","mcmis_add_date":"2023-09-18 21:38:00","insp_carrier_name":"BELLAVANCE BEVERAGE CO INC","insp_carrier_street":"46 PETTENGILL ROAD","insp_carrier_city":"LONDONDERRY","insp_carrier_state":"NH","insp_carrier_zip_code":"03053","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:41:38.000000Z","updated_at":"2025-03-17T19:41:38.000000Z","inspection_violations":[{"id":6171638,"change_date":"2023-09-18 21:38:00","inspection_id":"79680907","insp_violation_id":"255312908","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:35:49.000000Z","updated_at":"2025-03-17T21:35:49.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6414625,"change_date":"2023-09-18 21:38:00","inspection_id":"79680907","insp_unit_id":"197092104","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"5202","insp_unit_license":"AH3581","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"3ALHCYFE5PDUJ5817","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:51.000000Z","updated_at":"2025-03-17T22:53:51.000000Z"}]},{"id":3529203,"change_date":"2023-07-26 21:40:00","inspection_id":"79166677","dot_number":"309440","report_state":"NH","report_number":"0953006344","insp_date":"2023-07-17 00:00:00","insp_start_time":"1354","insp_end_time":"1420","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"AMHERST","county_code_state":"NH","county_code":"011","insp_level_id":"3","service_center":"EA","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":"N","pen_cen_match":null,"final_status_date":"2023-07-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"267704","transaction_code":"C","transaction_date":"2023-07-26 00:00:00","upload_date":"2023-07-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00309440","upload_search_indicator":null,"census_search_date":"2023-07-18 21:41:00","snet_input_date":"2023-07-17 00:00:00","source_office":"1NHS001","mcmis_add_date":"2023-07-18 21:41:00","insp_carrier_name":"BELLAVANCE BEVERAGE CO INC","insp_carrier_street":"46 PETTENGILL ROAD","insp_carrier_city":"LONDONDERRY","insp_carrier_state":"NH","insp_carrier_zip_code":"03053","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:48.000000Z","updated_at":"2025-03-17T19:32:48.000000Z","inspection_violations":[{"id":5442088,"change_date":"2023-07-26 21:40:00","inspection_id":"79166677","insp_violation_id":"254280410","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:32:17.000000Z","updated_at":"2025-03-17T21:32:17.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":5674498,"change_date":"2023-07-26 21:40:00","inspection_id":"79166677","insp_unit_id":"196196655","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"AH3600","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1FVHCYFE4JHJP6715","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:46.000000Z","updated_at":"2025-03-17T22:47:46.000000Z"}]},{"id":3280725,"change_date":"2023-06-14 21:41:00","inspection_id":"78887417","dot_number":"309440","report_state":"NH","report_number":"0940000382","insp_date":"2023-06-13 00:00:00","insp_start_time":"0803","insp_end_time":"0814","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"TRUCK LANES NB ROUTE 12","county_code_state":"NH","county_code":"005","insp_level_id":"3","service_center":"EA","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":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-06-14 21:41: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":"266765","transaction_code":"A","transaction_date":"2023-06-13 00:00:00","upload_date":"2023-06-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00309440","upload_search_indicator":null,"census_search_date":"2023-06-14 21:41:00","snet_input_date":"2023-06-13 00:00:00","source_office":"1NHS001","mcmis_add_date":"2023-06-14 21:41:00","insp_carrier_name":"BELLAVANCE BEVERAGE CO INC","insp_carrier_street":"46 PETTENGILL ROAD","insp_carrier_city":"LONDONDERRY","insp_carrier_state":"NH","insp_carrier_zip_code":"03053","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:28:06.000000Z","updated_at":"2025-03-17T19:28:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5274913,"change_date":"2023-06-14 21:41:00","inspection_id":"78887417","insp_unit_id":"195487525","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"7AP955","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"3AKJHLDR8PSUF8409","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:34.000000Z","updated_at":"2025-03-17T22:44:34.000000Z"},{"id":5274914,"change_date":"2023-06-14 21:41:00","inspection_id":"78887417","insp_unit_id":"195487526","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VANG","insp_unit_company":null,"insp_unit_license":"T511728","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"5V8VA4523PM310731","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:34.000000Z","updated_at":"2025-03-17T22:44:34.000000Z"}]},{"id":2950413,"change_date":"2023-05-03 21:41:00","inspection_id":"78514371","dot_number":"309440","report_state":"NH","report_number":"0953006153","insp_date":"2023-05-02 00:00:00","insp_start_time":"1655","insp_end_time":"1710","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"AMHERST","county_code_state":"NH","county_code":"011","insp_level_id":"3","service_center":"EA","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":"N","pen_cen_match":null,"final_status_date":"2023-05-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"265857","transaction_code":"A","transaction_date":"2023-05-02 00:00:00","upload_date":"2023-05-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00309440","upload_search_indicator":null,"census_search_date":"2023-05-03 21:41:00","snet_input_date":"2023-05-02 00:00:00","source_office":"1NHS001","mcmis_add_date":"2023-05-03 21:41:00","insp_carrier_name":"BELLAVANCE BEVERAGE CO INC","insp_carrier_street":"46 PETTENGILL ROAD","insp_carrier_city":"LONDONDERRY","insp_carrier_state":"NH","insp_carrier_zip_code":"03053","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:21:23.000000Z","updated_at":"2025-03-17T19:21:23.000000Z","inspection_violations":[{"id":4528820,"change_date":"2023-05-03 21:41:00","inspection_id":"78514371","insp_violation_id":"252583640","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:28:07.000000Z","updated_at":"2025-03-17T21:28:07.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":4747230,"change_date":"2023-05-03 21:41:00","inspection_id":"78514371","insp_unit_id":"194716183","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"2568AP","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"3ALHCYCY6HDJC7848","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:25.000000Z","updated_at":"2025-03-17T22:40:25.000000Z"}]},{"id":2836271,"change_date":"2023-04-19 21:41:00","inspection_id":"78385217","dot_number":"309440","report_state":"NH","report_number":"0940000277","insp_date":"2023-04-18 00:00:00","insp_start_time":"0943","insp_end_time":"0952","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"TRUCK LANES NB ROUTE 12","county_code_state":"NH","county_code":"005","insp_level_id":"3","service_center":"EA","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":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-04-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"24140","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":"265685","transaction_code":"A","transaction_date":"2023-04-18 00:00:00","upload_date":"2023-04-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00309440","upload_search_indicator":null,"census_search_date":"2023-04-19 21:41:00","snet_input_date":"2023-04-18 00:00:00","source_office":"1NHS001","mcmis_add_date":"2023-04-19 21:41:00","insp_carrier_name":"BELLAVANCE BEVERAGE CO INC","insp_carrier_street":"46 PETTENGILL ROAD","insp_carrier_city":"LONDONDERRY","insp_carrier_state":"NH","insp_carrier_zip_code":"03053","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:18:57.000000Z","updated_at":"2025-03-17T19:18:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4565003,"change_date":"2023-04-19 21:41:00","inspection_id":"78385217","insp_unit_id":"194463407","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"2568AP","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"3ALHCYCY6HDJC7848","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:01.000000Z","updated_at":"2025-03-17T22:39:01.000000Z"}]},{"id":2001512,"change_date":"2022-12-22 21:39:00","inspection_id":"77433801","dot_number":"309440","report_state":"NH","report_number":"1291002602","insp_date":"2022-12-21 00:00:00","insp_start_time":"1245","insp_end_time":"1310","registration_date":null,"region":"ET","ci_status_code":"C","location":"023","location_desc":"KEENE (TRUCK LANES N\/B)","county_code_state":"NH","county_code":"005","insp_level_id":"2","service_center":"EA","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":"Y","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-12-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"53220","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":"263022","transaction_code":"A","transaction_date":"2022-12-21 00:00:00","upload_date":"2022-12-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00309440","upload_search_indicator":null,"census_search_date":"2022-12-22 21:39:00","snet_input_date":"2022-12-21 00:00:00","source_office":"1NHS001","mcmis_add_date":"2022-12-22 21:39:00","insp_carrier_name":"BELLAVANCE BEVERAGE CO INC","insp_carrier_street":"46 PETTENGILL ROAD","insp_carrier_city":"LONDONDERRY","insp_carrier_state":"NH","insp_carrier_zip_code":"03053","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:03:38.000000Z","updated_at":"2025-03-17T19:03:38.000000Z","inspection_violations":[{"id":3107217,"change_date":"2022-12-22 21:39:00","inspection_id":"77433801","insp_violation_id":"250234636","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192550107","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:45.000000Z","updated_at":"2025-03-17T21:21:45.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":3219940,"change_date":"2022-12-22 21:39:00","inspection_id":"77433801","insp_unit_id":"192550107","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"4513","insp_unit_license":"3539AP","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1FVHCYFE8JHJP6717","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:02.000000Z","updated_at":"2025-03-17T22:29:02.000000Z"}]},{"id":1226154,"change_date":"2022-09-07 21:40:00","inspection_id":"76540773","dot_number":"309440","report_state":"NH","report_number":"1291002441","insp_date":"2022-09-06 00:00:00","insp_start_time":"0923","insp_end_time":"0939","registration_date":null,"region":"ET","ci_status_code":"C","location":"023","location_desc":"KEENE (TRUCK LANES N\/B)","county_code_state":"NH","county_code":"005","insp_level_id":"3","service_center":"EA","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":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"260260","transaction_code":"A","transaction_date":"2022-09-06 00:00:00","upload_date":"2022-09-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00309440","upload_search_indicator":null,"census_search_date":"2022-09-07 21:40:00","snet_input_date":"2022-09-06 00:00:00","source_office":"1NHS001","mcmis_add_date":"2022-09-07 21:40:00","insp_carrier_name":"BELLAVANCE BEVERAGE CO INC","insp_carrier_street":"1000 QUALITY DR","insp_carrier_city":"HOOKSETT","insp_carrier_state":"NH","insp_carrier_zip_code":"03063","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:49:19.000000Z","updated_at":"2025-03-17T18:49:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1972952,"change_date":"2022-09-07 21:40:00","inspection_id":"76540773","insp_unit_id":"190755381","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"4911","insp_unit_license":"5AP198","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"3ALHCYFE4MDMP9889","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:33.000000Z","updated_at":"2025-03-17T22:20:33.000000Z"}]},{"id":869998,"change_date":"2022-07-22 21:39:00","inspection_id":"76125372","dot_number":"309440","report_state":"NH","report_number":"0896000525","insp_date":"2022-07-20 00:00:00","insp_start_time":"1330","insp_end_time":"1343","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"RTE. 101 MARLBOROUGH DOT SHEDS","county_code_state":"NH","county_code":"005","insp_level_id":"3","service_center":"EA","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":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"53220","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":"258801","transaction_code":"A","transaction_date":"2022-07-20 00:00:00","upload_date":"2022-07-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00309440","upload_search_indicator":null,"census_search_date":"2022-07-22 21:39:00","snet_input_date":"2022-07-20 00:00:00","source_office":"1NHS001","mcmis_add_date":"2022-07-22 21:39:00","insp_carrier_name":"BELLAVANCE BEVERAGE CO INC","insp_carrier_street":"1000 QUALITY DR","insp_carrier_city":"HOOKSETT","insp_carrier_state":"NH","insp_carrier_zip_code":"03063","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:43:02.000000Z","updated_at":"2025-03-17T18:43:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1400481,"change_date":"2022-07-22 21:39:00","inspection_id":"76125372","insp_unit_id":"189909623","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"AF7026","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1FVHCYCYXGHHR7239","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:48.000000Z","updated_at":"2025-03-17T22:16:48.000000Z"}]},{"id":852770,"change_date":"2022-07-20 21:41:00","inspection_id":"76105219","dot_number":"309440","report_state":"NH","report_number":"0995000678","insp_date":"2022-07-19 00:00:00","insp_start_time":"1140","insp_end_time":"1212","registration_date":null,"region":"ET","ci_status_code":"C","location":"237","location_desc":"WINDHAM SCALES NORTHBOUND","county_code_state":"NH","county_code":"015","insp_level_id":"3","service_center":"EA","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":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"258719","transaction_code":"A","transaction_date":"2022-07-19 00:00:00","upload_date":"2022-07-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00309440","upload_search_indicator":null,"census_search_date":"2022-07-20 21:41:00","snet_input_date":"2022-07-19 00:00:00","source_office":"1NHS001","mcmis_add_date":"2022-07-20 21:41:00","insp_carrier_name":"BELLAVANCE BEVERAGE CO INC","insp_carrier_street":"1000 QUALITY DR","insp_carrier_city":"HOOKSETT","insp_carrier_state":"NH","insp_carrier_zip_code":"03063","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:42:41.000000Z","updated_at":"2025-03-17T18:42:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1372652,"change_date":"2022-07-20 21:41:00","inspection_id":"76105219","insp_unit_id":"189866535","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"3624AP","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1FVHCYFE6JHJP6716","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:37.000000Z","updated_at":"2025-03-17T22:16:37.000000Z"}]},{"id":825644,"change_date":"2022-07-15 21:40:00","inspection_id":"76073540","dot_number":"309440","report_state":"NH","report_number":"0945002864","insp_date":"2022-07-14 00:00:00","insp_start_time":"1320","insp_end_time":"1400","registration_date":null,"region":"ET","ci_status_code":"C","location":"237","location_desc":"WINDHAM SCALES NORTHBOUND","county_code_state":"NH","county_code":"015","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"BELLAVANCE BEVERAGE CO INC","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":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"258525","transaction_code":"A","transaction_date":"2022-07-14 00:00:00","upload_date":"2022-07-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00309440","upload_search_indicator":null,"census_search_date":"2022-07-15 21:40:00","snet_input_date":"2022-07-14 00:00:00","source_office":"1NHS001","mcmis_add_date":"2022-07-15 21:40:00","insp_carrier_name":"BELLAVANCE BEVERAGE CO INC","insp_carrier_street":"1000 QUALITY DR","insp_carrier_city":"HOOKSETT","insp_carrier_state":"NH","insp_carrier_zip_code":"03063","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:42:17.000000Z","updated_at":"2025-03-17T18:42:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1328230,"change_date":"2022-07-15 21:40:00","inspection_id":"76073540","insp_unit_id":"189795495","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"3623AP","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1FVHCYFE4JHJP6715","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:21.000000Z","updated_at":"2025-03-17T22:16:21.000000Z"}]},{"id":1844,"change_date":"2022-03-24 21:31:00","inspection_id":"75079491","dot_number":"309440","report_state":"NH","report_number":"1291002161","insp_date":"2022-03-17 00:00:00","insp_start_time":"1046","insp_end_time":"1103","registration_date":null,"region":"ET","ci_status_code":"C","location":"023","location_desc":"KEENE (TRUCK LANES N\/B)","county_code_state":"NH","county_code":"005","insp_level_id":"3","service_center":"EA","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":"Y","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-03-18 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"53000","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":"255686","transaction_code":"C","transaction_date":"2022-03-24 00:00:00","upload_date":"2022-03-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00309440","upload_search_indicator":null,"census_search_date":"2022-03-18 21:31:00","snet_input_date":"2022-03-17 00:00:00","source_office":"1NHS001","mcmis_add_date":"2022-03-18 21:31:00","insp_carrier_name":"BELLAVANCE BEVERAGE CO INC","insp_carrier_street":"1000 QUALITY DR","insp_carrier_city":"HOOKSETT","insp_carrier_state":"NH","insp_carrier_zip_code":"03063","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:27:42.000000Z","updated_at":"2025-03-17T18:27:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2891,"change_date":"2022-03-24 21:31:00","inspection_id":"75079491","insp_unit_id":"187796568","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"4513","insp_unit_license":"3539AP","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1FVHCYFE8JHJP6717","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:16.000000Z","updated_at":"2025-03-17T22:08:16.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/309440\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/309440\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/309440\/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\/309440\/inspections","per_page":100,"prev_page_url":null,"to":31,"total":31}