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 SWIA2025F01372Shear Tie · crackedSUSPECTED CRACKED CLIP ANGLE LOCATED AT FS 625.30 AT STGR 14R INTERSECT COMMON TO THE AIRCRAFT SKIN. (MARKED) (S/N#00522) (C-CHECK RO 09/24/2025)INSTALLED NEW CLIP INTERCOSTAL LOCATED AT FS 625.30 AT STGR 14R INTERSECT COMMON TO THE AIRCRAFT SKIN NEW P/N: 60SDR SWIA2025F01371Door Frame · chafedPAX DOOR SURROUND AFT LOWER STOP PIN FITTING HAS EVIDENCE OF CHAFFING. (S/N#00519) (C-CHECK RO 09/24/2025)BLENDED OUT CHAFE ON PAX DOOR SURROUND AFT LOWER STOP FITTING REF. CRJ-200 SRM 51-12-00. COMPLIED WITH STEPS 1-4 OF REO 601R-53-21-3764 REV -- DATE: 202SDR SWIA202509250728Door Frame · chafedPAX DOOR SURROUND FWD LOWER STOP PIN FITTING HAS EVIDENCE OF CHAFFING. (S/N#00518) (C-CHECK RO 09/24/2025)BLENDED OUT CHAFE ON PAX DOOR SURROUND FWD LOWER STOP FITTING REF CRJ-200 SRM 51-12-00 REV 39 MAR 10/21, COMPLIED WITH STEPS 1-4 OF REO 601R-53-21-3764 RSDR AALA202509244150Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED AFT CABIN FLOOR SHEAR PLATE BETWEEN FR 69 AND FR 70 AT S23R. REPLACED SHEAR PLATE PER SRM 51-42-11.SDR AALA202509235185Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED AFT CABIN FLOOR SHEAR PLATE BETWEEN FR 69 AND FR 70 AT S23L. REPLACED SHEAR PLATE PER SRM 51-42-11.SDR FDEA202507281331Floor Panel · damagedMAIN CARGO COMP. AT APROX STA. 350 & 221DFF, LBL 33 - LBL 11 FLOORBOARD PANEL SURFACE SKIN HAS INDENTATIONS (MARKED). FABRICATED NEW FLOOR PANEL 221DFF, MPN: 141T5856-117, LBL 33- LBL 11, STA 285- 391 IN REF. TO BOEING DWG 141T5856-117. SEE JPF FOR ALL THESDR AALA202509091134Fitting · burredAIRCRAFT IN BASE MAINTENANCE: BURRED MATERIAL AT LOWER LATERAL FITTING (LH) OF THE ELECTRONICS RACK 80VU,MEASURE ELONGATED IS L=0.399 INCH. MAINTENANCE ACCOMPLISHED INTERIM REPAIR INSTRUCTIONS ON LOWER LATERAL FITTING (LH) OF THE ELECTRONICS RACK 80VU IAW EA #SDR AALA202509090759Fitting · burredAIRCRAFT IN BASE MAINTENANCE: BURRED MATERIAL AT LOWER LATERAL FITTING (RH) OF THE ELECTRONICS RACK 80VU MEASURE ELONGATED HOLE IS L=0.399 INCH. MAINTENANCE ACCOMPLISHED INTERIM REPAIR INSTRUCTIONS ON LOWER LATERAL FITTING (RH) OF THE ELECTRONICS RACK 80VU IAWSDR SWAA2025090496136Support · corrodedCORROSION SUPPORT ZEE LOCATED BETWEEN STA747 TO STA787 AND LBL21 WL156 AFT CARGO COMPARTMENT. REPLACED SUPPORT ZEE LOCATED BETWEEN STA727 TO STA787 AND LBL21 WL156 AFT CARGO COMPARTMENT IAW SRM 51-40-02; SRM 51-10-02; SRM 53-00-53-2R-6 REPAIR 6 AND DWG 146A75SDR SWAA2025090496135Support · corrodedCORROSION SUPPORT ZEE LOCATED BETWEEN STA727A TO STA727C LBL21 WL156 AFT CARGO COMPARTMENT. REPLACED SUPPORT ZEE LOCATED BETWEEN STA727 TO STA787 AND LBL21 WL156 AFT CARGO COMPARTMENT IAW B737-700 SRM 51-40-02; SRM 51-10-02; SRM 53-00-53?2R-6 REPAIR 6 AND DWSDR SWAA2025090496138Support · corrodedCORROSION SUPPORT ZEE LOCATED BETWEEN STA727E TO STA767 AND RBL21 WL156 AFT CARGO COMPARTMENT. REPLACED SUPPORT ZEE AND FASTENERS LOCATED BETWEEN STA727 TO STA767 AND RBL21 WL156 AFT CARGO COMPARTMENT IAW B737-700 51-40-02; SRM 51-10-02 STEP 9 AND DWG # 146A75SDR SWAA2025090496140Shield · corrodedCORROSION SHIELD WEB LOCATED BETWEEN STA767 TO STA794.3 AND RBL22 WL156 AT AFT CARGO COMPARTMENT. REPLACED SHIELD WEB AND FASTENERS LOCATED BETWEEN STA767 TO STA794.3 AND RBL22 WL156 AT AFT CARGO COMPARTMENT IAW B737-700 SRM 51-10-02 ITEM 9; SRM 51-40-02 AND SDR SWAA2025090395978Support Angle · crackedCRACK ON SUPPORT ANGLE LOCATED BS 807 RBL 19 WL 156.1 AT AFT CARGO COMPARTMENT REPLACED NEW SUPPORT ANGLE AND FASTENERS LOCATED BS 807 RBL 19 WL 156.1 AT AFT CARGO COMPARTMENT IAW SRM:51-40-02 SRM:51-20-02 ITEM 9 AND DWG:146A8120;SHEET:37;REV:-.SDR SWAA2025090395985Support Angle · crackedCRACK ON SUPPORT ANGLE LOCATED BS 727 RBL 4 WL 159 AT AFT CARGO COMPARTMENT. REPLACED SUPPORT ANGLE LOCATED BS 727 RBL 4 WL 159 AT AFT CARGO COMPARTMENT AND FASTENERS IAW B737-700 SRM 51-10-02 ITEM 9 AND SRM 51-40-02 AND DWG: 144A2600 SHEET: 712 REV: -.SDR SWAA2025090395992Fitting · crackedCRACK ON FITTING LOCATED BS 947.5 AT LEVEL STR 26L AT AFT CARGO COMPARTMENT. REPLACED FITTING LOCATED BS 947.5 AT LEVEL STR 26L AT AFT CARGO COMPARTMENT AND FASTENERS IAW SRM 51-40-02; IAW SRM 51-10-02 ITEM 9 AND DWG:149A8103 SHEET: 7 REV: A.SDR SWAA2025090396149Access Panel · crackedCRACK BLADE ACCESS PANEL 333AT AT LT HORIZONTAL STAB. REPLACED BLADE (BLADE ASSY) ON ACCESS PANEL 333AT LT HORIZONTAL STABILIZER IAW B737-700 SRM 51-40-02 TOOK MEASURE CRACK IS L: 0.844.SDR SWAA2025090396141Angle · crackedCRACK ANGLE LOCATED BETWEEN STA907 TO STA927 AND STR25R TO STR27R AT AFT CARGO COMPARTMENT. REPLACED ANGLE LOCATED BETWEEN STA907 TO STA927 AND STR25R TO STR27R AT AFT CARGO COMPARTMENT IAW SRM 51-40-02; SRM 51-10-02 Ï¿½TEM 9 AND DWG:147A7221 SHEET:17 REV.D.SDR IPXA2025081560455Stringer · damagedMAJOR REPAIR, EXISTING REPAIRS IS TIME LIMITED RT WING UPPER STRINGER 6 AT XORS 980.80 REQUIRED PERM. REF EO # 87790-REQ 001. ACCOMPLISHED REPAIR IAW EO-87790-REQ001 REV2 AND VT-SAA EA 011-5700-01-B0550 REV IR.SDR IPXA2025082964745Floor Support · corrodedMAIN CARGO FLOOR STRUCTURE BETWEEN FRAMES 14-15, Y953 HAS CORROSION AROUND 2 EA FASTENER HOLES INSTALLED NEW SUPPORT IAW A300 SRM 51-40-21.SDR IPXA2025082964689Floor Support · corrodedMAIN CARGO FLOOR STRUCTURE BETWEEN FRAMES 13-14, Y1552 HAS CORROSION AT 2 EA FASTENR HOLES INSTALLED NEW FLOOR SUPPORT IAW A300-600 SRM 51-40-21 USING RETAINED HARDWARE.SDR SWAA2025090295983Cargo Track · crackedCRACK ON CARGO TRACK LOCATED BS 727E RBL 13.84 WL 156.1 AT AFT CARGO COMPARTMENT. PERFORMED REPAIR ON CARGO TRACK LOCATED BS 727D MORE 12? TO 727E MORE 11? RBL 13.84 WL 156.1 AT AFT CARGO COMPARTMENT IAW SRM B737-700 53-00-53-2R-3 1 REPAIR 3.SDR IPXA2025081956634Stringer · crackedMAJOR REPAIR, STRINGER CRACKED, BS 2598 FWD SIDE S8L. ACCOMPLISHED REPAIR IAW SRM 53-80-03-2R-2 REV.46, TR:53-152 AND EGAT WORK SHEET 50574 AND EO-94703-REQ1 REV.1 AND EGAT EI F2025A53M-1815 REV.0.SDR IPXA2025081956674Stringer · crackedMAJOR REPAIR, STRINGER CRACKED, BS 2598 FWD SIDE S7R. REPAIR DAMAGE AREA IAW SRM 53-80-03-2R-2 REV.46, TR:53-152, AND EGAT WORK SHEET 50578 AND EO-94702-REQ 1, REV 1 & EI .F2025A53M-1820, REV 0.SDR IPXA2025081956717Stringer · crackedMAJOR REPAIR, STRINGER CRACK, BS 2598 FWD SIDE S-1R. REPAIR DAMAGE AREA IAW SRM 53-80-03-2R-2 REV.46, TR:53-152 AND EGAT WORK SHEET 50575 AND EO-94695-REQ1 REV.1 AND EGAT EI F2025A53M-1818, REV 0.SDR IPXA2025081956695Stringer · crackedMAJOR REPAIR. STRINGER CRACKED, STA 2598 AFT SIDE S-4L. REPAIR DAMAGE AREA I.A.W SRM 53-80-03-2R-2 REV.46/RE:53-152 AND EGAT WORK SHEET 50570 AND UPS EO-94697-REQ1 REV.1 AND EGAT EI F2025A53M-1811 REV.0.SDR IPXA2025081956792Stringer · crackedMAJOR REPAIR, STRINGER CRACKED, BS 2598 FWD SIDE S6L. ACCOMPLISHED REPAIR AREA IAW SRM 53-80-03-2R-2 REV.46, TR:53-152, EGAT WORK SHEET 50573, UPS EO-94701-REQ 1, REV 1 AND EGAT EI F2025A53M-1816, REV 0.SDR IPXA2025081957343Stringer · crackedMAJOR REPAIR, STRINGER CRACKED, BS 2598, FWD SIDE S2L REPAIRED DAMAGE AREA IAW SRM 53-80-03-2R-2 REV.46, TR:53-152 AND EGAT WORK SHEET 50571 AND EO-94696-REQ 1, REV 1, AND EGAT EI F2025A53M-1817, REV 0.SDR IPXA2025082357346Stringer · crackedMAJOR REPAIR, STRINGER CRACKED, BS 2598 FWD SIDE S5L ACCOMPLISHED REPAIR IAW EO-94699-REQ 1, REV 2, AND EGAT EI F2025A53M-1844, REV 0, AND SRM 53-80-03-2R-2 REV 46, TR53-152, AND EGAT WORK SHEET 50572.SDR IPXA2025082357349Stringer · crackedMAJOR REPAIR, STRINGER CRACKED, BS 2598 AFT SIDE S5L. PERFORM EO-94700-REQ 1, REV.2, AND EI F2025A53M-1845, REV 0, AND EGAT WORK SHEET 50569.SDR IPXA2025081956802Stringer · crackedMAJOR REPAIR, STRINGER CRACKED, BS 2598 FWD SIDE S4R. REPAIRED DAMAGE AREA IAW SRM 53-80-03-2R-2 REV.46, TR:53-152, EGAT WORK SHEET 50576, UPS EO-94698-REQ 1, REV 1, AND GAT EI F2025A53M-1819 REV 0.SDR SWAA2025082796127Angle · crackedCRACK ANGLE TRAILING EDGE LOCATED IRSS 140 LT WING. REPLACED ANGLE TRAILING EDGE LOCATED IRSS 140 LT WING IAW SRM 51-10-02-0G-0 ITEM 9; SRM 51-40-02-0G-0 AND DWG: 115A2000; SHEET: 21; REV- . MEASURE OF CRACK IS L: 0.534.SDR SWAA2025082795962Support Angle · crackedCRACK ANGLE - SUPPORT LOCATED BS500I AND S-28R FWD CARGO COMPARTMENT. REPLACED ANGLE - SUPPORT LOCATED BS500I AND S-28R FWD CARGO COMPARTMENT IAW SRM 51-40-02, & DWG 143A4902, SHEET 301, REV A.SDR SWAA2025082795963Support Angle · crackedCRACK ANGLE - SUPPORT LOCATED BS 500I AND S-28L FWD CARGO COMPARTMENT. REPLACED ANGLE-CLIP LOCATED BS 500I AND S-28L FWD CARGO COMPARTMENT IAW SRM 51-40-02 DWG:143A7902 SHEET:301 REV:A.SDR JJBA20250825055Skin · dentedDENT/CREASE WAS IDENTIFIED IN THE FORWARD FUSELAGE 1 AREA, LOCATED BETWEEN FRAMES 1A AND 2 AND BETWEEN STRINGERS 15R AND 13R. NO STRUCTURAL DEFORMATION OR ADDITIONAL ANOMALIES WERE OBSERVED. PERMANENT REUNFORCING REPAIR PERFORMED ON RF FWD DUSELAGE SKIN AT FRASDR REXA2025082500831Stringer Splice · corrodedFOUND CORROSION ON STGR 21L AFT SPLICE AT FS374. UPON FURTHER INVESTIGATION FOUND STGR 21L AFT SPLICE AT FS374 TO BE HEAVILY CORRODED TO THE POINT OF 100% MATERIAL LOSS AND OUT OF LIMITS IAW CRJ700 SRM 53-21-03-101-006-A01. LOCATED AND DRILLED NEW SERVICEABLSDR SWAA2025082196102Floor Panel · delaminatedCABIN FLOOR PANEL 241GF STA. 727B- 727F DELAMINATED. REMOVED CABIN FLOOR PANEL 241GF IAW AMM 53-21-00. INSTALLED FLOOR PANEL 241GF IAW AMM 53-21-00.SDR SWAA2025082195960Floor Panel · delaminatedCABIN FLOOR PANEL 231KF BS 500B- 500E DELAMINATED. REMOVED CABIN FLOOR PANEL 231NF IAW AMM 53-21-00. INSTALLED PANEL 231KF IAW AMM 53-21-00.SDR R61A2025082000358Strap · corrodedLOWER FUSE SUPPORT STRAPS ON FR 74 BTWN STG 28L-28R CORRODED. MX REPLACED SUPPORT STRAPS IAW SRM 51-42-02, 51-43-03 .SDR R61A2025082000357Strap · corrodedLOWER WING TO FUSE FAIRING STRAP FOUND CORRODED. MX REPLACED STRAP IAW SRM 51-43-04.SDR AALA202508189695Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT INTERCOSTAL LOCATED FROM BS 500G TO BS 500H AT S25L. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR IPXA2025081456371Acoustic Liner · damagedBROKEN-ACOUSTIC LINER, NO.2 ENG FAN CASE MIDDLE 7:00 AREA . I.A.W AMM 72-33-01-004-001-H00 AND 72-33-01-404-011-H00 REV.145, REPLACED THE ACOUSTIC LINER SEGMENT OF NO.2 ENGINE.SDR IPXA2025081416434Retainer Seal · crackedFWD CREW DOOR SCUFF PLATE RETAINER WITH CRACK.REMOVED AND REPLACED RETAINER SEAL P/N A5361155631802 B/N 0004417335, INSTALLED USING EXISTING FASTENERS IAW A300-600 SRM 51-40-21. NO FURTHER ACTION REQUIREDSDR AALA202508117993Structure · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO APU ENCLOSURE LEFT HAND FORWARD CHORD FROM BS 1091 TO BS 1094 AT S24L. REPAIRED CHORD PER EA 366875.SDR IPXA2025080566169Drain · crackedMAIN CABIN DOOR, CASING DRAIN BROKEN.REMOVED CASING DRAIN BROKEN FROM Z200 IAW A300-600 SRM 51-40-21.RECEIVED NEW CASING DRAIN WITH NUMBERS:P/N#A5361152520000 AND BTCH#0002940485.LOCATED AND DRILL TO NEW CASING DRAIN IAW A300-600 SRM 51-40-44.INSTALLED NEW CASSDR CALA2025080807476Proximity Sensor · faultedCHRONIC LEVEL 1 - LGCIU 1 FAULT DUE TO HISTORY OF L/G LGCIU 1 FAULTS WITH AIRMAN REPORTING 32-31 -73 R LG DOOR PROX SNSR 26GA, REF TSM TASK 32-31-00-810-819-A, PERFORM BITE OF LGCIU 1 FOR FAULT CODES. REF ASM 32-31-03 CHECK RESISTANCE AND INSULATION RESISTANCESDR JJBA20250806012Partition · corrodedRH PARTITION AT FR61 FOUND CORRODED. AFTER INVESTIGATION, CRACK FOUND ON RH PARTITION AT FR61. AT PARTITION RH FR 61 CUT AWAY SECTION REPLACED WITH MADE REPAIR PART LOCALLY FABRICATED. AT FR61 RH PARTITION REPAIRED.SDR JJBA20250806005Frame · crackedLH COCKPIT, OVERHEAD PANEL, FRAME FOUND CRACKED. LH COCKPIT OVERHEAD PANEL FRAME REMOVED AND REPLACED.SDR ASAA2025072859854Door · no discrepancyL1 DOOR FOUND HARD TO CLOSE, BINDING AT UPPER AFT CORNER. MIG 2C INITIATED S/N 40-0039638, 40-0039639. GROUNDED - YES. VERIFIED DOOR FWD ENTRY LP 61121159 CLOSED. MIG-2C'S S/N 40-0039638 THROUGH 40-0039643 CLOSED.SDR AALA202508064329Angle · crackedAIRCRAFT IN BASE MAINTENANCE: FORWARD CARGO FLOOR STRUCTURE TRANSITION PANEL BAFFLE CLIP CRACKED LEFT HAND SIDE AT BS 500F. INSTALLED NEW PART. PER BOEING AARD 51-00-05-1SDR ASAA2025072859801Channel · corrodedAFT PIT LH & RH SIDEPLATE (TRANSITION PANELS) ARE CORRODED IN MULTIPLE PLACES WERE NUTPLATES FELL OFF. GROUNDED - YES. REPAIRED L/H AND R/H SIDEPLATES AIW B737 -9MAX SRM 53-00-53-2R-5W= .650" O= .040" R= 1.2" R= .000" D= .040".