{"current_page":1,"data":[{"id":12193362,"change_date":"2026-06-15 21:41:00","inspection_id":"88149417","dot_number":"436966","report_state":"IA","report_number":"205S000081","insp_date":"2026-06-15 00:00:00","insp_start_time":"0932","insp_end_time":"0954","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"IA","county_code_state":"IA","county_code":"187","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"FLYNN COMPANY INC","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":"Y","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":"140740","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":"3546253","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":"00436966","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":"FLYNN COMPANY INC","insp_carrier_street":"800 JULIEN DUBUQUE DR","insp_carrier_city":"DUBUQUE","insp_carrier_state":"IA","insp_carrier_zip_code":"52004","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-18T09:41:03.000000Z","updated_at":"2026-06-18T09:41:03.000000Z","inspection_violations":[{"id":21219227,"change_date":"2026-06-15 21:41:00","inspection_id":"88149417","insp_violation_id":"274920229","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","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:01:02.000000Z","updated_at":"2026-06-18T10:01:02.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":21178594,"change_date":"2026-06-15 21:41:00","inspection_id":"88149417","insp_unit_id":"214112566","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"4409","insp_unit_license":"SD2564","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1NPSL0EX49D771923","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-18T09:17:58.000000Z","updated_at":"2026-06-18T09:17:58.000000Z"},{"id":21178595,"change_date":"2026-06-15 21:41:00","inspection_id":"88149417","insp_unit_id":"214112567","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HOMEMADE T","insp_unit_company":"3-306","insp_unit_license":"LS1116","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"IA037319","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-18T09:17:58.000000Z","updated_at":"2026-06-18T09:17:58.000000Z"}]},{"id":12126695,"change_date":"2026-06-09 10:49:00","inspection_id":"88072521","dot_number":"436966","report_state":"IA","report_number":"205S000044","insp_date":"2026-06-08 00:00:00","insp_start_time":"1147","insp_end_time":"1159","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"IA","county_code_state":"IA","county_code":"187","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"FLYNN COMPANY","shipping_paper_number":"TRUCK","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-09 10:49:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"3493137","transaction_code":"A","transaction_date":"2026-06-08 00:00:00","upload_date":"2026-06-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00436966","upload_search_indicator":null,"census_search_date":"2026-06-09 10:49:00","snet_input_date":"2026-06-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-09 10:49:00","insp_carrier_name":"FLYNN COMPANY INC","insp_carrier_street":"800 JULIEN DUBUQUE DR","insp_carrier_city":"DUBUQUE","insp_carrier_state":"IA","insp_carrier_zip_code":"52004","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-12T09:39:47.000000Z","updated_at":"2026-06-18T09:31:57.000000Z","inspection_violations":[{"id":21104826,"change_date":"2026-06-09 10:49:00","inspection_id":"88072521","insp_violation_id":"274762016","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","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-12T09:58:10.000000Z","updated_at":"2026-06-18T09:43:32.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":21068908,"change_date":"2026-06-09 10:49:00","inspection_id":"88072521","insp_unit_id":"213969105","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"CUSTOM SCO","insp_unit_company":"3316","insp_unit_license":"FY1693","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1HSDJSNR2GH734076","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-12T09:15:09.000000Z","updated_at":"2026-06-18T09:04:01.000000Z"},{"id":21068909,"change_date":"2026-06-09 10:49:00","inspection_id":"88072521","insp_unit_id":"213969106","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LOAD KING","insp_unit_company":"3-409","insp_unit_license":"LT0441","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5LKL5335X91027416","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-12T09:15:09.000000Z","updated_at":"2026-06-18T09:04:01.000000Z"}]},{"id":10164596,"change_date":"2025-11-10 21:39:00","inspection_id":"86283566","dot_number":"436966","report_state":"IA","report_number":"000P130R94","insp_date":"2025-11-05 00:00:00","insp_start_time":"1242","insp_end_time":"1325","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"EAST 1ST STREET EB \/ HUXLEY","county_code_state":"IA","county_code":"169","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"FLYNN COMPANY INC","shipping_paper_number":"38687307","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":"2025-11-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"71090","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":"1380131","transaction_code":"A","transaction_date":"2025-11-07 00:00:00","upload_date":"2025-11-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00436966","upload_search_indicator":"M","census_search_date":"2025-11-10 21:39:00","snet_input_date":"2025-11-05 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-11-10 21:39:00","insp_carrier_name":"FLYNN COMPANY INC","insp_carrier_street":"800 JULIEN DUBUQUE DR","insp_carrier_city":"DUBUQUE","insp_carrier_state":"IA","insp_carrier_zip_code":"52004-7014","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-13T10:30:43.000000Z","updated_at":"2025-11-14T10:30:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16925044,"change_date":"2025-11-10 21:39:00","inspection_id":"86283566","insp_unit_id":"209946624","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"4211","insp_unit_license":"SE8832","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1NPSX0EX6BD115121","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-13T10:00:42.000000Z","updated_at":"2025-11-14T10:01:02.000000Z"}]},{"id":8714283,"change_date":"2025-05-22 21:42:00","inspection_id":"84755926","dot_number":"436966","report_state":"IA","report_number":"000P12X2TD","insp_date":"2025-05-21 00:00:00","insp_start_time":"1252","insp_end_time":"1300","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"F90 WEST DES MOINES","county_code_state":"IA","county_code":"049","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"01","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"84000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1361367","transaction_code":"A","transaction_date":"2025-05-22 00:00:00","upload_date":"2025-05-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00436966","upload_search_indicator":"M","census_search_date":"2025-05-22 21:42:00","snet_input_date":"2025-05-21 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-05-22 21:42:00","insp_carrier_name":"FLYNN COMPANY INC","insp_carrier_street":"800 JULIEN DUBUQUE DR","insp_carrier_city":"DUBUQUE","insp_carrier_state":"IA","insp_carrier_zip_code":"52004-7014","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-25T10:05:50.000000Z","updated_at":"2025-05-26T10:06:17.000000Z","inspection_violations":[{"id":13897759,"change_date":"2025-05-22 21:42:00","inspection_id":"84755926","insp_violation_id":"266406894","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-25T10:27:57.000000Z","updated_at":"2025-05-26T10:26:14.000000Z","normalized_code":"3922SLLS2"},{"id":13897760,"change_date":"2025-05-22 21:42:00","inspection_id":"84755926","insp_violation_id":"266406895","seq_no":"2","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"207015257","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-25T10:27:57.000000Z","updated_at":"2025-05-26T10:26:14.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":14243259,"change_date":"2025-05-22 21:42:00","inspection_id":"84755926","insp_unit_id":"207015257","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"4-607","insp_unit_license":"SC5111","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1M2AG11CX7M052796","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-25T09:50:58.000000Z","updated_at":"2025-05-26T09:51:29.000000Z"}]},{"id":8630940,"change_date":"2025-05-14 21:41:00","inspection_id":"84668199","dot_number":"436966","report_state":"IA","report_number":"000P1269RR","insp_date":"2025-05-12 00:00:00","insp_start_time":"1257","insp_end_time":"1325","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"NB I-35 89MM ANKENY","county_code_state":"IA","county_code":"153","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"150980","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":"1359895","transaction_code":"A","transaction_date":"2025-05-14 00:00:00","upload_date":"2025-05-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00436966","upload_search_indicator":"M","census_search_date":"2025-05-14 21:41:00","snet_input_date":"2025-05-12 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-05-14 21:41:00","insp_carrier_name":"FLYNN COMPANY INC","insp_carrier_street":"800 JULIEN DUBUQUE DR","insp_carrier_city":"DUBUQUE","insp_carrier_state":"IA","insp_carrier_zip_code":"52004-7014","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-17T10:05:09.000000Z","updated_at":"2025-05-18T10:05:46.000000Z","inspection_violations":[{"id":13723835,"change_date":"2025-05-14 21:41:00","inspection_id":"84668199","insp_violation_id":"266218547","seq_no":"1","part_no":"392","part_no_section":"2-SLLS1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"9RIP25051213105","created_at":"2025-05-18T10:26:47.000000Z","updated_at":"2025-05-18T10:32:58.000000Z","normalized_code":"3922SLLS1"}],"inspection_per_units":[{"id":14093077,"change_date":"2025-05-14 21:41:00","inspection_id":"84668199","insp_unit_id":"206855502","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"3109","insp_unit_license":"SD9333","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5KJNALDR89PAH7640","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-17T09:49:10.000000Z","updated_at":"2025-05-18T09:51:18.000000Z"},{"id":14093078,"change_date":"2025-05-14 21:41:00","inspection_id":"84668199","insp_unit_id":"206855503","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LOADKING","insp_unit_company":"4-300","insp_unit_license":"LS1118","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5LKD4023XY1023435","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-17T09:49:10.000000Z","updated_at":"2025-05-18T09:51:18.000000Z"}]},{"id":7250194,"change_date":"2024-11-22 21:41:00","inspection_id":"83215811","dot_number":"436966","report_state":"IA","report_number":"000P130R4D","insp_date":"2024-11-20 00:00:00","insp_start_time":"1448","insp_end_time":"1540","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 30 EB \/ NEVADA","county_code_state":"IA","county_code":"169","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"FLYNN COMPANY INC","shipping_paper_number":"CONCRETE SPREAD","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"177000","viol_total":"4","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1338366","transaction_code":"C","transaction_date":"2024-11-21 00:00:00","upload_date":"2024-11-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00436966","upload_search_indicator":"M","census_search_date":"2024-11-21 21:41:00","snet_input_date":"2024-11-20 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-11-21 21:41:00","insp_carrier_name":"FLYNN COMPANY INC","insp_carrier_street":"800 JULIEN DUBUQUE DR","insp_carrier_city":"DUBUQUE","insp_carrier_state":"IA","insp_carrier_zip_code":"52004-7014","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:47:16.000000Z","updated_at":"2025-03-17T20:47:16.000000Z","inspection_violations":[{"id":11332839,"change_date":"2024-11-22 21:41:00","inspection_id":"83215811","insp_violation_id":"263044127","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:02.000000Z","updated_at":"2025-03-17T22:01:02.000000Z","normalized_code":"3922SLLS2"},{"id":11332840,"change_date":"2024-11-22 21:41:00","inspection_id":"83215811","insp_violation_id":"263044128","seq_no":"2","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"204013329","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:02.000000Z","updated_at":"2025-03-17T22:01:02.000000Z","normalized_code":"3922RG"},{"id":11332841,"change_date":"2024-11-22 21:41:00","inspection_id":"83215811","insp_violation_id":"263044129","seq_no":"3","part_no":"392","part_no_section":"2DIM","insp_viol_unit":"2","insp_unit_id":"204013329","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:02.000000Z","updated_at":"2025-03-17T22:01:02.000000Z","normalized_code":"3922DIM"},{"id":11332842,"change_date":"2024-11-22 21:41:00","inspection_id":"83215811","insp_violation_id":"263044130","seq_no":"4","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"204013329","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:02.000000Z","updated_at":"2025-03-17T22:01:02.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":11694506,"change_date":"2024-11-22 21:41:00","inspection_id":"83215811","insp_unit_id":"204013328","insp_unit_type_id":"9","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"3109","insp_unit_license":"SD9333","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5KJNALDR89PAH7640","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:11.000000Z","updated_at":"2025-03-17T23:44:11.000000Z"},{"id":11694507,"change_date":"2024-11-22 21:41:00","inspection_id":"83215811","insp_unit_id":"204013329","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LOAK","insp_unit_company":"3805","insp_unit_license":"CT0931","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5LKL5335051025491","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:11.000000Z","updated_at":"2025-03-17T23:44:11.000000Z"}]},{"id":6456966,"change_date":"2024-08-13 21:42:00","inspection_id":"82372760","dot_number":"436966","report_state":"IA","report_number":"000P15V9C9","insp_date":"2024-08-09 00:00:00","insp_start_time":"0810","insp_end_time":"0815","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 21 SB","county_code_state":"IA","county_code":"171","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"16001","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":"1324603","transaction_code":"A","transaction_date":"2024-08-13 00:00:00","upload_date":"2024-08-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00436966","upload_search_indicator":"M","census_search_date":"2024-08-13 21:42:00","snet_input_date":"2024-08-09 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-08-13 21:42:00","insp_carrier_name":"FLYNN COMPANY INC","insp_carrier_street":"800 JULIEN DUBUQUE DR","insp_carrier_city":"DUBUQUE","insp_carrier_state":"IA","insp_carrier_zip_code":"52004-7014","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:30:44.000000Z","updated_at":"2025-03-17T20:30:44.000000Z","inspection_violations":[{"id":10027338,"change_date":"2024-08-13 21:42:00","inspection_id":"82372760","insp_violation_id":"261167072","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:32.000000Z","updated_at":"2025-03-17T21:54:32.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10407475,"change_date":"2024-08-13 21:42:00","inspection_id":"82372760","insp_unit_id":"202370282","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"1-424","insp_unit_license":"OPG992","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FDUF5HN1RDA03942","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:51.000000Z","updated_at":"2025-03-17T23:30:51.000000Z"}]},{"id":6357198,"change_date":"2024-07-31 21:43:00","inspection_id":"82266039","dot_number":"436966","report_state":"IA","report_number":"000P15562N","insp_date":"2024-07-30 00:00:00","insp_start_time":"2051","insp_end_time":"2130","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 151 NB\/EXIT 54","county_code_state":"IA","county_code":"105","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"FLYNN COMPANY INC","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-31 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":null,"viol_total":"5","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1323174","transaction_code":"A","transaction_date":"2024-07-31 00:00:00","upload_date":"2024-07-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00436966","upload_search_indicator":"M","census_search_date":"2024-07-31 21:43:00","snet_input_date":"2024-07-30 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-07-31 21:43:00","insp_carrier_name":"FLYNN COMPANY INC","insp_carrier_street":"800 JULIEN DUBUQUE DR","insp_carrier_city":"DUBUQUE","insp_carrier_state":"IA","insp_carrier_zip_code":"52004-7014","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:28:43.000000Z","updated_at":"2025-03-17T20:28:43.000000Z","inspection_violations":[{"id":9869850,"change_date":"2024-07-31 21:43:00","inspection_id":"82266039","insp_violation_id":"260941998","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202167840","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:44.000000Z","updated_at":"2025-03-17T21:53:44.000000Z","normalized_code":"3939A"},{"id":9869851,"change_date":"2024-07-31 21:43:00","inspection_id":"82266039","insp_violation_id":"260941999","seq_no":"2","part_no":"393","part_no_section":"81","insp_viol_unit":"1","insp_unit_id":"202167840","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:44.000000Z","updated_at":"2025-03-17T21:53:44.000000Z","normalized_code":"39381"},{"id":9869852,"change_date":"2024-07-31 21:43:00","inspection_id":"82266039","insp_violation_id":"260942000","seq_no":"3","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"202167840","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:44.000000Z","updated_at":"2025-03-17T21:53:44.000000Z","normalized_code":"39395F"},{"id":9869853,"change_date":"2024-07-31 21:43:00","inspection_id":"82266039","insp_violation_id":"260942001","seq_no":"4","part_no":"393","part_no_section":"41","insp_viol_unit":"1","insp_unit_id":"202167840","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:53:44.000000Z","updated_at":"2025-03-17T21:53:44.000000Z","normalized_code":"39341"},{"id":9869854,"change_date":"2024-07-31 21:43:00","inspection_id":"82266039","insp_violation_id":"260942002","seq_no":"5","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"9MCM24073021203","created_at":"2025-03-17T21:53:44.000000Z","updated_at":"2025-03-17T21:53:44.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":10244665,"change_date":"2024-07-31 21:43:00","inspection_id":"82266039","insp_unit_id":"202167840","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"0144","insp_unit_license":"CSX583","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GBJC34U02F140144","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:07.000000Z","updated_at":"2025-03-17T23:29:07.000000Z"}]},{"id":6186531,"change_date":"2024-07-10 21:40:00","inspection_id":"82083195","dot_number":"436966","report_state":"IA","report_number":"000P14HXC4","insp_date":"2024-07-10 00:00:00","insp_start_time":"0755","insp_end_time":"0820","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"BAKER AVE SB","county_code_state":"IA","county_code":"031","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"FLYNN COMPANY INC","shipping_paper_number":"828056","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1320434","transaction_code":"A","transaction_date":"2024-07-10 00:00:00","upload_date":"2024-07-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00436966","upload_search_indicator":"M","census_search_date":"2024-07-10 21:40:00","snet_input_date":"2024-07-10 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-07-10 21:40:00","insp_carrier_name":"FLYNN COMPANY INC","insp_carrier_street":"800 JULIEN DUBUQUE DR","insp_carrier_city":"DUBUQUE","insp_carrier_state":"IA","insp_carrier_zip_code":"52004-7014","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:25:22.000000Z","updated_at":"2025-03-17T20:25:22.000000Z","inspection_violations":[{"id":9607087,"change_date":"2024-07-10 21:40:00","inspection_id":"82083195","insp_violation_id":"260566549","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"201818610","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:30.000000Z","updated_at":"2025-03-17T21:52:30.000000Z","normalized_code":"39311"},{"id":9607088,"change_date":"2024-07-10 21:40:00","inspection_id":"82083195","insp_violation_id":"260566550","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201818610","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:30.000000Z","updated_at":"2025-03-17T21:52:30.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9966206,"change_date":"2024-07-10 21:40:00","inspection_id":"82083195","insp_unit_id":"201818610","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"307","insp_unit_license":"SC5112","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1M2AG11C87M052795","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:16.000000Z","updated_at":"2025-03-17T23:26:16.000000Z"}]},{"id":6094216,"change_date":"2024-06-27 21:41:00","inspection_id":"81984055","dot_number":"436966","report_state":"IA","report_number":"000P168W8X","insp_date":"2024-06-26 00:00:00","insp_start_time":"1536","insp_end_time":"1630","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWH 61 SB","county_code_state":"IA","county_code":"061","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"FLYNN COMPANY INC","shipping_paper_number":"915011446","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"51500","viol_total":"6","oos_total":"1","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1318613","transaction_code":"A","transaction_date":"2024-06-27 00:00:00","upload_date":"2024-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00436966","upload_search_indicator":"M","census_search_date":"2024-06-27 21:41:00","snet_input_date":"2024-06-26 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-06-27 21:41:00","insp_carrier_name":"FLYNN COMPANY INC","insp_carrier_street":"800 JULIEN DUBUQUE DR","insp_carrier_city":"DUBUQUE","insp_carrier_state":"IA","insp_carrier_zip_code":"52004-7014","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:23:24.000000Z","updated_at":"2025-03-17T20:23:24.000000Z","inspection_violations":[{"id":9458283,"change_date":"2024-06-27 21:41:00","inspection_id":"81984055","insp_violation_id":"260352760","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"201627460","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:45.000000Z","updated_at":"2025-03-17T21:51:45.000000Z","normalized_code":"3963A1"},{"id":9458284,"change_date":"2024-06-27 21:41:00","inspection_id":"81984055","insp_violation_id":"260352761","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"201627460","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:45.000000Z","updated_at":"2025-03-17T21:51:45.000000Z","normalized_code":"39347E"},{"id":9458285,"change_date":"2024-06-27 21:41:00","inspection_id":"81984055","insp_violation_id":"260352762","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"201627460","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:51:45.000000Z","updated_at":"2025-03-17T21:51:45.000000Z","normalized_code":"3963A1"},{"id":9458286,"change_date":"2024-06-27 21:41:00","inspection_id":"81984055","insp_violation_id":"260352763","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"0WIL24062616214","created_at":"2025-03-17T21:51:45.000000Z","updated_at":"2025-03-17T21:51:45.000000Z","normalized_code":"3922"},{"id":9458287,"change_date":"2024-06-27 21:41:00","inspection_id":"81984055","insp_violation_id":"260352764","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:45.000000Z","updated_at":"2025-03-17T21:51:45.000000Z","normalized_code":"3922"},{"id":9458288,"change_date":"2024-06-27 21:41:00","inspection_id":"81984055","insp_violation_id":"260352765","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201627460","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:45.000000Z","updated_at":"2025-03-17T21:51:45.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":9815821,"change_date":"2024-06-27 21:41:00","inspection_id":"81984055","insp_unit_id":"201627460","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"607","insp_unit_license":"SC5111","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1M2AG11CX7M052796","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:41.000000Z","updated_at":"2025-03-17T23:24:41.000000Z"}]},{"id":6083595,"change_date":"2024-06-26 21:43:00","inspection_id":"81972577","dot_number":"436966","report_state":"IA","report_number":"000P168W8T","insp_date":"2024-06-25 00:00:00","insp_start_time":"1633","insp_end_time":"1645","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 151 SB","county_code_state":"IA","county_code":"061","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"OWN","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-26 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","viol_total":"3","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1318506","transaction_code":"A","transaction_date":"2024-06-26 00:00:00","upload_date":"2024-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00436966","upload_search_indicator":"M","census_search_date":"2024-06-26 21:43:00","snet_input_date":"2024-06-25 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-06-26 21:43:00","insp_carrier_name":"FLYNN COMPANY INC","insp_carrier_street":"800 JULIEN DUBUQUE DR","insp_carrier_city":"DUBUQUE","insp_carrier_state":"IA","insp_carrier_zip_code":"52004-7014","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:23:21.000000Z","updated_at":"2025-03-17T20:23:21.000000Z","inspection_violations":[{"id":9440845,"change_date":"2024-06-26 21:43:00","inspection_id":"81972577","insp_violation_id":"260327311","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:43.000000Z","updated_at":"2025-03-17T21:51:43.000000Z","normalized_code":"3922"},{"id":9440846,"change_date":"2024-06-26 21:43:00","inspection_id":"81972577","insp_violation_id":"260327312","seq_no":"2","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:43.000000Z","updated_at":"2025-03-17T21:51:43.000000Z","normalized_code":"39216A"},{"id":9440847,"change_date":"2024-06-26 21:43:00","inspection_id":"81972577","insp_violation_id":"260327313","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201605490","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:43.000000Z","updated_at":"2025-03-17T21:51:43.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":9798551,"change_date":"2024-06-26 21:43:00","inspection_id":"81972577","insp_unit_id":"201605490","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"4409","insp_unit_license":"SD2564","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1NPSL0EX49D771923","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:28.000000Z","updated_at":"2025-03-17T23:24:28.000000Z"}]},{"id":6018123,"change_date":"2024-06-18 21:42:00","inspection_id":"81901999","dot_number":"436966","report_state":"IA","report_number":"000P14XHP7","insp_date":"2024-06-17 00:00:00","insp_start_time":"1445","insp_end_time":"1515","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"52 AND ROURKE","county_code_state":"IA","county_code":"061","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"FLYNN","shipping_paper_number":"915010919","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":"2024-06-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"8","oos_total":"2","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1317297","transaction_code":"A","transaction_date":"2024-06-18 00:00:00","upload_date":"2024-06-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00436966","upload_search_indicator":"M","census_search_date":"2024-06-18 21:42:00","snet_input_date":"2024-06-17 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-06-18 21:42:00","insp_carrier_name":"FLYNN COMPANY INC","insp_carrier_street":"800 JULIEN DUBUQUE DR","insp_carrier_city":"DUBUQUE","insp_carrier_state":"IA","insp_carrier_zip_code":"52004-7014","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:21:55.000000Z","updated_at":"2025-03-17T20:21:55.000000Z","inspection_violations":[{"id":9337195,"change_date":"2024-06-18 21:42:00","inspection_id":"81901999","insp_violation_id":"260171593","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"1DOE24061715050","created_at":"2025-03-17T21:51:09.000000Z","updated_at":"2025-03-17T21:51:09.000000Z","normalized_code":"3922"},{"id":9337196,"change_date":"2024-06-18 21:42:00","inspection_id":"81901999","insp_violation_id":"260171594","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"1DOE24061715054","created_at":"2025-03-17T21:51:09.000000Z","updated_at":"2025-03-17T21:51:09.000000Z","normalized_code":"3922"},{"id":9337197,"change_date":"2024-06-18 21:42:00","inspection_id":"81901999","insp_violation_id":"260171595","seq_no":"3","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"201468116","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:09.000000Z","updated_at":"2025-03-17T21:51:09.000000Z","normalized_code":"39395A"},{"id":9337198,"change_date":"2024-06-18 21:42:00","inspection_id":"81901999","insp_violation_id":"260171596","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201468116","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:51:09.000000Z","updated_at":"2025-03-17T21:51:09.000000Z","normalized_code":"3939A"},{"id":9337199,"change_date":"2024-06-18 21:42:00","inspection_id":"81901999","insp_violation_id":"260171597","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201468116","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:09.000000Z","updated_at":"2025-03-17T21:51:09.000000Z","normalized_code":"3939A"},{"id":9337200,"change_date":"2024-06-18 21:42:00","inspection_id":"81901999","insp_violation_id":"260171598","seq_no":"6","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"201468116","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:09.000000Z","updated_at":"2025-03-17T21:51:09.000000Z","normalized_code":"39378"},{"id":9337201,"change_date":"2024-06-18 21:42:00","inspection_id":"81901999","insp_violation_id":"260171599","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201468116","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:09.000000Z","updated_at":"2025-03-17T21:51:09.000000Z","normalized_code":"3939A"},{"id":9337202,"change_date":"2024-06-18 21:42:00","inspection_id":"81901999","insp_violation_id":"260171600","seq_no":"8","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"201468116","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:51:09.000000Z","updated_at":"2025-03-17T21:51:09.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":9692988,"change_date":"2024-06-18 21:42:00","inspection_id":"81901999","insp_unit_id":"201468116","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"104","insp_unit_license":"FW7148","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1M2P337C14M034420","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:27.000000Z","updated_at":"2025-03-17T23:23:27.000000Z"}]},{"id":5425044,"change_date":"2024-04-03 21:41:00","inspection_id":"81257045","dot_number":"436966","report_state":"IA","report_number":"000P12DZ3P","insp_date":"2024-04-02 00:00:00","insp_start_time":"0941","insp_end_time":"1130","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"SB HWY 151 \/ STONE RD","county_code_state":"IA","county_code":"113","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"142000","viol_total":"9","oos_total":"2","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1308091","transaction_code":"A","transaction_date":"2024-04-03 00:00:00","upload_date":"2024-04-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00436966","upload_search_indicator":"M","census_search_date":"2024-04-03 21:41:00","snet_input_date":"2024-04-02 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-04-03 21:41:00","insp_carrier_name":"FLYNN COMPANY INC","insp_carrier_street":"800 JULIEN DUBUQUE DR","insp_carrier_city":"DUBUQUE","insp_carrier_state":"IA","insp_carrier_zip_code":"52004-7014","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:10:16.000000Z","updated_at":"2025-03-17T20:10:16.000000Z","inspection_violations":[{"id":8376229,"change_date":"2024-04-03 21:41:00","inspection_id":"81257045","insp_violation_id":"258725878","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200215510","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:31.000000Z","updated_at":"2025-03-17T21:46:31.000000Z","normalized_code":"3922"},{"id":8376230,"change_date":"2024-04-03 21:41:00","inspection_id":"81257045","insp_violation_id":"258725879","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200215510","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:31.000000Z","updated_at":"2025-03-17T21:46:31.000000Z","normalized_code":"3922"},{"id":8376231,"change_date":"2024-04-03 21:41:00","inspection_id":"81257045","insp_violation_id":"258725880","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"200215511","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:31.000000Z","updated_at":"2025-03-17T21:46:31.000000Z","normalized_code":"3939A"},{"id":8376232,"change_date":"2024-04-03 21:41:00","inspection_id":"81257045","insp_violation_id":"258725881","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"200215511","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:31.000000Z","updated_at":"2025-03-17T21:46:31.000000Z","normalized_code":"3922"},{"id":8376233,"change_date":"2024-04-03 21:41:00","inspection_id":"81257045","insp_violation_id":"258725882","seq_no":"5","part_no":"393","part_no_section":"104(b)","insp_viol_unit":"2","insp_unit_id":"200215511","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:31.000000Z","updated_at":"2025-03-17T21:46:31.000000Z","normalized_code":"393104B"},{"id":8376234,"change_date":"2024-04-03 21:41:00","inspection_id":"81257045","insp_violation_id":"258725883","seq_no":"6","part_no":"393","part_no_section":"130","insp_viol_unit":"2","insp_unit_id":"200215511","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"7THA24040211042","created_at":"2025-03-17T21:46:31.000000Z","updated_at":"2025-03-17T21:46:31.000000Z","normalized_code":"393130"},{"id":8376235,"change_date":"2024-04-03 21:41:00","inspection_id":"81257045","insp_violation_id":"258725884","seq_no":"7","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"200215510","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:46:31.000000Z","updated_at":"2025-03-17T21:46:31.000000Z","normalized_code":"39345B2"},{"id":8376236,"change_date":"2024-04-03 21:41:00","inspection_id":"81257045","insp_violation_id":"258725885","seq_no":"8","part_no":"391","part_no_section":"41(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:31.000000Z","updated_at":"2025-03-17T21:46:31.000000Z","normalized_code":"39141A1"},{"id":8376237,"change_date":"2024-04-03 21:41:00","inspection_id":"81257045","insp_violation_id":"258725886","seq_no":"9","part_no":"393","part_no_section":"87(a)","insp_viol_unit":"2","insp_unit_id":"200215511","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:31.000000Z","updated_at":"2025-03-17T21:46:31.000000Z","normalized_code":"39387A"}],"inspection_per_units":[{"id":8738306,"change_date":"2024-04-03 21:41:00","inspection_id":"81257045","insp_unit_id":"200215510","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"716","insp_unit_license":"DX2797","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1M1AW07Y2GM059536","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:16.000000Z","updated_at":"2025-03-17T23:14:16.000000Z"},{"id":8738307,"change_date":"2024-04-03 21:41:00","inspection_id":"81257045","insp_unit_id":"200215511","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LOAK","insp_unit_company":"804","insp_unit_license":"CT0931","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5LKL5335051025491","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:16.000000Z","updated_at":"2025-03-17T23:14:16.000000Z"}]},{"id":3973135,"change_date":"2023-09-14 21:41:00","inspection_id":"79662985","dot_number":"436966","report_state":"IA","report_number":"000TT68VP1","insp_date":"2023-09-13 00:00:00","insp_start_time":"1410","insp_end_time":"1435","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 20 EB EXIT\/ HWY 136","county_code_state":"IA","county_code":"061","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"FLYNN CO","shipping_paper_number":"1462183","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-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1289237","transaction_code":"A","transaction_date":"2023-09-14 00:00:00","upload_date":"2023-09-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00436966","upload_search_indicator":"M","census_search_date":"2023-09-14 21:41:00","snet_input_date":"2023-09-13 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-09-14 21:41:00","insp_carrier_name":"FLYNN COMPANY INC","insp_carrier_street":"800 JULIEN DUBUQUE DR","insp_carrier_city":"DUBUQUE","insp_carrier_state":"IA","insp_carrier_zip_code":"52004-7014","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:41:14.000000Z","updated_at":"2025-03-17T19:41:14.000000Z","inspection_violations":[{"id":6144957,"change_date":"2023-09-14 21:41:00","inspection_id":"79662985","insp_violation_id":"255266723","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"42","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:42.000000Z","updated_at":"2025-03-17T21:35:42.000000Z","normalized_code":"3922"},{"id":6144958,"change_date":"2023-09-14 21:41:00","inspection_id":"79662985","insp_violation_id":"255266724","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197053564","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:42.000000Z","updated_at":"2025-03-17T21:35:42.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6388580,"change_date":"2023-09-14 21:41:00","inspection_id":"79662985","insp_unit_id":"197053564","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"3722","insp_unit_license":"FP8851","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5KJNALD1XNPNF0262","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:38.000000Z","updated_at":"2025-03-17T22:53:38.000000Z"},{"id":6388581,"change_date":"2023-09-14 21:41:00","inspection_id":"79662985","insp_unit_id":"197053565","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LOAK","insp_unit_company":"3219","insp_unit_license":"FB3421","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5LKL49361K1031181","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:38.000000Z","updated_at":"2025-03-17T22:53:38.000000Z"}]},{"id":3012762,"change_date":"2023-05-10 21:42:00","inspection_id":"78584978","dot_number":"436966","report_state":"IA","report_number":"000TT69WXP","insp_date":"2023-05-08 00:00:00","insp_start_time":"1708","insp_end_time":"1730","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"SB I29 - MM 128  SLOAN","county_code_state":"IA","county_code":"193","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"BOBTAIL","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-10 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1274317","transaction_code":"A","transaction_date":"2023-05-10 00:00:00","upload_date":"2023-05-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00436966","upload_search_indicator":"M","census_search_date":"2023-05-10 21:42:00","snet_input_date":"2023-05-08 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-05-10 21:42:00","insp_carrier_name":"FLYNN COMPANY INC","insp_carrier_street":"800 JULIEN DUBUQUE DR","insp_carrier_city":"DUBUQUE","insp_carrier_state":"IA","insp_carrier_zip_code":"52004-7014","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:22:38.000000Z","updated_at":"2025-03-17T19:22:38.000000Z","inspection_violations":[{"id":4627289,"change_date":"2023-05-10 21:42:00","inspection_id":"78584978","insp_violation_id":"252746750","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194856667","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"T22323050817092","created_at":"2025-03-17T21:28:34.000000Z","updated_at":"2025-03-17T21:28:34.000000Z","normalized_code":"3939A"},{"id":4627290,"change_date":"2023-05-10 21:42:00","inspection_id":"78584978","insp_violation_id":"252746751","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194856667","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:34.000000Z","updated_at":"2025-03-17T21:28:34.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":4847108,"change_date":"2023-05-10 21:42:00","inspection_id":"78584978","insp_unit_id":"194856667","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"3722","insp_unit_license":"FP8851","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5KJNALD1XNPNF0262","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:12.000000Z","updated_at":"2025-03-17T22:41:12.000000Z"}]},{"id":2827587,"change_date":"2023-04-18 21:42:00","inspection_id":"78375548","dot_number":"436966","report_state":"IA","report_number":"000TT6J5P5","insp_date":"2023-04-17 00:00:00","insp_start_time":"1336","insp_end_time":"1350","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 61 & 160TH","county_code_state":"IA","county_code":"057","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"FLYNN CO.","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"71090","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":"1271226","transaction_code":"A","transaction_date":"2023-04-18 00:00:00","upload_date":"2023-04-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00436966","upload_search_indicator":"M","census_search_date":"2023-04-18 21:42:00","snet_input_date":"2023-04-17 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-04-18 21:42:00","insp_carrier_name":"FLYNN COMPANY INC","insp_carrier_street":"800 JULIEN DUBUQUE DR","insp_carrier_city":"DUBUQUE","insp_carrier_state":"IA","insp_carrier_zip_code":"52004-7014","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:18:54.000000Z","updated_at":"2025-03-17T19:18:54.000000Z","inspection_violations":[{"id":4338931,"change_date":"2023-04-18 21:42:00","inspection_id":"78375548","insp_violation_id":"252284747","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:27:15.000000Z","updated_at":"2025-03-17T21:27:15.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4551324,"change_date":"2023-04-18 21:42:00","inspection_id":"78375548","insp_unit_id":"194444935","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"4211","insp_unit_license":"SE8832","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1NPSX0EX6BD115121","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:54.000000Z","updated_at":"2025-03-17T22:38:54.000000Z"}]},{"id":1015757,"change_date":"2022-08-11 21:38:00","inspection_id":"76295843","dot_number":"436966","report_state":"IA","report_number":"000TT6JVQQ","insp_date":"2022-08-10 00:00:00","insp_start_time":"0915","insp_end_time":"0945","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"SOUTH BOUND HIGHWAY 65","county_code_state":"IA","county_code":"153","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"FLYNN COMPANY","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":"2022-08-11 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"13200","viol_total":"3","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1237281","transaction_code":"A","transaction_date":"2022-08-11 00:00:00","upload_date":"2022-08-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00436966","upload_search_indicator":"M","census_search_date":"2022-08-11 21:38:00","snet_input_date":"2022-08-10 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-08-11 21:38:00","insp_carrier_name":"FLYNN COMPANY INC","insp_carrier_street":"800 JULIEN DUBUQUE DR","insp_carrier_city":"DUBUQUE","insp_carrier_state":"IA","insp_carrier_zip_code":"52004-7014","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:45:28.000000Z","updated_at":"2025-03-17T18:45:28.000000Z","inspection_violations":[{"id":1599273,"change_date":"2022-08-11 21:38:00","inspection_id":"76295843","insp_violation_id":"247653280","seq_no":"1","part_no":"391","part_no_section":"11(b)(5)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"T32122081009223","created_at":"2025-03-17T21:14:30.000000Z","updated_at":"2025-03-17T21:14:30.000000Z","normalized_code":"39111B5"},{"id":1599274,"change_date":"2022-08-11 21:38:00","inspection_id":"76295843","insp_violation_id":"247653281","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190257179","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:30.000000Z","updated_at":"2025-03-17T21:14:30.000000Z","normalized_code":"3939A"},{"id":1599275,"change_date":"2022-08-11 21:38:00","inspection_id":"76295843","insp_violation_id":"247653282","seq_no":"3","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"190257179","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:30.000000Z","updated_at":"2025-03-17T21:14:30.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":1634239,"change_date":"2022-08-11 21:38:00","inspection_id":"76295843","insp_unit_id":"190257179","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":"1-313","insp_unit_license":"CCG669","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GB3CZCG4DF220685","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:17.000000Z","updated_at":"2025-03-17T22:18:17.000000Z"}]},{"id":904647,"change_date":"2022-07-27 21:41:00","inspection_id":"76165669","dot_number":"436966","report_state":"IA","report_number":"000TT8D8Q3","insp_date":"2022-07-26 00:00:00","insp_start_time":"0722","insp_end_time":"0740","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 34","county_code_state":"IA","county_code":"101","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"144740","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":"1235011","transaction_code":"A","transaction_date":"2022-07-27 00:00:00","upload_date":"2022-07-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00436966","upload_search_indicator":"M","census_search_date":"2022-07-27 21:41:00","snet_input_date":"2022-07-26 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-07-27 21:41:00","insp_carrier_name":"FLYNN COMPANY INC","insp_carrier_street":"800 JULIEN DUBUQUE DR","insp_carrier_city":"DUBUQUE","insp_carrier_state":"IA","insp_carrier_zip_code":"52004-7014","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:43:41.000000Z","updated_at":"2025-03-17T18:43:41.000000Z","inspection_violations":[{"id":1426647,"change_date":"2022-07-27 21:41:00","inspection_id":"76165669","insp_violation_id":"247346361","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":"T12622072607333","created_at":"2025-03-17T21:13:45.000000Z","updated_at":"2025-03-17T21:13:45.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1456087,"change_date":"2022-07-27 21:41:00","inspection_id":"76165669","insp_unit_id":"189992632","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"3722","insp_unit_license":"FP8851","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5KJNALD1XNPNF0262","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:09.000000Z","updated_at":"2025-03-17T22:17:09.000000Z"},{"id":1456088,"change_date":"2022-07-27 21:41:00","inspection_id":"76165669","insp_unit_id":"189992633","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LOAK","insp_unit_company":"1","insp_unit_license":"EN0968","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5LKL5335X91027416","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:09.000000Z","updated_at":"2025-03-17T22:17:09.000000Z"}]},{"id":904687,"change_date":"2022-07-27 21:41:00","inspection_id":"76165717","dot_number":"436966","report_state":"IA","report_number":"000TT6M3B3","insp_date":"2022-07-26 00:00:00","insp_start_time":"1200","insp_end_time":"1225","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"US 34","county_code_state":"IA","county_code":"087","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"FLYNN","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"212000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"1","hazmat_oos_total":"0","snet_sequence_id":"1234921","transaction_code":"A","transaction_date":"2022-07-27 00:00:00","upload_date":"2022-07-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00436966","upload_search_indicator":"M","census_search_date":"2022-07-27 21:41:00","snet_input_date":"2022-07-26 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-07-27 21:41:00","insp_carrier_name":"FLYNN COMPANY INC","insp_carrier_street":"800 JULIEN DUBUQUE DR","insp_carrier_city":"DUBUQUE","insp_carrier_state":"IA","insp_carrier_zip_code":"52004-7014","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:43:41.000000Z","updated_at":"2025-03-17T18:43:41.000000Z","inspection_violations":[{"id":1426719,"change_date":"2022-07-27 21:41:00","inspection_id":"76165717","insp_violation_id":"247346488","seq_no":"1","part_no":"172","part_no_section":"602(a)","insp_viol_unit":"1","insp_unit_id":"189992727","insp_violation_category_id":"38","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:45.000000Z","updated_at":"2025-03-17T21:13:45.000000Z","normalized_code":"172602A"},{"id":1426720,"change_date":"2022-07-27 21:41:00","inspection_id":"76165717","insp_violation_id":"247346489","seq_no":"2","part_no":"107","part_no_section":"620(b)","insp_viol_unit":"1","insp_unit_id":"189992727","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:45.000000Z","updated_at":"2025-03-17T21:13:45.000000Z","normalized_code":"107620B"}],"inspection_per_units":[{"id":1456160,"change_date":"2022-07-27 21:41:00","inspection_id":"76165717","insp_unit_id":"189992727","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"3722","insp_unit_license":"FP8851","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5KJNALD1XNPNF0262","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:09.000000Z","updated_at":"2025-03-17T22:17:09.000000Z"},{"id":1456161,"change_date":"2022-07-27 21:41:00","inspection_id":"76165717","insp_unit_id":"189992728","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LOAK","insp_unit_company":"3219","insp_unit_license":"FB3421","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5LKL49361K1031181","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:09.000000Z","updated_at":"2025-03-17T22:17:09.000000Z"}]}],"first_page_url":"https:\/\/www.searchcarriers.com\/company\/436966\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/www.searchcarriers.com\/company\/436966\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/www.searchcarriers.com\/company\/436966\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next »","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/www.searchcarriers.com\/company\/436966\/inspections","per_page":100,"prev_page_url":null,"to":19,"total":19}