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 SWAA2025120833409Sidewall Support · corrodedCORROSION ON AFT CARGO BAY FLOOR TO SIDEWALL SUPPORT AT BS 727B - 767, RBL 21, WL 155. CORROSION FOUND TO BE OUT OF LIMITS. REMOVED, FABRICATED, AND INSTALLED NEW FLOOR TO SIDEWALL SUPPORT IAW SRM 53-00-53-1A-2, SRM 51-40-02-0G-0, SRM 51-40-05-0G-0, SRM 51-20SDR SWAA2025120833176Floor Panel · pulledPASSENGER CABIN FLOOR PANEL 232QF HAS AREAS OF PULLED STRANDS. FLOOR PANEL 232QF WAS REPLACED WITH A SERVICEABLE FLOOR PANEL IAW SRM 51-10-02-0G-0, PARA 9 A.1, DUE TO AMOUNT OF ALL DAMAGE.SDR SWAA2025120833173Floor Panel · pulledPASSENGER CABIN FLOOR PANEL 232JF HAS AREAS OF PULLED STRANDS. DUE TO THE EXTENT OF DAMAGE, REPLACED FLOOR PANEL 232JF IAW SRM 51-10-02-0G-0, PARA 9, AND AIPC 53-21-00-09A, ITEM 61.SDR SWAA2025120833172Floor Panel · pulledPASSENGER CABIN FLOOR PANEL 232FF HAS AREAS OF PULLED STRANDS. FLOOR PANEL 232FF WAS REPLACED WITH A NEWLY FABRICATED FLOOR PANEL IAW SRM 53-00-50-2R-0.SDR SWAA2025120833171Floor Panel · pulledPASSENGER CABIN FLOOR PANEL 232DF HAS AREAS OF PULLED STRANDS. FLOOR PANEL 232DF WAS REPLACED WITH A SERVICEABLE FLOOR PANEL IAW SRM 51-10-02-0G-0, PARA 9.A.1 DUE TO AMOUNT OF ALL DAMAGE.SDR SWAA2025120833170Floor Panel · pulledPASSENGER CABIN FLOOR PANEL 231WF HAS AREAS OF PULLED STRANDS. FLOOR PANEL 231WF WAS REPLACED WITH A SERVICEABLE FLOOR PANEL IAW SRM 51-10-02-0G-0, PARA 9.A.1 DUE TO AMOUNT OF ALL DAMAGE.SDR SWAA2025120833175Floor Panel · pulledPASSENGER CABIN FLOOR PANEL 231MF HAS AREAS OF PULLED STRANDS. FLOOR PANEL 231MF WAS REPAIRED IAW SRM 53-00-50-2R-1.SDR SWAA2025120833169Floor Panel · pulledPASSENGER CABIN FLOOR PANEL 231JF HAS AREAS OF PULLED STRANDS. THE CABIN FLOOR PANEL 231JF WAS REPLACED WITH A NEWLY FABRICATED FLOOR PANEL IAW SRM 53-00-50-2R-0.SDR SWAA2025120833168Floor Panel · pulledPASSENGER CABIN FLOOR PANEL 231FF HAS AREAS OF PULLED STRANDS. DUE TO THE EXTENT OF DAMAGE, REPLACED THE FLOOR PANEL 231FF IAW SRM 51-10-02-0G-0, PARA 9, AND AIPC 53-21-00-09A, ITEM 250.SDR SWAA2025120333182Attach Angle · corrodedAFT CARGO BAY FRAME TO SIDEWALL SUPPORT ATTACH ANGLE HAS CORROSION ON UPPER FLANGE AT FASTENER HOLES, BS 727D, S19L - S25L. REMOVED AND REPLACED AFT CARGO BAY FRAME TO SIDEWALL SUPPORT ATTACH ANGLE IAW SRM 51-40-02, & DWG 146A12290073 REV -.SDR SWAA2025120333187Sidewall Support · corrodedFORWARD CARGO BAY DOOR SURROUND STRUCTURE HAS CORROSION ON AFT FLOOR TO SIDEWALL SUPPORT AROUND FASTENER HOLES, BS 492 - 500A, RBL 24. REMOVED & REPLACED SIDWALL SUPPORT IAW SRM 51-40-02-0G-0, AND DWG 143A0080 REV-.SDR SWAA2025120333188Sidewall Support · corrodedFORWARD CARGO BAY DOOR SURROUND STRUCTURE FORWARD FLOOR TO SIDEWALL SUPPORT HAS CORROSION AROUND FASTENER HOLES; BS 420 - 440, RBL 24. REMOVED & REPLACED THE SIDEWALL SUPPORT IAW SRM 51-40-02-0G-0, AND DWG 143A0080, REV-.SDR SWAA2025120333428Panel · delaminatedPANEL 194CR HAS DELAMINAION ON OUTER SURFACE. PANEL 194CR WITH DELAMINATION ON OUTER SURFACE WAS REPAIRED IAW SRM 51-70-05-2R-2, & SRM 53-60-70-2R-1.SDR SWAA2025120333427Panel · delaminatedPANEL 194CL HAS DELAMINAION ON OUTER SURFACE. REPAIRED IAW AMM 51-21-99-300-802.SDR ASAA2025110962733Web · corrodedAFT WET AREA RT WEB AT BS 987-1006, RBL 24-45 HAS CORROSION. GROUNDED - YES. REMOVED .015 CORRODED MATERIAL FROM ORIG .080 REMAINING .065 IAW SRM 53-70-51-1A-1 FOUND OUT OF LIMITS, REMOVED LOCATED & DRILLED AND INSTALLED NEW WEB PER DWG 147A5701 SHEET 22 REV-,SDR SWAA2025120233462Floor Panel · delaminatedDELAMINATED FLOOR PANEL 231ZF IN THE PASSENGER CABIN. REPAIRED FLOOR PANEL 231ZF IAW SRM 53-00-50-2R-1, REPAIR 1.SDR SWAA2025120233463Floor Panel · delaminatedDELAMINATED FLOOR PANEL 241BF IN THE PASSENGER CABIN. REPAIRED FLOOR PANEL 241BF IAW SRM 53-00-50-2R-1, REPAIR 1.SDR SWAA2025120233464Support Beam · crackedCRACK TRAILING EDGE DEFLECTION CONTROL RIB SUPPORT BEAM AT LT WING. PERFORMED PERMANENT REPAIR ON TRAILING EDGE DEFLECTION CONTROL RIB UPPER SUPPORT BEAM AT LT WING IAW SRM 57-51-02-2R-3, REPAIR 3.SDR AALA202512013407Plate · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND PYLON SPIGOT FITTING RECEPTACLE BETWEEN PYLON RIBS 4 AND 5. REPLACED SPIGOT FITTING RETAINING PLATE PER SRM 54-51-12-300-002.SDR AALA202511285111Spigot · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION SPIGOT FITTING RECEPTACLE ON LT PYLON L= 4.340 INCH, W= 1.547 INCH D= 0.005 INCH. MAINTENANCE REPLACED SPIGOT FITTING RECEPTACLE OF LT PYLON IAW A319 SRM 54-51-12-300-002.SDR AALA202511289680Hinge Pin · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT WING #2 AILERON HINGE PIN. REPLACED HINGE PIN PER AMM 27-14-41-400-001-ASDR AALA202511263673Shear Tie · damagedAIRCRAFT IN BASE MAINTENANCE: FORWARD CARGO COMPARTMENT SHEAR TIE DAMAGED AT STA 500G BETWEEN S25R AND S26R. REPLACED SHEAR TIE PER SRM 51-40-02-0G.SDR AALA202511253257Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CABIN FLOOR BEAM AT FR 68 AND -Y1162.5. REPLACED FLOOR BEAM PER SRM 51-72-11.SDR SWIA202511240009Seat Track · corrodedRIGHT INBD SEAT TRACK FLANGE BETWEEN FR 84 - 85 CORRODED. PERFORMED REPAIR ON THE SEAT TRACK IAW SRM 53-00-10, REPAIR 01P AND ETD2022-170-022163 REV C.SDR ASAA2025110962438Floor Support · crackedFWD WET AREA INTERCOSTAL AT STA 312-328 LBL45 IS CRACKED. GROUNDED - YES. REMOVED AND REPLACED INTERCOSTAL P/N 141A5410U140 PER B737-900ER SRM 51-40-02 & DRAWING# 141A5400 SHEET 26 REV- PO: 1136869.1, 1133095.1.SDR SWAA2025112033199Battery Pack · inoperativeRIGHT OVERWING EXITS INTERIOR EMERGENCY LIGHTS ARE INOP. REMOVED AND REPLACED BATTERY PACK FOR RIGHT OVER WING EXIT EMERGENCY LIGHTS IAW AMM 33-51-06. OPS CHECKED GOOD IAW AMM 33-51-06.SDR SWAA2025112033197Battery Pack · inoperativeLEFT OVERWING EXITS INTERIOR EMERGENCY LIGHTS ARE INOP. REMOVED AND REPLACED BATTERY PACK FOR LEFT HAND OVER WING EXITS PER AMM 33-51-06. OPS CHECKS GOOD PER AMM 33-51-06.SDR AALA202511203114Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #4 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202511205794Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #3 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202511205790Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #6 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202511201419Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #1 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202511208960Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #5 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR ASAA2025110962420Floor Support · crackedFWD WET AREA INTERCOSTAL AT STA 277-294 RBL2 IS CRACKED. GROUNDED - YES. REMOVED AND REPLACED INTERCOSTAL IAW B737-900ER SRM 51-40-02 & BAC DWG 141A5410 REV A. P/N 141A5410U139 P.O. 1136761.1.SDR SWAA2025111733445Light · brokenEMERGENCY EXIT INDICATOR FWD OF RH AFT OVERWING EXIT IS BROKEN. REMOVED AND REPLACED EXIT LIGHT ASSEMBLY AND OPS CHECK GOOD IAW AMM 33-51-01, AND 33-51-00-710-801.SDR CALA2025111711272Fitting · crackedCRACK DAMAGE ON THE OTBD SIDE, FWD LOWER FLANGE OF MID BULKHEAD FITTING OF THE NR 2 STRUT ASSY AT PPS 174.30. THE CRACK EXTENDS FROM THE FWD EDGE OF FLANGE TO THE FWD FASTENER HOLE THROUGH ENTIRE MATERIAL THICKNESS.SDR CALA2025111711271Frame · dentedONE DENT REPORTED DURING C CHECK ON THE LT BS 680 FRAME, BETWEEN S23L & S24L. THE DENT MEASURES 0.700 INCH LONG, 0.500 INCH WIDE, AND 0.015 INCH DEEP. INTERIM REPAIR PERFORMED AS PER ECRA 5330-07645 PART1.SDR CALA2025111711270Frame · dentedDURING C-CHECK, REPORTED ONE DENT ON BS 1280 FRAME BOTTOM, BETWEEN S26R AND S27R. THE DENT MEASURES 1.20 INCH LONG, 0.92 INCH WIDE, AND 0.024 INCH DEEP. INTERIM REPAIR PERFORMED AS PER ECRA 5360-02051 PART1.SDR CALA2025111711269Frame · crackedWHILE ACCOMPLISHING INSPECTION PER EA 5311-01827, NOTED CRACK ON THE LT BS 1640 FRAME BETWEEN S14L AND S15L. THE CRACK STARTS AT FREE FLANGE OF THE INBD CHORD AND PROPAGATES INTO THE WEB. PERFORMED INSPECTIONS PER PART 2 OF THE LATEST REVISION OF ECRA 5360-SDR DALA2025111408361Frame · damagedTOOLING DAMAGE AT FR C60 STR P'1. REPAIRED PER ERA 630300-14 REV ORIGINAL. (1295086)SDR AALA202511144818Support Frame · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT WING AILERON #2 HINGE SUPPORT FRAME HAS EXCESSIVE PLAY. REPLACED SUPPORT FRAME PER AMM 57-51-31.SDR AALA202511148531Support Frame · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT WING AILERON #1 HINGE SUPPORT FRAME HAS EXCESSIVE PLAY. REPLACED SUPPORT FRAME PER AMM 57-51-31.SDR AALA202511142844Support Frame · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT WING AILERON #3 HINGE SUPPORT FRAME HAS EXCESSIVE PLAY. REPLACED SUPPORT FRAME PER AMM 57-51-31.SDR AALA202511141034Power Supply · no testAIRCRAFT IN BASE MAINTENANCE: DURING EMERGENCY LIGHT OPERATIONAL CHECK MAINTENANCE FOUND EMERGENCY POWER SUPPLY UNIT 13WL WITH UNIT FAULT LIGHT ON. REPLACED EMERGENCY POWER SUPPLY UNIT 13WL AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR ASAA2025110962227Seat Track · damagedPILOT AFT INBOARD SEAT TRACK FAILED INSPECTION. HAS ELONGATED HOLES. SRXR430X. GROUNDED - YES. REMOVED AND REPLACED AFT I/B SEAT TRACK AT PILOT SEAT. IAW IPECO CMM 53-01-02. B737 AMM 20-50-11-910-801. TW 19-1263 DUE 12-20-2025, B737 AMM 25-11-01-000-801 AND B7SDR ASAA2025110962226Seat Track · damagedCOPILOT AFT INBOARD SEAT TRACK FAILED INSPECTION, HAS ELONGATED HOLES. SRXR430X. GROUNDED - YES. REMOVED AND REPLACED AFT I/B SEAT TRACK AT COPILOT SEAT. IAW IPECO CMM 53-01-02. B737 AMM 20-50-11-910-801. TW 19-1263 DUE 12-20-2025, B737 AMM 25-11-01-000-801 ANSDR SWAA2025111333402Support · corrodedLEFT WING LEADING EDGE; NR 3 SLAT TAI DUCT, OTBD SUPPORT STRUCTURE IS CORRODED. WING STATION OFSS 418. REPLACED TAI SUPPORT ASSY PER SRM 51-10-02.;[02] C/W INSPECTION AS REQUIREDSDR CALA2025111311192Stringer · crackedLEFT WING FUEL TANK AFT, INBD OF RIB 22, AT END OF STRINGER 9U IS CRACKED ON EDGE TO FASTENER. MAJOR REPAIR IAW ECRA 5723-01056. REPAIRED LT WING UPPER STRINGER 9U IAW REO-G25606 REV IR AND EC/RA 5723-01056.SDR CALA2025111311190Stringer · crackedRIGHT WING INTERNAL FUEL TANK, UPPER STRINGER U-9 CRACKED ABOVE RIB NR 18. MAJOR REPAIR IAW ECRA 5723-01057. REPAIRED RT WING UPPER STRINGER 9U IAW REO-G25606 REV.IR AND EC/RA 5723-01057.SDR CALA2025111311188Fuse · failedMOST AFT RT OVERHEAD BIN EMERGENCY LIGHT INOPERATIVE. REMOVED & REPLACED FUSE IAW AMM 33-51-06. OPS CHECK GOOD PER AMM 33-51-00-710-801.SDR CALA2025111311181Toilet · cloggedLAVATORY E OVERFLOWING. CLEARED BLOCKAGE, TOILET OPERATES NORMALL. OPEN AND INSPECTED PANELS IN AFT CARGO PIT. NO WASTEWATER FOUND. AMM REF 38-32-00