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 TRBA2007040Lamp · burned outINTERIOR EMERGENCY EXIT LIGHT (UNDER LT EMERGENCY EXIT WINDOW) BURNED OUT. REMOVED AND REPLACED LAMPS AS PER MM NR 33-51-00 AND FOUND WORKING PROPERLY AT THIS TIME.SDR CPCP20070086Threshold · corrodedFOUND FRAME 36-39- RT GUTTER CORRODED. RT THRESHOLD GUTTER REPLACED AS PER SRM 51-21-42. GUTTER FABRICATED ON W/C 180622.SDR CPCP20070085Floor Support · corrodedFOUND FRAME 39-41 RT Z FLOOR CORRODED. RT "Z" FLOOR REPLACED AS PER SRM 51-25-01.SDR CPCP20070084Floorbeam · corrodedFOUND FRAME 40 FLOORBEAM CORRODED. FRAME 40 FLOORBEAM REPLACED AS PER SRM 51-25-01.SDR CPCP20070083Seat Track · corrodedFOUND FRAME 36-39 LT SEAT TRACK CORRODED. NOW LT SEAT TRACK BETWEEN FRAME 36-39 REPLACED IAW SRM 51-25-04.SDR CPCP20070082Bracket · corrodedFOUND FRAME 36 FWD FOLDING STEP BRACKET CORRODED. BRACKET IS FABRICATED AS PER SRM 53-67-70 FIG 137 AND REPLACED AS PER AMM 20-21-12.SDR TRBA2007039Power Supply · failedDURING PS-2 CK, FOUND CABIN RT AFT UPPER/LOWER SIGNS DOES NOT ILLUMINATE. ALSO, CABIN LT FWD SIGN DOES NOT ILLUMINATE. REMOVED AND REPLACED RT AFT EMERGENCY LIGHT POWER SUPPLY AND LT FWD EMERGENCY LIGHT POWER SUPPLY IAW JIC NR 33-51-21. OP CK OK.SDR TRBA200734Wire · chafedCAPT DOME AND STORM LIGHT WHEN OUT; BURNING SMELL IN COCKPIT ALONG WITH SPARKS APPARENTLY FROM INSTRUMENT PANEL. DE-PLANED PASSENGERS. REMOVED AND REPLACED CAPT'S DOME LIGHT BULB. PERFORMED DVI OF WIRING BEHIND INSTRUMENTS PANEL. NO ABNORMAL CONDITION OR SSDR TRBA200733Battery Pack · failedEMERGENCY LIGHTS CAME ON DURING TAXI. WILL NOT RESET. UNABLE TO EXTINGUISH LIGHTS. REMOVED AND REPLACED BATTERY PACK AT PWR SUPPLY FIN NR 61WL IAW JIC NR 33-51-21. OP CK OK.SDR CPCP20070058Support Bracket · corrodedRT "T" SUPPORT BRACKET FOR THRESHOLD AT FR 37 CORRODED. RT "TEE" SUPPORT BRACKET AT FR 37 FABRICATED AS PER SRM 53-67-70 FIG 104 AND INSTALLED AS PER SRM 51-25-01.SDR CPCP20070059Seat Track · corrodedCORROSION FOUND ON RT I/B SEAT TRACK BETWEEN FRAME 34-36. RT INBD SEAT TRACK BETWEEN 34-36 REPAIR SPLICING AS PER SRM 53-00-00 FIGURE 434 (SHEET1).SDR CPCP20070072Step · corrodedCORROSION FOUND ON ALL PAX DOOR STEPS UNDER NUTPLATES. CORROSION REMOVED ON ALL PAX DOOR STEPS UNDER NUTPLATE BY SRM 51-10-10.SDR CPCP20070071Stringer · corrodedCORROSION FOUND CHORD ANGLE AT RT STR 14 BETWEEN FRAME 13 AND 17 UPPER AND LOWER SURFACE. CORROSION FOUND CHORD ANGLE AT RT STR 14 BETWEEN FRAME 13 AND 17 UPPER AND LOWER SURFACE REPAIRED AS PER 53-31-50 FIGURE 402.SDR CPCP20070070Stringer · corrodedFOUND STR 21-L BETWEEN FRAME 41-40 CORRODED. STR21 L BETWEEN FRAME 40-41 IS REPAIRED IAW SRM 53-00-00 FIG 428 (SHEET 2).SDR CPCP20070060Seat Track · corrodedCORROSION FOUND ON LT I/B SEAT TRACK BETWEEN FRAME 34-36. LEFT INBOARD FRAME 33-36 SEAT TRACK REPAIR SPLICING AS PER SRM 53-00-00 FIG 435.SDR CPCP20070069Floorbeam · corrodedFLOORBEAM 41 CORRODED. FLOORBEAM 41 IS REPAIRED IAW SRM 53-61-40 FIG 412 SHEET 1.SDR CPCP20070068Floorbeam · corrodedFOUND FLOORBEAM 38 CORRODED. FLOORBEAM 38 REPAIRED IAW SRM 53-00-00 FIG 435.SDR CPCP20070067Floorbeam · corrodedFLOORBEAM 36 CORRODED. FLOORBEAM 36 REPAIRED IAW SRM 53-00-00 FIG 435.SDR CPCP22070066Intercostal · corrodedRT INTERCOSTAL BETWEEN FRAME 38-39 CORRODED. NOW RT INTERCOSTAL BETWEEN FRAME 38-39 INSTALLED IAW SRM 51-25-01.SDR CPCP20070065Floor Support · corrodedRT "Z" FLOOR BETWEEN FRAME 39-41 CORRODED. RIGHT "Z" FLOOR BETWEEN FRAME 39-41, REPLACED IAW SRM 51-25-01.SDR CPCP20070064Seat Track · corrodedCORROSION FOUND ON LT SEAT TRACK BETWEEN FRAME 39-41. NEW SEAT TRACK INSTALLED LEFT BETWEEN FRAME 39-41 AS PER SRM 51-25-04.SDR CPCP20070063Seat Track · corrodedCORROSION FOUND ON RT SEAT TRACK BETWEEN FRAME 39-40. RIGHT SEAT TRACK BETWEEN FRAME 39-40 REPLACED IAW SRM 51-25-04.SDR CPCP20070062Seat Track · corrodedCORROSION FOUND ON LT SEAT TRACK BETWEEN FRAME 36-39. LEFT SEAT TRACK BETWEEN FRAME REPLACED IAW SRM 51-25-04.SDR CPCP20070061Seat Track · corrodedCORROSION FOUND ON RT SEAT TRACK BETWEEN FRAME 36-39. RT SEAT TRACK BETWEEN FRAME 36-39. REPLACED AS PER SRM 51-25-04.SDR CPCP20070073Hinge · corrodedSERVICE DOOR UPPER AND LOWER DOOR SIDE HINGE FITTING CORRODED. CORROSION ON SERVICE DOOR UPPER AND LOWER DOOR SIDE HINGE FITTING REMOVED IAW SRM 51-21-42. FOUND WITHIN LIMITS IAW SRM 51-10-10.SDR CPCP20070080Angle · corrodedTAIL BUMPER AFT BTM ANGLE CORRODED. TAIL BUMPER AFT BTM ANGLE CORROSION REMOVED AS PER SRM 51-21-42 FOUND OUT OF LIMITS 51-10-10 TAIL BUMPER ANGLE REPLACED AS PER SRM 51-25-01.SDR CPCP20070076Floor Support · corrodedLT "Z" FLOOR BETWEEN FRAME 39-40 CORRODED ON LOWER SURFACE. LT "Z" FLOOR BETWEEN FRAME 39-40 REPLACED AS PER SRM 51-25-02.SDR CPCP20070081Floorbeam · corrodedFOUND FLOORBEAM AT FRAME 40 CORRODED. FLOORBEAM AT FRAME 40 REPAIRED AS PER SRM 53-00-00 FIG 435.SDR CPCP20070078Angle · corrodedRT CHORD ANGLE BTWEEN FRAME 13-17 CORRODED. RT CHORD ANGLE REPAIRED AS PER SRM 53-31-50.SDR CPCP20070077Floorbeam · corrodedFOUND FLOORBEAM 39 CORRODED. FLOORBEAM 39 REPAIRED AS PER SRM 53-00-00 FIG 435.SDR CPCP20070075Threshold · corrodedRT THRESHOLD BETWEEN FRAME 36-39 BRACKET ON FRAME 37 CORRODED. RT THRESHOLD BETWEEN FRAME 36-39 BRACKET ON FRAME 37 FABRICATED (W/C 172780) AND INSTALLED IAW SRM 51-25-01.SDR CPCP20070074Stringer · corrodedSTR 21R , BETWEEN FRAME 39-38 NEXT TO TAIL BUMPER BOX FOUND CORRODED. STRINGER 21R BETWEEN FRAME 38-39 REPAIRED AS PER SRM 53-00-00 FIG 428.SDR TRBA200728Fire Loop · false indicationAT 200 FT ON APPROACH TO STT, NR 2 ENGINE GAVE FIRE WARNING INDICATION; EXTINGUISHED BY ITSELF ON LANDING. PERFORMED DVI AND ADJUSTMENT OF FIRE DETECTION LOOPS AS PER MM NR 26-12-61. AT THIS TIME FOUND TURBINE AMBIENT DRAIN CLOGGED. CLEANED AS PER PWC NR 72SDR TRBA2007026Line · brokenGREEN HYDRAULIC SYSTEM LO LEVEL INDICATION. REPLACED UNION ON LINE FROM BRAKE DUAL VALVE LINE TO BLUE ACCUMULATOR, OPS CHECK GOOD.SDR CA070704014Packing · fractured(CAN) FUEL WAS FOUND LEAKING FROM THE FUEL MANIFOLD DRAIN DURING TAXI. SUBSEQUENT INSPECTION REVEALED LEAKING FUEL MANIFOLD PACKINGS. MFG HAS DETERMINED THE PACKINGS TO BE ASSOCIATED WITH A MANUFACTURER`S QUALITY ISSUE (REFERENCE MFG SB21740). (TC NR 2007070SDR TRBA200724Light · failedMAIN PAX DOOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHT ASSEMBLY AS PER JIC #33-51-24. OPERATIONAL CHECK GOOD.SDR TRBA2007023Battery Pack · failedEMERGENCY PAX DOOR STAIR LIGHT INOPERATIVE. REPLACED BATTERY PACK AS PER JIC NR 33-51-21. OPERATIONAL CHECK GOOD.SDR CPCP20070056Skin · corrodedCORROSION FOUND ON EXTERNAL SURFACEOF LT GUTTER BETWEEN GUTTER BETWEEN FRAME 14 TO 17. FORWARD CARGO ENTRY GUTTER REPLACED AS PER SRM 51-25-01.SDR CPCP20070057Angle · corrodedFOUND FORWARD AND AFT HOLDING ANGLE FOR SIDE PANEL 222 CW AND 222A AW CORRODED. FORWARD AND AFT HOLDING ANGLE FOR SIDE PANEL 222CW AND 222AW REPLACED AS PER 51-25-01.SDR CPCP20070055Latch · corrodedCARGO DOOR ENTRY CORROSION FOUND NEAR AFT DOOR LATCH FITTING. CARGO DOOR ENTRY REPAIRED AS PER SRM 53-00-00 FIG 402.SDR CPCP20070054Floorbeam · corrodedFOUND FLOORBEAM AT FRAME 36 IS CORRODED. FLOORBEAM AT 36 REPLACED AS PER SRM 51-25-01 AND 51-25-04.SDR CPCP20070053Floorbeam · corrodedFOUND FLOORBEAM AT FRAME 40 IS CORRODED. NEW FLOORBEAM INSTALLED IAW SRM 51-25-01 AND 51-25-04.SDR CPCP20070052Floorbeam · corrodedFOUND FLOORBEAM AT FRAME 38 IS CORRODED. FLOORBEAM AT FRAME 38 REPLACED AS PER SRM 51-25-01.SDR CPCP20070051Floor Support · corrodedRT FLOOR BETWEEN FRAME 36 THRU 38 IS CORRODED. RT FLOOR SUPPORT BETWEEN FRAME 36 THRU 38 REPLACED AS PER SRM 51-25-01.SDR CPCP20070050Floor Support · corrodedLT FLOOR SUPPORT BETWEEN FRAME 39 AND FRAME 40 IS CORRODED. LT FLOOR SUPPORT BETWEEN FRAME 39 AND FRAME 40 REPLACED AS PER SRM 51-25-01.SDR CPCP20070049Threshold · corrodedRT THRESHOLD PLATE AT FRAME 36 IS CORRODED. RT THRESHOLD PLATE AT FRAME 36 REPLACED AS PER SRM 51-25-01.SDR CPCP20070048Threshold · corrodedLT THRESHOLD BETWEEN FRAME 36 AND FRAME 39 IS CORRODED. LT THRESHOLD BETWEEN FRAME 36 AND FRAME 39 REPLACED AS PER SRM 51-25-01.SDR CPCP20070047Threshold · corrodedRT THRESHOLD BETWEEN FRAME 36 AND FRAME 39 IS CORRODED. RT THRESHOLD BETWEEN FRAME 36 AND FRAME 39 REPLACED AS PER SRM 51-25-01.SDR CPCP20070046Seat Track · corrodedRT SEAT TRACK BETWEEN FRAME 39 AND FRAME 40 IS CORRODED. RT SEAT TRACK BETWEEN FRAME 39 AND FRAME 40 REPLACED AS PER SRM 51-25-04.SDR CPCP20070045Seat Track · corrodedRT SEAT TRACK BETWEEN FRAME 36 AND FRAME 39 IS CORRODED. RT SEAT TRACK BETWEEN FRAME 36 AND FRAME 39 REPLACED AS PER SRM 51-25-04.
Back to Aerospatiale ATR 72-212