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 IPXA2025072925042Floor Panel · damagedMDC FLOOR 261DM, CRACK ON L/H AFT CORNER.MCD FLOOR PANEL REPAIRED IAW A300-600 SREO-42721-REQ001.SDR IPXA2025072925236Floor Panel · damagedCOMP MAIN CARGO FLOOR PANEL 262DM HAS COMPOSITE DAMAGE.MCD FLOOR PANEL REPAIRED IAW A300-600 SREO-42721-REQ001SDR AALA202508067903Actuator · failedAIRCRAFT WAS GROUNDED: THE NOSE GEAR DOORS OPENED WHILE ON APPROACH 4,000 AND 3,000 (VERY LOUD WIND NOISE ).THE RED NOSE GEAR, RED GEAR LEFT AND RIGHT RED LIGHT UNSAFE WARNING LIGHTS INTERMITTENTLY ILLUMINATED WITH THE WARNING HORN WHILE THE GEAR HANDLE WAS INSDR AALA202508061538Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY HINGE ARM END FITTING ELEVATOR #3 ON RH HORIZONTAL STABILIZER. MAINTENANCE REPLACED HINGE ARM 3 ELEVATOR ON RH HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202508063525Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY HINGE ARM END FITTING ELEVATOR #4 ON RH HORIZONTAL STABILIZER. MAINTENANCE REPLACED HINGE ARM 4 ELEVATOR ON RH HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202508068041Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY HINGE ARM END FITTING ELEVATOR#6 ON RH HORIZONTAL STABILIZER. MAINTENANCE REPLACED HINGE ARM 6 ELEVATOR ON RH HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202508068886Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY HINGE ARM END FITTING ELEVATOR #5 ON RH HORIZONTAL STABILIZER. MAINTENANCE REPLACED HINGE ARM 5 ELEVATOR ON RH HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202508063090Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY HINGE ARM END FITTING ELEVATOR #1 ON RH HORIZONTAL STABILIZER. MAINTENANCE REPLACED HINGE ARM 1 ELEVATOR ON RH HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR FDEA202507201360Web · crackedMAIN DECK CARGO COMPARTMENT - UNDER FLOOR FR47 WEB CRACKED BETWEEN Y0 AND -Y450 REPAIRED THE MAIN DECK CARGO COMPARTMENT UNDER FLOOR FR47 CRACKED WEB BETWEEN Y0 AND -Y450 PER A300-600 SRM 53-15-15-201 PARA.5A. THIS IS A CAT B REPAIR. THE FIRST INSPECTION WSDR IPXA2025080116917Handle · misalignedL1 DOOR WILL NOT CLOSE PROPERLY. SUSPECT LWR GATE ASSY FUNCTIONALITY WITH MAIN HANDLE INVERTED. REMOVED AND REPLACED LOWER LATCH PUSHROD IAW AMM 52-11-19. PERFORMED ADJUSTMENT IAW AMM 52-11-01. INSTALLED DOOR LINER PANELS IAW AMM 52-11-02.SDR AALA202508011236Valve · failedAIRCRAFT WAS GROUNDED: THE NOSE GEAR DOORS OPENED WHILE ON APPROACH 4,000 AND 3,000 (VERY LOUD WIND NOISE ).THE RED NOSE GEAR, RED GEAR LEFT AND RIGHT RED LIGHT UNSAFE WARNING LIGHTS INTERMITTENTLY ILLUMINATED WITH THE WARNING HORN WHILE THE GEAR HANDLE WAS INSDR AALA202508018581Bungee · failedAIRCRAFT WAS GROUNDED: THE NOSE GEAR DOORS OPENED WHILE ON APPROACH 4,000 AND 3,000 (VERY LOUD WIND NOISE ).THE RED NOSE GEAR, RED GEAR LEFT AND RIGHT RED LIGHT UNSAFE WARNING LIGHTS INTERMITTENTLY ILLUMINATED WITH THE WARNING HORN WHILE THE GEAR HANDLE WAS INSDR AALA202507311400Compensator · inaccurateAIRCRAFT WAS NOT GROUNDED: IN FLIGHT, LEFT MAIN FUEL TANK CONTINUOUSLY DISPLAYING A LOWER AMOUNT. EVEN AFTER BALANCING THE FUEL, LEFT MAIN GOES LOWER THAN RIGHT BY UP TO 600 LBS. VERIFIED INOPERATIVE MAIN FUEL INDICATION LIGHT. REMOVE AND REPLACED THE LEFT HSDR AALA202507309812Splice · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION SPLICE UPPER POSITION INBOARD SIDE ON FLOOR BEAM -Y1162.5 AT LEVEL FR68 AT AFT GALLEY AREA L=1.684 INCH, W=0.961 INCH, D= 0.078 INCH. MAINTENANCE REPLACED SPLICE LOC. UPPER POSITION INBOARD SIDE ON FLOOR BEAM -Y1162.5 SDR CALA2025072907028Shade · torn20L WINDOW SHADE ON EMER DOOR IS TORN WINDOW SHADE REMOVED FROM EMERGENCY EXIT ROW 20L. PLACED ON MEL WINDOW SHADE REMOVED FROM EMERGENCY EXIT ROW 20L. REMOVED. DEFERRED REF 2520LY PACED ON MEL R&R WINDOW SHADE REF AMM 25-21-00SDR DALA2025072805622Bushing · wornSHIP 6710 4L DOOR WILL NOT ARM. ARMING LEVER JAMMED. CORRECTIVE ACTION: REMOVED DOOR SLIDE COVER IAW B757 MM 52-11-02. FOUND BUSHINGS WORN ON FWD LIFTER BRACKET CAUSING GIRT BAR TO FALL OUT AND NOT BE ABLE TO ARM. REMOVED AND REPLACED WORN BUSHING. ADJUSTED GISDR AALA202507256323Bolt · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION SLAT TRACK 4 BOLT (LOWER BOLT) SLAT 1 ON RH WING MEASURE CORROSION ARE L=0.117 INCH W=0.071 INCH D=0.001 INCH. MAINTENANCE REPLACED SLAT TRACK 4 BOLT (LOWER BOLT) SLAT 1 ON RH WING IAW A319 AMM 27-84-63-400-002-A.SDR AALA202507251452Light · burnedAIRCRAFT IN BASE MAINTENANCE: BURNED EMERGENCY EXIT LIGHT ON CEILING PANELS INPASSENGER CABIN. MAINTENANC REPLACED EMERGENCY EXIT LIGHT ON CEILING PANEL IN PASSENGER CABIN AND PERFORMED TEST IAW AMM 33-51-16-000-001-A AND AMM 33-51-16-400-001-A.SDR CALA2025072506920Line · leakingOIL QTY DROPPED STEADILY TO 0 PERCENT. W/IN APPRO 20MIN OIL PRES S FLUCTUAT TO RED LIMIT. REMOVED AND REPLACED #1 ENGINE REF AMM 71-00-02-400-802-F00, ALL OPS CHECKS NORMAL, NO LEAKS NOTED.VERIFIED #1 ENGINE CHANGE IAW GMM 09-25-05, MONITORED DYNAMETERS, CONSDR CALA2025072506913Light · inoperative12D SEAT EMERGENCY PATH LIGHT IS BROKEN REMOVED AND REPLACED 12D SEAT PATH LIGHT AS REF. IFM 25-26-36. CHECKED ITEM, IT OPERATES OK.SDR CALA2025072506912Slide · unsecureAFT EMER EXIT SLIDES HANGING BELOW CONTAINER ADJUSTED R2 AFT SLIDE PACK AS REQ.SDR QXEA2025072400281Lever · bindingR1 DOOR DIFFICULT TO ACUATE ARMING LEVEL. REMOVED FROM SERVICE. MEASURED INITIAL RIGGING VALUES AND MADE ADJUSTMENTS PER AMM 52-41-00-820-801-A. ARMING LEVEL WORKS AS NORMAL FOR R1 DOOR. RETURNED TO SERVICE.SDR ASAA2025072059642Power Supply · inoperativeEMERGENCY LIGHTS ASSOCIATED WITH POWER SUPPLY M1673 ARE INOPERATIVE. GROUNDED - YES. REMOVED AND REPLACED EMERGENCY LIGHTS POWER SUPPLY IAW AMM 33-51-06-960-806.OPS CHECK GOOD.SDR SWAA2025072493275Flashlight · no discrepancyFLASHLIGHT AT FWD FA JUMP SEAT INOPERATIVE. PERFORMED CHECK OF FWD F/A FLASHLIGHT IAW AMM 25-64-00. OPS CHECKED GOOD. NO DEFECTS FOUND. THIS CLEARS MEL 25-64-02A.SDR SWAA2025072493276Lamp · inoperativeCEILING LIGHT F/O SIDE ROW 4 AND 5 INOP CEILING LIGHT CAPTAIN SIDE ROW 4 AND 5 INOPERATIVE. RELAMPED CEILING LIGHT AT ROWS 4-5 ABC REF AMM 33-22-00. OPS CHECKED GOOD.SDR DALA2025072405578Light · no testNRC 200-026. MTC TASK - DURING OPS CHECK OF EMERGENCY LIGHTING, FOUND DR2L EXTERIOR EMERGENCY LIGHT(151WL21) NOT ILLUMINATED. DR2L EVACUATION AREA LIGHT UNIT FIN: 151WL21 REMOVED AND REPLACED IAW AMM A350-A-52-12-73. INSTALLATION TEST CARRIED OUT AS PER AMM A3SDR DALA2025072405576Ecu · faultedSHIP 5650 - ATO - REJECTED TAKEOFF BELOW 80 KTS DUE TO APU FAULT DURING NO BLEED TAKEOFF. CORRECTIVE ACTION: APU PLACED ON MEL FOR DC POWER LOSS FAULT. PERFORMED HIGH ENERGY STOP INSPECTION. NO DEFECTS FOUND. LATER, REPLACED APU ECU AND APU BATTERY BUS CIRCUITSDR DALA2025072405549Oil System · leakingSHIP 3236 ON TAXI IN AFTER APU BLEED SELECTED ON, EXPERIENCED MUSTY GYM SOC SMELL. CONCERNED ABOUT POSSIBLE OIL CONTAMINATION IN BLEED SYSTEM SMOKE & FUMES QUESTIONAIRE COMPLETED ELECTRICALLY. REF LOG 1091553 FOR CORRECTIVE ACTION NO OIL CONTAMINATION FOUND SDR CALA2025072406878Girt Bar · fodL1 DOOR HARD TO ARM, NO SLIDE LIGHT ILLUMINATION. REMOVED DEBRIS FROM GIRT BAR FITTINGS, DIRT AND CATERING CART PLASTIC LOCKS, AND LUBED. OPENED AND CLOSED DOOR 1L AND ARMED SLIDE WITH NO ISSUES AND SLIDE LIGHT ILLUMINATED. REPEATED 3 TIMES AND HAD FLIGHTSDR N6WA2025072303Floor Support · corrodedFS349-FS409 RH SILL IS CORRODED AT THE SCREW HOLES. REMOVED AND REPLACED RH FLOOR SILL BETWEEN FS349-FS409 IAW CRJ SRM 51-42-06 AND GOJET EO-C550-53-MIA-078-OSDR SWAA2025072393265Sign · detachedRIGHT SIDE OVER WING EMERGENCY EXIT SIGN HAS COME OFF. RESECURED RT OVER WING EMERGENCY EXIT SIGN PER AMM 33-51-01.SDR SWAA2025072393221Lens · detachedMID- CABIN EXIT SIGN BROKEN OFF. INSTALLED MID-CABIN EMERGENCY EXIT SIGN LENS PER SIP.SDR SWAA2025072393464Lens · looseEMERGENCY EXIT LIGHT LENS LOOSE ROW 3 DEF, SECURED LENS WITH TAPE. OK TO CONTINUE PER MEL 3-15-02 SP-1B . REINSTALLED EMERGENCY LIGHT LENS AT ROW 3DEF PER AMM 33-51-03. OPS CHECK GOOD.SDR SWAA2025072393259Sign · detachedF/A FWD CHIME LIGHTS PLASTIC COVER KEEPS FALLING OFF. R&R FWD EMERGENCY EXIT SIGN ASSEMBLY OPS OK IAW AMM 33-51-01.SDR SWAA2025072393234Lamp · inoperativeAFT RT LOWER EMER LIGHT INOPERATIVE. RELAMPED EMER LIGHT IAW AMM 33-51-04.SDR SWAA2025072393506Lens · looseOVERWING EXIT SIGN COVER FELL OFF. SECURED LENSE PER AMM 33-51-01.SDR R61A2025072000314Mau · failedAVNX MAU 1A FAIL. EMERGENCY DECLARED, LANDED WITHOUT INCIDENT. REMOVED AND REPLACED NIC PROC MOD 1.SDR WX0A2025072332510O-Ring · worn(AIRCRAFT NOT GROUNDED) DURING CRUISE, FL 340, AFT FA'S REPORTED SOUR MILK SMELL AT LEAST 4 TIMES DURING CRZ. W/ EYE IRRIATITION. LOCATION L2 DOOR / REF WO# 526976 NRC 22814-1 FOR REPLACEMENT OF APU FUEL CONTROL UNIT DUE TO PHASE 2 ODOR EVENT TASK CARD. NO FURSDR DXTA2025072304309Keyway · failedCAN NOT OPEN MAIN CABIN DOOR BECAUSE KEY JUST SPINS GAINED ACCESS TO AIRCRAFT ON THE RAMP AT SIGNATURE SLC. CONFIRMED THAT THE KEY SPUN FREELY IN THE DOOR HANDLE BUT THE LOCK WOULD NOT UNLOCK. TECHS WERE ABLE TO GET THE LOCK TO UNLOCK AND ALLOW THE DOOR TO BE SDR DXTA2025072304310Brake Assy · malfunctionedDURING TAXI OUT THE RIGHT MAIN LANDING BRAKES SHUTTERED VIOLENTLY! TAXIED BACK TO RAMP! REMOVED THE WORN RH BRAKE ASSEMBLY. INSTALLED A OVERHAULED RH BRAKE ASSEMBLY REFERENCING AMM: 32.-45-.21-000/400-801-A. BLED THE BRAKE SYSTEM REFERENCING AMM: 32-40-00-87SDR DALA2025072305525Oxygen Mask · unwanted deploySHIP 3276, OXY MASKS DEPLOYED ON T.O. AT SEATS 1C/D. RESTOWED O2 MASKS + SECURED COVER. O2 GEN NOT ACTIVATED. IAW A320 AMM 35-21. (LP: 7324770)SDR DALA2025072205519Bushing · excess playSHIP 3155 EXCESSIVE PLAY PASSENGER CREW DOOR 831 UPPER AND LOWER BUSHING BETWEEN DOOR AND SUPPORT ARM AT FWD GALLEY AREA. CORRECTIVE ACTION: PERFORMED DVI ON BUSHES UPPER AND LOWER BEFORE INSTALL TELESCOPIC ROD OF PASSENGER CREW DOOR 831 BTW DAMPER AND SUPPORTSDR SWAA2025072293270Flashlight · no testCOKPIT FLASHLIGHT WILL NOT TEST. R&R CAPTAINS EMER FLASH LIGHT IAW AMM 25-64-00.SDR DALA2025072205496Seat Track · corrodedREAR BARREL SEAT TRACKS. AT LH FR 71 IB MULTIPLE AREAS OF CORROSION ON THE SEAT TRACK. REPLACED SEAT TRACK REF. A220 ASRP 51-42-00 AND A220 DWG C01342700. (LP# 1095019)SDR DALA2025072205495Seat Track · corrodedREAR BARREL SEAT TRACKS. AT LH FR 71 OB MULTIPLE AREAS OF CORROSION ON THE SEAT TRACK (M). REPLACED SEAT TRACK REF. A220 DWG C01342700 AND A220 ASRP 51-42-00. (LP# 1095032)SDR DALA2025072205494Seat Track · corrodedREAR BARREL SEAT TRACKS. AT RH FR 71 OB MULTIPLE AREAS OF CORROSION ON THE SEAT TRACK (M). REPLACED SEAT TRACK REF. A220 ASRP 51-42-00 AND A220 DWG C01342700.SDR M3XA20250720004Relay · overheatedPILOT PERFORMED A PRECAUTIONARY LANDING FOR A BURNING SMELL IN THE CABIN. DURING INSPECTION OF THE ACFT THE MECHANIC FOUND A RELAY WITH SIGNS OF HIGH HEAT. MECHANIC REPLACED RELAY PN 389FXAXC1-24D. FUNCTION CHECK OK WITH NO FURTHER SMELLSDR DXTA2025072204318Proximity Switch · out of adjustIN FLIGHT WE HAD AN INTERMITTENT 'EMER EXIT' WITH ASSOCIATED MASTER CAUTION CORRECTIVE ACTION: ADJUSTED PROX SWITCH. OPS CHECK GOOD. IAW AMM 52-20-01.SDR CALA2025072206844Hmu · faultedMENTIONED TO MX TECH NUM TWO ENG LAGGED AFTER TOGA. ALMOST 30-40 SPLIT AT ONE POINT UPDATE LABOR HOURS REPLACED HYDROMECHANICAL UNIT PER AMM 73-21-10/401. ACCOMPLISHED POWER PLANT RUN TEST REFERENCE TABLE ( TASK 71-00-00-800-811-F00.SDR AALA202507217903Landing Gear · abnormalAIRCRAFT WAS GROUNDED: THE NOSE GEAR DOORS OPENED WHILE ON APPROACH 4,000 AND 3,000 (VERY LOUD WIND NOISE ).THE RED NOSE GEAR, RED GEAR LEFT AND RIGHT RED LIGHT UNSAFE WARNING LIGHTS INTERMITTENTLY ILLUMINATED WITH THE WARNING HORN WHILE THE GEAR HANDLE WAS IN