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 AALA202502114535Connector · looseAIRCRAFT WAS NOT GROUNDED: RIGHT FUEL TANK SHOWING 500 TO 600 POUNDS LESS THAN LEFT TANK ON DESCENT. FUEL SHOWED NORMAL AGAIN WHILE LEVELED AROUND 4,000 FEET. CHECKED AND CONFIRMED NUMBER 2 MAIN TANK FUEL QUANTITY INOPERATIVE. REPEAT WRITE UP. **SUPPLEMENTAL RSDR AALA202502111958Apu · leakingAIRCRAFT WAS GROUNDED: VERY FOUL ODOR ON CLIMB OUT OF LAS VEGAS. SMELL WENT AWAY. THEN ON LANDING AROUND 3,000 FEET SMELL CAME BACK ALL THE WAY TO GATE. O2 MASK WAS USED. SMELLED LIKE DIRTY GYM SOCKS ON CLIMB OUT AND BURNING OIL ON LANDING. CABIN CREW SAID THESDR AALA202502103228Angle · crackedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND WING UPPER TRANSLATING PANEL JUST AFT OF PYLON LOWER WEB IS CRACKED AT OUTBOARD UPPER CORNER. REMOVED AND REPLACED LOWER ANGLE WEB ON RIGHT HAND WING UPPER TRANSLATING PANEL JUST AFT OF PYLON. PER B737-NG AIPC57-50-00-3SDR AALA202502063262Probe · inoperativeAIRCRAFT WAS NOT GROUNDED: NUMBER 1 MAIN TANK QUANTITY STOPPED TAKING FUEL AT 8190 LBS. REMOVED AND REPLACED LEFT HAND WING NUMBER 10 FUEL TANK PROBE.SDR AALA202502066168Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT BAFFLE CLIP LOCATED FORWARD OF STA 500G, AT RBL 25. REPLACED BAFFLE CLIP PER AARD 51-00-05-1.SDR AALA202502040029Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 312 TO BS 328 AT LBL 46. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202502045993Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM STA 328 TO STA 344 AT LBL 46. REPLACED INTERCOSTAL PER AARD 51-00-05-01.SDR AALA202502031958Unknown · odorAIRCRAFT WAS GROUNDED: VERY FOUL ODOR ON CLIMB OUT OF LAS VEGAS. SMELL WENT AWAY. THEN ON LANDING AROUND 3,000 FEET SMELL CAME BACK ALL THE WAY TO GATE. O2 MASK WAS USED. SMELLED LIKE DIRTY GYM SOCKS ON CLIMB OUT AND BURNING OIL ON LANDING. CABIN CREW SAID THESDR AALA202502033159Pump · warning lightAIRCRAFT WAS NOT GROUNDED: LEFT AFT FUEL PUMP LOW PRESSURE LIGHT CAME ON AFTER LANDING. LEFT AFT FUEL PUMP LOW PRESSURE LIGHT IS ILLUMINATED WHILE ON. REPEAT WRITE UP. (OPEN).SDR AALA202502034535Indication Sys · inoperativeAIRCRAFT WAS NOT GROUNDED: RIGHT FUEL TANK SHOWING 500 TO 600 POUNDS LESS THAN LEFT TANK ON DESCENT. FUEL SHOWED NORMAL AGAIN WHILE LEVELED AROUND 4,000 FEET. CHECKED AND CONFIRMED NUMBER 2 MAIN TANK FUEL QUANTITY INOPERATIVE. REPEAT WRITE UP. (OPEN).SDR AALA202502030290Fitting · 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 AALA202502031785Fitting · 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 AALA202502034742Fitting · 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 AALA202502033647Fitting · 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 AALA202502030169Fitting · 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 AALA202502031867Fitting · 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 AALA202502031779Fitting · 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 AALA202502037186Fitting · 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 AALA202502031003Fitting · 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 AALA202502192897Light · missingAIRCRAFT IN BASE MAINTENANCE: REMOVED PROXIMITY LIGHT ASSEMBLY FOR AIRCRAFT 3NC, PER CMM 25-32-08 REMOVED AND REPLACED 2 EACH (AALA202502194299) AND (AALA202502192897) FLOOR PROXIMITY LIGHTS, LOCATED AT THE LOWER G7 CLOSET, PER CMM 25-32-08. SUCCESSFULLY ACCOSDR AALA202502194299Light · missingAIRCRAFT IN BASE MAINTENANCE: REMOVED PROXIMITY LIGHT ASSEMBLY FOR AIRCRAFT 3NC, PER CMM 25-32-08 REMOVED AND REPLACED 2 EACH (AALA202502194299) AND (AALA202502192897) FLOOR PROXIMITY LIGHTS, LOCATED AT THE LOWER G7 CLOSET, PER CMM 25-32-08. SUCCESSFULLY ACCOSDR AALA202502199439Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR SUPPORT AT BS 992, LBL 37. REPLACED SUPPORT PER AARD 51-00-05-1.SDR AALA202502197281Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L2 DOOR LOWER SILL CHORD (CREASE ANGLE) LOCATED BETWEEN BS 978 AND BS 983 AT LBL 64. REPLACED CHORD PER AARD 51-00-05-1.SDR AALA202502174712Lamp · inoperativeAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND FORWARD OVERWING ESCAPE HATCH EXTERIOR EMERGENCY LIGHT INOPERATIVE RELAMPED RIGHT HAND FORWARD OVERWING ESCAPE HATCH EXTERIOR EMERGENCY LIGHT AND OPERATIONAL TEST IS GOOD. PER B737-NG-AMM 33-51-04-960-801.SDR AALA202502143173Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN CREASE ANGLE AT STA 326, RBL 60. REPLACED CREASE ANGLE PER AARD 51-00-05-1.SDR AALA202502142368Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR BEAM UPPER CHORD AT STA 986.5, FROM LBL 42 TO LBL 45. REPAIRED CHORD PER SRM 53-70-51-2R-6 ALTERNATIVE 4.SDR AALA202502146785Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT STA 951, RBL 41. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202502066992Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: AFT LOWER FUSELAGE DOOR SILL DRAIN CUTOUT CORRODED. CLEANED, BLENDED, AND REMOVED THE CORROSION ON THE AFT LOWER FUSELAGE DOOR SILL DRAIN CUTOUT AND IS WITHING LIMITS. PER B737NG SRM 53-00-01-1A-1 AND B737NG SRM 53-7-01-0I-1.SDR AALA202502042619Hinge · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR DIFFICULT TO OPEN FROM THE INSIDE. VERTIFIED LAVATORY-D DOOR BOTTOM PART IS BENT. **SUPPLEMENTAL REPORT FOR (AALA202501312619): READJUSTED DOOR HINGE AT AFT LAVATORY-D DOOR. PER CMM 25-40-64**(CLOSED).SDR AALA202501312619Structure · bentAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR DIFFICULT TO OPEN FROM THE INSIDE. VERTIFIED LAVATORY-D DOOR BOTTOM PART IS BENT. (OPEN).SDR AALA202501319247Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT LAVATORY-D DOOR IS HARD TO OPEN AND UNLOCKED UPPER DOOR LOCK AND LUBED ROLLERS. PER AMM 25-40-00.SDR AALA202501319437Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT BAFFLE CLIP AT STA 500H, RBL 26. REPLACED BAFFLE CLIP PER AARD 51-00-05-1.SDR AALA202501311097Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT BAFFLE CLIP AT STA 500H, RBL 26. REPLACED BAFFLE CLIP PER AARD 51-00-05-1.SDR AALA202501314775Stringer Clip · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT STINGER CLIP AT STA 500I, RBL 26. REPLACED STRINGER CLIP PER AARD 51-00-05-1.SDR AALA202501310272Stringer Clip · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT STINGER CLIP AT STA 500I, LBL 26. REPLACED STRINGER CLIP PER AARD 51-00-05-1.SDR AALA202501302137Power Supply · no testAIRCRAFT WAS NOT GROUNDED: RIGHT AFT EMERGENCY POWER SUPPLY INOPERATIVE. REMOVE AND REPALCED AFT EMERGENCY POWER SUPPLY. OPERTIONAL CHECK GOOD. PER AMM 33-51-06.SDR AALA202502211172Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL LOCATED BETWEEN STA 727G AND STA 827 AT LBL 25. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202502049124Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM STA 500D TO STA 500I AT S19R. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA202502046669Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL FROM STA 727 TO STA 767, S25R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202502047392Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT SHIELD FROM BS 767 TO BS 787 AT S25R. REPLACED SHIELD PER AARD 51-00-05-1.SDR AALA202502032824Elec Connector · brokenAIRCRAFT IN BASE MAINTENANCE: LEFT SEAT ROWS 13, 15, 20, 22 EMERGENCY LIGHT CONNECTORS BROKEN. REMOVED AND REPLACED LEFT SEAT ROW 13 (AALA202502032824), ROW 15 (AALA202502036075), ROW 20 (AALA202502032328), ROW 22 (AALA202502031304) EMERGENCY LIGHT CONNECTORS.SDR AALA202502031304Elec Connector · brokenAIRCRAFT IN BASE MAINTENANCE: LEFT SEAT ROWS 13, 15, 20, 22 EMERGENCY LIGHT CONNECTORS BROKEN. REMOVED AND REPLACED LEFT SEAT ROW 13 (AALA202502032824), ROW 15 (AALA202502036075), ROW 20 (AALA202502032328), ROW 22 (AALA202502031304) EMERGENCY LIGHT CONNECTORS.SDR AALA202502032328Elec Connector · brokenAIRCRAFT IN BASE MAINTENANCE: LEFT SEAT ROWS 13, 15, 20, 22 EMERGENCY LIGHT CONNECTORS BROKEN. REMOVED AND REPLACED LEFT SEAT ROW 13 (AALA202502032824), ROW 15 (AALA202502036075), ROW 20 (AALA202502032328), ROW 22 (AALA202502031304) EMERGENCY LIGHT CONNECTORS.SDR AALA202502036075Elec Connector · brokenAIRCRAFT IN BASE MAINTENANCE: LEFT SEAT ROWS 13, 15, 20, 22 EMERGENCY LIGHT CONNECTORS BROKEN. REMOVED AND REPLACED LEFT SEAT ROW 13 (AALA202502032824), ROW 15 (AALA202502036075), ROW 20 (AALA202502032328), ROW 22 (AALA202502031304) EMERGENCY LIGHT CONNECTORS.SDR AALA202501305216Lock · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT LAVATORY- D DOOR IS DIFFICULT TO OPERATE. LUBRICATED LOCK SLIDE OPERTIONAL CHECK GOOD. PER MM 52-50-00.SDR AALA202501301365Trim Panel · unsecureAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR IS DIFFICULT TO OPERATE. UPON INSPECTION OF LAVATORY-D DOOR, FOUND UPPER TRIM PLATE LOOSE. SECURED UPPER TRIM PLATE PER SMP. OPERTIONAL CHECK GOOD.SDR AALA202501303498Handle · lack of lubeAIRCRAFT WAS NOT GROUNDED: LAVATORY-A DOOR DIFFICULT TO OPEN. LUBRICATED LAVATORY-A DOOR HANDLE, OPERTIONAL CHECK GOOD. PER CMM 25-40-61.SDR AALA202502257721Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 129.30, 9 INCHES FROM FRONT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202502253686Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 129.50, 8 INCHES FROM FRONT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202502259007Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 129.50, 16 INCHES FROM FRONT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.
Back to Boeing 737-823