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 CALA2025080407236Gcu · faultyON ROTATION CAP FLT INSTRUMENTS BLANKED OUT. LT GEN CONTACTOR LIGHT ON RESET OK LOCKED CAPTAIN NOTIFIED THAT INSTRUMENTS CAME BACK ON WHEN LT GEN WAS RESET INSTRUMENTS OPS NORMAL REST OF FLT. APPEARS PIREP IS REFERRING TO LT GEN CONT OFF LIGHT BEING ILLUMINASDR CALA2025080407235Stub Beam · damagedSTA 616 LH STUB BEAM HAS AN ELONGATED HOLE. REPAIRED BS616 L/H STUB BEAM AS REQ IAW REO-G25531 REV IR AND ECRA NO. 5311-03385 REV-.SDR CALA2025080407234Panel · crackedAFT CARGO FR 56 LSTR 32-35 PROFILE PANEL IS CORRODED AND BROKEN. REMOVED AND REPLACED DISCREPANT FR56 L/H STR 32-35 PROFILE IAW A 319 SRM 51-42-11-001.SDR CALA2025080407233Profile · corrodedFWD CARGO BAY FR34 PROFILE PNL HAS CORROSION STR 38 LH-RH. REMOVED AND REPLACED PROFILE PANEL AT FWD CARGO FR 34 STR 38 L/H -R/H IAW A319 SRM 51-42-11-001.SDR CALA2025080407232Stringer · corrodedCORROSION FOUND AT AREA AFT OF AFT CARGO COMPT S-21R BETWEEN STA 967-986.5. ACCOMPLISHED CATEGORY A REPAIR AT STRINGER S-21R BETWEEN STA 967 AND 986.5 AS PER SRM 53-70-03-2R-1 AND SRM 53-00-03-2R-1 FIGURE 201 FOR DAMAGE ON STRINGER FREE FLANGE. NO FURTHER ACTSDR DALA2025080405803Oxygen Mask · unwanted deployOXYGEN MASK DEPLOYED, FLOW OF OXYGEN NOT RELEASED. CLOSED OXYGEN DOOR PER A320 AMM 35-21.SDR AALA202508030934Chiller · faultedAIRCRAFT WAS NOT GROUNDED: AFTER GALLEY CHILLER POWER CYCLING ON AND OFF AND NOT COOLING; FLIGHT ATTENDANTS SUSPECTED SLIGHT ELECTRICAL SMELL AND TURNED OFF CHILLER AND LEFT IT OFF. NO SMOKE OR PERSISTENT SMELL WAS REPORTED. (OPEN)SDR DALA2025080105794Wire · damagedATB DUE TO THE FLAPS BEING LOCKED BETWEEN POSITION 1 AND 2 WITH A FLAPS FAULT MESSAGE. REPLACED PIN ON WIRE 2751-5907R, REPLACED CONNECTOR 7505VC-B AND REPLACED PROX SENSOR 37CV.SDR DALA2025080105787Retainer · crackedCRACK ON BOTH GALLEY RETAINING BLOCKS ON COMPARTMENT OF 510M ON UPPER BLOCKS. REMOVED AND REPLACED RETAINING BLOCKS REF CMM PMC 68353751021-4050G-00001-01.SDR DALA2025080105786Shear Tie · gougedGOUGE SHEAR TIE LOCATED FR30 AND BTW STR41R TO STR42R IN FWD CARGO COMPARTMENT. REPLACED SHEAR TIE AS PER A319 SRM 51-42-11 AND A319 SRM 51-72-11.SDR DALA2025080105785Support Web · corrodedAFT FUSELAGE PASSENGER CABIN FLOOR STRUCTURE AREA BETWEEN FR68 AND FR69 AT Y-1362MM FLOOR SUPPORT WEB WITH CORROSION. REPLACED SUPPORT WEB LOCATED BTW FR68 AND FR69 AT Y-1362MM IAW A319 SRM TASK 51-72-11-911-001.SDR NACA2025080100001B-Nut · leakingDURING WALK AROUND FOUND LH ENG HAS OIL LEAK. FOUND LT AIR/OIL HEAT EXCHANGER VALVE RETURN TUBE LEAKING OIL. TIGHTENED RETURN TUBE B-NUT PER AMM 79-21-09SDR SWAA2025080196909Megaphone · inoperativeFWD MEGAPHONE INOPERATIVE.SDR SWAA2025080197393Scuff Plate · crackedAFT CARGO PIT CENTER THRESHOLD CRACKED AND DENTED. C/W CONDITIONAL INSPECTION REF AMM 05-51-59, NO DAMAGE NOTED. REMOVED AND REPLACED AFTER CARGO DOOR SCUFF PLATE PER AMM 53-11-02.SDR SWAA2025080196800Seat Back · out of adjustPASSENGER SEAT 11D RECLINES INTO EMERGENCY EXIT ROW. ADJUSTED PASSENGER SEAT 11D RECLINE CABLE PER CMM 25-21-42.SDR SWAA2025080196794Floor Panel · crackedAFT CARGO FLOOR PANEL 140BF WORN,CRACKED AND PREVIOUSLY REPAIRED. REMOVED AND REPLACED PER AMM 25-52-10-401-NG (CARGO FLOOR PANEL - REMOVAL/INSTALLATION - PERMANENT). AFT CARGO FLOOR PANEL 140BF.SDR SWAA2025080196908Megaphone · brokenAFT MEGAPHONE HAS BROKEN HANDLE. REMOVED AND REPLACED AFT MEGAPHONE PER AMM 25-64-00.SDR SWAA2025080197070Battery · no testAFT GALLEY LOWER F/O SIDE GREY FLASHLIGHT TEST RED. R & R AFT RT OTBD EMERGENCY FLASHLIGHT BATTERY IAW AMM 25-64-00.SDR SWAA2025080197011Flashlight · failedAFT CABIN FLASHLIGHT BLINKING RED. REMOVED AND REPLACED AFT GALLEY LEFT FA SEAT INBD FLASHLIGHT BATTERY PER AMM 25-64-00-900-805-MAX (FLASHLIGHT BATTERY REPLACEMENT (WITH FLASHING OR PUSH TO TEST - LED INDICATOR) - PERMANENT). OPS CHECK GOOD.SDR SWAA2025080197406Battery · no testCOCKPIT FLASHLIGHT WILL NOT TEST. R & R BATTERY REF AMM 25-64-00.SDR UIEA2025073101073First Aid Kit · openAIRLINE FIRST AID KIT FOUND TO BE UNSEALED DURING PRE-FLIGHT.(<P>R/R FIRST AID KIT PER AMM 25-64-50. NO FURTHER DEFECTS NOTED. THIS CLOSES MDDR 235175.</P>)SDR SIMA20250731001Unknown · odorVERY STRONG BURNING SMELL IN ENTIRE CABIN AND COCKPIT DURING FLIGHT AT FL270. EMERGENCY DECLARED. RAN ENG 1/ENG 2/APU BLEEDS AND PACKS 1 AND 2 WITH CREW TO ISOLATE BURN SMELL. RAN EACH PACK BY ITSELF ON EACH BLEED SYSTEM SEPARATELY FOR 15 MIN EACH (45 MIN TOTASDR ABXA20250731168Spring · out of toleranceLT FWD ENTRY DOOR OPENED ON LANDING WITH EICAS MESSAGE. UPON LANDING OBSERVED PSEU PROX SENSOR S195 TARGET WAS FLAGGED RESET TARGET FOUND GAP BETWEEN LOCK PIN AND PROX SENSOR S195 AT .059 IN. REMOVED DOORWAY LINING AND FOUND SPRING HYD SNUBBER OUT OF TOLERASDR YENA2025080100798Unknown · odorFLT#324, LAX-JFK. "DIRTY SOCK SMELL FORWARD GALLEY AND COCKPIT LEVEL 2 PER FOM; ACCOMPLISHED TSM 05-50-00-810-831-A PER INFO NOTICE 2017-T015L. ISOLATED PACK BURN FOUND NO SIGN OF ODOR. PERFORMED DUAL ENG RUN & ISOLATED BLEED. NO ABNORMALITIES OR ODOR NOTICED.SDR IPXA2025080126694Lever · bindingUPON CREW ENTRY DOOR CLOSURE, CAPTURE LEVER DIFFICULT TO MOVE OUTBOARD. INSPECTED CREW ENTRY DOOR HANDLE CAPTURE LEVER AND FOUND NO DEFECTS. OPERATED DOOR AND TESTED PER AMM 52-12-00-715-119. NO FAULT, DEFECTS OR EXCESSIVE FORCE WAS NOTED AT THIS TIME. OK FOR SDR WX0A2025080132522Flashlight · not seated(AIRCRAFT NOT GROUNDED) AFT FA FLASHLIGHT INOPERATIVE. AJUSTED FA FLASHLIGHT IAW SIP.OPS CHECK GOOD.SDR YENA2025080100797Battery · no testFLT#591, BOS-TPA. "EMERG LIGHT BATTERY FIN 13 WL FAILED TEST; REMOVED AND REPLACED EMER LIGHT BATTERY FIN 13WL IAW AMM 33-51-38"SDR YENA2025080100796Battery · no testFLT#591, BOS-TPA. "EMERG LIGHT BATTERY FIN 11WL FAILED TEST; REMOVED AND REPLACED EMERG LIGHT BATTERY FIN 11WL IAW AMM 33-51-38."SDR YENA2025080100795Battery · no testFLT#591, BOS-TPA. EMERG LIGHT BATTERY 12WL FAILED TEST; REMOVED AND REPLACED EMERG LIGHT BATTERY FIN 12WL IAW AMM 33-51-38.SDR YENA2025080100794Oil System · leakingFLT#2709, JFK-SDQ. INFLIGHT CREW COMPLAINED OF ODOR THROUGHOUT CABIN STARTING ON SHORT FINAL AND GETTING WORSE AFTER SHUTDOWN . APU NOT RUNNING AT START OF ODOR EVENT; AFTER SPEAKING TO FLT CREW, THEY CLARIFIED ODOR WAS NOTICE BY INFLIGHT AT GROUND WHEN TAXINGSDR YENA2025080100793Smoke Warning · false activationFLT#834, SFO-BOS. (ETOPS) SMOKE CLASS II MX MESSAGE; RESET SYS IAW AMM 26-17-00 OPS CHK GOOD MDDR CLEAR MX-4 UPDATED PLACARD REMOVEDSDR AALA202508010970Leg Assy · brokenAIRCRAFT IN BASE MAINTENANCE: M2 GALLEY AFT FACE RH CENTER EMER PROX LIGHT AND LENS COVER BROKEN. M2 GALLEY AFT FACE RH CENTER EMER PROX LIGHT ASSY AND LENS COVER REPLACED AND TESTED NORMAL AS PER AMM 33-51-05 REV 249 16 JUL 2025.SDR AALA202508013893Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT WON'T TURN OFF SEAL IS BROKEN. MAINTENANCE REPLACED FLASHLIGHT IN ATTENDANT FLIGHT CREW REST BUNKS IAW AMM 25-64-00.SDR AALA202508010091Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT IN F/A BUNK ROOM INOP. MAINTENANCE REPLACED EMERGENCY FLASHLIGHT IN F/A BUNK.SDR AALA202508019197Battery · dischargedAIRCRAFT WAS NOT GROUNDED: FA EMERGENCY FLASHLIGHT BATTERY INOP AT DOOR 2R AFT SEAT AND AFTGALLEY CENTER LEFT SEAT. MAINTENANCE REMOVED AND REPLACED FA EMERGENCY FLASHLIGHT BATTERIES AT DOOR 2R AFT SEAT AND AFT GALLEY CENTER LEFT SEAT IAW AMM 25-64-01.SDR DALA2025080105782Spar Web · damagedERA 628061-14 SECTION I ISSUED FOR REPAIR TO #2 PYLON FWD UPPER SPAR WEB AT POWER FEEDER CABLE CUTOUT. DAMAGED AREA REPAIRED PER ER/A 00-628061.SDR 2025F00171Oil System · low pressureDEPARTED GYH-ADS, AT FL180 PILOT NOTED SPARKS BY THE RT ENGINE AND THEN THE OIL PRESSURE WARNING LIGHT ACTIVATED AND PRESSURE GAUGE SHOWED 0. ENGINE WAS SHUTDOWN, ATC CONTACTED AND PERFORMED AN UNSCHEDULED LANDING AT THE NEAREST AIRPORT.SDR DALA2025080105771Light · brokenSEAT 39B EMERGENCY LIGHT HOLDER BROKEN. REPLACED PER A330 AMM 33-52. OK FOR SERVICE.SDR DALA2025080105770Bottle · low pressureDOOR 3R DID NOT SHOW ARMED ON FWD F/A PANEL DISPITE BEING ARMED AND SHOWING ARMED ON COCKPIT DOOR/OXY ECAM PAGE. SERVICED DOOR BOTTLE PER A330 AMM 52-15.SDR DALA2025080105767Bracket · misinstalledWAP #4 INSTALLATION, UPPER FWD BRACKET TO FR47, BRACKET FASTENERS ARE INCORRECT LENGTH. ALSO, BRACKET HAS TOOLING DAMAGE. REPAIRED PER A330 SRM 53-11 AND DRAWING F99235504.SDR DALA2025080105766Bracket · misinstalledFR53.6, STR 7 RT., VIEW D1-D2, INSTALLED BRACKET IS ON THE INCORRECT SIDE OF FRAME. INSTALLED BRACKET ON CORRECT SIDE OF FRAME. REF A330-900 DWG G5397629600000 AND A330 SRM 53-11.SDR DALA2025080105765Bracket · damagedCOAX BRACKET L/H AND ATTACHING HARDWARE HAS TOOLING DAMAGE BETWEEN FRAME 55. REPLACED BRACKET PER ERA 627776-14MT.SDR DALA2025080105764Bottle · low pressureDOOR 2R ASSIST BOTTLE REQUIRES SERVICING. SERVICED BOTTLE PER A330 AMM 52-15. OK FOR SERVICE.SDR YENA2025080100791Unknown · odorFLT#495, HPN-MCO. AFT FLIGHT ATTENDANTS REPORTED SMELL/ODOR OF GAS ON TAKEOFF AND LANDING; ACCOMPLISHED INFO-NOTICE 2017-T015L LEVEL 1 DEC. R&R HEPA FILTERS AS REQUIRED PER 21-26-43, LEAK CK GOOD. PERFORMED INSPECTION ON APU FOR SIGNS OF LEAKAGE, NO LEAKS FOUSDR AALA202508010248Shutoff Valve · failedAIRCRAFT WAS GROUNDED: ON TAXI OUT PARKING BRAKE WAS STUCK ENGAGED. THE PARKING BRAKE LIGHT ILLUMINATED AND ANTI-SKID INOPERATIVE LIGHT ILLUMINATED AS WELL. ALSO, PARKING BRAKE CIRCUIT BREAKER POPPED, RESET ONCE BUT CIRCUIT BREAKER POPPED AGAIN. UNABLE TO TAXISDR AALA202508016645Door · bindingAIRCRAFT WAS NOT GROUNDED: AFT LAVATORY-E DOOR IS DIFFICULT TO OPEN AND CLOSE. (OPEN).SDR SCNA20250731294Unknown · unknownEXCESSIVE PRESSURE AND NOISE FROM VENTS ON CLIMB OUT AT 10000 DIFFERENTIAL PRESSURE 2 PSI WITH CABIN CLIMB AT ZERO DUCT PRESSURE WAS 40 PSI BUT SAW IT FLUCTUATE TO AS HIGH AS 60 EXCESSIVE NOISE WAS IN THE WHOLE AIRPLANE. PERFORMED AMM 21-00-00 SUPPLY AIR TO CSDR DALA2025080105756Girt Bar · out of adjustL4 GIRT BAR DOES NOT ENGAGE DURING VISUAL CHECK. ADJUSTED GIRT BAR FEET IAW AMM 25-66.SDR DALA2025080105755Skin · crackedREPAIR TO RT WING UPPER SKIN COMMON TO DRAG FITTING ATTACHMENT REQUIRES SUPPLIMENTAL INSPECTIONS IAW ER/A 589741-14AD REV D. CRACK INDICATION WAS FOUND IN HOLE 6. REF ERA 589741-14AD.SDR SCNA20250731293Light · peelingROW 12 -FLOOR FLORESENT STRIPS PEELING UPWARDS-BOTH SIDES. REINSTALLED FLOOR FLORESENT STRIPS AT ROW 12 BOTH SIDES REF AMM 33-51-13.