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 DALA2025082506283Flap · missingFCNT- AIRCRAFT ARRIVED AUS WITH THE LEFT WING OUTBOARD TRAILING EDGE AFT FLAP MISSING. MAINTENANCE REPLACED LEFT OUTBOARD FLAP, BOTH BELLCRANKS ASSYS, 4 CONTROL RODS AND THE #1 AND 2 FLAP CANOES PER B 737 AMM 27-51. REFER TO LOG PAGES 7056569, 7056570 AND 705SDR DALA2025082506292Skin · damaged(LOG 7056570) FOUND LT O/B FLAP DAMAGED. R/R LT OB FLAP IAW A/C 2750-4569-01.SDR DALA2025082506291Beam · corrodedAFT CARGO COMP-R/H LONGITUDINAL TRANSITION BEAM PANEL SUPPORT-FRON STA727C TO STA787- HAS DAMAGE/CORROSION. REPAIRED SECTION 727I-767 IAW B737-900 SRM53-00-53-2R-6.SDR DALA2025082506290Seat Track · corroded(LOG 1158690) CORROSION ON SEAT TRACK LBL 45.50, STA 520 AT PAX CABIN FLOOR STRUCTURE. SEAT TRACK LBL 45.50 BTW STA 500H TO 520 AT PAX CABIN FLOOR STRUCTURE WAS REPLACED PER B737-800 SRM 51-40-02-0G.SDR FDEA202508231533Skin · dentedDENT ON INTERNAL SURFACE OF WEDGE, SLAT NO. 11. INTERNAL SURFACE OF WEDGE SLAT NO. 11 WAS REPAIRED IAW B767 SRM 57-43-02-2R AND SRM 51-70-10-2R FIG 202 SHEET 4 REPAIR 4 REV 92 APR 15, 2025.SDR FDEA202508231532Warning Light · false activationFWD EQPT COOLING EICAS ALERT APPEARED ON CLIMB, AND NO COOLING LIGHT ON EQUIPMENT COOLING PANEL ALSO ILLUMINATED. AMM: 21-58-00-5-8 FWD EQPT COOLING LOW FLOW DUE TO V12 VALVE OPEN IN FLIGHT. FWD EQPT COOLING OPS CHKS NORMALSDR FDEA202508231531Outflow Valve · failedAIRCRAFT DID NOT PRESSURIZE ON CLIMB OUT. EMERGENCY DECLARED. R & R OUTFLOW VALVE AS REQ. OPS CHK NORMAL.SDR AALA202508259631Bottle · low pressureAIRCRAFT IN BASE MAINTENANCE: R1 DOOR BOTTLE PRESSURE LOW. MAINTENANCE SERVICED DOOR DAMPER FOR R1 DOOR IAW AMM 52-10-00-614-001-A.SDR AALA202508259346Battery · no testAIRCRAFT WAS NOT GROUNDED: DURING PS CHECK FAULT EPSU INT LOAD AFT L ON EMERGENCY LIGHT TEST. PER TSM 33-51-00-810-807-A MAINTENANCE REPLACED EPSU BATTERY ON AFT EPSU, IAW AMM33-51-38.SDR AALA202508250365Battery · no testAIRCRAFT WAS NOT GROUNDED: WHILE ACCOMPLISHING J/C 26L00025011 WHILE PERFORMING OPERATIONAL TEST OF EMERGENCY LIGHTING SYSTEM. FAULT OCCURED TO REPLACE THE BATTERY ON ESPU 11WL. MAINTENANCE REPLACED BATTERY ON 11WL EPSU IAW AMM 33-51-38.SDR AALA202508251282Battery · no testAIRCRAFT WAS NOT GROUNDED: WHILE ACCOMPLISHING J/C 26L00025011 WHILE PERFORMING OPERATIONAL TEST OF EMERGENCY LIGHTING SYSTEM. FAULT OCCURED TO REPLACE THE BATTERIES ON ESPU 12WL. MAINTENANCE REPLACED BATTERY 12WL EPSU IAW AMM 33-51-38.SDR DALA2025082406280Seal · leakingAIRCRAFT 5024, FUME SMELL IN FORWARD GALLEY, RETURNED TO GATE. CORRECTIVE ACTION: FOUND NBR 1 ENGINE FAN SHAFT COVER PACKING LEAKING OIL. REPLACED PACKING PER A320 FAM AMM 72-15. LEAK CK GOOD. PERFORMED COMPRESSOR FOAM WASH ON NBR 1 ENGINE PER AMDS WC 7200-920SDR JJBA20250825053Battery · dischargedMULTIPLE EMERGANCY LIGHTS OUT. COCKPIT STEP, MAIN DOOR EXIT, AISLE LIGHT 1, MAIN ENTRANCE CEILING, EXIT AISLE CEILING LIGHT 1. R+R EMERGANCY LIGHT BATT 1. OPS CHECK SATSDR ABXA20250823195Support Fitting · corrodedDURING THE C-6 MAINTENANCE VISIT AT HAECO GSO, CORROSION WAS FOUND ON THE LH HORIZONTAL STABILIZER LOWER BLADE SEAL SUPPORT FITTINGS. #2 FITTINGS TOTAL WERE FOUND TO HAVE CORROSION BETWEEN THE BLADE SEAL AND MATING FLANGE OF THE SUPPORT FITTINGS AND WITHIN THESDR ABXA20250823194Support Fitting · corrodedDURING THE C-6 MAINTENANCE VISIT AT HAECO GSO, CORROSION WAS FOUND ON THE LH HORIZONTAL STABILIZER LOWER BLADE SEAL SUPPORT FITTINGS. #3 FITTINGS TOTAL WERE FOUND TO HAVE CORROSION BETWEEN THE BLADE SEAL AND MATING FLANGE OF THE SUPPORT FITTINGS AND WITHIN THESDR ABXA20250823193Support Fitting · corrodedDURING THE C-6 MAINTENANCE VISIT AT HAECO GSO, CORROSION WAS FOUND ON THE LH HORIZONTAL STABILIZER LOWER BLADE SEAL SUPPORT FITTINGS. #4 FITTINGS TOTAL WERE FOUND TO HAVE CORROSION BETWEEN THE BLADE SEAL AND MATING FLANGE OF THE SUPPORT FITTINGS AND WITHIN THESDR ABXA20250823192Support Fitting · corrodedDURING THE C-6 MAINTENANCE VISIT AT HAECO GSO, CORROSION WAS FOUND ON THE LH HORIZONTAL STABILIZER LOWER BLADE SEAL SUPPORT FITTINGS. #5 FITTINGS TOTAL WERE FOUND TO HAVE CORROSION BETWEEN THE BLADE SEAL AND MATING FLANGE OF THE SUPPORT FITTINGS AND WITHIN THESDR ABXA20250823191Support Fitting · corrodedDURING THE C-6 MAINTENANCE VISIT AT HAECO GSO, CORROSION WAS FOUND ON THE LH HORIZONTAL STABILIZER LOWER BLADE SEAL SUPPORT FITTINGS.# 6 FITTINGS TOTAL WERE FOUND TO HAVE CORROSION BETWEEN THE BLADE SEAL AND MATING FLANGE OF THE SUPPORT FITTINGS AND WITHIN THESDR ABXA20250823190Support Fitting · corrodedDURING THE C-6 MAINT VISIT, CORROSION FOUND ON LT HORIZONTAL STAB LOWER BLADE SEAL SUPPORT FITTINGS. NR 7 FITTINGS TOTAL WERE FOUND TO HAVE CORROSION BETWEEN THE BLADE SEAL & MATING FLANGE OF SUPPORT FITTINGS & WITHIN THE SUPPORT ATTACHMENT HOLES. ALL CORROSIOSDR ABXA20250823189Skin · damagedDURING THE CURRENT C-6 HEAVY MAINTENANCE CHK, MAINT FOUND AT BS 871.5, RT FWD OVERWING EMERG EXIT DOOR HAD NICK DAMAGE ABOVE WINDOW-PLUG CUTOUT. FASTENERS REMOVED AT AFFECTED AREA IAW SRM 51-40-02 & DAMAGE BLENDED OUT IAW SRM 52-20-01 RESULTING IN THE FINAL BLSDR ABXA20250823188Panel · damagedDURING THE C-6 MAINTENANCE CHECK, THE NR 2 ENGINE PYLON PANEL ASSEMBLY WAS FOUND TO BE DAMAGED BEYOND REPAIR. MAINTENANCE FABRICATED A NEW PANEL. ACCORDING TO BAC DWG 313T2381 REQUIREMENTS, THE PIECES MUST BE PHOSPHORIC ANODIZED (PAA) AND PRIMED WITH BMS5-13SDR ABXA20250823196Escape Reel · detached(4) INERTIAL ESCAPE REELS DROPPED AFTER LANDING. DEFERRED IAW MEL C ABX-25-61-1-1. REMOVED AND REPLACED 4 DESCENT DEVICES IAW AMM 25-61-03. PLACARDS REMOVED. THIS CLEARS DI 65509. NO FURTHER MAINTENANCE ACTION REQUIRED. LP 39229-54/1. AIRCRAFT RETURNED SDR CALA2025082508090Stop Fitting · damaged(SDR) 53-5305-1-2060 - TAIL AREA, AFT POTABLE WATER SERVICE DOOR FWD CUTOUT DOORSTOP IS DAMAGED. DOT 23-059. REF: NR 130314. C/W SDR/SFR REPORTING ONLY REPAIRED AFT POTABLE WATER SERVICE DOOR FWD CUTOUT DOOR STOPS PE R EC/RA# 5361-01126 AND VT MAE EA 757-5360-SDR CALA2025082508089Support Channel · corrodedAFTER OPENING ACCESS PANEL 197LL, FOUND SUPPORT CHANNEL WTB L BL 6 WITH EXFOLLIATION, STA 1180 TO STA 1220. DOT 68-18. REF: NR 129950. C/W SDR/SFR REPORTING ONLY REMOVED AND REPLACED SUPPORT CHANNEL AT STA 1180 TO STA 1220 LBL 6 IAW B757-200 SRM 51-40-02-OG-0 SDR CALA2025082508088Oven · dirtyODOR ONLY HAPPENED IN COCKPIT, NO ODOR IN CABIN. ONCE IN CRUISE FOR 15-20 MINS & ONCE ON DESCENT FOR 15-20 MINUTES..ODOR WENT AWAY BOTH TIMES SDR REPORTABLE DISCREPANCY TROUBLESHOOTED AIR CONDITIONING SYSTEM IN REF WITH FIM TASK 21-00-01/301 STEP 3 PROCEDURE 1SDR CALA2025082508087Rivet · missingSERVICE CHECK EXTERIOR WALK-AROUND PROCEDURE - 2, MISSING RIVETS ON CNA T/E, 12 CLOCK POSITION OF FWD ROW ON INNER SKIN SIDE. .NO OTHER RIVETS FELT OR LOOK LOOSE. REPLACED THE CNA AS PER EC/RA: 7811-01400 STEP: G.1. OKAY FOR 78-DIP FOR ENG 1 CNA TRAILING ESDR CALA2025082508086Power Supply · no testEMERGENCY LIGHTS OPS TEST WITH THE TEST SWITCHES PROCEDURE, EMERGENCY AISLE PATH LIGHTING SEATS 18 TO 32 DO NOT ALWAYS COME ON AND FADE OUT QUICKLY. REPLACED BATTERY PER AMM 33-51-06-960-802 AND LIGHTS COME ON DIM, REPLACED EMERGENCY PWER SUPPLY PER AMM SDR CALA2025082508085Engine · overtempENGINE LIMIT EXCEED CAUTION RT ENG EXCEEDED AN OPS LIMIT. AMBER LIMIT FOR EGT OR RED LINE FOR EGT, N1 AND N2, & RT ENG RUNNING. DB ELECT EC CHANNEL A. ENG NR 2 EGT OVERTEMP IAW AMM OVERTEMP INSP, EXCEEDANCE IS IN AREA A. HPT BOROSCOPE PERFORMED WITH NO FSDR CALA2025082508084Light · shortedPROCEDURE - EPSU EXT LOAD EMER R FAULT ON PTP AFTER EMER SYS TEST EXTERIOR LIGHT FAULT LIGHT ON RIGHT EPSU (PIC INCLUDED) RIGHT OVER WING EXTERIOR LIGHTS NOT WORKING RELAMPED OVERWING EXTERIOR LIGHTS, NO HELP. NO POWER AT PIN B, REINSTALLED LIGHTS ON FARING T/SDR ABXA20250823187Door Frame · corrodedDURING C6 CHECK AT HACECO INSPECTION FOUND E&E DOOR CUTOUT FWD FRAME WEB STA303 HAS PUNCTURE REMOVED ANGLE SUPPORT RAIL IAW B767 SRM 51-40-02, REMOVED DAMAGE IAW B767 53-00-07 REPAIR 3. MATL ID FOR FILLER .032 7075 PO1060506.1 AND DOUBLER 7075 T6 .040 PO 9837SDR UIEA2025082401134Bracket · brokenEMERGENCY EQUIPMENT CABINET LEFT PBE BRACKET BROKEN. SECURED PBE BRACKET FASTENERS IAW SRM 51-40-02. NO DEFECTS NOTED AT THIS TIME.SDR SIMA2025082503001Light · inoperativeEMERGENCY PHOTOLUMINESCENT INDICATOR STRIP LIGHT INOP IN FWD PASSENGER ENTRYWAY. RAR PASSENGER ENTRYWAY PHOTOLUMINESCENT INDICATOR STRIP LIGHT IAW ERJ-175 AMM 33-50-21/400. OPS CHECK GOOD. NO FURTHER DEFECTS NOTED.SDR SIMA202508253002Light · inoperativeFLIGHT DECK EMERGENCY LIGHT INOP READJUSTED COCKPIT EMER LT PER AMM 33-50-03. OPS CHK GOOD. NO FURTHER DEFECTS NOTED.SDR DALA2025082506282O-Ring · leakingMISC/DE, DUE TO LOSS OF BLUE HYDRAULIC SYSTEM QUANTITY AND PRESSURE. REPLACED O-RING TO PARKING BRAKE VALVE UNION. OPS AND LEAK CHECK GOOD. (7223106)SDR QMLA2025082320091Unknown · odorDURING RUN-UP FOR FLT, CREW NOTICED WHAT THEY DESCRIBED AS A BURNING ODOR. NO OTHER ABNORMAL INDICATIONS OBSERVED. ACFT SHUTDOWN NORMALLY, MX WERE NOTIFIED & ACFT WAS TAKEN OOS. DETAILED INSPECT OF COCKPIT WIRING & ELECT CONNECTIONS CONDUCTED. ACFT WAS CHARSDR REXA2026073001310Bracket · corrodedCORROSION ON HINGE(1 EA) AND BRACKETS (2 EAS) AT ACCESS PANEL 196DR CORROSION ON HINGE (1 EA) AND BRACKETS (2 EAS) AT ACCESS PANEL 196DR WAS REMOVED PER CRJ900 SRM 51-21-06-001-001-A01 AND WERE EVALUATED ARE OUT LIMITS THEREFORE WERE REPLACED PER CRJ900 SRM 51SDR REXA2026073001309Hinge · corrodedCORROSION ON HINGE(1 EA) AND BRACKETS (2 EAS) AT ACCESS PANEL 196DR CORROSION ON HINGE (1 EA) AND BRACKETS (2 EAS) AT ACCESS PANEL 196DR WAS REMOVED PER CRJ900 SRM 51-21-06-001-001-A01 AND WERE EVALUATED ARE OUT LIMITS THEREFORE WERE REPLACED PER CRJ900 SRM 51SDR REXA2026073001308Hinge · corrodedCORROSION ON HINGE(1 EA) AND BRACKETS (2 EAS) AT ACCESS PANEL 196DR CORROSION ON HINGE (1 EA) AND BRACKETS (2 EAS) AT ACCESS PANEL 196DR WAS REMOVED PER CRJ900 SRM 51-21-06-001-001-A01 AND WERE EVALUATED ARE OUT LIMITS THEREFORE WERE REPLACED PER CRJ900 SRM 51SDR SWIA2025082275778Roller · out of limitsCOMPLY WITH SCHEDULED MAINTENANCE CODE: TRACK ROLLER SLAT 1-2 900 RH - COMPLY WITH TASK CARD 27-630-809 RH TRACK ROLLER SEALED, TRACK 1-2, TOP FORWARD - SLAT 1 ( REMOVED AND REPLACED RH TRACK ROLLER SEALED TRACK 1-2 , TOP FORWARD SLAT 1 IAW AMM CRJ900 27-81-43SDR SWIA2025082275206Roller · wornFOUR RT SLAT TRACK SIDE ROLLERS AT 3-2 ARE WORN REMOVED AND REPLACED FOUR RT WING SLAT TRACK SIDE ROLLERS AT 3-2, IAW AMM:27-81-44-400-803-A01. EXTENSION AND RETRACTION OF SLATS GOOD AND OPERATING SMOOTHLY.SDR SWIA2025082275205Roller · wornALL FOUR RT WING SLAT TRACK SIDE ROLLERS AT 2-2 ARE WORN. REMOVED AND REPLACED FOUR RT WING SLAT TRACK SIDE ROLLERS AT 2-2, IAW AMM:27-81-44-400-802-A01. OPS TESTED GOOD.SDR SWIA2026020475200Fitting · chafedPAX DOOR FLOOR AFT CLOSING FITTING EXFOLIATED. REPLACED PAX DOOR FLOOR AFT CLOSING FITTING IAW DWG SH670-31810, REV AE, SRM 51-42-06-001-001-A01, & SRM 51-42-21-001-001-A01. COMPLIED WITH TASK CARD 51-900-1002-SKY.SDR SWIA202512020822Floor Support · crackedCOCKPIT FLOOR BEAM AT LBL 12.00 HAS CRACKED. REMOVED AND INSTALLED WITH NEW WITH NEW SUPPORT ANGLE AT LBL12.00 BETWEEN BS 250 - 280 IAW SRM 53-11-43-201-003-A01.SDR SWI2025F01585Plate · corrodedRBL9 TOP PLATE CORRODED IN MULTIPLE AREAS AS MARKED BETWEEN FS693.00 - FS847.00 (C-CHECK RO 11/22/2025)REMOVED CORROSION ON RBL9 TOP PLATE BETWEEN FS693.00 - FS847.00 FS693.00 REF. CRJ700 SRM 51-21-06-001-001-A01, PART FOUND WITH 100% MATERIAL LOSS AND REQUSDR SWI2025F01584Slat Track · gougedLEFT WING LEADING EDGE SLAT TRACK 3-3 HAS GOUGE MARKS (FLAGGED) CAMP# 30713603 (C-CHECK RO 11/22/2025)COMPLIED WITH REO 670-57-42-2204 REV -- DATED 2025-09-12. OPS TEST GOOD AT THIS TIME PER CRJ700 AMM 27-50-00-710-801-A02. COMPLIED WITH SKYWEST TASK CARD 27SDR SWIA202511240822Slat Track · corrodedCORROSION FOUND ON RIGHT WING LEADING EDGE SLAT TRACK 1-2 (MARKED) CAMP# 30712069 (C-CHECK RO 11/22/2025)COMPLIED WITH REO 670-57-42-2196 REV-- DATED 2025-09-12 PERFORMED OPERATIONAL TEST OF THE FLAPS AND SLAT SYSTEM CRJ700 AMM 27-50-00-710-801-A02 TEST OK ATSDR IPXA2025092713122Angle · crackedONE ANGLE BRACKET CRACKED AT THE COCKPIT FLOOR SUPPORT STRUCTURE AT FR 10, Y-953. REMOVED ANGLE BRACKET IAW SRM 51-40-21 AT THE COCKPIT FLOOR SUPPORT STRUCTURE AT FR 10, Y-953. RECEIVED FROM FAB SHOP NEW PICKUP ANGLE P/N UPA 5361225120300. INSTALLED NEW PISDR IPXA2025092606949Rib · crackedLEFT WING CENTER FLAP, TOP SKIN RIB FLANGE, 2 CRACKS NOTED AT RIB11. CIRCLED IN RED.ACCOMPLISHED THE REPAIR IN ACCORDANCE WITH EO-94890-REQ1 AND VT-MAE EA 300-5750-27-A4108.SDR IPXA2025092607053Rib · crackedLEFT WING CENTER FLAP, TOP SKIN RIB FLANGE, 1 CRACK NOTED AT RIB15. CIRCLED IN RED.ACCOMPLISHED THE REPAIR IN ACCORDANCE WITH EO-94890-REQ1 AND VT-MAE EA 300-5750-27-A4108.SDR IPXA2025092607057Rib · crackedLEFT WING CENTER FLAP, TOP SKIN RIB FLANGE, 1 CRACK NOTED AT RIB19. CIRCLED IN RED.ACCOMPLISHED THE REPAIR IN ACCORDANCE WITH EO-94890-REQ1 AND VT-MAE EA 300-5750-27-A4108.