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 IPXA2025080106493Roller · gougedAFT CARGO COMPT ROLLER @ FRAME 57 LBL 30 DAMAGED. REMOVED AND REPLACED ROLLER BRAKING IAW AMM 25-58-34/0401.VERIFIED 1 EACH ROLLER REMOVED AND REPLACED. JOB COMPLETE.SDR NACA2025070700003Web · crackedFOUND ONE CRACK AT RT PYLON FWD UPPER SPAR WEB, HYDRAULIC HOLE AREA AT ABOUT NSTA 180. REPAIRED THE NR 2 PYLON FORWARD UPPER SPAR WEB IAW EO 767-54-0014 REV 1R AND EO 767-54-0014 REV 1RSDR NACA2025070700002Shutoff Valve · no testFOUND RT ENGINE PRSOV HEALTH CHECK FAIL. REMOVED AND REPLACED THE NR 2 ENGINE PRSOV AND CARRIED OUT TEST IAW AMM 36-11-09 REV 145.SDR NACA2025070700001Seal · leakingRIGHT HEAT EXCHANGER SLEEVE FOUND AIR LEAK. REMOVED AND REPLACED RT AIR CONDITIONING AFT SURFACE BODY CROSS OVERDUCT SLEEVE SEAL IAW AMM 36-11-01 REV 145. NO LEAK.SDR DALA2025073105727Structure · ground damageAIRCRAFT 3060, DURING GROUND OPERATIONS IN PNS, THE HORIZONTAL STABILIZER IMPACTED A BUILDING CAUSING DAMAGE TO THE RH SIDE OF THE ASSEMBLY. THERE IS ALSO POTENTIAL DAMAGE TO THE NOSE LANDING GEAR FROM AN OVERLOAD CONDITION DUE TO THE ABRUPT IMPACT. CORRECTIVESDR JJBA20250730115Doubler · misinstalledCTR FUSELAGE I, UNRECORDED REPAIR DOUBLER FOUND ON UPPER SKIN PANEL BTW FR16-17 AND STR 3R-4R. CTR FUSELAGE, UNRECORDED REPAIR DOUBLER REMOVED. CTR FUSELAGE 1 PATCH REPAIR MADE BTW FR 16-17 AND STR 3R-4R CTR FUSELAGE 1 PATCH REPAIR INSTALLED BTW FR 16-17 AND SSDR SCNA20250728283Bulkhead Web · crackedWO 88396, NR00018, 00264: EMP 10001189 IN REFERENCE TASK CARD ENG-57SCA-11508: CRACKS (3 EAS) ON VERTICAL PRESSURE DECK OF STA 663 BTW LBL 25 AND LBL 45 AT MLG WHEEL WELL. RESOLUTION: IN PROGRESSSDR SCNA20250728281Skin · crackedCRACK ON LOWER SKIN AT RH HORIZONTAL STABILIZER, STAB STA 120 (SAFETY IN/OUT ITEM 6). OPENSDR SCNA20250728280Bulkhead Web · crackedWO 88936 NR00265: IN REFERENCE TASK CARD ENG-57SCA-11509: CRACKS (3 EAS) ON VERTICAL PRESSURE DECK OF STA 663 BTW RBL 25 AND RBL 45 AT MLG WHEEL WELL. - RESOLUTION: IN PROGRESSSDR SCNA20250728277Pressure Deck · crackedCRACK ON PRESSURE DECK WEB AT STA 663 & RBL 42, MLG WHEEL WELL.. CRACK ON PRESSURE DECK WEB AT STA 663 & RBL 42, MLG WHEEL WELL WAS REPAIRED UNDER NRC 00265SDR JJBA20250728093Support · corrodedLH SILL BTW FR 60-61 FOUND CORRODED. CORRODED ANCHOR NUT REMOVED ON LH SILL BTW FR 60-61. LH SILL BTW FR 60-61 CORRODED, FOUND OUT OF LIMITS. CORRDED LH SILL BTW FR 60-61 REMOVED. LH SILL BTW FR 60-61 REMOVED AND INSTALLED.SDR S2KA202507210452Fire Detector · inoperativeRIGHT ENGINE FIRE WARNING TEE HANDLE LIGHT CAME ON IN FLIGHT. REMOVED RT FIRE DETECTION CONTROL UNIT P/N 37702833 S/N 0143-069 AND INSTALLED REMOVED SERVICEABLE FIRE DETECTION CONTROL UNIT P/N 377-02833, S/N 9938-006 IAWL31A 26-10-01. OPERATIONAL CHECK GOOD SDR AALA202507214857Proximity Sensor · faultyAIRCRAFT WAS GROUNDED: DOOR L1 ECAM ON TOUCHDOWN. T/S PER TSM 52-11-00-810-804-A FOUND VOLTAGE (13WV1) CONNECTOR PINS A AND D LESS THAN THE 6VDC. MAINTENANCE REPLACED THE SLIDE ARMED INDICATOR IAW AMM 52-73-21. CHECKED VOLTAGE AGAIN VOLTAGE IS 6VDC. OPERATIONASDR AJXA2025072100033Warning Message · false activationDURING CLIMB EICAS AMBER CAS MESSAGE "CABIN ALTITUDE" ILLUMINATED. THE PRESSURIZATION SYSTEM WAS PLACED ON MEL AND FLOWN TO MAINTENANCE IN KOAK. ONCE IN MAINTENANCE THE PRESSURIZATION WAS TESTED AND THE DEFECT COULD NOT BE DUPLICATED. ALL COMPONENTS OF THE SYSSDR IPXA2025071607273Floor Panel · brokenMAJOR REPAIR, MDC FLOOR PANEL 231QH WITH CORNER BROKEN FABRICATED FLOOR PANEL 231QH IAW A300 SREO-16407-REQ001. PAINTED IAW AMM 25-00-00/801.SDR SWAA2025071788824Battery Pack · inoperativeEMERGENCY LIGHT RT BATTERY PACK AT BS 565 IS INOPERATIVE. R & R EMERGENCY LIGHT BATTERY PACK AT BS 565 IAW MM 33-51-06. CABIN EMERGENCY LIGHTS OPS CHECKED GOOD PER MM 33-51-06.SDR AALA202507178049Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT HAND PYLON SPIGOT FITTING RECEPTACLE BETWEEN PYLON RIBS 4 AND 5. REPLACED SPIGOT FITTING PER SRM 54-51-12-300-001.SDR AALA202507175967Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND PYLON SPIGOT FITTING RECEPTACLE BETWEEN PYLON RIBS 4 AND 5. REPLACED SPIGOT FITTING PER SRM 54-51-12-300-001.SDR SCNA20250717264Skin · dentedFOUND DENT BETWEEN STA. 1006 AND 1013 BETWEEN STRINGERS 12L AND 13L. DENT IS OUT OF LIMITS PER SRM 53-00-01 TABLE 2 NO CRACKS NOTED IN PAINT. REPAIRED DAMAGED FUSELAGE SKIN @STA 1006-1013 STR 12L TO 13L PER ER 25-02325 REV. P1 AND ENG-53SCA-11709 REV 00.SDR CALA2025071606611Web · crackedSHEAR WEB @ FR 11 ON F/O SIDE UNDER FLOOR CRACKED. REMOVED AND REPLACED SHEAR WEB, FR 11, F/O SIDE UNDER FLOOR IAW SRM 51-42-11 AND SURFACE PROTECTION IAW SRM 51-23-11 AND 51-21-00.SDR IPXA2025071295380Bear Strap · crackedCRACK, FWD ENTRY DOOR AFT LOWER CORNER BEAR STRAP. INSTALLED INSULATION BLANKET IAW AMM 25-80-00-400-803 REV. 145, JOB COMPLETED AND CONDITION CHECK NORMAL. IAW AMM 20-11-00-910-802 REV 145 INSTALLED THE E/E COOLING DUCT AT MEC P31. IAW AMM 24-22-00-862-001 RESDR FDEA202507071127Frame · no discrepancyEXISTING REPAIR ON MAIN DECK FRAME 13A BETWEEN STGR20RH AND STGR26RH REQUIRES EVALUATION FOR CONFORMITY. THE EXISTING REPAIR ON MAIN DECK FRAME 13A BETWEEN STGR20RH AND STGR26RH WAS EVALUATED AND FOUND IN CONFORMITY WITH A300-600F SRM53-12-13-201 FIG 201. SDR JJBA20250715050Shear Tie · crackedSHEAR CLIP AT FR59 AND BTW STR 15L-16L FOUND CRACKED. AT FR59 BTW STR 15L-16L SHEAR CLIP REMOVED AND REPLACEDSDR AALA202507148431Tube · missingAIRCRAFT WAS NOT GROUNDED: R2 DOOR ESCAPE SLIDE AFT END OF GIRT BAR MISSING RED HEAT SHRINK, PER J/C 08L22125001 AND AARD 25-66-00-4. **SUPPLEMENTAL REPORT FOR (AALA202507088431): INSTALLED R2 DOOR GIRT BAR RED HEAT SHRINK, PER AARD 25-66-00-4. NO FURTHER DEFESDR AALA202507147961Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER ATTACH ANGLE AT STA 663.5, LBL 8. REPAIRED PER SRM 57-10-10-2R-5.SDR AALA202507140181Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER ATTACH ANGLE AT STA 663.5, RBL 8. REPAIRED PER SRM 57-10-10-2R-5.SDR AALA202507141091Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 927 TO BS 947 AT BL 0. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202507138414Battery Pack · inoperativeAIRCRAFT IN BASE MAINTENANCE: MULTIPLE EMERGENCY LIGHTS ARE OUT. SUSPECT BATTERY POWER SUPPLYTO BE BAD. REMOVED AND REPLACED 9RH BATTERY PACK. PER B737-NG-AMM 33-51-06 AND PERFORMED SATISFACTORY OPERATIONAL TEST OF EMERGENCY LIGHTS, PER B737NG AMM 33-51-00.SDR ASAA2025070759333Battery Pack · inoperativeEMERGENCY LIGHTS ASSOCIATED WITH BATTERY PACK M1671 ARE INOP. GROUNDED - YES. REMOVED AND REPLACED EMER LIGHT BATT PWR SUPPLY AT M1671 IAW B737NG AMM 33-51-06-960-806. OPS CK GOOD. (S/N 113358)SDR SWAA2025071188814Light · inoperativeCEILING LIGHTS INOP AT ROWS 2 & 24.SDR DALA2025071105238Coffeemaker · smoke(LOG 7738316) FA IN FWD GALLEY ORSERVED SMOKE FROM THE TOP OF THE COFFEE MAKER BEFORE THE BREW PROCESS BEGAIN. SHE TURNED IT OFF AND THE SMOKE STOPPED. INSPECTED FWD COFFEE MAKERS AND FOUND NO INDICATION OF SMOKE OR BURNING ON EITHER COFFEE MAKER. REPLACED BOTSDR DALA2025071105228Skin · damaged(LOG 1068562) FOUND DAMAGE AT STA 807 BY S-2R. ACCOMPLISHED REPAIR INSTRUCTIONS 4 A-E PER SRM 53-00-01-2R-35.SDR DALA2025071105227Window Frame · cracked(LOG 1069452) CRACK OF 0.220IN LENGTH WAS FOUND ON NO. 1 LH WINDOW FRAME INNER CORNER RADIUS. NO. 1 LH WINDOW FRAME WAS REPAIRED PER ERA 619132-14ADTR REV. A SECTION I: PERMANENT REPAIR.SDR DALA2025071105226Floorbeam · corroded(LOG 1067984) CORROSION OUT OF LIMITS (UT) THICKNESS MEASUREMENT ON FLOOR BEAM STA 985 AT PASSENGER CABIN. CORROSION ON FLOOR BEAM STA 985 AT PASSENGER CABIN RBL46 TO RBL33 AND LBL42 TO LBL44 WAS REPAIRED PER ER/A 464736-14MA REV.A.SDR JJBA20250711008Shear Tie · crackedCF2 RH SHEAR CLIP FR24 BTW STR 15R-16R CRACKED. CF2 RH SHEAR CLIP FR24 BTW STR 15R-16R REMOVED AND INSTALLEDSDR CALA2025071106444Warning Message · illuminatedDOOR FLIGHT LOCK 1R EICAS STATUS #1 RIGHT PASSENGER ENTRY DOOR FLIGHT LOCK COMMAND/FLT LOCK RELAY/SENSOR DISAGREEMENT. FIM TASK REFERENCE NOT FOUND CMC MSG# 5211290. FOLLOWED FIM PROC. 52-11 TASK 80T REV. 104 OK NO EICAS MESSAGE IN VIEW.SDR CALA2025071106443Girt Bar · out of position1R DOOR RAFT GIRT BAR HAS EXCESS MATERIAL HANGING WHEN STOWED /DISARMED, EXCESS MATERIAL TUCKED PER AMM TASK 25-66-01-601-804, NO FURTHER DEFECTS NOTED AT THIS TIME.SDR ASAA2025070759293Power Supply · inoperativeEMERGENCY LIGHTS ASSOCIATED WITH BATTERY PACK M1694 ARE INOP. GROUNDED - YES. REMOVED AND REPLACED EMERGENCY POWER SUPPLY M1694 S/N 113378 IAW B737NG AMM 33-51-06- 960-806.SDR SWAA2025071089177Blade · out of limitsON DEPATURE, NR 1 ENGINE MADE AT LEAST 2 LOUD BANGS, SHOOK THE ACFT AND CREATED A YAW. TOWER AND PAX REPORTED LARGE FLAMES SHOOTING OUT OF THE ENGINE. ENGINE ROLLED BACK ON ITS OWN. REDUCED THROTTLE AND IT STABLIZED. PERFORMED NR 1 ENGINE BORESCOPE INSPECTISDR DALA2025071005199Control Panel · faultedSHIP 1810 ENTRY/SERVICE DOOR SLIDE ARMED INDICATING LIGHT SYSTEM 2R DOOR ARM LIGHT ON PANEL INOP. CORRECTIVE ACTION: R/R LT AT FLIGHT ATTENDANT PANEL PER B767-400 AMM 52-70. (1068600).SDR AALA202507106493Skin · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FUSELAGE SKIN AT AFT LAVATORY SERVICE PANEL BETWEEN BS 847 AND BS 867, BETWEEN S24L AND S25L. REPAIRED SKIN PER EA 365990.SDR AALA202507106231Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON STRINGER 25L BETWEEN BS 845 AND BS 849. REPAIRED STRINGER PER SRM 53-00-03-2R-1.SDR AALA202507105876Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT BAFFLE CLIP AT BS 500H, RBL 24. REPLACED CLIP PER AARD 51-00-05-1.SDR COEA2025071002921Skin · ground damageDURING UNLOADING OF FLIGHT 7820, THE BELT LOADER MADE CONTACT WITH THE AIRCRAFT. DISCREPANCY: LOWER L/H LATERAL SKIN PANEL BETWEEN FRAMES 36-37 AND STRINGERS 16-17L HAS DENT FROM BELT LOADER. REPAIR COMPLETED PER SRAS ES_00264336_01-25790, ISSUE B.SDR CALA2025071006423Wire · damagedSEAT MOUNTED AISLE EMERGENCY LIGHT AT ROW 10 IS INOP. FOUND DAMAGED WIRE BETWEEN ROW 10 AND 11. REQUESTING MEL. APPLIED PROTECTIVE TAPE REF SWPM 20-10-13. TOMC APPROVED APPLIED PLACARD. *DM* IF UNABLE TO RESOLVE UPDATE LP WITH P/N AND PICS HARNESS P/N RD-FP12SDR CALA2025071006421Bottle · no discrepancySLIDE PRESSURE DOOR 1R BORDERLINE. NEEDS SERVICING SOON. CHECKED DOOR 1RT RESERVOIR PRESSURE AND FOUND IN THE GREEN BAND PER GAGE MODEL "A". PER AMM TASK 25-62-00-210-001-A. NO OTHER DEFECTS NOTED. VERDEJO, ISSAC (V950090) CHECKED DOOR 1RT RESERVOIR PRESSURE SDR CALA2025070906405Acoustic Liner · dentedPROBABLE BIRD STRIKE ON NOSE RADOMEWHILE PERFORMING VISUAL INSPECTION OF RADOME NO BIRDSTRIKE DAMAGE OR SIGNS OF IMPACT WAS FOUND TO RADOME. WHILE PERFORMING WALK AROUND INSPECTION, SIGNS OF BIRDSTRIKE INJESTION WAS FOUND IN NR 1 ENGINE. DAMAGE WAS NOTED TO 5SDR CALA2025070906378Check Valve · faultedAD 2020-16-51 HAS BEEN ISSUED TO ADDRESS THE ENGINE BLEED AIR 5T H STAGE CHECK VALVE. C/W 5TH STAGE VALVE INSPECTION ON #1 ENGINE, REPLACED DEFECTIVE VALVE, IAW AMM 36-11-02 AND EA 3611-01438 REV B. COMPLETED VALVE, CHECK, F. THIS ENTRY TO REPORT 5TH STAGESDR N6WA2025071009Skin · damagedFUSELAGE SKIN FWD LOWER SKIN PANEL BETWEEN STRG20R-21R AT FS453.00-FS469.00 IS DAMAGED. REPAIRED FUSELAGE SKIN LOWER SKIN PANEL BETWEEN FS453-FS469 AT STGR20R IAW GOJET EO-C550-53MR-076SDR N6WA2025071008Stringer · corrodedSTGR20 CORRODED AT FS442. REPAIRED STINGER20R BETWEEN FS364-FS409 AND FS421-FS477 IAW GOJET EO-C550-53MR-077