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 AALA202510165137Battery Pack · inoperativeAIRCRAFT WAS NOT GROUNDED: RIGHT HAND OVERWING FORWARD DOOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED BATTERY PACK AT SEAT ROW 15EFD. PER AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR AALA202510166090Girt Bar · jammedAIRCRAFT WAS NOT GROUNDED: FORWARD RIGHT DOOR GIRT BAR JAMMED WILL NOT ARM. REMOVED JAM ON FORWARD RIGHT DOOR. OPERATIONAL CHECK GOOD. PER AMM 52-11-00.SDR AALA202510165292Door · stuckAIRCRAFT WAS NOT GROUNDED: AFTER LEFT LAVATORY DOOR STUCK CLOSED. ADJUSTED AFT LEFT LAVATORY DOOR AND LUBED ROLLER AND TRACKS DOOR. PER CMM 25-40-64.SDR AALA202510164129Light · dislodgedAIRCRAFT WAS GROUNDED: EMERGENCY LIGHT AT 15C FELL OUT AND THE WIRE IS STICKING OUT INTO THE ISLE. REMOVED AND REPLACED 15C EMERGENCY LIGHT ON END BAY. PER CMM 25-23-67. OPERATIONAL CHECK GOOD.SDR AALA202510163066Slide · unsecureAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS FORWARD SERVICE DOOR SLIDE APPEARS TO BE COMING OUT OF CASING. SECURED FORWARD SERVICE DOOR SLIDE BACK INTO CASE. PER AMM 25-66-00.SDR AALA202510168335Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR HARD TO OPEN. CLEANED AND LUBED LATCH, OPERATIONAL CHECK GOOD. PER AMM 52-51-00.SDR AALA202510162745Slide · unsecureAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANTS FOUND SOME YELLOW SLIDE MATERIAL EXTENDING OUT OF THE BOTTOM OF THE SLIDE BUSTLE ON DOOR L1, THE MAIN CABIN DOOR. RESTORED THE L1 DOOR YELLOW MATERIAL OF THE SLIDE AND SLIDE ENGAGEMENT NORMAL. PER AMM 25-66-00.SDR AALA202510162008Flashlight · no testAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS FORWARD RIGHT JUMPSEAT FLASHLIGHT BATTERY IS DEAD. REMOVED AND REPLACED FORWARD FLIGHT ATTENDENT SEAT FLASHLIGHT BATTERY. PER AMM 25-64-00. OPERATIONAL CHECK GOOD.SDR AALA202510154479Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER IN RIGHT HAND WHEEL WELL AT STA 663, RBL 50. REPAIRED VAPOR BARRIER PER SRM 57-10-10-2R-2.SDR AALA202510154678Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CARCK IN PASSENGER CABIN FLOORBEAM ASSEMBLY PANEL LOCATED AT BS 540, LBL 2. REPLACED FLOORBEAM ASSEMBLY PANEL PER AARD 51-00-05-1.SDR AALA202510236114Skin · wornAIRCRAFT IN BASE MAINTENANCE: WEAR TO UPPER FUSELAGE CROWN SKIN AT BS 847, S1. ACCOMPLISHED REPAIR PER SRM 53-00-01-2R-35 AND EA 368897.SDR AALA202510204726Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT SHIELD AT BS 957, RBL 20. REPLACED SHIELD PER AARD 51-00-05-1.SDR AALA202510309904Tab · corrodedAIRCRAFT IN BASE MAINTENANCE: RIGHT ELEVATOR TAB CONTROL MECHANISM SPRING SUPPORT BUSHINGS SHOW SIGNS OF CORROSION. REMOVED AND INSTALLED NEW BUSHINGS ON THE RIGHT HAND ELEVATOR TAB CONTROL MECHANISMS. PER B737NG AMM 27-31-34 AND PERFORMED SATISFACTORYELEVATORSDR AALA202510307902Control Quadrant · corrodedAIRCRAFT IN BASE MAINTENANCE: LEFT ELEVATOR TAB CONTROL MECHANISM SPRING SUPPORT BUSHINGS SHOW SIGNS OF CORROSION. REMOVED AND REPLACED LEFT ELEVATOR TAB CONTROL MECHANISMS SPRING SUPPORT NEW BUSHINGS. PER B737NG AMM 27-31-34 AND PERFORMED SATISFACTORY ELEVATOSDR AALA202510168638Controller · leakingAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING CLIMBOUT, RIGHT FUEL QUANTITY BEGAN DECREASING RAPIDLY. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT DFW. DURING TROUBLESHOOTING AND LEAK CHECK FOUND FUEL LEAK COMING FROM HPTACC DRAIN MSDR AALA202510162347Heat Shrink · missingAIRCRAFT WAS NOT GROUNDED: RED HEAT SHRINK MISSTING AT L1 DOOR GIRT BAR. REPLACED RED HEAT SHRINK TUBING. PER AARD 25-66-00-4.SDR AALA202510136335Controller · inoperativeAIRCRAFT WAS GROUNDED: CABIN EMERGENCY EXIT LIGHTS FLICKERING INTERMITTENTLY WHILE TAXING TO GATE. FOUND LEFT HAND EMERGENCY EXIT CEILING LIGHTS AT SEAT ROW 3, 10,AND 14 TURNING ON WITH SWITCH OFF. PER AMM 33-51-06 REMOVE AND REPLACED POWER SUPPLY (AALA202510SDR AALA202510139837Heat Shrink · missingAIRCRAFT WAS NOT GROUNDED: RED HEAT SHRINK MISSING AT L1 DOOR GIRT BAR. (OPEN).SDR AALA202510138180Fuel Sys · abnormalAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING CLIMBOUT, RIGHT FUEL QUANTITY BEGAN DECREASING RAPIDLY. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT DFW. (OPEN).SDR AALA202510138247Lamp · burned outAIRCRAFT WAS NOT GROUNDED: AFT L2 DOOR EXTERIOR EMERGENCY LIGHT OUT. RELAMPED, PER AMM 33-51-04. OPS CHECKED GOOD.SDR AALA202510136598Track · dirtyAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR IS JAMMED. CLEANED DOOR TRACK ON LAVATORY-D, OP CHECK GOOD. REF CMM 25-40-64.SDR AALA202510136303Power Supply · inoperativeAIRCRAFT WAS GROUNDED: CABIN EMERGENCY EXIT LIGHTS FLICKERING INTERMITTENTLY WHILE TAXING TO GATE. FOUND LEFT HAND EMERGENCY EXIT CEILING LIGHTS AT SEAT ROW 3, 10,AND 14 TURNING ON WITH SWITCH OFF. PER AMM 33-51-06 REMOVE AND REPLACED POWER SUPPLY (AALA202510SDR AALA202510132156Baffle · not reportedAIRCRAFT IN BASE MAINTENANCE: EXISTING REPAIR TO FORWARD CARGO COMPARTMENT FLOOR STRUCTURE BAFFLE BETWEEN BS 500E AND 500F AT S26R REQUIRES REPLACEMENT. REPLACED BAFFLE PER AARD 51-00-05-1.TLESDR AALA202510135391Baffle · not reportedAIRCRAFT IN BASE MAINTENANCE: EXISTING REPAIR TO FORWARD CARGO COMPARTMENT FLOOR STRUCTURE BAFFLE BETWEEN BS 500C AND 500D AT S26L REQUIRES REPLACEMENT. REPLACED BAFFLE PER AARD 51-00-05-1.SDR AALA202510209104Relay · inoperativeAIRCRAFT WAS GROUNDED: ON CLIMB OUT WE OBSERVED FUEL IMBALANCE AMBER ALERT ON RIGHT WING TANK IN EXCESS OF 1,000 POUNDS AND INCREASING RAPIDLY WITH ALL PUMPS CONFIGURED PROPERLY. VERIFIED RIGHT CENTER BOOST PUMP INOPERATIVE CAUSING FUEL IMBALANCE ON CLIMB OUT.SDR AALA202510205986Relay · faultyAIRCRAFT WAS GROUNDED: ON CLIMB OUT WE OBSERVED FUEL IMBALANCE AMBER ALERT ON RIGHT WING TANK IN EXCESS OF 1,000 POUNDS AND INCREASING RAPIDLY WITH ALL PUMPS CONFIGURED PROPERLY. VERIFIED RIGHT CENTER BOOST PUMP INOPERATIVE CAUSING FUEL IMBALANCE ON CLIMB OUT.SDR AALA202510201055Fuel Tank · leakingAIRCRAFT IN BASE MAINTENANCE: FUEL CENTER TANK SHOWS LEAK FROM LEFT MIDDLE SIDE OF THE KEEL BEAM AREA. DESEALED, CLEANED AND RESEALED INTERNAL CENTER TANK AT FORWARD SIDE OF RIB 6. FROM LEFT WING RIB 1 TO RIGHT WING RIB 1. PERFORMED SATISFACTORY LEAK CHECK, SDR AALA202510130958Door Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: LAVATORY-D LOCK DIFFICULT TO ENGAGE WHICH MAKES THE DOOR DIFFICULT TO OPEN. LUBED DOOR LOCKING RECEPTICLE. PER AMM 25-40-14.SDR AALA202510132393Flashlight · inoperativeAIRCRAFT IN BASE MAINTENANCE: AT L1 FLIGHT ATTENDANT SEAT, 2 FLASHLIGHTS REQUIRE BATTERY CHANGE. REMOVED AND REPLACED 2EA L1 FLASHLIGHT BATTERIES (AALA202510132393), (AALA202510135466) . PER AMM 25-60-00.SDR AALA202510135466Flashlight · inoperativeAIRCRAFT IN BASE MAINTENANCE: AT L1 FLIGHT ATTENDANT SEAT, 2 FLASHLIGHTS REQUIRE BATTERY CHANGE. REMOVED AND REPLACED 2EA L1 FLASHLIGHT BATTERIES (AALA202510132393), (AALA202510135466) . PER AMM 25-60-00.SDR AALA202510135986Pump · faultedAIRCRAFT WAS GROUNDED: ON CLIMB OUT WE OBSERVED FUEL IMBALANCE AMBER ALERT ON RIGHT WING TANK IN EXCESS OF 1,000 POUNDS AND INCREASING RAPIDLY WITH ALL PUMPS CONFIGURED PROPERLY. VERIFIED RIGHT CENTER BOOST PUMP INOPERATIVE CAUSING FUEL IMBALANCE ON CLIMB OUT.SDR AALA202510135026Cradle · inoperativeAIRCRAFT WAS NOT GROUNDED: 2 FLIGHT ATTENDANT EMERGENCY FLASHLIGHTS INOPERATIVE. REMOVED AND REPLACED FLIGHT ATTENDANT FLASHLIGHT BRACKET. PER AMM 25-64-00SDR AALA202510135889Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER ATTACH ANGLE LOCATED AT BS 663.5, RBL 33. REPAIRED PER SRM 57-10-10-2R-5.SDR AALA202510202939Sliding Window · inoperativeAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND NUMBER 2 WINDOW EMERGENCY (EXTERNAL) HANDLES DOES NOT UNLOCK AND OPEN WHEN THE EXTERNAL RELEASE HANDLE IS PULLED. REMOVED AND REPLACED EXTERNAL EMERGENCY HANDLE. PER AMM 56-12-11. OPERATIONAL CHECK GOOD.SDR AALA202510134744Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: BOTH LEFT HAND EMERGENCY FLASH LIGHT INOPERATIVE. REMOVED AND REPLACED BOTH LEFT HAND EMERGENCY FLASHLIGHT BATTERY (AALA202510134744) (AALA202510133699) . PER AMM 25-64-00.SDR AALA202510133699Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: BOTH LEFT HAND EMERGENCY FLASH LIGHT INOPERATIVE. REMOVED AND REPLACED BOTH LEFT HAND EMERGENCY FLASHLIGHT BATTERY (AALA202510134744) (AALA202510133699) . PER AMM 25-64-00.SDR AALA202510131554Door · not openedAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR HARD TO OPEN. FOUND DOOR RUBBING ON METAL THRESHOLD PLATE, ADJUSTED THE LAVATORY-A DOOR THRESHOLD. PER AMM 25-40-00.SDR AALA202510133769Girt Bar · unsecureAIRCRAFT WAS NOT GROUNDED: R4 DOOR HAS PIECE OF GREY MATERIAL STICKING OUT BY GIRT BAR. RESECURED GIRT BAR. PER AMM 25-66-01.SDR AALA202510142819Floorbeam · brokenAIRCRAFT IN BASE MAINTENANCE: BROKEN PASSENGER CABIN FLOOR SUPPORT BREAK ASSEMBLY PANEL LOCATED ON LEFT HAND SIDE AT BS 540. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-1.SDR AALA202510145138Floorbeam · brokenAIRCRAFT IN BASE MAINTENANCE: BROKEN PASSENGER CABIN FLOOR SUPPORT BREAK ASSEMBLY PANEL LOCATED ON RIGHT HAND SIDE AT BS 540. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-1.SDR AALA202510134078Lavatory · dirtyAIRCRAFT WAS NOT GROUNDED: SHORTLY AFTER TAKEOFF FLIGHT ATTENDANTS NOTICED A STRONG SMELL IN THE GALLEY, UPON FURTHER INSPECTION WE NOTICED FLUID COMING FROM THE LAVATORY WALL AND ACROSS THE ENTRY WAY TOWARDS THE CLOSET, IT SMELLED LIKE WASTE AND URINE. FOUNDSDR AALA202510136628Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER ATTACH ANGLE LOCATED AT BS 663, LBL 9. REPAIRED ANGLE PER SRM 57-10-10-2R-5.SDR AALA202510133528Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CARCK IN PASSENGER CABIN FLOORBEAM ASSEMBLY PANEL LOCATED AT BS 540, LBL 2. REPLACED FLOORBEAM ASSEMBLY IAW AARD 51-00-05-1.SDR AALA202510132791Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CARCK IN PASSENGER CABIN FLOORBEAM ASSEMBLY PANEL LOCATED AT BS 540, RBL 2. REPLACED FLOORBEAM ASSEMBLY PANEL PER AARD 51-00-05-1.SDR AALA202510137321Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER SECTION REAR SPAR VAPOR BARRIER ATTACH ANGLE LOCATED AT BS 663, LBL 10. REPLACED ANGLE PER SRM 57-10-10-2R-5.SDR AALA202510104078Lavatory · odorAIRCRAFT WAS NOT GROUNDED: SHORTLY AFTER TAKEOFF FLIGHT ATTENDANTS NOTICED A STRONG SMELL IN THE GALLEY, UPON FURTHER INSPECTION WE NOTICED FLUID COMING FROM THE LAVATORY WALL AND ACROSS THE ENTRY WAY TOWARDS THE CLOSET, IT SMELLED LIKE WASTE AND URINE. (OPENSDR AALA202510105188Girt Bar · lack of lubeAIRCRAFT WAS NOT GROUNDED: RIGHT FORWARD SERVICE DOOR DIFFICULT TO ARM AND DISARM, ALSO THE LATCH IS DIFFICULT TO OPERATE. CLEANED AND LUBED R1 GIRT BAR FITTINGS. PER AMM 25-66-02. OPERATIONAL CHECK GOOD.SDR AALA202510100315Sign · dislodgedAIRCRAFT WAS NOT GROUNDED: 14C EMERGENCY EXIT SIGN POPPED OUT ON ONE SIDE. REINSTALLED 14C SEAT EMERGENCY EXIT LIGHT ASSEMBLY.SDR AALA202510108655Toilet · leakingAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY TOILET LEAKS ON CLIMB AND DESCENT, SMELLS OF URINE. REMOVED AND REPLACED TOILET ASSEMBLY. PER AMM 38-32-01. LEAK CHECK GOOD AND OPERATIONAL CHECK GOOD.SDR AALA202510101087Girt Bar · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT SERVICE DOOR GIRT BAR DIFFICULT TO INSTALL IN POSITION. LUBED GIRT BAR, OPERATIONAL CHECK GOOD.
Back to Boeing 737-823