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 I5PA2025090519301Switch · faultyRIGHT TURB OVHR DET 1 STATUS MSG. R & R RT ENG OVHT DET 1 SWITCH PER AMM, OPS CHECK NORMAL.SDR VNAA2025090711101Manifold · unserviceableSTEERING INOP UPON TAKE OFF. FAULT HAPPENED UPON GEAR UP. / REPLACED STEERING MANIFOLD IAW AMM 32-51-50-400-801-A01. NO LEAK NOTED. BITE AND OPS TEST GOOD AT THIS TIME.SDR DALA2025090506582Floor Panel · damagedFWD CARGO FLOOR PANEL FOUND DAMAGED. COMPLIED WITH ER/A 587849-14TR. (7781763).SDR SIMA20250905002Tire · failedTIRE TREAD SEPARATION ON LANDING RESULTING IN FLAP DAMAGE. UPON LANDING GROUND SPOILERS FAIL, FLT CTRL NO DISPATCH, LG NO DISPATCH, HYD 2 LO QTY (2%) POSTED. DURING POST FLIGHT FOUND SIGNIFICANT DAMAGE DUE TO TIRE RETREAD DEPARTING TIRE. RAR #3 WHEEL ASSY IAW SDR DALA2025090506574Wedge · missingINBOARD LEADING EDGE SLAT TRAILING WEDGE MISSING APPROX 18 BY 10 INCH SECTION. REMOVED NR 6 LEADING EDGE SLAT IAW AMDS W/C 2781-4128-01(398826) INSTALLED NR 6 L/E SLAT IAW AMDS 2781-4128-01. (6525784)SDR DALA2025090506573Sign · damagedOVERHEAD EXIT SIGN AT ROW 37 DAMAGED. R & R AISLE OVERHEAD EMERGENCY EXIT SIGN AT ROW 37 PER AMM 33 -51 OPS TEST OK. (7873326)SDR IPXA2025090523303Fire Detector · faultedENG 3 FIRE INDICATION FOR 20-30 SEC, WENT OUT. DIVERTED TO HKG, REPLACED NR 3 ENG LOWER AFT FIRE LOOP ASSY (TS682) IAW AMM 26-11-02/401 AND PERFORMED FIRE SYSTEM GROUND TEST IAW AMM 26-11-00/501 RESULT PASS.SDR YENA2025090500915Unknown · odorFLT#323, JFK-LAX. "STRONG "DIRTY SOCK" SMELL ON FLIGHT DECK ON DESCENT FROM 10,000' TO THE GROUND. SMELLED ON FLIGHT DECK ONLY. ( APU SYSTEM )" (SUPPLEMENTAL INFORMATION TO FOLLOW)SDR QR9R2025090500002Sensor · fluctuatesGEN AMP SPLIT GREATER THAN TEN AMPS (#1 GEN). AMPS FLUCTUATED BETWEEN 5-25 AMP DIFFERENCE. REMOVED AND REPLACED #1 HALL SENSOR IAW AMM 24-30-00, 4-6.SDR QR9R2025090500001Windshield Wiper · failedON THE GROUND WITH AIRCRAFT AT 100% FLIGHT IN A LIGHT RAIN, TURNED WINDSHIELD WIPER ON TO THE LOW SETTING. APPROXIMATELY 5 MINUTES LATER HEARD A LOUD POP NOISE AND THE WINDSHIELD WIPERS IMMEDIATELY STOPPED WORKING AT THE FULL EXTENDED POSITION. DURING ENGINE SSDR SIMA20250905001Flashlight Assy · inoperativeFA 2 EMERGENCY FLASHLIGHT INOP RAR AFT FA EMERGENCY FLASHLIGHT ASSEMBLY IAW AMM 33-51-01. OPS CHECK GOOD.SDR FDEA202509051624Skin · misrepairedEXISTING REPAIR ON FUSELAGE SKIN BETWEEN FR19-FR20A STGR37R-STGR39R REQUIRES EVALUATION FOR CONFORMITY. THE EXISTING REPAIR ON FUSELAGE SKIN BETWEEN FR19-FR20A STGR37R-STGR39R WAS EVALUATED AND FOUND DID NOT CONFORM TO SRM 53-13-12-201 FIG201, RE-REPAIRED SDR FDEA202509051623Repair · not reportedEXISTING REPAIR ON MAIN DECK SEAT TRACK AT -Y953 BETWEEN FR36 AND FR38.2 REQUIRES EVALUATION FOR CONFORMITY. THE EXISITNG REPAIR ON MAIN DECK SEAT TRACK AT -Y953 BETWEEN FR36 AND FR 38.2 WAS EVALUATED AND FOUND IN CONFORMITY WITH A300-600F SRM 53-10-16-201SDR FDEA202509051622Skin · dentedRIGHT WING OB FLAP LWR SURFACE FOUND DENT AT 248 INCHES TO IB EDGE AND 6 INCHES TO AFT EDGE. REPAIRED RH WING OB FLAP LWR SURFACE DENT AT OTEF STA 261 AS PER B777 SRM 57-53-01-2R- 2 AND SRM 51-70-04-2R-1 REV 47.6 AND EA: G-5750-T0384798 P1. TITLE: WING-FLSDR FDEA202509051621Door · crackedMAIN DECK CARGO DOOR UPR EDGE AT PT1 BETWEEN FR23 AND FR24 FOUND CRACK SIGNAL ON 3EA FASTENER HOLES COMPLIED WITH EA: 6-5230-T0384815 P1. TITLE: DOORS - CARGO DOOR/HYD SYS - CRACKED HOLES ON MAIN DECK CARGO DOOR UPPER LONGERON. REPAIRED THE MAIN DECK CARGOSDR CALA2025090508496Sealant · deterioratedWHILE PRESSURIZING AIRCRAFT TO LEAK CHECK CAPT WINDSHIELD FOUND 3 LOCATIONS LEAKING. STARTED TO REMOVE SEALANT AND REMOVED WINSHIELD WIPER. SEALANT DID NOT APPEAR TO BE FULLY CURED HAD A CRUMBLY TEXTURE AND SMELLED UNCURED. REMOVED OLD SEALANT, RETORQUED AND RSDR SCNA20250905360Threshold · unsecureFWD GALLEY FLOOR RUBBER FLOOR TRIM IS RIPPED UP AND A TRIPPING HAZARD. REMOVED AND REPLACED THE CARPET TO MAT THRESHOLD IAW AMM 25-27-21.SDR SWIA202512120904Web · corrodedLEFT COCKPIT LOWER WEB CORRODED AT BOTTOM NEXT TO FLOOR. PERFORMED REPAIR ON LT COCKPIT LOWER WEB AT THE BOTTOM NEXT TO THE FLOOR IAW REO 670-53-11-594 REV.-A. AND AMM 20-70-00, SRM 51-42-06, AND SRM 51-25-16. PERFORMED NDT INSPECTION. COMPLETE INSTALLATISDR SWIA202512090004Intercostal · corrodedTHE INTERCOSTAL BELOW THE SERVICE DOOR AT S20R BETWEEN BS 319 & 349 CORRODED IN MULTIPLE LOCATIONS. REMOVED INTERCOSTAL IAW SRM 51-42-06-001-001-A01 & SRM 51-42-21-001-001-A01. INSTALLED A NEW INTERCOSTAL IAW SRM 51-42-06-001-001-A01, SRM 51-42-21-001-001-A0SDR SWIA202512020904Window Frame · crackedPILOT WINDSHIELD LT AFT LOWER SIDE POST FITTING HAS A POSSIBLE CRACK. REMOVED AND REPLACED THE LOWER SIDE POST FITTING IAW SRM 51-42-21-001-001-A01, REV 38, AND DWG CC670-33055, REV F.SDR AALA202512025053Fitting · wornAIRCRAFT IN BASE MAINTENANCE: AFT AVIONICS COMPARTMENT RACK 80VU LEFT HAND LATERAL FITTING WORN AT FR 24 AND S32R. REPLACED LEFT HAND LATERAL FITTING PER EA 367831.SDR AALA202512022112Fork · noneAIRCRAFT IN BASE MAINTENANCE: DUE TO THE MAJOR REPAIR BEING ACCOMPLISHED ON THE AFT AVIONIC COMPARTMENT RACK 80VU LEFT HAND LATERAL FITTING PER EA 367831, THE LEFT-HAND FORK END BETWEEN FR 23 AND FR 24 AT +Y1263 NEEDS TO BE REPLACED PER THE INSTRUCTIONS OUTLINSDR AALA202512029690Fork · noneAIRCRAFT IN BASE MAINTENANCE: DUE TO THE MAJOR REPAIR BEING ACCOMPLISHED ON THE AFT AVIONIC COMPARTMENT RACK 80VU RIGHT HAND LATERAL FITTING PER EA 367831, THE RIGHT-HAND FORK END BETWEEN FR 23 AND FR 24 AT -Y1263 NEEDS TO BE REPLACED PER THE INSTRUCTIONS OUTLSDR AALA202512021294Fitting · wornAIRCRAFT IN BASE MAINTENANCE: AFT AVIONIC COMPARTMENT RACK 80VU RIGHT HAND LATERAL FITTING WORN AT FR 24 AND S32R. REPLACED RIGHT HAND LATERAL FITTING PER EA 367831.SDR VNAA202511260006Panel · corrodedCORROSION ON THE MATING SURFACE OF THE PANEL ASSEMBLY FROM SS15.50 TO SS39.00 (ACCESS 621AB), AS WELL AS CORROSION ON MATING SURFACE OF LOWER EDGE OF ACCESS 621AT, RIGHT WING. CORROSION ON THE MATING SURFACE OF THE PANEL ASSEMBLY FROM SS15.50 TO SS39.00 (ACCESSDR VNAA202511250008Landing · corrodedCORROSION ON SETTLEMENT AREA OF ACCESS PANEL 521AT AT LH WING. SETTLEMENT AREA OF ACCESS PANEL 521AT AT LT WING (LT SIDE FRAME HOUSING LANDING P/N: CC670-12111-5) WAS EVALUATED OUT OF LIMITS PER SRM 57-41-01-101-001-A01 REPLACED PER CRJ900 SRM 51-42-06-001-0SDR VNAA202511250006Intercostal · corrodedCRACK ON INTERCOSTAL BTW FS173 TO FS179 AND WL79.50 INTERNAL STRUCTURE AT FWD EQUIPMENT COMPARTMENT. INTERCOSTAL BTW FS173 TO FS179 AND WL79.50 INTERNAL STRUCTURE AT FWD EQUIPMENT COMPARTMENT WAS REPLACED PER SRM 51-42-10-001-001-A01, SRM 51-42-06-001-001-A0SDR VNAA202511250005Web · crackedCRACK ON WEB BTW FS195 TO FS205 AND WL79.50 INTERNAL STRUCTURE AT FWD EQUIPMENT COMPARTMENT. WEB BTW FS195 TO FS205 AND WL79.50 INTERNAL STRUCTURE AT FWD EQUIPMENT COMPARTMENT WAS REPAIRED PER CRJ-900 SRM 53-11-43-201-001-A01.SDR AALA202511192809Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION FOUND ON FASTENER HOLE (AFT-LOWER POSITION) LOCATED O N FR35 AT LEVEL OF STR30 RH SIDE, LOWER FUSELAGE. CRACK DEPTH = 0.108 INCHES APPROX, CRACK POSITION: 25 AND 8 OCLOCK LOOKING FROM OUTSIDE. MAINTENANCE ACCOMSDR AALA202511188310Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION FOUND ON FASTENER HOLE (AFT-LOWER POSITION) LOCATED ON FR35 AT LEVEL OF STR30 LH SIDE, LOWER FUSELAGE. CRACK DEPTH = 0.100 INCHES APPROX, CRACK POSITION: 11 OCLOCK LOOKING FROM OUTSIDE. MAINTENANCE PERFORMED TIMESDR AALA202511134271Skin Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT WING TOP SKIN PANEL LOWER SURFACE AT RIB 14. REPAIRED SKIN PANEL PER EA 368862.SDR AALA202511134227Pressure Deck · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CENTER FUSELAGE PRESSURE DECK MEMEBRANE OPEN HOLES AT FR 36 AND +Y1292. REPAIRED PRESSURE DECK MEMBRANE PER EA 367850SDR AALA202511134581Pressure Deck · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CENTER FUSELAGE PRESSURE DECK MEMEBRANE OPEN HOLES AT FR 36 AND -Y1292. REPAIRED PRESSURE DECK MEMBRANE PER EA 367850SDR AALA202511138861Hinge Pin · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT WING AILERON #2 HINGE PIN BETWEEN WS 12277 AND WS 12879, BETWEEN RIB 23 AND RIB 24. REPLACED HINGE PIN PER SRM 57-00-00-801.SDR CALA2025111011069Door Sill · corrodedMAIN CABIN R2 LOWR INNER DOOR SILL CORRODED ON UPPER SURFACE REMOVED CORROSION, AND FOUND TO BE OUT LIMITS IAW SRM 51-10- 02, LOCATED, DRILLED AND INSTALLED A NEW INNER DOOR SILL IAW SRM 51-40-02 AND DWG 124A8501, REV T.SDR AALA202510280456Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION STRINGER 43L BTW FR 56 AND FR 57 IN AFT CARGO COMPARTMENT MEASURE OF CORROSION AREA L= 8.191 IN, W= 0.848 IN, D= 0.003 IN. MAINTENANCE PERFORMED PERMANENT REPAIR (SPLICE REPAIR) ON STRINGER 43L BTW FR55 TO FR58 IN AFT CSDR SWAA2025101411546Floorbeam · crackedCRACK BRAKE PANEL FLOOR STRUCTURE BS 540 AND LBL 2 AT PASSENGER CABIN. REPLACED BRAKE PANEL AND FASTENERS LOCATED FLOOR STRUCTURE LOCATED STA 540 AND BTW BL O TO LBL 24.75 AT PASSENGER CABIN IAW SRM 51-40-02 AND DWG 143A0060 SHEET 46 REV.SDR SWAA2025101411547Floorbeam · crackedCRACK BRAKE PANEL FLOOR STRUCTURE BS 540 AND RBL 2 AT PASSENGER CABIN. REPLACED BRAKE PANEL FLOOR STRUCTURE BS 540 AND RBL 2 AT PASSENGER CABIN IAW B737-700 SRM51-10-02 ITEM 9 AND SRM 51-40-02 AND DWG: 143A0060 SHEET: 46 REV: -.SDR CALA2025101309985Skin · crackedCRACK FOUND AT LEFT HORIZONTAL STABILIZER LOWER SKIN AT STAB. STA 175.50 , 10" FROM REAR SPAR,I/B ROW. CRACK LENGTH : 0.281" ESFR SUBMITTED ACCOMPLISHED REPAIR ON LOWER INSPAR SKIN STA175.50 AT LH HORIZ. STAB. REF SRM 55-10-01-2R-11 & DWG 182A4001 AND REQUIRESSDR CALA2025101309984Bulkhead Web · crackedCRACK FOUND AT VERTICAL PRESSURE WEB BETWEEN RBL40 AND RBL45.64. CRACK LENGTH: 0.656". REF. AAR N/R:99950519. REMOVED DAMAGE SECTION AND INSTALLED VERTICAL PRESSURE WEB WEB REPAIR AT BS 663 BETWEEN RBL 25 TO RBL 47 IAW SRM 57 10-10-2R-3, REPAIR 3. PERFORM SDR AALA202510109990Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED AFT CABIN FLOOR SHEAR PLATE BETWEEN FR 69 AND FR 70 AT S23R. REPLACED SHEAR PLATE PER SRM 51-42-11.SDR AALA202510085721Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED AFT CABIN FLOOR SHEAR PLATE BETWEEN FR 69 AND FR 70 AT S23L. REPLACED SHEAR PLATE PER SRM 51-42-11.SDR JJBA20251008021Channel · corrodedCFI, SERVICE DOOR CUT OUT, LOWER CHANNEL BTW FR 20-22 FOUND CORRODED. AT CF1 SERVICE DOOR CUT OUT, LOWER CHANNEL BTW FR 20-22, CHANNEL CORRODED OUT OF LIMIT. CF1 SERVICE DOOR CUT OUT LOWER CHANNEL BTW FR 20-22 REMOVED AND REPLACED.SDR ASAA2025090461415Stub Beam · gougedR-2 DOOR, HANDLE BOX CUTOUT, LOWER TORQUE TUBE BEARING AREA IS GOUGED. GROUNDED - YES. REMOVED DAMAGED STUB BEAM REFERENCE B737-900 SRM 51-40-02, FABRICATED NEW STUB BEAM REFERENCE BAC DWG#147A6149 REV D, APPLIED CAA TO STUB BEAM BY OUTISDE VEDNOR IAW BAC5019,SDR AALA202510077100Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT BS 948, LBL 25. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202510074825Rail · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT AFT BULKHEAD LOWER LOBE RAIL ASSEMBLY AT BS 500I, FROM S25L TO S25R. REPLACED RAIL ASSEMBLY PER SRM 51-40-02.SDR SWAA2025100611313Nut Plate · corrodedCORROSION ON RAIL NUT-PLATE LOCATED OFSS 573 INTERNAL CAVITY LEADING EDGE AT LT WING. REPLACED RAIL NUT-PLATE LOCATED OFSS 573 INTERNAL CAVITY LEADING EDGE AT LT WING IAW IAW SRM 51-40-02 AND DRAWING 112A4402 REV:A.SDR SWAA2025100611321Nut Plate · corrodedCORROSION ON RAIL NUT-PLATE LOCATED OFSS 632 INTERNAL CAVITY LEADING EDGE AT LT WING REPLACED RAIL NUT-PLATE LOCATED OFSS 632 INTERNAL CAVITY LEADING EDGE AT LT WING IAW B737-800 SRM 51-40-02 ; SRM 51-10-02 ITEM 9 AND DWG 112A4402 SHEET:40 REV:A.SDR SWAA2025100611323Nut Plate · corrodedCORROSION ON RAIL NUT-PLATE LOCATED OFSS 573 INTERNAL CAVITY LEADING EDGE AT LT WING. REPLACED RAIL NUT-PLATE LOCATED OFSS 573 INTERNAL CAVITY LEADING EDGE AT LT WING IAW SRM 51-40-02; SRM 51-10-02 ITEM 9 AND DWG 112A4402 SHEET 40 REV A.SDR SWAA2025100611563Nut Plate · corrodedCORROSION ON RAIL NUT-PLATE LOCATED OFSS 491 INTERNAL CAVITY LEADING EDGE RT WING. REPLACED RAIL NUT-PLATE LOCATED OFSS 491 INTERNAL CAVITY LEADING EDGE AT RT WING AND APPLIED PROTECTIVE TREATMENT ON FASTENERS. IAW B737-800 SRM 51-40-02; SRM 51-10-02 ITEM 8;