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 AALA202109036549Girt Bar · out of positionAIRCRAFT WAS NOT GROUNDED: DOOR 1R GIRT BAR DIFFICULT TO INSTALL AND REMOVE FROM DOOR STOWAGE HOOKS. ADJUSTED GIRT BAR RETENTION CLIPS PER AMM 25-66-01 OK FOR SERVICE OPERATIONS CHECKS OK.SDR AALA202109039069Door · bindingAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR IS BINDING AND IS HARD TO OPEN AND CLOSE. LUBRICATED FORWARD LAVATORY DOOR THRESHOLD PER STANDARD MAINTENANCE PRACTICE.SDR AALA202109037426Track · stickingAIRCRAFT WAS GROUNDED: FIRST OFFICERS SLIDING WINDOW DIFFICULT TO OPEN AND CLOSE. FOUND FIRST OFFICERS WINDOW STICKING IN TRACK. VISUAL INSPECTION FOUND DEBRIS IN WINDOW TRACK. REMOVED DEBRIS AND LUBRICATED WINDOW TRACKS AS PER AMM 12-25-81.SDR AALA202109075515Shroud · damagedAIRCRAFT WAS NOT GROUNDED: ESCAPE PATH LIGHTING SEAT 18C DAMAGED. REPLACED ESCAPE PATH LIGHTING SHROUD ASSEMBLY ON ESCAPE PATH LIGHTING SEAT 18C.SDR AALA202109030969Sliding Window · crackedAIRCRAFT WAS GROUNDED: R2 WINDOW CRACKED DUE TO DAMAGED HUMP SEAL. REPLACED R2 WINDOW WITH SERVICEABLE UNIT IAW WORKCARD 08L21056002, LEAK AND OPS CHECK GOOD.SDR AALA202109026161Girt Bar · looseAIRCRAFT WAS NOT GROUNDED: R1 DOOR FORWARD AND AFT GIRT BAR HANGERS ON BUSTLE LOOSE. RE POSITIONED GIRT BAR HANGERS ON R1 DOOR SLIDE BUSTLE REF AMM 25-66-01.SDR AALA202109026254Window Post · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN L1 WINDOW POST BETWEEN STA 224.8 AND STA 243.7 BETWEEN STR 10L AND STR 14L, MEASURING L=0.025 IN, D=0.15 IN. ACCOMPLISHED PERMANENT REINFORCING DOUBLER REPAIR IAW ECO 5319J023.SDR AALA202109017890Handle · unsecureAIRCRAFT WAS GROUNDED: NOTIFIED BY GATE AGENT UPON LANDING THAT EXTERIOR HANDLE IS "OPEN" ON DOOR 1L. THIS EXPLAINS VIBRATION IN DOOR 1L DURING FLIGHT REPORTED BY FLIGHT ATTENDANT. REMOVED AND REPLACED SPRING INSIDE HANDLE SHAFT AT DOOR 1L PER AMM 52-11-11.SDR AALA202109014734Housing · looseAIRCRAFT WAS GROUNDED: PASSENGER SEAT MOUNTED ESCAPE PATH LIGHT HANGING LOOSE AT SEAT 20C. ESCAPE PATH LIGHT HOUSING AT SEAT 20C PER AMM 33-51-11.SDR AALA202109019135Housing · looseAIRCRAFT WAS GROUNDED: PASSENGER SEAT MOUNTED ESCAPE PATH LIGHT HANGING LOOSE AT SEAT 31C. REPLACED ESCAPE PATH LIGHT HOUSING PER AMM 33-51-11.SDR AALA202109018072Slide · dislodgedAIRCRAFT WAS NOT GROUNDED: FORWARD ENTRY DOOR 1L SLIDE PACK COMING OUT OF SLIDE CONTAINER. RESTORED SLIDE PER AMM 25-66-00SDR AALA202109029363Indicator · faultedAIRCRAFT WAS GROUNDED: AFTER LEVELING AT CRUISE WITH CTR TANK FUEL PUMPS SHUT OFF, RH MAIN FUEL TANK DISPLAYED AMBER QTY AND IMBALANCE MESSAGE; RH ENGINE SHUT DOWN PER QRH AND EMERGENCY DECLARED, FLIGHT RETURNED TO FIELD AND LANDED WITHOUT INCIDENT. ACCOMPLISHSDR AALA202109028494Guide Arm · damagedAIRCRAFT WAS GROUNDED: 1L DOOR GUST LOCK DIFFICULT TO OPEN. REPLACED GUIDE ARM WITH NEW IAW AMM 52-11-21-400-802, OPS CHECK GOOD.SDR AALA202109018882Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION MEASURING L=0.25 IN, W=0.25 IN, D=0.02 IN, ON FLOOR SUPPORT Z ANGLE LOCATED BETWEEN STA 990 TO STA 1016 AT LBL 32. REPLACED ANGLE PER AARD 51-00-05-1.SDR AALA202109049520Lens · missingAIRCRAFT WAS NOT GROUNDED: CENTER AISLE OVER WING EXIT SIGN MISSING CLOSE OUT PANEL. **SUPPLEMENTAL REPORT FOR AALA202108319520: REPLACED MISSING COVER PER AMM 33-51-0** (CLOSED)SDR AALA202108319520Sign · missingAIRCRAFT WAS NOT GROUNDED: CENTER AISLE OVER WING EXIT SIGN MISSING CLOSE OUT PANEL. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202108314906Lens · looseAIRCRAFT WAS NOT GROUNDED: SEAT 32C EMERGENCY PATH WAY LIGHT LENS LOOSE, WILL NOT STAY SECURE IN POSITION. SECURED LIGHT HOUSING ASSEMBLY PER CMM 25-21-63.SDR AALA202108303946Bleed Valve · looseAIRCRAFT WAS GROUNDED: DURING TAXI, BRAKE PEDALS PUSHED TO THE FLOOR WITH EXCESSIVE CHATTERING AND LOSS OF STOPPING FORCE. TIGHTENED #3 BRAKE BLEED VALVE AND BLED ALL BRAKES IAW AMM 32-41-00, LEAK AND OPS CHECK GOOD.SDR AALA202108306829Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: #1 GALLEY FLASHLIGHT WILL NOT TEST. REPLACED FLASHLIGHT IAW AMM 25-64-00, OPS CHECK GOOD.SDR AALA202108300060Bracket · looseAIRCRAFT WAS NOT GROUNDED: 1R DOOR GIRT BAR BRACKET IS LOOSE. ADJUSTED BRACKET IAW AMM 52-10-00, OPS CHECK GOOD.SDR AALA202108300248Slide · dislodgedAIRCRAFT WAS GROUNDED: WHILE CATERING, L2 DOOR SLIDE DROPPED OUT OF COVER. SLIDE DID NOT DEPLOY. REPLACED SLIDE ASSEMBLY PER JOB CARD 08L22125001.SDR AALA202109147490Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION MEASURING L=3.00 IN, W=1.00 IN, D=0.007 IN, ON FORWARD CARGO AREA LEFT HAND TRANSITION PANEL LOCATED BETWEEN STA 500D TO 500I AT LBL 26. REPLACED PANEL PER SRM 53-00-53-2R-6.SDR AALA202109143522Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION MEASURING L=3.50 IN, W=2.75 IN, D=0.008 IN, ON FORWARD CARGO AREA LEFT HAND TRANSITION PANEL LOCATED BETWEEN STA 500A TO 500I AT S26R. REPLACED PANEL PER AARD 51-00-05-1 SRM 51-40-02.SDR AALA202108312147Door Frame · damagedAIRCRAFT WAS GROUNDED: L2 DOOR FRAME AT TOP FORWARD DOOR STOP PIN IS WORN FROM CONTACT WITH PRESSURE PAD. REPLACED DOOR STOP (AALA202108305773) AND BLENDED DOOR FRAME DAMAGE (AALA202108312147) PER SRM 52-10-90- 51-20-06.SDR AALA202108315773Stop Pin · damagedAIRCRAFT WAS GROUNDED: L2 DOOR FRAME AT TOP FORWARD DOOR STOP PIN IS WORN FROM CONTACT WITH PRESSURE PAD. REPLACED DOOR STOP (AALA202108305773) AND BLENDED DOOR FRAME DAMAGE (AALA202108312147) PER SRM 52-10-90- 51-20-06.SDR AALA202108300078Track · unsecureAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR NEEDS ADJUSTMENT, IT STICKS. SECURED HARDWARE ON AFT LEFT LAVATORY DOOR TRACK AS NEEDED.SDR AALA202108301740Actuator · inoperativeAIRCRAFT WAS GROUNDED: RIGHT WING NUMBER 8 SPOILER SHAKES WHEN DEPLOYED TO FLIGHT DETENT. REMOVED AND REPLACED RIGHT WING NUMBER 8 SPOILER ACTUATOR PER B737NG AMM 27-61-51 AND AMM 27-61-00.SDR AALA202108302895Girt Bar · unsecureAIRCRAFT WAS GROUNDED: GIRT BAR AT 1L IS NOT SECURE IN DISARM CRADLE POSITION. REPLACED 2 RIVETS ON DOOR SLIDE PACK HANGERS PER AMM 20-30-00.SDR AALA202108307384Light · detachedAIRCRAFT WAS NOT GROUNDED: SEAT 30C EMERGENCY LIGHT FELL OFF. RE SECURED EMERGENCY LIGHT LENS AT SEAT 30C.SDR AALA202108307894Lock · stickingAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DEAD BOLT STICKY. CLEANED AND LUBRICATED LOCKING MECHANISM DOOR LOCK AT LEFT AFT LAVATORY DOOR PER ESO 61113.SDR AALA202109133905Pressure Deck · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK FOUND IN PRESSURE DECK WEB LOCATED AT STA 663, LEFT BUTT LINE 31.83-40. INSTALLED -1 DOUBLER AND -2 FILLER PER SRM 57-10-10-2R-3.SDR AALA202108311872Skin · damagedAIRCRAFT IN BASE MAINTENANCE: REPLACEMENT OF TEMPORARY SKIN REPAIR AT STA 1088 BETWEEN STR 24R AND STR 25R, MEASURING L=0.75 IN, 0.5 IN, D=0.25 IN. ACCOMPLISHED PERMANENT REINFORCING DOUBLER REPAIR IAW EA329907A.SDR AALA202108309982Lock · inoperativeAIRCRAFT WAS NOT GROUNDED: DOOR LOCKING MECHANISM FOR FORWARD LAVATORY DOOR INOPERATIVE. ADJUSTED LAVATORY 1 DOOR PER AMM 25-40-00.SDR AALA202108302383Handle · looseAIRCRAFT WAS NOT GROUNDED: LAVATORY DOOR DIFFICULT TO OPEN L1. FOUND DOOR HANDLE LOOSE, ADJUSTED DOOR HANDLE PER CMM 25-46-96.SDR AALA202108308500Indicator · brokenAIRCRAFT WAS NOT GROUNDED: BOTTOM SNAP FOR SLIDE ARMED INDICATOR AT 2R DOOR IS BROKEN. REMOVED AND REPLACED AFT R2 DOOR SLIDE ARMED INDICATOR PER AMM CH 52-13-00.SDR AALA202109173529Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FOUND ON FLOOR BEAM LOCATED AT STA 312 AND LEFT BUTT LINE 45.6. INSTALLED REINFORCEMENT ANGLES PER SRM 51-40-02.SDR AALA202109143336Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION MEASURING L=0.75 IN, W=0.03 IN, D=0.000 IN, ON INTERCOSTAL LOCATED BETWEEN STA 294 TO STA 312 AT LBL 11.6. REPLACED INTERCOSTAL PER AARD 51-00-05-1 AND SRM 51-40-02.SDR AALA202109077935Plate · wornAIRCRAFT WAS GROUNDED: MAIN CABIN DOOR GUST LOCK DOES NOT ENGAGE. REPLACED UPPER GUIDE CAM PLATE WITH NEW IAW AMM 52-11-21, OPS CHECK GOOD.SDR AALA202109013593Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: FLOOR BOARD SUPPORT STRUCTURE IS CRACKED AT STA 540, RIGHT BUTT LINE 1. INSTALLED NEW SUPPORT STRUCTURE PER AARD 51-00-05.SDR AALA202109019538Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CABIN FLOORBOARD SUPPORT STRUCTURE IS CRACKED AT STA 540, LEFT BUTT LINE 1. INSTALLED NEW STRUCTURE ASSEMBLY PER AARD 51-00-05.SDR AALA202108307935Gust Lock · inoperativeAIRCRAFT WAS GROUNDED: MAIN CABIN DOOR GUST LOCK DOES NOT ENGAGE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202108273931Stringer · tornAIRCRAFT IN BASE MAINTENANCE: TORN STRINGER AT ATTACH FITTING FASTENER HOLE AT STA 1086 AND STR 24R, MEASURING L=0.25 IN, W=0.25 IN, D=0.032 IN. ACCOMPLISHED PERMANENT REINFORCING REPAIR WITH NESTED ANGLES IAW SRM 53-00-03-2R-1.SDR AALA202108277700Doubler · crackedAIRCRAFT IN BASE MAINTENANCE: EXTERNAL POWER DOOR CUT OUT CRACKED ON FUSELAGE SIDE. INSTALLED DOUBLERS AND FILLERS ON EXTERNAL POWER DOOR CUT OUT ON FUSELAGE PER B737-800NG SRM 51-10-15.SDR AALA202108278630Connector · disconnectedAIRCRAFT WAS NOT GROUNDED: LEFT FORWARD OVERWING EMERGENCY EXIT FLUORESCENT LIGHT FLICKERS CONSTANTLY. ADJUSTED LIGHT CONNECTIONS AND ACCOMPLISHED OPERATIONAL CHECK PER AMM 33-51-00.SDR AALA202108272281Megaphone · inoperativeAIRCRAFT WAS GROUNDED: DURING THROUGH FLIGHT INSPECTION NUMBER 1 FLIGHT ATTENDANT DISCOVERED THAT THE MEGAPHONE LOCATED ABOVE FORWARD COAT CLOSET WAS INOPERATIVE. REMOVED AND REPLACED MEGAPHONE PER AMM 25-64-00.SDR AALA202108277421Smoke Detector · false activationAIRCRAFT WAS NOT GROUNDED: FIRST CLASS LAVATORY SMOKE ALARM CLIMBING THRU 30,000 FT. PASSENGER COMING OUT OF LAVATORY. LAVATORY CHECKED, NO THREATS INDICATED. ACCOMPLISHED VISUAL INSPECTION OF LAVATORY AND PERFORMED A LAVATORY SMOKE DETECTION SELF-TEST. TESTEDSDR AALA202108273520Lens · detachedAIRCRAFT WAS NOT GROUNDED: 4L DOOR EMERGENCY EXIT LIGHT LENS FELL OFF. REINSTALLED EXIT LENS.SDR AALA202108272360Stop · missingAIRCRAFT WAS GROUNDED: L1 DOOR AFT GIRT BAR STOP ASSEMBLY MISSING. INSTALLED GIRT BAR STOP, AFT POSITION PER AMM 25-66-01.SDR AALA202108278509Light · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT ADJACENT TO SEAT 19D POPPED FROM ITS TRACK. SECURED LIGHT PER AMM 33-51-01.SDR AALA202108273539Retainer · looseAIRCRAFT WAS NOT GROUNDED: R1 DOOR GIRT BAR DOESN'T LOCK INTO STOWED POSITION ON RIGHT SIDE. TIGHTENED RIGHT GIRT BAR STOW CLIP.
Back to Boeing 737-823