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 WX0A2025110332623Power Supply · no test(AIRCRAFT NOT GROUNDED) FAILED EPSU BITE CHECK / REMOVED AND REPLACED EPSU REF WO535097"SDR DALA2025110308026Battery Pack · inoperativeEMERGENCY EXIT LIGHTS IN AFT GALLEY NOT STAYING ON DURING OPERATION. R/R EMERGENCY LIGHTS BATTERY PACK M1210 REF B767-400 AMM 33-51. OPS CHK OK. OK FOR SVC. (7928070)SDR DALA2025110308019Wire · damagedSHIP 3304 37 A/B WHITE SEAT EMERGENCY LIGHT INOP. CORRECTIVE ACTION: REPLACED LIGHT ASSY AND REPAIRED WIRING PER A330 AMM 33-51. (7959025)SDR QR9R2025110300002Sensor · faultyRRPM GAUGE WOULD DROP TO ZERO INTERMITTENTLY IN FLIGHT WITH LOW RRPM AUDIO. ALL OTHER ENGINE INDICATORS WERE NORMAL. HAPPENED SEVERAL TIMES IN FLIGHT. A TEST FLIGHT EVAL FOUND ROTOR RPM WENT TO 0 WHEN INCREASING COLLECTIVE PRIOR TO TAKEOFF TWO TIMES. RPM ON TRSDR QR9R2025110300001Gps · inoperativeNR 1 GPS FAILED TO BOOT PROPERLY AND STUCK IN FACTORY SETTINGS SCREEN DURING START RUNUP. REMOVED AND REPLACED GNS430W IAW 145MMS-023.SDR F3LA202511030322Power Supply · faultedTHIS AC WAS IN SCHEDULDED MAINTENANCE FOR THIS EVENT. DURING HEAVY CHECK EPSU UNIT 17WL FAULTING UNIT FAULT. REMOVED AND REPLACED EPSU 17WL REF AMM 33-51-38-000-001-A AND AMM 33-51-38-400-001-A. OPS CHECK GOOD. A/C OK FOR SERVICE.SDR CALA2025110310839Light · inoperative21A EMERGENCY EXIT LIGHT ON EXIT DOOR DOES NOT ILLUMINATE. PLACED SIDEWALL LIGHT AT 21A AFT LTH EMERGENCY EXIT DOOR ON MEL 3302 B. OVERWING EXIT SIDEWALL LIGHT INOPERATIVE AT SEAT 21A, EMERGENCY LIGHTS WORK NORMAL. R & R LIGHT ASSEMBLY, OPS CHECKED GOOD SDR REXA2026072701113Hinge Fitting · corrodedAFTER RT AILERON BUSHINGS REMOVAL: WEAR AND CORROSION ON ALL HINGE FITTINGS OF RT WING TRAILING EDGE WAS FOUND HINGE FITTINGS OF RT WING TRAILING EDGE WERE CLEANED PER SRM 51-26-00-001-001-A01 PAR 5 B CLEANING AND REPAIRED PER REO 690-57-51-491 REV. --SDR REXA2026072701094Hinge · corrodedAFTER LH AILERON BUSHINGS REMOVAL: WEAR AND CORROSION IN ALL BORE LUGS (L1,L2,L3,L4,L5,L6) AT CENTER HINGE FITTING AND HINGE 4 LUG LOWER OF AILERON WAS FOUND BORE LUGS L1 & L6 WERE CLEANED PER CRJ 900 SRM 51-26-00-001-001-A01 CLEANING, BORE LUGS L2, L3, L4 & SDR REXA2026052800831Bracket · corrodedCORROSION ON BRACKETS, MACHINED (6EAS) OF INTERNAL STRUCTURE AT FWD CARGO COMPARTMENT. CORROSION ON BRACKETS, MACHINED (6EAS) OF INTERNAL STRUCTURE AT FWD CARGO COMPARTMENT WAS EVALUATED OUT PER CRJ-900 SRM 51-21-06-001-001-A01 AND REPLACED PER CRJ 900 SRM 51-SDR REXA2026052800827Stiffener · crackedCRACK ON UPPPER STIFFENER ATTACHED TO POWER-ASSIST MOTOR BTW DATUM 4 AND DATUM 5 (AFT SIDE PANEL) OF PASSENGER DOOR INTERNAL STRUCTURE CRACK ON UPPPER STIFFENER ATTACHED TO POWER-ASSIST MOTOR BTW DATUM 4 AND DATUM 5 (AFT SIDE PANEL) OF PASSENGER DOOR INTERNALSDR SWIA2026031875545Skin · chafedRIGHT LOWER WING SKIN CHAFED UNDER PANEL 686AB. REPAIRED THE RIGHT LOWER WING SKIN CHAFED UNDER PANEL 686AB IAW REO 601R-57-21-4005, REV-.SDR SWIA2026030275401Slat Track · groovedLH SLAT TRACK 1-1 HAS MULTIPLE GROOVES ON OTBD FLAT (C-CHECK RO 02/28/2026)REPAIRED DAMAGE TO LH SLAT TRACK 1-1 IAW MHIRJ REO 670-57-42-2276 REV-- , AND SRM 51-12-00.SDR SIMA20260211002Light · damagedRIGHT NR 1 & 2 EMERGENCY PHOTOLUMINESCENT FLOOR LIGHTS DAMAGED. R & R THE EMERGENCY PHOTOLUMINESCENT FLOOR LIGHTS IAW AMM 33-50-21 OP CKD GOOD.SDR SWI2026F00075Diaphragm · corrodedRIGHT SIDE, LOWER SILL DIAPHRAGM STRUCTURE HAS CORROSION ON INBD EDGE FROM BS 720 TO BS 744. COMPLIED WITH PERMANENT REPAIR REO 690-53-41-566 REV-.SDR SWI2026F00074Deck Plate · corrodedCORROSION DISCOVERED AROUND THREE FASTENER HOLES ON LT SILL DECK BETWEEN BS 797 AND BS 813. COMPLIED WITH REO 690-53-41-569 REV-.SDR SWI2026F00073Deck Plate · corrodedCORROSION FOUND ON LT SILL DECK, BS 801 FOR OTBD FASTENER COMMON TO SILL DECK AND DIAPHRAGM. REPAIRED LT SILL DECK AND DIAPHRAGM AT FS 801 IAW MHIRJ REO 690-53-41-565 REV-. COMPLETED TASK CARD 51-900-1002-SKY AND ATTACHED COMPLETED FORM 337 NO WEIGHT CHANGE. SDR SWI2026F00072Deck Plate · corrodedCORROSION FOUND ON LEFT SILL DECK, BS 792 FOR OTBD 3 FASTENERS COMMON TO SILL DECK AND DIAPHRAGM. COMPLIED WITH REO 690-53-41-565 REV-.SDR SWI2026F00071Deck Plate · corrodedCORROSION DISCOVERED AROUND FASTENER HOLE ON LT OTBD SILL DECK AT BS 786. COMPLIED WITH REO 690-53-41-569 REV-.SDR SWI2026F00070Deck Plate · corrodedCORROSION DISCOVERED AROUND FASTENER HOLE ON LT OTBD SILL DECK AT BS 781. COMPLIED WITH REO 690-53-41-569 REV-.SDR SWI2026F00069Deck Plate · corrodedCORROSION DISCOVERED AROUND FASTENER HOLE ON LT OTBD SILL DECK AT BS 768. COMPLIED WITH REO 690-53-41-569 REV-.SDR SWI2026F00068Deck Plate · corrodedCORROSION DISCOVERED AROUND FASTENER HOLE ON LT OTBD SILL DECK AT BS 734. COMPLIED WITH REO 690-53-41-569 REV-.SDR SWI2026F00067Diaphragm · corrodedRIGHT, LOWER SILL DIAPHRAGM STRUCTURE CORRODED ON INBD EDGE BETWEEN BS 761 TO 785. REPAIRED RT LOWER SILL DIAPHRAGM INBD EDGE AT BS 761 - 785 IAW REO 690-53-41-566, REV-. COMPLETED TASK CARD 51-900-1002-SKY AND ATTACHED COMPLETED FORM 337 NO WEIGHT CHANGE. RESDR SWI2026F00066Deck Plate · corrodedCORROSION DISCOVERED AROUND FASTENER HOLE ON RT OTBD SILL DECK AT BS 781. RT SILL DECK AT BS 781 IAW REO 690-53-41-567, REV-. COMPLETED TASK CARD 51-900-1002-SKY AND ATTACHED COMPLETED FORM 337 NO WEIGHT CHANGE. REFERENCE CONTINUATION CARD FOR WORK PERFORMEDSDR SWIA2026011300002Deck Plate · corrodedCORROSION DISCOVERED AROUND FASTENER HOLE ON RT SILL DECK AT FS801. REPAIRED RT SILL DECK AT BS 801 IAW REO 690-53-41-567, REV-. COMPLETED TASK CARD 51-900-1002-SKY. NO WEIGHT CHANGE. REFERENCE CONTINUATION CARD FOR WORK PERFORMEDSDR SWI2026F00040Angle · corrodedUPON REMOVAL OF LOW-PRESSURE GROUND AIR DOOR STRUCTURES FOUND REINFORCING ANGLE CORRODED. REMOVED CORRODED REINFORCING ANGLE IAW SRM 51-42-06 AND INSTALLED NEW REINFORCING ANGLE IAW SRM 51-42-06 AND DWG 601R36025 REV. P AND COMPLIED WITH TASK 51-900-1003-SKYSDR SWI2026F00039Angle · corrodedUPON REMOVAL OF LOW PRESSURE GROUND AIR DOOR AFTANGLE FOUND LANDING ANGLE CORRODED. REMOVED LOW-PRESSURE GROUND AIR DOOR AFT ANGLE LANDING IAW SRM 51-42-06 AND INSTALLED NEW LOW-PRESSURE GROUND AIR DOOR AFT ANGLE LANDING IAW SRM 51-42-06 AND DWG 601R35226 RSDR SWI2026F00038Angle · corrodedLOW PRESSURE GROUND AIR DOOR FWD LANDING ANGLE IS CORRODED. REMOVED FWD LANDING ANGLE IAW SRM 51-42-06 AND INSTALLED NEW FWD LANDING ANGLE IAW SRM 51-42-06 AND DWG 601R35226 REV. P AND COMPLIED WITH TASK CARD 51-900-1003-SKY.SDR SWI2026F00037Mount · corrodedLOW PRESSURE GROUND AIR DOOR MOUNTING PLATE IS CORRODED. REMOVED AND REPLACED BY NEW MOUNTING PLATE AT LOW PRESSURE GROUND AIR DOOR, REF. SRM 51-42-06, REV. 39, AND DWG 601R35226 REV. P. COMPLIED WITH TASK CARD 51-900-1003-SKY. PERFORMED LEAK CHECK GOOD, NO LESDR SWI2026F00036Door Frame · corrodedUPON REMOVAL OF LOW-PRESSURE GROUND AIR DOOR STRUCTURES FOUND FRAME SECTION AT BS 589 CORRODED. REMOVED AND REPLACED BY NEW FRAME SECTION AT BS 589, S21-20L IAW SRM 51-42-06, SRM 51-42-21 REV. 39, DWG 601R36025 REV. P, AND DWG 601R35005 REV AG,SDR SWI2026F00035Angle · corrodedUPON REMOVAL OF FRAME BS 574 BETWEEN S20R AND S20L FOUND REINFORCING ANGLE CORRODED AT MULTIPLE LOCATION. REMOVED AND REPLACED BY NEW REINFORCING ANGLE AT BS 574 BETWEEN S24L TO S20L IAW SRM 51-42-06 AND SRM 51-42-21 REV. 39, AND DWG 601R36024 REV. N. PERFORSDR SWIA20260105102Door · corrodedLOW PRESSURE GROUND AIR DOOR AFT INTERNAL STRUCTURE ANGLE IS CORRODED. REMOVED AFT ANGLE IAW SRM 51-42-06 AND INSTALLED NEW AFT ANGLE IAW SRM 51-42-06 AND IAW DWG 601R35226 REV. P. PERFORMED LEAK CHECK GOOD,SDR AALA202512185021Light · brokenAIRCRAFT IN BASE MAINTENANCE: BROKEN LATERAL EMERGENCY EXIT LIGHT ON LOWER DOOR FRAME 832 AT AFT GAL LEY AREA (1EA). REPLACED LATERAL EMERGENCY EXIT LIGHT ON LOWER DOOR FRAME 832 ATAFT GALLEY AREA (1EA) I.A.W A320FAM AMM 33-51-13-000-001-A STEP 1 THRU 4.A (1)SDR SWAA2025121030900Scuff Plate · crackedCRACKED FWD SCUFF PLATE IN THE FWD CARGO BAY CUTOUT. REPAIRED FWD SCUFF PLATE IAW SRM 53-30-15-2R-1, REPAIR 1, AND BAC 5975.SDR SWAA2025121031135Stiffener · crackedFWD CARGO BAY BULKHEAD VERTICAL STIFFENER CRACKED, BS 540, LBL 24.97. REPLACED VERTICAL STIFFENER IAW SRM 51-40-02-0G-0, SRM 51-10-02-G-0, ITEM 9, AND DWG 11A2001, SHEET 113, REV B & DWG 111A2000, SHEET 49, REV -.SDR SWAA2025121031136Stiffener · crackedFWD CARGO BAY BULKHEAD VERTICAL STIFFENER CRACKED BS 540, LBL 0.22. REPLACED THE VERTICAL STIFFENER IAW SRM 51-40-02-0G-0, SRM 51-10-02-G-0, ITEM 9, AND DWG 11A2001, SHEET 113, REV B.SDR SWAA2025121031139Gusset · crackedCRACKED GUSSET, BS 500D, S19R IN THE FWD CARGO BAY. REPLACED THE GUSSET IAW SRM 51-40-02-0G-0, AND DWG 143A7902, SHEET 209, REV-.SDR SWAA2025121031140Gusset · crackedCRACKED GUSSET, BS 500D, S19L IN FWD CARGO BAY. INSTALLED GUSSET IAW SRM 51-40-02-0G-0, AND DWG 143A7902, SHEET 209, REV-.SDR SWAA2025121031134Plate · crackedCRACKED SEAL PLATE, ACCESS PANEL 333AB AT THE LT HORIZONTAL STAB. REPLACED THE SEAL ON ACCESS PANEL 333AB AT LT HORIZONTAL STAB IAW SRM 51-40-02-0G-0, AND SRM 51-10-02-0G-0, STEP 9.SDR SWAA2025120931138Support Bracket · crackedCRACK SUPPORT BRACKET LOCATED BS 540 AT LEVEL RBL 6 AT AIR CONDITIONING. REPLACED SUPPORT SUPPORT BRACKET LOCATED BS 540 AT LEVEL RBL 6 AT AIR CONDITIONING BAY IAW SRM 51-40-02 & DWG 212A1101 SHEET 3 REV -.SDR SWAA2025120931023Rib · crackedCRACK ON INSPAR RIB LOCATED STAB STA 129.50 AND 28 INCHES OF FROM SPAR AT RT HORIZONTAL STABILIZER. STEP 5 ANND STEP 6. EDDY CURRENT EQUIPMENT USED P/N: NORTEC 600D; S/N: 250593109 AND DUE DATE: 06-OCT-26. REPAIRED INSPAR RIB LOCATED STAB STA 129.50 AND 28 ISDR VNAA20251204007Support · corrodedAFTER REMOVAL OF LOWER FUSELAGE FAIRINGS, CRACK ON AFT REFUEL DUCT MOUNTING SUPPORT BTW FS 677.00 TO FS 669.40, BTW STRINGER 22R AND 21R. FT REFUEL DUCT MOUNTING SUPPORT BTW FS 677.00 TO FS 669.40 BTW STRINGER 22RH AND 21RH WAS REPAIRED PER REO 690-28-25-04SDR VNAA20251204005Fitting · corrodedCORROSION FLOOR FITTING UNDER THE WASTE (1EA) AND AISLE SIDE (1EA) ON FWD LAVATORY. FLOOR FITTING UNDER THE WASTE (1EA) P/N: A414252-3 AND AISLE SIDE (1EA) P/N: A414251-1 ON FWD LAVATORY WERE REPLACED PER CMM 25-40-40.SDR SWIA2025120101102Attach Angle · corrodedCORROSION FOUND ON ATTACH FLANGE OF STR22L FS280-FS333 (C-CHECK RO 11/30/2025)REPLACED STRINGER FROM STR22L FS280-FS333 REF. DWG#SH670-31630 REV K, CRJ700 SRM 51-42-06-001-001-A01; 51-42-21-001-001-A01. COMPLIED WITH TASK CARD 51-900-1002-SKY. ALL CHECKS GOOSDR CALA2025113011591Sensor · out of limitsFWD ENTRY LIGHT ILLUM AT 100KTS ON TAKEOFF LIGHT EXTINGUISHED AT 6000FT MSL/ 500FT AFE INTERR OMF, NO FAULTS, GVI FOUND S199 SENSOR OUT OF LIMITS, ADJUSTED IAW 52-71-11-802-801 OPS CHK GOOD. FULL AMM REF. 52-71-11-820-801SDR SWIA2025112800002Seat Track · corrodedFORWARD END OF R/H ISLE SEAT TRACK CORRODED AT FR17-18. CUT OUT DAMAGED PORTION OF R/H ISLE SEAT TRACK UPPER FLANGE AT FR17-18 AND DAMAGED CROWN TEETH. INSTALLED REPAIR FILLER AND DOUBLER ON R/H ISLE SEAT TRACK UPPER FLANGE. REF. ETD2025-170-931698 REV A. SEESDR SWAA2025112831022Access Panel · damagedELONGATED HOLES ON ACCESS PANEL 561BB TRAILING EDGE AT LT WING. REPAIRED ACCESS PANEL 561BB TRAILING EDGE AT LT WING IAW SRM 51-70-04-2R-10 REPAIR 10.SDR SWAA2025112631120Handle · deterioratedDETERIORATED HANDLE ON FWD ENTRY DOOR AT FWD GALLEY AREA, 3 EA. REPLACED HANDLE ON FWD ENTRY DOOR AT FWD GALLEY AREA IAW AMM 52-11-31-000-802 STEP 2. F. 3 AND AMM 52-11-31-400-802, STEP 3. G. 2.SDR SWAA2025112631121Handle · deterioratedDETERIORATED HANDLE ON AFT ENTRY DOOR AT AFT GALLEY AREA, 2 EA. REPLACED HANDLE ON AFT ENTRY DOOR AT AFT GALLEY AREA IAW AMM 52-13-31-000-802 STEP 2. F. 4 AND AMM 52-13-31-400-802 STEP 3. G. 2.SDR SWAA2025112631122Handle · deterioratedDETERIORATED HANDLE ON AFT SERVICE DOOR AT AFT GALLEY AREA, 2 EA, REPLACED HANDLE ON AFT SERVICE DOOR AT AFT GALLEY AREA IAW AMM 52-41-31-400-802, STEP 3. F. 2.