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 SWAA2025100611564Support Bracket · crackedCRACK SUPPORT BRACKET LOCATED BS540 AT LEVEL RBL 6 AT AIR CONDITIONING BAY. REPLACED SUPPORT BRACKET LOCATED BS540 AT LEVEL RBL 6 AT AIR CONDITIONING BAY IAW B737-800 SRM 51-10-2-0G-0 ITEM 9 AND SRM 51-40-02-0G-0. MEASURES OF CRACK IS: L=0.818.SDR SWAA2025100611557Channel · crackedCRACK CHANNEL OB FIXED LEADING EDGE BTW OFSS 564 AND OFSS 580 AT RT WING. REPLACED CHANNEL OB FIXED LEADING EDGE BTW OFSS 564 AND OFSS 580 AT RT WING IAW SRM 51-10-02-0G-0 ITEM 9; SRM 51-40-02-0G-0 AND DWG:112A4402; SHEET:41; REV A. MEASURE OF CRACK IS L: 0.SDR SWAA2025100611554Strap · corrodedCORROSION STRAP O/B FIXED LEADING EDGE AT LEVEL OFSS 584 AT RT WING. REFER TO FAULT TT8Q014Z6U7 WHERE 25-157-02455 WAS ADDED AS A SUBTASK.SDR SWAA2025100611326Strap · corrodedCORROSION ON STRAP O/B FIXED LEADING EDGE AT LEVEL OFSS 456 AT RT WING. PERFORMED REPAIR ON STRAP O/B FIXED LEADING EDGE AT LEVEL OFSS 456 OR ( OSS 227-95) AND OFSS 584 OR ( OSS 349.91) AT RT WING IAW EA 25-157-02455 AND EA 25-157-02455 WIP 1.SDR SWAA2025100611325Strap · corrodedCORROSION ON STRAP OTBD FIXED LEADING EDGE AT LEVEL OFSS 456 AT RT WING. REFER TO FAULT TTG8Q014Z6U7 WHERE 25-154-02455 WAS ADDED AS A SUBTASK. LOC. OFSS 456 (OSS 227.95);[03] FAULT RESOLVED ON OTHER FAULT.SDR SWAA2025100611311Web · crackedCRACK WEB ON OUTBOART FAN COWL ENGINE 2. REPLACED WEB LOCATED ON OUTBOARD FAN COWL OF ENGINE 2 IAW CMM 71-13-30, PAGE 10088, FIGURE 3, SHEET 1, DETAIL P, TABLE OF PAGE 10105, AND SRM 51-40-02-0G-0. MEASUREMENTS OF CRACK IS: 1.025 INCH.SDR JJBA20251006009Support · corrodedRF1, AFT RADIO ALTEMETER ANTENNA INTERNAL RETAINER BTW FR 68-70 FOUND CORRODED. RFI, AFT RADIO ALTIMETER ANTENNA, INTERNAL RETIANER BTW FR 68-70 BLENDED AND FOUND OF LIMIT. REMOVED AND INSTALLEDSDR AALA202510046654Rail · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT AFT BULKHEAD LOWER LOBE RAIL AT BS 500I, S25L. REPLACED SUPPORT RAIL PER AARD 51-00-05-1.SDR AALA202510045836Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM BS 500I TO BS 500C, AT S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202510045024Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM BS 400 TO BS 500I, AT S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR SWAA2025100311315Rail · corrodedCORROSION ON RAIL NUT-PLATE LOCATED OFSS 449 INTERNAL CAVITY LEADING EDGE AT LT WING. REPLACED RAIL NUT-PLATE AND FASTENERS LOCATED OFSS 449 INTERNAL CAVITY LEADING EDGE AT LT WING IAW B373-800 SRM 51-40-02 AND 51-10-02 APPLIED PROTECTIVE TREATMENT ON NEW FASDR SWAA2025100311316Rail · corrodedCORROSION ON RAIL NUT-PLATE LOCATED OFSS 332 INTERNAL CAVITY LEADING EDGE AT LT WING . REPLACED RAIL NUT-PLATE AND FASTENERS LOCATED OFSS 332 INTERNAL CAVITY LEADING EDGE AT LT WING IAW B373-800 SRM 51-40-02 AND 51-10-02 ITEM 9. APPLIED PROTECTIVE TREATMENT OSDR SWAA2025100311550Rail · corrodedCORROSION ON RAIL NUT-PLATE LOCATED OFSS 286 INTERNAL CAVITY LEADING EDGE AT LT WING. REPLACED RAIL NUT-PLATE AND FASTENERS LOCATED ON OFSS 286 AT INTERNAL CAVITY OF LEADING EDGE OF LT WING IAW SRM 51-40-02-0G-0 AND DRAWING NUMBER: 112A4402; SHEET: 41; REV: ASDR SWAA2025100311330Rail · crackedCRACK ON RAIL NUT-PLATE LOCATED OFSS 385 INTERNAL CAVITY LEADING EDGE AT LT WING. REPLACED RAIL NUT-PLATE AND FASTENERS LOCATED OFSS 385 INTERNAL CAVITY LEADING EDGE AT LT WING I.A.W B737-800 SRM 51-40-02 AND DWG 112A4402 SHEET 41 REV A.SDR SWAA2025100311322Rail · crackedCRACK ON RAIL NUT-PLATE LOCATED OFSS 604 INTERNAL CAVITY LEADING EDGE AT LT WING. REPLACED RAIL NUT-PLATE AND FASTENERS LOCATED ON OFSS 604 AT INTERNAL CAVITY OF LEADING EDGE OF LT WING IAW B737-800 SRM 51-40-02-0G-0 AND DRAWING 112A4402; SHEET: 41; REV: A.SDR SWAA2025100311331Rail · corrodedCORROSION ON RAIL NUT-PLATE LOCATED OFSS 308 INTERNAL CAVITY LEADING EDGE AT LT WING. REPLACED RAIL NUT-PLATE AND FASTENERS LOCATED OFSS 308 INTERNAL CAVITY LEADING EDGE AT LT WING IAW SRM 51-40-02 AND DWG 112A4402 SHEET 40 REV A.SDR SWAA2025100311565Angle · crackedCRACK ON ANGLE LOCATED AUXILIARY TRACK LOWER POSITION SLAT 7 AT RT WING. REPLACED ANGLE LOCATED AUXILIARY TRACK LOWER POSITION SLAT 7 AT RT WING IAW B737-800 SRM 51-40-02 AND SRM 51-10-02 ITEM 9.SDR HNAA2025100300675Shear Tie · damagedFRAME 3 BETWEEN STR 14R AND 17R IS DENTED AND BENT AT SKIN ATTACHMENT FLANGE. RAR FR3 BETWEEN STGR 11R-19R IAW EMB 145 SRM 51-40-02SDR HNAA2025100300667Frame · damagedFRAME 4 IS DAMAGED AT STGR 15R. REPAIRED FR 4 DAMAGE AT STR 15R IAW PIEDMONT EO1-53-25-0327 AND ETD2025-145-927854.SDR HNAA202510030075Frame · damagedFRAME 3 BETWEEN STR 14R AND 17R IS DENTED AND BENT AT SKIN ATTACHMENT FLANGE. RAR FR3 BETWEEN STGR 11R-19R IAW EMB 145 SRM 51-40-02SDR HNAA2025100300674Stringer · damagedSTRINGER 14R HAS AN OVERSIZED HOLE AT FR2. RAR STRINGER 14R BTW FR 1A-6 IAW EMB 145 SRM 51-40-02. DURING REPLACEMENT FOUND 13 HOLES BETWEEN FR 2-3 TO ONLY HAVE 1.5D EDGE DISTANCE. 13 HOLES ARE ACCEPTED AS A PERMANENT REPAIR IAW ETD2025-145-928801 AND EO1-53-2SDR HNAA2025100300676Frame · damagedFRAME 4 IS DAMAGED AT STGR 15R. REPAIRED FR 4 DAMAGE AT STR 15R IAW EO1-53-25-0327 AND ETD2025-145--927854.SDR SWAA2025100212739Fairing · temp repairPREVIOUS TEMP REPAIR NOTED ON FAIRING 193CR. TEMP REPAIR REMOVED AND REPLACED WITH A PERMANENT REPAIR IAW SRM 51-70-05-2R-2.SDR SWAA2025100211566Support Angle · crackedCRACK CARGO LINER SUPPORT ANGLE LOCATED STA 727B AND BTW STR 17L TO STR 18L AT AFT CARGO COMPARTMENT. PERFORMED REPAIR SUPPORT ANGLE LOCATED STA 727B AND BTW STR 17L TO STR 18L AT AFT CARGO COMPARTMENT IAW SRM 51-70-11-2R-0.SDR AALA202510023288Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO BAY FLOOR INTERCOSTAL AT BS 500I, S25L. REPLACED THE INTERCOSTAL IAW AARD 51-00-05-1.SDR SWAA2025100111617Scuff Plate · crackedCRACK FWD CORNER SCUFF PLATE AT AFT CARGO COMPARTMENT. REPAIRED AT FWD CORNER SCUFF PLATE AT AFT CARGO COMPARTMENT I. A.W. B737-700 SRM 53-60-15-2R-1; REPAIR 1.SDR SWAA2025100120087A/C Pack · odorSTRONG BURNING ODOR NOTED. C/W CONDITIONAL INSPECTION IAW AMM 05-51-56. BELIEVE SMELL TO BE COMING LT PACK REF LP 2444827 FOR FAULT INFO AND MELSDR SWAA2025092911530Plate · crackedCRACK CORRUGATED PLATE LOCATED ORSS290 TRAILING EDGE AT LT WING. REPLACED CORRUGATED PLATE LOCATED ORSS290 TRAILING EDGE AT LT WING IAW SRM 51-40-02 AND SRM 51-10-02 ITEM 9.SDR SWAA2025092911306Support Angle · crackedCRACK ANGLE SUPPORT LOCATED ORSS269 TRAILING EDGE AT RT WING. REPLACED ANGLE SUPPORT LOCATED ORSS269 TRAILING EDGE AT RT WING IAW B737-700 SRM 51-10-02 ITEM 9 AND DWG 115A2930 SHEET:8 REV:-.SDR VNAA202509260016Drag Angle · damagedELONGATE HOLES ON VERTICAL STABILIZER UNDER RH FWD DRAG ANGLE BTW 55.62% STGR DATUM TO 61.56% STGR DATUM. RH FWD DRAG ANGLE BTW 55.62% STGR DATUM TO 61.56% STGR DATUM WAS REPAIRED PER REO 670-55-31-196 REV.-ASDR SWAA2025092611310Nut · deterioratedDETERIORATED ASSIST HANDLE NUT SERVICE DOORWAY LINING AT AFT GALLEY AREA (2EA). REPLACED ASSIST HANDLE NUT SERVICE DOORWAY LINING AT AFT GALLEY AREA (2EA) IAW AMM 25-21-25-420-801 STEP 3.B.(5).SDR SWAA2025092611308Nut · deterioratedDETERIORATED ASSIST HANDLE NUT ENTRY DOORWAY LINING AT AFT GALLEY AREA (2EA). REPLACED ASSIST HANDLE NUT ENTRY DOORWAY LINING AT AFT GALLEY AREA (2EA) IAW AMM 25-21-25-420-801 STEP 3.B.(5).SDR SWAA2025092611307Nut · deterioratedDETERIORATED ASSISTLE HANDLE NUT ENTRY DOOR LINING AT AFT GALLEY AREA (2EA). REPLACED ASSIST HANDLE NUT ENTRY DOOR LINING AT AFT GALLEY AREA (2EA) IAW AMM 52-13-31-400-802 STEP 3.G.(2).SDR SWAA2025092611309Nut · deterioratedDETERIORATED ASSIST HANDLE NUT SERVICE DOOR LINING AT AFT GALLEY AREA (2EA) . REPLACED ASSIST HANDLE NUT SERVICE DOOR LINING AT AFT GALLEY AREA (2EA) IAW B737-700 AMM 52-13-31-400-802 STEP 3.G.(2).SDR SWAA2025092611304Angle · crackedCRACK ANGLE LOCATED ORSS282 TRAILING EDGE AT RT WING. REPLACED ANGLE LOCATED ORSS282 TRAILING EDGE AT RT WING IAW SRM 51-40-02 AND SRM 51-10-02 ITEM 9 DWG:115A6200 SHEET:10 REV.-SDR SWAA2025092611531Beam · elongatedELONGATED HOLE ON BEAM LOCATED ORSS281 TRAILING EDGE AT LT WING 2025-549032<[01] REAMED HOLE ON BEAM LOCATED ORSS281 TRAILING EDGE AT LT WING IAW B737-700 SRM 51-40-05-0G-0 FIGURE 4 SHEET 3 TABLE B.<BR>SEE INDIVIDUAL SIGNS OFF BELOW;[02] CERTIFIED ACTION 1; COSDR SWAA2025092611528Support Angle · crackedCRACK SUPPORT ANGLE LOCATED ORSS269 TRAILING EDGE AT LT WING. REPLACED SUPPORT ANGLE LOCATED ORSS269 TRAILING EDGE AT LT WING IAW SRM 51-40-02 AND #DWG: 115A2930 SHEET: 7 REV:-.SDR SWAA2025092611305Web · crackedCRACK WEB LOCATED ORSS269 TRAILING EDGE AT RT WING. REPLACED WEB LOCATED ORSS269 TRAILING EDGE AT RT WING IAW B737-700 SRM 51-10-02-0G ITEM 9; SRM 51-40-02-0G AND DWG: 115A2982; SHEET: 4; REV: -.SDR SWAA2025092611529Web · crackedCRACK WEB LOCATED ORSS269 TRAILING EDGE AT LT WING. REPLACED WEB LOCATED ORSS269 TRAILING EDGE AT LT WING IAW SRM 51-40-02 AND SRM 51-10-02 ITEM 9..SDR SWAA2025092611533Support Angle · crackedCRACK ON SUPPORT ANGLE ACCESS PANEL 323AL AT VERTICAL STABILIZER. REPLACED SUPPORT ANGLE ACCESS PANEL 323AL AT VERTICAL STABILIZER IAW B737-700 SRM 51-40-02 AND SRM 51-10-02 ITEM 9 DWG 172A6122 SHEET 1 REV B.SDR VNAA202509250011Hinge · not reportedPERM REPAIR - PASSENGER DOOR SURROUND STRUCTURE - HINGE REPLACEMENT REPLACE THE PASSENGER DOOR HINGE IN ACCORDANCE WITH CRJ700 SRM TASK 53-21-23-201-007- A01. PIANO HINGE OF PASSENGER DOOR WAS REPLACED PER CRJ700 SRM 53-21-23-201-007-A01SDR AALA202509252909Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE, CORROSION ON PASSENGER CABIN FLOORBEAM UPPER TEE CHORD LOCATED AT R2 DOOR AFT GIRT BAR TIEDOWN, BS 986, RBL 44. REPAIRED UPPER TEE CHORD IAW SRM 53-70-51-2R, REPAIR 6, ALTERNATIVE 4.SDR SWAA2025092411423Angle · crackedLEFT WING ANGLE ASSY INBD OF MIDFLAP DEFLECTION RIB IS CRACKED. REMOVED THE LT WING ANGLE ASSY IAW SRM 51-40-02. LOCATED AND DRILLED FASTENER HOLES IN THE NEW ANGLE IAW SRM 51-40-05. INSTALLED THE NEW ANGLE ASSY IAW SRM 51-10-02 & SRM 51-40-02.SDR IPXA2025092009730Bracket · crackedRIGHT A/C PACKS CONICAL BELLCRANK BRACKET CRACKED. REMOVED BRACKET AT STR-RT A/C PACKS IAW SRM 5I-40-21. INSTALLED NEW BRACKET IAW A300-600 SRM 51-40-21.SDR JJBA20250924036Floor Support · corrodedCFIII, LH SILL BTW FR 35-42 FOUND CORRODED. CF3, LH SILL BTW FR 35-42 FOUND OUT OF LIMITS. CF3, LH SILL BTW FR 35-42 REMOVED AND REPLACED.SDR SCNA20250923388Failsafe · corrodedWO 98143, NR00005 FAS# 4686 WHILE WORKING TASK CARD 737-53A1414-01-NDT_UT FOUND CORROSION ON FAILSAFE STRAP AT STA 663.75 LH SIDE (AD RELATED) - FAS#6574COMPLIED WITH FAS EA 25015 REV IR/AT BSTA 663.75 BULKHEAD/LH PICKLE FORK FITTING/FAIL SAFESTRAP/CORROSIONSDR AALA202509222288Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT RIGHT PASSENGER / CREW DOOR CUTOUT LOWER SILL CENTER SHAPE FITTING BETWEEN FR 66 AND FR 68 AT S23R. REPLACED CENTER SHAPE FITTING PER SRM 51-42-11.SDR JJBA20250922032Floor Support · corrodedCFIII, LH SILL BTW FR 41-48 FOUND CORRODED. CF3, LH SILL BTW FR 41-48 FOUND OUT OF LIMITS. CF3, LH SILL BTW FR 41-48 REMOVED AND REPLACED.SDR IPXA2025091709687Stringer · crackedCENTER WING UPPER FUEL TANK LOWER STRINGER 41 CRACK AT XCW = -81 REQUIRES PERMANENT REPAIR PER EO 81811-REQ001 ATA 57-11 QC AUDIT C/WSDR JJBA20250917026Doubler · corrodedRIGHT DIGITAL AT FR22 FOUND CORRODED. AT CF1, RT DIGITAL AT FR22 DOUBLER BLENDED OUT OF LIMIT. AT CF1, RT DIGITAL AT FR22 DIGITAL REMOVED AND INSTALLED.