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 DALA2025082006222Seal · leakingDIVERSION TO MCI DUE TO DIRTY SOCK SMELL IN THE AFT CABIN. FOUND OIL BEHIND #2 ENGINE SPINNER. REPLACED #2 ENGINE FAN SHAFT COVER SEAL AND PERFORMED LEVEL B ECS DECONTAMINATION. RAN ENGINES NO LEAKS OR ODORS PRESENT. (LP 7859728)SDR DALA2025082006221Light · disconnectedDURING SVC CHECK FOUND MULTIPLE SEAT ROWS WITH EMERGENCY LIGHTS OUT. FOUND EMERGENCY LIGHTS DISCONNECTED AT ROWS 15 AND 39. RECONNECTED AS REQUIRED. FOUND CONNECTOR DAMAGED AT SEAT ROW 4. REPAIRED CONNECTOR PER A321 ESPM 20-51. (LP 7478697)SDR KCSA202508201131Hinge Fitting · wornR/H O/B AILERON NO.5 HINGE FITTING (79K) WORNSDR 2WAA20250820191Skin · corrodedRIGHT HORIZONTAL STABILIZER LEADING EDGE HAS CORROSION AT UPPER CENTER EDGE AREA AND LOWER SECTION. REPAIRED RIGHT HORIZONTAL STABILIZER LEADING EDGE PER E.O.'S WAA-250319, WAA-250623, AND E.O. WAA-250620.SDR BAGA2025082000007Power Supply · failedELPU FAULTY, EPSU 2 FAIL, REPLACED EPSU 2.SDR YENA2025082000853Unknown · odorFLT # 944, BZN-JFK. ODRO EVENT ON DESCENT OUT OF 11,000 FEET UNTIL LANDING SMELL DESCRIBED AS A CHEMICAL SMELL, BOTH FORWARD AND AFT CABIN; RAN APU, ENG 1 & ENG 2 WITH BOTH PACKS ON, NO ODOR NOTED, A/C OK FOR SVCSDR KCSA202508201130Hinge Fitting · wornR/H O/B AILERON NO.3 HINGE FITTING (59K) WORNSDR AALA202508203381Bottle · 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 AALA202508205007Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R3 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202508203488Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R2 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR KCSA202508201129Hinge Fitting · wornR/H O/B AILERON NO.1 HINGE FITTING (23K) WORNSDR KCSA202508201128Hinge Fitting · wornL/H O/B AILERON NO.5 HINGE FITTING (79K) WORNSDR 2WAA202508200190Skin · corrodedLEFT HORIZONTAL STABILIZER LEADING EDGE HAS CORROSION AT UPPER EDGE, ALL THRU THE LENGHT ALSO THE HARWARE OF LOWER EDGE IS RUSTY AND HAS CORROSION AROUND THE FASTENER HEAD. REPAIRED LEADING EDGE PER E.O.'S WAA-250220, WAA-250221, WAA-250222, WAA-250223, WAA-2SDR JR2R20250820703Skin · chafedRIGHT HAND WING LEADING EDGE PANEL, ABOVE PYLON, IS CHAFED OUT OF LIMITS. REPAIRED.SDR JR2R20250820702Skin · chafedLEFT HAND WING LEADING EDGE PANEL, ABOVE PYLON, IS CHAFED OUT OF LIMITS. REPAIREDSDR KCSA202508201127Hinge Fitting · wornL/H O/B AILERON NO.3 HINGE FITTING (59K) WORN.SDR KCSA202508201126Hinge Fitting · wornL/H O/B AILERON NO.2 HINGE FITTING (43K) WORNSDR KCSA202508201125Fitting · wornL/H O/B AILERON NO.1 HINGE FITTING (23K) WORN.SDR CALA2025082007965Bulb · no testWING ILLUMINATION LIGHTS - OPERATIONAL TEST PROCEDURE - LEFT LANDING LIGHT BULB DOES NOT PROVIDE ILLUMINATION UPON REMOVAL OF BULB NOTICED TERMINALS TO BE SINGED AND EMITTING AN ODOR. INSPECTED LEFT WING LANDING LIGHT (L33115) WIRES. FOUND ON WIRE W5164-0056-1SDR SCNA20250820329Slide · dislodgedR1 DOOR SLIDE PACK FELL OFF DOOR. REINSTALLED R1 ESCAPE SLIDE PACK AND COVER IAW AMM 25-66-01. OK FOR SERVICE.SDR IXXA20250820001Winglet · corrodedCORROSION ON THE T/E OF THE RIGHT WINGLET OUTBROAD SIDESDR KCSA202508201124Seat Track · crackedDAMAGED SEAT TRACK IN FWD PIT AT STA 560-580 LBL 40SDR KCSA202508201123Floor Support · crackedE/E BAY FLOOR AUX SILL CRACKED AT STA 400 RBL 29SDR REXA2026073001306Stiffener · crackedCRACK IN STIFFENER AT ACCESS 172CR. STIFFENER (P/N: SH670-39397-3) AT ACCESS 172CR WAS FABRICATED PER EA NO: CRJ953-19937 REV IR AND REPLACED PER CRJ-900 SRM 51-42-06-001-001-A01SDR 2026FA0000181Bulkhead · crackedFOUND SPINNER BULKHEAD CRACKED 273 HRS. REPLACED BULKHEAD WITH NEW P/N: 0550321-4SDR NACA2025081900001Shutoff Valve · stuckAPU ECU SELF TEST SHOWS FAULT IGV ACT. PERFORMED APU ECU BITE TEST IAW AMM 49-61-05-742-045. NO FAULTS FOUND. BITE TEST PASSED. FOUND APU SHUTOFF VALVE STUCK IN CLOSED POSITION & RELEASED THE VALVE, SYSTEM CHECKED OK IAW AMM 49-11-00-802-002.SDR SWI2025F01696Frame · corrodedCORROSION ON FRAME AT BS 1015, S26L - 25L. REMOVED AND REPLACED DAMAGED FRAME SECTION IAW SRM 53-00-06-201-001-A03, FIG. 53-00-06-991-877 , DWG. MM670-36062, REV. E, & DWG MM670-35007, REV W.SDR SWI2025F01695Stringer · corrodedUNDERFLOOR CORROSION BETWEEN BS 1000 - 1015, S26R. PREFORMED S26R REPAIR IAW SRM 53-00-03-201-001-A02. LEAK CHECKED GOOD.SDR SWI2025F01694Stringer · corrodedUNDERFLOOR CORROSION BETWEEN BS 1000 - 985, S26L. PREFORMED S26L REPAIR IAW SRM 53-00-03-201-001-A02, LEAK CHECKED GOOD.SDR SWI2025F01693Actuator · gougedRIGHT INBOARD VANE ACTUATOR GOUGED. COMPLIED WITH THE REPAIR OF RH FLAP INBD VANE ACTUATOR IAW REO 670-57-52-257, REV B. OPS CHECKED GOOD.SDR SWI2025F01692Subframe · corrodedSUB-FRAME BS 854 ON FWD WEB FACE AND BOTTOM ATTACH FLANGE FROM S25L TO 26R HAD CORROSION. INSTALLED NEW SUB-FRAME IAW SRM 51-42-06-001-001-A01, 51-42-21-001-001-A01, AND DWG SH690-37060, REV N.SDR SWI2025F01691Frame · corrodedFRAME BS 847+48. ON FWD WEB FACE & BOTTOM ATTACH FLANGE AT S27 HAD CORROSION. REMOVED AND WET INSTALLED NEW FRAME REPAIR SECTION -9. USING 2EA -11 ANGLE SPLICES AND 2EA -10 FRAME SPLICES IAW SRM 53-00-06-201-001-A03 COMPLIED WITH SKYWEST SKYCARD 51-900-1002-SKSDR SWI2025F01690Floor Support · corrodedCORROSION ON FLOOR SUPPORT LBL9 BETWEEN APPROX. FS1069 - FS1051.3. REMOVED AND INSTALLED NEW FLOOR SUPPORT SECTION IAW SRM 53-00-41-201-001-A03 AND REO 690-53-61-1671 REV-, STEP 1, 2, 3, 4, 5. AND COMPLIED WITH TASK CARD 51-900-1002-SKY.SDR SWI2025F01689Floor Support · corrodedCORROSION AND SCRATCHES ON FLOOR SUPPORT AT LBL 27 APPROX. BETWEEN FS1031 - FS985. REMOVED AND INSTALLED NEW FLOOR SUPPORT CAP IAW SRM 53-00-41-201-001-A03 AND COMPLIED WITHTASK CARD 51-900-1002-SKY.SDR SWI2025F01688Channel · corrodedUNDERFLOOR CORROSION BETWEEN BS 1031 - 1047, S27R. REMOVED CORROSION AND REPLACED CHANNEL ASSEMBLY PER SRM TASK 51-40-06-001-0010-A01 , SRM TASK 51-42-06-001-001-A01 , SRM TASK 51-45-00-001-001-A01 , DWG MM670-43255 REV. NC , DWG. MM670-43200 REV. N. C/W TASSDR SWIA20251202819Intercostal · corrodedINTERCOSTAL AT STGR27 BETWEEN FS865.00 AND FS881.00 HAS CORROSION ON WEB. REMOVED AND REPLACED CORRODED INTERCOSTAL AT STGR27 BETWEEN FS865.00 AND FS881.00 WITH NEW INTERCOSTAL IAW DRAWING SH690-37060 REV AC AND SRM 51-42-06-001-001-A01, REV 38.SDR IPXA2025101457211Support · crackedENG NR 2 INBD THRUST REVERSER LOWER LATCHES COVER SUPPORT HAS A CRACK. CLEANED AREA AT ENG NR 2 INBD THRUST REVERSER LOWER LATCHES COVER SUPPORT IAW AMM 12-21-12. REMOVED LOWER LATCHES COVER SUPPORT IAW SRM 51-40-21. INSTALLED NEW LONGERON ON NR 2 INBD THRSDR IPXA2025101357340Angle · crackedENG NR 2 PYLON AFT FAIRING SUPPORT I/B AREA HAS A CRACK. REMOVED MEMBER ASSY-PICKUP P/N: A5451520600000 AT ENG #2 PYLON AFT FAIRING SUPPORT I/B AREA IAW SRM 51-40-21. RECEIVED WELDED MEMBER ASSY P/N: UPA545152415000 ON TRAVELER T25/1831545. INSTALLED MEMBER SDR IPXA2025100951382Splice · crackedLEFT WING KRUEGER FLAP INSIDE AREA, OTBD STRUCTURE HAS A CRACK, 1.00 INCH LONG,SDR SWAA2025092906000Floorbeam · crackedCRACKED FLOORBEAM LOCATED BS 540 BTW BL 0 TO RBL RBL 24.75 WL 208.1 AT PASSENGER CABIN. REPLACED FLOORBEAM IAW SRM 51-40-02 AND DWG 143A0060; SHEET 64 AND REV -.SDR SWAA2025092606286Frame · corrodedCORROSION FRAME ON BS 951.07 BTW STR 16R TO STR 17R WL 210 AFT GALLEY AND LAV . PERFORMED BLENDOUT LOCATED ON FRAME BS 951.07 BTW STRINGER 16R AND STRINGER 17R WL 210 AT AFT GALLEY AREA. IAW EA# 25-153-02381-WIP1 & EA# 25-153-02381.<SDR 9WGA2025092554676Spar · corrodedDURING HEAVY MAINTENANCE, RT OUTER WING LOWER REAR SPAR HAS CORROSION AT APPROX XORS-581. 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 REARSDR REXA2025092500876Floor Support · corrodedCORROSION ON FLOOR SUPPORT BTW BS 280 - 319, RBL47. CORROSION ON FLOOR SUPPORT WAS EVALUATED OUT LIMITS IAW SRM 51-10-06-001-001-A01, REPLACED THE FLOOR SUPPORT IAW SRM 51-42-06-001-001-A01 AND SRM 51-42-10-001-001-A01.SDR SWAA2025092305982Access Panel · elongatedELONGATED HOLES ON ACCESS PANEL 561CB AT LT WING. REPAIRED ACCESS PANEL 561CB AT LT WING IAW B737-700 SRM 51-70-04-2R-10 REPAIR 10.SDR SWAA2025092305983Access Panel · elongatedELONGATED HOLES ON ACCESS PANEL 561AB AT LT WING. REPAIRED ACCESS PANEL 561AB AT LT WING IAW B737-700 SRM 51-70-04-2R-10 REPAIR 10.SDR SWAA2025091506237Plate · crackedLEFT WING TRAILING EDGE WAFFLE PLATE JUST OTBD OF PANEL 551DB FOUND CRACKED. REMOVED AND REPLACED THE LT WING TRAILING EDGE WAFFLE PLATE JUST OTBD OF PANEL 551DB IAW SRM 51-40-02-0G-0, AND DWG 115A2713.SDR REXA2025091500862Access Panel · corrodedINITIAL INSPECTION: CORROSION / CHAFE DAMAGE AT ALL SETTLEMENT AREA OF HYDRAULIC LOWER ACCESS PANEL 195AB. CORROSION / CHAFE DAMAGE AT ALL SETTLEMENT AREA OF HYDRAULIC LOWER ACCESS PANEL 195AB WAS REMOVED PER CRJ-900 SRM 51-21-06-001-001-A01 AND EVALUATED WITHSDR REXA2025091500861Bracket · wornINITIAL INSPECTION: WEAR AT FWD / AFT HANDRAIL SUPPORT FITTINGS AND ALSO MISSING BUMPERS. WEAR AT FWD / AFT HANDRAIL SUPPORT FITTINGS WAS EVALUATED DUE EXESSIVE DAMAGE AND WAS REPLACED ALSO MISSING BUMPERS WAS INSTALLED PER CRJ-900 SRM 53-00-00-101-001-A01 ANDSDR HNAA2025091400629Floor Support · corrodedCENTER OMGA BEAM FLOOR SUPPORT IS CORRODED BETWEEN FR.56-57. R&R CENTER OMGA BEAM GUSSET BETWEEN FR.56-57 IAW EMB 145 SRM 51-40-02.SDR HNAA2025091400626Beam · corrodedCARGO DOOR CUTOUT LOWER BEAM HAS MULTIPLE CORROSION SPOTS. R&R CARGO DOOR CUT-OUT LOWER BEAM IAW EMB 145 SRM 51-40-02.