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 SWAA2025072390002Angle · corrodedAFT CARGO LT ZEE ANGLE HAS CORROSION AROUND SEVERAL FASTENERS HOLES, BS 727A - 767. REMOVED CORROSION & VERIFIED WITH A 10X POWER MAGNIFYING GLASS IAW SRM 53-00-53-1A-2. EVALUATED REWORKED AREA LT BS 727A - 747+18' WITH ORIGINAL THICKNESS 0.040'; REMAINING TSDR SWAA2025072390003Angle · corrodedAFT CARGO RT ZEE ANGLE CORRODED AROUND SEVERAL FASTENERS HOLES, BETWEEN BS 727D - 767. REMOVED CORROSION & VERIFIED WITH A 10X POWER MAGNIFYING GLASS IAW SRM 53-00-53-1A-2. EVALUATED REWORKED AREA WITH ORIGINAL THICKNESS 0.040, REMAINING THICKNESS 0.033, LOSDR JJBA20250723088Support · crackedRH BAGGAGE DOOR MECHANISM LOWER SUPPORT AT STR 5 BTW FR 68-69 FOUND CRACKED. RH BAGGAGE DOOR MECHANISM LOWER SUPPORT AT STR 5 BTW FR 68-69 REMOVED AND REPLACEDSDR IPXA2025072257913Static Wick · corrodedLEFT ELEVATOR TIP STATIC WIC CONDUCTIVE PLATE HAS EVIDENCE OF CORROSION. AA026 INSP VERIFIED STEP 14 ADJUSTMENT OF THE ELEVATOR POSITION INDICATING SYSTEM IN REF B757 AMM 27-38-00-825-009. ADJUSTMENT GOOD. PERFORMED ELEVATOR POSITION INDICATING SYSTEM OPERATIOSDR ASAA2025071059507Power Supply · inoperativeEMERGENCY LIGHTS AT L/H FWD O/W DOOR THROUGH L/H SEAT ROW 4 AISLE INOP. GROUNDED - YES. REMOVED AND REPLACED POWER SUPPLY M2335 S/N 32826 IAW B737-NG AMM 33-51-06-960-806. OPS CHECK GOOD.SDR SWAA2025072190185Lens · inoperativeL/H #11 BIN EMERGENCY LIGHT NOT SEATED. INSTALLED NEW EMERGENCY AREA LIGHT LENS ON L/H #11 OVERHEAD STOW BIN IAW AMM 33-51-03-960-802.SDR JJBA20250721076Gusset · corrodedLH GUSSET BTW FR 59-61 FOUND CORRODED. LH GUSSET BTW FR 59-61 FOUND CORRODED OUT OF LIMIT. LH GUSSET BTW FR 59-61 REMOVED AND REPLACEDSDR JJBA20250721070Gusset · corrodedMIDDLE GUSSET BTW FR 59-61 FOUND CORRODED. MIDDLE GUSSET BTW FR 59-61 FOUND CORRODED OUT OF LIMITS. MIDDLE GUSSET BTW FR 59-61 REMOVED AND REPLACEDSDR JJBA20250721067Gusset · corrodedCENTER GUSSET BTW FR 59-61 FOUND CORRODED. CENTER GUSSET BTW FR 59-61 FOUND CORRODED OUT OF LIMIT. CENTER GUSSET BTW FR 59-61 HAS BEEN REMOVED AND REPLACEDSDR DALA2025072105470Frame · dented(LOG 1074950) DENT ON FRAME STA 500B AND BTW S25L TO S26L AT FWD CARGO COMP. DENT ON FRAME STA 500B AND BTW S25L TO S26L AT FWD CARGO COMP WAS REPAIRED PER B737-800 SRM 53-30-07-2R PROCEDURE 1.SDR JJBA20250721061Support · crackedBAGGAGE DOOR MECHANISM SUPPORT BTW FR 61-62 AND BTW STR 4R-5R FOUND CRACKED. AT FR61-62 BTW STR 4R-5R BAGGAGE DOOR MECHANISM SUPPORT REMOVED AND REPLACEDSDR SIMA20250710004Shear Tie · corrodedAFT CARGO BAY HAS CORROSION AT FR 85 & STR 27R-26R. (MAJOR REPAIR) (LEVEL 2 CORROSION). BLENDED SHEAR CLIP AT FR85 BETWEEN STR 27R AND STR 26R PER EMB 175 SRM 51-- 10-03. BLENDED AREA MEASURE (L: 2.00? W:- .50? D: .020?) CLIP IS BEYOND ALLOWABLE LIMITS PER EMBSDR SIMA20250710005Shear Tie · corrodedAFT CARGO BAY HAS CORROSION AT FR 86 & STR 28R-27R. (MAJOR REPAIR) (LEVEL 2 CORROSION). UPON EVALUATION SHEAR CLIP FOUND TO BE OUT OF LIMITS PER EMB 175 SRM 51-- 75-16 AND ETN-EJ-51-009.PART REQUIRES REPLACEMENT. REMOVED SHEAR CLIP ON AFT CARGO BAY AT FR86 BETSDR SIMA20250710003Shear Tie · corrodedSHEAR CLIP ON FRAME 86 CORRODED BETWEEN STRGR 29 AND 28 RT. (MAJOR REPAIR) (LEVEL 2 CORROSION). DISPLACED BRACKET ON AFT CARGO BAY AT FR 86 BETWEEN STR 29R AND 28RT PER EMB 175 SRM 51-40-08 REMOVED FAIRING ON EXTERIOR SKIN AT LWR AREA LOCATE ON FR86 BETWEEN STSDR SIMA20250710002Shear Tie · corrodedSHEAR CLIP ON FRAME 84 CORRODED BETWEEN STRGR 27 AND 26 RT. (MAJOR REPAIR) (LEVEL 2 CORROSION). BLENDED SHEAR CLIP AT FR84 BETWEEN STR 27R AND STR 26R PER EMB 175 SRM 51-10-03. BLENDED AREA MEASURE (L: 2.00" W:- .50" D: .015") CLIP IS BEYOND ALLOWABLE LIMITS PSDR SIMA20250710006Shear Tie · corrodedSHEAR CLIP ON FRAME 87 CORRODED BETWEEN STRGR 27 AND 26 RT. (MAJOR REPAIR) (LEVEL 2 CORROSION). AFTER EVALUATION SHEAR CLIP FOUND TO BE OUT OF LIMITS PER EMB 175 SRM 51-75-16 AND ETN-EJ-51-009.PART REQUI RES REPLACEMENT. REMOVED SHEAR CLIP ON AFT CARGO BAY ATSDR CALA2025072106799Actuator · faultyFROM TOP OF DESCENTTO LNDG SPOILERS EICAS FOUND SCM FAULT AND PCA 7 FAULT ON SCM 3 LEFT. PICS ATTACHED. EXTENSIVE HISTORY. SEE LOG PAGES 5541754 , 5505120 AND 5600698 FOR OPT TESTS OF SCM AND PCA 7.FOR VERIFICATION OF FAULTS, TEMPORARILY SWAPPED VERIFIED WORKISDR CALA2025072106743Window Frame · crackedFOUND CRACK AT THE LT SIDE NUMBER 3 WINDOW FRAME POST HOLE NO 2 3 AND 4 (HOLE NR 2 REPAIR PER EA5310-08195 REVISION B OPS 003) ( REF. AAR NR 1000043040) REPAIRED THE LH WINDOW #3 FRAME PART#141A8800-23 IAW EO#250203, REV P1, IR, ECRA 5310-08625. REPAIRED THE LSDR CALA2025072106742Window Frame · crackedFOUND DAMAGE CRACK AT THE RH SIDE NUMBER 3 WINDOW FRAME POST AT HOLE NO 4 DIRECTION 9 O'CLOCK, REF EA 5310-08195 REVISION B OPS 004 (REF. AAR NR 1000043039) REPAIRED THE RH WINDOW #3 FRAME 141A8800-24 IAW EO#250204, REV P1, IR, ECRA 5310-08626 ESFR HAS BEEN CRSDR CALA2025071806734Skin · corrodedCORROSION AT FWD CARGO DOOR CUTOUT AFT INTERNAL SKIN. ACCOMPLISHED REPAIR AT FWD CARGO DOOR SURROUND AFT EDGE BEARSTRAP IAW EC/RA 5330-07563.SDR CALA2025071806698Seat Track · corrodedFOUND CORROSION AT MAIN CABIN LT OTBD SEAT TRACK UPPER COWL LBL 45.5 BS 887 - 907. REMOVED AND REPLACED SEAT TRACK AT LBL 45.50 FROM STA 887 TO STA 927 PER SRM 51-40-02-0G-0 AND DWG 10N00633.SDR DALA2025071705408Bracket · misinstalledSHIP 3412 BONDING BRACKET WAS FOUND INSTALLED IN THE INCORRECT POSITION AT FRAME C63 BETWEEN STRINGER P2 AND P3, DRILL START DAMAGE WAS FOUND ON THE AFT SIDE OF FRAME C63 WEB BETWEEN STRINGER P2 AND P3. COMPLIED WITH ER/A 627672-14. (1074484).SDR DALA2025071705407Shear Tie · damagedSHIP 3415 , TOOLING DAMAGE WAS NOTICED AT FRAME 60 AND STR P1, FRAME 60 SHEAR CLIP DAMAGED. COMPLIED WITH ER/A 627689-14. (1074966).SDR SWAA2025071790026Handle · looseCR RR L1 DOOR ASSIST HANDLE NEEDS SECURED. SECURED L1 DOOR ASSIST HANDLES IAW AMM TASK 25-21-31-420-802.SDR SWAA2025071790027Handle · looseL2 AIRFRAMEDOOR ASSIST HANDLES NEED SECURED. SECURED L2 DOOR ASSIST HANDLES IAW AMM 25-21-25-420-801SDR SWAA2025071790028Handle · looseCR RR R1 DOOR ASSIST HANDLE NEEDS SECURED. SECURED R1 DOOR ASSIST HANDLE IAW B737-800 AMM 52-41-31.SDR AALA202507176048Light · dislodgedAIRCRAFT WAS NOT GROUNDED: 17D EMERGENCY LIGHT AT SEAT ASSY IS INOP. MAINTENANCE REPLACED 17D EMERGENCY LIGHT IAW SWFM 20-30-00.SDR AALA202507179372Engine · flamed outAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: FLAMEOUT OF ENGINE NUMBER 1 AFTER LEVELING OFF AT FL370. THERE WAS NO OTHER INDICATIONS THAN A "ROLL BACK" OF N1 AND COMMAND SYSTEM-A DISCONNECTING. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT SDR DALA2025071705385Elec Connector · disconnectedEMERGENCY ESCAPE PATH LIGHTS INOP AT SEATS 20B,23B, 25B, 31C, 35C, 37C, 39C. FOUND CONNECTOR J13 AT EMERGENCY LIGHT FLOOR DISCONNECT BOX IN SEAT ROW 22AB DISCONNECTED. RECONNECTED J13. OPS CHECK NORMAL. (LP# 8982003)SDR SCNA20250717265Skin · dentedFOUND DENT BETWEEN STA. 1006 AND 1013 BETWEEN STRINGERS 13L AND 14L DEPTH .160". DENT IS OUT OF LIMITS PER SRM 53-00-01 TABLE 2. NO CRACKS NOTED IN PAINT. REPAIRED DAMAGED FUSELAGE SKIN @ STA 1006 TO 1013, STR 13L TO 14L PER ER 25-02325 REV P1 AND ENG-53SCA-SDR JJBA20250716054Shear Tie · corrodedSHEAR CLIP FR 65 BTW STR 17L-16L CRACKED. SHEAR CLIP AT FR65 BTW STR 17L-16L REMOVED AND INSTALLEDSDR JJBA20250716051Bracket · corrodedCARGO DOOR CUT-OUT STRUCTURE, LH FR 65 AT FLOOR LEVEL BRACKET FOUND CORRODED. ON CARGO DOOR CUT-OUT STRUCTURE, LH FR 65 AT FLOOR LEVEL BRACKET REMOVED AND INSTALLEDSDR CALA2025071606634Elec Connector · looseDOOR AFT CARGO ECAM. PLACED AFT CARGO DOOR INDICATION ON MEL. VERIFIED AFT CARGO DOOR IS CLOSED AND LATCHED. OK TO CONTINUE. PLR SHOWS AFT CARGO DR SAFETY MECHANICAL PROXIMITY SENSOR (32WV) TGT POS, POSSIBLE SENSOR 32WV OR DOOR HANDLE LINKAGE MAY NEED ADJUSDR G1IA20200710094Motor · shortedAIR CONDITIONER QUIT BLOWING IN ROUTE TO HNL LOAD METER NOT SHOWING LOAD.SDR DALA2025071505330Girt Bar · unsecureSHIP 6710 ESCAPE SLIDE GIRT BAR ENGAGEMENT LIGHT/S/ 3L DOOR LIGHT INOP. CORRECTIVE ACTION: RESECURED 3L DOOR GIRT BAR FITTINGS REF B757 AMM 25-66. (1074433)SDR AALA202507154277Bolt · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT WING LEADING EDGE #9 SLAT TRACK FORWARD BOLT BETWEEN WS 9704 AND WS 10204, BETWEEN RIBS 18 AND 19. REPLACED BOLT PER AMM 27-84-66.SDR 2025FA0000497Turbine Wheel · shearedOVERTORQUE INSPECTION (117% FOR 1 SEC). THE PROP BOX AND ACCESSORY GEARBOX ASSEMBLIES WERE DISMANTLED, INSPECTED AND RE-ASSEMBLED IAW ROLLS ROYCE MANUAL INSTRUCTIONS. THE TURBINE SHAFT TO PINION GEAR COUPLING WAS INSPECTED WITH NO REJECTABLE FINDINGS. THEREFORSDR SWAA2025071490352Flashlight · no testCREW REPORTS FLIGHT DECK FLASHLIGHT NOT TESTING. R&R FLIGHT DECK FLASHLIGHT REF AMM 25-64-00 TEST GOODSDR SWAA2025071490353Switch · out of adjustDURING DESCENT; LEFT OVERWING LIGHT. FLIGHT DIRECTORS BLANKED ON APPROACH; PSEU LIGHT ON LANDING ROLL OUT. FOR LEFT OVERWING LIGHT AND PSEU LIGHT ON LANDING ROLL OUT; PERFORMED PSEU BITE TEST. FOUND FAULTS 52-72020 AND 52-72010. PERFORMED FIM TASKS 52-20 #80SDR R61A202507100031Fadec · failedENGINE 2 SHUTDOWN IN FLIGHT, AUTO RESTART SUCCESSFUL. DECLARED EMERGENCY, LANDED WITHOUT INCIDENT. REMOVED AND REPLACED E2 FADEC.SDR AALA202507149372Engine · flamed outAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: FLAMEOUT OF ENGINE NUMBER 1 AFTER LEVELING OFF AT FL370. THERE WAS NO OTHER INDICATIONS THAN A "ROLL BACK" OF N1 AND COMMAND SYSTEM-A DISCONNECTING. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT SDR SCNA20250714258Sensor · faultedDEFECT 801870: TRAILING EDGE FLAP ASYMMETRY RT FLAP INDICATOR SHOWS UP, LEFT FLAP INDICATOR SHOWS LESS THAN UP. - (EMERGENCY DECLARED) - RESOLUTION: FSEU BITE PROCEDURE INDICATED FLAP SKEW FAULT 27-53409. NO 28VAC WAS PRESENT AT PIN 2 OF #4 SKEW SENSOR . FOSDR DALA2025071405288Door · corrodedWASTE WATER ACCESS PANEL HAS CORROSION ON INTERNAL SURFACE. REMOVED AND REPLACE WASTE WATER SERVICE DOOR DUE TO EXCESSIVE CORROSION REF MON #2396842 AND ERA ERA 602016-14AD REQUIRES PERMEATE REPAIR IAW A220 ASRP BD500-A-J52-47-06-03AAA-720A-A. CORRECTION LINSDR AALA202507148943Oil System · leakingAIRCRAFT WAS GROUNDED: VOMIT SMELL THROUGHOUT AIRCRAFT INTENSIFIED DURING TAKE OFF AND DESCENT. MAINTENANCE FOUND THE APU TO BE LEAKING INTERNALLY AND REPLACED IT PER TASK CARD 26L31049003. A DECONTAMINATION OF THE ENVIRONMENTAL CONTROL SYSTEM WAS ACCOMPLISHEDSDR AALA202507149360Light · dislodgedAIRCRAFT WAS GROUNDED: EMERG LIGHT ON CLOSET WALL FALLING OFF. MAINTENANCE REPLACED EMERRGENCY H ASSY REF AMM 33-51-05.SDR CALA2025071406559Target · looseDOOR L EMER EXIT ECAM INTERM 4 TIMES ON FINAL PRINTED POST FLIGHT REPORT AND FOUND WARNING BUT NO FAILURES. REMOVED COVER FLAP TO LEFT OVERWING EXIT HANDLE AND FOUND PROX TARGET ON INSIDE OF COVER FLAP WITH SLIGHTY LOOSE SCREWS.RESECURED AND REINSTALLED PANSDR CALA2025071406528Warning Message · false activationON TAKE OFF MASTER CAUTION DOOR ILLUMINATED THEN WENT OUT. UNABLE TO DETERMINE WHICH DOOR TS SYSTEM REF FIM 52-10 TASK 801. PSEU LOGGED INTERMITTANT L1 DOOR FAULT, 52-71001, FUNCTION TESTED SYSTEM, REF SAME FIM, SYSTEM TESTS NORMAL.SDR CALA2025071406524Lamp · no testEMERGENCY LIGHTING SYSTEM OPERATIONAL CHECK. R/H AFT OVERWING EMERGENCY LIGHT INOP. LAMP REPLACED, OP CHECK GOOD IAW: 33-51-04-960-801.SDR CALA2025071406519Door · unsecureCREW REPORTED A LOW SPEED REJECTED TAKEOFF AT 50KTS FOR A AFT L2 DOOR INDICATION FLICKERING. CREW CALLED AND STATED THAT THE DOOR WAS NOT CLOSED PROPERLY. CREW VERIFIED THE DOOR IS FULLY CLOSED AND SECURE.SDR CALA2025071406502Web · dentedFLIGHT DECK FLOOR IS DENTED AT B/S 255 14 INCHES LEFT OF CENTER LINE. REF. AAR N/R:9988418. REPAIRED FLIGHT DECK FLOOR WEB BETWEEN STA 250 AND STA 260 FROM LBL 16 TO RBL 2.5 REF B737 SRM 51-40-02-0G-0 AND SRM 53-10-51-2R-2.