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 CALA2025102310446Light · detachedRED EMERGENCY LIGHT ON SEAT 20C FELL OFF. RESECURED 20C RED AISLE LIGHT IAW CMM 25-23-54, OPS CHECK GOOD.SDR CALA2025102310445Power Supply · no testEMERGENCY BATTERY W/C 18-3351-1-0003 FAILED. REQUIRES 13WL POWER SUPPLY AND BATTERY. REMOVED AND REPLACED 13WL EPSU AND BATTERY PER AMM 33-51-38, ALSO REPLACED BATTERY 11WL PER 33-51-38, OPS TEST OF ALL EMERGENCY LIGHTS TEST OK FROM THE FAP. VISUAL OF ALL EMESDR CALA2025102310444Door Frame · crackedCRACK INDICATION NOTICED ON RT SIDE E-F POST NR 3 FASTENER HOLE. ACCORDING WITH EA 5310-08195 REV. OP 004 STEP B (26). IF CRACK IS OBSERVED AFTER IT WAS REAMED TO THE PRE COLD WORKED DIAMETER. COMPLIED WITH ECRA 5310-08708. REF AAR RFD NONROUTINE 1000048714. SDR CALA2025102310443Battery Pack · no testEMERGENCY EXIT LIGHTS TURNED ON IN THE AIR. FLASHING INTERMITTANTLY. REPLACED FWD EMERGENCY BATTERY M33093 ABOVE DOOR L1. REPLACED AFT EMERGENCY BATTERY M33098 ABOVE DOOR R2 ALL EMERGENCY LIGHTS GROUND TEST PASSED.SDR CALA2025102310442Frame · crackedCRACK INDICATION NOTICED ON THE LT SIDE E-F POST 3 AND 5 FASTENER HOLES. ACCORDING WITH EA 5310-08195 REV. OP 003 STEP B (26). IF CRACK IS OBSERVED AFTER IT WAS REAMED TO THE PRE COLD WORKED DIAMETER, COMPLIED WITH ECRA 5310-08709. REF AAR RFD NON ROUTINE 10SDR CALA2025102310441Pressure Deck · deformedCOCKPIT FLOOR DENTED JUST AFT OF PEDESTAL. ELEVATED FLIGHT DECK FLOOR WEB BETWEEN BS 250-260 LBL20-RBL20, FOUND AREAS WITH SHARP GOUGES, OUT OF LIMITS IAW SRM 53-10-51-1A-1 ALLOWABLE DAMAGE 1 SECT 41. FLOOR STRUCTURE FIG 105 SHT 2 DETAIL D. REMOVED DAMAGED SDR SWAA2025102226890Slide · unpackedR1 DOOR GIRT BAR WILL NOT STAY ENGAGED INTO DOOR HOOK. REPACKED R1 DOOR SLIDE IAW AMM 25-66-01.SDR CALA2025102210412Floorbeam · damagedREPAIRED FLOORBEAM STA 365.25 UPPER CHORD, RBL 64 TO 47.SDR CALA2025102210411Lens · missingEMERGENCY LIGHTS OPS TEST WITH THE TEST SWITCHES, GALLEY 2, 3X FLOOR PROX LIGHT LENS CAPS MISSING ADJACENT TO STOWAGE 227, 228 & 235. LIGHT IS FULLY FUNCTIONING. FLOOR PROX LIGHT LENS CAPS ADJACENT TO STOWAGE 227, 228 & 235 REPLACED IAW AMM 33-51-10-962-172.SDR CALA2025102210410Fuel Cap · missingPDA 2 FUEL CAP MISSING PLACED ON CDL 28A REF LP 6707105.SDR CALA2025102210409None · noneINSTALLED THE SLIDE'S SAFETY PIN INTO THE SLIDE'S INFLATION CYLINDER VALVE PER AMM 52-11-02-904-004 AND INSTALLED THE EMERGENCY POWER SAFETY PINS AT L2 DOOR REMOVED SLIDE'S INFLATION CYLINDER VALVE AND EMERGENCY POWER SAFETY PINS. VERIFIED SLIDE SAFETY PIN IS SDR CALA2025102210408Sign · brokenSEAT 39C AISLE EMERGENCY MARKER IS BROKEN REMOVED AISLE EMERGENCY LIGHT AT 39C, LACARD PLACED ON FA PANEL. REQUESTING 3319E MEL 3319E LIGHT IS WITHIN 2 SEAT ROWS OF A MONUMENT AND MUST WORK MOVED 34 C TO 39 C. OPS CHECKED EMERGENY AISLE LIGHTS. OPS CHECKED GOOSDR CALA2025102210407Lamp · no testEMERGENCY LIGHTS ABOVE 40 AND 43 JKL INOPERATIVE DURING OPS TEST WITH THE CONTROL SWITCHES PROCEDURE, EMERGENCY AREA LIGHTS LAMP REPLACED. IAW 33-51-03-960-801.OPS CHK OK.SDR CALA2025102210406Door · leakingEMERGENCY EXIT DOOR BY SEAT 21F HAS HIGH PITCH SQUEAL ABOVE FL25 0. CAB ALT/VS NORMAL. APPLIED SPEED TAPE TO WTB SEALS 192DT IAW MT 53-004, TAPE RECHECK DAILY, REPLACE SEALS WITHIN 1000 FH, REQUEST CREW COMMENT TO DETERMINE IF VIBRATION ELIMINATED. OK TO DIP TSDR CALA2025102210405Unknown · odorREPLACE RECIRC FILTERS DUE TO ODOR EVENT REPLACED RECIRC FILTER IAW AMM 21-25-01. NO DEFECTS NOTED. FA AND PAX SMELLED SOMETHING LIKE BURNING RUBBER APPEARED TO BE STRONGER IN AFT CABIN. DEBRIEFED CREW. CREW STATED INITIALLY SMELLED BURNING RUBBER SMELL IN SDR CALA2025102210404Engine · no discrepancyBIRDSTRIKE TO ENG 1OR2. BRIEF SMELL IN FLIGHT DECK. ENG IN ST NORM. T/O DEN 17R AT 100KTS PERFORMED NR 1 ENGINE BIRD STRIKE ISPECTION IAW AMM 05-51-18. NO DEFECT NOTED. SUSPECT BIRD WENT THRU THE ENGINE CORE. PERFORMED ENGINE INSPECTION IAW 79-21-02. NR 1 ENSDR CALA2025102210403Potable Water · contaminatedWATER HAS STRONG CHEMICAL SMELL AND TASTE REF FIM 38-10 TASK 810 DUMPED AND FLUSHED POTABLE WATER. SMELL IS NO LONGER. ACFT OK FOR SERVICESDR CALA2025102210402Flapper Valve · faultedDURING CONDITIONAL INSPECTIONAL FOR ODORS REF 05-51-26-800-801-C1, FOUND PC AIR FLAPPER STUCK PARTIALLY OPEN SUPPLIED PRESSURE TO THE PNEUMATIC SYSTEM WITH THE APU, TASK 36-00-00-860-803, PC AIR FLAPPER CLOSES NORMALLY AND DOES NOT LEAK. PC AIR FLAPPER IS NOT SDR CALA2025102210401Unknown · odorON TAKEOFF ROLL EXP ELEC FUMES SMELL.TOOK 5 MINS TO DISSIPATE SC AN CLEAN ALL ACFT DEBRIEFED CREW WITH COMPLETETION OF FORM 46.6020. NO SYSTEM ABNORMALITIES OR OTHER FLT DECK EFFECTS. ACP'D CONDITIONAL INSP, REF TASK 05-51-58-910-801-C1. SUSPECT FAULTY KORRY SSDR CALA2025102210400Toilet · leakingAFT AIRCRAFT FLOOR FROM ROW 36 AFT LAVS AND GALLEY FLOODED W/ S OME TYPE OF LIQUID FOUND LEAK COMMING FROM LAV D TOILET RINSE VALVE. COMPLIED WITH MEL 3830D. VACUUMED DAMP CARPET. DRIED WITH FANS. THIS IS A DIRTY WATER LEAK THAT CONTAMINATED THE LAV D AREA CASDR CALA2025102210399Outflow Valve · faultedCABIN ALT WARNING ON DESCENT, CABIN ALT 10/11 THOUSAND FT. COMPLIED WITH CABIN ALT QRC DEFER AUTO 1, BRIEFED OTBND CREW. PERFORMED DCPC BITE CK 1 FAULT REPORTED CODE 017. PULLED & COLLARD PRESSURIZATION CONTROL AUTO 1 CB ON P6-4 PANEL MEL 2114A REJECTING MELSDR WX0A2025102232606Battery Pack · inoperative(AIRCRAFT NOT GROUNDED) FOUND EPSU BATTERIES 11WL AND 12WL REQUIRES REPLACEMENT. REMOVED AND REPLACED BATTERIES REF A320 AMM 33-51-38-000-002-A & 33-51-38-400-002-A. OPS CHECK GOOD AT THIS TIME.SDR JR2R20251022409Shear Panel · corrodedRH SHEAR PANEL AT FR87 TO FR88 AND RBL12 TO RBL 48 IS CORRODED. OUT OF LIMITS. REPLACEDSDR JGVR20251022002Hinge Bracket · corrodedREMOVED CORRODE AREAS ON THE LOWER RUDDER HINGE BRACKET AND RUDDER TRIM BRACKET, PERFORMED NDT AND REPORTED FOR REPAIR DISPOSITION. CLEANED, TREATED, AND PRIMED BLENDED AREAS IAW NETJETS REQUEST FOR TECHNICAL SERVICES REPORT.SDR JGVR20251022001Skin · corrodedREMOVED 10 AREAS OF CORROSION LOCATED ON EMERGENCY EXIT DOOR AROUND CONTOUR RINGS ON OUTER E-EXIT SKIN, PERFORMED NDT AND REPORTED FOR REPAIR DISPOSITION. CLEANED, TREATED, AND PRIMED BLENDED AREAS IAW NETJETS REQUEST FOR TECHNICAL SERVICES REPORT.SDR JR2R20251022403Floor Support · corrodedFLOOR SILL AT FR12 TO FR14 AND RBL 36 TO RBL 48 IS CORRODED OUT OF LIMITS. REPLACEDSDR IPXA2025102288227Pump · trippedPASSING FL210 NOTED APPROX 900 LB IMBALANCE- L OUTER 8.1 R OUTER 7.2. ALSO CENTER (R) FUEL PUMP FAULT LIGHT ON. CENTER TANK WAS FEEDING. FOLLOWED ECAM AND AOM FOR MAN. FUEL CNTRL TO BALANCE FUEL. FOUND R/H CENTER PUMP CONTRACTOR RESET POPPED. RESET RELAY. OPSSDR DALA2025102207745Engine · making metalIFSD/DIV/DE- DIVERTED TO SAL DUE TO LEFT ENGINE FAILURE. MAINTENANCE FOUND METAL ON CHIP DETECTORS, REMOVED AND REPLACED ENGINE.SDR JR2R20251022412Gusset · corrodedGUSSET AT RBL 11 AND FR91 IS CORRODED. OUT OF LIMITS, REPLACEDSDR DALA2025102207730Spinner · leakingDURING ARRIVAL, DESCENDING THROUGH 8000'. BOTH PILOTS NOTICED A DIRTY SOCK SMELL. FLIGHT ATTENDANTS CONFIRMED THE ODOR. BOTH PILOTS DONNED 02 MASKS. AFTER ARRIVAL, APU WAS STARTED AND NO ODOR NOTICED. FOUND NBR 1 ENG SPINNER WET WITH OIL. REPLACED NBR 1 INLESDR DALA2025102207729Power Supply · no testCABIN EMER LIGHTS OUT AT ROWS 11-14 ABC. 14WL FAILED EPSU TEST, REPLACED 14WL AND BATTERY REF A321 AMM 3-51. OPS TEST GOOD. (LP 7782876)SDR ICRR202510220002Thrust Link · crackedSUB SURFACE INDICATION FOUND DURING MAGNETIC PARTICLE INSPECTION (SOPM 20-20-01)SDR VNAA2025102211104Hinge · gougedFITTING, AILERON, HINGE NO. 3 GOUGE DAMAGE. / VERIFIED PERM REPAIR OF THE RH AILERON HINGE FITTING NO. 3 IAW EA 57-2025-0822-A. DETAILS ON FILE FORM 337 COMPLETED. NO FURTHER DEFECTS NOTED AT THIS TIME.SDR VNAA2025102211103Hinge · gougedFITTING, AILERON, HINGE NO. 2 GOUGE DAMAGE. / VERIFIED PERM REPAIR OF THE RH AILERON HINGE FITTING NO. 2 IAW EA 57-2025-0824-A. DETAILS ON FILE FORM 337 COMPLETED. NO FURTHER DEFECTS NOTED AT THIS TIME.SDR VNAA2025102211102Hinge · gougedFITTING, INBOARD, AILERON, HINGE NO. 4 GOUGE DAMAGE. / VERIFIED PERM REPAIR OF THE RH AILERON HINGE FITTING NO. 4 IAW EA 57-2025-0825-A. DETAILS ON FILE FORM 337 COMPLETED. NO FURTHER DEFECTS NOTED AT THIS TIME.SDR VNAA2025102211101Skin · dentedDENT DAMAGE FOUND ON FUSELAGE AT FS 949.00, BETWEEN STRINGERS 20R AND 21R. THE DENT IS SMOOTH AND FOUND CRACK FREE BY VISUAL INSPECTION. DIMESION ARE 0.067 X 1.57 X 0.118 INCH. VERIFIED WORK PERFORMED AT RHS FUSELAGE FS942.00-FS897.00 STR 19R-22R IAW REO 690-5SDR ICRR202510220001Thrust Link · crackedSUB SURFACE INDICATION FOUND DURING MAGNETIC PARTICLE INSPECTION (SOPM 20-20-01)SDR JR2R20251022411Floor Support · corrodedINTERCOSTAL AT FR90 TO FR91, RBL 11, IS CORRODED. OUT OF LIMITS. REPLACED.SDR 9WGA2025102134401Circuit Card · dirtyCONTINOUS MASTER WARNING FIRE MAIN DECK FWD INFLIGHT, TROUBLESHOT PER FIM 26-16, TASK 864, CLEAN CIRCUIT CARD PER AMM 26-10-01, FIRE SYSTEM TEST, AMM 26-11-00, PASS NO FAULTS.SDR FDEA202510222071Frame · corrodedAFTER REMOVAL OF EXHAUST DUCT AND CORE ON APU FOUND SEVERE CORROSIONB ON FRAME (148N1606) AT STA 1992.8 APPOX 6 INCHES AT THE 6 OCLOCK POSITION (APPROX 4-7 O CLOCK) WAS FOUND FRAME, RING AND SPLICE WITH CORROSION OUT OF LIMITS EVALUATED IAW B757 SRM 53-SDR FDEA202510222070Skin · dentedREWORK: RH WING IB AFT FLAP LWR SURFACE FOUND DENT AT 58 INCHES TO OB EDGE AND 3 INCHES TO FWD EDGE. REPAIRED RH WING IB AFT FLAP LWR SURFACE DENT AT ITEF BS 279 IAW SRM 57-53-01- 2R-1, & SRM 51-70-04-2R-1, REV 51.0, EA:G-5750-T0385411 P1. MAJOR REPAIR SDR FDEA202510222069Doubler · crackedFUSELAGE: #1 AIRCONDITION RAM AIR EXHAUST ASSY CUT OUT PRODUCTION DOUBLER SUSPECT CRACKED. CRACKED DOUBLER AT FUSELAGE #1 AIRCONDITION RAM AIR EXHAUST ASSEMBLY AT LEFT HAND STATION 561.667 REMOVED AND REPLACED WITH FABRICATED DOUBLER AS PER MD-11 SRM 51- SDR FDEA202510222068Doubler · crackedFUSELAGE: #1 AIRCONDITION RAM AIR EXHAUST ASSY CUT OUT PRODUCTION DOUBLER SUSPECT CRACKED. CRACKED DOUBLER AT FUSELAGE #1 AIRCONDITION RAM AIR EXHAUST ASSEMBLY AT LEFT HAND STATION 561.667 REMOVED AND REPLACED WITH FABRICATED DOUBLER AS PER MD-11 SRM 51- SDR FDEA202510222067Floor Panel · damagedMAIN CARGO COMP. APROX. STA 285 TO 412 & RBL54.75 TO RBL77.5, ABOVE FLOORBOARD PANEL 222CFF HAS INDENTATION. FABRICATED NEW FLOOR PANEL 222CFF, MPN: 141T5856-116, RBL 54.75- RBL 77.50, STA 282-412 IN REF. TO BOEING DWG 141T5856-116. SEE JPF FOR ALL THE WORSDR FDEA202510222066Floor Panel · damagedMAIN CARGO COMP. APROX. STA 285 TO 412 & RBL11 TO RBL33, ABOVE FLOORBOARD PANEL 222AFF HAS INDENTATION. FABRICATED NEW FLOOR PANEL 222AFF, MPN: 141T5856-107, RBL 11- RBL 33, STA 282-412 IN REF. TO BOEING DWG 141T5856-107. SEE JPF FOR ALL THE WORK PERFORMEDSDR FDEA202510222065Floor Panel · damagedMAIN CARGO COMP. APROX. STA 285 TO 412 & LBL11 TO RBL11, ABOVE FLOORBOARD PANEL 221CFF HAS INDENTATION. FABRICATED NEW FLOOR PANEL 221CFF, MPN: 141T5856-105, LBL 11- RBL 11, STA 282-412 IN REF. TO BOEING DWG 141T5856-105. SEE JPF FOR ALL THE WORK PERFORMEDSDR FDEA202510222064Floor Panel · damagedMAIN CARGO COMP. APROX. STA 285 TO 412 & LBL 33 TO LBL 11, ABOVE FLOORBOARD PANEL 221DFF HAS INDENTATION (MARKED) FABRICATED NEW FLOOR PANEL 221DFF, MPN: 141T5856-117, LBL 11- LBL 33, STA 282-412 IN REF. TO BOEING DWG 141T5856-117. SEE JPF FOR ALL THE WORKSDR FDEA202510222063Beam · crackedLOWER CENTER CARGO DOOR UPPER DOOR JAMB CENTER BEAM FOUND CRACKED AT BS 1746.925. LOWER CENTER CARGO DOOR UPPER DOOR JAMB CENTER BEAM CRACKED AT STATION 1746.925 REPAIRED AS PER MD-11 SRM 53-50-15-2R FIGURE 201 REPAIR 2. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2SDR JR2R20251022521Seal Rest · corrodedAFT CARGO DOOR CUTOUT, FWD SEAL REST IS CORRODED OUT OF LIMITS. REPAIREDSDR F3LA202510220317Elt · failedREFERENCE LTPR NR 5001433153-0010 AIRCRAFT WAS NOT GROUNDED AND IS IN CHECK FOR SCHEDULED MX. DURING BITE TEST, CONTROL PANEL (111MX) INDICATOR LIGHT DOESN'T FLASH (110MX) ELT FAILED. REPLACEMENT IS REQUIRED IAW 25-65-35-04 CONF00 REV 54. REPLACEMENT OF (110