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 SWAA2025071089967Lens · detachedCENTER ISLE; MID CABIN OVERHEAD EXIT SIGN WAS KNOCKED OFF. RE-INSTALLED LENS PER SIP.SDR SWAA2025071089427Handle · looseFWD GALLEY SERVICE DOOR R1 UPPER ASSIST HANDLE IS LOOSE.<[01] TIGHTENED FWD GALLEY SERVICE DOOR R1 ASSIST HANDLE PER AMM 52-11-31SDR SWAA2025071089685Battery · inoperativeAFT GALLEY CA SIDE INBOARD FLASHLIGHT BLINKING RED. REMOVED AND REPLACED BATTERY IN AFT CA INBOARD FLASHLIGHT PER AMM 25-64-00; OPS CHECK GOOD.SDR SWAA2025071089637Holder · looseAFT CARGO DOOR GIRT BAR HOLDER LOOSE<[01] ADJUSTED R2 SERVICE DOOR GIRT BAR HOLDER TENSON PER SIP. PILOT WRITEUP SHOULD OF BEEN FOR R2 NOT AFT CARGOSDR DALA2025071005217Battery Pack · inoperativeAIRCRAFT 9549, BOTH EXTERIOR OVERWING EMERGENCY EXIT LIGHTS INOP. CORRECTIVE ACTION: REPLACED OVERWING EMERGENCY EVACUATION BATTERY POWER SUPPLY PER B717 AMM 33-51. OPS CHECK GOOD. (LP 7315329)SDR 21GA20250709015Target · out of positionAFTER LIFT OFF RECEIVED LE SLAT ASSYMETRY MESSAGE. RETURNED TO THE FIELD.SDR GTIA2025071038988Battery · inoperativeREMOVED EPSU BATTERY DUE TO FAILURE-R/R EPSU BATTERY IAW AMM 33-51-38SDR IPXA2025071043612Skin · damagedCREW DOOR UPPER INNER SKIN HAS BARE METAL EXPOSED.SDR IPXA2025071041352Fastener · corrodedALL FASTENERS AROUND CREW DOOR EXTERNAL SURFACE CORRODED.SDR AALA202507104635Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND ECS BAY AFT BULKHEAD INBOARD SIDE UPPER CHORD AT STA 663, FROM RBL 5 TO RBL 15. REPAIRED CHORD PER SRM 57-10-10-2R-5.SDR DALA2025071005206Light · no discrepancySHIP 3144 CABIN EMERGENCY OVERHEAD LIGHTS FLICKERING. CORRECTIVE ACTION: COULD NOT DUPLICATE FAULTS REF A319 AMM 33-50. (1072488).SDR DALA2025071005203Floor Support · corrodedSHIP 3146 NOSE FORWARD FUSELAGE, PASSENGER CABIN AT FR20 Y-1662MM FLOOR SUPPORT WITH CORROSION. CORRECTIVE ACTION: REPLACED PASSENGER CABIN FLOOR SUPPORT WEB FROM FR20 TO FR24 AT Y-166MM IAW A319 SRM 51-72-11-911-001. (1072574).SDR DALA2025071005202Access Panel · corrodedSHIP 3146 ENG 1 ACCESS PANEL 472BR SEAL RETAINER WITH CORROSION. CORRECTIVE ACTION: REPLACED SEAL RETAINER IAW A319 SRM 51-72-11 -911-001. (1072850).SDR AALA202507101225Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #2 HINGE FITTING HAS EXCESSIVE PLAY / WORN. REPLACED HINGE FITTING PER AMM 55-16-42.SDR AALA202507106837Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #5 HINGE FITTING HAS EXCESSIVE PLAY / WORN. REPLACED HINGE FITTING PER AMM 55-16-42.SDR AALA202507109344Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #4 HINGE FITTING HAS EXCESSIVE PLAY / WORN. REPLACED HINGE FITTING PER AMM 55-16-42.SDR AALA202507104163Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #1 HINGE FITTING HAS EXCESSIVE PLAY / WORN. REPLACED HINGE FITTING PER AMM 55-16-42.SDR AALA202507100786Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #6 HINGE FITTING HAS EXCESSIVE PLAY / WORN. REPLACED HINGE FITTING PER AMM 55-16-42.SDR AALA202507108544Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #3 HINGE FITTING HAS EXCESSIVE PLAY / WORN. REPLACED HINGE FITTING PER AMM 55-16-42.SDR AALA202507107202Power Supply · no testAIRCRAFT IN BASE MAINTENANCE: EMERGENCY POWER SUPPLY UNIT 14WL INOPERATIVE. REPLACED EMERGENCY POWER SUPPLY UNIT 14WL AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR AALA202507102175Module · false indicationAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: WHEN LANDING GEAR PLACED IN DOWN POSITION WE HAD AN AURAL INDICATION AS WELL AS 3 RED AND 3 GREEN LIGHTS. AIRCRAFT PERFOMED A GO AROUND AND LANDED SAFELY AT LGA. PARTIAL WORK ACCOMPLISHED. REMOVED AND RESDR AALA202507105940Slide · dislodgedAIRCRAFT WAS NOT GROUNDED: L1 DOOR SLIDE YELLOW PART SHOWING AT THE BOTTOM OF THE DOOR. REPOSITIONED SLIDE L1.SDR AALA202507101995Sign · incorrectAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT SAYS DURING DEPLANING THEY NOTICED THE R1 DOOR EXIT SIGN ABOVE THE DOOR APPEARS TO BE INCORRECT SIGNAGE. INSTALLED NEW EXIT SIGN. PER AMM 33-51-01.SDR AALA202507107803Sign · unsecureAIRCRAFT WAS NOT GROUNDED: EXIT SIGN OVER THE FORWARD SERVICE DOOR FELL OFF. RESECURED EXIT SIGN OVER THE FORWARD SERVICE DOOR. PER AMM 33-51-02.SDR DALA2025071005197Indicator · inoperativeR1 DOOR KNUCKLE KNOCKER NOT COMING OUT. CORRECTIVE ACTION: CLEANED UPPER EDGE ON KNOCKER OP CKS OK PER B757 AMM 52-11. (7470616)SDR 3EJA2025071000925Cabin Pressure · leakingSHORTLY AFTER BEGINNING OUR DESCENT FROM 45,000 FT. I LOOKED DOWN AT THE PRESSURE CONTROLLER AND CABIN ALTITUDE GAUGE AND NOTICED A CABIN CLIMB OF GREATER THAN 1,000 FPM AND INCREASING WHILE THE CABIN ALTITUDE GAUGE WAS COINCIDING WITH DECREASING PRESSURIZATIOSDR CALA2025071006428Fastener · missingEMPENNAGE EXTERIOR SURFACES CORROSION PREVENTION AND CONTROL PROGRAM (CPCP) INSPECTION {MULT-55-3-0001} - EMERGENCY LIGHT AFT OF R2 DOOR MISSING 1EA FASTENER. REPLACE LIGHT ASSY PER AMM 33-51-04 960-802. OKAY FOR SERVICE UPDATED FOR SDR REPORTABLESDR CALA2025071006427Handle · unlatchedDOOR 1L ON LDG HANDLE CAME UP FOUND MINOR PLAY ON INSIDE DOOR HANDLE 1L. SECURED AFT NUT AND INSTALLED NEW COTTER PIN, REF AMM 52-11-31-020-013. DOOR OPEN AND CLOSE OPERATION NORMAL. INSPECTED CASTELATED NUTS AND COTTER PINS ON INNER DOOR HANDLE, FOUND SECUREDSDR CALA2025071006426Stringer · crackedDURING OPEN HOLE HFEC INSPECTION OF NR 2731310 WAS FOUND CRACK HOLE INDICATION AT STGR 39LH AND STA 1395 PERFORMED INSPECTION. PERFORMED PERMANENT REPAIR AT STRINGER S-39L BTW STA1395 AND STA1417 AS PER ECRA 5360-01975. PERMANENT REPAIR AT STRINGER S-39L BTW SDR CALA2025071006425Floor Support · corrodedAFT CARGO FLOOR FR 58-FR 59 STR38 PROFILE PANEL HAS CORROSION. REMOVED AND REPLACED CORNER SECTION IN AFT CARGO FR 58-FR59 STR 38R IAW 51-42-11/001 51-44-11/001 51-42-11/001SDR CALA2025070906413Lamp · faultedEMERGENCY LIGHT ON LEFT AISLE SEAT ROW 25 INOP. REPLACED EMERGENCY LIGHT OUTLET PIG TAIL REF AMM 33-51-11.SDR CALA2025070906412Lamp · faultedR1 DOOR SLIDE EXTERIOR EMERGENCY LIGHT INOP. RELAMPED R1 DOOR SLIDE EXTERIOR EMERGENCY LIGHT AS REQUIRED. OPS CHECK GOOD. REF AMM 33-51-04. OK TO CONTINUE.PARTS USED: 99-3351-3-0014,QTY :1SDR CALA2025070906408Unknown · smokeON T/O ROLL, SMOKE WITH BURNING ODOR CAME FROM CA SIDE AIR VENTS. R EJ T/O AND SMOKE DISSIPATED CREW ADVISED LOW SPEED ABORT LESS THAN 20 KTS. PER FODM CAPTAIN REPORTED RTO BETWEEN 100 AND 110 KTS. PERFORMED SMOKE CABIN/FLIGHT DECK CONDITIONAL INSPECTION. REFSDR CALA2025070906407Potable Water · odorFA REPORTS POTABLE WATER SMELLS LIKE CHEMICALS. POTABLE WATER SYS DRAINED AND FILLED WITH FRESH WATER, WATER FLUSHED THROUGH ALL GALLEY COFFEE MKRS AND TAPS, SYS SERVICED SATIS IAW AMM 38-11-00 REV 136SDR IXXA20250709028Light · no testCREW PRE-FLIGHT, SLIDE LIGHT AT R4 DOOR DOES NOT ILLUMINATE. CLEANED GIRT BAR SLIDER STOP. OPERATIONAL CHECK IAW B767 AMM 52-11-25 NOTED NO FAULTS.SDR SIMA20250709001Housing · detachedSLIDE HOUSING BROKE AWAY FROM CABIN DOOR L1 UPON CLOSING. REF AML PAGE 104700936 MEL 2553 - AUTH# 07-489D-C REPAIR C - POSITION L1 - FMR 05925027E - MEL DEFERRAL - CATEGORY C RAR L1 EMERGENCY EVACUATION DOOR SLIDE ASSEMBLY IAW AMM 25-65-01 MEL RESTOREDSDR AALA202507103547Sign · dislodgedAIRCRAFT WAS GROUNDED: EXIT SIGN NEAR 2R IS FALLING DOWN. MAINTENANCE REPLACED EXIT SIGN 2R IAW AMM 33-51-00.SDR AALA202507100783Light · brokenAIRCRAFT WAS NOT GROUNDED: SEAT 31D EMERGENCY EXIT AISLE LIGHTING BROKEN. REPLACED SEAT 31D EPL PER AMM33-51-06.SDR AALA202507106424Modulating Valve · faultedAIRCRAFT WAS NOT GROUNDED: FLIGHT DIVERTED DUE TO UNCONTROLLABLE AFT CABIN TEMP FROM ROW 26-40 ZONE F TRIM SHOWS FAILED. AIRCRAFT LANDEDED OVERWIGHT AND AN EMERGENCY DECLARE. LAMNDED WITHOUT INCIDENT. MAINTENANCE REPLACED ZONE "F" TRIM AIR MODULATING VALVE IAWSDR FDEA202507091163Floorboard · damagedMAIN DECK FLOOR PANEL 241JFF HAS MULTIPLE DEEP PUNCTURES. FABRICATED MAIN DECK FLOOR PANEL 241JFF (MPN: 145T5876-107) AT STA 825 - STA 930, LBL 77.50 TO LBL 54.75 IN REF TO BOEING DRAWING 145T5876-107. SEE JPF FOR ALL STEPS ACCOMPLISHED. THIS IS A MAJOR REPASDR DALA2025071005196Elec Connector · disconnectedSHIP 3327 - DE - DUE NOSE WHEEL STEERING FAULT AFTER TAKEOFF. CORRECTIVE ACTION: MTC RECONNECTED ELECTRICAL CONNECTOR 6GC-A. OPS CHECK GOOD. (7317191)SDR FDEA202507091162Floor Panel · dentedMAIN DECK FLOOR PANEL 241WFF PUNCTURED MULTIPLE LOCATIONS. FABRICATED MAIN DECK FLOOR PANEL 241WFF MPN: 145T5876-51 AT BS 980-1114.82 LBL 11- RBL 11 IAW DWG 145T5876-51. SEE JPF FOR ALL WORK STEPS ACCOMPLISHED THIS IS A MAJOR REPAIR. INSTALLATION OF FLOORPANESDR FDEA202507091161Seat Track · wornCABIN-SEAT TRACK AT STATION 1541 X = 47.5 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 1541, 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 REPAIRED BY SECTIONAL SEASDR FDEA202507091160Seat Track · wornCABIN-SEAT TRACK AT STATION 1293 X = 47.5 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 1293, 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 REPAIRED BY SECTIONAL SEASDR FDEA202507091159Seat Track · wornCABIN-SEAT TRACK AT STATION 1293 X = 27.5 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 1293 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 SECTIONAL SEATSDR FDEA202507091158Seat Track · wornCABIN-SEAT TRACK AT STATION 1293 X = 8.5 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 1293, 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 SECTIONAL SEAT SDR FDEA202507091157Seat Track · wornCABIN-SEAT TRACK AT STATION 1293 X = -8.5. FOUND CROWN WORN.SDR FDEA202507091156Seat Track · wornCABIN-SEAT TRACK AT STATION 5-20 X = -8.5 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 5-20, 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 SECTIONAL SEASDR FDEA202507091155Seat Track · wornCABIN-SEAT TRACK AT STATION 1421 X = -8.5 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 1421, 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 SECTIONAL SEASDR FDEA202507091154Seat Track · wornCABIN-SEAT TRACK AT STATION 1421 X = -27.5 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 1421, 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 SECTIONAL S