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 YENA2025123001280Pressure Panel · crackedDURING HEAVY MAINTENANCE: FUSELAGE / CENTER FUSELAGE / FR 36 LH & RH SIDES / PRESSURE PANEL / CRACK DAMAGES AT MULTIPLE HOLES – TIME LIMITED REPAIR; REFERENCES: /1/ AEROMAN EA 53-0071-25 REV. 0 (COVER + PARTS 1-11) /2/ AIRBUS RDAF 81680593/005/2025#A /3/ AIRBUSDR YENA2025123001279Structure · crackedDURING HEAVY MAINTENANCE: WINGS / CENTER BOX / FRONT SPAR VERTICAL STRINGERS & HORIZONTAL FLOOR BEAMS / @ LEVEL OF FR36 & Y-254 & Y+765 / CRACKS - PERMANENT REPAIR; REFERENCES: /1/ AEROMAN EA 57-0108-25 REV. 0 (COVER + PARTS 1-3) /2/ AIRBUS RDAF 81679714/004/2SDR YENA2025123001278Skin · corrodedDURING HEAVY MAINTENANCE: FUSELAGE / REAR FUSELAGE / FR 65-66 & STR 31R / INNER SKIN / CORROSION DAMAGE - TIME LIMITED REPAIR; REFERENCES: /1/ AEROMAN EA 53-0077-25 REV. 1 (COVER + PARTS 1-3) /2/ AIRBUS RDAF 81680476/005/2025 ISSUE B /3/ AIRBUS TD/81680476/037SDR CALA2025123012546Unknown · vibrationACFT DIVERTED TO EWR FOR VIBRATION IN MID GALLEY 3. CREW STATED VIBRATION FELT BETWEEN DOORS 2L & R. VIBRATION BEGAN AT CRUISE & CREW REPORTED IT INCREASED & DECREASED WITH AIRSPEED. VIBRATION STOPPED AFTER LANDING WHEN THRUST LEVERS RETURNED TO IDLE. HAS HSDR CALA2025123012524Bezel · damagedNUMBER 4 LIFE RAFT CAME DOWN ON TAKEOFF. NR 3 & 4 LIFE RAFT SEAL BROKEN. R & R THE NR 4 LIFE RAFT COMPARTMENT BEZEL & LATCH IAW AIPC 25-24-40-11, ITEM 402. NO FIX. R & R LIFE RAFT 4 STOWAGE COMPARTMENT BEZEL & LATCH ASSY IAW AMM 25-24-40-400-0802, R & R CESDR CALA2025123012517Lamp · inoperativeEMERGENCY LIGHT OVER EMERGENCY EXIT ON THE RT SIDE IS OUT. RELAMPED ROW 21F EMERGENCY EXIT SIGN, OPS CHECK SATISFACTORY IAW AMM 33-51-01.SDR WX0A2025122932685Epsu · failed(AIRCRAFT NOT GROUNDED) EMERGENCY LIGHTING IN FWD GALLEY FAILS TO TURN ON W/ LOSS OF POWER / T/S PER TSM 33-51-00-810-829-A AND R&R'D EPSU 10WL BATTERY PER AMM 33-51-38-000/400-002-A. OPS CHECK GOOD."SDR AALA202512295554Rivet · brokenAIRCRAFT IN BASE MAINTENANCE: CAPTAIN L2 WINDOW LATCH HOLDER HAS BROKEN RIVET CAUSING IT TO BIND AND NOT ALLOWING EMERGENCY OPERATION OF WINDOW. MAINTENANCE INSTALLED NEW RIVET ON L2 WINDOW CHART HOLDER IAW B777-200 SRM 51-40-02-06. AEROMAN FAA CRS RJEY598H.SDR AALA202512296592Lamp · no testAIRCRAFT WAS NOT GROUNDED: L1 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. MAINTENANCE REPLACED SLIDE/OVERWING LIGHT-LAMP IAW AMM 33-51-04.SDR AALA202512298908Unknown · odorAIRCRAFT WAS GROUNDED: WHEN AIRCRAFT WENT TO IDLE ON DESCENT, FO AND MYSELF NOTICED HEAVY "DIRTY SOCK" SMELL. IT WAS ONLY IN COCKPIT. (OPEN)SDR AALA202512292282Battery · no testAIRCRAFT WAS NOT GROUNDED: DURING PS CHECK FOUND THAT EPSU LEFT MID CABIN BATTERY FAILED. MAINTENANCE REPLACED THE BATTERY OF THE EMERGENCY POWER SUPPLY UNIT LEFT MID CABIN IAW AMM 33-51-38.SDR ASAA2025122762563Door · obstructedR2 DOOR UNABLE TO ARM. GROUNDED - YES. FOUND PLACED UNDER DOOR. PERFORMED OPS CHECK OPS CHECK ACFT OK FOR SVC.SDR ASAA2025122762562Handle · no discrepancyL4 DOOR ARMING HANDLE HARD TO ENGAGE AND DISENGAGE. GROUNDED - YES. PERFORMED OPS TEST OF ARM/DISARM OF L4 DOOR. OPS CHECK GOOD. OK FOR SERVICE.SDR ASAA2025122762561Handle · no discrepancyL4 DOOR ARMING HANDLE HARD TO ENGAGE AND DISENGAGE. GROUNDED - YES. PERFORMED OPS TEST OF ARM/DISARM OF R4 DOOR. OPS CHECK GOOD. OK FOR SERVICE.SDR QXEA2025122900379Engine · smokeFLIGHT 2095. RAMP CREW REPORTED SMOKE OUT OF APU AS WELL AS OIL ON BOTTOM OF TAIL CONE. REMOVED FROM SERVICE. PLACED ON MEL. MEL CLEARED BY. PERFORMED GVI OF TAIL CONE AREA, NDN. PERFORMED APU OPS CHECK IAW AMM 49-10-00-700-801-A, OPS TEST GOOD. PLACARDS REMOSDR SWAA2025122955937Slide · looseL1 SLIDE UNSECURED FROM DOOR/HOUSING. RESECURED L1 SLIDE ASY IAW AMM 25-66-01. OK TO CONTINUE SERVICE.SDR SWI2025F01926Control Lever · warning messageSLAT FAIL ON APPROACH TO JAC QRH CLEARED MESSAGES. (FLIGHT 3317) THIS DISCREPANCY WAS TRANSFERRED TO CAMP ITEM 31437718 WITH THE FOLLOWING CORRECTIVE ACTION: "INTERROGATED THE CMC AND FOUND FAULT CODES 27811021ACE SLAT SURFACE JAMMED/ UNDERSPEED, FAULT CODE 2SDR SWIA202512290001Slat System · warning messageSLAT FAIL CAUTION ON DEPARTURE. COMPLIED WITH QRH (FLIGHT 3037) NO 10 DAY HISTORY. UPON ARRIVAL TO AIRCRAFT, SLAT FAIL CAUTION MESSAGE WAS NOT PRESENT. INTERROGATED CMC AND FOUND FAULT CODE 27811021ACE. TROUBLESHOT PER ERJ-175 FIM 27-81-00-810-802-A. FOUND TSDR DALA2025122909474Wire · cutFWD GALLEY WHITE AND RED FLOOR PROXIMITY LIGHT INOPERATIVE. FOUND CUT WIRES W4142-0157-20 AND W4142-0110-20, SPLICED IAW SWPM 20-30, OPS CHECKED GOOD IAW AMM 33-51.SDR GTIA2025122939228Flashlight · no testFA FLASHLIGHT INOP (FWD ) NOT BLINKING WHEN TEST BUTTON PRESSED ( FLASHLIGHT AND HOLDERS (FLIGHT DECK OR CABIN) ). R & R FWD LT FA FLASHLIGHT ASSY IAW CMM 25-60-13 THIS CLEARS DMI 6008670-1 PLACARD REMOVED MOC NOTIFIEDSDR DALA2025122909467Light · inoperativeFWD EMERGENCY LIGHT INOPERATIVE. REPLACED LIGHT ASSY PER A330 AMM 33-51. OK FOR SERVICE. (7380450)SDR YENA2025122901277Pressure Switch · failedFLT#363, BOS-UVF. (ETOPS), ENG 1 HYD PUMP PRESSURE INDICATES ON WITH ZERO PRESSURE AT AGTE ( ECAM HYD PAGE INDICATIONS 7) PUMPS ); REF TSM 29-11-00-810-806-A, FOUND NO FAULTS WITH WIRING. REMOVED AND REPLACED ENG PUMP PRESSURE SW (1074GK) ENG # 1 IAW AMM 29-1SDR DALA2025122909448Oxygen Mask · unwanted deploySEAT 10E O2 MASK DEPLOYED NOTED WHILE DEPLANING. CORRECTIVE ACTION: ESTOWED MASK PER A319 AMM 35-21, OK FOR SERVICE. (7936350)SDR DALA2025122909447Crossbeam · crackedFUSELAGE FRAMES CROSSBEAM JUNCTION AREA AT FR20 LH HOLES H18 & H26 CRACK. REPAIRED PER ERA 630734-14AD. (1371189)SDR DALA2025122909445Post · corrodedCORROSION ON AFT RH LATERAL POST LAV A. REPAIRED PER ER/A 630720-14. (1372197)SDR DALA2025122909442Floor Panel · corrodedCORROSION FUSELAGE PANEL INSTL-PASS COMPT FLOOR PANELS SEALING ANGLE. REPAIRED PER ER/A 631147-14. (1372047)SDR UIEA2025122701359Elt · looseELT NEAR RH CB PANEL TAPE IS LOOSE & 1 LATCH WILL NOT CLOSE. INSTALLED TAMPER TAPE ON FWD ELT IAW AMM 25-61-05-200-801. NO DEFECTS NOTED.SDR FDEA202512272292Skin · corrodedNO 1 ENGINE NACELLE BETWEEN ACCESS PANEL 433 HR AND 433 JR INTERNAL SKIN WITH CORROSION. JOBS FOR NR W/O 91519, N00437 AND N00438 WAS INCLUDED AND ACCOMPLISHED UNDER FEDEX EA F-5430-T0385806 P1SDR DALA2025122909439Unknown · leakingATB- DUE TO BROWN FLUID LEAKING IN THE AFT GALLEY AREA. INSPECTED DRAINS IN GALLEY AND LAVATORIES WITH ALL DRAINS FOUND NORMAL WITH NO BLOCKAGE. DRAIN MAST OPERATES NORMAL AND NO WATER FOUND COMING FROM BELLY DRAINS. (7364882)SDR DALA2025122909438Sensor · faultedDIV- TO AMS DUE TO (DOOR R AFT CABIN) ECAM MESSAGE. CONFIRMED FAULT WITH DOOR INDICATING OPEN. REPLACED DOOR SENSORS 22MJ AND 24MJ. OK FOR SERVICE (8028253)SDR CALA2025122912496Power Supply · inoperativeRIGHT FORWARD OVERWIND EXIT SIGN INOPERATIVE. R & R M1695 POWER SUPPLY ASSEMBLY. RIGHT OVERWING EXIT LIGHTS OPS CHECKS NORMAL. IW WDM 33-51-13-7,.AMM 33-51-06-960-806.SDR CALA2025122912494Control Lever · faultedAFTER LIFTOFF, MLG LEVER DOWNLOCK DOES NOT RELEASE FOR A FEW SECONDS.RELEASE ON 2ND/3RD. PERFORMED LGCIU BITE TEST IAW AMM 31-32-00. BITE TESTED GOOD. NO FAULT. NO HISTORY. PER TSM 32-31-00-810-885-A, PERFORMED FUNCTIONAL TEST OF NORMAL RETRACTION & EXTENSISDR YENA2025122901275Converter · failedFLT 424, LAX-JFK. (ETOPS) CAPTAIN`S WINDSHIELD WIPER INOPERATIVE. REMOVED AND REPLACED THE CAPTAIN`S WINDSHIELD WIPER MOTOR CONVERTER IAW AMM 30-45-51. ALL OPS CHECKS OK. A/C OK TO CONT SVC.SDR ABXA20251227358Warning Message · illuminatedDURING TAXI OUT, EICAS MESSAGE CARGO A/C CONT.ILLUMINATED, A/C RETURNED TO GATE (BTB) AND MTX GROUNDED A/C . MTX THEN DEFERRED FWD CARGO A/C SYSTEM IAW MEL 21-28-1 ACCOMPLISH MAINT. PROCEDURE IAW MEL 21-28-1 PLACARD INSTALLED MBCB 4/26/26 A/C REMAINS ETOPS 18SDR DALA2025122809428Light · damagedEMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE. LIGHTING PIECE HAS BROKEN OFF FROM SEAT AN IS ON THE FLOOR. REATTACHED LIGHT ASSY & OPS CHECK GOOD. A/C OK FOR SERVICE REF A320AMM 33-51 . (LP: 1372007)SDR DALA2025122809426Sensor · faultedIFSD/DE - OIL TEMP EXCEEDANCE - ON APPROACH RIGHT ENGINE OIL TEMPERATURE EXCEEDANCE MESSAGE, CREW FOLLOWED QRH AND OIL TEMP CONTINUED TO RISE AND CREW SHUTDOWN ENGINE AND DECLARED AN EMERGENCY INTO IAD. FOUND FAULT FOR OIL TEMP SENSOR CH A/B DISAGREE. REPLACSDR REXA2026073101364Seat Track · corrodedCORROSION ON SEAT TRACKS RBL 9, LBL 9 AND LBL 27, BTW BS 349 - 485 AT PASSENGER CABIN DUE TO EXCESIVE DAMAGE SEAT TRACKS RBL 9, LBL 9 AND LBL 27, BTW BS 349 - 485 AT PASSENGER CABIN WILL BE REPLACED IAW SRM 53-21-49-101-001-A01 AND WERE REPLACED IAW AMM 53-00SDR REXA2026073101363Striker · corrodedCORROSION AT LOWER SILL, SEAL STRIKER & MOUNTING ANGLES OF WEB FLOOR PROTECTOR BTW FS 320.00 TO FS 349.00 OF SERVICE DOOR SURROUND STRUCTURE. CORROSION AT LOWER SILL, SEAL STRIKER & MOUNTING ANGLES OF WEB FLOOR PROTECTOR BTW FS 320.00 TO FS 349.00 OF SERVICESDR SWIA2025122675892Rivet · shearedTWO SHEARED RIVETS ON REAR PRESSURE BULKHEAD FWD FACE AT WL73.5 AND RBL36.20. REMOVED 2 SHEARED RIVETS ON REAR PRESSURE BULKHEAD FWD FACE AT WL73.5 AND RBL36.20 IAW SRM 51-42-06. PERFORMED EDDY CURRENT INSPECTION OF BORES THROUGH ENTIRE STACK UP WITH REFERESDR REXA2026030900190Joint · corrodedCORROSION ON CIRCUMFERENTIAL JOINT FS 280.0 TO FS 282.86 BTW STRGR 21RH TO STGR 24 RH AND BTW 25 RH TO 26 RH RH AT MAIN AVIONICS COMPARTMENT. AREA WAS CLEANED ON CIRCUMFERENTIAL JOINT FS 280.0 TO FS 282.86 BTW STRGR 20 RH TO STGR 20.5 RH AND 24.5 RH TO 26 RHSDR REXA2026030900189Floorbeam · crackedCRACKED CENTER COCKPIT FLOOR BEAM RBL12 AT FS 280.00 FLOOR INTERNAL SUPPORT STRUCTURE BELOW FLIGHT COMPARTMENT. CRACKED CENTER COCKPIT FLOOR BEAM RBL12 AT FS 280.00 FLOOR INTERNAL SUPPORT STRUCTURE BELOW FLIGHT COMPARTMENT WAS REPAIRED PER REO 690-53-11-2121SDR REXA2026030900182Floorbeam · crackedCRACKED CENTER COCKPIT FLOOR BEAM RBL12 AT FS 280.00 FLOOR INTERNAL SUPPORT STRUCTURE BELOW FLIGHT COMPARTMENT. CRACKED CENTER COCKPIT FLOOR BEAM RBL12 AT FS 280.00 FLOOR INTERNAL SUPPORT STRUCTURE BELOW FLIGHT COMPARTMENT WAS REPAIRED PER REO 690-53-11-2121SDR REXA2026030900167Support Angle · crackedCRACKED SUPPORT ANGLE (2 EAS) OF SHEAR BOX FS 280 LBL 12.0 AND RBL 12.0 MAIN AVIONICS COMPARTMENT. SUPPORT ANGLE (2 EAS) OF SHEAR BOX FS 280 LBL 12.0 AND RBL 12.0 MAIN AVIONICS COMPARTMENT WAS REPLACED ANGLES PER CRJ900 SRM 51-42-21-001-001-A01SDR REXA2026030900166Support Angle · crackedCRACKED SUPPORT ANGLE (2 EAS) OF SHEAR BOX FS 280 LBL 12.0 AND RBL 12.0 MAIN AVIONICS COMPARTMENT. SUPPORT ANGLE (2 EAS) OF SHEAR BOX FS 280 LBL 12.0 AND RBL 12.0 MAIN AVIONICS COMPARTMENT WAS REPLACED ANGLES PER CRJ900 SRM 51-42-21-001-001-A01SDR JJBA20260130046Skin · dentedFUSELAGE EXTERNAL SKIN, LH, AT FR 9, STR 17L. REPAIRED DENT IN FUSELAGE EXTERNAL SKIN, LH AT FR 9 STR 17LSDR SWAA2026012855730Support Angle · crackedCRACKED SUPPORT ANGLE, BS 867, S26 - 27L. REPLACED THE SUPPORT ANGLE IAW SRM 51-40-02-0G-0, AND DWG 149A8102, SHEET 19, REV A.SDR SWAA2026012855834Access Panel · elongatedELONGATED HOLES ACCESS PANEL 661BB, RT WING. REPAIRED THE ACCESS PANEL 661BB IAW SRM 51-70-04-2R-10, REPAIR 10, PARAGRAPH 4.H.SDR SWAA2026012855833Access Panel · elongatedELONGATED HOLES ON ACCESS PANEL 661AB, T/E, RT WING. REPAIRED THE ACCESS PANEL 661AB IAW SRM 51-70-04-2R-10, REPAIR 10.SDR SWAA2026012855835Access Panel · elongatedELONGATED HOLES ON ACCESS PANEL 661CB, T/E, RT WING. REPAIRED THE ACCESS PANEL 661CB IAW SRM 51-70-04-2R-10, REPAIR 10.SDR DALA2026012800677Fairing · missingON ARRIVAL, W/A CHK FOUND RT WING OTBD MOST LEADING EDGE SLAT LINKAGE FAIRING PANEL (SLAT #12) MISSING. DAMAGED AREA REPAIRED, THE NR 12 SLAT OTBD FAIRING PANEL WAS INSTALLED & PAINTED IAW AMM 51-21-10. (8130946)