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 AALA202209291548Hook · out of adjustAIRCRAFT WAS NOT GROUNDED: 1L GIRT BAR LOOSE. ADJUSTED CLIP FOR GIRT BAR & REINSTALLED 1L SLIDE IN ACCORDANCE WITH AMM 25-66-00.SDR AALA202209286726Lock · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR LOCK IS DIFFICULT TO OPERATE. LUBED LOCK MECHANISM. OPERATIONAL CHECK GOOD.SDR AALA202209286494Guide Arm · damagedAIRCRAFT WAS GROUNDED: 1L DOOR DIFFICULT TO CLOSE. REPLACED 1L DOOR GUIDE ARM ASSEMBLY PER AMM 52-11-21. OPERATIONAL CHECK GOOD.SDR AALA202209296448Slide · dislodgedAIRCRAFT WAS GROUNDED: ON OPENING FORWARD ENTRY DOOR, EMERGENCY EXIT SLIDE FELL OUT OF IT'S CASE SLIDE. DID NOT DEPLOY. REPLACED EXIT SLIDE IN ACCORDANCE WITH WORK CARD 08L22125001.SDR AALA202209279011Girt Bar · out of positionAIRCRAFT WAS NOT GROUNDED: SLIDE AT DOOR 2L HAS EXCESSIVE FABRIC HANGING FROM BOTTOM OF SLIDE PACK. ADJUSTED GIRT BAR ATTACHMENT FABRIC.SDR AALA202209278455Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: FORWARD RIGHT EMERGENCY SLIDE LIGHT OUT. REPLACED FORWARD RIGHT EMERGENCY SLIDE LAMP PER AMM 33-51-04.SDR AALA202209309028Web · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN AFT PASSENGER CABIN OUTBOARD FLOOR SUPPORT STRUCTURE WEB LOCATED AT BS 985.5 AND RBL 45. REPLACED WEB PER SRM 51-40-02-0G.SDR AALA202209304758Skin · corrodedAIRCRAFT IN BASE MAINTENANCE: PITTING IN VERTICAL STABILIZER UPPER TIP SKIN PANEL FASTENER HOLES LOCATED AT BS 1198.8 AND WL 353.6. REPAIRED SKIN PANEL PER SRM 51-40-02-0G.SDR AALA202209293044Engine · leakingAIRCRAFT WAS GROUNDED: INFLIGHT AT CRUISE AT FL340 NOTE OIL QUANTITY ON ENGINE NUMBER 2 WAS 0 AND OIL PRESSURE WAS BOUNCING FROM WHITE TO AMBER. THEN OIL PRESSURE DROPPED INTO RED. FOLLOW LOW OIL PRESSURE QUICK REFERENCE HANDBOOK AND SHUT DOWN NUMBER 2 ENGINSDR AALA202209281266Gust Lock · failedAIRCRAFT WAS NOT GROUNDED: L1 ENTRY DOOR GUST LOCK HARD TO RELEASE. **SUPPLEMENTAL REPORT REQUIRED** (OPEN)SDR AALA202209273173Lens · missingAIRCRAFT WAS NOT GROUNDED: LEFT HAND AFT LAVATORY DOORWAY EMERGENCY LIGHT LENS IS MISSING. REMOVED AND REPLACED EMERGENCY LIGHT ASSEMBLY IN ACCORDANCE WITH AMM 33-51-01.SDR AALA202209263800Striker · stickingAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR DIFFICULT TO OPEN FROM CABIN SIDE. REMOVED AND REPLACED CREW COCKPIT DOOR STRIKE ASSY PER AMM 52-51-03.SDR AALA202209263815Hinge · lack of lubeAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR DIFFICULT TO OPEN AND CLOSE. LUBRICATED DOOR HINGES PER AMM 25-40-14.SDR AALA202210190119Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FOUND ON LEFT TRANSITION PANEL FROM STA 727+4 THROUGH STA 847, AND LEFT BUTT LINE 36. REMOVED AND REPLACED LEFT TRANSITION PANEL PER SRM 51-40-02.SDR AALA202209269682Megaphone · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT MEGAPHONE VOLUME IS LOW AND WON'T ADJUST. REMOVED AND REPLACED AFT MEGAPHONE PER AMM 25-64-00.SDR AALA202211151062Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR SUPPORT Z ANGLE LOCATED AT BS 900 AND LBL 37. REPLACED Z ANGLE PER AARD 51-00-05-1 AND DWG 147A5700. **SUPPLEMENTAL REPORT FOR AALA202210181062: ENGINEERING REVIEWED THIS EVENT AND DETERMINEDSDR AALA202210249781Crease Beam · corrodedAIRCRAFT IN BASE MAINTENANCE: RIGHT CREASE ANGLE CORRODED FROM STA 960 TO 990 AT RIGHT BUTT LINE 60. REMOVED AND REPLACED RIGHT CHORD ANGLE PER AARD 51-00-05-1.SDR AALA202210194988Skin · crackedAIRCRAFT IN BASE MAINTENANCE: 0.35 INCH CRACK FOUND IN LOWER SKIN AT LEFT STABILIZER STA 147.90 AND 8 INCHES FROM FORWARD SPAR. REMOVED CRACKED SECTION AND INSTALLED A DOUBLER FILLER PER SRM 55-10-01-2R-11.SDR AALA202210198350Skin · crackedAIRCRAFT IN BASE MAINTENANCE: 0.35 INCH LONG CRACK IN LOWER SKIN OF RIGHT HORIZONTAL STABILIZER STATION 101.9 AND 27 INCHES FROM FORWARD SPAR. CUT OUT CRACK AND INSTALLED FILLER DOUBLER REPAIR TO SKIN PER 55-10-01-2R-11.SDR AALA202210195798Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: 1 X 1 INCH CORROSION FOUND ON TRANSITION PANEL LOCATED AT STA 500I AND LEFT BUTT LINE 25. INSTALLED NEW TRANSITION PANEL LEFT SIDE PER SRM 53-00-53-2R.SDR AALA202210190641Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FOUND ON RIGHT TRANSITION PANEL FROM 500A TO 500I AND RIGHT BUTT LINE 36. REMOVED AND REPLACED TRANSITION PANEL PER SRM 53-00-53.SDR AALA202210197938Web · corrodedAIRCRAFT IN BASE MAINTENANCE: AFT WET CORROSION ON WEB FORWARD OF RIGHT OUTBOARD GALLEY MOUNT STA 986 AND RIGHT BUTT LINE 32. REMOVED AND REPLACED WEB PER AARD 51-00-05.SDR AALA202210050638Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND MAIN DECK FLOOR SUPPORT LOCATED AT BS 992.8 AND RBL 25. REPLACED SUPPORT PER SRM 51-40-02-0G.SDR AALA202210050228Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN RIGHT HAND MAIN DECK FLOORBEAM LOCATED AT BS 986, FROM RLB 45 TO LBL 45. REPAIRED FLOOR BEAM PER SRM 53-70-51-2R-4 ALT 1.SDR AALA202209304245Seat Track · corrodedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN STA 650 LEFT BUTT LINE 45 SEAT TRACK CORRODED. MECHANICALLY REMOVED CORROSION PER SRM 51-10-02-0G.SDR AALA202209306520Web · corrodedAIRCRFAT IN BASE MAIINTENANCE: MAIN CABIN STA 500E - 500F AND RIGHT SIDE CUSP WEB CORRODED. REMOVED AND REPLACED MAIN CABIN CUSP WEB PER AARD 51-00-05-1.SDR AALA202209303539Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN INTERCOSTAL LOCATED FROM BS 500A TO BS 500D AT S25R. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202209307518Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON INTERCOSTAL LOCATED FROM BS 500BT O BS 500C, AT S26L. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202209269239Bulkhead Web · crackedAIRCRAFT IN BASE MAINTENANCE: VERTICAL PRESSURE DECK IN RIGHT WHEEL WELL HAS A CRACK INDICATION LOCATED AT STA 663.75 BETWEEN RIGHT BUTT LINE 31.83 AND 40.00. REPAIRED WITH DOUBLER PER SRM 57-10-10-2R.SDR AALA202209230089Flashlight · inoperativeAIRCRAFT WAS GROUNDED: FORWARD FLIGHT ATTENDANT FLASHLIGHT NO TEST. REPLACED FORWARD FLIGHT ATTENDANT FLASHLIGHT PER AMM 25-64-00.SDR AALA202209238780Clevis · migratedAIRCRAFT WAS GROUNDED: L1 DOOR EMERGENCY PACK LATCH CLEVIS REQUIRES REPLACEMENT DUE TO MIGRATING ROLL PIN AND FAILED SPRING TEST OVER 30 POUNDS. REPLACED L1 DOOR SLIDE LATCH CLEVIS ASSEMBLY AND VERIFIED SPRING TEST WAS GOOD PER JOB CARD 08L2215001.SDR AALA202209234915Light · detachedAIRCRAFT WAS NOT GROUNDED: ROW 21 LEFT EMERGENCY LIGHT CAME OFF. REMOVED AND REPLACED LIGHT ASSEMBLY.SDR AALA202209235709Door · stickingAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR STICKS WHEN OPENING. SECURED AFT LEFT LAVATORY DOOR IN ACCORDANCE WITH AMM 25-40-00.SDR AALA202301092840Bulkhead Web · crackedAIRCRAFT IN BASE MAINTENANCE: AFT PRESSURE BULKHEAD WEB ATTACHMENT AT STA 1016 BUTT LINE 17R CRACKED. REMOVED AND REPLACED WEB PER SRM.SDR AALA202210058833Floor Support · damagedAIRCRAFT IN BASE MAINTENANCE: ELONGATED HOLES IN AFT PASSENGER CABIN INTERCOSTAL LOCATED FROM BS 986.5 TO BS 1006 AT LBL 33. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA2022100500638Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 175.50, 9 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202210052005Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 129.50, 9 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202209309048Web · brokenAIRCRAFT IN BASE MAINTENANCE: BROKEN FORWARD CARGO COMPARTMENT LEFT HAND FLOOR PANEL SUPPORT WEB LOCATED AT BS 480 AND LBL 25. REPAIRED WEB PER SRM 51-40-02-0G.SDR AALA202209231262Latch · missingAIRCRAFT WAS NOT GROUNDED: LAVATORY E MISSING SLIDE LAVATORY DOOR LATCH. REMOVED AND REPLACED SLIDE LAVATORY E DOOR LATCH IN ACCORDANCE WITH CMM 25-40-65.SDR AALA202210059369Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT RIGHT HAND INTERCOSTAL LOCATED FROM BS 500H TO BS 500G AT S25R. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202210056590Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND FLOOR TRANSITION PANEL LOCATED FROM BS 767 TO BS 787 AT RBL 25. REPLACED TRANSITION PANEL PER SRM 51-40-02-0G.SDR AALA202210052542Structure · damagedAIRCRAFT IN BASE MAINTENANCE: DAMAGED HOLE IN CHORD LOCATED AT BS 986.5 AND LBL 33. REPAIRED PER SRM 53-70-51-2R.SDR AALA202210058017Doubler · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND PASSENGER CABIN MAIN DECK REPAIR DOUBLER LOCATED AT BS 992 AND RBL 30. REPAIRED DOUBLER PER SRM 51-40-02-0G.SDR AALA202209308984Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT RIGHT HAND INTERCOSTAL LOCATED FORM BS 500G TO BS 500H AT RBL 25. REPAIRED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202210059291Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN INTERCOSTAL LOCATED AT BS 947 AND LBL 15. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202210053420Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER RIB LOCATED AT STABILIZER STA 92.70, AT FIRST STIFFENER FROM FRONT. REPLACED RIB PER AARD 51-00-05-1-R1, DWG 182A1500, DWG 182A3001, AND DWG 182A4001.SDR AALA202211157209Beam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION AROUND SEVERAL FASTENER HOLES IN THE LEFT WING TRAILING EDGE LOWER ACCESS PANELS SUPPORT STRUCTURE BEAM ASSEMBLY LOCATED BETWEEN LEFT WING STA 335 AND STA 440. REPLACED BEAM ASSEMBLY PER SRM 57-51-02-1A PROCEDURE 1 AND SSDR AALA202211153637Channel · 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 AALA202211154757Channel · 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 AALA202210057209Beam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION AROUND SEVERAL FASTENER HOLES IN THE LEFT WING TRAILING EDGE LOWER ACCESS PANELS SUPPORT STRUCTURE BEAM ASSEMBLY LOCATED BETWEEN LEFT WING STA 335 AND STA 440. REPLACED BEAM ASSEMBLY PER SRM 57-51-02-1A PROCEDURE 1 AND S
Back to Boeing 737-823