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 DXTA2025080504448Battery · dischargedEMERGENCY LIGHTS STARTED FLICKERING DURING CRUISE. SWITCHED LIGHT TO OFF POSITION FOR 1 MIN, BACK TO ARM, & LIGHTS STARTED FLICKERING AGAIN AFTER 30 SECS. ACCESSED FWD & AFT BATTERY. DURING ACCESS & BEFORE MAINT PERFORMED, FOUND THE EMER LIGHT CLL ON, RESETSDR HALA20250804044Hydraulic System · contaminatedREJECTED T/O 8L DUE TO R HYD HIGH TEMP. UNABLE TO MITIGATE W/ MOVEMENT OF FLT CONTROLS / SPOILERS. PERFORMED FIM 29-30 TASK 803. FOUND EXCESSIVE AIR IN R HYD SYSTEM. BLEEDED AIR FROM SYSTEM AS REQUIRED. OPS CHECK GOOD. FAULT FOUND TO BE INTERMITENT. NO DEFECTSSDR HALA20250804043Light · inoperativeFLOOR LIGHTING STRIP A BEAM SEAT 46B CRACKED. REPLACED BROKEN ILLINOUS PATH LIGHT ON STATED AREA.OK FOR SERVICED.SDR KY7A2023080500038Wire · damagedLEFT ENGINE FIRE LIGHT ERRONEOUSLY ON DURING SHORT FINAL FOR 3 SECONDS & AGAIN DURING TAXI FOR 3 SECONDS. REPAIRED WIRING TO LH ENGINE FIRE DETECTOR OPS CHECK GOOD PER SA227 AMM CH 26-10-10 RTS CHECK COMPLETED. F7536SDR FDEA202508021365Light · malfunctionedEMERGENCY LIGHTS ILLUMINATED DURING BEFORE START CHECKLIST. AMM 33-51-00-5 FOUND EMERGENCY LIGHT SWITCH AT THE OVERHEAD PANEL IN THE OFF POSITION. SWITCH PUT BACK TO ARM POSITION AND OPERATIONAL TEST PERFORMED IAW AMM 33-51-00-5SDR AALA202508055588Sensor · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING APPROACH FLAPS HAD ASYMMETRY. AIRCRAFT EMERGENCY LANDED SAFELY AT DTW. FSEU SHOWS MM 27-53256 IN FAULT HISTORY. INTERMITTENT ON FSEU. REMOVE AND REPLACED FLAP SKEW 7 SENSOR. PER AMM 27-59-01 AND FSDR AALA202508058209Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER ATTACH ANGLE AT STA 663, LBL 66. REPAIRED PER SRM 57-10-10-2R-5.SDR AALA202508055618Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER ATTACH ANGLE AT STA 663, RBL 23. REPAIRED PER SRM 57-10-10-2R-5.SDR AALA202508053303Door · bindingAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS DOOR STICKING IN RIGHT AFT LAVATORY REMOVED AND REPLACED RIGHT AFT LAVATORY DOOR. PER CMM 25-40-65. OPERATIONAL CHECK GOOD.SDR CALA2025080507325Flange · wornLH BODY-TO-VERTICAL FIN FAIRINGS FLANGE BROKEN. REMOVED AND REPLACED LH BODY TO VERTICAL FIN FAIRINGS FLANGE IAW SRM 51-40-02-0G-0 AND DWG 147A0030.SDR CALA2025080507324Skate Angle · wornCRACK FOUND ON FWD RT BODY-TO-VERTICAL FIN FAIRINGS FLANGE. . REMOVED AND REPLACED SKATE ANGLE AT FWD RT BODY TO VERTICAL FIN FAIRING REF SRM 51-40-02-0G-0 AND DWG 147A0030 .SDR GTIA2025080439031A/C Pack · odorDESCENDING THROUGH 8000" FUMES WERE NOTICED. PACKS 1 & 2 TURNED OFF- SMELL WENT AWAY. ON THE GROUND WE TURNED APU BLEED W/PACK 1 THE SMELL RETURNED. WITH PACK 2- NO ODOR. DESCRIPTION OF ODOR/FUMES: TEMPORARY, DIRTY SOCKS SMELL. APPARENT CABIN SOURCE: CABIN AIRSDR GTIA2025080439030Unknown · odorPOSSIBLE AIR QUALITY EVENT REPORTED BY THE AFT FAS SKUNK SMELL DURING CLIMB AND DESCENT. AIR QUALITY EVENT FORM FILLED OUT-ACCOMPLISHED TSM 05-50-00-810-831-A NO FURTHER ODOR FOUND AT THIS TIME A/C OK FOR SERVICE MOC 119918 ODOR IDENTIFIED AS TYPE 10. VERSDR GTIA2025080439029Flashlight · inoperativeCAPT SIDE FLASHLIGHT INOP ( FLASHLIGHT AND HOLDERS (FLIGHT DECK OR CABIN) )-R&R CAPT SIDE FLASHLIGHT, REF AMM 25-65-00 & DWG TITLE A320 EMERGENCY EQUIPMENT LAYOUT DWG # A320-EMER EQUIP RV7 OPS V GOOD. OK FOR SVC. THIS CLEARS DMI # 3520026-1. PLACARD REMOVED DMSDR DALA2025080405849Skin · damagedSHIP 3416 STRINGER 1R AND FUSELAGE SKIN FWD OF FRAME 60 TOOLING DAMAGE. CORRECTIVE ACTION: COMPLIED WITH ERA 627536-14 REV B. (1120906)SDR DALA2025080405848Frame · damagedSHIP 3416 TOOLING DAMAGE AFT SIDE OF FRAME 40.3 JUST OUTBD OF STR 3R. CORRECTIVE ACTION: REPAIRED PER ERA 628205-14 REV ORIG. (1121445)SDR DALA2025080405845Frame · damagedSHIP 3416 93 AT FRAME 40.3 BETWEEN STRINGER 3-4 NOTED TOOLING DAMAGE. CORRECTIVE ACTION: REPAIRED PER ERA 628205-14 REV ORIG. (1121427)SDR DALA2025080405843Stringer · damagedSHIP 3416 TOOLING DAMAGE ON STRINGER 1R FORWARD OF FRAME 60 AT STRINGER TO ANGLE ATTACH AREA. CORRECTIVE ACTION: REPAIRED PER ERA 627536-14 REV B. (1121546)SDR DALA2025080405842Skin · damagedSHIP 3416 TOOLING DAMAGE TO SKIN LOWER SURFACE ABOVE STRINGER 1R, FORWARD OF FRAME 60. CORRECTIVE ACTION: REPAIRED PER ERA 627536-14 REV B. (1121545)SDR DALA2025080405841Skin · damagedSHIP 3416 SKIN HOLES DAMAGED AFT OF FR61 BETWEEN STR 2L AND STR 3L. CORRECTIVE ACTION: REPAIRED PER ERA 627864-14 REV B. (1121461)SDR IPXA20250804564Snubber · out of limitsFOUND MAIN ENTRY DOOR ROTARY SNUBBER PIN EXTENSION IS OUT OF LIMIT (REPLACE) OK TO WORKSDR 6VAR202508041001Skin · corrodedCORROSION ON REAR FUSELAGE SKIN AT AFT LAVATORY VENT OUTLET BETWEEN FR 69 TO FR 70, STG 30 TO STG 32. CLEANED CORROSION, FOUND OUT OF LIMITS CONDITION. PERFORMED HFEC SURFACE AND BOLT HOLE INSPECTIONS. FABRICATED AND APPLIED FILLER AND EXTERNAL DOUBLER REPAIR SDR DALA2025080405838Bottle · no testSHIP 3157 DO NOT PASS OPERATIONAL TEST EMERGENCY DOOR DAMPER ON PASSENGER CREW EMERGENCY DOOR 832. CORRECTIVE ACTION: REMOVED EMERGENCY DOOR DAMPER ON UNSERVICEABLE CONDITION ON PASSENGER CREW DOOR 832 AS PER A320 FAM AMM 52-13-14-000-001-B. (1121783).SDR DALA2025080405834Stringer · corrodedSHIP 3155 CORROSION STRINGER 44 AND BETWEEN FR60 TO FR61 AFT CARGO COMPARTMENT. CORRECTIVE ACTION: REPLACED STRINGER 44 LOC BETWEEN FR 59 TO FR 64 AFT CARGO COMPARTMENT AS PER A319 SRM 51-72-11, A319 SRM 51-42-21. (1121659).SDR AALA202508047323Window · delaminatedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT DIVERTED TO LAS DUE TO THE FLIGHT CREW REPORTING THAT THE FLIGHT DECK LEFT HAND SIDE NUMBER 3 WINDOW DELAMINATED IN FLIGHT AT 330. THE FLIGHT CREW HEARD A LOUD POP AND BUBBLES APPEARED IN WINDOWSDR KCSA2025080242Handle · looseDOOR FLIGHT DECK OVERHEAD. FOUND FLIGHT DECK OVERHEAD DOOR/HATCH HANDLE (INTERIOR) SLIGHTLY IN THE OPEN POSITION. OPEN AND CLOSED OVERHEAD HATCH FROM THE INSIDE IAW KA B747-400 AMM 52-21-00. OPERATIONS CHECKED GOOD. NO DEFECTS NOTED. OK TO CONTINUE IN SERVICESDR FDEA202508021358Skin · dentedDENT ON EXTERNAL SURFACE OF SLAT NO. 7 AT 3" FROM UPPER EDGE AND 49.5" FROM OUTBOARD EDGE, RIGHT WING RH WING, SLAT NO. 7 AT 3" FROM UPPER EDGE AND 49.5" FROM OUTBOARD EDGE, WAS REPAIRED I.A.W. B767 SRM 57-43-02-02R REP 1 PAG 1-2 AND SRM 51-70-10-2R REPAIRSDR FDEA202508021357Floorbeam · corrodedAFT CARGO COMPT. FLOORBEAM AT BS 1681 LBL 5.0 WITH CORROSION.SDR FDEA202508021356Floorbeam · corrodedAFT CARGO COMPT. FLOOR BEAM AT BS 1681 LBL 5.0 WITH CORROSION. THIS REPAIR WAS ACCOMPLISHED FOLLOWING EA # F-5310-T0384258 REV A P1. PROCEDURES.COPY ATTACHED.TITLE: FUSELAGE - REPAIR OF STA 1681 FLOOR BEAM UPPER CHORD CORROSION AT LBL 5. THIS IS A MAJOR RESDR FDEA202508021355Thermocouple · failedAFTER TAKEOFF, HAD FLUXING VIBRATION ON CLIMB OUT. MONITORED INSTRUMENTS AND NOTHING WAS OUT OF LIMITS. UPON REACHING APPROXIMATELY 18000, NOTICED ATS LEVERS KICKED OFF. FOLLOWED ECAM AND RESET. INFORMED GOC AND MOCC INFLIGHT. NOTICED EGT ON NUMBER TWOSDR AALA202508041498Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 312 TO BS 328 AT RBL 31. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202508047743Intercostal · crazedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 274 TO BS 294.5 AT BL 0. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202508042315Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT BAFFLE FROM BS 500 TO BS 500A AT S26L. REPLACED BAFFLE PER AARD 51-00-05-1 .SDR AALA202508045722Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT BAFFLE FROM BS 500C TO BS 500D AT S25L. REPLACED BAFFLE PER AARD 51-00-05-1 .SDR ABXA20250802169Start Valve · inoperativeON TAXI, RT ENGINE START VALVE INOP. AIRCRAFT RETURNED TO BLOCKS (BTB). MAINTENANCE DEFERRED IAW MEL C ABX-80-00-2-1. REMOVED AND REPLACED RT ENGINE START VALVE. DI 64875 CLEARED. A/C REMAINS NO ETOPS IAW B767 AMM 80-11-02. AIRCRAFT RETURNED TO SERVICE.SDR AALA202508043172Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: DURING PS CHECK FOUND 3R EPAS BATT CHECK FAIL. MAINTENANCE REPLACED A NEW EPAS BATT AT DOOR 3R IAW AMM 52-12-19.SDR DALA2025080405813Floorbeam · corrodedCORROSION ON FLOORBEAM AT STA 986 BTW RLB 0-RBL RBL 44 UPPER & LOWER FACE, ALSO BTW LBL 15- LBL 44 AT PAX CABIN. FLOORBEAM AT STA 986 AT PAX CABIN WAS REPAIRED PER ERA 582813-14 REV. ORIGINAL.SDR AALA202508047328Life Vest · openAIRCRAFT WAS NOT GROUNDED: FIRST OFFICERS LIFE VEST PROTECTIVE POUCH OPENED. MAINTENANCE REPLACED LIFE VEST PER AMM 25-62-99.SDR AALA202508041155Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #6 HINGE ARM END HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202508047497Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: CIDS PANEL HAS WARNING. CHECK DOOR PRESSURE 1L DOOR. MAINTENANCE SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202508044948Life Vest · missingAIRCRAFT WAS NOT GROUNDED: LIFE VEST MISSING AT SEAT 15B. MAINTENANCE INSTALLED LIFE VEST PER AMM 26-66-52.SDR AALA202508049546Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY DOOR LOCK ON AFT AIRCRAFT RIGHT STICKS CAUSING A PASSENGER TO BE LOCKED INSIDE. MAINTENANCE ADJUSTED AND LUBED AFT LAVATORY DOOR AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 25-45-19.SDR AALA202508047339Fire Warning · false activationAIRCRAFT WAS NOT GROUNDED: FLIGHT CREW REPORTED AN INTERMITANT FIRE BELL BUT WAS NOT SURE WHICH SYSTEM. MAINTENANCE PERFORMED FIRE LOOP SYSTEM TEST PER AMM 26-12-00 WITH NO FAULTS DETECTED.SDR AALA202508045413Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202508047998Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R3 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202508049058Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: LEFT AFT EMERGENCY DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR UIEA2025080201078Life Vest · missingDURING DAILY CHK, W/C C-06-001-01-08 FOUND LIFE VEST MISSING AT PAX SEAT BY R1 DOOR. INSTALLED NEW LIFE VEST AS REQUIRED AT PAX SEAT BY R1 DOOR REF W/C C-06-001-01-08. NO FURTHER DEFECTS NOTED.SDR UIEA2025073001067Bushing · gougedLH BODY GEAR SIDE STRUT BUSHING (AIRCRAFT SIDE) IS GOUGED ON INSIDE.(<P>FABRICATED A NEW BUSHING PER BOEING SOPM 20-43-04 & EA 747-53-40-28-130537. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025080401079Trunnion · damagedLH BODY GEAR WHEEL WELL INBD TRUNNION FITTING FWD AFT & INBD 3 EA MOUNTING BOLT HOLE INNER BORES HAS SCORING(<P>REMOVED SCORING PER EA 747 5340-28-B0538 & SRM 53-40-90-2R REPAIR 1. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025080401080Trunnion · damagedRH BODY GEAR WHEEL WELL TRUNNION FWD MOUNTING BOLT HOLE INNER BORE HAS SCORING(<P>REMOVED SCORING ON THE INNER HOLE PER EA 747 5340-28-B0538 & SRM 53-40-90 REPAIR 2. NO FURTHER DEFECTS NOTED.</P>)