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 AALA202104089021Spring · brokenAIRCRAFT WAS NOT GROUNDED: PACK FAILURE. 1 PACK LIGHT ILLUMNATED INFLIGHT. RESET OKAY AND THEN LIGHT RE-ILLUMINATED. FLIGHT RETURNED TO FIELD. TROUBLESHOT 1 PACK FAULT , UPON TROUBLESHOOTING FOUND DEFLECTOR DOOR SPRING BROKEN. REMOVED AND REPLACED THE 1 DEFLECSDR AALA202104089019Bulb · burned outAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHTED SIGN AT ROW 16 RIGHT HAS BULBS BURNED OUT. REMOVED AND REPLACED EMERGENCY LIGHT SIGN AT ROW16 RIGHT REF AMM 33-51-01.SDR AALA202104079007Transmitter · inoperativeAIRCRAFT WAS GROUNDED: ON APPROACH, FLAPS SELECTED TO "1" BUT GOT STUCK HALFWAY BETWEEN 0 AND 1. "TRAILING EDGE FLAP DISAGREE" CHECKLIST ACCOMPLISHED. USED ALTERNATE FLAP EXTENSION WITH A FLAPS 15 LANDING. EMERGENCY DECLARED. REMOVED AND REPLACED LEFT POSITIONSDR AALA202104079006Bulb · burned outAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHTED SIGN AT ROW 16RH HAS BULBS BURNED OUT. REMOVED AND REPLACED EMERGENCY LIGHT SIGN AT ROW 16RH.SDR AALA202104079008Shroud · dislodgedAIRCRAFT WAS NOT GROUNDED: SEAT 14C ESCAPE PATH LIGHT DAMAGED. SECURED SHROUD PER AMM 25-21-63.SDR AALA202104079017Power Supply · inoperativeAIRCRAFT IN BASE MAINTENANCE: STA 697 EMERGENCY BIN LIGHT INOPERATIVE. REPLACED POWER SUPPLY M1670 WITH SERVICEABLE UNIT IAW AMM 33-51-06, OPS CHECK GOOD.SDR AALA202104069010Housing · brokenAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT ROW 18 IS BROKEN AND DOES NOT ILLUMINATE THE AISLE. REMOVED AND REPLACED SEAT 18 EMERGENCY LIGHT HOUSING IAW AMM 33-51-11.SDR AALA202104069013Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: RH AFT EXTERIOR EMERGENCY EXIT LIGHT INOPERATIVE. RELAMPED LIGHT IAW AMM 33-50-04, OPS CHECK GOOD.SDR AALA202104069011Slide · inoperativeAIRCRAFT WAS GROUNDED: DOOR L2 ESCAPE SLIDE REQUIRES REPLACEMENT. REMOVED AND REPLACED L2 DOOR ESCAPE SLIDE PER WORK CARD 08L22125001.SDR AALA202104069012Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: SEAT 16F EXIT LAMP INOPERATIVE. REPLACED LAMP PER AMM 33-51-00.SDR AALA202104059006Window · scratchedAIRCRAFT WAS GROUNDED: SCRATCH ON INSIDE OF R1 WINDOW. REPLACED R1 WINDOW IAW WORKCARD 08L21056004.SDR AALA202104059051Collar · shearedAIRCRAFT WAS NOT GROUNDED: FOUND CABIN EMERGENCY LIGHT CIRCUIT BREAKER C1949 ON P6-11 PANEL, COLLAR SHEARED. REPLACED CIRCUIT BREAKER C1949 PER WDM 33-51-11.SDR AALA202104059040Shroud · brokenAIRCRAFT WAS NOT GROUNDED: SEAT 16C EMERGENCY LIGHT SHROUD BROKEN. REPLACED LIGHT SHROUD WITH NEW IAW AMM 25-21-20, OPS CHECK GOOD.SDR AALA202104059041Bracket · looseAIRCRAFT WAS NOT GROUNDED: 1R DOOR GIRT BAR BRACKET IS LOOSE. ADJUSTED 1R DOOR GIRT BAR RETAINER CLIP IAW AMM 25-66-01, OPS CHECK GOOD.SDR AALA202104059037Shroud · looseAIRCRAFT WAS NOT GROUNDED: ESCAPE PATH LIGHTING IS LOOSE AT SEAT 28C. REPLACED EMERGENCY PATH LIGHT SHROUD IAW CMM 25-23-67, OPS CHECK GOOD.SDR AALA202104059036Light · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHTING AT ROWS 28-33 INOPERATIVE. ACCOMPLISHED SYSTEM TEST IAW FIM 33-50-00-810-801, OPS CHECK GOOD.SDR AALA202104059047Girt Bar · stuckAIRCRAFT WAS NOT GROUNDED: DOOR 1R GIRT BAR IS STUCK AND CANNOT BE ARMED. REPOSITIONED GIRT BAR.SDR AALA202104059045Retainer · stuckAIRCRAFT WAS NOT GROUNDED: DOOR 1R GIRT BAR VERY DIFFICULT TO DETACH. ADJUSTED GIRT BAR RETAINER CLIPS PER AMM 25-66-01.SDR AALA202104089026Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: FORWARD CARGO COMPARTMENT FLOOR INTERCOSTAL CRACKED IN THE FORWARD RADIUS BELOW THE LEFT HAND TRANSITION PANEL AT BS 400 AND S25L. REPLACED INTERCOSTAL PER SRM 51-40-02.SDR AALA202104069020Pressure Deck · crackedAIRCRAFT IN BASE MAINTENANCE: PRESSURE DECK WEB RIGHT WHEEL WELL AT RIGHT BUTT LINE 31.83 TO RIGHT BUTT LINE 40.00 HAS A CRACK APPROXIMATELY 1.5 INCHES LONG. REPAIRED PRESSURE DECK WEB RIGHT WHEEL WELL RIGHT BUTT LINE 31.83 TO RIGHT BUTT LINE 40.00 PER SRM 57-SDR AALA202104069026Slide · tornAIRCRAFT IN BASE MAINTENANCE: DOOR 2L ESCAPE SLIDE GIRT WORN AND TORN AT THE RIGHT HAND EDGE. REPLACED SLIDE ASSEMBLY PER AMM 25-66-01.SDR AALA202104059027Hook · out of adjustAIRCRAFT WAS NOT GROUNDED: SLIDE GRIT BAR HOOK AT DOOR 1L DOES NOT HOLD GRIT BAR FIRMLY ON RIGHT SIDE. BENT GIRT BAR CLIPS TO CONFORM ON DOOR 1L IAW AMM 25-66-01-200-802.SDR AALA202104059026Slide · out of positionAIRCRAFT WAS NOT GROUNDED: DOOR 1R SLIDE DIFFICULT TO ARM. THE FABRIC IS VERY STIFF. MADE SLIGHT ADJUSTMENT TO R-1 DOOR SLIDE BRACKET IAW 25-66-02.SDR AALA202104069017Rib · crackedAIRCRAFT IN BASE MAINTENANCE: RIGHTHAND HORIZONTAL STABILIZER RIB CRACKED AT STATION 147.90. REPAIRED PER SRM 55-10-09-2R-4.SDR AALA202104069016Skin · crackedAIRCRAFT IN BASE MAINTENANCE: RIGHTHAND HORIZONTAL STABILIZER LOWER SKIN CRACKED AT STATION 101.90. REPAIRED PER SRM 55-10-01-2R-11.SDR AALA202104059009Latch · dirtyAIRCRAFT WAS NOT GROUNDED: DOOR VERY DIFFICULT TO PULL OPEN WITH SWITCH IN OFF POSITION. CLEANED DEBRIS AND LUBRICATED DOOR LATCH PER AMM 52-51-03.SDR AALA202104069023Doubler · crackedAIRCRAFT IN BASE MAINTENANCE: RIGHT HORIZONTAL STABILIZER HAS CRACK AT STATION 110. INSTALLED DOUBLER AND FILLERS PER SRM 55-10-01-2R-11.SDR AALA202104069022Pressure Deck · crackedAIRCRAFT IN BASE MAINTENANCE: WING CENTER SECTION KEEL BEAM VERTICAL PRESSURE DECK WEB RIGHT BUTT LINE 40 TO RIGHT BUTT LINE 45.64 HAS CRACK. RIGHT PRESSURE DECK WEB REPAIR PER SRM 57-10-10-2R-3.SDR AALA202104069021Pressure Deck · crackedAIRCRAFT IN BASE MAINTENANCE: WING CENTER SECTION KEEL BEAM VERTICAL PRESSURE DECK WEB LEFT BUTT LINE 40 TO LEFT BUTT LINE 45.64 HAS CRACK. LEFT PRESSURE DECK WEB REPAIR PER SRM 57-10-10-2R-3.SDR AALA202104069030Skin · crackedAIRCRAFT IN BASE MAINTENANCE: LEFT HORIZONTAL STABILIZER LOWER SKIN HAS 1.5 INCH CRACK AT STA 157.10. ACCOMPLISHED DOUBLER AND FILLER REPAIR IAW SRM 55-10-01-2R-11 AND EA 326537.SDR AALA202104069028Skin · crackedAIRCRAFT IN BASE MAINTENANCE: LEFT HORIZONTAL STABILIZER BOTTOM SKIN HAS 1.00 INCH CRACK IN FRONT OF REAR SPAR AT STA 101.9. INSTALLED DOUBLER REPAIR IAW SRM 55-10-01-2R-11.SDR AALA202104069018Rib · crackedAIRCRAFT IN BASE MAINTENANCE: LEFTHAND HORIZONTAL STABILIZER RIB CRACKED AT STATION 101.90. REPAIRED PER SRM 55-10-09-2R-4.SDR AALA202104019016Bracket · looseAIRCRAFT WAS NOT GROUNDED: CAPTAIN REPORTS 1R DOOR SLIDE GIRT BAR LOOSE IN CLIP. ADJUSTED 1R DOOR GIRT BAR CLIP IAW AMM 25-66-01, OPS CK GOOD.SDR AALA202104019010Smoke Detector · false activationAIRCRAFT WAS NOT GROUNDED: LAVATORY SMOKE LIGHT ILLUMINATED. FLIGHT ATTENDANTS STATED SMOKE IN RIGHT REAR LAVATORY. TRASH CAN REMOVED, NO FIRE. SMOKE DETECTOR INDICATOR LIGHT ILLUMINATED. DEBRIEFED FLIGHT CREW. THEY CONFIRMED NO FIRE OR VISUAL SMOKE. ACCOMPLISSDR AALA202104019011Display · failedAIRCRAAFT WAS GROUNDED: INTEGRATED STANDBY FLIGHT DISPLAY FAILED INFLIGHT. REMOVED AND REPLACED INTEGRATED STANDBY FLIGHT DISPLAY IAW AMM 34-24-02. ALL TEST REQUIRED PASSED.SDR AALA202104069029Pressure Deck · crackedAIRCRAFT IN BASE MAINTENANCE: FOUND 1.00 INCH CRACK IN PRESSURE DECK AT STA 540 AND WL 207.4. INSTALLED DOUBLER AND FILLER REPAIR IAW SRM 57-10-01-2R-3.SDR AALA202104019027Stop Fitting · out of positionAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN RIGHT HAND AFT OVERWING EXIT UPPER AFT STOP PAD HAS TURNED. READJUSTED STOP PAD PER CMM 52-26-02SDR AALA202104019013Hook · looseAIRCRAFT WAS NOT GROUNDED: DOOR 1R SLIDE GIRT BAR CLIP LOOSE. SECURED GIRT BAR CLIP PER AMM 25-66-00.SDR AALA202104149023Angle · out of toleranceAIRCRAFT WAS GROUNDED: ATTACHING STRUCTURE FOR THE OASIS MOD LEFT OUTBOARD SEAT TRACK HAS ELONGATED HOLES IN MAIN CABIN, STA 887 AND LBL 45.5. REPLACED CARRY THROUGH ANGLE IAW BAC DWG 147A5300, B737 SRM 51-40-02 ADDING FREEZE PLUG REPAIR IAW AA E.A 325478.SDR AALA202104079021Servo · unserviceableAIRCRAFT WAS GROUNDED: DURING CLIMB OUT AT 2,000 FEET ELEC STABILIZER TRIM BECAME INTERMITTENT AND THEN FAILED. THE AIRCRAFT FAILED AUTO TRIMMING. COMMAND A AUTO PILOT WOULD NOT ENGAGE.COMMAND B ENGAGED FOR ABOUT 5 MINUTES AND THEN DISENGAGED. NEITHER AUTOPILOSDR AALA202104079020Switch · unserviceableAIRCRAFT WAS GROUNDED: DURING CLIMB OUT AT 2,000 FEET ELEC STABILIZER TRIM BECAME INTERMITTENT AND THEN FAILED. THE AIRCRAFT FAILED AUTO TRIMMING. COMMAND A AUTO PILOT WOULD NOT ENGAGE.COMMAND B ENGAGED FOR ABOUT 5 MINUTES AND THEN DISENGAGED. NEITHER AUTOPILOSDR AALA202104079019Relay · unserviceableAIRCRAFT WAS GROUNDED: DURING CLIMB OUT AT 2,000 FEET ELEC STABILIZER TRIM BECAME INTERMITTENT AND THEN FAILED. THE AIRCRAFT FAILED AUTO TRIMMING. COMMAND A AUTO PILOT WOULD NOT ENGAGE.COMMAND B ENGAGED FOR ABOUT 5 MINUTES AND THEN DISENGAGED. NEITHER AUTOPILOSDR AALA202104079018Relay · intermittentAIRCRAFT WAS GROUNDED: DURING CLIMB OUT AT 2,000 FEET ELEC STABILIZER TRIM BECAME INTERMITTENT AND THEN FAILED. THE AIRCRAFT FAILED AUTO TRIMMING. COMMAND A AUTO PILOT WOULD NOT ENGAGE.COMMAND B ENGAGED FOR ABOUT 5 MINUTES AND THEN DISENGAGED. NEITHER AUTOPILOSDR AALA202103309010Actuator · malfunctionedAIRCRAFT WAS GROUNDED: DURING CLIMB OUT AT 2,000 FEET ELEC STABILIZER TRIM BECAME INTERMITTENT AND THEN FAILED. THE AIRCRAFT FAILED AUTO TRIMMING. COMMAND A AUTO PILOT WOULD NOT ENGAGE.COMMAND B ENGAGED FOR ABOUT 5 MINUTES AND THEN DISENGAGED. NEITHER AUTOPILOSDR AALA202104069015Gusset · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED GUSSET LOCATED AT BS 500I S19R. REPLACED GUSSET PER SRM 51-40-02.SDR AALA202104019012Lock · out of adjustAIRCRAFT WAS NOT GROUNDED: FIRST CLASS LAVATORY DOOR STICKS, DIFFICULT TO OPEN AND CLOSE. ADJUSTED LAV DOOR HANDLE AND LOCK ASSY IAW ESO 60782, OPS CHECK GOOD.SDR AALA202103309028Selector Valve · faultedAIRCRAFT WAS GROUNDEDL: NOSE LANDING GEAR EXTENDED WITH HANDLE IN OFF POSITION AFTER TAKE OFF. PUTTING HANDLE BACK UP RETRACTED THE NOSE GEAR. HANDLE LEFT IN UP POSITION PER QRH FOUND LANDING GEAR SELECTOR VALVE FAULT. REPLACED SELECTOR VALVE AND ACCOMPLISHED SDR AALA202103309012Hook · out of adjustAIRCRAFT WAS NOT GROUNDED: GIRT BAR CLIPS TIGHT ON DOOR 1R. HARD TO INSERT AND REMOVE BAR INTO OR OUT OF CLIPS. ADJUSTED GIRT BAR RETENTION CLIPS ON DOOR 1R PER AMM 25-66-02.SDR AALA202103309014Sign · dislodgedAIRCRAFT WAS NOT GROUNDED: EXIT SIGN AT OVER WING EMERGENCY EXIT ROW FELL. SECURED SIGN PER AMM 33-51-00-720-801.SDR AALA202103299029Engine · fireAIRCRAFT WAS GROUNDED: AFTER TAKEOFF FLAMES FROM #2 ENGINE SEEN BY PASSENGER. ALL ENGINE PARAMETERS WERE NORMAL. RETURNED TO AIRPORT FOR MAINTENANCE. DECLARED EMERGENCY. **SUPPLEMENTAL INFORMATION: REMOVED AND REPLACE #2 ENGINE PER JC 08L40072003.
Back to Boeing 737-823