{"current_page":1,"data":[{"id":12159358,"change_date":"2026-06-11 21:41:00","inspection_id":"88108995","dot_number":"3266135","report_state":"CT","report_number":"3070007987","insp_date":"2026-06-11 00:00:00","insp_start_time":"0436","insp_end_time":"0450","registration_date":null,"region":"ES","ci_status_code":"C","location":"084","location_desc":"CT","county_code_state":"CT","county_code":"009","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"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":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26995","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":"3518886","transaction_code":"A","transaction_date":"2026-06-11 00:00:00","upload_date":"2026-06-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03266135","upload_search_indicator":null,"census_search_date":"2026-06-11 21:41:00","snet_input_date":"2026-06-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-11 21:41:00","insp_carrier_name":"ALX PRODUCTS AND SERVICES LLC","insp_carrier_street":"69 TALCOTT RD","insp_carrier_city":"WEST HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06110-1227","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-15T09:41:30.000000Z","updated_at":"2026-06-22T09:30:41.000000Z","inspection_violations":[{"id":21162666,"change_date":"2026-06-11 21:41:00","inspection_id":"88108995","insp_violation_id":"274841285","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":"2026-06-15T10:02:44.000000Z","updated_at":"2026-06-22T09:42:26.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":21121745,"change_date":"2026-06-11 21:41:00","inspection_id":"88108995","insp_unit_id":"214036900","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"VERN","insp_unit_company":null,"insp_unit_license":"BL14949","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1VRN1312831003005","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-15T09:19:20.000000Z","updated_at":"2026-06-22T09:01:43.000000Z"},{"id":21121744,"change_date":"2026-06-11 21:41:00","inspection_id":"88108995","insp_unit_id":"214036899","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BM68873","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FDFF6LT7RDA04484","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-15T09:19:20.000000Z","updated_at":"2026-06-22T09:01:43.000000Z"}]},{"id":12112130,"change_date":"2026-06-06 21:37:00","inspection_id":"88057103","dot_number":"3266135","report_state":"CT","report_number":"3010005133","insp_date":"2026-06-05 00:00:00","insp_start_time":"0930","insp_end_time":"1040","registration_date":null,"region":"ES","ci_status_code":"C","location":"077","location_desc":"CT","county_code_state":"CT","county_code":"003","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"ALX PRODUCTS AND SERVICES LL","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-06 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"11","oos_total":"4","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"10","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3477749","transaction_code":"A","transaction_date":"2026-06-06 00:00:00","upload_date":"2026-06-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03266135","upload_search_indicator":null,"census_search_date":"2026-06-06 21:37:00","snet_input_date":"2026-06-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-06 21:37:00","insp_carrier_name":"ALX PRODUCTS AND SERVICES LLC","insp_carrier_street":"69 TALCOTT RD","insp_carrier_city":"WEST HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06110-1227","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-09T09:40:48.000000Z","updated_at":"2026-06-17T09:30:10.000000Z","inspection_violations":[{"id":21080175,"change_date":"2026-06-06 21:37:00","inspection_id":"88057103","insp_violation_id":"274730882","seq_no":"1","part_no":"391","part_no_section":"11B2-Q","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"54","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"V139024-6","created_at":"2026-06-09T09:59:56.000000Z","updated_at":"2026-06-17T09:42:03.000000Z","normalized_code":"39111B2Q"},{"id":21080176,"change_date":"2026-06-06 21:37:00","inspection_id":"88057103","insp_violation_id":"274730883","seq_no":"2","part_no":"396","part_no_section":"3A1-HCM","insp_viol_unit":"1","insp_unit_id":"213941799","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-09T09:59:56.000000Z","updated_at":"2026-06-17T09:42:03.000000Z","normalized_code":"3963A1HCM"},{"id":21080177,"change_date":"2026-06-06 21:37:00","inspection_id":"88057103","insp_violation_id":"274730884","seq_no":"3","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"213941799","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-09T09:59:56.000000Z","updated_at":"2026-06-17T09:42:03.000000Z","normalized_code":"39617CPI"},{"id":21080178,"change_date":"2026-06-06 21:37:00","inspection_id":"88057103","insp_violation_id":"274730885","seq_no":"4","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"2","insp_unit_id":"213941800","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-09T09:59:56.000000Z","updated_at":"2026-06-17T09:42:03.000000Z","normalized_code":"3922SLLEQP"},{"id":21080179,"change_date":"2026-06-06 21:37:00","inspection_id":"88057103","insp_violation_id":"274730886","seq_no":"5","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"2","insp_unit_id":"213941800","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-09T09:59:56.000000Z","updated_at":"2026-06-17T09:42:03.000000Z","normalized_code":"3939ALSML"},{"id":21080180,"change_date":"2026-06-06 21:37:00","inspection_id":"88057103","insp_violation_id":"274730887","seq_no":"6","part_no":"393","part_no_section":"43D-B","insp_viol_unit":"2","insp_unit_id":"213941800","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"V139024-6","created_at":"2026-06-09T09:59:56.000000Z","updated_at":"2026-06-17T09:42:03.000000Z","normalized_code":"39343DB"},{"id":21080181,"change_date":"2026-06-06 21:37:00","inspection_id":"88057103","insp_violation_id":"274730888","seq_no":"7","part_no":"393","part_no_section":"48A-BIHE","insp_viol_unit":"2","insp_unit_id":"213941800","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-09T09:59:56.000000Z","updated_at":"2026-06-17T09:42:03.000000Z","normalized_code":"39348ABIHE"},{"id":21080182,"change_date":"2026-06-06 21:37:00","inspection_id":"88057103","insp_violation_id":"274730889","seq_no":"8","part_no":"393","part_no_section":"48A-BIHE","insp_viol_unit":"2","insp_unit_id":"213941800","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-09T09:59:56.000000Z","updated_at":"2026-06-17T09:42:03.000000Z","normalized_code":"39348ABIHE"},{"id":21080183,"change_date":"2026-06-06 21:37:00","inspection_id":"88057103","insp_violation_id":"274730890","seq_no":"9","part_no":"393","part_no_section":"75A1-TAORETA","insp_viol_unit":"2","insp_unit_id":"213941800","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"V139024-6","created_at":"2026-06-09T09:59:56.000000Z","updated_at":"2026-06-17T09:42:03.000000Z","normalized_code":"39375A1TAORETA"},{"id":21080184,"change_date":"2026-06-06 21:37:00","inspection_id":"88057103","insp_violation_id":"274730891","seq_no":"10","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"1","insp_unit_id":"213941799","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"V139024-6","created_at":"2026-06-09T09:59:56.000000Z","updated_at":"2026-06-17T09:42:03.000000Z","normalized_code":"3963A1BOS"},{"id":21080185,"change_date":"2026-06-06 21:37:00","inspection_id":"88057103","insp_violation_id":"274730892","seq_no":"11","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"213941800","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-09T09:59:56.000000Z","updated_at":"2026-06-17T09:42:03.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":21044170,"change_date":"2026-06-06 21:37:00","inspection_id":"88057103","insp_unit_id":"213941799","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BX44782","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3FRNF7FC2DV025982","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-09T09:17:13.000000Z","updated_at":"2026-06-17T09:01:12.000000Z"},{"id":21044171,"change_date":"2026-06-06 21:37:00","inspection_id":"88057103","insp_unit_id":"213941800","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VERN","insp_unit_company":null,"insp_unit_license":"AY51534","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1VRU1614851002079","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-09T09:17:13.000000Z","updated_at":"2026-06-17T09:01:12.000000Z"}]},{"id":11691606,"change_date":"2026-06-04 21:45:00","inspection_id":"87617663","dot_number":"3266135","report_state":"CT","report_number":"0511000846","insp_date":"2026-04-18 00:00:00","insp_start_time":"0931","insp_end_time":"0956","registration_date":"2026-06-01 00:00:00","region":"ED","ci_status_code":"C","location":"061","location_desc":"CT","county_code_state":"CT","county_code":"007","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"ALX PRODUCTS","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-04-20 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"4","oos_total":"3","driver_viol_total":"3","driver_oos_total":"3","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3457668","transaction_code":"C","transaction_date":"2026-06-04 00:00:00","upload_date":"2026-06-04 00:00:00","upload_first_byte":"0","upload_dot_number":"03266135","upload_search_indicator":null,"census_search_date":"2026-04-20 21:37:00","snet_input_date":"2026-04-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-20 21:37:00","insp_carrier_name":"ALX PRODUCTS AND SERVICES LLC","insp_carrier_street":"69 TALCOTT RD","insp_carrier_city":"WEST HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06110","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:35:11.000000Z","updated_at":"2026-06-16T09:30:04.000000Z","inspection_violations":[{"id":20312566,"change_date":"2026-06-04 21:45:00","inspection_id":"87617663","insp_violation_id":"274678219","seq_no":"4","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"213899542","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:50:14.000000Z","updated_at":"2026-06-16T09:44:09.000000Z","normalized_code":"3939ALIL"},{"id":20312563,"change_date":"2026-06-04 21:45:00","inspection_id":"87617663","insp_violation_id":"274678216","seq_no":"1","part_no":"391","part_no_section":"11B2-Q","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"54","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"Z536225-3","created_at":"2026-04-27T09:50:14.000000Z","updated_at":"2026-06-16T09:44:09.000000Z","normalized_code":"39111B2Q"},{"id":20312564,"change_date":"2026-06-04 21:45:00","inspection_id":"87617663","insp_violation_id":"274678217","seq_no":"2","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"Z536225-3","created_at":"2026-04-27T09:50:14.000000Z","updated_at":"2026-06-16T09:44:09.000000Z","normalized_code":"39141APC"},{"id":20312565,"change_date":"2026-06-04 21:45:00","inspection_id":"87617663","insp_violation_id":"274678218","seq_no":"3","part_no":"391","part_no_section":"11B5-LNCDLNVL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"54","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"Z536225-3","created_at":"2026-04-27T09:50:14.000000Z","updated_at":"2026-06-16T09:44:09.000000Z","normalized_code":"39111B5LNCDLNVL"}],"inspection_per_units":[{"id":20347603,"change_date":"2026-06-04 21:45:00","inspection_id":"87617663","insp_unit_id":"213899542","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"COURIER","insp_unit_company":null,"insp_unit_license":"BX44782","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3FRNF7FC2DV025982","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:10:20.000000Z","updated_at":"2026-06-16T09:01:08.000000Z"}]},{"id":11422204,"change_date":"2026-03-20 21:39:00","inspection_id":"87337987","dot_number":"3266135","report_state":"PA","report_number":"M045000142","insp_date":"2026-03-18 00:00:00","insp_start_time":"0933","insp_end_time":"1012","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"SEWICKLEY PA","county_code_state":"PA","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"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":"2026-03-20 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"4","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3028059","transaction_code":"A","transaction_date":"2026-03-19 00:00:00","upload_date":"2026-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03266135","upload_search_indicator":null,"census_search_date":"2026-03-20 21:39:00","snet_input_date":"2026-03-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-20 21:39:00","insp_carrier_name":"ALX PRODUCTS AND SERVICES LLC","insp_carrier_street":"69 TALCOTT RD","insp_carrier_city":"WEST HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06110-1227","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-23T09:46:29.000000Z","updated_at":"2026-03-31T09:30:20.000000Z","inspection_violations":[{"id":19268541,"change_date":"2026-03-20 21:39:00","inspection_id":"87337987","insp_violation_id":"272511745","seq_no":"1","part_no":"391","part_no_section":"11B2-Q","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"54","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"E-CITATION","created_at":"2026-03-23T10:13:19.000000Z","updated_at":"2026-03-31T09:48:10.000000Z","normalized_code":"39111B2Q"},{"id":19268542,"change_date":"2026-03-20 21:39:00","inspection_id":"87337987","insp_violation_id":"272511746","seq_no":"2","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"212229993","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"E-CITATION","created_at":"2026-03-23T10:13:19.000000Z","updated_at":"2026-03-31T09:48:10.000000Z","normalized_code":"3922SLLEQP"},{"id":19268543,"change_date":"2026-03-20 21:39:00","inspection_id":"87337987","insp_violation_id":"272511747","seq_no":"3","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"212229993","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"E-CITATION","created_at":"2026-03-23T10:13:19.000000Z","updated_at":"2026-03-31T09:48:10.000000Z","normalized_code":"39617CPI"},{"id":19268544,"change_date":"2026-03-20 21:39:00","inspection_id":"87337987","insp_violation_id":"272511748","seq_no":"4","part_no":"392","part_no_section":"2-SLLS3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"E-CITATION","created_at":"2026-03-23T10:13:19.000000Z","updated_at":"2026-03-31T09:48:10.000000Z","normalized_code":"3922SLLS3"}],"inspection_per_units":[{"id":19566912,"change_date":"2026-03-20 21:39:00","inspection_id":"87337987","insp_unit_id":"212229993","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"12","insp_unit_license":"BA90027","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3FRWF75D38V645017","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-23T09:29:55.000000Z","updated_at":"2026-03-31T09:08:06.000000Z"}]},{"id":10771735,"change_date":"2026-02-19 21:39:00","inspection_id":"86796960","dot_number":"3266135","report_state":"CT","report_number":"0511000739","insp_date":"2026-01-15 00:00:00","insp_start_time":"0759","insp_end_time":"0827","registration_date":"2026-02-19 00:00:00","region":"ET","ci_status_code":"C","location":"146","location_desc":"VERNON","county_code_state":"CT","county_code":"013","insp_level_id":"2","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-01-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"22000","viol_total":"6","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"763477","transaction_code":"C","transaction_date":"2026-01-15 00:00:00","upload_date":"2026-02-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03266135","upload_search_indicator":null,"census_search_date":"2026-01-15 21:40:00","snet_input_date":"2026-01-15 00:00:00","source_office":"1CTS001","mcmis_add_date":"2026-01-15 21:40:00","insp_carrier_name":"ALX PRODUCTS AND SERVICES LLC","insp_carrier_street":"69 TALCOTT RD","insp_carrier_city":"WEST HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06110","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-18T10:44:07.000000Z","updated_at":"2026-03-02T10:30:45.000000Z","inspection_violations":[{"id":18717890,"change_date":"2026-02-19 21:39:00","inspection_id":"86796960","insp_violation_id":"271882582","seq_no":"1","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"211696831","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-22T10:53:01.000000Z","updated_at":"2026-03-02T10:40:06.000000Z","normalized_code":"3939ALHLI"},{"id":18717891,"change_date":"2026-02-19 21:39:00","inspection_id":"86796960","insp_violation_id":"271882583","seq_no":"2","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"211696831","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-22T10:53:01.000000Z","updated_at":"2026-03-02T10:40:06.000000Z","normalized_code":"39395A1"},{"id":18717892,"change_date":"2026-02-19 21:39:00","inspection_id":"86796960","insp_violation_id":"271882584","seq_no":"3","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"211696831","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-22T10:53:01.000000Z","updated_at":"2026-03-02T10:40:06.000000Z","normalized_code":"3922SLLSR"},{"id":18717893,"change_date":"2026-02-19 21:39:00","inspection_id":"86796960","insp_violation_id":"271882585","seq_no":"5","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"211696831","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-22T10:53:01.000000Z","updated_at":"2026-03-02T10:40:06.000000Z","normalized_code":"3922SLLUCR"},{"id":18717894,"change_date":"2026-02-19 21:39:00","inspection_id":"86796960","insp_violation_id":"271882586","seq_no":"6","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":"2026-02-22T10:53:01.000000Z","updated_at":"2026-03-02T10:40:06.000000Z","normalized_code":"3928D"},{"id":18717895,"change_date":"2026-02-19 21:39:00","inspection_id":"86796960","insp_violation_id":"271882587","seq_no":"4","part_no":"392","part_no_section":"2-SLLSIV","insp_viol_unit":"1","insp_unit_id":"211696831","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-22T10:53:01.000000Z","updated_at":"2026-03-02T10:40:06.000000Z","normalized_code":"3922SLLSIV"}],"inspection_per_units":[{"id":19052391,"change_date":"2026-02-19 21:39:00","inspection_id":"86796960","insp_unit_id":"211696831","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BM68873","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FDFF6LT7RDA04484","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-22T10:13:18.000000Z","updated_at":"2026-03-02T10:03:32.000000Z"}]},{"id":10648326,"change_date":"2026-02-20 21:38:00","inspection_id":"86790117","dot_number":"3266135","report_state":"MA","report_number":"DD00002739","insp_date":"2026-01-14 00:00:00","insp_start_time":"0828","insp_end_time":"0910","registration_date":"2026-02-20 00:00:00","region":"ET","ci_status_code":"C","location":"322H","location_desc":"H-STURBRIDGE","county_code_state":"MA","county_code":"027","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SELF\/SAME","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-01-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"35490","viol_total":"12","oos_total":"4","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"12","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"538367","transaction_code":"C","transaction_date":"2026-01-15 00:00:00","upload_date":"2026-02-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03266135","upload_search_indicator":"M","census_search_date":"2026-01-14 21:40:00","snet_input_date":"2026-01-14 00:00:00","source_office":"1MAS001","mcmis_add_date":"2026-01-14 21:40:00","insp_carrier_name":"ALX PRODUCTS AND SERVICES LLC","insp_carrier_street":"69 TALCOTT RD","insp_carrier_city":"WEST HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06110-1227","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-17T10:36:31.000000Z","updated_at":"2026-03-03T10:30:05.000000Z","inspection_violations":[{"id":18758233,"change_date":"2026-02-20 21:38:00","inspection_id":"86790117","insp_violation_id":"271919396","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"211731302","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-23T10:53:20.000000Z","updated_at":"2026-03-03T10:40:43.000000Z","normalized_code":"3922SLLSR"},{"id":18758234,"change_date":"2026-02-20 21:38:00","inspection_id":"86790117","insp_violation_id":"271919397","seq_no":"2","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"211731302","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-23T10:53:20.000000Z","updated_at":"2026-03-03T10:40:43.000000Z","normalized_code":"39395A4EEUS"},{"id":18758235,"change_date":"2026-02-20 21:38:00","inspection_id":"86790117","insp_violation_id":"271919398","seq_no":"3","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"211731302","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-23T10:53:20.000000Z","updated_at":"2026-03-03T10:40:43.000000Z","normalized_code":"39395A1"},{"id":18758236,"change_date":"2026-02-20 21:38:00","inspection_id":"86790117","insp_violation_id":"271919399","seq_no":"4","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"211731302","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-23T10:53:20.000000Z","updated_at":"2026-03-03T10:40:43.000000Z","normalized_code":"3939ALIL"},{"id":18758237,"change_date":"2026-02-20 21:38:00","inspection_id":"86790117","insp_violation_id":"271919400","seq_no":"5","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"211731302","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-23T10:53:20.000000Z","updated_at":"2026-03-03T10:40:43.000000Z","normalized_code":"3939ALCL"},{"id":18758238,"change_date":"2026-02-20 21:38:00","inspection_id":"86790117","insp_violation_id":"271919401","seq_no":"6","part_no":"396","part_no_section":"5B-HWSL","insp_viol_unit":"1","insp_unit_id":"211731302","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-02-23T10:53:20.000000Z","updated_at":"2026-03-03T10:40:43.000000Z","normalized_code":"3965BHWSL"},{"id":18758239,"change_date":"2026-02-20 21:38:00","inspection_id":"86790117","insp_violation_id":"271919402","seq_no":"7","part_no":"393","part_no_section":"47A-BCFSHE-SA","insp_viol_unit":"1","insp_unit_id":"211731302","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-02-23T10:53:20.000000Z","updated_at":"2026-03-03T10:40:43.000000Z","normalized_code":"39347ABCFSHESA"},{"id":18758240,"change_date":"2026-02-20 21:38:00","inspection_id":"86790117","insp_violation_id":"271919403","seq_no":"8","part_no":"396","part_no_section":"3A1-F","insp_viol_unit":"1","insp_unit_id":"211731302","insp_violation_category_id":"18","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-02-23T10:53:20.000000Z","updated_at":"2026-03-03T10:40:43.000000Z","normalized_code":"3963A1F"},{"id":18758241,"change_date":"2026-02-20 21:38:00","inspection_id":"86790117","insp_violation_id":"271919404","seq_no":"9","part_no":"396","part_no_section":"3A1-DLDSUJBCB","insp_viol_unit":"1","insp_unit_id":"211731302","insp_violation_category_id":"17","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-02-23T10:53:20.000000Z","updated_at":"2026-03-03T10:40:43.000000Z","normalized_code":"3963A1DLDSUJBCB"},{"id":18758242,"change_date":"2026-02-20 21:38:00","inspection_id":"86790117","insp_violation_id":"271919405","seq_no":"10","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"211731302","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-23T10:53:20.000000Z","updated_at":"2026-03-03T10:40:43.000000Z","normalized_code":"39378AWS"},{"id":18758243,"change_date":"2026-02-20 21:38:00","inspection_id":"86790117","insp_violation_id":"271919406","seq_no":"11","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"211731302","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-23T10:53:20.000000Z","updated_at":"2026-03-03T10:40:43.000000Z","normalized_code":"39617CPI"},{"id":18758244,"change_date":"2026-02-20 21:38:00","inspection_id":"86790117","insp_violation_id":"271919407","seq_no":"12","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"211731303","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-23T10:53:20.000000Z","updated_at":"2026-03-03T10:40:43.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":19095001,"change_date":"2026-02-20 21:38:00","inspection_id":"86790117","insp_unit_id":"211731303","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DTET","insp_unit_company":null,"insp_unit_license":"BW43402","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1XNBC2029T3125411","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-23T10:13:20.000000Z","updated_at":"2026-03-03T10:03:21.000000Z"},{"id":19095000,"change_date":"2026-02-20 21:38:00","inspection_id":"86790117","insp_unit_id":"211731302","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"11","insp_unit_license":"AE51716","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FVABPCT81DJ25968","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-23T10:13:20.000000Z","updated_at":"2026-03-03T10:03:21.000000Z"}]},{"id":8877392,"change_date":"2025-07-03 21:33:00","inspection_id":"84928601","dot_number":"3266135","report_state":"CT","report_number":"3010004298","insp_date":"2025-06-12 00:00:00","insp_start_time":"1012","insp_end_time":"1045","registration_date":"2025-07-03 00:00:00","region":"ET","ci_status_code":"C","location":"165","location_desc":"WINDSOR LOCKS","county_code_state":"CT","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"4","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"742835","transaction_code":"C","transaction_date":"2025-06-12 00:00:00","upload_date":"2025-07-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03266135","upload_search_indicator":null,"census_search_date":"2025-06-12 21:40:00","snet_input_date":"2025-06-12 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-06-12 21:40:00","insp_carrier_name":"ALX PRODUCTS AND SERVICES LLC","insp_carrier_street":"69 TALCOTT RD","insp_carrier_city":"WEST HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06110","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-15T10:00:57.000000Z","updated_at":"2025-07-07T10:07:29.000000Z","inspection_violations":[{"id":14569617,"change_date":"2025-07-03 21:33:00","inspection_id":"84928601","insp_violation_id":"267185935","seq_no":"1","part_no":"383","part_no_section":"95A-LCDL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-06T10:16:44.000000Z","updated_at":"2025-07-07T10:15:07.000000Z","normalized_code":"38395ALCDL"},{"id":14569618,"change_date":"2025-07-03 21:33:00","inspection_id":"84928601","insp_violation_id":"267185936","seq_no":"2","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"207686458","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-06T10:16:44.000000Z","updated_at":"2025-07-07T10:15:07.000000Z","normalized_code":"39378AWS"},{"id":14569619,"change_date":"2025-07-03 21:33:00","inspection_id":"84928601","insp_violation_id":"267185937","seq_no":"3","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"207686458","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-06T10:16:44.000000Z","updated_at":"2025-07-07T10:15:07.000000Z","normalized_code":"39395A4EEUS"},{"id":14569620,"change_date":"2025-07-03 21:33:00","inspection_id":"84928601","insp_violation_id":"267185938","seq_no":"4","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"207686458","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-06T10:16:44.000000Z","updated_at":"2025-07-07T10:15:07.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":14856230,"change_date":"2025-07-03 21:33:00","inspection_id":"84928601","insp_unit_id":"207686458","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"11","insp_unit_license":"AE51716","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FVABPCT81DJ25968","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-06T09:46:16.000000Z","updated_at":"2025-07-07T09:45:06.000000Z"}]},{"id":8444136,"change_date":"2025-06-04 21:40:00","inspection_id":"84471495","dot_number":"3266135","report_state":"CT","report_number":"3076003278","insp_date":"2025-04-23 00:00:00","insp_start_time":"0801","insp_end_time":"0833","registration_date":"2025-06-04 00:00:00","region":"ET","ci_status_code":"C","location":"004","location_desc":"AVON","county_code_state":"CT","county_code":"003","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"NONE","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-04-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"738103","transaction_code":"C","transaction_date":"2025-05-19 00:00:00","upload_date":"2025-06-04 00:00:00","upload_first_byte":"0","upload_dot_number":"03266135","upload_search_indicator":null,"census_search_date":"2025-04-23 21:40:00","snet_input_date":"2025-04-23 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-04-23 21:40:00","insp_carrier_name":"ALX PRODUCTS AND SERVICES LLC","insp_carrier_street":"69 TALCOTT RD","insp_carrier_city":"WEST HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06110","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-26T10:27:38.000000Z","updated_at":"2025-06-09T10:00:03.000000Z","inspection_violations":[{"id":14093875,"change_date":"2025-06-04 21:40:00","inspection_id":"84471495","insp_violation_id":"266646251","seq_no":"1","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"207210950","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-07T10:16:35.000000Z","updated_at":"2025-06-08T10:16:34.000000Z","normalized_code":"39021TB1MC"},{"id":14093876,"change_date":"2025-06-04 21:40:00","inspection_id":"84471495","insp_violation_id":"266646252","seq_no":"2","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"207210950","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-07T10:16:35.000000Z","updated_at":"2025-06-08T10:16:34.000000Z","normalized_code":"39395A1"}],"inspection_per_units":[{"id":14418990,"change_date":"2025-06-04 21:40:00","inspection_id":"84471495","insp_unit_id":"207210950","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BX44782","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3FRNF7FC2DV025982","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-07T09:46:08.000000Z","updated_at":"2025-06-08T09:45:03.000000Z"}]},{"id":6501090,"change_date":"2024-08-19 21:42:00","inspection_id":"82419847","dot_number":"3266135","report_state":"MA","report_number":"DQ00001169","insp_date":"2024-08-17 00:00:00","insp_start_time":"0800","insp_end_time":"0826","registration_date":null,"region":"ET","ci_status_code":"C","location":"370H","location_desc":"H-WESTON","county_code_state":"MA","county_code":"017","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-19 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"28400","viol_total":"9","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"497807","transaction_code":"A","transaction_date":"2024-08-19 00:00:00","upload_date":"2024-08-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03266135","upload_search_indicator":"M","census_search_date":"2024-08-19 21:42:00","snet_input_date":"2024-08-17 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-08-19 21:42:00","insp_carrier_name":"ALX PRODUCTS AND SERVICES LLC","insp_carrier_street":"69 TALCOTT RD","insp_carrier_city":"WEST HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06110-1227","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:31:55.000000Z","updated_at":"2025-03-17T20:31:55.000000Z","inspection_violations":[{"id":10096594,"change_date":"2024-08-19 21:42:00","inspection_id":"82419847","insp_violation_id":"261263949","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:54:49.000000Z","updated_at":"2025-03-17T21:54:49.000000Z","normalized_code":"3922"},{"id":10096595,"change_date":"2024-08-19 21:42:00","inspection_id":"82419847","insp_violation_id":"261263950","seq_no":"2","part_no":"392","part_no_section":"16(b)","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:54:49.000000Z","updated_at":"2025-03-17T21:54:49.000000Z","normalized_code":"39216B"},{"id":10096596,"change_date":"2024-08-19 21:42:00","inspection_id":"82419847","insp_violation_id":"261263951","seq_no":"3","part_no":"391","part_no_section":"11(b)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:49.000000Z","updated_at":"2025-03-17T21:54:49.000000Z","normalized_code":"39111B2"},{"id":10096597,"change_date":"2024-08-19 21:42:00","inspection_id":"82419847","insp_violation_id":"261263952","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202459493","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:49.000000Z","updated_at":"2025-03-17T21:54:49.000000Z","normalized_code":"3922"},{"id":10096598,"change_date":"2024-08-19 21:42:00","inspection_id":"82419847","insp_violation_id":"261263953","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"202459494","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:49.000000Z","updated_at":"2025-03-17T21:54:49.000000Z","normalized_code":"3922"},{"id":10096599,"change_date":"2024-08-19 21:42:00","inspection_id":"82419847","insp_violation_id":"261263954","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"202459494","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:49.000000Z","updated_at":"2025-03-17T21:54:49.000000Z","normalized_code":"3922"},{"id":10096600,"change_date":"2024-08-19 21:42:00","inspection_id":"82419847","insp_violation_id":"261263955","seq_no":"7","part_no":"396","part_no_section":"9(d)(2)","insp_viol_unit":"2","insp_unit_id":"202459494","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:49.000000Z","updated_at":"2025-03-17T21:54:49.000000Z","normalized_code":"3969D2"},{"id":10096601,"change_date":"2024-08-19 21:42:00","inspection_id":"82419847","insp_violation_id":"261263956","seq_no":"8","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"202459494","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:49.000000Z","updated_at":"2025-03-17T21:54:49.000000Z","normalized_code":"39617C"},{"id":10096602,"change_date":"2024-08-19 21:42:00","inspection_id":"82419847","insp_violation_id":"261263957","seq_no":"9","part_no":"396","part_no_section":"9(d)(2)","insp_viol_unit":"2","insp_unit_id":"202459494","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:49.000000Z","updated_at":"2025-03-17T21:54:49.000000Z","normalized_code":"3969D2"}],"inspection_per_units":[{"id":10479577,"change_date":"2024-08-19 21:42:00","inspection_id":"82419847","insp_unit_id":"202459493","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BA90600","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FDFF6LT1NDA04782","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:32.000000Z","updated_at":"2025-03-17T23:31:32.000000Z"},{"id":10479578,"change_date":"2024-08-19 21:42:00","inspection_id":"82419847","insp_unit_id":"202459494","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"VERN","insp_unit_company":null,"insp_unit_license":"AY51534","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1VRU1614851002079","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:32.000000Z","updated_at":"2025-03-17T23:31:32.000000Z"}]},{"id":6098377,"change_date":"2024-07-30 21:42:00","inspection_id":"81988412","dot_number":"3266135","report_state":"CT","report_number":"3019005507","insp_date":"2024-06-28 00:00:00","insp_start_time":"0602","insp_end_time":"0701","registration_date":"2024-07-30 00:00:00","region":"ET","ci_status_code":"C","location":"052","location_desc":"FARMINGTON","county_code_state":"CT","county_code":"003","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-28 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"27495","viol_total":"16","oos_total":"5","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"14","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"711361","transaction_code":"C","transaction_date":"2024-06-28 00:00:00","upload_date":"2024-07-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03266135","upload_search_indicator":null,"census_search_date":"2024-06-28 21:38:00","snet_input_date":"2024-06-28 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-06-28 21:38:00","insp_carrier_name":"ALX PRODUCTS AND SERVICES LLC","insp_carrier_street":"69 TALCOTT RD","insp_carrier_city":"WEST HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06110","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:23:25.000000Z","updated_at":"2025-03-17T20:23:25.000000Z","inspection_violations":[{"id":9465500,"change_date":"2024-07-30 21:42:00","inspection_id":"81988412","insp_violation_id":"260905008","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"V128589-1","created_at":"2025-03-17T21:51:50.000000Z","updated_at":"2025-03-17T21:51:50.000000Z","normalized_code":"38323A2"},{"id":9465501,"change_date":"2024-07-30 21:42:00","inspection_id":"81988412","insp_violation_id":"260905009","seq_no":"2","part_no":"392","part_no_section":"7(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:50.000000Z","updated_at":"2025-03-17T21:51:50.000000Z","normalized_code":"3927A"},{"id":9465502,"change_date":"2024-07-30 21:42:00","inspection_id":"81988412","insp_violation_id":"260905010","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"202133231","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:50.000000Z","updated_at":"2025-03-17T21:51:50.000000Z","normalized_code":"39617C"},{"id":9465503,"change_date":"2024-07-30 21:42:00","inspection_id":"81988412","insp_violation_id":"260905011","seq_no":"4","part_no":"393","part_no_section":"55(b)","insp_viol_unit":"1","insp_unit_id":"202133231","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:50.000000Z","updated_at":"2025-03-17T21:51:50.000000Z","normalized_code":"39355B"},{"id":9465504,"change_date":"2024-07-30 21:42:00","inspection_id":"81988412","insp_violation_id":"260905012","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"202133231","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":"V128590-2","created_at":"2025-03-17T21:51:50.000000Z","updated_at":"2025-03-17T21:51:50.000000Z","normalized_code":"3963A1"},{"id":9465505,"change_date":"2024-07-30 21:42:00","inspection_id":"81988412","insp_violation_id":"260905013","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202133231","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:50.000000Z","updated_at":"2025-03-17T21:51:50.000000Z","normalized_code":"3939A"},{"id":9465506,"change_date":"2024-07-30 21:42:00","inspection_id":"81988412","insp_violation_id":"260905014","seq_no":"7","part_no":"393","part_no_section":"41","insp_viol_unit":"1","insp_unit_id":"202133231","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:51:50.000000Z","updated_at":"2025-03-17T21:51:50.000000Z","normalized_code":"39341"},{"id":9465507,"change_date":"2024-07-30 21:42:00","inspection_id":"81988412","insp_violation_id":"260905015","seq_no":"8","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"202133232","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:51:50.000000Z","updated_at":"2025-03-17T21:51:50.000000Z","normalized_code":"3939A"},{"id":9465508,"change_date":"2024-07-30 21:42:00","inspection_id":"81988412","insp_violation_id":"260905016","seq_no":"9","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"202133232","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:50.000000Z","updated_at":"2025-03-17T21:51:50.000000Z","normalized_code":"3922"},{"id":9465509,"change_date":"2024-07-30 21:42:00","inspection_id":"81988412","insp_violation_id":"260905017","seq_no":"10","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"202133232","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:50.000000Z","updated_at":"2025-03-17T21:51:50.000000Z","normalized_code":"39348A"},{"id":9465510,"change_date":"2024-07-30 21:42:00","inspection_id":"81988412","insp_violation_id":"260905018","seq_no":"11","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"202133232","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:50.000000Z","updated_at":"2025-03-17T21:51:50.000000Z","normalized_code":"39348A"},{"id":9465511,"change_date":"2024-07-30 21:42:00","inspection_id":"81988412","insp_violation_id":"260905019","seq_no":"12","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"202133232","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:50.000000Z","updated_at":"2025-03-17T21:51:50.000000Z","normalized_code":"39348A"},{"id":9465512,"change_date":"2024-07-30 21:42:00","inspection_id":"81988412","insp_violation_id":"260905020","seq_no":"13","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"202133232","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:50.000000Z","updated_at":"2025-03-17T21:51:50.000000Z","normalized_code":"39348A"},{"id":9465513,"change_date":"2024-07-30 21:42:00","inspection_id":"81988412","insp_violation_id":"260905021","seq_no":"14","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"202133232","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:50.000000Z","updated_at":"2025-03-17T21:51:50.000000Z","normalized_code":"3939A"},{"id":9465514,"change_date":"2024-07-30 21:42:00","inspection_id":"81988412","insp_violation_id":"260905022","seq_no":"15","part_no":"393","part_no_section":"75(a)(1)","insp_viol_unit":"2","insp_unit_id":"202133232","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:51:50.000000Z","updated_at":"2025-03-17T21:51:50.000000Z","normalized_code":"39375A1"},{"id":9465515,"change_date":"2024-07-30 21:42:00","inspection_id":"81988412","insp_violation_id":"260905023","seq_no":"16","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"202133232","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:50.000000Z","updated_at":"2025-03-17T21:51:50.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":9822450,"change_date":"2024-07-30 21:42:00","inspection_id":"81988412","insp_unit_id":"202133231","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"BJ24229","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1GDE4C1254F511116","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:45.000000Z","updated_at":"2025-03-17T23:24:45.000000Z"},{"id":9822451,"change_date":"2024-07-30 21:42:00","inspection_id":"81988412","insp_unit_id":"202133232","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"APTM","insp_unit_company":null,"insp_unit_license":"AZ8400","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1A920029123B17507","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:45.000000Z","updated_at":"2025-03-17T23:24:45.000000Z"}]},{"id":6077091,"change_date":"2024-07-10 21:39:00","inspection_id":"81965507","dot_number":"3266135","report_state":"CT","report_number":"3019005505","insp_date":"2024-06-26 00:00:00","insp_start_time":"1326","insp_end_time":"1410","registration_date":"2024-07-10 00:00:00","region":"ET","ci_status_code":"C","location":"052","location_desc":"FARMINGTON","county_code_state":"CT","county_code":"003","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"DUNNING SAND","shipping_paper_number":"753381","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-06-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"10","oos_total":"1","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"711183","transaction_code":"C","transaction_date":"2024-06-26 00:00:00","upload_date":"2024-07-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03266135","upload_search_indicator":null,"census_search_date":"2024-06-26 21:42:00","snet_input_date":"2024-06-26 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-06-26 21:42:00","insp_carrier_name":"ALX PRODUCTS AND SERVICES LLC","insp_carrier_street":"69 TALCOTT RD","insp_carrier_city":"WEST HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06110","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:23:02.000000Z","updated_at":"2025-03-17T20:23:02.000000Z","inspection_violations":[{"id":9430841,"change_date":"2024-07-10 21:39:00","inspection_id":"81965507","insp_violation_id":"260554446","seq_no":"1","part_no":"391","part_no_section":"41(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:37.000000Z","updated_at":"2025-03-17T21:51:37.000000Z","normalized_code":"39141A1"},{"id":9430843,"change_date":"2024-07-10 21:39:00","inspection_id":"81965507","insp_violation_id":"260554448","seq_no":"3","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"201808678","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:37.000000Z","updated_at":"2025-03-17T21:51:37.000000Z","normalized_code":"39395A"},{"id":9430844,"change_date":"2024-07-10 21:39:00","inspection_id":"81965507","insp_violation_id":"260554449","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201808678","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:37.000000Z","updated_at":"2025-03-17T21:51:37.000000Z","normalized_code":"3939A"},{"id":9430845,"change_date":"2024-07-10 21:39:00","inspection_id":"81965507","insp_violation_id":"260554450","seq_no":"10","part_no":"393","part_no_section":"41","insp_viol_unit":"1","insp_unit_id":"201808678","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:51:37.000000Z","updated_at":"2025-03-17T21:51:37.000000Z","normalized_code":"39341"},{"id":9430846,"change_date":"2024-07-10 21:39:00","inspection_id":"81965507","insp_violation_id":"260554451","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201808678","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:37.000000Z","updated_at":"2025-03-17T21:51:37.000000Z","normalized_code":"3939A"},{"id":9430847,"change_date":"2024-07-10 21:39:00","inspection_id":"81965507","insp_violation_id":"260554452","seq_no":"6","part_no":"390","part_no_section":"21T(c)","insp_viol_unit":"1","insp_unit_id":"201808678","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:37.000000Z","updated_at":"2025-03-17T21:51:37.000000Z","normalized_code":"39021TC"},{"id":9430848,"change_date":"2024-07-10 21:39:00","inspection_id":"81965507","insp_violation_id":"260554453","seq_no":"7","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201808678","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V128565-5","created_at":"2025-03-17T21:51:37.000000Z","updated_at":"2025-03-17T21:51:37.000000Z","normalized_code":"3922"},{"id":9430849,"change_date":"2024-07-10 21:39:00","inspection_id":"81965507","insp_violation_id":"260554454","seq_no":"8","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201808678","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V128565-5","created_at":"2025-03-17T21:51:37.000000Z","updated_at":"2025-03-17T21:51:37.000000Z","normalized_code":"3922"},{"id":9430850,"change_date":"2024-07-10 21:39:00","inspection_id":"81965507","insp_violation_id":"260554455","seq_no":"9","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201808678","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V128565-5","created_at":"2025-03-17T21:51:37.000000Z","updated_at":"2025-03-17T21:51:37.000000Z","normalized_code":"3922"},{"id":9430842,"change_date":"2024-07-10 21:39:00","inspection_id":"81965507","insp_violation_id":"260554447","seq_no":"2","part_no":"392","part_no_section":"8","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:37.000000Z","updated_at":"2025-03-17T21:51:37.000000Z","normalized_code":"3928"}],"inspection_per_units":[{"id":9788148,"change_date":"2024-07-10 21:39:00","inspection_id":"81965507","insp_unit_id":"201808678","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"AE52278","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1GDE5C1225F518717","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:22.000000Z","updated_at":"2025-03-17T23:24:22.000000Z"}]},{"id":4853154,"change_date":"2024-01-18 21:44:00","inspection_id":"80632568","dot_number":"3266135","report_state":"CT","report_number":"3120004369","insp_date":"2024-01-18 00:00:00","insp_start_time":"1009","insp_end_time":"1103","registration_date":"2024-01-18 00:00:00","region":"ET","ci_status_code":"C","location":"155","location_desc":"WEST HARTFORD","county_code_state":"CT","county_code":"003","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"ALX PRODUCTS AND SERVICES LLC","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-18 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"22490","viol_total":"12","oos_total":"3","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"11","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"697201","transaction_code":"A","transaction_date":"2024-01-18 00:00:00","upload_date":"2024-01-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03266135","upload_search_indicator":null,"census_search_date":"2024-01-18 21:44:00","snet_input_date":"2024-01-18 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-01-18 21:44:00","insp_carrier_name":"ALX PRODUCTS AND SERVICES LLC","insp_carrier_street":"69 TALCOTT RD","insp_carrier_city":"WEST HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06110","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:58:51.000000Z","updated_at":"2025-03-17T19:58:51.000000Z","inspection_violations":[{"id":7481229,"change_date":"2024-01-18 21:44:00","inspection_id":"80632568","insp_violation_id":"257385538","seq_no":"1","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"199003914","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:07.000000Z","updated_at":"2025-03-17T21:42:07.000000Z","normalized_code":"39021TB"},{"id":7481230,"change_date":"2024-01-18 21:44:00","inspection_id":"80632568","insp_violation_id":"257385539","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"199003914","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:07.000000Z","updated_at":"2025-03-17T21:42:07.000000Z","normalized_code":"39617C"},{"id":7481231,"change_date":"2024-01-18 21:44:00","inspection_id":"80632568","insp_violation_id":"257385540","seq_no":"3","part_no":"390","part_no_section":"19(b)(2)","insp_viol_unit":"1","insp_unit_id":"199003914","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:07.000000Z","updated_at":"2025-03-17T21:42:07.000000Z","normalized_code":"39019B2"},{"id":7481232,"change_date":"2024-01-18 21:44:00","inspection_id":"80632568","insp_violation_id":"257385541","seq_no":"4","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"199003914","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:07.000000Z","updated_at":"2025-03-17T21:42:07.000000Z","normalized_code":"39395A"},{"id":7481233,"change_date":"2024-01-18 21:44:00","inspection_id":"80632568","insp_violation_id":"257385542","seq_no":"5","part_no":"392","part_no_section":"8","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:07.000000Z","updated_at":"2025-03-17T21:42:07.000000Z","normalized_code":"3928"},{"id":7481234,"change_date":"2024-01-18 21:44:00","inspection_id":"80632568","insp_violation_id":"257385543","seq_no":"6","part_no":"393","part_no_section":"41","insp_viol_unit":"1","insp_unit_id":"199003914","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"V125888-2","created_at":"2025-03-17T21:42:07.000000Z","updated_at":"2025-03-17T21:42:07.000000Z","normalized_code":"39341"},{"id":7481235,"change_date":"2024-01-18 21:44:00","inspection_id":"80632568","insp_violation_id":"257385544","seq_no":"7","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"199003914","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:07.000000Z","updated_at":"2025-03-17T21:42:07.000000Z","normalized_code":"39311"},{"id":7481236,"change_date":"2024-01-18 21:44:00","inspection_id":"80632568","insp_violation_id":"257385545","seq_no":"8","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"199003915","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:07.000000Z","updated_at":"2025-03-17T21:42:07.000000Z","normalized_code":"39617C"},{"id":7481237,"change_date":"2024-01-18 21:44:00","inspection_id":"80632568","insp_violation_id":"257385546","seq_no":"9","part_no":"393","part_no_section":"104(f)(1)","insp_viol_unit":"2","insp_unit_id":"199003915","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"V125888-2","created_at":"2025-03-17T21:42:07.000000Z","updated_at":"2025-03-17T21:42:07.000000Z","normalized_code":"393104F1"},{"id":7481238,"change_date":"2024-01-18 21:44:00","inspection_id":"80632568","insp_violation_id":"257385547","seq_no":"10","part_no":"392","part_no_section":"9(a)(2)","insp_viol_unit":"2","insp_unit_id":"199003915","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:42:07.000000Z","updated_at":"2025-03-17T21:42:07.000000Z","normalized_code":"3929A2"},{"id":7481239,"change_date":"2024-01-18 21:44:00","inspection_id":"80632568","insp_violation_id":"257385548","seq_no":"11","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"199003915","insp_violation_category_id":"17","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:07.000000Z","updated_at":"2025-03-17T21:42:07.000000Z","normalized_code":"3922"},{"id":7481240,"change_date":"2024-01-18 21:44:00","inspection_id":"80632568","insp_violation_id":"257385549","seq_no":"12","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"199003915","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:07.000000Z","updated_at":"2025-03-17T21:42:07.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":7808468,"change_date":"2024-01-18 21:44:00","inspection_id":"80632568","insp_unit_id":"199003914","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BN94756","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3C7WRNBL0JG165714","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:47.000000Z","updated_at":"2025-03-17T23:05:47.000000Z"},{"id":7808469,"change_date":"2024-01-18 21:44:00","inspection_id":"80632568","insp_unit_id":"199003915","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"CARRY","insp_unit_company":null,"insp_unit_license":"AJ76087","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"4YMUL0917FV054294","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:47.000000Z","updated_at":"2025-03-17T23:05:47.000000Z"}]},{"id":3920991,"change_date":"2023-09-07 21:40:00","inspection_id":"79604967","dot_number":"3266135","report_state":"NY","report_number":"0816015048","insp_date":"2023-09-06 00:00:00","insp_start_time":"0925","insp_end_time":"1005","registration_date":null,"region":"ET","ci_status_code":"C","location":"80167","location_desc":"CLARKSTOWN","county_code_state":"NY","county_code":"087","insp_level_id":"2","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-09-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"28400","viol_total":"9","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2865182","transaction_code":"A","transaction_date":"2023-09-07 00:00:00","upload_date":"2023-09-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03266135","upload_search_indicator":"M","census_search_date":"2023-09-07 21:40:00","snet_input_date":"2023-09-07 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-09-07 21:40:00","insp_carrier_name":"ALX PRODUCTS AND SERVICES LLC","insp_carrier_street":"69 TALCOTT RD","insp_carrier_city":"WEST HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06110-1227","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:40:25.000000Z","updated_at":"2025-03-17T19:40:25.000000Z","inspection_violations":[{"id":6060476,"change_date":"2023-09-07 21:40:00","inspection_id":"79604967","insp_violation_id":"255127649","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"196937366","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:21.000000Z","updated_at":"2025-03-17T21:35:21.000000Z","normalized_code":"39395A"},{"id":6060477,"change_date":"2023-09-07 21:40:00","inspection_id":"79604967","insp_violation_id":"255127650","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196937366","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:21.000000Z","updated_at":"2025-03-17T21:35:21.000000Z","normalized_code":"3922"},{"id":6060478,"change_date":"2023-09-07 21:40:00","inspection_id":"79604967","insp_violation_id":"255127651","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196937366","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:21.000000Z","updated_at":"2025-03-17T21:35:21.000000Z","normalized_code":"3939A"},{"id":6060479,"change_date":"2023-09-07 21:40:00","inspection_id":"79604967","insp_violation_id":"255127652","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196937366","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:21.000000Z","updated_at":"2025-03-17T21:35:21.000000Z","normalized_code":"3939A"},{"id":6060480,"change_date":"2023-09-07 21:40:00","inspection_id":"79604967","insp_violation_id":"255127653","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"196937367","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:21.000000Z","updated_at":"2025-03-17T21:35:21.000000Z","normalized_code":"3922"},{"id":6060481,"change_date":"2023-09-07 21:40:00","inspection_id":"79604967","insp_violation_id":"255127654","seq_no":"6","part_no":"393","part_no_section":"205(c)","insp_viol_unit":"2","insp_unit_id":"196937367","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:21.000000Z","updated_at":"2025-03-17T21:35:21.000000Z","normalized_code":"393205C"},{"id":6060482,"change_date":"2023-09-07 21:40:00","inspection_id":"79604967","insp_violation_id":"255127655","seq_no":"7","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"196937367","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:21.000000Z","updated_at":"2025-03-17T21:35:21.000000Z","normalized_code":"39348A"},{"id":6060483,"change_date":"2023-09-07 21:40:00","inspection_id":"79604967","insp_violation_id":"255127656","seq_no":"8","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"196937367","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":"C239H52HJK","created_at":"2025-03-17T21:35:21.000000Z","updated_at":"2025-03-17T21:35:21.000000Z","normalized_code":"3963A1"},{"id":6060484,"change_date":"2023-09-07 21:40:00","inspection_id":"79604967","insp_violation_id":"255127657","seq_no":"9","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"196937367","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:21.000000Z","updated_at":"2025-03-17T21:35:21.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":6304771,"change_date":"2023-09-07 21:40:00","inspection_id":"79604967","insp_unit_id":"196937366","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BA90600","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FDFF6LT1NDA04782","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:57.000000Z","updated_at":"2025-03-17T22:52:57.000000Z"},{"id":6304772,"change_date":"2023-09-07 21:40:00","inspection_id":"79604967","insp_unit_id":"196937367","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"VERN","insp_unit_company":null,"insp_unit_license":"AY51534","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1VRU1614851002079","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:57.000000Z","updated_at":"2025-03-17T22:52:57.000000Z"}]},{"id":3300847,"change_date":"2023-07-05 21:41:00","inspection_id":"78910301","dot_number":"3266135","report_state":"CT","report_number":"3132003895","insp_date":"2023-06-16 00:00:00","insp_start_time":"1402","insp_end_time":"1436","registration_date":"2023-07-05 00:00:00","region":"ET","ci_status_code":"C","location":"064","location_desc":"HARTFORD","county_code_state":"CT","county_code":"003","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":"2023-06-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"36945","viol_total":"2","oos_total":"2","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"677548","transaction_code":"C","transaction_date":"2023-06-16 00:00:00","upload_date":"2023-07-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03266135","upload_search_indicator":null,"census_search_date":"2023-06-16 21:40:00","snet_input_date":"2023-06-16 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-06-16 21:40:00","insp_carrier_name":"ALX PRODUCTS AND SERVICES LLC","insp_carrier_street":"69 TALCOTT RD","insp_carrier_city":"WEST HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06110","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:28:29.000000Z","updated_at":"2025-03-17T19:28:29.000000Z","inspection_violations":[{"id":5090692,"change_date":"2023-07-05 21:41:00","inspection_id":"78910301","insp_violation_id":"253855799","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:39.000000Z","updated_at":"2025-03-17T21:30:39.000000Z","normalized_code":"38323A2"},{"id":5090693,"change_date":"2023-07-05 21:41:00","inspection_id":"78910301","insp_violation_id":"253855800","seq_no":"2","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"195814510","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"Y9968425","created_at":"2025-03-17T21:30:39.000000Z","updated_at":"2025-03-17T21:30:39.000000Z","normalized_code":"39343"}],"inspection_per_units":[{"id":5307034,"change_date":"2023-07-05 21:41:00","inspection_id":"78910301","insp_unit_id":"195814509","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"AE51776","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1GDK7C1C47F900420","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:52.000000Z","updated_at":"2025-03-17T22:44:52.000000Z"},{"id":5307035,"change_date":"2023-07-05 21:41:00","inspection_id":"78910301","insp_unit_id":"195814510","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":null,"insp_unit_license":"AZ84000","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1A920029123B17507","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:52.000000Z","updated_at":"2025-03-17T22:44:52.000000Z"}]},{"id":2363602,"change_date":"2023-03-01 21:41:00","inspection_id":"77847234","dot_number":"3266135","report_state":"CT","report_number":"3076002206","insp_date":"2023-02-14 00:00:00","insp_start_time":"1255","insp_end_time":"1324","registration_date":"2023-03-01 00:00:00","region":"ET","ci_status_code":"C","location":"151","location_desc":"WATERBURY","county_code_state":"CT","county_code":"009","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"30000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"666594","transaction_code":"C","transaction_date":"2023-02-14 00:00:00","upload_date":"2023-03-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03266135","upload_search_indicator":null,"census_search_date":"2023-02-14 21:40:00","snet_input_date":"2023-02-14 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-02-14 21:40:00","insp_carrier_name":"ALX PRODUCTS AND SERVICES LLC","insp_carrier_street":"69 TALCOTT RD","insp_carrier_city":"WEST HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06110","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:10:18.000000Z","updated_at":"2025-03-17T19:10:18.000000Z","inspection_violations":[{"id":3640574,"change_date":"2023-03-01 21:41:00","inspection_id":"77847234","insp_violation_id":"251397020","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:12.000000Z","updated_at":"2025-03-17T21:24:12.000000Z","normalized_code":"3922"},{"id":3640575,"change_date":"2023-03-01 21:41:00","inspection_id":"77847234","insp_violation_id":"251397021","seq_no":"2","part_no":"391","part_no_section":"11(b)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:12.000000Z","updated_at":"2025-03-17T21:24:12.000000Z","normalized_code":"39111B2"}],"inspection_per_units":[{"id":3803972,"change_date":"2023-03-01 21:41:00","inspection_id":"77847234","insp_unit_id":"193632519","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BA90600","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FDFF6LT1NDA04782","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:14.000000Z","updated_at":"2025-03-17T22:33:14.000000Z"},{"id":3803973,"change_date":"2023-03-01 21:41:00","inspection_id":"77847234","insp_unit_id":"193632520","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"VERN","insp_unit_company":null,"insp_unit_license":"BL14948","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1VRN1312831003098","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:14.000000Z","updated_at":"2025-03-17T22:33:14.000000Z"}]},{"id":1957739,"change_date":"2023-01-09 21:41:00","inspection_id":"77383898","dot_number":"3266135","report_state":"CT","report_number":"3061001836","insp_date":"2022-12-15 00:00:00","insp_start_time":"1659","insp_end_time":"1749","registration_date":"2023-01-09 00:00:00","region":"ET","ci_status_code":"C","location":"052","location_desc":"FARMINGTON","county_code_state":"CT","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAA","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"23000","viol_total":"7","oos_total":"4","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"5","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"661273","transaction_code":"C","transaction_date":"2022-12-16 00:00:00","upload_date":"2023-01-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03266135","upload_search_indicator":null,"census_search_date":"2022-12-16 21:39:00","snet_input_date":"2022-12-15 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-12-16 21:39:00","insp_carrier_name":"ALX PRODUCTS AND SERVICES LLC","insp_carrier_street":"69 TALCOTT RD","insp_carrier_city":"WEST HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06110","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:02:36.000000Z","updated_at":"2025-03-17T19:02:36.000000Z","inspection_violations":[{"id":3040804,"change_date":"2023-01-09 21:41:00","inspection_id":"77383898","insp_violation_id":"250439885","seq_no":"1","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:29.000000Z","updated_at":"2025-03-17T21:21:29.000000Z","normalized_code":"39141A"},{"id":3040805,"change_date":"2023-01-09 21:41:00","inspection_id":"77383898","insp_violation_id":"250439886","seq_no":"2","part_no":"391","part_no_section":"11(b)(5)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:29.000000Z","updated_at":"2025-03-17T21:21:29.000000Z","normalized_code":"39111B5"},{"id":3040806,"change_date":"2023-01-09 21:41:00","inspection_id":"77383898","insp_violation_id":"250439887","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"192749005","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:29.000000Z","updated_at":"2025-03-17T21:21:29.000000Z","normalized_code":"39617C"},{"id":3040807,"change_date":"2023-01-09 21:41:00","inspection_id":"77383898","insp_violation_id":"250439888","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192749005","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:21:29.000000Z","updated_at":"2025-03-17T21:21:29.000000Z","normalized_code":"3939A"},{"id":3040808,"change_date":"2023-01-09 21:41:00","inspection_id":"77383898","insp_violation_id":"250439889","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192749005","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:29.000000Z","updated_at":"2025-03-17T21:21:29.000000Z","normalized_code":"3939A"},{"id":3040809,"change_date":"2023-01-09 21:41:00","inspection_id":"77383898","insp_violation_id":"250439890","seq_no":"6","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"192749006","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"BE62666","created_at":"2025-03-17T21:21:29.000000Z","updated_at":"2025-03-17T21:21:29.000000Z","normalized_code":"39343"},{"id":3040810,"change_date":"2023-01-09 21:41:00","inspection_id":"77383898","insp_violation_id":"250439891","seq_no":"7","part_no":"393","part_no_section":"51","insp_viol_unit":"1","insp_unit_id":"192749005","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"Y992589-1","created_at":"2025-03-17T21:21:29.000000Z","updated_at":"2025-03-17T21:21:29.000000Z","normalized_code":"39351"}],"inspection_per_units":[{"id":3150193,"change_date":"2023-01-09 21:41:00","inspection_id":"77383898","insp_unit_id":"192749005","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"1","insp_unit_license":"AE53134","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FDXF47F41EB26053","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:35.000000Z","updated_at":"2025-03-17T22:28:35.000000Z"},{"id":3150194,"change_date":"2023-01-09 21:41:00","inspection_id":"77383898","insp_unit_id":"192749006","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MMDI","insp_unit_company":null,"insp_unit_license":"BE62666","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"5631F172XHM016703","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:35.000000Z","updated_at":"2025-03-17T22:28:35.000000Z"}]},{"id":1793030,"change_date":"2023-01-24 21:42:00","inspection_id":"77195177","dot_number":"3266135","report_state":"DE","report_number":"M007000279","insp_date":"2022-11-21 00:00:00","insp_start_time":"1045","insp_end_time":"1150","registration_date":"2023-01-23 00:00:00","region":"ET","ci_status_code":"C","location":"058348","location_desc":"I95 N\/B AT 896","county_code_state":"DE","county_code":"003","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-11-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"28400","viol_total":"5","oos_total":"2","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"102672","transaction_code":"C","transaction_date":"2022-11-21 00:00:00","upload_date":"2023-01-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03266135","upload_search_indicator":null,"census_search_date":"2022-11-22 21:40:00","snet_input_date":"2022-11-22 00:00:00","source_office":"1DES001","mcmis_add_date":"2022-11-22 21:40:00","insp_carrier_name":"ALX PRODUCTS AND SERVICES LLC","insp_carrier_street":"69 TALCOTT RD","insp_carrier_city":"WEST HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06110-1227","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:59:40.000000Z","updated_at":"2025-03-17T18:59:40.000000Z","inspection_violations":[{"id":2804681,"change_date":"2023-01-24 21:42:00","inspection_id":"77195177","insp_violation_id":"250731805","seq_no":"1","part_no":"391","part_no_section":"45(b)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:15.000000Z","updated_at":"2025-03-17T21:20:15.000000Z","normalized_code":"39145B"},{"id":2804682,"change_date":"2023-01-24 21:42:00","inspection_id":"77195177","insp_violation_id":"250731806","seq_no":"2","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:15.000000Z","updated_at":"2025-03-17T21:20:15.000000Z","normalized_code":"3958A1"},{"id":2804683,"change_date":"2023-01-24 21:42:00","inspection_id":"77195177","insp_violation_id":"250731807","seq_no":"4","part_no":"393","part_no_section":"75(a)(1)","insp_viol_unit":"2","insp_unit_id":"193022276","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"T062207616","created_at":"2025-03-17T21:20:15.000000Z","updated_at":"2025-03-17T21:20:15.000000Z","normalized_code":"39375A1"},{"id":2804684,"change_date":"2023-01-24 21:42:00","inspection_id":"77195177","insp_violation_id":"250731808","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"193022276","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:15.000000Z","updated_at":"2025-03-17T21:20:15.000000Z","normalized_code":"3939A"},{"id":2804685,"change_date":"2023-01-24 21:42:00","inspection_id":"77195177","insp_violation_id":"250731809","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"193022276","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:15.000000Z","updated_at":"2025-03-17T21:20:15.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":2884412,"change_date":"2023-01-24 21:42:00","inspection_id":"77195177","insp_unit_id":"193022275","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BA90600","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FDFF6LT1NDA04782","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:44.000000Z","updated_at":"2025-03-17T22:26:44.000000Z"},{"id":2884413,"change_date":"2023-01-24 21:42:00","inspection_id":"77195177","insp_unit_id":"193022276","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VERN","insp_unit_company":null,"insp_unit_license":"AY51534","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1VRU1614851002079","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:44.000000Z","updated_at":"2025-03-17T22:26:44.000000Z"}]},{"id":1737888,"change_date":"2022-12-13 21:39:00","inspection_id":"77131858","dot_number":"3266135","report_state":"CT","report_number":"0997000477","insp_date":"2022-11-15 00:00:00","insp_start_time":"0833","insp_end_time":"0955","registration_date":"2022-12-13 00:00:00","region":"ET","ci_status_code":"C","location":"061","location_desc":"HADDAM","county_code_state":"CT","county_code":"007","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-15 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","viol_total":"11","oos_total":"7","driver_viol_total":"3","driver_oos_total":"1","vehicle_viol_total":"8","vehicle_oos_total":"6","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"658817","transaction_code":"C","transaction_date":"2022-11-15 00:00:00","upload_date":"2022-12-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03266135","upload_search_indicator":null,"census_search_date":"2022-11-15 21:39:00","snet_input_date":"2022-11-15 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-11-15 21:39:00","insp_carrier_name":"ALX PRODUCTS AND SERVICES LLC","insp_carrier_street":"69 TALCOTT RD","insp_carrier_city":"WEST HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06110","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:36.000000Z","updated_at":"2025-03-17T18:58:36.000000Z","inspection_violations":[{"id":2721538,"change_date":"2022-12-13 21:39:00","inspection_id":"77131858","insp_violation_id":"250071753","seq_no":"1","part_no":"391","part_no_section":"11(b)(5)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"Z355259-1","created_at":"2025-03-17T21:19:51.000000Z","updated_at":"2025-03-17T21:19:51.000000Z","normalized_code":"39111B5"},{"id":2721539,"change_date":"2022-12-13 21:39:00","inspection_id":"77131858","insp_violation_id":"250071754","seq_no":"2","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:51.000000Z","updated_at":"2025-03-17T21:19:51.000000Z","normalized_code":"39141A"},{"id":2721540,"change_date":"2022-12-13 21:39:00","inspection_id":"77131858","insp_violation_id":"250071755","seq_no":"3","part_no":"391","part_no_section":"11(b)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:51.000000Z","updated_at":"2025-03-17T21:19:51.000000Z","normalized_code":"39111B2"},{"id":2721541,"change_date":"2022-12-13 21:39:00","inspection_id":"77131858","insp_violation_id":"250071756","seq_no":"4","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"192399572","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:51.000000Z","updated_at":"2025-03-17T21:19:51.000000Z","normalized_code":"39617C"},{"id":2721542,"change_date":"2022-12-13 21:39:00","inspection_id":"77131858","insp_violation_id":"250071757","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"192399572","insp_violation_category_id":"18","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"Z355259-1","created_at":"2025-03-17T21:19:51.000000Z","updated_at":"2025-03-17T21:19:51.000000Z","normalized_code":"3963A1"},{"id":2721543,"change_date":"2022-12-13 21:39:00","inspection_id":"77131858","insp_violation_id":"250071758","seq_no":"6","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"192399572","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"Z355259-1","created_at":"2025-03-17T21:19:51.000000Z","updated_at":"2025-03-17T21:19:51.000000Z","normalized_code":"39375A3"},{"id":2721544,"change_date":"2022-12-13 21:39:00","inspection_id":"77131858","insp_violation_id":"250071759","seq_no":"7","part_no":"393","part_no_section":"205(c)","insp_viol_unit":"1","insp_unit_id":"192399572","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"Z355259-1","created_at":"2025-03-17T21:19:51.000000Z","updated_at":"2025-03-17T21:19:51.000000Z","normalized_code":"393205C"},{"id":2721545,"change_date":"2022-12-13 21:39:00","inspection_id":"77131858","insp_violation_id":"250071760","seq_no":"8","part_no":"393","part_no_section":"106(d)","insp_viol_unit":"2","insp_unit_id":"192399573","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"Z355259-1","created_at":"2025-03-17T21:19:51.000000Z","updated_at":"2025-03-17T21:19:51.000000Z","normalized_code":"393106D"},{"id":2721546,"change_date":"2022-12-13 21:39:00","inspection_id":"77131858","insp_violation_id":"250071761","seq_no":"9","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"192399573","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:51.000000Z","updated_at":"2025-03-17T21:19:51.000000Z","normalized_code":"3922"},{"id":2721547,"change_date":"2022-12-13 21:39:00","inspection_id":"77131858","insp_violation_id":"250071762","seq_no":"10","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"192399573","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:19:51.000000Z","updated_at":"2025-03-17T21:19:51.000000Z","normalized_code":"39343"},{"id":2721548,"change_date":"2022-12-13 21:39:00","inspection_id":"77131858","insp_violation_id":"250071763","seq_no":"11","part_no":"393","part_no_section":"75(g)","insp_viol_unit":"2","insp_unit_id":"192399573","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"Z355259-1","created_at":"2025-03-17T21:19:51.000000Z","updated_at":"2025-03-17T21:19:51.000000Z","normalized_code":"39375G"}],"inspection_per_units":[{"id":2796259,"change_date":"2022-12-13 21:39:00","inspection_id":"77131858","insp_unit_id":"192399572","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"AE53134","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FDXF47F41EB26053","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:08.000000Z","updated_at":"2025-03-17T22:26:08.000000Z"},{"id":2796260,"change_date":"2022-12-13 21:39:00","inspection_id":"77131858","insp_unit_id":"192399573","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"APTM","insp_unit_company":null,"insp_unit_license":"AZ84000","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1A920029123B17507","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:08.000000Z","updated_at":"2025-03-17T22:26:08.000000Z"}]},{"id":546903,"change_date":"2022-06-06 21:40:00","inspection_id":"75744867","dot_number":"3266135","report_state":"MA","report_number":"CX00000097","insp_date":"2022-06-04 00:00:00","insp_start_time":"0812","insp_end_time":"0847","registration_date":null,"region":"ET","ci_status_code":"C","location":"4","location_desc":"WESTFIELD - BARRACKS","county_code_state":"MA","county_code":"013","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":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"28400","viol_total":"9","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"447220","transaction_code":"A","transaction_date":"2022-06-06 00:00:00","upload_date":"2022-06-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03266135","upload_search_indicator":"M","census_search_date":"2022-06-06 21:40:00","snet_input_date":"2022-06-04 00:00:00","source_office":"1MAS001","mcmis_add_date":"2022-06-06 21:40:00","insp_carrier_name":"ALX PRODUCTS AND SERVICES LLC","insp_carrier_street":"69 TALCOTT RD","insp_carrier_city":"WEST HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06110-1227","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:37:25.000000Z","updated_at":"2025-03-17T18:37:25.000000Z","inspection_violations":[{"id":861250,"change_date":"2022-06-06 21:40:00","inspection_id":"75744867","insp_violation_id":"246254825","seq_no":"1","part_no":"391","part_no_section":"11(b)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:06.000000Z","updated_at":"2025-03-17T21:11:06.000000Z","normalized_code":"39111B2"},{"id":861251,"change_date":"2022-06-06 21:40:00","inspection_id":"75744867","insp_violation_id":"246254826","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"189072560","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:06.000000Z","updated_at":"2025-03-17T21:11:06.000000Z","normalized_code":"39617C"},{"id":861252,"change_date":"2022-06-06 21:40:00","inspection_id":"75744867","insp_violation_id":"246254827","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"189072561","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:06.000000Z","updated_at":"2025-03-17T21:11:06.000000Z","normalized_code":"3922"},{"id":861253,"change_date":"2022-06-06 21:40:00","inspection_id":"75744867","insp_violation_id":"246254828","seq_no":"4","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"189072561","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"459237AB","created_at":"2025-03-17T21:11:06.000000Z","updated_at":"2025-03-17T21:11:06.000000Z","normalized_code":"39617C"},{"id":861254,"change_date":"2022-06-06 21:40:00","inspection_id":"75744867","insp_violation_id":"246254829","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"189072561","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:06.000000Z","updated_at":"2025-03-17T21:11:06.000000Z","normalized_code":"3939A"},{"id":861255,"change_date":"2022-06-06 21:40:00","inspection_id":"75744867","insp_violation_id":"246254830","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"189072561","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:06.000000Z","updated_at":"2025-03-17T21:11:06.000000Z","normalized_code":"3939A"},{"id":861256,"change_date":"2022-06-06 21:40:00","inspection_id":"75744867","insp_violation_id":"246254831","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"189072561","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:06.000000Z","updated_at":"2025-03-17T21:11:06.000000Z","normalized_code":"3939A"},{"id":861257,"change_date":"2022-06-06 21:40:00","inspection_id":"75744867","insp_violation_id":"246254832","seq_no":"8","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"189072561","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:06.000000Z","updated_at":"2025-03-17T21:11:06.000000Z","normalized_code":"3939A"},{"id":861258,"change_date":"2022-06-06 21:40:00","inspection_id":"75744867","insp_violation_id":"246254833","seq_no":"9","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"189072561","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:06.000000Z","updated_at":"2025-03-17T21:11:06.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":879791,"change_date":"2022-06-06 21:40:00","inspection_id":"75744867","insp_unit_id":"189072560","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BA90600","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FDFF6LT1NDA04782","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:36.000000Z","updated_at":"2025-03-17T22:13:36.000000Z"},{"id":879792,"change_date":"2022-06-06 21:40:00","inspection_id":"75744867","insp_unit_id":"189072561","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VERN","insp_unit_company":null,"insp_unit_license":"AY51534","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1VRU1614851002079","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:36.000000Z","updated_at":"2025-03-17T22:13:36.000000Z"}]},{"id":306699,"change_date":"2022-05-23 21:41:00","inspection_id":"75459017","dot_number":"3266135","report_state":"CT","report_number":"3019003446","insp_date":"2022-05-03 00:00:00","insp_start_time":"0656","insp_end_time":"0740","registration_date":"2022-05-23 00:00:00","region":"ET","ci_status_code":"C","location":"052","location_desc":"FARMINGTON","county_code_state":"CT","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"22000","viol_total":"10","oos_total":"1","driver_viol_total":"4","driver_oos_total":"1","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"643384","transaction_code":"C","transaction_date":"2022-05-03 00:00:00","upload_date":"2022-05-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03266135","upload_search_indicator":null,"census_search_date":"2022-05-03 21:39:00","snet_input_date":"2022-05-03 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-05-03 21:39:00","insp_carrier_name":"ALX PRODUCTS AND SERVICES LLC","insp_carrier_street":"69 TALCOTT RD","insp_carrier_city":"WEST HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06110","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:32:56.000000Z","updated_at":"2025-03-17T18:32:56.000000Z","inspection_violations":[{"id":476978,"change_date":"2022-05-23 21:41:00","inspection_id":"75459017","insp_violation_id":"245981465","seq_no":"7","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188837411","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"Y988648-1","created_at":"2025-03-17T21:09:16.000000Z","updated_at":"2025-03-17T21:09:16.000000Z","normalized_code":"3922"},{"id":476979,"change_date":"2022-05-23 21:41:00","inspection_id":"75459017","insp_violation_id":"245981466","seq_no":"8","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188837411","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"Y988648-1","created_at":"2025-03-17T21:09:16.000000Z","updated_at":"2025-03-17T21:09:16.000000Z","normalized_code":"3922"},{"id":476980,"change_date":"2022-05-23 21:41:00","inspection_id":"75459017","insp_violation_id":"245981467","seq_no":"9","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"188837411","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:16.000000Z","updated_at":"2025-03-17T21:09:16.000000Z","normalized_code":"39021TB"},{"id":476981,"change_date":"2022-05-23 21:41:00","inspection_id":"75459017","insp_violation_id":"245981468","seq_no":"10","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188837411","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"Y988648-1","created_at":"2025-03-17T21:09:16.000000Z","updated_at":"2025-03-17T21:09:16.000000Z","normalized_code":"3922"},{"id":476982,"change_date":"2022-05-23 21:41:00","inspection_id":"75459017","insp_violation_id":"245981469","seq_no":"1","part_no":"391","part_no_section":"41(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:16.000000Z","updated_at":"2025-03-17T21:09:16.000000Z","normalized_code":"39141A1"},{"id":476983,"change_date":"2022-05-23 21:41:00","inspection_id":"75459017","insp_violation_id":"245981470","seq_no":"2","part_no":"391","part_no_section":"11(b)(5)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"Y988647-0","created_at":"2025-03-17T21:09:16.000000Z","updated_at":"2025-03-17T21:09:16.000000Z","normalized_code":"39111B5"},{"id":476984,"change_date":"2022-05-23 21:41:00","inspection_id":"75459017","insp_violation_id":"245981471","seq_no":"3","part_no":"391","part_no_section":"11(b)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:16.000000Z","updated_at":"2025-03-17T21:09:16.000000Z","normalized_code":"39111B2"},{"id":476985,"change_date":"2022-05-23 21:41:00","inspection_id":"75459017","insp_violation_id":"245981472","seq_no":"4","part_no":"392","part_no_section":"8","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:16.000000Z","updated_at":"2025-03-17T21:09:16.000000Z","normalized_code":"3928"},{"id":476986,"change_date":"2022-05-23 21:41:00","inspection_id":"75459017","insp_violation_id":"245981473","seq_no":"5","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"188837411","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:16.000000Z","updated_at":"2025-03-17T21:09:16.000000Z","normalized_code":"39395A"},{"id":476987,"change_date":"2022-05-23 21:41:00","inspection_id":"75459017","insp_violation_id":"245981474","seq_no":"6","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"188837411","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:16.000000Z","updated_at":"2025-03-17T21:09:16.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":496221,"change_date":"2022-05-23 21:41:00","inspection_id":"75459017","insp_unit_id":"188837411","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BA90600","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FDFF6LT1NDA04782","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:15.000000Z","updated_at":"2025-03-17T22:11:15.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3266135\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3266135\/inspections?page=1","links":[{"url":null,"label":"&laquo; Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3266135\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next &raquo;","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/searchcarriers.com\/company\/3266135\/inspections","per_page":100,"prev_page_url":null,"to":20,"total":20}