{"current_page":1,"data":[{"id":12190525,"change_date":"2026-06-15 21:41:00","inspection_id":"88146448","dot_number":"180749","report_state":"IA","report_number":"450C000036","insp_date":"2026-06-15 00:00:00","insp_start_time":"1044","insp_end_time":"1102","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"IA","county_code_state":"IA","county_code":"039","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MCCONNELL & ASSOCIATES CORPORATION","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"16720","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":"3546922","transaction_code":"A","transaction_date":"2026-06-15 00:00:00","upload_date":"2026-06-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00180749","upload_search_indicator":null,"census_search_date":"2026-06-15 21:41:00","snet_input_date":"2026-06-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-15 21:41:00","insp_carrier_name":"MCCONNELL & ASSOCIATES CORPORATION","insp_carrier_street":"1225 IRON","insp_carrier_city":"NORTH KANSAS CITY","insp_carrier_state":"MO","insp_carrier_zip_code":"64116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-18T09:40:59.000000Z","updated_at":"2026-06-26T09:30:56.000000Z","inspection_violations":[{"id":21215905,"change_date":"2026-06-15 21:41:00","inspection_id":"88146448","insp_violation_id":"274916298","seq_no":"1","part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-18T10:00:53.000000Z","updated_at":"2026-06-26T09:42:30.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":21173694,"change_date":"2026-06-15 21:41:00","inspection_id":"88146448","insp_unit_id":"214107263","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"COURIER","insp_unit_company":"1165","insp_unit_license":"34AD2N","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1FD0W5GT1JEB59881","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-18T09:17:49.000000Z","updated_at":"2026-06-26T09:02:06.000000Z"}]},{"id":11857791,"change_date":"2026-05-08 21:38:00","inspection_id":"87794148","dot_number":"180749","report_state":"MO","report_number":"4496002567","insp_date":"2026-05-07 00:00:00","insp_start_time":"1356","insp_end_time":"1422","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"KANSAS CITY MO","county_code_state":"MO","county_code":"047","insp_level_id":"2","service_center":"MW","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":"2026-05-08 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","viol_total":"2","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3286623","transaction_code":"A","transaction_date":"2026-05-08 00:00:00","upload_date":"2026-05-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00180749","upload_search_indicator":null,"census_search_date":"2026-05-08 21:38:00","snet_input_date":"2026-05-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-08 21:38:00","insp_carrier_name":"MCCONNELL & ASSOCIATES CORPORATION","insp_carrier_street":"1225 IRON","insp_carrier_city":"NORTH KANSAS CITY","insp_carrier_state":"MO","insp_carrier_zip_code":"64116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-11T09:40:01.000000Z","updated_at":"2026-05-19T09:30:53.000000Z","inspection_violations":[{"id":20624391,"change_date":"2026-05-08 21:38:00","inspection_id":"87794148","insp_violation_id":"274131486","seq_no":"1","part_no":"393","part_no_section":"100B-C","insp_viol_unit":"1","insp_unit_id":"213448385","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-05-11T10:00:02.000000Z","updated_at":"2026-05-19T09:42:37.000000Z","normalized_code":"393100BC"},{"id":20624392,"change_date":"2026-05-08 21:38:00","inspection_id":"87794148","insp_violation_id":"274131487","seq_no":"2","part_no":"396","part_no_section":"5-HL","insp_viol_unit":"1","insp_unit_id":"213448385","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-05-11T10:00:02.000000Z","updated_at":"2026-05-19T09:42:37.000000Z","normalized_code":"3965HL"}],"inspection_per_units":[{"id":20619897,"change_date":"2026-05-08 21:38:00","inspection_id":"87794148","insp_unit_id":"213448385","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"11107","insp_unit_license":"68AM2N","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"2NPRLD0X97M699475","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-11T09:16:24.000000Z","updated_at":"2026-05-19T09:03:15.000000Z"}]},{"id":11461177,"change_date":"2026-03-24 21:39:00","inspection_id":"87379166","dot_number":"180749","report_state":"KS","report_number":"0070000020","insp_date":"2026-03-23 00:00:00","insp_start_time":"0708","insp_end_time":"0725","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"OLATHE KS","county_code_state":"KS","county_code":"091","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"EMPTY","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-03-24 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"68000","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":"3057131","transaction_code":"A","transaction_date":"2026-03-24 00:00:00","upload_date":"2026-03-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00180749","upload_search_indicator":null,"census_search_date":"2026-03-24 21:39:00","snet_input_date":"2026-03-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-24 21:39:00","insp_carrier_name":"MCCONNELL & ASSOCIATES CORPORATION","insp_carrier_street":"1225 IRON","insp_carrier_city":"NORTH KANSAS CITY","insp_carrier_state":"MO","insp_carrier_zip_code":"64116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-27T09:45:13.000000Z","updated_at":"2026-04-04T09:30:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19630384,"change_date":"2026-03-24 21:39:00","inspection_id":"87379166","insp_unit_id":"212301186","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"11208","insp_unit_license":"37KT0B","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3ALMG3CY9HDJF0515","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-27T09:22:55.000000Z","updated_at":"2026-04-04T09:03:47.000000Z"}]},{"id":10608278,"change_date":"2026-01-09 21:38:00","inspection_id":"86748020","dot_number":"180749","report_state":"MO","report_number":"4392002139","insp_date":"2026-01-07 00:00:00","insp_start_time":"1310","insp_end_time":"1330","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"KANSAS CITY MO","county_code_state":"MO","county_code":"095","insp_level_id":"3","service_center":"MW","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":"2026-01-09 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"72350","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":"2744790","transaction_code":"A","transaction_date":"2026-01-09 00:00:00","upload_date":"2026-01-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00180749","upload_search_indicator":null,"census_search_date":"2026-01-09 21:38:00","snet_input_date":"2026-01-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-09 21:38:00","insp_carrier_name":"MCCONNELL & ASSOCIATES CORPORATION","insp_carrier_street":"1225 IRON","insp_carrier_city":"NORTH KANSAS CITY","insp_carrier_state":"MO","insp_carrier_zip_code":"64116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-12T10:34:43.000000Z","updated_at":"2026-01-20T10:30:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17785408,"change_date":"2026-01-09 21:38:00","inspection_id":"86748020","insp_unit_id":"210995061","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"13KN3A","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3ALMG5CY9GDHN0534","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-12T10:11:44.000000Z","updated_at":"2026-01-20T10:00:34.000000Z"}]},{"id":9921674,"change_date":"2025-10-13 21:36:00","inspection_id":"86027165","dot_number":"180749","report_state":"MO","report_number":"4496001944","insp_date":"2025-10-07 00:00:00","insp_start_time":"1059","insp_end_time":"1120","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"KANSAS CITY MO","county_code_state":"MO","county_code":"095","insp_level_id":"2","service_center":"MW","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-10-13 21:36:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"2401169","transaction_code":"A","transaction_date":"2025-10-12 00:00:00","upload_date":"2025-10-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00180749","upload_search_indicator":null,"census_search_date":"2025-10-13 21:36:00","snet_input_date":"2025-10-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-13 21:36:00","insp_carrier_name":"MCCONNELL & ASSOCIATES CORPORATION","insp_carrier_street":"1225 IRON","insp_carrier_city":"NORTH KANSAS CITY","insp_carrier_state":"MO","insp_carrier_zip_code":"64116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-16T10:00:29.000000Z","updated_at":"2025-10-17T10:00:13.000000Z","inspection_violations":[{"id":16372249,"change_date":"2025-10-13 21:36:00","inspection_id":"86027165","insp_violation_id":"269254922","seq_no":"1","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"209429996","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-16T10:15:43.000000Z","updated_at":"2025-10-17T10:15:18.000000Z","normalized_code":"3939ALHLI"},{"id":16372250,"change_date":"2025-10-13 21:36:00","inspection_id":"86027165","insp_violation_id":"269254923","seq_no":"2","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"209429996","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-16T10:15:43.000000Z","updated_at":"2025-10-17T10:15:18.000000Z","normalized_code":"3939ALIL"},{"id":16372251,"change_date":"2025-10-13 21:36:00","inspection_id":"86027165","insp_violation_id":"269254924","seq_no":"3","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"1","insp_unit_id":"209429996","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-16T10:15:43.000000Z","updated_at":"2025-10-17T10:15:18.000000Z","normalized_code":"3939ALRLI"}],"inspection_per_units":[{"id":16466642,"change_date":"2025-10-13 21:36:00","inspection_id":"86027165","insp_unit_id":"209429996","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"11107","insp_unit_license":"68AM2N","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"2NPRLD0X97M699475","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-16T09:45:39.000000Z","updated_at":"2025-10-17T09:45:15.000000Z"}]},{"id":9716529,"change_date":"2025-09-18 21:42:00","inspection_id":"85812148","dot_number":"180749","report_state":"MO","report_number":"4859000541","insp_date":"2025-09-13 00:00:00","insp_start_time":"1300","insp_end_time":"1318","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"KANSAS CITY MO","county_code_state":"MO","county_code":"047","insp_level_id":"3","service_center":"MW","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-09-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"2295396","transaction_code":"A","transaction_date":"2025-09-18 00:00:00","upload_date":"2025-09-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00180749","upload_search_indicator":null,"census_search_date":"2025-09-18 21:42:00","snet_input_date":"2025-09-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-18 21:42:00","insp_carrier_name":"MCCONNELL & ASSOCIATES CORPORATION","insp_carrier_street":"1225 IRON","insp_carrier_city":"NORTH KANSAS CITY","insp_carrier_state":"MO","insp_carrier_zip_code":"64116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-23T10:02:20.000000Z","updated_at":"2025-09-23T10:02:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16089268,"change_date":"2025-09-18 21:42:00","inspection_id":"85812148","insp_unit_id":"209022047","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"11107","insp_unit_license":"68AM2N","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"2NPRLD0X97M699475","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-21T09:45:54.000000Z","updated_at":"2025-09-22T09:46:03.000000Z"}]},{"id":9626942,"change_date":"2025-09-09 21:39:00","inspection_id":"85717796","dot_number":"180749","report_state":"MO","report_number":"0399000310","insp_date":"2025-09-03 00:00:00","insp_start_time":"0957","insp_end_time":"1008","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"KANSAS CITY MO","county_code_state":"MO","county_code":"095","insp_level_id":"3","service_center":"MW","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-09-09 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"2238449","transaction_code":"A","transaction_date":"2025-09-08 00:00:00","upload_date":"2025-09-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00180749","upload_search_indicator":null,"census_search_date":"2025-09-09 21:39:00","snet_input_date":"2025-09-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-09 21:39:00","insp_carrier_name":"MCCONNELL & ASSOCIATES CORPORATION","insp_carrier_street":"1225 IRON","insp_carrier_city":"NORTH KANSAS CITY","insp_carrier_state":"MO","insp_carrier_zip_code":"64116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-11T10:46:54.000000Z","updated_at":"2025-09-13T10:46:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15901362,"change_date":"2025-09-09 21:39:00","inspection_id":"85717796","insp_unit_id":"208816694","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"14AM8P","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"2NPLLZ0X26M660034","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-12T10:47:40.000000Z","updated_at":"2025-09-13T09:58:57.000000Z"}]},{"id":9567393,"change_date":"2025-09-02 21:39:00","inspection_id":"85655950","dot_number":"180749","report_state":"KS","report_number":"HP03370235","insp_date":"2025-08-29 00:00:00","insp_start_time":"0915","insp_end_time":"0935","registration_date":null,"region":"CT","ci_status_code":"C","location":"WY","location_desc":"WYANDOTTE COUNTY - 209","county_code_state":"KS","county_code":"209","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MCCONNELL AND ASSOCIATE","shipping_paper_number":"1540472","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-09-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"72350","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":"1373121","transaction_code":"A","transaction_date":"2025-08-29 00:00:00","upload_date":"2025-09-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00180749","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-08-29 00:00:00","source_office":"3KSS001","mcmis_add_date":"2025-09-02 21:39:00","insp_carrier_name":"MCCONNELL & ASSOCIATES CORPORATION","insp_carrier_street":"1225 IRON","insp_carrier_city":"NORTH KANSAS CITY","insp_carrier_state":"MO","insp_carrier_zip_code":"64116","insp_colonia":null,"docket_number":"329285","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-06T10:43:03.000000Z","updated_at":"2025-09-06T10:43:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15792496,"change_date":"2025-09-02 21:39:00","inspection_id":"85655950","insp_unit_id":"208699094","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"11248","insp_unit_license":"13KN3A","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3ALMG5CY9GDHN0534","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:47:16.000000Z","updated_at":"2025-09-09T09:47:16.000000Z"}]},{"id":9447958,"change_date":"2025-08-19 21:40:00","inspection_id":"85529977","dot_number":"180749","report_state":"MO","report_number":"W172004450","insp_date":"2025-08-19 00:00:00","insp_start_time":"0751","insp_end_time":"0807","registration_date":null,"region":"CD","ci_status_code":"C","location":"I-29","location_desc":"PLATTE CITY MO","county_code_state":"MO","county_code":"165","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-08-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"124920","viol_total":"2","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":"2149209","transaction_code":"A","transaction_date":"2025-08-19 00:00:00","upload_date":"2025-08-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00180749","upload_search_indicator":null,"census_search_date":"2025-08-19 21:40:00","snet_input_date":"2025-08-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-19 21:40:00","insp_carrier_name":"MCCONNELL & ASSOCIATES CORPORATION","insp_carrier_street":"1225 IRON","insp_carrier_city":"NORTH KANSAS CITY","insp_carrier_state":"MO","insp_carrier_zip_code":"64116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-23T10:46:23.000000Z","updated_at":"2025-08-23T10:46:23.000000Z","inspection_violations":[{"id":15385973,"change_date":"2025-08-19 21:40:00","inspection_id":"85529977","insp_violation_id":"268112692","seq_no":"1","part_no":"393","part_no_section":"9A-HLLH","insp_viol_unit":"1","insp_unit_id":"208466836","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-22T10:44:54.000000Z","updated_at":"2025-08-23T10:47:59.000000Z","normalized_code":"3939AHLLH"},{"id":15385974,"change_date":"2025-08-19 21:40:00","inspection_id":"85529977","insp_violation_id":"268112693","seq_no":"2","part_no":"393","part_no_section":"9A-LSLIWR","insp_viol_unit":"2","insp_unit_id":"208466837","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-08-22T10:44:54.000000Z","updated_at":"2025-08-23T10:47:59.000000Z","normalized_code":"3939ALSLIWR"}],"inspection_per_units":[{"id":15579127,"change_date":"2025-08-19 21:40:00","inspection_id":"85529977","insp_unit_id":"208466836","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"91KT8E","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1FV4JJCB01HH03545","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-22T09:46:39.000000Z","updated_at":"2025-08-23T09:45:39.000000Z"},{"id":15579128,"change_date":"2025-08-19 21:40:00","inspection_id":"85529977","insp_unit_id":"208466837","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNKNOWN","insp_unit_company":null,"insp_unit_license":"54K4LA","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"5FTCF4021M1001619","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-22T09:46:39.000000Z","updated_at":"2025-08-23T09:45:39.000000Z"}]},{"id":9201652,"change_date":"2025-07-21 21:41:00","inspection_id":"85270868","dot_number":"180749","report_state":"MO","report_number":"W172004412","insp_date":"2025-07-21 00:00:00","insp_start_time":"0726","insp_end_time":"0742","registration_date":null,"region":"CD","ci_status_code":"C","location":"I-29","location_desc":"PLATTE CITY MO","county_code_state":"MO","county_code":"165","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-07-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"43500","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":"2021391","transaction_code":"A","transaction_date":"2025-07-21 00:00:00","upload_date":"2025-07-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00180749","upload_search_indicator":null,"census_search_date":"2025-07-21 21:41:00","snet_input_date":"2025-07-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-21 21:41:00","insp_carrier_name":"MCCONNELL & ASSOCIATES CORPORATION","insp_carrier_street":"1225 IRON","insp_carrier_city":"NORTH KANSAS CITY","insp_carrier_state":"MO","insp_carrier_zip_code":"64116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-25T10:45:27.000000Z","updated_at":"2025-07-25T10:45:27.000000Z","inspection_violations":[{"id":14872872,"change_date":"2025-07-21 21:41:00","inspection_id":"85270868","insp_violation_id":"267532185","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"207979295","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-25T10:46:49.000000Z","updated_at":"2025-07-25T10:46:49.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":15127618,"change_date":"2025-07-21 21:41:00","inspection_id":"85270868","insp_unit_id":"207979295","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"75KG3B","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1FD0W5HT0LEE49918","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-24T09:45:33.000000Z","updated_at":"2025-07-25T09:45:46.000000Z"},{"id":15127619,"change_date":"2025-07-21 21:41:00","inspection_id":"85270868","insp_unit_id":"207979296","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNKNOWN","insp_unit_company":null,"insp_unit_license":"51M1FX","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"46UFU2239R1287175","insp_unit_decal":"Y","insp_unit_decal_number":"35513971","created_at":"2025-07-24T09:45:33.000000Z","updated_at":"2025-07-25T09:45:46.000000Z"}]},{"id":9049506,"change_date":"2025-07-02 21:40:00","inspection_id":"85110714","dot_number":"180749","report_state":"SD","report_number":"5540003624","insp_date":"2025-07-02 00:00:00","insp_start_time":"0550","insp_end_time":"0618","registration_date":null,"region":"CD","ci_status_code":"C","location":"JEFFNB","location_desc":"JEFFERSON SD","county_code_state":"SD","county_code":"127","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"PAVEMENT SPECIALISTS","shipping_paper_number":"2507K14997","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-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1943097","transaction_code":"A","transaction_date":"2025-07-02 00:00:00","upload_date":"2025-07-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00180749","upload_search_indicator":null,"census_search_date":"2025-07-02 21:40:00","snet_input_date":"2025-07-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-02 21:40:00","insp_carrier_name":"MCCONNELL & ASSOCIATES CORPORATION","insp_carrier_street":"1225 IRON","insp_carrier_city":"NORTH KANSAS CITY","insp_carrier_state":"MO","insp_carrier_zip_code":"64116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-07T10:07:21.000000Z","updated_at":"2025-07-07T10:07:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14846877,"change_date":"2025-07-02 21:40:00","inspection_id":"85110714","insp_unit_id":"207675548","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"1105","insp_unit_license":"83AP9M","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"2HSCNSCRX7C432884","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-05T09:46:09.000000Z","updated_at":"2025-07-06T09:45:39.000000Z"},{"id":14846878,"change_date":"2025-07-02 21:40:00","inspection_id":"85110714","insp_unit_id":"207675549","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"REITNOUER","insp_unit_company":"13MT089","insp_unit_license":"TEMP","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1RND53A28DR025747","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-05T09:46:09.000000Z","updated_at":"2025-07-06T09:45:39.000000Z"}]},{"id":8914938,"change_date":"2025-06-17 21:40:00","inspection_id":"84968679","dot_number":"180749","report_state":"SD","report_number":"5540003550","insp_date":"2025-06-16 00:00:00","insp_start_time":"0551","insp_end_time":"0619","registration_date":null,"region":"CD","ci_status_code":"C","location":"JEFFNB","location_desc":"JEFFERSON SD","county_code_state":"SD","county_code":"127","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"PAVEMENT MAINTENANCE PRODUCTS","shipping_paper_number":"2506K13885","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-06-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"1871908","transaction_code":"A","transaction_date":"2025-06-16 00:00:00","upload_date":"2025-06-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00180749","upload_search_indicator":null,"census_search_date":"2025-06-17 21:40:00","snet_input_date":"2025-06-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-17 21:40:00","insp_carrier_name":"MCCONNELL & ASSOCIATES CORPORATION","insp_carrier_street":"1225 IRON","insp_carrier_city":"NORTH KANSAS CITY","insp_carrier_state":"MO","insp_carrier_zip_code":"64116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-20T10:00:47.000000Z","updated_at":"2025-06-22T10:00:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14607518,"change_date":"2025-06-17 21:40:00","inspection_id":"84968679","insp_unit_id":"207417158","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"004","insp_unit_license":"PWK9428","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1M1AN4GYXLM014848","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-20T09:45:59.000000Z","updated_at":"2025-06-22T09:45:11.000000Z"},{"id":14607519,"change_date":"2025-06-17 21:40:00","inspection_id":"84968679","insp_unit_id":"207417159","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"REITNOUER","insp_unit_company":"1364","insp_unit_license":"02L1TA","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1RND51A26BR024002","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-20T09:45:59.000000Z","updated_at":"2025-06-22T09:45:11.000000Z"}]},{"id":8736707,"change_date":"2025-05-26 21:33:00","inspection_id":"84779818","dot_number":"180749","report_state":"SD","report_number":"5610000772","insp_date":"2025-05-23 00:00:00","insp_start_time":"0548","insp_end_time":"0608","registration_date":null,"region":"CD","ci_status_code":"C","location":"JEFFNB","location_desc":"JEFFERSON SD","county_code_state":"SD","county_code":"127","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"PAVEMENT MAINTENANCE PRODUCTS","shipping_paper_number":"2505K12527","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-26 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1782124","transaction_code":"A","transaction_date":"2025-05-26 00:00:00","upload_date":"2025-05-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00180749","upload_search_indicator":null,"census_search_date":"2025-05-26 21:33:00","snet_input_date":"2025-05-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-26 21:33:00","insp_carrier_name":"MCCONNELL & ASSOCIATES CORPORATION","insp_carrier_street":"1225 IRON","insp_carrier_city":"NORTH KANSAS CITY","insp_carrier_state":"MO","insp_carrier_zip_code":"64116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-29T10:00:27.000000Z","updated_at":"2025-05-30T10:00:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14283528,"change_date":"2025-05-26 21:33:00","inspection_id":"84779818","insp_unit_id":"207064409","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"11105","insp_unit_license":"83APSM","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"2HSCNSCRX7C432884","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-29T09:45:32.000000Z","updated_at":"2025-05-30T09:45:19.000000Z"},{"id":14283529,"change_date":"2025-05-26 21:33:00","inspection_id":"84779818","insp_unit_id":"207064410","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":"1367","insp_unit_license":"1109452P","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1TTE5320X41073838","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-29T09:45:32.000000Z","updated_at":"2025-05-30T09:45:19.000000Z"}]},{"id":8673934,"change_date":"2025-05-19 21:40:00","inspection_id":"84713348","dot_number":"180749","report_state":"MO","report_number":"W110000422","insp_date":"2025-05-15 00:00:00","insp_start_time":"0835","insp_end_time":"0851","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"KANSAS CITY MO","county_code_state":"MO","county_code":"095","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-05-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"1749847","transaction_code":"A","transaction_date":"2025-05-19 00:00:00","upload_date":"2025-05-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00180749","upload_search_indicator":null,"census_search_date":"2025-05-19 21:40:00","snet_input_date":"2025-05-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-19 21:40:00","insp_carrier_name":"MCCONNELL & ASSOCIATES CORPORATION","insp_carrier_street":"1225 IRON","insp_carrier_city":"NORTH KANSAS CITY","insp_carrier_state":"MO","insp_carrier_zip_code":"64116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-22T10:01:31.000000Z","updated_at":"2025-05-23T10:04:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14170307,"change_date":"2025-05-19 21:40:00","inspection_id":"84713348","insp_unit_id":"206936761","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"36KT9B","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1FV4JJBBXYHG12746","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-22T09:46:01.000000Z","updated_at":"2025-05-23T09:49:32.000000Z"}]},{"id":8354214,"change_date":"2025-04-11 21:40:00","inspection_id":"84376630","dot_number":"180749","report_state":"KS","report_number":"HP00701611","insp_date":"2025-04-10 00:00:00","insp_start_time":"1100","insp_end_time":"1115","registration_date":null,"region":"CT","ci_status_code":"C","location":"JO","location_desc":"JOHNSON COUNTY - 091","county_code_state":"KS","county_code":"091","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"EMPTY","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"73200","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":"1358405","transaction_code":"A","transaction_date":"2025-04-10 00:00:00","upload_date":"2025-04-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00180749","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-04-10 00:00:00","source_office":"3KSS001","mcmis_add_date":"2025-04-11 21:40:00","insp_carrier_name":"MCCONNELL & ASSOCIATES CORPORATION","insp_carrier_street":"1225 IRON","insp_carrier_city":"NORTH KANSAS CITY","insp_carrier_state":"MO","insp_carrier_zip_code":"64116","insp_colonia":null,"docket_number":"329285","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-14T10:29:43.000000Z","updated_at":"2025-04-15T10:15:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13554920,"change_date":"2025-04-11 21:40:00","inspection_id":"84376630","insp_unit_id":"206270181","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"11222","insp_unit_license":"06KT7S","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1FVMG3FM7NHNE8613","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-14T10:16:43.000000Z","updated_at":"2025-04-15T10:02:37.000000Z"}]},{"id":8365674,"change_date":"2025-04-14 21:40:00","inspection_id":"84388712","dot_number":"180749","report_state":"MO","report_number":"0399000218","insp_date":"2025-04-08 00:00:00","insp_start_time":"0950","insp_end_time":"1020","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"WARRENSBURG MO","county_code_state":"MO","county_code":"101","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-04-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1591692","transaction_code":"A","transaction_date":"2025-04-14 00:00:00","upload_date":"2025-04-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00180749","upload_search_indicator":null,"census_search_date":"2025-04-14 21:40:00","snet_input_date":"2025-04-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-14 21:40:00","insp_carrier_name":"MCCONNELL & ASSOCIATES CORPORATION","insp_carrier_street":"1225 IRON","insp_carrier_city":"NORTH KANSAS CITY","insp_carrier_state":"MO","insp_carrier_zip_code":"64116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-17T10:05:00.000000Z","updated_at":"2025-04-18T10:21:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13575339,"change_date":"2025-04-14 21:40:00","inspection_id":"84388712","insp_unit_id":"206292396","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"02J6HK","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1FD0W5GT0LED98048","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-17T09:51:19.000000Z","updated_at":"2025-04-18T09:52:36.000000Z"}]},{"id":8276583,"change_date":"2025-04-02 21:41:00","inspection_id":"84294963","dot_number":"180749","report_state":"IA","report_number":"000P14W1W1","insp_date":"2025-03-31 00:00:00","insp_start_time":"0918","insp_end_time":"1000","registration_date":null,"region":"CT","ci_status_code":"C","location":"14","location_desc":"14 - I29 NB MM 12 PERCIVAL","county_code_state":"IA","county_code":"071","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MCCONNELL & ASSOCIATES CORPORATION","shipping_paper_number":"MACHINERY","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118140","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1355101","transaction_code":"A","transaction_date":"2025-04-01 00:00:00","upload_date":"2025-04-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00180749","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-03-31 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-04-02 21:41:00","insp_carrier_name":"MCCONNELL & ASSOCIATES CORPORATION","insp_carrier_street":"1225 IRON","insp_carrier_city":"NORTH KANSAS CITY","insp_carrier_state":"MO","insp_carrier_zip_code":"64116","insp_colonia":null,"docket_number":"329285","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-06T10:23:51.000000Z","updated_at":"2025-04-06T10:23:51.000000Z","inspection_violations":[{"id":13007292,"change_date":"2025-04-02 21:41:00","inspection_id":"84294963","insp_violation_id":"265400456","seq_no":"1","part_no":"391","part_no_section":"11B1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"54","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-04-04T11:07:24.000000Z","updated_at":"2025-04-05T10:41:58.000000Z","normalized_code":"39111B1"}],"inspection_per_units":[{"id":13397384,"change_date":"2025-04-02 21:41:00","inspection_id":"84294963","insp_unit_id":"206120785","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"11222","insp_unit_license":"06KT7S","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1FVMG3FM7NHNE8613","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-05T10:12:00.000000Z","updated_at":"2025-04-06T09:59:41.000000Z"},{"id":13397385,"change_date":"2025-04-02 21:41:00","inspection_id":"84294963","insp_unit_id":"206120786","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CUSM","insp_unit_company":"1359","insp_unit_license":"54K4LA","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"5FTCF4021M1001619","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-05T10:12:00.000000Z","updated_at":"2025-04-06T09:59:41.000000Z"}]},{"id":7346546,"change_date":"2025-12-11 21:45:00","inspection_id":"83317543","dot_number":"180749","report_state":"KS","report_number":"HP03017455","insp_date":"2024-12-04 00:00:00","insp_start_time":"0900","insp_end_time":"0920","registration_date":null,"region":"CT","ci_status_code":"C","location":"SH","location_desc":"SHERMAN COUNTY - 181","county_code_state":"KS","county_code":"181","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"NEW CENTURY AIR PORT","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-05 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"22000","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":"1346109","transaction_code":"C","transaction_date":"2025-12-11 00:00:00","upload_date":"2025-12-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00180749","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-12-04 00:00:00","source_office":"3KSS001","mcmis_add_date":"2024-12-05 21:37:00","insp_carrier_name":"MCCONNELL & ASSOCIATES CORPORATION","insp_carrier_street":"1225 IRON","insp_carrier_city":"NORTH KANSAS CITY","insp_carrier_state":"MO","insp_carrier_zip_code":"64116","insp_colonia":null,"docket_number":"329285","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:49:23.000000Z","updated_at":"2025-12-15T10:31:09.000000Z","inspection_violations":[{"id":17449031,"change_date":"2025-12-11 21:45:00","inspection_id":"83317543","insp_violation_id":"270628841","seq_no":"1","part_no":"391","part_no_section":"41A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-14T10:32:38.000000Z","updated_at":"2025-12-15T10:32:27.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":17409205,"change_date":"2025-12-11 21:45:00","inspection_id":"83317543","insp_unit_id":"210559266","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"56K5LA","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"99","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-14T10:02:00.000000Z","updated_at":"2025-12-15T10:01:38.000000Z"},{"id":17409204,"change_date":"2025-12-11 21:45:00","inspection_id":"83317543","insp_unit_id":"210559265","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"11209","insp_unit_license":"13J5JB","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1FD0W5GT6PEC36432","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-14T10:02:00.000000Z","updated_at":"2025-12-15T10:01:38.000000Z"}]},{"id":6823924,"change_date":"2025-07-23 21:41:00","inspection_id":"82763726","dot_number":"180749","report_state":"MO","report_number":"W110000228","insp_date":"2024-09-25 00:00:00","insp_start_time":"0915","insp_end_time":"0936","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"KANSAS CITY MO","county_code_state":"MO","county_code":"095","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-09-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"72000","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":"886977","transaction_code":"C","transaction_date":"2024-09-26 00:00:00","upload_date":"2025-07-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00180749","upload_search_indicator":null,"census_search_date":"2024-09-26 21:40:00","snet_input_date":"2024-09-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-26 21:40:00","insp_carrier_name":"MCCONNELL & ASSOCIATES CORPORATION","insp_carrier_street":"1225 IRON","insp_carrier_city":"NORTH KANSAS CITY","insp_carrier_state":"MO","insp_carrier_zip_code":"64116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:38:34.000000Z","updated_at":"2025-07-27T10:41:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15163558,"change_date":"2025-07-23 21:41:00","inspection_id":"82763726","insp_unit_id":"208029706","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"91KT8E","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1FV4JJCB01HH03545","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-26T09:46:20.000000Z","updated_at":"2025-07-27T09:45:11.000000Z"}]},{"id":6674369,"change_date":"2024-09-09 21:39:00","inspection_id":"82604380","dot_number":"180749","report_state":"MO","report_number":"W110000196","insp_date":"2024-09-03 00:00:00","insp_start_time":"1200","insp_end_time":"1217","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"MAYVIEW MO","county_code_state":"MO","county_code":"107","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-09-09 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"826718","transaction_code":"A","transaction_date":"2024-09-09 00:00:00","upload_date":"2024-09-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00180749","upload_search_indicator":null,"census_search_date":"2024-09-09 21:39:00","snet_input_date":"2024-09-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-09 21:39:00","insp_carrier_name":"MCCONNELL & ASSOCIATES CORPORATION","insp_carrier_street":"1225 IRON","insp_carrier_city":"NORTH KANSAS CITY","insp_carrier_state":"MO","insp_carrier_zip_code":"64116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:35:15.000000Z","updated_at":"2025-03-17T20:35:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10761407,"change_date":"2024-09-09 21:39:00","inspection_id":"82604380","insp_unit_id":"202815125","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"90AR5M","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"2HSCNAPRX6C265381","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:26.000000Z","updated_at":"2025-03-17T23:34:26.000000Z"}]},{"id":6223404,"change_date":"2024-07-16 21:42:00","inspection_id":"82122797","dot_number":"180749","report_state":"SD","report_number":"5410001241","insp_date":"2024-07-16 00:00:00","insp_start_time":"0645","insp_end_time":"0703","registration_date":null,"region":"CD","ci_status_code":"C","location":"JEFFNB","location_desc":"JEFFERSON SD","county_code_state":"SD","county_code":"127","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"PAVEMENT MAINTENCE PRODUCTS","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-07-16 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"655306","transaction_code":"A","transaction_date":"2024-07-16 00:00:00","upload_date":"2024-07-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00180749","upload_search_indicator":null,"census_search_date":"2024-07-16 21:42:00","snet_input_date":"2024-07-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-16 21:42:00","insp_carrier_name":"MCCONNELL & ASSOCIATES CORPORATION","insp_carrier_street":"1225 IRON","insp_carrier_city":"NORTH KANSAS CITY","insp_carrier_state":"MO","insp_carrier_zip_code":"64116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:26:10.000000Z","updated_at":"2025-03-17T20:26:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10027108,"change_date":"2024-07-16 21:42:00","inspection_id":"82122797","insp_unit_id":"201895465","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"11105","insp_unit_license":"83AP9M","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"2HSCNSCRX7C432884","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:54.000000Z","updated_at":"2025-03-17T23:26:54.000000Z"},{"id":10027109,"change_date":"2024-07-16 21:42:00","inspection_id":"82122797","insp_unit_id":"201895466","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":"1335","insp_unit_license":"PX7844","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1TTF48202X1061644","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:54.000000Z","updated_at":"2025-03-17T23:26:54.000000Z"}]},{"id":6172543,"change_date":"2024-07-09 21:42:00","inspection_id":"82068228","dot_number":"180749","report_state":"SD","report_number":"5540001734","insp_date":"2024-07-09 00:00:00","insp_start_time":"0615","insp_end_time":"0720","registration_date":null,"region":"CD","ci_status_code":"C","location":"JEFFNB","location_desc":"JEFFERSON SD","county_code_state":"SD","county_code":"127","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SEAL PROS","shipping_paper_number":"2407K97742","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-07-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"637964","transaction_code":"A","transaction_date":"2024-07-09 00:00:00","upload_date":"2024-07-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00180749","upload_search_indicator":null,"census_search_date":"2024-07-09 21:42:00","snet_input_date":"2024-07-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-09 21:42:00","insp_carrier_name":"MCCONNELL & ASSOCIATES CORPORATION","insp_carrier_street":"1225 IRON","insp_carrier_city":"NORTH KANSAS CITY","insp_carrier_state":"MO","insp_carrier_zip_code":"64116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:25:01.000000Z","updated_at":"2025-03-17T20:25:01.000000Z","inspection_violations":[{"id":9584783,"change_date":"2024-07-09 21:42:00","inspection_id":"82068228","insp_violation_id":"260529581","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201786973","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:52:24.000000Z","updated_at":"2025-03-17T21:52:24.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9943633,"change_date":"2024-07-09 21:42:00","inspection_id":"82068228","insp_unit_id":"201786973","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"11105","insp_unit_license":"83AP9M","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"2HSCNSCRX7C432884","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:02.000000Z","updated_at":"2025-03-17T23:26:02.000000Z"},{"id":9943634,"change_date":"2024-07-09 21:42:00","inspection_id":"82068228","insp_unit_id":"201786974","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRANSCRAFT","insp_unit_company":"1335","insp_unit_license":"PX7844","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1TTF48202X1061644","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:02.000000Z","updated_at":"2025-03-17T23:26:02.000000Z"}]},{"id":4538986,"change_date":"2023-12-12 21:41:00","inspection_id":"80288856","dot_number":"180749","report_state":"KS","report_number":"HP93463250","insp_date":"2023-11-30 00:00:00","insp_start_time":"1141","insp_end_time":"1225","registration_date":"2023-12-12 00:00:00","region":"CT","ci_status_code":"C","location":"#26A","location_desc":"SOUTH HAVEN M.C.I.S. #26A","county_code_state":"KS","county_code":"191","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"M.C.","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-12-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"35500","viol_total":"7","oos_total":"2","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1309618","transaction_code":"C","transaction_date":"2023-11-30 00:00:00","upload_date":"2023-12-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00180749","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-11-30 00:00:00","source_office":"3KSS001","mcmis_add_date":"2023-12-01 21:42:00","insp_carrier_name":"MCCONNELL & ASSOCIATES CORPORATION","insp_carrier_street":"1225 IRON","insp_carrier_city":"NORTH KANSAS CITY","insp_carrier_state":"MO","insp_carrier_zip_code":"64116","insp_colonia":null,"docket_number":"329285","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:52:38.000000Z","updated_at":"2025-03-17T19:52:38.000000Z","inspection_violations":[{"id":7022615,"change_date":"2023-12-12 21:41:00","inspection_id":"80288856","insp_violation_id":"256843739","seq_no":"1","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:39:53.000000Z","updated_at":"2025-03-17T21:39:53.000000Z","normalized_code":"39522G"},{"id":7022616,"change_date":"2023-12-12 21:41:00","inspection_id":"80288856","insp_violation_id":"256843740","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:39:53.000000Z","updated_at":"2025-03-17T21:39:53.000000Z","normalized_code":"39522H4"},{"id":7022617,"change_date":"2023-12-12 21:41:00","inspection_id":"80288856","insp_violation_id":"256843741","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:53.000000Z","updated_at":"2025-03-17T21:39:53.000000Z","normalized_code":"3922"},{"id":7022618,"change_date":"2023-12-12 21:41:00","inspection_id":"80288856","insp_violation_id":"256843742","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198468007","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:53.000000Z","updated_at":"2025-03-17T21:39:53.000000Z","normalized_code":"3922"},{"id":7022619,"change_date":"2023-12-12 21:41:00","inspection_id":"80288856","insp_violation_id":"256843743","seq_no":"5","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"198468007","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:53.000000Z","updated_at":"2025-03-17T21:39:53.000000Z","normalized_code":"39395F"},{"id":7022620,"change_date":"2023-12-12 21:41:00","inspection_id":"80288856","insp_violation_id":"256843744","seq_no":"6","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"198468008","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:39:53.000000Z","updated_at":"2025-03-17T21:39:53.000000Z","normalized_code":"3963A1"},{"id":7022621,"change_date":"2023-12-12 21:41:00","inspection_id":"80288856","insp_violation_id":"256843745","seq_no":"7","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"198468008","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:39:53.000000Z","updated_at":"2025-03-17T21:39:53.000000Z","normalized_code":"39343"}],"inspection_per_units":[{"id":7300120,"change_date":"2023-12-12 21:41:00","inspection_id":"80288856","insp_unit_id":"198468007","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"11180","insp_unit_license":"51J9GY","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1FD0W5GT0LED98051","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:20.000000Z","updated_at":"2025-03-17T23:01:20.000000Z"},{"id":7300121,"change_date":"2023-12-12 21:41:00","inspection_id":"80288856","insp_unit_id":"198468008","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIW","insp_unit_company":"03224","insp_unit_license":"80F6CC","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"5UCPT2727JA003224","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:20.000000Z","updated_at":"2025-03-17T23:01:20.000000Z"}]},{"id":4457053,"change_date":"2023-11-19 21:31:00","inspection_id":"80198684","dot_number":"180749","report_state":"MO","report_number":"4392000225","insp_date":"2023-11-15 00:00:00","insp_start_time":"1059","insp_end_time":"1135","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"KANSAS CITY MO","county_code_state":"MO","county_code":"047","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2023-11-19 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"101460","transaction_code":"A","transaction_date":"2023-11-19 00:00:00","upload_date":"2023-11-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00180749","upload_search_indicator":null,"census_search_date":"2023-11-19 21:31:00","snet_input_date":"2023-11-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-11-19 21:31:00","insp_carrier_name":"MCCONNELL & ASSOCIATES CORPORATION","insp_carrier_street":"1225 IRON","insp_carrier_city":"NORTH KANSAS CITY","insp_carrier_state":"MO","insp_carrier_zip_code":"64116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:51:06.000000Z","updated_at":"2025-03-17T19:51:06.000000Z","inspection_violations":[{"id":6898892,"change_date":"2023-11-19 21:31:00","inspection_id":"80198684","insp_violation_id":"256475258","seq_no":"1","part_no":"393","part_no_section":"100B-C","insp_viol_unit":"1","insp_unit_id":"198131981","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:39:14.000000Z","updated_at":"2025-03-17T21:39:14.000000Z","normalized_code":"393100BC"}],"inspection_per_units":[{"id":7167767,"change_date":"2023-11-19 21:31:00","inspection_id":"80198684","insp_unit_id":"198131981","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"37KT0B","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3ALMG3CY9HDJF0515","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:11.000000Z","updated_at":"2025-03-17T23:00:11.000000Z"}]},{"id":4339162,"change_date":"2023-11-02 21:41:00","inspection_id":"80068379","dot_number":"180749","report_state":"MO","report_number":"4496000179","insp_date":"2023-11-01 00:00:00","insp_start_time":"1030","insp_end_time":"1053","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"KANSAS CITY MO","county_code_state":"MO","county_code":"095","insp_level_id":"1","service_center":"MW","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":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2023-11-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"84985","transaction_code":"A","transaction_date":"2023-11-02 00:00:00","upload_date":"2023-11-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00180749","upload_search_indicator":null,"census_search_date":"2023-11-02 21:41:00","snet_input_date":"2023-11-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-11-02 21:41:00","insp_carrier_name":"MCCONNELL & ASSOCIATES CORPORATION","insp_carrier_street":"1225 IRON","insp_carrier_city":"NORTH KANSAS CITY","insp_carrier_state":"MO","insp_carrier_zip_code":"64116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:48:47.000000Z","updated_at":"2025-03-17T19:48:47.000000Z","inspection_violations":[{"id":6712292,"change_date":"2023-11-02 21:41:00","inspection_id":"80068379","insp_violation_id":"256180025","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:18.000000Z","updated_at":"2025-03-17T21:38:18.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6978646,"change_date":"2023-11-02 21:41:00","inspection_id":"80068379","insp_unit_id":"197871205","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"75KG4B","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1FD0W5HT2LEE49919","insp_unit_decal":"Y","insp_unit_decal_number":"33465455","created_at":"2025-03-17T22:58:34.000000Z","updated_at":"2025-03-17T22:58:34.000000Z"}]},{"id":4172997,"change_date":"2023-10-11 21:40:00","inspection_id":"79884791","dot_number":"180749","report_state":"IA","report_number":"000TT3HWRT","insp_date":"2023-10-10 00:00:00","insp_start_time":"0921","insp_end_time":"0950","registration_date":null,"region":"CT","ci_status_code":"C","location":"14","location_desc":"14 - I29 NB MM 12 PERCIVAL","county_code_state":"IA","county_code":"071","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MCCONNELL AND  ASSOCIATES CORP","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"37500","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":"1291463","transaction_code":"A","transaction_date":"2023-10-11 00:00:00","upload_date":"2023-10-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00180749","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-10-10 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-10-11 21:40:00","insp_carrier_name":"MCCONNELL & ASSOCIATES CORPORATION","insp_carrier_street":"1225 IRON","insp_carrier_city":"NORTH KANSAS CITY","insp_carrier_state":"MO","insp_carrier_zip_code":"64116","insp_colonia":null,"docket_number":"329285","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:45:29.000000Z","updated_at":"2025-03-17T19:45:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6710336,"change_date":"2023-10-11 21:40:00","inspection_id":"79884791","insp_unit_id":"197500320","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"11163","insp_unit_license":"79BIBU","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1FD0W5GT0JEB65414","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:17.000000Z","updated_at":"2025-03-17T22:56:17.000000Z"},{"id":6710337,"change_date":"2023-10-11 21:40:00","inspection_id":"79884791","insp_unit_id":"197500321","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAILMAX","insp_unit_company":"03224","insp_unit_license":"80F6CC","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"5UCPT2727JA003224","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:17.000000Z","updated_at":"2025-03-17T22:56:17.000000Z"}]},{"id":3955139,"change_date":"2023-09-12 21:40:00","inspection_id":"79642999","dot_number":"180749","report_state":"KS","report_number":"HP02730303","insp_date":"2023-09-11 00:00:00","insp_start_time":"0916","insp_end_time":"0931","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"TOPEKA SERVICE STATION","county_code_state":"KS","county_code":"177","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"1301085","transaction_code":"A","transaction_date":"2023-09-11 00:00:00","upload_date":"2023-09-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00180749","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-09-11 00:00:00","source_office":"3KSS001","mcmis_add_date":"2023-09-12 21:40:00","insp_carrier_name":"MCCONNELL & ASSOCIATES CORPORATION","insp_carrier_street":"1225 IRON","insp_carrier_city":"NORTH KANSAS CITY","insp_carrier_state":"MO","insp_carrier_zip_code":"64116","insp_colonia":null,"docket_number":"329285","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:40:51.000000Z","updated_at":"2025-03-17T19:40:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6359553,"change_date":"2023-09-12 21:40:00","inspection_id":"79642999","insp_unit_id":"197013646","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"83AP9M","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"2HSCNSCRX7C432884","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:24.000000Z","updated_at":"2025-03-17T22:53:24.000000Z"}]},{"id":3818186,"change_date":"2023-08-24 21:40:00","inspection_id":"79490130","dot_number":"180749","report_state":"MO","report_number":"4392000041","insp_date":"2023-08-22 00:00:00","insp_start_time":"1311","insp_end_time":"1337","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"KANSAS CITYMO","county_code_state":"MO","county_code":"047","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2023-08-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66410","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":"45059","transaction_code":"A","transaction_date":"2023-08-24 00:00:00","upload_date":"2023-08-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00180749","upload_search_indicator":null,"census_search_date":"2023-08-24 21:40:00","snet_input_date":"2023-08-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-08-24 21:40:00","insp_carrier_name":"MCCONNELL & ASSOCIATES CORPORATION","insp_carrier_street":"1225 IRON","insp_carrier_city":"NORTH KANSAS CITY","insp_carrier_state":"MO","insp_carrier_zip_code":"64116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:07.000000Z","updated_at":"2025-03-17T19:38:07.000000Z","inspection_violations":[{"id":5893143,"change_date":"2023-08-24 21:40:00","inspection_id":"79490130","insp_violation_id":"254847280","seq_no":"1","part_no":"392","part_no_section":"2-SLLIRP","insp_viol_unit":"1","insp_unit_id":"196699504","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:25.000000Z","updated_at":"2025-03-17T21:34:25.000000Z","normalized_code":"3922SLLIRP"}],"inspection_per_units":[{"id":6139102,"change_date":"2023-08-24 21:40:00","inspection_id":"79490130","insp_unit_id":"196699504","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"NONE DISPLAY","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1FV4JJCB01HH03545","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:34.000000Z","updated_at":"2025-03-17T22:51:34.000000Z"}]},{"id":3579760,"change_date":"2023-07-24 21:42:00","inspection_id":"79223764","dot_number":"180749","report_state":"NE","report_number":"T660000077","insp_date":"2023-07-24 00:00:00","insp_start_time":"1417","insp_end_time":"1457","registration_date":null,"region":"CT","ci_status_code":"C","location":"7","location_desc":"NEBRASKA CITY SCALE","county_code_state":"NE","county_code":"131","insp_level_id":"1","service_center":"MW","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":"2023-07-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"765203","transaction_code":"A","transaction_date":"2023-07-24 00:00:00","upload_date":"2023-07-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00180749","upload_search_indicator":null,"census_search_date":"2023-07-24 21:42:00","snet_input_date":"2023-07-24 00:00:00","source_office":"3NES001","mcmis_add_date":"2023-07-24 21:42:00","insp_carrier_name":"MCCONNELL & ASSOCIATES CORPORATION","insp_carrier_street":"1225 IRON","insp_carrier_city":"NORTH KANSAS CITY","insp_carrier_state":"MO","insp_carrier_zip_code":"64116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:33:36.000000Z","updated_at":"2025-03-17T19:33:36.000000Z","inspection_violations":[{"id":5519408,"change_date":"2023-07-24 21:42:00","inspection_id":"79223764","insp_violation_id":"254240776","seq_no":"1","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:32:34.000000Z","updated_at":"2025-03-17T21:32:34.000000Z","normalized_code":"39522H4"}],"inspection_per_units":[{"id":5756039,"change_date":"2023-07-24 21:42:00","inspection_id":"79223764","insp_unit_id":"196161091","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"11152","insp_unit_license":"05AH1L","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3FRNW7FC8DV775094","insp_unit_decal":"Y","insp_unit_decal_number":"33099586","created_at":"2025-03-17T22:48:26.000000Z","updated_at":"2025-03-17T22:48:26.000000Z"}]},{"id":3447157,"change_date":"2023-07-12 21:41:00","inspection_id":"79074598","dot_number":"180749","report_state":"KS","report_number":"HP04960037","insp_date":"2023-06-29 00:00:00","insp_start_time":"0825","insp_end_time":"0850","registration_date":"2023-07-12 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"SCALE","county_code_state":"KS","county_code":"091","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-06 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"1294986","transaction_code":"C","transaction_date":"2023-06-29 00:00:00","upload_date":"2023-07-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00180749","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-06-29 00:00:00","source_office":"3KSS001","mcmis_add_date":"2023-07-06 21:43:00","insp_carrier_name":"MCCONNELL & ASSOCIATES CORPORATION","insp_carrier_street":"1225 IRON","insp_carrier_city":"NORTH KANSAS CITY","insp_carrier_state":"MO","insp_carrier_zip_code":"64116","insp_colonia":null,"docket_number":"329285","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:31:19.000000Z","updated_at":"2025-03-17T19:31:19.000000Z","inspection_violations":[{"id":5314417,"change_date":"2023-07-12 21:41:00","inspection_id":"79074598","insp_violation_id":"254013381","seq_no":"1","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"1","insp_unit_id":"195956481","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:31:39.000000Z","updated_at":"2025-03-17T21:31:39.000000Z","normalized_code":"39375A"}],"inspection_per_units":[{"id":5543198,"change_date":"2023-07-12 21:41:00","inspection_id":"79074598","insp_unit_id":"195956481","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"11108","insp_unit_license":"90AR3M","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"2HSCNAPR56C269760","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:45.000000Z","updated_at":"2025-03-17T22:46:45.000000Z"}]},{"id":3295065,"change_date":"2024-08-22 21:42:00","inspection_id":"78903768","dot_number":"180749","report_state":"KS","report_number":"KC82270104","insp_date":"2023-06-14 00:00:00","insp_start_time":"0910","insp_end_time":"1030","registration_date":"2023-07-12 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"OLATHE SOUTH M.C.I.S #24W","county_code_state":"KS","county_code":"091","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SHIPPER IS CARRIER","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-06-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26300","viol_total":"14","oos_total":"5","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"12","vehicle_oos_total":"5","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1292119","transaction_code":"C","transaction_date":"2024-08-22 00:00:00","upload_date":"2024-08-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00180749","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-06-14 00:00:00","source_office":"3KSS001","mcmis_add_date":"2023-06-15 21:42:00","insp_carrier_name":"MCCONNELL & ASSOCIATES CORPORATION","insp_carrier_street":"1225 IRON","insp_carrier_city":"NORTH KANSAS CITY","insp_carrier_state":"MO","insp_carrier_zip_code":"64116","insp_colonia":null,"docket_number":"329285","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:28:10.000000Z","updated_at":"2025-03-17T19:28:10.000000Z","inspection_violations":[{"id":5080994,"change_date":"2024-08-22 21:42:00","inspection_id":"78903768","insp_violation_id":"261349608","seq_no":"1","part_no":"395","part_no_section":"8","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:30:38.000000Z","updated_at":"2025-03-17T21:30:38.000000Z","normalized_code":"3958"},{"id":5080995,"change_date":"2024-08-22 21:42:00","inspection_id":"78903768","insp_violation_id":"261349609","seq_no":"2","part_no":"392","part_no_section":"8","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:38.000000Z","updated_at":"2025-03-17T21:30:38.000000Z","normalized_code":"3928"},{"id":5080996,"change_date":"2024-08-22 21:42:00","inspection_id":"78903768","insp_violation_id":"261349610","seq_no":"3","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"202535171","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:38.000000Z","updated_at":"2025-03-17T21:30:38.000000Z","normalized_code":"39021TB"},{"id":5080997,"change_date":"2024-08-22 21:42:00","inspection_id":"78903768","insp_violation_id":"261349611","seq_no":"4","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"202535171","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:38.000000Z","updated_at":"2025-03-17T21:30:38.000000Z","normalized_code":"39395A"},{"id":5080998,"change_date":"2024-08-22 21:42:00","inspection_id":"78903768","insp_violation_id":"261349612","seq_no":"5","part_no":"393","part_no_section":"75(g)","insp_viol_unit":"1","insp_unit_id":"202535171","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:30:38.000000Z","updated_at":"2025-03-17T21:30:38.000000Z","normalized_code":"39375G"},{"id":5080999,"change_date":"2024-08-22 21:42:00","inspection_id":"78903768","insp_violation_id":"261349613","seq_no":"6","part_no":"393","part_no_section":"75(g)","insp_viol_unit":"1","insp_unit_id":"202535171","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:30:38.000000Z","updated_at":"2025-03-17T21:30:38.000000Z","normalized_code":"39375G"},{"id":5081000,"change_date":"2024-08-22 21:42:00","inspection_id":"78903768","insp_violation_id":"261349614","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"202535172","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:38.000000Z","updated_at":"2025-03-17T21:30:38.000000Z","normalized_code":"3939A"},{"id":5081001,"change_date":"2024-08-22 21:42:00","inspection_id":"78903768","insp_violation_id":"261349615","seq_no":"8","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"202535172","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:30:38.000000Z","updated_at":"2025-03-17T21:30:38.000000Z","normalized_code":"3939A"},{"id":5081002,"change_date":"2024-08-22 21:42:00","inspection_id":"78903768","insp_violation_id":"261349616","seq_no":"9","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"202535172","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:38.000000Z","updated_at":"2025-03-17T21:30:38.000000Z","normalized_code":"39348A"},{"id":5081003,"change_date":"2024-08-22 21:42:00","inspection_id":"78903768","insp_violation_id":"261349617","seq_no":"10","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"202535172","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:38.000000Z","updated_at":"2025-03-17T21:30:38.000000Z","normalized_code":"39348A"},{"id":5081004,"change_date":"2024-08-22 21:42:00","inspection_id":"78903768","insp_violation_id":"261349618","seq_no":"11","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"202535172","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:38.000000Z","updated_at":"2025-03-17T21:30:38.000000Z","normalized_code":"39348A"},{"id":5081005,"change_date":"2024-08-22 21:42:00","inspection_id":"78903768","insp_violation_id":"261349619","seq_no":"12","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"202535172","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:38.000000Z","updated_at":"2025-03-17T21:30:38.000000Z","normalized_code":"39348A"},{"id":5081006,"change_date":"2024-08-22 21:42:00","inspection_id":"78903768","insp_violation_id":"261349620","seq_no":"13","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"202535172","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:30:38.000000Z","updated_at":"2025-03-17T21:30:38.000000Z","normalized_code":"3963A1"},{"id":5081007,"change_date":"2024-08-22 21:42:00","inspection_id":"78903768","insp_violation_id":"261349621","seq_no":"14","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"202535172","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:30:38.000000Z","updated_at":"2025-03-17T21:30:38.000000Z","normalized_code":"39343"}],"inspection_per_units":[{"id":5297620,"change_date":"2024-08-22 21:42:00","inspection_id":"78903768","insp_unit_id":"202535171","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"64J9JA","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3C63R3GL0NG303052","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:47.000000Z","updated_at":"2025-03-17T22:44:47.000000Z"},{"id":5297621,"change_date":"2024-08-22 21:42:00","inspection_id":"78903768","insp_unit_id":"202535172","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MAXE","insp_unit_company":null,"insp_unit_license":"53K7LA","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"5R8CH202X7M004992","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:47.000000Z","updated_at":"2025-03-17T22:44:47.000000Z"}]},{"id":3295087,"change_date":"2023-06-15 21:42:00","inspection_id":"78903793","dot_number":"180749","report_state":"KS","report_number":"PD83170027","insp_date":"2023-06-14 00:00:00","insp_start_time":"1149","insp_end_time":"1215","registration_date":null,"region":"CT","ci_status_code":"C","location":"#24W","location_desc":"OLATHE SOUTH M.C.I.S. #24W","county_code_state":"KS","county_code":"091","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MAC","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-06-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"37200","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":"1292043","transaction_code":"A","transaction_date":"2023-06-14 00:00:00","upload_date":"2023-06-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00180749","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-06-14 00:00:00","source_office":"3KSS001","mcmis_add_date":"2023-06-15 21:42:00","insp_carrier_name":"MCCONNELL & ASSOCIATES CORPORATION","insp_carrier_street":"1225 IRON","insp_carrier_city":"NORTH KANSAS CITY","insp_carrier_state":"MO","insp_carrier_zip_code":"64116","insp_colonia":null,"docket_number":"329285","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:28:10.000000Z","updated_at":"2025-03-17T19:28:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5297651,"change_date":"2023-06-15 21:42:00","inspection_id":"78903793","insp_unit_id":"195521312","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"31181","insp_unit_license":"53J4JE","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1FD0W5HT3PEC71895","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:47.000000Z","updated_at":"2025-03-17T22:44:47.000000Z"},{"id":5297652,"change_date":"2023-06-15 21:42:00","inspection_id":"78903793","insp_unit_id":"195521313","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"1362","insp_unit_license":"43L8SP","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1V9PT2629N1233595","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:47.000000Z","updated_at":"2025-03-17T22:44:47.000000Z"}]},{"id":3240008,"change_date":"2023-07-12 21:41:00","inspection_id":"78841442","dot_number":"180749","report_state":"KS","report_number":"PD83720079","insp_date":"2023-06-07 00:00:00","insp_start_time":"1740","insp_end_time":"1830","registration_date":"2023-07-12 00:00:00","region":"CT","ci_status_code":"C","location":"DG","location_desc":"DOUGLAS COUNTY - 045","county_code_state":"KS","county_code":"045","insp_level_id":"1","service_center":"MW","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":"Y","pen_cen_match":null,"final_status_date":"2023-06-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"37150","viol_total":"10","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"10","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1291197","transaction_code":"C","transaction_date":"2023-06-08 00:00:00","upload_date":"2023-07-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00180749","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-06-07 00:00:00","source_office":"3KSS001","mcmis_add_date":"2023-06-08 21:41:00","insp_carrier_name":"MCCONNELL & ASSOCIATES CORPORATION","insp_carrier_street":"1225 IRON","insp_carrier_city":"NORTH KANSAS CITY","insp_carrier_state":"MO","insp_carrier_zip_code":"64116","insp_colonia":null,"docket_number":"329285","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:27:17.000000Z","updated_at":"2025-03-17T19:27:17.000000Z","inspection_violations":[{"id":4994163,"change_date":"2023-07-12 21:41:00","inspection_id":"78841442","insp_violation_id":"254013556","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"195956565","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:13.000000Z","updated_at":"2025-03-17T21:30:13.000000Z","normalized_code":"39395A"},{"id":4994164,"change_date":"2023-07-12 21:41:00","inspection_id":"78841442","insp_violation_id":"254013557","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195956565","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:13.000000Z","updated_at":"2025-03-17T21:30:13.000000Z","normalized_code":"3939A"},{"id":4994165,"change_date":"2023-07-12 21:41:00","inspection_id":"78841442","insp_violation_id":"254013558","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195956565","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:13.000000Z","updated_at":"2025-03-17T21:30:13.000000Z","normalized_code":"3939A"},{"id":4994166,"change_date":"2023-07-12 21:41:00","inspection_id":"78841442","insp_violation_id":"254013559","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"195956566","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:13.000000Z","updated_at":"2025-03-17T21:30:13.000000Z","normalized_code":"3939A"},{"id":4994167,"change_date":"2023-07-12 21:41:00","inspection_id":"78841442","insp_violation_id":"254013560","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"195956566","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:13.000000Z","updated_at":"2025-03-17T21:30:13.000000Z","normalized_code":"3939A"},{"id":4994168,"change_date":"2023-07-12 21:41:00","inspection_id":"78841442","insp_violation_id":"254013561","seq_no":"6","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"195956566","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:30:13.000000Z","updated_at":"2025-03-17T21:30:13.000000Z","normalized_code":"3963A1"},{"id":4994169,"change_date":"2023-07-12 21:41:00","inspection_id":"78841442","insp_violation_id":"254013562","seq_no":"7","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"195956566","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:13.000000Z","updated_at":"2025-03-17T21:30:13.000000Z","normalized_code":"39348A"},{"id":4994170,"change_date":"2023-07-12 21:41:00","inspection_id":"78841442","insp_violation_id":"254013563","seq_no":"8","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"195956566","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:13.000000Z","updated_at":"2025-03-17T21:30:13.000000Z","normalized_code":"39348A"},{"id":4994171,"change_date":"2023-07-12 21:41:00","inspection_id":"78841442","insp_violation_id":"254013564","seq_no":"9","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"195956566","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:13.000000Z","updated_at":"2025-03-17T21:30:13.000000Z","normalized_code":"39348A"},{"id":4994172,"change_date":"2023-07-12 21:41:00","inspection_id":"78841442","insp_violation_id":"254013565","seq_no":"10","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"195956566","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:13.000000Z","updated_at":"2025-03-17T21:30:13.000000Z","normalized_code":"39348A"}],"inspection_per_units":[{"id":5211023,"change_date":"2023-07-12 21:41:00","inspection_id":"78841442","insp_unit_id":"195956565","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"1189","insp_unit_license":"71H9XN","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1FDAW56P75ED36822","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:05.000000Z","updated_at":"2025-03-17T22:44:05.000000Z"},{"id":5211024,"change_date":"2023-07-12 21:41:00","inspection_id":"78841442","insp_unit_id":"195956566","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VALOR","insp_unit_company":"16-TUS","insp_unit_license":"43L8SP","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1V9PT2629N1233595","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:05.000000Z","updated_at":"2025-03-17T22:44:05.000000Z"}]},{"id":1754757,"change_date":"2022-11-16 21:41:00","inspection_id":"77151279","dot_number":"180749","report_state":"MO","report_number":"W179002868","insp_date":"2022-11-09 00:00:00","insp_start_time":"1636","insp_end_time":"1657","registration_date":null,"region":"CT","ci_status_code":"C","location":"A3W","location_desc":"MAYVIEW POST A3 WEST","county_code_state":"MO","county_code":"107","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"MAC","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-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"38000","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":"2043537","transaction_code":"A","transaction_date":"2022-11-09 00:00:00","upload_date":"2022-11-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00180749","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-11-16 00:00:00","source_office":"3MOS001","mcmis_add_date":"2022-11-16 21:41:00","insp_carrier_name":"MCCONNELL & ASSOCIATES CORPORATION","insp_carrier_street":"1225 IRON","insp_carrier_city":"NORTH KANSAS CITY","insp_carrier_state":"MO","insp_carrier_zip_code":"64116","insp_colonia":null,"docket_number":"329285","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:58.000000Z","updated_at":"2025-03-17T18:58:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2823345,"change_date":"2022-11-16 21:41:00","inspection_id":"77151279","insp_unit_id":"191990534","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"11143","insp_unit_license":"52AH5K","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1HTMMAAN1AH261956","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:19.000000Z","updated_at":"2025-03-17T22:26:19.000000Z"},{"id":2823346,"change_date":"2022-11-16 21:41:00","inspection_id":"77151279","insp_unit_id":"191990535","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"1345","insp_unit_license":"54K0LA","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"4ZECF182261013564","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:19.000000Z","updated_at":"2025-03-17T22:26:19.000000Z"}]},{"id":1026843,"change_date":"2022-08-12 21:39:00","inspection_id":"76308768","dot_number":"180749","report_state":"MO","report_number":"00KG001084","insp_date":"2022-08-11 00:00:00","insp_start_time":"1518","insp_end_time":"1531","registration_date":null,"region":"CT","ci_status_code":"C","location":"A435","location_desc":"44TH & N RANDOLPH","county_code_state":"MO","county_code":"047","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-08-12 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"62740","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":"2026226","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":"00180749","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-08-12 00:00:00","source_office":"3MOS001","mcmis_add_date":"2022-08-12 21:39:00","insp_carrier_name":"MCCONNELL & ASSOCIATES CORPORATION","insp_carrier_street":"1225 IRON","insp_carrier_city":"NORTH KANSAS CITY","insp_carrier_state":"MO","insp_carrier_zip_code":"64116","insp_colonia":null,"docket_number":"329285","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:45:48.000000Z","updated_at":"2025-03-17T18:45:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1652374,"change_date":"2022-08-12 21:39:00","inspection_id":"76308768","insp_unit_id":"190284362","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"1196","insp_unit_license":"14AM8P","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"2NPLLZ0X26M660034","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:25.000000Z","updated_at":"2025-03-17T22:18:25.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/180749\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/180749\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/180749\/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\/180749\/inspections","per_page":100,"prev_page_url":null,"to":35,"total":35}