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 AALA202105049022Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FLOOR BEAM LOCATED AT STA 987 LBL 42. REPAIRED PER SRM 53-00-51 AND EA 327025.SDR AALA202104139017Wire · pulledAIRCRAFT IN BASE MAINTENANCE: FOUND WIRES TO HAVE BEEN PULLED FROM CONNECTORS ON EXIT LIGHT ON SIDEWALL L12. REPAIRED SIDEWALL L12 EXIT LIGHT IAW BSWPM 20-90-14, OPS CHECK GOOD.SDR AALA202104139016Wire · damagedAIRCRAFT IN BASE MAINTENANCE: SIDEWALL NO 12 RIGHT HAS DAMAGED WIRES FOR EMERGENCY LIGHT. REPAIRED WIRES IN ACCORDANCE WITH B737NG WDM 33-51-13 AND 20-90-14.SDR AALA202104139021Screw · looseAIRCRAFT WAS NOT GROUNDED: EMERGENCY FLOOR PROXIMITY LIGHT COVER LOOSE AT 10C. TIGHTENED SCREW ON SEAT 10C EMERGENCY PROXIMITY LIGHT COVER PER AMM 33-51-11.SDR AALA202104149022Fseu · inoperativeAIRCRAFT WAS GROUNDED: REJECTED TAKEOFF AT LOW SPEED 50 KTS BECAUSE OF TAKEOFF CONFIGURATION WARNING WITH LEADING EDGE FLAPS AND SLATS IN CORRECT CONFIGURATION. MINIMUM BRAKING USED. REPLACED SENSOR S168 (AALA202104149003) IAW AMM 27-87-00. REPLACED FLAP SLATSSDR AALA202104149003Sensor · inoperativeAIRCRAFT WAS GROUNDED: REJECTED TAKEOFF AT LOW SPEED 50 KTS BECAUSE OF TAKEOFF CONFIGURATION WARNING WITH LEADING EDGE FLAPS AND SLATS IN CORRECT CONFIGURATION. MINIMUM BRAKING USED. REPLACED SENSOR S168 (AALA202104149003) IAW AMM 27-87-00. REPLACED FLAP SLATSSDR AALA202104139012Switch · out of positionAIRCRAFT WAS GROUNDED: LANDING GEAR FAILED TO RETRACT ON TAKEOFF, FLIGHT RETURNED TO FIELD; DISCOVERED FIRE EXTINGUISHER FELL FROM MOUNT, HITTING ALTERNATE EXTENSION HANDLE DOOR AND TRIGGERING MICROSWITCH. CLOSED MANUAL EXTENSION DOOR AND PERFORMED FUNCTIONALSDR AALA202104139018Handle · misinstalledAIRCRAFT WAS GROUNDED: L1 UPPER DOOR ASSIST HANDLE NOT PROPERLY INSTALLED. RESECURED L1 UPPER DOOR ASSIST HANDLE IAW B737-NG AMM 52-11-31.SDR AALA202104139008Lock · stuckAIRCRAFT WAS NOT GROUNDED: LAVATORY #2 IN REAR OF AIRCRAFT DOOR LOCKS BUT CANNOT UNLOCK. ACCOMPLISHED INSPECTION/CHECK OF LAVATORY D AND E IAW AMM 25-40-14 AND AMM 25-40-15. NO DOOR LOCKING DEFECTS FOUND.SDR AALA202104139019Light · dislodgedAIRCRAFT WAS NOT GROUNDED: PASSENGER SEAT MOUNTED ESCAPE PATH LIGHT FALLING OFF AT SEAT 19C. SECURED SEAT MOUNT ESCAPE LIGHT AT 19C AS REQUIRED.SDR AALA202104139009Smoke Detector · false activationAIRCRAFT WAS NOT GROUNDED: LAVATORY SMOKE LIGHT ILLUMINATED IN COCKPIT AND FLIGHT ATTENDANTS REPORTED SMOKE ALARM IN LEFT AFT LAVATORY. DETECTOR NEEDED SHUT OFF TO STOP ALARM. SMOKE DETECTOR OPS NORMAL PER AMM 26-14-00.SDR AALA202104129016Light · inoperativeAIRCRAFT IN BASE MAINTENANCE: LEFT OVERWING FORWARD SLIDE LIGHT INOPERATIVE. REPLACED THE LAMPS LEFT FORWARD OVERWING LIGHT IAW B737 AMM 33-51-04.SDR AALA202104129015Retainer · brokenAIRCRAFT IN BASE MAINTENANCE: AFT FLIGHT EMERGENCY FLASHLIGHT HAS BROKEN RETAINER CLIP. REPLACED BROKEN RETAINER CLIP WITH NEW FLIGHT ATTENDANT EMERGENCY FLASHLIGHT RETAINER, PER B737 NG AMM 25-64-00-200-802.SDR AALA202104129014Lens · crackedAIRCRAFT IN BASE MAINTENANCE: R1 DOOR CEILING PANEL EMERGENCY LIGHT LENS HAS CRACK AT FASTENER HOLE. REPLACED EMERGENCY LIGHT LENS IAW SRM 51-40-02 AND AMM 25-21-30, OPS CHECK GOOD.SDR AALA202104149012Splice Plate · wornAIRCRAFT IN BASE MAINTENANCE: OVERSIZED HOLES DUE TO WEAR IN UPPER SPLICE PLATE OF MAIN CABIN FLOORBEAM AT STA 887 AND RBL 45.5. REPLACED SPLICE PLATE WITH NEW IAW BAC DWG 146A5525 AND B737 NG SRM 51-40-02.SDR AALA202104149011Seat Track · wornAIRCRAFT IN BASE MAINTENANCE: OVERSIZED HOLES DUE TO WEAR IN SEAT TRACK CARRY-THROUGH ANGLE OF MAIN CABIN FLOORBEAM AT STA 887 AND RBL 45.5. REPLACED ANGLE WITH NEW IAW B737 NG SRM 51-40-02 AND BAC DWG 147A5300 REV A.SDR AALA202104149010Seat Track · wornAIRCRAFT IN BASE MAINTENANCE: OVERSIZED HOLES DUE TO WEAR IN SEAT TRACK GUSSET FITTING OF MAIN CABIN FLOORBEAM AT STA 887 AND RBL 45.5. REPLACED GUSSET FITTING WITH NEW IAW B737 NG SRM 51-40-02 AND BAC DWG 147A5300 REV A.SDR AALA202104129023Door · out of adjustAIRCRAFT IN BASE MAINTENANCE: RH AFT LAV DOOR IS BINDING IN FRAME AND DRAGS WHEN OPENING AND CLOSING. ADJUSTED LAV DOOR IAW AMM 25-40-15, OPS CHECK GOOD.SDR AALA202104129020Light · unsecureAIRCRAFT WAS NOT GROUNDED: SEAT 12C EMERGENCY EXIT LIGHTING NOT SECURE. SECURED 12C EMERGENCY LIGHT SEAT TRIM IAW AMM 25-00-00, OPS CHECK GOOD.SDR AALA202104129017Cover · damagedAIRCRAFT WAS NOT GROUNDED: RH REAR EVACUATION SLIDE HAS HANDLE STICKING OUT. REPLACED COVER OVER EVACUATION SLIDE HANDLE, OPS CHECK GOOD.SDR AALA202104129019Lamp · inoperativeAIRCRAFT IN BASE MAINTENANCE: FOUND AFT RECESSED EMERGENCY LIGHT IS INOPERATIVE. RELAMPED AFT RECESSED EMERGENCY LIGHT IAW B737 AMM 33-21-00.SDR AALA202104129022Girt Bar · out of positionAIRCRAFT WAS NOT GROUNDED: R1 SLIDE GIRT BAR AND GIRT FLAP OUT OF POSITION. MADE ADJUSTMENTS TO R1 GRIT BAR OPERATIONS CHECK GOOD PER AMM 52-20-00.SDR AALA202104129018Handle · bindingAIRCRAFT WAS GROUNDED: CAPTAIN SLIDING FLIGHT DECK WINDOW DIFFICULT TO CLOSE AND OPEN WHEN UNLOCKING AND LOCKING. ADJUSTED L2 WINDOW HANDLE TENSION TO 75 IN LBS OPEN, 100 IN LBS. CLOSE WITHIN LIMITS PER AMM 56-12-11-820-801.SDR AALA202104149016Angle · elongatedAIRCRAFT IN BASE MAINTENANCE: ELONGATED HOLES ON SEAT TRACK CARRY THROUGH ANGLE LOCATED AT STA 887 LBL 24.75. REPLACED ANGLE PER SRM 51-40-02 AND DWG 147A5300..SDR AALA202104149015Angle · elongatedAIRCRAFT IN BASE MAINTENANCE: ELONGATED HOLES ON SEAT TRACK CARRY THROUGH ANGLE LOCATED AT STA 887 LBL 45.5. REPLACED ANGLE PER SRM 51-40-02 AND DWG 147A5300.SDR AALA202104149014Gusset · damagedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN FLOOR BEAM SEAT TRACK GUSSET FITTING HAS ELONGATED HOLES. LOCATED AT STA 887 LBL 45.5. REPLACED GUSSET FITTING PER SRM 51-40-02 AND DWG 147A5300.SDR AALA202104149013Splice Plate · damagedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN FLOOR BEAM SEAT TRACK UPPER SPLICE PLATE HAS ELONGATED HOLES. LOCATED AT STA 887 LBL 45.5. REPLACED SPLICE PER SRM 51-40-02.SDR AALA202104149009Angle · wornAIRCRAFT IN BASE MAINTENANCE: OVERSIZED HOLES DUE TO WEAR IN SEAT TRACK CARRY-THROUGH ANGLE OF MAIN CABIN FLOORBEAM AT STA 887 AND RBL 24.75. REPLACED ANGLE WITH NEW IAW B737 NG SRM 51-40-02 AND BAC DWG 147A5300 REV A.SDR AALA202104149020Gusset · damagedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN FLOOR BEAM SEAT TRACK GUSSET FITTING HAS OVER SIZED/ELONGATED HOLES AT STA. 887 RIGHT BUTT LINE 24.75. REMOVED AND REPLACED GUSSET FITTING PER SRM 51-40-02.SDR AALA202104149019Splice Plate · damagedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN FLOOR BEAM SEAT TRACK UPPER SPLICE PLATE HAS OVER SIZED/ELONGATED HOLES LOCATED AT STA 887 LEFT BUTT LINE 24.75. REMOVED AND REPLACED UPPER SEAT TRACK SPLICE PLATE AT STA 887 LEFT BUTT LINE 24.75 PER SRM 51-40-02.SDR AALA202104149018Gusset · damagedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN FLOOR BEAM SEAT TRACK GUSSET FITTING HAS OVER SIZED HOLES AT STA 887, LEFT BUTT LINE 24.75. REMOVED AND REPLACED GUSSET FITTING AT STA 887, LEFT BUTT LINE 24.75 PER SRM 51-40-02.SDR AALA202104149017Splice Plate · damagedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN FLOOR BEAM SEAT TRACK UPPER SPLICE PLATE HAS OVER SIZED/ELONGATED HOLES LOCATED AT STA 887 RIGHT BUTT LINE 24.75. REMOVED AND REPLACED UPPER SPLICE PLATE PER SRM 51-40-02.SDR AALA202104139010Door · bindingAIRCRAFT WAS NOT GROUNDED: AFT LAVATORY UNUSABLE, NO LEAKAGE. LEFT AFT LAVATORY DOOR IS DIFFICULT TO OPERATE AS REPORTED BY FLIGHT ATTENDANT. FOUND TRIM BENT ON DOOR FRAME. REMOVED AND REPLACED LAVATORY D DOOR FRAME PER ESO 61082.SDR AALA202104139011Cover · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT SIGN COVER AT EXIT ROW DETACHED. REINSTALLED SIGN COVER IAW AMM 33-51-00, OPS CHECK GOOD.SDR AALA202104119004Handle · exposedAIRCRAFT WAS NOT GROUNDED: AFT ENTRY DOOR HAS SLIDE HANDLE EXPOSED. (MANUAL INFLATION) HANDLE IS NOT COVERED. COVERED MANUAL INFLATION HANDLE WITH FLAP ON SLIDE PACK PER AMM 25-66-01.SDR AALA202104149026Angle · out of toleranceAIRCRAFT IN BASE MAINTENANCE: CARRY THROUGH ANGLE AT 887 AND RBL 45.50 HAS OUT OF ROUND HOLES. REMOVED AND REPLACED CARRY THROUGH ANGLE IAW BAC DWG 147A5300 REV A AND B737NG SRM 51-40-02.SDR AALA202104149024Angle · out of toleranceAIRCRAFT IN BASE MAINTENANCE: CARRY THROUGH ANGLE AT STA 887 AND LBL 24.75 HAS ELONGATED HOLES. REMOVED AND REPLACED CARRY THROUGH ANGLE IAW BAC DRAWING 147A5300 REV A AND B737NG SRM 51-40-02.SDR AALA202104139013Window · overheatedAIRCRAFT WAS GROUNDED: RIGHT SIDE WINDOW OVERHEAT. REMOVED AND REPLACED RIGHT SIDE COCKPIT WINDOW NUMBER 2 PER MCM 56-94-02.SDR AALA202104109007Housing · brokenAIRCRAFT WAS NOT GROUNDED: ESCAPE PATH LIGHTS AT SEAT 33C HANGING BY WIRES. MEL AUTHORIZED. REMOVED AND REPLACED ESCAPE PATH LIGHT HOUSING AT 33C IAW AMM 33-51-11.SDR AALA202104119009Engine · inoperativeAIRCRAFT WAS GROUNDED: CLIMBING THRU FL340 ENCOUNTERED SIGNIFICANT AIRFRAME VIBRATION FOLLOWED BY ODOR IN THE COCKPIT AND CABIN. ENGINE #2 N1 AND N2 ERATIC WITH LOSS OF THRUST AND HIGH ENGINE VIBRATION. SECURED ENGINE 2 BY FOLLOWING CHECKLIST. AFTER ENGINE WASSDR AALA202104109006Bulb · inoperativeAIRCRAFT WAS GROUNDED: LEFT FORWARD OVERWING EMERGENCY LIGHT INTERMITTENT. RELAMPED OVERWING EMERGENCY LIGHT.SDR AALA202104109005Connector · brokenAIRCRAFT IN BASE MAINTENANCE: FORWARD COS BOX #1 ELECTRICAL CONNECTOR IS BROKEN. REMOVED AND REPLACED CONNECTOR IAW B737-NG WDM 33-51-12.SDR AALA202104109004Connector · brokenAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHT CONNECTOR BETWEEN COS BOX 1 AND COS BOX 2 BROKEN. REMOVED AND REPLACED CONNECTOR IAW B737NG WDM 33-51-12.SDR AALA202104109001Fire Warning · false activationAIRCRAFT WAS NOT GROUNDED: ON RECALL DURING DESCENT, THE MASTER FIRE WARNING LIGHT ILLUMINATED AND WOULD NOT EXTINGUISH. DID FINALLY RESET. THEN, UPON ENGINE SHUTDOWN ILLUMINATED AGAIN, NO OTHER INDICATIONS. ACCOMPLISHED FIM PROCEDURE AND FIRE WARNING TEST PERSDR AALA202104119012Wedge · delaminatedAIRCRAFT IN BASE MAINTENANCE: RIGHT WING INBOARD FLAP TRAILING EDGE WEDGE DELAMINATED. REPLACED WEDGE ASSEMBLY PER SRM 51-40-02.SDR AALA202104149021Rib · crackedAIRCRAFT IN BASE MAINTENANCE: FOUND RIB CRACKED ON HORIZONTAL STABILIZER LOCATED AT STA 129.5. INSTALLED AN ANGLE REPAIR ON RIB PER SRM 55-10-09-2R-4.SDR AALA202104139023Skin · crackedAIRCRAFT IN BASE MAINTENANCE: FOUND 2 CRACKS ON LEFT HORIZONTAL STABILIZER LOWER SKIN AT STAB STA 166.3. PERFORMED DOUBLER REPAIR ON HORIZONTAL STABILIZER SKIN REF SRM 55-10-01-2R REPAIR 11.SDR AALA202104149025Intercostal · out of toleranceAIRCRAFT IN BASE MAINTENANCE: FOUND MAIN CABIN FLOOR STA 330 AND RBL 10.40 FORWARD INBOARD G2 GALLEY HARDPOINT. THE PILOT HOLES HAVE INSUFFECIENT SPACING TO EXISTING FASTENR HOLES. REMOVED AND REPLACED INTERCOSTAL IAW BAC DWG 147A5720 AND B737 SRM 51-40-02 FIGSDR AALA202104089020Circuit Breaker · trippedAIRCRAFT WAS NOT GROUNDED: FOUND CABIN EMERGENCY LIGHT CIRCUIT BREAKER POPPED. RESET CABIN EMERGENCY LIGHT P6-11 A-9 CIRCUIT BREAKER. ACCOMPLISHED EMERGENCY LIGHTS OPERATIONAL TEST PER AMM 33-51-00.SDR AALA202104089017Slide · out of positionAIRCRAFT WAS NOT GROUNDED: L1 DOOR SLIDE FELL OUT OF CASING. RE-SECURED L1 DOOR SLIDE IN ITS COMPARTMENT PER AMM 25-66-01.
Back to Boeing 737-823