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 DALA2025102807900Indicator · inoperativeSHIP 3360 DOOR 3L SLIDE PRES INDICATION INOP. CORRECTIVE ACTION: REPLACED TERMINAL BOX 308RH2 PER A330 AMM 23-73. OPS CHECK GOOD. (7929179)SDR YENA2025102801064Epsu · failedFLT#1761, LGA-PBI. "OVERWING EMER EXIT LIGHT NOT ILLUMINATING; MESSAGE "EPSU INT LOAD EMER R" ON CIDS 1 GRD SCAN. R/R 12WL EPSU AND BATT IAW AMM 33-51-38. EMER BATT TEST NOW OK BUT LOWER O/W EMER EXIT LTS STILL DON'T WORK. T/S TO CONT."SDR AALA202510282271Power Supply · no testAIRCRAFT WAS NOT GROUNDED: DURING EPSU TEST FOUND FAULT MESSAGE EPSU COMM EMER. MAINTENANCE REPLACED EMERGENCY POWER SUPPLY BATTERY PACK PER AMM 33-51-38. OPS CHK GOOD.SDR VNAA2025102811101Windshield · arcedFO WINDSHIELD ARCED / REMOVED AND REPLACED THE COPILOT SIDE WINDSHIELD IAW AMM 56-11-01-000/400-801-A01-PSA. OPS CK AND LEAK CK GOOD IAW AMM 30-41-06-710-801-A01 AND AMM 21-31-00-910-801-A02-PSA RESPECTIVELY.SDR CALA2025102810670Adm · faultyFLAP FAIL AT 25 AND FLAP OVERSPEED 210 KTS DUE TO WINDSHEAR PERFORMED PHASE 1 INSPECTION OF FLAP SYS IAW AMM 05-51-08. NO ISSUES FOUND DURING INSP. PERFORMED BITE OF FSEU & FOUND FAULT CODE 27-51351 FROM INBOUND LEG. T/S IAW FIM 27-51 TASK 830 THRU STEP D.(8).SDR CALA2025102810656Light · inoperativeTHE FWD OF GENERAL ILLUMINATION LIGHT(L3351503) FOUND NOT ON DURING TEST ABOVE SEAT 31F - REPLACED THE FWD OF GENERAL ILLUMINATION LIGHT(L3351503) ABOVE SEAT 31F, PERFORMED TEST AND THEN FOUND RESULT NORMAL, AS PER AMM 33-51-05-00A-520A-A & AMM 33-51-05-00A-7SDR CALA2025102810654Light · inoperativeTHE DOOR VIEWING LIGHT FOUND NOT ON DURING TEST AT R/H DR #3 - REPLACED THE DOOR VIEWING LIGHT AT R/H DR #3 AND TEST FOUND RESULT 'NORMAL', AS PER AMM 33-49-03-01A-520A/720A-A REV 201.SDR CALA2025102810652Light · inoperativeTHE DOOR VIEWING LIGHT FOUND NOT ON DURING TEST AT L/H DR #3 - REPLACED THE DOOR VIEWING LIGHT AT L/H DOOR #3 AND TEST FOUND RESULT 'NORMAL', AS PER AMM 33-49-03-01A-520A/720A-A REV 201. SSDR CALA2025102810650Floor Support · corrodedFOUND CORROSION AT AFT WET AREA FLOOR SUPPORT WEB ATTACHED ANGLE LBL 33 STA 992.8. INSTALLED NEW FLOOR SUPPORT ATTACH ANGLE AT STA 992.8 TO STA 1016 LBL 33. REF SRM 51-40-02-0G-0 AND DWG #147A5700. REMOVED AND INSTALLED NEW FLOOR SUPPORT ATTACH ANGLE AT STASDR CALA2025102810648Light · brokenSEAT 15C ON THE AISLE SIDE HAS A COVER TRIM PIECE MISSING WITH W IRE HANGING OUT UPDATE ADDING IMAGE PIC UPDATE REPLACEMENT LIGHT ASSEMBLY IS ATTACHED TO THE HARDNESS. NEED BUMPER INSTALL FIRST SEE LOG PAGE 6747943 INSTALLED EPL BUMPER ASSY AND LIGHT ASSY REF SDR CALA2025102810646Floor Support · corrodedFOUND CORROSION @ AFT WET AREA FLOOR SUPPORT WEB ATTACHED ANGLE RBL 33 STA 992.8 (REF AAR NR 99970715) INSTALLED NEW FLOOR SUPPORT ATTACH ANGLE AT STA 922.8 TO STA 1016 RBL 33 AS PERF B737-800 SRM 51-40-02-0G-0 AND DWG# 147A5700. REMOVED AND INSTALLED NEW FSDR CALA2025102810634Filter · odorFUEL SMELL STILL DETECTABLE IN THE CABIN. REMOVED AND REPLACED BOTH RECIRCULATION FILTER CARTRIDGE PER AMM 21-21-41-400-001-A OPS TEST NORMAL, NO FUEL SMELL A THIS TIME, OK FOR SERVICE.PARTS USED: 31-2121-3-0008, QTY :1 ADD EMP: U114389SDR CALA2025102810631Battery · no testEPSU BATTERY FWD L INDICATION AFTER EMERGENCY LIGHT TEST PARTS NIS AT BNA PARTS UPDATED REMOVED AND REPLACED FWD LEFT EPSU BATTERY PER AMM 33-51-38. OPS CHECK GOOD. TEST OK. PARTS USED: 18-3351-3-0001, QTY :1SDR CALA2025102810630Light · no discrepancyEMERGENCY LIGHTS - OPERATIONAL TEST WITH THE TEST SWITCH PROCEDURE - EMERGENCY LIGHT INOP ABOVE SEAT 3DEF/ 4DEF. REPLACED LIGHT ASSY NO HELP, NEED MORE TIME TO T/S, REQUEST MEL 3351A APPROVED COMPLIED MEL 3351A, STICKER APPLIED. PERFORMED EMERGENCY LIGHTS OPERSDR CALA2025102810629Light Sys · no discrepancyEMERGENCY LIGHTS OVER ROW 30 ARE ON AND WILL NOT GO OUT. ON GROUND FOUND EMERGENCY LIGHTS ON ROW 30 ABLE TO SWITCH ON AND OFFF NORMALLY. PERFORMED EMERGENCY LIGHTS OPS TEST PER AMM B787-A-33-51-00-00B-320A-A PASSED.SDR SCNA20251028413Placard · missingAFT CARGO CAUTION DO NOT BLOCK SMOKE DETECTOR MISSING IN 2 AREAS. INSTALLED 2EA. CAUTION SMOKE DETECTOR DO NOT BLOCK IN AFT CARGO CEILINGS ADJACENT TO SMOKE DETECTORS IAW B-737 MM 20-10-11.SDR YENA2025102801063Warning Message · illuminatedFLT 2233, BOS-SFO. (ETOPS) CLASS II MESSAGE FUEL. CLASS II MAINTENANCE MESSAGES DISPLAYED ON ECAM STATUS PAGE OF ECAM SYSTEM DISPLAY 1) FAULTS INDICATED BY FUEL. PERFORMED FQIC BITE TEST PER AMM 28-42-00-740-001 AND 28-46-00-740-001 TEST OK. NO PREVIOUS HISTOSDR YENA2025102801061Heater · odorFLT#318, JFK-BOS. "FWD GALLEY HEATER ( GALLEY HEATER (GHTR) FWD GALLEY )FA1 REPORTED STRONG CIGARETTE SMOKE SMELL ON SHORT FINAL NEAR ROW 1 NOT OBSERVED IN FLIGHT DECK" (SUPPLEMENTAL INFORMATION TO FOLLOW)SDR DXTA2025102805459Hose · leakingUPON REACHING END OF RUNWAY 34 WE HEARD A THUD WHEN SETTING PARKING BREAK AND GOT A PARK BRAKE LOW PRESS AMBER CAS MESSAGE. THERE WAS A PUDDLE UNDER RIGHT MAIN WHEN WE TURNED AROUND TO TAXI BACK TO RAMP AND THERE IS FLUID ON RIGHT MAIN STRUT. CORRECTIVE ACTIONSDR YENA2025102801058Unknown · odorFLT#8357, PHX-LAX. "ON DEPARTURE FROM FLL AFTER A HEAVY RAIN SHOWER WE EXPERIENCED AN ODOR IN THE A/C THAT WAS SENSED BY BOTH PILOTS AND FWD FAS DISSAPATED ABOUT 20 MINS LATER AND NOT SENSED AGAIN UNTILL INDIE DESCENT INTO PHX YET NOT AS STRONG LEVEL 1 ODOR; RSDR YENA2025102801056Unknown · odorFLT#1853, JFK-PBI. "OILY SMELL IN CKPT THRU 10K ( APU SYSTEM ) PERFORMED PACK # 1 ISOLATION FOR 5 MIN. ODOR DISSAPATED. NO COMMENTS FROM CABIN; INSPECTED AND PERFORMED OPS CHKM OF APU BLEED SYST PER AMM 49-51-00. NO ODOR DETECTED. MDDR CLEARED BMX4 UPDATED MCCSDR YENA2025102801057Unknown · odorFLT#2321, BOS-PBI. "DESCENDING THROUGH 9,000 AFT FLIGHT ATTENDANT REPORTED HOT PLASTIC ODOR EMITTING FROM AFT GALLEY THE ODOR WAS TRANSIENT. FOLLOWED A320 ODOR RECOGNITION & ISOLATION GUIDANCE FCOM PAGE 4-54 STEPS 1,2,14; COMPLIED WITH INFORMATION NOTICE 2017-SDR DALA2025102807897Unknown · odorAFTER ENGINE START BOTH ENGINES RUNNING APU SHUT DOWN, FA'S (2) CALLED FROM AFT GALLEY STATING "STRONG DIRTY SOCK SMELL.". RTG. C/A: OPENED COWLS ON #1 & #2 ENGS FOR BORO. C/W BST #1 HPL & LPL, NO OIL OR LIMITING DAMAGE FOUND PER A320 AMM 71-00. CLOSED COWLSDR SWAA2025102728784Sensor · inoperativeLE FLAPS TRANSIT LIGHT ON APPROACH. R & R NR 3 RETRACT LEADING EDGE PROXIMITY SENSOR (S172) IAW AMM 27-88-11.SDR R61A202510271485Mau · failedAVNX MAU 1A FAIL IN FLIGHT. EMERGENCY DECLARED, LANDED WITHOUT INCIDENT. PERFORMED RTS ON FLIGHT CONTROL AND PERFORMED CARD RESET ON MAU 1 NIC 1.SDR WX0A2025102732612Apu · odor(AIRCRAFT NOT GROUNDED) DIRTY SOCK SMELL OCCURS ON APPROACH INTO SBN / PERFORMED PHASE 3 TASK CARD W.O. 21-000-003 NO ODOR DETECTED, THIS CLEARS MEL 21-52-01E MDDR #221523 M PROCEDURE REVERSED PLACARDS REMOVED. REMOVED APU IAW AMM 49-11-11-000-004-A. INSTALLEDSDR AALA202510274554Elec Connector · inoperativeAIRCRAFT WAS GROUNDED: EMERGENCY LIGHT AISLE INDICATION INOPERATIVE AT ROWS 18ABC THROUGH ROW 25ABC. REMOVE AND REPLACED CONNECTOR AT SEAT 18ABC. PER SWPM 20-61-28. SYSTEM OPERATIONAL CHECK GOOD.SDR AALA202510277243Sign · missingAIRCRAFT WAS NOT GROUNDED: ROW 17F EMERGENCY LIGHT AT SIDEWALL, SIGN IS MISSING. REPLACED RIGHT HAND AFT EMERGENCY EXIT BOTTOM SIGN LIGHT AT SIDE WALL IAWAMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA202510276246Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FRONT LAVATORY DOOR IS HARD TO OPEN AND CLOSE FOR PASSENGER. ADJUSTED AND TIGHTENED DOOR HANDLE ASSEMBLY AND LAVATORY DOOR. OPERATIONAL CHECKS NORMAL. PER CMM 25-44-49.SDR AALA202510274961Bolt · looseAIRCRAFT WAS NOT GROUNDED: FORWARD ENTRY DOOR GUST LOCK BOLT IS LOOSE, POSSIBLE SAFETY WIRE MISSING. INSTALLED KEYWASHER AND SCREW FOR GUIDE ARM. PER AMM 52-11-21. OPERATIONAL CHECK GOOD.SDR AALA202510270663Girt Bar · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD SERVICE DOOR GIRT BAR CLIP LOOSE. ADJUSTED GIRT BAR CLIP FOR FORWARD SERVICE DOOR. PER AMM 25-66-01.SDR AALA202510272433Door · stiffAIRCRAFT WAS GROUNDED: GATE AGENT SAYS MAIN CABIN DOOR IS DIFFICULT TO OPEN. (OPEN).SDR UIEA2025102601281Exhaust Fan · odorSMOKE SMELL IN COCKPIT. R & R COOLING EXHAUST FAN PER AMM 21-58-01. OPS CHK NORMAL.SDR DALA2025102707891Seal · leakingAIRCRAFT 5038, DIRTY SOCK SMELL ON DESCENT THRU 5,000'. PERFORMED SMOKE AND FUMES QRH. ISOLATED SMELL WITH PACK 1 OFF. SMELL ONLY IN FLIGHT DECK. CORRECTIVE ACTION: REPLACED NBR 1 ENGINE SPINNER SEAL IAW A321 AMM 72-15. PERFORMED LEVEL B TYPE 2 DECONTAMINATIONSDR DALA2025102707871Light · inoperativeSHIP 3310 EEPLS LIGHT AT SEAT 43 H INOP. CORRECTIVE ACTION: REPAIRED WIRE PER A330 ESWPM 20-45 AND AWM 33-51. OP CHECK GOOD. (7877975)SDR DALA2025102707870Light · inoperativeSHIP 3313 SEAT 45AB EEPL INOP. CORRECTIVE ACTION: REPLACED SEAT 45AB EEPL LIGHT ASSY IAW A330 AMM 33-51. OK FOR SERVICE. (8151771)SDR DALA2025102707869Light · inoperativeSHIP 3313 SEAT 41JH EEPL INOP. CORRECTIVE ACTION: REPLACED SEAT 41JH EEPL LIGHT ASSY IAW A330 AMM 33-51. OPS GOOD. (8151770)SDR DALA2025102707861Mount · corrodedSHIP 3317 FOUND CORROSION ON THE FWD EDGE OF LH OUTLET MOUNTING PLATE AT FR44 TO FR47, Y87 THRU Y-493. CORRECTIVE ACTION: REPAIRED PER ERA 629534-14 REV ORIGINAL. (1272144)SDR DALA2025102707846Heat Exchanger · crackedSHIP 3164 - PRES - AND EMERGENCY DECLARED DUE TO CAB PR EXCESS CAB ALT ECAM WARNING AT 34,000 FEET. BEGAN DESCENT AND CABIN STARTED TO RECOVER ABOUT 28,000 FEET. CORRECTIVE ACTION: FOUND THE PRIMARY HEAT EXCHANGER WITH A LARGE CRACK, AND THE ACM INLET GASKET LSDR DALA2025102707837Flap System · false indicationSHIP 3714 FCNT/DE DECLARED EMERGENCY DUE TO FLAP LOCKOUT ON APPROACH MEX. PERFORMED FSEU BITE CHECK. NO FAULTS. OPERATED FLAPS SEVERAL CYCLES. OPS CHECK GOOD.SDR HNAA2025102700728Flap System · abnormalEVAL FLIGHT UNSATISFACTORY DUE TO "FLAP FAIL" EICAS MESSAGE DURING FINAL APPROACH WHEN TRANSITIONING FLAPS FROM 22 DEG TO 45 DEG. STUCK AT 36 DEG. MX HEARD GRINDING NOISE FROM RH FTB AND FFS OUTBOARD OF FTB. R+R FTB IAW AMM 27-51-01SDR DALA2025102707832Structure · damagedFOUND FWD GALLEY LAMINATE COSMETICALLY DAMAGED. R & R FWD GALLEY HAND SANITIZER LAMINATE PER A319 AMM 25-31. (1272551).SDR DALA2025102707831Fitting · corrodedCORROSION SPIGOT FITTING RECEPTACLE ON LH PYLON. REPLACED SPIGOT FITTING RECEPTACLE ON LH PYLON AS PER A319 SRM 54-51-12-300-001. (1273360).SDR HNAA2025102700726Light · inoperativeMAIN DOOR EMERGENCY LIGHT INOP. RAR LIGHT ASSY IAW AMM 33-50-06SDR HNAA2025102700724Controller · faultedAUTO PRESS FAIL MEL C29930 21-12-3 PRESS CONTROL AUTO AND MANUALSDR U2RA2025102600023Bottle · low pressureLH EMERGENCY SLIDE RESERVOIR PRESSURE IS BELOW GREEN BAND.SDR DXTA2025102705468Air Filter · dirtyWHILE SITTING ON THE RAMP, AIRCRAFT POWERED UP WITH THE APU RUNNING WITH THE AIR ON AND THE DOOR CLOSED, FOR ABOUT 20 MIN. STARTED GETTING A BURNING SMELL, HAD HINTS OF ELECTRICAL, NOT APU BLEAD AIR OR OUTSIDE EXHAUST. SHUT THE AIRCRAFT DOWN IMMEDIATELY CORRECSDR CALA2025102710612Heat Exchanger · leakingRIGHT ENG LOST QTY AND PRESS. BOTH WENT TO ZERO. EICAS ENG OIL PRESS R CREW REPORTED QUICK DROP OF OIL QUANTITY ALONG WITH DECREASING OIL PRESSURE AND ENG WAS SHUTDOWN. ENG WINDMILL TIME APPROXIMATELY 25 MINUTES WITH ZERO PSI & ZERO QTY OBSERVED. INSPECT PER ASDR CALA2025102710610Light · brokenSEATS 46D, 50F, 38F EMERGENCY PATH LIGHTS INOP. LIGHT ASSEMBLIES REMOVED AND REPLACED PER WDM 33-00-11-1. CHECKS OK.PARTS USED: 29-3326-3-0013,QTY :3 INFO UPDATE REGARDING SDR.SDR CALA2025102710608Fuse · inoperativeFIRST CLASS AISLE SEATS 1-4 EMERGENCY LIGHTS INOP R&R ONE FUSE FOR EMERGENCY POWER SUPPLY M2816 IN REF IPC 33-51-06-15. OPS CHECK GOOD.