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 AALA202105269015Connector · damagedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING CONNECTOR D11100 DAMAGED ON TOP OF BIN 19/20 ABC. REPLACED CONNECTOR PER SWPM 20-61-00.SDR AALA202106119008Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF WEB Z-ANGLE AT STA 992 AT RBL 32, MEASURING L=1.0 IN, W=1.0 IN, D=0.05 IN. REPLACED Z-ANGLE WITH NEW IAW AARD 51-00-05-1 AND DRAWING 147A5700.SDR AALA202106119024Web · corrodedAIRCRAFT IN BASE MAINTENANCE: FOUND CORRODED WEB AT STA 992 AND LBL 32. INSTALLED DOUBLE REPAIR REF EA 328189.SDR AALA202106119023Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: INTERCOSTAL CRACKED BETWEEN STA 278-294 AT BL-0. INSTALLED UPDATED INTERCOSTAL REF AARD 51-00-05-1.SDR AALA202106119022Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: INTERCOSTAL CRACKED BETWEEN STA 312-328 AT RBL 31. INSTALLED MODIFIED INTERCOSTAL IAW AARD 51-00-05-1.SDR AALA202106119020Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: NUMEROUS SPOTS OF CORROSION ON RIGHT CREASE ANGLE AT R2 DOOR LOCATED AT STA 951-992, RIGHT BUTT LINE 45. REMOVED AND REPLACED CREASE ANGLE PER SRM 51-40-02.SDR AALA202106119019Frame · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FOUND ON FRAME LOCATED AT STA 986, LEFT BUTT LINE 43. ANGLE REINFORCING REPAIR TO STATION 986 FLOOR SUPPORT FRAME.SDR AALA202106119018Frame · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FOUND ON FRAME LOCATED AT STA 986, LEFT BUTT LINE 34. REINFORCING ANGLE REPAIR TO THE STATION 986 FLOOR SUPPORT FRAME PER EA 328058.SDR AALA202106029012Skin · crackedAIRCRAFT IN BASE MAINTENANCE: RIGHT HORIZONTAL STABILIZER LOWER SKIN SHOWS AN INDICATION OF A CRACK ON LEFT SIDE OF RIB ST STA 101.90 LOCATED 11 INCHES FORWARD OF AFT SPAR. COMPLETED DOUBLER REPAIR PER SRM 55-10-01-2R-11.SDR AALA202106029011Skin · crackedAIRCRAFT IN BASE MAINTENANCE: RIGHT HORIZONTAL STABILIZER LOWER SKIN HAS INDICATION OF CRACK ON FORWARD SIDE OF AFT SPAR AT STA 97. INSTALLED DOUBLER REPAIR IAW SRM 55-10-01-2R-11.SDR AALA202105269020Stiffener · crackedAIRCRAFT IN BASE MAINTENANCE: CRANK ON LEFT HAND HORIZONTAL STABILIZER RIB STIFFENER, THIRD BACK FROM FRONT, LOCATED AT STA 166.30 FORWARD OF AFT SPAR. REPAIRED PER SRM 55-10-09-2R-4.SDR AALA202105259011Bushing · missingAIRCRAFT WAS NOT GROUNDED: MISSING BUSHING ON L1 DOOR GIRT BAR. REPLACED GIRT BAR IAW AMM 25-66-01, OPS CHECK GOOD.SDR AALA202105259009Connector · brokenAIRCRAFT IN BASE MAINTENANCE: ELECTRICAL CONNECTOR FROM AIRCRAFT TO AFT LOWER CEILING PANEL HAS BROKEN SLIDE HOUSING AT STA 907. REMOVED AND REPLACED CONNECTOR D40038P IAW 737-NG SWPM 20-72-24.SDR AALA202105259008Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: LAVATORY D DOOR LATCH VERY HARD TO MOVE. LUBRICATED DOOR LATCH USING PER AMM 20-30-12.SDR AALA202105279023Door · openAIRCRAFT WAS GROUNDED: DIVERSION DUE TO AIRFRAME VIBRATION, EMERGENCY DECLARED; RH EXTERNAL POWER PANEL OPEN ON ARRIVAL. CLOSED PANEL AND INSPECTED AIRCRAFT IAW AMM 05-51-67, NO ISSUES NOTED.SDR AALA202105249028Girt Bar · out of adjustAIRCRAFT WAS NOT GROUNDED: UNABLE TO ARM R1 DOOR . GIRT BAR STUCK. FREED GIRT BAR AND FABRIC FROM GIRT DOOR CLIP AMM 25-61-00.SDR AALA202105249029Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: ONE CABIN MEGAPHONE INOPERATIVE. REPLACED BATTERIES PER AMM 25-64-00.SDR AALA202105249026Megaphone · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT MEGAPHONE IS INOPERATIVE. REMOVED AND REPLACED AFT MEGAPHONE PER AMM 25-64-00.SDR AALA202106029015Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN INTERCOSTAL BETWEEN STA 312 AND STA 328 AT LBL 44, MEASURING L=2.375 IN, W=0.375 IN, D=0.062 IN. REPLACED INTERCOSTAL WITH NEW IAW AARD 51-00-05-1.SDR AALA202106019029Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LOWER SKIN OF RH HORIZONTAL STABILIZER INBD OF EXISTING DOUBLER. REMOVED INDICATED SKIN CRACKS AND EXISTING DOUBLER DUE TO INSUFFICIENT EDGE DISTANCE, ACCOMPLISHED PERMANENT REINFORCING DOUBLER REPAIR IAW SRM 55-10-01-R2.SDR AALA202105249024Shroud · damagedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT DAMAGED AT SEAT 20C. REPLACED PATH LIGHT SHROUD IAW CMM 25-23-6, OPS CHECK GOOD.SDR AALA202105269021Housing · damagedAIRCRAFT WAS NOT GROUNDED: EXPOSED WIRE FOR EMERGENCY LIGHT AT SEAT 22C. REPLACED EMERGENCY LIGHT HOUSING IAW AMM 25-21-00, OPS CHECK GOOD.SDR AALA202105259014Floor Support · missingAIRCRAFT IN BASE MAINTENANCE: MISSING INTERCOSTAL BETWEEN STA 328 AND STA 344 AT LBL10. INSTALLED PLUGS IAW BAC DRAWING 141A5720.SDR AALA202105249025Lens · looseAIRCRAFT WAS NOT GROUNDED: SEAT 29C EXIT PATH LIGHTING ON SIDE OF SEAT IS LOOSE AND HANGING. REMOVED AND REPLACED EMERGENCY LIGHT COVER BOX AT SEAT 29C IAW CMM 25-23-67.SDR AALA202105249022Hook · out of adjustAIRCRAFT WAS NOT GROUNDED: UNABLE TO ARM 1R DOOR. ADJUSTED GIRT BAR STORAGE CLIP. CHECK OK IAW AMM 25-66-01.SDR AALA202105249002Gusset · out of positionAIRCRAFT WAS GROUNDED: GROUND CREW REPORTED LEFT AFT ENTRY DOOR WAS NOT CLOSED PROPERLY AND FOUND A PART WHICH FELL FROM THE DOOR. PART THAT FELL WAS THE AFT SERVICE DOOR GUSSET LOCK PIN AND SPRING ASSY. INSTALLED NEW LEFT AFT SERVICE DOOR GUSSET LOCK PIN ASSESDR AALA202105239008Girt Bar · out of alignmentAIRCRAFT WAS NOT GROUNDED: COULD NOT ARM R1 DOOR SLIDE. REPOSITIONED GIRT BAR PER 25-66-01.SDR AALA202105269019Stiffener · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIB STIFFENER OF RH HORIZONTAL STABILIZER AT SSTA 92.70 AND 12.00 IN AFT OF FRONT SPAR, MEASURING L=1.0 IN, W=0.002 IN, D=0.05 IN. ACCOMPLISHED PERMANENT REINFORCING DOUBLER REPAIR IAW SRM 55-10-09-2R-4.SDR AALA202105249035Indicator · faultedAIRCRAFT WAS GROUNDED: FUEL IMBALANCE AND FUEL CONFIGURATION MESSAGES DURING CLIMB WITH ALL PUMP SWITCHES NORMAL, FLIGHT RETURNED TO FIELD. REPLACED UNIVERSAL FAULT INTERRUPTOR IAW AMM 28-22-99, OPS CHECK GOOD.SDR AALA202105249027Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR DIFFICULT TO OPEN. ADJUSTED LAVATORY DOOR IAW AMM 25-40-11, OPS CHECK GOOD.SDR AALA202105249021Cover · damagedAIRCRAFT WAS NOT GROUNDED: SEAT 18C ESCAPE PATH LIGHTING COVER DAMAGED. REPOSITIONED 18C LIGHT COVER IAW STANDARD PRACTICES, OPS CHECK GOOD.SDR AALA202105249018Track · stickingAIRCRAFT WAS NOT GROUNDED: LAVATORY D DOOR DIFFICULT TO OPEN AND CLOSE. CLEANED AND LUBRICATED UPPER TRACK ON LAV D DOOR IAW AMM 25-40-14, OPS CHECK GOOD.SDR AALA202105249014Isolator · brokenAIRCRAFT IN BASE MAINTENANCE: BROKEN ISOLATOR FOR HEADER ATTACHMENT OF RH AFT OVERWING EXIT. REPLACED ISOLATOR AT RH AFT OVER WING EXIT IAW B737NG SRM 51-40-02.SDR AALA202105249031Skin · delaminatedAIRCRAFT WAS GROUNDED: ON INBOARD FLAP ON RIGHT WING ABOVE THE SHARK BITE HAS A DELAMINATION SECTION OF 16 IN SQUARE INCHES. RIGHT INBOARD FLAP WAS REMOVED AND REPLACED IAW AMM 27-51-22.SDR AALA202105249019Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR DIFFICULT TO OPEN OR CLOSE. LUBRICATED AFT LEFT LAVATORY DOOR OPS NORMAL IAW AMM 25-40-14.SDR AALA202105249017Girt Bar · out of positionAIRCRAFT WAS NOT GROUNDED: CREW REPORTS 1R DOOR SLIDE DIFFICULT TO ARM. REPACKED GIRT BAR FLAP AND REINSTALLED SLIDE PACK PER WORK CARD 08L22125001.SDR AALA202105249016Girt Bar · out of positionAIRCRAFT IN BASE MAINTENANCE: CREW REPORTS 1L DOOR SLIDE DIFFICULT TO ARM. REPACKED GIRT BAR FLAP AND REINSTALLED SLIDE PACK PER WORK CARD 08L22125001.SDR AALA202105249034Control Unit · faultedAIRCRAFT WAS NOT GROUNDED: AUTOBRAKE DISARM LIGHT ILLUMINATED, FLIGHT REJECTED TAKEOFF. REPLACED ANTISKID/AUTOBRAKE CONTROL UNIT IAW AMM 32-42-21, OPS CHECKED GOOD.SDR AALA202105289023Charger · damagedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY POWER SUPPLY M1695 MISSING TEST BUTTON. REPLACED EMERGENCY BATTERY CHARGER IAW B737-NG AMM 33-51-06, OPS CHECK GOOD.SDR AALA202105279020Bulkhead Web · crackedAIRCRAFT IN BASE MAINTENANCE: FOUND CRACK IN VAPOR BARRIER RIGHT WHEEL WELL AT STA 663, STR 23R AND RBL 33. INSTALLED BONDED FABRIC PATCH REPAIR REF SRM 57-10-10-2R-2.SDR AALA202105219013Cover · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT COVER DETACHED AT SEAT 15C. REINSTALLED 15C EMERGENCY LIGHT COVER IAW AMM 33-51-11, OPS CHECK GOOD.SDR AALA202105219017Connector · unsecureAIRCRAFT WAS GROUNDED: DURING OPERATIONAL TEST OF EMERGENCY LIGHTS, FOUND FAULTY LIGHTS FROM 26 TO 33, LEFT HAND SIDE NOT WORKING. REPLACED RIGHT AFT BATTERY PACK (AALA202105219007) AND FOUND LOOSE P2 CONNECTOR AT 31A SIDEWALL. ALL OPERATIONS CHECKS OK PER AMMSDR AALA202105219012Fuse · blownAIRCRAFT IN BASE MAINTENANCE: RIGHT OVERWING EXIT HATCH INDICATOR EMERGENCY LIGHT INOPERATIVE. REPLACED FUSES IN POWER SUPPLY M1695 AND OPERATIONS CHECK GOOD PER B737NG AMM 33-51-00.SDR AALA202105219007Battery Pack · inoperativeAIRCRAFT WAS GROUNDED: DURING OPERATIONAL TEST OF EMERGENCY LIGHTS, FOUND FAULTY LIGHTS FROM 26 TO 33, LEFT HAND SIDE NOT WORKING. REPLACED RIGHT AFT BATTERY PACK AND FOUND LOOSE P2 CONNECTOR (AALA202105219017) AT 31A SIDEWALL. ALL OPERATIONS CHECKS OK PER AMMSDR AALA202105219011Oven · odorAIRCRAFT WAS GROUNDED: THREE FLIGHT ATTENDANTS COMPLAINING ABOUT A SMELL IN THE FORWARD AREA NEAR DOOR 1L. FUEL OR ELECTRICAL SMELL AND MILD IRRITATION TO EYES AND THROAT. ALSO, SMELLED IN FLIGHT DECK. ACCOMPLISHED SOF EVENT W/C 08L00021001 AND FOUND GALLEY G1SDR AALA202105219014Slide · out of alignmentAIRCRAFT WAS NOT GROUNDED: DOOR 1R GIRT BAR DOES NOT LINE UP WITH CLIPS. REPACKED R1 DOOR SLIDE PER AMM 25-66-01.SDR AALA202105209014Fuse · blownAIRCRAFT IN BASE MAINTENANCE: RIGHT OVERWING EXIT HATCH INDICATOR EMERGENCY LIGHT INOPERATIVE. REPLACED FUSES IN POWER SUPPLY M1695, OPERATIONS CHECK GOOD PER AMM 33-51-00.SDR AALA202105209012Window Frame · not reportedAIRCRAFT IN BASE MAINTENANCE: FLIGHT DECK RIGHT HAND #1 WINDOW CUT OUT FRAME C&D POST AT BS 219 AND S5R REQUIRES MIDIFICATION / REPAIR PER ECO J2009BA-0003. ACCOMPLISHED MODIFICATION / REPAIR OF WINDOW FRAME PER ECO J2009BA-0003.SDR AALA202105209011Window Frame · not reportedAIRCRAFT IN BASE MAINTENANCE: FLIGHT DECK LEFT HAND #1 WINDOW CUT OUT FRAME C&D POST AT BS 219 AND S5L REQUIRES MIDIFICATION / REPAIR PER ECO J2009BA-002. ACCOMPLISHED MODIFICATION / REPAIR OF WINDOW FRAME PER ECO J2009BA-002.SDR AALA202105289020Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LOWER SKIN OF LH STABILIZER AT SSTA 147 AND 26.0 IN AFT OF FRONT SPAR, MEASURING L=1.2 IN. ACCOMPLISHED PERMANENT REINFORCING DOUBLER REPAIR IAW SRM 55-10-01-2R.
Back to Boeing 737-823