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 FDEA202511122164Floor Panel · damagedMAIN DECK CARGO COMP FLOOR PANEL 242JFF (145T5876-102) REQUIRES REPAIR. FABRICATED FLOOR PANEL 242JFF, MPN: 145T5876-102, RBL 11- RBL 33, STA. 930- 982 IN REF. TO B767 BOEING DWG 145T5876-102 AND FEDEX DWG SR67-53-009. THIS IS A MAJOR REPAIR. THE INSTALLATIOSDR FDEA202511122163Floor Panel · damagedMAIN DECK CARGO COMP FLOOR PANEL 241MFF (145T5876-21) REQUIRES REPAIR. FABRICATED FLOOR PANEL 241MFF, MPN: 145T5876-21, LBL 11- LBL 33, STA. 930- 982 IN REF. TO B767 BOEING DWG 145T5876-21 AND FEDEX DWG SR67-53-009. THIS IS A MAJOR REPAIR. THE INSTALLATION OSDR DXTA2025111205664Handle · jammedMAIN AIRCRAFT DOOR HANDLE WAS LOCKED BUT NOT STOWED. HANDLE IS JAMMED AND WE CAN NOT STOW IT OR GRT IT TO POP OUT. UNABLE TO OPEN MAIN CABIN DOOR.(PRE FLIGHT)SDR REXA2026052800854Web · crackedINITIAL INSPECTION': CRACK ON ELECTRICAL BAY FLOOR WEB LEFT SIDE (BELOW BRAKE ACCUMULATOR INDICATION SUPPORT DOUBLER) FS193.00. CRACK ON ELECTRICAL BAY FLOOR WEB LEFT SIDE (BELOW BRAKE ACCUMULATOR INDICATION SUPPORT DOUBLER) FS193.00. WAS REPAIRED PER CRJ-900SDR REXA2026052800800Angle · corrodedCORROSION ON MID CAP ANGLE AT PASSENGER DOOR SURROUND STRUCTURE MID CAP ANGLE AT PASSENGER DOOR SURROUND STRUCTURE WAS REPLACE PER CRJ-900 SRM 51-41-02-001-001-A01SDR SWIA2026031875533Crossbeam · corrodedBS 349 CROSSBEAM AFT SUPPORT ANGLE IS CORRODED LOCATED BETWEEN LBL36 AND LBL27. REMOVED AND REPLACED THE CROSSBEAM AFT SUPPORT ANGLE IAW SRM 51-42-06, & DWG 601R38673, REV D.SDR VNAA202601170015Rib · crackedCRACK ON MACHINED RIB OF LEADING EDGE SS57.16 AT RH WING. MACHINED RIB OF LEADING EDGE SS57.16 AT RH WING WAS REPAIRED PER REO 690-57-41-240 REV - -SDR AALA202601143069Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM BS 500A TO BS 500I, AT RBL 24. REPLACED TRANSITION PANEL PER AARD 51-00-05-01.SDR AALA202601142634Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM BS 500B TO BS 500I, AT S25L, AT LBL 22. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202601149146Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM BS 500 TO BS 500A, AT S25L, AT LBL 22. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR ASAA2025111163359Skate Angle · crackedCENTER WING AFT SPAR VAPOR BARRIER SKATE ANGLE CRACK AT BS 661.95 LBL+7. GROUNDED - YES. REPAIRED CENTER WING AFT SPAR VAPOR BARRIER SKATE ANGLE IAW SRM 57-10-10-2R-5 AT BS 661.95 LBL 7.SDR ASAA2025111163354Angle · crackedCENTER WING AFT SPAR VAPOR BARRIER SKATE ANGLE CRACK AT BS 661.95 RBL+9. GROUNDED - YES. REPAIRED CENTER WING AFT SPAR VAPOR BARRIER SKATE ANGLE AT BS 661.95 RBL 9 IAW B737-800 SRM 57-10-10-2R-5 REMOVED AND REINSTALLED RT W/W EMDP IAW 29-11-21, ACCOMPLISHED SDR SWAA2025122234296Strip · deterioratedDETERIORATED PHOTOLUMINESCENT LT & RT SIDES IN THE PASSENGER CABIN (10EA). REPLACED PHOTOLUMINESCENT STRIPS IAW AMM 33-51-15-400-802.SDR SWAA2025121834234Floor Support · corrodedCORROSION ON UPPER SURFACE OF FLOOR SUPPORT AT BS 986.5+9.5, LBL 33, WL 208. REMOVED AND REPLACED THE FLOOR SUPPORT, BS 986.5 - 1006, LBL 35, WL 208 IAW SRM 51-40-02, & DWG 147A5600, REV-.SDR ASAA2025111163117Floor Panel · delaminatedCABIN AFT WET AREA FLOOR PANEL 147A5810-446 HAS DELAMINATION. GROUNDED - YES. ACCOMPLISHED PERMANENT REPAIR TO CABIN AFT WET AREA FLOOR PANEL 147A5810-446 IAW ASA B737-900ER SRM 53-00-50-2R-1 & 53-00-50-2R-0.SDR SWAA2025121734024Pressure Deck · crackedCRACK FOUND ON HORIZONTAL PRESSURE DECK AT MID PASSENGER CABIN, BS 663 + 8, RBL 47, LENGTH 2 INCHES. REPAIRED THE PRESSURE DECK IAW SRM 53-40-51-2R-2, REPAIR 2.SDR SWAA2025121734231Floorbeam · corrodedCORROSION ON BS 986.5 FLOORBEAM UPPER FLANGE AT NUTPLATE HOLES, RBL 38 AND RBL 40, WL208. REPAIRED ON CUSTOMER CARD TTG8Q018TL1Z, WIP-1, & EA 25-153-03157, REV A.SDR SWAA2025121734232Floorbeam · corrodedCORROSION ON BS 986.5 FLOORBEAM UPPER FLANGE BOTTOM NUTPLATE HOLES, RBL 30, RBL 32.5, AND RBL 35, WL 208. REPAIRED ON CUSTOMER CARD TTG8Q018TL1Z, WIP-1, EA 25-153-03157, REV A.SDR SWAA2025121734233Web · corrodedCORROSION ON LEFT SHIELD WEB, BS 986.5+10. LBL 35, WL 208. REPAIRED IAW EA 25-153-03147.SDR SWAA2025121734226Web · corrodedCORROSION ON RT SHIELD WEB AT BS1016, RBL 6, WL 208. REF FAULT TTG8Q018TMSQ WHERE EA 25-153-03147 WAS ADDED AS A SUBTASK.SDR SWAA2025121734229Web · corrodedCORROSION ON LT SHIELD WEB AT BS1016+2, LBL2 AND BS 1016+10, BL0, WL 208. REF TTG8Q018TMSQ WHERE EA 25-153-03147 WAS ADDED AS A SUBTASK.SDR SWAA2025121734227Floorbeam · corrodedCORRODED BS 986.5 FLOORBEAM PREVIOUS REPAIR FILLER AT NUTPLATE HOLE RBL 43, WL 208. REPAIRED IAW EA 25-153-03157.SDR ASAA2025111163080Floorbeam · corrodedAFT WET AREAS BS 986.5 TEE CAP APPROX. BETWEEN RBL 24 TO RBL 58 HAS AREAS OF CORROSION. GROUNDED - YES. REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS IAW SRM 53-70-51-1A-1, FIG 104. ORIGINAL .150" LOSS OF .010" REMAINING .140". ACCOMPLISHED FULL TEE CAP RSDR ASAA2025111163079Floorbeam · corrodedAFT WET AREA STA 947.5 TEE CAP APPROX. BETWEEN LBL 24 TO RBL 24 HAS AREAS OF CORROSION. GROUNDED - YES. REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS IAW SRM 53-70-51-1A-1 ORIGINAL .180" REMAINING .124" LOSS OF .056" ACCOMPLISHED FULL TEE CAP REPAIR AT 947 ISDR ASAA2025111163078Intercostal · corrodedRIGHT AFT INTERCOSTAL AT BS 947.5 APPROX, RBL 51 HAS SEVERAL AREAS OF CORROSION. GROUNDED - YES. REMOVED CORROSION ON INTERCOSTAL AT BS. 947 RBL 51, LOST .045" OF MATERIAL, FOUND BEYOND LIMITS IAW SRM 53-70-51-1A-1, R & R INTERCOSTAL PO 1137621.1 IAW SRM 5SDR ASAA2025111163077Intercostal · corrodedLEFT AFT INTERCOSTAL AT BS 947.5, APPROX LBL 51 HAS SEVERAL AREAS OF CORROSION. GROUNDED - YES. REMOVED CORROSION ON INTERCOSTAL AT BS 947-967 LBL 51, LOST .035" OF MATERIAL, FOUND BEYOND LIMITS IAW SRM 53-70-51-1A-1, R & R THE INTERCOSTAL. PO 1137621.2 IASDR ASAA2025111163019Skate Angle · crackedCENTER WING AFT SPAR VAPOR BARRIER SKATE ANGLEHAS CRACK AT BS.661.95 LBL+9. GROUNDED - YES. REPAIRED VAPOR BARRIER SKATE ANGLE CRACK IAW SRM 57-10-10-2R-5 REPAIR 5. THIS IS A CATERGORY A REPAIR.SDR SWAA2025121546419Web · corrodedCORROSION WEB LOWER SILL LOCATED BETWEEN BS 440 TO BS 492.4, RBL 22, WL156 FWD CARGO BAY. REPLACED THE WEB LOWER SILL LOCATED BETWEEN BS 440 - 492.4, RBL 22, WL156 IAW SRM 51-10-02, ITEM 9 AND DWG 143A8330, SHEET 42, REV A.SDR SWAA2025121534018Web · corrodedCORROSION WEB LOWER SILL LOCATED BETWEEN BS 440 - 492.4, RBL 22, WL 156 IN THE FWD CARGO BAY. REPLACED WEB LOWER SILL IAW SRM 51-10-02, ITEM 9, & DWG 143A8330, SHEET 42, REV A.SDR SWAA2025121234188Floor Panel · delaminatedDELAMINATED FLOOR PANEL 231WF IN THE PASSENGER CABIN. REPAIRED THE FLOOR PANEL 231WF IAW SRM 53-00-50-2R-4, REPAIR 4.SDR ASAA2025111162903Floor Panel · dentedCABIN FLOOR PANEL 144A5810-258 HAS DELAMINATION. GROUNDED - YES. REMOVED AND INSTALLED NEW CBN FLOOR PANEL P/N 144A5810-258 IAW B737-900 AMM 53-21-00, USING TOOL #SCREW GUN T05867-104 + T05867-155 DUE 04/MAR/26 PO# 1137391.3.SDR SWAA2025121034210Filler · mismanufacturedRIGHT WING OTBD FIXED L/E REPAIR, BTW SS 61.75 & SS 67.53, REPAIR FILLER DOES NOT HAVE THE REQUIRED SIZE IAW EA 1-757-16674. FILLER HAS BEEN ADJUSTED ON RT WING OTBD FIXED L/E IAW EA 1-757-16674 AND EA 57-0485-19, PART 2, STEP 11, FIG 2, AND INSTALLED IAW ESDR SWAA2025121033790Web · crackedCRACKED NR 2 VAPOR BARRIER WEB, BS 663.75, RBL 25 MAIN WHEEL WELL. REPAIRED THE VAPOR BARRIER WEB IAW SRM 51-70-04-2R-10, REPAIR 10.SDR SWAA2025121034214Floorbeam · crackedMAIN CABIN FLOORBEAM CRACKED, BS 540, BL 0 - LBL 24.75. REPLACED THE FLOORBEAM IAW SRM 51-40-02-0G-0, AND DWG 143A0060, SHEET 46, REV -. .SDR DALA2025121009035Skin · damagedER/A 629290-14 ISSUED FOR DOUBLER REPAIR TO THE WASTE BOX AREA. FOLLOW-ON ACTION REQUIRED. ER/A 629290-14 SECTION I ACCOMPLISHED IN MSP NOV 2025. SECTION II REPEAT INSPECTION REQUIRED EVERY 1,000 FH UNTIL SECTION III IS ACCOMPLISHED WITHIN 10,000 FH OF SECTIONSDR SWAA2025120833689Angle · corrodedFOUND CORROSION ON ACB SHIELD ANGLE, BS 767 - 787, RBL 20, WL 155. FOUND FAULT DURING REMOVAL OF SHIELD. REMOVED AND REPLACED ACB SHIELD ANGLE IAW SRM 51-40-02, AND DWG 146A0081, REV- AND DWG 146A8123, REV-.SDR SWAA2025120834008Baffle · crackedFWD CARGO BAY BAFFLE AT BS 500A - 500B, RBL 21, WL 156 IS CRACKED. REMOVED, REPAIRED, AND INSTALLED A NEW BAFFLE ASSY IAW SRM 51-40-02, DWG 143A7505, REV A, AND SRM 53-30-53-2R-1-A01785, REPAIR 1 - SECTION 43.SDR SWAA2025120834090Baffle · corrodedFOUND CORROSION AT ACB BAFFLE BS 747 - 767, APPOX RBL 21, WL 155. CORROSION ON BAFFLE FOUND TO BE OUT OF LIMITS DUE TO NO LIMITS ARE GIVEN IN THE SRM. REMOVED, & REPLACED THE BAFFLE IAW SRM 51-40-05-0G-0, SRM 51-40-02-0G-0, AND DWG 146A7502 REV -.SDR SWAA2025120834085Rib · crackedRIGHT HORIZONTAL STAB REMOVABLE L/E INBD END RIB IS CRACKED. REMOVED CRACKED RIB FROM RT STAB L/E IAW SRM 51-40-02-0G-0 & INSTALLED IAW DWG 186A1001 REV B, SRM 51-40-02-0G-0, & SRM 55-10-01-2R-1.SDR SIMA20251111002Seal Rest · corroded53-21-009-0873 FWD CARGO DOOR CUTOUT HAS CORROSION ON OB FUSELAGE SIDE WHERE SCUFF PLATE ATTACHES AT FWD BOTTOM EDGE OF CARGO DOOR CUTOUT. (MAJOR REPAIR)) (LEVEL 2 CORROSION). BLENDED CORROSION ON FWD CARGO DOOR CUTOUT ON OB FUSELAGE SIDE WHERE SCUFF PLATE ATTSDR KCSA2025120811170Door · unsecureDOOR FWD OVHD EICAS ON LANDING. SECURED DOOR IAW AMM 52-21-00. ACFT OK FOR SERVICE.SDR SWAA2025120434212Floorbeam · crackedMAIN CABIN FLOORBEAM HAS CRACK AT BS 540; BL 0 TO RBL 24.75. REPLACED THE FLOORBEAM IAW SRM 51-40-02-0G-0, DWG 143A5240, SHEET 13, REV -, AND DWG 143A0060, SHEET 46, REV -.SDR AALA202512048772Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED LEFT HAND MAIN LANDING GEAR DOOR FORWARD FITTING. REPLACED FITTING PER CMM 52-81-18.SDR ASAA2025111162747Transition Panel · corrodedAFT CARGO PIT RT TRANSITION PANEL BS 727 - 767 HAS CORROSION. GROUNDED - YES. REMOVED CORROSION ORIGINAL THICKNESS .040, REMOVED .040, REMAINING .000. FOUND TO BE OUT OF LIMITS IAW SRM 53-00-53-1A-2. REMOVED TRANSITION PANEL, FABRICATED NEW REPAIR USING BAC14SDR ASAA2025111162745Transition Panel · corrodedFWD CARGO PIT LT TRANSITION PANEL BS 500 - 500I HAS CORROSION. GROUNDED - YES. REMOVED CORROSION ORIGINAL THICKNESS .040, REMOVED .040, REMAINING .000. FOUND TO BE OUT OF LIMITS IAW SRM 53-00-53-1A-2. REMOVED DAMAGE TRANSITION PANEL, FABRICATED NEW REPAIR PARTSDR SWAA2025120333713Web · chafedE/E BAY DOOR SURROUND STRUCTURE LONGITUDINAL CLOSE-OUT WEB HAS CHAFING DAMAGE ON THE TOP EDGE, BS 337.5, RBL 11.5. REMOVED, FABRICATED, & REPLACED THE CLOSE-OUT WEB IAW SRM 51-40-02-0G-0, & DWG 141A85110002, REV -, SRM 53-10-15-0I-3, TABLE 3, ITEM 8.SDR SWAA2025120334103Gusset · crackedFWD CARGO BAY AFT BULKHEAD SUPPORT GUSSET IS CRACKED, BS 500D, S19R, WL 193. REMOVED & REPLACED THE SUPPORT GUSSET IAW SRM 51-40-02, & DWG 143A79020259, REV -.SDR SWAA2025120334102Gusset · crackedFWD CARGO BAY AFT BULKHEAD SUPPORT GUSSET IS CRACKED, BS 500D, S19L, WL 193. REMOVED & REPLACEDTHE SUPPORT GUSSET IAW SRM 51-40-02, & DWG 143A79020259, REV -.SDR SWAA2025120334105Attach Angle · crackedCRACKED ATTACH ANGLE AT FCB BS 500C, FWD SIDE, LBL 25, WL 154. REMOVED AND REPLACED ATTACH ANGLE IAW SRM 51-40-02, & DWG 143A75050005, REV -.SDR SWAA2025120334108Attach Angle · crackedCRACKED ATTACH ANGLE AT FCB BS 500C, AFT SIDE, LBL 25, WL 154. REMOVED AND REPLACED THE ATTACH ANGLE IAW SRM 51-40-02, & DWG 143A75050005, REV-.