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 AALA202510299668Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202510292558Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: CHECK DOOR PRESSURE LIGHT ON CIDS PANEL SCREEN STAYS ON AFTER THE R1 DOOR IS ARMED. MAINTENANCE SERVICED THE R1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202510291451Elec Connector · unsecureAIRCRAFT WAS NOT GROUNDED: SEAT MOUNTED EMERGENCY LIGHT AT SEAT 8C INOPERATIVE. RESECURED SEAT MOUNTED EMERGENCY LIGHT CONNECTOR ON SEAT 8C AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER CMM 25-21-61.SDR AALA202510290286Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202510297851Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202510298111Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202510292579Gust Lock · out of adjustAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS 4L DOOR GUST LOCK INOPERATIVE. MAINTENANCE ADJUSTED AND LUBRICATED THE L4 DOOR GUST LOCK ASSEMBLY PER AMM 52-13-01. A SATISFACTORY OPERATIONAL CHECK WAS ACCOMPLISHED WITH NO ISSUES NOTED.SDR AALA202510290384Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202510291253Sign · dislodgedAIRCRAFT WAS NOT GROUNDED: CEILING EMERGENCY EXIT SIGN AT EMERGENCY EXIT ROW, FELL DOWN DURING TAKEOFF AND IS HANGING BY THE WIRE. TIGHTENED AND SECURED EMERGENCY EXIT LIGHT ASSEMBLY AT CEILING PANEL ROW 17ABC. OPERTIONAL CHECK GOOD. PER AMM 33-51-01.SDR AALA202510294147Heat Shrink · missingAIRCRAFT WAS GROUNDED: DUE TO SLIDE REPLACEMENT AT R1 DOOR, GIRT BAR REQUIRES RED HEATSHRINK TUBING. REPLACED GIRT BAR HEAT SHRINK. PER AARD 25-66-00SDR AALA202510292218Slide · unwanted deployAIRCRAFT WAS GROUNDED: FORWARD SERVICE DOOR EVACUATION SLIDE PARTIALLY DEPLOYED FROM HOUSING. REMOVED AND REPLACED R1 DOOR SLIDE. PER WORK CARD 08L22125001.SDR AALA202510291620Guide Arm · out of adjustAIRCRAFT WAS GROUNDED: L1 DOOR HARD TO OPEN. ADJUSTED THE GUIDE ARM BUT NO HELP. DOOR STILL HARD TO OPEN AND CLOSE. REMOVE AND REPLACED MAIN ENTRY DOOR GUIDE ARM. PER AMM 52-11-21.SDR SIMA202510297002Flashlight Assy · inoperativeAFT FA EMERGRENCY FLASHLIGHT INOPERATIVE . R & R AFT FA FLASHLIGHT ASSEMBLY IAW ERJ 175 AMM 33-51-01. NO DEFECTS NOTED. MEL RESTOREDSDR CALA2025102910710Rib · crackedCRACK INDICATIONS FOUND ON RT HORIZ STAB HSS 129.50 IN LWR SKIN RIB, (SECOND LAYER). REMOVED FWD SPAR WEB TO GAIN ACCESS IAW SRM 51-40-02. REMOVED & CUT CRACKED AREAS IAW SRM 55-10-09-2R-5 REPAIR 5. NDT VERIFIED NO CRACKS. FABRICATED TWO FILLERS AND TWO ANGLESDR CALA2025102910708Stringer · corrodedAFT CARGO BAY VACUUM WASTE COMPARTMENT BS 867, STRINGER 24L HAD CORROSION. REMOVED AND REPLACED AFT CARGO BAY VACUUM WASTE COMPARTMENT STRINGER FROM BS 867 - 887 IAW SRM 51-40-02-0G-0 AND DWG 146A3230.SDR CALA2025102910706Frame · corrodedAFT CARGO LOWER FRAME CORRODED STA 1460 S30 TO S29R.SDR CALA2025102910704Deck Plate · corrodedAFT DECK PLATE HAS SEVERAL CORROSION SPOTS BETWEEN STA 1680 AND STA 1700 ROM BL 0 TO ABOUT 52". OUT OF LIMITS.SDR CALA2025102910679Light Sys · malfunctionedEMERGENCY EXIT LIGHTS ILLUMINATED NEAR ROW 45 DURING TURBULENCE, EMERGENCY EXIT LIGHTS NEAR ROW 45 NOT ILLUMINATED UPON MAINTENANCE ARRIVAL. OPERATED EMERGENCY LIGHTS, LIGHTS TURN ON AND OFF. REF AMM DMC-B787-A-33-51-00-00C-320A-A,SDR CALA2025102910677Filter · cloggedFUMES REPORTED IN AFT GALLEY, ACFT DIVERTED TO RIC. LOCAL FBO TO FOLLOW AMM 05-51-10-200-801-C-1. REMOVED AND REPLACED CABIN RECIRCULATION FILTERS IAW MM 21-21-00, NO ABNORMAL FINDINGS, OK.SDR HALA20251028332Oil Cooler · leakingETOPS - DURING APU OIL LEAKAGE INSPECTION, FOUND EXCESSIVE OIL IN OIL COOLER & OUTLET DUCT. FOUND EXCESSIVE OIL DRIPPING FROM APU FUEL CONTROL UNIT. REMOVED AND REPLACED APU OIL COOLER PER AMM 49-91-44. REMOVED AND REPLACED APU FUEL CONTROL UNIT PER AMM 49-32SDR HALA20251028331Generator · faultedETOPS - APU GENERATOR FAULTING. REMOVED AND REPLACED GAPCU OPS CHECK PENDING AC 024678 IAW 24-41-34/401. FAULT CONTINUED. REPLACED APU GENERATOR PER AMM 24-23-51. OPS CHECK GOOD. A/C OK FOR SVC.SDR HALA20251028330Coffeemaker · shortedATB, STRONG AND PRESISTENT ELEC BURNING ODOR IN FWD GALLEY. GALLEY MASTER COMMERCIAL AND GALLEY & CABIN SECURED PER QRH PROC WITH NO IMPROVEMENT. NO VISIBLE SMOKE. INSPECTED FWD GALLEY AND FOUND COFFEE MAKER POSITIONED IN F111 SHORTED. REMVOED AND REPLACED COFSDR ASAA2025102761905Lamp · inoperativeDURING T/C 78233008 EMERGENCY LIGHT TEST, FOUND RT AFT SIDEWING EXT EMER LT INOPERATIVE. GROUNDED - YES. RELAMPED RT AFT SLIDE/OVERWING LIGHT. OPS CK GOOD, REF AMM 33-51-04-960-801.SDR SWAA2025102829340Transmitter · faultedTRAILING EDGE FLAP SPLIT ON LANDING CONFIGURATION. REMOVED LT FLAP POSITION TRANSMITTER IAW AMM 27-58-01. REMOVED AND REPLACED THE NR 3 FLAP TRANSMISSION INBD COUPLING SLEEVE & HALF IAW AMM 27-51-31, & LT POSITION TRANSMITTER IAW AMM 27-58-01. OP CHECK GOOD.SDR SWAA2025102829372Sleeve · damagedTRAILING EDGE FLAP SPLIT ON LANDING CONFIGURATION. REMOVED AND REPLACED THE NR 3 FLAP TRANSMISSION INBD COUPLING SLEEVE & HALF IAW AMM 27-51-31 & LT POSITION TRANSMITTER IAW AMM 27-58-01. OP CHECKED GOOD.SDR SWAA2025102829065Engine · faultedAFTER START OF NR 2 ENG; SOURCE OFF LIGHT ILLUMINATED AND FUEL FLOW WENT TO ZERO, HAD WHITE FLASHING BOX AROUND EGT, AND SHUT NR 2 ENG DOWN. C/W EEC BITE IAW FIM 73-00 TASK 801. NO FAULTS FOUND FOR NR 2 ENG. C/W ENG IDLE RUN WITH CREW IAW AMM 71-00-00 RAN ENSDR DALA2025102807906Seal · leakingAIRCRAFT 5035, FA'S REPORTED DIRTY SOCK SMELL LAST 15 MINUTES OF FLIGHT DURING DESCENT & LANDING. TRANSITIONED TO AN EXHAUST/BURNING FUEL SMELL. FOUND OIL ON ENG NR 2 SPINNER REMOVED ENG NR 2 INLET CONE PER A321 AMM 72-11 AND REPLACED SHAFT COVER SEAL PER A3SDR YENA2025102801072Door Frame · crackedDURING HEAVY MAINTENANCE: CRACK INDICATION ON FRAME 68 LH SIDE IN OPEN FASTENER HOLE UPPER INBO ARD AT DOOR STOP FITTING 6 POSITION, CRACK DIRECTION IS 3 OCLOCK, CRACK DEPTH IS 0.095 INCH, AT AFT GALLEY AREA (1 EA); EVALUATED DIAMETER HOLES D1 TO D4 AND FOUNDSDR YENA2025102801071Door Frame · crackedDURING HEAVY MAINTENANCE: CRACK INDICATION FOUND ON FRAME SEGMENTS 1 AT DOOR / EMERGENCY EXIT / OVERWING EMERGENCY EXIT HATCH (AFT RH SIDE ZONE 844) CRACK LENGTH= 0.2 55 INCHES; REMOVED AND REPLACED FRAME SEGMENTS ON EMERGENCY EXIT DOOR DOOR 844 FOLLOWING INSTSDR YENA2025102801070Door Frame · crackedDURING HEAVY MAINTENANCE: CRACK INDICATION FOUND ON FRAME SEGMENTS 1 AT DOOR / EMERGENCY EXIT / OVERWING EMERGENCY EXIT HATCH (AFT RH SIDE ZONE 843) CRACK LENGTH= 0.2 95 INCHES; REF AEROMAN WO# 2025-262/1 NR# 2025-608615 REMOVED AND REPLACED FRAME SEGMENTS ON SDR YENA2025102801069Door Frame · crackedDURING HEAVY MAINTENANCE: CRACK INDICATION FOUND ON FRAME SEGMENTS 1 AT DOOR / EMERGENCY EXIT / OVERWING EMERGENCY EXIT HATCH (AFT LH SIDE ZONE 834) CRACK LENGTH= 0.2 75 INCHES; REF AEROMAN WO@ 2025-262/1 NR# 2025-608616 REMOVED AND REPLACED FRAME SEGMENTS ON SDR YENA2025102801068Door Frame · crackedDURING HEAVY MAINTENANCE: CRACK INDICATION FOUND ON FRAME SEGMENTS 1 AT DOOR / EMERGENCY EXIT / OVERWING EMERGENCY EXIT HATCH (AFT LH SIDE ZONE 833) CRACK LENGTH= 0.3 05 INCHES; REF AEROMAN WO 2025-262/1 NR# 2025-608617 REMOVED AND REPLACED FRAME SEGMENTS ON ESDR YENA2025102801067Hinge Arm · wornDURING HEAVY MAINTENANCE: WEAR ON HINGE ARM FORK END FITTING # 6 ON VERTICAL STABILIZER (1EA); REF AEROMAN WO# 2025-262/1 NR# 2025-608758 REMOVED AND REPLACED HINGE ARM FORK END FITTING #6 ON VERTICAL STABILIZER I.A.W. A320 SRM 51-42-11 AND I.A.W A320 SRM 55-3SDR YENA2025102801066Door Frame · crackedDURING HEAVY MAINTENANCE: CRACK INDICATION ON FRAME 68 RH SIDE IN OPEN FASTENER HOLE LOWER INBOA RD AT DOOR STOP FITTING 1 POSITION, CRACK DIRECTION IS 6 OCLOCK, CRACK DEPTH IS 0.115 INCH, AT AFT GALLEY AREA (1 EA); REF AEROMAN WO# 2025-262/1 NR2025-608762 PERSDR IXXA20251027066Cooling Fan · inoperativeDURING PRE-FLIGHT NOTICABLE SMELL OF BURNT WIRE IN THE FIGHT DECK. PLACED ON DEFERRAL 67357 MINIMUM EQUIPMENT LIST 21-58-03-01 CATEGORY C. DUE 06 NOVEMBER 2025. FLIGHT CREW DEBRIEFED AND FOUND THAT FORWARD EQUIPMENT SUPPLY FAN 1 EICAS MESSAGE AND EQUIPMENT COOSDR DALA2025102807902Oxygen Mask · unwanted deploySHIP 3301 1R LAV THE OXYGEN MASK ARE DEPLOYED. CORRECTIVE ACTION: RE-PACKED MASKS PER A330 AMM 35-21. OK FOR SERVICE. (1274858)SDR DALA2025102807901Stringer · damagedSHIP 3413 TOOLING DAMAGE ON STRINGER FORWARD SIDE OF FRAME 60 AT P'2. CORRECTIVE ACTION: REPAIRED PER ERA 628200-14. (1274958)SDR YENA2025102801065Unknown · odorFLT#887, JFK-SXM. "INFLIGHT REPORTS DIRTY SOCK SMELL ON FINAL APPROACH. ACCOMPLISHED INFORMATION NOTICE 2017-T015L SECTION B2.IDENTIFIED ODOR LEVEL 2 COMING FROM APU. DECONTAMINATION LEVEL B WAS ACCOMPLISHED PER TSM 05-50-00-810-831-A. AIRCRAFT IS OK FOR SVC.SDR AALA202510288319Eiu · faultedAIRCRAFT WAS GROUNDED: NUMBER 2 ENGINE SHOWED LOW PSI OCCASIONALLY DROPPING TO 0. AS PE,R CHECKLIST ALL OTHER INDICATIONS WERE NORMAL. DECESION MADE TO DIVERT TO ORD, NO EMERGENCY DECLARED AND LANDED WITHOUT INCIDENT. MAINTENANCE REPLACED EIU 2 IAW AMM 73-25-3SDR AALA202510280848Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: 2L DOOR BOTTLE NEEDS SERVICING. MAINTENANCE SERVICED 2L DOOR IAW AMM 52-13-00.SDR AALA202510289677Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: 2R DOOR BOTTLE NEEDS SERVICING. MAINTENANCE SERVICED 2R DOOR IAW AMM 52-13-00.SDR VNAA2025102811102Window · crackedCAPT SIDE WINDOW CRACKED AT FL340. DECLARED EMERGENCY. / REMOVED AND REPLACED THE LH SIDE WINDOW IAW CRJ900 AMM 56-12-01-000/400-801-A01-PSA. LEAK CHECK GOOD. PERFORMED OPS CHECK OF TEMPERATURE CONTROLLER IAW CRJ900 AMM 30-41-06-710-801-A01, OPS CHECK GOOD.SDR EVCA20251028001Fitting · installedUPPER L/H TAILBOOM ATTACHMENT FITTING CRACKEDSDR FDEA202510272100Floor Panel · dentedDENT ON FLOOR PANEL (252 JFF)ON MAIN DECK CARGO COMPARTMENT. FLOOR PANEL (252JFF) ON MAIN DECK CARGO COMPARTMENT WAS REPAIRED IAW B767 SRM 53- 00-50-2R PAR 4-B FIG.201 SHEET 2 REV 93 AUG, 15,2025.SDR FDEA202510272099Floor Panel · puncturedPUNCTURE ON FLOOR PANEL (252HFF) ON MAIN DECK CARGO COMPARTMENT FLOOR PANEL (252 HFF) ON MAIN DECK CARGO COMPARTMENT WAS REPAIRED IAW B767 SRM 53- 00-50-2R PAR4-B FIG 201 SHEET 2 REV 93. AUG 15,2025SDR FDEA202510272098Floor Panel · puncturedPUNCTURE ON FLOOR PANEL (251 SFF) ON MAIN DECK CARGO COMPARTMENT FLOOR PANEL (251 SFF) ON MAIN DECK CARGO COMPARTMENT WAS REPAIRED IAW B767 SRM 53- 00-50-2R PAR 4-B FIG 201 SHEET 2 REV.93 AUG 15,2025.SDR FDEA202510272097Floor Panel · puncturedPUNCTURE ON FLOOR PANEL (251QFF) ON MAIN DECK CARGO COMPARTMENT FLOOR PANEL (251 QFF) ON MAIN DECK CARGO COMPARTMENT WAS REPAIRED IAW B767 SRM 53- 00-50-2R PAR 4-B FIG.201 SHEET 2 REV.93 AUG 15,2025.SDR FDEA202510272096Floor Panel · puncturedPUNCTURE ON FLOOR PANEL (252SFF) ON MAIN DECK CARGO COMPARTMENT. FLOOR PANEL (252SFF) ON MAIN DECK CARGO COMPARTMENT WAS REPAIRED IAW B767 SRM 53- 00-50-2R PAR 4-B FIG 201 SHEET 2 REV 93 AUG 15,2025.SDR SCNA20251028414Girt Bar · abnormalFORWARD ENTRY DOOR ESCAPE SLIDE GIRT IS NOT CORRECTLY TUCKED IN WITH HOOK AND LOOP TO PAN. OPEN.SDR CALA2025102810666Landing Gear · faultedLNDG GEAR DID NOT RETRACT AFTER T/O RAN QRH PROCEDURE SUCCESSFUL LY DEBRIFED CREW, PER CREW THEY FOLLOW QRH FOR GEAR FAILS TO RETRACT 2.140.10 AND FOLLOW HYPERLINK STEPS TO CYCLING LANDING ALTERNATE EXTENSION DOOR ON THE FLOOR THEN CYCLED LANDING GEAR LEVER DO