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 IPXA2025101564861Skin · gougedGOUGE - SKIN - RT WING OUTBOARD FLAP AFT FLAP AT WS 880 - 890. REFER TO 747 NDT MANUAL, PART 6,51-00-00, FIGURE 1,11OR 16 FOR HFEC PROCEDURE. IAW EGAT EI F 2025A57M-2243 SEQUENCE A STEP 3. REQUEST RII VERIFY VALIDATE SPECIALIZED PROCESS IN REPAIR INSTRUCTIONS SDR IPXA2025101564889Skin · gougedGOUGE - SKIN - RT WING OUTBOARD FLAP AFT FLAP AT STA WS 862-870. RT WING OUTBD AFT FLAP T. REFER TO 747 NDT MANUAL, PART 6,51-00-00, FIGURE 1,11OR 16 FOR HFEC PROCEDURE. IAW EGAT EI F 2025A57M-2243 SEQUENCE A STEP 3. REQUEST RII VERIFY VALIDATE SPECIALIZED PSDR IPXA2025101571181Floor Support · corrodedMAIN CABIN COMPARTMENT FLOOR STRUCTURE, BS 1720, LBL 25 HAS (1EA) PLATE EXFOLIATED. REMOVED PLATE 1 EA AT MAIN CABIN COMPARTMENT FLOOR STRUCTURE STA 1720 LBL 25 IAW B757-200 SRM 51-40-02. INSTALLED NEW ANGLE FROM MAIN CABIN COMPARTMENT FLOOR STRUCTURE, STA 17SDR CALA2025101710236Spar · gougedLEFT WING INBD FRONT SPAR WEB HAS DEEP GOUGE IFSS 152 MID AREA. ACCOMPLISHED INTERIM REPAIR OF LT WING INBD FRONT SPAR WEB IAW PART 1 OF EC/RA 5720-03570.SDR AALA202510152986Fitting · damagedAIRCRAFT IN BASE MAINTENANCE: ELONGATED HOLES ON RIGHT AFT PASSENGER / CREW DOOR CUT OUT LOWER CENTER FITTING BETWEEN FR 66 AND FR 68 AT S23R. REPLACED CENTER FITTING PER SRM 51-42-11.SDR CALA2025101510117Skin · not reportedPER CUSTOMER REQUEST REMOVE AND REPLACE AFT CARGO DOOR SKIN. REMOVED AND REPLACED AFT CARGO DOOR SKIN IAW SRM 51-40 02 AND DWG 146A6110.SDR DALA2025101407522Sensor · faultedON THE GROUND ON APU POWER WHEN RT PACK TURNED ON, DID NOT COME ON. SMELLED SMOKE & THEN GOT PACK R FLO DISAG. TURNED SWITCH OFF AND SMELL WENT AWAY. R & R RT AIRFLOW SENSOR REF AMM 21-52. OPS CHK NML NO FAULTS, GOOD AIRFLOW. MEL/PLAC REMOVED. REVERSED M PRSDR DALA2025101407520Spar · corrodedWORKING PRI 629584-14 REV 0, REV1, REV 2, REV 3, AND ERA 629584- 14AD REV ORIG. LT REAR SPAR XRS 179 CORROSION. ACCOMPLISHED PRI 629584-14AD REV 3 LT WING REAR SPAR XRS 179 REPAIR. SFAR 88 AND CDCCL REQUIREMENTS C.W. (1232961)SDR AALA202510148444Vent Line · leakingAIRCRAFT WAS GROUNDED: SMELL OF FUMES ON FINAL APPROACH. MAINTENANCE SUSPECTS APU, MAINTENANCE ACCOMPLISHED. APU COOLING FAN REPLACED IAW AMM49-52-51, APU VENT TUBE REPLACED IAW AMM 49-26-51, #2 ENGINE DE-OILER SEAL REPLACED IAW AMM 72-60-31, A.SDR AALA202510144809Cooling Fan · leakingAIRCRAFT WAS GROUNDED: SMELL OF FUMES ON FINAL APPROACH. MAINTENANCE SUSPECTS APU, **SUPPLEMENTAL REPORT FOR SDR AALA202510144809.** (CLOSED)** MAINTENANCE ACCOMPLISHED. APU COOLING FAN REPLACED IAW AMM49-52-51, APU VENT TUBE REPLACED IAW AMM 49-26-51, #2 ENGISDR AALA202510143945Seal · leakingAIRCRAFT WAS GROUNDED: SMELL OF FUMES ON FINAL APPROACH. MAINTENANCE SUSPECTS APU, MAINTENANCE ACCOMPLISHED. APU COOLING FAN REPLACED IAW AMM49-52-51, APU VENT TUBE REPLACED IAW AMM 49-26-51, #2 ENGINE DE-OILER SEAL REPLACED IAW AMM 72-60-31, A.SDR DALA2025101407495Retainer · corrodedSHIP 3124 BUFFET AND GALLEY G5 GALLEY CORROSION. CORRECTIVE ACTION: REPLACEMENT OF ALL TROLLEY RETAINER BLOCKS ( COMPARTMENTS 510, 511, AND 512) OF G5 GALLEY PER ER/A 629680-14. (1232453)SDR AALA202510139657Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO RIGHT HAND AFT PASSENGER / CREW DOOR CUT OUT LOWER CENTER FITTING BETWEEN FR 66 AND FR 68 AT S23R. REPLACED CENTER FITTING PER SRM 51-42-11.SDR AALA202510134778Plate · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER / CREW DOOR FLOOR MOUNTED GIRT BAR FITTING PLATE ASSEMBLY. REPLACED PLATE ASSEMBLY AS REQUIRED.SDR DALA2025101307482Strap · corrodedCORROSION ON AFT LAV SUPPORT STRUCTURE STRAP. REPLACED STRAP REF BAC DWG 146T3244 (1232946)SDR DALA2025101307474Gusset · corrodedSHIP 185 CORROSION ON AFT LAV SUPPORT STRUCTURE 3EA GUSSETS 146T3248-9. CORRECTIVE ACTION: REPLACED GUSSETS REF BAC DWG 146T3244 (1231764)SDR DALA2025101307489Stiffener · corrodedCORROSION ON AFT LAV PAN SUPPORT STRUCTURE RH STIFFNER PT# 146T3248-2. REPLACED STIFFNER REF BAC DWG 146T3244 (1232945)SDR DALA2025101307488Stiffener · corrodedCORROSION ON AFT LAV PAN SUPPORT STRUCTURE LH STIFFENER PT # 146T3248-1. REPLACED STIFFENER REF BAC DWG 146T3244 (1232943)SDR DALA2025101307487Stiffener · corrodedCORROSION ON AFT LAV SUPPORT STRUCTURE 2EA STIFFENER SUPPORTS PN 146T3259-1. REPLACED SUPPORTS REF BAC DWG 146T3244 (1231990)SDR DALA2025101307486Support · corrodedSHIP 185 CORROSION ON AFT LAV SUPPORT STRUCTURE 2EA GUSSETS 146T3248-13. CORRECTIVE ACTION: REPLACED GUSSETS REF BAC DWG 146T3244 (1231766)SDR DALA2025101307485Angle · corrodedSHIP 185 CORROSION ON AFT LAV PAN SUPPORT STRUCTURE "L- ANGLE" PT # 146T0207-2. CORRECTIVE ACTION: REPLACED ANGLE REF BAC DWG 146T3244 (1232941)SDR CALA2025101309944Seat Track · corrodedMAIN CABIN AFT WET AREA RT BS 890 RBL44, SEAT TRACK HAS CORROSION AT FASTENER HOLE. REMOVED AND REPLACED SEAT TRACK IAW SRM 51-40-02 AND NAT DWG 10N00633 REV-.SDR AALA202510139781Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 277 TO BS 294.5 AT RBL 2. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR JJBA20251010039Skin · corrodedRFI EXT, SKIN UNDER ANTENNA BTW FR 70-68 AND STR 21R-21L FOUND CORRODED. REPAIR DOUBLER ON RFI LOWER SKIN, BTW FR 68-69 AND BTW 21L-21RSDR DALA2025101007390Skin · damagedPERFORM ER/A 628645-14 REV. ORIGINAL SECTION III ON EXTERNAL SKIN FR 3 AND 10.5 INCH ABOVE STATIC PORT RVSM AREA REFERENCE TO LOG PAGE 1153824. PERFORMED REPAIR ON UPPER SKIN BETWEEN FR2 TO FR4 RH SIDE AND 10.5 INCH ABOVE STATIC PORT RVSM AREA AS PER A320 SRMSDR AALA202510094717Bulkhead · crackedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND ECS BAY AFT BULKHEAD UPPER INBOARD CHORD CRACKED. REPAIRED RIGHT HAND ECS BAY AFT BULKHEAD UPPER INBOARD CHORD. PER B737 SRM 57-10-10-2R-5.SDR CALA2025100909835Skin · contaminatedLEFT ELEVATOR HAS A LIQUID INGRESS INDICATION 39" FROM INBD 12" FROM TRAILING EDGE 2"X 2". REPAIRED LEFT ELEVATOR 39" FROM INBD 12" FROM TRAILING EDGE ZONE A AS REQUIRED IAW SRM 55-21-11-300-005 CATEGORY A REPAIR A.SDR CALA2025100909834Skin · contaminatedLEFT ELEVATOR HAS A LIQUID INGRESS INDICATION 45.5" FROM INBD 15" FROM TRAILING EDGE 4" X 2" IN SIZE. REPAIRED LEFT ELEVATOR 45.5" FROM INBD 15" FROM TRAILING EDGE Z ONE A AS REQUIRED IAW SRM 55-21-1-300-005 CATEGORY A REPAIR.SDR 141A2025100800237Brake · overtempPIC CONTACTED ACP SABRINI FOR BRIEFING & CLARIFICATION ABOUT PROCEDURE BEFORE BEGINNING. WHILE ON THE RAMP, PIC PERFORMED LOW-SPEED BRAKE TESTS AT 5–10 KNOTS GS TO VERIFY FUNCTIONALITY. BRAKES WERE ONLY SLOWING DOWN THE ACFT, BUT IT WASN’T FIRM BRAKING AS THESDR JJBA20251008022Plate · corrodedRFI, FWD RADIO ALTEMETER ANTENNA DOUBLER BTW FR 65-66 AND STR 21R-21L FOUND CORRODED. RF1, ANTENNA DOUBLER BTW FR 65-66 AND STR 21L-21R BLENDED AND FOUND OUT OF LIMIT. RF1, FWD RADIO ALTIMETER ANTENNA DOUBLER BTW FR 65-66 AND STR 21R-21L REPLACED.SDR CALA2025100809790Stringer · corrodedFOUND 3 AREAS OF CORROSION IN STRINGER CHANNEL AT APPROX STA 811, STA 815, AND STA 832, STR 25L. REMOVED DAMAGE AT STA 811 -825 AT STR 25L HFEC REQUIRED AT CUT EDGE OF STR 25L AND APROX STA 811 REF SRM 53-00-03-2R-1 STEP 4 (C) PERFORMED HFEC AT CUT EDGE OF SSDR CALA2025100709752Stringer · gougedFOUND 2 LARGE SCRATCHES AND DENT ON FUSELAGE JUST AFT OF DOOR 1L.THE GOUGE MEASURES 4.25" BY 2.0" AND GOES ACROSS A STRINGER AND THROUGH TWO RIVET HEADS (AS PICTURED). THE DENT MEASURES .065" DEEP. USING SRM REFERENCE 53-11-11-283-017 BLEND OUT (REWORK) PLUS DSDR QXEA2025100700317Fuel Sys · faultedFUEL FEED 2 FAULT ON TAKEOFF. REJECTED TAKEOFF. REMOVED FROM SERVICE. INFO ONLY RESET. FUEL FEED 2 FAULT IAW AOM 1 PG 3.8.25 AND GPM 8.2.2.4 MSG CLRD. RETURNED TO SERVICE. NO PARTS REPLACED.SDR AALA202510073945Unknown · odorAIRCRAFT WAS GROUNDED: SMELL OF FUMES ON FINAL APPROACH. MAINTENANCE SUSPECTS APU,SDR ABXA20251003259Actuator · faultedDURING APPROACH, LE SLAT ASSYM. EICAS MSG ILLUMINATED, ABORTED APPROACH. (AAP). A/C IS CURRENTLY IN WORK. WILL SEND AN UPDATED SDR REPORT WHEN WORK IS COMPLETE. AMENDED: FOUND #4 SLAT ASKEW, REMOVED AND REPLACED #4 OUTBD SLAT ROTART ACTUATOR AND OFFSET GSDR AALA202510078435Shield · corrodedAIRCRAFT WAS GROUNDED: CORROSION ON AFT CARGO COMPARTMENT SHIELD BETWEEN BS 767 AND BS 787 AT S25L. REPLACED SHIELD PER AARD 51-00-05-1.SDR AALA202510077974Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE BREAK ASSEMBLY PANEL AT BS 540, LBL 0. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-1.SDR AALA202510073392Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE BREAK ASSEMBLY PANEL AT BS 540, RBL 0. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-1.SDR CALA2025100709751Skin · ground damageAIRCRAFT AFT FUSALAGE CONTACTED LAV TRUCK AT LAV SVC HATCH. MULTIPLES DENTS AREAS AROUND LAV SERVICE DOOR ON THE STRINGERS THAT REQUIRED OPEN UP FOR FURTHER INSPECTION FOR DAMAGE. REF. SRM 53-00-01-1A-1. SEE ATTACHED PHOTOS FOR LOCATION OF DAMAGE. SKIN AND SDR CALA2025100709750Power Supply · inoperativeCABIN SEAT EMERGENCY LIGHTS INOP FROM 22ABC TO 27ABC. REPLACED FUSE NUMBER 2 ON EMERGENCY BATTERY PACK CHARGER M1670 IAW AMM 33-51-06-960-804.PERFORMED EMERGENCY LIGHTS OPERATIONAL CHECK IAW AMM 33-51-00-720-801. OPS CHECK GOO D.SDR CALA2025100709749Spring · missingPDA 2 REFRENCE LOG 6494784 FOUND LEFT HAND GEAR SIDE BRACE SPRING MISSING ON ARRIVAL . .LANDING GEAR LEFT STRUT DOWNLINK SPRING MISSING FWD DRAG BRACE AFT SPRING INSTALLED NEW LEFT MLG DRAG BRACE AFT LOCK SPRING AND SPOOLHALF, REF AMM 32-32-07-400-802.SDR GTIA2025100639115Unknown · odorPRIOR F/A'S REPORTED FUME EVENT ON ARRIVAL / DESCENT IN TO EWR FA REPORTS DIRTY SOCK SMELL. -PERFORMED INSPECTION OF FUMES EVENT IAW TSM 05-50-00-810-831-A. DRAINED BOTH ENG’S TO NORMAL OIL LEVEL. INSPECTED ENGINES AND APU IAW TSM TASK 71-00-00-810-847-A & AMMSDR GTIA2025100639114Engine · overservicedFLIGHT ATTENDANTS NOTIFIED US THAT THEY SMELLED A DIRTY SOCK SMELL AT 2000 FEET. DESCRIPTION OF ODOR/FUMES: PERSISTENT, DIRTY SOCKS/MUSTY DRY SMELL. APPARENT CABIN SOURCE: CABIN AIR SUPPLY VENTS. FWD CABIN AND AFT CABIN. NO VISIBLE HAZE/SMOKE. NO MEDICAL ATTESDR SWAA2025100620766Skirt · out of limitsPASSENGER CABIN AFT SERVICE DOOR ESCAPE SLIDE GIRT SKIRT IN POOR CONDITION. REMOVED AND REPLACED AFT SERVICE DOOR ESCAPE SLIDE PER MT 756-61-06SDR SWAA2025100620867Rivet · shearedCREW REPORTS ISSUE WITH L-1 SLIDE GIRT BAR. FOUND RIVET SHEERED ON L-1 SLIDE GIRT BAR RETAINER. INSTALLED NEW RIVET PER SRM 51-40-02.SDR SWAA2025100620872Cover · detachedMID CABIN EXIT SIGN COVER FELL DOWN. SECURED EXIT SIGN COVER IAW SIP.SDR SWAA2025100620808Light · contaminatedPASSENGER CABIN SEAT ROW 24DEF TO GALLEY TRANSITION PHOTOLUMINESCENT FLOOR STRIP WATER CONTAMINATED. R & R CABIN PHOTOLUMINESCENT STRIPS PER AMM 33-51-15;.SDR SWAA2025100620938Battery Pack · inoperativeR/H AFT EMERGENCY EXIT LIGHTS INOPERATIVE. REMOVED AND REPLACED RIGHT AFT BATTERY PACK IAW AMM 33-51-06. OPS CHECK GOOD. NO OTHER DEFECTS NOTED.SDR SWAA2025100620748Stiffener · damagedNR 2 ENGINE AFT STRUT FAIRING STIFFENER HAS 4 EACH ELONGATED HOLES FORWARD SIDE. REAMED HOLES TO .328 AND INSTALLED OVERSIZED FATSENERS IAW EA 25-154-02693 REFERENCE TASK TTG8Q015HNDM.SDR SCNA20251006397Smoke Detector · false activationR2 LAVATORY SMOKE ALARM WENT ON AND OFF NO VISIBLE SMOKE OR FIRE OBSERVED. ILLUMINATED DURING DEPLANING. R & R R2 LAVATORY SMOKE DETECTOR REF AMM 26-14-01. OPS TEST GOOD.