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 AALA202405091969Slide · failedAIRCRAFT WAS GROUNDED: FORWARD SERVICE DOOR EMERGENCY SLIDE WAS NOT DISARMED DOOR WAS OPEN, SLIDE FELL OUT BUT FAILED TO DEPLOY. REMOVE AND REPLACED R1 (FORWARD SERVICE DOOR) DOOR EMERGENCY ESCAPE SLIDE. PER J/C 08L22125001SDR AALA202405082133Slide · faultyAIRCRAFT WAS NOT GROUNDED: DURING INSPECTION DISCOVERED NEW SLIDE IS BAD; REJECTED THE NEW SLIDE ASSEMBLY FOR BEING BAD FROM STOCK. REINSTALLED ORIGINAL EMERGENCY ESCAPE SLIDE ASSEMBLY. OPERTIONAL CHECK GOOD. PER J/C 08L22125001.SDR AALA202405081969Slide · dislodgedAIRCRAFT WAS GROUNDED: FORWARD SERVICE DOOR EMERGENCY SLIDE WAS NOT DISARMED DOOR WAS OPEN, SLIDE FELL OUT BUT FAILED TO DEPLOY.**SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202405086662Sign · unsecureAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT SIGN BY ROW 16 FELL DOWN. REINSTALLED AND SECURED EMERGENCY EXIT SIGN AT ROW 16. PER AMM 25-63-00.SDR AALA202405088153Cam · out of adjustAIRCRAFT WAS NOT GROUNDED: GIRT BAR FRONT EXIT, STOW SPRING IS NOT HOLDING THE BAR SECURELY. ADJUSTED L1 GIRT BAR RETENTION SPRING CLIP. FUNCATIONAL CHECK GOOD. PER AMM 25-66-01.SDR AALA202405084920Cam · inoperativeAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS THAT THE RIGHT SIDE OF THE GIRT BAR IS VERY DIFFICULT TO PLACE IN THE FLOOR BRACKET DUE TO THE SPRING CLIP NOT WORKING PROPERLY LOCATED AT DOOR 1L. REPLACED SPRING ON FORWARD FLOOR BRACKET FOR L1 DOOR AND OPESDR AALA202405087911Skin · crackedAIRCRAFT IN BASE MAINTENANCE: 2 CRACKS IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 157.10, 8 INCHES AND 16 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202405087910Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 92.70, 9 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202405088469Skin · crackedAIRCRAFT IN BASE MAINTENANCE: 2 CRACKS IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 101.90, 9 INCHES AND 18 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202405081159Skin · crackedAIRCRAFT IN BASE MAINTENANCE: 2 CRACKS IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 138.70, 9 INCHES AND 17 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202406219077Skin · bulgedAIRCRAFT IN BASE MAINTENANCE: BULGE IN FUSELAGE SKIN ABOVE AFT CARGO DOOR AT STA 767, S14R. REPAIRED SKIN PER SRM 51-10-02 AND EA 353874.SDR AALA202405217315Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM STA 328 TO STA 348, LBL 45. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202405212811Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM STA 312 TO STA 328, LBL 45. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202405203564Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT FLOOR STRUCTURE TRANSITION PANEL AT STA 412, S25L. REPLACED TRANSITION PANEL PER AARD 53-00-05.SDR AALA202405145166Selector Valve · faultyAIRCRAFT WAS GROUNDED: UPON LOWERING LANDING GEAR, GOT THREE GREEN LIGHTS AND THREE RED LIGHTS (ON FWD INSTRUMENT PANEL), (ALL SIX LIGHTS ILLUMINATED), OVERHEAD PANEL SHOWED THREE GREEN LIGHTS. REPLACEMENT OF LANDING GEAR SELECTOR VALVE (AALA202405075166), PSDR AALA202405147919Push-Pull Cable · faultedAIRCRAFT WAS GROUNDED: UPON LOWERING LANDING GEAR, GOT THREE GREEN LIGHTS AND THREE RED LIGHTS (ON FWD INSTRUMENT PANEL), (ALL SIX LIGHTS ILLUMINATED), OVERHEAD PANEL SHOWED THREE GREEN LIGHTS. REPLACEMENT OF LANDING GEAR SELECTOR VALVE (AALA202405075166), PSDR AALA202405144604Gearbox · faultyAIRCRAFT WAS GROUNDED: UPON LOWERING LANDING GEAR, GOT THREE GREEN LIGHTS AND THREE RED LIGHTS (ON FWD INSTRUMENT PANEL), (ALL SIX LIGHTS ILLUMINATED), OVERHEAD PANEL SHOWED THREE GREEN LIGHTS. REPLACEMENT OF LANDING GEAR SELECTOR VALVE (AALA202405075166), PESDR AALA202405076175Light · dislodgedAIRCRAFT WAS NOT GROUNDED: EMERGENCY ESCAPE PATH SEAT MOUNTED LIGHTING SYSTEM AT ROW 33C IS DISCONNECTED AND ON THE FLOOR. REPLACED SEAT 33C SEAT MOUNTED HOUSING. OPERTIONAL CHECK OF EMERGENCY LIGHT NORMAL. PER AMM 33-51-11.SDR AALA202405071504Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR STICKS AND IS DIFFICULT TO OPEN AND CLOSE. GETTING STUCK AT THE BOTTOM AFT CORNER OF THE DOOR. CLEANED AND LUBRICATE FORWARD LAVATORY DOOR FRAME AND LOCK, OPERTIONAL CHECK GOOD. PER AMM 25-40-11.SDR AALA202405075166Indication Sys · malfunctionedAIRCRAFT WAS GROUNDED: UPON LOWERING LANDING GEAR, GOT THREE GREEN LIGHTS AND THREE RED LIGHTS (ON FWD INSTMENT PANEL). (ALL SIX LIGHTS ILLUMINATED). OVERHEAD PANEL SHOWED THREE GREEN LIGHTS. (OPEN).SDR AALA202405076636Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT SLIDE EMERGENCY LIGHT INOPERATIVE. RELAMPED LIGHT. PER AMM 33-51-04.SDR AALA202405072412Skin · crackedAIRCRAFT IN BASE MAINTENANCE: 2 CRACKS IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 129.50, 9 INCHES AND 17 INCHES FROM FRONT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202405070722Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 101.90, 18 INCHES FROM FRONT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202406103911Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L2 DOOR ENTRY AREA SILL INNER CHORD (CREASE ANGLE) FROM STA 981 TO STA 974, LBL 48. REPLACED INNER CHORD PER AARD 51-00-05-1.SDR AALA202405073169Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: LEFT EXTERIOR FORWARD SLIDE OVERWING EMERGENCY LIGHT INOPERATIVE. **SUPPLEMENTAL REPORT FOR (AALA202405063169): RE-LAMPED. PER AMM 33-51-04, OPERTIONAL CHECK GOOD**(CLOSED).SDR AALA202405074376Sliding Window · leakingAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: R2 WINDOW SEAL LEAKING ABOVE 11000 FT LOUD SQUEALING SOUND; AIRCRAFT RETURN TO AND LANDED SAFELY AT PHX. REMOVE AND REPLACED FIRST OFFICER SLIDING WINDOW. PER AMM 56-12-11.SDR AALA202405061081Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY ENTRY DOOR DIFFICULT TO OPEN. TIGHTENED SCREWS ON DOOR HINGE AND LUBRICATED, DOOR OPERTIONAL CHECK GOOD. PER CMM 25-40-64.SDR AALA202405067807Power Supply · inoperativeAIRCRAFT WAS NOT GROUNDED: UPON PERFORMING A EMERGENCY LIGHTING INSPECTION FOUND AFT LEFT HAND DOOR SLIDE LIGHT INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY. OPERTIONAL CHECK GOOD. PER AMM 33-51-06.SDR AALA202405067173Seal · unsecureAIRCRAFT WAS NOT GROUNDED: LAVATORY-D ENTRY DOOR DIFFICULT TO OPEN OR CLOSE. SECURED DOOR SEAL BEARING, OPERTIONAL CHECK GOOD. PER AMM 25-40-14.SDR AALA202405065518Door Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR DIFFICULT TO OPEN AND CLOSE. LUBRICATED AFT LEFT LAVATORY DOOR LATCH. OPERTIONAL CHECK GOOD. PER CMM 25-40-65.SDR AALA202405067803Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: LEFT FORWARD ENTRY DOOR FLASH LIGHT INOPERATIVE. REPLACED FLASHLIGHT AS REQUIRED. PER AMM 25-20-00.SDR AALA202405063169Light · inoperativeAIRCRAFT WAS NOT GROUNDED: LEFT EXTERIOR FORWARD SLIDE OVERWING EMERGENCY LIGHT INOPERATIVE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202405069279Light · inoperativeAIRCRAFT WAS NOT GROUNDED: LEFT SLIDE OVERWING EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED LEFT SLIDE OVERWING EMERGENCY LIGHT. PER AMM 33-51-04.SDR AALA202405245364Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR STRUCTURE SHIELD LOCATED FROM STA 767 TO STA 787, S25R. REPLACED SHIELD PER AARD 51-00-05-1.SDR AALA202405244516Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR STRUCTURE TRANSITION PANEL CLIP AT STA 767, S25R. REPLACED CLIP PER AARD AARD 51-00-05.SDR AALA202405214839Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL FROM STA 727H TO STA 727I, RBL 24. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202405218692Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL FROM STA 727G TO STA 727H, RBL 24. REPLACED TRANSITION PANEL PER ARM 53-00-53.SDR AALA202405202612Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR STRUCTURE TRANSITION PANEL FROM STA 727 TO STA 767, S25R. REPLACED TRANSITION PANEL PER AARD 51-00-05.SDR AALA202405203733Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR STRUCTURE TRANSITION PANEL FROM STA 727 TO STA 767, S25R. REPLACED TRANSITION PANEL PER AARD 51-00-05.SDR AALA202405201163Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR BOARD SUPPORT FROM STA 787 TO STA 807, LBL 6. REPAIRED FLOOR BOARD SUPPORT PER SRM 53-00-53.SDR AALA202405209078Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR STRUCTURE TRANSITION PANEL FROM STA 727 TO STA 767, S25R. REPLACED TRANSITION PANEL PER AARD 51-00-05.SDR AALA202405208803Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR STRUCTURE TRANSITION PANEL FROM STA 727F TO STA 727G, RBL 24. REPLACED TRANSITION PANEL PER AARD 51-00-05.SDR AALA202405207666Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR STRUCTURE TRANSITION PANEL FROM STA 727E TO STA 727F, RBL 24. REPLACED TRANSITION PANEL PER AARD 51-00-05.SDR AALA202405204332Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR STRUCTURE TRANSITION PANEL FROM STA 727D TO STA 727E, RBL 24. REPLACED TRANSITION PANEL PER AARD 51-00-05.SDR AALA202405203529Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR STRUCTURE TRANSITION PANEL FROM STA 727B TO STA 727C, RBL 23. REPLACED TRANSITION PANEL PER AARD 51-00-05.SDR AALA202405064663Tube · missingAIRCRAFT WAS NOT GROUNDED: HEAT SHRINK TUBING MISSING FROM BOTH ENDS OF GIRT BAR FOR R1 DOOR SLIDE. REPLACED HEAT SHRINK TUBING ON BOTH ENDS OF GIRT BAR. PER PER AARD 25-66-00 REPAIR 4.SDR AALA202405066149Tube · missingAIRCRAFT WAS NOT GROUNDED: HEAT SHRINK TUBING MISSING FROM BOTH ENDS OF GIRT BAR FOR L2 DOOR SLIDE. REPLACED HEAT SHRINK TUBING ON BOTH ENDS OF GIRT BAR. PER AARD25-66-00 REPAIR 4.SDR AALA202405066217Tube · missingAIRCRAFT WAS NOT GROUNDED: HEAT SHRINK TUBING MISSING FROM BOTH ENDS OF GIRT BAR FOR L1 DOOR SLIDE. REPLACED HEAT SHRINK TUBING ON BOTH ENDS OF GIRT BAR. PER AARD25-66-00 REPAIR 4.SDR AALA202405069915Tube · missingAIRCRAFT WAS NOT GROUNDED: HEAT SHRINK MISSING FROM ONE END AND OTHER END DAMAGED ON GIRT BAR FOR R2 DOOR SLIDE. REPLACED HEAT SHRINK TUBING ON BOTH ENDS OF GIRT BAR. PER AARD 25-66-00 REPAIR 4.SDR AALA202405064499Housing · dislodgedAIRCRAFT WAS NOT GROUNDED: FOUND EMERGENCY EXIT LIGHT ON FLOOR LOCATED AT 9C. REMOVED AND REPLACED EMERGENCY LIGHT HOUSING. PER CMM 25-23-67.
Back to Boeing 737-823