{"current_page":1,"data":[{"id":11901936,"change_date":"2026-05-22 21:37:00","inspection_id":"87840732","dot_number":"145625","report_state":"CT","report_number":"3010005071","insp_date":"2026-05-13 00:00:00","insp_start_time":"1503","insp_end_time":"1625","registration_date":"2026-05-22 00:00:00","region":"ET","ci_status_code":"C","location":"083S","location_desc":"MIDDLETOWN SCALE","county_code_state":"CT","county_code":"007","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"THE AERO ALL-GAS CO","shipping_paper_number":"53451-00","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-05-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"2","hazmat_oos_total":"0","snet_sequence_id":"772804","transaction_code":"C","transaction_date":"2026-05-13 00:00:00","upload_date":"2026-05-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00145625","upload_search_indicator":null,"census_search_date":"2026-05-14 21:41:00","snet_input_date":"2026-05-13 00:00:00","source_office":"1CTS001","mcmis_add_date":"2026-05-14 21:41:00","insp_carrier_name":"THE AERO ALL-GAS CO","insp_carrier_street":"3150 MAIN ST","insp_carrier_city":"HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-16T13:32:42.000000Z","updated_at":"2026-06-02T09:30:18.000000Z","inspection_violations":[{"id":20702462,"change_date":"2026-05-22 21:37:00","inspection_id":"87840732","insp_violation_id":"274437203","seq_no":"2","part_no":"392","part_no_section":"2-SLLEWG2","insp_viol_unit":"1","insp_unit_id":"213700557","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V138696-0","created_at":"2026-05-16T13:12:20.000000Z","updated_at":"2026-06-02T09:43:19.000000Z","normalized_code":"3922SLLEWG2"},{"id":20702465,"change_date":"2026-05-22 21:37:00","inspection_id":"87840732","insp_violation_id":"274437206","seq_no":"5","part_no":"172","part_no_section":"202A3-HMSPS","insp_viol_unit":"1","insp_unit_id":"213700557","insp_violation_category_id":"31","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-16T13:12:20.000000Z","updated_at":"2026-06-02T09:43:19.000000Z","normalized_code":"172202A3HMSPS"},{"id":20702461,"change_date":"2026-05-22 21:37:00","inspection_id":"87840732","insp_violation_id":"274437202","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA3","insp_viol_unit":"1","insp_unit_id":"213700557","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V138696-0","created_at":"2026-05-16T13:12:20.000000Z","updated_at":"2026-06-02T09:43:19.000000Z","normalized_code":"3922SLLEWA3"},{"id":20702463,"change_date":"2026-05-22 21:37:00","inspection_id":"87840732","insp_violation_id":"274437204","seq_no":"3","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"213700557","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-16T13:12:20.000000Z","updated_at":"2026-06-02T09:43:19.000000Z","normalized_code":"39345B2BAIR"},{"id":20702464,"change_date":"2026-05-22 21:37:00","inspection_id":"87840732","insp_violation_id":"274437205","seq_no":"4","part_no":"172","part_no_section":"202A7-HMSPS","insp_viol_unit":"1","insp_unit_id":"213700557","insp_violation_category_id":"31","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-16T13:12:20.000000Z","updated_at":"2026-06-02T09:43:19.000000Z","normalized_code":"172202A7HMSPS"}],"inspection_per_units":[{"id":20691901,"change_date":"2026-05-22 21:37:00","inspection_id":"87840732","insp_unit_id":"213700557","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"168","insp_unit_license":"77726A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FVAC4FEXRHVG9717","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-16T12:44:35.000000Z","updated_at":"2026-06-02T09:02:03.000000Z"}]},{"id":11725192,"change_date":"2026-05-06 21:40:00","inspection_id":"87652881","dot_number":"145625","report_state":"CT","report_number":"3025006386","insp_date":"2026-04-23 00:00:00","insp_start_time":"0739","insp_end_time":"0804","registration_date":"2026-05-06 00:00:00","region":"ET","ci_status_code":"C","location":"155","location_desc":"WEST HARTFORD","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-23 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"121300","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"771095","transaction_code":"C","transaction_date":"2026-04-23 00:00:00","upload_date":"2026-05-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00145625","upload_search_indicator":null,"census_search_date":"2026-04-23 21:38:00","snet_input_date":"2026-04-23 00:00:00","source_office":"1CTS001","mcmis_add_date":"2026-04-23 21:38:00","insp_carrier_name":"THE AERO ALL-GAS CO","insp_carrier_street":"3150 MAIN ST","insp_carrier_city":"HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:40:22.000000Z","updated_at":"2026-05-16T13:23:31.000000Z","inspection_violations":[{"id":20383730,"change_date":"2026-05-06 21:40:00","inspection_id":"87652881","insp_violation_id":"274069388","seq_no":"2","part_no":"390","part_no_section":"21TC-MC","insp_viol_unit":"1","insp_unit_id":"213398175","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:59:58.000000Z","updated_at":"2026-05-16T12:54:40.000000Z","normalized_code":"39021TCMC"},{"id":20383729,"change_date":"2026-05-06 21:40:00","inspection_id":"87652881","insp_violation_id":"274069387","seq_no":"1","part_no":"392","part_no_section":"2-SLLS4","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:59:58.000000Z","updated_at":"2026-05-16T12:54:40.000000Z","normalized_code":"3922SLLS4"}],"inspection_per_units":[{"id":20402597,"change_date":"2026-05-06 21:40:00","inspection_id":"87652881","insp_unit_id":"213398175","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"160","insp_unit_license":"73773A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3AKJHLDV7PSUK1708","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:18:20.000000Z","updated_at":"2026-05-16T12:30:15.000000Z"},{"id":20402598,"change_date":"2026-05-06 21:40:00","inspection_id":"87652881","insp_unit_id":"213398176","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"MTCI","insp_unit_company":"156","insp_unit_license":"BA50764","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1M9PT9A27LH355339","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:18:20.000000Z","updated_at":"2026-05-16T12:30:15.000000Z"}]},{"id":10630897,"change_date":"2026-01-13 21:38:00","inspection_id":"86771733","dot_number":"145625","report_state":"CT","report_number":"3014004739","insp_date":"2026-01-13 00:00:00","insp_start_time":"1529","insp_end_time":"1616","registration_date":null,"region":"ET","ci_status_code":"C","location":"083S","location_desc":"MIDDLETOWN SCALE","county_code_state":"CT","county_code":"007","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"ALL GAS","shipping_paper_number":"42034-00","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-01-13 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"763261","transaction_code":"A","transaction_date":"2026-01-13 00:00:00","upload_date":"2026-01-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00145625","upload_search_indicator":null,"census_search_date":"2026-01-13 21:38:00","snet_input_date":"2026-01-13 00:00:00","source_office":"1CTS001","mcmis_add_date":"2026-01-13 21:38:00","insp_carrier_name":"THE AERO ALL-GAS CO","insp_carrier_street":"3150 MAIN ST","insp_carrier_city":"HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-16T10:35:48.000000Z","updated_at":"2026-01-24T10:30:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17827660,"change_date":"2026-01-13 21:38:00","inspection_id":"86771733","insp_unit_id":"211040858","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"141","insp_unit_license":"55262A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FVAC4CY9EHFV9857","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-16T10:08:31.000000Z","updated_at":"2026-01-24T10:01:30.000000Z"}]},{"id":10371970,"change_date":"2025-12-08 21:37:00","inspection_id":"86500861","dot_number":"145625","report_state":"CT","report_number":"0102000044","insp_date":"2025-12-08 00:00:00","insp_start_time":"1504","insp_end_time":"1525","registration_date":null,"region":"ET","ci_status_code":"C","location":"083S","location_desc":"MIDDLETOWN SCALE","county_code_state":"CT","county_code":"007","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":"N","pen_cen_match":null,"final_status_date":"2025-12-08 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"760012","transaction_code":"A","transaction_date":"2025-12-08 00:00:00","upload_date":"2025-12-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00145625","upload_search_indicator":null,"census_search_date":"2025-12-08 21:37:00","snet_input_date":"2025-12-08 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-12-08 21:37:00","insp_carrier_name":"THE AERO ALL-GAS CO","insp_carrier_street":"3150 MAIN ST","insp_carrier_city":"HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-11T10:30:18.000000Z","updated_at":"2025-12-12T10:30:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17336516,"change_date":"2025-12-08 21:37:00","inspection_id":"86500861","insp_unit_id":"210461306","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"168","insp_unit_license":"77726A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FVAC4FEXRHVG9717","insp_unit_decal":"Y","insp_unit_decal_number":"35804114","created_at":"2025-12-11T10:00:23.000000Z","updated_at":"2025-12-12T10:00:05.000000Z"}]},{"id":9931593,"change_date":"2025-10-14 21:41:00","inspection_id":"86037525","dot_number":"145625","report_state":"CT","report_number":"3129006285","insp_date":"2025-10-14 00:00:00","insp_start_time":"1315","insp_end_time":"1330","registration_date":null,"region":"ET","ci_status_code":"C","location":"119","location_desc":"ROCKY HILL","county_code_state":"CT","county_code":"003","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":"2025-10-14 21:41: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":"755080","transaction_code":"A","transaction_date":"2025-10-14 00:00:00","upload_date":"2025-10-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00145625","upload_search_indicator":null,"census_search_date":"2025-10-14 21:41:00","snet_input_date":"2025-10-14 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-10-14 21:41:00","insp_carrier_name":"THE AERO ALL-GAS CO","insp_carrier_street":"3150 MAIN ST","insp_carrier_city":"HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-17T10:01:27.000000Z","updated_at":"2025-10-18T10:00:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16483823,"change_date":"2025-10-14 21:41:00","inspection_id":"86037525","insp_unit_id":"209448145","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"AERO10","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FVACXFC0PHUK8639","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-17T09:46:39.000000Z","updated_at":"2025-10-18T09:45:09.000000Z"}]},{"id":9931597,"change_date":"2025-10-14 21:41:00","inspection_id":"86037529","dot_number":"145625","report_state":"CT","report_number":"3070007457","insp_date":"2025-10-14 00:00:00","insp_start_time":"0852","insp_end_time":"0913","registration_date":"2025-10-14 00:00:00","region":"ET","ci_status_code":"C","location":"083S","location_desc":"MIDDLETOWN SCALE","county_code_state":"CT","county_code":"007","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"726439","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"1","hazmat_oos_total":"0","snet_sequence_id":"754999","transaction_code":"A","transaction_date":"2025-10-14 00:00:00","upload_date":"2025-10-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00145625","upload_search_indicator":null,"census_search_date":"2025-10-14 21:41:00","snet_input_date":"2025-10-14 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-10-14 21:41:00","insp_carrier_name":"THE AERO ALL-GAS CO","insp_carrier_street":"3150 MAIN ST","insp_carrier_city":"HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-17T10:01:27.000000Z","updated_at":"2025-10-18T10:00:05.000000Z","inspection_violations":[{"id":16390826,"change_date":"2025-10-14 21:41:00","inspection_id":"86037529","insp_violation_id":"269274989","seq_no":"1","part_no":"172","part_no_section":"328D-HMM","insp_viol_unit":"1","insp_unit_id":"209448150","insp_violation_category_id":"33","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-17T10:17:03.000000Z","updated_at":"2025-10-18T10:15:11.000000Z","normalized_code":"172328DHMM"}],"inspection_per_units":[{"id":16483826,"change_date":"2025-10-14 21:41:00","inspection_id":"86037529","insp_unit_id":"209448150","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"153","insp_unit_license":"AERO","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3ALACXFC0MDMS8044","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-17T09:46:39.000000Z","updated_at":"2025-10-18T09:45:09.000000Z"}]},{"id":9229018,"change_date":"2025-07-29 21:39:00","inspection_id":"85299724","dot_number":"145625","report_state":"CT","report_number":"3132005744","insp_date":"2025-07-24 00:00:00","insp_start_time":"0845","insp_end_time":"0931","registration_date":"2025-07-29 00:00:00","region":"ET","ci_status_code":"C","location":"064","location_desc":"HARTFORD","county_code_state":"CT","county_code":"003","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"THE AERO ALL-GAS CO","shipping_paper_number":"0000024463-00","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"747017","transaction_code":"C","transaction_date":"2025-07-24 00:00:00","upload_date":"2025-07-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00145625","upload_search_indicator":null,"census_search_date":"2025-07-24 21:40:00","snet_input_date":"2025-07-24 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-07-24 21:40:00","insp_carrier_name":"THE AERO ALL-GAS CO","insp_carrier_street":"3150 MAIN ST","insp_carrier_city":"HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-27T10:41:43.000000Z","updated_at":"2025-08-04T10:00:10.000000Z","inspection_violations":[{"id":18462468,"change_date":null,"inspection_id":"85299724","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"45D-BAAL","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39345DBAAL"}],"inspection_per_units":[{"id":18737805,"change_date":null,"inspection_id":"85299724","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"16050A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FVAC4CYXDHFH8136","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8820387,"change_date":"2025-06-05 21:40:00","inspection_id":"84868204","dot_number":"145625","report_state":"CT","report_number":"3132005613","insp_date":"2025-06-05 00:00:00","insp_start_time":"0832","insp_end_time":"0856","registration_date":null,"region":"ET","ci_status_code":"C","location":"064","location_desc":"HARTFORD","county_code_state":"CT","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"BUCKEYE","shipping_paper_number":"0000696441","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"742193","transaction_code":"A","transaction_date":"2025-06-05 00:00:00","upload_date":"2025-06-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00145625","upload_search_indicator":null,"census_search_date":"2025-06-05 21:40:00","snet_input_date":"2025-06-05 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-06-05 21:40:00","insp_carrier_name":"THE AERO ALL-GAS CO","insp_carrier_street":"3150 MAIN ST","insp_carrier_city":"HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-09T10:00:54.000000Z","updated_at":"2025-06-09T10:00:54.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18732181,"change_date":null,"inspection_id":"84868204","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"AERO","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3ALACXFC0MDMS8044","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8694122,"change_date":"2025-05-21 21:41:00","inspection_id":"84734532","dot_number":"145625","report_state":"CT","report_number":"3129005844","insp_date":"2025-05-21 00:00:00","insp_start_time":"0800","insp_end_time":"0845","registration_date":null,"region":"ET","ci_status_code":"C","location":"064","location_desc":"HARTFORD","county_code_state":"CT","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"141","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"740915","transaction_code":"A","transaction_date":"2025-05-21 00:00:00","upload_date":"2025-05-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00145625","upload_search_indicator":null,"census_search_date":"2025-05-21 21:41:00","snet_input_date":"2025-05-21 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-05-21 21:41:00","insp_carrier_name":"THE AERO ALL-GAS CO","insp_carrier_street":"3150 MAIN ST","insp_carrier_city":"HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-24T10:03:26.000000Z","updated_at":"2025-05-25T10:03:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18730657,"change_date":null,"inspection_id":"84734532","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"55262A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FVAC4CY9EHFV9857","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7577448,"change_date":"2025-01-16 21:40:00","inspection_id":"83560086","dot_number":"145625","report_state":"CT","report_number":"3063006906","insp_date":"2025-01-09 00:00:00","insp_start_time":"1045","insp_end_time":"1104","registration_date":"2025-01-16 00:00:00","region":"ET","ci_status_code":"C","location":"040","location_desc":"EAST GRANBY","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"THE AERO ALL-GAS CO","shipping_paper_number":"4426-00","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":"2025-01-09 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"729034","transaction_code":"C","transaction_date":"2025-01-09 00:00:00","upload_date":"2025-01-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00145625","upload_search_indicator":null,"census_search_date":"2025-01-09 21:39:00","snet_input_date":"2025-01-09 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-01-09 21:39:00","insp_carrier_name":"THE AERO ALL-GAS CO","insp_carrier_street":"3150 MAIN ST","insp_carrier_city":"HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:55:19.000000Z","updated_at":"2025-03-17T20:55:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18715810,"change_date":null,"inspection_id":"83560086","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"16050A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FVAC4CYXDHFH8136","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7481585,"change_date":"2025-01-07 21:39:00","inspection_id":"83459475","dot_number":"145625","report_state":"CT","report_number":"3134000785","insp_date":"2024-12-23 00:00:00","insp_start_time":"1324","insp_end_time":"1413","registration_date":"2025-01-07 00:00:00","region":"ET","ci_status_code":"C","location":"083","location_desc":"MIDDLETOWN","county_code_state":"CT","county_code":"007","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"TRANSFLO AT N. HAVEN","shipping_paper_number":"135725-1","cargo_tank":"331","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-23 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"121300","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":"727649","transaction_code":"C","transaction_date":"2024-12-23 00:00:00","upload_date":"2025-01-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00145625","upload_search_indicator":null,"census_search_date":"2024-12-23 21:38:00","snet_input_date":"2024-12-23 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-12-23 21:38:00","insp_carrier_name":"THE AERO ALL-GAS CO","insp_carrier_street":"3150 MAIN ST","insp_carrier_city":"HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:52:17.000000Z","updated_at":"2025-03-17T20:52:17.000000Z","inspection_violations":[{"id":18432341,"change_date":null,"inspection_id":"83459475","insp_violation_id":null,"seq_no":null,"part_no":"396","part_no_section":"3A1-ALBV","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3963A1ALBV"}],"inspection_per_units":[{"id":18714390,"change_date":null,"inspection_id":"83459475","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"73773A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3AKJHLDV7PSUK1708","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18795800,"change_date":null,"inspection_id":"83459475","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"MTCI","insp_unit_company":null,"insp_unit_license":"W11825","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1M9PT9A28BH355073","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7422173,"change_date":"2024-12-18 21:40:00","inspection_id":"83397017","dot_number":"145625","report_state":"CT","report_number":"3014004384","insp_date":"2024-12-16 00:00:00","insp_start_time":"1116","insp_end_time":"1137","registration_date":"2024-12-18 00:00:00","region":"ET","ci_status_code":"C","location":"083S","location_desc":"MIDDLETOWN SCALE","county_code_state":"CT","county_code":"007","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"MOT","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"27380","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":"726734","transaction_code":"C","transaction_date":"2024-12-16 00:00:00","upload_date":"2024-12-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00145625","upload_search_indicator":null,"census_search_date":"2024-12-16 21:39:00","snet_input_date":"2024-12-16 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-12-16 21:39:00","insp_carrier_name":"THE AERO ALL-GAS CO","insp_carrier_street":"3150 MAIN ST","insp_carrier_city":"HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:51:06.000000Z","updated_at":"2025-03-17T20:51:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18635913,"change_date":null,"inspection_id":"83397017","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"AP31248","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FVACXFC1KHKM1600","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7254400,"change_date":"2024-11-22 21:40:00","inspection_id":"83220274","dot_number":"145625","report_state":"CT","report_number":"3129005290","insp_date":"2024-11-22 00:00:00","insp_start_time":"1327","insp_end_time":"1400","registration_date":null,"region":"ET","ci_status_code":"C","location":"064","location_desc":"HARTFORD","county_code_state":"CT","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"PLACSARD","cargo_tank":"331","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"724625","transaction_code":"A","transaction_date":"2024-11-22 00:00:00","upload_date":"2024-11-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00145625","upload_search_indicator":null,"census_search_date":"2024-11-22 21:40:00","snet_input_date":"2024-11-22 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-11-22 21:40:00","insp_carrier_name":"THE AERO ALL-GAS CO","insp_carrier_street":"3150 MAIN ST","insp_carrier_city":"HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:47:18.000000Z","updated_at":"2025-03-17T20:47:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18711282,"change_date":null,"inspection_id":"83220274","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"42289A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FVAC4FE3KHKM1601","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6956394,"change_date":"2024-10-15 21:41:00","inspection_id":"82904433","dot_number":"145625","report_state":"CT","report_number":"3120004877","insp_date":"2024-10-15 00:00:00","insp_start_time":"1046","insp_end_time":"1115","registration_date":null,"region":"ET","ci_status_code":"C","location":"083S","location_desc":"MIDDLETOWN SCALE","county_code_state":"CT","county_code":"007","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"THE AERO ALL-GAS CO","shipping_paper_number":"0000633968","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"720616","transaction_code":"A","transaction_date":"2024-10-15 00:00:00","upload_date":"2024-10-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00145625","upload_search_indicator":null,"census_search_date":"2024-10-15 21:41:00","snet_input_date":"2024-10-15 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-10-15 21:41:00","insp_carrier_name":"THE AERO ALL-GAS CO","insp_carrier_street":"3150 MAIN ST","insp_carrier_city":"HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:41:03.000000Z","updated_at":"2025-03-17T20:41:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18707183,"change_date":null,"inspection_id":"82904433","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"AERO","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3ALACXFC0MDMS8044","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6567512,"change_date":"2024-08-27 21:41:00","inspection_id":"82490471","dot_number":"145625","report_state":"CT","report_number":"3129005076","insp_date":"2024-08-26 00:00:00","insp_start_time":"1458","insp_end_time":"1523","registration_date":null,"region":"ET","ci_status_code":"C","location":"164","location_desc":"WINDSOR","county_code_state":"CT","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRRIER","shipping_paper_number":"PLACARD","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"716517","transaction_code":"A","transaction_date":"2024-08-26 00:00:00","upload_date":"2024-08-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00145625","upload_search_indicator":null,"census_search_date":"2024-08-27 21:41:00","snet_input_date":"2024-08-26 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-08-27 21:41:00","insp_carrier_name":"THE AERO ALL-GAS CO","insp_carrier_street":"3150 MAIN ST","insp_carrier_city":"HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:33:10.000000Z","updated_at":"2025-03-17T20:33:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18624189,"change_date":null,"inspection_id":"82490471","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"16054A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3ALAC4FE6MDMV0260","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6383665,"change_date":"2024-08-05 21:41:00","inspection_id":"82294362","dot_number":"145625","report_state":"CT","report_number":"0997000768","insp_date":"2024-08-05 00:00:00","insp_start_time":"0725","insp_end_time":"0750","registration_date":null,"region":"ET","ci_status_code":"C","location":"155","location_desc":"WEST HARTFORD","county_code_state":"CT","county_code":"003","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"NA","cargo_tank":"331","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","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":"714474","transaction_code":"A","transaction_date":"2024-08-05 00:00:00","upload_date":"2024-08-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00145625","upload_search_indicator":null,"census_search_date":"2024-08-05 21:41:00","snet_input_date":"2024-08-05 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-08-05 21:41:00","insp_carrier_name":"THE AERO ALL-GAS CO","insp_carrier_street":"3150 MAIN ST","insp_carrier_city":"HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:29:28.000000Z","updated_at":"2025-03-17T20:29:28.000000Z","inspection_violations":[{"id":18412904,"change_date":null,"inspection_id":"82294362","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2-SLLS4","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3922SLLS4"}],"inspection_per_units":[{"id":18621729,"change_date":null,"inspection_id":"82294362","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"73772A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FVHC5DV4PHUH0072","insp_unit_decal":null,"insp_unit_decal_number":"34379231","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6088150,"change_date":"2024-06-27 21:40:00","inspection_id":"81977443","dot_number":"145625","report_state":"CT","report_number":"3129005010","insp_date":"2024-06-27 00:00:00","insp_start_time":"0935","insp_end_time":"1015","registration_date":null,"region":"ET","ci_status_code":"C","location":"165","location_desc":"WINDSOR LOCKS","county_code_state":"CT","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"13461408","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"711300","transaction_code":"A","transaction_date":"2024-06-27 00:00:00","upload_date":"2024-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00145625","upload_search_indicator":null,"census_search_date":"2024-06-27 21:40:00","snet_input_date":"2024-06-27 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-06-27 21:40:00","insp_carrier_name":"THE AERO ALL-GAS CO","insp_carrier_street":"3150 MAIN ST","insp_carrier_city":"HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:23:22.000000Z","updated_at":"2025-03-17T20:23:22.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18695389,"change_date":null,"inspection_id":"81977443","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"16050A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FVAC4CYXDHFH8136","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5715690,"change_date":"2024-05-10 21:38:00","inspection_id":"81573818","dot_number":"145625","report_state":"CT","report_number":"3129004875","insp_date":"2024-05-10 00:00:00","insp_start_time":"0945","insp_end_time":"1022","registration_date":null,"region":"ET","ci_status_code":"C","location":"054","location_desc":"GLASTONBURY","county_code_state":"CT","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"LAM\/PLACARD","cargo_tank":"331","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-10 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"707125","transaction_code":"A","transaction_date":"2024-05-10 00:00:00","upload_date":"2024-05-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00145625","upload_search_indicator":null,"census_search_date":"2024-05-10 21:38:00","snet_input_date":"2024-05-10 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-05-10 21:38:00","insp_carrier_name":"THE AERO ALL-GAS CO","insp_carrier_street":"3150 MAIN ST","insp_carrier_city":"HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:15:55.000000Z","updated_at":"2025-03-17T20:15:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18612289,"change_date":null,"inspection_id":"81573818","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRGHT","insp_unit_company":null,"insp_unit_license":"54680A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FVAC4CY5FHGE7334","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5660399,"change_date":"2024-05-03 21:38:00","inspection_id":"81513723","dot_number":"145625","report_state":"CT","report_number":"3132004520","insp_date":"2024-05-03 00:00:00","insp_start_time":"0735","insp_end_time":"0802","registration_date":null,"region":"ET","ci_status_code":"C","location":"148","location_desc":"WALLINGFORD","county_code_state":"CT","county_code":"009","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"THE AERO ALL-GAS CO","shipping_paper_number":"162831","cargo_tank":"331","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-03 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"706520","transaction_code":"A","transaction_date":"2024-05-03 00:00:00","upload_date":"2024-05-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00145625","upload_search_indicator":null,"census_search_date":"2024-05-03 21:38:00","snet_input_date":"2024-05-03 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-05-03 21:38:00","insp_carrier_name":"THE AERO ALL-GAS CO","insp_carrier_street":"3150 MAIN ST","insp_carrier_city":"HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:15:02.000000Z","updated_at":"2025-03-17T20:15:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18689098,"change_date":null,"inspection_id":"81513723","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"54680A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FVAC4CY5FHGE7334","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5364257,"change_date":"2024-04-11 21:40:00","inspection_id":"81190634","dot_number":"145625","report_state":"CT","report_number":"3098002521","insp_date":"2024-03-26 00:00:00","insp_start_time":"1136","insp_end_time":"1200","registration_date":"2024-04-11 00:00:00","region":"ET","ci_status_code":"C","location":"083S","location_desc":"MIDDLETOWN SCALE","county_code_state":"CT","county_code":"007","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"AERO","shipping_paper_number":"0000582516","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"703362","transaction_code":"C","transaction_date":"2024-03-26 00:00:00","upload_date":"2024-04-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00145625","upload_search_indicator":null,"census_search_date":"2024-03-26 21:42:00","snet_input_date":"2024-03-26 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-03-26 21:42:00","insp_carrier_name":"THE AERO ALL-GAS CO","insp_carrier_street":"3150 MAIN ST","insp_carrier_city":"HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:09:02.000000Z","updated_at":"2025-03-17T20:09:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18684951,"change_date":null,"inspection_id":"81190634","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"AERO","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3ALACXFC0MDMS8044","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5291626,"change_date":"2024-03-18 21:37:00","inspection_id":"81111405","dot_number":"145625","report_state":"CT","report_number":"3129004752","insp_date":"2024-03-14 00:00:00","insp_start_time":"1331","insp_end_time":"1445","registration_date":"2024-03-18 00:00:00","region":"ET","ci_status_code":"C","location":"164","location_desc":"WINDSOR","county_code_state":"CT","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"TRIP TIK","cargo_tank":"331","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-15 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"4","oos_total":"4","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"702248","transaction_code":"C","transaction_date":"2024-03-14 00:00:00","upload_date":"2024-03-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00145625","upload_search_indicator":null,"census_search_date":"2024-03-15 21:39:00","snet_input_date":"2024-03-14 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-03-15 21:39:00","insp_carrier_name":"THE AERO ALL-GAS CO","insp_carrier_street":"3150 MAIN ST","insp_carrier_city":"HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:07:30.000000Z","updated_at":"2025-03-17T20:07:30.000000Z","inspection_violations":[{"id":18391283,"change_date":null,"inspection_id":"81111405","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"209(d)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"393209D"},{"id":18391284,"change_date":null,"inspection_id":"81111405","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9BRKLAMP","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3939BRKLAMP"},{"id":18391285,"change_date":null,"inspection_id":"81111405","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3939TS"}],"inspection_per_units":[{"id":18683916,"change_date":null,"inspection_id":"81111405","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"PROPANE","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FVAC4DV7CHBC8995","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5004794,"change_date":"2024-02-08 21:42:00","inspection_id":"80798635","dot_number":"145625","report_state":"MA","report_number":"CJ00001881","insp_date":"2024-02-07 00:00:00","insp_start_time":"0958","insp_end_time":"1022","registration_date":null,"region":"ET","ci_status_code":"C","location":"322H","location_desc":"H-STURBRIDGE","county_code_state":"MA","county_code":"027","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"AERO ALL-GAS CO","shipping_paper_number":"DT473324","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-08 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"27500","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":"484767","transaction_code":"A","transaction_date":"2024-02-08 00:00:00","upload_date":"2024-02-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00145625","upload_search_indicator":"M","census_search_date":"2024-02-08 21:42:00","snet_input_date":"2024-02-07 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-02-08 21:42:00","insp_carrier_name":"THE AERO ALL-GAS CO","insp_carrier_street":"3150 MAIN ST","insp_carrier_city":"HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06120-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:02:00.000000Z","updated_at":"2025-03-17T20:02:00.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18602102,"change_date":null,"inspection_id":"80798635","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"AERO10","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FVACXFC0PHUK8639","insp_unit_decal":null,"insp_unit_decal_number":"33753226","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":4928264,"change_date":"2024-01-30 21:41:00","inspection_id":"80714658","dot_number":"145625","report_state":"MA","report_number":"DO00000173","insp_date":"2024-01-29 00:00:00","insp_start_time":"1020","insp_end_time":"1031","registration_date":null,"region":"ET","ci_status_code":"C","location":"311H","location_desc":"H-SPRINGFIELD","county_code_state":"MA","county_code":"013","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":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"484001","transaction_code":"A","transaction_date":"2024-01-30 00:00:00","upload_date":"2024-01-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00145625","upload_search_indicator":"M","census_search_date":"2024-01-30 21:41:00","snet_input_date":"2024-01-29 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-01-30 21:41:00","insp_carrier_name":"THE AERO ALL-GAS CO","insp_carrier_street":"3150 MAIN ST","insp_carrier_city":"HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06120-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:00:27.000000Z","updated_at":"2025-03-17T20:00:27.000000Z","inspection_violations":[{"id":18384529,"change_date":null,"inspection_id":"80714658","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2-SLLS4","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3922SLLS4"}],"inspection_per_units":[{"id":18678680,"change_date":null,"inspection_id":"80714658","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"AERO10","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"JTJBARBZ6H2143845","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":4468507,"change_date":"2023-11-21 21:39:00","inspection_id":"80211296","dot_number":"145625","report_state":"CT","report_number":"1162001944","insp_date":"2023-11-20 00:00:00","insp_start_time":"1055","insp_end_time":"1111","registration_date":null,"region":"ET","ci_status_code":"C","location":"015","location_desc":"SOUTH OF X26","county_code_state":"CT","county_code":"001","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"VARIOUS","shipping_paper_number":"MUTIPLE","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"692319","transaction_code":"A","transaction_date":"2023-11-20 00:00:00","upload_date":"2023-11-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00145625","upload_search_indicator":null,"census_search_date":"2023-11-21 21:39:00","snet_input_date":"2023-11-20 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-11-21 21:39:00","insp_carrier_name":"THE AERO ALL-GAS CO","insp_carrier_street":"3150 MAIN ST","insp_carrier_city":"HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:51:25.000000Z","updated_at":"2025-03-17T19:51:25.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":4297916,"change_date":"2023-10-27 21:42:00","inspection_id":"80022916","dot_number":"145625","report_state":"CT","report_number":"3119001796","insp_date":"2023-10-26 00:00:00","insp_start_time":"1645","insp_end_time":"1718","registration_date":null,"region":"ET","ci_status_code":"C","location":"083S","location_desc":"MIDDLETOWN SCALE","county_code_state":"CT","county_code":"007","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"10041015","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"689901","transaction_code":"A","transaction_date":"2023-10-26 00:00:00","upload_date":"2023-10-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00145625","upload_search_indicator":null,"census_search_date":"2023-10-27 21:42:00","snet_input_date":"2023-10-26 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-10-27 21:42:00","insp_carrier_name":"THE AERO ALL-GAS CO","insp_carrier_street":"3150 MAIN ST","insp_carrier_city":"HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:47:54.000000Z","updated_at":"2025-03-17T19:47:54.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":4168476,"change_date":"2023-10-13 21:40:00","inspection_id":"79879792","dot_number":"145625","report_state":"CT","report_number":"3120004173","insp_date":"2023-10-10 00:00:00","insp_start_time":"0541","insp_end_time":"0607","registration_date":"2023-10-13 00:00:00","region":"ET","ci_status_code":"C","location":"052","location_desc":"FARMINGTON","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"THE AERO ALL-GAS CO","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"121300","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":"688300","transaction_code":"C","transaction_date":"2023-10-10 00:00:00","upload_date":"2023-10-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00145625","upload_search_indicator":null,"census_search_date":"2023-10-11 21:40:00","snet_input_date":"2023-10-10 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-10-11 21:40:00","insp_carrier_name":"THE AERO ALL-GAS CO","insp_carrier_street":"3150 MAIN ST","insp_carrier_city":"HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:45:28.000000Z","updated_at":"2025-03-17T19:45:28.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3348406,"change_date":"2023-06-26 21:40:00","inspection_id":"78963773","dot_number":"145625","report_state":"CT","report_number":"0511000079","insp_date":"2023-06-23 00:00:00","insp_start_time":"0823","insp_end_time":"0840","registration_date":null,"region":"ET","ci_status_code":"C","location":"155","location_desc":"I-84 WEST HARTFORD","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"ALL GAS\/OMAS PRIDE","shipping_paper_number":"DT457829","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"678294","transaction_code":"C","transaction_date":"2023-06-23 00:00:00","upload_date":"2023-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00145625","upload_search_indicator":null,"census_search_date":"2023-06-23 21:39:00","snet_input_date":"2023-06-23 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-06-23 21:39:00","insp_carrier_name":"THE AERO ALL-GAS CO","insp_carrier_street":"3150 MAIN ST","insp_carrier_city":"HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:29:21.000000Z","updated_at":"2025-03-17T19:29:21.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2949560,"change_date":"2023-07-31 21:40:00","inspection_id":"78513471","dot_number":"145625","report_state":"CT","report_number":"3019004266","insp_date":"2023-05-02 00:00:00","insp_start_time":"1528","insp_end_time":"1551","registration_date":"2023-07-24 00:00:00","region":"ET","ci_status_code":"C","location":"083S","location_desc":"MIDDLETOWN SCALE","county_code_state":"CT","county_code":"007","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"673339","transaction_code":"C","transaction_date":"2023-07-31 00:00:00","upload_date":"2023-07-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00145625","upload_search_indicator":null,"census_search_date":"2023-05-03 21:41:00","snet_input_date":"2023-05-02 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-05-03 21:41:00","insp_carrier_name":"THE AERO ALL-GAS CO","insp_carrier_street":"3150 MAIN ST","insp_carrier_city":"HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:21:23.000000Z","updated_at":"2025-03-17T19:21:23.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2891706,"change_date":"2023-04-26 21:40:00","inspection_id":"78448124","dot_number":"145625","report_state":"CT","report_number":"3061002072","insp_date":"2023-04-25 00:00:00","insp_start_time":"1707","insp_end_time":"1726","registration_date":null,"region":"ET","ci_status_code":"C","location":"083S","location_desc":"MIDDLETOWN SCALE","county_code_state":"CT","county_code":"007","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"ALL GAS","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"672787","transaction_code":"A","transaction_date":"2023-04-25 00:00:00","upload_date":"2023-04-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00145625","upload_search_indicator":null,"census_search_date":"2023-04-26 21:40:00","snet_input_date":"2023-04-25 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-04-26 21:40:00","insp_carrier_name":"THE AERO ALL-GAS CO","insp_carrier_street":"3150 MAIN ST","insp_carrier_city":"HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:20:05.000000Z","updated_at":"2025-03-17T19:20:05.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2835463,"change_date":"2023-04-24 21:40:00","inspection_id":"78384339","dot_number":"145625","report_state":"CT","report_number":"3017001113","insp_date":"2023-04-17 00:00:00","insp_start_time":"1619","insp_end_time":"1645","registration_date":"2023-04-21 00:00:00","region":"ET","ci_status_code":"C","location":"064","location_desc":"HARTFORD","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"672111","transaction_code":"C","transaction_date":"2023-04-17 00:00:00","upload_date":"2023-04-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00145625","upload_search_indicator":null,"census_search_date":"2023-04-19 21:41:00","snet_input_date":"2023-04-17 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-04-19 21:41:00","insp_carrier_name":"THE AERO ALL-GAS CO","insp_carrier_street":"3150 MAIN ST","insp_carrier_city":"HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:18:56.000000Z","updated_at":"2025-03-17T19:18:56.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2162031,"change_date":"2023-01-30 21:42:00","inspection_id":"77617828","dot_number":"145625","report_state":"CT","report_number":"0132000691","insp_date":"2023-01-18 00:00:00","insp_start_time":"0955","insp_end_time":"1028","registration_date":"2023-01-30 00:00:00","region":"ET","ci_status_code":"C","location":"061","location_desc":"HADDAM","county_code_state":"CT","county_code":"007","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"MULTI","cargo_tank":"331","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"1","hazmat_oos_total":"0","snet_sequence_id":"664060","transaction_code":"C","transaction_date":"2023-01-18 00:00:00","upload_date":"2023-01-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00145625","upload_search_indicator":null,"census_search_date":"2023-01-18 21:39:00","snet_input_date":"2023-01-18 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-01-18 21:39:00","insp_carrier_name":"THE AERO ALL-GAS CO","insp_carrier_street":"3150 MAIN ST","insp_carrier_city":"HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:06:34.000000Z","updated_at":"2025-03-17T19:06:34.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2050132,"change_date":"2023-01-05 21:39:00","inspection_id":"77489140","dot_number":"145625","report_state":"CT","report_number":"3132003471","insp_date":"2023-01-03 00:00:00","insp_start_time":"0842","insp_end_time":"0853","registration_date":null,"region":"ET","ci_status_code":"C","location":"064","location_desc":"HARTFORD","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"THE AERO ALL-GAS CO","shipping_paper_number":"DT445647","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"662427","transaction_code":"C","transaction_date":"2023-01-03 00:00:00","upload_date":"2023-01-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00145625","upload_search_indicator":null,"census_search_date":"2023-01-03 21:40:00","snet_input_date":"2023-01-03 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-01-03 21:40:00","insp_carrier_name":"THE AERO ALL-GAS CO","insp_carrier_street":"3150 MAIN ST","insp_carrier_city":"HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:04:23.000000Z","updated_at":"2025-03-17T19:04:23.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":1968542,"change_date":"2022-12-19 21:40:00","inspection_id":"77396205","dot_number":"145625","report_state":"CT","report_number":"3070004091","insp_date":"2022-12-19 00:00:00","insp_start_time":"1500","insp_end_time":"1512","registration_date":null,"region":"ET","ci_status_code":"C","location":"131","location_desc":"SOUTHINGTON","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"0","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"661497","transaction_code":"A","transaction_date":"2022-12-19 00:00:00","upload_date":"2022-12-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00145625","upload_search_indicator":null,"census_search_date":"2022-12-19 21:40:00","snet_input_date":"2022-12-19 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-12-19 21:40:00","insp_carrier_name":"THE AERO ALL-GAS CO","insp_carrier_street":"3150 MAIN ST","insp_carrier_city":"HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:02:56.000000Z","updated_at":"2025-03-17T19:02:56.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":901170,"change_date":"2022-07-27 21:40:00","inspection_id":"76161604","dot_number":"145625","report_state":"CT","report_number":"LC00400119","insp_date":"2022-07-27 00:00:00","insp_start_time":"0916","insp_end_time":"1016","registration_date":null,"region":"ET","ci_status_code":"C","location":"004","location_desc":"AVON","county_code_state":"CT","county_code":"003","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"251960","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-07-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","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":"649931","transaction_code":"A","transaction_date":"2022-07-27 00:00:00","upload_date":"2022-07-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00145625","upload_search_indicator":null,"census_search_date":"2022-07-27 21:40:00","snet_input_date":"2022-07-27 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-07-27 21:40:00","insp_carrier_name":"THE AERO ALL-GAS CO","insp_carrier_street":"3150 MAIN ST","insp_carrier_city":"HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:43:40.000000Z","updated_at":"2025-03-17T18:43:40.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":536286,"change_date":"2022-06-03 21:39:00","inspection_id":"75732517","dot_number":"145625","report_state":"CT","report_number":"3019003556","insp_date":"2022-06-03 00:00:00","insp_start_time":"1442","insp_end_time":"1450","registration_date":null,"region":"ET","ci_status_code":"C","location":"052","location_desc":"FARMINGTON","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"645724","transaction_code":"A","transaction_date":"2022-06-03 00:00:00","upload_date":"2022-06-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00145625","upload_search_indicator":null,"census_search_date":"2022-06-03 21:39:00","snet_input_date":"2022-06-03 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-06-03 21:39:00","insp_carrier_name":"THE AERO ALL-GAS CO","insp_carrier_street":"3150 MAIN ST","insp_carrier_city":"HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:37:05.000000Z","updated_at":"2025-03-17T18:37:05.000000Z","inspection_violations":[],"inspection_per_units":[]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/145625\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/145625\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/145625\/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\/145625\/inspections","per_page":100,"prev_page_url":null,"to":35,"total":35}