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 AALA202105249033Girt Bar · corrodedAIRCRAFT IN BASE MAINTENANCE: R2 DOOR GIRT BAR PITTED. REPLACED GIRT BAR IAW B737-NG AMM 25-66-01-000-804.SDR AALA202105209010Anti-Ice Valve · faultedAIRCRAFT WAS GROUNDED: #2 ENGINE ANTI-ICE VALVE COWL VALVE OPEN LIGHT AND "TAI" ON N1. EMERGENCY DECLARED AND RETURNED TO MIA. REMOVED AND REPLACED #2 ENGINE COWL TAI VALVE IAW AMM 30-21-11SDR AALA202105209009Battery · inoperativeAIRCRAFT IN BASE MAINTENANCE: FORWARD OVER WING HATCH EMERGENCY EXIT LIGHT AT 16A IS INOPERATIVE. REPLACED BATTERY PACK M1694 AT SEAT 16A, OPERATIONS CHECK GOOD PER AMM 33-51-06.SDR AALA202105209001Angle · missingAIRCRAFT WAS NOT GROUNDED: FORWARD GALLEY GIRT BAR CLIP MISSING. INSTALLED R1 CABIN DOOR SLIDE GIRT BAR CLIP PER AMM 51-40-02.SDR AALA202105209002Bulb · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT BULB INOPERATIVE. REPLACED BULB.SDR AALA202105289017Floor Support · faultyAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN INTERCOSTAL BETWEEN STA 360 AND 380, RBL 10.4 HAS FASTENER HOLES WITH NO SPACING. REPLACED INTERCOSTAL PER SRM 51-40-02 AND 51-40-04.SDR AALA202105289018Floor Support · out of toleranceAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN INTERCOSTAL AT STA 328-344 RBL 10.4 DOES NOT HAVE ADEQUATE SPACING. REMOVED AND REPLACED INTERCOSTAL IAW BAC DWG 141A5720 REV B, B737NG SRM 51-40-02 & 51-40-10.SDR AALA202105209008Connector · shortedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY ESCAPE PATH LIGHTS INOPERATIVE FROM SEAT 27 ABC THROUGH 33 ABC. REPAIRED SHORTED P1 CONNECTOR AT ROW 28 ABC.SDR AALA202105199015Sliding Window · dislodgedAIRCRAFT WAS NOT GROUNDED: FOUND CAPTAIN'S SLIDING WINDOW OFF TRACK AND SITTING IN CAPTAIN'S SEAT. REINSTALLED WINDOW PER AMM 56-12-00-400-801.SDR AALA202105199017Housing · looseAIRCRAFT WAS NOT GROUND: OVERWING EXIT FLOOR LIGHT HOUSING BENETH SEAT 16C IS LOOSE. SECURED AND TIGHTENED.SDR AALA202105199009Seal · tornAIRCRAFT WAS GROUNDED: FLIGHT ATTENDANTS REPORT AIR LEAK SQUEAL, APPROXIMATING A FIRE ALARM IN VOLUME, FROM TAKEOFF TO FL 380. CONTINUED ENTIRE CLIMB AND DESCENT. FLUSHING ANY LAVATORY GAVE "CONTINUED" TEMPORARY RELIEF FROM NOISE. CABIN PRESSURE AT 380 WAS APPSDR AALA202105199014Latch · bindingAIRCRAFT WAS NOT GROUNDED: CLOSET DOOR HARD TO OPEN BY 1L DOOR. ADJUSTED LATCH MECHANISM ON CLOSET DOOR BY L1 ENTRY DOOR AS REQUIREDSDR AALA202105199024Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY DECLARED DUE TO INOPERATIVE NOSE LANDING GEAR INDICATION, FLIGHT LANDED AND TAXIED TO GATE WITHOUT FURTHER INCIDENT. RELAMPED NLG DOWN AND LOCKED LIGHT IAW AMM 33-18-00, OPS CHECK GOOD.SDR AALA202105199022Wire Harness · brokenAIRCRAFT IN BASE MAINTENANCE: EXIT SIGN ON PANEL BETWEEN THE RIGHT SIDE OVER-WING EXITS HAS BROKEN WIRE HARNESS. REPAIRED WIRE HARNESS IAW B737NG SWOM 20-30-12, OPS CHECK GOOD.SDR AALA202105199021Battery Pack · inoperativeAIRCRAFT IN BASE MAINTENANCE: R1 DOOR EMERGENCY LIGHTS DO NOT STAY ILLUMINATED. REPLACED M1674 BATTERY PACK WITH SERVICEABLE UNIT IAW B737NG AMM 33-51-06-960-805, OPS CHECK GOOD.SDR AALA202105189007Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR DIFFICULT TO OPEN. LUBED DOOR RELEASE MECHANISM.SDR AALA202105189004Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR BINDS AGAINST FLOOR. REQUIRES MORE THAN USUAL FORCE TO OPEN AND CLOSE. ADJUSTED FLIGHT DECK DOOR PER AMM 52-51-00-006.SDR AALA202105179041Light · unsecureAIRCRAFT WAS NOT GROUNDED: AFT GALLEY CEILING EXIT LIGHT IS LOOSE. RESECURED AFT GALLEY CEILING EXIT LIGHT PER AMM 33-50-00.SDR AALA202105259013Attach Fitting · out of adjustAIRCRAFT IN BASE MAINTENANCE: LAVAROTY E HARDPOINT FITTING OUT OF ALIGNMENT. REPLACED PER EA 327658.SDR AALA202105179031Isolator · spinningAIRCRAFT IN BASE MAINTENANCE: ON FORWARD LEFT HAND OVER WING EXIT DOOR, THE FORWARD ISOLATOR FOR THE EXIT LIGHT HEADER IS SPINNING. VERIFIED AND RESECURED ISOLATOR FOR EXIT LIGHT HEADER IAW B737 SRM 51-40-02.SDR AALA202105179038Megaphone · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT MEGAPHONE UNSERVICABLE. REMOVED AND REPLACED AFT MEGAPHONE PER MCM2808.SDR AALA202105179028Door · bindingAIRCRAFT WAS NOT GROUNDED: FIRST CLASS LAVATORY DOOR STICKING. WORSE WHEN AIRCRAFT IS PRESSURIZED. ADJUSTED FIRST CLASS LAVATORY DOOR, OPERATIONS CHECK OK. PER AMM 52-41-00.SDR AALA202105179025Housing · damagedAIRCRAFT WAS NOT GROUNDED: SEAT 19C ESCAPE PATH LIGHTING COVER DAMAGED. REPLACED ESCAPE PATH LIGHTING HOUSING AT SEAT 19C PER ESO 61106.SDR AALA202105179039Megaphone · unserviceableAIRCRAFT WAS NOT GROUNDED: FORWARD MEGAPHONE UNSERVICABLE. REPLACED MEGAPHONE.SDR AALA202105179029Hook · out of adjustAIRCRAFT WAS NOT GROUNDED: 1R ENTRY DOOR GIRT BAR DIFFICULT TO ARM AND DISARM. ADJUSTED GIRT BAR STOWAGE CLIPS.SDR AALA202105179030Control Panel · smokeAIRCRAFT WAS GROUNDED: AT FL340, EXPERIENCED SMOKE IN COCKPIT FROM "FL' BUTTON ON TRANSPONDER AND FOUND "ELECTRICAL PANEL LIGHTS" CIRCUIT BREAKER POPPED; FLIGHT DIVERTED TO ORD AND LANDED WITHOUT FURTHER INCIDENT. REPLACED AIR TRAFFIC CONTROL CONTROL PANEL IAWSDR AALA202105149004Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: LH AFT GALLEY DOOR SLIDE LIGHT INOPERATIVE.REPLACED LAMP IAW AMM 33-51-04, OPS CHECK GOOD.SDR AALA202105149005Light · damagedAIRCRAFT WAS NOT GROUNDED: EXIT IDENTIFIER AT GALLEY COMPARTMENT 571 LENS IS OFF. REPLACED LIGHT L01191 PER AMM 33-51-01.SDR AALA202105149001Megaphone · inoperativeAIRCRAFT IN BASE MAINTENANCE: AFT LEFT HAND MEGAPHONE INOPERATIVE. REPLACED MEGAPHONE PER AMM 25-64-00.SDR AALA202105189022Support Angle · crackedAIRCRAFT IN BASE MAINTENANCE: FOUND FLOOR BOARD ANGLE SUPPORT CRACKED WITH CRACK LENGTH OF 1.5 INCH AT STA 540. REPLACED CRACKED SUPPORT ANGLE WITH NEW ANGLE REF SRM 51-40-01.SDR AALA202105174920Retainer · out of adjustAIRCRAFT WAS NOT GROUNDED: CABIN ENTRY DOOR SLIDE ARMED INDICATOR STRAP WILL NOT STAY CONNECTED. ADJUSTED INDICATOR STRAP RETAINING SNAP, OPS CHECK GOOD.SDR AALA202105176027Girt Bar · looseAIRCRAFT WAS NOT GROUNDED: 1R DOOR GIRT BAR CLIP LOOSE. ADJUSTED AFT GIRT BAR CLIP, OPS CHECK GOOD.SDR AALA202105179024Slide · not reportedAIRCRAFT WAS NOT GROUNDED: L1 SLIDE RAFT REQUIRES REPLACEMENT. REPLACED L1 SLIDE RAFT IAW WORKCARD 08L22125001.SDR AALA202105149007Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: MEGAPHONE INOPERATIVE. INSTALLED NEW BATTERIES IN MEGAPHONE MEGAPHONE OPERATIONS CHECKS OK PER AMM 25-60-00.SDR AALA202105149009Warning Switch · inoperativeAIRCRAFT WAS GROUNDED: TAKE OFF WARNING HORN SOUNDED AND TAKE OFF CONFIGURATION LIGHT ILLUMINATED WHEN THRUST LEVERS ADVANCED FOR TAKEOFF. REMOVED AND REPLACED THE SPEED BRAKE TAKEOFF WARNING SWITCH S651 IAW WDM 31-53-11.SDR AALA202105139005Megaphone · damagedAIRCRAFT IN BASE MAINTENANCE: MEGAPHONES FOUND TO BE MISSING HARDWARE. REPLACED MEGAPHONES IN G7 AND L17 BIN IAW AMM 25-64-00.SDR AALA202105139006Wire · unsecureAIRCRAFT WAS NOT GROUNDED: SEAT MOUNTED EMERGENCY LIGHTS AT ROWS 12, 13, 14 ARE INOPERATIVE. TROUBLE SHOOT SEAT MOUNTED EMERGENCY LIGHTS AT ROW 12,13, 14. FOUND P2 WIRING ON SEAT 11 NOT SECURED, RE-SECURED P2 WIRING AT SEAT 11 OPERATIONS CHECKED GOOD PER AMM 3SDR AALA202105139003Smoke Detector · false activationAIRCRAFT WAS NOT GROUNDED: LAVATORY SMOKE ILLUMINATED ON CLIMB OUT. RAN CHECK LIGHT. ACCOMPLISHED LAVATORY SMOKE DETECTION SELF TEST PER AMM 26-14-00. OPERATIONS TEST CHECKED OK.SDR AALA202105139002Smoke Detector · false indicationAIRCRAFT WAS NOT GROUNDED: SMOKE DETECTOR VISUAL ALERT LAVATORY D FALSE WARNING. ACCOMPLISHED LAVATORY D SMOKE DETECTOR SELF TEST PER AMM 26-14-00, NO FAULTS NOTED.SDR AALA202105189021Pressure Web · crackedAIRCRAFT IN BASE MAINTENANE: FOUND CRACK IN WING CENTER SECTION VERTICAL PRESSURE WEB AT STA 663.75 AND RBL 25 TO 45. REMOVED AND REPLACED WEB AND INSTALLED DOUBLER AND SHIM REPAIR REF SRM 57-10-10-2R-3 ALT 2.SDR AALA202105129004Light · detachedAIRCRAFT WAS NOT GROUNDED: FLOOR AISLE LIGHT DETATCHED AND LYING ON FLOOR NEAR 15C. RE SECURED EMERGENCY AISLE LIGHT AT SEAT 15C. CHECKS OK PER AMM 33-51-00.SDR AALA202105139011Floorbeam · damagedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN FLOOR BEAM AT STA 907 RBL 54 UPPER FLANGE HAS A NUT PLATE HOLE NEXT TO A PLUG. REPAIRED PER EA 327185 AND SRM 51-40-05, 51-40-02.SDR AALA202105129007Battery Pack · faultedAIRCRAFT WAS GROUNDED: ON LANDING EMERGENCY EXIT LIGHTS CAME ON THEN EXTINGUISED AFTER APPROXIMATELY 30 SECONDS. NO SWITCHES CHANGED IN COCKPIT. REPLACED FAULTY BATTERY PACK M1672 PER AMM 33-51-06.SDR AALA202105129003Motor · failedAIRCRAFT WAS GROUNDED: STAB OUT OF TRIM ILLUMINATED AT LEVEL OFF FL 300. FOLLOWED QRH PROCEDURES AUTOPILOT AND AUTO THROTTLE DISENGAGED AIRCRAFT TRIMMED NORMALLY. RETURNED TO DFW. REPLACED STAB TRIM MOTOR PER AMM 27-41-71.SDR AALA202105119009Hook · out of adjustAIRCRAFT WAS NOT GROUNDED: GIRT BAR CLIP ON R1 DOOR IS OVERTIGHT. ADJUSTED R1 DOOR GIRT BAR CLIP IAW AMM 25-66-01, OPS CHECK GOOD.SDR AALA202105119007Light · detachedAIRCRAFT WAS NOT GROUNDED: WHITE EMERGENCY LIGHT AT SEAT 19C HANGING FROM SEAT. RE SECURED 19C LIGHT PER 25-21-00.SDR AALA202105119005Slide · low pressureAIRCRAFT WAS NOT GROUNDED: R2 DOOR EMERGENCY ESCAPE SLIDE PRESSURE BELOW LIMITS. REPLACED R2 DOOR EMERGENCY ESCAPE SLIDE IAW J/C 08L22125001.SDR AALA202105119008Light · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT ROW 16 FOUND HANGING FROM CENTER OF CEILING. RE-SECURED MID CABIN EMERGENCY EXIT LIGHT IAW AMM 33-51-01.SDR AALA202105119004Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: FORWARD FLIGHT ATTENDANT INBOARD SEAT FLASHLIGHT INOPERATIVE. REMOVED AND REPLACED FORWARD FLIGHT ATTENDANT INBOARD SEAT FLASHLIGHT IAW AMM 25-64-00 AMM 20-50-11SDR AALA202105119011Support Fitting · damagedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN SEAT TRACK SUPPORT FITTING AT STA 927 LBL 24.75 DOES NOT HAVE EDGE MARGIN. INSTALLED NEW SEAT TRACK SUPPORT FITTING PER EA 327244 AND ECO T2383AB-007.
Back to Boeing 737-823