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 IPXA2025070324287Stringer · crackedMAJOR REPAIR. STRINGER CRACKED, AFT SIDE OF BS 2360, S7R. ACCOMPLISHED REPAIR IAW EO-94424-REQ1 REV 1, EGAT EI 2025A53M-1358, REV 1, SRM 53-80-03-2R-3, REV 46 /TR:53-153, AND EGAT WORK SHEET 50429.SDR IPXA2025070122163Stringer · crackedSTRINGER CRACKED, FWD SIDE OF STA 2598 S-7L, LEVEL 2. COMPLETED EGAT WORK SHEET NO.50426(SRM 53-80-03-2R-2 REV.46 / TR:53-152) STEP 30SDR IPXA2025070122139Stringer · crackedFAULT- STRINGER CRACK, FWD SIDE OF STA 2598 S-6L, LEVEL 2 (REPAIR). .PERFORM EO-94231-REQ1 REV.1 AND EI NO.F2025A53M-1368 REV.0 AND EGAT WORK SHEET NO.50427. 2.JOB COMPLETED. EO-94231-REQ1 ATTACHED TO FAULT. VERIFY REPAIR IS ACCOMPLISHED PER GMM 04.02.01.15 RSDR IPXA2025070122179Stringer · crackedFAULT-STRINGER CRACK, FWD SIDE OF STA 2598 S-8L, LEVEL 2 (REPAIR). PERFORM EO-94235-REQ1 REV.1 AND EI NO.F2025A53M-1370 REV.0 AND EGAT WORK SHEET NO.50428. C/W REVIEWSDR ASAA2025062059151Web · corrodedAFT CARGO DOOR SILL WEB HAS AREAS OF CORROSION. GROUNDED - YES. REMOVED DAMAGE, FOUND TO BE OUT OF LIMITS I.A.W. B737-700 SRM 53-60-15-01-1, REMOVED AND REPLACED AFT CARGO DOOR SILL WEB I.A.W. B737-700 SRM 51-40-02-0G-0.W= 3 O= .045 R= .029 L= 36 D= .016.SDR ASAA2025062059149Frame · corrodedAFT CARGO STA 767 FRAME SPLICE HAS CORROSION RBL 24. GROUNDED - YES. REMOVED AND REPLACED FRAME SPLICE AT F.S 767 AND RBL 24 I.A.W. BOEING 737-700 SRM 51-40-02-0G-0.W= .75 O= .063 R= .055 L= 3.5 D= .008.SDR ASAA2025062059145Frame · corrodedFWD CARGO AFT BULKHEAD CENTER SUPPORT HAS CORROSION. GROUNDED - YES. REMOVED DAMAGE, FOUND TO BE OUT OF LIMITS I.A.W. B737-700 SRM 53-30-08-1A-1, REMOVED AND REPLACED FWD CARGO AFT BULKHEAD CENTER SUPPORT I.A.W. B737-700 SRM 51-40-02-0G-0.W= 1.5 O= .071 R= .04SDR SWAA2025063083708Battery Pack · inoperativeEMERGENCY EXIT LIGHT BATTERY PACK (M2816) WILL NOT CHARGE <[01]. OPENED FORWARD BATTERY ACCESS DOOR IAW AMM 33-51-06-960-805 STEPS 4.A-4.E(3E). REPLACED AND ACCOMPLISHED INSTALLATION TEST OF EMERGENCY EXIT LIGHT BATTERY PACK (M2816) IAW AMM 33-51-06-960-805 SSDR SWAA2025063083707Battery Pack · inoperativeEMERGENCY EXIT LIGHT BATTERY PACK (M1676) WILL NOT CHARGE <[01]. OPENED AIR GRILL AT M1676 BATTERY PACK POSITION IAW AMM 33-51-06-960-805 STEPS 4.A-4.E(2) AND 4.E(3G). REPLACED AND ACCOMPLISHED INSTALLATION TEST OF EMERGENCY EXIT LIGHT BATTERY PACK (M1676) ISDR SWAA2025063083536Service Panel · corrodedPOSSIBLE CORROSION AT STA 850 AT THE WASTE TANK SERVICE PANEL ALONG STRINGER 25L.<[01] REMOVED AND REPLACED WASTE TANK SERVICE PAN ASSY IAW B737 SRM 51-40-02 AND BOEING DWG#DWG 146A7400-16#B ID:22;[02] 02 - INSPECTED PER B737 SRM 51-40-02 AND BOEING DWG# 146A7SDR AALA202506301015Wire Harness · damagedAIRCRAFT IN BASE MAINTENANCE: SEAT ROW 21C EMERGENCY LIGHT INOPERATIVE. MAINTENANCE FOUND WIRING HARNESS TO SEAT ROW 21 ABC EMERGENCY LIGHT DAMAGED AND REPLACED IT PER CMM 25-21-6. A SATISFACTORY OPERATIONAL CHECK WAS ACCOMPLISHED.SDR IPXA2025062722010Antenna · no discrepancySUPPORT STRUCTURE INSTALLATION FOR SATCOM HGA-7001 ANTENNA. PAPER CHECK OK.SDR IPXA2025062521798Angle · brokenBROKEN - ANGLE, AFTER CARGO DOOR FORWARD LINK AREA (REPLACE) FORMED THE JOGGLES OF THE REPAIR ANGLE I.A.W. EGAT EI NO. F2025A52M-1318 SEQUENCE A STEP 1.C (FORMED THE JOGGLES OF THE REPAIR ANGLE, REFER TO 143T6482-5 DRAWING REQUIREMENTS.) REV.0 REPAIR DAMAGE ASDR IPXA2025062631112Attach Angle · crackedFLOOR SUPPORT INTERCOSTAL ATTACH ANGLE AT STA 972/FR10 LEFT SIDE IS CRACKED. INSTALLED NEW ANGLE AT FLOOR SUPPORT INTERCOSTAL ATTACH ON STA 972/FR10 LEFT SIDE IAW SRM 51-40-21.SDR IPXA2025062631088Attach Angle · crackedFLOOR SUPPORT INTERCOSTAL ATTACH ANGLE AT STA 972/FR10 RIGHT SIDE IS CRACKED. INSTALLED NEW ANGLE AT FLOOR SUPPORT INTERCOSTAL ATTACH ON STA 972/FR10 RIGHT SIDE IAW SRM 51-40-21.SDR CALA2025062605927Inspection · noneACCOMPLISH AN NDT INSPECTION OF THE BEAR STRAP AND INNER CHORD, IN THE AREA OF THE REPAIR (INSTALLED PER EA 5330-04213 OP 2), BEFORE 50,000 TOTAL AIRCRAFT CYCLES. AFTER THE ACCUMULATION OF 46,500 TOTAL AIRCRAFT FLIGHT CYCLES, BUT BEFORE 47,000 TOTAL AIRCRAFT FSDR IPXA2025062519505Vhf Comm · inoperativeDURING CRUISE EICAS ALERT THEN STATUS MESSAGE EQUIPMENT SMOKE ALONG WITH VHF DATA OFF RESULTED IN ATB. REPLACED C VHF TRANSCEIVER PER AMM 23-12-01-404-027, GROUND TEST, BITE TEST, AND OPS TEST OK REF AMM 23-12-00.SDR CALA2025062505874Shear Plate · corrodedCABIN FLOOR LH SHEAR PLATE AT FR 69-70 HAS CORROSION AND MISSING RIVETS AT Y1292 A3NB-53-3-6222. R & R L/H SHEAR PLATE AT FR 69-70 IAW SRM A319 51-42-11.SDR FDEA202506201015Closeout Panel · gougedDURING ADJUSMENT OF #8 TELESCOPING DUCT SEAL FOUND EDGE NICKED. REPAIRED RH WING # 8 SLAT LWR INBD CLOSE OUT PANEL O/B EDGE BETWEEN WS 456.48 - 464.48. IN REF. TO 767 SRM 57-43-01-2R FIG.201 SHEET:4, REPAIR:3, AND 767 SRM 51-70-08-0G PARA 5.G. THIS IS A MASDR AALA202506245779Bottle · low pressureAIRCRAFT IN BASE MAINTENANCE: L1 DOOR BOTTLE LOW. MAINTENANCE SERVICED L1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER WITH NITROGEN IAW AMM 52-10-00.SDR AALA202506244671Wire Harness · shortedAIRCRAFT WAS NOT GROUNDED: DURING PS CHECK FOUND LH/RH FWD AFT EMERGENCY EXIT ROW EXIT MARKERS AND RED SEAT MOUNTED RED EMERGENCY LIGHTS ALL OUT. ALSO RECEIVED R ESPU FAULT DURING IBIT. RH ESPU LOCATED AT EMERGENCY EXITS IS GIVING UNIT FAULT. EPSU IBIT SHOWINGSDR DALA2025062404726Slide · warning lightL WING SLIDE INDICATION ON TAXI IN. REMOVED AND REPLACED LT OVERWING SLIDE ASSEMBLY IN REF TO AMDS WORK CARD 2563-4002. OPS NML. MEL AND PLACARD REMOVED. (361396) RII TASK COMPLIED WITH PER AMDS CARD 2563-4002. (LP# 7411362)SDR DALA2025062404725Seat Track · corrodedAFT FUSELAGE SEAT TRACK CORROSION AFT OF STA 72 LBL 43.5. SCEPTRE LOG PAGE ENTERED FOR SDR REPORTING. SUMMARY SEE NR FOR ADDITIONAL INFORMATION 001-0569:5321-2021/006 00306 REMOVED AND REPLACED SEAT TRACK PER ER/A 62 3167-14TR REV O SECTION 1 CLOSING REQUIREMESDR DALA2025062404724Seat Track · corrodedCORROSION ON SEAT TRACK AT FR 74 RBL 43. REMOVED AND REPLACED SEAT TRACK AT FR 61 TO FR 74 RBL 43 IAW A220 ASRP BD500-A-J51-42-20-00AAA-078A-A AND DWG # BOMBARDIER PL C01342701 REV: G. (LP# 1036303)SDR DALA2025062404723Seat Track · corrodedCORROSION ON SEAT TRACK AT FR 74 LBL 23. REMOVED AND REPLACED SEAT TRACK BETWEEN FR 57+6" TO FR 74+6", LBL 23, WL 157 IAW A220 ASRP BD500-A-J51-42-21-00AAA-078A-A AND BOMBARDIER PL: C01342701. REV: G. (LP# 1036295)SDR DALA2025062404722Door · corrodedFORWARD LEDGE OF LAV SERVICE DOOR OPENING HAS SIGNS OF CORROSION. SCEPTRE LOG PAGE ENTERED FOR SDR REPORTING. SUMMARY SEE NR FOR ADDITIONAL INFORMATION 001-0519:5300-2019/002 00191 REPAIRED PER ER/A PRI 609317-14 REV 0, REV. 1, REV. 2, AND FINAL ER/A 609317 -1SDR DALA2025062404721Seat Track · corrodedAFT RH, O/B SEAT TRACK HAS EVIDENCE OF CORROSION FROM FR72 TO FR74. REMOVED CORROSION, FOUND OUT OF LIMITS, REMOVED AND REPLACED AFT R/H O/B SEAT TRACK IAW A220 ASRP J51-21-06, J53-61-49, J51-40- 11 AND J51-42-21. (LP# 1035461)SDR DALA2025062404720Seat Track · corrodedAFT LH, I/B SEAT TRACK HAS EVIDENCE OF CORROSION FROM FR72 TO FR74. REMOVED CORROSION, FOUND OUT OF LIMITS, REMOVED AND REPLACED AFT L/H I/B SEAT TRACK IAW A220 ASRP J51-21-06, J51-61-49, J51-40- 11, J51-42-20. (LP# 1035454)SDR DALA2025062404719Seat Track · corrodedFWD LH, O/B SEAT TRACK HAS EVIDENCE OF CORROSION FROM FR22 TO FR24. REMOVED AND REPLACED SEAT TRACK AT FWD L/H O/B IAW A220 ASRP J51 -42-21, J51-21-06, J51-40-11 JOB COMPLETE, AFTER CORROSION REMOVED FOUND OUT OF LIMITS. (LP# 1035448)SDR DALA2025062404718Seat Track · corrodedFWD RH, I/B SEAT TRACK HAS EVIDENCE OF CORROSION FROM FR22 TO FR24. REMOVED CORROSION AND FOUND FWD R/H I/B SEAT TRACK OUT OF LIMITS IAW A220 ASRP J51-21-06, J53-21-49. REMOVED AND REPLACED DAMAGED SEAT TRACK IAW A220 ASRP J51-42-20, J51-40-11. (LP# 1035442)SDR SIMA20250620001Seal Rest · corrodedFWD CARGO DOOR CUT-OUT STRUCTURE CENTER SEAL REST CORRODED BEYOND LIMITS. (MAJOR REPAIR) (LEVEL 2 CORROSION) REMOVED AND REPLACED FWD CARGO DOOR CUT-OUT STRUCTURE CENTER SEAL REST IAW ERJ 175 SRM 51-40-08.SDR DALA2025062404699Skin · damaged(LOG 1036381) DURING INSPECTION, DENT DAMAGE WAS DISCOVERED TO THE FUSELAGE SKIN AT STA 363 BETWEEN S-17L AND S-18L. DAMAGE REPAIRED PER ERA 626317-14.SDR DALA2025062404698Floor Support · corroded(LOG 1036291) CORROSION ON INTERCOSTAL BTW STA 951 TO STA 960 LBL 48 AT PASSENGER CABIN. INTERCOSTAL BTW STA 951 TO STA 960 LBL 48 AT PASSENGER CABIN WAS REPLACED AND INSTALLED PER B737-800 SRM 51-40-02-0G.SDR AALA202506240761Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE BREAK ASSEMBLY PANEL AT BS 540, RBL 10. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-1.SDR AALA202506238750Wastegate Valve · cloggedAIRCRAFT WAS GROUNDED: FLIGHT ATTENDANTS REPORTED ROTTEN EGGS ODOR IN CABIN DURING DESCENT. ACCOMPLISHED SOF CARD 08L00021001. FOUND LEFT AFT SERVICE DOOR SILL DRAINS NOT DRAINING. THE WASTE VALVE IS CLOGGED. REMOVED AND REPLACED VALVE. PER AMM 38-31-06. OPERASDR AALA202506235637Power Supply · inoperativeAIRCRAFT WAS GROUNDED: RIGHT AFT OVERWING EMERGENCY LIGHT INOPERABLE. REMOVED AND REPLACED EMERGENCY LIGHTING POWER SUPPLY M1671. PER AMM 33-51-06. RIGHT HAND AFT OVERWING EMERGENCY LIGHT OPERATIONAL CHECKS GOOD.SDR ASAA2025062058896Floor Panel · damagedMAIN CABIN FLOOR PANEL 147A5810-446 HAS PEELING FIBERS (PARTS RACK ITEM). GROUNDED - YES. EVALUATED AND REPAIRED IAW ASA B737-900ER SRM 53-00-50-2R-1, SRM 53-00-50-2R-0.SDR SWIA2025062300020Drag Angle · crackedDURING RH VERT STAB-TO-FUSELAGE AFT DRAG ANGLE REMOVAL FIND CRACK ON RH VERT STAB-TO-FUSELAGE FWD DRAG ANGLE #30352476 (FILED OPEN)THIS IS CURRENTLY A WORK IN PROGRESSSDR SWAA2025062384172Slide · looseFWD SERVICE DOOR ESCAPE SLIDE UNSECURED <[01]. REPLACED FWD SERVICE DOOR SLIDE IAW MT 725-61-06.SDR SWAA2025062383699Floor Panel · crackedFWD CARGO FLOOR CRACK DAMAGE <[01]. REMOVED AND INSTALLED NEW FWD CARGO FLOOR PANEL IAW 25?52-10.SDR SWAA2025062384193Girt Bar · out of adjustFWD ENTRY GIRT BAR IS OUT OF ALIGNMENT. <[01] REPOSITIONED THE FWD ENTRY GIRT BAR AS REQUIRED. REF. AMM 25-66-01. OPS CHECK GOOD.SDR SWAA2025062384178Brake · fluctuatesBRAKE SHAKE ENTIRE AIRCRAFT AT SLOW SPEED WHEN APPLYING BRAKES <[01]. R&R #3 BRAKE PER AMM 32-41-41.SDR SWAA2025062383762Battery Pack · failedLEFT AFT BATTERY PACK FAILED CAPACITY CHECK LEFT AFT BATTERY PACK M1670 FAILED CAPACITY CHECK <[01]. R&R LEFT AFT BATTERY PACK PER AMM 33-51-06; [02] R&R LEFT AFT BATTERY PACK M1670 PER AMM 33-51-06.SDR SWAA2025062383787Handle · looseR1 DOOR ASSIST HANDLE LOOSE <[01]. TIGHTNED R1 DOOR ASSIST HANDLE IAW B 737 AMM 2-41-31-400-802-NG. TQ WRENCH T8349R DUE 23/OCT/25; [02] TIGHTNED R1 DOOR ASSIST HANDLE IAW B 737 AMM 2-41-31-400-802-NG. TQ WRENCH T8349R DUE 23/OCT/25.SDR SWAA2025062383601Seal · crackedR/H HORIZONTAL STABILIZER FWD UPPER SLIDING SEAL CRACKED <[01]. REMOVED R/H HORIZONTAL STABILIZER UPPER FWD SLIDING SEAL PER AMM CH.53-31-31.; [02] DRILLED NEW SLIDER SEAL; AND INSTALLED NEW HINGE BRACKET TO NEW SEAL IAW SRM 51-40-05 AND SRM 51-40-02.; [03] SDR SWAA2025062383575Seal · crackedLEFT HORIZONTAL STABILIZER FORWARD UPPER SLIDER SEAL CRACKED / DAMAGED <[01]. R/R STABILIZER TO BODY FRONT SPAR LEFT UPPER SLIDING SEAL PER M/M 53-31-1.SDR SWAA2025062383493Seal · crackedLEFT HORIZONTAL STAB FWD UPPER SLIDING SEAL CRACKED BEYOND LIMITS. <[01] REMOVED AND REPLACED LEFT FWD UPPER HORIZONTAL STABILIZER SLIDING SEAL IAW AMM 53-31-31.SDR SWAA2025062383490Seal · crackedRIGHT HORIZONTAL STAB FWD UPPER SLIDING SEAL CRACKED BEYOND LIMITS. <[01] REMOVED AND REPLACED RIGHT FWD UPPER HORIZONTAL STABILIZER SLIDING SEAL IAW AMM 53-31-31.SDR SWAA2025062383576Seal · crackedRIGHT HORIZONTAL STABILIZER FORWARD UPPER SLIDER SEAL CRACKED / DAMAGED <[01]. 01 - REMOVED AND REPLACED PER [AMM 53-31-31-401 CONFIG 2-NG (STABILIZER TO BODY FRONT SPAR SLIDING SEAL - REMOVAL/INSTALLATION - PERMANENT)].SDR GTIA2025062338965Flashlight · missingJUMPSEAT C FLASHLIGHT MISSING ( FLASHLIGHT AND HOLDERS (FLIGHT DECK OR CABIN) )-R/R FLASHLIGHT AT JUMPSEAT C IAW AMM 25-65-00. THIS CLOSES DMI #3543750-1. PLACARD REMOVED. MOC NOTIFIED