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 SWAA2025080698124Light · unsecurePHOTO ILLUMIN.STRIP PULLED UP ON FOS SIDE NEAR ROWS 12-13. SECURED PHOTO LUMINESCENT LIGHTING STRIP AT ROW 12 IAW AMM 33-51-15.SDR SWAA2025080698127Lens · missingFA REPORTS FWD GALLEY A/C RIGHT EXIT/SALIDA LIGHT LENS MISSING. R & R LIGHT ASSY PER AMM 33-51-01. LIGHT OPS CK GOOD. A/C OK FOR SERVICE.SDR AALA202508069621Priority Valve · defectiveAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED INBOUND INTO DFW DUE TO THE FLIGHT CREW REPORTING THAT THE LANDING GEAR WOULD NOT COME DOWN WITH MULTIPLE RECYCLE ATTEMPTS. AFTER A GO AROUND AND ANOTHER ATTEMPT, IT FINALLY CAME DOWN. THE AIRCRAFT LANDED SAFELYSDR AALA202508062454Control Lever · defectiveAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED INBOUND INTO DFW DUE TO THE FLIGHT CREW REPORTING THAT THE LANDING GEAR WOULD NOT COME DOWN WITH MULTIPLE RECYCLE ATTEMPTS. AFTER A GO AROUND AND ANOTHER ATTEMPT, IT FINALLY CAME DOWN. THE AIRCRAFT LANDED SAFELYSDR DXTA2025080604455Starter Gen · failedON FIRST LEG OF THE DAY, DURING DECENT GEN 1 OFF BUS CAS MESSAGE DISPLAYED. RAN APPROPRIATE QRH AND MESSAGE CLEARED. MESSAGE RETURNED TWO OTHER TIMES THROUGHOUT THE DAY CLEARING ALL TIMES AFTER RUNNING CHECKLIST. ON CLIMB OUT ON LAST LEG ELEC EMER RED CAS MESSSDR DXTA2025080604456Lamp · blownSEAT 10 EMERGENCY LIGHT INOP REMOVED DEFECTIVE LIGHT· 12W HALO P/N RL6860, INSTALLED CUSTOMER SUPPLIED "NEW" LIGHT·12W HALO P/N RL6860. INSTALLED GASPER TO ORIGINAL POSITION. APPLIED POWER TO A/C, PERFORMED OPS CHECK, OPS CHECK GOOD. REF CES60XL MM 33·50·0SDR DXTA2025080604461Coalescer Bag · contaminatedCABIN HAS A STRONG DIRTY SOCK SMELL. PREVIOUS WRITE-UP. CLEANED WATER SEPARATOR ASSY'S, REMOVED LH AND RH WATER SEPERATOR COALESCE, BAGS AND INSTALLED NEW CONDITION LH AND RH WATER SEPERATOR COALESCER BAGS !AW CL650 AMM 21-51-13, PERFORMED OPS FUNCTIONAL AND LSDR N6WA2025080301Control Cable · brokenELEVATOR JAMS WHEN PULLED BACK. FOUND ELEVATOR AUTOPILOT SERVO CABLE BROKEN. REMOVED ELEVATOR AUTOPILOT CABLES IN ACCORDANCE WITH MHIRJ RIL (REFFERENCE INSTRUCTION LETTER) 12802 AND PERFORMED OPERATIONAL TEST OF ELEVATOR CONTROL SYSTEM IN ACCORDANCE WITH MHSDR CALA2025080607392Wire Harness · faultedAT CRUISE CALC FUEL DROPPED 5K BELOW PROJECTED BURN. FUEL INDICATIONS. UNRELIABLE PERFORMED FQIS BITE IAW FIM TASK 28-41, FAULT TREE 847, SELF TEST PASSED, NO ACTIVE OR PRESENT FAULTS. FLT HISTORY, FLT LEG 00, FOUND FAULT CT DENS SENSE WIRE SHORTED A02. DURSDR CALA2025080607380Handle · not seatedHANDLE ON DOOR 1L MOVES UPWARD DURING T/O ROLL. FA MANUALLY RESEATED THE HANDLE. NO ISSUE AT ALTITUDE, OPERATED DOOR 1L SEVERAL TIMES FROM BOTH INSIDE AND OUTSIDE HANDLES, FOUND TO BE OPERATING NORMALLY AT THIS TIME, NO FURTHER DEFECTS NOTED AT THIS TIME, OK TSDR CALA2025080607379Slide · low pressureDOOR 2L SLIDE PRESS GAUGE IS GREATER THEN HALF A NEEDLE SIZE IN THE RED. REMOVED AND REPLACED L2 EMERGENCY ESCAPE SLIDE PER AMM 25-66-01/40. INSP INSTALLATON OF THE R2 DOOR EMERGENCY SLIDE PACK IAW AMM 25-66-01/401.SDR CALA2025080607378Slide · no discrepancy1B SLIDE PRESS IN RED NEEDLE IS NOT PAST THICKNESS OF NEEDLE TO THE RIGHT OF THE GREEN BAND. OK FOR USE REF AMM 25-66-01SDR CALA2025080607377Girt Bar · no discrepancyREPORTED BY FA, CHECKED OPERATION OF GIRT BAR OPERATION AND FOUND NO FAULTS, REF AMM25-66-01.SDR CALA2025080607376Indicator · detachedPIECE OF METAL DETACHED FROM DOOR 2L ESCAPE SLIDE BUSTLE COVER. REINSTALLED ARMING INDICATOR ON DOOR 2L. OP CHECK GOOD.SDR CALA2025080607375Warning Message · false activationCLASSII APU MSG CLEARED WHEN APU MASTER SWITCH ON. FOUND MSG, FUEL LOW PRESS LOW FUEL PRESS SW (5030QM) ON LAST LEG REP. DUE TO HISTORY REQUEST MEL 4900A OK TO MEL COMPLIED WITH MEL 4900A DM MX NOTE FIN 5030QM IS SENSOR P/N FRH100014A (18-2822-3-0017). PERFSDR CALA2025080607374Door · warning messageDOOR WARNING ANNUNCIATOR IS ON AFT ENTRY INSTRUCTED FA TO PUSHED DOOR HANDLE DOWN, LIGHT EXTINGUISHED PRESSURE NORMAL. PERFORMED T/S IAW FIM 52-10 TASK 801 NO TROUBLE FOUND COULD NO DUPLICATE FAULT. NO 30-DAY HISTORY OK TO CLOSE.SDR 2NVA2025080501Bearing · slippedDETECTED NON CONFORMITY ON HYDRAULIC DRIVE BEARING PULLEY. DISCOVERED FRETTING DUST AROUND HYDRAULIC DRIVE PULLEY. FURTHER INVESTIGATION REVEALED PULLEY PN 350A35109224 HAVING SLIPPED ON INNER RACE OF DRIVE BEARING MFG PN 593733.SDR DXTA2025080504450Proximity Switch · faultedAMBER CABIN DOOR OPEN CAS MESSAGE. RAN EMER CHECKLIST FOR CABIN DOOR OPEN CAS MESSAGE ON GROUND N1 MESSAGE WILL NOT CLEAR. SPOKE WITH MCC RAN CHECKLIST AGAIN SAME RESULT. DID A POWER CYCLE MESSAGE STILL WILL NOT CLEAR. PERFORMED TROUBLESHOOTING !AW AMM 52-00-0SDR DXTA2025080504454Strut · dirtyMAIN PAX DOOR WARNING ILLUMINATED SEVERAL TIMES DURING FLIGHT SPOKE WITH PILOTS AND RECREATED THE BINDING. THE SUPPORT STRUT WAS CREATING A CHATTER NOISE BUT WAS NOT CAUSING THE DOOR TO OPERATE IMPROPERLY. WAITED FOR AIRCRAFT TO COME INTO HANGER TO FURTHER EVASDR DXTA2025080504460Strut · dirtyMAIN CABIN DOOR IS BINDING UPON CLOSING. DOOR REQUIRES REALIGNMENT. SPOKE WITH PILOTS AND RECREATED THE BINDING. THE SUPPORT STRUT WAS CREATING A CHATTER NOISE BUT WAS NOT CAUSING THE DOOR TO OPERATE IMPROPERLY. WAITED FOR AIRCRAFT TO COME INTO HANGER TO FURTHSDR WX0A2025080432523Battery · no test(AIRCRAFT NOT GROUNDED) AFT F2 FA FLASHLIGHT NOT CHARGED / REPLACED BATTERY W/REF TO CMM 25-60-02. OPS CHECK GOOD"SDR DALA2025080505852Wedge · wornNUMBER 5 SLAT T/E WEDGE LOWER SURFACE FOUND WORN AT O/B EDGE TO 31.4 INCH. NR 5 SLAT T/E WEDGE LOWER SURFACE WORN REPAIRED AT O/B EDGE TO 31.4 INCH IAW SRM 57-43-02-2R-1 AND SRM 51-70-10-2R.SDR DALA2025080505851Spar · crackedRIGHT PYLON UPPER SPAR BETWEEN NAC STA221.25 AND NAC STA237.5 FOUND CRACKED AROUND WIRE CUTOUT. THE R/H PYLON UPPER SPAR BETWEEN NAC STA221.25 AND NAC STA237.5 POWER FEEDER CABLE CUTOUT CRACK AREA REPAIRED IAW PRI 628061-14 REV 0, .COMPARED AND COMPLIED WITHSDR AALA202508056197Inlet Door · openAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING CLIMBOUT THERE WERE CONTINUOUS AIRFRAME VIBRATIONS AS AIRCRAFT ACCELERATED TO CLIMB SPEED. AIRCRAFT EMERGENCY LANDED SAFELY AT PHL. UPON LANDING APU INLET DOOR WAS FULLY OPEN WHILE OM MEL 49-51. ASDR AALA202508058997Screen · unsecureAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING CLIMBING THRU FL220 ENGINE NUMBER 1 OIL INDICATED 3Q, OIL PRESSURE INDICATION WAS ABNORMAL AND FLUCTUATING. SHUT DOWN ENGINE NUMBER 1, OIL QUANTITY THAN DROPPED TO ZERO. AIRCRAFT AIR INTERRUPTED BSDR DALA2025080505856Strut · looseLEFT WING INTERCONNECTING STRUT LOOSE. CORRECTIVE ACTION: REPLACED BEARING AT LH WING I/B FLAP INTERCONNECTING SUPPORT STRUT ATTACH FITTING IAW A319 CMM TASK 57-52-21-300-803-A01. (1122721).SDR DALA2025080505855Strut · looseRIGHT WING INTERCONNECTING STRUT WITH LOOSENESS. CORRECTIVE ACTION: REPLACED BEARING AT RH WING I/B FLAP INTERCONNECTING SUPPORT STRUT ATTACH PAINT IAW A319 CMM TASK 57-52-21-300-803-A01. (1122710).SDR AALA202508056127Slide · out of adjustAIRCRAFT WAS NOT GROUNDED: PIECES OF THE EVACUATION SLIDE ARE STICKING OUT OF THE FORWARD SERVICE DOOR. PERFORMED INSPECTION OF THE FORWARD SERVICE DOOR ESCAPE SLIDE PACK. FOUND VELCRO SKIRT NOT ATTACHED AND REATTACHED. PER AMM 25-66-01.SDR AALA202508059692Flashlight · inoperativeAIRCRAFT IN BASE MAINTENANCE: AFT RIGHT HAND NUMBER 1 EMERGENCY FLASHLIGHT INOPERATIVE. REMOVE AND REPLACED FLASHLIGHT BATTERY. PER AMM 25-60-00. OPERATIONAL CHECK GOOD.SDR AALA202508052421Flashlight · activation errorAIRCRAFT WAS NOT GROUNDED: FORWARD FLIGHT ATTENDANT JUMP SEAT FLASHLIGHT NOT CHARGING. RESECURED FLIGHT LIGHT. PER AMM 25-64-00. OPERATIONAL CHECK GOOD.SDR AALA202508052760Light · dislodgedAIRCRAFT WAS NOT GROUNDED: CEILING LIGHT ABOVE ROW 27 DEF HANGING DOWN FROM IT'S MOUNTED POSITION. REMOVE AND REPLACED EMERGENCY AISLE LIGHT. PER AMM 33-51-03. OPERATIONAL CHECK GOOD.SDR AALA202508053196Sign · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT SIGN AT OVERWING EXITS DETACHED FROM CEILING. REINSTALLED EMERGENCY EXIT SIGN ON CEILING. PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA202508059966Sign · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT SIGN OVER EXIT ROW DETACHED. RESECURED OVERWING AISLE AFT SIDE EMERGENCY EXIT LIGHT SIGN. PER AMM 33-51-03.SDR AALA202508057204Battery Pack · inoperativeAIRCRAFT WAS NOT GROUNDED: WHILE PERFORMING OPERATIONAL TEST OF THE EMERGENCY LIGHTS FOUND LEFT HAND AFT DOOR EXIT LIGHTS INOPERATIVE. REMOVED AND REPLACED AFT GALLEY LEFT HAND OVERHEAD EMERGENCY BATTERY ASSEMBLY. PER AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR AALA202508054302Battery Pack · inoperativeAIRCRAFT IN BASE MAINTENANCE: REMOVED AND REPLACED AFT LEFT HAND POWER SUPPLY. PER AMM 33-51-06. REPLACEMENT DID NOT RESOLVE THE ISSUE. FURTHER TROUBLESHOOTING REQUIRED. REMOVED AND REPLACED AFT GALLEY LEFT HAND OVERHEAD EMERGENCY BATTERY ASSEMBLY. PER AMM 33-SDR AALA202508054684Sign · missingAIRCRAFT WAS NOT GROUNDED: EXIT SIGN MISSING AT 16A. REPLACED EXIT SIGN. PER AMM 33-50-00.SDR DALA2025080405850Unknown · odorAFT FA REPORTS SULFUR SMELL COMING OUT OF VENTS IN AFT GALLEY. NO ODOR OR SULFUR SMELL NOTED.SDR CALA2025080507339Door · false indicationECAM DOOR RT FWD CABIN ON DEPARTURE. FA REPORTS ORANGE LIGHT FLASHING. ACCOMPLISHED VISUAL INSPECTION OF DOOR, DOOR SEAL, STOP PADS, GUIDE ROLLERS, DOOR CLOSED & OPEN POSITIONS, ARMED AND UNARMED. NO DEFECTS SEEN. MEL 5270AX. CLEANED SENSOR IAW AMM 52-00-0SDR CALA2025080507338Toilet · malfunctionedFWD AFT LAV TOILET OVERFLOWED DURING CLIMB SENDING WATER INTO AF T AFT LAV AND AFT GALLEY. UPON INITIAL INSPECTION FOUND TOILET FULL OF LIQUID. FLUSHED TOILET TO CHECK FLUSH VALVE, NO EVIDANCE OF LEAKING FROM FLUSH VALVE, SUSPECT FILL SIDE OF SYSTEM. FOUND LASDR CALA2025080507328Light · detachedROW 22C EXIT PATH LIGHT BROKEN OFF SEAT 22C. EMERGENCY LIGHT BRACKET AFT MONNT BROKEN. PERFORMED A PERMANENT REPAIR .SDR CALA2025080507327Skin · corrodedFWD CARGO COMP CORRODED FASTENERS FWD OF FR 32 BETWEEN STR 40L A ND SRT 42L. ACCOMPLISED REPAIR INSTRUCTIONS PER HAECO REO L25555 WITH NO DEV IATIONS AT FWD CARGO COMP FR32 BETWEEN 39L-42L STRG IAW SRM 53-2 1-11-300-063 AND ECRA 5321-02165SDR CALA2025080507326Light · brokenEMERGENCY EXIT LIGHT NEAR FORWARD CLOSET BROKEN, REPLACED THE LAMP IN THE EMERGENCY LIGHT AND REPLACED LIGHT COVER IAW AMM 33-51-00, OPS CHECKED GOOD.SDR CALA2025080507301Light · inoperativeEMERGENCY LIGHTING SYSTEM OPERATIONAL CHECK FOUND LH AFT OVERWING SLIDE LIGHT INOPERATIVE. REMOVED AND REPLACED LH AFT OVERWING SLIDE LIGHT. OPS CHECK NORMAL. REF AMM 33-51-04-960-801SDR CALA2025080507300Bracket · brokenFOUND CAPTAIN SIDE EMERGENCY FLASHLIGHT BRACKET BROKEN REPLACED BRACKET AND CHECKED OKAY. CHECKED OK.SDR CALA2025080507299Light · no discrepancyFA REPORTS EMERGENCY LIGHTS ILLUMINATED DURING DESCENT WITH SWITCH IN ARM POSITION OPS CHECK OF EMERGENCY LIGHTING SYSTEM INCLUDING CHECK OF ALL CABIN LIGHTS AND SIGNS, REFERENCE: TASK 33-51-00-710-805-A OPS CHECK OK. ALSO CYCLED E LIGHT SWITCH ON 25VU, OPS CHSDR CALA2025080507298Power Supply · faultedEPSU UNIT EMER R FAULT REF AMM 33-51-38-400-001-A REMOVED AND REPLACED RIGHT OVERWING EXIT EPSU UNIT AND REPLACED EPSU BATTERY FAULT CLEARED OPS CHECKS GOOD.SDR CALA2025080507291Lavatory · dirtyFWD LAV EMITS STENCH AFTER FLUSHING NO FOUL ODOR DETECTED AFTER LAV SERVICING WAS PERFORMEDSDR CALA2025080507290None · noneSTRONG ODOR OF FUEL THROUGHOUT AIRPLANE AFTER PARKING W/ APU SHUTDOWN. PORTABLE CONDITIONED GROUND AIR CART CAUSING ODOR. SHUTDOWN UNIT. STARTED APU AND RAN PACKS. ODOR CLEAREDSDR GTIA2025080439034Oil System · overserviced"IN CRUISE AT FL 35.0 SMELLED OIL SMELLY FUME , RAN QRH SHUT X BLEED AND TURNED OFF PACK 1 DID NOT SMELL AGAIN -PER GMM 30.40.3 FOUND FOUND TO BE ODOR EVENT STAGE 3. NO EVIDENCE OF APU OR ENGS OVERSERVICE. PER TSM 05-50-00-810-831-A FOUND #1 ENG AND PACK #1 SOSDR GTIA2025080439033A/C Pack · odorAQE PACK 1. FERRY FLIGHT 9134 SAL FLL HAS REPORTED AN ODOR EVENT BEFORE FINAL INTO FLL. CA REPORTED TO DX THAT THERE WAS AN ODOR IN THE COCKPIT AND THEY WERE ABLE TO ISOLATE THE ODOR TO PACK 1. CREW WILL BE WRITING IT UP IN THE LOGBOOK AFTER BLOCKING IN. THERE