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 N6WA2025102302Oxygen Box · brokenCAPTAINS O2 MASK BOX BROKEN. R & R CAPT'S O2 MASK BOX IAW CRJ AMM 35-11-15 OPS CHECK GOOD.SDR KCSA202510231217Floor Support · corrodedMAIN DECK FLOOR SUPPORT FITTING @ BS 1370 LBL 92.5 HAS EVIDENCE OF DAMAGESDR KCSA202510231216Shear Web · corrodedMAIN DECK SHEAR WEB PANEL 152W1209-25, HAS SEVERAL AREAS WITH EVIDENCE OF CORROSION.SDR JR2R20251023404Floorbeam · corrodedCROSS BEAM AT FR 14 BETWEEN RBL 12 TO RBL 48 IS CORRODED. OUT OF LIMITS. REPAIREDSDR KCSA202510231015Shear Web · corrodedMAIN DECK SHEAR WEB PANEL # 152W1209-24, HAS SEVERAL AREAS WITH EVIDENCE OF CORROSION.SDR JR2R20251023406Floorbeam · corrodedFLOOR BEAM AT RBL 11 AND FRAME 87 IS CORRODED. OUT OF LIMITS. REPAIREDSDR DALA2025102307752Unknown · odorFUMES IN AFT GALLEY AREA REPORTED BY F/A ON INBOUND FLIGHT AND AT THE GATE. C/A: C/W WC #0550-2002. DETERMINED TO BE TYPE 9 IN AFT CBN. C/W TROUBLESHOOTING STEPS FOR ELEC / SMOKE ODOR IN AFT CABIN PER FIGURE 4. INSP'D AFT GALLEY (COFFEEMAKERS, C/B'S + C/B PNL)SDR AALA202601152253Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR BEAM UPPER CHORD TEE FITTING AT BS 967, LBL 48. REPAIRED UPPER TEE FITTING PER EA 369387.SDR AALA202601159331Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT BS 947, LBL 48. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202601153081Support Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT SIDEWALL SUPPORT ANGLE AT BS 500D, LBL 25. REPLACED SUPPORT ANGLE PER AARD 51-00-05-1.SDR AALA202601140077Support Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT SIDEWALL SUPPORT ANGLE AT BS 500D, RBL 25. REPLACED SUPPORT ANGLE PER 51-00-05-1.SDR AALA202601148200Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL AT BS 907 PLUS 5 INCHES, AT RBL 23. REPLACED TRANSITION PANEL PER AARD 51-00-05.SDR AALA202601140239Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR SUPPORT INTERCOSTAL FROM BS 967 TO BS 986 AT LBL 16. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202601143082Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO PASSENGER CABIN FLOOR SUPPORT INTERCOSTAL FROM BS 947 TO BS 967 AT LBL 25. REPLACED INTERCOSTAL PER AARD 51-00-05-1SDR AALA202601139319Bracket · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION AROUND FASTENER HOLE ON FRAME BRACKET AT BS 500D FROM S21R TO S22R. REPAIRED BRACKET PER EA 369468.SDR DALA2026010600103Floorboard · delaminatedDURING OVERNIGHT WORK FOUND FLOORBOARD AT ROW 30G DELAMINATED. REMOVED FLOOR BOARD AT 30G PER A350 AMM 53-XX. REQ REPAIR. (WIP 917171). ACCOMPLISHED TEMPORARY REPAIR PER ASR A350-A-53-02-XX- 04001-662A-A. DEFERRED TO NEXT C CHECK. FLOOR PANEL REINSTALLED. MPN SDR SWI2025F01865Frame · corrodedBS 589 LOWER FLANGE WAS CORRODED AND PEELING PAINT FROM JUST UNDER CARGO DOOR SILL TO STRINGER 20R IN SEVERAL AREAS. REMOVED AND REPLACED THE FRAME BS 589, S20R - S20L IAW SRM 51-42-06, & 51-42-21.SDR SWI2025F01864Frame · corrodedBS 605 HAS CORROSION AND BARE METAL ON FWD SIDE OF FRAME & UPPER SURFACE OF LOWER FLANGE FROM JUST BELOW CARGO DOOR SILL TO S23R. R & R FRAME SECTOR BS 605, FROM S20R - 20L INSTALLED & FRAME SECTOR BS 605.00 FROM STRINGERS 17L - 20L. INSTALLED SRM 51-42-06, SDR SWIA202512230022Frame · corrodedUPPER FLANGE OF BS 589 HAS CORROSION ON UPPER SURFACE FROM S25L - S26R. R & R FRAME SECTION AT BS 589 FROM S25L - S26R IAW SRM 51-42-06SDR IPXA2025120998823Access Door · corrodedCORROSION AT LOWER HINGE OF LAV DUMP ACCESS DOOR. AIRFRAME SIDE. INSTALLED 1EA FWD TOILET SERVICE DOOR AND (1EA) LOWER HINGE ASSY FROM FORWARD TOILET SERVICE PAN IAW AMM 52-49-06-404-012 AND SRM 51-40-02-0G-0SDR IPXA2025110198823Hinge · corrodedCORROSION AT LOWER HINGE OF LAV DUMP ACCESS DOOR. AIRFRAME SIDE. 61-009. OPENSDR KCSA2025102269Door · no discrepancyDOOR U/D FLT LK. PERFORMED OPERATIONAL TEST IAW B747-400 AMM CHP 52-23-00. COULD NOT DUPLICATE SYS OPS CHECKS NORMAL.SDR SWAA2025120427310Skin · crackedCRACKED LOWER SURFACE OF LEADING EDGE SLAT NR 6 SKIN AT ACTUATOR LOCATION, AROUND FASTENER ON RT WING. PERFORMED PERMANENT REPAIR IAW SRM 57-42-01-2R-8, REPAIR 8.SDR SWAA2025120127305Strap · corrodedCORROSION AFT CARGO BAY FLOOR SPLICE STRAP AROUND NUT PLATE HOLE BS 727D+6, RBL 11.5, WL 156. EVALUATED CORROSION OF FLOOR STRAP. FOUND TO BE OUT OF LIMITS, RECEIVED NEW STRAP AND APPLIED WHITE ENAMEL ALL IAW SRM 51-10-02, AMM 51-21-73-370-804, AND ACO 5360SDR SWAA2025120127295Shield · corrodedCORROSION AFT CARGO BAY SHIELD FWD OF CARGO DOOR AROUND MULTIPLE NUT PLATE HOLES BS 767+3 - 794, RBL 22, WL 156. FOUND TO BE OUT OF LIMITS DUE TO NO LIMITS GIVEN IN THE SRM. REMOVED, REPLACED, AND INSTALLED A NEW SHIELD IAW SRM 51-10-02, SRM 51-40-05-0G-0, SSDR SWAA2025120127291Support Plate · corrodedCORROSION AFT CARGO BAY LT FLOOR TO SIDEWALL SUPPORT PLATE MULTIPLE AREAS AROUND NUT PLATE HOLES, BS 727B - 767, LBL 22, WL 156. CORROSION ON AFT CARGO BAY L/H FLOOR TO SIDEWALL SUPPORT PLATE; FOUND TO BE OUT OF LIMITS. REMOVED, REPLACED, AND INSTALLED A NSDR SWAA2025120127290Sidewall Support · corrodedCORROSION AFT CARGO BAY RT FLOOR TO SIDEWALL SUPPORT PLATE HAS MULTIPLE AREAS AROUND NUT PLATE HOLES, BS 727B - 767, RBL 22, WL 156. CORROSION ON AFT CARGO BAY R/H FLOOR TO SIDEWALL SUPPORT PLATE; FOUND TO BE OUT OF LIMITS. REMOVED, REPLACED, AND INSTALLED SDR SWAA2025120126621Scuff Plate · crackedCRACKED AFT CORNER SCUFF PLATE IN THE FWD CARGO BAY. REPAIRED THE AFT CORNER SCUFF PLATE IAW SRM 53-30-15-2R-1, REPAIR 1, AND BAC 5975.SDR SWAA2025120126957Attach Angle · crackedBS 663, LOWER COMPOSITE BULKHEAD UPPER ATTACH ANGLE IS CRACKED AT LBL 45, WL 165. REMOVED, REPLACED, AND INSTALLED A NEW ATTACH ANGLE IAW SRM 51-40-02-0G-0, AND DWG 111A1000, REV A.SDR SWAA2025120127299Web · corrodedCORROSION AFT CARGO BAY SUB THRESHOLD WEB MULTIPLE AREAS AROUND NUT PLATE HOLES BS 794 - 847, RBL 26, WL 156. REMOVED AND REPLACED THE THRESHOLD WEB IAW SRM 51-40-02, AND DWG:146A8340 REV-.SDR SWAA2025120127296Scuff Plate · crackedFORWARD CARGO BAY AFT CORNER SCUFF PLATE IS CRACKED. WELDED THE CORNER SCUFF PLATE IAW SRM 53-30-15-2R-1, STEP 4.B.(4).SDR SWAA2025120127297Scuff Plate · crackedAFT CARGO BAY AFT CORNER SCUFF PLATE IS CRACKED. WELDED THE CORNER SCUFF PLATE IAW SRM 53-60-15-2R-1, STEP 4.B.(4).SDR SWAA2025120126946Doubler · crackedEGPR SURROUND DOUBLER CRACKED BS 233, WL 175+8, ABOVE S24R. TRIMMED DAMAGED AREA; FABRICATED REPAIR PARTS AND INSTALLED IAW SRM 53-10-15-2R-4, REPAIR 4, PARG 4 (B-M).SDR SWAA2025120127122Handle · deterioratedDETERIORATED ASSIST HANDLE NUT FWD ENTRY AND SERVICE DOORS. REPLACED THE ASSIST HANDLE NUTS IAW AMM 52-11-31-400-802, STEP 3.G (2).SDR SWAA2025120127124Handle · deterioratedDETERIORATED ASSIST HANDLE NUT ON AFT ENTRY AND SERVICE DOORS. REPLACED ASSIST HANDLE NUT AFT ENTRY AND SERVICE DOORS IAW AMM 52-13-31-400-802, STEP 3.G (2), AND AMM 52-41-31-400-802, STEP 3.F (2).SDR SWAA2025120126923Sill Drain · corrodedCORROSION ON UPPER MAN SILL LOCATED BS 440 TO BS 492.5 ABOVE S-19R WL 190 FWD CARGO COMPARTMENT. REPLACED NEW UPPER MAN SILL LOCATED BS 440 TO BS 492.5 ABOVE S-19R WL 190 FWD CARGO COMPARTMENT IAW SRM 51-40-02, SRM 51-10-02, DWG 143A8110, SHEET 20, REV -, ANDSDR SWAA2025120127298Attach Angle · corrodedCORROSION AFT CARGO BAY ATTACH ANGLE UNDER SHIELD HAS MULTIPLE AREAS UNDER NUT PLATES BS 767 TO 787, RBL 21, WL 156. CORROSION ON AFT CARGO BAY ATTACH ANGLE UNDER SHIELD FOUND TO BE OUT OF LIMITS DUE TO NO LIMITS ARE GIVEN IN THE SRM. REMOVED, REPLACED, ANDSDR SWAA2025120127125Handle · deterioratedDETERIORATED ASSIST HANDLE NUT FWD GALLEY 1 AND FWD ENTRY DOORWAY AT FWD GALLEY AREA REPLACED ASSIST HANDLE NUT FWD GALLEY 1 AND FWD ENTRY DOORWAY AT FWD GALLEY AREA (4EA) IAW B737-700 AMM 25-21-31-420-801 ITEM 2. B (2) AND AMM 25-21-31-420-802 ITEM 3. B (6).SDR HNAA2025120100832Floor Support · crackedLEFT OMEGA BEAM CRACKED AT FR22. REPAIRED OMEGA BEAM IAW ETD2025-145-931090SDR HNAA2025120500840Shear Tie · crackedRIGHT SHEAR CLIP CRACKED AT FR 48 BTW S13 & 14R. R & R SHEAR CLIP IAW SRM 51-40-02.SDR HNAA202512010839Floor Support · crackedLEFT OMEGA BEAM CRACKED AT FR 34. REPAIRED IAW ETD2025-145-931170SDR HNAA2025120100838Floor Support · crackedCTR OMEGA BEAM CRACKED AT FR33. REPAIRED IAW ETD2025-145-931166SDR HNAA2025120100837Floor Support · crackedLEFT OMEGA BEAM CRACKED AT FR31. REPAIRED IAW ETD2025-145-931170SDR HNAA2025120100836Floor Support · crackedLEFT OMEGA BEAM CRACKED AT FR33. REPAIRED IAW ETD2025-145-931170. PIEDMONT EO1-53-25-0392 PERFORMEDSDR HNAA2025120100835Floor Support · cracked53-2063 LH OMEGA BEAM CRACKED AT FR36 IB SIDE. REPAIRED IAW ETD2025-145-931162SDR HNAA2025120100834Floor Support · crackedFWD DIGITAL BTW FR16-18 CORRODED. REPAIRED IAW PIEDMONT ESR1-53-24-004SDR HNAA2025120100833Floor Support · crackedLEFT OMEGA BEAM CRACKED AT FR23. REPAIRED BEAM IAW ETD2025-145-931070.SDR HNAA2025120100831Floor Support · crackedLH OMEGA BEAM CRACKED AT FR21. REPAIRED IAW ETD2025-145-931090SDR SWAA2025112826935Support Beam · crackedCRACK TRAILING EDGE DEFLECTION CONTROL RIB SUPPORT BEAM AT RT WING. PERFORMED PERMANENT REPAIR ON TRAILING EDGE DEFLECTION CONTROL RIB SUPPORT BEAM AT RT WING IAW SRM 57-51-02-2R-3SDR JJBA20251125107Profile · corrodedRH FR 61 BTW RH SILL AND RH OMEGA BEAM, T-PROFILE FOUND CORRODED. RH FR 61 BTW RH SILL AND RH OMEGA BEAM, T-PROFILE BLENDED AND FOUND OUT OF LIMITS. RH FR 61 BTW RH SILL AND RH OMEGA BEAM, T-PROFILE WAS REPLACED.