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 AALA202301170655Light · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT ON SEAT 33C IS HANGING DOWN ON FLOOR. RE-SECURED LIGHT PER AMM 33-51-11. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202301246315Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN CABIN FLOOR BEAM T-CAP, LOCATED AT BS 947.5 AND FROM LBL 16 TO RBL 16. SPLICE REPAIRED FLOOR BEAM T-CAP PER EA 340706 AND SRM 53-70-51-2R-5.SDR AALA202301191060Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT LEFT HAND BAFFLE LOCATED FROM BS 400 TO BS 460 AT S25L. REPLACED BAFFLE PER DWG 143A7505, AARD 51-00-05-1, AND SRM 51-40-02.SDR AALA202301171323Fitting · corrodedAIRCRAFT WAS GROUNDED (LONG TERM STORAGE): LH UPPER KICK FITTING HAS CORROSION LOCATED AT STA 663 AND STR 18A REMOVED AND REPLACED KICK FITTING PER AARD.SDR AALA202301176798Fitting · crackedAIRCRAFT WAS GROUNDED (LONG TERM STORAGE: DURING INSPECTION OF THE RH STA 663.7 FAIL SAFE STRAP, FOUND A CRACK INDICATION AT EH UPPER AFT FASTENER HOLE HIDDEN BEHIND THE STR 18A STRAP. REMOVED AND REPLACED RH STA 663 PICKLE FORK FITTING.SDR AALA202301172726Fitting · crackedAIRCRAFT WAS GROUNDED (LONG TERM STORAGE): DURING INSPECTION OF THE LH STA 663.7 FAIL SAFE STRAP FOUND A CRACK INDICATION AT UPPER FASTENER BEHIND THE STR 18A STRAP. REMOVED AND REPLACED LH STA 663 PICKLE FORK FITTING DUE TO A CRACK INDICATION.SDR AALA202301176470Window · scratchedAIRCRAFT WAS GROUNDED: FLIGHT DECK L3 (AFT LEFT SIDE) WINDOW OPAQUE/DIRTY/SCRATCHED CANNOT SEE LEFT WINGTIP TO ENSURE TAXI CLEARANCE. REMOVED AND REPLACED NUMBER 3 WINDOW.SDR AALA202301177017Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR WEB LOCATED AT BS 986.5 AND LBL 44.5. REPLACED WEB PER SRM 53-70-51-1A PROCEDURE 1.SDR AALA202301170396Door Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR DOES NOT LATCH WHEN PUSHED FROM OUTSIDE COCKPIT. DIFFICULT TO CLOSE. CLEANED AND LUBED FLIGHT DECK DOOR LATCH. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202301176527Lamp · inoperativeAIRCRAFT IN BASE MAINTENANCE: EMERGENCY EXIT LIGHT ON EXTERIOR AT RIGHT HAND AFT OVERWING EXIT INOPERATIVE. REPLACED LIGHT INSULATOR PER SRM 51-40-02 (AALA202301178807). REPLACED LAMP (AALA202301176527) AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK PER AMM 3SDR AALA202301178807Insulator · inoperativeAIRCRAFT IN BASE MAINTENANCE: EMERGENCY EXIT LIGHT ON EXTERIOR AT RIGHT HAND AFT OVERWING EXIT INOPERATIVE. REPLACED LIGHT INSULATOR PER SRM 51-40-02 (AALA202301178807). REPLACED LAMP (AALA202301176527) AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK PER AMM 3SDR AALA202301177491Slide · dislodgedAIRCRAFT WAS GROUNDED: CATERING ATTEMPTED TO OPEN L2 DOOR WITH THE SLIDE ARMED. SLIDE IS HANGING FROM THE BUSTLE AND DID NOT DEPLOY. REPLACED SLIDE PER JOB CARD 08L22125001.SDR AALA202304183490Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR Z ANGLE LOCATED AT BS 998.8 AND LBL 40. REPLACED Z ANGLE PER SRM 51-10-02-0G. **SUPPLEMENTAL REPORT FOR AALA202301183490: ENGINEERING REVIEWED THIS EVENT AND DETERMINED THE CORRECT LEVEL WAS LEVESDR AALA202301256546Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT FLOOR SUPPORT INTERCOSTAL LOCATED AT BS 500A AND S26L. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202301196582Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT LEFT HAND BAFFLE LOCATED FROM BS 460 TO BS 480 AT LBL 23. REPLACED BAFFLE PER DWG 143A7505, AARD 51-00-05-1, AND SRM 51-40-02.SDR AALA202301192140Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT LEFT HAND BAFFLE LOCATED FROM BS 500G TO BS 500H AT S25L. REPLACED BAFFLE PER DWG 143A7510, AARD 51-00-05, SRM 51-40-02, AND SRM 53-00-01-6.SDR AALA202301183490Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR Z ANGLE LOCATED AT BS 998.8 AND LBL 40. REPLACED Z ANGLE PER SRM 51-10-02-0G.SDR AALA202301172409Intercostal · elongatedAIRCRAFT IN BASE MAINTENANCE: ELONGATED HOLE IN INTERCOSTAL LOCATED AT BS 986.5 AND RBL 32. REPAIRED INTERCOSTAL PER SRM 51-20-10-0G AND EA 341339.SDR AALA202301170925Module · inoperativeAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR SECURITY AUTO LOCK SYSTEM INOPERATIVE. REPLACED FLIGHT DECK DOOR ACCESS SYSTEM MODULE ASSEMBLY PER AMM 52-51-06. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202302218600Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN CABIN WALL SUPPORT LOCATED FROM BS 986 TO BS 1016 AT RBL 32. REPLACED SUPPORT PER SRM 51-40-02-0G AND AARD 51-00-05-1.SDR AALA202301257123Cusp Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND CUSP WEB AFT OF R2 DOOR, LOCATED FROM BS 992 TO BS 1006 AT RBL 48. REPLACED WEB PER SRM 51-40-02-0G AND, DWG 147A8501.SDR AALA202301170626Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR HARD TO OPEN AND CLOSE. ADJUSTED DOOR PER AMM 25-42-26 AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202301139418Antenna · faultedAIRCRAFT WAS NOT GROUNDED: AIRCRAFT MASTER CAUTION ILLUMINATED - INERTIAL REFERENCE SYSTEM GPS LIGHT ILLUMINATED ON OVERHEAD PANEL. FLIGHT MANAGEMENT COMPUTER SCRATCH PAD DISPLAY INVALID L - GPS AND INVALID R- GPS. FLIGHT DIVERTED TO MEM. REMOVED AND REPLACED SDR AALA202301130343Antenna · faultedAIRCRAFT WAS NOT GROUNDED: AIRCRAFT MASTER CAUTION ILLUMINATED - INERTIAL REFERENCE SYSTEM GPS LIGHT ILLUMINATED ON OVERHEAD PANEL. FLIGHT MANAGEMENT COMPUTER SCRATCH PAD DISPLAY INVALID L - GPS AND INVALID R- GPS. FLIGHT DIVERTED TO MEM. REMOVED AND REPLACED SDR AALA202301120626Door · stiffAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR HARD TO OPEN AND CLOSE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202301121559Door Latch · out of adjustAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR DIFFICULT TO LATCH CLOSED. ADJUSTED DOOR LATCH AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK PER AMM 52-51-00.SDR AALA202304185838Support Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT AFT BULKHEAD SUPPORT ANGLE LOCATED AT BS 500H FROM S25L TO S26R. REPLACED SUPPORT ANGLE PER SRM 51-40-02-0G. **SUPPLEMENTAL REPORT FOR AALA202301185838: ENGINEERING REVIEWED THIS EVENT AND DESDR AALA202301250616Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN INTERCOSTAL UNDER FLOORBOARD, LOCATED FROM BS 380 Ï¿½ BS 400 AT BL 0. REPLACED INTERCOSTAL PER AARD 51-00-05-01.SDR AALA202301185838Support Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT AFT BULKHEAD SUPPORT ANGLE LOCATED AT BS 500H FROM S25L TO S26R. REPLACED SUPPORT ANGLE PER SRM 51-40-02-0G.SDR AALA202301181209Stringer Clip · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN STRINGER CLIP LOCATED AT BS 500C AND S22R. REPLACED STRINGER CLIP PER SRM 51-40-02 AND DWG 143A1224.SDR AALA202301117623Door · out of adjustAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY ENTRY DOOR DIFFICULT TO OPEN AND CLOSE. ADJUSTED LEFT AFT LAVATORY DOOR OPERATIONS CHECK GOOD.SDR AALA202301111883Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR DIFFICULT TO OPEN / CLOSE. LUBED DOOR. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202301198940Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT LEFT HAND BAFFLE LOCATED FROM BS 400 TO BS 460, WL 58, LBL 28. REPLACED BAFFLE PER AARD 51-00-05-1, DWG 143A7505, AND SRM 51-40-02.SDR AALA202301189285Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN CABIN Z ANGLE LOCATED AT BS 992.8 FROM RBL 37 TO RBL 42. REPLACED Z ANGLE PER DWG 147A5700.SDR AALA202301185639Structure · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN CABIN R2 DOOR LOWER THRESHOLD SILL INNER CHORD LOCATED FROM BS 967 TO BS 992.8 AT RBL 65. REPLACED INNER CHORD PER DWG 197A8501.SDR AALA202301105197Retainer · looseAIRCRAFT WAS NOT GROUNDED: RIGHT SLIDE GIRT BAR CLIP IS LOOSE ON FORWARD ENTRY DOOR. TIGHTENED RIGHT SLIDE GIRT BAR CLIP AT L1 DOOR.SDR AALA202301105465Screw · looseAIRCRAFT WAS NOT GROUNDED: BIFOLD DOOR ON LAVATORY D AFT LEFT VERY DIFFICULT TO OPEN AND CLOSE. FOUND DOOR THRESHOLD SCREWS LOOSE AND DOOR HAD DIFFICULTY SLIDING ACROSS THRESHOLD DURING OPEN AND CLOSE. SECURED SCREWS AND CLEANED STICKY SUBSTANCE OFF THRESHOLD.SDR AALA202301102875Door Latch · out of adjustAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR DIFFICULT TO OPEN AND CLOSE. ADJUSTED AFT LEFT LAVATORY DOOR LOCK PER CMM 25-40-64. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202301107414Light · faultyAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT ABOVE SEAT 17F ILLUMINATED ON CLIMB OUT AND REMAINS ILLUMINATED. REPLACED SEAT 17F OVER WING EXIT LIGHT ASSEMBLY PER AMM 33-21-00. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202304053023Control Valve · faultyAIRCRAFT WAS GROUNDED: FLAPS SELECTED DOWN AND NO MOVEMENT NOTED. DECLARED AN EMERGENCY AND DIVERTED TO CLT. PERFORMED FLAPS UP LANDING. AIRCRAFT WAS NOT OVERWEIGHT FOR LANDING. **SUPPLEMENTAL REPORT FOR AALA202301113023: REMOVED AND REPLACED TRAILING EDGE FLASDR AALA202301185219Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT LEFT HAND BAFFLE LOCATED FROM BS 500A TO BS 500B, S26L, AND WL 152. REPLACED BAFFLE PER AARD 51-00-05.SDR AALA202301113023Flap System · faultedAIRCRAFT WAS GROUNDED: FLAPS SELECTED DOWN AND NO MOVEMENT NOTED. DECLARED AN EMERGENCY AND DIVERTED TO CLT. PERFORMED FLAPS UP LANDING. AIRCRAFT WAS NOT OVERWEIGHT FOR LANDING. OPEN.SDR AALA202301105923Retainer · out of adjustAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS GIRT BAR ON SERVICE DOOR IS DIFFICULT TO STOW AND UNSTOW. ADJUSTED RETAINER CLIPS IAW AMM 25-61-01.SDR AALA202301106540Slide · frayedAIRCRAFT IN BASE MAINTENANCE: R1 DOOR SLIDE GIRT BAR SKIRT IS FRAYED. REPLACED SLIDE.SDR AALA202301100522Skirt · tornAIRCRAFT IN BASE MAINTENANCE: L1 DOOR SLIDE GIRT BAR SKIRT IS TORN. REPLACED SLIDE.SDR AALA202301095031Girt Bar · wornAIRCRAFT IN BASE MAINTENANCE: L1 ENTRY DOOR SLIDE PACK GIRT ASSEMBLY WORN. REPLACED SLIDE PER JOB CARD 08L22125001.SDR AALA202301095581Girt Bar · wornAIRCRAFT IN BASE MAINTENANCE: L2 ENTRY DOOR SLIDE PACK GIRT ASSEMBLY WORN. REPLACED SLIDE PER JOB CARD 08L22125001.SDR AALA202301097603Girt Bar · wornAIRCRAFT IN BASE MAINTENANCE: R1 SERVICE DOOR SLIDE PACK GIRT ASSEMBLY WORN. REPLACED SLIDE PER JOB CARD 08L22125001.SDR AALA202301185674Intercostal · elongatedAIRCRAFT IN BASE MAINTENANCE: ELONGATED HOLES IN MAIN CABIN INTERCOSTAL LOCATED AT BS 986.5 AND LBL 32. REPLACED INTERCOSTAL PER SRM 53-70-51-2R-4 AND DWG 147A5700.SDR AALA202301120363Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: AFT PRESSURE BULKHEAD LOWER INTERCOSTAL ATTACHMENT AT STA 1016 AND APPROXIMATELY RIGHT BUTT LINE 9 TO RIGHT BUTT LINE 3 CORRODED. REMOVED AND REPLACED INTERCOSTAL PER SRM.
Back to Boeing 737-823