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 YENA2026012100048Skin · corrodedDURING HEAVY MAINTENANCE: FUSELAGE / REAR FUSELAGE / LOWER SKIN PANEL / FR64-FR65 BETWEEN STGR43L-STGR44 / CORROSION AND ELONGATED HOLE - TIME LIMITED REPAIR; REFERENCES: /1/ AEM EA 53-0094-25 (COVER + PARTS 1-4) /2/ AIRBUS DOSSIER 81702291 /3/ AIRBUS RDAF 817SDR YENA2026012100047Frame · damagedDURING HEAVY MAINTENANCE: WINGS / CENTER WING 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 81679714SDR YENA2026012100046Skin · damagedDURING HEAVY MAINTENANCE: FUSELAGE / REAR FUSELAGE / EXTERNAL SKIN / BTW FR 82-83 AND STGR 3-5LH / DENT DAMAGE – PERMANENT REPAIR; REFERENCES: /1/ AEROMAN EA 53-0095-25 (COVER + PART 1-2) /2/ RDAF 81703158/002/2025#A /3/ AIRBUS DOSSIER 81695068 /4/ A321NEO SRSDR CALA2026012113129Anti-Ice Valve · faultedRTO AT 20KTS FOR COWL ANTI-ICE CAUTION NR 1 ENGINE. R & R THE NR 1 ENGINE COWL ANT-ICE VALVE IAW AMM 30-21-11-400-801. OPS & LEAK CHECKED GOOD IAW AMM 30-21-11-400-801. ACFT OK TO CONTINUE SERVICE.SDR CALA2026012113127Computer · faultyTCAS FAIL FLAG SHOWS ON ND CAPTAIN'S. PERFORMED WIRING CHECK FOR TCAS TOP & BOTTOM ANTENNA & CHECKED TCAS COMPUTER UNIT IAW FIM 34-45 TASK 803, & WDM 34-45-21-10. WIRING CHKD GOOD, BUT FOUND TCAS COMPUTER UNIT FAILED. R & R THE TCAS COMPUTER UNIT IAW AMM 34SDR CALA2026012113120Skin · dentedREPLACE AFT CARGO DOOR SKIN DUE TO CONDITION AND NUMEROUS DIPS. REMOVED AND REPLACED AFT CARGO DOOR SKIN IAW SRM 51-40-02-0G-0, AND DWG 146A6110.SDR WX0A2026012032705Unknown · odor(AIRCRAFT GROUNDED) STRONG SMELLY SOCK ODOR IN FLIGHT DECK AND REPORTED BY FA'S IN CABIN, ON DESCENT THROUGH 10,000 MSL. COMPLIED WITH A32X-21-000-002 TASK CARD IAW ALLEGINAT POLICIES AND PROCEDURES. C/W TASK CARD 05-000-011 NO DEFECTS NOTED.SDR ASAA2026011862922Battery · inoperativeOVERWING EMERGENCY LIGHTS INOPERATIVE. GROUNDED - YES. R & R THE EMERGENCY LIGHT BATTERY FOR OVERWING LIGHTS IAW 33-51-06. OPS CHKD GOOD. OK FOR SERVICE.SDR DALA2026012000436Battery Pack · inoperativeMULTIPLE SECTIONS OF EMERGENCY LIGHTS OUT. REPLACED BATTERY PACKS FOR LOCATIONS M02816, M1676, M1673, M2627, IAW AMM 33-51. OPS CHKD GOOD. (LP 8048286)SDR ASAA2026011863806Battery Pack · inoperativeWHILE PERFORMING T/C 78233008, FOUND CABIN OVERWING EXIT SIGNS NOT ILLUMINATED. GROUNDED - YES. R & R THE LT & RT OVERWING BATTERY PACKS REF AMM 33-51-06-960-805. OPS TEST PASSED.SDR SWI2026F00081Warning Message · illuminatedPASSENGER DOOR WARNING RECEIVED IN FLIGHT. RAN QRH PROCEDURE. FLIGHT ATTENDANT REPORTED A POPPING NOISE FROM THE MCD IN FLIGHT BEFORE WARNING RECEIVED. (FLIGHT 4957) THIS DISCREPANCY WAS TRANSFERRED TO CAMP ITEM 31562889 WITH THE FOLLOWING CORRECTIVE ACTION:SDR SWAA2026012062730Seat · unlockedPAX SEAT 14B WILL NOT STAY IN THE LOCKED UPRIGHT POSITION. FOUND TO BE OVERWING EXIT SEAT, ENSURED SEAT LOCKED UP IAW AMM 25-22-00.SDR SWAA2026012062567Battery · inoperativeCAPTAIN`S PORTABLE FLASHLIGHT INOPERATIVE. REMOVED AND REPLACED THE CAPTAIN`S PORTABLE FLASHLIGHT BATTERY IAW AMM 25-64-00.SDR SWAA2026012062556Battery · inoperativeFWD GALLEY AREA ALL EMERGENCY LIGHTS ARE INOPERATIVE. R & R FWD GALLEY BOTH BATTERIES AND POWER SUPPLY M01675 AND M02816. OPS CHKD GOOD IAW AMM 33-51-06.SDR SWAA2026012063118Battery Pack · inoperativeFWD GALLEY AREA ALL EMERGENCY LIGHTS ARE INOPERATIVE. R & R THE FWD GALLEY BOTH BATTERIES AND POWER SUPPLY M01675 AND M02816. OP?S CHKD GOOD IAW AMM 33-51-06.SDR DALA2026012000423Cover · misinstalledHARD TO OPERATE (DISARMED- ARMED AT HALF WAY) R2 DOOR SLIDE ACTIVATION HANDLE. GIRT BAR PROXIMITY SWITCH (S10220 AND S10221) COVERS WERE INSTALLED CORRECTLY PER AMM 25-66-11 AND GIRT BAR HANDLE OPERATES FREELY. (1407095)SDR DALA2026012000422Reservoir · low pressureR4 & R1 EMERGENCY POWER RESERVOIRS, LOW PRESSURE (LESS 2,000 PSI) AT R2 EMERGENCY POWER RESERVOIR. RESERVOIR AT 1R DOOR WAS REPLACED WITH SERVICEABLE RESERVOIR PER B757-200 AIPC 52-11-30-01. INSTALL ACOMPLISHED UNDER AMDS 5211-9001-1R STEP 20 AND RESERVOIR ATSDR DALA2026012000421Skin · dentedFUSELAGE DENT BETWEEN BS 620 - 640, STRINGERS 15L-17L. REMOVED SKIN SECTION WHERE DAMAGE WAS LOCATED IAW SRM 53-30 -01-2R-2. PERFORMED HFEC OF CUTOUT & BHEC OF OPEN FASTENER HOLES, NO DEFECTS NOTED IAW SRM 53-30-01-2R-2. PERFORMED DVI OF STRUCTURE AROUND CUTSDR DALA2026012000417Frame · corrodedCORROSION ON FRAME BS 1540 BTW S28 & 29R IN AFT CARGO BAY. FRAME BS 1540 BTW S28 & 29R IN AFT CARGO BAY WAS REPAIRED IAW PRI 631344-14, REV 0, AND ER/A 631344-14 REV. ORIGINAL SECTION I: REPAIR INSTRUCTIONS. (1408040)SDR IPXA202601202670Slide · no testDURING OPERATIONAL CHECK OF CREW DOOR ESCAPE SLIDE, EMERGENCY CYLINDER DOOR ASSIST. FAILED TO DEPLOY.SDR GTIA2026012039250Megaphone · inoperativeF/A MEGAPHONE INOP IN AFT GALLEY. R & R F/A MEGAPHONE IN AFT GALLEY IAW AMM 25-65-51. OPS CHECK GOOD.SDR F2PA202601200004Flap System · out of rigFLAP FAIL CREW WAS STAGED TO LANDED ON FINAL. CONDITIONS WERE IMC, ENGINE AI AND WING STAB WAS ON. UPON SWITCHING FROM FLAPS 0 TO 1, FLAP FAIL CAS MESSAGE IMMEDIATELY APPEARED. CREW REQUESTED PUBLISHED MISSED APPROACH. CREW RAN FLAP FAIL MESSAGE AND NO CHANGESSDR R61A2026011800009Transducer · faultedBRK RT FAULT DURING APPROACH TO LANDING. DECLARED EMERGENCY, LANDED WITHOUT INCIDENT. REMOVED AND REPLACED #4 MLG WHEEL SPEED TRANSDUCER.SDR AALA202601209257Wire · brokenAIRCRAFT WAS GROUNDED: SEAT MOUNTED EMERGENCY EXIT LIGHTS AT ROW 28 AND 29 INOPERATIVE. MAINTENANCE REPAIRED BROKEN WIRES ON SEAT HARNESS AT ROW 28 AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK OF THE EMERGENCY LIGHTING SYSTEM WITH NO ISSUES NOTED.SDR AALA202601203893Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT AFT PASSENGER / CREW DOOR CUTOUT LOWER SILL AT FR 68 AND S23L. REPAIRED DOOR SILL PER SRM 53-41-14-300-001 REPAIR PRINCIPLE #5.SDR SCNA20260120035Bustle · looseL1 BORDING DOOR SLIDE VIEWING PANEL LOOSE. RESECURED WINDOW TO L1 SLIDE BUSTLE IAW AMM 25-66-00. OKAY FOR SERVICE.SDR CALA2026012013113Sense Line · contaminatedLEFT VALVE CAUTION LIGHT ON WING ANTIICE PERFORMED FIM 30-11 TASK 808. OPERATED VALVE FROM COCKPIT AND OBSERVED LEFT WING ANTI-ICE VALVE MOVING AS SWITCH WAS OPENED AND CLOSED FROM COCKPIT. SUSPECTED MOISTURE WAS IN SENSE LINE IN VALVE. ONCE VALVE WAS WARMED SDR CALA2026012013112Indicator · faultedON DEPARTURE SPEED TRIM FAIL LIGHT ILLUMINATED TWO TIMES. COULD NOT ENGAGE A/P CMD A OR B. DEBRIEFED CREW, CREW FOUND THE AUTOPILOT STAB TRIM SWITCH IN THE CUTOFF POSITION. THEY STATED THEY MUST OF MISSED IT ON THEIR PREFLIGHT CHECK. BUT THE SPEED TRIM INOP CASDR CALA2026012013102Power Supply · faultedDUE TO SMOKE ODOR REPORTED IN CABIN, ACCOMPLISHED SMOKE ODOR INSPECTION IAW AMM DMC-B787-A-05-51-99-99A-282A-A. COMPLETED. INTENSIFIED VISUAL INSPECTION OF UNDER SEAT CARRIAGE ASSY OF SEATS 9D AND 10D FOR ELECTRICAL CABLE SHORTING & SIGNS OF BURNING, NO INDICASDR CALA2026012013100Lens · missingDURING LINE CHECK ROW 3 CEILING EMER LIGHT COVER MISSING REPLACED COVER REF IPC 33-51-03 PARTS USED: 29-3351-3-0076,QTY :1SDR CALA2026011913080Acm · overtempDIRTY SOCK/OIL OODR IN FLIGHT DECK WITH LEFT PACK OFF AND RIGHT PACK ON ODOR FADES AWAY. WITH LT PACK ON AND RT PACK OFF ODOR COMES BACK. FOUND MAINTENANCE MESSAGE 21-21191 AND 21-23401 LATCHED. LT PACK OPS FOR ABOUT 5 MINS & SHUTSDOWN DUE TO OVERTEMP. SUSPECSDR CALA2026011913079Oven · smokeFIRE OBSERVED AND EXTNG FWD GALLY OVEN 204. COMPLETED SMOKE AND ODOR FORMS BY FA AND CAPTAIN PERFORMED GVI OF OVEN 204, FOUND BURNT RESIDUAL FOOD ON INSERT. PHOTOS ATTACHED REMOVED AND REPLACED FWD GALLEY OVEN 204. REF AMM 25-34-00 OPS CHECK GOOD.PARTS USED: SDR CALA2026011913078None · no discrepancyPLASTIC ODOR IN PLANE, SMELLS LIKE NEW INTERIOR, NO SMOKE ODOR NOTED. OKAY FOR SERVICE AT THIS TIME IAW AMM 05-51-26-800-801-C1.SDR I5PA2026011988801Anti-Ice Valve · stickingLEFT ENG ANTI-ICE VALVE STICKING. R & R LT ENG ANTI-ICE VALVE IAW AMM 30-21-03. OP CHECKED NORMAL.SDR SWI2026F00080Limiter · trippedSLAT FAIL ON APPROACH TO HDN. QRH DID NOT FIX, SLAT DID NOT ADVANCE OR RETRACT FROM BETWEEN 0 AND 1 POSITION (FLIGHT 3100) UPON ARRIVAL TO A/C SLAT FAIL STILL PRESENT. FOUND FAULT CODE 27811021ACE IN CMC. TROUBLESHOT PER FIM 27-81-00-810-802-A. CHECKED SLAT SDR SWI2026F00079Warning Message · activatedPASSENGER DOOR WARNING RECEIVED IN FLIGHT. RAN QRH PROCEDURE. FLIGHT ATTENDANT REPORTED A POPPING NOISE FROM THE MCD IN FLIGHT BEFORE WARNING RECEIVED. (FLIGHT 4957) OPENSDR SWIA2026011900008Warning Message · illuminatedRECEIVED LG DISAGREE WARNING MESSAGE AFTER TAKEOFF; RAN QRH, LANDING GEAR WAS SHOWING A DISAGREE OF THE LEFT MAIN LANDING GEAR DURING THE RETRACTION PHASE (QRH CALL FOR CYCLING THE GEAR.) MESSAGE CLEARED AFTER EXTENDING THE GEAR, SHOWING 3 GREEN IN THE DOWN ANSDR JJBA20260119039Lamp · inoperativeRIGHT OVERWING EXTERNAL EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED RH OVERWING EXTERNAL EMERGENCY LAMP. OPS CHECK SAT.SDR IXXA202601118005Proximity Switch · faultedSLIDE LIGHT ARMED LIGHT WILL NOT ILLUMINATE WHEN ARMED ON L1 DOOR. PLACED ON DEFERRAL 69878 MINIMUM EQUIPMENT LIST ATI-25-66-05-01 CATEGORY C. DUE 28 JANUARY 2026. REMOVED AND REPLACED AFT AND FORWARD PROXIMITY SENSORS IN ACCORDANCE WITH AMM 25-66-11. OPS CSDR ABXA202601198019Warning Light · false activationMAIN CARGO DOOR LIGHT ILLMINATED ON PUSHBACK NEVER DISCONNECTED FROM TUG (BTB). MTX ENTERED ACFT AND OPENED MCD DOOR AND CHECKED OPERATION .CLOSED CARGO DOOR AND LOOKED. ADVISORY LIGHT ADVISORY LIGHT WENT OUT. OPS CHECK NORMAL AND IAW AMM 52-32-00, ACFT DEPASDR SCNA20260119034Light · inoperativeEMERGENCY AREA LIGHT INOP AT ROW 12DEF. REMOVED AND REPLACED EMERGENCY AREA LIGHT LAMP IAW AMM 33-51-03-960-801. OPS CHECK GOOD. A/C OK FOR SERVICESDR CALA2026011913053Power Supply · no testFOUND EPSU UNIT AFT LIGHT FAULT DURING OPS CHECK OF THE EMERGENCY POWER SUPPLY. R & R AFT EPSU AND BATTERY IAW AMM 33-51-38-400-001-A. OPS CHECKED GOOD.SDR JR2R20260118974Rib · crackedLH HORIZONTAL STAB TIP CAP, 335AL, RIB CRACKEDSDR JR2R20260118971Rib · crackedRH HORIZONTAL STAB TIP CAP, 345AR, RIB CRACKEDSDR IXXA2026011801Panel · delaminatedLEFT HAND VERTAL STAB UPPER SURFACE LEADING EDGE BONDED PANEL DELAMINATEDSDR 2026FA0000036Skin · abnormalDUE TO EXISTING EXTERNAL REPAIR IN FUSELAGE SKIN, SHOP CANNOT INSTALL SHEAR TIE, P/N 95292-257 IN ACCORDANCE WITH DWG REQUIREMENTS.SDR 2026FA0000035Shear Tie · damagedSHOP FOUND SIX (6) EXISTING 7/32" DIAMETER FASTNER HOLES DURING SALVAGED SHEAR TIE, P/N BACF3T01G7G16 REMOVAL AT STA 390, BETWEEN STR-20L AND STR-21L. REFER TO FIGURES 1 AND 2 FOR E.M AND FASTENER SPACING.SDR 2026FA0000034Tear Strap · gougedDURING INSTALLATION OF P/N 368-53-11-90830-235 SHEAR TIE PER DWG 371-53-11-C3147, VIEWS 1B3 AND 1B12, A GOUGE WAS FOUND ON THE TEAR STRAP AT STA 368, BETWEEN STR 20L AND 21L. THE GOUGE WAS REMOVED, AND THE RESULTING BLEND-OUT DIMENSIONS ARE 1.00" X 0.320". THESDR 2026FA0000033Skin · mechanic errorDURING INSTALLATION OF SHEAR TIE PER DWG 371-53-00-C4157 VIEWS 5C8-1 AND 1B5, THE SHOP MISTAKENLY DAMAGED THE COUNTERSINK OF ONE FASTENER HOLE COMMON TO THE FUSELAGE SKIN AT BS 1241, BETWEEN STR 27R AND 28R.SDR 2026FA0000032Frame · mechanic errorDURING CNV WORK SHOP CAUSED DAMAGE TO THE FRAME EDGE AT SPLICE AREA, OUTER FLANGE.