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 AALA202508161372Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR IS DIFFICULT TO OPEN AND CLOSE. ADJUSTED DOOR STOP. PER CMM 25-40-64. OPERATIONAL CHECK GOOD.SDR AALA202508160008Girt Bar · damagedAIRCRAFT WAS NOT GROUNDED: GIRT BAR HEAT SHRINK TUBING DAMAGED AT R2 DOOR. REPACED R2 DOOR GIRT BAR HEAT SHRINK TUBING. PER AARD 25-66-00.SDR AALA202508155051Warning System · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: GEAR HANDLE WOULD RAISE ON TAKEOFF; AIRCRAFT EMERGENCY LANDED SAFELY AT ATL. REMOVED AND REPLACED LANDING GEAR CONTROL LEVER LOCK SOLENOID (AALA202508151170), PER AMM 32-31-31. REMOVED AND REPLACED AURALSDR AALA202508151170Warning System · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: GEAR HANDLE WOULD RAISE ON TAKEOFF; AIRCRAFT EMERGENCY LANDED SAFELY AT ATL. REMOVED AND REPLACED LANDING GEAR CONTROL LEVER LOCK SOLENOID (AALA202508151170), PER AMM 32-31-31. REMOVED AND REPLACED AURALSDR AALA202508158691Ballast · burned outAIRCRAFT WAS GROUNDED: FLIGHT ATTENDANTS REPORT BURNT SMELL IN AFT GALLEY. PERFORMED JOB CARD 08L00021001. DURING TROUBLESHOOTING TRACED ODOR TO AFT GALLEY CEILING LIGHT ELECTRONIC BALLAST. ALSO, FOUND BALLAST OVERHEATING. REPLACED BALLAST, PER AMM 33-26-02. OSDR CALA2025081507850Light · inoperativeFA REPORTS 20C SIDE SEAT EMER LIGHT INOPERATIVE. SWAPPED LIGHT FROM 20C WITH 14C IAW AMM 33-51-11, OPS CHECKS ON 20C OK, DEFERRED 14C FLOOR ESCAPE PATH LIGHT IAW MEL 3319E.SDR CALA2025081507849Oven · odorFA`S IN AFT GALLEY REPORTED STRONG PLASTIC OR ELECTRICAL ODOR. WENT AWAY. CONFIRMED ELICTRICAL ODOR IN CABIN. FLT CREW STATED: APPROX 2.5 HRS INTO FLT AT AIRSPEED .86 MACH & AN ALTITUDE OF 37000 FT. EXPERIENCED A STRONG BURNING ODOR & HAZE BETWEEN DOORS 3 &SDR CALA2025081507848Seal · leakingWHISTLING SOUND FROM WINDOW 30A. AIR LEAK ON UPPER SEAL OF LT PLUG DOOR DURING PRESSURE CHECK USING LEAK CHECK FLUID. OPENED MID CABIN LH EXIT DOOR PLUG FOR FURTHER INSPECTION IAW AMM 52-23-02-010-802 UP TO STEP E.8. FOUND SEAL DAMAGE AT AREAS LEAKING. REMOSDR DXTA2025081504596Skin · dentedRADOME REQUIRES INSPECTION FOR HAIL DAMAGE. LEFT STAB REQUIRES INSPECTION FOR HAIL DAMAGE. RIGHT STAB LEADING EDGE REQUIRES INSPECTION FOR HAIL DAMAGE. REMOVED DAMAGED RADOME REPLACED WITH CUSTOMER SUPPLIED REPAIRED RADOME. COMPLIED WITH POST MAINTENANCE GAPSDR MTNA20250815001Access Panel · crackedCRACK FOUND ON RH ENGINE NACELLE..... PERFORMED TEMP REPAIR PER MAC EO # C408-54-0003 AND CESSNA 408 NACELLE CRACKING MINOR REPAIR LETTER DQ42817M3 DATED OCTOBER 16, 2024SDR WX0A2025081532543Battery · no test(AIRCRAFT NOT GROUNDED) FAS 5 FLASHLIGHT NOT BLINKING / REPLACED F/A 5 FLASHLIGHT BATTERY. OPS CHECK GOOD AT THIS TIME. THIS CLEARS MDDR 217954 MEL 25-60-08-A. INOP PLACARDS REMOVED. MX ACTION REVERSED.SDR UATA2870815255301Frame · buckledLH FWD FRAME OF THE LOWER RAMP OPENING (P/N 212-23201-03-1) IS BUCKLED BETWEEN FRAME 17+18. REPLACED DAMAGED C CHANNEL 212-23201-03-1 WITH NEW. SEE 337 DATED 08/13/2025 FOR FURTHER INFORMATION. IMPACT DAMAGE FOUND IN C CHANNEL 212-23201-03-1 FWD OF F18. REMOVESDR UATA1750815255701Hinge · crackedLH AILERON CENTER HINGE STRUCTURE, A PREVIOUS REPAIR PATCH IS CRACKED. REPAIR WAS ACCOMPLISHED AS FOLLOWS: REMOVED THE PREVIOUS CRACKED REPAIR ANGLE. USING THE ORIGINAL ANGLE AS A PATTERN A NEW ANGLE WAS FABRICATED FROM 301 STAINLESS STEEL 0.040 THICK AND INSTSDR AALA202508153731Battery · dischargedAIRCRAFT WAS NOT GROUNDED: FA EMERGENCY FLASHLIGHTS AT 2R DOOR SEATS INOP. MAINTENANCE REPLACED BATTERIES IN FA FLASHLIGHTS AT 2R IAW AMM 25-64-01.SDR AALA202508151190Battery · dischargedAIRCRAFT WAS NOT GROUNDED: FA EMERGENCY FLASHLIGHTS AT 3R DOOR SEATS INOP. MAINTENANCE REPLACED BATTERIES IN FA FLASHLIGHTS AT 3R SEAT IAW AMM 25-64-01.SDR AALA202508152769Elec Connector · brokenAIRCRAFT WAS NOT GROUNDED: ROW 11 EMERGENCY AISLE LIGHT INOP. REPAIRED FLOOR CONNECTOR IAW ESPM 20-44-10. OPS CK GOOD.SDR AALA202508155701Elec Connector · brokenAIRCRAFT WAS NOT GROUNDED: ROW 12 EMERGENCY AISLE LIGHT INOP. MAINTENANCE REPAIRED FLOOR CONNECTOR IAW ESPM 20-44-10. OPS CK GOOD.SDR AALA202508156974Metering Unit · faultyAIRCRAFT WAS GROUNDED: FUEL STATUS PAGE INDICATED NO POSITIVE FUEL PRESSURE TO LEFT ENG,INE. AS A PRECUATION RETURNED TO CLT EMERGENCY DECLARED AND LANDED OVERWIGHT WITHOUT INCIDENT. MAINTENANCE REPLACED LH ENGINE FUEL FLOW TRANSMITTER REFERENCE JOB CARD 72L40SDR FXTA20250815001Ahrs · faultedAHRS #1 & 2 FAILED, HEADING RED "X", LOSE OF SYNTHETIC VISION; GRS #1 S/N: 45T003846, GRS #3 S/N: 45T003702, GMU #1 1CM0333444. GMU #2 S/N: 1CM033471, REMOVED, INSPECTED, REINSTALLED. AHRS SYSTEM POST-MX CHECK PERFORMED. AHRS ADJUSTMENT/TEST, PITCH/ROLL OFFSETSDR DXTA2025081504600Battery · inoperativeDURING CRUISE WITH THE EMERGENCY LIGHTS ARMED , THE CABIN EMERGENCY LIGHTS TURNED ON AND WOULD FLICKER INTERMITTANTLY CORRECTIVE ACTION: COMPLIED WITH FIM TASK 33-50-00-810-801-A AND TROUBLESHOT DOWN TO / FAULTY #1 EMERGENCY BATTERY. CUSTOMER ELECTS TO REPLACESDR I5PA2025081368802Sensor · faultyFLT NO: MGE300, LEFT ENG BLEED OFF ON T/O, AIR RETURN HNL. MX PERFORMED FIM 36-10 FT 817, FOUND LH ENG PRECOOLER OUT TEMP FAULTY. R/R FAN AIR TEMP SENSOR PER AMM. PERFORMED PNEUMATIC HEALTH CHECK NO FAULTS NOTED.SDR ASAA2025081360080Lens · detachedL-2 DOOR EMERGENCY COVER EXIT FELL OFF. GROUNDED - YES. L-2 DOOR EMERGENCY EXIT LIGHT LENS COVER RE-INSTALLED REF AMM 33-51-01.SDR ASAA2025081360079Lens · missingEXIT SIGN MISSING 17F. GROUNDED - YES. INSTALLED NEW EMERGENCY EXIT SIGN LENS AT ROW 17DEF OPS GOOD. REF AMM 33-51-01.SDR ASAA2025081360078Lens · missingR1 DOOR EXIT SIGN COVER MISSING. GROUNDED - YES. INSTALLED NEW R1 DOOR EXIT LENS. PER AMM 33-51-01 OPS CHECK GOOD. NO DISCREPANCIES NOTED.SDR QMLA2025081320087Motor · failedENROUTE BACK TO BASE AFTER A TRANSPORT, THE CREW SMELLED A BURNING ELECTRICAL SMELL. SMOKE IN THE COCKPIT EP WAS FOLLOWED AND IT WAS DETERMINED THAT THE SMELL WENT AWAY WHEN THE ECS WAS TURNED OFF. IAW THE EP, WE LEFT THE ECS OFF AND CONTINUED TO BASE WITHOUT SDR 2025FA0000545Pump · seizedTHIS WAS A TRAINING FLIGHT. DURING A GO-AROUND, ON CLIMB OUT, THE PILOTS NOTICED THAT THE VACUUM GAGE READ 0 AND THAT THEIR TWO GYRO INSTRUMENTS WERE NO LONGER WORKING. THEY PROCEEDED AROUND THE PATTERN AND LANDED WITHOUT INCIDENT. THE REMOVED PUMP HAD A SHSDR HALA20250814247Blanket · damagedETOPS - FOUND APU SURGE AIR DUCT THERMAL BLANKET DAMAGED. REMOVED AND REPLACED APU SURGE AIR DUCT THERMAL BLANKET IAW A330 AMM 49-41-52-420-050-A STEP 9K.SDR SWIA2025081400003Flap System · stuckHAD A FLAP FAIL CAUTION MESSAGE SHORTLY AFTER DEPARTURE €” QRH PROCEDURE DID NOT RESOLVE THE ISSUE, SO HAD TO RETURN TO FIELD. FLAPS WERE STUCK AT 2. (FLIGHT 3315 - FILED OPEN)SDR AALA202508146641Strut · out of rigAIRCRAFT WAS GROUNDED: F/CTL FLAPS LOCKED ALIGNMENT FAULT. DECESION MADE TO DIVERT TO IAD FOR LANGER RUMWAY, AIRCRAFT LANDED WITHOUT INCIDENT. MAINTENANCE TROUBLESHOT IAW 27-51-00-810-818-A AND FOUND LH INTERCONNECTING STRUT OUT OF RIG, REMOVED AND REPLACED LSDR SWAA2025081404032Seat Back · out of adjustSEAT ROW 12DEF WILL NOT STAY UPRIGHT<[01] TIGHTENED ALL SEATS IN ROW 12 DEF AS PER AMM 25-22-00SDR SWAA2025081404048Megaphone · inoperativeMEGAPHONE FORWARD CABIN. INOPERATIVE. R & R FWD CABIN MEGAPHONE IAW MM 25-64-00.SDR SWAA2025081403939Flashlight · inoperativeAFTER GALLEY FLIASHLIGHT ON FOS SIDE INOPERATIVE. REMOVED AND REPLACED BATTERY PER AMM 25-64-00.SDR SWAA2025081404418Battery · inoperativeAFT. AIRCRAFT LEFT EMERGENCY FLASHLIGHT INOP.<[01] R/R FLASHLIGHT BATTERY IAW MM 25-64-00 .SDR SWAA2025081403577Battery · inoperativeFWD JUMP SEAT FLASHLIGHT (2) INOPERATIVE. REMOVED AND REPLACED BOTH FA JUMP SEAT FLASHLIGHT BATTERIES AS PER AMM 25-64-00. OPS CHECK GOODSDR SWAA2025081404376Battery · failedFWD INBD F/A FLASHLIGHT WON'T TEST. R & R FWD INBD F/A FLASHLIGHT BATTERY REF AMM 25-64-00 OPS CHK GOOD.SDR SWAA2025081403638Slide · unpackedL1 DOOR ESCAPE SLIDE GIRT REPACK REQUIRED. REPACKED L1 DOOR ESCAPE SLIDE GIRT REF AMM 25-66-01.SDR SWAA2025081403575Door · crackedLEFT WING MLG MIDDLE DOOR CRACKED.<[01] REMOVED INNER AND CENTER GEAR DOORS REF 32-13-11 AND OK TO CONT REF AUTH# 273828SDR SWAA2025081403903Cover · detachedOVERWING EXIT SIGN COVER FELL OFF. REINSTALLED OVERWING EXIT SIGN COVER REF AMM 33-51-01.SDR SWAA2025081403864Lamp · inoperativeL2 DOOR EMERGENCY EXIT LIGHT INOPERATIVE. RELAMPED L2 DOOR EMERGENCY EXIT LIGHT IAW AMM 33-51-04. OPS CHECK GOOD; NO OTHER DEFECTS NOTED.SDR DXTA2025081404594Pin · missingWHILE OPENING MAIN CABIN DOOR THE LEFT CONNECTING LINKAGE CAME APART. PARTS ARE ON THE COUNTER. CORRECTIVE ACTION: ACCESSED AIRCRAFT AND NOTED THE DOOR LINKAGE HARDWARE ON THE GALLEY COUNTY AS LEFT BY THE / CREW. TECHS NOTED THAT THE HARDWARE WAS MISSING THESDR QMLA2025081320086Engine · faultedWHILE AT CRUISE FLIGHT THE NR 1 ENGINE TORQUE BEGAN TO RAPIDLY RISE WITH INCREASED ENGINE NOISE AND RISING ROTOR RPM. DURING THAT SAME TIME THE AIRCRAFT BEGAN A YAWING MOTION. IMMEDIATELY ADJUSTED POWER AND MANUALLY
ADJUSTED THROTTLE NR 1 TO REGAIN CONTROL ASDR YENA2025081400839Interface Unit · faultedFLT#1908, CDG-JFK. (ETOPS) "ENG SOFT FAULT ON TOGA TAKEOFF. A/THR KICKED OFF AS WELL BUT WAS ABLE TO RESET USING A/THR PUSH BUTTON ON THRUST LEVERS. ( LOST A/THR AFAIN ON APPROACH); TROUBLESHOT ENGINE SOFT FAULT AND AUTO THROTTLE FAULT PER TSM 78.00.810.808.A SDR DALA2025081406102Oil Filter · cloggedSHIP 5030 - ATB -AIR TURN BACK DUE TO LEFT ENGINE OIL FILTER CLOG MESSAGE. ENGINE OIL PRESSURE STILL IN GREEN AREA. CORRECTIVE ACTION: CHECKED OIL FILTER AND CHIP DETECTORS WITH NO FINDINGS. PERFORMED HIGH POWER RUN, NO FAULTS. WAITING FOR OIL FILTER DP SENSORSDR DALA2025081406075Structure · damagedSHIP 3161 FWD GALLEY LAMINATE COSMETICALLY DAMAGED. CORRECTIVE ACTION: REPLACED LAMINATED IN FWD GALLEY PER P.S. 900-9-1-11 AND A319 AMM 25-31. (1140950).SDR DALA2025081406074Seat Track · corrodedSHIP 3157 CORROSION FLOOR BEAM -Y765 AT FR20 FWD GALLEY AREA. CORRECTIVE ACTION: REPLACED FLOOR BEAM (SEAT TRACK) -Y765 LOC. BTW. FR12 TO FR24 AT FWD GALLEY AREA AS PER A319 SRM 51-42-11, A319 SRM 51-72-11. (1142092).SDR DALA2025081406073Seat Track · corrodedSHIP 3157 CORROSION FLOOR BEAM -Y1292 AT FR20 FWD GALLEY AREA. CORRECTIVE ACTION: REPLACED FLOOR BEAM ( SEAT TRACK) - Y1292 LOC. ON FR12 TO FR 24 AT FWD GALLEY AREA AS PER A319 SRM 51-42-11 AND A319 SRM 51-72-11. (1142082).SDR DALA2025081406072Stringer · corrodedSHIP 3146 AFT LOWER REAR FUSELAGE, AFT CARGO COMPARTMENT BETWEEN FR59 AND FR60, STGR 33R WITH CORROSION. CORRECTIVE ACTION: REPLACED STRINGER 33R IAW A319 SRM 51-72-11-911- 001. (1141554).SDR DALA2025081406089Skin · corrodedSHIP 3146 FOUND THE RH WING TOP SKIN PANEL 2, TRAILING EDGE OVERHANG AREA, LOWER SURFACE WITH CORROSION. CORRECTIVE ACTION: COMPLIED WITH ER/A 627459-14. (1142290).SDR DALA2025081406088Skin · corrodedSHIP 3146 RH WING TOP SKIN PANEL 2 WAS FOUND WITH CORROSION AT LOWER SURFACE TRAILING EDGE OVERHANG AREA. CORRECTIVE ACTION: COMPLIED WITH ER/A 627459-14. (1142287).SDR DALA2025081406087Skin · corrodedSHIP 3146 CORROSION FOUND AT THE RH WING TOP SKIN PANEL 2, TRAILING EDGE OVERHANG AREA, LOWER SURFACE. CORRECTIVE ACTION: COMPLIED WITH ER/A 627459-14. (1142277).