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 ASAA2025070259169Light · inoperativeEXTERIOR EMERGENCY EXIT LIGHT NEAR R1 DOOR INOP. GROUNDED - YES. TRANSFERED TO AAR MIG-5 S/N: OK427039SDR SWAA2025070787686Lamp · inoperativeEMERGENCY EXIT SLIDE LIGHT IS INOPERATIVE ON RIGHT SIDE OF FUSELAGE. REPLACED EMERGENCY EXIT SLIDE LAMP AT AFT RIGHT SIDE OF FUSELAGE IAW AMM 33-51-04-960-801. OPS TEST GOOD.SDR SWAA2025070787538Failsafe · crackedLEFT HAND PICKLE FORK FAIL SAFE STRAP APPEARS CRACKED. CONFIRMED CRACK PER NDT PART4 53-10-16. SEE TSR# 2025006295.SDR CALA2025070706279Pump · failedRIGHT CENTER FUEL LOW PRESS ON WITH SWITCH SELECTED ON. 6.4 IN TAN K.REQUEST MEL FOR RT CENTER FUEL BOOST PUMP INOP. PULLED AND COLLARED RT CENTER PUMP C/B. PLACED RT CENTER FUEL PUMP ON M.E.L., DDP C/W. TRANSFERRED FUEL INTO CENTER TANK WITH RT CENTER FUEL SDR CALA2025070706261Stringer · damagedAFT CARGO COMPT. FR 1500 R/SID E STRG 27 HAS FREE FLANGE AREA WITH DRILLED HOLE. REPAIR WAS PERFORMED ON AFT CARGO COMP FR 1500 R/SIDE STR 27 IAW WORK PER UAL EC/RA:5360-01976 AND VT MAE EA 757-5360-13-A3989 RE V-. REF: NR 128606.SDR CALA2025070706260Panel · wornL/H WING PANEL S521UBX. PANEL CUT OUT AT INBD LA TCH AREA LAND STRUCTURE WORN. REPAIR WAS PERFORMED ON LH WING L/E PANEL 521UBX, PANEL CUTOUT A T INB IAW WORK PER UAL EC/RA#:5740-03399 AND VT MAE EA 757-5740- 13-A3987 REV- AND SRM 51-40-02-0G-0.SDR CALA2025070706259Skin · corrodedLAV PAN SERVICE PANEL SKIN STRUCTURE AROUND PAN HAS SIGNS OF CORROSION AT HYLOCK AREA, REF 002741809 FUSELAGE SKIN AT LAVATORY SERVICE PAN BS 847-867 AT S-25L REPAIRED PER ECRA -5331-03169 REF BAM N/R002731809 FOR WORKED PERFORMED AND REQUIRED INSPECTION SIGNSDR CALA2025070706250Bottle · faultedCIDS CAUTION LIGHTS ON AFTER ENG START. -CFDS SHOWING SLIDE BOTTLE EMER L INSPECTED BOTTLE FOR LH OVERWING EMERGENCY SLIDE. TS REF TSM 25-62-00-810-805-A. INSPECTED LT OVERWING INFLATION BOTTLE AND FOUND TO BE APPROXIMATELY IN THE RED BAND. CONTACTED TOMC ANDSDR CALA2025070706249Door · no discrepancyGATE AND RAMP REPORT FWD ENTRY DOOR DOES NOT APPEAR CLOSED LIGHT IS OUT IN FLT DECK. PERFORMED OPERATIONAL CK OF DOOR OPENING AND CLOSING WITH NO DEFECTS NOTED. NO PRIOR HISTORY AMM 52-00-00-840-801SDR CALA2025070706248Cover · detachedHANDLE COVER FOR EMER EXIT DOOR ROW 21 ABC SIDE FELL OFF AND WI LL NOT STICK BACK ON DOOR REINSTALLED HANDLE COVER BACK INTO PLACE REF AMM 52-22-00-580-803.SDR CALA2025070706246Slide · no discrepancyDOOR 3R SLIDE INDICATOR NOT VISIBLE CHECKED DOOR 3R INFLATION CYLINDER PRESSURE GAGE PER DMC-B787-A-25-66-01-02B-300C-A, INDICATOR PRESENT AND IN GREEN RANGE.SDR CALA2025070706234Charger · inoperativeEMERGENCY LIGHTS OPERATIONAL CHECK EMERGENCY LIGHTS OPERATIONAL CHECK - FIRST CLASS FLOOR EMREGENCY LIGHTS INOP. R/R M2816 EMERGENCY LIGHTING BATTERY CHARGER IAW AMM 33-51-06. OPS CHECK FOR ALL LIGHTS ON CIRCUIT GOOD.SDR CALA2025070706233Light · no testCHECK EMERGENCY LIGHTS OPERATIONAL CHECK - R1 DOOR SLIDE LIGHT INOP SEE LP 5418784 FOR CORRECTIVE ACTION.SDR CALA2025070706232Light · faultedEMERGENCY EXIT LIGHTS REMAIN ILLUMINATED IN ALL MODES. POWERED DOWN AIRCRAFT COMPLETELY FOR 3 MINUTES. POWERED BACK UP, CYCLED NO SMOKING LIGHTS SWITCH AND SEAT BELT LIGHT SWITCH PER TROUBLESHOOTING MANUAL (TSM) 33-51-00-810-881-A. EMERGENCY LIGHTS STAYED OFF SDR CALA2025070706231Light · detachedSEAT 12C EMER EXIT PATH LIGHT HAS FALLEN OFF REPLACED EXIT PATH LIGHT BRACKET.REF AMM TASK33-51-05-402-030SDR CALA2025070706230Elec Connector · disconnected30ABC LOWER AISLE EMERGENCY LIGHT OUT 30ABC FLOOR PROXIMITY LIGHT ASSY REM AND REPL. REF AMM 33-51-11-960-802. LIGHT STILL WONT TURN ON. FURTHER TS REQUIRED. MEL 3319E. CW MEL REQUIREMENTS FLOOR PROXIMITY LIGHT INDICATED ON LOWER AISLE 30ABC WAS FOUND UPON TRSDR CALA2025070706225Unknown · odorFA ADVISED ELECTRICAL SMELL NEAR DOOR R2 SAID IT SMELLED LIKE A HOT CHARGER DEBRIEF CABIN AND FLT CREW. ACCOMPLISHED TAS PER AMM 05--51-26-800-801-C1, PERFOMED RIGHT AFT DOOR HEATER OPS CK PER AMM 21-45-00-700-802 AND NO DEFECTS NOTED NO SMELL, INSPECTED HESDR WX0A2025070732492Unknown · odor(AIRCRAFT NOT GROUNDED) F/A REPORTS""DIRTY SOCK"" ODER ON DESENT FROM ABOUT 16000' TO TOUCHDOWN. ODER WAS OBSERVED THROUOUT ENTIRE CABIN. / TROUBLESHOOTING IN PROGRESS"SDR DALA2025070705011Web · corroded(LOG 1059606) CABIN FLOOR STRUCTURE WEB CORRODED AT STA 986 LBL 25. FABRICATED AND INSTALLED NEW WEB AS PER PRI 627324-14 REV0, RECEIVED FINAL ERA 627324-14 REV ORIGINAL, ALL STEPS MATCHED PRI JOB COMPLETE.SDR DALA2025070705005Attach Angle · cracked(LOG 1060122) TWO CRACKS OF 0.320 IN LENGTH AND 0.125 IN LENGTH ON ATTACH ANGLE (DRAIN HOLE/SLOT AREA) AT RH VERTICAL PRESSURE DECK WEB. TWO CRACKS OF 0.320 IN LENGTH AND 0.125 IN LENGTH ON ATTACH ANGLE (DRAIN HOLE/SLOT AREA) AT RH VERTICAL PRESSURE DECK WEB WSDR DALA2025070705003Frame · cracked(LOG 1060034) CRACK ON FRAME STA 400 STGR 8L AT PASSENGER CABIN. CRACK ON FRAME STA 400 STGR 8L AT PASSENGER CABIN WAS REPAIRED PER ER/A 627278-14AD REV. ORIGINAL.SDR DALA2025070705002Attach Angle · crackedCRACK OF 0.600 IN ON ATTACH ANGLE AT THE DRAIN HOLE/SLOT RH SIDE BTW RBL 25 AND RBL 45. CRACK OF 0.600 IN ON ATTACH ANGLE AT THE DRAIN HOLE/SLOT RH SIDE BTW RBL25 AND RBL45 (REF. CARD 5714-01004-02 STEP 13) ASSOCIATED AA 5714-01004 ADDED FOR AC 3756.SDR DALA2025070705001Battery Pack · inoperative(LOG 7229184) EMERGENCY LIGHTS OUT AT R1 DOOR AND FIRST CLASS SEATS. REMOVED AND REPLACED M2816 BATTERY PACK PER B737 AMM 33-51. OPS CHECK GOOD.SDR AALA202507077891Door · no discrepancyAIRCRAFT WAS NOT GROUNDED: DOOR 3L INDICATING AS DISARMED IN FLIGHT ON THE ECAM DOOR PAGE WITH THE ARMING LEVER IN THE PROPER ARMED POSITION. THIS DOOR WAS CONFIRMED AS INDICATING PROPERLY ARMED PRIOR TO DEPARTURE ON THE GROUND. (OPEN)SDR DXTA2025070304117Door · bindingATTEMPTING TO CLOSE THE MAIN CABIN DOOR REQUIRES EXCESSIVE FORCE. MY FO IS PHYSCIALLY UNABLE TO CLOSE THE AIRCRAFT DOOR. CORRECTIVE ACTION: THE ARRIVAL AT THE AIRCRAFT REVEALED THE MED CLOSED WITH THE VENT FLAP OPEN. AFTER OPENING THE DOOR, A VISUAL INSPECTIONSDR AALA202507065841Bulb · inoperativeAIRCRAFT IN BASE MAINTENANCE: DOOR 1R EXIT NEED RELAMP. MAINTENANCE PLACED DOOR 1R EXIT LIGHT IAW AMM 33-51-16-000-001-A STEP 4.A AND IAW AMM 33-51-16-400-001-A STEP 4.B.SDR AALA202507065042Power Supply · inoperativeAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHT TEST FAILED FOLLOWING FAULTS INCLUDEEPSU INT LOAD AFT LEPSU EXT LOAD AFT LEPSU BATTERY EMEP REPSU BATTERY AFT L EPSU UNIT. MAINTENANCE REPLACED 10WL ESPU AND BATTERY IAW AMM 33-51-38, OPS CHECK GOOD.SDR AALA202507065199Sensor · faultedAIRCRAFT WAS GROUNDED: DECLARED AN EMERGENCY INTO GRR ACCOUNT MAINTENANCE, LOSS OF NOSE WHEEL STEERING. AIRCRAFT LANDED WITHOUT INCIDENT AND WAS TOWED TO THE GATE. EMERGENCY VEHICLES RESPONDED AS A PRECAUTION. MAINTENANCE FOUND N/WS FEEDBACK SENSOR 4GC HAS PISDR AALA202507040451Power Supply · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHS AT RH OVERWING DOOR AND CENTER OVERHEAD BETWEEN OVERWING DOORS STAYS ON. MAINTENANCE REPLACED EPSU AND BATTERY IAW AMM 33-51-38.SDR I5PA2025070429301Exciter · faultedFLT NO: MGE 402, APU FAULT ON THE GROUND, UNABLE TO START APU. PERFORMED ECU BITE TEST, MINI FLAGS 28 AND 91. ISOLATED ISSUE TO APU EXCITER. MX R/R APU EXCITER, OPS CHECK.SDR COEA2025070307903Proximity Switch · failedFLIGHT 7820, ENROUTE MSO-GTF AIR TURNBACK/DISCREPANCY: LANDING GEAR FAILED TO RETRACT ON CLIMB OUT. AIRCRAFT WAS RETURNED TO MSO. LANDED SAFELY AND NO EMERGENCY WAS DECLARED. MAINTENANCE DEFERRED THE ISSUE AND AIRCRAFT WAS RETURNED TO SERVICE. DEFERRAL WAS SDR DALA2025070304990Angle · damagedSHIP 3416 CLIP HAS TOOLING DAMAGE AT 2 FASTENERS ON BACKSIDE OF FRAME 61 BETWEEN STRINGERS 1L AND 2L. CORRECTIVE ACTION: REPAIRED PER ERA 627461-14 REV ORIG. (1059891)SDR DALA2025070304985Stringer · damagedSHIP 3412 TOOLING DAMAGE ON STR. 1L FORWARD OF FRAME 60. CORRECTIVE ACTION: REPAIRED PER ERA 627461-14. (1058346)SDR DALA2025070304984Oxygen Mask · unwanted deploySHIP 3307 FA JUMPSEAT AT 2R OXYGEN MASK FELL DOWN IN FLIGHT. CORRECTIVE ACTION: RE-PACKED MASKS PER A330 AMM 35-21. OK FOR SERVICE. (7078091)SDR DALA2025070304983Frame · damagedSHIP 3406 AFT SIDE OF FR61 BETWEEN STR 2L AND 3L NOTED WITH TOOLING DAMAGE 2 EA AREAS IN UPPER AFT RADIUS. CORRECTIVE ACTION: REPAIRED PER ERA 627461-14 REV 0. (1058865)SDR DALA2025070304981Angle · damagedSHIP 3406 CLIP ASSY AT FR 60 AND STR 2R NOTD WITH TOOLING DAMAGE ON LE. CORRECTIVE ACTION: REPAIRED PER ERA 627461-14 REV 0. (1058823)SDR DALA2025070304980Frame · damagedSHIP 3406 AFT SIDE OF FR 60 OTBD OF STR 1R (REINFORCEMENT) NOTED WITH 2 EA AREAS OF TOOLING DAMAGE. CORRECTIVE ACTION: REPAIRED PER ERA 627461-14 REV 0. (1058815)SDR DALA2025070304979Frame · damagedSHIP 3406 AFT SIDE OF FR 62 2" I/B OF STRINGER 4L THE FRAME HAS TOOLING DAMAGE. CORRECTIVE ACTION: REPAIRED PER ERA 627461-14 REV 0. (1058802)SDR DALA2025070304978Frame · damagedSHIP 3406 AFT SIDE OF FR 62 1" I/B OF STRINGER 4L BOTTOM SIDE OF FRAME HAS TOOLING DAMAGE. CORRECTIVE ACTION: REPAIRED PER ERA 627461-14 REV 0. (1058796)SDR DALA2025070304977Bracket · damagedSHIP 3406 AFT SIDE OF FR 61 T-CORD BRACKET TOOLING DAMAGE AFT LWR RADIUS AND AFT UPPER EDGE OF LWR ANGLE. CORRECTIVE ACTION: REPAIRED PER ERA 627461-14. (1058787)SDR DALA2025070304976Frame · damagedSHIP 3406 FWD SIDE OF FR62 STRINGER 1L HAS TOOLING DAMAGE. CORRECTIVE ACTION: REPAIRED PER ERA 627461-14 REV 0. (1058777)SDR DALA2025070304975Frame · damagedSHIP 3406 AFT SIDE OF FR62 BELOW STRINGER 1R HAS 2 SPOTS OF TOOLING DAMAGE. CORRECTIVE ACTION: REPAIRED PER ERA 627461-14 REV 0. (1058760)SDR SWIA2025070300002Sensor · faultedELEVATOR SPLIT CAUTION MESSAGE AND CAS MISCOMP STATUS MESSAGE ILLUMINATED DURING CLIMB OUT AT ABOUT 4000 FT. (FLIGHT 4290 - FILED CLOSED)TROUBLESHOT ELEVATOR SPLIT CAUTION AND CAS MISCOMP STATUS IN REFERENCE TO FIM 27-31-00 AND 31-41-00. NO VISIBLE ELEVATOR SSDR GTIA2025070338979Unknown · odorVERY STRONG MUSTY/DIRTY SOCK ODOR ON DESCENT SMELLED ON FLT DECK, ALL FOUR FA'S REPORTED SAME SMELL THROUGHOUT CABIN. DESCRIPTION OF ODOR/FUMES: PERSISTENT, MUSTY DRY/DIRTY SOCKS SMELL. APPARENT CABIN SOURCE: UNKNOWN. FLIGHT DECK, FWD CABIN/GALLEY(LAV), AFT CASDR SWAA2025070387872Flashlight · no testFWD IB FLIGHT ATTENDANT FLASHLIGHT FLASHING RED<[01] R&R FWD F/A I/B FLASHLIGHT BATTERY REF. AMM 25-64-00 OPS CHECKS NORMALSDR SWAA2025070387938Fastener · looseFWD SERVICE DOOR GIRT BAR WILL NOT STOW PROPERLY. COMPLIED WITH EA M-23-125-01839. INSTALLED FWD SERVICE DOOR GIRT BAR STOW FASTNERSDR SWAA2025070387916Sign · detachedEMERGENCY EXIT SIGN EXIT ROW HAS FALLEN OFF. REMOVED AND REPLACED EMERGENCY EXIT SIGN ON THE CEILING AT ROW 11 IN REFERENCE TO AMM 33-51-01. OPS CHECK GOOD.SDR SWAA2025070387523Charger · overheatedFWD GALLEY EMERGENCY LIGHT BATTERY PACK CHARGER (M02816) OVERHEATING/SMOKING<[01] REMOVED AND REPLACED M02816 POWER SUPPLY CHARGER AND BATTERY PACK. DEEP CYCLE CHARGE AND EMERGENCY LIGHT OPS CHECK GOOD. REF: AMM 33-51-06SDR SWAA2025070387250Slide · out of adjustR-2 DOOR SLIDE CATCHES ON DOOR SILL WHEN CLOSING<[01] ADJUSTED R2 DOOR SLIDE PER AMM 25-66-01SDR SWAA2025070387249Slide · out of adjustL-2 DOOR SLIDE CATCHES ON DOOR SILL WHEN CLOSING. ADJUSTED L2 DOOR SLIDE PER AMM 25-66-01