Boeing 737-823
Service difficulty reports · 31,890
Newest first. 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' WHERE aircraft_model_key = '737823' 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' WHERE aircraft_model_key = '737823' 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 AALA202504045268Sign · missingAIRCRAFT WAS NOT GROUNDED: EXIT SIGN LIGHT NEXT TO LAVATORY-D MISSING THE SIGN THAT SAYS EXIT. REMOVED AND REPLACED EXIT SIGN LIGHT NEXT TO LAVATORY-D. OPERTIONAL CHECKED GOOD. PER AMM 33-51-01.SDR AALA202504042132Cap · missingAIRCRAFT WAS GROUNDED: 1R DOOR GIRT BAR RIGHT HAND SAFETY CAP MISSING. INSTALLED NEW STOP RELEASE (AALA202504042132), PIN (AALA202504049949), AND A HEAT SHRINK TUBING (AALA20250404063) ON FORWARD RIGHT HAND DOOR SLIDE GIRT BAR. PER AMM 25-66-01 AND EO-2523J012SDR AALA202504046598Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER AT STA 663.75, FROM RBL 45.64 TO RBL 54.21. REPAIRED VAPOR BARRIER PER SRM 57-10-10-2R-2.SDR AALA202504040462Retainer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND WHEEL WELL CUT OUT SEAL RETAINER AT BS 727, RBL 39. REMOVED, FABRICATED, AND INSTALLED WHEEL WELL CUT OUT SEAL RETAINER PER SRM 51-40-02-0G.SDR AALA202504041148Retainer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND WHEEL WELL CUT OUT AFT SEAL RETAINER AT BS 727, RBL 57. REMOVED, FABRICATED, AND INSTALLED WHEEL WELL CUT OUT SEAL RETAINER PER SRM 51-40-02-0G.SDR AALA202504168402Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR SUPPORT BREAK ASSEMBLY PANEL AT STA 540, RBL 15. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-1.SDR AALA202504114334Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION PASSENGER CABIN FLOOR BEAM AT BS 294.5 FROM RBL 6 TO LBL 6. REPAIRED FLOOR BEAM PER SRM 53-10-51-2R-14SDR AALA202504077985Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT BAFFLE CLIP AT STA 500E, LBL 26. REPLACED BAFFLE CLIP PER AARD 51-00-05-1.SDR AALA202504036967Skin · crackedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND SIDE OF FUSELAGE SKIN AT EXTERNAL POWER PANEL ACCESS DOOR CUTOUT CRACKED AT STA 224, S20R. ACCOMPLISHED DOUBLER REPAIR PER SRM 53-10-15-2R-4.SDR AALA202504031746Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM STA 500A TO STA 500I AT S24R. REPLACED TRANSITION PANEL PER SRM 51-40-02-0G.SDR AALA202504039391Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM STA 480 TO STA 500I AT S24R. REPLACED TRANSITION PANEL PER SRM 53-00-53.SDR AALA202504034529Door · dislodgedAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR OFF TRACK AND DIFFICULT TO OPEN AND CLOSE. REINSTALLED LAVATORY-D DOOR. OPERTIONAL CHECKS GOOD. PER CMM 25-40-64.SDR AALA202504030059Door · jammedAIRCRAFT WAS GROUNDED: LEFT HAND AFT ENTRY DOOR RIGGING OF LOWER HINGE ARM AND SNUBBER ALIGNMENT QUESTIONABLE, CAUSING DOOR TO JAM HALFWAY THROUGH OPENING. PHYSICALLY SHIMMYING THE DOOR RELEASES THE JAM TO FULLY OPEN DOOR. CHECKED AND CLEAN AND LUBE ALL DOOR HSDR AALA202504039326Sliding Window · dislodgedAIRCRAFT WAS GROUNDED: WINDOW DETACHED FROM IT HINGES ON TAKEOFF. AIRCRAFT REJECT TAKEOFF AROUND 100KTS. INSTALLED WINDOW VERIFIED HANDLE FORCE WITHIN LIMITS PER AMM 56-12-11-820-801 SUB TASK 820-004.SDR AALA202504083024Oven · smokeAIRCRAFT WAS NOT GROUNDED: GALLEY OVEN NUMBER 2 SMOKES EXCESSIVELY, UNUSABLE. ACCOMPLISHED OPERATIONAL CHECK OF NUMBER 2 OVEN PER A.M.M 25-32-02 IN BOTH LOW AND HIGH HEAT WITH NO SMOKE OR DEFECTS NOTED.SDR AALA202504071470Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT BAFFLE BETWEEN STA 500G AND STA 500F AT S26L. REPLACED BAFFLE PER AARD 51-00-05-1.SDR AALA202504074561Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT SHIELD FROM STA 767 TO STA 787 AT RBL 25. REPLACED SHIELD ASSEMBLY PER AARD 51-00-05-1.SDR AALA202504032109Skin · wornAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND SIDE OF FUSELAGE SKIN AT EXTERNAL POWER PANEL ACCESS DOOR TORN FROM STA 225 TO STA 235, S24R. REPAIRED SKIN PER SRM 53-10-15-2R-4.SDR AALA202504032939Web · corrodedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND WHEEL WELL CUT OUT WEB HAS CORROSION AT BS 667, RBL 57. REPAIRED PER SRM 51-40-02-0G.SDR AALA202504036443Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER ATTACH ANGLE AT STA 663, LBL 10. REPAIRED ATTACH ANGLE PER SRM 57-10-10-2R-5.SDR AALA202504031764Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER ATTACH ANGLE AT STA 663, LBL 10. REPAIRED ATTACH ANGLE PER SRM 57-10-10-2R-5.SDR AALA202504033915Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR SUPPORT BRACKET AT BS 540 FROM LBL 0 TO LBL 3. REPLACED FLOOR SUPPORT BRACKET PER SRM 51-40-02.SDR AALA202504031071Rib · wornAIRCRAFT IN BASE MAINTENANCE: WEAR TO RIGHT HAND HORIZONTAL STABILIZER RIB FITTING AT STABILIZER STA 195. REPLACED RIB FITING PER SRM 51-40-02-0G.SDR AALA202504020969Slide · wornAIRCRAFT IN BASE MAINTENANCE: R1 SLIDE PACK HAS DAMAGED AND WEAR ON GIRT MATERIAL. REMOVED UNSERVICEABLE SLIDE AND INSTALLED NEW SERVICEABLE SLIDE. PER AMM 52-66-01.SDR AALA202504029595Girt Bar · lack of lubeAIRCRAFT WAS NOT GROUNDED: RIGHT AFT ENTRY DOOR GIRT BAR CLIPS ARE VERY TIGHT MAKING IT DIFFICULT TO SECURE THE GIRT BAR. LUBRICATED LEFT AFTER DOOR GIRT BAR CLIPS. PER AMM 25-66-01.SDR AALA202504029668Light · dislodgedAIRCRAFT WAS NOT GROUNDED: SEAT 10C ESCAPE PATH LIGHTING HANGING DOWN BY WIRE. REPLACED 10C SEAT MOUNTED ENERGENCY LIGHT. PER AMM 33-51-11.SDR AALA202504022621Unknown · unknownAIRCRAFT WAS GROUNDED: FUEL IS CONTINUOUSLY GOING INTO THE CENTER TANK WITH CENTER PUMPS OFF. FUEL WILL NOT BURN BELOW 0.20 IN CENTER TANKS WITH PUMPS ON. NO FAULTS FOUND. PER FIM TEST TASK 28-41-00-810-801.SDR AALA202504020048Girt Bar · lack of lubeAIRCRAFT WAS NOT GROUNDED: LEFT AFT ENTRY DOOR GIRT BAR CLIPS ARE VERY TIGHT MAKING IT DIFFICULT TO SECURE THE GIRT BAR. LUBRICATED LEFT AFT GIRT BAR ATTACHMENT TO SLIDE. PER MM 25-66-01.SDR AALA202504023024Oven · smokeAIRCRAFT WAS NOT GROUNDED: GALLEY OVEN NUMBER 2 SMOKES EXCESSIVELY, UNUSABLE. (OPEN).SDR AALA202504024072Landing Gear · malfunctionedAIRCRAFT WAS NOT GROUNDED: SHUT DOWN ENGINE NUMBER 2 DURING TAXI IN. CAME TO A STOP PRIOR TO GATE TO WAIT FOR TAMPERS. ONCE IN PLACE, RELEASED PARKING BRAKE ANDAIRCRAFT WOULD NOT MOVE. ADVANCED THRUST TO 50 PERCENT AND NOTHING. STARTED THE NUMBER 1 ENGINE AND SDR AALA202505016604Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN BAFFLE CLIP AT BS 500H, RBL 25. REPLACED BAFFLE CLIP PER AARD 51-00-05-1SDR AALA202504141216Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR SUPPORT BREAK ASSEMBLY PANEL AT BS 540, RBL 2. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-1.SDR AALA202504146575Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR SUPPORT BREAK ASSEMBLY PANEL AT BS 540, LBL 2. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-1.SDR AALA202504078346Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT BAFFLE FROM STA 500E TO STA 500F AT RBL 25. REPLACED BAFFLE PER AARD 51-00-05-1.SDR AALA202504070317Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM STA 312 TO STA 328 AT RBL 32. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202504017331Bracket · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD ENTRY GIRT BAR BRACKET DOES NOT SECURELY HOLD THE GIRT BAR. ADJUSTED FORWARD ENTRY GIRT BAR BRACKET. PER AMM 25-66-02.SDR AALA202504011394Light · unsecureAIRCRAFT WAS NOT GROUNDED: 20C AISLE EMERGENCY EXIT LIGHT LOOSE. RESECURED EMERGENCY ISLE LIGHT AT 20C, OPERTIONAL CHECK GOOD. PER AMM 33-51-00.SDR AALA202504019957Light · missingAIRCRAFT WAS NOT GROUNDED: ROW 15 (LEFT SIDE) EMERGENCY LIGHT MISSING. REPOSITIONED LIGHT.SDR AALA202504014605Transfer Valve · openAIRCRAFT WAS NOT GROUNDED: UNWANTED FUEL TRANSFER TO CENTER TANK. CANNOT DETERMINE WHICH TANK IS DOING IT. BURNED TO 0, BUT IT HAS ADDED UP TO 380 LBS. FOUND CENTER FUEL VALVE OPEN ON FUELING PANEL CLOSED VALVE CHECKED FOR UNWANTED TRANSFER NO TRANSFER. PER MMSDR AALA202504014712Trim Panel · unsecureAIRCRAFT WAS NOT GROUNDED: FIRST CLASS LAVATORY DOOR STICKING. FOUND FIRST CLASS LAVATORY DOOR METAL TRIM PIECE RUBBING AGAINST DOOR. RESECURED DOOR TRIM. PER CMM 25-00-00.SDR AALA202504018103Processor · faultedAIRCRAFT WAS GROUNDED: FLIGHT CREW REPORT OF "CHECK FMC FUEL QUANTITY" MESSAGE ON FMC AND FUEL QUANTITY. ACCOMPLISHED BITE CHECK OF FQP, PER FIM 28-41-00-810-801 AND FMC, PER FIM 34-61-00-810-801. NO FAULTS NOTED FROM BOTH COMPUTERS. SUMPED ALL TANKS, NO SIGNISDR AALA202504017364Elec Connector · disconnectedAIRCRAFT WAS NOT GROUNDED: AISLE EMERGENCY FLOOR PROXIMITY LIGHTS INOPERATIVE FROM SEATS 28ABC TO SEATS 33ABC. FOUND CONNECTOR D95035 DISCONNECTED UNDER SEAT 28ABC. RECONNECTED, PER WDM 33-51-22. PERFORMED EMERGENCY LIGHT OPERTIONAL CHECK GOOD AT ROW 28ABC TO SDR AALA202504011898Slide · partial deployAIRCRAFT WAS GROUNDED: L1 DOOR INADVERTENTLY PARTIALLY OPENED WITH SLIDE ARMED. INSPECTED GIRT BAR RETAINERS. NO DAMAGE FOUND. REMOVED AND REPLACED L1 DOOR SLIDE, PER WORK CARD 08L22125001.SDR AALA202504102846Hook · corrodedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND AND RIGHT HAND AFT EMERGENCY DOOR ESCAPE STRAP LANDYARD HOOKS CORRODED. REMOVED AND REPLACED LEFT HAND (AALA202504109668) AND RIGH HAND (AALA202504102846) AFT EMERGENCY DOOR ESCAPE STRAP LANYARD ASSEMBLY. PER B737 NG AMMSDR AALA202504109668Hook · corrodedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND AND RIGHT HAND AFT EMERGENCY DOOR ESCAPE STRAP LANDYARD HOOKS CORRODED. REMOVED AND REPLACED LEFT HAND (AALA202504109668) AND RIGH HAND (AALA202504102846) AFT EMERGENCY DOOR ESCAPE STRAP LANYARD ASSEMBLY. PER B737 NG AMMSDR AALA202504026325Locking Cam · fodAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR INTERMITTENTLY GETS STUCK OR JAMMED IN A CLOSED POSITION, DIFFICULT TO OPEN. CONFIRMED BY MX THAT LAVATORY-D DOOR STICKS AND DIFFICULT TO OPEN. REMOVED DEBRIS FROM LOCKING MECHANISM AND CLEANED. OPERTIONAL CHECK GOODSDR AALA202504016325Door · bindingAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR INTERMITTENTLY GETS STUCK OR JAMMED IN A CLOSED POSITION, DIFFICULT TO OPEN. CONFIRMED BY MX THAT LAVATORY-D DOOR STICKS AND DIFFICULT TO OPEN. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202504019352Locking Cam · dirtyAIRCRAFT WAS NOT GROUNDED: 1L ENTRY DOOR GIRT BAR IS DIFFICULT TO LATCH AND UNLATCH. CLEANED L1 DOOR GIRT BAR RETAINER CLIPS. PER AMM 25-66-01. FUNCTIONAL CHECK GOOD. NO DEFECTS NOTED AT THIS TIME.SDR AALA202504017335Door Latch · unsecureAIRCRAFT WAS NOT GROUNDED: AFTER LEFT LAVATORY INNER DOOR LATCH IS DIFFICULT TO LATCH AND UNLATCH. RESECURED AFT LEFT HAND LAVATORY DOOR LATCH. PER AMM 25-40-14.SDR AALA202503313870Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR SUPPORT BREAK ASSEMBLY PANEL AT BS 540, LBL 3. REPLACED BREAK ASSEMBLY PANEL PER SRM 51-40-02.
Back to Boeing 737-823