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 AALA202506127305Computer · leakingAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: FEEL DIFFERENTIAL PRESS LIGHT ILLUMINATED ON CLIMBOUT AFTER TAKEOFF AT 1000FT, LIGHT WENT OUT AT 12,000FT, 295KTS. BUT THEN CAME BACK ON AGAIN FL320, 260KTS AND STAYED ON THE REMAINDER OF FLIGHT. REPEAT SDR AALA202506107305Warning Light · intermittentAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: FEEL DIFFERENTIAL PRESS LIGHT ILLUMINATED ON CLIMBOUT AFTER TAKEOFF AT 1000FT, LIGHT WENT OUT AT 12,000FT, 295KTS. BUT THEN CAME BACK ON AGAIN FL320, 260KTS AND STAYED ON THE REMAINDER OF FLIGHT. REPEAT SDR AALA202506101962Oven · odorAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTANDENT IS SAYING THE NUMBER 1 OVEN HAS A BURNING SMELL WHEN BEING USED. * (OPEN).SDR AALA202506103969Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: REAR LAVATORY ACCORDION DOOR HARD TO OPEN AND CLOSE. LUBRICATED TRACK DOOR, OPERTIONAL CHECK GOOD.SDR AALA202506106825Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: WHEN ATTEMPTING TO OPEN THE FLIGHT DECK DOOR WITH THE CORRECT CODE THE LIGHT ON THE DOOR TURNS YELLOW AND UPON TURNING GREEN TH EDOOR DOES NOT UNLOCK AND WILL NOT OPEN. LUBRICATED AND PERFORMED OPERATIONAL CHECK GOOD. PER AMM 52-51-0SDR AALA202506104685Flashlight · no testAIRCRAFT WAS NOT GROUNDED: ON PREFLIGHT, NUMBER 4 FLIGHT ATTANDENT POSITION FLASHLIGHT INOPERATIVE. **SUPPLEMENTAL REPORT FOR (AALA202506094685): REMOVED AND REPLACED FLIGHT ATTANDENT SEAT NUMBER 4 FLASHLIGHT. PER AMM: 25-64-00**(CLOSED.SDR AALA202506094685Flashlight · no testAIRCRAFT WAS NOT GROUNDED: ON PREFLIGHT, NUMBER 4 FLIGHT ATTANDENT POSITION FLASHLIGHT INOPERATIVE. (OPEN).SDR AALA202506090459Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR STICKS CLOSED. ADJUSTED LAVATORY-D DOOR. PER AMM 25-40-00 OPERTIONAL CHECK GOOD.SDR AALA202506093342Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD ENTRY DOOR L1 HANDLE REQUIRES EXCESSIVE FORCE TO OPEN AND CLOSE. ADJUSTED FORWARD ENTRY DOOR. PER AMM 52-11-00. OPERTIONAL CHECK GOOD.SDR AALA202506093908Liner · out of positionAIRCRAFT WAS NOT GROUNDED: FORWARD SERVICE DOOR SLIDE FABRIC LOOSE MAKING IT DIFFICULT TO ARM AND DISARM SLIDE. ADJUSTED FABRIC ON SLIDE AND LUBED LATCH. OPERTIONAL CHECKS GOOD.SDR AALA202506096022Locking Cam · missingAIRCRAFT WAS NOT GROUNDED: L1 DOOR SLIDE GIRT BAR MISSING WHITE TEFLON STOP THAT KEEPS GIRT BAR IN PLACE. INSTALLED L1 DOOR GIRT BAR LOCK. PER AMM 25-66-01-000-804.SDR AALA202506094710Light · inoperativeAIRCRAFT WAS NOT GROUNDED: RIGHT HAND FORWARD EMERGENCY EXIT OVERWING LIGHT IS INOPERATIVE. RELAMPED RIGHT HAND FORWARD EMERGENCY EXIT OVERWING LIGHT. PER MM 33-51-04. OPERTIONAL CHECK GOOD.SDR AALA202506234795Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 138.70, 16 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202506230563Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 138.70, 8 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202506109211Beam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN R1 DOOR BEAM. REPLACED BEAM PER SRM 52-10-02-01 AND CMM 52-41-05.SDR AALA202506098774Brace · seizedAIRCRAFT WAS GROUNDED: UPON CLEARING RUNWAY, BRAKES WOULD NOT RELEASE EVEN WITH AUTO BRAKES DISARMED. TOOK AN ABNORMALLY LARGE AMOUNT OF POWER TO KEEP MOVING AND WHEN ENGINES SPOOLED TO OVER 60% N1 FELT BRAKES SUDDENLY RELEASE WITH A JOLT. TOWER REPORTED MOMESDR AALA202506098697Brake · lockedAIRCRAFT WAS GROUNDED: UPON CLEARING RUNWAY, BRAKES WOULD NOT RELEASE EVEN WITH AUTO BRAKES DISARMED. TOOK AN ABNORMALLY LARGE AMOUNT OF POWER TO KEEP MOVING AND WHEN ENGINES SPOOLED TO OVER 60% N1 FELT BRAKES SUDDENLY RELEASE WITH A JOLT. TOWER REPORTED MOMESDR AALA202506093142Door · malfunctionedAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR HANDLE IS NOT WORKING PROPERLY CAN BE DIFFICULTTO OPEN DOOR. TROUBLESHOT AND FOUND BOTH INNER AND OUTER DOOR HANDLES PLUS BOTH INNER AND OUTER HANDLE MOUNT PLATES LOOSE. TIGHTNED DOOR HANDLE ASSEMBLY. PER AMM 25SDR AALA202506095784Tube · missingAIRCRAFT WAS NOT GROUNDED: DOOR ONE LEFT-GIR BART MISSING RED STOPPER. INSTALLED HEAT SHRINK. PER AMM 25-66-12.SDR AALA202506115484Door · bindingAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR IS HARD TO OPEN AND CLOSE. VERIFIED FORWARD LAVATORY DOOR STICKS ON BOTTOM THRESHOLD PLATE. DOOR HAS A HISTORY. **SUPPLEMENTAL REPORT FOR (AALA202506065484): REMOVED THRESHOLD, RESET POT NUT AND RESEALED THRESHOSDR AALA202506099304Floor Panel · scratchedAIRCRAFT IN BASE MAINTENANCE: SEVERAL SCRATCHES ON FLIGHT CONTROL COMPARTMENT FLOOR FROM BS 200 TO BS 230 AT RBL 20. REPLACED FLOOR PANEL PER DWG 141A5133.SDR AALA202506099396Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER UPPER ATTACH ANGLE AT STA 663, LBL 35. REPLACED ANGLE PER SRM 57-10-10-2R-5.SDR AALA202506095050Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER UPPER ATTACH ANGLE AT STA 663, LBL 35. REPLACED ANGLE PER SRM 57-10-10-2R-5.SDR AALA202506065484Door · bindingAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR IS HARD TO OPEN AND CLOSE. VERIFIED FORWARD LAVATORY DOOR STICKS ON BOTTOM THRESHOLD PLATE. DOOR HAS A HISTORY. (OPEN).SDR AALA202506064271Door · bindingAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR STICKS CLOSED. LUBED DOOR. PER AMM 52-50-00.SDR AALA202506065511Girt Bar · stuckAIRCRAFT WAS NOT GROUNDED: R1 AND R2 GIRT BARS VERY DIFFICULT TO UNSTOW. ADJUSTED GIRT BAR RETAINING CLIPS. PER AMM 21-66-01.SDR AALA202506061232Handle · brokenAIRCRAFT WAS NOT GROUNDED: LAVATORY-E DOOR HANDLE BROKEN. CAN NOT OPEN DOOR FROM INSIDE LAVATORY. INSTALLED SET SCREW. PER CMM 25-40-65.SDR AALA202506065936Light · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT ABOVE SEAT 24D INOPERATIVE. REMOVE AND REPLACED EMERGENCY LIGHT ABOVE SEAT 24C. PER AMM 33-51-00.SDR AALA202506061819Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: LAVATORY-E DOOR STICKS AND DIFFICULT TO OPEN AND CLOSE. LUBRICATED DOOR SILL AND LOCK MECHANISM.SDR AALA202506068812Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS THAT THE DOOR TO THE FORWARD LAVATORY STICKS AND IS VERY DIFFICULT TO OPEN. LUBRICATED LAVATORY DOOR HINGE. OPERTIONAL CHECKS NORMAL. PER AMM 52-10-00SDR AALA202506060922Web · wornAIRCRAFT IN BASE MAINTENANCE: WEAR MARKS ON WEB, ABOVE E & E COMPARTMENT RIGHT HAND DOOR LATCH, LOCATED AT BS 340, RBL 11. REPLACED WEB PER AARD 51-00-05-1.SDR AALA202506173241Rib · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON INBOARD BOTTOM SIDE OF LEFT HAND WINGLET RIB 0. REPLACED WINGLET PER JOB CARD 08C52057001 AND JOB CARD 08C52057004.SDR AALA202506104888Air Filter · odorAIRCRAFT WAS GROUNDED: AIRCRAFT HAS SIGNIFICANT WOODY BURNT SMELL THROUGHOUT ENTIRE CABIN. REMOVE AND REPLACED LEFT HAND RECIRCULATION FAN (AALA202506056042), PER AMM 21-25-02. REMOVE AND REPLACED LEFT HAND RECIRCULATION FILTER (AALA202506104888), PER AMM 21-SDR AALA202506106532Battery · burnedAIRCRAFT WAS GROUNDED: AIRCRAFT HAS SIGNIFICANT WOODY BURNT SMELL THROUGHOUT ENTIRE CABIN. **SUPPLEMENTAL REPORT FOR (AALA202506056042): REMOVE AND REPLACED LEFT HAND RECIRCULATION FAN (AALA202506056042), PER AMM 21-25-02. REMOVE AND REPLACED LEFT HAND RECIRCUSDR AALA202506104603Shroud · odorAIRCRAFT WAS GROUNDED: AIRCRAFT HAS SIGNIFICANT WOODY BURNT SMELL THROUGHOUT ENTIRE CABIN. REMOVE AND REPLACED LEFT HAND RECIRCULATION FAN (AALA202506056042), PER AMM 21-25-02. REMOVE AND REPLACED LEFT HAND RECIRCULATION FILTER (AALA202506104888), PER AMM 21-SDR AALA202506106042Fan · failedAIRCRAFT WAS GROUNDED: AIRCRAFT HAS SIGNIFICANT WOODY BURNT SMELL THROUGHOUT ENTIRE CABIN. **SUPPLEMENTAL REPORT FOR (AALA202506056042): REMOVE AND REPLACED LEFT HAND RECIRCULATION FAN (AALA202506056042), PER AMM 21-25-02. REMOVE AND REPLACED LEFT HAND RECIRCUSDR AALA202506058731Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT LAVATORY-D DOOR STICKS AND IS DIFFICULT TO OPEN AND CLOSE. ACCOMPLISHED LAVATORY-D LUBE OF DOOR AND HINGES. PER AMM 25-40-14.SDR AALA202506053166Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT UNDER NUMBER 1 JUMP SEAT IS DEAD. REPLACED 1L FLIGHT ATTENDANT SEAT FLASHLIGHT, OPERTIONAL CHECK GOOD. PER AMM 25-64-00.SDR AALA202506058763Door · inoperativeAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR CANNOT BE OPENED FROM OUTSIDE. RESET DOOR LOCKING MECHANISM, OPERTIONAL CHECK GOOD. PER AMM 52-51-01.SDR AALA202506056042Unknown · odorAIRCRAFT WAS GROUNDED: AIRCRAFT HAS SIGNIFICANT WOODY BURNT SMELL THROUGHOUT ENTIRE CABIN. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202506055554Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER ATTACH ANGLE AT STA 663.5, LBL 1. REPAIRED ANGLE PER SRM 57-10-10-2R-5.SDR AALA202506058394Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT SHIELD AT BS 767, RBL 23. REPLACED SHIELD PER AARD 51-0-05-1.SDR AALA202506093966Light · brokenAIRCRAFT WAS NOT GROUNDED: SEAT 32C EMERGENCY LIGHT HOUSING UNDER THE SEAT IS BROKEN AND HANGING. REMOVED AND REPLACED EMERGENCY LIGHT HOUSING. OPERTIONAL CHECKED LIGHT GOOD. PER AMM 33-51-11.SDR AALA202506094214Stop Fitting · unsecureAIRCRAFT IN BASE MAINTENANCE: RIGHT AFT OVER WING EXIT DOOR, AFT FRAME UPPER STOP FITTING LANDING PAD IS UNSECURED. SECURED RIGHT HAND AFT OVER WING EXIT DOOR FITTING FRAME STOP FITTING. PER B737 AMM 52-22-01.SDR AALA202506094137Stop Fitting · unsecureAIRCRAFT IN BASE MAINTENANCE: LEFT AFT OVER WING EXIT DOOR, AFT FRAME UPPER STOP FITTING LANDING STOP PAD IS UNSECURED. SECURED LEFT AFT OVER WING EXIT DOOR, AFT FRAME UPPER STOP FITTING LANDING STOP PAD. PER B737 AMM 52-22-01-400-801.SDR AALA202506094398Stop Fitting · unsecureAIRCRAFT IN BASE MAINTENANCE: LEFT FORWARD OVER WING EXIT DOOR, AFT FRAME UPPER STOP FITTNG STOP PAD IS UNSECURED. SECURED LEFT FORWARD OVER WING EXIT DOOR, AFT FRAME UPPER STOP FITTING STOP PAD. PER B737 AMM 52-22-01-400-801.SDR AALA202506057208Roller · disengagedAIRCRAFT WAS GROUNDED: L1 DOOR GUST LOCK WILL NOT ENGAGE. **SUPPLEMENTAL REPORT FOR (AALA202506040273): INSTALLED AND RIGGED GUIDE ARM (AALA202506040273) AND ROLLER ASSEMBLY (AALA202506057208) ON L1 FORWARD ENTRY DOOR. PER AMM 52-11-21**(CLOSED).SDR AALA202506050273Guide Arm · disengagedAIRCRAFT WAS GROUNDED: L1 DOOR GUST LOCK WILL NOT ENGAGE. **SUPPLEMENTAL REPORT FOR (AALA202506040273): INSTALLED AND RIGGED GUIDE ARM (AALA202506040273) AND ROLLER ASSEMBLY (AALA202506057208) ON L1 FORWARD ENTRY DOOR. PER AMM 52-11-21**(CLOSED).SDR AALA202506043518Sign · detachedAIRCRAFT WAS NOT GROUNDED: LEFT AFTER ENTRY DOOR EXIT SIGN COVER CAME LOOSE AND DETACHED. REMOVED AND REPLACED AFTER LEFT EMEGENCY DOOR LIGHT AND COVER. PER AMM 33-51-01. OPERTIONAL CHECKS GOOD.SDR AALA202506040273Gust Lock · inoperativeAIRCRAFT WAS GROUNDED: L1 DOOR GUST LOCK WILL NOT ENGAGE. (OPEN).
Back to Boeing 737-823