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 AALA202602108128Hinge 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 AALA202602104241Hinge 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 IPXA2026020227094Adapter · corrodedMAJOR REPAIR, MDC FLOOR, FR 55, Y0, RT CLS ADAPTER CORRODED. ACCOMPLISHED EA 300-5316-27-A4270, PRELIMINARY 1, STEP 13. INSTALLED THE CLS ADAPTER IAW SRM 51-40-21. ACCOMPLISHED PERMANENT REPAIR IAW EO-96237-REQ1 & VT-MAE EA 300-5316-27-A4270, REV-.SDR IPXA2026020222905Adapter · corrodedMAJOR REPAIR, MCD FLOOR, LT SIDE, FRAME 29 ADJACENT TO Y0 SEAT TRACK, CLS HAS CORROSION. DOT 103-71 ACCOMPLISHED E.A 300-5314-27-A4271 PRELIMINARY 1 STEP 9 RESTORE SURFACE AND PAINT SCHEME ACCORDING TO SRM 51-23-10 AND 51-75-10. ACCOMPLISHED PERMANENT REPAISDR SWAA2026020659892Support Angle · crackedCRACKED CARGO LINER SUPPORT ANGLE, BS 867 - 887, RBL 54. REPLACED LINER SUPPORT ANGLE IAW SRM 51-40-02, AND DWG 149A9491, SHEET 12, REV D, DWG 146A7942, SHEET 15, REV-.SDR SWAA2026020659897Floorbeam · crackedCRACKED SUPPORT ANGLE, BS 270, BTW LBL 5 TO RBL 5, WL 208.1. FLOOR STRUCTURE FLIGHT DECK. EVALUATED REWORK AREA ON SUPPORT ANGLE AND FOUND WITHIN LIMITS IAW SRM 53-10-51-1A-1, ALLOWABLE DAMAGE 1, STEP 4.C (1), DETAILSDR SWAA2026020660008Web · crackedCRACK WEB INBOARD FAN COWL ON LT ENGINE. REPLACED WEB INBOARD FAN COWL ON LT ENGINE IAW B737-700 SRM-51-40-02 AND CMM- 71-31-30.SDR SWAA2026020660009Web · crackedCRACKED WEB, OTBD FAN COWL ON RT ENGINE. REPLACED THE WEB ON RT ENGINE IAW SRM-51-40-02, AND CMM- 71-31-30.SDR SWAA2026020559866Hook · looseFWD ENTRY DOOR SLIDE AFT GIRT BAR HOOK LOOSE. SECURED THE GIRT BAR HOOK IAW SRM 51-40-02.SDR AALA202602040851Light · inoperativeAIRCRAFT IN BASE MAINTENANCE: LEFT HAND AFT OVERWING EXTERIOR EMERGENCY LIGHT IS INOPERATIVE. REMOVED AND REPLACED LAMP AT LEFT HAND AFT EMERGENCY EXIT OVERWING LIGHT. PERFORMED A SATISFACTORY OPERATIONAL CHECK OF LEFT HAND AFT OVERWING EXTERIOR EMERGENCY LIGHSDR SWAA2026020359998Tie Clip · crackedCRACK ON TIE CLIP LOCATED BS 380 AND STRINGER 8L ON FWD PASS CABIN. REPLACED TIE CLIP AND FASTENERS LOCATED BS 380 AND STRINGER 8L ON FWD PASS CABIN IAW SRM 51-40-02; SRM 51-10-02, ITEM 9 AND DWG 143A1110 SHEET 32, REV -.SDR IPXA2026012234008Skin · crackedLEFT WING FIXED LEADING EDGE SKIN UPPER SURFACE HAS A GOUGE, AREA BY SLAT NR 1 OTBD END. PERFORMED CUT OUT OF THE AFFECTED PANEL FROM THE CENTER LINE OF THE MAIN TRACK AT OSS 809.46 TO THE OTBD END OF PANEL, IAW EA 757-5741-27-A4274 PRELIMINARY 1, STEP 3. INSDR IPXA2026012634694Seat Track · corrodedMDC SEAT TRACK -Y2127.5 CORRODED SECTION BETWEEN FR72 AND FR73 RH SIDE. REMOVED SEAT TRACK FROM FR 70 TO FR 74 AT -Y2127 IAW SRM-53-10-16. INSTALLED SEAT TRACK AT FR 71 TO FR 74 AT -Y2127 IAW SRM-53-10-16.SDR AALA202602038215Door Latch · gougedAIRCRAFT IN BASE MAINTENANCE: FORWARD GALLEY SERVICE DOOR FUSELAGE CUTOUT STRUCTURE AFT FRAME-MOUNTED UPPER LATCH TRACK FITTING HAS A GOUGE AT EDGE. REMOVED AND REPLACED FITTING (LATCH RECEIVER) AT FORWARD GALLEY SERVICE DOOR FUSELAGE CUTOUT AFT UPPER SIDE, PESDR AALA202602031157Track · chafedAIRCRAFT IN BASE MAINTENANCE: FORWARD GALLEY SERVICE DOOR FUSELAGE CUTOUT STRUCTURE, FORWARD FRAME-MOUTED LOWER LATCH TRACK FITTING HAS A CHAFE. REMOVED AND REPLACED LOWER LATCH TRACK FITTING (LATCH RECEIVER) AT FORWARD GALLEY SERVICE DOOR FUSELAGE CUTOUT STRUSDR IPXA2026020223560Floor Panel · damagedMCD FLOOR PANEL BTWN FRAME 19 TO 22, Y1456 TO Y953 BROKEN TWO PLACES & A SPOT OF EXTERNAL SURFACE MISSING. FABRICATED A NEW FLOOR PANEL 241MJ IAW SREO-16407-REQ001.SDR IPXA2026012723222Floor Panel · damagedMCD FLOOR PANEL 231WG, LOWER SURFACE CRACKED. FABRICATED FLOOR PANEL 231KJ COMPLETED IAW SREO-16407-REQ001, APPX B.SDR IPXA2026020228383Web · crackedATTACH WEB LOCTD INBD OF LT WING OTBD FLAP, INBD FLAP CARRIAGE, DIRECLY NEXT TO LT WING NR 5 SPOILER INBD ATTACH POINT CRACKED AT THE UPPR FWD CORNER. REMOVED ATTACH WEB LOCTD INBD OF LT WING OUTBD FLAP, INBD FLAP CARRIAGE, DIRECLY NEXT TO LT WING NR 5 SPOILESDR AALA202602011550Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT LT PASSENGER DOOR CUTOUT LOWER SILL BETWEEN FR 66 AND FR 68 AT S23L. REPLACED LOWER SILL IAW SRM 51-72-11.SDR IPXA2026012833721Tee Fitting · corrodedLEFT WING TO BODY FAIRING STRUCTURE WITH TEE FITTINGBEAM EXFOLIATED BTWN STA 1200 AND 1220 AT BL 57.50. INSTALLED NEW T-FITTING P/N: UP-149N7630-37 BETWEEN STA 1180-1240 LBL 57.50 I.A.W B757-200 SRM 51-40-02-OG.SDR CALA2026012813413Frame · corrodedDURING C-CHECK, THREE CORROSION DAMAGES ON BS 1420 FRAME BTWN S29-30L, S29-30R & S28-29R. MAJOR REPAIR ACCOMPLISHED AND ALL RII STEPS C/W.SDR CALA2026012813412Frame · corrodedCORROSION DAMAGE ON BS 1460 FRAME BOTTOM BETWEEN S29 -30R. PERFORMED AN INSPECTION IAW PART 2 OF THE LATEST REVISION OF ECRA 5360-02086. ACCOMPLISHED MAJOR REPAIR AND ALL RII STEPS C/W. DIP APPROVED FOR INSPECTION OF DAMAGE.SDR SWAA2026012760126Support · corrodedCORRODED SUPPORT ZEE, BS 727E + 10 INCHES - 847, LBL 21, WL 156.1 IN THE AFT CARGO BAY. PERFORMED A PERMANENT REPAIR OF THE SUPPORT ZEE IAW SRM 53-00-53-2R-6, REPAIR 6, FIGURE 203.SDR AALA202601279838Clamp · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT BAFFLE CLIP AT BS 500H, RBL 26. REPLACED BAFFLE CLIP PER AARD 51-00-05-1.SDR AALA202601270209Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN ALONG RIB LINE AT STABILIZER STA 120.3, 27 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202601270146Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT BAFFLE BETWEEN BS 500A AND BS 500B AT S25L. REPLACED BAFFLE PER AARD 51-00-05-1.SDR SWAA2026012659858Crossbeam · crackedCABIN CROSSBEAM IS CRACKED. LOCATED BELOW FLOORBOARD 231UF, BS 540 FROM BL 0 - RBL 24. REPLACED CROSSBEAM IAW SRM 51-40-02.SDR AALA202601266530Bulb · inoperativeAIRCRAFT IN BASE MAINTENANCE: LEFT HAND AFT OVERWING EXTERIOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED LAMB. PER B737NG AMM 33-51-04.SDR IPXA2026012223577Pressure Web · corrodedMCD FLOOR, LH SIDE, BTWN FRAME 19 TO 22 AND BTWN Y1456 TO Y953 SEAT TRACKS, UNDER PANEL, FLOOR HAS CORROSION (APPROX 4 PLACES). REMOVED PRESSURE WEB IAW SRM 51-40-21. INSTALLED NEW PRESSURE WEB AT BTWN FRAME 19 TO 22 AND BTWN Y1456 TO Y953 IAW SRM 51-40-21.SDR AALA202601237496Bolt · wornAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO LAX DUE TO THE FLIGHT CREW REPORTING THAT INFLIGHT VIBRATIONS FELT FROM ABOUT 13,000 THROUGH CLIMB OUT 30,000 FEET APPROXIMATE SPEED 340. VIBRATION WAS FELT ON LEFT SIDE ON BOTH RUDDSDR AALA202601229123Warning Message · false activationAIRCRAFT WAS NOT GROUNDED: RIGHT AFTER TAKE OFF THE FORWARD LEFT MAIN FUEL PUMP CAME ON AND STAYED ON EVEN AFTER COMPLETION OF QRH PROCEDURE. FUEL PUMP LOW PRESSURE INDICATION OPERATIVE, NO FAULT FOUND.SDR DALA2026011600379Transceiver · faultedATB- PERFORMED AN AIR TURN BACK DUE TO A WEATHER RADAR. MAINTENANCE REPLACED THE WEATHER RADAR TRANSCEIVER AND PERFORMED OPERATIONAL TEST. AIRCRAFT RETURNED TO SERVICE.(7949802)SDR AALA202601154734Lamp · inoperativeAIRCRAFT IN BASE MAINTENANCE: FLIGHT STATION EMERGENCY LIGHT IS INOPERATIVE. RELAMPED THE EMERGENCY DOME LIGHT IN THE FLIGHT STATION. PER AMM 33-14-00-960-80. PERFORMED A SATISFACTORY EMERGENCY LIGHTS OPERATIONAL CHECKFOR THE FLIGHT STATIONEMERGENCY DOME LIGHTSDR AALA202601158477Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT BAFFLE CLIP AT BS 500H, RBL 26. REPLACED CLIP IAW AARD 51-00-05-1.SDR AALA202601159924Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT BAFFLE ASSY BETWEEN BS 500D AND BS 500E AT S25R. REPLACED BAFFLE ASSY PER AARD 51-00-05-1.SDR AALA202601151263Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT BAFFLE ASSY BETWEEN BS 500C AND BS 500D AT S25R. REPLACED BAFFLE ASSY PER AARD 51-00-05-1.SDR AALA202601159081Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT BAFFLE ASSY BETWEEN BS 500G AND BS 500H AT S25R. REPLACED BAFFLE ASSY PER AARD 51-00-05-1.SDR AALA202601154717Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT BAFFLE ASSY BETWEEN BS 500B AND BS 500C AT S25L. REPLACED BAFFLE ASSY PER AARD 51-00-05-1.SDR IPXA2026011327277Skin · dentedA/C ARRIVED WITH 4? DENT IN FUSELAGE JUST AFTER & LEFT OF TAIL STAND BALL. MATERIAL ID FOR REPAIR TO BE 2024T3-.071€? PO. SP2889817 FOR FILLERS, AND 2024T3-.090€? PO. SP2564337 FOR DOUBLER. REPAIRED IAW EO-96217.SDR FDEA202601090044Skin · crackedFWD CARGO DOOR INNER SKIN AT FR22A, BEAM1-BEAM2 CRACKED. COMPLIED WITH EA 6-5230-T0386127 REPAIRED THE FWD CARGO DOOR FR22A BEAM1-BEAM2 CRACKED INNER SKIN. TITLE: DOORS - CARGO DOOR/HYD SYS - FWD CARGO DOOR - CRACK ON INNER SKIN FWD OF FR22A BELOW BEAM #1.SDR SWAA2026011459988Battery Pack · inoperativeLH OWE EMERGENCY EXIT LIGHTS INOPERATIVE. ACCESSED SIDEWALLS AND DADO PANELS; REMOVED AND REPLACED BATTERY PACKS; PERFORMED GOOD OPS TESTS ON BATTERY PACKS AND REINSTALLED ACCESSED SIDEWALLS AND DADO PANELS IAW AMM 33-51-06 AND AMM 25-21-46 AND AMM 21-23-03.SDR SWAA2026011459753Seal · crackedRIGHT HORIZONTAL STABILIZER'S UPPER FRONT TO BODY SLIDING SEAL IS CRACKED. R & R RT FWD UPPER SLIDER IAW AMM REF 53-31-31.SDR G1IA20260109101Landing Gear · failedON APPROACH TO LAND IN FNL, PUT GEAR HANDLE IN DOWN POSITION. HEARD AND FELT THE GEAR MOVE. INDICATOR LIGHTS SHOWED NOSE AND LT MAIN GEAR DOWN, BUT NOT RT MAIN. BROKE OFF APPROACH AND RECEIVED VECTORS AND A SAFE ALTITUDE FROM ATC. FOLLOWED LANDING GEAR MASDR SWAA2026011359676Post · corrodedPASSENGER CABIN FWD LAV AFT INBD LOWER POST HAS EVIDENCE OF CORROSION. REMOVED FWD FLIGHT ATTENDANT SEAT TO FOM IAW AMM 25-25-12. FWD FLIGHT ATTENDANT SEAT INSTALLED IAW TASK CARD 725-41-01. REMOVED AND REPLACED THE FWD LAV ASSY IAW TASK 725-41-01.SDR SWAA2026011359698Pan · corrodedPASSENGER CABIN FWD LAV FLOOR PAN HAS EVIDENCE OF CORROSION AT THE THRESHOLD. REMOVED AND REPLACED LAVATORY IAW TASK CARD 725-41-01, FAULT TTG8Q019T2FF.SDR SWAA2026011359850Flashlight · failedAFT FA FLASHLIGHT WILL NOT TEST. REINSTALLED AFT FA FLASHLIGHT IN MOUNTING BRACKET AND OP CHECKED IAW AMM 25-64-00. OPS CHECKED GOOD.SDR SWAA2026011359785Rivet · shearedGIRT BAR LOOSE ON FWD ENTRY DOOR. FOUND SHEARED RIVET ON FWD ENTRY DOOR SLIDE J HOOK. INSTALLED A NEW RIVET IAW SRM 51-40-02-0G-0, PARA 4B.SDR HNAA202601130000Door · obstructedDURING TAKE OFF, CARGO DOOR INDICATED OPEN. MAINTAINED 8000 FT & BELOW, THEN RETURNED TO FIELD. DISCOVERED CARGO NET PARTIALLY CAUGHT IN CARGO DOOR. SECURED THE CARGO NET AND CARGO DOOR AS REQUIRED. OPS CHECKED GOOD. NO DEFECTS NOTED. ACFT OK FOR SERVICE.SDR AALA202601139123Warning Light · illuminatedAIRCRAFT WAS NOT GROUNDED: RIGHT AFTER TAKE OFF THE FORWARD LT MAIN FUEL PUMP CAME ON AND STAYED ON EVEN AFTER COMPLETION OF QRH PROCEDURE. (OPEN).SDR AALA202601130437Cover · missingAIRCRAFT WAS NOT GROUNDED: AFT RIGHT EMERGENCY EXIT SIGN COVER ON RIGHT SIDE OF AIRCRAFT MISSING BEFORE GALLEY. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-00. OPS CHECKED GOOD.