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 DALA2025090206488Seat Track · corrodedSEAT TRACK FR 20 RBL 44 HAS EXCESSIVE CORROSION. REMOVED DAMAGED SEAT TRACK AND INSTALLED NEW SEAT TRACK FROM RBL 44 FR 20 TO FR 30 I.A.W DWG BOMBARDIER PL C01342701 REV-E AND A220 ASRP BD500-A-J51-42-20-00AAA-078A-A. (LP# 1163286)SDR DALA2025090206487Light · inoperativeLH AFT FUSELAGE EXTERNAL EMER LIGHT INOP. REMOVED AND INSTALLED NEW LH AFT FUSELAGE EXTERNAL EMERGENCY LIGHT, OP CHECK GOOD, I.A.W A220 AMP BD500-A-J33-55-02-01AAA- 720A-A. (LP# 1163012)SDR DALA2025090206486Light · inoperativeRH AFT FUSELAGE EXTERNAL EMER LIGHT INOP. REMOVED AND INSTALLED NEW RH AFT FUSELAGE EXTERNAL EMERGENCY LIGHT I.A.W A220 AMP BD500-A-J33-55-02-01AAA-720A-A. OP CHECK GOOD. (LP# 1163004)SDR DALA2025090206485Light · inoperativeRH FWD OVERWING EXTERNAL EMER LIGHT INOP. REMOVED AND INSTALLED NEW EMERGENCY LIGHT, OP CHECK GOOD I.A.W A220 AMP BD500-A-J33-55-02-02AAA-720-A. (LP# 1162987)SDR AALA202509024893Power Supply · no testAIRCRAFT IN BASE MAINTENANCE: EMERGENCY POWER SUPPLY UNIT 10WL DOES NOT PASS SYSTEM TEST. MAINTENANCE REPLACED EMERGENCY POWER SUPPLY UNIT 10WL (AALA202509028249) AND BATTERY (AALA202509025754) PER AMM 33-51-38. MAINTENANCE ALSO REPLACED PASSENGER / CREW DOOR SDR AALA202509025754Battery · no testAIRCRAFT IN BASE MAINTENANCE: EMERGENCY POWER SUPPLY UNIT 10WL DOES NOT PASS SYSTEM TEST. MAINTENANCE REPLACED EMERGENCY POWER SUPPLY UNIT 10WL (AALA202509028249) AND BATTERY (AALA202509025754) PER AMM 33-51-38. MAINTENANCE ALSO REPLACED PASSENGER / CREW DOOR SDR AALA202509028249Power Supply · no testAIRCRAFT IN BASE MAINTENANCE: EMERGENCY POWER SUPPLY UNIT 10WL DOES NOT PASS SYSTEM TEST. MAINTENANCE REPLACED EMERGENCY POWER SUPPLY UNIT 10WL (AALA202509028249) AND BATTERY (AALA202509025754) PER AMM 33-51-38. MAINTENANCE ALSO REPLACED PASSENGER / CREW DOOR SDR 2025FA0000604Servo · defectiveMOMENTARY ENGINE ROUGHNESS/VIBRATION/LOSS OF POWER. ENGINE FLUCTUATING 200-250 RPMS AT ALL RPM SETTINGS ON THE RAMP, DURING TAXI, AND DURING THE RUNUP. RAN THE ENGINE ROUGHNESS CHECKLIST WITH NO CHANGE. UNABLE TO GET A FIRM READING ON THE MAG DROP DURING RUNUPSDR 2025FA0000601Servo · contaminatedMOMENTARY ENGINE ROUGHNESS/VIBRATION. AIRCRAFT HAD MOMENTARY POWER LOSS AFTER ADDING FULL POWER ON A TOUCH AND GO. ABORTED TAKEOFF. TOOK AIRCRAFT TO A RUNUP AREA AND CYCLED THE ENGINE FROM POWER IDLE TO FULL POWER MULTIPLE TIMES AND COULD NOT RECREATE THE ISSUSDR CALA2025090108303Rib · crackedCRACK AT RTGHT HORIZONTAL STABILIZER STA 129.50 INSPAR RIB.FWD TO AFT ,3RD STIFFNER LOWER CHORD AREA. REF AAR N/R 97530105. ESFR INFORMATION UPDATED ACCOMPLISHED REPAIR RIGHT HORIZONTAL STABILIZER RIB #5 PER REF SRM 55-10-09-2R-4 REPAIR 4 DETAIL "A" FIG SDR DALA2025083106423Computer · faultedDIV- TO LHR DUE TO INTERMITTENT VIBRATIONS FELT BY CREW. REPLACED ELEVATOR FEEL COMPUTER DUE TO ONE CHANNEL INOP.(7600378)SDR DALA2025083106422Pseu · faultedDIV- TO JFK DUE TO NOSE A/G DISAGREE WITH TO CONFIG / FLAPS WARNING MESSAGE IN CRUISE. REPLACED PSEU, FSEU, WARN ELEX POWER SUPPLY MODULE B, T/O CONFIG MODULE, AND NOSE NOT COMPRESSED SENSOR S266.(7867730)SDR DALA2025083106418Lens · loose33F EMERGENCY LIGHT LOOSE. SECURED LOOSE LENS. CKS GOOD. OK FOR SVC IAW B767-300 AMM 33-51- 10 (7547618)SDR DALA2025082906400Manifold · crackedCRACK INDICATION FOUND ON LEFT MLG NORMAL BRAKE MANIFOLD LOCATED ON BOTTOM THREAD. REPLACED LEFT MLG NORMAL BRAKE MANIFOLD AS PER A320 FAM AMM 32- 42-16-000-001-A, AMM 32-42-21-000-001-A, AMM 32-42-16-400-001-A, AMM 32-42-00-720-002-A AND 27-96-00-740-001-A.SDR SWAA2025082908329Tire · blownSUSPECTED MLG TIRE BLOWN ON TAKEOFF. PERFORMED CONDITIONAL INSPECTION FOR TIRE BURST IAW AMM 05-51-54. CONFIRMED TIRE BLOWN, REF TTG8Q014SP1Z FOR FINDINGS OF CONDITIONAL INSPECTION AND WO 04719292. ALL WORK ACCOMPLISHED PER APPLICABLE AMMS. ACFT OK FOR SERSDR AALA202508294156Shear 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-72-11.SDR AALA202508299456Shear 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-72-11.SDR AALA202508298251Attach Bolt · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION BOLT ATTACHMENT SLAT TRACK 8 (LOWER MID) ON LH WING L=0.443 INCH, W=0.167 INCH AND D=0.002 INCH. MAINTENANCE REPLACED ATTACHE BOTL AT SLAT TRACK 8 ON LH WING.SDR AALA202508298555Attach Bolt · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION BOLT ATTACHMENT SLAT TRACK 8 (LOWER FWD) ON LH WING L=0.445 INCH, W=0.169 INCH AND D=0.001 INCH. MAINTENANCE REPLACED ATTACH BOLT AT SLAT TRACK 8 ON LH WING.SDR AALA202508294542Attach Bolt · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION BOLT ATTACHMENT SLAT TRACK 7 (LOWER BOLT) ON LH WING L=0.449 INCH, W=0.170 INCH AND D=0.002 INCH. MAINTENANCE REPLACED ATTACH BOLT AT SLAT TRACK 7 ON LH WING.SDR AALA202508298290Attach Bolt · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION BOLT ATTACHMENT SLAT TRACK 3 (LOWER BOLT) ON LH WING L: 0.450 INCH, W: 0.171 INCH, D: 0.001 INCH. MAINTENANCE REPLACED ATTACH BOLT AT SLAT TRACK 3 ON LH WING.SDR N6WA2025082806Strap · corrodedCORROSION ON STRAP RH OTBD FS909 OF WING TO FUSELAGE FAIRING STRUCTURE. REMOVED AND REPLACED STRAP ON RH OTBD FS909 OF WING TO FUSELAGE FAIRING STRUCTURE IAW CRJ SRM 51-42-06SDR N6WA2025082805Strap · corrodedCORROSION ON STRAP LH OTBD FS909 OF WING TO FUSELAGE FAIRING STRUCTURE. REMOVED AND REPLACED STRAP ON LH OTBD FS909 OF WING TO FUSELAGE FAIRING IAW CRJ SRM 51-42-06SDR N6WA2025082804Angle · corrodedCORROSION ON ANGLE AND STRAP MID FS909 OF WING FUSELAGE FAIRING STRUCTURE. REMOVED AND REPLACED ANGLES AND STRAP MID FS909 OF WING TO FUSELAGE FAIRING STRUCTURE IAW CRJ SRM 51-42-06SDR LDIA2025082500001Engine · damagedAIRCRAFT WAS CRUISING AT FL 250 FROM KBFI TO KEUG. THE THROTTLES RETARDED FOR DESCENT & SMOKE BEGAN EMANATING FROM COCKPIT WEMACS. SMOKE LIGHT & BECAME THICKER, DID NOT OBSCURE VISION. AN OIL ODORL OBSERVED. SEVERAL SECS LATER OIL 2 LIGHT ILLUMINATED, PIC OBSDR CWQA20250828001A/C Pack · failedCREW REPORTED SMOKE AND ELECTRICAL SMELL IN THE COCKPIT COMING FROM LEFT SIDE FLOOR VENTS DURING CRUISE APPROXIMATELY TWENTY MINUTES INTO THE FLIGHT. CREW DECLARED AN EMERGENCY, BEGAN AN EMERGENCY DESCENT, AND REMOVED ELECTRICAL POWER TO NON-ESSENTIAL CABIN ISDR YENA2025082800894Control Valve · failedFLT#33, BOS-CDG. (ETOPS) APU MAINTENANCE MESSAGE ( CLASS II MAINTENANCE MESSAGES DISPLAYED ); PERFORMED REMOVAL AND REPLACEMENT OF APU LOAD CONTROL VALVE PER AMM 49-51-51. OPS CHECK GOOD NO FAULTS APPEAR ON ECAM, NO LEAKS NOTED. AIRCRAFT SYSTEM RESPONDS NORMASDR DXTA2025082804725Motor · faultedMAIN ENTRY DOOR LATCHING HANDLE DOES NOT MOVE TO THE LATCHED POSITION SMOOTHLY, REGARDLESS WHETHER IT IS BEING CLOSED FROM THE INSIDE OR OUTSIDE. IT FEELS LIKE ONE OR MORE OF THE LATCHING PINS IS OUT OF ALIGNMENT. REMOVED AND REPLACED MAIN CABIN DOOR LIFTINSDR UIEA2025082501140Antenna · faultedCOULD NOT RECEIVE ON EITHER HF RADIO. CONFIRMED WITH ATC W/ CPDLC THAT WE WERE TRANSMITTING. REMOVED AND REPLACED HF RADIO ANTENNA IAW AMM 23-11-04. OPS CHECK GOOD.SDR SCNA20250828341Strip · unsecureFLOOR STRIP IN FWD GALLEY BETWEEN NICKLE BOARD AND AISLE RUNNER DAMAGED, TRIP HAZARD. REPLACED STRIP BETWEEN NICKLE BOARD AND AISLE RUNNER IAW AMM25-27-15 OK FOR SVCSDR CALA2025082808238Hydraulic System · leakingHYD Y SYS LO LVL ECAM APPEARED AFTER TAKEOFF. CREW STATED THEY LOST YELLOW SYS ON TAKEOFF. SHUT YELLOW HYD ELECT PUMP OFF IMMEDIATELY. FLT WAS JUST OVER A HOUR. CONFIRMED YELLOW SYS EMPTY ON LOWER SERVICE PANEL QTY GAUGE & ON PANEL. MET ACFT ON TAXIWAY, ACFT SDR CALA2025082808237Pressure Gauge · faultyENGINE 2 ANTI ICE LIGHT ILLUMINATED AT TOD SECOND WRITE UP TOP = TOP OF DESCEND. ONCE FLIGHT CREW STARTED TO RETARD THE LEVER, THE ENG2 ANTI-ICE ILLUMINATED. FOUND MSG 36-21011 ACTIVE, OCCURED DURING DESCENT AND ENG START. PERFORMED GND TEST PER FIM 36-21 TASKSDR CALA2025082808236Lavatory · faultyALL LAVS INOP 20 MINS AFTER TAKE OFF. REPEAT WRITEUP. DEBRIEF FLIGHT CREW AFTER DIVERSION EWR-DEN (UA2120) FLIGHT CREW REPORTED THAT ALL LAVATORIES STOPPED WORKING RIGHT AFTER TAKEOFF FROM NEWARK. UPON ARRIVAL INTO ORD FOUND SAME CB OPEN ON P91 PANEL (VACUUMSDR CALA2025082808216Slide · no discrepancyFA REPORTS SLIDE ON 1R DOOR IS PROTRUDING AND DRAGGING ON THE FL OOR VISUALLY INSPECTED R1 SLIDE FOUND NO PROTRUSION OF THE SLIDE, AND SLIDE IS IN THE CORRECT POSITION SO NO DRAGGING WAS FOUND. OPEN AND CLOSED R1 DOOR FOR SMOOTH OPERATION. ARMED AND DISARMED RSDR CALA2025082808215Not Reported · no discrepancyPREVIOUS FLIGHT PAX REPORT WATER LEAKING FROM EXIT ROW DOOR. INSPECTED AND DID NOT FIND ANY FLUID COMING FROM ANYWHERE IN THE ARE OF ANY OF THE EXIT ROW DOORS. NO OTHER DEFECTS WERE NOTED.SDR CALA2025082808214Indication Sys · no discrepancyPERFORM AFT ENTRY DOOR INDICATION AND SENSOR TEST (S200) REF. AMM 52-71-11-710-801. PERFORMED AFT ENTRY DOOR INDICATION SENSOR TEST (S200) REF. AMM 52-71-11-710-801. VERIFIED DOOR WARNING SYSTEM IS FUNCTIONING NORMALLY. VERIFIED AFT ENTRY DOOR INDICATION FUNCTSDR CALA2025082808213Slide · no discrepancyDOOR 1R SLIDE HAS EXCESS MATERIAL EXPOSED CAUSING SLIDE TO DRAG WHEN DOOR OPENED AND CLOSED. A CHECK OF 1R SLIDE PACK REVEAL SLIDE Z FOLD TO BE WITHIN LIMITS OF AMM25-66-01-400-801. FABRIC IS NOT EXCESSIVELY LONG, AND DOES NOT IMPEDE DOOR OPERATION.SDR CALA2025082808212Door · no discrepancyVERIFY DOOR L1 IS PROPER CLOSED BEFORE DEP AS PER DDP OF MEL 5271E. C/W DDP PER MEL 5271E AND VERIFIED L1 DOOR IS PROPERLY CLOSED. A/C OK TO CONT.SDR CALA2025082808211Slide · low pressureDUE TO DOOR SLIDE AT 2L BEING SLOW TO INDICATE WITHIN THE GREEN BAND REPLACE THE 2L SLIDE IAW 25-66-01-401 CARRIED BY ELB REMOVED AND REPLACED L2 DOOR SLIDE PER AMM 25-66-01-404-044.NO FURTHER DEFECTS NOTED.ALL TESTS NORMAL AT THIS TIME. C/W RII INSPECTION OFSDR CALA2025082808210Bottle · no discrepancyPLEASE CHECK DOOR 2L PRESSURE GAUGE INSPECTED DOOR 2L PRESSURE GUAGE. FOUND NEEDLE ONE NEEDLE WIDTH OVER (TOWARDS HIGHER END OF BAND) IAW AMM 25-66-02 A/C OK TO CONT. NOTE: A/C CABIN WAS HOT PRIOR TO APU PACKS BEING TURNED ON.SDR DALA2025082806363Seat Track · corrodedAIRCRAFT 3767, CORROSION LEVEL 2- SEAT TRACK SECTION LBL 24.75 BTW STA 500H TO 520 AT PAX CABIN FLOOR STRUCTURE. CORRECTIVE ACTION: REPLACED SEAT TRACK SECTION LBL 24.75 BTW STA 500H TO 520 PER B737-800 SRM 51-40-02-0G PAR. 7. (LP 1163766)SDR DALA2025082806362Receptacle · crackedAIRCRAFT 3769, CRACK ON INNER STRAP ON GROUND POWER RECEPTACLE AT LOWER FUSELAGE. CORRECTIVE ACTION: GROUND POWER RECEPTACLE AT LOWER FUSELAGE WAS REPAIRED PER B737-800 SRM 53-10-15-2R PROCEDURE 5 REPAIR 5. (LP 1163677)SDR DALA2025082806361Receptacle · crackedAIRCRAFT 3769, CRACK ON INNER STRAP ON GROUND POWER RECEPTACLE AT LOWER FUSELAGE. CORRECTTIVE ACTION: GROUND POWER RECEPTACLE AT LOWER FUSELAGE WAS REPAIRED PER B737-800 SRM 53-10-15-2R PROCEDURE 5 REPAIR 5. (LP 1163662)SDR DALA2025082806360Floorbeam · damagedAIRCRAFT 3870, CABIN FLOOR BEAM STA 947 RBL20 OUT OF LIMITS AREA. CORRECTIVE ACTION: INSTALLED REPAIR ON THE CABIN FLOORBEAM AT STA 947 RBL20 IAW B737-900 SRM 53-70-51-2R-8. (LP 1163645)SDR DALA2025082806359Skin · crackedAIRCRAFT 3766, CRACK ON LOWER SKIN APROX STAB STA 101.90 AT RH HORIZONTAL STABILIZER. CORRECTIVE ACTION: CRACK ON LOWER SKIN APROX STAB STA 101.90 AT RH HORIZONTAL STABILIZER WAS REPAIRED PER B737-800 SRM 55-10-01-2R PROCEDURE 11. (LP 1163553)SDR DALA2025082806358Skin · crackedAIRCRAFT 3766, CRACK ON LOWER SKIN APROX STAB STA 101.90 AT RH HORIZONTAL STABILIZER. CORRECTIVE ACTION: CRACK ON LOWER SKIN APROX STAB STA 101.90 AT RH HORIZONTAL STABILIZER WAS REPAIRED PER B737-800 SRM 55-10-01-2R PROCEDURE 11 CATEGORY B REPAIR. (LP 1163546SDR DALA2025082806357Threshold · corrodedAIRCRAFT 3870, AFT CARGO COMP- CARGO DOOR THRESHOLD AREA- HAS DAMAGE/CORROSION, MULTIPLE LOCATIONS. CORRECTIVE ACTION: REMOVED AND REPLACED AFT CARGO DOOR THRESHOLD AREA WEB IAW B737-900 SRM 53-60-15-A-2 AND SRM 41-40-02-0G. (LP 1163467)SDR DALA2025082806356Floorbeam · corrodedAIRCRAFT 3769, CORROSION OUT OF LIMITS ON FLOOR BEAM STA 986.5 BTW LBL 45 TO LBL 46. CORRECTIVE ACTION: PREVIOUS REPAIR ON BEAM STA 986 BTW LBL 25/50 WAS REPLACED PER B737-800 SRM 51-40-02-0G. (LP 1163445)SDR DALA2025082806355Threshold · corrodedAIRCRAFT 3870, R-1 DOORWAY THRESHOLD CHORD HAS DEEP CORROSION. CORRECTIVE ACTION: REPAIRED/REPLACED R-1 DOORWAY THRESHOLD CHORD IAW B737-900 SRM 51-40-02-0G. RESTORED FININSH IAW B737- 900 21-20-01-0G, 53-10-15-01-2, SOPM 20-41-02. (LP 1163393)SDR DALA2025082806354Frame · crackedAIRCRAFT 3767, INITIAL INSPECTION: CRACK ON FRAME STA 400 BTW STR 9 AND 8 RH SIDE AT PAX CABIN. CORRECTIVE ACTION: FRAME STA 400 BTW STR 9 AND 8 RH SIDE AT PAX CABIN WAS REPAIRED PER B737-800 SRM 53-00-07-2R-1 REPAIR 1. (LP 1162366)