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 TRAX200800161Intercostal · corrodedINTERCOSTAL CORRODED BTW FR 36-38 STRG 17R. REPLACED IAW SRM 51-25-01 AND SRM 51-25-04.SDR TRBA2008011Power Supply · failedMULTIPLE EMERGENCY LIGHTS ON ERRONEOUSLY. REPLACED EMERGENCY LIGHTS POWER SUPPLY 61WL AS PER 33-51-21 AND FOUND WORKING PROPERLY.SDR TRBA20080011Power Supply · failedMULTIPLE EMERGENCY LIGHTS ON ERRONEOUSLY. REPLACED EMERGENCY LIGHTS POWER SUPPLY 61WL AS PER 33-51-21 AND FOUND WORKING PROPERLY.SDR CPCP20080008Fitting · corrodedLT BETWEEN FRAME 36 TO 39 FORWARD THRESHOLD FITTING CORRODED. CORROSION REMOVED ON LT FORWARD THRESHOLD FITTING AS PER SRM 51-21-42. FITTING FOUND OUT OF LIMITS 51-10-10 LT THRESHOLD FITTING FABRICATED AS PER SRM 53-67-70. FIG.128 AND INSTALLED IAW SRM 51-25SDR CPCP20080009Bracket · corrodedLT BETWEEN FRAME 36 TO 39 FOLDING STEP BRACKETS CORRODED. CORROSION REMOVED ON FOLDING STEP BRACKETS IAW SRM 51-21-42. BRACKET FOUND OUT OF LIMITS 51-10-10. LT THRESHOLD FOLDING STEP BRACKET FABRICATED IAW SRM 53-67-70, FIG 128 AND INSTALLED IAW SRM 51-25-0SDR CPCP20080007Seat Track · corrodedRT SEAT TRACK BETWEEN FRAME 36 TO 39 CORRODED. NEW SEAT TRACK RT BETWEEN FRAME 36 TO 39, INSTALLED IAW SRM 51-25-04.SDR CPCP20080006Seat Track · corrodedLT SEAT TRACK BETWEEN FRAME 36-39 CORRODED. NEW SEAT TRACK LT BETWEEN FRAME 36-39. INSTALLED IAW SRM 51-25-04.SDR TRBA2008010Transmitter · failedAT 16000 HAD A SURGE RIGHT AFTER THE NR 1 OIL PRESS STARTS TO DROP AND THE OIL LOW LEVEL LIGHT CAME ON AND NO WARNING. THE NEEDLE DROPPED TO RED LINE BUT STILL NO WARNING CHIME, SHUT DOWN AS A PRECAUTION. REMOVED AND REPLACED LT ENG OIL PRESS TRANSMITTER IAWSDR CPCP20080005Seat Track · corrodedLT INBOARD SEAT TRACK, BETWEEN FRAME 29-35 CORRODED. LT INBOARD SEAT TRACK BETWEEN FRAME 20 TO 35. REPLACED AS PER SRM 51-25-04.SDR CPCP20080004Door Frame · corrodedPAX DOOR STAIRCASE THREADS UPPER & LOWER SURFACE CORRODED IN NUT PLATES AREA. PAX DOOR STAIRCASE TREADS SUPPORT CORROSION REMOVED IAW SRM 51-21-42 ON TREADS SUPPORT NR 1-2,4 AND 5 AND FOUND WITHIN LIMITS AS PER SRM 52-11-00 FIG 301. TREAD SUPPORT NR 3 HAVE BSDR COEA0803819Angle · crackedFOUND DURING HEAVY CHECK, LT AND RT AFT UPPER WING PRESSURE DECK INTERNAL SPLICE ANGLES CRACKED. AFT OF FRAME 27 AT STRINGERS 4L AND 4R. LT ANGLE PN IS S53573201210, RT S53573201211. SRAS, SHEET REF: SO/TS-232/08/4462. DAMAGES LEFT, AS IS AFTER INSPECTION SDR TRBA2008016Shock Absorber · damagedVERY STRONG NOISE IN NOSE GEAR DURING RETRACTION. REMOVED AND REPLACED THE NOSE LANDING GEAR SHOCK ABSORBER IAW MM NR 32-21-00. REMOVED AND REPLACED LT NOSE WHEEL ASSEMBLY IAW JIC NR 12-37-32.SDR TRBA2008006Wire · brokenEMERGENCY EXIT LIGHT BY SERVICE DOOR ON FLOOR INOP. REPAIRED BROKEN WIRES AT SERVICE DOOR EMERGENCY EXIT SIGN IAW SRM 20-27-14 PERFORMED OPT CHK FOUND WORKING PROPERLYAT THIS TIME IAW JIC 33-50-00.SDR TRBA2008005Light · failedEMERGENCY LIGHT FOR SERVICE DOOR INOP. REMOVED AND REPLACED SERVICE DOOR EMERGENCY LIGHT AND OPERATIONALY TESTED IAW JIC 33-50-00 OPT 10000. TESTED SATISFACTORY.SDR TRBA2008004Bulb · failedEMERGENCY LIGHT IN PASSENGER DOOR INOPERATIVE. RELAMPED AIRSTAIR EMERGENCY LIGHT BULB IAW MM 35-50-00. OPERATIONAL CHECK GOOD.SDR CPCP20080003Frame · corrodedFRAME 39 BETWEEN STRINGER 21L-21R CORRODED. FRAME 39, BETWEEN STRINGER 21L-21R REPAIRED IAW SRM 53-61-40 FIG 415.SDR CPCP20080002Floorbeam · corrodedFOUND FLOORBEAM 39 CORRODED. FLOORBEAM 39 REPAIRED IAW SRM 53-00-00 FIG 436.SDR CPCP20080001Intercostal · corrodedR/T INTERCOSTAL BETWEEN FRAME 36-38 CORRODED. RT INTERCOSTAL REPLACED AS PER SRM 51-25-01.SDR TRBA20080002Floorbeam · corrodedFOUND FLOORBEAM 39 CORRODED. FLOORBEAM 39 REPAIRED IAW SRM 53-00-00 FIG 436.SDR TRBA20080001Intercostal · corrodedRT INTERCOSTAL BETWEEN FRAME 36-38 CORRODED. RT INTERCOSTAL REPLACED AS PER SRM 51-25-01.SDR COEA0801816Transceiver · failedAIR TURN BACK. FLT NR 8663, CREW RECEIVED A LEVEL 3 CAP ALERT LANDING GEAR NOT DOWN FOLLOWED BY A STICK PUSHER/ STICK SHAKER FAULT, TERRAIN ALERT WARNING SYS (TAWS) WARNING, RADIO ALTIMETER WENT TO 0. CREW ELECTED TO RETURN TO DEPARTURE, AIRCRAFT LANDED NORMSDR TRBA2008003Engine · failedRT ENG NP WENT TO 108 PERCENT ENGINE WAS SHUT DOWN AND CAPTAIN DECLARED EMERGENCY. REMOVED AND REPLACED RT ENGINE IAW WORK CARD 055006-CS-20000-001R1. PENDING MFG TEAR DOWN REPORT.SDR TRBA2008103Engine · failedRT ENG NP WENT TO 108 PERCENT ENGINE WAS SHUTDOWN AND CAPTAIN DECLARED EMERGENCY. REMOVED AND REPLACED RT ENGINE IN PROGRESS.SDR TRBA2008002Fuse · failedFORWARD PART EMERGENCY LIGHTS INOP. REPLACED POWER SUPPLY FUSE.SDR COEA0801819Bleed Valve · failedFLIGHT NR 8091 ON 1/2/08, DURING TAXI TO RUNWAY, THE NR 1 ENGINE BLEED FAULTED. CREW ATTEMPTED TO RESET WITHOUT SUCCESS. AIRCRAFT RETURNED SAFELY TO BLOCKS. REPLACED NR 1 ENGINE HIGH PRESSURE BLEED AIR SHUTOFF VALVE. (K)SDR COEA0802819Starter Gen · failedFLIGHT NR 8091 ON 1/2/08, DURING TAXI TO RUNWAY THE NR 2 DC GENERATOR FAULTED. CREW ATTEMPTED TO RESET WITHOUT SUCCESS. AIRCRAFT RETURNED SAFELY TO BLOCKS. REPLACED NR 2 ENGINE DC STARTER GENERATOR. NR 40670.SDR TRBA2008001Bulb · failedEMERGENCY LIGHT ON ON STAIRS. REPLACED EMERGENCY LIGHT BULB ON STAIRS IAW JIC 25-60-00.
SDR TRBA2007120Battery Pack · failedIN CRUISE THE AFT GALLEY EMERGENCY LIGHTS CAME ON BY THEMSELVES; TRIED RESETING EMERGENCY LIGHT SWITCH IN COCKPIT AND CABIN BUT THE LIGHTS STAYED ON. REMOVED AND REPLACE BATTERY PACK FIN NR 62WL IAW JIC NR 33-51-21.
SDR TRBA2007119Bulb · failedEMERGENCY DOOR STAIRLIGHT INOPERATIVE. REMOVED AND REPLACED LIGHT BULB.SDR TRBA2007118Bulb · failedEMERGENCY LIGHT INOPERATIVE IN THE MAIN ENTRANCE PASSENGER DOOR. MAINTENANCE REPLACED LIGHT BULB.SDR TRBA2007117Pump · failedAFTER GEAR UP SELECTION, DURING T/O, LOUD BANG HEARD AND UNLOCK INDICATION ON LT MLG. REMOVED AND REPLACED GREEN HYDRAULIC PUMP. PERFORMED EXTENSION AND RETRACTION OF LANDING GEARS. OPS GOOD IAW JIC 29-10-00.SDR TRBA2007115Wire Harness · failedAFTER DEPARTURE LANDING GEAR HANDLE WILL NOT MOVE, FROZEN IN PLACE. REMOVED AND REPLACED NOSE LANDING GEAR HARNESS IAW MM 32-21-11. REMOVED AND REPLACED RT MAIN LANDING GEAR WOW 54GB HARNESS IAW 32-11-51.SDR TRAX200701963Light · inoperativePAX DOOR LOWER STEP BOARDING LIGHT INOP.SDR TRAX200701958Heater · failedFLT 4718 DEL 180 MINS, NR 1 PROP HEAT FAILED ON AND OFF 19 TIMES IN FLIGHT. A/C RETURNED TO ATL AFTER T/O, EMERGENCY DECLARED.SDR TRBA2007113Lamp · failedPASSENGER STAIR EMERGENCY FLOOD LIGHT IS INOP. REMOVED AND INSTALLED ENTRANCE DOOR EMERGENCY LIGHT AS PER MM 33-51-00.SDR TRAX200701940Light · malfunctionedTWO MINUTE LIGHT WILL NOT EXTINGUISH.SDR TRAX200701934Cover · missingFLT 4268 - LEFT FWD LOWER EXIT SIGN IS MISSING COVER.SDR TRBA2007112Power Supply · failedEMERGENCY LIGHTS STAYS STAY ON WHEN THE SWITCH IS ON THE ARM POSITION. REMOVED AND REPLACED THE EMERGENCY LIGHT POWER SUPPLY AT 73WL, THE EMERGENCY BATTERY LIGHT PACK AT 62WL, OPS CHECK NORMAL IAW MM 33-51-00. OPS CHECKS NORMAL AS PER MM 25-60-00.SDR TRAX200701905Mount · damagedRT ENG LT FWD LATERAL SHOCKMOUNT CRACKED. RT ENG LT FWD LATERAL SHOCKMOUNT AFT MOLDED CUSHION REPLACED IAW AMM 71-20-22 AND JIC 71-21-61 RAI 10 000.SDR TRAX200701906Bracket · crackedPAX DOOR SURROUND 255DW, 255EW IN CRACKED. NLG FWD LT DOOR FWD STOP BRACKET REPLACED IAW SRM 51-25-01REPAIR DETERMINED NOT TO BE A MAJOR REPAIR IN ACCORDANCE WITH S.P. 663 AND FAR 43, APPENDIX A. REPAIR CCOMPLISHED IN ACCORDANCE WITH SRM 51-25-01.SDR TRAX200701898Bracket · crackedNLG FWD LT DOOR, FWD STOP BRACKET CRACKED.
SDR TRAX200701903Bracket · crackedLT I/B FLAP O/B FLAP ARM OMEGA BRACKET CRACKED.SDR TRAX200701902Angle · crackedANGLE CRACK ON LT O/B FUSELAGE FR 23D, BRACKET FIXED ON FUSELAGE SKIN.SDR TRAX200701901Intercostal · crackedCRACK FOUND ON RT O/B INTERCOSTAL BTW FUSELAGE FAIRING FR 23D TO FUSELAGE.
SDR TRAX200701900Floorbeam · corrodedFOUND FLOORBEAM 36 CORRODED.
SDR TRAX200701899Floorbeam · corrodedFOUND FLOORBEAM 41 CORRODED.
SDR TRAX200701897Doubler · corrodedDOUBLER CORRODED AT LWR FUSELAGE AREA (ANTENNA DOUBLER) FR 16-17 (SEE W/C 2000-18 FOR FABRICATION) SEE STICKER 200.
SDR TRBA2007110Fire Warning · false indicationAPPROXIMATELY 3 TO 5 MINS AFTER STARTING ENG NR 1, AN ENG NR 1 FIRE INDICATION ON CAP, CONDITION LEVER NR 1 AND FIRE HANDLE NR 1 ENGINE FIRE EMERGENCY PROCEDURES WERE PERFORMED. SPECIAL DVI AFTER ENGINE FIRE WAS PERFORMED IAW JIC NR 70-00-00 SDI 10000. RE-CHSDR TRBA2007108Wheel · damagedPOST FLIGHT INSPECTION REVEALED NR 3 WHEEL TIRE AT ODD ANGLE AND BRAKE DISC OUT OF POSITION. REMOVED AND REPLACED RT MLG AS PER JIC 32-11-00.SDR TRAX200701842Landing Gear · inoperativeLEFT MAIN GEAR WILL NOT RETRACT, EMERGENCY DECLARED. EMERGENCY EQUIPMENT ON STANDBY.
Back to Aerospatiale ATR 72-212