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 ASAA2025092361331Floor Support · crackedINTERCOSTAL BETWEEN FRAME STATION 312 AND 328 RBL 40 CRACKED. GROUNDED - YES. REMOVED INTERCOSTAL BETWEEN FRAME STATION 312 AND 320 RBL 40 IAW B737-700 SRM 51-40-02-0G-0 INSTALLED NEW INTERCOSTAL N.P 141A5410U140 TAG AS34740 BETWEEN FRAME STATION 312 AND 328 RSDR U2RA2025100500022Cartridge · inoperativeDURING A CHECK, UPPER DECK DOOR LT EMERGENCY POWER SYSTEM BATTERY FOUND INOPERATIVE DURING TEST. CARTRIDGE ASSY WAS REPLACED. OPERATIONAL CHECK WAS SATISFACTORY.SDR IPXA2025100200271Seat Track · corrodedMAIN DECK FLOOR STRUCTURE AT FRAME 80/82 HAS SEAT TRACK CORRODED, -Y450 DOT 1/018. REMOVED CORROSION IAW SRM 51-22-00 AND AFTER FURTHER EVALUATION FOUND STILL SHOWS UP EXFOLIATED CORROSION. FOUND OUT OF LIMITS IAW SRM 53-10-16. INSTALLED NEW SEAT TRACK SECTIOSDR IPXA2025100100289Floor Support · crackedMAIN DECK FLOOR STRUCTURE AT FRAME 79, -Y1580.5 ANGLE CRACKED. REMOVED CRACKED ANGLE. IAW SRM 51-40-21-001. INSTALLED ANGLE IAW SRM 51-40-21-001.SDR IPXA2025100100260Floor Support · crackedMAIN DECK FLOOR STRUCTURE AT FRAME 79 AT Y1580.5 ANGLE CRACKED. REMOVED CRACKED ANGLE IAW SRM 51-40-21-001. INSTALLED ANGLE IAW SRM 51-40-21-001.SDR CALA2025093009423Proximity Sensor · stickingSLIDE LIGHT OVER 2R ILLUMINATED ON GROUND WILL NOT EXTINGUISH DOOR SLIDE ARMED LIGHT STAYS ILLUMINATED WHEN DOOR IS DISARMED. LIGHT EXTINGUISHES WHE DOOR HANDLE IS MOVED TO THE OPEN POSITION, LIGHT ILLUMINATES WHEN DOOR IS CLOSED AND DISARMED. VERIFIED GIRT SDR DALA2025092907042Skin · damaged(LOG 7546848) BIRD STRIKE ON FINAL APPROACH FO SIDE HORIZONTAL STAB. REPAIRED R/H HORIZONTAL L/E PER BOEING DWG 186A1001. RE-INSTALLED R/H HORIZONTAL L/E SKIN PER BOEING DWG 186A1001.SDR DALA2025092907035Skin · ground damage(LOG 7472984) AIRCRAFT SUSTAINED IMPACT DAMAGE; SECTION 41 LOWER LOBE FORWARD OF E&E DOOR. PERFORMED FRAME REPAIRS PER BOEING DRAWINGS 141A1501, 141A1502 AND 141A1503. SKIN INSTALLATION PER BOEING DRAWING 141A0650, 141A3501 AND 141A3502. ASSOCIATED REPAIRS C/WSDR DALA2025092907034Frame · cracked(LOG 1214060) CRACK ON FRAME STA 380 BTW STGR 7L TO 8L AT PAX CABIN. FRAME STA 380 BTW STGR 7L TO 8L AT PAX CABIN WAS REPAIRED PER B737-800 SRM 53-00-07-2R PROCEDURE 1 REPAIR 1.SDR DALA2025092907033Threshold Web · corroded(LOG 1214002) AFT CARGO DOORWAY THRESHOLD WEB CORRODED. EVALUATED & REPLACED THE AFT CARGO LOWER MAIN SILL WEB IAW B737- 900 SRM 53-60-15-1-A1 & SRM 51-40-02-0G.SDR DALA2025092907032Skin · cracked(LOG 1213937) GROUND POWER RECEPTACLE SURROUND STRUCTURE TAB BETWEEN DOOR HINGES IS CRACKED. REMOVED AND REPLACED DOUBLER AND TRIPPLER PER ER/A 585833-14 REV A SECTION II. COMPARED TO PRI REV 1, 2, 3, 4 AND 5. ALL WORK STEPS COMPLETE.SDR DALA2025092907031Fitting · corroded(LOG 1213903) STA 312 L/H SIDE GIRT BAR FITTING Z BRACKET HAS CORROSION. REMOVED AND REPLACED L/H SIDE TIEDOWN FITTING AT STA 312 IAW B737-900 SRM 51-0-02-0G.SDR DALA2025092907030Splice Strap · corroded(LOG 1213884) AFT CARGO FLOOR PANEL SPLICE STRIP AT STA 770 IS CORRODED. ORDERED AND RECEIVED NEW AFT CARGO FLOOR PANEL SPLICE STRAP AT STA 770 P/N 146A9401 TAG 4195867. WORK ACCOMPLISHED ON ROUTINE CARD 16407.149.SDR DALA2025092907029Seat Track · broken(LOG 1213723) BROKEN SEAT TRACK FROM STA 500C TO STA 500D LBL 24.75 AT PASSENGER CABIN. SEAT TRACK FROM STA 500C TO STA 500D LBL 24.75 AT PASSENGER CABIN WAS REPAIRED B737-800 SRM 53-00-52-2R PROCEDURE 4 REPAIR 4.SDR DALA2025092907028Door Frame · corroded(LOG 1213924) FRAME 947 FWD R2 DOOR POSSIBLE CORROSION. REMOVED AND REPLACED FR947 FWD R2 DOOR FLOOR SUPPORTS BETWEEN RBL 5-15 IAW B737-900 SRM 51-40-02-0G.SDR VNAA2025092911101Control Lever · inoperativeGEAR DISAGREE / STEERING INOP / GEAR WOULD NOT EXTEND WITH GEAR HANDLE. / REMOVED AND REPLACED LANDING GEAR CONTROL LEVER IAW CRJ 700 AMM 32-31-01-000/400-802. OPERATIONAL CHECK GOOD. REMOVED AND REPLACED LANDING GEAR SELECTOR VALVE IAW CRJ 700 AMM 32-32-10-00SDR CALA2025092909365Battery Pack · no testEMEGENCY PASSENGER CABIN LIGHTS M1695 FAILS BATTERY CAPACITY CHECK. REMOVED AND REPLACED NEW BATTERY PACK M1695 IAW AMM 33-51-06-960-805. OP TEST GOOD.SDR ASAA2025092361098Bulb · inoperativeEMERGENCY EXIT BULBS INOP L2 AND FWD RIGHT OVERWING EXIT LOWER LIGHT. GROUNDED - YES. TRANSFERRED TO AAR MIG-5 #OK436622.SDR YENA2025092600966A/C Pack · odorFLT#8400, BNA-BOS. (AIRCRAFT PERFORMED AN AIR TURNBACK TO BNA) STRONG CHEMICAL ODOR ON TOFF.O2 MASKS DONNED; COMPLIED WITH INFORMATION NOTICE 2017-T015,SECTION B1.IDENTIFIED ODOR AT BOTH PACKS.DECONTAMINATION LEVEL A WAS ACCOMPLISHED PER TSM 05-50-00.AIRCRAFTSDR SWAA2025092617716Cover · missingFWD GALLEY EXIT LT COVER MISSING. F/O SIDE<[01] R & R EXIT LIGHT ASSY PER AMM 33-51-01; OPS CHKED GOOD.SDR SWAA2025092617330Seal · crackedRIGHT HORIZONTAL STAB FWD UPPER SLIDING SEAL CRACKED. R & R RT HORIZONTAL STAB FWD UPPER SLIDING SEAL. IAW AMM 53-31-31.SDR AALA202509268856Light · no testAIRCRAFT IN BASE MAINTENANCE: SEAT 31C SIDE EMERGENCY LIGHT INOPERATIVE. EMERGENCY LIGHT AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-19.SDR CALA2025092609308Actuator · faultedRECEIVED A TAKEOFF CONFIG WARNING, MAIN GEAR STEERING EICAS BELOW 30 KNOTS REGUEST MEL 3253A, MEL PROCEDURE PERFORMED. APPROVED ITEM DEFERRED. CHRONIC LVL 1 FOR MAIN GEAR STEERING WITH MAINT MSG 32-63010. MAIN GEAR STEERING POWER CONTROL ACTUATOR LT IS UNSERSDR CALA2025092609293Bracket · crackedRIGHT FWD CARGO COMPARTMENT AT AFT AIR CONDITIONING DISTRIBUTION BAY AT BS 500I, STR 19R HAS BRACKET CRACKED. REMOVED AND REPLACED RIGHT FWD CARGO COMPARTMENT GUSSET AT AFT AIR CONDITIONING DISTRIBUTION BAY AT BS 500I, STR 19-R IAW SRM 51-40-02-0G-0 AND DWG SDR CALA2025092609292Fitting · crackedFLIGHT DECK RT CONTINUITY FITTING HAS CRACK INDICATION APPROX .400 INCH FROM CTR POST. REPLACED CONTINUITY FITTING IAW EA 5310-07675 004.SDR CALA2025092609280Girt Bar · no discrepancyGIRT BAR, R1 DOOR ALIGNMENT OFF. GIRT BAR ALIGNMENT BETWEEN SLIDE BRACKETS SEEMED OFF TO F/A. OPS CHECKED OPERATION ON ARRIVAL. NO ISSUES NOTED. SET AND REMOVED BAR FROM BRACKETS SEVERAL TIMES WITHOUT ISSUE. IAW TASK 25-66-02-000-801SDR CALA2025092609279Girt Bar · fodFA REPORTS DOOR R1 HARD TO DISARM. CLEARED DEBRIS AWAY FROM R1 DOOR GIRT CLIPS. NO DEFECTS NOTED, OK TO CONTINUE.SDR AALA202509251534Battery · dischargedAIRCRAFT WAS NOT GROUNDED: DURING ETOPS INSPECTION FOUND F/A JUMPSEAT FLASHLIGHTS NOT WORKING BY L1 DOOR AND AFT L2 DOOR. MAINTENANCE REPLACED F/A JUMPSEAT FLASHLIGHTS BATTERIES BY L1 DOOR AND AFT L2 DOOR IAW AMM 25-64-00.SDR AALA202509256803Power Supply · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHTS FROM SEATS 13 TO 24 ARE INOPERATIVE. MAINTENANCE REPLACED POWER SUPPLY BATTERY PACK M33401 AMM 33-51-06.SDR ASAA2025092361097Lens · missingROW 16 ABC EXIT SIGN MISSING. GROUNDED - YES. INSTALLED EXIT SIGN LENS COVER AT 16A OPS TEST NORMAL PER AMM 33-51-00.SDR HALA20250925289Sensor · faultedETOPS - COCKPIT TEMP CONTROLLER DOES NOT KEEP STABLE TEMPERATURE. REMOVED AND REPLACED TEMP SENSOR (651HK) IAW AMM 21-63-17. OPS CHECK GOOD. AC OKAY FOR SERVICE.SDR GTIA2025092539090Unknown · odorAFTER FUME EVENT FROM APPROX 22000 FT UNTIL LANDING DISAPUTED AFTER TOUCHDOWN . DESCRIPTION OF ODOR/FUMES: PERSISTENT, MUSTY DRY/DIRTY SOCKS/MOLDY SMELL. APPARENT CABIN SOURCE: UNKNOWN. MID CABIN, AFT CABIN, GALLEY, LAV, FWD CABIN, AND PAX SEATS. NO VISIBLE SMSDR GTIA2025092539089Flashlight · inoperativeL1 FLASHLIGHT INOPERATIVE. R & R L1 FLASHLIGHT IAW EMERGENCY EQUIPMENT LAYOUT NKS DRAWING. NO DEFECTS NOTED, THIS CLEARS DMI, MOC NOTIFIED, PLACARD REMOVED, DMI LOG UPDATEDSDR GTIA2025092539088Engine · making metalDURING CLIMB OUR RECEVED OIL QTY ADV FOUNDED BY DECREASING OIL QTY FOUNDED BY ENG 1 OIL LOW PRESSURE ECAM. FLIGHT CREW FOLLOW ECAM AND SHOUTDOWN ENG 1 -METAL WAS DISCOVERED IN THE ENG 2 CHIP DETECTOR. ATL MX HAS QUARANTINED BOTH THE CHIP DETECTOR AND THE FILSDR AALA202509252855Elec Connector · damagedAIRCRAFT WAS NOT GROUNDED: ROW 4AB SEAT AISLE EMERGENCY LIGHTS INOPERATIVE. REPAIRED CONNECTOR, PER TSM 33-50-00. OPERATIONAL CHECK GOOD.SDR AALA202509255838Wire · looseAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHTING WIRING ON SEAT 20C LOOSE. RESTOWED EMERGENCY EXIT LIGHTING WIRING IN CLIPS ON SEAT 20C. PER AMM 33-51-11.SDR AALA202509259393Air Filter · contaminatedAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTED STRONG ODOR ON TAKEOFF AND ON CLIMB OUT THAT SMELLED LIKE DIRTY SOCK. GOT BETTER IN CRUISE AND WORSE ON DESCENT. FOUND LEAKING GREY WATER HOSE ABOVE LEFT HAND RECIRCULATING FAN FILTER. REMOVE AND REPLACED HOSDR AALA202509257830Insulation · contaminatedAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTED STRONG ODOR ON TAKEOFF AND ON CLIMB OUT THAT SMELLED LIKE DIRTY SOCK. GOT BETTER IN CRUISE AND WORSE ON DESCENT. FOUND LEAKING GREY WATER HOSE ABOVE LEFT HAND RECIRCULATING FAN FILTER. REMOVE AND REPLACED HOSDR AALA202509257742Fan · contaminatedAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTED STRONG ODOR ON TAKEOFF AND ON CLIMB OUT THAT SMELLED LIKE DIRTY SOCK. GOT BETTER IN CRUISE AND WORSE ON DESCENT. FOUND LEAKING GREY WATER HOSE ABOVE LEFT HAND RECIRCULATING FAN FILTER. REMOVE AND REPLACED HOSDR AALA202509256714Hose · leakingAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTED STRONG ODOR ON TAKEOFF AND ON CLIMB OUT, THAT SMELLED LIKE DIRTY SOCKS. GOT BETTER IN CRUISE AND WORSE ON DESCENT. FOUND LEAKING GREY WATER HOSE ABOVE LT RECIRCULATING FAN FILTER. REMOVE AND REPLACED HOSESDR AALA202509251940Door Latch · out of adjustAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR IS VERY DIFFICULT TO OPEN. CLEANED AND ADJUSTED DOOR LATCH. OPERATIONAL CHECK NORMAL.SDR DALA2025092506984Skin · ground damageA GROUND VEHICLE HOSE CONTACTED THE AIRCRAFT ON THE FUSELAGE BETWEEN FR2 AND FR4, ABOVE Y330 RT. CORRECTIVE ACTION: COMPLIED WITH ER/A 628044-14. (1213648).SDR DALA2025092506983Crossbeam · crackedCRACK INDICATION ON CROSS BEAM IN PASSENGER CABIN, ON FR 16 L, HOLE H3. CORRECTIVE ACTION: COMPLIED WITH ER/A 628546-14AD. (1214415).SDR DALA2025092506982Stringer · corrodedCORROSION STRINGER 42R BTW FR 59 TO FR 60 AFT CARGO COMPARTMENT. REPLACED STRINGER 42R AND FASTENER LOC BTW FR59 TO FR64 AFT CARGO COMPARTMENT AS PER A319 SRM 51-42-11 AND A319 SRM 51-72-11. (1214470).SDR DALA2025092506981Skin · ground damageA GROUND VEHICLE HOSE CONTACTED THE AIRCRAFT ON THE FUSELAGE BETWEEN FR2 AND FR4, ABOVE Y330 RH. COMPLIED WITH ER/A 628044-14. (1213814).SDR AALA202509254250Battery · no testAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT AT FLIGHT ATTENDANT JUMP SEAT 2R INOPERTIVE. REPLACED FLASHLIGHT BATTERY PER AMM 25-00-00.SDR JJBA20250925040Battery Pack · inoperativeLEFT LOWER EMERGENCY LIGHT INOPERATIVE. FOUND INOPERATIVE EMERGENCY LIGHTS ABOVE MCD ENTRY WAY AND IN AISLE ABOVE ROW 3. REMOVED AND REPLACED BPS #1. ALL OPS CHECKS GOOD.SDR DXTA2025092505060Light · inoperativeAISLE EMERGENCY LIGHTS UNDER SEAT 5 IS NOT ILLUMINATING. GAINED ACCESS TO SEAT 5 AISLE EMERGENCY LIGHT AND STARTED GETTING ACCESS FOR R/R.OBSERVED INOP LIGHT ASSY CABLES HAD MULTIPLE ZIP TIES ALONG ITS PATH. HAD TO REMOVED SEAT 5 LOWER COVERING PANELS AND HOUSDR CALA2025092509262Anti-Ice Valve · faultedENGINE COWL ANTI-ICE LIGHT ON AT 60KTS, ABORTED TAKEOFF, LIGHT WENT OUT 160.1 POWER WAS PULLED BACK AND LIGHT WENT OFF. CREW UNABLE TO SAY WHICH SYSTEM HAD THE AMBER LIGHT ILLUMINATED. CREW REPORTED UNABLE TO TELL WHICH SIDE, MAYBE RT BUT BOTH PILOTS UNABLESDR CALA2025092509259Rib · corrodedUPON REMOVAL OF UPPER SPAR AFT WEB FIVE HAS CORROSION. LOCATED AND DRILLED NEW #1 AFT FAIRING FOR #1 AFT MOVABLE FAIRING IAW SRM 51-44-11 TO INSTALLED ON NR 375421/24337/9292337.