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 CALA2025101610179Angle · wornLOWER VERTICAL STABILIZER TO UPPER FUSELAGE ACCESS PANEL 323AR SUPPORT ANGLE SEVERAL AREA WORN. REMOVED AND REPLACED LOWER VERTICAL STABILIZER TO UPPER FUSELAGE ACCESS PANEL 323AR SUPPORT FWD ANGLE IAW SRM 51-40-02-0G-0 AND DWG 147A0030.SDR CALA2025101610178Angle · crackedLOWER VERTICAL STABILIZER TO UPPER FUSELAGE ACCESS PANEL 323AL SUPPORT ANGLE CRACKED REF AAR N/R 99954672 REMOVED AND REPLACED LOWER VERTICAL STABILIZER TO UPPER FUSELAGE ACCESS PANEL 323AL SUPPORT FWD ANGLE REF B-737 SRM 51-40-02-0G-0 AND DWG 147A0030. REMOVSDR CALA2025101610166Unknown · odorMUSTY SMELL IN COCKPIT UPON ARRIVAL AT A/C UPON ARRIVAL TO AIRCRAFT THE ODOR WAS VERY FAINT AND ALMOST GONE. FOLLOWED FIM TASK 05-50-00-810-831-A. AIRPLANE HAS HISTORY OF HYDRAULIC LEAK AND SUSPECT RESIDUAL HYDRAULIC FLUID GOT INTO APU INLET AND HAD MOMENTARY SDR CALA2025101610163Battery Pack · no testEMERGENCY LIGHTS - OPERATIONAL TEST FOUND EMERGENCY LIGHT BETWEEN SEAT ROWS 49 FED UNITL 54 FED INOPERATIVE. APPLIED FIM 33-51 FAULT TREE 803 AND REPLACED BATTERY PACK POSITION M734 AS PER AMM TASK 33-51-07-27. GOOD FOR SERVICE.SDR CALA2025101610160Girt Bar · lack of lubeDOOR DISARM LEVER FEELS STIFF AT 4L INSPECTED4L DOOR SLIDE GIRT BAR AND ATTACH POINTS NO DEFECTS NOTED . FOUND GIRT BAR SLIDE AND PIVOT POINT DRY WITH NO GREASE. GREASED AREA WITH LOW TEMP GREASE CYCLED DISARM SEVERAL TIMES OPS CHECKS GOODSDR CALA2025101610159Bottle · low pressureEMERGENCY ESCAPE SLIDE PRESSURE LOW 1L PERFORMED VISUAL INSPECTION OF L1 DOOR SLIDE CYLINDER REF AMM 25-66-02 , NEEDLE ON GREEN BAND OK TO CONTINUE.SDR DALA2025101607562Oil System · low pressureRETURNED TO SLC DUE TO LEFT ENGINE LOW OIL PRESSURE AND ENGINE WAS SHUT DOWN. ENGINE CHANGE REQUIRED DUE TO ENGINE OPERATED BELOW AMM OIL PRESSURE LIMITS. (LP: 7404148)SDR DALA2025101607561Bottle · low pressureL1 DOOR ASSIST BOTTLE REQUIRES SERVICE. SERVICED ASSIST BOTTLE PER A320 AMM 52-10. (LP: 6684508)SDR YENA2025101601037Battery · inoperativeFLT#1743, SFO-BOS. "AFT EMERG LIGHTS IN GALLEY WILL NOT ILLUMINATE; REMOVED AND REPLACED BATTERY FROM EPSU (1004WL) IAW AMM 33-51-38. NO HELP."SDR 2025FA0000719Bracket · crackedFUEL FLOW TRANSDUCER BRACKET FOUND TO HAVE SIGNIFICANT CRACK.SDR SWIA2025101500001Landing Gear · warning messageSMOD APPROVAL REQUIRED FOR RETURN TO SERVICE DUE TO ODI EVENT, CAT II DOWNGRADED. GEAR DISAGREE WHEN BRINGING GEAR UP. LEFT MAIN SHOWED RED HASHES. RAN QRH AND GEAR CAME DOWNC:MEL 32-30-1CAT A. GEAR DISAGREE WHEN BRINGING GEAR UP. LEFT MAIN SHOWED RED HASHESSDR VNAA20251015032Floorbeam · corrodedFLOORBEAM AT FS333.00 RBL 9.00 IS CORRODED. REPAIRED IAW MHIRJ REO 670-53-21-25485 REV-- DATED 2025-02-18SDR 2025FA0000717Bearing · brinelledFOUND BOTH SPINDLE BEARINGS P/N A159-3, TSN: 1406.9 BRINELLED. NO OVER SPEEDSSDR VNAA20251015031Seat Track · corrodedSEAT TRACK IS WORN AT FS 379.00 LBL 9.00. REMOVED CORRODED SEAT RAIL. INSTALLED NEW SEAT TRACK (P/N:SH670-32249-3) AT LBL 9 FS379-485 IAW CRJ700 AMM 53-00-49-400-801-A01.SDR 2025FA0000716Bearing · brinelledFOUND BOTH SPINDLE BEARINGS P/N A159-3, TSN: 1449.7 BRINELLED. NO OVER SPEEDSSDR FDEA202510152013Floor Panel · damagedBROKEN FLOOR PANEL 231VFF, MAIN DECK CARGO COMPARTMENT FLOOR PANEL 231VFF, MAIN DECK CARGO COMPARTMENT WAS REPAIRED IAW B767 SRM 53-00- 50-2R PAR. 4B FIG. 201 SHEET 2 REV 92 APR 15, 2025SDR FDEA202510152012Floor Panel · damagedBROKEN FLOOR PANEL 252HFF, MAIN DECK CARGO COMPARTMENT FLOOR PANEL 252HFF, MAIN DECK CARGO COMPARTMENT WAS REPAIRED IAW B767 SRM 53-00- 50-2R PAR 4B FIG 201 SHEET 2 REV 92 APR 15, 2025SDR FDEA202510152011Wedge · scratchedRIGHT WING SLAT 8 HAS A DEEP SCRATCH ON UNDERSIDE. REPAIRED THE RT WING NR 8 SLAT UPPER T/E WEDGE BOTTOM SURFACE APPROX OSS 425 IAW SRM 57-43-02-2R, PG 1-2 DETAIL 1 & 2, SRM 51-70-10-2R SEE JPF FOR WORK ACCOMPLISHED. MAJOR REPAIR.SDR FDEA202510152010Skin · crackedDURING PERFORMANCE OF WORK CARD: E G-5710-E0376285E, P12, STEP 3.B.(1), STEP 5.A.(2), & FOUND TWO CRACKS AT HOLE NR 5 OF RT UPPER WING SKIN COMMON TO FASTENERS 0-5. RT WING UPPER WING SKIN REPAIRED IAW SRM 51-40-05-0G, SRM 51-40-02-0G, SRM 51-40-04-0G, REV 51,SDR FDEA202510152009Skin · crackedDURING PERFORM WORK CARD:EG-5710-E0376285E P11 STEP 3.B.(1)&STEP 5.A.(2) AND FOUND TWO CRACKS AT HOLE #5 OF LH UPPER WING SKIN COMMON TO FASTENERS 0-5. LH WING UPPER SKIN TRAILING EDGE #5 HOLE CRACK REPAIRED AS PER B777 SRM 51-50-02-0G, SRM 51-40-02-0G, SRSDR FDEA202510152008Frame · crackedNDT INSPECTION, LT SIDE FUSELAGE FRAME FR73A ONE RIVET HOLE CRACKED AT S24L - S25L REPAIRED LH DOOR FRAME FR73A RIVET HOLE AT STGR24 - STGR25.THIS IS CATEGORY B REPAIR.MAJOR REPAIR IAW FEDEX GMM6-2-100.SEE WRI 53100887 FOR WORK DETAILS.SDR FDEA202510152007Frame · crackedNDT INSP - RH SIDE FUSELAGE FRAME FR73A 1EA RIVET HOLE CRACKED AT STGR24 - STGR25 COMPLIED WITH EA:6-5310-T0385324 P1,TITLE: FUSELAGE - MAINFRAME - EO 6-5310-E0327267 (SB A300-53-6175) INSPECTION - CRACK FOUND ON LH & RH DOOR FRAME FR73A - SPLICE REPAIR PESDR FDEA202510152005Tee Angle · crackedWHILE ACCOMPLISHING NON DESTRUCTIVE TEST HIGH FREQUENCY EDDY CURRENT OPEN HOLE INSPECTION, HOLE A AT TEE CAP (NCA6042-15) FOUND WITH CRACKED. CRACK AT TEE CAP (NCA6042-15) HOLE A REPAIRED AS PER EA # 1-5330-T0385040 PART 1 TITLE: FUSELAGE - PLATES & SKINS SDR KCSA202510151206Shear Web · corrodedMAIN DECK SHEAR WEB PANEL 152W1209-22, HAS SEVERAL AREAS WITH EVIDENCE OF CORROSION.SDR KCSA202510151205Fitting · crackedBS 1119 - 1140, LBL 96 MAIN DECK CARGO HANDLING FITTING HAS DAMAGE.SDR DALA2025101507542Oxygen Mask · dislodgedFA BUNK NR 2 CREW REST O2 MASK HANGING. REPACKED MASKS IAW AMM 35-23. OK FOR SERVICE. (7832529)SDR DALA2025101507540Seat Track · corrodedCABIN SEAT TRACK FOUND CORROSION AT -YA FR 71-73. REPLACED THE SEAT TRACK AT CABIN -YA FR71-73 PER A330 SRM 51-72-11. (1253032)SDR DALA2025101507539Seat Track · corrodedCABIN SEAT TRACK FOUND CORROSION AT Y380 FR 78. REPLACED THE SEAT TRACK AT CABIN Y380 FR78 PER A330 SRM 51-72-11. (1253028)SDR DALA2025101507538Seat Track · corrodedCABIN SEAT TRACK FOUND CORROSION AT YB TO Y-380 BETWEEN FR 75 AND FR 78. REPLACED THE SEAT TRACK AT CABIN YB TO Y-380 BETWEEN FR75 AND FR78 PER A330 SRM 51-72-11. (1253019)SDR DALA2025101507537Seat Track · corrodedCORROSION AT Y-460 FR 80. REPLACED THE FLOOR PROFILE AT Y-460 FR80 PER A330 SRM 51-72-11. (1253006)SDR DALA2025101507536Seat Track · corrodedCABIN SEAT TRACK FOUND CORROSION AT Y450 BETWEEN FR73 AND FR75. SEAT TRACK REPLACED PER A330 SRM 51-72-11. (1252983)SDR DALA2025101507535Seat Track · corrodedCABIN SEAT TRACK FOUND CORROSION AT Y-450 BETWEEN FR73 AND FR75. SEAT TRACK REPLACED PER A330 SRM 51-72-11. (1252968)SDR DALA2025101507534Seat Track · corrodedCABIN SEAT TRACK FOUND CORROSION AT Y-1137.1 FR 74. REPLACED THE INTERCOSTAL (SEAT TRACK) AT Y-1137.1 (RBL44.77) BETWEEN FR74 AND FR77 PER ER/A 629508-14 REV ORIGINAL. (1252954)SDR DALA2025101507533Seat Track · corrodedCABIN SEAT TRACK FOUND CORROSION AT Y-794.3 BETWEEN FR 74 AND FR 75. REPLACED THE INTERCOSTAL (SEAT TRACK) AT Y-794.3 (RBL31.27) BETWEEN FR74 AND FR77 PER ER/A 629509-14 REV ORIGINAL. (1252939)SDR DALA2025101507532Seat Track · corrodedCABIN SEAT TRACK FOUND CORROSION AT Y794.3 FR 74. REPLACED THE INTERCOSTAL (SEAT TRACK) AT Y794 (LBL31.27) BETWEEN FR74 AND FR77 PER ER/A 629509-14 REV ORIGINAL. (1252903)SDR DALA2025101507531Seat Track · corrodedCABIN SEAT TRACK FOUND CORROSION AT Y0 BETWEEN FR 77 AND FR 78. SEAT TRACK REPLACED PER A330 SRM 51-72-11. (1252885)SDR DALA2025101507530Seat Track · corrodedCABIN SEAT TRACK FOUND CORROSION AT Y1147.8 BETWEEN FR 75 AND FR 76. SEAT TRACK REPLACED PER A330 SRM 51-72-11. (1252855)SDR DALA2025101507529Seat Track · corrodedCABIN SEAT TRACK FOUND CORROSION AT Y450 FR 78. SEAT TRACK REPLACED PER A330 SRM 51-72-11. (1252685)SDR DALA2025101507528Seat Track · corrodedCABIN SEAT TRACK FOUND CORROSION AT YB TO Y-450 BETWEEN FR 78 AND FR 80. SEAT TRACK REPLACED PER A330 SRM 51-72-11. (1252675)SDR KCSA202510151204Floor Support · corrodedFLOOR SUPPORT FITTING AT BS 1622, APPROX RBL 92 HAS EVIDENCE OF CORROSION.SDR KCSA202510151203Floor Support · corrodedFLOOR SUPPORT FITTING AT STA 1664, APPROX RBL 92 HAS EVIDENCE OF CORROSION.SDR KCSA202510151202Floor Support · corrodedFLOOR SUPPORT FITTING AT STA 1685, APPROX RBL 92 HAS EVIDENCE OF CORROSION.SDR KCSA202510151201Floor Support · corrodedFLOOR SUPPORT FITTING AT STA 1706 RBL 92 HAS EVIDENCE OF CORROSIONSDR DALA2025101507524Ground Wire · looseROW 30 CEILING EMERGENCY LIGHT INOP. REMOVED CEILING PANEL AND FOUND LOOSE GROUNDING WIRE TO LIGHT. SECURED GROUNDING WIRE PER A321 AMM 33-51. OPS CHECK GOOD. (LP 7861071)SDR KCSA202510151200Fitting · crackedSTA 1140 TO STA 1161 LBL 96 MAIN DECK CARGO HANDLING FITTING HAS DAMAGESDR KCSA202510151199Floor Support · corrodedMAIN DECK CARGO FLOOR SUPPORT FITTING @ BS 1434 LBL 6.5 HAS EVIDENCE OF CORROSIONSDR 2025FA0000715Bearing · brinelledFOUND BOTH SPINDLE BEARINGS P/N A159-3, TSN: 1064.8, BRINELLED. NO OVER SPEEDSSDR 2025FA0000714Bearing · brinelledFOUND BOTH SPINDLE BEARING SETS P/NA159-3, TSN: 1113.0, BRINELLED. NO OVER SPEEDS.SDR KCSA202510151198Skin · crackedWHILE PERFORMING BOEING SB 777-57A0125 CRACK INDICATION FOUND ON FASTENER #5 & #6 R/H WING T/E UPPER SKINSDR KCSA202510151197Skin · crackedWHILE PERFORMING BOEING SB 777-57A0125 CRACK INDICATION FOUND ON FASTENER #5 L/H WING T/E UPPER SKIN