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 AALA202211105330Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY D DOOR DIFFICULT TO OPEN OR CLOSE. ADJUSTED LAVATORY DOOR. OPERATIONAL CHECK NORMAL.SDR AALA202211108110Screw · looseAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR DIFFICULT TO OPEN AND CLOSE. TIGHTENED BOTTOM DOOR TRIM SCREWS PER CMM 25-40-64. OPERATIONAL CHECK GOOD.SDR AALA202211104966Fuse · blownAIRCRAFT IN BASE MAINTENANCE: SEAT EMERGENCY LIGHTING ROW 26 ABC AFT INOPERATIVE. REPLACED M1672 BATTERY PACK FUSE.SDR AALA202211297206Support · corrodedFORWARD CARGO AFT LOWER LEFT SUPPORT CORRODED LOCATED AT STA 500I AND STR 26L. REMOVED AND REPLACED FORWARD CARGO AFT SUPPORT PER SRM 51-40-02-0G.SDR AALA202211212204Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK FOUND ON 3RD STIFFENER RIGHT HORIZONTAL STABILIZER STA 92.70 AND 28 INCHES FROM AFT SPAR. REMOVED AND REPLACED RIB PER AARD 51-00-05-1.SDR AALA202211212232Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED BAFFLE LOCATED BETWEEN 500H TO 500I AND LEFT BUTT LINE 25. REMOVED AND REPLACED BAFFLE PER AARD 51-00-05.SDR AALA202211157687Web · damagedAIRCRAFT IN BASE MAINTENANCE: ELONGATED HOLE IN CUSP WEB LOCATED AT BS 290 AND RBL 64. REPLACED WEB PER SRM 51-40-02.SDR AALA202211152647Crease Beam · elongatedAIRCRAFT IN BASE MAINTENANCE: ELONGATED HOLE IN CREASE BEAM LOCATED FROM BS 500G TO BS 500H AT RBL 64. REPAIRED BEAM PER SRM 51-40-02 AND EA 340061.SDR AALA202211153052Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND SIDE CUSP WEB INNER CHORD LOCATED AT BS 639 AND LBL 64. REPLACED CUSP WEB INNER CHORD PER SRM 51-40-02.SDR AALA202211159999Support Fitting · damagedAIRCRAFT IN BASE MAINTENANCE: ELONGATED HOLE IN FORWARD CARGO COMPARTMENT FLOOR SUPPORT FITTING LOCATED AT BS 492 AND RBL 20. REPLACED SUPPORT FITTING PER SRM 51-40-02-0G.SDR AALA202211155533Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT FLOOR INTERCOSTAL LOCATED AT BS 500D + 8 INCHES AND LBL 16.5. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202211146888Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN CABIN FLOOR INTERCOSTAL LOCATED AT BS 951 AND LBL 24. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202211145541Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL LOCATED FROM BS 500A TO BS 500H AT RBL 16.5. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA202211149292Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED FROM BS 492 TO BS 500A AT RBL 27. REPLACED TRANSITION PANEL PER SRM 51-40-02-0G.SDR AALA202211102866Shear Tie · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND RBL 6.14. REPLACED SHEAR FITTING PER EA 340093.SDR AALA202211104567Shear Tie · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND RBL 15.04. REPLACED SHEAR FITTING PER EA 340093.SDR AALA202211105306Shear Tie · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND RBL 32.40. REPLACED SHEAR FITTING PER EA 340093.SDR AALA202211100465Shear Tie · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND RBL 54.60. REPLACED SHEAR FITTING PER EA 340093.SDR AALA202211094001Retainer · looseAIRCRAFT WAS NOT GROUNDED: FORWARD ENTRY DOOR GIRT BAR CLIPS ARE LOOSE CAUSING GIRT BAR TO SLIDE OUT. ADJUSTED FORWARD SERVICE DOOR GIRT BAR BUSTLE CLIP.SDR AALA202211099264Stop · disconnectedAIRCRAFT WAS NOT GROUNDED: UPON GATE ARRIVAL FLIGHT ATTENDANT REPORTS AFT RIGHT EXIT DOOR DISARM GIRT BAR STOPPER BECAME UNHINGED/DISCONNECTED. REATTACHED AFT RIGHT EXIT DOOR GIRT BAR STOPPER PER AMM 25-66-00SDR AALA202211098666Hinge · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY D DOOR DIFFICULT TO OPEN OR CLOSE. ADJUSTED LAVATORY D DOOR HINGE PER AMM 25-40-14. OPERATIONAL CHECK GOOD.SDR AALA202211090174Gust Lock · lack of lubeAIRCRAFT WAS NOT GROUNDED: L1 DOOR GUST LOCK DIFFICULT TO OPERATE. LUBED L1 GUST LOCK. OPERATIONAL CHECK GOOD.SDR AALA202211094434Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR DIFFICULT TO OPEN / LOCK. ADJUSTED FORWARD LAVATORY DOOR.SDR AALA202211087722Fairing · delaminatedAIRCRAFT WAS GROUNDED: DURING WALK AROUND FOUND LEFT HAND WING TO BODY FAIRING PANEL 194GL WITH CLUSTERED DELAMINATION. REPAIRED FAIRING PER EA 340315.SDR AALA202211151133Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN CABIN FLOOR BEAM LOCATED AT BS 986.5 AND FROM BL 0 TO RBL 46. REPAIRED FLOOR BEAM PER SRM 53-70-51-2R-4.SDR AALA202211159435Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN CABIN FLOOR WEB LOCATED AT BS 1016 AND LBL 30. REPLACED WEB PER SRM 51-40-02-0G.SDR AALA202211154499Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN CABIN FLOOR WEB LOCATED AT BS 989 AND LBL 30. REPLACED WEB PER SRM 51-40-02-0G.SDR AALA202211141698Crease Beam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN CABIN CREASE BEAM INNER CHORD LOCATED FROM BS 927 TO BS 992.8 AT LBL 54. REPLACED CHORD PER SRM 51-40-02-0G.SDR AALA202211109416Shear Tie · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND LBL 54.60. REPLACED SHEAR FITTING PER EA 340093.SDR AALA202211108318Shear Tie · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND LBL 40.87. REPLACED SHEAR FITTING PER EA 340093.SDR AALA202211101109Shear Tie · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND LBL 32.40. REPLACED SHEAR FITTING PER EA 340093.SDR AALA202211106901Shear Tie · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND LBL 15.04. REPLACED SHEAR FITTING PER EA 340093.SDR AALA202211102422Shear Tie · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND LBL 6.14. REPLACED SHEAR FITTING PER EA 340093.SDR AALA202211101815Shear Tie · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND RBL 40.87. REPLACED SHEAR FITTING PER EA 340093.SDR AALA202211086264Pseu · faultedAIRCRAFT WAS NOT GROUNDED: ON MULTIPLE OCCASIONS R1 DOOR WARNING CAME ON IN FLIGHT. DOOR HANDLE WAS DOWN. REPLACED PROXIMITY SWITCH ELECTRONICS UNIT (PSEU) PER AMM 32-09-10 AND ACCOMPLISHED FIM TASK 52-10-00-810-801.SDR AALA202211087314Gust Lock · unsecureAIRCRAFT WAS NOT GROUNDED: L1 DOOR GUST LOCK INOPERATIVE. SECURED L1 DOOR GUST LOCK LEVER PER AMM 52-11-11. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202211081286Pseu · faultedAIRCRAFT WAS NOT GROUNDED: ON MULTIPLE OCCASIONS L1 DOOR WARNING CAME ON IN FLIGHT. ACCOMPLISHED PROXIMITY SWITCH ELECTRONICS UNIT (PSEU) BITE PROCEDURE PER AMM 32-09-00. FOUND PSEU INTERNAL FAULT. REPLACED PSEU PER AMM 32-09-10 AND ACCOMPLISHED SATISFACTORY OSDR AALA202211087048Hinge · out of adjustAIRCRAFT WAS NOT GROUNDED: L4 LAVATORY BI FOLD DOOR DIFFICULT TO OPERATE. ADJUSTED LEFT HAND LAVATORY DOOR HINGE.SDR AALA202211149582Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO FLOOR INTERCOSTAL LOCATED FROM BS 500G TO BS 500H AT S26L. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202211088411Girt Bar · out of adjustAIRCRAFT WAS NOT GROUNDED: DOOR 1L SLIDE BUSTLE NEEDS ADJUSTMENT. ADJUSTED GIRT BAR PER AMM 25-66-01.SDR AALA202211081231Sliding Window · crackedAIRCRAFT WAS GROUNDED: IN FLIGHT R2 WINDOW CRACKED. EMERGENCY DECLARED; FLIGHT DIVERTED TO ATL LANDING SAFELY. REPLACED WINDOW HEAT CONTROLLER #1 (AALA202211088508) PER AMM 30-41-11. REPLACED WIRE HARNESS M2675 (AALA202211084645) AND REPLACED R2 SLIDING WINDOWSDR AALA202211084645Wire Harness · damagedAIRCRAFT WAS GROUNDED: IN FLIGHT R2 WINDOW CRACKED. EMERGENCY DECLARED; FLIGHT DIVERTED TO ATL LANDING SAFELY. REPLACED WINDOW HEAT CONTROLLER #1 (AALA202211088508) PER AMM 30-41-11. REPLACED WIRE HARNESS M2675 (AALA202211084645) AND REPLACED R2 SLIDING WINDOWSDR AALA202211088508Controller · faultyAIRCRAFT WAS GROUNDED: IN FLIGHT R2 WINDOW CRACKED. EMERGENCY DECLARED; FLIGHT DIVERTED TO ATL LANDING SAFELY. REPLACED WINDOW HEAT CONTROLLER #1 (AALA202211088508) PER AMM 30-41-11. REPLACED WIRE HARNESS M2675 (AALA202211084645) AND REPLACED R2 SLIDING WINDOWSDR AALA202211076111Girt Bar · looseAIRCRAFT WAS NOT GROUNDED: GIRT BAR ON R1 DOOR IS LOOSE. SECURED GIRT BAR ON SLIDE AT R1 DOOR.SDR AALA202211077513Cover · looseAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT COVER, SEAT 19C SIDE LIGHT, IS LOOSE. REPLACED LIGHT ASSEMBLY PER AMM 33-51-03. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202211088423Girt Bar · stickingAIRCRAFT WAS NOT GROUNDED: R1 DOOR SLIDE GIRT BAR STUCK UNDER THE DOOR. REMOVED GIRT BAR FROM UNDER R1 DOOR.SDR AALA202211071559Structure · unsecureAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR DIFFICULT TO CLOSE AND OPEN. SECURED AFT LEFT LAVATORY BI-FOLD DOOR BOTTOM TRIM PER CMM 25-40-64.SDR AALA202212055365Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD PASSENGER CABIN INTERCOSTAL UNDER FLOORBOARD LOCATED AT BS 285 AND BL 0. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202212010571Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT TRANSITION ANGLE LOCATED BETWEEN STA 500+14 TO 500I AND LEFT BUTT LINE 24. REMOVED AND REPLACED TRANSITION PANEL PER 51-40-02.SDR AALA202211302167Solenoid · inoperativeAIRCRAFT WAS GROUNDED: WITH PLANE IN TRIM SELECTED AUTO PILOT A ABRUPT / VIOLENT HARD ROLL TO THE RIGHT 30 DEGREES AUTOPILOT DISCONNECTED. HAND FLOWN FOR 5 MIN, RETRIMMED, SELECTED A AGAIN ANOTHER ABRUPT HARD ROLL TO RIGHT AUTOPILOT DISCONNECT. AIRCRAFT AIR IN
Back to Boeing 737-823