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 AALA202402061314Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 727J AND BS 747, LBL 25. REPLACED TRANSITION PANEL PER SRM 53-00-53-1A-2 AND AARD 51-00-05-01.SDR AALA202402063837Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 847 TO BS 967, RBL 52. REPLACED INTERCOSTAL PER SRM 51-40-02.SDR AALA202402069880Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN AFT ENTRY WAY SILL INNER CHORD AT BS 947.5, RBL 55. REPLACED CHORD PER AARD 51-00-05-1.SDR AALA202401164379Seal · leakingAIRCRAFT WAS GROUNDED: FUMES IN COCKPIT AND CABIN DURING DESCENT FROM FL190 TO ABOUT 2000 SMELLS LIKE MUSTY SOCKS. REMOVED AND REPLACED APU MAGNETIC DRAIN PLUG SEAL. PEER AMM 49-91-81.SDR AALA202401162357Seat Track · damagedAIRCRAFT WAS GROUNDED: FOUND TRACKS WITH ELONGATED SEAT STOW HOLES, AND OUTBOARD TRACK WITH GROOVE ACROSS TRACK FROM SEAT PIN NOT CLEARING TRACK. SEAT WAS UNABLE TO MOVE WILL INTERFERE WITH PILOT EGRESS FROM COCKPIT. REPLACED BOTH REAR SEAT TRACKS. PER AMM 25-SDR AALA202401165937Seat Track · inoperativeAIRCRAFT WAS GROUNDED: FIRST OFFICER'S SEAT VERY DIFFICULT TO ADJUST POSITION FORWARD AND AFT. SEAT WILL NOT MOVE INTO ANY OF THE FORWARD 15 POSITIONS EASILY. REMOVE AND REPLACED FIRST OFFICER AFT SEAT TRACKS. PER AMM 25-11-11 AND FIRST OFFICER SEAT PER AMM 25SDR AALA202401169367Hinge · lack of lubeAIRCRAFT WAS NOT GROUNDED: AIRCRAFT LEFT AFT LAVATORY DOOR IS DIFFICULT TO OPEN AND CLOSE. CLEANED AND LUBED AFT LEFT LAVATORY DOOR HINGES PER MM 25-00-00. OPERATIONAL CHECK GOODSDR AALA202401160887Hinge · out of adjustAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR DIFFICULT TO OPEN AND CLOSED. ADJUSTED AFT LAVATORY DOOR HINGE. PER CDA AMM 25-44-49. OPERATIONAL CHECK GOOD.SDR AALA202401198931Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR SUPPORT INTERCOSTAL AT STA 291. BL 0. REPLACED INTERCOSTAL PER AARD 51-40-02.SDR AALA202401196584Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR SUPPORT INTERCOSTAL AT STA 321. RBL 32. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202401161949Flashlight · faultyAIRCRAFT WAS NOT GROUNDED: FOUND FLASHLIGHT AFT LEFT INBOARD FLIGHT ATTENDANT SEAT REQUIRES REPLACEMENT. INSTALLED FLASHLIGHT AT FLIGHT ATTENDANT AFT INBOARD SEAT PER AMM 25-64-00.SDR AALA202401160315Pressure Switch · faultedAIRCRAFT WAS NOT GROUNDED: DURING CLIMB OUT, ENGINE NUMBER 2 AFT FUEL PUMP ILLUMINATED. AS PER FIM TASK 28-22-00-810-805, REMOVE AND REPLACED TANK 2 AFT BOOST PUMP LOW PRESSURE SWITCH. PER AMM 28-42-11. OPERATIONAL CHECK GOOD.SDR AALA202401173519Strap · looseAIRCRAFT IN BASE MAINTENANCE: STRINGER STRAP AT MAIN CABIN BS 827 STR 14R IS LOOSE. RE-SECURED STRINGER STRAP AT MAIN CABIN FROM BS 827 STR 14R. PER B-737NG SRM 51-30-10-OG.SDR AALA202401173063Strap · looseAIRCRAFT IN BASE MAINTENANCE: STRINGER STRAP IN MAIN CABIN AT BS 827 STR 14R STRAP IS LOOSE. RE-SECURED STRINGER STRAP AT MAIN CABIN FROM BS 827 STR 14R. PER B-737NG SRM 51-30-10-OG.SDR AALA202401174590Strap · looseAIRCRAFT IN BASE MAINTENANCE: STRINGER STRAP IN MAIN CABIN BS 800 STR 14L TO 16L IS LOOSE. RE-SECURED STRINGERS STRAPS FROM BS 800 STR 14L TO 16L. PER B-737NG SRM 51-30-10-OG.SDR AALA202401177424Strap · looseAIRCRAFT IN BASE MAINTENANCE: STRINGER STRAP IN MAIN CABIN BS 800 STR 14L TO 16L IS LOOSE. RE-SECURED STRINGERS STRAPS FROM BS 800 STR 14L TO 16L. PER B-737NG SRM 51-30-10-OG.SDR AALA202401178371Strap · looseAIRCRAFT IN BASE MAINTENANCE: STRINGER STRAP IN MAIN CABIN BS 787 STR 5L IS LOOSE. RE-SECURED STRINGER STRAP AT MAIN CABIN FROM BS 787 STR 5L. PER B-737NG SRM 51-30-10-OGSDR AALA202401172143Strap · looseAIRCRAFT IN BASE MAINTENANCE: STRINGER STRAP IN MAIN CABIN BS 727G STR 5R IS LOOSE. RE-SECURED STRAP ON MAIN CABIN BS 727G STR 5R. PER B737-NG-SRM 51-30-10-0G.SDR AALA202401179223Strap · looseAIRCRAFT IN BASE MAINTENANCE: STRINGER STRAP IN MAIN CABIN BETWEEN BS 727B TO 727C AND STR 6R TO 7R IS LOOSE. RE-SECURED STRINGERS STRAPS AT MAIN CABIN BETWEEN BS 727B AND 727C STR 6R AND 7R. PER B-73NG SRM 51-30-10-OG.SDR AALA202401177914Strap · looseAIRCRAFT IN BASE MAINTENANCE: STRINGER STRAP IN MAIN CABIN BETWEEN BS 727B TO 727C AND STR 6R TO 7R IS LOOSE. RE-SECURED STRINGERS STRAPS AT MAIN CABIN BETWEEN BS 727B TO 727C AND STR 6R TO 7R. PER B-73NG SRM 51-30-10-OG.SDR AALA202401167833Bracket · lack of lubeAIRCRAFT WAS NOT GROUNDED: 1L DOOR SLIDE GIRT BAR IS DIFFICULT TO REMOVE FROM ARMING BRACKETS. CLEANED AND LUBRICATED L1 DOOR GIRT BAR FLOOR MOUNT ARMING BRACKET PER AMM 25-66-02.SDR AALA202401168456Plate · misinstalledAIRCRAFT WAS GROUNDED: CAPTAIN SLIDING WINDOW FORWARD FRAME REINFORCEMENT PLATE RIVET INSTALLED INCORRECTLY. NEW SCUFF PLATE WITH SHIM INSTALLED. PER AMM 56-11-11SDR AALA202401165685Bracket · out of adjustAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS THAT THE RIGHT BRACKET ON THE FORWARD SERVICE DOOR IS TO TIGHT AND RESTRICTS ARMING AND DISARMING OF THE EXIT SLIDE. ADJUSTED FORWARD LEFT DOOR BRACKET. PER AMM 20-00-00.SDR AALA202401165407Door · out of adjustAIRCRAFT WAS NOT GROUNDED: AFT LAVATORY D DOOR IS HARD TO LOCK AND UNLOCK. READJUSTED LAVATORY DOOR DSDR AALA202401120409Light · looseAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTED SEAT 16C EMERGENCY LIGHT WAS LOOSE. RESECUREDD SEAT 16C EMERGENCY LIGHT PER MM 33-51-11. OPERATIONAL CHECK GOOD.SDR AALA202401125880Acm · damagedAIRCRAFT WAS GROUNDED: DURING CLIMB OUT OF MIA ENGINE ANTI ICE WAS TURNED ON A VERY STRONG ODOR OF BURNED OIL PERMEATED BOTH COCKPIT AND CABIN. ENGINE ANTI ICE WAS SELECTED OFF, THE ODOR DISSIPATED. FOUND (ACM) AIR CYCLE MACHINE BLADES DAMAGED AND BROKEN. REMOSDR AALA202401122815Battery · dischargedAIRCRAFT WAS NOT GROUNDED: FORWARD FLIGHT ATTENDANT FLASHLIGHT BATTERY LOW. REMOVED AND REPLACED FORWARD FLIGHT ATTENDANT FLASHLIGHT BATTERY. PER AMM 25-64-00.SDR AALA202401129647Link Pin · corrodedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND MAIN GEAR REACTION LINK PIN FOUND CORROSION AND PAINT IN POOR CONDITION. INSTALLED SERVICEABLE REACTION LINK PIN. PER AMM 32-11-71.SDR AALA202401122208Selector · inoperativeAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: PRESSURIZATION AUTO FAIL ILLUMINATED. ALTERNATE MODE FAILED AS WELL, AND CABIN PRESSURIZATION WAS UNCONTROLLABLE IN MAN MODE. AIRCRAFT DIVERTED AND LANDED SAFELY AT CLT WITHOUT FURTHER INCIDENT. REPLACEDSDR AALA202401126766Door · out of adjustAIRCRAFT WAS GROUNDED: FORWARD LAVATORY DOOR DIFFICULT TO OPEN. READJUSTED FORWARD LAVATORY DOOR AS REQUIRED. OPERATIONAL CHECK GOOD. PER AMM 52-00-00.SDR AALA202401127658Sign · wrong partAIRCRAFT WAS GROUNDED: FLIGHT ATTENDANT STATES WRONG EXIT SIGNS INSTALLED ABOVE AISLE IN AFT GALLEY. REPLACE EXIT SINGS ABOUT AISLE AFT GALLEY. PER AMM 33-50-00. OPERATIONAL CHECKS NORMAL.SDR AALA202401128162Stop Fitting · damagedAIRCRAFT WAS GROUNDED: REF MIC# 1062114. L1 DOOR FUSELAGE PRESSURE STOP FITTING REPAIR REQUIRES EA FOR FINAL SIGN OFF. ACCOMPLISHED PERMANENT REPAIR OF FUSELAGE PRESSURE STOP FITTING PER SRM 53-10-15-1A-1. OK FOR SERVICE AT THIS TIME.SDR AALA202401120182Sign · detachedAIRCRAFT WAS NOT GROUNDED: AFT EMERGENCY EXIT OVERHEAD SIGN, ROW 16 FEEL OFF. REINSTALLED FORWARD EMERGENCY CEILING EXIT SIGN LENS AT ROW 16. PER AMM 33-51-01.SDR AALA202401123434Battery · missingAIRCRAFT WAS NOT GROUNDED. REF MIC 1062228 FLASHLIGHT MISSING FOR FLIGHT ATTENDANT SEAT 4R AISLE. **SUPPLEMENTAL REPORT FOR (AALA202401113434): REMOVED AND REPLACED FLASHLIGHT BATTERY. PER AMM 25-64-00, OPERATIONAL CHECK GOOD**(CLOSED).SDR AALA202401122634Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT DOOR CUTOUT AFT SHIELD FROM STA 490 TO STA 500A, RBL 64. REPLACED SHIELD PER SRM 53-00-53-2R-6.SDR AALA202401127912Fitting · 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.SDR AALA202401126874Fitting · 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.SDR AALA202401122249Fitting · 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.SDR AALA202401127016Fitting · 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.SDR AALA202401128907Fitting · 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.SDR AALA202401127502Fitting · 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.SDR AALA202401125761Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND LBL 15.04. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202401123986Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND LBL 32.40. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202401124541Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND LBL 40.87. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202401120566Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND LBL 54.60. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202401111385Door · out of adjustAIRCRAFT WAS GROUNDED: L1 DOOR OUT OF RIG, VERY DIFFICULT TO CLOSE FROM THE INSIDE. ADJUSTED UPPER GUIDE ARM. PER AMM 52-11-00-820-801 (STEP H). OPERATIONAL CHECK GOOD.SDR AALA202401113434Flashlight · missingAIRCRAFT WAS NOT GROUNDED. REF MIC 1062228 FLASHLIGHT MISSING FOR FLIGHT ATTENDANT SEAT 4R AISLE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202402069789Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 101.90, 9 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202401116870Unknown · odorAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: FLIGHT ATTENDANTS SMELT AN ODOR AND FELT NAUSEOUS. AIRCRAFT RETURN TO AND LANDED SAFELY AT MIA WITHOUT FURTHER INCIDENT. ACCOMPLISHED W/C 08L00021001, NO ODOR NOR FUMES NOTED. NO FAULT FOUND.SDR AALA202401113570Door · out of adjustAIRCRAFT WAS NOT GROUNDED: THE FORWARD LAVATORY DOOR STICKS CLOSED AT THE LOWER VERTICAL EDGE. PERFORMED DOOR ADJUSTMENT. PER AMM 25-40-00, OPERATIONAL CHECK GOOD. OK FOR SERVICE.
Back to Boeing 737-823