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 HALA20250718220Filter · inoperativeETOPS - FOUND YELLOW ENGINE-PUMP CASE-DRAIN FILTER ASSY INOP. REMOVED AND REPLACED YELLOW ENGINE-PUMP CASE-DRAIN FILTER ASSY IAW AMM 29-13-43-000-804-A AND 29-13-43-400-804-A. LEAK CHECK GOOD. OK TO RETURN TO SERVICE.SDR DALA2025071805436Frame · damagedSHIP 3415 FOUND 1 HOLE IN-BETWEEN STRINGER 2R AND 1R ON THE BOTTOM ROW HAS TOOLING DAMAGE. CORRECTIVE ACTION: REPLACED FRAME C60 ON NRC 182 PER A330 AMM 53-11. (1090102).SDR DALA2025071805430Floor Support · corrodedSHIP 3146 AFT FUSELAGE PASSENGER CABIN FLOOR STRUCTURE AREA AT FR68 AND FR69+480MM AT Y-765 LONGITUDINAL BEAM WITH CORROSION. CORRECTIVE ACTION: REPLACED FLOOR STRUCTURE LOCATED BETWEEN FR66 TO FR70 IAW A319 SRM TASK 51-72-11-911-001. (1090793).SDR DALA2025071805429Floor Support · corrodedSHIP 3155 CORROSION FLOOR BEAM +Y512 AT FR68 AT AFT GALLEY AREA. REPLACED FLOOR BEAM Y512 AND FASTENERS LOC. BTW FR68 TO FR70 AS PER A319 SRM 51-72-11. (1091239).SDR DALA2025071805428Floor Support · corrodedSHIP 3155 CORROSION FLOOR BEAM -Y189 LOCATED BETWEEN FR20 TO FR21 FWD GALLEY AREA. REPLACED FLOOR BEAM -Y189 AND FASTENERS LOCATED BETWEEN FR20 TO FR24 FWD GALLEY AREA AS PER A319 SRM 51-42-11, A319 SRM 51-72-11. (1091225).SDR DALA2025071805427Frame · corrodedSHIP 3155 CORROSION WEB FRAME LOCATED FROM FR69 TO FR70 AND STR23LH IN PASSENGER CABIN. REPLACED WEB AND FASTENERS LOC ON FR69 TO FR70 AT LEVEL STR23LH AFT GALLEY AREA AS PER A319 SRM 51-42-11 A319 SRM 51-72-11. (1091223).SDR DALA2025071805426Window Post · crackedSHIP 3130 CRACK INDICATION ON RH WINDSHIELD CENTER LOWER NODE. COMPLIED WITH ER/A 626727-14AD. (1090577).SDR DALA2025071805425Window Post · crackedSHIP 3130 FOUND CRACK AT THE LOWER RADIUS OF THE RH CENTER POST OF THE FRONT WINDSHIELD FRAMING. COMPLIED WITH ER/A 626818-14AD. (1090500).SDR DALA2025071805424Window Frame · crackedSHIP 3130 CRACK FOUND AT RH FRONT WINDSHIELD FRAMING. COMPLIED WITH ER/A 626817-14. (1090383).SDR DALA2025071805419Hydraulic Line · brokenSHIP 3253 - ATB - DUE TO LOSS OF THE GREEN HYDRAULIC SYSTEM SHORTLY AFTER TAKE-OFF. FOUND BROKEN HYDRAULIC LINE AT RH MLG LOCKSTAY ACTUATOR SWIVEL FITTING. MAINTENANCE IN PROGRESS. (LP: 7283138)SDR AALA202507180856Pump · inoperativeAIRCRAFT WAS NOT GROUNDED: IN FLIGHT RIGHT AFTER FUEL LOW PRESSURE LIGHT ILLUMINATED STEADY FOR SEVERAL MINUTES AND DID NOT EXTINGUISH. VERIFIED RIGHT AFT BOOST PUMP INOPERATIVE. (OPEN).SDR AALA202507185446Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT FLIGHT ATTENDENT SEAT BY L2 AFT SERVICE DOOR OUTBOARD HAS ONE EACH FLASHLIGHT INOPERATIVE. (OPEN).SDR AALA202507184746Door Latch · inoperativeAIRCRAFT WAS NOT GROUNDED: THE COCKPIT DOOR WAS CLOSED AND LOCKED UPON ARRIVAL. UNABLE TO OPEN DOOR WITH CODE DESPITE MULTIPLE ATTEMPTS. CALLED MAINTENANCETO DISASSEMBLE THE DOOR TO GAIN ENTRY. RESET ELECTRIC POWER TO FLIGHT DECK DOOR ELECTRIC LATCH. PER AMM52SDR AALA202507180675Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR IS HARD TO OPEN AND CLOSE. READJUSTED FORWARD LAVATORY DOOR AS REQUIRED, OPERATIONAL CHECK GOOD.SDR AALA202507183822Lockpin · installedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: NOSE GEAR DID NOT RETRACT ON TAKEOFF, NOSE GEAR WARNING LIGHT WITH HANDLE UP.AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT CTL. REMOVED LANDING GEAR PIN FROM NOSE LANDING GEAR AND PERFORMED BITE SDR AALA202507184661B-Nut · leakingAIRCRAFT WAS GROUNDED: STRONG SMELL AND LEAKAGE FROM FORWARD LAVATORY ON TAKEOFF AND LANDING AS REPORTED BY FLIGHT ATTENDANT. TROUBLESHOOT PER FIM 38-1000-810-807, UPON OPENING SINK CAB DOOR FOUND WATER DRIPPING FROM B-NUT ON WATER HEATER. TIGHTENED B-NUT, PERSDR IPXA202507183415Skin · crackedRIGHT OUTBOARD ELEVATOR HAS TWO CRACKS AND NUMEROUS LOOSE AND MISSING RIVETS ON UPPER LEADING EDGE. ELEVATOR PART NUMBER [ 654U6625-2930 ] IS NOT IN IPC.SDR IPXA2025071881182Sign · inoperativeEMERGENCY EXIT SIGN HAS 7 EACH LIGHTS INOP. ++REPLACED 7 EACH BULBS IN EMERGENCY EXIT SIGN IAW AMM 33-51-01 OPS CHECK GOODSDR IPXA202507183055Stop Fitting · gougedFWD CREW DOOR STOP ( FROM FWD FACE OF THE DOOR ) # 8 FROM LOWER APPEAR TO HAVE GOUGES . 89-832 APPROVED.SDR IPXA202507182988Stop Fitting · gougedFWD CREW DOOR STOP ( FROM FWD FACE OF THE DOOR ) NR 7 FROM LOWER APPEAR TO HAVE GOUGES .SDR IPXA202507182897Stop Fitting · gougedFWD CREW DOOR STOP ( FROM FWD FACE OF THE DOOR ) NR 5 FROM LOWER APPEAR TO HAVE GOUGES .SDR IPXA202507182895Stop Fitting · gougedFWD CREW DOOR STOP ( FROM FWD FACE OF THE DOOR ) NR 6 FROM LOWER APPEAR TO HAVE GOUGES.SDR AALA202507183746Light · missingAIRCRAFT WAS GROUNDED: DURING PERIODIC SERVICE CHECK MAINTENANCE FOUND EMERGENCY ESCAPE PATH LIGHT ASSEBLY MISSING AT SEAT ROW 35ABC. INSTALLED ESCAPE PATH LIGHT ASSEMBLY AND ACCOMPLISHED A SATISFACTORY OPERATIOPNAL CHECK PER AMM 33-51-38SDR AALA202507188699Lever · looseAIRCRAFT WAS NOT GROUNDED: ARMING LEVER FOR DOOR 2R LOOSE. MAINTENANCE SECURED ARMING HANDLE PER AMM 20-21-11.SDR DALA2025071805422Spring · missingSHIP 6819 DURING WALKAROUND FOUND LT LANDING GEAR UPLOCK ONE SPRIN MISSING. CORRECTIVE ACTION: REPLACED THE MISSING UP LOCK SPRING REF B757 AMM 32-32. (7374340)SDR DALA2025071805421Light · brokenSHIP 5642 EXIT LIGHT PANEL BROKEN ABOVE 2L DOOR. CORRECTIVE ACTION: REPLACED 2L DOOR EMERGENCY EXIT SIGN LENS AS REQ B757 AMM 33-51. (7344764)SDR YENA2025071800734Slide · unwanted deployFLT#353, BOS-DUB. R1 DOOR SLIDE INADVERTENTLY DEPLOYED; REMOVED AND REPLACED R1 DOORSLIDE IAW AMM 25-62-44. REPLACED ERUPTED DIAPHRAGM.SDR R61A2025071800312Skin · crackedWHILE IN HEAVY CHECK - RH WING CRACK ON LOWER SKIN BETWEEN RIBS 4 & 5 AT SPAR 2. REPAIRED RH WING LOWER SKIN BETWEEN RIBS 4 & 5 AT SPAR 2 REF ETD2025-170-923747.SDR N6WA2025071802Skin · gougedGOUGE IN FUSELAGE SKIN AT FS977.00 AND STGR27. REPAIRED SKIN AT FS977.00 AND STGR27 IAW GOJET EO-C550-53MR-075.SDR AALA202507186435Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: PER PS CHECK L4 DOOR ASSIST BOTTLE REQUIRES SERVICING. MAINTENANCE SERVICED L4 DOOR ASSIST BOTTLE IAW AMM 52-10-00.SDR AALA202507187907Battery Pack · inoperativeAIRCRAFT WAS NOT GROUNDED: OFCR EMERGENCY FLASHLIGHT TAMPER SEAL BROKEN, WILL NOT TEST GREEN. MAINTENANCE REPLACED OFCR EMRGENCY FLASHLIGHT BATTERY PACK, INSTALLED TAMPERSEAL AND TEST OK IAW AMM 25-64-00.SDR SIMA20250717001Light · no testDURING EMER LT TEST FIRST THREE LIGHTS ON CEILING DO NOT LIGHT UP. DID AIRCRAFT RESET WITH NO LUCK PERFORMED OPERATIONAL CHECK OF THE EMERGENCY LIGHT SYSTEM IAW AMM 33-50-00 OPC GOOD NO FURTHER DEFECT NOTEDSDR SIMA20250717002Battery Pack · inoperativeEMERGENCY LIGHT ON PAX CABIN CEILING PANEL 253CLC DOES NOT ILLUMINATE. R & R AFT R LW (#4) EMERGENCY BATTERY IAW AMM 33-50-01. OPS CHECK OF EMERGENCY LIGHT ON PAX CABIN CEILING PANEL 253CLC GOOD.SDR FDEA202507171249Window · crackedL1 WINDOW CRACK DURING CRUISE AT FL400. WINDOW STARTED ARCING AND CRACKING, RAN WINDOW DAMAGE QRH. DESELECTED L FWD WINDOW HEAT, ARCING AND CRACKING STOPPED.SDR FDEA202507171232Oil System · leakingOIL QTY ON RIGHT ENGINE WENT TO 4 QTS ABOUT 3.5 HOURS INTO FLIGHT. EVENTUALLY DECREASED TO ZERO OIL QTY ABOUT 1.5 HOURS LATER. OIL PRESSURE DECREASED TO 35 IN DESCENT, NEVER ANY LOWER. NEVER GOT ANY EICAS MESSAGES OR SECONDARY INDICATIONS. REMOVED AND RESDR FDEA202507171231Cylinder · emptyAFTER SLIDE REINSTALLED NOTED L1 DOOR EMERGENCY POWER RESERVOIR EMPTY. REMOVED AND REPLACED L1 DOOR EMERGENCY POWER RESERVOIR WITH REF AMM 52-11-30-4. A/C OK FOR SERVICE.SDR FDEA202507171230Skin · dentedONE DENT IN SURFACE INNERSIDE LOWER SKIN INSIDE CORNER OF INBOARD AFT FLAP OF INBOARD FLAP RIGHT WING. RT WING, INBD T/E FLAP LOWER SURFACE, DENT WAS REPAIRED IAW B767 SRM 57-53-01-2R FIG 201 (SHEET 4) DETAIL III AND SRM 51-70-03-0G PAR 5L FIGURE 16 REV 9SDR CALA2025071806717Transceiver · faultedNO RECEPTION ON BOTH HF RADIOS SENSOR SET TO 100. OPS CHECKED HF COM SYS REF AMM 23-11-00/501. OPS CHECK GOOD. ABLE TO RECIEVE & TRANSMIT ACFT TO ACFT TESTED FREQUENCY 5.000 & 10.000, RECIEVED PROPER MSG FOR HF 1. HF 2 DIDN'T RECIEVE PROPER MSG DURING 5.000/ SDR CALA2025071806712Clamp · loose1R RIGHT GIRT BAR CLAMP LOOSE. DOESNT HOLD BAR ADJUSTED GIRT BAR CLIP, OPS NORMAL.SDR CALA2025071806709Seal · brokenFOUND ENGINE NR 1 FWD PYLON TO NACELLE PROFILES PANEL BROKEN. INSTALLED E#1 FWD PYLON TO NACELLE PROFILES PANEL REFERENCE AMM TASK 54-57-22-400-003-A.SDR CALA2025071806708Sensor · faultedLE FLAPS TRANSIT LIGHT ILLUMINATED UPON SETTING FLAPS 15 ON APPC H. RAN CHECKLIST LAND FLAPS 15 LOCK FAUTL CODE 27-81201 WAS FOUND DURING BITE CHECK. ACCOMPLISHED FIM TASK 27-88. IN TRANSIENT LIGHT WOULD NOT EXTINGUISH IN FLT DECK PAST FLAP HANDLE COMMANDED ATSDR CALA2025071806707Battery Pack · no testMULTIPLE EMERGENCY LIGHTS INOPERATIVE THOUGHOUT CABIN. REMOVED BATTERY PACK IAW AMM 33-51-06-960-805. INSTALLED SERVICEABLE BATTERY PACK IAW AMM 33-51-06-960-805. PERFORMED EMERGENCY LIGHTS OPS CHECK IAW 33-51-00. OPS CHECK GOOD.SDR CALA2025071806706Battery Pack · inoperativeSEAT ROW 7-14ABC EMERGENCY LIGHTS INOPERATIVE. REMOVED EMERGENCY LIGHT BATTERY PACK IAW AMM 33-51-06. INSTALL EMERGENCY LIGHT BATTERY PACK IAW AMM 33-51-06. EMERGENCY LIGHTS OPS CHECK IAW 33-51-00. OPS CHECKS GOOD.SDR CALA2025071806705Lamp · failedEMERGENCY LIGHT IN THE CENTER OF THE LOWERED CEILING PANEL IN THE CABIN IS INOPERATIVE. LOWERED CEILING PANEL AT BS 889 IAW AMM 25-21-71-000-815 TO FOM. TROUBLESHOOT AND RELAMPED AFT CEILING LIGHT L1419 IAW AMM 33-51-03-960-801. OPS TEST OF EMERGENCY LIGHT SDR CALA2025071806704Battery Pack · inoperativeRT WING FWD EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED FUSE 4 ON BATTERY PACK M1695. OPS CHECK GOOD. REF AMM 33-51-06.SDR 4DPA2025071870001Door Seal · damagedCREW REPORTED- DURING THE FINAL 1000 FEET OF THE CLIMB TO FL 360. WE HEARD WHAT SOUNDED LIKE A TEA KETTLE ABOUT TO BOIL OVER. AT 7.8 DELTA PRESSURE THE SOUND WENT FROM A WHISTLE TO A FULL VIBRATION THAT SOUNDED THROUGHOUT THE CABIN. THE SOUND ORIGINATED FROM TSDR K11A2025071700235Control Cable · out of adjustLANDING GEAR LEVER WOULD NOT GO UP WHILE ON TAKEOFF DURING RETRACTION. ADJUSTED MAIN GEAR AIR / GROUND CABLE IAW AMM 32-21-11. PERFORMED OPS CHECK IAW AMM 32-21-11. PERFORMED GEAR SWING SYSTEM OPS CHECK NORMAL.SDR DALA2025071705404Fairing · damagedSHIP 3357 FOUND MULTIPLE PUNCTURE HOLES ON LEFT WING OUTBOARD FLAP BELOW WING LEFT OF #3 FLAP TRACK FAIRING. COMPLIED WITH ER/A 627962-14. (7582900).SDR DALA2025071705402Stringer · damagedSHIP 3412 FOUND HOLES ON STR 1L AT FR 64. COMPLIED WITH ER/A 627660-14. (7067183).SDR SWAA2025071792169Doubler · debondedL/H O/B UPPER SURFACE DISBOND ON EXISITING REPAIR DOUBLER. REMOVED DAMAGE PER SRM 57-53-01-2R14; PERFORMED TAP TEST PER 737 NET MANUEL PART 1 51-05-01 . PREPED AREA ;FABRICATED REPAIR PARTS INSTALLED REPAIR PARTS PER SRM 57-53-01-2R-14. AND SRM 51-70-05-2R-0