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 DALA2025062604774B-Nut · looseSHIP 3250. TWO FLT ATTENDANTS REPORTED DIRTY SOCK SMELL IN AFT CABIN ROW 31 TO AFT GALLEY. DISSIPATED ON ITS OWN AS WERE ANALYZING IT. C/A: C/W WORK CARDS 7900-2001, 0550-2002, AND 2100-2007. FOUND LOOSE B-NUT ON HYDRAULIC LINE AND RESECURED. NO FURTHER LEAKSDR JR2R2025062802Shear Tie · corrodedSHEAR TIE CORRODED AT FR85 BETWEEN STR28R AND STR29R. REPLACEDSDR JR2R2025062679Shear Tie · corrodedSHEAR TIE CORRODED AT FR86 BETWEEN STR28R AND STR29R. REPLACEDSDR JR2R20250626796Shear Tie · corrodedSHEAR TIE CORRODED AT FR86 BETWEEN STR27L AND STR28L. REPLACEDSDR F3LA202506260260Power Supply · no testFAULT HAPPENED DURING A SCHEDULED RON HEAVY CHECK. NO DELAY OCCURRED. LP489069 #3 EPSU 12WL FAULT. REMOVED EPSU POWER SUPPLY 12WL AND INSTALLED NEW ONE PER REFERENCE AMM 33-51-38-000-01-A AND 33-51-38-400-001-A OPS CHECK GOOD.SDR 2025FA0000427Flapper Valve · crackedON APPROACH CARBURETOR HEAT WAS APPLIED AND THE ENGINE IMMEDIATELY LOST POWER BUT DID NOT STOP RUNNING. THE PILOT ATTEMPTED TO DE-SELECT THE CARBURETOR HEAT AND THE LOSS OF POWER PERSISTED. THE AIRCRAFT WAS ABOUT 2300 FEET MSL AND 2 NM FROM THE RUNWAY. THE AIRSDR 2026FA0000199Impulse Coupling · destroyedI HEARD THE ENGINE BACKFIRE A FEW TIMES DURING TAKEOFF/INITIAL CLIMB OUT AROUND 6/20/2025. PLANE WAS BROUGHT TO MAINTENANCE 6/25/2025 FOR REPORTS OF INABILITY TO START THE RH ENGINE. AFTER MULTIPLE STARTING ATTEMPTS, A VISUAL INSPECTION WAS CONDUCTED ON THE ENSDR COEA2025103003919Deflector · puncturedWO 264878 NR 500052 HEAVY CHECK COE/MAJOR REPAIR DISCREPANCY: L/H OUTBOARD FLAP DEFLECTOR LEADING EDGE HAS PUNCTURE JUST INBOARD OF THE OUTBOARD MOST CAM GUIDE. CORRECTIVE ACTION: REPAIRED PER SRAS ES_00266312_01...26012 ISSUE A, DATED 9/5/2025.SDR 2025F00244Bearing · misinstalledON 25TH JUNE 2025 DURING A TEARDOWN INVESTIGATION AND JOINT REVIEW MEETING BETWEEN AIRBUS, SINGAPORE AIRLINES, PARKER AND ACE SERVICES OF A SUBJECT EDP AT THE PARKER HSD IT WAS SUGGESTED AN ENGINE DRIVEN PUMP HAD AN INCORRECTLY INSTALLED SUBASSEMBLY JOURNAL BESDR AALA202509035981Window Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION FOUND ON LOWER RADIUS OF THE WINDSHIELD CENTER POST LOWER ATTACHMENT AREA INTERNAL SIDE LH. CRACK L= 0.098 INCH. MAINTENANCE PERFORMED TIME LIMITED REPAIR OF MIRROR FITTING REPAIR LH LOC ON CENTER WINDSHIELD FRAMESDR AALA202509032061Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION FOUND ON CONTINUITY FITTING OF THE WINDSHIELD LOWER ATTACHMENT AREA INTERNAL SIDE RH. CRACK L= 0.157 INCH. MAINTENANCE D5348004121101.SDR AALA202509039074Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION FOUND ON LOWER RADIUS OF THE WINDSHIELD CENTER POST LOWER ATTACHMENT AREA INTERNAL SIDE RH. CRACK L= 0.197 INCH. MAINTENANCE PERFORMED TIME LIMITED REPAIR OF MIRROR FITTING REPAIR RH LOC ON CENTER WINDSHIELD FRAMESDR AALA202509023860Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION FOUND ON CONTINUITY FITTING OF THE WINDSHIELD LOWER ATTACHMENT AREA INTERNAL SIDE LH. CRACK L= 0.157 INCH. MAINTENANCE PERFORMED TIME LIMITED REPAIR ( REPLACED CONTINUITY FITTING) WINDSHIELD LOWER ATTACHMENT AREA SDR SWAA2025073185555Attach Angle · corrodedCORROSION AFT CARGO BAY ATTACH ANGLE UNDER SHIELD, HAS MULTIPLE AREAS UNDER NUT PLATES BS 767 TO BS 787, RBL21, WL156. CORROSION ON AFT CARGO BAY ATTACH ANGLE UNDER SHIELD FOUND TO BE OUT OF LIMITS DUE TO NO LIMITS AS GIVEN IN SRM. REMOVED, REPLACED, & INSSDR SWAA2025073085414Web · crackedCRACK ON WEB LOCATED DEFLECTION CONTROL RIB AREA AT LEVEL ORSS 261 AT LT WING. REPLACED WEB LOCATED DEFLECTION CONTROL RIB AREA AT LEVEL ORSS 261 AT LT WING IAW SRM 51-10-02, SRM 51-40-02, DWG: 115A2512, SHEET 14, REV A.SDR SWAA2025073085415Angle · crackedCRACK ON ANGLE LOCATED DEFLECTION CONTROL RIB AREA AT LEVEL ORSS 261 AT RT WING. REPLACED WEB AND FASTENERS LOCATED DEFLECTION CONTROL RIB AREA AT LEVEL ORSS 261 AT RT WING IAW SRM 51-40-02, SRM 51-10-02, ITEM 9, AND DWG 115A2900, SHEET 1, REV E.SDR SWAA2025072985416Floorbeam · corrodedCORROSION FLOOR STRUCTURE FLOOR BEAM LOCATED BS 986.5 AND RBL 43 WL 208.1 AT AFT GALLEY AREA. PERFORMED REPAIR FLOOR STRUCTURE FLOOR BEAM LOCATED BS 986.5 AND RBL 43 WL 208.1 AT AFT GALLEY AREA IAW SRM 53-70-51-2R-6 REPAIR 6.SDR SWAA2025072985369Floor Panel · delaminatedPASSENGER CABIN FLOOR PANEL 241TF HAS DELAMINATION. REMOVED CABIN FLOOR PANEL 241TF IAW AMM 53-21-00-000-801. REPAIRED AND REINSTALLED FLOOR PANEL 241TF PER AMM 53-21-00-400-801.SDR SWAA2025072985368Floor Panel · delaminatedPASSENGER CABIN FLOOR PANEL 241SF HAS DELAMINATION . REMOVED CABIN FLOOR PANEL 241SF IAW AMM 53-21-00-000-801. DUE TO THE EXTENT OF DAMAGE; REPLACED PASSENGER CABIN FLOOR PANEL 241SF IAW SRM 51-10-02-0G-0 PARA 9 AND AIPC 53-21-00-22 ITEM 121.SDR SWAA2025072985365Floor Panel · delaminatedPASSENGER CABIN FLOOR PANEL 242AF HAS DELAMINATION. REPLACED WITH A SERVICEABLE FLOOR PANEL PER SRM 51-10-02-0G-0 PARA 9.A.1 DUE TO AMOUNT OF ALL DAMAGE.SDR SWAA2025072985366Floor Panel · delaminatedPASSENGER CABIN FLOOR PANEL 241BF HAS DELAMINATION. DUE TO THE EXTENT OF DAMAGE, REPLACED THE FLOOR PANEL 241BF IAW SRM 51-10-02-0G-0 PARA 9 AND AIPC 53-21-00-42A ITEM 65.SDR SWAA2025072985556Support Plate · corrodedCORROSION FWD CARGO BAY LT FLOOR TO SIDEWALL SUPPORT PLATE MULTIPLE AREAS AROUND NUT PLATE HOLES BS 400 TO BS 500D LBL22 WL156, FOUND TO BE OUT OF LIMITS. REMOVED; REPLACED AND INSTALLED NEW L/H FLOOR TO SIDEWALL SUPPORT PLATE IAW SRM 51-40-02-0G-0 AND DWG 143SDR SWAA2025072985553Support Plate · corrodedCORROSION AFT CARGO BAY L/H FLOOR TO SIDEWALL SUPPORT PLATE MULTIPLE AREAS AROUND NUT PLATE HOLES BS727B TO BS767 LBL22 WL156. EVALUATED; LOCATED; DRILLED; REMOVED AND REPLACED AFT CARGO BAY L/H FLOOR TO SIDEWALL SUPPORT PLATE IAW SRM 51-40-02-0G-0; SRM 51-40SDR SWAA2025072985554Support Plate · corrodedCORROSION AFT CARGO BAY R/H FLOOR TO SIDEWALL SUPPORT PLATE HAS MULTIPLE AREAS AROUND NUT PLATE HOLES BS727B TO BS767 RBL22 WL156, FOUND TO BE OUT OF LIMITS. REMOVED; REPLACED; AND INSTALLED NEW FLOOR TO SIDEWALL SUPPORT PLATE IAW SRM 51-40-02-0G-0 AND DWG 14SDR SWAA2025072985557Shield · corrodedCORROSION AFT CARGO BAY SHIELD FWD OF CARGO DOOR AROUND MULTIPLE NUT PLATE HOLES BS767+3 TO BS794 RBL22 WL156, FOUND TO BE OUT OF LIMITS DUE TO NO LIMITS ARE GIVEN IN THE SRM. REMOVED; REPLACED AND INSTALLED NEW SHIELD IAW SRM 51-40-02-0G-0; AND DWG 146A0081SDR SWAA2025072985558Strap · corrodedCORROSION AFT CARGO BAY ON TIE STRAP BS 787+16, RBL 20, WL 156, FOUND TO BE OUT OF LIMITS. REMOVED; REPLACED AND INSTALLED NEW TIE STRAP IAW SRM 51-40-02-0G-0; DWG 146A8340 REV -, DWG 146A0081, REV A, AND DWG 146A8120, REV -.SDR SWAA2025072985356Attach Angle · crackedLANDING GEAR MANUAL EXTENSION CONTROL DRUM BOX ATTACH ANGLE CRACKED AT BS 253, RBL 7, WL 207. REMOVED AND REPLACED LANDING GEAR MANUAL EXTENSION CONTROL DRUM ATTACH ANGLE IAW SRM 51-40-02-0G-0 AND DWG 141A0631 REV D, DWG 141A5100 REV C.SDR SWAA2025072985560Strap · corrodedCORROSION ON STRAP AT BS719; RBL66; WL203. REMOVED AND TREATED PER EA 25-153-01775-WIP1; TASK ID TTG8Q013HMEX; AND WIP2; TASK ID TTG8Q013QUEY.SDR SWAA2025072985561Strap · corrodedCORROSION ON STRAP AT MID CABIN BS696 LBL66 WL203. IAW EA 25-153-01786; THE REWORK IS ACCEPTABLE AS A CONTINUE-IN-SERVICE CONDITION WITHOUT REPETITIVE INSPECTIONS AND NO TERMINATING ACTION REQUIREMENTS.SDR SWAA2025072985562Attach Angle · crackedCRACKED ATTACH ANGLE AT MID CABIN BS 691, RBL1, WL206. REMOVED, FABRICATED, AND REPLACED ATTACH ANGLE IAW SRM 51-10-02-0G-0, SRM 51-40-02-0G-0, BOEING 111A6000 REV -, DWG 273A9112, REV -, DWG 273A9112, REV H.SDR SWAA2025072985125Panel · debondedPANEL 193AR OUTER SKIN IS DISBONDED. REPAIRED IAW SRM 51-70-05-2R-4.SDR SWAA2025072985127Panel · crackedRT HORIZ STAB LEADING EDGE PNL 341B 5TH RIB O/B FROM I/B END CRACKED.<[01] REMOVED AND REPLACED 5TH RIB O/B FROM I/B END OF RT HORIZ. L/E PANEL 341B IAW SRM 51-40-02-0G-0 PARA.4.;[02] VERIFIEDSDR IPXA2025072108549Stringer · crackedMAJOR REPAIR, STRINGER CRACKED, AFT SIDE OF BS 1660, S11R. REPAIRED DAMAGED STRINGER IAW EO-94461, REQ 1, REV 1.SDR SWAA2025072285621Access Panel · crackedCRACK SEAL - PLATE ACCESS PANEL 343AT AT RT HORIZONTAL STAB. REPLACED SEAL - PLATE ACCESS PANEL 343AT AT RT HORIZONTAL STAB IAW B737-700 SRM 51-10-02 ITEM 9 AND SRM 51-40-02.AND DWG 186A3101 SHEET 13 REV.C. LENGTH OF CRACK IS L:0.554.SDR AALA202507226649Handle · excess playAIRCRAFT IN BASE MAINTENANCE, R1 DOOR HANDLE MECHANISM HAS EXCESSIVE PLAY ADJUSTED HORIZONTAL CONTROL ROD TO CORRECT EXCESSIVE HANDLE PLAY, OPS CHECK GOOD. AMM 52-41-00.SDR SIMA20250625001Seal Rest · corrodedSSI# 53-21-009 FWD CARGO DOOR CUTOUT FWD CORNER SEAL DEPRESSOR IS GOUGED ON EDGES AND HAS CORROSION AT NUT PLATE HOLE. (MAJOR REPAIR) (LEVEL 2 CORROSION). RAR THE FWD CARGO DOOR CUTOUT FWD CORNER SEAL DEPRESSOR IAW ERJ 175 AMM 20-10-01.SDR CALA2025071706648Shear Plate · corrodedLEFT SHEAR PLATE SUPPORT (FR.69-70) CORRODED. REMOVED AND REPLACED LT SHEAR PLATE SUPPORT FR69-70 IAW SRM 51-42-11.SDR SWIA202507150625Seat Track · corrodedRH FLOOR SEAT TRACK BEAM HAS CORROSION AT FR 17 & Y+ 10 (C-CHECK RO 07/13/2025)REMOVED AND REPLACED RH FLOOR SEAT TRACK AT FR 17 & Y=+10 PER E175 SRM 51-40-08. WEIGHT AND BALANCE IS NOT AFFECTED BY REPAIR. NO FURTHER ACTION REQUIRED.SDR SWAA2025071585138Scuff Plate · crackedCRACK ON CORNER SCUFF PLATE FWD POSITION AT FWD CARGO COMPARTMENT. REPAIRED CORNER SCUFF PLATE FWD POSITION AT FWD CARGO COMPARTMENT I.A.W. BOEING 737-700 SRM 53-30-15-2R-1 REPAIR 1; AND BAC 5975.SDR SWAA2025071585571Plate · crackedCRACK CORRUGATED PLATE TRAILING EDGE LOCATED ORSS275 AT RT WING. REPLACED CORRUGATED PLATE TRAILING EDGE LOCATED ORSS275 AT RT WING IAW SRM B737-700 51-10-02 SRM 51-40-02 AND DRAWING 115A 2001; SHEET 29; REV.-. MEASURE OF CRACK IS: 1.313.SDR SWAA2025071585572Plate · crackedCRACK CORRUGATED PLATE TRAILING EDGE LOCATED ORSS236 AT LT WING 2025-390053 <[01]. REPLACED CORRUGATED PLATE AND FASTENERS LOCATED ORSS236 AT LT WING IAW B737-700 SRM 51-40-02 AND DWG: 115A2001 SHEET: 49; REV: - TOOK LENGTH OF CRACK ON CORRUGATED IS 0.765 INCHSDR SWAA2025071585370Angle · crackedCRACK ON ANGLE LOCATED ACCESS PANEL 651FB TRAILING EDGE AT RT WING 2025-390049 <[01]. REPLACED ANGLE LOCATED ON ACCESS PANEL 651FB TRAILING EDGE AT RT WING IAW B737-700 SRM 51-40-02 AND DWG 115A2710; SHEET 6 REV: B. LENGTH OF CRACK IS: 0.371? TOOL USED CALIPERSDR SWAA2025071585570Plate · crackedCRACK CORRUGATED PLATE TRAILING EDGE LOCATED ORSS261 AT RT WING 2025-390051<[01]. REPLACED CORRUGATED PLATE TRAILING EDGE LOCATED ORSS261 AT RT WING IAW SRM B737-700 51-10-02; SRM B737-700 51-40-02 AND DRAWING # 115A 2001; SHEET 29; REV.-. MEASURE OF CRACK ISSDR CALA2025071506571Service Panel · corroded(SUPPORT TASK) AFT CARGO COMPARTMENT,WASTE SERVICE PAN HAS CORROSION.SDR CALA2025071506570Floor Support · crackedFOUND FLOOR SUPPORT INTERCOSTAL T CHORD CRACKED AT LBL 14 BETWEEN STA 380 AND 400 REF AAR N/R 9983624 ESFR INFORMATION ENTERED.SDR 2025FA0000482Stiffener · crackedRIGHT WING FWD LWR I/B SKIN. FWD STIFFENER CRACKED.SDR 2025FA0000481Stiffener · crackedRIGHT WING FWD LWR I/B SKIN. AFT STIFFENER CRACKED.SDR BJNA202506250001Window · delaminatedAT 38000, L3 WINDOW DELAMINATED + SEPERATED FROM THE INNER PANE. REMOVED AND REPLACED L3 WINDOW PER AMM 56-11-21. LEAK CHK GOOD.SDR AALA202507099554Wire Harness · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO PHX DUE TO THE FLIGHT CREW REPORTING THAT ENGINE 2 EGT OVER LIMIT ON TAKEOFF. THE FLIGHT CREW SHUT DOWN THE ENGINE AND LANDED SAFELY AT PHX WHERE IT TAXIED TO THE GATE UNDER ITS OWN SDR AALA202507095688Wire Harness · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO PHX DUE TO THE FLIGHT CREW REPORTING THAT ENGINE 2 EGT OVER LIMIT ON TAKEOFF. THE FLIGHT CREW SHUT DOWN THE ENGINE AND LANDED SAFELY AT PHX WHERE IT TAXIED TO THE GATE UNDER ITS OWN