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 AALA202507211928Elt · detachedAIRCRAFT WAS NOT GROUNDED: ELT HAS DETACHED FROM THE BULKHEAD. MAINTENANCE REINSTALLED ELT BACK ON BULKHEAD.SDR CALA2025072106798Probe · faultedREJECTD T/O 50-60 KIAS DUE TO SPLIT POWER SETTING W/ NO ECAM ITEM UPDATED WITH CURRENT P2T2 SENSOR. ENG #2 REPLACED AT ENG #2 , P2T2 SENSOR PER AMM 73-22-11/401 CONFIG 13 . ALL TEST OK.SDR CALA2025072106784Wire · pulledSEAT 30C EMERGENCY LIGHTING INOP - WIRE PULLED FROM PLUG REMOVED OLD PIN AND STRIPPED WIRE RE-CRIMPED NEW SOCKET ON TO WIRE AND INSTALLED IN CONNECTOR AT SEAT 30C REF AWM 33-51-08 PAGE 52A. INSTALLED LIGHT AT SEAT 30C REF TASK 33-51-19-400-002-A OPS CHECK GOODSDR CALA2025072106783Elec Connector · not seatedEMERGENCY EXIT LIGHT IN ROW 24 SEAT C NOT ILLUMINATING CHECKED CONNECTION, CONNECTION SECURE. RELAMPED EMERGENCY LIGHT IN ROW 24 SEAT C PER AMM TASK 33-51-19-000-002-A. NO HELP. RESEATED CONNECTOR OPS CHECKED GOOD.SDR CALA2025072106782Light · detachedEMER LIGHT HANGING OFF SEAT 11C SEAT 11C EMERGENCY TRIM NOT SECURE, FOUND CLIPS BROKEN. SECURED TRIM IN PLACE. EMERGENCY LIGHT OPERATES AT THIS TIME. PIC ADDED. REQUEST NEF 2522BV OK TO MEL COMPLIED WITH NEF 2522BV. NO HAZRARD TO PASSENGERS OR CREW. REMOVED ASDR CALA2025072106781Light · brokenSEAT 6D EMERGENCY LIGHT BROKEN. REPLACED PROXIMITY LIGHT.OPS CHKD NORMAL.SDR CALA2025072106780Light · broken29C EMERGENCY EXIT LIGHT BROKEN PLACED ON MEL OK TO MEL COMPLIED WITH MEL REMOVED AND REPLACED 29C EMERGENCY EXIT LIGHT REF AMM 33-51-18. OPS CHECK GOOD AT THIS TIME.SDR CALA2025072106779Power Supply · no testOPERATIONAL CHECK OF THE EMERGENCY POWER SUPPLY UNITS BY BITE-CHECK EMERGENCY LIGHTS FAIL TEST AT CIDS PANEL. FAULT EPSU INT LOAD FWD L ATA 33-51-38. CYCLED BREAKERS NO HELP. REMOVED CEILING PANEL AT DOOR 1 LEFT. DID TEST OF LIGHTING BOX FAULTING INTERIOR LIGSDR CALA2025072106778Lamp · no testLEFT WING OVERWING REAR EXTERIOR EMERGENCY LIGHT IS NOT COMING ON DURING TEST CHECK RELAMPED , OPS CHECK GOOD.SDR CALA2025072106777Elec Connector · damagedEMERGENCY EXIT LIGHT OVERHEAD IN ROW 27 SEAT C NOT ILLUMINATING CHECKED CONNECTION, CONNECTION SECURE. NEEDS MORE TROUBLESHOOTING RELAMPED LIGHT BULBS FOR OVERHEAD EMERGENCY LIGHT IN ROW 27 SEAT C REF IPC 33-51-11-01. NO HELP. REINSTALLED 2 EACH PINS IN THE CSDR CALA2025072106756Shear Tie · gougedINBD AND OTBD FWD UPPER SKIN SUPPORT FLANGES HAVE PREVIOUS GOUGES PR ESENT AND REQUIRE REPLACEMENT. REMOVED AND REPLACED I/B AND O/B FWD UPPER SKIN SUPPORT ANGLES I AW A319 SRM 51-42-11-01.SDR CALA2025072106755Bracket · crackedAFT CARGO FR 850, S22L BRACKET CRACKED AT BULKHEAD PANEL SUPPORT. REMOVED AND REPLACED GUSSET 143N5812-15 AT STA 850 S22.L IAW SRM 51-40-02-0G-0.SDR CALA2025072106754Channel · corrodedFWD CARGO RIGHT SIDE "Z" CHANNEL IS CORRODED FROM 500D TO 500. REMOVED AND REPLACED FWD CARGO RIGHT SIDE "Z" CHANNEL FROM STA 500B+10 TO STA 500I PER SRM 51-40-02-0G-0 AND DWG#143A7500SDR CALA2025072106753Rib · crackedRT HORIZ STA RIB STA 92.70 STIFFENER #4 WITH CRACK AT LOWER TRANSITION RADIUS. ACCOMPLISHED REPAIR AT RT HORIZ STA RIB STA 92.70 STIFFENER #4 PER SRM 55-10-09-2R-4 .SDR CALA2025072106752Rib · crackedRT HORIZ STA RIB STA 92.70 STIFFENER #3 WITH CRACK AT LOWER TRANSITION RADIUS. REF AAR N/R 9987976 ACCOMPLISHED REPAIR AT RT HORIZ STA RIB STA 92.70 STIFFENER #3 PER SRM 55-10-09-2R-4SDR CALA2025072106751Battery Pack · no testBATTERY PACK M1675 OPERATION TEST FAILED (REF. AAR NR 1000042537 ). REMOVED AND REPLACED EMERGENCY BATTERY PACK M1675 AT LH FWD ENTRY LOWERED CEILING PANEL IAW B737 AMM 33-51-06-960-805 OPS TEST GOOD.SDR CALA2025072106749Idg · faultyIN FLT AT FL330 LEFT GEN DRIVE EICAS LT CAME ON. 30 SEC LATER LE FT GEN DISCONNECTED. DEBRIEFED CREW - IN CRUISE APPROX FL310 NR. 1 GEN DRIVE EICAS MESSAGE AND LIGHT ILLUMINATED. GEN AUTOMATICALLY DISCONNECTED. BPCU BITE INDICATES MULTIPLE FAULTS, INCLUDING HSDR FDEA202507181264Lamp · failedDEBRIEF WITH CREW OVERHEAD EMERGENCY LIGHT OVER THE GALLEY NOT WORKING. REMOVED AND REPLACED THE LAMP PER AMM 33-51-03-2. PERFORMED THE EMERGENCY LIGHTS OPERATIONAL TEST PER AMM 33-51-00-5, TEST OK, ALL EMERGENCY LIGHT FUNCTION NORMAL.A/C OK FOR SVC.SDR FDEA202507181263Seat Track · corrodedFLIGHT COMPT SEAT TRACK BETWEEN BS 345.0 TO 365.0 LBL 7.0 WITH CORROSION.SDR FDEA202507181262Seat Track · corrodedFLIGHT COMPART SEAT TRACK BETWEEN BS 345.0 TO BS 365.0 RBL 14.5 WITH CORROSION.SDR FDEA202507181261Floor Panel · dentedDENT ON FLOOR PANEL 241ZFF UPPER SURFACE, MAIN DECK CARGO COMPT. FLOOR PANEL 241ZFF UPPER SURFACE, MAIN DECK CARGO COMPT. WAS REPAIRED IAW SRM 53- 00-50-2R PAR 4.B FIG 201 SHEET 2 REV. 92 APR 15, 2025SDR FDEA202507181260Floor Panel · crackedCRACK ON FLOOR PANEL 231NFF AT MDC SEC 43. FLOOR PANEL 231NFF AT MDC SEC 43 WAS REPAIRED IAW SRM 53-00-50-2R PAR 4B FIG 201 SHEET 2 REV. 92 APR 15, 2025SDR FDEA202507181259Floor Panel · crackedPUNCTURES ON FLOOR PANEL 241KFF UPPER SURFACE, MAIN DECK CARGO COMPT. FLOOR PANEL 241KFF UPPER SURFACE, MAIN DECK CARGO COMPT. WAS REPAIRED IAW SRM 53- 00-50-2R PAR 4B FIG 201 SHEET 2 REV. 92 APR 15, 2025SDR FDEA202507181258Floor Panel · crackedPUNCTURES ON FLOOR PANEL 241DFF UPPER SURFACE, MAIN DECK CARGO COMPT. FLOOR PANEL 241DFF UPPER SURFACE, MAIN DECK CARGO COMPT. WAS REPAIRED IAW SRM 53- 00-50-2R PAR 4B FIG 201 SHEET 2 REV. 92 APR 15, 2025SDR FDEA202507181257Floor Panel · dentedDENTS ON FLOOR PANEL 242HFF UPPER SURFACE, MAIN DECK CARGO COMPT. FLOOR PANEL 242HFF UPPER SURFACE, MAIN DECK CARGO COMP. WAS REPAIRED IAW SRM 53- 00-50-2R PAR 4B FIG 201 SHEET 2 REV. 92 APR 15, 2025SDR FDEA202507181256Floor Panel · dentedDENT ON FLOOR PANEL 242UFF UPPER SURFACE, MAIN DECK CARGO COMPT. FLOOR PANEL 242UFF UPPER SURFACE, MAIN DECK CARGO COMPT. WAS REPAIRED IAW SRM 53- 00-50-2R PAR 4B FIG 201 SHEET 2 REV. 92 APR15,2025SDR FDEA202507181255Floor Panel · crackedSEVERAL DENTS WITH CRACK OF FLOOR PANEL 241WFF AREA OUTERSIDE ON MAIN DECK CARGO COMPARTMENT. FLOOR PANEL 241WFF AREA OUTERSIDE ON MAIN DECK CARGO COMPARTMENT WAS REPAIRED IAW SRM 53-00-50-2R PAR 4B FIG 201 SHEET 2 REV. 92SDR FDEA202507181254Floor Panel · puncturedONE PUNCTURE OF FLOOR PANEL NO. 242TFA AREA OUTERSIDE ON MAIN DECK CARGO COMPARTMENT. FLOOR PANEL 242TFA AREA OUTERSIDE ON MAIN DECK CARGO COMPARTMENT WAS REPAIRED IAW SRM 53-00-50-2R PAR 4B FIG 201 SHEET 2 REV 92 APR 15, 2025SDR UIEA2025071800971Battery Pack · failedRIGHT SUPERNUMERARY FLASHLIGHT BLINKING RED. REMOVED AND REPLACED RT FLASHLIGHT BATTERY PACK IAW AMM 25-64-01. OPS CHECK GOOD. THIS ACTION CLEARS DMI 234387. PLACARDS REMOVED.SDR UIEA2025071800976Oxygen Mask · dislodgedOXYGEN MASK IN LAV FELL OUT.(<P>LAV OXYGEN MASK PACKED IAW AMM 35-23-01-400-802. OPS CHECK SATISFACTORY.</P>)SDR DALA2025071905437Oil System · leakingAIRCRAFT 5030, FA REPORTS DIRTY SOCK SMELL IN CABIN DURING DESCENT AT 8000 FT. ENGINES WERE AT IDLE. FOUND OIL PUDDLED IN LOW PRESS COMPRESSOR SECTION 6 OCLOCK POSITION AS WELL AS SMALL AMOUNT OF OIL IN SPINNER ON ENG 2. REPLACED NBR 2 ENGINE. (LP 7094092)SDR QMLA2025071820075Unknown · odorNURSES REPORTED AFTER TAKING OFF FROM GOODYEAR AIRPORT AFTER GETTING FUEL AFTER A PR EVENT THAT THEY NOTICED A STRONG FUEL SMELL. THEY CONTINUED ON TO THE HELIPAD AT ABRAZO WEST AND LANDED SAFELY. I ARRIVED AT THE HELIPAD AND PERFORMED A INSPECTION OF THE HELISDR DALA2025071805431Lever · bindingSHIP 3116 ENTRY DOOR ARMING LEVER HARD TO OPERATE, MISSING THE NUT TO HOLD IT TO THE SILVER HANDLE. IT IS OPERABLE BUT IT FALLS OFF WHEN IN THE DISARMED POSITION AND SOMEONE BUMPS INTO IT.. INSTALLED NEW NUT IAW A319 AMM 52-11. (1091409).SDR DALA2025071805432Waste Tank · fullSHIP 1806 -DIV- TO JFK DUE TO 5 OF 6 LAVS INOP. LH LAV TANK FULL CAUSING ALL LH LAVS INOP. 2 RH LAVS ON MEL LEAVING ONLY 1 LAV WORKING. UNABLE TO CONTINUE. SERVICED TANK FOR LH LAVS. REPLACED CRACKED AFT WASTE TANK DUCT FOR LH LAVS. (LP 7507025)SDR IPXA2025071893228Skin · crackedRIGHT INBOARD ELEVATOR CRACKED IN UPPER LEFT HAND CORNER. MARKED WITH TAPESDR IPXA2025071889332Fire Warning · false activationFIRE CARGO FWD INTERMITTENT DURING INITIAL CLIMB. DISPLAYED LESS THAN 1 SECOND EACH TIME CREW RAN CARGO AIR CONDITIONING SYSTEM HEAT THROUGHOUT FLIGHT, FAULT DID NOT RETURN. ++PERFORMED OPERATIONAL CHECK IAW MM 26-16-00. OPS CHECK GOOD. PER FIM 26-16 TASK 81SDR WX0A2025071832504Battery Pack · no test(AIRCRAFT NOT GROUNDED) CABIN EMERGENCY LIGHTING CHECK BATTERY CAPACITY FAILED / PER NOTE ON TC-A32X-335100-03-1-001, REMOVED AND REPLACED EPSU BATTERIES IAW AMM 33-51-38-000-001-A AND 33-51-38-400-001-A. OPS CHECK GOOD"SDR DALA2025071805420Pan · crackedAIRCRAFT 9572, DURING HCK AT QRO, WHILE PERFORMING AN AFT LOWER CARGO DOOR INSPECTION PER WC 5231-2004, SEVEN (7 QTY) CRACKS WERE FOUND AFFECTING THE AFT CARGO DOOR INNER PAN AFT EDGE AT STOPS #1, # 3 & 5. ADDITIONALLY, A GOUGE WAS FOUND BETWEEN STOP FITTINGS SDR R61A2025071800313Stringer · corrodedWHILE IN HEAVY CHECK - AFT CARGO STGR 29R SHOWS SIGNS OF CORROSION. PERFORMED SPLICE REPAIR ON STINGER 29R REF ETD2025-170-924028.SDR YENA2025071800733Fire Loop · failedFLT#354, DUB-JFK. (ETOPS) ENG 1 FIRE LOOP B ( ENGINE FIRE DETECTION SYSTEMS 2) LOOP B ); REF LOGPAGE 4353751 ITEM #1 FOR REMOVED AND REPLACED OF AFT FIRE LOOP ASY REMOVED AND REPLACED. MDDR CLEARED DUE TO NO FAULTS SINCE THE LOOP HAS BEEN CHANGED. MX-4 UPDATESDR QR9R2025071800001Recorder · faultySLAB BATTERY WOULD NOT STAY CHARGED AFTER BEING REPLACED SEVERAL TIMES. TROUBLESHOOTING REVEALED THE FA5001 CVFDR HAD A CONTINUOUS DRAIN ON ACFT SLAB BATTERY, EVEN WHEN SYSTEM WAS TURNED OFF. REMOVED AND REPLACED CVFDR IAW AMM 31-32-00, 4-1.SDR IXXA20250718001Floor Support · crackedUPPER CABIN FLOOR SUPPORT BETWEEN STA. 480 AND STA. 500, B.L. 0 IS CRACKED AT SEVERAL NUTPLATES, LOCATED ABOVE E3 SHELVES IN MECSDR N3XR20250718475Hinge · crackedDURING A ROUTINE INSPECTION, THE LOWER RUDDER HINGE FITTING WAS FOUND CRACKED ON THE LOWER PORTION AROUND EACH CORNER BETWEEN RIVET HOLESSDR N3XR202507180476Hinge · crackedDURING A ROUTINE INSPECTION, THE LOWER RUDDER HINGE FITTING WAS FOUND CRACKED ON THE LOWER PORTION AROUND EACH CORNER BETWEEN RIVET HOLESSDR FDEA202507181253Longeron · misrepairedEXISTING REPAIR AT CENTER CARGO LONGERON BETWEEN STATION 1531 TO STATION 1551, LONGERON 50R RIGHT HAND SIDE. EXISTING REPAIR AT CENTER CARGO LONGERON BETWEEN BS 1531 - 1551, LONGERON 50 RIGHT RIGHT HAND SIDE EVALUATED AND FOUND WITH MISSING STEPS IN WORK SDR FDEA202507181252Seat Track · wornCABIN - RIGHT HAND STATION 1452 X= -47.5 SEAT TRACK CROWN WORN. CABIN Ï¿½ RIGHT HAND AT SEAT TRACK STATION 1452 X = -47.5 WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIT AS PER MD-11 SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1. CROWN WORN SEAT TRACK REPAIRSDR FDEA202507181251Seat Track · wornCABIN FLOOR SEAT TRACK FOUND CRACK FOUND CRACK AT STATION 808 X= 27.50. CABIN FLOOR SEAT TRACK AT STATION 808, X = 27.5 CRACKED CROWN EVALUATED AND FOUND EXCEEDED LIMIT AS PER MD-11 SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1. CROWN CRACKED SEAT TRACK RESDR FDEA202507181250Seat Track · wornCABIN - LEFT HAND STATION 5-83 X= 8.5 SEAT TRACK CROWN WORN. CABIN-LEFT HAND AT SEAT TRACK STATION 5-83, X= 8.5 WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIT AS PER MD-11 SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1. CROWN WORN SEAT TRACK REPAIRED BY SECTSDR FDEA202507181248Doubler · crackedLEFT WING, FIXED LEADING EDGE LOWER DOUBLER FOUND CRACKED ABOUT 1 INCH AT XOS 487.5. CRACKED DOUBLER REMOVED IAW SRM 51-35-01-0G & SRM 51-33-01-0G. DOUBLER FABRICATED IAW DRAWING ARB2933, REV AJ & INSTALLED IAW SRM 51-33-01-0G & SRM 51-35-01-0G. REPAIR CLASSDR FDEA202507181247Seat Track · wornCABIN - LEFT HAND STATION 1551 X= 27.5 SEAT TRACK CROWN WORN. CABIN-LEFT HAND AT SEAT TRACK STATION 1551, X= 27.5 WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIT AS PER MD-11 SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1. CROWN WORN SEAT TRACK REPAIRED BY SE