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 2025FA0000490Skin · crackedRIGHT WING AFT WING WALK CORRUGATED SKIN CRACKED, REPLACED SKIN ASSY WITH NEW.SDR 2025FA0000489Skin · crackedRIGHT WING FWD WING WALK CORRUGATED SKIN CRACKED, REPLACED SKIN ASSY WITH NEW.SDR CALA2025071106461Door Frame · crackedLH O/W HATCH AFT FRAME SEGMENT IS CRACKED. REMOVED AND REPLACED AFT FRAME SEGMENT ON LH O/W HATCH IAW SRM 51-72-11-911-001, SRM 51-42-11-001, SRM 51-75-12-911-002.SDR CALA2025071106460Door Frame · crackedLH O/W HATCH FWD FRAME SEGMENT IS CRACKED. REMOVED AND REPLACED FWD FRAME SEGMENT ON LH O/W HATCH IAW SRM 51-72-11-911-001, SRM 51-42-11-001, SRM 51-75-12-911-002.SDR CALA2025071106459Door Frame · crackedRH O/W HATCH AFT FRAME SEGMENT IS CRACKED. REMOVED AND REPLACED 1EA FRAME DEGMENT (AFT) AT R/H O/W HATCH IAW SRM 51-42-11-001, SRM 51-72-11-911-001, AND SRM 51-75-12- 911-002.SDR CALA2025071106458Door Frame · crackedRH O/W HATCH FWD FRAME SEGMENT IS CRACKED. REMOVED AND REPLACED 1EA FRAME SEGMENT (FWD) AT R/H O/W HATCH IAW SRM 51-42-11-001, SRM 51-72-11-911-001, AND SRM 51-75-12- 911-002.SDR DALA2025071005208Check Valve · leakingSHIP 3255 - MISC - DECLARED EMERGENCY DUE TO LOSS OF THE BLUE SYSTEM QUANTITY AT CRUISE. CORRECTIVE ACTION: REPLACED LEAKING CHECK VALVE AT BLUE SYSTEM MANIFOLD. (LP: A010146)SDR SCNA20250710252Hmu · faultedENGINE 1 ROLLED BACK FROM CLIMB THRUST OF ROUGHLY 97% DURING CLIMB TO 20% N1. NO ABNORMAL INDICATION IN FLIGHT. ENGINE CONTROL LIGHT ILLUMINATED ON GROUND AFTER LANDING. MC NOTIFIED DA 34012. FOLLOWED FIM 79-06 TASK 812 AND PERFORMED EEC BITE AND FOUND FAULT SDR DALA2025071005195Latch · malfunctionedSHIP 3225 DISC: THE LOCKING LATCH IS DOWN, EXPOSING ORANGE WARNING STICKER ON THE LATCH. MASKS NOT FULLY DEPLOYED, OXYGEN PANEL MASK DEPLOYED. C/A: MASKS NOT DEPLOYED AT ALL. DOOR SECURE. RESET LATCH. SECURED. OK FOR SVC. (LP: 1061299)SDR DALA2025071005192Oxygen Panel · brokenSHIP 3260 DISC: PAX 02 STORAGE PANEL BROKEN WIULL NOT STA LATCHED ROW 13FED. C/A: REPOSITIONED MASKS AND LATCHED DOOR CLOSED AND LOCKED IAW CMM 25 -28-02 ALL SECURITY CKS GOOD. "M" PROCEDURES REVERSED, MEL AND PLACARD REMOVED. SEATS OK FOR SVC. (LP: 7274672)SDR 2025F00161Warning Light · illuminatedNR 2 ENGINE CONTROL LIGHT IS ON.SDR N3XR202507090001Hinge · crackedDURING A ROUTINE INSPECTION, THE LOWER RUDDER HINGE FITTING WAS FOUND CRACKED ON THE LOWER PORTION AROUND EACH CORNER BETWEEN RIVET HOLESSDR AALA202507096600Shim · migratedAIRCRAFT IN BASE MAINTENANCE: VERTICAL STABILIZER RIGHT HAND REAR SPAR TERMINAL FITTING HAS SHIM WASHERS MIGRATING OUT FROM THE AFT SIDE OF THE OUTBOARD LUG. INSTALLED SHIMS AND ALL HARDWARE. PER AMM 53-30-00.SDR REXA2025070900714Lamp · inoperativeRH AFT EXTERNAL EMERGENCY LIGHT INOP RELAMPED RH AFT EXTERNAL EMERGENCY LIGHT IAW AMM 33-51-15 R/R LENSE FOR RH AFT EXTERNAL EMERGENCY LIGHT IAW CRJ900 AMM 33-51-15 OPC GOOD.SDR SWAA2025070888307Skin · bulgedLH INBD TRAILING EDGE AFT FLAP UPPER FLAP SKIN AREA HAS BULGE 2.5IN FROM TRAILING EDGE AND 7IN FROM INBD EDGE<[01] REF TTG8Q013J5AB FOR REMOVAL AND INSTALLATION OF L/H INBOARD AFT FLAP REF AMM 27-51-12;[02] PERFORMED RII OF LH INBOARD AFT FLAP INSTALLATION ON SDR DALA2025070805164Retainer · crackedSHIP 3122 DAMAGES ON THE G5 GALLEY COMPARTMENTS 510, 511, 512 TROLLEY RETAINER AREA. CORRECTIVE ACTION: ACCOMPLISHED ER/A 627623-14. (1061643).SDR AALA202507081324Control Valve · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: LEFT PACK CAME ON DURING CRUISE AND LEPT FAILING. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT MIA. ACCOMPLISHED FIM TASK 21-62-00-810-830, REMOVED AND REPLACED LEFT TCV, PER AMM 21-51-10. OPERASDR F3LA202507080266Eec · defectiveENG 2 FADEC SYS FAULT ON DEPARTURE CLIMBOUT, EMERGENCY CHECKLIST APPLIED, RETURNED TO ATL. REMOVED AND REPLACED ELECTRONIC ENGINE CONTROL (EEC) CHANNEL A IAW AMM 73-21-55-080-802-A/400-802-A OPS CHECKED GOOD.SDR AALA202507087872Hinge Fitting · wornAIRCRAFT IN BASE MAINTENANCE: LEFT HAND ELEVATOR #4 HINGE ARM FITTING BEARING RACE SPINNING. REPLACED HINGE ARM FITTING PER AMM 55-16-42.SDR AALA202507087969Fitting · wornAIRCRAFT IN BASE MAINTENANCE: LATERAL AVIONIC COMPARTMENT LEFT HAND SUPPORT ARM FITTING WORN AT FR 20 AND S29L. REPLACED SUPPORT ARM FITTING PER SRM 51-42-11.SDR AALA202507089195Window · crazedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND FORWARD EMERGENCY EXIT WINDOW CRAZED. REMOVED AND REPLACED RIGHT HAND FORWARD EMERGENCY EXIT WINDOW. PER AMM 56-22-00.SDR AALA202507089745Window · crazedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND AFT EMERGENCY EXIT WINDOW CRAZED. REPLACED RIGHT HAND AFT EMERGENCY EXIT WINDOW. PER AMM 56-22-00.SDR AALA202507089538Battery Pack · failedAIRCRAFT IN BASE MAINTENANCE: L1 ENTRY DOORWAY EMERGENCY LIGHTS FLICKER UNCOMMANDED. FOUND TEST BUTTON BROKEN OFF, REMOVED AND REPLACED EMERGENCY BATTERY PACK. PER AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR AALA202507085006Slide · dislodgedAIRCRAFT WAS NOT GROUNDED: FRONT ENTRY DOOR WAS OPENED WITH JETBRIDGE ATTACHED WITHOUT BEING DISARMED. SLIDE DID NOT DEPLOY. REMOVED AND REPLACED L1 DOOR SLIDE. PER JOBCARD 08L22125001. OPERATIONAL CHECK GOOD.SDR AALA202507089693Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR DIFFICULT TO OPEN. FOUND DOOR FRAME TRIM LOOSE (LATCH SIDE). SECURED AS REQUIRED, OPERATIONAL CHECK GOOD.SDR AALA202507088423Hinge · excess playAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTANDENTS REPORTS FORWARD LAVATORY DOOR STICKS. FOUND HINGE ON FORWARD LAVATORY DOOR TO HAVE EXCESSIVE PLAY. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202507083092Flashlight · no testAIRCRAFT WAS NOT GROUNDED: AFT GALLEY FLIGHT ATTENDANT EMERGENCY FLASHLIGHT NOT PROPERLY FUNCTIONING, DPES NOT STAY ON. REPLACED FLASHLIGHT. PER AMM 25-64-00.SDR AALA202507088422Acm · failedAIRCRAFT WAS GROUNDED: SMOKE AND FUME IN FLIGHT DECK REACHING 15,000FT IN CONJUNCTION WITH A LEFT PACK FAIL AFTER TAKEOFF. REMOVED AND REPLACED (ACM)-AIR CYCLE MACHINE. PER AMM 21-51-04. OPERATIONAL CHECKED GOOD.SDR CALA2025070806332Strap · crackedCRACK INDICATIONS FOUND RT SIDE BS639 I/B STUD BEAM STRAP, AFT LOWER HOLE, IN I/B STRAP AT 3 AND 5 O'CLOCK POSITIONS AS VIEWED FROM O/B. REMOVED AND REPLACED SUTB BEAM CRACKED STRAP IAW BAC DWG 144A1705 REV B AND UAL ECRA 5340-02235 AND EA5340-02153 ESFR COMPSDR NACA2025070300003Elec Connector · dirtyRH ENG LOOP 1 OVHT/FIRE STATUS MESSAGE. CLEANED AND RESECURED ELECTRICAL CONNECTOR D4230P IAW WPM 26-11-11 OPS CHECK OK.SDR NACA2025070300002Indicator · inoperativeRH ENGINE OIL PRESS IND BLANK. CLEANED AND RESECURED ELECTRICAL CONNECTOR P4208P IAW WPM 36-11-62 OPS CHECK OK.SDR NACA2025070300001Elec Connector · dirtyCLEANED AND SECURED ELECTRICAL CONNECTOR D4208P OPS CHECK OK WPM 36-11-62.SDR ASAA2025070359244Glowstrip · detachedFA REPORTED PHOTOLUMINESCENT STRIP IN FRONT OF LAV D AND G HAVE COME UP. THE STRIP HAS BEEN PLACED IN THE FWD CABIN CLOSET AT FIRST CLASS FOR SAFE KEEPING. GROUNDED - YES. REMOVED AND REPLACED PHOTOLUMINESCENT STRIP AS REQUIRED.SDR ASAA2025070359237Handle · no discrepancyL1 DOOR HANDLE STIFF AND REQUIRED EXCESSIVE FORCE TO OPEN. GROUNDED - YES. CW L1 DOOR SYSTEM TEST REF AMM 52-11-00-700-804 DOOR HANDLE TORQUE TEST WITHIN LIMITS. AS PRECAUTION PERFORM DOOR LUBING.SDR ASAA2025070359204Cover · detachedLIGHT COVER ON DIVIDER WALL BY AFT LAV LEFT SIDE KEEPS FALLING OFF. GROUNDED - YES. REPLACED EMERGENCY LIGHT RECEPTACLE. OPS CK OK.SDR SWAA2025070787977Flashlight · not seated2 AFT STATION EMERGENCY FLASHLIGHTS INOP. RESTEATED FLASHLIGHTS OPS CHECK GOOD ER AMM 25-64-00 MEL CLEARED.SDR SWAA2025070788055Flashlight · no testFWD INBD FA FLASHLIGHT WON'T TEST. OK TO CONTINUE PER MEL 25-12-01; SP1B. R& R FWD. FLASHLIGHT (INBD) IAW MM 25-64-00.SDR SWAA2025070788063Slide · dislodgedFA (A) REPORTS L1 EVACUATION SLIDE FELL OUT OF THE BAG WHEN DOOR WAS OPENED. SLIDE DID NOT DEPLOY. REPLACED L1 SLIDE PER MT 725-61-06.SDR SWAA2025070788312Lens · detachedCEILING MOUNTED EXIT SIGN BETWEEN OVERWING EXIT ROWS HAS DETATCHED. INSTALLED EXIT SIGN LENS PER AMM#33-1-01.SDR SWAA2025070787693Handle · looseAFT ENTRY DOOR HANDLE IS LOOSE. TIGHTENED AFT ENTRY DOOR HANDLE IAW AMM 52-13-31-400-802.SDR SWAA2025070787696Handle · looseFWD SERVICE DOOR HANDLE IS LOOSE. TIGHTENED FWD SERVICE DOOR HANDLE IAW AMM 25-21-35-420-801.SDR SWI2025F00855Proximity Sensor · out of rigGEAR DISAGREE AFTER SELECTING GEAR UP, NOSE WHEEL WOULDN?T SHOW UP. GEAR WAS SELECTED UP AT 195 KNOTS, ALL HYDRAULIC PUMPS ACTIVE. RAN QRH, PUT GEAR DOWN, ALL GEAR SHOWED DOWN AND GREENC: MEL 32-30-1CAT A DUE ONE FLIGHT DAY 07/04/2025**CAT II DOWNGRADED** B1-0SDR SWI2025F00854Floor Support · damagedREMOVED TWO FASTENERS ON RH PRESSURE FLOOR SILL ANGLE AT FS513.00 AND BETWEEN RBL42.4 - RBL36.0 TO FOM (FILED OPEN)THIS IS CURRENTLY A WORK IN PROGRESSSDR SWIA202507070003Tie Down · damagedCENTER CARGO NET TIE DOWN RING ASSY WITH TWO ANGLES (REF SRM 53-61-43 ITEMS 6 & 8) REMOVED TO F.O.M. WITH REFERENCE TO SRM 51-42-21. (FILED OPEN)THIS IS CURRENTLY A WORK IN PROGRESSSDR DALA2025070705064Bottle · low pressureSHIP 3424 3L DOOR ASSIST LOW. SERVICED DOOR ASSIST BOTTLE PER A330 AMM 52-15. (7463970)SDR DALA2025070705062Frame · damagedSHIP 3406 FWD SIDE OF FR61 BETWEEN STR 2R & 3R NOTED WITH TOOLING DAMAGE ON FWD FACE AND FWD UPPER RADIUS. CORRECTIVE ACTION: REPAIRED PER ERA 627552-14. (1061995)SDR DALA2025070705061Bracket · damagedSHIP 3406 FWD SIDE OF FR61 BETWEEN STR 1R AND 2R. REINFORCEMENT ITEM #57 NOTED WITH TOOLING DAMAGE ON UPPER INBD FWD FACE. CORRECTIVE ACTION: REPAIRED PER ERA 627548-14 REV ORIG. (1061976)SDR GTIA2025070738981A/C Pack · odorON T/O FA REPORTED FUME/ ODOR IN CABIN COMPLIED WITH QRH ISOLATED PACK 2 OFF FUME/ODOR DISIPATED. DESCRIPTION OF ODOR/FUMES: TEMPORARY, WASTE: FISH SMELL. APPARENT CABIN SOURCE: CABIN AIR SUPPLY VENTS. FWD CABIN AND AFT CABIN. NO VISIBLE SMOKE/HAZE. NO MEDICALSDR GTIA2025070738980Unknown · odorFUME EVENT REPORTED BY AFT FLIGHT ATTENDENT OUT OF 10K FT. REPORTED AS SWEET CHEMICAL SMELL THAT LASTED MOMENTARILY AND DISSIPATED AFTER SEVERAL MINS. DESCRIPTION OF ODOR/FUMES: TEMPORARY, UNFAMILIAR CHEMICAL SMELL. APPARENT CABIN SOURCE: CABIN AIR SUPPLY VENTSDR IPXA2025070758664Door · inoperativeL1 CABIN DOOR INOP THIS ITEM IS DEFERRED BY MEL 52-10-3-1-2-1-2, PLACARD INSTALLED, NO DMP.