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 CALA2025120111617Window Frame · dentedEVALUATE DAMAGE ON WINDOW FRAME AND CROWN SKIN BTW STA 200 AND RBL 3". ESFR SUBMISSION C/W FOR REPAIR SKIN, ALL WORK CAPTURED ON AAR N/R 1000062455. UPDATED ESFR F/O SIDE WINDOW FORGING REPAIR C/W UPDATED FOR 3 TOTAL ITEMS. SKIN, INTERNAL DBLR, AND WINDOW FOSDR CALA2025120111615Floor Support · corrodedCORROSION FWD WET AREA PANEL BREAK AROUND NUT PLATE FASTENERS BETWEEN BS 294.5 AND 312 AT RBL 10. INATALLED SUPPORT PANEL BREAK AT FWD WET AREA BETWEEN STA 294.5 TO STA 312 RBL 10 IAW REF. SRM 51-40-02-0G-0 DWG # 141A5400.SDR CALA2025120111611Angle · crackedLEFT WING WEB ALONG DEFLECTION CONTROL RIB POSSIBLE CRACK. REMOVED AND REPLACED AT LEFT WING ANGLE WEB ALONG DEFLECTION CONTROL RIB IAW SRM 51-40-02-0G-0, SRM 51-40-05-0G-0, SRM 51-20-01-0G-0, AMM 51-21--41-370-802, AND IPC 57-50-00-36A.SDR CALA2025113011594Slide · wornDOOR 1L SLIDE GIRT WEBBING MATERIAL IS WORN. PART IN AREA OF DOOR 1L, SLIDE, SLIDE REPLACEMENT IS A RII ITEM PER GMM 09-25-05 REMOVED AND REPLACED L1 SLIDE IN REF AMM 25-66-01. VERIFIED DOOR 1 L REPLACEMENT SLIDE IS CORRECT PER IPC, SAFETYPIN REMOVED & STOWED SDR CALA2025113011593Slide · no discrepancyDOOR 2L EXCESS SLIDE PACK STICKING OUT NEAR GIRT BAR. INSPECTED SLIDE PACK AT DOOR 2L SLIDE PACK GIRT BAR AREA WAS NORMAL NO EXCESS MATERIAL NO DEFECTS NOTED.SDR CALA2025113011586Light · inoperativeOVERHEAD EMERGENCY LIGHT INOP AT ROW 28FED. REMOVE AND REPLACED OVERHEAD EMERGENCY LIGHT AT ROW 28FED PER AMM 33-51-03.SDR HNAA2025120100828Closet · contaminatedODOR EMINATING FROM G1 CREW CLOSET BOTTOM AND GALLEY AREA. INSPECTED G1 CREW CLOSET AREA FOUND 2 PLASTIC BAGS WITH DRIED LIQUID RESIDUE. CLEANED AND SANITIZED THE AREA AS REQUIRED. A/C OK FOR SERVICE.SDR HNAA2025120100727Bleed Valve · faultedBLD 2 VLV FAIL DURING T/O ROLL. R & R #2 BLEED VALVE IRW AMM 36-11-05. OPS CHECK GOOD. NO LEAKS NOTED. A/C OK FOR SERVICE4 AT THIS TIMESDR DALA2025120108755Fseu · inoperativeRETURNED TO LAX DUE TO FLAP LOCKOUT DURING RETRACTION. MTC REPLACED FSEU, LEFT AND RIGHT FLAP POSITION SENSORS PER AMM 27-51 AND 27-58.SDR DALA2025120108753Sign · missingEMERGENCY EXIT SIGN MISSING BY ROW 21. REPLACED EMERGENCY EXIT SIGN IAW B737 AMM 33-51. OK FOR SVC.SDR DALA2025120108747Oil System · leakingON FINAL APPROACH - APPROX 7 MINS UNTIL TOUCHDOWN THE FA SMELLED 'DIRTY SOCK' IN AFT CABIN - FA WALKED FWD AND STATED SMELL STRONGER. SMELL WENT AWAY AT TOUCHDOWN. FOUND APU GENERATOR LEAKING, REPLACED APU GENERATOR DRAIN PLUG SEAL. (LP 6581076, 6581079)SDR AALA202512017826Sensor · out of adjustAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AFTER TAKEOFF AND GEAR HANDLE SELECTED UP, WE HAD A GEAR DISAGREE. AIRCRAFT DIVERTED TO AND LANDED SAFELY AT PHX. REMOVED AND REPLACED DMAGED SENSOR S0085 (AALA202512013139), PER AMM 32-61-41. ADDITIONALSDR AALA202512016724Sensor · out of adjustAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AFTER TAKEOFF AND GEAR HANDLE SELECTED UP, WE HAD A GEAR DISAGREE. AIRCRAFT DIVERTED TO AND LANDED SAFELY AT PHX. REMOVED AND REPLACED DMAGED SENSOR S0085 (AALA202512013139), PER AMM 32-61-41. ADDITIONALSDR AALA202512013139Sensor · damagedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AFTER TAKEOFF AND GEAR HANDLE SELECTED UP, WE HAD A GEAR DISAGREE. AIRCRAFT DIVERTED TO AND LANDED SAFELY AT PHX. REMOVED AND REPLACED DMAGED SENSOR S0085 (AALA202512013139), IAW AMM 32-61-41. ADDITIONALSDR AALA202512017733Generator · failedAIRCRAFT WAS GROUNDED: AIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: RIGHT GENERATOR FAILURE FOLLOWED BY EXCESSIVE RIGHT ENGINE VIBRATION. AIRCRAFT DIVERTED TO AND LANDED SAFELY AT BZE. FOUND EXCESSIVE ENGINE DAMAGE DUE TO BLADE PLATFORM LIBERATION.SDR DALA2025120108743Seal · fodUNABLE TO ARM 3L DOOR DURING ALL CALL FOR DEPARTURE ARMING LEVER IS JAMMED AND UNABLE TO SLIDE TO ARM. REMOVED DEBRIS FROM DOOR SEAL CHKS NML DOOR ARMS. (7788600)SDR REXA2025120100995Fitting · damagedFOUND RT AILERON WING SIDE NR 2 LUG OB BORE TO BE PREVIOUSLY OVERSIZED. REPAIRED R/H AILERON WING SIDE NR 2 LUG OUTBD BORE IAW MHI REO 690-57-51-489 DATED 2025-11-15 REV A.SDR AALA202512012602Skin · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO LOWER FUSELAGE SKIN UNDER LAVATORY SERVICE PAN LOCATED FROM BS 865 TO BS 867, AT S22L. REPAIRED SKIN PER EA 369821.SDR DALA2025113008734Frame · crackedCRACK INDICATION FOUND ON INNER CAP FR 68 LH SIDE, CRACK LENGHT = 1.0 INCH APPROX. REQUESTING REPAIR DISPOSITION ADITIONAL EGINEERING DOCUME NTATION IS REQUIRED AND REPAIR MUST BE ACCOMPLISHED PRIOR TO FURTHER F LIGHT REFER TO EM 5311-01244 AND SB A320-531491.SDR DALA2025113008733Frame · crackedCRACK INDICATION FOUND ON INNER CAP FR 68 RH SIDE AREA, CRACK LENGHT: 1.5 INCH, REQUESTING REPAIR DISPOSITION ADITIONAL EGINEERING DOCUMENTA TION IS REQUIRED AND REPAIR MUST BE ACCOMPLISHED PRIOR TO FURTHER FLIG HT REFER TO EM 5311-01244 AND SB A320-531491. CSDR AALA202511285018Sign · detachedAIRCRAFT WAS NOT GROUNDED: MID EXIT SIGN DETACHED. SECURED MID EXIT SIGN ASSEMBLY AT AISLE 17. PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA202511283255Light · unsecureAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT ASSEMBLY LOSSE AT SEAT 10C. SECURED EMERGENCY EXIT LIGHT ASSEMBLY AT SEAT 10C. PER AMM 33-51-11.SDR AALA202511282020Trim Panel · looseAIRCRAFT WAS NOT GROUNDED: EXIT ROW SEAT TRIM LOOSE 16C. (OPEN).SDR AALA202511280393Light · inoperativeAIRCRAFT WAS NOT GROUNDED: EXIT ROW FLOOR LIGHTING AT SEAT 16C INOPERATIVE. RESECURED EMERGENCY LIGHT AT SEAT 16C. OPERATIONAL CHECKED GOOD.SDR AALA202511284502Bulb · inoperativeAIRCRAFT IN BASE MAINTENANCE: G6 (SECOND TO AFT GALLEY) OVERHEAD EMERGENCY LIGHT INOP. RELAMPED EMERGENCY LIGHT ABOVE GALLEY (DOOR 4) IAW AMM 33-51-03.SDR N6WA2025112805Seat Track · corrodedCORROSION ON LH SIDE SEAT RAIL AT FS785.15-FS847. REMOVED AND REPLACED LH SIDE SEAT RAIL AT FS785.15-FS847 IAW REO-670-53-00-589SDR N6WA2025112804Skin · gougedGOUGE FOUND ON SKIN PANEL AT FS977 UNDER AFT FAIRING PANEL 195DL. PERFORMED REPAIR ON SKIN PANEL AT FS977 UNDER AFT FAIRING PANEL 195DL IAW GOJET EO-C550-53MR-110-OSDR N6WA2025112801Elec Connector · looseNW STERRING INOP AND CAUTION IN FLIGHT. INSPECTED NOSE WHEEL STEERING AND FOUND ELECTRICAL CONNECTOR LOOSE AND T-BOLT CLAMP STUD BROKEN. RECONNECTED CONNECTOR AND REPLACED T-BOLT CLAMP IAW AMM 32-52-01. OPS CHECK GOOD.SDR 2025F00276Wire · damagedDURING THE TAKEOFF ROLL, PRIOR TO REACHING 60 UNIDS THE RIGHT AFT TANK LOW PRESSURE LIGHT ILLUMINATED, THE TAKEOFF WAS DISCONTINUE. IAW SWPM 20-10-13 PAG 7-10 THE ELECTRICAL WIRE W518-301-18B WAS REPAIRED REFLECTED IN WDM 28-23-01 PAG 509-514 FUEL BOOST PUMPSDR 2025FA0000789Relay · unstableTHE AFT FUEL PUMP ON THE TANK #2 LOW PRESSURE LIGHT ILLUMINATED. IAW AMM 28-22-41 PAG 501-506 GROUND FAULT INTERRUPTER RELAY "20" RESET WAS PERFORMED.SDR DALA2025112808730Sign · detachedEMERGENCY EXIT SIGN FELL OFF. REPLACED MISSING LENS AT LOC 603. REF A330 AMM 33-51. OPS CKS GOOD. (LP 1323310)SDR SWI2025F01653Warning Message · illuminatedRECEIVED GEAR DISAGREE WARNING MESSAGE ON GEAR EXTENSION. GEAR SELECTOR LEVER IS LIMP. COMPLETED QRH - LANDED WITH OUT FURTHER ISSUE. DEFERRED PER MEL 32-30-1LOCATION: LANDING GEAR RETRACTION SYSTEMMAINTENANCE ACTION COMPLIED WITH ACCORDING TO MELCAT II DOWSDR SWI2025F01652Windshield · crackedCRACK IN RH WINDSHIELD DURING CLIMB. DESCENDED TO FL270 AND RAN QRH. (FLIGHT 4670) REMOVED AND REPLACED FO'S WINDSHIELD REFERENCING AMM 56€“11€“01. COMPLIED WITH COCKPIT WINDSHIELD / SIDE WINDOW INSTALLATION TASK CARD 56-220-1000-SKY. OPS CHECK GOOD, LEAKSDR SWIA2025112800006Buttstrap · corrodedCORROSION ON BUTTSTRAP AT FS280.00 BTW STR 25R - STR 23R (FILED OPEN)SDR FDEA202511262209Wire · brokenCOCKPIT EMERGENCY DOME LIGHT INOPERATIVE. RELAMPED NO HELP. DURING TROUBLESHOOTING, FOUND WIRE W0200-0009-22, BROKEN FROM RELAY R10381. RESOLDER SAME, LIGHT OPS CHECK NORMAL. DOME LIGHT ASSEMBLIES REQUIRE MOUNTING AND RE-OPS CHECK.SDR AALA202511281837Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: FLIGHT CREW REPORTED THAT A CABIN FLASHLIGHT AT THE R2 WAS NEEDED. MAINTENANCE REPLACED BATTERY FOR FLASHLIGHT AT THE R2 AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 25-60-00.SDR AALA202511288678Smoke Detector · false activationAIRCRAFT WAS NOT GROUNDED: FLIGHT CREW REPORTED WHILE CRUISING AT FL 330, RED UPPER ECAM LAVATORY SMOKE APPEARED FOR 5 SEC, PLUS AURAL, THEN MESSAGE CLEARED ITSELF. FLIGHT ATTENDANTS IDENTIFIED THE MID LEFT LAVATORY, AFTER PASSENGER USE. MAINTENANCE ACCOMPLISHSDR AALA202511285424Lever · looseAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS 2R DOOR ARMING LEVER IS LOOSE. MAINTENANCE ADJUSTED R2 EXIT DOOR ARMING LEVER AND ACCOMPLISHED A SATISFACTORY OPERATIONBAL CHECK PER AMM 52-22-22.SDR VNAA2025112811102Selector Valve · faultedGEAR DISAGREE WARNING W/ LOSS OF STEERING ON LANDING. /REMOVED AND REPLACED MLG SELECTOR VALVE ASSEMBLY IAW AMM 32-10-000/400-801-A01. BLED HYD SYSTEM 3 IAW AM 29-10-00-870-802-A01.SDR YENA2025112801126Valve · failedFLT#1416, SFO-JFK. (ETOPS) AIR ENG 1 BLEED FAULT ECAM WHEN WING ANTI ICE WAS SELECTED. BLEED FAULT RESET WITH WING ANT - ICE DESSELECT. WHEN WING ANTI-ICE WAS SELECTED AGAIN AIR ENG 1 BLEED FAULT REAPPEARED; REMOVED AND REPLACED ENG 1 FAN AIR VALVE IAW AMM 36SDR CALA2025112811569Oil Cap · openOIL QUANTITY INDICATED 30-34 PERCENT ON CLIMB OUT AND LEVEL OFFENG2 SN. 603861 (TSI= 8882 HRS / 2988 CYC). A/R CREW REPORTS: RT ENG OIL QTY 34%, LT 82, WAS NORMAL ON T-OFF ROLL & CLB OUT, TEMPS L91, R91, PRESS L67 R74., REPORT FINDINGS TO ESCPP & TOMC-EMC. USDR CALA2025112811568Unknown · unknownLOUD NOISE SOUNDED LIKE TIRE BLOWN AFTER TAKE OFF. ALTITUDE 600 FEET LANDING GEAR UP FLAPS 1 PERFORMED WAK AROUND , NO BIRD STRIKE , NO TAIL STRIKE , NO MISSING PANELS , WHEELWELL AREAS NORMAL , HYD SYSTEMS NORMAL , NO FLAT TIRES , NO BAD TIRES , FLT CONTROL OSDR CALA2025112811567Fuel Sys · malfunctionedFUEL DISAGREE PROG 2 FMC MSG. CALC FUEL DIFFRD TOTLZR BY 3.0. TOTLZR FUEL 3.2 LESS THAN FLT PL, ACP 34-61 FAULT TREE 845 NO FAULTS NOTED ACP. FUEL TOTAL ONBOARD IN FMC AND FUEL INDICTOR SAME.SDR CALA2025112811554Wire Harness · damagedDURING CABIN WALK THROUGH FOUND EMERGENCY AISLE LIGHTS IN FIRST CLASS INOP. REPLACED POWER SUPLY "BATTERY CHARGER" FOR FIRST CLASS SEAT PROXIMITY LIGHTS IAW AMM: 33-51-06. NO HELP. FURTHER TROUBLESHOTING FOUND "Y" HARNESS OF ROWS 3,4 & 5AB DAMAGED. HARNESS NESDR CALA2025112811552Battery · inoperativeDOOR 4L EMERGENCY POWER SUPPLY BATTERY FAILED TEST. BATTERY REPLACED IAW AMM 33-51-00. INSTALLATION TEST CARRIED OUT FO DOOR 4L EMERGENCY POWER SUPPLY BATTERY (M33406) AS PER AMM33-51-00, FOUND WORKING SATISFACTORY.SDR CALA2025112811550Fuel Sys · leakingLAX TOWER REPORTED FUEL LEAKING FROM #1 ENGINE LOCKED PER FLIGHT CREW DEBRIEF: ATC STATED THEY SAW FUEL POURING OUT OF LEFT ENGINE ON OUR DEPARTURE. NO OBVIOUS LEAK TO US BASED ON FUEL BURN, BALANCE AND TOTALIZER. FA DID NOT SEE ANYTHING. FO DID NOT SEE NOTHSDR CALA2025112811548Elt · malfunctionedELT REPORTED GOING OFF, REMOVED PORTABLE ELT FROM COMPARTMENT 707 AND FOUND RED BATTERY TAB STILL INSTALLED ON UNIT. CONFIRMED BATTERY TAB PREVENTED ELT FROM TESTING. SDR FILED. REMOVED BATTERY TAB AND REINSTALLED BATTERY ON ELT. OPS TEST GOOD. REINSTALLED INTSDR CALA2025112811542Lamp · inoperativeEMERGENCY LIGHTS OPERATIONAL CHECK - EEL AT ROW 24 IS INOPERATIVE. RELAMPED FLOOR PROXIMITY LIGHT FOR SEAT 24 IAW AMM 33-51-11-960-801. OPS CHECKED GOOD.SDR CALA2025112811541Light · damagedSEAT MOUNTED EMERGENCY LIGHT AT ROW 15ABC PUSHED IN. SWAPPED TO SEAT ROW 24ABC AND PLACED ON MEL 3319E. REMOVED AND REPLACED LAMP ASSY AT 24ABC, OPS CK OK, AMM 33-51-11, OK FOR SERVICE.SDR CALA2025112711531Filter · odorFLIGHT ATTENDS REPORT SMOKE IN COCKPIT. REPLACED 2 ABIN RECIRCULATION FILTERS. RAN PACKS FOR 20 MINUTES CHECKS OK.