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 2025FA0000649Skin · crackedDURING EXTERIOR INSPECTION ON JANUARY 15 2025 AND AGAIN JULY 2, 2025, MULTIPLE CRACKS WERE OBSERVED IN THE WING UPPER SKIN PANELS OF BOTH THE LEFT AND RIGHT WINGS, AS WELL AS IN THE FUSELAGE STRUCTURE ADJACENT TO THE CABIN ENTRY DOOR. LEFT WING UPPER SURFACE:SDR KCSA202509171161Stiffener · crackedAILERON CAVITY I/B STRUCTURE 20 IN. FWD OF HINGE POINT VERTICAL STIFFENER CRACKED AT LOWER EDGESDR AALA202509170086Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L3 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-14.SDR UIEA2025091701238Bulb · inoperativeR4 EXTERIOR EMERGENCY LIGHT BULB INOPERATIVE. REPLACED THE LIGHT BULB IAW AMM 33-51-06. OPS CHK OK</P>)SDR REXA2026052800841Bracket · corrodedINITIAL INSPECTION: CORROSION ON BRACKET OF THE AFT LAV WASTE LEVEL INDICATOR LIGHT (PRESS-TO-TEST INDICATOR). CORROSION ON BRACKET OF THE AFT LAV WASTE LEVEL INDICATOR LIGHT (PRESS-TO-TEST INDICATOR) WAS REMOVED PER CRJ-900 SRM 51-21-06-001-001-A01, EVALUATESDR SWIA2025091675369Floorbeam · corrodedFWD CENTER FLOOR PANEL SUPPORT ANGLE AT FS280.00 HAS SURFACE CORROSION. REMOVED AND REPLACED THE FWD CENTER FLOOR PANEL SUPPORT ANGLE AT BS 280 IAW SRM 51-42-06, SRM 53-11-10 AND SRM 53-11-43 .SDR SWI2025F01858Scroll · corroded6" OF MINOR SURFACE CORROSION NOTED UNDER CARGO DOOR SCUFF PLATE LOWER EDGE AT FS 605.00 (C-CHECK RO 12/19/2025)UPON INVESTIGATION FOUND THE CORROSION TO BE 12.7" L X 1.5" W. BLENDED MINOR SURFACE CORROSION NOTED UNDER CARGO DOOR SCUFF PLATE LOWER EDGE AT FSSDR SWIA202512220916Skin · dented1 DENT LOCATED APRROXIMATELY 6" AFT OF FS 654.50 BETWEEN STRINGERS 22L AND 23L. (C-CHECK RO 12/19/2025)COMPLIED WITH REO 601R-53-61-8393 REV "--" DATED 2025-10-16. REPAIR FOR DENT AND GOUGE DAMAGE TO FUSELAGE SKIN BETWEEN FS654.50 - FS672.20 AND STR21L - STR2SDR AALA202512158494Fitting · migratedAIRCRAFT IN BASE MAINTENANCE: DURING INSPECTION OF 80VU RACK IAW JC26T12053007 FOUND RT LOWER LATER AL FITTING BUSHING MIGRATED AND BURRED MATERIAL ON OUTBOARD FLANGE. MAINTENANCE ACCOMPLISHED INTERIM REPAIR INSTRUCTIONS ON RT LOWER LATERAL FITTING 80VU RACK ISDR AALA202512158930Bushing · migratedAIRCRAFT IN BASE MAINTENANCE: DURING INSPECTION OF 80VU RACK IAW JC26T12053007 FOUND L/H LOWER LATER AL FITTING BUSHING MIGRATED. MEASURE OF DIAMETER AFFECTED HOLE IS:0.475 IN. MAINTENANCE ACCOMPLISHED INTERIM REPAIR INSTRUCTIONS ON LH LOWER LATERAL FITTING 80SDR AALA202512118325Fork · migratedAIRCRAFT IN BASE MAINTENANCE: DURING INSPECTION OF 80VU RACK IAW JC26T12053007 FOUND RT LOWER LATER AL FITTING BUSHING MIGRATED AND BURRED MATERIAL ON OUTBOARD FLANGE.MEASURE OF DIAMETER AFFECTED HOLE IS:0.486 IN. MAINTENANCE \ACCOMPLISHED INTERIM REPAIR INSTRSDR AALA202512110625Fork · migratedAIRCRAFT IN BASE MAINTENANCE: DURING INSPECTION OF 80VU RACK IAW JC26T12053007 FOUND L/H LOWER LATERAL FITTING BUSHING MIGRATED. MAINTENANCE ACCOMPLISHED INTERIM REPAIR INSTRUCTIONS ON RT LOWER LATERAL FITTING 80VU RACK IAW EA 368176, REPAIR DRAWING: R53113174SDR ASAA2025091662033Power Supply · inoperativeFCF INDUCTION FLIGHT DISC 12 - AFTER RIGHT SECTION OF EMERGENCY EXIT LIGHTS INOP ROW 17FED THROUGHJ ROW 29FED. GROUNDED - YES. REMOVED AND REPLACED EMERGENCY BATTERY PACK RIGHT SECTIN AT EXIT LIGHTS ROW 17FED THROUGH 29FED IAW B737-900 AMM 33-51-06-960-805. PESDR SWAA2025103015048Floor Panel · pulledFLOOR PANEL 232SF UPPER SKIN HAS AREAS OF PULLED STRANDS. REPAIRED THE FLOOR PANEL IAW SRM 53-00-50-2R-0-A00938.SDR SWAA2025103015049Floor Panel · pulledFLOOR PANEL 231XF UPPER SKIN HAS AREAS OF PULLED STRANDS. REPAIRED THE FLOOR PANEL IAW SRM 53-00-50-2R-0-A00938.SDR SWAA2025103015050Floor Panel · pulledFLOOR PANEL 231ZF UPPER SKIN HAS AREAS OF PULLED STRANDS. REPAIRED THE FLOOR PANEL IAW SRM 53-00-50-2R-0-A00938.SDR SWAA2025103015052Floor Panel · pulledFLOOR PANEL 241BF UPPER SKIN HAS AREAS OF PULLED STRANDS. FLOOR PANEL 241BF REPLACED WITH A NEW FABRICATED FLOOR PANEL IAW SRM 53-00-50-2R-0.SDR SWAA2025103015054Floor Panel · pulledFLOOR PANEL 242AF UPPER SKIN HAS AREAS OF PULLED STRANDS. REPAIRED THE FLOOR PANEL IAW SRM 53-00-50-2R-0-A00938.SDR SWAA2025103015057Floor Panel · pulledFLOOR PANEL 241DF UPPER SKIN HAS AREAS OF PULLED STRANDS. REPAIRED THE FLOOR PANEL IAW SRM 53-00-50-2R-0-A00938.SDR SWAA2025103015056Floor Panel · pulledFLOOR PANEL 242CF UPPER SKIN HAS AREAS OF PULLED STRANDS. REPAIRED FLOOR PANEL IAW SRM 53-00-50-2R-0-A00938.SDR SWAA2025103015058Floor Panel · pulledFLOOR PANEL 242DF UPPER SKIN HAS AREAS OF PULLED STRANDS. FABRICATED A NEW FLOOR PANEL IAW DWG 144A5810 0123.SDR SWAA2025103015051Floor Panel · pulledFLOOR PANEL 241AF UPPER SKIN HAS AREAS OF PULLED STRANDS. FABRICATION OF NEW 241AF FLOOR PANEL REPLACEMENT HAS BEEN ACCOMPLISHED IAW SRM 53-00-50-2R-0-A00938.SDR SWAA2025103015047Floor Panel · pulledFLOOR PANEL 232RF UPPER SKIN HAS AREAS OF PULLED STRANDS FABRICATION OF NEW FLOOR PANEL REPLACEMENT HAS BEEN ACCOMPLISHED IAW SRM 53-00-50-2R-0-A00938.SDR WX0A2025102732613Seat Track · corroded(AIRCRAFT NOT GROUNDED) (DISCREPANCY NOTED DURING AIRCRAFT HEAVY MX VISIT) NRC 1000-0059: (274-3) PASSENGER CABIN FLOOR STRUCTURE, BTWN FR12-FR18, AT Y1292, CORROSION FOUND ON SEAT TRACK. / PASSENGER CABIN FLOOR STRUCTURE, BTWN FR 12-FR 18, AT Y1292, SEAT TRACSDR CALA2025102610510Receptacle · gougedSUPPORT TASK R1 DOOR HANDLE BOX CUTOUT, UPPER TORQUE TUBE BUSHING STUB BEAM IS GOUGED, REMOVED DAMAGED STUB BEAM AND INSTALLED NEW STUB BEAM REF B737- 800 SRM 51-40-02 AND BAC DWG 141A6525 AND 141A6516.SDR SWAA2025102315280Sill Drain · corrodedCORROSION LOWER SILL LOCATED BETWEEN STA794.3 TO STA847 AND RBL24 WL156 AT AFT CARGO COMPARTMENT. REPLACED LOWER SILL LOCATED BETWEEN STA794.3 TO STA847 AND RBL24 WL156 AT AFT CARGO COMPARTMENT IAW SRM 51-10-02 PARAGRAPH 9; SRM 51-40-02 AND DWG 146A8340; SHEESDR AALA202510230045Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FLOOR BEAM +Y1292 LOCATED FR 16 FWD GALLEY AREA. MEASURES OF CORROSION ARE: L: 0.575 IN, W: 0.235 IN, D: 0.060 IN.SDR SWAA2025102114911Support Bracket · crackedCRACK SUPPORT BRACKET LOCATED BS540 AT LEVEL LBL 6 AT AIR CONDITIONING BAY. REPLACED SUPPORT BRACKET LOCATED BS540 AT LEVEL LBL 6 AT AIR CONDITIONING BAY IAW DWG 212A1101 SHEET 9 REV - SRM 51-40-02; SRM 51-10-02 ITEM 9.SDR SWAA2025102019405Balance Arm · out of balanceDURING WEIGHT AND BALANCE PROCEDURE OF ELEVATOR LT FOUND BALANCE WEIGHTS ON BAY 2, ON BAY 3. ACCOMPLISHED ON MULTI EA M-22-155-03766.SDR DALA2025102007629Apu · failedFIRE/ATB - APU IN OPERATION DURING FLIGHT DUE TO ATA 24 MEL APPLIED FOR EPC 3 DEGRADED FAULT. DURING CLIMB, SHUDDER FELT IN BACK OF A/C WITH APU FAULT FOLLOWED BY FIRE INDICATION. APU FIRE HANDLE PULLED, BOTTLE DISCHARGED. RETURNED TO MCI. CORRECTIVE ACTION: MSDR AALA202510202607Fairing · corrodedAIRCRAFT IN BASE MAINTENANCE: #2 ENGINE AFT STRUT FAIRING TRAILING EDGE ASSEMBLY HAS CORROSION ON INBOARD SIDE. REPLACED TRAILING TRAILING EDGE ASSEMBLY REPLACED PER AARD 51-00-05-1.SDR CALA2025101309981Door Frame · crackedCRACK AT CIRCUNFERENTIAL FRAME FITTING AT L1 DOOR CUT OUT INTERNAL STA 312 AND S8L. TRIMMED OUT DAMAGED AREA AND INSTALLED REPAIR AT CIRCUMFERENTIAL FRAME L1 DOOR CUTOUT AREA, STA.312 AND STR.5L - STR.6L, IAW SRM 53-10-07-2R-1.SDR ASAA2025091661448Frame Splice · corrodedAFT CARGO RH FRAME SPLICE STA 727H HAS CORROSION. GROUNDED - YES. REMOVED AND REPLACED FRAME SPLICE IAW BOEING ENGEREERING DOCUMENT NUMBER: 146A1242 TYPE: DWG ID: 0039 REV:- PN: 146A13A13 00 UB PO: 1133535.1 NO SRM LIMITS.SDR SWIA2025100900016Seat Track · corrodedFORWARD PASSENGER CABIN FLOOR STRUCTURE FORWARD WET AREA , CORROSION AT FR 18 S17L ON THE LEFT SEAT TRACK. PERFORMED CUTOUT AND DOUBLER REPAIR ON THE FORWARD PASSENGER CABIN FLOOR STRUCTURE FORWARD WET AREA LT SEAT TRACK AT FR18 STGR17, IAW SRM 53-10-10,REPAISDR IPXA2025100926914Panel · crackedPANEL 831AZ CRACKED (2 LOCATIONS).CLEANED AND PREPARED PANEL FOR ALLOWABLE REPAIRS. IAW SRM A300-600 51-77-11 PARA 3 A.1.REPAIRED PANEL WITH 08-090, BATCH 4354723. IAW SRM A300-600 51-77-11 PARA 3.A.2-7. REVIEWEDSDR 2025FA0000692Air Box · crackedAIRBOX FAILURE. SEALS MISSING AND CRACKED WELDSDR CALA2025100709731Intercostal · corrodedEXFOILIATED OUT OF LIMITS CORROSION AT INTERCOASTAL BETWEEN STA 947 & STA9 67 RBL-28. REPLACED INTERCOSTAL BETWEEN STA 947.5 & STA 967 RBL-28 (REMOVAL AND INSTALLATION ACCOMPLISHED IN TASK CARD SERIAL #: 99946877) PER REF SRM 51-40-05-0G-0, AMM 51-21-41-370-SDR ASAA2025091661324Floor Panel · damagedFLOOR PANEL 231LF HAS DELAMINATION & SEVERAL AREAS OF CORROSION IN FASTNER HOLES. GROUNDED - YES. EVALUATED FLOOR PANEL 231LF P/N 143A5810-614 AND FOUND DAMAGE TO BE OUT OF LIMITS AND REQUIRES FABRICATION OF NEW FLOOR PANEL IAW ASA B737-900ER SRM 53-30-50-1A-1SDR SWAA2025100614847Seal · debondedRUDDER BLADE SEAL 324AAL DISBONDED. REPLACED RUDDER BLADE SEAL 324AAL ON SHELF IAW AIPC 55-30-00-21 ITEM 30 PG. 6.SDR SWAA2025100614848Seal · debondedRUDDER BLADE SEAL 324ABL DISBONDED. REPLACED RUDDER BLADE SEAL 324ABL ON SHELF IAW AIPC 55-30-00-21 ITEM 25 PG. 6.SDR SWAA2025100614849Seal · debondedRUDDER BLADE SEAL 324RL DISBONDED. REMOVED AND REPLACED ON SHELF REF IPC 55-30-00-31 ITEM 75.SDR SWAA2025100614850Seal · debondedDOT A24-16 RUDDER BLADE SEAL 324ZL DISBONDED. REPLACED RUDDER BLADE SEAL 324ZL ON SHELF IAW AIPC 55-30-00-21 ITEM 35 PG. 7.SDR JJBA20251006012Shear Tie · crackedCF2, AT FR 25 BTW STR 16R-17R SHEAR CLIP FOUND CRACKED. CF2, AT FR 25 BTW STR 16R-17R SHEAR CLIP REMOVED AND REPLACEDSDR CALA2025100609634Floorbeam · crackedFOUND CRACK LOWER FUS CTR REAR SPAR R/H VAPOR BARRIER UPPER ATTACHED ANGLE RBL 7 STA 663.75. ACCOMPLISHED STA-663.75 RT VAPOR BARRIER ATTACH ANGLE SPLICE REPAIR FROM RBL-5 TO RBL-30 AS PER SRM 57-10-10-2R-5 .SDR CALA2025100609633Window Frame · crackedCONTACT ENGINEERING FOR REPAIR INSTRUCTIONS. LEFT WINDSHIELD FWD NODE, MOST INBD HOLE FROM CENTER LINE HAS A CRACK INDICATION AT THE 6:O CLOCK POSITION 100% SH. PERFORM REPEAT INSPECTION AT INTERVALS NOT TO EXCEED 5,600 FLIGHT CYCLES CURRENT HOURS 74772:19 FLSDR CALA2025100609632Floorbeam · dentedFLIGHT DECK FLOOR HAS DENT AT STA 246 LBL 14. INSTALLED REPAIR ON FLIGHT DECK FLOOR WEB STA 246 LBL10 TO RBL 8, REF. SRM 51-40-02-0G-0 AND SRM 53-10-51-2R-2.SDR AALA202510064804Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CABIN FLOOR BEAM BETWEEN FR 12 AND FR 20 AT +Y1292. REPLACED FLOOR BEAM PER SRM 51-42-11.SDR SWAA2025100315311Angle · corrodedCORROSION ANGLE BTW STA767 AND STA787 RBL22 AT AFT CARGO COMPARTMENT . REPLACED ANGLE LOC. BTW STA767 AND STA787 RBL 22 AT AFT CARGO COMPARTMENT IAW SRM 51-10-02 ITEM 9, SRM 51-40-02 ; DWG# 146A0081 SHEET 37; REV-; DWG# 146A8123 SHEET 16; REV-.SDR R61A2025100300427Waste Box · corrodedEVIDENCE OF CORROSION ON WASTE SERICING PANEL CUT OUT INTERNAL SIDE. REMOVED AND REPLACED WASTE BOX DOUBLER. REF: EMB SRM 51-40-08SDR ASAA2025091661225Floorboard · damagedFLOORBOARD PANEL 241FK HAS DELAMINATION & SEVERAL AREAS OF CORROSION IN FASTNER HOLES. GROUNDED - YES. EVALUATED FLOORBOARD PANEL 241FK DAMAGE AREAS, DAMAGE FOUND TO BE OUT OF REPAIRABLE LIMITS, FABRICATED NEW PANEL IAW B737-900ER SRM 53-00-50-1A-1, 53-00-50-2