Aerospatiale ATR 72-212
Service difficulty reports · 4,441
Newest first. General aviation reporting is voluntary.
Query with SQL
duckdb -csv -c "SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE aircraft_model_key = 'ATR72212' ORDER BY difficulty_date DESC"
Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE aircraft_model_key = 'ATR72212' ORDER BY difficulty_date DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
SDR SDR2005081Odor · detectedWHILE TAXIING, BURNING ODOR NOTICED BY THE FLIGHT CREW. VISUALLY INSPECTED ALL OVERHEAD BINS WIRING BUNDLES AND FOUND NO EVIDENCE OF BURNING. OPERATIONAL CHECK OF ALL SYSTEMS PERFORMED AND FOUND SATISFACTORY. (K)SDR ASOA051044Lamp · burned outDURING A HANGAR INSPECTION, THE EMERGENCY LIGHT ON THE PASSENGER DOOR WAS FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE LAMP IN THE EMERGENCY LIGHT ON THE PASSENGER DOOR. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (K)SDR ASOA051038Fuse · burned outDURING A GROUND INSPECTION, THE EMERGENCY LIGHT, NEAR THE FRONT DOOR, WAS FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE FUSE IN THE POWER SUPPLY UNIT. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (K)SDR ASOA051033Lamp · burned outDURING A GROUND INSPECTION IN MGM, THE EMERGENCY EXIT SIGN, ABOVE THE FLIGHT ATTENDANTS SEAT, WAS FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE LAMP IN THE EMERGENCY EXIT SIGN, ABOVE THE FLIGHT ATTENDANTS SEAT. OPS CHECKS GOOD. AIRCRAFT OK FSDR ASOA05915Engine · malfunctionedFLT 4086 - DURING DESCENT INTO ATL FROM AGS, AT APPROX 9,000 FEET THE CREW NOTICED THE RIGHT ENGINE TORQUE AT APPROX 20 PERCENT AND THE NP AT APPROX 35 PERCENT WITH ALL OTHER INDICATIONS SHOWING NORMAL WHICH WAS FOLLOWED BY A LARGE YAW TO THE RIGHT AND VIBRATISDR ASOA051017Control Panel · malfunctionedDURING TAXI TO THE GATE IN MCN, THE EMERGENCY LIGHTS CAME ON WHILE IN THE ARM POSITION. WHEN ON WAS SELECTED THE EMERGENCY LIGHTS TURNED OFF. MAINTENANCE REMOVED AND REPLACED THE ANTI-ICE/MISCELLANEOUS 24VU LIGHT CONTROL PANEL. OPERATIONAL CHECKS GOOD. AIRSDR ASOA051012Light · malfunctionedDURING A GROUND INSPECTION IN ATL, THE EMERGENCY LIGHTS CAME ON THREE TIMES. MAINTENANCE PERFORMED OPERATIONAL CHECKS WITH NO DEFECTS NOTED. AIRCRAFT OK FOR SERVICE. (M)SDR ASOA051009Light · inoperativeDURING A GROUND INSPECTION IN AGS, THE EMERGENCY LIGHT ON THE PASSENGER DOOR WAS FOUND TO BE INOPERATIVE. MAINTENANCE INSPECTED THE PASSENGER DOOR LIGHT SYSTEM IAW ATR-72 AMM 33-51-11 WITH THE EMERGENCY SWITCHES ON. OPERATIONAL CHECKS WERE GOOD. NO DEFECTS SDR ASOA051000Lamp · inoperativeDURING HANGAR MAINTENANCE IN MCN, THE EMERGENCY LIGHT ON THE PASSENGER DOOR WAS FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE LAMP IN THE EMERGENCY LIGHT ON THE PASSENGER DOOR. OPERATIONAL CHECKS GOOD. (M)SDR ASOA05997Lamp · burned outDURING A HANGAR INSPECTION IN MCN, THE EMERGENCY LIGHT ASSEMBLY ON THE PASSENGER DOOR WAS FOUND TO BE INOPERATIVE.SDR ASOA05965Light · inoperativeFLT 4223 - DURING A GROUND INSPECTION IN MGM, THE EMERGENCY FLOOR TRACK LIGHT, NEAR SEAT 4B, WAS FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE LAMP IN THE EMERGENCY FLOOR TRACK LIGHT, NEAR SEAT 4B, AND RECONNECTED THE CANNON PLUG. (M)SDR SDR2005074Computer · malfunctionedDURING APPROACH, CREW REPORTED A FLAP UNLOCK INDICATION. EMERGENCY DECLARED. AIRCRAFT LANDED SAFELY. VISUAL INSPECTION AND OPERATIONAL CHECK PERFORMED AND FOUND NO DISCREPANCIES. MULTIFUNCTION COMPUTER RERACKED. FUNCTIONAL CHECK FLIGHT CONDUCTED AND FOUNDSDR ASOA05984Angle · corrodedDURING A C-CHECK IN YUL, THE ANGLE AT FS 39, BETWEEN STRINGER 21R-21L WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED THE ANGLE AT FS 39, BETWEEN STRINGER 21R-21L, IAW SRM 51-21-42 AND REPLACED THE ANGLE AT FS 39, BETWEEN STRINGER 21R-21 IAW SRM 5SDR ASOA05994Floor Support · corrodedDURING A C-CHECK IN YUL, THE LEFT SIDE FLOOR SUPPORT, BETWEEN FS 36-38, WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED THE LEFT SIDE FLOOR SUPPORT, BETWEEN FS 36-38, IAW SRM 51-25-01, AND REPLACED THE LEFT SIDE FLOOR SUPPORT, BETWEEN FS 36-38, IASDR ASOA05988Floor Support · corrodedDURING A C-CHECK IN YUL, THE LEFT AND RIGHT SIDE `Z` FLOOR SUPPORTS, BETWEEN FS 39-40, WERE FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE LEFT SIDE `Z` FLOOR SUPPORT, BETWEEN FS 39-40, IAW ASA EO 72-53-0200, AND REMOVED AND REPLACEDSDR ASOA05987Floorbeam · corrodedDURING A C-CHECK IN YUL, FLOORBEAM 41, AT BL 0, WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED FLOORBEAM 41, AT BL 0, IAW ASA EO 72-53-0174. (M)SDR ASOA05986Doubler · corrodedDURING A C-CHECK IN YUL, THE RIGHT SIDE DOUBLER, ON FRAME 39, WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE RIGHT SIDE DOUBLER, ON FRAME 39, IAW ASA EO 72-53-0194. (M)SDR ASOA05985Crease Beam · corrodedDURING A C-CHECK IN YUL, THE RIGHT SIDE CREASE BEAM, BETWEEN FS 39-40, WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE RIGHT SIDE CREASE BEAM, BETWEEN FS 39-40, IAW ASA EO 72-53-0195. (M)SDR ASOA05935Flashlight · inoperativeDURING GROUND INSPECTION IN ATL, THE AFT FLIGHT ATTENDANTS FLASHLIGHT WAS FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE AFT FLIGHT ATTENDANTS FLASHLIGHT. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (M)SDR ASOA05932Generator · malfunctionedDURING CRUISE FROM ATL-PFN, THE CREW REPORTED AN ELECTRICAL ODOR WITH A RIGHT AC WILD GENERATOR FAULT. AIRCRAFT CONTINUED TO PFN WHERE IT LANDED SAFELY. MAINTENANCE REMOVED AND REPLACED THE RIGHT AC WILD GENERATOR. OPERATIONAL CHECK GOOD. AIRCRAFT OK FOR SSDR ASOA05993Floorbeam · corrodedDURING A C-CHECK IN YUL, THE FLOORBEAM AT FS 40 WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE FLOORBEAM, AT FS 40, IAW ASA EO 72-53-0173. (M)SDR ASOA05992Floorbeam · corrodedDURING A C-CHECK IN YUL, THE FLOORBEAM, AT FS 39, WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED THE FLOORBEAM, AT FS 39, IAW SRM 51-25-01 AND REPLACED THE FLOORBEAM, AT FS 39, IAW ASA EO 72-53-0172.SDR ASOA05991Floorbeam · corrodedDURING A C-CHECK IN YUL, THE FLOORBEAM AT FS 38, WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE FLOORBEAM, AT FS 38, IAW ASA EO 72-53-0171. (M)SDR ASOA05990Floorbeam · corrodedDURING A C--CHECK IN YUL, THE FLOORBEAM AT FS 36 WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE FLOORBEAM AT FS 36, IAW ASA EO 72-53-0170. (M)SDR ASOA05989Frame · corrodedDURING A C-CHECK IN YUL, FRAME FRAME 23A, AT STRINGER 21R AND STRINGER 21L, WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED THE CORROSION ON FRAME FS 23A, AT STRINGER 21R AND STRINGER 21, IAW SRM 51-21-42. REPAIRED FRAME FS 23A, AT STRINGER 21R ASDR ASOA05922Light · inoperativeDURING HANGAR MAINTENANCE IN MCN, THE EMERGENCY LIGHT ON THE PASSENGER DOOR WAS FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE LAMP IN THE EMERGENCY LIGHT ON THE PASSENGER DOOR. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (M)SDR SDR2005069Indicator · faultyON SHORT FINAL, FLAPS EXTENSION FLAG REMAINED OUT AND FLAPS DID NOT LOCK AT 30 DEGREES. EMERGENCY DECLARED. AIRCRAFT LANDED WITH 15 DEGREES OF FLAPS. REPLACED FLAP INDICATOR. (K)SDR ASOA05912Doubler · corrodedDURING A C-CHECK IN YUL, THE UPPER AND LOWER STATIC BASE DOUBLERS, AT FS 48 WERE FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE UPPER AND LOWER STATIC BASE DOUBLERS AT FS 48, IAW AMM 20-21-12. (M)SDR ASOA05866Lamp · burned outFLT 4223 - DURING A GROUND INSPECTION IN MGM, THE EMERGENCY LIGHT ON THE PASSENGER DOOR WAS FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE LAMP IN THE EMERGENCY LIGHT ON THE PASSENGER DOOR. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (SDR ASOA05869Light · inoperativeDURING HANGAR MAINTENANCE IN MCN, THE EMERGENCY LIGHT ON THE PASSENGER DOOR WAS FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE EMERGENCY LIGHT ASSEMBLY ON THE PASSENGER DOOR. OPERATIONAL CHECK GOOD. (M)SDR ASOA05910Angle · corrodedDURING A C-CHECK IN YUL, THE ANGLE BETWEEN THE TAIL BUMPER BOX AND FS 39 WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE ANGLE BETWEEN THE TAIL BUMPER BOX AND FS 39 IAW SRM 51-25-01. (M)SDR ASOA05864Light · inoperativeDURING HANGAR MAINTENANCE IN MCN, THE EMERGENCY LIGHT ON THE PASSENGER DOOR WAS FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE EMERGENCY LIGHT ASSEMBLY ON THE PASSENGER DOOR. OPERATIONAL CHECKS GOOD. (M)SDR ASOA05860Light · inoperativeDURING HANGAR MAINTENANCE IN MCN, THE EMERGENCY LIGHT ON THE PASSENGER DOOR WAS FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE EMERGENCY LIGHT ON THE PASSENGER DOOR OPERATIONAL CHECKS GOOD. (M)SDR ASOA05911Retainer · corrodedDURING A C-CHECK IN YUL, THE SEAL RETAINERS, AT FS 45 AND FS 46, WERE FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE SEAL RETAINERS, AT FS 45 AND FS 48, IAW SRM 51-21-42 AND AMM 20-21-12. (M)SDR ASOA05905Stanchion · crackedDURING A C-CHECK IN YUL, THE LEFT STANCHION, AT FLOORBEAM 39, WAS FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE LEFT STANCHION, AT FS 39, IAW SRM 51-25-01. (M)SDR TRB2005F00007Wire Harness · intermittent(REF NR: SDR2005066) AFTER TAKEOFF, THE LANDING GEAR DID NOT RETRACT AND THE IDLE GATE DID NOT MOVE INTO THE FLIGHT POSITION. AIRCRAFT RETURNED TO AIRPORT. REPLACED MAIN LANDING GEAR HARNESS. (K)SDR ASOA05899Seat Track · corrodedDURING A C-CHECK IN YUL, THE SEAT TRACKS, BETWEEN FRAME 36-40, AT RBL 8, WERE FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACKS, BETWEEN FS 36-39, IAW ASA EO 72-53-0190, AND REPLACED THE SEAT TRACKS BETWEEN FS 36-39 IAW ASA SDR ASOA05900Seat Track · corrodedDURING A C-CHECK IN YUL, THE SEAT TRACKS, BETWEEN FRAME 36-41, AT LBL 4, WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK, BETWEEN FRAME 36-39 IAW ASA EO 72-53-0186 AND REMOVED AND REPLACED THE SEAT TRACKS BETWEEN FS 39-SDR ASOA05901Intercostal · corrodedDURING A C-CHECK IN YUL, THE INTERCOSTAL BETWEEN FS 36-38, LBL 35 WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE INTERCOSTAL, BETWEEN FS 36-38 LBL 35, IAW ASA EO 72-53-0187. (M)SDR ASOA05902Seat Track · corrodedDURING A C-CHECK IN YUL, THE SEAT TRACK, BETWEEN FS 41-42, RBL 18 OUTBOARD, WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED IAW ASA EO 72-53-0193. (M)SDR ASOA05903Floorbeam · corrodedDURING A C-CHECK IN YUL, THE FLOORBEAM AT FS 36, BETWEEN LBL 30 TO RBL 30, WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE FLOORBEAM AT FS 36, BETWEEN LBL 30 TO RBL 36 IAW ASA EO 72-53-0170. (M)SDR ASOA05904Floorbeam · corrodedDURING A C-CHECK IN YUL, THE FLOORBEAM AT FS 38, WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE FLOORBEAM AT FS 38 IAW ASA EO 72-53-0171. (M)SDR ASOA05906Floorbeam · corrodedDURING A C-CHECK IN YUL, THE FLOORBEAM, AT FS 39, WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE FLOORBEAM, AT FS 39, IAW ASA EO 72-53-0172. (M)SDR ASOA05907Floorbeam · corrodedDURING A C-CHECK IN YUL, THE FLOORBEAM, AT FS 40, WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE FLOORBEAM AT FS 40, IAW ASA EO 72-53-0173. (M)SDR ASOA05908Floorbeam · corrodedDURING A C-CHECK IN YUL, FLOORBEAM AT FS 41, BETWEEN BL 0 TO RBL 26, WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE FLOORBEAM AT FS 41, BETWEEN BL 0 TO RBL 26, IAW ASA EO 72-53-0184. (M)SDR ASOA05909Frame · corrodedDURING A C-CHECK IN YUL, THE FS 39, AND STRINGER 14R, WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE FS 39, AT STRINGER 14R, IAW ASA EO 72-53-0185.SDR ASOA05831Lamp · burned outDURING A GROUND INSPECTION IN ATL, THE EMERGENCY TRACK LIGHTS, NEAR SEATS 6A AND 6B WERE FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED EMERGENCY TRACK LIGHT LAMP, NEAR 6A AND 6B. OPERATIONAL CHECKS GOOD. (M)SDR 2005FA0001486Feeder Cable · chafedDURING INDUCTION INSPECTION FOR PASSENGER TO FREIGHTER CONVERSION MODIFICATION, INSPECTION REVEALED 2 AREAS OF SEVERE CHAFING RESULTING IN EXPOSURE OF CONDUCTOR WIRES FOR AC WILD FEEDERS AT RT SIDE CABIN AREA BETWEEN FRAMES 15-17 APPROXIMATELY STINGER 5R. (SWSDR ASOA05766Lamp · inoperativeDURING A GROUND INSPECTION IN MGM, THE FLIGHT COMPARTMENT OVERHEAD PANEL EMERGENCY EXIT LIGHT WAS FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE LAMP IN THE OVERHEAD PANEL EMERGENCY EXIT LIGHT. OPERATIONAL CHECKS GOOD. (M)SDR ASOA05761Lamp · inoperativeDURING AN A-CHECK IN MCN, THE EMERGENCY LIGHT ON THE PASSENGER DOOR WAS FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE LAMP IN THE EMERGENCY LIGHT ASSEMBLY ON THE PAX DOOR. OPERATIONAL CHECKS GOOD. (M)
Back to Aerospatiale ATR 72-212