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 FDEA202507031106Floor Panel · puncturedMDC FLOOR PANEL 251EFF WITH PUNCTURES MDC FLOOR PANEL 251EFF WAS REPAIRED IAW B767 SRM 53-00-50-2R PAR 4B FIG 201 SHEET 2 REV 92 APR 15/2025SDR FDEA202507031105Floor Panel · crackedMDC FLOOR PANEL 241KFF WIYH PUNCTURES MDC FLOOR PANEL 241KFF WAS REPAIRED IAW B767 SRM 53-00-50-2R FIG 201 PAR 4B SHEET 2, REV 92. APR 15/2025.SDR FDEA202507031104Floor Panel · crackedMDC FLOOR PANEL 242HFF WITH CRACK MDC FLOOR PANEL 242HFF WAS REPAIRED IAW B767 SRM 53-00-50-2R PAR 4B FIG 201 SHEET 2 REV 92 APR 15/2025SDR FDEA202507031103Skin · dentedDENT ON OUTBOARD LOWER SKIN, BETWEEN WS 720 AND 746 LH WING LH WING, OUTBOARD FLAP LOWER SKIN WAS REPAIRED IAW B767 SRM 57-53-01-2R FIG 201 SHEET 3 DETAIL II AND SRM 51-70-10-2R REPAIR 4 REV 92 15/2025SDR DXTA2025070304120Wire Harness · disconnectedFOUND EMERGENCY FLOOR PATH LIGHT AT SEAT 8 INOPERATIVE. CORRECTIVE ACTION: GAINED ACCESS TO EMERGENCY LIGHT AT SEAT 8, FOUND THAT HARNESS FOR THE LIGHT WAS DISCONNECTED. RECONNECTED AND OPS CHECKS GOOD. WORK PERFORMED WITH REFERENCE TO CE680A AMM 33-50-00SDR HALA20250706205A/C Pack · faultedETOPS - PACK 2 OUTPUTS HOT AIR WITH TEMP CONTROLLER SELECTED TO FULL COLD AND CABIN TEMP INCREASES TO 86. REPLACED TEMP CONTROL VALVE PER 21-53-53-000-801,21-53-53-400-801 OP CHECK 21-63-00-730-801 TEST OK OP CHECK GOOD.SDR DXTA2025070604126Precatch · faultedTHE MAIN CABIN DOOR PRE-CATCH WILL NOT RELEASE THE DOOR. PERFORMED LUBRICATION OF LH & RH TR GUIDE RODS AND PIVOT POINTS USING D5100NS LUBRICANT. NO DEFECTS NOTED. IAW NJA CE560XLS AAIPSDR AALA202507060800Power Supply · faultedAIRCRAFT WAS NOT GROUNDED: WHILE PERFORMING TEST OF THE EMERGENCY LIGHTING SYSTEM FOUND FAULT CLASS 1 BAT/EPSU (13WL) AFT L REF AMM 33-51-00-710-001. REPLACED BAT/EPSU (13WL) IAW AMM 33-51-38.SDR AALA202507060201Bottle · low pressureAIRCRAFT IN BASE MAINTENANCE: LOW PRESSURE DOOR DAMPER CYLINDER ON PASSENGER CREW DOOR 831 ATFWD GALLEY AREA. MAINTENANCE PERFORMED CHARGING OF DOOR DAMPER CYLINDER ON PASSENGER CREW DOOR 831 AT FWD GALLEY AREA IAW AMM 52-10-00-614-001-A STEP 4.BSDR AALA202507069386Bulb · inoperativeAIRCRAFT IN BASE MAINTENANCE: D2 R EXIT NEED RELAMP. MAINTENANCE REPLACED D2 R EXIT BULB IAW AMM 33-51-16-000-001-A STEP 4.A AND IAWAMM 33-51-16-400-001-A STEP 4.BTHRU E PERFORMED OPERACIONAL AND TEST IS OK.SDR AALA202507064014Cylinder · low pressureAIRCRAFT WAS NOT GROUNDED: RH AFT SERVICE DOOR CYLINDER PRESSURE LOW, 1000PSI, NEEDS SERVICING. MAINTENANCE SERVICED RH AFT DOOR IAW AMM 52-10-00.SDR AALA202507065811Light · brokenAIRCRAFT WAS NOT GROUNDED: EMERGENCY PATHWAY LIGHT OUTSIDE OF LAV E AT 3R TOP BROKEN DETACHED FROM WALL. MAINTENANCE REPLACED FLOOR PROXIMITY LIGHT AT LAV 3RC IAW AMM 33-51-06.SDR AALA202507062073Actuator · inoperativeAIRCRAFT WAS GROUNDED: RETURNED TO BCN BECAUSE OF SPOILER LIGHT, OVERWEIGHT LANDING AT WEIGHT OF 417,5,FLAPS 25, ANGLE 4 DEG TOUCHDOWN SPD 148 LANDING VERY SMOOTH. MAINTENANCE REPLACED #10 SPOILER ACTUATOR IAW AMM 27-61-16.SDR MASA2025070300053Control Panel · inoperativeFWD GALLEY EMER LIGHTS DO NOT TURN OFF - R+R FWD FA PANEL IAW E175 AMM 25-25-01. OPS CK GOOD.SDR DALA2025070405000Door Frame · crackedSHIP 3130 CRACK INDICATION FOUND IN RHS FR20 WEB LAYER IN HOLE #3 AT DOORSTOP FITTING #1. CORRECTIVE ACTION: REPAIRED PER 626903-14. (1061757)SDR DALA2025070404999Door Frame · crackedSHIP 3130 CRACK INDICATION FOUND IN RHS FR20 WEB LAYER IN HOLE #3 AT DOORSTOP FTG #1. CORRECTIVE ACTION: REPAIRED PER ER/A 626903-14. (1061752)SDR DALA2025070404998Door Frame · crackedSHIP 3130 CRACK INDICATION FOUND IN LHS FR20 WEB LAYER IN HOLE #3 AT DOORSTOP FTG #1. CORRECTIVE ACTION: REPAIRED PER ER/A 626883-14. (1061388)SDR DALA2025070404997Door Frame · crackedSHIP 3130 CRACK INDICATION FOUND IN LHS FR20 WEB LAYER IN HOLE #3 AT DOORSTOP FTG #1. CORRECTIVE ACTION: REPAIRED PER ER/A 626883-14. (1061383)SDR DALA2025070404996Door Frame · crackedSHIP 3130 CRACK INDICATION FOUND ON HOLE 1 OF THE DOOR STOP FITTING 7 AT FRAME 16 LH. CORRECTIVE ACTION: REPLACED INTERCOSTAL FITTING AT LOC. AT LEVEL DOOR STOP FITTING 7 AT FRAME 16 LH. (1061693)SDR DALA2025070404995Bonding Plate · corrodedSHIP 3130 CORROSION BONDING PLATE FLAP TRACK FAIRING 2 (631CB). CORRECTIVE ACTION: REPAIRED PER ER/A 622998-14TR. (1062035)SDR DALA2025070404994Door Frame · crackedSHIP 3130 CRACK INDICATION FOUND ON HOLE 3 OF THE DOOR STOP FITTING 7 AT FRAME 16 LH. CORRECTIVE ACTION: REPLACED INTERCOSTAL FITTING LOC. ATLEVEL DOOR STOP FITTING 7 AT FRAME 16 LH SIDE AS PER A319 SRM 51-42-11 AND A319 SRM 51-72-11. (1061671)SDR N6WA2025070306Lap Joint · corrodedCORROSION ON CIRCUMFERNTIAL JOINT AT FS280 BETWEEN STRINGER 25R AND 25L. PERFORMED REPAIR ON STRAP AT FS280 BETWEEN STRINGER 25R AND 25L IAW STS EA139-2025-122.SDR N6WA2025070305Bulb · inoperativeRH OVERWING EMERGENCY LIGHT IS INOP. REMOVED AND REPLACED THE RH OVERWING EMERGENCY LIGHT IAW CRJ AMM 33-51-15.SDR N6WA2025070304Bulb · inoperativeLH EMERGENCY EXIT LOWER INTERIOR EMERGENCY LIGHT IS INOP. REMOVED AND REPLACED THE LH EMERGENCY EXIT LOWER INTERIOR EMERGENCY LIGHT BULB IAW CRJ AMM 33-51-05.SDR N6WA2025070303Intercostal · corrodedCORROSION ON INTERCOSTAL AT STRINGER 27 BETWEEN FS394 AND FS409. REMOVED AND REPLACED INTERCOSTAL AT STRINGER 27 BETWEEN FS394 AND FS409.SDR N6WA2025070302Frame · corrodedCORROSION ON FRAME AT FS409.00 BETWEEN STRINGERS 19R - 20R. PERFORMED REPAIR ON FRAME AT FS409.00 BETWEEN STRINGERS 19R - 20R IAW GOJET EO C550-53MR-033 REV O.SDR N6WA2025070301Frame · corrodedFRAME 319.00 IS CORRODED BETWEEN STRINGER 25L AND 25R. REMOVED AND REPLACED FRAME 319.00 IAW CRJ SRM 51-42-06.SDR DALA2025070304989Frame · damagedSHIP 3415 FORWARD SIDE OF FRAME 61 AT 2L TOOLING DAMAGE ON ATTACH BRACKET SEVERAL LOCATIONS. CORRECTIVE ACTION: REPAIRED PER A330 SRM 51-42-11. (1060871)SDR JGVR0250703001Spar · corrodedBLENDED CORRODED AREAS OF THE LH AND RH AFT WING SPARS LOCATED IN THE MAIN LANDING GEAR WHEEL WELLS, PERFORMED NDT AND REPORTED FOR REPAIR DISPOSITION. CLEANED, TREATED, PRIMED AND TOPCOATED PER NETJETS REQUEST FOR TECHNICAL SERVICES REPORTS.SDR KY7A202507030038Skin · corrodedA/B/E CHECK FOUND BELLY CORROSIONSDR HNAA2025070300464A/C Pack · odorMELTING PLASTIC SMELL IN FLIGHT DECK. AIR CONDITIONING PACKS NOTE: FOUND TO BE PACK 1 ACM. INSPECTED #100 ACM AND PACK SYSTEMS, RAN PACK 1 FOR 30 MINUTES COULD NOT DUPLICATE. THIS CLEARS MEL 21-15-2.SDR SWAA2025070387876Lamp · inoperativeFWD SERVICE DOOR EXTERIOR EMERGENCY LIGHT INOP. RELAMPED IAW MM 33-51-04.SDR SWAA2025070387623Battery Pack · inoperativeRIGHT AFT EMERGENCY LIGHTS OUT. REMOVED AND REPLACED PER [AMM 33-51-06-960-805-NG (POWER SUPPLY - BATTERY PACK REPLACEMENT - PERMANENT)]SDR SWAA2025070387817Seal · crackedHORIZONTAL STABILIZER UPPER RIGHT FORWARD SLIDER CRACKED.<[01] 01 - REMOVED AND REPLACED PER [AMM 53-31-31-400-802-NG (STABILIZER-TO-BODY UPPER FRONT SPAR SLIDING SEAL INSTALLATION - PERMANENT)] HORIZONTAL STABILIZER UPPER RIGHT FORWARD SLIDERSDR DALA2025070304974Oxygen Mask · unwanted deploySHIP 3122 AFT RIGHT LAV O2 MASK FELL. CORRECTIVE ACTION: STOWED MASK PER A319 AMM 25-64. (7732409).SDR YENA2025070300680A/C Pack · contaminatedFLT#591, BOS-, "PACK 1 POSSIBLE OIL CONTAMINATION "DIRTY SOCK" ODOR IN COCKPIT WHEN PACK 1 IS ON; C/W INFO NOTICE 2017-T015, SECTION A, ISOLATED FAULT TO TYPE 10, AMBIENT AIR, PERFORMED LEVEL DECON IRT AMM 21-00-00, PER TSM 05-50-00-810-085-B/TSM 05-50-00-810-SDR JR2R20250703205Sill Drain · corrodedAFT WET AREA, LH MOP SILL BETWEEN FRAME 88 TO FRAME 90, IS CORRODED OUT OF LIMITS. REPLACEDSDR JR2R20250703203Gusset · corrodedAFT WET AREA, GUSSET AT FRAME 90A. RBL10, IS CORRODED OUT OF LIMITS. REPLACEDSDR QR9R2025070300002Starter Gen · fluctuatesGEN AMPS SPLIT GREATER THAN 10 (GEN 1: 30; GEN 2: 50 AT FLIGHT). A TEST PILOT EVAL FOUND #2 GEN AMPS CLIMBED TO 70 AS #1 DROPPED TO ZERO DURING CLIMB OUT. AFTER DECLARING A PL AND RETURNING TO AIRFIELD THE AMPS RETURNED TO 35 EACH. ON SHUTDOWN #1 AMPS INDICATESDR QR9R2025070300001Air Data Module · inoperativeVAR NR INOPERATIVE DURING START RUN-UP. REMOVED AND REPLACED AIR DATA UNIT IAW AMM 34-11-00, 4-1. TEST FLIGHT COMPLETED IAW MSM 05-60-00,6-1, CHECKS OK.SDR JR2R20250703202Gusset · corrodedAFT WET AREA, GUSSET PLATE AT FRAME 90, BL0, IS CORRODED. OUT OF LIMITS.SDR JR2R20250703201Gusset · corrodedAFT WET AREA, GUSSET PLATE AT FRAME 90, RBL10, IS CORODED OUT OF LIMTS. REPLACEDSDR JR2R20250703200Gusset · corrodedAFT WET AREA, "TEXAS DOUBLER" / GUSSET AT FRAME 90, RBL24, IS CORODED OUT OF LIMTS. REPLACEDSDR JR2R20250703199Sill Drain · corrodedAFT WET AREA, RH MOP SILL BETWEEN FRAMES 88-90 IS CORODED OUT OF LIMTS. REPLACEDSDR DALA2025070304967Spring · damagedSHIP 6711 A.A: DOES NOT RETAIN THE SLIDER FWD AND AFT SPRING ON R1 DOOR GIRT BAR. IN REF. AMDS 2560-01492-0201. SPRINGS FWD AND AFT (2 EAS) OF R1 DOOR GIRT BAR WERE REPLACED PER BOEING CMM 25-66-14. (1060508)SDR CALA2025070306175Battery Pack · dischargedEMERGENCY EXIT SIGN DOES NOT TURN OFF DOOR 2L DEBRIEFED FA, R & R BATTERY PACK M1673. EMERGENCY LIGHTS OPERATE NORMAL AND OPS CHK OK. REF AMM 33-51-06-960-805.SDR FDEA202507031102Power Supply · no testLVL 1 EMER LT BAT 1 LO WHEN PERFORMING EMERGENCY LIGHT TEST. REMOVED AND REPLACE EMERGENCY LIGHTS POWER SUPPLY. OPERATIONAL CHECK NORMALSDR FDEA202507031101Skin · crackedDURING PERFORM UT & OPEN HOLE HFEC INSPECTION OF THE LEFT UPPER WING SKIN COMMON TO FASTENERS 0-5 AND FOUND 02EA CRCAK AT HOLE #5. LEFT WING UPPER SKIN #5 HOLE 02EA CRACKS REPAIRED AS PER B777 SRM 51-40-05-0G, SRM 51-40-04-0G, SRM 51-40-02-0G REV47.6 AND ESDR FDEA202507031100Skin · crackedDURING PERFORM UT & OPEN HOLE HFEC INSPECTION OF THE RIGHT UPPER WING SKIN COMMON TO FASTENERS 0-5 AND FOUND 02EA CRCAK AT HOLE #5. RIGHT WING UPPER SKIN #5 HOLE 02EA CRACKS REPAIRED AS PER B777 SRM 51-40-02-0G, SRM 51-40-04-0G, SRM 51-40-05-0G REV47.6 ANDSDR F3LA202507030263Skin · dentedC4 CHECK REF LOGPAGE 444741 ITEM 1 & EAR INC0061624 FOR DENT ON SKIN FUSELAGE BETWEEN 13 & 14. REPAIRED DENT ON SKIN FUSELAGE BETWEEN FRAME 13 &14 IAW A320NEO SRM 53-11-11-300-04. CATEGORY B REPAIR CURRENT RC/FH IS 10,758/23,964.08 INSPECTION THERSHOLD FROM