{"current_page":1,"data":[{"id":12077027,"change_date":"2026-06-02 21:41:00","inspection_id":"88019563","dot_number":"759785","report_state":"VT","report_number":"3700002233","insp_date":"2026-06-02 00:00:00","insp_start_time":"0911","insp_end_time":"0943","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"VT","county_code_state":"VT","county_code":"007","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":"U","pen_cen_match":"I","final_status_date":"2026-06-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"44900","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":"3449020","transaction_code":"A","transaction_date":"2026-06-02 00:00:00","upload_date":"2026-06-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00759785","upload_search_indicator":null,"census_search_date":"2026-06-02 21:41:00","snet_input_date":"2026-06-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-02 21:41:00","insp_carrier_name":"CRESTVIEW CONSTRUCTION & TRUCKING INC","insp_carrier_street":"25 INDUSTRIAL RD","insp_carrier_city":"SOUTHWICK","insp_carrier_state":"MA","insp_carrier_zip_code":"01077","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-06T09:40:26.000000Z","updated_at":"2026-06-13T09:31:25.000000Z","inspection_violations":[{"id":21014677,"change_date":"2026-06-02 21:41:00","inspection_id":"88019563","insp_violation_id":"274644207","seq_no":"1","part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-06T10:00:17.000000Z","updated_at":"2026-06-13T09:43:30.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":20987221,"change_date":"2026-06-02 21:41:00","inspection_id":"88019563","insp_unit_id":"213871569","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":null,"insp_unit_license":"V27920","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3C7WRNAL5JG338841","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-06T09:17:21.000000Z","updated_at":"2026-06-13T09:02:28.000000Z"},{"id":20987222,"change_date":"2026-06-02 21:41:00","inspection_id":"88019563","insp_unit_id":"213871570","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"F13892","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"5FTCF3228M1000023","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-06T09:17:21.000000Z","updated_at":"2026-06-13T09:02:28.000000Z"}]},{"id":11081511,"change_date":"2026-02-09 21:38:00","inspection_id":"86992747","dot_number":"759785","report_state":"MA","report_number":"DE00001716","insp_date":"2026-02-09 00:00:00","insp_start_time":"1220","insp_end_time":"1233","registration_date":null,"region":"ET","ci_status_code":"C","location":"170S","location_desc":"S-LENOX","county_code_state":"MA","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":"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":"2026-02-09 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"539876","transaction_code":"A","transaction_date":"2026-02-09 00:00:00","upload_date":"2026-02-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00759785","upload_search_indicator":"M","census_search_date":"2026-02-09 21:38:00","snet_input_date":"2026-02-09 00:00:00","source_office":"1MAS001","mcmis_add_date":"2026-02-09 21:38:00","insp_carrier_name":"CRESTVIEW CONSTRUCTION & TRUCKING INC","insp_carrier_street":"25 INDUSTRIAL RD","insp_carrier_city":"SOUTHWICK","insp_carrier_state":"MA","insp_carrier_zip_code":"01077","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-12T10:36:58.000000Z","updated_at":"2026-02-20T10:30:33.000000Z","inspection_violations":[{"id":18551573,"change_date":"2026-02-09 21:38:00","inspection_id":"86992747","insp_violation_id":"271677228","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"211514590","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-12T10:50:26.000000Z","updated_at":"2026-02-20T10:38:57.000000Z","normalized_code":"39617CPI"},{"id":18551574,"change_date":"2026-02-09 21:38:00","inspection_id":"86992747","insp_violation_id":"271677229","seq_no":"2","part_no":"393","part_no_section":"87A-FPLR","insp_viol_unit":"1","insp_unit_id":"211514590","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-12T10:50:26.000000Z","updated_at":"2026-02-20T10:38:57.000000Z","normalized_code":"39387AFPLR"}],"inspection_per_units":[{"id":18895973,"change_date":"2026-02-09 21:38:00","inspection_id":"86992747","insp_unit_id":"211514590","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"W10486","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FDXF46P45EC23723","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-12T10:13:35.000000Z","updated_at":"2026-02-20T10:03:27.000000Z"}]},{"id":10212318,"change_date":"2025-11-17 21:38:00","inspection_id":"86333672","dot_number":"759785","report_state":"CT","report_number":"3129006361","insp_date":"2025-11-17 00:00:00","insp_start_time":"0803","insp_end_time":"0827","registration_date":null,"region":"ET","ci_status_code":"C","location":"052","location_desc":"FARMINGTON","county_code_state":"CT","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-11-17 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"76500","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":"757930","transaction_code":"A","transaction_date":"2025-11-17 00:00:00","upload_date":"2025-11-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00759785","upload_search_indicator":null,"census_search_date":"2025-11-17 21:38:00","snet_input_date":"2025-11-17 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-11-17 21:38:00","insp_carrier_name":"CRESTVIEW CONSTRUCTION & TRUCKING INC","insp_carrier_street":"25 INDUSTRIAL RD","insp_carrier_city":"SOUTHWICK","insp_carrier_state":"MA","insp_carrier_zip_code":"01077","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-20T10:30:20.000000Z","updated_at":"2025-11-21T10:30:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17011650,"change_date":"2025-11-17 21:38:00","inspection_id":"86333672","insp_unit_id":"210053962","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"1AJ85H","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1NKWX4TX8KJ245131","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-20T10:00:25.000000Z","updated_at":"2025-11-21T10:00:07.000000Z"}]},{"id":9954076,"change_date":"2025-10-16 21:39:00","inspection_id":"86061798","dot_number":"759785","report_state":"CT","report_number":"3091006204","insp_date":"2025-10-16 00:00:00","insp_start_time":"1311","insp_end_time":"1335","registration_date":null,"region":"ET","ci_status_code":"C","location":"077","location_desc":"MANCHESTER","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CRESTVIEW CONSTRUCTION & TRUCKING INC","shipping_paper_number":"1025-5000YP-DMR","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-10-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"83240","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":"755431","transaction_code":"A","transaction_date":"2025-10-16 00:00:00","upload_date":"2025-10-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00759785","upload_search_indicator":null,"census_search_date":"2025-10-16 21:39:00","snet_input_date":"2025-10-16 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-10-16 21:39:00","insp_carrier_name":"CRESTVIEW CONSTRUCTION & TRUCKING INC","insp_carrier_street":"25 INDUSTRIAL RD","insp_carrier_city":"SOUTHWICK","insp_carrier_state":"MA","insp_carrier_zip_code":"01077","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-19T10:01:26.000000Z","updated_at":"2025-10-20T10:00:07.000000Z","inspection_violations":[{"id":16437039,"change_date":"2025-10-16 21:39:00","inspection_id":"86061798","insp_violation_id":"269327713","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":"V136703-2","created_at":"2025-10-19T10:17:22.000000Z","updated_at":"2025-10-20T10:15:14.000000Z","normalized_code":"39216D"}],"inspection_per_units":[{"id":16525530,"change_date":"2025-10-16 21:39:00","inspection_id":"86061798","insp_unit_id":"209493710","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"12","insp_unit_license":"1AD34G","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1NK1X4TX3NJ495875","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-19T09:46:41.000000Z","updated_at":"2025-10-20T09:45:10.000000Z"}]},{"id":9653161,"change_date":"2025-09-11 21:41:00","inspection_id":"85746916","dot_number":"759785","report_state":"MA","report_number":"CW00004015","insp_date":"2025-09-11 00:00:00","insp_start_time":"0603","insp_end_time":"0620","registration_date":null,"region":"ET","ci_status_code":"C","location":"374H","location_desc":"H-WHATLEY","county_code_state":"MA","county_code":"011","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","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":"2025-09-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"77000","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"528487","transaction_code":"A","transaction_date":"2025-09-11 00:00:00","upload_date":"2025-09-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00759785","upload_search_indicator":"M","census_search_date":"2025-09-11 21:41:00","snet_input_date":"2025-09-11 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-09-11 21:41:00","insp_carrier_name":"CRESTVIEW CONSTRUCTION & TRUCKING INC","insp_carrier_street":"25 INDUSTRIAL RD","insp_carrier_city":"SOUTHWICK","insp_carrier_state":"MA","insp_carrier_zip_code":"01077","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-13T10:47:57.000000Z","updated_at":"2025-09-16T10:46:53.000000Z","inspection_violations":[{"id":15810088,"change_date":"2025-09-11 21:41:00","inspection_id":"85746916","insp_violation_id":"268610035","seq_no":"1","part_no":"392","part_no_section":"2-SLLS1","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-14T11:56:57.000000Z","updated_at":"2025-09-14T11:56:57.000000Z","normalized_code":"3922SLLS1"},{"id":15810089,"change_date":"2025-09-11 21:41:00","inspection_id":"85746916","insp_violation_id":"268610036","seq_no":"2","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"208873018","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-14T11:56:57.000000Z","updated_at":"2025-09-14T11:56:57.000000Z","normalized_code":"39360D"},{"id":15810090,"change_date":"2025-09-11 21:41:00","inspection_id":"85746916","insp_violation_id":"268610037","seq_no":"3","part_no":"396","part_no_section":"9D2-FTF","insp_viol_unit":"1","insp_unit_id":"208873018","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"694809AD","created_at":"2025-09-14T11:56:57.000000Z","updated_at":"2025-09-14T11:56:57.000000Z","normalized_code":"3969D2FTF"}],"inspection_per_units":[{"id":15951976,"change_date":"2025-09-11 21:41:00","inspection_id":"85746916","insp_unit_id":"208873018","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"1AJ49K","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1NKWX4TX8NR469604","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-13T10:00:37.000000Z","updated_at":"2025-09-15T09:53:17.000000Z"}]},{"id":9418211,"change_date":"2025-08-15 21:38:00","inspection_id":"85498550","dot_number":"759785","report_state":"CT","report_number":"3014004601","insp_date":"2025-08-14 00:00:00","insp_start_time":"1353","insp_end_time":"1409","registration_date":null,"region":"ET","ci_status_code":"C","location":"155","location_desc":"WEST HARTFORD","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"FARMINGTON READY MIX","shipping_paper_number":"585139","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-15 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"76500","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":"749056","transaction_code":"A","transaction_date":"2025-08-14 00:00:00","upload_date":"2025-08-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00759785","upload_search_indicator":null,"census_search_date":"2025-08-15 21:38:00","snet_input_date":"2025-08-14 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-08-15 21:38:00","insp_carrier_name":"CRESTVIEW CONSTRUCTION & TRUCKING INC","insp_carrier_street":"25 INDUSTRIAL RD","insp_carrier_city":"SOUTHWICK","insp_carrier_state":"MA","insp_carrier_zip_code":"01077","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-20T10:44:28.000000Z","updated_at":"2025-08-20T10:44:28.000000Z","inspection_violations":[{"id":15322462,"change_date":"2025-08-15 21:38:00","inspection_id":"85498550","insp_violation_id":"268042059","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"W1120-4491","created_at":"2025-08-18T10:44:43.000000Z","updated_at":"2025-08-19T10:43:42.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":15525131,"change_date":"2025-08-15 21:38:00","inspection_id":"85498550","insp_unit_id":"208409151","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"11","insp_unit_license":"1AJ85H","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1NKWX4TX8KJ245131","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-18T09:46:25.000000Z","updated_at":"2025-08-19T09:45:08.000000Z"}]},{"id":8675415,"change_date":"2025-05-19 21:40:00","inspection_id":"84714900","dot_number":"759785","report_state":"MA","report_number":"CW00003802","insp_date":"2025-05-19 00:00:00","insp_start_time":"0551","insp_end_time":"0612","registration_date":null,"region":"ET","ci_status_code":"C","location":"374H","location_desc":"H-WHATLEY","county_code_state":"MA","county_code":"011","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","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":"2025-05-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"77000","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":"518166","transaction_code":"A","transaction_date":"2025-05-19 00:00:00","upload_date":"2025-05-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00759785","upload_search_indicator":"M","census_search_date":"2025-05-19 21:40:00","snet_input_date":"2025-05-19 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-05-19 21:40:00","insp_carrier_name":"CRESTVIEW CONSTRUCTION & TRUCKING INC","insp_carrier_street":"25 INDUSTRIAL RD","insp_carrier_city":"SOUTHWICK","insp_carrier_state":"MA","insp_carrier_zip_code":"01077","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-22T10:01:34.000000Z","updated_at":"2025-05-23T10:04:57.000000Z","inspection_violations":[{"id":13813969,"change_date":"2025-05-19 21:40:00","inspection_id":"84714900","insp_violation_id":"266316247","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":"434554AD","created_at":"2025-05-22T10:20:21.000000Z","updated_at":"2025-05-23T10:24:43.000000Z","normalized_code":"39216D"},{"id":13813970,"change_date":"2025-05-19 21:40:00","inspection_id":"84714900","insp_violation_id":"266316248","seq_no":"2","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"206939752","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-22T10:20:21.000000Z","updated_at":"2025-05-23T10:24:43.000000Z","normalized_code":"39360D"}],"inspection_per_units":[{"id":14172738,"change_date":"2025-05-19 21:40:00","inspection_id":"84714900","insp_unit_id":"206939752","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"14","insp_unit_license":"1AJ49K","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1NKWX4TX8NR469604","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-22T09:46:03.000000Z","updated_at":"2025-05-23T09:49:59.000000Z"}]},{"id":8642692,"change_date":"2025-05-15 21:43:00","inspection_id":"84680393","dot_number":"759785","report_state":"MA","report_number":"CW00003793","insp_date":"2025-05-14 00:00:00","insp_start_time":"1644","insp_end_time":"1705","registration_date":null,"region":"ET","ci_status_code":"C","location":"284S","location_desc":"S-RUSSELL","county_code_state":"MA","county_code":"013","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"N\/A","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":"N","pen_cen_match":null,"final_status_date":"2025-05-15 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"30400","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"517714","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":"00759785","upload_search_indicator":"M","census_search_date":"2025-05-15 21:43:00","snet_input_date":"2025-05-14 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-05-15 21:43:00","insp_carrier_name":"CRESTVIEW CONSTRUCTION & TRUCKING INC","insp_carrier_street":"25 INDUSTRIAL RD","insp_carrier_city":"SOUTHWICK","insp_carrier_state":"MA","insp_carrier_zip_code":"01077","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-18T10:04:14.000000Z","updated_at":"2025-05-19T10:05:16.000000Z","inspection_violations":[{"id":13748941,"change_date":"2025-05-15 21:43:00","inspection_id":"84680393","insp_violation_id":"266244971","seq_no":"1","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"206877671","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-18T10:30:33.000000Z","updated_at":"2025-05-19T10:26:19.000000Z","normalized_code":"39021TB2DOT"},{"id":13748942,"change_date":"2025-05-15 21:43:00","inspection_id":"84680393","insp_violation_id":"266244972","seq_no":"2","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"206877672","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-18T10:30:33.000000Z","updated_at":"2025-05-19T10:26:19.000000Z","normalized_code":"39617CPI"},{"id":13748943,"change_date":"2025-05-15 21:43:00","inspection_id":"84680393","insp_violation_id":"266244973","seq_no":"3","part_no":"393","part_no_section":"43DBMA","insp_viol_unit":"2","insp_unit_id":"206877672","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-18T10:30:33.000000Z","updated_at":"2025-05-19T10:26:19.000000Z","normalized_code":"39343DBMA"}],"inspection_per_units":[{"id":14114748,"change_date":"2025-05-15 21:43:00","inspection_id":"84680393","insp_unit_id":"206877672","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FLNG","insp_unit_company":null,"insp_unit_license":"TZ43390","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"5FTCE2625R1015240","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-18T09:50:07.000000Z","updated_at":"2025-05-19T09:50:56.000000Z"},{"id":14114747,"change_date":"2025-05-15 21:43:00","inspection_id":"84680393","insp_unit_id":"206877671","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"W47551","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1GT49SEY2MF242213","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-18T09:50:07.000000Z","updated_at":"2025-05-19T09:50:56.000000Z"}]},{"id":8201232,"change_date":"2025-03-25 21:35:00","inspection_id":"84215591","dot_number":"759785","report_state":"CT","report_number":"3063007012","insp_date":"2025-03-24 00:00:00","insp_start_time":"0632","insp_end_time":"0649","registration_date":null,"region":"ET","ci_status_code":"C","location":"049","location_desc":"ENFIELD","county_code_state":"CT","county_code":"003","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":"2025-03-25 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"735718","transaction_code":"A","transaction_date":"2025-03-24 00:00:00","upload_date":"2025-03-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00759785","upload_search_indicator":null,"census_search_date":"2025-03-25 21:35:00","snet_input_date":"2025-03-24 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-03-25 21:35:00","insp_carrier_name":"CRESTVIEW CONSTRUCTION & TRUCKING INC","insp_carrier_street":"25 INDUSTRIAL RD","insp_carrier_city":"SOUTHWICK","insp_carrier_state":"MA","insp_carrier_zip_code":"01077","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-28T10:14:51.000000Z","updated_at":"2025-03-29T10:19:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13259555,"change_date":"2025-03-25 21:35:00","inspection_id":"84215591","insp_unit_id":"205971455","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"1AG97Z","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1NKWX4TX1SR131957","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-28T10:05:13.000000Z","updated_at":"2025-03-29T09:58:16.000000Z"}]},{"id":7408353,"change_date":"2024-12-13 21:40:00","inspection_id":"83382461","dot_number":"759785","report_state":"CT","report_number":"3014004377","insp_date":"2024-12-13 00:00:00","insp_start_time":"1306","insp_end_time":"1414","registration_date":null,"region":"ET","ci_status_code":"C","location":"155","location_desc":"WEST HARTFORD","county_code_state":"CT","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"DELTA GRAVEL","shipping_paper_number":"571525","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-12-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14","viol_total":"3","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"726587","transaction_code":"A","transaction_date":"2024-12-13 00:00:00","upload_date":"2024-12-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00759785","upload_search_indicator":null,"census_search_date":"2024-12-13 21:40:00","snet_input_date":"2024-12-13 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-12-13 21:40:00","insp_carrier_name":"CRESTVIEW CONSTRUCTION & TRUCKING INC","insp_carrier_street":"25 INDUSTRIAL RD","insp_carrier_city":"SOUTHWICK","insp_carrier_state":"MA","insp_carrier_zip_code":"01077","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:50:45.000000Z","updated_at":"2025-03-17T20:50:45.000000Z","inspection_violations":[{"id":11575799,"change_date":"2024-12-13 21:40:00","inspection_id":"83382461","insp_violation_id":"263438759","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:02:20.000000Z","updated_at":"2025-03-17T22:02:20.000000Z","normalized_code":"3922SLLLR"},{"id":11575800,"change_date":"2024-12-13 21:40:00","inspection_id":"83382461","insp_violation_id":"263438760","seq_no":"2","part_no":"392","part_no_section":"2-SLLS3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V131461-3","created_at":"2025-03-17T22:02:20.000000Z","updated_at":"2025-03-17T22:02:20.000000Z","normalized_code":"3922SLLS3"},{"id":11575801,"change_date":"2024-12-13 21:40:00","inspection_id":"83382461","insp_violation_id":"263438761","seq_no":"3","part_no":"392","part_no_section":"2-SLLEWG1","insp_viol_unit":"1","insp_unit_id":"204362469","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V131460-2","created_at":"2025-03-17T22:02:20.000000Z","updated_at":"2025-03-17T22:02:20.000000Z","normalized_code":"3922SLLEWG1"}],"inspection_per_units":[{"id":11951202,"change_date":"2024-12-13 21:40:00","inspection_id":"83382461","insp_unit_id":"204362469","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"76500","insp_unit_license":"1AJ49K","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1NKWX4TX8NR469604","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:57.000000Z","updated_at":"2025-03-17T23:46:57.000000Z"}]},{"id":7355023,"change_date":"2024-12-16 21:39:00","inspection_id":"83326509","dot_number":"759785","report_state":"MA","report_number":"DE00000505","insp_date":"2024-12-06 00:00:00","insp_start_time":"1055","insp_end_time":"1105","registration_date":"2024-12-16 00:00:00","region":"ET","ci_status_code":"C","location":"167H","location_desc":"H-LEE","county_code_state":"MA","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":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-06 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","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":"504869","transaction_code":"C","transaction_date":"2024-12-06 00:00:00","upload_date":"2024-12-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00759785","upload_search_indicator":"M","census_search_date":"2024-12-06 21:43:00","snet_input_date":"2024-12-06 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-12-06 21:43:00","insp_carrier_name":"CRESTVIEW CONSTRUCTION & TRUCKING INC","insp_carrier_street":"25 INDUSTRIAL RD","insp_carrier_city":"SOUTHWICK","insp_carrier_state":"MA","insp_carrier_zip_code":"01077","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:49:25.000000Z","updated_at":"2025-03-17T20:49:25.000000Z","inspection_violations":[{"id":11495296,"change_date":"2024-12-16 21:39:00","inspection_id":"83326509","insp_violation_id":"263485116","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:56.000000Z","updated_at":"2025-03-17T22:01:56.000000Z","normalized_code":"39617CPI"},{"id":11495297,"change_date":"2024-12-16 21:39:00","inspection_id":"83326509","insp_violation_id":"263485117","seq_no":"2","part_no":"391","part_no_section":"41A-MCPC","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-17T22:01:56.000000Z","updated_at":"2025-03-17T22:01:56.000000Z","normalized_code":"39141AMCPC"}],"inspection_per_units":[{"id":11864589,"change_date":"2024-12-16 21:39:00","inspection_id":"83326509","insp_unit_id":"204402477","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"W10486","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FDXF46P45EC23723","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:58.000000Z","updated_at":"2025-03-17T23:45:58.000000Z"}]},{"id":7153174,"change_date":"2024-11-08 21:40:00","inspection_id":"83113193","dot_number":"759785","report_state":"MA","report_number":"DR00001202","insp_date":"2024-11-08 00:00:00","insp_start_time":"1000","insp_end_time":"1010","registration_date":null,"region":"ET","ci_status_code":"C","location":"236H","location_desc":"H-NORTHAMPTON","county_code_state":"MA","county_code":"015","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"NA","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"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-11-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"78000","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":"503170","transaction_code":"A","transaction_date":"2024-11-08 00:00:00","upload_date":"2024-11-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00759785","upload_search_indicator":"M","census_search_date":"2024-11-08 21:40:00","snet_input_date":"2024-11-08 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-11-08 21:40:00","insp_carrier_name":"CRESTVIEW CONSTRUCTION & TRUCKING INC","insp_carrier_street":"25 INDUSTRIAL RD","insp_carrier_city":"SOUTHWICK","insp_carrier_state":"MA","insp_carrier_zip_code":"01077","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:45:08.000000Z","updated_at":"2025-03-17T20:45:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11537349,"change_date":"2024-11-08 21:40:00","inspection_id":"83113193","insp_unit_id":"203799399","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"11","insp_unit_license":"1AJ85H","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1NKWX4TX8KJ245131","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:33.000000Z","updated_at":"2025-03-17T23:42:33.000000Z"}]},{"id":6755541,"change_date":"2024-09-18 21:42:00","inspection_id":"82690562","dot_number":"759785","report_state":"MA","report_number":"DR00001114","insp_date":"2024-09-18 00:00:00","insp_start_time":"1327","insp_end_time":"1341","registration_date":null,"region":"ET","ci_status_code":"C","location":"006H","location_desc":"H-AGAWAM","county_code_state":"MA","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"ROSATI","shipping_paper_number":"63997","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-09-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"499933","transaction_code":"A","transaction_date":"2024-09-18 00:00:00","upload_date":"2024-09-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00759785","upload_search_indicator":null,"census_search_date":"2024-09-18 21:42:00","snet_input_date":"2024-09-18 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-09-18 21:42:00","insp_carrier_name":"CRESTVIEW CONSTRUCTION & TRUCKING INC","insp_carrier_street":"25 INDUSTRIAL RD","insp_carrier_city":"SOUTHWICK","insp_carrier_state":"MA","insp_carrier_zip_code":"01077","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:36:58.000000Z","updated_at":"2025-03-17T20:36:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10893549,"change_date":"2024-09-18 21:42:00","inspection_id":"82690562","insp_unit_id":"203001109","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"10","insp_unit_license":"4298B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1NPXX4EX4MD736521","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:49.000000Z","updated_at":"2025-03-17T23:35:49.000000Z"}]},{"id":6383700,"change_date":"2024-08-05 21:41:00","inspection_id":"82294399","dot_number":"759785","report_state":"CT","report_number":"3010003532","insp_date":"2024-08-05 00:00:00","insp_start_time":"1221","insp_end_time":"1326","registration_date":null,"region":"ET","ci_status_code":"C","location":"164","location_desc":"WINDSOR","county_code_state":"CT","county_code":"003","insp_level_id":"2","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"86001","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":"714602","transaction_code":"A","transaction_date":"2024-08-05 00:00:00","upload_date":"2024-08-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00759785","upload_search_indicator":null,"census_search_date":"2024-08-05 21:41:00","snet_input_date":"2024-08-05 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-08-05 21:41:00","insp_carrier_name":"CRESTVIEW CONSTRUCTION & TRUCKING INC","insp_carrier_street":"25 INDUSTRIAL RD","insp_carrier_city":"SOUTHWICK","insp_carrier_state":"MA","insp_carrier_zip_code":"01077","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:29:28.000000Z","updated_at":"2025-03-17T20:29:28.000000Z","inspection_violations":[{"id":9908083,"change_date":"2024-08-05 21:41:00","inspection_id":"82294399","insp_violation_id":"260996514","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202221202","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V129266-6","created_at":"2025-03-17T21:53:55.000000Z","updated_at":"2025-03-17T21:53:55.000000Z","normalized_code":"3922"},{"id":9908084,"change_date":"2024-08-05 21:41:00","inspection_id":"82294399","insp_violation_id":"260996515","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202221202","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V129266-6","created_at":"2025-03-17T21:53:55.000000Z","updated_at":"2025-03-17T21:53:55.000000Z","normalized_code":"3922"},{"id":9908085,"change_date":"2024-08-05 21:41:00","inspection_id":"82294399","insp_violation_id":"260996516","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202221202","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V129266-6","created_at":"2025-03-17T21:53:55.000000Z","updated_at":"2025-03-17T21:53:55.000000Z","normalized_code":"3922"},{"id":9908086,"change_date":"2024-08-05 21:41:00","inspection_id":"82294399","insp_violation_id":"260996517","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202221202","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V129266-6","created_at":"2025-03-17T21:53:55.000000Z","updated_at":"2025-03-17T21:53:55.000000Z","normalized_code":"3922"},{"id":9908087,"change_date":"2024-08-05 21:41:00","inspection_id":"82294399","insp_violation_id":"260996518","seq_no":"5","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"202221202","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:55.000000Z","updated_at":"2025-03-17T21:53:55.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":10287542,"change_date":"2024-08-05 21:41:00","inspection_id":"82294399","insp_unit_id":"202221202","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"7","insp_unit_license":"3319B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1NKDX4TX4LR400123","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:33.000000Z","updated_at":"2025-03-17T23:29:33.000000Z"}]},{"id":6257670,"change_date":"2024-07-19 21:37:00","inspection_id":"82159438","dot_number":"759785","report_state":"CT","report_number":"3019005559","insp_date":"2024-07-19 00:00:00","insp_start_time":"1325","insp_end_time":"1341","registration_date":null,"region":"ET","ci_status_code":"C","location":"052","location_desc":"FARMINGTON","county_code_state":"CT","county_code":"003","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":"2024-07-19 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"73000","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":"713289","transaction_code":"A","transaction_date":"2024-07-19 00:00:00","upload_date":"2024-07-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00759785","upload_search_indicator":null,"census_search_date":"2024-07-19 21:37:00","snet_input_date":"2024-07-19 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-07-19 21:37:00","insp_carrier_name":"CRESTVIEW CONSTRUCTION & TRUCKING INC","insp_carrier_street":"25 INDUSTRIAL RD","insp_carrier_city":"SOUTHWICK","insp_carrier_state":"MA","insp_carrier_zip_code":"01077","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:26:40.000000Z","updated_at":"2025-03-17T20:26:40.000000Z","inspection_violations":[{"id":9719591,"change_date":"2024-07-19 21:37:00","inspection_id":"82159438","insp_violation_id":"260726933","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V129018-3","created_at":"2025-03-17T21:53:00.000000Z","updated_at":"2025-03-17T21:53:00.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":10082244,"change_date":"2024-07-19 21:37:00","inspection_id":"82159438","insp_unit_id":"201963797","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"1AD34G","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1NK1X4TX3NJ495875","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:29.000000Z","updated_at":"2025-03-17T23:27:29.000000Z"}]},{"id":5804230,"change_date":"2024-06-04 21:42:00","inspection_id":"81669720","dot_number":"759785","report_state":"MA","report_number":"CV00003019","insp_date":"2024-05-21 00:00:00","insp_start_time":"0728","insp_end_time":"0949","registration_date":"2024-06-04 00:00:00","region":"ET","ci_status_code":"C","location":"071H","location_desc":"H-CHICOPEE","county_code_state":"MA","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"DELTA SAND & GRAVEL INC.","shipping_paper_number":"55675","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-21 21:46:00","post_acc_ind":"N","gross_comb_veh_wt":"77000","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":"492049","transaction_code":"C","transaction_date":"2024-05-21 00:00:00","upload_date":"2024-06-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00759785","upload_search_indicator":"M","census_search_date":"2024-05-21 21:46:00","snet_input_date":"2024-05-21 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-05-21 21:46:00","insp_carrier_name":"CRESTVIEW CONSTRUCTION & TRUCKING INC","insp_carrier_street":"25 INDUSTRIAL RD","insp_carrier_city":"SOUTHWICK","insp_carrier_state":"MA","insp_carrier_zip_code":"01077","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:17:51.000000Z","updated_at":"2025-03-17T20:17:51.000000Z","inspection_violations":[{"id":8990903,"change_date":"2024-06-04 21:42:00","inspection_id":"81669720","insp_violation_id":"259888143","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:28.000000Z","updated_at":"2025-03-17T21:49:28.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9348212,"change_date":"2024-06-04 21:42:00","inspection_id":"81669720","insp_unit_id":"201219603","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"1AD34G","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1NK1X4TX3NJ495875","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:02.000000Z","updated_at":"2025-03-17T23:20:02.000000Z"}]},{"id":4402444,"change_date":"2023-12-12 21:41:00","inspection_id":"80138526","dot_number":"759785","report_state":"MA","report_number":"CW00002259","insp_date":"2023-11-13 00:00:00","insp_start_time":"0705","insp_end_time":"0750","registration_date":"2023-12-12 00:00:00","region":"ET","ci_status_code":"C","location":"374H","location_desc":"H-WHATLEY","county_code_state":"MA","county_code":"011","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"DELTA","shipping_paper_number":"SLIP #544927","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-11-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","viol_total":"3","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"478504","transaction_code":"C","transaction_date":"2023-11-13 00:00:00","upload_date":"2023-12-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00759785","upload_search_indicator":"M","census_search_date":"2023-11-13 21:40:00","snet_input_date":"2023-11-13 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-11-13 21:40:00","insp_carrier_name":"CRESTVIEW CONSTRUCTION & TRUCKING INC","insp_carrier_street":"25 INDUSTRIAL RD","insp_carrier_city":"SOUTHWICK","insp_carrier_state":"MA","insp_carrier_zip_code":"01077","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:50:15.000000Z","updated_at":"2025-03-17T19:50:15.000000Z","inspection_violations":[{"id":6814508,"change_date":"2023-12-12 21:41:00","inspection_id":"80138526","insp_violation_id":"256835604","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":"280578AC","created_at":"2025-03-17T21:38:47.000000Z","updated_at":"2025-03-17T21:38:47.000000Z","normalized_code":"3922"},{"id":6814509,"change_date":"2023-12-12 21:41:00","inspection_id":"80138526","insp_violation_id":"256835605","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":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:47.000000Z","updated_at":"2025-03-17T21:38:47.000000Z","normalized_code":"39141A"},{"id":6814510,"change_date":"2023-12-12 21:41:00","inspection_id":"80138526","insp_violation_id":"256835606","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"198460675","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"280578AC","created_at":"2025-03-17T21:38:47.000000Z","updated_at":"2025-03-17T21:38:47.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":7080213,"change_date":"2023-12-12 21:41:00","inspection_id":"80138526","insp_unit_id":"198460675","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"9","insp_unit_license":"4297B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1NPXX4EX2MD736520","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:27.000000Z","updated_at":"2025-03-17T22:59:27.000000Z"}]},{"id":4278907,"change_date":"2023-10-25 21:41:00","inspection_id":"80001799","dot_number":"759785","report_state":"MA","report_number":"CW00002212","insp_date":"2023-10-25 00:00:00","insp_start_time":"0935","insp_end_time":"0955","registration_date":null,"region":"ET","ci_status_code":"C","location":"324S","location_desc":"S-SUNDERLAND","county_code_state":"MA","county_code":"011","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"SLIP #543612","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-10-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"80001","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":"477130","transaction_code":"A","transaction_date":"2023-10-25 00:00:00","upload_date":"2023-10-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00759785","upload_search_indicator":"M","census_search_date":"2023-10-25 21:41:00","snet_input_date":"2023-10-25 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-10-25 21:41:00","insp_carrier_name":"CRESTVIEW CONSTRUCTION & TRUCKING INC","insp_carrier_street":"25 INDUSTRIAL RD","insp_carrier_city":"SOUTHWICK","insp_carrier_state":"MA","insp_carrier_zip_code":"01077-9231","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:47:30.000000Z","updated_at":"2025-03-17T19:47:30.000000Z","inspection_violations":[{"id":6619167,"change_date":"2023-10-25 21:41:00","inspection_id":"80001799","insp_violation_id":"256029050","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:51.000000Z","updated_at":"2025-03-17T21:37:51.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":6881823,"change_date":"2023-10-25 21:41:00","inspection_id":"80001799","insp_unit_id":"197734166","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"3319B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1NKDX4TX4LR400123","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:42.000000Z","updated_at":"2025-03-17T22:57:42.000000Z"}]},{"id":4223096,"change_date":"2023-10-18 21:40:00","inspection_id":"79939992","dot_number":"759785","report_state":"MA","report_number":"CX00000507","insp_date":"2023-10-18 00:00:00","insp_start_time":"1133","insp_end_time":"1146","registration_date":null,"region":"ET","ci_status_code":"C","location":"036H","location_desc":"BLANDFORD","county_code_state":"MA","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"VICTORIA TRUCKING","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-10-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"86001","viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"476614","transaction_code":"A","transaction_date":"2023-10-18 00:00:00","upload_date":"2023-10-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00759785","upload_search_indicator":"M","census_search_date":"2023-10-18 21:40:00","snet_input_date":"2023-10-18 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-10-18 21:40:00","insp_carrier_name":"CRESTVIEW CONSTRUCTION & TRUCKING INC","insp_carrier_street":"25 INDUSTRIAL RD","insp_carrier_city":"SOUTHWICK","insp_carrier_state":"MA","insp_carrier_zip_code":"01077-9231","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:46:35.000000Z","updated_at":"2025-03-17T19:46:35.000000Z","inspection_violations":[{"id":6538714,"change_date":"2023-10-18 21:40:00","inspection_id":"79939992","insp_violation_id":"255899306","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:29.000000Z","updated_at":"2025-03-17T21:37:29.000000Z","normalized_code":"39216A"},{"id":6538715,"change_date":"2023-10-18 21:40:00","inspection_id":"79939992","insp_violation_id":"255899307","seq_no":"2","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:29.000000Z","updated_at":"2025-03-17T21:37:29.000000Z","normalized_code":"38323A2"}],"inspection_per_units":[{"id":6791632,"change_date":"2023-10-18 21:40:00","inspection_id":"79939992","insp_unit_id":"197612449","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"3319B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1NKDX4TX4LR400123","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:56.000000Z","updated_at":"2025-03-17T22:56:56.000000Z"}]},{"id":3658703,"change_date":"2023-08-03 21:40:00","inspection_id":"79311969","dot_number":"759785","report_state":"CT","report_number":"0558000718","insp_date":"2023-08-03 00:00:00","insp_start_time":"0743","insp_end_time":"0758","registration_date":null,"region":"ET","ci_status_code":"C","location":"155","location_desc":"WEST HARTFORD","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CRESTVIEW CONSTRUCTION","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-08-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"682346","transaction_code":"A","transaction_date":"2023-08-03 00:00:00","upload_date":"2023-08-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00759785","upload_search_indicator":null,"census_search_date":"2023-08-03 21:40:00","snet_input_date":"2023-08-03 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-08-03 21:40:00","insp_carrier_name":"CRESTVIEW CONSTRUCTION & TRUCKING INC","insp_carrier_street":"25 INDUSTRIAL RD","insp_carrier_city":"SOUTHWICK","insp_carrier_state":"MA","insp_carrier_zip_code":"01077","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:59.000000Z","updated_at":"2025-03-17T19:34:59.000000Z","inspection_violations":[{"id":5640371,"change_date":"2023-08-03 21:40:00","inspection_id":"79311969","insp_violation_id":"254436014","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:10.000000Z","updated_at":"2025-03-17T21:33:10.000000Z","normalized_code":"3922"},{"id":5640372,"change_date":"2023-08-03 21:40:00","inspection_id":"79311969","insp_violation_id":"254436015","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"Z399445-3","created_at":"2025-03-17T21:33:10.000000Z","updated_at":"2025-03-17T21:33:10.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5882933,"change_date":"2023-08-03 21:40:00","inspection_id":"79311969","insp_unit_id":"196337662","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"4298B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1NPXX4EX4MD736521","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:27.000000Z","updated_at":"2025-03-17T22:49:27.000000Z"}]},{"id":3562285,"change_date":"2023-07-21 21:40:00","inspection_id":"79203932","dot_number":"759785","report_state":"CT","report_number":"3129004133","insp_date":"2023-07-21 00:00:00","insp_start_time":"0810","insp_end_time":"0835","registration_date":null,"region":"ET","ci_status_code":"C","location":"052","location_desc":"FARMINGTON","county_code_state":"CT","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"681257","transaction_code":"A","transaction_date":"2023-07-21 00:00:00","upload_date":"2023-07-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00759785","upload_search_indicator":null,"census_search_date":"2023-07-21 21:40:00","snet_input_date":"2023-07-21 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-07-21 21:40:00","insp_carrier_name":"CRESTVIEW CONSTRUCTION & TRUCKING INC","insp_carrier_street":"25 INDUSTRIAL RD","insp_carrier_city":"SOUTHWICK","insp_carrier_state":"MA","insp_carrier_zip_code":"01077","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:33:30.000000Z","updated_at":"2025-03-17T19:33:30.000000Z","inspection_violations":[{"id":5492978,"change_date":"2023-07-21 21:40:00","inspection_id":"79203932","insp_violation_id":"254194554","seq_no":"1","part_no":"391","part_no_section":"45(b)","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:32:29.000000Z","updated_at":"2025-03-17T21:32:29.000000Z","normalized_code":"39145B"}],"inspection_per_units":[{"id":5728182,"change_date":"2023-07-21 21:40:00","inspection_id":"79203932","insp_unit_id":"196119701","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"9","insp_unit_license":"4297B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1NPXX4EX2MD736520","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:12.000000Z","updated_at":"2025-03-17T22:48:12.000000Z"}]},{"id":2262290,"change_date":"2023-01-31 21:42:00","inspection_id":"77731929","dot_number":"759785","report_state":"MA","report_number":"CW00001290","insp_date":"2023-01-30 00:00:00","insp_start_time":"1340","insp_end_time":"1400","registration_date":null,"region":"ET","ci_status_code":"C","location":"324S","location_desc":"S-SUNDERLAND","county_code_state":"MA","county_code":"011","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","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":"2023-01-31 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"459579","transaction_code":"A","transaction_date":"2023-01-31 00:00:00","upload_date":"2023-01-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00759785","upload_search_indicator":"M","census_search_date":"2023-01-31 21:42:00","snet_input_date":"2023-01-30 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-01-31 21:42:00","insp_carrier_name":"CRESTVIEW CONSTRUCTION & TRUCKING INC","insp_carrier_street":"25 INDUSTRIAL RD","insp_carrier_city":"SOUTHWICK","insp_carrier_state":"MA","insp_carrier_zip_code":"01077-9231","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:27.000000Z","updated_at":"2025-03-17T19:08:27.000000Z","inspection_violations":[{"id":3491595,"change_date":"2023-01-31 21:42:00","inspection_id":"77731929","insp_violation_id":"250861011","seq_no":"1","part_no":"393","part_no_section":"60(b)","insp_viol_unit":"1","insp_unit_id":"193143990","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:29.000000Z","updated_at":"2025-03-17T21:23:29.000000Z","normalized_code":"39360B"}],"inspection_per_units":[{"id":3641470,"change_date":"2023-01-31 21:42:00","inspection_id":"77731929","insp_unit_id":"193143990","insp_unit_type_id":"6","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"9","insp_unit_license":"4297B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1NPXX4EX2MD736520","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:06.000000Z","updated_at":"2025-03-17T22:32:06.000000Z"}]},{"id":1210887,"change_date":"2022-09-06 21:41:00","inspection_id":"76523219","dot_number":"759785","report_state":"MA","report_number":"CE00005884","insp_date":"2022-09-02 00:00:00","insp_start_time":"1105","insp_end_time":"1202","registration_date":null,"region":"ET","ci_status_code":"C","location":"071S","location_desc":"S-CHICOPEE","county_code_state":"MA","county_code":"013","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-06 21:41:00","post_acc_ind":"Y","gross_comb_veh_wt":"77000","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":"451432","transaction_code":"A","transaction_date":"2022-09-06 00:00:00","upload_date":"2022-09-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00759785","upload_search_indicator":"M","census_search_date":"2022-09-06 21:41:00","snet_input_date":"2022-09-02 00:00:00","source_office":"1MAS001","mcmis_add_date":"2022-09-06 21:41:00","insp_carrier_name":"CRESTVIEW CONSTRUCTION & TRUCKING INC","insp_carrier_street":"25 INDUSTRIAL RD","insp_carrier_city":"SOUTHWICK","insp_carrier_state":"MA","insp_carrier_zip_code":"01077-9231","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:48:59.000000Z","updated_at":"2025-03-17T18:48:59.000000Z","inspection_violations":[{"id":1919945,"change_date":"2022-09-06 21:41:00","inspection_id":"76523219","insp_violation_id":"248210965","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"190720712","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:50.000000Z","updated_at":"2025-03-17T21:15:50.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":1947608,"change_date":"2022-09-06 21:41:00","inspection_id":"76523219","insp_unit_id":"190720712","insp_unit_type_id":"6","insp_unit_number":"1","insp_unit_make":"KWMH","insp_unit_company":"7","insp_unit_license":"3319B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1NKDX4TX4LR400123","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:23.000000Z","updated_at":"2025-03-17T22:20:23.000000Z"}]},{"id":1031184,"change_date":"2022-08-15 21:37:00","inspection_id":"76313811","dot_number":"759785","report_state":"CT","report_number":"3019003791","insp_date":"2022-08-09 00:00:00","insp_start_time":"0748","insp_end_time":"0757","registration_date":null,"region":"ET","ci_status_code":"C","location":"049","location_desc":"ENFIELD","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"DELTA SAND","shipping_paper_number":"506469","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-15 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"76500","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":"650954","transaction_code":"A","transaction_date":"2022-08-09 00:00:00","upload_date":"2022-08-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00759785","upload_search_indicator":null,"census_search_date":"2022-08-15 21:37:00","snet_input_date":"2022-08-09 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-08-15 21:37:00","insp_carrier_name":"CRESTVIEW CONSTRUCTION & TRUCKING INC","insp_carrier_street":"25 INDUSTRIAL RD","insp_carrier_city":"SOUTHWICK","insp_carrier_state":"MA","insp_carrier_zip_code":"01077","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:45:49.000000Z","updated_at":"2025-03-17T18:45:49.000000Z","inspection_violations":[{"id":1624727,"change_date":"2022-08-15 21:37:00","inspection_id":"76313811","insp_violation_id":"247697465","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:14:38.000000Z","updated_at":"2025-03-17T21:14:38.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":1659666,"change_date":"2022-08-15 21:37:00","inspection_id":"76313811","insp_unit_id":"190295045","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"4298B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1NPXX4EX4MD736521","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:27.000000Z","updated_at":"2025-03-17T22:18:27.000000Z"}]},{"id":869835,"change_date":"2022-07-22 21:39:00","inspection_id":"76125163","dot_number":"759785","report_state":"MA","report_number":"CL00002838","insp_date":"2022-07-21 00:00:00","insp_start_time":"1332","insp_end_time":"1430","registration_date":null,"region":"ET","ci_status_code":"C","location":"071H","location_desc":"H-CHICOPEE","county_code_state":"MA","county_code":"013","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-22 21:39:00","post_acc_ind":"Y","gross_comb_veh_wt":"80000","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":"449273","transaction_code":"A","transaction_date":"2022-07-22 00:00:00","upload_date":"2022-07-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00759785","upload_search_indicator":"M","census_search_date":"2022-07-22 21:39:00","snet_input_date":"2022-07-21 00:00:00","source_office":"1MAS001","mcmis_add_date":"2022-07-22 21:39:00","insp_carrier_name":"CRESTVIEW CONSTRUCTION & TRUCKING INC","insp_carrier_street":"25 INDUSTRIAL RD","insp_carrier_city":"SOUTHWICK","insp_carrier_state":"MA","insp_carrier_zip_code":"01077-9231","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:43:02.000000Z","updated_at":"2025-03-17T18:43:02.000000Z","inspection_violations":[{"id":1369910,"change_date":"2022-07-22 21:39:00","inspection_id":"76125163","insp_violation_id":"247246491","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:28.000000Z","updated_at":"2025-03-17T21:13:28.000000Z","normalized_code":"3922"},{"id":1369911,"change_date":"2022-07-22 21:39:00","inspection_id":"76125163","insp_violation_id":"247246492","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"41","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:28.000000Z","updated_at":"2025-03-17T21:13:28.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1400285,"change_date":"2022-07-22 21:39:00","inspection_id":"76125163","insp_unit_id":"189909129","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"4297B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1NPXX4EX2MD736520","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:48.000000Z","updated_at":"2025-03-17T22:16:48.000000Z"}]},{"id":402790,"change_date":"2022-05-18 21:43:00","inspection_id":"75573432","dot_number":"759785","report_state":"CT","report_number":"3120002948","insp_date":"2022-05-10 00:00:00","insp_start_time":"1021","insp_end_time":"1043","registration_date":"2022-05-18 00:00:00","region":"ET","ci_status_code":"C","location":"049","location_desc":"ENFIELD","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CRESTVIEW CONSTRUCTION & TRUCKING 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":"2022-05-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"19000","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":"644008","transaction_code":"C","transaction_date":"2022-05-10 00:00:00","upload_date":"2022-05-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00759785","upload_search_indicator":null,"census_search_date":"2022-05-17 21:42:00","snet_input_date":"2022-05-10 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-05-17 21:42:00","insp_carrier_name":"CRESTVIEW CONSTRUCTION & TRUCKING INC","insp_carrier_street":"25 INDUSTRIAL RD","insp_carrier_city":"SOUTHWICK","insp_carrier_state":"MA","insp_carrier_zip_code":"01077","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:34:45.000000Z","updated_at":"2025-03-17T18:34:45.000000Z","inspection_violations":[{"id":629667,"change_date":"2022-05-18 21:43:00","inspection_id":"75573432","insp_violation_id":"245861783","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:09:58.000000Z","updated_at":"2025-03-17T21:09:58.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":650548,"change_date":"2022-05-18 21:43:00","inspection_id":"75573432","insp_unit_id":"188743648","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"31","insp_unit_license":"V27920","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3C7WRNAL5JG338841","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:12.000000Z","updated_at":"2025-03-17T22:12:12.000000Z"}]},{"id":141874,"change_date":"2022-04-11 21:40:00","inspection_id":"75262023","dot_number":"759785","report_state":"MA","report_number":"CW00000634","insp_date":"2022-04-11 00:00:00","insp_start_time":"0622","insp_end_time":"0630","registration_date":null,"region":"ET","ci_status_code":"C","location":"141H","location_desc":"H-HATFIELD","county_code_state":"MA","county_code":"015","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","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-04-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"444402","transaction_code":"A","transaction_date":"2022-04-11 00:00:00","upload_date":"2022-04-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00759785","upload_search_indicator":"M","census_search_date":"2022-04-11 21:40:00","snet_input_date":"2022-04-11 00:00:00","source_office":"1MAS001","mcmis_add_date":"2022-04-11 21:40:00","insp_carrier_name":"CRESTVIEW CONSTRUCTION & TRUCKING INC","insp_carrier_street":"25 INDUSTRIAL RD","insp_carrier_city":"SOUTHWICK","insp_carrier_state":"MA","insp_carrier_zip_code":"01077-9231","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:30:07.000000Z","updated_at":"2025-03-17T18:30:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":229595,"change_date":"2022-04-11 21:40:00","inspection_id":"75262023","insp_unit_id":"188071613","insp_unit_type_id":"6","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"4297B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1NPXX4EX2MD736520","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:35.000000Z","updated_at":"2025-03-17T22:09:35.000000Z"}]}],"first_page_url":"https:\/\/www.searchcarriers.com\/company\/759785\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/www.searchcarriers.com\/company\/759785\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/www.searchcarriers.com\/company\/759785\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next »","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/www.searchcarriers.com\/company\/759785\/inspections","per_page":100,"prev_page_url":null,"to":27,"total":27}