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 JJBA20251125084Floor Support · corrodedRIGHT FLOOR GUSSET AT FR 61, STR 4R HAS CORROSION. REMOVED AND REPLACED RH FLOOR BEAM GUSSET AT FR 61, STR 4R.SDR HNAA2025112500793Floor Support · crackedLEFT OMEGA BEAM CRACKED AT FR24. REPAIRED IAW ETD 2025-145-931172 AND BULLETIN 51-05.SDR HNAA2025112400789Shear Tie · cracked53-2088 SHEAR CLIP CRACKED AT FR27 BTW STR15-16L. RAR SHEAR CLIP IAW SRM 51-40-02SDR HNAA2025112400788Attach Fitting · crackedLEFT WING TO BODY FAIRING, FUSELAGE ATTACHMENT FOUND CRACKED AT FR48. REPAIRED IAW SRM 53-23-12SDR HNAA2025112400787Beam · corrodedLOWER BEAM AT SERVICE DOOR ENTRY CORRODED. R & R LOWER BEAM IAW SRM 51-40-02SDR SWAA2025112026659Access Panel · damagedELONGATED HOLES ON ACCESS PANEL 561CB AT LT WING. REPAIRED ACCESS PANEL 561CB AT LT WING IAW SRM 51-70-04-2R-10 REPAIR 10.SDR SWAA2025112026657Access Panel · elongatedELONGATE HOLES ON ACCESS PANEL 561AB LT WING. REPAIRED ACCESS PANEL 561AB LT WING IAW SRM 51-70-04-2R-10 REPAIR 10. SEE INDIVIDUAL SIGN OFFS BELOW.;[03] TASK COMPLETED.SDR SWAA2025112026658Access Panel · elongatedELONGATE HOLES ON ACCESS PANEL 561BB AT LT WING. REPAIRED ACCESS PANEL 561BB AT LT WING IAW SRM 51-70-04-2R-10 REPAIR 10. MAJOR REPAIR.SDR SWAA2025112026654Access Panel · elongatedELONGATE HOLES ON ACCESS PANEL 561AB LT WING. FAULT RESOLVED ON OTHER FAULT; SEE TTG8Q015VWDA.SDR SWAA2025112027210Attach Angle · crackedBS 663 RT VAPOR BARRIER UPPER ATTACH ANGLE CRACKED AT RBL 34. REMOVED FASTENERS IN THE ATTACH ANGLE AND BULKHEAD IAW SRM 51-40-02. MATCH DRILLED NEW REPLACEMENT ANGLE IAW SRM 51-40-02. INSTALLED FASTENERS IN ATTACH ANGLE IAW SRM 51-40-02 & DWG 111A1000. SDR SWAA2025112027211Attach Angle · crackedBS 663 LT VAPOR BARRIER UPPER ATTACH ANGLE CRACKED AT LBL 34. REMOVED THE LT VAPOR BARRIER UPPER ATTACH ANGLE IAW SRM 51-40-02. C/W HFEC OF OPEN HOLES IN REPAIR AREA PER NDT PART 6 51-00-00 PROD. 16, NO DEFECTS NOTED. MATCH DRILLED NEW ANGLE IAW SRM 51-4SDR SWAA2025112027157Stub Frame · crackedCRACK INDICATION ON STUB FRAME, BETWEEN BS 294.5 - 296.5, BTW S8R TO S9R. LENGTH OF CRACK; 0.312 IN. REPLACED THE STUB FRAME AND FASTENERS IAW SRM 51-40-02, DWG 141A8370, SHEET 9, SHEET 10, REV D.SDR SWAA2025112027156Floor Support · crackedCRACK FLOOR SUPPORT BTW BS 277 TO 294.5, BL 0. REPLACED THE FLOOR SUPPORT IAW SRM 51-10-02, ITEM 9, AND SRM 51-40-02. MEASUREMENT OF THE CRACK IS 1.0675 INCHES.SDR SWAA2025112027155Floor Support · crackedCRACKED FLOOR SUPPORT BTW BS 344 - 360, BL 0. REPLACED THE FLOOR SUPPORT IAW SRM 51-40-02, SRM 51-10-02, ITEM 9, AND DWG 141A5400, SHEET 32, REV -.SDR SWAA2025112027152Floor Support · crackedCRACKED FLOOR SUPPORT BTW BS 312 - 328 LBL 46 IN THE FWD GALLEY AREA. REPLACED THE FLOOR SUPPORT IAW SRM 51-40-02, SRM 51-10-02, ITEM 9 & DWG 141A5400, SHEET 26, REV -.SDR JJBA20251120104Doubler · bentCENTER FUSELAGE III, DOUBLER ON TOP RH OMEGA BEAM AT FRAME 35 BENT. CFII DOUBLER ON TOP RH OMEGA BEAM AT FRAME 35 REMOVED AND REPLACED.SDR JJBA20251120088Floor Support · corrodedRIGHT FLOOR GUSSET AT FR 61, STR 4R, HAS CORROSION. REMOVED AND REPALCED RT FLOOR BEAM GUSSET AT FR61, STR 4R.SDR JJBA20251120083Floor Support · corroded"LH FLOOR GUSSET AT FR 61, STR 4L, HAS CORROSION. LH FLOOR GUSSET AT FR 60, STR 4L, HAS CORROSION. REMOVED AND REPLACED 1EA. LH FLOOR GUSSET AT FR 61, STR 4L.SDR SWAA2025111927142Lens · brokenBROKEN LENS EMERGENCY EXIT LIGHT (WITH ARROW) AT EMERGENCY EXIT HATCH RH SIDE PASSENGER CABIN (1EA) 2025-636395<[01] REPLACED LENS EMERGENCY EXIT LIGHT (WITH ARROW) AT EMERGENCY EXIT HATCH RH SIDE PASSENGER CABIN (1EA) I.A.W B737-700 AMM 33-51-01-960-801; STEPSDR HNAA2025111900757Shear Tie · crackedSHEAR TIE CRACKED AT FRAME 25 BTW STRINGERS 15-16L. R & R SHEAR TIE IAW SRM 51-40-02SDR HNAA2025111900756Support · corrodedRT SILL CORRODED BTW FRAMES 23-29. R & R SILL IAW SRM 51-40-02SDR HNAA2025111900755Shear Tie · crackedSHEAR TIE CRACKED AT FRAME 24 BTW STRINGERS 16-17R. R & R THE SHEAR CLIP IAW SRM 51-40-02.SDR HNAA2025111900751Support · corrodedLEFT SUPPORT CORRODED AT BTW FRAMES 19-23. R & R SUPPORT IAW SRM 51-40-02.SDR ASAA2025102262379Support · crackedLEFT A/C BAY AFT BULKHEAD BS 663, CRACKED UPPER INBD SUPPORT ANGLE. GROUNDED - YES. REPAIRED SUPPORT ANGLE ON LT A/C BAY AFT BULKHEAD IAW SRM 57-10-10-2R-5.SDR ASAA2025102262378Support Angle · crackedRIGHT A/C BAY AFT BULKHEAD, BS 663 CRACK UPPER INBD SUPPORT ANGLE. GROUNDED - YES. REPAIRED SUPPORT ANGLE ON RT A/C BAY AFT BULKHEAD IAW SRM 57-10-10-2R-5.SDR HNAA2025111700745Shear Tie · crackedSHEAR TIE CRACKED AT FR27 BTW STRINGERS 15-16R. R & R THE SHEAR TIE IAW SRM 51-40-02SDR HNAA2025111700744Shear Tie · crackedSHEAR TIE CRACKED AT FR24 BTW STRINGERS 15-16R. R & R THE SHEAR TIE IAW SRM 51-40-02.SDR HNAA2025111700743Shear Tie · crackedLEFT SHEAR TIE CRACKED AT FR48 BTW STRINGERS 13-14L. R & R THE SHEAR TIE IAW SRM 51-40-02.SDR R61A2025111400498Shear Panel · corrodedDURING HEAVY CHECK CF III L/H SHEAR PANEL BETWEEN FR 87- FR88 LBL 12-LBL 41 FOUND CORRODED. REMOVED AND REPLACED SHEAR PANEL IAW EMB 170/175 SRM 51-42-02SDR R61A2025111400497Seat Track · corrodedDURING HEAVY CHECK FWD CABIN WET AREA L/H INBOARD SEAT TRACK BETWEEN FR12 TO FR23 FOUND CORRODED. REMOVED AND REPLACED SEAT TRACK IAW EMB 170/175 SRM 51-41-02,51-43-03SDR AALA202511145400Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED AFT CABIN FLOOR SHEAR PLATE AT FR 70 AND S23L. REPLACED SHEAR PLATE PER SRM 51-42-11.SDR SWAA2025111327044Attach Bracket · crackedSEAT TRACK NR 4 ATTACH BRACKET CRACKED AT BS 727B UNDER FLOORBOARD 242DF. REMOVED DAMAGED SPLICE STRAP AT BS 727B; RBL 45.5 IAW SRM 51-40-02. LOCATED AND DRILLED NEW PART IAW SRM 51-40-05.SDR FXGA202511120001Structure · damagedAIRCRAFT HAD A STATIONARY TAIL STRIKE DAMAGING THE LOWER TAIL CONE AREA AND TAIL TIE DOWN FITTING. AIRCRAFT WAS PARKED ON A SLOPE AND WHEN THE PILOTS EXITED THE AIRCRAFT THE PLANE TILTED BACK AND THE TAIL STRUCK THE GROUND. CAUSED DAMAGE TO LOWER AFT TAIL CONESDR AALA202511074018Stop Pad · out of positionAIRCRAFT IN BASE MAINTENANCE: RIGHT AFT AUTOMATIC OVERWING EXIT DOOR AFT UPPER DOOR STOP PAD IS OUT OF POSITION. REMOVED AND REPLACED STOP PAD PLATE AT RIGHT AFT AUTOMATIC OVER-WING EXIT DOOR. PER B737NG AMM 52-01-000-801 AND AMM 52-22-01-400-801.SDR AALA202511079996Stop Pad · out of positionAIRCRAFT IN BASE MAINTENANCE: LEFT AFT AUTOMATIC OVERWING EXIT DOOR AFT UPPER DOOR STOP PAD IS OUT OF POSITION. REMOVED AND REPLACED STOP PAD PLATE AT LEFT AFT AUTOMATIC OVER-WING EXIT DOOR. PER B737NG AMM 52-01-000-801 AND AMM 52-22-01-400-801.SDR IPXA2025110696806Flap · damagedRIGHT NR 1 FLAP DAMAGED, APPROX 74 INCHES FROM INBOARD EDGE AND 16 INCHES FROM TRAILING EDGE. INSTALLED REPAIR DOUBLERSEALED WITH P/N 1440B1-2AM654SK (PO/RO # SP2843294) PER EO-95513-REQ3.SDR E0YA202511070001Indication Sys · erraticOIL PRESSURE INDICATION ERATIC. SHUTDOWN ENGINE AS PRECAUTIONARY.SDR CALA2025110610936Skin · damagedAFT CARGO DOOR SKIN DAMAGED. REMOVED AND REPLACED AFT CARGO DOOR OUTER SKIN IAW DWG 146A6110 REV C AND SRM 52-30-01-2R-3.SDR SWAA2025110327051Lamp · not seatedLEFT EMERGENCY EXIT HATCH OVERHEAD LIGHT INOPERATIVE. ON INVESTIGATION FOUND LT EMERGENCY EXIT HATCH OVERHEAD LAMP INCORRECTLY SEATED, SEATED CORRECTLY AND PERFORMED GOOD LAMP TEST IAW AMM 33-21-00-960-801.SDR SWAA2025110327053Connector · disconnectedSEVERAL RT & LT OVERHEAD STOWAGE BULLNOSE EMERGENCY EXIT LIGHTS INOPERATIVE. RECONNECTED CONNECTOR D13018 TO EMERGENCY LIGHT POWER SUPPLY M2335 IAW AMM 33-51-06-960-806 AND PERFORMED SATISFACTORY OPS TEST IAW AMM 33-51-00-710-801.SDR JJBA20251103005Support · corrodedLH SILL BTW FR 60-65 FOUND CORRODED. LH SILL BTW FR 60-65 BLENDED AND FOUND OUT OF LIMIT. LH SILL BTW FR 60-65 REPLACED WITH NEW PART.SDR SWAA2025103126902Battery Pack · inoperativeFWD LEFT OUTSIDE OVERWING EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED EMERGENCY BATTERY PACK AND PERFORMED GOOD OPS CHECK IAW AMM 33-51-06-960-805. REMOVED AND REPLACED 1 EA FWD LEFT OUTSIDE OWE LIGHT ASSEMBLY CONTACT PN 81114-17201 IAW AMM 33-51-04-960SDR SWAA2025103126906Doubler · damagedEGPR DOOR CUTOUT LOWER SECTION HAS PIECE OF DOUBLER MISSING. ACCOMPLISHED REPAIR ON EGPR ACCESS DOOR SURROUND DOUBLER LOWER LANDING IAW SRM 53-10-15-2R-4.SDR AALA202510312748Fitting · damagedAIRCRAFT IN BASE MAINTENANCE: DUE TO THE MAJOR REPAIR BEING ACCOMPLISHED ON THE FLIGHT DECK CENTER WINDSHIELD FRAMING THE LOWER CONTINUITY FITTING AT FR 1 AND Y0 MUST BE REPLACED PER INSTRUCTIONS OUTLINED IN EA 367511. REPLACED LOWER CONTINUITY FITTING PER EA SDR HNAA2025103100732Floor Support · crackedCTR OMEGA BEAM SUPPORT ANGLE CRACKED AT FR1-20. RAR ANGLE IAW SRM 51-40-02SDR AALA202510302257Hinge 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 SCNA20251030417Support Beam · damagedGROUND CREW FOUND HP AIR DOOR PARTIALLY HANGING. LATCH AND LANDING DAMAGED. PERFORMED PERMANENT REPAIR ON WING CENTOR SECTION LWR SUPPORT BEAM LWR CHORD AT RBL 40.875 IAW B-737 SRM 50-10-13-2R-3. REV24 10. REMOVED & REPLACED DOUBLE ASSY ITEM:149A7244IAATSMROSDR ASAA2025102261894Power Supply · inoperativeBATERY PACK CAPACITY CK FAILED AT FWD ENTRY LT, AFT ENTRY LT, AND 17-23 ROWS LOCATION. SRXR430X. GROUNDED - YES. REMOVED AND REPLACED BATTERY POWER SUPPLY AT M1671 AND BATTERY PACKS AT 1673, AND M1675 FED LT AND AFT LT AND PERFORMED OPS CHECK TESTED GOOD IAW ASDR ASAA2025102261893Power Supply · inoperativeBATERY PACK CAPACITY CK FAILED AT FWD ENTRY LT, AFT ENTRY LT, AND 17-23 ROWS LOCATION. SRXR430X. GROUNDED - YES. REMOVED AND REPLACED BATTERY POWER SUPPLY AT M1671 AND BATTERY PACKS AT 1673, AND M1675 FED LT AND AFT LT AND PERFORMED OPS CHECK TESTED GOOD IAW BSDR ASAA2025102261892Power Supply · inoperativeBATERY PACK CAPACITY CK FAILED AT FWD ENTRY L/H, AFT ENTRY LT, AND 17-23 ROWS LOCATION. SRXR430X. GROUNDED - YES. REMOVED AND REPLACED BATTERY POWER SUPPLY AT M1671 AND BATTERY PACKS AT 1673, AND M1675 FED LH AND AFT LH AND PERFORMED OPS CHECK TESTED GOOD IAW