{"current_page":1,"data":[{"id":10809857,"change_date":"2026-01-20 21:39:00","inspection_id":"86836945","dot_number":"3158500","report_state":"MA","report_number":"DQ00003073","insp_date":"2026-01-17 00:00:00","insp_start_time":"0902","insp_end_time":"1004","registration_date":null,"region":"ET","ci_status_code":"C","location":"370H","location_desc":"H-WESTON","county_code_state":"MA","county_code":"017","insp_level_id":"1","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":"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":"2026-01-20 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"20000","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":"538730","transaction_code":"A","transaction_date":"2026-01-20 00:00:00","upload_date":"2026-01-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03158500","upload_search_indicator":"M","census_search_date":"2026-01-20 21:39:00","snet_input_date":"2026-01-17 00:00:00","source_office":"1MAS001","mcmis_add_date":"2026-01-20 21:39:00","insp_carrier_name":"CRANDALL AND COMPANY INC","insp_carrier_street":"20 GARDEN ST 20 GARDEN ST","insp_carrier_city":"DANVERS","insp_carrier_state":"MA","insp_carrier_zip_code":"01923-1431","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"S00000025843","created_at":"2026-01-23T10:36:14.000000Z","updated_at":"2026-01-31T10:30:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18150925,"change_date":"2026-01-20 21:39:00","inspection_id":"86836945","insp_unit_id":"211175187","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"T69","insp_unit_license":"W62534","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1GDG5C1E05F904586","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-24T10:08:17.000000Z","updated_at":"2026-01-31T10:02:48.000000Z"}]},{"id":10587167,"change_date":"2026-01-07 21:38:00","inspection_id":"86725857","dot_number":"3158500","report_state":"MA","report_number":"DS00002479","insp_date":"2026-01-06 00:00:00","insp_start_time":"1844","insp_end_time":"1900","registration_date":null,"region":"ET","ci_status_code":"C","location":"271H","location_desc":"H-READING","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":"2026-01-07 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"537802","transaction_code":"A","transaction_date":"2026-01-07 00:00:00","upload_date":"2026-01-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03158500","upload_search_indicator":"M","census_search_date":"2026-01-07 21:38:00","snet_input_date":"2026-01-06 00:00:00","source_office":"1MAS001","mcmis_add_date":"2026-01-07 21:38:00","insp_carrier_name":"CRANDALL AND COMPANY INC","insp_carrier_street":"20 GARDEN ST 20 GARDEN ST","insp_carrier_city":"DANVERS","insp_carrier_state":"MA","insp_carrier_zip_code":"01923-1431","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"S00000025843","created_at":"2026-01-10T10:34:38.000000Z","updated_at":"2026-01-18T10:31:44.000000Z","inspection_violations":[{"id":17795406,"change_date":"2026-01-07 21:38:00","inspection_id":"86725857","insp_violation_id":"271057779","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"210950100","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-10T10:38:51.000000Z","updated_at":"2026-01-18T10:31:46.000000Z","normalized_code":"3922SLLSR"},{"id":17795407,"change_date":"2026-01-07 21:38:00","inspection_id":"86725857","insp_violation_id":"271057780","seq_no":"2","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"210950100","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-10T10:38:51.000000Z","updated_at":"2026-01-18T10:31:46.000000Z","normalized_code":"3922SLLUCR"}],"inspection_per_units":[{"id":17746627,"change_date":"2026-01-07 21:38:00","inspection_id":"86725857","insp_unit_id":"210950100","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"W83203","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1GDG5C1G86F903382","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-10T10:06:07.000000Z","updated_at":"2026-01-18T10:01:06.000000Z"}]},{"id":8908571,"change_date":"2025-06-16 21:39:00","inspection_id":"84962018","dot_number":"3158500","report_state":"NH","report_number":"1094004848","insp_date":"2025-06-13 00:00:00","insp_start_time":"0707","insp_end_time":"0739","registration_date":null,"region":"ET","ci_status_code":"C","location":"034","location_desc":"NORTH CONWAY","county_code_state":"NH","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"OWNER'S PROPERT","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"29500","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":"285899","transaction_code":"A","transaction_date":"2025-06-13 00:00:00","upload_date":"2025-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03158500","upload_search_indicator":null,"census_search_date":"2025-06-16 21:39:00","snet_input_date":"2025-06-13 00:00:00","source_office":"1NHS001","mcmis_add_date":"2025-06-16 21:39:00","insp_carrier_name":"CRANDALL AND COMPANY INC","insp_carrier_street":"20 GARDEN ST 20 GARDEN ST","insp_carrier_city":"DANVERS","insp_carrier_state":"MA","insp_carrier_zip_code":"01923","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-19T10:00:21.000000Z","updated_at":"2025-06-20T10:00:19.000000Z","inspection_violations":[{"id":14285904,"change_date":"2025-06-16 21:39:00","inspection_id":"84962018","insp_violation_id":"266863278","seq_no":"1","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"207403763","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-19T10:15:31.000000Z","updated_at":"2025-06-20T10:15:39.000000Z","normalized_code":"39395A4EEUS"},{"id":14285905,"change_date":"2025-06-16 21:39:00","inspection_id":"84962018","insp_violation_id":"266863279","seq_no":"2","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"207403764","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-19T10:15:31.000000Z","updated_at":"2025-06-20T10:15:39.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":14596267,"change_date":"2025-06-16 21:39:00","inspection_id":"84962018","insp_unit_id":"207403763","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"T60","insp_unit_license":"V64992","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FD0X5HT5KEG28600","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-19T09:45:20.000000Z","updated_at":"2025-06-20T09:45:25.000000Z"},{"id":14596268,"change_date":"2025-06-16 21:39:00","inspection_id":"84962018","insp_unit_id":"207403764","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"KAUF","insp_unit_company":null,"insp_unit_license":"F34496","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"5VGFD2022ML008330","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-19T09:45:20.000000Z","updated_at":"2025-06-20T09:45:25.000000Z"}]},{"id":6058290,"change_date":"2024-06-24 21:42:00","inspection_id":"81945409","dot_number":"3158500","report_state":"NH","report_number":"1292002021","insp_date":"2024-06-20 00:00:00","insp_start_time":"0659","insp_end_time":"0715","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WAKEFIELD","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":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-06-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"29500","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":"276030","transaction_code":"A","transaction_date":"2024-06-20 00:00:00","upload_date":"2024-06-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03158500","upload_search_indicator":null,"census_search_date":"2024-06-24 21:42:00","snet_input_date":"2024-06-20 00:00:00","source_office":"1NHS001","mcmis_add_date":"2024-06-24 21:42:00","insp_carrier_name":"CRANDALL AND COMPANY INC","insp_carrier_street":"20 GARDEN ST 20 GARDEN ST","insp_carrier_city":"DANVERS","insp_carrier_state":"MA","insp_carrier_zip_code":"01923","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:22:40.000000Z","updated_at":"2025-03-17T20:22:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9757731,"change_date":"2024-06-24 21:42:00","inspection_id":"81945409","insp_unit_id":"201551382","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"V50621","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FDUF5HT2KEG28669","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:04.000000Z","updated_at":"2025-03-17T23:24:04.000000Z"},{"id":9757732,"change_date":"2024-06-24 21:42:00","inspection_id":"81945409","insp_unit_id":"201551383","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KAUF","insp_unit_company":null,"insp_unit_license":"TZ88221","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"5VGFD2021PL002586","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:04.000000Z","updated_at":"2025-03-17T23:24:04.000000Z"}]},{"id":5728409,"change_date":"2024-05-13 21:41:00","inspection_id":"81587682","dot_number":"3158500","report_state":"MA","report_number":"CD00007377","insp_date":"2024-05-07 00:00:00","insp_start_time":"0531","insp_end_time":"0552","registration_date":null,"region":"ET","ci_status_code":"C","location":"253H","location_desc":"H-PEABODY","county_code_state":"MA","county_code":"009","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-05-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"64500","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":"491346","transaction_code":"A","transaction_date":"2024-05-13 00:00:00","upload_date":"2024-05-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03158500","upload_search_indicator":"M","census_search_date":"2024-05-13 21:41:00","snet_input_date":"2024-05-07 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-05-13 21:41:00","insp_carrier_name":"CRANDALL AND COMPANY INC","insp_carrier_street":"20 GARDEN ST 20 GARDEN ST","insp_carrier_city":"DANVERS","insp_carrier_state":"MA","insp_carrier_zip_code":"01923-1431","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"S00000025843","created_at":"2025-03-17T20:16:17.000000Z","updated_at":"2025-03-17T20:16:17.000000Z","inspection_violations":[{"id":8865759,"change_date":"2024-05-13 21:41:00","inspection_id":"81587682","insp_violation_id":"259457995","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:55.000000Z","updated_at":"2025-03-17T21:48:55.000000Z","normalized_code":"39216A"},{"id":8865760,"change_date":"2024-05-13 21:41:00","inspection_id":"81587682","insp_violation_id":"259457996","seq_no":"2","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":null,"created_at":"2025-03-17T21:48:55.000000Z","updated_at":"2025-03-17T21:48:55.000000Z","normalized_code":"39282A1"}],"inspection_per_units":[{"id":9226632,"change_date":"2024-05-13 21:41:00","inspection_id":"81587682","insp_unit_id":"200851494","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"S70274","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1HTMMAAL9CH148192","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:52.000000Z","updated_at":"2025-03-17T23:18:52.000000Z"},{"id":9226633,"change_date":"2024-05-13 21:41:00","inspection_id":"81587682","insp_unit_id":"200851495","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KAUF","insp_unit_company":null,"insp_unit_license":"TZ88220","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"5VGFH3521PL000579","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:52.000000Z","updated_at":"2025-03-17T23:18:52.000000Z"}]},{"id":4792368,"change_date":"2024-01-09 21:42:00","inspection_id":"80566127","dot_number":"3158500","report_state":"MA","report_number":"CD00007009","insp_date":"2024-01-08 00:00:00","insp_start_time":"1703","insp_end_time":"1717","registration_date":null,"region":"ET","ci_status_code":"C","location":"385H","location_desc":"H-WOBURN","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":"2024-01-09 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":"482403","transaction_code":"A","transaction_date":"2024-01-09 00:00:00","upload_date":"2024-01-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03158500","upload_search_indicator":"M","census_search_date":"2024-01-09 21:42:00","snet_input_date":"2024-01-08 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-01-09 21:42:00","insp_carrier_name":"CRANDALL AND COMPANY INC","insp_carrier_street":"20 GARDEN ST 20 GARDEN ST","insp_carrier_city":"DANVERS","insp_carrier_state":"MA","insp_carrier_zip_code":"01923-1431","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"S00000025843","created_at":"2025-03-17T19:57:40.000000Z","updated_at":"2025-03-17T19:57:40.000000Z","inspection_violations":[{"id":7394638,"change_date":"2024-01-09 21:42:00","inspection_id":"80566127","insp_violation_id":"257251931","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:41:41.000000Z","updated_at":"2025-03-17T21:41:41.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7710077,"change_date":"2024-01-09 21:42:00","inspection_id":"80566127","insp_unit_id":"198875473","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"T57548","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3HAJTSKN6CL617325","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:56.000000Z","updated_at":"2025-03-17T23:04:56.000000Z"}]},{"id":4732700,"change_date":"2023-12-29 21:40:00","inspection_id":"80500977","dot_number":"3158500","report_state":"NH","report_number":"1094004561","insp_date":"2023-12-29 00:00:00","insp_start_time":"0722","insp_end_time":"0759","registration_date":null,"region":"ET","ci_status_code":"C","location":"034","location_desc":"NORTH CONWAY","county_code_state":"NH","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"16 TYROLEAN DR","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-12-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","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":"271996","transaction_code":"A","transaction_date":"2023-12-29 00:00:00","upload_date":"2023-12-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03158500","upload_search_indicator":null,"census_search_date":"2023-12-29 21:40:00","snet_input_date":"2023-12-29 00:00:00","source_office":"1NHS001","mcmis_add_date":"2023-12-29 21:40:00","insp_carrier_name":"CRANDALL AND COMPANY INC","insp_carrier_street":"20 GARDEN ST 20 GARDEN ST","insp_carrier_city":"DANVERS","insp_carrier_state":"MA","insp_carrier_zip_code":"01923","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:56:33.000000Z","updated_at":"2025-03-17T19:56:33.000000Z","inspection_violations":[{"id":7307706,"change_date":"2023-12-29 21:40:00","inspection_id":"80500977","insp_violation_id":"257116051","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:41:17.000000Z","updated_at":"2025-03-17T21:41:17.000000Z","normalized_code":"39216A"},{"id":7307707,"change_date":"2023-12-29 21:40:00","inspection_id":"80500977","insp_violation_id":"257116052","seq_no":"2","part_no":"395","part_no_section":"8(f)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:17.000000Z","updated_at":"2025-03-17T21:41:17.000000Z","normalized_code":"3958F1"},{"id":7307708,"change_date":"2023-12-29 21:40:00","inspection_id":"80500977","insp_violation_id":"257116053","seq_no":"3","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:41:17.000000Z","updated_at":"2025-03-17T21:41:17.000000Z","normalized_code":"39141A"},{"id":7307709,"change_date":"2023-12-29 21:40:00","inspection_id":"80500977","insp_violation_id":"257116054","seq_no":"4","part_no":"393","part_no_section":"81","insp_viol_unit":"1","insp_unit_id":"198737982","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:17.000000Z","updated_at":"2025-03-17T21:41:17.000000Z","normalized_code":"39381"}],"inspection_per_units":[{"id":7612772,"change_date":"2023-12-29 21:40:00","inspection_id":"80500977","insp_unit_id":"198737982","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"T43","insp_unit_license":"T90972","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1GB3G3CG2B1160790","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:03.000000Z","updated_at":"2025-03-17T23:04:03.000000Z"}]},{"id":4347839,"change_date":"2023-11-03 21:40:00","inspection_id":"80077902","dot_number":"3158500","report_state":"MA","report_number":"CP00003624","insp_date":"2023-11-02 00:00:00","insp_start_time":"1745","insp_end_time":"1801","registration_date":null,"region":"ET","ci_status_code":"C","location":"037H","location_desc":"H-BOLTON","county_code_state":"MA","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":"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-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"20390","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":"477709","transaction_code":"A","transaction_date":"2023-11-03 00:00:00","upload_date":"2023-11-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03158500","upload_search_indicator":"M","census_search_date":"2023-11-03 21:40:00","snet_input_date":"2023-11-02 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-11-03 21:40:00","insp_carrier_name":"CRANDALL AND COMPANY INC","insp_carrier_street":"20 GARDEN ST 20 GARDEN ST","insp_carrier_city":"DANVERS","insp_carrier_state":"MA","insp_carrier_zip_code":"01923-1431","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"S00000025843","created_at":"2025-03-17T19:49:06.000000Z","updated_at":"2025-03-17T19:49:06.000000Z","inspection_violations":[{"id":6726560,"change_date":"2023-11-03 21:40:00","inspection_id":"80077902","insp_violation_id":"256203700","seq_no":"1","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:38:23.000000Z","updated_at":"2025-03-17T21:38:23.000000Z","normalized_code":"39141A"},{"id":6726561,"change_date":"2023-11-03 21:40:00","inspection_id":"80077902","insp_violation_id":"256203701","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"197891834","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:23.000000Z","updated_at":"2025-03-17T21:38:23.000000Z","normalized_code":"39617C"},{"id":6726562,"change_date":"2023-11-03 21:40:00","inspection_id":"80077902","insp_violation_id":"256203702","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"197891835","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:23.000000Z","updated_at":"2025-03-17T21:38:23.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":6992296,"change_date":"2023-11-03 21:40:00","inspection_id":"80077902","insp_unit_id":"197891834","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"T86171","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FT8X3B68KEC68916","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:42.000000Z","updated_at":"2025-03-17T22:58:42.000000Z"},{"id":6992297,"change_date":"2023-11-03 21:40:00","inspection_id":"80077902","insp_unit_id":"197891835","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KAUF","insp_unit_company":null,"insp_unit_license":"F29537","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"5VGFD2029JL002925","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:42.000000Z","updated_at":"2025-03-17T22:58:42.000000Z"}]},{"id":3048731,"change_date":"2023-05-16 21:41:00","inspection_id":"78625755","dot_number":"3158500","report_state":"MA","report_number":"CD00006282","insp_date":"2023-05-16 00:00:00","insp_start_time":"0514","insp_end_time":"0536","registration_date":null,"region":"ET","ci_status_code":"C","location":"253H","location_desc":"H-PEABODY","county_code_state":"MA","county_code":"009","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":"2023-05-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"29500","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":"465726","transaction_code":"A","transaction_date":"2023-05-16 00:00:00","upload_date":"2023-05-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03158500","upload_search_indicator":"M","census_search_date":"2023-05-16 21:41:00","snet_input_date":"2023-05-16 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-05-16 21:41:00","insp_carrier_name":"CRANDALL AND COMPANY INC","insp_carrier_street":"20 GARDEN ST 20 GARDEN ST","insp_carrier_city":"DANVERS","insp_carrier_state":"MA","insp_carrier_zip_code":"01923-1431","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"S00000025843","created_at":"2025-03-17T19:23:23.000000Z","updated_at":"2025-03-17T19:23:23.000000Z","inspection_violations":[{"id":4686036,"change_date":"2023-05-16 21:41:00","inspection_id":"78625755","insp_violation_id":"252845530","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"194940655","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:51.000000Z","updated_at":"2025-03-17T21:28:51.000000Z","normalized_code":"39311"},{"id":4686037,"change_date":"2023-05-16 21:41:00","inspection_id":"78625755","insp_violation_id":"252845531","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"194940656","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:51.000000Z","updated_at":"2025-03-17T21:28:51.000000Z","normalized_code":"39617C"},{"id":4686038,"change_date":"2023-05-16 21:41:00","inspection_id":"78625755","insp_violation_id":"252845532","seq_no":"3","part_no":"393","part_no_section":"40","insp_viol_unit":"2","insp_unit_id":"194940656","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:51.000000Z","updated_at":"2025-03-17T21:28:51.000000Z","normalized_code":"39340"}],"inspection_per_units":[{"id":4904936,"change_date":"2023-05-16 21:41:00","inspection_id":"78625755","insp_unit_id":"194940655","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"T12833","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FDUF5HTXHEC16833","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:39.000000Z","updated_at":"2025-03-17T22:41:39.000000Z"},{"id":4904937,"change_date":"2023-05-16 21:41:00","inspection_id":"78625755","insp_unit_id":"194940656","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KAUF","insp_unit_company":null,"insp_unit_license":"TZ88221","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"5VGFD2021PL002586","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:39.000000Z","updated_at":"2025-03-17T22:41:39.000000Z"}]},{"id":1244925,"change_date":"2022-09-09 21:38:00","inspection_id":"76562451","dot_number":"3158500","report_state":"MA","report_number":"CD00005481","insp_date":"2022-09-09 00:00:00","insp_start_time":"0636","insp_end_time":"0658","registration_date":null,"region":"ET","ci_status_code":"C","location":"385H","location_desc":"H-WOBURN","county_code_state":"MA","county_code":"017","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-09 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"202000","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":"451702","transaction_code":"A","transaction_date":"2022-09-09 00:00:00","upload_date":"2022-09-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03158500","upload_search_indicator":"M","census_search_date":"2022-09-09 21:38:00","snet_input_date":"2022-09-09 00:00:00","source_office":"1MAS001","mcmis_add_date":"2022-09-09 21:38:00","insp_carrier_name":"CRANDALL AND COMPANY INC","insp_carrier_street":"20 GARDEN ST 20 GARDEN ST","insp_carrier_city":"DANVERS","insp_carrier_state":"MA","insp_carrier_zip_code":"01923-1431","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"S00000025843","created_at":"2025-03-17T18:49:42.000000Z","updated_at":"2025-03-17T18:49:42.000000Z","inspection_violations":[{"id":1970846,"change_date":"2022-09-09 21:38:00","inspection_id":"76562451","insp_violation_id":"248298215","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:16:04.000000Z","updated_at":"2025-03-17T21:16:04.000000Z","normalized_code":"3922"},{"id":1970847,"change_date":"2022-09-09 21:38:00","inspection_id":"76562451","insp_violation_id":"248298216","seq_no":"2","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:16:04.000000Z","updated_at":"2025-03-17T21:16:04.000000Z","normalized_code":"39145B"},{"id":1970848,"change_date":"2022-09-09 21:38:00","inspection_id":"76562451","insp_violation_id":"248298217","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"190800525","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:04.000000Z","updated_at":"2025-03-17T21:16:04.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":2003397,"change_date":"2022-09-09 21:38:00","inspection_id":"76562451","insp_unit_id":"190800524","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"V64992","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FD0X5HT5KEG28600","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:46.000000Z","updated_at":"2025-03-17T22:20:46.000000Z"},{"id":2003398,"change_date":"2022-09-09 21:38:00","inspection_id":"76562451","insp_unit_id":"190800525","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"AMHL","insp_unit_company":null,"insp_unit_license":"E90414","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"7HB211629L1002515","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:46.000000Z","updated_at":"2025-03-17T22:20:46.000000Z"}]},{"id":1002577,"change_date":"2022-08-10 21:39:00","inspection_id":"76280358","dot_number":"3158500","report_state":"MA","report_number":"CD00005385","insp_date":"2022-08-09 00:00:00","insp_start_time":"1542","insp_end_time":"1601","registration_date":null,"region":"ET","ci_status_code":"C","location":"385H","location_desc":"H-WOBURN","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"21000","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":"450088","transaction_code":"A","transaction_date":"2022-08-10 00:00:00","upload_date":"2022-08-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03158500","upload_search_indicator":"M","census_search_date":"2022-08-10 21:39:00","snet_input_date":"2022-08-09 00:00:00","source_office":"1MAS001","mcmis_add_date":"2022-08-10 21:39:00","insp_carrier_name":"CRANDALL AND COMPANY INC","insp_carrier_street":"20 GARDEN ST 20 GARDEN ST","insp_carrier_city":"DANVERS","insp_carrier_state":"MA","insp_carrier_zip_code":"01923-1431","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"S00000025843","created_at":"2025-03-17T18:45:24.000000Z","updated_at":"2025-03-17T18:45:24.000000Z","inspection_violations":[{"id":1579279,"change_date":"2022-08-10 21:39:00","inspection_id":"76280358","insp_violation_id":"247617791","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:23.000000Z","updated_at":"2025-03-17T21:14:23.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1613059,"change_date":"2022-08-10 21:39:00","inspection_id":"76280358","insp_unit_id":"190225965","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"T68075","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FDRF3H68JEC26867","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:09.000000Z","updated_at":"2025-03-17T22:18:09.000000Z"},{"id":1613060,"change_date":"2022-08-10 21:39:00","inspection_id":"76280358","insp_unit_id":"190225966","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"AME","insp_unit_company":null,"insp_unit_license":"C58124","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"593200G25G1050914","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:09.000000Z","updated_at":"2025-03-17T22:18:09.000000Z"}]},{"id":589598,"change_date":"2022-06-13 21:41:00","inspection_id":"75795243","dot_number":"3158500","report_state":"MA","report_number":"CM00003096","insp_date":"2022-06-13 00:00:00","insp_start_time":"1030","insp_end_time":"1044","registration_date":null,"region":"ET","ci_status_code":"C","location":"370H","location_desc":"H-WESTON","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":"2022-06-13 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":"447646","transaction_code":"A","transaction_date":"2022-06-13 00:00:00","upload_date":"2022-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03158500","upload_search_indicator":"M","census_search_date":"2022-06-13 21:41:00","snet_input_date":"2022-06-13 00:00:00","source_office":"1MAS001","mcmis_add_date":"2022-06-13 21:41:00","insp_carrier_name":"CRANDALL AND COMPANY INC","insp_carrier_street":"20 GARDEN ST 20 GARDEN ST","insp_carrier_city":"DANVERS","insp_carrier_state":"MA","insp_carrier_zip_code":"01923-1431","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"S00000025843","created_at":"2025-03-17T18:38:05.000000Z","updated_at":"2025-03-17T18:38:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":947335,"change_date":"2022-06-13 21:41:00","inspection_id":"75795243","insp_unit_id":"189194450","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"S70274","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1HTMMAAL9CH148192","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:02.000000Z","updated_at":"2025-03-17T22:14:02.000000Z"}]},{"id":364609,"change_date":"2022-05-11 21:39:00","inspection_id":"75527585","dot_number":"3158500","report_state":"MA","report_number":"CM00003004","insp_date":"2022-05-11 00:00:00","insp_start_time":"1000","insp_end_time":"1016","registration_date":null,"region":"ET","ci_status_code":"C","location":"370H","location_desc":"H-WESTON","county_code_state":"MA","county_code":"017","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-05-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"445808","transaction_code":"A","transaction_date":"2022-05-11 00:00:00","upload_date":"2022-05-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03158500","upload_search_indicator":"M","census_search_date":"2022-05-11 21:39:00","snet_input_date":"2022-05-11 00:00:00","source_office":"1MAS001","mcmis_add_date":"2022-05-11 21:39:00","insp_carrier_name":"CRANDALL AND COMPANY INC","insp_carrier_street":"20 GARDEN ST 20 GARDEN ST","insp_carrier_city":"DANVERS","insp_carrier_state":"MA","insp_carrier_zip_code":"01923-1431","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"S00000025843","created_at":"2025-03-17T18:33:58.000000Z","updated_at":"2025-03-17T18:33:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":589691,"change_date":"2022-05-11 21:39:00","inspection_id":"75527585","insp_unit_id":"188620448","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"S70274","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1HTMMAAL9CH148192","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:48.000000Z","updated_at":"2025-03-17T22:11:48.000000Z"},{"id":589692,"change_date":"2022-05-11 21:39:00","inspection_id":"75527585","insp_unit_id":"188620449","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"KAUF","insp_unit_company":null,"insp_unit_license":"B69066","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"5VGFH3023DL001414","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:48.000000Z","updated_at":"2025-03-17T22:11:48.000000Z"}]},{"id":296379,"change_date":"2022-05-02 21:40:00","inspection_id":"75446683","dot_number":"3158500","report_state":"MA","report_number":"CD00005086","insp_date":"2022-05-02 00:00:00","insp_start_time":"0536","insp_end_time":"0557","registration_date":null,"region":"ET","ci_status_code":"C","location":"271H","location_desc":"H-READING","county_code_state":"MA","county_code":"017","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26500","viol_total":"4","oos_total":"1","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"445369","transaction_code":"A","transaction_date":"2022-05-02 00:00:00","upload_date":"2022-05-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03158500","upload_search_indicator":"M","census_search_date":"2022-05-02 21:40:00","snet_input_date":"2022-05-02 00:00:00","source_office":"1MAS001","mcmis_add_date":"2022-05-02 21:40:00","insp_carrier_name":"CRANDALL AND COMPANY INC","insp_carrier_street":"20 GARDEN ST 20 GARDEN ST","insp_carrier_city":"DANVERS","insp_carrier_state":"MA","insp_carrier_zip_code":"01923-1431","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"S00000025843","created_at":"2025-03-17T18:32:37.000000Z","updated_at":"2025-03-17T18:32:37.000000Z","inspection_violations":[{"id":461501,"change_date":"2022-05-02 21:40:00","inspection_id":"75446683","insp_violation_id":"245500027","seq_no":"1","part_no":"392","part_no_section":"8","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:09:15.000000Z","updated_at":"2025-03-17T21:09:15.000000Z","normalized_code":"3928"},{"id":461502,"change_date":"2022-05-02 21:40:00","inspection_id":"75446683","insp_violation_id":"245500028","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:09:15.000000Z","updated_at":"2025-03-17T21:09:15.000000Z","normalized_code":"3961"},{"id":461503,"change_date":"2022-05-02 21:40:00","inspection_id":"75446683","insp_violation_id":"245500029","seq_no":"3","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"188443724","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:15.000000Z","updated_at":"2025-03-17T21:09:15.000000Z","normalized_code":"39395A"},{"id":461504,"change_date":"2022-05-02 21:40:00","inspection_id":"75446683","insp_violation_id":"245500030","seq_no":"4","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"188443725","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:09:15.000000Z","updated_at":"2025-03-17T21:09:15.000000Z","normalized_code":"39343"}],"inspection_per_units":[{"id":479580,"change_date":"2022-05-02 21:40:00","inspection_id":"75446683","insp_unit_id":"188443724","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"T5","insp_unit_license":"S69436","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FDUF5HT3HEB62386","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:08.000000Z","updated_at":"2025-03-17T22:11:08.000000Z"},{"id":479581,"change_date":"2022-05-02 21:40:00","inspection_id":"75446683","insp_unit_id":"188443725","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"AME","insp_unit_company":null,"insp_unit_license":"C58124","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"593200G25G1050914","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:08.000000Z","updated_at":"2025-03-17T22:11:08.000000Z"}]},{"id":221115,"change_date":"2022-04-21 21:40:00","inspection_id":"75356723","dot_number":"3158500","report_state":"ME","report_number":"1494005187","insp_date":"2022-04-21 00:00:00","insp_start_time":"1256","insp_end_time":"1309","registration_date":null,"region":"ET","ci_status_code":"C","location":"000295","location_desc":"KITTERY","county_code_state":"ME","county_code":"031","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"20000","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":"344796","transaction_code":"A","transaction_date":"2022-04-21 00:00:00","upload_date":"2022-04-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03158500","upload_search_indicator":null,"census_search_date":"2022-04-21 21:40:00","snet_input_date":"2022-04-21 00:00:00","source_office":"1MES001","mcmis_add_date":"2022-04-21 21:40:00","insp_carrier_name":"CRANDALL AND COMPANY INC","insp_carrier_street":"20 GARDEN ST 20 GARDEN ST","insp_carrier_city":"DANVERS","insp_carrier_state":"MA","insp_carrier_zip_code":"01923","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:31:31.000000Z","updated_at":"2025-03-17T18:31:31.000000Z","inspection_violations":[{"id":339711,"change_date":"2022-04-21 21:40:00","inspection_id":"75356723","insp_violation_id":"245286031","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:08:38.000000Z","updated_at":"2025-03-17T21:08:38.000000Z","normalized_code":"39141A1"},{"id":339712,"change_date":"2022-04-21 21:40:00","inspection_id":"75356723","insp_violation_id":"245286032","seq_no":"2","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:08:38.000000Z","updated_at":"2025-03-17T21:08:38.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":358434,"change_date":"2022-04-21 21:40:00","inspection_id":"75356723","insp_unit_id":"188263768","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"W83203","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1GDG5C1G86F903382","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:19.000000Z","updated_at":"2025-03-17T22:10:19.000000Z"}]},{"id":221121,"change_date":"2022-04-21 21:40:00","inspection_id":"75356733","dot_number":"3158500","report_state":"ME","report_number":"1494005188","insp_date":"2022-04-21 00:00:00","insp_start_time":"1256","insp_end_time":"1313","registration_date":null,"region":"ET","ci_status_code":"C","location":"000295","location_desc":"KITTERY","county_code_state":"ME","county_code":"031","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"20000","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":"344784","transaction_code":"A","transaction_date":"2022-04-21 00:00:00","upload_date":"2022-04-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03158500","upload_search_indicator":null,"census_search_date":"2022-04-21 21:40:00","snet_input_date":"2022-04-21 00:00:00","source_office":"1MES001","mcmis_add_date":"2022-04-21 21:40:00","insp_carrier_name":"CRANDALL AND COMPANY INC","insp_carrier_street":"20 GARDEN ST 20 GARDEN ST","insp_carrier_city":"DANVERS","insp_carrier_state":"MA","insp_carrier_zip_code":"01923","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:31:31.000000Z","updated_at":"2025-03-17T18:31:31.000000Z","inspection_violations":[{"id":339713,"change_date":"2022-04-21 21:40:00","inspection_id":"75356733","insp_violation_id":"245286054","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:08:38.000000Z","updated_at":"2025-03-17T21:08:38.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":358443,"change_date":"2022-04-21 21:40:00","inspection_id":"75356733","insp_unit_id":"188263788","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"W83204","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1GDG5C1EX5F904837","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:19.000000Z","updated_at":"2025-03-17T22:10:19.000000Z"}]}],"first_page_url":"https:\/\/www.searchcarriers.com\/company\/3158500\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/www.searchcarriers.com\/company\/3158500\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/www.searchcarriers.com\/company\/3158500\/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\/3158500\/inspections","per_page":100,"prev_page_url":null,"to":16,"total":16}