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 AALA202205261918Skin · crackedAIRCRAFT IN BASE MAINTENANCE: LEFT HORIZONTAL STABILIZER LOWER SKIN AT STA 129.50 CRACKED. INSTALLED DOUBLER PER SRM 51-40-02-0G AND SRM 55-10-01-2R-11 REPETITIVE INSPECTION TO BE ACCOMPLISHED NO LATER THAN EVERY 9000 FLIGHT CYCLE. FINAL RESTORATION TO BE ACCOSDR AALA202204076818Fseu · faultedAIRCRAFT WAS GROUNDED: AT POWER UP ON TAKEOFF, TAKEOFF WARNING HOLD AND TAKEOFF CONFIGURATION LIGHT ACTIVATED. CONFIRMATION WAS RECHECKED, ALL SETTINGS AS REQUIRED. REAPPLIED POWER AND WARNING CONTINUED TAKEOFF WAS DISCONTINUED. SPEED DID NOT EXCEED 5 KNOTS, FSDR AALA202204078887Sensor · fault messageAIRCRAFT WAS GROUNDED: LEFT COWL ANTI ICE LIGHT ILLUMINATED ON TAKEOFF. RESTARTED AT 60 KIAS THRUST WAS AT APPROXIMATELY 70 PERCENT N1. THIS WAS A FERRY FLIGHT TO CLT FOR MAINTENANCE FROM A PREVIOUS ABORTED TAKE OFF FOR THE SAME ISSUE. (AALA202204047755), (AALSDR AALA202204079660Anti-Ice Valve · fault messageAIRCRAFT WAS GROUNDED: LEFT COWL ANTI ICE LIGHT ILLUMINATED ON TAKEOFF. RESTARTED AT 60 KIAS THRUST WAS AT APPROXIMATELY 70 PERCENT N1. THIS WAS A FERRY FLIGHT TO CLT FOR MAINTENANCE FROM A PREVIOUS ABORTED TAKE OFF FOR THE SAME ISSUE. (AALA202204047755), (AALSDR AALA202204072729Skin · crackedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND STABILIZER LOWER SKIN CRACKED AT STABILIZER STATION 129.50 AND 19 INCHES FROM THE AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R REPAIR 11.SDR AALA202204074372Skin · crackedAIRCRAFT IN BASE MAINTENANCE LEFT HAND STABILIZER LOWER SKIN CRACKED AT STABILIZER STATION 125 ALONG THE AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R REPAIR 11.SDR AALA202204074718Skin · crackedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND STABILIZER LOWER SKIN CRACKED AT STABILIZER STATION 129.50 AT THE SIXTH DRAIN HOLE OUTBOARD. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202204081797Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CABIN FLOOR SUPPORTS AT BS 540 BETWEEN LBL 24 AND RBL 24. **SUPPLEMENTAL REPORT FOR AALA202204071797: REPLACED LEFT HAND FLOOR SUPPORT AND RIGHT-HAND FLOOR SUPPORT (AALA202204086530) PER AARD 51-00-05** (CLOSED)SDR AALA202204086530Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CABIN FLOOR SUPPORTS AT BS 540 BETWEEN LBL 24 AND RBL 24. **ORIGINAL REPORT WAS AALA202204071797** REPLACED LEFT HAND FLOOR SUPPORT AND RIGHT-HAND FLOOR SUPPORT (AALA202204086530) PER AARD 51-00-05.SDR AALA202204079260Sensor · fault messageAIRCRAFT WAS GROUNDED: LEFT COWL ANTI-ICE LIGHT ILLUMINATED ON TAKE OFF, 24K POWER. REJECTED AT 50 KNOTS. **SUPPLEMENTAL REPORT FOR AALA202204047755: SECOND ABORTED TAKE OFF (AALA202204079660), (AALA202204078887) ON A FERRY FLIGHT ON APRIL 5. TROUBLE SHOOTING SDR AALA202204077755Anti-Ice Valve · fault messageAIRCRAFT WAS GROUNDED: LEFT COWL ANTI-ICE LIGHT ILLUMINATED ON TAKE OFF, 24K POWER. REJECTED AT 50 KNOTS. **SUPPLEMENTAL REPORT FOR AALA202204047755: SECOND ABORTED TAKE OFF (AALA202204079660), (AALA202204078887) ON A FERRY FLIGHT ON APRIL 5. TROUBLE SHOOTING SDR AALA202205267984Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK ALONG RIB AT STA 166.30 LOCATED 9 INCHES` FROM AFT SPAR. COMPLETED DOUBLER INSTALLATION PER SRM 55-10-01-2R REPAIR 11. **SUPPLEMENTAL REPORT FOR AALA202204087984: RE INSPECTION TO OCCUR NO LATER THAN 56000 FLIGHT CYCLES.** (SDR AALA202204134324Lens · crackedAIRCRAFT IN BASE MAINTENANCE: OVERWING EXIT LIGHT LENS CRACKED. REPLACED LENS PER AMM 33-51-01.SDR AALA202204130154Lens · crackedAIRCRAFT IN BASE MAINTENANCE: OVERWING EXIT LIGHT LENS CRACKED. REPLACED LENS PER AMM 33-51-01.SDR AALA202204138008Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED RIGHT HAND HORIZONTAL STABILIZER RIB AT STABILIZER STATION 92.70 ON THE 1ST AND 2ND STIFFENERS. REPAIRED RIB PER SRM 55-10-09-2R.SDR AALA202204131399Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED LEFT HAND HORIZONTAL STABILIZER RIB AT STABILIZER STATION 120.30 AT THE 4TH STIFFENER. REPLACED RIB PER AARD 51-00-05.SDR AALA202204133318Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED LEFT HAND HORIZONTAL STABILIZER RIB AT STABILIZER STATION 120.30 ON THE 2ND AND 3RD STIFFENERS. REPLACED RIB PER AARD 51-00-05.SDR AALA202204136087Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED RIGHT HAND HORIZONTAL STABILIZER RIB AT STABILIZER STATION 129.50 AT THE 3RD STIFFENER. REPAIRED RIB PER SRM 55-10-09.SDR AALA202204137592Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN AT STABILIZER STATION 138.70 AND 9 INCHES FROM THE AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R.SDR AALA202204131793Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN AT STABILIZER STATION 138.70 AND 25 INCHES FROM THE FORWARD SPAR. REPAIRED SKIN PER SRM 55-10-01-2R.SDR AALA202204134484Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN AT STABILIZER STATION 129.50 AND 9 INCHES FROM THE AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R.SDR AALA202204133390Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED LEFT HAND HORIZONTAL STABILIZER LOWER SKIN AT STABILIZER STATION 147.90 AND 17 INCHES FROM THE AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R.SDR AALA202204131295Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED LEFT HAND HORIZONTAL STABILIZER LOWER SKIN AT STABILIZER STATION 147.89 AND 10 INCHES FROM THE AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R.SDR AALA202204131762Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED LEFT HAND HORIZONTAL STABILIZER LOWER SKIN AT STABILIZER STATION 138.70 AND 9 INCHES FROM THE FORWARD SPAR. REPAIRED SKIN PER SRM 55-10-01-2R.SDR AALA202204131553Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED LEFT HAND HORIZONTAL STABILIZER LOWER SKIN AT STABILIZER STATION 129.50 AND 18 INCHES FROM THE AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R.SDR AALA202204131511Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED LEFT HAND HORIZONTAL STABILIZER LOWER SKIN AT STABILIZER STATION 129.50 AND 10 INCHES FROM THE AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R.SDR AALA202304185010Fairing · crackedAIRCRAFT WAS GROUNDED: WING TO FUSELAGE BODY FAIRING NUMBER 192 BC TOP AFT CORNER CRACKED ABOUT 10 INCHES LONG. ACCOMPLISHED TEMPORARY REPAIR TO WING TO BODY FAIRING PER EA NUMBER 334597. REPETITIVE INSPECTIONS TO BE ACCOMPLISHED NO LATER THAN EVERY 30 DAYS. FSDR AALA202203022736Sensor · faultyAIRCRAFT WAS GROUNDED: FLAP ASYMMETRY ON APPROACH. FLIGHT DECLARED AN EMERGENCY LANDING SAFELY. REPLACED TRAILING EDGE FLAP SKEW SENSOR 2 PER AMM 27-59-01-400-802. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202202178198Window · arcedAIRCRAFT WAS GROUNDED: LEFT FORWARD WINDOW ARC IN FLIGHT AT BASE OF WINDOW. NO SMOKE, NO FUMES. PARTIAL WORK ACCOMPLISHED REMOVED AND REPLACED LEFT FORWARD WINDOW NUMBER 1 PER WORK 08L21056003 OPERATIONS CHECK GOOD NO LEAKS NOTED AT THIS TIME.SDR AALA2022021601035Tire · failedAIRCRAFT WAS GROUNDED: ON TAKEOFF BOTH LEFT MAIN LANDING GEAR TIRES BLEW RESULTING IN DAMAGE TO MULTIPLE AIRCRAFT STRUCTURES. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202304186233Vapor Barrier · crackedAIRCRAFT WAS GROUNDED: CRACKED VAPOR BARRIER IN RH WHEEL WELL, ACCOMPLISHED TEMPORARY SPEED TAPE REPAIR IAW AARD 57-10-10-9 WITH 600 FC REPETITIVE INSPECTION. **SUPPLEMENTAL REPORT FOR AALA202202106233: REMOVED REPAIR AND INSTALLED PERMANENT REPAIR PATCH PER ASDR AALA202202072218Smoke Detector · false activationAIRCRAFT IN BASE MAINTENANCE: FORWARD LAVATORY SMOKE DETECTOR ACTIVATED IN FLIGHT, NO SMOKE OR FIRE PRESENT. REPLACED SMOKE DETECTOR PER AMM 26-14-00-730-801.SDR AALA202202087463Sensor · faultedAIRCRAFT WAS GROUNDED: FLAPS WOULD NOT EXTEND AND YAW DAMPER FAILED IN DESCENT, FLAPS EXTENDED ELECTRICALLY PER QRH PROCEDURE TO 15 DEGREES. REPLACED #8 FLAP SKEW SENSOR WITH SERVICEABLE UNIT IAW AMM 27-59-01, OPS CHECK GOOD.SDR AALA202311015559Window · faultyAIRCRAFT WAS NOT GROUNDED: L1 WINDOW OVERHEAT INDICATION WHEN SYSTEM TURNED ON. **SUPPLEMENTAL REPORT FOR AALA202201265559: REPLACED L1 WINDOW PER JOB CARD 08L21056003.** (CLOSED)SDR AALA202201268580Switch · faultedAIRCRAFT WAS GROUNDED: ELEVATOR TRIM SWITCHES ON BOTH YOKES INOPERATIVE, MANUAL ELEVATOR TRIM UNAFFECTED; FLIGHT DECLARED EMERGENCY AND RETURNED TO FIELD. ACCOMPLISHED LOGIC RESET OF STAB TRIM MOTOR IAW FIM 27-41-00, OPS CHECK GOOD.SDR AALA202201240656Air Filter · dirtyAIRCRAFT WAS GROUNDED: FOUL SMELL FROM PACKS DURING DESCENT. ACCOMPLISHED SOF INSPECTION IAW 08L00021001, OPS CHECK GOOD; REPLACED HEPA FILTER IAW AMM 21-25-01 AS A PRECAUTION.SDR AALA202201248996Smoke Detector · false activationAIRCRAFT WAS NOT GROUNDED: FWD LAVATORY SMOKE ALARM ACTIVATED, BUT NO INDICATION OF FIRE OR SMOKE. ACCOMPLISHED FUNCTIONAL TEST OF SMOKE DETECTOR IAW FIM 26-14-00-810-801, OPS CHECK GOOD.SDR AALA202201249095Connector · damagedAIRCRAFT WAS GROUNDED: CLIMBING THROUGH 11,000 FT, MASTER CAUTION AND OVERHEAD WARNING LIGHT FOR HYD ELECTRIC PUMP 1, SYS B ILLUMINATED WITH BRIEF ELECTRICAL BURNING SMELL; PUMP DEACTIVATED PER QRH. REPLACED SYSTEM B EMDP CONNECTOR D2666 WITH NEW IAW SWPM 20-6SDR AALA202201240098Smoke Detector · false activationAIRCRAFT WAS NOT GROUNDED: FALSE LAVATORY SMOKE LIGHT ON OVERHEAD PANEL WITH ASSOCIATED AURAL TUNE AT FL390. FLIGHT ATTENDANT NOTED NO SIGN OF SMOKE OR ANY SMELL OF FUMES IN FIRST CLASS LAVATORY NOT ASSOCIATED WITH LAVATORY SMOKE LIGHT OR TONE. REPLACED FIRST SDR AALA202201189462Setscrew · looseAIRCRAFT WAS NOT GROUNDED: FORWARD LABORATORY DOOR HANDLE IS LOOSE. TIGHTENED DOOR HANDLE SET SCREW AS REQUIRED.SDR AALA202201189701Retainer · out of adjustAIRCRAFT WAS NOT GROUNDED: DOOR 1L GIRT BAR HARD INSTALL IN BRACKET AND HARD TO REMOVE. ADJUSTED GIRT BAR ROD RETAINER. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK PER AMM 25-66-01.SDR AALA202201185178Door · out of adjustAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR HARD TO OPEN AND CLOSE. ADJUSTED DOOR AND ACCOMPLISHED SATISFACTORY OPERATIONAL TEST.SDR AALA202201255788Rib · inoperativeAIRCRAFT IN BASE MAINTENANCE: FOUND CRACKS IN VERTICAL STIFFENERS OF HORIZONTAL STABILIZERS RIB. LOCATED AT STA 92.70. INSTALLED RIB AT STA 92.70 PER AARD 55-10-00.SDR AALA202201207528Sump · leakingAIRCRAFT WAS GROUNDED: SHORTLY AFTER POWER REDUCTION ON DECENT, MUSTY TYPE OF ODOR WAS NOTICED ON FLIGHT DECK AND AFT CABIN. ODOR DISSIPATED SHORTLY BEFORE LANDING. MAINTENANCE ACCOMPLISHED SMOKE ODOR FUMES INITIAL TROUBLESHOOTING JOB CARD 08L00021001. ENGINESDR AALA202201187528Unknown · odorAIRCRAFT WAS GROUNDED: SHORTLY AFTER POWER REDUCTION ON DECENT, MUSTY TYPE OF ODOR WAS NOTICED ON FLIGHT DECK AND AFT CABIN. ODOR DISSIPATED SHORTLY BEFORE LANDING. * (OPEN)SDR AALA202201181864Warning Horn · activatedAIRCRAFT WAS NOT GROUNDED: INFO TO MAINTENANCE ABORTED TAKE OFF TUL. TAKE OFF CONFIGURATION HORN AND LIGHT APPROXIMATELY 60 KNOTS CONSULTED QUICK REFERENCE HANDBOOK. RECYCLED FLAPS AND STABILIZERS TRIM SPOILERS, 2ND TAKE OFF ATTEMPT NORMAL.SDR AALA202201143958Proximity Sensor · faultedAIRCRAFT WAS GROUNDED: FLAP/SLAT DISAGREE MESSAGE DURING DESCENT, FLIGHT DECLARED EMERGENCY AND LANDED WITHOUT FURTHER INCIDENT. REPLACED LEADING EDGE SLAT/FLAP PROXIMITY SENSOR S174 F4 RETRACT WITH NEW IAW AMM 27-88-11, OPS CHECK GOOD.SDR AALA202201110366Cover · missingAIRCRAFT WAS NOT GROUNDED: ROW 32DEF OVERHEAD EMERGENCY LIGHT LENS COVER MISSING. INSTALLED LENS COVER PER AMM 33-51-03.SDR AALA202201117620Roller · out of adjustAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR LATCH IS GETTING STUCK IN LOCKED POSITION. ADJUSTED DOOR TOP ROLLER. PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 25-40-04.SDR AALA202201108085Motor · faultedAIRCRAFT WAS NOT GROUNDED: AIRCRAFT DIVERTED TO DFW ON ACCOUNT OF STAB-TRIM ISSUE. EMERGENCY WAS NOT DECLARED AND NOT OVERWEIGHT FOR LANDING. DUE TO AIR INTERRUPT AND REPORT OF SYSTEM B STAB TRIM POSITION FAIL. REMOVED AND REPLACED HORIZONTAL STABILIZER TRIM
Back to Boeing 737-823