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 HNAA2025101400704Gusset · corroded53-2157 CF4 BTW FR59-61, LH GUSSET CORRODEDSDR AALA202510103177Beam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN R1 DOOR BEAM. REPLACED DOOR BEAM PER SRM 20-10-02-01 AND CMM 52-41-05.SDR HNAA2025101000692Beam · corroded53-2127 RF1 CARGO DOOR ENTRANCE AT FR66 POST CRACKED. RAR POST IAW SRM 51-40-02SDR HNAA2025101000693Beam · corroded53-2130 RF1 CARGO DOOR ENTRANCE AT FR66 ANGLE ON TOP OF LWR BEAM CRACKED. RAR ANGLE IAW SRM 51-40-02SDR HNAA2025101000694Door Frame · crackedCARGO DOOR ENTRANCE AT FR67 POST CRACKED. RAR POST IAW SRM 51-40-02SDR HNAA2025101000695Angle · crackedCARGO DOOR ENTRANCE AT FR67 ANGLE ON TOP OF LWR BEAM CRACKED. RAR ANGLE IOAW SRM 51-40-02SDR ASAA2025091261456Floor Support · corrodedSTA 787-847 LH FLOOR PLATE WITH CORROSION. GROUNDED - YES. REMOVED CORROSION IAW B737-900 SRM 51-10-02. ORIGONAL THICKNESS IS .040", IAW B737-900 SRM 53-60-53 AND DWG BAC 1496-377. THE WORST AREA BEING .003" MATERIAL LOSS, .037" REMAINING. FOUND TO BE WITHIN SDR ASAA2025091261452Strap · corrodedFORWARD CARGO PIT R/H TRANSITION STRAP STA. 500D-500H HAS MULTIPLE AREAS OF CORROSION AT SCREW HOLES. GROUNDED - YES. REPAIRED TRANSITION STRAP IAW B737-900 ER SRM 53-00-53-2R-5 REV:56 10JUL2025. MATERIAL ID: BAC1496-444 7075-T62C PO: 1131612.1 AND MATERIAL IDSDR ASAA2025091261450Strap · corrodedRIGHT TRANSITION STRAP STA. 500-500D HAS MULTIPLE AREA'S OF CORROSION AT SCREW HOLES. GROUNDED - YES. REPAIRED TRANSITION STRAP IAW B737-900ER SRM 53-00-53-2R-5 REV:56, 10JUL2025 MATERIAL ID: BAC1496444 7075-T62C PO: 1131612.1 AND PN: 143A8126-38 PO: 1133635.1SDR ASAA2025091261446Plate · corrodedFWD CARGO PIT R/H TRANSITION STRAP STA 500H-500L HAS MULTIPLE AREA'S OF CORROSION AT SCREW HOLES-MARKED IN RED. GROUNDED - YES. REPAIRED TRANSITION STRAP IAW B737-900ER SRM 53-00-53-2R-5 REV: 56, 10JUL2025 MATERIAL ID: BAC 1496444 7075-T62C REV: 56 10JUL2025 PSDR HNAA20250900690Shear Tie · cracked53-2172 LH SHEAR CLIP CRACKED AT FR61 BTW STR18-19L. REPAIRED IAW ETD 2025-145-929206SDR CALA2025100909829Floorbeam · corrodedCORROSION CABIN AFT WET AREA FLOORBEAM STA 947.5, LBL9. (REF AAR N/R 97533673) REMOVED THE DAMAGED FLANGES OF THE UPPER TEE OF THE FLOORBEAM BETWEEN LBL 34.5 TO RBL 32.9, INSTALLED NEW TEE ANGLE AND REPAIR PARTS IAW SRM 53-70-51-2R-5 REPAIR 5 WITH THE DEVIASDR HNAA2025100700679Shear Tie · crackedLEFT SHEAR CLIP CRACKED AT FR66 BTW STR6-7L. R & R SHEAR CLIP IAW SRM 51-40-02SDR FDEA202509121903Door · not enteredDOORS - CARGO DOOR/HYD SYS - DETAILED VISUAL INSPECTION OF THE MAIN DECK CARGO DOOR (MDCD) ACTUATOR BEARING FITTINGS AT FRAME 23 AND 24 - AOT A52W016-24 COMPLIED WITH EO 6-5230-E0378588 B P5. TITLE: DOORS - CARGO DOOR/HYD SYS - DETAILED VISUAL INSPECTION OSDR CALA2025100609629Stringer · corrodedCORROSION AT FWD CARGO AFT (AIR CONDITIONING DISTRIBUTION BAY) STR 28 LEFT STA 530.DOT251-083. (REF AAR N/R 99951024) ESFR TRANSACTION COMPLETED PERFORMED REPAIR TO THE LEFT-HAND KEEL BEAM UPPER INNER CHORD IN ACCORDANCE WITH AAR-MIA ESR-WI NO.: 2023803-27-12SDR CALA2025100609628Stringer · corrodedCORROSION AT FWD CARGO AFT (AIR CONDITIONING DISTRIBUTION BAY) STR 28 RIGHT STA 537.DOT251-084. (REF AAR N/R 99951025) ESFR TRANSACTION COMPLETE PERFORMED REPAIR TO THE RIGHT-HAND KEEL BEAM UPPER INNER CHORD IN ACCORDANCE WITH AAR-MIA ESR-WI NO.: 2023803-28-1SDR JIKA2025100301Brake Assy · weakDURING TAXI ON TAXIWAY HEADING TO THE ACTIVE RUNWAY, THE FLIGHT CREW NOTED LOW BRAKE PRESSURE AND OPTED TO SHUT DOWN THE AIRCRAFT IN PLACE TO PREVENT LOSS OF CONTROL. BURBANK MAINTENANCE INSPECTED THE BRAKE SYSTEM AND FOUND NO EVIDENCE OF LEAKING FLUID OR OTHESDR SIMA20250912004Seat Track · gougedRH LATERAL SEAT TRACK GOUGED AT 11EA AREAS ON SCALLOP AT FRAME 75-84 BLENDED GOUGES ON R/H LATERAL SEAT TRACK BETWEEN FR74-FR84 IAW EMBRAER 175 SRM 51-10-03. BLEND IN DEEPEST SPOT LOCATED AT FR82 MEASURES: L= 1.90? W= 0.50? H= 0.012?. R/H LATERAL SEAT TRACK ALSDR SIMA20250912003Floorbeam · corrodedFWD WET AREA FLOOR STRUCTURE CROSSBEAM CORRODED AT FR 14 Y +37". LEVEL 2 CORROSION BLENDED CORROSION OUT AT FWD WET AREA FLOOR STRUCTURE CROSSBEAM AT FR 14 Y+37 PER EMB-175 SRM 51-10-03. MEASUREMENTS ARE L=1" W=0.5" D=0.080" MEASURED. THIS IS FOUND TO BE OUT OSDR SWAA2025100214098Floorboard · peelingMAIN CABIN FLOORBOARD 222DF THE FIBER IN TOP SIDE OF PANEL IS PEELING. REFER TO FAULT TTG8Q014XXD0 WHERE EA 25-153-02429 WAS ADDED AS A SUBTASK.SDR JJBA20251002004Door Sill · corrodedCFI, SERVICE DOOR AFT SILL BTW FR 22-24 FOUND CORRODED. AT CF1, SERVICE DOOR AFT SILL BTW FR 22-24 SILL BLENDED OUT OF LIMIT. CFI, SERVICE DOOR AFT SILL BTW FR 22-24 REPLACEDSDR SWAA2025100114214Doubler · crackedWHILE INWORK INSTALLING RH VAPOR BARRIER FOUND SUPPORTING DOUBLER IS CRACKED<[01] FABRICATED ON RH VAPOR BARRIER SUPPORTING DOUBLER FROM 2024T3#0.040 C LOT#1614857-1 IAW SRM 51-40-05 AND DWG 111A1511 ID: 0025 REV: - <BR>MATERIAL REPLACEMENT; MATERIAL 2024 T42 SDR SWAA2025100114215Support Angle · crackedWHILE INWORK INSTALLING RH VAPOR BARRIER FOUND SUPPORTING ANGLE IS CRACKED. REMOVED AND REPLACED RH VAPOR BARRIER SUPPORT ANGLE P/N 149A7218Y8 LOT# 1620188-1 BS652 TO BS663 RBL25 AND CLIP P/N149A7627U6 BS663 RBL25 IAW SRM 51-40-02 AND DWG 149A7210 REV -. CASDR SCNA20250930390Floorbeam · crackedCRACK ON FLOOR SUPPORTS (2 EAS) AT STA 540 LBL 2 AND LBL 28 OF PASSENGER COMPARTMENT FLOOR STRUCTURE. FLOOR SUPPORT AT STA 540 LBL 2 OF PASSENGER COMPARTMENT FLOOR STRUCTURE WAS REPLACED PER B737-800 SRM 51-40-02-0G-0 AND (ET)(HFEC) INSPECTION WAS ACCOMPLISHESDR 2025FA0000670Pump · leakingDURING A PLANNED FLIGHT FROM FORT WORTH MEACHAM (KFTW) TO KENOSHA, WI (KENW), THE PILOT OF A PIPER PA-46-310P MALIBU EXPERIENCED A FUEL SYSTEM ANOMALY. APPROXIMATELY 3 HOURS INTO THE FLIGHT AT FL230, THE PILOT OBSERVED THE INDICATED FUEL QUANTITY DECREASING THSDR SWAA2025092914113Skin · delaminatedLEFT OTBD AFT FLAP UPPER SURFACE HAS AREA OF DELAMONATION AT INBD END JUST FWD OF T/E. REMOVED; REPLACED AND ADJUSTMENT CHECKED LT O/B AFT FLAP IAW AMM 27-51-22. VERIFIED TORQUES AND SAFETIES; ADJUSTMENT CHECK GOOD. VERIFIED COMPLETION CORRECTIVE ACTION 1 SDR HNAA2025092600650Shear Tie · cracked53-2141 SHEAR CLIP CRACKED AT FR62 BTW STR6-8L. RAR SHEAR CLIP IAW SRM 51-40-02SDR HNAA2025092600648Gusset · corrodedRIGHT GUSSET AT BTW FR 59-61 IS CORRODED. R & R GUSSET IAW SRM 51-40-02SDR HNAA2025092600647Shear Tie · crackedSHEAR CLIP CRACKED AT FR 71 BTW STR 6-10R. R & R SHEAR CLIP IAW SRM 51-40-02SDR SWIA2025F01339Skin · scratchedUPON INSPECTION, FOUND THE DAMAGED AREA BETWEEN THE AFT CARGO DOOR AND AFT LAV SERVICE PANEL TO BE 15.5"L X 2.5" W WITH A SCRATCH 1/16" DEEP. DAMAGE IS OUT OF LIMITS PER SRM 53-23-01 (FLIGHT 4653 - FILED CLOSED)TRANSFERED FROM EAML 1702353 : REF AML# 1702303SDR SWI2025F01338Intercostal · chafedLH FS1144.00 AT INTERCOSTAL WEB STR9L HAS CHAFING DAMAGE FROM RAM AIR WATER LINE (FILED CLOSED)PERFORMED REPAIR TO LH FS1144.00 AT INTERCOSTAL WEB STR9L IAW REO 670-53-61-2568 DATED 2025-09-22 REV -. COMPLIED WITH TASK CARD 51-900-1002-SKY SEE CP-30828924 FSDR SWIA2025F01337Skin · gougedAFT FUSELAGE INTERIOR SKIN HAS GOUGES BELOW STG 6L BETWEEM FS1162.00 AND FS1144.00 (FILED CLOSED)PERFORMED REPAIR TO AFT FUSELAGE INTERIOR SKIN BELOW STR 6L BETWEEN FS1162.00 AND FS1144.00 IAW REO 670-53-61-2568 DATED 2025-09-22 REV -.COMPLIED WITH TASK CASDR SWIA2025F01336Stringer · chafedLH STG 7L HAS CHAFING DAMAGE BETWEEN FS1162.0 AND FS1144.00 FROM RAM AIR WATER LINE (FILED CLOSED)PERFORMED REPAIR TO LH STR 7L BETWEEN FS1162.0 AND FS1144.00 IAW REO 670-53-61-2568 DATED 2025-09-22 REV- COMPLIED WITH TASK CARD 51-900-1002-SKY SEE CP-3082892SDR SWIA20250924012Stringer · chafedLH STG 6L HAS CHAFING DAMAGE BETWEEN FS1162.0 AND FS1144.00 FROM RAM AIR WATER LINE (FILED CLOSED)PERFORMED REAPIR TO LH STR6L BETWEEN FS1162.0 AND FS1144.00 IAW REO 670-53-61-2568. DATED 2025-09-22 REV- COMPLIED WITH TASK CARD 51-900-1002-SKY AND FORM M-337SDR CALA2025092409208Floorbeam · corrodedCORROSION ON CABIN AFT WET AREA FLOORBEAM STA 986.5 BETWEEN BL-0 AND RBL 54. REMOVED CORRODED EXISTING TEE CHORD REPAIR AT STA 986.5 FROM RBL 54 TO LBL 50 IAW SRM 51-40-02-0G-0, CUT AND REMOVED THE REMAINING DAMAGE FLANGE FROM LBL 50 TO LBL 54 IAW SRM 53-70-5SDR HNAA2025092300640Shear Tie · crackedSHEAR CLIP CRACKED AT FR62 BTW STR6-8R. RAR SHEAR CLIP IAW SRM 51-40-02SDR AALA202509227854Strip · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RUDDER LEFT HAND SIDE TRAILING EDGE LOWER APEX STRIP. REPAIRED APEX STRIP PER SRM 55-41-19-300-011 AND SRM 51-42-11-801.SDR CALA2025092209113Skin · dentedDENT ALONG RH HORIZONTAL LOWER SURFACE.DAMAGE CUT OUT FOR AVO 15542 STEPS 2 AND 3 ACP ON LP 6153673 AND NDT ACP ON SAME LP. REMOVED FASTENERS COMMON TO REPAIR DOUBLER REF, AVO. 15542 REV. A, READY FOR NDT OPEN HOLE INSPECTION. ACPD HFEC PER AVO 15542 ITEM 5A ASDR CALA2025092209110Skin · crackedTWO CRACKS SIGNAL NOTED AT STAB LH SIDE STA129.50, FIRST CRACK L =0.500 INCH LOCATED TO 10.300INCH FWD FROM AFT SPAR, SECOND CRAC K L=0.625INCH LOCATED TO 18.250 INCH FWD FROM AFT SPAR PERFORMED PERMANENT REPAIR ON HORIZONTAL STABILIZER LOWER SKIN L H SIDE SSDR CALA2025092209083Door Frame · crackedTYPICAL CRACK FOUND AT FWD GALLEY DOOR INTERNAL AFT AREA ABOVE AND ADJACENT TO SEAL DEPRESSOR. REMOVED AND REPLACED FRAME AT FWD GALLEY DOOR IAW B737 SRM 51-40-02-0G-0 , AND DWG 141A8370.SDR AALA202509190026Battery · no testAIRCRAFT IN BASE MAINTENANCE: FAULT MESSAGE FOR EMERGENCY POWER SUPPLY UNIT 14WL DISPLAYED DURING SYSTEM TEST. REPLACED BATTERY FOR EMERGENCY POWER SUPPLY UNIT 14WL AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR AALA202509199630Battery · no testAIRCRAFT IN BASE MAINTENANCE: FAULT MESSAGE FOR EMERGENCY POWER SUPPLY UNIT 11WL DISPLAYED DURING SYSTEM TEST. REPLACED BATTERY FOR EMERGENCY POWER SUPPLY UNIT 11WL AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR ASAA2025091260935Floorbeam · corrodedAFT WET AREA, AT STA.986.5 AND RBL.43 UPPER CHORD OF FLOOR BEAM HAS A CORRODED FASTENER HOLE. GROUNDED - YES. REMOVED DAMAGE IAW B737-900ER SRM 53-70-51-2R-6 PERFORMED HFEC CUT AND MAT. ID, ROTO PEEN, HEAT TREATED, FABRICATED, APPLIED PROTECTIVE TREATMENT AND SDR AALA202509187377Bottle · low pressureAIRCRAFT IN BASE MAINTENANCE: R2 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202509185612Bottle · low pressureAIRCRAFT IN BASE MAINTENANCE: L3 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202509184396Bottle · low pressureAIRCRAFT IN BASE MAINTENANCE: R3 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202509186022Bottle · low pressureAIRCRAFT IN BASE MAINTENANCE: L2 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202509173352Proximity Switch · intermittentAIRCRAFT WAS GROUNDED: CABIN 1R DOOR ARMED LIGHT INTERMITTENTLY INFLIGHT ON LOWER ECAM AND AT THE SAME TIME THE DOOR CABIN OVER PRESSURE FLASHING RED ON THE DOOR. MAINTENANCE REPLACED PROXIMITY SWITCH (13WV2) IAW AMM 52-71-11-000/400-001-A.SDR AALA202509174386Idg · out of toleranceAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHTS AND SEATBELT SIGN AND NO PORTABLE DEVICES SIGNS AND ALL LIGHTS INCLUDING EMERGENCY LIGHTS COME ON AND START FLASHING WITH SOME SORT OF HIGH PITCH ALARM WITH NO CREW INPUT. CABIN LIGHTS GO TO FULL BRIGHT AND CAN NOT BSDR AALA202509177734Module · failedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHTS AND SEATBELT SIGN AND NO PORTABLE DEVICES SIGNS AND ALL LIGHTS INCLUDING EMERGENCY LIGHTS COME ON AND START FLASHING WITH SOME SORT OF HIGH PITCH ALARM WITH NO CREW INPUT. CABIN LIGHTS GO TO FULL BRIGHT AND CAN NOT B