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 SWAA2025120836437Splice · corrodedFLOOR PANEL SPLICE AT BS 727D+7 HAS CORROSION. NO ALLOWABLE DAMAGE FOUND FOR FLOR PANEL SPLICE. REMOVED AND REPLACED THE SPLICE IAW SRM 51-40-02-0G-0.SDR SWI2025F01743Spring · brokenBROKEN SPRINGS ON DOOR SLIDE FLOOR FITTINGS AT AFT PAX DOOR AFT FITTING AND FWD SVC DOOR FWD FITTING. REMOVED AND REPLACED SPRINGS ON DOOR SLIDE FLOOR FITTINGS AT AFT PAX DOOR AFT FITTING AND FWD SVC DOOR FWD FITTING. IAW AMM 53-23-21, 53-10-25.SDR SWI2025F01742Seat Track · gougedFWD WET AREA TRACK RIGHT AT FR 14/15 HAS A GOUGE. REMOVED AND REPLACED RT SEAT TRACK FR 12-20 REF SRM 51-40-08. REPLACED WITH FACTORY PART,SDR SWIA20251208118Seat Track · corrodedFWD WET AREA TRACK LEFT AT FR 19/20 HAS CORROSION. CUT-OUT DAMAGE FROM CORROSION IN THE FORWARD WET AREA ON THE LT INBOARD SEAT TRACK BETWEEN FRAMES 19-20 AND INSTALLED A FABRICATED FILLER AND DOUBLER TO REPAIR DAMAGE REF ETD2025-170-932634-A.SDR AALA202512086728Smoke Detector · no testAIRCRAFT IN BASE MAINTENANCE: OFCR BUNK 3 SMOKE DETECTOR FAILED OPERATIONAL CHECK. REMOVED AND REPLACED OFCR BUNK 3 SMOKE DETECTOR. PER AMMDMC-B787-A-26-14-21-00A-520A/720A-A.SDR SROM2025120479601Control Panel · inoperativeWHEN LANDING GEAR SELECTED DOWN IN FLIGHT THERE WAS NO MOVEMENT OF THE LANDING GEAR AND THE LANDING GEAR INOP CAUTION LIGHT ILLUMINATED AFTER SEVERAL SECONDS. ALTERNATE EXTENSION COMPLETED SUCCESSFULLY. WHEN ALTERNATE EXTENSION WAS COMPLETED THE NORMAL LANDINGSDR ASAA2025111862824Floor Support · crackedFLOOR SUPPORT CRACKED BETWEEN BS 277 TO 294, BL 0. GROUNDED - YES. REMOVED AND REPLACED THE FLOOR SUPPORT IAW SRM 51-40-02-0G-0.SDR AALA202512037600Bushing · wornAIRCRAFT IN BASE MAINTENANCE: LEFT HAND WING NUMBER 3 FLAP TRACK TRANSMISSION ATTACH FITTING BUSHINGS ARE WORN. REMOVAL AND INSTALLATION OF FLIGHT CONTROL HARDWARE WAS ACCOMPLISHED. PERV NON-ROUTINE S/N 506.SDR AALA202512030634Mount · excess playAIRCRAFT IN BASE MAINTENANCE: AFTER REMOVAL OF LEFT HAND WING NUMBER 3 FLAP TRANSMISSION, FOUND PLAY IN TRANSMISSION MOUNT TO FLAP TRACK. REMOVED AND REPLACED BUSHINGS AND ATTACH HARDWARE ON NUMBER 3 FLAP TRACK FWD ATTACH FITTING. PER B737/NG SOPM 20-50-03 ANDSDR DALA2025120308820Light · damagedEMERGENCY PATH LIGHTING SEATS 38B & 44B ARE DAMAGED. REMOVED AND REPLACED EMERG LIGHT ASSY AT SEAT 38B PER B767 AMM 33-52, REPAIRED WIRING AT SEAT 44B PER SWPM CH20. BOTH LIGHTS OPS NML. (7377996)SDR DALA2025120308819Stiffener · crackedFOUND 01EA CRACK IN THE RADIUS OF THE STIFFENER AT STA287 FROM WL159 TO 185,THE LENGTH OF CRACK IS 0.2 INCH,AS MARKED. PERFORMED REPAIR ON THE LH VERTICAL STIFFENER CRACK AREA AT STA287 FROM WL 159 TO 185.REFER TO W/C 5312-01186-02A. (1309595)SDR SIMA20251118001Seal Rest · corrodedAFT CARGO DOOR CUT OUT FWD CORNER SEAL DEPRESSOR HAS CORROSION AROUND 1 NUT PLATE. (MAJOR REPAIR) (LEVEL 2 CORROSION). REMOVED AND REPLACED AFT CARGO DOOR CUT OUT FWD CORNER SEAL DEPRESSOR IAW ERJ 175 SRM 51-40-08.SDR SWAA2025120136615Scuff Plate · crackedFWD SERVICE DOOR SCUFF PLATE IS CRACKED AT AFT LOWER CORNER. REMOVE AND REPLACED FWD SERVICE DOOR SCUFF PLATE IS CRACKED AT AFT LOWER CORNER IAW AMM 53-11-01-420-801, REJECT; FWD SERVICE DOOR FWD LOWER CORNER CUTOUT LEAK CHECK FAILED. IT HAS A HISSING SOUNSDR SWAA2025120136476Floor Support · crackedRIGHT FLOOR SUPPORT CRACKED BS 537.45. R & R THE FLOOR SUPPORT IAW SRM 51-40-02SDR CALA2025112811574Skin · crackedRH HORIZONTAL STAB LOWER SKIN, ONE CRACK SIGNAL NOTED L=0.855INCH APROX. AT STAB STA157.10 AND 9 INCH FROM AFT SPAR (REF AAR NR 1000060368)PERFORMED PERMANENT REPAIR AT RH HORIZONTAL STAB AT STAB STA157.10 AND 9 INCH FROM AFT SPARTHIS REPAIR IS A CATEGORY "B",SDR CALA2025112811573Skin · crackedLH HORIZONTAL STAB LOWER SKIN, ONE CRACK SIGNAL NOTED L=1INCH APROX. AT STAB STA147.90 AND 15.600 INCH FROM FWD SPAR (REF AAR NR 1000060354) PERFORMED PERMANENT REPAIR AT LT HORIZONTAL STAB AT STAB STA147.90 AND 15.600 INCH FROM FWD SPAR THIS REPAIR IS A CATEGSDR CALA2025112711501Skin · not reportedRE-SKIN FWD CARGO DOOR. REMOVED AND REPLACED FWD CARGO DOOR SKIN, ALL WORK PERFORMED IAW SRM 52-30-01-2R-3SDR CALA2025112711499Skin · deformedRE-SKIN AFT CARGO DOOR. REMOVED AND REPLACED AFT CARGO DOOR SKIN, ALL WORK PERFORMED IAW SRM 52-30-01-2R-3.SDR U5QA202511180162Pseu · inoperativeLEVELING OFF @ FL430, AMBER WOW FAIL AND CYAN PROX SYS FAULT. MX C/A: R&R PSEU, OPS TEST OF GEAR EXTENSION AND RETRACTION GOOD, NO DISCREPANCIES DENOTED AT THIS TIME. (REF. CH300 AMM 32-61-09, 32-30-00)SDR CALA2025112611476Attach Angle · crackedFOUND CRACK AT LOWER FUSELAGE CENTER WING BOX REAR SPAR RT VAPOR BARRIER UPPER ATTACHED ANGLE AT RBL 7 BS 663.5. ACCOMPLISHED REPAIR AT RT VAPOR BARRIER UPPER ATTACH ANGLE RBL 7 BS 663.5 IAW SRM 57-10-10-2R-5.SDR AALA202511256545Handle · looseAIRCRAFT IN BASE MAINTENANCE: ALL EMERGENCY EXIT DOORS, ARM/ DISARM HANDLES ARE LOOSE. MAINTENANCE TIGHTENED AND CHECKED ALL EMERGENCY EXIT DOORS, ARM/DISARM HANDLES PER AMM 52-22-11SDR AALA202511252953Bottle · low pressureAIRCRAFT IN BASE MAINTENANCE: L1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER NEEDS TO BE SERVICED, SERVICED DAMPER AND EMERGENCY OPERATION CYLINDER AMM 52-10-00.SDR SWIA2025112400018Skin · dentedREF AML 1751235: UPON INSPECTION FOUND: 3-OFF AREAS OF DENT DAMAGE TO LHS FUSELAGE SKIN PANEL (DWG: MM670-35146, 0.080€? ±0.005€? NOMINAL PAD UP THK, 0.050€? ±0.005€? & 0.060€? ±0.005€? CHEM-MILLED POCKET THICKNESS, REF) BETWEEN FS1015.00 -FS1047.00 ASDR AALA202511240682Light · inoperativeAIRCRAFT IN BASE MAINTENANCE: RT EMERGENCY EXIT DOOR LIGHT IS NOT WORKING. MAINTENANCE REPLACED RT EMERGENCY EXIT DOOR LIGHT, IAW AMM 33-51-16. OPS-CHECK GOOD.SDR AALA202511247455Light · inoperativeAIRCRAFT IN BASE MAINTENANCE: SEAT 9 AND14 CELLING EMERGENCY LIGHT IS NOT WORKING. MAINTENANCE REPLACED EMERGENCY LIGHT LOCATED ON CEILING PANEL BETWEEN ROWS 9 AND 14, IAW AMM 33-51-11.SDR AALA202511245885Light · inoperativeAIRCRAFT IN BASE MAINTENANCE: SEAT 23 CELLING EMERGENCY LIGHT IS NOT WORKING. MAINTENANCE REPLACED EMERGENCY CEILING LIGHT AT SEAT 23, OPS CHK GOOD IAW AMM 33-51-11.SDR AALA202511249808Actuator · leakingAIRCRAFT WAS GROUNDED: LAV SMOKE DETECTOR WENT OFF AND CABIN FILLED WITH A LIGHT HAZE. SMOKE DISCAPATED AS WE HEADED TO THE GATE. UPON ENGINE #2 INSPECTION MAINTENANCE FOUND UPPER OUTBOARD THRUST REVERSER ACTUATOR LEAKING AND SUSPECTED IT AS SOURCE FOR ODORS. SDR AALA202511246893Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER ATTACH ANGLE, LOCATED IN LEFT HAND ECS BAY, AT STA 663 AT LBL 38. REPLACED ANGLE PER AARD 51-00-05-1.SDR CALA2025112411424Pan · dentedREMOVED AND REPLACED HANDLE PAN AT L4 DOOR EXTERIOR IAW SRM 51-40-02-0G-0, DRAWING 146N6100. REMOVED AND REPLACED HANDLE PAN WITH P/N: 146N6201-5, BATCH:NUMB ER 0004442259 AT L4 DOOR EXTERIOR LAW SRM 51-40-01-0G-D , DRAWING 146N6100.SDR CALA2025112411422Web · corrodedAFT CARGO COMP. RT BS 1380 S23R TO S20R FOUND WEB WITH CORROSION. REMOVED AND REPLACED WEB BTW BS 1380 TO 1360 S22R IAW SRM 51-40-02-0G-0 AND DWG 146N8533 DOOR.SDR QMLA2025112220115Starter Gen · faultedWHILE CONDUCTING STARTUP CHECKS AND UPON ENGINES REACHING IDLE, THE NR 1 GEN DISCON CAUTION LIGHT ILLUMINATED. REPLACED STARTER GEN.SDR SWIA2025112100018Windshield · crackedFO WINDSHIELD SHATTERED AT FL340, RAN QRH, NO LOSS OF CABIN PRESSURE. DIVERTED TO DEN LANDED WITH NO OTHER ISSUES (FLIGHT 6203) REMOVED AND REPLACED FO WINDSHIELD IAW AMM 56-11-01 COMPLIED WITH TASK CARD 56-220-1000-SKY OPS CHECKS GOOD WITH NO LEAKS NOTED.SDR DALA2025112108516Slide · unpackedUNFOLDED OVERWING SLIDE EMERGENCY AT RT WING. OVERWING SLIDE EMERGENCY AT RT WING WAS REMOVED AND REPLACED IAW AMDS 2560-9901-RT, IAW CARD 56-2560-9-0002 AND AMM 25-65. (1310426)SDR QXEA2025112100348Fuel Cell · leakingFUEL LEAK AT THE RIGHT HAND WING ROOT / WHEEL WELL AREA. AREA HAD A PREVIOUS REPAIR APPLIED. AIRCRAFT REMOVED FROM SERVICE AND IS CURRENTLY BEING REPAIRED.SDR DALA2025112108514Light · inoperativeSEAT MOUNTED EMERGENCY LIGHT AT SEAT 24AB INOPERATIVE. R & R 24 A/B EMER SEAT LIGHT PER AMM 25-21-46. OPS CHECKED GOOD . MEL/PLACARD REMOVED. ABC OK FOR SVC.SDR CALA2025112111388Filter · dirtyPERFORM CONDITIONAL INSPECTION FOR SMOKE/ODOR IN CABIN 05-51-58-800-801-C3. ACCOMPLISHED CONDITIONAL INSPECTION, INITIAL INSPECTION, UP TO STEP F. NO FINDINGS, NO DEFECTS NOTED. INSPECTED AND PERFORMED ALL TEST ON ALL CABIN, GALLEY, LAV, CREW REST LIGHTING. SDR DXTA2025112005751Actuator · weakWHEN CLOSING MAIN CABIN DOOR ON OUTSIDE OF AIRPLANE USING EXTREMAL SWITCH IN AUTO MODE, MED WENT UP ABOUT 1/3 OF THE WAY AND THEN STOPPED AND CAME BACK DOWN. WAS UNABLE TO USE OUTSIDE SWITCH IN EITHER AUTO OR MANUAL TO RAISE DOOR. TRIED USING SWITCH ON INSIDSDR ANCF2025111835Gpws · abnormalGPWS FAULT AND ALERTING INFLIGHT DURING CLIMB - GPWS AS PER AMM 34-36-31--000-001/400-001 MMR 1 WAS REPLACED OPERATIONAL TEST WAS ACCOMPLISHED CAT III TEST WAS PERFORMED TEST OKSDR SWAA2025112036435Sign · inoperativeRIGHT EMERGENCY SIGN ABOVE OVERWING EMERGENCY DOORS INOPERATIVE. REMOVED AND REPLACED M1695 EMERGENCY EXIT LIGHT BATTERY PACK REF AMM 33-51-06. OPS CHECKED GOOD.SDR SWAA2025112036434Battery Pack · inoperativeLEFT EMERGENCY SIGN ABOVE OVERWING EMERGENCY DOORS INOPERATIVE. REMOVED AND REPLACED IAW AMM 33-51-06-960-805-NG.SDR SWAA2025112036063Support · delaminatedRIGHT WING OTBD FLAP NR 7 FWD SUPPORT FAIRING HAS MULTIPLE FASTENER HOLES FIBER GLASS DELAMINATED. REPLACED RT WING OTBD FLAP NR 7 FWD SUPPORT FAIRING IAW MM 27-51-28.SDR GTIA2025112039185Slide · inoperativeL1 DOOR SLIDE INOPERATIVE. R & R FWD L1 DOOR SLIDE IAW AMM 25-62-44 OPS CK GOOD SAFETY PIN REMOVED.SDR KCSA2025111865Pump · faulted100280839: HYD QTY LOW 1 DEMAND PUMP AND ENGINE PUMP BOTH OFF BEFORE SYS FLUID 0. ACTION TAKEN: REMOVED AND REPLACED #1 EDP HYD 1. IAW B747-400 AMM 29-11-05-004 AND 29-11-05-904. ALL CHECKS GOOD. NO LEAKS NOTED. DRY MOTOR PERFORMED. NO DEFECTS NOTED.SDR DALA2025112008498Radome · damagedSHIP 3237 DISC: BIRD STRIKE ON LOWER NOSE CONE ON CA SIDE. ABOUT 7500' ON CLIMB OUT FROM DENVER. NO ADVERSE CONDITIONS EXPERIENCED. C/A: INSPECTED A/C PER A320 AMM 05-51-14-200-803. DAMAGE NOTED ON RADOME. NO FURTHER DAMAGE ON A/C (WIP 184199) R&R RADOME PER ASDR DALA2025112008496Anchor · damagedREMOVED 3 NUTS FROM LT MLG RETRACT ACTUATOR MOUNT REMOVED 2 REMAINDER NUTS FROM RETRACT ACTUATOR MOUNT PLATE. REMOVED AND REPLACED LT MLG JACK ANCHORAGE ASSY PER ER/A 630497- 14, REV ORIG PER SECTION I PERMANENT REPAIR INSTRUCTIONS; REFER TO L.P 1309462. (LP:SDR DALA2025112008495Not Reported · damagedWORKING PRI ER/A 630497 REV "O". ACCOMPLISHED ALL REPAIR INSTRUCTIONS PRE PRI ER/A 630497 REV "O" PRI REVISIONS 1-4. FINAL ER/A 630497 REV. ORIGINAL SECTION I: PERMANENT REPAIR INSTRUCTIONS MATCH. (LP: 1309501)SDR DALA2025112008494None · noneER/A 543344-14 REV A REQUIRES NEW INSPECTIONS. LOGPAGE 2378650 WILL BE CLOSED AND NO LONGER WILL TRACK THE REPAIR PER ER/A 543344-14 REV ORIGINAL. THIS LOG WILL TRACK THE REQUIREMENTS PER ER/A 543344-14 REV A. NEW INSPECTIONS REQUIRED PER ERA 543344-14 REV A SDR DALA2025112008493Not Reported · noneER/A 543343-14 REV A REQUIRES NEW INSPECTIONS. NEW INSPECTIONS REQUIRED PER ERA 543343-14 REV A STARTING AT 39,000 TFC AND EVERY 1,600 FC THEREAFTER. LOGPAGE 2378641 WILL BE CLOSED AND NO LONGER WILL TRACK THE REPAIR PER ER/A 543343-14 REV ORIGINAL. THIS LOG SDR DALA2025112008492Threshold · noneNEW INSPECTION THRESHOLD REQUIRED PER ER/A 563946-14 REV B. THIS LOG PAGE SUPERSEDES LOG PAGE 0565626 PER ER/A 563946-14 REV B. DTE STAGE 2 AND 3 REQUIRED. ACCOMPLISH INSPECTION PER ER/A 563946-14 REV B PRIOR TO SIXTY-FOUR THOUSAND TWO HUNDRED (64,200 ) TOTALSDR N6WA2025112006Frame · corrodedCORROSION ON FRAME AT FS863 BETWEEN STGR26L-STGR26R. REPAIRED FRAME AT FS863 BETWEEN STGR26L-STGR26R IAW GOJET EO-C550-53MR-033-O