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 ASOA04612Light · inoperativeDURING AN A-CHECK 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. AIRCRAFT OK FOR SERVICE. (M)SDR ASOA04614Lens · damagedDURING AN A-CHECK IN MCN, THE EMERGENCY EXIT LIGHT LENS AT ROW 1 WAS FOUND NEEDING REPLACEMENT. MAINTENANCE REMOVED AND REPLACED THE EMERGENCY EXIT LIGHT LENS AT ROW 1. (M)SDR 2004F00353Sensor · erraticABORTED TAKEOFF DUE TO RIGHT ENGINE FIRE WARNING INDICATION. REPLACED RIGHT ENGINE FIRE SENSING ELEMENTS. (M)SDR ASOA04601Cover · brokenDURING A GROUND INSPECTION IN ATL, THE EMERGENCY EXIT SIGN COVER AT ROW ONE WAS FOUND BROKEN OFF. MAINTENANCE REMOVED AND REPLACED THE EMERGENCY EXIT SIGN COVER AT ROW ONE. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (M)SDR ASOA04581Wire · brokenFLT 4276 - DURING A GROUND INSPECTION IN ATL, THE WIRING TO THE TWO AFT EMERGENCY FLOOR LIGHTS WAS FOUND BROKEN AND THE LENS COVER LOOSE. MAINTENANCE RESECURED THE WIRING AND LENS COVER ONTHE TWO AFT EMERGENCY FLOOR LIGHT TRACKS. OPERATIONAL CHECKS GOOD. AISDR ASOA04568Light · damagedDURING HANGAR MAINTENANCE IN MCN, THE EMERGENCY EXIT LIGHT AT THE SERVICE DOOR WAS FOUND DAMAGED. MAINTENANCE REMOVED AND REPLACED THE EMERGENCY EXIT LIGHT ASSEMBLY AT THE SERVICE DOOR. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (M)SDR ASOA04567Odor · detectedDURING TAKEOFF FROM PFN-ATL, THE AIRCRAFT RECEIVED MULTIPLE BIRD STRIKES WITH ONE HITTING THE CAPTAINS WINDSHIELD AND ANOTHER ENTERING THE LT ENGINE INTAKE, FOLLOWED BY A STRONG ODOR IN THE AIRCRAFT. THE FLIGHT CONTINUED TO ATL WITH NO OTHER PROBLEMS NOTED. SDR ASOA04638Support Beam · corrodedDURNG A C-CHECK IN YUL, THE LEFT Z-SUPPORT BEAM BETWEEN FS 39 AND FS 40 WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE LEFT Z-SUPPORT BEAM BETWEEN FS 39 AND FS 40 IAW SRM 51-25-01. (M)SDR ASOA04637Guide · corrodedDURING A C-CHECK IN YUL, THE LEFT OUTBOARD FLAP NR 6 CAM GUIDE WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE LEFT OUTBOARD FLAP NR 6 CAM GUIDE IAW AMM 20-21-12. (M)SDR ASOA04631Floorbeam · 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 SRM 51-25-01. (M)SDR ASOA04632Guide · corrodedDURING A C-CHECK IN YUL, THE RIGHT INBOARD FLAP NR 1 CAM GUIDE AT RIB 4 WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE RIGHT INBOARD FLAP NR 1 CAM GUIDE AT RIB 4 IAW AMM 20-21-12. (M)SDR ASOA04636Guide · corrodedDURING A C-CHECK IN YUL, THE RIGHT OUTBOARD FLAP NR 4 CAM GUIDE AT RIB 17 WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE RIGHT OUTBOARD FLAP NR 4 CAM GUIDE AT RIB 17 IAW AMM 20-21-12. (M)SDR ASOA04633Guide · corrodedDURING A C-CHECK IN YUL, THE RIGHT INBOARD FLAP NR 2 CAM GUIDE AT RIB 5, AND THE RIGHT INBOARD FLAP NR 3 CAM GUIDE AT RIB 6 WERE FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE RIGHT INBOARD FLAP NR 2 CAM GUIDE AT RIB 5, AND THE RIGHTSDR ASOA04634Guide · corrodedDURING A C-CHECK IN YUL, THE RIGHT OUTBOARD FLAP NR 2 CAM GUIDE AT RIB 15 WAS FOUND TO BE CORRODED LIMITS. MAINTENANCE REMOVED AND REPLACED THE RIGHT OUTBOARD FLAP NR 2 CAM GUIDE AT RIB 15 IAW AMM 20-21-12. (M)SDR ASOA04635Guide · corrodedDURING A C-CHECK IN YUL, THE RIGHT OUTBOARD FLAP NR 3 CAM GUIDE AT RIB 16 WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE RIGHT OUTBOARD FLAP NR 3 CAM GUIDE AT RIB 16 IAW AMM 20-21-12. (M)SDR ASOA04561Door · malfunctionedFLT 4374 - DURING A GROUND INSPECTION IN ATL, THE PASSENGER DOOR WAS DIFFICULT TO CLOSE. MAINTENANCE CYCLED THE DOOR BUT COULD NOT DUPLICATE THE DISCREPANCY. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (M)SDR ASOA04627Seat Track · corrodedDURING A C-CHECK IN YUL, THE RIGHT INBOARD SEAT TRACK AT FS 36 TO 39, AND THE LEFT SEAT TRACK AT FS 36/38 WERE FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE RIGHT INBOARD SEAT TRACK AT FRAME 36 TO FRAME 39, AND THE LEFT SEAT TRACK ASDR ASOA04624Floorbeam · corrodedDURING A C-CHECK IN YUL, THE FLOORBEAMS AT FS 36 BETWEEN STRINERS 16R AND 16L, AND FS 38 BETWEEN STRINGERS 15R AND 15L WERE FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE FLOORBEAMS AT FS 36 BETWEEN STRINGERS 16R AND 16L, AND FS 38 BSDR ASOA04625Crease Beam · corrodedDURING A C-CHECK IN YUL, THE LEFT CREASE BEAM AT FS 39 WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE LEFT CREASE BEAM AT FS 39 IAW SRM 51-25-01. (M)SDR ASOA04626Seat Track · corrodedDURING A C-CHECK IN YUL, THE RIGHT INBOARD SEAT TRACK BETWEEN FRAME 35/36 WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE RIGHT INBOARD SEAT TRACK BETWEEN FRAME 35/36 IAW SRM 53-00-00, FIG 434 AND 53-21-04. (M)SDR ASOA04629Guide · corrodedDURING A CHECK IN YUL, THE NR 2 CAM GUIDE OUTBOARD ON THE LEFT OUTBOARD FLAP WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE NR 2 CAM GUIDE OUTBOARD ON THE LEFT OUTBOARD FLAP IAW AMM 20-21-12. (M)SDR ASOA04623Intercostal · corrodedDURING A C-CHECK IN YUL, THE LEFT INTERCOSTAL BETWEEN FS 36/38 WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE LEFT INTERCOSTAL BETWEEN FS 36/38 IAW SRM 51-25-01. (M)SDR ASOA04628Guide · corrodedDURING A C-CHECK IN YUL, THE NR 3 AND 4 CAM GUIDES OUTBOARD ON THE LEFT INBOARD FLAPS WERE FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE NR 3/4 CAM GUIDES OUTBOARD ON THE LEFT INBOARD FLAP IAW AMM 20-21-12. (M)SDR ASOA04622Intercostal · corrodedDUIRNG A C-CHECK IN YUL, THE LEFT AND RIGHT INTERCOSTALS AT FS 38/39 WERE FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE LEFT AND RIGHT INTERCOSTALS AT FS 38/39 IAW SRM 51-25-01. (M)SDR ASOA04630Guide · corrodedDURING A C-CHECK IN YUL, THE NR 5 AND 6 CAM GUIDES OUTBOARD ON THE LEFT INBOARD FLAP AS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE NR 5 AND 6 CAM GUIDES OUTBOARD ON THE LEFT INBOARD FLAP IAW AMM 20-21-12. (M)SDR ASOA04532Rib · crackedDURING A C-CHECK IN YUL, LEADING EDGE RIBS 6 AND 7 AT THE RIGHT INBOARD FLAP WERE FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED LEADING EDGE RIBS 6 AND 7 AT THE RIHT INBOARD FLAP IAW SRM 51-25-03 AND 51-25-01. (M)SDR ASOA04526Pin · misalignedFLT 4297 - DURING A GROUND INSPECTION IN ATL, THE FLIGHT ATTENDANT REPORTED THE PASSENGER DOOR WAS VERY HARD TO OPEN. MAINTENANCE RE-ADJUSTED THE UPPER AFT LATCH PIN ONTHE PASSENGER DOOR. OPS CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (M)SDR ASOA04527Bolt · missingFLT 4474 - DURING A GROUND INSPECTION IN TYS, THE PASSENGER DOOR WAS VERY HARD TO OPEN AND THE UPPER LEFT LOCKING PIN WOULD NOT ENGAGE. MAINTENANCE FOUND THE BOLT, WASHER AND NUT P/N NT113544CM, ON THE UPPER AFT LOCKING PIN CONNECTION ROD TO THE BELL CRANK MISDR 2004F00314Smoke · detectedDURING TAXI, ELECTRICAL SMOKE IN CABIN. INSPECTED CABIN LIGHTING SYSTEM, INCLUDING LATERAL LIGHTS SOCKETS AND READING LIGHTS CIRCUIT BOARDS AND FOUND NO EVIDENCE OF DAMAGE THAT COULD CAUSE THE SMOKE IN THE CABIN. (M)SDR ASOA04556Skin · dentedDURING A C-CHECK IN YUL, A DENT IN THE SKIN BETWEEN FS 38 AND FS 39, LEFT STRINGER 17 AND 18 WAS FOUND TO BE BEYOND LIMITS. MAINTENANCE REPAIRED THE SKIN BETWEEN FS 38/39, LEFT STRINGER 17 AND 18 IAW SRM 53-00-00. (M)SDR 2004F00275Engine · fireDURING TAXI, LEFT ENGINE FIRE INDICATOR ILLUMINATED, FIRE EXTINGUISHER DISCHARGED. REPLACED ENGINE. WAITING FOR TEARDOWN REPORT. (M)SDR ASOA04555Guide · corrodedDURNG A C-CHECK IN YUL, THE RIGHT OUTBOARD FLAP CAM GUIDE NR 4 FROM INBOARD WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE RIGHT OUTBOARD FLAP CAM GUIDE NR 4. (M)SDR ASOA04554Guide · corrodedDURING A C-CHECK IN YUL, THE RIGHT INBOARD FLAP CAM GUIDE NR 1 WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE RIGHT INBOARD FLAP CAM GUIDE NR 1 IAW AMM 20-21-12. (M)SDR ASOA04549Stanchion · bentDURING A C-CHECK IN YUL, THE RIGHT STANCHION UNDER THE FLOORBEAM AT FRAME 36 WAS FOUND TO BE BENT BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE RIGHT STANCHION UNDER THE FLOORBEAM AT FRAME 36 IAW SRM 51-25-00. (M)SDR ASOA04550Intercostal · corrodedDURING A C-CHECK IN YUL, THE LEFT INTERCOSTAL BETWEEN FRAME 38 AND FRAME 39 WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE LEFT INTERCOSTAL BETWEEN FRAME 38 AND FRAME 38 IAW SRM 51-25-01. (M)SDR ASOA04551Rib · crackedDURING A C-CHECK IN YUL, THE RIGHT INBOARD FLAP LEADING EDGE PICKUP RIB NR 7 FOR THE CAM GUIDE WAS FOUND TO BE CRAKED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE RIGHT INBOARD FLAP LEADING EDGE PICKUP RIB NR 7 FOR THE CAM GUIDE IAW SRM 51-25-03 AND 51SDR ASOA04552Rib · crackedDURING A C-CHECK IN YUL, THE RIGHT INBOARD FLAP LEADING EDGE PICKUP RIB NR 6 FOR THE CAM GUIDE NR 4 WAS FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE REMOVED AND EPLACED THE RIGHT INBOARD FLAP LEADING EDGE PICKUP RIB NR 6 FOR THE CAM GUIDE NR 4 IAW SRM 51-25SDR ASOA04553Skin · dentedDURING A C-CHECK IN YUL, A DENT IN THE LOWER FUSELAGE AT FS 10, NEAR STRINGER 21R WAS FOUND TO BE BEYOND LIMITS. MAINTENANCE REPAIRED THE SKIN AT FR 10, NEAR STRINGER 21R IAW SRM 53-00-00. (M)SDR ASOA04508Light · inoperativeDURING AN A-CHECK IN MCN, THE EMERGENCY LIGHT ON THE PASSENGER DOOR WAS FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE EMERGENCY LIGHT ASSEMBLY ON TH PASSENGER DOOR. OPS CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (M)SDR ASOA04547Support · corrodedDURING A C-CHECK IN YUL, THE RIGHT BOTTOM WALL SUPPORT BETWEEN FRAME 16 AND FRAME 17, RBL 14 WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE RIGHT BOTTOM WALL SUPPORT BETWEEN FRAME 16 AND FRAME 17, RBL 14 IAW SRM 51-25-00 AND 51-2SDR ASOA04545Seat Track · corrodedDURING A C-CHECK IN YUL, THE LEFT INBOARD SEAT TRACK BETWEEN FRAME 29 AND FRAME 36 WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE LEFT INBOARD SEAT TRACK BETWEEN FRAME 29 AND FRAME 36 IAW SRM 51-25-04. (M)SDR ASOA04546Seat Track · corrodedDURING A C-CHECK IN YUL, THE LEFT AND RIGHT INBOARD SEAT TRACK FROM FRAME 13 TO FRAME 17A WERE FOUND TO BE GOUGED AND CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE LEFT AND RIGHT INBOARD SEAT TRACKS FROM FRAME 13 TO FRAME 18 IAW SRM 51-25-01 ANSDR ASOA04548Intercostal · corrodedDURING A C-CHECK IN YUL, THE RIGHT INTERCOSTAL BETWEEN FRAME 38 AND FRAME 39 WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE RIGHT INTERCOSTAL BETWEEN FRAME 38 AND FRAME 39 IAW SRM 51-25-00. (M)SDR 2004F00400Odor · detectedELECTRICAL HEAT AND SMELL COMING FROM THE CIRCUIT BREAKER PANEL BEHIND F/O SEAT. VISUALLY INSPECTED CIRCUIT BREAKER PANELS, WIRING AND CONTACTORS AND OFUND NO EVIDENCE OF ELECTRICAL DAMAGE. (M)SDR ASOA04543Frame · crackedDURING A C-CHECK IN YUL, THE RIGHT WEB WING BOX AT FRAME 28A WAS FOND TO BE CRAKED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE RIGHT WEB WING BOX AT FRAME 28A IAW SRM 51-25-01. (M)SDR ASOA04544Bracket · crackedDURING A C-CHECK IN YUL, THE LEFT AND RIGHT UPPER WING BOX BRACKETS AT FRAME 26 WERE FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE LEFT AND RIGHT UPPER WING BOX BRACKETS AT FRAME 26 IAW SRM 51-25-04 AND 51-25-01. (M)SDR ASOA04540Floorbeam · corrodedDURING A C-CHECK IN YUL, THE FLOORBEAM AT FRAME 36 WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE FLOORBEAM AT FRAME 36 IAW SRM 51-25-01. (M)SDR ASOA04541Floorbeam · corrodedDURING A C-CHECK IN YUL, THE FLOORBEAM AT FRAME 39 AROUND THE NUT PLATES WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE FLOORBEAM AT FRAME 39 IAW SRM 51-25-01 AND 51-25-00. (M)SDR ASOA04539Seat Track · corrodedDURING A C-CHECK IN YUL, THE LEFT AND RIGHT SEAT TRACKS BETWEEN FRAME 37 TO FRAME 39 WERE FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE LEFT AND RIGHT SEAT TRACKS BETWEEN FRAME 37 TO FRME 39 IAW SRM 51-25-01 AND 51-25-04. (M)SDR ASOA04542Intercostal · corrodedDURING A C-CHECK IN YUL, THE LEFT INTERCOSTAL BETWEEN FRAME 36 AND FRAME 38 WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE LEFT INTERCOSTAL BETWEEN FRAME 36 AND FRAME 38 IAW SRM 51-25-01. (M)
Back to Aerospatiale ATR 72-212