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 AALA202305016094Retainer · looseAIRCRAFT WAS NOT GROUNDED: 1L DOOR GIRT BAR RETAINER CLIP IS LOOSE.**SUPPLEMENTAL REPORT FOR AALA202304246094: REMOVED AND REPLACED 1L GIRT BAR RETAINERS PER AMM 25-66-01.** (CLOSED)SDR AALA202304263357Engine · stalledAIRCRAFT WAS GROUNDED: NUMBER 2 ENGINE BIRD STRIKE COMPRESSOR STALL/SURGE ENGINE SHUTDOWN. EMERGENCY WAS DECLARED AND AIRCRAFT RETURNED TO CMH. REPLACED NUMBER 2 ENGINESDR AALA202304253458Fitting · 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 AALA202304255425Fitting · 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 AALA202304256510Fitting · 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 AALA202304241416Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: PASSENGER AFT CABIN MEGAPHONE OVER SEAT 36 D.E.F DID NOT TEST PROPERLY. REPLACED BATTERIES OPERATION CHECKS NORMAL. OK FOR SERVICE.SDR AALA202304240278Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT FLIGHT ATTENDANT JUMPSEAT EMERGENCY FLASHLIGHT INOPERATIVE. REPLACED AFT JUMPSEAT EMERGENCY FLASHLIGHT BATTERIES.SDR AALA202304246094Unknown · unknownAIRCRAFT WAS NOT GROUNDED: L1 DOOR GIRT BAR RETAINER CLIP IS LOOSE.**SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202308292772Window · delaminatedAIRCRAFT WAS NOT GROUNDED: SMALL AREAS OF DELAMINATION VISIBLE AROUND EDGES OF FIRST OFFICER'S FORWARD R1 WINDOW. **SUPPLEMENTAL REPORT FOR AALA202304242772: REPLACED WINDOW PER JOB CARD 0921056004.** (CLOSED)SDR AALA202305091318Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FOUND ON RIGHT AFT CARGO SHIELD LOCATED BETWEEN 767 TO 787 AND STR 25R.SDR AALA202305054097Frame · corrodedAIRCRAFT IN BASE MAINTENANCE: CORRODED FRAME LOCATED BETWEEN 312 AND 325, AND STR 23L. REPAIRED FRAME WITH REINFORCEMENT PER EA.SDR AALA202304250021Lock · inoperativeAIRCRAFT WAS GROUNDED: THE LEFT AFT ENTRY DOOR HAS A GUST LOCK THAT IS INOPERABLE AND HAS PARTS MISSING. REMOVED AND REPLACED LOCK ASSEMBLY ON L2 DOOR.SDR AALA202304258842Receiver · out of adjustAIRCRAFT WAS GROUNDED: GATE AGENT REPORTS L1 ENTRY DOOR DIFFICULT TO OPEN FROM OUTSIDE. L1 DOOR OPENED BY AIRCRAFT MAINTENANCE. ADJUSTED UPPER AFT LATCH RECEIVER AND PERFORMED DOOR HANDLE TORQUE TEST IAW AMM 52-11-00. CLEARANCES AND TORQUE WITHIN LIMITS.SDR AALA202304245332Handle · looseAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR HANDLE LOOSE AND HARD TO OPEN AND CLOSE DOOR. TIGHTENED LAVATORY DOOR HANDLE.SDR AALA202304249435Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: FOUND FORWARD RIGHT FLIGHT ATTENDANT FLASHLIGHT BATTERY BAD. REPLACED THE FLASHLIGHT BATTERY.SDR AALA202304240206Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT AT L1 DOOR INOPERATIVE. REPLACED FLASHLIGHT AT L1 DOOR.SDR AALA202304240009Spring · brokenAIRCRAFT WAS GROUNDED: UPON ARRIVAL THE GATE AGENT NOTED THE 1L DOOR HANDLE WAS NOT FLUSH AND THE HANDLE WAS LOOSE AND TURNING VERY EASY. MAINTENANCE FOUND DOOR HANDLE BOX ASSEMBLY SPRING BROKEN. REPLACED SPRING.SDR AALA202304242772Unknown · unknownAIRCRAFT WAS NOT GROUNDED: SMALL AREAS OF DELAMINATION VISIBLE AROUND EDGES OF FIRST OFFICER'S FORWARD R1 WINDOW. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202305010125Transmitter · inoperativeAIRCRAFT WAS NOT GROUNDED: FLAPS DID NOT EXTEND NORMALLY WITH HANDLE. USED ALTERNATE FLAPS SWITCH TO EXTEND FLAPS TO 15 DEGREES. NO ASYMMETRY NOTICED AT ANY TIME. FLAPS AND SLATS EXTENDED NORMALLY WITH ALTERNATE FLAP SWITCH. AIRCRAFT DECLARED AN EMERGENCY LANDSDR AALA202304249103Plate · out of positionAIRCRAFT WAS NOT GROUNDED: NUMBER 1 LAVATORY DOOR DIFFICULT TO OPEN. ADJUSTED LOWER SILL PLATE.SDR AALA202304243164Sign · missingAIRCRAFT WAS NOT GROUNDED: ROW 16 F EMERGENCY EXIT SIGN CORN MISSING. REMOVED AND REPLACED EMERGENCY EXIT SIGN.SDR AALA202304244323Control Panel · unknownAIRCRAFT WAS GROUNDED: ENGINE/APU FIRE CONTROL PANEL SHOWS SIGNS OF WATER CONTAMINATION. ENGINE AND APU FIRE CONTROL PANEL SYSTEMSDR AALA202304245344Panel · damagedAIRCRAFT WAS GROUNDED: CARGO FIRE DETECTION PANEL SHOWS SIGNS OF WATER CONTAMINATION. REMOVED AND REPLACED THE CARGO FIRE DETECTION PANEL IAW AMM 26-00-02.SDR AALA202304246973Unknown · out of adjustAIRCRAFT WAS NOT GROUNDED: R1 SERVICE DOOR GIRT BAR RETAINING CLIP WHEN DISARMED LOOSE. ADJUSTED GIRT BAR RETAINING CLIP PER AMM 25-61-00.SDR AALA202304248644Unknown · out of adjustAIRCRAFT WAS NOT GROUNDED: R1 DOOR GIRT BAR RETAINER CLIP NEEDS ADJUSTMENT. ADJUSTED GIRT BAR RETAINER CLIP PER AMM 25-66-01. OPERATIONAL CHECK GOOD.SDR AALA202304249178Control Rod · out of adjustAIRCRAFT WAS GROUNDED: GATE AGENT AND FLIGHT ATTENDANTS REPORT MAIN CABIN DOOR DIFFICULT TO CLOSE. ADJUSTED L1 DOOR HORIZONTAL CONTROL ROD PER AMM 52-11-00-820-801 SUBTASK 820-016.SDR AALA202304260078Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER INSPAR RIB LOCATED AT STABILIZER STA 92.70. REPAIRED RIB PER SRM 55-10-09-2R PROCEDURE 4 REPAIR 4.SDR AALA202304262928Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER INSPAR RIB 2 LOCATED AT STABILIZER STA 92.70. REPAIRED RIB PER SRM 55-10-09-2R PROCEDURE 4 REPAIR 4.SDR AALA202304261306Line · leakingAIRCRAFT WAS GROUNDED: MILD/MODERATE TRANSIENT DIRTY SOCK SMELL AFTER TAKEOFF IN FRONT HALF OF AIRPLANE. DISSIPATED AFTER 2-3 MINUTES. DID NOT RE-OCCUR IN FLIGHT. REOCCURRED ON TAXI-IN. **SUPPLEMENTAL REPORT FOR AALA202304211306: MAINTENANCE FOUND APU TO BE SOSDR AALA202304217993Threshold · misalignedAIRCRAFT IN BASE MAINTENANCE: FORWARD LAVATORY DOOR BOTTOM THRESHOLD STICKS WHEN CLIMBING THROUGH 22,000 AND MARKED ON THRESHOLD. REMOVED AND REINSTALL FORWARD LAVATORY DOOR BOTTOM THRESHHOLD.SDR AALA202304211306Unknown · unknownAIRCRAFT WAS GROUNDED: MILD/MODERATE TRANSIENT DIRTY SOCK SMELL AFTER TAKEOFF IN FRONT HALF OF AIRPLANE. DISSIPATED AFTER 2-3 MINUTES. DID NOT RE-OCCUR IN FLIGHT. REOCCURRED ON TAXI-IN. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202304212857Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: BOTH LEFT OVERWING EMERGENCY LIGHTS ARE INOPERATIVE. **SUPPLEMENTAL REPORT FOR AALA202304202841: REPLACED LEFT HAND EMERGENCY LIGHT POWER SUPPLY ASSEMBLY PER AMM 33-51-06 (AALA202304202841). REPLACED LEFT HAND OVERWING EMERGENCY LIGHSDR AALA202304212841Power Supply · inoperativeAIRCRAFT WAS NOT GROUNDED: BOTH LEFT OVERWING EMERGENCY LIGHTS ARE INOPERATIVE. **SUPPLEMENTAL REPORT FOR AALA202304202841: REPLACED LEFT HAND EMERGENCY LIGHT POWER SUPPLY ASSEMBLY PER AMM 33-51-06 (AALA202304202841). REPLACED LEFT HAND OVERWING EMERGENCY LIGHSDR AALA202304202841Unknown · unknownAIRCRAFT WAS NOT GROUNDED: BOTH LEFT OVERWING EMERGENCY LIGHTS ARE INOPERATIVE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202305097564Angle · crackedAIRCRAFT IN BASE MAINTENANCE: ANGLE CRACKED AT STA 663 AND LEFT BUTT LINE 16. REMOVED AND REPLACED ANGLE AND SPLICE REPAIR PER SRM.SDR AALA202305092762Angle · crackedAIRCRAFT WAS GROUNDED: ANGLE CRACKED AT STA 663 AND RIGHT BUTT LINE 16. INSTALLED A REPAIR ANGLE AND SPLICE PER SRM.SDR AALA202305052608Skin · crackedAIRCRAFT IN BASE MAINTENANCE: EXTERNAL POWER RECEPTACLE INTERNAL DOOR FRAME IS CRACKED / MISSING MATERIAL. LOCATED BETWEEN 235.8 AND 243.7 AND STR 21R AND 22R. INSTALLED DOUBLER REPAIR PER SRM.SDR AALA202304262926Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER RIB LOCATED AT STABILIZER STA 101.90. SECOND STIFFENER FROM FRONT SPAR ON RIB IS CRACKED. REPAIRED RIB PER SRM 55-10-09-2R PROCEDURE 5 REPAIR 5.SDR AALA202304212499Handle · damagedAIRCRAFT WAS NOT GROUNDED: CABIN ENTRY DOOR ASSIST HANDLE DAMAGED 1R. REPLACED 1R CABIN ENTRY DOOR ASSIST HANDLE.SDR AALA202304210462Window · crackedAIRCRAFT WAS GROUNDED: FIRST OFFICER WINDSHIELD HAS CRACK ABOUT AN INCH AND A HALF IN LENGTH. HORIZONTAL LOWER CENTER. CRACK IN WINDSHIELD. REMOVED AND REPLACED FIRST OFFICER COCKPIT WINDOW.SDR AALA202304219738Sensor · out of positionAIRCRAFT WAS NOT GROUNDED: ON DESCENT AT 10,000 FT FORWARD ENTRY DOOR ILLUMINATED. ADDED SHIMS AT FORWARD L 1 DOOR SENSOR.SDR AALA202304204338Power Supply · inoperativeAIRCRAFT WAS GROUNDED: R1 AND R2 DOORS OUTSIDE EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHT POWER SUPPLY FOR R1 & R2 OUTSIDE EMERGENCY LIGHTS PER AMM 33-51-06.SDR AALA202304208086Unknown · unsecureAIRCRAFT WAS NOT GROUNDED: L1 GIRT BAR CLIP LOOSE ON LEFT SIDE. ADJUSTED AND SECURED L1 GIRT BAR PER AMM 25-66-01.SDR AALA202304263036Window Shade · faultedAIRCRAFT WAS NOT GROUNDED: THE WINDOW SHADE AT EXIT ROW SEAT 17A WON'T OPEN ALL THE WAY. **SUPPLEMENTAL REPORT FOR AALA202304193036: REMOVED AND REPLACED WINDOW SHADE AT EXIT ROW SEAT 17A PER AMM 25-21-12.** (CLOSED)SDR AALA202304198674Door Latch · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY D DOOR LATCH DIFFICULT TO OPERATE. ADJUSTED LAVATORY D DOOR LATCHSDR AALA202304193651Door Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR IS DIFFICULT TO CLOSE AND STAY CLOSED. LUBED DOOR LATCHSDR AALA202304195306Smoke Detector · false activationAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY SMOKE DETECTOR ALERTED. NO SMOKE CONFIRMED. REPLACED THE AFT LAVATORY SMOKE DETECTOR.SDR AALA202304199967Door · out of adjustAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR HARD TO OPEN AND CLOSE. AFT LEFT LAVATORY D ENTRY DOOR ADJUSTED AND LUBRICATED OPS CHECKED GOOD IN ACCORDANCE WITH AMM 25-40-64.SDR AALA202304192638Bracket · out of adjustAIRCRAFT WAS NOT GROUNDED: AFT LEFT DOOR SLIDE DIFFICULT TO ARM GIRT BAR. ADJUSTED SLIDE HANDLE CLIPS OPERATION CHECKS NORMAL PER AMM 25-66-01. OK FOR SERVICE.SDR AALA202304193036Unknown · unknownAIRCRAFT WAS NOT GROUNDED: THE WINDOW SHADE AT EXIT ROW SEAT 17A WON'T OPEN ALL THE WAY. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)
Back to Boeing 737-823