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 CALA2025100609658Floor Support · corrodedFLOOR STRUCTURE PANEL SUPPORT AT STA 312-4" RBL12" IS CORRODED AT BOLT HOLE. REMOVED AND INSTALLED NEW FLOOR PANEL SUPPORT AT STA 312-4" RBL 12" PER SRM 51-40-02-0G-0 AND DWG 141A5410SDR CALA2025100609657Skin · nickedRIGHT FUSELAGE SKIN, AFT STATIC PORT HAS SMALL NICKS. SDR ENTRY WORKED PER UAL ECRA 5360-02034 SDR2033 ATTACHED FORM 44-0008SDR CALA2025100609656Filter · dirtyVERY MUSTY SMELL COMING FROM AIR VENTS TOMC LOCKED LP. PLEASE PERFORM CONDITIONAL INSP PER AMM 05-51-26-800-801-C1. PERFORM AC PACK BURN OUT AND REPLACE RECIRC FILTERS. REVIEWED WORK HISTORY AND FOUND #1 ENG WASH WAS JUST COMPLETED IN RDU LAST NIGHT DURING SDR CALA2025100609655Wire · damagedAILSE EMERGENCY LIGHT AT SEAT 8C INOP. REPAIRED RED VENDOR WIRE AT SEAT 8C REF WDM 33-51-21-1. REQUIRES OPS CHECK. PERFORMED OPS CHECK OF EMERGENCY AISLE LIGHT AT SEAT 8C. OPS CHECK GOOD, REF AMM 33-51-00SDR CALA2025100609622Chain · exposed2R GIRT BAR INFLATION CHAIN EXPOSED PERFORMED CHECK ON 2R GIRT BAR, INFLATION CHAIN IS PROPERLY SECURED AND NOT VISIBLE/EXPOSED. REF AMM 25-66-01SDR CALA2025100609621Latch · faultyESCAPE SLIDE INSTALL LATCH ASSEMBLY BROKEN REMOVED AND REPLACED ESCAPE SLIDE LATCH ASSY AT R2 DOOR REF AMM 25-66-01SDR CALA2025100609616Light · inoperativeDUE TO CAB LT MALF CYC CAB/UTIL SW AND EMER EXIT LTS ILLUM FOUND MX MSG 24-12045 "ELCU (UTIL BUS R) IN P200 IS NOT IN COMMANDED POSITION" LATCHED. FOLLOWED FIM 24-51 TASK 807. ACP'D ELMS POWER MANAGEMENT PANEL, P210 INITIATED EU SELF TEST PER AMM TASK 45-10-00SDR CALA2025100609615Guard · brokenFLIGHT DECK EMERGENCY LIGHT SWITCH GUARD ON P5 PANEL BROKEN. IPC 33-51-00-02 ITEM 15 REPLACED EMERGENCY LIGHT SWITCH GUARD REF IPC 33-51-00-02 ITEM 15. PERFORMED OPERATIONAL CHECK OF EMERGENCY LIGHTS REF 33-51-00AMM. OPS CHECK GOOD.PARTS USED: 29-3351-3-0037,SDR CALA2025100609607Smoke Detector · false activationLAVATORY E SMOKE ALARM SOUNDING AT GATE. NO SMOKE OR FUMES OBSERVED. CONFIRMED WITH FLIGHT CREW NO PRESENCE OF SMOKE. PERFORMED OPSCHECK OF LAV E SMOKE DECET. OPS CHECK GOOD AT THIS TIME. OK TO CONTINUE AT THIS TIMESDR CALA2025100609606None · odorSTRONG GASOLINE ODOR IN FRONT OF AIRCRAFT AND COCKPIT FAINT SMELL AFT OF THE AIRCRAFT THERE WAS A GASOLINE POWERED AIR CART ATTACHED TO THE AIRCRAFT. THE AIR FROM THE CART DOES NOT HAVE ANY GASOLINE ODOR. CART REMOVED FROM THE AIRCRAFT AND APU IS BEING USED TOSDR AALA202510060482Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER UPPER ATTACH ANGLE INBOUND CHORD, IN RIGHT HAND ECS BAY AFT BULKHEAD LOCATED AT BS 663, FROM RBL 5 TO RBL 15. REPAIRED PER SRM 57-10-10-2R-5.SDR KCSA202510041172Bottle · dischargedR-1 EPAS BOTTLE INADVERTENTLY DISCHARGEDSDR KCSA202510041171Battery · inoperativeREPLACE R-1 DOOR EPAS BATTERY FOR COMPANY CONVENIENCESDR REXA2026052800814Bolt · stuckA STUCK BOLT WAS DETECTED IN THE AILERON LUG T/E ALSO DAMAGE TO BOTH LUG 2 AND 3. A STUCK BOLT WAS REMOVED PER CRJ 900 SRM 51-40-11-001-001-A01 AND DAMAGE TO BOTH LUG 2 AND 3 WERE REPAIRED PER REO 690-57-51-482 REV. -ASDR IPXA2026040276511Floor Panel · damaged***MAJOR REPAIR*** MCD FLOOR PANEL O/B OF E&E HATCH FOUND DAMAGED (PICTURES ATTACHED) INSTALLED FLOOR PANEL, SEALED AND TAPED PANEL PER AMM 53-21-02.SDR SWIA202512260003Stringer · corrodedCORROSION FOUND ON STRINGER 19R BETWEEN FS364 AND FS379. REMOVED AND INSTALLED NEW FWD AND AFT STRINGER 19R INSERTS BETWEEN FS349 AND FS477 AND REPAIR SPLICE AND SHIM BETWEEN FS379 AND FS394. REF. SRM 51-42-06-001-001-A01, REO 690-53-21-2042 REV. - AND DWG# SSDR SWI2025F01862Floor Support · corrodedEXFOLIATING CORROSION FOUND ON RH PRESSURE FLOOR SILL STRAP AT FS559.00, WL73.00 BETWEEN RBL36.00 AND RBL45.00. REMOVED AND REPLACED THE RH PRESSURE FLOOR SILL STRAP AT FS559.00, WL73.00 BETWEEN RBL36.00 AND RBL45.00 IN REFERENCE WITH THE SRM 53-41-43 AND SRMSDR SWIA202512221003Floor Support · corrodedDURING INSPECTION AND CORROSION REMOVAL OF THE LH PRESSURE FLOOR SILL ASSY, FOUND 2 CRACKED NUTPLATE HOLES ON LH PRESSURE FLOOR SILL ASSY APPROX. FS 449.85 - FS 461.50 IN BETWEEN LBL 36.00 - 45.00. (C-CHECK RO 12/19/2025)PERFORMED REPAIR OF LH PRESSURE FLOOR SDR SWIA20251124003Floor Support · corrodedRIGHT FLOOR SUPPORT RBL 9 HAS CORROSION APPROXIMATELY BETWEEN BS 501 TO BS 565. REPAIRED THE FLOOR SUPPORT IAW REO 670-53-31-1112 REV -. TASK CARD 51-900-1002-SKY.SDR REXA2025111900989Drag Angle · crackedRIGHT AFT DRAG ANGLE IS CRACKED AT FORWARD END. REMOVED RH AFT DRAG ANGLE IAW SRM 51-42-13-001-001-A01, SRM 51-42-21-001-001-A01, AND SRM 51-42-22-001-001-A01. LOCATED, DRILLED, AND COUNTERSINK NEW SERVICEABLE RT AFT DRAG ANGLE IAW SRM 51-40-11-001-001-A01. ISDR SWAA2025110521056Support Bracket · crackedCRACK SUPPORT BRACKET LOCATED BS540 AT LEVEL RBL 6 AT RT AIR CONDITIONING BAY. REPLACED SUPPORT BRACKET AND FASTENERS LOCATED BS540 AT LEVEL RBL 6 AT RT AIR CONDITIONING BAY IAW SRM 51-10-02 Ï¿½TEM 9; 51-40-02 AND DWG:212A1116 SHEET:1.SDR SWAA2025110520966Support Bracket · crackedCRACK ON SUPPORT BRACKET LOCATED BS 867 BTW STR 2R TO STR 3R AT PASSENGER CABINREPLACED SUPPORT BRACKET LOCATED BS 867 BTW STR 2R TO 3R AT PASSENGER CABIN IAW B737-800 SRM 51-40-02 SRM 51-10-02 ITEM 9 AND DWG 146A7901 SHEET:66 REV:A.SDR SWAA2025110521063Support Angle · crackedCRACK SUPPORT ANGLE LOCATED BODY STA 663.75 AND LBL 10 AT AIR CONDITIONING BAY. REPLACED SUPPORT ANGLE IAW SRM 51-10-02; SRM 51-40-02. AND DRAWING 111A1000; SHEET 31; REV A.SDR SWAA2025110521057Support Beam · crackedCRACK SUPPORT BEAM NR 4 LOCATED FWD GALLEY DOOR. REPLACED SUPPORT BEAM NR 4 AND FASTENERS IAW SRM 51-10-02; SRM 51-40-02; DWG 141A6535, SHEET 13, REV -, AND DWG 141A6516, SHEET 142, REV -.SDR SWAA2025110521062Support Angle · crackedCRACK ON SUPPORT ANGLE LOCATED BODY STA 663.75 RBL 35 AT AIR CONDITIONING BAY. REPLACED THE SUPPORT ANGLE IAW SRM 51-10-02; SRM 51-40-02 AND DRAWING 111A1000; SHEET 31; REV A.SDR SWAA2025110520967Support Angle · crackedCRACK ON SUPPORT ANGLE BTW BS 380 - 400, LBL 13, WL 208.1. REPLACED SUPPORT ANGLE AND FASTENERS IAW SRM 51-40-02, DWG 143A5400, SHEET 138, REV -, & DWG 143A5400, SHEET 142, REV -.SDR SWAA2025110520965Support Angle · crackedCRACK ON SUPPORT ANGLE LOCATED BTW BS 380 TO BS 400 LBL 52 WL 208.1 AT PASSENGER CABIN. REPLACED SUPPORT ANGLE AND FASTENERS LOCATED BTW BS 380 TO BS 400 LBL 52 WL 208.1 AT PASSENGER CABIN IAW SRM 51-40-01, DWG 143A5400, SHEET 14, REV -, & DWG 143A5400, SHEESDR SWAA2025110520968Support Angle · crackedCRACK ON SUPPORT ANGLE LOCATED BTW BS 380 TO BS 400 RBL 39 WL 208.1 AT PASSENGER CABIN. REPLACED SUPPORT ANGLE AND FASTENERS LOCATED BTW BS 380 TO BS 400 RBL 39 WL 208.1 AT PASSENGER CABIN IAW SRM 51-40-02; DWG 143A5400; SHEET 140; REV- AND DWG 143A5400, SHEESDR AALA202511057065Seat Track · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN CABIN FLOOR SEAT TRACK BETWEEN FR 47.1-AND FR 47.2 AT +Y1292. REPLACED SEAT TRACK PER SRM 51-72-11.SDR SWAA2025110321085Support · corrodedCORROSION SUPPORT ZEE BETWEEN BS 727 - 767, S25R, WL 156. REPLACED SUPPORT ZEE AND FASTENERS IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, DWG 146A7500, SHEET 113, REV-, AND DWG 146A7502, SHEET 49, REV-.SDR SWAA2025110331271Support · corrodedCORROSION SUPPORT ZEE BETWEEN BS 727 - 767, S25R, WL 156. REPLACED THE SUPPORT ZEE AND FASTENERS IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, DWG 146A7500, SHEET 113, REV-, AND DWG 146A7502, SHEET 49, REV-.SDR SWAA2025103021090Web · crackedCRACK WEB CEILING AREA, BS 847 TO 867, LBL 19, AFT CARGO BAY. REPLACED WEB IAW SRM 51-40-02, SRM 51-10-02, ITEM 9, & DWG 149A8100, SHEET 1 REV -.SDR SWAA2025103021086Shield · corrodedCORROSION SHIELD WEB FLOOR STRUCTURE BS 767 TO 794.5, S25R, WL156, AFT CARGO COMPARTMENT. REPLACED SHIELD WEB AND FASTENERS IAW SRM 51-10-02, ITEM 9, AND INSTALLED FASTENERS IAW SRM 51-40-02, AND DRAWING 146A0081, SHEET 37, REV -.SDR SWAA2025103020975Support Bracket · crackedCRACKED SUPPORT BRACKET, BS 947.5, LBL 10 IN THE AFT CARGO COMPARTMENT. REPLACED SUPPORT BRACKET AND FASTENERS IAW SRM 51-40-02, SRM 51-10-02, ITEM 9, & DWG 149A8103, SHEET 7, REV A.SDR SWAA2025103020977Angle · crackedCRACK ANGLE LOCATED BS 867, LBL 10 IN THE AFT CARGO COMPARTMENT. REPLACED ANGLE LOCATED BS 867, LBL 10 IAW SRM 51-10-02, ITEM 9, AND INSTALLED FASTENERS IAW SRM 51-40-02, AND DRAWING 149A8102, SHEET 17, REV-. MEASUREMENT OF CRACK IS 0.550 INCH.SDR SWAA2025103021084Cargo Track · crackedCRACK CARGO TRACK RBBL 13.84 BS 727 IN THE AFT CARGO COMPARTMENT. REPAIRED THE CARGO TRACK BTW BS 727D- 787 IAW SRM 53-00-53-2R-3, REPAIR 3, ALTERNATIVE 1 AND 2.SDR SWAA2025103021088Cargo Track · crackedCRACK CARGO TRACK RBBL 13.84, BS 767 IN THE AFT CARGO COMPARTMENT. REPAIRED THE CARGO TRACK SECTION BS 727D - 787 IAW SRM 53-00-53-2R-3, REPAIR 3, ALTERNATIVE 1 AND ALTERNATIVE 2.SDR SWAA2025103021087Cargo Track · crackedCRACK CARGO TRACK RBBL 13.84 FRAME 747 AFT CARGO COMPARTMENT. REPAIRED CARGO TRACK RBL 13.84 BTW SECTION BS 727D - 787 IAW SRM 53-00-53-2R-3, REPAIR 3, ALTERNATIVE 1, AND ALTERNATIVE 2.SDR AALA202510295385Rod · excess playAIRCRAFT WAS NOT GROUNDED: LEFT WING, BETWEEN SPOILER NUMBER 5 AND 6, AFT OF AFT SPAR, INBOARD SIDE BOTH RODS HAVE EXCESSIVE PLAY. REMOVED AND REPLACED BEAM ASSEMBLY AT LEFT WING. PER B737NG SRM 51-40-02, SRM 51-40-05, SRM 51-20-01.SDR IPXA2025101379065Angle · crackedAVIONICS COMPARTMNT FR9 ANGLE CRACKED AT Y950. FABRICATED AND DRILLED NEW ANGLE FITTING FROM 2024-T3 .063C", B/N:0004276732. IAW SRM 53-12-15 FIG.7ITEM #80 AND UPS GMM-09.08.01.03, FOLLOW #4. INSTALLED NEW ANGLE FITTING IAW SRM 51-40-21.SDR SWAA2025102721109Support Angle · crackedCRACK ANGLE FLOOR STRUCTURE LOCATED STA695 AND LBL24.75 PASSENGER CABIN. REPLACED SUPPORT ANGLE AND FASTENERS LOCATED ON FLOOR STRUCTURE IAW SRM 51-40-02-0G-0, & DWG 273A9111, SHEET 6, REV A, AND DWG 111A6000, SHEET 178, REV-.SDR SWAA2025102721040Seal · crackedRIGHT HORIZONTAL STABILIZER UPPER FWD SLIDER SEAL IS CRACKED. REMOVED AND REPLACE RIGHT HORIZONTAL STABILIZER UPPER FWD SLIDER SEAL IAW AMM 53-31-31.SDR SWAA2025102721106Access Panel · damagedELONGATED HOLES ON ACCESS PANEL 571FB TRAILING EDGE AT LT WING. REPAIRED ACCESS PANEL 571FB TRAILING EDGE AT LT WING IAW B737-700 SRM 51-70-04-2R-10 REPAIR 10.SDR SWAA2025102721042Fairing · crackedNR 3 FLAP TRACK FAIRING HAS IMPACT DAMAGE; A CRACK AND IS DELAMINATED ON THE INSIDE WHERE THE ATTACHMENT BEAM MAKES CONTACT. REMOVED ATTACH BEAM AND ADJUSTMENT LINK ASSEMBLY FROM DAMAGED #3 FLAP TRACK FAIRING AND INSTALLED ON REPLACEMENT NR 3 FLAP TRACK FAIRISDR IPXA2025100965035Skin · gougedGOUGE - SKIN, RT WING OUTBOARD AFT FLAP AT WS900 - WS920. REPAIRED GOUGE DAMAGE RT WING OUTBD T/E FLAP AFT FLAP UPPER PANEL BETWEEN WBL 747.7 AND WBL 822.0 IAW EI F 2025A57M-2243, REV 2 AND EO-95508-REQ1 REV 1.SDR IPXA2025101379032Angle · crackedAVIONICS COMPARTMNT FR9 ANGLE CRACKED AT -Y950 JP-110. REMOVED WEB CRACKED RH SIDE IAW A300/600 SRM 51-40-21. INSTALLED NEW ANGLE FITTING IAW A300-600 SRM 51-40-21.SDR AALA202510237549Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT STA 312, LBL 43. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202510237031Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT STA 312, LBL 10. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR SWAA2025102221083Wedge · delaminatedLEFT INBD AFT FLAP WEDGE IS DELAMINATED. INSTALLED NEW NEW WEDGE ASSY INBD MAIND FLAP IAW 51-40-02-0G AND DWG 113A2100 REV A.SDR AALA202510201195Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE WEB AT BS 990, LBL 37. REPAIRED WEB PER EA 368782.