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 AALA202508110644Indication Sys · faultedAIRCRAFT WAS GROUNDED: ON APPROACH AFTER FLAPS 1 SELECTED AND EXTENDED, NOSE GEAR LIGHTS BOTH RED AND GREEN WERE FLASHING AND MOMENTARILY STAYING LIT WITHOUT GEAR BEING ACTUATED. (OPEN).SDR AALA202508115201Slide · out of adjustAIRCRAFT WAS GROUNDED: FLIGHT ATTENDANT REPORTS R1 IS DIFFICULT TO ARM. CHECKED AND ADJUSTED R1 DOOR SLIDE. OPERATIONAL CHECKS GOOD TO ARM. PER AMM 25-66-01SDR AALA202508118886Door · bindingAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR JAMMED. ADJUSTED LAVATORY-D DOOR ON AFT LEFT HAND CABIN, OPERATIONAL CHECK GOOD. PER AMM 25-40-14SDR AALA202508114438Girt Bar · unsecureAIRCRAFT WAS GROUNDED: AFT LEFT DOOR GIRT BAR FITTING LOOSE. SECURED AFT LEFT DOOR ASSEMBLY GIRT BAR LOCK. PER AMM 25-26-01.SDR AALA202508116820Girt Bar · out of adjustAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANTS REPORT GIRT BAR ON MAIN CABIN ENTRY DOOR IS VERY LOOSE. READJUSTED GIRT BAR CLIP OF MAIN CABIN DOOR, GIRT BAR HAS POSITIVE CATCH. PER AMM 25-66-01.SDR AALA202508116370Sign · dislodgedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT SIGNAGE 25ABC WAS HANGING BY WIRES. SIGNAGE REATTACHED AND SECURED. OPERATIONAL CHECK GOOD.SDR AALA202508111880Girt Bar · unsecureAIRCRAFT WAS NOT GROUNDED: EMERGENCY SLIDE ON BOARDING DOOR L1 HAS A FLAP EXPOSED AFTER DISARMING. RESECURED LOOSE FABRIC STRAP ON L1 DOOR EMERGENCY SLIDE PACK AND PERFORMED OPERATIONAL CHEC KOF THE GIRT BAR SYSTEM. PER AMM 25-66-01. NO FURTHER DEFECTS NOTED.SDR DALA2025081105989Frame · damagedSHIP 9516 FRAME AND FASTENERS DAMAGED AT 6 O'CLOCK POSITION ON CANTED. CORECTIVE ACTION: COMPLIED WITH ER/A 627973-14 (1130003)SDR IXXA2025080117038Engine · faultedUPON LANDING HEARD A LOUD BANG AND FLASH OF LIGHT BOTH FROM THE LEFT SIDE OF AIRCRAFT. NO OTHER IRREGULAR ITEMS NOTED. ACCOMPLISHED EXTERIOR INSPECTION WITH NO DAMAGE, DEFECTS, OR ANY OTHER ABNORMALITIES NOTED. ACCOMPLISHED LEFT ENGINE VARIABLE STATOR VANE ANDSDR JJBA20250811031Frame · crackedFR 29 LH FOUND CRACKED BTW STR 15L-16L. EXTENDED SPLICE REPAIR ON LH CENTER FUSE IV FRAME 59 BTW STR 14L-16LSDR DALA2025081105972Skin · damaged(LOG 1130816) ATS HAS REMOVED A PREVIOUSLY INSTALLED TEMPORARY FUSELAGE SKIN REPAIR AT STRINGER S-3R BETWEEN 500C+14 AND BS 500D+1.4. THE REMOVED REPAIR WAS INSTALLED DUE TO SKIN LIGHTNING STRIKE DAMAGE AT S-3R WITH A SKIN CUTOUT AT ONE FASTENER LOCATION. ALSOSDR DALA2025081105970Seat · loose(LOG 7717042) SEATS LOOSE IN TRACK 3AB, 3CD, 12DEF, 13DEF, 14DEF, 19DEF, 20DEF, 21DEF, 22DEF, 23DEF, 24DEF, 25DEF, 26DEF, 27DEF, 29DEF, 32DEF. SECURED SEATS REF B737 AMM 25-22.SDR DALA2025081105968Angle · corroded(LOG 1130990) FWD CARGO L/H TRANSITION ANGLE HAS CORROSION FROM ST 500 TO STA 500K. REMOVED AND REPLACED DUE TO MULTIPLE OUT OF LIMITS AREAS IAW B737-900 SRM53-00-53-ZR-5 51-40-02-AND 51-40-05.SDR DALA2025081105967Angle · corroded(LOG 1130969) FWD CARGO R/H TRANSITION ANGLE HAS CORROSION FROM STA 500A TO STA 500K. REMOVED AND REPLACED FWD CARGO R/H TRANSITION PANEL FROM STA 500A-500L IAW B737-900 SRM 53-00-53-ZR-5, 51-40-02, 51-40-05 AND 50PM 20-41-02.SDR DALA2025081105966Web · corroded(LOG 1130815) FWD CARGO DOORWAY THRESHOLD WEB HAS LIGHT CORROSION. REMOVED AND REPLACED FWD CARGO DOORWAY THRESHOLD WEB B737-900 SRM 51-40-02-00.SDR DALA2025081105965Support Beam · corroded(LOG 1130808) MULTIPLE AREAS OF CORROSION ALONG LENGTH OF AFT CARGO RH FLOORBOARD TO SIDEWALL TRANSITION SUPPORT BEAM. REMOVED TRANISTION BEAN SECTION FROM STA 727I TO STA 767, FABRICATED NEW TRANSITION BEAM AND INSTALLED. REMOVED TRANSITION BEAM AND INSTALLEDSDR DALA2025081105964Seat Track · corroded(LOG 1130647) CORROSION ON FLOOR SUPPORT STA 500I BTW LBL 17. FLOOR SUPPORT (TRACK) ON STA 500 G +24 TO STA 500 I LBL 17 WAS REPAIRED PER B737-800 SRM 53-00-53-2R PROCEDURE 3.SDR DXTA2025081104509Coffeemaker · smokeON DESENT THRU 17,000' OR SO THE FLIGHT ATTENDANT INFORMED US THAT SMOKE WAS COMING OUT FROM THE ESPRESSO MAKER, AND THERE WAS A ELECTRICAL SMELL. I CAME BACK AND CONFIRMED THE ELECTRICAL SMELL BUT THE SMOKE HAD SUBSIDED. AS A PRECAUTION ALL APPLIANCES WERE TSDR DXTA2025081104522Handle · faultedTHE SPRING ON THE EXTERIOR RED LEVER HANDLE IS BROKEN. WHEN YOU UNSTOW THE HANDLE THE LEVER DROPS DOWN WITH NO TENSION. WHEN YOU MOVE THE LEVER BACK TO THE NEUTRAL DETENT IT WILL NOT STOW WITHOUT MANIPULATION OF THE CLASP TO STOW IN PLACE. THE CLASP ITSELF IS SDR AALA202508119126Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION LOWER SILL LOCATED FR68 AT LEVEL STR 23R AFT GALLEY AREA. MAINTENANCE PERFORMED PERMANENT REPAIR ON LOWER SILL LOCATED FR68 AT LEVEL STR 23R AFT GALLEY AREA IAW A319 SRM 53-41-14-300-001 STEP 2.A.SDR CALA2025081107560Skin · damagedSIX EA FASTENERS HOLES FOUND ELONGATED. ON REMOVAL OF FASTENERS IAW EA 5330-04213 REV D OP 004 STEP 3. ACCOMPLISHED ECRA#5310-08671 AND EA 757-5310-13-A4029 REV-.SDR CALA2025081107559Skin · crackedRIGHT WING NR 8 SLAT LOWER SURFACE AT ACTUATOR ATTACH POINT CRACKED. ACCOMPLISHED PERMANENT REPAIR AT SLAT NR 8 NOSE SKIN LOWER SURFACE IAW SRM 57-42-01-2R-8 FIGURE 202 ALTERNATIVE 1. NO FURTHER ACTION REQUIRED.SDR CALA2025081107542None · noneOPENED CB A1, A3 ON P 18-2 FOR MX CLOSED CB A1 A3 ON P18-2SDR CALA2025081107541Slide · not reportedR2 DOOR SLIDE REQUIRE REPLACEMENT.SDR CALA2025081107522Lavatory · odorAFT LAV D GIVING VERYROUGH SMELL. NO WASTE VISIBLE. STARTED SMELLING AFTER TAKEOFF, NOTIFY LAV SERVICE TO DUMP AND RESERVICE LAV SYS, NO WATER OR WASTE LEAKS NOTED, NO FOUL ODORS NOTED AT AFT LAV D.SDR DALA2025081105961Reservoir · leakingCREW DIVERTED TO ORD AFTER RECEIVING A LT SYSTEM HYDRAULIC QUANTITY LOW MESSAGE WITH QUANTITY DEPLETING. FOUND LEFT HYD LEAKING AT HYD RESERVOIR BLEED VALVE DRAIN HOSE CONNECTION. REPLACED RESERVOIR. LEAK CHECK NORMAL.(7712608)SDR NI6R202508100063Engine · flamed outPILOT REPORT: WE WERE ORBITING THE FIRE AT 10,500' IN A RIGHT TURN, WITH BOTH ENGINES STABILIZED AT 200 HORSEPOWER EACH AND FUEL FLOWS AT 200 LBS./HR. EACH WHEN I FELT A YAWING MOTION THAT I INITIALLY THOUGHT WAS WAKE TURBULENCE. LOOKING AT THE ENGINE INSTRUMESDR AALA202508095773Control Unit · inoperativeAIRCRAFT WAS GROUNDED: DURING PERFORMING J/C 78T21033001, FOUND EXIT LOCATOR SIGN AFT DOOR 2L INOP. MAINTENANCE 25REPLACED WELS CONTROL UNIT M3351051 PER AMM 33-51-07.SDR YENA2025080800820A/C Pack · odorFLT#2251, BOS-MCO. AFT FA'S REPORTING A STRONG DIRTY SOCK SMELL ON LANDING APU NOT RUNNING. IN COCKPIT A PAINT SMELL WAS NOTICED ON DESENT LANDING; COMPLIED WITH INFO NOTICE 2017-T015. IDENTIFIED ODOR AT PACK 1. INSPECTED APU & APU BLEED DUCT FOR OIL CONTAMINASDR YENA2025080800819Apu · odorFLT#219, BOS-SAN. DURING DESCENT STRONG OZONE SMELL/ODOR ON BLEED PAGE HP VALVE WAS OPEN. SHUT X-BLEED & PACK 1 OFF. ODOR DISSIPATED W/IN 20 SECONDS . AFTER LANDING RESET X-BLEED & PACK 1 AND ODOR RETURNED IMMIDIATELY. ODOR FORM COMPLETED; REF TSM 05-50-00-81SDR SWIA2025080800007Windshield · crackedCAPTAIN WINDSHIELD CRACKED (FLIGHT 5844) THIS IS CURRENTLY A WORK IN PROGRESS.SDR DXTA2025080804511Bellcrank · misinstalledCLIMBING THROUGH 10,000FT, RECEIVED AN AMBER CABIN DOOR ANNUNCIATOR LIGHT. NO PRESSURIZATION CHANGES NOTED, LEVELED OFF AT 12,000 AND RETURNED BACK TO KBTL. TROUBLE SHOT AS REQUIRED, FOUND MED BOLTING SYSTEM LINKAGE BELLCRANK CAM TO BE INSTALLED INCORRECTLYSDR DALA2025080805955Engine · odorDIRTY SOCK SMELL NOTICED ON TAKEOFF ROLL AND EARLY CLIMB OUT. REMOVED AND REPLACED NR 1 ENGINE IAW AMDS 7100-9901-LT.SDR DALA2025080805954Apu · odorDIRTY SOCK SMELL WHEN APU AIR TURNED ON. R/R APU IAW A319 AMM 49-11-11.SDR WX0A2025080832530Light · missing(AIRCRAFT NOT GROUNDED) SMALL SECTION PHOTOLUMINESCANT STRIP (EMERG LIGHT STRIP) MISSING ROW 22 LH . REPLACED/SECURED PHOTOLUMINESCENT SECTION @ ROW 22 LH REF AMM 33-51-21-400-001-A"SDR DXTA2025080804512Door · faultedDOOR HANDLE IS STIFF AND FEELS LIKE ITS CATCHING ON SOMETHING. INSPECTED THE DOOR AND FOUND NO ABNORMALITIES AT THIS TIME. PERFORMED CABIN DOOR OPERATIONAL CHECK IAW AMM 52-10-00, AND THE OPS CHECK WAS FOUND SATISFACTORY. PERFORMED THE OPS CHECK AGAIN WITH ASDR DXTA2025080804519Rod · dirtyMAIN DOOR HANDLE IS DIFFICULT TO OPEN FROM INSIDE THE AIRPLANE. RESEARCHED MED DOOR DESCRIPTION AND OPERATION, AND NO HISTORY FOUND CONNECTED TO THIS SQUAWK. ARRIVED AT ACFT. NO STRUGGLE FOUND OPENING FROM THE OUTSIDE. TRIED TO CLOSE AND OPEN FROM INSIDE, WAS SDR DALA2025080805952Door · out of rigLEFT AFT ENTRY DOOR EICAS MESSAGE IN CRUISE. THE HANDLE POPS UP A FEW INCHES IN CRUISE FLIGHT. PERFORMED RIG ON LEFT AFT ENTRY DOOR PER B757 AMM 52-11-00 PRESSURIZED AIRCRAFT TO 4.5 PSI IAW AMM 21-31-00 LEFT AFT ENTRY DOOR CKS GOOD.SDR DALA2025080805951Charger · inoperativeDURING SVC CHECK, FOUND EMERGENCY LIGHT BETWEEN ROW 2735 INOP. REMOVED AND REPLACED BATTERY CHARGER AT ROW 35, ALL WORK PER B757 AMM 2433. FOUND BROKEN WIRE AT CONNECTOR D9353, REPAIRED SAME PER SWPM 20 IAW B757 WDM 33-51-14 EMER LTS OPS NORMAL.SDR DALA2025080805945Stringer · crackedPASSENGER CABIN AT STATION 1600 STRINGER S9L HAS CRACK AT INBOARD HI-LOK FOR OVERHEAD BIN SUPPORT BRACKET, VERIFIED BY EDDY CURRENT MACHINE. CUTOUT DAMAGE & REPAIRED IAW B757 SRM 53-00-07-2R AT STA 1600 STR 9L.SDR AALA202508082678Beam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CABIN LONGITUDINAL FLOOR BEAM FR FR 67 AND FR 70 AT -Y464.8. REPLACED LONGITUDINAL FLOOR BEAM PER SRM 51-72-11.SDR AALA202508083402Wire Harness · brokenAIRCRAFT WAS GROUNDED: SEAT ROW 35 AND 36 WHITE SEAT MOUNTED EMERGENCY AISLE LIGHTS ARE INOPERATIVE. MAINTENANCE FOUND SEAT 35ABC WALL / FLOOR EMERGENCY LIGHT CONNECTOR WIRE PULLED / BROKEN FROM CONNECTOR PIN AS WELL AS THE CONNECTOR QUICK DISCONNECT METAL PRSDR AALA202508082851Brake · damagedAIRCRAFT WAS NOT GROUNDED: FLIGHT CREW REPORTED THAT THE BRAKES WERE GRABBING AND CHATTERING, ESPECIALLY LEFT SIDE. SHAKING THE AIRFRAME AS WE TRIED TO TAXI EVEN WITH FEET ON THE FLOOR. MAINTENANCE FOUND THE #1 BRAKE ASSEMBLY WAS DAMAGED AND REPLACED IT PER AMSDR SIMA20250807003Sensor · failedSLAT FAIL FLAP FAIL ON EICAS. SOFT LANDING LESS THEN 300 FPM WEIGHT 72,000 LBS. TRANSFERRED TO NRWC 061-DFW-04708 ITEM-1. EMERGENCY DECLARED. R & R OUTBOARD LEFT SLAT SKEW SENSOR IAW AMM 27-83-01. OPS CHECKED GOOD.SDR FDEA202508071392Floor Panel · crackedMDC FLOOR PANEL 241KFF WITH PUNCTURE MDC FLOOR PANEL 241KFF WAS REPAIRED IAW B767 SRM 53-00-50-2R PAR 4-B FIG 201 SHEET 2 REV 92 APR 15/2025SDR FDEA202508071391Floor Panel · crackedHOLE ON FLOOR PANEL 241YFA ON MAIN DECK FLOOR PANEL 241YFA ON MAIN DECK WAS REPAIRED IAW B767 SRM 53-00-50-2R PAR 4-B FIG 201 SHEET 2 REV 92 APR 15/2025SDR FDEA202508071390Strut · corrodedENG #1 I/B NACELLE STRUT INTERNAL STRUCTURE THRU ACCESS PANEL # 433AL HAS CORROSION ON THE SKIN COMPLIED WITH EA # F-5450-T0384076 P1 TITLE: NACELLES/PYLON N0 1 PYLON, INBD PANEL, PP STA 163, INNER SKIN ASSY, CORROSION REPAIRSDR FDEA202508071389Floorbeam · corrodedMAIN CABIN FLOOR BEAM AT BS 1681.0 RBL 24.75 WITH EVIDENCE CORROSION COMPLIED WITH EA # F-5310-T0384192 TITLE: FUSELAGE - MAINFRAME - REPAIR OF STA 1681 FLOOR BEAM LOWER CHORD CORROSION AT RBL 26SDR SIMA20250807001Light · inoperativeEMERGENCY PHOTOLUMINESCENT STRIPS INOPERATIVE NEAR WARDROBE, REQUIRE REPLACEMENT. R & R PHOTOLUMINESCENT STRIPS NEAR WARDROBE IAW AMM 33-50-21.SDR SIMA20250807002Battery · inoperativeDURING PS 2 CHECK FOUND PILOT HAND FLASHLIGHT INOPERATIVE. R & R FLASHLIGHT BATTERY IAW AMM 33-51-01. OPS CHECK GOOD.