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 SWAA2025101424025Sign · detachedCENTER AISLE OVER WING EXIT SIGN FELL OFF. REMOVED AND REPLACED CENTER AISLE OVERHEAD EXIT SIGN PER AMM 33-51-02. OPS CHECK GOOD.SDR SWAA2025101423857Handle · brokenR1 DOOR ASSIST HANDEL BROKEN. REPLACED R1 DOOR ASSIST HANDLE IAW AMM 52-41-31SDR DALA2025101407515Power Supply · faultedROW 27-38 SEAT MOUNTED EMERGENCY LIGHTS INOP. SLAVED IN BATTERY AND CHARGER IN LOCATIONS M114881 AND M11082 REF B757 AMM 33-51, REF B757 WDM 33-51-21 REPAIRED WIRE AT SEAT 38 DEF PER SWPM CH 20. RPLCD EMERG LT PWR SUPPLY M11487 REF AMM 33-51. ALL SEAT MOUNTEDSDR DALA2025101407509Elec Connector · disconnectedON S/C FOUND E-LIGHT OUT AT SEAT 26DEF. FOUND LIGHT DISCONNECTED. RE-CONNECTED LIGHT NOW CKS GOOD. REF B737 AMM 33-51.SDR DALA2025101407507Battery Pack · inoperativeFOUND EMERGENCY PATHWAY LIGHTS ROW 33 AND AFT INOP. R & R BATTERY PACK PER B737 AMM 33-51. OPS CHK GOOD.SDR AALA202510146275Elec Connector · damagedAIRCRAFT WAS GROUNDED: WHILE WORKING J/C# 26L00005005, FOUND (2) WHITE SEAT MOUNTED EMERGENCY AISLE LIGHTS INOP AT CABIN ROWS: 9ABC, AND 10ABC. FOUND CONNECTOR FOR SEATS 9ABC AND 10ABC EMERGENCY LIGHT SYSTEMD AMAGE, MAINTENANCE REPLACED CONNECTOR IAW ESPM 20-4SDR AALA202510148908Unknown · odorAIRCRAFT WAS GROUNDED: ONCE AT FLIGHT IDLE ON THE DESCENT THROUGH 17000 ABNORMAL ODOR NOTICED IN FLIGHT DECK. NOTHING NOTED IN CABIN. COMPLIED WITH QRH15-38, AND ODOR DISSIPATED WITHIN SEVERAL MINUTES. TURNED PACK1 AND CROSS BLEED BACK TO AUTO AND ODOR CAME BASDR DXTA2025101405287Latch Pin · lack of lubeCABIN DOOR WILL CLOSE BUT DOOR HANDLE WILL NOT MOVE. CHECKED BOTH FROM INSIDE AND OUTSIDE WITH NO LUCK. REMOVED AND INSTALLED CABIN DOOR STEP TO GAIN ACCESS ON CABIN DOOR LINKAGE IAW AMM 52-10-05. PERFORMED VISUAL INSPECTION AND FOUND FWD LOWER LATCH PIN HASSDR KCSA2025101252Lock · inoperativeDOOR UPPER DECK FLIGHT LOCK. TROUBLESHOT PER FIM 52-71 TASK 823. PERFORMED OPERATIONS TEST IAW AMM 52-23-00. ALL CHECKS GOOD AT THIS TIME.SDR YENA2025101401026Fire Loop · faultedFLT#8351, BOS-JFK. (ETOPS) "#2 ENG LOOP B FAULT ( ENGINE FIRE DETECTION SYSTEMS 2) LOOP B ). PERFORMED INSPECTION OF WIRE HARNESS PER TSM 26-12-00 -810-806 A NO DEFECTS NOTED THIS CLEARS MDDR 597097, MX-4 UPDATED, PLACARD REMOVED MCC CONTACTED 79453.SDR CALA2025101410078Cabin Pressure · faultedA/C DECLARED EMERGENCY LANDING DUE TO A PRESSURIZATION PROBLEM.. PILOT NOTED POSSIBLE PRESSURIZATION ISSUE. CABIN ALT LESS THAN ZERO ON OVERHEAD WITH DIFFERNTIAL ABOVE 6. PRESSURIZATION SCHEDULE IS NORMAL FOR FLIGHTS WITH ALTITUDE UNDER 18,500FT PER SDS 21-3SDR CALA2025101410077Battery · faultyMAIN BATTERY EICAS STATUS MAIN BATTERY FAILURE. UPON RETURNING TO GATE MAIN BATTERY REPLACED & INSTALLATION TESTED OK. MAIN BATTERY STATUS MX MSG CLEARED. AMM 24-31-01-000-801 & 24-31-01-400-801.SDR CALA2025101410069Structure · corrodedR1 DOOR INNER CHORD HAS CORROSION AT STA 328-2". REMOVED AND REPLACED INNER CHORD AT R1 DOOR IAW SRM 51-40-02 AND DWG #141A8310SDR CALA2025101410068Floorbeam · corrodedMAIN CABIN AFT WET AREA CORROSION AT FLOORBEAM STA 947.5 LBL 53". ACCOMPLISHED REPAIR AT LT AFT WET AREA FLOORBEAM 947.5" LBL 53" PER B737-800 SRM 53-70-51-2R-5 AND SRM 51-40-02-0G-0SDR CALA2025101410067Fairing · cracked#2 PYLON AFTER FAIRING WITH CRACK IN AFT AREA. REMOVED AND REPLACED NO. 2 PYLON AFTER FAIRING ASSY END, LOCATED DRILLED AND COUTERSUNK, APPLIED ALODINE, PRIMER, TOPCOAT PAINT IAW B737-900ER SRM 51-40-05-0G-0, SRM 51-40-02-0G-0,SRM51-40-08- 0G-0 SRM 51-21-72-3SDR CALA2025101410065Support Strap · corrodedAFT CARGO COMP) BEHIND RH SIDE PA NEL, BTW STA1280 AND STA1300, STRAP SPPRT HAS CORROSION AROUND N UTPLATES. DOT 23-043 COMPLETED SFR REPORTING ONLY REMOVED AND REPLACED STRAP (CHORD). AT AFT CARGO COMP. BEHIND R/ H SIDE PANEL BTW B51280-B51300. P/N:146N5448-2SDR CALA2025101410064Stringer Clip · crackedAFT CARGO COMP, BS 1380, NEAR S-27R, FLOOR STR CLIP HAS A CRACK. DOT 23-065 COMPLETED SFR REPORTING ONLY REMOVED AND REPLACED STR CLIP AT OFF CARGO COMP. STA 1380 FLOOR STR 5-27R IAW B757-200 SRM 51-40-02, DWG. 146N5393 AND TRAVELER T25/1835297.SDR CALA2025101410052Oil System · leakingOIL LEAKING FROM NR 1 ENG OIL LEAK IS ONLY COMING FROM C-SUMP DRAIN #1 ENG. OIL CONSUMPTION IS BELOW .20 QTS PER HOUR. PERFORMED IDLE LEAK CHECK NO ACTIVE OIL LEAKS OR FUMES OR FOGS AT IDLE. PLACE ON 5 CYCLE DIP IN REF TO AMM 71-71-00-200-801-G00. TOMC APPROVESDR CALA2025101410050Lamp · failedRIGHT FORWARD OVERWING EXTERNAL EMERGENCY LIGHT INOP. EMERGENCY LIGHTING SYSTEM OPERATIONAL CHECK {B737-33-3-0235} - REMOVED AND REPLACED BULB, OPS CHECK GOOD. PARTS USED: 29-3351-3-0015, QTY :1SDR CALA2025101410049D-Ring · unsecureDOOR 2L SLIDE RAFT D RING CONNECTION POINT NEEDS TO BE RESECUR ED FOUND D RING STRAP TUCKED AND HANGING BEHIND BUSTLE. RESECURED D RING ON VELCRO MOUNTING POINT. ADD EMP: U421130SDR CALA2025101410048Bracket · looseDOOR 1L GIRT BAR BRACKET RIGHT SIDE LOOSELY HOLDING GIRT BAR WHEN DISARMED. DOOR 1L GIRT BAR STOWS AND RELEASES NORMALLY FROM DOOR MOUNTED AND FLOOR MOUNTED BRAKETS. IAW AMM 25-66-01. OK FOR SVC.SDR CALA2025101410047Slide · no discrepancyDOOR SLIDE SAFETY PIN INSTALLED AT 2R REMOVED SAFETY PIN FROM SLIDE AT #2R. STOWED IN POUCH. VERIFIED SLID PIN REMOVED IAW GMM 09-10-05SDR YENA2025101401021Fan · odorFLT#1189, JFK-SAN. "ELECTRICAL ODOR FROM CENTER PEDISTAL ( EXTRACT FAN - NO AVNCS SYS FAULT ECAM CAUTION ); ITEM DEFERED IN ERROR LOG PAGE 4492949 ITEM 1 WAS TROUBLESHOT PER TSM 24-00-00-810-823-A FOUND AVIONICS EXTRACTOR FAN FIN 18HQ BAD R & R OPS CHECK GOOD SDR YENA2025101401020None · odorFLT#315, JFK-SFO. "MOTH BALLS SMELL COMING FROM ROW 9; C/W INFORMATION NOTICE 2017-T015, SECTION A, ISOLATED FAULT TO TYPE 10. THREE PASSENGERS FROM 7D, 8B, 23A USED MOTH BALLS TO WASH CLOTHES PER TSM 05-50-00-810-085-B / TSM 05-50-00-810-085-D. A/C OK FOR SERSDR ASAA2025101261500Battery Pack · inoperativeEMERGENCY EXIT AND SLIDE LIGHTS FOR R1 AND R2 DOOR INOP. GROUNDED - YES. REMOVED AND REPLACED BATTERY PACKS FOR ASSOCIATED LTS REF AMM 33-51-06. OPS GOOD.SDR SWAA2025101324006Slide · out of positionFWD ENTRY DOOR SLIDE LOOSE. REPOSITIONED FWD ENTRY SLIDE PACK IAW TC 725-61-06. A/C OK FOR SVC.SDR IPXA2025101320911Floor Panel · damagedFOUND MAIN DECK FLOOR PANEL DAMAGE, PANEL 231AFF. THIS REPAIR IS CLASSIFIED AS MAJOR PER GMM 05-04-01-02. REPAIRED IAW AMM 25-58-01-404-005, AMM 25-57-02-404-16 AND AMM 25-57-05-404-006 REV.146. INSTALLED MAIN DECK CARGO HANDLING AND CONDITION CHECK NORMSDR IPXA2025101321049Floor Panel · damagedFOUND MAIN DECK FLOOR PANEL DAMAGE, PANEL 231KFF. THIS REPAIR IS CLASSIFIED AS MAJOR PER GMM 05-04-01-02. REPAIRED IAW AMM 53-01-06-400-801 REV 146. INSTALLED MAIN DECK CARGO FLOOR PANEL AND CONDITION CHECK NORMAL.SDR IPXA2025101320871Floor Panel · damagedFOUND MAIN DECK FLOOR PANEL DAMAGE, PANEL NO : 232JFF. THIS REPAIR IS CLASSIFIED AS MAJOR PER GMM 05-04-01-02. REPAIRED IAW AMM 25-58-04-404-015, AMM 25-57-02-404-016 AND AMM 25-57-05-404-006 REV.146. INSTALLED MAIN DECK CARGO HANDLING AND CONDITION CHECK SDR IPXA2025101320914Floor Panel · damagedFOUND MAIN DECK FLOOR PANEL DAMAGE, PANEL 232FFF. THIS REPAIR IS CLASSIFIED AS MAJOR PER GMM 05-04-01-02. REPAIRED IAW AMM 25-57-02-404-016 REV.146. INSTALLED MAIN DECK CARGO HANDLING AND CONDITION CHECK NORMAL.SDR IPXA2025101320971Floor Panel · damagedFOUND MAIN DECK FLOOR PANEL DAMAGE, PANEL 231EFF. THIS REPAIR IS CLASSIFIED AS MAJOR PER GMM 05-04-01-02. REPAIRED IAW AMM 53-01-06-400-801, REV 146. INSTALLED MAIN DECK CARGO FLOOR PANEL AND CONDITION CHECK NORMAL.SDR IPXA2025101321062Floor Panel · damagedFOUND MAIN DECK FLOOR PANEL DAMAGE, PANEL 231CFF. THIS REPAIR IS CLASSIFIED AS MAJOR PER GMM 05-04-01-02. REPAIRED IAW AMM 53-01-06-400-801 REV.146. INSTALLED MAIN DECK CARGO FLOOR PANEL AND CONDITION CHECK NORMAL.SDR IPXA2025101320957Floor Panel · damagedFOUND MAIN DECK FLOOR PANEL DAMAGE, PANEL 231BFF. THIS REPAIR IS CLASSIFIED AS MAJOR PER GMM 05-04-01-02. REPAIRED IAW AMM 53-01-06-400-801 REV.146. INSTALLED MAIN DECK CARGO FLOOR PANEL AND CONDITION CHECK NORMAL.SDR IPXA2025101321174Floor Panel · damagedFOUND MAIN DECK FLOOR PANEL DAMAGE, PANEL 231DFF. THIS REPAIR IS CLASSIFIED AS MAJOR PER GMM 05-04-01-02. REPAIRED IAW AMM 53-01-06-400-801 REV.146. INSTALLED MAIN DECK CARGO FLOOR PANEL AND CONDITION CHECK NORMAL.SDR IPXA2025101321023Floor Panel · damagedFOUND MAIN DECK FLOOR PANEL DAMAGE, PANEL 231HFF. REPAIRED IAW AMM 25-57-02-404-016 REV.146, INSTALLED MAIN DECK CARGO HANDLING AND CONDITION CHECK NORMALSDR IPXA2025101320979Floor Panel · damagedFOUND MAIN DECK FLOOR PANEL DAMAGE, PANEL 232CFF. REPAIRED IAW AMM 53-01-06-400-801 REV.146, INSTALLED MAIN DECK CARGO FLOOR PANEL AND CONDITION CHECK NORMAL.SDR IPXA2025101320990Floor Panel · damagedFOUND MAIN DECK FLOOR PANEL DAMAGED, PANEL 231FFF. REPAIRED IAW AMM 53-01-06-400-801 REV.146. INSTALLED MAIN DECK CARGO FLOOR PANEL AND CONDITION CHECK NORMAL.SDR IPXA2025101321005Floor Panel · damagedFOUND MAIN DECK FLOOR PANEL DAMAGE, PANEL 231GFF. FOUND MAIN DECK FLOOR PANEL, CHECK NORMAL.SDR IPXA2025101320955Floor Panel · brokenFOUND MAIN DECK FLOOR PANEL DAMAGED, PANEL 232GFF. REPAIRED IAW AMM 53-01-06-400-801, REV146. INSTALLED MAIN DECK CARGO FLOOR PANEL AND CONDITION CHECK NORMAL.SDR WX0A2025101332597Unknown · odor(AIRCRAFT NOT GROUNDED) ALL 4 FA'S SMELLED DIRTY SOCK ON DESCENT INTO SCK. I ALSO SMELLED A MUSTY SMELL AT ABOUT 8,000 FT. THE SMELL SEEMS TO BE STRONGER IN AFT PORTION OF THE CABIN / COMPLIED WITH TC A32X21-000-002. THIS CLEARS MEL 49-10-01-A, MDDR 220784. SDR WX0A2025101332593Uplock Switch · faulted(AIRCRAFT NOT GROUNDED) (EMERGENCY DECLARED) ECAM L/G GEAR NOT UPLOCKED ON DEPARTURE. UPLOCK INDICATIONS AMBER ON NOSEWHEEL IN THE GEAR UP POSITION. / RAR NLG UPLOCK SWITCH ASSEMBLY IAW AMM 32-31-21-000/400-001-A. OPS CHECK GOOD. NO OTHER DEFECTS NOTED. "SDR GTIA2025101339127Unknown · odorFUMES REPORTED IN CABIN DURING DESCENT THROUGH 6'000' TURNED OFF PACK 2 & SMELL DISSIPATED IN ABOUT 3 MINUTES. ALSO SMELLED BURNING OIL AFTER SHUTDOWN IN COCPIT. --SDR GTIA2025101339126Unknown · odorCABIN ODOR REPORTED BY FA DURING APPROACH.SDR AALA202510136335Controller · inoperativeAIRCRAFT WAS GROUNDED: CABIN EMERGENCY EXIT LIGHTS FLICKERING INTERMITTENTLY WHILE TAXING TO GATE. FOUND LEFT HAND EMERGENCY EXIT CEILING LIGHTS AT SEAT ROW 3, 10,AND 14 TURNING ON WITH SWITCH OFF. PER AMM 33-51-06 REMOVE AND REPLACED POWER SUPPLY (AALA202510SDR AALA202510139837Heat Shrink · missingAIRCRAFT WAS NOT GROUNDED: RED HEAT SHRINK MISSING AT L1 DOOR GIRT BAR. (OPEN).SDR AALA202510138180Fuel Sys · abnormalAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING CLIMBOUT, RIGHT FUEL QUANTITY BEGAN DECREASING RAPIDLY. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT DFW. (OPEN).SDR AALA202510138247Lamp · burned outAIRCRAFT WAS NOT GROUNDED: AFT L2 DOOR EXTERIOR EMERGENCY LIGHT OUT. RELAMPED, PER AMM 33-51-04. OPS CHECKED GOOD.SDR AALA202510136598Track · dirtyAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR IS JAMMED. CLEANED DOOR TRACK ON LAVATORY-D, OP CHECK GOOD. REF CMM 25-40-64.SDR AALA202510136303Power Supply · inoperativeAIRCRAFT WAS GROUNDED: CABIN EMERGENCY EXIT LIGHTS FLICKERING INTERMITTENTLY WHILE TAXING TO GATE. FOUND LEFT HAND EMERGENCY EXIT CEILING LIGHTS AT SEAT ROW 3, 10,AND 14 TURNING ON WITH SWITCH OFF. PER AMM 33-51-06 REMOVE AND REPLACED POWER SUPPLY (AALA202510SDR AALA202510139845Girt Bar · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD ENTRY DOOR GIRT BAR REPORTS DIFFICULT TO OPEN AND CLOSE. ADJUSTED SLIDING BAR ON DIRT BAR ON L1 DOOR. PER AMM 25-66-01. OPERATIONAL CHECK GOOD.