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 SIMA981985Seat Track · corrodedSAW - DURING CPCP-2 INSPECTION, MAINTENANCE REPORTED THE LEFT FLIGHT ATTENDANT, RIGHT FLIGHT ATTENDANT, LEFT AFT INBOARD AND THE LEFT MIDDLE OUTBOARD SEAT TRACKS CORRODED. MAINTENANCE REMOVED AND REPLACED BOTH FLIGHT ATTENDANT AND THE LEFT AFT INBOARD SEAT TRSDR SIMA981984Sill Plate · corrodedSAW - DURING CPCP-2 INSPECTION, MAINTENANCE REPORTED THE SERVICE DOOR SILL PLATE AND DRAIN GULLEY CORRODED. MAINTENANCE REMOVED AND REPLACED THE SILL PLATE AND DRAIN GULLEY IAW SRM 51-25-02. AIRCRAFT WAS RETURNED TO SERVICE. REF: OPER CONTROL NR 98ZZZX2835SDR SIMA981983Pan · corrodedSAW - DURING CPCP-2 INSPECTION, MAINTENANCE REPORTED THE PASSENGER DOOR UPPER PAN CORRODED. MAINTENANCE REMOVED AND REPLACED THE PAN IAW SRM 52-11-00. AIRCRAFT WAS RETURNED TO SERVICE. ACFT TT: 11,704.9 HOURS. ACFT TC: 12,665. (X)SDR SIMA981982Sill Plate · corrodedSAW - DURING CPCP-2 INSPECTION, MAINTENANCE REPORTED THE PASSENGER DOORSILL PLATE AND COVER PLATE CORRODED. MAINTENANCE REMOVED AND REPLACED BOTH PLATES IAW SRM 51-25-02. AIRCRAFT WAS RETURNED TO SERVICE. REF: OPER CONTROL NR 98ZZZX2834. ACFT TT: 11,704.SDR SIMA9819810Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND THE LEFT FORWARD AND AFT OUTBOARD, LEFT AND RIGHT AFT INBOARD AND THE RIGHT MIDDLE OUTBOARD SEAT TRACKS CORRODED. REMOVED AND REPLACED THE SEAT TRACKS. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA981981Bracket · corrodedSAW - DURING CPCP-2 INSPECTION, MAINTENANCE REPORTED THE PAX DOOR HANDRAIL BRACKET, TEE FITTING ON PAX DOOR SILL PLATE AND FLOOR SUPPORT BETWEEN FRAMES 36 AND 39 CORRODED. MAINTENANCE REMOVED AND REPLACED ALL THREE ITEMS IAW SRM 51-25-02. A/C WAS RETURNED TOSDR 98ZZZX2838Seat Track · corrodedSAW - DURING CPCP-2 INSPECTION, MAINTENANCE REPORTED THE LEFT FLIGHT ATTENDANT, RIGHT FLIGHT ATTENDANT, LEFT AFT INBOARD AND THE LEFT MIDDLE OUTBOARD SEAT TRACKS CORRODED. MAINTENANCE REMOVED AND REPLACED BOTH FLIGHT ATTENDANT AND THE LEFT AFT INBOARD SEAT TRSDR 98ZZZX2837Seat Track · corrodedSAW - DURING CPCP-2 INSPECTION, MAINTENANCE REPORTED THE LEFT FLIGHT ATTENDANT, RIGHT FLIGHT ATTENDANT, LEFT AFT INBOARD AND THE LEFT MIDDLE OUTBOARD SEAT TRACKS CORRODED. MAINTENANCE REMOVED AND REPLACED BOTH FLIGHT ATTENDANT AND THE LEFT AFT INBOARD SEAT TRSDR 98ZZZX2836Seat Track · corrodedSAW - DURING CPCP-2 INSPECTION, MAINTENANCE REPORTED THE LEFT FLIGHT ATTENDANT, RIGHT FLIGHT ATTENDANT, LEFT AFT INBOARD AND THE LEFT MIDDLE OUTBOARD SEAT TRACKS CORRODED. MAINTENANCE REMOVED AND REPLACED BOTH FLIGHT ATTENDANT AND THE LEFT AFT INBOARD SEAT TRSDR 98ZZZX2835Drain Gulley · corrodedSAW - DURING CPCP-2 INSPECTION, MAINTENANCE REPORTED THE SERVICE DOOR SILL PLATE AND DRAIN GULLEY CORRODED. MAINTENANCE REMOVED AND REPLACED THE SILL PLATE AND DRAIN GULLEY IAW SRM 51-25-02. AIRCRAFT WAS RETURNED TO SERVICE. ACFT TT: 11,704.9 HOURS. ACFT SDR 98ZZZX2834Cover Plate · corrodedSAW - DURING CPCP-2 INSPECTION, MAINTENANCE REPORTED THE PASSENGER DOORSILL PLATE AND COVER PLATE CORRODED. MAINTENANCE REMOVED AND REPLACED BOTH PLATES IAW SRM 51-25-02. AIRCRAFT WAS RETURNED TO SERVICE. ACFT TT: 11,704.9 HOURS. ACFT TC: 12,665. REF: SDR 98ZZZM571Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND THE LEFT FORWARD AND AFT OUTBOARD, LEFT AND RIGHT AFT INBOARD AND THE RIGHT MIDDLE OUTBOARD SEAT TRACKS CORRODED. REMOVED AND REPLACED THE SEAT TRACKS. AIRCRAFT RETURNED TO SERVICE. (M)SDR 98ZZZM570Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND THE LEFT FORWARD AND AFT OUTBOARD, LEFT AND RIGHT AFT INBOARD AND THE RIGHT MIDDLE OUTBOARD SEAT TRACKS CORRODED. REMOVED AND REPLACED THE SEAT TRACKS. AIRCRAFT RETURNED TO SERVICE. (M)SDR 98ZZZM569Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND THE LEFT FORWARD AND AFT OUTBOARD, LEFT AND RIGHT AFT INBOARD AND THE RIGHT MIDDLE OUTBOARD SEAT TRACKS CORRODED. REMOVED AND REPLACED THE SEAT TRACKS. AIRCRAFT RETURNED TO SERVICE. (M)SDR 98ZZZM568Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND THE LEFT FORWARD AND AFT OUTBOARD, LEFT AND RIGHT AFT INBOARD AND THE RIGHT MIDDLE OUTBOARD SEAT TRACKS CORRODED. REMOVED AND REPLACED THE SEAT TRACKS. AIRCRAFT RETURNED TO SERVICE. (M)SDR 98ZZZM558Support · corrodedSAW - DURING CPCP-2 INSPECTION, MAINTENANCE REPORTED THE PAX DOOR HANDRAIL BRACKET, TEE FITTING ON PAX DOOR SILL PLATE AND FLOOR SUPPORT BETWEEN FRAMES 36 AND 39 CORRODED. MAINTENANCE REMOVED AND REPLACED ALL THREE ITEMS IAW SRM 51-25-02. A/C WAS RETURNED TOSDR 98ZZZM557Tee Fitting · corrodedSAW - DURING CPCP-2 INSPECTION, MAINTENANCE REPORTED THE PAX DOOR HANDRAIL BRACKET, TEE FITTING ON PAX DOOR SILL PLATE AND FLOOR SUPPORT BETWEEN FRAMES 36 AND 39 CORRODED. MAINTENANCE REMOVED AND REPLACED ALL THREE ITEMS IAW SRM 51-25-02. A/C WAS RETURNED TOSDR SIMA981971Bulb · failedORD - FLT 4107 - REAR MOST FLOOR PROX LIGHT INOP. RAI'D BULB. PERFORMED OPERATION CHECK SATISFACTORILY AND RETURNED A/C TO SERVICE. (M)SDR SIMA981892Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, MAINTENANCE REPORTED THE LEFT MIDDLE INBOARD, LEFT AFT INBOARD, LEFT AFT OUTBOARD, RIGHT MIDDLE INBOARD, RIGHT MIDDLE OUTBOARD AND RIGHT AFT INBOARD SEAT TRACKS CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACKS IAW SRMSDR 98ZZZM561Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, MAINTENANCE REPORTED THE LEFT MIDDLE INBOARD, LEFT AFT INBOARD, LEFT AFT OUTBOARD, RIGHT MIDDLE INBOARD, RIGHT MIDDLE OUTBOARD AND RIGHT AFT INBOARD SEAT TRACKS CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACKS IAW SRMSDR 98ZZZM560Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, MAINTENANCE REPORTED THE LEFT MIDDLE INBOARD, LEFT AFT INBOARD, LEFT AFT OUTBOARD, RIGHT MIDDLE INBOARD, RIGHT MIDDLE OUTBOARD AND RIGHT AFT INBOARD SEAT TRACKS CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACKS IAW SRMSDR 98ZZZM559Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, MAINTENANCE REPORTED THE LEFT MIDDLE INBOARD, LEFT AFT INBOARD, LEFT AFT OUTBOARD, RIGHT MIDDLE INBOARD, RIGHT MIDDLE OUTBOARD AND RIGHT AFT INBOARD SEAT TRACKS CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACKS IAW SRMSDR SIMA981824Rgb · damagedHRL - FLT 3724 - AFTER TAKEOFF FROM HRL THE FLT CREW SELECTED 'CLIMB' ON THE POWER MANAGEMENT PANEL AND BEGAN TO BRING THE CONDITION LEVERS BACK TO ACHIEVE 86 PERCENT NP WHEN THE NR 1 ENGINE BEGAN TO SURGE AND THEN THE TQ WENT TO ZERO. THE NP STABILIZED AT 30SDR SIMA981823Gearbox · damagedHRL - FLT 3724 - AFTER TAKEOFF, CREW SELECTED 'CLIMB' ON POWER MGMNT PANEL AND BEGAN TO BRING CONDITION LEVERS BACK TO 86 PERCENT NP WHEN THE NR 1 ENGINE BEGAN TO SURGE, THEN TORQUE WENT TO ZERO. NP STABILIZED AT 30 PERCENT AND NH AT 45 PERCENT. SHUT DOWN THSDR C2XA98BT045Pcu · failedEWR - FLT 3308 - ON TAKEOFF FROM NEWARK, AIRCRAFT NR 1 ENGINE STARTED TO FEATHER, ABORTED TAKEOFF AND RETURNED TO GATE. MAINTENANCE TROUBLESHOT AND FOUND THE PROPELLER CONTROL UNIT TO BE CAUSING THE PROBLEM. REMOVED AND REPLACED PCU WITH SERVICEABLE UNIT, OPSDR SIMA981738Gulley · corrodedSAW - DURING CPCP8 INSPECTION, FOUND RAIN GULLEY ON PASSENGER DOOR SILL PLATE TO HAVE CORROSION. REMOVED AND REPLACED RAIN GULLEY ON PASSENGER DOOR SILL PLATE. (X)SDR SIMA981737Sill · corrodedSAW - DURING CPCP8 INSPECTION, FOUND PASSENGER DOOR SILL PLATE TO HAVE CORROSION. REMOVED AND REPLACED PASSENGER DOOR SILL PLATE. (X)SDR SIMA981736Seat Track · corrodedSAW - DURING CPCP8 INSPECTION, FOUND LEFT FLIGHT ATTENDANT'S SEAT TRACK TO HAVE CORROSION BETWEEN FLOORBEAM 36 AND FLOORBEAM 39. REMOVED AND REPLACED LEFT FLIGHT ATTENDANT'S SEAT TRACK BETWEEN FLOORBEAM 36 AND FLOORBEAM 39. (X)SDR SIMA981735Sill · corrodedSAW - DURING CPCP8 INSPECTION, FOUND SERVICE DOOR SILL PLATE CORRODED. REMOVED AND INSTALLED NEW SERVICE DOOR SILL PLATE. (X)SDR SIMA981734Seat Track · corrodedSAW - DURING CPCP8 INSPECTION, FOUND LEFT AFT OUTBOARD SEAT TRACK CORRODED BETWEEN FRAME 29 AND FRAME 36. REMOVED AND INSTALLED NEW LEFT AFT OUTBOARD SEAT TRACK BETWEEN FRAMES 29 AND FRAME 36. (X)SDR SIMA981733Floorbeam · corrodedSAW - DURING CPCP8 INSPECTION, FOUND FLOORBEAM 36 CORRODED. REMOVED AND REPLACED FLOORBEAM 36. (X)SDR SIMA981732Seat Track · corrodedSAW - DURING CPCP8 INSPECTION, FOUND LEFT AFT INBOARD SEAT TRACK CORRODED FROM FRAME 29 TO FRAME 36. REMOVED AND INSTALLED NEW SEAT TRACK BETWEEN FRAME 29 AND FRAME 36. (X)SDR SIMA981731Support · corrodedSAW - DURING CPCP8 INSPECTION, FOUND FLOOR SUPPORT CHANNEL BETWEEN FRAMES 38 AND 39, UNDER PASSENGER DOOR SILL PLATE, CORRODED. INSTALLED NEW FLOOR CHANNEL SUPPORT BETWEEN FRAMES 38 AND 39. (X)SDR SIMA981721Battery Pack · dischargedORD - FLT 4151 - NINE EMERGENCY FLOOR PROXIMITY LIGHTS IN AFT OF AIRCRAFT AND ONE EXIT SIGN ON AFT WALL DO NOT ILLUMINATE. REMOVED AND REPLACED BATTERY PACK 73WL. OPERATIONAL CHECK GOOD. (X)SDR SIMA981697Floorbeam · corrodedSAW - DURING CPCP-4 INSPECTION, FOUND FLOORBEAMS 36 AND 38 CORRODED. REMOVED AND REPLACED BOTH FLOORBEAMS. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA981696Support · corrodedSAW - DURING CPCP-4 INSPECTION, FOUND THE SERVICE DOOR SILL PLATE SUPPORT AND DRAIN TRACK CORRODED AT FRAME 37. REMOVED AND REPLACED THE SILL PLATE SUPPORT AND DRAIN TRACK. AIRCRAFT RETURNED TO SERVICE. (M)SDR 98ZZZM513Drain · corrodedSAW - DURING CPCP-4 INSPECTION, FOUND THE SERVICE DOOR SILL PLATE SUPPORT AND DRAIN TRACK CORRODED AT FRAME 37. REMOVED AND REPLACED THE SILL PLATE SUPPORT AND DRAIN TRACK. AIRCRAFT RETURNED TO SERVICE. (M)SDR 98ZZZM512Floorbeam · corrodedSAW - DURING CPCP-4 INSPECTION, FOUND FLOORBEAMS 36 AND 38 CORRODED. REMOVED AND REPLACED BOTH FLOORBEAMS. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA981668Skin · gougedORD - FLT 4070 - JET BRIDGE STRUCK FUSELAGE. CAUSED SKIN DAMAGE AT FS 2086. CUT OUT DAMAGE, INSTALLED 15 INCH BY 16 INCH REPAIR DOUBLER. ACFT TT: 1,680.3 HOURS. ACFT TC: 2,339. (X)SDR SIMA981672Air Distribution · odorDFW - FLT 3535 - FLT ATTENDANT REPORTS AN ELECTRICAL SMOKE SMELL IN THE CABIN. INSPECTED AND FOUND NO EVIDENCE OF SMOKE/SMELL IN CABIN. ALL LIGHTS WORKING OK. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA981655Sill · corrodedSAW - DURING CPCP-4 INSPECTION, FOUND THE PAX DOOR SILL PLATE AND DRAIN TRACK CORRODED. REMOVED AND REPLACED THE SILL PLATE AND DRAIN TRACK. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA981654Seat Track · corrodedSAW - DURING CPCP-4 INSPECTION, MAINTENANCE FOUND THE LEFT FORWARD INBOARD AND OUTBOARD, LEFT AFT INBOARD. THE LEFT AND RIGHT MIDDLE INBOARD AND OUTBOARD AND THE LEFT AND RIGHT AFT FLIGHT ATTENDANT SEAT TRACKS CORRODED. REMOVED AND REPLACED ALL SEAT TRACKS. SDR 98ZZZM522Seat Track · corrodedSAW - DURING CPCP-4 INSPECTION, MAINTENANCE FOUND THE LEFT FORWARD INBOARD AND OUTBOARD, LEFT AFT INBOARD. THE LEFT AND RIGHT MIDDLE INBOARD AND OUTBOARD AND THE LEFT AND RIGHT AFT FLIGHT ATTENDANT SEAT TRACKS CORRODED. REMOVED AND REPLACED ALL SEAT TRACKS. SDR 98ZZZM521Seat Track · corrodedSAW - DURING CPCP-4 INSPECTION, MAINTENANCE FOUND THE LEFT FORWARD INBOARD AND OUTBOARD, LEFT AFT INBOARD. THE LEFT AND RIGHT MIDDLE INBOARD AND OUTBOARD AND THE LEFT AND RIGHT AFT FLIGHT ATTENDANT SEAT TRACKS CORRODED. REMOVED AND REPLACED ALL SEAT TRACKS. SDR 98ZZZM520Seat Track · corrodedSAW - DURING CPCP-4 INSPECTION, MAINTENANCE FOUND THE LEFT FORWARD INBOARD AND OUTBOARD, LEFT AFT INBOARD. THE LEFT AND RIGHT MIDDLE INBOARD AND OUTBOARD AND THE LEFT AND RIGHT AFT FLIGHT ATTENDANT SEAT TRACKS CORRODED. REMOVED AND REPLACED ALL SEAT TRACKS. SDR 98ZZZM519Seat Track · corrodedSAW - DURING CPCP-4 INSPECTION, MAINTENANCE FOUND THE LEFT FORWARD INBOARD AND OUTBOARD, LEFT AFT INBOARD. THE LEFT AND RIGHT MIDDLE INBOARD AND OUTBOARD AND THE LEFT AND RIGHT AFT FLIGHT ATTENDANT SEAT TRACKS CORRODED. REMOVED AND REPLACED ALL SEAT TRACKS. SDR 98ZZZM518Seat Track · corrodedSAW - DURING CPCP-4 INSPECTION, MAINTENANCE FOUND THE LEFT FORWARD INBOARD AND OUTBOARD, LEFT AFT INBOARD. THE LEFT AND RIGHT MIDDLE INBOARD AND OUTBOARD AND THE LEFT AND RIGHT AFT FLIGHT ATTENDANT SEAT TRACKS CORRODED. REMOVED AND REPLACED ALL SEAT TRACKS. SDR 98ZZZM517Seat Track · corrodedSAW - DURING CPCP-4 INSPECTION, MAINTENANCE FOUND THE LEFT FORWARD INBOARD AND OUTBOARD, LEFT AFT INBOARD. THE LEFT AND RIGHT MIDDLE INBOARD AND OUTBOARD AND THE LEFT AND RIGHT AFT FLIGHT ATTENDANT SEAT TRACKS CORRODED. REMOVED AND REPLACED ALL SEAT TRACKS. SDR 98ZZZM516Seat Track · corrodedSAW - DURING CPCP-4 INSPECTION, MAINTENANCE FOUND THE LEFT FORWARD INBOARD AND OUTBOARD, LEFT AFT INBOARD. THE LEFT AND RIGHT MIDDLE INBOARD AND OUTBOARD AND THE LEFT AND RIGHT AFT FLIGHT ATTENDANT SEAT TRACKS CORRODED. REMOVED AND REPLACED ALL SEAT TRACKS. SDR 98ZZZM515Seat Track · corrodedSAW - DURING CPCP-4 INSPECTION, MAINTENANCE FOUND THE LEFT FORWARD INBOARD AND OUTBOARD, LEFT AFT INBOARD. THE LEFT AND RIGHT MIDDLE INBOARD AND OUTBOARD AND THE LEFT AND RIGHT AFT FLIGHT ATTENDANT SEAT TRACKS CORRODED. REMOVED AND REPLACED ALL SEAT TRACKS.
Back to Aerospatiale ATR 72-212