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 SWAA2025081494243Stub Frame · crackedFSD LOWER STUB FRAME IS CRACKED AT BS294.5 WL208. REPAIRED FSD LOWER STUB FRAME IAW SRM 53-10-15-2R-7 REPAIR-7 AND DWG 141A8310 REV-B.SDR SWAA2025081494254Stringer Clip · corrodedCORROSION ON STRINGER CLIP ACB STA-787 RBL-5'' FLOOR AREA. REMOVED AND REPLACED STRINGER CLIP ACB BS787 RBL5 IAW SRM 51-40-02-0G-0 AND DWG 146A8130 REV: C.SDR SWAA2025081494256Stringer Clip · corrodedCORROSION ON STRINGER CLIP ACB STA-807 RBL-13'' FLOOR AREA. REMOVED AND REPLACED STRINGER CLIP ACB STA 807 RBL 13 IAW SRM 51-40-02-0G-0; IAW SRM 51-40-05 AND DWG 146A1263 REV:C.SDR SWAA2025081494260Web · corrodedCORROSION ON SUB THRESHOLD WEB ACB BS 787 TO 847 RBL-33. REMOVED AND REPLACED ACB SUBTHRESHOLD WEB IAW SRM 51-40-02 AND DWG 146A8340 ID:0012 REV: C.SDR SWAA2025081494266Web · corrodedMULTIPLE SPOTS WITH CORROSION ON FCB DOOR CUTOUT SURROUND THRESHOLD BS440+14; BS460;460+9 RBL30;WL156. REMOVED AND REPLACED SUBTHRESHOLD WEB AT FCB; BETWEEN BS 440 TO BS 492 RBL 30 WL 156 IAW SRM 51-40-02 AND DWG 143A8330 REV -.SDR IPXA2025072256161Pump · inoperativeDURING CRUISE, RECEIVED CTR R FUEL PUMP (EICAS C). RAN CHECKLIST AND OPERATED REMAINDER OF FLIGHT WITH CTR R FUEL PUMP INOP. I.A.W. AMM 28-22-05-004-057-002 REV.145 AND AMM 28-22-05-404-078-002 REV.145 REPLACE THE CTR R FUEL PUMP. I.A.W. AMM 28-22-00-715-001 SDR IPXA2025080560795Skin · corrodedNUMBER 2 PYLON INBD SIDE, FWD INNER SKIN HAS CORROSION AROUND CUTOUT OF PANEL 443GL. INSTALLED PYLON #2 I/B FWD FAIRING IAW B757-200PF SRM 51-40-02-0G-0.SDR IPXA2025080265076Tee Angle · corrodedTEE CHORD BS 900 RBL 0 HAVE CORROSION. INSTALLED TEE CHORD AND 8 PLATES, IAW SRM 51-70-12-0G-0, SRM 51-40-02.SDR IPXA2025080366377Skin · dentedEXTERNAL FUSELAGE SKIN BETWEEN STA 560 TO 580 AND S-27R TO S-28R HAS A DENT. ACCOMPLISH REPAIR PER EO-94639-REQ1 AND VT-MAE EA 757-5330-27-A4080, REV-.SDR IPXA2025080361106Skin · corrodedNR 2 PYLON INBD SIDE, AFT INNER SKIN HAS CORROSION BETWEEN PANELS 443HL AND 443JL AT LOWER AREA. ACCOMPLISH REPAIR PER EO-94655-REQ1 AND VT-MAE EA 757-5450-27-A4075, REV-.SDR AALA202508080725Door · misalignedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND FORWARD OVERWING EXIT DOOR, UPPER FORWARD STOP PAD MISALIGNED. MAINTENANCE ADJUSTED UPPER FORWARD STOP PAD ON LEFT HAND FORWARD OVERWING EXIT DOOR PER AMM 52-22-00SDR AALA202508089258Door · misalignedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND FORWARD OVERWING EXIT DOOR, UPPER AFT STOP PAD MISALIGNED MAINTENANCE ADJUSTED UPPER AFT STOP PAD ON LEFT HAND FORWARD OVERWING EXIT DOOR PER AMM 52-22-00.SDR AALA202508089510Door · misalignedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND AFT OVERWING EXIT DOOR, UPPER AFT STOP PAD MISALIGNED. MAINTENANCE ADJUSTED UPPER AFT STOP PAD ON LEFT HAND AFT OVERWING EXIT DOOR PER AMM 52-22-00.SDR IPXA2025080706343Support Bracket · corrodedBETWEEN T-CHORD 860 AND LOWER SKIN OF FUSELAGE, LOWER SUPPORT BRACKET HAS CORROSION.REMOVED CORROSION T-CHORD 860 RBL 0 IAW B757-200PF SRM 51-10-02.TREATED AND PRIMED AREA IAW B757-200PF SRM 51-20-01.APPLIED TOP COAT AT AREA IAW B757-200PF AMM 51-21-15-370-801SDR IPXA2025080766917Support Angle · corrodedEVIDENCE CORROSION PANEL 192 DR UPPER SUPPORT R/H SIDE. CLEANED AREA AT PANEL 192 DR UPPER SUPPORT R/H SIDE IAW SOPM 20-30-03.TREATED AND PRIMED AREA IAW SRM 51-20-01.APPLIED TOP COAT AT AREA IAW AMM 51-21-15-370-801.SDR SWAA2025080694026Nut · brokenL2 DOOR LINER ASSIST HANDLE NUT BROKEN<[01] REMOVED AND REPLACED ASSIST HANDLE NUT AND SECURED ASSIST HANDLE IAW B737NG AMM 52-13-31-400-802 SUBTASK 52-13-31-020-008 PO:1128177.1;[02] VERIFIED REMOVED AND REPLACED ASSIST HANDLE NUT AND SECURED ASSIST HANDLE IASDR SWAA2025080694330Handle · looseL2 DOOR BOTH ASSIST HANDLES LOOSE. SECURED BOTH L2 DOOR ASSIST HANDLES IAW B737NG AMM 52-13-31-400-802 SUBTASK 52-13-31-020-008.SDR IPXA2025072968409Floor Panel · damagedFAULT-INT-Z200- MDC FLOOR PANEL 252DN WITH COMPOSITE MATERIAL EXPOSURE AT UPPER FACE. DOT 21-15.MCD FLOOR PANEL REPAIRED IAW A300-600 SREO-42721-REQ001SDR ASAA2025072259891Angle · corrodedAFT CARGO R/H TRANSITION CORRODED BETWEEN STA 727D TO STA 847. GROUNDED - YES. REMOVED CORROSION FOUND TO BE OUT OF LIMITS, REPAIRED TRANSITION IAW BOEING 737-800 SRM 53-00-53-2R-6W 1" O .040 R .000 L 2" D .040.SDR REXA2025080600789Skin · cracked"SECONDARY NRC IN REF. TO NRC 00013 : AFTER PAINT STRIPPING ON LOWER SKIN AT LH INBOARD FLAP, CRACK WAS FOUND ON LOWER SKIN BTW FS30.00 / FS36.00 FROM 0.750Ï¿½ TO TRAILING EDGE. LOWER SKIN AT LH INBOARD FLAP BTW FLS 30.00 / FLS 36.00 0.750"" ABOVE OF TRAILING SDR ASAA2025072259863Transition Panel · corrodedFORWARD CARGO COMPARTEMENT R/H SIDE TRANSITION PANEL HAS NUMEROUS AREAS OF CORROSION BETWEEN STA 500C & 500I. GROUNDED - YES. REMOVED CORR. FROM FWD CARGO COMP. RT TRANSITION PANEL AT BS 500C TO 500I ORIG. THICKNESS .040 IAW SRM 53-30-53. MAT. LOSSED .008, RSDR AALA202508051670Slide · abnormalAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND AFT PASSENGER / CREW DOOR SLIDE PULL HANDLE DETACHED FROM SLIDE. REPLACED SLIDE PER TASK CARD 26C84252006.SDR AALA202508051485Hinge 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 AALA202508055483Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #2 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202508050198Hinge 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 ASAA2025072259805Transition Panel · corrodedAFT CARGO L/H TRANSITION CORRODED BETWEEN STA 727D TO STA 887. GROUNDED - YES. REMOVED CORROSION FOUND TO BE OUT OF LIMITS, REPAIRED TRANSITION IAW BOEING 737-800 SRM 53-00-53-2R-6W 2" O .040 R .000 L 1" D .040.SDR SIMA2025080422003Control Rod · gougedR/H DV WINDOW CONTROL ROD IS CHAFED ON LOWER SECTION. (MAJOR REPAIR) REMOVED DAMAGE ON R/H DV WINDOW LOWER CONTROL ROD AFTER BLENDING CONTROL MEASURES .688" OUT OF LIMITS REF EMB 175 AMM 56-12-00 PART REQUIRES REPLACEMENT. REMOVED AND REPLACED R/H DV LOWER WINSDR AALA202508046886Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #5 HINGE ARM END HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR CALA2025080107211Plate · damagedFRAME 68, S10 - 16. INNER CAP GUSSET PLATE JOINT, ALL FASTENER HOLES HAVE REJECTABLE INDICATIONS. ACP INITIAL INSPECTION OF THE GUSSET HOLES IAW PART 2 OF THE LATEST REV OF ECRA 5341-01508. ACCOMPLISHED REPAIR IAW RCO-L25500.SDR CALA2025080107210Frame · corrodedLEFT FR 66, S10 - 16L INNER CAP GUSSET PLATE JOINT, ALL FASTENER ATTACH HOLES HAVE INDICATIONS. INTERIM REPAIR FOR FR 66 HAS BEEN ACCOMPLISHED IAW PART 1 OF ECRA 5341-01508 WITHOUT DEVIATIONS. ACCOMPLISHED REPAIR IAW REO-L25500REV1R WITH NO DEVIATIONS.SDR AALA202507313519Flashlight · dischargedAIRCRAFT IN BASE MAINTENANCE: FLIGHT ATTANDENT FLASHLIGHT OUTBOARD NEXT TO L1 DOOR TEST LIGHT WILL NOT COME ON. INSTALLED FLASHLIGHT CORRECTLY IN TO CHARGE BASE. PER AMM 26-64-00. OPERATIONAL CHECK GOOD.SDR ASAA2025072259736Skin · crackedRIGHT HORZONTAL STAB LOWER SKIN CRACKED AT RIB 8 HSS 147.9 2EA LOCATIONS 17IN AND 9IN FROM T/E. GROUNDED - YES. REPAIRED R/H HORIZONTAL STAB LOWER SKIN AT RIB 8 HSS 147 IAW B737-800 SRM 55-10-01-2R-11 THIS IS A CAT B REPAIR WITH A THRESHOLD INSPECTION AT 56,00SDR SWIA202507300022A/C Pack · faultedWHILE ENROUTE FROM LNK TO DEN AT FLIGHT LEVEL 240,RECEIVED A LEFT PACK OVERPRESS CAUTION MESSAGE AND AIRCRAFT STARTED TO DEPRESSURIZE. PERFORMED EMERGENCY DECENT AND DIVERTED TO EAR. CABIN ALT WARNING AND CAUTION ILLUMINATED. MEL 21-51-1CCAT C . (FLIGHT 4648SDR JJBA20250730113Frame · crackedFR 59 LH FOUND CRACKED BTW STR 15L-16L. FR59 LH SPLICE REMOVED BTW STR15L-16L FOR REPAIR ACCESS. FR 59 LH BTW STR 15-16 REPAIREDSDR DALA2025072905696Pan · scratchedWASTE WATER SERVICE PAN HAS SCRATCHES. REMOVED AND REPLACED WASTE WATER SERVICE PAN IAW A220 ASRP BD500 -J51-42-21-00AAA-078A-A AND BOMBARDIER DWG# C01342100 REV. -W. (LP# 1099809)SDR DALA2025072905695Skin · corrodedCORROSION ON FWD CARGO COMPARTMENT DOOR SKIN BOTTOM AT HOLES 12OL, 13OL, 14OL,15OL,16OL,17OL,18OL, AND 20OL. COMPLIED WITH ER/A 627804-14 REV. ORIGINAL ASSOCIATED ER/A 14-627804 ADDED FOR AC 8118. CORROSION LEVEL CHANGED FROM: 1 TO: 2. (LP# 1099798)SDR DALA2025072905694Door Sill · corrodedCORROSION ON FWD CARGO COMPARTMENT DOOR LWR SILL FASTENER HOLES, BETWEEN FR-24 AND FR-29. COMPLIED WITH ER/A 627804-14 REV. ORIGINAL. (LP# 1099778)SDR SWAA2025072894222Fairing · damagedSTRUT FAIRING ON NR 2 ENGINE AT 3 O`CLOCK POSITION HAS ELONGATED HOLE. PARTIALLY INSTALLED STRUT FAIRING PANEL IAW AMM 73-21-06, FINISHED INSTALLING REMAINING 2 SCREWS COMMON TO STRUT FAIRING REF AMM 73-21-06.SDR SWAA2025072893676Acoustic Liner · delaminatedNUMBER 2 ENGINE, RT ACOUSTICAL PANEL IN 4TH POSITION DELAMINATED. REMOVED AND REPLACED PER AMM 72-23-02-401-NG AFT ACOUSTICAL PANELS.SDR SWAA2025072893950Sensor · faultyTWO POPS HEARD ON NR 1 ENGINE AT 41K FT .79 MACH TAT -32C N1 ROLLED BACK APPROX 5%. . AUTOTHROTTLES DID NOT DISCONNECT AND ENGINE STABILIZED. ALL ENGINE PARAMETERS NORMAL FOR REMAINDER OF FLIGHT. COMPLIED WITH FIM TASK 71-05-805. FOUND FAULT CODE 75-30801 TSDR JJBA20250728101Skin · dentedDENT ON LH FWD FUSE I SKIN, BTW FR 6-7 AND ABOVE STR 15L, UNDER GPU ACCESS DOOR. ON LH FWD FUSE I SKIN, BTW FR 6-7 AND ABOVE STR 15L UNDER GPU ACCESS DOOR REPAIR PERFORMED.SDR JJBA20250728098Angle · crackedAT FR 59 LH ANGLE BTW FR 59 AND OMEGA BEAM FOUND CRACKED. AT FR59 LH ANGLE BTW FR 59 AND OMEGA BEAM REMOVED. AT FR59 LH ANGLE BTW FR 59 AND OMEGA BEAM REPLACEDSDR JJBA20250728095Shear Tie · crackedSHEAR CLIP AT FR 59 AND BTW STR 15L-16L FOUND CRACKED. SHEAR CLIP AT FR 59 BTW STR 15L-16L REMOVED AND REPLACEDSDR AALA202507283876Bolt · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LOWER BOLT AT SLAT TRACK 7 RH WING MEASURE ARE L= 0.344 IN, W= 0.123 IN, D= 0.002 IN. MAINTENANCE REPLACED BOLT AT SLAT TRACK 7 RH WING IAW AMM 27-84-65-400-002-A AND JOB CARD 26C61057005 STEP 6.A(3) .SDR AALA202507251307Door · inoperativeAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR INOPERATIVE, HARD TO OPEN. REMOVED AND REPLACED LAVATORY-D FOLDING DOOR. PER CMM 25-40-64. OPERATIONAL CHECKS GOOD.SDR IPXA2025072555740Floor Panel · crackedFOUND BULK CARGO FLOOR PANEL DAMAGE , STA 1518 LBL 24. (REPAIR) 1.ACCOMPLISHED REPAIR I.A.W SREO-34806-REQ002 REV.1.SDR IPXA2025072555713Floor Panel · crackedFOUND BULK CARGO FLOOR PANEL DAMAGE , STA 1480 , LBL 5. (REPAIR) 1.ACCOMPLISHED REPAIR I.A.W SREO-34806-REQ002 REV.1.SDR DALA2025072505609Structure · damagedSHIP 3120 FOUND DAMAGES ON THE G5 GALLEY COMPARTMENTS. CORRECTIVE ACTION:COMPLIED WITH ER/A 628039-14. (1099468).SDR AALA202507256367Placard · missingAIRCRAFT IN BASE MAINTENANCE: R1 PASSENGER /CREW DOOR GIRT BAR ORANGE DOT INDICATION PLACARD IS MISSING. MAINTENANCE INSTALLED PLACARD PER AMM 11-00-00.SDR AALA202507254317Placard · missingAIRCRAFT WAS NOT GROUNDED: DURING A SCHEDULED REPLACEMENT OF THE R3 DOOR SLIDE MAINTENANCE FOUND NEW SLIDE MISSING STENCIL AND CLASSIFIED THE SLIDE AS BAD FROM STOCK. MAINTENANCE ROUTED THE DEFECTIVE SLIDE TO BE REPAIRED AND REINSTALLED OLD SLIDE ON R3 DOOR PE