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 CPCP20070124Plate · corrodedLT GUTTER PLATE ON FORWARD CARGO DOOR THRESHOLD BETWEEN FRAME 14 TO 17 IS CORRODED. LT GUTTER PLATE ON FORWARD CARGO DOOR THRESHOLD BETWEEN FRAME 14 TO 17, REPLACED AS PER SRM 51-25-01 AND SRM 51-25-03.SDR CPCP20070123Seat Track · corrodedRT SEAT TRACK BETWEEN FRAME 36-39 CORRODED. NEW RT SEAT TRACK BETWEEN FRAME 36-39. INSTALLED IAW SRM 51-25-04.SDR CPCP20070122Seat Track · corrodedLT SEAT TRACK BETWEEN FRAME 36-39 CORRODED. LT SEAT TRACK BETWEEN FRAME 36-39, REPLACED IAW SRM 51-25-04.
SDR CPCP20070121Seat Track · corrodedRT SEAT TRACK BETWEEN FRAME 39-40 CORRODED. NEW RT SEAT TRACK BETWEEN FRAME 39-40 IS INSTALLED IAW SRM 51-25-04.SDR TRBA2007102Windshield · crackedF/O WINDSHIELD CRACKED IN FLIGHT AT CRUISE. ORIGINAL FLIGHT SJU-EIS, DIVERTED TO STT. REMOVED AND REPLACED RH WINDSHIELD IAW JIC 53-11-10. PERFORMED OPERATIONAL AND LEAK CHECK AND FOUND SATISFACTORY.SDR TRBA2007101Power Supply · failedEMERGENCY LIGHTS FROM CABIN STAY ON ALL THE TIME (HALF OF THEM). REPLACED AND TESTED EMERGENCY BATTERY POWER SUPPLY 73WL AS PER MM 33-51-21 AND FOUND WORKING PROPERLY.
SDR TRBA2007100Power Supply · discharged2ND CEILING EMERGENCY LIGHT INOP. REMOVED AND REPLACED EMERGENCY LIGHT POWER SUPPLY UNIT IAW JIC 33-51-21. PERFORMED OPERATIONAL CHECK AND FOUND WORKING PROPERLY AT THIS TIME.SDR TRBA2007099Engine · making metalLT ENGINE OIL PRESURRE DROP WITH ASSOCIATED WARNINGS. REMOVED AND REPLACED LT ENGINE S/N 127056 AS PER WORK CARD 055006-CS-20000-001.SDR TRBA2007098Sign · inoperativeSERVICE DOOR EMERGENCY EXIT SIGN INOPERATIVE. RAI SERVICE DOOR EMERGENCY EXIT SIGN IAW JIC 33-51-00. OPT OK IAW JIC 33-50-00.SDR TRBA2007097Light · burned outPASSENGER ENTRY STAIRS EMERGENCY LIGHT OUT. REMOVED AND REPLACED PAX/CREW DOOR EMERGENCY LIGHT IAW JIC 33-51-25. PERFORMED OPT CHK FOUND WORKING PROPERLY AT THIS TIME.SDR TRBA2007096Power Supply · failedEMERGENCY LIGHTS STAY ON WITH ENGINE RUNNING. REPLACED EMERGENCY POWER SUPPLY 61WL IAW MM 37-51-21, OPT CK NORMAL.SDR TRBA2007094Power Supply · failedCABIN DOOR EMERGENCY "EXIT" LIGHT SIGN INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHT POWER SUPPLY AND PERFORMED OP CK IAW JIC NR 33-50-00.SDR TRBA2007093Power Supply · failedCABIN EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHTS POWER SUPPLY 62WL AND PERFORMED OP CK IAW JIC NR 33-50-00.SDR TRAX200701671Seat Track · corrodedRT SEAT TRACK BTW FR 39-40 FOUND CORRODED OUT OF LIMIT ON W/C 200-115 NEEDS TO BE FABRICATED, RESOLVED ON W/O: 74559 TASKCARD: N/R-00552. NEW RT SEAT TRACK BTW FR 39-40 HAS BEEN FABRICATED IAW SRM 53-33-00 FIG 101. INSTALLATION COVERED ON W/C 200-115.SDR TRAX200701674Light · inoperativeFLT 4508 - EMERGENCY LIGHT ON CABIN DOOR NOT WORKING. DEL 225 MINS.SDR TRAX200701670Lap Joint · corrodedCORROSION FOUND ON FUSELAGE SKIN LAP JOINT BTW FR 23A-23C STR 11L. REMOVED AS PER SRM 51-21-42, SKIN REPAIRED IAW SRM 53-00-00 FIG 424 MATERIAL THICKNESS: 0.063 MATERIAL REMOVED: 0.012 OUT OF LIMITS AS PER SRM: 53-31-00 FIG 301.SDR TRBA2007092Lamp · inoperativePAX DOOR EMERGENCY STAIR LIGHT INOPERATIVE. REPOSITIONED LAMP AND PERFORMED OP CK IAW JIC NR 33-50-00.SDR TRBA2007091Lamp · inoperativePAX DOOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPAIRED LAMP IAW JIC NR 33-50-00. OP CK OK.SDR TRAX200701662Rib · corrodedRT O/B FLAP CAM GUIDE AT FLAP RIB 13 CORRODED.SDR TRAX200701660Torque Box · corrodedTORQUE BOX BTW FR 36-38 CORRODED (ON RT SIDE). CORROSION REMOVED AS PER SRM 51-21-42 TOURQUE BOX REPLACED IAW SRM 51-25-01 MATERIAL THICKNESS: 0.063 MATERIAL REMOVED: 0.030 OUT OF LIMITS AS PER SRM: 53-61-00 FIG 301.SDR TRAX200701659Stringer · corrodedFOUND STRINGER 12R BTW FR 36-38 CORRODED. REPAIRED AS PER SRM 53-00-00 FIG 426.SDR TRBA2007090Light · failedPAX DOOR STAIR EMERGENCY FLOOD LIGHT INOPERATIVE. REMOVED AND REPLACED EMERGENCY FLOOD LIGHT ASSEMBLY IAW JIC NR 33-51-24. PERFORMED OP CK.SDR COEA0702819Pitot Head · obstructedFLT 8080 - ABORTED TAKEOFF, DURING TAKEOFF ROLL PILOT NOTICED NR 2 AIRSPEED INDICATOR READ ZERO, FOLLOWED BY (DACD DATA INVALID) ON AFCS CONTROL PANEL. PILOT RETURNED TO RAMP AT OAK. MAINTENANCE FOUND AND REMOVED DEBRIS IN PITOT PROBE, TWO INSECTS. AIRCRAFTSDR COEA0701819Indicator · malfunctionedFLIGHT 8080 - ABORTED TAKEOFF, DURING TAKEOFF ROLL PILOT NOTICED NR 2 AIRSPEED INDICATOR READ ZERO, FOLLOWED BY (DACD DATA INVALID) ON AFCS CONTROL PANEL. PILOT RETURNED TO RAMP AT OAK. REMOVED AND REPLACED ASI. AIRCRAFT RETURNED TO SERVICE. DISCREPANCY RESDR TRAX200701641Floorbeam · corrodedFOUND FLOORBEAM 39 CORRODED, RESOLVED ON W/O: 74559 TASKCARD: N/R-00277. FLOORBEAM 39 CORROSION REMOVED IAW SRM 51-21-42 BUT IT IS OUT OF LIMIT AS PER SRM 53-61-00 FIG 301. FLOORBEAM 39 REPAIRED IAW SRM 53-00-00 FIG 450. FABRICATION OF PARTS COVER ON W/C 20SDR TRBA2007089Battery Pack · failedFWD CABIN EMERGENCY LIGHTS (UPPER AND LOWER) INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACK 43WL IAW JIC NR 33-51-21.SDR TRAX200701629Seat Track · corrodedETNRC-200-120 SEAT TRACK LT I/B BTW FR 29 AND 39 CORRODED, (RESOLVED ON W/O: 74559 TASKCARD: N/R-0018). REMOVED CORROSION ON SEAT TRACK LT I/B BTW FR 29 AND FR 39 AS PER SRM 53-00-00. FABRICATION COVERED ON W/C 2000-203 SEAT TRACK. REPLACED IAW SRM 51-25-04SDR TRAX200701658Bracket · brokenLT INBD FLAP AT RIB 5 1 OMEGA BRACKET FOUND BROKEN FOR FABRICATION SEE WC NR 2000-102. NSTALLED IAW SRM 51-25-01FABRICATION COVERED ON W/C 2000-102
REPAIR DETERMINED NOT TO BE A MAJOR REPAIR IN ACCORDANCE WITH S.P. 663 AND FAR 43, APPENDIX A. REPAIR ACCOMPLISDR TRAX200701657Bracket · brokenLT INBD FLAP AT RIB 9, 3 OMEGA BRACKETS FOUND BROKEN. INSTALLED IAW AMM 20-21-11 FABRICATION COVERED ON W/C 2000-101.SDR TRBA2007088Spacer · crackedRT MLG SWINGING LEVER SPACER CRACKED. REMOVED AND REPLACED RT MLG SWINGING LEVER SPACER AS PER EO NR E2-3200-029R2 (SB #631-32-165). LANDING GEAR PART NUMBER CHANGED TO SUFFIX -20. PERFORMED RETRACTION, FUNCTIONAL AND EMERGENCY EXTENSION TEST AND FOUND SATISDR TRAX200701714Seal · corrodedTAIL BUMPER SURROUND SEAL (DOUBLER) CORRODED.SDR CPCP20070120Seat Track · corrodedRT SEAT TRACK FRAME 39-40 CORRODED AROUND NUTPLATE HOLES. RT SEAT TRACK FRAME 39-40. REPLACED IAW SRM 51-25-04.SDR CPCP2007120Seat Track · corrodedRT SEAT TRACK FRAME 39-40 CORRODED AROUND NUTPLATE HOLES. RT SEAT TRACK FRAME 39-40 REPLACED IAW SRM 51-25-04.
SDR CPCPC2007119Seat Track · corrodedLT SEAT TRACK FRAME 36-39 CORRODED. LT SEAT TRACK FRAME 36-39 REPLACED IAW SRM 51-25-04.SDR CPCP20070118Channel · corrodedRT Z FLOOR FRAME 39-41 FOUND CORRODED. RT Z FLOORFRAME 39-41 REPLACED IAW SRM 51-25-01.SDR TRAX200701569Hinge · brokenFITTING HINGE (AFT) BROKEN ON RT EMERGENCY EXIT (RESOLVED ON W/O: 71093 TASKCARD: N/R-00253 ), FITTING HINGE ON RT EMERGENCY EXIT REPLACED AND INSTALLED IAW SRM 51-25-04. REPAIR DETERMINED NOT TO BE A MAJOR REPAIR IN ACCORDANCE WITH SP 663 AND FAR 43, APPENDISDR TRBA2007087Lamp · inoperativeEMERGENCY LIGHT IN MAIN CABIN DOOR INOPERATIVE. RELAMPED MAIN CABIN DOOR EMERGENCY LIGHT.SDR TRBA2007086Wire · brokenONE OF THE EMERGENCY EXIT LIGHTS IN THE STAIRS IS BURNED OUT. REPAIRED BROKEN WIRE AT PASSENGER CREW DOOR IAW SRM 20-24-17. PERFORMED OPT CHK IAW JIC 33-50-00 AND FOUND WORKING PROPERLY AT THIS TIME.SDR CPCP200700116Support Bracket · corrodedFWD "T" BRACKET OF FOLDING STEP CORRODED. FWD "T" BRACKET OF FOLD ONG STEP REPLACED IAW SRM 51-25-04.SDR CPCP200700115Floorbeam · corrodedFLOORBEAM 39 CORRODED ON UPPER AND LOWER SURFACE. CORROSION OF FLOORBEAM 39 REPAIRED IAW SRM 53-00-00 FIGURE 450 AT 2 LOCATIONS.SDR CPCP200700114Threshold · corrodedRT THRESHOLD BTW FRAME 36-39 GUTTER CORRODED. RT THRESHOLD BTW FRAME 36-39 GUTTER REPLACED IAW SRM 51-25-01.SDR TRBA2007083Lamp · inoperativeEMERGENCY LIGHT ON MAIN PAX DOOR INOPERATIVE. REMOVED AND REPLACED LIGHT BULB AND PERFORMED OPERATIONAL CHECK IAW JIC NR 33-50-00.SDR TRBA2007080Lamp · burned outEMERGENCY EXIT LIGHT AT BASE OF MAIN CABIN DOOR IS BURNED OUT, EXTERNAL FLOOD LIGHT. REPLACED BULB ON MAIN CABIN DOOR EMERGENCY LIGHT ASSY. PERFORMED OPERATIONAL CHECK AND FOUND WORKING PROPERLY PER M/M 33-50-00.SDR TRBA2007079Indicator · failedDURING T/O ROLL, F/O'S EHSI WENT BLANK. ABORTED TAKEOFF AND RETURNED TO BLOCK. REMOVED AND REPLACED F/O EHSI AND PERFORMED OPT CK IAW JIC NR 34-75-81 AND FOUND SYSTEM WORKING PROPERLY.SDR CPCP20070113Seat Track · corrodedLT I/B SEAT TRACK BETWEEN FRAME 29-36 CORRODED. SEAT TRACK FRAME 29-36 LT I/B REPLACED IAW SRM 51-25-04.SDR CPCP200700112Seat Track · corrodedLT O/B SEAT TRACK BETWEEN FRAME 29-36 CORRODED. SEAT TRACK FRAME 29-36 LT OUTB REPLACED IAW SRM 51-25-04.SDR CPCP200700109Threshold · corrodedGUTTER ON RT THRESHOLD BETWEEN FRAME 36-39 IS CORRODED. GUTTER IS REMOVED AND REPLACED AS PER SRM 51-25-01.SDR CPCP00112Seat Track · corrodedLT O/B SEAT TRACK BETWEEN FRAME 29-36 CORRODED. SEAT TRACK FRAME 29-36 LT OUTB REPLACED IAW SRM 51-25-04.SDR CPCP200700111Floorbeam · corrodedFLOORBEAM AT FRAME 39, TOP SURFACE IS CORRODED AT STR 17, AND UNDER CLIPNUTS. FLOORBEAM AT FRAME 39 REPAIRED IAW SRM 53-00-00 FIG 429.
SDR CPCP200700110Floorbeam · corrodedFLOORBEAM FR 38, TOP SURFACE IS CORRODED BETWEEN STR 17-20 AND UNDER CLIPNUT. FLOORBEAM AT FRAME 38 REPAIRED AS PER SRM 53-00-00 FIG 450.
Back to Aerospatiale ATR 72-212