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 AALA202404056514Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON APU ENCLOSURE SUPPORT AT RIGHT HAND FORWARD SECTION OF DOOR SURROUND STRUCTURE FROM BS 1090 TO BS 1100, BL 0.SDR AALA202404040052Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 129.50, 8 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202404013211Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOORBEAM UPPER CHORD AT BS 986, LBL 387. REPAIRED CHORD PER SRM 53-70-51-2R-6 ALTERNATIVE 4.SDR AALA202404017231Skin · crackedAIRCRAFT IN BASE MAINTENANCE: 2 CRACKS IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 129.50, 16 INCHES AND 24 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202404010402Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 175, 8 INCHES FORWARD OF AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202404015817Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 138.7, 8 INCHES FORWARD OF AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202403270649Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM CREASE ANGLE AT BS 986, RBL 33. REPAIRED CREASE ANGLE PER SRM 53-70-51-6 ALTERNATIVE 4.SDR AALA202403270127Hinge · looseAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR DIFFICULT TO OPEN. **SUPPLEMENTAL REPORT FOR AALA202403210127: TIGHTEN DOOR HINGES PER CMM 25-40-64..** (CLOSED)SDR AALA202403258043Skin · corrodedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND SIDE OF FUSELAGE SKIN HAS SMALL AREA OF CORROSION AT AFT LAVATORY VENT AREA, LOCATED AT BS 917 BELOW STRINGER 22L. REMOVED CORROSION AND TREATED PRIMED AND APPLIED TOPCOAT ONTO AREA. PER SRM 51-10-02-0G, SRM 53-00-01-1A-SDR AALA202403210127Door · bindingAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR DIFFICULT TO OPEN. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202403207902Sensor · faultyAIRCRAFT WAS GROUNDED: NOSE LANDING GEAR WOULD NOT RETRACT AS COMMANDED AFTER TAKEOFF. RED NOSE GEAR ANNUNCIATOR LIGHT ILLUMINATED THROUGHOUT LANDING AND TAXI IN. FOUND NOSE LANDING GEAR LOCK SENSOR S0846 OUT OF RANGE, REMOVED AND REPLACED NOSE LANDING GEAR LOSDR AALA202403208370Threshold · unsecureAIRCRAFT WAS NOT GROUNDED: AFT LAVATORY D DOOR GETS JAMMED. TIGHTENED DOOR THRESHOLD HARDWARE PER AMM 25-40-15.SDR AALA202406100217Keelbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND KEEL BEAM FLANGE (CHORD) FROM STA 808 TO STA 813, S27R. REPLACED. CHORD REPLACED PER AARD 51-00-05 REPAIR 1.SDR AALA202403208349Light · malfunctionedAIRCRAFT WAS NOT GROUNDED: SIDE WALL LIGHT AT 8D IS FLICKERING. REPLACED SIDEWALL LIGHT AT SEAT 8A.SDR AALA202403208989Girt Bar · out of positionAIRCRAFT WAS NOT GROUNDED: FORWARD SERVICE DOOR IS DIFFICULT TO ARM. GIRT BAR IS HAVING TROUBLE TO SLIDE INTO PLACE. FOUND 'Z' FOLD NOT IN CORRECT R1 DOOR FRONT SIDE. RESTABLISHED 'Z' FOLD IN GIRT.SDR AALA202403185963Indicator · failedAIRCRAFT WAS GROUNDED: ON APPROACH TO CLT, FLAPS FAILED AT APPROX 4 DEGREES. THERE WAS A 1 DEGREE OR LESS SPLIT BETWEEN FLAPS. LANDING WAS UNEVENTFUL. RETRACTED FLAPS AFTER ARRIVING AT GATE. STILL ABOUT A 0.25 DEGREE SPLIT BETWEEN INDICATORS. LEFT FLAP INDICSDR AALA202403188349Light · malfunctionedAIRCRAFT WAS NOT GROUNDED: SIDE WALL LIGHT AT 8D IS FLICKERING. (OPEN)SDR AALA202406106080Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON STRINGER S27R AT STA 808. SPLICE REPAIRED STRINGER PER AARD 51-00-05-1.SDR AALA202403257167Failsafe · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN AFT CARGO COMPARTMENT LOWER FRAME FAILSAFE SPLICE AT BS 927, RBL 25. REPLACED SPLICE PER AARD 51-00-05-1 AND EA 352321.SDR AALA202403251135Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR STRUCTURE SHIELD FROM BS 767 TO BS 787, RBL 20. REPLACED SHIELD PER AARD 51-00-05.SDR AALA202403252646Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 312 TO BS 320, LBL 46. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202403259429Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 312 TO BS 328, RBL 30. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202403189557Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: DURING A-CHK, FOUND AFT RH FA FLASHLIGHT INOP. REMOVED AND REPLACED AFT RH FA FLASHLIGHT.SDR AALA202403187686Slide Raft · dislodgedAIRCRAFT WAS NOT GROUNDED: 1R DOOR SLIDE IS FALLING OUT OF ITS HOLDER. MAINTENANCE REMOVED, ADJUSTED, REINSTALL SLIDE PACK I.A.W. AMM 25-66-01.SDR AALA202403188469Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FWD LAV DOOR DIFFICULT TO OPEN - MORE PRONOUNCED AT ALTITUDE. MAINTENANCE ADJUSTED FWD LAV DOOR PER IAW AMM 25-40-00.SDR AALA202403187923Web · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN EQUIPMENT DOOR CUTOUT WEB AT BS 334, S27L, LBL 7. REPLACED WEB PER SRM 53-10-15-01.SDR AALA202403196803Light · abnormalAIRCRAFT WAS NOT GROUNDED: OVER WING EMERGENCY EXIT ROW 16D DOOR HAS FLICKERING LIGHT. REPLACED OVER WING DOOR LIGHT ASSEMBLY AT ROW 16 DEF.SDR AALA202403190072Light · faultedAIRCRAFT WAS NOT GROUNDED: ROW 16 ABC EMERGENCY EXIT SIDEWALL LIGHT NOT ON. WILL WORK EMERGENCY LIGHT SWITCH IS ON. REPLACED SIDEWALL LIGHT AT ROW 16 ABC.SDR AALA202403188982Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: DURING A-CHK FOUND AFT RH FA FLASHLIGHT INOP. REMOVED AND REPLACED AFT RH FA FLASHLIGHT BATTERY.SDR AALA202403184532Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: DURING A-CHK FOUND AFT LH FA FLASHLIGHT INOP. REMOVED AND REPLACED AFT LH FA FLASHLIGHT BATTERY.SDR AALA202403186803Light · malfunctionedAIRCRAFT WAS NOT GROUNDED: OVER WING EMERGENCY EXIT ROW 16D DOOR HAS FLICKERING LIGHT. (OPEN)SDR AALA202403180072Light · malfunctionedAIRCRAFT WAS NOT GROUNDED: ROW 16 ABC EMERGENCY EXIT SIDEWALL LIGHT NOT ON. WILL WORK EMERGENCY LIGHT SWITCH IS ON. (OPEN)SDR AALA202403185985Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FLOOR INTERCOASTAL AT STA 537.45, RBL 2. REPLACED INTERCOSTAL PER SRM 51-40-05.SDR AALA202403222241Stop Fitting · gougedAIRCRAFT IN BASE MAINTENANCE: L1 DOOR UPPER AFT STOP GOUGED. REPLACED STOP FITTING PER AARD 51-00-05 REPAIR 1.SDR AALA202403197421Housing · brokenAIRCRAFT WAS NOT GROUNDED: SEAT 22C EXIT PATH LIGHT HOUSING BROKEN. **SUPPLEMENTAL REPORT FOR AALA202403187421; REMOVED AND REPLACED 22C ESCAPE PATH LIGHT SHROUD** (CLOSED)SDR AALA202403180013Sensor · bindingAIRCRAFT WAS GROUNDED: TRAILING EDGE FLAPS JAMMED AT FLAPS 10 UNITS DURING APPROACH. USED ALTERNATE FLAP EXTENSION PROCEDURE TO EXTEND TO FLAPS 15. REPLACED RIGHT-HAND LEADING EDGE RETRACT F4 SENSOR S174 PER AMM 27-88-11.SDR AALA202403187421Light · brokenAIRCRAFT WAS NOT GROUNDED: SEAT 22C EXIT PATH LIGHT HOUSING BROKEN. (OPEN)SDR AALA202403184800Escape Rope · out of positionAIRCRAFT WAS NOT GROUNDED: FIRST OFFICER ESCAPE ROPE NOT ATTACHED. REINSTALLED FIRST OFFICER ESCAPE ROPE.SDR AALA202403183092Girt Bar · looseAIRCRAFT WAS NOT GROUNDED: RIGHT SIDE OF GIRT BAR FORWARD ENTRY DOOR IS LOOSE. MAINTENANCE SECURED GIRT BAR FWD ENTRY DOOR L1 IAW AMM 52-10-00.SDR AALA202403184791Tube · missingAIRCRAFT WAS NOT GROUNDED: R1 DOOR GIRT BAR HAS MISSING RED HEAT SHRINK OF RH SIDE OF DOOR. MAINTENANCE INSTALLED HEAT SHRINK TUBE AT R1 DOOR IAW W/C 2523J012-001.SDR AALA202403156878Fitting · 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 AALA202403151005Fitting · 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 AALA202403157878Fitting · 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 AALA202403156545Fitting · 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 AALA202403153132Fitting · 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 AALA202403150486Fitting · 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 AALA202403151716Fitting · 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 AALA202403152596Fitting · 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 AALA202403151262Fitting · 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 AALA202403153470Fitting · 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.
Back to Boeing 737-823