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 AALA202507232760Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: F/A JUMPSEAT DOOR 1L FLASHLIGHT BATTERY SHOWS RED. MAINTENANCE REPLACED FLASHLIGHT BATTERY AT F/A JUMPSEAT 1L IAW AMM 25-64-00.SDR AALA202507235675Megaphone · inoperativeAIRCRAFT WAS NOT GROUNDED: WHILE PROFORMING J/C 26C00025003 NOTICE MEGAPHONE INOP. MAINTENANCE REPLACED MEGAPHONE IAW AMM 25-65-51.SDR AALA202507239362Elec Connector · looseAIRCRAFT WAS NOT GROUNDED: SEAT MOUNTED EMERGENCY LIGHT INOP AT SEAT 19ABC. MAINTENANCE FOUND CONNECTOR LOOSE AT SEAT 19ABC RESECURED IAW AMM 33-51-19.SDR AALA202507235495Elec Connector · looseAIRCRAFT WAS NOT GROUNDED: SEAT MOUNTED EMERGENCY LIGHT INOP AT SEAT 18ABC. MAINTENANCE FOUND CONNECTOR LOOSE AT 18ABC. RECONNECTED AND SECURED CONNECTOR IAW AMM 33-51-19.SDR IXXA20250722033Guard · failedEMERGENCY EXIT LIGHT OVERHEAD SWITCH GUARD WILL NOT ARM LIGHTS WHEN CLOSED. REMOVED AND REPLACED SWITCH GUARD IN ACCORDANCE WITH B767 MAINTENANCE MANUAL 33-51-00. OPERATIONAL CHECK GOOD.SDR YENA2025072300751Uplock · failedFLT#488, MCO-ORH. (AIRCRAFT DIVERSION TO BOS) "ON GA AFTER PREVIOUS MDG NOSE LG WOULD NOT RETRACT. RECYCLED GEAR PER EICAM + GEAR RETRACTED; PER TSM 32-31-00 REMOVED AND REPLACED NLG UPLOCK ASSY IAW AMM 32-31-21. OPERATIONAL CHECK AND LEAK CHECK REQUIRED.)SDR IXXA20250722032Slide · low pressureMAINTENANCE FOUND R3 EMERGENCY SLIDE PRESSURE GAUGE BELOW SERVICABLE LIMITS. REMOVED AND REPLACED R3 EMERGENCY SLIDE IN ACCORDANCE WITH BOEING 757 MAINTENANCE MANUAL 25-66-03.SDR DALA2025072305531Power Supply · faultedAIRCRAFT 5034, WHEN TESTING EMERGENCY LIGHTS MULTIPLE INTERIOR AISLE LIGHTS INOP (ESCAPE PATH LIGHTING). REPLACED EPSU (17WL) AND BATTERY PACK. ALL LIGHTS TEST GOOD (ESCAPE PATH). (LP 7341335)SDR DALA2025072305529Skin · damagedSHIP 3307 AFT CARGO DOOR CUT OUT EDGE HAS DAMAGE ON FR 65. CORRECTIVE ACTION: BLENDED AND PAINTED AND DISPATCHED PER A330 SRM 53-41-11-283-001 DAMAGE WITHIN LIMITS. (5973393)SDR DALA2025072305526Frame · damagedSHIP 3416 FRAME 62 AFT SIDE BETWEEN 3R AND 4R FRAME HAS TOOLING DAMAGE. CORRECTIVE ACTION: REPLACED FRAME PER A330 SRM 53-11. (1099254)SDR SIMA20250722002Battery · inoperativeAFT UPPER EXIT LOCATOR EMERGENCY LIGHT IS INOPERATIVE. R & R NR 3 EMERGENCY LIGHT BATTERY IAW AMM 33-50-01 OPS CHECK GOODSDR SIMA20250722001Mau · failedAVNX MAU FAIL 2A FAIL, FMS 1 FAIL EICAS MESSAGES IN CRUISE. EMERGENCY DECLARED. REMOVED AND REPLACED MAU 2 POWER SUPPLY 2 IAW AMM CH 31-41-02 OPS CHECK GOOD..SDR YENA2025072300748Anti-Ice Valve · failedFLT#1675, FLL-KIN. AIRCRAFT PERFORMED AN AIR TURN-BACK TO FLL. LEFT WING ANTI ICE FAIL EICAS WHEN CONDUCTING TEST ABOVE 10K FEET. AIR RETURN FLL. DID NOT LAND OVER WEIGHT; REMOVED AND REPLACED WING ANTI-ICE VALVE IAW AMP J30-12-01 LEAK AND OPS OK REQUIRES FUSDR YENA2025072300747Apu · odorFLT#608, LAS-FLL. DIRTY SOCK SMELL ALL PHASES OF FLIGHT. SMELL DISSIPATED WHEN PACK 1 WAS TURNED OFF; COMPLIED WITH INFORMATION NOTICE 2017-T015, SECTION B2. IDENTIFIED ODOR SOURCE AS APU, DECONTAMINATION LEVEL B WAS ACCOMPLISHED PER TSM 05-50-00-810-831-A. OSDR HNAA2025072300472Start Valve · faultedDURING CLIMB AT ABOUT 3K BLEED 2 LEAK MESAGE ON EICAS, C/W QRH, MESSAGE CLEARED FACT 22JUL25 10:51 CLT RRD GROUND AIR START CONNNECTION ASSY IAW AMM 36-10-02. LEAK CHECK GOOD OK FOR SERVICESDR FDEA202507221293Socket · loosePARKING BRAKE DISCRETE LIGHT DOES NOT ILLUMINATE WHEN PARKING BRAKE SET FOUND PARKING BRAKE LIGHT BASE ASSY LOOSE, TIGHTEN BASE. LIGHT OPS CKED GOOD. A/C OK FOR SERVICE.SDR FDEA202507221292Floor Panel · crackedPUNCTURES ON ACCESS PANEL 221EFF SECTION 41 OF MDC FLOOR PANEL 221EFF MDC SECTION 41 WAS REPAIRED IAW B767 SRM 53-00-50-2R PAR 4.B FIG 201 SHEET 2 REV 92 APR 15/2025SDR UIEA2025072200998Bottle · low pressureL1 DOOR PRESSURE GAUGE IN THE RED, NOT GREEN. REMOVED AND REPLACED L1 DOOR EMERGENCY SLIDE IAW AMM 25-66-01. NO DEFECTS NOTED. THIS CLEARS MDDR 234685 PER MEL 52-11-01-02. PLACARDS REMOVED.SDR DXTA2025072304334Handle · bindingMAIN CABIN DOOR HANDLE REQUIRES EXCESSIVE FORCE TO OPEN OR CLOSE DOOR FROM INSIDE CABIN. INSPECTED AND NOTED TWO DOOR PINS ADJUSTED TO TIGHT AND BINDING IN THE ECCENTRIC HOLES CLOSE DOOR FROM INSIDE CABIN. ON DOOR FRAME. PERFORMED LATCH PLATE ADJUSTMENT TO THESDR DALA2025072205520Panel · delaminatedSHIP 3119 LEFT HORIZONTAL STAB UPPER PANEL 334BT DELAMINATED/SEPERATED. CORRECTIVE ACTION: R/R'D PANEL 334BT ON LEFT HORIZONTAL STAB IAW A319 AMM 55-10. (7455080).SDR JR2R20250722727Cam · wornFWD CARGO DOOR, VENT BOX, FWD AND AFT CAMS WORN. REPAIRSDR DALA2025072205511Frame · damagedSHIP 3415, FRONT SIDE OF 6 AT STRINGER 2L TOOLING DAMAGE ON FITTING. REPAIRED PER ERA 627461-14 REV. ORIG. (1098651)SDR DALA2025072205509Frame · damagedSHIP 3415, FRAME 63, FWD SIDE BETWEEN 1 AND 2 RT O/B U CHANNEL BRACKET NOTED WITH TOOLING DAMAGE ON INBD FACE. REPAIRED PER ERA 627461-14 REV ORIG. (1098669)SDR DALA2025072205508Stringer · damagedSHIP 3415, FRONT SIDE OF 6 AT STRINGER 1L TOOLING DAMAGE ON VERTICAL SUPPORT. REPAIRED PER ERA 627461-14 REV. ORIG. (1098646)SDR DALA2025072205507Stringer · damagedSHIP 3416, STRINGER STIFFENER HAS TOOLING DAMAGE AT 2 FASTENERS ON BACKSIDE OF FRAME 61 BETWEEN STRINGERS JUST IB OF DUCT SUPPORT. REPAIRED PER ERA 627461-14 REV ORIG. (1099132)SDR DALA2025072205505Frame · damagedSHIP 3415, FRAME 63 DAMAGED. CORRECTIVE ACTION: REPLACED PER A330 SRM 53-11. (1098691)SDR IPXA2025072252379Arming Lever · faultedUNABLE TO ARM DOOR. DMP C/W.SDR AALA202507221609Battery · no testAIRCRAFT WAS NOT GROUNDED: FAULT MESSAGE DISPLAYS FOR EMERGENCY POWER SUPPLY UNIT 10WL DURING SYSTEM TEST. REPLACED BATTERY FOR EMERGENCY POWER SUPPLY UNIT 10WL AND ACCOMPLISHED A SATISFACTORY OPERATIONAL TEST PER AMM 33-51-38 WITH NO FAULTS NOTED.SDR AALA202507228862Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: RIGHT HAND FORWARD PASSENGER / CREW DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR FDEA202507221291Indicator · no testON POST FLIGHT, THE R1 DOOR RAFT PUSH LIGHT WAS POPPED OUT. LIGHT WOULD NOT TEST. REMOVED AND REPLACED R1 SLIDE REMOTE PRESSURE INDICATOR ASSY IAW AMM 25-61-04-4.SDR FDEA202507221290Channel · crackedRIGHT WING FIXED UPPER TRAILING EDGE PANEL, UNDER SIDE "U" CHANNEL STIFFENER ALONG THE TRAILING EDGE OF THE PANEL, AROUND WING STATION 1034, IS CRACKED REMOVED AND REPLACED DAMAGED BEAM REF BOEING DWR: 113T1913 AND B767 SRM 51-40-02SDR FDEA202507221289Smoke Warning · activatedMAIN DECK CARGO SMOKE ECAM PASSING 32K LEVELED OFF COMPLIED WITH ECAM. ATB DESCENDING THROUGH 20K RECALLED ECAM ALL RED ECAM CLEARED CONTINUED MEM NORMAL APP LANDING FIRE RESCUE CONFIRMED NO SMOKE. EMERGENCY DECLARED. REMOVED AND REPLACED SMOKE DETECTISDR FDEA202507221288Seat Track · chafedAGING AIRCRAFT - EXISTING REPAIR AT MAIN DECK CARGO COMPARTMENT FLOOR SEAT TRACK BETWEEN STATION 745 TO STATION 801 X = 8.5 LEFT HAND SIDE EXISTING REPAIR AT MAIN DECK CARGO COMPARTMENT FLOOR SEAT TRACK BETWEEN STATION 745 TO STATION 801 X = 8.5 LEFT HAND SDR FDEA202507221287Seat Track · chafedEXISTING REPAIR AT MAIN DECK CARGO COMPARTMENT FLOOR SEAT TRACK BETWEEN STATION 745 TO STATION 856 X = -8.5 RIGHT HAND SIDE. EXISTING REPAIR AT MAIN DECK CARGO COMPARTMENT FLOOR SEAT TRACK BETWEEN STATION 745 TO STATION 856 X = -8.5 RIGHT HAND SIDE EVALUATSDR CALA2025072206832Lamp · inoperativeEMERGENCY LIGHTS OPERATIONAL CHECK EMERGENCY LIGHTS OPERATIONAL CHECK - LEFT AFT OVERWING EMERGENCY EXIT DOOR EXTERIOR LIGHT INOP. RE-LAMPED REF MM 33-51-04-960-801. OPS CK OK.SDR SWIA2025072175119Rivet · damagedRT OTBD FLAP HAS SMOKING RIVETS ON TOP SIDE OF FLAP SKIN FROM APPOX. WS.200.00 TO WS.210.00 (MARKED). (C-CHECK RO 02/01/2026)REMOVED AND REPLACED FASTENERS (7 EA) ON RH OB FLAP TOP SIDE SKIN FROM APPOX. WS.200.00 TO WS.210.00. IAW REO 690-57-53-186 REV -- DASDR 2025FA0000832Engine · failedENGINE FAILURE IN CLIMBSDR SWI2025F01809Intercostal · corrodedPAX DOOR INTERCOSTAL DD6 CORRODED BETWEEN BS 320 AND 338. REPLACED PAX DOOR INTERCOSTAL IAW SRM 51-40-11-001-001-A01, AND 51-42-06-001-001-A01, REV 38.SDR SWI2025F01808Intercostal · corrodedPAX DOOR INTERCOSTAL DD5 CORRODED BETWEEN BS 311.75 AND 320. INSTALLED NEW SERVICEABLE FWD DD5 IAW SRM 51-42-06-001-001-A01, REV 38 AND REO 670-52-11-1492, REV -.SDR SWI2025F01807Former · corrodedPAX DOOR AFT FORMER AT FS347.27 CORRODED BETWEEN DD4 AND DD7. REPLACED PAX DOOR AFT FORMER AT BS 347.27 IAW SRM 51-42-06-001-001-A01, 51-42-21-001-001-A01, AND 51-42-13-001-001-A01 REV 38.SDR SWI2025F01806Former · corrodedPAX DOOR FWD FORMER BS 311.75 BETWEEN DD4 AND DD7 CORRODED. REMOVED AND REPLACED PAX DOOR FWD FORMER IAW SRM 51-42-06-001-001-A01, AND 51-42-21-001-001-A01, REV 38.SDR SWIA202512090721Stringer · corrodedEVIDENCE OF CORROSION FOUND ON STRINGER 20R BETWEEN BS 280 AND 295. INSTALLED STRINGER 20R FROM BS 280 TO 319 IAW SRM 51-42-06-001-001-A01, & SRM 51-42-21-001-001-A01, REV 38.SDR JJBA20251024083Floor Support · corrodedRH FLOOR SILL BETWEEN FR 22 AND 23 CORRODED AROUND FWD NUTPLATE. REMOVED AND REPLACED RH FLOORSILL BETWEEN FR 22 AND 23.SDR AALA202510158861Skin Panel · wornAIRCRAFT IN BASE MAINTENANCE: WEAR ON SLAT 1 TRAILING EDGE AT LEVEL SLAT 2 TRACK 2 LOWER SURFACE RIGHT HAND WING MEASURE L= 3.628 IN, W= 0.347. MAINTENANCE PERFORMED PERMANENT REPAIR ON SLAT 1 TRAILING EDGE AT LEVEL SLAT TRACK 2 LOWER SURFACE RH WING IAW EA 36SDR VNAA20251015014Support · corrodedCORROSION ON SILL BETWEEN FS1000 / FS1088 AND STGR17R. CORROSION ON SILL BETWEEN FS1000 / FS1031 AND FS1051 / FS1088 STGR17R WAS REMOVED PER CRJ-900 SRM 51-21-06-001-001-A01 AND EVALUATED WITHIN LIMITS PER CRJ-900 SRM 53-00-45-201-001-A01. AND SILL BETWEEN SDR VNAA20251015002Rib · crackedCRACK ON LEADING-EDGE RIB SS58.41 WAS FOUND AT LH WING. CRACK ON LEADING-EDGE RIB SS58.41 WAS FOUND AT LH WING WAS REPAIRED PER REO 690-57-41-240 REV - -SDR VNA2025F00034Fitting · corrodedCORROSION ON SILL PASSENGER DOOR, CORROSION ON ANGLE KICKPLATE BETWEEN FS319/FS349 AND MID CAP CORROSION ON AFT LOWER FITTING FLOOR BEAN FS349.SDR VNA2025F00033Seat Track · corrodedCORROSION ON SEAT RAILS LBL 9 BTW FS349 TO FS485(1E/A), FS485 TO FS581(1E/A), FS581 TO FS661+32(1E/A) FS661+32 TO FS677(1E/A), FS677 TO FS847+16(2E/A) AND FS847+16 TO FS985(1E/A)SDR VNA2025F00032Seat Track · corrodedCORROSION ON SEAT RAILS LBL 9 BTW FS349 TO FS485(1E/A), FS485 TO FS581(1E/A), FS581 TO FS661+32(1E/A) FS661+32 TO FS677(1E/A), FS677 TO FS847+16(2E/A) AND FS847+16 TO FS985(1E/A) SEAT RAILS LBL 9 BTW FS349 TO FS485(1E/A), FS485 TO FS581(1E/A), FS581 TO FS661SDR VNA2025F00031Seat Track · corrodedDISCREPANCY: CORROSION ON RH SIDE SEAT RAILS STGR15 BTW FS379 TO FS485(1E/A), FS485 TO FS581(1E/A), FS581 TO FS661+16(1E/A), FS661+16 TO FS677(1E/A), FS677 TO FS720(1E/A), FS744 TO FS761(1E/A), FS785 TO FS847(1E/A) AND FS847+32 TO FS913(1E/A). RH SIDE SEAT RA