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 FDEA202507011087Idg · faultedIN FLIGHT L GEN OFF AND ASSOCIATED EICAS. L AC BUS OFF. RESET IN FLIGHT. OPERATED NORMALLY FOR 20 MINUTES. SAME MALFUNCTION AGAIN DURING DESCENT. EMERGENCY DECLARED. BITE CHECKED BPCU PER FIM 24-20 F/T 801. FOUND SAME MESSAGES AS PREVIOUS L GEN SYSTEM DSDR CALA2025070206155Computer · faultedYAW DAMPENER SWITCH TRIPPED OFF IN FLIGHT ABLE 2 RESET PILOTS STATED YAW DAMPENER SWITCH TRIPPED OFF ONCE DURING THEIR FLIGHT AND WAS ABLE TO RESET SUCCESSFULLY, PILOTS SAID IT TRIPPED ONCE ON THE CREW PRIOR TO THEM AS WELL AND DIDNT FEEL COMFORTABLE FLYING INSDR CALA2025070206143Light · false activationAFT GALLEY LIGHT ON EMERGENCY EVAC PANEL ILLUMINATED AFT GALLEY FAP PANEL HAS SMALL RED LIGHT ILLUMNAITED ON EMG SWITCH. CYCLED EMG LIGHTS PUSH BUTTON MULTIPLE TIMES RED LIGHT EXTIGUSH IAW AMM TASK 33-51-00 NO DEFECTS NOTEDSDR CALA2025070206142Battery Pack · failedPASSENGER CABIN EMERGENCY LIGHT M1670 FAILS BATTERY CHECK. REMOVED AND INSTALLED BATTERY PACK M1670 IAW B737 AMM 33-51-06-9 60-802, OP CHECKS GOOD.SDR CALA2025070206141None · no discrepancyDURING A/C REFUELING, PRIOR TO ENG OR APU START, 1 F/A REPORTED STRONG FUEL SMELL IN ACFT. NO OTHER CREW OR PASSENGERS WERE EFFECTED BY ODOR. CAPTAIN WALKED TO BACK OF ACFT ON 3 DIFFERENT OCCASIONS AND NEVER NOTICED ANY SMELL OR FUMES/ VISIBLE SMOKE. STONG SMSDR CALA2025070206140Skin · crackedCRACK ON AFT INNER SKIN SLAT 10 NEAR ACCESS 625 CB RIGHT WING. REMOVED AND REINSTALLED LE SLAT #10 AS PER AMM TASK 27-81-0 2-424-021, TEST SATISFACTORY, REPLACED 2 E/A COVERED SKIN IAW B757 SRM 51-40-02-0G, ADJUSTED SLAT NR 10 PER B757 AMM TASK 27-81-02 -424-SDR CALA2025070206139Skin · crackedCRACK ON AFT SKIN SLAT #9 NEAR ACCESS 624CB. REMOVED AND REINSTALLED LE SLAT #9 AS PER B757 AMM TASK 27-81-02 -424-021, TEST SATISFACTORY, SKIN OF SLAT #9 WAS REPLACED IAW B7 57 SRM 51-40-02.SDR CALA2025070206138Battery Pack · malfunctionedR4 DOOR AFT EMERGENCY LIGHT POWER SUPPLY M33409 BATTERY PACK FOUND MALFUNCTIONED. REPLACED R4 DOOR AFT EMERGENCY LIGHT PO WER SUPPLY M33409 BATTERY PACK AND PERFORMED NEW BATTERY PACK TE ST THE TEST RESULT NORMAL AS PER AMM 33-51-06-960-802 REV.104.SDR CALA2025070206137Power Supply · malfunctionedR3 DOOR FWD EMERGENCY LIGHT BATTERY PACK M33404 FOUND MALFUNCTIONED. REPLACED R3 DOOR FWD EMERGENCY LIGHT PO WER SUPPLY M33404 & BATTERY PACK THE PERFORMED NEW POWER SUPPLY AND NEW BATTERY PACK INSTALLATION TEST,THE RESULT NORMAL AS PER AMM 33-51-06-960-803 &SDR CALA2025070206136Battery Pack · malfunctionedR3 DOOR AFT EMERGENCY LIGHT BATTERY PACK M33401 FOUND MALFUNCTIONED. REPLACED R3 DOOR AFT EMERGENCY LIGHT PO WER SUPPLY M33401 & BATTERY PACK,THE PERFORMED NEW POWER SUPPLY AND NEW BATTERY PACK INSTALLATION TEST,THE RESULT NORMAL AS PER AMM 33-51-06-960-803 &SDR DALA2025070104948Repair · corrodedSHIP 6711 CORROSION ON PREVIOUS STRINGER REPAIR AT RBL 16 STA 1510 AT AFT CARGO COMPARTMENT. CORROSION LEVEL 2, STRINGER AT RBL 16 STA 1510 AT AFT CARGO COMPARTMENT WAS REPAIRED PER B757-200 SRM 53-00-53-2R PROCEDURE 1 REPAIR 1. (1056161)SDR JR2R20250701209Floorbeam · crackedFWD SIDE OF FLOOR BEAM 12 ANGLE CRACKED UNDER PILOTS SIDE COUNSIL IN THE FLIGHT DECK IS CRACKED AT INTERCOSTAL.SDR EE4Y2025070122614Frame · crackedDURING ALLEGIANT ACCOMPLISHMENT OF THE TASK A32X-E5311-0019, UPPER FUSELAGE FR16 LH SIDE DOUBLE JOGGLE AREA HOLE POSITION # 7 WITH CRACK INDICATION WAS FOUND. PERFORMED NEXT NOMINAL FASTENER HOLE # 7 REPAIR AND ASSOCIATED HOLE # 8 SECOND OVERSIZE REPAIR IAW A3SDR DALA2025070104940Selector Valve · leakingAT GEAR RETRACTION IN MSP AND IND, HAD A STRONGER THAN NORMAL VIBRATION & NOISE, AS WELL AS AN ODOR THAT LASTED ABOUT 10 SECS. NO OTHER ABNORMALIES NOTED. REPLACED LT & RT NOSE WHEEL ASSYS IAW AMM 32-42. PERFORMED AMDS CARD 0550-2002 UP TO STEP 18 DECISION TRSDR 2025FA0000443Brake · seizedDURING AN AIRCRAFT JACKING PROCEDURE FOR UNRELATED MAINTENANCE, MAINTENANCE PERSONNEL NOTICED THAT THE RIGHT-HAND (RH) WHEEL WAS NOT ABLE TO SPIN NORMALLY DUE TO HIGH FRICTION. THE BRAKE WAS SENT OUT FOR EVALUATION AND WAS FOUND TO HAVE BEEN OVERHEATED, WHICH SDR DALA2025070104934Skin · damagedSHIP 3159 DURING DOOR CLOSURE OF 1L, GATE AGENT & LEAD FA NOTICED TOP LEFT OF EXTERIOR DOOR WAS DAMAGED. CORRECTIVE ACTION: REMOVED & REPLACED L1 PAX DOOR PER A319 AMM 52-11. (7012590).SDR DALA2025070104933Light · brokenSHIP 3132 SEAT 25D EMERGENCY EXIT LIGHT BROKEN OFF. CORRECTIVE ACTION: RE-ATTACHED EMERGENCY PATH LIGHT AT 25D REF. A319 AMM 53-51-13. (7571768).SDR JR2R20250701244Skin · corrodedUPON REMOVAL OF AFT WIFI ANTENNA DOUBLER, FOUND UNDERLYING SKIN TO HAVE LIGHT CORROSION.SDR IPXA2025070103289Gasket · leakingEMERGENCY DECLARED, LEFT HYD QTY ICAS MESSAGE QTY AT.45. PILOT STATED IT DID GO TO ZERO. REMOVED AND REPLACED YDS ELECTROHYDRAULIC SERVOVALVE AND SOLENOID VALVES GASKET PLATES AND PACKINGS PER AMM 22-21-03. OPS AND LEAK CHECK GOOD PER AMM 22-21-03. NO LEAKSSDR IPXA2025070100627Floor Panel · damagedMAJOR REPAIR, FOUND MAIN DECK FLOOR PANEL DAMAGE, PANEL NR 231GFF. IAW AMM 53-01-06-000-801 REV.145 REMOVE MAIN DECK CARGO FLOOR PANEL AND PERFORM G.V.I CHECK RESULT WAS NORMAL. IAW AMM 53-01-06-000-801 REV.145, REMOVED MAIN DECK CARGO FLOOR PANEL SEALANTSDR IPXA2025070100576Floor Panel · damagedMAJOR REPAIR , FOUND MAIN DECK FLOOR PANEL DAMAGE, P/N: 143T5876-90 PANEL NO.232JFF. IAW AMM 25-57-02-404-016 AND AMM 25-58-04-404-015 REV.145 INSTALLED MAIN DECK CARGO HANDLING AND CONDITION CHECK NORMALSDR IPXA2025070100773Floor Panel · damagedMAJOR REPAIR, FOUND MAIN DECK FLOOR PANEL DAMAGE, P/N:141T5856-13 PANEL 222DFF, IAW AMM 25-57-05-404-006, AMM 25-58-01-404-005 AND AMM 25-58-04-404-015 REV.145 INSTALLED MAIN DECK CARGO HANDLING AND CONDITION CHECK NORMAL.SDR IPXA2025070100572Floor Panel · damagedMAJOR REPAIR, FOUND MAIN DECK FLOOR PANEL DAMAGE, P/N: 143T5876-75 PANEL NO.231CFF. IAW AMM 25-57-02-404-016, AMM 25-58-01-404-005 AND AMM 25-58-05-404-052 REV.145 INSTALLED MAIN DECK CARGO HANDLING AND CONDITION CHECK NORMAL.SDR IPXA2025070100500Floor Panel · damagedMAJOR REPAIR, FOUND MAIN DECK FLOOR PANEL DAMAGE, PANEL NO.231AFF (REPAIR) 1.I.A.W AMM 53-01-06-000-801 REV.145 REMOVE MAIN DECK CARGO FLOOR PANEL AND PERFORM G.V.I CHECK RESULT WAS NORMAL. 2.I.A.W AMM 53-01-06-000-801 REV.145 REMOVE MAIN DECK CARGO FLOOR PSDR IPXA2025070104685Light · inoperativeDURING EMER LT TEST GOT LVL 1 €ŒEMER LT BAT 1 LO€? MSG REPLACED EMERGENCY LIGHT BATTERY POWER SUPPLY PER AMM 33-51-01. OPS CHECKED GOOD.SDR IPXA2025070112307Radar · faulted**SDR FILED OPEN** *** ATB *** DURING CRUISE @FL300 NAV ADC-PRED W/S DET FAULT. ALSA WEATHER FAIL. TRIED TO RESET IW SYSTEM RESET TABLE. AOM NO EFFECT. ATBSDR IPXA2025070105651Slide · no discrepancyUNABLE TO ARM SLIDE AFTER CLOSING DOOR ADJUSTED GIRT BAR ASSEMBLY REF AMM 25-61-21. DOOR OPERATES CORRECTLY AT THIS TIME. DEFERRAL CLEARED PLACARDS REMOVED.SDR DALA2025070104929Frame · damagedSHIP 3412 AT C61 OPEN HOLE HAS TOOLING MARK. CORRECTIVE ACTION: REPAIRED PER ERA 627461-14 REV ORIG. (1056947)SDR DALA2025070104928Frame Angle · damagedSHIP 3412 C61 FRAME ON P'2 ANGLE HAS TOOLING DAMAGE. CORRECTIVE ACTION: REPAIRED PER ERA 627461-14 REV ORIG. (1056942)SDR DALA2025070104927Proximity Switch · out of adjustSHIP 3357 DOOR L AFT CABIN ECAM MSG IN FLT. CORRECTIVE ACTION: ADJUSTED PROX SWITCHES PER A330 AMM 52-71. (1056802)SDR DALA2025070104926Frame · damagedSHIP 3406 AFT SIDE OF FR60 OTBD OF ATR 1L REINFORCEMENT ITEM WITH TOOLING DAMAGE ON AFT INBD EDGE OF REINFORCEMENT. CORRECTIVE ACTION: REPAIRED PER ERA 627461-14 REV ORIGINAL. (1056483)SDR DALA2025070104922Channel · damagedSHIP 3406 CENTER U-CHANNEL BETWEEN FRAMES 63 AND 64 HAS TOOL MARK. CORRECTIVE ACTION: REPAIRED PER ERA 627461-14 REV ORIGINAL. (1056834)SDR DALA2025070104921Stringer Clip · damagedSHIP 3406 FWD SIDE OF FR61 AT STR 1L. CLIP ASSY NOTED WITH TOOLING DAMAGE ON FWD OTBD EDGE. CORRECTIVE ACTION: REPAIRED PER ERA 627461-14 REV 0. (1056828)SDR DALA2025070104920Angle · damagedSHIP 3406 CLIP ASSY COMMON TO STRINGER 2 RT AND FRAME 63 HAS TOOL MARKS AROUND 4 OF THE UPPER ROW OF RIVET HEADS. CORRECTIVE ACTION: REPAIRED PER ERA 627461-14. (1056803)SDR DALA2025070104919Channel · damagedSHIP 3406 U-CHANNEL BETWEEN FR62-63 STRINGERS 1L &2L HAS TOOLING DAMAGE IN 2 SPOTS, MIDDLE OF U-CHANNEL AND FWD SIDE. CORRECTIVE ACTION: REPAIRED PER ERA 627461-14 REV. 0. (1056790)SDR DALA2025070104918Frame · damagedSHIP 3406 ON AFT SURFACE OF FR61 JUST INBD OF STR 3L 1 EA AREA OF TOOLING DAMAGE NOTED IN AFT UPPER RADIUS. CORRECTIVE ACTION: REPAIRED PER ERA 627461-14 REV 0. (1056784)SDR DALA2025070104917Support · damagedSHIP 3406 FWD SIDE OF FR 62 SUPPORT AT STRINGER 2L ITEM 74 HAS TOOLING DAMAGE. CORRECTIVE ACTION: REPAIRED PER ERA 627461-14 REV. 0. (1056781)SDR DALA2025070104916Bracket · damagedSHIP 3406 TOOLING MARK AROUND RIVET HEAD AT ANGLE BRACKET COMMON TO FRAME 64 AND STRINGER 1 LEFT BOTTOM RIVET. CORRECTIVE ACTION: REPAIRED PER ERA 627461-14. (1056687)SDR DALA2025070104915Channel · damagedSHIP 3406 U-CHANNEL FWD OF FRAME 64 HAS MULTIPLE PAINTED OVER TOOL MARKS BETWEEN REAR END OF U-CHANNEL AND 2ND ROW OF RIVETS FORWARD. CORRECTIVE ACTION: REPAIRED PER ERA 627461-14 REV 0. (1056611)SDR DALA2025070104914Frame · damagedSHIP 3406 FWD SIDE OF FR61 OTBD OF STR 1R U-CHANNEL REINFORCEMENT TOOLING DAMAGE. CORRECTIVE ACTION: REPAIRED PER ERA 627461-14 REV 0. (1056597)SDR DALA2025070104913Frame · damagedSHIP 3406 DAMAGE BETWEEN FR60 & FR61 U-CHANNEL BETWEEN STR 1R AND 2R. CORRECTIVE ACTION: REPAIRED PER ERA 627461-14 REV 0. (1056588)SDR DALA2025070104912Frame · damagedSHIP 3406 FRAME 64 AFT SIDE BETWEEN STRINGERS 2L AND 1R MULTIPLE TOOL MARKS ALONG UPPER BEND RADIUS. CORRECTIVE ACTION: REPAIRED PER ERA 627461-14. (1056577)SDR DALA2025070104911Frame · damagedSHIP 3406 AFT SIDE OF FR61 STARTING AT STR 3R TO STR 4R NOTED WITH 7 EA AREAS WITH TOOLING MARKS. CORRECTIVE ACTION: REPAIRED PER ERA 627461-14 REV 0. (1056565)SDR DALA2025070104910Frame · damagedSHIP 3406 FWD SIDE OF FR61 OUTBD OF STR1R U-CHANNEL REINFORCEMENT NOTED WITH TOOLING DAMAGE AT AFT UPPER INBD FACE. CORRECTIVE ACTION: REPAIRED PER ERA 627461-14 REV 0. (1056563)SDR DALA2025070104909Frame · damagedSHIP 3406 AT FR60 AND STR 1L NOTED WITH TOOLING DAMAGE AT LWR FWD / LE OF CLIP ASSY. CORRECTIVE ACTION: REPAIRED PER ERA 627461-14 REV 0. (1056547)SDR DALA2025070104908Frame · damagedSHIP 3406 AFT SIDE OF FR60 INBD OF STR2R ITEM #93 (REINFORCEMENT) NOTED WITH 2EA AREAS OF TOOLING DAMAGE. CORRECTIVE ACTION: REPAIRED PER ERA 627461-14 REV 0. (1056541)SDR DALA2025070104907Frame · damagedSHIP 3406 AFT SIDE OF FR60 BETWEEN STR 1R AND 2R. 2 EA AREAS OF TOOLING DAMAGE NOTED BELOW REINFORCEMENTS. CORRECTIVE ACTION: REPAIRED PER ERA 627461-14 REV O. (1056523)SDR DALA2025070104906Frame · damagedSHIP 3406 AFT SIDE OF FR60 INBD OF STR 1L. TOOLING DAMAGE NOTED ON UPPER AFT EDGE OF FRAME. JUST INBD OF REINFORCEMENT. CORRECTIVE ACTION: REPAIRED PER ERA 627461-14 REV 0. (1056498)SDR DALA2025070104930Frame · damagedSHIP 3406 AFT SIDE OF FR60 OTBD OF STR 1R. TOOLING DAMAGE NOTED ON UPPER AFT EDGE OF FRAME. JUST INBD OF REINFORCEMENT. CORRECTIVE ACTION: REPAIRED PER ERA 627461-14 REV 0. (1056512)SDR BJNA202507010001Light · damagedDURING WALKAROUND FOUND SEAT 20 DEF EMERGENCY LIGHT INOPERATIVE. R/R LIGHT SUBASSY ON SEAT 20 DEF EMERGENCY LIGHT DUE TO RECURRING LAMP REPLACEMENT IAW AMM 33-21-00 OPS CHECK GOOD A/C OK FOR SERVICE