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 IPXA2025081718692Attach Angle · brokenFR 79 +Y1589.5 AFT SEAT TRACK ATTACHMENT ANGLE IS CRACKED THROUGH THE BOTTOM AFT FASTENER HOLE ON SEAT TRACK ATTACHMENT POINT. INSTALLED ANGLE WITH FASTENERS IAW SRM 51-40-21.SDR J7SA2025082600453Fce · faultedAP FAIL CAS FOLLOWED BY SWPS FAULT, FLAP FAIL, PTRIM BKP FAIL, AND SPOILER FAULT CAS ILLUMINATED WHILE CRUISING AT FL450. CREW FOLLOWED THE QRH AND LANDED WITHOUT INCIDENT. DURING DESCENT, THE SPEED TAPE DISPLAYED A CONTINUOUS MAX SPEED CAUTION UNTIL 3000 FT DSDR ASAA2025081760297Battery Pack · inoperativeEMERGECNY LIGHTS ASSOCIATED WITH POWER SUPPLY M1694 ARE INOP. GROUNDED - YES. REMOVED AND REPLACED BATTERY PACK M1694 AND TEST PASSED AIW B737-900 AMM 33-51-06-960-805.SDR ASAA2025081760296Battery Pack · inoperativeEMERGENCY LIGHTS ASSOCIATED WITH POWER SUPPLY M1695 ARE INOP. GROUNDED - YES. REMOVED AND REPLACED BATTERY PACK M1695 AND TEST PASSEDD IAW B737-900 AMM 33-61-06-960-805.SDR ASAA2025081760295Battery Pack · inoperativeEMERGENCY LIGHTS ASSOCIATED WITH POWER SUPPLY M1676 ARE INOP. GROUNDED - YES. REMOVED AND REPLACED BATTERY PACK M1676 AND TEST PASSED IAW B737-900 AMM 33-51-06-960-805.SDR ASAA2025081760294Battery Pack · inoperativeEMERGENCY LIGHTS ASSOCIATED WITH POWER SUPPLY M1671 ARE INOP. GROUNDED - YES. REMOVED AND REPLACED BATTERY PACK M1671 AND TEST PASSED IAW B737-900 AMM 33-51-06-960-805.SDR ASAA2025081760293Battery Pack · inoperativeEMERGENCY LIGHTS ASSOCIATED WITH POWER SUPPLY M1670 ARE INOP. GROUNDED - YES. REMOVED AND REPLACED BATTERY PACK M1670 AND TEST PASSED IAW B737-900 AMM 33-51-06-960-805.SDR AALA202508254942Slat · out of rigAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: LEADING EDGE FLAPS WERE RAISED BUT THE FLAPS TRANSIT LIGHT REMAINED ILLUMINATED, RECYCLE FLAPS DID NOT HELP. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT LAX. REMOVED AND REPLACED OUTBOARD SLATSDR AALA202508259181Target · damagedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: LEADING EDGE FLAPS WERE RAISED BUT THE FLAPS TRANSIT LIGHT REMAINED ILLUMINATED, RECYCLE FLAPS DID NOT HELP. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT LAX. REMOVED AND REPLACED OUTBOARD SLATSDR AALA202508256316Sensor · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: LEADING EDGE FLAPS WERE RAISED BUT THE FLAPS TRANSIT LIGHT REMAINED ILLUMINATED, RECYCLE FLAPS DID NOT HELP. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT LAX. REMOVED AND REPLACED OUTBOARD SLATSDR 3EJA20250825172Door Seal · no discrepancyBRINGING THE THRUST LEVERS UP TO 75-80% HEARD A NOISE; LOOKED AT THE PRESSURIZATION CONTROL AND SAW THAT WE WERE LOSING PRESSURE, WITH THE CABIN CLIMBING (AT THAT TIME) AT 3600' PER MINUTE. IMMEDIATELY INITIATED AN EMERGENCY DESCENT. INSPECTED DOOR SEAL, NO DASDR 9WGA2025082354639Spar · corrodedDURING HEAVY MAINTENANCE CHECK RH OUTER WING LOWER REAR SPAR HAS CORROSION @ APPROX. (XORS-799). AFTER FURTHER EVALUATION, BOEING CERTIFIED THE BLENDED LOCATION AS A PERMANENT REPAIR AND BEEN ACCOMPLISHED WITH ALL THE REQUESTED PROVISIONS, AT RH OUTER WING LOSDR 9WGA2025082354638Spar · corrodedDURING HEAVY MAINTENANCE CHECK RH OUTER WING UPPER REAR SPAR HAS CORROSION @ APPROX. (XORS-608). AFTER FURTHER EVALUATION, BOEING CERTIFIED THE BLENDED LOCATION AS A PERMANENT REPAIR AND BEEN ACCOMPLISHED WITH ALL THE REQUESTED PROVISIONS AT RH OUTER WING UPPSDR 9WGA2025082354637Spar · corrodedDURING HEAVY CHECK RH OUTER WING LOWER REAR SPAR HAS CORROSION AT APPROX XORS-601. AFTER FURTHER EVALUATION, BOEING CERTIFIED THE BLENDED LOCATION AS A PERMANENT REPAIR AND BEEN ACCOMPLISHED WITH ALL THE REQUESTED PROVISIONS AT RH OUTER WING LOWER REAR SPAR ASDR 9WGA2025082354635Spar · corrodedDURING HEAVY CHECK RH OUTER WING LOWER REAR SPAR HAS CORROSION AT APPROX (XORS-581.SDR 9WGA2025082354634Spar · corrodedDURING HEAVY CHECK RH OUTER WING LOWER REAR SPAR HAS CORROSION @ APPROX (XORS-574).SDR 9WGA2025082354633Spar · corrodedDURING HEAVY CHECK RH OUTER WING LOWER REAR SPAR HAS CORROSION @ APPROX (XORS-536). ACCOMPLISHED STRAP AND SHIM REPAIR AT R/H WING OUTER LOWER REAR SPAR AFT FLANGE AT XORS 544.000 IAW MD-11 SRM 51-35-01 AND BOEING MESSAGE WGA-WGA-26-0020-01C. THE AIRCRAFT WASDR 9WGA2025082354632Spar · corrodedDURING HEAVY MAINTENANCE LH OUTER WING UPPER REAR SPAR HAS CORROSION @ APPROX (XORS-694). AFTER FURTHER EVALUATION BOEING CERTIFIED THE BLENDED AREAS AS A PERMANENT REPAIR AND BEEN ACCOMPLISHED WITH ALL THE REQUESTED PROVISIONS AT LH OUTER WING UPPER REAR SPASDR 9WGA2025082354631Spar · corrodedDURING HEAVY MAINTENANCE LT OUTER WING UPPER REAR SPAR HAS CORROSION @ APPROX (XORS-702). FTER FURTHER EVALUATION BOEING CERTIFIED THE BLENDED AREA AS A PERMANENT REPAIR AND BEEN COMPLETED WITH ALL THE REQUESTED PROVISIONS AT LH OUTER WING UPPER REAR SPAR AT SDR DALA2025082206259Seat Track · corrodedG7 INBD GALLEY TRACK CORRODED. REPAIRED THE SEAT TRACK IAW SRM 53-20-52-2R. (1149132)SDR DALA2025082206256Cusp Web · corrodedCORROSION ON UPPER SURFACE OF CUSP WEB ADJACENT TO STA 237 FRAME ATTACH FITTING AT X60. REPAIRED CUSP WEB PER SRM 53-00-55-2R (1149078).SDR DALA2025082206254Elec Connector · dirtyAFT EMERGENCY LIGHT FLASHING. CLEANED CONNECTOR ON EMERGENCY LIGHT BATTERY PACK B5-260 AND OPS CHECKED IAW AMM 33-51, CHECKED GOOD (7280156).SDR CALA2025082208044Channel · corrodedAFT CARGO BAY LH 'Z' CHANNEL HAS MULTIPLE SPOTS OF CORROSION FROM BS 727H - 787. R & R LT ZEE CHANNEL AT AFT CARGO BAY IAW SRM 51-40-02-0G-0. REMOVED CORROSION ON CHANNEL IAW SRM 51-10-02-0G-0. EVALUATED REWORKED AREA ORIGINAL MAT: 0.040" MAT LOSS" 0.001" RSDR SWAA2025082105390Power Supply · inoperativeEMERGENCY LIGHTS AT RH AFT OVERWING LOWER DOOR LIGHT; ROW17FED; 21FED, & 25FED DO NOT COME ON. REMOVED AND REPLACED IAW AMM 33-51-06-960-806-NG.SDR DALA2025082106246Winglet · damagedFOUND LIGHTNING STRIKE DAMAGE ON RH WINGLET TIP. BLENDED DAMAGE PER A220-ASRP-57-32-02-01AAA-664A-A.(TJ 538079) COMPLIED WITH HFEC INSPECTION OF THE BLENDED AREA ON THE RH WINGLET TIP-NO DEFECTS OR CRACKS NOTED ON INSPECTION PER A220 ANDTP 51-01-08-01AAA-353A-SDR DALA2025082106237Housing · brokenOXYGEN PANEL LATCH BROKEN, COMPARTMENT OPENED DURING TAKEOFF. THE LATCH IS BROKEN. I WAS ABLE TO GET EVERYTHING BACK IN AND CLOSE IT BUT IT NEEDS TO BE REPAIRED. CONFIRMED ITS NOT THE LATCH BUT THE HOUSING ITSELF THAT IS BROKEN. INSPECTED PSU LATCHES. AND HISDR DALA2025082006234Panel · erodedNUMBER 1 ENGINE PYLON PANEL 414FR HAS EROSION DAMAGE. REPAIRED PER ER/A 628632-14. (7744524)SDR AALA202508206800Outlet · inoperativeAIRCRAFT WAS GROUNDED: AFT PUSHBACK FLIGHT ATTENDANTS AND PASSENGERS REPORT THE PLASTIC SMELL IS GETTING WORST IN THE CABIN. DURING INSPECTION FOUND PC OUTLET UNIT INOPERATIVE. REMOVED AND REPLACED PC OUTLET UNITS AT SEATS 12D (AALA202508204260), 13C (AALA202SDR AALA202508206697Outlet · inoperativeAIRCRAFT WAS GROUNDED: AFT PUSHBACK FLIGHT ATTENDANTS AND PASSENGERS REPORT THE PLASTIC SMELL IS GETTING WORST IN THE CABIN. DURING INSPECTION FOUND PC OUTLET UNIT INOPERATIVE. REMOVED AND REPLACED PC OUTLET UNITS AT SEATS 12D (AALA202508204260), 13C (AALA202SDR AALA202508204260Outlet · inoperativeAIRCRAFT WAS GROUNDED: AFT PUSHBACK FLIGHT ATTENDANTS AND PASSENGERS REPORT THE PLASTIC SMELL IS GETTING WORST IN THE CABIN. DURING INSPECTION FOUND PC OUTLET UNIT INOPERATIVE. REMOVED AND REPLACED PC OUTLET UNITS AT SEATS 12D (AALA202508204260), 13C (AALA202SDR WX0A2025082032546Cover · broken(AIRCRAFT GROUNDED) L1 DOOR OVER HEAD EMERGENCY L16T7 COVER BROKEN / INSTALLED NEW OVER HEAD EMERGENCY LIGHT COVER ON L1 DOOR IN REF 33-51-11-400-001-A."SDR NACA2025081700001Cooler · failedRIGHT ENGINE OIL QTY DROPPED FROM 17 UNITS TO 12 DURING FLIGHT. SUSPECT OIL LEAK STILL PRESENT. FOUND OIL PUDDLING AT 6 OCLOCK OF ENGINE WITH EVIDENCE OF OIL LEAKAGE ON THE LH SIDE OF ENGINE CORE EMANATING FROM AIR/OIL COOLER. REMOVED AND REPLACED #2 ENGINE AISDR AALA202508203598Tube · missingAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS GIRT BAR RED HEATSHRINK MISSING AT AFT LEFT L2 DOOR. INSTALLED HEATSHRINK ON L2 DOOR GIRT BAR. PER AARD 25-66-00-4.SDR CALA2025082007975Pressure Sensor · faultedBLEED OFF ENG R EICAS ADVISORY RIGHT ENGINE BLEED VALVE CLOSED FOR SYSTEM FAULT OR SWITCH OFF, AND THE ENGINE IS NOT SHUTDOWN. FIM TASK REF : FIM TASK REFERENCE NOT FOUND CMC MSG# 3610470 AIR SUPPLY & CABIN PRES SURE CONTROLLER (R) IP SENSOR FAIL 36-10470 FSDR CALA2025082007962Bracket · looseGIRT BAR 1L BRACKET LOOSE. NEEDS ADJUSTMENT FOUND 1L DOOR GIRT BAR FWD FLOOR BRACKET SPRING LOADED RETAINING CLIP STUCK. CLEANED AND EXERCISED SPRING CLIP. OPS CHECK GOOD.SDR CALA2025082007961Girt Bar · out of limitsEXCESS SLIDE MATERIAL ABOVE GIRT BAR DOOR 1R. RETUCKED GIRT Z-FOLD TO PROPER GIRT PAYOUT DIMENSION PER AMM 25-66-01-400-801 D (2)(C)(D).SDR CALA2025082007960Tape · wornRED TAPE ON GIRT WORN. EMERGENCY ESCAPE SLIDE INSPECTION {B737-25-3-1066} - REMOVED AND REPLACED L1 EMERGENCY ESCAPE SLIDE AFT END OF GIRT BAR RED COLORED NYLON TAPE PER AMM 25-66-01.SDR CALA2025082007959Pin · installedINSTALLED DOOR L4 CYLINDER SAFETY PIN ASSEMBLY INTO THE INFLATION CYLINDER VALVE ON THE SLIDE PACK IAW AMM25-66-01-004-154. REMOVED DOOR L 4 CYLINDER SAFETY PIN ASSEMBLY OUT OF INFLATION CYLINDER VALVE ON A SLIDE PACK IAW AMM25-66-01-404-044. REF: LOG PAGE 594SDR CALA2025082007958Girt Bar · out of limitsESCAPE SLIDES/RAFTS - INSPECTION - GIRT BAR FITTING ASSEMBLY ON L2, HAS LOST SPRING BACK AND NEEDS REPLACING. REMOVED AND REPLACED GIRT BAR ASSEMBLY FORWARD FITTING AT PASSENGER ENTRY DOOR LEFT 2 P/N421Z0589-5041, REF IPD 52-11-18-110-941A FIG ITEM 30, AND ASDR ASAA2025081760196Cover · missingLOWER "EXIT SALIDA" LIGHT COVER MISSING R-2 DOOR. GROUNDED - YES. REMOVED AND REPLACED LOWER EXIT SIGN LIGHT ASSY AT R2 DOOR REF AMM 33-51-01-960-802. LIGHTS TEST PASS. OPS TEST PASS. OK FOR SERVICE.SDR ASAA2025081760147Sign · looseFA REPORTS LOWER EXIT ROW SIGN SEATS 16 A-C LOOSE. GROUNDED - YES. REMOVED AND REPLACED LOWER EXIT ROW SIGN SEATS 16 A-C. OPS CHECK GOOD REF AMM 33-51-01.SDR AALA202508197813Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR DIFFICULT TO OPEN FROM OUTSIDE DOOR (CABIN SIDE). LUBED COCKPIT DOOR.SDR AALA202508194810Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR DIFFICULT TO OPEN. READJUSTED AND LUBED LEFT AFT LAVATORY DOOR AND TRACKS. PER AMM 25-40-00.SDR SWAA2025081905343Shield · brokenAFT LT OTBD EMERGENCY FLASHLIGHT SHEILD BROKEN. R&R FLASHLIGHT SHEILD REF AMM 25-64-00.SDR SWAA2025081905397Bracket · looseAFT ENTRY SLIDE BRACKET LOOSE. SECURED SLIDE PACK AND COVER HARDWARE IAW AMM 25-66-01.SDR SWAA2025081905551Hook · looseCA SIDE FWD ENTRY DOOR GIRT BAR HOOK IS REPORTED LOOSE BY FA.<[01] ADJUSTED FWD ENTRY DOOR GIRT BAR HOOK PER SIP. OPS CHECK GOOD.SDR SWAA2025081905550Brake · malfunctionedEXTREME BRAKE SHAKE WHILE STOPPING DURING TAXI. R&R NR 2 MAIN BRAKE ASSY PER AMM 32-41-41-401-NG,SDR SWAA2025081905554Lens · detachedRIGHT OVERWING EXIT FLOOR LEVEL EMERGENCY EXIT LIGHT COVER FELL OFF. REPLACED EMERGENCY EXIT LIGHT LENS AT FLOOR LEVEL IAW AMM 33-51-01.SDR SWAA2025081905556Cover · detachedRIGHT OVERWING EXIT LIGHTED EMERGENCY EXIT COVER FELL OFF. RESECURED COVER IAW AMM 33-51-01.SDR SWAA2025081905306Battery Pack · inoperativeINTERIOR EMERGENCY EXIT LIGHT AT FWD ENTRY DOOR INOP. REMOVED AND REPLACED THE FWD LEFT POWER SUPPLY BATTERY PACK AND OPS TESTED GOOD IAW AMM 33-51-06.