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 AALA202507280073Roller · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS ARMING HANDLE ON 4R DOOR IS DIFFICULT TO OPERATE MAINTENANCE LUBRICATED 4R DOOR ROLLERS AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK AMM 52-13-31.SDR AALA202507280587Roller · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS ARMING HANDLE ON 4L DOOR IS DIFFICULT TO OPERATE MAINTENANCE LUBRICATED 4L DOOR ROLLERS AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK AMM 52-13-31.SDR AALA202507288807Lever · looseAIRCRAFT WAS NOT GROUNDED: DOOR 2R ARMING MECHANISM LOOSE AND NEEDS TIGHTENED. MAINTENANCE TIGHTEN DOOR ARMING LEVER AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 52-22-22.SDR AALA202507285024Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: AFT RIGHT HAND PASSENGER / CREW DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202507280910Strap · unsecureAIRCRAFT WAS NOT GROUNDED: DOOR 4R MANUAL INFLATION HANDLE IS. EXPOSED. MAINTENANCE PERFORMED GVI OF DOOR/SLIDE. FOUND STRAP SAFETY BARRIER STICKING OUT OF DOOR FRAME. STOWED STRAP AS REQUIRED.SDR AALA202507283607Handle · looseAIRCRAFT WAS NOT GROUNDED: EXIT DOOR 3L ARMING HANDLE LOOSE. MAINTENANCE TIGHTENED DOOR ARM HANDLE MECHANISM AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 52-20-00.SDR AALA202507288211Bottle · 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 YENA2025072800779Filter · odorFLT#773, BOS-AUA. "FUMS EVENT IN CABIN ON DESCENT BELOW 10000 BY FLIGHT ATTENDANTS MIDDLE OF CABIN RW 6-14 ( PACKS ) LEFT AND RIGHT FAN COWLS OPENED FOR MX; (RESOLVED ON W/O: 1428717 TASKCARD: NR-00002) REF TSI 589904. AFTER APU INSP AND REPLACEMENT OF HEPA FISDR WX0A2025072832518Cids · faulted(AIRCRAFT NOT GROUNDED) AFT EMERGENCY EXIT LIGHT OVERHEAD OUT. / PERFORMED CIDS BITE TEST IAW AMM 23-73-00-740-005A. NO DEFECTS NOTED AT THIS TIME."SDR WX0A2025072832516Megaphone · faulted(AIRCRAFT NOT GROUNDED) FA REPORT AFT MEGA PHONE INOP. / PERFORMED OPS TEST OF MEGAPHONE IAW AMM 25-65-51-710-002-A. OPS TEST GOOD. "SDR GTIA2025072839020A/C Pack · odorBAD ODOR COMING FROM PACKS THROUGHOUT FLIGHT, BECAME WORSE DURING DESCENT (MUSTY DIRTY SOCKS ) SWITCHED OFF PACK 1 AND SMELL WENT AWAY. DESCRIPTION OF ODOR/FUMES: PERSISTENT, DIRTY SOCKS SMELL. APPARENT CABIN SOURCE: CABIN AIR SUPPLY VENTS. FWD CABIN AND FLIGHSDR GTIA2025072839019Skin Panel · corrodedCORROSION LOWER SURFACE LOCATED RIB27 AFT AREA ON LH WING RAF-01 3551193-01 GENERATED-PERFORMED PERMANENT REPAIR LOC. LOWER SURFACE LOCATED RIB 27 AFT AREA ON LH WING IAW A321 EA #57-0078-25 THIS REPAIR IS CATEGORY B INSPECTION IS REQUIRED AT THRESHOLD 66100 SDR YENA2025072800778Unknown · odorFLT#1877, BOS-SXM. "ON DESCENT APPROX 8000 FT FLIGHT ATTENDANT NOTICED A STRONG FUME IT WAS TRANSIENT AND DISSIPATED IN A FEW MINUTES; COMPLIED WITH INFO NOTICE 2017-T015-L SECTION A.. ACCOMPLISHED TSM 05-50-00-810-831-A , INSPECTED APU COMPARTMENT WITH NO FINSDR GTIA2025072839018Skin · no discrepancyEXISTING RE-WORK EXTERNAL SKIN LOCATED FR23 TO FR24 BTW STR 41L TO STR 42L AT LOWER FUSELAGE. RAF-01 3336958-01-PERFORMED PERMANENT REPAIR ON EXTERNAL SKIN LOCATED FR.23 TO FR.24 BTW STR 41L TO STR 42L AT LOWER FUSELAGE IAW EA #53-00-45-25 AIRBUS PROVIDED AN ISDR GTIA2025072839017Skin Panel · dentedDENTS ON EXTERNAL FUSELAGE BTW FR. 8 - 9 AND LH SIDE STRINGER TO LOWER STRINGER RAF-01 3551196-01 CREATED-EVALUATED DENT 1 AND 2 BTW FR8-9 LOWER STRG 28 LH AND FOUND WITHIN LIMITS I.A.W A321 SRM 53-00-11-283-005, THIS REPAIR IS CATEGORY B, INSPECTION THREHOLD SDR F3LA202507280270Proximity Switch · stickingAFT AVIONICS DOOR OPEN ECAM APPEARED AFTER TAKEOFF. PERFORMED TSM 52-41-00-810-803A. CLEANED PROXIMITY SWITCH AND TARGET, CYCLED AFT AVIONICS COMPARTMENT DOOR. NO FAULTS NOTED IAW AMM 52-41-00-010/410-002A. DOOR LATCHED AND SECURED.SDR IPXA2025072633138Fire Warning · illuminatedWHEEL WELL FIRE INDICATION AT GEAR DOWN. DEFERRED WHEEL WELL FIRE DETECTION SYSTEM IAW MEL 26-17-1A.SDR IPXA2025072832545Filter · faultedEMERGENCY DECLARED, LT HYD SYSTEM QTY AND SYSTEM PRESSURE LOST IN FLIGHT. LEFT ENG HYD PUMP AND LT ELECTIC PUMP SHUTOFF PER QRH FOR REMAINDER OF FLIGHT 45 MINTES. REMOVED AND REPLACED LT HYD RETURN FILTER MOD DPI PER AMM 29-11-15. OPS AND LEAK CHKD OK. AND SDR YENA2025072800776Wheel · leakingFLT#2278, AVL-BOS. (AN EMERGENCY WAS DECLARED) "NOSE TIRE LO PRESS EICAS AFTER TAKEOFF; REMOVED AND REPLACED RH NLG WHEEL ASSY IAW AMP 32-42-01. INSPECTED NLG ASSY NO DEFECTS FOUND. A/C OK TO CONT SVC."SDR IPXA2025072636677Motor · failedATB, EMERGENCY DECLARED, FUEL IMBALANCE 2-3 EICAS ADVISORY MSG ON DEPARTURE. MAXIMUM IMBALANCE REACHED 16,000 LBS WITHIN ABOUT 40 MIUNUTES. TANK 2 WAS LOW TANK. RESULTED IN AIR TURN BACK. REF. TECH ALERT ON MAINTENIX BARCODE T3F1800747A8, REPLACED NR 3 FSDR IPXA2025072931607Slide · rupturedWHILE WORKING D/D MEL-L1 DOOR SLIDE, FOUND DOOR DAMPER PRESS LOW, AND DIAPHRAGM RUPTURED. VERIFIED ALL LOCKOUT PINS REMOVED FROM DOOR DAMPNER AND ALL OPS CHECKS GOOD IAW AMM 52-10-14SDR IPXA2025072734706Floor Panel · crackedFOUND MAIN DECK FLOOR PANEL WITH CRACK DAMAGE, P/N: 146T5869-88 PANEL NO: 252UFF STA 1400~ STA 1520 RBL 55~ RBL 77. I.A.W AMM 53-01-06-000-801 REV.145 REMOVE MAIN DECK CARGO FLOOR PANEL AND SEALANT AND PERFORM G.V.I CHECK. RESULT WAS NORMAL. FABRICATE A NEW SDR DALA2025072805669Support · corrodedSHIP 3155 CORROSION LOWER SILL LOCATED BETWEEN FR68 AND STR23L AFT GALLEY AREA. CORRECTIVE ACTION: PERFORMED REPAIR LOWER SILL LOC ON FR68 LH SIDE AT AFT GALLEY AREA AS PER A319 SRM 53-41-14-300-001. (1106200)SDR YENA2025072800772Generator · faultedFLT#824, LAX-JFK. (ETOPS) CLASS II AC GEN ON STATUS PAGE ( CLASS II MX MSG - GPCU OR AC GEN ); T/S FOUND PIN 3 OF 4000XUB CONNECTOR SHORTED TO GND WITH 405VCA DISCONNECTED. R/R 4155KS HARNESS ON #2 ENG REF PW1100G-A-24-21-61-00A-720A-D. PERFORMED OPS CHK WITSDR YENA2025072800771Bleed Air Sys · faultedFLT#824, LAX-JFK. (ETOPS) "CLASS II AIR BLEED ON STATUS PAGE ( CLASS II MAINTENANCE MESSAGES DISPLAYED ON ECAM STATUS PAGE OF ECAM SYSTEM DISPLAY 1) FAULT(S) INDICATED BY AIR BLEED )" (SUPPLEMENTAL INFORMATION TO FOLLOW)SDR DALA2025072805664Bottle · low pressureSHIP 3417 CIDS PANEL INDICATES 2R DOOR NOT ARMED WHEN DOOR INDICATIONS SHOW ARMED AND COCKPIT DOOR PAGE SHOWS 2R DOOR IS ARMED. CORRECTIVE ACTION: SERVICED DOOR ASSIST BOTTLE PER A330 AMM 52-15. OK FOR SERVICE. (7464580)SDR DALA2025072805663Frame · damagedSHIP 3415 FRAME 62 BETWEEN STR 2 AND 3 LT STRINGERS TOOLING DAMAGE NOTED IN UPPER RADIUS OF T- CHORD BRACKET. CORRECTIVE ACTION: REPLACED BRACKET PER A330 SRM 53-11. (1107948)SDR DALA2025072805659Bracket · damagedSHIP 3415 TOOLING MARKS ON BRACKET ON AFT SIDE OF FRAME 60 AT STR 2R. CORRECTIVE ACTION: REPLACED BRACKET PER A330 SRM 53-11. (1107886)SDR DALA2025072805658Bracket · damagedSHIP 3415 AFT SIDE OF 60 OB OF 2L TOOLING DAMAGE AT FWD UPPER CORNER OF BRACKET. CORRECTIVE ACTION: REPAIRED PER ERA 627461-14 REV. A. (1107881)SDR DALA2025072805656Frame · damagedSHIP 3415 FWD. SIDE OF FRAME 61, 3EA. AREAS OF TOOLING DAMAGE. REPLACED BRACKET PER A330 SRM 53-11. (1107904)SDR DALA2025072805655Bracket · mechanic errorSHIP 3415 INTERCOSTAL BRACKET AFT SIDE OF FRAME 61 BETWEEN 2R AND 3R MISDRILLED. CORRECTIVE ACTION: REPLACED BRACKET PER A330 SRM 53-11. (1107906)SDR DALA2025072805645Skin · mechanic errorSHIP 3360 WHILE DISBONDING STGR 3R, TOOLING MARKS WERE CREATED ON SKIN AT FR 61. CORRECTIVE ACTION: REPAIRED PER PRI 627795-14 REV 1. (1106308)SDR DALA2025072805643Shear Tie · gougedSHIP 3360 FR60 AFT SIDE OF FRAME U-CHANNEL SKIN SUPPORT IN BETWEEN STR1L AND STR2L GOUGED AT FWD INBD RADIUS. CORRECTIVE ACTION: REPAIRED PER A330 SRM 53-11. (1107157)SDR HALA20250728235Fuel Sys · leakingETOPS - FUEL LEAK COMING OUT LH AND RH WING DRY BAY WEEP HOLES. REPAIRED BOTH LEFT & RIGHT WING DRY BAY FUEL LEAKS IN ACCORDANCE WITH SRM 51-76-12. PERFORMED LEAK TEST PER AMM 28-11-00. NO LEAKS NOTED.SDR HALA20250728040Skin · corrodedINFO TO MX CORROSION AROUND THE AFT WASTER OVEBOARD VENT. REPAIR ACCOMPLISHED ON TASK CARD E105-370017-INI2 OK FOR SERVICESDR DALA2025072805620Hydraulic Line · leakingSHIP 5050 - MISC/DE - DECLARED EMERGENCY INTO JFK DUE TO LOSS OF THE YELLOW HYDRAULIC SYSTEM FLUID AFTER TAKE-OFF FROM SEA. CORRECTIVE ACTION: FOUND LEAKING FLARED AN CAP THAT WAS USED TO APPLY MEL 29-10-03 INSTEAD OF AN MS CAP. REPLACED CAP. (LP 7326094)SDR VNAA2025072811101Seal · detachedMAIN CABIN DOOR SEAL CAME LOOSE IN FLIGHT / INSTALLED PORTIONS OF PASSENGER DOOR SEAL THAT WERE LOOSE IAW CRJ 900 AMM 52-11-07-400-801-A02-PSA, PRESSURE CHECK GOOD NO LEAKS DETECTED. NO FURTHER DEFECTS NOTED AT THIS TIME.SDR AALA202507281743Wire · brokenAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT AT ROW 27 ABC IS INOP. MAINTENANCE FOUND BROKEN WIRES WHERE WIRES TRANSFER TO FLOOR TRACK, SPLICED WIRES IAW ESPM 20-43-11.SDR AALA202507282906Power Supply · faultedAIRCRAFT WAS NOT GROUNDED: DURING L1 SLIDE CHANGE FWD L EPSU FAULT. MAINTENANCE REPLACED FWD L EPSU IAW AMM 33-51-38.SDR UIEA2025072601029Oxygen Mask · no testCAPT OXYGEN FLOW INDICATOR NOT SHOWING YELLOW CROSS WHEN TESTING. REMOVED AND REPLACED CAPT OXYGEN MASK STOWAGE BOX IAW AMM 35-11-51. OPS CHECKS GOOD.SDR CALA2025072806980Plate · crackedL1 DOOR, UPPER AREA HAS CRACK AFT CORNER OF COVER PLATE. REMOVED/REPLACED L1 DOOR COVER PLATE IAW SRM 51-72-11-911-0 01.SDR CALA2025072806979Shroud · crackedCRACK ON REAR SKIN INBOARD UPPER SIDE OF RIGHT WING SHROUD BOX. REPAIR ACCOMPLISHED ON AEROMAN NR 2025-373234 IAW AEM EA 57-0073-25 AND EC/RA 5751-01579. REPAIR ACCOMPLISHED ON AEROMAN NON ROUTINE 20 25-373234 PER ECRA 5751-01579. NO REPEAT INSPECTIONS ARE SDR CALA2025072806978Angle · corrodedCORROSION APU BAY. AFT BULKHEAD. LOWER ANGLE FOR SEAL RETAINER, DOT 260 001 FOR REF N/R 9985897 REMOVED AND REPLACED CORROSION APU BAY. AFT BULKHEAD. LOWER ANGLE FOR SEAL RETAINER, DOT 260 001. AFT BULKHEAD. LOWER ANGLE FOUND EXFOLIATION OUT OF LIMITIS. REMOVSDR CALA2025072806977Waste Tank · corrodedAFT CARGO WASTE TANK COMP CORROSION AT DUMP CHUTE BASE BETWEEN S STA 847-867 REMOVED AND REPLACED WASTE TANK DRAIN NEW PAN ASSY AT AFT CARGO WASTE TANK AT DUMP CHUTE BASE BETWEEN STA 847-867 IN REF SRM 51-40-02-0G-0 AND DWG 146A7401 ESFR TRANSACTION COMPLETEDSDR CALA2025072806976Battery · dischargedFWD IB FA FLASHLIGHT BATTERY LOW. RED LIGHT SHOWING REPLACED FLASHLIGHT BATTERY AT FWD FA INB FLASHLIGHT. OPS CHECK GOOD REF AMM 25-64-00SDR CALA2025072806975Fmu · faultedLEFT ENG EXCEEDENCE FOLLOWED BY FAILURE ON CLIMB, LEFT ENGINE BECAME UNCONTROLLABLE AND SPOOLED UP APROX AT 5K FT DURING CLIMB. FOUND ASSOCIATED MAINTENANCE MESSAGES 73-32671, 73-09603, 73-33931, 77-11411, 76-39351, 73-32901. PERFORMED FIM G73-20-F1-J3A-421A-SDR CALA2025072806974Fuel Cap · missingFUEL CAP MISSING FUEL CAP NIS IN IAH PLACING FUEL CAP ON CDL. REPLACED FUEL CAP PER AMM 28-25-41-400-005-A.SDR CALA2025072806973Lamp · inoperativeRH AFT EXTERIOR EMERGENCY LIGHT NOT LIGHT DURING TEST. RH AFT SLIDE ESCAPE LIGHT LAMP REPLACED IAW AMM 33-51-06-902-082.SDR CALA2025072806972Light · inoperativeAFT LEFT EXTERIOR EMERGENCY EXIT LIGHT INOP. R & R AFT LEFT EXTERIOR EMERGENCY LIGHT REF AMM 33-51-04.SDR CALA2025072806948Lamp · no testEMERGENCY LIGHTS - OPERATIONAL TEST WITH THE TEST SWITCH PROCEDURE - OVERHEAD BIN EMERGENCY EXIT LAMP INOP ROW 29 DEF RELAMPED EXIT LAMP @29 IN REF TO AMM 33-51-00, OPS CHECK SATISFACTORY, OK TO CONTINUE PARTS USED: 00-0596-3-2874, QTY :1