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 AALA202407158448Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FIRST CLASS LAVATORY DOOR STICKS WHEN OPENING AND CLOSING. ADJUSTED FIRST CLASS LAVATORY DOOR. PER AMM 25-40-00.SDR AALA202407153843Battery Pack · inoperativeAIRCRAFT WAS GROUNDED: AFT RIGHT HAND FLIGHT ATTENDANT SEAT HAS A FLASH LIGHT INOPERATIVE. REPLACED AFT RIGHT HAND FLIGHT ATTENDANT FLASHLIGHT BATTERY. OPERTIONAL CHECK GOOD. PER AMM 25-64-00.SDR AALA202407157691Bulb · inoperativeAIRCRAFT WAS GROUNDED: L1 EMERGENCY LIGHT ASSEMBLY 1 BULB NEEDS TO BE REPLACED. REMOVED AND REPLACED L1 EMERGENCY LIGHT ASSEMBLY 1 BULB. OPERTIONAL CHECK GOOD. PER AMM 33-51-00.SDR AALA202407159894Light · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT DIRECTION LIGHT ON SEAT 11C HAS FALLEN OFF. RESECURED LIGHT AT 11C AS REQUIRE.SDR AALA202407158195Slide · unpackedAIRCRAFT WAS NOT GROUNDED: FORWARD CABIN ENTRY DEPLOYABLE SLIDE IS PROTRUDING THROUGH THE SEAL. REPACKED FORWARD SLIDE COVER UNDER BESSEL AT L1 DOOR. PER AMM 25-66-00-840-801.SDR AALA202407151771Slide · dislodgedAIRCRAFT WAS NOT GROUNDED: L1 DOOR SLIDE PROTRUDING OUT OF CONTAINER ON LOWER LEFT SIDE. UNABLE TO OPEN L1 DOOR TO DEPLANE. REMOVED SLIDE PACK COVER AND REINSTALLED. PER AMM 25-66-01-000-801.SDR AALA202407156533Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FIRST CLASS LAVATORY DOOR STICKS. HARD TO OPEN AND CLOSE. ADJUSTED BOTTOM OF DOOR PER STANDARD PRACTICES.SDR AALA202407194106Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT BS 320, LBL 45. REPLACED INTERCOSTAL PER AARD 51-00-05-01.SDR AALA202407158336Sign · missingAIRCRAFT WAS NOT GROUNDED: GALLEY SERVICE DOOR EMERGENCY SIGN EXIT PLASTIC COVER MISSING. REMOVE AND REPLACED GALLEY EXIT LIGHT ASSEMBLY. OPERTIONAL CHECK GOOD. PER AMM 33-51-01-960-802.SDR AALA202407157642Switch · inoperativeAIRCRAFT WAS GROUNDED: FLIGHT CREW REPORTS EMERGENCY LIGHTS ILLUMINATE WHEN AIRCRAFT ON GROUND SERVICE BUSS. FOUND EMERGENCY TOGGLE SWITCH OVERHEAD PANEL NEEDS REPLACEMENT. REMOVED AND REPLACED P5 EMERGENCY TOGGLE SWITCH, PER SWPM 20-83-11. ALSO PERFORMED EMERSDR AALA202407151211Girt Bar · frayedAIRCRAFT IN BASE MAINTENANCE: GIRT FRAYED ON R1 DOOR SLIDE. INSTALLED SERVICEABLE SLIDE. PER CARD 08L22125001.SDR AALA202407159654Pin · dislodgedAIRCRAFT WAS NOT GROUNDED: AFT AFT LEFT SERVICE DOOR HAS A PIN STICKING DOWN FROM THE DOOR ON THE INSIDE FROM THE GIRT BAR. REMOVED SLIDE, REINSTALLED SAFTY PIN AND REINSTALLED SLIDE. PER AMM 25-66-01.SDR AALA202407150687Door Latch · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DIFFICULT TO OPEN AND CLOSE. READJUSTED LAVATORY-A DOOR LATCH. OPERTIONAL CHECK GOOD. PER CMM 26-46-96.SDR AALA202407159408Connector · disconnectedAIRCRAFT WAS NOT GROUNDED: CABIN EMERGENCY AISLE LIGHTS INOPERATIVE ON SEATS 32ABC AND 33ABC. RECONNECTED LOOSE CONNECTION ON ROW 32, PER WDM 33-51-22 AND PER SSM 33-51-21, PERFORMED OPERATIONAL TEST AND PASSED. PER AMM 33-51-00.SDR AALA202408046428Floor Support · brokenAIRCRAFT IN BASE MAINTENANCE: PASSENGER CABIN INTERCOSTAL FROM STA 328 TO STA 344, LBL 45, BROKEN. REPLACED INTERCOSTAL PER AARD 51-00-05 01.SDR AALA202408044860Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON R2 DOOR SILL INNER CHORD (CREASE ANGLE) FROM STA 967 TO STA 986.5, RBL 54. REPLACED CHORD PER AARD 51-00-05 .SDR AALA202407168528None · noneAIRCRAFT WAS GROUNDED: AT FL280 DURING THE INITIAL DESCENT, THE AIRCRAFT VIOLENTLY BANKED 30 DEGREES TO THE RIGHT WITH AN ANNUNCIATION ON THE PFD "ROLL AUTHORITY" WITH THE VERBAL AURAL. AUTOPILOT WAS DISENGAGED AND MAINTAINED CONTROLLED OF THE AIRCRAFT. BOEINSDR AALA202407157468Arm · crackedAIRCRAFT WAS GROUNDED: WHILE TRYING TO CLOSE L1 DOOR FOUND GUST LOCK STUCK. AFTER FURTHER INVESTIGATION FOUND DOOR ATTACH ARM THE GUST LOCK IS ON IS CRACKED. REMOVED AND REPLACED GUIDE ARM ASSEMBLY, PER AMM 52-11-21. NO FURTHER DEFECTS.SDR AALA202407156044Control Valve · faultedAIRCRAFT WAS GROUNDED: LOUD SQUEALING IN BRAKES AT LOW SPEEDS. VIBRATIONS FELT IN BRAKEPEDALS AND SEEMS LIKE MAYBE A STUCK PAD OR BRAKE. FLIGHT ATTANDENT ALSO REPROTED LOUD GRINDING SOUND FROM BACK OF PLANE AND SOUNDS LIKE A FREIGHT TRAIN. TROUBLESHOOT AND FOUSDR AALA202407151811Sign · looseAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT UNDER 23C CAME LOOSE. REMOVE AND REPLACED 23C EMERGENCY EXIT LIGHT, OPERTIONAL CHECK GOOD. PER CMM 25-23-67.SDR AALA202407152949Sensor · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING GO AROUND, FLAPS WOULD NOT RETRACT PAST 5; AIRCRAFT LANDED SAFELY AT TPA. ACCOMPLISHED FSEU BITE, PER FIM 27-51-00-810-801. FLAP 6 SKEW LATCHED. REMOVED AND REPLACED NUMBER 6 FLAP SKEW SENSOR. OPESDR AALA202407249573Pump · low pressureAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING CRUISE SYSTEMA ENGINE NUMBER 1 HYDRAULIC PUMP LOW PRESSURE LIGHT ILLUMINATED ALONG WITH MASTER CAUTION, THEN LOST ALL HYDRAULIC PRESSURE; AIRCRAFT DIVERTED AND LANDED SAFELY AT DFW.**SUPPLEMENTAL SDR AALA202407123962Sliding Window · off trackAIRCRAFT WAS NOT GROUNDED: CLEANERS OPENED CAPTS SLIDING WINDOW AND WINDOW FELL OFF THE TRACKS. RESECURED CAPTAINS WINDOW. OPERTIONAL CHECK GOOD. PER AMM 56-12-11SDR AALA202407123095Megaphone · expiredAIRCRAFT WAS NOT GROUNDED: FORWARD MEGAPHONE DUE FOR MX. REMOVE AND REPLACED MEGAPHONE. PER AMM 25-64-00.SDR AALA202407123198Megaphone · expiredAIRCRAFT WAS NOT GROUNDED: AFT MEGAPHONE DUE FOR MX. REMOVE AND REPLACED MEGAPHONE. PER AMM 25-64-00.SDR AALA202407129573Pump · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING CRUISE SYSTEMA ENGINE NUMBER 1 HYDRAULIC PUMP LOW PRESSURE LIGHT ILLUMINATED ALONG WITH MASTER CAUTION, THEN LOST ALL HYDRAULIC PRESSURE; AIRCRAFT DIVERTED AND LANDED SAFELY AT DFW.**SUPPLEMENTAL SDR AALA202407128118Door Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR IS EXTREMELY HARD TO OPEN. LUBRICATED DOOR LATCH ASSEMBLY. DOOR OPERTIONAL CHECKS NORMAL. PER AMM 52-51-00.SDR AALA202407120235Light · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT AT SEAT 32C IS DETACHED. SECURED EMERGENCY LIGHT AT ROW 32C. OPERTIONAL CHECKS GOOD.SDR AALA202409051502Tire · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: HIGH SPEED REJECT AFTER 80 KNOTS JUST PRIOR TO V1 ABOUT 150 KNOTS DUE TO BLOWN TIRES RIGHT MLG. AFTER REJECTING ARFF CONFIRMED FLAMES ON THE RIGHT MLG. BOTH LEFT MLG LOST PRESSURE AFTER AIRCRAFT STOPPED;SDR AALA202407246413Bolt · looseAIRCRAFT WAS GROUNDED: RIGHT MAIN TANK FUEL INDICATOR FLUCTUATED 1300 LBS AFTER LEVEL OFF AT FL350, DISPLAYING A FUEL IMBALANCE YELLOW WARNING ON THE RIGHT MAIN TANK FUEL INDICATOR.**SUPPLEMENTAL REPORT FOR (AALA202407116413): REF WORK ORDER #TT00150; FOUND MUSDR AALA202407117351Light · looseAIRCRAFT WAS NOT GROUNDED: SEAT 30C; EMERGENCY LIGHT IS HANGING LOOSE FROM SIDE OF SEAT. REINSTALLED 30C EMERGENCY LIGHT. OPERTIONAL CHECK GOOD. PER AMM 33-51-11.SDR AALA202407110158Light · inoperativeAIRCRAFT WAS NOT GROUNDED: OVERWING EMERGENCY EXIT DOOR AT 16ABC INOPERATIVE. REMOVED AND REPLACED OVERWING EXIT DOOR LIGHT AT 16ABC. OPERTIONAL CHECK GOOD. PER AMM 33-51-04.SDR AALA202407115051Locking Cam · out of adjustAIRCRAFT WAS NOT GROUNDED: DOOR 1L SLIDE ARMING BAR IS DIFFICULT TO REMOVE FROM ARMED POSITION. ADJUSTED GIRT BAR HOOK. OPERTIONAL CHECK GOOD. PER AMM 25-66-01.SDR AALA202407110545Sign · missingAIRCRAFT WAS NOT GROUNDED: EXIT SIGN BY OVERWING EXIT AT SEAT 17F MISSING. REPLACED MISSING EMERGENCY EXIT SIGN AT SEAT 17F AS REQUIRED.SDR AALA202407116413Indicator · unknownAIRCRAFT WAS GROUNDED: RIGHT MAIN TANK FUEL INDICATOR FLUCTUATED 1300 LBS AFTER LEVEL OFF AT FL350, DISPLAYING A FUEL IMBALANCE YELLOW WARNING ON THE RIGHT MAIN TANK FUEL INDICATOR.SDR AALA202407111502Tire · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: HIGH SPEED REJECT AFTER 80 KNOTS JUST PRIOR TO V1 ABOUT 150 KNOTS DUE TO BLOWN TIRES RIGHT MLG. AFTER REJECTING ARFF CONFIRMED FLAMES ON THE RIGHT MLG. BOTH LEFT MLG LOST PRESSURE AFTER AIRCRAFT STOPPED;SDR AALA202407101581Fitting · 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. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202407105247Fitting · 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-737-57-1309.SDR AALA202407108769Fitting · 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. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202407109303Fitting · 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. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202407101154Fitting · 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-737-57-1309.SDR AALA202407108832Fitting · 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. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202407108515Fitting · 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-737-57-1309.SDR AALA202407109762Fitting · 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. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202407100091Fitting · 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-737-57-1309.SDR AALA202407109501Fitting · 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-737-57-1309.SDR AALA202407103853Track · looseAIRCRAFT WAS NOT GROUNDED: AFTER PARKING THE AIRCRAFT THE FIRST OFFICER OPENED HIS SLIDING WINDOW AND THE WINDOW CAME OFF THE TRACKS AND IS LOOSE IN THE COCKPIT. REINSTALLED WINDOW IN TRACKS, OPERTIONAL CHECKS NORMAL. PER AMM 56-12-11.SDR AALA202407102395Track · lack of lubeAIRCRAFT WAS NOT GROUNDED: LAVATORY-D ENTRY DOOR DIFFICULT TO OPEN AND CLOSE. LUBED LAVATORY-D TRACKS. OPERTIONAL CHECK GOOD. PER CMM 25-40-58.SDR AALA202407105503Door Frame · looseAIRCRAFT WAS NOT GROUNDED: LAVATORY-E DOOR IS DIFFICULT TO OPEN. TIGHTENED LAVATOR-E DOOR JAMB AS REQUIRED. OPERTIONAL CHECK GOOD.SDR AALA202407101306Hinge · out of adjustAIRCRAFT WAS GROUNDED: LAVATORY-D DOOR STICKS DIFFICULT TO OPEN. LUBED AND ADJUSTED LAVATORY-D DOOR HINGE. OPERTIONAL CHECK GOOD. PER AMM 25-40-14.
Back to Boeing 737-823