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 AALA202507010603Life Vest · missingAIRCRAFT WAS NOT GROUNDED: MAINTENANCE FORWARD GALLEY FIRE COMPARTMENT BAG STORAGE CABINET SEAT LIFE VEST MISSING. INSTALLED LIFE VEST AS REQUIRED.SDR AALA202507014111Bottle · no testAIRCRAFT IN BASE MAINTENANCE: PASSENGER / CREW DOOR 841 DAMPER AND EMERGENCY OPERATION CYLINDER FAILED THE DAMPING FUNCTION TEST. REPLACED DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-11-14.SDR AALA202507012198Unknown · smokeAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT DIVERTED TO HNL DUE TO THE FLIGHT CREW REPORTING A SMELL OF SMOKE THROUGH THE CABIN. FLIGHT ATTENDANTS REPORTED THAT THE SMOKE WAS THROUGHOUT THE CABIN. THE AIRCRAFT LANDED SAFELY AT HNL AND TAXSDR FDEA202506301085Floor Panel · crackedMDC FLOOR PANEL 251LFF WITH PUNCTURES MDC FLOOR PANEL 251LFF WAS REPAIRED IAW B767 SRM 53-00-50-2R PAR 4-B FIG 201 SHEET 2 REV 92 APR 15,2025SDR FDEA202506301084Floor Panel · crackedMDC FLOOR PANEL 251PFF WITH CRACK MDC FLOOR PANEL 251PFF WAS REPAIRED IAW B767 SRM 53-00-50-2R PAR 4-B FIG 201 SHEET 2 REV 92 APR 15,2025SDR FDEA202506301083Floor Panel · crackedMDC FLOOR PANEL 252NFF WITH PUNCTURES MDC FLOOR PANEL 252NFF WAS REPAIRED IAW B767 SRM 53-00-50-2R PAR 4-B FIG 201 SHEET 2 REV 92 APR 15,2025SDR YENA2025070100668Unknown · odorFLT#1457, JFK-AUA. "ON DESCENT TO 10K FT ODOR BEGAN TO PRESENT IN COCKPIT AND CABIN BEGAN TO DISSAPATE THEN CAME BACK BELOW 5K FT AND PERSISTED AFTER LANDING AND ON GROUND.SDR CALA2025070106126Transceiver · faultedWX RADAR FAIL. CB RESET NO HELP. RADAR ON PANTS SMALL SLIVER A T 0100 CL OCK POS. VIDEO AVAILAB PERFORMED OPERATIONAL TEST OF WX RADAR REF MM 34-43-00-710-800-001. WX RADAR WOULD NOT TEST. INSPECTED WX RADAR TRANSCEIVER. FOUND COOLING FAN OUT OF THE MOUNTINGSDR CALA2025070106119Bottle · no discrepancy2L AND 2R EXIT DOOR SLIDE PRESSURES OUT OF GREEN BAND. UPON INSPECTION FOUND DOOR 2L AND 2R SLIDE PRESSURE GAUGE IS ONE NEEDLE WIDTH ABOVE GREEN BAND TO BE WITH IN LIMITS PER AMM 25-66-99SDR CALA2025070106118Skirt · unsecureEMERGECY SLIDE SKIRT HAS ABOUT 2 FEET EXTRA HANGING OUT ON DOOR 1R. SECURED ECSESS MATERIAL. SECURED ECSESS MATERIAL. ADD EMP:V948178SDR SIMA20250630001Door · no discrepancyFLIGHT ATTENDENT AND GATE AGENT ARE COMPLAINING THAT MAIN DOOR 1L IS VERY HEAVY AND HARD TO OPEN AND CLOSE OPENED AND CLOSED MAIN DOOR L1 IAW AMM SDS 52-11-00 OPS CHK GOOD NO DEFECTS NOTED AT THIS TIME.SDR 2025FA0000442Spring · cockedDURING ENGINE STRIP OF ESN 42605, THE MECHANICS NOTICED THAT ON FAN BLADE POSITION #18, THE SPRING CHOCKING (EIPC REF: 72-31-11-01-318) IS MISSING.SDR 2025FA0000440Dummy Rail · corrodedAIRCRAFT IS CURRENTLY IN SIAEC FOR ROUTINE MAINTENANCE. DURING ROUTINE INSPECTION PERFORMED FOR TASKCARD 330-531172-02-1, FALSE RAIL AT FR11-18, Y1456(LH) WAS FOUND WITH LEVEL 2 CORROSION.SDR KC1R20250630155Compressor · crackedAS RECEIVED, CIRCUMFERENTIAL CRACKING WAS NOTED AROUND THE OUTER DIAMETER OF THE 12TH STAGE, WITH INTERMITTENT PARENT MATERIAL CRACKS ALIGNED PARALLEL IN THE RADIUS ADJACENT TO KNIFE EDGE #12 360 DEGREES. ADDITIONALLY, MULTIPLE CRACKS WERE FOUND IN THE 10TH STSDR UOIA202506300001Spark Plug · faultedDURING CLIMB PILOT NOTICED LEFT ENGINE SOUNDED ROUGH AND DECIDED TO RETUN TO THE AIRPORT AS PRECAUTION. UPON EXAMINATION MAINTENANCE PERFORMED LEFT ENGINE COLD CHECK AND REPLACED CYLINDERS #1, #3, AND #5 TOP SPARK PLUGS AS PER LYCOMING OH MANUAL CHAPTER 4. PSDR UIEA2025062600815Web · crackedLEFT WING T/E CAVITY SUPPORT RIB WEB AT NR 5 SPOILER INBD LWR WBL 432.65 FOUND CRACKED. LT WING T/E CAVITY SUPPORT RIB WEB (P/N: 6565B10865-26) AT NR 5 SPOILER INBD LWR WBL 432.65 REPLACED IAW RI-57-70-17735 REV. A. NO FURTHER DEFECTS NOTED.SDR UIEA2025062200790Panel · corrodedAFT CARGO BAY TORQUE BOX PANEL BETWEEN STATION 1262 AND STATION 1285 RBL6 TO RBL 10 FOUND WITH SURFACE CORROSION. WEB REMOVED AND REPLACED AS PER B767-300BCF SRM 51-40-02 REV 52. NO FURTHER DEFECTS NOTED.SDR UIEA2025062200791Panel · corrodedAFT CARGO BAY TORQUE BOX PANEL AT STATION 1280 RBL 29 FOUND WITH SURFACE CORROSION. WEB REMOVED AND REPLACED AS PER SRM 51-40-02 REV 52. NO FURTHER DEFECTS NOTED.SDR UIEA2025062200792Shear Tie · corrodedFWD CARGO BAY SHEAR CLIP AT STATION 742 BETWEEN S35L AND S36L FOUND WITH SURFACE CORROSION. NEW SHEAR CLIP (P/N:140T2101Y21) AND SHEAR TIE (P/N:140T2102U243) INSTALLED AS PER SRM 51-40-02 REV 52. NO FURTHER DEFECTS NOTED.SDR UIEA2025062200793Shear Tie · corrodedFWD CARGO BAY- SHEAR CLIP AT STATION 742 BETWEEN S37R AND S38R FOUND WITH SURFACE CORROSION. NEW SHEAR CLIP (P/N:140T2102U252) INSTALLED AS PER SRM 51-40-02 REV52. NO FURTHER DEFECTS NOTED.SDR UIEA2025062300795Web · corrodedFWD CARGO COMPT WEB AT STATION 742 ABOVE S35L AND S36L FOUND WITH SURFACE CORROSION. REPAIR CARRIED OUT AS PER EN #3218-25. NO FURTHER DEFECTS NOTED.SDR UIEA2025062300796Web · corrodedFWD CARGO COMPT WEB AT STATION 742 ABOVE S36L FOUND WITH SURFACE CORROSION. REPAIR CARRIED OUT AS PER EN #3218-25. NO FURTHER DEFECTS NOTED.SDR UIEA2025062300797Skin · crackedDURING HFEC OPEN HOLE INSPECTION ON RH FWD ENTRY DOOR CUTOUT AFT LOWER CORNER. FOUND SECOND HOLE FROM BOTTOM WITH CRACK INDICATION AT 1 O'CLOCK POSITON VIEW LOOKING INBOARD. REPAIR CARRIED OUT IAW SRM 53-10-01 REPAIR 1 REV. 52. NO FURTHER DEFECTS NOTED.SDR UIEA2025062300798Skin · crackedDURING HFEC OPEN HOLE INSPECTION ON LT FWD ENTRY DOOR CUTOUT AFT LOWER CORNER FOUND SECOND HOLE FROM BOTTOM WITH CRACK INDICATION AT 10 O'CLOCK & 4 O'CLOCK POSITION VIEW LOOKING INBOARD. REPAIR CARRIED OUT IAW SRM 53-10-01 REPAIR 1 REV. 52. NO FURTHER DEFECTSSDR UIEA2025062400799Shear Tie · corrodedFWD CGO COMP'T - SHEAR CLIP AT STATION 742 S34L FOUND WITH SURFACE CORROSIONS AS MARKED. SHEAR CLIP (P/N: 140T2101Y21) AND SHEAR TIE (P/N: 140T2102U203) REMOVED AND REPLACED AS PER B767-300BCF SRM 51-40-02 REV 52. NO FUTHER DEFECTS NOTED.SDR UIEA2025062400800Shear Tie · corrodedFWD CGO COMP - SHEAR CLIP AT STATION 742 S37L FOUND WITH SURFACE CORROSIONS AS MARKED. SHEAR CLIP REMOVED AND REPLACED AS PER B767-300BCF SRM 51-40-02 REV 52. NO FURTHER DEFECTS NOTED.SDR IPXA2025063082821Bulb · inoperativeMAIN DECK CEILING EMERGENCY LIGHT 1EA BULB OUT AROUND L1 DOOR AREA. REPLACED BULB THEN OPERATION CHECKED OK PER AMM 33-51-07SDR IPXA2025063082924Light · detachedPASSENGER/CREW DOOR WARNING LIGHT ASSY HANGING OUT OF DOOR LINER. SECURED PASSENGER/CREW DOOR WARNING LIGHT HOUSING IAW AMM 52-73-11. OPS CHECK GOOD.SDR DALA2025063004844Duct · tornSHIP 3804 -DIV- DIVERTED TO RDU DUE TO RIGHT WING BODY OVERHEAT. UNABLE TO PROCEED DUE TO ICING ENROUTE. CORRECTIVE ACTION: IDENTIFIED FAULT CODE 64 (RIGHT WING LE AND AC PACK BAY) DURING BITE TEST. FOUND DUCT TORN BETWEEN RIGHT PACK HEAT EXCHANGERS. REPLACED SDR DALA2025063004843None · pax errorSHIP 3922 -SMK/DE- DUE TO SMOKE IN THE CABIN AT SEAT ROW 4D DURING TAXI. FIRE EXTINGUISHERS USED TO EXTINGUISH. CORRECTIVE ACTION: FOUND OVERHEATED PASSENGER VAPE PEN UNDER SEAT CUSHION. REFER TO LOG PAGE 1052096 FOR CORRECTIVE ACTION.SDR YENA2025063000660Radio · faultedFLT#841, JFK-DUB. (ETOPS) "UNABLE TO RECEIVE SELCAL AFTER MULTIPLE ATTEMPTS WITH NY RADIO AND GANDER OCEANIC. WE HAD TO MONITOR HF WHILE IN OCEANIC AIRSPACE ( SELCAL (AMU). TROUBLE SHOOT PER TSM 23-51-00-810-828-A, SELCAL OPS TEST OK AT THIS TIME, IAW AMM 2SDR AALA202506302198Unknown · smokeAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT DIVERTED TO HNL DUE TO THE FLIGHT CREW REPORTING A SMELL OF SMOKE THROUGH THE CABIN. FLIGHT ATTENDANTS REPORTED THAT THE SMOKE WAS THROUGHOUT THE CABIN. THE AIRCRAFT LANDED SAFELY AT HNL AND TAXSDR AALA202506300168Flashlight · no testAIRCRAFT WAS NOT GROUNDED: FORWARD FLIGHT ATTENDANT SEAT FLASH LIGHT INOPERATIVE, REPLACED FLASHLIGHT AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 25-65-99.SDR AALA202506304112Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L3 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR REXA2025063000702Hinge Fitting · chafedVERTICAL STABILIZER MID LOWER HINGE ASSY., LOWER HINGE HALF P/N AV670-21140-001 HAS AN EXCESSIVELY WORN BEARING LANDING. COMPLIED WITH MHIRJ REO 670-55-31-192 REV-- DATED 2025-06-20. INSTALLED NEW SERVICABLE LOWER HINGE P/N AV670-21081-013.SDR FDEA202506301082Stringer · corrodedBAY AFT OF FWD CARGO COMPT.- FUSELAGE STRINGER AT STGR44RH BETWEEN FR38.2 AND FR39 FOUND HEAVY CORROSION REPAIRED THE BAY OF FWD CARGO COMPT. CORRODED FUSELAGE STRINGER AT STGR44RH BETWEEN FR38.2 AND FR39 PER SRM 53-10-14-201 FIGURE 208 AND EA 6-5310-T038392SDR 29EA20250630154Light · no testBATTERY PACK FOR EMERGENCY LIGHTS L290,L291,L292 & L293 FAIL CAP TEST.SDR 2DYA20250630153Light · inoperativeR/H EMERGENCY EXIT & PAX EMERGENCY LIGHTS L996,L321,L121 & L776 INOP.SDR 2DYA20250630152Light · inoperative2 EACH EXTERNAL EMERGENCY LIGHTS NOT ILLUMINATINGSDR 2DYA202506300151Spar · corrodedCORROSION DAMAGE HAS BEEN FOUND ON THE REAR SPAR LOWER CHORD OF THE INBOARD TRAILING EDGE FLAP ON THE RH WING. THE DAMAGE HAS BEEN CUT OUT TO REMOVE THE DAMAGED SECTION OF THE 2024-T3511 EXTRUDED TEE AND REPLACED WITH AN EQUIVALENT 2024-T3 EXTRUSION. THE REPAISDR 2025FA0000683Torque Link · brokenNOSE GEAR UPPER TORQUE LINK BROKE CAUSING GEAR TO COLLAPSE UPON TOUCHDOWN.SDR SWIA2025090200629Frame · crackedDURING CLEANING FOUND FS 605.00 FRAME CRACKED AT APPROX STRINGER 18L. REMOVED AND REPLACED FRAME SECTOR ON FS605 FROM WL73 (LEFT HAND) - STR21L WITH REFERENCE TO SRM 53-61-15, SRM 51-42-06 AND REO 601R-53-61-8354 REV-- DATED 2025-07-04. COMPLETED TASK CARSDR SWAA2025081186632Bulkhead · crackedCRACK BULKHEAD PANEL 121EW AT FWD CARGO COMPARTMENT 2025-417078<[01] TOOL USED: CALIPER P/N: 500-197-30; S/N: B23304029; DUE DATE: 10- NOV-25.;[02] PREPARED REPAIR AREA AND APPLIED REPAIR PATCH ON BULKHEAD PANEL 121EW AT FWD CARGO COMPARTMENT IAW B737-700 AMM SDR SWAA2025081186544Stub Frame · crackedCRACK INDICATION ON STUB FRAME LOCATED BTW BS 294.5 TO BS 296 AND S-8R TO S-9R AT FWD GALLEY DOOR AREA. REPLACED STUB FRAME LOCATED BTW BS 294.5 TO BS 296 AND S-8R TO S-9R AT FWD GALLEY DOOR AREA IAW SRM 51-10-02 ITEM. 9 AND 51-40-02 AND DWG 141A8370 SHEET SDR SWAA2025081186543Gusset · crackedCRACKED GUSSET STA 500D AND STR 19R FWD CARGO COMPARTMENT. REPLACED GUSSET LOCATED ON STA 500D AND STR 19R FWD CARGO COMPARTMENT IAW B737 700 SRM 51-10-02-0G STEP 9; SRM 51-40-02-0G AND DWG 143A7902 SHEET REV -.SDR SWAA2025081186545Gusset · crackedCRACK GUSSET STA 500D STR 19L FWD CARGO COMPARTMENT. REPLACED GUSSET LOC. STA 500D STR 19L FWD CARGO COMPARTMENT IAW B737-700 SRM 51-10-02-0G STEP 9; SRM 51-40-02-0G-0 AND DWG 143A7902 SHEET 209 REV -.SDR SWIA2025081100629Fitting · looseDURING FFOD FOUND AFT SLIDE FLOOR FITTING OF THE MCD LOOSEN (FLIGHT 5422 - FILED CLOSED)REMOVED AND REPLACED AFT FLOOR FITTING SLIDE OF THE MCD REFERENCE TO ERJ175 AMM 53-10-21, GOOD FOR SERVICE AT THIS TIME.SDR AALA202508115023Gusset · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK ON GUSET LOC. BTW FR68 AND FR69 AT LVEL STRG 8 RH SIDE ON PASSEN GER CABIN, AFT GALLEY AREA L= 0.090 INCH. MAINTENANCE REPLACED GUSET LOC. BTW FR68 AND FR69 AT LVEL STRG 8 RH SIDE ON PASSENGER CABIN, AFT GALLEY AREA IAW A319SDR AALA202507210221Attach Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION UPPER FWD PYLON SLEEVE I/B SIDE WING ATTACH FITTIN ON RH PYLON. MEASURES ARE D= 0.003 INCH, W= 0.479 AND L= 0.794. MAINTENANCE REPLACED ATTACHED FITTING.SDR AALA202507212359Attach Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION UPPER FWD PYLON SLEEVE O/B SIDE WING ATACH FITTING ON RH PYLON. MEASURES ARE D=0.003 INCH, W= 0.479 INCH AND L= 0.794 INCH. MAINTENANCE REPLACED ATTACHED FITTING.