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 AALA202510046476Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER IN WHEEL WELL, AT STA 663, LBL 47. REPAIRED VAPOR BARRIER PER AARD 57-10-10-9 AND SRM 57-10-10-2R-2.SDR AALA202510044149Skin · corrodedAIRCRAFT WAS GROUNDED: CORROSION ON FUSELAGE SKIN AROUND LAVATORY VENT LOCATED AT BS 917, FROM S21L TO S22L. ACCOMPLISHED DOUBLER REPAIR TO SKIN PER SRM 53-70-01-2R-3.SDR N6WA2025100406Angle · corrodedCORROSION ON KICK PLATE ANGLE AT STGR17L-18L. REMOVED AND REPLACED KICK PLATE ANGLE AT STGR17L-18L IAW CRJ SRM 51-42-06SDR N6WA2025100405Angle · corrodedCORROSION ON ANGLE MID CAP ON STGR18L. REMOVED AND REPLACED ANGLE MID CAP ON STGR18L IAW CRJ SRM 51-41-02SDR AALA202510035477Landing Gear · faultedAIRCRAFT WAS GROUNDED: THE GEAR FAILED TO RETRACT AFTER TAKEOFF ALL RED DOOR LIGHTS AND GREEN GEAR LIGHTS WERE ILLUMINATED. WE RAN THE LANDING GEAR DISAGREE CHECK LIST TWICE THE GEAR RETRACTED WHEN THE FIRST OFFICER HELD THE MANUAL GEAR EXTENSION DOOR CLOSED.SDR AALA202510036411Liner · unsecureAIRCRAFT WAS NOT GROUNDED: FLAP OF MATERIAL HANGING FROM DOOR SLIDE PACK ON DOOR 2L. RESECURED L2 GIRT BAR FLAPPER. PER AMM 52-10-00.SDR AALA202510031366Door · jammedAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANTS REPORT THE LAVATORY DOOR ON AFT RIGHT SIDE JAMS AT TOP OF FRAME. APPLIED LUBRICANT TO AFT RIGHT HAND LAVATORY DOOR. OPERATIONALCHECK GOOD. PER AMM 20-30-21.SDR AALA202510037807Mechanism · out of adjustAIRCRAFT WAS NOT GROUNDED: GIRT BAR ON FORWARD ENTRY DOOR RED PLASTIC RIGHT SIDE IS DIFFICULT TO LOCK INTO PLACE. ADJUSTED GIRT BAR. ON L1 DOOR. CYCLED AND ARMED DOOR GIRT BAR OPERATIONAL CHECK GOOD.SDR AALA202510037339Mechanism · lack of lubeAIRCRAFT WAS NOT GROUNDED: L1 GIRT BAR DIFFICULT TO ARM AND DISARM. CLEANED AND LUBED L1 DOOR GIRT BAR, OPERATIONAL CHECK GOOD. PER AMM 52-20-01.SDR AALA202510030195Cover · missingAIRCRAFT WAS NOT GROUNDED: FORWARD SERVICE DOOR RIGHT SIDE OF GIRT BAR MISSING RED COVER. CONFIRMED RED HEAT SHRINK MISSING R1 GIRT BAR. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202510033115Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR STICKS. ADJUSTED FORWARD LAVATORY DOOR. OPERATIONAL CHECKS GOOD.SDR AALA202510033480Latch · out of adjustAIRCRAFT WAS NOT GROUNDED: LATCH ON FORWARD LAVATORY DOOR STICKS MAKING DOOR DIFFICULT TO OPEN. ADJUSTED FORWARD LAVATORY DOOR HANDLE AND LATCH. PER MM 25-40-11.SDR HALA20251003301Button · crackedETOPS - CAPTAIN FD PUSH BUTTON, ON GLARESHIELD CRACKED. REMOVED AND REPLACED FCU PER AMM 22-81-12. OPS CHECK GOOD. NO DEFECTS NOTED. OK TO CONTINUESDR AALA202510039012Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ON ELEVATOR HINGE ARM BEARING 2 RH ELEVATOR. MAINTENANCE REPLACED HINGE ARM END FITTING #2 R/H ELEVATOR I.A.W AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202510034796Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ON ELEVATOR HINGE ARM BEARING 3 RH ELEVATOR. MAINTENANCE REPLACED HINGE ARM FITTING #3 R/H ELEVATOR I.A.W AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202510030226Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ON ELEVATOR HINGE ARM BEARING 4 RH ELEVATOR. MAINTENANCE REPLACED HINGE ARM END FITTING ASSY #4 R/H ELEVATOR I.A.W AMM 55-16-42-000-001-A.SDR AALA202510039327Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ON ELEVATOR HINGE ARM BEARING 6 RT ELEVATOR. MAINTENANCE REPLACED ELEVATOR HINGE ARM NR 6 RT ELEVATOR IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202510036758Control Handle · looseAIRCRAFT WAS NOT GROUNDED: 2L DOOR EMERGENCY HANDLE IS LOOSE. MAINTENANCE RESECURED 2L DOOR EMERGENCY CONTROL HANDLE IAW IPC 52-13-22.SDR AALA202510036851Wire · brokenAIRCRAFT WAS NOT GROUNDED: ROW 1 AND 2 EEPL WHITE IS INOP. MAINTENANCE REPAIRED BROKEN WIRE AT SIDEWALL CONNECTOR IAW AWM 33-51-06.SDR AALA202510030381Spring · brokenAIRCRAFT IN BASE MAINTENANCE: BROKEN SPRING AT LEVER OF GIRT BAR FITTING DOOR 841 FWD AND AFTVPOSITION. MAINTENANCE REPLACED SPRING AT LEVER OF GIRT BAR FITTING DOOR 841 FWD AND AFT POSITION IAW DWG D53480282.SDR DALA2025100307226Frame · crackedCRACKS INDICATIONS WERE FOUND AT HOLE #A AND #C FRAME LAYER ONLY. COMPLIED WITH ER/A 628832-14AD. (1230320).SDR DALA2025100307225Skin · dentedAFT FUSELAGE TOP SURFACE JUST RIGHT OF RUDDER CENTER HAS A DENT. ASSESSED DENT PER A319 SRM 53-51-11-283-024. (1230717).SDR DALA2025100307224Window Frame · crackedCRACK FOUND ON WINDSHIELD FRAMES ON LH AND RH SIDES. COMPLIED WITH ER/A 628472-14. (1230870).SDR DALA2025100307223Door Frame · crackedUPPER FUSELAGE, PAX CABIN, LT FORWARD ENTRY DOOR, FR 16 DOOR STOP 7 WITH CRACK INDICATION AT INTERCOSTAL LAYER IN UPPER INBOARD AND LOWER INBOARD HOLES. REPLACED INTERCOSTAL FR16 DOOR STOP 7 IAW SRM 51-72-11-911-001. (1230614).SDR DALA2025100307222Frame · crackedCRACK INDICATION FOUND ON FRAME 16LH HOLE C. ON DOUBLE JOGGLE AREA. COMPLIED WITH ER/A 628459-14AD. (1230633).SDR DALA2025100307221Bearing · excess playLEFT WING SPOILER 5 WITH EXCESSIVE PLAY. REPLACED BEARINGS SLEEVES AND BUSHINGS AT LT WING SPOILER 5 IAW CMM TASK 57-75-21-000-806-A01. (1230737).SDR DALA2025100307220Bearing · excess playLEFT WING SPOILER 1 WITH EXCESSIVE PLAY. REPLACED BEARINGS SLEEVES AND BUSHINGS AT LT WING SPOILER NR 1 IAW CMM TASK 57-71-21-000-805-A01. (1230724).SDR DALA2025100307219Bearing · excess playRIGHT WING SPOILER 3 WITH EXCESSIVE PLAY. REPLACED BEARINGS SLEEVES AND BUSHINGS AT R/H WING SPOILER #3 IAW A319 CMM TASK 57-73-21-000-803-A01. (130715).SDR DALA2025100307218Bearing · excess playRIGHT WING SPOILER 5 WITH EXCESSIVE PLAY. REPLACED BEARINGS SLEEVES AND BUSHINGS AT RT WING SPOILER 5 IAW CMM TASK 57-75-21-000-806-A01. (1230692).SDR DALA2025100307217Window Frame · crackedCRACK INDICATION FOUND ON WINDSHIELD CENTER POST LOWER ATTACHMENT AREA LOWER RADIO RT SIDE. COMPLIED WITH ER/A 628400-14AD. (1230996).SDR DALA2025100307216Skin · corrodedCORROSION INTERNAL SKIN LOCATED BTW FR 67 TO FR 68 AND BTW STR 30L TO STR 31L IN AFT CARGO COMPARTMENT. COMPLIED WITH ER/A 628904-14. (1230844).SDR DALA2025100307215Shear Plate · corrodedAFT CARGO COMPARTMENT, UNDER FLOOR COMPARTMENT BETWEEN FR69-FR70 STR 23R-24R SHEAR PLATE CORRODED AROUND ANCHOR NUTS. REPLACED SHEAR PLATE IAW A319 SRM 53-41-17-01A. (1230652).SDR DALA2025100307214Seat Track · corrodedUPPER FUSELAGE, PAX CABIN SEAT TRACK Y765 FROM FR65 TO FR66 WITH CORROSION. COMPLIED WITH ER/A 628887-14. (1230635).SDR DALA2025100307213Seat Track · corrodedUPPER FUSELAGE, PAX CABIN SEAT TRACK -Y1292 FROM FR65 TO FR66 WITH CORROSION. COMPLIED WITH ER/A 628887-14. (1230630).SDR DALA2025100307212Seat Track · corrodedUPPER FUSELAGE, PAX CABIN SEAT TRACK Y1292 FROM FR65 TO FR66 WITH CORROSION. COMPLIED WITH ER/A # 628887-14. (1230619).SDR DALA2025100307211Window Frame · crackedCRACKS FOUND ON LT WINDSHIELD, CENTER POST, LOWER ATTACHMENT AREA, UPPER RADIUS, FRONT WINDSHIELD FRAMING , RT WINDSHIELD, CENTER POST, LOWER ATTACHMENT AREA, LOWER RADIUS, FRONT WINDSHIELD FRAMING. COMPLIED WITH ER/A 628585-14AD. (1230430).SDR DALA2025100307229Bearing · excess playLEFT WING SPOILER 2 WITH EXCESSIVE PLAY. REPLACED BEARINGS SLEEVES AND BUSHINGS AT LT WING SPOILER NR 2 IAW CMM TASK 57-72-21-010-803-A01. (1230752).SDR DALA2025100307228Bearing · excess playLEFT WING SPOILER 3 WITH EXCESSIVE PLAY. REPLACED BEARINGS SLEEVES AND BUSHINGS AT LT WING SPOILER NR 3 IAW CMM TASK 57-73-21-000-803-A01. (1230768).SDR R61A2025100200429Unknown · odorFUMES IN FWD CABIN BY PILOT, BOTH FAS AND FIRST CLASS PASSENGERS. SMELLS LIKE BUTANE. PERFORMED OPS CHECK OF PACK 1 AND 2 INCLUDING ENGINE RUNS AND BLEED VALVE. OPS CHECK GOOD. UNABLE TO REPRODUCE SMELL. NO SMELL OR FUMES NOTED AT THIS TIME.SDR SWIA2025100300002Hydraulic System · low pressureHYD2 LO QTY IN FLIGHT FOLLOWED BY HYD 2 LO PRESS. RAN QRH. NO HYD 2 QTY, USED ALTERNATE LANDING GEAR HANDLE. (FLIGHT 5971 - FILED OPEN)SDR SWAA2025100320435Handle · looseFWD GALLEY SERVICE DOOR ASSIST HANDLE LOOSE. RESECURED FWD GALLEY SERVICE DOOR ASSIST HANDLE REF AMM 20-50-11.SDR SWAA2025100320417Battery Pack · failedAFT R/H EMERGENCY LIGHTING BATTERY PACK FAILED THE CAPACITY CHECK.. REMOVED AND REPLACED BATTERY PACK PER M/M 33-51-06.SDR SWAA2025100320628Charger · inoperativeCABIN INTERIOR MID SECTION/OVER WING EMERGENCY LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK AND CHARGER/CRADLE ASSY FOR M1694 (R/H STATION 565). REMOVED AND REPLACED BATTERY PACK FOR 1671 (R/H STATION 727) REF MM 33-51-06. OPS CHECK GOOD.SDR SWAA2025100320463Battery Pack · inoperativeCABIN INTERIOR MID SECTION/OVER WING EMERGENCY LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK AND CHARGER/CRADLE ASSY FOR M1694 (R/H STATION 565). REMOVED AND REPLACED BATTERY PACK FOR 1671 (R/H STATION 727) REF M/M 33-51-06. OPS CHECK GOOD.SDR SWAA2025100320500Light · inoperativeFWD GALLEY SERVICE DOOR EXTERIOR AND LOWER INTERIOR EMERGENCY EXIT LIGHTS ARE INOP. ] INITIAL EVALUATION PERFORMED EMERGENCY LIGHTS OPS TEST PER AMM 33-51-00. CHARGED EMERGENCY LIGHTS BATTERY PACKS FOR 90MINUTES PER AMM 33-51-06. EMERGENCY LIGHTS AT THE FWD GASDR DXTA2025100305185Brake Assy · leakingAFTER LANDING AT KHND (ON-SPEED, WITH AN APPROX TAILWIND 5 KNOTS), PF REPORTED, ATTEMPTED TO BRAKE HEAVILY BUT GOT A MEDIOCRE BRAKING. AT 65 KNOTS, TOOK OVER CONTROLS & SAME. AFTER PARKING, CHECKED BOTH MLG FOR HYD LEAKS & NONE, BUT THERE WAS LIGHT SMOKE COSDR DXTA2025100305190Elec Connector · disconnectedTHE AFT-MOST EMERGENCY LIGHT ON THE SEAT BASE OF SEAT #6 FOR EMERGENCY PATH LIGHTING IS INOPERATIVE GAINED ACCESS TO EMER LIGHT AND PERFORMED GVI OF LIGHT, DURING GVI FOUND LIGHT TO BE DISCONNECTED. TECHS VERIFIED THAT POWER AND GROUND WERE PRESENT AT THE CONSDR DXTA2025100305188Brake Sys · abnormalAS WE TAXIED OUT THE RIGHT MAIN BRAKE WAS PULSATING VERY AGGRESSIVELY REMOVED WORN TO LIMIT/ FAILED RH MLG BRAKE ASSY AND INSTALLED OVERHAULED BRAKE ASSY. BRAKES BLEED AND OP CHECK AND TAXI CHECK IS GOOD. ALL IN REF WITH AMM 32-45-21, 32-40-00, 12-13-00, 32SDR 2025100205185Brake Assy · weakAFTER LANDING AT KHND (ON-SPEED, WITH AN APPROXIMATE TAILWIND 5 KNOTS), PF REPORTED THAT HE ATTEMPTED TO BRAKE HEAVILY BUT GOT A MEDIOCRE BRAKING ACTION. AT 65 KNOTS, TOOK OVER CONTROLS AND NOTICED THE SAME ACTION. (SPEED BRAKES AND THRUST REVERSERS WERE IN TSDR DXTA2025100305183Pressure Switch · faultedFUEL FEED2 FAULT WHITE EICAS ILLUMINATED CLIMBING THROUGH 27,000. CONSULTED QRH. REMOVED AND REPLACED #2 FUEL LOW PRESSURE SWITCH IAW AMM 28-45-01. OPS CHECK GOOD. NO LEAKS NOTED AT THIS TIME.