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 SWAA2025071683208Lens · brokenBROKEN EMERGENCY EXIT LENS GALLEY 4 AT AFT GALLEY AREA (1 EA). REPLACED EMERGENCY EXIT LENS GALLEY 4 AT AFT GALLEY AREA IAW AMM 33-51-01-960-802 STEP 3.C. ITEM (10).SDR SWAA2025071683212Housing · brokenBROKEN HOUSING ASSY EMERGENCY LIGHT OVERHEAD STOWAGE BIN 3 LH SIDE AT PASSENGER CABIN. REPLACED HOUSING ASSY EMERGENCY LIGHT OVERHEAD STOWAGE BIN 3 LH SIDE AT PASSENGER CABIN IAW B737-700 AMM 33-51-03-960-802 TEST IS OK.SDR ASAA2025061959414Doubler · corrodedBELLY DRAIN DOUBLER BS.737.37 BL.0 SHOWS SIGNS OF CORROSION. GROUNDED - YES. REMOVED CORROSION ON BELLY DRAIN DOUBLER AT STA.737.37 BL.0 ORIGINAL MAT .063" IAW BAC DWG #146A3239 REV:C, LOST .008", REMAINING .055" OF MATERIAL FOUND BEYOND LIMITS IAW B737-800 SRSDR SWAA2025071587699Battery Pack · inoperativeINOP BATTERY PACK LH SIDE AT FWD GALLEY AREA (1EA). REPLACED BATTERY PACK LH SIDE AT FWD GALLEY AREA (1EA) IAW B737-700 AMM 33-51-06-960-805. INSTALLATION TEST IS OK.SDR SWAA2025071583629Light · inoperativeINOP EMERGENCY LIGHT LAV A AT FWD GALLEY AREA. REPLACED EMERGENCY LIGHT LAV A AT FWD GALLEY AREA IAW B737-700 AMM-33-51-01-960-802. PERFORMED OPERATIONAL TEST IS OK;SDR SWAA2025071583646Floor Support · crackedAAI REPORT MAIN CABIN - FLOOR STRUCTURE SUPPORT HAS CRACK AT STA 540 BTW BL 0 TO RBL 24.75 . REPLACED FLOOR STRUCTURE SUPPORT LOCATED AT 540 BETWEEN BLO TO RBL 24.75 PASSENGER CABIN IAW B737-700 SRM 51-10-02 PARAGRAPH 9; SRM 51-40-02 AND DWG: 143A0060 SHEET: SDR SWAA2025071583633Pressure Deck · crackedCRACK INDICATION FOUND ON HORIZONTAL PRESSURE DECK WEB AT LBL 31 BETWEEN STA 663 TO STA 675 AT MAIN WHEEL WELL COMPARTMENT. CRACK LENGTH: 0.250 IN. APPROX. REWORKED AREA OF TOOLING MARK LOCATED ON WEB AT LBL 60 BTW STA 663 TO STA 675 AND FOUND WITHIN LIMITS DSDR SWAA2025071583628Pressure Deck · crackedCRACK INDICATION FOUND ON HORIZONTAL PRESSURE DECK WEB AT RBL 42 BETWEEN STA 663 TO STA 675 AT MAIN WHEEL WELL COMPARTMENT. CRACK LENGTH: 0.500 IN. APPROX 2025-389846<[01] TOOL USED ON STEP 6; 7 AND 8. ET EQUIPMENT: P/N: NORTEC 600D; S/N: 60007161486; CAL DUE SDR SWAA2025071583647Floorbeam · crackedAAI REPORT MAIN CABIN - FLOOR STRUCTURE SUPPORT HAS CRACK AT STA 540 BTW BL 0 TO LBL 24.75. REPLACED FLOOR STRUCTURE SUPPORT LOCATED AT 540 BETWEEN BLO TO LBL 24.75 PASSENGER CABIN IAW B737-700 SRM 51-10-02 PARAGRAPH 9; SRM 51-40-02 AND DWG: 143A0060 SHEET: SDR SWAA2025071583643Grommet · missingAAI REPORT MAIN CABIN - FLOOR BEAM WEB HOLES FLIGHT CONTROL CABLES MLGEA AND EA PASS THROUGH PROTECTOR GROMMETS ARE MISSING STA 312 AT REPLACED INTERCOSTAL AREA. VERIFIED DWG 141A5503 SHEET 15; GROMMETS MUST BE INSTALLED ON FLOORBEAM WEB HOLES LOCATED ON BS 3SDR SWAA2025071583403Angle · crackedCRACK ANGLE TRAILING EDGE LOCATED ORSS 279 AT LT WING. REPLACED ANGLE LOCATED ON TRAILING EDGE LOCATED ORSS 279 AT LT WING. IAW B737-700 SRM 51-10-02; ITEM 9. SRM 51-40-02 AND DWG 115A6200; SHEET: 10 AND REV: -.SDR SWAA2025071583402Angle · crackedCRACK ANGLE TRAILING EDGE LOCATED FWD POSITION AT LEVEL ORSS 270 AT RT WING. REPLACED ANGLE TRAILING EDGE LOCATED FWD POSITION AT LEVEL ORSS 270 AT RT WING IAW SRM 51-10-02; ITEM 9 AND SRM 51-40-02. MEASURE OF CRACK IS 0.995.SDR SWAA2025071583401Angle · crackedCRACK ANGLE TRAILING EDGE LOCATED AFT POSITION AT LEVEL ORSS 270 AT RT WING 2025-389818 <[01]. REPLACED ANGLE TRAILING EDGE LOCATED AFT POSITION AT LEVEL ORSS 270 AT RT WING IAW B737-700 SRM 51-40-02; SRM 51-10-02 ITEM 9 AND DWG 115A2930 SHEET 8 REV-.TOOL USEDSDR SWAA2025071583404Angle · crackedCRACK ANGLE TRAILING EDGE LOCATED AFT POSITION AT LEVEL ORSS 270 AT LT WING 2025-389821<[01]. REPLACED ANGLE ON TRAILING EDGE LOCATED AFT POSITION AT LEVEL ORSS 270 AT LT WING IAW B737-700 SRM 51-40-02 AND DWG 115A2930 SHEET 7 REV:-. LENGTH OF CRACK IS: 1.056?SDR SWAA2025071583677Skin · crackedCRACK ON LH HORIZONTAL STABILIZER LOWER SKIN STA 193.90; 25.5' AFT FROM L/E; L: 0.3'. REPAIRED IAW SRM 55-10-01-2R-11<BR>LH H. STAB. LWR SKIN STA193.90; 25.5' FROM L/E.SDR CALA2025071506569Stringer · gougedAFT CARGO STRINGER 40R GOUGED APPROX 7 INCHES FWD OF FRAME 48.SDR SWAA2025071483430Scuff Plate · crackedACB FWD CORNER SCUFF PLATE IS CRACKED. REMOVED AND REPLACED ACB CORNER SCUFF PLATE P/N:146A8341-7 LOT:1610461-1 IAW SRM 51-10-02-0G-0 PAR 9.SDR SWAA2025071483431Scuff Plate · crackedACB AFT CORNER SCUFF PLATE IS CRACKED. REMOVED AND REPAIRED ACB AFT CORNER SCUFF PLATE IAW SRM RM 53-60-15-2R-1-A00967 (REPAIR 1 - AFT CARGO DOOR SURROUND STRUCTURE - PERMANENT)SDR SWAA2025071483673Scuff Plate · crackedFCB FWD CORNER SCUFF PLATE IS CRACKED.<[01] RECIVED NEW FWD CORNER SCUFF PLATE ITEM:654A0004-337 LOT: 1603223-1. THE INSTALLATION OF THIS PART WILL BE COMPLETED ON CARD TTG8Q0137XVD.SDR SWAA2025071483674Scuff Plate · crackedFCB AFT CORNER SCUFF PLATE IS CRACKED. REPAIRED FWD CARGO DOOR FWD CORNER SCUFF PLATE IAW SRM 53-30-15-2R-1 PARAGRAPH 4.B.(2). REFER TO SOPM 20-30-02 AND APPLIED CHEMICAL CONVERSION IAW SOPM 20-43-03; TYPE 2; CLASS A OR C..SDR JJBA20250711027Floorbeam · corrodedRH IB FLOOR SUPPORT CAP AT FRAME 39 IS BENT AND RIVETS ARE PUNCHED THROUGH. REMOVED RH IB FLOOR SUPPORT CAP AT FRAME 39. RECEIVED NEW DOUBLER, LOCATED, DRILLED AND INSTALLED NEW PART.SDR JJBA20250711009Floor Support · corrodedCF1, ANGLE ON INBD SIDE OF CENTER OMEGA BEAM BTW FR18-20 FOUND CORRODED. AT CF1 ANGLE ON INBD SIDE OF CENTER OMEGA BEAM BTW FR18-20, ANGLE REMOVED. AT CF1 ANGLE ON INBD SIDE OF CENTER OMEGA BEAM BTW FR 18-20 FOUND CORRODED OUT OF LIMIT. DRILLED NEW HOLES FOR NSDR IPXA2025070416637Angle · corrodedSTR / AFT CARGO COMPARTMENT ANGLE UNDER R/H TRANSITION PANEL IS CORRODED BETWEEN STA 1440 AND STA 1460, RBL 25. 031-013. ATA-53-00.REMOVED CORRODED ANGLE FROM LOWER SIDE OF R/H TRANSITION PANEL STA 1440 TO STA 1460 TO F.O.M.IAW B757-200PF SRM 51-40-02-OG-0.REMSDR IPXA2025070316837Angle · corrodedSTR / AFT CARGO COMPARTMENT FRAME STA 1440 LOWER FLANGE HAS CORROSION BETWEEN STGR 27RH AND STGR 28RH. 031-015. ATA-53-00.REMOVED CORRODED ANGLE AT AFT CARGO COMPARTMENT FRAME STA 1440 BETWEEN STGR 27RH AND STGR 28R REF B 757 SRM 51-40-02-OG-O.CLEANED AREA ON SDR SWI2025F00870Seat Track · corrodedFWD WET AREA RIGHT TRACK HAS CORROSION AT FR 17 AS MARKED. (C-CHECK RO 07/06/2025)REPAIRED RH IB SEAT TRACK AT FR 17 WITH REPAIR DOUBLER REF ETD2025-170-923495. SEE CONTINUE CARD FOR WORK PERFORMED. NO CHANGE TO WEIGHT AND BALANCE.SDR SWIA20250707619Seat Track · corrodedAFT WET AREA FLOOR STRUCTURE HAS CORROSION ON RH SEAT TRACK FR 84-85. (C-CHECK RO 07/06/2025)PERFORMED PERMANENT SPLICE REPAIR ON RH INBD FLOOR BEAM SEAT TRACK FR 83-85 REF. ETD2022-170-022163 REV. C. WEIGHT OF REPAIR MEASURES 292.22 GRAMS CAL. TOOL I.D.# SHSDR AALA202507073464Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY HINGE ARM 3 ELEVATOR ON RH HORIZONTAL STABILIZER. MAINTENANCE REPLACED HINGE ARM 3 ELEVATOR ON RH HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202507079988Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY HINGE ARM 5 ELEVATOR ON RH HORIZONTAL STABILIZER). MAINTENANCE REPLACED HINGE ARM 5 ELEVATOR ON RH HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR IPXA2025070304712Lever · deformedFOUND THE ENTRY DOOR DOORWAY ARMING LEVER HINGE ASSY WITH DEFORM DAMAGE (REPLACE) INSTALLED DOORWAY LINING I.A.W AMM 52-12-02-404-025 REV. 145.SDR DALA2025063004873Fairing · damagedSHIP 3119 RIGHT WING SLAT TRACK FAIRING RACKED AND PEELED BACK. CORRECTIVE ACTION: INSTALLED NEW SLAT CLOSING PLATE PER A319 AMM 27-84. (7441368)SDR SWAA2025063083436Skin · delaminatedLT. OUTBD AFT FLAP UPPER SURFACE DELAMINATED ON INBD. END<[01] 01 - REMOVED AND REPLACED PER [AMM 27-51-22-400-801-NG (OUTBOARD AFT FLAP INSTALLATION - PERMANENT)];[02] VERIFIED REMOVED AND REPLACED PER [AMM 27-51-22-400-801-NG (OUTBOARD AFT FLAP INSTALLATION SDR DALA2025063004853None · noneSHIP 9508 TRACKING FOR DTE FOR 24 MONTHS FROM DATE OF REPAIR APPROVAL. CORRECTIVE ACTION: C/W ERA ERA 626897-14 REV ORIGINAL. (1033207)SDR DALA2025063004855None · noneSHIP 9575 DTE, 624256-14AD. CORRECTIVE ACTION: ACCOMPLISH DTE FOR ERA 622844-14AD (1033944)SDR AALA202506308038Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY HINGE ARM 2 ELEVATOR ON RH HORIZONTAL STABILIZER. MAINTENANCE REPLACED HINGE ARM END FITTING 2 ON RH HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202506306959Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY HINGE ARM 1 ELEVATOR ON RH HORIZONTAL STABILIZER. MAINTENANCE REPLACED HINGE ARM END FITTING 1 ON RH HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202506305157Actuator · faultedAIRCRAFT WAS NOT GROUNDED: FLIGHT CREW REPORTED A CENTER RIGHT FUEL TRANSFER VALVE FAULT MESSAGE AT START OF DESCENT WITH ZERO FUEL IN ACTS. **SUPPLEMENTAL REPORT FOR AALA202506235157: MAINTENANCE REPLACED THE CENTER RIGHT FUEL TRANSFER VALVE ACTUATOR AND ACCOSDR FDEA202506191079Skin · gougedA GOUGE WAS FOUND ON OUTBD EDGE LOWER SIDE OF L2 SPLR. ACCOMPLISHED DOUBLER REPAIR WITH FASTENERS AT OUTBD EDGE OF L2 SPLR RIB 18 POSITION I.A.W FEDEX EA NO:T6-5750-T0383884P1, SEQ NO: XXX , TITLE: WING - FLIGHT SURFACES - LH #2 SPOILER - WEAR DAMAGE AT OUSDR ANCF2025062719Blower · faultedVENT BLOWER FAULT DURING CRUISE, PRESENTING NOISE AND FUMES. IAW AMM 21-26-51-000-001-A/400-001-A REMOVAL AND INSTALLATION BLOWER FAN WAS REPLACED SATISFACTORILY. OPERATIONAL TEST OF THE AEVC WAS PERFORMED TEST OK.SDR IPXA2025062601105Filler · corrodedFOUND THE PLATE WITH CORROSION DAMAGE AT STA 1601 LBL 59 IN BULK CARGO COMPARTMENT CEILING AREA. (REPLACE) 1. FABRICATE FILLER (P/N: 146T5609-67) PER BOEING DRAWING 146T5609 SH7 REV."-"; PL REV."AA" AS A SAMPLE I.A.W GMM-MTX CH 9.08 REV: 11 REQUIREMENT 2. INSTSDR DALA2025062604791Inspection · noneSHIP 9575 AMOC, ERA 624259-14AD. CORRECTIVE ACTION: CURRENT AMOC APPROVAL IS LIMITED TO 24 MONTHS. ADDITIONAL ERA REVISION IS REQUIRED FOR AMOC APPROVAL BEYOND 17-JUN-2027 FOR ERA 624259-14AD (1033908)SDR REXA2025062600699Drag Angle · crackedCRACK ON RIGHT VERTICAL STABILIZER TO FUSELAGE ATTACHMENT AFT DRAG ANGLE BTW 55.625% STGR DATUM TO 67.5% REAR SPAR DATUM (TRACE AT BL0.00). CRACK ON RIGHT VERTICAL STABILIZER TO FUSELAGE ATTACHMENT AFT DRAG ANGLE BTW 55.625% STGR DATUM TO 67.5% REAR SPAR DATUMSDR LR7A2025061903765Brace · bentDURING CARGO LOADING, THE RAMP WAS RAISED BRING THE CARGO INTO CONTACT WITH AIRCRAFT STRUCTURE. FIVE UPPER FUSELAGE BRACES BENT APPROXIMATELY FS789 - 810 / REPLACED BRACES IAW ERO#5350ERO3946 REF MEA 382-53-25-050SDR AALA202506252718Processor · failedAIRCRAFT WAS GROUNDED: CENTER TANK FUEL QUANTITY INDICATOR ONCE AGAIN BLANKED IN FLIGHT. FUEL TOTALIZER SUBSEQUENTLY BLANKED AS WELL. FUEL QUANTITY IN CENTER TANK WAS 0 JUST BEFORE INDICATOR BLANKING. **SUPPLEMENTAL REPORT FOR (AALA202506232718): PERFORMED FQISDR DALA2025062404736Battery Pack · inoperativeSHIP 698 EMERGENCY LIGHTS AT SEATS 33 THRU 37 INOP. CORRECTIVE ACTION: R/R EMERGENCY BATTERY PACK FOR SEATS 33 THRU 37 PER B757 AMM 33- 51, OPS CHECKS GOOD. (7303925)SDR SWAA2025062483392Girt Bar · looseFWD SERVICE DOOR GIRT BAR FITTINGS ARE LOOSE.<[01] TIGHTENED FWD SERVICE DOOR GIRT BAR FITTINGS PER AMM 25-66-02-400-801 AND SRM 51-40-04<BR>TORQUE WRENCH ID# PER2640 DATE: 04/2025-04/2026;[02] VERIFIED CORRECTIVE ACTION 1SDR SWAA2025062483388Lamp · inoperativeFWD SERVICE DOOR EMERGENCY ESCAPE SLIDE LIGHT INOP. REPLACED LAMP AND PERFORMED GOOD FUNCTIONAL TEST OF FWD SERVICE DOOR EMERGENCY ESCAPE SLIDE LIGHT IAW AMM 33-51-04-960-801.SDR SWAA2025062483389Lamp · missingL/H OVERWING EXIT HATCH LOWER FWD EMERGENCY EXIT LOCATOR MISSING LAMPS. REPLACED L/H OVERWING EXIT HATCH LOWER FWD EMERGENCY EXIT LOCATOR LAMP AND PERFORMED GOOD FUNCTIONAL TEST IAW AMM 33-51-01-960-801.SDR DALA2025062404728Bottle · low pressureSHIP 3229 DISC: R2 DOOR ASSIST PSI LOW. C/A: SERVICED R2 DOOR ASSIST REF A320 AMM 52-10. OK FOR SVC.SDR AALA202506243514Hinge Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION ON FITTING HINGE OF MLG DOOR AT LH SIDE KEEL BEAM, FWD LUG IN LOWER WEB POCKET RADIUS. CRACK LENGTH IS 0.085 INCH APPROX. MAINTENANCE PERFORMED PERMANENT REPAIR LH MLG DOOR HINGE FITTING IAW EA 365227 AND DWG R533SDR DALA2025062404717Threshold · corrodedAFT SERVICE DOOR THRESHOLD/ENTRY SILL HAS CORROSION AROUND FASTENER HOLE AT AFT I/B CORNER. SUMMARY SEE NR FOR ADDITIONAL INFORMATION 001-0576:5300-2016/001 00358 REMOVED AND REPLACED ENTRY SILL PER A220 AMP 53-00-47. (LP# 1034435)