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 DALA2025103007956Transmission · faultedUFC/DE- DECLARED EMERGENCY DUE TO TE FLAP ASYMMETRY. REPLACED NBR 2 FLAP TRANSMISSION, WFFA AND WFFB CONTROL CABLES. PERFORMED CONTROL CABLE TENSION, SAFETY, AND ADJUSTED FLAP. (LP 1268322, 1279340, 1279914)SDR AALA202510303149Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY DOOR STUCK HALF OPEN AGAIN. AFT LEFT LAVATORY DOOR IS OFF ITS TRACK AND INOPERATIVE, THE TRACK IS BENT. FOUND DOOR OUT OF TRACK, READJUSTED DOOR AND PERFORMED OPERATIONAL TEST. PER AMM 25-40-15. OPERATIONAL CHECK GOOD.SDR AALA202510300032Placard · missingAIRCRAFT IN BASE MAINTENANCE: FORWARD PASSENGER / CREW DOOR 841 GIRT BAR IS MISSING THE ORANGE PLACARD. INSTALLED NEW ORANGE PLACARD ON THE GIRT BAR PER AMM 11-00-00.SDR AALA202510307113Placard · missingAIRCRAFT IN BASE MAINTENANCE: LEFT HAND FORWARD PASSENGER / CREW DOOR GIRT BAR MISSING ORANGE PLACARD. INSTALLED ORANGE PLACARD ON THE GIRT BAR PER AMM 11-00-00.SDR AALA202510304159Pin · corrodedAIRCRAFT IN BASE MAINTENANCE: PITTING FOUND ON LEFT HAND ENGINE AFT MOUNT CENTER INBOARD PIN. REPLACED PIN PER AMM 71-22-11.SDR AALA202510300959Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #5 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202510308406Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #1 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202510304896Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #3 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202510304265Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #6 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202510303493Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #2 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202510300382Indication Sys · malfunctionedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS NO DECLARED DUE TO: HYDRAULIC SYSTEM-A DECREASED DURING FLIGHT. AIRCRAFT DIVERTED TO AND LANDED SAFELY AT MIA. ACCOMPLISHED GVI OF AIRCRAFT FLIGHT SURFACES FOR LEAKS AND OPERATIONAL CHECKS, NO LEAKS NOTED. PERFORMED OPERSDR CALA2025102910702Stringer · crackedCRACKED STRINGER 27R, BS 540, AFT OF FWD CARGO. ACCOMPLISHED INSTALLATION OF ALL REPAIR PART AND COMMON TO REPAIR AT STR 27, BS 540 AFT OF FWD CARGO IAW SRM 51-40-02 AND ECRA 5330-07630SDR ASAA2025102461862Placard · detachedEXIT PLACARD FOR L1 DOOR NEXT TO FLASHLIGHT POPPED OFF. GROUNDED - YES. RESECURED EXIT PLACARD BACK TO WALL.SDR SWAA2025102827954Flashlight · not seatedAFT GALLEY FLASHLIGHT TEST LIGHT INOPERATIVE. REMOVED AND SEATED AFT GALLEY FLASHLIGHT IAW AMM 25-64-00. OPS CHECKED GOOD.SDR SWAA2025102827951Slide · dislodgedSLIDE FELL OUT WHEN OPENING L1 DOOR. REMOVED AND REPLACED FWD ENTRY DOOR ESCAPE SLIDE IAW AMM 25-66-01.SDR SWAA2025102828365Girt Bar · jammedFWD SERVICE DOOR GIRT BAR JAMMED. FREED THE GIRT BAR FROM SLIDE COVER RETAINER IAW MM 25-66-02, OPS NORMAL.SDR SWAA2025102828387Slide · dislodgedL1 DOOR SLIDE FELL OUT OF CONTAINER. SECURED THE ESCAPE SLIDE PACK AND COVER IAW AMM 25-66-01. ACFT OK FOR SERVICE.SDR SWAA2025102828110Flashlight · no testTHREE EMERGENCY FLIGHT ATTENDANT AFT FLASHLIGHTS WILL NOT TEST. OKAY TO CONTINUE PER MEL 25-64-02A. SP1B. REMOVED AND REPLACED THE FLASHLIGHTS IAW AMM 25-64-00. OPS CHECKED GOOD.SDR SWAA2025102829373Flashlight · no testTHREE EMERGENCY FLIGHT ATTENDANT AFT FLASHLIGHTS WILL NOT TEST. OKAY TO CONTINUE PER MEL 25-64-02A, SP1B. REMOVED AND REPLACED THE FLASHLIGHTS IAW AMM 25-64-00. OPS CHECKED GOOD.SDR SWAA2025102829374Flashlight · no testTHREE EMERGENCY FLIGHT ATTENDANT AFT FLASHLIGHTS WILL NOT TEST. OKAY TO CONTINUE IAW MEL 25-64-02A, SP1B. REMOVED AND REPLACED THE THREE EMERGENCY FLASHLIGHTS IAW AMM 25-64-00. OPS CHECKED GOOD.SDR SWAA2025102827706Seal · crackedRIGHT HORIZONTAL STABILIZER UPPER FORWARD SLIDER CRACKED. R & R RT HORIZONTAL STAB UPPER FWD SLIDING SEAL IAW AMM 53-31-31.SDR SWAA2025102828377Flashlight · no testFLIGHT ATTENDANT REPORTS FWD OUTBOARD FLASHLIGHT WILL NOT TEST. R & R FLASHLIGHT ASSY IAW AMM 25-64-00.SDR SWAA2025102828386Battery · no testLEFT SIDE AFT CABIN FLASHLIGHT WILL NOT TEST AND SEALS BROKEN. R & R LEFT EMERGENCY FLASHLIGHT BATTERY & SEAL IAW AMM 25-64-00. OPS CHECK GOOD. THIS CLEARS MEL 25-64-02A.SDR IPXA2025102829407Flap · damagedBIRD STRIKE DAMAGE TO RIGHT WING OUTBOARD FLAP LEADING EDGE. COMPLETED REPAIR TO LEADING EDGE PANEL PER SRM 51-70-05-0G-0 ALL STEPS OF REPAIR COMPLETE. REPAIR PLIES INSTALLED AND CURED. REAPPLIED PROTECTIVE COATINGS AND PERFORM POST REPAIR REQUIREMENTS. INSTASDR DALA2025102807905Battery · inoperative(LOG 7659171) IB SVC FOUND LT FWD CEILING EMER LIGHTS AND FWD WIND EMER LIGHT INOP. CEILING EMER LIGHTS OVER ROWS 3, 11, 15 AND EXTERIOR LH LIGHT FWD WING EXITS. R AND R M2335 BATTERY IN REF TO B737 AMM 33-51-06. OPS CKS GOOD AT THIS TIME.SDR DALA2025102807904Battery Pack · inoperative(LOG 7659170) ON SVC FOUND EMERGENCY EXIT SIGN OVER WING EXIT AFT AND OUTSIDED LIGHT AFT EXIT INOP LH SIDE. REMOVED AND REPLACED BATTERY M1670 REF B737 AMM 33-51-06. OPS CHECKED GOOD.SDR AALA202510287446Power Supply · faultedAIRCRAFT IN BASE MAINTENANCE: ON FAP PANEL ESPU EXT LOAD AFT L AND ESPU INT LOAD AFT L FAULT FOUND. MAINTENANCE REPLACED EPSU.SDR AALA202510288378Power Supply · faultedAIRCRAFT IN BASE MAINTENANCE: ON FAP PANEL ESPU EXT LOAD AFT L AND ESPU INT LOAD AFT L FAULT FOUND. MAINTENANCE REPLACED EPSU.SDR AALA202510283355Slide Raft · faultyAIRCRAFT IN BASE MAINTENANCE: ON FAP PANEL ESPU EXT LOAD AFT L AND ESPU INT LOAD AFT L FAULT FOUND. MAINTENANCE REPLACED L2 SLIDE IAW JOBCARD 26L00025011.SDR AALA202510284581Slide Raft · faultyAIRCRAFT IN BASE MAINTENANCE: ON FAP PANEL ESPU EXT LOAD AFT L AND ESPU INT LOAD AFT L FAULT FOUND. MAINTENANCE REPLACED R2 SLIDE IAW JOB CARD 26L00025011.SDR CALA2025102810675Window Frame · crackedON THE R3 WINDOW FRAME E-F CRACK REPAIR, ACCOMPLISH INSPECTION REQUIREMENTS PER PART 2 OF EC/RA 5311-03408 ON OR BEFORE 24 OCT 2027. WHILE PERFORMING EA 5310-08195 OP 002 ON R3 WINDOW FRAME, CRACK FOUND ON 3RD LOWER HOLE, REPAIR OF WINDOW FRAME ACCOMPLISHED PSDR CALA2025102810641Channel · corrodedFOUND CORROSION FWD CARGO COMPARTMENTFLOOR SUPPORT Z CHANNEL S-26L STA 500AD TO 500I. INSTALLED FWD CARGO NEW Z CHANNEL S-26L STA 500A+10" TO 500I IAW B737 SRM 51-40-02 AND DGW 143A7500 & 143A7505. REMOVED AND REPLACED FWD CARGO Z CHANNEL S-26L STA 500A+10" SDR CALA2025102810639Channel · corrodedFWD CARGO COMPARTMENT LH Z CHANNEL BTW STA. 500A AND 500I HAS CORROSION NEEDS REPLACEMENT. ALL WORK CAPTURED ON AAR RFD N/R 1000057627. CORRECTION ATA UPDATED TO REFLECT DISCREPANCY REPAIRED. REMOVED AND REPLACED FWD CARGO COMPARTMENT FWD CARGO COMPARTMENT LSDR CALA2025102810628Battery · dischargedEMERGENCY LIGHT BATTERY AT M1672 AND M1695 ARE DEAD REPLACED BOTH BATTERIES IN REF TO AMM 33-51-06-960-805. OPS CHECK GOOD. EMERGENCY LIGHTS NOT A RII OR IDT INSPECTION ITEM. BATTERY RPLD.SDR CALA2025102810619Warning Message · false activationDOOR FLIGHT LOCK 2L EICAS STATUS #2 LEFT PASSENGER ENTRY DOOR FLIGHT LOCK COMMAND/FLT LK RLY/SENS OR DISAGREEMENT. FIM TASK REF : FIM TASK REFERENCE NOT FOUND. MSG NOT ACTIVE. OPS CHECKED DOOR 2L, DOOR CHECK OK. REF FIM 52-11 TASK 805. STEP F (1) (A). MESG CLSDR CALA2025102810618Bracket · looseDOOR 1R GIRT BAR BRACKET LOOSE. PERFORMED INSPECTION AND OPS CHECK OF GIRT BAR LEAF SPRING NO DEFECTS NOTED. HARDWARE IS SECURE AND LEAF SPRING HOLD GIRT BAR SECURE REF AMM 25-66-10.SDR YENA2025102801060Apu · odorFLT#1233, MCO-SJU. "DURING CLIMB AND CRUISE INFLIGHT CREW REPORTED STRONG ODOR/SMELL OF STINKY CHEESE/DIRTY SOCKS . REPORT FROM FWD GALLEY TO ROW 4. MODERATE INTENSITY LEVEL2. FOM POLICY COMPLIED WITH AND CALLS TO DISPATCH AND MX. IRRITATING NOSE SMELLS; ACCOMSDR RU3A2025102800001Brake · overtempDURING ROLLOUT INSPECTION, CREW RETURNED TO GATE DUE TO AIRCRAFT'S BRAKES BECAME EXCESSIVELY HOT PRODUCING VISIBLE SMOKE. FIRE TRUCKS WERE ROLLED OUT AND SPRAYED THE HOT BRAKES DOWN; AIRCRAFT WAS EVACUATED AND TOWED BACK TO THE GATE. CREW EVACUATED THROUGH THESDR HALA20251027329Fmu · faultedETOPS - ENG 2 LP SHAFT PROT LOSS ECAM AFTER LANDING. REMOVED AND REPLACED NR 2 ENG FMU W/ REF TO AMM 73-21-52 UP TO AND INCLUDING STEP 5.E.PERFORMED REMAINING STEPS. NO LEAKS NOTED. OK FOR SVC.SDR SWAA2025102728097Air Filter · odorON ROTATION BURNING SMELL IN COCKPIT AND CABIN; SMELL DISSIPATED IN COCKPIT BUT REMAINED IN CABIN ALL ENGINE INDICATIONS NORMAL. SMELL RETURNED IN CABIN ON APPROACH. PER AMM 05-51-56-201-MAX (SMOKE OR FUMES IN CABIN - MAINTENANCE PRACTICES (CONDITIONAL INSPESDR SWAA2025102728368Actuator · faultyAFTER TAKEOFF; RIGHT GEAR TRANSIT LIGHT WOULD NOT EXTINGUISH. OK TO CONT PER MEL 32-30-01. SP1. MDDR# 290073. GEAR PINS REMAIN INSTALLED PER MEL. PIN FLAGS REMOVED AND SAFETIED. REMOVED AND REPLACED RT MAIN GEAR DOWNLOCK ACTUATOR IAW AMM 32-32-51. LEAK CHECSDR SWAA2025102728361Rivet · missingFWD GALLEY SERVICE DOOR SLIDE AFT GIRT BAR RETAINER MISSING 1 RIVET. INSTALLED INTERIM REPAIR PER E.A. M-23-125-01839.SDR SWI2025F01462Elevator System · splitELEVATOR SPLIT CAUTION MESSAGE AT CRUISE. (FLIGHT 4995 - FILED CLOSED)TROUBLESHOT ELEVATOR SPLIT CAUTION IN REFERENCE TO FIM 27-31-00. UPON ARRIVAL, NO MESSAGES WERE PRESENT. PERFORMED OPS CHECK OF THE ELEVATOR CONTROL SYSTEM IN REFERENCE TO AMM 27-31-00. FSDR SWIA2025102700024Frame · dentedCOMPLY WITH REO 601R-53-11-4030 (LATEST REVISION) TEMPORARY REPAIR FOR DENT DAMAGE TO FRAME WEB AT FS 241.60 AND BETWEEN RBL 5.50 €“ RBL 11.16. (FILED OPEN)SDR WX0A2025102732615Battery Pack · no test(AIRCRAFT NOT GROUNDED) OPERATIONAL TEST OF EMERGENCY LIGHT RESULT SHOW EPSL 13WL BATT FAULT / REMOVED AND REPLACED EPSU REF WO528678"SDR WX0A2025102732611Unknown · odor(AIRCRAFT NOT GROUNDED) CHEMICAL / DIRTY SOCK ODOR REPORTED ROWS 23 TO AFT GALLEY. COMPLIED WITH QRH. ODOR DISSIPATED WITH PACK 2 OFF BUT RETURNED DURING DESCENT THEN DISSIPATED AGAIN. SMOKE / ODER REPORT COMPLETED / PERFORMED LEVEL 2 IAW TASK CARD 21-000-0SDR AALA202510273149Door · off trackAIRCRAFT WAS NOT GROUNDED: LAVATORY DOOR STUCK HALF OPEN AGAIN. AFT LEFT LAVATORY DOOR IS OFF ITS TRACK AND INOPERATIVE, THE TRACK IS BENT. (OPEN).SDR AALA202510276786Door · off trackAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR OFF RAIL AND STUCK. REINSTALLED AFTER LEFT DOOR ON RAIL. OPERATIONAL CHECKED GOOD.SDR AALA202510270012Light · dislodgedAIRCRAFT WAS NOT GROUNDED: EMERGENCY PATH LIGHTING MODULE AT SEAT 20C DISLODGED AND ON FLOOR. REPLACED EMERGENCY LIGHT ASSEMBLY AT 20C. PER AMM 33-51-11.SDR AALA202510276823Light · dislodgedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT AT SEAT 26C FELL OFF. REINSTALLED EMERGENCY EXIT LIGHT AT 26C. OPERATIONAL CHECK GOOD. PER AMM 33-51-00.