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 DALA2025122909455Shear Tie · corrodedFOUND CORROSION ON SKIN CLIP AT FRAME 927 BETWEEN STRINGER 29L AND 30. REMOVED AND REPLACED DAMAGED FORMER PN 9915524-33 PER BOEING DWG 9915524 (1362226)SDR CALA2025122912476Floorbeam · crackedMAIN CABIN BS 540 LBL 1 FLOORBEAM CRACKED. R & R THE FLOORBEAM IAW SRM 51-40-02-0G-0.SDR DALA2025122809434Lens · missingFOUND 1L SLIDE ARM LIGHT LENS MISSING ON SVC CK. "1L DOOR". CORRECTIVE ACTION: REPLACED 1L DOOR ARM LIGHT LENS ASSY. REF B767-400 AMM 52-73 REVERSED "M" PROCEDURES. (8385901)SDR DALA2025122809429Oxygen Mask · unwanted deployPASSENGER OXYGEN MASKS ROW 28 DEF DROPPED ON TAKEOFF. C/A: REPLACED OXYGEN MASKS IN CONTAINER AND SECURED DOOR CLOSED AND LOCKED REF A320 AMM 35-21. (LP: 8069166)SDR AALA202512287728Slide · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK ON ENCLOSURE OFFWING SCAPE SLIDE LH (193AT). MAINTENANCE REPLACED ENCLOSURE OFF-WING ESCAPE SLIDE LH. IAW CARD 26C19053012.SDR AALA202512269395Fitting · stickingAIRCRAFT WAS NOT GROUNDED: FORWARD ENTRY DOOR GIRT BAR IS DIFFICULT TO DISARM. FLIGHT ATTENDANT REPORTS GIRT BAR ASSEMBLY PLASTIC HOUSING SEEMS TO BE COMING APART. MAINTENANCE REPLACED PLASTIC GIRT BAR STOP RING PER AMM 25-66-01. (AALA202512242326) MAIANTENANCSDR AALA202512269603Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R3 DOOR DAMPER AND EMERGENCY OPS CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPS CYLINDER PER AMM 52-22-00.SDR AALA202512267930Lanyard · unsecureAIRCRAFT WAS NOT GROUNDED: CORD HANGING OUT BOTTOM OF 4L DOOR. MAINTENANCE PERFORMED VISUAL INSPECTION OF 4L DOOR SLIDE AND RESECURED LANYARD PER AMM 25-62-44.SDR AALA202512266212Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R2 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202512260789Sliding Window · crackedAIRCRAFT WAS GROUNDED: OUTER PANE OF FIRST OFFICERS NUMBER 2 WINDOW CRACKED IN MIDDLE OF PREFLIGHT. MAINTENANCE REPLACED THE R2 SLIDING WINDOW PER TASK CARD 08L21056002.SDR AALA202512268126Bulb · inoperativeAIRCRAFT IN BASE MAINTENANCE: SEVERAL EMERGENCY EXIT LIGHT BULBS INOPERATIVE OVER 3 OF THE 4 OVERWING DOORS. REPLACED LIGHT BULBS AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-01.SDR AALA202512267510Fan · faultedACFT GROUNDED: DURING CRUISE AFT F/A CALLED & SAID THEY SMELLED A STRONG ODOR OF SULPHURIC LIKE ODOR. FWD F/A CALLED & SAID SAME THING. CABIN JUMPSEATER REACHED UP & SHUT OFF LAV, ATTN, READ POWER BUTTONS ON CIDS PANEL. ODOR DISAPPEARED & NO FURTHER ISSUES.SDR AALA202512268187Cids · false activationAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK SMOKE DETECTOR ALERTING INTERMITTENTANTLY WITH NO INDICATION. CIDS1 CLASS 2 MESSAGE APPEARS WITH ALERTS. MAINTENANCE REPLACED THE NR 1 CIDS DIRECTOR AND ACCOMPLISHED A SATISFACTORY OPS CHECK IAW AMM 23-73-34.SDR AALA202512264720Flashlight · misinstalledAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT UNDER JUMPSEAT AT DOOR 4R IS ON AND WON'T TURN OFF. MAINTENANCE REPLACED THE FLASHLIGHT BATTERY AND STOWED THE FLASHLIGHT PROPERLY IN HOLDER.SDR AALA202512266646Tube · missingAIRCRAFT WAS NOT GROUNDED: FORWARD ENTRY DOOR HEAT SHRINK END MISSING ON GIRT BAR LEFT SIDE. INSTALLED HEAT SHRINK TUBE ON L1 DOOR GIRT BAR PER AARD 25-66-00-4.SDR AALA202512262326Stop · separatedAIRCRAFT WAS NOT GROUNDED: FORWARD ENTRY DOOR GIRT BAR IS DIFFICULT TO DISARM. FLIGHT ATTENDANT REPORTS GIRT BAR ASSEMBLY PLASTIC HOUSING SEEMS TO BE COMING APART. MAINTENANCE REPLACED PLASTIC GIRT BAR STOP RING IAW AMM 25-66-01. (AALA202512242326) MAIANTENANSDR SCNA20251226502Bulb · inoperativeEMERGENCY EXIT LIGHT AT 15F INOPERATIVE. R & R EMERGENCY EXIT WINDOW LIGHT BULB AT 15F IAW: 33-21-00, OPS CHECKED GOOD.SDR ASAA2025122163311Door · bindingFA REPORTS: L2 DOOR WONT OPEN FULLY. GROUNDED - YES. L2 DOOR OPERATIONAL CHECK WAS PERFORMED IAW AMM 52-41-00 ALL WORKING WELL.SDR DALA2025122409399Proximity Sensor · faultedATB/DE- DUE TO TAKEOFF WARNING HORN SOUNDED DURING CLIMB OUT. PSEU FAULT CODE 31-53010 (LE FLAPS NOT EXT) AND FSEU FAULT 27-81218 (F2 PROX RETRACT) RECORDED. REPLACED LE FLAP 2 RETRACT PROXIMITY SENSOR (S170). FAULTS CLEARED. AIRCRAFT RETURNED TO SERVICE.SDR AALA202512245469Oxygen Mask · no testAIRCRAFT WAS GROUNDED: SEAT 20ABC O2 MASK COMPARTMENT WILL NOT RELEASE WHILE PERFORMING THE DROP TEST IAW AMM 35-23-00. MAINTENANCE OPENED AND INSPECTED MASK CONTAINER AT 20ABC. REPACKED AND STOWED MASKS AS NEEDED, PER AMM 35-21-43 AND PERFORMED SATISFACTORY DSDR DXTA2025122406243Bulb · unsecureSEAT NR 7 EMERGENCY EXIT LIGHT. READING LIGHT INOPERATIVE. TROUBLESHOT AS REQUIRED, FOUND SEAT NR 7 READING & EMER EXIT LIGHT BULB TO BE LOOSE, SECURED BULB. OPS CHECKED GOOD IAW AMM 33-20-02.SDR REXA2025122401056Switch · out of positionBURNING WIRE ODOR COMING FROM FO SIDE PFD OR MFD MAINLY IN FLIGHT. PERFORMED OPS TEST OF THE DISPLAY COOLING SYSTEM IAW AMM 21-24-00. OPS CHECK GOOD SWITCH WAS FOUND IN STBY.SDR CALA2025122412422Toilet · malfunctioned45 MIN INTO FLT WASTE TANK 2 SHOWS FULL & ASSOC LAVS WONT FLUSH. AFTER SERVICED, WASTE TANKS, OPS CHKD & FOUND LAV B INOP. DOOR 1L LAV B TOILET WON'T FLUSH. ACCOMPLISHED LAV B OPS TEST IAW AMM 38-32-00-700-802, TOILET FLUSHED NORMALLY MULTIPLE TIMES. OK FORSDR CALA2025122412421Selector Valve · faultedMAIN GEAR NOT DOWNLOCKED FOR FERRY, UNLOCKING COMPLETED AMM 32-30-00-867-001-A UP TO AND INCLUDING STEP 3.C. IAW AMM GROUND POWER CART HYD IS REQUIRED TO COMPLETE GEAR SWING. REF TSM 32-31-00-810-808-A, PERFORMED A FUNCTIONAL CHECK OF THE MLG. GEAR DOORS OPSDR CALA2025122412406Circuit Breaker · crackedCAPTAIN`S PITOT FAULT LIGHT ILLUMINATED. INITIAL INSPECTION FOUND CIRCUIT BREAKER OPEN. AIR RETURN WHILE PERFORMING VISUAL INSPECTION OF THE HEATERS, CAPT PITOT CIRCUIT BREAKER C1 FOUND A CRACKED AROUND THE NEGTITIVE TERMINAL. WHEN SLIGHTLY MOVING THE NEGISDR CALA2025122412403Control Rod · out of adjustDOOR WARNING ANNUNCIATOR IS ON AFT SERVICE & AFT ENTRY DOOR LIGHT ILLUMINATED INFLT. HANDLE CONFIGURED UNSTOWED. NORMAL LANDING. PERFORMED PRELIMINARY DOOR INDICATION CHECK DUE TO HORIZONTAL CONTROL ROD ADJUSTMENT. CLEARED TO INSTALL LINER AND SLIDE ASSY. SDR CALA2025122412401Intercostal · corrodedINTERCOSTAL BETWEEN BS 860 - 900 LT SIDE OF CENTER HAD EVIDENCE OF CORROSION. REMOVED AND REPLACED THE INTERCOSTAL BETWEEN BS 860 - 900 IAW SRM 51-40-02-0G-0.SDR CALA2025122412399Angle · corrodedAFT CARGO BAY, BS 1420 - 1440, RBL 7, ANGLES SUPPORT, TWO EACH ON WEB CORRODED. REMOVED THE TWO STIFFENERS IAW SRM 51-40-02, FABRICATED THE STIFFENERS IAW DWG 146N5378, PL 146N5448 -33 AND BAC 1490-2743. RESTORED PROTECTIVE SURFACE AND INSTALLED THE STIFFESDR CALA2025122412397Pitot Tube · faultedCAPT PITOT LIGHT ON, LIGHT WITH ASSOCIATED TRIPPED C/B. REMOVED AND REPLACED CAPT PITOT PROBE IAW AMM 34-11-01. OPS CHECKED GOOD. BREAKER REMAINS IN. REFER TO LOG 7349998 FOR LT PITOT SYSTEM LEAK TEST IAW AMM 34-11-00-790-810.SDR CALA2025122412395Lens · missingPOLARIS BUSINESS SEAT 1F WITH PROXIMITY LIGHT LENS MISSING. R & R FLOOR PROXIMITY LIGHT ASSY. GOOD FOR FLIGHT. IAW AMM 33-51-06.SDR CALA2025122412393Skin · crackedBROKEN DOUBLER AT PREVIOUS REPAIR OF POWER RECEPTACLE SURROUND SKIN. INSTALLED REPAIR PARTS AT POWER RECEPTACLE AREA IAW SRM 53-10-15-2R-4, REPAIR 4.SDR CALA2025122412391Balance Weight · corrodedRIGHT WING AILERON BALANCE BAY MOST INBD WEIGHTS (5EA) HAVE SIGNS OF CORROSION. R & R RT WING AILERON BALANCE BAY MOST INBD WEIGHTS (5EA) IAW SRM 51-40-02-0G-0, AMM 27-11-31-400-801, PAR 3, G. (M), STEPS 1 TO 3, OPS TESTED OK.SDR N6WA2025122401Stiffener · crackedFS 280 BULKHEAD STIFFENER RH INBD CRACKED. REMOVED AND REPLACED RH INBD STIFFENER AT FS280 IAW SRM 51-47-06SDR SWAA2025122354451Latch · inoperativeRIGHT AFT ATTENDANT SEAT ACCESS DOOR FOR EMERGENCY FLASHLIGHT WILL NOT OPEN. REPLACED ACCESS DOOR LATCH IAW CMM 25-25-12. OPS OK.SDR DALA2025122309390Slide · out of limitsFOUND R2 DOOR SLIDE OUT OF LIMITS. R & R R2 DOOR SLIDE IAW AMDS W/C 2566-9001-2R. (7887676)SDR AALA202512234120Uplock Target · false indicationAIRCRAFT WAS GROUNDED: ON GEAR RETRACTIONECAM MESSAGE L/G NOT UPLOCKED THAT ECAM WENT AWAY WITHIN A COUPLE SECONDS FOLLOWED BY ECAM MESSAGE L/G DOORS NOT CLOSEDFOLLOWED ECAM TO CYCLE GEAR. GEAR CYCLE OCCURRED NORMALLY AND ALL MESSAGES CLEARED. NO STATUS MESSAGSDR SWIA20251223021Outflow Valve · obstructedEMERGENCY DESCENT DUE TO RAPID DEPRESSURIZATION AT 33K FT. CALL FROM FA ABOUT A LOUD BANG FOLLOWED BY LOSS OF PRESSURIZATION. RAN QRC & QRH, LANDED WITHOUT ANY ISSUES. (FLIGHT 5053) DURING PRESSURIZATION OPS CHECKS FOUND ONCE 6.0 DELTA P IS REACHED RATE INDISDR SWAA2025122354578Hook · looseL1 SLIDE FWD J HOOK LOOSE. ACCOMPLISHED EA M-23-01859. INSTALLED NEW FASTNER IN L1 SLIDE FWD J HOOK.SDR SWAA2025122354586Slide · out of alignmentFORWARD GALLEY SLIDE LOOKS MISALIGNED. RESCURED EXCESS MATERIAL AT BOTTOM OF R1 DOOR SLIDE COMPARTMENT. VERIFIED GIRT BAR OPERATION; GIRT OPS NORMAL AND SLIDE PRESSURE GAUGE IS READABLE THROUGH SLIDE PACK WINDOW IAW AMM 25-66-01.SDR DALA2025122309351Longeron · crackedLONGERON AT RBL 40.0 CRACKED AT FWD END APPROX 18"LONG AT RADIUS BETWEEN VERT & OUTER FLANGES. AD RELATED, WC 5352-01038-01B. REMOVED AND REPLACED LONGERON @ RBL 40.0 PER A220 ASRP 51-77-00. (LP# 1362563)SDR YENA2025122301249Apu · odorFLT# 1799 0RF-FLL "ODOR EVENT AT AROUND 10,000FT. CREW REPORT SMELL OF DIRTY SOCK AFTER LANDING, SMELL WAS ALL THROUGH THE CABIN.; C/W INFO NOTICE .2017-T015 L. DETERMINED APU IS AT FAULT AND WAS PLACED ON MEL. PERFORMED LEVEL "A" DECONTAMINATION REF AMM 21-00SDR YENA2025122301248Reservoir · leakingFLT #2930 SJU - RDU (AN EMERGENCY WAS DECLARED ) "OW ALMOST 0 GREEN RESERV. ECAM HYD G ENG 1 PUMP LO PR G SYS LO PR ECAM AND QRH ACTIONS COMPLETED.; FOUND RH MLG DORO ACTUATION CYLINDER FLEX OPENEING HOSE BURST. REPLACED OPENING FLEX HOSE AND CLOSING FLEX HOSESDR YENA2025122301239Apu · odorFLT# 1799 ORF- FLL ODOR EVENT AT AROUND 10, 000FT. CREW REPORT SMELL OF DIRTY SOCK AFTER LANDING, SMELL WAS ALL THROUGH THE CABIN.; C/W INFO NOTICE .2017-T015 L. DETERMINED APU IS AT FAULT AND WAS PLACED ON MEL. PERFORMED LEVEL "A" DECONTAMINATION REF AMM 2SDR YENA2025122301238Hydraulic System · warning messageFLT # 2930 SJU- RDU ( AN EMERGENCY WAS DECLEARED ) "LOW ALMOST 0 GREEN RESERV. ECAM HYD G ENG 1 PUMP LO PR G SYS LO PR ECAM AND QRH ACTIONS COMPLETED. FOUND RH MLG DORO ACTUATION CYLINDER FLEX OPENEING HOSE BURST. REPLACED OPENING FLEX HOSE AND CLOSING FLEX HOSDR CALA2025122312375Battery · no testDURING CABIN EMERGENCY LIGHTING OPS TEST, FOUND RT EPSU BATTERY FAULTED. REMOVED & REPLACED RT EPSU IAW AMM 31-51-38. OPS TESTED GOOD.SDR CALA2025122312322Bottle · no discrepancySLIDE PRESSURE GAUGE IS IN THE RED ON THE L1 DOOR. PERFORMED L1 DOOR SLIDE CYCLINDER CHECK IAW AMM TASK 25-66-01-200-801. FOUND PRESSURE WITHIN GREEN BAND, OK TO CONTINUE.SDR CALA2025122312321Warning Light · false activationON TAKEOFF ROLL AT 100 KTS, CAUTION LIGHT FOR FWD ENTRY DOOR. LIGHT WENT OUT IN CLIMB, INSPECTED FWD ENTRY DOOR AND SWITCH, NO DEFECTS. OPENED AND CLOSED DOOR MULTIPLE TIMES. OPS CHECKED NORMAL IAW 52-71-11-710-802.SDR DALA2025122209335Battery Pack · no testSEAT 28DEF THROUGH 32DEF EMERGENCY LIGHTS INOPERATIVE. REPLACED THE BATTERY PACK LOCATED AT ROW 28 CEILING PANEL PER AMM 33-51. (LP 7398059)SDR DALA2025122209334Battery Pack · no testON SERVICE CHECK FOUND LT EMER EXIT LIGHT AFT OF OVERWING EXIT DOOR INOPERATIVE. REPLACED EMERGENCY LIGHT BATTERY PACK (M1670) IAW AMM 33-51. (LP 7380096)SDR GTIA2025122239220Apu Bay · contaminatedFA AND PAX IN ROW 25 SMELLED DIRTY SOCKS DURING TAKE OFF AND LANDING WAS REPORTED TO YHE PILOTS AFTER LANDING DURING TAXI IN PACK 2 AND XBLEED SHOT PER ELIMINATION OF FUMES PROCEDURE FUMES DISSIPATED -INDENTY CAUSE OF SMELL IAW TSM 05-50-00-810-831A, FOUND AP