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 AALA202402239976Bulkhead Web · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN MAIN LANDING GEAR WHEEL WELL BULKHEAD WEB AT BS 727, S18AL. REPAIRED WEB PER EA350812 AND SRM 51-40-02-0G.SDR AALA202402233013Slide · partial deployAIRCRAFT WAS GROUNDED: EMERGENCY SLIDE ON MAIN CABIN DOOR PARTIALLY DEPLOYED ON DOOR OPENING. REPLACED FORWARD L-1 SLIDE. PER CARD 08L22125001.SDR AALA202402235486Girt Bar · out of adjustAIRCRAFT WAS NOT GROUNDED: AFTER PARKING, FLIGHT ATTENDANT ADVISED THAT FORWARD ENTRY DOOR SLIDE RAFT APPEARS TO BE SLIGHTLY COMING OUT OF DOOR COMPARTMENT. ADJUSTED GIRT BAR OF L1 DOOR SLIDE.SDR AALA202402236784Floor Support · crackedAIRCRAFT IN BASED MAINTENANCE: CRACK IN PASSENGER FLOOR STRUCTURE INTERCOSTAL AT STA 537.45, LBL 25. REPLACED INTERCOSTAL PER SRM 51-40-05.SDR AALA202402233420Lock · stuckAIRCRAFT WAS NOT GROUNDED: LEFT SIDE AFT LAVATORY DOOR IS STUCK CLOSED AND FLIGHT ATTENDANT CANNOT OPEN. FREED LOCK.SDR AALA202402228192Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND RBL 15.04. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202402221688Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND RBL 32.40. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202402222142Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND RBL 54.60. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202402227660Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND RBL 40.87. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202402225341Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND RBL 6.14. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202402234281Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: THE DOOR LOCK ON LAVATORY D DOES NOT OPERATE PROPERLY. ADJUSTED AND APPLIED LUBRICANT TO LAVATORY DOOR D LATCH/MECHANISM PER AMM 25-40-14.SDR AALA202402227159Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND LBL 6.14. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202402220200Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND LBL 15.04. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202402228270Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND LBL 32.40. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202402220542Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND LBL 40.87. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202402227939Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: RIGHT FORWARD OVERWING EMERGENCY EXIT LIGHT INOPERATIVE. RELAMPED OVERWING FORWARD LIGHT. PER AMM 33-51-04-960-801, OPERATIONAL CHECK GOOD.SDR AALA202402221923Door · unsecureAIRCRAFT WAS NOT GROUNDED: FRONT LAVATORY DOOR DIFFICULT TO OPEN AND CLOSE. TIGHTENED FORWARD LAVATORY THRESHOLD. OPERATIONAL CHECK GOOD.SDR AALA202402220826Tube · missingAIRCRAFT WAS NOT GROUNDED: L1 DOOR HEAT SHRINK TUBING IS MISSING FROM ONE END OF THE GIRT BAR. INSTALLED RED HEAT SHRINK TUBE ON L1 DOOR GIRT BAR. PER AARD 25-66-00-4.SDR AALA202402227028Sliding Window · lack of lubeAIRCRAFT WAS NOT GROUNDED: FIRST OFFICERS WINDOW OPEN RELEASE LOCK IS INOPERATIVE. WINDOW WILL NOT LOCK IN OPEN POSITION. UNSTUCK FIRST OFFICER NUMBER 2 SLIDING WINDOW HOLD OPEN LOCK, CLEANED AND LUBED AND PERFORMED. FUNCTIONAL CHECK GOOD. PER AMM 56-12-11.SDR AALA202402223903Girt Bar · misalignedAIRCRAFT WAS NOT GROUNDED: FORWARD RIGHT SERVICE DOOR IS DIFFICULT TO ARM AND DISARM. RIGHT CLIP IS VERY TIGHT. FOUND EVACUATION SLIDE GIRT BAR MISALIGNED ADJUSTED GIRT BAR. PER 52-66-00.SDR AALA202402222880Lamp · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT LENS OVER DOOR AT SEAT 16A FELL OFF INFLIGHT. THE LIGHT DOES NOT ILLUMINATE DURING EMERGENCY LIGHT TEST. RESECURED LENS LAMP. PER AMM 33-22-00.SDR AALA202402229761Keelbeam · crackedAIRCRAFT IN BASE MAINTENANCE: FOUND CRACK IN WING CENTER SECTION KEEL BEAM AT RBL 40.00 TO 45.64. REPAIRED RIGHT HAND VAPOR BARRIER CRACK. PER SRM 57-10-10-2R-3 ALT. 2.SDR AALA202402228327Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE: FOUND CRACK IN VERTICAL PRESSURE DECK WEB AT BS 663 FROM LBL 24.92 TO LBL 31.83. REPAIRED VAPOR BARRIER. PER SRM 57-10-10-2R-3 ALT 2.SDR AALA202402215284Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN AFT CARGO COMPARTMENT FORWARD BULKHEAD FRAME INNER CHORD WEB ASSEMBLY AT STA 727, STR 18A LEFT. REPAIRED WEB AT LEFT HAND STA 727 STR 18A PER EA 350812 AND SRM 51-40-02-OG.SDR AALA202403015297Door · bindingAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR JAMMED. **SUPPLEMENTAL REPORT FOR (AALA202402215297): ADJUSTED AFT LEFT LAV DOOR PER CMM 25-40-64. OPS CHECK GOOD. OK FOR SERVICE. **(CLOSED).SDR AALA202402260046Oven · smokeAIRCRAFT WAS NOT GROUNDED: FORWARD GALLEY OVEN NUMBER 1 PRODUCES SMOKE WHILE HEATING.**SUPPLEMENTAL REPORT FOR (AALA202402200046): REPLACED NUMBER 1 OVEN. PER B737 AMM 25-32-03.**(CLOSED).SDR AALA202402223987Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND LBL 54.60. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202402226510Antenna · faultyAIRCRAFT WAS NOT GROUNDED: AN EMERGENCY WAS DECLARED AND LANDED SAFELY AT LAX DUE TO: DURING CAPTURE OF ILS, LEFT SIDE FLIGHT DIRECTOR FAILED AND LOST GUIDANCE CUES, ON SUBSEQUENT APPROACH IT FAILED AGAIN. REMOVED AND REPLACED (LRRA) LOW RANGE RADIO ALTIMETER SDR AALA202402224904Metering Valve · faultyAIRCRAFT WAS GROUNDED: AIRCRAFT PULLS LEFT UNCOMMANDED DURING TAXI AND TAKEOFF OPERATIONS. REPEAT WRITE UP. UNSAFE FOR PASSENGER OPERATIONS. **SUPPLEMENTAL REPORT FOR (AALA202402214904): REMOVED AND REPLACED STEERING METERING VALVE. PER AMM 32-51-11. OPERATIONSDR AALA202402214904Unknown · unknownAIRCRAFT WAS GROUNDED: AIRCRAFT PULLS LEFT UNCOMMANDED DURING TAXI AND TAKEOFF OPERATIONS. REPEAT WRITE UP. UNSAFE FOR PASSENGER OPERATIONS. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202402219869Shutoff Valve · inoperativeAIRCRAFT WAS GROUNDED: ANTI SKID INOPERATIVE AND PARKING BRAKE LIGHT ARE ILLUMINATED, RUN CHECKLIST IT DID NOT FIX ISSUE. REMOVED AND REPLACED PARKING BRAKE SHUT OFF VALVE. OPERATIONAL CHECK GOOD. PER B737 AMM 32-44-21.SDR AALA202402211522Lock · lack of lubeAIRCRAFT WAS NOT GROUNDED: LOCK JAMMED ON LAVATORY D DOOR. LUBRICATE LOCK AND LATCH MECHANISM.SDR AALA202402215525Handle · detachedAIRCRAFT WAS NOT GROUNDED: FIRST CLASS LAVATORY DOOR HANDLE CAME OFF ON THE INSIDE OF THE DOOR. RESECURED FIRST CLASS LAVATORY INSIDE DOOR HANDLE. CHECK NORMAL.SDR AALA202402216350Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT LEFT HAND LAVATORY LATCH IS BROKEN UNABLE TO OPEN. ADJUSTED LOCKING LATCH AND SPRAYED OIL.SDR AALA202402217134Door Latch · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT LAVATORY LATCH VERY DIFFICULT TO OPEN TO ACCESS LAVATORY. REMOVED AND REPLACED LAVATORY D LOCK MECHANISM. PER CMM 25-40-64. OPERATIONAL CHECK GOOD.SDR AALA202402215297Door · stuckAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR JAMMED.**SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202402219486Tube · missingAIRCRAFT WAS NOT GROUNDED: BOTH AFT EXIT DOORS MISSING RED SLEEVES ON GIRT BARS. INSTALLED RED HEAT SHRINK SLEEVE. PER AARD 25-66-00-4.SDR AALA202402218747Door · stuckAIRCRAFT WAS NOT GROUNDED: AFT LAVATORY DOOR STUCK. PUT DOOR BACK IN TRACK.SDR AALA202402213725Relay · inoperativeAIRCRAFT WAS GROUNDED: RIGHT CENTER PUMP LIGHT ILLUMINATED WITH SWITCH ON ADDITIONALLY, FUEL WAS DRAINING FROM RIGHT WING CREATING FUEL IMBALANCE CONFIRMING LACK OF PRESSURE FROM RIGHT CENTER PUMP. LEFT SIDE OPERATED NORMALLY. FOUND RELAY K9904 DEFECTIVE, REMSDR AALA202402209833Slide · unserviceableAIRCRAFT WAS NOT GROUNDED: R1 DOOR EMERGENCY ESCAPE SLIDE REQUIRES REPLACEMENT. REPLACED R1 DOOR ESCAPE SLIDE. PER WORK CARD 08L22125001.SDR AALA202402200046Oven · smokeAIRCRAFT WAS NOT GROUNDED: FORWARD GALLEY OVEN NUMBER 1 PRODUCES SMOKE WHILE HEATING. (OPEN).SDR AALA202402286078Compensator · faultyAIRCRAFT WAS GROUNDED: FUEL IMBALANCE. REPLACED RIGHT WING TANK FUEL COMPENSATOR (AALA202402206078) AND 7 FUEL PROBES (AALA202402287617, AALA202402287952, AALA202402281578, AALA202402288867, AALA202402282995, AALA202402288523, AALA202402288382) PER AMM 28-41SDR AALA202402287617Probe · faultyAIRCRAFT WAS GROUNDED: FUEL IMBALANCE. REPLACED RIGHT WING TANK FUEL COMPENSATOR (AALA202402206078) AND 7 FUEL PROBES (AALA202402287617, AALA202402287952, AALA202402281578, AALA202402288867, AALA202402282995, AALA202402288523, AALA202402288382) PER AMM 28-41SDR AALA202402287952Probe · faultyAIRCRAFT WAS GROUNDED: FUEL IMBALANCE. REPLACED RIGHT WING TANK FUEL COMPENSATOR (AALA202402206078) AND 7 FUEL PROBES (AALA202402287617, AALA202402287952, AALA202402281578, AALA202402288867, AALA202402282995, AALA202402288523, AALA202402288382) PER AMM 28-41SDR AALA202402281578Probe · faultyAIRCRAFT WAS GROUNDED: FUEL IMBALANCE. **SUPPLEMENTAL REPORT FOR AALA202402206078: REPLACED RIGHT WING TANK FUEL COMPENSATOR (AALA202402206078) AND 7 FUEL PROBES (AALA202402287617, AALA202402287952, AALA202402281578, AALA202402288867, AALA202402282995, AALA202SDR AALA202402288867Probe · faultyAIRCRAFT WAS GROUNDED: FUEL IMBALANCE. REPLACED RIGHT WING TANK FUEL COMPENSATOR (AALA202402206078) AND 7 FUEL PROBES (AALA202402287617, AALA202402287952, AALA202402281578, AALA202402288867, AALA202402282995, AALA202402288523, AALA202402288382) PER AMM 28-41SDR AALA202402282995Probe · faultyAIRCRAFT WAS GROUNDED: FUEL IMBALANCE. REPLACED RIGHT WING TANK FUEL COMPENSATOR (AALA202402206078) AND 7 FUEL PROBES (AALA202402287617, AALA202402287952, AALA202402281578, AALA202402288867, AALA202402282995, AALA202402288523, AALA202402288382) PER AMM 28-41SDR AALA202402288523Probe · faultyAIRCRAFT WAS GROUNDED: FUEL IMBALANCE. REPLACED RIGHT WING TANK FUEL COMPENSATOR (AALA202402206078) AND 7 FUEL PROBES (AALA202402287617, AALA202402287952, AALA202402281578, AALA202402288867, AALA202402282995, AALA202402288523, AALA202402288382) PER AMM 28-41-SDR AALA202402288382Probe · faultyAIRCRAFT WAS GROUNDED: FUEL IMBALANCE. REPLACED RIGHT WING TANK FUEL COMPENSATOR (AALA202402206078) AND 7 FUEL PROBES (AALA202402287617, AALA202402287952, AALA202402281578, AALA202402288867, AALA202402282995, AALA202402288523, AALA202402288382) PER AMM 28-41-SDR AALA202402226158Wire · cutAIRCRAFT IN BASE MAINTENANCE: FOUND EMERGENCY AISLE LIGHT INOPERATIVE DUE TO WIRES CUT. SPLICED WIRE TO CONNECTOR D11321 AISLE LIGHT. PER B737NG SWPM 20-10-13.
Back to Boeing 737-823