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 AALA202211289068Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK FOUND ON RIB OF LEFT HORIZONTAL STABILIZER LOCATED AT STA 111.10 AND INSPAR RIB. CRACK LENGTH: L= 0.421 INCHES. PERFORMED DOUBLER REPAIR ON INSPAR RIB PER SRM 55-10-09.SDR AALA202211253876Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: INTERCOSTAL UNDER FLOOR BOARD IS CRACKED AT APPROXIMATE STA 320 AND LEFT BUTT LINE 46. REMOVED AND REPLACED INTERCOSTAL PER AARD AND SRM 51-40-02.SDR AALA202211255503Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FOUND ON BULKHEAD SUPPORT LOCATED AT STA 500I AND STR 19R. REMOVED AND REPLACED BULKHEAD SUPPORT PER AARD 51-00-05-01.SDR AALA202211257308Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: RIGHT TRANSITION PANEL IS CORRODED. LOCATED AT STA 500H AND STR L26R. REMOVED AND REPLACED TRANSITION PANEL PER SRM 53-30-53-2A.SDR AALA202211251174Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FOUND ON TRANSITION PANEL LOCATED BETWEEN STA 727I +14 TO 767 AND STR 25R. REMOVED AND REPLACED RIGHT TRANSITIONAL PANEL PER SRM 53-00-53-2R.SDR AALA202211216512Skin · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON SKIN AT LAVATORY VENT LOCATED AT STA 917 AND BETWEEN STR 21L AND 22L. INSTALLED DOUBLER REPAIR PER SRM 53-70-01-2R-3.SDR AALA202211153809Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN CABIN FLOOR PANEL SUPPORT LOCATED FROM BS 992.8 TO BS 1060 AT RBL 30. REPLACED SUPPORT PER SRM 53-70-51-1A AND SRM 51-40-02-0G.SDR AALA202211158111Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN CABIN FLOOR PANEL SUPPORT Z ANGLE LOCATED AT BS 992.8 AND RBL 35. REPLACED FLOOR PANEL SUPPORT PER SRM 51-40-02-0G.SDR AALA202211148562Crease Beam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN DECK CREASE BEAM CHORD LOCATED FROM BS 951 TO BS 992.8 AT RBL46. REPLACED CHORD PER SRM 51-40-02-0G.SDR AALA202211148478Stringer Clip · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT FLOOR STRUCTURE MAIN FRAME AFT SIDE ATTACH ANGLE STRINGER CLIP LOCATED AT BS 500G AND S26L. REPLACED STRINGER CLIP PER SRM 51-40-02-0G,SDR AALA202211072167Autopilot Sys · faultedAIRCRAFT 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 INSDR AALA202211073141Windshield · delaminatedAIRCRAFT WAS GROUNDED: CAPTAINÏ¿½S WINDSHIELD SHOWS DELAMINATION AT HEATING ELEMENTS. REPLACED WINDSHIELD PER JOB CARD 08C21156001.SDR AALA202211077024Stop Pin · out of adjustAIRCRAFT WAS GROUNDED: L1 DOOR HANDLE SOFT LATCH RAISES UP ON LANDING / TAXI. FOUND LOWER FORWARD DOORSTOP MISSING SECURITY SPRING AND OUT OF ADJUSTMENT. PERFORMED STOP PIN ADJUSTMENT PER AMM 52-11-00-501. ALSO PERFORMED SATISFACTORY DOOR HANDLE TORQUE TEST PESDR AALA202211076327Windshield · delaminatedAIRCRAFT WAS GROUNDED: FIRST OFFICERÏ¿½S WINDSHIELD SHOWS DELAMINATION AT HEATING ELEMENTS. REPLACED WINDSHIELD PER JOB CARD 08C21256001.SDR AALA202211256970Mount Bracket · corrodedAIRCRAFT IN BASE MAINTENANCE: LEFT WING NUMBER 2 SLAT OUTBOARD AUXILIARY TRACK TORSION ROD ADJUSTMENT MOUNT BRACKET HAS CORROSION. LOCATED AT THE LEFT WING STA 457 AND FRONT SPAR. INSTALLED NEW BRACKET PER BOEING DRAWING.SDR AALA202211151355Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN CABIN FLOOR BEAM T-CHORD LOCATED AT BS 986.5 AND FROM BL 0 TO LBL 46. REPLACED T-CHORD PER SRM 53-70-51-2R-4.SDR AALA202211157858Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT FLOOR STRUCTURE SUPPORT BAFFLE LOCATED FROM BS 500E TO BS 500F AT S26L. REPLACED BAFFLE PER SRM 51-40-02-0G AND SRM 51-40-05-0G.SDR AALA202211154699Stub Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN STUB FRAME LOCATED FROM BS 277 TO BS 344 AT RBL 60. REPLACED FRAME PER SRM 51-10-02-OG AND SRM 53-10-15-01-2 TABLE 2 FIG 3 ITEM 7.SDR AALA202211147812Strap · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON R1 DOOR LOWER SILL INNER CHORD STRAP LOCATED AT BS 303 AND RBL 60. REPAIRED STRAP PER DWG 141A8316 AND SRM 51-40-02-OG.SDR AALA202211146262Tee Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON BULK CARGO COMPARTMENT FLOOR PANEL SUPPORT STRAP TEE ASSEMBLY LOCATED AT BS 887 BETWEEN LBL 14 AND RBL 14. REPLACED TEE ASSEMBLY PER SRM 51-40-02-0G AND SRM 51-40-05-0G.SDR AALA202211146255Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN INTERCOSTAL LOCATED AT BS 294.5 AND BL 0. REPLACED INTERCOSTAL PER SRM 53-10-04-1A AND SRM 51-40-02G.SDR AALA202211142047Channel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO FLOOR STRUCTURE ZEE CHANNEL LOCATED AT BS 945.5 AND RBL 16.5. REPLACED ZEE CHANNEL PER SRM 51-40-02-0G.SDR AALA202211147042Structure · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT HAND INNER CHORD LOCATED FROM BS 360 TO BS 270 AT LBL 60. REPLACED CHORD PER SRM 53-10-15-1A AND SRM 51-40-02.SDR AALA202211081183Brake Assy · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN BREAK ASSEMBLY LOCATED AT BS 540 AND RBL 1. REPLACED BREAK ASSEMBLY PER AARD 51-00-05 AND DWG 143A0060.SDR AALA202211088415Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 138.70, 9 INCHES FROM FORWARD SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202211086206Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER ATTACH ANGLE LOCATED AT BS 663.75 AND S18R. REPAIRED ANGLE PER SRM 57-10-10-2R-5.SDR AALA202211080870Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN BREAK ASSEMBLY LOCATED AT BS 540 AND LBL 1. REPLACED BREAK ASSEMBLY PER AARD 51-00-05 AND DWG 143A0060.SDR AALA202211081241Structure · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD PASSENGER CABIN CHORD LOCATED FROM BS 294 TO BS 328, AT RBL 53. REPLACED CHORD PER SRM 51-40-02.SDR AALA202211088264Channel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT Z CHANNEL LOCATED FROM BS 500B TO BS 500I, AT RBL 21. REPLACED ZEE CHANEL PER SRM 53-00-53 REPAIR 5.SDR AALA202211073194Sliding Window · overheatedAIRCRAFT WAS GROUNDED: RIGHT SIDE WINDOW OVERHEAT LIGHT ILLUMINATED IN FLIGHT AND WOULD NOT EXTINGUISH PER QRH PROCEDURES. REPLACED R2 COCKPIT SLIDING WINDOW PER JOB CARD 08L21056002. OPERATIONAL AND PRESSURIZATION TEST GOOD.SDR AALA202211047296Retainer · looseAIRCRAFT WAS NOT GROUNDED: GIRT BAR HOLDER FOR STOWED POSITION (DISARM) IS LOOSE BAR KEEPS FALLING ON FLOOR. ADJUSTED R1 DOOR GIRT BAR CLIP AS REQUIREDSDR AALA202301199494Fitting · crackedAIRCRAFT WAS GROUNDED: DURING UT INSPECTION OF LEFT STA 663.75 FAIL SAFE STRAP FOUND A CRACK INDICATION AT THE UPPER AFT FASTENER. REMOVED AND REPLACED LEFT PICKLE FORK FITTING DUE TO CRACK.SDR AALA202301184696Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND FRAME (PICKLE FORK) AT REAR SPAR, LOCATED AT BS 663, S18L, AND WL 207. REPLACED FRAME ASSEMBLY PER AARD 51-00-05, DWG 144A2400, AND DWG 110A0150.SDR AALA202212015694Bracket · corrodedAIRCRAFT IN BASE MAINTENANCE: RIGHT WING ON FRONT SPAR NUMBER 7 SLAT OUTBOARD SEQUENCE TRACK TORSION ROD ATTACH BRACKET CORRODED ON FACE OG T BOLT HOLES. WING STAT 564 AND FRONT SPAR. INSTALLED NUMBER 7 SLAT OUT BOARD SEQUENCE TRACK TORSION ROD ATTACH BRACKET SDR AALA202212018346Bracket · corrodedAIRCRAFT IN BASE MAINTENANCE, RIGHT WING FRONT SPAR NUMBER 6 SLAT OUT BOARD SEQUENCE TRACK TORSION ROD ATTACH BRACKET CORRODED ON FACE OF T BOLT HOLES. INSTALLED TRACK TORSION ROD ATTACH BRACKET ON FRONT SPAR NUMBER 6 SLAT OUTBOARD SEQUENCE TRACK PER SRM 57-1SDR AALA202211252293Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FOUND IN FLOOR SHIELD LOCATED BETWEEN STA 767 AND 792 AND STR 25R. REMOVED AND REPLACED CORRODED SHIELD PER AARD 51-00-05.SDR AALA202211256588Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FOUND ON INTERCOSTAL LOCATED AT STA 954 AND 964, WATER LINE 208 AND RIGHT BUTT LINE 46. REMOVED AND REPLACED INTERCOSTAL PER SRM 51-40-01.SDR AALA202211252613Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FOUND ON FLOOR BEAM LOCATED AT STA 987 AND LEFT BUTT LINE 44. INSTALLED DOUBLER REPAIR PER SRM 37-70-57-2R-6.SDR AALA202211234542Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER RIB LOCATED AT STABILIZER STA 92.70, THIRD STIFFENER FROM FRONT. REPAIRED RIB PER SRM 55-10-09-2R-4.SDR AALA202211235725Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER RIB LOCATED AT STABILIZER STA 120.30, THIRD STIFFENER FROM FRONT. REPLACED RIB PER AARD 51-00-05, DWG 182A5403 AND SRM 51-40-02.SDR AALA202211237662Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR BEAM UPPER T CHORD LOCATED AT BS 947 AND LBL 26. REPAIRED UPPER T CHORD PER SRM 53-70-51-2R-5.SDR AALA202211237928Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR BEAM LOCATED AT BS 987 AND RBL 44. REPAIRED FLOOR BEAM PER SRM 37-70-57-2R-6 AND EA 340265.SDR AALA202211145076Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FLOOR BEAM UPPER T CHORD LOCATED AT BS 1016 AND RBL 33. REPAIRED T CHORD PER EA 339928 AND SRM 53-70-51-2R-4.SDR AALA202211146623Stringer Clip · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT FLOOR STRUCTURE MAIN FRAME FORWARD SIDE ATTACH STRINGER CLIP LOCATED AT BS 500G AND S26R. REPLACED STRINGER CLIP PER SRM 51-40-02-OG AND SRM 53-30-53.SDR AALA202211141112Stringer Clip · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT FLOOR STRUCTURE MAIN FRAME ATTACH STRINGER CLIP LOCATED AT BS 500I AND S26L. REPLACED STRINGER CLIP PER SRM 53-30-53 AND AND 51-40-02-0G.SDR AALA202211088741Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND FLOOR TRANSITION PANEL LOCATED FROM BS 767 TO BS 847 AT S25L. REPLACED TRANSITION PANEL PER SRM 51-40-02.SDR AALA202211072964Motor · failedAIRCRAFT WAS GROUNDED: STAB TRIM FAILED IN FLIGHT. EMERGENCY DECLARED, FLIGHT LANDED SAFELY AT DFW. REPLACED STAB TRIM MOTOR PER AMM 27-41-71. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202211035020Door Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR IS DIFFICULT TO OPEN / CLOSE. CLEANED AND LUBED DOOR LATCH ASSEMBLY. FLIGHT DECK DOOR OPERATIONAL CHECKS NORMAL PER AMM 52-51-00SDR AALA202211039805Striker · unserviceableAIRCRAFT WAS NOT GROUNDED: COCKPIT DOOR DIFFICULT TO CLOSE. REPLACED COCKPIT DOOR STRIKER. OPERATIONAL CHECK GOOD PER AMM 52-51-03.SDR AALA202211031481Door Latch · out of adjustAIRCRAFT WAS NOT GROUNDED: LATCH ON LEFT REAR LAVATORY DOOR DIFFICULT TO OPERATE FROM INSIDE. ADJUSTED LATCH MECHANISM PER CMM 25-40-64.
Back to Boeing 737-823