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 CPCP20070044Seat Track · corrodedLT SEAT TRACK BETWEEN FRAME 39 AND FRAME 41 IS CORRODED. LT SEAT TRACK BETWEEN FRAME 39 AND FRAME 41 REPLACED AS PER SRM 51-25-04.SDR CPCP20070043Seat Track · corrodedLT SEAT TRACK BETWEEN FRAME 36 AND FRAME 39 IS CORRODED. LT SEAT TRACK BETWEEN FRAME 39 AND FRAME 39 REPLACED AS PER SRM 51-25-04SDR CPCP20070042Bulkhead · corrodedCORROSION FOUND ON FORWARD PRESSURE BULKHEAD AT GROUND POINTS (8) LOCATIONS. FORWARD BULKHEAD LT AND RT UPPER AT STA 2962 REPAIRED AS PER SRM 53-11-10 FIG 404.SDR CPCP20070041Support · corrodedTHREAD SUPPORT NR 1 (BOTTOM) OF PASSENGER DOOR STAIRCASE IS CORRODED UNDER NUT PLATES. THREAD SUPPORT NR 1 FROM BOTTOM REPLACED AS PER SRM 51-25-01.SDR CPCP20070031Skin · corrodedLOCK FASTERNER COLLARS CORRODED UNDERNEATH TOP SKIN O/B OF RIB 24 ACCESS VIA PANEL 624 AB. LOCK FASTERNER COLLARS REPLACED UNDERNEATH TOP SKIN O/B OF RIB AS PER SRM 51-25-04.SDR CPCP20070033Floorbeam · corrodedFOUND FRAME 38 FLOORBEAM CORRODED. FRAME 38 FLOORBEAM REPAIRED AS PER SRM 53-00-00 FIG 450.SDR CPCP20070036Frame · corrodedFOUND FRAME 39 BETWEEN STRINGER LT 21 AND RT 21 CORRODED. FRAME 39 REPAIRED AS PER SRM 53-61-40 FIG 415 WITH SECTION OF NEW FRAME SEGMENT.SDR CPCP20070032Floorbeam · corrodedFOUND FRAME 36 FLOORBEAM CORRODED. FRAME 36 FLOOR SPLICED AS PER SRM 55-00-00.SDR CPCP20070035Seat Track · corrodedFOUND LT BETWEEN FRAME 36 AND 39 SEAT TRACK CORRODED. SEAT TRACK LT BETWEEN FRAME 36 AND 39 REPLACED AS PER SRM 51-25-04.SDR CPCP20070034Floorbeam · corrodedFOUND FRAME 39 FLOORBEAM CORRODED. FRAME 39 FLOORBEAM REPAIRED AS PER SRM 53-00-00 FIG 450.SDR CPCP20070037Seat Track · corrodedFOUND LT FRAME 39 TO 41 SEAT TRACK CORRODED. SEAT TRACK LT FRAME 39 - 41 REPLACED AS PER SRM 51-25-04.SDR CPCP20070039Doubler · corrodedGUTTER AND DOUBLER ARE CORRODED BETWEEN FRAME 13 AND 17 AT CARGO DOOR. DOUBLER BETWEEN FRAME 13 AND 17 AT CARGO DOOR REPLACED AS PER SRM 51-25-01.SDR CPCP20070040Seat Track · corrodedCORROSION FOUND ON LT I/B SEAT TRACK AT FRAME 17. SEAT TRACK LT I/B ON FRAME 13 - 23 REPLACED IAW SRM 51-25-04.SDR CPCP20070038Frame · corrodedAILERON CONTROL QUADRANT CORRODED RT FRAME 27 AND 28 WING RIB 1 AND 2. REPLACED QUADRANT ASSY ON AUTO-PILOT ROLL CONTROL SYSTEM IAW AMM JIC 27-11-23 RAI 10000.SDR CPCP20070030Seat Track · corrodedRIGHT SEAT TRACK BETWEEN FRAME 36-39 CORRODED. REPLACED RIGHT SEAT TRACK AS PER SRM 51-25-04.SDR TRBA2007018O-Ring · brokenWHILE IN CLIMB, NR 2 ENG OIL LOW PRESSURE LIGHT ILLUMINATED IN FLIGHT, WITH MASTER WARNING. SHUTDOWN IAW CHECK LIST AND LANDED. EMERGENCY DECLARED. FOLLOW MFG FAULT ISOLATION MANUAL (PW 72-00-01). FOUND STARTER GENERATOR BROKEN O-RING. REMOVED AND INSTALLESDR CPCP20070022Support · corrodedLT AFT PASSENGER DOOR THREAD SUPPORT 1(BOTTOM) IS CORRODED. NEW THREAD SUPPORT 1 (BOTTOM), INSTALLED IAW SRM 51-25-01.SDR CPCP20070025Structure · corrodedLT GUTTER CORRODED BETWEEN FRAME 36 AND 39. NEW LT GUTTER BETWEEN FRAME 36 AND 39, INSTALLED IAW SRM 51-25-01.SDR CPCP20070023Support · corrodedLT AFT PASSENGER DOOR THREAD SUPPORT 5 IS CORRODED. NEW THREAD SUPPORT 5 INSTALLED IAW SRM 51-25-01.SDR CPCP20070024Threshold · corrodedLT THRESHOLD CORRODED BETWEEN FRAME 36 AND 39. NEW LT THRESHOLD BETWEEN FRAME 36 AND 39 INSTALLED IAW SRM 51-25-01.SDR CPCP20070026Floor Support · corrodedLT "Z" FLOOR UPPER AND LOWER SURFACE BETWEEN FRAME 39 AND 40 CORRODED. LEFT "Z" FLOOR SUPPORT BETWEEN FRAME 39-40 REPLACED AS PER SRM 51-25-02.SDR CPCP20070029Floorbeam · corrodedFLOORBEAM 39 UPPER AND LOWER SURFACE CORRODED. FLOORBEAM 39 REPLACED AS PER SRM 51-25-01.SDR CPCP20070028Floorbeam · corrodedFLOORBEAM 36 CORRODED ON UPPER AND LOWER SURFACE. NEW FLOORBEAM 36 INSTALLED IAW SRM 51-25-01.SDR CPCP20070027Support · corrodedRT THRESHOLD SUPPORT AND LOWER SURFACE BETWEEN FRME 36 TO 39 CORRODED. RT THRESHOLD BETWEEN FRAME 36 TO 39 REPLACED AS PER SRM 51-25-01.SDR CA070514043Packing · leaking(CAN) DURING BOARDING, FUEL WAS DISCOVERED LEAKING FROM THE ENGINE. SUBSEQUENT INSPECTION REVEALED DAMAGED FUEL NOZZLE TRANSFER TUBE PACKINGS. (TC NR 20070514043)SDR CA070514039Packing · leaking(CAN) THE ENGINE FLAMED OUT ON APPROACH. SUBSEQUENT INSPECTION REVEALED DAMAGED FUEL NOZZLE MANIFOLD O-RING PACKINGS. (TC NR 20070514039)SDR TRBA2007015Wire · damagedWHILE PERFORMING POST FLIGHT, CREW NOTICED MAIN CABIN DOOR EMERGENCY EXIT LIGHT INOPERATIVE. REPAIRED WIRE AT MAIN CABIN EMERGENCY EXIT LIGHT ASSY IAW 33-22-17. (K)SDR TRBA2007012Fuse · blownCREW NOTICED LOWER EXIT LIGHT AT SERVICE DOOR INOPERATIVE. REPLACED FUSE AT POWER SUPPLY FIN 62WL AND BULB AT LOWER ASSY FOR EMERGENCY LIGHT AT SERVICE DOOR IAW JIC 33-50-00, OPS CHECKS GOOD. (K)SDR CPCP20070020Stringer · corrodedFOUND CORROSION FOUND ON RT STG 21. STG 21 RT AT FRAME 24 AND 25 REPAIRED IAW SRM 53-00-00 FIG 428.SDR CPCP20070021Floorbeam · corrodedFLOORBEAM FRAME 39 FOUND CORRODED NEAR SERVICE DOOR THRESHOLD. FLOOR BEAM REPLACEMENT C/OUT ON NRWC 174954.SDR CPCP20070016Seat Track · corrodedCORROSION FOUND ON LT I/B SEAT TRACK AT FRAME 36. TRACK LT I/B AT FRAME 36 REPAIRED IAW SRM 53-00-00 FIG 434.SDR CPCP20070018Seat Track · corrodedCORROSION FOUND ON RT SEAT TRACK BETWEEN FRAME 36 AND 39. RT SEAT TRACK BETWEEN FRAME 36 AND 39 REPLACED AS PER SRM 51-25-04.SDR CPCP20070017Seat Track · corrodedCORROSION FOUND ON LT SEAT TRACK BETWEEN FRAME 36 AND 39. LT SEAT TRACK BETWEEN FRAME 36 AND 39, REPLACED AS PER SRM 51-25-04.SDR CPCP20070012Floor Support · corrodedCORROSION FOUND ON RT "Z" FLOOR SUPPORT. RT "Z" FLOOR SUPPORT REPLACED AS PER SRM 51-25-01.SDR CPCP20070011Frame · corrodedCORROSION FOUND ON FRAME BEAM 40. FLOORBEAM 40 REPAIRED IAW SRM 53-00-00 FIG 435 SRM 51-25-01.SDR CPCP20070019Seat Track · corrodedCORROSION FOUND ON LT SEAT TRACK BETWEEN 39 AND 41. LT SEAT TRACK BETWEEN FRAME 39 AND 41 REPLACED AS PER SRM 51-25-04.SDR CPCP20070013Threshold · corrodedCORROSION FOUND ON RT THRESHOLD GUTTER. RT THRESHOLD GUTTER REPLACED AS PER SRM 51-25-01.SDR CPCP20070014Frame · corrodedCORROSION FOUND ON FRAME 38 BETWEEN STG 21L AND 21R. FRAME 38 21L AND 21R REPAIRED IAW SRM 53-01-40 FIG 414.SDR CPCP20070015Floor Support · corrodedCORROSION FOUND ON LT "Z" FLOOR SUPPORT BETWEEN FRAME 39 AND 40. LEFT "Z" FLOOR REPLACED IAW SRM 51-25-01.SDR TRBA2007013Engine · malfunctionedSHORTLY AFTER TAKEOFF, RT ENGINE. AC DECLARED EMERGENCY AND RETURNED TO DEPARTURE, NO FIRE INDICATION NOTED. REMOVED AND REPLACED RT ENGINE IAW MM 055006-CS20000-00R1. (K)SDR CPCP20070002Floorbeam · corrodedCORROSION FOUND ON FLOORBEAM ON FRAME 40.SDR CPCP20070001Stiffener · corrodedCORROSSION FOUND ON FR 1 STIFFENER.SDR CA070514023Packing · leaking(CAN) THE ENGINE EXHIBITED AN UNCOMMANDED POWER REDUCTION IN CRUISE AND WAS SHUTDOWN IN FLIGHT. SUBSEQUENT INSPECTION REVEALED LEAKING FUEL MANIFOLD PACKINGS. (TC NR 20070514023)SDR TRBA2007010Flow Divider · leakingWHILE IN CLIMB, NR 2 ENGINE TQ DROPS SLOWLY UP TO 25 PERCENT AND LOST POWER UNTIL THE ENGINE FLAMED OUT BY ITSELF. REPLACED FUEL FLOW DIVIDER IAW MM 72-01-40 AND FUEL NOZZLES 8,9,10,11 AND 12 TRANSFER TUBES AND SEALS IAW 72-01-40. PERFORMED ENGINE RUN UP NO SDR TRBA2007008Wire · damagedCREW NOTICED EMERGENCY EXIT LIGHT AT BOTTOM OF SERVICE DOOR INOPERATIVE. REPAIRED WIRE AND TESTED EMERGENCY LIGHT IAW MM 33-55-00. FOUND WORKING PROPERLY. (K)SDR CA070514007Bleed Valve · malfunctioned(CAN) TAKEOFF WAS ABORTED DUE TO HIGH TURBINE TEMPERATURE INDICATION. THE INTERCOMPRESSOR BLEED VALVE WAS SUBSEQUENTLY REPLACED. (TC NR 20070514007)SDR TRBA2007007Light · inoperativePERFORMING POST FLIGHT CREW NOTED LT FWD EMERGENCY FLOOD LIGHT INOPERATIVE. REPLACED FWD FLOOD LIGHT BULB IAW JIC 33-50-00. (K)SDR TRAX200700271Warning System · activatedDURING APPROACH AT APPROX 400 W/FLAPS 30 DEG, RECEIVED "FLAP UNLOCK". EXECUTED MISSED APPROACH. RAN QRH. EXECUTED NO FLAP LANDING, EMERGENCY DECLARED.SDR TRAX200700269Light · malfunctionedON TAXI OUT, FIRST HALF OF EMERGENCY FLOOR TRACK LIGHTING WILL NOT EXTINGUISH, GATE RETURN. FLT 4582 DEL 180 MINS.SDR TRBA2007005Windshield · crackedWHILE IN CRUISE AT 11,000 FTS RT WINDSHIELD STARTED CRACKING. RETURNED TO POS FOR CHECK. REPLACED F/O WINDSHIELD IAW JIC 56-11-00, FOUND WORKING PROPERLY WITH NO LEAK. (K)
Back to Aerospatiale ATR 72-212