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 AALA202408199860Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON UPPER CHORD OF FLOORBEAM AT STA 947.5, LBL 26. ACCOMPLISHED DOUBLER REPAIR TO UPPER CHORD (T CHORD) PER SRM 53-70-51-2R-5, ALTERNATIVE 2.SDR AALA202408122931Stiffener · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER INSPAR RIB STIFFENER AT STAB STA 120.30, THIRD STIFFENER FROM FORWARD SPAR. REPAIRED RIB STIFFENER PER SRM 55-10-09-2R-4.SDR AALA202407306366Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT ANGLE FOR INTERCOSTAL AT BS 500G, RBL 23. REPLACED ANGLE PER AARD 51-00-05-1.SDR AALA202407307646Baffle · corrodedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT BAFFLE AT STA 500G, RBL 23 REPLACED BAFFLE PER AARD 51-00-05-1.SDR AALA202407263509Wire · openAIRCRAFT IN BASE MAINTENANCE: DURING INSPECTION AFT CENTER EXIT LIGHT AT L2 DOOR FAILED TO ILLUMINATE. FOUND OPEN WIRE LEADING TO THE NUMBER 4 SOCKET IN CONNECTOR D10746. REPAIRED WIRE WITH A SPLICE. PER B737-NG SWPM 20-10-13 AND RESOCKETED CONNECTOR PER B737-SDR AALA202407267956Lamp · burned outAIRCRAFT IN BASE MAINTENANCE: RIGHT AFT OVERWING EMERGENCY LIGHT OUT. CHANGED RIGHT WING AFT EMERGENCY SLIDE LIGHT. OPERTIONAL CHECK GOOD. PER AMM 33-51-04.SDR AALA202407267704Lamp · burned outAIRCRAFT IN BASE MAINTENANCE: LEFT AFT OVERWING EMERGENCY LIGHT OUT. CHANGED LEFT WING AFT EMERGENCY SLIDE LIGHT. OPERTIONAL CHECK GOOD. PER AMM 33-51-01SDR AALA202407267887Guide Arm · brokenAIRCRAFT WAS GROUNDED: GUST LOCK DOES NOT KEEP THE L1 CABIN DOOR LOCKED IN PLACE OPEN.**SUPPLEMENTAL REPORT FOR (AALA202407257887): REMOVE AND REPLACED GUIDE ARM ((AALA202407257887)) AND ROLLER ((AALA202407264622)) PER AMM 52-11-21 AND PER EA 356580B**(CLOSED)SDR AALA202407264622Roller · brokenAIRCRAFT WAS GROUNDED: GUST LOCK DOES NOT KEEP THE L1 CABIN DOOR LOCKED IN PLACE OPEN.**SUPPLEMENTAL REPORT FOR (AALA202407257887): REMOVE AND REPLACED GUIDE ARM ((AALA202407257887)) AND ROLLER ((AALA202407264622)) PER AMM 52-11-21 AND PER EA 356580B**(CLOSED)SDR AALA202407253086Girt Bar · brokenAIRCRAFT WAS GROUNDED: DIFFICULT TO ARM AND DISARM BOTH FORWARD DOORS. FOUND R1 DOOR SLIDE GIRT BAR STOP BROKEN. REMOVED AND REPLACED GIRT BAR STOP AT R1 DOOR. PER AMM 25-66-01.SDR AALA202407257887Gust Lock · inoperativeAIRCRAFT WAS GROUNDED: GUST LOCK DOES NOT KEEP THE L1 CABIN DOOR LOCKED IN PLACE OPEN.**SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202407258845Sign · unsecureAIRCRAFT WAS NOT GROUNDED: 2L DOOR EXIT SIGN COVER WILL NOT STAY ATTACHED. RESECURED EXIT SIGN COVER AT 2L DOOR. PER AMM 33-51-01.SDR AALA202407250327Slide · misinstalledAIRCRAFT WAS GROUNDED: 1L DOOR SLIDE PART OF SLIDE IS PUCKERED OUT OF SHROUD. REINSTALLED "Z" FOLD ON FORWARD ENTRY DOOR (L1) SLIDE PACK. PER AMM 25-66-01-400-801.SDR AALA202407253013Door Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTANDENT REPORTS LAVATORY-D LOCK IS DIFFICULT TO OPEN AND CLOSE. LUBED LAVATORY-D LATCH MECHANISM. OPERTIONAL CHECK GOOD. PER AMM 25-40-15.SDR AALA202407259077Slide · looseAIRCRAFT WAS NOT GROUNDED: AFT SERVICE DOOR SLIDE LOOSE. REMOVED AND REPLACED R2 DOOR SLIDE. PER WORK CARD 08L22125001.SDR AALA202407252279Door Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: FIRST CLASS LAVATORY DOOR HANDLE IS DIFFICULT TO OPERATE. LUBE HANDLE AND LATCH. OPERTIONAL CHECK GOOD.SDR AALA202407251579Rail · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT AFT BULKHEAD LOWER LOBE RAIL ASSEMBLY AT STA 500I, FROM S25L TO S25R. REPLACED RAIL ASSEMBLY PER SRM 51-40-02-0G.SDR AALA202407249854Mount Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN AFT RIGHT LAVATORY MOUNT FITTING AT STA 947.5, RBL 51. REPLACED FITTING PER AARD 51-00-05-1.SDR AALA202407240970Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND LBL 6.14. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202407247414Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND RBL 6.14. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202407248707Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND LBL 15.04. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202407247590Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND LBL 32.40. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202407241070Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND LBL 40.87. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202407246708Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND LBL 54.60. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202407242001Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND RBL 15.04. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202407241645Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND RBL 32.40. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202407241680Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND RBL 40.87. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202407249847Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND RBL 54.60. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202407304418Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT ANGLE FOR INTERCOSTAL AT BS 500H, RBL 27. REPLACED ANGLE PER AARD 51-00-05-1.SDR AALA202407265122Lamp · inoperativeAIRCRAFT IN BASE MAINTENANCE: LEFT HAND AFT EMERGENCY EXTERIOR SLIDE LIGHT INOPERATIVE. REPLACED LIGHT BULB ON THE LEFT HAND AFT EXTERIOR SLIDE LIGHT AND PERFORMED SATISFACTORY OPERTIONAL CHECK GOOD. PER B-737 NG AMM 33-51-04.SDR AALA202407250498Panel · crackedAIRCRAFT IN BASE MAINTENANCE: DURING LEADING EDGE PANEL REMOVAL FOUND PANEL 521QB CRACKED AT CORNER NEXT TO SCREW HOLE. CHECKED AND ACCOMP PANEL EDGE REPAIR. PER SRM 51-70-10-2R-1 REPAIR 1SDR AALA202407242831Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: EXTERIOR EMERGENCY LIGHT AFT L1 DOOR INOPERATIVE. RELAMPED EXTERIOR EMERGENCY LIGHT, OPERTIONAL CHECK GOOD. PER AMM 33-51-04.SDR AALA202407245670Light · detachedAIRCRAFT WAS NOT GROUNDED: LIGHT ABOVE BAGGAG BIN AR SEAT 12 RIGHT HAND SIDE HANGING LOOSE. REATTACHED EMERGENCY LIGHT ABOVE BAGGAGE BIN AT ROW 12 RIGHT HAND SIDE. OPERTIONAL CHECK GOOD. PER MM 33-51-00.SDR AALA202407244095Light · detachedAIRCRAFT WAS NOT GROUNDED: EXIT LIGHT UNDER SEAT 13C HANGING DOWN IN ISLE. SECURED LIGHT CASE TOGETHER AT ROW 13 PER STANDARD PRACTICES.SDR AALA202407248539Lanyard · misinstalledAIRCRAFT WAS NOT GROUNDED: L1 DOOR SLIDE HAS PULLED OUT OF PACK. REINSTALLED L1 DOOR SLIDE GIRT BAR LANYARD. PER MM 25-66-01.SDR AALA202407241503Pin · shearedAIRCRAFT WAS GROUNDED: LEFT FORWARD BOARDING DOOR DIFFICULT TO CLOSE AND OPEN. INSPECTED DOOR, FOUND L-1 DOOR GUST LOCK PIN SHEARED, REMOVED AND INSTALLED SERVICEABLE L-1 DOOR GUST LOCK PIN, OPERTIONAL CHECK GOOD. PER AMM 52-11-21.SDR AALA202407242318Light · detachedAIRCRAFT WAS NOT GROUNDED: COVER FOR EMERGENCY EXIT ROW AISLE LIGHT AT 23C IS DETACHED. RESECURED EMERGENCY AISLE LIGHT. PER AMM 33-51-11.SDR AALA202407245213Floor Support · crazedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL UPPER ANGLE AT STA 500I, BL 0. REPLACED ANGLE PER AARD 51-00-05-1 AND SRM 51-40-02.SDR AALA202407248859Light · unsecureAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT PATH LIGHT AT BOTTOM OF SEAT 19C DAMAGED OR LOOSE MOUNT. RESECURED EMERGENCY SEAT MOUNTED LIGHT. OPERTIONAL CHECKS NORMAL.SDR AALA202407242768Door Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT LEFT DOOR KEEPS GETTING STUCK AND IS DIFFICULT TO OPEN. LUBRICATED LATCH. OPERTIONAL CHECK GOOD. PER CMM 25-47-23.SDR AALA202407240216Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: FORWARD FLIGHT ATTENDANT SEAT ONE LEFT FLASHLIGHT INOPERATIVE. REPLACED FORWARD FLIGHT ATTENDANT SEAT FLASHLIGHT. PER AMM 25-64-00.SDR AALA202407247894Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY ENTRY DOOR DIFFICULT TO OPEN AND CLOSE. ADJUSTED FORWARD LAVATORY DOOR AS REQUIRED. PER CMM 25-44-49.SDR AALA202407241290Flashlight · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY FLASHLIGHTS TEST FAILED. REPLACED FLASHLIGHT BATTERIES. PER AMM 25-64-00.SDR AALA202407230493Connector · incorrectAIRCRAFT WAS NOT GROUNDED: ROW 2AB FORWARD EMERGENCY LIGHT ON END BAY INOPERATIVE. INSTALLED CORRECT CONNECTORS P1 AND P2. OPERTIONAL CHECK GOOD. PER AMM 33-51-11.SDR AALA202407230127Link Pin · inoperativeAIRCRAFT WAS GROUNDED: FORWARD ENTRY DOOR L1 WILL NOT OPEN. REMOVED AND REPLACED L1 DOOR UPPER (AALA202407230127) AND LOWER (AALA202407230257) RADIUS LINK PIN. OPERTIONAL CHECK GOOD. PER MM 52-11-21.SDR AALA202407230257Link Pin · inoperativeAIRCRAFT WAS GROUNDED: FORWARD ENTRY DOOR L1 WILL NOT OPEN. REMOVED AND REPLACED L1 DOOR UPPER (AALA202407230127) AND LOWER (AALA202407230257) RADIUS LINK PIN. OPERTIONAL CHECK GOOD. PER MM 52-11-21.SDR AALA202407237365Guide · faultedAIRCRAFT WAS GROUNDED: L2 AFT ENTRY DOOR DOWN LOCK GUST LOCK LEVER (YELLOW) DOES NOT FULLY ENGAGE AND CANNOT KEEP DOOR FULLY OPEN. REMOVED AND REPLACED L2 AFT ENTRY DOOR GUIDE ARM ASSEMBLY. OPERTIONAL CHECK NORMAL. PER AMM 52-13-21.SDR AALA202407238218Engine · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: RIGHT ENGINE FAILURE INFLIGHT AT 10K'; AIRCRAFT AIR INTERRUPTED TO AND LANDED SAFELY AT DFW. REMOVE AND REPLACED RIGHT ENGINE. PER CARD 08L40072003.SDR AALA202407233993Tab · looseAIRCRAFT WAS NOT GROUNDED: ON FORWARD ENTRY DOOR, THE RED TABS ON THE GIRT BAR ARE LOOSE. RESECURED RED SHRINK TUBE.SDR AALA202407230370Tube · missingAIRCRAFT WAS NOPT GROUNDED: FORWARD GALLEY DOOR MISSING SHRINK WRAP ON GIRT BAR. REPLACED RED SHRINK TUBE.
Back to Boeing 737-823