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 WX0A2025082532548Flashlight · damagedFLIGHT ATTENDENT SEAT 4 FLASHLIGHT BROKEN. REPLACED BATTERY PACK IAW CMM 25-60-02. OPS CHECK GOOD.SDR KY7A202508250038Control Unit · not reportedREPLACED RH GENERATOR CONTROL UNIT C0303 P# 51509-002B SN 15239ASDR DALA2025082506316Elec Connector · corrodedCORROSION ON ELECTRICAL CONNECTORS 7541VC AND 7543VC OF INTERCONNECTING STRUT ON LH WING. REPLACED ELECTRICAL CONNECTORS 7541VC AND 7543VC OF INTERCONNECTING STRUT ON LH WING AS PER AIRBUS ESPM 20-44-11. (1156567).SDR DALA2025082506315Fairing · corrodedCORROSION BONDING PLATE FLAP TRACK FAIRING 4 (533CB) ON LH WING. COMPLIED WITH ER/A 622998-14TR. (1156742).SDR DALA2025082506314Fairing · corrodedCORROSION BONDING PLATE FLAP TRACK FAIRING 2 (531CB) ON LH WING. COMPLIED WITH ER/A 622998-14TR. (1156727).SDR DALA2025082506313Seat Track · corrodedCORROSION SEAT TRACK +Y1292 AT FR66 AT AFT GALLEY AREA. REPLACED SEAT TRACK Y1292 LOC. BTW FR64 TO FR66 IN AFT GALLEY AREA AS PER A319 SRM 51-42-11 AND A319 SRM 51-72-11. (1156676).SDR DALA2025082506312Floorbeam · damagedFOUND ELONGATE HOLES (2 E/A) LOCATE ON CROSS BEAM FR67 BTW -Y920 TO -Y1495 IN AFT GALLEY AREA. REPLACED CROSS BEAM RH SECTION LOCATE ON FR67 BTW -Y920 TO - Y1495 IN AFT GALLEY AREA RH, AS PER A319 SRM 51-42-11 AND A319 SRM 51-72-11. (1156539).SDR DALA2025082506311Seat Track · corrodedCORROSION 1 E/A ON SEAT TRACK -Y1292 ZONE 240 BTW FR35 TO FR 47. REPLACED SEAT TRACK -Y1292 AND FASTENERS LOCATED BTW FR41 TO FR47/51 AS PER A319 SRM 51-42-11 AND A319 SRM 51-72-11. (1156533).SDR DALA2025082506310Seat Track · corrodedCORROSION SEAT TRACK +Y1292 AT FR66 AT AFT GALLEY AREA. REPLACED SEAT TRACK Y1292 LOCATED BTW FR64 TO FR66 AT AFT GALLEY AREA AS PER A319 SRM 51-42-11 AND A319 SRM 51-72-11. (1156509).SDR GTIA2025082539051Flashlight · no testUNABLE TO TEST FWD F/A EMERGENCY FLASHLIGHT ( FLASHLIGHT AND HOLDERS (FLIGHT DECK OR CABIN). R & R FWD FA FLASHLIGHT PER NKS DRAWINGS EMER EQUIP REV 7. THIS CLOSES MDDR 117788. MOC NOTIFIED, PLACARD REMOVED, LOG UPDATEDSDR DXTA2025082504682Stop Fitting · out of adjustMAIN CABIN DOOR LATCH REQUIRES MORE FORCE THAN NORMAL CLOSING. "CORRECTIVE ACTION" PERFORMED THE MAIN CABIN DOOR HEALTH CHECK/DATA COLLECTION CHECK LIST REFERENCING CESSNA MODEL 680A MAINTENANCE MANUAL CH 52-10-04 NOTING THAT THE INNER HANDLE DID NOT CONTACT TSDR DXTA2025082504691Brake · failedON THE TAXI OUT FOR DEPARTURE THE RIGHT SIDE BRAKE WAS PULSATING AND CHATTERING, SHAKING THE ENTIRE AIRFRAME. LINE SERVICE ALSO OBSERVED THE AIRFRAME SHAKING AS THE BRAKE WAS APPLIED. REMOVED RH BRAKE ASSY P/N: DAP00097-04, S/N: 5028YJ. AND INSTALLED BRAKE ASSDR AALA202508252756Lock · jammedAIRCRAFT WAS NOT GROUNDED: LAVATORY E LOCK JAMMED. AND THE DOOR WAS REMOVED TO FREE PASSENGER. MAINTENANCE REPLACED DOOR LOCK ASSEMBLY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 25-45-21.SDR DALA2025082506284Flap System · lockedFCNT/DE- DECLARED EMERGENCY DUE TO FLAP LOCKOUT AT 15 ON APPROACH TO LAND. PERFORMED FSEU BITE CHECK. NO FAULTS RECORDED. RESET FLAP TRANSMISSION DPI INDICATORS. OPS CHECK GOOD.SDR DALA2025082506287Floor Support · corroded(LOG 1156122) CORROSION ON FLOOR SUPPORT UPPER AND LOWER SIDE STA 951 TO 967 BTW LBL 48 AT PAX CABIN. .FLOOR SUPPORT UPPER AND LOWER SIDE STA 951 TO 967 BTW LBL 48 AT PAX CABIN WAS REPLACED AND INSTALLED PER B737-800 SRM 51-40-02-0G.SDR DALA2025082506286Attach Angle · cracked(LOG 1155116) CRACK OF: 0.156 IN LENGTH ON RH VERTICAL PRESSURE DECK WEB ATTACH ANGLE AT THE DRAIN SLOT. VERTICAL PRESSURE DECK WEB ATTACH ANGLE WAS REPAIRED PER B737-800 SRM 57-10-10-2R PROCEDURE 6 AND A.A./ A.D. 5714-01004-02.SDR AALA202508254571Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK SHEAR PLATE STR 23L LOCATED FR69 TO FR70 AT AFT GALLEY AREA. MAINTENANCE REPLACED SHEAR PLATE LOCATED BTW FR69 TO FR70 STR 23L AT AFT GALLEY AREA IAW A319 SRM 51-42-11-801 AND A319 SRM 51-71-11-911-001 AND DWG D53474180 SHESDR DALA2025082406281Wire Harness · faultedSHIP 5044 -ATO- CREW REPORTED THEY RECEIVED ENG 2 MINOR FAULT MESSAGE AT 60 KNOTS. CONTACTED MCC APPLIED MEL CONTINUED WITH FLIGHT. LATER, REPLACED NBR 2 ENGINE WC08 HARNESS. (LP 7881510)SDR REXA2025082500832Lamp · inoperativeRIGHT SIDE AFT EXTERIOR EMERGENCY LIGHT IS INOP REPLACED LAMP WITH NEW LAMP IAW AMM 33-51-15, OPS CHECK GOOD. P/N OFF/ON 8GH002473-08SDR AALA202508250244Door Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN R1 DOOR SURROUND STRUCTURE STUB FRAME LOCATED AT BS 291.5, S17R. REPAIRED FRAME PER AARD 53-10-00-8.SDR CALA2025082508094Frame · crackedRH FRAME 16 DOUBLE JOGGLE FASTENER HOLE #6 HAS A CRACK INDICATION IN THE FRAME LAYER, AT 1 OCLOCK (VIEWED FROM THE OUTSIDE) 60% S.H. ACCOMPLISHED INTERIM REPAIR AT RH FR 16 DBL JOGGLE HOLE # 6 IAW ECRA 5311-03392 PART 1.1. ACCOMPLISH INITIAL INSP OF RH FR16 DSDR CALA2025082508092Scavenge Pump · faultedENG2/INNER EXHAUST HAS FLUID LEAKING AT THE 6 OCLOCK POSITION. SUSPECT FUEL PUDDLE, DID NOT GLOW FROM UV LIGHT AND DOES NOT HAVE A SMELL. IN CONCURRANCE WITH TOMC ENGINE DESK, SUSPECT #5 ENGINE BEARING OIL SCAVENGE TUBE MAY BE BLOCKED INTERNALLY & CAUSING THESDR CALA2025082508091Filter · odorAT ENG START TILL 10000 FT STRONG FOUL SMELL FROM PACKS ORD MX DEBRIEFED CREW, PER CREW SMELL FOUL ODOR SMELL RETURNED ON LANDING. PER TOMC AND AMM 5-51-26, REMOVED AND REPLACED RECIRCULATION AIR FILTER REF AMM 21-25-01 ADD EMP:U105424 PER TOMC STILL REQUIRES SDR CALA2025082508078Support Angle · crackedEXTERNAL RT FUSELAGE FAIRING OUTER VERTICAL SUPPORT AT FR 34 IS CRACKED. REMOVED AND REPLACED FR 34 VERTICAL ANGLE IAW SRM 51-42-11 P 18-25.SDR X7PA2025082300001Seal · leakingAIRCRAFT MADE A SCHEDULED DEPARTURE. DURING CLIMB OUT, SMOKE WAS NOTICED IN THE COCKPIT & CABIN BY BOTH THE FLIGHT CREW AND PASSENGERS. AIRCRAFT DECLARED AND EMERGENCY AND DIVERTED. AIRCRAFT LANDED WITHOUT INCIDENT. DURING INVESTIGATION AS TO THE CAUSE OF THE SDR EVCA2025082300001Blower Motor · odorINTERMITTENT ELECTRICAL SMELLSDR N6WA2025082306Intercostal · corrodedCORRODED INTERCOSTAL BETWEEN BS 349-364 AT S27L. REMOVED AND REPLACED INTERCOSTAL IAW SRM 51-42-06.SDR N6WA2025082305Frame · corrodedCORROSION ON FWD CARGO FRAME AT BS 469 BETWEEN S26-27L. REPAIRED FWD CARGO FRAME IAW EO-C550-53MR-00 REV CSDR N6WA2025082303Seat Track · corrodedCORROSION ON SIDE SEAT RAIL BETWEEN BS 863 - 909. REMOVED AND REPLACED SEAT RAIL IAW AMM 53-00-49.SDR N6WA2025082302Seat Track · corrodedCORROSION ON SIDE SEAT RAIL BETWEEN FS708-FS761. REMOVED AND REPLACED SEAT RAIL BETWEEN FS708-FS761 IAW CRJ AMM 53-00-49SDR N6WA2025082301Structure · crackedEXTERNAL POWER PROVISIONS BOX CRACKED. REMOVED AND REPLACED EXTERNAL POWER PROVISIONS BOX IAW CRJ SRM 51-42-06.SDR AALA202508220812Sill Drain · cloggedAIRCRAFT WAS GROUNDED: FLIGHT ATTENDANT REPORTS DURING DESCENT A STRONG ODOR ON THE LEFT AFT GALLEY AREA. FOUND AFT GALLEY THRESHHOLD DRAINS CLOGGED. CLEARED AFT GALLEY L2 (AALA202508228549) AND R2 (AALA202508220812) DOOR THRESHHOLD DRAINS.SDR AALA202508221159Pump · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AT 37K FEET OVER CUBA, NUMBER 1 ENGINE ROLLED BACK TO 40-50% N1. AUTO THROTTLES DISENGAGED. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT MIA. REMOVED AND REPLACED (HMU)-HYDROMECHANICAL UNIT LEFTSDR AALA202508220467Girt Bar · wornAIRCRAFT IN BASE MAINTENANCE: L2 ESCAPE SLIDE GIRT WORN. REPAIRED GIRT, PER AARD 25-66-00-2 PROCEDURE.SDR AALA202508225290Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANTS REPORTS LAVATORY-E DOOR DIFFICULT TO BOTH OPEN AND CLOSE. ADJUSTED LAVATORY-E DOOR LATCH. PER AMM 52-00-00.SDR AALA202508222533Hmu · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AT 37K FEET OVER CUBA, NUMBER 1 ENGINE ROLLED BACK TO 40-50% N1. AUTO THROTTLES DISENGAGED. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT MIA. REMOVED AND REPLACED (HMU)-HYDROMECHANICAL UNIT LEFTSDR AALA202508223650Door Latch · looseAIRCRAFT WAS NOT GROUNDED: FORWARD BATHROOM DOOR HANDLE VERY LOOSE AND CAN NOT OPEN. REMOVE AND REPLACED LAVATORY DOOR LATCH. PER CMM 25-40-61. OPERATIONAL CHECK GOOD.SDR AALA202508226930Door · bindingAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR BINDS ON THE BOTTOM AND MAKES THE DOOR DIFFICULT TO OPEN AND CLOSE. ADJUSTED LAVATORY DOOR. PER AMM 25-40-11.SDR AALA202508226670Spring · looseAIRCRAFT WAS GROUNDED: FORWARD ENTRY DOOR GIRT BAR HAS LOOSE WHITE CAP. REMOVE AND REPLACED WHITE CAP RELEASE STOP ASSEMBLY SPRING CLIP ON L1 DOOR. PER AMM 25-66-01.SDR AALA202508228549Sill Drain · cloggedAIRCRAFT WAS GROUNDED: FLIGHT ATTENDANT REPORTS DURING DESCENT A STRONG ODOR ON THE LEFT AFT GALLEY AREA. FOUND AFT GALLEY THRESHHOLD DRAINS CLOGGED. CLEARED AFT GALLEY L2 (AALA202508228549) AND R2 (AALA202508220812) DOOR THRESHHOLD DRAINS.SDR AALA202508228689Light · detachedAIRCRAFT WAS NOT GROUNDED: 22C SEAT EMERGENCY LIGHT HANGING BY THE WIRES. SECURED EMERGENCY LIGHT ON SEAT 22C. OPERATIONAL CHECK GOOD. PER 33-51-00.SDR HALA20250822258Actuator · faultedETOPS - LINE SERVICE REPORTED RIGHT OUTER TANK NOT TAKING FUEL. REMOVED AND REPLACED RIGHT OUTER TANK FUEL INLET VALVE ACTUATOR (500QU2) PER AMM 28-25-57-400-801-A.SDR QXEA2025082200297Door Latch · dirtyFLIGHT 2274. FLIGHT DECK DOOR IS DIFFICULT TO OPEN.REMOVED FROM SERVICE. CLEANED FLIGHT DECK DOOR LATCH. NO FURTHER DEFECTS NOTED. RETURNED TO SERVICE. NO PARTS REPLACED.SDR SWAA2025082206787Cradle · inoperativeAFT GALLEY LH;I/B EMERGENCY FLASH LIGHT WILL NOT TEST. REMOVED AND REPLACED AFT GALLEY LT INBD EMERGENCY FLASHLIGHT BRACKET ASSY IAW AMM 25-64-00.SDR SWAA2025082206931Flashlight Assy · inoperativeFLIGHT. DECK FLASHLIGHT TEST RED LIGHT. REMOVED AND REPLACED FLASHLIGHT ASSY IAW MM 25-64-00.SDR SWAA2025082206733Handle · looseFWD ENTRY DOOR CLOSE ASSIST HANDLE IS LOOSE<[01] SECURED FWD ENTRY DOOR CLOSE ASSIST HANDLE; REF. AMM 52-11-31.SDR SWAA2025082206810Battery Pack · inoperativeINTERIOR LH OVERWING EXIT HAS 3 LIGHTS INOP.<[01] R/R?D INTERIOR LH OVERWING EXIT BATTERY PACK PER AMM 33-51-06. OPS CK GOOD.SDR SWAA2025082206571Handle · missingAFT CARGO DOOR HANDLE STUD CAP IS MISSING.<[01] REPLACED AFT CARGO DOOR HANDLE STUD PER AMM 52-31-14;[02] INSP AFT CARGO DOOR HANDLE STUD PER AMM 52-31-14SDR SWAA2025082206540Seal · crackedTAIL RH HORIZONTAL UPPER FRONT SPAR SLIDING SEAL IS CRACKED.<[01] REMOVED AND REPLACED TAIL RH HORIZONTAL UPPER FRONT SPAR SLIDING SEAL IN ACCORDANCE WITH AMM 53-31-31. OPS CHECK GOOD.SDR SWAA2025082207252Sign · looseFWD GALLEY NEAR R2 DOOR LOWER EXIT SIGN LENS CAME OFF UNABLE TO RE-SECURE. REMOVED AND REPLACED GALLEY (FWD) EXIT SIGN INDICATOR ASSEMBLY REF AMM 33-51-01. SECURED LENS AS NEEDED; OPS CHECKS NORMAL.