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 AALA202412161594Oil Cooler · leakingAIRCRAFT WAS GROUNDED: STRONG SMELL OF FUMES FROM PREFLIGHT TO LANDING. DEFINITELY IN THE FLIGHT DECK AND FLIGHT ATTENDANTS ALSO REPORTED IN THE CABIN. DURING TROUBLESHOOTING FOUND OVERALL APU AREA CONTAMINATED WITH OIL AND SOOT STAINED PRIMARILY IN THE OIL COSDR AALA202412163965Brake Assy · seizedAIRCRAFT WAS NOT GROUNDED: AFTER GETTING PUSHED BACK OFF THE GATE TRIED TO TAXI OUT IN THEALLEYWAY. AFTER BRINGING THE THRUST UP TO 40% THE AIRCRAFT WOULD NOT MOVE. WE CALLED OPS AND ASKED FOR A TUG TO COME TO TUG US ABOUT 20 FEET TO GET OUT OF THE RUT. HOWEVESDR AALA202501148151Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL LOCATED FROM STA 727I TO STA 727J, RBL 40, AT S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-01.SDR AALA202412201743Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL LOCATED BETWEEN STA 727 AND STA 1016, AT S25L, LBL 26. REPLACED TRANSITION PANEL PER AARD51-00-05-1.SDR AALA202412168812Slide · out of positionAIRCRAFT WAS NOT GROUNDED: AFT ENTRY DOOR SLIDE STICKING OUT OF HOUSING. ADJUSTED SLIDE PACK. PER AMM 25-66-01.SDR AALA202412142441Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER AT STA 663.75, RBL 6.15. REPAIRED CRACK PER AARD 57-10-10-9.SDR AALA202412278012Skin · delaminatedAIRCRAFT IN BASE MAINTENANCE: LEFT WING INBOARD MAIN FLAP AFT OUTBOARD TRAILING EDGE WEDGE LOWER SURFACE DELAMINATED. MAINTENANCE REPAIRED LEFT WING INBOARD MAIN FLAP AFT OUTBOARD TRAILING EDGE WEDGE LOWER SURFACE PER SRM 57-53-01-2R-7 AND SRM 51-70-10-2R-4.SDR AALA202412263696Girt Bar · frayedAIRCRAFT IN BASE MAINTENANCE: AFT ENTRY L2 SLIDE'S GIRT FRAYED. **SUPPLEMENTAL REPORT FOR (AALA202412133696): REMOVED AND REPLACED SLIDE PACK ASSEMBLY, PER WORK CARD 08L22125001-L2**(CLOSED).SDR AALA202412244945Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND WING UPPER TRANSLATING PANEL JUST OUTBOARD OF RIGHT HAND PYLON LOWER WEB HAS CRACKED ATTACH CLIP. REMOVED DAMAGED CLIP AND INSTALLED NEW CLIP AT RIGHT HAND WING UPPER TRANSLATING PANEL JUST OUTBOARD OF RIGHT HAND PYLON SDR AALA202412240287Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT FLOOR STRUCTURE BAFFLE LOCATED FROM STA 500C TO STA 500D AT RBL 26. REPLACED BAFFLE PER AARD 51-00-05-1.SDR AALA202412249968Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IM FORWARD CARGO COMPARTMENT FLOOR STRUCTURE BAFFLE CLIP LOCATED AT STA 500G, RBL 26. REPLACED BAFFLE CLIP PER AARD 51-00-05-1.SDR AALA202412234864Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR SUPPORT BREAK ASSEMBLY PANEL LOCATED AT STA 540 BETWEEN BL 0 AND RBL 24. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-1.SDR AALA202412205809Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT BAFFLE CLIP LOCATED AT BS 500G AT S26R. REPLACED BAFFLE CLIP PER AARD 51-00-05-1.SDR AALA202412184402Pump · low pressureAIRCRAFT WAS NOT GROUNDED: AFTER LEVEL OFF AT CRUISE ALTITUDE BOTH CENTER TANK PUMPS SELECTED ON TO USE CENTER TANK FUEL. LEFT PUMP OPERATED NORMALLY BUT RIGHT PUMP LOW PRESSURE LIGHT ILLUMINATED AND WOULD NOT EXTINGUISH UNTIL PUMP SELECTED OFF. **SUPPLEMENTALSDR AALA202412178273Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL TOP ANGLE, LOCATED FROM STA 380 TO STA 400 AT BL 0. REPLACED ANGLE PER AAR 51-00-05-1.SDR AALA202412172887Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT STA 344 AND BL 0. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202412136609Battery Pack · no testAIRCRAFT WAS GROUNDED: EMERGENCY EXIT LIGHT BATTERY PACK M1672 REQUIRES REPLACEMENT DUE TO FAILURE. PER JOB CARD 08T21033001. REPLACED EMERGENCY LIGHT POWER SUPPLY BATTERY PACK M1672, OPERTIONAL CHECKS NORMAL. PER AMM 33-51-06.SDR AALA202412134402Pump · low pressureAIRCRAFT WAS NOT GROUNDED: AFTER LEVEL OFF AT CRUISE ALTITUDE BOTH CENTER TANK PUMPS SELECTED ON TO USE CENTER TANK FUEL. LEFT PUMP OPERATED NORMALLY BUT RIGHT PUMP LOW PRESSURE LIGHT ILLUMINATED AND WOULD NOT EXTINGUISH UNTIL PUMP SELECTED OFF. **SUPPLEMENTALSDR AALA202412133696Girt Bar · frayedAIRCRAFT IN BASE MAINTENANCE: AFT ENTRY L2 SLIDE'S GIRT FRAYED. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202412132476Sign · missingAIRCRAFT WAS NOT GROUNDED: RIGHT OVERWING EMERGENCY EXIT SIGN MISSING. REPLACED LENS. OPERTIONAL CHECK GOOD. PER MM33-51-01.SDR AALA202412132549Lens · brokenAIRCRAFT WAS NOT GROUNDED: LEFT OVERWING EMERGENCY EXIT LIGHT COVER BROKEN. REPLACED EMERGENCY LIGHT ASSEMBLY AT LEFT OVERWING EXIT AFT OF SEAT16A PASSENGER WINDOW. OPERTIONAL CHECK GOOD. PER AMM 33-51-01.SDR AALA202412136323Light · dislodgedAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTANDENT REPORTED A CELING LIGHT HANGING ON THE AFT CABIN. AROUND ROW32. RESECURED EMERGENCY LIGHT AT ROW 32 OVERHEAD. OPERTIONAL CHECK GOOD. PER AMM 33-51-03.SDR AALA202501094891Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN STA 480 AND STA 500E, AT LBL 30. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202412200449Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL BETWEEN STA 500I AND STA 520 AT BL 0. REPLACED INTERCOSTAL PER AARD 51-00-05-1 AND SRM 51-40-02.SDR AALA202412192166Door Frame · gougedAIRCRAFT IN BASE MAINTENANCE: R1 DOOR CUTOUT AT AFT FRAME, GUIDE FITTING IS GOUGED. REMOVED AND REPLACED R1 DOOR CUTOUT, AFT FRAME, GUIDE FITTING. PER B737-NG SRM 51-40-02-0G AND B737-NG AMM 20-50-11-910-801.SDR AALA202412184062Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL LOCATED AT STA 290, AT BL 0. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202412144082Skin · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND WING LOWER SKIN AT WS 746. REPAIRED SKIN PER 360204.SDR AALA202412135555Unknown · odorAIRCRAFT WAS GROUNDED: AFTER LANDING FLIGHT ATTENDANT IN THE REAR REPORTED A MOMENTARY SMELL OF RUBBER. CLEARED AFTER A COUPLE OF SECONDS. POST FLIGHT LOOKED NORMAL PER FIRST OFFICER BUT REPORTED AN UNUSUAL SMELL OF OIL AROUND ENGINES. OIL LEVELS NORMAL. FOUSDR AALA202412125555Unknown · odorAIRCRAFT WAS GROUNDED: AFTER LANDING FLIGHT ATTENDANT IN THE REAR REPORTED A MOMENTARY SMELL OF RUBBER. CLEARED AFTER A COUPLE OF SECONDS. POST FLIGHT LOOKED NORMAL PER FIRST OFFICER BUT REPORTED AN UNUSUAL SMELL OF OIL AROUND ENGINES. OIL LEVELS NORMAL. **SUSDR AALA202412112568Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED BREAK ASSEMBLY PANEL LOCATED AT STA 537.45 BETWEEN LBL 24.75 AND LBL 45.50. REPLACED BREAK ASSEMBLY PANEL PER SRM 51-40-02.SDR AALA202412301238Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON INTERCOSTAL LOCATED AT BS 958, LBL 49. REPLACED INTERCOSTAL PER AARD AARD 51-00-05-1.SDR AALA202412272525Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER CHORD AT LAVATORY MOUNT AT STA 947, LBL 51. ACCOMPLISHED REPAIR PER SRM 53-70-51-2R-5.SDR AALA202412279962Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT STA 949, RBL 52. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202412277505Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL BETWEEN STA 947.5 AND STA 967, AT LBL 24. REPLACED INTERCOSTAL PER AARD 51-00-05-1 SRM 51-10-02-0G.SDR AALA202412246521Skin · crackedAIRCRAFT IN BASE MAINTENANCE: RIGHT WING KRUEGER FLAP INBOARD SIDE SHOWS STRUCTURAL DEFORMATION, CRACKS, AND A MISSING PORTION OF THE SKIN. REPAIRED RIGHT HAND WING INBOARD KRUEGER FLAP. PER B737-NG SRM 57-43-02-2R PROCEDURE 3 REPAIR 3.SDR AALA202412182139Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR BREAK ASSEMBLY PANEL LOCATED AT STA 540 FROM RBL 1 TO RBL 21. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-1.SDR AALA202412111702Light · missingAIRCRAFT IN BASE MAINTENANCE: FORWARD ENTRY DOOR EXIT PLASTIC COVER NEAR FLOOR MISSING. REMOVED AND REPLACED FORWARD DOOR EMERGENCY LIGHT ASSEMBLY. PER AMM 33-51-01.SDR AALA202412118326Door Latch · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY-D LOCK (AFT LEFT LAVATORY), SEVERAL PASSENGERS UNABLE TO UNLOCK DOOR FROM INSIDE. ADJUSTED LATCH STRIKER MECHANISM OPERTIONAL CHECKL GOOD. PER AMM25-40-15.SDR AALA202412117082Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHTS FAILED TEST AT AFT LEFT DOOR OF AIRCRAFT. REPLACED BATTERY PACK FOR LEFT AFT DOOR. OPERTIONAL CHECK GOOD. PER AMM 33-51-06.SDR AALA202412105558Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR BREAK ASSEBMLY PANEL LOCATED AT STA 540, FROM BL 0 TO LBL 21. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-1.SDR AALA202506045050Probe · faultedAIRCRAFT WAS GROUNDED: ON TAKEOFF, AIRCRAFT DEVELOPED A 540 LBS FUEL IMBALANCE BETWEEN THE LEFT TANK AND RIGHT TANK. THE IMBALANCE REMAINED BETWEEN 540LBS AND 400 LBS. DUE TO RECENT AIRCRAFT FUEL LEAK, WE OPTED TO NOT BALANCE THE FUEL. THE LEFT TANK IS THE LOSDR AALA202506044314Compensator · faultedAIRCRAFT WAS GROUNDED: ON TAKEOFF, AIRCRAFT DEVELOPED A 540 LBS FUEL IMBALANCE BETWEEN THE LEFT TANK AND RIGHT TANK. THE IMBALANCE REMAINED BETWEEN 540LBS AND 400 LBS. DUE TO RECENT AIRCRAFT FUEL LEAK, WE OPTED TO NOT BALANCE THE FUEL. THE LEFT TANK IS THE LOSDR AALA202412275904Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: COSSORION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL BETWEEN STA 929 AND STA 947 AT LBL 60. REPLACED INTERCOSTAL PER AARD 51-00-05-1 AND SRM 53-00-04-1A.SDR AALA202412188219Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER FLOOR STRUCTURE INTERCOSTAL LOCATED FROM STA 277 TO STA 294.5 AT BL 0. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202412189456Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN ANGLE LOCATED AT CABIN FLOOR AREA OF R2 DOOR JAMB, STA 294.5 AT RBL 53. REPLACED ANGLE PER AARD 51-00-05-01.SDR AALA202412182203Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL LOCATED FROM STA 312 TO STA 328, LBL 46. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202412110729Skin · crackedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND SIDE OF FUSELAGE EXTERNAL POWER PANEL LOWER CUTOUT SKIN IS BENT WITH CRACK. LOCATED BETWEEN STA 229 AND STA 235.8 AND BETWEEN S21R AND S22R. ACCOMPLISHED DOUBLER REPAIR PER SRM 53-10-15-2R-4.SDR AALA202412104314Fuel Sys · out of balanceAIRCRAFT WAS GROUNDED: ON TAKEOFF, AIRCRAFT DEVELOPED A 540 LBS FUEL IMBALANCE BETWEEN THE LEFT TANK AND RIGHT TANK. THE IMBALANCE REMAINED BETWEEN 540LBS AND 400 LBS. DUE TO RECENT AIRCRAFT FUEL LEAK, WE OPTED TO NOT BALANCE THE FUEL. THE LEFT TANK IS THE LOSDR AALA202412106076Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER CHORD AT STA 947, FROM LBL 7 TO LBL 52. ACCOMPLISHED REPAIR PER SRM 51-40-02-OG.SDR AALA202412100823Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL LOCATED FROM STA 328 TO STA 344, LBL 45. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.
Back to Boeing 737-823