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 SWAA2025090395131Intercostal · crackedCRACK WEB - INTERCOSTAL FLOOR STRUCTURE LOCATED BS312 TO BS 328 AND LBL 46 FWD GALLEY AND LAV. REPLACED NEW WEB - INTERCOSTAL FLOOR STRUCTURE LOCATED BS312 TO BS 328 AND LBL 46 FWD GALLEY AND LAV AND FASTENERS IAW B737-700 SRM 51-40-02 AND DWG: 141A5400 SHEESDR SWAA2025090395141Strap · corrodedCORROSION ON STRAP LOCATED BS 1016 TO BS 1040 RBL 18 WL 208.1 AT AFT GALLEY AREA. REPLACED STRAP AND FASTENERS LOCATED BS 1016 TO BS 1040 RBL 18 WL 208.1 AT AFT GALLEY AREA IAW B737-700 SRM 51-40-02; SRM 51-10-02 ITEM 9 AND DWG: 147A5730 SHEET: 23 REV: C.SDR SWAA2025090395143Strap · corrodedCORROSION ON STRAP LOCATED BS 1006 TO BS 1040 AND LBL 3 WL 208.1 AT AFT GALLEY AREA. REPLACED STRAP LOCATED BS 1006 TO BS 1040 AND LBL 3 WL 208.1 AT AFT GALLEY AREA IAW B737-700 SRM 51-40-02 AND DWG: 147A5600 SHEET: 32 REV:B .SDR SWAA2025090394843Web · crackedCRACK INDICATION ON HORIZONTAL PRESSURE DECK WEB RBL40 STA 633 AT PASSENGER CABIN (1 E/A) CRACK LENGTH 0.200 INCH . PERFORMED PERMANENT REPAIR ON PRESSURE DECK WEB RBL 30 TO RBL 60 STA 663 TO STA 675 AT PASSENGER CABIN IAW SRM 53-40-51-2R-2 REPAIR 2.SDR SWAA2025090395133Web · crackedCRACK WEB - INTERCOSTAL FLOOR STRUCTURE LOCATED BS 312 TO BS 328 AND RBL 31 FWD GALLEY AND LAV. REPLACED WEB - INTERCOSTAL FLOOR STRUCTURE LOCATED BS 312 TO BS 328 AND RBL 31 FWD GALLEY AND LAV IAW B737-700 SRM 51-40-02-0G AND DWG: 141A5400 SHEET: 39 REV: -.SDR SWAA2025090395144Tie Clip · crackedCRACK TIE CLIP LOCATED 277 AND S-10R PASSENGER CABIN . REPLACED TIE CLIP LOCATED 277 AND S-10R PASSENGER CABIN IAW B737-700 SRM 51-40-02-0G-0; SRM 51-10-02-0G-0 ITEM 9 AND DWG 141A1110 SHEET: 18 REV: -.SDR SWAA2025090395117Bear Strap · crackedCRACK INDICATION ON BEAR STRAP FORWARD GALLEY DOOR BETWEEN BS 291-BS 294.5 AND BETWEEN S-8R AND S-9R .CRACK LENGTH 0.125 IN.APPROX. AT PASSENGER CABIN REPAIRED FUSELAGE BEAR STRAP FWD GALLEY DOOR LOCATED BTW BS 277 TO BS 320 AND BTW STR 5R TO STR 10R IAW EA M-SDR SWAA2025090395118Stub Frame · crackedCRACK INDICATIONS(2EA) ON STUB FRAME LOCATED BETWEEN BS 294.5 TO BS 296.5 AND BETWEEN S-8R TO S-9R AT FWD GALLEY DOOR AREA CRACK LENGTHS 1.00 IN. AND 1.187 IN. APROX.AT PASSENGER CABIN. REPLACED STUB FRAME LOCATED BETWEEN BS 294.5 TO BS296.5 AND BETWEEN S-7R SDR SWAA2025090395124Access Panel · damagedELONGATED HOLES ON ACCESS PANEL 561BB TRAILING EDGE AT LT WING. REPAIRED ACCESS PANEL 561BB TRAILING EDGE AT LT WING IAW B737-700 SRM 51-70-04-2R-9 REPAIR 9.SDR SWAA2025090395125Access Panel · damagedELONGATED HOLES ON ACCESS PANEL 661AB TRAILING EDGE AT RT WING . REPAIRED ACCESS PANEL 661AB TRAILING EDGE AT RT WING IAW SRM 51-70-04-2R-9 REPAIR 9.SDR SWAA2025090395126Access Panel · elongatedELONGATED HOLES ON ACCESS PANEL 661BB TRAILING EDGE AT RT WING. REPAIRED ACCESS PANEL 661BB TRAILING EDGE AT RT WING IAW SRM 51-70-04-2R-10 REPAIR 10.SDR SWAA2025090395127Access Panel · crackedELONGATED HOLES ON ACCESS PANEL 561CB TRAILING EDGE AT LT WING. REPAIRED ACCESS PANEL 561CB TRAILING EDGE AT LT WING IAW SRM 51-70-04-2R-9 REPAIR 9.SDR IPXA2025072908797Seat Track · corrodedMAJOR REPAIR, MDC FLOOR STRUCTURE SEAT TRACK WITH CORROSION BTWN FR 28 THROUGH FR 31 AT Y1959. INSTALLED 3(EA) FLOORBOARD PANELS IAW AMM 53-10-23/0401 WITH RETAINED HARDWARE. INSTALLED 2(EA) FWD CARGO SIDEWALL PANEL IAW AMM 25-54-10/201.SDR AALA202508281925Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO INTERCOSTAL LOCATED FROM BS 312 TO BS 344 AT S21L. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR SWAA2025082795110Skin · debondedDEBONDED EXTERNAL SKIN IB MAIN FLAP TRAILING EDGE WED GE LOWER SURFACE AT LT WING. REPAIRED EXTERNAL SKIN IB MAIN FLAP TRAILING EDGE WEDGE LOWER SURFACE AT LT WING IAW AEM 25-157-02122.SDR SWAA2025082795111Skin · debondedDEBONDED EXTERNAL SKIN IB MAIN FLAP TRAILING EDGE WEDGE LOWER SURFACE AT RT WING. REPAIRED IB MAIN FLAP TRAILING EDGE WEDGE LOWER SURFACE AT RT WING IAW 25-157-02127-WIP1 (COMPONENT - AEM - REPAIR - RH WING - I/B MAIN FLAP - WEDGE ASSY - LOWER SKIN).SDR SWAA2025082795108Intercostal · crackedCRACK ON INTERCOSTAL LOCATED BTW BS 294.5 TO BS 303.9 AT LEVEL STR 16L. PERFORMED REPAIR ON INTERCOSTAL LOCATED BTW BS 294.5 TO BS 303.9 AT LEVEL STR 16L AT FWD GALLEY AREA IAW EA 25-153-02091.SDR SWAA2025082794825Floor Panel · crackedCRACK ON FLOOR PANEL IN E/E AVIONIC COMPARTMENT. REPAIRED FLOOR PANEL IAW SRM 53-00-50-2R-1, REPAIR 1.SDR SWAA2025082795109Tie Clip · crackedCRACK ON TIE CLIP LOCATED BS 277 AT LEVEL STR 10R AT FWD GALLEY AREA. REPLACED TIE CLIP LOCATED ON BS 277 STR 10 AT FWD GALLEY AREA IAW B737-800 SRM 51-40-02-0G ; SRM 51-10-02 PARAGRAPH 9 ;DWG 141A1110 SHEET 18 REV - AND DWG 141A8380 SHEET 21 REV-.SDR SWAA2025082795104Frame · crackedCRACK ON FRAME LOCATED BS 312 BTW STR 5L TO STR 6L AT FWD GALLEY AREA. PERFORMED REPAIR AT FRAME 312 AND BETWEEN STR 5L TO STR 6L IAW M-22-153-01244. PERFORMED REPAIR AT FRAME 312 AND BETWEEN STR 5L TO STR 6L IAW M-22-153-01244.SDR IPXA2025082508264Support · crackedMDC FLOOR STRUCTURE, R/H SIDE REINFORCEMENT SUPPORT CRACKED AT FR 38.2 AND -Y2462. 21-50 INSTALLED NEW SUPPORT ON MDC FLOOR STRUCTURE, R/H SIDE REINFORCEMENT AT FR 38.2 AND -Y2462. I.A.W A300-600 SRM 51-40-21SDR SWAA2025082194781Web · cracked#1 ENG INBD FAN COWL VERTICAL WEB CRACKED.<[01] REMOVED AND REPLACED #1 ENG. IB FAN COWL VERTICAL WEB IAW SRM 51-40-02.;[02] C/W INSPECTIONSDR IPXA2025082108648Seat Track · corrodedMAJOR REPAIR. MDC FLOOR STRUCTURE SEAT TRACK WITH CORROSION BTWN FR 27 THROUGH FR 29 AT Y1456. COMPLIED WITH ACCOMPLISH PERMANENT REPAIR PER SRM REV. 42 CHAPTER 53-10-16-201 PARAGRAPH 4 FIGURE 201.SDR AALA202508195389Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION STRINGER 31 R BTW FR 65 TO FR 66 IN BULK CARGO COMPARTMENT MEASURE OF CORROSION ARE L: 3.990 INCH, W: 0.873 INCH, D: 0.020 INCH. MAINTENANCE REPLACED STRINGER 31 RH LOC BETWEEN FR64 TO FR67 BULK CARGO COMPARTMENT IAW A3SDR SIMA20250724003Floor Support · corrodedCABIN FLOOR STRUCTURE LH SHEAR PANEL OTBD SPLICE BETWEEN FR 87-88 HAS POSSIBLE CORROSION. (LEVEL 2 CORROSION). REMOVED AND REPLACED CABIN FLOOR STRUCTURE LH SHEAR PANEL OTBD SPLICE BETWEEN FR 87-88 IAW ERJ 170 SRM 51-40-08.SDR SWAA2025081595102Web · corrodedCORROSION ON AFT CARGO BAY LOWER MAIN SILL WEB AT BS 787+10, RBL 20.5, WL 156. REMOVED AND REPLACED WEB ON ACB LOWER MAIN SILL BS 794 - BS 847, RBL 20.5, WL156 IAW SRM 51-40-02-0G-0 AND DWG 146A8120 REV -.SDR 3EJA202508150007Acm · failedWE BOTH HEARD A LOUD POP/BURST FOLLOWED BY THE CONTINUAL SOUND OF FAST LEAKING AIR. IT SOUNDED LIKE A DOOR SEAL OR AIR DUCT PIPE BURST. WE THEN GOT MULTIPLE RED AND YELLOW CASS MESSAGES ON THE SCREEN. I TURNED AROUND AND IMMEDIATELY NOTICED THAT SMOKE WAS FILLSDR AALA202508128889Support Frame · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT WING AILERON #2 HINGE SUPPORT FRAME HAS EXCESSIVE PLAY. REPLACED HINGE SUPPORT FRAME PER AMM 57-51-31-000-001-A AND AMM 57-51-31-400-001-A.SDR AALA202508120191Support Frame · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT WING AILERON #4 HINGE SUPPORT FRAME HAS EXCESSIVE PLAY. REPLACED HINGE SUPPORT FRAME PER AMM 57-51-31-000-001-A AND AMM 57-51-31-400-001-A.SDR AALA202508122060Support Frame · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT WING AILERON #3 HINGE SUPPORT FRAME HAS EXCESSIVE PLAY. REPLACED HINGE SUPPORT FRAME PER AMM 57-51-31-000-001-A AND AMM 57-51-31-400-001-A.SDR AALA202508122626Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER ELEVATOR #1 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202508127314Support Frame · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT WING AILERON #5 HINGE SUPPORT FRAME HAS EXCESSIVE PLAY. REPLACED HINGE SUPPORT FRAME PER AMM 57-51-31-000-001-A AND AMM 57-51-31-400-001-A.SDR AALA202508120196Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER ELEVATOR #5 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR IPXA2025080308094Floorbeam · corrodedMAIN DECK FLOORBEAM BELOW FLOOR PANEL 242XGF AT BS 1100 RBL 24.75, HAS EXFOLIATED CORROSION, DOT 78-20, FABRICATED 01 EA REPAIR UPPER CHORD SECTION PER E.A.# 757-5340-27-A4084 STEP 8, LETTER A AND B. ACCOMPLISH CATEGORY B REPAIR IN ACCORDANCE WITH EO-94658-REQSDR 2025FA0000542Oil Filter · defectiveTEMPEST OIL FILTER PN AA48109 FOUND DEFECTIVE AT INSPECTION. NEW OIL FILTER HAS A MANUFACTURING DEFECT. THE MOUNT THREADS ARE NOT TRUE TO CENTERLINE OF THE FILTER. THIS IS A SPIN ON OIL FILTER. IT IS A PMA PART AND MFG. AND SOLD IN THE USA. WHEN INSTALLINSDR AALA202508087028Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER ELEVATOR #6 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR IPXA2025080303268Tee Angle · corrodedAT STA 1040 TO 1060 LEFT, UNDER THE RAM AIR DOOR ACTUATOR, T-CHORD HAS EXFOLITATION CORROSION ON UPPER FLANGE, DOT 8-018.RECEIVED NEW INTERCOSTAL FROM TRAVELER # T25/1825274, BATCH #0004248846. RESTORED SURFACE IN NEW INTERCOSTAL IAW AMM 51-21-15 ALODINE PAISDR IPXA2025080408421Floor Support · crackedMDC FLOOR STRUCTURE, L/H SIDE REINFORCEMENT SUPPORT CRACKED BTWN FR 37 AND FR38 AT Y2462. 21-53.REMOVED REINFORCEMENT SUPPORT AT MCD FLOOR STRUCTURE BTWN FR 37 AND FR 38, Y 2462 LH I.A.W. A300-600 SRM 51-40-21.LOCATED AND DRILLED REINFORCEMENT SUPPORT STRUCTURSDR AALA202508047357Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER ELEVATOR #3 HINGE ARM END HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202508013798Support Frame · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON WING TO BODY FAIRING SUPPORT FRAME AT BS 727 FROM LBL 15 TO RBL 15. REPLACED FRAME PER SRM 53-60-71.SDR CALA2025080107200Frame · crackedCRACK FOUND AT LT STA 727 FRAME INNER CHORD AT S18A LWR HOLE. ACCOMPLISHED REPAIR AT LOWER AFT FITTING ON LT BS 727 FRAME INNER CHORD AT S18L IAW EC/RA 5310-08657 (ESR-WI 2023573-15-12410)SDR VNAA2025073111101Gcu · faultedACFT ESS BUSS CAUTION MSG IN FLIGHT. REMOVED AND REPLACED IDG GCU 1 IAW AMM 24-11-07-000/400-801-A01, PERFORMED OPS TEST IAW AMM 24-11-01-710-801-A01-PSA, OPS CHECK GOOD.SDR AALA202507298377Connector · looseAIRCRAFT IN BASE MAINTENANCE: ROW 3AB EMERGENCY LIGHT INOPERATIVE. TIGHTENED LOOSE CONNECTION UNDER SEAT CUSHION, PER B737-NG SWPM 20-90-14. OPERATIONAL CHECK GOOD.SDR DALA2025072905700Seat Track · corrodedCORROSION FOUND CORROSION ON SEAT TRACK FR74 RBL 43. REMOVED AND REPLACED SEAT TRACK AT FR 74 RBL 43 PER BOMBARDIER DWG# PL C01342701 REV G AND A220 ASRP BD500-A-J51-41-02-00AAA-078A-A. (LP# 1105839)SDR DALA2025072905699Skin · corrodedCORROSION FOUND ON EXTERNAL SKIN FR79, AFT LAP JOINT, STRINGER 36 TO 37L. BLENDED CORROSION ON EXTERNAL SKIN @ LAP JOINT FR 79, STGR 36R- 36L IAW A220 ASRP 31-21-06-01. FOUND OUT OF LIMITS IAW A220 ASRP 53-61-01. RESTORED FINISH TO AFFECTED AREA IAW ERA 627700SDR DALA2025072905698Skin · corrodedCORROSION FOUND ON EXTERNAL SKIN FR77 TO FR78 AROUND STRINGER 36. BLENDED OUT CORROSION ON EXTERNAL SKIN @ FR 77-78 @ STGR 36 IAW A220 ASRP 51-21-06-01AAA. FOUND OUT OF LIMITS IAW A220 ASRP 53- 61-01. RESTORED FINISH TO AFFECTED AREA IAW ERA 627700-14 REV. ASSSDR DALA2025072905697Duct · damagedAPU HIGH PRESSURE BLEED DUCT HAS PLY SEPARATION AT FIRE LOOP STANDOFF, 10 INCHES FWD OF FRAME 85. PER AMDS, REQUIRES CUSTOMER RESPONSE CENTER NOTIFICATION. SCEPTRE LOG PAGE ENTERED FOR SDR REPORTING. SUMMARY SEE NR FOR ADDITIONAL INFORMATION 066-0001:3610-2002SDR CALA2025072907033Stringer · corrodedFWD PIT STRINGER IS CORRODED INSIDE U-CHANNEL AT APPROX BS 500G+7 S26L, UNDERNEATH. REMOVED CORROSION BS 500G+7 S26LT, ORIGINAL MAT. THICKNESS .045, MAT. REMAINING .035, MAT. LOSS .010 FOUND TO BE OUT OF LIMITS IAW SRM 53-00-03-1A-1 & SRM 53-30-01. REMOVED STRSDR CALA2025072907032Support Beam · wornRH WING CENTER SECTION LOWER SUPPORT BEAM LOWER CHORD AT RBL 40.875, FOUND LATCH STOP WEARING STRIKER PLATE AND STRUCTURE. REMOVED SEAL AND SEAL RETAINER TRIM FROM ALONG THE RH LOWER CHORD TO FOM IAW SRM 51-40-02. CUTOUT DAMAGE AS PER REF STEP 4.E OF SRM 57-10SDR AALA202507283360Girt Bar · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD SERVICE DOOR GRIT BAR IS VERY DIFFICULT TO OPERATE. FORWARD CABIN SERVICE DOOR GIRT BAR ADJUSTED. PER AMM 25-66-01. OPERATIONAL CHECKED GOOD.