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 CALA2025062705978Slide · no discrepancyDOOR L2 SLIDE PRESSURE BELOW GREEN RANGE IAW AMM 25-62-00-210-001-A. MODEL A GAUGE NEEDLE AT TOP OF GREEN BAND, 2L WAS OPEN IN HEATED ENVIRONMENT FOR CATERING.SDR CALA2025062705977Warning Light · false activationAFT CARGO ILLUMINATED WITH DOOR CLOSED FOLLOWED MEL. DOOR CLOSED AND LATCHED AFT CARGO DOOR WARNING LIGHT WITH DOOR CLOSED. DEFERRED PER MEL ADJUSTED THE EXTENSION OF THE AFT INDICATION SWITCH PER AMM 52-71-31. PERFORMED CARGO DOOR INDICATION SWITCH TEST PER ASDR DALA2025062604794Angle · not reportedSHIP 9546 C/W LH WING BULKHEAD CLIP XRS164 PART MANUFACTURE ERA 626984-14 REV ORIG. CORRECTIVE ACTION: COMPLIED WITH LH WING BULKHEAD CLIP XRS164 PART MANUFACTURE ER/A 626894-14 REV A. (1043812)SDR DALA2025062604785Hydraulic Line · damagedSHIP 6823 ON FINAL APPROACH RECIEVED "GEAR DOOR" MESSAGE. RAN QRH AND RECIEVED SAME MESSAGE ON SECOND APPR. AFTER LANDING AIRCRAFT HAD STRONG PULL TO LEFT. LEFT HYD QTY WAS 0.750. CORRECTIVE ACTION: REF LOG 1042442 FOR ODI INFO. FOUND RT GEAR DOOR OPEN, FOUND SDR DALA2025062604782Switch · faulted6804 ESCAPE SLIDE GIRT BAR ENGAGEMENT LIGHT/S/ 1 RIGHT SLIDE LIGHT. CORRECTIVE ACTION: R/R "SLIDE" LIGHT SWITCH AS REQ'D. OPS NML. (1043774)SDR CALA2025062605933Idg · lowL GEN DRIVE LGT ON TAKEOFF ROLL. LOW SPEED REJECT. MAX SPEED 90K TS. INSPECTED #1 IDG NO LEAKS NOTED DPI INDICATOR NOT POPPED FOUND LOW OIL QTY, SERVICED 3 QUARTS OF OIL REF MM 12-13-03 BIT BPCU LAST LEG FAULT FOR L/H GEN 2 FAULTS PRESENT "SERVICE IDG" - "IDG SDR CALA2025062605916Slide · low pressureSLIDE RAFT AT DOOR 3L PRESSURE GAUGE YELLOW NEEDLE IS OUT OF GREEN ON THE LOW SIDE. PX GAUGE READING BELOW GREEN LEVEL. REQUEST TO APPLY MEL 5211L. MEL 5211L TOMC REJECTING DEF REQUEST - MX TO REPLACE DR 3L SLIDE DOOR 3L DOOR MOUNTED ESCAPE SLIDE PACK REMOVEDSDR CALA2025062605915Floorbeam · corrodedCABIN FLOORBEAM HAS BARE METAL STA 1661 LBL-57" TO RBL-57". REPAIRED CABIN FLOORBEAM BS 1661 LBL-57 TO RBL 57 IAW EC/RA 5360-01972 THIS IS A CATEGORY A REPAIR NO DIPS REQUIRED F OR INSPECTION. RII VERIFIED AND APPROVED.SDR CALA2025062605914Lamp · burned outEMERGENCY LIGHTING SYSTEM OPERATIONAL CHECK. DOOR 2L EXTERNAL EMERGENCY LIGHT INOP. REPLACED THE LAMP, OPS OK IAW AMM 33-51-04.SDR CALA2025062605913Floor Support · corrodedAFT WET AREA R/H SIDE INNER CHORD BETWEEN STA 947 TO STA 987 HAS SEVERAL SPOTS CORRORED. REMOVED AND REPLACED R2 DOOR INNER CHORD IN REF B 737-800 SRM 51-40-02-0G-0 AND DWG# 147A8501.SDR CALA2025062605912Floor Support · corrodedFWD WET AREA R/H SIDE INNER CHORD HAS CORROSION FROM STA 312 TO STA 344. REMOVED AND REPLACED INNER CHORD AT FWD WET AREA R/H SIDE REF. SRM 51-40-02-0G-0 & DWG # 141A8310.SDR CALA2025062605911Bulb · burned outMAIN CABIN R3 DOOR EMERGENCY EXIT SIGN HAS ONE BULB OUT. REPLACED THE LAMP L50 IAW AMM 33-51-01-962-001-002. OPS CHECK GOOD FOR L-50 AFTER CHARGING LIGHT IAW B757 AMM 23-51-01-962-001-002.SDR CALA2025062605910Power Supply · failedEMERGENCY EXIT LIGHT BATTERY CHARGER M737 FAILS TEST. REMOVED AND REPLACED EMERGENCY LIGHT POWER SUPPLY M737 AND OPS CHECK GOOD REF B757 AMM 33-51-07.SDR CALA2025062605909Floor Support · crackedFOUND FLOOR SUPPORT INTERCOSTSL T CHORD CRACKED AT RBL 9 BETWEEN STA 380 AND 400. REMOVED AND REPLACED FLOOR SUPPORT INTERCOASTAL CHORD AT RBL 9 BETWEEN STA 380 AND STA 400.IN REF TO SRM 51-40-02.SDR CALA2025062605908Floor Support · crackedFOUND FLOOR SUPPORT INTERCOSTAL T CHORD CRACKED AT BL 0 BETWEEN STA 380 AND 400. REMOVED AND REPLACED FLOOR SUPPORT INTERCOASTAL T CHORD AT BL 0 BETWEEN STA 380 AND STA 400. IN REF TO SRM 51-40-02.SDR CALA2025062605886Slide · out of positionSLIDE PACK DOOR 2R HAS A LARGE GAP BETWEEN COVE R AND SLIDE UPDATED MAA CODE FIX USING VENDOR MAA SCREEN PLEASE CONTACT TOMC BEFORE COMMENCING ANY WORK. MAC METER INITIATED FOR WITH VENDOR ID V946316 MAC RELATED WORK ORDER 000000003141204 AND PRTR CLEMENTE, SDR CALA2025062605885Girt Bar · unknownDOOR 1R GIRT BAR HAS SOMETHING WRONG WITH IT. ITS NOT SITTING QUITE RIGHT. FA REPORTS INSPECTED DOOR 1R GIRT BAR FOR SECURITY IN REF TO AMM 03-25-66-200-801.SDR CALA2025062605884Slide · unsecureSLIDE PACK 2L LOOSE PERFORMED DOOR MOUNTED SLIDE PACK CHECK AND ADJUSTED Z FOLD ON ESCAPE SLIDE PACK IAW AMM TASK 25-66-01-400-801 STEP D).(2)E. DOOR OPEN AND CLOSES WITHOUT HURT BAR INTERFERENCESDR CALA2025062605883Cover · unsecureDOOR 2R SLIDE COVER NOT SEATED FLUSH WITH DOOR. DOOR ARMS AND IN DICATES LOCKED INSTALLED BUSTLE REF AMM SUBTASK 25-66-01-414-066. ITEM OKAYSDR CALA2025062605882Door · no discrepancyDOOR 2R PRESSURE GAUGE IS INDICATING IN THE RED ZONE. DOOR 2R SLIDE PRESSURE GAUGE WITHIN THE GREEN BAND. NON-FURTHER MAINTENANCE ACTION REQUIREDSDR CALA2025062605881Switch · faultedAFT CARGO DOOR LIGHT WILL NOT EXTINGUISH. WHEN AFT CARGO DOOR IS CLOSED AND LOCKED, DOOR LIGHT STAYS ON. NEED TO APPLY MEL 5203A. MEL 5203A REJECTED. ITEM CORRECTED CLEANED CONNECTIONS AT WIRES SWITCH. REINSTALLED SWITCH, OPS CHECK GOOD.SDR DALA2025062504773Cooling Fan · contaminatedSHIP 3251, DIRTY SOCK ODOR IN FLIGHT DECK. FOUND APU COOLING FAN WET WITH OIL. T/S PER A320 TSM 49 -00. NO EXTERNAL LEAKS. VERIFIED APU COOLING FAN NOT LEAKING. APU INTAKE PLENUM DIRTY, SUSPECT INTERNAL LEAK. C/W AMDS W/C 4916-2001 AND R/REINSTALL APU ACCESSSDR COEA2025062503876Switch · stuckFLIGHT 8675 ENROUTE PDX-LMT, DURING FLIGHT, THE PILOT EXPERIENCED A STUCK MIC AND LOST RADIO COMMUNICATION. SHOWS TX ON BOTH GNS530 AND GNS430. THE PILOT FOLLOWED LOST COMM PROCEDURES AND LANDED SAFELY AT LMT. ATC DECLARED AN EMERGENCY AND EMERGENCY SERVICESDR SWI2025F00767Warning Message · activatedIN SLN, GOT ANTI-ICE DUCT WARNING, RAN QRH. DIVERTED TO SLN TO AVOID CLOUDS (FLIGHT 5824 - FILED OPEN)THIS IS CURRENTLY A WORK IN PROGRESSSDR SWI2025F00766Landing Gear · warning messageGEAR DISAGREE WARNING ON DEPARTURE AT GEAR RETRACTION INITIATION. BOTH MAINS CAME UP, NOSE WHEEL DID NOT BY THE LOOKS OF IT. ALL GEAR CAME DOWN AT COMPLETION OF QRH. (FLIGHT 5836 - FILED CLOSED)THIS DISCREPANCY WAS TRANSFERRED TO CAMP ITEM 30376022 WITH THE FSDR SWIA202506250004Unknown · odorPLANE HAS STRANGE ODOR. ON DEPARTURE FAS CALLED TO REPORT ODOR WAS INTENSIFYING AND A BROWNISH GRAY HAZE WAS IN THE CABIN. LEVELED OFF AT 5000 CALLED BACK THEY SAID IT WAS STARTING TO GO AWAY. AS WE CLIMBED IT BEGAN TO CLEAR. THE ODOR WAS ALWAYS PRESENT DURINGSDR HALA20250625198Clamp · disconnectedETOPS - AIR- L- WING LEAK. FOUND CLAMP DISCONECTED FROM TRIM AIR PRESSURE REGULATING VALVE. INSTALLED NEW SEAL PER AMM 21-63-52. INSTALLED CLAMP PER M105 #R0483. OPS CHECK GOOD. LEAK CHECK GOOD. NO DEFECTS NOTED. OK FOR SERVICE.SDR HALA20250625196A/C Pack · faultedETOPS, AIR-PACK 2 REGUL FAULT. PERFORMED VISUAL INSP OF PREVIOUSLY INSTALLED #2 PACK TEMP CONTROL. FOUND OZONE CONVERTOR AIR LEAK. REMOVED AND REPLACED OZONE CONVERTOR SEAL BOTH LEFT AND RIGHT SIDE PER AMM 21-51-53. OPS CHECKED NO DEFECTS NOTED.SDR DALA2025062504771Web · damagedSHIP 3135, MISDRILL ON VERTICAL WEB BTW FR57 TO FR58 AT LEVEL OF STR 41R AFT. REPLACED VERTICAL WEB AND FASTENERS LOC BTW FR 57 TO FR58 AT LEVEL OF STR 41R AFT CARGO COMPARTMENT AS PER A319 SRM 51-72-11 AND A319 SRM 51-42-11. (1043544)SDR DALA2025062504769Bushing · wornSHIP 3169, WEAR BONDED BUSHINGS ON UPPER AND LOWER CONNECTION LINK AND SUPPORT ARM OF PASSENGER CREW DOOR 831. REPLACED BUSHES ON UPPER AND LOWER CONNECTION LINK AND SUPPORT ARM OF PASSENGER CREW DOOR 831 AS PER A320 FAM AMM 52-11-21-400- 001-A AS PER A320 SDR DALA2025062504768Frame · corrodedSHIP 3130, CORROSION WEB FRAME LOCATED BTW FR 69 TO FR 70 STR 23L IN AFT GALLEY AREA. REPLACED WEB FRAME LOCATED BTW FR 69 TO FR 70 STR 23L IN AFT AFT GALLEY AREA AS PER A319 SRM 51-42-11 A319 SRM 51-72-11.SDR DALA2025062504767Floor Support · corrodedSHIP 3130, CORROSION FLOOR SUPPORT -Y254 LOCATED BETWEEN FR18 TO FR20 FWD GALLEY AREA. REPLACED FLOOR SUPPORT -Y254 LOCATED BTW FR12 TO FR24 AT FWD GALLEY AREA AS PER A319 SRM 51-42-11 AND A319 SRM 51-72-11.SDR VNAA20250625007Transcowl · temp repairEA 54-2025-0682 (140FH PERM REPAIR - SPEED TAPE APPLIED - RH ENGINE TRANS COWL ACCES PANEL FWD LATCH OPENS IN FLIGHT) WITHIN 140 FLIGHT HOURS AFTER SECTION I, ACCOMPLISH A PERMANENT REPAIR AT DISCREPANT AREA IN ACCORDANCE WITH APPROVED PROCEDURES OR REPLACE PASDR VNAA20250625006Pulley Bracket · chafedHN00246730 DISCREPANCY: FOUND RH SIDE FS280 AILERON PULLEY BRACKET TO BE CHAFED AND REQUIRE REPLACEMENT. CORRECTIVE ACTION: LOCATED AND DRILLED NEW BRACKET P/N CC670-94802-7-01, AND TRANSFERRED BRACKET FROM OLD PULLEY IAW CRJ-700-SRM-51-40-11-001-001-A01 AND 5SDR AALA202506258489Girt Bar · frayedAIRCRAFT IN BASE MAINTENANCE: R1 DOOR SLIDE GIRT IS FRAYED AND WORN. REPLACED R1 DOOR SLIDE. PER 08L22125001.SDR AALA202506250262Door · bindingAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY-D DOOR IS DIFFICULT TO OPEN AND CLOSE. VERIFIED LAVATORY-D DOOR DIFFICULT TO OPEN, MISSING HOUSING AT TOP OF DOOR. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202506257165Unknown · odorAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: A STRONG ODOR IN THE BACK OF THE PLANE THAT CAUSED PASSENGERS AND FLIGHT ATTENDANTS TO BECOME SICK. AIRCRAFT AIR INTERRUPTED, BACK TO AND LANDED SAFELY AT MDE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OSDR VNAA2050625005Bulkhead Web · corrodedFOUND CORROSION ON FS 280 R/H LOWER WEB. UPON FURTHER INVESTIGATION FOUND CORROSION ON FS 280 R/H LOWER WEB FOUND TO BE OUT OF LIMITS IAW CRJ 700 SRM 53-11-10-201-003-A01. FABRICATED, LOCATED AND DRILLED FS 280 RH LOWER WEB AND BUTTSTRAP FROM MATERIAL 7075-T6SDR VNAA20250625004Bulkhead Web · corrodedFOUND CORROSION ON FS 280 L/H LOWER WEB. UPON FURTHER INVESTIGATION FOUND CORROSION ON FS 280 L/H LOWER WEB FOUND TO BE OUT OF LIMITS IAW CRJ 700 SRM 53-11-10-201-003-A01. FABRICATED, LOCATED AND DRILLED FS 280 LH LOWER WEB AND BUTTSTRAP FROM MATERIAL 7075-TSDR VNAA20250625003Floorbeam · corrodedFOUND CORROSION ON FS 280 "J" ANGLE. UPON FURTHER INVESTIGATION ON FS 280 "J" ANGLE FOUND TO BE OUT OF LIMITS IAW CRJ 700 SRM 53-00-00-101-001-A01. LOCATED AND DRILLED NEW J ANGLE P/N CC670-34095-1SB IAW CRJ-700-SRM-51-40-11-001-001-A01. INSTALLED FS 280 NEWSDR VNAA20250625002Floorbeam · corrodedFOUND CORROSION ON FS 280 R/H CROSS BEAM. UPON REMOVAL OF R/H CROSS BEAM FOUND R/H CORROSION CAP ANGLE DAMAGE REQUIRES REPLACEMENT. LOCATED, DRILLED AND INSTALLED NEW SERVICEABLE RH CORROSION CAP ANGLE P/N CC670-34096-2 IAW CRJ 700 SRM 51-42-06-001-001- A01.SDR VNAA20250625001Floorbeam · corrodedFOUND CORROSION @ L/H F.S.280 BEAM. INSTALLED NEW FS 280 LH CROSSBEAM P/N CC670-34094-2 AND INSTALLED NEW LH CORROSION CAP ANGLE PN CC670-34096-1 IAW CRJ 700 SRM 51-42-06-001-001-A01, 51-42-13-001-001-A01, 51-42-21-001-001-A01 & 51-42-22-001-001-A01.SDR FDEA202506241040Floorboard · damagedNR# 0296: MAIN CARGO COMPARTMENT, FLOOR PANEL 241WFF HAS DAMAGE FABRICATED NEW FLOOR PANEL 241WFF, MPN:145T5876-51, RBL 11- LBL 11, STATION 984.95 - 1114.82 IN REF TO BOEING DWG 145T5876-51. SEE JPF FOR ALL THE WORK PERFORMED. THIS IS A MAJOR REPAIR. INSSDR IPXA2025062497147Door · inoperativeL1 DOOR WILL NOT OPERATE ELECTRICALLY DEFERRED PER MEL 52-10-3-1-2-1-2SDR AALA202506254917Pressure Blkhd · canningAIRCRAFT IN BASE MAINTENANCE: AFT PRESSURE BULKHEAD OIL CAN DAMAGE AT BS 1016, BETWEEN S1L AND S2L. REPAIRED BULKHEAD PER SB-737-53-007051.SDR AALA202506259387Pressure Blkhd · damagedAIRCRAFT IN BASE MAINTENANCE: AFT PRESSURE BULKHEAD OIL CAN DAMAGE AT BS 1016, BETWEEN S11R AND S12R. REPAIRED BULKHEAD PER SB-737-53-007051.SDR OEJA2025062500915Landing Gear · faultedAFTER TAKE OFF SELECTED GEAR HANDLE UP BOTH THE NOSE AND RIGHT MAINSHOWED UP BUT THE LEFT MAIN DID NOT, LEFT GGEAR SHOWED AMBER LIGHT FOLLOW BY RED INDICATING NOT UP AND LOCKED .CYCLED GEAR TWICE DID NOT CORRECT LOWERD GEAR RETURNED TO AIRPORT WITH A SAFE LANSDR AALA202506259513Spring · stickingAIRCRAFT WAS GROUNDED: DOOR 4R SLIDE ARM LEVER DOES NOT STAY IN FLUSH/ARMED POSITION INFLIGHT. MAINTENANCE CLEANED AND LUBED R4 ARMING HANDLE, (AALA202506251100) GIRT BAR FITTINGS (AALA202506256261) AND SPRINGS (AALA202506259513) PER AMM 12-22-52. A SATISFACTOSDR AALA202506256261Fitting · stickingAIRCRAFT WAS GROUNDED: DOOR 4R SLIDE ARM LEVER DOES NOT STAY IN FLUSH/ARMED POSITION INFLIGHT. MAINTENANCE CLEANED AND LUBED R4 ARMING HANDLE, (AALA202506251100) GIRT BAR FITTINGS (AALA202506256261) AND SPRINGS (AALA202506259513) PER AMM 12-22-52. A SATISFACTOSDR AALA202506254247Unknown · odorAIRCRAFT WAS GROUNDED: THE AIRCRAFT DIVERTED TO MCO DUE TO THE FLIGHT CREW REPORTING THAT DURING PUSH BACK FLIGHT ATTENDANT REPORTED ODD SMELL IN THE AFT CABIN, BUT FELT OK. ALL OTHER FLIGHT ATTENDANTS WERE OK AS WELL. NO UNUSUAL SMELL IN THE FLIGHT DECK. DUR