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 AALA202509099299Beam · damagedAIRCRAFT IN BASE MAINTENANCE: PREVIOUS TEMP REPAIR REQUIRES REPLACEMENT OF BEAM LOC ON FR40 BTW BEAM 2 AND BEAM 3 IAW EO 5210Y228-001. MAINTENANCE REPLACED BEAM LOC ON FR40 BTW BEAM 2 AND BEAM 3 IAW EO 5210Y228-001.SDR AALA202509096280Structure · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK EMERGENCY EXIT DOOR 834 AT SEGMENT FR41 BTW BEAM 2 AND BEAM 3 DIMENSION OF CRACK IS L= 1.010 IN. MAINTENANCE REPLACED EMERGENCY EXIT DOOR 834 SEGMENT FR41 BTW BEAM 2 AND BEAM 3 IAW EO 5210Y228-001.SDR AALA202509098910Structure · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK EMERGENCYEXIT DOOR 834 SEGMENT AT FR40 BTW BEAM 2 AND BEAM 3 DIMENSION OF CRACK L=0.935 IN. MAINTENANCE REPLACED EMERGENCYEXIT DOOR 834 SEGMENT AT FR40 IAW EO 5210Y228-001.SDR AALA202509099100Structure · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK EMERGENCY EXIT DOOR 844 FWD SEGMENT AT FR 40. MAINTENANCE REPLACED EMERGENCY EXIT DOOR 844 FWD SEGMENT AT FR 40 IAW EO 5210Y228-001.SDR AALA202509094245Structure · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK MEREGENCY EXIT DOOR 844 FWD SEGMENT AT FR 40 L=0.935 IN. MAINTENANCE REPLACED MEREGENCY EXIT DOOR 844 FWD SEGMENT AT FR40 IAW EO 5210Y228-001.SDR AALA202509091102Beam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK EMERGENCY EXIT DOOR 844 FORWARD SEGMENT AT FR 40. MAINTENANCE REPLACED BEAM AT DOOR 844 IAW EO 5210Y288-001.SDR SWIA2025090200620Drag Angle · crackedDURING RH VERT STAB-TO-FUSELAGE AFT DRAG ANGLE REMOVAL FIND CRACK ON RH VERT STAB-TO-FUSELAGE FWD DRAG ANGLE #30352476 (C-CHECK RO 08/29/2025)BLENDED CORRODED AREA OF LH WING FUEL ACCESS PANEL LANDING 510AB IN REFERENCE WITH REO 601R-57-21-030 REV. -L, DATED 2SDR AALA202509027426Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION ON FRAME IN PASSENGER CABIN (1E/A) CRACK INDICATION FOUND ON HORIZONTAL FLOOR BEAM RADIUS OF THE BACKSIDE THE SPAR VERTICAL STR 3 ZONE 1 FR36 CENTER WING BOX CRACK LEGTH 0.318 INCH. MAINTENANCE PERFORMED PERMANENTSDR AALA202509029715Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION FOUND IN OPEN HOLE ZONE 1 STR 5 FR36 CENTER WING BOX CRACK DEPTH: 0.097 INCH. MAINTENANCE PERFORMED PERMANENT REPAIR ON ZONE 1 FR36, -Y765 CENTER WING BOX IAW EA# 366035.SDR AALA202509023724Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION ON FRAME IN PASSENGER CABIN (1 EA) CRACK INDICATION FOUND ON HORIZONTAL FLOOR BEAM RADIUS OF THE BACKSIDE THE SPAR VERTICA L STR 2 ZONE 1 FR36 CENTER WING BOX CRACK L=0.283 INCH. MAINTENANCE PERFORMED PERMANENT RSDR AALA202509029501Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CARCK INDICATION ON FRAME IN PASSENGER CABIN CRACK INDICATION FOUND ON HORIZONTAL FLOOR BEAM RADIUS OF THE BACKSIDE THE SPAR VERTICAL STR 4 ZONE 2 FR36 CENTER WING BOX, CRACK LENGTH 0.236 INCH. MAINTENANCE PERFORMED PERMANENT REPSDR IPXA2025070524371Stringer · crackedMAJOR REPAIR. STRINGER CRACKED, FWD SIDE OF BS 740, S47R. ACCOMPLISHED REPAIR IAW EO-94422-REQ 1, REV 1, AND EGAT EI F2025A53M-1386, REV 1, AND SRM 53-20-03-2R-5, REV 46 AND EGAT WORK SHEET 50430.SDR IPXA2025070524446Stringer · crackedMAJOR REPAIR. STRINGER CRACKED, FWD AND AFT SIDE OF BS 740, S41L. ACCOMPLISHED REPAIR IAW EO-94405-REQ 1 AND EGAT EI F2025A53M-1385, REV 1 AND SRM 53-20-03-2R-5, REV 46 AND EGAT WORK SHEET 50431.SDR IPXA2025073024211Stringer · crackedMAJOR REPAIR. STRINGER CRACKED, AFT SIDE OF BS 2360 S-6L. PERFORM EO-94409-REQ1 REV.1 AND EI NO.F2025A53M-1292 REV.2.SDR JJBA20250730119Channel · corrodedCF1, CHANNEL BTW FR20-22 AT SERVICE DOOR LOCATION FOUND CORRODED. CF1, CHANNEL BTW FR 20-22 AT SERVICE DOOR BLENDED OUT OF LIMIT. REPAIR PART FABRICATED. AT CF1, CHANNEL BTW FR 20-22 AT SERVICE DOOR, REPAIR PART INSTALLED.SDR SWAA2025072984028Web · crackedCRACK INDICATION FOUND ON HORIZONTAL PRESSURE DECK WEB AT RBL 55 BETWEEN BS 663 TO BS 675 AT MAIN WHEEL WELL COMPARTMENT. CRACK LENGTH: 0.322 IN. APPLIED FILLET-CAP SEALANT LOWER SIDE BETWEEN REPAIR PARTS IAW SOPM 20-50-19 AND INSTALLED FASTENER ON REPAIR ARESDR SWAA2025072983773Stub Frame · crackedCRACK INDICATION ON STUB FRAME LOCATED BETWEEN BS 294.5 TO BS 296.5 BTW S8R TO S9R AT FWD GALLEY DOOR AREA. CRACK LENGTH: 0.937 IN. REPLACED STUB FRAME LOCATED BETWEEN BS 294.5 TO BS 296.5 BTW S-8R TO S-9R AT FWD GALLEY AT PASSENGER CABIN IAW SRM 51-40-02, SDR SWAA2025072884027Pressure Deck · crackedCRACK INDICATION FOUND ON HORIZONTAL PRESSURE DECK WEB AT LBL 31 BETWEEN STA 663 TO STA 675 AT MAIN WHEEL WELL COMPARTMENT. CRACK LENGTH: 0.250 IN. INSPECT RII REJECTED STEP 23 DUE TO SEVERAL FASTENER FROM THE INTERNAL SIDE AND EXTERNAL SIDE OF REPAIR WERE FOSDR JJBA20250728104Shear Tie · crackedSHEAR CLIP AT FR60 BTW STR 19R-20R FOUND CORRODED. SHEAR CLIP AT FR60 BTW STR 19R-20R BLENDED OUT OF LIMITS. SHEAR CLIP AT FR 50 BTW STR 19R-20R REMOVED AND INSTALLEDSDR AALA202507256513Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FLOOR SUPPORT +Y1292 LOC. AT LEVEL FR16 AT FWD GALLEY AREA. (CORRODED AREA L: 1.739 INCH, W: 1.220 INCH AND D: 0.010 INCH). MAINTENANCE REPLACED FLOOR SUPPORT +Y1292 LOC. BTW FR12 TO FR24 AT FWD GALLEY AREA IAW A319 SRM SDR ASAA2025062059615Doubler · corrodedFWD CARGO ANTENNA DOUBLER STA 500 TO 500A BETWEEN STR 28L AND 28R HAS CORROSION. GROUNDED - YES. FWD CARGO ANTENNA DOUBLER STA 500-500A FOUND TO BE OUT OF LIMITS WITH 100% MATERIAL LOSS REMOVED AND REPLACED ANTENNA DOUBLER IAW B737-700 SRM 51-40-02-0G-0. W=3"SDR ASAA2025062059597Rib · crackedL/H HORIZONAL RIB #7 HAS CRACKS MULTPLE PLACES (3EA). GROUNDED - YES. REMOVED DAMAGE RIB #7 AND REPAIR IAW B737-700 SRM 55-10-09-2R-4.SDR AALA202507219572Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION WEB FRAME 20 AND STR23R FWD GALLEY AREA CORROSION ARE: L:2.68 INCH W: 1.48 INCH D: 0.02 INCH. MAINTENANCE REPLACED WEB LOC FR 20 AND STR23 RH FWD GALLEY AREA IAW A 319 SRM 51-42-11-801 AND SRM 51-72-11-911-001, DWG D531SDR AALA202507212816Frame Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON E & E COMPARTMENT STRINGER 23L AT BS 318. REPLACED FRAME ASSEMBLY (AALA202507217304) AND ANGLE (AALA202507212816) PER AARD 51-00-05-1.SDR AALA202507217304Frame · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON E & E COMPARTMENT STRINGER 23L AT BS 318. REPLACED FRAME ASSEMBLY (AALA202507217304) AND ANGLE (AALA202507212816) PER AARD 51-00-05-1.SDR SWAA2025071783852Panel · pulledLH WING TRAILING EDGE PANEL 561BB HAS DAMAGED SCREW HOLES UPPER SURFACE. LOCATED AFT EDGE ROW FROM SCREWS PULLING THROUGH COMPOSITE PANEL. ACCOMPLISHED REPAIR TO AREA REF SRM 51-70-04-2R-9 PER CORRECTIVE ACTIONS 1 AND 2. RESTORED FINISH TO AREA REF AMM 51-SDR SWAA2025071783857Panel · damagedLH WING TRAILING EDGE PANEL 561AB HAS DAMAGED SCREW HOLES UPPER SURFACE. LOCATED AFT EDGE ROW FROM SCREWS PULLING THROUGH COMPOSITE PANEL. REMOVED DAMAGE AND ACCOMPLISHED REPAIR REF SRM 51-70-04-2R-9 SEE C/A 1-4. RESTORED FINISH TO REPAIR AREA REF AMM 51-21-99SDR SWAA2025071783858Panel · pulledLH WING TRAILING EDGE PANEL 561CB HAS DAMAGED SCREW HOLES UPPER SURFACE. LOCATED AFT EDGE ROW FROM SCREWS PULLING THROUGH COMPOSITE PANEL. REMOVED DAMAGE AND ACCOMPLISHED REPAIR REF SRM 51-70-04-2R-9 SEE C/A 1-4. RESTORED FINISH TO REPAIR AREA REF AMM 51-21-99SDR SWAA2025071683989Rib · crackedCRACK ACCESS PANEL 341B LEADING EDGE RIB LOCATED LE STA 105.26 RT HORIZONTAL STAB. REPLACED RIB LOCATED LEADING EDGE LE STA 105.26 ON RT HORIZONTAL STAB IAW B737-700 SRM 51-10-02 ITEM 9; SRM 51-40-02 AND DWG:186A1001 SHEET: 11 AND SHEET: 13 REV A ; DWG:186A13SDR JJBA20250716053Shear Tie · corrodedCF1, SHEAR CLIP AT FR15 BTW STR 15R-16R FOUND CRACKED. CF1, SHEAR CLIP AT FR15 BTW STR 15R-16R REMOVED AND REPLACEDSDR JJBA20250716052Shear Tie · corrodedSHEAR CLIP AT FR61 BTW STR 19R-20R FOUND CORRODED. SHEAR CLIP AT FR61 BTW STR 19R-20R BLENDED OUT OF LIMITS. SHEAR CLIP AT FR61 BTW STR 19R-20R DRILLED NEW HOLES IN NEW SHEAR CLIP. INSTALLED NEW SHEAR CLIP AT FR61.SDR SWAA2025071583639Light · brokenBROKEN PHOTOLUMINESCENT STRIP RH SIDE AT PASSENGER CABIN (6 EA) 2025-389875<[01] THE REPLACEMENT PHOTOLUMINESCENT STRIP RH SIDE AT PASSENGER CABIN (6 EA) SEE TASK 733-50-01 (TTG8Q00FRFA6).;[02] COMPLETED JOBSDR SWAA2025071583637Light · brokenBROKEN PHOTOLUMINESCENT STRIP LH SIDE AT PASSENGER CABIN (5 EA) THE REPLACEMENT PHOTOLUMINESCENT STRIP LH SIDE AT PASSENGER CABIN (5 EA) SEE TASK 733-50-01 (TTG8Q00FRFA6).;[02] COMPLETED JOBSDR SWAA2025071584051Seat Track · corrodedCORROSION ON SEAT TRACK LBL 25 AT BS480+17; BS500A+8; BS500D+10. VERIFIED APPLICABILITY PER SRM 53-00-52-1A-1. REMOVED CORROSION ON SURFACE OF SEAT TRACK AT DISCREPANCY AREAS; WERE FOUND WITHIN LIMIT; PER SRM 53-00-52-1A-1; STEP 4A(2)(A); FIG 103; DETAIL A. SDR IPXA2025071524507Stringer · crackedMAJOR REPAIR, STRINGER CRACK, FWD SIDE OF STA 740 S-32L LEVEL 1. ACCOMPLISHED EO-94494-REQ1 REV.1 AND EGAT EI F2025A53M-1296 REV.1 2.SDR IPXA2025071024150Stringer · crackedMAJOR REPAIR. STRINGER CRACKED, AFT SIDE OF BS 2360 S1R. PERFORM EO-94356-REQ1 REV.1 AND EI NO.F2025A53M-1290 REV.3.SDR IPXA2025071520298Stringer · crackedMAJOR REPAIR. STRINGER CRACKED, FWD AND AFT SIDE OF STA 2180 S-38R. PERFORMED EO-94498-REQ1 REV 1, EO-94498-REQ1, REV 2, & EI F2025A53M-1429, REV 1.SDR IPXA2025071424320Stringer · crackedMAJOR REPAIR, STRINGER CRACK, FWD OF STA 2360 S-21R LEVEL 1 (REPAIR) 1. PERFORM EO-94413-REQ1 REV.1 AND EI NO.F2025A53M-1294 REV.2 2.SDR IPXA2025071027826Support Angle · corrodedAPU INLET INTERNAL ACCESED FROM 311 SHOWS SIGNS OF ADVANCED CORROSION AND DELAMINATION AROUND NUTPLATES AND AREA WHERE DUCT ATTACHES TO FUSLAGE ON ALL SIDE. REMOVED UPPER AND LOWER NUT PLATE SUPPORT ANGLE AT APU INLET INTERNAL IAW SRM 51-40-02-G-0. FABBRICATSDR CALA2025071406492Frame · dentedFWD CABIN, FRAME AT STA 310.5, AROUND S-6 L HAS A DENT ESRF REPORTING PERFORMED REPAIR AT FRAME STA 310.5 AROUND S-4L I.A.W B757-300 U AL EC/RA#:5310-08635 PART 1 INTERIM REPAIR AND VT MAE EA 757-531 0-13-A3981. MAJOR REPAIR ACCOMPLISHED AND COMPLETED.SDR IPXA2025070534130Fuel Tank · corrodedFOUND CORROSION AT FUEL TANK UPPER SKIN M. CABIN STA 1239 XCW=-81.00 ATA 53-10.REMOVED 6EA FASTENERS AND REMOVED CORROSION AT FUEL TANK UPPER SKIN M. CABIN STA. 1239 XCW=-81.00 PER MD11 SRM 57-10-01-1A-1 FIG. 101. ACCOMPLISHED ON E.A.# 011-5730-01-B0525 REV. PSDR JJBA20250711038Angle · crackedCF1, ANGLE ON INBD SIDE OF LH OMEGA BEAM BTW FR 19-20 FOUND CRACKED. CF1 ANGLE ON INBD SIDE ON LH OMEGA BEAM BTW FR 19-20 REMOVED AND REPLACEDSDR R61A2025071000302Doubler · corrodedUPON REMVOAL OF WASTE PAN NOTED CORROSON ON FWD LOWER CORNER. REMOVED AND REPLACED CFIII WASTE BOX DOUBLER. REF: EMB SRM 51-40-08SDR CALA2025070906372Frame · dentedAFT CARGO COMP, RH SIDE, LOWER FRAME STA 1300, HAS A DENT. PERFORMED REPAIR ON RH WIDE FRAME 1300 IAW EA 757-5360-13-A3953 AND EC/RA 5360-01982. MAJOR REPAIR.SDR IPXA2025070524243Stringer · crackedMAJOR REPAIR. STRINGER CRACK, AFT SIDE OF BS 2377 S5L. ACCOMPLISHED REPAIR IAW EO-94407-REQ 1. REV 1 AND EGAT EI F2025A53M-1291, REV 2.SDR IPXA2025070721187Stringer · crackedMAJOR REPAIR, STRINGER CRACKED, FWD SIDE OF BS 2180, S36R. ACCOMPLISHED REPAIR IAW EO-94312-REQ1, EGAT WORK SHEET 50456, AND SRM 53-60-03-2R-4, REV.46.SDR IPXA2025070724446Stringer · crackedSTRINGER CRACK, AFT SIDE OF STA 740 S-41L LEVEL 1 (REPAIR) 1. RII COMPLETED FOR EGAT WORK SHEET NO.50431 STEP 24. RII COMPLETED FOR EGAT EI NO.F2025A53M-1385 SEQUENCE A STEP 5.SDR IPXA2025070724371Stringer · crackedSTRINGER CRACK, FWD SIDE OF STA 740 S-47R LEVEL 1 (REPAIR) 1. RII COMPLETED FOR EGAT WORK SHEET NO.50430 STEP 24 - RII COMPLETED FOR EGAT EI NO.F2025A53M-1386 SEQUENCE A STEP 5.SDR IPXA2025070734130Fuel Tank · corrodedFOUND CORROSION AT FUEL TANK UPPER SKIN M. CABIN STA 1239 XCW=-81.00 ATA 53-10 VERIFIED STEP 27 VERIFIED REPAIR ACCOMPLISHED IN ACCORDANCE WITH EO-94206-REQ1 AND VT-SAA EA 011-5730-01-B0525 REV IRSDR 2025FA0000454Arm · brokenAIRCRAFT BEING OPERATED BY TWO PILOT CREW. SIC WAS BACK TAXIING ON RUNWAY IN PREP FOR TAKEOFF. SIC MANEUVERED FOR A RIGHT 180 ON THE RUNWAY AND MADE THE RIGHT TURN. ABOUT HALF WAY THROUGH THE 180, CREW HEARD AND FELT A LOUD THUMP COMING FROM THE FLOOR. AFTER T