{"current_page":1,"data":[{"id":7468179,"change_date":"2024-12-20 21:39:00","inspection_id":"83445276","dot_number":"3979095","report_state":"NY","report_number":"SPK4020046","insp_date":"2024-12-13 00:00:00","insp_start_time":"1317","insp_end_time":"1359","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"BREWSTER NY","county_code_state":"NY","county_code":"079","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-12-20 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1178322","transaction_code":"A","transaction_date":"2024-12-20 00:00:00","upload_date":"2024-12-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03979095","upload_search_indicator":null,"census_search_date":"2024-12-20 21:39:00","snet_input_date":"2024-12-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-12-20 21:39:00","insp_carrier_name":"SPRAY ALLIANCE CORP","insp_carrier_street":"48 UNION ST STE 20","insp_carrier_city":"STAMFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06906-1342","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:51:56.000000Z","updated_at":"2025-03-17T20:51:56.000000Z","inspection_violations":[{"id":11673207,"change_date":"2024-12-20 21:39:00","inspection_id":"83445276","insp_violation_id":"263594926","seq_no":"1","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"204495835","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:49.000000Z","updated_at":"2025-03-17T22:02:49.000000Z","normalized_code":"39021TB1MC"},{"id":11673208,"change_date":"2024-12-20 21:39:00","inspection_id":"83445276","insp_violation_id":"263594927","seq_no":"2","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"204495835","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"S241197132","created_at":"2025-03-17T22:02:49.000000Z","updated_at":"2025-03-17T22:02:49.000000Z","normalized_code":"39021TB2DOT"}],"inspection_per_units":[{"id":12048233,"change_date":"2024-12-20 21:39:00","inspection_id":"83445276","insp_unit_id":"204495835","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"BJ24293","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"5PVNJ8AV2M5T51447","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:02.000000Z","updated_at":"2025-03-17T23:48:02.000000Z"}]},{"id":5505480,"change_date":"2024-04-16 21:40:00","inspection_id":"81344975","dot_number":"3979095","report_state":"CT","report_number":"3090003886","insp_date":"2024-04-15 00:00:00","insp_start_time":"1050","insp_end_time":"1132","registration_date":null,"region":"ET","ci_status_code":"C","location":"103","location_desc":"NORWALK  DMV","county_code_state":"CT","county_code":"001","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SELF","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"704888","transaction_code":"C","transaction_date":"2024-04-16 00:00:00","upload_date":"2024-04-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03979095","upload_search_indicator":null,"census_search_date":"2024-04-15 21:40:00","snet_input_date":"2024-04-15 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-04-15 21:40:00","insp_carrier_name":"SPRAY ALLIANCE CORP","insp_carrier_street":"48 UNION ST STE 20","insp_carrier_city":"STAMFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06906","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:11:55.000000Z","updated_at":"2025-03-17T20:11:55.000000Z","inspection_violations":[{"id":8505175,"change_date":"2024-04-16 21:40:00","inspection_id":"81344975","insp_violation_id":"258942622","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":"V127267 2","created_at":"2025-03-17T21:47:13.000000Z","updated_at":"2025-03-17T21:47:13.000000Z","normalized_code":"38323A2"},{"id":8505176,"change_date":"2024-04-16 21:40:00","inspection_id":"81344975","insp_violation_id":"258942623","seq_no":"2","part_no":"392","part_no_section":"80(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:47:13.000000Z","updated_at":"2025-03-17T21:47:13.000000Z","normalized_code":"39280A"}],"inspection_per_units":[{"id":8868417,"change_date":"2024-04-16 21:40:00","inspection_id":"81344975","insp_unit_id":"200407195","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BA88516","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3ALACXDT3EDFR8549","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:29.000000Z","updated_at":"2025-03-17T23:15:29.000000Z"}]},{"id":4969711,"change_date":"2024-02-03 21:32:00","inspection_id":"80760195","dot_number":"3979095","report_state":"NY","report_number":"D012002347","insp_date":"2024-02-02 00:00:00","insp_start_time":"1140","insp_end_time":"1244","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"RIVERHEAD NY","county_code_state":"NY","county_code":"103","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SPRAY ALLIANCE CORP","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-02-03 21:32:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"216391","transaction_code":"A","transaction_date":"2024-02-03 00:00:00","upload_date":"2024-02-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03979095","upload_search_indicator":null,"census_search_date":"2024-02-03 21:32:00","snet_input_date":"2024-02-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-02-03 21:32:00","insp_carrier_name":"SPRAY ALLIANCE CORP","insp_carrier_street":"48 UNION ST STE 20","insp_carrier_city":"STAMFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06906-1342","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:01:14.000000Z","updated_at":"2025-03-17T20:01:14.000000Z","inspection_violations":[{"id":7656239,"change_date":"2024-02-03 21:32:00","inspection_id":"80760195","insp_violation_id":"257649854","seq_no":"1","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"199253168","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:57.000000Z","updated_at":"2025-03-17T21:42:57.000000Z","normalized_code":"3922SLLUCR"},{"id":7656240,"change_date":"2024-02-03 21:32:00","inspection_id":"80760195","insp_violation_id":"257649855","seq_no":"2","part_no":"393","part_no_section":"11A1-L","insp_viol_unit":"1","insp_unit_id":"199253168","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:57.000000Z","updated_at":"2025-03-17T21:42:57.000000Z","normalized_code":"39311A1L"},{"id":7656241,"change_date":"2024-02-03 21:32:00","inspection_id":"80760195","insp_violation_id":"257649856","seq_no":"3","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"199253168","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:57.000000Z","updated_at":"2025-03-17T21:42:57.000000Z","normalized_code":"3939ALFTSI"}],"inspection_per_units":[{"id":7998441,"change_date":"2024-02-03 21:32:00","inspection_id":"80760195","insp_unit_id":"199253168","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"BA88516","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3ALACXDT3EDFR8549","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:29.000000Z","updated_at":"2025-03-17T23:07:29.000000Z"}]},{"id":4962795,"change_date":"2024-02-02 21:41:00","inspection_id":"80752614","dot_number":"3979095","report_state":"NY","report_number":"SPWL091158","insp_date":"2024-01-30 00:00:00","insp_start_time":"0931","insp_end_time":"1026","registration_date":null,"region":"ET","ci_status_code":"C","location":"00096G","location_desc":"YAPHANK (WB)","county_code_state":"NY","county_code":"103","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-02-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"10","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"10","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2902842","transaction_code":"A","transaction_date":"2024-02-01 00:00:00","upload_date":"2024-02-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03979095","upload_search_indicator":"M","census_search_date":"2024-02-02 21:41:00","snet_input_date":"2024-02-01 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-02-02 21:41:00","insp_carrier_name":"SPRAY ALLIANCE CORP","insp_carrier_street":"48 UNION ST STE 20","insp_carrier_city":"STAMFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06906-1342","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:01:11.000000Z","updated_at":"2025-03-17T20:01:11.000000Z","inspection_violations":[{"id":7644473,"change_date":"2024-02-02 21:41:00","inspection_id":"80752614","insp_violation_id":"257632311","seq_no":"1","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"199238260","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:56.000000Z","updated_at":"2025-03-17T21:42:56.000000Z","normalized_code":"39360D"},{"id":7644474,"change_date":"2024-02-02 21:41:00","inspection_id":"80752614","insp_violation_id":"257632312","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199238260","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:56.000000Z","updated_at":"2025-03-17T21:42:56.000000Z","normalized_code":"3922"},{"id":7644475,"change_date":"2024-02-02 21:41:00","inspection_id":"80752614","insp_violation_id":"257632313","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"199238260","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:56.000000Z","updated_at":"2025-03-17T21:42:56.000000Z","normalized_code":"39378"},{"id":7644476,"change_date":"2024-02-02 21:41:00","inspection_id":"80752614","insp_violation_id":"257632314","seq_no":"4","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"199238260","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:56.000000Z","updated_at":"2025-03-17T21:42:56.000000Z","normalized_code":"39617C"},{"id":7644477,"change_date":"2024-02-02 21:41:00","inspection_id":"80752614","insp_violation_id":"257632315","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199238260","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:56.000000Z","updated_at":"2025-03-17T21:42:56.000000Z","normalized_code":"3922"},{"id":7644478,"change_date":"2024-02-02 21:41:00","inspection_id":"80752614","insp_violation_id":"257632316","seq_no":"6","part_no":"385","part_no_section":"337(b)","insp_viol_unit":"1","insp_unit_id":"199238260","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:42:56.000000Z","updated_at":"2025-03-17T21:42:56.000000Z","normalized_code":"385337B"},{"id":7644479,"change_date":"2024-02-02 21:41:00","inspection_id":"80752614","insp_violation_id":"257632317","seq_no":"7","part_no":"396","part_no_section":"9(d)(2)","insp_viol_unit":"1","insp_unit_id":"199238260","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:56.000000Z","updated_at":"2025-03-17T21:42:56.000000Z","normalized_code":"3969D2"},{"id":7644480,"change_date":"2024-02-02 21:41:00","inspection_id":"80752614","insp_violation_id":"257632318","seq_no":"8","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199238260","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:56.000000Z","updated_at":"2025-03-17T21:42:56.000000Z","normalized_code":"3939A"},{"id":7644481,"change_date":"2024-02-02 21:41:00","inspection_id":"80752614","insp_violation_id":"257632319","seq_no":"9","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199238260","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:56.000000Z","updated_at":"2025-03-17T21:42:56.000000Z","normalized_code":"3922"},{"id":7644482,"change_date":"2024-02-02 21:41:00","inspection_id":"80752614","insp_violation_id":"257632320","seq_no":"10","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199238260","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:56.000000Z","updated_at":"2025-03-17T21:42:56.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7986907,"change_date":"2024-02-02 21:41:00","inspection_id":"80752614","insp_unit_id":"199238260","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BA88516","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3ALACXDT3EDFR8549","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:24.000000Z","updated_at":"2025-03-17T23:07:24.000000Z"}]},{"id":4457791,"change_date":"2023-11-20 21:39:00","inspection_id":"80199499","dot_number":"3979095","report_state":"NY","report_number":"0L96000077","insp_date":"2023-11-20 00:00:00","insp_start_time":"0622","insp_end_time":"0700","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"ROSLYN HEIGHTS NY","county_code_state":"NY","county_code":"059","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2023-11-20 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"2","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"101676","transaction_code":"A","transaction_date":"2023-11-20 00:00:00","upload_date":"2023-11-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03979095","upload_search_indicator":null,"census_search_date":"2023-11-20 21:39:00","snet_input_date":"2023-11-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-11-20 21:39:00","insp_carrier_name":"SPRAY ALLIANCE CORP","insp_carrier_street":"48 UNION ST STE 20","insp_carrier_city":"STAMFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06906-1342","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:51:07.000000Z","updated_at":"2025-03-17T19:51:07.000000Z","inspection_violations":[{"id":6899980,"change_date":"2023-11-20 21:39:00","inspection_id":"80199499","insp_violation_id":"256476632","seq_no":"1","part_no":"385","part_no_section":"325C-OOSO","insp_viol_unit":"1","insp_unit_id":"198133513","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"K165HF227N","created_at":"2025-03-17T21:39:14.000000Z","updated_at":"2025-03-17T21:39:14.000000Z","normalized_code":"385325COOSO"},{"id":6899981,"change_date":"2023-11-20 21:39:00","inspection_id":"80199499","insp_violation_id":"256476633","seq_no":"2","part_no":"385","part_no_section":"337B-OOSO","insp_viol_unit":"1","insp_unit_id":"198133513","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"K165HF22W3","created_at":"2025-03-17T21:39:14.000000Z","updated_at":"2025-03-17T21:39:14.000000Z","normalized_code":"385337BOOSO"}],"inspection_per_units":[{"id":7169080,"change_date":"2023-11-20 21:39:00","inspection_id":"80199499","insp_unit_id":"198133513","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"BA88516","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3ALACXDT3EDFR8549","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:11.000000Z","updated_at":"2025-03-17T23:00:11.000000Z"}]},{"id":2925319,"change_date":"2023-05-01 10:44:00","inspection_id":"78486306","dot_number":"3979095","report_state":"NY","report_number":"0L67001361","insp_date":"2023-04-29 00:00:00","insp_start_time":"1131","insp_end_time":"1216","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"N\/B135 EXIT 14W WOODBURY","county_code_state":"NY","county_code":"059","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":"Y","pen_cen_match":"I","final_status_date":"2023-05-01 10:44:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2820622","transaction_code":"A","transaction_date":"2023-04-29 00:00:00","upload_date":"2023-05-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03979095","upload_search_indicator":null,"census_search_date":"2023-05-01 10:44:00","snet_input_date":"2023-05-01 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-05-01 10:44:00","insp_carrier_name":"SPRAY ALLIANCE CORP","insp_carrier_street":"48 UNION ST STE 20","insp_carrier_city":"STAMFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06906-1342","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:20:53.000000Z","updated_at":"2025-03-17T19:20:53.000000Z","inspection_violations":[{"id":4489741,"change_date":"2023-05-01 10:44:00","inspection_id":"78486306","insp_violation_id":"252522950","seq_no":"4","part_no":"396","part_no_section":"9(d)(2)","insp_viol_unit":"1","insp_unit_id":"194660021","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"K192GP6SMB","created_at":"2025-03-17T21:27:56.000000Z","updated_at":"2025-03-17T21:27:56.000000Z","normalized_code":"3969D2"},{"id":4489742,"change_date":"2023-05-01 10:44:00","inspection_id":"78486306","insp_violation_id":"252522951","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"194660021","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"K192GP6RZJ","created_at":"2025-03-17T21:27:56.000000Z","updated_at":"2025-03-17T21:27:56.000000Z","normalized_code":"39395A"},{"id":4489743,"change_date":"2023-05-01 10:44:00","inspection_id":"78486306","insp_violation_id":"252522952","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194660021","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"K192GP6SDC","created_at":"2025-03-17T21:27:56.000000Z","updated_at":"2025-03-17T21:27:56.000000Z","normalized_code":"3939A"},{"id":4489744,"change_date":"2023-05-01 10:44:00","inspection_id":"78486306","insp_violation_id":"252522953","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194660021","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"K192GP6STS","created_at":"2025-03-17T21:27:56.000000Z","updated_at":"2025-03-17T21:27:56.000000Z","normalized_code":"3939A"},{"id":4489745,"change_date":"2023-05-01 10:44:00","inspection_id":"78486306","insp_violation_id":"252522954","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194660021","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"K192GP6SKW","created_at":"2025-03-17T21:27:56.000000Z","updated_at":"2025-03-17T21:27:56.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4706530,"change_date":"2023-05-01 10:44:00","inspection_id":"78486306","insp_unit_id":"194660021","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BA88516","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3ALACXDT3EDFR8549","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:06.000000Z","updated_at":"2025-03-17T22:40:06.000000Z"}]},{"id":2138235,"change_date":"2023-01-13 21:39:00","inspection_id":"77590033","dot_number":"3979095","report_state":"NY","report_number":"SPL0172877","insp_date":"2023-01-12 00:00:00","insp_start_time":"0657","insp_end_time":"0717","registration_date":null,"region":"ET","ci_status_code":"C","location":"00096F","location_desc":"YAPHANK (EB)","county_code_state":"NY","county_code":"103","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-13 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"4","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2788836","transaction_code":"A","transaction_date":"2023-01-13 00:00:00","upload_date":"2023-01-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03979095","upload_search_indicator":"M","census_search_date":"2023-01-13 21:39:00","snet_input_date":"2023-01-13 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-01-13 21:39:00","insp_carrier_name":"SPRAY ALLIANCE CORP","insp_carrier_street":"48 UNION ST STE 20","insp_carrier_city":"STAMFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06906-1342","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:05:55.000000Z","updated_at":"2025-03-17T19:05:55.000000Z","inspection_violations":[{"id":3308855,"change_date":"2023-01-13 21:39:00","inspection_id":"77590033","insp_violation_id":"250561774","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"1G9RQT8","created_at":"2025-03-17T21:22:39.000000Z","updated_at":"2025-03-17T21:22:39.000000Z","normalized_code":"3922"},{"id":3308856,"change_date":"2023-01-13 21:39:00","inspection_id":"77590033","insp_violation_id":"250561775","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:22:39.000000Z","updated_at":"2025-03-17T21:22:39.000000Z","normalized_code":"39141A"},{"id":3308857,"change_date":"2023-01-13 21:39:00","inspection_id":"77590033","insp_violation_id":"250561776","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192860906","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:39.000000Z","updated_at":"2025-03-17T21:22:39.000000Z","normalized_code":"3922"},{"id":3308858,"change_date":"2023-01-13 21:39:00","inspection_id":"77590033","insp_violation_id":"250561777","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192860906","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"1G9RR27","created_at":"2025-03-17T21:22:39.000000Z","updated_at":"2025-03-17T21:22:39.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3440785,"change_date":"2023-01-13 21:39:00","inspection_id":"77590033","insp_unit_id":"192860906","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BA88516","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3ALACXDT3EDFR8549","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:40.000000Z","updated_at":"2025-03-17T22:30:40.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3979095\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3979095\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3979095\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next »","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/searchcarriers.com\/company\/3979095\/inspections","per_page":100,"prev_page_url":null,"to":7,"total":7}