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 HALA20250909275Filter · cloggedETOPS - APU AUTOSHUTDOWN PRIOR TO TOW TO GATE. APU LUBE AND SCAVANGE FILTERS INDICATED AS CLOGGED. REMOVED AND REPLACED LUB AND SCAVANGE FILTERS PER AMM 49-91-41. LEAK CHECK GOOD. OPS CHECK GOOD OF APU. OK FOR SERVICE.SDR FDEA202509081644Skin · corrodedLEFT WING INBOARD MAIN FLAP LOWER SKIN HAS CORROSION, (OUTBOARD FLAP TRACK AREA) UPON FURTHER EVALUATION ON LT WING INBD MAIN FLAP LOWER SKIN CORROSION FOUND OUT OF LIMITS IAW SRM 57-53-01-1A DETAIL I, FIG 101, SHEET 1, NOTE F AND APPLIED PERMANENT REPAIR IN SSDR DXTA2025090904888Rod · out of adjustWALKING UP TO THE AIRPLANE, NOTICED THE VENT DOOR WAS NOT FLUSH WITH CABIN DOOR. CANNOT COMPLY WITH MEL 52-70 WRITEUP, DOOR VENT WONT CLOSE COMPLETELY. TESTED CABIN DOOR TWICE WITH A CREWMEMBER ON BOTH SIDES OF DOOR TO ENSURE PROPER OPERATION, WITH AND WITHOUSDR DALA2025090906649Engine · faultedNR 2 ENGINE SHOWS HIGH FUMES FROM TAIL PIPE (BLUE ). PERFORMED OIL SERVICE TO ENG 2 ADDED 5 QTS, PERFORMED DVI ON ENG 2 FOR OIL LEAKS EVIDENCES, NO FOUND. (7273398).SDR DALA2025090906648Intercostal · corrodedAFT CARGO COMPARTMENT DOOR CUT OUT UPPER SECTION BETWEEN FR58 AND FR59 INTERCOSTAL FLANGE WITH CORROSION. REPLACED INTERCOSTAL IAW A319 SRM 51-72-11-911 -001. (1188751).SDR DALA2025090906647Access Panel · puncturedPUNCTURE ON ACCESS PANEL 192KB AT LOWER FUSELAGE. COMPLIED WITH ER/A 524189-14. (1188635).SDR YENA2025090900919Warning Light · false activationFLT#1251, HPN-RSW. "MULTIPLE DOOR/SLIDE INDICATORS DURING TAXI OUT INDIACTING SLIDES DISARMED WHEN THEY WERE ARMED; C/W WITH RESET OF PAX DOORS SLIDE INDIACTION SYSTEM IAW TSM 52-11-00 C/W WITH ARMING AND DIARAMING PROCEDURES.NO FAULTS NOTED.A/C OK FOR SVC."SDR DALA2025090906661Cover · looseEMERGENCY EXIT SIGN COVER LOOSE. RESECURED LOOSE PANEL AT EMERGENCY EXIT PER B757 AMM 33-51. (1188994)SDR DALA2025090906660Battery Pack · inoperativeFOUND AFT GALLEY EMERGENCY LIGHTED SIGNS INOPERATIVE. R & R BATTERY PACK FOR AFT GALLEY EMERGENCY LIGHTED SIGNS IAW B757 AMM 33-51 CHECKS GOOD. (7265933)SDR DALA2025090906659Sign · brokenOVERHEAD EMERGENCY EXIT SIGN AT STA 1182 IS BROKEN. INSTALLED NEW EMEGENCY EXIT SIGN PER B757 AMM 33-51. OPS CK GOOD. (7567077)SDR DALA2025090906656Skin · damagedLEFT WING UPPER SKIN PANEL SUPPORT BEAM AT LWSTA 177.5 REQUIRES INSTALL. REMOVAL AND DAMAGE EVALUATION DOCUMENTED ON ORNRC 184563.0500.0010. INSTALLED SERVICEABLE LEFT WING UPPER SKIN SUPPORT BEAM AT LEFT WING STA 177.5 IAW BOEING 757-200 SRM 51-40-02 PARAGRSDR DALA2025090906655Spar Cap · corrodedSEAM SEALANT AND THE L/E OF THE UPPER BONDED T/E PANEL ARE BULGED UP WITH CORROSION UNDER THEM, ON THE LEFT WING T/E UPPER SPAR CAP, FROM 2 TO 6 FEET OUT FROM THE FUSELAGE, IN THE EMERGENCY ESCAPE PATHWAY AREA. REPAIRED L/H WING UPPER SKIN BTW WSTA 160 TO WSSDR DXTA2025090904882Light Sys · unknownAS WE APPROACHED THE AIRCRAFT TO BEGIN PREFLIGHT WE NOTICED THE EXTERIOR EMER LIGHTS AT THE RIGHT WING ROOT WERE FLICKERING. UPON OPENING THE CABIN DOOR, ALL THE INRERIOR EMER LIGHTS WERE DISCOVERED IN THE SAME FLICKERING STATE OPS CHECKED EMERGENCY LIGHTING SDR DXTA2025090904884Handle · unknownDOOR HANDLE PHYSICALLY WILL NOT ROTATE TO CLOSED POSITION, EITHER FROM OUTSIDE OR INSIDE THE CABIN. FOUND DOOR TO OPEN AND CLOSE NORMAL. PERFORMED DOOR HEALTH CHECK PER CE680A AMM 52· 10-04, ALL CHECKS ARE NORMAL AND WITHIN LIMITS. NO FURTHER ACTION IS REQUSDR AALA202509091265Battery · dischargedAIRCRAFT WAS NOT GROUNDED: EMERGENCY FLASHLIGHT AT DIRECT VIEW JUMPSEAT NOT WORKING. MAINTENANCE REPLACED EMERGENCY FLASHLIGHT BATTERY AT DIRECT VIEW JUMPSEATIAW AMM 25-60-00.SDR ABXA20250908217Elec Connector · detachedDURING MAINTENANCE INSPECTION, FOUND FLIGHT DECK EMERGENCY EXIT SIGN LIGHT INOP. CLEANED AND REINSTALLED CONNECTOR FOR POWER SUPPLY. LIGHT OPS CHECKS GOOD IAW AMM 33-51-00. AIRCRAFT RETURNED TO SERVICE.SDR ABXA20250908216Elec Connector · detachedDURING MAINTENANCE INSPECTION, FOUND L1 DOOR EMERGENCY EXIT SIGN LIGHT INOP. CLEANED AND REINSTALLED CONNECTOR FOR POWER SUPPLY. LIGHT OPS CHECKS GOOD IAW AMM 31-51-00. AIRCRAFT RETURNED TO SERVICE.SDR YENA2025090900918Unknown · odorFLT#1904, RDU-SJU. FUMES EVENT ODOR REPORT SUBMITED DESCENDING THRU 10,700 FT, FLT CREW EXPERIENCED BURNING OF NOSE AND THROAT, CHEMICAL ODOR, PACK 1 ISOLATED, FUMES DISIPATED SLOWLY. REPEAT EVENT. OPENSDR SCNA20250909372Light · unsecurePHOTOLUMINESCENT LIGHT STRIP BY ROW 12 DEF SIDE RAISED UP DURING CRUISE CREATING TRIPPING HAZARD. CARPET ON FLOOR ALSO RAISED UP. GOES BACK DOWN ON GROUND REMOVED AND REPLACED ROW 12 DEF PHOTOLUMINESCENT STRIP AND ADHESIVE AND REPLACED CARPET RAPE REF AMM 33-5SDR SCNA20250909371Holder · looseL1 GIRT BAR HOLDER IS LOOSE. ADJUSTED GIRT BAR HOLDER L1 DOOR REF AMM 25-66-01. OK FOR SERVICE,SDR SCNA20250909370Light · unsecurePHOTOLUMINESCENT EMERGENCY ESCAPE PATH MARKING SYSTEM ROW 12DEF STICKING UP AND IS A TRIPPING HAZARD PHOTOLUMINESCENT EMERGANY ESCAPE STRIP REPOSITIONED PROPERLY-OK FOR SERVICE REF AMM 33-51-15SDR SCNA20250909369Fastener · missingINITIAL INSPECTION: MISING SOLID FASTENER ON RETEINER CLIP OF GIRT BAR ESCAPE SLIDE COVER OF DOOR R1. OPENSDR SCNA20250909368Light · no testDURING EMERGENCY LIGHTING SWITCH OPERATIONAL TEST EMERGENCY LIGHT CEILING AFT AND EMERGENCY LIGHT L1 EXT. AND INT. DON""T TURN ON. OPENSDR SCNA20250909367Window · arcedARCING ON UPPER LH CORNER OF L1 WINDSCREEN WITH SMALL BURN SPOT R&R L1 WINDOW PER AMM 56-11-11 LEAK CHECK AND OPS CHECK GOOD REMOVED COLLARS AND RESET BREAKERS ON P18-3 Q1,Q3,D1,D2,E2,E2 P6-3 A9,A10 P6-11 Q8,Q9SDR SCNA20250909366Ballast · failedLEFT WING #1 EMERGENCY EXIT LIGHT FAILED REPLACED BALLAST ASSY OPS OK USING REF AMM 25-21-20 AND REF AMM 33-21-00SDR DALA2025090906645Unknown · odorATB/DE - DUE TO ELECTRICAL BURNING SMELL IN THE AFT GALLEY AREA. INSPECTED COFFEE MACHINES, FLOOR HEATERS, C/B PANEL, AND APU AREA. NO FINDINGS. (7869168)SDR CALA2025090908667Battery · no testCABIN EMER LIGHTING OPS CHK FAIL REPLACE LT EPSU BATTERY REPLACED LT EPSU IAW 33-51-38-400-002-A OPS CHK PASSED.SDR CALA2025090908653Battery Pack · inoperativeFLT DECK DOME LIGHT FAILS TO ILLUMINATE WHEN EMERGENCY EXIT LIGHT SWITCH IN ON POSOTION. EMERGENCY LIGHTING SYSTEM OPS CHECK. REPLACED BATTERY PACK M1675 IAW AMM 33-51-06. CHECKS GOOD.SDR CALA2025090908652Floor Support · corrodedCORROSION AT AFT CARGO PIT FLOOR SUPPORT BS 1380 RBL 16 UNDER THE NUTPLATES. REMOVED CORROSION ON FLOOR SUPPORT IAW SRM 51-10-02; ORIGINAL THICKNESS 0.063", MATERIAL LOSS 0.050" MATERIAL REMAINING 0.013", FOUND OUT LIMITS IAW SRM 53-00-53-1A-1, INSTALLEDSDR CALA2025090908651Floorbeam · corrodedSEVERAL SPOTS WITH EVIDENCE OF SURFACE CORROSION AT FWD WET AREA FLOORBEAM TOP SURFACE STA 328 RBL 38 TO RBL 58. REMOVED DAMAGED TEE AND ACCOMPLISHED NEW TEE FABRICATION AT WET AREA FLOORBEAM IAW SRM 51-40-02-0G-0,SRM 53-10-51-2R-7 AND EC-RA 5321-01706.SDR CALA2025090908650Rib · crackedCRACK AT LEFT HORIZONTAL STABILIZER RIB STA 92.70 STIFFENER # 2 LOWER FLANGE. ACCOMPLISHED REPAIR AT LEFT HORIZONTAL STABILIZER RIB NR 1 LOWER FLANGE STIFFENER NR 2 HSS 92.7 IAW SRM 55-10-09-2R-5 & SRM 51-40-02-0G-0.SDR CALA2025090908649Lens · missingSEAT 39D EMERGENCY LIGHT LENS MISSING AND LIGHT INSIDE OF SEAT. REMOVED AND REPLACED PROXIMITY LIGHT AT SEAT 39D IAW AMM 33-51-06. OPS CHECK GOOD.SDR CALA2025090908648Housing · brokenROW 21 ABC EPL HOUSING MOUNTING TAB IS BROKEN. REMOVED AND REPLACED EPL HOUSING REF. IFM 25-22-59. PROXIMITY LIGHTS OPS CHECKED GOOD IAW 737 AMM 33-51-11.SDR CALA2025090908647Lens · brokenSEAT 52D EMERGENCY LIGHT LENS BROKEN. R & R 52D EMERGENCY LIGHT REF AMM 33-51-10. OPS CHECK GOOD. A/C OKAY FOR SERVICE AT THIS TIME.SDR DCGA202509100629Blade · dentedDURING A POST FLIGHT MAINTENANCE INSPECTION A SMALL DENT WAS DISCOVERED ON THE OUTBOARD FACE OF ONE OF THE AIRCRAFT TAIL ROTOR BLADES. PILOT REPORTED THERE WAS NO INDICATIONS OR NOISE OF ANYTHING STRIKING THE BLADE. THE BLADE DENT WAS FOUND TO BE WITHIN SERVICSDR C1CB2025090800628Warning Message · false activationAFTER DEPARTURE AND DURING THE CLIMB OUT, N284CP EXPERIENCED MULTIPLE AMBER MAINTENANCE MESSAGES THAT INCLUDED #1/2 RUDDER SYS INOP, AUTOPILOT INOP AND PITCH TRIM INOPERATIVE. THE CREW HELD ALTITUDE AT 16,000FT TO PERFORM THE STEPS IN THE QRH TO CLEAR THE MESSDR EE4Y2025090823081Window Frame · crackedDURING ACCOMPLISHMENT OF THE ALLEGIANT A32X-53-210-003-WINDSHIELD, UPPER FUSELAGE COCKPIT LH WINDSHIELD CENTER POST LOWER HORIZONTAL FLANGE OPEN FASTENER HOLE WITH CRACK DETECTED DURING ROTOTEST INSPECTION OF THE CONTINUITY FITTINGS REPLACE PROCEDURE AS PER AISDR EE4Y2025090823080Fitting · crackedDURING ACCOMPLISHMENT OF THE ALLEGIANT TASK A32X-53-210-003-WINDSHIELD, UPPER FUSELAGE COCKPIT WINDSHIELD CENTER POST LOWER ATTACHMENT ARE CONTINUITY FITTINGS LH AND RH WITH CRACK. THE BOTH FITTINGS WERE REPLACED FOLLOW THE ALLEGIANT ENGINEERING ORDER # A32X-SSDR EE4Y2025090823079Frame · crackedDURING ACCOMPLISHMENT OF THE ALLEGIANT TASK A32X-534123-01-2-001, UPPER FUSELAGE FR68 RH AT DOORSTOP 6 LEVEL FRAME INNER CAP JOINT TO GUSSET PLATE FASTENER HOLE WITH CRACK INDICATION DUE MISSED HOLE.PERFORMED GUSSET PLATE ATTACHMENT HOLES REPAIR AND GUSSET REPSDR SWAA2025090812512Channel · fodAFTER TAKE OFF ENCOUNTERED LOUD WIND NOISE FROM CAPTIANS L2 WINDOW. PRESSURIZED A/C ON GROUND REF AMM 21-31-00. NO FAULTS NOTED WHILE A/C WAS PRESSURIZED TO 4 PSI. SUSPECT L2 WINDOW TO NOT BE CLOSED AND LATCHED. ALSO FOUND DEBRI IN THE TOP GUIDE CHANNEL OF LSDR SWAA2025090812521Transceiver · smokeSHORTLY AFTER TAKEOFF; FAINT SMELL OF SMOKE WAS OBSERVED. IT WASN'T ELECTRICAL. AS WE ASSESSED IT; THE SMOKE DISSIPATED AND STOPPED. MOMENTS LATER VHF2 FAILED. REF TTG8Q01519BZ FOR CONDITIONAL INSPECTION.<[01] REMOVED AND REPLACED #2 VHF TRANSCEIVER AND OPS CHSDR AALA202509082078Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER UPPER ATTACH ANGLE LOCATED IN RIGHT HAND ECS BAY, AT AFT BULKHEAD, AT BS 663, FROM RBL 5 TO RBL 15. REPAIRED ANGLE PER SRM 57-10-10-2R-5.SDR AALA202509080517Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER UPPER ATTACH ANGLE LOCATED IN LEFT HAND ECS BAY, AT AFT BULKHEAD, AT BS 663, FROM LBL 5 TO LBL 15. REPAIRED ANGLE PER SRM 57-10-10-2R-5.SDR DALA2025090806624Skin · damagedTOOLING MARK AFT OF FRAME BETWEEN STR 3 AND 4 RT. REPAIRED PER ERA 627429-14 REV. ORIGINAL. (1187623)SDR AALA202509083906Battery · abnormalAIRCRAFT IN BASE MAINTENANCE: BAT/EPSU (10WL) FWD L FAULT DISPLAYED DURING SYSTEM TEST. REPLACED EMERGENCY POWER SUPPLY UNIT 10WL (AALA202509084615) AND BATTERY (AALA202509084615) PER AMM 33-51-38.SDR AALA202509084615Power Supply · abnormalAIRCRAFT IN BASE MAINTENANCE: BAT/EPSU (10WL) FWD L FAULT DISPLAYED DURING SYSTEM TEST. REPLACED EMERGENCY POWER SUPPLY UNIT 10WL (AALA202509084615) AND BATTERY (AALA202509084615) PER AMM 33-51-38.SDR AALA202509082931Pin · wornAIRCRAFT IN BASE MAINTENANCE: LEFT HAND MAIN LANDING GEAR UPPER TORQUE LINK PIN MEASURES OUT OF LIMITS. REPLACED UPPER TORQUE LINK PIN PER AMM 32-11-27.SDR FDEA202509081643Floor Panel · dentedMAIN CARGO, FLOOR PANEL 241MFF HAS DAMADE. REPAIRED FLOORPANEL #241MFF MPN# (145T5876-101) STA 930-980 LBL 11- LBL 33 IN REF TO B767 SRM 53-00-50-2R 4.B. SEE JPF FOR ALL WORK STEPS ACCOMPLISHED. INSTALLATION OF FLOOR PANEL 241MFF WILL BE ACCOMPLISHED ON WOSDR FDEA202509081642Floor Panel · dentedMAIN CARGO, FLOOR PANEL 241LFF HAS DAMADE REPAIRED FLOORPANEL #241LFF MPN# (145T5876-19) STA 930-984 LBL 11- RBL 11 IN REF TO B767 SRM 53-00-50-2R 4.B. SEE JPF FOR ALL WORK STEPS ACCOMPLISHED. INSTALLATION OF FLOOR PANEL 241LFF WILL BE ACCOMPLISHED ON WO#:SDR FDEA202509081641Floor Panel · dentedMAIN CARGO, FLOOR PANEL 241ZFF HAS DAMADE. REPAIRED FLOORPANEL #241ZFF MPN# (145T5876-111) STA 980-1114.82 LBL 54.75- LBL77.50 IN REF TO B767 SRM 53-00-50-2R 4.B. SEE JPF FOR ALL WORK STEPS ACCOMPLISHED. INSTALLATION OF FLOOR PANEL 241ZFF WILL BE ACCOMPLIS