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 SWAA2025091915885Power Supply · inoperativeAFT RT EMERGENCY EXIT LIGHTS WONT LIGHT ABOVE ROW 25; ABOVE AFT R/H SERVICE DOOR AND EXTERNAL R/H AFT OF SERVICE DOOR. REMOVED AND REPLACED PER AMM 33-51-06-960-806-NG.SDR SWAA2025091915639Flashlight · no testFLIGHTDECK FLASHLIGHT FAILED TEST. LED DID NOT ILLUMINATE. RE-SEATED FLT DECK FLASHLIGHT PER AMM 25-64-00. OPS CHECK GOODSDR SWIA2025091900008Duct · warning messageR 10TH DUCT WARNING MSG DURING CLIMB AT 3500FT, APPLIED THE QRH MSG DISAPPEARED, RETURNED TO KORD WITH NO FURTHER ISSUE. (FLIGHT 5215 - FILED OPEN)SDR WX0A2025091932569Epsu · no test(AIRCRAFT NOT GROUNDED) FAILED EPSU SYSTEM TEST. REMOVED AND REPLACED EPSU REF WO531467"SDR IPXA2025091911559Floor Panel · dentedMAJOR REPAIR. FOUND MAIN DECK FLOOR PANEL DENTED, PANEL 252XF. REPAIRED MAIN DECK FLOOR PANEL NEAR BS 1700, BETWEEN RBL 11.33 & 33.99 IAW EGAT EI F2025A53M-2137, REV1 AND EO-95356-REQ 1, REV1. CONDITION CHECK IS SATISFACTORY.SDR WX0A2025091932568Oil System · leaking(AIRCRAFT NOT GROUNDED) DIRTY SOCK SMELL BELOW 1000' DURING LANDING THROUGHOUT CABIN AND COCKPIT. / PERFORMED A32X-21-000-001 OIL TYPE SMELL TASK CARD, FOLLOWING STEP 3.A4.A PERFORMED AMM 21-00-00-615-802A LEVEL A DECONTAMINATION USING ENG BLEED. SMELL NOT PRESDR IXXA202509198054Seal · missingPORTABLE BREATHING EQUIPMENT SEALS ARE NOT ATTACHED. REINSTALLED EXISTING SERVICEABLE PORTABLE BREATHING EQUIPMENT WITH NEW SECURITY SEAL IN ACCORDANCE WITH ATI GENERAL MAINTENANCE MANUAL 9.10.SDR DALA2025091906889Bearing · excess playLEFT WING FLAP INTERCONNECTING STRUT, FWD BEARING WITH PLAY. REPLACED LT WING FLAP INTERCONNECTING STRUT RAD END IAW AMM TASK 27-51-44-960-001-A. (1205337).SDR DALA2025091906888Bearing · excess playRIGHT WING FLAP INTERCONNECTING STRUT, FWD BEARING WITH PLAY. REPLACED R/H WING FLAP INTERCONNECTING STRUT RAD END IAWW A319 AMM TASK 27-51-44-960-001-A. (1205325).SDR DALA2025091906887Access Panel · crackedDELAMINATED ACCESS PANEL 191BB BELLY FAIRING AT LOWER FUSELAGE. COMPLIED WITH ER/A 542077-14TR. (1205793).SDR DALA2025091906886Access Panel · crackedCRACK ACCESS PANEL 322BL ON VERTICAL STABILIZER. COMPLIED WITH ER/A 628592-14. (1205816).SDR DALA2025091906885Seat Track · corrodedUPPER FUSELAGE, PAX CABIN SEAT TRACK Y1292 AT FR16 AND FR 20 WITH CORROSION. REPLACED PAX CABIN SEAT TRACK BETWEEN FR16 AND FR20 AT Y1292 IAW A319 SRM 51-72-11-911. (1205452).SDR DALA2025091906892Floor Panel · delaminatedDELAMINATED FLOOR PANEL 261DF AT AFT GALLEY AREA. COMPLIED WITH ER/A 628697-14. (1205802).SDR IXXA20250918053Power Supply · inoperativeFOUND INTERIOR EMERGENCY LIGHTS RIGHT CEILING, DOOR EXIT SIGN AND DOOR THRESHOLD LIGHT INOPERATIVE DURING EMERGENCY LIGHT TEST. PLACED ON DEFERRAL 66237. MINIMUM EQUIPMENT LIST ATI-33-51-01-01 CATEGORY D. TROUBLESHOT IN ACCORDANCE WITH B767 IAI WIRING DIAGRAMSDR ABXA20250918232A/C Pack · warning messageON TAXI OUT, L PACK TEMP EICAS MESSAGE ILLUMINATED. AIRCRAFT RETURNED TO BLOCKS (BTB). MAINTENANCE DEFERRED L PACK PER MEL 21-51-1-1. MTX PROCEDURES CW. PLACARD INSTALLED. AC RELEASED NO ETOPS. A/C RETURNED TO SERVICE.SDR SIMA20250918003Flashlight · faultedCAPTAIN SIDE FLASHLIGHT MISSING SWITCH THAT TURNS ON/OFF LIGHT. RAR FLASH LIGHT CAPTAIN SIDE IAW E175 AMM 33-51-01 OP CHECK GOOD.SDR SIMA20250918002Glowstrip · detachedFOUND PHOTOLUMINESCENT INDICATOR STRIP LIGHT IN FWD CLOSET INSTALLED PHOTOLUMINESCENT INDICATOR STRIP LIGHT AT FWD CARPET THRESHOLD IAW AMM 33-50-21, OPC GOOD.SDR DALA2025091906883Plenum · damagedDIVERTED TO DTW DUE TO LEFT PACK ON MEL AND RIGHT PACK STOPPED WORKING. FOUND PACK NR 2 PLENUM DAMAGED, HEAT EXCHANGER AND FLANGE ON REHEATER CRACKED, AND PACK COMPRESSOR OVERHEAT SENSOR SHOWING AMBER XX. REPLACED PLENUM, HEAT EXCHANGER, REHEATER, AND ELECTRISDR DALA2025091906881Light · inoperativeEMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE AT LOCATION 606 AND RC335201606, ADDITIONAL LOCATIONS 607, CROSS AISLE LIGHTS IN AFT GALLEY FALLING INSIDE COMPARTMENT. REPAIRED PER 0 AMM 33-51. OK FOR SERVICE. (1205265)SDR DALA2025091906879Elec Connector · disconnectedSEAT 55 J/H EMERGENCY AISLE LIGHT INOPERATIVE. CONNECTED THE ELEC CONNECTOR IAW AMM 33-51. OK FOR SERVICE. (7084209)SDR AALA202509194308Battery · no testAIRCRAFT IN BASE MAINTENANCE: FAULT MESSAGE FOR EMERGENCY POWER SUPPLY UNIT 12WL DISPLAYED DURING SYSTEM TEST. REPLACED BATTERY FOR EMERGENCY POWER SUPPLY UNIT 12WL AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR AALA202509192185Fork · stickingAIRCRAFT IN BASE MAINTENANCE: L1 DOOR ARM/DISARM HANDLE DIFFICULT TO MOVE CLEANED / LUBRICATED TELESCOPIC FORKS ON L1 DOOR AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 52-11-22.SDR AALA202509190021Battery · no testAIRCRAFT IN BASE MAINTENANCE: FAULT MESSAGE FOR EMERGENCY POWER SUPPLY UNIT 13WL DISPLAYED DURING SYSTEM TEST. REPLACED BATTERY FOR EMERGENCY POWER SUPPLY UNIT 13WL AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR AALA202509193779Screw · looseAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR IS DIFFICULT TO OPERATE AND UPPER LATCH DOES NOT ENGAGE. LATCH IS ABOUT 1/2" AWAY FROM ENABLING CLOSURE. MAINTENANCE FOUND SCREW LOOSE ON FIGHT DECK DOOR FRAME, SECURED SCREW AND ACCOMPLISHED A SATISFACTORY OPERATIONSDR AALA202509197913Battery · no testAIRCRAFT WAS NOT GROUNDED: BATTERY FAULT FOR EMERGENCY POWER SUPPLY UNIT 11WL DISPLAYED DURING SYSTEM TEST. REPLACED BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR AALA202509194734Handle · looseAIRCRAFT WAS NOT GROUNDED: DOOR 3R ARMING HANDLE LOOSE. MAINTENANCE RESECURED ARM/DISARM HANDLE PER AMM 52-22-22.SDR FDEA202509181741Hydraulic Line · leakingACTIVE HYDRAULIC LEAK FROM RIGHT WING JUST OUTBOARD OF RIGHT MAIN GEAR FOUND LINE LEAKING FLUID FROM LG UP CTR SYSTEM. OPENED RIGHT WING PANEL 651TB TO ACCESS LINE THAT IS LEAKING IN REFERENCE TO AMM LISTED ABOVE. REMOVED CENTER HYDRAULIC SYSTEM RIGHT MAISDR FDEA202509181740Seat Track · corrodedMAIN CABIN SEAT TRACK FLANGES WITH CORROSION BETWEEN BS 1620 TO 1420 LBL 58.22 REMOVED MAIN CABIN SEAT TRACK BETWEEN BS 1420-1620 LBL 58.22 IAW B757 SRM 51-40-02-0G TRIMMED, LOCATED AND DRILLED NEW SEAT TRACK IAW B757 SRM 51-40-05-0G, 51-40-08-0G BOEING DSDR CALA2025091909064Sensor · dirtyAFT ENTRY DOOR LIGHT WAS INTERMINTENTLY ILLUMINATED ON TAKEOFF A ND LANDING FOUND AFT ENTRY DOOR WARNING SENSOR DIRTY. CLEANED SENSOR, OPS CHECK GOOD. ADVISED CREW TO MONITOR DURING SUBSEQUENT FLIGHT PER FIM 52-10 TASK 814.SDR CALA2025091909057Light · unsecureSEAT 34D HAS EMERGENCY LIGHT HANGING LOOSE UNDER SEAT. SECURED THE LIGHT IAW AMM 33-51-00.SDR CALA2025091909055Lamp · inoperativeSEAT 12C EMERGENCY LIGHT INOPERATIVE. REPLACED FLOOR PROXIMITY LIGHT LAMP AT SEAT 12C IAW AMM 33-51-11-960-801. OPS CHECKED GOOD.SDR CALA2025091909054Battery Pack · inoperativeEMERGENCY FLOOR MOUNTED PROXIMITY LIGHTS AT ROW 22-27 INOP. REPLACED BATTERY BACK FROM POWER SUPPLY AT ROW 26ABC. REF AMM 33-51-06-960-802. OPS CHECK GOOD.SDR CALA2025091909051Fan · dirtyWEIRD ODOR COMING OUT OF PACKS, INITIAL ENTRY INTO CABIN WITH PAX ON BOARD AND PACKS OPERATING INDICATES MODERATE ACIDIC-RUBBER LIKE ODOR. RECIRC FAN SYSTEMS AND ETC. REMOVED FORWARD CARGO COMPARTMENT AFT BULKHEAD LINER REMOVAL AND FOUND ODOR COMING FROM SDR CALA2025091909050Apu · odorACFT SMELLS OF VAPOR & BURNING OIL WITH APU & ENG BLEED. REPLACED RECIRCULATION FILTERS IAW 21-25-02/401. RAN APU AND BOTH ENGINES ONE AT A TIME. THE ODOR WAS ONLY NOTICEABLE WHEN USING THE APU BLEED. ENINE RUNS WERE NORMAL. SUGGEST PLACING APU BLEED ON SDR DALA2025091906876Battery Pack · inoperativeR1 DOOR EXITERIOR EMERGY SLIDE LIGHT INOPERATIVE. R & R POWER SUPPY- BATTERY PACK IAW B737 AMM 33-51. OPS CHECK GOOD.SDR SCNA20250919382Handle · unsecureLEFT FWD OVERWING EMERGENCY EXIT DOOR MAINT ASSIST STRAP MISSING TRIM RETAINING STUDS. SECURED THE LT FWD OVERWING EXIT DOOR ASSIST HANDLE TRIM ASSY. REF AMM 52-22-51.SDR DXTA2025091905005Light · no testEMERGENCY EXIT LIGHT LOWER RIGHT ON CABIN ENTRY DOOR INOP PERFORMED FULL RECHARGE PROCEDURE CONFIRMED DISCREPANCY, REMOVED LOWER EMER EXIT SIGN, THERE WAS NO RESISTANCE AND FELT LIKE IT WAS UNPLUGGED. CHECKED FOR POWER AT PLUG WITH A GOOD READING. REINSTALLED SDR QMLA2025091820095Warning Light · illuminatedGEN LIGHT ILLUMINATED 5 TIMES IN FLIGHT. IT RESET EVERY TIME. OPTED NOT TO CONTINUE THE FLIGHT BEYOND SYRACUSE.SDR DALA2025091906869Probe · leakingAT THE GATE MSP DURING DEPLANING DIRTY SOCK ODOR REPORTED BY FAS . NEAR ROW 27A. APU AIR IN USE. AFTER 3+ MIN APU WARM UP. AFTER LANDING. C/W AMDS 0550-2002. FOUND APU INLET CONTAMINATED WITH OIL. CLASSIFIED AS LEEL B. C/W AMDS 4900-2001. FOUND APU OIL TEMP PSDR DALA2025091806868Oil System · leakingFUMES IN CKPT DURING DESCENT AT 11000FT. DIRTY SOCK SMELL. APU OFF AFT GALLEY REPORTED PAINT SMELL. OIL POOL FOUND IN LEFT ENGINE FAN CONE. REPLACED FAN SHAFT COVER SEALS PER A321 AMM 72-15. CLEANED ALL OIL RESIDUE FOUND IN OR AROUND FAN CONE. PER MCC PERFORSDR FDEA202509181739Repair · no discrepancyEXISTING REPAIR AT MAIN DECK CARGO COMPARTMENT FLOOR SEAT TRACK STATION 625 - STATION 645 X = 47.5 LEFT HAND SIDE. EXISTING REPAIR AT MAIN DECK CARGO COMPARTMENT FLOOR SEAT TRACK STATION 625 - STATION 645 X = 47.5 LEFT HAND SIDE EVALUATED AND FOUND REPAIRESDR SIMA20250918001Lamp · no testFO FLASHLIGHT INOP. RELAMPED FO FLASHLIGHT OPC GOOD EJ25-085SDR 7C7A2025091800039Apu · oil consumptionHIGH OIL CONSUMPTION AUTO SHUTDOWN ACTIVATEDSDR QR9R2025091800005Bleed Valve · failedNR 1 ENGINE BLEED AIR VALVE FLAG DID NOT COME ON DURING PREFLIGHT CHECKLIST WITH TWIST GRIPS AT FLIGHT. REMOVED AND REPLACED BLEED VALVE IAW ARRIEL1 E2 75-31-00-900-804-A01; MOC SUCCESSFULLY COMPLETED.SDR DALA2025091806854A/C Pack · failedDECLARED EMERGENCY DURING APPROACH INTO ATL DUE TO A DUAL PACK FAILURE AT FL200. LT ENGINE EIU FAULT LED TO THE LT PACK FAULT. THE RT PACK WAS ALREADY ON MEL FOR A PRIOR OVERHEAT MESSAGE. CORRECTIVE ACTION: DURING TS, LT ENGINE PYLON CONNECTOR 406VC1 WAS FOUNDSDR KCSA202509181166Fitting · crackedCRACK FOUND AT STA 1000 INTERCOSTAL LUG FITTING AT LBL 11.33SDR JJBA20250918030Lamp · inoperativeLH WING/FUSELAGE FWD EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED EXTERNAL EMERGENCY LIGHT LAMP OF FORWARD LOWER FAIRING. OPS CHECK SAT.SDR KCSA202509181165Fitting · crackedCRACK FOUND AT BS 1000 INTERCOSTAL LUG FITTING AT RBL 11.33SDR F3LA202509180293Floor Support · corrodedDURING INSPECTION FOUND CABIN FLOOR SUPPORT Y765 AT FR66-70 CORRODED. REQUIRES REPLACEMENT OF FLOOR SUPPORT Y765 AT FR65 AT FR66-FR70 AS PER SRM 51-72-11 REV 45. FLOOR SUPPORT Y765 AT FR66-FR67 WAS REPLACED AS PER SRM 51-72-11 REV45. MX ACTION ACCEPTABLE.SDR F3LA202509180292Floor Support · corrodedAIRCRAFT WAS NOT GROUNDED AND IS IN CHECK FOR SCHEDULED MX. DURING INSPECTION OF THE AFT CABIN FLOOR STRUCTURE FOUND CORROSION L2 DOOR SILL BEAM FR-68. PERFORMED REPAIR OF THE L2 DOOR SILL BEAM FR-68 IAW-53-41-14-300-001 REV 45. MX ACTION IS ACCEPTABLE. /E