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 AALA202508310311Handle · looseAIRCRAFT WAS NOT GROUNDED: CREW REPORTED 3R DOOR SLIDE ARM HANDLE IS LOOSE. MAINTENANCE RETORQUED SLIDE ARM HANDLE PER AMM 20-21-00.SDR AALA202508319792Screw · looseAIRCRAFT WAS NOT GROUNDED: DOOR 3R ARMING LEVER IS LOOSE. MAINTENANCE TIGHTENED LOOSEN SCREW ON DOOR 3R ARM LEVER PER AMM 20-21-11.SDR AALA202508315562Handle · looseAIRCRAFT WAS NOT GROUNDED: CREW REPORTED 3L DOOR SLIDE ARM HANDLE IS LOOSE. MAINTENANCE RETORQUED SLIDE ARM HANDLE PER AMM 20-21-00.SDR AALA202508311091Bottle · low pressureAIRCRAFT WAS GROUNDED: L1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202508316173Megaphone · no testAIRCRAFT WAS NOT GROUNDED: AFT CABIN MEGAPHONE INOPERATIVE. REPLACED MEGAPHONE AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 25-65-51.SDR DALA2025083006415Skin · dentedDURING HCK AT QRO, WHILE PERFORMING AN EXTERNAL FORWARD PASSENGER COMPARTMENT ZONAL INSPECTION PER WC 5330-2112. DENT AND GOUGE WERE FOUND AFFECTING THE FUSELAGE SKIN BETWEEN STA 500 500A AND BETWEEN S-9R TO S-10R. TRIMMED OUT THE DAMAGE, PERFORM INSPECTIONSSDR DALA2025083006414Stringer · corrodedAFTER REMOVE ACCESS PANEL N/P 284A6813-3 ON INTERNAL FWD E/E: CORROSION WAS FOUND ON S-L28-LH BTW STA.348.2 TO STA.380. CORROSION LEVEL 2, STRINGER 28 LH BTW STA 380 TO STA 362 WAS REPAIRED PER B737-800 SRM 53-00-03-2R PROCEDURE 1. REPAIR 1. (LP 1171591)SDR DALA2025083006413Web · puncturedTHREE PUNCTURES ON FWD RH WEB ON APU COMPARTMENTE ALSO WEAR ON STIFFENER BEHIND OF WEB. FWD RH WEB ON APU COMPARTMENTE WAS REPAIRED PER B737-800 SRM 51-70-13-2R-1 REPAIR 1 AND STIFFENER BEHIND OF WEB WAS BLENDED OUT PER B737-800 SRM 51-10-02-0G PAR.6.A, STIFSDR QMLA2025083020092None · noneSTARTER GENERATOR INSPECTION OVERFLOWNSDR N6WA2025083001Seat Track · corrodedCORROSION ON RH SEAT RAIL AT FS581-FS708. REMOVED AND REPLACED SEAT RAIL AT FS581-FS708 ON RH SIDE IAW CRJ AMM 51-00-49SDR HALA20250830266Apu · shutdownETOPS - APU AUTO SHUTDOWN. PER ENGINEERING REMOVED AND REPLACED FLOW DIVIDER ASSY PER AMM 49-31-51. LEAK CHECK OK, CONDITION SAME. REINSTALLED ORIGINAL FLOW DIVIDER. REMOVED AND REPLACED APU PER T/C 330-49-HWI-02. OPS/LEAK CHECK GOOD. OK FOR SVC.SDR HALA20250830265Door · crackedETOPS - #1 ENGINE LEFT HAND LOWER T/R PIVOT DOOR HAS A CRACK IN ACTUATOR CHANNEL FAIRING. PERFORMED REPAIR OF THE CRACK ON ACTUATOR CHANNEL IAW RB211 TRENT SRM REPAIR NO.9 (FRSX10) A/C OK FOR SVC. NO FURTHER ACTION / INSPECTIONS NEEDED. SRM REF: 54-30-02 OF THSDR DALA2025082906408Lamp · inoperativeEXTERIOR EMERGENCY EXIT LIGHT ADJACENT AFT PAX DOOR INOP. RELAMPED EXTERIOR EMERGNCY EXIT LIGHT ADJACENT THE AFT PAX DOOR. (LP 6524503)SDR DALA2025082906401Window Frame · crackedCRACK INDICATION WAS FOUND AT LH & RH (MIDDLE CENTER POST AND LOWER CORNER RADIUS AREA) FRONT WINDSHIELD FRAMING AND AT LH CONTINUITY FITTING. REPLACED PER ERA 627625-14. (1170092)SDR JR2R20250829000Strap · corrodedUPPER STRAP ON BEAM AT RBL10 BETWEEN FR85-FR86 IS CORRODED.SDR JR2R20250829010Seat Track · corrodedMOP SILL THAT SITS ON TOP OF FR84 CROSSBEAM AT APPROXIMATELY RBL36 IS CORRODED.SDR JR2R20250829095Seat Track · corrodedFWD WET AREA, SEAT TRACK BEAM AT RBL10 IS CORRODED IN MULTIPLE AREAS AT FR17 AND FR12.SDR JR2R20250829976Intercostal · corrodedAFT WET AREA INTERCOSTAL AT RBL10 BETWEEN FR89-FR90 CORRODED.SDR IPXA2025082916221Circuit Breaker · trippedCOULDN`T GET MAIN ENTRY DOOR TO CLOSE. FOUND LEFT CABIN DOOR FWD POWER CIRCUIT BREAKER POPPED. RESET CIRCUIT BREAKER IAW AMM 20-30-13-865-801. PERFORMED OPS CHECK OF DOOR NUMEROUS TIMES OPS CHECKS GOOD IAW AMM 52-11-02. THIS CLEARS DEFERRAL 2854970.SDR JR2R20250829809Shear Tie · corrodedSHEAR TIE CORRODED AT FR76 BETWEEN STR29L - STR28LSDR JR2R20250829811Shear Tie · corrodedSHEAR TIE CORRODED AT FR88 BETWEEN STR27R - STR28RSDR JR2R20250829975Gusset · corrodedAFT WET AREA GUSSET AT FR90 RBL10 IS CORRODED.SDR JR2R20250829973Shear Panel · corrodedAFT WET AREA R/H SHEAR PANEL CONNECTION SPLICE AT APPROXIMATELY RBL36 BETWEEN FR87-FR88 IS CORRODED AROUND RIVETS.SDR 2025FA0000590Window Frame · corrodedDURING COMPLIANCE WITH SB525C-56-01 CORROSION FOUND ON ALL WINDSHIELD FRAMES AND SURROUNDING STRUCTURE REQUIRING REPLACEMENT OF ALL COCKPIT WINDSHIELD FRAMES AND ATTACHING SKINS.SDR FDEA202508291567Door · crackedMAIN DECK CARGO DOOR UPR EDGE AT PT1 BETWEEN FR22 AND FR25 FOUND CRACK SIGNAL ON 6EA FASTENER HOLES REPAIRED THE MAIN DECK CARGO DOOR UPR EDGE PT1 BETWEEN FR22 AND FR25 6EA CRACKED FASTENER HOLES PER EA 6-5230-T0384742 P1, TITLE: DOORS - CARGO DOOR / HYD SSDR FDEA202508291566Skin · delaminatedRH WING #3 SPOILER CENTER I/B HINGE ARM OUTSIDE SURFACE FOUND DELAMINATION. SIZE: 43 MM*25MM, DEPTH: 1.2MM COMPLIED WITH EA: 6-5750-T0384693 P1. TITLE: WING - FLIGHT SURFACES - RT NR 3 SPOILER CENTER HINGE ARM AREA DELAMINATION. REPAIRED THE RT WING NR 3 SPOILSDR FDEA202508291565Flap · misrepairedEXISTING REPAIR ON RH WING OUTER FLAP LEADING EDGE SKIN BETWEEN RIB14 AND RIB17 REQUIRES EVALUATION FOR CONFORMITY THE EXISTING REPAIR ON RH WING OUTER FLAP LEADING EDGE SKIN BETWEEN RIB14 AND RIB17 WAS EVALUATED & FOUND NOT IN CONFORMITY WITH SRM 57-50-0SDR 2025F00215Access Panel · detachedUPON LANDING PANEL #'S 411GR & 411DL DEPARTED THE ENGINE. DAMAGE TO FOLLOWING COMPONENTS: L/WING #2 FLAP (15"X6" LOWER & 3X2) UPPER, OUTER SECTION OF EXHAUST NOZZLE, PANEL #'S 411PL & 411QR, BLOCKER DOORS #'S 1.2.3.4 & 8.SDR 2025F00214Skin · damagedREPAIRED CORROSION UNDER THE BAGGAGE FLOOR BOARDS ON THE TAILCONE SKIN AND STRINGERS BETWEEN FS 501.25 AND FS 548.50 PER AQRD ERO-985795 REV.A, TITLED "N357QS TAILCONE SKIN CORROSION" DATED AUG 28, 2025. SUPPORTED BY FAA FORM 8110-3 DATED 08/28/2025. THE FATIGSDR JR2R20250829974Shear Panel · corrodedAFT WET AREA R/H SHEAR PANEL BETWEEN FR87-FR88 IS CORRODED.SDR JR2R20250829084Sill Drain · corrodedAFT WET AREA L/H MOP SILL BETWEEN FR88-FR90 IS CORRODED AT FWD EDGE.SDR AALA202508294189Switch · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHTS WILL NOT SHUT OFF IN THE OFF POSITION IN CKPT. MAINTENANCE REPLACED SWITCH 4WL IAW ESPM 20-45-21.SDR JR2R20250829996Beam · corrodedAFT WET AREA BEAM AT LBL10 IS CORRODED BETWEEN FR88-FR89.SDR JR2R20250829096Doubler · corrodedFWD WET AREA, DOUBLER JUST O/B OF LBL10 SEAT TRACK BEAM AROUND FR16 IS CORRODED AT AFT EDGE.SDR KCSA202508291148Longeron Fitting · crackedFOUND R/H LONGERON EXTENSION FITTING TO BE CRACKED WITH EDDY CURRENT INSPECTIONSDR ABXA20250829201Warning Light · illuminatedDURING TAXI, MAIN CARGO DOOR LIGHT ILLUMINATED WHILE STARTING ENGINES. AIRCRAFT RETURNED TO BLOCKS. (BTB) MAINTENANCE DEFERRED IAW MEL C ABX-52-32-1-3. AIRCRAFT RETURNED TO SERVICESDR 2025F00209Power Supply · dischargedL1 DOOR EMERGENCY LIGHTS INOP.28-AUG-25 LP 60909.SDR CALA2025082908271Lamp · inoperativeEMERGENCY LIGHTS - OPERATIONAL TEST WITH THE TEST SWITCHES PROCEDURE, EMERGENCY AREA LIGHT IN MID AFT LAV CROSSOVER AISLE CEILING L33490 INOPERATIVE RELAMPED IAW AMM 33-51-03-960-801 OP CK OK.SDR SWIA2026022705380Frame · damagedREMOVED FRAME SEGMENT 18-20L STGR FS 295.00 TO FACILITATE REPLACEMENT OF STGR 20L. INSTALLED FRAME SEGMENT BS 295, STGR 18L - STGR 20L IAW SRM 51-42-06, SRM 51-42-21 AND REO 670-53-21-2688 REV--. PERFORMED EDDY CURRENT INSPECTION WITH REFERENCE TO NDTM 53-0SDR SWIA202512120828Floorbeam · crackedRBL 12 COCKPIT FLOORBEAM IS CRACKED ON OTBD SIDE WHERE IT ATTACHES TO BS 280. PERFORMED REPAIR OF FLOORBEAM IAW AMM 20-70-00, SRM 51-42-06, 51-42-21, 51-40-11, 51-21-11, 51-25-06, & REO 670-53-11-896, REV -. PERFORMED NDT ET INSPECTION. SEE REPORT FOR DETAISDR SWI2025F01821Floorbeam · crackedLBL 12 COCKPIT FLOORBEAM CRACKED ON OTBD SIDE, WHERE IT ATTACHES TO BS 220. PERFORMED REPAIR IAW SRM 51-42-06, 51-42-21, 53-00-00, 51-21-11, 51-25-06, 51-40-11, 51-25-16, & REO 670-53-11-896, REV -. PERFORMED NDT ET INSPECTION.SDR SWI2025F010560Hinge · damagedPAX DOOR HINGE, FUSELAGE SIDE, FWD 2EA LUGS HAVE IMPACT DAMAGE ON THE UPPER AREA (MARKED) (C-CHECK RO 11/22/2025)REMOVED GOUGE ON PAX DOOR HINGE, FUSELAGE SIDE, FWD 2 EA IAW CRJ 700 SRM 53-21-23-201-010-A01 TYPE I REPAIR ANS CRJ-700-SRM-51-12-00-001-001-A01. SDR SWI2025F01561Hinge · damagedPAX DOOR HINGE, DOOR SIDE, THE FIRST LUG BORE HAS IMPACT DAMAGE/OVAL SHAPED NO THE FORWARD SIDE (MARKED) (C-CHECK RO 11/22/2025)REMOVED AND INSTALLED NEW PAX DOOR HINGE HALF. REF: CRJ-700 SRM 52-11-01-201-002-A01 AND DRAWING 601R31702 REV N, COMPLIED WITH SKSDR IPXA2025100212155Bracket · crackedFWD CARGO, FR 38.2, STRAP SUPPORT PANEL, HAS SIX BRACKETS CRACKED. REMOVED THE BRACKETS AT THE FWD CARGO FR38.2 STRAP SUPPORT PANEL BULK. IAW SRM 51-40-21-001. RESTORED SURFACE IN NEW BRACKETS 6EA IAW A300 SRM 51-21-10. FABRICATED NEW BRACKETS IAW GMM 09.08SDR SWIA20251110828Intercostal · corrodedINTERCOSTAL BETWEEN FS347 TO FS364 AT STGR 20R HAS CORROSION. REMOVED AND REPLACED INTERCOSTAL BETWEEN FS 347 AND FS 364 AT STGR 20R IAW SRM 51-42-21.SDR CALA2025111011065Floor Support · crackedMAIN CABIN FLOOR SUPPORT CRACKED BETWEEN BS 380 - 400, RBL 10. REMOVED AND REPLACED THE FLOOR SUPPORT IAW DWG 143A5400, REV-, SRM 51-40-05, & SRM 51-40-02.SDR CALA2025111011063Floor Support · crackedMAIN CABIN FLOOR SUPPORT IS CRACKED BETWEEN BS 380 & 400 AT BL 0. REMOVED AND REPLACED THE FLOOR SUPPORT IAW DWG 143A5400 REV-, SRM 51-40-05 & SRM 51-40-02.SDR SWAA2025100609262Tie Clip · crackedCRACK TIE CLIP LOCATED STA 277 AND STR 10R PASSENGER CABIN . REPLACED TIE AND FASTENERS CLIP LOCATED STA 277 AND STR 10R IAW SRM 51-40-02-0G-0 AND DWG 141A1110 SHEET: 18 REV -, DWG 141A8380, SHEET 21, REV -, AND SRM 51-10-02-0G-0, PARAGRAPH 9.SDR SWAA2025100609483Web · corrodedCORROSION LOCATED BTW STA 350 AND STA 360 BL 0 IN INTERNAL AREA E/E BAY. REPLACED WEB LOCATED BTW STA 350 AND STA 360 BL 0 IN INTERNAL AREA E/E BAY IAW SRM 51-10-02-0G-0 AND DWG 141A3502; SHEET:59; REV A.SDR SWAA2025100609470Rib · crackedCRACK LEADING EDGE RIB ACCESS PANEL 341B LOCATED LE STA 114.55 AT RT HORIZONTAL STABILIZER. REPLACED RIB ON ACCESS PANEL 341B LOCATED LE STA 114.55 AT RT HORIZONTAL STABILIZER IAW SRM 51-10-02 PARAGRAPH 9; SRM 51-40-02; DRAWING 186A1305 SHEET 1, REV A, AND D