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 AALA202402141340Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM BS 500F TO BS 500G, S25R. BLENDED CORROSION PER AMM 51-00-53-201.SDR AALA202402128933Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY D DIFFICULT TO OPEN FROM INSIDE. PASSENGER COULD NOT GET OUT OF LAVATORY AND HAD TO HAVE FLIGHT ATTENDANT OPEN DOOR FROM OUTSIDETO GET DOOR OPEN. : ADJUSTED DOOR PER CMM 25-40-58.**(CLOSED).SDR AALA202402096005Door Frame · damagedAIRCRAFT IN BASE MAINTENANCE: FORWARD RIGHT HAND EMERGENCY EXIT FRAME HAS LOOSE NUTS ARROUND TRIM STRIP. SECURED FORWARD RIGHT HAND EMERGENCY EXIT TRIM STRIP NUTS. PER B737 NG AMM 52-22-51.SDR AALA202402079151Web · damagedAIRCRAFT IN BASE MAINTENANCE: EXISTING REPAIR TO CUSP WEB FROM BS 400 TO BS 420, RBL 64. INSTALLED DOUBLER REPAIR PER SRM 51-70-13-2R-1 REPAIR 1.SDR AALA202402079887Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR WEB FROM BS 1016 TO BS 1036, RBL 33. REPLACED WEB PER SRM 51-40-02-0G.SDR AALA202402068962Fuel Filter · inoperativeAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS NOT DECLARED DUE TO: ENGINE 1 FUEL FLITER BYPASS. ERRATIC AND ILLUMINATED WITH TAKE OFF AND CLIMB POWER, ON CENTER TANK AND MAIN WING PUMPS. AIRCRAFT RETURN AND LANDED SAFELY AT MSP WITHOUT FURTHER INCIDENT. REMOVE AND RSDR AALA202402068939Switch · inoperativeAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS NOT DECLARED DUE TO: ENGINE 1 FUEL FLITER BYPASS. ERRATIC AND ILLUMINATED WITH TAKE OFF AND CLIMB POWER, ON CENTER TANK AND MAIN WING PUMPS. AIRCRAFT RETURN AND LANDED SAFELY AT MSP WITHOUT FURTHER INCIDENT. REMOVE AND RSDR AALA202402068933Door · bindingAIRCRAFT WAS NOT GROUNDED: LAVATORY D DIFFICULT TO OPEN FROM INSIDE. PASSENGER COULD NOT GET OUT OF LAVATORY AND HAD TO HAVE FLIGHT ATTENDANT OPEN DOOR FROM OUTSIDETO GET DOOR OPEN. (OPEN).SDR AALA202402062084Unknown · vibrationAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: LOUD VIBRATING NOISE SIMILAR TO VIBRATING FAN HEARD FROM NOSE CLIMBING THROUGH 20000 FEET. SOUND CHANGED WITH CHANGES IN AIRSPEED. AIRCRAFT RETURN AND LANDED SAFELY AT MIA WITHOUT FURTHER INCIDENT. FOUNDSDR AALA202402066618Fuse · failedAIRCRAFT IN BASE MAINTAINCE: L2 DOOR ESCAPE SLIDE EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACK FUSE. PER AMM 33-51-06.SDR AALA202402067002Slide · wornAIRCRAFT IN BASE MAINTIANCE: BOTTOM OF GIRT IS WORN ON R1 SLIDE, GALLEY SERVICE DOOR. INSTALLED SLIDE ASSEMBLY. PER AMM 25-66-01.SDR AALA202402078714Snubber · inoperativeAIRCRAFT WAS NOT GROUNDED: R-1 GALLEY ENTRY DOOR SNUBBER INOPERATIVE. REMOVED AND REPLACED R1 SNUBBER (AALA202402078714) PER AMM 52-41-5 AND REMOVED AND REPLACED R1 UPPER ARM (AALA202402071577) PER AMM 52-41-21.SDR AALA202402071577Arm · inoperativeAIRCRAFT WAS NOT GROUNDED: R-1 GALLEY ENTRY DOOR SNUBBER INOPERATIVE. REMOVED AND REPLACED R1 SNUBBER (AALA202402078714) PER AMM 52-41-5 AND REMOVED AND REPLACED R1 UPPER ARM (AALA202402071577) PER AMM 52-41-21.SDR AALA202402052865Channel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN DOOR CUTOUT Z CHANNEL FROM BS 947 TO BS 987, RBL 60. REPLACED Z CHANNEL PER SRM 51-40-02-0G.SDR AALA202402059914Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON CUSP WEB FROM BS 400 TO BS 420, S17R. REMOVED, FABRICATED, AND INSTALLED CUSP WEB SRM 51-40-02-0G.SDR AALA202402053423Battery Pack · no testAIRCRAFT WAS NOT GROUNDED: FLASH LIGHT MOUNTED UNDER AFT FLIGHT ATTENDANT SEAT CONTINUOUSLY ON WHILE IN MOUNT. EMERGENCY FLASHLIGHT PUSH TO TEST FAILED. REPLACED BATTERY PACK, CORRECTLY INSTALLED FLASHLIGHT TO MOUNT BRACKET AND OPS TEST GOOD. PER AMM 25-64-00SDR AALA202402052401Pump · inoperativeAIRCRAFT WAS NOT GROUNDED: ON DESCENT WITH 3800 LBS OF FUEL IN TANK NUMBER 1 LOW PRESSURE AFT PUMP LIGHT ILLUMINATED. REMOVE AND REPLACED NUMBER 1 AFT FUEL PUMP, OPERTIOBNAL CHECK GOOD. PER AMM 28-22-41.SDR AALA202402069910Tube · damagedAIRCRAFT WAS NOT GROUNDED: WHILE ACCOMPLISHING WORK CARD 08C20025006 (DVI-EMERGENCY ESCAPE SLIDE AND PRESSURE BOTTLE, MAINTENANCE FOUND HEAT SHRINK TUBING ON ONE END OF GIRT BAR FOR THE L1 SLIDE DAMAGED AND COVERED WITH CLEAR MYLAR TAPE. MAINTENANCE REPLACED SDR AALA202402052705Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR DIFFICULT TO OPEN AND CLOSE. SEEMS TO BE CATCHING SOMEWHERE WHEN CLOSING AND HAVE TO SLAM IT SHUT REALLY HARD. LUBRICATED FLIGHT DECK DOOR.SDR AALA202402054717Slide · misalignedAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS GIRT BAR ON R1 DOOR DIFFICULT TO STOW WHEN DISARMED. REMOVED R1 DOOR SLIDE AND COVER ASSEMBLY, RESET SLIDE INSIDE COVER ASSEMBLY, REINSTALLED ASSEMBLY.SDR AALA202402055026Trim Panel · unsecureAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY D LATCH DIFFICULT TO OPEN/CLOSE. RESECURED LAVATORY D UPPER DOOR TRIM.SDR AALA202402051825Sliding Window · lack of lubeAIRCRAFT WAS GROUNDED: CAPTAIN SIDE WINDOW WAS HARD TO CLOSE AND LOCK ON THE GROUND AND ON TAKEOFF THERE WAS LOUD AIRFLOW NOISE. CLEANED AND LUBRICATED CAPTAIN SIDE SLIDING WINDOW.SDR AALA202402053725Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT UNDER FORWARD FLIGHT ATTENDANT JUMP SEAT NOT WORKING. REPLACED L1 DOOR FLIGHT ATTENDANT FLASHLIGHT.SDR AALA202402050644Door · obstructedAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR DOES NOT OPEN FULLY. REMOVED DEBRIS FROM LEFT AFT LAVATORY DOOR AND LUBRICATE TRACK.SDR AALA202402059146Fitting · 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.SDR AALA202402054215Fitting · 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.SDR AALA202402055356Fitting · 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.SDR AALA202402056558Fitting · 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.SDR AALA202402056335Fitting · 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.SDR AALA202402051040Fitting · 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.SDR AALA202402051024Fitting · 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.SDR AALA202402054302Fitting · 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.SDR AALA202402057717Fitting · 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.SDR AALA202402051883Fitting · 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.SDR AALA202402122869Fire Bottle · false indicationAIRCRAFT WAS NOT GROUNDED: APU FIRE BOTTLE DISCHARGED LIGHT ILLUMINATED AFTER TAKEOFF. MAINTENANCE REPLACED THE APU FIRE EXTINGUISHING BOTTLE PER AMM 26-22-01.** (CLOSED)SDR AALA202402070860Web · damagedAIRCRAFT IN BASE MAINTENANCE: UNSPECIFIED DAMAGE FOUND TO PASSENGER CABIN FLOOR WEB FROM BS 927 TO BS 947, RBL 54. REPLACED WEB PER AARD 51-00-05-1.SDR AALA202402067258Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER RIB, ON SECOND STIFFENER FROM FRONT SPAR, LOCATED AT STABILIZER STA 92.70, REPLACED RIB PER AARD 51-00-05-1.SDR AALA202402058222Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND WHEEL WELL VAPOR BARRIER CRACKED AT BS 663.75 AND LBL34. REPAIRED VAPOR BARRIER PER SRM 57-10-10-2R-2 AND AARD 57-10-10-9.SDR AALA202402052869Warning Light · illuminatedAIRCRAFT WAS NOT GROUNDED: APU FIRE BOTTLE DISCHARGED LIGHT ILLUMINATED AFTER TAKEOFF. **SUPPLEMENTAL REPORT WILL BE SUBMITTED** (OPEN)SDR AALA202402059948Trim Panel · looseAIRCRAFT WAS NOT GROUNDED: AFT RIGHT LAVATORY DOOR IS DIFFICULT TO OPEN AND CLOSE. RESECURED LAVATORY DOOR LOOSE TRIMSDR AALA202402038111Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND WHEEL WELL VAPOR BARRIER CRACKED 4 INCHES OUTBOARD OF PACK EXHAUST DUCT AT RBL 30. REPAIRED VAPOR BARRIER PER SRM 57-10-10-2R-2 AND AARD 57-10-10-9.SDR AALA202402211976Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 767 AND BS 787, LBL 25. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202402218431Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 747 AND BS 767, RBL 25. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202402210491Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 787 AND BS 807, LBL 25. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202402213953Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 747 AND BS 767, LBL 25. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202402150073Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 767 AND BS 787, RBL 25. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202402071770Door · bindingAIRCRAFT WAS NOT GROUNDED: AFT LAVATORY D DOOR DIFFICULT TO OPEN OR CLOSE. **SUPPLEMENTAL REPORT FOR AALA202402051770: MAINTENANCE REPLACED THE LAVATORY D DOOR PER CMM 25-40-64 AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK.** (CLOSED)SDR AALA202402070028Panel · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE BREAK ASSEMBLY PANEL AT BS 540, LBL 1. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-1.SDR AALA202402079218Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 312 TO BS 328, RBL 31. REPLACED INTERCOSTAL PER AARD 51-00-05-01.SDR AALA202402073743Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 344 TO BS 360, BL 0. REPLACED INTERCOSTAL PER AARD 51-00-05-01.
Back to Boeing 737-823