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 SWI2026F00009Floor Support · corrodedFWD PAX DOOR CUTOUT FLOOR SUPPORT CORRODED. REMOVED AND REPLACED FWD PAX DOOR CUTOUT FLOOR SUPPORT BEAM IAW SRM 51-40-08.SDR SWI2026F00008Beam · chafedFWD CARGO DOOR CUTOUT LOWER BEAM AFT FINGER DOUBLER UPPER SURFACE CHAFED AS MARKED FR 25-27. REMOVED AND REPLACED FWD CARGO DOOR CUTOUT LOWER BEAM AFT FINGER DOUBLER REF. SRM 51-40-08.SDR SWI2026F00007Beam · corrodedLEFT BEAM, FR 86 - 89 CORRODED. REMOVED AND REPLACED THE LT BEAM IAW SRM 51-40-08.SDR SWI2026F00006Seat Track · gougedRIGHT INBD SEAT TRACK HAS GOUGES AND CORROSION, FR 23- 34. REMOVED AND REPLACED THE RT INBD SEAT TRACK IAW SRM 51-40-08.SDR SWI2026F00005Rib · crackedSUSPECTED CRACK LT HORIZONTAL RIB 11 UPPER FLANGE. REMOVED AND REPLACED LT HORIZONTAL RIB 11A IAW ETD2025-170-933833, SRM 51-40-08.SDR SWI2026F00004Seat Track · gougedRH OB LATERAL SEAT TRACK HAS GOUGES AND CORROSION FR 23- FR 34. REMOVED AND REPLACED RT OTBD LATERAL SEAT TRACK FR 23-34 WITH NEW IAW SRM 51-40-08.SDR SWI2026F00003Seat Track · gougedLEFT INBD SEAT TRACK HAS GOUGES AND CORROSION AS MARKED FR 30 - 34. REMOVED AND REPLACED THE DAMAGED LT INBD SEAT TRACK BETWEEN FRAMES 23-34 IAW SRM 51-40-08. SEAT TRACK REPLACED WITH OEM PARTS. NO CHANGES TO WEIGHT AND BALANCE.SDR SWIA2025123100007Rib · crackedSUSPECTED CRACK LH HORIZONTAL RIB 12 UPPER FLANGE. REMOVED AND REPLACED LH HORIZONTAL RIB 12A REF: ETD2025-170-933833 SRM 51-40-08. REPLACED WITH OEM PART- NO CHANGE IN WEIGHT AND BALANCE.SDR AALA202512314664Skin · delaminatedAIRCRAFT IN BASE MAINTENANCE: RIGHT WING, INBOARD FLAP OUTBOARD TRAILING EDGE SKIN DELAMINATED. REPLACED LOWER SKIN PER CMM 57-53-05.SDR SWIA2025122307Stay · faultedLG LEVER DISAGREE MESSAGE AFTER TAKEOFF AND RETRACTION ATTEMPT.RIGHT MAIN DID NOT RETRACT, COULD HEAR AND FEEL RIGHT MAIN WAS STILL DOWN. QRH PROCEDURE FOLLOWED. GEAR CONFIRMED DOWN AND GREEN AS PER QRH PROCEDURE. (FLIGHT 5367) PERFORMED GEAR SWINGS IAW AMMSDR SWAA2025121849219Retainer · missingRIGHT EMERGENCY EXIT FWD LENS RETAINER FOUND MISSING. FOUND AND INSTALLED THE MISSING RT, FWD LENS RETAINER IAW AMM 33-21-00-960-804.SDR SWAA2025121643476Panel · delaminatedPANEL 193B DELAMINATED AT TRAILING EDGE UNDER THE LOWER ANTI-COLLISION LIGHT. REPAIRED THE PANEL 193B IAW SRM 53-40-70-2R-1, AND SRM 51-70-04-2R-1.SDR SWAA2025121643747Retainer · missingRIGHT EMERGENCY EXIT FWD LENS RETAINER FOUND MISSING.SDR VNAA2025121611101Dcu · faultedELEVATOR SPLIT CAUTION MSG W/ CAS MISCOMP / INTERROGATED MDC DID NOT FIND B1. TS IAW CRJ 700 FIM 31ˆ’41ˆ’00ˆ’810ˆ’802 AND 27ˆ’31ˆ’00ˆ’810ˆ’803. PERFORMED OPS CHECK OF ELEVATOR IAW CRJ 700 AMM 27€“31€“00€“710€“801. REMOVED DCU 1 AND DCU 2 IAW CRJ 70SDR AALA202512165396Relief Valve · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: SHORTLY AFTER LEVEL OFF AT FL370, CABIN ALTITUDE ALERT SOUNDED AND FLASHED, MANUALLY DEPLOYED MASKS. AIRCRAFT DIVERTED TO AND LANDED SAFELY AT PIT. GVI OF APU AIR DUCT BOOT. REMOVED AND REPLACED OUTFLOWSDR AALA202512164641Relief Valve · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: SHORTLY AFTER LEVEL OFF AT FL370, CABIN ALTITUDE ALERT SOUNDED AND FLASHED, MANUALLY DEPLOYED MASKS. AIRCRAFT DIVERTED TO AND LANDED SAFELY AT PIT. *GVI OF APU AIR DUCT BOOT. REMOVED AND REPLACED OUTFLOWSDR AALA202512168232Outflow Valve · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: SHORTLY AFTER LEVEL OFF AT FL370, CABIN ALTITUDE ALERT SOUNDED AND FLASHED, MANUALLY DEPLOYED MASKS. AIRCRAFT DIVERTED TO AND LANDED SAFELY AT PIT. GVI OF APU AIR DUCT BOOT. REMOVED AND REPLACED OUTFLOWSDR ASAA2025120763016Floor Support · corrodedMAIN CABIN SUPPORT 147A5710-17 AT BS 986.5 FOUND CORRODED. GROUNDED - YES. REMOVED CORROSION IAW SRM 51-10-02 INVESTIGATION FOUND TO BE 100% MAT LOSS OUT OF LIMITS, DRILLED TO FIT NEW SUPPORT P/N 147A5710-17 PO:1137788.1 AND INSTALLED NEW FLOOR SUPPORT STA 986SDR AALA202512156372Light · inoperativeAIRCRAFT IN BASE MAINTENANCE: SEAT16H EMERGENCY LIGHT INOP. MAINTENANCE REPLACED EPL AT SEAT 16H IAW AMM 33-50-00.SDR AALA202512159286Light · inoperativeAIRCRAFT IN BASE MAINTENANCE: SEAT 11D EMERGENCEY OUT LIGHT INOP. MAINTENANCE REPLACED EPL AT SEAT 11D IAW AMM 33-50-00.SDR HYIA20251212001Blower · failedPILOT REPORTED LOW AIRFLOW AND A BURNING SMELL FROM THE CABIN HEATER. MAINTENANCE INSPECTED AND FOUND THE COMBUSTION HEATER VENT BLOWER AT FAULT. THE BLOWER WAS REPLACED WITH NO FURTHER DEFECTS NOTED.SDR SWAA2025121243582Skin · crackedPERMANENT REPAIR SKIN DEFORMATION WITH EDGE CRACK AND A DENT ON UNDERLYING FRAME. REMOVED FILLET SEAL COMMON TO DOOR SKIN AND DOOR FRAME; UPON REEVALUATION OF DAMAGE; FOUND DAMAGE TO BE LIMITED TO UNPRESSUREIZED AREA OF DOOR SKIN ONLY; NO DAMAGE NOTED TO FRASDR SWAA2025121243658Smoke Detector · false activationAFTER LAV SMOKED ALARM ACTIVATED INTERMITTENTLY DURING FINAL DESCENT AND AT THE GATE. NO SIGNS OF SMOKE. OK TO CONTINUE PER MEL 26-16-01 XB;AFT LAVATORY SMOKE DETECTION SYSTEM. WITH SP 1B & 3 AND AUTHORIZATION NUMBER 296463. R & R AFT LAVATORY SMOKE DETECTOSDR CALA2025121212044Battery · inoperativeL1 DOOR NEEDS EPAS BATTERY PACK REINSTALLED REF 52-11-20-400-813. INSTALLED EPAS BATTERY PACK ON DOOR 1L UP TO STEP 5 G(3)(E), AMM 52-11-20-400-814. EPAS BATTERY OPS TEST FAILED IAW AMM 52-11-20-700-812. AMBER SQUIB CONTINUITY TEST LIGHT WOULD NOT ILLUMINATE ASDR ASAA2025120762878Power Supply · inoperativeEMERGENCY LIGHT EXIT SIGN BATTERY M1673 FAILS TASK CARD 33-055-00. GROUNDED - YES. REPLACED EMERGENCY LIGHT M1673 BATTERY PACK PER AMM 33-51-06. BATTERY PACK CHECKS GOOD AREA ACCESSED BY MAINTENANCE. SEAL ADDRESSED BY MAINTENANCE.SDR SWAA2025121143796Tray · out of adjustTRAY TABLE EXIT ROW (FO SIDE) WONT STAY LOCKED UPRIGHT. OK TO CONTINUE PER MEL 25-10-01. SP-1B. FOUND MISSING SET SCREW INSTALLED NEW SET SCREW ADJUSTED, OPS CHECK GOOD. OKAY FOR SERVICE IAW CMM 25-21-45.SDR SWAA2025121144330Elec Connector · looseSIDEWALL LIGHTS ROW 15 -21 AIRCRAFT RIGHT INOPERATIVE. ROW 15 OVERWING EXIT IS WHERE POWER BREAK-IN IS LOCATED. SUSPECT THIS LIGHT ASSEMBLY OR LOOSE CONNECTION. OKAY TO CONTINUE PER MEL 33-2-04 SP1B. REMOVED AND REPLACED SIDE WALL LIGHT ROW 21 FED AND EMESDR SWAA2025121143815Sign · detachedOVERHEAD ISLE EXIT ROW SIGN PLACARD DETACHED. ATTACHED EMERGENCY EXIT SIGN TO OVERWING SIGN IAW SIP.SDR CALA2025121112019Slide · no discrepancyR1 DOOR SLIDE PROTRUDING OUT OF BOTTOM OF CASING. INSPECTED SLIDE PACK AT R1 DOOR. SLIDE PACK GIRT BAR AREA NORMAL, NO EXCESS MATERIAL, NO DEFECTS NOTED, IAW AMM 25-66-01-400-801.SDR CALA2025121012018Sensor · out of adjustREPORTING INTERMITTENT MMSG 52-71003, PSEU AFT SERVICE DOOR SWITCH SENSOR IS TARGET FAR IN AIR. REQUEST MAINTENANCE IAW FIM TASK 52-10-00-810-802, ADJUSTED AFT DOOR S200 INDICATION SENSOR IAW AMM 52-71-11-820-801, OPS CHECKED GOOD. NO FUTHER DEFECTS NOTED.SDR SWAA2025121043821Megaphone · no discrepancyMEGAPHONE IN AFT GALLEY INOPERATIVE. MEGAPHONE OPS CHECK GOOD IAW AMM 25-64-00SDR SWAA2025121043648Flashlight · no testFA FWD FLASHLIGHT WILL NOT TEST. RESEATED FWD FA EMERGENCY FLASHLIGHT IAW AMM 25-64-00. OPS CHECKED GOOD.SDR SWAA2025121043579Fastener · missingDOOR SLIDE COVER GIRT BAR RETAINER CLIP MISSING FASTENERS. INSTALLED NEW FASTENERS IAW SRM 51-40-02.SDR DALA2025121009038Landing Gear · faultedATB - DUE TO LOUD BANG AND "GEAR DISAGREE" AND "WOW FAIL" MESSAGES. SWITCHED TO SECONDARY NOSE LANDING GEAR STRUT SEALS, PERFORMED GEAR SWING TEST. OK FOR SERVICE. (LP# 7889415)SDR DALA2025121009031Strap · crackedCRACK IN LOWER SUPPORT STRAP OF THE FLIGHT DECK FLOORBEAM OTBD OF THE LT NOSE W/W WALL STA 365.2 THRU STA 377.7. REPAIRED PER B757 SRM 53-00-51-2R REPAIR 12. (1340474)SDR DALA2025121009029Sign · detachedEXIT SIGN AT 2R FELL OFF. REATTACHED SIGN. (8215257)SDR DALA2025121009021Line · out of positionWHILE COMPARING DOOR 4R MODE SELECTOR LEVER TO DOOR 4L FOUND 4L SELECTOR LEVER NOT COMPLELY ARMING. UPON INSPECTION OF THE GIRT BAR, FOUND THE MOORING LINE CLIP SITTING UNDER THE BAR RETURNED IT BACK INTO THE SLIDE PACKDOOR SLIDE ARMED AND DISARMED W/NO ISSUSDR DALA2025121009015Sensor · out of adjustATB, PERFORMED AN AIR TURN BACK DUE TO LEFT AND RIGHT MAIN GEAR UNSAFE LIGHTS. COMPLIED WITH NO GO MSI LOG, ADJUSTED LEFT DOOR ACTUATOR TO WITHIN LIMITS, ADJUSTED RIGHT GEAR DOOR UP AND LATCHED SENSOR TO WITHIN LIMITS AND REPLACED THE S1-89 LANDING GEAR HANSDR DALA2025121009010Relay · faultedEMERGENCY LIGHTS FLICKER ON AND OFF DURING FLGHT. REMOVED AND REPLACED RELAY R2-5133 PER B717 WDM 24-51-01. (8071400)SDR IXXA202512107083Proximity Switch · inoperative"EMER DOOR" DESCRETE LIGHT COMES ON OCCASIONALY IN FLIGHT. NO EICAS MESSAGE DISPLAYED. PLACED ON DEFERRAL 68621 MINIMUM EQUIPMENT LIST ATI-52-71-01-01 CATEGORY C. DUE 18 DECEMBER 2025. SUPPLEMENTAL TO PREVIOUS REPORT IXXA20251207083 DATED 12/07/2025 AT KILN. ASDR AALA202512105528Hydraulic Line · brokenAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED INTO DEN DUE TO THE FLIGHT CREW REPORTING THAT DURING LEVEL OFF AT FLIGHT LEVEL 240 THE ECAM MESSAGES FOR YELLOW HYDRAULIC SYSTEM LOW LEVEL AND LOW PRESSURE ILLUMINATED. THE YELLOW HYDRAULIC SYSTEM LEVEL READ ZESDR CALA2025121011976Floor Support · corrodedMAIN CABIN FLOOR SUPPORT CORRODED ON UPPER SURFACE FLANGE, BS 962, RBL 11. REMOVED AND REPLACED THE FLOOR SUPPORT IAW SRM 51-40-02 AND DWG 147A5760 REV -.SDR AALA202512091977Skin Panel · delaminatedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER UPPER SKIN PANEL DELAMINATED BETWEEN FRONT SPAR STA 177.9 AND 228.526. REPAIRED PANEL PER SRM 51-70-00.SDR SWAA2025120943661Fuse · faultyON TAKE OFF LT MAIN GEAR INDICATIONS DID NOT GO OUT. WITH HANDLE IN UP RED LEFT GEAR LIGHTS STAYED ILLUMINATED. WITH HANDLE IN OFF RED AND GREEN LEFT GEAR LIGHTS STAYED ILLUMINATED. OK TO CONTINUE PER [MEL 32-16-01. REMOVED AND REPLACED LMLG RETRACT PRESSURSDR SWAA2025120944308Actuator · faultedON TAKE OFF LEFT MAIN GEAR INDICATIONS DID NOT GO OUT. WITH HANDLE IN UP RED LEFT GEAR LIGHTS STAYED ILLUMINATED. WITH HANDLE IN OFF RED & GREEN LEFT GEAR LIGHTS STAYED ILLUMINATED. OK TO CONTINUE IAW [MEL 32-16-01. REMOVED AND REPLACED LMLG RETRACT PRESSURSDR AALA202512098118Battery · no testAIRCRAFT WAS NOT GROUNDED: L1 FLIGHT ATTENDANT FLASHLIGHTS FAILED TEST. REMOVED AND REPLACED FLASHLIGHTS BATTERIES. PER AMM 25-64-00.SDR AALA202512092371Power Supply · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHTS DO NOT COME ON DURING TEST FROM ROW 19ABC THRU 25ABC. REMOVED AND REPLACED BATTERY POWER PACK AT ROW 23ABC. PER AMM 33-51-06.SDR AALA202512090538Light · inoperativeAIRCRAFT WAS NOT GROUNDED: RIGHT HAND AFT SLIDE ILLUMINATION LIGHT INOPERATIVE. RELAMPED RIGHT HAND AFT SLIDE ILLUMINATION LIGHT. PER AMM 33-51-04.SDR DALA2025120908980Oxygen Mask · no testCAPT O2 MASK DOES NOT TEST PROPERLY ( LEAK TEST FUNCTION). DFR PER MEL 25- 011-06C O2 BOX WILL NOT TEST. PLACARD INSTRALLED CONTACTED MCC OK FOR SVC. SWAPPED CAPT. O2 MASK WITH OBSERVER SEAT O2 MASK, OK TO CONT. ON DEFERRAL. REINSTALLED OBSVRS O2 MASK TO ORIGSDR IXXA2025120907083Light · false activationEMERGENCY DOOR DESCRETE LIGHT COMES ON OCCASIONALY IN FLIGHT. NO EICAS MESSAGE DISPLAYED. PLACED ON DEFERRAL 68621 MINIMUM EQUIPMENT LIST ATI-52-71-01-01 CATEGORY C.