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 AALA202507217796Power Supply · inoperativeAIRCRAFT WAS GROUNDED: EMERGENCY LIGHT AT 4R INOP. ARMS CODE SENT. MAINTENANCE REPLACED EPSU (12WL) IAW AMM 33-51-38.SDR AALA202507212190Power Supply · inoperativeAIRCRAFT WAS GROUNDED: DURING PS CHECK FOUND 12 EMERGENCY LIGHTS INOP. MAINTENANCE REPLACED EPSU BATTERY FOR 11WL IAW AMM 33-51-38.SDR CALA2025072106794Slide · detachedDOOR SLIDE 2R HAS A PART DETACHED AND AN ORANGE FLAG/FABRIC SH OWING FAS REPORTS DR-2R ESCAPE SLIDE SAFETY PIN HAS FALLEN OUT OF IT'S STOWAGE POUCH WHILE ARMING ESCAPE SLIDE SLIDE RENDER SAFE CHECKLIST REMOVED DR-2R ESCAPE SLIDE PACK AND COVER REF AMM 25-66-SDR CALA2025072106785Charger · no testDURING CABIN INSPECTION FOUND THE FWD CABIN IN SEATS EMERGENCY LIGHTS INOPERATIVE IN THE FIRST FIVE ROWS FIRS CLASS SEATS. REMOVED AND REPLACED BATTERY CHARGER FUSE OPS CHECK NORMAL AS PER B737 AMM 33-51-00.SDR CALA2025072106766Spar · cracked{ EA 5510-01843 REV H 002 } RH HORIZONTAL STABILIZER FRONT SPAR STA 101.90 VERTICAL STIFFENER #3 CRACK AT LOWER TRANSITION RADIUS ( 212 ). INSTALLED ALL REPAIR PARTS AT RH HORIZONTAL STABILIZER FRONT SPAR STA 101.90 VERTICAL STIFFENER #3 PER REF SRM 55-10-09SDR CALA2025072106765Wire Harness · missingDURING TROUBLE SHOOTING FOUND NO WIRES RUNNING FROM SEAT 32- 36. SEAT 35, 34 AND 32 HAVE NO WIRES AT ALL. WIRE FROM SEAT 37 IS SPLICED IN MULTIPLE PLACES WITH EXCESS WIRE BUNDLED UP UNDER CARPET. ALSO FOUND GROUND WIRE FROM 37- 36 DISCONNECTED. REMOVED SEAT TSDR CALA2025072106764Battery Pack · no testEMEGENCY PASSENGER CABIN LIGHTS M1673 FAILS BATTERY CAPACITY CHE CK. BATTERY PACK M1673 FAILED CAPACITY CHECK. REMOVED INSTALLED NEW BATTERY PACK M1673 IAW B737 AMM 33-51-06-9 60-895, OP. CHECKS GOODSDR CALA2025072106763Oven · fireOVEN 205 FIRE. PBE AND FIRE EXT USED. OVEN 205 FIRE L1 DOOR PBE USED, FIRE EXTINGUISHER WAS NOT USED BUT WILL NEED TO BE INSPECTED AND RESEALED. REMOVED AND REPLACED L1 PBE AND FIRE EXTINGUISHER PER 26-26-02 SEE LOG PAGE 5616867 FOR POSITION 205 OVEN. R&R GALSDR CALA2025072106762Web · corrodedCORROSION AROUND G4 GALLEY FITTING AT FLOOR STRUTURE STA986.5+8" RBL 39. REMOVED AND INSTALLED NEW MACHINED WEB FROM STA 986 TO STA 1016 RBL 39" REF B 737-900ER SRM 51-40-02-0G-0 AND DWG # 147A5701.SDR CALA2025072106761Stiffener · cracked{ EA 5510-01843 REV H 002 } RH HORIZONTAL STABILIZER FRONT SPAR STA 101.90 VERTICAL STIFFENER #4 CRACK AT LOWER TRANSITION RADIUS ( 212 ). REF AAR N/R 97524560 INSTALLED ALL REPAIR PARTS AT RH HORIZONTAL STABILIZER FRONT SPAR STA 101.90 VERTICAL STIFFENER #4 PSDR CALA2025072106760Intercostal · corrodedCORROSION AT AFT WET AREA INTERCOASTAL STA 947 RBL 24. CORROSION FOUND OUT OF LIMITS REMOMOVED AND INSTALLED NEW INTERCOSTAL AND 2 EACH NEW CLIPS AT STA 947.50 RBL 24.75 REF SRM 51-40-02-0G-0 , DWG# 147A5650,EC/RA 5370-01183 AND AAR ESR# 16-12455 REV P2SDR CALA2025072106759Floor Support · crackedMAIN CABIN CENTER SECTION FLOOR SUPPORT BREAK CRACKED AT STA 540 BL0 TO RBL24 MKD DOT 038 REF AAR N/R 97524961 INSTALLED NEW FLOOR SUPPORT IAW SRM 51-40-02-0G-0, DWG: 143A0060. WORK ACCOMPLISHED BY V945157 ESFR TRANSACTION COMPLETE REMOVED AND REPLACED MAIN CASDR CALA2025072106758Elec Connector · arcedCONNECTOR D256A FOUND WITH EVIDENCE OF ARCING AT PINS C15, D15 & D13. REQUIRES FURTHER INVESTIGATION. CONNECTOR D256 FRAME REPLACED ALONG WITH D256A PLUG INSERT. REFITTED ORIGINAL D256B AND D256C PLUG INSERT INTO NEW FRAME. IAW SWPM 20-71-14 PAGE 165/166. D256SDR CALA2025072106757Battery Pack · no testDURING EMERG LIGHT CHECK FOUND FAULT EPSU UNIT FWD L REF AMM 33-51-38 REPLACED EPSU BATTERY. OPS TEST GOOD AT THIS TIME. UPDATING SDRSDR FDEA202507191267Skin · damagedWHILE PERFORMING INSPECTION ON THE #2 CARGO DOOR LWR CORNERS SKIN CUTOUT FWD AND AFT, FOUND A REPAIR ON THE AFT LOWER CORNER OF THE #2 CARGO DOOR AREA. AD2006-11-11 FUSELAGE PREVIOUS REPAIR AT NO. 2 CARGO DOOR CUTOUT BS 1410-1445 STR 25- 28R. ACCOMPLISHED SSDR FDEA202507191266Handle · faultedFOUND AFTER LANDING, EMERGENCY HATCH HANDLE EXTENDED. REPEAT WRIGHT UP. SECURED HANDLE FLUSH AND IN STOWED POSITION REF AMM 56-11-04-4. OK FOR SERVICE.SDR FDEA202507191265Stringer · crackedDURING ACCOMPLISHING W/C: 57.20.01.1, FOUND CRACK ON UPPER AUXILLIARY TANK LOWER STRINGER S-47 ALONG XCW -17 (RIGHT HAND SIDE). CRACK ON UPPER AUXILLIARY TANK LOWER STRINGER S-47 ALONG XCW -17 (RIGHT HAND SIDE) REPAIRED AS PER MD-11 SRM 57-10-03-2R FIGURE SDR SCNA20250721267Placard · damaged15D EMERGENCY EXIT INSTRUCTIONS PLACARD ON THE TRAY HAS DAMAGED. R&R 15D EMERGENCY EXIT INSTURCTION PLACARD ON THE TRAY REF AMM 11-32-00.SDR SCNA20250721266Bracket · looseDEFECT 801438: 1 R DOOR SLIDE BRACKETS LOOSE. REMOVED 1 R DOOR SLIDE PACK. INSTALLED NEW RIVET IN RIGHT GRIT BAR RETAINER CLIP.IAW SRM 51-40-02.INSTALLED SLIDE PACK IAW AMM 25-66-01 OK FOR SERVICESDR AALA202507217411Bear Strap · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN R1 DOOR UPPER FORWARD CUTOUT CORNER BEAR STRAP AT BS 294 FROM S8R TO S9R. REPARED BEAR STRAP PER EA 365781 AND SRM 53-10-01-2R PROCEDURE 6.SDR DALA2025072005442Frame · dentedAIRCRAFT 651, AFTER REMOVAL SIDEWALL PANEL 162BW: FOUND DENT ON FRAME STA 1500 AT STGR 22RH IN AFT CARGO COMPARTEMENT. FRAME STA 1500 AT STGR 22RH IN AFT CARGO COMPARTEMENT WAS REPAIRED PER B757-200 SRM 53-00-07-2R-5 PROCEDURE 5 REPAIR 5 DETAIL III. (LP 1094SDR DALA2025072005441Transceiver · faultedSHIP 9523-ATO- ABORTED TAKE-OFF DUE TO RECEIVING A STICK PUSHER FAIL MESSAGE. CORRECTIVE ACTION: MAINTENANCE REPLACED BOTH RADIO ALTIMETER TRANSCEIVERS AND PERFORMED ALL APPLICABLE RETURN TO SERVICE TESTS. (LP 7808224)SDR DALA2025072005440Ecs · contaminatedAIRCRAFT 5075, AT GATE AFTER ENGINE SHUTDOWN STRONG FUME SCENT IMMEDIATELY AFTER TURNING ON APU BLEED. SHUT OFF BLEED WITHIN 5 SECONDS OF NOTICING THE SMELL. COMPLETED LEVEL A DECONTAMINATION OF THE ENVIRONMENTAL CONTROL SYSTEM (ECS) PER WORKCARD 2100-2007.SDR DALA2025072005439Bearing · excess playSHIP 1022 - DIV - TO DEN DUE TO AIRFRAME VIBRATIONS IN CRUISE. ELEVATOR HINGE LINE FITTINGS AND SERVO CONTROL BEARINGS FAILED FREE PLAY TESTS. REPLACED NBR 1 - 6 HINGE BOLTS AND BUSHINGS. PERFORMED FUNCTIONAL CHECK OF RIGHT ELEVATOR FREE PLAY, FOUND TO BE WISDR JR2R20250719908Case · corroded#1 ENGINE CONTAINMENT CASE FLANGE HAS CORROSION ON LOWER THREE BOLT HOLES.SDR SWIA20251110718Hinge · gougedMAIN ENTRY DOOR HINGE GOUGED AT FWD AND AFT ENDS (C-CHECK RO 11/07/2025)PERFORMED REPAIR ON PASSENGER DOOR HINGE REPAIR (DOOR SIDE) IAW REO #670-52-11-511, REV -E, DATE 2017-08-02, NDT PERFORMEDSDR SWI2025F01512Stringer · corrodedSTRINGER 21R LOCATED 7" FWD FS 333.0 HAS CORROSION. REMOVED AND REPLACED NEW STGR 21R @ FWD BETWEEN FS. 280 TO FS. 333.0 IAW CRJ900 SRM 51-42-06-001-001-A01WEIGHT CHANGE: NO WEIGHT CHANGE NOTED, SAME ITEMS REPLACED AS REMOVED.COMPLIED WITH TASK CARD 51-900-1SDR SWI2025F01511Stringer · corrodedSTRINGER 21R LOCATED 5.5" FWD FS 349.0 HAS CORROSION. REMOVED AND REPLACED NEW STGR 21R @ FWD BETWEEN FS. 333 TO FS. 349.0 IAW CRJ900 SRM 51-42-06-001-001-A01NO WEIGHT CHANGE, ITEMS REMOVED, REPLACED WITH NEW SAME ITEMS.STRUCTRAL REPAIR TASK CARD 51-900-1002SDR SWIA2025110600718Stringer · corrodedSTRINGER 22R LOCATED 5.5" FWD FS 349.0 HAS CORROSION. REMOVED AND REPLACED NEW STGR 22R , BRACKET, & JOINT SPLICE, AT FWD BETWEEN BS 280 TO 349 IAW SRM 51-42-06-001-001-A01. ITEMS REMOVED, REPLACED WITH NEW COMPLIED WITH STRUCTRAL REPAIR TASK CARD 51-900-SDR VNA2025F00037Frame · corrodedCORRODED FASTENERS ON FRAME AND FUSELAJE JOINT FS1162.00 BTW STGR 25RH TO 25LH AT AFT EQUIPMENT BAY. FASTENERS ON FRAME AND FUSELAJE JOINT FS1162.00 BTW STGR 25RH TO 25LH AT AFT EQUIPMENT BAY. WERE REPLACED PER SRM 51-42-06-001-001-A01.SDR VNA2025F00036Frame · corrodedCORROSION ON FS 581.00 BTW STGR 26LH AND STGR 26RH AT FWD CARGO COMPARTMENT. CORROSION ON FS 581.00 BTW STGR 26LH AND STGR 26RH AT FWD CARGO COMPARTMENT WERE REMOVED PER CRJ-900 SRM 51-21-06-001-001-A01 AND EVALUATED WITHIN LIMITS PER CRJ-900 SRM 53-31-06-10SDR VNA2025F00035Frame · corrodedCORROSION ON FS 501.00 BTW STGR 24LH AND STGR 26RH AT FWD CARGO COMPARTMENT. CORROSION ON FS 501.00 BTW STGR 24LH AND STGR 26RH AT FWD CARGO COMPARTMENT WAS REMOVED PER CRJ-900 SRM 51-21-06-001-001-A01 AND EVALUATED WITHIN LIMITS PER CRJ-900 SRM 53-31-06-101SDR VNA2025F00026Nut · corrodedCORROSION ON STIFFENER FWD LOWER PANEL(3E/A), CHANNEL FWD LOWER PANEL(2E/A), ANGLE FWD LOWER PANEL(2E/A), SUPPORT ANGLE(2E/A) AFTER TO 67.50% REARSPAR DATUM THROUGH ACCESS PANEL 326AR WAS REMOVED PER CRJ/900 SRM 51-21-06-001-001-A01 AND EVALUATED WITHIN LIMITSSDR VNA2025F00025Stiffener · corrodedCORROSION ON STIFFENER FWD LOWER PANEL(4E/A), CHANNEL FWD LOWER PANEL(2E/A),ANGLE FWD LOWER PANEL(2E/A), SUPPORT ANGLE(2E/A) AFTER TO 67.50% REARSPAR DATUM THROUGH ACCESS PANEL 326AR.. CORROSION ON STIFFENER FWD LOWER PANEL(3E/A), CHANNEL FWD LOWER PANEL(2E/ASDR AALA202510105489Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION ON FASTENER HOLE ZONE 1 OF HORIZONTAL FLOOR BEAM 1 AT FR 36. CRACK DIRECTION 1 OCLOCK VIEW LOOKING AFT. CRACK D= 0.130 INCH. MAINTENANCE PERFORMED PERMANENT REPAIR ON CENTER WING BOX POSITION +Y1292 FR 36 ON SPAR SDR AALA202510103608Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION FOUND ON RADIUS OF HORIZONTAL FLOOR BEAM 3 BACKSIDE OF THE SPAR VERTICAL STRINGER AT FR 36. CRACK MEASURE L= 0.305 INCH. MAINTENANCE PERFORMED PERMANENT REPAIR ON CENTER WING BOX POSITION (3) Y254 FRONT SPAR VERTSDR AALA202510107798Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION FOUND ON RADIOUS OF HORIZONTAL FLOOR BEAM 4 BACKSIDE OF THE SPAR VERTICAL STRINGER AT FR36. CRACK L:0.395 INCH. MAINTENANCE PERFORMED PERMANENT REPAIR ON CENTER WING BOX POSITION (4)-Y254 ON SPAR VERTICAL STRINGERSDR AALA202510106968Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION FOUND ON RADIUS OF HORIZONTAL FLOOR BEAM 2 BACKSIDE OF THE SPAR VERTICAL STRINGER AT FR 36. CRACK L= 0.105 INCH. MAINTENANCE PERFORMED PERMANENT REPAIR ON CENTER WING BOX POSITION (2)Y765 FRONT SPAR VERTICAL STRINSDR AALA202510067363Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION FOUND ON RADIUS OF HORIZONTAL FLOOR BEAM 5 BACKSIDE OF THE SPAR VERTICAL STRINGER AT FR 36. CRACK L= 0.155 INCH. MAINTENANCE PERFORMED PERMANENT REPAIR ON CENTER WING BOX POSITION (5) -Y765 ON SPAR VERTICAL STRINGSDR NACA2025071800003Wire Harness · wornFOUND THE #2 EGT HARNESS WORN. REPLACED THE #2 EGT HARNESS FOUND SATIS PER AMM 77-21-02. ENGINE INFORMATION NOT AVAILABLE.SDR SWIA202509020009Tie Bar · bentRH ENGINE PYLON - AFT OF PYLON TIE BAR FRAME - UPR AND LWR FIREWALL SEAL RETAINERS AND SUPPORT STRUCTURE BENT. REPLACED RH ENGINE PYLON - AFT OF PYLON TIEBAR FRAME - UPR AND LWR FIREWALL SEAL RETAINERS AND SUPPORT STRUCTURE REF.DWG: MM670-37001 REV: AH AND SSDR SWAA2025082792731Gusset · crackedCRACK ON GUSSET ANGLE LOCATED BS 500I AT LEVEL STR 21L AT FWD CARGO COMPARTMENT. REPLACED GUSSET AND FASTENERS IAW SRM 51-40-02; SRM 51-10-02 ITEM 9 AND DWG 143A7902 SHEET 256 REV B.SDR SWAA2025082792729Support Angle · crackedCRACK ON SUPPORT ANGLE LOCATED FWD FACE BS 500H AT LEVEL STR 26L AT FWD CARGO COMPARTMENT. REPLACED SUPPORT ANGLE LOCATED FWD FACE IAW SRM 51-40-02-0G AND DWG 143A7505 SHEET 123 REV-.SDR SWAA2025082792732Intercostal · crackedCRACK WEB - INTERCOSTAL LOCATED BTW BS 500FTO BS500G AT LEVEL STR 26L AT FWD CARGO COMPARTMENT 2025-456922<[01] APPLIED PROTECTIVE TREATMENT ON WEB-INTERCOSTAL LOCATED BTW BS 500FTO BS500G AT LEVEL STR 26L AT FWD CARGO COMPARTMENT IAW B737-800 SRM 51-20-01-0G.SDR SWAA2025082792934Web · crackedCRACK ON WEB LOCATED BTW BS 500 TO BS 500A AT LEVEL STR 26L AT FWD CARGO COMPARTMENT. REPLACED WEB LOCATED BTW BS 500 TO BS 500A AT LEVEL STR 26L AT FWD CARGO COMPARTMENT IAW SRM 51-40-02-0G-0, AND DWG 143A7505, SHEET 123, REV-.SDR SWAA2025082792733Angle · crackedCRACK ON ANGLE LOCATE FWD FACE BS 500H AT LEVEL STR 26R AT FWD CARGO COMPARTMENT. REPLACED ANGLE (CLIP ASSY) LOCATE FWD FACE BS 500H AT LEVEL STR 26R AT FWD CARGO COMPARTMENT IAW SRM 51-40-02-0G-0, AND DWG 143A7505, SHEET 123, REV-.SDR SWAA2025082792728Angle · crackedCRACK ON GUSSET ANGLE LOCATED BS 500I AT LEVEL STR 19R AT FWD CARGO COMPARTMENT. REPLACED GUSSET ANGLE AND FASTENERS LOCATED BS 500I AT LEVEL STR 19R AT FWD CARGO COMPARTMENT. IAW SRM 51-40-02; SRM 51-10-02 PARAGRAPH 9 AND DWG143A7902 SHEET 256 REV B.SDR SWAA2025082792935Floorbeam · crackedCRACK ON BREAK PANEL LOCATED BS 540 BTW BL 0 TO RBL 24.75 WL 208.1 AT PASSENGER CABIN. REPLACED BREAK PANEL LOCATED BS 540 BTW BL 0 TO RBL 24.75 WL 208.1 AT PASSENGER CABIN IAW SRM 51-40-02 AND DRAWING 14345240; SHEET 14; REV-.SDR SWAA2025082792931Angle · crackedCRACK ON ANGLE LOCATED FWD FACE BS 500G AT LEVEL STR 26R AT FWD CARGO COMPARTMENT. REPLACED ANGLE LOCATED FWD FACE BS 500G AT LEVEL STR 26R AT FWD CARGO COMPARTMENT IAW SRM 51-40-02 AND DWG 143A7505, SHEET 123, REV-.SDR IPXA2025082294766Adapter · corrodedMDC FR28 Y0 LH CLS ADAPTER HAS CORROSION ON FLANGE AND INSIDE DOT 5612-34 COMPLIED WITH ACCOMPLISH PERMANENT REPAIR IN ACCORDANCE WITH EO-94687-REQ1 AND VT-MAE EA 300-5314-27-A4053 REV. -