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 AALA202510319224Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FLOOR BEAM COMMON TO VERTICAL STRINGER 3L AT FR 36, AND Y254, CENTER WING BOX FRONT SPAR, FORWARD CARGO COMPARTMENT. REPAIRED FLOOR BEAM PER EA 367962SDR AALA202510311486Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FLOOR BEAM COMMON TO VERTICAL STRINGER 4R AT FR 36, AND -Y254, CENTER FORWARD CARGO COMPARTMENT. REPAIRED FLOOR BEAM PER EA 367962SDR JJBA20251024062Floor Support · corrodedCORROSION FOUND ON CENTER OMEGA BIN GUSSET, BETWEEN FRAMES 59 & 61. INSTALLED NEW GUSSET BETWEEN FRAMES 59 & 61.SDR AALA202510239031Stringer Splice · damagedAIRCRAFT IN BASE MAINTENANCE: ELONGATED HOLE ON LOWER SPLICE OUTBOARD SIDE ON LOWER SILL LOC. STR23R AT LEVEL FR66 AFT GALLEY AREA. MEASURE IS 0.043 IN. MAINTENANCE REPLACED LOWER SPLICE OUTBOARD SIDE ON LOWER SILL LOC. STR23R AT LEVEL FR66 AFT GALLEY AREA, IASDR AALA202510236165Stringer Splice · damagedAIRCRAFT IN BASE MAINTENANCE: ELONGATED HOLE ON UPPER SPLICE INBOARD SIDE ON LOWER SILL LOC. STR23R AT LEVEL FR66 AFT GALLEY AREA. MEASURE IS 0.049 IN. MAINTENANCE REPLACED UPPER SPLICE INBOARD SIDE LOC. STR23R AT LEVEL FR66 AFT GALLEY AREA, IAW A320 SRM 51-72SDR AALA202510233940Stringer Splice · elongatedAIRCRAFT IN BASE MAINTENANCE: ELONGATED HOLE ON UPPER SPLICE OUTBOARD SIDE ON LOWER SILL LOC. STR23R AT LEVEL FR66 AFT GALLEY AREA. MEASURE IS 0.05 IN. MAINTENANCE REPLACED UPPER SPLICE OUTBOARD SIDE LOWER SILL LOC. STR23R AT LEVEL FR66 AFT GALLEY AREA, IAW A3SDR AALA202510235799Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION LOWER SILL STR 23R AT LEVEL FR68 AFT GALLEY AREA (CPCP 534195-1).CORROSION MEASURE L=3.870 IN, W=2.035 IN, D=0.030 IN. MAINTENANCE REPLACED LOWER SILL LOC. STR23R AT LEVEL FR68 AFT GALLEY AREA IAW A320 SRM 51-72-11-911-SDR AALA202510239373Seat Track · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION SEAT TRACK -Y1162.5 AT LEVEL FR 68 AFT GALLEY AREA (CPCPC 5341 95-01) MEASURES OF CORROSION ARE L: 0.898 INCH, W: 0.540 INCH, D: 0.034 INCH. MAINTENANCE REPLACED SEAT TRACK -Y1162.5 AT LEVEL FR68 TO FR69 AFT GALLEY AREASDR AALA202510238657Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK SHEAR PLATE STR 23 L BTW FR 69 AND FR 70 AT AFT GALLEY AREA. L= 0.780 INCHES. MAINTENANCE REPLACED SHEAR PLATE STR 23L BTW FR69 AND FR70 AT AFT GALLEY AREA IAW A32O SRM 51-42-11-801, SRM 51-72-11-911-001 AND DWG D58474180.SDR SWIA20250905Floor Support · corrodedFLOOR SUPPORT CAP CORRODED FROM FS574 TO FS621. REPLACED FLOOR SUPPORT CAP FROM FS574 TO FS 621 IAW BOMBARDIER REO 601R-53-61-3778 REV-B DATED 2016-12-19 COMPLETED TASK CARD 51-900-1003-SKY.SDR CALA2025101510116Window Frame · crackedFOUND CRACK AT THE LOWER FASTENER NR 3 HOLE OF L3 WINDOW FRAME POST. REF TO EA 5310-08195 REV C OP 003. PERFORMED REPAIR TO L3 WINDOW FRAME E-F POST REPAIR IAW ECRA 5310-08678.SDR CALA2025101510109Wire Harness · damagedEEPL HARNESS AT STA. 570 HAS DAMAGED WIRING. REMOVED AND REPLACED CABLE HARNESS (PN:BR-9635-90-24) ON EEPL HARNESS AT STA. 570 IAW DWG 40N01810 SH2,PG8, REV ORIGINAL AND SWPM20-90-14. INSTALLED EEPL HARNESS AT STA 570 IAW DWG 40N01810 SH2 REV ORIGINAL. CHARGESDR CALA2025101510108Connector · damagedEEPL HARNESS AT STA. 500E +12 HAS 2 BROKEN PIN LOCKS ON THE CONNECTOR. SUPPORT TASK NSA EMX NR 00214 SDR INFORMATION ADDED REMOVED AND REPLACED CONNECTOR (PN:BACC45FT10-5P) ON EEPL HARNESS AT STA.500E+ 12 IAW NATDWG 40N01810 SH2,PG8,REV ORIGINAL AND SWPM 20-6SDR SWAA2025101411937Angle · crackedCRACK ON ANGLE - CLIP LOCATED BS400 AND STR26L FWD CARGO COMPARTMENT. REPLACED ANGLE - CLIP LOCATED BS400 AND STR26L FWD CARGO COMPARTMENT. IAW SRM 51-10-02-0G-0 ITEM 9 AND DWG 143A7505 SHEET: 2 REV: B.SDR SWAA2025101411936Angle · crackedCRACK ON ANGLE - CLIP LOCATED BS420 AND STR26L FWD CARGO COMPARTMENT. REPLACED ANGLE - CLIP LOCATED BS420 AND STR26L FWD CARGO COMPARTMENT. IAW B737-700 SRM 51-10-02-0G-0 ITEM 9 AND DWG 143A7505 SHEET: 2 REV: B.SDR SWAA2025101411938Angle · crackedCRACK ON ANGLE - CLIP LOCATED BS500C AND STR26R FWD CARGO COMPARTMENT. REPLACED ANGLE - CLIP AND FASTENERS LOCATED BS500C AND STR26R FWD CARGO COMPARTMENT IAW B737-700 SRM 51-40-02; SRM 51-10-02 ITEM 9 AND DWG 143A7505 SHEET:6 REV:D .SDR AALA202510148261Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION CENTER FITTING STR 23L BTW FR66 AND FR68 AFT GALLEY AREA. MEASURES OF CORROSION: L= 5.279 IN W=1.586IN D= 0.080 IN. MAINTENANCE REPLACED CENTER FITTING LOCATED STR 23L BTW FR 66 AND FR 68 AFT GALLEY AREA IAW A320 SRM 51SDR JJBA20251010042Fuel Tank · corrodedSURFACE CORROSION ON VENTRAL FUEL TANK EXTERNAL FWD FACE AROUND FUEL VENT TUBE BRACKET. AFTER INVESTIGATION, NO CORROSION FOUND ON BRACKET, ONLY ON RIB I OF VENTRAL TANK. SURFACE BLENDED AND FOUND OUT OF LIMIT. VENTRAL TANK ON RIB I CUT OUT PERFORMED. VENTRAL SDR IPXA2025092725310Stringer · crackedSTRINGER CRACK, AFT SIDE OF STA 2360, STA 2377 AT S-6L (LEVEL 2) (REPAIR).REMOVED UPPER CORNER BRACKET FROM LOWER FUSELAGE, WING/BODY FAIRING 194CR IAW B757-200PF SRM 51-40-02-0G-0.FABRICATED UPPER CORNER BRACKET R/H FROM P/N: SHT-7075T6-0.063/12 BATCH: 000323SDR AALA202510088256Dummy Rail · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CABIN FLOOR DUMMY RAIL AT FR 16 AT +Y503.2. REPLACED DUMMY RAIL PER SRM 51-72-11.SDR AALA202510087062Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK AFT CABIN FLOOR SHEAR PLATE BETWEEN FR 69 AND FR 70 AT S23R. REPLACED SHEAR PER RM 51-72-11.SDR CALA2025100709730Structure · corrodedCORROSION ON CABIN FWD WET AREA R1 DOOR LOWER INNER CHORD BETWEEN STA 294 AND STA 328. REMOVED CORROSION, FOUND OUT OF LIMITS, REMOVED INNER CHORD, AT CABIN FWD WET AREA R1 DOOR. LOCATED AND DRILLED NEW INNER CHORD, INSTALLED NEW INNER CHORD AT CABIN FWD WETSDR CALA2025100709729Structure · corrodedAFT CABIN STA 986 LBL 55 WEB UNDER L/H INNER CHORD HAS EXFOLIATED CORROSION. REMOVED AND REPLACED WEB AT AFT CABIN STA 986 LBL 55 WEB UNDER L/H INNER CHORD IAW SRM 51-40-02-0G-0 AND DWG 147A8501 SHEET 23.SDR CALA2025100709728Structure · corrodedAFT PASSANGER CABIN BS 947 LBL 54 (L2 DOOR) INNER CHORD HAS EXFOLIATED CORROSION. REMOVED AND REPLACED INNER CHORD AFT PASSENGER CABIN STA 946 LBL 54" L2 DOOR AS PER SRM 51-40-02-0G-0 AND DWG 147A8501 SHEET 67.SDR SWAA2025100611513Seat Track · corrodedSEAT TRACK RBL 45 FROM STA. 440+2' IS CORRODED AT THE LOWER CROWN. COUNTERSUNK SEAT TRACK REPAIR STA 380-480 RBL 45' IAW SRM 51-40-08-0G-0. REMOVED CORROSION FROM LOWER CROWN OF SEAT TRACK AT RBL 45 AT STA 440+2' AND VERIFIED WITH 10X MAGNIFIER ALL REMOVED SDR JJBA20251006008Shear Tie · crackedCFII, SHEAR CLIP AT FR25 BTW FR 15R-16R FOUND CRACKED. CFII AT FR 25 BTW STR 15R-16R SHEAR CLIP REMOVED AND REPLACED.SDR AALA202510042940Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT BS 948.5, RBL 25. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR SWAA2025100311943Angle · crackedCRACK ON ANGLE LOCATED AFT FACE BS 500I AT LEVEL STR 28R AT FWD CARGO COMPARTMENT. REPLACED ANGLE AND FASTENERS LOCATED AFT FACE BS 500I AT LEVEL STR 28R AT FWD CARGO COMPARTMENT IAW B737-800 SRM 51-40-02; SRM 51-10-02 ITEM 9 AND DWG 143A7902 SHEET 301 REV ASDR SWAA2025100311944Angle · crackedCRACK ON ANGLE LOCATED AFT FACE BS 500I AT LEVEL STR 28L AT FWD CARGO COMPARTMENT. REPLACED ANGLE (BRACKET) AND FASTENERS LOCATED AFT FACE BS 500I AT LEVEL STR 28L AT FWD CARGO COMPARTMENT IAW B737-800 SRM 51-10-02-0G-0 ITEM 9; SRM 51-40-02-0G-0 AND DWG:143A7SDR HNAA2025100300669Crossbeam · damagedCROSSMEMBER AT FRAME 5 HAS ELONGATED FASTENER HOLES NEAR STGR 15R. REPAIRED CROSSMEMBER AT FR 5 ELONGATED FASTENER HOLES NEAR STR 15R IAW EO1-53-25-0326 AND ETD2025-145-927858.SDR HNAA2025100300668Frame · damagedFRAME 5 HAS ELONGATED FASTENER HOLES NEAR STGR 15R. REPAIRED FR 5 ELONGATED FASTENER HOLES NEAR STR 15R IAW EO1-53-25-0330 AND ETD2025-145-927849.SDR SWAA2025100211897Seat Track · wornMAIN CABIN SEAT TRACK AT LBL 45 STA 520 UPPER CROWN HAS WEAR. REMOVED WEAR DAMAGE FROM MAIN CABIN SEAT TRACK AT LBL 45 STA 520 UPPER CROWN IAW SRM 51-10-02-0G-0; DAMAGE CLEAN UP DEPTH .025'; MAX CLEAN UP DEPTH ALLOWED .020'. FOUND OUT OF LIMITS IAW SRM 53-00SDR SWAA2025100211902Seat Track · corrodedMAIN CABIN SEAT TRACK AT LBL 45 BETWEEN BS 727B -747+5' LOWER CROWN HAS CORROSION IN MULTIPLE AREAS. REPAIRED IAW DWG 146A5300 REV: -, EVALUATED MATERIAL LOSS OF .043 MAX LOSS OF .040 IAW SRM 53-00-52-1A-1, FOUND TO OUT OF LIMITS. CUT AND REMOVED SEAT TRSDR SWAA2025100211891Seat Track · wornMAIN CABIN SEAT TRACK AT LBL 45 BETWEEN STA 807+17' AND STA 807+19' UPPER CROWN HAS WEAR. REPAIRED THE SEAT TRACK IAW SRM 53-00-52-2R-5-A00847, AND DWG: 146A5300 REV-, REPAIR 5, SECTION 46.SDR JJBA20251002003Support · corrodedCFII, RT SILL NR 1 BTW FR 23-30 FOUND CORRODED. CFII, RT SILL NR 1 BTW FR 23-30 BLENDED, FOUND OUT OF LIMIT AND REMOVED FOR REPLACEMENT. CFII, RT SILL NR 1 BTW FR 23-30 IS REPLACED.SDR SWAA2025100111977Stop Fitting · crackedCRACK AFT LOWER STOP FITTING SERVICE DOOR AT FWD GALLEY AND LAV . REPLACED STOP FITTING DOOR AND FASTENERS LOCATED ON AFT LOWER SERVICE DOOR AT FWD GALLEY AND LAV IAW SRM 51-40-02 AND DWG 141A6535 SHEET 1 REV.SDR SWAA2025100111639Scuff Plate · crackedCRACK FWD SCUFF PLATE LOCATED ON FWD CARGO DOOR CUT-OUT. REPAIRED AT CORNER FWD SCUFF PLATE LOCATED ON FWD CARGO DOOR CUT-OUT I. A.W. B737-700 SRM 53-30-15-2R-1; REPAIR 1.SDR MASA20250930008Door · corrodedCORROSION REMOVED BY BLENDING AND FOUND TO BE WITHIN ALLOWABLE LIMITS IAW ERJ-175 SRM 53-23-11 AD2, DVI PERFORMED IAW NDTM TASK 51-05-00-214-801-A, NO FINDINGS SURFACE WAS REPROTECTED I.A.W SRM 51-23-04, 51-23-05, 51-23-06, REMAINING THICKNESS 0.050", CORROSIOSDR MASA20250930007Beam · corrodedFWD CARGO DOOR CUT-OUT LOWER BEAM, AFT CORNER SEAL REST AT FR27 WAS REMOVED AND REPLACED I.A.W AMM SUBTASK 20-10-01-910-801-ASDR MASA20250930004Shear Tie · corrodedAFT CARGO COMPARTMENT, CORRODED SHEAR CLIP AT FRAME 86 BETWEEN STRG 27R-28R WAS REMOVED AND REPLACED IAW ERJ175 SRM 51-41-01 AND 51-41-02SDR SWAA2025093011643Floor Panel · delaminatedDELAMINATED FLOOR PANEL 242AF AT PASSENGER CABIN. REPAIRED THE FLOOR PANEL 242AF IAW SRM 53-00-50-2R-1, REPAIR 1, AND SRM 53-00-50-2R-0, REPAIR GENERAL.SDR AALA202509306582Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER SECTION REAR SPAR VAPOR BARRIER SUPPORT ANGLE AT BS 663.5, LBL 2. REPAIRED PER SRM 57-10-10-2R AND EA 368112.SDR SWAA2025092911482Handle · looseFWD ENTRY DOOR AFT CUTOUT LINER ASSIST HANDLE IS LOOSE. SECURED FWD ENTRY DOOR AFT CUTOUT LINER ASSIST HANDLE PER AMM 25-21-31-420-802 STEP 3. B. (6).SDR SWAA2025092911866Pressure Deck · crackedCRACK NOTED ON RH HORIZONTAL PRESSURE DECK WEB BS 663+1.5 WL 202.5; RBL 40.5; L: 0.3'. REMOVED DAMAGE BS 663- BS674 RBL 38- RBL60; FABRICATED REPAIR PARTS AND INSTALLED REPAIR PARTS ON BS663-BS674 RBL30-RBL60 WL 203 I.A.W SRM 53-40-51-2R-2 REPAIR 2.SDR SWAA2025092911544Plate · crackedCRACK CORRUGATED PLATE TRAILING EDGE LOCATED ORSS261 AT RT WING . REPLACED CORRUGATED PLATE TRAILING EDGE LOCATED ORSS261 AT RT WING IAW B737-700 SRM 51-10-02-0G ITEM 9; SRM 51-40-02-0G AND DWG: 115A2001; SHEET: 29; REV: -SDR SWAA2025092911541Access Panel · damagedELONGATED HOLES ON ACCESS PANEL 661CB TRAILING EDGE AT RT WING. REPAIRED ACCESS PANEL 661CB TRAILING EDGE AT RT WING IAW B737-700 SRM 51-70-04-2R-9 REPAIR 9.SDR SWAA2025092911540Access Panel · elongatedELONGATED HOLES ON ACCESS PANEL 661BB TRAILING EDGE AT RT WING. REPAIRED ACCESS PANEL 661BB TRAILING EDGE AT RT WING IAW SRM 51-70-04-2R-9 REPAIR 9.SDR SWAA2025092911543Access Panel · elongatedELONGATED HOLES ON ACCESS PANEL 661AB TRAILING EDGE AT RT WING. REPAIRED ACCESS PANEL 661AB TRAILING EDGE AT RT WING IAW SRM 51-70-04-2R-9 REPAIR 9.SDR IPXA2025092625040Stringer · crackedSTRINGER CRACKED, FWD SIDE OF BS 2598 S5L LEVEL 2. PERFORM EO-95354-REQ1 REV.1 AND EI F2025A53M-2043 REV 1.SDR IPXA2025091824996Stringer · crackedSTRINGER CRACK, FWD SIDE OF STA 2598 S-7R LEVEL 2. ACCOMPLISHED REPAIR IAW EO-95138-REQ1 REV.1 AND EGAT EI F2025A53M-2075 REV.0 AND SRM 53-80-03-2R-2 REV.46 / TR53-152 AND EGAT WORK SHEET NR.50683.