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 AALA202405061175Light · unsecureAIRCRAFT WAS NOT GROUNDED: FOUND EMERGENCY EXIT LIGHT ON FLOOR LOCATED AT 15C. RESECURED EMERGENCY LIGHT AT SEAT 15C. OPERATION NORMAL AT THIS TIME. PER AMM 33-51-11.SDR AALA202405063993Skin · puncturedAIRCRAFT WAS GROUNDED: LEFT WING INBOARD FLAP HAS A PUNCTURE AT WS 204. REPAIRED FLAP PER EA 350164A AND SRM 51-70-10-2R-2.SDR AALA202406143917Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON E AND E COMPARTMENT INTERCOSTAL BETWEEN STA 311 AND STA 325, BETWEEN S22L AND S28L. REPLACED INTERCOSTAL PER AARD 51-00-05-1 AND EA 354578.SDR AALA202406048390Skin · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FUSELAGE SKIN AT STA 540, S22L. REPAIRED SKIN PER EA 353519.SDR AALA202405219859Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN LEFT HAND ENTRY WAY MAIN SILL INNER CHORD FROM STA 961 TO STA 974, LBL 48. REPLACED INNER CHORD PER AARD 51-00-05-1 AND EA 354552.SDR AALA2024052060772Skin · bulgedAIRCRAFT IN BASE MAINTENANCE: OUTWARD BULGE IN FUSELAGE SKIN ABOVE AFT CARGO DOOR AT STA 807, S14R. ACCOMPLISHED DOUBLER REPAIR PER EA 353444.SDR AALA202405205293Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR SUPPORT AT STA 992, RBL 37. REPLACED SUPPORT PER AARD 51-00-05-1.SDR AALA202405062971Girt Bar · out of adjustAIRCRAFT WAS NOT GROUNDED: GIRT BAR LOOSE WHEN INSTALLED IN FLOOR LATCH AT FORWARD SERVICE DOOR. READJUSTED GIRT. PER AMM 25-66-00.SDR AALA202405069193Light · dislodgedAIRCRAFT WAS NOT GROUNDED: EMERGENCY ESCAPE PATH LIGHT ATTACHED TO SEAT 19C IS HANGING FROM BOTTOM OF SEAT. REATTACHED 19C EMERGENCY LIGHT ASSEMBLY AS REQUIRED. PER 33-50-00SDR AALA202405065393Housing · dislodgedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT FLOOR LIGHT ON SEAT 15C FELL OFF. REMOVED AND REPLACED SHROUD ASSEMBLY RACEWAY AT EMERGENCY EXIT FLOOR LIGHT ON SEAT 15C. PER CMM 25-23-67.SDR AALA202405067929Door Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: L4 BATHROOM DOOR LATCH HARD TO OPEN. LUBED L4 LAVATORY DOOR LATCH. FUNCATIONAL CHECK GOOD.SDR AALA202405069089Door · inoperativeAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS AFT LEFT LAVATORY DOOR IS STUCK IN CLOSED POSITION. **SUPPLEMENTAL REPORT FOR (AALA202405039089): REMOVED AND REPLACED AFT LEFT LAVATORY DOOR. OPERTIONAL CHECK GOOD. PER CMM 25-40-64**(CLOSED).SDR AALA202405068099Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER RIB, SECOND STIFFENER FROM FRONT, AT STABILIZER STA 92.70, REPAIRED RIB PER SRM 55-10-09-2R.SDR AALA202405061280Pressure Deck · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING SECTION REAR SPAR, LEFT HAND WHEEL WELL, VERTICAL PRESSURE DECK WEB AT STA 663.75, AT LBL 40. REPAIRED WEB PER SRM 57-10-10-2R REPAIR 3 ALTERNATIVE 2.SDR AALA202405037223Girt Bar · lack of lubeAIRCRAFT WAS NOT GROUNDED: GIRT BAR ON AFT RIGHT SERVICE DOOR NEEDS TO BE ADJUSTED. VERY DIFFICULT TO ARM AND DISARM. ADJUSTED AND LUBED AFT SERVICE DOOR GIRT BAR.SDR AALA202405037509Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY-A DOOR STICKS AND JAMMING AND IS DIFFICULT TO OPEN AND CLOSE. ADJUSTED FLOOR DOOR TRIM. PER AMM 25-40-11.SDR AALA202405034626Light · inoperativeAIRCRAFT WAS NOT GROUNDED: R2 DOOR EMERGENCY SLIDE LIGHT INOPERATIVE. REMOVED AND REPLACED R2 DOOR EMERGENCY SLIDE LIGHT. OPERTIONAL CHECK NORMAL. PER AMM 33-51-04.SDR AALA202405039614Light · brokenAIRCRAFT WAS NOT GROUNDED: EMERGENCY PATH LIGHTING AT ROW 16ABC BROKEN. REMOVED AND REPLACED EMERGENCY PATH LIGHTING.PER AMM 33-51-11.SDR AALA202405039089Door · stuckAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS AFT LEFT LAVATORY DOOR IS STUCK IN CLOSED POSITION. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202405209789Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON STRINGER 25L BETWEEN STA 867 AND STA 887. REPAIRED STRINGER PER EA 354296.SDR AALA202405097581Door · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR WILL NOT OPEN. REMOVE AND REPLACED DOOR ASSEMBLY. PER CMM 25-40-58.SDR AALA202405032197Oven · burnedAIRCRAFT WAS GROUNDED: FOUND FORWARD GALLEY NUMBER 2 OVEN HEATING ELEMENT BURNED. **SUPPLEMENTAL REPORT FOR (AALA202405022197): REPLACED FORWARD GALLEY NUMBER 2 OVEN. PER AMM 25-32-03**(CLOSED).SDR AALA202405024901Girt Bar · stuckAIRCRAFT WAS NOT GROUNDED: R1 GIRT BAR STUCK IN THE UNARMED POSITION. RELEASED GIRTBAR. PER AMM 52-40-00.SDR AALA202405027581Door · stuckAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR WILL NOT OPEN. (OPEN).SDR AALA202405029239Light · unsecureAIRCRAFT WAS NOT GROUNDED: ROW 8ABC EXIT LIGHTING HANGING FROM BOTTOM OF SEAT. RE-INSTALLED AND SECURED LIGHT COVER CAP ON ROW 8ABC. PER AMM 33-51-11.SDR AALA202405022197Oven · overheatedAIRCRAFT WAS GROUNDED: FOUND FORWARD GALLEY NUMBER 2 OVEN HEATING ELEMENT BURNED. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202405020500Door · unsecureAIRCRAFT WAS NOT GROUNDED: FIRST CLASS LAVATORY DOOR VERY DIFFICULT TO OPEN AND CLOSE. SECURED PANEL FUNCATIONAL CHECKED GOOD. PER AMM 25-21-71.SDR AALA202405026838Light · dislodgedAIRCRAFT WAS NOT GROUNDED: CABIN SEAT 8C HAS EMERGENCY LIGHT ASSEMBLY HANGING DOWN UNDER SEAT. REPLACED LIGHT BRACKET. PER B/E CMM 25-23-61.SDR AALA202405019377Sign · dislodgedAIRCRAFT WAS NOT GROUNDED: ROW 22 EMERGENCY EXIT LIGHT PACK IS FALLING OFF SEAT. RESECURED EGRESS LIGHT CASE ON PAX SEAT 22C. PER CMM 25-23-67.SDR AALA202405011242Sign · unsecureAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT AT 16F FLICKERING. SECURED LIGHT AT 16F. PER AMM 23-21-00.SDR AALA202405013213Sign · dislodgedAIRCRAFT WAS NOT GROUNDED: OVERHEAD EXIT LIGHT ROW 16 HIT BY PASSENGER BAG HANGING BY WIRES. REINSTALLED EMERGENCY LIGHT. OPERTIONAL CHECK NORMAL. PER MM 33-51-01.SDR AALA202405039172Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FUSELAGE FRAME AT STA 500A, JUST BELOW S8R. INSTALLED DOUBLER REPAIR PER SRM 53-00-07-2.SDR AALA202405025146Light · dislodgedAIRCRAFT WAS NOT GROUNDED: GROUND EMERGENCY LIGHT COMPONENT HANGING FROM 11C.**SUPPLEMENTAL REPORT FOR (AALA202404305146): REPLACED SEAT 11C EMERGENCY LIGHT TRIM. PER CMM 25-23-67**(CLOSED).SDR AALA202405017716Plate · out of adjustAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR DIFFICULT TO OPEN AND UNLOCK. ADJUSTED LOWER PLATE HEIGHT. PER CMM 25-40-58.SDR AALA202405019376Wire Harness · unsecureAIRCRAFT WAS GROUNDED: SEAT 13C EMERGENCY LIGHTING HARNESS HANGING DOWN FROM SEAT HOUSING EXPOSED TO PASSENGER FOOT AREA. RE-SECURED EMERGENCY LIGHTING ELECTRICAL HARNESS AT 13C. OPERATIONAL CHECK OF EMERGENCY LIGHTING NORMAL AT TIME OF INSPECTION.SDR AALA202405019557Wire Harness · unsecureAIRCRAFT WAS GROUNDED: 29C EMERGENCY LIGHT HARNESS HAVING DOWN OUT OF SEAT HOUSING. RE-SECURED EMERGENCY LIGHTING HARNESS AT 29D, CHECK EMERGENCY LIGHTING NORMAL.SDR AALA202405019956Housing · unsecureAIRCRAFT WAS GROUNDED: 11C EMERGENCY LIGHT HOUSING COVER MISSING AND EMERGENCY LIGHT HANGING NOT SECURED. REPLACED BROKEN EMERGENCY HOUSING, REINSTALLED EMERGENCY LIGHT ASSEMBLY AND SECURED WIRING HARNESS, CHECKED EMERGENCY LIGHTING GOOD.SDR AALA202405010267Track · looseAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY UPPER TRACK HAS SCREW LOOSE, AND DOOR WILL NOT OPEN ALL THE WAY. TIGHTENED LOOSE FASTENER UPPER TRACK AFT LAVATORY DOOR. FUNCATIONAL CHECK NORMAL.SDR AALA202405019070Indication Sys · unknownAIRCRAFT WAS GROUNDED: ON DEPARTURE AT 8,000 FEET NOTICED IMBALANCE ON LEFT FUEL TANK. ACCOMPLISHED FAULT ISOLATION FOR UNEXPECTED FUEL CONFIGURATION MESSAGE .NO FAULTS NOTED PER TASK 28-41-00-810-820.SDR AALA202405012108Door Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR LATCH STICKS. DIFFICULT TO OPEN FROM INSIDE. LUB LATCH ON LEFT AFT LAVATORY. OPERTIONAL CHECK GOOD.SDR AALA202405016668Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR DIFFICULT TO OPEN AND CLOSE. LUBED HINGE AND TRACK FOR LAVATORY-D DOOR. FUNCATIONAL CHECKS GOOD. PER CMM 25-40-64.SDR AALA202405014284Track · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT STATES AFT LAVATORY-D DOOR DOES NOT SELF CLOSE PROPERLY TO BE SAFE FOR EMERGENCY EGRESS. CLEANED AND LUBRICATED LAVATORY-D DOOR TRACK. PER CMM 25-40-64.SDR AALA202405019888Door · looseAIRCRAFT WAS NOT GROUNDED: AFT RIGHT LAVATORY-E DOOR IS VERY HARD TO OPERATE. FOUND DOOR FRAME LOWER SKID PLATE WITH LOOSE SCREWS. TIGHTENED SCREWS ON LAVATORY-E DOOR LOWER SKID PLATE. PER CMM 25-40-65.SDR AALA202404305146Light · detachedAIRCRAFT WAS NOT GROUNDED: GROUND EMERGENCY LIGHT COMPONENT HANGING FROM 11C. (OPEN).SDR AALA202404302072Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND RBL 54.60. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202404302130Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND RBL 40.87. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202404302395Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND RBL 32.40. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202404306876Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND RBL 15.04. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202404301199Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND RBL 6.14. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202404303413Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND LBL 6.14. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.
Back to Boeing 737-823