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 SIMA202601209002Battery · inoperativeEMERGENCY L2 DOOR LIGHT AND EMERGENCY EXIT SIGN LIGHT WONT ILLUMINATE. RAR THE EMERGENCY-LIGHT POWER UNIT #3 IAW AMM 33-50-01. OPS CHECK GOOD OF THE L2 DOOR EMERGENCY LIGHT IAW AMM 33-50-00. NO FURTHER DEFECTS NOTED.SDR AALA202601206922Battery · inoperativeAIRCRAFT WAS GROUNDED: EMERGENCY LIGHTING SYSTEM CHECK FAILED. MAINTENANCE REPLACED WELS BATTERY FIM 33-50-F1-58A-421A.SDR AALA202601200067Charger · no testAIRCRAFT WAS NOT GROUNDED. F/A FLASHLIGHT BY R3 DOOR WILL NOT TEST. MAINTENANCE REPLACED BATTERY PACK. NO HELP. REPLACED CHARGER IAW AMM 25-64-00.SDR SWIA2026012000019Flap System · warning messageFLAP FAILURE OCCURRED DURING TAKEOFF. QRH DIDN€™T RESOLVE (FLIGHT 3726) FLAP FAILURE WAS DUE TO A MECHANICAL JAM PLEASE REFERENCE AML 1801790 FOR CORRECTIVE ACTION PLEASE REFERENCE AML 1801792 PLEASE REFERENCE AML 1801794SDR SWAA2026012062706Flashlight · dislodgedFLASHLIGHT UNDER A FLIGHT ATTNDT. SEAT NOT CHARGING. FOUND FLASHLIGHT DISLODGED; PERFORMED FLASHLIGHT CHECK IAW AMM 25-64-00. OPS CHECK GOOD.SDR SWAA2026012062749Flashlight · no testFWD FA FLASH LIGHT DOES NOT TEST PROPERLY. R & R FLASH LIGHT BATTERY. OPS CHECK GOOD IAW AMM 25-64-00.SDR SWAA2026012062817Hook · looseLEFT SIDE GIRT BAR J-HOOK ON AFT LEFT ENTRY DOOR LOOSE<[01] TIGHTENED J HOOK PER SIP GIRT BAR SECURED.SDR SWAA2026012062751Cover · dislodgedAFT LT ESCAPE SLIDE COVER DISPLACED. SECURED AFT LT SLIDE COVER IAW AMM 25-66-01. AC OK FOR SERVICE.SDR SWAA2026012062752Bulb · inoperativeAFT GALLEY CALL LIGHT SYSTEM FLIGHT ATTENDANT BLUE CALL LIGHT INOPERATIVE. REPLACED AFT GALLEY ATTENDANT CALL LIGHT BULB ON EMERGENCY EXIT SIGN IAW AMM 33-51-01.SDR SWAA2026012062750Light · inoperative15 ABC EMERGENCY EXIT INDICATOR LIGHT INOPERATIVE. REMOVED AND REPLACED 15 ABC EMERGENCY EXIT ASSEMBLY IAW AMM 33-51-01.SDR DALA2026012000419Skin · scratchedIN REF AMDS 5720-01100-04A STEP 18 , SCRATCH ON FASTENER HOLE NO.7 ON SKIN AND FITTING AT 5 O'CLOCK POSITION AT LT WING. REASON FOR RE-WRITE: AFTER FINAL INSTALLATION OF INBD DRAG FITTING WITH FRONT SPAR AND UPPER/ LOWER WING SKINS, UPPER LINK PIN MISSALIGNED SDR DALA2026012000418Skin · scratchedIN REF AMDS 5720-01100-04A STEP 18, SCRATCH ON FASTENER HOLE NR 7 ON SKIN AND FITTING AT 5 O'CLOCK POSITION AT LT WING. SCRATCH ON FASTENER HOLE NR 7 ON SKIN & FITTING AT 5 O'CLOCK POSITION AT LT WING WAS REPAIRED IAW PRI 592324-14, REV 0, TO PRI REV 6, AND ESDR FDEA202601190069Web · dentedFLIGHT DECK, BS 246, LBL 26 DAMAGED ON WEB. REPAIRED FLOORBEAM WEB BS 246 REF EA H-5310-TO386201 ALONG WITH SRM 51-20- 01-0G, SRM 51-40-02-0G, SRM 51-70-13-0G, AND AMM 53-01-01-4 .MAJOR REPAIR.SDR R61A2026011900010Hydraulic Line · leakingHYD 1 LO QTY IN FLIGHT. STARTED AT 12% AND LOST ALL HYD 1 FLUID. DECLARED EMERGENCY, LANDED WITHOUT INCIDENT. REMOVED AND REPLACED ENG 1 HYD PRESSURE PIPE.SDR DALA2026012000414Power Supply · failedAIRCRAFT 3016, DURING EPSU TEST FOUND EPSU FAIL INDICATION ON L1 DOOR (10WL). REPLACED L1 AND R1 DOOR ESCAPE SLIDES ON AMDS CARDS 2561-4001-LF, AND 2561-4002-RF. RE-ACOMPLISHED EPSU BITE CHECK IAW AMM 33-51-38-400-002-A OPS CHECKS GOOD. (LP 1409327)SDR MASA2026011900005Light · inoperativeSEAT 1A/2A PHOTOLUM INOPERATIVE PLACED ON MELSDR YENA2026012000045Unknown · odorFLT #283 JFK-MCO. A/C RT BY REAR DOOR BURNT RUBBER SMELL.;PERFORMED INSP OF A/C BELLY, APU AREA & ENGINES. NO ISSUES NOTED. PERFORMED APU RUN WITH BLEED. NO SMELL NOTED. PERFORMED DUAL ENG EUN NO SMELL NOTED. PERFORMED LEVEL A DECONTAM IAW AMM 21-00-00. A/C OKSDR BAGA2026012000004Unknown · odorDURING SERVICE FAS REPORTED WEIRD SMELL IN CABIN. TECH INSPECTED VENTS AND ONLY FOUND MINOR DUST. PERFORMED INSPECTION OF AREA WITH NO DEFECTS NOTED. PERFORMED AIR CONDITIONING SYSTEM OPERATION TEST. NO SMELLS OR DEFECTS NOTED. NO EMERGENCY DECLARED, AND NO MESDR YENA2026012000043Radar · malfunctionedFLT # 2220 LHR- JFK (ETOPS)."RADAR CONTINUOSLY PAINTS WXR, ALTHOUGH THERE IS NONE.ECHO RETURNING LIGHTNING STRIKES.; FOUND FAULTY WXR TRANSCEIVER/PROCESSOR.R/R 1SQ1 IAW AMM 34-41-33-400-003-A.FAULT CLEARED.OK FOR SVC."SDR YENA2026012000042Valve · faultedFLT 1115, JFK-SFO (ETOPS). COND TRIM AIR SYS FAULT. HOT AIR PRESS REGULATING VLV - N703 AND UP, CLOSED POSITION. OPS TEST OF COND TRIM SYS PASSED. NO GROUND REPORT FAULTS FOUND. IAW TSM 21-61-00-810-876-A. MDDR CLEARR. MX 4 UPDATED. PLACARD REMOVED.SDR KC8A20260120001Fire Loop · false activationDURING DECENT INTO DESTINATION AIRPORT, KYIP, THE RIGHT ENGINE WHITE CAS MESSAGE 'R ENG FIRE FAIL' FOLLOWED BY RED CAS MESSAGE 'R ENGFIRE' ON EICAS. CONTINUED DECENT, OBSERVED NO OTHER ENGINE ISSUES. RETARDED POWER LEVER TO FLIGHT IDLE. EICAS MESSAGES NO LONGESDR YENA2026012000041Warning Message · illuminatedFLT 348, LAS -JFK (ETOPS). AIR BLEED CLASS II MSG, CLASS II MAINTENANCE MESSAGES DISPLAYED ON ECAM STATUS PAGE OF ECAM SYSTEM DISPLAY 1, FAULTS INDICATED BY AIR BLEED . PERFORMED BITE TESTS OF EBAS REF TSM 36-00-00-810-804-A. OPC OK FOR SVC. NO FAULTS. MDDR SDR SIMA20260119001Strut · dischargedAFTER TAKEOFF LANDING GEAR WOULD NOT RETRACT POSITIVE RATE CALL ATTEMPTED TO RETRACT GEAR. LEVER WOULD NOT MOVE, APPROX. 3 SECONDS LATER LG WOW SYS FAIL EICAS MESSAGE APPEARED. RAN QRH CHECKLIST. MESSAGE CLEARED UPON TOUCHDOWN. EMERGENCY DECLARED NOT OVER WT. SDR SCNA20260120037Smoke Detector · false activationLAV SMOKE ALARM DESCENDING THRU 5000 FT. R&R FWD LAV SMOKE DETECTOR PER AMM 26-14-01 OPS CHECK GOOD THIS CLEARS MEL 26-16-1SDR SCNA20260120036Smoke Detector · false activationLAVATORY SMOKE DETECTOR AUDIBLE FALSE POSITIVE. RESET LAV SMOKE DETECTOR AND PERFORMED OPS CHECK OF LAV SMOKE DETECTOR IAW AMM 26-14-00-710-802 OPS CECKS GOOD. ACFT OK FOR CONTINUED SERVICE.SDR DXTA2026012006593Battery Pack · faultedEMER LIGHT NOT ARM CAS ON WITH SWITCH IN ARM, ENGINES RUNNING AND NO GPU. GROUND RESET PROCEDURE UNSUCCESFUL. REVIEWED SL505-33-0005 REV 5 "EMER LIGHT T/S" AND FOUND THAT BOTH BATTERY PACKS ARE CAUSING THE ISSUE CONFIRMED 'G' SWITCH NOT TRIPPED. REMOVED FWD ESDR DXTA2026012006591Battery Pack · faultyRIGHT FORWARD EXTERIOR EMERGENCY LIGHT DOES NOT COME ON DURING EMERGENCY LIGHT TEST. REMOVED NR 3 BATTERY. INSTALLED CUSTOMER SUPPLIED NEW EMER BATTERY. OPS CHECKED GOOD. WORK DONE IAW AMM 33-50-10. NO DEFECTS NOTED.SDR CALA2026012013107Light · inoperativeFOUND PATHWAY LIGHT ON SIDE OF SEAT 39D INOP. FOUND 39F LIGHT INOP AS WELL. REPLACED BOTH PATHWAY LIGHTS AT SEATS 39D AND 39F. STILL NOT WORKING. REFERENCE CMM 25-23-52. DISCONNECTED BOTH PATHWAY LIGHTS AT 39 D&F. MEASURED 6V AT BOTH CONNECTORS AND MEASURED GSDR CALA2026012013105Shaft · damagedHYD PRESS PRI R EICAS PUMP OFF PER ECL PUMP STILL HAS FAULT REMOVED THE RIGHT ENGINE DRIVEN PUMP, FOUND DAMAGE TO THE SHAFT. IN ACCORDANCE WITH DMC B787-A-29-11-02-00B-520A-A FITTED ENGINE DRIVEN PUMP ON RIGHT ENGINE TO DMC-B787-A-29-11-02-00B-720A-A. COMPLETESDR CALA2026012013104Elec Connector · dirtyDOOR 2R SLIDE/OVERWING LIGHT INOP CLEANED POWER SUPPLY M33098 WIRE CANNON PLUG DM33098 REF WDM 33-51-42 AND SWPM 20-10-04.SDR 2026FA0000043Frame · puncturedDURING MAINTENANCE INSPECTIONS AT IAI, A PUNCTURE WAS FOUND ON THE WEB OF FRAME STA 1417 BETWEEN STR 37R AND 39R. WORK PERFORMED IAW REA NO: MF03036R0237.SDR 2026FA0000042Ring · wornDURING MAINTENANCE INSPECTION, WEAR DAMAGE FOUND ON ENGINE NR 1, RIGHT FAN REVERSER, AFT CLOSEOUT RING AT THE LOWER AND UPPER CORNERS.WORK PERFORMED IAW REA NO: MF03036R0222.SDR 2026FA0000041Frame · corrodedDURING CONVERSION, CORROSION WAS FOUND ON THE FRAME AT STA1480, BETWEEN STR 22L AND STR 24L. WORK PERFORMED IAW- REA NO: MF03036R0202.SDR DALA2026011900412Fork · crackedFOUND FRAME FORK CRACKS OF THE FRAME FR64-FRAME FORK AREA H-5.AT BEAM 4 IN THE AFT CARGO COMPARTMENT DOOR BY ROTATING PROBE INSPECTION AS PER W/C:5230-01164-08 STEP 11. REPLACED THE CRACK FRAME FORK AT FR64 PER W/C 5230-01164-10. (LP 1408873)SDR DALA2026011900411Fork · crackedFOUND FRAME FORK CRACKS OF THE FRAME FR63A-FRAME FORK AREA H-5 AND H-6.AT BEAM 4 IN THE AFT CARGO COMPARTMENT DOOR .BY ROTATING PROBE INSPECTION IAW W/C 5230-01164-08 STEP 10. REPLACED THE CRACKED FRAME FORK AT FR63A PER W/C5230-01164-10. (LP 1408856)SDR DALA2026011900410Seat Track · corrodedCABIN SEAT TRACK UPPER SURFACE FOUND CORROSION AT FR52-53 Y1959. SEAT TRACK REPAIRED AS PER A330 SRM53-31-15-300-001 REV 128.00-NOV-24-2025. (LP 1408842)SDR DALA2026011900409Seat Track · corrodedCABIN SEAT TRACK UPPER SURFACE FOUND WITH CORROSION AT FR 52-53.2 -Y1959. SEAT TRACK REPAIRED AS PER A330 SRM 53-31-15-300-001 REV 128.00-NOV-24-2025. (LP 1408765)SDR DALA2026011900407Pin · brokenTWO EACH EMERGENCY PATH LIGHTS INOP AT EXIT ROW 13C AND 14C SEATS. FOUND SIDEWALL CONNECTOR AT SEAT 14A WIRE BROKEN AT CONNECTOR PIN. RE-TERMINATED WIRE TO CONNECTOR PIN OPS CKS GOOD. (LP 8437168)SDR FDEA202601190068Skin · corrodedNR 2 ENGINE UPPER NACELLE INTERNAL STRUCTURE OTBD SIDE PPS 134.76 CORRODED. THIS ITEM HAS BEEN ACCOMPLISHED ON EA # F-5430-T0386151 P1 TITTLE: NACELLES/PYLONS- SKIN/PLATES/PANELS- # 2 PYLON O/B SIDE SKIN-EXISTING REPAIR DOUBLER BETWEEN PP STA 174-190, WITHSDR FDEA202601190067Skin · corrodedNR 2 ENGINE UPPER NACELLE INTERNAL STRUCTURE OTBD SIDE PPS 200.50 SUSPECTED CORROSION. ACCOMPLISHED ON EA F-5430-T0386151 P1 TITTLE: NACELLES/PYLONS- SKIN/PLATES/PANELS # 2 PYLON O/B SIDE SKIN-EXISTING REPAIR DOUBLER BETWEEN PP STA 174- 190, WITH CORROSION SDR 2026FA0000039Frame · damagedDURING CONVERSION AT IAI FACILITIES, SHOP FOUND DAMAGED FRAME WEB AT STA 478, BETWEEN STR - 27R AND STR - 28R (LARGE CARGO DOOR SURROUND). WORK PERFORMED IAW - REA NO: MF03036R0206.SDR 2026FA0000038Frame · corrodedCORROSION FOUND ON FRAME STA 1439, OUTER FLANGE, TWO LOCATIONS BETWEEN STR 17L-18L.SDR 2026FA0000037Channel · crackedDURING MAINTENANCE INSPECTIONS AT IAI FACILITIES SHOP FOUND A CRACK ON CHANNEL. DAMAGED AND ENLARGED FASTENER HOLES ON OUTER SKIN FAIRING. WORK PERFORMED IAW REA MF03036R0216.SDR DALA2026083104896Bracket · corrodedRT MLG DOOR CENTER HINGE FWD SEAL RETAINER BRACKET CORRODED. BRACKET WIP 359055 BRACKET WAS REPLACED ON PRI 631605-14 (1408230)(AIRCRFT GROUNDED)SDR VNAA20260508016Floor Support · damagedUPON REMOVAL OF LH FS 280 CROSS BEAM FOUND SEVERAL OVERSIZED FASTENER HOLES IN THE LH FLOOR SILL BETWEEN FS 280 AND FS 290. REPAIRED LH FLOOR SILL OVERSIZED FASTENER HOLES BETWEEN FS 280 AND FS 290 REO 670-53-21-2788 REV-- DATED 2-25-26.SDR SWIA2026011875816Intercostal · corrodedPAX DOOR AFT INTERCOSTAL DD5 HAS CORROSION. REMOVED AND INSTALLED PAX DOOR NEW DD5 AFT INTERCOSTAL PN 601R31902-317 PER CRJ 200 SRM 51-42-06 AND DWG 601R31902 REV BW. LEAK CHECK GOOD COMPLIED WITHSKYWEST TASK CARD 51-900-1003-SKY AND M-337SDR SWIA2026011875735Skin · corrodedDEEP CORROSION PIT FOUND BEHIND RH FUSELAGE HINGE FITTING OF REAR NOSE LANDING GEAR DOOR. WET INSTALLED ALL REPAIR PARTS AT STR 26R & NLG BAY WEB FWD OF FS.235 & RBL 6 WITH NEW FASTENERS PER REO 601R-53-11-4054 REV --. LEAK CHECK GOOD. COMPLIED WITH TASK CARDSDR SWIA2026011875591Fitting · crackedWINDSHIELD CENTER POST LOWER LT FITTING IS CRACKED. REPLACED WINDSHIELD CENTER POST LOWER LH FITTING IAW SRM 51-42-21SDR SWIA2026032775583Fitting · crackedWINDSHIELD CENTER POST LOWER RT FITTING IS CRACKED. REPLACED THE WINDSHIELD CENTER POST LOWER FITTING IAW SRM 51-42-21. MAJOR REPAIR.SDR SWIA2026011875578Intercostal · corrodedMAIN AVIONICS BAY, INTERCOSTAL AT BS 394 - 409 BETWEEN STRINGERS 26R & 27R HAS TWO AREAS OF MINOR CORROSION AND INTERCOSTAL AREA MINOR CORROSION. REMOVED AND REPLACED THE INTERCOSTAL IAW SRM 51-42-06 & 51-42-21.