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 CALA2025071506590Slide · out of positionDOOR 2L HAS EXPOSED SLIDE MATERIAL HANGING OUT THE BOTTOM OF DOOR. RETUCKED EXCESS MATERIAL REF AMM 25-66-01SDR CALA2025071506587Arming Lever · malfunctionedFA REPORTS DOOR 4L WILL NOT DISARM. REF AMM 25-56-01. INSTALLED SAFETY PIN IN DOOR SLIDE. REMOVED SLIDE FOR ACCESS FOR ARMING MECH. LUBE CABLE FOR THOUGHT OF MOSTIURE. RESCURSED SLIDE PER AMM 25-66-01-404-044. OPS CHECK ARMMIMG. ALL OPS CHECK GOOD. NO BINDING.SDR CALA2025071506586Pseu · faultedDOOR FLIGHT LOCK 1R EICAS STATUS #1 RIGHT PASSENGER ENTRY DOOR FLIGHT LOCK COMMAND/FLT LK RLY/SENSOR DISAGREEMENT. FIM TASK REF : FIM TASK REFERENCE NOT FOUND CMC MSG# 5211290 PSEU 2 (R2) CMC MSG 5212050. PSEU 2 (R2) TEST ACCOMPLISHED IAW FIM 52-11 TASK SDR CALA2025071506575Computer · smokeSMOKE IN CABIN THE SOURCE OF THE SMOKE IN THE CABIN WAS FROM A PASSENGER LAPTOP AT SEAT 4B. REMOVED AND REPLACED BOTH CABIN AIR RECIRCULATION FILTERS REF AMM 21-21-41-000-001-A AND AMM 21-21-41-400-001-A AND RAN PACKS TO AIR OUT CABIN. NO RESIDUAL SMOKE SMELLSDR QMLA2025071420072Wire Harness · chafedTRANSMISSION CHIP LIGHT ILLUMINATED IN FLIGHT.SDR SWAA2025071491117Engine · failedENGINE FAILURE AFTER DEPARTURE AT 3000. R&R #1ENGINE IN REF MT 771-00-01. OPS & LEAK CHECK GOOD. AIRCRAFT OK TO CONTINUE IN SERVICE.SDR QXEA2025071400278Indication Sys · faultedFLIGHT 2084. ON TAKEOFF ROLL AFTER 80 KIAS, ENGINE PERFORMANCE VALUES BEGAN DROPPING. HIGH-SPEED REJECTED TAKEOFF EXECUTED. RETURNED TO GATE REMOVED FROM SERVICE. CW POWER ASSURANCE RUN FOR BOTH ENGINES IAW GE LMM TASK 72-00-00-700-802 SUBTASK 72-00-00-760-043SDR QXEA2025071400275Fadec · malfunctionedPER ECMP REQUEST REPLACE THE #1 FADEC WITH POBIT. FADEC REPLACED.SDR SWIA2025071400013Engine · warning messageENGINE WARNING MESSAGE ON CLIMB OUT. INTERMITTENT DURING DESCENT AND BACK ON DURING FINAL APPROACH. NOT ON DURING TAXI, (FLIGHT 5099 - FILED OPEN)THIS IS CURRENTLY A WORK IN PROGRESSSDR SWI2025F00872Smoke Detector · false activationSMOKE FWD LAV WARNING MESSAGE WENT OFF DURING CRUISE TWICE IN A ROW WITH A COUPLE SECONDS DELAY IN BETWEEN. THERE WAS A PASSENGER IN THE FORWARD LAV, WE ASKED THEM DID THEY SMOKE/VAPE. THEY SAID NO. THEY SAID THEY SPRAYED PERFUME. THE FLIGHT ATTENDANTS SAID THSDR SWI2025F00871Skin · dentedTRANSFER FROM EAML 1654324 : REF EAML 1654169 FOR DENT FOUND ON LEFT FUSELAGE, NSPECTED DAMAGED AREA ON LEFT FORWARD FUSELAGE SKIN PANEL AT FR 10L +0.531" AND STG 16L - 0.156" AND FOUND DENT MEASURING 2.625"L X 2.781"H X 0.111"D. OUT OF LIMITS PER ERJ 175 SRM SDR GTIA2025071438990Door · leakingEME EXIT ROW 134A,B,C IS MAKING LOUD NOISE-SWAPPED EMERGENCY DOOR LH SIDE WITH RH SIDE FWD AND AFT PER AMM 52-21-11, PERFOMED PRESSURIZATION PER AMM 05-28-30. LH SIDE NO LEAKING, RH SIDE AFT LEAKING. THE HATCH WITH SN UH25387 WAS IDENTIFIED AS THE SOURCE OF TSDR AALA202507141347Warning Light · illuminatedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: CLIMBING THROUGH 10K RIGHT A/C PACK LIGHT CAME ON. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT DFW. (OPEN).SDR DALA2025071405282Switch · stickingSHIP 3124 GROUND PERSONAL REPORTED AFT CARGO DOOR SWITCH STICKING IN THE OPEN POSITION. REMOVED AND REPLACED AFT CARGO MANUAL SELECTOR VALVE IAW A319 AMM 52-36.SDR DALA2025071405299Bolt · missingSHIP 3159 L1 WILL NOT SHUT PROPERLY AND WILL NOT ARM. INSTALLED MISSING HARDWARE AND PERFORMED OPS CHECK OF 1L DOOR AND LOCKING SYSTEM PER A319 AMM 52-11-31.SDR DALA2025071405292Reinforcement · damagedSHIP 3412 REINFORCEMENT DAMAGED AT FRAME 63 STR 1R. REPLACED UPPER FRAME REINFORCEMENT SECTION PER A330 SRM 51-42-00.SDR DALA2025071405289Psu · inoperativeSHIP 3329 SEAT 56AB PSU INOP. REPLACED PSU ASSY PER A330 AMM 35-21. OK FOR SERVICE.SDR AALA202507145227Bottle · no testAIRCRAFT IN BASE MAINTENANCE: PASSENGER CREW DOOR 831, DOOR DAMPER AND EMERGENCY OPERATION CYLINDER DOES NOT PASS THE DOOR DAMPING FUNCTION OPERATIONAL TEST. REPLACED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-11-14.SDR AALA202507147000Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202507149068Handle · looseAIRCRAFT WAS NOT GROUNDED: 3R DOOR SLIDE ARMING HANDLE IS LOOSE AND DIFFICULT TO ARM. MAINTENANCE RESECURED HANDLE HARDWARE ON THE 3R DOOR AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 52-20-00.SDR AALA202507143651Light · no testAIRCRAFT IN BASE MAINTENANCE: EMERGENCY CIELING DOME LIGHT 207WL IS INOPERATIVE. REPLACED LIGHT AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-11.SDR WX0A2025071432500Generator · inoperativeF/A STATES DIRTY SOCK ODOR FROM TOP OF DESCENT UNTIL FINAL APPROACH, ACCOMP TC 21-000-001, RAN APU, ENGS 1 & 2 BLEED WITH PACKS 1 & 2. UNABLE TO DUP ODOR. APU OIL LEVEL IN RANGE & NO EVIDENCE OF OIL. C/W TC 21-000-002, NO SMELL, W/O 527112, PERFRMD T/C 21-00SDR UIEA2025071300946B-Nut · looseDURING FLIGHT, #2 OIL QUANTITY FELL TO 0, NO OTHER ABNORMAL INDICATIONS WERE NOTED AT THE TIME. ABOUT 2 HRS LATER, OIL PRESS BEGAN TO DECREASE, #2 ENG SHUTDOWN DUE TO "ENG 2 OIL PRESS" EICAS MSG WHEN THROTTLES WENT TO IDLE AT DESCENT. OIL PRESS DROPPED TO NEARSDR IPXA2025071410407Warning Message · illuminatedLEFT WINDOW MSG QRH ACTIONED MSG REMAINS DISPLAYED. DEFERRED THE L2 WINDOW AS PER MEL 30-41-1-2. DMP C/W AND PLACARD INSTALLEDSDR AALA202507145361Wire Splice · brokenAIRCRAFT WAS GROUNDED: EMERGENCY AISLE RUNNING LIGHT ON SEAT 13 L/H SIDE INOPERATIVE. MAINTENANCE FOUND BROKEN SPLICE IN WIRING HARNESS LEADING TO SEAT MOUNTED EMERGENCY LIGHT AT ROW 13 L/H. REMOVED OLD SPLICE AND INSTALLED NEW ONE IAW AWM 33-51-07.SDR AALA202507141498Control Unit · faultedAIRCRAFT WAS GROUNDED: AFTER PUSH BACK CABIN CREW REPORTED STRONG ELECTRICAL TYPE ODOR, FROM FORWARD GALLEY VENTS. A SHORT TIME LATER ODOR CAME THROUGH COCKPIT VENTS. MAINTENANCE REPLACED COOLING SYSTEM COMPRESSOR MOTOR CONTROL.SDR AALA202507146173Coffeemaker · odorAIRCRAFT WAS GROUNDED: ODER SMELL OBSERVED BY PASS & FA NEAR ROWS 28 A/C LEFT TO RIGHT TRAVELLED TO FRONT 15 MIN LATER SMELL WAS NO LONGER NOTICED SOME DESCRIBED AS ELECT SMELL- TO MUSTY SMELL 1 PAX COMPLAINED OF HEADACHE AS SOON AS HE SMELLED IT. MAINTENANCE SDR AALA202507147840Battery · dischargedAIRCRAFT WAS NOT GROUNDED: FORWARD FLIGHT ATTENDANT JUMP SEAT FLASHLIGHT INOPERATIVE. MAINTENANCE REPLACED FLASHLIGHT BATTERY IAW DRAWING NUMBER DFB1081.SDR CALA2025071406563Charger · faultedWHILE PERFORMING STAR CHECK, BCL 1 AND BATTERY 1 FAULTS APPEARED. SMOKE SMELL IN COCKPIT, SMOKE COMING FROM BAT 1. FAULT FIR BAT 1 AND BCL 1 ON ECAM. R/R #1 MAIN BAT IAW AMM 24-38-51/401. R/R #1 BCL IAW AMM 24-38-34/401. NO FAULTS NOTED AT THIS TIME. A/C OK FOSDR CALA2025071406518Battery Pack · no testL1 DOOR EXTERIOR SLIDE LIGHT INOP. EMERGENCY LIGHTING SYSTEM OPERATIONAL CHECK {B737-33-3-0235} - EVALUATED AND FOUND L273 DOME LIGHT, L1086 EXIT LOCATOR SIGN, AN D L1067 OVERDOOR EXIT SIGN ALSO INOP. SUSPECT BATTERY AND CHARGE R M1675 FAULTY. REF IFM 33-51-0SDR CALA2025071406517Girt Bar · out of positionREQUEST DOOR 1R SLIDE INSPECTION. FABRIC HANGING LOW/TOUCHING FLOOR. REPACKED GIRT MATERIAL Z FOLD ON 1R DOOR SLIDE REF AMM 25-66-01. C/W RII REF. GMM 09-25-05. 1R DOOR SLIDE INSTALL IS GOOD REF. AMM 25-66-01.SDR CALA2025071406516Skin · dentedDENT FOUND AT APPROXIMATELY BS 951 THE 5 OCLOCK POSITION. JUST AFT OF WATER SERVICING PANEL. AFT CARGO RH SIDEWALL PANEL # 142VW REMOVED FOE ACCESS, REF AMM 25-52-06-400-801, DRW T29-0620-1-0069. REMOVED AFT CARGO FLOOR PANEL #140DF REF:AMM 25-52-10-400-801, SDR CALA2025071406515Motor · failedSTAB TRIM INOP RAN QRH ALL STAB TRIM STILL INOPPERF LAND VERIFY TEST. FOUND MX MSG 22-11167, 22-11173 AND 22-11181. REC REP OF ELEC SWITCH (S272) REF FIM 22-11 TASK 924. REC REP OF STAB POS TRANS A (M1192) REF FIM 22-11 TASK 930. ATTEMPTED TO MANUALY ACTUATE SDR DALA2025071405252Seat Track · corrodedAIRCRAFT 3094, CORROSION SEAT TRACK -Y1292 FROM FR20 TO FR24 FWD GALLEY AREA (SSI: 531194). CORRECTIVE ACTION: REPLACED SEAT TRACK, -Y1292 BTW FR12 TO FR24, AND FASTENERS. AS PER A321 SRM 51-72-11, A321 SRM 51-42-11, DWG D53135205. (LP 1080887)SDR FDEA202507131186Slide · warning messageRIGHT WING SLIDE EICAS ON TAXI OUT. TERMINATING ACTION ACCOMPLISHED FOR E.A. F-5220-T0384096. INSTALLED 4EA SEALING BOLTS FOR THE OVERWING SLIDE PANEL. INSTALLED ACCESS PANEL IN THE AFT OUTBOARD CORNER OF THE RIGHT MLG BAY REFERENCED BY THE ABOVE MAINTENANCSDR JJBA2025514048Door · lack of lubeMCD HARD TO OPEN. LUBRICATED MCD. OPS CHECK SAT.SDR SCNA20250714256Battery Pack · inoperativeLEFT AND FWD GALLEY EMERGENCY LIGHTS INOP. R&R L1 EMERGENCY LIGHT BATTERY PACK REF AMM 33-51-06, OPS CHECK OKAY.SDR MAS2025F00003Shear Tie · corrodedSHEAR TIE AT FRAME 90 BETWEEN STRINGERS 29L AND 29R IS CORRODED. OUT OF LIMITS. REPLACEDSDR DALA2025071305249Packing · leakingAIRCRAFT 5005, DIRTY SOCK SMELL ON DESCENT. F/O SMELLED IT AROUND 8K, F/A'S CALLED AROUND 3K TO REPORT A STRANGE SMELL IN THE FWD AND AFT CABIN AS WELL. CORRECTIVE ACTION: FOUND EVIDENCE OF OIL IN #1 AND #2 ENGINE SPINNERS. REPLACED #1 AND #2 ENGINE FAN SHAFT SDR JR2R20250713909Stringer · corrodedSTRINGER 28R BETWEEN FRAMES 88 AND 89 IS CORRODED OUT OF LIMITS. REPAIRED.SDR JR2R20250713944Shear Tie · corrodedSHEAR TIE AT FRAME 89 BETWEEN STRINGERS 29R AND 29L IS CORRODED OUT OF LIMITS. REPLACED.SDR JR2R20250713934Shear Tie · corrodedSHEAR TIE AT FRAME 87 BETWEEN STRINGERS 28L AND 29L IS CORRODED OUT OF LIMITS. REPLACED.SDR JR2R20250713790Shear Tie · corrodedSHEAR TIE AT FRAME 88 BETWEEN STRINGERS 28R AND 29R IS CORRODED OUT OF LIMITS. REPLACED.SDR R61A2025071300309Seat Track · corrodedDURING HEAVY CHECK CF III, L/H I/B SEAT TRACK REPAIR DOUBLER AT FR84 FOUND CORRODED. REPAIRED SETA TRACK DOUBLER IAW SRM 53-23-10 REPAIR 4SDR R61A2025071300308Seat Track · corrodedDURING HEAVY CHECK CF III, R/H I/B SEAT TRACK DOUBLER AT FR84 FOUND CORRODED. REPAIRED SEAT TRACK DOUBLER IAW SRM53-23-10 REPAIR 04SDR R61A2025071300307Floor Support · corrodedDURING HEAVY CHECK FWD CABIN WET AREA FR16 LBL46 FLOOR SUPPORT FOUND CORRODED. REPLACED FLOOR SUPPORT IAW SRM 51-43-03SDR R61A2025071300306Beam · corrodedDURING HEAVY CHECK AFT PASSENGER DOOR L2 CUTOUT LOWER BEAM FOUND CORRODED. LOWER BEAM REPLACED IAW SRM51-43-03SDR R61A2025071300305Beam · corrodedDURING HEAVY CHECK AFT SERVICE DOOR R2 CUTOUT LOWER BEAM FOUND CORRODED. REPAIRED IAW ETD2025-170-924197SDR R61A2025071300304Shear Panel · corrodedDURING HEAVY CHECK CF III R/H SHEAR PANEL BETWEEN FR87-FR88 RBL12-RBL41 FOUND CORRODED. REMOVED AND REPLACED SHEAR PANEL IAW SRM51-42-01SDR R61A2025071300303Shear Web · corrodedDURING HEAVY CHECK CF III, R/H SHEAR WEB SPLICE BETWEEN FR87-FR88 RBL41 FOUND CORRODED. REPLACED SHEAR WEB SPLICE IAW SRM 57-42-02