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 DALA2025091206728Floor Panel · delaminatedDELAMINATED FLOOR PANEL 222EF TA FWD GALLEY AREA. COMPLIED WITH ER/A 628477-14. (1194617).SDR DALA2025091206727Skin · wornWEAR ON EXTERNAL SKIN UPPER CUT OUT ON PASSENGER CREW DOOR R/H LOC. FR 66 TO FR 68 IN PASSENGER CABIN. COMPLIED WITH ER/A 628845-14. (1194664).SDR DALA2025091206726Support · corrodedCORROSION ON FITTING SUPPORT THE SPHERICAL BEARING TRACK 3 0/B FLAP RT WING. COMPLIED WITH ER/A 628388-14. (1194658).SDR DALA2025091206725Support Fitting · corrodedCORROSION ON FITTING SUPPORT THE SPHERICAL BEARING TRACK 3 O/B FLAP LH WING. COMPLIED WITH ER/A 628387-14. (1194652).SDR FDEA202509121696Floorbeam · crackedCRACK FOUND IN FLOOR BEAM UPPER CAP LOWER SURFACE AT STA 580 @ LBL 45.5. INSIDE RADIUS AREA REPAIR ON FLOOR BEAM AFT UPPER FLANGE. STA 580. AND LBL 45 WAS PERFORMED I.A.W. FEDEX E.A. # F-5310-T0384885 P1. REV-.SDR FDEA202509121695Skin · puncturedLEFT ELEVATOR UPPER SURFACE HAS A SMALL HOLE AT PROXIMATELY 150" FROM THE INBOARD SIDE OF ELEVATOR, 37" FWD OF TRAILING EDGE AND 20" AFT OF LEADING EDGE. REPAIRED LH ELEVATOR UPPER SURFACE A SMALL HOLE AS PER B777 SRM 55-20-01-2R-1 AND SRM 51-70-04-2R-1 ASDR FDEA202509121694Skin · crackedNUMBER 5 SLAT EXTERNAL SKIN FROM OB TO IB 50 INCHES CROSS TE TO LE 19 INCHES FOUND CRACKED. NR 5 SLAT EXTERNAL SKIN FROM OB TO IB 50 INCHES CROSS TE TO LE 19 INCHES REPAIRED IAW SRM 57-43-01-2R-9 FIGURE 202 REV 47.6 AND EA G-5750-T0384896 P1 ,TITLE:WING - FLISDR FDEA202509121693Skin · crackedNUMBER 5 SLAT EXTERNAL SKIN FROM OB TO IB 49 INCHES CROSS TE TO LE 12.5 INCHES FOUND CRACK. NO.5 SLAT EXTERNAL SKIN FROM OB TO IB 49" CROSS TE TO LE 12.5" REPAIRED AS PER B777 SRM 57-43-01-2R-9 FIGURE 202 REV 47.6 AND EA G-5750-T0384896 P1 ,TITLE:WING - SDR FDEA202509121691Skin · crackedNUMBER 5 SLAT EXTERNAL SKIN FROM OB TO IB 54 INCHES CROSS TE TO LE 19 INCHES FOUND CRACK. NO.5 SLAT EXTERNAL SKIN FROM OB TO IB 54" CROSS TE TO LE 19" REPAIRED AS PER B777 SRM 57- 43-01-2R-9 FIGURE 202 REV 47.6 AND EA G-5750-T0384896 P1 ,TITLE:WING - FLISDR FDEA202509121689Web · crackedAGING AIRCRAFT - EXISTING REPAIR AT COCKPIT FLOOR WEB OBSERVER SEAT AREA STATION 360 X = -13.250 RIGHT HAND SIDE. EXISTING REPAIR AT COCKPIT FLOOR WEB OBSERVER SEAT AREA STATION 360 X =-13.250 RIGHT HAND SIDE EVALUATED AND FOUND WITH CRACK LENGTH AT EDGE OSDR 2025FA0000640Distribution Box · faultedWHILE EN ROUTE TO KADS FROM KHPN AT 45,000 FEET, APPROXIMATELY 1.5 HOURS INTO OUR FLIGHT, THE BATT 2 DISCHARGING CAS MESSAGE ILLUMINATED. THE EMER BUS 2 WAS POWERED BY BATT 2 ONLY, THE AUTOMATIC BUS POWER TRANSFER FAILED CAUSING A CASCADE OF SYSTEMS TO FAIL. ASDR KCSA202509121153Tension Tie · crackedFOUND CRACK IN TENSION TIE AT STA 1180 R/H SIDESDR KCSA202509121152Wire · damagedUPPER DECK EXIT SIGN AT STA 690-CENTER INOPSDR AALA202509125567Power Supply · no testAIRCRAFT WAS NOT GROUNDED: WHILE PERFORMING JC 26L00025010 GOT EPSU BATTERY AFT L DURING OPERATION TEST OF EMERGENCY LIGHTING SYSTEM. MAINTENANCE REPLACED AFT L EPSU IAW AMM 33-51-38.SDR KCSA202509121151Light · inoperativeEMERGENCY LIGHT AT STA 587 INOPERATIVE.SDR DALA2025091206722Frame · damagedCABIN FRAME C61-SIGNIFICANT TOOLING DAMAGE TO THE EDGE. REPLACED PER A330 SRM 53-11. OK FOR SERVICE. (1195270)SDR NACA2025091100004Linkage · corrodedOUTFLOW VALVE DRIVE LINKAGE CORRODED. R & R THE LINKAGE ON OUTFLOW VALVE IAW AMM 20-11-00-993-809.SDR SWI2025F01905Fitting · crackedTHE RT AFT EMERGENCY DOOR UPPER AFT PROX SENSOR FITTING IS CRACKED. REPAIRED THE CRACKED UPPER PROX SENSOR FITTING ON THE RT AFT EMER DOOR PER REO 670-52-21-103 REV -. ALL STEPS OF REO COMPLIED WITH IN THEIR ENTIRETY. SKYCARD 51-900-1002-SKY COMPLIED WITH.SDR SWI2025F01904Fitting · crackedTHE RT FWD EMERGENCY DOOR UPPER PROX SENSOR FITTING IS CRACKED. (C-CHECK RO 12/24/2025)REPAIRED THE CRACKED UPPER PROX SENSOR FITTING ON THE RH FWD EMER DOOR PER MHIRJ REO 670-52-21-103 REV. -- DATED 2024-11-06. ALL STEPS OF REO COMPLIED WITH IN THEIR ENTIRESDR SWI2025F01903Fitting · crackedTHE LEFT FWD EMER DOOR AFT UPPER PROX SENSOR FITTING IS CRACKED. REPAIRED THE CRACKED UPPER PROX SENSOR FITTING ON THE LT FWD EMER DOOR PER REO 670-52-21-103 REV-. ALL STEPS OF REO COMPLIED WITH IN THEIR ENTIRETY. SKYCARD 51-900-1002-SKY COMPLIED WITH.SDR SWI2025F01902Stand Off · crackedRIGHT LWR TRANSCOWL OTBD -A- BRACKET STANDOFF IS CRACKED. REMOVED CRACKED OTBD -A- BRACKET STANDOFF FROM RT LOWER TRANSCOWL AND INSTALLED ONE NEW OTBD -A- BRACKET STANDOFF ON RT LOWER TRANSCOWL IAW GREO 670-54-21-971 REV (-B) 2023-11-28 STEPS 1-3. COMPLIED WISDR SWI2025F01901Stand Off · crackedLEFT UPPER TRANSCOWL OTBD -A- BRACKET STANDOFF CRACKED. REMOVED CRACKED OTBD -A- BRACKET STANDOFF FROM LT UPPER TRANSCOWL AND INSTALLED 1EA NEW OTBD -A- BRACKET STANDOFF ON L/H UPPER TRANSCOWL IAW GREO 670-54-21-971 REV -B, STEPS 1-3. COMPLIED WITH SKY CARDSDR SWI2025F01900Stand Off · crackedLEFT UPPER TRANSCOWL INBD -A- BRACKET STANDOFF IS CRACKED. REMOVED CRACKED INBD -A- BRACKET STANDOFF FROM LT UPPER TRANSCOWL AND INSTALLED 1EA NEW INBD -A- BRACKET STANDOFF ON LT UPPER TRANSCOWL REF. GREO 670-54-21-971 REV -B, STEPS 1-3. COMPLIED WITH SKY CARDSDR SWI2025F01899Floor Support · corrodedMULTIPLE SPOTS OF CORROSION ON RH FLOOR SUPPORT AT RBL 9 APPROX. BS 1070 - 985. REMOVED AND INSTALLED NEW REPLACEMENT RBL 9.0 FLOOR SUPPORT SECTION AND REPAIR PARTS PER SRM 53-00-41-201-001-A03, STEPS 5.B.(8) & (10) - (12) & REO 690-53-61-1686 REV -. STEPS SDR SWI2025F01898Floor Support · corrodedMULTIPLE SPOTS OF CORROSION ON LT FLOOR SUPPORT AT LBL9 APPROX. FS1000 - FS1088. REMOVED AND INSTALLED NEW REPLACEMENT FLOOR SUPPORT SECTION AND REPAIR PARTS IAW SRM 53-00-41-41-201-001-A03 AND SRM 51-42-21-001-001-A01 AND SRM 51-42-06-001-001-A01 AND REO 690SDR SWI2025F01897Strap · corrodedCORROSION ON JOINT STRAP COMMON TO INBD CORNER OF FWD CARGO DOOR SURROUND AND BS 562.36. REPLACED JOINT STRAP ON FWD. CARGO DOOR SURROUND AT BS 562.36 IAW SRM 51-42-27-001-001-A01, & DWG SH670-33750, REV Y. COMPLIED WITH 51-900-1002-SKYSDR SWIA202512260911Floor Support · corrodedMULTIPLE SPOTS OF CORROSION ON LH FLOOR BEAM AT LBL27 APPROX. FS1000 - FS1047. REMOVED AND INSTALLED NEW FLOOR BEAM SECTION AT LBL 27.0 FROM F/S FS 977 TO F/S 1058 IAW CRJ 900 SRM 53-00-41-201-001-A03 AND IAW SRM 51-42-21-001-001-A01AND SRM 51-42-06-001-001-ASDR SWIA202512190911Former · corrodedPAX DOOR MID FORMER, FS329.41 BETWEEN DD5 AND DD6 FOUND TO BE CORRODED REQUIRED REPLACEMENT. REPLACED PAX DOOR MID FORMER AT FS329.41 IAW SRM 51-42-06. COMPLETED TASK CARD 51-900-1003-SKY. REFERENCE CONTINUATION CARD FOR WORK PERFORMED.SDR AALA202511288101Skin Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION INTERNAL SKIN LOCATED BTW FR 54 TO FR 55 AND BTW STRG 42L TO 43L IN AFT CARGO COMPARTMENT L= 2.100 INCH, W= 1.800 INCH. D= 0.002 INCH. MAINTENANCE ACCOMPLISHED TIME LIMITED REPAIR ON INTERNAL SKIN LOCATED BTW FR 54 TO SDR AALA202511289716Skin · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION INTERNAL SKIN LOCATED BTW FR 54 TO FR 55 AND BTW STRG 43L T O STRG 44 IN AFT CARGO COMPARTMENT L= 1.800 INCH, W= 1.500 INCH. D= 0.002 INCH. MAINTENANCE ACCOMPLISHED TIME LIMITED REPAIR ON INTERNAL SKIN LOCATED BTW FR54 SDR NACA2025091100003Bypass Valve · leakingNUMBER 2 ENGINE FUEL BY PASS VALVE LEAKING FUEL. PERFORMED LEAK CHECK OF NR 2 ENGINE FUEL BYPASS VALVE IAW AMM 71-00-00-795-003-N00. NO LEAKS NOTED, LEAK CHECKED GOOD. ENGINE IDLE AND MPA RUNS WERE PERFORMED AS PART OF LEAK CHECKED ATTACHMENT.SDR AALA202511186293Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE, CORROSION ON AFT CARGO COMPARTMENT STRINGER BETWEEN FR 56 AND FR 59 AT S42L. REPAIRED STRINGER PER SRM 53-00-13-300-001.SDR AALA202511179530Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT STRINGER BETWEEN FR 58 AND FR 59 AT S42L. REPAIRED STRINGER PER SRM 53-00-13-300-001.SDR SWIA2025111000911Trunnion · crackedREPAIRED 3 EACH CRACKED HOLES FOR LH TRUNION REF REO 601R-57-21-1748 REV. --, THIS IS A SAFE LIFE REPAIR. LIFE LIMIT/DISCARD TIME IS 20,475 CYCLES FROM INCORPERATION OF REPAIR DUE BY TAC 41408., PART NUMBER: - , SERIAL NUMBER: 7765, POSITION: (FILED CLOSESDR AALA202510284167Seat Track · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION SEAT TRACK +Y1292 AT LEVEL FR16 AT FWD GALLEY AREA MEASURE OF CORROSION ARE : L= 0.754 INCH, W= 0.640 D: 0.046 INCH. MAINTENANCE REPLACED SEAT TRACK +Y 1292 AT LEVEL FR12 TO FR24 AT FWD GALLEY AREA I.A.W A319 SRM 51-42-1SDR AALA202510246095Oven · odorAIRCRAFT WAS NOT GROUNDED: FORWARD GALLEY LEFT OVEN SMELLS LIKE BURNING PAPER WHEN RUN. : MAINTENANCE ACCOMPLISHED INSTRUCTIONS FOR EA 368117.SDR SWAA2025102313442Angle · crackedCRACK ANGLE FLOOR STRUCTURE LOCATED BS 695 AND RBL 24.75 AT PASSENGER CABIN. REPLACED ANGLE ON FLOOR STRUCTURE LOCATED BS 695 AND RBL 24.75 AT PASSENGER CABIN IAW B737-700 SRM 51-10-02 PARAGRAPH 9 AND DWG: 273A9110 SHEET: 6 REV: A.SDR SWAA2025102313443Stiffener · crackedCRACK STIFFENER ASSY FLOOR STRUCTURE LOCATED BS 540 BETWEEN BL 0 AND RBL 24.75 PASSENGER CABIN. REPLACED STIFFENER ASSY FLOOR STRUCTURE AND FASTENERS LOCATED BS 540 BETWEEN BL 0 AND RBL 24.75 PASSENGER CABIN IAW B737-700 SRM-51-10-02 ITEM 9 AND B737-700 SRM 5SDR SWAA2025102313453Beam · crackedCRACK INDICATION ON RADIUS OF FORWARD SERVICE DOOR 141A6536-14 BEAM #4.LENGTH OF CRACK: 0.625 IN. EO 5241-C-14093 OR 5241-C-14344 WILL BE ADDED TO REPAIR ORDER FOR REPAIR. REPLACED TRACE BEAM NR 4 BTW BS 299.10 AND 328.87, FWD SERVICE DOOR IAW SRM 51-10-02 PSDR SWAA2025102213441Angle · crackedCRACKED ANGLE LOCATED BS 695 BL0 AFT SIDE. REPLACED ANGLE IAW SRM 51-10-02, PARAGRAPH 9, SRM 51-40-02, AND DWG 273A9110, SHEET 6, REV A.SDR SWAA2025102213444Angle · crackedCRACKED ANGLE LOCATED BS 695 AND BL0 FWD SIDE. REPLACED ANGLE IAW SRM 51-10-02, PARAGRAPH 9, SRM 51-40-02, AND DWG 273A9110, SHEET 6, REV A.SDR NACA2025091100002Outflow Valve · faultedOUTFLOW VALVE DRIVE LINKAGE HAS IS CORRODED. RESOLVED ON W/O: 128197 TASKCARD: N/R-00420. REMOVED & REPLACED LINKAGE ON OUT FLOW VALVE IAW B767 AMM 20-11-00-993-809.SDR NACA2025102000001Outflow Valve · faultedOUTFLOW VALVE LINKS ROD END AND ATTACHMENT HARDWARE CORRODED.SDR SWAA2025102113935Floorbeam · crackedCRACKED FLOORBEAM LOCATED BS 540 AND BTW BL 0 TO RBL 24.75. REPLACED THE FLOORBEAM IAW SRM 51-10-02-0G ITEM 9; SRM 51-40-02-0G AND DWG: 143A0060; SHEET: 64; REV-.SDR AALA202510212595Dummy Rail · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION RAIL DUMMY Y503.2 LOC. AT LEVEL FR16 AT FWD GALLEY AREA CORROSION ARE: L= 0.611 INCH, W= 0.350 INCH D=0.005 INCH. MAINTENANCE REPLACED RAIL DUMMY Y503.2 LOC. AT LEVEL FR16 AT FWD GALLEY AREA IAW A319 SRM-51-42-11-801, A3SDR SWAA2025102013941Floorbeam · corrodedCORROSION FLOORBEAM BS 986.5 LBL 43 AND WL 208.1 AT AFT GALLEY AREA. ULTRASONIC EQUIPMENT USED, EDDY CURRENT EQUIPMENT USED. PERFORMED PERMANENT REPAIR ON FLOORBEAM LOCATED ON STA 986.5 LBL 43 AND WL 208.1 AT AFT GALLEY AREA IAW SRM 53-70-51-2R-6 REPAIR 6.SDR SWAA2025102013937Floorbeam · corrodedCORROSION EXISTING REPAIR LOCATED BS 947 LBL 49 WL 208.1 AFT GALLEY AREA. PERFORMED PERMANT REPAIR CATEGORY A; ON FLOOR BEAM LOCATED BS 947 RBL 60 TO LBL 60 IAW EA 25-153-02580 AND B737-800 SRM 53-70-51-2R-5 REPAIR 5 STEPS DUCUMENTED ON TTG8Q0153W1D.SDR SWAA2025102013938Floorbeam · corrodedCORROSION ON EXISTING REPAIR LOCATED BS 947 RBL 49 WL 208.1 AFT GALLEY AREA. PERFORMED PERMANT REPAIR CATEGORY A ON FLOOR BEAM LOCATED BS 947 RBL 60 TO LBL 60 IAW EA 25-153-02580 AND B737-800 SRM 53-70-51-2R-5 REPAIR 5.SDR SWAA2025101613939Floor Support · corrodedCORROSION INTERCOSTAL FLOOR STRUCTURE LOCATED BTW STA 947 TO STA 967 RBL 50 WL 208.1 AT AFT GALLEY AREA. REPLACED NEW INTERCOSTAL FLOOR STRUCTURE AND FASTENERS LOCATED BTW STA 947 TO STA 967 RBL 50 WL 208.1 AT AFT GALLEY AREA. IAW SRM 51-40-02 SRM 51-10-02 ITSDR SWAA2025101413890Light · brokenBROKEN PHOTOLUMINESCENT STRIP AT PASSENGER CABIN (10 EA). REPLACED PHOTOLUMINESCENT STRIP AT PASSENGER CABIN (10 EA) IAW SOPM 20-50-12 REV 58 AND DWG 33500007 SHEET 2.