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 CALA2025102110328Bracket · corrodedAFTER THE SCUFF PLATE WAS REMOVED AT L4 PAX DOOR, AREA UNDER FOUND SPOTS WITH CORROSION. REMOVED AND REPLACED (3EA ANGLE) CLIP P/N 146N5246U61 BATCH 0004 433738 SUPPORT P/N 146N5246U5 BATCH 0004433522 AND BRACKET P/N U A1489-113 TRAVELER T25/1836788 ON LOWER SDR CALA2025102110327Intercostal · corrodedFWD CARGO BAY, BETWEEN BS 720-740 AND STR 27R-28R, INTERCOSTAL HAS EVIDENCE OF CORROSION. NR: 134672 COMPLETED SFR REPORTING ONLY REMOVED CORROSION ON FWD CARGO INTERCOSTAL STA 720-740 STR 27R-2 8R. IAW B757-300 SRM 51-10-02. FOUND OUT LIMITS ORIGINAL MAT 0.0 SDR CALA2025102110326Intercostal · corrodedFWD CARGO CMPT, BETWEEN STA 660-680 STR 28R, INTERCOSTAL HAS EVIDENCE OF CORROSION. COMPLETED SFR REPORTING ONLY REMOVED AND REPLACED INTERCOSTAL AT FWD CARGO COMPT BETWEEN STA 660-680 STR 28R.SDR ASAA2025101661633Landing Gear · malfunctionedNOSE GEAR CAME DOWN WHEN POSITIONING GEAR TO OFF AFTER TAKE OFF. RAN QRH. NOSE GEAR RETRACTED NORMALLY WHEN BROUGHT TO THE UP POSITION. DID NOT FALL AGAIN WHEN PUT TO OFF WHILE PUTTING GEAR DOWN. GEAR CAME DOWN NORMALLY ON LANDING. GROUNDED - YES. C/W FIM TASKSDR AALA202510209486Actuator · misinstalledAIRCRAFT WAS GROUNDED: LEFT MAIN GEAR WOULD NOT RETRACT WHEN GEAR HANDLE WAS RAISED. RETURNED GEAR HANDLE TO DOWN POSITION AND RECEIVED NORMAL GEAR INDICATION FOR MAIN GEAR. RETURNED TO TUL, EMERGENCY DECLARED AND ;LANDED WITHOUT INCIDENT. MAINTENANCE FOUND L/SDR AALA202510204988Battery · no testAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS UNABLE TO TEST EMERGENCY FLASHLIGHT LOCATED AT #4 JUMPSEAT. MAINTENANCE REPLACED FLASHLIGHT BATTERY.SDR SWAA2025102025214Trim Motor · inoperativeELECTRIC STABILIZER TRIM INOPERATIVE. ] R & R STAB TRIM MOTOR PER AMM 27-41-71 OPS CHECK GOOD.SDR SWAA2025102024990Fastener · shearedFWD SERVICE DOOR 6: RT BAR CLIP FASTENER SHEARED. COMPLIED WITH EA-23-125-01839SDR SWAA2025102024700Door · crackedLEFT MAIN LANDING GEAR CENTER DOOR HAS CRACK. REMOVED LT MLG CENTER & INNER DOOR IAW AMM 32-13-11, OK TO CONTINUE SERVICE.SDR SWAA2025102024851Knob · missingFWD GALLEY MEGAPHONE MISSING VOLUME KNOB. REPLACED THE FWD GALLEY MEGAPHONE PER AMM 25-64-00. OPS CHECK GOOD.SDR SWAA2025102024703Flashlight · no testAFT LH GALLEY FLASHLIGHTS DID NOT TEST. REPOSITIONES FLASHLIGHTS IN CRADLE & SEALED. FLASHLIGHTS TEST NORMAL PER MM 25-64-00SDR SWAA2025102024936Slide · out of positionFWD SERVICE DOOR EMERGENCY ESCAPE SLIDE MISSING COVER OVER PULL TO RELEASE HANDLE. PULLED FLAP OVER ?PULL TO RELEASE HANDLE? ON FWD SERVICE DOOR ESCAPE SLIDE. NO DEFECTS NOTED PER AMM 25-66-00SDR SWAA2025102024970Fuse · blownEMERGENCY LIGHT BEHIND L2 INOPERATIVE. R & R THE FUSE FROM BATTERY POWER SUPPLY M1673 IAW AMM 33-51-06-960-804. TEST PASSED.SDR SWAA2025102024974Elec Connector · disconnectedEMERGENCY CEILING LIGHT AT SEAT 10DEF IS INOPERATIVE. PERFROMED TROBLESHOOTING EMERGENCY LIGHT AT SEAT ROW 10DEF INOP; FOUND CONNECTORS D14816/D14830 DISCONNECTED; RECONNECTED CONNECTORS AND PERFORMED GOOD TEST PER AMM 33-51-00-710-801.SDR GTIA2025102039136Unknown · odorDESCENDING THROUGH 16,000 STRONG MUSTY , WET DOG, CHEMICAL FUME ODOR IN FLT DECK. CALLED FLT ATTENDANTS & THEY REPORTED THE ODOR IN FWD ,MID, & AFT CABIN. RAN QRH PROCEDURE FOR ELIMINATION OF ODOR / FUMES. FIRST TURNED OFF PACK 1, STRONG ODOR REMAINED IN CABINSDR AALA202510205571Heat Shrink · missingAIRCRAFT WAS NOT GROUNDED: DURING CHANGE OF L2 DOOR SLIDE MISSING RED HEATSHRINK. **SUPPLEMENTAL REPORT FOR (AALA202510175571): REPLACED HEAT SHRINK TUBING ON L2 SLIDE GIRT BAR. PER AARD 25-66-00-4**(CLOSED).SDR DALA2025102007633Pin · broken(LOG 7785936) FLIGHT CREW REPORTS 1L DOOR DIFFICULT TO OPEN AND CLOSE. FOUND GUST LOCK BROKEN. R&R GUST LOCK PIN IN UPPER HOLD OPEN GUIDE ARM REF B737 AMM 52-11. OPS NML.SDR DALA2025102007632Fitting · corroded(LOG 1255801) STA 947 FLOORBEAM HAS CORROSION UNDER LAV FITTING AT RBL50. PERFORMED REPAIR ON STA 947 FLOOR BEAM UNDER LAV FITTING AT RBL50 IAW B737-900 SRM 53-70-51-2R-8. RESTORED FINISH TO AREA IAW B737-900 SRM 51-20-01-0G.SDR DALA2025102007631Frame · damaged(LOG 1255562) REPAIR OF LEFT-HAND STATION, 727 FRAME INNER CHORD. FABRICATED AND INSTALLED SHIM BETWEEN STA 727 FRAME INNER CHORD AND S-18A WEB, REPAIRED IN ACCORDANCE WITH CC# 5311-01251-02A.SDR DALA2025102007630Frame · damaged(LOG 1255557) REPAIR OF RIGHT-HAND STATION, 727 FRAME INNER CHORD. FABRICATED AND INSTALLED SHIM BETWEEN STA 727 FRAME INNER CHORD AND S-18A WEB, REPAIRED IN ACCORDANCE WITH CC#5311-01251-02B.SDR IPXA2025102008002Flap System · faultedON APPROACH RECEIVED FLAPS SYS 1&2 FAULT. FLAPS WOULD GO TO 20 THEN COMEBACK UP A FEW DEGREES AND THEN GIVE A JAM INDICATION OF FLAP SYS 1&2 FAULT. ++REPLACED #4 JACKSCREW PER AMM 27-54-24-401. OPS CHECK GOOD. VERIFIED AND WITNESSED #4 JACKSCREW INSTALLATION RSDR AALA202510208251Windshield · crackedAIRCRAFT WAS GROUNDED: CLIMBING OUT OF FL220 TO FL230 ENCOUNTERED MODERATE POSSIBLY SERVERE TURBULENCE WHICH RESULTED IN THE LEFT FLIGHT DECK WINDSHIELD CRACKING. MAINTENANCE REPLACED WINDSHIELD AND ACCMPLISHED A SATISFACTORY OPERATIONAL CHECK PER TASK CARD 26SDR AALA202510202106Elec Connector · looseAIRCRAFT WAS GROUNDED: SEAT MOUNTED EMERGENCY WHITE LIGHT INOPERATIVE ON SEAT ROW 27. MAINTENANCE FOUND P1 CONNECTOR FOR EMERGENCY PATH LIGHT LOOSE, SECURED CONNECTOR AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-00.SDR DXTA2025102005342Light · malfunctionedWHEN EMER LTS ARE IN ARM AND PAX SAFETY SWITCH IS IN ON POSITION, THE WHITE EXIT LIGHT ABOVE THE FORWARD AIRSHOW SCREEN ON THE CABIN DIVIDER IS NOT ILLUMINATED. THE LIGHT WILL ILLUMINATE NORMALLY WHEN EMER LTS ARE PLACED IN THE ON POSITION. NO OTHER EMER LIGHTSDR DXTA2025102005339Selector Valve · inoperativeAFTER TAKEOFF ,LANDING GEAR WOULD NOT RETRACK. PERFORMED FIM-4885 - 32-61-00-810-815-A - LG SLOW TO EXTEND OR RETRACT. 32-31-00-720-801-A - EXTENSION AND RETRACTION SYSTEM - FUNCTIONAL CHK, GEAR SWUNG 20 TIMES WITH NO FAULTS, ACCOMPLISHED TASK 29-10-00-860-80SDR DXTA2025102005335Warning Message · illuminatedNO T/O CONFIG RED CAS APPEARED IMMEDIATELY UPON TAKEOFF (NORMAL AURAL TAKEOFF OK ON THE GROUND). FLAP FAIL YELLOW CAS, PTRIM BKP FAIL YELLOW CAS, SWPS FAULT YELLOW CAS, SPOILER FAULT WHITE CAS, & YELLOW X'S ON FLAP INDICATORS ALL UPON FLAP RETRACTION. REPAIRSDR F3LA202510180316Oil Cooler · leakingENGINE 2 FIRE ON TAKE OFF. SHUT ENGINE DOWN AND FIRE ALERT WENT AWAY. SPARKS AND SMOKE REPORTED SEEN BY FAS AND PASSENGERS. PERFORMED INSPECTION AFTER ENGINE WINDMILLING ON ENG#2 AFTER ENGINE IN-FLIGHT SHUTDOWN AND FOUND HARNESS CONNECTOR DAMAGE ON CONNECTORSDR HALA20251017322Landing Gear · faultedATB - MLG R LENGTHENING FAULT. ECAM HOT BRAKES. (#4 BRAKE 315) RAN ECAM, EXTENDED MLG, ONCE COOLED, UNABLE TO RETRACT. ECAM L/G R LENGTHENING FAULT. PERFORMED TSM 32-30-00-810-817-A THROUGH 4(A)3. PROX SENSORS MEASURED IN LIMITS BEFORE MLG SWING. AFTER MLG SWSDR HALA20251017321Pump · failedETOPS - Y ENG 2 PUMP INOP. REMOVED AND REPLACED NR 2 ENG. DRIVEN HYD. PUMP CONDITION SAME. ACCOMP. TEST OF PTU W/ENG. PUMPS PER AMM 29-23-00-710-004-A. ALL ENG.DRIVEN HYD PUMPS,ELECT HYD. PUMPS & PTU OPS NORMAL OK FOR SERVICE. SECURED NR 2 ENG.COWLINGS. P/N OFSDR ASAA2025101661634Power Supply · faultyFA REPORTS EMERGENCY LIGHT ABOVE ROW 27 IS ILLUMINATED DURING CLIMB & CRUISE, LIGHT EXTINGUISHED DURING DESENT. GROUNDED - YES. REMOVED AND REPLACED BATTERY/ PWR PACK 3378 WDM 33-51-13 OPS NML AMM 33-51-06.SDR SCNA20251017409Hydraulic Line · leakingAFTER 10000 MASTER CAUTION LOW PRESSURE ENGINE 1 LIGHT A HYDRAULIC QTY 0 - RESOLUTION: FOUND HYD PRESSURE TUBE ASSY BURST IN CEILING OF WHEEL WELL. INSTALLED TEMPORARY FLEXIBLE TUBING REF GMM 840-020. ACCOMPLISHED LEAK CHECK & SERVICED L HYD SYSTEM - NO LEAKS SDR QXEA2025101700321Rudder Pedal · mismatchedFO RUDDER PETAL MISMATCH. AFTER FLIGHT FO DETERMINED THE MISMATCH WOULD HAVE BEEN PROBLEMATIC DURING LANDING IF CROSSWIND IMPUTS WOULD HAVE BEEN NECESSARY. FO ALSO REPORTED EVEN BRAKING DURING LANDING ROLLOUT WAS NEAR IMPOSSIBLE. RUDDERS ARE MISMATCHED BY APROSDR YENA2025101701043Secu · failedFLT#373, BOS-AUA. "F/CTL/SEC FAULT ALSO WAS AN ELECTRIC BURING SMELL FOR 5 MIN ; REMOVED AND REPLACED SEC 2 IAW AMM 27-94-34 OPS GOOD AT THIS TIME."SDR YENA2025101701042Slide · deployedFLT#2160, PHL-BOS. INADVERTANT RH OWEED SLIDE DEPLOYMENT. REMOVED AND REPLACED RT OWEED SLIDE REF AMP 25-63-02 SEALANT REQ CURE TIME REF LP 4511226-1"SDR DALA2025101707620Light · inoperativeSHIP 3312 AISLE EMERGENCY LIGHTS INOP AT 55H AND 40H. CORRECTIVE ACTION: REPAIRED PER A330 AMM 33-51. (7919398)SDR DALA2025101707618Frame · damagedSHIP 3405 TOOLING DAMAGE AT STANDOFF BRACKET TO FRAME 53.2 ATTACH POINT LT SIDE. CORRECTIVE ACTION: REPAIRED PER ERA 628177-14 REV ORIGINAL. (1255796)SDR DALA2025101707615Bottle · low pressureSHIP 3307 3R DOOR ASSIST BOTTLE BELOW YELLOW BAND. CORRECTIVE ACTION: SERVICED DOOR ASSIST BOTTLE PER A330 AMM 52-15. OK FOR SERVICE. (7979808)SDR DALA2025101707614Bottle · low pressureSHIP 3307 1L DOOR ASSIST BOTTLE BELOW GREEN BAND. CORRECTIVE ACTION: SERVICED 1L DOOR ASSIST BOTTLE PER A330 AMM 52-15-00. OK FOR SERVICE. (7979807)SDR DALA2025101707597None · noneSHIP 9544 REPETITIVE INSPECTIONS WITHIN FORTY-SIX HUNDRED (4,600) FLIGHT CYCLES UPON ER/A 617313-14. CORRECTIVE ACTION: C/W REPAIRED PER ERA 617313 (1255743).SDR DALA2025101707596Not Reported · not reportedSHIP 9544 ACCOMPLISH ER/A 617313-14 REV A. CORRECTIVE ACTION: REPARIED PER ER/A 14-617313. (1255302)SDR DALA2025101707589Actuator · binding-FCNT/DE- DUE TO LEADING EDGE SLAT DISAGREE MESSAGE. R & R #1 SLAT INBOARD AND OUTBOARD ROTARY ACTUATORS.SDR DALA2025101707588Cover · detachedEMERGENCY EXIT SIGN COVER FELL OFF DURING TAKEOFF. INSTALLED EMERGENCY LIGHT LENS COVER FOR DOOR 2R. RESECURED COVER . OPS CHK GOOD PER B757AMM 33-51. (1255228)SDR DALA2025101707587Door · out of rigR1 DOOR REPORTED HARD TO CLOSE. PERFORMED ADJUSTMENT/ RIG OF R-1 PAX DOOR PER B757 AMM 52-11. R- 1 DOOR OPERATES GOOD. (6532736)SDR 6CBA2025101625001Overheat Sensor · faultedDURING A ROUTINE REPOSITIONING FLIGHT FROM KCHS TO KBCT, THE CREW REPORTED A "BATTERY 1 HOT CAS" MESSAGE. THE CREW DECLARED AN EMERGENCY AND DIVERTED TO KVRB, LANDING WITHOUT ANY FURTHER INCIDENT. TECHNICIANS REPLACED THE #1 BATTERY P/N 31406-002 S/N 1190124SDR AALA202510172268Tire · blownAIRCRAFT WAS GROUNDED: AFTER LANDING NUMBER 1 TIRE ON MAIN LANDING GEAR BLEW. REMOVED AND REPLACED NUMBER 1 MAIN LANDING GEAR TIRE. PER AMM 32-45-11.SDR AALA202510175231Fuel Sys · out of balanceAIRCRAFT WAS NOT GROUNDED: AFTER TAKEOFF RECEIVED FUEL IMBALANCE OF 1200 LBS. DIFFERENCE NOTED. (OPEN).SDR AALA202510175571Heat Shrink · missingAIRCRAFT WAS NOT GROUNDED: DURING CHANGE OF L2 DOOR SLIDE MISSING RED HEATSHRINK. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202510172799Bulb · inoperativeAIRCRAFT IN BASE MAINTENANCE: LEFT FORWARD OVERWING EXIT LOWER EMERGENCY LIGHT HAS ONE INOPERATIVE BULB. RELAMPED LEFT HAND OVERWING EXIT SIGN. PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA202510178649Door · stuckAIRCRAFT WAS NOT GROUNDED: FOUND LAVATORY-E DOOR EVERY DIFFICULT TO OPEN. REMOVED AND REPLACED LAVATORY-E DOOR. ASSEMBLY. PER AMM 25-40-15.SDR AALA202510170606Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR DIFFICULT TO OPEN. ADJUSTED LAVATORY DOOR LOCK MECHANISM. PER AMM 25-40-14.