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 SWAA2025121250802Light · missingPASSENGER CABIN SEAT ROW 24ABC PHOTOLUMINESCENCE STRIP MISSING. INSTALLED A PHOTOLUMINESCENCE STRIP IAW AMM 33-51-15.SDR SWAA2025121250796Bulb · unsecurePASSENGER CABIN RIGHT EMERGENCY EXIT LIGHT INTERMITTENT. SECURED THE LIGHT BULB IAW AMM 33-21-00.SDR SWAA2025121251103Battery Pack · inoperativeEMERGENCY LIGHTS BATTERY PACK AT M1673 INOPERATIVE. REPLACED BATTERY PACK M1673 IAW AMM 33-51-06. TESTED GOOD.SDR SWAA2025121251124Cover · detachedLIGHT COVER FOR FO SIDE OVERWING EXIT DOOR AT 14F DETATCHED. SECURED LIGHT COVER IAW AMM 33-51-04.SDR SWAA2025121251232Screw · missingROW 11F TRAY TABLE BROKEN AT SEAT 11F. REPLACED A MISSING TRAY TABLE SCREW IAW CMM 25-23-46.SDR DALA2025121209103Oil System · overservicedA/C 8120 -FUMES- CREW REPORTED DIRTY SOCK SMELL AND DONNED O2 MASKS. EMERGENCY WAS DECLARED. CORRECTIVE ACTION: MTC FOUND RT ENGINE OVERSERVICED. (LP# 7932476)SDR DALA2025121209095Shutoff Valve · fluctuatesSHIP 3740 -ATB/DE- DUE TO CABIN PRESSURE AND RIGHT BLEED PRESSURE FLUCTUATIONS. MTC R/R PRSOV PER B737 AMM 36-11.SDR DALA2025121209094Receptacle · cracked(LOG 1344966) EXTERNAL POWER RECEPTOICE CUT OUT LOWER FLANGE CRACKED. PERFORMED REPAIR ON THE EXTERNAL POWER RECEPTICLE CUT OUT LOWER FLANGE IAW DELTA ERA 630999-14.SDR DALA2025121209087Torque Box · corrodedHORIZONTAL STABILIZER CENTER TORQUE BOX UPPER SURFACE CORROSION AT FRONT SPAR AND FROM OTBD EDGE 33 INCH. THE REWORKED AREA REPAIRED IAW PRI:630636 -14 REV.0 AND REV.1. COMPARED AND COMPLIED WITH ERA:630636-14 SECTION I REV. (1344652)SDR DALA2025121209086Skin · crackedFUSELAGE SKIN FASTENERS CUTOUT CRACK AT STA 1654.5 AND S-3L. THE FUSELAGE SKIN STA 1654.5 S-3L FASTENERS CUTOUT CRACK SREPAIRED IAW SRM53-80-01-2R-4, FIG 201, REV 76 AND ER/A 630618-14 REV.ORIGINAL PRI PEV.0. THE PRI 630618-14 REV.0 C (1344630)SDR DALA2025121209085Floorbeam · crackedFOUND AFT CARGO FLOORBEAM CRACK AT BS 1109 , RBL 32 AND LBL 32. REPAIRED PER PRI 630656-14. (1344415)SDR VNAA2025121211101Unknown · odorSTRONG SMELL OF KEROSENE IN FLIGHT AROUND ROWS 16-18. NO OTHERS SMELLS NOTED NO SMOKE NOTED. TROUBLESHOT SMELL OF KEROSENE? IN CABIN IAW FIM 21-22-00-810-806-A01. AFTER MULTIPLE ENGINE RUNS COULD NOT MANAGE TO DUPLICATE THE SMELL. DID NOT FIND ANY LEAKS OR FSDR 8G9R1212202501Pump · damagedHYDRAULIC SYSTEM FOUND CONTAMINATED WITH METAL SHAVINGS IN THE MAIN AND RETURN FILTERS. RH HYDRAULIC PUMP TO BE REMOVERD AND SENT OUT.SDR AALA202512122487Proximity Switch · out of adjustAIRCRAFT WAS GROUNDED: 1L DOOR WILL NOT STAY ARMED WHEN LEVER IS LOWERED. MAINTENANCE 1L DOOR WILL NOT STAY ARMED WHEN LEVER IS LOWERED. MAINTENANCE ADJUSTED PROX SWITCH 4WN1 PER MM52-71-00-820-002-A.SDR FDEA202512102230Skin · dentedLEFT HORIZONTAL STAB UPPER SKIN HAD REPAIR DAMAGE AT LOWER INTERNAL SURFACE, HSS 104.248 & 128.248, DENT WITH DELAMINATION AT LT HORIZONTAL STAB UPPER SKIN ON LOWER INTERNAL SURFACE WAS APPLIED PERMANENT REPAIR IAW SRM 55-10-01-1A, TABLE 1, NOTE I, & SRM 51-SDR FDEA202512102229Skin · dentedLEFT HORIZONTAL STAB UPPER SKIN HAD FIVE DENTS BETWEEN HSS 81.249 AND 104.248, APPLIED PERMANENT REPAIR AT LT HORIZONTAL STAB UPPER SKIN IAW SRM 55-10-01-1A, TABLE I NOTE I & SRM 51-70-10-2RSDR FDEA202512102228Floor Panel · dentedMAIN DECK CARGO COMPARTMENT, FLOOR PANEL 232NFF GOUGED. REPAIRED MAIN DECK FLOOR PANEL 232NFF RBL 77.5 - 77.5, BS 654 + 22 INCHES, IAW SRM 53-00-50-2R. MAJOR REPAIR.SDR FDEA202512102227Floor Panel · dentedMAIN DECK CARGO COMPARTMENT, LT FLOOR PANEL 231NFF HAS SEVERAL DENTS. REPAIRED MAINDECK FLOOR PANEL 231NFF LBL 33 - 54.75, BS 654, 22 INCHES IAW SRM 53-00-50-2R. MAJOR REPAIR.SDR FDEA202512102226Floor Panel · dentedMAIN DECK CARGO COMPARTMENT, LT FLOOR PANEL 231PFF HAS PUNCTURE DAMAGE. REPAIRED MAIN DECK FLOOR PANEL 231PFF AT BS 654 22, LBL 54.75 - 77.5 IAW SRM 53-00-50-2R. THIS IS A MAJOR REPAIR.SDR DXTA2025121206055Fitting · defectiveAFTER LANDING LINE TECH INFORMED US THAT LEFT MAIN WAS SMOKING. FOUND SMOKE COMING FROM LEFT MAIN. REPLACED BRAKE TOP BLEED FITTING. OPS CHECK GOOD. IAW MM 32-48-00SDR CALA2025121212079Valve · faultedNR 1 ENGINE IS EXPERIENCING AN INCREASE IN OIL CONSUMPTION. PE RFORM A VISUAL INSPECTION THE SUBJECT ENGINES EDUCTOR VALVE. BE SURE TO CHECK THE AIR LINE THAT RUNS ALONG THE VALVE TO SEE IF THERE ARE ANY INDICATIONS. IAW AMM 79-21-17/401 FOR LOCATION OF THE EDSDR CALA2025121212078Drain · cloggedLAVATORY IS SHOWING FULL WITH POTABLE WATER FULL, LAV SERVICED AT 1329 LCL IAW FLIGHT FEED VERIFIED LAV SERVICE. WASTE ITANK IS EMPTY. VERIFIED LAV OPERATION WITH NO LEAKS. REQUEST MEL 3802F. TOILETS FLUSH NORMALLY. NO LEAKS NOTED - TOMC APPROVED PLACED LAV SDR CALA2025121212077Anti-Ice Valve · faultedUPON APPLICATION OF T/O THRUST RT ENG COWL ANTI- ICE AMBER LIGHT ILLUMINATED. R & R OF NR 2 COWL ANTI ICE VALVE, RT ENG ANTI-ICE VALVE REPLACED. OPS CHECK OK IAW AMM 30-21-11.SDR CALA2025121212064Fuel Cap · missingFUELER REPORT FUELING CAP MISSING.SDR CALA2025121212062Coffeemaker · odorACRID SMELL AND VISIBLE SMOKE & HAZE IN AFT GALLEY /LAST 2 PAX ROW S. CHECKLISTS RAN, DIVERTED. DEBRIEFED INBOUND FLIGHT CREW. CREW NOTED HAZE IN AFT OF AIRCRAFT CABIN, AND ODOR WAS NOTABLY WORSE WHEN LT PACK SWITCH WAS PLACED IN AUTO DURING FLIGHT. REMOVEDSDR CALA2025121212052Sensor · faultedRIGHT PACK OFF FOLLOWED BY ACRID ODOR, THEN EICAS SMOKE. PLACED ON MEL 2151A. REMOVED AND REPLACED LOWER FLOW CONTROL & SHUTOFF VALVE (FCSOV) IAW AMM 21-51-02-400-801. REPLACED RT AIR PACK FLOW SENSOR IAW AMM 21-51-03/401. ALL TESTS PASS, RAN ENGINE AND PACSDR CALA2025121212047Cover · brokenEMERGENCY LIGHTS - OPS TEST WITH THE TEST SWITCH PROCEDURE - ROW 25ABC EMERGENCY PATHWAY LIGHT BROKEN REPLACED PLASTIC COVER ON EMERGENCY PATHWAY LIGHT, OPS CHECK GOOD.SDR CALA2025121212046Bottle · low pressure2L SLIDE PRESSURE IN RED. INSPECTED ESCAPE SLIDE PACK INFLATION CYLINDER PRESSURE REF AMM 25-66-01-200-801. PRESSURE WITHIN LIMITS. OK FOR SERVICE. INSPECTED ESCAPE SLIDE PACK INFLATION CYLINDER PRESSURE IAW AMM 25-66-01-200-801. PRESSURE WITHIN LIMITS. OK SDR ASAA2025121062252Bottle · unserviceableFORWARD SERVICE DOOR ESCAPE SLIDE UNSERVICEABLE, REQ'S REPLACEMENT. GROUNDED - YES. FWD SERVICE DOOR ESCAPE SLIDE REMOVED AND REPLACED. SECURITY & OPS CK GOOD IAW AMM 25-61-01. AC OKAY FOR SERVICE.SDR AALA202512117192Pressure Switch · faultyAIRCRAFT WAS NOT GROUNDED: THE RIGHT AFT FUEL PUMP LOW PRESSURE LIGHT DOES NOT ILLUMINATE WHEN SWITCH IS TURNED OFF. REMOVED AND REPLACED RIGHT AFT PRESSURE SWITCH. PER AMM 28-42-11. OPS CHECKED GOOD, NO LEAKS NOTED.SDR AALA202512111051Sign · brokenAIRCRAFT WAS NOT GROUNDED: AFT GALLEY EXIT SIGN BROKEN OVER AFT LEFT DOOR. REMOVED AND REPLACED AFT GALLEY EXIT SIGN OVER AFT LEFT DOOR. PER AMM 33-53-01.SDR SWAA2025121151241Handle · brokenR1 SERVICE DOOR HANDLE BROKEN. R & R R1 SERVICE DOOR HANDLE IAW AMM 52-11-31.SDR 8G9R20251211001Bulkhead · crackedCRACK FOUND ON 703 BULKHEAD TOP RIGHT CORNER OF ACCESS HOLE. VERIFIED WITH EDDY CURRENT .375" IN LENGTHSDR GTIA2025121139198Flashlight · no testL1 JUMPSEAT FLASHLIGHT TEST BUTTON INOP ( FLASHLIGHT AND HOLDERS (FLIGHT DECK OR CABIN) )-R/R L1 FLASHLIGHT AND TEST BUTTON PER A/C DRAWING TITLE A321 CEO EMERGENCY EQUIPMENT LAYOUT DRAWING NUMBER A321 CEO EMER EQUIP THIS CLEARS DMI LG PG 3504116-2 LOG BK UPDASDR IPXA2025121171825Landing Gear · faultedATB, AFTER T/O WHEN RETRACTING THE L/G THE RIGHT REMAINED DOWN AND LOCKED. GEAR DISAGREE EICAS MESSAGE.RETURNED TO SNN AND REMAINING TWO GEARS EXT NORMALLY FOR LANDING. FLAPS OPERATED NORMALLY.SDR SIMA20251210001Warning Message · false activationINFO TO MTX HAD A FLAP FAIL MESSAGE ON EICAS PERFORMED QRH RESET PROCEDURE MESSAGE CLEARED ON EICAS. EMERGENCY DECLARED. NO INJURIES. PERFORMED OPERATIONAL CHECK OF FLAP SYSTEM.OPC GOOD FOR NO FLAP FAIL MESSAGE ON EICAS IAW ERJ AMM 27-50-00.SDR AALA202512119628Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR IS VERY DIFFICULT TO OPEN AND CLOSE AIRBORNE. WORKS NORMALLY ON THE GROUND. MAINTENANCE ADJUSTED THE FLIGHT DECK DOOR PER AMM 52-51-00.SDR AALA202512115693Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L2 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202512113517Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R3 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202512114122Bottle · low pressureAIRCRAFT WAS NOT GROUNDED, L3 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR YENA2025121101199Unknown · odorFLT 1371, LGA-FLL. TRANSIENT ODOR OFENGINE EXHAUST IN AFT GALLEY FROM TAKEOFF TO 10,000 FT. ODOR DISSAPATED AFTER THAT. NR 3 FA NOTED ODOR BUT NOT NOTED BY OTHER CREW OR PAX; COMPLIED WITH INFO NOTICE 2017-T015L SECTION A- ISOLATED FAULT TO TYPE 10 AMBIENT AIRSDR ABXA20251210327Generator · faultedDURING TAXI AND UPON NR 2 ENGINE START, RT GENERATOR CONT INDICATED OFF, RT AC BUSS INDICATED NO POWER, RT BUSS TIE INDICATED OFF AND FMC AND LOWER EICAS WENT DEAD. AIRCRAFT RETURNED TO BLOCKS (BTB). MAINTENANCE TESTED RT IDG IAW FIM 24-20-43 A1. OPS CHECKEDSDR YENA2025121101198Unknown · odorFLT 995, HPN-MCO. ON R-BASE TO FINAL 36L, LEVELING AT 2000 MSL, GOT SUBTLE DIRTY SOCK SMELL WITH APU OFF, BOTH PACKS ON ,ALL CREW SMELLED IT.M; COMPLIED WITH INFO NOTICE 2017-T015K SECTION A INSPECTED APU COMPARTMENT AND FOUND TRACES OF OIL ON INTAKE AND MID DSDR DALA2025121109060Cover · detachedEXIT SIGN COVER CAME OFF AT 2R EXIT DOOR ABOVE PAX HEAD. RESECURED LIGHT COVER. (8215272)SDR DALA2025121109059Bearing · migratedMIGRATED BEARING OF FLAP TRACK NBR 4 ON FWD/ UPPER SUPPORT FITTING (UPPER LINK) AT LH WING. INBD FLAP TRACK OF INBD TE FLAP AT LT WING WAS REMOVED AND INSTALLED PER B757-200 AMM 27-51-03 AND WAS REWORKED IAW CMM 27-51-87. BEARING FORWARD OF INBD FLAP TRACK SDR DALA2025121109058Frame · gougedGOUGE ON BS 1640 BETWEEN S15L & 16L JUST FWD OF L4 DOOR. REFERENCE AMDS TASK CARD 2020-2424, STEP 5. GOUGE ON FS 1640 BETWEEN STR 15L AND STR 16L JUST FWD OF L4 DOOR WAS REPAIRED PER ER/A 630534-14 REV. ORIGINAL SECTION I: PERMANENT REPAIR.SDR DALA2025121109056Handle · stuckATB, DUE TO THE FLAP/SLAT CONTROL UNIT HANDLE STUCK AT POSITION 2. FOUND HANDLE TRIGGER SECURING PIN BROKEN. CORRECTIVE ACTION: REPLACED FLAP/SLAT COMMAND SENSE UNIT. (LP 7796736)SDR DALA2025121109055Coffeemaker · failedIN CRUISE, AFT FLT ATTS REPORTED FAINT ODOR LIKE ARM PLASTIC IN GENERAL VICINITY OF AFT GALLEY. MOST DETECTABLE IN CART STOWAGE AREA. TURNED OF TWO COFFEE MAKERS. ODOR REPORTED SLOWLY DISSIPATING BUT OCCASIONALLY DETECTABLE. FOUND AFT GALLEY COFFEE MAKER NOSDR DALA2025121109054Power Supply · inoperativeWHILE CONDUCTING EMERGENCY LIGHT TEST, FOUND FAULT EPSU (15WL) MID L. FOUND RECEPTACLE DAMAGED/SHORTED AT 7260VC2 CAUSING EPSU AT 15WL TO BLOW INTERNAL FUSE. REPLACED EPSU 14WL PER A321 AMM 33-51-38. CHECKS NORMAL. REPLACED RECEPTACLE 726OVC2. REPLACED EPSSDR DALA2025121109051Light · missingMISSING EMERGENCY PATH LIGHT AT 4A. INSTALLED MISSING EMERGENCY LIGHT IAW AMM 33-51. OPS CHECKED GOOD. (7980888)