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 AALA202404305823Fitting · 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 AALA202405061874Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FLANGE OF FLOORBEAM UPPER CHORD AT STA 986, LBL 31. REPAIRED PER EA 354081.SDR AALA202405019542Light · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT HOUSING HANGING FROM 11C.: RE-SECURED LOOSE SCREWS ON EMERGENCY LIGHT HOUSING FROM SEAT 11C. PER STANDARD MX PRACTICES**(CLOSED).SDR AALA202404305859Sign · abnormalAIRCRAFT WAS GROUNDED: EMERGENCY EXIT LIGHT STROBING OVER EXIT AT SEAT 16F. RESET AND SECURED EMERGENCY EXIT SIGN LED LIGHT ASSEMBLY AT OVER WING EXIT SEAT 16F AND CHECK GOOD. PER AMM REF 33-51-00.SDR AALA202404300256Transmitter · leakingAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: HYDRAULICS SYSTEM A QUANTITY INDICATION ABNORMALLY LOW; AIRCRAFT DIVERTED TO AND LANDED SAFELY AT DFW.**SUPPLEMENTAL REPORT FOR (AALA202404300256): INSTALLED SERVICEABLE SYSTEM A HYDRAULIC TRANSMITTER, LSDR AALA202404309542Housing · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT HOUSING HANGING FROM 11C. (OPEN).SDR AALA202404300725Lock · out of adjustAIRCRAFT WAS NOT GROUNDED: AFT LAVATORY-D DOOR LOCK STICKING. CUSTOMERS GETTING TRAPPED INSIDE. ADJUSTED AFT LAVATORY-D DOOR LOCK. PER AMM 25-40-15.SDR AALA202404309267Sign · dislodgedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT SIGN FOUND ON THE FLOOR BY EXIT ROW. REATTACHED EMERGENCY EXIT SIGN COVER TO RIGHT HAND LOWER AFT OVERWING EMERGENCY EXIT LIGHT ASSEMBLY, VERIFIED SYSTEM WORKING PROPERLY. PER AMM33-51-00.SDR AALA202404308556Control Unit · faultyAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: ON CAT-3 APPROACH GOT AN APPROACH WARNING IN HUD AND ON HAP PANEL, UNABLE TO SELECT A HEADING ON FMA GOT A PWS FAIL ON BOTH NAV DISPLAY AFTER LEVEL OFF, CONFIGURATION HORN SOUND WITH NO LIGHTS TO INDICATSDR AALA202404302856Fitting · 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 AALA202404300275Fitting · 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 AALA202404307459Fitting · 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 AALA202404309502Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE BREAK ASSEMBLY PANEL AT STA 540 BETWEEN BL 0 AND RBL 24. REPLACED BREAK ASSEMBLY PANEL PER SRM 51-70-11-2R.SDR AALA202405017998Module · faultyAIRCRAFT WAS GROUNDED: REPEAT WRITE UP; WITH THE LANDING GEAR LEVER DOWN 3 GREEN AND 3 RED UNSAFE LIGHTS DISPLAYED. GEAR HANDLE HAS TO BE PUSHED IN INTO EXTINGUISH THE RED GEAR UNSAFE LIGHTS. REMOVED AND REPLACED LANDING GEAR LEVER MODULE. PER AMM 32-31-22.SDR AALA202404295900Battery Pack · no testAIRCRAFT WAS NOT GROUNDED: WHILE PERFORMING OPERATIONAL TEST EMERGENCY LIGHTS MCM CARD #08T20033001 FOUND THE FORWARD LEFT HAND POWER PACK TO BE INOPERATIVE. REMOVE AND REPLACED FORWARD LEFT HAND POWER PACK M1675 FOR THE EMERGENCY LIGHTS. PER MM 33-51-06-960-8SDR AALA202404290023Girt Bar · unsecureAIRCRAFT WAS NOT GROUNDED: FORWARD ENTERY DOOR GIRT BAR NEEDS REATTACHED. GIRT BAR RESEATED IN GIRT BAR RETAINING CLIPS. PER AMM 25-66-01.SDR AALA202404297942Megaphone · inoperativeAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDENT REPORTS THE MEGAPHONE FROM REAR OF AIRCRAFT INOPERATIVE. REPLACED MEGAPHONE WITH A NEW SERVICEABLE ONE. OPERTIONAL CHECKS GOOD. PER AMM 25-64-00.SDR AALA202404298947Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR DIFFICULT TO OPEN AND CLOSE. ADJUSTED THE FORWARD LAVATORY DOOR. PER CMM 25-44-49.SDR AALA202404293042Switch · lack of lubeAIRCRAFT WAS GROUNDED: WITH LANDING GEAR LEVER DOWN 3 GREEN DOWN AND LOCKED BUT ALSO 3 RED GEAR DISAGREE LIGHTS ON. PERFORMED PSEU BITE, PER FIM 32-61-00. INSPECTED LANDING GEAR CONTROL MODULE AND LUBRICATED SWITCHES. INDICATIONS ARE CORRECT, NO FAULT FOUND.SDR AALA202405175498Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: FORWARD CARGO LEFT HAND SIDE TRANSITION PANEL CORRODED. LOCATED AT BS 500D TO 500I AND BL 21L. REPLACED TRANSITION PANEL. PER AARD 51-00-05-1 AND BOEING DRAWING 143.SDR AALA202405132357Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL AT STA 496, RBL 27. REPLACED TRANSITION PANEL PER AARD 51-00-05.SDR AALA202405065353Door · faultyAIRCRAFT WAS NOT GROUNDED: AFT LAVATORY-D DOOR STUCK IN CLOSED POSITION. **SUPPLEMENTAL REPORT FOR AALA202404297451: REPLACED DOOR TRIM (AALA202404297451), DOOR RAIL (AALA202405066717) AND DOOR FRAME TRIM (AALA202405065353) PER CMM 25-40-64.**(CLOSED)SDR AALA202405066717Rail · faultyAIRCRAFT WAS NOT GROUNDED: AFT LAVATORY-D DOOR STUCK IN CLOSED POSITION. **SUPPLEMENTAL REPORT FOR AALA202404297451: REPLACED DOOR TRIM (AALA202404297451), DOOR RAIL (AALA202405066717) AND DOOR FRAME TRIM (AALA202405065353) PER CMM 25-40-64.**(CLOSED)SDR AALA202405067451Door · stuckAIRCRAFT WAS NOT GROUNDED: AFT LAVATORY-D DOOR STUCK IN CLOSED POSITION. **SUPPLEMENTAL REPORT FOR AALA202404297451: REPLACED DOOR TRIM (AALA202404297451), DOOR RAIL (AALA202405066717) AND DOOR FRAME TRIM (AALA202405065353) PER CMM 25-40-64.**(CLOSED)SDR AALA202405017365Bulb · inoperativeAIRCRAFT IN BASE MAINTENANCE: R2 EXTERIOR EMERGENCY LIGHT INOPERATIVE. RELAMPED R2 EXTERIOR EMERGENCY LIGHT AND PERFORMED SATISFACTORY. OPERTIONAL CHECK GOOD. PER B737-NGAMM 33-51-04-960-801, B737-NG-AMM 33-51-00-710-801.SDR AALA202404309915Track · looseAIRCRAFT WAS NOT GROUNDED: LEFT AFT LABORATORY DOOR IS EXTREMELY HARD TO OPEN, A PASSENGER GOT STUCK INSIDE THE LAVATORY. **SUPPLEMENTAL REPORT FOR (AALA202404299915): FOUND LOOSE SCREWS ON THE UPPER RAIL LEFT AFT LAVATORY DOOR ,TIGHTENED SCREWS. PER AMM 20-00SDR AALA202404299915Door · stiffAIRCRAFT WAS NOT GROUNDED: LEFT AFT LABORATORY DOOR IS EXTREMELY HARD TO OPEN, A PASSENGER GOT STUCK INSIDE THE LAVATORY. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202404297451Door · stuckAIRCRAFT WAS NOT GROUNDED: AFT LAVATORY-D DOOR STUCK IN CLOSED POSITION. (OPEN).SDR AALA202404290987Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORT LAVATORY-E DOOR DIFFICULT TO OPEN AND CLOSE. ADJUSTED LAVATORY-E DOOR. PER 25-40-15SDR AALA202404297560Door · out of adjustAIRCRAFT WAS NOT GROUNDED: AFT LAVATORY-D DOOR GETS STUCK AND HARD TO OPEN AND CLOSE. ADJUSTED AFT LAVATORY-D DOOR. PER AMM 25-40-00.SDR AALA202404299488Gust Lock · out of adjustAIRCRAFT WAS NOT GROUNDED: MAIN ENTRY DOOR GUST LOCK STUCK. ADJUSTMENT MADE TO GUST LOCK ON MAIN ENTRY DOOR. OPERTIONAL CHECK GOOD. PER AMM 52-10-00.SDR AALA202405176664Web · corrodedAIRCRAFT IN BASE MAINTENANCE: AFT CARGO THRESHOLD WEB CORRODED. LOCATED AT BS 794 TO 847 AT STR S25R. REPLACED THRESHOLD WEB. PER AARD 51-00-05-1.SDR AALA202405095153Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT STA 951, RBL 50. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202405086147Skin · 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 AALA202405022403Connector · brokenAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS EMERGENCY LIGHTS ON RIGHT SIDE OF AIRCRAFT ARE BLINKING. **SUPPLEMENTAL REPORT FOR (AALA202404302403): REPAIR BROKEN WIRE TO TO CONNECTOR D10012 AND REMOVE AND REPLACED 17 DEF WALL LIGHT. PER AMM 22-21-00**(CSDR AALA202405015908Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 129.50, 9 INCHES FROM FRONT SPAR. DOUBLER REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202405017992Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 147.90, 8 INCHES FROM FRONT SPAR. DOUBLER REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202404302403Light · malfunctionedAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS EMERGENCY LIGHTS ON RIGHT SIDE OF AIRCRAFT ARE BLINKING. OPENSDR AALA202404296897Bracket · crackedAIRCRAFT WAS GROUNDED: FOUND CRACK IN RIGHT HAND MLG JUNCTION BOX BRACKET ON OUTBOARD FORWARD CORNER. REMOVED AND REPLACED JUNCTION BOX BRACKET. PER CMM 32-11-16.SDR AALA202404298576Module · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: UPON LOWERING LANDING GEAR, OBSERVED 3 RED INDICATORS ALONG WITH 3 GREEN ON PANEL ALONG WITH 3 GREEN ON OVERHEAD PANEL; AIRCRAFT LANDED SAFELY AT DFW. REMOVED AND REPLACED LANDING GEAR CONTROL LEVER MODUSDR AALA202404294472Light · unsecureAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT IS HANGING BY THE WIRE SEATS 13ABC. REPLACED EMERGENCY FLOOR LIGHT HOUSING AND BRACKET SECURED LIGHT, OPERTIONAL CHECK GOOD.SDR AALA202404294295Megaphone · inoperativeAIRCRAFT WAS NOT GROUNDED: FIRST CLASS MEGAPHONE INOPERATIVE. REPLACED MEGAPHONE. PER AMM 25-64-00.SDR AALA202404299629Girt Bar · unsecureAIRCRAFT WAS NOT GROUNDED: ENTRY DOOR GIRT BAR VERY LOOSE WHEN ATTACHED. RESECURED ENTRY DOOR GIRT BAR. PER AMM 52-00-00.SDR AALA202404294821Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR IS HARD TO OPEN. ADJUSTED FORWARD LAVATORY DOOR TRIM. PER AMM 25-40-00. OPERTIONAL CHECK NORMAL.SDR AALA202404299498Toilet · leakingAIRCRAFT WAS GROUNDED: FISH SMELLING ODOR THROUGHOUT THE CABIN. REMOVED AND REPLACED LAVATORY-A TOILET (AALA202404299498), PER AMM 38-32-15. REMOVE AND REPLACED BOTH LEFT HAND (AALA202404293290) AND RIGHT HAND (AALA202404296275) FAN AIR RECIRC AIR FILTERS, PERSDR AALA202404293290Air Filter · dirtyAIRCRAFT WAS GROUNDED: FISH SMELLING ODOR THROUGHOUT THE CABIN. REMOVED AND REPLACED LAVATORY-A TOILET (AALA202404299498), PER AMM 38-32-15. REMOVE AND REPLACED BOTH LEFT HAND (AALA202404293290) AND RIGHT HAND (AALA202404296275) FAN AIR RECIRC AIR FILTERS, PERSDR AALA202404296275Air Filter · dirtyAIRCRAFT WAS GROUNDED: FISH SMELLING ODOR THROUGHOUT THE CABIN. REMOVED AND REPLACED LAVATORY-A TOILET (AALA202404299498), PER AMM 38-32-15. REMOVE AND REPLACED BOTH LEFT HAND (AALA202404293290) AND RIGHT HAND (AALA202404296275) FAN AIR RECIRC AIR FILTERS, PERSDR AALA202404291082Insulation · contaminatedAIRCRAFT WAS GROUNDED: FISH SMELLING ODOR THROUGHOUT THE CABIN. REMOVED AND REPLACED LAVATORY-A TOILET (AALA202404299498), PER AMM 38-32-15. REMOVE AND REPLACED BOTH LEFT HAND (AALA202404293290) AND RIGHT HAND (AALA202404296275) FAN AIR RECIRC AIR FILTERS, PERSDR AALA202404297526O-Ring · leakingAIRCRAFT WAS GROUNDED: FISH SMELLING ODOR THROUGHOUT THE CABIN. REMOVED AND REPLACED LAVATORY-A TOILET (AALA202404299498), PER AMM 38-32-15. REMOVE AND REPLACED BOTH LEFT HAND (AALA202404293290) AND RIGHT HAND (AALA202404296275) FAN AIR RECIRC AIR FILTERS, PERSDR AALA202404294749Clamp · leakingAIRCRAFT WAS GROUNDED: FISH SMELLING ODOR THROUGHOUT THE CABIN. REMOVED AND REPLACED LAVATORY-A TOILET (AALA202404299498), PER AMM 38-32-15. REMOVE AND REPLACED BOTH LEFT HAND (AALA202404293290) AND RIGHT HAND (AALA202404296275) FAN AIR RECIRC AIR FILTERS, PER
Back to Boeing 737-823