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 AALA202305254470Link · damagedAIRCRAFT WAS GROUNDED: FORWARD ENTRY DOOR WON'T CLOSE. **SUPPLEMENTAL REPORT FOR AALA202305244470: REMOVED AND REPLACED DAMAGED UPPER (AALA202305244470) AND LOWER (AALA202305252208) RADIUS LINKS PER AMM 52-11-21.** (CLOSED)SDR AALA202305256691Light · inoperativeAIRCRAFT WAS NOT GROUNDED: LIGHT BULBS NEED REPLACING AT EMERGENCY EXIT LIGHT. RELAMPED EMERGENCY EXIT LIGHT.THIS SDR WAS SUBMITTED VIA EMAIL UNDER FAA OPERATOR CONTROL NUMBER: AALA202305246691SDR AALA202305244470Unknown · unknownAIRCRAFT WAS GROUNDED: FORWARD ENTRY DOOR WON'T CLOSE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202305230415Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE. CRACKS IN RIGHT HAND AIR CONDITIONING BAY, WING CENTER SECTION REAR SPAR VAPOR BARRIER LOCATED AT BS 663 AND RBL 32. REPAIRED VAPOR BARRIER PER AARD 57-10-10-9 REPAIR 9 AND SRM 57-10-10-2R-2 REPAIR 2.SDR AALA202305225294Girt Bar · will not armAIRCRAFT WAS NOT GROUNDED: FORWARD ENTRY CABIN DOOR SLIDE HAS TOO MUCH SLACK AND DIFFICULT TO ARM. ADJUSTED GIRT BAR SKIRT.SDR AALA202305229145Unknown · unknownAIRCRAFT WAS NOT GROUNDED: ROW 16 RIGHT HAND EMERGENCY EXIT WINDOW SHADE INOPERATIVE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202305225530Sensor · faultyAIRCRAFT WAS GROUNDED: FLAPS APPEAR TO BE STUCK AT 25. EMERGENCY DECLARED; FLIGHT LANDED SAFELY. AFTER LANDING RAISED FLAPS AND GAUGE REMAINED AT 25. PARKED AT THE GATE AND FLAPS APPEAR TO BE EXTENDED. REPLACED LEFT WING FLAP SKEW SENSOR #1 PER AMM 27-59-01-40SDR AALA202305196864Door Seal · out of adjustAIRCRAFT WAS NOT GROUNDED: FIRST CLASS LAVATORY DOOR STICKS, HARD TO OPEN. ADJUSTED LOWER DOOR SEAL ON DOOR THAT WAS STICKING, PER CMM 2-45-46.SDR AALA202305199006Door · out of adjustAIRCRAFT WAS NOT GROUNDED. AFT LEFT LAVATORY DOOR OFF TRACK. READJUSTED AFT LEFT LAVATORY DOOR. CHECKS GOOD PER CMM 25-40-64.SDR AALA202305190273Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: L2 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOPERATIVE. RELAMPED L2 DOOR EXTERIOR EMERGENCY EXIT LIGHT.SDR AALA202305194306Pin · unserviceableAIRCRAFT WAS GROUNDED: L1 ENTRY DOOR VERY DIFFICULT TO OPEN. REMOVED AND REPLACED PIN ON UPPER RADIUS LINK OF L1 DOOR GUIDE ARM PER AMM 52-11-21.SDR AALA202305197168Pressure Deck · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VERTICAL PRESSURE DECK WEB AT MAIN LANDING GEAR WHEEL WELL LOCATED AT BS 663.75 BETWEEN LBL 31.83 AND LBL 40.00. REPAIRED PRESSURE DECK WEB PER SRM 57-10-10-2R PROCEDURE 3 REPAIR 3.SDR AALA202305228330Guide Arm · faultedAIRCRAFT WAS GROUNDED: LEFT FORWARD ENTRY DOOR HANDLE MOVES UP IN FLIGHT. MOVED UP 3 INCHES AFTER LANDING. REMOVED AND REPLACED UPPER GUIDE ARM.SDR AALA202305191321Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY D DOOR LATCH HARD TO OPEN. ADJUSTED LAVATORY D DOOR PER AMM 25-40-14.SDR AALA202305198985Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER TRAILING EDGE LOWER SKIN LOCATED FROM STAB STA 120.30 TO STAB STA 129.50. REPAIRED SKIN PER SRM 55-10-01-2R-11 REPAIR 11 AND DWG 182A4001.SDR AALA202305196651Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STAB STA 101.90. REPAIRED SKIN PER SRM 55-10-01-2R-11 REPAIR 11 AND DWG 182A4001.SDR AALA202305193617Window · scratchedAIRCRAFT WAS GROUNDED: R3 COCKPIT WINDOW HAS MANY SCRATCHES DIFFICULT VIEW WITH SUNLIGHT SCATTERING. REMOVED AND REPLACED R3 COCKPIT WINDOW PER AMM 56-11-21.SDR AALA202305195875Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN Z ANGLE LOCATED AT BS 990 AND FROM RBL 34 TO RBL 47. REPLACED Z ANGLE PER SRM 51-10-02-0G.SDR AALA202305184382Shade · inoperativeAIRCRAFT WAS NOT GROUNDED: SEAT 16A WINDOW SHADE, EXIT ROW WILL NOT RETRACT. REMOVED AND REPLACED SEAT 16A WINDOW SHADE IN ACCORDANCE WITH AMM 25-21-12. CHECKS GOOD.SDR AALA202305175865Power Supply · no testAIRCRAFT IN BASE MAINTENANCE: LEFT HAND AFT OVERWING EXIT EMERGENCY LIGHT DID NOT ILLUMINATE DURING TEST. REPLACED EMERGENCY LIGHTING BATTERY PACK POWER SUPPLY M1670 PER JOB CARD 08C20033004.SDR AALA202305178509Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR NOT ABLE TO FUNCTION NORMALLY. ADJUSTED AFT LEFT LAVATORY DOOR IN ACCORDANCE WITH AMM 25-40-14. OPERATION CHECKS GOOD, OK FOR SERVICE.SDR AALA202305175828Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD ENTRY DOOR AFT GRIT BAR ATTACH FLOOR FITTING (TIEDOWN) LOCATED FROM BS 328 TO BS 344 AT LBL 45. REPLACED TIEDOWN PER SRM 51-40-02-0G.SDR AALA202305173652Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT LEFT HAND BAFFLE LOCATED FROM BS 500C TO BS 500D AT S25L. REPLACED BAFFLE PER AARD 53-00-01-06 AND SRM 51-40-02.SDR AALA202305316243Tie Down · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L1 DOOR AFT GIRT BAR FITTING MOUNT (TIEDOWN) LOCATED AT BS 340 AND LBL 60. REPLACED TIEDOWN PER SRM 51-10-02-0G.SDR AALA202305173003Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 120.30, 9 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202305173842Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 129.50, 10 INCHES FROM FORWARD SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202305170904Housing · out of positionAIRCRAFT WAS NOT GROUNDER: SEAT 19C EMERGENCY ESCAPE PATH LIGHT FELL DOWN. REPLACED LIGHT HOUSING PER CMM 25-23-67. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202305178328Support Angle · gougedAIRCRAFT IN BASE MAINTENANCE: GOUGE IN FORWARD CARGO COMPARTMENT FLOOR STRUCTURE SUPPORT ANGLE LOCATED AT BS 480 AND LBL 2.5. REPAIRED ANGLE PER SRM-53-00-53-1A-2.SDR AALA202305175735Fitting · 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 AALA202305179165Fitting · 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 AALA202305176148Fitting · 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 AALA202305174844Fitting · 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 AALA202305171331Fitting · 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 AALA202305177516Fitting · 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 AALA202305179724Fitting · 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 AALA202305170765Fitting · 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 AALA202305175604Battery Pack · no testAIRCRAFT IN BASE MAINTENANCE: LEFT HAND OVERWING EMERGENCY BATTERY FAILS CAPACITY CHECK. REPLACED EMERGENCY LIGHT POWER SUPPLY M1694 BATTERY PACK PER AMM 33-51-06-960-805.SDR AALA202305172022Fitting · 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 AALA202305174279Fitting · 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 AALA202305165481Module · faultyAIRCRAFT WAS GROUNDED: AFTER TAKEOFF WE HAD AN UNSAFE LANDING GEAR INDICATION WITH ALL THREE GEAR INDICATIONS RED. PERFORMED A LIGHTS TEST AND THE NOSE GEAR GREEN LIGHT WAS INOPERATIVE. EMERGENCY DECLARED; FLIGHT RETURNED TO DFW LANDING SAFELY. MAINTENANCE REPSDR AALA202305161114Sliding Window · lack of lubeAIRCRAFT WAS NOT GROUNDED: CAPTAIN'S WINDOW DIFFICULT TO UNLOCK AND LOCK, HANDLE IS DIFFICULT TO UNLATCH. CLEANED AND LUBRICATED CAPTAIN'S WINDOW TRACK. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202305154727Gust Lock · lack of lubeAIRCRAFT WAS NOT GROUNDED: L1 DOOR GUST LOCK DIFFICULT TO UNLOCK. REMOVED DEBRIS AND LUBRICATED L1 DOOR GUST LOCK PER AMM 52-11-00. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202305169725Controller · unserviceableAIRCRAFT WAS GROUNDED: WHILE CLIMBING TO FL360 CABIN ALTITUDE / DIFFERENTIAL PRESSURE PASSING 32000 WAS 8.95 PSI AND CABIN ALTITUDE WAS 3900 FEET. REQUESTED DESCENT AND LOST PRESSURIZATION RAPIDLY UPON COMMENCING DESCENT. EMERGENCY DECLARED; FIGHT RETURNED TO SDR AALA202305161692Controller · unserviceableAIRCRAFT WAS GROUNDED: WHILE CLIMBING TO FL360 CABIN ALTITUDE /DIFFERENTIAL PRESSURE PASSING 32000 WAS 8.95 PSI AND CABIN ALTITUDE WAS 3900 FEET. REQUESTED DESCENT AND LOST PRESSURIZATION RAPIDLY UPON COMMENCING DESCENT. EMERGENCY DECLARED; FIGHT RETURNED TO MSDR AALA202305162546Relief Valve · unserviceableAIRCRAFT WAS GROUNDED: WHILE CLIMBING TO FL360 CABIN ALTITUDE /DIFFERENTIAL PRESSURE PASSING 32000 WAS 8.95 PSI AND CABIN ALTITUDE WAS 3900 FEET. REQUESTED DESCENT AND LOST PRESSURIZATION RAPIDLY UPON COMMENCING DESCENT. EMERGENCY DECLARED; FIGHT RETURNED TO MSDR AALA202305163620Relief Valve · unserviceableAIRCRAFT WAS GROUNDED: WHILE CLIMBING TO FL360 CABIN ALTITUDE /DIFFERENTIAL PRESSURE PASSING 32000 WAS 8.95 PSI AND CABIN ALTITUDE WAS 3900 FEET. REQUESTED DESCENT AND LOST PRESSURIZATION RAPIDLY UPON COMMENCING DESCENT. EMERGENCY DECLARED; FIGHT RETURNED TO MSDR AALA202305169498Wire · brokenAIRCRAFT WAS GROUNDED: WHILE CLIMBING TO FL360 CABIN ALTITUDE / DIFFERENTIAL PRESSURE PASSING 32000 WAS 8.95 PSI AND CABIN ALTITUDE WAS 3900 FEET. REQUESTED DESCENT AND LOST PRESSURIZATION RAPIDLY UPON COMMENCING DESCENT. EMERGENCY DECLARED; FIGHT RETURNED TO SDR AALA202305162596Regulator Valve · unserviceableAIRCRAFT WAS GROUNDED: WHILE CLIMBING TO FL360 CABIN ALTITUDE /DIFFERENTIAL PRESSURE PASSING 32000 WAS 8.95 PSI AND CABIN ALTITUDE WAS 3900 FEET. REQUESTED DESCENT AND LOST PRESSURIZATION RAPIDLY UPON COMMENCING DESCENT. EMERGENCY DECLARED; FIGHT RETURNED TO MSDR AALA202305167395Outflow Valve · unserviceableAIRCRAFT WAS GROUNDED: WHILE CLIMBING TO FL360 CABIN ALTITUDE /DIFFERENTIAL PRESSURE PASSING 32000 WAS 8.95 PSI AND CABIN ALTITUDE WAS 3900 FEET. REQUESTED DESCENT AND LOST PRESSURIZATION RAPIDLY UPON COMMENCING DESCENT. EMERGENCY DECLARED; FIGHT RETURNED TO MSDR AALA202305163225Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT FLASHLIGHT INBOARD ON L1 FLIGHT ATTENDANT SEAT TEST RED LED. REMOVE AND REPLACED FLASHLIGHT BATTERY (AALA202305153225) AND BRACKET (AALA202305152308) ON FLIGHT ATTENDANT SEAT ON L1 DOOR INBOARD, OPERATION OK. ALL DON
Back to Boeing 737-823