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 YENA2025120201160Door Frame · crackedDURING HEAVY MAINTENANCE: CRACK INDICATION ON FRAME 16 AT FWD GALLEY AREA (1 E/A) (CRACK INDICATION FOUND OPEN HOLE B FR16 LH DOUBLE JOGGLE AREA) PERFORMED PERMANENT REPAIR ON PRIMARY STRUCTURE AT HOLE B FR16 LH DOUBLE JOGGLE AREA IAW SRM 53-11-12-300-012.SDR YENA2025120201159Support · corrodedDURING HEAVY MAINTENANCE: CORROSION LOWER SILL LOC. STR23L AND FR68 AT AFT GALLEY AREA. PERFORMED PERMANENT REPAIR ON LOWER SILL LOC. STR23L AND FR68 AT AFT GALLEY AREA IAW SRM A320 53-41-14-300-001 THIS REPAIR IS CATEGORY A AND FURTHER INSPECTION.
;SDR YENA2025120201158Skin · no discrepancyDURING HEAVY MAINTENANCE: CORROSION UPPER SURFACE OF TOP SKIN LOC. REAR SPAR BTW RIB18 AND RIB19 ON LH WING; EVALUATED REWORK AREA ON UPPER SURFACE OF TOP SKIN REAR SPAR BTW RIB18 AND RIB19 ON LH WING AND FOUND WITHIN LIMITS IAW SRM 57-21-11-283-007.SDR YENA2025120201157Door Frame · crackedDURING HEAVY MAINTENANCE: CRACK INDICATION FOUND ON FR 16 LT SIDE DOOR STOP 7 LOWER OUTBOARD HOLE AT 12 OCLOCK, CRACK LENGTH 0.078 INCH APROX; PERFORMED PERMANENT REPAIR OUTBOARD HOLE ON FR 16 LH SIDE DOOR STOP 7 LOWER IAW SRM 53-11-12-300-010 AND DWG D531354SDR YENA2025120201156Window Frame · crackedDURING HEAVY MAINTENANCE: CRACK INDICATION ON WINDSHIELD IN COCKPIT (1 EA) (CRACK INDICATION FOU ND CONTINUITY FITTING WINDSHIELD RH SIDE.. CRACK DIRECTION VERTICAL. CRACK LENGTH 0.200 INCH.); PERFORMED REPAIR TO CRACKS AFFECTING THE WINDSHIELD FRAMING CENTERSDR YENA2025120201155Window Frame · crackedDURING HEAVY MAINTENANCE: CRACK INDICATION FOUND ON WINDSHIELD CENTER POST, LOWER ATTACHMENT ARE A, INBOARD LOWER RADIUS LH SIDE, CRACK LONGITUDINAL DIRECTION, LENGTH= 0.120 INCHES APPROX; PERFORMED REPAIR TO CRACKS AFFECTING THE WINDSHIELD FRAMING CENTER POSTSDR YENA2025120201154Skin · dentedDURING HEAVY MAINTENANCE: SEVERAL DENTS ON ACCESS PANEL 341BB LEADING EDGE ON RH HORIZONTAL STABILIZER; EVALUATED DENTS ON ACCESS PANEL 341BB LEADING EDGE ON RH HORIZONTAL STABILIZER AND FOUND WITHIN ALLOWABLE DAMAGE LIMITS AS PER A320 SRM 55-12-11-283-003 PASDR YENA2025120201153Shear Plate · crackedDURING HEAVY MAINTENANCE: CRACK SHEAR PLATE STR 23R FR 69-FR 70; R & R SHEAR PLATE STR 23R FR 69-FR 70 IAW A320 SRM 51-72-11, SRM 51-42-11 & DWG D53474180.SDR YENA2025120201152Shear Plate · crackedDURING HEAVY MAINTENANCE: CRACK SHEAR PLATE STR 23L FR69-FR70; R& R SHEAR PLATE STR 23L FR 69-FR 70 IAW A320 SRM 51-72-11, 51-42-11 & DWG D53474180.SDR DALA2025120208789Light · damagedAIRCRAFT 3411, DURING PDC INTERIOR CK. FOUND 2L DOOR AFT EMER. ESCAPE PATH FLOOD LIGHT DAMAGED. CORRECTIVE ACTION: REPLACED EMER. ESCAPE PATH FLOOD LIGHT REF. A330 IPC 33-51. OPS CKS GOOD. (LP 7971768)SDR YENA2025120201151Fitting · crackedDURING HEAVY MAINTENANCE: NOSE FWD FUSELAGE RACK 10VU LUGS SEVERAL FINDINGS WITH CRACKED OR BROKEN FITTINGS.SDR SIMA20251130001Engine · vibrationENG 1 LP VIBRATION REOCCURRING THROUGHOUT FLIGHT IN EXCESS OF 10 SECS, MAX REACHED 5.1 OCCURRED AT ALTITUDE AND IN DESCENT INTO PHX, COMPLIED WITH PROCEDURES AND VIBRATIONS DID NOT GO AWAY EMERGENCY DECLARED. SPOKE WITH PILOTS. PILOTS DECLARED AN EMERGENCY COMSDR YENA2025120201150Floorbeam · crackedDURING HEAVY MAINTENANCE: CENTER BOX FR36 FLOORBEAM CRACKED.SDR YENA2025120201149Window Post · crackedDURING HEAVY MAINTENANCE: NOSE FWD FUSELAGE WINDSHIELD FRAME, CENTER POST LOWER NODE AREA CONTINUITY FITTING RT & LT SIDE CRACKED.SDR YENA2025120201148Pressure Panel · crackedDURING HEAVY MAINTENANCE: CENTER FUSELAGE, FR 36 LT SIDE PRESSURE PANEL, HOLES #6, 7, 15 & 20 / CRACKED.SDR YENA2025120201147Pressure Blkhd · crackedDURING HEAVY MAINTENANCE: FUSELAGE CENTER FUSELAGE, FR35 & STGR 30L PRESSURE BULKHEAD ATTACHMENT HOLES CRACKEDSDR YENA2025120201146Stringer · corrodedDURING HEAVY MAINTENANCE: CORROSION STRINGER 43L LOC, BTW FR. 56 TO FR. 57 ON FLOOR SURFACE IN AFT CARGO COMPARTMENT REMOVED AND REPLACED STRINGER LOC.BTW FR54 TO FR60 STRG 43L ON AFT CARGO COMPARTMENT I.A.W A320 SRM 51-42-11, A320 SRM 51-72-11 AND DWG E534703SDR YENA2025120201145Stringer · corrodedDURING HEAVY MAINTENANCE: CORROSION STRINGER 42L LOC. BTW FR. 54 TO FR. 58 ON FLOOR SURFACE I N AFT CARGO COMPARTMENT. PERFORMED PERMANENT REPAIR STRINGER 42L LOC. BTW FR. 54 TO FR. 58 ON FLOOR SURFACE IN AFT CARGO COMPARTMENT I.A.W. A320 SRM 53-00-13-300-00SDR DALA2025120208782Elec Connector · damagedROW 24DEF WHITE EMERGENCY LIGHT INOPERATIVE. FOUND FEMALE PINS PUSHED BACK AT CONNECTOR, EVEN THOUGH CONNECTOR ITSELF WAS SECURE. SECURED BOTH PINS AND LOCKED INTO ELEC CONNECTOR. NOW LIGHTS OPS CHKD GOOD.SDR DALA2025120208780Power Supply · defectiveDURING SVC CHK FOUND EMERGENCY LIGHTS BETWEEN 28-32 INOPERATIVE. TROUBLESHOT IAW FIM 33-50-00-810-801. FOUND POWER SUPPLY DEFECTIVE. R & R THE POWER SUPPLY IAW AMM 33-51. OPS CHKD GOOD.SDR DALA2025120208787Battery Pack · inoperativeAFT GALLEY RT EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED AFT GALLEY BATTERY PACK M1672 IAW AMM 33-51. OPS CHECKED GOOD.SDR YENA2025120201144Dummy Rail · corrodedDURING HEAVY MAINTENANCE: CORROSION RAIL DUMMY Y503.2 LOC. BTW FR12 AND FR16 FWD GALLEY AREA, REPLACED RAIL DUMMY Y503.2 LOC. BTW FR12 AND FR16 FWD GALLEY AREA IAW A320 SRM 51-42-11, SRM 51-72-11-911-001 AND DWG D53112826, D53112056SDR YENA2025120201143Seat Track · corrodedDURING HEAVY MAINTENANCE: CORROSION FLOOR BEAM -Y464 LOC. BTW FR64 ANF FR68 AT AFT GALLEY AREA. REPLACED FLOOR BEAM -Y464 LOC. BTW FR64 AND FR68 AT AFT GALLEY AREA IAW A320 SRM 51-72-11 AND DWG D53472816.SDR YENA2025120201142Seat Track · corrodedDURING HEAVY MAINTENANCE: CORROSION FLOOR BEAM +Y765 LOC. BTW FR12 AND FR24 AT FWD GALLEY AREA. REPLACED FLOOR BEAM Y765, LOC. BTW FR 12 TO FR24 FWD GALLEY AREA IAW A320 SRM 51-72-11 AND DWG D53112812 DWG D53110097 DWG D53110984 DWG D53110920,SDR YENA2025120201141Seat Track · corrodedDURING HEAVY MAINTENANCE: CORROSION FLOOR BEAM -Y765 LOC. BTW FR12 AND FR24 AT FWD GALLEY AREA. REPLACED FLOOR BEAM -Y765 LOC. BTW FR12 AND FR24 AT FWD GALLEY AREA IAW A320 SRM 51-72-11, DWG D53112812, DWG D533110984 DWG D53110876,SDR YENA2025120201140Seat Track · corrodedDURING HEAVY MAINTENANCE: CORROSION FLOOR BEAM +Y1292 LOC. BTW FR12 AND FR24 AT FWD GALLEY AREA. REPLACED FLOOR BEAM Y1292 LOC. BTW FR12 TO FR24 FWD GALLEY AREA IAW A320 SRM 51-72-11 AND DWG D53112812 DWG D53110097 DWG D53110984 DWG D53110920,SDR YENA2025120201139Seat Track · corrodedDURING HEAVY MAINTENANCE: CORROSION FLOOR BEAM -Y1292 LOC. BTW FR12 AND FR24 AT FWD GALLEY AREA. REPLACED FLOOR BEAM -Y1292 LOC. BTW FR12 AND FR24 AT FWD GALLEY AREA I.A.W SRM 51-72-11 AND DWG D53112812, D53112639, D53110876,SDR CALA2025120211686Battery Pack · dischargedBATERRY PACK M2503 FAIL DURING EMERGENCY LIGHTING SYSTEM FUNCTIONAL CHECK. REMOVED AND INSTALLED NEW BATTERY PACK (M2503). OPS CHECK GOOD IAW AMM 33-51-06-906-805.SDR CALA2025120211684Battery Pack · dischargedEMERGENCY BATTERY PACK M1675 WAS INOPERATIVE. REMOVED AND INSTALLED EMERGENCY BATTERY PACK M1675 IAW AMM 33-51-06-960-805. OPS CHECK GOOD.SDR CALA2025120211682Light · brokenEMERGENCY LIGHT AT SEAT 28 C BROKEN REMOVED AND REPLACED EMERGENCY SEAT LIGHT AT 28C. OPS CHECK GOOD. IAW CMM 25-29-54.SDR 2025FA0000792Rudder Pedal · obstructedFIRST OFFICER’S RUDDER PEDALS STIFF AND REQUIRE EXTRA FORCE. IAW AMM 27-21-05-214-033. RUDDER PEDALS OPERATED THROUGH FULL TRAVEL RANGE, NO OBVIOUS STIFFNESS NOTED. PEDALS MOVED FREELY THROUGH THEIR FULL RANGE WITH RUDDER OPERATING CORRECTLY WITH THE POSITIOSDR DALA2025120208778Filter · odorAIRCRAFT FILLED WITH SMOKE AS REVERSER STOWED AND UPON EXITING RUNWAY. NO BURNING SMELL OBSERVED AND SMOKE DISPLAYED UPON SHUTDOWN. INSPECTED ENGINES. FOUND EXCESSIVE DIRT RESIDUE ON BLOCKER DOORS AND IN INLET. RUNWAYS AND TAXIWAY HAVE HEAVY SAND RESIDUE AND SDR SWAA2025120141009Battery · inoperativeAFT GALLEY MEGAPHONE INOPERATIVE. REPLACED THE AFT MEGAPHONE BATTERIES IAW AMM 25-64-00. OPS TESTED NORMAL ACFT OK FOR SERVICE.SDR SWAA2025120141084Unknown · odorLIGHT ELECTRICAL ODOR DETECTED IN THE AFT GALLEY, FIRST OFFIER SIDE. GASPER VENT IN AFT GALLEY SEEMED TO HAVE AN ODOR. NO ISSUES OR ODORS DETECTED NEAR COFFEE POT. EARLY ONSET ODOR SEEMED RUBBER IN NATURE. USED FIM 21-00 TASK 806, AS A GUIDE FOR T/S, INSPECSDR SWIA2025120111301Warning Message · illuminatedAPU OIL TEMP CAUTION AT CRUISE. (FLIGHT 5116)SDR AALA202512016671Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: FRONT JUMPSEAT FLASHLIGHT INOPERATIVE. REMOVED AND REPLACED FRONT JUMPSEAT FLASHLIGHT BATTERY. PER AMM25-64-00.SDR AALA202512019372Megaphone · no testAIRCRAFT WAS NOT GROUNDED: AFT MEGAPHONE WEAK AND HAS RATTLE INSIDE. REMOVED AND REPLACED AFT MEGAPHONE. PER AMM 25-64-00.SDR AALA202512011254Sliding Window · bindingAIRCRAFT WAS GROUNDED: FIRST OFFICER SLIDING WINDOW WILL NOT LOCK OPEN OR OPEN COMPLETELY DUE TO CIRCULAR OBSTRUCTION STUCK IN LOWER WINDOW TRACK. FOUND DITCHING LATCH MECHANISM OUT OF SEQUENCE. RESET DITCHING LATCH AND OPERATIONAL CHECKED GOOD. PER AMM 56-12-SDR AALA202512019597Light · unsecureAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHTS IN ROW 14 ABC ARE POPPING OUT. RESECURED EMERGENCY LIGHT ASSEMBLY AT ROW 14ABC. PER AMM 33-51-03.SDR AALA202512017620Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR DIFFICULT TO OPEN. ADJUSTED LAVATORY DOOR. PER AMM 25-40-14.SDR AALA202512016024Girt Bar · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD SERVICE DOOR GIRT BAR CLAMP ON RIGHT SIDE OF DOOR VERY DIFFICULT TO REMOVE GIRT BAR AND READJUSTED GIRT BAR RETAINER AS REQUIRED.SDR AALA202512011284Life Vest · missingAIRCRAFT WAS NOT GROUNDED: FLIGHT CREW REST SEAT LIFE JACKET MISSING. REPLACED CREWREST LIFE JACKET. PER AMM 25-62-00.SDR AALA202512016020Light · inoperativeAIRCRAFT IN BASE MAINTENANCE: 3D AFT EMERGENCY LIGHT ON OUTER SHELL INOPERATIVE. REMOVED AND REPLACED AFT FLOOR PROXIMITY LIGHT AT SEAT 3D. PER AMM 33-51-05.SDR AALA202512019510Light · inoperativeAIRCRAFT IN BASE MAINTENANCE: 5D SEAT EMERGENCY LIGHT ON OUTER SHELL INOPERATIVE. REMOVED AND REPLACED AFT GROUND PROXIMITY LIGHT AT SEAT 5D. PER AMM 33-51-05.SDR AALA202512019147Light · inoperativeAIRCRAFT IN BASE MAINTENANCE: 4D SEAT EMERGENCY LIGHT ON OUTER SHELL INOPERATIVE. REMOVED AND REPLACED FORWARD GROUND PROXMIT LIGHT AT SEAT 4D. PER AMM 33-51-05.SDR DALA2025120108771Oxygen Mask · unwanted deployPASSENGER OXYGEN PANEL MASK DEPLOYED. REPACKED PASSENGER OXYGEN PANEL PER A320 FAM AMM 35-21. (1327920).SDR DALA2025120108761Web · corrodedCORROSION WEB LOCATED BETWEEN FR20 AND STR23L FWD GALLEY AREA. REPLACED WEB LOC. BETWEEN FR20 TO FR24 AND AT LEVEL STR 23L FWD GALLEY AREA AS PER A319 SRM 51-72-11. (1328745).SDR DALA2025120108760Beam · corrodedPASSENGER AFT UTILITY AREA BEAM WITH CORROSION AT FR65+540MM, -Y=320. REPLACED INTERCOSTAL IAW A319 SRM TASK 51-72- 11-911-001. (1328624).SDR UIEA2025113001331Valve · faultedBLEED 4 CAUTION MSG ON CLIMB OUT. MSG 36229. REPLACED NR 4 PRVC AND CHECKED NORMAL PER AMM 36-11-20/401 & IPC 36-11-19-01</P>)SDR CALA2025113011590Lamp · inoperativeUPON SERVICE2 INSPECTION FOUND L2 DOOR OVERHEAD EMERGENCY LIGHTS INOP RELAMPED EMERGENCY LIGHT NO HELP, SUPECT BATTERY PACK M&E 75-3351-3-00041 2013-LA REFERENCE LOGPAGE 7124123 FOR R AND R OF EMERGENCY LIGHT POWER SUPPLY, OPS CHECK GOOD PER AMM 33-51-07.