{"current_page":1,"data":[{"id":11883142,"change_date":"2026-05-12 21:39:00","inspection_id":"87820861","dot_number":"272172","report_state":"VT","report_number":"62A0001000","insp_date":"2026-05-12 00:00:00","insp_start_time":"0816","insp_end_time":"0835","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"VT","county_code_state":"VT","county_code":"027","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"JOHN DEGRANS & SON","shipping_paper_number":"260511-41","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"U","drug_intrdctn_search":"U","drug_intrdctn_arrests":"0","size_weight_enf":"U","traffic_enf":"U","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-12 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3304360","transaction_code":"A","transaction_date":"2026-05-12 00:00:00","upload_date":"2026-05-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00272172","upload_search_indicator":null,"census_search_date":"2026-05-12 21:39:00","snet_input_date":"2026-05-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-12 21:39:00","insp_carrier_name":"JOHN DEGRAND & SON INC","insp_carrier_street":"430 ISLAND LANE","insp_carrier_city":"WEST HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06516","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-14T12:39:25.000000Z","updated_at":"2026-05-23T09:30:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20661296,"change_date":"2026-05-12 21:39:00","inspection_id":"87820861","insp_unit_id":"213498511","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"80025A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3HAEUTANXSL649165","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-14T12:01:23.000000Z","updated_at":"2026-05-23T09:03:11.000000Z"}]},{"id":11602743,"change_date":"2026-04-09 21:54:00","inspection_id":"87529672","dot_number":"272172","report_state":"NY","report_number":"SPK3060114","insp_date":"2026-04-02 00:00:00","insp_start_time":"0920","insp_end_time":"0937","registration_date":null,"region":"ED","ci_status_code":"C","location":"80018","location_desc":"WASSAIC NY","county_code_state":"NY","county_code":"027","insp_level_id":"2","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":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-04-09 21:54:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"3132552","transaction_code":"A","transaction_date":"2026-04-08 00:00:00","upload_date":"2026-04-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00272172","upload_search_indicator":null,"census_search_date":"2026-04-09 21:54:00","snet_input_date":"2026-04-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-09 21:54:00","insp_carrier_name":"JOHN DEGRAND & SON INC","insp_carrier_street":"430 ISLAND LANE","insp_carrier_city":"WEST HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06516","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-12T09:45:07.000000Z","updated_at":"2026-04-20T09:30:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19888214,"change_date":"2026-04-09 21:54:00","inspection_id":"87529672","insp_unit_id":"212619460","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"64","insp_unit_license":"79122A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1HTEUTAL4SS162308","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-12T09:25:25.000000Z","updated_at":"2026-04-19T09:04:01.000000Z"}]},{"id":11552415,"change_date":"2026-04-02 21:38:00","inspection_id":"87475368","dot_number":"272172","report_state":"NY","report_number":"M608000277","insp_date":"2026-04-02 00:00:00","insp_start_time":"0924","insp_end_time":"0952","registration_date":null,"region":"ED","ci_status_code":"C","location":"80018","location_desc":"WASSAIC NY","county_code_state":"NY","county_code":"027","insp_level_id":"2","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":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-04-02 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3105727","transaction_code":"A","transaction_date":"2026-04-02 00:00:00","upload_date":"2026-04-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00272172","upload_search_indicator":null,"census_search_date":"2026-04-02 21:38:00","snet_input_date":"2026-04-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-02 21:38:00","insp_carrier_name":"JOHN DEGRAND & SON INC","insp_carrier_street":"430 ISLAND LANE","insp_carrier_city":"WEST HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06516","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-05T09:56:37.000000Z","updated_at":"2026-04-13T09:30:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19795144,"change_date":"2026-04-02 21:38:00","inspection_id":"87475368","insp_unit_id":"212499155","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"66230A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3HAEETAN0LL887542","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-05T09:52:13.000000Z","updated_at":"2026-04-13T09:03:42.000000Z"}]},{"id":11574908,"change_date":"2026-05-12 21:39:00","inspection_id":"87499028","dot_number":"272172","report_state":"NY","report_number":"D103002087","insp_date":"2026-04-01 00:00:00","insp_start_time":"0824","insp_end_time":"0913","registration_date":"2026-04-07 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"FULTONVILLE NY","county_code_state":"NY","county_code":"057","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":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-04-06 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3119824","transaction_code":"C","transaction_date":"2026-04-06 00:00:00","upload_date":"2026-05-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00272172","upload_search_indicator":null,"census_search_date":"2026-04-06 21:37:00","snet_input_date":"2026-04-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-06 21:37:00","insp_carrier_name":"JOHN DEGRAND & SON INC","insp_carrier_street":"430 ISLAND LANE","insp_carrier_city":"WEST HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06516","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-09T09:49:08.000000Z","updated_at":"2026-05-23T09:30:03.000000Z","inspection_violations":[{"id":19581601,"change_date":"2026-05-12 21:39:00","inspection_id":"87499028","insp_violation_id":"274193329","seq_no":"2","part_no":"391","part_no_section":"15A-LNCDLNSRW","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":"2026-04-09T10:16:24.000000Z","updated_at":"2026-05-23T09:44:09.000000Z","normalized_code":"39115ALNCDLNSRW"},{"id":19581600,"change_date":"2026-05-12 21:39:00","inspection_id":"87499028","insp_violation_id":"274193328","seq_no":"1","part_no":"393","part_no_section":"45B2-BHTD","insp_viol_unit":"1","insp_unit_id":"213499776","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-04-09T10:16:24.000000Z","updated_at":"2026-05-23T09:44:09.000000Z","normalized_code":"39345B2BHTD"}],"inspection_per_units":[{"id":19846900,"change_date":"2026-05-12 21:39:00","inspection_id":"87499028","insp_unit_id":"213499776","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"54","insp_unit_license":"66898A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3HAEUTAL5LL855381","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-10T09:22:17.000000Z","updated_at":"2026-05-23T09:02:11.000000Z"}]},{"id":10145175,"change_date":"2025-11-07 21:40:00","inspection_id":"86263111","dot_number":"272172","report_state":"VT","report_number":"51A0001461","insp_date":"2025-11-04 00:00:00","insp_start_time":"0900","insp_end_time":"0942","registration_date":null,"region":"ET","ci_status_code":"C","location":"1307NB","location_desc":"GUILFORD TRUCK CHECK AREA","county_code_state":"VT","county_code":"025","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"423722","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":"2025-11-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"221794","transaction_code":"A","transaction_date":"2025-11-04 00:00:00","upload_date":"2025-11-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00272172","upload_search_indicator":null,"census_search_date":"2025-11-07 21:40:00","snet_input_date":"2025-11-04 00:00:00","source_office":"1VTS001","mcmis_add_date":"2025-11-07 21:40:00","insp_carrier_name":"JOHN DEGRAND & SON INC","insp_carrier_street":"430 ISLAND LANE","insp_carrier_city":"WEST HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06516","insp_colonia":null,"docket_number":"15100","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-10T10:31:39.000000Z","updated_at":"2025-11-11T10:30:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16889835,"change_date":"2025-11-07 21:40:00","inspection_id":"86263111","insp_unit_id":"209903117","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"65","insp_unit_license":"79123A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3HAEUTAN3SL161854","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-10T10:02:11.000000Z","updated_at":"2025-11-11T10:00:54.000000Z"}]},{"id":9717612,"change_date":"2025-09-18 21:42:00","inspection_id":"85813319","dot_number":"272172","report_state":"VT","report_number":"51A0001419","insp_date":"2025-09-18 00:00:00","insp_start_time":"0807","insp_end_time":"0828","registration_date":null,"region":"ET","ci_status_code":"C","location":"1307NB","location_desc":"GUILFORD TRUCK CHECK AREA","county_code_state":"VT","county_code":"025","insp_level_id":"1","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":"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-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"14706","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":"220575","transaction_code":"A","transaction_date":"2025-09-18 00:00:00","upload_date":"2025-09-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00272172","upload_search_indicator":null,"census_search_date":"2025-09-18 21:42:00","snet_input_date":"2025-09-18 00:00:00","source_office":"1VTS001","mcmis_add_date":"2025-09-18 21:42:00","insp_carrier_name":"JOHN DEGRAND & SON INC","insp_carrier_street":"430 ISLAND LANE","insp_carrier_city":"WEST HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06516","insp_colonia":null,"docket_number":"15100","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-23T10:02:22.000000Z","updated_at":"2025-09-23T10:02:22.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16090904,"change_date":"2025-09-18 21:42:00","inspection_id":"85813319","insp_unit_id":"209024663","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"74285A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FD0X5HT8NEF12327","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-21T09:45:55.000000Z","updated_at":"2025-09-22T09:46:10.000000Z"}]},{"id":9726998,"change_date":"2025-09-19 21:38:00","inspection_id":"85823110","dot_number":"272172","report_state":"NH","report_number":"1292002654","insp_date":"2025-08-01 00:00:00","insp_start_time":"1119","insp_end_time":"1148","registration_date":"2025-09-19 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"NH","county_code_state":"NH","county_code":"003","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":"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":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-09-19 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2299648","transaction_code":"A","transaction_date":"2025-09-19 00:00:00","upload_date":"2025-09-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00272172","upload_search_indicator":null,"census_search_date":"2025-09-19 21:38:00","snet_input_date":"2025-08-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-19 21:38:00","insp_carrier_name":"JOHN DEGRAND & SON INC","insp_carrier_street":"430 ISLAND LANE","insp_carrier_city":"WEST HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06516","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-23T10:02:40.000000Z","updated_at":"2025-09-23T10:02:40.000000Z","inspection_violations":[{"id":15971029,"change_date":"2025-09-19 21:38:00","inspection_id":"85823110","insp_violation_id":"268803084","seq_no":"1","part_no":"392","part_no_section":"16B-DPASS","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-09-22T10:18:20.000000Z","updated_at":"2025-09-23T10:15:59.000000Z","normalized_code":"39216BDPASS"},{"id":15971030,"change_date":"2025-09-19 21:38:00","inspection_id":"85823110","insp_violation_id":"268803085","seq_no":"2","part_no":"392","part_no_section":"16B-DPASS","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-09-22T10:18:20.000000Z","updated_at":"2025-09-23T10:15:59.000000Z","normalized_code":"39216BDPASS"}],"inspection_per_units":[{"id":16107819,"change_date":"2025-09-19 21:38:00","inspection_id":"85823110","insp_unit_id":"209043153","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CUSTOM SCO","insp_unit_company":null,"insp_unit_license":"80025A","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"3HAEUTANXSL649165","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-22T09:47:00.000000Z","updated_at":"2025-09-23T09:45:42.000000Z"}]},{"id":9187097,"change_date":"2025-07-18 21:39:00","inspection_id":"85255609","dot_number":"272172","report_state":"ME","report_number":"3969004862","insp_date":"2025-07-17 00:00:00","insp_start_time":"0927","insp_end_time":"0940","registration_date":null,"region":"ET","ci_status_code":"C","location":"000531","location_desc":"YORK - SCALES","county_code_state":"ME","county_code":"031","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":"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-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"399928","transaction_code":"A","transaction_date":"2025-07-17 00:00:00","upload_date":"2025-07-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00272172","upload_search_indicator":null,"census_search_date":"2025-07-18 21:39:00","snet_input_date":"2025-07-17 00:00:00","source_office":"1MES001","mcmis_add_date":"2025-07-18 21:39:00","insp_carrier_name":"JOHN DEGRAND & SON INC","insp_carrier_street":"430 ISLAND LANE","insp_carrier_city":"WEST HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06516","insp_colonia":null,"docket_number":"15100","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-21T10:43:33.000000Z","updated_at":"2025-07-22T10:45:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15098054,"change_date":"2025-07-18 21:39:00","inspection_id":"85255609","insp_unit_id":"207949468","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"52","insp_unit_license":"66230A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3HAEETAN0LL887542","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-21T09:46:35.000000Z","updated_at":"2025-07-22T09:45:43.000000Z"}]},{"id":8682970,"change_date":"2025-05-20 21:40:00","inspection_id":"84722811","dot_number":"272172","report_state":"CT","report_number":"3067A00078","insp_date":"2025-05-20 00:00:00","insp_start_time":"0638","insp_end_time":"0728","registration_date":null,"region":"ET","ci_status_code":"C","location":"083","location_desc":"MIDDLETOWN SCALE","county_code_state":"CT","county_code":"009","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"JOHN DEGRAND & SON","shipping_paper_number":"1001527081","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-05-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"740743","transaction_code":"A","transaction_date":"2025-05-20 00:00:00","upload_date":"2025-05-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00272172","upload_search_indicator":null,"census_search_date":"2025-05-20 21:40:00","snet_input_date":"2025-05-20 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-05-20 21:40:00","insp_carrier_name":"JOHN DEGRAND & SON INC","insp_carrier_street":"430 ISLAND LANE","insp_carrier_city":"WEST HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06516","insp_colonia":null,"docket_number":"15100","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-23T10:03:14.000000Z","updated_at":"2025-05-24T10:03:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14185425,"change_date":"2025-05-20 21:40:00","inspection_id":"84722811","insp_unit_id":"206954664","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"64","insp_unit_license":"79122A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1HTEUTAL4SS162308","insp_unit_decal":"Y","insp_unit_decal_number":"35261595","created_at":"2025-05-23T09:48:35.000000Z","updated_at":"2025-05-24T09:48:27.000000Z"}]},{"id":8636319,"change_date":"2025-05-15 21:42:00","inspection_id":"84673606","dot_number":"272172","report_state":"CT","report_number":"3132005569","insp_date":"2025-05-15 00:00:00","insp_start_time":"1426","insp_end_time":"1435","registration_date":null,"region":"ET","ci_status_code":"C","location":"145S","location_desc":"UNION SCALE","county_code_state":"CT","county_code":"013","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":"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-05-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"740370","transaction_code":"A","transaction_date":"2025-05-15 00:00:00","upload_date":"2025-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00272172","upload_search_indicator":null,"census_search_date":"2025-05-15 21:42:00","snet_input_date":"2025-05-15 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-05-15 21:42:00","insp_carrier_name":"JOHN DEGRAND & SON INC","insp_carrier_street":"430 ISLAND LANE","insp_carrier_city":"WEST HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06516","insp_colonia":null,"docket_number":"15100","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-18T10:03:27.000000Z","updated_at":"2025-05-19T10:03:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14102554,"change_date":"2025-05-15 21:42:00","inspection_id":"84673606","insp_unit_id":"206865318","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"66898A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3HAEUTAL5LL855381","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-18T09:49:41.000000Z","updated_at":"2025-05-19T09:48:20.000000Z"}]},{"id":8386666,"change_date":"2025-04-17 21:41:00","inspection_id":"84410746","dot_number":"272172","report_state":"CT","report_number":"3029003002","insp_date":"2025-04-16 00:00:00","insp_start_time":"1259","insp_end_time":"1306","registration_date":"2025-04-17 00:00:00","region":"ET","ci_status_code":"C","location":"106","location_desc":"OLD SAYBROOK","county_code_state":"CT","county_code":"007","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"JOHN DEGRAND & SON 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":"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-04-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"737647","transaction_code":"C","transaction_date":"2025-04-16 00:00:00","upload_date":"2025-04-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00272172","upload_search_indicator":null,"census_search_date":"2025-04-16 21:40:00","snet_input_date":"2025-04-16 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-04-16 21:40:00","insp_carrier_name":"JOHN DEGRAND & SON INC","insp_carrier_street":"430 ISLAND LANE","insp_carrier_city":"WEST HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06516","insp_colonia":null,"docket_number":"15100","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-19T10:18:35.000000Z","updated_at":"2025-04-21T10:20:39.000000Z","inspection_violations":[{"id":13245097,"change_date":"2025-04-17 21:41:00","inspection_id":"84410746","insp_violation_id":"265669103","seq_no":"1","part_no":"392","part_no_section":"16-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-20T10:49:46.000000Z","updated_at":"2025-04-20T10:53:34.000000Z","normalized_code":"39216D"},{"id":13245098,"change_date":"2025-04-17 21:41:00","inspection_id":"84410746","insp_violation_id":"265669104","seq_no":"2","part_no":"393","part_no_section":"93A-SBA","insp_viol_unit":"1","insp_unit_id":"206353147","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-20T10:49:46.000000Z","updated_at":"2025-04-20T10:53:34.000000Z","normalized_code":"39393ASBA"}],"inspection_per_units":[{"id":13631644,"change_date":"2025-04-17 21:41:00","inspection_id":"84410746","insp_unit_id":"206353147","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"55","insp_unit_license":"72147A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3HAMMMML3FL682834","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-20T10:06:17.000000Z","updated_at":"2025-04-21T09:49:18.000000Z"}]},{"id":7500792,"change_date":"2024-12-26 21:37:00","inspection_id":"83479668","dot_number":"272172","report_state":"ME","report_number":"9438000464","insp_date":"2024-12-23 00:00:00","insp_start_time":"1150","insp_end_time":"1204","registration_date":null,"region":"ET","ci_status_code":"C","location":"000440","location_desc":"SIDNEY","county_code_state":"ME","county_code":"011","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"JOHN DEGRAND AND SON INC","shipping_paper_number":"241220-5","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":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-26 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"390454","transaction_code":"A","transaction_date":"2024-12-23 00:00:00","upload_date":"2024-12-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00272172","upload_search_indicator":null,"census_search_date":"2024-12-26 21:37:00","snet_input_date":"2024-12-23 00:00:00","source_office":"1MES001","mcmis_add_date":"2024-12-26 21:37:00","insp_carrier_name":"JOHN DEGRAND & SON INC","insp_carrier_street":"430 ISLAND LANE","insp_carrier_city":"WEST HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06516","insp_colonia":null,"docket_number":"15100","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:52:38.000000Z","updated_at":"2025-03-17T20:52:38.000000Z","inspection_violations":[{"id":11724085,"change_date":"2024-12-26 21:37:00","inspection_id":"83479668","insp_violation_id":"263657885","seq_no":"1","part_no":"395","part_no_section":"8F12-HOSM","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:08.000000Z","updated_at":"2025-03-17T22:03:08.000000Z","normalized_code":"3958F12HOSM"}],"inspection_per_units":[{"id":12100484,"change_date":"2024-12-26 21:37:00","inspection_id":"83479668","insp_unit_id":"204556649","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"-","insp_unit_license":"66230A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3HAEETAN0LL887542","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:37.000000Z","updated_at":"2025-03-17T23:48:37.000000Z"}]},{"id":7366868,"change_date":"2024-12-09 21:40:00","inspection_id":"83338998","dot_number":"272172","report_state":"NY","report_number":"M607500054","insp_date":"2024-12-02 00:00:00","insp_start_time":"0857","insp_end_time":"0935","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"BRONX NY","county_code_state":"NY","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":"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-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1135223","transaction_code":"A","transaction_date":"2024-12-09 00:00:00","upload_date":"2024-12-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00272172","upload_search_indicator":null,"census_search_date":"2024-12-09 21:40:00","snet_input_date":"2024-12-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-12-09 21:40:00","insp_carrier_name":"JOHN DEGRAND & SON INC","insp_carrier_street":"430 ISLAND LANE","insp_carrier_city":"WEST HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06516","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:49:47.000000Z","updated_at":"2025-03-17T20:49:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11884091,"change_date":"2024-12-09 21:40:00","inspection_id":"83338998","insp_unit_id":"204259981","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"51","insp_unit_license":"56252A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1HTMKAAN4FH710947","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:13.000000Z","updated_at":"2025-03-17T23:46:13.000000Z"}]},{"id":7269743,"change_date":"2024-11-24 21:33:00","inspection_id":"83236510","dot_number":"272172","report_state":"VT","report_number":"2149004222","insp_date":"2024-11-20 00:00:00","insp_start_time":"0935","insp_end_time":"0951","registration_date":null,"region":"ET","ci_status_code":"C","location":"0504","location_desc":"BRIGHTON","county_code_state":"VT","county_code":"009","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"JOHN DEGRAND & SONS INC","shipping_paper_number":"421724","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-11-24 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"45800","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":"212030","transaction_code":"A","transaction_date":"2024-11-20 00:00:00","upload_date":"2024-11-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00272172","upload_search_indicator":null,"census_search_date":"2024-11-24 21:33:00","snet_input_date":"2024-11-20 00:00:00","source_office":"1VTS001","mcmis_add_date":"2024-11-24 21:33:00","insp_carrier_name":"JOHN DEGRAND & SON INC","insp_carrier_street":"430 ISLAND LANE","insp_carrier_city":"WEST HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06516","insp_colonia":null,"docket_number":"15100","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:47:43.000000Z","updated_at":"2025-03-17T20:47:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11726200,"change_date":"2024-11-24 21:33:00","inspection_id":"83236510","insp_unit_id":"204031679","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"33","insp_unit_license":"77625A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1HSHWAHN15J005093","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:32.000000Z","updated_at":"2025-03-17T23:44:32.000000Z"},{"id":11726201,"change_date":"2024-11-24 21:33:00","inspection_id":"83236510","insp_unit_id":"204031680","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CAM S","insp_unit_company":"NA","insp_unit_license":"V95406","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"5JPBU2922BP027259","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:32.000000Z","updated_at":"2025-03-17T23:44:32.000000Z"}]},{"id":7289190,"change_date":"2024-11-27 21:39:00","inspection_id":"83257030","dot_number":"272172","report_state":"RI","report_number":"0239000429","insp_date":"2024-11-20 00:00:00","insp_start_time":"1333","insp_end_time":"1410","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"WARWICK RI","county_code_state":"RI","county_code":"003","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":"U","pen_cen_match":"I","final_status_date":"2024-11-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1097362","transaction_code":"A","transaction_date":"2024-11-27 00:00:00","upload_date":"2024-11-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00272172","upload_search_indicator":null,"census_search_date":"2024-11-27 21:39:00","snet_input_date":"2024-11-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-27 21:39:00","insp_carrier_name":"JOHN DEGRAND & SON INC","insp_carrier_street":"430 ISLAND LANE","insp_carrier_city":"WEST HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06516","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:48:09.000000Z","updated_at":"2025-03-17T20:48:09.000000Z","inspection_violations":[{"id":11397462,"change_date":"2024-11-27 21:39:00","inspection_id":"83257030","insp_violation_id":"263116340","seq_no":"1","part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:20.000000Z","updated_at":"2025-03-17T22:01:20.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":11757810,"change_date":"2024-11-27 21:39:00","inspection_id":"83257030","insp_unit_id":"204076818","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"59","insp_unit_license":"77031A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3HAMMMML9JL633310","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:51.000000Z","updated_at":"2025-03-17T23:44:51.000000Z"}]},{"id":6567508,"change_date":"2024-08-29 21:41:00","inspection_id":"82490467","dot_number":"272172","report_state":"CT","report_number":"3063006682","insp_date":"2024-08-27 00:00:00","insp_start_time":"0630","insp_end_time":"0729","registration_date":"2024-08-29 00:00:00","region":"ET","ci_status_code":"C","location":"083S","location_desc":"MIDDLETOWN SCALE","county_code_state":"CT","county_code":"007","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"RG","shipping_paper_number":"240826-8","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-08-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"716525","transaction_code":"C","transaction_date":"2024-08-27 00:00:00","upload_date":"2024-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00272172","upload_search_indicator":null,"census_search_date":"2024-08-27 21:41:00","snet_input_date":"2024-08-27 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-08-27 21:41:00","insp_carrier_name":"JOHN DEGRAND & SON INC","insp_carrier_street":"430 ISLAND LANE","insp_carrier_city":"WEST HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06516","insp_colonia":null,"docket_number":"15100","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:33:10.000000Z","updated_at":"2025-03-17T20:33:10.000000Z","inspection_violations":[{"id":10206597,"change_date":"2024-08-29 21:41:00","inspection_id":"82490467","insp_violation_id":"261477571","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"202640042","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:25.000000Z","updated_at":"2025-03-17T21:55:25.000000Z","normalized_code":"39395A"},{"id":10206598,"change_date":"2024-08-29 21:41:00","inspection_id":"82490467","insp_violation_id":"261477572","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202640042","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:25.000000Z","updated_at":"2025-03-17T21:55:25.000000Z","normalized_code":"3939A"},{"id":10206599,"change_date":"2024-08-29 21:41:00","inspection_id":"82490467","insp_violation_id":"261477573","seq_no":"3","part_no":"393","part_no_section":"203(b)","insp_viol_unit":"1","insp_unit_id":"202640042","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:25.000000Z","updated_at":"2025-03-17T21:55:25.000000Z","normalized_code":"393203B"}],"inspection_per_units":[{"id":10587971,"change_date":"2024-08-29 21:41:00","inspection_id":"82490467","insp_unit_id":"202640042","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"59","insp_unit_license":"77031A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3HAMMMML9JL633310","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:40.000000Z","updated_at":"2025-03-17T23:32:40.000000Z"}]},{"id":6355620,"change_date":"2024-07-31 21:42:00","inspection_id":"82264355","dot_number":"272172","report_state":"NY","report_number":"SPL0165097","insp_date":"2024-07-30 00:00:00","insp_start_time":"0806","insp_end_time":"0822","registration_date":null,"region":"ET","ci_status_code":"C","location":"00096F","location_desc":"YAPHANK (EB)","county_code_state":"NY","county_code":"103","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-31 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"22000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2941527","transaction_code":"A","transaction_date":"2024-07-31 00:00:00","upload_date":"2024-07-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00272172","upload_search_indicator":"M","census_search_date":"2024-07-31 21:42:00","snet_input_date":"2024-07-31 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-07-31 21:42:00","insp_carrier_name":"JOHN DEGRAND & SON INC","insp_carrier_street":"430 ISLAND LANE","insp_carrier_city":"WEST HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06516","insp_colonia":null,"docket_number":"15100","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:28:43.000000Z","updated_at":"2025-03-17T20:28:43.000000Z","inspection_violations":[{"id":9868102,"change_date":"2024-07-31 21:42:00","inspection_id":"82264355","insp_violation_id":"260938656","seq_no":"1","part_no":"390","part_no_section":"21(b)","insp_viol_unit":"1","insp_unit_id":"202164039","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:44.000000Z","updated_at":"2025-03-17T21:53:44.000000Z","normalized_code":"39021B"},{"id":9868103,"change_date":"2024-07-31 21:42:00","inspection_id":"82264355","insp_violation_id":"260938657","seq_no":"2","part_no":"395","part_no_section":"30(b)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:44.000000Z","updated_at":"2025-03-17T21:53:44.000000Z","normalized_code":"39530B1"}],"inspection_per_units":[{"id":10242021,"change_date":"2024-07-31 21:42:00","inspection_id":"82264355","insp_unit_id":"202164039","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"61","insp_unit_license":"BM71408","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FDFF6LN6NDA26570","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:06.000000Z","updated_at":"2025-03-17T23:29:06.000000Z"}]},{"id":6318741,"change_date":"2024-07-26 21:39:00","inspection_id":"82224867","dot_number":"272172","report_state":"ME","report_number":"1000014879","insp_date":"2024-07-25 00:00:00","insp_start_time":"0834","insp_end_time":"0854","registration_date":null,"region":"ET","ci_status_code":"C","location":"000018","location_desc":"OLD TOWN - SCALES SB","county_code_state":"ME","county_code":"019","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"VERIZON","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":null,"final_status_date":"2024-07-26 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"383464","transaction_code":"A","transaction_date":"2024-07-25 00:00:00","upload_date":"2024-07-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00272172","upload_search_indicator":null,"census_search_date":"2024-07-26 21:39:00","snet_input_date":"2024-07-25 00:00:00","source_office":"1MES001","mcmis_add_date":"2024-07-26 21:39:00","insp_carrier_name":"JOHN DEGRAND & SON INC","insp_carrier_street":"430 ISLAND LANE","insp_carrier_city":"WEST HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06516","insp_colonia":null,"docket_number":"15100","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:27:53.000000Z","updated_at":"2025-03-17T20:27:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10181421,"change_date":"2024-07-26 21:39:00","inspection_id":"82224867","insp_unit_id":"202090228","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"74285A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FD0X5HT8NEF12327","insp_unit_decal":"Y","insp_unit_decal_number":"34384753","created_at":"2025-03-17T23:28:28.000000Z","updated_at":"2025-03-17T23:28:28.000000Z"}]},{"id":5642416,"change_date":"2024-05-16 21:41:00","inspection_id":"81494198","dot_number":"272172","report_state":"NH","report_number":"1230001282","insp_date":"2024-05-01 00:00:00","insp_start_time":"0836","insp_end_time":"0940","registration_date":"2024-05-15 00:00:00","region":"ET","ci_status_code":"C","location":"219","location_desc":"TWIN MOUNTAIN","county_code_state":"NH","county_code":"007","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"417516","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":"2024-05-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"22000","viol_total":"7","oos_total":"2","driver_viol_total":"7","driver_oos_total":"2","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"274661","transaction_code":"C","transaction_date":"2024-05-01 00:00:00","upload_date":"2024-05-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00272172","upload_search_indicator":null,"census_search_date":"2024-05-01 21:42:00","snet_input_date":"2024-05-01 00:00:00","source_office":"1NHS001","mcmis_add_date":"2024-05-01 21:42:00","insp_carrier_name":"JOHN DEGRAND & SON INC","insp_carrier_street":"430 ISLAND LANE","insp_carrier_city":"WEST HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06516","insp_colonia":null,"docket_number":"15100","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:14:40.000000Z","updated_at":"2025-03-17T20:14:40.000000Z","inspection_violations":[{"id":8726617,"change_date":"2024-05-16 21:41:00","inspection_id":"81494198","insp_violation_id":"259542909","seq_no":"1","part_no":"391","part_no_section":"41(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:14.000000Z","updated_at":"2025-03-17T21:48:14.000000Z","normalized_code":"39141A1"},{"id":8726618,"change_date":"2024-05-16 21:41:00","inspection_id":"81494198","insp_violation_id":"259542910","seq_no":"2","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:14.000000Z","updated_at":"2025-03-17T21:48:14.000000Z","normalized_code":"3958A1"},{"id":8726619,"change_date":"2024-05-16 21:41:00","inspection_id":"81494198","insp_violation_id":"259542911","seq_no":"3","part_no":"392","part_no_section":"4(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"9","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"2024-052900","created_at":"2025-03-17T21:48:14.000000Z","updated_at":"2025-03-17T21:48:14.000000Z","normalized_code":"3924A"},{"id":8726620,"change_date":"2024-05-16 21:41:00","inspection_id":"81494198","insp_violation_id":"259542912","seq_no":"4","part_no":"395","part_no_section":"22(h)(1)","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:48:14.000000Z","updated_at":"2025-03-17T21:48:14.000000Z","normalized_code":"39522H1"},{"id":8726621,"change_date":"2024-05-16 21:41:00","inspection_id":"81494198","insp_violation_id":"259542913","seq_no":"5","part_no":"395","part_no_section":"22(h)(2)","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:48:14.000000Z","updated_at":"2025-03-17T21:48:14.000000Z","normalized_code":"39522H2"},{"id":8726622,"change_date":"2024-05-16 21:41:00","inspection_id":"81494198","insp_violation_id":"259542914","seq_no":"6","part_no":"395","part_no_section":"22(h)(3)","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:48:14.000000Z","updated_at":"2025-03-17T21:48:14.000000Z","normalized_code":"39522H3"},{"id":8726623,"change_date":"2024-05-16 21:41:00","inspection_id":"81494198","insp_violation_id":"259542915","seq_no":"7","part_no":"395","part_no_section":"22(h)(4)","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:48:14.000000Z","updated_at":"2025-03-17T21:48:14.000000Z","normalized_code":"39522H4"}],"inspection_per_units":[{"id":9088549,"change_date":"2024-05-16 21:41:00","inspection_id":"81494198","insp_unit_id":"200926499","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"61","insp_unit_license":"BM71408","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FDFF6LN6NDA26570","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:33.000000Z","updated_at":"2025-03-17T23:17:33.000000Z"}]},{"id":5570482,"change_date":"2024-05-06 21:42:00","inspection_id":"81415776","dot_number":"272172","report_state":"CT","report_number":"3064001163","insp_date":"2024-04-23 00:00:00","insp_start_time":"1444","insp_end_time":"1507","registration_date":"2024-05-06 00:00:00","region":"ET","ci_status_code":"C","location":"164","location_desc":"WINDSOR","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"JOHN DEGRAND & SON 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":"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-04-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"705751","transaction_code":"C","transaction_date":"2024-04-23 00:00:00","upload_date":"2024-05-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00272172","upload_search_indicator":null,"census_search_date":"2024-04-23 21:40:00","snet_input_date":"2024-04-23 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-04-23 21:40:00","insp_carrier_name":"JOHN DEGRAND & SON INC","insp_carrier_street":"430 ISLAND LANE","insp_carrier_city":"WEST HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06516","insp_colonia":null,"docket_number":"15100","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:08.000000Z","updated_at":"2025-03-17T20:13:08.000000Z","inspection_violations":[{"id":8608882,"change_date":"2024-05-06 21:42:00","inspection_id":"81415776","insp_violation_id":"259319155","seq_no":"1","part_no":"392","part_no_section":"82(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V127458-4","created_at":"2025-03-17T21:47:42.000000Z","updated_at":"2025-03-17T21:47:42.000000Z","normalized_code":"39282A1"}],"inspection_per_units":[{"id":8972892,"change_date":"2024-05-06 21:42:00","inspection_id":"81415776","insp_unit_id":"200729680","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"77032A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3HAMMMML3HL481728","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:29.000000Z","updated_at":"2025-03-17T23:16:29.000000Z"}]},{"id":4929605,"change_date":"2024-01-30 21:41:00","inspection_id":"80716105","dot_number":"272172","report_state":"NY","report_number":"SPWB010290","insp_date":"2024-01-29 00:00:00","insp_start_time":"1130","insp_end_time":"1151","registration_date":null,"region":"ET","ci_status_code":"C","location":"70188","location_desc":"SR 3 COLTON","county_code_state":"NY","county_code":"089","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"JOHN DEGRAND AND SON INC","shipping_paper_number":"414536","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-01-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2902691","transaction_code":"A","transaction_date":"2024-01-30 00:00:00","upload_date":"2024-01-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00272172","upload_search_indicator":"M","census_search_date":"2024-01-30 21:41:00","snet_input_date":"2024-01-30 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-01-30 21:41:00","insp_carrier_name":"JOHN DEGRAND & SON INC","insp_carrier_street":"430 ISLAND LANE","insp_carrier_city":"WEST HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06516","insp_colonia":null,"docket_number":"15100","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:00:27.000000Z","updated_at":"2025-03-17T20:00:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7932741,"change_date":"2024-01-30 21:41:00","inspection_id":"80716105","insp_unit_id":"199167888","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"53","insp_unit_license":"66382A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1HTEUTAN1LH887560","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:54.000000Z","updated_at":"2025-03-17T23:06:54.000000Z"}]},{"id":4864225,"change_date":"2024-01-30 21:41:00","inspection_id":"80644720","dot_number":"272172","report_state":"ME","report_number":"9270002222","insp_date":"2024-01-18 00:00:00","insp_start_time":"0822","insp_end_time":"0855","registration_date":null,"region":"ET","ci_status_code":"C","location":"000531","location_desc":"YORK - SCALES","county_code_state":"ME","county_code":"031","insp_level_id":"2","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":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-19 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"17950","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":"374397","transaction_code":"C","transaction_date":"2024-01-30 00:00:00","upload_date":"2024-01-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00272172","upload_search_indicator":"M","census_search_date":"2024-01-19 21:43:00","snet_input_date":"2024-01-18 00:00:00","source_office":"1MES001","mcmis_add_date":"2024-01-19 21:43:00","insp_carrier_name":"JOHN DEGRAND & SON INC","insp_carrier_street":"430 ISLAND LANE","insp_carrier_city":"WEST HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06516","insp_colonia":null,"docket_number":"15100","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:59:12.000000Z","updated_at":"2025-03-17T19:59:12.000000Z","inspection_violations":[{"id":7498328,"change_date":"2024-01-30 21:41:00","inspection_id":"80644720","insp_violation_id":"257553706","seq_no":"1","part_no":"393","part_no_section":"209(d)","insp_viol_unit":"1","insp_unit_id":"199165264","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:42:09.000000Z","updated_at":"2025-03-17T21:42:09.000000Z","normalized_code":"393209D"},{"id":7498329,"change_date":"2024-01-30 21:41:00","inspection_id":"80644720","insp_violation_id":"257553707","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"199165264","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:09.000000Z","updated_at":"2025-03-17T21:42:09.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":7826167,"change_date":"2024-01-30 21:41:00","inspection_id":"80644720","insp_unit_id":"199165264","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"34199A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FDAF5HR9AEA74889","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:56.000000Z","updated_at":"2025-03-17T23:05:56.000000Z"}]},{"id":4929855,"change_date":"2024-01-30 21:41:00","inspection_id":"80716374","dot_number":"272172","report_state":"VT","report_number":"51A0000365","insp_date":"2024-01-17 00:00:00","insp_start_time":"1410","insp_end_time":"1428","registration_date":null,"region":"ET","ci_status_code":"C","location":"1408SB","location_desc":"WHITE RIVER SB RA","county_code_state":"VT","county_code":"027","insp_level_id":"2","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":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"202056","transaction_code":"A","transaction_date":"2024-01-17 00:00:00","upload_date":"2024-01-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00272172","upload_search_indicator":null,"census_search_date":"2024-01-30 21:41:00","snet_input_date":"2024-01-17 00:00:00","source_office":"1VTS001","mcmis_add_date":"2024-01-30 21:41:00","insp_carrier_name":"JOHN DEGRAND & SON INC","insp_carrier_street":"430 ISLAND LANE","insp_carrier_city":"WEST HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06516","insp_colonia":null,"docket_number":"15100","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:00:27.000000Z","updated_at":"2025-03-17T20:00:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7933129,"change_date":"2024-01-30 21:41:00","inspection_id":"80716374","insp_unit_id":"199168324","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"54","insp_unit_license":"66898A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3HAEUTAL5LL855381","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:54.000000Z","updated_at":"2025-03-17T23:06:54.000000Z"}]},{"id":4823456,"change_date":"2024-01-12 21:43:00","inspection_id":"80600154","dot_number":"272172","report_state":"NY","report_number":"SPK0220603","insp_date":"2024-01-11 00:00:00","insp_start_time":"0247","insp_end_time":"1505","registration_date":null,"region":"ET","ci_status_code":"C","location":"80789A","location_desc":"SOUTHEAST (NB)","county_code_state":"NY","county_code":"079","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-12 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"2899152","transaction_code":"A","transaction_date":"2024-01-11 00:00:00","upload_date":"2024-01-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00272172","upload_search_indicator":null,"census_search_date":"2024-01-12 21:43:00","snet_input_date":"2024-01-12 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-01-12 21:43:00","insp_carrier_name":"JOHN DEGRAND AND SON INC","insp_carrier_street":"430 ISLAND LANE","insp_carrier_city":"WEST HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06516","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:58:24.000000Z","updated_at":"2025-03-17T19:58:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7760221,"change_date":"2024-01-12 21:43:00","inspection_id":"80600154","insp_unit_id":"198940652","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BA89995","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3HAEUTAL4PL209500","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:22.000000Z","updated_at":"2025-03-17T23:05:22.000000Z"}]},{"id":4586633,"change_date":"2023-12-08 21:40:00","inspection_id":"80341131","dot_number":"272172","report_state":"NY","report_number":"SPL0173575","insp_date":"2023-12-05 00:00:00","insp_start_time":"0726","insp_end_time":"0743","registration_date":null,"region":"ET","ci_status_code":"C","location":"00096F","location_desc":"YAPHANK (EB)","county_code_state":"NY","county_code":"103","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":"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-12-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2891474","transaction_code":"A","transaction_date":"2023-12-05 00:00:00","upload_date":"2023-12-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00272172","upload_search_indicator":null,"census_search_date":"2023-12-08 21:40:00","snet_input_date":"2023-12-07 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-12-08 21:40:00","insp_carrier_name":"JOHN DEGRAND AND SON INC","insp_carrier_street":"430 ISLAND LANE","insp_carrier_city":"WEST HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06516","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:53:46.000000Z","updated_at":"2025-03-17T19:53:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7376801,"change_date":"2023-12-08 21:40:00","inspection_id":"80341131","insp_unit_id":"198413060","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"53","insp_unit_license":"66382A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1HTEUTAN1LH887560","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:00.000000Z","updated_at":"2025-03-17T23:02:00.000000Z"}]},{"id":4532554,"change_date":"2023-12-01 21:41:00","inspection_id":"80281673","dot_number":"272172","report_state":"NY","report_number":"0L95000136","insp_date":"2023-11-30 00:00:00","insp_start_time":"1221","insp_end_time":"1237","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"WOODBURY NY","county_code_state":"NY","county_code":"059","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":"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":"2023-12-01 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"112542","transaction_code":"A","transaction_date":"2023-11-30 00:00:00","upload_date":"2023-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00272172","upload_search_indicator":null,"census_search_date":"2023-12-01 21:41:00","snet_input_date":"2023-11-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-12-01 21:41:00","insp_carrier_name":"JOHN DEGRAND & SON INC","insp_carrier_street":"430 ISLAND LANE","insp_carrier_city":"WEST HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06516","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:52:36.000000Z","updated_at":"2025-03-17T19:52:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7289755,"change_date":"2023-12-01 21:41:00","inspection_id":"80281673","insp_unit_id":"198294209","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"40465A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1HTMKAAN66G303275","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:13.000000Z","updated_at":"2025-03-17T23:01:13.000000Z"}]},{"id":4532800,"change_date":"2023-12-01 21:41:00","inspection_id":"80281944","dot_number":"272172","report_state":"NY","report_number":"D011900109","insp_date":"2023-11-30 00:00:00","insp_start_time":"1220","insp_end_time":"1237","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"HEMPSTEAD NY","county_code_state":"NY","county_code":"059","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CELTECH LYNBROOK","shipping_paper_number":"413478","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":"2023-12-01 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"112607","transaction_code":"A","transaction_date":"2023-11-30 00:00:00","upload_date":"2023-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00272172","upload_search_indicator":null,"census_search_date":"2023-12-01 21:41:00","snet_input_date":"2023-11-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-12-01 21:41:00","insp_carrier_name":"JOHN DEGRAND & SON INC","insp_carrier_street":"430 ISLAND LANE","insp_carrier_city":"WEST HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06516","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:52:36.000000Z","updated_at":"2025-03-17T19:52:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7290171,"change_date":"2023-12-01 21:41:00","inspection_id":"80281944","insp_unit_id":"198294676","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"55","insp_unit_license":"72147A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3HAMMMML3FL682834","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:15.000000Z","updated_at":"2025-03-17T23:01:15.000000Z"}]},{"id":4502087,"change_date":"2023-11-30 21:38:00","inspection_id":"80248101","dot_number":"272172","report_state":"CT","report_number":"3082000890","insp_date":"2023-11-28 00:00:00","insp_start_time":"0958","insp_end_time":"1015","registration_date":"2023-11-29 00:00:00","region":"ET","ci_status_code":"C","location":"084","location_desc":"MILFORD","county_code_state":"CT","county_code":"009","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"100108393","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"692917","transaction_code":"C","transaction_date":"2023-11-28 00:00:00","upload_date":"2023-11-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00272172","upload_search_indicator":null,"census_search_date":"2023-11-28 21:40:00","snet_input_date":"2023-11-28 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-11-28 21:40:00","insp_carrier_name":"JOHN DEGRAND & SON INC","insp_carrier_street":"430 ISLAND LANE","insp_carrier_city":"WEST HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06516","insp_colonia":null,"docket_number":"15100","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:52:10.000000Z","updated_at":"2025-03-17T19:52:10.000000Z","inspection_violations":[{"id":6968595,"change_date":"2023-11-30 21:38:00","inspection_id":"80248101","insp_violation_id":"256633646","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:39:38.000000Z","updated_at":"2025-03-17T21:39:38.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7240932,"change_date":"2023-11-30 21:38:00","inspection_id":"80248101","insp_unit_id":"198277141","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"51","insp_unit_license":"56252A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1HTMKAAN4FH710947","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:50.000000Z","updated_at":"2025-03-17T23:00:50.000000Z"}]},{"id":4460130,"change_date":"2023-11-20 21:40:00","inspection_id":"80202024","dot_number":"272172","report_state":"NY","report_number":"SPB0402142","insp_date":"2023-11-17 00:00:00","insp_start_time":"1029","insp_end_time":"1050","registration_date":null,"region":"ET","ci_status_code":"C","location":"70188","location_desc":"COLTON ROADSIDE","county_code_state":"NY","county_code":"089","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":"N","pen_cen_match":null,"final_status_date":"2023-11-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2888587","transaction_code":"A","transaction_date":"2023-11-17 00:00:00","upload_date":"2023-11-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00272172","upload_search_indicator":null,"census_search_date":"2023-11-20 21:40:00","snet_input_date":"2023-11-20 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-11-20 21:40:00","insp_carrier_name":"JOHN DEGRAND AND SON INC","insp_carrier_street":"PO BOX  16609","insp_carrier_city":"WEST HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06516","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:51:22.000000Z","updated_at":"2025-03-17T19:51:22.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7172674,"change_date":"2023-11-20 21:40:00","inspection_id":"80202024","insp_unit_id":"198137638","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"52","insp_unit_license":"66230A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3HAEETAN0LL887542","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:14.000000Z","updated_at":"2025-03-17T23:00:14.000000Z"}]},{"id":4437243,"change_date":"2023-11-16 21:42:00","inspection_id":"80176895","dot_number":"272172","report_state":"NY","report_number":"D012002150","insp_date":"2023-11-16 00:00:00","insp_start_time":"1204","insp_end_time":"1228","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"ROCKVILLE CENTRE NY","county_code_state":"NY","county_code":"059","insp_level_id":"1","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":"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":"2023-11-16 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"99576","transaction_code":"A","transaction_date":"2023-11-16 00:00:00","upload_date":"2023-11-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00272172","upload_search_indicator":null,"census_search_date":"2023-11-16 21:42:00","snet_input_date":"2023-11-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-11-16 21:42:00","insp_carrier_name":"JOHN DEGRAND & SON INC","insp_carrier_street":"430 ISLAND LANE","insp_carrier_city":"WEST HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06516","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:50:45.000000Z","updated_at":"2025-03-17T19:50:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7135801,"change_date":"2023-11-16 21:42:00","inspection_id":"80176895","insp_unit_id":"198085756","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"51","insp_unit_license":"56252A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1HTMKAAN4FH710947","insp_unit_decal":"Y","insp_unit_decal_number":"33400134","created_at":"2025-03-17T22:59:56.000000Z","updated_at":"2025-03-17T22:59:56.000000Z"}]},{"id":4198608,"change_date":"2023-10-19 21:40:00","inspection_id":"79913056","dot_number":"272172","report_state":"CT","report_number":"3091005085","insp_date":"2023-10-16 00:00:00","insp_start_time":"0741","insp_end_time":"0807","registration_date":"2023-10-16 00:00:00","region":"ET","ci_status_code":"C","location":"014","location_desc":"BRANFORD","county_code_state":"CT","county_code":"009","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"JOHN DEGRAND & SON 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":"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-10-16 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"689008","transaction_code":"C","transaction_date":"2023-10-16 00:00:00","upload_date":"2023-10-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00272172","upload_search_indicator":null,"census_search_date":"2023-10-16 21:42:00","snet_input_date":"2023-10-16 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-10-16 21:42:00","insp_carrier_name":"JOHN DEGRAND & SON INC","insp_carrier_street":"430 ISLAND LANE","insp_carrier_city":"WEST HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06516","insp_colonia":null,"docket_number":"15100","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:45:54.000000Z","updated_at":"2025-03-17T19:45:54.000000Z","inspection_violations":[{"id":6502109,"change_date":"2023-10-19 21:40:00","inspection_id":"79913056","insp_violation_id":"255923199","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:37:23.000000Z","updated_at":"2025-03-17T21:37:23.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":6752074,"change_date":"2023-10-19 21:40:00","inspection_id":"79913056","insp_unit_id":"197633525","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"7","insp_unit_license":"J67569","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1HTMKAAN95H100797","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:36.000000Z","updated_at":"2025-03-17T22:56:36.000000Z"}]},{"id":4077848,"change_date":"2023-10-03 21:40:00","inspection_id":"79779323","dot_number":"272172","report_state":"MA","report_number":"CU00002667","insp_date":"2023-09-27 00:00:00","insp_start_time":"1808","insp_end_time":"1835","registration_date":"2023-10-03 00:00:00","region":"ET","ci_status_code":"C","location":"173H","location_desc":"H-LEXINGTON","county_code_state":"MA","county_code":"017","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-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"474932","transaction_code":"C","transaction_date":"2023-09-28 00:00:00","upload_date":"2023-10-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00272172","upload_search_indicator":"M","census_search_date":"2023-09-28 21:40:00","snet_input_date":"2023-09-27 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-09-28 21:40:00","insp_carrier_name":"JOHN DEGRAND & SON INC","insp_carrier_street":"430 ISLAND LANE","insp_carrier_city":"WEST HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06516","insp_colonia":null,"docket_number":"151","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:43:15.000000Z","updated_at":"2025-03-17T19:43:15.000000Z","inspection_violations":[{"id":6312157,"change_date":"2023-10-03 21:40:00","inspection_id":"79779323","insp_violation_id":"255615490","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:36:26.000000Z","updated_at":"2025-03-17T21:36:26.000000Z","normalized_code":"3922"},{"id":6312158,"change_date":"2023-10-03 21:40:00","inspection_id":"79779323","insp_violation_id":"255615491","seq_no":"2","part_no":"396","part_no_section":"1","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:36:26.000000Z","updated_at":"2025-03-17T21:36:26.000000Z","normalized_code":"3961"}],"inspection_per_units":[{"id":6556444,"change_date":"2023-10-03 21:40:00","inspection_id":"79779323","insp_unit_id":"197361117","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"54","insp_unit_license":"66898A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3HAEUTAL5LL855381","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:02.000000Z","updated_at":"2025-03-17T22:55:02.000000Z"}]},{"id":4087565,"change_date":"2023-12-08 21:40:00","inspection_id":"79790180","dot_number":"272172","report_state":"NY","report_number":"1020002001","insp_date":"2023-09-26 00:00:00","insp_start_time":"0850","insp_end_time":"0943","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"ROCKVILLE CENTRE NY","county_code_state":"NY","county_code":"059","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2023-09-29 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"6","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"60586","transaction_code":"C","transaction_date":"2023-12-08 00:00:00","upload_date":"2023-12-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00272172","upload_search_indicator":null,"census_search_date":"2023-09-29 21:39:00","snet_input_date":"2023-09-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-09-29 21:39:00","insp_carrier_name":"JOHN DEGRAND & SON INC","insp_carrier_street":"430 ISLAND LANE","insp_carrier_city":"WEST HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06516","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:43:37.000000Z","updated_at":"2025-03-17T19:43:37.000000Z","inspection_violations":[{"id":6327264,"change_date":"2023-12-08 21:40:00","inspection_id":"79790180","insp_violation_id":"256780849","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"198409090","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"23H76GBP","created_at":"2025-03-17T21:36:32.000000Z","updated_at":"2025-03-17T21:36:32.000000Z","normalized_code":"39347E"},{"id":6327265,"change_date":"2023-12-08 21:40:00","inspection_id":"79790180","insp_violation_id":"256780850","seq_no":"2","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"1","insp_unit_id":"198409090","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"23H76GH3","created_at":"2025-03-17T21:36:32.000000Z","updated_at":"2025-03-17T21:36:32.000000Z","normalized_code":"3963A1BOS"},{"id":6327266,"change_date":"2023-12-08 21:40:00","inspection_id":"79790180","insp_violation_id":"256780851","seq_no":"3","part_no":"393","part_no_section":"201B-FR","insp_viol_unit":"1","insp_unit_id":"198409090","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"23H76G89","created_at":"2025-03-17T21:36:32.000000Z","updated_at":"2025-03-17T21:36:32.000000Z","normalized_code":"393201BFR"},{"id":6327267,"change_date":"2023-12-08 21:40:00","inspection_id":"79790180","insp_violation_id":"256780852","seq_no":"4","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"198409090","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"23H76G07","created_at":"2025-03-17T21:36:32.000000Z","updated_at":"2025-03-17T21:36:32.000000Z","normalized_code":"39021TB1MC"},{"id":6327268,"change_date":"2023-12-08 21:40:00","inspection_id":"79790180","insp_violation_id":"256780853","seq_no":"5","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"198409090","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"23H76GFS","created_at":"2025-03-17T21:36:32.000000Z","updated_at":"2025-03-17T21:36:32.000000Z","normalized_code":"3939ALHLI"},{"id":6327269,"change_date":"2023-12-08 21:40:00","inspection_id":"79790180","insp_violation_id":"256780854","seq_no":"6","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"1","insp_unit_id":"198409090","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"23H76GD8","created_at":"2025-03-17T21:36:32.000000Z","updated_at":"2025-03-17T21:36:32.000000Z","normalized_code":"39353BB"}],"inspection_per_units":[{"id":6571939,"change_date":"2023-12-08 21:40:00","inspection_id":"79790180","insp_unit_id":"198409090","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"56","insp_unit_license":"BA89995","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3HAEUTAL4PL209500","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:09.000000Z","updated_at":"2025-03-17T22:55:09.000000Z"}]},{"id":3817892,"change_date":"2023-08-24 21:40:00","inspection_id":"79489817","dot_number":"272172","report_state":"CT","report_number":"1094000077","insp_date":"2023-08-24 00:00:00","insp_start_time":"1135","insp_end_time":"1234","registration_date":null,"region":"ET","ci_status_code":"C","location":"145S","location_desc":"UNION SCALE","county_code_state":"CT","county_code":"013","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"JOHN DEGRAND & SIN","shipping_paper_number":"410618","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-08-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","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":"684475","transaction_code":"A","transaction_date":"2023-08-24 00:00:00","upload_date":"2023-08-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00272172","upload_search_indicator":null,"census_search_date":"2023-08-24 21:40:00","snet_input_date":"2023-08-24 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-08-24 21:40:00","insp_carrier_name":"JOHN DEGRAND & SON INC","insp_carrier_street":"430 ISLAND LANE","insp_carrier_city":"WEST HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06516","insp_colonia":null,"docket_number":"15100","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:06.000000Z","updated_at":"2025-03-17T19:38:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6138646,"change_date":"2023-08-24 21:40:00","inspection_id":"79489817","insp_unit_id":"196698950","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"3","insp_unit_license":"59998A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1HTWNAATX9J180088","insp_unit_decal":"Y","insp_unit_decal_number":"33111227","created_at":"2025-03-17T22:51:34.000000Z","updated_at":"2025-03-17T22:51:34.000000Z"}]},{"id":3626827,"change_date":"2023-07-31 21:40:00","inspection_id":"79276390","dot_number":"272172","report_state":"CT","report_number":"3091004922","insp_date":"2023-07-31 00:00:00","insp_start_time":"0622","insp_end_time":"0702","registration_date":"2023-07-31 00:00:00","region":"ET","ci_status_code":"C","location":"145","location_desc":"UNION CT","county_code_state":"CT","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"JOHN DEGRAND & SON INC","shipping_paper_number":"409954","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-31 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"681952","transaction_code":"A","transaction_date":"2023-07-31 00:00:00","upload_date":"2023-07-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00272172","upload_search_indicator":null,"census_search_date":"2023-07-31 21:40:00","snet_input_date":"2023-07-31 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-07-31 21:40:00","insp_carrier_name":"JOHN DEGRAND & SON INC","insp_carrier_street":"430 ISLAND LANE","insp_carrier_city":"WEST HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06516","insp_colonia":null,"docket_number":"15100","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:33.000000Z","updated_at":"2025-03-17T19:34:33.000000Z","inspection_violations":[{"id":5593097,"change_date":"2023-07-31 21:40:00","inspection_id":"79276390","insp_violation_id":"254360534","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:32:55.000000Z","updated_at":"2025-03-17T21:32:55.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5831375,"change_date":"2023-07-31 21:40:00","inspection_id":"79276390","insp_unit_id":"196266386","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"20","insp_unit_license":"44836A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1HTMKAAN67H522111","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:03.000000Z","updated_at":"2025-03-17T22:49:03.000000Z"}]},{"id":3628345,"change_date":"2023-07-31 21:40:00","inspection_id":"79278027","dot_number":"272172","report_state":"NY","report_number":"SPE0273817","insp_date":"2023-07-25 00:00:00","insp_start_time":"1207","insp_end_time":"1235","registration_date":null,"region":"ET","ci_status_code":"C","location":"30690","location_desc":"PREBLE (NB)","county_code_state":"NY","county_code":"023","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"VERIZON","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":null,"final_status_date":"2023-07-31 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2853584","transaction_code":"A","transaction_date":"2023-07-25 00:00:00","upload_date":"2023-07-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00272172","upload_search_indicator":null,"census_search_date":"2023-07-31 21:40:00","snet_input_date":"2023-07-31 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-07-31 21:40:00","insp_carrier_name":"JOHN DEGRAND AND SON INC","insp_carrier_street":"PO BOX  16609","insp_carrier_city":"WEST HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06516","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:33.000000Z","updated_at":"2025-03-17T19:34:33.000000Z","inspection_violations":[{"id":5596138,"change_date":"2023-07-31 21:40:00","inspection_id":"79278027","insp_violation_id":"254365263","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196269422","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:55.000000Z","updated_at":"2025-03-17T21:32:55.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":5833508,"change_date":"2023-07-31 21:40:00","inspection_id":"79278027","insp_unit_id":"196269422","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"52","insp_unit_license":"66230A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3HAEETAN0LL887542","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:03.000000Z","updated_at":"2025-03-17T22:49:03.000000Z"}]},{"id":3551773,"change_date":"2023-08-04 21:39:00","inspection_id":"79192163","dot_number":"272172","report_state":"CT","report_number":"3078002069","insp_date":"2023-07-20 00:00:00","insp_start_time":"1516","insp_end_time":"1600","registration_date":"2023-08-04 00:00:00","region":"ET","ci_status_code":"C","location":"145S","location_desc":"UNION SCALE","county_code_state":"CT","county_code":"013","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SAME","shipping_paper_number":"SHIPPING ORDER","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"7","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"681178","transaction_code":"C","transaction_date":"2023-07-20 00:00:00","upload_date":"2023-08-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00272172","upload_search_indicator":null,"census_search_date":"2023-07-20 21:40:00","snet_input_date":"2023-07-20 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-07-20 21:40:00","insp_carrier_name":"JOHN DEGRAND & SON INC","insp_carrier_street":"430 ISLAND LANE","insp_carrier_city":"WEST HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06516","insp_colonia":null,"docket_number":"15100","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:33:10.000000Z","updated_at":"2025-03-17T19:33:10.000000Z","inspection_violations":[{"id":5476181,"change_date":"2023-08-04 21:39:00","inspection_id":"79192163","insp_violation_id":"254462316","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196359407","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:23.000000Z","updated_at":"2025-03-17T21:32:23.000000Z","normalized_code":"3939A"},{"id":5476182,"change_date":"2023-08-04 21:39:00","inspection_id":"79192163","insp_violation_id":"254462317","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196359407","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:23.000000Z","updated_at":"2025-03-17T21:32:23.000000Z","normalized_code":"3939A"},{"id":5476183,"change_date":"2023-08-04 21:39:00","inspection_id":"79192163","insp_violation_id":"254462318","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196359407","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:32:23.000000Z","updated_at":"2025-03-17T21:32:23.000000Z","normalized_code":"3939A"},{"id":5476184,"change_date":"2023-08-04 21:39:00","inspection_id":"79192163","insp_violation_id":"254462319","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196359407","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:23.000000Z","updated_at":"2025-03-17T21:32:23.000000Z","normalized_code":"3939A"},{"id":5476185,"change_date":"2023-08-04 21:39:00","inspection_id":"79192163","insp_violation_id":"254462320","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"196359407","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:32:23.000000Z","updated_at":"2025-03-17T21:32:23.000000Z","normalized_code":"3963A1"},{"id":5476186,"change_date":"2023-08-04 21:39:00","inspection_id":"79192163","insp_violation_id":"254462321","seq_no":"6","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"196359407","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:23.000000Z","updated_at":"2025-03-17T21:32:23.000000Z","normalized_code":"39347E"},{"id":5476187,"change_date":"2023-08-04 21:39:00","inspection_id":"79192163","insp_violation_id":"254462322","seq_no":"7","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"196359407","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:23.000000Z","updated_at":"2025-03-17T21:32:23.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":5711074,"change_date":"2023-08-04 21:39:00","inspection_id":"79192163","insp_unit_id":"196359407","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"35","insp_unit_license":"51370A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1HTMKAAN6FH710948","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:05.000000Z","updated_at":"2025-03-17T22:48:05.000000Z"}]},{"id":3427904,"change_date":"2023-07-05 21:41:00","inspection_id":"79052891","dot_number":"272172","report_state":"CT","report_number":"3119001695","insp_date":"2023-07-05 00:00:00","insp_start_time":"0606","insp_end_time":"0633","registration_date":null,"region":"ET","ci_status_code":"C","location":"084","location_desc":"MILFORD","county_code_state":"CT","county_code":"009","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"VERIZON","shipping_paper_number":"408968","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-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"679439","transaction_code":"A","transaction_date":"2023-07-05 00:00:00","upload_date":"2023-07-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00272172","upload_search_indicator":null,"census_search_date":"2023-07-05 21:41:00","snet_input_date":"2023-07-05 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-07-05 21:41:00","insp_carrier_name":"JOHN DEGRAND & SON INC","insp_carrier_street":"430 ISLAND LANE","insp_carrier_city":"WEST HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06516","insp_colonia":null,"docket_number":"15100","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:30:56.000000Z","updated_at":"2025-03-17T19:30:56.000000Z","inspection_violations":[{"id":5285894,"change_date":"2023-07-05 21:41:00","inspection_id":"79052891","insp_violation_id":"253855637","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"42","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"Y997393-3","created_at":"2025-03-17T21:31:33.000000Z","updated_at":"2025-03-17T21:31:33.000000Z","normalized_code":"3922"},{"id":5285895,"change_date":"2023-07-05 21:41:00","inspection_id":"79052891","insp_violation_id":"253855638","seq_no":"2","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:33.000000Z","updated_at":"2025-03-17T21:31:33.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":5511445,"change_date":"2023-07-05 21:41:00","inspection_id":"79052891","insp_unit_id":"195814433","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"56","insp_unit_license":"BA89995","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3HAEUTAL4PL209500","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:30.000000Z","updated_at":"2025-03-17T22:46:30.000000Z"}]},{"id":3410455,"change_date":"2023-06-30 21:40:00","inspection_id":"79033456","dot_number":"272172","report_state":"NY","report_number":"0817014227","insp_date":"2023-06-27 00:00:00","insp_start_time":"1150","insp_end_time":"1159","registration_date":null,"region":"ET","ci_status_code":"C","location":"80789M","location_desc":"SOUTHEAST REST AREA (NB)","county_code_state":"NY","county_code":"079","insp_level_id":"3","service_center":"EA","census_source_id":"4","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-06-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"2842981","transaction_code":"A","transaction_date":"2023-06-27 00:00:00","upload_date":"2023-06-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00272172","upload_search_indicator":null,"census_search_date":"2023-06-30 21:40:00","snet_input_date":"2023-06-30 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-06-30 21:40:00","insp_carrier_name":"JOHN DEGRAND & SON INC","insp_carrier_street":"PO BOX  16609","insp_carrier_city":"WEST HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06516","insp_colonia":null,"docket_number":"15100","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:30:35.000000Z","updated_at":"2025-03-17T19:30:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5483197,"change_date":"2023-06-30 21:40:00","inspection_id":"79033456","insp_unit_id":"195775628","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"55","insp_unit_license":"72147A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3HAMMMML3FL682834","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:15.000000Z","updated_at":"2025-03-17T22:46:15.000000Z"}]},{"id":3309470,"change_date":"2023-06-30 21:39:00","inspection_id":"78920150","dot_number":"272172","report_state":"CT","report_number":"3019004432","insp_date":"2023-06-19 00:00:00","insp_start_time":"1434","insp_end_time":"1445","registration_date":"2023-06-30 00:00:00","region":"ET","ci_status_code":"C","location":"158","location_desc":"WESTPORT","county_code_state":"CT","county_code":"001","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-19 21:36:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"677715","transaction_code":"C","transaction_date":"2023-06-19 00:00:00","upload_date":"2023-06-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00272172","upload_search_indicator":null,"census_search_date":"2023-06-19 21:36:00","snet_input_date":"2023-06-19 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-06-19 21:36:00","insp_carrier_name":"JOHN DEGRAND & SON INC","insp_carrier_street":"430 ISLAND LANE","insp_carrier_city":"WEST HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06516","insp_colonia":null,"docket_number":"15100","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:28:32.000000Z","updated_at":"2025-03-17T19:28:32.000000Z","inspection_violations":[{"id":5105241,"change_date":"2023-06-30 21:39:00","inspection_id":"78920150","insp_violation_id":"253808409","seq_no":"1","part_no":"392","part_no_section":"82(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"Y996935-0","created_at":"2025-03-17T21:30:44.000000Z","updated_at":"2025-03-17T21:30:44.000000Z","normalized_code":"39282A1"}],"inspection_per_units":[{"id":5320626,"change_date":"2023-06-30 21:39:00","inspection_id":"78920150","insp_unit_id":"195773965","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"35","insp_unit_license":"51370A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1HTMKAAN6FH710948","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:59.000000Z","updated_at":"2025-03-17T22:44:59.000000Z"}]},{"id":2915772,"change_date":"2023-04-28 21:38:00","inspection_id":"78475579","dot_number":"272172","report_state":"VT","report_number":"51A0000032","insp_date":"2023-04-27 00:00:00","insp_start_time":"1223","insp_end_time":"1240","registration_date":null,"region":"ET","ci_status_code":"C","location":"1313SB","location_desc":"PUTNEY SB RA","county_code_state":"VT","county_code":"025","insp_level_id":"1","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":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-28 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"198224","transaction_code":"A","transaction_date":"2023-04-27 00:00:00","upload_date":"2023-04-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00272172","upload_search_indicator":null,"census_search_date":"2023-04-28 21:38:00","snet_input_date":"2023-04-27 00:00:00","source_office":"1VTS001","mcmis_add_date":"2023-04-28 21:38:00","insp_carrier_name":"JOHN DEGRAND & SON INC","insp_carrier_street":"430 ISLAND LANE","insp_carrier_city":"WEST HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06516","insp_colonia":null,"docket_number":"15100","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:20:28.000000Z","updated_at":"2025-03-17T19:20:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4690951,"change_date":"2023-04-28 21:38:00","inspection_id":"78475579","insp_unit_id":"194639340","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"58","insp_unit_license":"74285A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FD0X5HT8NEF12327","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:59.000000Z","updated_at":"2025-03-17T22:39:59.000000Z"}]},{"id":2712148,"change_date":"2023-06-19 21:36:00","inspection_id":"78244882","dot_number":"272172","report_state":"RI","report_number":"0084000958","insp_date":"2023-03-30 00:00:00","insp_start_time":"1205","insp_end_time":"1220","registration_date":null,"region":"ET","ci_status_code":"C","location":"26","location_desc":"RT 95S @ EXIT 14 (RT 37)","county_code_state":"RI","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-06-19 21:36:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"81330","transaction_code":"C","transaction_date":"2023-06-19 00:00:00","upload_date":"2023-06-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00272172","upload_search_indicator":"M","census_search_date":"2023-06-19 21:36:00","snet_input_date":"2023-03-31 00:00:00","source_office":"1RIS001","mcmis_add_date":"2023-04-01 21:30:00","insp_carrier_name":"JOHN DEGRAND & SON INC","insp_carrier_street":"430 ISLAND LANE","insp_carrier_city":"WEST HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06516","insp_colonia":null,"docket_number":"15100","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:16:37.000000Z","updated_at":"2025-03-17T19:16:37.000000Z","inspection_violations":[{"id":4166739,"change_date":"2023-06-19 21:36:00","inspection_id":"78244882","insp_violation_id":"253569248","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:26:31.000000Z","updated_at":"2025-03-17T21:26:31.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4364916,"change_date":"2023-06-19 21:36:00","inspection_id":"78244882","insp_unit_id":"195553139","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"66898A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3HAEUTAL5LL855381","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:21.000000Z","updated_at":"2025-03-17T22:37:21.000000Z"}]},{"id":2451750,"change_date":"2023-02-27 21:40:00","inspection_id":"77947921","dot_number":"272172","report_state":"CT","report_number":"3015001884","insp_date":"2023-02-27 00:00:00","insp_start_time":"1036","insp_end_time":"1050","registration_date":null,"region":"ET","ci_status_code":"C","location":"UNION","location_desc":"UNION SCALE","county_code_state":"CT","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"JOHN DEGRAND AND SON 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":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"667781","transaction_code":"A","transaction_date":"2023-02-27 00:00:00","upload_date":"2023-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00272172","upload_search_indicator":null,"census_search_date":"2023-02-27 21:40:00","snet_input_date":"2023-02-27 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-02-27 21:40:00","insp_carrier_name":"JOHN DEGRAND & SON INC","insp_carrier_street":"430 ISLAND LANE","insp_carrier_city":"WEST HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06516","insp_colonia":null,"docket_number":"15100","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:11:48.000000Z","updated_at":"2025-03-17T19:11:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3945511,"change_date":"2023-02-27 21:40:00","inspection_id":"77947921","insp_unit_id":"193583903","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"N\/A","insp_unit_license":"66382A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1HTEUTAN1LH887560","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:16.000000Z","updated_at":"2025-03-17T22:34:16.000000Z"}]},{"id":2250697,"change_date":"2023-01-30 21:43:00","inspection_id":"77718891","dot_number":"272172","report_state":"NY","report_number":"SPK0158117","insp_date":"2023-01-24 00:00:00","insp_start_time":"0848","insp_end_time":"0907","registration_date":null,"region":"ET","ci_status_code":"C","location":"80288A","location_desc":"FISHKILL DOT RESIDENCY","county_code_state":"NY","county_code":"027","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":"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-01-30 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"2792523","transaction_code":"A","transaction_date":"2023-01-30 00:00:00","upload_date":"2023-01-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00272172","upload_search_indicator":"M","census_search_date":"2023-01-30 21:43:00","snet_input_date":"2023-01-27 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-01-30 21:43:00","insp_carrier_name":"JOHN DEGRAND & SON INC","insp_carrier_street":"PO#  16609","insp_carrier_city":"WEST HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06516","insp_colonia":null,"docket_number":"15100","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:08.000000Z","updated_at":"2025-03-17T19:08:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3622324,"change_date":"2023-01-30 21:43:00","inspection_id":"77718891","insp_unit_id":"193118164","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"55","insp_unit_license":"72147A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3HAMMMML3FL682834","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:58.000000Z","updated_at":"2025-03-17T22:31:58.000000Z"}]},{"id":2023802,"change_date":"2023-03-23 21:43:00","inspection_id":"77459050","dot_number":"272172","report_state":"RI","report_number":"00LR002692","insp_date":"2022-12-27 00:00:00","insp_start_time":"1327","insp_end_time":"1353","registration_date":"2023-01-09 00:00:00","region":"ET","ci_status_code":"C","location":"23","location_desc":"RT 95S @ EXIT 12 (RT 113)","county_code_state":"RI","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"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-28 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"79931","transaction_code":"C","transaction_date":"2023-03-23 00:00:00","upload_date":"2023-03-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00272172","upload_search_indicator":"M","census_search_date":"2022-12-28 21:39:00","snet_input_date":"2022-12-27 00:00:00","source_office":"1RIS001","mcmis_add_date":"2022-12-28 21:39:00","insp_carrier_name":"JOHN DEGRAND & SON INC","insp_carrier_street":"430 ISLAND LANE","insp_carrier_city":"WEST HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06516","insp_colonia":null,"docket_number":"15100","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:03:59.000000Z","updated_at":"2025-03-17T19:03:59.000000Z","inspection_violations":[{"id":3138421,"change_date":"2023-03-23 21:43:00","inspection_id":"77459050","insp_violation_id":"251822832","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:21:50.000000Z","updated_at":"2025-03-17T21:21:50.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3255976,"change_date":"2023-03-23 21:43:00","inspection_id":"77459050","insp_unit_id":"194020117","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"56","insp_unit_license":"BA89995","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3HAEUTAL4PL209500","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:19.000000Z","updated_at":"2025-03-17T22:29:19.000000Z"}]},{"id":1712197,"change_date":"2022-11-28 21:40:00","inspection_id":"77102442","dot_number":"272172","report_state":"CT","report_number":"3078001359","insp_date":"2022-11-10 00:00:00","insp_start_time":"0639","insp_end_time":"0706","registration_date":"2022-11-28 00:00:00","region":"ET","ci_status_code":"C","location":"083S","location_desc":"MIDDLETOWN SCALE","county_code_state":"CT","county_code":"007","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SAME","shipping_paper_number":"MANIFEST","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-10 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"658467","transaction_code":"C","transaction_date":"2022-11-10 00:00:00","upload_date":"2022-11-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00272172","upload_search_indicator":null,"census_search_date":"2022-11-10 21:38:00","snet_input_date":"2022-11-10 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-11-10 21:38:00","insp_carrier_name":"JOHN DEGRAND & SON INC","insp_carrier_street":"430 ISLAND LANE","insp_carrier_city":"WEST HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06516","insp_colonia":null,"docket_number":"15100","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:13.000000Z","updated_at":"2025-03-17T18:58:13.000000Z","inspection_violations":[{"id":2684209,"change_date":"2022-11-28 21:40:00","inspection_id":"77102442","insp_violation_id":"249786733","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"192126971","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:39.000000Z","updated_at":"2025-03-17T21:19:39.000000Z","normalized_code":"39395A"},{"id":2684210,"change_date":"2022-11-28 21:40:00","inspection_id":"77102442","insp_violation_id":"249786734","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"192126971","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:39.000000Z","updated_at":"2025-03-17T21:19:39.000000Z","normalized_code":"39617C"},{"id":2684211,"change_date":"2022-11-28 21:40:00","inspection_id":"77102442","insp_violation_id":"249786735","seq_no":"3","part_no":"393","part_no_section":"201(b)","insp_viol_unit":"1","insp_unit_id":"192126971","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:39.000000Z","updated_at":"2025-03-17T21:19:39.000000Z","normalized_code":"393201B"},{"id":2684212,"change_date":"2022-11-28 21:40:00","inspection_id":"77102442","insp_violation_id":"249786736","seq_no":"4","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"192126971","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:39.000000Z","updated_at":"2025-03-17T21:19:39.000000Z","normalized_code":"39383G"},{"id":2684213,"change_date":"2022-11-28 21:40:00","inspection_id":"77102442","insp_violation_id":"249786737","seq_no":"5","part_no":"395","part_no_section":"24(d)","insp_viol_unit":"1","insp_unit_id":"192126971","insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:39.000000Z","updated_at":"2025-03-17T21:19:39.000000Z","normalized_code":"39524D"}],"inspection_per_units":[{"id":2754557,"change_date":"2022-11-28 21:40:00","inspection_id":"77102442","insp_unit_id":"192126971","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"53772A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1HTMMAAL2DH195548","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:50.000000Z","updated_at":"2025-03-17T22:25:50.000000Z"}]},{"id":1701506,"change_date":"2022-11-18 21:38:00","inspection_id":"77090089","dot_number":"272172","report_state":"CT","report_number":"3079001730","insp_date":"2022-11-09 00:00:00","insp_start_time":"1355","insp_end_time":"1422","registration_date":"2022-11-18 00:00:00","region":"ET","ci_status_code":"C","location":"035","location_desc":"DARIEN","county_code_state":"CT","county_code":"001","insp_level_id":"3","service_center":"EA","census_source_id":"5","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":null,"final_status_date":"2022-11-09 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"658356","transaction_code":"C","transaction_date":"2022-11-09 00:00:00","upload_date":"2022-11-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00272172","upload_search_indicator":null,"census_search_date":"2022-11-09 21:39:00","snet_input_date":"2022-11-09 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-11-09 21:39:00","insp_carrier_name":"JOHN DEGRAND & SON INC","insp_carrier_street":"430 ISLAND LANE","insp_carrier_city":"WEST HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06516","insp_colonia":null,"docket_number":"15100","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:09.000000Z","updated_at":"2025-03-17T18:58:09.000000Z","inspection_violations":[{"id":2667255,"change_date":"2022-11-18 21:38:00","inspection_id":"77090089","insp_violation_id":"249669926","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:19:34.000000Z","updated_at":"2025-03-17T21:19:34.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2737828,"change_date":"2022-11-18 21:38:00","inspection_id":"77090089","insp_unit_id":"192019418","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"56252A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1HTMKAAN4FH710947","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:44.000000Z","updated_at":"2025-03-17T22:25:44.000000Z"}]},{"id":1600037,"change_date":"2022-10-26 21:39:00","inspection_id":"76973752","dot_number":"272172","report_state":"NY","report_number":"0322003628","insp_date":"2022-10-25 00:00:00","insp_start_time":"1304","insp_end_time":"1327","registration_date":null,"region":"ET","ci_status_code":"C","location":"70877M","location_desc":"WATERTOWN REST AREA (SB)","county_code_state":"NY","county_code":"045","insp_level_id":"2","service_center":"EA","census_source_id":"4","insp_facility":"F","shipper_name":"VERIZON","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-26 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2763104","transaction_code":"A","transaction_date":"2022-10-26 00:00:00","upload_date":"2022-10-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00272172","upload_search_indicator":"M","census_search_date":"2022-10-26 21:39:00","snet_input_date":"2022-10-26 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-10-26 21:39:00","insp_carrier_name":"JOHN DEGRAND & SON INC","insp_carrier_street":"430 ISLAND LANE","insp_carrier_city":"WEST HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06516","insp_colonia":null,"docket_number":"15100","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:56:15.000000Z","updated_at":"2025-03-17T18:56:15.000000Z","inspection_violations":[{"id":2515105,"change_date":"2022-10-26 21:39:00","inspection_id":"76973752","insp_violation_id":"249251015","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191640067","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:47.000000Z","updated_at":"2025-03-17T21:18:47.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":2574435,"change_date":"2022-10-26 21:39:00","inspection_id":"76973752","insp_unit_id":"191640067","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"52","insp_unit_license":"66230A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3HAEETAN0LL887542","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:38.000000Z","updated_at":"2025-03-17T22:24:38.000000Z"}]},{"id":1600131,"change_date":"2022-10-26 21:39:00","inspection_id":"76973860","dot_number":"272172","report_state":"NY","report_number":"MC74000478","insp_date":"2022-10-25 00:00:00","insp_start_time":"1301","insp_end_time":"1317","registration_date":null,"region":"ET","ci_status_code":"C","location":"70877M","location_desc":"WATERTOWN REST AREA (SB)","county_code_state":"NY","county_code":"045","insp_level_id":"3","service_center":"EA","census_source_id":"4","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-10-26 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2762795","transaction_code":"A","transaction_date":"2022-10-26 00:00:00","upload_date":"2022-10-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00272172","upload_search_indicator":"M","census_search_date":"2022-10-26 21:39:00","snet_input_date":"2022-10-26 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-10-26 21:39:00","insp_carrier_name":"JOHN DEGRAND & SON INC","insp_carrier_street":"430 ISLAND LANE","insp_carrier_city":"WEST HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06516","insp_colonia":null,"docket_number":"15100","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:56:15.000000Z","updated_at":"2025-03-17T18:56:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2574562,"change_date":"2022-10-26 21:39:00","inspection_id":"76973860","insp_unit_id":"191640220","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"14","insp_unit_license":"59631A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1HTMKAAN07H431903","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:38.000000Z","updated_at":"2025-03-17T22:24:38.000000Z"}]},{"id":1504438,"change_date":"2022-10-13 21:39:00","inspection_id":"76863613","dot_number":"272172","report_state":"CT","report_number":"3129003474","insp_date":"2022-10-13 00:00:00","insp_start_time":"0803","insp_end_time":"0819","registration_date":null,"region":"ET","ci_status_code":"C","location":"093","location_desc":"NEW HAVEN","county_code_state":"CT","county_code":"009","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-13 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"656214","transaction_code":"A","transaction_date":"2022-10-13 00:00:00","upload_date":"2022-10-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00272172","upload_search_indicator":null,"census_search_date":"2022-10-13 21:39:00","snet_input_date":"2022-10-13 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-10-13 21:39:00","insp_carrier_name":"JOHN DEGRAND & SON INC","insp_carrier_street":"430 ISLAND LANE","insp_carrier_city":"WEST HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06516","insp_colonia":null,"docket_number":"15100","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:54:28.000000Z","updated_at":"2025-03-17T18:54:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2421455,"change_date":"2022-10-13 21:39:00","inspection_id":"76863613","insp_unit_id":"191416873","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"J67569","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1HTMKAAN95H100797","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:36.000000Z","updated_at":"2025-03-17T22:23:36.000000Z"}]},{"id":1352032,"change_date":"2022-09-23 21:37:00","inspection_id":"76687093","dot_number":"272172","report_state":"NY","report_number":"SPWL090801","insp_date":"2022-09-22 00:00:00","insp_start_time":"0918","insp_end_time":"0940","registration_date":null,"region":"ET","ci_status_code":"C","location":"00421R","location_desc":"BOHEMIA","county_code_state":"NY","county_code":"103","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":"2022-09-23 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"4","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2752357","transaction_code":"A","transaction_date":"2022-09-23 00:00:00","upload_date":"2022-09-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00272172","upload_search_indicator":"M","census_search_date":"2022-09-23 21:37:00","snet_input_date":"2022-09-23 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-09-23 21:37:00","insp_carrier_name":"JOHN DEGRAND & SON INC","insp_carrier_street":"430 ISLAND LANE","insp_carrier_city":"WEST HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06516","insp_colonia":null,"docket_number":"15100","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:51:38.000000Z","updated_at":"2025-03-17T18:51:38.000000Z","inspection_violations":[{"id":2140952,"change_date":"2022-09-23 21:37:00","inspection_id":"76687093","insp_violation_id":"248605320","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":"24FWTN50","created_at":"2025-03-17T21:16:48.000000Z","updated_at":"2025-03-17T21:16:48.000000Z","normalized_code":"39216A"},{"id":2140953,"change_date":"2022-09-23 21:37:00","inspection_id":"76687093","insp_violation_id":"248605321","seq_no":"2","part_no":"392","part_no_section":"16(b)","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:16:48.000000Z","updated_at":"2025-03-17T21:16:48.000000Z","normalized_code":"39216B"},{"id":2140954,"change_date":"2022-09-23 21:37:00","inspection_id":"76687093","insp_violation_id":"248605322","seq_no":"3","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:16:48.000000Z","updated_at":"2025-03-17T21:16:48.000000Z","normalized_code":"3922"},{"id":2140955,"change_date":"2022-09-23 21:37:00","inspection_id":"76687093","insp_violation_id":"248605323","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191060889","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:48.000000Z","updated_at":"2025-03-17T21:16:48.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2176848,"change_date":"2022-09-23 21:37:00","inspection_id":"76687093","insp_unit_id":"191060889","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"55","insp_unit_license":"72147A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3HAMMMML3FL682834","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:54.000000Z","updated_at":"2025-03-17T22:21:54.000000Z"}]},{"id":1023274,"change_date":"2022-08-16 21:38:00","inspection_id":"76304560","dot_number":"272172","report_state":"ME","report_number":"0221007667","insp_date":"2022-08-11 00:00:00","insp_start_time":"1311","insp_end_time":"1407","registration_date":"2022-08-16 00:00:00","region":"ET","ci_status_code":"C","location":"000440","location_desc":"SIDNEY - SCALES","county_code_state":"ME","county_code":"011","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"F","shipper_name":"VERIZON","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-08-16 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"351326","transaction_code":"C","transaction_date":"2022-08-15 00:00:00","upload_date":"2022-08-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00272172","upload_search_indicator":"M","census_search_date":"2022-08-16 21:38:00","snet_input_date":"2022-08-12 00:00:00","source_office":"1MES001","mcmis_add_date":"2022-08-12 21:39:00","insp_carrier_name":"JOHN DEGRAND & SON INC","insp_carrier_street":"430 ISLAND LANE","insp_carrier_city":"WEST HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06516","insp_colonia":null,"docket_number":"15100","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:45:47.000000Z","updated_at":"2025-03-17T18:45:47.000000Z","inspection_violations":[{"id":1612622,"change_date":"2022-08-16 21:38:00","inspection_id":"76304560","insp_violation_id":"247725865","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"190319866","insp_violation_category_id":"18","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:14:34.000000Z","updated_at":"2025-03-17T21:14:34.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":1646322,"change_date":"2022-08-16 21:38:00","inspection_id":"76304560","insp_unit_id":"190319866","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"52","insp_unit_license":"66230A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3HAEETAN0LL887542","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:22.000000Z","updated_at":"2025-03-17T22:18:22.000000Z"}]},{"id":960953,"change_date":"2022-08-25 21:42:00","inspection_id":"76232039","dot_number":"272172","report_state":"CT","report_number":"3064000916","insp_date":"2022-08-04 00:00:00","insp_start_time":"1356","insp_end_time":"1458","registration_date":"2022-08-25 00:00:00","region":"ET","ci_status_code":"C","location":"164","location_desc":"WINDSOR","county_code_state":"CT","county_code":"003","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"JOHN DEGRAND & SON INC","shipping_paper_number":"400732","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"650725","transaction_code":"C","transaction_date":"2022-08-04 00:00:00","upload_date":"2022-08-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00272172","upload_search_indicator":null,"census_search_date":"2022-08-04 21:41:00","snet_input_date":"2022-08-04 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-08-04 21:41:00","insp_carrier_name":"JOHN DEGRAND & SON INC","insp_carrier_street":"430 ISLAND LANE","insp_carrier_city":"WEST HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06516","insp_colonia":null,"docket_number":"15100","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:44:43.000000Z","updated_at":"2025-03-17T18:44:43.000000Z","inspection_violations":[{"id":1514953,"change_date":"2022-08-25 21:42:00","inspection_id":"76232039","insp_violation_id":"247978032","seq_no":"1","part_no":"392","part_no_section":"16(b)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"Y990315-2","created_at":"2025-03-17T21:14:09.000000Z","updated_at":"2025-03-17T21:14:09.000000Z","normalized_code":"39216B"},{"id":1514954,"change_date":"2022-08-25 21:42:00","inspection_id":"76232039","insp_violation_id":"247978033","seq_no":"2","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"190528816","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:09.000000Z","updated_at":"2025-03-17T21:14:09.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":1546423,"change_date":"2022-08-25 21:42:00","inspection_id":"76232039","insp_unit_id":"190528816","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"10","insp_unit_license":"34196A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1HTMKAAN85H130759","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:44.000000Z","updated_at":"2025-03-17T22:17:44.000000Z"}]},{"id":993618,"change_date":"2022-08-09 21:40:00","inspection_id":"76269958","dot_number":"272172","report_state":"NY","report_number":"SPL0105738","insp_date":"2022-08-04 00:00:00","insp_start_time":"0640","insp_end_time":"0700","registration_date":null,"region":"ET","ci_status_code":"C","location":"00096F","location_desc":"YAPHANK (EB)","county_code_state":"NY","county_code":"103","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":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2736165","transaction_code":"A","transaction_date":"2022-08-09 00:00:00","upload_date":"2022-08-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00272172","upload_search_indicator":"M","census_search_date":"2022-08-09 21:40:00","snet_input_date":"2022-08-08 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-08-09 21:40:00","insp_carrier_name":"JOHN DEGRAND & SON INC","insp_carrier_street":"PO#  16609","insp_carrier_city":"WEST HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06516","insp_colonia":null,"docket_number":"15100","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:45:07.000000Z","updated_at":"2025-03-17T18:45:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1598689,"change_date":"2022-08-09 21:40:00","inspection_id":"76269958","insp_unit_id":"190203860","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"53","insp_unit_license":"66382A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1HTEUTAN1LH887560","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:04.000000Z","updated_at":"2025-03-17T22:18:04.000000Z"}]},{"id":547681,"change_date":"2022-06-06 21:40:00","inspection_id":"75745793","dot_number":"272172","report_state":"NY","report_number":"SPT0530061","insp_date":"2022-06-01 00:00:00","insp_start_time":"1012","insp_end_time":"1048","registration_date":null,"region":"ET","ci_status_code":"C","location":"20330M","location_desc":"GLEN REST AREA WB","county_code_state":"NY","county_code":"057","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"JOHN DEGRAND AND SON, INC.","shipping_paper_number":"MR02155902","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2714156","transaction_code":"A","transaction_date":"2022-06-06 00:00:00","upload_date":"2022-06-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00272172","upload_search_indicator":"M","census_search_date":"2022-06-06 21:40:00","snet_input_date":"2022-06-06 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-06-06 21:40:00","insp_carrier_name":"JOHN DEGRAND & SON INC","insp_carrier_street":"PO#  16609","insp_carrier_city":"WEST HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06516","insp_colonia":null,"docket_number":"15100","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:37:26.000000Z","updated_at":"2025-03-17T18:37:26.000000Z","inspection_violations":[{"id":862430,"change_date":"2022-06-06 21:40:00","inspection_id":"75745793","insp_violation_id":"246256899","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"189074050","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:06.000000Z","updated_at":"2025-03-17T21:11:06.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":880843,"change_date":"2022-06-06 21:40:00","inspection_id":"75745793","insp_unit_id":"189074050","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"52","insp_unit_license":"66230A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3HAEETAN0LL887542","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:38.000000Z","updated_at":"2025-03-17T22:13:38.000000Z"}]},{"id":428828,"change_date":"2022-07-27 21:40:00","inspection_id":"75604301","dot_number":"272172","report_state":"RI","report_number":"00LR002108","insp_date":"2022-05-19 00:00:00","insp_start_time":"0803","insp_end_time":"0849","registration_date":"2022-06-15 00:00:00","region":"ET","ci_status_code":"C","location":"58","location_desc":"RT 95N @ WEIGH STATION","county_code_state":"RI","county_code":"009","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"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-05-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"4","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"77063","transaction_code":"C","transaction_date":"2022-07-27 00:00:00","upload_date":"2022-07-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00272172","upload_search_indicator":"M","census_search_date":"2022-05-19 21:41:00","snet_input_date":"2022-05-19 00:00:00","source_office":"1RIS001","mcmis_add_date":"2022-05-19 21:41:00","insp_carrier_name":"JOHN DEGRAND & SON INC","insp_carrier_street":"430 ISLAND LANE","insp_carrier_city":"WEST HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06516","insp_colonia":null,"docket_number":"15100","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:35:09.000000Z","updated_at":"2025-03-17T18:35:09.000000Z","inspection_violations":[{"id":673795,"change_date":"2022-07-27 21:40:00","inspection_id":"75604301","insp_violation_id":"247341696","seq_no":"1","part_no":"395","part_no_section":"3(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:10.000000Z","updated_at":"2025-03-17T21:10:10.000000Z","normalized_code":"3953A2"},{"id":673796,"change_date":"2022-07-27 21:40:00","inspection_id":"75604301","insp_violation_id":"247341697","seq_no":"2","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:10:10.000000Z","updated_at":"2025-03-17T21:10:10.000000Z","normalized_code":"39216A"},{"id":673797,"change_date":"2022-07-27 21:40:00","inspection_id":"75604301","insp_violation_id":"247341698","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189986962","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:10.000000Z","updated_at":"2025-03-17T21:10:10.000000Z","normalized_code":"3939A"},{"id":673798,"change_date":"2022-07-27 21:40:00","inspection_id":"75604301","insp_violation_id":"247341699","seq_no":"4","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"189986962","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:10.000000Z","updated_at":"2025-03-17T21:10:10.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":691421,"change_date":"2022-07-27 21:40:00","inspection_id":"75604301","insp_unit_id":"189986962","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"10","insp_unit_license":"34196A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1HTMKAAN85H130759","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:27.000000Z","updated_at":"2025-03-17T22:12:27.000000Z"}]},{"id":441409,"change_date":"2022-06-30 21:41:00","inspection_id":"75619213","dot_number":"272172","report_state":"VT","report_number":"SP24000308","insp_date":"2022-05-18 00:00:00","insp_start_time":"1437","insp_end_time":"1500","registration_date":"2022-06-28 00:00:00","region":"ET","ci_status_code":"C","location":null,"location_desc":"NB RANDOLPH WEIGH STATION","county_code_state":"VT","county_code":"017","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"J DEGRAND AND SONS","shipping_paper_number":"MR02148607","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-05-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"191897","transaction_code":"C","transaction_date":"2022-05-18 00:00:00","upload_date":"2022-06-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00272172","upload_search_indicator":null,"census_search_date":"2022-05-20 21:40:00","snet_input_date":"2022-05-18 00:00:00","source_office":"1VTS001","mcmis_add_date":"2022-05-20 21:40:00","insp_carrier_name":"JOHN DEGRAND & SON INC","insp_carrier_street":"430 ISLAND LANE","insp_carrier_city":"WEST HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06516","insp_colonia":null,"docket_number":"15100","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:35:35.000000Z","updated_at":"2025-03-17T18:35:35.000000Z","inspection_violations":[{"id":697199,"change_date":"2022-06-30 21:41:00","inspection_id":"75619213","insp_violation_id":"246817839","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189542300","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:15.000000Z","updated_at":"2025-03-17T21:10:15.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":711364,"change_date":"2022-06-30 21:41:00","inspection_id":"75619213","insp_unit_id":"189542300","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"52","insp_unit_license":"66230A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3HAEETAN0LL887542","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:34.000000Z","updated_at":"2025-03-17T22:12:34.000000Z"}]},{"id":374639,"change_date":"2022-05-12 21:41:00","inspection_id":"75539659","dot_number":"272172","report_state":"NY","report_number":"SPF0201849","insp_date":"2022-05-05 00:00:00","insp_start_time":"0950","insp_end_time":"1020","registration_date":null,"region":"ET","ci_status_code":"C","location":"80392","location_desc":"TOWN OF HIGHLANDS","county_code_state":"NY","county_code":"071","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":"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-05-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2705472","transaction_code":"A","transaction_date":"2022-05-12 00:00:00","upload_date":"2022-05-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00272172","upload_search_indicator":"M","census_search_date":"2022-05-12 21:41:00","snet_input_date":"2022-05-12 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-05-12 21:41:00","insp_carrier_name":"JOHN DEGRAND & SON INC","insp_carrier_street":"PO#  16609","insp_carrier_city":"WEST HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06516","insp_colonia":null,"docket_number":"15100","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:34:01.000000Z","updated_at":"2025-03-17T18:34:01.000000Z","inspection_violations":[{"id":586827,"change_date":"2022-05-12 21:41:00","inspection_id":"75539659","insp_violation_id":"245745092","seq_no":"1","part_no":"393","part_no_section":"55(d)(1)","insp_viol_unit":"1","insp_unit_id":"188644761","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:48.000000Z","updated_at":"2025-03-17T21:09:48.000000Z","normalized_code":"39355D1"},{"id":586828,"change_date":"2022-05-12 21:41:00","inspection_id":"75539659","insp_violation_id":"245745093","seq_no":"2","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"188644761","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:48.000000Z","updated_at":"2025-03-17T21:09:48.000000Z","normalized_code":"3965B"},{"id":586829,"change_date":"2022-05-12 21:41:00","inspection_id":"75539659","insp_violation_id":"245745094","seq_no":"3","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"188644761","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:48.000000Z","updated_at":"2025-03-17T21:09:48.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":605717,"change_date":"2022-05-12 21:41:00","inspection_id":"75539659","insp_unit_id":"188644761","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"21A","insp_unit_license":"51544A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1HTMMAAL39H121837","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:55.000000Z","updated_at":"2025-03-17T22:11:55.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/272172\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/272172\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/272172\/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\/272172\/inspections","per_page":100,"prev_page_url":null,"to":58,"total":58}