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 AALA202308157138Door Latch · stickingAIRCRAFT WAS NOT GROUNDED: AFT LAVATORY DOOR LATCH STICKING ON AIRCRAFT LEFT HAND SIDE. SECURED AFT LAVATORY DOOR LATCH ON AIRCRAFT LEFT HAND SIDE PER AMM 25-40-00.SDR AALA202308154600Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER CHORD LOCATED AT BS 947.5 FROM LBL 6.0 TO RBL 7.5. REPLACED CHORD PER SRM 53-70-51-2R-5 AND SRM 51-40-02-0G.SDR AALA202308145140Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 32.40. REPLACED SHEAR FITTING PER AARD 57-14-00-1 AND SRM 51-40-02.SDR AALA202308143595Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 15.04. REPLACED SHEAR FITTING PER AARD 57-14-00-1 AND SRM 51-40-02.SDR AALA202308144207Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 6.14. REPLACED SHEAR FITTING PER AARD 57-14-00-1 AND SRM 51-40-02.SDR AALA202308150761Latch · stuckAIRCRAFT WAS NOT GROUNDED: CAPTAIN L2 WINDOW WILL NOT FULLY OPEN. UNSTUCK HOLD OPEN LATCH ON CAPTAIN #2 SLIDING WINDOW PER AMM 56-11-00.SDR AALA202308149922Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 40.87. REPLACED SHEAR FITTING PER AARD 57-14-00-1 AND SRM 51-40-02.SDR AALA202308149971Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 6.14. REPLACED SHEAR FITTING PER AARD 57-14-00-1 AND SRM 51-40-02.SDR AALA202308141384Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 15.04. REPLACED SHEAR FITTING PER AARD 57-14-00-1 AND SRM 51-40-02.SDR AALA202308148801Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 32.40. REPLACED SHEAR FITTING PER AARD 57-14-00-1 AND SRM 51-40-02.SDR AALA202308148489Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 40.87. REPLACED SHEAR FITTING PER AARD 57-14-00-1 AND SRM 51-40-02.SDR AALA202308140207Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 54.60. REPLACED SHEAR FITTING PER AARD 57-14-00-1 AND SRM 51-40-02.SDR AALA202308146040Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 54.60. REPLACED SHEAR FITTING PER AARD 57-14-00-1 AND SRM 51-40-02.SDR AALA202308146823Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKE IN AFT CARGO COMPARTMENT INTERCOSTAL. LOCATED AT BS 947.5, S25R. REMOVED, FABRICATED, AND INSTALLED NEW INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202308147773Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 6.14. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202308141219Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 15.04. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202308144773Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 32.40. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202308143952Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 40.87. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202308140474Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 54.60. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202308147703Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 6.14. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202308145412Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 15.04. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202308142449Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 32.40. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202308140313Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 40.87. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202308143153Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 54.60. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202308145736Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR STICKS. LUBRICATED FORWARD LAVATORY DOOR.SDR AALA202308141941Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT AT FLIGHT ATTENDANT JUMPSEAT 4L INOPERATIVE. REMOVED AND REPLACED FLASHLIGHT ON FLIGHT ATTENDANT SEAT AT DOOR 4L.SDR AALA202308143754Drain Line · deterioratedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO LGA DUE LOUD SQUEAL FROM CAPTAINÏ¿½S #2 WINDOW. THE AIRCRAFT LANDED SAFELY AT LGA WITHOUT FURTHER INCIDENT. MAINTENANCE FOUND #2 WINDOW DRAIN TUBE DETERIORATED. REPAIRED DRAIN TUBE PSDR AALA202308143720Battery Pack · inoperativeAIRCRAFT WAS NOT GROUNDED: FORWARD FLIGHT ATTENDANT FLASHLIGHT #1 REQUIRE REPLACEMENT. REMOVED AND REPLACED BATTERY PACK.SDR AALA202308142268Battery Pack · inoperativeAIRCRAFT WAS NOT GROUNDED: FORWARD FLIGHT ATTENDANT FLASHLIGHT #2 REQUIRES REPLACEMENT. REMOVED AND REPLACED BATTERY PACK.SDR AALA202308143620Unknown · unknownAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED UPON ARIVAL INTO DFW DUE TO THE FLIGHT ATTENDANTS REPORTING A BURNING PLASTIC SMELL IN AFT GALLEY. THE AIRCRAFT LANDED SAFELY AT DFW WITHOUT FURTHER INCIDENT. MAINTENANCE ACCOMPLISHED THE SMOKE ODOR FUMES TROUBLSDR AALA202308113244Pressure Deck · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VERTICAL PRESSURE DECK WEB LOCATED AT BS 663 FROM RBL 40 TO RBL 45.64. REPAIRED PRESSURE DECK WEB PER SRM 57-10-10 REPAIR 3 ALTERNATIVE 2.SDR AALA202308111054Lamp · inoperativeAIRCRAFT IN BASE MAINTENANCE: SLIDE / EMERGENCY EXIT LIGHT L547 LOCATED ON LEFT SIDE OF FUSELAGE AFT OF WING IS INOPERATIVE. REPLACED LAMP AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-00.SDR AALA202308154399Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON VERTICAL STABILIZER RIGHT HAND FAILSAFE FITTING LOCATED AT BS 1088, S2R. REPLACED FITTING PER SRM 51-40-02.SDR AALA202308157476Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON VERTICAL STABILIZER RIGHT HAND AFT FAILSAFE FITTING LOCATED AT BS 1088, S2R. REPLACED FITTING PER SRM 51-40-02.SDR AALA202308150006Spar · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND STABILIZER REAR SPAR, AROUND FASTENER HOLES LOCATED FROM STAB STA 66.54 TO STAB STA 176.64. REPAIRED SPAR PER EA 344885.SDR AALA202308115556Hook · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD ENTRY DOOR GIRT BAR HOOK LOOSE. MAINTENANCE ADJUSTED THE GIRT BAR RETAINIER CLIP PER AMM 25-66-01 AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK.SDR AALA202308112457Stabilizer · warning lightAIRCRAFT WAS NOT GROUNDED: AN EMERGENCY WAS DECLARED INTO MIA DUE TO STABILIZER TRIM FAILURE WITH BOTH AUTPILOTS ON AND OFF. FLIGHT CREW ALSO REPORTED PERIODIC SPEED TRIM FAILURE LIGHT ILLUMINATED. THE AIRCRAFT LANDED SAFELY AT MIA WITHOUT FURTHER INCIDENT. MASDR AALA202308113804Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: THE EMERGENCY EXIT LIGHT NOT ARMED NEEDS TO BE RLELAMPED. MAINTENANCE REPLACED THE LAMP AS REQUIRED.SDR AALA202308116741Bulb · inoperativeAIRCRAFT WAS NOT GROUNDED: SEAT ROW 16 A/B/C EMERGENCY EXIT LIGHT HAS BULB OUT. MAINTENANCE REPLACED BULB PER AMM 33-51-01.SDR AALA202308113847Pressure Switch · faultedAIRCRAFT WAS NOT GROUNDED: AFTER TAKE OFF THE LEFT CENTER FUEL PUMP LOW PRESSURE LIGHT ILLUMINATED. MAINTENANCE REPLACED THE LEFT CENTER FUEL PUMP LOW PRESSURE SWITCH PER AMM 28-42-11 AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK.SDR AALA202308148727Bulb · burned outAIRCRAFT IN BASE MAINTENANCE: R2 DOOR EXTERIOR EMERGENCY SLIDE LIGHT BURNED OUT. MAINTENANCE FOUND BULB BURNED OUT AND CONNECTOR D11084 DISCONNECTED. REPLACED BULB (AALA202308148727) AND RECONNECTED CONNECTOR PER SWPM 20-61-28 (AALA202308142530). ACCOMPLISHED SDR AALA202308142530Connector · disconnectedAIRCRAFT IN BASE MAINTENANCE: R2 DOOR EXTERIOR EMERGENCY SLIDE LIGHT BURNED OUT. MAINTENANCE FOUND BULB BURNED OUT AND CONNECTOR D11084 DISCONNECTED. REPLACED BULB (AALA202308148727) AND RECONNECTED CONNECTOR PER SWPM 20-61-28 (AALA202308142530). ACCOMPLISHED SDR AALA202308146579Bulb · burned outAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND AFT EXTERIOR OVERWING SLIDE EMERGENCY EXIT LIGHT BULB BURNT OUT. REPLACED BULB AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-04-960-801.SDR AALA202308114884Floor Panel · damagedAIRCRAFT WAS GROUNDED: AISLE CABIN FLOOR PANEL BETWEEN SEAT ROWS 1 AND 2 VERY SOFT AND BOUNCY. MAINTENANCE REPAIRED FLOOR PANEL PER AARD 53-00-00-6.SDR AALA202308111895Latch · defectiveAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR LOCK OCCUPIED/ UNOCCUPIED SWITCH LOCK INTERMITTENTLY GETS STUCK IN LOCK POSITION. MAINTENANCE REPLACED THE LATCH PER AMM 25-40-11 AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK.SDR AALA202308119688Stop · out of positionAIRCRAFT WAS NOT GROUNDED: FORWARD ENTRY DOOR GIRT BAR SPRING BRACKETS DIFFICULT TO STOW BAR. MAINTENANCE FOUND THE PLASTIC STOP ON THE GIRT BAR OUT OF POSITION AND REPOSITIONED IT AS REQUIRED. A SATISFACTORY OPERATIONAL CHECK WAS ACCOMPLISHED.SDR AALA202308111516Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND WHEEL WEEL CENTER WING VAPOR BARRIER CRACKED. REPAIRED VAPOR BARRIER PER AARD 57-10-10-9 AND SRM 57-10-10-2R-2.SDR AALA202308110271Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT 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 AALA202308114359Windshield · crackedAIRCRAFT WAS GROUNDED: FLIGHT DECK L1 WINDSHIELD ARCED AND THEN THE OUTER PANE CRACKED. MAINTENANCE REPLACED THE WINDSHIELD PER TASK CARD 08L21056007.SDR AALA202308116993Stiffener · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER RIB'S FORWARD MOST STIFFENER, LOCATED AT STABILIZER STA 147.9, REPAIRED RIB PER SRM 55-10-09-2R.
Back to Boeing 737-823