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 AALA202210053637Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT FLOOR SUPPORT STRUCTURE LOCATED BETWEEN BS 500C AND BS 500I AT S25R. REPLACED Z CHANNEL PLATE PER SRM 53-00-53-2R-5.SDR AALA202210054757Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT FLOOR SUPPORT STRUCTURE LOCATED BETWEEN BS 460 AND BS 500I AT S25L. REPLACED Z CHANNEL PLATE PER SRM 51-40-02-OG.SDR AALA202210053045Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED BETWEEN BS 500A AND BS 500I AT S26L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202210044019Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED FROM BS 500A TO BS 500I, RBL 25. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202209308383Plate · corrodedAIRCRAFT IN BASE MAINTENANCE: MULTIPLE AREAS OF CORROSION AROUND FASTENER HOLES AND UPPER SURFACE OF FORWARD CARGO COMPARTMENT FLOOR STRUCTURE RIGHT SIDE PLATE BETWEEN BODY STATION 500 A AND BODY STATION 500 I RIGHT BUTT LINE 24. FABRICATED NEW PART PER SRM 53SDR AALA202209303461Plate · corrodedAIRCRAFT IN BASE MAINTENANCE: MULTIPLE AREAS OF CORROSION AROUND FASTENER HOLES AND UPPER SURFACE IN THE FORWARD CARGO COMPARTMENT FLOOR STRUCTURE LIGHT SIDE PLATE BETWEEN BODY STATION 455 AND BODY STATION 500I AND LEFT BUTT LINE 24. REMOVED AND REPLACED SIDESDR AALA202209300130Panel · corrodedCORROSION AROUND FASTENER HOLE IN THE FORWARD CARGO COMPARTMENT RIGHT SIDEWALL PANEL SUPPORT LOWER END BODY STATION 500I APROXIMATLY RIGHT BUTT LINE 25.5. FABRICATED PANEL SUPPORT PER SRM 51-70-11-2R.SDR AALA202210059348Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED BETWEEN BS 787 AND BS 807 AT LBL 25. REPLACED TRANSITION PANEL PER SRM 51-40-02.SDR AALA202210053279Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN BREAK ASSEMBLY LOCATED AT BS 540, LBL 2. REPLACED BREAK ASSEMBLY PER AARD 51-00-05-1 DWG 143A5240.SDR AALA202210056183Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED BETWEEN BS 747 AND BS 767 AT RBL 24. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5 AND SRM 51-40-02.SDR AALA202210048880Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND SHIELD LOCATED FROM BS 767 TO BS 787, RBL 25. REPLACED SHIELD PER AARD 51-00-05-1 AND DWG 146A0081.SDR AALA202210040261Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT DOOR SILL PLATE WEB LOCATED FROM BS 440 TO BS 492.4, S25R. REPLACED WEB PER AARD 51-00-05-1 AND SRM 51-40-02.SDR AALA202210054639Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND BAFFLE LOCATED BELOW FORWARD CARGO COMPARTMENT FROM BS 460 TO BS 480 AT LBL 21. REPLACED BAFFLE PER DWG 143A7505 SHEET 4. AND AARD 51-00-05-1.SDR AALA202211157789Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND INTERCOSTAL LOCATED FROM BS 500G TO BS 500F AT S25L. REPLACED INTERCOSTAL PER SRM 53-00-53-1A AND SRM 53-10-02-0G.SDR AALA202210051326Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR SUPPORT STRUCTURE BREAK ASSEMBLY LOCATED AT BS 540 BETWEEN BL 0 AND RBL 23. REPLACED BREAK ASSEMBLY PER AARD 51-00-05-1.SDR AALA202210057789Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND INTERCOSTAL LOCATED FROM BS 500G TO BS 500F AT S25L. REPLACED INTERCOSTAL PER SRM 53-00-53-1A AND SRM 53-10-02-0G.SDR AALA202303308741Skin · crackedAIRCRAFT IN BASE MAINTENANCE: RIGHT HORIZONTAL STABILIZER - VISUAL INDICATION OF A CRACK IN THE LOWER SKIN AT STAB STA 101.90 LOCATED 18 INCHES FROM THE AFT SPAR. **SUPPLEMENTAL REPORT FOR AALA202209098741: REPAIRED SKIN PER SRM 55-10-01 AND EA 338490.** (CLOSSDR AALA202210051793Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR BEAM FASTENER HOLE LOCATED AR BS 986.5 AND RBL 43. REPAIRED FLOOR BEAM PER SRM 53-70-51-2R-6, PROCEDURE 4.SDR AALA2022100505424Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR BEAM FASTENER HOLE LOCATED AT BS 986.5 AND LBL 43. REPAIRED FLOOR BEAM PER SRM 53-70-51-2R-6.SDR AALA202210055901Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER RIB LOCATED AT STABILIZER STA 92.70, SECOND STIFFENER FROM FRONT. REPLACED RIB PER AARD 55-10-00-2 AND DWG 182A5301 AND SRM 51-40-02.SDR AALA202210057800Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR SUPPORT LOCATED AT BS 951 AND RBL 17. REPLACED FLOOR SUPPORT PER SRM 51-40-02.SDR AALA202210054204Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CABIN FLOOR SUPPORT INTERCOSTAL LOCATED FROM BS 947 TO BS 967, AT RBL 50. REPLACED INTERCOSTAL PER EA 339080 AND AARD 51-00-05.SDR AALA2022100595019Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION AROUND FLOORBEAM FASTENER HOLE LOCATED AT BS 967, AT RBL 47. REPAIRED FLOORBEAM PER EA 339080.SDR AALA202210053084Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 138.70, 9 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202210055248Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 147.90, 8 INCHES FROM FORWARD SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202210057406Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN INTERCOSTAL FLOOR SUPPORT LOCATED BETWEEN BS 947 AND 957, AT LBL 50. REPLACED INTERCOSTAL PER AARD 51-00-05-1, SRM 51-40-02, AND SRM 51-10-02-0G.SDR AALA202209301402Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR RIGHT HAND TRANSITION PANEL LOCATED FROM BS 727I TO BS 767 AND RBL 25. REPAIRED PER SRM 53-00-53-2R-5.SDR AALA202209297294Rib · crackedAIRCRAFT IN BASE MAINTENANCE: RIGHT HORIZONTAL STABILIZER RIB CRACKED AT FORWARD BOTTOM END STABILIZER STA 92.70. REMOVED AND REPLACED RIB PER SRM 51-40-02.SDR AALA202209296528Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN AFT ENTRY FLOOR SUPPORT INTERCOSTAL LOCATED BETWEEN BS 947 AND BS 962, AT LBL 25. REPLACED INTERCOSTAL PER SRM 53-70-51.SDR AALA202209274391Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON CABIN FLOOR RIGHT HAND CREASE ANGLE AT 2R DOOR, LOCATED FROM BS 947 TO BS 986.5 AT RBL 46. REPLACED CREASE ANGLE PER AARD 51-00-05-1 AND SRM 51-40-01.SDR AALA202209272676Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER RIB, LOCATED AT STABILIZER STA 92.70. THIRD STIFFENER FROM THE FRONT. REPLACED RIB PER AARD 55-40-02, BOEING DWG #182A5301 AND SRM 51-40-02.SDR AALA202210059584Support Bracket · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND SUPPORT L BRACKET LOCATED AT BS 360 AND S26L AT BL 0 REPLACED L BRACKET PER AARD 51-00-05-1 AND DWG 143A9485.SDR AALA202209297630Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON R1 DOOR CREASE ANGLE LOCATED FROM BS 294.5 TO BS 328 AT RBL 57. REPLACED CREASE ANGLE PER SRM 51-00-05-1.SDR AALA202210059741Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED FROM BS 767 TO BS 787, S26R, RBL 15. REPLACED TRANSITION PANEL PER SRM 51-00-05-02.SDR AALA202210059708Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND TRANSITION SHIELD WEB LOCATED FROM BS 500 TO BS 500A, AT RBL 24. REPLACED TRANSITION SHIELD WEB PER SRM 51-40-02.SDR AALA202209293913Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED FROM BS 360 TO BS 540 AT RBL 15, S26R. REPLACED TRANSITION PANEL PER SRM 51-40-02.SDR AALA202209270918Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO DOORWAY WEB LOCATED FROM BS 807 TO BS 813, AT STR 25R. REPLACED WEB PER AARD 51-00-05.SDR AALA202208188282Door · out of positionAIRCRAFT WAS NOT GROUNDED: LAVATORY DOOR LATCH DIFFICULT TO OPERATE. AFT,LEFT. PUT AFT LEFT LAVATORY DOOR BACK IN TRACK AS REQUIRED. OPERATIONS CHECK GOOD.SDR AALA202304189413Support Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD ENTRY DOOR THRESHOLD LOWER SILL SUPPORT ANGLE LOCATED AT BS 344, LBL 61. REPLACED SUPPORT ANGLE PER SRM 53-10-15-1A AND SRM 51-40-02. **SUPPLEMENTAL REPORT FOR AALA202209269413: ENGINEERING REVIEWED THIS EVENTSDR AALA202211150132Frame · corrodedAIRCRAFT IN BASE MAINTENANCE; CORROSION FOUND AT ELECTRONIC EQUIPMENT COMPARTMENT STUB FRAME, LOCATED AT BS 334, FROM STR 23L TO STR 24L. REPLACED PER SRM 51-30-01 AND DWG 141A1180-23 REV B. OPENSDR AALA202211041120Window · delaminatedAIRCRAFT WAS NOT GROUNDED: L1 WINDOW DELAMINATION ON TOP OF WINDOW (2 LOCATIONS). REMOVED AND REPLACED L1 WINDOW ASSEMBLY PER JOB CARD 08L21056003.SDR AALA202207203645Light · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT GALLEY EMERGENCY EXIT LIGHT RED LIGHT IS STUCK *ON* - TRIED CYCLING EXIT LIGHT SWITCH BACK TO ARMED OFF, ON, OFF. NO HELP. CYCLED AIRCRAFT POWER. OPERATIONS CHECKS GOOD. PER AMM 33-51-00.SDR AALA202207205209Nut · looseAIRCRAFT WAS GROUNDED: THE DOOR HANDLE MOVES 1 INCH TOWARD THE OPEN POSITION ITS THE LEFT AFT ENTRY DOOR. SECURED LEFT AFT INTERIOR DOOR HANDLE NUTS. PRESSURIZED AIRCRAFT CABIN. OPERATIONS CHECK WITHIN ALLOWABLE LIMITS.SDR AALA202207209607Life Raft · low pressureAIRCRAFT IN BASE MAINTENANCE: MID PASSENGER CABIN FORWARD POSITION LIFE RAFT LOW PRESSURE. REPLACED LIFE RAFT PER DWG DBF2000.SDR AALA202207203894Life Raft · low pressureAIRCRAFT IN BASE MAINTENANCE: FORWARD PASSENGER CABIN FORWARD POSITION LIFE RAFT LOW PRESSURE. REPLACED LIFE RAFT PER DWG DBF2000.SDR AALA202207202414Life Raft · low pressureAIRCRAFT IN BASE MAINTENANCE: FORWARD PASSENGER CABIN AFT POSITION LIFE RAFT LOW PRESSURE. REPLACED LIFE RAFT PER DWG DBF2000.SDR AALA202207202361Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND MAIN CABIN FLOOR WEB INBOARD ANGLE LOCATED FROM BS 310 - BS 334 AT RBL 55.5. REPLACED ANGLE PER AMM 53-11-01-420-801.SDR AALA202207194619Light · unsecureAIRCRAFT WAS NOT GROUNDED: EMERGENCY ESCAPE PATH LIGHT AT SEAT 31C INOPERATIVE. SECURED LIGHT BASE. OPERATIONAL CHECK GOOD PER AMM 33-51-11.SDR AALA202207191538Light · damagedAIRCRAFT WAS NOT GROUNDED: 2R DOOR EMERGENCY EXIT LIGHT DAMAGED. REPLACED LIGHT ASSEMBLY PER AMM 33-51-00.SDR AALA202207199825Rivet · brokenAIRCRAFT WAS GROUNDED: AT L1 DOOR, ONE GIRT BAR RETAINER CLIP ON SLIDE COVER HAD BROKEN RIVET. RE-INSTALLED GIRT BAR CLIP PER AMM 25-66-01.
Back to Boeing 737-823