{"current_page":1,"data":[{"id":12198900,"change_date":"2026-06-17 21:41:00","inspection_id":"88155547","dot_number":"157894","report_state":"NY","report_number":"SPE3071571","insp_date":"2026-06-09 00:00:00","insp_start_time":"0915","insp_end_time":"0940","registration_date":"2026-06-15 00:00:00","region":"ED","ci_status_code":"C","location":"40354N","location_desc":"GROVELAND NY","county_code_state":"NY","county_code":"051","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"56509","shipping_paper_number":"56509","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-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"3550722","transaction_code":"C","transaction_date":"2026-06-15 00:00:00","upload_date":"2026-06-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00157894","upload_search_indicator":null,"census_search_date":"2026-06-16 21:39:00","snet_input_date":"2026-06-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-16 21:39:00","insp_carrier_name":"MERCURY AIRCRAFT INC","insp_carrier_street":"8126 COUNTY ROUTE 88","insp_carrier_city":"HAMMONDSPORT","insp_carrier_state":"NY","insp_carrier_zip_code":"14840","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-19T09:42:37.000000Z","updated_at":"2026-06-28T09:30:16.000000Z","inspection_violations":[{"id":21253265,"change_date":"2026-06-17 21:41:00","inspection_id":"88155547","insp_violation_id":"274967658","seq_no":"1","part_no":"392","part_no_section":"2-SLLSIV","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-19T10:05:49.000000Z","updated_at":"2026-06-28T09:41:27.000000Z","normalized_code":"3922SLLSIV"}],"inspection_per_units":[{"id":21188229,"change_date":"2026-06-17 21:41:00","inspection_id":"88155547","insp_unit_id":"214152086","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"123","insp_unit_license":"78118NG","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDAAA7PS009257","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-19T09:20:08.000000Z","updated_at":"2026-06-28T09:01:01.000000Z"}]},{"id":11893347,"change_date":"2026-05-13 21:41:00","inspection_id":"87831642","dot_number":"157894","report_state":"NY","report_number":"M601400270","insp_date":"2026-05-12 00:00:00","insp_start_time":"1105","insp_end_time":"1136","registration_date":null,"region":"ED","ci_status_code":"C","location":"40354S","location_desc":"GROVELAND NY","county_code_state":"NY","county_code":"051","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"3310937","transaction_code":"A","transaction_date":"2026-05-13 00:00:00","upload_date":"2026-05-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00157894","upload_search_indicator":null,"census_search_date":"2026-05-13 21:41:00","snet_input_date":"2026-05-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-13 21:41:00","insp_carrier_name":"MERCURY AIRCRAFT INC","insp_carrier_street":"8126 COUNTY ROUTE 88","insp_carrier_city":"HAMMONDSPORT","insp_carrier_state":"NY","insp_carrier_zip_code":"14840","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-15T12:26:49.000000Z","updated_at":"2026-05-24T09:30:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20678173,"change_date":"2026-05-13 21:41:00","inspection_id":"87831642","insp_unit_id":"213519293","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"78118NG","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDAAA7PS009257","insp_unit_decal":"Y","insp_unit_decal_number":"36368548","created_at":"2026-05-15T12:13:27.000000Z","updated_at":"2026-05-24T09:03:48.000000Z"}]},{"id":11753573,"change_date":"2026-04-26 21:34:00","inspection_id":"87683538","dot_number":"157894","report_state":"NY","report_number":"SPC3011900","insp_date":"2026-04-20 00:00:00","insp_start_time":"0831","insp_end_time":"0846","registration_date":null,"region":"ED","ci_status_code":"C","location":"60585E","location_desc":"NICHOLS NY","county_code_state":"NY","county_code":"107","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":"2026-04-26 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"3215898","transaction_code":"A","transaction_date":"2026-04-26 00:00:00","upload_date":"2026-04-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00157894","upload_search_indicator":null,"census_search_date":"2026-04-26 21:34:00","snet_input_date":"2026-04-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-26 21:34:00","insp_carrier_name":"MERCURY AIRCRAFT INC","insp_carrier_street":"8126 COUNTY ROUTE 88","insp_carrier_city":"HAMMONDSPORT","insp_carrier_state":"NY","insp_carrier_zip_code":"14840","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-29T09:40:16.000000Z","updated_at":"2026-05-07T09:30:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20449523,"change_date":"2026-04-26 21:34:00","inspection_id":"87683538","insp_unit_id":"213234769","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"78118NG","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDAAA7PS009257","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-29T09:17:49.000000Z","updated_at":"2026-05-07T09:02:33.000000Z"}]},{"id":10052561,"change_date":"2025-10-28 21:39:00","inspection_id":"86165413","dot_number":"157894","report_state":"NY","report_number":"SPE3080985","insp_date":"2025-10-22 00:00:00","insp_start_time":"0836","insp_end_time":"0856","registration_date":null,"region":"ED","ci_status_code":"C","location":"60117M","location_desc":"CAMPBELL NY","county_code_state":"NY","county_code":"101","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MERCURY AIRCRAFT INC","shipping_paper_number":"34302","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-28 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"2468366","transaction_code":"A","transaction_date":"2025-10-28 00:00:00","upload_date":"2025-10-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00157894","upload_search_indicator":null,"census_search_date":"2025-10-28 21:39:00","snet_input_date":"2025-10-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-28 21:39:00","insp_carrier_name":"MERCURY AIRCRAFT INC","insp_carrier_street":"8126 COUNTY ROUTE 88","insp_carrier_city":"HAMMONDSPORT","insp_carrier_state":"NY","insp_carrier_zip_code":"14840","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-01T10:01:53.000000Z","updated_at":"2025-11-01T10:01:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16705758,"change_date":"2025-10-28 21:39:00","inspection_id":"86165413","insp_unit_id":"209688486","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"123","insp_unit_license":"96476NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDAAA7PS009257","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-31T09:47:06.000000Z","updated_at":"2025-11-01T09:45:38.000000Z"}]},{"id":10052654,"change_date":"2025-11-05 21:40:00","inspection_id":"86165513","dot_number":"157894","report_state":"NY","report_number":"SPC3021220","insp_date":"2025-10-22 00:00:00","insp_start_time":"0800","insp_end_time":"0831","registration_date":"2025-11-05 00:00:00","region":"ED","ci_status_code":"C","location":"60585W","location_desc":"OWEGO NY","county_code_state":"NY","county_code":"107","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MERCURY","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-28 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"2468357","transaction_code":"C","transaction_date":"2025-10-28 00:00:00","upload_date":"2025-11-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00157894","upload_search_indicator":null,"census_search_date":"2025-10-28 21:39:00","snet_input_date":"2025-10-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-28 21:39:00","insp_carrier_name":"MERCURY AIRCRAFT INC","insp_carrier_street":"8126 COUNTY ROUTE 88","insp_carrier_city":"HAMMONDSPORT","insp_carrier_state":"NY","insp_carrier_zip_code":"14840","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-01T10:01:53.000000Z","updated_at":"2025-11-09T10:30:11.000000Z","inspection_violations":[{"id":16783618,"change_date":"2025-11-05 21:40:00","inspection_id":"86165513","insp_violation_id":"269738548","seq_no":"1","part_no":"393","part_no_section":"55C1-B","insp_viol_unit":"1","insp_unit_id":"209848531","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-08T10:32:23.000000Z","updated_at":"2025-11-09T10:30:21.000000Z","normalized_code":"39355C1B"}],"inspection_per_units":[{"id":16843677,"change_date":"2025-11-05 21:40:00","inspection_id":"86165513","insp_unit_id":"209848531","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"115","insp_unit_license":"35001PA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4NC9EH2FN908949","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-08T10:02:03.000000Z","updated_at":"2025-11-09T10:00:14.000000Z"},{"id":16843678,"change_date":"2025-11-05 21:40:00","inspection_id":"86165513","insp_unit_id":"209848532","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"609852","insp_unit_license":"CF47249","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1UYVS25379G644437","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-08T10:02:03.000000Z","updated_at":"2025-11-09T10:00:14.000000Z"}]},{"id":9637792,"change_date":"2025-09-10 21:39:00","inspection_id":"85729159","dot_number":"157894","report_state":"NY","report_number":"SPA3011604","insp_date":"2025-09-03 00:00:00","insp_start_time":"1329","insp_end_time":"1347","registration_date":null,"region":"ED","ci_status_code":"C","location":"40055M","location_desc":"BATAVIA NY","county_code_state":"NY","county_code":"037","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SRI","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-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"2243145","transaction_code":"A","transaction_date":"2025-09-09 00:00:00","upload_date":"2025-09-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00157894","upload_search_indicator":null,"census_search_date":"2025-09-10 21:39:00","snet_input_date":"2025-09-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-10 21:39:00","insp_carrier_name":"MERCURY AIRCRAFT INC","insp_carrier_street":"8126 COUNTY ROUTE 88","insp_carrier_city":"HAMMONDSPORT","insp_carrier_state":"NY","insp_carrier_zip_code":"14840","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-13T10:47:24.000000Z","updated_at":"2025-09-13T10:47:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15922712,"change_date":"2025-09-10 21:39:00","inspection_id":"85729159","insp_unit_id":"208839658","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"115","insp_unit_license":"35001PA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4NC9EH2FN908949","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-13T10:00:13.000000Z","updated_at":"2025-09-13T10:00:13.000000Z"},{"id":15922713,"change_date":"2025-09-10 21:39:00","inspection_id":"85729159","insp_unit_id":"208839659","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":null,"insp_unit_license":"CF47248","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1UYVS25379G638198","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-13T10:00:13.000000Z","updated_at":"2025-09-13T10:00:13.000000Z"}]},{"id":9544006,"change_date":"2025-08-29 21:40:00","inspection_id":"85631218","dot_number":"157894","report_state":"NY","report_number":"M606700520","insp_date":"2025-08-26 00:00:00","insp_start_time":"0901","insp_end_time":"0928","registration_date":null,"region":"ED","ci_status_code":"C","location":"40354N","location_desc":"GROVELAND NY","county_code_state":"NY","county_code":"051","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"34026","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-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"2197678","transaction_code":"A","transaction_date":"2025-08-29 00:00:00","upload_date":"2025-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00157894","upload_search_indicator":null,"census_search_date":"2025-08-29 21:40:00","snet_input_date":"2025-08-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-29 21:40:00","insp_carrier_name":"MERCURY AIRCRAFT INC","insp_carrier_street":"8126 COUNTY ROUTE 88","insp_carrier_city":"HAMMONDSPORT","insp_carrier_state":"NY","insp_carrier_zip_code":"14840","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-06T10:42:29.000000Z","updated_at":"2025-09-06T10:42:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15752905,"change_date":"2025-08-29 21:40:00","inspection_id":"85631218","insp_unit_id":"208655292","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"123","insp_unit_license":"96476NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDAAA7PS009257","insp_unit_decal":"Y","insp_unit_decal_number":"35489063","created_at":"2025-09-09T09:46:49.000000Z","updated_at":"2025-09-09T09:46:49.000000Z"}]},{"id":9422177,"change_date":"2025-08-15 21:38:00","inspection_id":"85502806","dot_number":"157894","report_state":"NY","report_number":"5L50000092","insp_date":"2025-08-14 00:00:00","insp_start_time":"0929","insp_end_time":"0957","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MOUNT MORRIS NY","county_code_state":"NY","county_code":"051","insp_level_id":"1","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":"2025-08-15 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"2133997","transaction_code":"A","transaction_date":"2025-08-15 00:00:00","upload_date":"2025-08-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00157894","upload_search_indicator":null,"census_search_date":"2025-08-15 21:38:00","snet_input_date":"2025-08-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-15 21:38:00","insp_carrier_name":"MERCURY AIRCRAFT INC","insp_carrier_street":"8126 COUNTY ROUTE 88","insp_carrier_city":"HAMMONDSPORT","insp_carrier_state":"NY","insp_carrier_zip_code":"14840","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-20T10:44:34.000000Z","updated_at":"2025-08-20T10:44:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15531629,"change_date":"2025-08-15 21:38:00","inspection_id":"85502806","insp_unit_id":"208416821","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"96476NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDAAA7PS009257","insp_unit_decal":"Y","insp_unit_decal_number":"NONE","created_at":"2025-08-18T09:46:28.000000Z","updated_at":"2025-08-19T09:45:34.000000Z"}]},{"id":9444636,"change_date":"2025-09-09 21:40:00","inspection_id":"85526549","dot_number":"157894","report_state":"NY","report_number":"SPB3061164","insp_date":"2025-08-12 00:00:00","insp_start_time":"1010","insp_end_time":"1040","registration_date":"2025-08-12 00:00:00","region":"ED","ci_status_code":"C","location":"60585W","location_desc":"OWEGO NY","county_code_state":"NY","county_code":"107","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-19 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"2146694","transaction_code":"C","transaction_date":"2025-08-18 00:00:00","upload_date":"2025-09-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00157894","upload_search_indicator":null,"census_search_date":"2025-08-19 21:39:00","snet_input_date":"2025-08-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-19 21:39:00","insp_carrier_name":"MERCURY AIRCRAFT INC","insp_carrier_street":"8126 COUNTY ROUTE 88","insp_carrier_city":"HAMMONDSPORT","insp_carrier_state":"NY","insp_carrier_zip_code":"14840","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-23T10:46:14.000000Z","updated_at":"2025-09-13T10:46:19.000000Z","inspection_violations":[{"id":15747181,"change_date":"2025-09-09 21:40:00","inspection_id":"85526549","insp_violation_id":"268542661","seq_no":"1","part_no":"392","part_no_section":"9BA-INACTIVE","insp_viol_unit":"1","insp_unit_id":"208818874","insp_violation_category_id":"51","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-09-12T10:51:06.000000Z","updated_at":"2025-09-13T10:48:30.000000Z","normalized_code":"3929BAINACTIVE"}],"inspection_per_units":[{"id":15902487,"change_date":"2025-09-09 21:40:00","inspection_id":"85526549","insp_unit_id":"208818874","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"96476NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDAAA7PS009257","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-12T10:47:40.000000Z","updated_at":"2025-09-13T09:59:02.000000Z"}]},{"id":9229615,"change_date":"2025-07-24 21:40:00","inspection_id":"85300369","dot_number":"157894","report_state":"NY","report_number":"D507501150","insp_date":"2025-07-23 00:00:00","insp_start_time":"1012","insp_end_time":"1030","registration_date":null,"region":"ED","ci_status_code":"C","location":"40354N","location_desc":"GROVELAND NY","county_code_state":"NY","county_code":"051","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-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2032011","transaction_code":"A","transaction_date":"2025-07-23 00:00:00","upload_date":"2025-07-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00157894","upload_search_indicator":null,"census_search_date":"2025-07-24 21:40:00","snet_input_date":"2025-07-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-24 21:40:00","insp_carrier_name":"MERCURY AIRCRAFT INC","insp_carrier_street":"8126 COUNTY ROUTE 88","insp_carrier_city":"HAMMONDSPORT","insp_carrier_state":"NY","insp_carrier_zip_code":"14840","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-27T10:41:45.000000Z","updated_at":"2025-07-30T10:00:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15186501,"change_date":"2025-07-24 21:40:00","inspection_id":"85300369","insp_unit_id":"208044300","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"96476NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDAAA7PS009257","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-27T09:46:24.000000Z","updated_at":"2025-07-28T09:45:12.000000Z"}]},{"id":8737815,"change_date":"2025-05-27 21:38:00","inspection_id":"84780980","dot_number":"157894","report_state":"NY","report_number":"SPC3040230","insp_date":"2025-05-20 00:00:00","insp_start_time":"0905","insp_end_time":"0920","registration_date":null,"region":"ED","ci_status_code":"C","location":"60585E","location_desc":"NICHOLS NY","county_code_state":"NY","county_code":"107","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MERCURY AIRCRAFT","shipping_paper_number":"32887","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-27 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"1783131","transaction_code":"A","transaction_date":"2025-05-27 00:00:00","upload_date":"2025-05-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00157894","upload_search_indicator":null,"census_search_date":"2025-05-27 21:38:00","snet_input_date":"2025-05-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-27 21:38:00","insp_carrier_name":"MERCURY AIRCRAFT INC","insp_carrier_street":"8126 COUNTY ROUTE 88","insp_carrier_city":"HAMMONDSPORT","insp_carrier_state":"NY","insp_carrier_zip_code":"14840","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-30T10:00:21.000000Z","updated_at":"2025-05-31T10:00:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14286385,"change_date":"2025-05-27 21:38:00","inspection_id":"84780980","insp_unit_id":"207066489","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"123","insp_unit_license":"96476NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDAAA7PS009257","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-30T09:45:26.000000Z","updated_at":"2025-05-31T09:46:40.000000Z"}]},{"id":8652195,"change_date":"2025-05-16 21:42:00","inspection_id":"84690284","dot_number":"157894","report_state":"NY","report_number":"D507101574","insp_date":"2025-05-15 00:00:00","insp_start_time":"0846","insp_end_time":"0924","registration_date":null,"region":"ED","ci_status_code":"C","location":"40354N","location_desc":"GROVELAND NY","county_code_state":"NY","county_code":"051","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MERCURY AIRCRAFT","shipping_paper_number":"56038","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-16 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"1734901","transaction_code":"A","transaction_date":"2025-05-16 00:00:00","upload_date":"2025-05-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00157894","upload_search_indicator":null,"census_search_date":"2025-05-16 21:42:00","snet_input_date":"2025-05-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-16 21:42:00","insp_carrier_name":"MERCURY AIRCRAFT INC","insp_carrier_street":"8126 COUNTY ROUTE 88","insp_carrier_city":"HAMMONDSPORT","insp_carrier_state":"NY","insp_carrier_zip_code":"14840","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-19T10:03:50.000000Z","updated_at":"2025-05-20T10:03:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14132163,"change_date":"2025-05-16 21:42:00","inspection_id":"84690284","insp_unit_id":"206895802","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"115","insp_unit_license":"35001PA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4NC9EH2FN908949","insp_unit_decal":"Y","insp_unit_decal_number":"NONE","created_at":"2025-05-19T09:50:08.000000Z","updated_at":"2025-05-20T09:48:59.000000Z"},{"id":14132164,"change_date":"2025-05-16 21:42:00","inspection_id":"84690284","insp_unit_id":"206895803","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"609852","insp_unit_license":"CF47249","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1UYVS253879G64443","insp_unit_decal":"Y","insp_unit_decal_number":"NONE","created_at":"2025-05-19T09:50:08.000000Z","updated_at":"2025-05-20T09:48:59.000000Z"}]},{"id":8623443,"change_date":"2025-05-14 21:41:00","inspection_id":"84660269","dot_number":"157894","report_state":"NY","report_number":"M603600142","insp_date":"2025-05-13 00:00:00","insp_start_time":"0830","insp_end_time":"0909","registration_date":null,"region":"ED","ci_status_code":"C","location":"40354N","location_desc":"GROVELAND NY","county_code_state":"NY","county_code":"051","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-05-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"1722423","transaction_code":"A","transaction_date":"2025-05-14 00:00:00","upload_date":"2025-05-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00157894","upload_search_indicator":null,"census_search_date":"2025-05-14 21:41:00","snet_input_date":"2025-05-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-14 21:41:00","insp_carrier_name":"MERCURY AIRCRAFT INC","insp_carrier_street":"8126 COUNTY ROUTE 88","insp_carrier_city":"HAMMONDSPORT","insp_carrier_state":"NY","insp_carrier_zip_code":"14840","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-17T10:04:40.000000Z","updated_at":"2025-05-18T10:03:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14081161,"change_date":"2025-05-14 21:41:00","inspection_id":"84660269","insp_unit_id":"206841652","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"96476NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDAAA7PS009257","insp_unit_decal":"Y","insp_unit_decal_number":"35216954","created_at":"2025-05-17T09:48:35.000000Z","updated_at":"2025-05-18T09:48:45.000000Z"}]},{"id":8575019,"change_date":"2025-05-08 21:40:00","inspection_id":"84609210","dot_number":"157894","report_state":"NY","report_number":"SPC3070306","insp_date":"2025-05-01 00:00:00","insp_start_time":"1306","insp_end_time":"1336","registration_date":null,"region":"ED","ci_status_code":"C","location":"60585W","location_desc":"OWEGO NY","county_code_state":"NY","county_code":"107","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":"25950","viol_total":"3","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":"1697863","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":"00157894","upload_search_indicator":null,"census_search_date":"2025-05-08 21:40:00","snet_input_date":"2025-05-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-08 21:40:00","insp_carrier_name":"MERCURY AIRCRAFT INC","insp_carrier_street":"8126 COUNTY ROUTE 88","insp_carrier_city":"HAMMONDSPORT","insp_carrier_state":"NY","insp_carrier_zip_code":"14840","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-11T10:20:55.000000Z","updated_at":"2025-05-12T10:02:10.000000Z","inspection_violations":[{"id":13618663,"change_date":"2025-05-08 21:40:00","inspection_id":"84609210","insp_violation_id":"266098575","seq_no":"1","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"1","insp_unit_id":"206749462","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-10T11:31:31.000000Z","updated_at":"2025-05-12T10:19:59.000000Z","normalized_code":"3939ALSLI"},{"id":13618664,"change_date":"2025-05-08 21:40:00","inspection_id":"84609210","insp_violation_id":"266098576","seq_no":"2","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"206749462","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-10T11:31:31.000000Z","updated_at":"2025-05-12T10:19:59.000000Z","normalized_code":"3965BL"},{"id":13618665,"change_date":"2025-05-08 21:40:00","inspection_id":"84609210","insp_violation_id":"266098577","seq_no":"3","part_no":"393","part_no_section":"11A1-LTSM","insp_viol_unit":"1","insp_unit_id":"206749462","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"8C86K9DKPB","created_at":"2025-05-10T11:31:31.000000Z","updated_at":"2025-05-12T10:19:59.000000Z","normalized_code":"39311A1LTSM"}],"inspection_per_units":[{"id":13995445,"change_date":"2025-05-08 21:40:00","inspection_id":"84609210","insp_unit_id":"206749462","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"215","insp_unit_license":"76771ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV0F4S58614","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-11T03:52:26.000000Z","updated_at":"2025-05-12T09:48:47.000000Z"}]},{"id":8199329,"change_date":"2025-03-25 12:44:00","inspection_id":"84213566","dot_number":"157894","report_state":"NY","report_number":"D507500827","insp_date":"2025-03-18 00:00:00","insp_start_time":"1334","insp_end_time":"1349","registration_date":null,"region":"ED","ci_status_code":"C","location":"40644","location_desc":"PAVILION NY","county_code_state":"NY","county_code":"037","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-25 12:44:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"1510653","transaction_code":"A","transaction_date":"2025-03-25 00:00:00","upload_date":"2025-03-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00157894","upload_search_indicator":null,"census_search_date":"2025-03-25 12:44:00","snet_input_date":"2025-03-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-25 12:44:00","insp_carrier_name":"MERCURY AIRCRAFT INC","insp_carrier_street":"8126 COUNTY ROUTE 88","insp_carrier_city":"HAMMONDSPORT","insp_carrier_state":"NY","insp_carrier_zip_code":"14840","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-28T10:14:42.000000Z","updated_at":"2025-03-29T10:19:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13256138,"change_date":"2025-03-25 12:44:00","inspection_id":"84213566","insp_unit_id":"205967426","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"96476NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDAAA7PS009257","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-28T10:02:54.000000Z","updated_at":"2025-03-29T09:55:13.000000Z"}]},{"id":8141462,"change_date":"2025-03-18 21:39:00","inspection_id":"84152766","dot_number":"157894","report_state":"NY","report_number":"SPE4070029","insp_date":"2025-03-11 00:00:00","insp_start_time":"1130","insp_end_time":"1153","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"CAMPBELL NY","county_code_state":"NY","county_code":"101","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MERCURY CORPORATION","shipping_paper_number":"32221","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-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"1483356","transaction_code":"A","transaction_date":"2025-03-18 00:00:00","upload_date":"2025-03-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00157894","upload_search_indicator":null,"census_search_date":"2025-03-18 21:39:00","snet_input_date":"2025-03-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-18 21:39:00","insp_carrier_name":"MERCURY AIRCRAFT INC","insp_carrier_street":"8126 COUNTY ROUTE 88","insp_carrier_city":"HAMMONDSPORT","insp_carrier_state":"NY","insp_carrier_zip_code":"14840","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-21T10:28:29.000000Z","updated_at":"2025-03-22T10:28:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13148257,"change_date":"2025-03-18 21:39:00","inspection_id":"84152766","insp_unit_id":"205850211","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"96476NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDAAA7PS009257","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-21T10:01:50.000000Z","updated_at":"2025-03-22T09:51:17.000000Z"}]},{"id":8076387,"change_date":"2025-03-11 21:40:00","inspection_id":"84084115","dot_number":"157894","report_state":"NY","report_number":"D507005594","insp_date":"2025-03-10 00:00:00","insp_start_time":"0955","insp_end_time":"1018","registration_date":null,"region":"ED","ci_status_code":"C","location":"40714W","location_desc":"CHURCHVILLE NY","county_code_state":"NY","county_code":"055","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-03-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"1453690","transaction_code":"A","transaction_date":"2025-03-11 00:00:00","upload_date":"2025-03-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00157894","upload_search_indicator":null,"census_search_date":"2025-03-11 21:40:00","snet_input_date":"2025-03-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-11 21:40:00","insp_carrier_name":"MERCURY AIRCRAFT INC","insp_carrier_street":"8126 COUNTY ROUTE 88","insp_carrier_city":"HAMMONDSPORT","insp_carrier_state":"NY","insp_carrier_zip_code":"14840","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:05:53.000000Z","updated_at":"2025-03-17T21:05:53.000000Z","inspection_violations":[{"id":12621708,"change_date":"2025-03-11 21:40:00","inspection_id":"84084115","insp_violation_id":"264931999","seq_no":"1","part_no":"393","part_no_section":"203B-CBP","insp_viol_unit":"1","insp_unit_id":"205721132","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:49.000000Z","updated_at":"2025-03-17T22:07:49.000000Z","normalized_code":"393203BCBP"}],"inspection_per_units":[{"id":13039894,"change_date":"2025-03-11 21:40:00","inspection_id":"84084115","insp_unit_id":"205721132","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"96476NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDAAA7PS009257","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:05.000000Z","updated_at":"2025-03-17T23:59:05.000000Z"}]},{"id":8103733,"change_date":"2025-03-13 21:43:00","inspection_id":"84112826","dot_number":"157894","report_state":"NY","report_number":"SPE3040519","insp_date":"2025-03-07 00:00:00","insp_start_time":"0820","insp_end_time":"0850","registration_date":null,"region":"ES","ci_status_code":"C","location":"60056M","location_desc":"BATH NY","county_code_state":"NY","county_code":"101","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MERCURY","shipping_paper_number":"48701","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-13 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"114999","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":"1464300","transaction_code":"A","transaction_date":"2025-03-13 00:00:00","upload_date":"2025-03-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00157894","upload_search_indicator":null,"census_search_date":"2025-03-13 21:43:00","snet_input_date":"2025-03-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-13 21:43:00","insp_carrier_name":"MERCURY AIRCRAFT INC","insp_carrier_street":"8126 COUNTY ROUTE 88","insp_carrier_city":"HAMMONDSPORT","insp_carrier_state":"NY","insp_carrier_zip_code":"14840","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:06:50.000000Z","updated_at":"2025-03-17T21:06:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13084135,"change_date":"2025-03-13 21:43:00","inspection_id":"84112826","insp_unit_id":"205776878","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":null,"insp_unit_license":"35005PA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4NC9EH4GN957121","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:38.000000Z","updated_at":"2025-03-17T23:59:38.000000Z"},{"id":13084136,"change_date":"2025-03-13 21:43:00","inspection_id":"84112826","insp_unit_id":"205776879","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":null,"insp_unit_license":"CF47249","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1UYVS25379G644437","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:38.000000Z","updated_at":"2025-03-17T23:59:38.000000Z"}]},{"id":8050044,"change_date":"2025-03-07 21:38:00","inspection_id":"84056256","dot_number":"157894","report_state":"NY","report_number":"5L50000033","insp_date":"2025-03-05 00:00:00","insp_start_time":"0931","insp_end_time":"1012","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MOUNT MORRIS NY","county_code_state":"NY","county_code":"051","insp_level_id":"1","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":"2025-03-07 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":"1439549","transaction_code":"A","transaction_date":"2025-03-07 00:00:00","upload_date":"2025-03-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00157894","upload_search_indicator":null,"census_search_date":"2025-03-07 21:38:00","snet_input_date":"2025-03-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-07 21:38:00","insp_carrier_name":"MERCURY AIRCRAFT INC","insp_carrier_street":"8126 COUNTY ROUTE 88","insp_carrier_city":"HAMMONDSPORT","insp_carrier_state":"NY","insp_carrier_zip_code":"14840","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:05:25.000000Z","updated_at":"2025-03-17T21:05:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12996697,"change_date":"2025-03-07 21:38:00","inspection_id":"84056256","insp_unit_id":"205671699","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"123","insp_unit_license":"96476NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDAAA7PS009257","insp_unit_decal":"Y","insp_unit_decal_number":"none","created_at":"2025-03-17T23:58:35.000000Z","updated_at":"2025-03-17T23:58:35.000000Z"}]},{"id":8077108,"change_date":"2025-03-11 21:40:00","inspection_id":"84084876","dot_number":"157894","report_state":"NY","report_number":"SPF3060527","insp_date":"2025-03-04 00:00:00","insp_start_time":"1303","insp_end_time":"1324","registration_date":null,"region":"ES","ci_status_code":"C","location":"60585E","location_desc":"NICHOLS NY","county_code_state":"NY","county_code":"107","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-03-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"1454576","transaction_code":"A","transaction_date":"2025-03-11 00:00:00","upload_date":"2025-03-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00157894","upload_search_indicator":null,"census_search_date":"2025-03-11 21:40:00","snet_input_date":"2025-03-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-11 21:40:00","insp_carrier_name":"MERCURY AIRCRAFT INC","insp_carrier_street":"8126 COUNTY ROUTE 88","insp_carrier_city":"HAMMONDSPORT","insp_carrier_state":"NY","insp_carrier_zip_code":"14840","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:05:53.000000Z","updated_at":"2025-03-17T21:05:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13041045,"change_date":"2025-03-11 21:40:00","inspection_id":"84084876","insp_unit_id":"205722394","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"123","insp_unit_license":"96476NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDAAA7PS009257","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:10.000000Z","updated_at":"2025-03-17T23:59:10.000000Z"}]},{"id":7914752,"change_date":"2025-02-20 21:40:00","inspection_id":"83914340","dot_number":"157894","report_state":"NY","report_number":"SPE3080268","insp_date":"2025-02-13 00:00:00","insp_start_time":"1257","insp_end_time":"1320","registration_date":null,"region":"ES","ci_status_code":"C","location":"40354S","location_desc":"GROVELAND NY","county_code_state":"NY","county_code":"051","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-02-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"1379064","transaction_code":"A","transaction_date":"2025-02-20 00:00:00","upload_date":"2025-02-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00157894","upload_search_indicator":null,"census_search_date":"2025-02-20 21:40:00","snet_input_date":"2025-02-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-20 21:40:00","insp_carrier_name":"MERCURY AIRCRAFT INC","insp_carrier_street":"8126 COUNTY ROUTE 88","insp_carrier_city":"HAMMONDSPORT","insp_carrier_state":"NY","insp_carrier_zip_code":"14840","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:02:24.000000Z","updated_at":"2025-03-17T21:02:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12775985,"change_date":"2025-02-20 21:40:00","inspection_id":"83914340","insp_unit_id":"205410896","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"123","insp_unit_license":"96476NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDAAA7PS009257","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:09.000000Z","updated_at":"2025-03-17T23:56:09.000000Z"}]},{"id":7857841,"change_date":"2025-02-13 21:40:00","inspection_id":"83854687","dot_number":"157894","report_state":"NY","report_number":"SPC3020463","insp_date":"2025-02-06 00:00:00","insp_start_time":"0940","insp_end_time":"1004","registration_date":null,"region":"ES","ci_status_code":"C","location":"60585E","location_desc":"NICHOLS NY","county_code_state":"NY","county_code":"107","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MERCURY","shipping_paper_number":"48462","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-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"1355122","transaction_code":"A","transaction_date":"2025-02-13 00:00:00","upload_date":"2025-02-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00157894","upload_search_indicator":null,"census_search_date":"2025-02-13 21:40:00","snet_input_date":"2025-02-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-13 21:40:00","insp_carrier_name":"MERCURY AIRCRAFT INC","insp_carrier_street":"8126 COUNTY ROUTE 88","insp_carrier_city":"HAMMONDSPORT","insp_carrier_state":"NY","insp_carrier_zip_code":"14840","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:01:14.000000Z","updated_at":"2025-03-17T21:01:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12682446,"change_date":"2025-02-13 21:40:00","inspection_id":"83854687","insp_unit_id":"205300641","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"123","insp_unit_license":"96476NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDAAA7PS009257","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:05.000000Z","updated_at":"2025-03-17T23:55:05.000000Z"}]},{"id":7648389,"change_date":"2025-01-17 21:39:00","inspection_id":"83634536","dot_number":"157894","report_state":"NY","report_number":"D507101286","insp_date":"2025-01-16 00:00:00","insp_start_time":"0925","insp_end_time":"0939","registration_date":null,"region":"ES","ci_status_code":"C","location":"60056M","location_desc":"BATH NY","county_code_state":"NY","county_code":"101","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MERCURY AIRCRAFT","shipping_paper_number":"55884","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-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","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":"1259895","transaction_code":"A","transaction_date":"2025-01-17 00:00:00","upload_date":"2025-01-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00157894","upload_search_indicator":null,"census_search_date":"2025-01-17 21:39:00","snet_input_date":"2025-01-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-17 21:39:00","insp_carrier_name":"MERCURY AIRCRAFT INC","insp_carrier_street":"8126 COUNTY ROUTE 88","insp_carrier_city":"HAMMONDSPORT","insp_carrier_state":"NY","insp_carrier_zip_code":"14840","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:57:01.000000Z","updated_at":"2025-03-17T20:57:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12341131,"change_date":"2025-01-17 21:39:00","inspection_id":"83634536","insp_unit_id":"204889470","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":null,"insp_unit_license":"35005PA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4NC9EH4GN957121","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:13.000000Z","updated_at":"2025-03-17T23:51:13.000000Z"},{"id":12341132,"change_date":"2025-01-17 21:39:00","inspection_id":"83634536","insp_unit_id":"204889471","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"CE57220","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GR1P0621PD446739","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:13.000000Z","updated_at":"2025-03-17T23:51:13.000000Z"}]},{"id":7603410,"change_date":"2025-01-13 21:45:00","inspection_id":"83587459","dot_number":"157894","report_state":"NY","report_number":"D306001005","insp_date":"2025-01-09 00:00:00","insp_start_time":"1151","insp_end_time":"1209","registration_date":null,"region":"ES","ci_status_code":"C","location":"60056M","location_desc":"BATH NY","county_code_state":"NY","county_code":"101","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MERCURY CORPORATION","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-13 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"1242533","transaction_code":"A","transaction_date":"2025-01-13 00:00:00","upload_date":"2025-01-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00157894","upload_search_indicator":null,"census_search_date":"2025-01-13 21:45:00","snet_input_date":"2025-01-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-13 21:45:00","insp_carrier_name":"MERCURY AIRCRAFT INC","insp_carrier_street":"8126 COUNTY ROUTE 88","insp_carrier_city":"HAMMONDSPORT","insp_carrier_state":"NY","insp_carrier_zip_code":"14840","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:56:06.000000Z","updated_at":"2025-03-17T20:56:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12268625,"change_date":"2025-01-13 21:45:00","inspection_id":"83587459","insp_unit_id":"204773734","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"96476NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDAAA7PS009257","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:23.000000Z","updated_at":"2025-03-17T23:50:23.000000Z"}]},{"id":7444508,"change_date":"2024-12-18 21:40:00","inspection_id":"83420461","dot_number":"157894","report_state":"NY","report_number":"SPT3050302","insp_date":"2024-12-11 00:00:00","insp_start_time":"0926","insp_end_time":"0944","registration_date":null,"region":"ES","ci_status_code":"C","location":"60117R","location_desc":"CAMPBELL NY","county_code_state":"NY","county_code":"101","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MERCURY AIRCRAFT INC","shipping_paper_number":"47973","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-12-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"1168425","transaction_code":"A","transaction_date":"2024-12-18 00:00:00","upload_date":"2024-12-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00157894","upload_search_indicator":null,"census_search_date":"2024-12-18 21:40:00","snet_input_date":"2024-12-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-12-18 21:40:00","insp_carrier_name":"MERCURY AIRCRAFT INC","insp_carrier_street":"8126 COUNTY ROUTE 88","insp_carrier_city":"HAMMONDSPORT","insp_carrier_state":"NY","insp_carrier_zip_code":"14840","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:51:31.000000Z","updated_at":"2025-03-17T20:51:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12009808,"change_date":"2024-12-18 21:40:00","inspection_id":"83420461","insp_unit_id":"204445018","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"96476NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDAAA7PS009257","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:34.000000Z","updated_at":"2025-03-17T23:47:34.000000Z"}]},{"id":7435017,"change_date":"2025-01-13 21:45:00","inspection_id":"83410496","dot_number":"157894","report_state":"NY","report_number":"SPC3010265","insp_date":"2024-12-10 00:00:00","insp_start_time":"0910","insp_end_time":"0936","registration_date":null,"region":"ES","ci_status_code":"C","location":"60585E","location_desc":"NICHOLS NY","county_code_state":"NY","county_code":"107","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MERCURY AIRCRAFT","shipping_paper_number":"47948","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-12-17 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"1164729","transaction_code":"C","transaction_date":"2024-12-17 00:00:00","upload_date":"2025-01-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00157894","upload_search_indicator":null,"census_search_date":"2024-12-17 21:38:00","snet_input_date":"2024-12-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-12-17 21:38:00","insp_carrier_name":"MERCURY AIRCRAFT INC","insp_carrier_street":"8126 COUNTY ROUTE 88","insp_carrier_city":"HAMMONDSPORT","insp_carrier_state":"NY","insp_carrier_zip_code":"14840","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:51:10.000000Z","updated_at":"2025-03-17T20:51:10.000000Z","inspection_violations":[{"id":11618259,"change_date":"2025-01-13 21:45:00","inspection_id":"83410496","insp_violation_id":"263893449","seq_no":"1","part_no":"393","part_no_section":"55E-B","insp_viol_unit":"2","insp_unit_id":"204771376","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:33.000000Z","updated_at":"2025-03-17T22:02:33.000000Z","normalized_code":"39355EB"},{"id":11618260,"change_date":"2025-01-13 21:45:00","inspection_id":"83410496","insp_violation_id":"263893450","seq_no":"2","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"204771376","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:33.000000Z","updated_at":"2025-03-17T22:02:33.000000Z","normalized_code":"3939ALIL"},{"id":11618261,"change_date":"2025-01-13 21:45:00","inspection_id":"83410496","insp_violation_id":"263893451","seq_no":"3","part_no":"393","part_no_section":"55D2-B","insp_viol_unit":"1","insp_unit_id":"204771375","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:33.000000Z","updated_at":"2025-03-17T22:02:33.000000Z","normalized_code":"39355D2B"}],"inspection_per_units":[{"id":11994818,"change_date":"2025-01-13 21:45:00","inspection_id":"83410496","insp_unit_id":"204771375","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"115","insp_unit_license":"35001PA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4NC9EH2FN908949","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:24.000000Z","updated_at":"2025-03-17T23:47:24.000000Z"},{"id":11994819,"change_date":"2025-01-13 21:45:00","inspection_id":"83410496","insp_unit_id":"204771376","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"609140","insp_unit_license":"CF47248","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1UYVS25379G638198","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:24.000000Z","updated_at":"2025-03-17T23:47:24.000000Z"}]},{"id":6756103,"change_date":"2024-09-18 21:42:00","inspection_id":"82691156","dot_number":"157894","report_state":"NY","report_number":"SPWE031275","insp_date":"2024-09-16 00:00:00","insp_start_time":"1040","insp_end_time":"1055","registration_date":null,"region":"ET","ci_status_code":"C","location":"40714B","location_desc":"RIGA (WB)","county_code_state":"NY","county_code":"055","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-09-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"2951091","transaction_code":"A","transaction_date":"2024-09-18 00:00:00","upload_date":"2024-09-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00157894","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-09-18 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-09-18 21:42:00","insp_carrier_name":"MERCURY AIRCRAFT INC","insp_carrier_street":"8126 COUNTY ROUTE 88","insp_carrier_city":"HAMMONDSPORT","insp_carrier_state":"NY","insp_carrier_zip_code":"14840","insp_colonia":null,"docket_number":"426218","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:36:58.000000Z","updated_at":"2025-03-17T20:36:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10894272,"change_date":"2024-09-18 21:42:00","inspection_id":"82691156","insp_unit_id":"203002104","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"96476NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDAAA7PS009257","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:49.000000Z","updated_at":"2025-03-17T23:35:49.000000Z"}]},{"id":6756203,"change_date":"2024-09-18 21:42:00","inspection_id":"82691265","dot_number":"157894","report_state":"NY","report_number":"SPC0261169","insp_date":"2024-09-11 00:00:00","insp_start_time":"1058","insp_end_time":"1120","registration_date":null,"region":"ET","ci_status_code":"C","location":"60585A","location_desc":"NICHOLS (EB)","county_code_state":"NY","county_code":"107","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MERCURY","shipping_paper_number":"47142","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-18 21:42: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":"2950960","transaction_code":"A","transaction_date":"2024-09-18 00:00:00","upload_date":"2024-09-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00157894","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-09-18 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-09-18 21:42:00","insp_carrier_name":"MERCURY AIRCRAFT INC","insp_carrier_street":"8126 COUNTY ROUTE 88","insp_carrier_city":"HAMMONDSPORT","insp_carrier_state":"NY","insp_carrier_zip_code":"14840","insp_colonia":null,"docket_number":"426218","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:36:58.000000Z","updated_at":"2025-03-17T20:36:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10894414,"change_date":"2024-09-18 21:42:00","inspection_id":"82691265","insp_unit_id":"203002270","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"96476NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDAAA7PS009257","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:49.000000Z","updated_at":"2025-03-17T23:35:49.000000Z"}]},{"id":6345672,"change_date":"2024-07-30 21:43:00","inspection_id":"82253600","dot_number":"157894","report_state":"NY","report_number":"SPE0229474","insp_date":"2024-07-29 00:00:00","insp_start_time":"1119","insp_end_time":"1135","registration_date":null,"region":"ET","ci_status_code":"C","location":"40354A","location_desc":"GROVELAND (NB)","county_code_state":"NY","county_code":"051","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":"2024-07-30 21:43: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":"2941329","transaction_code":"A","transaction_date":"2024-07-30 00:00:00","upload_date":"2024-07-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00157894","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-07-30 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-07-30 21:43:00","insp_carrier_name":"MERCURY AIRCRAFT INC","insp_carrier_street":"8126 COUNTY ROUTE 88","insp_carrier_city":"HAMMONDSPORT","insp_carrier_state":"NY","insp_carrier_zip_code":"14840","insp_colonia":null,"docket_number":"426218","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:28:40.000000Z","updated_at":"2025-03-17T20:28:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10225481,"change_date":"2024-07-30 21:43:00","inspection_id":"82253600","insp_unit_id":"202143132","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"96476NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDAAA7PS009257","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:57.000000Z","updated_at":"2025-03-17T23:28:57.000000Z"}]},{"id":6260246,"change_date":"2024-07-25 21:43:00","inspection_id":"82162217","dot_number":"157894","report_state":"NY","report_number":"SPWE021475","insp_date":"2024-07-18 00:00:00","insp_start_time":"1035","insp_end_time":"1055","registration_date":null,"region":"ET","ci_status_code":"C","location":"60056B","location_desc":"BATH (WB)","county_code_state":"NY","county_code":"101","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MERCURY CORPORATION","shipping_paper_number":"46765","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-19 21:37: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":"2938376","transaction_code":"C","transaction_date":"2024-07-19 00:00:00","upload_date":"2024-07-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00157894","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-07-19 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-07-19 21:37:00","insp_carrier_name":"MERCURY AIRCRAFT INC","insp_carrier_street":"8126 COUNTY ROUTE 88","insp_carrier_city":"HAMMONDSPORT","insp_carrier_state":"NY","insp_carrier_zip_code":"14840","insp_colonia":null,"docket_number":"426218","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:26:57.000000Z","updated_at":"2025-03-17T20:26:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10086316,"change_date":"2024-07-25 21:43:00","inspection_id":"82162217","insp_unit_id":"202066799","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"96476NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDAAA7PS009257","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:32.000000Z","updated_at":"2025-03-17T23:27:32.000000Z"}]},{"id":5817380,"change_date":"2024-05-22 21:40:00","inspection_id":"81684243","dot_number":"157894","report_state":"NY","report_number":"SPF0198328","insp_date":"2024-05-21 00:00:00","insp_start_time":"1045","insp_end_time":"1117","registration_date":null,"region":"ET","ci_status_code":"C","location":"60585B","location_desc":"NICHOLS (WB)","county_code_state":"NY","county_code":"107","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-05-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"598200","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":"2925565","transaction_code":"A","transaction_date":"2024-05-22 00:00:00","upload_date":"2024-05-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00157894","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-05-22 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-05-22 21:40:00","insp_carrier_name":"MERCURY AIRCRAFT INC","insp_carrier_street":"8126 COUNTY ROUTE 88","insp_carrier_city":"HAMMONDSPORT","insp_carrier_state":"NY","insp_carrier_zip_code":"14840","insp_colonia":null,"docket_number":"426218","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:17:55.000000Z","updated_at":"2025-03-17T20:17:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9369012,"change_date":"2024-05-22 21:40:00","inspection_id":"81684243","insp_unit_id":"201032804","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"115","insp_unit_license":"35001PA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4NC9EH2FN908949","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:16.000000Z","updated_at":"2025-03-17T23:20:16.000000Z"},{"id":9369013,"change_date":"2024-05-22 21:40:00","inspection_id":"81684243","insp_unit_id":"201032805","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"CF47248","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1UYVS25379G638198","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:16.000000Z","updated_at":"2025-03-17T23:20:16.000000Z"}]},{"id":5805180,"change_date":"2024-05-21 21:46:00","inspection_id":"81670750","dot_number":"157894","report_state":"NY","report_number":"SPA0276262","insp_date":"2024-05-06 00:00:00","insp_start_time":"0135","insp_end_time":"1350","registration_date":null,"region":"ET","ci_status_code":"C","location":"40644A","location_desc":"PAVILION","county_code_state":"NY","county_code":"051","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":"2024-05-21 21:46: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":"2924937","transaction_code":"A","transaction_date":"2024-05-21 00:00:00","upload_date":"2024-05-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00157894","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-05-21 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-05-21 21:46:00","insp_carrier_name":"MERCURY AIRCRAFT INC","insp_carrier_street":"8126 COUNTY ROUTE 88","insp_carrier_city":"HAMMONDSPORT","insp_carrier_state":"NY","insp_carrier_zip_code":"14840","insp_colonia":null,"docket_number":"426218","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:17:51.000000Z","updated_at":"2025-03-17T20:17:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9349523,"change_date":"2024-05-21 21:46:00","inspection_id":"81670750","insp_unit_id":"201007116","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"76771ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV0F4S58614","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:02.000000Z","updated_at":"2025-03-17T23:20:02.000000Z"}]},{"id":5694961,"change_date":"2024-05-08 21:41:00","inspection_id":"81551369","dot_number":"157894","report_state":"NY","report_number":"SPA3020018","insp_date":"2024-05-02 00:00:00","insp_start_time":"1225","insp_end_time":"1246","registration_date":null,"region":"ED","ci_status_code":"C","location":"60308","location_desc":"FRIENDSHIP NY","county_code_state":"NY","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"JAMESTOWN ELECTRO PLATING WORKS INC","shipping_paper_number":"376917","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-05-08 21:41: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":"464390","transaction_code":"A","transaction_date":"2024-05-08 00:00:00","upload_date":"2024-05-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00157894","upload_search_indicator":null,"census_search_date":"2024-05-08 21:41:00","snet_input_date":"2024-05-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-08 21:41:00","insp_carrier_name":"MERCURY AIRCRAFT INC","insp_carrier_street":"8126 COUNTY ROUTE 88","insp_carrier_city":"HAMMONDSPORT","insp_carrier_state":"NY","insp_carrier_zip_code":"14840","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:15:31.000000Z","updated_at":"2025-03-17T20:15:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9172653,"change_date":"2024-05-08 21:41:00","inspection_id":"81551369","insp_unit_id":"200781139","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"76771ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV0F4S58614","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:22.000000Z","updated_at":"2025-03-17T23:18:22.000000Z"}]},{"id":5378118,"change_date":"2024-03-27 21:41:00","inspection_id":"81205692","dot_number":"157894","report_state":"NY","report_number":"5L42000573","insp_date":"2024-03-27 00:00:00","insp_start_time":"1245","insp_end_time":"1330","registration_date":null,"region":"ED","ci_status_code":"C","location":"40354S","location_desc":"GROVELAND NY","county_code_state":"NY","county_code":"051","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-03-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"351151","transaction_code":"A","transaction_date":"2024-03-27 00:00:00","upload_date":"2024-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00157894","upload_search_indicator":null,"census_search_date":"2024-03-27 21:41:00","snet_input_date":"2024-03-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-03-27 21:41:00","insp_carrier_name":"MERCURY AIRCRAFT INC","insp_carrier_street":"8126 COUNTY ROUTE 88","insp_carrier_city":"HAMMONDSPORT","insp_carrier_state":"NY","insp_carrier_zip_code":"14840","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:09:06.000000Z","updated_at":"2025-03-17T20:09:06.000000Z","inspection_violations":[{"id":8300909,"change_date":"2024-03-27 21:41:00","inspection_id":"81205692","insp_violation_id":"258606486","seq_no":"1","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"200107626","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:12.000000Z","updated_at":"2025-03-17T21:46:12.000000Z","normalized_code":"3939ALCL"}],"inspection_per_units":[{"id":8661507,"change_date":"2024-03-27 21:41:00","inspection_id":"81205692","insp_unit_id":"200107626","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":null,"insp_unit_company":"215","insp_unit_license":"76771ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV0F4S58614","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:34.000000Z","updated_at":"2025-03-17T23:13:34.000000Z"}]},{"id":4835558,"change_date":"2024-01-16 21:44:00","inspection_id":"80613480","dot_number":"157894","report_state":"NY","report_number":"SPA0340642","insp_date":"2024-01-03 00:00:00","insp_start_time":"1344","insp_end_time":"1359","registration_date":null,"region":"ET","ci_status_code":"C","location":"40354","location_desc":"GROVELAND REST AREA S\/B","county_code_state":"NY","county_code":"051","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MERCURY CORPORATION","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-16 21:44: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":"2899758","transaction_code":"A","transaction_date":"2024-01-16 00:00:00","upload_date":"2024-01-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00157894","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-01-16 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-01-16 21:44:00","insp_carrier_name":"MERCURY AIRCRAFT INC","insp_carrier_street":"8126 COUNTY ROUTE 88","insp_carrier_city":"HAMMONDSPORT","insp_carrier_state":"NY","insp_carrier_zip_code":"14840","insp_colonia":null,"docket_number":"426218","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:58:28.000000Z","updated_at":"2025-03-17T19:58:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7779651,"change_date":"2024-01-16 21:44:00","inspection_id":"80613480","insp_unit_id":"198965162","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"76771ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV0F4S58614","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:31.000000Z","updated_at":"2025-03-17T23:05:31.000000Z"}]},{"id":4706207,"change_date":"2023-12-27 21:41:00","inspection_id":"80472260","dot_number":"157894","report_state":"NY","report_number":"5L42000013","insp_date":"2023-12-21 00:00:00","insp_start_time":"1016","insp_end_time":"1127","registration_date":null,"region":"ES","ci_status_code":"C","location":"40354N","location_desc":"GROVELAND NY","county_code_state":"NY","county_code":"051","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MERCURY AIRCRAFT INC","shipping_paper_number":"55355","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-12-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"6","oos_total":"4","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"145764","transaction_code":"A","transaction_date":"2023-12-27 00:00:00","upload_date":"2023-12-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00157894","upload_search_indicator":null,"census_search_date":"2023-12-27 21:41:00","snet_input_date":"2023-12-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-12-27 21:41:00","insp_carrier_name":"MERCURY AIRCRAFT INC","insp_carrier_street":"8126 COUNTY ROUTE 88","insp_carrier_city":"HAMMONDSPORT","insp_carrier_state":"NY","insp_carrier_zip_code":"14840","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:56:09.000000Z","updated_at":"2025-03-17T19:56:09.000000Z","inspection_violations":[{"id":7268082,"change_date":"2023-12-27 21:41:00","inspection_id":"80472260","insp_violation_id":"257055701","seq_no":"1","part_no":"393","part_no_section":"9A-HLLH","insp_viol_unit":"1","insp_unit_id":"198672265","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:07.000000Z","updated_at":"2025-03-17T21:41:07.000000Z","normalized_code":"3939AHLLH"},{"id":7268083,"change_date":"2023-12-27 21:41:00","inspection_id":"80472260","insp_violation_id":"257055702","seq_no":"2","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"198672265","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:07.000000Z","updated_at":"2025-03-17T21:41:07.000000Z","normalized_code":"3939ALCL"},{"id":7268084,"change_date":"2023-12-27 21:41:00","inspection_id":"80472260","insp_violation_id":"257055703","seq_no":"3","part_no":"393","part_no_section":"47A-BCFSHE-SA","insp_viol_unit":"1","insp_unit_id":"198672265","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:41:07.000000Z","updated_at":"2025-03-17T21:41:07.000000Z","normalized_code":"39347ABCFSHESA"},{"id":7268085,"change_date":"2023-12-27 21:41:00","inspection_id":"80472260","insp_violation_id":"257055704","seq_no":"4","part_no":"396","part_no_section":"5B-HWSL","insp_viol_unit":"1","insp_unit_id":"198672265","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:41:07.000000Z","updated_at":"2025-03-17T21:41:07.000000Z","normalized_code":"3965BHWSL"},{"id":7268086,"change_date":"2023-12-27 21:41:00","inspection_id":"80472260","insp_violation_id":"257055705","seq_no":"5","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"1","insp_unit_id":"198672265","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:41:07.000000Z","updated_at":"2025-03-17T21:41:07.000000Z","normalized_code":"3963A1BOS"},{"id":7268087,"change_date":"2023-12-27 21:41:00","inspection_id":"80472260","insp_violation_id":"257055706","seq_no":"6","part_no":"396","part_no_section":"5B-HWSL","insp_viol_unit":"1","insp_unit_id":"198672265","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:41:07.000000Z","updated_at":"2025-03-17T21:41:07.000000Z","normalized_code":"3965BHWSL"}],"inspection_per_units":[{"id":7569733,"change_date":"2023-12-27 21:41:00","inspection_id":"80472260","insp_unit_id":"198672265","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"215","insp_unit_license":"76771ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV0F4S58614","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:39.000000Z","updated_at":"2025-03-17T23:03:39.000000Z"}]},{"id":4200182,"change_date":"2023-10-16 21:42:00","inspection_id":"79914767","dot_number":"157894","report_state":"NY","report_number":"MC57001159","insp_date":"2023-10-12 00:00:00","insp_start_time":"0850","insp_end_time":"0919","registration_date":null,"region":"ET","ci_status_code":"C","location":"40354M","location_desc":"GROVELAND REST AREA (NB)","county_code_state":"NY","county_code":"051","insp_level_id":"1","service_center":"EA","census_source_id":"4","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":"N","pen_cen_match":"I","final_status_date":"2023-10-16 21:42: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":"2878512","transaction_code":"A","transaction_date":"2023-10-12 00:00:00","upload_date":"2023-10-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00157894","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-10-16 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-10-16 21:42:00","insp_carrier_name":"MERCURY AIRCRAFT INC","insp_carrier_street":"8126 COUNTY ROUTE 88","insp_carrier_city":"HAMMONDSPORT","insp_carrier_state":"NY","insp_carrier_zip_code":"14840-9458","insp_colonia":null,"docket_number":"426218","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:46:11.000000Z","updated_at":"2025-03-17T19:46:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6754596,"change_date":"2023-10-16 21:42:00","inspection_id":"79914767","insp_unit_id":"197562582","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"215","insp_unit_license":"76771ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV0F4S58614","insp_unit_decal":"Y","insp_unit_decal_number":"33399527","created_at":"2025-03-17T22:56:37.000000Z","updated_at":"2025-03-17T22:56:37.000000Z"}]},{"id":4180378,"change_date":"2023-10-12 21:41:00","inspection_id":"79892853","dot_number":"157894","report_state":"NY","report_number":"SPWE031153","insp_date":"2023-10-11 00:00:00","insp_start_time":"0907","insp_end_time":"0922","registration_date":null,"region":"ET","ci_status_code":"C","location":"40714B","location_desc":"RIGA (WB)","county_code_state":"NY","county_code":"055","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MERCURY AIRCRAFT","shipping_paper_number":"55241","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-10-12 21:41: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":"2877617","transaction_code":"A","transaction_date":"2023-10-12 00:00:00","upload_date":"2023-10-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00157894","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-10-12 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-10-12 21:41:00","insp_carrier_name":"MERCURY AIRCRAFT INC","insp_carrier_street":"8126 COUNTY ROUTE 88","insp_carrier_city":"HAMMONDSPORT","insp_carrier_state":"NY","insp_carrier_zip_code":"14840","insp_colonia":null,"docket_number":"426218","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:45:48.000000Z","updated_at":"2025-03-17T19:45:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6722340,"change_date":"2023-10-12 21:41:00","inspection_id":"79892853","insp_unit_id":"197516213","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"76771ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV0F4S58614","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:22.000000Z","updated_at":"2025-03-17T22:56:22.000000Z"}]},{"id":4067341,"change_date":"2023-09-27 21:41:00","inspection_id":"79767672","dot_number":"157894","report_state":"NY","report_number":"SPA0334259","insp_date":"2023-09-22 00:00:00","insp_start_time":"1449","insp_end_time":"1512","registration_date":null,"region":"ET","ci_status_code":"C","location":"60308A","location_desc":"FRIENDSHIP (EB)","county_code_state":"NY","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-27 21:41: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":"2873246","transaction_code":"A","transaction_date":"2023-09-27 00:00:00","upload_date":"2023-09-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00157894","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-09-27 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-09-27 21:41:00","insp_carrier_name":"MERCURY AIRCRAFT INC","insp_carrier_street":"8126 COUNTY ROUTE 88","insp_carrier_city":"HAMMONDSPORT","insp_carrier_state":"NY","insp_carrier_zip_code":"14840","insp_colonia":null,"docket_number":"426218","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:43:11.000000Z","updated_at":"2025-03-17T19:43:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6539510,"change_date":"2023-09-27 21:41:00","inspection_id":"79767672","insp_unit_id":"197263695","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"215","insp_unit_license":"76771ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV0F4S58614","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:52.000000Z","updated_at":"2025-03-17T22:54:52.000000Z"}]},{"id":3669329,"change_date":"2023-08-04 21:40:00","inspection_id":"79324149","dot_number":"157894","report_state":"NY","report_number":"SPE0311083","insp_date":"2023-07-26 00:00:00","insp_start_time":"1255","insp_end_time":"1314","registration_date":null,"region":"ET","ci_status_code":"C","location":"40354A","location_desc":"GROVELAND (NB)","county_code_state":"NY","county_code":"051","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SCHLEGEL ELECTRONIC MATERIALS INC","shipping_paper_number":"27663","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-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"2855482","transaction_code":"A","transaction_date":"2023-07-26 00:00:00","upload_date":"2023-08-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00157894","upload_search_indicator":null,"census_search_date":"2023-08-04 21:40:00","snet_input_date":"2023-08-04 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-08-04 21:40:00","insp_carrier_name":"MERCURY AIRCRAFT INC","insp_carrier_street":"8126 COUNTY ROUTE 88","insp_carrier_city":"HAMMONDSPORT","insp_carrier_state":"NY","insp_carrier_zip_code":"14840","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:35:17.000000Z","updated_at":"2025-03-17T19:35:17.000000Z","inspection_violations":[{"id":5657286,"change_date":"2023-08-04 21:40:00","inspection_id":"79324149","insp_violation_id":"254465104","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196361170","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:12.000000Z","updated_at":"2025-03-17T21:33:12.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":5899226,"change_date":"2023-08-04 21:40:00","inspection_id":"79324149","insp_unit_id":"196361170","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"56015MH","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV0F4S58614","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:35.000000Z","updated_at":"2025-03-17T22:49:35.000000Z"}]},{"id":3148020,"change_date":"2023-05-26 21:39:00","inspection_id":"78737330","dot_number":"157894","report_state":"NY","report_number":"0519001025","insp_date":"2023-05-25 00:00:00","insp_start_time":"1248","insp_end_time":"1300","registration_date":null,"region":"ET","ci_status_code":"C","location":"40714M","location_desc":"RIGA REST AREA (WB)","county_code_state":"NY","county_code":"055","insp_level_id":"3","service_center":"EA","census_source_id":"4","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":"N","pen_cen_match":"I","final_status_date":"2023-05-26 21:39: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":"2829563","transaction_code":"A","transaction_date":"2023-05-25 00:00:00","upload_date":"2023-05-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00157894","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-05-26 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-05-26 21:39:00","insp_carrier_name":"MERCURY AIRCRAFT INC","insp_carrier_street":"8126 COUNTY ROUTE 88","insp_carrier_city":"HAMMONDSPORT","insp_carrier_state":"NY","insp_carrier_zip_code":"14840-9458","insp_colonia":null,"docket_number":"426218","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:25:21.000000Z","updated_at":"2025-03-17T19:25:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5062923,"change_date":"2023-05-26 21:39:00","inspection_id":"78737330","insp_unit_id":"195157457","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"56015MH","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV0F4S58614","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:54.000000Z","updated_at":"2025-03-17T22:42:54.000000Z"}]},{"id":3158658,"change_date":"2023-05-30 21:41:00","inspection_id":"78749357","dot_number":"157894","report_state":"NY","report_number":"SPF0240727","insp_date":"2023-05-23 00:00:00","insp_start_time":"1120","insp_end_time":"1210","registration_date":null,"region":"ET","ci_status_code":"C","location":"60585A","location_desc":"NICHOLS (EB)","county_code_state":"NY","county_code":"107","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MERCURY AIRCRAFT INC.","shipping_paper_number":"55013","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-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","viol_total":"5","oos_total":"0","driver_viol_total":"5","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2830284","transaction_code":"A","transaction_date":"2023-05-30 00:00:00","upload_date":"2023-05-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00157894","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-05-30 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-05-30 21:41:00","insp_carrier_name":"MERCURY AIRCRAFT INC","insp_carrier_street":"8126 COUNTY ROUTE 88","insp_carrier_city":"HAMMONDSPORT","insp_carrier_state":"NY","insp_carrier_zip_code":"14840","insp_colonia":null,"docket_number":"426218","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:25:24.000000Z","updated_at":"2025-03-17T19:25:24.000000Z","inspection_violations":[{"id":4865550,"change_date":"2023-05-30 21:41:00","inspection_id":"78749357","insp_violation_id":"253125389","seq_no":"1","part_no":"395","part_no_section":"8(e)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"1GRRL97","created_at":"2025-03-17T21:29:39.000000Z","updated_at":"2025-03-17T21:29:39.000000Z","normalized_code":"3958E1"},{"id":4865551,"change_date":"2023-05-30 21:41:00","inspection_id":"78749357","insp_violation_id":"253125390","seq_no":"2","part_no":"395","part_no_section":"22(h)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:39.000000Z","updated_at":"2025-03-17T21:29:39.000000Z","normalized_code":"39522H1"},{"id":4865552,"change_date":"2023-05-30 21:41:00","inspection_id":"78749357","insp_violation_id":"253125391","seq_no":"3","part_no":"395","part_no_section":"22(g)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:39.000000Z","updated_at":"2025-03-17T21:29:39.000000Z","normalized_code":"39522G"},{"id":4865553,"change_date":"2023-05-30 21:41:00","inspection_id":"78749357","insp_violation_id":"253125392","seq_no":"4","part_no":"395","part_no_section":"24(c)(2)(iii)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:39.000000Z","updated_at":"2025-03-17T21:29:39.000000Z","normalized_code":"39524C2III"},{"id":4865554,"change_date":"2023-05-30 21:41:00","inspection_id":"78749357","insp_violation_id":"253125393","seq_no":"5","part_no":"395","part_no_section":"30(b)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:39.000000Z","updated_at":"2025-03-17T21:29:39.000000Z","normalized_code":"39530B1"}],"inspection_per_units":[{"id":5079784,"change_date":"2023-05-30 21:41:00","inspection_id":"78749357","insp_unit_id":"195180412","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"115","insp_unit_license":"35001PA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4NC9EH2FN908949","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:01.000000Z","updated_at":"2025-03-17T22:43:01.000000Z"},{"id":5079785,"change_date":"2023-05-30 21:41:00","inspection_id":"78749357","insp_unit_id":"195180413","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"AB11795","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GRAA96232B018102","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:01.000000Z","updated_at":"2025-03-17T22:43:01.000000Z"}]},{"id":2961134,"change_date":"2023-05-04 21:40:00","inspection_id":"78526463","dot_number":"157894","report_state":"NY","report_number":"SPA0275273","insp_date":"2023-05-02 00:00:00","insp_start_time":"1302","insp_end_time":"1317","registration_date":null,"region":"ET","ci_status_code":"C","location":"40644A","location_desc":"PAVILION","county_code_state":"NY","county_code":"037","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":"2023-05-04 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":"2821855","transaction_code":"A","transaction_date":"2023-05-04 00:00:00","upload_date":"2023-05-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00157894","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-05-04 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-05-04 21:40:00","insp_carrier_name":"MERCURY AIRCRAFT INC","insp_carrier_street":"8126 COUNTY ROUTE 88","insp_carrier_city":"HAMMONDSPORT","insp_carrier_state":"NY","insp_carrier_zip_code":"14840","insp_colonia":null,"docket_number":"426218","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:21:49.000000Z","updated_at":"2025-03-17T19:21:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4764467,"change_date":"2023-05-04 21:40:00","inspection_id":"78526463","insp_unit_id":"194740764","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"56015MH","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV0F4S58614","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:33.000000Z","updated_at":"2025-03-17T22:40:33.000000Z"}]},{"id":2682086,"change_date":"2023-03-29 21:41:00","inspection_id":"78209222","dot_number":"157894","report_state":"NY","report_number":"SPE0310648","insp_date":"2023-03-23 00:00:00","insp_start_time":"1142","insp_end_time":"1157","registration_date":null,"region":"ET","ci_status_code":"C","location":"40354A","location_desc":"GROVELAND (NB)","county_code_state":"NY","county_code":"051","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MERCURY","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-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2811005","transaction_code":"A","transaction_date":"2023-03-29 00:00:00","upload_date":"2023-03-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00157894","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-03-29 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-03-29 21:41:00","insp_carrier_name":"MERCURY AIRCRAFT INC","insp_carrier_street":"8126 COUNTY ROUTE 88","insp_carrier_city":"HAMMONDSPORT","insp_carrier_state":"NY","insp_carrier_zip_code":"14840","insp_colonia":null,"docket_number":"426218","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:16:11.000000Z","updated_at":"2025-03-17T19:16:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4318266,"change_date":"2023-03-29 21:41:00","inspection_id":"78209222","insp_unit_id":"194111594","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"56015MH","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV0F4S58614","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:01.000000Z","updated_at":"2025-03-17T22:37:01.000000Z"}]},{"id":2292422,"change_date":"2023-02-03 21:40:00","inspection_id":"77766180","dot_number":"157894","report_state":"NY","report_number":"SPG0214098","insp_date":"2023-01-31 00:00:00","insp_start_time":"0715","insp_end_time":"0731","registration_date":null,"region":"ET","ci_status_code":"C","location":"60117A","location_desc":"CAMPBELL (EB)","county_code_state":"NY","county_code":"101","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MERCURY AIRCRAFT 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-02-03 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":"2795429","transaction_code":"A","transaction_date":"2023-02-03 00:00:00","upload_date":"2023-02-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00157894","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-02-03 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-02-03 21:40:00","insp_carrier_name":"MERCURY AIRCRAFT INC","insp_carrier_street":"8126 COUNTY ROUTE 88","insp_carrier_city":"HAMMONDSPORT","insp_carrier_state":"NY","insp_carrier_zip_code":"14840","insp_colonia":null,"docket_number":"426218","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:53.000000Z","updated_at":"2025-03-17T19:08:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3689294,"change_date":"2023-02-03 21:40:00","inspection_id":"77766180","insp_unit_id":"193214728","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"56015MH","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV0F4S58614","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:25.000000Z","updated_at":"2025-03-17T22:32:25.000000Z"}]},{"id":1738653,"change_date":"2022-11-15 21:39:00","inspection_id":"77132729","dot_number":"157894","report_state":"NY","report_number":"0509015586","insp_date":"2022-11-10 00:00:00","insp_start_time":"0936","insp_end_time":"0948","registration_date":null,"region":"ET","ci_status_code":"C","location":"40354M","location_desc":"GROVELAND REST AREA (NB)","county_code_state":"NY","county_code":"051","insp_level_id":"1","service_center":"EA","census_source_id":"4","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":"N","pen_cen_match":"I","final_status_date":"2022-11-15 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"2768066","transaction_code":"A","transaction_date":"2022-11-15 00:00:00","upload_date":"2022-11-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00157894","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-11-15 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-11-15 21:39:00","insp_carrier_name":"MERCURY CORPORATION","insp_carrier_street":"8126 COUNTY ROUTE 88","insp_carrier_city":"HAMMONDSPORT","insp_carrier_state":"NY","insp_carrier_zip_code":"14840","insp_colonia":null,"docket_number":"426218","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:36.000000Z","updated_at":"2025-03-17T18:58:36.000000Z","inspection_violations":[{"id":2722785,"change_date":"2022-11-15 21:39:00","inspection_id":"77132729","insp_violation_id":"249595717","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191952139","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:51.000000Z","updated_at":"2025-03-17T21:19:51.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":2797270,"change_date":"2022-11-15 21:39:00","inspection_id":"77132729","insp_unit_id":"191952139","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"215","insp_unit_license":"56015MH","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV0F4S58614","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:09.000000Z","updated_at":"2025-03-17T22:26:09.000000Z"}]},{"id":1674170,"change_date":"2022-11-04 21:37:00","inspection_id":"77058819","dot_number":"157894","report_state":"NY","report_number":"0518000749","insp_date":"2022-11-03 00:00:00","insp_start_time":"1324","insp_end_time":"1403","registration_date":null,"region":"ET","ci_status_code":"C","location":"40354M","location_desc":"GROVELAND REST AREA (SB)","county_code_state":"NY","county_code":"051","insp_level_id":"1","service_center":"EA","census_source_id":"4","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":"N","pen_cen_match":"I","final_status_date":"2022-11-04 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"2766338","transaction_code":"A","transaction_date":"2022-11-04 00:00:00","upload_date":"2022-11-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00157894","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-11-04 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-11-04 21:37:00","insp_carrier_name":"MERCURY CORPORATION","insp_carrier_street":"8126 COUNTY ROUTE 88","insp_carrier_city":"HAMMONDSPORT","insp_carrier_state":"NY","insp_carrier_zip_code":"14840","insp_colonia":null,"docket_number":"426218","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:57:27.000000Z","updated_at":"2025-03-17T18:57:27.000000Z","inspection_violations":[{"id":2625847,"change_date":"2022-11-04 21:37:00","inspection_id":"77058819","insp_violation_id":"249436746","seq_no":"1","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"191808161","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:23.000000Z","updated_at":"2025-03-17T21:19:23.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":2693073,"change_date":"2022-11-04 21:37:00","inspection_id":"77058819","insp_unit_id":"191808161","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"215","insp_unit_license":"56015MH","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV0F4S58614","insp_unit_decal":"Y","insp_unit_decal_number":"32006701","created_at":"2025-03-17T22:25:27.000000Z","updated_at":"2025-03-17T22:25:27.000000Z"}]},{"id":1443445,"change_date":"2022-10-05 21:40:00","inspection_id":"76792818","dot_number":"157894","report_state":"NY","report_number":"SPE0293013","insp_date":"2022-10-04 00:00:00","insp_start_time":"1200","insp_end_time":"1233","registration_date":null,"region":"ET","ci_status_code":"C","location":"60117A","location_desc":"CAMPBELL (EB)","county_code_state":"NY","county_code":"101","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"COLUMBIA TECH","shipping_paper_number":"54594","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-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"3","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2756099","transaction_code":"A","transaction_date":"2022-10-05 00:00:00","upload_date":"2022-10-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00157894","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-10-05 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-10-05 21:40:00","insp_carrier_name":"MERCURY AIRCRAFT INC","insp_carrier_street":"8126 COUNTY ROUTE 88","insp_carrier_city":"HAMMONDSPORT","insp_carrier_state":"NY","insp_carrier_zip_code":"14840","insp_colonia":null,"docket_number":"426218","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:53:23.000000Z","updated_at":"2025-03-17T18:53:23.000000Z","inspection_violations":[{"id":2273662,"change_date":"2022-10-05 21:40:00","inspection_id":"76792818","insp_violation_id":"248837218","seq_no":"1","part_no":"395","part_no_section":"22(h)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:24.000000Z","updated_at":"2025-03-17T21:17:24.000000Z","normalized_code":"39522H1"},{"id":2273663,"change_date":"2022-10-05 21:40:00","inspection_id":"76792818","insp_violation_id":"248837219","seq_no":"2","part_no":"395","part_no_section":"22(h)(4)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:24.000000Z","updated_at":"2025-03-17T21:17:24.000000Z","normalized_code":"39522H4"},{"id":2273664,"change_date":"2022-10-05 21:40:00","inspection_id":"76792818","insp_violation_id":"248837220","seq_no":"3","part_no":"395","part_no_section":"3(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:24.000000Z","updated_at":"2025-03-17T21:17:24.000000Z","normalized_code":"3953A2"}],"inspection_per_units":[{"id":2323549,"change_date":"2022-10-05 21:40:00","inspection_id":"76792818","insp_unit_id":"191273899","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"115","insp_unit_license":"35001PA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4NC9EH2FN908949","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:54.000000Z","updated_at":"2025-03-17T22:22:54.000000Z"},{"id":2323550,"change_date":"2022-10-05 21:40:00","inspection_id":"76792818","insp_unit_id":"191273900","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"021","insp_unit_license":"AB11794","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GRAA96212B018101","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:54.000000Z","updated_at":"2025-03-17T22:22:54.000000Z"}]},{"id":1310985,"change_date":"2022-09-19 21:39:00","inspection_id":"76639358","dot_number":"157894","report_state":"NY","report_number":"SPG0223653","insp_date":"2022-09-14 00:00:00","insp_start_time":"0907","insp_end_time":"0924","registration_date":null,"region":"ET","ci_status_code":"C","location":"40354A","location_desc":"GROVELAND (NB)","county_code_state":"NY","county_code":"051","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-09-19 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"2750230","transaction_code":"A","transaction_date":"2022-09-19 00:00:00","upload_date":"2022-09-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00157894","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-09-19 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-09-19 21:39:00","insp_carrier_name":"MERCURY AIRCRAFT INC","insp_carrier_street":"8126 COUNTY ROUTE 88","insp_carrier_city":"HAMMONDSPORT","insp_carrier_state":"NY","insp_carrier_zip_code":"14840","insp_colonia":null,"docket_number":"426218","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:50:51.000000Z","updated_at":"2025-03-17T18:50:51.000000Z","inspection_violations":[{"id":2076067,"change_date":"2022-09-19 21:39:00","inspection_id":"76639358","insp_violation_id":"248490819","seq_no":"1","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"190962432","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:29.000000Z","updated_at":"2025-03-17T21:16:29.000000Z","normalized_code":"39345"}],"inspection_per_units":[{"id":2110295,"change_date":"2022-09-19 21:39:00","inspection_id":"76639358","insp_unit_id":"190962432","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"56015MH","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV0F4S58614","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:29.000000Z","updated_at":"2025-03-17T22:21:29.000000Z"}]},{"id":1023350,"change_date":"2022-08-12 21:39:00","inspection_id":"76304646","dot_number":"157894","report_state":"NY","report_number":"0518000542","insp_date":"2022-08-11 00:00:00","insp_start_time":"1044","insp_end_time":"1115","registration_date":null,"region":"ET","ci_status_code":"C","location":"40354M","location_desc":"GROVELAND REST AREA (SB)","county_code_state":"NY","county_code":"051","insp_level_id":"1","service_center":"EA","census_source_id":"4","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":"N","pen_cen_match":"I","final_status_date":"2022-08-12 21:39: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":"2738068","transaction_code":"A","transaction_date":"2022-08-12 00:00:00","upload_date":"2022-08-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00157894","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-08-12 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-08-12 21:39:00","insp_carrier_name":"MERCURY CORPORATION","insp_carrier_street":"8126 COUNTY ROUTE 88","insp_carrier_city":"HAMMONDSPORT","insp_carrier_state":"NY","insp_carrier_zip_code":"14840","insp_colonia":null,"docket_number":"426218","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:45:47.000000Z","updated_at":"2025-03-17T18:45:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1646438,"change_date":"2022-08-12 21:39:00","inspection_id":"76304646","insp_unit_id":"190275320","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"215","insp_unit_license":"56015MH","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV0F4S58614","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:22.000000Z","updated_at":"2025-03-17T22:18:22.000000Z"}]},{"id":686137,"change_date":"2022-06-24 21:38:00","inspection_id":"75909936","dot_number":"157894","report_state":"NY","report_number":"SPA0257152","insp_date":"2022-06-23 00:00:00","insp_start_time":"0745","insp_end_time":"0810","registration_date":null,"region":"ET","ci_status_code":"C","location":"60117A","location_desc":"CAMPBELL (EB)","county_code_state":"NY","county_code":"101","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MERCURY CORPORATION","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-06-24 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2720142","transaction_code":"A","transaction_date":"2022-06-24 00:00:00","upload_date":"2022-06-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00157894","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-06-24 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-06-24 21:38:00","insp_carrier_name":"MERCURY AIRCRAFT INC","insp_carrier_street":"8126 COUNTY ROUTE 88","insp_carrier_city":"HAMMONDSPORT","insp_carrier_state":"NY","insp_carrier_zip_code":"14840","insp_colonia":null,"docket_number":"426218","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:39:49.000000Z","updated_at":"2025-03-17T18:39:49.000000Z","inspection_violations":[{"id":1080406,"change_date":"2022-06-24 21:38:00","inspection_id":"75909936","insp_violation_id":"246700286","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"189444139","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:06.000000Z","updated_at":"2025-03-17T21:12:06.000000Z","normalized_code":"3922"},{"id":1080407,"change_date":"2022-06-24 21:38:00","inspection_id":"75909936","insp_violation_id":"246700287","seq_no":"2","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"189444139","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:12:06.000000Z","updated_at":"2025-03-17T21:12:06.000000Z","normalized_code":"39345D"}],"inspection_per_units":[{"id":1102237,"change_date":"2022-06-24 21:38:00","inspection_id":"75909936","insp_unit_id":"189444139","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"215","insp_unit_license":"56015MH","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV0F4S58614","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:59.000000Z","updated_at":"2025-03-17T22:14:59.000000Z"}]},{"id":414204,"change_date":"2022-05-18 21:43:00","inspection_id":"75586964","dot_number":"157894","report_state":"NY","report_number":"MC36001077","insp_date":"2022-05-17 00:00:00","insp_start_time":"0930","insp_end_time":"0955","registration_date":null,"region":"ET","ci_status_code":"C","location":"40354M","location_desc":"GROVELAND REST AREA (NB)","county_code_state":"NY","county_code":"051","insp_level_id":"1","service_center":"EA","census_source_id":"4","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":"N","pen_cen_match":"I","final_status_date":"2022-05-18 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"2706962","transaction_code":"A","transaction_date":"2022-05-18 00:00:00","upload_date":"2022-05-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00157894","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-05-18 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-05-18 21:43:00","insp_carrier_name":"MERCURY CORPORATION","insp_carrier_street":"8126 COUNTY ROUTE 88","insp_carrier_city":"HAMMONDSPORT","insp_carrier_state":"NY","insp_carrier_zip_code":"14840","insp_colonia":null,"docket_number":"426218","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:34:49.000000Z","updated_at":"2025-03-17T18:34:49.000000Z","inspection_violations":[{"id":648442,"change_date":"2022-05-18 21:43:00","inspection_id":"75586964","insp_violation_id":"245865437","seq_no":"1","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"188746147","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:03.000000Z","updated_at":"2025-03-17T21:10:03.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":668407,"change_date":"2022-05-18 21:43:00","inspection_id":"75586964","insp_unit_id":"188746147","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"215","insp_unit_license":"56015MH","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV0F4S58614","insp_unit_decal":"Y","insp_unit_decal_number":"31442107","created_at":"2025-03-17T22:12:18.000000Z","updated_at":"2025-03-17T22:12:18.000000Z"}]},{"id":231828,"change_date":"2022-04-22 21:41:00","inspection_id":"75369380","dot_number":"157894","report_state":"NY","report_number":"SPD0214076","insp_date":"2022-04-19 00:00:00","insp_start_time":"0645","insp_end_time":"0715","registration_date":null,"region":"ET","ci_status_code":"C","location":"60056B","location_desc":"BATH (WB)","county_code_state":"NY","county_code":"101","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-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2698350","transaction_code":"A","transaction_date":"2022-04-22 00:00:00","upload_date":"2022-04-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00157894","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-04-22 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-04-22 21:41:00","insp_carrier_name":"MERCURY AIRCRAFT INC","insp_carrier_street":"8126 COUNTY ROUTE 88","insp_carrier_city":"HAMMONDSPORT","insp_carrier_state":"NY","insp_carrier_zip_code":"14840","insp_colonia":null,"docket_number":"426218","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:31:34.000000Z","updated_at":"2025-03-17T18:31:34.000000Z","inspection_violations":[{"id":356421,"change_date":"2022-04-22 21:41:00","inspection_id":"75369380","insp_violation_id":"245314431","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"188288312","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:44.000000Z","updated_at":"2025-03-17T21:08:44.000000Z","normalized_code":"3939A"},{"id":356422,"change_date":"2022-04-22 21:41:00","inspection_id":"75369380","insp_violation_id":"245314432","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"188288312","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:44.000000Z","updated_at":"2025-03-17T21:08:44.000000Z","normalized_code":"3939A"},{"id":356423,"change_date":"2022-04-22 21:41:00","inspection_id":"75369380","insp_violation_id":"245314433","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"188288312","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:44.000000Z","updated_at":"2025-03-17T21:08:44.000000Z","normalized_code":"3939A"},{"id":356424,"change_date":"2022-04-22 21:41:00","inspection_id":"75369380","insp_violation_id":"245314434","seq_no":"4","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"188288312","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"1FC65N0","created_at":"2025-03-17T21:08:44.000000Z","updated_at":"2025-03-17T21:08:44.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":375675,"change_date":"2022-04-22 21:41:00","inspection_id":"75369380","insp_unit_id":"188288311","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"115","insp_unit_license":"35001PA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4NC9EH2FN908949","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:31.000000Z","updated_at":"2025-03-17T22:10:31.000000Z"},{"id":375676,"change_date":"2022-04-22 21:41:00","inspection_id":"75369380","insp_unit_id":"188288312","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"976","insp_unit_license":"AB81679","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GRAA9629VS058303","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:31.000000Z","updated_at":"2025-03-17T22:10:31.000000Z"}]},{"id":24341,"change_date":"2022-03-23 21:31:00","inspection_id":"75114083","dot_number":"157894","report_state":"NY","report_number":"SPE0255559","insp_date":"2022-03-22 00:00:00","insp_start_time":"0914","insp_end_time":"0931","registration_date":null,"region":"ET","ci_status_code":"C","location":"40354A","location_desc":"GROVELAND (NB)","county_code_state":"NY","county_code":"051","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MERCURY AIRCRAFT INC","shipping_paper_number":"54174","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":"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":"2688113","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":"00157894","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-03-23 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-03-23 21:31:00","insp_carrier_name":"MERCURY AIRCRAFT INC","insp_carrier_street":"8126 COUNTY ROUTE 88","insp_carrier_city":"HAMMONDSPORT","insp_carrier_state":"NY","insp_carrier_zip_code":"14840","insp_colonia":null,"docket_number":"426218","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:28:04.000000Z","updated_at":"2025-03-17T18:28:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":39111,"change_date":"2022-03-23 21:31:00","inspection_id":"75114083","insp_unit_id":"187769848","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"215","insp_unit_license":"56015MH","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV0F4S58614","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\/157894\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/157894\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/157894\/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\/157894\/inspections","per_page":100,"prev_page_url":null,"to":54,"total":54}