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 DALA2025090206472Support · corroded(LOG 1176759) CORROSION ON LOWER SILL STA 794 TO 847 BTW STRINGER 25R AT AFT CARGO COMPARTMENT. LOWER SILL STA 794 TO 847 BTW STRINGER 25R AT AFT CARGO COMPARTMENT WAS REPLACED PER B737-800 SRM 51-40-02-0G.SDR DALA2025090206471Intercostal · corroded(LOG 1176216) CORROSION ON INTERCOSTAL STA 500F TO 500G BTW STRINGER 25L AT FWD CARGO COMPARTMENT. INTERCOSTAL STA 500F TO 500G BTW STRINGER 25L AT FWD CARGO COMPARTMENT WAS REPLACED AND REPAIRED PER B737-800 SRM 53-30-53-2R-PROCEDURE 1- REPAIR 1.SDR DALA2025090206470Support · corroded(LOG 1176168) CORROSION ON LOWER SILL STA 440 TO 492 AT FWD CARGO COMPARTMENT. LOWER SILL WEB STA 440 TO 492 AT FWD CARGO COMPARTMENT WAS REPLACED PER B737-800 SRM 51-40-02-0G.SDR AALA202509023618Bottle · low pressureAIRCRAFT WAS GROUNDED: R4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202509026992Battery · no testAIRCRAFT WAS GROUNDED: L2 FLIGHT ATTENDANT FLASHLIGHT , TEST BUTTON FLASHING RED. MAINTENANCE REPLACED FLASHLIGHT BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 25-65-00.SDR AALA202509020200Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202509021576Lever · looseAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS 3L DOOR ARM/DISARM LEVER LOOSE. MAINTENANCE TIGHTENED ARM/DISARM LEVER PER AMM 52-00-00.SDR CALA2025090208353Battery · no testEICAS MESSAGE EMERGENCY LIGHT ON UPPER EICAS. MAINT MESSAGE 33-11311 IS ACTIVE ON ONBORD MAINT EXISTING FAULTS. ACTIVE MAINT MSG 33-11311, SHOWING DEGRADED CLASS 11 DR 2RH REMOTE WELS BATTERY DEGRADED (M3351036). WAITING FOR M&E PN 78-3350-9-9001 TO DELIVER TOSDR CALA2025090208352Bulb · burned outFORWARD CARGO, AND EMERGENCY EXIT LIGHTS ANNUNCIATORS 1/2 ILLUMINATED. REMOVED FORWARD CARGO AND EMERGENCY EXIT LIGHTS ANNUNCIATORS REMOVED AND REPLACED BURNED OUT #387 LIGHT BULBS. OPS CHECK GOOD.SDR DALA2025090106464Ecs · contaminatedAFTER START OF BOTH ENGINES FA NOTIFIED CREW OF BURNT RUBBER SMELL IN BACK OF CABIN THRU CENTER OF CABIN. SECURED BOTH PACKS AND COMPLIED WITH EQRH. SMELL DISCIPATED WITHIN 1 MIN OF PACKS OFF. PERFORMED T/S AND MTC PER AMDS W/C 0550-2002. PERFORMED LEVEL A DESDR DALA2025090106432Power Supply · no testFIRST CLASS EMERGENCY LIGHTS INOP. REPLACED POWER SUPPLY PER AMM 33-51-06. (LP 7273537)SDR DALA2025090106431Battery Pack · no testDURING SVC CHECK FOUND EMERGENCY EXIT LIGHT NOT ILLUMINATING OVER L1 DOOR AND OVER FLIGHT DECK ENTRANCE. REPLACED BATTERY PACK M1675 REF B737 AMM 33-51. (LP 7203106)SDR 2025FA0000600Servo · contaminatedFUEL SERVO FOUND TO HAVE CONTAMINATION. HEAVY THICK BLUE STAIN.SDR REXA2026073001312Hinge · corrodedCORROSION ON BUSHING BORE LH/RH HINGE FITTINGS AT NLG W/W AREA (2EA) WAS FOUND LH/RH HINGE FITTINGS AT NLG W/W AREA (2EA) WERE REPLACED PER CRJ900 SRM 51-42-21-001-001-A01SDR 8WWA2026F00002Control Cable · chafedDURING INSPECTIONS WE HAVE DISCOVERED A TREND WHERE THE TELEFLEX CABLES THAT CONNECT TO THE FCU POWER CONTROL ARE SHOWING SIGNS OF WEAR CAUSED BY CHAFING AGAINST THE ENGINE LOWER COWLING. THE MOST SEVERE EXAMPLES OF THIS WERE ON SERIAL NUMBERS SH3205, SH3415,SDR SWIA202512260831Support Angle · corrodedAFTER REMOVAL OF PANEL 642AZ, FOUND CORROSION ON SUPPORT ANGLE FWD SIDE. R & R THE CORRODED SUPPORT ANGLE WITH NEW USING ALL NEW FASTENERS. REF DWG CC670-10320 REV -F AND SRM 51-42-21-001-001-A01.SDR SWIA202512190831Post · failed inspBS 409+128 BL 0 VERTICAL POST RT & LT SIDES HAS INDICATIONS .3" LONG BY 100% FSH IN THE AFT RADIUS AT WL69. FAILED NDT INSPECTION. REMOVED AND REPLACED BS 409+128 BL 0 VERTICAL POST IAW REO 601R-53-41-889 REV-D, COMPLETED TASK CARD 51-900-1003-SKY. REFERENCE SDR SWI2025F01788Web · crackedPOSSIBLE CRACK ON THE LT TRU BAY FLOOR WEB AT BS 193, DIRECTLY BEHIND THE SEAL STRIKER. REPAIRED CRACKED ON THE LH TRU BAY FLOOR WEB AT FS193, DIRECTLY BEHIND THE SEAL STRIKER REF REO 670-53-11-2181 REV - AND COMPLIED WITH THE STEPS OF THE FINAL REO 670-53-11SDR SWIA2025120831Former · corrodedPAX DOOR, FWD FORMER BS 311.75 BETWEEN DD2 - DD3, CORRODED. REMOVED AND INSTALLED NEW FORMER FS311.75. IAW SRM 51-42-06-001-001-A01, SRM 51-42-13-001-001-A01, SRM 51-42-21-001-001-A01, SRM 51-41-02-001-001-A01 AND DWG 601R31702 REV. N. PERFORMED PRESSURE LEASDR JJBA20251024065Floor Support · corrodedCORROSION FOUND ON LT OMEGA BEAM GUSSET, BETWEEN FRAMES 59 & 61. REMOVED BAD GUSSET BETWEEN FRAMES 59 & 61 LT SIDE AND INSTALLED NEW GUSSETSDR SWAA2025100610037Intercostal · crackedCRACK WEB - INTERCOSTAL LOCATED BTW STA 344 TO STA 360 RBL 12 AT FWD GALLEY AREA. REPLACED WEB - INTERCOSTAL AND FASTENERS LOCATED BTW STA 344 TO STA 360 RBL 12 AT FWD GALLEY AREA IAW B737-800 SRM 51-40-02; SRM 51-10-02 ITEM 9 AND DWG 141A5400 SHEET 13 REV - SDR SWAA2025100610038Intercostal · crackedCRACK WEB - INTERCOSTAL LOCATED BTW STA 344 TO STA 360 LBL 12 AT FWD GALLEY AREA. REPLACED WEB - INTERCOSTAL AND FASTENERS LOCATED BTW STA 344 TO STA 360 LBL 12 AT FWD GALLEY AREA IAW SRM 51-40-02; SRM 51-10-02 ITEM 9 AND DWG 141A5400 SHEET 46 REV A AND 141A5SDR SWAA2025100210033Web · crackedCRACK FLOOR STRUCTURE WEB LOCATED ON BL 0 BTW BS 277 TO BS 294.5 AT PASSENGER CABIN. REPLACED WEB LOCATED FLOOR STRUCTURE ON BL 0 BTW BS 277 TO BS 294.5 AT PASSENGER CABIN. IAW SRM 51-40-02-0G, AND DWG 141A5400, SHEET 20, REV-.SDR AALA202509270655Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL LOCATED AT BS 500, RBL 33. REPLACED TRANSITION PANEL PER SRM 51-40-02-0G.SDR AALA202509272454Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL LOCATED FROM BS 500B TO BS 500I AT LBL 26. REPLACED TRANSITION PANEL PER SRM 51-10-02.SDR AALA202509254859Bushing · corrodedAIRCRAFT IN BASE MAINTENANCE: RIGHT ELEVATOR TAB CONTROL MECHANISM LOWER HARDWARE HAS EVIDENCE OF SURFACE RUST. REMOVED AND INSTALLED 2EA (AALA202509250670) AND (AALA202509254859) RIGHT ELEVATOR TAB CONTROL MECHANISM AFT BUSHING, PER AMM 27-31-34. PERFORMED SASDR AALA202509250670Bushing · corrodedAIRCRAFT IN BASE MAINTENANCE: RIGHT ELEVATOR TAB CONTROL MECHANISM LOWER HARDWARE HAS EVIDENCE OF SURFACE RUST. REMOVED AND INSTALLED 2EA (AALA202509250670) AND (AALA202509254859) RIGHT ELEVATOR TAB CONTROL MECHANISM AFT BUSHING, PER AMM 27-31-34. PERFORMED SASDR REXA2025092500886Angle · crackedCRACKED ANGLE BETWEEN LBL 12, BS 280. THE ANGLE WAS REPLACED IAW SRM 51-42-06-001-001-A01, SRM 51-42-21-001-001-A01, AND SRM 51-42-10-001-001-A01.SDR REXA2025092500885Receptacle · crackedCRACKED ON BOX OF THE EXTERNAL POWER RECEPTACLE AT THE FWD FUSELAGE BOX OF THE EXTERNAL POWER RECEPTACLE AT THE FWD FUSELAGE WAS REPLACED PER CRJ900 SRM 51-42-06-001-001-A01, SRM 51-42-10-001-001-A01 AND SRM 51-42-21-001-001-A01.SDR REXA2025092500884Fitting · wornWEAR ON TWO FLAP FITTINGS, STUB FAIRINGS 171DL & 172DR, RT & LT WING TRAILING EDGE. FLAP FITTINGS WERE EVALUATED, AND DUE TO EXCESIVE DAMAGE, WERE REPLACED SRM 53-00-00-101-001-A01, AMM 20-21-00-910-801-A01, AND SRM 51-42-21-001-001-A01.SDR REXA2025092500883Support · wornWEAR ON TWO PLATE SUPPORTS OF FLAP STUB FAIRING 171DL & 172DR, RT & LT WING TRAILING EDGE. PLATE SUPPORTS WERE EVALUATED DUE TO EXCESIVE DAMAGE AND WERE REPLACED IAW SRM 53-00-00-101-001-A01, AMM 20-21-00-910-801-A01, AND SRM 51-42-21-001-001-A01.SDR AALA202509250585Rail · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO FORWARD CARGO COMPARTMENT AFT BULKHEAD LOWER RAIL ASSEMBLY LOCATED AT BS 500I. REPLACED RAIL ASSEMBLY PER SRM 51-40-02-0G.SDR AALA202509243584Window · scratchedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY EXIT DOOR 843 WINDOW INNER AND OUR PANE SCRATCHED. REPLACED WINDOW ASSEMBLY PER AMM 56-31-45.SDR IPXA2025091653930Support Angle · corrodedAPU INLET SUPPORT STRUCTURE FWD STRAP O/B END SHOWS SIGNS OF CORROSION , HAS 3 EA NUT PLATES PULLED THROUGH STRAP WHITH A LAYER OF WHITE POWDER. REMOVED AND REPLACED SUPPORT ANGLES IAW SRM 51 GUIDELINES, USING THE ORIGINAL PARTS AS SAMPLE IAW UPS GMM REV 12 SDR AALA202509233141Window · scratchedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY EXIT DOOR 844 WINDOW INNER PANE SCRATCHED. REPLACED WINDOW ASSEMBLY PER AMM 56-31-15.SDR R61A2025091700410Floor Support · crackedDURING C-CHECK MAINTENANCE FOUND CENTER CABIN FLOOR STRUCTURE AT FR 47 L/H OMEGA BEAM FOUND CRACKED. REPAIRED CENTER CABIN FLOOR STRUCTURE AT FR 47 L/H OMEGA BEAM IAW ETD 2025-170-927620SDR AALA202509172712Wire Harness · defectiveAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO PHX DUE TO THE FLIGHT CREW REPORTING THAT AN ENGINE 2 EGT OVER LIMIT ECAM MESSAGE DISPLAYED. THE FLIGHT CREW SHUT DOWN #2 ENGINE AS PER THE ECAM PROCEDURES. THE AIRCRAFT LANDED SAFELSDR AALA202509171579Coupling · defectiveAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO PHX DUE TO THE FLIGHT CREW REPORTING THAT AN ENGINE 2 EGT OVER LIMIT ECAM MESSAGE DISPLAYED. THE FLIGHT CREW SHUT DOWN #2 ENGINE AS PER THE ECAM PROCEDURES. THE AIRCRAFT LANDED SAFELSDR AALA202509173193Harness · defectiveAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO PHX DUE TO THE FLIGHT CREW REPORTING THAT AN ENGINE 2 EGT OVER LIMIT ECAM MESSAGE DISPLAYED. THE FLIGHT CREW SHUT DOWN #2 ENGINE AS PER THE ECAM PROCEDURES. THE AIRCRAFT LANDED SAFELSDR AALA202509176203Harness · chafedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO PHX DUE TO THE FLIGHT CREW REPORTING THAT AN ENGINE 2 EGT OVER LIMIT ECAM MESSAGE DISPLAYED. THE FLIGHT CREW SHUT DOWN #2 ENGINE AS PER THE ECAM PROCEDURES. THE AIRCRAFT LANDED SAFELSDR CALA2025091708992Frame · crackedAFT PIT AT FRAME 59RT UNDER STRINGER 41RT WEDGE IS CRACKED. REMOVED AND REPLACED WEDGE IN AFT CARGO PIT FR59RT AT STRINGER 4 1 IAW A320 SRM 51-72-11.SDR DALA2025091506775Wire Harness · shortedAFTER LEFT ENGINE START, ELECTRICAL FAULT LT FBW PC PMG INOPERATIVE. T/S IAW EFIM, FAULT CODE 2401F3249, RELAY PREVIOUSLY CHANGED, WIRING CHECK FOR PINS X1 & X2 AT K17 RELAY OK, WIRING CHECK FROM A276P1 PIN 1 TO 38 SHOWS 28 VDC. R & R CDC1 LRM09 IAW AMP 24-SDR DALA2025091306745Shim · migratedLEFT WING L/E I/B DRAG FITTING HAS SHIM MIGRATION AT LOCATION (1, A) FIGURE 4. AFT SIDE OF FITTING PER AD CARD #5720-01100-02A. CORRECTIVE ACTION: REPLACED L/W L/E I/B DRAG FITTING SHIM AND OVERSIZED HOLES IAW ERA 628602-14. (LP 1195921)SDR AALA202509122824Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR STRUCTURE SHIELD ASSEMBLY LOCATED FROM BS 787 TO BS 807 AT S25R. REPLACED SHIELD ASSEMBLY PER AARD 51-00-05-1.SDR AALA202509117600Reservoir · low pressureAIRCRAFT WAS NOT GROUNDED: DOOR SLIDE 3L HAS LOW PRESSURE INDICATION. MAINTENANCE REPLACED THE L3 DOOR SLIDE INFLATION RESERVOIR AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 25-62-49.SDR AALA202509104716Elec Connector · misinstalledAIRCRAFT IN BASE MAINTENANCE: SEAT ROW 28 WHITE CABIN EMERGENCY LIGHT OUT. MAINTENANCE REVERSED CONNECTIONS ON EMERGENCY LIGHT AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-11.SDR AALA202509109711Megaphone · not reportedAIRCRAFT IN BASE MAINTENANCE: CABIN EMERGENCY EQUIPMENT LEFT HAND FWD CLOSET MEGAPHONE. MAINTENANCE INSTALLED CABIN EMERGENCY EQUIPMENT, MEGAPHONE MPN A12SA, IN LEFT HAND FWD CLOSET IAW AMM 787 25-64-02.SDR SWAA2025090910191Charger · inoperativeEMERGENCY EXIT LIGHTS ASSOCIATED WITH BATTERY PACK M1669. BATTERY GOOD, SUSPECT CHARGER. REMOVED THE BATTERY CHARGER M1669 AND INSTALLED SERVICEABLE BATTERY CHARGER. PERFORMED GOOD INSTALLATION TEST IAW AMM 33-51-06-960-806. REPLACED THE LAMP IN EMERGENCY SDR SWAA2025090912965Charger · inoperativeEMERGENCY EXIT LIGHTS ASSOCIATED WITH BATTERY PACK M1669. BATTERY GOOD, SUSPECT CHARGER. REMOVED EMERGENCY LIGHT BATTERY CHARGER M1669 AND INSTALLED SERVICEABLE BATTERY CHARGER AND PERFORMED GOOD INSTALLATION TEST IAW AMM 33-51-06-960-806, REPLACED THE LAMP SDR AALA202509080706Bottle · low pressureAIRCRAFT IN BASE MAINTENANCE: R3 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.