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 AALA202510081235Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CABIN FLOOR BEAM AT FR 68 AT +Y1162. REPLACED FLOOR BEAM PER SRM 51-42-11.SDR AALA202510086310Motor · failedAIRCRAFT WAS NOT GROUNDED: THE NUMBER 2 ENGINE FUEL AFT LOW PRESSURE LIGHT CAME ON AND REMAINED LIT. TROUBLESHOT PER WDM 28-23-11. PERFORMED VOLTAGE CHECK OF CONNECTOR D74, FOUND 115V AT ALL THREE PHASES. SUSPECT PUMP AT FAULT. REMOVED AND REPLACED NUMBER 2 ASDR DALA2025100807328Skin · damagedSHIP 9540 DUE ER/A 628896-14 REV. ORIG. SECTION II PERMANENT REPAIR INSTRUCTION FOR RIGHT SIDE FUSELAGE SKIN DAMAGED AT STA. 237"- STA. 294". COMPLIED WITH PERMANENT REPAIR PER B717-200 SRM 53-00-01 (1219111)SDR AALA202510078254Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON ANGLE ATTACHED TO L1 ENTRY LOWER SILL INNER CHORD (CREASE ANGLE) BETWEEN BS 310 AND BS 340 AT LBL 59. REPLACED ANGLE PER AARD 51-00-05-1.SDR ASAA2025092661317Rail · corrodedFWD CARGO AFT BULKHEAD R/H SUPPORT CORRODED RBL 30 TO 35 STA 500L. GROUNDED - YES. REMOVED DAMAGE FOUND TO BE OUT OF LIMITS IAW B737-900ER SRM 53-30-08-1A-1. REMVOED AND REPLACED SUPPORT RAIL ON FWD CARGO AFT BULKHEAD RH BTW RBL 30 TO 35 STA 500L IAW B737-900ESDR CALA2025100609636Stringer · dentedREF. LOG PAGE # 6361899 STRINGER 49R IS DAMAGED BETWEEN STA. 1958 AND STA. 1979CUT OUT DAMAGED SECTION OF STRINGER REF. SRM 53-70-03-2R-1 REPAIR 1 PARAGRAGH 4.C. REQUEST ON INSPECTOR PERFORM HFEC INSPECTION OF CUT EDGES AND ALL INITAL FASTENER HOLES IN REPAIRSDR JBZA20250930001Fire Detector · failed inspRETURNING TO BASE FROM SCENE CALL FIRE WARNING AUDIO GONG SOUNDED INTERMITTENTLY. REMOVED AND REPLACED FIRE WARNING UNIT PN L315M5007051 RMVD PL650 INSTALLED PL107, SYSTEM FUNCTIONAL CHECK SATISFACTORY. APPROXIMATELY SEVEN MINUTES AFTER DEPARTURE FIRE WARNINSDR AALA202510045688Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL ANGLE LOCATED AT BS 396, LBL 13. REPLACED ANGLE PER AARD 51-00-05-1.SDR G1IA202510036097Engine · warning messageON DEPARTURE FROM KPAE TO PAKT CLIMBING THROUGH 12,000' MEDICS COMPLAINED OF BURNING SMELL, THEN SMELL WENT AWAY VERY SHORTLY AFTER. CONTINUED CLIMB AND THEN AT ABOUT FL200, GOT MASTER WARNING RIGHT ENGINE FIRE AND ASSOCIATED CAS MESSAGE. ACCOMPLISHED MEMORY ISDR IPXA2025100251097Support · brokenMDC, LH SIDE, FLOOR PANEL241BF, LOWER SURFACE HAS A PUCTURE AND MATERIAL DAMAGED. FLOOR PANEL 241BF FABRICATION COMPLETE IAW SREO-16407-REQ001.SDR HNAA2025100300661Floor Support · corrodedF068535 CORROSION ON LH OTBD #2 FLOOR SILL. REMOVED AND REPLACED FLOOR SILL ON LH OTBD #2 FLOOR SILL IAW EMB145 SRM 51-40-02.SDR CALA2025100309594Floor Panel · corrodedFWD CARGO COMPARTMENT AT CARGO DOOR LOCATION, FROM STA.440 TO STA. 492 AND STRINGER S-26R LOWER MAIN SILL STRUCTURE HAS CORROSION. REMOVED AND REPLACED NEW WEB STA 440 TO 492 AT S-26R IAW B737 SRM 51-40-05-0G-0, 51-40-02-0G-0 AND DWG # 143A8120SDR AALA202510026932Door · out of rigAIRCRAFT IN BASE MAINTENANCE: R2 DOOR WAS REMOVED AND SENT TO SHOP FOR REPAIR, REINSTALLED AND RIGGED DOOR. ACCOMPLISH PRESSURIZATION LEAK CHECK.SDR AALA202510023750Window · scratchedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND PASSENGER WINDOW R20 AT AFT EMERGENCY EXIT SCRATCHED. INSTALLED NEW SERVICEABLE WINDOW. PER AMM 56-22-00.SDR AALA202510027504Stop Pad · misinstalledAIRCRAFT IN BASE MAINTENANCE: LEFT OVERWING EXIT AFT EXIT UPPER AFT STOP PAD ON DOOR NOT INSTALLED IN THE CORRECT ORIENTATION. ADJUSTED LEFT HAND OVERWING EXIT AFT EXIT UPPER AFT STOP PAD. PER AMM 52-22-00.SDR AALA202510023986Stop Pad · misinstalledAIRCRAFT IN BASE MAINTENANCE: RIGHT OVERWING EXIT LOWER AFT STOP PADS ON AFT EXIT DOOR NOT INSTALLED IN THE CORRECT ORIENTATION. ADJUSTED RGITH HAND OVERWING EXIT LOWER AFT STOP PADS ON AFT EXIT DOOR. PER AMM 52-22-00.SDR AALA202510023227Stop Pad · out of adjustAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND OVERWING EXIT UPPER AFT STOP PADS ON AFT EXIT DOOR NOT INSTALLED IN THE CORRECT ORIENTATION. ADJUSTED RIGHT HAND OVERWING EXIT UPPER AFT STOP PADS ON AFT EXIT DOOR. PER AMM 52-22-00.SDR AALA202510025946Stop Pad · misinstalledAIRCRAFT IN BASE MAINTENANCE: LEFT HAND OVERWING EXIT FORWARD EXIT UPPER AFT STOP PAD ON DOOR NOT REINSTALLED IN THE CORRECT ORIENTATION. PER AMM 52-22-00.SDR AALA202510021820Window · crazedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND PASSENGER CABIN WINDOW L18 AT FORWARD EMERGENCY EXIT CRAZED. INSTALLED SERVICEABLE LEFT HAND PASSENGER CABIN WINDOW L18 AT FORWARD EMERGENCY EXIT. PER AMM 56-22-00-400-801.SDR AALA202510025405Window · scratchedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND PASSENGER WINDOW R19 AT FORWARD EMERGENCY EXIT SCRATCHED. INSTALLED NEW SERVICEABLE WINDOW. PER AMM 56-22-00.SDR DALA2025100207163Unknown · odorSTRONG ELECTRICAL ODOR IN FLIGHT DECK AND CABIN AFTER LANDING. PERFORMED WC 0550-2001. PARTICLE READING DOUBLED WITH APU BLEED ON, AND ENGINES RUNNING WITH FAINT DUSTY SMELL. INSPECTED APU COMPARTMENT AND APU INLET WITH NO FINDINGS. C/W WORK CARD 0550-2003, SDR JJBA20251002050Shear Tie · crackedCFIV, SHEAR CLIP AT FR58 BTW STR 15L-16L FOUND CRACKED. CFIV, SHEAR CLIP AT FR58 BTW STR 15L-16L REMOVED AND REPLACED.SDR 2025FA0000676Steering Sys · brokenWHILE MAKING AN INITIAL LANDING AT KAUS, THE TOUCHDOWN OF NLG DIDN'T FEEL THE SAME AS OTHER IN THIS ACFT. ASKED AUSTIN TOWER TO ASK OPS CAR DRIVING BY, TO TAKE A LOOK WITH THEIR SPOTLIGHT AT THE GEAR), THEY DID AND DIDN'T SEE ANYTHING ON THE GEAR OR LEAKING SDR CALA2025093009439Intercostal · crackedLEFT FRAME 16 DOUBLE JOGGLE AREA HOLE 18 HAS CRACK INDICATION IN FRAME LAYER AT 5 O`CLOCK, DIRECTION 50%. REMOVED FASTENERS COMMON TO #18 (LEADER), #19 (ASSOCIATED). REF SRM 51-42-11/001. HOLE #18, #19 DIA. = NOMINAL. REAMED HOLE 18 TO MAX DIA. OF .34220? INSDR G1IA2025093026097Warning Message · illuminatedON DEPARTURE FROM KPAE TO PAKT CLIMBING THROUGH 12,000' MEDICS COMPLAINED OF BURNING SMELL, THEN SMELL WENT AWAY VERY SHORTLY AFTER. CONTINUED CLIMB AND THEN AT ABOUT FL200, GOT MASTER WARNING "RIGHT ENGINE FIRE" AND ASSOCIATED CAS MESSAGE. ACCOMPLISHED MEMORYSDR SWAA2025093018611Light · burnedBURNED EMERGENCY LIGHT (1 EA) LOCATED BEHIND ACCESS PANEL 194FR AT LOWER FUSELAG. REPLACED EMERGENCY LIGHT (1 EA) LOCATED BEHIND ACCESS PANEL 194FR AT LOWER FUSELAGE IAW B737-700 AMM 33-51-04-960-801.OPERATIONAL TEST IS OK.SDR SWAA2025093018610Light · burnedBURNED EMERGENCY LIGHTS (2EA) LOCATED BEHIND ACCESS PANEL 194FL AT LOWER FUSELAGE AND LOCATED AT AFT ENTRY DOOR. REPLACED EMERGENCY LIGHTS (2EA) LOCATED BEHIND ACCESS PANEL 194FL AT LOWER FUSELAGE AND LOCATED AT AFT ENTRY DOOR IAW AMM 33-51-04-960-801 TEST SDR AALA202509303627Track · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT ADVISES LEFT AFT LAVATORY-D HAS DIFFICULTY OPENING. APPEARS TO BE STICKING AT THE TOP OF THE DOOR TRACK. CLEANED TRACK AND LUBED TRACK FOR LAVATORY-D. PER AMM 25-40-00.SDR AALA202509309264Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: FIRST CLASS LAVATORY DOOR DIFFICULT TO OPEN. LUBRICATED FIRST CLASS LAVATORY DOOR. PER STANDARD PRACTICES, OPERATIONAL CHECKED GOOD.SDR AALA202509306511Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTED LEFT AFT REAR LAVATORY-D DOOR IS DIFFICULT TO OPEN. LUBRICANTED LAVATORY-D AS REQUIRED, OPERATIONAL CHECKED GOOD.SDR AALA202509302666Latch · not seatedAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR UPPER EMERGENCY EXIT PANEL LATCH NOT SEATED PROPERLY. INSTALLED BLOW OUR DOOR CORRECTLY. PER AMM 52-51-08.SDR AALA202509308417Power Supply · inoperativeAIRCRAFT WAS NOT GROUNDED: EXTERIOR EMERGENCY LIGHT BEHIND R2 DOOR INOPERATIVE. REMOVED AND REPLACED EMERGENCY POWER SUPPLY, OPERATIONAL SYSTEM CHECK GOOD. PER AMM 33-51-06.SDR AALA202509304039Flashlight · no testAIRCRAFT WAS NOT GROUNDED: FORWARD FLIGHT ATTENDANT SEAT EMERGENCY FLASHLIGHT INOPERATIVE. REPLACED FLASHLIGHT. PER AMM 25-64-00.SDR AALA202509300274Power Supply · no testAIRCRAFT WAS NOT GROUNDED: WHILE DOING AN OPERATIONAL TEST OF THE EMERGENCY LIGHTS FOUND THE SEAT MOUNTED ESCAPE PATH LIGHTING BETWEEN ROWS 26 TO 33 NOT LIGHTING UP. REMOVED AND REPLACED EMERGENCY POWER SUPPLY M1672, OPERATIONAL CHECK GOOD. PER AMM 33-51-06.SDR AALA202509306310Warning Light · illuminatedAIRCRAFT WAS NOT GROUNDED: THE NUMBER 2 ENGINE FUEL AFT LOW PRESSURE LIGHT CAME ON AND REMAINED ILLUMINATED. T/S PER WDM 28-23-11. PERFORMED VOLTAGE CHECK OF CONNECTOR D74, FOUND 115V AT ALL THREE PHASES. SUSPECT PUMP AT FAULT. OPENSDR DALA2025093007110Door Sill · corrodedAFT PASSENGER DOOR SILL HAS 6 LOCATIONS WITH SURFACE CORROSION AT OR NEAR THE SILL/ CORNER STRIKER FASTENER HOLES. HOLES 2, 3, 4, 11, 12, 14 COUNTING FWD TO AFT FROM FR 74- FR76. AREAS ARE MARKED AND SEE PHOTO FOR REFERENCE. SSI: 53-61-23-02. COMPLETE: REMOVSDR DALA2025093007105Light · inoperativeSEAT 4J EMER LIGHT INOP. REPLACED LIGHT ASSY PER A330 AMM 33-51. OK FOR SERVICE. (7621326)SDR DALA2025093007090Battery Pack · inoperative(LOG 7751028) EMERGENCY EXIT LIGHTS AT SEATS 19/20ABC AND 19 DEF INOP. REMOVED AND REPLACED BATTERY PACK M1694 PER B737 AMM 33-51. OPS CHK GOOD.SDR YENA2025093000975Fire Loop · faultedFLT#1907, JFK-CDG. (ETOPS) "ENG 2 FIRE LOOP B FAULT ( ENGINE FIRE DETECTION SYSTEMS 2) LOOP B ); FAULT CURRENTLY INACTIVE, NO RECENT HISTORY. NOTHING ON PFR, PREVIOUS LEGS REPORT OR ECAM. BITE TEST PASSES ON R ENG FDU PER AMM 26-12-00. PERF'D DVI PER TSM 26SDR JJBA20250930046Controller · failedDURING CLIMBOUT AUTO PRESS INCREASED UNCONTROLLED, MANUAL MODE OPERATED NORMAL. USING FIM TROUBLESHOOT TO DIGITAL CONTROLLER, DIGITAL CONTROLLER ERROR CODE READER FOUND MULTIPLE FAILURE CODES. REMOVED AND REPLACED DIGITAL CONTROLLER. PERFORMED OPS CHECKS IN AUSDR JJBA20250930048Floor Support · crackedCFIII, RH GUSSET BTW FR 35-39 FOUND CRACKED. CFIII, RH GUSSET BTW FR 35-39 REMOVED AND REPLACED.SDR DALA2025093007083Flange · corrodedCORROSION AT VERTICAL FLANGE OUTBOARD SURFACES AND AROUND NUT PLATE HOLES . COMPLIED WITH ER/A 629280-14. (1219817).SDR UIEA2025092601246Cover · detachedEMERGENCY EXIT LIGHT COVER FELL OFF L1 DOOR. INSTALLED EMERGENCY EXIT LIGHT COVER IAW AMM 33-51-03. NO FURTHER DEFECTS NOTED.SDR REXA2025093000897Oxygen Mask · no deployDURING CRUISE CREW REPORTED R BLEED DUCT WARNING WITH CABIN DEPRESSURIZATION. FOLLOWING QRH PROCEDURES THE DESCENDED AND DECLARED EMERGENCY. PASSENGER OXYGEN MASKS WERE DEPLOYED WITH A FEW NOT DEPLOYED, ROWS 7 C7D AND 16 A&B. INSPECTED SEAT 7 C/D AND 16 A/B OXSDR YENA2025093000972Unknown · odorFLT#1229, EWR-CUN. TRANSIENT ODOR EVENT DURING TAKEOFF, MODORATE NURNING SMELL THROUOUT CABIN. BEGAN TO DISIPATE DURING CLIMBOUT. ( THALES-AVANT IFE (ENTIRE SYSTEM) ); REACTIVATED AVANT IFE SYSTEM IAW AVANT AMMS 44-21-00. NO HAZARDOUS CONDITION NOTED. PERFORMESDR YENA2025093000971Coffeemaker · odorFLT#1307, BOS-BNA, ODOR EVENT ON DESCENT INTO BNA 2-3 MINUTES IN DURATION FROM APPOX 17000 TO 14000 FT COCKPIT NOTICED FOR 2 MINUTES AFT GALLEY NOTICED FOR 3 MINTUES WAS WORST IN AFT GALLEY ELECTRICAL SMELL MIST OR SMOKE VISABLE EYE IRRATION AND HEADACHE SYMPSDR AALA202509298805Locking Cam · out of adjustAIRCRAFT WAS NOT GROUNDED: L1 DOOR RIGHT HAND GIRT BAR FLOOR CLIP IS STICKING. ADJUST AND CLEAN GIRT BAR AND CLIP. OPERATIONAL CHECK GOOD. PER AMM 25-66-00.SDR AALA202509292264Slide · dislodgedAIRCRAFT WAS NOT GROUNDED: FORWARD DOOR EMERGENCY EXIT SLIDE ABOVE GIRT BAR INFLATABLE SLIDE PROTRUDING. SECURED L1 DOOR SLIDE. PER AMM 25-66-01.SDR ASAA2025092661173Lens · missingEXIT SIGN FORWARD OF 17F EMERGENCY EXIT MISSING. GROUNDED - YES. REPLACED LENS COVER AT 17F EXIT SIGN PER AMM 33-51-01. A/C OK FOR CONTIMUED SERVICE.SDR ASAA2025092661154Battery Pack · inoperativeWHILE PERFORMING TC 78233008 FOUND L1 OVERHEAD EXIT LIGHT R2 GALLEY EXIT LIGHT AND 6D AISLE LIGHT INOP. GROUNDED - YES. RELAMPED 6D ASILE LT NO HELP, R2 GALLEY EXIT LT OPS NORMAL. FOUND BATTERY PACK 1674 FROM CHARGER. REMOVED AND REPLACED 1674 BATTERY PACK P