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 AALA202310271411Girt Bar · damagedAIRCRAFT WAS GROUNDED: RIGHT AFT SERVICE DOOR SLIDE RED HEAT SHRINK MATERIAL MISSING FROM FORWARD END OF GIRT BAR.**SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202310274010Girt Bar · damagedAIRCRAFT WAS GROUNDED: AFT SERVICE DOOR GIRT BAR MISSING WHITE PLASTIC STOP PIECE. INSTALLED WHITE PLASTIC STOP ON GIRT BAR.SDR AALA202310271044Flashlight · no testAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT 1L DOOR BLINKING RED ON PREFLIGHT. REMOVED & REPLACED L1 DOOR FLASHLIGHT.SDR AALA202310274196Unknown · unknownAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO FUEL IMBALANCE, IMBALANCE WARNING ANNUNCIATED FOR LEFT TANK. FUEL DROPPING RAPIDLY AIRCRAFT APPROACHING TRIM LIMITS AIRCRAFT LANDED SAFELY AT LAX WITHOUT FURTHER INCIDENT.**SUPPLEMENTAL REPORT WILL BE SUSDR AALA202311068091Bracket · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT HAND WING LEADING EDGE OUTBOARD FIXED LOWER ACCESS PANEL BRACKET AT SS 308. REPLACED BRACKET PER SRM 51-40-02SDR AALA202310314523Tube · missingAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS AFT LEFT HAND GALLEY DOOR SLIDE GIRT BAR MISSING RED TUBE.**SUPPLEMENTAL REPORT FOR AALA202310264523: INSTALLED NEW SHRINK WRAP ON AFT LEFT HAND GALLEY DOOR GIRT BAR. PER JOB CARD 2523J012-001.**(CLOSED)SDR AALA202310318918Sign · unsecureAIRCRAFT WAS NOT GROUNDED: "EXIT" SIGN ON L4 DOOR WILL NOT STAY SECURED IN PLACE.**SUPPLEMENTAL REPORT FOR AALA202310268918: REMOVED AND REPLACED EXIT SIGN. PER AMM 33-51-01. FUNCTIONAL CHECK GOOD.**(CLOSED)SDR AALA202310312914Sign · missingAIRCRAFT WAS NOT GROUNDED: OVERWING RIGHT EXIT SIGN MISSING AT BASE OF DOOR.**SUPPLEMENTAL REPORT FOR (AALA202310262914): REMOVE AND REPLACED RIGHT HAND OVERWING EMERGENCY EXIT SIGN. PER AMM 33-51-01. FUNCTIONAL CHECK GOOD.**(CLOSED).SDR AALA202310313883Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 111.10, 10 INCHES AFT OF FORWARD SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202310268918Unknown · unknownAIRCRAFT WAS NOT GROUNDED: "EXIT" SIGN ON L4 DOOR WILL NOT STAY SECURED IN PLACE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED** (OPEN).SDR AALA202310262914Unknown · unknownAIRCRAFT WAS NOT GROUNDED: OVERWING RIGHT EXIT SIGN MISSING AT BASE OF DOOR.**SUPPLEMENTAL REPORT WILL BE SUBMITTED** (OPEN).SDR AALA202310264523Unknown · unknownAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS AFT LEFT HAND GALLEY DOOR SLIDE GIRT BAR MISSING RED TUBE.**SUPPLEMENTAL REPORT WILL BE SUBMITTED** (OPEN).SDR AALA202311024229Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION IN AFT WET AREA INTERCOASTAL LOCATED BETWEEN STA 951 AND 967 AT RBL 48. REPLACED AFT WET AREA INTERCOASTAL PER SRM 51-40-02.SDR AALA202310312788Lug · missingAIRCRAFT IN BASE MAINTENANCE: PASSENGER CABIN SEAT TRACK AT STA 727G, LBL 46 MISSING LUG. REPAIRED SEAT TRACK PER SRM 52-00-52-2R-5 AND EA 348902.SDR AALA202310258826Door · out of adjustAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY STICKS WHEN OPENING AND CLOSING. ADJUSTED AFT LEFT LAVATORY DOOR. FUNCTIONAL CHECK GOOD. PER CMM 25-40-64.SDR AALA202310254964Light · inoperativeAIRCRAFT WAS NOT GROUNDED: LOWER EMERGENCY EXIT LIGHT INOPERATIVE AT SEAT ROW 17ABC. REPLACED LIGHT ASSEMBLY. FUNCTIONAL CHECK GOOD. PER AMM 33-51-01.SDR AALA202310316482Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER RIB, AT STABILIZER STA 130.1. REPAIRED RIB PER SRM 55-10-09-2R.SDR AALA202310319299Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER RIB, AT STABILIZER STA 130.1. REPAIRED RIB PER SRM 55-10-09.SDR AALA202310265330Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: FORWARD DOOR FLASHLIGHT CHARGING PORT IS INOPERATIVE. **SUPPLEMENTAL REPORT FOR (AALA202310245330): REMOVE AND REPLACED FLASHLIGHT. FUNCTIONAL CHECK GOOD. PER AMM 25-60-00.**(CLOSED).SDR AALA202310245330Unknown · inoperativeAIRCRAFT WAS NOT GROUNDED: FORWARD DOOR FLASHLIGHT CHARGING PORT IS INOPERATIVE. Ï¿½ **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202310248917Unknown · unknownAIRCRAFT WAS GROUNDED: AFT LAVATORY D DOOR STICKING AND DIFFICULT TO OPEN. NO FAULT FOUND, DOOR OPERATES NORMALLY.SDR AALA202311022596Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON UPPER CHORD OF FLOOR BEAM LOCATED AT BS 947.5, RBL 48. REPLACED T-CHORD PER SRM 53-70-51-2R-5.SDR AALA202310314367Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER ATTACH ANGLE AT STA 663, LBL 3. REPLACED ANGLE PER SRM 57-10-10-2R-5.SDR AALA202310316992Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER ATTACH ANGLE AT STA 663, RBL 3. REPLACED ANGLE PER SRM 57-10-10-2R-5.SDR AALA202310269714Housing · brokenAIRCRAFT WAS NOT GROUNDED: 26C SEAT EMERGENCY LIGHT BROKEN.**SUPPLEMENTAL REPORT FOR (AALA202310239714): REPLACED EMERGENCY LIGHT BRACKET ASSEMBLY. PER CMM 25-23-67.**(CLOSED).SDR AALA202310241569Door · fodAIRCRAFT WAS NOT GROUNDED: LAVATORY D DOOR JAMS SHUT, WILL NOT OPEN WITHOUT HEAVY FORCED APPLIED. **SUPPLEMENTAL REPORT FOR AALA202310231569: REMOVED DEBRIS FROM SILL PLATE AT LAVATORY D DOOR. PER AMM 38-10-00.** (CLOSED)SDR AALA202310239714Unknown · unknownAIRCRAFT WAS NOT GROUNDED: 26C SEAT EMERGENCY LIGHT BROKEN. **SUPPLEMENTAL REPORT WILL BE SUBMITTED** (OPEN).SDR AALA202310236695Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT LEFT HAND LAVATORY DOOR HARD TO OPEN AND CLOSE. ACCOMPLISHED AFT LEFT LAVATORY DOOR HINGE LUBRICATION. FUNCTIONAL CHECK GOOD. PER AFMM 20-14-1.SDR AALA202310231569Unknown · unknownAIRCRAFT WAS NOT GROUNDED: LAVATORY D DOOR JAMS SHUT, WILL NOT OPEN WITHOUT HEAVY FORCED APPLIED. **SUPPLEMENTAL REPORT WILL BE SUBMITTED** (OPEN).SDR AALA202310244976O-Ring · leakingAIRCRAFT WAS GROUNDED: EMERGENCY DECLARED ON APPROACH TO STI DUE TO HYDRAULIC SYSTEM B LOW PRESSURE LIGHT. AIRCRAFT LANDED SAFELY AT STI WITHOUT FURTHER INCIDENT. MAINTENANCE REPLACED O-RING RIGHTHAND NUMBER 8 SPOLIER ACTUATOR FILTER CAP PER CMM 27-60-42.SDR AALA202310230670Door Seal · distortedAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR DIFFICULT TO OPEN AND CLOSE. CHECKED AND TRIM OVERLAPPING RUBBER DOOR SEAL AT UPPER CORNER, FUNCTIONAL CHECK NORMAL. PER 25-47-63.SDR AALA202310234553Light · brokenAIRCRAFT WAS GROUNDED: SEAT 13 ABC EMERGENCY LIGHT BROKEN. REMOVE AND REPLACED EMERGENCY LIGHT RETAINER ASSEMBLY AT 13 ABC. FUNCTIONAL CHECK GOOD. PER WDM 33-51-22.SDR AALA202310233308Hinge · lack of lubeAIRCRAFT WAS NOT GROUNDED: LAVATORY D DOOR HARD TO OPEN AND CLOSE. ACCOMPLISH LAVATORY D DOOR HINGE LUBRICATION. PER AFMM 20-14-1.SDR AALA202310236208Hinge Pin · migratedAIRCRAFT WAS GROUNDED: L1 DOOR WILL NOT OPEN. REMOVED AND INSTALLED NEW UPPER HINGE ARM PIN PER AARD 52-10-00-4.SDR AALA202311060790Fitting · noneAIRCRAFT IN BASE MAINTENANCE: CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 54.60 REPLACEMENT REQUIRED PER BOEING SERVICE BULLETIN B737-57-1309. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202311060458Fitting · noneAIRCRAFT IN BASE MAINTENANCE: CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 40.87 REPLACEMENT REQUIRED PER BOEING SERVICE BULLETIN B737-57-1309. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202311062184Fitting · noneAIRCRAFT IN BASE MAINTENANCE: CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 32.40 REPLACEMENT REQUIRED PER BOEING SERVICE BULLETIN B737-57-1309. REPLACED SHEAR FITTING PER AARD 57-14-00 REPAIR 1.SDR AALA202311065555Fitting · noneAIRCRAFT IN BASE MAINTENANCE: CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 15.04 REPLACEMENT REQUIRED PER BOEING SERVICE BULLETIN B737-57-1309. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202311068570Fitting · noneAIRCRAFT IN BASE MAINTENANCE: CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 6.14 REPLACEMENT REQUIRED PER BOEING SERVICE BULLETIN B737-57-1309. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202311069965Fitting · noneAIRCRAFT IN BASE MAINTENANCE: CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 6.14 REPLACEMENT REQUIRED PER BOEING SERVICE BULLETIN B737-57-1309. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202311067069Fitting · noneAIRCRAFT IN BASE MAINTENANCE: CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 15.04 REPLACEMENT REQUIRED PER BOEING SERVICE BULLETIN B737-57-1309. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202311067792Fitting · noneAIRCRAFT IN BASE MAINTENANCE: CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 32.40 REPLACEMENT REQUIRED PER BOEING SERVICE BULLETIN B737-57-1309. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202311068953Fitting · noneAIRCRAFT IN BASE MAINTENANCE: CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 40.87 REPLACEMENT REQUIRED PER BOEING SERVICE BULLETIN B737-57-1309. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202311069215Fitting · noneAIRCRAFT IN BASE MAINTENANCE: CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 54.60 REPLACEMENT REQUIRED PER BOEING SERVICE BULLETIN B737-57-1309. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202310276655Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN AT RIB 101.7 AND 20.5 INCHES FORWARD OF THE REAR SPAR. REPAIRED RIGHT HAND HORIZONTAL STABILIZER SKIN PER SRM 55-10-01-2R-11.SDR AALA202310274905Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN AT RIB 101.7 AND 2.5 INCHES FORWARD OF THE REAR SPAR. REPAIRED RIGHT HAND HORIZONTAL STABILIZER SKIN PER SRM 55-10-01-2R-11.SDR AALA202310272883Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN AT RIB 101.7 AND 11 INCHES FORWARD OF THE REAR SPAR. REPAIRED RIGHT HAND HORIZONTAL STABILIZER SKIN PER SRM 55-10-01-2R-11.SDR AALA202310270862Skin · crackedAIRCRAFT IN BASE MAINTENANCE: TAIL CRACK LOWER SKIN OF RIGHT HAND HORIZONTAL STABILIZER AT RIB STA 141.5 AND 18 INCHES FORWARD OF THE REAR SPAR. REPAIRED RIGHT HAND HORIZONTAL STABILIZER SKIN. PER SRM 55-10-01-2R-11.SDR AALA202310276396Skin · crackedAIRCRAFT IN BASE MAINTENANCE: TAIL CRACK LOWER SKIN OF RIGHT HAND HORIZONTAL STABILIZER AT RIB STA 141.5 AND 10 INCHES FORWARD OF THE REAR SPAR. REPAIRED RIGHT HAND HORIZONTAL STABILIZER SKIN. PER SRM 55-10-01-2R-11.SDR AALA202310266531Connector · faultyAIRCRAFT WAS NOT GROUNDED: RIGHT AFT FUEL TANK PUMP WILL NOT SHUT OFF. REPLACED CONNECTOR (AALA202310266531) AND SOCKETS (AALA202310269505) ON D872, RIGHT AFT FUEL PUMP PRESSURE SWITCH. PER SWPM 20-61-11 AND WDM 28-43-11. OPERATIONAL CHECK PASSED.
Back to Boeing 737-823