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 JJBA20251125105Floor Support · corrodedRH SILL #6 CORRODED BTW FR 53-59. BTW FR 53-54 RH SILL #6 BLENDED OUT OF LIMITS. RH SILL #6 BTW FR 53-39 REMOVED AND REPLACEDSDR CALA2025112511440Shield · corroded{B737-06-3-3686} FWD CARGO COMPARTMENT FLOOR STRUCTURE SHIELD BTW STA. 500 AND 500A HAS CORROSION NEEDS TO BE REPLACED. (REF AAR NR 1000057632). REMOVED, LOCATED, DRILLED, AND INSTALLED NEW FLOOR STRUCTURE SHIELD BTW STA. 500 AND 500A (P/N 143A8126Y29) IAW DWGSDR SWAA2025112034436Access Panel · crackedCRACK ON ACCESS PANEL 344GB AT RT HORIZONTAL STABILIZER. REPLACED ACCESS PANEL 344GB IAW B737-700 AMM 27-31-00-200-801 STEP 7.D(6).SDR DALA2025112008488Apu · odorATB/FUME - RETURNED TO JFK DUE TO ODOR IN CABIN. P-TRAK SNIFFER RESULTS INDICATE APU AS SOURCE OF THE ODOR. COMPLETED LEVEL B ECS DECONTAMINATION. DEFERRED APU PER MEL 49-10-01A. LATER, COMPLIED WITH CLEAN APU AIR INTAKE AND COMPARTMENT PER WORK CAR 4916-200SDR CALA2025112011353Girt Bar · fodR2 DOOR WILL NOT ARM. REMOVED FOD FROM UNDER GIRT, SLIDE ARMS AND DISARMS NORMAL. IAW AMM 52-11-01.SDR CALA2025111911332Floorbeam · corrodedAFT FLOORBEAM AT FR 68 RT CORROSION. REMOVED AND REPLACED AFT FLOORBEAM -Y1162, FRAME 68 RT IAW SRM 51-72-11-911.SDR DALA2025111808440Threshold · corrodedC1 DOOR THRESHOLD: LIGHT SURFACE CORROSION IN DOOR SILL AREA. REPLACED REPAIRED FORWARD CARGO DOOR LOWER JAMB PAN REF: B717-200 SRM 53-20-15-2R (1300666).SDR DALA2025111808423Heater · odorDURING CRUISE FLIGHT AN ODOR WAS OBSERVED COMING FROM AREA OF CAPT GASPER VENT AND SPEAKER AREA. SMELLED LIKE AN ELEC HEATER WHEN TURNED ON. REMOVED AND REPLACED CAPT SHOULDER AND FOOT HEATER PER B767 MM 21-45. OPS CHECKS GOOD. NO ODOR DETECT ON A/C ARRIVAL SDR DALA2025111808418Cover · detachedDURING SERVICE CHECK WALK AROUND, TAIL CONE SLIDE COVER WAS COMPLETELY UNLATCHED AND COVER WAS FULLY TO THE REAR. RESECURED CONTAINER ASSY LATCH IAW CMM 25-66-20, ALSO REF AMM 25-61. PER TOPP 40-30-05 APP J ABLE TO RESECURE AND NOT CONSIDERED RII EVENT. (7982SDR DALA2025111808417Slide · deflatedSLIDE IN TAIL CONE FOUND DEFLATED IN TAIL COMPARTMENT. REMOVED TAIL CONE SLIDE IAW AMM 25-61-02. INSTALLED NEW TAIL CONE SLIDE IAW WC 2561-9006 (7585377)SDR AALA202511181446Bumper Block · wornAIRCRAFT IN BASE MAINTENANCE: FORWARD ENTRY DOOR ON AFT DOOR FRAME ROLLER GUIDE FITTING HAS WEAR MARK. REMOVED AND REPLACED NEW BUMPER AT FORWARD ENTRY DOOR ON AFT DOOR FRAME ROLLER GUIDE FITTING. PER B737NG SRM 51-40--02-OG AND IPC 52-11-00-12.SDR AALA202511187841Skin Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT WING TOP SKIN PANEL UPPER SURFACE AT RIB 14. REPAIRED SKIN PANEL PER EA 368862.SDR AALA202511182054Escape Hatch · faultedAIRCRAFT IN BASE MAINTENANCE: RIGHT OVERWING EMERGENCY HATCH LIGHT FAULT, T/S REF TSM 33-51-810-809AWHEN RT OVR WING EMER HANDLE COVER IS OPENED/REMOVED (SLIDE ARMED LT IS ON)WHEN LATCH PIN IS TURNED 1/4 TURN CCW (SLIDE ARMED LIGHT STAYS ON, SHOULD GO OUT AND SDR AALA202511189792Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION LOWER SILL AT LEVEL STR23L BTW FR66 AND FR68 AT AFT GALLEY AREA.L:5.998 INCH W=2.106 INCH D=0.023 INCH. MAINTENANCE REPLACED LOWER SILL AT LEVEL STR23L BTW FR66 AND FR68 AT AFT GALLEY AREA IAW A319 SRM 51-42-11-801 AND SDR KCSA2025111800263Actuator · unserviceableGEAR DOOR, R & R RT BODY LANDING GEAR DOOR ACTUATOR IAW AMM 32-33-27. GEAR DOOR REMAINED INOPERATIVE. R & R BODY GEAR ALT-EXT ACTUATOR ROTARY IAW AMM 32-35-01. PERFORMED OPS CHECK IAW AMM 32-35-00. OPS CHECKED GOOD. RT BODY GEAR DOOR BUMP STOP MISSING BOLSDR CALA2025111711273Frame · dentedONE DENT ON THE BS 1560 FRAME BOTTOM, BETWEEN S26L & S27L. THE DENT MEASURES 0.750 INCH LONG, 0.600 INCH WIDE, AND 0.020 INCH DEEP. THIS DENT IS THE SUBJECT OF EA 5310-07582 AND ALSO AD 2020-05-25 PERFORM INSPECTIONS PER PART 2 OF THE LATEST REVISION OF ECRA SDR CALA2025111711263Anti-Ice Valve · faultedEAI PRSOV R, CREW STATED THAT THEY RECEIVED AN EICAS MESSAGE FOR RT ANTI-ICE VALVE BEING FAULTED IN THE CLOSED POSITION. TRIED MULTIPLE TIMES TO MANUALLY OPEN VALVE, ALL ATTEMPTS FAILED. REPLACED ENG 2 ENGINE ANTI-ICE PRESSURE SENSOR (P1) IAW AMM A-30-21-04 SDR CALA2025111711229Battery Pack · no testEMERGENCY LIGHT BATTERY PACK M1675 FAILED CAPACITY CHECK.POWER SUPPLY - BATTERY PACK CAPACITY CHECK POWER SUPPLY - BATTERY PACK CAPACITY CHECK - REPLACED BATTERY PACK IN M1675 POWER SUPPLY. RE-RAN CAPACITY CHECK ON M1675, LASTED ONLY 10 MINUTES. CONTINUED DISCSDR N6WA2025111501Mount Bracket · crackedPASSENGER DOOR POWER ASSIST MOTOR LOWER MOUNT BRACKET CRACKED. REPLACED PAX DOOR POWER ASSIST MOTOR LOWER MOUNT BRACKET IAW CRJ SRM 52-11-04SDR 2025FA0000757Controller · malfunctionedON 11/12/2025, N924PS DEPARTED KMAF HEADING TO KDRO. ON CLIMB THE CAPTAIN REPORTED THE PRESSURIZATION SYSTEM SEEMED LIKE THE AIRCRAFT WAS NOT PRESSURIZING. HE THEN ELECTED TO RETURN TO KMAF. THE AIRCRAFT LANDED SAFELY, ATI MAINTENANCE ARRIVED AT MAF TO TEST THSDR SWAA2025111434447Data Plate · looseCUSTOMER REQUEST LOOSE RIVETS AT PLACARD DATA ON OUTBOARD SIDE ENGINE 2<2025-671319SDR 6CBA2025111425001Circuit Breaker · trippedDURING A SCHEDULED FLIGHT FROM KBVU TO KIWS, THE CREW WAS CLIMBING OUT OF KBVU AND CREW NOTED THAT THE LANDING GEAR WOULD NOT RETRACT. THEY FOUND THE CIRCUIT BREAKER FOR THE LANDING GEAR WAS OUT. THE CREW DIVERTED BACK TO KBVU AND LANDED WITHOUT INCIDENT. TSDR IPXA2025111229656Computer · faultedEMERGENCY DECLARED, AUTO FUEL FAULT IN FLIGHT RAN QRH PROCEDURES AFTER EVALUATING FUEL QUANITY WE SAW OUTER FUEL @ 4700 REVIEWED FUEL IMBALANCE CHECK BALANCEED FUEL UPON LANDING OUTER FUEL TANK SHOWED 8200 LBS. T/S AUTO FUEL FEED FAULT PREFORMED AUTO FUSDR SWIA2025111400002Warning Message · illuminatedGEAR DISAGREE WARNING ON TAKEOFF WITH GEAR HANDLE SELECTED UP. ALL 3 GEAR STAYED DOWN AND LOCKED. RAN QRH AND RETURNED TO DEPARTURE POINT. (FLIGHT 4062) THIS DISCREPANCY WAS TRANSFERRED TO CAMP ITEM 31180672. REFERENCE CP 31182373 AND CP 31182349 FOR CSDR AALA202511142195Battery · no testAIRCRAFT IN BASE MAINTENANCE: BATTERY FAULT FOR EMERGENCY POWER SUPPLY UNIT 15WL DURING SYSTEM TEST. REPLACED BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR AALA202511144496Sliding Window · out of adjustAIRCRAFT IN BASE MAINTENANCE: FLIGHT DECK LEFT HAND SLIDING WINDOW DIFFICULT TO CLOSE. MAINTENANCE ADJUSTED THE SLIDING WINDOW HANDLE AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 56-12-11.SDR SIMA202511142002Door · lack of lubeL1 PAX DOOR STUCK, IT WON'T OPEN PROPERLY ONCE THE OUTSIDE HANDLE IS ALL THE WAY UPWARDS PERFORMED LUBRICATION OF L1 PAX DOOR IAW AMM 12-26-00 OPS CHECK GOOD IAW AMM 52-11-00.SDR CALA2025111411220Battery Pack · dischargedEMERGENCY LIGHTS OVER SEAT ROWS 32 AND 36 DEF INOP. SUPPORT TASK NSA EMX NR 00051. REMOVED UNSERVICEABLE BATTERY PACK PN AD-D717-01-100 SN 179187 A T BATTERY SUPPLY M1899 AND INSTALLED SERVICEABLE BATTERY PACK PN AD-D717-01-100 SN 371771 IAW B737-900 AMM 33-51SDR CALA2025111411218Wire Harness · damagedFLIGHT READINESS CHECK (REVISED BY EC0500-01360E) PROCEDURE, FOUND FOUR RED EMERGENCY EXIT LIGHTS AT SEATS 15C, 20C, AND 21C WILL NOT ILUMINATE. AT SEAT 15C, FOUND RED-WHITE EEPL HARNESS INTERMITTENLY SHORTING IAW CMM 25-21-68, WDM FIGURE 2011, SHEET 2, PAGE SDR CALA2025111411206Pitot Tube · faultedAUX PITOT CAUTION MESSAGE, FOUND C/B K16 TRIPPED, CAPTAIN'S PITOT PROBE HEAT, AUX PHASE B. C/B K16 (C01873) PITOT PROBE HT, AUX PHASE B T/S IAW FIM 30-31-00-815-814-001. R & R RT AUX PITOT PROBE IAW AMM 34-11-01.SDR CALA2025111411204Girt Bar · dirtyL2 DOOR GIRT BAR IS EXTREMELY HARD TO DISARM, TOOK TWO PEOPLE. CHECKED AND FOUND GIRT BAR DIFFICULT TO REMOVE FROM RETAINING CLIPS DUE TO BUILD UP OF GRIME. CLEANED THE GIRT BAR FLOOR BRACKETS, FOUND CLEAN AND OK. GIRT BAR OPERATES NORMAL IAW AMM 25-66-02-4SDR CALA2025111411203Warning Message · false activationDOOR ENTRY 4L ADVISORY L4 PASSENGER ENTRY DOOR NOT FULLY CLOSED, LATCHED, OR LOCKE D. DOOR ENTRY 4L EICAS CABIN ALT NORMAL 5800FT 8.6 AT FL360 FOUND NO ACTIVE MSGS, NO HISTORY. PROX SENSOR CLEARANCE WITHIN RANGE (~2.0MM). OK TO CONTINUE. REF AMM 52-71-01 & FIMSDR CALA2025111411202Door · damagedFWD CATERING DOOR, SEEMS TO BE SCUFFS ON THE AIRCRAFT SCUFF MARKS WERE ONLY TO SURFACE FINISH. APPLIED FINISH REF AMM 51-21-99. NO FURTHER ACTION REQUIREDSDR CALA2025111411201Slide · no discrepancyL2 DOOR HAS EXCESSIVE SLIDE HANGING OUT. UTILIZED RENDER SAFTEY CHECKLIST, INSPECTED 2L SLIDE PACK, NO EXCESS MATERIAL NOTED IAW AMM 25-66-01.SDR CALA2025111411200Slide · no discrepancyR1 DOOR EXCESSIVE DOOR SLIDE MATERIAL SHOWING. INSPECTED SLIDE IAW AMM 25-66-01, NO DEFECTS FOUND, SLIDE WITHIN AMM PARAMETERS, OK TO CONTINUESDR CALA2025111411199Slide · unpackedDOOR 1R SLIDE PACK PARTIALLY OUT ITEM LOCKED UNLOCK. REPACKED R1 DOOR ESCAPE SLIDE IAW AMM 25-66-01-200-802 & AMM 25-66-01-400-801 FOR INSTALLATION OF SLIDE PACK.SDR CALA2025111411198Slide · unraveledDOOR 1R SLIDE PACK PARTIALLY OUT. LOCAL FBO TO PACK DOOR 1R SLIDE PACK. REPACKED R1 DOOR SLIDE IAW AMM REF 25-66-01.SDR CALA2025111411197Sign · detachedEXIT SIGN FALLING OFF ABOVE ROW 20DEF CHECKED EMERGENCY EXIT SIGN ABOVE EXIT DOOR FOR OPERATION AND VERIFIED PANEL ABOVE ROW 20 DEF SECURED.SDR CALA2025111411196A/C Pack · odorSTRANGE ODOR FROM PACKS WHILE DESCENDING THRU 8000 UNTIL LANDING RAN BOTH PACKS FOR A WHILE, UNABLE TO DUPLICATE THE SMELL.SDR ASAA2025111262279Snubber · out of sequenceON PREFLIGHT L2 DOOR WILL NOT OPEN. GROUNDED - YES. FOUND SNUBBER OUT OF SEQUENCE, RESET SNUBBER DOOR OPENS AND CLOSES AS REQUIRED.SDR HYIA20251113001Blade · crackedDURING DISASSEMBLY FOR SCHEDULED OVERHAUL A CRACK WAS IDENTIFIED AT A SINGLE BLADE ROOT. MULTIPLE BEARING RACES WERE FOUND TO BE CORRODED AND FAILED.SDR SWIA20251113002Landing Gear · faultedGEAR DISAGREE WARNING ON TAKEOFF WITH GEAR HANDLE SELECTED UP. ALL 3 GEAR STAYED DOWN AND LOCKED. RAN QRH AND RETURNED TO DEPARTURE POINT. OPEN.SDR SWAA2025111334377Sign · brokenMID CABIN CEILING EXIT SIGN COVER BROKEN. ATTACHED COVER AS NECESSARY PER SIP.SDR SWAA2025111334423Flashlight · inoperativeTWO AFT F/A FLASHLIGHTS INOPERATIVE. ONE ON CAPTS SIDE, & ONE ON F/O SIDE. RESEATED & RESEALED OPS CHECKED GOOD IAW MM 25-64-00.SDR SWAA2025111334487Bottle · low pressureFORWARD ENTRY DOOR SLIDE C02 LOW CHARGE.. R&R FWD ENTRY DOOR SLIDE IAW MT 25-66-01-FE-REPLSDR SWAA2025111334157Seal · crackedRT HORIZONTAL STAB UPPER SLIDING SEAL CRACKED. REMOVED AND REPLACED RH HORIZONTAL STAB UPPER SLIDING SEAL REF AMM 53-31-31.SDR SWAA2025111334156Seal · crackedLEFT HORIZONTAL STAB UPPER SLIDING SEAL CRACKED. REMOVED AND REPLACED SLIDING SEAL AND OPS CHECKED GOOD IAW AMM 53-31-31.SDR SWAA2025111334158Battery Pack · no testAFT L/H EMERGENCY LIGHTING BATTERY PACK FAILED THE CAPACITY CHECK. REMOVED AND REPLACED BATTERY PACK PER M/M 33-51-06.SDR SWAA2025111334420Glowstrip · detachedPHOTOLUMINESCENT STRIP FELL OFF AIRCRAFT. RESECURED PHOTO LUMINESCENT STRIP AT ROW 1-2DEF PER SIP.SDR SWAA2025111334768Sign · detachedEMERGENCY OVERWING EXIT SIGN ON CEILING FELL DOWN. SECURED THE SIGN IAW SIP.