{"current_page":1,"data":[{"id":12710696,"change_date":"2026-08-13 21:42:00","inspection_id":"88685701","dot_number":"1531354","report_state":"NY","report_number":"SPC3022036","insp_date":"2026-08-06 00:00:00","insp_start_time":"0948","insp_end_time":"1013","registration_date":"2026-08-07 00:00:00","region":"ED","ci_status_code":"C","location":"70877S","location_desc":"WATERTOWN NY","county_code_state":"NY","county_code":"045","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MCQUADE AND BANNIGAN INC","shipping_paper_number":"79680","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-08-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3972256","transaction_code":"A","transaction_date":"2026-08-12 00:00:00","upload_date":"2026-08-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":null,"census_search_date":"2026-08-13 21:42:00","snet_input_date":"2026-08-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-08-13 21:42:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-08-16T09:40:50.000000Z","updated_at":"2026-08-17T09:38:40.000000Z","inspection_violations":[{"id":22130164,"change_date":"2026-08-13 21:42:00","inspection_id":"88685701","insp_violation_id":"276099085","seq_no":"1","part_no":"393","part_no_section":"55C2-B","insp_viol_unit":"1","insp_unit_id":"215128738","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-16T10:00:13.000000Z","updated_at":"2026-08-17T09:55:36.000000Z","normalized_code":"39355C2B"}],"inspection_per_units":[{"id":22059014,"change_date":"2026-08-13 21:42:00","inspection_id":"88685701","insp_unit_id":"215128738","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"46744NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ7AT8R5T50657","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-16T09:19:45.000000Z","updated_at":"2026-08-17T09:14:08.000000Z"}]},{"id":12222204,"change_date":"2026-06-18 21:41:00","inspection_id":"88180022","dot_number":"1531354","report_state":"NY","report_number":"SPB3130538","insp_date":"2026-06-11 00:00:00","insp_start_time":"1420","insp_end_time":"1438","registration_date":"2026-06-17 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"OSWEGATCHIE NY","county_code_state":"NY","county_code":"089","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":"U","pen_cen_match":"I","final_status_date":"2026-06-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14070","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":"3567864","transaction_code":"A","transaction_date":"2026-06-17 00:00:00","upload_date":"2026-06-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":null,"census_search_date":"2026-06-18 21:41:00","snet_input_date":"2026-06-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-18 21:41:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-06-21T09:43:37.000000Z","updated_at":"2026-06-29T09:30:49.000000Z","inspection_violations":[{"id":21272903,"change_date":"2026-06-18 21:41:00","inspection_id":"88180022","insp_violation_id":"274992048","seq_no":"1","part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-21T10:04:53.000000Z","updated_at":"2026-06-29T09:42:36.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":21226407,"change_date":"2026-06-18 21:41:00","inspection_id":"88180022","insp_unit_id":"214171648","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":null,"insp_unit_license":"44151ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GCRDAED7PZ148066","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-21T09:19:27.000000Z","updated_at":"2026-06-29T09:01:48.000000Z"},{"id":21226408,"change_date":"2026-06-18 21:41:00","inspection_id":"88180022","insp_unit_id":"214171649","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"CK61948","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5JW1U1824N2373195","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-21T09:19:27.000000Z","updated_at":"2026-06-29T09:01:48.000000Z"}]},{"id":12073488,"change_date":"2026-06-02 21:41:00","inspection_id":"88015783","dot_number":"1531354","report_state":"NY","report_number":"SPT3101600","insp_date":"2026-05-26 00:00:00","insp_start_time":"1225","insp_end_time":"1232","registration_date":null,"region":"ED","ci_status_code":"C","location":"22058M","location_desc":"UTICA NY","county_code_state":"NY","county_code":"065","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MCQUADE & BANNIGAN INC","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":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3445258","transaction_code":"A","transaction_date":"2026-06-01 00:00:00","upload_date":"2026-06-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":null,"census_search_date":"2026-06-02 21:41:00","snet_input_date":"2026-05-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-02 21:41:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-06-06T09:40:20.000000Z","updated_at":"2026-06-13T09:30:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20981867,"change_date":"2026-06-02 21:41:00","inspection_id":"88015783","insp_unit_id":"213864482","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"46744NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ7AT8R5T50657","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-06T09:17:09.000000Z","updated_at":"2026-06-13T09:01:47.000000Z"}]},{"id":12034772,"change_date":"2026-05-28 21:41:00","inspection_id":"87975045","dot_number":"1531354","report_state":"NY","report_number":"SPC3021862","insp_date":"2026-05-21 00:00:00","insp_start_time":"1037","insp_end_time":"1106","registration_date":null,"region":"ED","ci_status_code":"C","location":"70877S","location_desc":"WATERTOWN NY","county_code_state":"NY","county_code":"045","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MCQUADE AND BANNIGAN","shipping_paper_number":"78692","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-05-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3414249","transaction_code":"A","transaction_date":"2026-05-27 00:00:00","upload_date":"2026-05-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":null,"census_search_date":"2026-05-28 21:41:00","snet_input_date":"2026-05-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-28 21:41:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-06-01T09:39:48.000000Z","updated_at":"2026-06-08T09:30:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20918064,"change_date":"2026-05-28 21:41:00","inspection_id":"87975045","insp_unit_id":"213787021","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"46744NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ7AT8R5T50657","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-01T09:16:57.000000Z","updated_at":"2026-06-08T09:01:43.000000Z"}]},{"id":11572591,"change_date":"2026-04-06 21:37:00","inspection_id":"87496546","dot_number":"1531354","report_state":"NY","report_number":"SPT3101447","insp_date":"2026-03-30 00:00:00","insp_start_time":"1215","insp_end_time":"1219","registration_date":null,"region":"ED","ci_status_code":"C","location":"20854E","location_desc":"VERONA NY","county_code_state":"NY","county_code":"065","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":"2026-04-06 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3117222","transaction_code":"A","transaction_date":"2026-04-05 00:00:00","upload_date":"2026-04-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":null,"census_search_date":"2026-04-06 21:37:00","snet_input_date":"2026-03-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-06 21:37:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-04-09T09:49:02.000000Z","updated_at":"2026-04-17T09:32:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19834465,"change_date":"2026-04-06 21:37:00","inspection_id":"87496546","insp_unit_id":"212556529","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"46744NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ7AT8R5T50657","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-09T09:42:51.000000Z","updated_at":"2026-04-18T09:14:49.000000Z"}]},{"id":11232176,"change_date":"2026-02-26 21:40:00","inspection_id":"87144438","dot_number":"1531354","report_state":"NY","report_number":"SPD3011672","insp_date":"2026-02-19 00:00:00","insp_start_time":"1125","insp_end_time":"1141","registration_date":null,"region":"ES","ci_status_code":"C","location":"30382S","location_desc":"HASTINGS NY","county_code_state":"NY","county_code":"075","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MCQUADE AND BANNIGAN INC","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-02-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"16600","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2935139","transaction_code":"A","transaction_date":"2026-02-25 00:00:00","upload_date":"2026-02-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":null,"census_search_date":"2026-02-26 21:40:00","snet_input_date":"2026-02-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-26 21:40:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-03-01T10:38:50.000000Z","updated_at":"2026-03-09T09:30:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19200061,"change_date":"2026-02-26 21:40:00","inspection_id":"87144438","insp_unit_id":"211843220","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":null,"insp_unit_license":"44166ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GCZGGFP6P1120759","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-01T10:15:37.000000Z","updated_at":"2026-03-09T09:06:36.000000Z"},{"id":19200062,"change_date":"2026-02-26 21:40:00","inspection_id":"87144438","insp_unit_id":"211843221","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"CD68373","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5A3U612D0LL001195","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-01T10:15:37.000000Z","updated_at":"2026-03-09T09:06:36.000000Z"}]},{"id":11138875,"change_date":"2026-02-15 21:33:00","inspection_id":"87052803","dot_number":"1531354","report_state":"NY","report_number":"D305502752","insp_date":"2026-02-12 00:00:00","insp_start_time":"1106","insp_end_time":"1124","registration_date":null,"region":"ES","ci_status_code":"C","location":"30382S","location_desc":"HASTINGS NY","county_code_state":"NY","county_code":"075","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MCQUADE AND BANNIGAN INC","shipping_paper_number":"77531","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-02-15 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2890858","transaction_code":"A","transaction_date":"2026-02-15 00:00:00","upload_date":"2026-02-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":null,"census_search_date":"2026-02-15 21:33:00","snet_input_date":"2026-02-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-15 21:33:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-02-18T10:37:14.000000Z","updated_at":"2026-02-26T10:30:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19001290,"change_date":"2026-02-15 21:33:00","inspection_id":"87052803","insp_unit_id":"211637462","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"46744NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ7AT8R5T50657","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-18T10:12:47.000000Z","updated_at":"2026-02-26T10:02:25.000000Z"}]},{"id":10872029,"change_date":"2026-01-28 21:37:00","inspection_id":"86902078","dot_number":"1531354","report_state":"NY","report_number":"SPD3081569","insp_date":"2026-01-21 00:00:00","insp_start_time":"0956","insp_end_time":"1013","registration_date":null,"region":"ES","ci_status_code":"C","location":"70877S","location_desc":"WATERTOWN NY","county_code_state":"NY","county_code":"045","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":"2026-01-28 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2818608","transaction_code":"A","transaction_date":"2026-01-27 00:00:00","upload_date":"2026-01-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":null,"census_search_date":"2026-01-28 21:37:00","snet_input_date":"2026-01-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-28 21:37:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-01-31T10:36:23.000000Z","updated_at":"2026-02-08T10:31:00.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18272375,"change_date":"2026-01-28 21:37:00","inspection_id":"86902078","insp_unit_id":"211316704","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"46744NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ7AT8R5T50657","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-31T10:10:57.000000Z","updated_at":"2026-02-08T10:04:12.000000Z"}]},{"id":10803613,"change_date":"2026-01-19 21:34:00","inspection_id":"86830392","dot_number":"1531354","report_state":"NY","report_number":"SPD3021490","insp_date":"2026-01-12 00:00:00","insp_start_time":"1103","insp_end_time":"1110","registration_date":null,"region":"ES","ci_status_code":"C","location":"30382S","location_desc":"HASTINGS NY","county_code_state":"NY","county_code":"075","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MCQUADE AND BANNIGAN INC","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-01-19 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2785315","transaction_code":"A","transaction_date":"2026-01-18 00:00:00","upload_date":"2026-01-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":null,"census_search_date":"2026-01-19 21:34:00","snet_input_date":"2026-01-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-19 21:34:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-01-22T10:36:01.000000Z","updated_at":"2026-01-30T10:30:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18138970,"change_date":"2026-01-19 21:34:00","inspection_id":"86830392","insp_unit_id":"211160922","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"46744NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ7AT8R5T50657","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-24T10:08:09.000000Z","updated_at":"2026-01-30T10:00:12.000000Z"}]},{"id":10395170,"change_date":"2025-12-10 21:38:00","inspection_id":"86525124","dot_number":"1531354","report_state":"NY","report_number":"SPC3051202","insp_date":"2025-12-03 00:00:00","insp_start_time":"1040","insp_end_time":"1058","registration_date":null,"region":"ES","ci_status_code":"C","location":"70877S","location_desc":"WATERTOWN NY","county_code_state":"NY","county_code":"045","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MCQUADE & BANNIGAN INC","shipping_paper_number":"76775","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":"2025-12-10 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2636879","transaction_code":"A","transaction_date":"2025-12-09 00:00:00","upload_date":"2025-12-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":null,"census_search_date":"2025-12-10 21:38:00","snet_input_date":"2025-12-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-12-10 21:38:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-12-13T10:31:33.000000Z","updated_at":"2025-12-14T10:30:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17380938,"change_date":"2025-12-10 21:38:00","inspection_id":"86525124","insp_unit_id":"210517707","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"46744NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ7AT8R5T50657","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-13T10:01:46.000000Z","updated_at":"2025-12-14T10:00:35.000000Z"}]},{"id":10134837,"change_date":"2025-11-06 21:40:00","inspection_id":"86252149","dot_number":"1531354","report_state":"NY","report_number":"D305401065","insp_date":"2025-11-05 00:00:00","insp_start_time":"0939","insp_end_time":"1005","registration_date":null,"region":"ES","ci_status_code":"C","location":"70877S","location_desc":"WATERTOWN NY","county_code_state":"NY","county_code":"045","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MCQUADE AND BANNIGAN INC","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":"U","pen_cen_match":"I","final_status_date":"2025-11-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2509295","transaction_code":"A","transaction_date":"2025-11-06 00:00:00","upload_date":"2025-11-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":null,"census_search_date":"2025-11-06 21:40:00","snet_input_date":"2025-11-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-06 21:40:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-11-09T10:31:37.000000Z","updated_at":"2025-11-10T10:30:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16870711,"change_date":"2025-11-06 21:40:00","inspection_id":"86252149","insp_unit_id":"209877191","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"46744NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ7AT8R5T50657","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-09T10:01:51.000000Z","updated_at":"2025-11-10T10:00:48.000000Z"}]},{"id":10088501,"change_date":"2025-10-31 21:40:00","inspection_id":"86203418","dot_number":"1531354","report_state":"NY","report_number":"D305401031","insp_date":"2025-10-27 00:00:00","insp_start_time":"0955","insp_end_time":"1030","registration_date":null,"region":"ED","ci_status_code":"C","location":"70877S","location_desc":"WATERTOWN NY","county_code_state":"NY","county_code":"045","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MCQUADE AND BANNIGAN INC","shipping_paper_number":"76360","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":"2025-10-31 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2485881","transaction_code":"A","transaction_date":"2025-10-31 00:00:00","upload_date":"2025-10-31 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":null,"census_search_date":"2025-10-31 21:40:00","snet_input_date":"2025-10-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-31 21:40:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-11-03T11:04:47.000000Z","updated_at":"2025-11-04T11:00:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16773736,"change_date":"2025-10-31 21:40:00","inspection_id":"86203418","insp_unit_id":"209761739","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"46744NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ7AT8R5T50657","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-03T10:47:12.000000Z","updated_at":"2025-11-04T10:45:40.000000Z"}]},{"id":10002231,"change_date":"2025-10-22 21:38:00","inspection_id":"86112448","dot_number":"1531354","report_state":"NY","report_number":"SPD3031476","insp_date":"2025-10-15 00:00:00","insp_start_time":"0903","insp_end_time":"0921","registration_date":null,"region":"ED","ci_status_code":"C","location":"70877N","location_desc":"WATERTOWN NY","county_code_state":"NY","county_code":"045","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MCQUADE AND BANNIGAN INC","shipping_paper_number":"76186","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":"2025-10-22 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2440678","transaction_code":"A","transaction_date":"2025-10-21 00:00:00","upload_date":"2025-10-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":null,"census_search_date":"2025-10-22 21:38:00","snet_input_date":"2025-10-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-22 21:38:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-10-25T10:01:19.000000Z","updated_at":"2025-10-26T10:00:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16611526,"change_date":"2025-10-22 21:38:00","inspection_id":"86112448","insp_unit_id":"209588219","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"46744NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ7AT8R5T50657","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-25T09:46:35.000000Z","updated_at":"2025-10-26T09:45:09.000000Z"}]},{"id":9954610,"change_date":"2025-10-16 21:39:00","inspection_id":"86062359","dot_number":"1531354","report_state":"NY","report_number":"SPD3061112","insp_date":"2025-10-09 00:00:00","insp_start_time":"1051","insp_end_time":"1121","registration_date":null,"region":"ED","ci_status_code":"C","location":"30382S","location_desc":"HASTINGS NY","county_code_state":"NY","county_code":"075","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MCQUADE AND BANNIGAN INC","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":"2025-10-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2417368","transaction_code":"A","transaction_date":"2025-10-15 00:00:00","upload_date":"2025-10-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":null,"census_search_date":"2025-10-16 21:39:00","snet_input_date":"2025-10-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-16 21:39:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-10-19T10:01:27.000000Z","updated_at":"2025-10-20T10:00:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16526360,"change_date":"2025-10-16 21:39:00","inspection_id":"86062359","insp_unit_id":"209494882","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"46744NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ7AT8R5T50657","insp_unit_decal":"Y","insp_unit_decal_number":"35750138","created_at":"2025-10-19T09:46:47.000000Z","updated_at":"2025-10-20T09:45:15.000000Z"}]},{"id":9751283,"change_date":"2025-10-08 21:39:00","inspection_id":"85848512","dot_number":"1531354","report_state":"NY","report_number":"SPC3021121","insp_date":"2025-09-17 00:00:00","insp_start_time":"0801","insp_end_time":"0841","registration_date":"2025-09-25 00:00:00","region":"ED","ci_status_code":"C","location":"70877S","location_desc":"WATERTOWN NY","county_code_state":"NY","county_code":"045","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-09-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"19600","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2313576","transaction_code":"C","transaction_date":"2025-09-23 00:00:00","upload_date":"2025-10-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":null,"census_search_date":"2025-09-23 21:42:00","snet_input_date":"2025-09-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-23 21:42:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-09-25T10:00:41.000000Z","updated_at":"2025-10-12T10:00:05.000000Z","inspection_violations":[{"id":16289729,"change_date":"2025-10-08 21:39:00","inspection_id":"85848512","insp_violation_id":"269162530","seq_no":"1","part_no":"393","part_no_section":"43D-B","insp_viol_unit":"2","insp_unit_id":"209351925","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"8C87KS6PMV","created_at":"2025-10-11T10:17:38.000000Z","updated_at":"2025-10-12T10:15:06.000000Z","normalized_code":"39343DB"}],"inspection_per_units":[{"id":16393711,"change_date":"2025-10-08 21:39:00","inspection_id":"85848512","insp_unit_id":"209351924","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":null,"insp_unit_license":"44166ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GCZGGFP6P1120759","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-11T09:46:56.000000Z","updated_at":"2025-10-12T09:45:06.000000Z"},{"id":16393712,"change_date":"2025-10-08 21:39:00","inspection_id":"85848512","insp_unit_id":"209351925","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"BL19402","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5JPBU2421HP046336","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-11T09:46:56.000000Z","updated_at":"2025-10-12T09:45:06.000000Z"}]},{"id":9738591,"change_date":"2025-09-22 21:38:00","inspection_id":"85835051","dot_number":"1531354","report_state":"NY","report_number":"SPD3031377","insp_date":"2025-09-15 00:00:00","insp_start_time":"1053","insp_end_time":"1108","registration_date":null,"region":"ED","ci_status_code":"C","location":"30382S","location_desc":"HASTINGS NY","county_code_state":"NY","county_code":"075","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":"2025-09-22 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2306676","transaction_code":"A","transaction_date":"2025-09-21 00:00:00","upload_date":"2025-09-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":null,"census_search_date":"2025-09-22 21:38:00","snet_input_date":"2025-09-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-22 21:38:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-09-25T10:00:12.000000Z","updated_at":"2025-09-25T10:00:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16127203,"change_date":"2025-09-22 21:38:00","inspection_id":"85835051","insp_unit_id":"209064263","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"46744NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ7AT8R5T50657","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-25T09:45:17.000000Z","updated_at":"2025-09-26T09:45:05.000000Z"}]},{"id":9648695,"change_date":"2025-09-11 21:40:00","inspection_id":"85742290","dot_number":"1531354","report_state":"NY","report_number":"SPD3011170","insp_date":"2025-09-04 00:00:00","insp_start_time":"1055","insp_end_time":"1116","registration_date":null,"region":"ED","ci_status_code":"C","location":"30382S","location_desc":"HASTINGS NY","county_code_state":"NY","county_code":"075","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MCQUADE AND BANNIGAN INC","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":"2025-09-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2250016","transaction_code":"A","transaction_date":"2025-09-10 00:00:00","upload_date":"2025-09-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":null,"census_search_date":"2025-09-11 21:40:00","snet_input_date":"2025-09-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-11 21:40:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-09-13T10:47:44.000000Z","updated_at":"2025-09-16T10:46:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15942573,"change_date":"2025-09-11 21:40:00","inspection_id":"85742290","insp_unit_id":"208864026","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"46744NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ7AT8R5T50657","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-13T10:00:30.000000Z","updated_at":"2025-09-15T09:52:41.000000Z"}]},{"id":9407487,"change_date":"2025-08-14 21:39:00","inspection_id":"85487223","dot_number":"1531354","report_state":"NY","report_number":"SPB3050693","insp_date":"2025-08-07 00:00:00","insp_start_time":"1024","insp_end_time":"1030","registration_date":null,"region":"ED","ci_status_code":"C","location":"70725","location_desc":"ANTWERP NY","county_code_state":"NY","county_code":"089","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MC QUADE & BANNIGAN","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":"2025-08-14 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"19600","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2125146","transaction_code":"A","transaction_date":"2025-08-13 00:00:00","upload_date":"2025-08-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":null,"census_search_date":"2025-08-14 21:39:00","snet_input_date":"2025-08-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-14 21:39:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-08-17T10:01:07.000000Z","updated_at":"2025-08-20T10:43:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15504798,"change_date":"2025-08-14 21:39:00","inspection_id":"85487223","insp_unit_id":"208387980","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":null,"insp_unit_license":"44166ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GCZGGFP6P1120759","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-17T09:46:19.000000Z","updated_at":"2025-08-18T09:45:08.000000Z"},{"id":15504799,"change_date":"2025-08-14 21:39:00","inspection_id":"85487223","insp_unit_id":"208387981","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"CC15291","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5JW1U1824N2373195","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-17T09:46:19.000000Z","updated_at":"2025-08-18T09:45:08.000000Z"}]},{"id":9408725,"change_date":"2025-08-27 21:40:00","inspection_id":"85488527","dot_number":"1531354","report_state":"NY","report_number":"SPC3050873","insp_date":"2025-08-07 00:00:00","insp_start_time":"1014","insp_end_time":"1035","registration_date":"2025-08-07 00:00:00","region":"ED","ci_status_code":"C","location":"70877S","location_desc":"WATERTOWN NY","county_code_state":"NY","county_code":"045","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MACQUADE AND BANNIGAN INC","shipping_paper_number":"75239","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":"2025-08-14 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2126746","transaction_code":"C","transaction_date":"2025-08-13 00:00:00","upload_date":"2025-08-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":null,"census_search_date":"2025-08-14 21:39:00","snet_input_date":"2025-08-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-14 21:39:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-08-17T10:01:08.000000Z","updated_at":"2025-09-06T10:41:19.000000Z","inspection_violations":[{"id":15532819,"change_date":"2025-08-27 21:40:00","inspection_id":"85488527","insp_violation_id":"268283244","seq_no":"1","part_no":"393","part_no_section":"75A1-TFBMF","insp_viol_unit":"1","insp_unit_id":"208609705","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-09-05T10:50:20.000000Z","updated_at":"2025-09-06T10:44:16.000000Z","normalized_code":"39375A1TFBMF"}],"inspection_per_units":[{"id":15708563,"change_date":"2025-08-27 21:40:00","inspection_id":"85488527","insp_unit_id":"208609705","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"46744NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ7AT8R5T50657","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-05T09:46:35.000000Z","updated_at":"2025-09-09T09:45:34.000000Z"}]},{"id":9318821,"change_date":"2025-08-04 21:38:00","inspection_id":"85394168","dot_number":"1531354","report_state":"NY","report_number":"SPD3031242","insp_date":"2025-07-28 00:00:00","insp_start_time":"1225","insp_end_time":"1242","registration_date":null,"region":"ED","ci_status_code":"C","location":"22058M","location_desc":"UTICA NY","county_code_state":"NY","county_code":"065","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-08-04 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2080450","transaction_code":"A","transaction_date":"2025-08-03 00:00:00","upload_date":"2025-08-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":null,"census_search_date":"2025-08-04 21:38:00","snet_input_date":"2025-07-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-04 21:38:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-08-07T10:44:45.000000Z","updated_at":"2025-08-08T10:00:22.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15346604,"change_date":"2025-08-04 21:38:00","inspection_id":"85394168","insp_unit_id":"208217010","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"46774NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ7AT8R5T50657","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-07T09:45:24.000000Z","updated_at":"2025-08-08T09:45:24.000000Z"}]},{"id":9220521,"change_date":"2025-07-23 21:41:00","inspection_id":"85290597","dot_number":"1531354","report_state":"NY","report_number":"SPD3080955","insp_date":"2025-07-16 00:00:00","insp_start_time":"1005","insp_end_time":"1021","registration_date":null,"region":"ED","ci_status_code":"C","location":"30382S","location_desc":"HASTINGS NY","county_code_state":"NY","county_code":"075","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-07-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2028613","transaction_code":"A","transaction_date":"2025-07-22 00:00:00","upload_date":"2025-07-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":null,"census_search_date":"2025-07-23 21:41:00","snet_input_date":"2025-07-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-23 21:41:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-07-27T10:41:25.000000Z","updated_at":"2025-07-27T10:41:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15167665,"change_date":"2025-07-23 21:41:00","inspection_id":"85290597","insp_unit_id":"208020708","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"46744NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ7AT8R5T50657","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-26T09:46:23.000000Z","updated_at":"2025-07-27T09:45:25.000000Z"}]},{"id":9161947,"change_date":"2025-07-16 21:40:00","inspection_id":"85229079","dot_number":"1531354","report_state":"NY","report_number":"SPC3030955","insp_date":"2025-07-09 00:00:00","insp_start_time":"1008","insp_end_time":"1021","registration_date":null,"region":"ED","ci_status_code":"C","location":"70877S","location_desc":"WATERTOWN NY","county_code_state":"NY","county_code":"045","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MCQUADE & BANNIGAN INC","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":"2025-07-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1997511","transaction_code":"A","transaction_date":"2025-07-15 00:00:00","upload_date":"2025-07-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":null,"census_search_date":"2025-07-16 21:40:00","snet_input_date":"2025-07-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-16 21:40:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-07-19T10:42:29.000000Z","updated_at":"2025-07-21T10:42:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15048830,"change_date":"2025-07-16 21:40:00","inspection_id":"85229079","insp_unit_id":"207896077","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"46744NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ7AT8R5T50657","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-19T09:46:14.000000Z","updated_at":"2025-07-20T09:45:30.000000Z"}]},{"id":8976860,"change_date":"2025-06-25 21:39:00","inspection_id":"85034511","dot_number":"1531354","report_state":"NY","report_number":"SPC3040356","insp_date":"2025-06-18 00:00:00","insp_start_time":"0950","insp_end_time":"1005","registration_date":null,"region":"ED","ci_status_code":"C","location":"70877S","location_desc":"WATERTOWN NY","county_code_state":"NY","county_code":"045","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MCQUADE &BANNIGAN","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":"2025-06-25 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"2550","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1910506","transaction_code":"A","transaction_date":"2025-06-24 00:00:00","upload_date":"2025-06-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":null,"census_search_date":"2025-06-25 21:39:00","snet_input_date":"2025-06-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-25 21:39:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-06-28T10:00:59.000000Z","updated_at":"2025-06-30T10:00:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14718622,"change_date":"2025-06-25 21:39:00","inspection_id":"85034511","insp_unit_id":"207538296","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"46744NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ7AT8R5T50657","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-28T09:46:09.000000Z","updated_at":"2025-06-29T09:45:18.000000Z"}]},{"id":8710447,"change_date":"2025-05-22 21:41:00","inspection_id":"84751895","dot_number":"1531354","report_state":"NY","report_number":"SPB4020172","insp_date":"2025-05-15 00:00:00","insp_start_time":"1200","insp_end_time":"1223","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"OSWEGATCHIE NY","county_code_state":"NY","county_code":"089","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":"U","pen_cen_match":"I","final_status_date":"2025-05-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"1766371","transaction_code":"A","transaction_date":"2025-05-22 00:00:00","upload_date":"2025-05-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":null,"census_search_date":"2025-05-22 21:41:00","snet_input_date":"2025-05-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-22 21:41:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-05-25T10:05:00.000000Z","updated_at":"2025-05-26T10:04:37.000000Z","inspection_violations":[{"id":13885803,"change_date":"2025-05-22 21:41:00","inspection_id":"84751895","insp_violation_id":"266400097","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"207008090","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-25T10:26:09.000000Z","updated_at":"2025-05-26T10:21:50.000000Z","normalized_code":"3922SLLSR"},{"id":13885804,"change_date":"2025-05-22 21:41:00","inspection_id":"84751895","insp_violation_id":"266400098","seq_no":"2","part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-25T10:26:09.000000Z","updated_at":"2025-05-26T10:21:50.000000Z","normalized_code":"3922SLLTCD"},{"id":13885805,"change_date":"2025-05-22 21:41:00","inspection_id":"84751895","insp_violation_id":"266400099","seq_no":"3","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"2","insp_unit_id":"207008091","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"S25032282","created_at":"2025-05-25T10:26:09.000000Z","updated_at":"2025-05-26T10:21:50.000000Z","normalized_code":"3939ALLPL"}],"inspection_per_units":[{"id":14234717,"change_date":"2025-05-22 21:41:00","inspection_id":"84751895","insp_unit_id":"207008090","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":null,"insp_unit_license":"40079MH","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GCZGGFGXG1175389","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-25T09:50:39.000000Z","updated_at":"2025-05-26T09:49:43.000000Z"},{"id":14234718,"change_date":"2025-05-22 21:41:00","inspection_id":"84751895","insp_unit_id":"207008091","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"CC15291","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5JW1U1824N2373195","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-25T09:50:39.000000Z","updated_at":"2025-05-26T09:49:43.000000Z"}]},{"id":8577012,"change_date":"2025-05-08 21:40:00","inspection_id":"84611350","dot_number":"1531354","report_state":"NY","report_number":"D103400209","insp_date":"2025-05-07 00:00:00","insp_start_time":"1240","insp_end_time":"1310","registration_date":null,"region":"ED","ci_status_code":"C","location":"22058M","location_desc":"UTICA NY","county_code_state":"NY","county_code":"065","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-05-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1699903","transaction_code":"A","transaction_date":"2025-05-08 00:00:00","upload_date":"2025-05-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":null,"census_search_date":"2025-05-08 21:40:00","snet_input_date":"2025-05-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-08 21:40:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-05-11T10:21:04.000000Z","updated_at":"2025-05-12T10:02:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13998769,"change_date":"2025-05-08 21:40:00","inspection_id":"84611350","insp_unit_id":"206753324","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"46744NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ7AT8R5T50657","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-11T03:54:46.000000Z","updated_at":"2025-05-12T09:49:25.000000Z"}]},{"id":8398443,"change_date":"2025-04-17 21:41:00","inspection_id":"84423130","dot_number":"1531354","report_state":"NY","report_number":"SPD3070623","insp_date":"2025-04-10 00:00:00","insp_start_time":"1108","insp_end_time":"1126","registration_date":null,"region":"ED","ci_status_code":"C","location":"30382S","location_desc":"HASTINGS NY","county_code_state":"NY","county_code":"075","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MCQUADE AND BANNIGAN INC","shipping_paper_number":"8074777","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":"2025-04-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1605360","transaction_code":"A","transaction_date":"2025-04-17 00:00:00","upload_date":"2025-04-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":null,"census_search_date":"2025-04-17 21:41:00","snet_input_date":"2025-04-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-17 21:41:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-04-20T10:27:38.000000Z","updated_at":"2025-04-21T10:21:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13633463,"change_date":"2025-04-17 21:41:00","inspection_id":"84423130","insp_unit_id":"206355123","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"46744NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ7AT8R5T50657","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-20T10:07:17.000000Z","updated_at":"2025-04-21T09:51:04.000000Z"}]},{"id":8207404,"change_date":"2025-03-26 21:40:00","inspection_id":"84222612","dot_number":"1531354","report_state":"NY","report_number":"SPD3080530","insp_date":"2025-03-19 00:00:00","insp_start_time":"1018","insp_end_time":"1030","registration_date":null,"region":"ED","ci_status_code":"C","location":"70877S","location_desc":"WATERTOWN NY","county_code_state":"NY","county_code":"045","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":"2025-03-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1513652","transaction_code":"A","transaction_date":"2025-03-26 00:00:00","upload_date":"2025-03-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":null,"census_search_date":"2025-03-26 21:40:00","snet_input_date":"2025-03-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-26 21:40:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-29T10:21:00.000000Z","updated_at":"2025-03-30T10:34:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13271581,"change_date":"2025-03-26 21:40:00","inspection_id":"84222612","insp_unit_id":"205984223","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"46744NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ7AT8R5T50657","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-29T10:02:41.000000Z","updated_at":"2025-03-30T09:56:20.000000Z"}]},{"id":8005837,"change_date":"2025-03-03 21:38:00","inspection_id":"84009899","dot_number":"1531354","report_state":"NY","report_number":"SPT3030908","insp_date":"2025-02-24 00:00:00","insp_start_time":"1208","insp_end_time":"1222","registration_date":null,"region":"ES","ci_status_code":"C","location":"20854E","location_desc":"VERONA NY","county_code_state":"NY","county_code":"065","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MCQUADE & BANNING INC","shipping_paper_number":"73033","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":"2025-03-03 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1422453","transaction_code":"A","transaction_date":"2025-03-03 00:00:00","upload_date":"2025-03-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":null,"census_search_date":"2025-03-03 21:38:00","snet_input_date":"2025-02-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-03 21:38:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T21:04:29.000000Z","updated_at":"2025-03-17T21:04:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12924901,"change_date":"2025-03-03 21:38:00","inspection_id":"84009899","insp_unit_id":"205587386","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"46744NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ7AT8R5T50657","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:44.000000Z","updated_at":"2025-03-17T23:57:44.000000Z"}]},{"id":7789173,"change_date":"2025-02-05 21:39:00","inspection_id":"83782570","dot_number":"1531354","report_state":"NY","report_number":"D305400646","insp_date":"2025-02-03 00:00:00","insp_start_time":"1015","insp_end_time":"1034","registration_date":null,"region":"ES","ci_status_code":"C","location":"70877S","location_desc":"WATERTOWN NY","county_code_state":"NY","county_code":"045","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MCQUADE AND BANNIGAN INC","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":"U","pen_cen_match":"I","final_status_date":"2025-02-05 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1324171","transaction_code":"A","transaction_date":"2025-02-05 00:00:00","upload_date":"2025-02-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":null,"census_search_date":"2025-02-05 21:39:00","snet_input_date":"2025-02-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-05 21:39:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:59:55.000000Z","updated_at":"2025-03-17T20:59:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12570509,"change_date":"2025-02-05 21:39:00","inspection_id":"83782570","insp_unit_id":"205163006","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"46744NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ7AT8R5T50657","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:53:53.000000Z","updated_at":"2025-03-17T23:53:53.000000Z"}]},{"id":7622384,"change_date":"2025-01-15 21:41:00","inspection_id":"83607284","dot_number":"1531354","report_state":"NY","report_number":"SPD3050394","insp_date":"2025-01-08 00:00:00","insp_start_time":"1120","insp_end_time":"1136","registration_date":null,"region":"ES","ci_status_code":"C","location":"30382S","location_desc":"HASTINGS NY","county_code_state":"NY","county_code":"075","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MCQUADE & BANNIGAN","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":"2025-01-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1249147","transaction_code":"A","transaction_date":"2025-01-15 00:00:00","upload_date":"2025-01-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":null,"census_search_date":"2025-01-15 21:41:00","snet_input_date":"2025-01-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-15 21:41:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:56:30.000000Z","updated_at":"2025-03-17T20:56:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12299105,"change_date":"2025-01-15 21:41:00","inspection_id":"83607284","insp_unit_id":"204840449","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"46744NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ7AT8R5T50657","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:43.000000Z","updated_at":"2025-03-17T23:50:43.000000Z"}]},{"id":7612733,"change_date":"2025-01-14 21:54:00","inspection_id":"83597217","dot_number":"1531354","report_state":"NY","report_number":"SPA3050278","insp_date":"2025-01-07 00:00:00","insp_start_time":"1205","insp_end_time":"1218","registration_date":null,"region":"ES","ci_status_code":"C","location":"30382S","location_desc":"HASTINGS NY","county_code_state":"NY","county_code":"075","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SLOCUM","shipping_paper_number":"2458852","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":"2025-01-14 21:54:00","post_acc_ind":"N","gross_comb_veh_wt":"19400","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1245536","transaction_code":"A","transaction_date":"2025-01-14 00:00:00","upload_date":"2025-01-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":null,"census_search_date":"2025-01-14 21:54:00","snet_input_date":"2025-01-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-14 21:54:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:56:09.000000Z","updated_at":"2025-03-17T20:56:09.000000Z","inspection_violations":[{"id":11900576,"change_date":"2025-01-14 21:54:00","inspection_id":"83597217","insp_violation_id":"263972337","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"204813593","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:00.000000Z","updated_at":"2025-03-17T22:04:00.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":12283583,"change_date":"2025-01-14 21:54:00","inspection_id":"83597217","insp_unit_id":"204813593","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":null,"insp_unit_license":"40079MH","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GCZGGFGXG1175389","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:33.000000Z","updated_at":"2025-03-17T23:50:33.000000Z"},{"id":12283584,"change_date":"2025-01-14 21:54:00","inspection_id":"83597217","insp_unit_id":"204813594","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNKNOWN","insp_unit_company":null,"insp_unit_license":"CC15291","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5JW1U1824N2373195","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:33.000000Z","updated_at":"2025-03-17T23:50:33.000000Z"}]},{"id":7560626,"change_date":"2025-01-07 21:39:00","inspection_id":"83542407","dot_number":"1531354","report_state":"NY","report_number":"SPC3060006","insp_date":"2024-12-31 00:00:00","insp_start_time":"1110","insp_end_time":"1130","registration_date":null,"region":"ES","ci_status_code":"C","location":"9077W","location_desc":"UNADILLA NY","county_code_state":"NY","county_code":"025","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","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":"U","pen_cen_match":"I","final_status_date":"2025-01-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"10850","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1222594","transaction_code":"A","transaction_date":"2025-01-07 00:00:00","upload_date":"2025-01-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":null,"census_search_date":"2025-01-07 21:39:00","snet_input_date":"2024-12-31 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-07 21:39:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:55:14.000000Z","updated_at":"2025-03-17T20:55:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12199131,"change_date":"2025-01-07 21:39:00","inspection_id":"83542407","insp_unit_id":"204677069","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":"1","insp_unit_license":"66951ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GC4YME7XRF142194","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:39.000000Z","updated_at":"2025-03-17T23:49:39.000000Z"}]},{"id":7297738,"change_date":"2024-11-28 21:34:00","inspection_id":"83266129","dot_number":"1531354","report_state":"NY","report_number":"SPD3010319","insp_date":"2024-11-21 00:00:00","insp_start_time":"1412","insp_end_time":"1436","registration_date":null,"region":"ES","ci_status_code":"C","location":"30382S","location_desc":"HASTINGS NY","county_code_state":"NY","county_code":"075","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MCQUADE AND BANNIGAN INC","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-11-28 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"19800","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1102127","transaction_code":"A","transaction_date":"2024-11-28 00:00:00","upload_date":"2024-11-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":null,"census_search_date":"2024-11-28 21:34:00","snet_input_date":"2024-11-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-28 21:34:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:48:12.000000Z","updated_at":"2025-03-17T20:48:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11771702,"change_date":"2024-11-28 21:34:00","inspection_id":"83266129","insp_unit_id":"204094286","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":null,"insp_unit_license":"44166ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GCZGGFP6P1120759","insp_unit_decal":"Y","insp_unit_decal_number":"34641244","created_at":"2025-03-17T23:45:01.000000Z","updated_at":"2025-03-17T23:45:01.000000Z"},{"id":11771703,"change_date":"2024-11-28 21:34:00","inspection_id":"83266129","insp_unit_id":"204094287","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"CC15291","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5JW1U1824N2373195","insp_unit_decal":"Y","insp_unit_decal_number":"34641245","created_at":"2025-03-17T23:45:01.000000Z","updated_at":"2025-03-17T23:45:01.000000Z"}]},{"id":6949895,"change_date":"2024-10-14 21:36:00","inspection_id":"82897599","dot_number":"1531354","report_state":"NY","report_number":"D305400431","insp_date":"2024-10-09 00:00:00","insp_start_time":"1015","insp_end_time":"1040","registration_date":null,"region":"ED","ci_status_code":"C","location":"70877S","location_desc":"WATERTOWN NY","county_code_state":"NY","county_code":"045","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MCQUADE AND BANNIGAN INC","shipping_paper_number":"71474","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-10-14 21:36:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"942223","transaction_code":"A","transaction_date":"2024-10-13 00:00:00","upload_date":"2024-10-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":null,"census_search_date":"2024-10-14 21:36:00","snet_input_date":"2024-10-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-14 21:36:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:41:01.000000Z","updated_at":"2025-03-17T20:41:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11209569,"change_date":"2024-10-14 21:36:00","inspection_id":"82897599","insp_unit_id":"203391702","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"46744NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ7AT8R5T50657","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:02.000000Z","updated_at":"2025-03-17T23:39:02.000000Z"}]},{"id":6822220,"change_date":"2024-09-26 21:39:00","inspection_id":"82761930","dot_number":"1531354","report_state":"NY","report_number":"SPD3050032","insp_date":"2024-09-19 00:00:00","insp_start_time":"1124","insp_end_time":"1140","registration_date":null,"region":"ED","ci_status_code":"C","location":"30382S","location_desc":"HASTINGS NY","county_code_state":"NY","county_code":"075","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MCQUADE&BANNIGAN INC","shipping_paper_number":"71202","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-09-26 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"886406","transaction_code":"A","transaction_date":"2024-09-26 00:00:00","upload_date":"2024-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":null,"census_search_date":"2024-09-26 21:39:00","snet_input_date":"2024-09-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-26 21:39:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:38:34.000000Z","updated_at":"2025-03-17T20:38:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11001562,"change_date":"2024-09-26 21:39:00","inspection_id":"82761930","insp_unit_id":"203135652","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"46744NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ7AT8R5T50657","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:57.000000Z","updated_at":"2025-03-17T23:36:57.000000Z"}]},{"id":6678200,"change_date":"2024-09-09 21:40:00","inspection_id":"82608497","dot_number":"1531354","report_state":"NY","report_number":"SPD0310011","insp_date":"2024-09-04 00:00:00","insp_start_time":"1005","insp_end_time":"1021","registration_date":null,"region":"ET","ci_status_code":"C","location":"70877C","location_desc":"WATERTOWN (SB)","county_code_state":"NY","county_code":"045","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MCQUADE AND BANNIGAN INC","shipping_paper_number":"01","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-09-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2949497","transaction_code":"A","transaction_date":"2024-09-09 00:00:00","upload_date":"2024-09-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":"M","census_search_date":"2024-09-09 21:40:00","snet_input_date":"2024-09-09 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-09-09 21:40:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:35:17.000000Z","updated_at":"2025-03-17T20:35:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10767282,"change_date":"2024-09-09 21:40:00","inspection_id":"82608497","insp_unit_id":"202822278","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"46744NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ7AT8R5T50657","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:29.000000Z","updated_at":"2025-03-17T23:34:29.000000Z"}]},{"id":6430114,"change_date":"2024-08-09 21:38:00","inspection_id":"82344080","dot_number":"1531354","report_state":"NY","report_number":"SPWB030984","insp_date":"2024-08-08 00:00:00","insp_start_time":"1249","insp_end_time":"1307","registration_date":null,"region":"ET","ci_status_code":"C","location":"70623","location_desc":"OSWEGATCHIE ROADSIDE WEST","county_code_state":"NY","county_code":"089","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-09 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"4","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2943636","transaction_code":"A","transaction_date":"2024-08-09 00:00:00","upload_date":"2024-08-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":"M","census_search_date":"2024-08-09 21:38:00","snet_input_date":"2024-08-09 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-08-09 21:38:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:30:18.000000Z","updated_at":"2025-03-17T20:30:18.000000Z","inspection_violations":[{"id":9985142,"change_date":"2024-08-09 21:38:00","inspection_id":"82344080","insp_violation_id":"261107977","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:19.000000Z","updated_at":"2025-03-17T21:54:19.000000Z","normalized_code":"3922"},{"id":9985143,"change_date":"2024-08-09 21:38:00","inspection_id":"82344080","insp_violation_id":"261107978","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"202315963","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"3JC1B7T","created_at":"2025-03-17T21:54:19.000000Z","updated_at":"2025-03-17T21:54:19.000000Z","normalized_code":"3939A"},{"id":9985144,"change_date":"2024-08-09 21:38:00","inspection_id":"82344080","insp_violation_id":"261107979","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"202315963","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"3JC1BD4","created_at":"2025-03-17T21:54:19.000000Z","updated_at":"2025-03-17T21:54:19.000000Z","normalized_code":"3939A"},{"id":9985145,"change_date":"2024-08-09 21:38:00","inspection_id":"82344080","insp_violation_id":"261107980","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"202315963","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"3JC1BBM","created_at":"2025-03-17T21:54:19.000000Z","updated_at":"2025-03-17T21:54:19.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":10363046,"change_date":"2024-08-09 21:38:00","inspection_id":"82344080","insp_unit_id":"202315962","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"44166ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GCZGGFP6P1120759","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:24.000000Z","updated_at":"2025-03-17T23:30:24.000000Z"},{"id":10363047,"change_date":"2024-08-09 21:38:00","inspection_id":"82344080","insp_unit_id":"202315963","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"CC15291","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5JW1U1824N2373195","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:24.000000Z","updated_at":"2025-03-17T23:30:24.000000Z"}]},{"id":6285241,"change_date":"2024-07-23 21:41:00","inspection_id":"82189071","dot_number":"1531354","report_state":"NY","report_number":"SPT0541825","insp_date":"2024-07-22 00:00:00","insp_start_time":"1322","insp_end_time":"1338","registration_date":null,"region":"ET","ci_status_code":"C","location":"22058A","location_desc":"UTICA (EXIT 31)","county_code_state":"NY","county_code":"065","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":"2024-07-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2939037","transaction_code":"A","transaction_date":"2024-07-23 00:00:00","upload_date":"2024-07-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":"M","census_search_date":"2024-07-23 21:41:00","snet_input_date":"2024-07-23 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-07-23 21:41:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:27:22.000000Z","updated_at":"2025-03-17T20:27:22.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10126850,"change_date":"2024-07-23 21:41:00","inspection_id":"82189071","insp_unit_id":"202019817","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"46744NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ7AT8R5T50657","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:55.000000Z","updated_at":"2025-03-17T23:27:55.000000Z"}]},{"id":5927954,"change_date":"2024-06-06 21:41:00","inspection_id":"81804211","dot_number":"1531354","report_state":"NY","report_number":"SPT0580174","insp_date":"2024-06-05 00:00:00","insp_start_time":"1055","insp_end_time":"1110","registration_date":null,"region":"ET","ci_status_code":"C","location":"20895R","location_desc":"WESTMORELAND (EXIT 32)","county_code_state":"NY","county_code":"065","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MCQUADE AND BANNIGAN INC","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-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"106000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2928500","transaction_code":"A","transaction_date":"2024-06-06 00:00:00","upload_date":"2024-06-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":"M","census_search_date":"2024-06-06 21:41:00","snet_input_date":"2024-06-06 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-06-06 21:41:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:20:15.000000Z","updated_at":"2025-03-17T20:20:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9547846,"change_date":"2024-06-06 21:41:00","inspection_id":"81804211","insp_unit_id":"201264241","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"45740ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GCZGGFG3J1287037","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:01.000000Z","updated_at":"2025-03-17T23:22:01.000000Z"},{"id":9547847,"change_date":"2024-06-06 21:41:00","inspection_id":"81804211","insp_unit_id":"201264242","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":null,"insp_unit_company":null,"insp_unit_license":"BH93761","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5JPBU242XGP042493","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:01.000000Z","updated_at":"2025-03-17T23:22:01.000000Z"}]},{"id":5904384,"change_date":"2024-06-04 21:41:00","inspection_id":"81778492","dot_number":"1531354","report_state":"NY","report_number":"D507800599","insp_date":"2024-06-03 00:00:00","insp_start_time":"1252","insp_end_time":"1310","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"CHURCHVILLE NY","county_code_state":"NY","county_code":"055","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-06-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"536413","transaction_code":"A","transaction_date":"2024-06-04 00:00:00","upload_date":"2024-06-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":null,"census_search_date":"2024-06-04 21:41:00","snet_input_date":"2024-06-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-06-04 21:41:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:19:48.000000Z","updated_at":"2025-03-17T20:19:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9510011,"change_date":"2024-06-04 21:41:00","inspection_id":"81778492","insp_unit_id":"201214990","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":"RED","insp_unit_license":"44151ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GCRDAED7PZ148066","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:40.000000Z","updated_at":"2025-03-17T23:21:40.000000Z"},{"id":9510012,"change_date":"2024-06-04 21:41:00","inspection_id":"81778492","insp_unit_id":"201214991","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":"RED","insp_unit_license":"CB12644","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"53BPTEA22MP020431","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:40.000000Z","updated_at":"2025-03-17T23:21:40.000000Z"}]},{"id":5765586,"change_date":"2024-05-16 21:41:00","inspection_id":"81627935","dot_number":"1531354","report_state":"NY","report_number":"SPD0235852","insp_date":"2024-05-15 00:00:00","insp_start_time":"1110","insp_end_time":"1128","registration_date":null,"region":"ET","ci_status_code":"C","location":"70877C","location_desc":"WATERTOWN (SB)","county_code_state":"NY","county_code":"045","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MCQUADE AND BANNIGAN INC","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":"2024-05-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2923616","transaction_code":"A","transaction_date":"2024-05-16 00:00:00","upload_date":"2024-05-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":"M","census_search_date":"2024-05-16 21:41:00","snet_input_date":"2024-05-16 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-05-16 21:41:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:17:04.000000Z","updated_at":"2025-03-17T20:17:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9286203,"change_date":"2024-05-16 21:41:00","inspection_id":"81627935","insp_unit_id":"200927065","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"46744NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ7AT8R5T50657","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:27.000000Z","updated_at":"2025-03-17T23:19:27.000000Z"}]},{"id":5337258,"change_date":"2024-03-21 21:40:00","inspection_id":"81161329","dot_number":"1531354","report_state":"NY","report_number":"SPT0532023","insp_date":"2024-03-19 00:00:00","insp_start_time":"1109","insp_end_time":"1127","registration_date":null,"region":"ET","ci_status_code":"C","location":"20330M","location_desc":"GLEN REST AREA WB","county_code_state":"NY","county_code":"057","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":"2024-03-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2912614","transaction_code":"A","transaction_date":"2024-03-21 00:00:00","upload_date":"2024-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":"M","census_search_date":"2024-03-21 21:40:00","snet_input_date":"2024-03-21 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-03-21 21:40:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:08:19.000000Z","updated_at":"2025-03-17T20:08:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8595293,"change_date":"2024-03-21 21:40:00","inspection_id":"81161329","insp_unit_id":"200022062","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"71126ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNE8JR2H4S50265","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:58.000000Z","updated_at":"2025-03-17T23:12:58.000000Z"}]},{"id":5151714,"change_date":"2024-02-28 21:41:00","inspection_id":"80959140","dot_number":"1531354","report_state":"NY","report_number":"SPD0272105","insp_date":"2024-02-27 00:00:00","insp_start_time":"0923","insp_end_time":"0948","registration_date":null,"region":"ET","ci_status_code":"C","location":"70459A","location_desc":"LE RAY\/FORT DRUM","county_code_state":"NY","county_code":"045","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MCQUADE AND BANNIGAN INC","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-02-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2909314","transaction_code":"A","transaction_date":"2024-02-27 00:00:00","upload_date":"2024-02-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":null,"census_search_date":"2024-02-28 21:41:00","snet_input_date":"2024-02-28 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-02-28 21:41:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:04:34.000000Z","updated_at":"2025-03-17T20:04:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8294846,"change_date":"2024-02-28 21:41:00","inspection_id":"80959140","insp_unit_id":"199635911","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"44166ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GCZGGFP6P1120759","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:09.000000Z","updated_at":"2025-03-17T23:10:09.000000Z"},{"id":8294847,"change_date":"2024-02-28 21:41:00","inspection_id":"80959140","insp_unit_id":"199635912","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"CC15291","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5JW1U1824N2373195","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:09.000000Z","updated_at":"2025-03-17T23:10:09.000000Z"}]},{"id":4892540,"change_date":"2024-01-24 21:44:00","inspection_id":"80675708","dot_number":"1531354","report_state":"NY","report_number":"SPD0281401","insp_date":"2024-01-22 00:00:00","insp_start_time":"1130","insp_end_time":"1145","registration_date":null,"region":"ET","ci_status_code":"C","location":"30382A","location_desc":"HASTINGS (SB)","county_code_state":"NY","county_code":"075","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MCQUADE AND BANNIGAN INC","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-01-24 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2901721","transaction_code":"A","transaction_date":"2024-01-22 00:00:00","upload_date":"2024-01-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":null,"census_search_date":"2024-01-24 21:44:00","snet_input_date":"2024-01-24 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-01-24 21:44:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK ST","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:59:38.000000Z","updated_at":"2025-03-17T19:59:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7872043,"change_date":"2024-01-24 21:44:00","inspection_id":"80675708","insp_unit_id":"199086810","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"71126ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNE8JR2H4S50265","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:22.000000Z","updated_at":"2025-03-17T23:06:22.000000Z"}]},{"id":4211059,"change_date":"2023-10-17 21:40:00","inspection_id":"79926836","dot_number":"1531354","report_state":"NY","report_number":"M607100021","insp_date":"2023-10-16 00:00:00","insp_start_time":"1135","insp_end_time":"1201","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"WATERTOWN NY","county_code_state":"NY","county_code":"045","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MCQUADE AND BANNIGAN INC","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-10-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"70009","transaction_code":"A","transaction_date":"2023-10-17 00:00:00","upload_date":"2023-10-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":null,"census_search_date":"2023-10-17 21:40:00","snet_input_date":"2023-10-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-10-17 21:40:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:46:15.000000Z","updated_at":"2025-03-17T19:46:15.000000Z","inspection_violations":[{"id":6519839,"change_date":"2023-10-17 21:40:00","inspection_id":"79926836","insp_violation_id":"255870692","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"197586510","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:24.000000Z","updated_at":"2025-03-17T21:37:24.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":6772105,"change_date":"2023-10-17 21:40:00","inspection_id":"79926836","insp_unit_id":"197586510","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"71126ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNE8JR2H4S50265","insp_unit_decal":"Y","insp_unit_decal_number":"33401941","created_at":"2025-03-17T22:56:46.000000Z","updated_at":"2025-03-17T22:56:46.000000Z"}]},{"id":4359131,"change_date":"2023-11-08 21:40:00","inspection_id":"80090318","dot_number":"1531354","report_state":"NY","report_number":"SPC0226204","insp_date":"2023-10-11 00:00:00","insp_start_time":"1122","insp_end_time":"1140","registration_date":null,"region":"ET","ci_status_code":"C","location":"70877","location_desc":"WATERTOWN (SB)","county_code_state":"NY","county_code":"045","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MCQUADE AND BANNIGAN INC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2884773","transaction_code":"C","transaction_date":"2023-10-11 00:00:00","upload_date":"2023-11-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":null,"census_search_date":"2023-11-06 21:41:00","snet_input_date":"2023-11-06 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-11-06 21:41:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13503","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:49:10.000000Z","updated_at":"2025-03-17T19:49:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7010512,"change_date":"2023-11-08 21:40:00","inspection_id":"80090318","insp_unit_id":"197963363","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"71126ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNE8JR2H4S50265","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:51.000000Z","updated_at":"2025-03-17T22:58:51.000000Z"}]},{"id":3940718,"change_date":"2023-09-11 21:40:00","inspection_id":"79626971","dot_number":"1531354","report_state":"NY","report_number":"SPD0291259","insp_date":"2023-09-05 00:00:00","insp_start_time":"0941","insp_end_time":"1001","registration_date":null,"region":"ET","ci_status_code":"C","location":"20095","location_desc":"BROOKFIELD","county_code_state":"NY","county_code":"053","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"PATRIOT MASONRY AND CONSTRUCTION INC","shipping_paper_number":"3283771","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"18600","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2867062","transaction_code":"A","transaction_date":"2023-09-05 00:00:00","upload_date":"2023-09-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":null,"census_search_date":"2023-09-11 21:40:00","snet_input_date":"2023-09-11 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-09-11 21:40:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:40:46.000000Z","updated_at":"2025-03-17T19:40:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6336171,"change_date":"2023-09-11 21:40:00","inspection_id":"79626971","insp_unit_id":"196982301","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"12106MN","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GCWGAFGXK1323730","insp_unit_decal":"Y","insp_unit_decal_number":"33075309","created_at":"2025-03-17T22:53:14.000000Z","updated_at":"2025-03-17T22:53:14.000000Z"},{"id":6336172,"change_date":"2023-09-11 21:40:00","inspection_id":"79626971","insp_unit_id":"196982302","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":null,"insp_unit_company":null,"insp_unit_license":"BL9402","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5JPBU2421HP046336","insp_unit_decal":"Y","insp_unit_decal_number":"33075310","created_at":"2025-03-17T22:53:14.000000Z","updated_at":"2025-03-17T22:53:14.000000Z"}]},{"id":3730148,"change_date":"2023-08-14 21:41:00","inspection_id":"79391931","dot_number":"1531354","report_state":"NY","report_number":"SPB0401895","insp_date":"2023-08-10 00:00:00","insp_start_time":"0811","insp_end_time":"0843","registration_date":null,"region":"ET","ci_status_code":"C","location":"70725","location_desc":"ROSSIE","county_code_state":"NY","county_code":"089","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":"2023-08-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19600","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2857458","transaction_code":"A","transaction_date":"2023-08-10 00:00:00","upload_date":"2023-08-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":null,"census_search_date":"2023-08-14 21:41:00","snet_input_date":"2023-08-14 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-08-14 21:41:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK ST","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:30.000000Z","updated_at":"2025-03-17T19:36:30.000000Z","inspection_violations":[{"id":5753824,"change_date":"2023-08-14 21:41:00","inspection_id":"79391931","insp_violation_id":"254623171","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:33:38.000000Z","updated_at":"2025-03-17T21:33:38.000000Z","normalized_code":"39141A"},{"id":5753825,"change_date":"2023-08-14 21:41:00","inspection_id":"79391931","insp_violation_id":"254623172","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"196502282","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:33:38.000000Z","updated_at":"2025-03-17T21:33:38.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":5997347,"change_date":"2023-08-14 21:41:00","inspection_id":"79391931","insp_unit_id":"196502281","insp_unit_type_id":"12","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"44166ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GCZGGFP6P1120759","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:24.000000Z","updated_at":"2025-03-17T22:50:24.000000Z"},{"id":5997348,"change_date":"2023-08-14 21:41:00","inspection_id":"79391931","insp_unit_id":"196502282","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"BL19402","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5JPBU2421HP046336","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:24.000000Z","updated_at":"2025-03-17T22:50:24.000000Z"}]},{"id":3730334,"change_date":"2023-08-14 21:41:00","inspection_id":"79392129","dot_number":"1531354","report_state":"NY","report_number":"SPC0216770","insp_date":"2023-08-10 00:00:00","insp_start_time":"1052","insp_end_time":"1111","registration_date":null,"region":"ET","ci_status_code":"C","location":"70877C","location_desc":"WATERTOWN (SB)","county_code_state":"NY","county_code":"045","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MCQUADE AND BANNIGAN INC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2857536","transaction_code":"A","transaction_date":"2023-08-10 00:00:00","upload_date":"2023-08-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":null,"census_search_date":"2023-08-14 21:41:00","snet_input_date":"2023-08-14 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-08-14 21:41:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:30.000000Z","updated_at":"2025-03-17T19:36:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5997637,"change_date":"2023-08-14 21:41:00","inspection_id":"79392129","insp_unit_id":"196502596","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"71126ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNE8JR2H4S50265","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:24.000000Z","updated_at":"2025-03-17T22:50:24.000000Z"}]},{"id":3339836,"change_date":"2023-06-22 21:41:00","inspection_id":"78954101","dot_number":"1531354","report_state":"NY","report_number":"MC74000550","insp_date":"2023-06-21 00:00:00","insp_start_time":"1122","insp_end_time":"1150","registration_date":null,"region":"ET","ci_status_code":"C","location":"70877M","location_desc":"WATERTOWN REST AREA (SB)","county_code_state":"NY","county_code":"045","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"F","shipper_name":"MCQUADE & BANNIGAN INC","shipping_paper_number":"65252","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-06-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2839425","transaction_code":"A","transaction_date":"2023-06-22 00:00:00","upload_date":"2023-06-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":"M","census_search_date":"2023-06-22 21:41:00","snet_input_date":"2023-06-22 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-06-22 21:41:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:28:58.000000Z","updated_at":"2025-03-17T19:28:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5369204,"change_date":"2023-06-22 21:41:00","inspection_id":"78954101","insp_unit_id":"195617507","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"71126ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNE8JR2H4S50265","insp_unit_decal":"Y","insp_unit_decal_number":"32700573","created_at":"2025-03-17T22:45:21.000000Z","updated_at":"2025-03-17T22:45:21.000000Z"}]},{"id":3103477,"change_date":"2023-05-22 21:40:00","inspection_id":"78687169","dot_number":"1531354","report_state":"NY","report_number":"SPC0158907","insp_date":"2023-05-17 00:00:00","insp_start_time":"1218","insp_end_time":"1233","registration_date":null,"region":"ET","ci_status_code":"C","location":"70877C","location_desc":"WATERTOWN (SB)","county_code_state":"NY","county_code":"045","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MCQUADE AND BANNIGAN INC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2827597","transaction_code":"A","transaction_date":"2023-05-17 00:00:00","upload_date":"2023-05-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":null,"census_search_date":"2023-05-22 21:40:00","snet_input_date":"2023-05-22 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-05-22 21:40:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:24:33.000000Z","updated_at":"2025-03-17T19:24:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4991493,"change_date":"2023-05-22 21:40:00","inspection_id":"78687169","insp_unit_id":"195058394","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"71126ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNE8JR2H4S50265","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:21.000000Z","updated_at":"2025-03-17T22:42:21.000000Z"}]},{"id":2738632,"change_date":"2023-04-05 21:41:00","inspection_id":"78274784","dot_number":"1531354","report_state":"NY","report_number":"SPB0401527","insp_date":"2023-04-04 00:00:00","insp_start_time":"1311","insp_end_time":"1342","registration_date":null,"region":"ET","ci_status_code":"C","location":"70623","location_desc":"OSWEGATCHIE","county_code_state":"NY","county_code":"089","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":"2023-04-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"16670","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2812824","transaction_code":"A","transaction_date":"2023-04-05 00:00:00","upload_date":"2023-04-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":"M","census_search_date":"2023-04-05 21:41:00","snet_input_date":"2023-04-05 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-04-05 21:41:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:17:01.000000Z","updated_at":"2025-03-17T19:17:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4408103,"change_date":"2023-04-05 21:41:00","inspection_id":"78274784","insp_unit_id":"194237056","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"40079MH","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GCZGGFGXG1175389","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:41.000000Z","updated_at":"2025-03-17T22:37:41.000000Z"},{"id":4408104,"change_date":"2023-04-05 21:41:00","inspection_id":"78274784","insp_unit_id":"194237057","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"CC15291","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5JW1U1824N2373195","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:41.000000Z","updated_at":"2025-03-17T22:37:41.000000Z"}]},{"id":2539791,"change_date":"2023-03-09 21:41:00","inspection_id":"78047832","dot_number":"1531354","report_state":"NY","report_number":"SPT0462138","insp_date":"2023-03-06 00:00:00","insp_start_time":"1400","insp_end_time":"1420","registration_date":null,"region":"ET","ci_status_code":"C","location":"22058A","location_desc":"UTICA (EXIT 31)","county_code_state":"NY","county_code":"065","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MCQUADE AND BANNIGAN INC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2804288","transaction_code":"A","transaction_date":"2023-03-09 00:00:00","upload_date":"2023-03-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":"M","census_search_date":"2023-03-09 21:41:00","snet_input_date":"2023-03-09 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-03-09 21:41:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:13:23.000000Z","updated_at":"2025-03-17T19:13:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4087710,"change_date":"2023-03-09 21:41:00","inspection_id":"78047832","insp_unit_id":"193782925","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"71126ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNE8JR2H4S50265","insp_unit_decal":"Y","insp_unit_decal_number":"32340370","created_at":"2025-03-17T22:35:18.000000Z","updated_at":"2025-03-17T22:35:18.000000Z"}]},{"id":2250602,"change_date":"2023-01-30 21:43:00","inspection_id":"77718793","dot_number":"1531354","report_state":"NY","report_number":"SPD0280382","insp_date":"2023-01-25 00:00:00","insp_start_time":"1245","insp_end_time":"1300","registration_date":null,"region":"ET","ci_status_code":"C","location":"22058A","location_desc":"UTICA (EXIT 31)","county_code_state":"NY","county_code":"065","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MCQUADE AND BANNIGAN INC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-30 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2792794","transaction_code":"A","transaction_date":"2023-01-30 00:00:00","upload_date":"2023-01-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":"M","census_search_date":"2023-01-30 21:43:00","snet_input_date":"2023-01-27 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-01-30 21:43:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:08.000000Z","updated_at":"2025-03-17T19:08:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3622185,"change_date":"2023-01-30 21:43:00","inspection_id":"77718793","insp_unit_id":"193118016","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"258","insp_unit_license":"59347NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNE8JR2H4S50265","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:58.000000Z","updated_at":"2025-03-17T22:31:58.000000Z"}]},{"id":2101810,"change_date":"2023-01-10 21:40:00","inspection_id":"77548266","dot_number":"1531354","report_state":"NY","report_number":"SPT0461979","insp_date":"2023-01-09 00:00:00","insp_start_time":"1334","insp_end_time":"1349","registration_date":null,"region":"ET","ci_status_code":"C","location":"22058A","location_desc":"UTICA (EXIT 31)","county_code_state":"NY","county_code":"065","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MCQUADE AND BANNIGAN INC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2786674","transaction_code":"A","transaction_date":"2023-01-10 00:00:00","upload_date":"2023-01-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":"M","census_search_date":"2023-01-10 21:40:00","snet_input_date":"2023-01-10 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-01-10 21:40:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:05:29.000000Z","updated_at":"2025-03-17T19:05:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3382050,"change_date":"2023-01-10 21:40:00","inspection_id":"77548266","insp_unit_id":"192777248","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"59347NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNE8JR2H4S50265","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:14.000000Z","updated_at":"2025-03-17T22:30:14.000000Z"}]},{"id":1804263,"change_date":"2022-11-23 21:39:00","inspection_id":"77208131","dot_number":"1531354","report_state":"NY","report_number":"SPD0224479","insp_date":"2022-11-21 00:00:00","insp_start_time":"1126","insp_end_time":"1142","registration_date":null,"region":"ET","ci_status_code":"C","location":"70877C","location_desc":"WATERTOWN (SB)","county_code_state":"NY","county_code":"045","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MCQUADE AND BANNIGAN INC","shipping_paper_number":"62563","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-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2773849","transaction_code":"A","transaction_date":"2022-11-23 00:00:00","upload_date":"2022-11-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":"M","census_search_date":"2022-11-23 21:39:00","snet_input_date":"2022-11-23 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-11-23 21:39:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:59:57.000000Z","updated_at":"2025-03-17T18:59:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2902168,"change_date":"2022-11-23 21:39:00","inspection_id":"77208131","insp_unit_id":"192103839","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"59347NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNE8JR2H4S50265","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:52.000000Z","updated_at":"2025-03-17T22:26:52.000000Z"}]},{"id":1631402,"change_date":"2022-10-31 21:40:00","inspection_id":"77009758","dot_number":"1531354","report_state":"NY","report_number":"SPT0530537","insp_date":"2022-10-28 00:00:00","insp_start_time":"1410","insp_end_time":"1425","registration_date":null,"region":"ET","ci_status_code":"C","location":"20330M","location_desc":"GLEN REST AREA WB","county_code_state":"NY","county_code":"057","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-31 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2764336","transaction_code":"A","transaction_date":"2022-10-31 00:00:00","upload_date":"2022-10-31 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":"M","census_search_date":"2022-10-31 21:40:00","snet_input_date":"2022-10-31 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-10-31 21:40:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:56:41.000000Z","updated_at":"2025-03-17T18:56:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2624225,"change_date":"2022-10-31 21:40:00","inspection_id":"77009758","insp_unit_id":"191709965","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"1","insp_unit_license":"59347NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNE8JR2H4S50265","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:59.000000Z","updated_at":"2025-03-17T22:24:59.000000Z"}]},{"id":1631481,"change_date":"2022-10-31 21:40:00","inspection_id":"77009844","dot_number":"1531354","report_state":"NY","report_number":"3L11000139","insp_date":"2022-10-28 00:00:00","insp_start_time":"1020","insp_end_time":"1103","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"100 BRUCE ST-ROADSIDE","county_code_state":"NY","county_code":"067","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":"Y","pen_cen_match":"I","final_status_date":"2022-10-31 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"5","oos_total":"2","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2764380","transaction_code":"A","transaction_date":"2022-10-31 00:00:00","upload_date":"2022-10-31 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":"M","census_search_date":"2022-10-31 21:40:00","snet_input_date":"2022-10-31 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-10-31 21:40:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:56:41.000000Z","updated_at":"2025-03-17T18:56:41.000000Z","inspection_violations":[{"id":2560996,"change_date":"2022-10-31 21:40:00","inspection_id":"77009844","insp_violation_id":"249326907","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"191710108","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:19:06.000000Z","updated_at":"2025-03-17T21:19:06.000000Z","normalized_code":"3939A"},{"id":2560997,"change_date":"2022-10-31 21:40:00","inspection_id":"77009844","insp_violation_id":"249326908","seq_no":"2","part_no":"393","part_no_section":"42","insp_viol_unit":"2","insp_unit_id":"191710108","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:19:06.000000Z","updated_at":"2025-03-17T21:19:06.000000Z","normalized_code":"39342"},{"id":2560998,"change_date":"2022-10-31 21:40:00","inspection_id":"77009844","insp_violation_id":"249326909","seq_no":"3","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"191710108","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:06.000000Z","updated_at":"2025-03-17T21:19:06.000000Z","normalized_code":"39375C"},{"id":2560999,"change_date":"2022-10-31 21:40:00","inspection_id":"77009844","insp_violation_id":"249326910","seq_no":"4","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:19:06.000000Z","updated_at":"2025-03-17T21:19:06.000000Z","normalized_code":"3927A"},{"id":2561000,"change_date":"2022-10-31 21:40:00","inspection_id":"77009844","insp_violation_id":"249326911","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191710107","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:06.000000Z","updated_at":"2025-03-17T21:19:06.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2624353,"change_date":"2022-10-31 21:40:00","inspection_id":"77009844","insp_unit_id":"191710107","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"10939MK","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GCZGGFG9H1238841","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:59.000000Z","updated_at":"2025-03-17T22:24:59.000000Z"},{"id":2624354,"change_date":"2022-10-31 21:40:00","inspection_id":"77009844","insp_unit_id":"191710108","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"CD68564","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1R9US16246B295767","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:59.000000Z","updated_at":"2025-03-17T22:24:59.000000Z"}]},{"id":1609330,"change_date":"2022-10-27 21:40:00","inspection_id":"76984396","dot_number":"1531354","report_state":"NY","report_number":"SPG0260716","insp_date":"2022-10-25 00:00:00","insp_start_time":"1235","insp_end_time":"1250","registration_date":null,"region":"ET","ci_status_code":"C","location":"10174A","location_desc":"CLIFTON PARK (NB)","county_code_state":"NY","county_code":"091","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2763639","transaction_code":"A","transaction_date":"2022-10-25 00:00:00","upload_date":"2022-10-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":null,"census_search_date":"2022-10-27 21:40:00","snet_input_date":"2022-10-27 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-10-27 21:40:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:56:18.000000Z","updated_at":"2025-03-17T18:56:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2589205,"change_date":"2022-10-27 21:40:00","inspection_id":"76984396","insp_unit_id":"191661505","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"1","insp_unit_license":"59347NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNE8JR2H4S50265","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:44.000000Z","updated_at":"2025-03-17T22:24:44.000000Z"}]},{"id":1526130,"change_date":"2022-10-17 21:40:00","inspection_id":"76888620","dot_number":"1531354","report_state":"NY","report_number":"SPD0214545","insp_date":"2022-10-12 00:00:00","insp_start_time":"1137","insp_end_time":"1210","registration_date":null,"region":"ET","ci_status_code":"C","location":"70877C","location_desc":"WATERTOWN (SB)","county_code_state":"NY","county_code":"045","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MCQUADE AND BANNIGAN","shipping_paper_number":"62045","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2759522","transaction_code":"A","transaction_date":"2022-10-17 00:00:00","upload_date":"2022-10-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":"M","census_search_date":"2022-10-17 21:40:00","snet_input_date":"2022-10-17 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-10-17 21:40:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:54:49.000000Z","updated_at":"2025-03-17T18:54:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2455496,"change_date":"2022-10-17 21:40:00","inspection_id":"76888620","insp_unit_id":"191464766","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"59347NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNE8JR2H4S50265","insp_unit_decal":"Y","insp_unit_decal_number":"32007119","created_at":"2025-03-17T22:23:50.000000Z","updated_at":"2025-03-17T22:23:50.000000Z"}]},{"id":1493830,"change_date":"2022-10-12 21:41:00","inspection_id":"76851580","dot_number":"1531354","report_state":"NY","report_number":"SPB0401171","insp_date":"2022-10-11 00:00:00","insp_start_time":"1405","insp_end_time":"1427","registration_date":null,"region":"ET","ci_status_code":"C","location":"70623","location_desc":"OSWEGATCHIE","county_code_state":"NY","county_code":"089","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":"2022-10-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2757497","transaction_code":"A","transaction_date":"2022-10-12 00:00:00","upload_date":"2022-10-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":"M","census_search_date":"2022-10-12 21:41:00","snet_input_date":"2022-10-12 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-10-12 21:41:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:54:09.000000Z","updated_at":"2025-03-17T18:54:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2403884,"change_date":"2022-10-12 21:41:00","inspection_id":"76851580","insp_unit_id":"191391397","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"40079MH","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GCZGGFGXG1175389","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:27.000000Z","updated_at":"2025-03-17T22:23:27.000000Z"},{"id":2403885,"change_date":"2022-10-12 21:41:00","inspection_id":"76851580","insp_unit_id":"191391398","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"CC15291","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5JW1U1824N2373195","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:27.000000Z","updated_at":"2025-03-17T22:23:27.000000Z"}]},{"id":735913,"change_date":"2022-07-01 21:38:00","inspection_id":"75968773","dot_number":"1531354","report_state":"NY","report_number":"SPC0187674","insp_date":"2022-06-29 00:00:00","insp_start_time":"1453","insp_end_time":"1515","registration_date":null,"region":"ET","ci_status_code":"C","location":"70877C","location_desc":"WATERTOWN (SB)","county_code_state":"NY","county_code":"045","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MCQUADE AND BANNIGAN","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-07-01 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"19599","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2723465","transaction_code":"A","transaction_date":"2022-07-01 00:00:00","upload_date":"2022-07-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":"M","census_search_date":"2022-07-01 21:38:00","snet_input_date":"2022-07-01 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-07-01 21:38:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:40:34.000000Z","updated_at":"2025-03-17T18:40:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1182587,"change_date":"2022-07-01 21:38:00","inspection_id":"75968773","insp_unit_id":"189568151","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"10939MK","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GCZGGFG9H1238841","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:27.000000Z","updated_at":"2025-03-17T22:15:27.000000Z"},{"id":1182588,"change_date":"2022-07-01 21:38:00","inspection_id":"75968773","insp_unit_id":"189568152","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"CD68564","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1R9US16246B295767","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:27.000000Z","updated_at":"2025-03-17T22:15:27.000000Z"}]},{"id":440876,"change_date":"2022-05-20 21:40:00","inspection_id":"75618579","dot_number":"1531354","report_state":"NY","report_number":"SPC0215538","insp_date":"2022-05-18 00:00:00","insp_start_time":"1145","insp_end_time":"1201","registration_date":null,"region":"ET","ci_status_code":"C","location":"70877C","location_desc":"WATERTOWN (SB)","county_code_state":"NY","county_code":"045","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MCAUADE AND BANNIGAN","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-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2708569","transaction_code":"A","transaction_date":"2022-05-20 00:00:00","upload_date":"2022-05-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":"M","census_search_date":"2022-05-20 21:40:00","snet_input_date":"2022-05-20 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-05-20 21:40:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:35:35.000000Z","updated_at":"2025-03-17T18:35:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":710587,"change_date":"2022-05-20 21:40:00","inspection_id":"75618579","insp_unit_id":"188808344","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"59347NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNE8JR2H4S50265","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:34.000000Z","updated_at":"2025-03-17T22:12:34.000000Z"}]},{"id":142402,"change_date":"2022-04-11 21:40:00","inspection_id":"75262618","dot_number":"1531354","report_state":"NY","report_number":"SPB0341517","insp_date":"2022-04-07 00:00:00","insp_start_time":"1345","insp_end_time":"1415","registration_date":null,"region":"ET","ci_status_code":"C","location":"70623A","location_desc":"OSWEGATCHIE","county_code_state":"NY","county_code":"089","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":"2022-04-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2694585","transaction_code":"A","transaction_date":"2022-04-11 00:00:00","upload_date":"2022-04-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":"M","census_search_date":"2022-04-11 21:40:00","snet_input_date":"2022-04-11 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-04-11 21:40:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:30:07.000000Z","updated_at":"2025-03-17T18:30:07.000000Z","inspection_violations":[{"id":210735,"change_date":"2022-04-11 21:40:00","inspection_id":"75262618","insp_violation_id":"245061935","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188072538","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:01.000000Z","updated_at":"2025-03-17T21:08:01.000000Z","normalized_code":"3922"},{"id":210736,"change_date":"2022-04-11 21:40:00","inspection_id":"75262618","insp_violation_id":"245061936","seq_no":"2","part_no":"393","part_no_section":"41","insp_viol_unit":"1","insp_unit_id":"188072538","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:08:01.000000Z","updated_at":"2025-03-17T21:08:01.000000Z","normalized_code":"39341"},{"id":210737,"change_date":"2022-04-11 21:40:00","inspection_id":"75262618","insp_violation_id":"245061937","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"188072539","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:01.000000Z","updated_at":"2025-03-17T21:08:01.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":230376,"change_date":"2022-04-11 21:40:00","inspection_id":"75262618","insp_unit_id":"188072538","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"14836MG","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GTS8AF42E1154941","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:36.000000Z","updated_at":"2025-03-17T22:09:36.000000Z"},{"id":230377,"change_date":"2022-04-11 21:40:00","inspection_id":"75262618","insp_unit_id":"188072539","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"BH93761","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5JPBU242XGP042493","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:36.000000Z","updated_at":"2025-03-17T22:09:36.000000Z"}]},{"id":142267,"change_date":"2022-04-11 21:40:00","inspection_id":"75262470","dot_number":"1531354","report_state":"NY","report_number":"SPC0224567","insp_date":"2022-04-06 00:00:00","insp_start_time":"1048","insp_end_time":"1107","registration_date":null,"region":"ET","ci_status_code":"C","location":"70877","location_desc":"WATERTOWN (NB)","county_code_state":"NY","county_code":"045","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MCQUADE AND BANNIGAN INC","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-04-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2694294","transaction_code":"A","transaction_date":"2022-04-11 00:00:00","upload_date":"2022-04-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":"M","census_search_date":"2022-04-11 21:40:00","snet_input_date":"2022-04-11 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-04-11 21:40:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:30:07.000000Z","updated_at":"2025-03-17T18:30:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":230193,"change_date":"2022-04-11 21:40:00","inspection_id":"75262470","insp_unit_id":"188072327","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"59347NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNE8JR2H4S50265","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:36.000000Z","updated_at":"2025-03-17T22:09:36.000000Z"}]},{"id":24350,"change_date":"2022-03-23 21:31:00","inspection_id":"75114093","dot_number":"1531354","report_state":"NY","report_number":"SPWB070484","insp_date":"2022-03-22 00:00:00","insp_start_time":"1341","insp_end_time":"1400","registration_date":null,"region":"ET","ci_status_code":"C","location":"70334","location_desc":"T\/GOUVERNEUR","county_code_state":"NY","county_code":"089","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-03-23 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"18700","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2688246","transaction_code":"A","transaction_date":"2022-03-23 00:00:00","upload_date":"2022-03-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01531354","upload_search_indicator":"M","census_search_date":"2022-03-23 21:31:00","snet_input_date":"2022-03-23 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-03-23 21:31:00","insp_carrier_name":"MCQUADE AND BANNIGAN INC","insp_carrier_street":"1300 STARK STREET","insp_carrier_city":"UTICA","insp_carrier_state":"NY","insp_carrier_zip_code":"13502","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:28:04.000000Z","updated_at":"2025-03-17T18:28:04.000000Z","inspection_violations":[{"id":34333,"change_date":"2022-03-23 21:31:00","inspection_id":"75114093","insp_violation_id":"244721051","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"187769862","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:16.000000Z","updated_at":"2025-03-17T21:07:16.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":39123,"change_date":"2022-03-23 21:31:00","inspection_id":"75114093","insp_unit_id":"187769862","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"83040MK","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GCVKNEC1JZ304385","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:30.000000Z","updated_at":"2025-03-17T22:08:30.000000Z"},{"id":39124,"change_date":"2022-03-23 21:31:00","inspection_id":"75114093","insp_unit_id":"187769863","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":null,"insp_unit_company":null,"insp_unit_license":"BH93761","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5JPBU242XGP042493","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:30.000000Z","updated_at":"2025-03-17T22:08:30.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1531354\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1531354\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1531354\/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\/1531354\/inspections","per_page":100,"prev_page_url":null,"to":66,"total":66}