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 AALA202508153070Damper Plate · low pressureAIRCRAFT WAS NOT GROUNDED: L1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202508159091Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR KCSA20250815144Warning Message · false activationDOOR UPPER DECK FLIGHT LOCK MESSAGE. PERFORMED ADJUSTMENT TEST OF UPPER DECK DOOR LOCK IAW AMM 52-23-00. NO DEFECTS NOTED. MESSAGE CLEARED.SDR AALA202508140203Fuel Filter · cloggedAIRCRAFT WAS GROUNDED: ENG 1 FUEL CLOGGED ECAM ON DEPARTURE. DECESION MADE TO RETURN TO MIA, AIRCRAFT LANED WITHOUT INCIDENT. MAINTENANCE REPLACED #1 ENGINE FUEL FILTER IAW AMM 73-11-10.SDR AALA202508146755Torque Link · out of adjustAIRCRAFT WAS GROUNDED: PILOT REPORTS ECAM MESSAGE L/G SHOCK ABSORBER FAULT AND SURV ROW/ROP LOST. AIR INTERRUPT LANDING UNDER MAX WEIGHT. GEAR WOULD NOT RETRACT AFTER TAKE OFF. MAINTENANCE FOUND DEAR WOULD NOT STOW COMPLETEY DUE TO TARGETS 24GA & 25GAA BEING SDR AALA202508141589Torque Link · out of adjustAIRCRAFT WAS GROUNDED: PILOT REPORTS ECAM MESSAGE L/G SHOCK ABSORBER FAULT AND SURV ROW/ROP LOST. AIR INTERRUPT LANDING UNDER MAX WEIGHT. GEAR WOULD NOT RETRACT AFTER TAKE OFF. MAINTENANCE FOUND DEAR WOULD NOT STOW COMPLETEY DUE TO TARGETS 24GA & 25GAA BEING SDR GTIA2025081439044Flashlight · no testFLIGHT ATTENDANT POSITION L2 FLASHLIGHT INOP-R/R L2 FLASHLIGHT IAW AMM 25-63-00. OPERATIONAL CHECK OK. A/C OK FOR SVC.SDR SWAA2025081403148Flashlight · no testCREW REPORTS AFTER F/A FLASHLIGHT WILL NOT TEST. REMOVED AND REPLACED AFT F/A FLASHLIGHT ASSY IAW AMM 25-64-00.SDR SWAA2025081403137Flashlight · no testAFT FA FLASHLIGHT WILL NOT TEST. R & R FLASHLIGHT BATTERY PER AMM 25-64-00, RESEALED.SDR SWAA2025081400425Flashlight · inoperativeAFT GALLEY F/A FLASHLIGHT INOPERATIVE. REMOVED AND REPLACED AFT GALLEY FLASHLIGHT IAW AMM 25-64-00.SDR SWAA2025081403166Flashlight · inoperativeAFT RT ATTENDANT FLASHLIGHT INOPERATIVE. REMOVED AND REPLACED AFT RT FLIGHT ATTENDANT FLASHLIGHT BATTERY IAW AMM 25-64-00. OPS CHECKED GOOD.SDR SWAA2025081400375Slide · looseFWD DOOR SLIDE BUSTLE ON ESCAPE SLIDE LOOSE. SECURED FWD R-1 DOOR ESCAPE SLIDE. OK FOR CONTINUED SERVICE. IAW AMM 25-66-00. SECURED FWD R1 DOOR ESCAPE SLIDE. OK FOR CONTINUED SERVICE IAW AMM 25-66-01.SDR SWAA2025081400347Girt Bar · looseFASTENER ON SVC DOOR SLIDE GIRT BAR RETAINING CLIP NEEDS REPLACING. REPLACED MISSING FASTENER IAW SIP.SDR SWAA2025081403471Flap · looseFORWARD SERVICE DOOR SLIDE BAR FLAP LOOSE. RESECURED FLAP IAW MT 725-61-06.SDR SWAA2025081403128Bulb · inoperativeEMERGENCY EXIT BULBS OVERHEAD AFT RH SERVICE DOOR INOPERATIVE. REPLACED THE LAMPS EMERGENCY EXIT SIGN OVER AFT RH SERVICE DOOR IAW AMM 33-35-01.SDR SWAA2025081403126Bulb · inoperativeOVERHEAD EMERGENCY EXIT BULB LOCATED NEAR AFT LAVATORIES INOPERATIVE. REPLACED THE LAMPS IN OVERHEAD EMERGENCY EXIT SIGN LOCATED NEAR AFT LAVATORIES IAW AMM 33-51-01.SDR SWAA2025081403125Bulb · inoperativeEMERGENCY BULBS INOPERATIVE AT OVERHEAD EMERGENCY SIGN ROW 14 IN PASSENGER COMPARTMENT. REPLACED THE LAMPS IN OVERHEAD EMERGENCY EXIT SIGN AT ROW 14 IAW AMM 33-51-01.SDR SWAA2025081400327Battery Pack · inoperativeMULTIPLE EMERGENCY LIGHTS OUT ON RH SIDE MID CABIN. REMOVED AND REPLACED TWO EMERGENCY BATTERIES M1669 AND M1671 IAW AMM 33-51-06.SDR SWAA2025081403134Handle · crackedTHE RIGHT WING EMERGENCY EXIT DOOR HANDLE MOLDING IS CRACKED. REMOVED AND REPLACED THE RT WING EMERGENCY EXIT DOOR HANDLE MOLDING IAW AMM 52-22-51.SDR DXTA2025081404566Door Seal · tornDOOR SEAL SQUEAL DURING CLIMB OUT BETWEEN 14,000 AND 20,000 AND DESCENT 8,500 AND 6,000 DELTA P 3.3PSI. SMALL DAMAGE TO SEAL ON FUSELAGE FRAME TOP LEFT CORNER. CORRECTIVE ACTION: REPLACED MED SEAL WORK PERFORMED IAW EMBRAER PHENOM 300 AMM CH. 52-10-20. PERFORSDR DALA2025081406099Battery Pack · faulted(LOG 7711530) EMERGENCY LIGHTS ROWS 22 TO 27 INOP. REMOVED / REPLACED EMERGENCY FOOT PATH LIGHTING BATTERY PACK, IAW B737 AMM 33-51. OPS CHECKS GOOD.SDR DALA2025081406101Battery Pack · inoperative(LOG 7328988) 1R EXTERNAL EMERGENCY LIGHT INOP. REPLACED BATTERY PACK IAW B737 AMM 33-51 OK FOR SVCSDR DALA2025081406096Plate · corroded(LOG 1138154) CORROSION ON SIDE PLATE LH STA 450 TO 500I AT FWD CARGO COMPARTMENT. SIDE PLATE LH STA 450 TO 500I AT FWD CARGO COMPARTMENT WAS REPLACED PER B737-800 SRM 51-40-02-0G.SDR DALA2025081406095Skin · cracked(LOG 1138000) CRACK ON LOWER SKIN AT STAB STA 157.10 AT RH HORIZONTAL STAB. LOWER SKIN AT STAB STA 157.10 AT RH HORIZONTAL STAB WAS REPAIRED PER B737-800 SRM 55-10-01-2R REPAIR 11.SDR DALA2025081406094Floorbeam · corroded(LOG 1137898) STA 947 FLOOR BEAM HAS LIGHT CORROSION AROUND HILOCK HOLE AT LBL 12. PERFORMED CUT-OUT REPAIR ON THE FLOOR BEAM AT STA. 947 LBL 12 IAW B737-900 SRM 53-70-51-1A-1.SDR DALA2025081406093Floorbeam · corroded(LOG 1137870) CORROSION ON FLOOR BEAM UPPER CHORT AT STA 344 BTW RBL 1-LBL 5. FLOOR BEAM UPPER CHORT AT STA 344 BTW RBL 3 TO LBL 5 WAS REPAIRED PER B737-800 SRM 53-10-51-2R REPAIR 8.SDR DALA2025081406092Frame · damaged(LOG 1136820) FRAME 203.8, LOWER LOBE DAMAGED. PROCURED LOWER CHORD AND WEB. POSITIONED PER BOEING DRAWING 141A1503. MATCH DRILLED PER BOEING B737 DRAWING 141A1503 (RJD 471692). INSTALLED LOWER LOBE FRAME 203.8 PER BOEING DRAWING 141A1503.SDR DALA2025081406091Frame · cracked(LOG 1136833) BHEC CRACK INDICATION IN STA 196.5 L/H FRAME SPLICE WEB. COMPLETED DRILLING SPLICE PLATE PER BOEING DRAWING 141A1502 (RJD 471692) OKAY TO TREAT AND PRIME (QC 5332). TREATED AND PRIMED (RJD 471692). INSTALLED SPLICE PLATE PER BOEING DRAWING 141A15SDR DALA2025081406090Frame · damaged(LOG 1136825) FRAME 196.5, LOWER LOBE DAMAGED. COMPLETED INSTALLATION OF LOWER LOBE FRAME 196.5 PER BOEING DRAWING 141A1502.SDR CALA2025081407745Control Panel · faulted2 RTO FOR WINDSHEAR WARN 1ST 50KTS 2ND 30KTS. REMOVED AND REPLACED THE WX RADAR CTRL PANEL REF AMM 34-43-91, OPS CKS NORMAL. REF LP 5885383 FOR THE WXR R/T REPLACEMENT. REMOVED AND REPLACED THE WX RADAR CTRL PANEL REF AMM 34-43-91, OPS CKS NORMAL. REF LP SDR CALA2025081407731Strobe · faultedLOWER RED ANTI-COLLISION LIGHT HAS BEEN DEFERRED IN COMPLIANCE WITH CDL CARD 334430 REF LOG PAGE 5883456 APPLIED MEL 3344AD, BOTH (LEFT AND RIGHT) WING TIP WHITE, TAIL CONE WHITE STROBE LIGHTS AND UPPER RED ANTI-COLLISION OPERATE NORMALLY , ALL POSITION LIGHTSSDR CALA2025081407730Door Sill · corrodedAFT MAIN CABIN R2 DOOR SILL HAS CORROSION. REPAIRED AFT MAIN CABIN R2 DOOR SILL IAW A320 SRM 53-41-14-300-0 01. CAT A.SDR CALA2025081407718Proximity Switch · failedDOOR E/E ACCESS EICAS ADVISORY, E/E ACCESS DOOR NOT FULLY CLOSED, LATCHED AND LOCKED. MESSAGE APPEARED DURING DEPARTURE CLIMB, DISCONNECTED & CAPPED ELECTRICAL CONNECTOR S52019 IN MAIN E&E COMPARTMENT. E/E ACCESS DOOR INDICATION INOPERATIVE, DEFERRED PER MSDR CALA2025081407712Light · malfunctionedFOUND FLOOR EMERGENCY LIGHT ROW 28 INOP ALL ADJACENT LIGHTS OPERATE NORMALLY. PLACE INOP LIGHT ON MEL INSPECTED FLOOR EMERGENCY LIGHT ROW 28 NOT ABLE TO DUPLICATE FAULT ON GROUND AT THIS TIME, FLOOR EMERGENCY LIGHT ILLUMINATE NORMAL. OK TO CONTINUE.SDR ANCF2025081323Engine · bird ingestionDURING TAKE OFF ROLL BIRD STRIKE ON ENGINE ONE VIBRATION 2,7 ON ENGINE ONE AND N1 AND LOUD NOISE (2.7 VIBRATION ON N1 ENGINE NUMBER ONE) NO MAYDAY NO PAN PAN SUST PRIORITY DURING RETURN DURING CRUISE EGT DIFFERENCE 30 ° C ON ENGINE ONE LANDING WEIGHT 63.1 TSDR VNAA2025081311102Ballast · failedCABIN CREW REPORTS ELECTRICAL/CIRCUITY SMELL IN THE AFT CABIN AT THE LAST FIVE ROWS. GPU ATTACHED. APU ON. PACKS ON. RECRIC FANS ON. NO LOW PRESS AIR ATTACHED. NO FUELER ACTIVITY PRESENT./ PERFORMED TROUBLESHOOTING IAW CRJ700 FIM 21-22-00-810-806. FOUND TOP SISDR WX0A2025081332541Light · missingAIRCRAFT NOT GROUNDED, FA DISCOVERED L2 FLOOR LEVEL EMERGENCY LIGHT MISSING IN FLIGHT. INSTALLED NEW EXIT LIGHT COVER ON L2 EXIT DOOR IAW AMM 33-51-11-400-001-A.SDR IXXA20250811044Battery Pack · inoperativeEMERGENCY LIGHT L9801, L9803 AND THE EXTERIOR EMERGENCY LIGHTS ARE INOPERATIVE. FAULT PLACED ON MAINTENANCE DEFERRAL 65186, CATEGORY D DUE ON 10 DECEMBER 2025. REMOVED AND REPLACED EMERGENCY BATTERY AND POWER SUPPLY IN FORWARD POSITION IN ACCORDANCE WITH BOEINSDR FDEA202508111420Skin · contaminatedEMPENNAGE - RH ELEVATOR UPPER COMPOSITE MATERIAL FOUND ENTRAPPED WATER (LOC: L/E ER13) REPAIRED EMPENNAGE RH ELEVATOR UPPER L/E ER13 ENTRAPPED WATER COMPOSITE MATERIAL PER A300-600 SRM55-21-12-201 PARA.5.J & SRM51-77-12-201. THIS IS CAT B REPAIR AND THE SDR FDEA202508111419Skin · contaminatedEMPENNAGE - LH ELEVATOR UPPER COMPOSITE MATERIAL FOUND ENTRAPPED WATER (LOC: L/E ER2) REPAIRED EMPENNAGE LH ELEVATOR UPPER L/E ER2 ENTRAPPED WATER COMPOSITE MATERIAL PER A300-600 SRM55-21-12-201 PARA.5.J & SRM51-77-12-201. THIS IS CAT B REPAIR AND THE FOSDR IXXA20250811042Flashlight · inoperativeEMERGENCY FLASHLIGHT ON CONTROL PEDESTAL INOPERATIVE. REMOVED AND REPLACED EMERGENCY FLASHLIGHT ON CONTROL PEDESTAL IN ACCORDANCE WITH BOEING 767 AIRCRAFT MAINTENANCE MANUAL 25-64-00. OPERATIONAL CHECK GOOD.SDR DALA2025081306045Girt Bar · dirtyON TAKEOFF ROLL ABOVE DOOR 4L ( CAPTAINS SIDE). ALL OTHER FOOR ARMED INDICATORS FUNCTIONAL. LIFTING RUBBER SEAL CONFIRMED GIRT BAR ENGAGED. SLUDE WARNING LIGHT ILLUMINATED WHEN DOOR WAS ARMED FIR DEPARTURE. / INTERIOR. CLEANED AROUND GIRT BAR AREA, SECURED SSDR AALA202508132713Control Rod · out of adjustAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND FORWARD PASSENGER / CREW DOOR DAMPER AND EMERGENCY OPERATION CYLINDER STRIKER MECHANISM TO PERCUSSION BELLCRANK FINGER CLEARANCE (DIMENSION B) IS IN EXCESS OF .33". MAINTENANCE ADJUSTED PERCUSSION BELLCRANK FINGER CONTRSDR YENA2025081300832Intake · contaminatedFLT#525, PVD-SJU. "FUMES NOTICIED IN AFT CABIN BY FA'S VERY STRONG SMELL OF BURNT FUEL OR HYDRAULICS THE SMELL IS REDUCED AFTER PACK 2 0FF; DURING THE PROCEDURES FOLLOWED TO HANDLE THIS ODOR EVENT, THE SOURCE OF THE ODOR WAS FOUND TO BE APU, ALSO FOUND THE AIRSDR REXA2025081300805Sensor · inoperativeBRAKE OVHT WARNING AT 8000' 250 KTS WITH RT OTBD INDICATOR AT 00. FOLLOWED CHECKLIST AND LOWERED GEAR. NO CHANGE. UPON LANDING INDICATOR NEVER WENT ABOVE 02. R&R RHOB BRAKE TEMP SENSOR IAW AMM 32-46-01. OPS CHECK GOOD.SDR CALA2025081307708Skin · damagedLEFT LEADING EDGE SLAT 7 & 8 HAS DAMAGE ON UPPER INBOARD SIDE OF THE SLAT. THERE ARE 9 DAMAGED RIVETS AND THE HOLE MEASURES 4.5 INCHES IN WIDTH AND 2 IN LENGTH. PERFORMED TASK IN AMM REF 27-81-10 UP TO (E) (5) (A). REMOVED FASTENERS AND CUT OUT DAMAGED SECTSDR CALA2025081307690Limiter · failedOPERATIONAL TEST OF THE RUDDER-TRAVEL LIMITING FUNCTION IAW AMM 22-61-00-710-001-A. PERFORMED OPS CHECK OF RUDDER TRAVEL LIMITING FUNCTION IAW AMM 22-61-00-710-001-A, OPS CHECK FAILED. CONTINUED TROUBLESHOOTING REF TSM LOSS OF THE RUDDER TRAVEL LIMITATION-FUNSDR CALA2025081307689Pitot Tube · shortedLEFT ELEVATOR PITOT MASTER CAUTION. T/S IAW FIM 30-31 TASK 805 AND WDM 30-31-11-900. FOUND LT ELEVATOR PITOT PROBE A24 INTERNALLY SHORTED. REMOVED L ELEV PROBE IAW AMM 27-31-94-000-801 AND COVERED LINE. LEFT ELEV PITOT PROBE REPLACED.SDR CALA2025081307682Light · detachedSEAT 12C EMERGENCY LIGHT WIRE & HOLDER OUT AND SITTING ON SEAT. EMERGENCY LIGHT INOPERATIVE. SEAT MOUNTED LIGHT AT 12 C. ITEM SECURED DOESNT CAUSE HAZARD TO THE PAX. REQUESTING TO DEFER. MEL 3351D REJECTED LIGHT ASSEMBLY SECURED, SECURED WITH TIE WRAPS ECRASDR CALA2025081307681Slide · no discrepancyDOOR 1R SLIDE PULLED OUT SLIGHTY. CATCHING ON GIRT BAR DURING ARMING. FOUND J HOOKS ON SLIDE PACK FOR UNARMING DOOR POSSIBLY OUT OF POSITION. REMOVED DOOR SLIDE PACK ON DOOR 1R, INSPECTED DOOR 1R SLIDE PACK CONTAINER. COVER IS EFFECTIVE PER IPC 25-66-01-02.