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 AALA202403133032Tube · missingAIRCRAFT WAS NOT GROUNDED: R1 DOOR SLIDE GIRT BAR MISSING RED HEAT SHRINK. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202403136231Retainer · brokenAIRCRAFT WAS NOT GROUNDED: FORWARD SERVICE DOOR GIRT BAR HAS A WHITE PLASTIC PIECE THAT IS LOOSE ON THE RIGHT SIDE NEXT TO THE RED PORTION OF THE BAR. REPLACED BROKEN PLASTIC RETAINER ON R1 DOOR SLIDE. PER 25-66-01.SDR AALA202403134438Light · intermittentAIRCRAFT WAS NOT GROUNDED: LEFT AFT OVERWING EMERGENCY LIGHT FLICKERING. REMOVE AND REPLACED LEFT AFT OVERWING EXIT LIGHT. PER AMM 33-21-00. FUNCTIONAL CHECK GOOD.SDR AALA202403138173Door Sill · out of adjustAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY SLIDE LOCK IS BROKEN. CLEANED AND ADJUSTED LEFT AFT LAVATORY DOOR SILL. PER AMM 25-40-00. FUNCTIONAL CHECK NORMAL.SDR AALA202403136452Lock · stickingAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR LOCK REPORTED STICKING AND HARD TO OPERATE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202403135172Housing · brokenAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT BASE BROKEN. REMOVED AND REPLACED LIGHT ASSY AT ROW 17 DEF. PER AMM 33-51-01. OPERATIONAL TESTED GOOD.SDR AALA202403134251Lens · missingAIRCRAFT WAS NOT GROUNDED: AFT GALLEY EMERGENCY EXIT LIGHT COVER MISSING. REMOVED AND REPLACED AFT GALLEY EMERGENCY EXIT LIGHT ASSEMBLY. PER AMM 33-51-01. FUNCTIONAL CHECK GOOD CHECK GOOD.SDR AALA202403126920Light · detachedAIRCRAFT WAS NOT GROUNDED: SEAT 9C EMERGENCY EXIT LIGHT HAS FALLEN OFF. SECURED EMERGENCY LIGHT AT SEAT 9C PER AMM 33-50-00. OK FOR SERVICE.SDR AALA202403153431Plate · crackedAIRCRAFT WAS GROUNDED: RIGHT HORIZONTAL STABILIZER UPPER SLIDER ASSEMBLY PLATE CRACKED APPROXIMATELY 2 INCH LONG THROUGH AFT LOWER FASTENER LOCATION.**SUPPLEMENTAL REPORT FOR (AALA202403123431): APPLIED SPEED TAPE AT RIGHT HORIZONTAL STABILIZER UPPER SLIDE ASSSDR AALA202403156478Tube · damagedAIRCRAFT WAS NOT GROUNDED: R2 SLIDE GIRT BAR REQUIRES HEAT SHRINK REPLACEMENT. PER AARD 24-66-00-4. **SUPPLEMENTAL REPORT FOR (AALA202403126478): REPLACED HEAT SHRINK ON R2 SLIDE GIRT BAR. PER AARD 24-66-00-4 **(CLOSED).SDR AALA202403151981Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER RIB AT STABILIZER STATION 92.70. REPLACED RIB PER SRM 51-40-02 AND AARD 51-00-05-1.SDR AALA202403123431Plate · crackedAIRCRAFT WAS GROUNDED: RIGHT HORIZONTAL STABILIZER UPPER SLIDER ASSEMBLY PLATE CRACKED APPROXIMATELY 2 INCH LONG THROUGH AFT LOWER FASTENER LOCATION.**SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202403123908Lock Mechanism · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT RIGHT LAVATORY LOCK DIFFICULT TO OPERATE. LUBRICATED RIGHT LAVATORY DOOR LOCKING MECHANISM. OPERATIONAL CHECK GOOD. PER CMM 25-40-65.SDR AALA202403126478Tube · missingAIRCRAFT WAS NOT GROUNDED: R2 SLIDE GIRT BAR REQUIRES HEAT SHRINK REPLACEMENT. PER AARD 24-66-00-4. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202403120680Door Frame · damagedAIRCRAFT WAS NOT GROUNDED: FRONT LAVATORY DOOR STICKS, BOTTOM PORTION OF THE METAL FRAME ON THE RIGHT IS DAMAGED. ADJUSTED AND LUBRICATED LAVATORY DOOR FRAME. PER CMM 25-40-61. OK FOR SERVICE.SDR AALA202403144611Tube · missingAIRCRAFT WAS NOT GROUNDED: AFT SERVICE DOOR IS MISSING RED TAB ON GIRT BAR.**SUPPLEMENTAL REPORT FOR (AALA202403114611): INSTALLED RED HEAT SHRINK ON AFT RIGHT HAND GIRT BAR AS REQUIRED**(CLOSED).SDR AALA202403116764Extinguisher · dischargedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: FIRE EXTINGUISHER DISCHARGED IN THE FLIGHT DECK. ONLY CLEAR GAS EXPELLED; AIRCRAFT DIVERTED TO AND LANDED SAFELY AT BNA. REMOVED AND REPLACED FLIGHT DECK FIRE EXTINGUISHER. PER AMM 26-26-01.SDR AALA202403115046Track · looseAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY-D DOOR DIFFICULT TO OPERATE. TIGHTEN LOOSE SCREW ON UPPER TRACK. PER 20-22-00. OK FOR SERVICE. DOOR OPERATES PROPERLY.SDR AALA202403110423Light · detachedAIRCRAFT WAS GROUNDED: 32C ISLE EMERGENCY LIGHT IS DETACHED. REMOVE AND REPLACED EMERGENCY FLOOR PROXIMITY LIGHT ASSEMBLY AT 32C. PER AMM 33-51-11. OPERATIONAL CHECK GOOD.SDR AALA202403114611Tab · missingAIRCRAFT WAS NOT GROUNDED: AFT SERVICE DOOR IS MISSING RED TAB ON GIRT BAR. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202403126201Flt Controls · noneAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: ON CLIMB OUT, AIRCRAFT HAD HIGH VIBRATIONS AT HIGH POWER SETTINGS. FLIGHT CONTROLS FELT MUSHY AND AUTOPILOT KICKED OFF TWICE AFTER GEAR AND FLAPS WERE RETRACTED; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDSDR AALA202403116201Unknown · vibrationAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: ON CLIMB OUT, AIRCRAFT HAD HIGH VIBRATIONS AT HIGH POWER SETTINGS. FLIGHT CONTROLS FELT MUSHY AND AUTOPILOT KICKED OFF TWICE AFTER GEAR AND FLAPS WERE RETRACTED; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDSDR AALA202403111816Oven · odorAIRCRAFT WAS GROUNDED: FLIGHT ATTENDANT NUMBER 2 OVEN HAS AN ELECTRICAL SMELL. REMOVED AND REPLACED NUMBER 2 GALLEY OVEN. PER AMM 25-32-03. ALL CHECK NORMAL.SDR AALA202403115604Retainer · brokenAIRCRAFT WAS GROUNDED: DURING R1 SLIDE REMOVAL RETAINER CLIP FOR GIRT BAR NYLON BUSHING BROKEN. INSTALLED NEW GIRT BAR. PER AMM 25-66-01.SDR AALA202403115924Indicator · intermittentAIRCRAFT WAS NOT GROUNDED: LEFT FUEL TANK AFT BOOST PUMP LOW PRESSURE LIGHT DOES NOT ILLUMINATE WHEN SWITCH TURNED OFF ON SHUTDOWN. REPLACED LEFT AFT BOOST PUMP LOW PRESSURE SWITCH. PER AMM 33-18-00. TEST OK.SDR AALA202403110533Light · brokenAIRCRAFT WAS GROUNDED: EMERGENCY LIGHT LENS AND COVER BROKEN SEAT 31C. REMOVED AND REPLACED EMERGENCY PATH LIGHT AT SEAT 32C. PER AMM 33-51-11. OPERATIONAL CHECK GOOD.SDR AALA202403117246Light · brokenAIRCRAFT WAS GROUNDED: EMERGENCY LIGHT LENS FOR SEAT 24C BROKEN. REMOVE AND REPLACED PATH LIGHTING ASSEMBLY ON SEAT 24C. PER AMM 33-51-11. OPERATIONAL CHECK GOOD.SDR AALA202403113978Skin · noneAIRCRAFT IN BASE MAINTENANCE DOCUMENTING EXISTING FUSELAGE SKIN DOUBLER REPAIR BETWEEN STA 727E AND 727F, BETWEEN S27L AND S27R. EXISTING REPAIR ACCOMPLISHED PER SRM 53-00-01-2R-3 REPAIR 3.SDR AALA202404091772Skin · dentedAIRCRAFT IN BASE MAINTENANCE: AFT LOWER FUSELAGE HAS DENTS (FOUND TO BE PREVIOUS BLENDS), AT BS 967, S23L. REPAIRED SKIN PER EA 352758.SDR AALA202404019116Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND WHEEL WELL VAPOR BARRIER AT BS 663.75, FROM LBL 31.83 TO LBL 54.21. REPARED VAPOR BARRIER PER AARD 57-10-10-9 AND SRM 51-70-04-2R-10.SDR AALA202403183505Pump · false indicationAIRCRAFT WAS NOT GROUNDED: LEFT CENTER FUEL LOW PRESSURE LIGHT ILLUMINATING DURING FLIGHT. RIGHT CENTER PUMP WORKING NORMAL. LEFT CENTER PUMP LOW PRESSURE LIGHT DID NOT EXTINGUISH UNTIL SWITCH WAS TURNED OFF. ACCOMPLISHED SATISFACTORY FUEL BOOST PUMP TEST PERSDR AALA202403120860Flashlight · inoperativeAIRCRAFT IN BASE MAINTENANCE: FORWARD AFT LEFT HAND AND AFT RIGHT HAND FLIGHT ATTENDANTS SEAT FLASHLIGHTS NEED TO BE REPLACED. REMOVED AND REPLACED FORWARD AFT LEFT HAND (AALA202403120860) AND AFT RIGHT HAND (AALA202403127521) FLIGHT ATTENDANTS SEAT FLASHLIGHTSDR AALA202403127521Flashlight · inoperativeAIRCRAFT IN BASE MAINTENANCE: FORWARD AFT LEFT HAND AND AFT RIGHT HAND FLIGHT ATTENDANTS SEAT FLASHLIGHTS NEED TO BE REPLACED. REMOVED AND REPLACED FORWARD AFT LEFT HAND (AALA202403120860) AND AFT RIGHT HAND (AALA202403127521) FLIGHT ATTENDANTS SEAT FLASHLIGHTSDR AALA202403089165Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT LAVATORY-D DOOR DIFFICULT TO OPEN AND CLOSE. LUBRICATED LAVATORY-D DOOR. FUNCTIONAL CHECK GOOD.SDR AALA202403089997Sliding Window · off trackAIRCRAFT WAS GROUNDED: RAMPERS REPORT THE FIRST OFFICER SLIDING WINDOW FELL OFF ITS TRACKS DURING REPOSITION BACK TO GATE FROM PAD. RE-ENGAGED FIRST OFFICER SLIDING WINDOW INTO ITS TRACKS. PER AMM 56-12-11, OPERATIONAL CHECKS GOOD. PERFORMED CABIN PRESSURE LEASDR AALA202403083505Pump · faultedAIRCRAFT WAS NOT GROUNDED: LEFT CENTER FUEL LOW PRESSURE LIGHT ILLUMINATING DURING FLIGHT. RIGHT CENTER PUMP WORKING NORMAL. LEFT CENTER PUMP LOW PRESSURE LIGHT DID NOT EXTINGUISH UNTIL SWITCH WAS TURNED OFF. OPENSDR AALA202403081754Light · dislodgedAIRCRAFT WAS NOT GROUNDED: SEAT 30C EMERGENCY LIGHT DISLODGED FROM SIDE OF SEAT. REINSTALLED EMERGENCY LIGHT ASSEMBLY AT SEAT 30C. PER AMM 33-51-11. OPERATIONAL CHECK GOOD.SDR AALA202403078090Power Supply · inoperativeAIRCRAFT WAS NOT GROUNDED: POWER SUPPLY AT 17R INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY AT 17R. PER AMM 44-12-00.SDR AALA202403195518Skin · puncturedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STAB UPPER SURFACE HAS A PUNCTURE APPROX 5 INCHES AFT OF THE FORWARD SPAR AND 85 INCHES FROM THE OUTBOARD EDGE. ACCOMPLISHED INSTALLATION OF REPAIR DOUBLER PER EA 352680 ON LEFT HAND HORIZONTAL STABILIZER UPPSDR AALA202403085518Skin · puncturedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STAB UPPER SURFACE HAS A PUNCTURE APPROX 5 INCHES AFT OF THE FORWARD SPAR AND 85 INCHES FROM THE OUTBOARD EDGE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202403071721Girt Bar · out of adjustAIRCRAFT WAS NOT GROUNDED: #4 FLT ATTENDANT REPORTS THAT L2 GIRT BAR IS WAY TOO HARD TO MOVE FROM ARM TO DISARM POSITION. CLEANED AND ADJUSTED L2 DOOR GIRT BAR. PER AMM 25-66-01. CHECK NORMAL.SDR AALA202403077502Girt Bar · out of adjustAIRCRAFT WAS NOT GROUNDED: #4 FLIGHT ATTENDANT REPORT THAT R2 DOOR GIRT BAR IS WAY TOO HARD TO MOVE FROM ARM TO DISARM POSITION. CLEANED AND ADJUSTED R2 DOOR GIRT BAR. PER AMM 25-66-01. CHECK NORMAL.SDR AALA202403074964Warning Message · false indicationAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: RIGHT WING-BODY OVERHEAT LIGHT ILLUMINATED AROUND 1500 AND STAYED ON; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT MIA. ACCOMPLISHED WORK CARD 08C44126001. NO FAULTS NOTED. OPERTIONAL CHECK NORMSDR AALA202403072616Power Supply · inoperativeAIRCRAFT WAS NOT GROUNDED: LEFT AFT SERVICE DOOR, AFT ESCAPE SLIDE LIGHT INOPERATIVE. FOUND LIGHT ASSEMBLY HAD NO VOLTAGE TO ASSEMBLY. REPLACED POWER SUPPLY AT M1673. OPERATIONAL CHECK GOOD. PER B737 AMM 33-51-06 AND CARD 08T20033001.SDR AALA202403063453Fitting · noneAIRCRAFT IN BASE MAINTENANCE: CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 54.60 REPLACEMENT REQUIRED PER BOEING SERVICE BULLETIN B737-57-1309. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202403064332Fitting · 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 B737-57-1309.SDR AALA202403066274Fitting · 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 B737-57-1309.SDR AALA202403062078Fitting · 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 B737-57-1309.SDR AALA202403062971Fitting · 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 B737-57-1309.SDR AALA202403062004Fitting · 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 B737-57-1309.
Back to Boeing 737-823