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 AALA202502256247Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 184.70, 17 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202502257234Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 184.70 9, INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202502170750Post · damagedAIRCRAFT IN BASE MAINTENANCE: FLIGHT ATTANDENTS REPORTS AFT LEFT LAVATORY-D DOOR IS HARD TO OPEN AND CLOSE. REMOVED AND REPLACED LAVATORY-D AFT DOOR POST. PER B737-NG SRM 51-40-02.SDR AALA202501304054Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD CABIN DOOR WAS EXTREMELY DIFFICULT TO OPEN. ADJUSTED L1 DOOR, OPERTIONAL CHECK GOOD. PER MM 52-11-00.SDR AALA202501309860Check Valve · faultyAIRCRAFT WAS GROUNDED: RIGHT MAIN FUEL TANK INCREASED FUEL BY 400-500 LBS DURING FLIGHT WITH NO CHANGE IN FUEL PANEL CONFIGURATION, EACH ENGINE WAS CONFIGURED TO BURN FROM EACH TANK SEPARATELY. ON DECENT, FUEL QUANTITY ON NUMBER 2 MAIN TANK WAS INCREASING, NO SDR AALA202501304927Bypass Valve · faultyAIRCRAFT WAS GROUNDED: RIGHT MAIN FUEL TANK INCREASED FUEL BY 400-500 LBS DURING FLIGHT WITH NO CHANGE IN FUEL PANEL CONFIGURATION, EACH ENGINE WAS CONFIGURED TO BURN FROM EACH TANK SEPARATELY. ON DECENT, FUEL QUANTITY ON NUMBER 2 MAIN TANK WAS INCREASING, NO SDR AALA202501304517Check Valve · faultyAIRCRAFT WAS GROUNDED: RIGHT MAIN FUEL TANK INCREASED FUEL BY 400-500 LBS DURING FLIGHT WITH NO CHANGE IN FUEL PANEL CONFIGURATION, EACH ENGINE WAS CONFIGURED TO BURN FROM EACH TANK SEPARATELY. ON DECENT, FUEL QUANTITY ON NUMBER 2 MAIN TANK WAS INCREASING, NO SDR AALA202501294054Door · bindingAIRCRAFT WAS NOT GROUNDED: FORWARD CABIN DOOR WAS EXTREMELY DIFFICULT TO OPEN. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202501290750Door · bindingAIRCRAFT IN BASE MAINTENANCE: FLIGHT ATTANDENTS REPORTS AFT LEFT LAVATORY-D DOOR IS HARD TO OPEN AND CLOSE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202501299860Fuel Sys · malfunctionedAIRCRAFT WAS GROUNDED: RIGHT MAIN FUEL TANK INCREASED FUEL BY 400-500 LBS DURING FLIGHT WITH NO CHANGE IN FUEL PANEL CONFIGURATION, EACH ENGINE WAS CONFIGURED TO BURN FROM EACH TANK SEPARATELY. ON DECENT, FUEL QUANTITY ON NUMBER 2 MAIN TANK WAS INCREASING, NO SDR AALA202501295799Skin · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT SIDE OF FUSELAGE SKIN AT AFT LAVATORY SERVICE PANEL FROM STA 847 TO STA 867, FROM S24L TO S25L. ACCOMPLISHED REPAIR PER SRM 51-40-05 AND EA 361206.SDR AALA202502219074Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN STA 500B PLUS 12 INCHES AND STA 5001 AT LBL 24. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202502144728Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR BEAM UPPER CHORD AROUND FASTENER HOLE AT STA 986.5, LBL 43. REPAIRED CHORD PER SRM 53-70-51-2R-6 ALTERNATIVE 4.SDR AALA202502143517Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND AFT ENTRY DOOR LOWER SILL CHORD (CREASE ANGLE) LOCATED AT BS 950, S17R, RBL 53. REPLACED CHORD PER AARD 51-00-05-1.SDR AALA202502149234Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR BEAM UPPER CHORD FLANGE AT STA 947, FROM RBL 24 TO RBL 26. REPAIRED CHORD PER SRM 53-70-51-2R-5.SDR AALA202502042180Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM BS 500D TO BS 500I AT S24R, RBL 24. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202502035913Angle · crackedAIRCRAFT IN BASE MAINTENANCE: UPON REMOVAL OF RIGHT HAND WING AFT WEB FOUND ANGLE TO BE CRACKED. REMOVED AND INSTALLED NEW RIGHT HAND WING AFT WEB ANGLE. PER B737-NG SRM 51-40-02.SDR AALA202501294304Web · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER WEB AT STAB STA 180.2. REPAIRED PER 55-10-01-2R 11.SDR AALA202501292758Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER RIB LOCATED AT STABILIZER STA 152. REPAIRED PER SRM 55-10-01-2R-11.SDR AALA202501290321Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER RIB LOCATED AT STABILIZER STA 193.90. REPAIRED PER SRM 55-10-01-2R-11.SDR AALA202501280159Door Sill · unsecureAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATROY DOOR IS STICKING AND IS DIFFICULT TO OPEN. SECURED AFT LEFT LAVATORY DOOR SILL, DOOR OPERTIONAL CHECK GOOD. PER 25-00-00.SDR AALA202501289142Light · detachedAIRCRAFT WAS NOT GROUNDED: 30C ESCAPE LIGHT DETACHED. REATTACHED SEAT 30C ESCAPE LIGHT, OPERTIONAL CHECK GOOD. PER CMM 25-23-67.SDR AALA202501280773Flashlight · no testAIRCRAFT WAS NOT GROUNDED: L4 DOOR AND R4 AISLE EMERGENCY FLASHLIGHTS INOPERATIVE. REMOVE AND REPLACED L4 (AALA202501280773) DOOR AND R4 AISLE (AALA202501288088) FLASHLIGHT. PER 25-64-00.SDR AALA202501288088Flashlight · no testAIRCRAFT WAS NOT GROUNDED: L4 DOOR AND R4 AISLE EMERGENCY FLASHLIGHTS INOPERATIVE. REMOVE AND REPLACED L4 (AALA202501280773) DOOR AND R4 AISLE (AALA202501288088) FLASHLIGHT. PER 25-64-00.SDR AALA202501309832Tube · leakingAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AT FL390, N1 AROUND 89%. REVERSE VIDEO INDICATION APPEARED ON L OIL QUANTITY. AFTER ABOUT 5 MIN, THE L OIL PRESSURE BEGAN FLUCTUATING +/- 7PSI. ENGINE NUMBER 1 UPPER DISPLAY BRIEFLY DISPLAYED FLASHING AMSDR AALA202501279832Oil System · fluctuatesAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AT FL390, N1 AROUND 89%. REVERSE VIDEO INDICATION APPEARED ON L OIL QUANTITY. AFTER ABOUT 5 MIN, THE L OIL PRESSURE BEGAN FLUCTUATING +/- 7PSI. ENGINE NUMBER 1 UPPER DISPLAY BRIEFLY DISPLAYED FLASHING AMSDR AALA202501275284Autopilot Sys · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: ON CLIMB OUT TRIED TO ENGAGE AUTO PILOT A AND IT WOULD NOT ENGAGE. SWITCHED TO CHANNEL B WITH THE SAME RESULT; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT ORD. TROUBLESHOT SYSTEM. NO FAULTS NOTSDR AALA202501274092Sign · dislodgedAIRCRAFT WAS NOT GROUNDED: AFTER TAKEOFF, OVER WING EMERGENCY EXIT SIGN CAME OFF. RESECURED ISLE OVERHEAD EXIT SIGN. PER AMM 33-52-01.SDR AALA202501273286Tube · missingAIRCRAFT WAS NOT GROUNDED: L1 ENTRY DOOR GIRT BAR MISSING RED COVERING ON LEFT SIDE. REPLACED L1 DOOR GIRT BAR RED HEATSHRINK. PER AMM 25-66-01SDR AALA202501286800Light · crackedAIRCRAFT IN BASE MAINTENANCE: 2EA BOTTOM EMERGENCY LIGHTS IS CRACKED LOCATED AT G7. REMOVE AND REPLACED 2EA (AALA202501286800), (AALA202501289075) FLOOR PROXIMITY EMERGENCY LIGHT ASSEMBLY. OPERTIONAL CHECK GOOD. PER AMM 33-51-14-960-802.SDR AALA202501289075Light · crackedAIRCRAFT IN BASE MAINTENANCE: 2EA BOTTOM EMERGENCY LIGHTS IS CRACKED LOCATED AT G7. REMOVE AND REPLACED 2EA (AALA202501286800), (AALA202501289075) FLOOR PROXIMITY EMERGENCY LIGHT ASSEMBLY. OPERTIONAL CHECK GOOD. PER AMM 33-51-14-960-802.SDR AALA202501270231Anti-Ice Valve · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING CLIMB ENGINE 2 COWL ANTI-ICE LIGHT ILLUMINATED; AIRCRAFT DIVERTED TO AND LANDED SAFELY AT ORD. REMOVED AND REPLACED NUMBER 2 ENGINE COWL ANTI-ICE VALVE. OPERTIONAL CEHCK GOOD. PER AMM 30-21-11.SDR AALA202501274076Door Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR LATCH LOCK HARD TO SLIDE. LUBED LEFT AFT LAVATORY DOOR LATCH LOCK MECANISM. PER CMM 25-40-64.SDR AALA202501277974Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: L2 EXTERIOR EMERGENCY EXIT SLIDE LIGHT IS INOPERATIVE. RELAMPED L2 EXTERIOR EMERGENCY EXIT SLIDE LIGHT. OPERTIONAL CHECK GOOD. PER MM 33-51-04.SDR AALA202501274837Door Latch · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR IS DIFFICULT TO OPEN AND CLOSE. ADJUSTED DOOR LATCH. PER AMM 25-40-00.SDR AALA202501283437Elec Connector · looseAIRCRAFT IN BASE MAINTENANCE: EXTERIOR EMERGENCY LIGHT AFT OF L1 DOOR INOPERATIVE FOUND CONNECTOR 11074 LOOSE, RECONNECTED LOOSE CONNECTOR, OPERTIONAL CEHCK GOOD. PER B737-NG WDM 33-51-12.SDR AALA202501274446Unknown · odorAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING CLIMB WE HAD A VERY STRONG BURNING SMELL. PLASTIC OR ELECTRICAL; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT MIA. ACCOMPLISHED W/C 08L00021001 AND NO ODOR FOUND, NO FAULT FOUND.SDR AALA202501270706Sign · missingAIRCRAFT WAS NOT GROUNDED: LOWER EXIT SIGN AT 17A MISSING. REINSTALLED EXIT SIGN AT 17A AND OPERTIONAL CHECK GOOD. PER AMM 33-51-00.SDR AALA202501274396Light · missingAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT AT 19ABC BROKEN AND MISSING. INSTALLED FLOOR PROXIMITY LIGHT ASSEMBLY AT ROW 19ABC, OPERTIONAL CHECK GOOD. PER AMM 33-51-11.SDR AALA202501279022Lock · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY-D BI-FOLD DOOR DIFFICULT TO OPERATE; EXCESSIVE FORCE REQUIRED. READJUSTED LOWER DOOR LOCK, OPERTIONAL CHECK GOOD. PER CMM 25-40-64.SDR AALA202502078064Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FLOORBOARD SUPPORT AT BS 540, LBL 2. REPLACED FLOORBOARD SUPPORT PER AARD 51-00-05-1.SDR AALA202502061779Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL BETWEEN STA 380 AND STA 400 AT BL 0. REPLACED INTERCOSTAL PER AARD 5100-05-1.SDR AALA202502067291Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM STA 380 TO STA 400 AT LBL 14. REPLACED INTERCOSTAL PER AARD 5100-05-1.SDR AALA202501275584Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM STA 500I TO STA 520 AT BL 0. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202501240837Door · misrepairedAIRCRAFT WAS NOT GROUNDED: AFTER LEFT LAVATORY DOOR IS DIFFICULT TO OPEN AND CLOSE, AND LOCK IS DIFFICULT TO ENGAGE FROM THE INSIDE. REPAIRED LAVATORY-D DOOR. PER AARD 25-40-10 REPAIR 10. OPERTIONAL CHECK GOOD.SDR AALA202501242913Door · out of adjustAIRCRAFT WAS NOT GROUNDED: AFT LAVATORY-D DOOR HARD TO OPERATE. ADJUSTED LAVATORY-D DOOR MECHANISM. OPERTIONAL CHECK GOOD. PER AMM 25-40-14.SDR AALA202501246043Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT BAFFLE CLIP AT STA 460, LBL 25. REPLACED BAFFLE CLIP PER AARD 51-00-05-1.SDR AALA202501247858Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT BAFFLE CLIP AT STA 440, LBL 25. REPLACED BAFFLE CLIP PER AARD 51-00-05-1.SDR AALA202502053668Wedge · delaminatedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND WING INBOARD FLAP TRAILING EDGE WEDGE LOWER SURFACE IS DELAMINATED. REMOVED AND INSTALLED NEW WEDGE ASSEMBLY ON LEFT HAND WING INBOARD FLAP. PER B737-NG SRM 51-40-02-0G.SDR AALA202501278798Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT STA 295, RBL 3. REPLACED INTERCOSTAL PER AARD 51-00-05-1.
Back to Boeing 737-823