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 AALA202509267260Door Latch · looseAIRCRAFT WAS NOT GROUNDED, FLIGHT DECK DOOR DOES NOT OPEN AT ALTITUDE UNLESS YOU HOLD THE ELECTRONIC UNLOCK SWITCH TO THE OPEN ON PEDESTAL. MAINTENANCE FOUND FLIGHT DECK DOOR UPPER LATCH WAS LOOSE AND REPLACED IT PER AMM 52-51-21. A SATISFACTORY OPERATIONAL CSDR AALA202509266436Brake Sys · contaminatedAIRCRAFT WAS GROUNDED: BRAKES ON LEFT MAIN GEAR GRAB AGGRESSIVELY WHEN USED AND HEAT UPCONSIDERABLY MORE AFTER LANDING IN EXCESS OF 300 DEGREES FROM THE RIGHT SIDE. MAINTENANCE OPENED BRAKE BLEED VALVES FOR #3 AND #4 BRAKES. FOUND EXCESSIVE FOAMING. BLEED AIR SDR DALA2025092607003Engine · fireREJECTED TAKEOFF AT 100 KNOTS DUE TO RIGHT ENGINE FIRE. REPLACED NUMBER 2 ENGINE PER DELTA WORK CARD 7100-9901-02. OK FOR SERVICE.SDR CALA2025092609311Fairing · inflt separationLEFT ENGINE FORWARD THUMBNAIL FAIRING MISSING UPON ARRIVAL. NO OBVIOUS DAMAGE NOTED. REF AMM TASK 05-51-59-202-001 PART DEPARTS THE AIRPLANE INSPECTION.SDR CALA2025092609310Elec Jack · dirtyLOUD STATIC OVER HEADSET, CLEANED INTERPHONE JACK WITH APPLICABLE CLEANER, OPS CHECK NORMAL, NO STATIC FROM HEADSETS GOOD TO CONTINUE.SDR CALA2025092609309Transmitter · faultedLEFT ENGINE AT ZERO OIL QTY AT TAKEOFF. REMOVED AND REPLACED NR 1 ENG OIL QUANTITY TRANSMITTER IAW AMM 79-31-01. PERFORMED IDLE RUN ON BOTH ENGINES. OPS CHECKED GOOD, OIL QUANTITY DISPLAYS AS NORMAL.SDR CALA2025092609301Skin · crackedFOUND CRACK ON RT WING LEADING EDGE FASTENER HOLES NO 9 AND NO 1 0 PER EA 5720-02922 REV A. PERFORMED PERMANENT REPAIR ON RT WING LEADING EDGE IAW EC/RA 574 1-01667 AND EO 250352 REV IRSDR CALA2025092609300Seal Depressor · crackedFOUND A CRACK FWD CABIN R1 DOOR FUSELAGE CUTOUT FWD JAMB SEAL DEPRESSOR AT UPPER END. REMOVED AND REPLACED SEAL DEPRESSOR IAW SRM 51-40-02-0G-0, AND DWG 141A8370.SDR CALA2025092609299Stub Frame · crackedCRACK FOUND AT INTERIOR OF FWD GALLEY DOOR STUB FRAME ABOVE SEAL DEPRESSOR, DOOR CUT OUT AREA. REMOVED AND REPLACED THE STUB FRAME IAW SRM 51-40-02-0G-0 AND DWG 141A8370.SDR CALA2025092609298Skin Panel · gougedGOUGES FOUND ON EXTERIOR SKIN BETWEEN BS 727G AND 727H OTBD OF STRINGER 1. REPAIRED IAW EC/RA 5331-03181.SDR CALA2025092609297Crease Beam · corrodedMAIN CABIN AFT WET AREA CREASE BEAM LBL 60 HAS CORROSION BETWEEN BS 947 & 993. ORIGINAL DAMAGE ON INNER CHORD FOUND TO BE OUT OF LIMITS IAW SRM 53-70-15-1A-1. REMOVED AND REPLACED INNER CHORD IAW SRM 51-40-02, DWG 147A8540, REV B, & DWG 147A8501, REV C.SDR CALA2025092609296Floorbeam · corrodedMAIN CABIN FLOORBEAM AT STA 987 RBL45 CORRODED AT GIRT BAR FITTING HOLE. CORROSION LEVEL. 2 - OUT OF LIMITS ON PRIMARY STRUCTURE. REPAIRED BS 987 FLOORBEAM AT RBL 45 IAW SRM 53-70-51-2R-6.SDR CALA2025092609295Floorbeam · corrodedCORROSION AT CABIN FLOORBEAM STA 947, RBL 28. REPAIR ACCOMPLISHED ON THE MAIN CABIN FLOORBEAM STA 947 IAW EC/RA 5370-01198 & SRM 53-70-51-2R-5.SDR CALA2025092609294Hmu · failedLEFT ENGINE DID NOT PRODUCE TAKE OFF POWER. MAX THRUST REQUESTED L 97-98 MAX WHEN 101. AIR RETURN, REMOVED AND REPLACED HMU ASSEMBLY ON NR 1 ENGINE IAW AMM 73-11-01-400-801. LEAK CHECKED GOODSDR CALA2025092609283Slide · frayedL2 DOOR EMERGENCY SLIDE, FWD END OF GIRT BAR HOLDER IS FRAYED. REMOVED AND REPLACED L2 DOOR SLIDE IAW AMM 25-66-01-000-801, 25-66-01-000-802, 25-66-01-400-802, 25-66-01-400-801.SDR CALA2025092609282Slide · no discrepancyR1 DOOR SLIDE MATERIAL HANGING AND RUBBING FLOOR, FOUND SKIRT WITHIN LIMITS IAW BULLETIN 24MEB084, OK TO CONTINUE AMM 25-66-01.SDR CALA2025092609281Girt Bar · dirtyL1 DOOR FLOOR AFT RELEASE CATCH FOR GIRT BAR IS JAMMED. CHECKED CONDITION OF GIRT BAR FITTINGS, CLEANED GIRT BAR FITTINGS, NO DEFECTS NOTED IAW AMM 52-11-00. OK FOR SERVICE.SDR MASA2025092400078Module · inoperativeBLEED 2 FAIL IN FLIGHT. R & R AMS CONTROLLER DRIVE MODULES SBDA 2 SLOT 20 SLOT 223.SDR AALA202509255968Power Supply · faultedAIRCRAFT IN BASE MAINTENANCE: RIGHT EMERGENCY EXIT ESPU FAULTING. MAINTENANCE REPLACED RH EMER ESPU IAW AMM 33-51-38.SDR AALA202509259104Light · inoperativeAIRCRAFT WAS NOT GROUNDED: FOUND EMERGENCY PATH LIGHT AT SEAT 26D INOP. MAINTENANCE REPLACED INOP EMERGENCY LIGHT AT SEAT 26D IAW CMM 25-23-40.SDR AALA202509258675Power Supply · faultedAIRCRAFT IN BASE MAINTENANCE: RH EMERGENCY ESPU FAULTED. MAINTENANCE REPLACED RH EMER ESPU IAW AMM 33-51-38.SDR ASAA2025092461099Lens · brokenROW 17F EMERGENCY EXIT LIGHT LENS FELL OFF. GROUNDED - YES. FOUND LIGHT LENS BROKEN. INSTALLED NEW LIGHT LENS AS REQUIRED.SDR SWAA2025092517849Nut · brokenAFT FO SIDE SERVICE DOOR GRIP HANDLE BROKEN<[01] R/R AFT SERVICE DOOR ASSIST HANDLE NUT REF. AMM 52-41-31.SDR GTIA2025092539094Unknown · odorFA'S REPORT DIRTY SOCK SMELL DURING DECENT, WENT AWAY ON GROUND , L3-R3 SMELL STILL THERE. DESCRIPTION OF ODOR/FUMES: PERSISTENT, DIRTY SOCKS SMELL. APPARENT CABIN SOURCE: CABIN AIR SUPPLY VENTS. AFT CABIN,GALLEY, LAV & MID CABIN. NO VISIBLE SMOKE OR HAZE. NOSDR GTIA2025092539093A/C Pack · odorDIRTY SOCK FUME SMELL IN COCKPIT ON TAKEOFF THRU 10000FT PACK 1 ISOLATED, SMELL DISSIPPATED-REF LP 3510221-2 AND 3510225-1 FOR RESOLUTION. NO DEFECTS NOTED, A/C IS OK FOR CONT SVC.SDR GTIA2025092539092Epsu · inoperativeEPSU (13WL) AND EPSU (12WL) FAILED THE EPSU BITE TEST-REMOVED AND REPLACED EPSU BATTERY FOR POSITION 13WL AND 12WL IAW AMM 33-51-38. OPS CHECK GOOD.SDR GTIA2025092539091Epsu · inoperative( EPSU BATTERY ) MULTIPLE EMERGENCY EXIT SIGNS NOT ILLUMINATE WHEN ON BATTERIES POWER. -R/R FRONT ( 10WL ) AND MID LEFT ( 11WL ) EPSU BATTERIES IAW AMM 33-51-00. ALL OPS CHECKS NORMAL.SDR AALA202509255664Elec Connector · not seatedAIRCRAFT WAS NOT GROUNDED: AFT LEFT FUEL PUMP LOW PRESSURE LIGHT DID NOT ILLUMINATE. CLEANED AND RESEATED CONNECTOR ON BOOST PUMP. PER AMM 28-22-41.SDR AALA202509257658Hinge · wornAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR IS DIFFICULT TO OPEN AND CLOSE. FOUND THAT LAVATORY-D DOOR HINGE TO BE WORN, TRIED TO ADJUST THE DOOR UP. NO HELP. DOOR DRAGS ON THRESHOLD. (OPEN).SDR DALA2025092506999Lanyard · unsecureR1 GIRT BAR LANYARD HANGING FROM BOTTOM OF DOOR. STOWED R1 DOOR MOORING LINE. REF B757 AMM 25-66. (7549862)SDR DALA2025092506998Floor Support · corrodedIN REFERENCE TO NRC 00327: CORROSION ON LOWER CHORD BS 720-740 AND LBL 64 OF FLOOR STRUCTURE AT CPAX. CORROSION LEVEL 2. LOWER CHORD BS 720-740 AND LBL 64 OF FLOOR STRUCTURE AT CPAX WAS REPLACED PER SRM 51-40-02-0G PAR. 4 B AND PAR. 7 D. (1215862)SDR DALA2025092506997Floor Support · corrodedCORROSION ON LOWER CHORD BTW STA 731-735 AND RBL 64 ON FLOOR STRUCTURE AT CPAX. CORROSION LEVEL 2. LOWER CHORD BTW BS 731 -735 AND RBL 64 ON FLOOR STRUCTURE AT CPAX WAS REPLACED PER B757 -300 SRM 51-40-02-0G PAR. 4 B AND PAR. 7 D. (1215855)SDR DALA2025092506996Floorbeam · corrodedCORROSION ON FITTING BS 684 BTW RBL 46 AT FLOOR STRUCTURE W2. CORROSION LEVEL 2-FITTING ON BS 684 BTW RBL 46 AT FLOOR STRUCTURE W2 WAS REPLACED PER SRM 51-40-02 -0-G PAR. 7. (1215695)SDR AALA202509252319Bezel · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY ESCAPE PATH LIGHT BEZEL FELL OFF ROW 20ABC. CONFIRMED ON SEAT 20C EMERGENCY ESCAPE PATH LIGHT INOPERATIVE. (OPEN).SDR AALA202509258788Sign · dislodgedAIRCRAFT WAS NOT GROUNDED: OVERHEAD EXIT SIGN BY WING EMERGENCY EXIT ROWS FELL DOWN. REINSTALLED EXIT LIGHT SIGN FOR OVERHEAD AISLE EXIT MARKERS LIGHT. PER AMM 33-51-02.SDR AALA202509250175Light · intermittentAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT ROW LIGHT IS FLICKERING AT ROW17ABC. RESET EMERGENCY EXIT ROW 17ABC. PER AMM 33-50-00.SDR IPXA2025092526197Rail · gougedCREW DOOR CUT-OUT, FWD AND AFT FRAMES, FOUR ROLLER RAILS HAVE GOUGES.SDR IPXA2025092500858Skin · damagedCREW DOOR, EXTERNAL SURFACE, ALONG OF THE FWD EDGE HAS BARE METAL.SDR FDEA202509241798Skin · dentedDENT ON SLAT WEDGE UPPER SKIN LOCATED AT 42'' FROM INBOARD EDGE AND 5.5'' FROM AFT EDGE SLAT 1 DENT ON SLAT 1 T/E WEDGE UPPER SKIN LOCATED AT 42'' FROM INB EDGE AND 5.5'' FROM AFT EDGE OF SLAT, WAS REPAIRED IAW B767 SRM 57-43-02-2R REPAIR 1 FIG 201 SHEET SDR FDEA202509241797Floor Panel · crackedPUNCTURE ON FLOOR PANEL 251EFF. MDC AREA FLOOR PANEL 251EFF MDC AREA WAS REPAIRED IAW SRM 53-00-50-2R PAR 4B FIG 201, SHEET 2, REV 92, APR 15/25.SDR FDEA202509241796Floor Panel · crackedPUNCTURE ON FLOOR PANEL 241DFF ON MDC FLOOR PANEL 241DFF ON MDC WAS REPAIRED IAW B767 SRM 53-00-50-2R PAR 4B FIG 201, SHEET 2, REV 92 APR 15/25.SDR FDEA202509241795Floor Panel · crackedPUNCTURE ON FLOOR PANEL 251XFF. MDC AREA FLOOR PANEL 251XFF MDC AREA WAS REPAIRED IAW B767 SRM 53-00-50-2R PAR 4B FIG 201 SHEET 2 REV 92 APR 15/2025SDR DALA2025092506993Rib · damagedDAMAGE FOUND TO LH OUTBOARD FLAP, RIB 1 SKIN, ADJACENT TO FLAP INTERCONNECT STRUT. REPAIRED PER ER/A 629324-14. (1215919)SDR DALA2025092506992Rib · damagedDAMAGE FOUND TO RT OUTBOARD FLAP, RIB 1 SKIN, ADJACENT TO FLAP INTERCONNECT STRUT. REPAIRED PER 629325-14. (1215916)SDR DALA2025092506991Fitting · misinstalledAVIONICS RACK LT LOWER FITTING SUPPORT HAS ONE FASTENER NOT TIGHT AND MAIN FITTING BOLT NOT INSTALLED PROPERLY. COMPLIED WITH ER/A 629286- 14AD. (1215886).SDR DALA2025092506990Fitting · damagedAVIONICS RACK RT LOWER FITTING HAS ELONGATED HOLE INBD LUG. COMPLIED WITH ER/A 629286- 14AD. (1215875).SDR DALA2025092506994Stringer · dentedDENT FOUND AT FRAME 11, STRINGER 24L. COMPLIED WITH ER/A 629178- 14. (1215908).SDR DALA2025092506989Ground Stud · damagedMIDDLE CEILING EXIT LIGHT INOP RIGHT HAND OVERWING EXIT LIGHT INOP AFT CEILING EXIT LIGHT STUCK ON. ISOLATED TO LOOS GND STUDS AT 6703VN, 6602VN,66001VN AND 6541VN. RE-SECURED ALL REF A319 ESPM CH 20 AND WDM 33-51-02. (7744624).SDR DALA2025092506988Panel · crackedNR 1 ENGINE PYLON PANEL 411AL DAMAGED/CRACKED. R & R PANEL 411AL PER A319 IPC 54-52-12. (1216080)SDR DALA2025092506987Door Frame · crackedCRACK FOUND ON FASTENER HOLE AT THE DOUBLE JOGGLE AREA OF THE FR16RH AROUND THE PASSENGER SERVICE DOOR. COMPLIED WITH ER/A 628458-14AD. (1215573).