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 SIMA992511Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND THE LEFT MIDDLE INBOARD AND OUTBOARD, THE LEFT AFT INBOARD AND OUTBOARD, AND THE RIGHT MIDDLE INBOARD AND OUTBOARD SEAT TRACKS CORRODED. REMOVED AND REPLACED THE SEAT TRACKS IAW EO E9-5300-013. AIRCRAFT RETURNED TO SERVISDR 99ZZZM694Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND THE LEFT MIDDLE INBOARD AND OUTBOARD, THE LEFT AFT INBOARD AND OUTBOARD, AND THE RIGHT MIDDLE INBOARD AND OUTBOARD SEAT TRACKS CORRODED. REMOVED AND REPLACED THE SEAT TRACKS IAW EO E9-5300-013. AIRCRAFT RETURNED TO SERVISDR 99ZZZM693Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND THE LEFT MIDDLE INBOARD AND OUTBOARD, THE LEFT AFT INBOARD AND OUTBOARD, AND THE RIGHT MIDDLE INBOARD AND OUTBOARD SEAT TRACKS CORRODED. REMOVED AND REPLACED THE SEAT TRACKS IAW EO E9-5300-013. AIRCRAFT RETURNED TO SERVISDR 99ZZZM692Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND THE LEFT MIDDLE INBOARD AND OUTBOARD, THE LEFT AFT INBOARD AND OUTBOARD, AND THE RIGHT MIDDLE INBOARD AND OUTBOARD SEAT TRACKS CORRODED. REMOVED AND REPLACED THE SEAT TRACKS IAW EO E9-5300-013. AIRCRAFT RETURNED TO SERVISDR 99ZZZM691Drain Track · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND THE PASSENGER DOOR SILL PLATE AND DRAIN TRACK CORRODED. REMOVED AND REPLACED THE PASSENGER DOOR SILL PLATE AND DRAIN TRACK IAW SRM 51-25-01 AND 51-25-02. AIRCRAFT RETURNED TO SERVICE. (M)SDR C2XA99BT084Light · inoperativeEWR - FLT 3354 - DURING MAINTENANCE, FOUND AIRSTAIR DOOR EMERGENCY EXIT LIGHT INOPERATIVE. REMOVED AND REPLACED AIRSTAIR DOOR EMERGENCY LIGHT ASSEMBLY. OPS CHECKED SYSTEM GOOD. (M)SDR SIMA992401Battery Pack · dischargedDFW - FLT 3506 - FORWARD EMERGENCY EXIT LIGHT, ONE OVERHEAD, AND EIGHT FLOOR PROXIMITY LIGHTS DO NOT ILLUMINATE. REPLACED BATTERY PACK AT LOCATION 61WL. OPERATIONAL CHECK NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR ASOA99083SGearbox · fracturedEN ROUTE TO ATL, LEFT ENGINE OIL PRESSURE DROPPED TO 0 PSI. CAPTAIN PERFORMED ENGINE FAILURE IN FLIGHT CHECKLIST, DECLARED AN EMERGENCY, AND PERFORMED A SAFE SINGLE ENGINE LANDING AT CSG. MCN MAINTENANCE CREW FOUND NR 3/4 BEARING OIL TUBE CRACKED. MAINTENANSDR ASOA99083Engine · failedEN ROUTE TO ATL, LEFT ENGINE OIL PRESSURE DROPPED TO 0 PSI. CAPTAIN PERFORMED ENGINE FAILURE IN FLIGHT CHECKLIST, DECLARED AN EMERGENCY, AND PERFORMED A SAFE SINGLE ENGINE LANDING AT CSG. MCN MAINTENANCE CREW FOUND NR 3/4 BEARING OIL TUBE CRACKED. MAINTENANSDR 99ZZZM653Battery · dischargedMAIN BATTERY KEEPS FALLING OUT (OFF). RECYCLED 2 AFTER TAKEOFF AND STAYS INOP. SMELL OF ELECTRICAL BURNING. REMOVED AND REPLACED MAIN BATTERY AS PER 24-31-85. FOUND MAIN BATTERY CHARGING SYSTEM WORKING PROPERLY AT THIS TIME. PERFORMED VISUAL INSPECTION. SDR SIMA992291Zee · corrodedDURING MBV-2 INSPECTION, FOUND RIGHT AFT ZEE MEMBER BETWEEN FRAMES 39 AND 42 CORRODED. MAINTENANCE REMOVED AND REPLACED THE ZEE MEMBER IAW SRM 51-25-03. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA992151Cam Guide · corrodedSAW - DURING MBV-2 INSPECTION, FOUND THE LEFT INBOARD FLAP INBOARD DEFLECTOR WITH THREE CAM GUIDES CORRODED, THE LEFT OUTBOARD FLAP INBOARD DEFLECTOR WITH TWO CAM GUIDES CORRODED, AND THE LEFT INBOARD FLAP OUTBOARD DEFLECTOR OUTBOARD CAM GUIDE CORRODED. REMOVSDR 99ZZZM618Cam Guide · corrodedSAW - DURING MBV-2 INSPECTION, FOUND THE LEFT INBOARD FLAP INBOARD DEFLECTOR WITH THREE CAM GUIDES CORRODED, THE LEFT OUTBOARD FLAP INBOARD DEFLECTOR WITH TWO CAM GUIDES CORRODED, AND THE LEFT INBOARD FLAP OUTBOARD DEFLECTOR OUTBOARD CAM GUIDE CORRODED. REMOVSDR SIMA992096Seat Track · corrodedSAW - DURING MBV-2 INSPECTION, FOUND THE LEFT AND RIGHT AFT FLIGHT ATTENDANT, THE LEFT AFT INBOARD AND OUTBOARD, THE RIGHT AFT INBOARD AND OUTBOARD, AND THE RIGHT MIDDLE INBOARD AND OUTBOARD SEAT TRACKS CORRODED. REMOVED AND REPLACED THE SEAT TRACKS IAW EO E9SDR SIMA992095Web · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND THE LEFT AFT WEB BETWEEN FRAMES 36 AND 38 CORRODED. REMOVED AND REPLACED THE WEB IAW 51-25-02. AIRCRAFT RETURNED TO SERVICE. (X)SDR SIMA992094Floorbeam · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND FLOORBEAMS 36 AND 38 WITH CORROSION AROUND THE NUTPLATE HOLES. REPAIRED FLOORBEAM 36 IAW SRM 53-00-00 FIGURE 435, AND REMOVED AND REPLACED FLOORBEAM 38 IAW SRM 51-25-04. AIRCRAFT RETURNED TO SERVICE. REF: OPER CNTRL NRSDR SIMA992093Floorbeam · misdrilledSAW - DURING MBV-2 INSPECTION, FOUND FLOORBEAM 29 WITH AN OVERSIZED HI-LOCK HOLE AT THE LEFT INBOARD SEAT TRACK CENTER ATTACH POINT. REPAIRED THE FLOORBEAM IAW SRM 53-00-00. AIRCRAFT RETURNED TO SERVICE. (X)SDR SIMA992092Zee Member · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND THE RIGHT AFT ZEE MEMBER BETWEEN FRAMES 39 AND 41 CORRODED. REMOVED AND REPLACED THE ZEE MEMBER IAW SRM 51-25-02. AIRCRAFT RETURNED TO SERVICE. (X)SDR 99ZZZX3058Seat Track · corrodedSAW - DURING MBV-2 INSPECTION, FOUND THE LEFT AND RIGHT AFT FLIGHT ATTENDANT, THE LEFT AFT INBOARD AND OUTBOARD, THE RIGHT AFT INBOARD AND OUTBOARD, AND THE RIGHT MIDDLE INBOARD AND OUTBOARD SEAT TRACKS CORRODED. REMOVED AND REPLACED THE SEAT TRACKS IAW EO E9SDR 99ZZZX3057Seat Track · corrodedSAW - DURING MBV-2 INSPECTION, FOUND THE LEFT AND RIGHT AFT FLIGHT ATTENDANT, THE LEFT AFT INBOARD AND OUTBOARD, THE RIGHT AFT INBOARD AND OUTBOARD, AND THE RIGHT MIDDLE INBOARD AND OUTBOARD SEAT TRACKS CORRODED. REMOVED AND REPLACED THE SEAT TRACKS IAW EO E9SDR 99ZZZX3056Seat Track · corrodedSAW - DURING MBV-2 INSPECTION, FOUND THE LEFT AND RIGHT AFT FLIGHT ATTENDANT, THE LEFT AFT INBOARD AND OUTBOARD, THE RIGHT AFT INBOARD AND OUTBOARD, AND THE RIGHT MIDDLE INBOARD AND OUTBOARD SEAT TRACKS CORRODED. REMOVED AND REPLACED THE SEAT TRACKS IAW EO E9SDR 99ZZZX3055Seat Track · corrodedSAW - DURING MBV-2 INSPECTION, FOUND THE LEFT AND RIGHT AFT FLIGHT ATTENDANT, THE LEFT AFT INBOARD AND OUTBOARD, THE RIGHT AFT INBOARD AND OUTBOARD, AND THE RIGHT MIDDLE INBOARD AND OUTBOARD SEAT TRACKS CORRODED. REMOVED AND REPLACED THE SEAT TRACKS IAW EO E9SDR 99ZZZX3054Seat Track · corrodedSAW - DURING MBV-2 INSPECTION, FOUND THE LEFT AND RIGHT AFT FLIGHT ATTENDANT, THE LEFT AFT INBOARD AND OUTBOARD, THE RIGHT AFT INBOARD AND OUTBOARD, AND THE RIGHT MIDDLE INBOARD AND OUTBOARD SEAT TRACKS CORRODED. REMOVED AND REPLACED THE SEAT TRACKS IAW EO E9SDR 99ZZZX3053Floorbeam · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND FLOORBEAMS 36 AND 38 WITH CORROSION AROUND THE NUTPLATE HOLES. REPAIRED FLOORBEAM 36 IAW SRM 53-00-00 FIGURE 435, AND REMOVED AND REPLACED FLOORBEAM 38 IAW SRM 51-25-04. AIRCRAFT RETURNED TO SERVICE. REF: OPER CNTRL NRSDR SIMA992022Zee · corrodedSAW - DURING HMBV-1 INSPECTION, FOUND THE LEFT AFT PASSENGER DOOR ZEE MEMBER CORRODED BETWEEN FRAMES 39 AND 40. REMOVED AND REPLACED THE ZEE MEMBER IAW SRM 52-11-30. AIRCRAFT RETURNED TO SERVICE. (X)SDR SIMA992021Frame · crackedSAW - DURING MBV-2 INSPECTION, FOUND THE THREE FORWARD UPPER FRAMES ON THE CARGO DOOR CRACKED. MAINTENANCE REPAIRED THE FRAMES IAW SRM 52-31-00 FIGURE 402. AIRCRAFT RETURNED TO SERVICE. REF: OPER CNTRL NR 99ZZZX2964 AND 99ZZZX2965. (X)SDR 99ZZZX2965Frame · crackedSAW - DURING MBV-2 INSPECTION, FOUND THE THREE FORWARD UPPER FRAMES ON THE CARGO DOOR CRACKED. MAINTENANCE REPAIRED THE FRAMES IAW SRM 52-31-00 FIGURE 402. AIRCRAFT RETURNED TO SERVICE. REF: OPER CNTRL NR SIMA992021 AND 99ZZZX2964.SDR 99ZZZX2964Frame · crackedSAW - DURING MBV-2 INSPECTION, FOUND THE THREE FORWARD UPPER FRAMES ON THE CARGO DOOR CRACKED. MAINTENANCE REPAIRED THE FRAMES IAW SRM 52-31-00 FIGURE 402. AIRCRAFT RETURNED TO SERVICE. REF: OPER CNTRL NR SIMA992021 AND 99ZZZX2965.SDR 99ZZZX2894Seat Track · corrodedSJU - HMV1 INSPECTION CRIC NR 7991 AT LT F/A SEAT TRACK IS CORRODED. BLENDED OUT CORROSION AND FOUND OUT OF LIMITS IAW SRM 53-00-00 PAGE 312 THROUGH 314. CAUSE OF DAMAGE, ENVIRONMENTAL. COMPLETED CORROSION REPAIR PER EO NR 9-5300-013R4 BY REMOVING AND REPLASDR SIMA991931Floorbeam · damagedSAW - DURING CPCP-2 INSPECTION, FOUND FLOORBEAMS 31, 33, AND 35 WITH ELONGATED HI-LOCK HOLES. REPAIRED THE THREE FLOORBEAMS IAW SRM 53-00-00 FIGURE 429. AIRCRAFT RETURNED TO SERVICE. REF: OPER CNTRL NR 99ZZZX.2817 THRU 99ZZZX2818. (X)SDR 99ZZZX2818Floorbeam · damagedSAW - DURING CPCP-2 INSPECTION, FOUND FLOORBEAMS 31, 33, AND 35 WITH ELONGATED HI-LOCK HOLES. REPAIRED THE THREE FLOORBEAMS IAW SRM 53-00-00 FIGURE 429. AIRCRAFT RETURNED TO SERVICE. REF: OPER CNTRL NR SIMA991931 AND 99ZZZX2817.SDR 99ZZZX2817Floorbeam · damagedSAW - DURING CPCP-2 INSPECTION, FOUND FLOORBEAMS 31, 33, AND 35 WITH ELONGATED HI-LOCK HOLES. REPAIRED THE THREE FLOORBEAMS IAW SRM 53-00-00 FIGURE 429. AIRCRAFT RETURNED TO SERVICE. REF: OPER CNTRL NR SIMA991931 AND 99ZZZX2818.SDR SIMA991903Fitting · corrodedSAW - DURING CPCP-2 INSPECTION, FOUND FORWARD T-FITTING ON THE PASSENGER DOOR SILL PLATE BETWEEN FRAMES 36 AND 38 CORRODED. REMOVED AND REPLACED T-FITTING IAW SRM 51-25-04. AIRCRAFT RETURNED TO SERVICE. (X)SDR SIMA991902Floorbeam · corrodedSAW - DURING CPCP-2 INSPECTION, FOUND FLOORBEAM 38 CORRODED. REMOVED AND REPLACED FLOORBEAM IAW SRM 51-25-02. AIRCRAFT RETURNED TO SERVICE. (X)SDR SIMA991901Seat Track · corrodedSAW - DURING CPCP-2 INSPECTION, FOUND LEFT AND RIGHT AFT INBOARD AND THE LEFT AND RIGHT MIDDLE INBOARD SEAT TRACKS CORRODED. REMOVED AND REPLACED SEAT TRACKS IAW EO E9-5300-013. AIRCRAFT RETURNED TO SERVICE. REF: OPER CNTRL NR 99ZZZX2811 THROUGH NR 99ZZZX2SDR 99ZZZX2813Seat Track · corrodedSAW - DURING CPCP-2 INSPECTION, FOUND LEFT AND RIGHT AFT INBOARD AND THE LEFT AND RIGHT MIDDLE INBOARD SEAT TRACKS CORRODED. REMOVED AND REPLACED SEAT TRACKS IAW EO E9-5300-013. AIRCRAFT RETURNED TO SERVICE. REPLACED 2 EACH. REF: OPER CNTRL NR SIMA991901SDR 99ZZZX2812Seat Track · corrodedSAW - DURING CPCP-2 INSPECTION, FOUND LEFT AND RIGHT AFT INBOARD AND THE LEFT AND RIGHT MIDDLE INBOARD SEAT TRACKS CORRODED. REMOVED AND REPLACED SEAT TRACKS IAW EO E9-5300-013. AIRCRAFT RETURNED TO SERVICE. REPLACED 2 EACH. REF: OPER CNTRL NR SIMA991901SDR 99ZZZX2811Seat Track · corrodedSAW - DURING CPCP-2 INSPECTION, FOUND LEFT AND RIGHT AFT INBOARD AND THE LEFT AND RIGHT MIDDLE INBOARD SEAT TRACKS CORRODED. REMOVED AND REPLACED SEAT TRACKS IAW EO E9-5300-013. AIRCRAFT RETURNED TO SERVICE. REPLACED 2 EACH. REF: OPER CNTRL NR SIMA991901SDR SIMA991894Floorbeam · corrodedSAW - DURING CPCP-2 INSPECTION, FOUND FLOORBEAM 36 CORRODED. REMOVED AND REPLACED FLOORBEAM IAW SRM 51-25-02. AIRCRAFT RETURNED TO SERVICE. (X)SDR SIMA991893Sill · corrodedSAW - DURING CPCP-2 INSPECTION, FOUND THE PASSENGER DOOR SILL PLATE AND DRAIN TRACK CORRODED. REMOVED AND REPLACED SILL PLATE AND DRAIN RACK IAW SRM 51-25-03. AIRCRAFT RETURNED TO SERVICE. REF: OPER CNTRL NR 99ZZZX2814. (X)SDR SIMA991892Zee Member · corrodedSAW - DURING CPCP-2 INSPECTION, FOUND THE RIGHT AFT ZEE MEMBER BETWEEN FRAMES 39 AND 41 CORRODED. REMOVED AND REPLACED THE ZEE MEMBER IAW SRM 51-25-02. AIRCRAFT RETURNED TO SERVICE. (X)SDR SIMA991891Support · corrodedSAW - DURING CPCP-2 INSPECTION, FOUND THE LEFT AFT FLOOR SUPPORT BETWEEN FRAMES 38 AND 39 CORRODED. REMOVED AND REPLACED FLOOR SUPPORT IAW SRM 51-25-01. AIRCRAFT RETURNED TO SERVICE. (X)SDR 99ZZZX2814Drain Track · corrodedSAW - DURING CPCP-2 INSPECTION, FOUND THE PASSENGER DOOR SILL PLATE AND DRAIN TRACK CORRODED. REMOVED AND REPLACED SILL PLATE AND DRAIN RACK IAW SRM 51-25-03. AIRCRAFT RETURNED TO SERVICE. REF: OPER CNTRL NR SIMA991893.SDR SIMA991841Engine · failedCRP - FLT 3642 - AT AN ALTITUDE OF APPROXIMATELY 10,000 FEET, THE RIGHT ENGINE OIL PRESSURE BEGAN TO DROP FOLLOWED BY THE ASSOCIATED OIL PRESSURE CAP ADVISTORY. WHILE THE CREW WAS C/W THE QRH, THE ENGINE SHUT DOWN UNCOMMANDED. FLIGHT ATTENDANT REPORTED SMOKESDR SIMA991823Floorbeam · oversized holeSAW - DURING MBV-2 INSPECTION, FOUND FLOORBEAM 36 WITH A HILOCK HOLE THAT WAS OVERSIZED BEYOND LIMITS. REPAIRED THE FLOORBEAM IAW SRM 53-00-00 PAGE 498. AIRCRAFT RETURNED TO SERVICE. (X)SDR SIMA991822Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND THE RT MIDDLE OUTBOARD, THE LEFT AFT OUTBOARD AND THE RIGHT AFT INBOARD SEAT TRACKS CORRODED. REMOVED AND REPLACED THE SEAT TRACKS IAW EO E9-5300-013. AIRCRAFT RETURNED TO SERVICE. OPER CNTRL NR 99ZZZX2815 AND 99ZZZX281SDR 99ZZZX2816Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND THE RT MIDDLE OUTBOARD, THE LEFT AFT OUTBOARD AND THE RIGHT AFT INBOARD SEAT TRACKS CORRODED. REMOVED AND REPLACED THE SEAT TRACKS IAW EO E9-5300-013. AIRCRAFT RETURNED TO SERVICE. OPER CNTRL NR SIMA991822 AND 99ZZZX281SDR 99ZZZX2815Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND THE RT MIDDLE OUTBOARD, THE LEFT AFT OUTBOARD AND THE RIGHT AFT INBOARD SEAT TRACKS CORRODED. REMOVED AND REPLACED THE SEAT TRACKS IAW EO E9-5300-013. AIRCRAFT RETURNED TO SERVICE. OPER CNTRL NR SIMA991822 AND 99ZZZX281SDR SIMA991766Seat Track · corrodedSAW - DURING CPCP-2 INSPECTION, FOUND LEFT FORWARD INBOARD AND OUTBOARD, LEFT AFT INBOARD AND OUTBOARD, RIGHT FLIGHT ATTENDANT, AND THE RIGHT MIDDLE OUTBOARD SEAT TRACKS CORRODED. REMOVED AND REPLACED THE SEAT TRACKS IAW EO E9-5300-013. AIRCRAFT RETURNED TO SDR SIMA991765Floorbeam · corrodedSAW - DURING MBV-2 INSPECTION, FOUND CORROSION ON FLOORBEAM 36 AROUND NUTCLIPS. REMOVED AND REPLACED FLOORBEAM 36 IAW EO E2-53-00-029. AIRCRAFT RETURNED TO SERVICE. (M)
Back to Aerospatiale ATR 72-212