Service difficulty reports
1,771,708 reports of malfunctions and defects, newest first. Air carriers must report; 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' 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' 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 AALA202509020533Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: LAV D EMERGENCY LIGHT WONT TURN ON. MAINTENANCE RELAMPED PER CMM 25-43-54.SDR AALA202509027153Elec Connector · mispinnedAIRCRAFT IN BASE MAINTENANCE: INOP EMERGENCY LIGHT SEAT AT ROW 24 AND 25 RH SIDE. FOUND IMPROPERLY CONNECTED PIN C OF ELECTRICAL CONNECTOR 7260VC9-A. MAINTENANCE INSTALLED PROPERLY PIN C AT ELECTRICAL CONNECTOR 7260VC9-A IAW ESPM 20-48-21 AND TEST IS OK IAW AMSDR DALA2025090206517Wire · damagedEMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE, LOCATION:36H. REPLACED LIGHT HOUSING AND REPAIRED WIRES IAW AMM 33-51. OK FOR SERVICE. (1173066)SDR DALA2025090206511Wire · brokenROW 32FG EMERGENCY EXIT LIGHT INOPERATIVE. FOUND WIRE FROM MAIN HARNESS TO SEAT BORKEN. REPAIRED WIRING AT SEAT 32FG PER SWPM 20-30 OPS CHECK GOOD. (7867750)SDR WX0A2025090232554Battery Pack · no test(AIRCRAFT NOT GROUNDED) FAILED EPSU BAT CAP CHECK / REPLACED EPSU BATTERY AT FIN 13WL IAW AMM'S 33-51-38-000-002-A AND 33-51-38-400-002-A. REPLACED EPSU UNIT AT FIN 10WL IAW AMM'S 33-51-38-000-001-A AND 33-51-38-400-001-A"SDR DALA2025090206502Seat Track · corrodedAFT CABIN, LT OTBD SEAT TRACK, AFT MOST TRACK, HAS EVIDENCE OF CORROSION. REMOVED CORROSION ON AFT CABIN SEAT TRACK, FOUND OUT OF LIMITS IAW ASRP J51-21-06, J53-61-49. REMOVED AND REPLACED LT OTBD SEAT TRACK IAW ASRP J51-42-20. (LP# 1172888)SDR DALA2025090206501Seat Track · corrodedAFT CABIN, RT INBD SEAT TRACK, AFT MOST TRACK, HAS EVIDENCE OF CORROSION. REMOVED CORROSION ON SEAT TRACK, FOUND OUT OF LIMITS IAW ASRP J51-21-06, J53-51-49. REMOVED AND REPLACED RT INBD SEAT TRACK IAW ASRP J51-42-20. (LP# 1172881)SDR AALA202509029544Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: THE DOOR TO THE FORWARD NUMBER LAVATORY 1 HARD TO OPEN. LUBRICATED FORWARD LAVATORY DOOR. PER AMM 52-50-00.SDR AALA202509021661Pressure Switch · inoperativeAIRCRAFT WAS GROUNDED: NUMBER 2 AFT FUEL PUMP IS TURNED OFF, LOW PRESSURE LIGHT DOES NOT ILLUMINATE. REMOVED AND REPLACED NUMBER 2 AFT FUEL PUMP PRESSURE SWITCH. PER AMM 28-42-11. OPERATIONAL CHECK GOOD.SDR AALA202509021042Light · detachedAIRCRAFT WAS NOT GROUNDED: 14C EMERGENCY LIGHT DETACHED FROM SIDE OF SEAT. REATTACHED EMERGENCY LIGHT IN ROW 14C. PER AMM 33-51-11. OPERATIONAL CHECK GOOD.SDR AALA202509021738Light · inoperativeAIRCRAFT WAS NOT GROUNDED: RIGHT HAND AFT FUSELAGE EMERGENCY LIGHT IS INOPERATIVE. REMOVED AND REPLACED RIGHT HAND AFT FUSELAGE EMERGENCY LIGHT. PER AMM 33-51-04. OPERATIONAL CHECK GOOD.SDR AALA202509023620Light · inoperativeAIRCRAFT WAS NOT GROUNDED: SEATS 22C, 23C, 24C, 25C EMERGENCY SEAT LIGHT INOPERATIVE. TROUBLESHOOT AND FOUND CONNECTOR OFF AT ROW 21ABC. RECONNECTED AS REQUIRED AND ACCOMPLISHED AN EMERGENCY LIGHT TEST. PER M/M 33-51-00-710-801, ALL TESTS AND CHECKS NORMAL.SDR IPXA2025090243563Warning Message · activated**ATB** AT FL320 WE RECEIVED THE CABIN ALT WARING. THE CABIN ALT WAS 10,800. WE RAN THE CHECKLIST AND DESCENDED TO 14000. PERFORMED EXCESSIVE CABIN PRESSURE LEAKAGE TEST, LEAKAGE RATE FOUND TO BE WITHIN LIMITS, REF AMM 05-51-08-702-001. AIRCRAFT OK FOR CONT. SSDR YENA2025009000902Unknown · odorFLT#219, BOS-SAN. "DESECURING LIOC ELECTRICAL DIRTY SOCK AND NAIL POLISH SMELL ODOR THOUGHOUT CABIN CREWMEMBERS AND PAX ADVERSLY AFFECTED WITH DIZZYNESS HEADACHE AND LOGNITIVE INPAREMENT FLIGHT DECK ALSO SMELLED AN ODOR ON TAXI OUT IN BOSTON THAT WAS USUAL BUTSDR YENA2025009000901Line · leakingFLT#1952, MCO-BOS. "FUMES EVENT ON ARRIVAL AT 10,000 FT MUSTY DIRTY SCCK SMELL IN FLIGHT DECK AND FWD CABIN SMELL WENT AWAY WHEN #1 PACK TURNED OFF VIA PROCEDURE; INSPECTED A/C FOR OIL LEAK SIGNS. FOUND APU COOLING FAN TRANSFER TUBE LEAKING. R/R APU TRANSFER TSDR AALA202509020618Brake Sys · weakAIRCRAFT WAS GROUNDED: BRAKES ARE SPONGY AND WILL SUDDENLY GRAB WITH APPROXIMATELY DOUBLE THE EXPECTED BRAKING FORCE. (OPEN)SDR YENA2025009000900Transceiver · failedFLT#1817, JFK-JFK. (ETOPS) (AIRCRAFT PERFORMED AN AIRTURN BACK TO JFK) "WX RADAR INOP AFTER TO WHITE WXR OFF; PER TSM 34-41-00-810-802 REMOVED AND REPLACED 1SQ1 WX RADAR TRANCEIVER IAW AMM 34-41-33. PERFORMED OPS CHKS OF WX RADAR SYS IAW AMM 34-41-00. NO FAULTSDR YENA2025009000890Transceiver · failedFLT#1817, JFK-JFK. (ETOPS) (AIRCRAFT PERFORMED AN AIRTURN BACK TO JFK) "WX RADAR INOP AFTER TO WHITE WXR OFF; PER TSM 34-41-00-810-802 REMOVED AND REPLACED 1SQ1 WX RADAR TRANCEIVER IAW AMM 34-41-33. PERFORMED OPS CHKS OF WX RADAR SYS IAW AMM 34-41-00. NO FAULTSDR UIEA2025083001150Solenoid · faultedENG 4 FUEL VALVE EICAS, ENG 4 FUEL VALVE STATUS, #4 ENG WOULD NOT SHUT DOWN UPON FUEL CONTROL SWITCHING OFF POSN. L13 CB FOUND IN OUT POSITION.(<P>R/R SOLENOID FUEL SOV PER AMM 73-21-20 & IPC 73-21-14-01 ITEM 67. PFM #4 ENG IDLE RUN CHK, NO LEAK FND.</P>)SDR DALA2025090206480Indicator · inoperative1R DOOR KNUCKLE KNOCKER INOP. CLEARED DEBRIS FROM DOOR 1R KNUCKLE KNOCKER, OPS. CHECK GOOD. (1172626)SDR SIMA20250830001Battery · inoperativeINTERIOR COCKPIT EMERGENCY LIGHTS INOP REMOVED AND REPLACED EMERGENCY LIGHT POWER UNIT IAW EMB 175 AMM 33-50-01. OPS CHK PASS. MEL RESTORED.SDR SIMA2025090283002Gcu · failedIDG 1 OFF BUS CAME ON EICAS AND APU FAULT AFTER DEPARTURE AROUND 3000 FT. A/I BACK TO DFW / EMERGENCY DECLARED / NOT AN OVER WT LANDING / MTX INSP. RAR MAIN GCU 1 IAW: AMM 24-21-19 OPC GOODSDR CALA2025090208386Service Door · missingLAV SERVICE PANEL MISSING UP[ON ARRIVAL REQUEST CDL 52D ADD PICS INSPECTED AREA NO DAMAGE NOTED AT THIS TIME. TECH CONFIRMED SIZE OF PANEL IS LESS THAN 150 SQINCHES.SDR CALA2025090208374Control Unit · faultedINSTALLED NEW WCU AT POSITION 13.1 PER AMM UP TO STEP 1.D. REQUIRES SOFTWARE UPDATE AND INSTALLATION TEST DUE TO REPLACEMENT. PERFORMED SOFTWARE UPDATE AND INSTALLATION TESTS OF WELS SYSTEM DUE TO WCU 13.1 INSTALLATION REF AMM 33-51-07-01A-720A STEPS 1.D TO ENSDR CALA2025090208373Control Unit · faultedDURING CLB AFT GALLY LST POWER. ALL OVENS OFFLINE . ALL BUT ONE CHLLR INOP . NO PWR. ALL BUT 1. AFT GALLEY POWER WORKS NORMAL ON THE GROUND .ALL OVENS AND CHILLERS CHECKED OK. ALL CIRCUIT BRKRS IN.PWR LAMP INDCTNG 7+ 8 R DARK. FA REPORTED AFT GALLEY 7&8 LOSDR CALA2025090208372Support Angle · corrodedREMOVED AND REPLACED SUPPORT ANGLE ATTACHED TO INNER CHORD IAW SRM 51-40-02-0G-0 AND DWG 141A8312. REMOVED AND REPLACED SUPPORT ANGLE ATTACHED TO INNER CHORD IAW SRM 51-40-02-0G-0 AND DWG 141A8312.SDR CALA2025090208371Floorbeam · crackedPASSENGER CABIN FLOORBEAM AT STA 540 BETWEEN BL0 TO LBL 24 LOOSE. REMOVED AND REPLACED FLOORBEAM IAW SRM 51-40-02-0G-0 ,AND AMM 51-21-72-370-804.SDR CALA2025090208370Lens · broken11F SEAT EMERGENCY FLOOR PROXIMITY LIGHT LENS BROKEN. REMOVED AND REPLACED 11F FLOOR PROXIMITY LIGHT REF AMM 33-51-06. OPS CHECK GOOD.PARTS USED: 78-3300-3-0098,QTY :1SDR CALA2025090208369Mount · corrodedG1 GALLEY MOUNT FITTINGS BETWEEN BS 324 AND BS 335 HAVE CORROSION. REMOVED AND REPLACED 2EA FITTING AT MAIN STA 324 RS 335 IAW SRM 51-40-02-OG.SDR CALA2025090208368Floor Support · corrodedR1 DOOR CUTOUT LOWER SILL CORRODED FWD TO AFT CORNER. REMOVED AND REPLACED FLOOR SUPPORTS 141N5160U78 AND 141N5160U79 AT R1 DOOR STA 324 TO STA 365 IAW SRM 51-40-02-OG-0.SDR CALA2025090208367Mount · corrodedMAIN CABIN FLOOR WEB , FWD OF AFT PRESSURE BULKHEAD ALL GALLEY MOUNTS CORRODED. REMOVED AND REPLACED ALL GALLEY MOUNTS FITTING 5EA IAW SRM 51-40-02-OG.SDR CALA2025090208366Blocker Door · brokenNUMBER 2 ENG LT T/R BLOCKER DOOR AT THE 7 OCLOCK POWITION FOUND DAMAGED. DOOR REQUIRES REPLACMENT IAW AMM 78-31-14/401. NR 2 ENG T/R BLOCKER DOOR AT 7 O"CLOCK REMOVED AND REPLACED IAW AMM 78-31-14/401. OP CHECK AND CLEARANCE CHECK, FOUND NO FURTHER DEFECT.SDR CALA2025090208365Acm · seizedDURING LANDING ROLL A STRONG ACRID SMOKE SMELL WAS NOTICED. BRAK ES SUSPCTD ADDED PHOTOS OF SMOKE REPORT FORM. INSPECTED BRAKES, NO DEFECTS NOTED. CREW REPORTED SMELL DISSIPATED DURING TAXI IN. SUSPECT CONSTRUCTION FUMES. ACCOMPLISHED GROUND CHECKS AS REQUIRSDR CALA2025090208364Panel · missingPDA 2 ON ARRIVAL RT ENGINE PANEL 446AR MEASURING 28 SQUARE INCHES.SDR CALA2025090208363Lamp · no testEMERGENCY LIGHTS - OPERATIONAL TEST WITH THE TEST SWITCHES PROCEDURE - EMERGENCY AREA LIGHT ABOVE ROW 1AB INOP RELAMPED PER AMM 33-51-03-960-801 CK OK.SDR CALA2025090208362Lamp · no testEMERGENCY LIGHTS - OPERATIONAL TEST WITH THE TEST SWITCHES PROCEDURE - EMERGENCY AREA LIGHT AT DOOR 2 GALLEY, LEFT, INOP LOCATOR PHOTO RELAMPED PER AMM 33-51-03-960-801 CK OK.SDR CALA2025090208361Lamp · no testEMERGENCY LIGHTS - OPERATIONAL TEST WITH THE TEST SWITCHES PROCEDURE - EMERGENCY AREA LIGHT IN DOOR 3 CROSSOVER CEILING INOP RELAMPED PER AMM 33-51-03-960-801 CK OK.SDR CALA2025090208360Battery Pack · no testPOWER SUPPLY - BATTERY PACK CAPACITY CHECK PROCEDURE - AFTER C/W BATTERY PACK DEEP-CYCLE PROCEDURE, FOUND BATTERY M33094 WILL NOT HOLD A CHARGE FOR THE FULL 15 MINUTES. REPLACED BATTERY PACK PER AMM 33-51-06-960-802 TEST OK.SDR CALA2025090208343Unknown · odorREF LP 6095938 FAS REPORT FOUL ODOR STILL COMING FROM AFT GALLEY . CLEANERS PERFORMED THOROUGHLY CLEANING FOR THE WHOLE AFT GALLEY AREA. INSPECTED LAVS D AND E FOR ANY UNUSUAL SMELLS, NO BAD SMILLS NOTECED AT THIS TIME.SDR CALA2025090208342Fuel Sys · leakingCREW REPORTS FUEL SMELL IN CABIN. FUEL FOUND LEAKING FROM APU COPMARTMENT. APU FUEL CONTROLLER LEAKING AT SURGE CONTROL VALVE SUPPLY AND RETURN LINES. REMOVED SUPPLY LINES TO IGV ACTUATOR, FUEL FLOW DIVIDER, AND SCV REF AMM TASK 49-31-01-004-001-001. FOUND PACSDR CALA2025090208341Potable Water · odorSTRONG CLEANER SMELL AND TASTE IN POTABLE WATER WATER SVC VENDOR NOTIFIED TO SERVICE WATER.SDR SCNA20250902347Holder · damagedFWD LAV TOILET PAPER HOLDER, SHARP WIRE FOUND WHEN CHANGING ROLL.REMOVED AND REPLACED THE L1 LAV TOILET PAPER HOLDER REF. CMM 25-47-10.SDR SCNA20250902345Girt Bar · out of adjustL1 DOOR GIRT BAR LOOSE IN DISARM POSITION ADJUSTED L1 DOOR GIRT BAR BRACKETS REF. AMM 25-66-02.SDR DALA2025090106461Target · out of adjustLEFT EMERGENCY DOOR MSG AT FL360 ECAM CORRECTED ECAM DOOR PAGE INDICATIONS-OVERWING EMERGENCY EXITS-OPEN INDIC. ADJUSTED HANDLE COVER PROX TARGET IAW A319 TSM 52-21. (7270940).SDR DALA2025090106458Access Panel · crackedCRACK ACCESS PANEL 423DL ON RH PYLON. COMPLIED WITH ER/A 540187-14MA. (1172830).SDR DALA2025090106453Strut · corrodedCORROSION INTERCONNECTING STRUT OB FLAP ON LT WING. R & R INTERCONNECTING STRUT OB FLAP ON LT WING ON UN UNSERVICEABLE CONDITION IAW AMM 27-51-44-000-001-A. (1172913).SDR DALA2025090106452Elec Connector · wornWORN ELECTRICAL CONNECTOR 7540VC ON I/B FLAP RT. REPLACED ELECTRICAL CONNECTOR 7540VC ON I/B FLAP RT IAW AIRBUS ESPM 20-44-11. (1172999).SDR DALA2025090106443Skin · corrodedCORROSION EXTERNAL SKIN AROUND VENT OUTLET-TUBE LOCATED FROM FR69 TO FR70 BETWEEN STR31RH AND STR32RH AT LOWER FUSELAGE. PERFORMED PERMANENT REPAIR LOC ON EXTERNAL SKIN FR69 TO FR70 AT LEVEL STR 31RH TO STR 32 RH AS PER A319 SRM 53-41-11-300-004. (1172815).SDR DALA2025090106442Cover · missingMISSING COVER SLIDE LINING DOOR 832 PLACARD AT AFT GALLEY AREA. INSTALLED COVER SLIDE LINING DOOR 832 PLACARD (DO NOT SIT HERE ESCAPE SLIDE) AT AFT GALLEY AREA (1 EA) AS PER A320FAM AMM-11-00-00-400-021-A. (1172300).SDR DALA2025090106441Skin · damagedFWD FUSELAGE SKIN DAMAGED LT SIDE BETWEEN FR 13 & F 14, 17.5' ABOVE SKIN BUTT JOINT. COMPLIED WITH ER/A 628891-14. (1172092).