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 AALA202510169912Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CABIN FLOOR BEAM AT FR 18 +18 INCHES AT -Y1292. REPLACED BEAM PER SRM 51-42-11.SDR DALA2025101307475Shear Tie · corrodedSHIP 185 CORROSION ON SHEAR TIE AT STA 1562 BETWEEN S-38L AND S-38R, REPLACED SHEAR TIE REF BAC DWG 146T1223 (1228789)SDR DALA2025101307484Support · corrodedCORROSION ON AFT LAV SERVICE PAN SUPPORT STRUCTURE PAN STRAP. REPLACED STRAP REF BAC DWG 146T3240 (1228787)SDR CALA2025101309987Skin · corrodedLAVATORY TOILET SERVICE AT LWR EXTERNAL FUSELAGE SURFACE STRUCTURE WITH BULDGING SKIN AROUND FASTENERS. INSTALLED REPAIR AT FUSELAGE LOWER SKIN STA 827 - 887, STR 22L - 26L IN ACCORDANCE WITH AAR-MIA ESR-WI 2023803-19-12777 REV. IR,SDR AALA202510131540Skin · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO FUSELAGE LOWER SKIN AROUND DRAIN HOLE AT BS 727J, S27R. REPAIRED SKIN PER SRM 53-60-01-2 -R-4.SDR AALA202510131080Skin · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO FUSELAGE LOWER SKIN AROUND DRAIN HOLE AT BS 727L, BL 0. REPAIRED SKIN PER SRM 53-60-01-2 -R-4 AND EA 368857.SDR AALA202510131599Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER ATTACH ANGLE LOCATED AT BS 663.75 RBL 36. REPAIRED ANGLE PER SRM 57-10-10-2R-5.SDR AALA202510107928Skin Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO FUSELAGE SKIN PANEL AROUND ACCESSORY ACCESS DOOR 312AR CUTOUT AT FR 71 BETWEEN S27R AND S28R. ACCOMPLISHED DOUBLER REPAIR PER EA 368590.SDR FDEA2025100911865Skin · dentedFUSELAGE: RAMP REPORTED DENT 24 INCH FORWARD OF BULK CARGO DOOR AT AFT FUSELAGE ON SKIN BETWEEN STATION 1887 - STATION 1902 LONGERON 40LEFT - LONGERON 41LEFT, REQUIRED TO PERFORM TERMINATING REPAIR, (REFERANCE: WRI: 53304011). DENT AT 24 INCH FORWARD OF BUSDR CALA2025100909833Seat Track · corrodedMID WET AREA AFTER FURTHER EVALUATION ON SEAT TRACK BETWEEN STA 500C AND STA 500E LBL 24, FOUND TO BE OUT LIMITS. REPAIRED AND RESTORED MID WET AREA ON SEAT TRACK BTW STA 500C-ST A 500E LBL24 IAW B737 SRM 53-00-52-2R-4,SRM 51-40-05-0G-0,SRM 51 -40-08-0G-0,SRMSDR JJBA20251008038Floor Support · corrodedRH OMEGA BEAM #1 FOUND CORRODED BTW FR 18-19. AT RH OMEGA BEAM #1 BTW FR 18-20 OMEGA BEAM CORRODED OUT OF LIMIT. RH OMEGA BEAM #1 BTW FR 18-20 REPAIRED.SDR JJBA20251008034Floor Support · crackedCFII, LH OMEGA BEAM INBD VERTICAL FLANGE FOUND CRACKED AT FR 26. REPAIR DOUBLER ON CFII, LH OMEGA BEAM, ON INBD VERTICAL FLANGE AT FR26SDR JJBA20251008033Floor Support · crackedCFII, LH OMEGA BEAM INBD VERTICAL FLANGE FOUND CRACKED AT FR31. REPAIR DOUBLER ON CFII, LH OMEGA BEAM, ON INBD VERTICAL FLANGE AT FR31SDR JJBA20251008032Floor Support · crackedCFI, LH OMEGA BEAM INBD VERTICAL FLANGE FOUND CRACKED AT FR21. REPAIR DOUBLER ON CFI, LH OMEGA BEAM, ON INBD VERICAL FLANGE AT FR 21.SDR JJBA20251008031Floor Support · crackedCFII, LH OMEGA BEAM INBD VERTICAL FLANGE FOUND CRACKED AT FR34. REPAIR DOUBLER ON CFII, LH OMEGA BEAM, ON INBD VERTICAL FLANGE AT FR34SDR JJBA20251008029Floor Support · crackedLH OMEGA BEAM INBD VERTICAL FLANGE FOUND CRACKED AT FR25. REPAIR DOUBLER ON CFII, LT OMEGA BEAM, ON INBD VERTICAL FLANGE AT FR 25SDR JJBA20251008026Floor Support · crackedCFI, LH OMEGA BEAM INBD VERTICAL FLANGE FOUND CRACKED AT FR22. REPAIR DOUBLER ON CFI, LH OMEGA BEAM, ON INBD VERICAL FLANGE AT FR 22SDR JJBA20251008023Shear Tie · corrodedRF1, CARGO ENTRANCE L-FRAME 68 BTW STR 17L-18L FOUND CORRODED. RF1, CARGO ENTRANCE L-FRAME 68 BTW STR 17L-18L BLENDED. RF1 CARGO ENTRANCE L-FRAME 68 BTW STR 15L-16L CUTOUT WAS DONE. RF1 CARGO ENTRANCE L-FRAME 68 BTW STR 17L-18L REPAIRED.SDR CALA2025100809789Seat Track · corrodedMID WET AREA AFTER FURTHER EVALUATION ON SEAT TRACK BETWEEN STA 500C AND 500E LBL 45 FOUND TO BE OUT LIMITS, REQUIRE REPAIR. REPAIRED AND RESTORED MID WET AREA ON SEAT TRACK BTW STA 500C-ST A500E LBL45 IAW SRM 53-00-52-2R-4,SRM 51-40-05-0G-0,SRM 51-40-08-0G-SDR ASAA2025100161416Floorbeam · crackedSTA 540 RBL 0 PANEL BREAK IS CRACKED. GROUNDED - YES. REMOVED AND REPLACED PANEL BREAK IAW B737-900ER SRM 51-40-02-0G-0.SDR AALA202510070029Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE BREAK ASSEMBLY PANEL AT BS 540, LBL 6. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-1.SDR DALA2025100707311Microphone · inoperativeF.O O2 MASK MICROPHONE NOT TESTING. C/A: REPACKED O2 MASK OPS CKD PER A320 AMM35-13 CKD NORMAL. (LP: 7276102)SDR AALA202510074803Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT BS 354, S17L, LBL 11. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR CALA2025100709738Support Beam · damagedCENTER LOWER SUPPORT BEAM LOWER CHORD RBL 540 DAMAGED. PRIMARY STRUCTURE REQUIRES R IAW SRM 57-10-13-2R-3 MATERIAL ID FOR STRAP ITEM (1) AND FILLER ITEM (4), 7075 T6 .125" PO#3919569330. LOCATION CORRECTION, DAMAGE IS OF THE LOWER SUPPORT BEAM LOWER CHORD ASDR ASAA2025100161326Floor Panel · dentedCABIN FLOOR PANEL PN 143A5810-514 (231EF) RELEASED AT RISK FROM QC BOND PENDING REPAIR, DENTED ON BACKSIDE. GROUNDED - YES. REPAIRED DENT ON LOWER SURFACE OF CABIN FLOOR PANEL PN: 143A5810-514 (231EF) IAW B737-900ER SRM 53-00-50-2R-2.SDR SWAA2025100620121Lens · damagedAFT LAVATORY EMERGENCY EXIT SIGN HAS DAMAGED LENS. REMOVED AND REPLACED DAMAGED LENS FROM AFT LAV EMERGENCY EXIT SIGN AND PERFORMED GOOD INSTALLATION TEST IAW AMM 33-51-01-960-802.SDR 2025FA0000682Probe · faultyDURING START UP THE PILOT NOTED A HIGH RISE IN TEMP WHICH EXCEEDED ALLOWABLE TEMP FOR START. IMMEDIATELY SHUT THE ENGINE DOWN. CONTACTED MX. PER THE MX MANUAL NO TEMPS WERE EXCEEDED PER THE MX MANUAL ONLY THE "ALLOWABLE" LIMIT FOR PILOT START. FURTHER TROUSDR IPXA2025100641817Hydraulic System · leakingATB AFTER TAKEOFF WHILE RETRACTING FLAPS FROM F5 TO F1 WE RECEIVED C HYD QTY ABD STATUS PAGE SHOWED QUANTITY DECREASING #8 SPOILER ACTUATOR REPLACED IAW AMM 26-61-02-401. LEAK CHECK PERFORMED AND NOT FOUND LEAKS. SPOILER OPTS PERFORMED IAW AMM 27-61-00 AND SYSSDR CALA2025100609640Intercostal · crackedWHILE PERFORMI ING REPAIR FOR NRTN 1333882 DISCOVERED CRACK COMMON TO MATING 14 6N5425-37 INTER COSTAL WEB. REMOVE WEB, REMOVE STIFFENERS COMMON TO WEB, FABRICATE WEB LOCATE DRILL TREAT PRIME REINSTALL ESDR REPORTING REMOVED 02 STIFFENERS AND 02 CLIPS FROM INSDR CALA2025100609639Intercostal · gougedMAIN E&E ACCESS DOOR CUTOUT BETWEEN FR460- FR480/S29R INTERCOSTAL I/B SURFACE GOUGED. DIT 95-15. REMOVED AND REPLACED INTERCOSTAL AT MAIN E&E ACCESS DOOR CUT OUT BETWEEN FR460-FR480 S21R.SDR CALA2025100609638Plate · crackedNR 2 ENGINE, UPPER STRUT GAP PANEL LE CRACKED. REMOVED, FABRICATED AND REPLACED GAP PANEL SKIN IAW SRM 51-40-02 AND PER PRODUCTION CONTROL TRAVELER T25/1832479 SDR 200 4.SDR DALA2025100607231Oil System · leakingAFTER APU START UP AND WARM UP AT THE GATE WHEN THE APU BLEED SELECTED ON THE DIRTY SOCK SMELL FILLED THE COCKPIT AND ENTIRE CABIN. SMELL WAS VERY STRONG. PERFORMED GVI OF APU COMPARTMENT. FOUND EVIDENCE OF AN OIL LEAK ON PLENUM. OK FOR SVC. (LP: 7403510)SDR N6WA2025100404Frame · corrodedCORROSION AT FS879 BELOW FLOOR ON STGRS26L-STGR26R. PERFORMED REPAIR ON FRAME AT FS879 IAW EO-C550-53MR-033-OSDR N6WA2025100403Seat Track · corrodedCORROSION ON SEAT TRACK LOCATED LBL27 BETWEEN FS364.00-FS485.00. REMOVED AND REPLACED SEAT TRACK AT LBL27 BETWEEN FS364.00-FS485 IAW CRJ AMM 53-00-49SDR N6WA2025100402Stringer · corrodedCORROSION ON STRINGER 19R BETWEEN FS421-FS453. REMOVED AND REPLACED STGR19R BETWEEN FS349-485 IAW GOJET EO-C550-53MR-050SDR ELYA10012025006Alternator · brokenLEFT ALTERNATOR FAILED CAS MESSAGE. WHILE TROUBLESHOOTING SMOKE SMELL BEGAN IN CABIN. LT ALTERNATOR WAS FOUND WITH TWO BROKEN CASE TIE BOLTS BY MAINTENANCE. BUS BAR FUSE FOUND POPPED. ALTERNATOR AND FUSE REPLACED. LH VOLTAGE REGULATOR REPLACED. OPS CHECK GOOD,SDR ASAA2025100161311Door · no discrepancyJETWAY AGENT REPORTS L1 DOOR FEELS ABNORMAL WHEN CLOSING. GROUNDED - YES. PERFORMED GENERAL VISUAL OF DOOR AND OPENED AND CLOSED L1 DOOR. L1 DOOR FUNCTIONS NORMAL. NO DEFECTS NOTED, REF AMM 52-11-00.SDR AALA202510034430Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: AFT RIGHT CABIN DOOR DAMPER NEEDS SERVICING. MAINTENANCE SERVICED DOOR DAMPER IAW AMM 52-10-00.SDR AALA202510036451Oxygen Bottle · faultedAIRCRAFT WAS NOT GROUNDED: WHILE ACCOMPLISHING JOBCARD 26C20035003, EMERGENCY OXYGEN CONTAINER DOOR DOES NOT CLOSE ON ROW 1FD. MAINTENANCE REPLACED OXYGEN CONTAINER.SDR AALA202510034106Oxygen Bottle · faultedAIRCRAFT WAS NOT GROUNDED: WHILE ACCOMPLISHING JOBCARD 26C20035003, EMERGENCY OXYGEN CONTAINER DOOR DOES NOT CLOSE ON ROW 22ABC. MAINTENANCE REPLACED OXYGEN CONTAINER IAW AMM 35-21-41-000-001-AND AMM 35-21-41-400-001-A.SDR AALA202510036051Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: FOUND LOW PRESSURE ON R4 DOOR OPENING ASSIST BOTTLE. MAINTENANCE SERVICED ASSIST BOTTLE AT R4 DOOR IAW AMM 52-10-00.SDR AALA202510030896Bottle · low pressureAIRCRAFT WAS GROUNDED: GATE AGENT REPORTS L1 DOOR DIFFICULT TO OPEN/MOVE. MAINTENANCE SERVICED L1 DOOR DAMPER AND ACCOMPLISHED LUBRICATION OF HINGE ARMS SUPPORT FITTINGS, DOOR OPERATES NORMAL NO DIFFICULTY NOTED OPERATING DOOR, OPS CHK GOOD IAW AMM 52-10-00 ANSDR AALA202510033494Sign · inoperativeAIRCRAFT WAS NOT GROUNDED: R2 DOOR EXIT SIGN HAS BULBS INOP. MAINTENANCE REPLACED LIGHT ASSEMBLY IAW AMM 33-51-16.SDR AALA202510034506Sign · inoperativeAIRCRAFT WAS NOT GROUNDED: L2 DOOR EXIT SIGN HAS BULBS INOP. MAINTENANCE REPLACED LIGHT ASSEMBLY IAW AMM 33-51-16.SDR AALA202510039345Sign · inoperativeAIRCRAFT WAS NOT GROUNDED: FWD GALLEY CENTER EXIT SIGN HAS LIGHT BULBS INOP. MAINTENANCE REPLACED LIGHT ASSEMBLY IAW AMM 33-51-16.SDR AALA202510031169Sign · inoperativeAIRCRAFT WAS NOT GROUNDED, R1 DOOR EXIT SIGN HAS LIGHT BULBS INOPERATIVE. MAINTENANCE REPLACED LIGHT ASSEMBLY IAW AMM 33-51-16.SDR AALA202510037170Sign · inoperativeAIRCRAFT WAS GROUNDED: L1 DOOR EXIT SIGN HAS LIGHT BULBS INOP. MAINTENANCE REPLACED LIGHT ASSEMBLY IAW AMM 33-51-16.SDR R61A2025100100428Engine · vibrationENGINE NR 2 VIB IN CLIMB FROM FL320 TO FL380. ISSUED REQUIRED DESCENT TO FL340 AND SPEED REDUCED TO .70 MACH. ENGINE #2 THRUST REDUCED TO APPROXIMATELY 77% N1. DECLARED EMERGENCY, LANDED WITHOUT INCIDENT. PERFORMED INSPECTION ON ENGINE #2 FAN BLADES. PLACED ENSDR SWAA2025100320526Handle · brokenRIGHT FWD SERVICE DOOR GRAB HANDLE BROKEN. REPLACED RIGHT FWD SERVICE DOOR GRAP HANDLE IAW AMM 52-41-31SDR SWAA2025100320038Charger · smokeTHERE IS SMOKE COMING FROM FWD RT EMERGENCY LIGHTING CHARGER AND BATTERY PACK. REMOVED AND REPLACED FWD R/H CHARGER AND BATTERY PACK PER M/M 33-51-06