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 CALA2026011613009Lamp · inoperativeEMERGENCY LIGHT AT BS 1197 LT, INOPERATIVE, REAR OF WING TRAILING EDGE. EMERGENCY LIGHT LAMP REPLACED IAW AMM 33-51-06-902-08, LIGHT NOW OPERATES WHEN SELECTED.SDR CALA2026011613008Bulb · burned outON TAXI OUT, FA SAYS A STRONG ODOR OF BURNED RUBBER OR GAS APPARENT FROM ROW 38 AFT. DID NOT DISAPATE. PERFORMED CABIN INSPECTION, IAW AMM 05-51-58-910-801-C1. FOUND BURNED LIGHT BULB AT LOCATION ROW 38 RT OVERNEAD BIN , IAW FA, IT WAS LIKE RUBBER OR ELECTRISDR CALA2026011613007Floor Support · corrodedAFT FLOOR SUPPORT Y765 CORRODED AT FASTENER HOLES BETWEEN FR 66 - 68. REMOVED AND REPLACED THE FLOOR SUPPORT AT Y765, FR 66 - 70 IAW SRM 51-42-11/001.SDR CALA2026011613006Floor Support · corrodedSECONDARY FINDING UPON REMOVING FLOOR PANEL FOR FLOOR SUPPORT REPLACEMENT, FOUND CORROSION ON FLOOR SUPPORT Y+160 HARDPOINT. REMOVED AND REPLACED THE FLOOR SUPPORT AT Y160 FR 68 TO 70 IAW SRM 51-42-11/001.SDR CALA2026011613004Skin · contaminatedLEFT ELEVATOR UPPER SKIN HAS LIQUID INGRESS INDICATION 126 INCHE S FROM INBD, AND 9.5 INCHES FROM TRAILING EDGE. DRILLED WITNESS HOLES IN LT ELEVATOR UPPER SKIN 126IN FROM I/B 9 .5IN FROM T/E. FOUND NO LIQUID, REPAIRED IAW SRM 55-21-11-30 0-004. CATEGORY A RSDR CALA2026011613003Skin · contaminatedLEFT ELEVATOR UPPER SKIN HAS LIQUID INGRESS INDICATION 29 INCHES FROM INBD, AND 21 INCHES FROM TRAILING EDGE. DRILLED WITNESS HOLES IN LT ELEVATOR UPPER SKIN 29IN FROM I/B 21 IN FROM T/E ZONE A, FOUND NO LIQUID. REPAIRED AREA IAW SRM 5 5-21-11-300-004, CATESDR CALA2026011613002Skin · contaminatedLEFT ELEVATOR UPPER SKIN HAS LIQUID INGRESS INDICATION 156 INCHE S FROM INBD, AND 7.0 INCHES FROM TRAILING EDGE. DRILLED WITNESS HOLES ON ELEVATOR UPPER SKIN LT 156IN FROM I/B 7 IN FROM T/E ZONE A-C, FOUND NO LIQUID REPAIRED IAW SRM 55-2 1-11-300-004, CATEGOSDR CALA2026011613001Skin · contaminatedLEFT ELEVATOR UPPER SKIN HAS LIQUID INGRESS INDICATION 30 INCHES FROM INBD AND 16.5 INCHES FROM TRAILING EDGE. DRILLED WITNESS HOLES IN LT ELEVATOR UPPER SKIN 30IN FROM I/B 16 .5IN FROM T/E ZONE A, FOUND NO LIQUID, REPAIRED AREA IAW SRM 55-21-11-300-004 CATESDR CALA2026011613000Frame · puncturedPUNCTURE IN FRAME BS 460 BETWEEN STRINGER 11L AND 12L.SDR CALA2026011612999Test Button · brokenEMER EXIT LIGHTS ILLUM DURING TAKEOFF ILLUM AT BACK HALF OF CABIN FOR 1 MIN THEN OFF FOUND EMERGENCY BATTERY CHARGER POWER SUPPLY M1673 LEFT SIDE PUSH TO TEST BUTTON BROKEN OFF. REPLACED THE POWER SUPPLY IAW AMM 33-51-06-960-806. OPS CHECK OK ON GROUND.SDR CALA2026011612998Battery · dischargedEMEGENCY POWER PACK, M1673, FAILS EMERGENCY LIGHTING FUNCTIONAL CHECK. BATTERY DISCHARGES IN LESS THAN 10 MINS. REMOVED AND INSTALLED EMERGENCY POWER PACK M1673 IAW IAW AMM 33-51-06-960-802.SDR CALA2026011612997Shim · migratedVERTICAL STAB LE SIDE INBD REAR SPAR FITTING VSS 1088 HAS A MIGRATING SHIM FROM BETWEEN THE BULKHEAD FITTING AND THE SPAR FITTING. REMOVED MIGRATED LAMINATED SHIMS AND REPLACED WITH SOLID SHIMS IAW DWG 170A1610, REV G, AND IAW AMM 55-30-00.SDR CALA2026011612996Lamp · inoperativeEMERGENCY LIGHTS, OPS TEST WITH THE TEST SWITCHE PROCEDURE. R1 SLIDE LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-51-04-960-801, OPS CHKD GOOD.SDR CALA2026011612995Lamp · inoperativeEMERGENCY LIGHTS, OPS TEST WITH THE TEST SWITCHES PROCEDURE. FWD MID GALLEY CEILING EMERGENCY AREA LIGHT INOPERATIVE, REPLACED THE LAMPS IAW AMM 33-51-03-960-801, OP CHKD GOOD.SDR CALA2026011612994Battery · dischargedCABIN EMERGENCY LIGHT FOUND INOP ON DOOR 3 ATTENDANT CREW REST CLOSET REF HAECO NON-ROUTINE 9493192, SUPPORT TASK. BATTERY LOW VOLTAGE, REPLACED THE POWER SUPPLY (M33099) BATTERY AND BATTERY CHARGER, THEN CARRIED OUT INSTALLATION TEST AND OPERATIONAL TEST, THSDR 2026FA0000026Transmitter · defectivePILOTS RETURNED FROM THEIR FLIGHT WITH A SQUAWK DETAILING THAT FUEL PRESSURE INDICATOR BEGAN DISPLAYING A NULL VALUE. THIS WAS DUE TO A PREMATURE FAILURE OF THE UMA FUEL PRESSURE SENDER, P/N T1EU100D, S/N B0197, IN THE RIGHT NACELLE. IT ONLY LASTED 103 HOURS OSDR GTIA2026011539248Elec Connector · looseEPSU SYSTEM TEST PRODUCES MULTIPLE FAULTS. FOUND CONNECTOR LOOSE AT 10WL IAW AMM 33-51-02 P0151, TSM 33-51-00-810-A AND AMM 33-51-38-400-001-A PARA 4, STEP 78. OPS CHECKED GOOD IAW AMM 33-51-00-710-001-A.SDR EE4Y2026150123774Frame · crackedDURING THE ALLEGIANT TASK CARD A32X-53-260-004 INSPECTION, CRACK WAS FOUND ON FR 68, STOP NR1 FRAME INBD LOWER FASTENER HOLE. THIS DISCREPANCIE WAS REPORTED TO AIB AND REPAIRED UNDER AIRBUS DOCUMENT 81709985/036 AND PER COOPESA EO COO-EO-2025-23646-R02. JOB A1SDR EE4Y2026150123773Frame · crackedDURING THE ALLEGIANT TASK CARD A32X-53-260-004 INSPECTION, CRACK WAS FOUND ON FR68, STRINGER 22L FRAME WEB HORIZONTAL FLANGE RADII. THIS DISCREPANCIE WAS REPORTED TO AIB AND REPAIRED UNDER AIRBUS DOCUMENT 81709985/036 AND PER COOPESA EO COO-EO-2025-23646-R02.SDR GTIA2026011539247Bottle · low pressureL1 AND L2 DOOR ASSIST BOTTLES REQUIRE SERVICE. SERVICED L1 AND L2 DOOR ASSIST BOTTLE IAW AMM 52-10-00. LEAK AND OPS CHK NORMALSDR AALA202601152236Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FUSELAGE SKIN, AT ELECTRICAL GROUND POWER RECEPTACLE DOOR LOWER CUTOUT SURROUND DOUBLER BETWEEN BS 224.8 AND BS 235.8, BETWEEN S21R AND S22R. REPAIRED SKIN PER SRM 53-10-15-2R-4.SDR AALA202601158362Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FUSELAGE SKIN, AT ELECTRICAL GROUND POWER RECEPTACLE DOOR LOWER CUTOUT SURROUND DOUBLER AT BS 224, S20R. REPAIRED SKIN PER SRM 53-10-15-2R-4.SDR AALA202601154448Megaphone · no testAIRCRAFT WAS NOT GROUNDED: AFT MEGAPHONE REQUIRES REPLACEMENT. REMOVE AND REPLACED AFT MEGAPHONE. PER W/C 08C20025010.SDR REXA2026011500004Beam · crackedDURING MAINTENANCE TO LT HYDRAULIC BAY SKIN, CRACKED LT NLG DOOR BEAM AT LBL 13.40. REPLACED BEAM PER APPLICABLE SRM STANDARD PRACTICES AND DRAWINGS, BEAM IS FCBS & WAS DOCUMENTED AS A MAJOR REPAIR.SDR REXA2026011500003Skin · crackedA CRACK WAS FOUND ON LEFT HYDRAULIC BAY SKIN AT TRU DOOR CORNER IAW EA CRJ953-19108. REPLACED SKIN PER APPLICABLE SRM AND DRAWINGS. SKIN WAS DEEMED FCBS AND WAS DOCUMENTED AS A MAJOR REPAIR.SDR JR2R20260115233Skin · chafedAFT LOWER FUSELAGE AT MID AVIONICS BAY DOOR SURROUND STRUCTURE UPPER FWD CORNER SKIN DOUBLER IS CHAFED. REPAIRED PER ETD.SDR JR2R20260115232Skin · chafedAFT LOWER FUSELAGE AT MID AVIONICS BAY DOOR SURROUND STRUCTURE UPPER AFT CORNER SKIN DOUBLER IS CHAFED. REPAIRED PER ETD.SDR JR2R20260115029Skin · corrodedAFT CARGO SCUFF PLATE AREA EXTERNAL SKIN IS CORRODED IN MULTIPLE AREAS. REPAIRED PER ETD.SDR JR2R20260115021Skin · corrodedFWD CARGO SCUFF PLATE AREA EXTERNAL SKIN IS CORRODED IN MULTIPLE AREAS. REPAIRED PER ETD.SDR JR2R20260115368Retainer · corrodedL/H I/B MAIN FLAP TORQ TUBE RETAINER ASSY IS CORRODED. REPAIRED PER ETD.SDR JR2R20260115370Retainer · corrodedR/H I/B MAIN FLAP TORQ TUBE RETAINER ASSY IS CORRODED. REPAIRED PER ETD.SDR IPXA2026011513640Unknown · odorAT APPLICATION OF TAKEOFF POWER AND DURING CLIMB-OUT, THE STRONG ODOR OF DIRTY WET SOCK EXISTED. THE SMELL LESSENED A BIT DURING CRUISE BUT WAS STILL NOTABLY PRESENT FOR THE REMAINDER OF THE FLIGHT. AT SDF MGMT REQUEST, OPERATED LEFT AND RIGHT AIR PACKS FOR APSDR EE4Y2026150123772Frame · crackedDURING THE ALLEGIANT TASK CARD A32X-53-260-005 / TASK CARD A32X-53-260-003 INSPECTION RELATED TO AD 2022-15-05 AND A320-53-1491 REV 01 IN THE UPPER FUSELAGE PASSENGER CABIN AREA, CRACK WAS FOUND AT FR68 / STOP FITTING #1. (INBD LOWER HOLE) LOCATION AND WAS REPSDR JR2R20260115006Beam · corrodedBEAM LBL11 CORRODED BETWEEN FR12 THRU FR16. REPLACEDSDR FDEA202601150045Repair · no discrepancyEXISTING REPAIR ON FWD CARGO DOOR INNER SKIN FR 23A-24A BETWEEN BEAM 1 AND BEAM 2 REQUIRES EVALUATION FOR CONFORMITY. THE EXISTING REPAIR ON FWD CARGO DOOR INNER SKIN FR23A - FR24A BETWEEN BEAM 1 AND BEAM 2 WAS EVALUATED AND FOUND IN CONFORMITY WITH EA 6-SDR JR2R20260115753Skin · dentedDENT AT LOWER AFT FUSELAGE SKIN FR 89 - 90 STR 26L-27L. REPAIRED PER ETD.SDR JR2R20260115009Mount · corrodedFLOOR MOUNT ANGLE ON BEAM 16 AT RBL28 CORRODED. REPLACEDSDR JR2R20260115007Beam · corrodedBEAM RBL11 CORRODED BETWEEN FR12 THRU FR17. REPLACEDSDR EE4Y2026150123769Skin · corrodedCORROSION DAMAGE AFFECTING THE CENTER FUSELAGE II SKIN INNER FACE,LOCATED IN THE S29L LOCATION, AT FR73+235MM. VERIFIED BLEND OUT WITH CLAD LAYERPENETRATED AND FOUND OUT OF LIMITS IAW PART II SRM 53-22-01, AD51, PARAG. 5A (2),TABLE 102, FIG. 104 SHEET 2. THE CSDR 2026FA0000025Bracket · misinstalledACCORDING TO INSTALLATION 371-53-00-C4178-003 SHOP REQ TO REMOVE AND REPLACE TWO EXISTING BRACKETS.HOWEVER INSTALLATION OF FITTINGS WILL RESULT IN SHORT EDGE MARGIN.BRACKETS ARE DIFFRENT THAN WHAT ITS SHOULD BE PER DWG 145T8722. IN ADDITION THE FOUR FASTNERSDR SWIA2026011477083Floorbeam · crackedINSIDE CABIN RIGHT HAND SIDE F.S. 559.00 RBL18 TEE CAP CRACKED (C-CHECK RO 08/31/2026)REPAIRED TCAP AT FS 559.00 RBL18 IAW REO 601R-53-41-3384, REV --, DATE 2026-01-23. RESTORED SURFACE FINISH IAW CRJ200 SRM 51-25-16.SDR SWIA2026011475864Skin · chafedLEFT INBD FLAP VANE LEADING EDGE CHAFED IN MULTIPLE SPOTS. REPAIRED LT INBD FLAP VANE LEADING EDGE INBD PANEL AT BLENDED AREA 1 THAT WAS FOUND TO BE IN LIMITS REF REO 601R-57-52-004 REV.D DATE:2012-12-19. STEPS 1 TO 3. BLENDED AREAS #2 AND #3 ON (MID PANEL & SDR SWIA2026011475657Skin · corrodedUPON REMOVAL OF RAD ALT ANTENNA (E19) , FOUND CORROSION ON INTERNAL SKIN BETWEEN FS 1031 - FS 1047. CUT AWAY IDENTIFIED AREA OF FUSELAGE SKIN, FABRICATED NEW DOUBLER AND INSTALLED AT FS 1031-FS1047 UNDER RAD ALT ANTENNA BETWEEN STGR27 AND 26L IAW REO 670-53-6SDR SWIA2026011475643Intercostal · crackedPAX DOOR AFT INTERCOSTAL DD1 FOUND BE CRACKED REQUIRE REPLACEMENT. REMOVED UNSERVICEABLE PAX DOOR AFT INTERCOSTAL DD1 IAW SRM 51-42-06-001-001-A01. LOCATED AND DRILLED NEW SERVICEABLE PAX DOOR AFT INTERCOSTAL DD1 IAW SRM 51-40-11-001-001-A01. INSTALLED NEW SSDR SWIA2026040375632Former · corrodedPAX DOOR FWD FORMER FS.320 FOUND BE CORRODED REQUIRE REPLACEMENT. REMOVED AND REPLACED PAX DOOR FORMER BS 320 IAW SRM 51-42-06-001-001-A01 AND REO 670-52-11-1555 REV -.SDR HYIA20260327004Engine · making metalPILOT REPORTED LEFT ENGINE LOW OIL PRESSURE, WHICH DROPPED INTO THE RED DURING LANDING. MAINTENANCE INSPECTED AND FOUND METAL CONTAMINATION IN THE LEFT ENGINE AND OIL POOLING IN 5 OUR OF 6 CYLINDERS. THE ENGINE WAS REPLACED WITH NO FURTHER DEFECTS NOTED.SDR SWIA2026030975463Stringer · corrodedSTR 24R BETWEEN FS985 AND FS1000 HAS CORROSION. (C-CHECK RO 03/07/2026)PERFORMED PERMANENT REPAIR ON STGR 24R BETWEEN FS985 AND FS1000, REF. CRJ550 SRM 53-00-03-201-001-A01, CRJ550 SRM 51-42-06-001-001-A01, CRJ550 SRM 51-42-21-001-001-A01 REV. 38 - JUL 25/20SDR SWIA2026030975456Bulkhead · corrodedANGLE SUPPORT ON THE FWD SIDE OF THE FS280.00 BULKHEAD IS CORRODED FROM BL9L - BL9R. (C-CHECK RO 03/07/2026)REMOVED AND INSTALLED NEW ANGLE SUPPORT ON THE FWD SIDE OF THE FS280.00 BULKHEAD BETWEEN LBL9 - RBL9 REF. DWG CC670-33052 REV. -G, DWG CC670-34010 REV.SDR IPXA2026011406798Warning Light · inoperativeON PREFLIGHT, L1 RED WARNING LIGHT DOES NOT ILLUMINATE WHEN TESTED. BUZZER DOES SOUND. FOUND ASPSU WITH RED LIGHT DISPLAYED ON UNIT POSITION. REMOVED AND REPLACED APSU 70WN AND OPERATION CHECKS GOOD IAW AMM 52-73-18/401. THIS CLEARS DMI, PLACARD REMOVED. NO DMSDR VNAA20260303008Tube · corrodedCORROSION ON DOOR SILL, BS 310 - 349 AND TUBE ASSY OF ELECTRICAL HARNESS ON BS 322.15 AT LOWER SUROUND STRUCTURE PASSENGER DOOR CUT-OUT. CORROSION REMOVED IAW SRM 51-21-06-001-001-A01 AND THE DOOR SILL WAS EVALUATED WITHIN LIMITS & THE TUBE ASSY WAS EVALUATED