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 UIEA2025090301152Slide · low pressureR1 DOOR ESCAPE SLIDE PRESSURE LOW. REPLACED ESCAPE SLIDE PER AMM 25-66-01. NO FURTHER DEFECTS NOTED.SDR ASAA2025090360561Lens · detachedEXIT PLACARD NEAR L2 DOOR FALL OFF. GROUNDED - YES. REPLACED EXIT LENS COVER, REF. 33-51-01.SDR N6WA2025090409Support Angle · corrodedCORROSION ON SUPPORT STRUCTURE ANGLE AT BS 939. REMOVED AND REPLACED SUPPORT ANGLE AT BS 939 IAW SRM 51-42-06.SDR N6WA2025090408Skin · corrodedCORROSION ON TOP SKIN AT VHF3 ANTENNA MOUNTS INSIDE CABIN. REMOVED AND REPLACED INTERNAL DOUBLER IAW SRM 51-42-06SDR N6WA2025090407Beam · corrodedCORROSION LBL 9 ON BEAM BETWEEN BS 477 - 677. REWORKED AND RESTORED FINISH IAW REO-670-53-31-1076SDR N6WA2025090406Beam · corrodedCORROSION RBL 9 ON BEAM BETWEEN BS 533 - 477. REWORKED AND RESTORED FINISH IAW REO670-53-31-1076.SDR N6WA2025090405Repair · corrodedCORROSION ON REPAIR DOUBLER AT BS 969 - 985, STRINGERS 26R - 26L. REMOVED AND REPLACED DOUBLER IAW EO-25-CRJ5-53-212.SDR N6WA2025090404Seat Track · corrodedCORROSION ON EXTRUSION REINFORCEMENT SEAT TRACK MOUNTING BETWEEN BS 784 - 797 RT SIDE. PREFORMED REFURBISHMENT AND RESTORED FINISH ON EXTRUSION REINFORCEMENT SEAT TRACK MOUNTING IAW REO-670-53-91-752.SDR N6WA2025090403Skin · corrodedCORROSION AND GOUGES ON LOWER SKIN PANEL UNDER ADF ANTENNA BETWEEN FS485.00-FS517.00 AT STRINGERS 26R-26L. PERFORMED BLEND OUT AND RESTORED FINISH TO LOWER SKIN PANEL UNDER ADF ANTENNA IAW EO-79-2025-196.SDR N6WA2025090402Support · mechanic errorMISDRILLED HOLE AT FWD CARGO DOOR SUPPORT STRUCTURE THRU LOWER LONGERON JOINT PLATE AND EXTERNAL CLOSING. PERFORMED A REPAIR ON THE SUPPORT STRUCTURE IAW EO-C550-53MR-086.SDR N6WA2025090401Doubler · gougedTWO GOUGES ON AN EXISTING REPAIR DOUBLER BETWEEN BS 977 - 985, S27. REMOVED AND REPLACED DOUBLER IAW REO-670-53-61-1149.SDR IPXA2025090482863Window · damagedL2 WINDOW HEAVILY SCRATCHED AND IMPAIRS VIEW DURING TAXI IN WITH BRIGHT LIGHTS. REMOVED AND REPLACED L2 WINDOW IN REF TO AMM 56-11-02/401. LEAK CHECK GOOD. REF MM 05-51-24-201.SDR UIEA2025090401160Fmc · faultedONE HOUR, THREE MINUTES INTO FLIGHT, BOTH ND'S HAVE YELLOW MAP FAULT DISPLAYED. NO ROUTE OR MAGENTA LINE SHOWN, EIU SOURCE SEL AND CTR C/B CYCLED. REPLACED LT FMC PER AMM 34-61-01, TESTED GOOD IAW AMM 34-61-00 & IPC 34-61-01.SDR DALA2025090406557Shear Tie · damagedTOOLING DAMAGE FOUND AT SKIN CLIP ON FORWARD SIDE OF F60 @ P1 RIGHT. REPAIRED PER ERA 627429-14 REV. ORIG. (1179482)SDR AALA202509049777Trim System · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: FIRST WE GOT STAB OUT OF TRIM. AFTER GOING THROUGH THE CHECKLIST AND DISCONNECTING THE AUTOPILOT AND AUTOTHROTTLES, WE HAD NO ELECTRIC TRIM. THAN WE RECEIVED A STAB TRIM FAIL. AIRCRAFT EMERGENCY LANDED SSDR AALA202509044354Sign · missingAIRCRAFT WAS NOT GROUNDED: FORWARD FACING EXIT SIGN ABOVE AISLE AND ADJACENT TO OVERWING EXITS IS MISSING. REINSTALLED EXIT SIGN COVER. PER 33-51-01.SDR AALA202509042245Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT AT AFT FLIGHT ATTENDANT JUMP SEAT IS INOPERABLE. (OPEN).SDR AALA202509043582Light · burned outAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT AFT OF RIGHT WING BURNED OUT. REPLACED LIGHT AND OPERATIONAL CHECK GOOD. PER AMM 33-35-00.SDR AALA202509045316Flap System · splitAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: WHILE CONFIGURING FLAPS DURING APPROACH FLAPS ASYMMETRY (SPLIT) OCCURRED. AIRCRAFT EMERGENCY LANDED SAFELY AT GUA. (OPEN).SDR DALA2025090406554Keelbeam · damaged(LOG 1179813) DURING HCK AT QRO, WHILE PERFORMING A ZONAL INSPECTION OF THE KEEL BEAM FROM STA 540 TO STA 727 PER WC 5300-2539, CORROSION WAS FOUND AFFECTING THE DOUBLER INSTALLED BETWEEN STA 500H TO 540 & S-26L TO S-26R, SUBSEQUENTLY AN INTERNAL INSPECTION WASDR DALA2025090406553Skin · damaged(LOG 1180508) DURING HCK AT QRO, WHILE PERFORMING APU AREA (APU REMOVED) INSPECTIONS PER WC 4900-2365, THREE PUNCTURES (LIGHNING STRIKES) WERE FOUND ON FUSELAGE AT LOWER HORIZONTAL BEAM WEB BETWEEN STA 1104 AND 1121 & BETWEEN RBL 20.60 AND RBL 30.60, AND AN ADSDR DALA2025090406549Frame · damaged(LOG 1180234) ACCOMPLISH AMDS 5311-01251-02A LEFT HAND STA 727 FRAME INNER CHORD,737 REPAIR; RII; SECTION 02. SHIM WAS INSTALLED BTW THE LEFT SIDE OF STA 727 INNER CHORD AND S-18A WEB PER AMDS 5311-01251-02A (AD 2023-06-15) (BOEING SERVICE BULLETIN 737-53A1402SDR DALA2025090406548Frame · damaged(LOG 1180224) ACCOMPLISH AMDS 5311-01251-02B RIGHT HAND STA 727 FRAME INNER CHORD,737 REPAIR; RII; SECTION 02. SHIM WAS INSTALLED BTW THE RIGHT SIDE OF STA 727 INNER CHORD AND S-18A WEB PER AMDS 5311-01251-02B (AD 2023-06-15) (BOEING SERVICE BULLETIN 737-53A14SDR DALA2025090406547Torsion Box · dented(LOG 1180091) HORIZONTAL STAB TORSION BOX COMPARTMENT, STA 1088 - 1096 LOWER HORIZONTAL BEAM WEB HAS 3 EA DENTS AND 1 IN CRACK AT BL0. REPAIRED HORIZONTAL STAB TORSION BOX LWR BEAM DENTS/CRACK LOCATED AT STA 1088 - 1096 BL0 IAW B737-900 SRM 53-80-13-1A-1, 51-7SDR DALA2025090406546Floor Support · corroded(LOG 1179824) CORROSION ON FLOOR SUPPORTS STA 727D+5,727I+5. BTW STRG 25L TO 25R AND STA 767+5 RBL 3.00 AT AFT CARGO COMPARMENT. FLOOR SUPPORTS STA 727D+5,727I+5. BTW STRG 25L TO 25R AND STA 767+5 RBL 3.00 AT AFT CARGO COMPARMENT WAS REPAIRED PER B737-800 SRM SDR DALA2025090406543A/C Pack · failedDIV/PRES/DE- TO YUL DUE TO LOSS OF BOTH PACKS WITH CABIN ALTITUDE WARNING AND O2 MASKS DEPLOYED. SECURED RT PACK V-BAND CLAMP TO SEC HEAT EXCHANGER, RESECURED COUPLING AT PACK PRIM HEAT EXCHANGER, R/R HOSES AND CLAMPS FROM ACM TO CONDENSER.SDR DALA2025090406540Shear Tie · corrodedSHIP 3157 CORROSION SHEAR TIE AT LEVEL OF FR 65 AND BTW STR 44 TO STR 43L IN AF T CARGO COMPARTMENT. CORRECTIVE ACTION: REPLACED SHEAR TIE AT LEVEL OF FR 65 AND BTW STR 44 TO STR 43L IN AFT CARGO COMPARTMENT, AS PER A319 SRM 51-42-11 AND A319 SRM 51- 72-11. (1SDR HALA20250904272Fuel Filter · cloggedETOPS - ENG 1 FUEL FILTER CLOG MESSAGE DISPLAYED IN CRUISE. REPLACED ENG 1 LP FUEL FILTER PER AMM 73-11-41. NO FINDINGS, FILTER CLEAN. OK FOR SVC.SDR 3J7R2025090400001Light · inoperativeTHE DROPPED-AISLE EMERGENCY LIGHTS BETWEEN SEAT 8 AND SEAT 6 ARE INOPERATIVE.SDR DXTA2025090404810Fce · faultedFLAP FAILED BETWEEN 1 AND 2. REVIEWED PREVIOUS STEPS AND PROCEEDED WITH THE FOLLOWING: SWAPPED FCE 1 & 2. PERFORMED RIGGING OF FLAP SYSTEM FOR FCE 1 AND PERFORMED OPS CHECKS OF FLAP SYSTEM S TIMES IAW AMM. WORK DONE IAW EMB-505 AMM 27-50-00. PERFORMED RIGGINSDR DXTA2025090404815Lever · faultedFLAP FAIL, CAS MESSAGE ILLUMINATED ATTEMPTED RESET PROCEDURE PER THE CHECKLIST UNSUCCESSFULLY. LANDED ZERO FLAPS UNEVENTFULLY. COULD NOT DUPLICATE FLAPS FAIL CAS MESSAGE. PER CONTACT CENTER PREFORMED A GVI OF FLAPS.FLAP ROLLERS, FLAP TRACKS AND FLAP WELLS SDR SIMA20250903002Seat Track · corrodedLH SEAT TRACK HAS CORROSION BETWEEN FR 19 AND FR 20 @ Y=-12" (MAJOR REPAIR) BLENDED CORROSION ON LH SEAT TRACK BETWEEN FR 19 AND FR 20 @ Y=-12" PER EMB 175 SRM 51-10-03. UPON EVALUATION FOUND AREA TO MEASURE L=1.3" X W=1.1" H=.- 071" ORIGINAL MATERIAL THICKNESDR SIMA20250903001Skin · damagedFWD FUSELAGE LOWER EXTERNAL SKIN AT FR8 BETWEEN STR18L AND STR20L HAS LIGHTNING STRIKE DAMAGE. (MAJOR REPAIR). STRIPPED AREA ON FUSELAGE SKIN AT STRG 20L FR 8 REF EMB 175 SRM 51-23-02. DAMAGE AT FR 8 BETWEEN STR 18L AND 20L L = .650" W = .416" H = .023" ORIGINSDR YENA2025090400909Skin · corrodedDURING HEAVY MAINTENANCE: CORROSION ON TOP SKIN, TRAILING EDGE OVERHANG, LOWER SURFACE, BTW WX4013 AND WX4349 ( BTW RIB 8 7 RIB 9 ), ON RH WING; REFERENCE AEROMAN W.O. 2025 279 / 1- N.R. 481112 * PERFORMED PERMANENT REPAIR ON TOP SKIN PANEL #2, TRAILING EDGE OSDR YENA2025090400908Skin · corrodedDURING HEAVY MAINTENANCE: CORROSION ON TOP SKIN, TRAILING EDGE OVERHANG, LOWER SURFACE, BTW WX40 13 & WX4349 ( BTW RIB 8 AND 9) ON LT WING; REFERENCE SAL WO 2025 279/1 NR 2025-481126. EVALUATED BLENDED AREA LOCATED ON TOP SKIN, T/E OVERHANG, LOWER SURFACE, BTWSDR FDEA202509031614Floor Panel · dentedMAIN DECK CARGO COMPARTMENT, FLOOR PANEL 231NFF IS DENTED. JM31 FABRICATED MAIN DECK FLOOR PANEL# 231NFF MPN # 143T5876-119 LBL 33- LBL 54.75 STA 654-700 IN REF TO BOEING DWG 141T5876-119. SEE JPF FOR ALL WORK STEPS ACOMPLISHED. INSTALLATION OF FLOORPANELSDR FDEA202509031613Floorboard · dentedMAIN DECK CARGO COMPARTMENT, FLOOR PANEL 251LFF HAS PUNCTURE DAMAGE. FABRICATED NEW FLOOR PANEL (PNL 251LFF MPN: 143T5876-51) AT STA 1208 TO STA 1350 BETWEEN RBL 11 AND LBL 11 IN REF TO BOEING DWG# 143T5876-51. THIS IS A MAJOR REPAIR. SEE JPF WORK STEPS ACSDR FDEA202509031612Door · openDURING POST FLIGHT INSPECTION FOUND CREW REST UPPER PSU DOOR OPEN. COULD NOT REST PSU DOOR. REPAIRED DOOR ASSY. OPS CHK GOOD. OK FOR SERVICE.SDR FDEA202509031615Switch · failedEMERGENCY TEST LIGHT SWITH INOP REMOVED AND REPLACED EMERGENCY LIGHT SWITCH IAW SWPM 20-84-18, OPS CHECK IAW B757 AMM 33-51-00-5 TEST GOOD.SDR CALA2025090408467Lavatory · odorFWD LAV RANCID SMELL POSSIBLY FROM DRAINS. FLUSHED TOILET AND SINK DRAINS WITH SANI/CLEANER FLUIDS. NO LEAKS OR SPILLAGE AROUND DRAINS/FLOOR. OK TO CONTINUE SERVICE.SDR CALA2025090408463Lens · out of positionEMERGENCY EXIT ROW LIGHTS OUT OF CORRECT SEQUENCE. REPOSITIONED EMERGENCY LIGHT LENS AT ROW 21 ABC TO CORRECT CONFIG. REF. AMM 33-51-11. EMERGENCY LIGHTS TEST NORMAL.SDR CALA2025090408462Light · malfunctionedEMERGENCY EXIT LIGHTSARE ILLUMINATED WITH EMER EXIT LT SWITCH IN OFF AND ARMED POSITION WITH CREW ASSISTANCE CYCLED BREAKERS H06, H05 AND V07. CYCLED NO SMOKING AND EMER SWITCHES, LIGHTS OPS NORMAL. AMM33-51-00.SDR CALA2025090408460Bottle · no discrepancyCHECK DOOR 2R SLIDE PERESSURE GAUGE FOR LOW PRESSURE. NEEDLE IS ON LIMIT LINE. INVALID ENTRY, PRESSURE CHECKED SERVICEABLE AS NEEDLE REMAINS IN TOP OF GREEN BANDSDR CALA2025090408459Slide · no discrepancyINSTALLED 1EA SAFETY PINS AT DOOR L1 IN EACH DOOR ASSIT BOTTLE AND DOOR SLIDE ASSY. FOR REPLACEMENT OF SLIDE ASSY REMOVED AND STOWED 1EA SAFETY PINS AT DOOR L1 IN EACH DOOR ASSIT BOTTLE AND DOOR SLIDE AFTER COMPLETION OF DOOR SLIDE REPLACEMENT. REF AMM TASK 25SDR SCNA20250904357Lamp · inoperativeNO SMOKING/FASTENED SEATBELT LIGHTS INOP AT SEATS 2ABC,8ABC,12ABC,16ABC,23ABC,23DEF, AND 27DEF. RELAMPED NO SMOKING/FASTEN SEAT BELT LIGHT REF. MM 33-25-00. OPS CHECKS GOOD. OK FOR SERVICE.SDR SCNA20250904356Light · inoperativeEMERGENCY LIGHTS AT OVERHEAD BINS 15 AND 20 RH, LAV D, GALLEY 4 AND (3 EAS) INTERNAL AT EXIT OVERWINGS DON'T TURN ONSDR SCNA20250904355Bulb · inoperativeINOPERATIVE BULB ON THE EMER EXIT LIGHT NOT ARMED LIGHT. RELAMPED OPS CHECK GOOD IAW AMM 33-11-00SDR EE4Y2025090323032Seat Track · wornREPAIRED SEAT TRACK SECTION AT MAIN CARGO CABIN LBL 45.5 BETWEEN STA 689 AND STA 703.5 DUE TO WEAR I/A/W B737-800 SRM 53-00-52 REPAIR 3 PARAGRAPH 4 FIGURE 202 DETAIL A. CATEGORY A REPAIR. REV 85 DATED 07-10-2025. UNDER JOB A1Q187 NRI 2-45SDR EE4Y2025090323031Seat Track · wornDURING THE ACCOMPLISHMENT OF 737-AE-53-837_P1-OP-UP NAC TASK CARD, THERE WERE FOUND TWOSEAT TRACK CROWN AREAS DAMAGED, ONE CRACKED AT STA 520 LBL 24.75, AND THE OTHER ONE WITHWEAR AT STA 520 LBL 45.50. SINCE THE MENTIONED SEAT TRACK AREAS ARE AFFECTED BY AEI CSDR EE4Y2025090323030Seat Track · crackedDURING THE ACCOMPLISHMENT OF 737-AE-53-837_P1-OP-UP NAC TASK CARD, THERE WERE FOUND TWO SEAT TRACK CROWN AREAS DAMAGED, ONE CRACKED AT STA 520 LBL 24.75, AND THE OTHER ONE WITH WEAR AT STA 520 LBL 45.50. SINCE THE MENTIONED SEAT TRACK AREAS ARE AFFECTED BY AEI