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 98ZZZM701Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND CORROSION AT THE FOLLOWING TRACK LOCATIONS. LEFT FORWARD, MIDDLE AND AFT OUTBOARD, LEFT AFT INBOARD, LEFT AND RIGHT FLIGHT ATTENDANT SEAT SEAT TRACKS. THE RIGHT MIDDLE INBOARD AND OUTBOARD, AND THE RIGHT AFT CARGO SEAT TSDR 98ZZZM700Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND THE FOLLOWING TRACKS CORRODED. LEFT FORWARD, MIDDLE AND AFT OUTBOARD, LEFT AFT INBOARD, LEFT AND RIGHT FLIGHT ATTENDANT SEAT TRACKS. THE RIGHT MIDDLE INBOARD AND OUTBOARD, AND THE RIGHT AFT CARGO SEAT TRACKS CORRODED. RSDR 98ZZZM699Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND TRACK CORROSION AT THE FOLLOWING LOCATIONS. LEFT FORWARD,MIDDLE AND AFT OUTBOARD, LEFT AFT INBOARD, LEFT AND RIGHT FLIGH T ATTENDANT SEAT TRACKS. THE RIGHT MIDDLE INBOARD AND OUTBOARD, AND THE RIGHT AFT CARGO SEAT TRACKSSDR 98ZZZM698Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND CORROSION AT THE FOLLOWING LOCATIONS. LEFT FORWARD, MIDDLE AND AFT OUTBOARD, LEFT AFT INBOARD, LEFT AND RIGHT FLIGHT ATTENDANT SEAT TRACKS. THE RIGHT MIDDLE INBOARD AND OUTBOARD, AND THE RIGHT AFT CARGO SEAT TRACKS CORROSDR 98ZZZM697Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND CORROSION AT THE FOLLOWING TRACK LOCATIONS. LEFT FORWARD, MIDDLE AND AFT OUTBOARD, LEFT AFT INBOARD, LEFT AND RIGHT FLIGHT ATTENDANT SEAT TRACKS. THE RIGHT MIDDLE INBOARD AND OUTBOARD, AND THE RIGHT AFT CARGO SEAT TRACKSSDR SIMA982473Floorbeam · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND CORROSION AROUND NUT CLIP ON FLOORBEAM 36. INSTALLED SPLICE AND NEW SECTION OF FLOORBEAM. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA982462Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND RIGHT AFT INBOARD SEAT TRACK CORRODED. REMOVED AND REPLACED SEAT TRACK. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA982421Battery Pack · dischargedORD - FLT 4326 - FLOOR PROXIMITY LIGHTS DOES NOT ILLUMINATE AT THE FORWARD PART OF THE CABIN. REMOVED AND REPLACED BATTERY PACK AT SEAT ROW 4B. (M)SDR SIMA982353Housing · crackedTUL - FLT 3828 - LEFT ENGINE ACW GENERATOR FAULTED, AND ASSOCIATED ENGINE POWER LEVER WOULD NOT MOVE FROM FLIGHT IDLE FORWARD. POWER LEVER WOULD MOVE FROM FLT IDLE BACK THROUGH REVERSE. FOUND ACW GENERATOR COVER BROKEN OFF AND JAMMED AGAINST POWR LEVER CONTRSDR SIMA982344Seat Track · corrodedSAW - DURNIG CPCP-4 INSPECTION, FOUND THE LEFT FORWARD INBOARD AND OUTBOARD, LEFT MIDDLE INBOARD AND OUTBOARD, LEFT AFT INBOARD AND OUTBOARD, LEFT AND RIGHT AFT FLIGHT ATTENDANT, RIGHT AFT CARGO, RIGHT AFT INBOARD, RIGHT MIDDLE INBOARD AND OUTBOARD, RIGHT FORWSDR SIMA982343Zee Member · corrodedSAW - DURING CPCP-4 INSPECTION, FOUND THE RIGHT AFT ZEE MEMBER CORRODED BETWEEN FRAMES 39 AND 42. REMOVED AND REPLACED THE ZEE MEMBER AND FLOOR CHANNEL. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA982342Zee Member · corrodedSAW - DURING CPCP-4 INSPECTION, FOUND THE LEFT AFT ZEE MEMBER AND FLOOR CHANNEL CORRODED BETWEEN FRAMES 39 AND 40. REMOVED AND REPLACED THE ZEE MEMBER AND FLOOR CHANNEL. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA982331Battery Pack · dischargedDFW - FLT 3618 - WITH EMERGENCY LIGHT SWITCH DISARMED. FLOOR PROXIMITY LIGHTS ILLUMINATED. REMOVED AND REPLACED BATTERY PACK. OPERATIONAL CHECK GOOD. (M)SDR SIMA982312Floorbeam · corrodedSAW - DURING MBV-1 INSPECTION, FOUND FLOORBEAM 36.38 AND 39 CORRODED. REMOVED AND REPLACED THE FLOORBEAMS. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA982311Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND THE LEFT AFT INBOARD AND OUTBOARD, AND THE RIGHT MIDDLE INBOARD AND OUTBOARD SEAT TRACKS CORRODED. REMOVED AND REPLACD BOTH LEFT AFT SEAT TRACKS. REPAIRED BOTH RIGHT MIDDLE SEAT TRACKS. AIRCRAFT RETURNED TO SERVICE. (MSDR SIMA982233Floorbeam · corrodedSAW - DURING CPCP-4 INSPECTION, FOUND FLOORBEAM 39 CORRODED AROUND THE NUT PLATE ATTACH POINT ON THE RIGHT SIDE. REPAIRED FLOORBEAM. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA982232Sill · corrodedSAW - DURING CPCP-4 INSPECTION, FOUND THE SERVICE DOOR SILL PLATE CORRODED. REMOVED AND REPLACED SILL PLATE. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA982231Seat Track · corrodedSAW - DURING CPCP-4 INSPECTION, FOUND THE LEFT AFT INBOARD AND THE FLIGHT ATTENDANT SEAT TRACKS CORRODED. REMOVED AND REPLACED BOTH SEATS TRACKS. AIRCRAFT RETURNED TO SERVICE. (M)SDR 98ZZZM627Seat Track · corrodedSAW - DURING CPCP-4 INSPECTION, FOUND THE LEFT AFT INBOARD AND THE FLIGHT ATTENDANT SEAT TRACKS CORRODED. REMOVED AND REPLACED BOTH SEATS TRACKS. AIRCRAFT RETURNED TO SERVICE. (M)SDR C2XA98BT058Fuel Heater · brokenBTV - DURING 2A INSPECTION, PLANNING REQUESTED THE NR 2 ENGINE FUEL/OIL HEATER FILTER BE TIME-CHANGED. DURING REMOVAL OF BOWL AND FILTER, FOUND STUD BROKEN ON FILTER BOWL. REMOVED AND REPLACED FUEL/OIL HEATER ASSEMBLY. OPS AND LEAK CHECKS GOOD. (X)SDR SIMA982182Zee Member · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND LEFT AFT ZEE MEMBER, BETWEEN FRAME 39 AND 40 CORRODED. REMOVED AND REPLACED ZEE MEMBER. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA982181Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND LEFT FLIGHT ATTENDANT, LEFT AFT INBOARD AND OUTBOARD, LEFT AND RIGHT FORWARD OUTBOARD AND RIGHT MIDDLE SEAT TRACKS CORRODED. REMOVED AND REPLACED SEAT TRACKS. AIRCRAFT RETURNED TO SERVICE. (M)SDR 98ZZZM605Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND LEFT FLIGHT ATTENDANT, LEFT AFT INBOARD AND OUTBOARD, LEFT AND RIGHT FORWARD OUTBOARD AND RIGHT MIDDLE SEAT TRACKS CORRODED. REMOVED AND REPLACED SEAT TRACKS. AIRCRAFT RETURNED TO SERVICE. (M)SDR 98ZZZM604Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND LEFT FLIGHT ATTENDANT, LEFT AFT INBOARD AND OUTBOARD, LEFT AND RIGHT FORWARD OUTBOARD AND RIGHT MIDDLE SEAT TRACKS CORRODED. REMOVED AND REPLACED SEAT TRACKS. AIRCRAFT RETURNED TO SERVICE. (M)SDR 98ZZZM603Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND LEFT FLIGHT ATTENDANT, LEFT AFT INBOARD AND OUTBOARD, LEFT AND RIGHT FORWARD OUTBOARD AND RIGHT MIDDLE SEAT TRACKS CORRODED. REMOVED AND REPLACED SEAT TRACKS. AIRCRAFT RETURNED TO SERVICE. (M)SDR 98ZZZM602Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND LEFT FLIGHT ATTENDANT, LEFT AFT INBOARD AND OUTBOARD, LEFT AND RIGHT FORWARD OUTBOARD AND RIGHT MIDDLE SEAT TRACKS CORRODED. REMOVED AND REPLACED SEAT TRACKS. AIRCRAFT RETURNED TO SERVICE. (M)SDR 98ZZZM601Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND LEFT FLIGHT ATTENDANT, LEFT AFT INBOARD AND OUTBOARD, LEFT AND RIGHT FORWARD OUTBOARD AND RIGHT MIDDLE SEAT TRACKS CORRODED. REMOVED AND REPLACED SEAT TRACKS. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA982131Floorbeam · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND FLOORBEAM 36 CORRODED. REMOVED AND REPLACED FLOORBEAM 36. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA982082Floorbeam · corrodedSAW - DURING MBV-1 INSPECTION, FOUND FLOORBEAMS 36, 38, AND 39 CORRODED. REMOVED AND REPLACED THE FLOORBEAMS. AIRCRAFT RETURNED TO SERVICE. REF: OPER CONTROL NR 98ZZZX3287 AND 98ZZZX3288. (X)SDR 98ZZZX3288Floorbeam · corrodedSAW - DURING MBV-1 INSPECTION, FOUND FLOORBEAMS 36, 38, AND 39 CORRODED. REMOVED AND REPLACED THE FLOORBEAMS. AIRCRAFT RETURNED TO SERVICE. REF: OPER CONTROL NR SIMA982082 AND 98ZZZX3287.SDR 98ZZZX3287Floorbeam · corrodedSAW - DURING MBV-1 INSPECTION, FOUND FLOORBEAMS 36, 38, AND 39 CORRODED. REMOVED AND REPLACED THE FLOORBEAMS. AIRCRAFT RETURNED TO SERVICE. REF: OPER CONTROL NR SIMA982082 AND 98ZZZX3288.SDR SIMA982062Seat Tracks · corrodedSAW - DURING CPCP-4 INSPECTION, FOUND THE LT AND RT FLIGHT ATTENDANT, LT FORWARD INBD AND OTBD, LT MIDDLE AND AFT OTBD, LT AFT INBD, RT AFT CARGO, RT MIDDLE AND AFT OTBD, AND THE RT MIDDLE INBD SEAT TRACKS CORRODED. REMOVED AND REPLACED THE SEAT TRACKS. AIRCSDR SIMA982061Panel · corrodedDURING CPCP-4 INSPECTION, FOUND THE RT WING FEEDER TANK AND CENTER WING TANK ACCESS PANELS CORRODED. REMOVED AND REPLACED BOTH PANELS. AIRCRAFT RETURNED TO SERVICE. REF: OPERATOR CONTROL NR 98ZZZX3299. (X)SDR 98ZZZX3299Panel · corrodedDURING CPCP-4 INSPECTION, FOUND THE RT WING FEEDER TANK AND CENTER WING TANK ACCESS PANELS CORRODED. REMOVED AND REPLACED BOTH PANELS. AIRCRAFT RETURNED TO SERVICE. REF: OPERATOR CONTROL NR SIMA982061.SDR 98ZZZX3298Seat Tracks · corrodedSAW - DURING CPCP-4 INSPECTION, FOUND THE LT AND RT FLIGHT ATTENDANT, LT FORWARD INBD AND OTBD, LT MIDDLE AND AFT OTBD, LT AFT INBD, RT AFT CARGO, RT MIDDLE AND AFT OTBD, AND THE RT MIDDLE INBD SEAT TRACKS CORRODED. REMOVED AND REPLACED THE SEAT TRACKS. AIRCSDR 98ZZZX3297Seat Tracks · corrodedSAW - DURING CPCP-4 INSPECTION, FOUND THE LT AND RT FLIGHT ATTENDANT, LT FORWARD INBD AND OTBD, LT MIDDLE AND AFT OTBD, LT AFT INBD, RT AFT CARGO, RT MIDDLE AND AFT OTBD, AND THE RT MIDDLE INBD SEAT TRACKS CORRODED. REMOVED AND REPLACED THE SEAT TRACKS. AIRCSDR 98ZZZX3296Seat Tracks · corrodedSAW - DURING CPCP-4 INSPECTION, FOUND THE LT AND RT FLIGHT ATTENDANT, LT FORWARD INBD AND OTBD, LT MIDDLE AND AFT OTBD, LT AFT INBD, RT AFT CARGO, RT MIDDLE AND AFT OTBD, AND THE RT MIDDLE INBD SEAT TRACKS CORRODED. REMOVED AND REPLACED THE SEAT TRACKS. AIRCSDR 98ZZZX3295Seat Tracks · corrodedSAW - DURING CPCP-4 INSPECTION, FOUND THE LT AND RT FLIGHT ATTENDANT, LT FORWARD INBD AND OTBD, LT MIDDLE AND AFT OTBD, LT AFT INBD, RT AFT CARGO, RT MIDDLE AND AFT OTBD, AND THE RT MIDDLE INBD SEAT TRACKS CORRODED. REMOVED AND REPLACED THE SEAT TRACKS. AIRCSDR 98ZZZX3294Seat Tracks · corrodedSAW - DURING CPCP-4 INSPECTION, FOUND THE LT AND RT FLIGHT ATTENDANT, LT FORWARD INBD AND OTBD, LT MIDDLE AND AFT OTBD, LT AFT INBD, RT AFT CARGO, RT MIDDLE AND AFT OTBD, AND THE RT MIDDLE INBD SEAT TRACKS CORRODED. REMOVED AND REPLACED THE SEAT TRACKS. AIRCSDR 98ZZZX3293Seat Tracks · corrodedSAW - DURING CPCP-4 INSPECTION, FOUND THE LT AND RT FLIGHT ATTENDANT, LT FORWARD INBD AND OTBD, LT MIDDLE AND AFT OTBD, LT AFT INBD, RT AFT CARGO, RT MIDDLE AND AFT OTBD, AND THE RT MIDDLE INBD SEAT TRACKS CORRODED. REMOVED AND REPLACED THE SEAT TRACKS. AIRCSDR 98ZZZX3292Seat Tracks · corrodedSAW - DURING CPCP-4 INSPECTION, FOUND THE LT AND RT FLIGHT ATTENDANT, LT FORWARD INBD AND OTBD, LT MIDDLE AND AFT OTBD, LT AFT INBD, RT AFT CARGO, RT MIDDLE AND AFT OTBD, AND THE RT MIDDLE INBD SEAT TRACKS CORRODED. REMOVED AND REPLACED THE SEAT TRACKS. AIRCSDR 98ZZZX3291Seat Tracks · corrodedSAW - DURING CPCP-4 INSPECTION, FOUND THE LT AND RT FLIGHT ATTENDANT, LT FORWARD INBD AND OTBD, LT MIDDLE AND AFT OTBD, LT AFT INBD, RT AFT CARGO, RT MIDDLE AND AFT OTBD, AND THE RT MIDDLE INBD SEAT TRACKS CORRODED. REMOVED AND REPLACED THE SEAT TRACKS. AIRCSDR 98ZZZX3290Seat Tracks · corrodedSAW - DURING CPCP-4 INSPECTION, FOUND THE LT AND RT FLIGHT ATTENDANT, LT FORWARD INBD AND OTBD, LT MIDDLE AND AFT OTBD, LT AFT INBD, RT AFT CARGO, RT MIDDLE AND AFT OTBD, AND THE RT MIDDLE INBD SEAT TRACKS CORRODED. REMOVED AND REPLACED THE SEAT TRACKS. AIRCSDR 98ZZZX3289Seat Tracks · corrodedSAW - DURING CPCP-4 INSPECTION, FOUND THE LT AND RT FLIGHT ATTENDANT, LT FORWARD INBD AND OTBD, LT MIDDLE AND AFT OTBD, LT AFT INBD, RT AFT CARGO, RT MIDDLE AND AFT OTBD, AND THE RT MIDDLE INBD SEAT TRACKS CORRODED. REMOVED AND REPLACED THE SEAT TRACKS. AIRCSDR SIMA982051Zee Member · corrodedSAW DURING MBV-1 INSPECTION, FOUND THE LT AND RT AFT ZEE MEMBERS AND LT WEB BETWEEN FRAMES 39 AND 40 CORRODED. REMOVED AND REPLACED BOTH ZEE MEMBERS AND WEB. AIRCRAFT RETURNED TO SERVICE. REF: OPER CONTROL NR 98ZZZX3300 AND NR 98ZZZX3301. (X)SDR 98ZZZX3301Zee Member · corrodedSAW DURING MBV-1 INSPECTION, FOUND THE LT AND RT AFT ZEE MEMBERS AND LT WEB BETWEEN FRAMES 39 AND 40 CORRODED. REMOVED AND REPLACED BOTH ZEE MEMBERS AND WEB. AIRCRAFT RETURNED TO SERVICE. REF: OPER CONTROL NR SIMA98205-1 AND NR 98ZZZX3300.SDR 98ZZZX3300Zee Member · corrodedSAW DURING MBV-1 INSPECTION, FOUND THE LT AND RT AFT ZEE MEMBERS AND LT WEB BETWEEN FRAMES 39 AND 40 CORRODED. REMOVED AND REPLACED BOTH ZEE MEMBERS AND WEB. AIRCRAFT RETURNED TO SERVICE. REF: OPER CONTROL NR SIMA98205-1 AND NR 98ZZZX3301.SDR SIMA982002Battery Pack · dischargedGRR - FLT 5067 - EMERGENCY LIGHTS STAY ON. REMOVED AND REPLACED BATTERY PACKS AT 73WL, 63WL, AND 61WL. OPERATIONAL CHECK GOOD. (M)SDR SIMA981991Plate · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND THE LEFT AFT OUTBOARD SEAT TRACK JUNCTION PLATE BETWEEN FRAME 35 AND 36 TO BE CORRODED. REMOVED AND REPLACED THE JUNCTION PLATE. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA981986Floorbeam · corrodedSAW - DURING CPCP-2 INSPECTION, MAINTENANCE REPORTED FLOORBEAM 36 CORRODED. MAINTENANCE REMOVED AND REPLACED FLOORBEAM 36 IAW SRM 51-25-02. AIRCRAFT WAS RETURNED TO SERVICE. ACFT TT: 11,704.9 HOURS. ACFT TC: 12,665. (X)
Back to Aerospatiale ATR 72-212