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 SWAA2025092611539Scuff Plate · crackedCRACK FWD CORNER SCUFF PLATE AT FWD CARGO COMPARTMENT. REPAIRED THE FWD CORNER SCUFF PLATE AT FWD CARGO COMPARTMENT IAW BOEING SRM 53-30-15-2R-1 REPAIR 1 AND BAC 5975.SDR SWAA2025092611931Access Panel · elongatedELONGATED HOLES ON ACCESS PANEL 193B BODY FAIRING AT FUSELAGE EXTERIOR. REPAIRED ACCESS PANEL 193B IAW SRM 51-70-05-2R-8 REPAIR 8.SDR IPXA2025092525306Stringer · crackedSTRINGER CRACKED, AFT SIDE OF BS 2360, BS 2377 AT S5R (LEVEL 2) PERFORM EO-95265-REQ1 REV.1 AND EI F2025A53M-2037 REV 2.SDR IPXA2025092525301Stringer · crackedSTRINGER CRACK, AFT SIDE OF BS 2360, BS 2377 TO BS 2380 AT S-5L (LEVEL 2). PERFORM EO-95266-REQ1 REV 1 AND EI F2025A53M-2035 REV 2.SDR AALA202509253226Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE, CRACK IN CENTER SECTION REAR SPAR VAPOR BARRIER ATTACH ANGLE AT BS 663.5, LBL 28. REPAIRED IAW SRM 57-10-10-2R-5 AND AARD 51-00-05-1.SDR SWAA2025092411425Battery Pack · inoperativeRIGHT OVERWING EMERGENCY LIGHT BATTERY PACK AT BS 659 FOUND INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK IAW MM 33-51-06. ACCOMPLISHED OPS CHECK IAW AMM 33-51-06. NO FAULTS NOTED.SDR IPXA2025091824925Stringer · crackedSTRINGER CRACK, FWD SIDE OF STA 2598 S-8L LEVEL 2. (REPAIR). VERIFY REPAIR IS ACCOMPLISHED PER GMM 04.02.01.15 REQUIREMENTS. PAPER FINAL COMPLETED. ACCOMPLISHED REPAIR I.A.W UPS EO-95140-REQ1 REV.1 AND EGAT EI NO.F2025A53M-2076 REV.0 AND SRM 53-80-03-2R-2 REV.SDR SWAA2025091911824Battery Pack · inoperativeLT AND RT OVERWING EMERGENCY LIGHTS INOP. REMOVED AND REPLACED PER AMM 33-51-06-960-805-NG.SDR SWAA2025091911695Handle · unsecureCR RR L1 DOOR ASSIST HANDLE NEEDS SECURED. SECURED L1 DOOR ASSIST HANDLE IAW BOEING 737-800 AMM 52-11-31-400-802.SDR SWAA2025091911694Handle · unsecureCR RR R2 DOOR ASSIST HANDLE NEEDS SECURED. SECURED R2 DOOR ASSIST HANDLE IAW BOEING 737-800 AMM 52-41-31-400-802.SDR SWAA2025091911701Handle · looseR1 DOOR LINER ASSIST HANDLE LOOSE. SECURED R1 ASSIST HANDLE IAW B737-800 AMM 52-41-31.SDR SWAA2025091911697Girt Bar · unsecureCR RR L2 DOOR AFT GIRT BAR FITTING NEEDS SECURED. TOP TWO FASTENERS ON GIRT BAR FITTING WERE LOOSE. RE-TORQUED FASTENERS IAW B737-800 AMM 20-50-11-910-801.SDR AALA202509199818Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN REAR SPAR VAPOR BARRIER ATTACH ANGLE LOCATED AT BS 663.5, RBL 2. REPLACED ANGLE PER SRM 57-10-10-2R-5.SDR JJBA20250918029Shear Tie · crackedCFII, SHEAR CLIP AT FR24 BTW STR 15R-16R FOUND CRACKED. CFII AT FR24 BTW STR 15R-16R SHEAR CLIP REMOVED FOR REPLACEMENT. CFII AT FR24 BTW STR 15R-16R SHEAR CLIP REPLACEDSDR JJBA20250918028Shear Tie · crackedCFII, SHEAR CLIP AT FR26 BTW STR 15R-16R FOUND CRACKED. CFII AT FR26 BTW STR 15R-16R SHEAR CLIP REMOVED FOR REPLACEMENT. CFII AT FR26 BTW STR 15R-16R SHEAR CLIP REPLACEDSDR JJBA20250918027Shear Tie · crackedCFII, SHEAR CLIP AT FR27 BTW STR 15R-16R FOUND CRACKED. CFII AT FR27 BTW STR 15R-16R SHEAR CLIP REMOVED FOR REPLACEMENT. CFII AT FR27 BTW STR 15R-16R SHEAR CLIP REPLACEDSDR CALA2025091708994Plate · corrodedAFT PIT CORROSION AT 38R PROFILE FR 52. REMOVED AND REPLACED CORRODED PROFILE PANEL AT FR43-FR52A IAW SRM 51-72-11.SDR SWAA2025091611581Handle · looseCR RR R1 DOOR ASSIST HANDLE NEEDS SECURED. SECURED R1 DOOR ASSIST HANDLE IAW AMM 25-21-35-420-801.SDR SWAA2025091511583Fitting · looseL2 DOOR AFT GIRT BAR FITTING NEEDS SECURED. SECURED L2 AFT GIRT BAR FITTING IAW AMM 25-66-02-201, AND 20-50-11-910-801.SDR SWAA2025091511584Handle · looseL1 DOOR ASSIST HANDLE NEEDS SECURED. SECURED L1 DOOR ASSIST HANDLE IAW AMM SUBTASK 52-11-31-020-011.SDR SWAA2025091511586Handle · looseL2 DOOR AIRFRAME SIDE ASSIST HANDLE NEEDS SECURED. SECURED L2 DOOR AIRFRAME SIDE ASSIST HANDLE IAW AMM SUBTASK 52-13-31-020-008.SDR SWAA2025091511582Handle · looseR2 DOOR AIRFRAME SIDE ASSIST HANDLE NEEDS SECURED. SECURED R2 DOOR AIRFRAME SIDE ASSIST HANDLE IAW AMM SUBTASK 52-13-31-020-008..SDR IXXA20250915001Link · gougedFWD LOWER LOBE CARGO DOOR FWD UPPER ACTUATOR ARM ON FWD SIDE HAS SEVERAL GOUGES.SDR AALA202509157875Seat Track · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CABIN FLOOR BEAM-SEAT TRACK AT FR 16 AND +Y1292. REPLACED BEAM-SEAT TRACK PER SRM 51-42-11.SDR AALA202509150588Relay · inoperativeAIRCRAFT WAS NOT GROUNDED: LEFT CENTER TANK FUEL PUMP LOW PRESSURE LIGHT ILLUMINATED IN LEVEL FLIGHT. REPLACED LEFT POWER SWITCH RELAY PER SWPM 20-81-13. OPERATIONAL CHECK GOOD.SDR CALA2025091508886Web · corrodedAFT CABIN STA 986 RBL 55 WEB UNDER R/H INNER CHORD HAS EXFOLIATED CORROSION. REMOVED AND REPLACED WEB AT AFT CABIN STA 986 RBL 55 UNDER R/H INNER CHORD IAW SRM 51-40-02-G0-0 AND DWG 147A8501 SHEET 25.SDR ABXA20250905221Warning Light · false activationBULK CARGO DOOR EICAS INTERMITTENT ENTRY DOOR, EMER DOOR & CARGO DOOR DISCREET LIGHTS INTERMITTENT FLASHING. PERFORMED CABIN PRESSURATION IAW B767 AMM 05-51-24. PSEU BITE IAW B767 FIM 32-09 FT 803 AND DOOR WARNING SYSTEM TEST IAW B767 AMM 52-71-00. NO FAULTS SDR SWAA2025091111980Sign · missingFWD LT EMERGENCY EXIT LWR EXIT SIGN COVER MISSING. REPLACED MISSING EXIT SIGN ON FWD LH EMERGENCY EXIT IAW SRM 51-40-02-0G-0.SDR DALA2025091106701Stowage Box · faultedWHEN TESTING CAPT FWD O2 MASK, AIRFLOW YELLOW INDICATOR WOULD ALWAYS SHOW ON STOWAGE BOX. R & R CAPT FWD O2 MASK STOWAGE BOX PER A320 AMM 35-12. NO LEAKS NOTED, OPS CK NORMAL. (LP: 7587846)SDR JJBA20250911016Gusset · corrodedCENTER OMEGA BEAM GUSSET FROM FRAME 22 TO FRAME 27 IS CORRODED. CENTER OMEGA BEAM GUSSET AT FRAME 22 - FRAME 27 FOUND TO BE OUT OF LIMITS. REMOVED AND REPLACED CENTER OMEGA BEAM GUSSET.SDR JJBA20250911015Gusset · corrodedCORROSION ON GUSSET AT FRAME 16 RBL 4. REMOVED CORROSION ON GUSSET AT FRAME 16 RBL 4 GUSSET FOUND TO BE OUT OF LIMITS. REMOVED AND REPLACED GUSSET FROM FRAME 16 RBL 4.SDR JJBA20250911014Gusset · corrodedGUSSET AT FRM 20 RBL 19 IS CORRODED. REMOVED CORROSION FROM FRAME 20 RBL 19, FOUND TO BE OUT OF LIMITS. REMOVED AND REPLACED GUSSET.SDR JJBA20250911010Skin · crackedEXTERNAL REAR FUSELAGE SKIN, DENT FOUND 8 INCHES AFT FRAME 77, BTW STR 14L-15L. REPAIR DOUBLER ON LH REAR FUSE II SKIN, BTW FR 77-80 AND BTW STR 13L-16LSDR JJBA20250911009Skin · crackedFF1 RH SKIN CRACKED AT FR 4 AND EDGE OF SKIN AT NLG CUTOUT. REPAIR DOUBLER ON RH FWD FUSE I SKIN, AT FR 4 AND ON LOWER EDGE.SDR HNAA2025091100603Skin · damagedDMT 17 PERMANENT REPAIR OF LIGHTENING STRIKE DAMAGE PER EMB SRM 53-22-01 ETD2023-145-008587. FRAM 26-FRAM 27, STGR 20L- STGR 21.C/W PERMANENT REPAIR IAW EMB 145 SRM 53-22-01 REF ITEM 2, FIG 201, SHEET 1, REPAIR TYPE "A".SDR AALA202509101026Lamp · inoperativeAIRCRAFT IN BASE MAINTENANCE: R1 EXTERIOR SLIDE EMERGENCY LIGHT IS NOT WORKING. RELAMPED R1 EXTERIOR SLIDE EMERGENCY LIGHT. PER B737NG AMM 33-51-04-960-801. OPERATIONAL TEST GOOD. PER B737NG AMM 33-51-04-960-801.SDR AALA202509108148Light · inoperativeAIRCRAFT IN BASE MAINTENANCE: SEAT 5H AFT EMERGENCY LIGHT INOP MAINTENANCE REPLACED THE FLOOR PROXIMITY EMERGENCY LIGHT ON THE SEAT IAW AMM 33-51-05.SDR CALA2025091008717Floorbeam · crackedMID PASSENGER COMPARTMENT FLOOR SUPPORT BRACKET FOUND CRACKED AT BS 540 BETWEEN BL 0 AND RBL 24.75. REMOVED AND INSTALLED NEW MID PASSENGER COMPARTMENT FLOOR SUPPORT BRACKET AT STA 540 BETWEEN BL 0 AND RBL 24.75 PER SRM 51-40-02-0G-0 AND DWG # 143A0060. FLOSDR CALA2025091008712Floorbeam · corrodedMAIN CABIN FLOORBEAM STA 947 RBL 60 CORRODED ON UPPER SURFACE. REPAIRED FLOORBEAM AT STA 947 RBL 60 IAW B737-800 SRM 53-70-51- 2R-5. REMOVED CORROSION IAW SRM 51-10-02 ORIG THICKNESS .180" DEPTH OF BLEND .080 AND MATERIAL REMAINING IS .100". FOUND TO BE OUSDR ASAA2025090560696Lens · brokenFIGHT ATT REPORTED THE EMERG EXIT COVER SIGN 16DEF BROKEN. GROUNDED - YES. VERIFIED EMERG EXIT SIGN BROKEN 16DEF REMOVED AND REPLACED EMERG EXIT COVER REF AMM 33-51-01, CHECK GOOD.SDR SWAA2025090912055O-Ring · leakingAPU AIR CAUSES SMOKE AND VAPOR TO FILL THE CABIN. FOUND APU OIL COOLER INPUT-OUTPUT LINES O-RINGS DAMAGED. REPLACED APU OIL COOLER LINE O-RINGS PER AMM 49-91-41. A/COK FOR SERVICE.SDR HALA20250908049Battery Pack · inoperativeCAT WALK EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED BATTERY ASSY. B5-260 PER AMM 33-51-03. OPERATIONAL CHECKED OK.SDR FDEA202509051646Longeron Splice · damagedDAMAGED LONGERON SPLICE AT STATION 1811 AND LONGERON 36 REWORKED DAMAGED SPLICES IAW 51-21-10.SDR FDEA202509051645Shear Tie · damagedDAMAGED SHEAR TIE AT STA 1801 AND LONGERONS 37-39. REMOVED AND REPLACED THE SHEAR TIE AT STATION 1801 AND LONGERONS 37-39 IN REF TO SRM 51-33-01-0GSDR DALA2025090906666Access Panel · damagedIN REF NRC 124 AFTER CLEAN ELONGATED HOLE FOUND ON FUEL ACCESS PLATE 520 JB. FUEL ACCESS PLATE 520JB WAS REPAIRED PER ER/A 628967-14AD (1183419)SDR DALA2025090906646Oxygen Mask · inoperativeL4 LAVATORY OXYGEN MASK INOPERATIVE. REPLACED PSU ASSY IAW AMM 35-21. OK FOR SERVICE.SDR CALA2025090908676Window · looseAT FL320 AND 1 HOUR INTO FLT THE FO WINDOW STARTED A LOUD SQUEA L FLT CREW INDICATED R2 WINDOW TO BE THE ISSUE. WINDOW INSPECTED AND FOUND OPERATION NORMAL, NO LIMITING DEFECTS NOTED WITH REF TO AMM 56-11-11-401. BULB SEAL AND WINDOW ASSY FRAME CLEANED (VERY SDR CALA2025090908673Indication Sys · malfunctionedWHEN GEAR RAISED ALL NORMAL INDICATIONS BUT SPEED TAPE STAYED AT 270 EVEN W/ GEAR CYCLED AFTER TAKEOFF, RAISED GEAR & THEN FLAPS PER NORMAL PROCEDURES. ALL INDICATORS NORMAL FOR GEAR & FLAPS SHOWING FULLY RAISED OR STOWED. HOWEVER THE SPEED TAPE WHEN RAISING FSDR CALA2025090908672Actuator · faultedSLATS DRIVE CAUTION PRIMARY AND SECONDARY SLAT DRIVES HAVE FAILED TO OPERATE, OR HAV E BEEN SHUT DOWN BECAUSE OF AN ASYMMETRY, SKEW/LOSS, DISAGREE, OR UNCOMMANDED MOTION. DB 27 FCM OPS (RT) DB 27 FCM OPS (LT) DB 27 FCM OPS (CENT). MESSAGE APPEARED AN HOUR INTSDR CALA2025090908670Access Panel · detachedNUMBER 2 ENGINE INBOARD BOTTOM ACESS PANEL POPPED OPEN IN FLIGHT FOUND #2 ENGINE IDG ACCESS DOOR OPEN, INSPECTED COWL AREA AND DOOR, NO DAMAGE, LATCHES OPERATE OK, SECURED PANEL.