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 SIMA991764Web · corrodedSAW - DURING MBV-2 INSPECTION, FOUND THE LEFT WEB FORWARD OF THE PASSENGER DOOR BETWEEN FRAMES 35 AND 36 ARE CORRODED. REMOVED AND REPLACED THE WEB IAW SRM 51-25-03. AIRCRAFT RETURNED TO SERVICE. (M)SDR 99ZZZM401Seat 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 99ZZZM400Seat 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 99ZZZM399Seat 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 99ZZZM398Seat 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 99ZZZM397Seat 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 SIMA991732Skin · dentedSAW - DURING MBV-2 INSPECTION, FOUND THREE DENTS IN THE LOWER SIDE OF THE FUSELAGE SKIN BETWEEN FRAMES 41 AND 43 AND STRINGERS 20 AND 21, MEASURING 2.17 BY 1.34 BY .080, AND 1.50 BY .058, AND 1.50 BY .052 INCHES. REPAIRED THE DENTS IAW SRM 53-00-00 FIGURE 405SDR SIMA991731Skin · dentedSAW - DURING MBV-2 INSPECTION, FOUND TWO DENTS IN THE LEFT SIDE OF THE FUSELAGE SKIN BETWEEN FRAMES 39 AND 42 AND STRINGERS 11 AND 12, MEASURING 1.27 BY .060 AND 1.37 BY .78 BY .056 INCHES. REPAIRED THE DENTS IAW SRM 53-00-00 FIGURE 403. AIRCRAFT RETURNED TO SDR SIMA991622Seat Track · corrodedSAW - DURING MBV-2 INSPECTION, FOUND THE LEFT MIDDLE INBOARD, LEFT AFT OUTBOARD, AND THE RIGHT MIDDLE OUTBOARD SEAT TRACKS CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACKS IAW EO E9-5300-013. AIRCRAFT RETURNED TO SERVICE. (M)SDR 99ZZZM617Seat Track · corrodedSAW - DURING MBV-2 INSPECTION, FOUND THE LEFT MIDDLE INBOARD, LEFT AFT OUTBOARD, AND THE RIGHT MIDDLE OUTBOARD SEAT TRACKS CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACKS IAW EO E9-5300-013. AIRCRAFT RETURNED TO SERVICE. (M)SDR 99ZZZM616Seat Track · corrodedSAW - DURING MBV-2 INSPECTION, FOUND THE LEFT MIDDLE INBOARD, LEFT AFT OUTBOARD, AND THE RIGHT MIDDLE OUTBOARD SEAT TRACKS CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACKS IAW EO E9-5300-013. AIRCRAFT RETURNED TO SERVICE. (M)SDR C2XA99BT051Bulb · failedEWR - CREW REPORTS STAIR EMERGENCY LIGHT NO WORKING. REMOVED AND REPLACED BULB. OPS CHECKED GOOD. (M)SDR SIMA991414Engine · power lossMIA - FLT 5714 - DURING CLIMB-OUT, APPROX 2-3 MINUTES AFTER TAKEOFF, THE LEFT ENGINE TORQUE DROPPED TWENTY PERCENT AS IF IT HAD FLAMED OUT. THE ITT DROPPED ABOUT 100 DEGREES AND THEN THE TORQUE SLOWLY ROSE BACK UP TO CLIMB SETTING. THIS OCCURENCE LASTED ABOUSDR SIMA991383Seat Track · corrodedSAW - DURING MBV-1 INSPECTION, FOUND LEFT FORWARD INBOARD AND OUTBOARD, LEFT MIDDLE INBOARD AND OUTBOARD, LEFT AFT INBOARD AND OUTBOARD, LEFT AND RIGHT FLIGHT ATTENDANT, RIGHT FORWARD AND RIGHT MIDDLE OUTBOARD, AND THE RIGHT AFT AND RIGHT MIDDLE INBOARD SEAT TSDR SIMA991382Skin · canningSAW - DURING MBV-1 INSPECTION, MAINTENANCE REPORTED OIL CANNING OF LEFT FUSELAGE SKIN BETWEEN FRAME 9 AND 10 AND STRINGER 14 AND 18. MAINTENANCE INSTALLED A SKIN PATCH AND THREE STIFFENERS IAW ATR DRAWING NR 11S531R016 AND SRM 53-00-00 FIGURE 403. AIRCRAFT RSDR SIMA991381Floorbeam · elongationSAW - DURING CPCP-4 INSPECTION, FOUND FLOORBEAM 18 HAD AN ELONGATED HI-LOCK HOLE. REPAIRED FLOORBEAM 18 IAW SRM 53-00-00 FIGURE 429. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA991233Seat Track · corrodedSAW - DURING CPCP-2 INSPECTION, FOUND THE LEFT INBOARD SEAT TRACK CORRODED. REMOVED AND REPLACED SEAT TRACK IAW EO E9-5300-013. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA991232Floorbeam · corrodedSAW - DURING CPCP-2 INSPECTION, FOUND FLOORBEAM 36 CORRODED. MAINTENANCE REPAIRED FLOORBEAM 36 IAW SRM 53-00-00 FIGURE 435. AIRCRAFT RETURNED TO SERVICE. (M)SDR C2XA99BT036Battery Pack · dischargedBTV - DURING 4A INSPECTION, FOUND SERVICE DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE ON BATTERY PACK. MAINTENANCE REMOVED AND REPLACED EMERGENCY LIGHT POWER SUPPLY BATTERY PACK. OPS CHECKED OF EMERGENCY LIGHTING GOOD. (M)SDR C2XA99BT035Bulb · failedBTV - DURING 4A INSPECTION, FUOND LEFT AISLE PATH EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED TRACK LIGHTING BULB AT END OF AISLE. OPS CHECKED OF EMERGENCY LIGHTS GOOD. (M)SDR SIMA991178Skin · dentedSAW - DURING MBV-2 INSPECTION CLEARED TDMI NR 425MQ53023 TWO DENTS IN THE LEFT SIDE OF THE FUSELAGE SKIN 18 INCHES FORWARD OF THE TAILCONE, BETWEEN FRAMES 46 AND 47 AND BETWEEN STRINGERS 13 AND 16. FORWARD DENT MEASURED 1.5 INCHES INBOARD DIAMETER BY .018 DEESDR SIMA991177Skin · dentedSAW - DURING MBV-2 INSPECTION, FOUND A DENT IN THE LEFT SIDE OF THE FUSELAGE SKIN BETWEEN FRAMES 31 AND 32 AND BETWEEN STRINGER 10 AND 12, MEASURING 3 INCHES IN DIAMETER BY .038 DEEP. REPAIRED THE DENT IAW SRM 53-00-00 FIGURE 403. AIRCRAFT RETURNED TO SERVICSDR C2XA99BT033Connector · looseBTV - DURING LINE CHECK MAINTENANCE, FOUND EMERGENCY LIGHTS DID NOT PASS CHECK. RESECURED CANNON PLUG AT LOCATION 73WL POWER SUPPLY. OPS CHECKED EMERGENCY LIGHT SYSTEM, GOOD. (M)SDR C2XA99BT032Bulb · looseBTV - DURING LINE CHECK, MAINTENANCE FOUND AFT RIGHT EXTERIOR EMERGENCY LIGHT INOPERATIVE. RESECURED BULB IN RIGHT AFT EXTERIOR EMERGENCY LIGHT. OPS CHECKED SYSTEM GOOD. (M)SDR SIMA991001Fan · smokedNAS - FLT 5775 - ROUTINE FLIGHT AT FL 150 APPROX 50 NM WEST OF NAS SMOKE WAS NOTICED IN THE MAIN CABIN AIR CONDITIONING SYSTEM. DECLARED EMERGENCY AND DESCENDED TO 5000 FT DIRECT TO NAS. FOLLOWED EMERGENCY PROCEDURES FOR COCKPIT AND ELECTRICAL SMOKE. ONCE TSDR ASOA99026Wire · chafedEN ROUTE MGM-ATL AT 11,000 FEET, A PITCH DISCONNECT WARNING OCCURRED. CREW DECLARED AN EMERGENCY AND LANDED IN ATL WITHOUT FURTHER INCIDENT. ATL MAINTENANCE FOUND CHAFFED WIRES AT THE DISCONNECT PROX SENSOR. REPLACED AND SECURED WIRES. OPERATIONAL CHECKS WERSDR SIMA990433Cover · missingDFW - FLT 3651 - EXIT LIGHT COVER MISSING AT PASSENGER DOOR ENTRANCE. INSTALLED EXIT LIGHT COVER. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA990396Light · inoperativeMIA - FLT 5672 - ONE FLOOR PROXIMITY LIGHT DOES NOT ILLUMINATE. REMOVED AND REPLACED LIGHT ASSEMBLY. OPERATIONAL CHECK GOOD. (M)SDR SIMA990201Valve · failedCRP - FLT 3674 - SMOKE IN THE COCKPIT. TURNED OFF NR 1 BLEED AD SMOKE CLEARED. DIVERTED TO CRP. FERRIED AIRCRAFT TO DFW FOR REPAIR. REMOVED AND REPLACED NR 1 P2.5 AND P3 AIR SWITCHING VALVE. GROUND RUN CHECKS GOOD. (M)SDR C2XA99IA071Stiffener · crackedIAH - DURING C-CHECK INSPECTION, THE RIGHT HAND BELLY FAIRING STIFFENER ON THE FORWARD SIDE OF FRAME 27 WAS FOUND CRACKED. MAINTENANCE REMOVED AND REPLACED THE STIFFENER IAW ATR-72 SRM 51-24-00, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. ACFT TT: SDR C2XA99IA070Intercostal · crackedIAH - DURING C-CHECK INSPECTION, THE RIGHT HAND BELLY FAIRING INTERCOSTAL CLIP ON THE AFT SIDE OF FRAME 27 WAS FOUND CRACKED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED CLIP IAW ATR-72 SRM 51-24-00, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. ACFSDR C2XA99IA069Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE LEFT HAND AFT INBOARD SEAT TRACK WAS FOUND CORRODED FROM FRAME 29 TO FRAME 36. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SEAT TRACK IAW ATR-72 SRM 51-25-02, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. ACFT TTSDR C2XA99IA068Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE RIGHT HAND FLIGHT ATTENDANT'S SEAT TRACK WAS FOUND CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SEAT TRACK IAW ATR-72 SRM 51-25-02, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. ACFT TT: 11,711.6. CYCLSDR C2XA99IA067Frame · crackedIAH - DURING C-CHECK INSPECTION, THE PASSENGER DOOR FRAME UPPER FLANGE WAS FOUND CRACKED. MAINTENANCE STOP DRILLED THE CRACK AND INSTALLED A REPAIR DOUBLER IAW WITH AR-72 SRM 52-11-00, AND, THE AIRCRAFT WAS THEN APPROVED FOR RETURN TO SERVICE. ACFT TT: 11,7SDR C2XA99IA066Support · crackedIAH - DURING C-CHECK INSPECTION, THE LEFT HAND BELLY FAIRING PANEL 193CL CENTER SUPPORT ON THE MAIN LANDING GEAR FITTING WAS FOUND CRACKED. MAINTENANCE STOP DRILLED THE CRACK AND INSTALLED A REPAIR DOUBLER IAW ATR-72 SRM 51-70-00 AND SRM 51-25-02. THE AIRCRASDR SIMA990135Battery Pack · dischargedDFW - FLT 3656 - NINE BULBS ON FLOOR PROXIMITY LIGHT PATH DO NOT ILLUMINATE. REMOVED AND REPLACED BATTERY PACK. OPERATIONAL CHECK GOOD. (M)SDR SIMA990131Skin · puncturedABI - PERFORM PERMANENT REPAIR OF PUNCTURE ON RT FORWARD FUSELAGE BETWEEN FRAMES 11 AND 12 AND BETWEEN STRINGER 19 AND 20. CUT OUT DAMAGED SKIN AND PERFORMED AN EDDY CURRENT INSPECTION WITH NO INDICATIONS OF CRACKS. REMOVED DAMAGED INTERCOSTAL. FABRICATED ASDR ASOA99007Power Supply · defectiveCREW REPORTED THAT THE AFT EMERGENCY FLOOR TRACK LIGHTING REMAINS ON, AND ALSO WHEN THE EMERGENCY EXIT LIGHT IS ARMED. THE LIGHTS REMAIN ON WITH AIRCRAFT POWER ON. ATL MAINTENANCE REMOVED AND REPLACED THE EMERGENCY LIGHTING POWER SUPPLIES AT 62WL AND 73WL. OPSDR 99ZZZM137Intercostal · damagedABI - PERFORM PERMANENT REPAIR OF PUNCTURE ON RT FORWARD FUSELAGE BETWEEN FRAMES 11 AND 12 AND BETWEEN STRINGER 19 AND 20. CUT OUT DAMAGED SKIN AND PERFORMED AN EDDY CURRENT INSPECTION WITH NO INDICATIONS OF CRACKS. REMOVED DAMAGED INTERCOSTAL. FABRICATED ASDR SIMA990101Connector · looseHOU - 3627 - SOME OF THE AFT EMERGENCY EXIT LIGHTS DO NOT ILLUMINATE. RESEATED THE CONNECTOR ON THE AFT BATTERY PACK. OPERATIONAL CHECK GOOD. (M)SDR SIMA990097Smoke Detector · malfunctionedFLT 9724 - CRP - ELECTRICAL SMOKE INDICATION ON CWP ILLUMINATED. FERRIED AIRCRAFT TO DFW FOR REPAIR. REMOVED AND REPLACED AVIONICS EXTRACTION FAN AND SMOKE DETECTOR. PERFORMED OPERATIONAL TESTS AND TEST FLIGHT WITH NO FURTHER SMOKE INDICATIONS NOTED. AIRCRSDR SIMA990096Smoke Detector · malfunctionedCRP - FLT 3739 - ELECTRICAL SMOKE INDICATION ON CWP ILLUMINATED. REMOVED AND REPLACED FORWARD ELECTRONICS RACK SMOKE DETECTOR. OPERATIONAL TESTS NORMAL. NO FURTHER SMOKE INDICATIONS NOTED. (M)SDR SIMA990094Brake · inoperativeMIA - FLT 5799 - FIRST OFFICERS BRAKES INOPERATIVE. BLED BRAKE SYSTEM. FUNCTIONAL CHECK GOOD. (M)SDR 99ZZZM164Fan · failedFLT 9724 - CRP - ELECTRICAL SMOKE INDICATION ON CWP ILLUMINATED. FERRIED AIRCRAFT TO DFW FOR REPAIR. REMOVED AND REPLACED AVIONICS EXTRACTION FAN AND SMOKE DETECTOR. PERFORMED OPERATIONAL TESTS AND TEST FLIGHT WITH NO FURTHER SMOKE INDICATIONS NOTED. AIRCRSDR SIMA990072Battery Pack · dischargedSGF - FLT 4370 - FLOOR PROXIMITY LIGHTS IN AFT CABIN AND SERVICE DOOR EMERGENCY EXIT SIGN DO NOT ILLUMINATE. REMOVED AND REPLACED A BATTERY PACK FOR THE FLOOR PROXIMITY LIGHTS AND THE LIGHT BULBS IN THE EMERGENCY EXIT SIGN. OPERATIONAL CHECKS GOOD. (M)SDR 99ZZZM149Bulbs · failedSGF - FLT 4370 - FLOOR PROXIMITY LIGHTS IN AFT CABIN AND SERVICE DOOR EMERGENCY EXIT SIGN DO NOT ILLUMINATE. REMOVED AND REPLACED A BATTERY PACK FOR THE FLOOR PROXIMITY LIGHTS AND THE LIGHT BULBS IN THE EMERGENCY EXIT SIGN. OPERATIONAL CHECKS GOOD. (M)SDR SIMA983495Crank Lever · looseDFW - DURING COMPLIANCE OF AD 93-12-10, FOUND CRANK LEVER IN RIGHT WING AT RIB 22 WITH LOOSE BEARING. REMOVED AND REPLACED CRANK LEVER. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA983494Crank Lever · looseDFW - DURING COMPLIANCE OF AD 93-12-10, FOUND CRANK LEVER IN LEFT WING AT RIB 15 WITH LOOSE BEARING. REMOVED AND REPLACED CRANK LEVER. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA983493Bellcrank · looseDFW - DURING COMPLIANCE OF AD 93-12-10, FOUND BELLCRANK IN RIGHT WING AT RIB 26 WITH LOOSE CENTER BEARING. REMOVED AND REPLACED BELLCRANK. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA983443Skin · damagedABI - DAMAG TO THE LOWER AFT FUSELAGE SKIN AND STRINGERS BETWEEN FRAMES 46 AND 47. REMOVED DAMAGED SKIN AND STRINGERS 17 LEFT AND 17 RIGHT AND CUT TO LENGTH NEW STRINGERS EXTRUSION AND FABRICATED CONNECTING SECTION. FABRICATED REPAIR SKIN .032 THICK AND SPLI
Back to Aerospatiale ATR 72-212