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 AALA202302136981Guide Arm · frozenAIRCRAFT WAS GROUNDED: FORWARD ENTRY DOOR HAD TO BE CYCLED TO EXTINGUISH FORWARD ENTRY DOOR LIGHT ON OVERHEAD PANEL. MAINTENANCE FOUND L1 DOOR GUIDE ARM FROZEN. REPLACED GUIDE ARM ASSEMBLY (AALA202302136981) PER AMM 52-11-21. ADJUSTED DOOR SENSOR (AALA20230213SDR AALA202302133587Sensor · out of adjustAIRCRAFT WAS GROUNDED: FORWARD ENTRY DOOR HAD TO BE CYCLED TO EXTINGUISH FORWARD ENTRY DOOR LIGHT ON OVERHEAD PANEL. MAINTENANCE FOUND L1 DOOR GUIDE ARM FROZEN. REPLACED GUIDE ARM ASSEMBLY (AALA202302136981) PER AMM 52-11-21. ADJUSTED DOOR SENSOR (AALA20230213SDR AALA202302149976Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT AFT MAIN LANDING GEAR WHEEL WELL RIGHT SIDE INOPERATIVE. RELAMPED EMERGENCY LIGHT AFT RIGHT MAIN LANDING GEAR WHEEL WELL.SDR AALA202302146775Battery · no testAIRCRAFT WAS NOT GROUNDED: AFT LEFT FLIGHT ATTENDANT RIGHT FLASHLIGHT FLASHES RED. REMOVED AND REPLACED AFT LEFT FLIGHT ATTENDANT RIGHT FLASHLIGHT BATTERY.SDR AALA202302147641Battery · no testAIRCRAFT WAS NOT GROUNDED: FORWARD FLIGHT ATTENDANT RIGHT FLASHLIGHT FLASHES RED. REMOVED AND REPLACED FORWARD FLIGHT ATTENDANT RIGHT FLASHLIGHT BATTERY.SDR AALA202302131892Rib · crackedAIRCRAFT IN BASE MAINTENANCE: TWO CRACKS IN RIGHT HAND HORIZONTAL STABILIZER RIB LOCATED AT STABILIZER STA 92.70, AT FIRST AND SECOND STIFFENER AFT OF FORWARD SPAR. REPLACED RIB PER SRM 55-10-09-0I-2 AND SRM 55-10-09-0I PROCEDURE 2.SDR AALA202302132468Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FUSELAGE SKIN AT EXTERNAL POWER ACCESS DOOR AFT AREA OF CUTOUT LOCATED AT BS 232 AND S22R. REPAIRED SKIN PER EA 342011 AND SRM B737NG 53-10-15-2R PROCEDURE 4.SDR AALA202302132645Bulb · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT CABIN EMERGENCY FLOOD LIGHT NEAR LAVATORY D HAS ONE INOPERATIVE BULB. REPLACED BULB PER AMM 33-51-01. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202302134876Girt Bar · stickingAIRCRAFT WAS NOT GROUNDED: GIRT BAR 1L EXTREMELY HARD TO ARM AND DISARM - REQUIRES FAR MORE FORCE THAN USUAL. RESECURED MATERIAL ON GIRT BAR.SDR AALA202302139204Light · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY AISLE LIGHT ABOVE OVERHEAD BIN AT 12FED INOPERATIVE. REMOVED AND REPLACED EMERGENCY AISLE OVERHEAD LIGHT ASSEMBLY PER AMM 33-51-03.SDR AALA202302138223Rivet · shearedAIRCRAFT WAS NOT GROUNDED: L1 DOOR AFT GIRT BAR BRACKET IS LOOSE. REPLACED SHEARED RIVET ON AFT GIRT BAR RETAINER CLIP PER AMM 25-66-01.SDR AALA202302138385Screw · looseAIRCRAFT WAS NOT GROUNDED: RIGHT AFT LAVATORY DOOR DIFFICULT TO OPEN OR CLOSE. TIGHTENED LOOSE DOOR HINGE SCREW. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202302136905Guide Arm · fault messageAIRCRAFT WAS GROUNDED: REPEAT WRITE UP FORWARD ENTRY DOOR L1 LIGHT CAME ON AFTER LANDING .DOOR DIFFICULT TO OPEN AND CLOSE. REMOVED AND REPLACED L-1 DOOR GUIDE ARM (AALA202302106905) AND LOCKING CAM (AALA202302131586) AMM 52-11-21.SDR AALA202302131586Cam · fault messageAIRCRAFT WAS GROUNDED: REPEAT WRITE UP FORWARD ENTRY DOOR L1 LIGHT CAME ON AFTER LANDING .DOOR DIFFICULT TO OPEN AND CLOSE. REMOVED AND REPLACED L-1 DOOR GUIDE ARM (AALA202302106905) AND LOCKING CAM (AALA202302131586) AMM 52-11-21.SDR AALA202302108440Bracket · out of adjustAIRCRAFT WAS NOT GROUNDED: FWD GALLEY ENTRY DOOR GIRT BAR ATTACHMENT NEEDS ADJUSTMENT. ADJUSTED FORWARD GALLEY ENTRY DOOR GIRT BAR ATTACHED BRACKET.SDR AALA202302104529Rod · out of adjustAIRCRAFT WAS GROUNDED: R1 DOOR DIFFICULT TO CLOSE. TOP AFT ROLLER STRIKES LATCH. ADJUSTED THE HORIZONTAL ROD ON THE R1 DOORSDR AALA202302103170Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: PS CHECK EXTERIOR EMERGENCY LIGHT AFT OF RIGHT BODY TRAILING EDGE FLAPS TO BE INOPERATIVE. RELAMPED EMERGENCY LIGHT.SDR AALA202302100236Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: RIGHT AFT INBOARD FLIGHT ATTENDANT FLASHLIGHT INOPERATIVE. REMOVED AND REPLACED RIGHT AFT INBOARD FLASHLIGHT BATTERY.SDR AALA202302107930Trim Motor · stuckAIRCRAFT WAS GROUNDED: ON CLIMB UNABLE TO TRIM STABILIZER WITH YOKE TRIM SWITCHES OR MANUALLY WITH TRIM WHEEL. PITCH TRIM WAS STUCK. FIGHT RETURNED TO DFW LANDING SAFELY. REMOVED AND REPLACED STAB TRIM MOTOR AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK PER SDR AALA202303017930Trim Motor · stuckAIRCRAFT WAS GROUNDED: ON CLIMB UNABLE TO TRIM STABILIZER WITH YOKE TRIM SWITCHES OR MANUALLY WITH TRIM WHEEL. PITCH TRIM WAS STUCK. FIGHT RETURNED TO DFW LANDING SAFELY. REMOVED AND REPLACED STAB TRIM MOTOR AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK PER SDR AALA202302175083Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND RBL 54.60. REPLACED SHEAR FITTING PER EA 342233.SDR AALA202302169476Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND LBL 6.14. REPLACED SHEAR FITTING PER EA 342233.SDR AALA202302161322Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND RBL 40.87. REPLACED SHEAR FITTING PER EA 342233.SDR AALA202302168292Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND LBL 32.40. REPLACED SHEAR FITTING PER EA 342233.SDR AALA202302166083Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND LBL 15.04. REPLACED SHEAR FITTING PER EA 342233.SDR AALA202302169819Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND RBL 6.14. REPLACED SHEAR FITTING PER EA 342233.SDR AALA202302167472Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND LBL 40.87. REPLACED SHEAR FITTING PER EA 342233.SDR AALA202302163000Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND RBL 32.40. REPLACED SHEAR FITTING PER EA 342233.SDR AALA202302165316Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND LBL 54.60. REPLACED SHEAR FITTING PER EA 342233.SDR AALA202302165062Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND RBL 15.04. REPLACED SHEAR FITTING PER EA 342233.SDR AALA202302139373Outlet · odorAIRCRAFT WAS GROUNDED: FLIGHT ATTENDANT REPORTED STRONG ELECTRICAL BURNING SMELL BY 2F VERY BRIEF AND COULDN'T FIND SOURCE . FOUND RESIDUAL OF ELECTRICAL BURNING SMELL ON SEAT 2F AC OUTLET UNIT REMOVED AND REPLACED AC OUTLET UNIT.SDR AALA202302138267Pin · unserviceableAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR DIFFICULT TO OPEN / CLOSE. **SUPPLEMENTAL REPORT FOR AALA202302098267: MAINTENANCE FOUND BI-FOLD DOOR WHEEL PIN ASSEMBLY FAULTY. (ALLOWS DOOR TO SLIDE IN TRACK). WHEEL PIN ASSEMBLY REPLACED.** (CLOSED)SDR AALA202302105091Light · brokenAIRCRAFT WAS NOT GROUNDED: PATHWAY LIGHT AT SEAT 15C IS BROKEN. REMOVED AND REPLACED EMERGENCY LIGHT.SDR AALA202302096111Bracket · inoperativeAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS R1 GIRT BAR WILL NOT STAY STOWED. ADJUSTED GIRT BAR RETENTION BRACKET.SDR AALA202302092333Screw · missingAIRCRAFT WAS NOT GROUNDED: LAVATORY DOOR LATCH MECHANISM FOR AFT LAVATORY D IS STICKING AND ABOUT TO BREAK. FOUND MISSING SCREWS THAT SECURE LOCKING MECHANISM. REPLACED MISSING SCREWS.SDR AALA202302096885Outlet · odorAIRCRAFT WAS GROUNDED: FLIGHT ATTENDANT REPORTED STRONG ELECTRICAL BURNING SMELL BY 2F VERY BRIEF AND COULDN'T FIND SOURCE. FOUND RESIDUAL OF ELECTRICAL BURNING SMELL ON SEAT 2F AC OUTLET UNIT REMOVED AND REPLACED AC OUTLET UNIT.SDR AALA202302098267Unknown · unknownAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR DIFFICULT TO OPEN / CLOSE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202302204063None · brokenAIRCRAFT IN BASE MAINTENANCE: BROKEN MAIN CABIN FLOOR SUPPORT BREAK ASSEMBLY LOCATED AT BS 537.45 AND RBL 1. REPLACED BREAK ASSEMBLY PER DWG 143A0060 AND AARD 51-00-05.SDR AALA202302139730Bracket · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION AROUND FASTENER HOLES ON AFT CARGO COMPARTMENT AFT BULKHEAD CENTER PANEL LOWER SUPPORT BRACKET LOCATED AT BS 947.5 AND FROM RBL 12 TO LBL 12. REPLACED BRACKET PER SRM 51-10-02, 51-10-01-0G, AND 51-40-02.SDR AALA202302098180Door · out of adjustAIRCRAFT WAS GROUNDED: FORWARD ENTRY DOOR IS DIFFICULT TO OPEN AND CLOSE. FORWARD ENTRY DOOR LIGHT CAME ON AFTER LANDING DURING TAXI TO THE GATE. ADJUSTED PROX SWITCH S199 AND ADJUSTED TOP AFT ROLLER CLEARANCE.SDR AALA202302081354Not Reported · out of positionAIRCRAFT WAS NOT GROUNDED: L1 DOOR GIRT BAR WILL NOT STAY FIRMLY AFFIXED. REPOSITIONED L1 DOOR GIRT BAR STOW CLIP PER AMM 25-66-00.SDR AALA202302088342Light · inoperativeAIRCRAFT WAS NOT GROUNDED: R2 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED R2 DOOR EXTERIOR EMERGENCY LIGHT PER AMM 33-51-04. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202302085204Slide · stickingAIRCRAFT WAS GROUNDED: L1 DOOR/SLIDE JAMMED CANNOT OPEN DOOR UPON ARRIVAL. INSTALLED REPLACEMENT SLIDE PER JOB CARD.SDR AALA202302210120Baffle · dentedAIRCRAFT IN BASE MAINTENANCE: DENT IN FORWARD CARGO COMPARTMENT LEFT HAND BAFFLE LOCATED BETWEEN BS 500C AND BS 500D AT S25L. REPLACED BAFFLE PER SRM 51-40-02-0G.SDR AALA202302216265Shear Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON SHEAR WEB LOCATED FROM BS 992 TO BS 1016 AND FROM RBL 40 TO RBL 50. REPLACED SHEAR WEB PER SRM 51-40-02-0G.SDR AALA202302219895Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L1 DOOR MOP SILL SUPPORT ANGLE LOCATED FROM BS 312 TO BS 344 AT S17L. REPLACED ANGLE PER SRM 51-40-02-0G.SDR AALA202302177810Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND VAPOR BARRIER UPPER ANGLE LOCATED AT BS 663 AND RBL 8. REPAIRED ANGLE PER SRM 57-10-10-2R-5 AND AARD 57-10-10-10.SDR AALA202302139191Mount · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L1 DOOR FORWARD GIRT BAR MOUNT LOCATED AT BS 312 AND LBL 58. REPLACED GRIT BAR MOUNT PER SRM 53-10-02, 53-10-15, AND 51-40-02.SDR AALA202302134769None · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L1 DOOR CUT-OUT INNER CHORD, LOCATED BETWEEN BS 320 AND BS 335 AT LBL 60. REPLACED CHORD PER SRM 51-40-02-0G.SDR AALA202302080475Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR STRUCTURE LEFT HAND TRANSITION PANEL LOCATED FROM BS 727H + 10 INCHES TO BS 797 AT S25L. REPAIRED TRANSITION PANEL PER SRM 51-40-02-0G.
Back to Boeing 737-823