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 DALA2025102307751Engine · bird ingestionON WALKAROUND POST FLIGHT INSPECTION FOUND NR 1 ENGINE AD EVIDENCE OF A BIRD STRIKE INSIDE THE ENGINE COWLING, ALL ENGINE INDICATIONS NORMAL. C/A: CW AMM 05-51-14 INSPECTION, CLEANED DEBRIS , NO DAMAGE NOTED, DEFER BOROSCOPE INSPECTION ON MON. FOR 25 FLT HR ORSDR SCNA20251023406Solenoid · faultedFLIGHT LOCK SOLENOID OF AUTOMATIC EMERGENCY EXIT DOOR RH / FWD SIDE NOT WORKING CORRECTLY. OPENSDR SCNA20251023405Fuse · inoperativeFWD OVERWING EMERGENCY EXIT LIGHT INOPERATIVE LT SIDE. REMOVED AND REPLACED POWER SUPPLY FUSE FOR L/H FORWARD EXIT DOOR EMERGENCY LIGHT. OPS CHECKS GOOD. REF AMM 33-51-06.SDR CALA2025102310452Bracket · unsecureDOOR 2R GIRT BAR LOOSE ACTUAL LOCATION DOOR 2L GIRT BAR DOOR BRACETS NOT HOLDING GIRT BAR SECURELY, ADJUSTED DOOR BRACKETS.SDR CALA2025102310451Slide · no discrepancyDOOR 2R SLIDE FABRIC STICKING OUT PERFORM SLIDE PACK, CHECKED 2L. IAW AMM 25-66-01-200-802. GIRT FABRIC IN NORMAL FOLD & POSITION.SDR CALA2025102310450Girt Bar · no discrepancyLOTS OF PLAY ON LEFT SIDE OF GIRT BAR AT DOOR 1L. PERFORMED INSPECTION OF L1 GIRT BAR ON THE LEFT-HAND SIDE & FOUND NO DEFECTS IAW AMM 25-66-01.SDR CALA2025102310440Support Strap · corrodedAFT CARGO COMP, BEHIND RH SIDE PANEL, BTW STA 1360 AND STA 1380, STRAP SUPPORT HAS CORROSION AROUND NUTPLATES. REMOVED SUPPORT ANGLE BTW BS 1360 - 1380 IAW SRM 51-4 0-02. REMOVED FOR ACCESS TRANSITION PANEL IAW SRM 51-40-02. INSTALLED NEW PART IAW SRM 5 1SDR CALA2025102310439Fitting · crackedSHEAR FITTING AT BS 540 AND LBL 15.04 IS CRACKED. REMOVED AND REPLACED SHEAR FITTING AT STATION 540 AND LBL 15.04 IAW SRM 51-40-02 & DWG 111A2000 REV ORIG.SDR CALA2025102310438Fitting · crackedSHEAR FITTING AT BS 540, LBL 6.14 CRACKED. REMOVED AND REPLACED SHEAR FITING AT BS 540, LBL 6.14 IAW SRM 51-40-02 & DWG 111A2000 REV ORIG.SDR CALA2025102310437Fitting · crackedSHEAR FITTING AT STATION 540 AND RBL 6.14 IS CRACKED. REMOVED AND REPLACED SHEAR FITTING AT BS 540, RBL 6.14 IAW SRM 51-40-02 AND BAC DWG 111A2000 REV ORIG.SDR CALA2025102310436Fitting · corrodedFR 66R STR 23R FWD OF GIRT BAR FITTING HAS CORROSION. REPAIRED RT DOOR SILL FR 66 STR 23R FWD OF GIRT BAR FITTING IAW SRM 53-41-14-283-002.SDR CALA2025102310435Seat Track · corrodedCABIN FLOOR STRUCTURE RT OTBD SEAT TRACK Y-1292 CORRODED AT FR 66. REMOVED AND REPLACED THE SEAT TRACK IAW SRM 51-42-11/001.SDR CALA2025102310434Pan · corrodedLOWER FUSELAGE POTABLE WATER SERVICE DOOR CUTOUT INSIDE CORROSION IN SEVERAL AREA. REMOVED AND INSTALLED NEW DOUBLER AND PORTABLE WATER SERVICE PAN AT AFT CARGO IAW SRM 51-40-02-0G-0, DWG 147A7221 AND DWG 147A722.SDR ASAA2025102161761Lens · detachedFA REPORTS EXIT SIGN BY R1 CAME OFF. GROUNDED - YES. REMOVED AND REPLACED LIGHT LENS AS REQ.SDR SWIA2025102200001Door · warning messagePASSENGER DOOR WARNING MESSAGE ON DESCENT. FOLLOWED QRH. THEN HAD CAB ATL WARNING AND CAUTION MESSAGE. (FLIGHT 9919) WHEN ACFT ARRIVED AT GATE, MECHANIC WITNESSED MCD OUTER HANDLE NOT STOWED ALL THE WAY. UPON INSPECTION OF MCD LATCH MECHANISM, FOUND TENSIONERSDR CALA2025102210420Flashlight Assy · no testDURING INTERNAL WALKTHROUGH DR2 L FLASHLIGHT POS 1 TEST INDICATOR FOUND INOP. R&R DR2L POS1 EMERGENCY FLASHLIGHT DUE TO FAILED TEST USING AMM TASK 25-64-00-200-801 AS A REF. OPS CHECK GOOD.SDR CALA2025102210415Flashlight Assy · failedDURING INTERNAL WALKTHROUGH DR2 L EMERGENCY FLASHLIGHT POS 2 TEST INDICATOR FOUND INOP. R&R DR2L POS 2 EMERGENCY FLASHLIGHT DUE TO FAILED TEST USING AMM TASK 25-64-00-200-801 AS A REF. OPS CHECK GOOD.SDR CALA2025102210414Lens · missingMISSING THE LENS AT AFT GALLEY EMERGENCY LIGHT ASSY. INSTALLED THE LENS AT AFT GALLEY EMEGERCY LIGHT, AS REF IPC 33-51-04-35. ITEM GOOD FOR SERVICESDR CALA2025102210413Fuel Cap · missingAC ARRIVED IN ORD WITH FUEL CAP ASSY MISSING .SDR DALA2025102207744Lens · looseROW 17C EXIT SIGN (LOWER). SECURED EMERG EXIT SIGN LENS PER B757 AMM 33-20. (7048888)SDR DALA2025102207743Idg · inoperativeMISC/DE- DUE TO RIGHT GENERATOR FAILED WITH APU ON MEL. REPLACED RIGHT ENGINE IDG AND RIGHT GCU. APU EGT THERMOCOUPLE REPLACED.SDR DALA2025102207742Lanyard · out of positionR3 DOOR ARM LIGHT WILL NOT ILLUMINATE FA REPORTS 3R DOOR WILL NOT ARM. REMOVED BUSTLE.FOUND GREEN PARA CORD OUT OF POCKET AND UNDER GIRT BAR.STOWED SAME.REPLACED BUSTLE OPS OK REF B757 AMM 52-11. (5953572)SDR DALA2025102207741Arming Lever · binding1R DOOR ARMING LEVER BINDING. REMOVED DEBRIS FROM GIRT LATCHES ON FLOOR OPS NML. (6683754)SDR DALA2025102207739Battery Pack · inoperativeSHIP 699 ROW 33-42 EELPS INOP. REMOVED DEDO PANELS AT ROWS 27-28 AND 38-39 PER B 757 AMM 21-23. R/R BATTERY PACKS AT M735 ANS M11648 EMERGENCY POWER SUPPLIES REF B 757 AMM 33-51. OPS CKS GOOD. REINSTALLED PANELS AT ROWS 27-28 AND 38-39. (5952888)SDR DALA2025102207738Skin · damagedREFERENCES AMDS AD 5331-01293-02A-01: EXISTING REPAIR WAS FOUND IN THE INSPECTION AREA. EXISTING REPAIR WAS FOUND ON SKIN FS 615, LOWER AFT EDGE OF THE CUTOUT AT THE FWD CARGO DOOR WAS INSPECTED AND REPAIRED PER ER/A 475273-14AD REV.E; SECTION V: PERMANENT RSDR DALA2025102207737Skin · damagedFOUND IN FASTENER HOLE 4. NICK ON COUTERSKIN. LH WING. S THIS DISCREPANCIE MUST BE REPAIRED PER ER/ A 595215-14AD REV C SECTION VI UNDER NRC 00157. (1263652)SDR DALA2025102207736Seat Track · damagedBOTH LH INBD AND OUTBD SEAT TRACKS HAS SCRATCHES, FWD OF STA 879 . BLENDED AREA AND REMOVED SCRATCHES ON LH INBD SEAT TRACK, FWD STA 879 AND FOUND OUT LIMITS IAW B757-200 SRM 53-00-52-1A-1 FIG 101 DETAIL I AND REPAIRED IAW B757-200 SRM 53-00-52-2R-1 REPAIR 1 SDR DALA2025102207735Skin · damagedFOUND IN FASTENERS HOLES 16, 17.18 MISSALING BETWEEN WING SKIN AND DRAG FITTING. ON LH WING. UPPER WING SKIN, FRONT SPAR & OUTBOARD DRAG FITTING DISCREPANCIES WERE REPAIRED PER PRI 595215-14 REV 10 & ER/A 595215-14AD REV C SECTION VI, INBOARD DRAG FITTING OSDR CHIA202510229834Encoder · arcedAIRCRAFT RETURNED TO BASE, WITH PILOTS REPORTING A BURNT ELECTRICAL SMELL, AND DIMMED EHSI. INSPECTED EHSI, AND ASSOCIATED WIRING, FINDING NO SIGNS OF DAMAGE. ULTIMATELY FOUND ALTITUDE ENCODER IN LH AVI CLOSET LOOSE FROM IT'S MOUNT PLATE, AND SIGNS OF ARCING TSDR DALA2025102207733Skin · wornFOUND LH WING SLAT NO.5 T/E SURFACE TOP AREA WORN AT OSS 514. LH WING SLAT NO.5 T/E SURFACE TOP AREA REPAIRED AT OSS 514 AS PER B767-400 SRM 57-43-02-2R-1 AND SRM 51-70-10-2R-4 FIGURE 202 AND SRM 51-70-10-2R-0. (1263410)SDR DALA2025102207728Slide · faultedDURING SVC EMER LIGHT FAULT 13WL, ESCAPE SLIDE AFT L AND EXIT SIGNS 13WL. REPLACED R4 DOOR ESCAPEE SLIDE ASSY REF AMDS WORK CARD 2561-4002-RA. (LP 7653861, 1263394)SDR HALA20251022326Engine · oil consumptionETOPS - #1 ENG HAS A HIGH OIL CONSUMPTION RATE. PERFORM TSM 79-31-00-810-832-A. FOUND EVIDANCE OF FUEL ODOR FROM FOHE OIL. OIL SAMPLE SAVED. REPLACED FOHE PER AMM 79-21-41. ENG RUN AND LEAK CHECK GOOD.SDR 4EZF202510210001None · no discrepancyBIRD STRIKE (DURING LANDING AT TNCC) - MTX ACTION: PERFORMED INSPECTION OF THE FUSELAGE IN ACCORDANCE WITH SRM 51-10-00-001 NO DAMAGE FOUND. AIRCRAFT WAS RELEASED BACK TO SERVICE.SDR SIMA20251021002Power Supply · no testSEAT ROW 12/13 EMERGENCY LIGHT OUT RAR EMERGENCY LIGHT POWER UNIT #4 IAW AMM 33-50-01. OPC GOOD.SDR SIMA20251021001Stringer · corrodedNRTC F074483 STRINGER 28R BETWEEN FRAMES 85-89 HAS CORROSIONAND OR CORRODED FASTENERS IN AREAS. (LEVEL 2 CORROSION) REPAIRED STRINGER 28R BETWEEN FRAMES 85-89 OS ERS EJ-53MR-5267.SDR AALA202510222821Battery · dischargedAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS AFT LEFT HAND AISLE JUMPSEAT EMERGENCY FLASHLIGHT IS FLASHING RED. REMOVED AND REPLACED AFT GALLEY INBOARD JUMPSEAT FLASHLIGHT (AALA202510224521) AND BATTERY (AALA202510222821). OPERATIONAL CHECK GOOD.SDR AALA202510224928Indication Sys · malfunctionedAIRCRAFT WAS NOT GROUNDED: LEFT MAIN FUEL TANK QUANTITY INDICATION ERRATIC. FUEL QUANTITY SHOWS INCREASING AND DECREASING CONSTANTLY WHEN CROSS-FEEDING AND LEFT MAIN TANK FUEL PUMPS TURNED OFF. CONFIRMED LEFT FLIGHT DECK FUEL TANK INDUCTION INOPERATIVE. (OPENSDR AALA202510223955Hook · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT ENTRY DOOR GIRT BAR DIFFICULT TO DISARM. LUBED AFT ENTRY DOOR GIRT BAR HOOK. PER AMM 25-66-00. OPERATIONAL CHECK GOOD AT THIS TIME.SDR AALA202510228853Girt Bar · inoperativeAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANTS REPORT THAT THE BRACKET FOR THE SLIDE GIRT BAR AT DOOR 1R IS TOO TIGHT; VERY DIFFICULT TO ARM THE SLIDE. REMOVED AND REPLACED R1 ESCAPE SLIDE COVER. PER AMM 25-66-01-400-803.SDR AALA202510224734Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT AT FORWARD FLIGHT ATTENDANT STATION INOPERATIVE. REMOVED AND REPLACED FLASHLIGHT ASSEMBLY UNDER FORWARD FLIGHT ATTENDANT SEAT PER STANDARD MAINT PRACTICES. OPERATIONAL CHECKS GOOD.SDR AALA202510224521Flashlight · no testAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS AFT LEFT HAND AISLE JUMPSEAT EMERGENCY FLASHLIGHT IS FLASHING RED. REMOVED AND REPLACED AFT GALLEY INBOARD JUMPSEAT FLASHLIGHT (AALA202510224521) AND BATTERY (AALA202510222821). OPERATIONAL CHECK GOOD.SDR AALA202510224057Hook · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT SERVICE DOOR GIRT BAR DIFFICULT TO DISARM. LUBED AFT SERVICE DOOR GIRT BAR HOOK. PER AMM 25-66-00. OPERATIONAL CHECK GOOD AT THIS TIME.SDR AALA202510220570Engine · vibrationAIRCRAFT WAS GROUNDED, AN EMERGENCY WAS DECLARED DUE TO: DURING CLIMB NUMBER 1 ENGINE VIBRATION BEGAN TO SPIKE INTO ABNORMAL RANGE. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT PHL. OPENSDR FDEA202510212062Proximity Sensor · faultedRIGHT MLG UNSAFE BOTH PRI & SEC WITH GEAR HANDLE UP. COMPLIED WITH QRH. LOWERED LG. SAFE INDICATIONS ALL FOUR. RAISED GEAR HNDLE PER QRH. UNSAFE RMLG & NLG. UPON ARRIVAL, SLOWED FROM 250 TO 230. NLG AUDIBLE CHANGE AND INDICATED SAFE UP. SUBSEQUENT LOWERINGSDR FDEA202510212060Floor Panel · crackedPUNCTURE ON FLOOR PANEL 242LFA MDC. FLOOR PANEL 242LFA MDC WAS REPAIRED IAW B767 SRM 53-00-50-2R PAR 4-B FIG 201 SHEET 2 REV 92 APR 15, 2025SDR FDEA202510212059Floor Panel · dentedSEVERAL DENTS AND DISBOND AT FWD EDGE OF FLOOR PANEL 241WFF FLOOR PANEL 241WFF WAS REPAIRED IAW B767 SRM 53-00-50-2R PAR 4-B FIG 201 SHEET 2 REV 92 APR 15, 2025SDR FDEA202510212058Floor Panel · crackedCRACK AND PUNCTURES ON SKIN OF FLOOR PANEL 242SFF MAIN CARGO COMPARTMENT. FLOOR PANEL 242SFF, MAIN CARGO COMPARTMENT WAS REPAIRED IAW B767 SRM 53-00-50-2R PAR 4-B FIG 201 SHEET 2 REV 92 APR 15, 2025SDR FDEA202510212057Skin Panel · corrodedAPU COMPARTMENT RT SIDE BS 1896.20, DOOR 316AR CUTOUT, INTERNAL SKIN, WITH CORROSION. CORROSION OUT OF LIMITS AT APU COMPT. RT SIDE B.S 1892 DOOR 316AR CUTOUT AREA ON INTERNAL SKIN WAS REPAIRED IAW SRM 53-80-01-2R AND SRM 51-70-10-2R.SDR DALA2025102207727Skin · dentedSHIP 3128 LEFT HAND HORINZONTAL STABILIZER LEADING EDGE FOUND TO HAVE MULTIPLE DENTS. CORRECTIVE ACTION: EVALUATED REF A319 SRM 51-77-10. COMPLETED GVI REF A319 NTM 51- 90-00 AND TAP TEST REF A319 NTM 51-10-03. NO DISCREPANCIES NOTED. AREA PREVIOUSLY BLENDED ASDR DALA2025102207726Bonding Strap · corrodedSHIP 3153 DEBONDED FLAP TRACK FAIRING 4 (533CB) BONDING STRIP ON LH WING. CORRECTIVE ACTION: COMPLIED WITH ER/A 622998-14TR. (1264357).