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 CALA2025121212049Lamp · inoperativeEMERGENCY LIGHTS - OPS CHECK EMERGENCY LIGHTS OPS CHECK - EXTERIOR AFT SLIDE LIGHT INOPERATIVE REMOVED AND REPLACED AFT SLIDE SLIDE/OVERWING LIGHT - LAMP. OPS CHECK GOOD. REF AMM 33-51-04-960-801.SDR 2025FA0000821Autothrottle Sys · disconnectedINNOVATIVE SOLUTIONS AND SUPPORT (IS&S) SA 00400BO AUTOMATIC THROTTLE ASSEMBLY (P/N 9B-89005-3). LINKAGE PUSHROD FOUND DETACHED AT CONNECTION WITH ASSEMBLY'S LINEAR ACTUATOR; LINKAGE FAILED AT ACTUATOR ATTACHMENT POINT. LOOSE FOD DROPPED INTO COMPARTMENT (FASTSDR DALA2025121109073Unknown · odorATB DUE TO ELECTRICAL ODOR IN THE FLIGHT DECK AND CABIN. RAN ENGINES, CHECKED ALL SEATS, CHECKED OVENS, COFFEE MAKERS, WATER HEATERS, GALLEY LIGHTING, GALLEY FLOOR HEAT, AND LAV CABINETS. NO TROUBLE FOUND. (7925005)SDR YENA2025121101197Unknown · odorFLT#83, JFK-FLL. UPON ARRIVAL INTO MCO, FA ADVISED ME THEY EXPERIENCED A DIRTY SOCK SMELL RIGHT BEFORE WE EXTENDED THE LANDING GEAR. ACCORDING TO THE NO.1 FA, THE SMELL GONE JUST BEFORE LANDING; PEFORMED LEVEL 1 DECONTAMINATION FOR APU ODOR EVENT INSPECTED APUSDR ABXA20251211326Fire Loop · warning messageDURING INSPECTION, RIGHT ENG FIRE LOOP 1 STATUS MESSAGE. DEFERRED R ENG FIRE LOOP 1 IAW MEL 26-11-1-1. MAINTENANCE PROCEDURES CW. PLACARD INSTALLED. AC REMAINS NO ETOPS. MBCB 12/21/25SDR DALA2025121109062Sensor · dirtyLEFT AFT ENTRY DOOR EICAS DISPLAYED DURING CLIMBOUT AS WELL. AS ENTRY DOOR DISCRETE LIGHT. QRH COMPLIED WITH. PRESSURIZATION NORMAL. CLEANED LT AFT DOOR SENSOR AND PERFORMED A SYS OPS CHKD IAW AMM 52-71. (7954490)SDR DALA2025121109061Cover · detachedEXIT SIGN AT 2R DOOR DETACHED AGAIN. INSTALLED EXIT SIGN PER B757 AMM 33-51. (8215276)SDR DALA2025121109057Lgciu · faultedDIVERTED TO ATL DUE TO L/G GEAR NOT UPLOCKED ECAM WARNING AND GEAR STILL DOWN. REPLACED LGCIU 1 AND 2. (LP 7694858, 1345469)SDR DALA2025121109052Bottle · low pressureL1 DOOR ASSIST BOTTLE LOW PRESSURE. SERVICED THE L1 DOOR ASSIST BOTTLE IAW AMM 52-15. (8049570)SDR DALA2025121109050Seat Track · corrodedCORROSION WAS FOUND BY R4 LAVATORY, SEAT TRACK -YC1. REPLACED THE SEAT TRACK IAW SRM 51-42-11. (1346321)SDR DALA2025121109049Seat Track · corrodedFORWARD OF R4 DOOR, FOUND CORROSION ON SEAT TRACK AFT OF FR 73 ON -YB (M)(P). REPLACED THE SEAT TRACK IAW SRM 51-42-11. (1346320)SDR CALA2025121112042Battery Pack · no testR4 DOOR EMERGENCY BATTERY PACK M33409 CAPACITY CHECK FAILED. THE BATTERY PACK M33409 WAS REPLACED AND TESTED CARRIED OUT WITH NORMAL RESULT IAW AMM 33-51-06.SDR CALA2025121112040Battery Pack · no testL2 DOOR EMERGENCY BATTERY PACK M33099 CAPACITY CHECK FAILED. THE BATTERY PACK M33099 WAS REPLACED AND TESTED NORMAL IAW AMM 33-51-06.SDR 2025FA0000819Attach Fitting · chafedFUSELAGE TO RT WING ATTACHMENT FITTING CHAFED.SDR 2025FA0000818Reverser Half · corrodedRH THRUST REVERSER UPPER DOOR SHOWS SIGNS OF CORROSION.SDR 2025FA0000817Reverser Half · corrodedRH THRUST REVERSER LOWER DOOR SHOWS SIGNS OF CORROSION.SDR 2025FA0000816Reverser Half · contaminatedLH THRUST REVERSER UPPER DOOR SHOWS SIGNS OF CORROSION.SDR 2025FA0000815Reverser Half · corrodedLH THRUST REVERSER LOWER DOOR SHOWS SIGNS OF CORROSION.SDR SWIA2025121075728Stringer · crackedSTRINGER 3L CRACKED AT THE AFT END OF THE PASSENGER DOOR UPPER LINTEL BS 379. REPLACED STRINGER 3L IAW SRM 51-42-06, AND DWG 601R31016, REV C.SDR SWIA2025121075164Angle · corrodedCORROSION PRESENT ON IMPACT ANGLE AT FWD WASTE WATER SERVICE DOOR INSIDE STRUCTURE BETWEEN FS379 - FS394 STR 23R (C-CHECK RO 02/01/2026)REMOVED AND INSTALLED NEW REPLACEMENT IMPACT ANGLE AT FWD WASTE WATER SERVICE DOOR INSIDE STRUCTURE BETWEEN FS379 - FS394 SSDR SWIA2025121075163Diaphragm · corrodedCORROSION PRESENT ON LOWER DIAPHRAGM AT FWD WASTE WATER SERVICE DOOR INSIDE STRUCTURE BETWEEN FS379 -FS394 STR 23R (C-CHECK RO 02/01/2026)REMOVED AND INSTALLED NEW LOWER DIAPHRAGM AT FWD WASTE WATER SERVICE DOOR INSIDE STRUCTURE BETWEEN FS379 -FS394 STR 23R SDR DALA2026020200784Angle · corrodedFWD CARGO LT TRANSITION ANGLE CORRODED BS 500L. REMOVED DAMAGED SECTION OF TRANSITION ANGLE, FABRICATED, LOCATED, AND INSTALLED THE REPAIR OF THETRANSITION ANGLE AND SPLICE BS 500K - 500L, LBL 50 IAW SRM 51-40-02, AND 53-00-53-2R .SDR HNAA2026012900098Support · crackedLEFT OMEGA BEAM INBD VERTICAL FLANGE CRACKED AT FR23. REPAIRED IAW ETD2025-145-93466 AND EO 1-53-26-0001.SDR HNAA2026012900097Support · crackedLEFT OMEGA BEAM INBD VERTICAL FLANGE CRACKED AROUND RIVET HEAD AT FR22. REPAIRED IAW ETD 2025-145-934066 AND EO1-53-26-0001.SDR HNAA2026012800088Floor Support · crackedLEFT OMEGA BEAM INBD VERTICAL FLANGE CRACKED AROUND RIVET AT FR 21. REPAIRED IAW ETD2025-145-934066 AND EO1-53-26-0001.SDR VNAA20260125010Floorbeam · corrodedCORROSION ON FLOORBEAM ANGLE BS 280, 9 LBL - 9 RBL IN THE COCKPIT. FLOORBEAM SUPPORT ANGLE BS 280 9 LBL - 9 RBL WAS REPLACED IAW SRM 51-42-06-001-001-A01, SRM 51-42-21-001-001-A01, AND SRM 51-42-13-001-001-A01.SDR HNAA2026012200068Housing · wornLEFT & RIGHT VERTICAL STABILIZER SPHERICAL BEARING HOUSINGS WORN. ENLARGED LT & RT VERTICAL STAB SPHERICAL BEARING HOUSINGS TO FIRST OVERSIZED (DIMENSION 58.00MM, PN 145-408881-001 (RE-WORK #1) IAW SRM 55-30-02 ND EO1-55-26-0030.SDR SWAA2026011451390Floor Support · crackedCRACKED INTERCOSTAL AT FWD WET AREA BS 284, BL 0, WL 208. THE INTERCOSTAL WAS FOUND TO BE OUT OF LIMITS IAW SRM 53-00-04-1A-1. REMOVED AND REPLACED THE INTERCOSTAL BS 277-294 BL 0 WL 208 IAW SRM 51-40-02-0G-0 AND DWG 141A5400 REV-.SDR SWAA2026011450905Floor Panel · pulledAFT FLOOR PANEL 242TF UPPER SKIN HAS AREAS OF PULLED STRANDS. 242TF FLOOR PANEL UPPER SKIN DAMAGE HAS BEEN REPAIRED IAW SRM 53-00-50-2R-1.SDR SWAA2026011450932Sidewall Support · corrodedCORROSION ON FLOOR TO SIDEWALL SUPPORT, BS 727B+10 - 787+7, LBL 21, WL 156. REMOVED AND REPLACED THE SIDEWALL SUPPORT BS 727 - 847 IAW SRM 51-40-02, DWG 146A7500, & 146A7502.SDR SWAA2026011451380Skin · damagedEXTERNAL GROUND POWER DOOR LOWER CUTOUT HAS A MISSING FASTENER. REPAIRED EXTERNAL POWER DOOR LOWER CUTOUT IAW SRM 53-10-15-2R-4, REPAIR 4.SDR SWAA2026011450934Shield · corrodedCORROSION ON AFT CARGO BAY CARGO DOOR CUT-OUT FWD SHIELD AT BS 767+19, RBL 22, WL 156. REMOVED AND REPLACED THE AFT CARGO BAY CARGO DOOR CUT OUT FWD SHIELD IAW SRM 51-40-02, DWG 146A0081, REV A.SDR SWAA2026011451163Stub Frame · crackedONE CRACK NOTED ON R1 DOOR STUB FRAME, BS 294.5+2, 0.1 INCH ABOVE SEAL DEPRESSOR, WL 267. L: 1 INCH. EVALUATED CRACK ON FSD STUB FRAME AND FOUND TO BE OUT OF ALLOWABLE LIMITS. THE DAMAGED FSD STUB FRAME WAS REMOVED AND INSTALLED NEW UPPER STUB FRAME IAW SRMSDR SWAA2026011451384Floor Support · crackedCRACKED FLOOR SUPPORT, FWD CABIN BS 390, BL 0, WL 208. THE INTERCOSTAL WAS FOUND TO BE OUT OF LIMITS IAW SRM 53-00-04-1A-1. REMOVED AND REPLACED UPPER SECTION IAW SRM 51-40-02-0G-0, AND DWG 143A5400, REV A.SDR SWAA2026011451392Floor Support · crackedCRACKED FLOOR SUPPORT, FWD CABIN BS 394, LBL 14, WL 208. REMOVED THE DAMAGED FLOOR SUPPORT UPPER SECTION AND INSTALLED A NEW FLOOR SUPPORT IAW SRM 51-40-02, AND DWG 143A5400, REV-.SDR SWAA2026011451393Floor Support · crackedCRACKED FLOOR SUPPORT, BS 391, RBL 9, WL 208. FOUND TO BE OUT LIMITS IAW SRM 53-00-04-1A-1. REMOVED AND REPLACED UPPER SECTION OF THE FLOOR SUPPORT, BS 380-400, RBL 39, WL 208 IAW SRM 51-40-02-0G-0, AND DWG 143A5400, REV A.SDR SWAA2026011451385Floor Support · crackedCRACKED FLOOR SUPPORT BS 354, BL 0, WL 208. THE FLOOR SUPPORT WAS FOUND TO BE OUT OF LIMITS IAW SRM 53-00-04-1A-1. REMOVED AND REPLACED IAW DWG 141A5400, REV-.SDR SWAA2026011451366Angle · crackedWHILE ACCESSING FOR VAPOR BARRIER FOUND ANGLE CRACKED BS 652 LBL 29 WL 144. REMOVED AND REPLACED THE VAPOR BARRIER ANGLE IAW SRM 51-40-02 & DWG 149A7210 REV -.SDR SWAA2026011350917Floorbeam · corrodedCORROSION ON FLOORBEAM BS 986, RBL 43, WL 208.1. REPAIRED THE FLOORBEAM IAW SRM 53-70-51-2R-6-A00995, REPAIR 6.SDR SWAA2026011350918Floorbeam · corrodedCORROSION ON BS 986 FLOORBEAM, LBL 43, WL 208.1. REPAIRED THE FLOORBEAM IAW SRM 53-70-51-2R-6-A00995, REPAIR 6.SDR SWAA2026011350897Floor Panel · pulledAFT FLOOR PANEL 241UF UPPER SKIN HAS AREAS OF PULLED STRANDS. AFT FLOOR PANEL 241UF WITH UPPER SKIN HAS AREAS OF PULLED STRANDS WAS REPLACED WITH A NEWLY FABRICATED FLOOR PANEL DUE TO AMOUNT OF ALL DAMAGE IAW SRM 53-00-50-2R-0, & DWG 146A5810.SDR SWAA2026011350898Floor Panel · pulledAFT FLOOR PANEL 241XF UPPER SKIN HAS AREAS OF PULLED STRANDS. AFT FLOOR PANEL 241XF WITH UPPER SKIN HAS AREAS OF PULLED STRANDS WAS REPAIRED IAW SRM 53-00-50-2R-1.SDR SWAA2026011350899Floor Panel · pulledAFT FLOOR PANEL 241YF UPPER SKIN HAS AREAS OF PULLED STRANDS. REPAIRED IAW SRM 53-00-50-2R-1-A00939, REPAIR 1.SDR SWAA2026011350907Floor Panel · pulledAFT FLOOR PANEL 242VF UPPER SKIN HAS AREAS OF PULLED STRANDS. AFT 242VF FLOOR PANEL UPPER SKIN DAMAGE WAS REPAIRED IAW SRM 53-00-50-2R-1.SDR SWAA2026011350915Floor Panel · pulledFLOOR PANEL 231JF UPPER SKIN HAS AREAS OF PULLED STRANDS. REMOVED AND FABRICATED A NEW FLOOR PANEL IAW SRM 53-00-50-2R-0-A00938.SDR SWAA2026011350920Floor Panel · pulledFLOOR PANEL 231XF UPPER SKIN HAS AREAS OF PULLED STRANDS. THE FLOOR PANEL 231XF WAS REPLACED WITH A NEWLY FABRICATED FLOOR PANEL DUE TO AMOUNT OF ALL DAMAGE IAW SRM 53-00-50-2R-0, & DWG 144A5810.SDR SWAA2026011350921Floor Panel · pulledFLOOR PANEL 241BF UPPER SKIN HAS AREAS OF PULLED STRANDS. R & R THE FLOOR PANEL IAW SRM 53-00-50-2R-0-A00938.SDR SWAA2026011350922Floor Panel · pulledFLOOR PANEL 241DF UPPER SKIN HAS AREAS OF PULLED STRANDS. R & R IAW SRM 53-00-50-2R-0-A00938.SDR SWAA2026011350924Floor Panel · pulledAFT FLOOR PANEL 241ADF UPPER SKIN HAS AREAS OF PULLED STRANDS. THE AFT FLOOR PANEL 241ADF WAS REPAIRED IAW SRM 53-00-50-2R-1.SDR SWAA2026011350933Sidewall Support · corrodedCORROSION ON FLOOR TO SIDEWALL SUPPORT FROM BS 727C+13 - 747+16, RBL 21, WL 156. R & R FLOOR SIDEWALL SUPPORT AT BS 727+4.04 - 767, RBL 21, WL 156 IAW SRM 51-40-02-0G-0 AND DWG 146A7500 SHEET 113 REV -.