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 99ZZZM105Stringer · 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 SPLISDR SIMA983432Battery · dischargedORD - FLT 3567 - AFT EMERGENCY LIGHTS OVER PASSENGER AND SERVICE DOOR DO NOT ILLUMINATE. REMOVED AND REPLACED EMERGENCY POWER SUPPLY. OPERATIONAL CHECK GOOD. (M)SDR SIMA983331Mfc · failedMIA - FLT 5782 - LEFT MAIN LANDING GEAR UNLOCK LIGHT ON OVERHEAD PANEL IS ILLUMINATED. REMOVED AND REPLACED NR 2 MULTIFUNCTION COMPUTER (MFC). GEAR EXTENSION/RETRACTION CHECKS GOOD. (M)SDR SIMA983263Pump · malfunctionedDFW - FLT 3626 - AFTER TAKEOFF, THE NR 1 ENGINE FEATHERING PUMP CIRCUIT BREAKER POPPED. CREW RESET IT AND IT POPPED AGAIN. REMOVED AND REPLACED FEATHERING PUMP. OPERATIONAL CHECK GOOD. (M)SDR SIMA983172Skin · dentedABI - TWO DENTS AT LEFT FUSELAGE BETWEEN FRAMES 31 AND 33 JUST ABOVE AND BELOW STRINGER 12. CUT OUT DAMAGED AREA AND PERFORMED EDDY CURRENT INSPECTION, NO INDICATION OF CRACKS. FABRICATED AND INSTALLED EXTERNAL DOUBLER AND A FILLER PIECE .050 THICK. AIRCRAFSDR SIMA983092Power Supply · inoperativeDFW - FLT 3504 - SOME EMERGENCY FLOOR LIGHTS REMAIN ILLUMINATED. REMOVED AND REPLACED EMERGENCY LIGHT POWER SUPPLY AND BATTERY PACK. (M)SDR 98ZZZM875Power Supply · inoperativeDFW - FLT 3504 - SOME EMERGENCY FLOOR LIGHTS REMAIN ILLUMINATED. REMOVED AND REPLACED EMERGENCY LIGHT POWER SUPPLY AND BATTERY PACK. (M)SDR SIMA983071Line · failedDFW - FLT 3690 - GREEN SYSTEM HYDRAULIC LOW LEVEL WARNING LIGHT CAME ON. PULLED EMERGENCY GEAR EXTENSION HANDLE. REMOVED AND REPLACED BROKEN PIPE FROM THE GREEN ACCUMULATOR TO THE BRAKE MANIFOLD. RESERVICED HYDRAULIC SYSTEM AND PERFORMED LEAK CHECK. AIRCRASDR SIMA983032Battery Pack · dischargedDFW - FLT 3613 - FORWARD EMERGENCY LIGHTS DO NOT TEST CORRECTLY. REMOVED AND REPLACED FORWARD EMERGENCY LIGHT POWER SUPPLY. OPERATIONAL CHECK GOOD. (M)SDR SIMA983023Acm · seizedMIA - FLT 5804 - FOUL ODOR MIXED WITH POSSIBLE SMOKE IN THE CABIN/COCKPIT. SMELL ISOLATED TO THE LEFT ACM. REMOVED AND REPLACED AIR CYCLE MACHINE. (M)SDR SIMA983022Duct · crackedDFW - FLT 3597 - AT 200 FT, THE NR 2 ENGINE TORQUE BEGAN TO FLUCTUATE AND THE HIGH ITT LIGHT ILLUMINATED. CREW REDUCED POWER TO GET THE ITT DOWN, BUT THE ITT SPIKED AGAIN WITH HIGH ITT LIGHT. CREW SHUT DOWN THE ENGINE, DECLARED AN EMERGENCY AND LANDED SAFELYSDR SIMA983003Skin · dentedABI - DAMAGE ON RIGHT LOWER FUSELAGE BETWEEN FRAMES 8 AND 10, AND BETWEEN STRINGER 20 AND BL 0. CUT OUT DAMAGE, PERFORMED EDDY CURRENT INSPECTION. FABRICATED AND INSTALLED EXTERNAL DOUBLER. AIRCRAFT RETURNED TO SERVICE. (M)SDR C2XA98BT078Smoke Detector · malfunctionedUPON TAXIING IN TO GATE AREA, CREW REPORTED AFT SMOKE MASTER WARNING INDICATOR REPEATED. MAINTENANCE REMOVED AND REPLACED THE AUX AND AFT CARGO COMPARTMENT SMOKE DETECTORS. OPS AND FUNCTIONALLY CHECK GOOD. (M)SDR SIMA982858Web · corrodedABI - SEAT TRACK, FLOOR SUPPORT WEBS AND ENTRY FLOORBEAMS ARE CORRODED BETWEEN FRAMES 36 AND 39. REMOVED AND REPLACED SEAT TRACK, WEBS AND FLOORBEAM. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA982857Seat Track · corrodedABI - SEAT TRACK BETWEEN FRAMES 29 AND 35, AND BETWEEN FRAMES 23 TO 29 ARE CORRODED. REMOVED AND REPLACED SEAT TRACKS. (M)SDR 98ZZZM810Floorbeam · corrodedABI - SEAT TRACK, FLOOR SUPPORT WEBS AND ENTRY FLOORBEAMS ARE CORRODED BETWEEN FRAMES 36 AND 39. REMOVED AND REPLACED SEAT TRACK, WEBS AND FLOORBEAM. AIRCRAFT RETURNED TO SERVICE. (M)SDR 98ZZZM809Seat Track · corrodedABI - SEAT TRACK, FLOOR SUPPORT WEBS AND ENTRY FLOORBEAMS ARE CORRODED BETWEEN FRAMES 36 AND 39. REMOVED AND REPLACED SEAT TRACK, WEBS AND FLOORBEAM. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA98281Bulb · failedMIA - FLT 5700 - FOUND EMERGENCY LIGHT AT PAX DOOR STATION DOES NOT ILLUMINATE. REMOVED AND REPLACED BULB. OPERATIONAL CHECK GOOD. (M)SDR SIMA982802Transformer · failedDFW - FLT 3625 - AIRCRAFT RETURNED TO DFW DUE TO ODOR OF SMOKE IN THE CABIN. EMEGENCY WAS DECLARED. AIRCRAFT LANDED SAFELY. REMOVED AND REPLACED SHORTED OUT TRANSFORMER AT SEAT 6CD PSU PANEL. OPERATIONAL CHECK GOOD. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA982744Floorbeam · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND THE RIGHT AND LEFT SIDE OF FLOORBEAM 36 CORRODED. REMOVED AND REPLACED FLOORBEAM. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA982743Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND THE ELFT AFT INBOARD AND OUTBOARD, AND THE LEFT FORWARD OUTBOARD SEAT TRACKS CORRODED. REMOVED AND REPLACED THE SEAT TRACKS. AIRCRAFT RETURNED TO SERVICE. (M)SDR 98ZZZM814Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND THE ELFT AFT INBOARD AND OUTBOARD, AND THE LEFT FORWARD OUTBOARD SEAT TRACKS CORRODED. REMOVED AND REPLACED THE SEAT TRACKS. AIRCRAFT RETURNED TO SERVICE. (M)SDR 98ZZZM813Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND THE ELFT AFT INBOARD AND OUTBOARD, AND THE LEFT FORWARD OUTBOARD SEAT TRACKS CORRODED. REMOVED AND REPLACED THE SEAT TRACKS. AIRCRAFT RETURNED TO SERVICE. (M)SDR C2XA98BT072Switch · inoperativeFLT 3519 - CREW REPORTED EMERGENCY EXIT LIGHTS WILL NOT EXTINGUISH USING TWO MINUTE LIGHT SWITCH. MAINTENANCE REPORTED, REMOVED AND REPLACED TWO MINUTE SWITCH, OPS CHECKED GOOD. (M)SDR SIMA982601Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND RIGHT MIDDLE AND AFT OUTBOARD, AND LEFT AND RIGHT FLIGHT ATTENDANT SEAT TRACKS CORRODED. REMOVED AND REPLACED SEAT TRACKS. AIRCRAFT RETURNED TO SERVICE. (M)SDR 98ZZZM737Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND RIGHT MIDDLE AND AFT OUTBOARD, AND LEFT AND RIGHT FLIGHT ATTENDANT SEAT TRACKS CORRODED. REMOVED AND REPLACED SEAT TRACKS. AIRCRAFT RETURNED TO SERVICE. (M)SDR 98ZZZM736Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND RIGHT MIDDLE AND AFT OUTBOARD, AND LEFT AND RIGHT FLIGHT ATTENDANT SEAT TRACKS CORRODED. REMOVED AND REPLACED SEAT TRACKS. AIRCRAFT RETURNED TO SERVICE. (M)SDR 98ZZZM735Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND RIGHT MIDDLE AND AFT OUTBOARD, AND LEFT AND RIGHT FLIGHT ATTENDANT SEAT TRACKS CORRODED. REMOVED AND REPLACED SEAT TRACKS. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA982562Seat Track · corrodedABI - DURING CPCP-2 INSPECTION, FOUND THE RIGHT FLIGHT ATTENDANT SEAT TRACK CORRODED. REMOVED AND REPLACED SEAT TRACK. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA982531Zee Member · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND RIGHT AFT ZEE MEMBER BETWEEN FRAMES 39 AND 41 CORRODED. REMOVED AND REPLACED ZEE MEMBER. AIRCRAFT RETURNED TO SERVICE. (M)SDR 98ZZZM718Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND LEFT AFT OUTBOARD AND INBOARD, AND THE LEFT FLIGHT ATTENDANT SEAT TRACKS CORRODED. REMOVED AND REPLACED SEAT TRACKS. AIRCRAFT RETURNED TO SERVICE. (M)SDR 98ZZZM717Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND LEFT AFT OUTBOARD AND INBOARD, AND THE LEFT FLIGHT ATTENDANT SEAT TRACKS CORRODED. REMOVED AND REPLACED SEAT TRACKS. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA982511Floorbeam · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND FLOORBEAM 36, 38, AND 39 CORRODED. REMOVED AND REPLACED FLOORBEAMS 36, 38, AND 39. AIRCRAFT RETURNED TO SERVICE. (M)SDR 98ZZZM722Floorbeam · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND FLOORBEAM 36, 38, AND 39 CORRODED. REMOVED AND REPLACED FLOORBEAMS 36, 38, AND 39. AIRCRAFT RETURNED TO SERVICE. (M)SDR 98ZZZM721Floorbeam · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND FLOORBEAM 36, 38, AND 39 CORRODED. REMOVED AND REPLACED FLOORBEAMS 36, 38, AND 39. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA982502Plate · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND THE SERVICE DOOR SILL PLATE CORRODED. REMOVED AND REPLACED SILL PLATE. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA982501Seat Track · corrodedDURING CPCP-8 INSPECTION, FOUND LEFT FORWARD, MIDDLE AND AFT OUTBOARD, LEFT AFT INBOARD, AND THE LEFT AND RIGHT FLIGHT ATTENDANT SEAT TRACKS CORRODED. REMOVED AND REPLACED SEAT TRACKS. AIRCRAFT RETURNED TO SERVICE. (M)SDR 98ZZZM726Seat Track · corrodedDURING CPCP-8 INSPECTION, FOUND LEFT FORWARD, MIDDLE AND AFT OUTBOARD, LEFT AFT INBOARD, AND THE LEFT AND RIGHT FLIGHT ATTENDANT SEAT TRACKS CORRODED. REMOVED AND REPLACED SEAT TRACKS. AIRCRAFT RETURNED TO SERVICE. (M)SDR 98ZZZM725Seat Track · corrodedDURING CPCP-8 INSPECTION, FOUND LEFT FORWARD, MIDDLE AND AFT OUTBOARD, LEFT AFT INBOARD, AND THE LEFT AND RIGHT FLIGHT ATTENDANT SEAT TRACKS CORRODED. REMOVED AND REPLACED SEAT TRACKS. AIRCRAFT RETURNED TO SERVICE. (M)SDR 98ZZZM724Seat Track · corrodedDURING CPCP-8 INSPECTION, FOUND LEFT FORWARD, MIDDLE AND AFT OUTBOARD, LEFT AFT INBOARD, AND THE LEFT AND RIGHT FLIGHT ATTENDANT SEAT TRACKS CORRODED. REMOVED AND REPLACED SEAT TRACKS. AIRCRAFT RETURNED TO SERVICE. (M)SDR 98ZZZM723Seat Track · corrodedDURING CPCP-8 INSPECTION, FOUND LEFT FORWARD, MIDDLE AND AFT OUTBOARD, LEFT AFT INBOARD, AND THE LEFT AND RIGHT FLIGHT ATTENDANT SEAT TRACKS CORRODED. REMOVED AND REPLACED SEAT TRACKS. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA982532Floorbeam · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND LEFT FLOORBEAM 36, 38, AND 39 CORRODED. REMOVED AND REPLACED FLOORBEAMS. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA982493Plate · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND PAX DOOR SILL PLATE CORRODED. REMOVED AND REPLACED THE SILL PLATE. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA982492Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND THE FOLLOWING SEAT TRACKS CORRODED. LOCATIONS WERE THE LEFT FORWARD, MIDDLE AND AFT OUTBOARD, LEFT AFT INBOARD, LEFT AND RIGHT FLIGHT ATTENDANT SEAT TRACKS. THE RIGHT MIDDLE INBOARD AND OUTBOARD, AND THE RIGHT AFT CARGO SDR C2XA98BT066Light · inoperativeBTV - DURING 3 A INSPECTION FOUND PASSENGER DOOR EMERGENCY LIGHT INOPE RATIVE. REMOVED AND REPLACED LIGHT ASSY. OPS CHECK GOOD. (M)SDR 98ZZZM720Floorbeam · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND LEFT FLOORBEAM 36, 38, AND 39 CORRODED. REMOVED AND REPLACED FLOORBEAMS. AIRCRAFT RETURNED TO SERVICE. (M)SDR 98ZZZM719Floorbeam · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND LEFT FLOORBEAM 36, 38, AND 39 CORRODED. REMOVED AND REPLACED FLOORBEAMS. AIRCRAFT RETURNED TO SERVICE. (M)SDR 98ZZZM704Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND THE FOLLOWING SEAT TRACKS CORRODED. THE LEFT FORWARD, MIDDLE AND AFT OUTBOARD, LEFT AFT INBOARD, LEFT AND RIGHT FLIGHT ATTENDANT SEAT TRACKS. THE RIGHT MIDDLE INBOARD AND OUTBOARD, AND THE RIGHT AFT CARGO TRACKS CORRODEDSDR 98ZZZM703Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND THE FOLLOWING SEAT TRACKS CORRODED. LEFT FORWARD, MIDDLE AND AFT OUTBOARD, LEFT AFT INBOARD, LEFT AND RIGHT FLIGHT ATTENDANT. THE RIGHT MIDDLE INBOARD AND OUTBOARD, AND THE RIGHT AFT CARGO TRACKS CORRODED. REMOVED AND RSDR 98ZZZM702Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND CORROSION AT THE FOLLOWING TRACK LOCATIONS. LEFT FORWARDRD, MIDDLE AND AFT OUTBOARD, LEFT AFT INBOARD, LEFT AND RIGHT FLIGHT ATTENDANT. THE RIGHT MIDDLE INBOARD AND OUTBOARD, AND THE RIGHT AFT CARGO SEAT TRACKS CORRODED.
Back to Aerospatiale ATR 72-212