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 AALA202512155321Skin · delaminatedAIRCRAFT IN BASE MAINTENANCE: LEFT WING TRAILING EDGE AFT FLAP INBOARD BOTTOM SURFACE DELAMINATED. REPAIRED FLAP PER SRM 57-52-00-300-113.SDR KCSA202512121245Lamp · inoperativeAFT EMERGENCY LIGHT ON L/H UPPER DECK INOPSDR SIMA2025120906001Fitting · wornBEARING ON WING AT UPPER ATTACH POINT OF LT ENGINE UPPER LT PYLON LINK HAS EXCESSIVE PLAY REMOVED LT ENGINE PYLON UPPER ATTACH POINT OTBD FITTING ASSY PER SRM 51-40-08. INSTALLED THE NEW LT ENGINE PYLON UPPER ATTCH POINT OTBD FITTING ASSY IAW AMM 20-10-01, NE4SDR SWAA2025120839725Attach Bracket · corrodedCORROSION ON NOSE RADOME ATTACH BRACKET AT BS 178; RBL 12; WL 240.1. REMOVED AND REPLACED CLIP IAW AMM 53-52-00-400-801.SDR JJBA20251208019Floor Support · crackedCENTER OMEGA BEAM CRACKED AT FRAME 28. REPAIR DOUBLER INSTALLED ON CTR FUSELAGE II CTR OMEGA BEAM, AT FR 28 INBD VERTICAL FLANGE.SDR SWAA2025120440121Glowstrip · damagedPHOTOLUMINESCENT STRIP IS DAMAGED. INSTALLED NEW PHOTOLUMINESCENT STRIPS IAW AMM 33-51-15-960-801.SDR JJBA20251204014Floor Support · crackedCENTER FUSE II, LH OMEGA BEAM CRACKED AT FRAME 35. CENTER FUSE II, LH OMEGA BEAM AT FRAME 35 CUT-OUT PERFORMED AND REPAIRED.SDR JJBA20251204013Rib · crackedRH ENGINE UPPER COWLING, FWD RIB AT XN810 FOUND CRACKED. ON RH ENGINE UPPER COWLING, FWD RIB AT XN810 REMOVED AND REPLACED.SDR JJBA20251204011Spar Cap · corrodedLT AND RT WING SPAR II CAP SURFACE TO BE CLEAN AND REPROTECTED AT LOCATION OF AILERON LOWER SHROUD. AT LT & RT WING SPAR II CAP SURFACE FOUND CORRODED, LH WING SPAR II CAP SURFACE CORRODED OUT OF LIMIT AND RH WING SPAR II CAP SURFACE BLENDED WITHIN LIMIT. AT TSDR SWAA2025120339727Fuse · blownMULTIPLE EMERGENCY LIGHTS SURROUNDING RT OVERWING EXIT INOPERATIVE. REPLACED THE FUSE AND PERFORMED A GOOD OPS TEST OF EMERGENCY LIGHTS SURROUNDING RT OVERWING EXIT IAW AMM 33-51-06-960-804.SDR DALA2025120308834Sensor · out of tolerance1L DOOR INTERMITTENTLY SHOWS AS OPEN W/DOOR CLOSED AND ARMED ENTRY DOOR LIGHT ILLUMINATED IN COCKPIT. FOUND S194 "DOOR CLOSED SENSOR" OUT OF SPECIFICATION. ADDED TARGET SHIM, MEASUREMENT OF S194 NOW WITHIN LIMITS. ALL WORK DONE PER B767 AMM. 52-71. (8171956)SDR DALA2025120308831Indicator · inoperativeSLIDE INDICATOR LIGHT INOPERATIVE OR DAMAGED. FOUND SLIDE LIGHT COVER INCLUDING BULBS UNDER ATTENDANT SEAT ADJACENT. RE-INSTALLED AND PERFORMED OPS TEST SUCCESSFULLY PER B767-400 AMM 52-71 (1322223)SDR F2PA202512030279Pdu · failedON APPROACH TO LAND AT KAPA PILOTS SELECTED FLAPS DOWN, AND FLAP SYSTEM DID NOT RESPOND. PILOTS RECEIVED A CAS MASSAGE "FLAP FAIL". CREW FOLLOWED FOM AND PROCEEDED TO MAKE AN UNEVENTFUL NO FLAPS LANDING. AN EMBRAER AOG MAINTENANCE TEAM WAS DISPATCHED TO TROUBLSDR ASAA2025112662734Floor Panel · crackedAFT WET AREA FLOOR PANEL147A5810-421 IS CRACKED / DAMAGED. GROUNDED - YES. PERMANENT REPAIRED AFT WET AREA FLOOR PANEL 147A5810-421 IAW SRM 53-00-50-2R-6 & 53-00-50-2R-0.SDR AALA202512021934Hinge Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT HAND HORIZONTAL STABILIZER ELEVATOR #4 HINGE FITTING. REPLACED HINGE FITTING PER AMM 55-16-42.SDR R61A2025120200520Skin · crackedFOUND RIGHT WING LOWER SKIN CRACKED ON OVERNIGHT INSPECTION AFT OF PANEL 621CB INBD OF RIB 6 APROX 2.2 INCHES LONG. CUTOUT CRACK AND INSTALLED FILLER, DOUBLER, AND TRIPLER IAW ETD2025-170-932958. ALSO REF VP-049194-2025 FOR WORK ACCOMPLISHED.SDR CALA2025120211636Fan Cowl · gougedNUMBER 1 ENGINE OTBD FAN COWL INTERNAL SKIN AT 23 INCHES FROM FWD EDGE AND 33 INCHES FROM LOWER EDGE, FOUND MULTIPLE GOUGES. ACCOMPLISHED FAN COWL SKIN EXTERNAL REPAIR AT TWO FRAMES ON NR 1 ENG OTBD POSITION IAW SRM 54-20-01-2R-5 AND SRM 51-40-02-0G-0.SDR CALA2025120211629Proximity Sensor · miswiredR1 ARM LIGHT WILL NOT COME ON. INDICATION INOP. VERIFIED GIRT BAR ENGAGMENT OF DR 1R. SWAPPED LIGHT MODULE FROM L1 DOOR, FAULT DID NOT FOLLOW, FIM SUGGESTS COULD BE GIRT BAR PROX SWITCH, ALL TS PERFORMED REF FIM 25-66 TASK 802. FOUND FWD SENSOR S10216 FASDR IXXA20251124079Escape Reel · unserviceableTWO EMERGENCY ESCAPE REELS FELL FROM COMPARTMENT. PLACED ON DEFERRAL 68279 MINIMUM EQUIPMENT LIST ATI-25-61-01-01 CATEGORY C DUE 06 DECEMBER 2025. INSTALLED 2 EMERGENCY ESCAPE REELS POSITION 4 AND 5 IN ACCORDANCE WITH IAI B767 AMM 25-61-03.SDR ASAA2025112662686Door · lack of lubeF/A REPORTS L2 DOOR OPENING STICKS WHEN HALF WAY OPEN WHEN CLOSING AT ABOUT HALF WAY CLOSED THE DOOR BINDS AND COMES TO A STOP YOU CAN HEAR A SQUEEKING AND GRINDING NOISE COMING FROM THE LOWER HINGE. GROUNDED - YES. LUBRICATED L2 DOOR REF AMM 12-25-12 OPS CK NSDR WX0A2025120132652Unknown · odor(AIRCRAFT NOT GROUNDED) AFT FA REPORTED DIRTY SOCK SMELL 9 MINUTES PRIOR TO LANDING SMELL WORKED FWD TO FWD FA'S. PERFORMED AND COMPLIED WITH TC A32X-21-000-002. NO LEAKS OR SMELLS WERE NOTED. CANNOT DUPLICATE.SDR WX0A2025120132650Battery · inoperative(AIRCRAFT NOT GROUNDED) FA REPORTS PREFLIGHT OF FWD MEGAPHONE WAS NEGATIVE. REPLACED BATTERIES FOR FOREWARD MEGASPHONE OP'S CK GOOD IAW AMM 25-65-51-02"SDR WX0A2025120132649Light · unsecure(AIRCRAFT NOT GROUNDED) EMER EXIT ROW WINDOW LIGHTS NOT WORKING. RESECURED LIGHT IN SIDEWALL. OPS CHECKED GOOD. IAW AMM 33-21-11-400-001-A.SDR EVCA202512010001Hose · meltedSMOKE IN CABIN, AC HOSE ASSY HAD SPIRAL WRAP ON IT THAT CONTACTED HEATER SYSTEM FITTING BETWEEN TUBES PN: S-9402EC-17 AND S-9402EC-12 WHICH MELTED AND IS SUSPECTED TO HAVE CAUSED THE SMOKE IN CABIN EVENT.SDR SWAA2025120139743Counterweight · corrodedTHE RUDDER COUNTER BALANCE WEIGHT CORRODED AND MISSING PAINT. REPLACED THE RUDDER COUNTER BALANCE WEIGHT IAW CMM 55-40-09.SDR SWAA2025120139731Lamp · inoperativePASSENGER CABIN LT EMERGENCY EXIT DOOR LIGHT IS INOPERATIVE. REPLACED THE LAMPS IN THE EXIT LIGHT IAW AMM 33-21-00.SDR SWAA2025120140033Cover · detachedEMERGENCY EXIT SIGN IN THE MID-CABIN FELL OFF CEILING CONNECTION. REINSTALLED EXIT SIGN COVER IAW AMM 33-51-01SDR SWAA2025120139741Attach Bolt · crackedRIGHT WING NR 8 SLAT ACTUATOR, ONE FASTENER CRACKED AT ATTACHMENT POINT. REMOVED AND REPLACED THE RT WING NR 8 SLAT AND OPS CHECKED GOOD IAW AMM 27-81-21.SDR SWAA2025120140135Sign · detachedOVERHEAD EXIT SIGN DETACHED. RESECURED LIGHT ASSY IAW AMM 33-51-00.SDR SWAA2025120139993Lamp · inoperativeAFT SERVICE DOOR EMERGENCE LIGHT INOPERATIVE. REPLACED THE LAMPS IN THE EMERGENCY LIGHT IAW AMM 33-51-04-960-801. OPS CHECKED GOOD.SDR SWAA2025120140315Light · looseEMERGENCY EXIT LIGHT AT OVER WING EXITS LOOSE W/O 108464. SECURED THE EMERGENCY EXIT AISLE LIGHT ASSY IAW AMM 33-51-01. OPS CHECK GOOD. ACFT OKAY FOR SERVICE.SDR SWAA2025120140043Girt Bar · unsecureL1 GIRT BAR CAME LOOSE WHEN ATTEMPTING TO CLOSE DOOR. RESECURED THE L1 GIRT BAR IAW AMM 52-11-00, NO DEFECTS NOTED.SDR SWAA2025120140002Inlet · pulledNUMBER 1 ENG COWL ASSY, INLET INNER SIDE AT 3 O'CLOCK POSITION OUTER BARREL HAS 15 PULLED FASTENERS AND CRACKED 5.5' LONG .IAW TTG8Q0192A5K. R & R NR 1 ENG INLET COWL IAW AMM 71-11-01.SDR SWAA2025120140053Coffeemaker · odorACRID SMELL IN AFT GALLEY. SUSPECT AFT RIGHT COFFEEMAKER. FLT ATTENDANTS COULD NOT TURN IT OFF. TURNED OFF GALLEY POWER. SMELL DISSIPATED. OK TO CONTINUE IAW MEL 25-10-01 SP 1B & SP 2. PERFORMED SMOKE OR FUMES IN CABIN CONDITIONAL INSPECTION IAW AMM 05-51-5SDR SWAA2025120140306Coffeemaker · odorUNKNOWN BURNING IN THE FWD GALLEY. PERFORMED INSPECTION IAW AMM 05-51-56 NO ISSUES FOUND BELIEVE COFFEE MAKER. TO BE BAD. ACFT OK FOR SERVICE.SDR SWAA2025120139744Cover · crackedFWD ENTRY DOOR LINER HANDLE COVER IS CRACKED. R & R FWD ENTRY DOOR LINER HANDLE COVER IAW AMM 52-11-31.SDR SWI2025F01654Landing Gear · malfunctionedRECEIVED GEAR DISAGREE WARNING MESSAGE ON GEAR EXTENSION. GEAR SELECTOR LEVER IS LIMP. COMPLETED QRH - LANDED WITH OUT FURTHER ISSUE. DEFERRED PER MEL 32-30-1LOCATION: LANDING GEAR RETRACTION SYSTEMMAINTENANCE ACTION COMPLIED WITH ACCORDING TO MELCAT II DOWSDR SWIA202512011126Buttstrap · corrodedCORROSION ON BUTTSTRAP AT FS280.00 BTW STR 25R - STR 23R (FILED CLOSED)CHAFFING UNDER FUSELAGE SKIN ON STRG 27, FS 977.00 TO 989.00 BLEND-OU AND FOUND WITHIN LIMITS IAW MHICRJ700 SRM 53-00-01-101-001-A01, L:3" W:2" D:0.016",SURFACE REPROTECTED IAW SRM CRJSDR YENA2025120101130Floorbeam · corrodedDURING HEAVY MAINTENANCE: INSIDE CABIN FORWARD WET AREA CPCP TASK RIGHT SIDE OF CABIN CORROSION ON BEAM-Y1292 FRAME 20 STR 38R; REMOVED AND REPLACED FLOOR BEAM Y-1292 AT FWD WET AREA INW A321NEO SRM 51-42-11, 51-72-111-911-001 DRW D53135362000.SDR YENA2025120101129Beam · corrodedDURING HEAVY MAINTENANCE: INSIDE CABIN AFT WET AREA CORROSION ON L2 PASSENGER DOOR SILL BEAM AROUND LEVEL HOLES FRAME 68 STR 23L; REF TO HAECO WO 440616 NR 24384, REPAIRED AFT WET AREA AT L2 DOOR FR 68 STR 23L PASSENGER DOOR SILL BEAM IAW A321 SRM 53-41-14-300SDR KCSA20251201666Handle · out of positionDOOR F/D OVHD CAUTION MESSAGE ON CLIMB OUT. NO CHANGES IN PRESSURIZATION CONTINUED OPS AS NORMAL PER QRH. FOUND HANDLE NOT IN FULL CLOSED POSITION. OPEN AND CLOSED F/D OVHD DOOR IAW B747-400 AMM 52-21-00 OPS CHECK GOOD NO DEFECTS NOTED MESSAGE CLEARED NO FURTHSDR HNAA2025120100827Bleed Valve · failedBLEED 2 VALVE FAIL DURING T/O ROLL R & R NR 2 BLEED VALVE IAW AMM 36-11-05. OPS CHECK GOOD. NO LEAKS NOTED. A/C OK FOR SERVICE AT THIS TIME.SDR AALA202512012020Light · looseAIRCRAFT WAS NOT GROUNDED: EXIT ROW SEAT TRIM LOOSE 16C. REMOVED AND REPLACED EPL. PER 25-23-67.SDR IPXA2025120161137Indicator · inoperativeMAIN UPPER CARGO COMPT, BOTH CAUTION RAILS UP? SIGN NOT FLASHING LEFT SIDE WALL BS 400 - 290. R & R CARGO GUIDE RAIL CAUTION FLASHER (M3290) PER SWPM 20-30-00 AND AMM 20-51-01, OPS CHECK GOOD.SDR IPXA2025120150436Door · inoperativeON DEPARTURE AFTER GEAR RETRACTED BOTH MAIN LANDING GEAR DOORS REMAINED OPEN. JACKED AIRCRAFT ACCOMPLISHED NORMAL GEAR RETRACTION AND EXTENSION FOUND INDICATION OF LEFT MAIN GEAR DOOR AT FAULT REPLACED SWITCH 29GB REF AMM 32-00-00-0401 TEST GOOD ALSO ACCOMPLISDR R61A2025112600518Actuator · faultedFLAP FAIL AFTER TAKEOFF. DECLARED EMERGENCY, LANDED WITHOUT INCIDENT. REMOVED AND REPLACED NR 3 FLAP ACTUATOR.SDR UIEA2025112601326Elec Connector · damagedGEAR DISAGREE, GEAR DOORS EICAS MESSAGE AFTER GEAR UP SELECTION. PERFORMED PSEU LDG SYS 1 & 2. NO FAULT FOUND IAW AMM 32-09-04-204-013. PERFORMED PSEU LDG SYS 1 & 2, NO FAULTS FOUND IAW AMM 32-09-04-204-013. INSTALLED & REMOVED RT MAIN GEAR PIN ON SIDE BRSDR UIEA2025112801329Slide · partial deployL1 SLIDE PARTIALLY DEPLOYED, INADVERTENTLY DID NOT DEPLOY. REPLACED SLIDE L1 IAW AMM 25-66-01-404-07C. OPS CHK OK.SDR CALA2025120111623Battery · inoperativeDURING EMER LIGHT TEST DOOR 3R EMER SLIDE LIGHT FOUND INOP TRANSFER REFER NON-ROUTINE WO.5693243 AND ORIGINATOR V920569 DOOR 3R EMER SLIDE LIGHT LAMP REPLACED AND TEST NORMAL AS PER AMM 33-51-04 .SDR CALA2025120111619Skin · nickedLEFT FWD FUSELAGE RVSM CRITICAL AREA AT 5 INCHES FROM FWD EDGE AND 11 INCHES FROM LOWER EDGE FOUND A NICK. REMOVED NICK AT LT FWD FUSELAGE RVSM CRITICAL AREA AT 5 INCHES FROM FWD EDGE AND 11 INCHES FROM LOWER EDGE REF SRM 51-10-02-0G-0, ORIGINAL THICKNESS: 0.