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 SWAA2025102726516Flashlight · inoperativeF/A REPORTS FWD INBD EMERGENCY FLASHLIGHT. R&R FWD I/B EMERGENCY FLASHLIGHT PER AMM 25-64-00 OPT CHECKED GOOD.SDR AALA202510277230Engine · stalledAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO PHX DURE TO THE FLIGHT CREW REPORTING THAT AFTER TAKEOFF, AND APPROXIMATELY 1 MINUTE AFTER THRUST REDUCTION TO CLIMB POWER, LOUD BANG WAS HEARD AND ENGINE 2 STALL APPEARED ON ECAM. SSDR DALA2025102707842Transition Panel · corroded(LOG 1264388) FWD CARGO COMPARTMENT - L/H TRANSITION PANEL BRACKET - HAS CORROSION, MULTIPLE LOCATIONS. FWD CARGO L/H TRANSITION ANGLE WAS OUT OF LIMITS FROM STA 500F TI STA 500J FABRICATED ANGLE IAW B737-900 SRM 53-00-53-2R.SDR DALA2025102707841Transition Panel · corroded(LOG 1264381) R/H TRANSITION PANEL BRACKET - HAS CORROSION, MULTIPLE LOCATIONS. REMOVED AND REPLACED R/H TRANSITION PANEL IAW B737-900 SRM 51-40-02-0G.SDR DALA2025102707840Floorbeam · corroded(LOG 1262803) STA 947 FLOOR BEAM HAS CORROSION UNDER LAV FITTINGS AT LBL24 AND LBL 48. REPAIRED FLOOR BEAM STA 947 AT LBL24 AND LBL48 AS PER REF B737-900 SRM 53-70-51-2R.SDR CALA2025102710558Fitting · crackedSHEAR FITTING AT STATION 540 AND RBL 15.04 IS CRACKED. REMOVED AND REPLACED SHEAR FITTING AT STATION 540 AND RBL 15.04 IAW B737-800 SRM 51-40-02 AND BAC DWG 111A2000 REV ORIGINALSDR DALA2025102707827Landing Gear · malfunctionedLANDING GEAR RETRACTION SYSTEM. ON APPROACH AT LANDING, GEAR DOWN , NOTHING HAPPEN, AFTER GEAR HANDLE CYCLED LANDING GEAR CAME DOWN AND LOCKED & ALL INDICATIONS NORMAL, DOWN & LOCKED. C/A: MLG & NLG IN DOWN LOCK POSITION PER MEL 32-31-02, VMO TO LG DOWN , NLG SDR DALA2025102407820Pin · bindingUNABLE TO INSERT DISARM PIN IN THE LH OWEED ESCAPE SLIDE. SEE NR FOR ADDITIONAL INFORMATION 001-0400:2561-9101/001 00142 REMOVAL STOCK NUMBER:81-2563-9-0007 SERIAL NUMBER:28136. (LP# 1264495)SDR SWAA2025102426066Flashlight · inoperative2 AFT AIRCRAFT LH FLASHLIGHTS INOPERATIVE. FOUND BATTERIES ON 2 AFT LEFT FLASH LIGHTS TO BE DISCONNECTED RECONNECTED AND PERFORMED OPS CHECK REF 25-64-00 CHECK GOOD THIS CLEARS MEL.SDR SWAA2025102426405Flashlight · inoperativeFWD F/A EMERGENCY FLASHLIGHT INOPERATIVE. R & R FWD EMERGENCY FLASHLIGHT ASSY REF AMM25-64-00.SDR SWAA2025102426359Megaphone · inoperativeAFT MEGAPHONE BATTERIES REQ RELACEMENT. REPLACED BATTERIES IN AFT MEGAPHONE PER AMM 25-64-00. OPS CHECK GOOD.SDR DALA2025102407796Engine · failedDIVERTED TO KEF DUE TO LEFT ENGINE FAILURE. MAINTENANCE FOUND METAL IN TAIL PIPE. LEFT ENGINE REPLACEMENT IN WORK.(A010420)SDR DALA2025102407792Doubler · not reportedEXISTING REPAIRS FOUND THAT IMPACTS INSPECTION ACCOMPLISHMENT. REPAIR INVESTIGATION REQUIRED PRIOR TO FURTHER FLIGHT. PERFORMED DOUBLER INSPECTION PER ERA 625837-14 AD (7976471)SDR DALA2025102407797Warning Message · false activationATO- DURING TAKEOFF ROLL THE CREW REPORTED A STAB OUT OF TRIM AURAL WARNING AND ABORTED TAKEOFF. MAINTENANCE PERFORMED STABILIZER SYSTEM TESTS AND RETURNED TO SERVICE.(7843690)SDR DALA2025102407790Spar Cap · noneRH WING / REAR SPAR / LOWER CAP / AFT FLANGE / XRS = 164 / CRITICAL HOLE INSPECTION. PRI 629860-14AD REQUIRES ACCOMPLISHMENT WHILE IN BHM. ACCOMPLISH PRI 629860-14AD WHILE IN BHM OCT-2025 MAINTENANCE VISIT. (1263856)SDR QXEA2025102400328Antenna · malfunctionedFLIGHT 2106. AFTER TAKEOFF AT ABOUT 400 AGL RECIEVED GND PROX WARNING. WHEN SELECTING FLAPS 0, LANDING GEAR AURAL WARNING ACTIVATED AND COULD NOT BE CANCELED. PERFORMED QRH NAP 38 CHECKLIST. RAD1 CB WAS PULLED OUT ON MCDU. AURAL WARNING CEASED AFTER CB ACTIONSDR AALA202510249633Fitting · noneAIRCRAFT IN BASE MAINTENANCE: DUE TO THE MAJOR REPAIR BEING ACCOMPLISHED ON THE FLIGHT DECK CENTER WINDSHIELD FRAMING THE LEFT CONTINUITY FITTING BETWEEN AT FR 2 AND Y0 MUST BE REPLACED PER INSTRUCTIONS OUTLINED IN EO 5319Y017-002. REPLACED CONTINUITY FITTING SDR CALA2025102410499Valve · faultedLEFT BLEED TRIP OFF LIGHT ILLUMINATED REPEAT WRITE UP. NR 1 ENG HIGH STAGE REGULATOR (HSR) FAIL HEALTH CHECK TEST REGULATOR, REMOVED N REPLACED HI STAGE REGULATOR REF AMM 36-11-07 OPS CHECKS GOOD. PERFORMED HEALTH CHECK FOR 1 ENG, FOUND BLEED AIR REGULATOSDR CALA2025102410495Fitting · crackedSHEAR FITTING AT STATION 540 AND RBL 32.40 IS CRACKED. REMOVED AND REPLACED SHEAR FITTING AT STATION 540 AND RBL 32.40 IAW B737-800 SRM 51-40-02 AND BAC DWG 111A2000 REV ORIGINALSDR CALA2025102410494Fitting · crackedSHEAR FITTING AT BS 540 AND LBL 32.40 IS CRACKED. REMOVED AND REPLACED SHEAR FITTING AT BS 540 AND LBL 32.40 IAW B737-800 SRM 51-40-02 AND BAC DWG 111A2000 REV ORIGINAL FOR WORK ACCOMPLISHED SEE NSA EMX N/R 00080 AND HANGER N/R 6482033.SDR DXTA2025102405390Pump · defectiveRIGHT HYD RESERVOIR DUMPED ALL FLUID TO 0% AT FL430. CYAN FLAPS RATE LOW AND R HYD ENG PUMP FAIL ILLUMINATED. AMBER R HYD LOW AND SPILER FAULT ILLUMINATED WHEN FLAPS EXTENDED VIA ALTN FLAPS. POST FLIGHT SHOWED HYD FLUID DRIPPING FROM BOTH R ENGINE LOWER WEEP HSDR VNAA2025102411102Sensor · not reportedRH IB BRAKE TEMP SENSOR INDICATED A STEADY 14 AFTER SELECTING GEAR DOWN. / REMOVED AND REPLACED RH INBOARD BRAKE TEMPERATURE SENSOR IAW CRJ 900 AMM 32-46-01-000/400-801-A01 & 32-46-01-000/400-801-A01-PSA. OPS TEST CHECKED GOOD. THIS CLEARS MEL.SDR VNAA2025102411101Light · odorELECTRICAL BURNING ODOR IN BETWEEN SEAT 3 AND 8 DF / REMOVED AND REPLACED SIDE WALL LIGHT SEAT 8AC AND 9AC IAW SWPM 20-16-00 AND AMM 33-21-07-000/400-801-A01 OPERATIONAL TEST GOOD. NO BURNING ODOR NOTICED.SDR AALA202510240190Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK ON CONNECTING FITTING ON MLG AREA LH SIDE L=0.163 INCH. MAINTENANCE ACCOMPLISHED PERMANET REPAIR INSTRUCTION (REPLACED CONNECTING PLATE) LOC BTW FR42 TO FR43 AT LEVEL OF WEB W10 AT MLG AREA ON LH SIDE IAW EA 368107, A320 SRMSDR DALA2025102307773Skin · gougedGOUGES WERE FOUND COMMON TO TH E FUSELAGE SKIN FROM FR 53 TO FR 55, STR 42R TO STR 51R COMMON T O THE 198GB AND 198HB WING TO BODY FAIRING. REPAIRED PER ERA 629866-14. (1264277)SDR GTIA2025102339146A/C Pack · contaminatedSHORTLY AFTER DEPARTURE/TAKEOFF AFT FLIGHT ATTENTDANTS REPORTED FUMES(MOLDY SMELL).TURNED PACK 2 OFF.SMELL/ODOR DISSIPATED. F/A REPORTED FAINT ODOR ON GO AROUND. DESCRIPTION OF ODOR/FUMES: TEMPORARY, DIRTY SOCKS/MUSTY DRY SMELL. APPARENT CABIN SOURCE: CABIN AISDR GTIA2025102339145Unknown · odorF/O NOTICED SMELL OF DRY SOCKS DURING TAKE OFF WE COMPLETED. "QRH ELIMINATION OF ODOR/FUMES PROCEDURE. PACK ONE WAS TURNED OFF.-REF TSM 05-50-00-810-831-A PARA 4A TYPE 2 + 3. REF TSM 71-00-00-810-801-A STEPS 1,2, 3A, + B1 SUSPECTED ENG 1 FOR ODOR. CONTINUE TO SDR AALA202510235619Handle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK ON HANDLE SLIDING WINDOW CAPTAIN SIDE IN COCKPIT. MAINTENANCE REPLACED HANDLE SLIDING WINDOW CAPTAIN SIDE IN COCKPIT. IAW AMM 56-12-12-000-002-A , AMM 56-12-12-400-003-A, CMM 56-12-12 AMM 30-42-00-710-001-A.SDR AALA202510238087Battery · no testAIRCRAFT WAS NOT GROUNDED: FORWARD FA FLASHLIGHT DOES NOT TEST PROPERLY. MAINTENANCE REPLACED BATTERY AND PLASTIC EMERGENCY USE ONLY BAND IAW AMM 25-65-00.SDR DALA2025102307760Acm · seizedSHIP 3953 -ATB/FUMES- RETURNED TO ATL DUE TO STRONG ODOR IN COCKPIT. CORRECTIVE ACTION: FOUND LEFT PACK ACM SEIZED. REPLACED SAME. OPS CHECK GOOD.SDR DALA2025102307759Sensor · inoperativeSHIP 3715 -FCNT/DE- DECLARED EMERGENCY DUE TO TE FLAP ASYMMETRY. TE FLAPS DID NOT EXTEND FROM UP POSITION. CORRECTIVE ACTION: FSEU BITE FAULT CODE 27-53255 (FLAP 6 SKEW). REPLACED SKEW SENSOR. OPS CHECK GOOD.SDR FDEA202510212061Skin · dentedDENT RH WING, LOWER SURFACE OF OUTBOARD FLAP, 36.5" OUTBOARD EDGE AND 19" TRAILING EDGE DENT RH WING, LOWER SURFACE OF OUTBOARD FLAP, 36.5'' OUTBOARD EDGE AND 19'' TRAILING EDGE WAS REPAIRED IAW B767 SRM 57-53-01-2R AND SRM 57-70-10-2R REPAIR 4 FIG 201 SHSDR YENA2025102301054A/C Pack · odorFLT#195, HPN-MCO. "APPROACHIN 3000' PACKS DELIVERED STRONG MUSTY SMELL. INFLIGHT NOTIFIED CREW THAT ODOR WAS STRONG IN REAR OF AIRCRAFT AS WELL AS FRONT; PERFORMED INSPECTION ON APU, FOUND NO LEACKS. PERFORMED APU OPS TEST & RAN BOTH PACKS. NO SMELLS NOTED. " SDR AALA202510230570Accelerometer · out of toleranceAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING CLIMB NUMBER 1 ENGINE VIBRATION BEGAN TO SPIKE INTO ABNORMAL RANGE. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT PHL. REMOVED AND REPLACED TCF BEARING ACCELEROMETER, PER AMM 77-31-06. ALSDR JJBA20251023049Battery Pack · inoperativeSEVERAL GALLEY AREA EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED EMERGENCY BPS #2. OPS CHECK GOOD.SDR JJBA20251023048Battery · inoperativeOVERWING EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED EMERGENCY BPS #4. OPS CHECK GOOD.SDR JJBA20251023050Pump · failedHYD SYS 1 FAIL, E1 HYD PUMP FAIL EICAS MESSAGES AND HYD 1 QTY 0 IN CRUISE. REMOVED AND REPLACED #1 ENGINE DRIVE HYDRAULIC PUMP. FOUND AFT DPI TO NOT BE SEATED ON MANIFOLD DUE TO BACKUP RING INSTALLED INCORRECTLY REMOVED AND REPLACED AFT DPI WITH NEW ORINGS ANDSDR AALA202510232532Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202510239809Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: ON FLIGHT ATTENDANT PANEL, MESSAGE INDICATES CHECK DOOR PRESSURE ON DOOR 4L. MAINTENANCE SERVICED THE 4L DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-13-14.SDR AALA202510234485Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L1 DOOR DOES NOT SHOW ARMED ON THE CIDS PANEL WHEN SLIDE IS ARMED. MAINTENANCE SERVICED THE L1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 25-62-44.SDR AALA202510237230Engine · stalledAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO PHX DURE TO THE FLIGHT CREW REPORTING THAT AFTER TAKEOFF, AND APPROXIMATELY 1 MINUTE AFTER THRUST REDUCTION TO CLIMB POWER, LOUD BANG WAS HEARD AND ENGINE 2 STALL APPEARED ON ECAM. SSDR AALA202510237772Battery · no testAIRCRAFT WAS NOT GROUNDED: FAULT MESSAGE DISPLAYED FOR EMERGENCY POWER SUPPLY UNIT 14WL DURING SYSTEM TEST. REPLACED BATTERY FOR EMERGENCY POWER SUPPLY UNIT 14WL AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR AALA202510232761Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R3 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202510237937Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202510233731Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202510238274Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R2 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202510239385Battery · no testAIRCRAFT WAS NOT GROUNDED: BATTERY FAULT DISPLAYED FOR EMERGENCY POWER SUPPLY UNIT 13WL DURING SYSTEM TEST. REPLACED BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR DXTA2025102305389Battery Pack · faultyTHE SEAT LIGHT ABOVE SEAT 9 DOES NOT ILLUMINATE DURING THE EMERGENCY LIGHT TEST IN EITHER THE ARMED OR ON SWITCH POSITION AND POWERED BY EMERGENCY BATTERY POWER. CORRECTIVE ACTION: REMOVED AND REPLACED #2 EMERGENCY BATTERY IAW CE680A MM 33-50-10. LIGHTS OPS CHSDR DXTA2025102305388Battery Pack · faultyTABLE LIGHT BETWEEN SEAT 3 AND 5 DOES NOT ILLUMINATE ON EMERGENCY LIGHT TEST WITH SWITCH IN THE ARM OR ON POSITION ON EMERGENCY BATTERY POWER. CORRECTIVE ACTION: REMOVED AND REPLACED #2 EMERGENCY BATTERY IAW CE680A MM 33-50-10. LIGHTS OPS CHECKS GOOD.SDR YENA2025102301052Door Frame · corrodedDURING HEAVY MAINTENANCE: INSIDE CABIN FWD WET AREA CPCP RELATED TASK- LEFT SIDE BEAM Y503.2 CORROSION FRAME 16 STR 23L; REF HAECO WO 440613 NR 44278. REMOVED SURFACE CORROSION ON FWD WET AREA L/T SIDE Y.503.2 AT STR 23L FR 16 MAT LOSS .022 MATERIAL ALLOWABLE