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 CALA2025071406527Door · lack of lubeDUE TO MULTIPLE ENTERIES OF PASSENGER ENTRY DOOR 4R WILL NOT ARM COMPLY WITH AMM 52-11-18-01B-280B. PASSENGER ENTRY DOOR GIRT BAR FLOOR FITTINGS DETAILED INSPECTION. ASSURE DOOR MODE SELECT LEVER OPERATES WITHOUT DIFFICULTY DURING ENGAGE AND DISENGAGE. PERFSDR CVGA20250714001Flap System · faultedFLAP FAILURE ON DEPARTURE, STUCK AT 4 DEGREES. WERE ABLE TO RESET FLAPS AND FLAP FAIL WENT AWAY. PERFORMED FLAPS OPS CHECK AND FLAPS OPS CHECK IS NORMAL IAW CL300 27-51-05-710-801.SDR JJBA20250714046Angle · crackedRH INTERNAL STRUCTURE BTW FR 61-62 AND STR 4R-5R, ANGLE FOUND CRACKED. RH INTERNAL STRUCTURE BTW FR 61-62 AND STR 4R-5R ANGLE REMOVED AND REPLACED.SDR DALA2025071105240Skin · gouged(LOG 1070402) EXTERNAL FUSELAGE SKIN AND INTERNAL DOUBLER GOUGED AT AFT CARGO DOOR CUT OUT, APPROX 18IN ABOVE AFT LOWER CORNER. REPAIRED AFT CARGO DOOR CUT OUT APPROX 18IN ABOVE AFT LOWER CORNER DAMAGE IAW B737-900 SRM 53-00-01-2R-24, 53-00-01-1A-6, 51-40-02, SDR DALA2025071105231Wire · misinstalled(LOG 7420453) L2 DOOR LOWER EMER EXIT SIGN LIGHT IS INOP. FOUND NEGATIVE WIRE SOLDER IN POOR CONDITION. SOLDERED NEGATIVE WIRE TO LIGHT ASSEMBLY REF B737 SWPM 20-10. OPS CHECK GOOD.SDR DALA2025071105229Skin · dented(LOG 1071380) DENTS LOCATED ON FUSELAGE SKIN AT STA363; BELOW L1 DOOR BETWEEN STR17-18L. REPAIRED DENTS BELOW L1 DOOR BETWEEN STR 17 THROUGH STR18L IAW DELTA ER/A 626317-14 AND ATS ER NO25-01763 REV: P5.SDR JJBA20250711043Shear Tie · crackedLH FR 67 BTW STR 6L-7L SHEAR CLIP FOUND CRACKED. LH SHEAR CLIP AT FR67 BTW STR 6L-7L REMOVED AND REPLACED.SDR JJBA20250711041Angle · crackedRH INTERNAL STRUCTURE BTW FR 67-68 AND STR 4R-5R. CARGO DOOR MECHANISM MIDDLE ANGLE FOUND CRACKED. RH INTERNAL STRUCTURE BTW FR 67-68 AND STR 4R-5R CARGO DOOR MECH MIDDLE ANGLE REPLACED ,SDR AALA202507116491Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 312 TO BS 328 AT RBL 20. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202507119489Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 294 TO BS 276 AT BL 0. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202507117607Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 312 TO BS 328 AT LBL 20. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202507118432Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 328 TO BS 344 AT LBL 20. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202507117738Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL UPPER ANGLE FROM BS 380 TO BS 400 AT LBL 9. REPLACED ANGLE PER AARD 51-00-05-1.SDR 2025FA0000492Skin · crackedRIGHT WING AFT WING WALK CORRUGATED SKIN CRACKED, REPLACED SKIN ASSY WITH NEW.SDR 2025FA0000491Skin · crackedRIGHT WING FWD WING WALK CORRUGATED SKIN CRACKED, REPLACED SKIN ASSY WITH NEW.SDR CALA2025071106462Attach Angle · crackedMAIN WHEEL WELL STA 663.75 LBL 7. VAPOR BARRIER UPPER ANGLE CRACKED. ACCOMPLISHED REPAIR OF LH VAPOR BARRIER UPPER ATTACH ANGLE STA 663 LBL 5 TO LBL20" PER SRM 57-10-10-2R-5.SDR CALA2025071106452Lanyard · unsecureROPE HANGING OUT OF SLIDE AT DOOR 1R ROPE SECURED AS REQUIRED. NO OTHER DEFECTS NOTED AS THIS TIME. DOOR ARMED AND DISARMED SEVERAL TIMES , FOUND SATISFACTORY. OPERATIONAL CHECK OF DOOR CARRIED OUT, FOUND SATISFACTORY.SDR CALA2025071106451Girt Bar · no discrepancyDOOR 4L SLIDE ARM INDICATOR LIGHT INOP COMFIRM DOOR ARMING GOOD, JUST ARMING LIGHT INDICATOR LIGHT INOP SWAPPED WITH GOOD LIGHT ASSY NO HELP. REQUEST MEL 2566U FOR DOOR 4L SLIDE LIGHT INDICATION. SLIDE INDICATOR LIGHT AT 4L INOP. COMPLIED WITH MEL. SEE L/P 550SDR CALA2025071106450Light · inoperativeDOOR L4 NOT ARMING COMFIRM DOOR ARMING GOOD, JUST ARMING LIGHT INDICATOR LIGHT INOP. SWAPPED WITH GOOD LIGHT ASSY NO HELP. REQUEST MEL 2566U FOR DOOR 4L SLIDE LIGHT INDICATION. MEL 2566U. REFERENCE LOG PAGE 5487168 FOR CORRECT DOOR LOCATION AND DEFERRAL PROCSDR CALA2025071106449Girt Bar · out of adjustDOOR 4R WILL NOT ARM, PERFORMED INSPECTION OF DOOR AND SLIDE ASSY, ADJUSTED GIRT MATERIAL AS NEEDED, REF AMM 25-66-01-00A-521B. PIN REMOVED AND STOWED AND EPAS SAFETY SWITCH RETURNED TO NORMAL.SDR CALA2025071106448Girt Bar · out of adjustL1 DOOR WITH A THE LEFT SIDE OF THE SCAPE SLIDE HOLDING BAR LOOSE. ADJUSTED AS REQUIRED, OK FOR SERVICE.SDR CALA2025071106447Relay · faultedDOOR FLIGHT LOCK 1R EICAS STATUS NR 1 RIGHT PASSENGER ENTRY DOOR FLIGHT LOCK COMMAND/FLT LK RLY/SEN SOR DISAGREEMENT. FIM TASK REFERENCE NOT FOUND CMC MSG. REPLACED DOOR 1R FLIGHT DOOR LOCK RELAY K52201 IN P210 PANEL REF WDM 52-11-12 & FIM 52-11 TASK 806. STSDR CALA2025071106446Cover · no discrepancy2L SLIDE RAFT PLASTIC COVER IS LOOSE. NSPECTED DOOR 2L, FOUND SLIDE COVER INSTALLED CORRECTLY REF AMM 25-66-01-200-802.SDR SWAA2025071089669Coffeemaker · odorFO SIDE AFT COFFEE MAKER FA REPORTS BURNING SMELL WHEN ON SMELL GOES AWAY WHEN TURNED OFF<[01] R&R F/O SIDE AFT COFFEE MAKER PER AMM 25-30-01SDR SWAA2025071088984Intercostal · crackedFWD CARGO COMPARTMENT RIGHT OF CENTER INTERCOSTAL AT STA 540 CRACKED. REMOVED AND REPLACED PER [SRM 51-40-02-0G-0-A00729 (GENERAL - FASTENER INSTALLATION AND REMOVAL - AIRFRAME - PERMANENT) FWD CARGO COMPARTMENT RIGHT OF CENTER INTERCOSTAL AT STA 540.SDR SWAA2025071089003Girt Bar · out of positionR1 DOOR SLIDE LOWER FLAP REQUIRES REPOSITION. REPOSITIONED & SECURED LOWER GIRT BAR FLAP ON R1 DOOR SLIDE PER AMM 25-66-01.SDR SWAA2025071089205Flashlight · unsecureAFT GALLEY CAPTAIN SIDE FLASHLIGHTS WORKING, BUT NOT TESTING. OK TO CONTINUE PER MEL 25-12-01 SP1B. SECURED AFT CABIN LT FLASHLIGHT AND PERFORMED FLASHLIGHT CHECK WITH PUSH TO TEST -LED INDICATOR IAW AMM 25-64-00 AND FOUND ALL SATISFACTORY .SDR SWAA2025071089127Flashlight · inoperativeAFT LEFT OUTBOARD FLASH LIGHT INOPERATIVE. R&R FLASHLIGHT & BATTERY PER AMM 25-64-00.SDR SWAA2025071090042Battery · inoperativeAFT LEFT OUTBOARD FLASH LIGHT INOPERATIVE. R & R FLASHLIGHT & BATTERY IAW AMM 25-64-00.SDR SWAA2025071089286Flashlight · inoperativeONE L/H AFT FLIGHT ATTENDANT FLASHLIGHT INOP. REMOVED AND REPLACED LT AFT FA FLASHLIGHT ASSY IAW AMM 25-64-00.SDR SWAA2025071089218Sign · looseEMERGENCY EXIT SIGN FOUND FELL FROM CEILING AT EMERGENCY EXIT ROW 11. REPLACED EMERGENCY EXIT SIGN AT ROW 11 REF AMM 33-51-01.SDR SWAA2025071088926Light · inoperativeFORWARD EMERGENCY LIGHT OVER RIGHT OVER WING EXIT IS INOPERATIVE. REMOVED AND REPLACED PER AMM 33-51-04-960-801-NG (SLIDE/OVERWING LIGHT - LAMP REPLACEMENT - PERMANENT).SDR SWAA2025071089596Battery Pack · inoperativeR2 DOOR EMERGENCY LIGHTS ARE INOPERATIVE. REMOVED AND REPLACED PER AMM 33-51-06-960-805-NG (POWER SUPPLY - BATTERY PACK REPLACEMENT - PERMANENT).SDR SWAA2025071089200Battery Pack · inoperativeBOTH L/H EXTERIOR OVER WING EMERGENCY LIGHTS ARE INOPERATIVE AND INTERIOR AISLE EMERGENCY LIGHTING L/H ROWS 8-23 ARE INOP. REMOVED AND REPLACED PER AMM 33-51-06-960-802-MAX (POWER SUPPLY - BATTERY PACK REPLACEMENT - PERMANENT)SDR DALA2025071005204Wire Harness · faultedSHIP 1811 -DIV- TO JFK DUE TO LT FUEL QTY INOP. UNABLE TO CONTINUE ETOPS. MEL APPLIED. A/C RESTRICTED TO NON ETOPS ROUTING. REPLACED LEFT MAIN FUEL TANK HARNESS. OPS CHECK GOOD, ALL PROBES WITHIN LIMITS.SDR DALA2025071005201Light · brokenSHIP 1601 OVERHEAD PANEL EMERGENCY LIGHT ARMED LIGHT BROKEN. CORRECTIVE ACTION: REMOVED & REPLACED OVERHEAD EMERGENCY LIGHT ARMING PANEL PER B767-300 AMM 33-51. (7050470).SDR DALA2025071005200Light · inoperativeSHIP 1811 DURING SVC CHK FOUND FLIGHT CREW EMERGENCY LIGHT INOP. CORRECTIVE ACTION: R/R EMERGENCY LIGHT ASSEMBLY IAW B767 AMM 33- 51. (7314948).SDR DALA2025071005198Wire Harness · damagedTOTAL FUEL QTY INDICATION INOP DUE TO MEL 28-41-01A. CORRECTIVE ACTION: PERFORMED FQIS BITE FAULTS MULTIPLE TU OPEN LO Z OR HI Z WIRING. ISSUE NO RESOLVED CONTINUED IN MEL (7314951). R&R LT WING TANK HARNESS PER B767 AMM 28-31, OK FOR SVC.SDR UATA5120710252101Unknown · smoke"WHEN BLEED AIR IS TURNED ON, SMOKE ENTERS COCKPIT." "INSPECTED, NO SMOKE WAS OBSERVED COMING FROM THE ENGINE COMPARTMENT." CAUSE SUSPECTED TO BE DIRT/DUST IN BLEED AIR HEAT/VENT DISTRIBUTION.SDR GTIA2025071038987Megaphone · inoperativeMEGAPHONE DOES NOT WORK-R&R FWD L1 ENTRANCE DOOR PORTABLE SAFETY MEGAPHONE IAW AMM 25-65-01SDR GTIA2025071038986Ecs · contaminatedDIRTY SOCK SMELL IN COCKPIT ONLY. TURNED OFF PACK 1 AND SMELL DISAPPATED. WE WERE ABOUT 8,000' ON DESCENT-PER TSM 05-50-00-810-831-A, LEVEL B DECONTAMINATION OF THE BLEED AIR DUCTS AND ECS IS REQUIRED. PERFORMED LEVEL B DECONTAMINATION OF THE BLEED AIR DUCTS ASDR GTIA2025071038985A/C Pack · odorDURING APPROACH AT 5000 FA REPORTS STRONG SMELL OF DIRTY SOCKS/SOUR MILK -REF LP # 3589162-1, PACK BURNOUT ACCOMPLISHED ON # 1 PACK, PACK # 2 BURNOUT C/W IAW AMM 21-00-00, ALL CHECKS OK, NO ODORS DETECTED AT THIS TIME WITH TH AEROTRACER AROUND THE CABIN, A/C OSDR DATA20250710001Blade · crackedDURING ACCOMPLISHMENT OF AD 2003-22-05 AN OUT OF LIMITS CRACK WAS FOUND IN THE #5 PROPELLER BLADESDR UIEA2025070800867Oxygen Mask · obstructedSAFETY HAZARD OXYGEN MASK OBSTRUCTED BY GPS CABLE, O2 IS UNUSABLE.(<P>ROUTED CABLE PER EO 7746A003. DOES NOT OBSTRUCT O2 MASK. NO FURTHER DEFECTS NOTED.</P>)SDR CALA2025071006434Flap System · faultedFLAPS INDICATING 5 WITH FLAPS 40 SELECTED RAN FLAP DISAGREE CHKL ST HAPPENED 2000FT 165KTS PERFORMED FSEU BITE TEST WITH NO FAULTS FOUND, LAST FAULT WAS 94 LEGS OLD, PERFORMED TRAILING EDGE FLAPS PRIMARY CONTROL OPERATIONAL CHECK WITH NO FAULTS FOUND AND PERFOSDR CALA2025071006433Door · out of adjustFWD SERVICE DOOR LIGHT ILLUMINATED 5 TIMES IN FLIGT W/ASSOCIATED HANDLE MOVEMENT OF 4IN ADJUSTED R1 GALLEY SERVICE DOOR PER AMM 52-41-00-820-801 STEPS N- LATCH ADJUSTMENT, O-HORIZONTAL CONTROL ROD ADJUSTMENT, Q-STOP PIN ADJUSTMENT. ADJUSTED SOFT UNLATCHING PERSDR CALA2025071006430Bulb · missingRH LANDING LIGHT BULB WAS MISSING IN ARRIVAL IN DENVER. RH LANDING LIGHT ASSY REPLACED ON LP 5481968SDR CALA2025071006424Seat Track · corrodedFOUND CORR. AT FASTENERS HEADS MAIN CABIN L/H O/B SEAT TRACK UPPER CROWN WEB LBL 45.5 STA 827 TO 847 MKD DOT 119 REF AAR N/R 9983579 REMOVED EWIS PROTECTION AT WORKING AREA PER AMM 20-60-07-913-801. WORK ACCOMPLISHED BY V903719 REMOVED CORROSION AT SEAT TRSDR CALA2025070906411Light · detachedEMERGENCY EXIT LIGHT AT 14C HANGING DOWN WITH WIRES EXPOSED. PERFORMED THE INTERIM REPAIR PER PART 1.TAPE APPLIED. REMOVE AND REPLACE EMERGENCY EXIT LIGHT AT 14C, AND END BAY. OPS CHK GOOD AT THIS TIME. IAW CMM 25-23-55.SDR CALA2025070906410Light · no testEMERGENCY LIGHTS OPERATIONAL CHECK {B767-33-3-7000} - DURING OPERATIONAL CHECK WAS FOUND AFTER EXTERNAL LIGHT SIDE RIGHT DOOR 2RH INOP. IT WAS SLIDE AND OVERWING ESCAPE LIGHT LAMP REPLACEMENT AFTER DOOR RIGHT 2RH AS PER AMM-TASK 33-51-06-902-082, CHECKED OK.