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 IPXA2025110593698Stringer · crackedSTRINGER CRACK, FWD SIDE OF STA 2360 AT S-11L. ACCOMPLISHED REPAIR I.A.W UPS EO-95769-REQ1 REV.1 AND EGAT EI NO.F2025A53M-2498 REV.2.SDR IPXA2025103198494Floor Panel · damagedUPPER MAIN CARGO FLOOR PANEL 232KH DELAMINATED AND BROKEN . FLOOR PANEL 232KH FAB COMPLETED IAW SREO-16407-REQ002 ((APPX C).SDR IPXA2025103195901Floor Panel · damagedUPPER MAIN CARGO FLOOR PANEL 222EG DAMAGED AND DELAMINATED. FLOOR PANEL 222EG FAB COMPLETED IAW SREO-16407-REQ002 ((APPX C).SDR IPXA2025103198283Floor Panel · damagedUPPER MAIN CARGO FLOOR PANEL 231KH DAMAGED AND BROKEN . FLOOR PANEL 231KH FAB COMPLETED IAW SREO-16407-REQ002 ((APPX C) CARGO COMPARTMENT FLOOR PANEL FABRICATION (SREO)).SDR IPXA2025103195609Floor Panel · brokenUPPER MAIN CARGO FLOOR PANEL # 222DG BROKEN . 89-1589. LOORBOARD PANEL 222DG FAB COMPLETED IAW SREO-16407-REQ002 ,APPX C A300 FWD/AFT LOWER CARGO COMPARTMENT FLOOR PANEL FABRICATION.SDR IPXA2025110293878Stringer · crackedSTRINGER CRACK, FWD SIDE OF STA 2360 AT S-2L (LEVEL 2).ACCOMPLISHED REPAIR I.A.W UPS EO-95632-REQ1 REV.1 AND SRM 53-60-03-2R-8 TR: 53-157 AND EGAT WORK SHEET NO.50777 AND EGAT EI NO. F2025A53M-2580 REV.0SDR IPXA2025110295147Stringer · crackedSTRINGER CRACK, FWD SIDE OF STA 2360 AT S-1R (LEVEL 2). (REPAIR). ACCOMPLISHED REPAIR I.A.W UPS EO-95630-REQ1 REV.1 AND SRM 53-60-03-2R-8 TR: 53-157 AND EGAT WORK SHEET NO.50782 AND EI NO. F2025A53M-2579 REV.0SDR SCNA20251031420Hydraulic Line · rupturedAFTER 10000, MASTER CAUTION LOW PRESSURE ENGINE 1 LIGHT A HYDRAULIC QTY 0. FOUND HYD PRESSURE TUBE ASSY BURST IN CEILING OF WHEEL WELL. INSTALLED TEMPORARY FLEXIBLE TUBING REF GMM 840-020. ACCOMPLISHED LEAK CHECK & SERVICED L HYD SYSTEM - NO LEAKS NOTED - REFSDR SWAA2025103124954Fitting · crackedCRACKED FITTING, BS 727B, RBL 24.75, FLOOR STRUCTURE. REPLACED THE FITTING IAW SRM 51-40-02-0G-0 AND DWG 146A5502 SHEET 9 REV A.SDR AALA202510305231Fuel Sys · malfunctionedAIRCRAFT WAS NOT GROUNDED: AFTER TAKEOFF RECEIVED FUEL IMBALANCE OF 1200 LBS. DIFFERENCE NOTED. COMPLIED WITH CONDITIONAL INSPECTION OF FUEL IMBALANCE EXCEEDADANCE. COULD NOT DUBLICATE FUEL IMBALANCE ON GROUND. FUELED AIRCRAFT AND NO FUEL INBALANCE NOTED. PERSDR AALA202510303697Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER ELEVATOR #4 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202510301878Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER ELEVATOR #5 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202510305157Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER ELEVATOR #2 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202510308428Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER ELEVATOR #6 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR IPXA2025103093293Stringer · crackedSTRINGER 6L CRACKED, FWD SIDE OF BS 2360. ACCOMPLISHED REPAIR I.A.W UPS EO-95688-REQ1 REV.2 AND SRM 53-60-03-2R-8 TR: 53-157 AND EGAT WORK SHEET NO.50781 AND EGAT EI NO.F2025A53M-2730 REV.0.SDR IPXA2025103093314Stringer · crackedSTRINGER 7L CRACKED, FWD SIDE OF BS 2360. ACCOMPLISHED REPAIR I.A.W UPS EO-95703-REQ1 REV.2 AND SRM 53-60-03-2R-8 TR: 53-157 AND EGAT WORK SHEET NO.50780 AND EGAT EI NO.F2025A53M-2731 REV.0.SDR IPXA2025103093343Stringer · crackedSTRINGER 8L CRACKED, FWD SIDE OF BS 2360. ACCOMPLISHED REPAIR I.A.W UPS EO-95631-REQ1 REV.1 AND SRM 53-60-03-2R-8 TR: 53-157 AND EGAT WORK SHEET NO.50779 AND GAT EI NO. F2025A53M-2577 REV.0SDR IPXA2025103093350Stringer · crackedSTRINGER 9L CRACKED, FWD SIDE OF BS 2360. ACCOMPLISHED REPAIR I.A.W UPS EO-95673-REQ1 REV.1 AND SRM 53-60-03-2R-8 TR: 53-157 AND EGAT WORK SHEET NO.50778.SDR IPXA2025103093401Stringer · crackedSTRINGER 10L CRACKED, FWD SIDE OF BS 2360. ACCOMPLISHED REPAIR I.A.W UPS EO-95668-REQ1 REV.2 AND SRM 53-60-03-2R-8 TR: 53-157 AND EGAT WORK SHEET NO.50785 AND EGAT EI NO.F2025A53M-2709 REV.0.SDR IPXA2025103095131Stringer Clip · crackedSTRINGER 7R CRACKED, FWD SIDE OF BS 2360. ACCOMPLISHED REPAIR I.A.W UPS EO-95648-REQ1 REV.1 AND SRM 53-60-03-2R-8 TR: 53-157 AND EGAT WORK SHEET NO.50783 AND EGAT EI NO. F2025A53M-2573 REV.0SDR IPXA2025102805909Profile · brokenFAULT/STR/ZONE 200 R/H FR 82 THE CORNER ANGLE IS BROKEN. REMOVED PROFILE -T R/H FR 82 I.A.W. SRM 51-40-21. INSTALLED NEW PROFILE-T AT ZONE 200 R/H FR 82 I.A.W. A300-600 SRM 51-40-21.SDR IPXA2025102889817Stringer · crackedSTRINGER CRACKED, FWD AND AFT SIDE OF STA 2180 S-11L. ACCOMPLISHED REPAIR I.A.W UPS EO-95736-REQ1 REV.1 AND SRM 53-60-03-2R-3 TR: 53-154 AND EGAT WORK SHEET NO.50775 AND EGAT EI NO.F2025A53M-2749 REV.0.SDR IPXA2025102889845Stringer · crackedSTRINGER CRACKED, FWD SIDE OF STA 2180 S-12L. ACCOMPLISHED REPAIR I.A.W UPS EO-95762-REQ1 REV.1 AND SRM 53-60-03-2R-3 TR: 53-154 AND EGAT WORK SHEET NO.50776 AND EGAT EI NO.F2025A53M-2773 REV.0.SDR IPXA2025102889881Stringer · crackedSTRINGER CRACK, FWD SIDE OF STA 2180 S-17L. ACCOMPLISHED REPAIR I.A.W UPS EO-95737-REQ1 REV.1 AND 53-60-03-2R-3 TR: 53-154 AND EGAT WORK SHEET NO.50771 AND EGAT EI F2025A53M-2755 REV.0.SDR IPXA2025102889905Stringer · crackedSTRINGER CRACKED, FWD AND AFT SIDE OF STA 2180 S-20L. ACCOMPLISHED REPAIR I.A.W UPS EO-95682-REQ1 REV.1 AND 53-60-03-2R-12 TR: 53-160 AND EGAT WORK SHEET NO.50762 AND EGAT EI NO.F2025A53M-2699 REV.0.SDR IPXA2025102889952Stringer · crackedSTRINGER CRACKED, FWD AND AFT SIDE OF STA 2180 S-22L. ACCOMPLISHED REPAIR I.A.W UPS EO-95700-REQ1 REV.1 AND 53-60-03-2R-12 TR: 53-160 AND EGAT WORK SHEET NO.50766 AND EGAT EI NO.F2025A53M-2701 REV.0.SDR IPXA2025102889985Stringer · crackedSTRINGER CRACKED, FWD AND AFT SIDE OF STA 2180 S-23L. ACCOMPLISHED REPAIR I.A.W UPS EO-95678-REQ1 REV.1 AND SRM 53-60-03-2R-12 TR: 53-160 AND EGAT WORK SHEET NO.50769.SDR IPXA2025102890028Stringer · crackedSTRINGER CRACKED, AFT SIDE OF STA 2180 S-17R. ACCOMPLISHED REPAIR I.A.W UPS EO-95699-REQ1 REV.1 AND SRM 53-60-03-2R-3 TR: 53-154 AND EGAT WORK SHEET NO.50774 AND EGAT EI F2025A53M-2694 REV.0.SDR IPXA2025102890067Stringer · crackedSTRINGER CRACKED, FWD AND AFT SIDE OF STA 2180 S-18R. ACCOMPLISHED REPAIR I.A.W UPS EO-95684-REQ1 REV.1 AND SRM 53-60-03-2R-3 TR: 53-154 AND EGAT WORK SHEET NO.50770 AND EGAT EI F2025A53M-2696 REV.0.SDR CALA2025102810625Floor Support · damagedAFT WET AREA FLOOR STRUCTURE; FLOOR SUPPORT BTW STA 907 AND STA 927 POSSIBLE TOOL MARK LBL 15. (REF AAR NR 1000057481) REMOVED AND REPLACED AFT WET AREA FLOOR SUPPORT BTW STA 907 AND STA 927 LBL 15 IAW B737-800 SRM 51-40-02-0G-0 AND DWG 147A5676SDR CALA2025102810623Floor Support · corroded(B737-53-3-0711) AFT WET AREA FLOOR STRUCTURE; FLOOR SUPPORT BTW STA 947.5 AND STA 967 POSSIBLE CORROSION RBL 54. (REF AAR NR 1000057480). REMOVED AND REPLACED INTERCOSTAL P/N: 147A5762U13 ON RBL 51 BWT STA 947.5 TO STA 967 IAW B737-800 SRM 51-40-02-0G-0G-0, 5SDR SWAA2025102724732Lamp · inoperativeLEFT OVERWING FWD EMERGENCY EXIT LOCATOR HAS INOPERATIVE BULBS. RELAMPED ALL INOPERATIVE LAMPS AND PERFORMED A GOOD OPS CHECK IAW AMM 33-51-01-960-801 STEPS 2 C; (1) 4); (B) B); (2) (3).SDR SWAA2025102724731Lamp · inoperativeRIGHT OVERWING FWD EMERGENCY EXIT LOCATOR HAS INOPERATIVE BULBS. RELAMPED ALL INOPERATIVE LAMPS AND PERFORMED A GOOD OPS CHECK IAW AMM 33-51-01-960-801, STEPS 2 C; (1) 4); (B) B); (2) (3).SDR SWAA2025102724730Lamp · inoperativeRIGHT OVERWING AFT EMERGENCY EXIT LOCATOR HAS INOPERATIVE BULBS. RELAMPED ALL INOPERATIVE LAMPS AND PERFORMED A GOOD OPS CHECK IAW AMM 33-51-01-960-801, STEPS 2 C; (1) 4); (B) B); (2) (3).SDR AALA202510277924Guide Arm · jammedAIRCRAFT IN BASE MAINTENANCE: DURING ADJUSTMENT AND CHECK OF AFT ENTRY DOOR FOUND ADJUSTMENT FITTING ON ARM ASSEMBLY TO BE JAMMED AND DAMAGED. REMOVED UNSERVICEABLE GUIDE ARM FROM AFT ENTRY DOOR AND INSTALLED SERVICEABLE GUIDE ARM ON AFT ENTRY DOOR. PER B737-NSDR JJBA20251024059Door Frame · corrodedCORROSION AT RT SERVICE DOOR ENTRANCE FRM 20-22 RBL 19. REMOVED AND REPLACED RT SERVICE DOOR ENTRANCE FROM 20-22 RBL 19.SDR JJBA20251024058Bracket · corrodedPAX DOOR FLOOR PANEL BRACKETS ARE CORRODED. REMOVED CORROSION FROM PAX DOOR FLOOR PANEL BRACKETS. REMOVED AND REPLACED BRACKETSSDR JJBA20251024057Rib · crackedRH WHEEL WELL RIB CRACKED IN MULTIPLE SPOTS. REMOVED AND REPLACED RH WHEEL WELL RIB.SDR JJBA20251024055Rib · crackedLH WHEEL WELL RIB CRACKED IN MULTIPLE SPOTS. REMOVED AND REPLACED LH WHEEL WELL RIB.SDR AALA202510245183Engine · fireAIRCRAFT WAS GROUNDED: AFTER TOUCHDOWN AND WHILE TAXING TO THE GATE IN CLT AN INDICATION OF A FIRE IN THE #1 ENGINE OCCURRED. THE FLIGHT CREW DECLARED AN EMERGENCY ON THE GROUND AND DISCHARGED BOTH FIRE EXTINGUISHING BOTTLES FOR THE #1 ENGINE. THE AIRCRAFT WASSDR DALA2025102207747Light · no testDURING PDC CK - DISPATCH MSG CABIN EMERGENCY EXIT LIGHT. PERFORMED EPSU SYSTEM TEST AND FAULTED DOOR 3L LIGHT UNIT. CONFIRMED EXTERIOR LIGHT INOP. R & R LIGHT ASSEMBLY P/N 8607-2-00 AND OPS TEST OK IAW A350 AMM 33-51. OK FOR SERVICE. (LP# 8151470)SDR DALA2025102007650Power Supply · inoperativeOUTSIDE EMERGENCY LIGHT AT DOOR 1R AND CEILING EMERGENCY LIGHTS AT SEATS 1D AND 2D ARE INOP. T/S PER B767 WDM 33-51-12. FOUND POWER SUPPLY AND EMERGENCY BATTERIES FAILED. R/R POWER SUPPLY (M730) AND BATTERIES PER B767 AM 33-51. OPS CK NORMAL. (7359295)SDR AALA202510212886Skin Panel · crackedAIRCRAFT IN BASE MAINTENANCE: FATIGUE CRACK 0.5" LONG AFT FROM FASTNER HOLE BETWEEN FR 13 & FR 14., HALFWAY BETWEEN Z+780 AND Z+950. MAINTENANCE CUT OUT DAMAGE AND INSTALLED DOUBLER REPAIR IAW EA 369008, SRM 53-11-11.SDR DALA2025102107687Filter · odorRETURNED TO ORD DUE TO FUMES IN CABIN. R/R LT AND RT RECIRCULATION FILTERS. C/W NO-GO ODI MSI 2172. PERFORMED W/C 0550-2001. NO DEFECTS NOTED. (LP# 8024230)SDR DALA2025102107686Light · faultedFAS REPORT EMERGENCY EXIT INTERIOR LOCATOR LIGHTS DID NOT ILLUMINATE ON LANDING. T/S PER A220 EFIM SOL.# 1-04874, RESET C/BS AND PERFORMED OPS CK OF INTERNAL EMERGENCY LIGHTING SYSTEM PER A220 AMP 33-52-00, OPS CK NML. OK TO CLOSE LOG. (LP# 6995876)SDR YENA2025102101045Valve · leakingFLT#429, PHL-FLL. F/AS ADVISE CABIN ODOR SMELL ON AIRCRAFT; COMPLIED WITH ALL TASKS ASSIGNED TO W/O 1448876. APU & COMP CLEANING. FOUND APU FCU LEAKING, FOUND SURGE VLV LEAKING, FOUND IGV ACTUATOR LEAKING. A LVL B ECS DECONTAMINATION WAS COMPLIED WITH. INSPECTSDR SCNA20251021399Light · no testR1 EXIT SIGNS AND SLIDE LIGHT EMERGENCY LIGHTS DO NOT COME ON DURING TEST. OPENSDR SCNA20251021398A/C Pack · odorA/C PACKS EMIT SMELLY SOCK SMELL ON DESCENT ON BOTH LEGS THRU APPROX 15000". PERFORMED GROUND PACK RUN TEST. COULD NOT DUPLICATE ON GROUND. BOTH PACKS OPERATE NORMALLY. I REF AMM 21-51-00SDR CALA2025102110330Bracket · crackedLH WING LOWER SKIN, BETWEEN RIB 7-8 AND S 8-9 HYDRAULIC LINES BRACKET BROKEN. REPLACED CRACKED BRACKET AT LEFT WING LOWER SKIN BETWEEN RIB 7&8 REFERENCE SRM 51-40-02-0G-0, DWG 272A9125-1.SDR CALA2025102110329Bracket · brokenRH WING LOWER SKIN, BETWEEN RIB 7-8 AND S 8-9 HYDRAULIC LINES BRACKET BROKEN. REPLACED CRACKED HYDRAULIC LINES BRACKET P/N 2729125-13 ON THE RIGHT-WING LOWER SKIN BETWEEN RIB 7&8 REFERENCE DWG 2729125-1, SRM 51-40-02-0G-0. ESFR NO. 2175; (WORK ACCOMPLISHED BY