{"current_page":1,"data":[{"id":11649094,"change_date":"2026-04-15 21:38:00","inspection_id":"87578579","dot_number":"328526","report_state":"CT","report_number":"3022002061","insp_date":"2026-04-15 00:00:00","insp_start_time":"1517","insp_end_time":"1530","registration_date":null,"region":"ET","ci_status_code":"C","location":"034","location_desc":"DANBURY","county_code_state":"CT","county_code":"001","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"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":"2026-04-15 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"770359","transaction_code":"A","transaction_date":"2026-04-15 00:00:00","upload_date":"2026-04-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00328526","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-04-15 00:00:00","source_office":"1CTS001","mcmis_add_date":"2026-04-15 21:38:00","insp_carrier_name":"NORBERT E MITCHELL CO INC","insp_carrier_street":"7 FEDERAL RD","insp_carrier_city":"DANBURY","insp_carrier_state":"CT","insp_carrier_zip_code":"06810","insp_colonia":null,"docket_number":"263035","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-26T09:30:09.000000Z","updated_at":"2026-04-26T09:30:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20263240,"change_date":"2026-04-15 21:38:00","inspection_id":"87578579","insp_unit_id":"213020591","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"C48","insp_unit_license":"39246A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"2NKHHJ7X0MM459945","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-26T09:02:19.000000Z","updated_at":"2026-04-26T09:02:19.000000Z"}]},{"id":11392029,"change_date":"2026-03-17 21:38:00","inspection_id":"87306592","dot_number":"328526","report_state":"CT","report_number":"3090005029","insp_date":"2026-03-17 00:00:00","insp_start_time":"0606","insp_end_time":"0620","registration_date":null,"region":"ET","ci_status_code":"C","location":"034","location_desc":"DANBURY","county_code_state":"CT","county_code":"001","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SELF","shipping_paper_number":"GENERIC","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":"2026-03-17 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"767926","transaction_code":"A","transaction_date":"2026-03-17 00:00:00","upload_date":"2026-03-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00328526","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-03-17 00:00:00","source_office":"1CTS001","mcmis_add_date":"2026-03-17 21:38:00","insp_carrier_name":"NORBERT E MITCHELL CO INC","insp_carrier_street":"7 FEDERAL RD","insp_carrier_city":"DANBURY","insp_carrier_state":"CT","insp_carrier_zip_code":"06810","insp_colonia":null,"docket_number":"263035","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-20T09:42:09.000000Z","updated_at":"2026-03-28T09:30:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19508694,"change_date":"2026-03-17 21:38:00","inspection_id":"87306592","insp_unit_id":"212168203","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"C43","insp_unit_license":"61894A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"2NKHHJ7X1JM202336","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-20T09:19:17.000000Z","updated_at":"2026-03-28T09:03:47.000000Z"}]},{"id":11230596,"change_date":"2026-03-04 21:40:00","inspection_id":"87142766","dot_number":"328526","report_state":"CT","report_number":"3082001857","insp_date":"2026-02-26 00:00:00","insp_start_time":"1653","insp_end_time":"1725","registration_date":"2026-03-04 00:00:00","region":"ET","ci_status_code":"C","location":"034S","location_desc":"DANBURY SCALE","county_code_state":"CT","county_code":"001","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CARRRIER","shipping_paper_number":"NO BOL","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":"2026-02-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"766320","transaction_code":"C","transaction_date":"2026-02-26 00:00:00","upload_date":"2026-03-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00328526","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-02-26 00:00:00","source_office":"1CTS001","mcmis_add_date":"2026-02-26 21:40:00","insp_carrier_name":"NORBERT E MITCHELL CO INC","insp_carrier_street":"7 FEDERAL RD","insp_carrier_city":"DANBURY","insp_carrier_state":"CT","insp_carrier_zip_code":"06810","insp_colonia":null,"docket_number":"263035","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-01T10:38:47.000000Z","updated_at":"2026-03-15T09:30:05.000000Z","inspection_violations":[{"id":18965815,"change_date":"2026-03-04 21:40:00","inspection_id":"87142766","insp_violation_id":"272175450","seq_no":"1","part_no":"393","part_no_section":"11A1-LFTSM","insp_viol_unit":"1","insp_unit_id":"211949914","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-07T10:57:15.000000Z","updated_at":"2026-03-15T09:40:12.000000Z","normalized_code":"39311A1LFTSM"}],"inspection_per_units":[{"id":19292105,"change_date":"2026-03-04 21:40:00","inspection_id":"87142766","insp_unit_id":"211949914","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"D22","insp_unit_license":"58072A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3BKHHJ7X9GF497314","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-07T10:15:38.000000Z","updated_at":"2026-03-15T09:03:16.000000Z"}]},{"id":11166509,"change_date":"2026-03-04 21:40:00","inspection_id":"87081980","dot_number":"328526","report_state":"CT","report_number":"0132001227","insp_date":"2026-02-19 00:00:00","insp_start_time":"1046","insp_end_time":"1109","registration_date":"2026-03-03 00:00:00","region":"ET","ci_status_code":"C","location":"057","location_desc":"GREENWICH SCALE","county_code_state":"CT","county_code":"001","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"HAZMAT","cargo_tank":"331","hazmat_placard_req":"Y","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":"2026-02-19 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"1","hazmat_oos_total":"0","snet_sequence_id":"765904","transaction_code":"C","transaction_date":"2026-02-19 00:00:00","upload_date":"2026-03-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00328526","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-02-19 00:00:00","source_office":"1CTS001","mcmis_add_date":"2026-02-19 21:39:00","insp_carrier_name":"NORBERT E MITCHELL CO INC","insp_carrier_street":"7 FEDERAL RD","insp_carrier_city":"DANBURY","insp_carrier_state":"CT","insp_carrier_zip_code":"06810","insp_colonia":null,"docket_number":"263035","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-22T10:37:42.000000Z","updated_at":"2026-03-15T09:30:48.000000Z","inspection_violations":[{"id":18964986,"change_date":"2026-03-04 21:40:00","inspection_id":"87081980","insp_violation_id":"272174976","seq_no":"1","part_no":"177","part_no_section":"840L-HMHC","insp_viol_unit":"1","insp_unit_id":"211949682","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-07T10:57:14.000000Z","updated_at":"2026-03-15T09:41:37.000000Z","normalized_code":"177840LHMHC"}],"inspection_per_units":[{"id":19291677,"change_date":"2026-03-04 21:40:00","inspection_id":"87081980","insp_unit_id":"211949682","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"D31","insp_unit_license":"74190A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FVACXFE0PHUL1056","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-07T10:15:37.000000Z","updated_at":"2026-03-15T09:03:13.000000Z"}]},{"id":11099384,"change_date":"2026-02-13 21:38:00","inspection_id":"87011312","dot_number":"328526","report_state":"CT","report_number":"3019006948","insp_date":"2026-02-11 00:00:00","insp_start_time":"0854","insp_end_time":"0924","registration_date":"2026-02-13 00:00:00","region":"ET","ci_status_code":"C","location":"034S","location_desc":"DANBURY SCALE","county_code_state":"CT","county_code":"001","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CRESTWOOD","shipping_paper_number":"43855","cargo_tank":"331","hazmat_placard_req":"Y","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":"2026-02-11 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"1","hazmat_oos_total":"0","snet_sequence_id":"765377","transaction_code":"C","transaction_date":"2026-02-11 00:00:00","upload_date":"2026-02-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00328526","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-02-11 00:00:00","source_office":"1CTS001","mcmis_add_date":"2026-02-11 21:38:00","insp_carrier_name":"NORBERT E MITCHELL CO INC","insp_carrier_street":"7 FEDERAL RD","insp_carrier_city":"DANBURY","insp_carrier_state":"CT","insp_carrier_zip_code":"06810","insp_colonia":null,"docket_number":"263035","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-14T10:37:27.000000Z","updated_at":"2026-02-24T10:30:07.000000Z","inspection_violations":[{"id":18631324,"change_date":"2026-02-13 21:38:00","inspection_id":"87011312","insp_violation_id":"271774950","seq_no":"1","part_no":"178","part_no_section":"337-9C-HMP","insp_viol_unit":"2","insp_unit_id":"211603432","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-16T10:54:10.000000Z","updated_at":"2026-02-24T10:37:55.000000Z","normalized_code":"1783379CHMP"}],"inspection_per_units":[{"id":18972588,"change_date":"2026-02-13 21:38:00","inspection_id":"87011312","insp_unit_id":"211603432","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"COUA","insp_unit_company":"G21","insp_unit_license":"AH50508","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1Z9M1AA23JA448275","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-16T10:14:55.000000Z","updated_at":"2026-02-24T10:02:10.000000Z"},{"id":18972587,"change_date":"2026-02-13 21:38:00","inspection_id":"87011312","insp_unit_id":"211603431","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"F12","insp_unit_license":"63832A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3WKDD49X8KF259046","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-16T10:14:55.000000Z","updated_at":"2026-02-24T10:02:10.000000Z"}]},{"id":10901551,"change_date":"2026-02-05 21:38:00","inspection_id":"86933027","dot_number":"328526","report_state":"CT","report_number":"3064001692","insp_date":"2026-02-02 00:00:00","insp_start_time":"0905","insp_end_time":"0949","registration_date":"2026-02-05 00:00:00","region":"ET","ci_status_code":"C","location":"034S","location_desc":"DANBURY SCALE","county_code_state":"CT","county_code":"001","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"NORBERT E MITCHELL CO INC","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":"Y","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":"2026-02-02 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"4","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"764672","transaction_code":"C","transaction_date":"2026-02-02 00:00:00","upload_date":"2026-02-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00328526","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-02-02 00:00:00","source_office":"1CTS001","mcmis_add_date":"2026-02-02 21:38:00","insp_carrier_name":"NORBERT E MITCHELL CO INC","insp_carrier_street":"7 FEDERAL RD","insp_carrier_city":"DANBURY","insp_carrier_state":"CT","insp_carrier_zip_code":"06810","insp_colonia":null,"docket_number":"263035","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-05T10:35:37.000000Z","updated_at":"2026-02-16T10:30:11.000000Z","inspection_violations":[{"id":18493383,"change_date":"2026-02-05 21:38:00","inspection_id":"86933027","insp_violation_id":"271605036","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V137747-3","created_at":"2026-02-08T10:50:17.000000Z","updated_at":"2026-02-16T10:39:01.000000Z","normalized_code":"3922SLLEWA1"},{"id":18493384,"change_date":"2026-02-05 21:38:00","inspection_id":"86933027","insp_violation_id":"271605037","seq_no":"2","part_no":"392","part_no_section":"2-SLLEWG1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V137747-3","created_at":"2026-02-08T10:50:17.000000Z","updated_at":"2026-02-16T10:39:01.000000Z","normalized_code":"3922SLLEWG1"},{"id":18493385,"change_date":"2026-02-05 21:38:00","inspection_id":"86933027","insp_violation_id":"271605038","seq_no":"3","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"211448267","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-08T10:50:17.000000Z","updated_at":"2026-02-16T10:39:01.000000Z","normalized_code":"3922SLLSR"},{"id":18493386,"change_date":"2026-02-05 21:38:00","inspection_id":"86933027","insp_violation_id":"271605039","seq_no":"4","part_no":"393","part_no_section":"55D2-B","insp_viol_unit":"1","insp_unit_id":"211448267","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-08T10:50:17.000000Z","updated_at":"2026-02-16T10:39:01.000000Z","normalized_code":"39355D2B"}],"inspection_per_units":[{"id":18840540,"change_date":"2026-02-05 21:38:00","inspection_id":"86933027","insp_unit_id":"211448267","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"C33","insp_unit_license":"39566A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1HTMKAAN55H105737","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-08T10:14:10.000000Z","updated_at":"2026-02-16T10:03:03.000000Z"}]},{"id":10002053,"change_date":"2025-10-22 21:38:00","inspection_id":"86112254","dot_number":"328526","report_state":"CT","report_number":"3119002476","insp_date":"2025-10-22 00:00:00","insp_start_time":"1030","insp_end_time":"1058","registration_date":null,"region":"ET","ci_status_code":"C","location":"034S","location_desc":"DANBURY SCALE","county_code_state":"CT","county_code":"001","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"9950325","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-22 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"755768","transaction_code":"A","transaction_date":"2025-10-22 00:00:00","upload_date":"2025-10-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00328526","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-10-22 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-10-22 21:38:00","insp_carrier_name":"NORBERT E MITCHELL CO INC","insp_carrier_street":"7 FEDERAL RD","insp_carrier_city":"DANBURY","insp_carrier_state":"CT","insp_carrier_zip_code":"06810","insp_colonia":null,"docket_number":"263035","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-25T10:01:19.000000Z","updated_at":"2025-10-26T10:00:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16611258,"change_date":"2025-10-22 21:38:00","inspection_id":"86112254","insp_unit_id":"209587603","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"C55","insp_unit_license":"71747A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FVACXFE8PHUH2191","insp_unit_decal":"Y","insp_unit_decal_number":"35802722","created_at":"2025-10-25T09:46:35.000000Z","updated_at":"2025-10-26T09:45:08.000000Z"}]},{"id":9117782,"change_date":"2025-07-11 21:38:00","inspection_id":"85182876","dot_number":"328526","report_state":"CT","report_number":"3082001561","insp_date":"2025-07-11 00:00:00","insp_start_time":"1120","insp_end_time":"1145","registration_date":null,"region":"ET","ci_status_code":"C","location":"034S","location_desc":"DANBURY SCALE","county_code_state":"CT","county_code":"001","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"520809","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-11 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"745595","transaction_code":"A","transaction_date":"2025-07-11 00:00:00","upload_date":"2025-07-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00328526","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-07-11 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-07-11 21:38:00","insp_carrier_name":"NORBERT E MITCHELL CO INC","insp_carrier_street":"7 FEDERAL RD","insp_carrier_city":"DANBURY","insp_carrier_state":"CT","insp_carrier_zip_code":"06810","insp_colonia":null,"docket_number":"263035","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-14T10:46:54.000000Z","updated_at":"2025-07-16T10:44:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14968851,"change_date":"2025-07-11 21:38:00","inspection_id":"85182876","insp_unit_id":"207810441","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"C44","insp_unit_license":"63901A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"2NKHHJ7X6KM259715","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-14T09:46:01.000000Z","updated_at":"2025-07-15T09:45:06.000000Z"}]},{"id":8975346,"change_date":"2025-07-03 21:33:00","inspection_id":"85032890","dot_number":"328526","report_state":"CT","report_number":"3070007080","insp_date":"2025-06-25 00:00:00","insp_start_time":"0958","insp_end_time":"1010","registration_date":"2025-07-03 00:00:00","region":"ET","ci_status_code":"C","location":"034S","location_desc":"DANBURY SCALE","county_code_state":"CT","county_code":"001","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"0","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":"2025-06-25 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"743957","transaction_code":"C","transaction_date":"2025-07-03 00:00:00","upload_date":"2025-07-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00328526","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-06-25 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-06-25 21:39:00","insp_carrier_name":"NORBERT E MITCHELL CO INC","insp_carrier_street":"7 FEDERAL RD","insp_carrier_city":"DANBURY","insp_carrier_state":"CT","insp_carrier_zip_code":"06810","insp_colonia":null,"docket_number":"263035","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-28T10:00:57.000000Z","updated_at":"2025-07-07T10:07:29.000000Z","inspection_violations":[{"id":14570091,"change_date":"2025-07-03 21:33:00","inspection_id":"85032890","insp_violation_id":"267186345","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWG1","insp_viol_unit":"1","insp_unit_id":"207686634","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-06T10:16:45.000000Z","updated_at":"2025-07-07T10:15:10.000000Z","normalized_code":"3922SLLEWG1"}],"inspection_per_units":[{"id":14856491,"change_date":"2025-07-03 21:33:00","inspection_id":"85032890","insp_unit_id":"207686634","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"66623A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3WKDD49X1LF411167","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-06T09:46:16.000000Z","updated_at":"2025-07-07T09:45:07.000000Z"},{"id":14856492,"change_date":"2025-07-03 21:33:00","inspection_id":"85032890","insp_unit_id":"207686635","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"COUA","insp_unit_company":null,"insp_unit_license":"AH50508","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1Z9M1AA23JA448275","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-06T09:46:16.000000Z","updated_at":"2025-07-07T09:45:07.000000Z"}]},{"id":8102124,"change_date":"2025-03-13 21:42:00","inspection_id":"84111128","dot_number":"328526","report_state":"CT","report_number":"3129005641","insp_date":"2025-03-13 00:00:00","insp_start_time":"0915","insp_end_time":"0955","registration_date":null,"region":"ET","ci_status_code":"C","location":"093","location_desc":"NEW HAVEN","county_code_state":"CT","county_code":"009","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"SHIPPER PAPER\/","cargo_tank":"306","hazmat_placard_req":"Y","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-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"734778","transaction_code":"A","transaction_date":"2025-03-13 00:00:00","upload_date":"2025-03-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00328526","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-03-13 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-03-13 21:42:00","insp_carrier_name":"NORBERT E MITCHELL CO INC","insp_carrier_street":"7 FEDERAL RD","insp_carrier_city":"DANBURY","insp_carrier_state":"CT","insp_carrier_zip_code":"06810","insp_colonia":null,"docket_number":"263035","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:06:49.000000Z","updated_at":"2025-03-17T21:06:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13081473,"change_date":"2025-03-13 21:42:00","inspection_id":"84111128","insp_unit_id":"205770658","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"F-12","insp_unit_license":"63832A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3WKDD49X8KF259046","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:37.000000Z","updated_at":"2025-03-17T23:59:37.000000Z"},{"id":13081474,"change_date":"2025-03-13 21:42:00","inspection_id":"84111128","insp_unit_id":"205770659","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":null,"insp_unit_license":"V16391","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1H4T04328NL022009","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:37.000000Z","updated_at":"2025-03-17T23:59:37.000000Z"}]},{"id":7856711,"change_date":"2025-02-24 21:39:00","inspection_id":"83853501","dot_number":"328526","report_state":"CT","report_number":"1147002323","insp_date":"2025-02-13 00:00:00","insp_start_time":"1005","insp_end_time":"1100","registration_date":"2025-02-24 00:00:00","region":"ET","ci_status_code":"C","location":"080","location_desc":"MERIDEN","county_code_state":"CT","county_code":"009","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"GLOBAL COMPANIES","shipping_paper_number":"382050","cargo_tank":"406","hazmat_placard_req":"Y","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-02-13 21:39:00","post_acc_ind":"Y","gross_comb_veh_wt":"120000","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":"732375","transaction_code":"C","transaction_date":"2025-02-13 00:00:00","upload_date":"2025-02-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00328526","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-02-13 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-02-13 21:39:00","insp_carrier_name":"NORBERT E MITCHELL CO INC","insp_carrier_street":"7 FEDERAL RD","insp_carrier_city":"DANBURY","insp_carrier_state":"CT","insp_carrier_zip_code":"06810","insp_colonia":null,"docket_number":"263035","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:01:13.000000Z","updated_at":"2025-03-17T21:01:13.000000Z","inspection_violations":[{"id":12279559,"change_date":"2025-02-24 21:39:00","inspection_id":"83853501","insp_violation_id":"264653297","seq_no":"1","part_no":"392","part_no_section":"2-SLLML","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"Z481904-2","created_at":"2025-03-17T22:05:53.000000Z","updated_at":"2025-03-17T22:05:53.000000Z","normalized_code":"3922SLLML"}],"inspection_per_units":[{"id":12680484,"change_date":"2025-02-24 21:39:00","inspection_id":"83853501","insp_unit_id":"205458099","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"74494A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1XKYDP9X4GJ493884","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:05.000000Z","updated_at":"2025-03-17T23:55:05.000000Z"},{"id":12680485,"change_date":"2025-02-24 21:39:00","inspection_id":"83853501","insp_unit_id":"205458100","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LBT I","insp_unit_company":null,"insp_unit_license":"99917","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"4J8T043237T011706","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:05.000000Z","updated_at":"2025-03-17T23:55:05.000000Z"}]},{"id":7742268,"change_date":"2025-02-07 21:39:00","inspection_id":"83732981","dot_number":"328526","report_state":"CT","report_number":"3022001080","insp_date":"2025-01-30 00:00:00","insp_start_time":"1357","insp_end_time":"1409","registration_date":"2025-02-07 00:00:00","region":"ET","ci_status_code":"C","location":"034","location_desc":"DANBURY","county_code_state":"CT","county_code":"001","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"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-01-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"731353","transaction_code":"C","transaction_date":"2025-01-30 00:00:00","upload_date":"2025-02-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00328526","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-01-30 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-01-30 21:40:00","insp_carrier_name":"NORBERT E MITCHELL CO INC","insp_carrier_street":"7 FEDERAL RD","insp_carrier_city":"DANBURY","insp_carrier_state":"CT","insp_carrier_zip_code":"06810","insp_colonia":null,"docket_number":"263035","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:59:06.000000Z","updated_at":"2025-03-17T20:59:06.000000Z","inspection_violations":[{"id":12097137,"change_date":"2025-02-07 21:39:00","inspection_id":"83732981","insp_violation_id":"264388844","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:04:59.000000Z","updated_at":"2025-03-17T22:04:59.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":12494097,"change_date":"2025-02-07 21:39:00","inspection_id":"83732981","insp_unit_id":"205202723","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"66623A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3WKDD49X1LF411167","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:51.000000Z","updated_at":"2025-03-17T23:52:51.000000Z"},{"id":12494098,"change_date":"2025-02-07 21:39:00","inspection_id":"83732981","insp_unit_id":"205202724","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"COUA","insp_unit_company":"621","insp_unit_license":"AH50508","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1Z9M1AA23JA448275","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:51.000000Z","updated_at":"2025-03-17T23:52:51.000000Z"}]},{"id":7245519,"change_date":"2024-11-21 21:40:00","inspection_id":"83210876","dot_number":"328526","report_state":"NY","report_number":"SPK4040012","insp_date":"2024-11-14 00:00:00","insp_start_time":"0926","insp_end_time":"1005","registration_date":null,"region":"ES","ci_status_code":"C","location":"80789M","location_desc":"BREWSTER NY","county_code_state":"NY","county_code":"079","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-11-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"13200","viol_total":"3","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":"1076371","transaction_code":"A","transaction_date":"2024-11-21 00:00:00","upload_date":"2024-11-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00328526","upload_search_indicator":null,"census_search_date":"2024-11-21 21:40:00","snet_input_date":"2024-11-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-21 21:40:00","insp_carrier_name":"NORBERT E MITCHELL CO INC","insp_carrier_street":"7 FEDERAL RD","insp_carrier_city":"DANBURY","insp_carrier_state":"CT","insp_carrier_zip_code":"06810","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:47:15.000000Z","updated_at":"2025-03-17T20:47:15.000000Z","inspection_violations":[{"id":11326288,"change_date":"2024-11-21 21:40:00","inspection_id":"83210876","insp_violation_id":"263010590","seq_no":"1","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":"K110JPGGKR","created_at":"2025-03-17T22:01:01.000000Z","updated_at":"2025-03-17T22:01:01.000000Z","normalized_code":"39141AMCPC"},{"id":11326289,"change_date":"2024-11-21 21:40:00","inspection_id":"83210876","insp_violation_id":"263010591","seq_no":"2","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":"2025-03-17T22:01:01.000000Z","updated_at":"2025-03-17T22:01:01.000000Z","normalized_code":"3922SLLTCD"},{"id":11326290,"change_date":"2024-11-21 21:40:00","inspection_id":"83210876","insp_violation_id":"263010592","seq_no":"3","part_no":"392","part_no_section":"8-D","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-17T22:01:01.000000Z","updated_at":"2025-03-17T22:01:01.000000Z","normalized_code":"3928D"}],"inspection_per_units":[{"id":11686787,"change_date":"2024-11-21 21:40:00","inspection_id":"83210876","insp_unit_id":"203983403","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":null,"insp_unit_license":"K90488","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1GB3KZCG1DF147908","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:08.000000Z","updated_at":"2025-03-17T23:44:08.000000Z"}]},{"id":6752270,"change_date":"2024-09-18 21:41:00","inspection_id":"82687072","dot_number":"328526","report_state":"NY","report_number":"D102901023","insp_date":"2024-09-13 00:00:00","insp_start_time":"1221","insp_end_time":"1250","registration_date":null,"region":"ED","ci_status_code":"C","location":"10753M","location_desc":"SCHODACK LANDING NY","county_code_state":"NY","county_code":"083","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"NA","cargo_tank":"331","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-09-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"856722","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":"00328526","upload_search_indicator":null,"census_search_date":"2024-09-18 21:41:00","snet_input_date":"2024-09-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-18 21:41:00","insp_carrier_name":"NORBERT E MITCHELL CO INC","insp_carrier_street":"7 FEDERAL RD","insp_carrier_city":"DANBURY","insp_carrier_state":"CT","insp_carrier_zip_code":"06810","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:36:57.000000Z","updated_at":"2025-03-17T20:36:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10888102,"change_date":"2024-09-18 21:41:00","inspection_id":"82687072","insp_unit_id":"202994520","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH M","insp_unit_company":"F14","insp_unit_license":"66623A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3WKDD49X1LF411167","insp_unit_decal":"Y","insp_unit_decal_number":"34337475","created_at":"2025-03-17T23:35:46.000000Z","updated_at":"2025-03-17T23:35:46.000000Z"},{"id":10888103,"change_date":"2024-09-18 21:41:00","inspection_id":"82687072","insp_unit_id":"202994521","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"COUNTRY-AI","insp_unit_company":"G21","insp_unit_license":"AH50508","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1Z9M1AA23JA448275","insp_unit_decal":"Y","insp_unit_decal_number":"34337476","created_at":"2025-03-17T23:35:46.000000Z","updated_at":"2025-03-17T23:35:46.000000Z"}]},{"id":6327673,"change_date":"2024-07-30 21:42:00","inspection_id":"82234433","dot_number":"328526","report_state":"CT","report_number":"3070006166","insp_date":"2024-07-29 00:00:00","insp_start_time":"0758","insp_end_time":"0817","registration_date":"2024-07-30 00:00:00","region":"ET","ci_status_code":"C","location":"034S","location_desc":"DANBURY SCALE","county_code_state":"CT","county_code":"001","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"0","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-07-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"713918","transaction_code":"C","transaction_date":"2024-07-29 00:00:00","upload_date":"2024-07-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00328526","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-07-29 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-07-29 21:40:00","insp_carrier_name":"NORBERT E MITCHELL CO INC","insp_carrier_street":"7 FEDERAL RD","insp_carrier_city":"DANBURY","insp_carrier_state":"CT","insp_carrier_zip_code":"06810","insp_colonia":null,"docket_number":"263035","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:28:15.000000Z","updated_at":"2025-03-17T20:28:15.000000Z","inspection_violations":[{"id":9824390,"change_date":"2024-07-30 21:42:00","inspection_id":"82234433","insp_violation_id":"260905217","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202133344","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V129136-2","created_at":"2025-03-17T21:53:32.000000Z","updated_at":"2025-03-17T21:53:32.000000Z","normalized_code":"3922"},{"id":9824391,"change_date":"2024-07-30 21:42:00","inspection_id":"82234433","insp_violation_id":"260905218","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"202133344","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:32.000000Z","updated_at":"2025-03-17T21:53:32.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":10196238,"change_date":"2024-07-30 21:42:00","inspection_id":"82234433","insp_unit_id":"202133344","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"F14","insp_unit_license":"66623A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3WKDD49X1LF411167","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:37.000000Z","updated_at":"2025-03-17T23:28:37.000000Z"},{"id":10196239,"change_date":"2024-07-30 21:42:00","inspection_id":"82234433","insp_unit_id":"202133345","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"COUA","insp_unit_company":"G21","insp_unit_license":"AH50508","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1Z9M1AA23JA448275","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:37.000000Z","updated_at":"2025-03-17T23:28:37.000000Z"}]},{"id":6238647,"change_date":"2024-07-17 21:41:00","inspection_id":"82139130","dot_number":"328526","report_state":"NY","report_number":"M005700081","insp_date":"2024-07-11 00:00:00","insp_start_time":"1059","insp_end_time":"1118","registration_date":null,"region":"ED","ci_status_code":"C","location":"80789M","location_desc":"BREWSTER NY","county_code_state":"NY","county_code":"079","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-07-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"660487","transaction_code":"A","transaction_date":"2024-07-17 00:00:00","upload_date":"2024-07-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00328526","upload_search_indicator":null,"census_search_date":"2024-07-17 21:41:00","snet_input_date":"2024-07-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-17 21:41:00","insp_carrier_name":"NORBERT E MITCHELL CO INC","insp_carrier_street":"7 FEDERAL RD","insp_carrier_city":"DANBURY","insp_carrier_state":"CT","insp_carrier_zip_code":"06810","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:26:15.000000Z","updated_at":"2025-03-17T20:26:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10051899,"change_date":"2024-07-17 21:41:00","inspection_id":"82139130","insp_unit_id":"201925440","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"D31","insp_unit_license":"74190A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FVACXFE0PHUL1056","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:09.000000Z","updated_at":"2025-03-17T23:27:09.000000Z"}]},{"id":6204918,"change_date":"2024-07-12 21:39:00","inspection_id":"82102888","dot_number":"328526","report_state":"NY","report_number":"SPK0230450","insp_date":"2024-07-10 00:00:00","insp_start_time":"1340","insp_end_time":"1356","registration_date":null,"region":"ET","ci_status_code":"C","location":"80789","location_desc":"SOUTHEAST","county_code_state":"NY","county_code":"079","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-12 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","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":"2936487","transaction_code":"A","transaction_date":"2024-07-12 00:00:00","upload_date":"2024-07-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00328526","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-07-12 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-07-12 21:39:00","insp_carrier_name":"NORBERT E MITCHELL CO INC","insp_carrier_street":"7 FEDERAL RD","insp_carrier_city":"DANBURY","insp_carrier_state":"CT","insp_carrier_zip_code":"06810","insp_colonia":null,"docket_number":"263035","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:25:45.000000Z","updated_at":"2025-03-17T20:25:45.000000Z","inspection_violations":[{"id":9637617,"change_date":"2024-07-12 21:39:00","inspection_id":"82102888","insp_violation_id":"260609890","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:52:37.000000Z","updated_at":"2025-03-17T21:52:37.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9995981,"change_date":"2024-07-12 21:39:00","inspection_id":"82102888","insp_unit_id":"201855824","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"E51","insp_unit_license":"AB08931","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3C7WRTAL9JG319987","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:36.000000Z","updated_at":"2025-03-17T23:26:36.000000Z"}]},{"id":5673112,"change_date":"2024-05-06 21:42:00","inspection_id":"81527682","dot_number":"328526","report_state":"NY","report_number":"8L43000582","insp_date":"2024-05-01 00:00:00","insp_start_time":"1132","insp_end_time":"1205","registration_date":null,"region":"ED","ci_status_code":"C","location":"HARBOR","location_desc":"MAMARONECK NY","county_code_state":"NY","county_code":"119","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-05-06 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"457302","transaction_code":"A","transaction_date":"2024-05-06 00:00:00","upload_date":"2024-05-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00328526","upload_search_indicator":null,"census_search_date":"2024-05-06 21:42:00","snet_input_date":"2024-05-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-06 21:42:00","insp_carrier_name":"NORBERT E MITCHELL CO INC","insp_carrier_street":"7 FEDERAL RD","insp_carrier_city":"DANBURY","insp_carrier_state":"CT","insp_carrier_zip_code":"06810","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:15:07.000000Z","updated_at":"2025-03-17T20:15:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9137485,"change_date":"2024-05-06 21:42:00","inspection_id":"81527682","insp_unit_id":"200734850","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"D31","insp_unit_license":"74190A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FVACXFE0PHUL1056","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:02.000000Z","updated_at":"2025-03-17T23:18:02.000000Z"}]},{"id":5428715,"change_date":"2024-04-10 21:41:00","inspection_id":"81261087","dot_number":"328526","report_state":"CT","report_number":"3076002792","insp_date":"2024-04-04 00:00:00","insp_start_time":"0909","insp_end_time":"0931","registration_date":"2024-04-10 00:00:00","region":"ET","ci_status_code":"C","location":"034S","location_desc":"DANBURY SCALE","county_code_state":"CT","county_code":"001","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"215340","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"704133","transaction_code":"C","transaction_date":"2024-04-04 00:00:00","upload_date":"2024-04-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00328526","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-04-04 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-04-04 21:41:00","insp_carrier_name":"NORBERT E MITCHELL CO INC","insp_carrier_street":"7 FEDERAL RD","insp_carrier_city":"DANBURY","insp_carrier_state":"CT","insp_carrier_zip_code":"06810","insp_colonia":null,"docket_number":"263035","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:10:17.000000Z","updated_at":"2025-03-17T20:10:17.000000Z","inspection_violations":[{"id":8381130,"change_date":"2024-04-10 21:41:00","inspection_id":"81261087","insp_violation_id":"258842909","seq_no":"1","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"2","insp_unit_id":"200321581","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:46:36.000000Z","updated_at":"2025-03-17T21:46:36.000000Z","normalized_code":"39375A"}],"inspection_per_units":[{"id":8744484,"change_date":"2024-04-10 21:41:00","inspection_id":"81261087","insp_unit_id":"200321580","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"F14","insp_unit_license":"66623A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3WKDD49X1LF411167","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:19.000000Z","updated_at":"2025-03-17T23:14:19.000000Z"},{"id":8744485,"change_date":"2024-04-10 21:41:00","inspection_id":"81261087","insp_unit_id":"200321581","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"COUA","insp_unit_company":"G21","insp_unit_license":"AH50508","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1Z9M1AA23JA448275","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:19.000000Z","updated_at":"2025-03-17T23:14:19.000000Z"}]},{"id":5056796,"change_date":"2024-02-15 21:41:00","inspection_id":"80855400","dot_number":"328526","report_state":"CT","report_number":"3019005167","insp_date":"2024-02-15 00:00:00","insp_start_time":"0706","insp_end_time":"0719","registration_date":null,"region":"ET","ci_status_code":"C","location":"144","location_desc":"TRUMBULL","county_code_state":"CT","county_code":"001","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"GLOBAL","shipping_paper_number":"305625","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-02-15 21:41: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":"699576","transaction_code":"A","transaction_date":"2024-02-15 00:00:00","upload_date":"2024-02-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00328526","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-02-15 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-02-15 21:41:00","insp_carrier_name":"NORBERT E MITCHELL CO INC","insp_carrier_street":"7 FEDERAL RD","insp_carrier_city":"DANBURY","insp_carrier_state":"CT","insp_carrier_zip_code":"06810","insp_colonia":null,"docket_number":"263035","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:02:47.000000Z","updated_at":"2025-03-17T20:02:47.000000Z","inspection_violations":[{"id":7794495,"change_date":"2024-02-15 21:41:00","inspection_id":"80855400","insp_violation_id":"257851819","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:43:41.000000Z","updated_at":"2025-03-17T21:43:41.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8139937,"change_date":"2024-02-15 21:41:00","inspection_id":"80855400","insp_unit_id":"199434378","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"58942A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1XKDD49X2CJ326530","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:44.000000Z","updated_at":"2025-03-17T23:08:44.000000Z"},{"id":8139938,"change_date":"2024-02-15 21:41:00","inspection_id":"80855400","insp_unit_id":"199434379","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LBT","insp_unit_company":"G15","insp_unit_license":"V86017","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"4J8T0422X8T007901","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:44.000000Z","updated_at":"2025-03-17T23:08:44.000000Z"}]},{"id":4914911,"change_date":"2024-02-02 21:40:00","inspection_id":"80700114","dot_number":"328526","report_state":"CT","report_number":"3019005137","insp_date":"2024-01-29 00:00:00","insp_start_time":"1406","insp_end_time":"1419","registration_date":"2024-02-01 00:00:00","region":"ET","ci_status_code":"C","location":"034","location_desc":"DANBURY","county_code_state":"CT","county_code":"001","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-29 21:38: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":"698166","transaction_code":"C","transaction_date":"2024-01-29 00:00:00","upload_date":"2024-02-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00328526","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-01-29 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-01-29 21:38:00","insp_carrier_name":"NORBERT E MITCHELL CO INC","insp_carrier_street":"7 FEDERAL RD","insp_carrier_city":"DANBURY","insp_carrier_state":"CT","insp_carrier_zip_code":"06810","insp_colonia":null,"docket_number":"263035","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:00:04.000000Z","updated_at":"2025-03-17T20:00:04.000000Z","inspection_violations":[{"id":7572501,"change_date":"2024-02-02 21:40:00","inspection_id":"80700114","insp_violation_id":"257623333","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:42:32.000000Z","updated_at":"2025-03-17T21:42:32.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7909062,"change_date":"2024-02-02 21:40:00","inspection_id":"80700114","insp_unit_id":"199230722","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"F14","insp_unit_license":"66623A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3WKDD49X1LF411167","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:41.000000Z","updated_at":"2025-03-17T23:06:41.000000Z"},{"id":7909063,"change_date":"2024-02-02 21:40:00","inspection_id":"80700114","insp_unit_id":"199230723","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"COUA","insp_unit_company":"G21","insp_unit_license":"AH50508","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1Z9M1AA23JA448275","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:41.000000Z","updated_at":"2025-03-17T23:06:41.000000Z"}]},{"id":4845084,"change_date":"2024-01-17 21:43:00","inspection_id":"80623737","dot_number":"328526","report_state":"CT","report_number":"0791000641","insp_date":"2024-01-17 00:00:00","insp_start_time":"0936","insp_end_time":"0954","registration_date":null,"region":"ET","ci_status_code":"C","location":"034S","location_desc":"DANBURY SCALE","county_code_state":"CT","county_code":"001","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CRESTWOOD MIDSTREAM PARTNERS","shipping_paper_number":"49862","cargo_tank":"331","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-17 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"697060","transaction_code":"A","transaction_date":"2024-01-17 00:00:00","upload_date":"2024-01-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00328526","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-01-17 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-01-17 21:43:00","insp_carrier_name":"NORBERT E MITCHELL CO INC","insp_carrier_street":"7 FEDERAL RD","insp_carrier_city":"DANBURY","insp_carrier_state":"CT","insp_carrier_zip_code":"06810","insp_colonia":null,"docket_number":"263035","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:58:49.000000Z","updated_at":"2025-03-17T19:58:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7795337,"change_date":"2024-01-17 21:43:00","inspection_id":"80623737","insp_unit_id":"198985621","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"66623A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3WKDD49X1LF411167","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:41.000000Z","updated_at":"2025-03-17T23:05:41.000000Z"},{"id":7795338,"change_date":"2024-01-17 21:43:00","inspection_id":"80623737","insp_unit_id":"198985622","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"COUA","insp_unit_company":"G21","insp_unit_license":"AH50508","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1Z9M1AA23JA448275","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:41.000000Z","updated_at":"2025-03-17T23:05:41.000000Z"}]},{"id":4798464,"change_date":"2024-01-10 21:43:00","inspection_id":"80572734","dot_number":"328526","report_state":"CT","report_number":"3070005590","insp_date":"2024-01-10 00:00:00","insp_start_time":"0714","insp_end_time":"0735","registration_date":null,"region":"ET","ci_status_code":"C","location":"096","location_desc":"NEW MILFORD","county_code_state":"CT","county_code":"005","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"0","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-10 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"696506","transaction_code":"A","transaction_date":"2024-01-10 00:00:00","upload_date":"2024-01-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00328526","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-01-10 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-01-10 21:43:00","insp_carrier_name":"NORBERT E MITCHELL CO INC","insp_carrier_street":"7 FEDERAL RD","insp_carrier_city":"DANBURY","insp_carrier_state":"CT","insp_carrier_zip_code":"06810","insp_colonia":null,"docket_number":"263035","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:57:42.000000Z","updated_at":"2025-03-17T19:57:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7720176,"change_date":"2024-01-10 21:43:00","inspection_id":"80572734","insp_unit_id":"198888799","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"C26","insp_unit_license":"31309A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FVABTBS91HH57021","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:01.000000Z","updated_at":"2025-03-17T23:05:01.000000Z"}]},{"id":4668526,"change_date":"2024-01-05 21:45:00","inspection_id":"80430994","dot_number":"328526","report_state":"CT","report_number":"3019005046","insp_date":"2023-12-20 00:00:00","insp_start_time":"1408","insp_end_time":"1422","registration_date":"2024-01-04 00:00:00","region":"ET","ci_status_code":"C","location":"034","location_desc":"DANBURY","county_code_state":"CT","county_code":"001","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-12-20 21:41: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":"694999","transaction_code":"C","transaction_date":"2023-12-20 00:00:00","upload_date":"2024-01-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00328526","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-12-20 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-12-20 21:41:00","insp_carrier_name":"NORBERT E MITCHELL CO INC","insp_carrier_street":"7 FEDERAL RD","insp_carrier_city":"DANBURY","insp_carrier_state":"CT","insp_carrier_zip_code":"06810","insp_colonia":null,"docket_number":"263035","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:55:23.000000Z","updated_at":"2025-03-17T19:55:23.000000Z","inspection_violations":[{"id":7216528,"change_date":"2024-01-05 21:45:00","inspection_id":"80430994","insp_violation_id":"257198368","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:40:50.000000Z","updated_at":"2025-03-17T21:40:50.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7508765,"change_date":"2024-01-05 21:45:00","inspection_id":"80430994","insp_unit_id":"198825549","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"66623A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3WKDD49X1LF411167","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:07.000000Z","updated_at":"2025-03-17T23:03:07.000000Z"},{"id":7508766,"change_date":"2024-01-05 21:45:00","inspection_id":"80430994","insp_unit_id":"198825550","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"COUI","insp_unit_company":null,"insp_unit_license":"AH50508","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1Z9M1AA23JA448275","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:07.000000Z","updated_at":"2025-03-17T23:03:07.000000Z"}]},{"id":4650322,"change_date":"2023-12-18 21:41:00","inspection_id":"80411019","dot_number":"328526","report_state":"NY","report_number":"SPC0179444","insp_date":"2023-12-13 00:00:00","insp_start_time":"1143","insp_end_time":"1203","registration_date":null,"region":"ET","ci_status_code":"C","location":"80057A","location_desc":"BEDFORD (SB)","county_code_state":"NY","county_code":"119","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MITCHELL NORBERT CO INC","shipping_paper_number":null,"cargo_tank":"331","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-12-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2894130","transaction_code":"A","transaction_date":"2023-12-13 00:00:00","upload_date":"2023-12-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00328526","upload_search_indicator":null,"census_search_date":"2023-12-18 21:41:00","snet_input_date":"2023-12-18 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-12-18 21:41:00","insp_carrier_name":"NORBERT E MITCHELL CO INC","insp_carrier_street":"7 FEDERAL RD","insp_carrier_city":"DANBURY","insp_carrier_state":"CT","insp_carrier_zip_code":"06810","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:54:58.000000Z","updated_at":"2025-03-17T19:54:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7478973,"change_date":"2023-12-18 21:41:00","inspection_id":"80411019","insp_unit_id":"198547110","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"D21","insp_unit_license":"55696A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"2NKHHJ7X0FM436524","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:52.000000Z","updated_at":"2025-03-17T23:02:52.000000Z"}]},{"id":4487414,"change_date":"2023-11-27 21:40:00","inspection_id":"80232045","dot_number":"328526","report_state":"CT","report_number":"1094000095","insp_date":"2023-11-27 00:00:00","insp_start_time":"1305","insp_end_time":"1320","registration_date":null,"region":"ET","ci_status_code":"C","location":"034","location_desc":"DANBURY","county_code_state":"CT","county_code":"001","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"N\/A","cargo_tank":"331","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"692827","transaction_code":"A","transaction_date":"2023-11-27 00:00:00","upload_date":"2023-11-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00328526","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-11-27 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-11-27 21:40:00","insp_carrier_name":"NORBERT E MITCHELL CO INC","insp_carrier_street":"7 FEDERAL RD","insp_carrier_city":"DANBURY","insp_carrier_state":"CT","insp_carrier_zip_code":"06810","insp_colonia":null,"docket_number":"263035","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:51:48.000000Z","updated_at":"2025-03-17T19:51:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7217092,"change_date":"2023-11-27 21:40:00","inspection_id":"80232045","insp_unit_id":"198198394","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"F14","insp_unit_license":"66623A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3WKDD49X1LF411167","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:37.000000Z","updated_at":"2025-03-17T23:00:37.000000Z"},{"id":7217093,"change_date":"2023-11-27 21:40:00","inspection_id":"80232045","insp_unit_id":"198198395","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"COUI","insp_unit_company":"G21","insp_unit_license":"AH50508","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1Z9M1AA23JA448275","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:37.000000Z","updated_at":"2025-03-17T23:00:37.000000Z"}]},{"id":4078683,"change_date":"2023-09-28 21:40:00","inspection_id":"79780257","dot_number":"328526","report_state":"NY","report_number":"SPK0220418","insp_date":"2023-09-19 00:00:00","insp_start_time":"1530","insp_end_time":"1552","registration_date":null,"region":"ET","ci_status_code":"C","location":"80789A","location_desc":"SOUTHEAST (NB)","county_code_state":"NY","county_code":"079","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"331","hazmat_placard_req":"Y","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"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":"2873480","transaction_code":"A","transaction_date":"2023-09-28 00:00:00","upload_date":"2023-09-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00328526","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-09-28 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-09-28 21:40:00","insp_carrier_name":"NORBERT E MITCHELL CO INC","insp_carrier_street":"7 FEDERAL RD","insp_carrier_city":"DANBURY","insp_carrier_state":"CT","insp_carrier_zip_code":"06810","insp_colonia":null,"docket_number":"263035","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:43:15.000000Z","updated_at":"2025-03-17T19:43:15.000000Z","inspection_violations":[{"id":6313713,"change_date":"2023-09-28 21:40:00","inspection_id":"79780257","insp_violation_id":"255538547","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:26.000000Z","updated_at":"2025-03-17T21:36:26.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6557582,"change_date":"2023-09-28 21:40:00","inspection_id":"79780257","insp_unit_id":"197287684","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"D26","insp_unit_license":"69755A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"2NKHHJ7X4MM461035","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:02.000000Z","updated_at":"2025-03-17T22:55:02.000000Z"}]},{"id":3951782,"change_date":"2023-09-12 21:39:00","inspection_id":"79639206","dot_number":"328526","report_state":"NY","report_number":"SPK0158547","insp_date":"2023-09-07 00:00:00","insp_start_time":"1048","insp_end_time":"1112","registration_date":null,"region":"ET","ci_status_code":"C","location":"80645A","location_desc":"PAWLING","county_code_state":"NY","county_code":"027","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"331","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-12 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2867618","transaction_code":"A","transaction_date":"2023-09-12 00:00:00","upload_date":"2023-09-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00328526","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-09-12 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-09-12 21:39:00","insp_carrier_name":"NORBERT E MITCHELL CO INC","insp_carrier_street":"PO BOX 186","insp_carrier_city":"DANBURY","insp_carrier_state":"CT","insp_carrier_zip_code":"06813-0186","insp_colonia":null,"docket_number":"263035","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:40:50.000000Z","updated_at":"2025-03-17T19:40:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6354151,"change_date":"2023-09-12 21:39:00","inspection_id":"79639206","insp_unit_id":"197005794","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"D26","insp_unit_license":"69755A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"2NKHHJ7X4MM461035","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:22.000000Z","updated_at":"2025-03-17T22:53:22.000000Z"}]},{"id":3830221,"change_date":"2023-08-25 21:40:00","inspection_id":"79503635","dot_number":"328526","report_state":"NY","report_number":"0811012725","insp_date":"2023-08-24 00:00:00","insp_start_time":"1001","insp_end_time":"1036","registration_date":null,"region":"ET","ci_status_code":"C","location":"80789M","location_desc":"SOUTHEAST REST AREA (NB)","county_code_state":"NY","county_code":"079","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"331","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-08-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2862110","transaction_code":"A","transaction_date":"2023-08-24 00:00:00","upload_date":"2023-08-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00328526","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-08-25 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-08-25 21:40:00","insp_carrier_name":"NORBERT E MITCHELL CO INC","insp_carrier_street":"PO BOX 186","insp_carrier_city":"DANBURY","insp_carrier_state":"CT","insp_carrier_zip_code":"06813-0186","insp_colonia":null,"docket_number":"263035","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:31.000000Z","updated_at":"2025-03-17T19:38:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6158047,"change_date":"2023-08-25 21:40:00","inspection_id":"79503635","insp_unit_id":"196725534","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"D31","insp_unit_license":"74190A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FVACXFE0PHUL1056","insp_unit_decal":"Y","insp_unit_decal_number":"33073573","created_at":"2025-03-17T22:51:43.000000Z","updated_at":"2025-03-17T22:51:43.000000Z"}]},{"id":3762322,"change_date":"2023-08-17 21:42:00","inspection_id":"79427590","dot_number":"328526","report_state":"NY","report_number":"SPC0242138","insp_date":"2023-08-16 00:00:00","insp_start_time":"0943","insp_end_time":"1009","registration_date":null,"region":"ET","ci_status_code":"C","location":"80057A","location_desc":"BEDFORD (SB)","county_code_state":"NY","county_code":"119","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"NORBERT E MITCHELL CO INC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"2859209","transaction_code":"A","transaction_date":"2023-08-17 00:00:00","upload_date":"2023-08-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00328526","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-08-17 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-08-17 21:42:00","insp_carrier_name":"NORBERT E MITCHELL CO INC","insp_carrier_street":"PO BOX 186","insp_carrier_city":"DANBURY","insp_carrier_state":"CT","insp_carrier_zip_code":"06813-0186","insp_colonia":null,"docket_number":"263035","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:37:15.000000Z","updated_at":"2025-03-17T19:37:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6049382,"change_date":"2023-08-17 21:42:00","inspection_id":"79427590","insp_unit_id":"196573851","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"C47","insp_unit_license":"68184A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3BKDL40XXMF453603","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:50.000000Z","updated_at":"2025-03-17T22:50:50.000000Z"}]},{"id":3112322,"change_date":"2023-05-23 21:41:00","inspection_id":"78697199","dot_number":"328526","report_state":"NY","report_number":"0811012674","insp_date":"2023-05-22 00:00:00","insp_start_time":"0817","insp_end_time":"0911","registration_date":null,"region":"ET","ci_status_code":"C","location":"80749M","location_desc":"SAUGERTIES MP99 PARKING (NB)","county_code_state":"NY","county_code":"111","insp_level_id":"2","service_center":"EA","census_source_id":"4","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"331","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-05-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"2828241","transaction_code":"A","transaction_date":"2023-05-23 00:00:00","upload_date":"2023-05-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00328526","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-05-23 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-05-23 21:41:00","insp_carrier_name":"NORBERT E MITCHELL CO INC","insp_carrier_street":"7 FEDERAL RD","insp_carrier_city":"DANBURY","insp_carrier_state":"CT","insp_carrier_zip_code":"06810","insp_colonia":null,"docket_number":"263035","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:24:36.000000Z","updated_at":"2025-03-17T19:24:36.000000Z","inspection_violations":[{"id":4790436,"change_date":"2023-05-23 21:41:00","inspection_id":"78697199","insp_violation_id":"253005104","seq_no":"1","part_no":"393","part_no_section":"86(a)(3)","insp_viol_unit":"2","insp_unit_id":"195078765","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:17.000000Z","updated_at":"2025-03-17T21:29:17.000000Z","normalized_code":"39386A3"}],"inspection_per_units":[{"id":5006222,"change_date":"2023-05-23 21:41:00","inspection_id":"78697199","insp_unit_id":"195078764","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"F-12","insp_unit_license":"63832A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3WKDD49X8KF259046","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:28.000000Z","updated_at":"2025-03-17T22:42:28.000000Z"},{"id":5006223,"change_date":"2023-05-23 21:41:00","inspection_id":"78697199","insp_unit_id":"195078765","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"COUI","insp_unit_company":"G21","insp_unit_license":"AH50508","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1Z9M1AA23JA448275","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:28.000000Z","updated_at":"2025-03-17T22:42:28.000000Z"}]},{"id":2222299,"change_date":"2023-01-25 21:42:00","inspection_id":"77686425","dot_number":"328526","report_state":"NY","report_number":"SPC0225418","insp_date":"2023-01-12 00:00:00","insp_start_time":"0827","insp_end_time":"0845","registration_date":null,"region":"ET","ci_status_code":"C","location":"80057","location_desc":"BEDFORD (SB)","county_code_state":"NY","county_code":"119","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"NORBERT E MITCHELL CO INC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-25 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"2791738","transaction_code":"A","transaction_date":"2023-01-25 00:00:00","upload_date":"2023-01-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00328526","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-01-25 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-01-25 21:42:00","insp_carrier_name":"NORBERT E MITCHELL CO INC","insp_carrier_street":"PO BOX 186","insp_carrier_city":"DANBURY","insp_carrier_state":"CT","insp_carrier_zip_code":"06813-0186","insp_colonia":null,"docket_number":"263035","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:07:42.000000Z","updated_at":"2025-03-17T19:07:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3576464,"change_date":"2023-01-25 21:42:00","inspection_id":"77686425","insp_unit_id":"193051166","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"C47","insp_unit_license":"68184A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3BKDL40XXMF453603","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:39.000000Z","updated_at":"2025-03-17T22:31:39.000000Z"}]},{"id":1952671,"change_date":"2022-12-15 21:38:00","inspection_id":"77378048","dot_number":"328526","report_state":"NY","report_number":"SPK0194796","insp_date":"2022-12-14 00:00:00","insp_start_time":"0715","insp_end_time":"0745","registration_date":null,"region":"ET","ci_status_code":"C","location":"80057","location_desc":"BEDFORD","county_code_state":"NY","county_code":"119","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":"Y","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-12-15 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2780286","transaction_code":"A","transaction_date":"2022-12-15 00:00:00","upload_date":"2022-12-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00328526","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-12-15 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-12-15 21:38:00","insp_carrier_name":"NORBERT E MITCHELL CO INC","insp_carrier_street":"PO BOX 186","insp_carrier_city":"DANBURY","insp_carrier_state":"CT","insp_carrier_zip_code":"06813-0186","insp_colonia":null,"docket_number":"263035","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:02:35.000000Z","updated_at":"2025-03-17T19:02:35.000000Z","inspection_violations":[{"id":3032467,"change_date":"2022-12-15 21:38:00","inspection_id":"77378048","insp_violation_id":"250111877","seq_no":"1","part_no":"393","part_no_section":"60(e)","insp_viol_unit":"1","insp_unit_id":"192438351","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:25.000000Z","updated_at":"2025-03-17T21:21:25.000000Z","normalized_code":"39360E"},{"id":3032468,"change_date":"2022-12-15 21:38:00","inspection_id":"77378048","insp_violation_id":"250111878","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":"99","citation_number":null,"created_at":"2025-03-17T21:21:25.000000Z","updated_at":"2025-03-17T21:21:25.000000Z","normalized_code":"38323A2"}],"inspection_per_units":[{"id":3141638,"change_date":"2022-12-15 21:38:00","inspection_id":"77378048","insp_unit_id":"192438351","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"C42","insp_unit_license":"45848A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"2NKHHJ7X4HM142210","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:31.000000Z","updated_at":"2025-03-17T22:28:31.000000Z"}]},{"id":2051622,"change_date":"2023-01-03 21:40:00","inspection_id":"77490803","dot_number":"328526","report_state":"NY","report_number":"SPK0174265","insp_date":"2022-12-14 00:00:00","insp_start_time":"0905","insp_end_time":"0929","registration_date":null,"region":"ET","ci_status_code":"C","location":"80789","location_desc":"SOUTHEAST","county_code_state":"NY","county_code":"079","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":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2784321","transaction_code":"A","transaction_date":"2023-01-03 00:00:00","upload_date":"2023-01-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00328526","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-01-03 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-01-03 21:40:00","insp_carrier_name":"NORBERT E MITCHELL CO INC","insp_carrier_street":"7 FEDERAL RD","insp_carrier_city":"DANBURY","insp_carrier_state":"CT","insp_carrier_zip_code":"06810","insp_colonia":null,"docket_number":"263035","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:04:23.000000Z","updated_at":"2025-03-17T19:04:23.000000Z","inspection_violations":[{"id":3177621,"change_date":"2023-01-03 21:40:00","inspection_id":"77490803","insp_violation_id":"250348000","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192662001","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"6G6P764","created_at":"2025-03-17T21:22:01.000000Z","updated_at":"2025-03-17T21:22:01.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":3299921,"change_date":"2023-01-03 21:40:00","inspection_id":"77490803","insp_unit_id":"192662001","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"C27","insp_unit_license":"31485A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FVABTBS71HH83049","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:36.000000Z","updated_at":"2025-03-17T22:29:36.000000Z"}]},{"id":1682551,"change_date":"2022-11-07 21:40:00","inspection_id":"77068462","dot_number":"328526","report_state":"US","report_number":"1546000489","insp_date":"2022-11-04 00:00:00","insp_start_time":"0932","insp_end_time":"0943","registration_date":null,"region":"ET","ci_status_code":"C","location":"034","location_desc":"DANBURY WEIGH STATION","county_code_state":"CT","county_code":"001","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"C43","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-11-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"36326","transaction_code":"A","transaction_date":"2022-11-04 00:00:00","upload_date":"2022-11-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00328526","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-11-07 00:00:00","source_office":"1MDD001","mcmis_add_date":"2022-11-07 21:40:00","insp_carrier_name":"NORBERT E MITCHELL CO INC","insp_carrier_street":"PO BOX 186","insp_carrier_city":"DANBURY","insp_carrier_state":"CT","insp_carrier_zip_code":"06813-0186","insp_colonia":null,"docket_number":"263035","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:57:43.000000Z","updated_at":"2025-03-17T18:57:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2706976,"change_date":"2022-11-07 21:40:00","inspection_id":"77068462","insp_unit_id":"191827749","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"C43","insp_unit_license":"61894A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"2NKHHJ7X1JM202336","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:33.000000Z","updated_at":"2025-03-17T22:25:33.000000Z"}]},{"id":1577164,"change_date":"2022-10-24 21:40:00","inspection_id":"76947559","dot_number":"328526","report_state":"CT","report_number":"3070003911","insp_date":"2022-10-24 00:00:00","insp_start_time":"0955","insp_end_time":"1007","registration_date":null,"region":"ET","ci_status_code":"C","location":"034S","location_desc":"DANBURY SCALE","county_code_state":"CT","county_code":"001","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"-","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-24 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":"656907","transaction_code":"A","transaction_date":"2022-10-24 00:00:00","upload_date":"2022-10-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00328526","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-10-24 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-10-24 21:40:00","insp_carrier_name":"NORBERT E MITCHELL CO INC","insp_carrier_street":"7 FEDERAL RD","insp_carrier_city":"DANBURY","insp_carrier_state":"CT","insp_carrier_zip_code":"06810","insp_colonia":null,"docket_number":"263035","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:55:38.000000Z","updated_at":"2025-03-17T18:55:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2538324,"change_date":"2022-10-24 21:40:00","inspection_id":"76947559","insp_unit_id":"191586290","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"63832A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3WKDD49X8KF259046","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:23.000000Z","updated_at":"2025-03-17T22:24:23.000000Z"},{"id":2538325,"change_date":"2022-10-24 21:40:00","inspection_id":"76947559","insp_unit_id":"191586291","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"COUI","insp_unit_company":null,"insp_unit_license":"AH50508","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1Z9M1AA23JA448275","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:23.000000Z","updated_at":"2025-03-17T22:24:23.000000Z"}]},{"id":1108907,"change_date":"2022-08-23 21:41:00","inspection_id":"76404572","dot_number":"328526","report_state":"NY","report_number":"MC59000538","insp_date":"2022-08-22 00:00:00","insp_start_time":"1003","insp_end_time":"1112","registration_date":null,"region":"ET","ci_status_code":"C","location":"80749M","location_desc":"SAUGERTIES MP99 PARKING (NB)","county_code_state":"NY","county_code":"111","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"F","shipper_name":"NORBERT E MITCHELL CO INC","shipping_paper_number":null,"cargo_tank":"331","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-08-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"148000","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":"2742694","transaction_code":"A","transaction_date":"2022-08-23 00:00:00","upload_date":"2022-08-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00328526","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-08-23 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-08-23 21:41:00","insp_carrier_name":"NORBERT E MITCHELL CO INC","insp_carrier_street":"7 FEDERAL RD","insp_carrier_city":"DANBURY","insp_carrier_state":"CT","insp_carrier_zip_code":"06810","insp_colonia":null,"docket_number":"263035","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:47:14.000000Z","updated_at":"2025-03-17T18:47:14.000000Z","inspection_violations":[{"id":1746807,"change_date":"2022-08-23 21:41:00","inspection_id":"76404572","insp_violation_id":"247912751","seq_no":"1","part_no":"393","part_no_section":"55(d)(3)","insp_viol_unit":"2","insp_unit_id":"190479352","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:09.000000Z","updated_at":"2025-03-17T21:15:09.000000Z","normalized_code":"39355D3"}],"inspection_per_units":[{"id":1783358,"change_date":"2022-08-23 21:41:00","inspection_id":"76404572","insp_unit_id":"190479351","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"F12","insp_unit_license":"63832A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3WKDD49X8KF259046","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:16.000000Z","updated_at":"2025-03-17T22:19:16.000000Z"},{"id":1783359,"change_date":"2022-08-23 21:41:00","inspection_id":"76404572","insp_unit_id":"190479352","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"COUI","insp_unit_company":"G21","insp_unit_license":"AH50508","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1Z9M1AA23JA448275","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:16.000000Z","updated_at":"2025-03-17T22:19:16.000000Z"}]},{"id":869783,"change_date":"2022-07-22 21:39:00","inspection_id":"76125097","dot_number":"328526","report_state":"CT","report_number":"3119001363","insp_date":"2022-07-22 00:00:00","insp_start_time":"0937","insp_end_time":"1155","registration_date":null,"region":"ET","ci_status_code":"C","location":"034S","location_desc":"DANBURY SCALE","county_code_state":"CT","county_code":"001","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CRESTWOOD MIDSTREAM PARTNERS","shipping_paper_number":"000047264","cargo_tank":"331","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"98593","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":"649530","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":"00328526","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-07-22 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-07-22 21:39:00","insp_carrier_name":"NORBERT E MITCHELL CO INC","insp_carrier_street":"7 FEDERAL RD","insp_carrier_city":"DANBURY","insp_carrier_state":"CT","insp_carrier_zip_code":"06810","insp_colonia":null,"docket_number":"263035","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:43:02.000000Z","updated_at":"2025-03-17T18:43:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1400224,"change_date":"2022-07-22 21:39:00","inspection_id":"76125097","insp_unit_id":"189908840","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"FT12","insp_unit_license":"63832A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3WKDD49X8KF259046","insp_unit_decal":"Y","insp_unit_decal_number":"31730685","created_at":"2025-03-17T22:16:48.000000Z","updated_at":"2025-03-17T22:16:48.000000Z"},{"id":1400225,"change_date":"2022-07-22 21:39:00","inspection_id":"76125097","insp_unit_id":"189908841","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"COUI","insp_unit_company":"G12","insp_unit_license":"AH50508","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1Z9M1AA23JA448275","insp_unit_decal":"Y","insp_unit_decal_number":"31730686","created_at":"2025-03-17T22:16:48.000000Z","updated_at":"2025-03-17T22:16:48.000000Z"}]},{"id":285081,"change_date":"2022-04-29 21:40:00","inspection_id":"75433317","dot_number":"328526","report_state":"NY","report_number":"SPK0136164","insp_date":"2022-04-26 00:00:00","insp_start_time":"1045","insp_end_time":"1115","registration_date":null,"region":"ET","ci_status_code":"C","location":"80789A","location_desc":"SOUTHEAST (NB)","county_code_state":"NY","county_code":"079","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-29 21:40: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":"2700490","transaction_code":"A","transaction_date":"2022-04-29 00:00:00","upload_date":"2022-04-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00328526","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-04-29 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-04-29 21:40:00","insp_carrier_name":"NORBERT E MITCHELL CO INC","insp_carrier_street":"7 FEDERAL RD","insp_carrier_city":"DANBURY","insp_carrier_state":"CT","insp_carrier_zip_code":"06810","insp_colonia":null,"docket_number":"263035","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:32:34.000000Z","updated_at":"2025-03-17T18:32:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":461482,"change_date":"2022-04-29 21:40:00","inspection_id":"75433317","insp_unit_id":"188416990","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"F10","insp_unit_license":"9951A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1XKDDU9X91J880015","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:02.000000Z","updated_at":"2025-03-17T22:11:02.000000Z"},{"id":461483,"change_date":"2022-04-29 21:40:00","inspection_id":"75433317","insp_unit_id":"188416991","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"G17","insp_unit_license":"W15013","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1A9ST31297G040021","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:02.000000Z","updated_at":"2025-03-17T22:11:02.000000Z"}]},{"id":116082,"change_date":"2022-04-12 21:42:00","inspection_id":"75229462","dot_number":"328526","report_state":"CT","report_number":"3027000432","insp_date":"2022-04-04 00:00:00","insp_start_time":"1648","insp_end_time":"1721","registration_date":"2022-04-12 00:00:00","region":"ET","ci_status_code":"C","location":"034S","location_desc":"DANBURY SCALE","county_code_state":"CT","county_code":"001","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"9339456","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"641429","transaction_code":"C","transaction_date":"2022-04-04 00:00:00","upload_date":"2022-04-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00328526","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-04-04 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-04-06 21:40:00","insp_carrier_name":"NORBERT E MITCHELL CO INC","insp_carrier_street":"7 FEDERAL RD","insp_carrier_city":"DANBURY","insp_carrier_state":"CT","insp_carrier_zip_code":"06810","insp_colonia":null,"docket_number":"263035","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:29:31.000000Z","updated_at":"2025-03-17T18:29:31.000000Z","inspection_violations":[{"id":171459,"change_date":"2022-04-12 21:42:00","inspection_id":"75229462","insp_violation_id":"245090426","seq_no":"1","part_no":"393","part_no_section":"55(d)(2)","insp_viol_unit":"1","insp_unit_id":"188097036","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:51.000000Z","updated_at":"2025-03-17T21:07:51.000000Z","normalized_code":"39355D2"}],"inspection_per_units":[{"id":187880,"change_date":"2022-04-12 21:42:00","inspection_id":"75229462","insp_unit_id":"188097036","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"D12","insp_unit_license":"52453A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1HTMKAANX2H531189","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:21.000000Z","updated_at":"2025-03-17T22:09:21.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/328526\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/328526\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/328526\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next »","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/searchcarriers.com\/company\/328526\/inspections","per_page":100,"prev_page_url":null,"to":40,"total":40}