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 AALA202211036564Light · brokenAIRCRAFT WAS NOT GROUNDED: 25ABC AISLE ESCAPE PATH LIGHTING BROKEN OFF. REATTACHED 25ABC AISLE ESCAPE PATH LIGHTING AS REQUIREDSDR AALA202211034474Girt Bar · looseAIRCRAFT WAS NOT GROUNDED: 1R DOOR SLIDE DRAGS. SECURED LOOSE GIRT BAR AT 1R DOOR PER AMM 25-66-00.SDR AALA202211032282Mechanism · lack of lubeAIRCRAFT WAS NOT GROUNDED: LAVATORY DOOR DIFFICULT TO OPEN OR CLOSE. CLEANED AND LUBRICATED DOOR LAVATORY D SLIDING MECHANISM AS PER CMM 25-40-64.SDR AALA202211159299Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON R1 DOOR LOWER SILL INBOARD FLOOR SUPPORT CHORD LOCATED FROM BS 298 TO BS 328 AT LBL 6. REPLACED CHORD PER SRM 53-10-15-1A.SDR AALA202211149755Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON R1 DOOR LOWER SILL INBOARD FLOOR SUPPORT CHORD LOCATED FROM BS 298 TO BS 328 AT LBL 6.SDR AALA202211086001Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT BAFFLE LOCATED BETWEEN BS 400 AND BS 420 AT S25R. REPLACED BAFFLE PER SRM 51-40-02.SDR AALA202211036599Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT RIGHT OUTBOARD FLIGHT ATTENDANT FLASH LIGHT FAIL TEST. REMOVED AND REPLACED AFT RIGHT OUTBOARD FLIGHT ATTENDANT FLASHLIGHT BATTERY PER AMM 25-64-00.SDR AALA202211035419Latch · looseAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR HARD TO OPEN OR CLOSE. CHECKED LAVATORY D FOR OPEN AND CLOSED OPERATION, FOUND DOOR UPPER RELEASE LATCH LOOSE, SECURED LATCH DOOR, OPERATES NORMAL PER AMM 25-40-14SDR AALA202211294571Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HORIZONTAL STABILIZER SKIN LOCATED AT RIGHT STABILIZER STA 157.10 AND 8 INCHES FORWARD OF AFT SPAR. INSTALLED DOUBLER AND FILLER PER SRM 55-10-01-2R-11.SDR AALA202211231735Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 129.50. 9 INCHES FORWARD OF AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202211237206Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 147.90. 9 INCHES FORWARD OF AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202211231288Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 175.50. 9 INCHES FORWARD OF AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202211233787Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 129.50, 17 INCHES FORWARD OF AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202211238441Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 97, ALONG AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202211238206Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 138.70, 16 INCHES FORWARD OF AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R.SDR AALA202211160573Baffle · damagedAIRCRAFT IN BASE MAINTENANCE: LEFT BAFFLE HAS OVERSIZED FASTENER HOLES LOCATED BETWEEN STA 500D AND 500E AND LEFT BUTT LINE 24. INSTALLED NEW BAFFLE PER AARD 53-00-01-6.SDR AALA202211166443Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND BAFFLE CRACKED AT FASTENER HOLE LOCATED AT STA 500C AND 500D AND LEFT BUTT LINE 24.SDR AALA202211168183Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND BAFFLE CRACKED AT FORWARD FASTENER HOLE LOCATED AT STA 500 TO 500A. REMOVED AND REPLACED BAFFLE PER AARD 53-00-01-6.SDR AALA202211032937Door · unserviceableAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR IS DIFFICULT TO OPEN AND CLOSE. **SUPPLEMENTAL REPORT FOR AALA202211012937: REPLACED LAVATORY D DOOR HARDWARE PER CMM 25-47-21.** (CLOSED)SDR AALA202211152685Support · corrodedAIRCRAFT IN BASE MAINTENANCE: FORWARD CARGO AFT BULKHEAD LOWER BULKHEAD TO FLOOR SUPPORT LOCATED AT STA 500I LEFT BUTT LINE 21 TO RIGHT BUTT LINE 21 HAS CORROSION. REMOVED AND REPLACED FLOOR SUPPORT PER SRM 51-40-02-0G.SDR AALA202211154888Stringer Clip · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT FLOOR STRUCTURE MAIN FRAME ATTACH STRINGER CLIP LOCATED AT BS 500I AND S26R. REPLACED STRINGER CLIP PER SRM 51-40-02-0G.SDR AALA202211145678Stringer Clip · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT FLOOR STRUCTURE MAIN FRAME ATTACH STRINGER CLIP LOCATED AT BS 500I AND S26R. REPLACED STRINGER CLIP PER SRM 51-40-02-0G.SDR AALA202211140702Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT FLOOR STRUCTURE MAIN FRAME AFT SIDE ATTACH ANGLE LOCATED AT BS 500H AND RBL 26. REPLACED ATTACH ANGLE PER SRM 51-40-02-0G.SDR AALA202211080879Cargo Track · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT AFT BULKHEAD RIGHT HAND ACCESS PANEL LOWER SUPPORT RAIL LOCATED AT BS 500I AND RBL 21. REPLACED RAIL ASSEMBLY PER SRM 51-40-02-0G.SDR AALA202211145105Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON WEB LOCATED FROM BS 986.5 TO BS 1016 AT LBL 33. REPAIRED WEB PER SRM 53-70-51-1A.SDR AALA202211048497Channel · corrodedAIRCRAFT IN BASE MAINTENANCE: LEFT Z CHANNEL LOCATED AT STA 992-1016 AND 33 INCHES LEFT BUTT LINE HAS CORROSION. REMOVED AND REPLACED Z CHANNEL PER SRM 53-70-51-1A.SDR AALA202210319641Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT RIGHTHAND FLIGHT ATTENDANT JUMP SEAT FLASHLIGHT #1 INOPERATIVE. REPLACED BATTERY PER AMM 25-64-00. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202210310287Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT RIGHTHAND FLIGHT ATTENDANT JUMP SEAT FLASHLIGHT #2 INOPERATIVE. REPLACED BATTERY PER AMM 25-64-00. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202210311748Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON INTERCOSTAL LOCATED BETWEEN BS 294.5 AND BS 312, AT LBL 12. REPLACED INTERCOSTAL PER SRM 53-10-51-1A-1.SDR AALA202211150397Shear Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND AFT SHEAR WEB LOCATED AT BS 990 AND RBL 33. REPAIRED SHEAR WEB PER SRM 53-70-51-2R-6. **SUPPLEMENTAL REPORT FOR AALA202210310397: ENGINEERING REVIEWED THIS EVENT AND DETERMINED THE CORRECT LEVEL WAS LEVEL 2SDR AALA202211084114Stringer · wornAIRCRAFT IN BASE MAINTENANCE: WEAR ON S15L LOCATED BETWEEN BS 500G AND BS 500H. REPAIRED STRINGER PER SRM 53-00-03-2R-1.SDR AALA202211087970Stringer · wornAIRCRAFT IN BASE MAINTENANCE: WEAR ON S15L LOCATED BETWEEN BS 500I AND BS 520. REPAIRED STRINGER PER SRM 53-00-03-2R-1.SDR AALA202211086554Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN THE INBOARD END OF PASSENGER CABIN FLOORBOARD SUPPORT LOCATED AT BS 540, FROM RBL 0 TO RBL 24. REPLACED FLOORBOARD SUPPORT PER AARD 51-00-05 AND DWG 143A5240.SDR AALA202211088279Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN THE INBOARD END OF PASSENGER CABIN FLOOR SUPPORT LOCATED AT BS 540, WL 208, AND LBL 2. REPLACED FLOOR SUPPORT PER AARD 51-00-05 AND SRM 51-40-02.SDR AALA202211086637Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED FROM BS 730 TO BS 735, AT RBL 25. REPLACED TRANSITION PANEL PER AARD 51-00-05-1 AND DWG 146A7502.SDR AALA202211087592Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 847 TO BS 849, AT LBL 25. REPLACED TRANSITION PANEL PER AARD 51-00-05-1 AND DWG 146A750.SDR AALA202210316644Retainer · looseAIRCRAFT WAS NOT GROUNDED: GIRT BAR LOOSE ON FORWARD SERVICE DOOR. ADJUSTED CLIP FOR R1 DOOR, OK FOR SERVICE PER AMM 25-66-01.SDR AALA202210313021Windshield · crackedAIRCRAFT WAS GROUNDED: R1 WINDSHIELD CRACKED. REMOVED AND REPLACED R1 WINDSHIELD.SDR AALA202210314020Smoke Detector · false activationAIRCRAFT WAS NOT GROUNDED: L1 LAVATORY SMOKE DETECTOR AURAL ALERT WITH NO SMOKE, SUSPECT FALSE WIRING. REMOVED AND REPLACED L1 LAVATORY SMOKE DETECTOR PER AMM 26-14-01.SDR AALA202210310397Shear Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND AFT SHEAR WEB LOCATED AT BS 990 AND RBL 33. REPAIRED SHEAR WEB PER SRM 53-70-51-2R-6.SDR AALA202211290835Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO TRANSITION PANEL BETWEEN STA 727 AND STA 767 AT STR 25L. INSTALLED NEW TRANSITIONAL PANEL AT AFT CARGO PER SRM 51-40-02.SDR AALA202211218743Angle · crackedAIRCRAFT IN BASE MAINTENANCE: FOUND CRACK ON FLOOR SUPPORT LOCATED AT STA 540 AND RIGHT BUTT LINE 2. REMOVED AND REPLACED FLOOR SUPPORT ANGLE PER AARD 51-00-05-1.SDR AALA202211183411Support Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK FOUND ON FLOOR SUPPORT LOCATED AT STA 540 AND LEFT BUTT LINE 2. REMOVED AND REPLACED FLOOR SUPPORT ANGLE PER AARD 51-00-0501.SDR AALA202211088481Baffle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON BAFFLE ASSEMBLY LOCATED BETWEEN BS 500F AND BS 500G AT S25R. REPLACED BAFFLE PER SRM 53-30-53 2R1.SDR AALA202211082703Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN INTERCOSTAL LOCATED AT BS 282 AT BL 0. REPLACED INTERCOSTAL PER SRM 51-40-02, AARD 51-00-05-1 AND DWG 141A5410-139.SDR AALA202211044733Plate · corrodedFORWARD CARGO LEFT ZEE CHANNEL SIDE PLATE CORRODED LEFT BUTT LINE 21 FROM STA 500-500I. REMOVED AND REPLACED SIDE PLATE PER SRM 53-00-53-2R-6.SDR AALA202210316435Girt Bar · bindingAIRCRAFT WAS NOT GROUNDED: 1L GIRT BAR ENTRY DOOR DIFFICULT TO OPEN. ADJUSTED GIRT BAR, OPERATIONS CHECKS GOOD PER AMM 25-66-01.SDR AALA202210283414Door · bindingAIRCRAFT WAS NOT GROUNDED: COCKPIT DOOR DIFFICULT TO OPEN. LUBED DOOR. OK FOR SERVICE.SDR AALA202210289405Girt Bar · looseAIRCRAFT WAS NOT REQUIRED: AFT LEFT SLIDE/ GIRT BAR LOOSE. ADJUSTED CLIP FOR GIRT BAR ON L2 DOOR OK FOR SERVICE PER AMM 25-66-00.SDR AALA202210286117Power Supply · inoperativeAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING BATTERY PACK POWER SUPPLY M1672 FAILS OPERATIONAL TEST. INOPERATIVE. REPLACED BATTERY PACK POWER SUPPLY PER AMM 33-51-06-960-806.
Back to Boeing 737-823