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 AALA202308115877Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL LOCATED FROM BS 792 TO BS 767 AT RBL 25R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202308115854Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR WILL NOT WORK. FOUND AFT LEFT LAVATORY DOOR TO BE STIFF. LUBRICATED.SDR AALA202308111157Latch Handle · inoperativeAIRCRAFT WAS NOT GROUNDED: L1 LAVATORY DOOR LATCH INSIDE INOPERATIVE. RESECURED L1 LAVATORY DOOR LATCH LOCK KNOB PER CMM 25-48-48.SDR AALA202308115067Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 147.90, 16 INCHES FORWARD OF AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202308115184Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER COMPARTMENT TRANSITION PANEL LOCATED FROM BS 727E TO BS 827 AT RBL 25. REPAIRED TRANSITION PANEL PER SRM 53-00-53-1A.SDR AALA202308095428Light · brokenAIRCRAFT WAS NOT GROUNDED: ESCAPE PATH LIGHTING BROKEN AT 29C. REINSTALLED EMERGENCY LIGHT ASSEMBLY AT 29C.SDR AALA202308097135Door Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR LATCH DIFFICULT TO OPEN AND CLOSE. LUBRICATED FORWARD LAVATORY DOOR LATCH PER AMM 52-00-00.SDR AALA202308090330Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: RIGHT AFT OUTBOARD FLIGHT ATTENDANT FLASHLIGHT IS INOPERATIVE. REPLACED FLASHLIGHT BATTERY PER AMM 25-64-00.SDR AALA202308094059Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY D DOOR LATCH IS DIFFICULT TO OPERATE. ADJUSTED LAV D DOOR PER AMM 52-51-00.SDR AALA202308088294Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR STICKS AND IS VERY DIFFICULT TO OPEN. LUBED AND CYCLED FORWARD LAVATORY DOOR.SDR AALA202309188970Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED FROM BS 500A TO BS 490, S25R. REPLACED TRANSITION PANEL PER SRM 53-00-53-1A.SDR AALA202308182690Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER ATTACH ANGLE LOCATED AT BS 662 AND RBL 42. REPAIRED ATTACH ANGLE PER SRM 57-10-10-2R-5.SDR AALA202308159077Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: FLOOR BEAM HAS CORROSION AROUND FASTENER HOLES LOCATED AT BS 982 FROM LBL 60 TO RBL 63. REMOVED AND REPLACED PREVIOUS T-CAP REPAIR. PER SRM 53-70-51-2R PROCEDURE 4.SDR AALA202308144678Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED IN FLOOR SUPPORT INTERCOSTAL LOCATED AT BS 335, LBL 47. REMOVED, FABRICATED, AND INSTALLED NEW INTERCOSTAL PER SRM: 51-40-02-0G.SDR AALA202308147084Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL LOCATED FROM BS 400 TO BS 500I, LBL 25. REMOVED, FABRICATED, AND INSTALLED NEW TRANSITION PANEL. PER SRM 53-00-53 2R-6.SDR AALA202308111828Seat Track · corrodedAIRCRAFT IN BASE MAINTENACE: CORROSOIN ON UPPER SURFACE OF PASSENGER CABIN SEAT TRACK LOCATED FROM BS 390 TO BS 480 AT RBL 24.75. REPAIRED SEAT TRACK PER SRM 53-00-52-2R-4.SDR AALA202308084868Unknown · looseAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR DIFFICULT TO OPEN AND CLOSE, BINDING AT BOTTON. CHECKED AND FOUND DOOR FRAME HARDWARE LOOSE. ADJUST THE DOOR AND SECURED HARDWARE AS REQUIRED PER AMM 52-52-00-14.SDR AALA202308073244Door · out of adjustAIRCRAFT WAS GROUNDED: FLIGHT DECK DOOR HARD TO OPEN. ADJUSTED FLIGHT DECK DOOR PER AMM 52-51-00.SDR AALA202308077978Lamp · burned outAIRCRAFT WAS NOT GROUNDED: COCKPIT EMERGENCY EXIT LIGHTS ANNUNCIATOR LIGHT BURNED OUT. REPLACED LAMP PER AMM 33-18-00.SDR AALA202308078958Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: RIGHT HAND SIDE LIGHT INOPERATIVE. RELAMPED RIGHT HAND SLIDE LIGHT PER AMM 33-51-04.SDR AALA202308102819Unknown · unknownAIRCRAFT WAS NOT GROUNDED: AN EMERGENCY WAS DECLARED ON APPROACH TO CLT DUE TO LEADING EDGE FLAPS TRANSIT LIGHT ILLUMINATED. USED ALTERNATE FLAPS TO EXTEND FLAPS TO 15. AIRCRAFT LANDED SAFELY AT CLT WITHOUT FURTHER INCIDENT. MAINTENANCE FOUND NO FAULTS. ACCOMPSDR AALA202308090273Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN INTERCOSTAL LOCATED FROM BS 380 TO BS 400 AT LBL 1. REPLACED INTERCOSTAL PER SRM 51-10-02.SDR AALA202308097234Eec · faultyAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DURING CRUISE ENROUTE TO SDQ DUE TO #2 ENGINE N1 DROPPED TO 20 TO 40%. CREW SHUTDOWN #2 ENGINE AND LANDED SAFELY AT SDQ WITHOUT FURTHER INCIDENT. **SUPPLEMENTAL REPORT FOR AALA202308077234: REPLACED #2 ENGINE ELSDR AALA202308071549Hook And Loop · unsecureAIRCRAFT WAS NOT GROUNDED: 1L DOOR SLIDE PARTS HANGING BETWEEN TRIM AND GIRT BAR. RESECURED VELCRO STRIP AS REQUIRED PER AMM 25-66-01.SDR AALA202308077234Unknown · unknownAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DURING CRUISE ENROUTE TO SDQ DUE TO #2 ENGINE N1 DROPPED TO 20 TO 40%. CREW SHUTDOWN #2 ENGINE AND LANDED SAFELY AT SDQ WITHOUT FURTHER INCIDENT. **SUPPLEMENTAL REPORT WILL BE SUBMITTED** (OPEN)SDR AALA202308075931Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT INDICATOR BULB IS OUT. RELAMPED EMERGENCY EXIT LIGHT INDICATOR LIGHT ASSY. PER AMM 33-18-00.SDR AALA202308076107Cover · out of adjustAIRCRAFT WAS NOT GROUNDED: SLIDE RAFT PACK AT DOOR 1R HAS SOMETHING HANGING OUT. ADJUSTED GIRT BAR SLIDE COVER.SDR AALA202308162198Seat Track · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN SEAT TRACK LOCATED AT BS 727B, LBL 25. REPAIRED SEAT TRACK PER SRM 51-10-02-5.SDR AALA202308143815Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN REAR SPAR LEFT HAND FRAME ASSEMBLY (PICKLE FORK) LOCATED AT BS 663, S17L. REPLACED FRAME ASSEMBLY PER EA 346632.SDR AALA202308144000Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN REAR SPAR RIGHT HAND FRAME ASSEMBLY (PICKLE FORK) LOCATED AT BS 663, S17R. REPLACED FRAME ASSEMBLY PER EA 346632.SDR AALA202308147821Seat Track · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN SEAT TRACK LOCATED AT BS 727B, RBL 48. REPLACED SEAT TRACK PER AARD 51-00-05-1.SDR AALA202308084972Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 147.0, 8 INCHES FORWARD OF AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202308087464Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT LEFT FLIGHT ATTENDANT FLASHLIGHT TEST RED. REMOVED AND REPLACED AFT LEFT FLIGHT ATTENDANT FLASHLIGHT BATTERY PER AMM 25-64-00.SDR AALA202308077932Screw · looseAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR DIFFICULT TO OPEN AND CLOSE INFLIGHT SEEMS TO STICK CLOSED NEAR LOWER AFT CORNER. TIGHTENED LOOSE SCREW ON LOWER DOOR TRIM.SDR AALA202308256803Stub Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD GALLEY DOOR STUB FRAME LOCATED AT BS 296, S8R. REPLACED STUB FRAME PER SRM 51-40-02, AARD 51-00-05-1 AND DWG 141A8370.DSDR AALA202308161276Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL LOCATED FROM BS 767 TO BS 787, RBL 24. REPLACED TRANSITION PANEL PER SRM 51-10-02-0G.SDR AALA202308169969Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL LOCATED FROM BS 767 TO BS 787, RBL 24. REPLACED TRANSITION PANEL PER SRM 51-10-02-0G.SDR AALA202308163403Seat Track · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN SEAT TRACK LOCATED AT BS 727B, RBL 25. REPLACED SEAT TRACK PER AARD 51-00-05-1,SDR AALA202308149564Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT BULKHEAD SUPPORT RAIL LOCATED AT BS 500I AND LBL 26. REPLACED SUPPORT RAIL PER AARD 51-00-05-1 AND SRM 51-40-02.SDR AALA202308105360Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO BAFFLE LOCATED FROM BS 500G TO BS 500H AT LBL 25. REPLACED BAFFLE PER SRM 51-40-02.SDR AALA202308100585Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO BAFFLE LOCATED FROM BS 500E TO BS 500F AT LBL 25. REPLACED BAFFLE PER AARD 51-00-05-1SDR AALA202308107829Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RUDDER SKIN LOCATED AT RUDDER STA 276.240. REPAIRED SKIN PER SRM 55-40-01-2R-2.SDR AALA202308049161Pump · leakingAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO MIA DUE TO HYDRAULIC QUANTITY LOSS. THE AIRCRAFT LANDED SAFELY AT MIA WITHOUT FURTHER INCIDENT. MAINTENANCE REPLACED ENGINE #1 HYDRAULIC PUMP PER AMM 29-11-11 (AALA202308049161). REPSDR AALA202308044396Pump · leakingAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO MIA DUE TO HYDRAULIC QUANTITY LOSS. THE AIRCRAFT LANDED SAFELY AT MIA WITHOUT FURTHER INCIDENT. MAINTENANCE REPLACED ENGINE #1 HYDRAULIC PUMP PER AMM 29-11-11 (AALA202308049161). REPSDR AALA202308049633Light · detachedAIRCRAFT WAS NOT GROUNDED: AFT SERVICE DOOR EMERGENCY EXIT SIGN FELL OFF. PLACED EMERGENCY EXIT SIGN IN PROPER LOCATION.SDR AALA202308043516Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR DIFFICULT TO OPEN FROM CABIN WITH ACCESS SYSTEM OFF. LUBRICATED FLIGHT DECK DOOR PER AMM 52-51-00.SDR AALA202308110823Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR SUPPORT STRUCTURE INTERCOSTAL LOCATED AT BS 293 AND LBL 11.5. REPLACED INTERCOSTAL PER AARD 51-00-05-1 R1.SDR AALA202308079406Spar · corrodedAIRCRAFT IN BASE MAINTENANCE CORROSION ON LEFT HAND HORIZONTAL STABILIZER TRAILING EDGE AFT SPAR LOWER CHORD (BEAM) FASTENER ON NUT PLATE HOLES BETWEEN STABILIZER STATIONS 57.99 AND 221.5. REPAIRED CHORD PER EA 344990.SDR AALA202308045035Shade · damagedAIRCRAFT WAS NOT GROUNDED: DAMAGED WINDOW SHADE AT EMERGENCY EXIT DOOR 16F (SEAT). REMOVED AND REPLACED EMERGENCY EXIT DOOR WINDOW SHADE ASSEMBLY FOR SEAT 16F PER 737 AMM 25-21-12SDR AALA202308046573Computer · inoperativeAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO DFW TO ELECTRIC STAB TRIM NOSE DOWN INOPERATIVE IMMEDIATELY AFTER TAKEOFF. AUTO-THROTTLE DID NOT RESPOND. NO CAUTIONS OR WARNINGS. AIRCRAFT LANDED SAFELY AT DFW WITHOUT FURTHER INCID
Back to Boeing 737-823