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 SCNA20251113436Frame · crackedCRACK ON FRAME STA 312 & S-6L AT PASSENGER CABIN . FRAME BS 312, S6L AT PASSENGER CABIN WAS REPAIRED PER SRM 53-10-07-2R-1 REPAIR 1.SDR SWAA2025111222788Access Panel · damagedELONGATED HOLES ON ACCESS PANEL 661BB TRAILING EDGE AT RT WING. REPAIRED ACCESS PANEL 661BB TRAILING EDGE AT RT WING IAW B737-700 SRM 51-70-04-2R-10 REPAIR 10.SDR SWAA2025111222790Access Panel · damagedELONGATED HOLES ON ACCESS PANEL 661AB TRAILING EDGE AT RT WING . REPAIRED ACCESS PANEL 661AB TRAILING EDGE AT RT WING IAW B737-700 SRM 51-70-04-2R-10 REPAIR 10.SDR SWAA2025111222791Access Panel · elongatedELONGATED 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-10 REPAIR 10.SDR SWAA2025111122651Threshold Web · corrodedFWD CARGO BAY CORROSION ON DOOR SURROUND STRUCTURE SUB THRESHOLD WEB AT FASTENER HOLES; BS 440 - 490. REMOVED AND REPLACED SUB THRESHOLD WEB IAW SRM 51-40-02, AND DWG 143A8330, REV-.SDR SWAA2025111122768Intercostal · corrodedCORROSION ON INTERCOSTAL BETWEEN BS 294.5 - 304, S21L. REMOVED AND REPLACED THE INTERCOSTAL, CUSTOMER RO 1060146-SWA, IAW SRM 51-40-02-0G-0, AND DWG 142A0070, REV -.SDR SWAA2025111122767Intercostal · corrodedCORROSION ON INTERCOSTAL BETWEEN BS 330 - 344, S22L. REMOVED AND REPLACED THE INTERCOSTAL IAW SRM 51-40-02, AND DWG 141A8131.SDR SWAA2025111122769Stub Frame · crackedCRACK FOUND ON FWD STUB FRAME .3 INCHES ABOVE SEAL DEPRESSOR, WL 206 + 52.5. NO ALLOWABLE DAMAGE FOUND IN SRM, UPPER STUB FRAME TO BE REPAIRABLE BY REPLACEMENT IAW SRM 51-10-02; STEP 9. REMOVED FWD GALLEY DOOR UPPER STUB FRAME IAW SRM 51-40-02. LOCATED AND SDR J7SA2025111000460Acm · faultedBURNING SMELL ON DESCENT ACCOMPANIED BY VERY WARM AIR. AIRCRAFT LANDED WITHOUT INCIDENT AT KSSI. AFTER LANDING, CREW RECEIVED AMBER PACK TEMP HIGH CAS ON SYNOPTIC. REPLACED AIR CYCLE MACHINE. PERFORMED SUCCESSFUL OPS CHECK AND LEAK CHECK IAW CH 300 AMM 21-52-1SDR IPXA2025110459260Adapter · corrodedMAIN CABIN - SEAT TRACK ADAPTER SEGMENT CLS WITH CORROSION BTW FR20 AND FR27 BTW Y1580 & Y2244. INSTALLED NEW TRACK ADAPTER CLS SEGMENT IAW A300-600 SRM 51-40-21. REVIEWEDSDR IPXA2025110561418Adapter · corrodedMAIN CABIN - CLS ADAPTER WITH CORROSION AT FR 27 Y0 RH. INSTALED CLS ADAPTER I.A.W. A300-600 SRM 51-40-21 . REVIEWEDSDR IPXA2025102461494Adapter · corrodedMAIN CABIN - SEAT TRACK CLS ADAPTER WITH CORROSION AT FR 27 Y0 LT. INSTALLED CLS ADAPTER IAW SRM 51-40-21.SDR CALA2025110410883Door Frame · crackedCRACK AT UPPER L/1 DOOR FRAME LOWER CORNER STA. 312 STR 5-6L. ACCOMPLISHED REPAIR OF FUSESALGE FRAME AT STA 312 AT STR 5L AND 6L AS PER SRM 53-10-07-2R-1, PENDING ESFR ENTRY, DIP REQUIRED AS PER TABLE 202,INSPECTION THRESHOLD 50,000 FLIGHT CYCLES OR 12,000 FSDR IPXA2025102356354Profile · damagedMAIN CABIN - Z-PROFILE CRACKED BTW FR73-FR74 -Y2127.6. REMOVED Z-PROFILE IN MAIN CABIN BTW FR73-FR74 -Y 2127.6 IAW AIRBUS A300-600 SRM 51-40-21. INSTALLED NEW Z-PROFILE AT FR73-FR74 -Y2127.6 IAW AIRBUS A300-600 SRM 51-40-21.SDR SWAA2025103022363Rib · crackedFOUND CRACK LOCATED AT RT HORIZONTAL STAB NR 4 RIB STAB STA 120.30 NR 1 VERTICAL STIFFENER. REPAIRED IAW SRM 55-10-09-2R-4.SDR SWAA2025103022364Rib · crackedFOUND CRACK LOCATED AT RT HORIZONTAL STAB NR 4 RIB STAB STA 120.30 NR 4 VERTICAL STIFFENER. REPAIRED IAW SRM 55-10-09-2R-5.SDR SWAA2025103022362Rib · crackedFOUND CRACKS LOCATED AT RT HORIZONTAL STAB NR 4 RIB HSS 120.30, FRONT SPAR ATTACH STIFFENER. REMOVED AND REPLACED RT HORIZONTAL STAB RIB FRONT STIFFENER IAW SRM 51-40-02-0G-0 AND DWG 142A2401 REV:F.SDR IPXA2025101658777Adapter · corrodedMAIN CABIN - CLS ADAPTER WITH CRACK AT FR37 BTW Y1580.5 & Y2127.5. INSTALLED CLS ADAPTER IAW A300 SRM 51-40-21.SDR IPXA2025102461059Hinge Fitting · corrodedFAULT - STR Z400 - ENG #2 O/B FAN COWL, AFT ATTACH SUPPORT DAMAGED. DOT 90-038. ++REPLACED FAN COWL HINGE AT STR Z400 - ENG #2 O/B FAN COWL, AFT ATTACH SUPPORT IAW A300-600 SRM 51-40-21SDR SWAA2025102822826Tail Cone · delaminatedDELAMINATED TAIL CONE RIGHT SIDE ON EXTERNAL SKIN. REPAIRED TAIL CONE RIGHT SIDE ON EXTERNAL SKIN IAW SRM 51-70-04-2R-1, REPAIR 1.SDR IPXA2025101655510Profile · crackedMAIN CABIN - T-PROFILE CRACKED AT FR80/82 -Y2127. REMOVED T-PROFILE IN MAIN CABIN AT FR80/82 -Y 2127. IAW SRM 51-40-21. INSTALLED. MAIN CABIN NEW T-PROFILE AT FR80/82-Y2127 IAW SRM 51-40-21 USED.SDR SIMA20251028007Floorbeam · corrodedSSI 53-23-005: AFT GALLEY LH FLOOR BEAM CORRODED AT FR 87 (MAJOR REPAIR) (LEVEL 2 CORROSION). RAR THE LH FLOOR BEAM AT FR87 IAW ERJ 175 SRM 51-40-08SDR ASAA2025100861823Web · corrodedFWD PIT LOWER SILL WEB HAS SPOTS OF CORROSION. GROUNDED - YES. REMOVED AND REPLACED FWD PIT LOWER SILL WEB IAW B737-700 SRM 51-40-02-0G-0W= 1" O= .045 R= .033 L= 1" D= .012.SDR ASAA2025100861819Web · corrodedAFT PIT LOWER SILL WEB HAS CORROSION. GROUNDED - YES. REMOVED AND REPLACED AFT PIT LOWER SILL WEB IAW SRM 51-40-02-0G-0W= 1" O= .045 R= .031 L= 1" D= .014.SDR SIMA20251008005Seat Track · corrodedSSI 53-23-005: RH CENTER SEAT TRACK CORRODED BTWN FR 84-85 (MAJOR REPAIR) (LEVEL 2 CORROSION). CUTOUT DAMAGED SECTION AND INSTALLED REPAIR SPLICE ON THE RH CENTER SEAT TRACK BTWN FR 84-85 IAW ENVOY ERS-EJ-53MR-5273SDR SIMA20251008006Floorbeam · corrodedSSI 53-23-005: AFT GALLEY RH CENTER FLOOR BEAM SPLICE CORRDED AT FR 89 (LEVEL 2 CORROSION). RAR AFT GALLEY RH CENTER FLOOR BEAM SPLICE AT FR 89 IAW ERJ 175 SRM 51-40-08.SDR CALA2025102610526Baffle · corroded(SUPPORT TASK) FWD CARGO PIT AT S-26 BETWEEN BS 500E - BS 500F BAFFLE IS CORRODED ON UPPER FLANGE. AFTER INVESTIGATION OF DAMAGE AREA IT WAS CONCLUDED THAT MATERIAL IS FOUND TO BE 100% OUT OF LIMITS DUE TO EVIDENT EXFOLIATION IAW SRM 53-00-53-1A-2 FIG 103. RSDR CALA2025102610524Transition Panel · corrodedAFT CARGO COMPARTMENT RIGHT SIDE TRANSITIONAL PANEL BETWEN STA 727H-727I HAS CORROSION. MARKED WITH RED PEN. REMOVED AND REPLACED TRANSITION PANEL FROM BS727-727I USING 'Z' ANGLE PN# BAC1496-377 7075-T62 FOR 2EA TRANSITION PANELS AND 1EA SPLICE REPAIR PARTS ISDR CALA2025102610522Seat Track · corrodedSUPPORT TASK: MAIN CABIN SEAT TRACK AT LBL45 STA 700-727 HAS MULTIPLE GOUGES AND CORROSION. REMOVED CORROSION FROM MAIN CABIN SEAT TRACK STA 700-727 LBL45. MATERIAL REMOVED 0.028, MAX MATERIAL ALLOWED IS 0.020, SEAT TRACK SECTION FOUND OUT OF LIMITS IAW B737SDR IPXA2025102355969Profile · damagedMAIN CABIN - Z-PROFILE CRACKED AT FR75 Y2127.6. REMOVED Z-PROFILE IN MAIN CABIN AT FR75 Y 2127.6 IAW SRM 51-40-21. INSTALLED NEW Z-PROFILE AT FR75 Y2127.6 IAW SRM 51-40-21.SDR IPXA2025102356317Web · damagedMAIN CABIN - WEB CRACKED BTW FR73-FR74 Y2127.6. REMOVED WEB IN MAIN CABIN BTW FR73-FR74 Y2127.6 IAW SRM 51-40-21. ++INSTALLED NEW WEB BTW FR73-FR74 Y2127.6. IAW SRM 51-40-21.SDR IPXA2025102356212Web · crackedMAIN CABIN - WEB CRACKED BTW FR73-FR74 -Y2127.6. REMOVED Z-PROFILE IN MAIN CABIN BTW FR73-FR74 -Y 2127.6 IAW SRM 51-40-21. INSTALLED NEW Z-PROFILE AT FR73-FR74 -Y2127.6 IAW SRM 51-40-21.SDR AALA202510242450Seat Track · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN CABIN SEAT TRACK BETWEEN FR47.1 AND FR47.2 AT +Y1292. REPLACED SEAT TRACK PER SRM 51-42-11.SDR SIMA20251008002Floorbeam · corrodedSSI 53-23-005: AFT GALLEY RH CENTER FLOOR BEAM SPLICE CORRDED AT FR 90 (LEVEL 2 CORROSION) RAR AFT GALLEY RH CENTER FLOOR BEAM SPLICE AT FR 90 IAW ERJ 175 SRM 51-40-08SDR SIMA20251008004Shear Panel · corrodedAFT GALLEY CENTER SHEAR PANEL CORRODED (LEVEL 2 CORROSION) RAR AFT GALLEY CENTER SHEAR PANEL IAW ERJ 175 SRM 51-40-08.SDR SIMA20251008003Shear Panel · corrodedAFT GALLEY RH SHEAR PANEL CORRDED (LEVEL 2 CORROSION) RAR AFT GALLEY RH SHEAR PANEL IAW ERJ 175 SRM 51-40-08.SDR IPXA2025102261418Adapter · corrodedMAIN CABIN - CLS ADAPTER (SEAT TRACK) WITH CORROSION AT FR 27 Y0 RH VERIFIED INSTALLATION OF CLS ADAPTER IAW SRM 51-40-21. OPENSDR IPXA2025102261494Adapter · corrodedMAIN CABIN - CLS ADAPTER (SEAT TRACK) WITH CORROSION AT FR 27 Y0 LT VERIFIED INSTALLATION OF CLS ADAPTER IAW A300-600 SRM 51-40-21 (1 TUBE QTY). OPENSDR AALA202510232141Door Frame · chafedAIRCRAFT IN BASE MAINTENANCE: FORWARD ENTRY DOOR FORWARD FRAME MOUNTED LOWER END LATCH TRACK FITTING HAS A CHAFE, TRACK AREA. REMOVED AND REPLACED FORWARD ENTRY DOOR FORWARD FRAME-MOUNTED LOWER RECEIVER, PER B737NG SRM 51-40-02-0G AND PERFORMED SATISFACTORY ADSDR CALA2025102310449Web · crackedSURVEY OF THE LT INSP AREA SHOWS EVIDENCE OF A PREVIOUS REPAIR. PERFORMED REPAIR PER PART 1 INTERIM REPAIR IAW EC/RA 5330-07609 AND REO-L25569 REV IR WITH NO DEVIATIONS.SDR IPXA2025102162001Support · crackedRH PYLON PANEL 443KL SUPPORT STRUCTURE HAS (1EA) CRACK. REMOVED RH PYLON PANEL 443KL SUPPORT STRUCTURE IAW B757-200PF SRM 51-40-02. ++INSTALLED NWE SUPPORT AT RH PYLON IAW B757-200PF SRM 51-40-02. INSTALLED PANELS: 442AL, 443KL.SDR IPXA2025102158491Seat Track · corrodedMAIN CABIN - SEAT TRACK WITH CORROSION AT FR67 Y0. INSTALLED NEW SEAT TRACK BTW FR66-FR67 AND FR68-69 Y0 IAW AIRBUS A300-600 SRM 53-10-16 PAG.207, FIG. 20.SDR SWAA2025102122665Lens · deterioratedAFT ENTRY DOOR( L2) EXTERIOR EMERGENCY LIGHT LENS DETERIORATED. REMOVED AND REPLACED AFT ENTRY DOOR (L2) EXTERIOR LIGHT LENS IAW B737 AMM 33-51-04-960-801.SDR CALA2025102110323Seat Track · corrodedFWD WET AREA Y765 SEAT TRACK AT FR 16 HAS AREA OF CORROSION. R & R FR 12-24 Y765 SEAT TRACK IAW SRM 57-42-21-001.SDR IPXA2025101448379Skin · crackedFAULT-STR-Z400- #2 ENG PYLON LOWER SPAR LOWER SURFACE LH/RH ANGLE CRACKED PROJECTION RIB 18. DOT 139-2. REMOVED 02 EA ANGLE CRAKED AT #2 ENG PYLON LOWER SPAR LOWER SURFACE LH/RH, IAW A300-600 SRM 51-40-21. INSTALLED NEW 01EA ANGLE SECTION LH P/N A545150632040SDR AALA202510209155Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT LEFT PASSENGER / CREW DOOR CUT OUT LOWER SILL CENTER SHAPE FITTING BETWEEN FR 66 AND FR 68 AS T S23L. REPLACED CENTER SHAPE FITTING PER SRM 51-72-11.SDR DXTA2025101305237Probe · defectiveDURING FLT, AMBER FUEL IMBALANCE CAS MESSAGE CAME ON IMMEDIATELY, RT SIDE INCREASE BY 2900 LBS. TOTAL FUEL ALSO INCREASED BY 2900 LBS. FOLLOWED QRH FUEL IMBALANCE. FUEL IMBALANCE BEGAN TO CORRECT. IMBALANCE CONINTUED TO CORRECT & STOPPED. TOTAL FUEL BEGAN SDR SCNA20251020396Window · debondedDISBONDED & OPAQUE WINDOWS (4 EAS) OF PRESSURE GAUGE OF ALL SCAPE SLIDE PACKS. OPENSDR SCNA20251020395Light · inoperativeBROKEN COVER OF EXIT EMERGENCY LIGHT OF DOOR L1. OPENSDR IPXA2025101600639Fuel Sys · out of balanceDURING CLIMB LEVEL 2 LAT FUEL UNBAL UN COMMANDED FUEL CROSS FEED FROM TANK THREE TO ENGINE 1 FUEL DECREASING IN TANK THREE AT A RATE OF BURN FOR TWO ENGINES TANK ONE INDICATING NO DECREASE IN QUANTITY OPS CHK NORMAL OF VALVE AND NO LEAKS NOTED.