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 AALA202302075740Mount · corrodedAIRCRAFT IN BASE MAINTENANCE: L1 DOOR AFT GIRT BAR MOUNT HAS CORROSION LOCATED AT STA 344 AND LEFT BUTT LINE 61. REMOVED AND REPLACED MOUNT PER SRM.SDR AALA202302075114Not Reported · corrodedAIRCRAFT IN BASE MAINTENANCE: FORWARD WET AREA R1 DOOR CUT-OUT INNER CHORD HAS CORROSION. LOCATED AT STA 328. REMOVED AND REPLACED CHORD PER SRM.SDR AALA202302077022Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FORWARD CARGO COMPARTMENT FLOOR STRUCTURE RIGHT SIDE TRANSITION PANEL SECTION BETWEEN STA 492 TO STA 500A AND STR 26R. REMOVED AND REPLACED TRANSITION PANEL PER SRM.SDR AALA202302079872Not Reported · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L2 DOOR MOP SILL (INNER CHORD) LOCATED FROM BS 951 TO BS 990 AT LBL 50. REPLACED CHORD PER SRM 51-40-02-0G.SDR AALA202302078574Not Reported · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON R2 DOOR MOP SILL (INNER CHORD) LOCATED FROM BS 951 TO BS 990 AT RBL 50. REPLACED CHORD PER SRM 51-40-02-0G.SDR AALA202302079261Support Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR SUPPORT ANGLE LOCATED AT BS 992 FROM LBL 40 TO LBL 50. REPLACED SUPPORT ANGLE PER SRM 51-40-02-0G.SDR AALA202302075046Support Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR SUPPORT ANGLE LOCATED AT BS 992 AND RBL 46. REPLACED SUPPORT ANGLE PER SRM 51-40-02-0G.SDR AALA202302061127Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L1 DOOR CUT-OUT LOWER SCUFF PLATE ANGLE LOCATED FROM BS 312 TO BS 328 AT LBL 61. REPLACED ANGLE PER SRM 51-40-02.SDR AALA202302201395Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL SHIELD LOCATED FROM BS 767 TO BS 787 AT S25R. REPLACED SHIELD PER SRM 51-40-02.SDR AALA202302075216Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED:: 1L DOOR SLIDE DIFFICULT TO ARM. LUBRICATED IL DOOR SLIDE LATCHES.SDR AALA202302072203Guide Arm · stickingAIRCRAFT WAS NOT GROUNDED: L1 DOOR HARD TO CLOSE FROM THE INSIDE. OPERATIONS CHECKS OK FROM THE OUTSIDE HANDLE. FOUND GUIDE ARM OUT OF ADJUSTMENT. ADJUSTED GUIDE ARM AND STOP PINS PER AMM 52-11-00.SDR AALA202302203041Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED FROM BS 500A TO BS 500H AT S25R. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R.SDR AALA202302208791Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 500E + 10 INCHES TO BS 500I AT LBL 0. REPLACED TRANSITION PANEL PER SRM 51-40-02 AND SRM 53-00-53-2R-6.SDR AALA202302082730Light · inoperativeAIRCRAFT WAS NOT GROUNDED: AISLE OVERHEAD EMERGENCY EXIT LIGHT AT BIN 12DEF IS INOPERATIVE. **SUPPLEMENTAL REPORT FOR AALA202302062730: REPLACED EMERGENCY AISLE LIGHT PER AMM 33-51-03. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.** (CLOSED)SDR AALA202302069101Light · detachedAIRCRAFT WAS NOT GROUNDED: ESCAPE PATH LIGHTING HOUSING DETACHED FROM SEAT 21A. REMOVED AND REPLACED SEAT 21A ESCAPE PATH LIGHT CLOSEOUTSDR AALA202302060565Bracket · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD ENTRY DOOR GIRT BAR FALLING OUT OF RETAINER BRACKET. ADJUSTED FORWARD ENTRY DOOR GIRT BAR RETAINER BRACKET.SDR AALA202302061515Detector · false activationAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY SMOKE DETECTOR ALARM SOUNDING OFF. REMOVED AND REPLACED FORWARD LAVATORY SMOKE DETECTOR.SDR AALA202302062730Not Reported · not reportedAIRCRAFT WAS NOT GROUNDED: AISLE OVERHEAD EMERGENCY EXIT LIGHT AT BIN 12DEF IS INOPERATIVE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202304048699Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED AT BS 500A AND RBL 26. REPLACED TRANSITION PANEL PER SRM 51-40-02-0G.SDR AALA202304040911Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT FLOOR STRUCTURE RIGHT HAND INTERCOSTAL LOCATED FROM BS 500A TO BS 500B AT S25R. REPLACED INTERCOSTAL PER 51-40-02-0G.SDR AALA202302208528Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PREVIOUS REPAIR ANGLE OF KEEL BEAM AREA WING TO BODY AFT FAIRING FRAME LOCATED AT BS 727 AND BL 0. PREVIOUS REPAIR ANGLE #2 REMOVED AND FRAME REPAIRED PER EA 341801 AND SRM 51-40-02.SDR AALA202302205228Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PREVIOUS REPAIR ANGLE OF KEEL BEAM AREA WING TO BODY AFT FAIRING FRAME LOCATED AT BS 727 AND BL 0. PREVIOUS REPAIR ANGLE #3 REMOVED AND REPAIRED FRAME PER EA 341801 AND SRM 51-40-02.SDR AALA202302204860Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PREVIOUS REPAIR ANGLE OF KEEL BEAM AREA WING TO BODY AFT FAIRING FRAME LOCATED AT BS 727 AND BL 0. PREVIOUS REPAIR ANGLE #1 REMOVED AND FRAME REPAIRED PER EA 341801 AND SRM 51-40-02.SDR AALA202302176548Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT FLOOR STRUCTURE LEFT HAND TRANSITION PANEL LOCATED FROM BS 493 TO BS 500I AT LBL 26. REPLACED TRANSITION PANEL PER SRM 51-40-02-0G.SDR AALA202302102463Support Angle · crackedAIRCRAFT IN BASE MAINTENANCE: SUPPORT ANGLE CRACKED 2 INCHES OUTBOARD OF KEEL BEAM AT STA 663.5 AND RIGHT SIDE. REMOVED AND REPLACED SUPPORT ANGLE PER SRM.SDR AALA202302076750Shear Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN SHEAR WEB LOCATED FROM BS 986 TO BS 992 AND FROM LBL 40 TO LBL 50. REPLACED SHEAR WEB PER SRM 51-40-02.SDR AALA202302061483Light · brokenAIRCRAFT WAS NOT GROUNDED: EXIT SIGN ABOVE FORWARD RIGHT ENTRY DOOR BROKEN. REMOVED AND REPLACED EXIT SIGN LIGHT ASSEMBLY ABOVE RIGHT FORWARD ENTRY DOOR.SDR AALA202302067330Washer · missingAIRCRAFT WAS NOT GROUNDED: DURING POST FLIGHT GUST LOCK ON L1 DOOR DIFFICULT TO USE. **SUPPLEMENTAL REPORT FOR AALA202302037330: MAINTENANCE FOUND LOCK WASHER AND SCREW MISSING FROM UPPER HINGE PIN. INSTALLED NEW WASHER (AALA202302037330), SCREW (AALA202302063SDR AALA202302063852Screw · missingAIRCRAFT WAS NOT GROUNDED: DURING POST FLIGHT GUST LOCK ON L1 DOOR DIFFICULT TO USE. **SUPPLEMENTAL REPORT FOR AALA202302037330: MAINTENANCE FOUND LOCK WASHER AND SCREW MISSING FROM UPPER HINGE PIN. INSTALLED NEW WASHER (AALA202302037330), SCREW (AALA202302063SDR AALA202302062221Hinge Pin · unserviceableAIRCRAFT WAS NOT GROUNDED: DURING POST FLIGHT GUST LOCK ON L1 DOOR DIFFICULT TO USE. **SUPPLEMENTAL REPORT FOR AALA202302037330: MAINTENANCE FOUND LOCK WASHER AND SCREW MISSING FROM UPPER HINGE PIN. INSTALLED NEW WASHER (AALA202302037330), SCREW (AALA202302063SDR AALA202302031649Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT LEFT JUMP SEAT FLASHLIGHT IS INOPERATIVE. REMOVED AND REPLACED AFT LEFT JUMP SEAT FLASHLIGHT BATTERY PER AMM 25-60-00. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202302037330Not Entered · not enteredAIRCRAFT WAS NOT GROUNDED: DURING POST FLIGHT GUST LOCK ON L1 DOOR DIFFICULT TO USE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202302106466Bracket · crackedAIRCRAFT IN BASE MAINTENANCE: SUPPORT ANGLE CRACKED 6 INCHES OF LEFT BUTT LINE 41 AT STA 663.5. REMOVED AND REPLACED SUPPORT ANGLE PER SRM.SDR AALA202302107564Support Angle · crackedAIRCRAFT IN BASE MAINTENANCE: SUPPORT ANGLE CRACKED 2 INCHES OUTBOARD OF KEEL BEAM AT STATION 663.5 AT LEFT BUTT LINE 16. REMOVED AND REPLACED SUPPORT ANGLE PER SRM.SDR AALA202302035547Light · brokenAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT BROKEN AT SEAT 30ABC. REMOVED AND REPLACED EMERGENCY LIGHT AT SEAT 30ABC PER AMM 33-51-11.SDR AALA202304040920Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AROUND FASTENER HOLES IN FORWARD CARGO COMPARTMENT FLOOR STRUCTURE LEFT HAND INTERCOSTAL LOCATED FROM BS 500E TO BS 500F ABOVE S26L. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202302074371Not Reported · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LOWER FUSELAGE WING TO BODY FAIRING ACCESS PANEL 193AR (RIGHT HAND WHEEL WELL PANEL Ï¿½ FORWARD OUTBOARD) SUPPORT T CHORD LOCATED AT BS 683 AND RBL 20. REPLACED T CHORD PER SRM 53-40-71-1A-1 TABLE 112 ITEM 12 (4).SDR AALA202302072286Support Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR SUPPORT ANGLE LOCATED AT BS 540 AND LBL 1. REPLACED SUPPORT ANGLE PER SRM 51-40-02-0G.SDR AALA202302074096Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT FLOOR STRUCTURE LEFT HAND INTERCOSTAL LOCATED FROM BS 500D TO BS 500E AT S26L. REPAIRED PER DWG 143A7505-62.SDR AALA202302068942Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN INTERCOSTAL LOCATED AT BS 1030, FROM LBL 2 TO LBL 9. REPLACED INTERCOSTAL PER AARD 20-00-00-1 PROCEDURE REPAIR 1 AND SRM 51-40-05.SDR AALA202302069929Intercostal · elongatedAIRCRAFT IN BASE MAINTENANCE: ELONGATED HOLES IN INTERCOSTAL LOCATED AT BS 1030 FROM BL 0 TO RBL 9. REPLACED INTERCOSTAL PER AARD 20-00-00-1 PROCEDURE 1 AND SRM 51-40-05-0G.SDR AALA202302021255Battery Pack · dischargedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING POWER SUPPLY M02335 BATTERY PACK IS DISCHARGED. REPLACED BATTERY PACK PER AMM 33-51-06. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202302029738Battery Pack · dischargedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING POWER SUPPLY M01670 BATTERY PACK IS DISCHARGED. REPLACED BATTERY PACK PER AMM 33-51-06. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202302024814Battery Pack · dischargedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING POWER SUPPLY M02816 BATTERY PACK IS DISCHARGED. REPLACED BATTERY PACK PER AMM 33-51-06. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202302025632Battery Pack · dischargedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING POWER SUPPLY M01675 BATTERY PACK IS DISCHARGED. REPLACED BATTERY PACK PER AMM 33-51-06. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202302021142Battery Pack · dischargedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING POWER SUPPLY M01673 BATTERY PACK IS DISCHARGED. REPLACED BATTERY PACK PER AMM 33-51-06. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202302027933Battery Pack · dischargedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING POWER SUPPLY M01672 BATTERY PACK IS DISCHARGED. REPLACED BATTERY PACK PER AMM 33-51-06. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202302027716Battery Pack · dischargedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING POWER SUPPLY M01695 BATTERY PACK IS DISCHARGED. REPLACED BATTERY PACK PER AMM 33-51-06. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202302024670Battery Pack · dischargedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING POWER SUPPLY M01694 BATTERY PACK IS DISCHARGED. REPLACED BATTERY PACK PER AMM 33-51-06. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202302024678Battery Pack · dischargedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING POWER SUPPLY M01676 BATTERY PACK IS DISCHARGED. REPLACED BATTERY PACK PER AMM 33-51-06. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.
Back to Boeing 737-823