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 AALA202109214315Switch · failedAIRCRAFT WAS GROUNDED: AUTO BRAKE FAILED UPON LANDING AUTO BRAKE DISARM LIGHT EXTINGUISHED IN OFF POSITION. REMOVED AND REPLACED LEFT SWITCH PACK PER WORK CARD 08L11276001.SDR AALA202109211415Light · detachedAIRCRAFT WAS NOT GROUNDED: SEAT 15C AISLE PATH LIGHTING DETACHED. REINSTALLED LIGHT PER AMM 33-51-00.SDR AALA202109213131Control Valve · faultedAIRCRAFT WAS GROUNDED: ENGINE 1 FIRE AND OVERHEAT WARNING DURING CLIMB OUT FROM CLT. INDICATION CEASED SHORTLY AFTERWARDS. DECLARED EMERGENCY AND RETURNED TO CLT. MAINTENANCE PERFORMED AMM TASK 26-10-00-810-811 AND WAS UNABLE TO DUPLICATE OVERHEAT FAULT. MAINTSDR AALA202109213228Wire Harness · damagedAIRCRAFT WAS GROUNDED: ENGINE 1 FIRE AND OVERHEAT WARNING DURING CLIMB OUT FROM CLT. INDICATION CEASED SHORTLY AFTERWARDS. DECLARED EMERGENCY AND RETURNED TO CLT. MAINTENANCE PERFORMED AMM TASK 26-10-00-810-811 AND WAS UNABLE TO DUPLICATE OVERHEAT FAULT. MAINTSDR AALA202110086946None · corrodedAIRCRAFT IN BASE MAINTENANCE: MULTIPLE AREA OF CORROSION ON LEFT TRANSITION PANEL FROM STA 500D TO STA 500L. INSTALLED LEFT TRANSITION PANEL PER SRM 53-00-53-2R.SDR AALA202110083581Support Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: AREA OF CORROSION AT STA 500L ON ANGLE ABOVE TRANSITION PANEL. INSTALLED LOWER SUPPORT ANGLE AT STA 500L PER SRM 51-40-02.SDR AALA202110084210None · corrodedAIRCRAFT IN BASE MAINTENANCE: MULTIPLE AREA OF CORROSION ON RIGHT TRANSITION PANEL FROM STA 500 TO 500L. INSTALLED RIGHT TRANSITION PANEL AND SPLICE PER SRM 53-00-53-2R.SDR AALA202109212289Knob · brokenAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR LATCH BROKEN. RE-SECURED AFT LEFT LAVATORY DOOR LATCH KNOB. ACCOMPLISHED PER AMM 25-40-14.SDR AALA202109219682Screw · unsecureAIRCRAFT WAS NOT GROUNDED: 16C EXIT ROW LIGHT IS HANGING OUT NOT SECURE. A SCREW MIGHT BE MISSING. REPLACED THE MISSING SCREW ON THE EMERGENCY EXIT LIGHT PER AMM 33-51-11 AT SEAT 16C.SDR AALA202109217994Cover · detachedAIRCRAFT WAS NOT GROUNDED: SEAT 26A EMERGENCY LIGHT COVER PULLED OFF. REPLACED EMERGENCY LIGHT ASSEMBLY.SDR AALA202109203288Cover · out of positionAIRCRAFT WAS NOT GROUNDED: OVER WING EMERGENCY EXIT LIGHT COVER FELL OFF LIGHT AND BROKE. LOCATION ROW 16 FACING AFT. REATTACHED LIGHT COVER ON OVERWING 16F EMERGENCY LIGHTS AS REQUIRED PER AMM 25-60-00.SDR AALA202109200224Bulb · inoperativeAIRCRAFT IN BASE MAINTENANCE: REPEAT EMERGENCY LIGHT IN CEILING AT ROW 1 INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHT BULB PER AMM 33-51-03.SDR AALA202109203918Threshold · stickingAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR DIFFICULT TO OPEN. SECURED LOOSE THRESHOLD OF FORWARD LAVATORY DOOR FRAME PER AMM 25-40-11.SDR AALA202109201099Flap System · malfunctionedAIRCRAFT WAS NOT GROUNDED: ON APPROACH 25L LAX UPON MOVING FLAPS FROM 25 TO 30 NO MOVEMENT. DID GO AROUND AND LANDED AT FLAPS 15. AFTER LANDING EXTENDED FLAPS TO 30 AND FLAPS EXTENDED NORMALLY. ACCOMPLISHED TRAILING EDGE FLAP SYSTEM OPERATIONS TEST PER AMM 27SDR AALA202109208677Selector · failedAIRCRAFT WAS GROUNDED: EMERGENCY LANDED INTO DEN DUE TO AUTO FAIL ILLUMINATED ON PRESSURIZATION PANEL DURING DESCENT. REPLACED NUMBER 1 CABIN PRESSURE CONTROLLER PER AMM 21-31-01.SDR AALA202109205223Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR STICKS AND IS DIFFICULT TO OPEN OR CLOSE. LUBRICATED DOOR.SDR AALA202109203014Actuator · faultedAIRCRAFT WAS GROUNDED: ABRUPT PITCH DOWN MOMENTS AFTER AUTOPILOT A ENGAGED AT FL310, SPEED MACH .79 AUTOPILOT B NORMAL.. REPLACED AUTOPILOT ELEVATOR ACTUATOR A PER AMM 22-11-26 .SDR AALA202309252837Skin Panel · damagedAIRCRAFT WAS GROUNDED: DAMAGE OCCURRED DUE TO LIGHTING STRIKE TO THE LEFT NUMBER 3 WINDOW FRAME. THIS DAMAGE IS AT STA 241 / WL268 ON THE CROWN SKIN. A TIME LIMITED REPAIR WAS ACCOMPLISHED IN TUL PER EA 330478 WHICH IS CALLED OUT IN EA 330514. FINAL ACTION TO SDR AALA202109204532Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN VERTICAL RIB AT 3RD STIFFENER OF RH HORIZONTAL STABILIZER AT STA 92.70, MEASURING L=0.5 IN, W=0.002 IN, D=0.04 IN. REPLACED RIB WITH NEW IAW AARD 51-00-05-1.SDR AALA202109206945Connector · disconnectedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHT INOPERATIVE AT SEAT 10ABC. CONNECTED CONNECTOR IAW SWPM 20-63-02, OPS CHECK GOOD.SDR AALA202109206428Connector · disconnectedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHT INOPERATIVE AT ROW 1. CONNECTED CONNECTOR IAW SWPM 20-63-02, OPS CHECK GOOD.SDR AALA202109202837None · noneAIRCRAFT WAS GROUNDED: DAMAGE OCCURED DUE TO LIGHTING STRIKE TO THE LEFT NUMBER 3 WINDOW FRAME. THIS DAMAGE IS AT STA 241 / WL268 ON THE CROWN SKIN. A TIME LIMITED REPAIR WAS ACCOMPLISHED IN TUL PER EA 330478 WHICH IS CALLED OUT IN EA 330514. FINAL ACTION TO BSDR AALA202109174210Lens · missingAIRCRAFT WAS NOT GROUNDED: LEFT AFT EXIT SIGN LENS MISSING. REPLACED LENS.SDR AALA202109170737Slide · out of positionAIRCRAFT IN BASE MAINTENANCE: SLIDE FLAP AT DOOR 2L DRAGS AND HANGS UP AT DOOR SILL WHEN CLOSING DOOR. FOLDED SLIDE PER AMM 25-66-01.SDR AALA202109178023Slide · out of positionAIRCRAFT IN BASE MAINTENANCE: SLIDE FLAP AT DOOR 2R DRAGS AND HANGS UP AT DOOR STILL WHEN CLOSING DOOR. FOLDED SLIDE PER AMM 25-66-01.SDR AALA202109179718Latch · stickingAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR LOCK/LATCH DIFFICULT TO OPERATE. CLEAN AND ADJUSTED AFT LEFT LAVATORY DOOR LOCK/LATCH PER AMM 25-40-00.SDR AALA202109204533None · noneAIRCRAFT WAS NOT GROUNDED: ROW 2 AISLE CREAKED WHEN WALKED ON. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202109170707Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LOWER SKIN OF RIGHT HORIZONTAL STABILIZER AT STA 166.3 24 INCHES FROM FRONT SPAR. INSTALLED EXTERNAL DOUBLER REPAIR PER SRM 55-10-01-2R-11.SDR AALA202109178732Skin · crackedAIRCRAFT WAS GROUNDED: 2 INCH CRACK FOUND ON LOWER LEFT HORIZONTAL STABILIZER SKIN LOCATED AT STA 144. INSTALLED EXTERNAL DOUBLER REPAIR PER SRM 55-10-01-2R-11.SDR AALA202109157943Slide · out of positionAIRCRAFT IN BASE MAINTENANCE: 1L DOOR SLIDE HAS EXPANDED AND IS PUSHING THE SLIDE COVER OUT. REPLACED SLIDE PER JOB CARD 08L22125001.SDR AALA202109172214Skin · crackedAIRCRAFT IN BASE MAINTENANCE: 2 INCH CRACK IN RIGHT HAND HORIZONTAL STABILIZER AT STABILIZER STA 101.90. REPAIRED PER SRM 55-10-01-2R. INSTALLED DOUBLER.SDR AALA202109154076Light · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT OUT ON DOOR SEAT 17FED. ADJUSTED EMERGENCY LIGHT AT EMERGENCY EXIT DOOR AT 17FED PER AMM 33-51-00.SDR AALA202109151706Master Caution · false activationAIRCRAFT WAS NOT GROUNDED: ON TAKE-OFF AT APPROXIMATELY 30 KNOTS THE MASTER CAUTION AND AFT ENTRY DOOR ILLUMINATED. A REJECT WAS ACCOMPLISHED WITH MAX SPEED OF 45 KNOTS. PERFORMED FIM 52-10-00, AFT ENTRY DOOR LIGHT OPERATIONS CHECK NORMAL.SDR AALA202109151763Hinge · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY ENTRY DOOR JAMS AND DIFFICULT TO OPEN AND CLOSE. ADJUSTED DOOR HINGE PER AMM 25-00-00.SDR AALA202109178474Rib · crackedAIRCRAFT IN BASE MAINTENANCE: FOUND A CRACK ON THE RIGHT HORIZONTAL STABILIZER IN RIB 3RD STIFFENER FROM FORWARD SPAR AT STA 166.30. INSTALLED DOUBLER REPAIR TO VERTICAL RIB PER SRM 55-10-09-2R-4.SDR AALA202109157038Battery · inoperativeAIRCRAFT IN BASE MAINTENANCE: BOTH FLASHLIGHTS UNDER FLIGHT ATTENDANT JUMP SEAT ADJACENT TO DOOR 2L DO NOT TEST. BATTERY INOPERATIVE. REMOVED AND INSTALLED SERVICEABLE BATTERIES ON BOTH FLASH LIGHTS (AALA202109146720) PER AMM 25-64-00.SDR AALA202109156720Battery · no testAIRCRAFT IN BASE MAINTENANCE: BOTH FLASHLIGHTS UNDER FLIGHT ATTENDANT JUMP SEAT ADJACENT TO DOOR 2L DO NOT TEST. BATTERY INOPERATIVE. REMOVED AND INSTALLED SERVICEABLE BATTERIES ON BOTH FLASH LIGHTS (AALA202109157038) PER AMM 25-64-00.SDR AALA202109157403Handle · corrodedAIRCRAFT IN BASE MAINTENANCE: DOOR 1R HANDLE IS SCRATCHED AND PITTED. INSTALLED NEW R1 DOOR HANDLED PER 52-41-31.SDR AALA202109157219Air Filter · dirtyAIRCRAFT WAS GROUNDED: STRONG DIRTY SOCK SMELL COMING FROM AIR CONDITIONING PACKS DURING TAKEOFF, CLIMB, DESCENT AND LANDING. ODOR AND FUMES REPORT SUBMITTED. SMELL OBSERVED THROUGHOUT ENTIRE AIRCRAFT. COMPLETED SMOKE ODOR FUMES INITIAL TROUBLESHOOTING WORKCARSDR AALA202109158000Air Filter · dirtyAIRCRAFT WAS GROUNDED: STRONG DIRTY SOCK SMELL COMING FROM AIR CONDITIONING PACKS DURING TAKEOFF, CLIMB, DESCENT AND LANDING. ODOR AND FUMES REPORT SUBMITTED. SMELL OBSERVED THROUGHOUT ENTIRE AIRCRAFT. COMPLETED SMOKE ODOR FUMES INITIAL TROUBLESHOOTING WORKCARSDR AALA202109141289Battery · no testAIRCRAFT IN BASE MAINTENANCE: FLASHLIGHT 1 UNDER FLIGHT ATTENDANT JUMP SEAT ADJACENT TO DOOR 2R DOES NOT TEST. REPLACED BATTERY PER AMM 25-64-00.SDR AALA202109148946Battery · no testAIRCRAFT IN BASE MAINTENANCE: FLASHLIGHT 2 UNDER FLIGHT ATTENDANT JUMP SEAT ADJACENT TO DOOR 2R DOES NOT TEST. REPLACED BATTERY PER AMM 25-64-00.SDR AALA202109140009Battery · no testAIRCRAFT IN BASE MAINTENANCE: RIGHT FLASHLIGHT UNDER FLIGHT ATTENDANT JUMP SEAT ADJACENT TO DOOR 1L DOES NOT TEST. REPLACED BATTERY PER AMM 25-64-00.SDR AALA202109145669Flap · out of adjustAIRCRAFT IN BASE MAINTENANCE: DOOR 2L SLIDE GIRT FLAP DRAGS LOW AND BUNCHES AT BOTTOM DOOR JAMB WHEN CLOSING DOOR. REINSTALLED L2 SLIDE AND ADJUSTED GIRT FLAP IAW 25-66-01.SDR AALA202109207383Angle · wornAIRCRAFT IN BASE MAINTENANCE: THRESHOLD CREASE ANGLE FASTENER HOLE OUT OF ROUND AT STA 312 AND LBL 56. ACCOMPLISHED PERMANENT REPAIR IAW EA330284.SDR AALA202109178151Rib · crackedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER INTERNAL RIB LOCATED AT STABILIZER STA 101.90, CRACKED AT VERTICAL STIFFENER. REPLACED RIB PER SRM 55-10-09.SDR AALA202109134210Screw · looseAIRCRAFT WAS NOT GROUNDED: RIGHT AFT LAVATORY DOOR DIFFICULT TO OPEN AND CLOSE. TIGHTENED SCREW TO DOOR JAM.SDR AALA202109207363Window Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN L1 WINDOW FRAME AT STA 217 AND WL 258. ACCOMPLISHED PERMANENT REINFORCING DOUBLER/TRIPLER REPAIR IAW WORKCARD 5319J023-007.SDR AALA202109200782Window Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN R1 WINDOW FRAME AT STA 217 AND WL 258. ACCOMPLISHED PERMANENT REINFORCING DOUBLER/TRIPLER REPAIR IAW WORKCARD 5319J023-008.SDR AALA202109178975Rib · crackedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER INTERNAL RIB LOCATED AT STABILIZER STA 92.70, CRACKED AT VERTICAL STIFFENER. REPLACED RIB PER SRM 55-10-09.
Back to Boeing 737-823