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 DALA2025080405836Skin · dentedSHIP 3119 FOUND DENT ON THE CROWN SKIN AFT OF FR 53 BETWEEN STR 3L-4L. CORRECTIVE ACTION: COMPLIED WITH ER/A 626580-14. (1107420).SDR DALA2025080105769Stringer Clip · damagedFWD OF FRAME 61, STRINGER CLIP TOOLING DAMAGE. REPAIRED PER ERA 627516-14.SDR DALA2025080105768Frame · damagedBETWEEN SRINGER 2L AND 3L DAMAGED FASTENER HOLES. REPAIRED PER ERA 627864-14.SDR AALA202507312689Light · inoperativeAIRCRAFT WAS NOT GROUNDED: OVERHEAD EMERGENCY LIGHT AT 24DEF INOPERATIVE. REPLACED OVERHEAD BIN EMERGENCY EXIT LIGHT OVERHEAD EMERGENCY LIGHT AT 24DEF.SDR VNAA2025073111102Hose · chafedHYD SYSTEM 2 LOW PRESSURE CAUTION MESSAGE IN FLIGHT WITH 0% QUANTITY. FOUND HYD 2 DAMPENER FLEX HOSE TO BE CHAFED THROUGH BY ADEL CLAMP. REMOVED AND REPLACED HOSE AND CLAMP IAW AMM 29-11-59-000/400-801. OPS CHECK/LEAK CHECK GOOD.SDR SWAA2025073195640Bulb · inoperativeLIGHT BULB IS OUT ON AED EMERGENCY EXIT LIGHT SIGN. REPLACED ONE UPPER BULB ON AED EMERGENCY EXIT LIGHT SIGN IAW AMM 33-51-01-960-801. PERFORMED OPS TEST, TESTED GOOD IAW AMM 33-51-01-960-801.SDR SWAA2025073195639Bulb · inoperativeBULB OUT AT EMERGENCY EXIT LIGHT ABOVE FED. REMOVED AND REPLACED BULB AT EMERGENCY EXIT LIGHT ABOVE FED IAW AMM 33-51-01-960-801, OPS CHECKED GOOD.SDR KCSA2025072640Fire Bottle · unserviceableFIRE CARGO FWD MSG. FAK & ALL SRCS MVD TO U/D XFER TO DMI 100259185 IAW MEL 26-23-1-2 CAT C DUE 08-06-2025 MX PROC C/W PLCDS INSTL. REF DMI 100259185 FOR DEACT FWD LWR LOBE SMOKE DET SYS. SYS DEACT, XFER TO DMI 100259186 IAW MEL 26-16-1-2-2B CAT C, MX PROC SDR IPXA2025072938528Repair · peelingMAJOR REPAIR, WHILE PERFORMIN WALK AROUND PER PS1 FOUND L/H WING #2 FLAP UPPER SURFACE AFT OF L/E PREVIOUS REPAIR HAS PEELED OFF . DEFERRED IAW EO-94534-REQ1.SDR SWAA2025073095524Handle · looseFWD GALLEY AREA R1 DOOR ASSISTANCE HANDLE LOOSE. INSTALLED CORRECTLY FWD GALLEY AREA R1 DOOR ASSISTANCE HANDLE IAW AMM 52-41-31-400-802 STEP 3F(2).SDR IXXA20250726037Apu · sparksUPON INITIAL WALK AROUND SPARKS WERE SEEN COMING OUT OF THE EXHAUST BEFORE APU SHUT DOWN. ACCOMPLISHED BORESCOPE FOUND DAMAGE TO BE BEYOND ALLOWABLE LIMITS. REMOVED AND REPLACED APU IAW ATI TASK CARD JC-49-999-00-01. ALL OPERATIONAL AND LEAK CHECKS GOOD.SDR AALA202507301629Duct Clamp · looseAIRCRAFT WAS GROUNDED: CABIN AND BULK CARGO WOULD NOT COOL AFTER 1.5 HOURS IN FLIGHT. DIVERTED TO HND. AIRCRAFT LANDED WITHOUT INCIDENT. MAINTENANCE FOUND DROOPINH DUCT AND LOOSE CLAMPED. RE-ALIGNED DUCT AND SECURED CLAMP IAW AMM 21-52-01.SDR AALA202507304542Oven · burnedAIRCRAFT WAS GROUNDED: FUMES SMELLED IN ENTIRE AIRCRAFT FROM ABOUT 18K FEET UNTIL LANDING. ACRID IN BACK CABIN. MORE OF A BURNING SMELL IN COCKPIT. LIKE AN ELECTRIC HEATER OR THE OVENS BEING USED SMELL. MAINTENANCE FOUND BAD BURNING ELEMENT AND REPLACED #2 OVESDR DXTA2025073004376Door Seal · leakingWHEN DESCENDING THROUGH 12K FEET THE MAIN DOOR MAKES A LOUD NOISE. IT SEEMS TO STOP MAKING NOISE AT 3K FEET THERE IS NO PRESSURIZATION ISSUES. FABRICATED A SHIM. INSTALLED SHIM ON LOWER FORWARD MED SUPPORT ANGLE RADIUS IAW SRM 52-11-28. INSTALLED CUSTOMER SUPPSDR SWAA2025072995466Megaphone · inoperativeFWD MEGAPHONE INOPERATIVE. REMOVED AND REPLACED THE MEGAPHONE IAW AMM 25-64-00-SWA-804-NG-01.SDR SWAA2025072995697Flashlight · inoperativeFWD RIGHT FLASHLIGHT NOT TESTING. FLASHLIGHT REPLACED IAW AMM 25-64-00.SDR SWAA2025072995690Girt Bar · stuckGIRT BAR STUCK FORWARD ON SLIDE FWD GALLEY FO SIDE. RELEASED GIRT BAR ON SLIDE POUCH ON R1 GALLEY SERVICE DOOR IN REFERENCE TO AIRCRAFT MAINTENANCE MANUAL 25-66-00.SDR SWAA2025072995553Sign · looseOVERHEAD EXIT SIGN LOOSE. RESECURED AISLE EXIT SIGN REF AMM 33-51-01.SDR SWAA2025072995446Lamp · inoperativeAFT SERVICE DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED AFT SERVICE DOOR EXTERIOR EMERGENCY LIGHT LAMP REF AMM 33-51-04. OPS CHECK GOOD.SDR AALA202507290585Tire · explodedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING TAKEOFF ROLL LEFT MAIN TIRES EXPLODED. AIRCRAFT REJECTED TAKEOFF AND STOP ON THE RUNWAY. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR SIMA20250726001Control Module · malfunctionedAIRCRAFT NOT PRESSURIZING ON CLIMB OUT EMERGENCY DECLARED. FOUND PRESSURIZATION CONTROL MODE ON MANUAL ON OVERHEAD PANEL, PERFORMED OPS CHECK OF CPCS OUTFLOW VALVE PER AMM 21-31-02, AND RE-SET MODE TO AUTO. OPS CHECK GOOD A/C GOOD FOR SERVICESDR REXA2025072900763Lamp · inoperativeCEILING EMERGENCY FLOOD LIGHT FOUND INOP REMOVED AND REPLACED CEILING EMERGENCY FLOOD LIGHT BULB IAW CRJ 700 AMM 33-51-09. OPS CHECK GOOD.SDR AALA202507293029Latch · stickingAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR DIFFICULT TO OPEN. MAINTENANCE REPLACED THE FLIGHT DECK DOOR UPPER LATCH ASSEMBLY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 52-51-21.SDR AALA202507298011Bottle · low pressureAIRCRAFT IN BASE MAINTENANCE: LEFT HAND EMERGENCY EXIT DOOR 834 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE IS LOW. SERVICED DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202507299823Bottle · low pressureAIRCRAFT IN BASE MAINTENANCE: LEFT HAND EMERGENCY EXIT DOOR 833 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE IS LOW. SERVICED DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202507297298Filter · dirtyAIRCRAFT WAS NOT GROUNDED: LAVATORY SMOKE WARNING ECAM INFLIGHT AT CRUISE THAT SELF-CLEARED AFTER ABOUT 7 SECONDS. MAINTENANCE NOTED ON THE SMOKE WARNINGS REPORT REFLECTED FAULTS AT THE AFT LEFT LAVATORY SMOKE DETECTOR. MAINTENACE CLEANED DUST FROM THE SMOKE DSDR AALA202507292801Smoke Detector · false indicationAIRCRAFT WAS NOT GROUNDED: MOMENTARILY LAVATORY SMOKE , ECAM MESSAGE AT ALTITUDE. CABIN CREW INSPECTED ALL LAVATORIES, NO SMOKE PRESENT. UNABLE TO DETERMINE WHICH LAVATORY TRIGGERED THE ALERT. MAINTENANCE ACCOMPLISHED A FUNCTIONAL TEST AND OPERATIONAL TEST OF SDR DALA2025072905683Skin · damaged(LOG 1107254) FUSELAGE / SKIN / BTW BSTA 178 AND BSTA 188 AND BTW LBL 10 AND LBL 20 / LIGHTNING STRIKE. REPAIRED PER ERA 627647-14.SDR DALA2025072905680Seat Track · damaged(LOG 1107169) WHILE IN SLC, MTC REPORTED DAMAGE COMMON TO THE OTBD SEAT TRACK LOCATED AT SEAT ROW 27 ABC. ACCOMPLISHED ERA 627404-14 REV A, PRI REV 0 SEAT TRACK REPAIR AT SEAT ROW 27 ABC.SDR DALA2025072905679Seat Track · damaged(LOG 1106625) SEAT TRACK DAMAGE AT STA 727I AND SEAT ROW 27ABC. INSTALLED AND REPAIRED SEAT TRACK LH OTBD SECTION FROM 727G TO 727J PER B737-800 SRM 53-00-52-2R PROCEDURE 5 (001971) INSPECTED INSTALLATION OF REPAIR OF SEAT TRACK PER SRM 53-00-52-2R PROCEDURE 5SDR DALA2025072905678Floor Support · corroded(LOG 1106329) CORROSION ON FLOOR SUPPORT FROM STA 948-967 RLB 44 AT PAX CABIN. FLOOR SUPPORT FROM STA 948-967 RLB 44 AT PAX CABIN WAS REPLACED PER B737-800 SRM 51-40-02-0G.SDR CALA2025072907054Warning Message · false activationMAIN GEAR STEERING EICAS STATUS EITHER MAIN GEAR AFT AXLE IS MANUALLY DISABLED, IS NOT RESPONDIN G TO COMMANDS, OR LOSS OF ARINC 629 BUS INPUT FROM MAIN GEAR STEERING CONTROL UNIT. C/W MEL VERIFIED BOTH LEFT AND RIGHT PCA UNIT LOCKED IN CENTER POSITION , DEACTSDR CALA2025072907053Warning Message · multiple failAFTER T/O CA SIDE SPD LI M FLAG ILLUM. LOSS OF ST ALL SPD TAPE. LOST CA FD PITCH. INT SHAKER INFO FROM FLIGHT CREW: AFTER T/O CA SPD LIM FLAG APPEARED. LOST STALL SPEED TAPE. INTERMITTENT LOSS OF CA FD PITCH INDICATOR. INTERMITTENT STICK SHAKER ABOVE 18,000. SSDR CALA2025072907052Bleed Valve · faultedON CLIMBOUT LEFT BLEED ZERO PRESSURE NORMAL INDICATIONS ON START AND TAXI DEBRIEF CREW, LOST OF DUCT PRESSURE AT CLIMB OUT #1 ENGINE . (LEFT DUCT ZERO 0) (RIGHT DUCT PRESSUREGHT 50 PSI). ENGINE BEEN THE SOURCE. PREFORMED PNUEMATIC HEALTH CHECK REF. AMM 36-11-0SDR CALA2025072907035Brake · crackedNUMBER 3 MLG BRAKE PADS CRACKED/DAMAGED. REMOVED AND REPLACED NR 3 BRAKE IAW AMM 32-41-41.SDR CALA2025072907034Tire · damagedNUMBER 3 MAIN TIRE FLAT SPOT. REMOVED NR 3 MAIN TIRE R & R NR 3 MLG TIRE IAW AMM 32-45-11.SDR CALA2025072907029Light · broken24C EMERGNCY EXIT ROW LIGHT ASSEMBLY BROKEN REQUESTING DEFFERAL FOR 24C AILE EMERGENCY LIGHT NOT STAYING ON, RESECURED WITH INTERIOR TAPE AND LIGHT WORK NORMAL. APPROVED FWD TO MEL DDP FOLLOW *DM* REF CMM 25-22-55 M/L UPDATED WITH HOUSING 29-2522-3-0101, ATTASDR CALA2025072907027Slide · damagedGIRT BAR SLIDE RUBBER BACKING IS PEELING OFF ACCOMPLISHED ESCAPE SLIDE PACK CHECK AT DOOR 2L IAW AMM 25-66-01-200-802. NO DAMAGE FOUND THAT WOULD CAUSE THE SLIDE PACK TO OPERATE INCORRECTLY. OK F/SVCSDR CALA2025072907026Bottle · no discrepancyDOOR 4L/R PRESSURE GAUGE SHOWING IN THE RED BAND CHECKED BOTH 4L AND 4R DOOR MOUNTED ESCAPE SLIDE PACK PRESSURES AND FOUND TO BE SERVICEABLE AT THIS TIME IAW AMM TASK 25-66-01-206-041.SDR CALA2025072907025Switch · no discrepancyDOORS SEGMENT LITE ILLUMINATED FOR 2-3 SEC ON T/O ROLL...THEN EX T. ACP PSEU CK REF FIM 32-09 TASK 801 NO CURRENT OR PREV FLT FAULTS. INSPECTED FWD ENTRY AND SERVICE DOOR SWITCHES FOUND NO DEFECTS.SDR CALA2025072907024Girt Bar · faultedDOOR 1L DISARM BAR DOESNT STOW ALL THE WAY 52-11-00-862-001AND CLOSING THE ENTRY/SERVICE DOOR EXTERNALLY, TASK 52-11-00-862-002+OPENING THE ENTRY/SERVICE DOOR INTERNALLY, TASK 52-11-00-862-003 AND CLOSING THE ENTRY/SERVICE DOOR INTERNALLY, TASK 52-11-00-862-00SDR DALA2025072905677Fuel Line · leakingSHIP 9528 -DIV- TO ORD DUE TO LEFT FUEL QUANTITY LOSS. CORRECTIVE ACTION: MAINTENANCE FOUND A LEFT SHROUDED FUEL RETURN TO TANK LINE AND COUPLING LOOSE AND LEAKING, REPLACED THE INNER AND OUTER FUEL SHROUD "O" RINGS. ALL OPS AND LEAK CHECK GOOD.(7294538)SDR DALA2025072905674Oxygen Panel · misinstalledSHIP 3269 AFT LAV OXYGEN PANEL DOOR HAS STRINGS HANGING OUT THE SIDES. LOOKS TAMPERED WITH. SECURED O2 PANEL AND STOWED MASKS OK FOR SVC A320AMM 35-21. (LP: 1106540)SDR DALA2025072905673A/C Pack · faultedSHIP 3249 - DIV - TO PHX DUE TO A PACK 2 FAULT WITH PACK 1 ALREADY ON MEL. DESCENDED TO FL100, BUT COULD NOT CONTINUE DUE TO LAX APPROACH RESTRICTIONS. CORRECTIVE ACTION: REPLACED PACK 1 FLOW CONTROL VALVE, COMPRESSOR OUTLET TEMP SENSOR 12HH, AND OVERHEAT SENSSDR ASAA2025072659709Cover · looseFA REPORTS EXIT LIGHT COVER IS LOOSE NEAR COMPARMENT 4-22. GROUNDED - YES. REPLACED EXIT SIGN LIGHT ASSEMBLY AT R2 DOOR REF AMM 33-51-01. OPS CHECK GOOD.SDR AALA202507287380Battery · no testAIRCRAFT WAS NOT GROUNDED: LED FLASHLIGHT UNDER FORWARD FLIGHT ATTANDENT SEAT FLASHING RED. REMOVE AND REPLACED LED FLASHLIGHT BATTERY AND COMPLETED OPERATIONAL CHECK GOOD. PER AMM 25-64-00.SDR AALA202507285950Sign · dislodgedAIRCRAFT WAS NOT GROUNDED: EXIT SIGN ROW 16 HANGING FROM A WIRE. REINSTALLED EXIT SIGN. PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA202507282601Sign · missingAIRCRAFT WAS NOT GROUNDED: 16A EXIT SIGN LENS COVER WALL MOUNTED NEAR EXIT HATCH MISSING. REPLACED MISSING EXIT SIGN COVER. PER AMM 33-51-04.SDR SWIA202507280001Control Unit · warning messagePLEASE T/S ANTI-ICE DUCT WARNING EVENT AT NEXT MX VISIT. RECOMMEND CHECKING THE LOOPS ON THE LEFT SYSTEMMCI TYPE: TROUBLESHOOTING PRIORITY 1 (FLIGHT 5139 - FILED CLOSED)JUL 26, 2025 STATION: DEN--TROUBLESHOT ANTI-ICE DUCT MSG REFERENCING FIM 36-20-00. PERFORSDR SWIA2025072800006Warning Message · false activationANTI ICE DUCT WARNING MESSAGE MOMENTARILY THEN ANTI ICE CAUTION ASSOCIATED WITH L/R WING A/I CCAUTION MESSAGES. PERFORMED EMER CHECKLIST AND ANTI ICE DUCT MESSAGES DISAPPEARED. (FLIGHT 4903 - FILED CLOSED)INTERROGATED MDC FOUND NO CURRENT FAULTS POSTED AT THI