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 CALA2025100909849Battery Pack · inoperativeEEPL EMERGENCY LIGHTS FROM SEAT ROW 35ABC TO 39ABC ARE INOP. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACK FOR BATTERY CHARGER M1972 ABOVE LAV E, UP TO POS CHECK IAW AMM 33-51-06-960-805. PERFORMED OPERATIONAL CHECK OF EEPL EMERGENCY LIGHTS FROM SEAT RSDR CALA2025100909848Fuse · blownEMERGENCY LIGHTS AT SEAT 15, 20, 21ABC & LH &RH FWD OW DOOR BOTTOM EXIT INDICATORS ARE INOP. M1694 BATTERY CHARGER REMOVED AND REINSTALLED RETURN AIR GRILLE AT FWD LT OVERWING EMERGENCY EXIT DOOR TO FOM IAW AMM 21-23-03. TROUBLESHOT TO A BAD FUSE ON M1694 BASDR CALA2025100909847Battery Pack · inoperativeEMERGENCY LIGHTS AROUND THE FWD RT AND AFT RT OVERWING EMERGENCY EXIT DOORS ARE INOPERATIVE. RT OVERWING EMERGENCY EXIT REMOVED AND INSTALLED, RETURN AIR GRILLE AT FWD RT OVERWING EMERGENCY EXIT DOOR TO FOM IAW AMM 21-23-03. REMOVED AND REPLACED EMERGENCY SDR CALA2025100909846Beam · crackedFWD CARGO DOOR UPPER BEAM -A- CRACKED UNDER EXISTING SKIN DOUBLER. REMOVED AND REPLACED -7 BEAM IAW 14A6117 REV A, CMM 2-31-15, SRM 51-40-02, AND DWG 143A6117.SDR CALA2025100909844Stub Beam · wornL1 DOOR HANDLE BOX CUTOUT, UPPER TORQUE TUBE BUSHING AREA, STUB BEAM IS GOUGED. REMOVED GOUGED STUB BEAM IAW B737-800 SRM 51-40-02. LOCATED, DRILLED AND INSTALLED NEW STUB BEAM PN 141A6143-6 IAW BAC DWG 141A6190 REV E AND B737-800 SRM 51-40-02 AND BAC DWG 141SDR CALA2025100909843Skin · crackedFORWARD CARGO DOOR SKIN REPLACED. REMOVED AND REPLACED OUTER SKIN IAW B737-800 SRM 52-30-01-2R-3 REP.3, CMM 52-31-15 AND BAC DWG 143A6110 REV D.SDR CALA2025100909842Stop Fitting · wornL-2 DOOR UPPER FWD DOOR STOP FITTING IS GOUGED. REPAIR COMPLETED STATUS CHANGE FROM MAJOR REMOVED AND REPLACED L-2 DOOR UPPER FWD DOOR STOP FITTING IAW BAC DWG 147A6125 AND BAC DWG 147A6116 REV -.SDR CALA2025100909841Seal · brokenAFT LIFE RAFT SEAL BROKEN REQUEST MEL 3810A, REFERRAL IS DO LAV SMELLING TO BADLY, ALL SYSTEMS OPERATE NORALLY, PLACARD INSTALLED ON DOOR. MEL 3810A REJECTED INSPECTED LIFE RAFT AND RESEALED BIN.SDR CALA2025100909840Blade · out of limitsDURING WALK AROUND, FOUND FAN BLADE TIP OF NR 2 ENG BENT. ON FURTHER INSPECTION IAW AMM 72-21-02-200-801-F00, FOUND ORIGINAL BLADE NR 8 TO BE OUT OF LIMITS. IN ADDITION, FOUND ADJACENT BLADE NR 9 TO HAVE A TIP CURL OUT OF LIMITS. FOUND SEVERAL OTHER BLADESSDR CALA2025100909823Door · out of rigTEST FLIGHT REFLY REQUIRED REFLY REQUIRED FOR L2 DOOR LATCH MOVING ON TAKEOFF LOCKED BY SYSTEM. RE-RIGGING COMPLETED AND TEST HOP READY ACCOMPLISHED AFT ENTRY DOOR (SOFT UNLATCHING) CHECK AND ADJUSTED ALL LATCH ROLLERS WITHIN LIMITS IAW AMM 52-13-00-820-802. ASDR YENA2025100901015Fire Detector · faultedFLT#687, BOS-LAX. (ETOPS) "ENG 2 FIRE LOOP A ( ENGINE FIRE DETECTION SYSTEMS 1) LOOP A )" OPENSDR YENA2025100901014Skin · corrodedDURING HEAVY MAINTENANCE: CORROSION ON TOP SKIN LOWER SURFACE ON TRAILING EDGE OVERHANG AREA BTW RIB8 AND RIB9 ON RH WING (CPCP FINDING); ACCOMPLISH REPAIR OF THE CORROSION ON THE RH WING TOP SKIN PANEL 2 LOWER SURFACE TRAILING EDGE OVERHANG BETWEEN WX3494.5-WSDR YENA2025100901013Skin · corrodedDURING HEAVY MAINTENANCE: CORROSION ON TOP SKIN LOWER SURFACE ON TRAILING EDGE OVERHANG AREA BTW RIB 8 AND RIB 9 ON LH WING (CPCP FINDING ); ACCOMPLISHED REPAIR OF THE CORROSION ON THE LH WING TOP SKIN PANEL 2 BETWEEN RIBS 8-9 LOWER SURFACE IN ACCORDANCE WITH SDR 2025FA0000696Warning Message · intermittentINTERMITTENT "L MAIN GEAR NOT UP" AMBER (CAUTION) CAS MESSAGE ALERT OCCURRED DURING CLIMB, APPROXIMATELY 8-10 MINS AFTER SUCCESSFUL GEAR RETRACTION. MESSAGE CLEARED FOLLOWING GEAR EXTENSION. THE DEFECT RECURRED INTERMITTENTLY, AGAIN AFTER 8-10 MINS DURING A SSDR HALA20251008309Cooling Duct · crackedETOPS - ON WALK AROUND, FOUND #2 ENG EEC COOLING INLET DUCT CRACKED. REMOVED AND REPLACED #2 ENG EEC COOLING DUCT INLET PER CMM 71-60-00. SEC CHK GOOD. OK FOR SVCSDR HALA20251008308Fire Loop · faultedETOPS - IN FLIGHT, ENG 1 FIRE LOOP B FAULT. REMOVED AND REPLACED #1 ENG PYLON FIRE DETECTOR RAMP ASSY PER AMM 26-12-16. OPS CHECK GOOD. OK FOR SERVICE.SDR YENA2025100801012Wire Harness · failedFLT#72, EDI-JFK. (ETOPS) "ENG 1 FADEC SYS FAULT HAPPENED AT CRUISE FL 350; PERFORMED TSM 77-11-00-810-812A FOUND W04 HARNESS CHAFFED AT N2 SENSOR. REMOVED AND REPLACED W04 HARNESS REF AMM 73-21-64 FADEC SYSTEM TEST OK PERFORMED IDLE RUN REF AMM 71-00-00 ALL PASDR YENA2025100801011Cable · out of positionFLT 613, HPN-FLL. AFT CARGO LEFT RESERVOIR OF THE OFFWING ESCAPE SLIDE FLEXIBLE CONTROL ASSY FROM ACFT IS MISSING NOT VISIBLE. CAREFULLY PULLED THE END OF THE WIRE OUT OF THE FLEXIBLE CONTROL ASSY AND RE-ENGAGED THE END OF THE WIRE IN THE SLOT OF THE FLEXIBLSDR SWAA2025100822224Cover · missingVELCRO COVER FOR MANUAL INFLATION HANDLE ON SLIDE FWD SERVICE DOOR IS MISSING. REPOSITIONED SLIDE AND INSTALLED MANUAL DEPLOY FLAP IAW AMM 25-66-01.SDR SWAA2025100821998Seat · out of alignmentPASSENGER SEAT 11F RECLINES INTO EXIT ROW. LOCKED OUT PASSENGER SEAT 11F RECLINE IAW CMM 25-23-46.SDR SWAA2025100822202Battery · inoperativeCOCKPIT FLASHLIGHT DOES NOT TEST WITH GREEN LIGHT. REMOVED AND REPLACED COCKPIT FLASHLIGHT BATTERY PER AMM 25-64-00. OPS CHECK GOOD.SDR SWAA2025100822101Slide · unpackedL1 DOOR SLIDE GIRT REPACK REQUIRED. REPACKED L1 DOOR SLIDE GIRT REF AMM 25-66-01.SDR SWAA2025100822131Light · inoperativeMULTIPLE EMERGENCY LIGHTS INOP THROUGHOUT THE CABIN. REMOVED AND REPLACED IAW AMM 33-51-03-960-801.SDR DALA2025100807360Line · out of positionR1 ENTRY DOOR WILL NOT ARM. FOUND 1R ESCAPE SLIDE MOORING LINE STICKING OUT. RESECURED ESCAPE SLIDE MOORING LINE. REF B757 AMM25-66. (7189244)SDR AALA202510088165Attach Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND PYLON FORWARD ATTACH FITTING (SHACKLE) RIGHT HAND POSITION AT RIB 4. REPLACED PYLON ATTACH FITTING PER AMM 54-51-17-400-001-ASDR AALA202510083234Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION FOUND ON FITTING AT FR 2 AND -Y 330. REPLACED FITTING PER SRM 51-42-11.SDR AALA202510082069Unknown · odorAIRCRAFT WAS GROUNDED: ELECTRICAL BURNING SMELL BETWEEN ROWS 10 AND 12. NOTICED POWER PORTS INOPERATIVE IN ROW 12DEF. PERFORMED VISUAL INSPECTION FROM ROW 9DEF-13DEF FOR WIRES/OUTLET/ISPS UNIT. PER AMM 23-81-00. OPERATIONAL CHECK GOOD, NO SOF NO FAULT FOUND.SDR AALA202510087455Tube · missingAIRCRAFT WAS NOT GROUNDED: THE AFT RIGHT R2 DOOR THE GIRT BAR IS MISSING THE RED SECURITY TAPE. REPLACED GIRT BAR HEATSHRINK.SDR AALA202510087959Bonding Jumper · dislodgedAIRCRAFT WAS NOT GROUNDED: AFT SERVICE DOOR EVACUATION SLIDE HAS A PIECE OF STRAP HANGING OUTSIDE THE COVER. RESECURED BONDING JUMPER ON AFT RIGHT SERVICE DOOR SLIDE PACK COVER. PER MM 25-66-01.SDR AALA202510081045Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR STICKS AT BOTTOM CORNER IT IS HARD TO OPEN. LUBED FORWARD LAVATORY DOOR LATCH DOOR, OPERATIONAL CHECK GOOD.SDR AALA202510088756Sign · missingAIRCRAFT WAS GROUNDED: CORNER EXIT SIGN BY SEAT 16A MISSING. INSTALLED LEFT HNAD FORWARD EMERGENCY EXIT SIGN LENS. PER AMM 33-51-01.SDR AALA202510080272Girt Bar · unsecureAIRCRAFT WAS GROUNDED: FLIGHT ATTENDANT REPORTS FORWARD ENTRY DOOR IS NOT ARMING PROPERLY. RESTOWED GIRT BAR MATERIAL AND REMOVED AND REINSTALLED SLIDE PACK AND COVER. PER AMM 25-66-01.SDR AALA202510081582Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: NUMBER 4 FLIGHT ATTENDANT JUMPSEAT FLASHLIGHT IS INOPERATIVE. REMOVED AND REPLACED NUMBER 4 FLIGHT ATTENDANT JUMPSEAT FLASHLIGHT. PER AMM 25-64-00.SDR DALA2025100807355Door · openATB- PERFORMED AN AIR TURN BACK DUE TO A NOSE GEAR AREA VIBRATION. MAINTENANCE CLOSED THE NOSE GEAR DOORS, CONFIRMED THE SECURITY AND CONDITION OF THE DOORS AND SURROUNDING AREA AND RETURNED TO SERVICE.(7585642)SDR DALA2025100807338Strut · out of toleranceRIGHT FLAP INTERCONNECT STRUT FAILED RADIAL PLAY DIMENSION CHECK. REPLACED AND ADJUSTED INTERCONNECT STRUT REF A319 AMM 27-51-44. (1239789)SDR DALA2025100807356Strut · out of toleranceLT WING FLAP INTERCONNECT STRUT FAILS RADIAL PLAY CHECK. REPLACED AND ADJUSTED INTERCONNECT STRUT REF A319 AMM 27-51-44. (1239803)SDR DALA2025100807337Girt Bar · fodSHIP 3147 AFT RIGHT DOOR WON'T ARM, INDICATED ARMED ON GROUND FOUND IT DISARMED IN FLIGHT. CORRECTIVE ACTION: REMOVED DEBRIS FROM GIRT BAR ATTACH FITTING ON FLOOR OPS OK A319 TSM 52-13-00. (7620894).SDR DALA2025100807335Door Frame · crackedUPPER FUSELAGE L1 DOOR CUTOUT FR20 DOUBLE JOGGLE AREA IN THE OUTER FLANGE OF THE FRAME WITH CRACK AT DOOR STOP 1 LHS FASTENER HOLE LOCATION #9 WITH CRACK. COMPLIED WITH ER/A 628974-14AD. (1239330).SDR DALA2025100807334Door Frame · crackedUPPER FUSELAGE R1 DOOR CUTOUT FR16 DOUBLE JOGGLE AREA IN THE OUTER FLANGE OF THE FRAME WITH CRACK AT DOOR STOP 7 RHS FASTENER HOLE LOCATIONS #A & #C WITH CRACK. COMPLIED WITH ER/A 628832-14AD. (1239308).SDR DALA2025100807333Crossbeam · damagedFWD FUSELAGE CROSSBEAM SPLICING FR16, RH SIDE WERE FOUND HOLES H14 & H15 WITH DIAMETER GREATER THAN THE MAXIMUM STARTING HOLE DIAMETER FOR COLD EXPANSION. COMPLIED WITH ER/A 629070-14AD. (1239284).SDR DALA2025100807332Crossbeam · damagedFWD FUSELAGE CROSSBEAM SPLICING FR16, LH SIDE WERE FOUND HOLES H14 & H15 WITH DIAMETER GREATER THAN THE MAXIMUM STARTING HOLE DIAMETER FOR COLD EXPANSION. COMPLIED WITH ER/A 629071-14AD. (1239273).SDR DALA2025100807331Door Frame · crackedUPPER FUSELAGE, PAX CABIN, R/H FORWARD ENTRY DOOR, FR 16 DOOR STOP NR 1 WITH CRACK INDICATION AT FRAME AND INTERCOSTAL LAYERS AT THE LOWER INBOARD HOLE. COMPLIED WITH ER/A 628823-14AD. (1239733).SDR DALA2025100807330Dummy Rail · corrodedSHIP 3153 CORROSION RAIL DUMMY Y503.2 LOCATED FROM FR12 TO FR16 AT FWD GALLEY AREA. REPLACED RAIL DUMMY Y503.2 LOCATED FROM FR12 TO FR16 AT FWD GALLEY AREA AS PER SRM 51-42-11 AND SRM 51-72-11. (1239554).SDR DALA2025100807353Frame · damagedMISDRILLED HOLES AT FRAME 22, L/H SIDE P5 BEHIND ANGLE BRACKET. CORRECTIVE ACTION: REPAIRED PER ERA 627851-14 REV ORIG. (1239805)SDR DALA2025100807352Frame · damagedFRAME C70 DETAIL W STR '6 TOOLING DAMAGE ON EXISTING CLIP AND FRAME AROUND NEW FASTENER TAIL AT WIRE BUNDLE. REPAIRED PER ERA 627851-14 REV O. (1239749)SDR DALA2025100807351Bracket · damagedFRAME C69 STR P'5 BRACKET HAS TOOLING DAMAGE. REPAIRED PER ERA 627851-14 REV O. (1239745)SDR DALA2025100807350Power Supply · faultedFOUND MULTIPLE EMERGENCY CABIN LIGHT OUT FROM ROW 43HJ TO 58HJ ON RIGHT SIDE. R & R EPSU PWR SUPPLY ASSY R/H AFT PER A330 AMM 33-51. OPS CK GOOD. (7673020)SDR UIEA2025100701260Light · no discrepancyEXTERIOR EMERGENCY LIGHTS INOP. LEFT SIDE L4 DOOR AND OVER THE WING(<P>PERFORMED EMERGENCY LIGHT TEST IAW B767 AMM 33-51-06-862. OPS CHECK GOOD</P>)SDR AALA202510088355Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER ATTACH ANGLE, IN RIGHT HAND ECS BAY, AFT BULKHEAD, LOCATED AT BS 663, RBL 15. REPAIRED ANGLE PER SRM 57-10-10-2R-5.SDR N6WA2025100801Skin · corrodedCORROSION ON SKIN BETWEEN STGR25L-26L. COMPLETED SKIN REPAIR BETWEEN STGR25L-26L IAW EO-C550-53MR-094