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 3EJA202508150001Thrust Reverser · unlockedLEFT THRUST REVERSER UNLOCK ILLUMINATED. PERFORMED OPS TEST OF LH TR, MANIPULATED ALL TR EXPOSED ASSOCIATED WIRING WHILE MONITORING THE UNLOCK LIGHT, PERFORMED GVI OF ALL ASSOCIATED MECHANICAL AND PERFORMED 25 TR CYCLES PER THE TR HYDRAULIC LEAK CHECK WITH NOSDR SWAA2025081596842Panel · crackedPANEL 324BL CRACKED ON EDGE NEAR FASTENER HOLE. REPAIRED VERTICAL STAB TRAILING EDGE PANEL 324BL IAW SRM 55-30-01-2R-9, SRM 51-70-04-2R-6, AND SRM 51-70-04-2R-0 REPAIR GENERAL.SDR CALA2025081407728Bolt · crackedFRAME 68, STR 22 HAS CRACK INDICATION AT LOWER SIDE OF FLANGE ABOVE DOOR STOP FASTENERS NR 3.SDR SWI2025F01081Spring · brokenFORWARD SERVICE DOOR FORWARD GIRT BAR FLOOR FITTING FLAP SLIDE SPRING IS BROKEN. (C-CHECK RO 08/12/2025)REMOVED AND REPLACED FORWARD SERVICE DOOR FORWARD GIRT BAR FLOOR FITTING FLAP SLIDE SPRING REF. ERJ 175 AMM 53-10-25SDR SWIA202508130730Cable · damagedAFT SERVICE DOOR EMERGENCY SLIDE MECHANISM CABLE SHEATH DETACHED AT TOP. (C-CHECK) REMOVED AND REPLACED AFT SERVICE DOOR EMERGENCY SLIDE FLEX CABLE. REF: ERJ 175 AMM 52-42-40SDR AALA202508128582Intercostal · wornAIRCRAFT IN BASE MAINTENANCE: FORWARD CARGO COMPARTMENT INTERCOSTAL TOP SURFACE HAS ELONGATED HOLES BETWEEN BS 500C AND BS 500D AT S25L. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR IPXA2025080310676Frame · crackedDURING OK TO INSTALL, FOUND AT STA 1200, BTW RBL 5 TO RBL 24, INTERCOSTAL DELAMINATED AND WITH CRACK. INSTALLED 1 EA INTERCOSTAL IAW SRM 51-40-02-0G.SDR AALA202508110058Stop Fitting · undertorquedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND AFT EMERGENCY ESCAPE DOOR CUT OUT, UPPER AFT DOOR STOP LOOSE (ROTATES BY HAND). RETIGHTENED RIGHT HAND AFT EMERGENCY ESCAPE DOOR CUT OUT, UPPER AFT DOOR STOP. PER B737 NG SRM 51-40-02.SDR AALA202508119850Stop Fitting · undertorquedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND AFT EMERGENCY ESCAPE DOOR CUT OUT, UPPER AFT STOP LOOSE (ROTATES BY HAND). RETIGHTENED LEFT HAND AFT EMERGENCY ESCAPE DOOR CUT OUT, UPPER AFT STOP. PER B737NG SRM 51-40-02.SDR AALA202508094228Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON WEB LOC BTW FR69 TO FR70 AT STGR 23RH IN AFT GALLEY AREA MEASURE OF DAMAGE ARE L= 1.167 INCH, W= 0.506 INCH, D= 0.010 INCH. MAINTENANCE REPLACED WEB LOC BTW FR69 TO FR70 AT STGR 23RH IN AFT GALLEY AREA IAW A319 SRM 51SDR SWAA2025080796660Flashlight · unsecureFWD WINDSCREEN LOWER EMERGENCY FLASHLIGHT NOT SECURED. TIGHTEN FWD WINDSCREEN LOWER EMERGENCY FLASHLIGHT SCREWS IAW SOPM 20-50-01.SDR FDEA202507301386Doubler · no discrepancyAIRCRAFT REPAIR ASSESSMENT : EXISTING FLUSH DOUBLER REPAIR FOUND ON LH WING #1 SLAT NOSE SKIN BTW RIB 9~10 COMPLIED WITH ATTACHMENT B OF EO: E6-5100-7-5000 D7 PT1, TITLE: STRUCTURES - REPAIR CATALOG - A300/A310 REPAIR IDENTIFICATION & TRACKING REQUIREMENTSSDR AALA202508075104Intercostal · elongatedAIRCRAFT IN BASE MAINTENANCE: FOUND INTERCOSTAL BETWEEN BS 500F TO 500G AT STR 25L TOP HOLES ELONGATED. INSTALLED NEW INTERCOSTAL. PER AARD 51-00-05-1A AND SRM 51-40-02 AND BOING DRAWING 143A7505SDR VNAA2025080711101Control Panel · faultedSTEERING INOP IN FLIGHT, SHORTLY AFTER GEAR UP, PLANE CAME IN WITH NWS INOP CAUTION MSG. NWS INOP MESSAGE CAME ON IN FLIGHT WHEN TAKEOFF HAPPENED. WHEN PLANE LANDED NWS INOP WAS CLEARED BY CB RESET BY THE PILOTS PER THE MIPM. PILOTS TAXI PLANE TO GATE AFTER CSDR SWAA2025080696704Battery Pack · inoperativeRIGHT OVERWING HEADER EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED M1671 AND OWE BATTERY PACK PER AMM 33-51-06-960-805-NG, POWER SUPPLY - BATTERY PACK REPLACEMENT - PERMANENT. OPS CHECK GOOD.SDR FDEA202507301372Skin · no discrepancyAIRCRAFT REPAIR ASSESSMENT : EXISTING COMPOSITE REPAIR FOUND ON LH ELEVATOR UPR SKIN AT ER16-12", T/E-22" COMPLIED WITH ATTACHMENT B OF EO: E6-5100-7-5000 D7 PT1, TITLE: STRUCTURES - REPAIR CATALOG - A300/A310 REPAIR IDENTIFICATION & TRACKING REQUIREMENTSDR AALA202508061200Outlet · odorAIRCRAFT WAS NOT GROUNDED: POWER PORTS AT ROWS 16 AND 17 DEACTIVATED DUE TO ELECTRICAL BURNING ODOR REF MIC 1396210. MAINTENANCE REPLACED POWER OUTLET UNIT AT 16D IAW AMM 25-21-37.SDR AALA202508065565Power Port · odorAIRCRAFT WAS NOT GROUNDED: POWER PORTS AT ROWS 16 AND 17 DEACTIVATED DUE TO ELECTRICAL BURNING ODOR REF MIC 1396210. **SUPPLEMENTAL REPORT FOR SDR AALA202508025565** (CLOSED)** MAINTENANCE REPLACED ISPS UNIT FOR ROW 16DEF IAW AMM 25-21-38.SDR DALA2025080505872Light · inoperativeAFT LT OVERWING EMERGENCY LIGHT INOPERATIVE. R & R LT OWEED EXTERNAL LIGHT IAW AMP 33-55. OPS TESTS NML.SDR SWAA2025080596966Battery Pack · inoperativeALL RH BIN EMERGENCY LIGHTS AFT OF OVERWING; AND R2 EMERGENCY LIGHTS INOP.<[01] TWO BATTERY PACKS (M1671 AND M1672) WERE FOUND TO BE AT FAULT. CHARGED AND OP CHECKED M1672 BATTERY PACK IAW SWA 737-800 AMM 33-51-06-610-802 AND AMM 33-51-06-960-805. REMOVED; REPSDR SWAA2025080598529Battery Pack · inoperativeALL RH BIN EMERGENCY LIGHTS AFT OF OVERWING; AND R2 EMERGENCY LIGHTS INOP.<[01] TWO BATTERY PACKS (M1671 AND M1672) WERE FOUND TO BE AT FAULT. CHARGED AND OP CHECKED M1672 BATTERY PACK IAW SWA 737-800 AMM 33-51-06-610-802 AND AMM 33-51-06-960-805. REMOVED; REPSDR AALA202508054391Stop Fitting · out of positionAIRCRAFT IN BASE MAINTENANCE: LEFT HAND OVERWING EXIT HATCH, FORWARD LOWER DOOR STOP IS CROOKED. MAINTENANCE POSITIONED LOWER DOOR STOP IN PROPER POSITION PER AMM 52-22-01.SDR AALA202508053041Stop Fitting · out of positionAIRCRAFT IN BASE MAINTENANCE: LEFT HAND OVERWING EXIT HATCH, FORWARD UPPER DOOR STOP IS CROOKED. MAINTENANCE POSITIONED UPPER DOOR STOP IN PROPER POSITION PER AMM 52-22-01.SDR DALA2025080505854Hydraulic Line · leakingRETURNED TO ATL DUE TO A RIGHT SYSTEM HYDRAULIC FLUID AND PRESSURE LOSS REQUIRING A MANUAL GEAR EXTENSION. MAINTENANCE REPLACED THE LEFT MAIN LANDING GEAR BUNGEE CYLINDER LINE AND UNION.SDR DALA2025080405821Light · inoperativeSHIP 5805 4L DOOR SLIDE LIGHT WENT OUT IN AIR. CORRECTIVE ACTION: RELAMPED, REMOVED EXCESSIVE DEBRIS FROM GIRT BAR AREA OF DOOR. OPS NOW OK. REF B757-300 AMM 25-66. (7296864)SDR DALA2025080105762Windshear Sys · activatedATO, APPROX. 100 KNOTS DUE TO PREDICTIVE WINDSHEAR ALERT ON TAKEOFF. NO WEATHER ON FIELD. CORRECTIVE ACTION: FORWARD PWS TO MEL VIA FLIGHT CREW PLACARD.SDR AALA202508036180Oil System · leakingAIRCRAFT WAS GROUNDED: VERY STRONG BURNED OIL LIKE SMELL, IN THE FLIGHT DECK. IT STARTED AT ABOUT 12000 FEET DURING DESCENT. MAINTENANCE FOUND THE APU WAS LEAKING OIL AND REPLACED IT PER TASK CARD 26L31049003. A DECONTAMINATION OF THE ENVIRONMENTAL CONTROL SYSSDR AALA202508025565Power Port · odorAIRCRAFT WAS NOT GROUNDED: POWER PORTS AT ROWS 16 AND 17 DEACTIVATED DUE TO ELECTRICAL BURNING ODOR REF MIC 1396210. (OPEN)SDR AALA202508020044Acm · odorAIRCRAFT WAS GROUNDED: UNABLE TO COOL AIRCRAFT AND ODOR ON TAKE OFF AND CLIMB. DECESION MADE TO RETURN TO LHR. LANDED WITHOUT INCIDENT. MAINTENANCE CONFIRMED RH A/C PACK ACM FAILED AND REPLACED RH ACM IAW AMM 21-51-02.SDR DALA2025080105792Unknown · odorBOTH CLIMB AND DESCENT THROUGH APPROX. 10,000 FT FAINT URINE ODOR IN COCKPIT AND FIRST CLASS. DISAPPEARED QUICKLY. PERFORMED INSP PER NO GO ODI PREVENTION AND W/C 0550-2002. REFER TO LOG # 1113733 FOR DETAILS.SDR DALA2025080105790Bushing · wornWEAR FIXED BUSHINGS (2 EA) ON HINGE FITTING 1 LH ELEVATOR. REPAIRED AND REPLACED BUSHINGS (2EA) ON HINGE FITTING NR 1 AT LH ELEVATOR AS PER A319 SRM 55-26-41-300-004.SDR DALA2025080105789Bushing · wornWEAR FIXED BUSHINGS (2 EA) ON HINGE FITTING 3 LH ELEVATOR. REPAIRED AND REPLACED BUSHINGS (2EA) ON HINGE FITTING NR 3 AT LH ELEVATOR AS PER A319 SRM 55-26-41-300-004.SDR DALA2025080105788Retainer · crackedCRACK ON BOTH GALLEY RETAINING BLOCKS ON COMPARTMENT OF 511M ON UPPER BLOCKS BOTH MEASURING OVER 4 IN ALONG WITH BLOCK PANEL DELAMINATING. REMOVED AND REPLACED RETAINING BLOCKS REF CMM PMC 68353751021-4050G-00001-01. REPAIRED DELAMINATION REF A319 SRM 51-77-1SDR DALA2025080105784Bushing · wornWEAR FIXED BUSHINGS (2 EA) ON HINGE FITTING 2 LH ELEVATOR. REPAIRED AND REPLACED BUSHINGS (2EA) ON HINGE FITTING #2 AT LH ELEVATOR AS PER A319 SRM 55-26-41-300-004.SDR SWAA2025080196449Doubler · crackedELECTRICAL GROUND POWER RECEPTACLE SURROUND DOUBLER CRACKED ON LOWER EDGE. REPAIRED ELECTRICAL GROUND POWER RECEPTACLE SURROUND DOUBLER AT LOWER EDGE IAW SRM 53-10-15-2R-4. PERFORMED A HIGH FREQUENCY EDDY CURRENT (HFEC) INSPECTION OF THE TRIM OUT AT THE LOSDR AALA202508015708Gps · malfunctionedAIRCRAFT WAS NOT GROUNDED: GPS GOT JAMMED IN GEORGA AND DID NOT COME BACK. BURNED TO MUCH FUEL AS A RESULT AND MADE A FUEL STOP IN BOS. AIRCRAFT WAS NOT OVERWEIGHT AND NO EMERGENCY DECLARED. MAINTENANCE ACCOMPLISHED A/C POWER DOWN AND POWER UP REF AMM 49-11-00SDR AALA202508010493Bulb · burned outAIRCRAFT WAS NOT GROUNDED: EMER OVERWING EXIT HANDLE LIGHT BURNT OUT. MAINTENANCE RELAMPED HANDLE LIGHTS PER AMM 33-51-11.SDR AALA202508010241Power Supply · no testAIRCRAFT IN BASE MAINTENANCE: ** FLIGHT CREW REST (OFCR) DEEP CYCLE TEST FAIL. MAINTENANCE REPLACED OFCR BATTERY PACK REPLACED AND TESTED NORMAL AS PER AMM 33-51-06, REV 249, 16 JUL 2025.SDR DALA2025080105760Skin · crackedCRACKS 2 (EA) ON LOWER SKIN HORIZONTAL STAB STA 129.50 BTW FRONT SPAR AND REAR SPAR LH SIDE. LOWER SKIN HORIZONTAL STAB STA 129.50 BTW FRONT SPAR AND REAR SPAR LH SIDE WAS REPAIRED PER B737-800 SRM 55-10-01-2R PROCEDURE 11 REPAIR 11.SDR YENA2025080100790Unknown · odorFLT#1793, JFK-SJO. AT TOP OF DESCENT FA REPORTED TFRANSENT SMELL OF GAS. SMELL CONFIRMED BY OTHER FA. SMEI CAME AND WENT. SMELL ISOLATED TO FWD GALLEY, APU WAS OFF. PACKS 1 & 2 ON HAD BEEN INFLIGHT FOR 4 HOURS. ACCOMPLISHED INFO NOTICE 2017-7015 OPERATED BY CSDR AALA202508014885Flashlight · no testAIRCRAFT IN BASE MAINTENANCE: AFT FLIGHT ATTENDANT RIGHT HAND LED FLASHLIGHT TEST LIGHT DOES NOT ILLUMINATE. REMOVE AND REPLACED BATTERY. PER AMM 25-64-00. OPERATIONAL CHECK GOOD.SDR AALA202508012480Flashlight · no testAIRCRAFT IN BASE MAINTENANCE: AFT FLIGHT ATTANDENT LEFT HAND LED FLASHLIGHT TEST LIGHT DOES NOT ILLUMINATE. REMOVE AND REPLACED BATTERY. PER AMM 25-64-00. OPERATIONAL CHECK GOOD.SDR AALA202508014377Battery · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY POWER SUPPLY UNIT 12WL BATTERY FAILED SYSTEM TEST. REPLACED BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR AALA202508018022Battery · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY POWER SUPPLY UNIT 10WL BATTERY FAILED SYSTEM TEST. REPLACED BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR CALA2025080107213Anti-Ice Valve · faultedEAI PRSOV R RIGHT ENGINE ANTI-ICE (EAI) PRSOV FAILURE. FLT CREW DEBRIEF STATED THAT THE ANTI-ICE MSG WAS PRESENT ON DESCENT JUST AS IT WAS IN CRUISE. REMOVED AND REPLACED EAI PRSOV RT ENGINE IAW AMM 30-21-08, OPS ACCOMPLISHED GVI OF THE ENGINE INLET CAVITY PSDR CALA2025080107212Window Frame · crackedL3 WINDOW FRAME E-F POST REPAIRED PER ECRA 5310-08654. PERFORM AN INSPECTION OF LT WINDOW FRAME E-F POST REPAIR ON AIRCRAFT IAW PART 2 OF THE LATEST REVISION OF ECRA 5310-08654. MAJOR REPAIR. ACCOMPLISHED ESFR AND PERMANENT REPAIR COMPLIED WITH.SDR CALA2025080107195Bottle · no discrepancyL2 DOOR NOT SHOWING GREEN, INSPECTED SLIDE PRESSURE GAUGE. INDICATION SHOWS TO BE AT THE HIGHER END OF PRESSURE BUT REMAINS IN THE GREEN BAND. SLIDE IS CLEAR FOR CONTINUED SERVICESDR CALA2025080107194Switch · out of toleranceAT TOUCH DOWN L2 AFT ENTRY DOOR LIGHT CAME ON PERFORMED GALLEY SERVICE DOOR INDICATION SENSOR IAW AMM 52-71-11-820-801. FOUND AFT GALLEY ENTRY DOOR SWITCH S200 GAP OUTSIDE OF CLOSEST PERMITTED GAP. ADJUSTED AFT GALLEY ENTRY DOOR SENSOR (S200) TO OPTIMUM GAP ASDR CALA2025080107193Lens · looseL1 PRESSURE GAUGE COVER LOOSE. RAFT RESECURED PRESSURE GAUGE LENS COVER.SDR CALA2025080107192Light · no discrepancyL4 SLIDE LIGHT NOT TURNING ON WHEN ARMED. REPOSITIONED DOOR L4 BY OPENING AND CLOSING DOOR, SLIDE LIGHT ON, WHEN ARMED, OK FOR SERVICE.