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 AALA202103259015Sign · dislodgedAIRCRAFT WAS NOT GROUNDED: EXIT ROW EXIT SIGN HAS FALLEN DOWN. REINSTALLED SIGN PER AMM 33-51-00. OPS CK NORMALSDR AALA202103279010Battery · inoperativeAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTS INOPERATIVE AT RH OVERWING EXITS. REPLACED BATTERY PACK IAW AMM 33-51-06-960-805.SDR AALA202103249009Battery Pack · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHTS INOPERATIVE AT RIGHTHAND OVERWING EXITS. REPLACED BATTERY PACK PER AMM 33-51-06-960-805..SDR AALA202107138303Fitting · damagedAIRCRAFT IN BASE MAINTENANCE: ELONGATED HOLES ON SEAT TRACK VERTICAL SPLICE FITTING LOCATED AT STA 887 AND LBL 45.5.SDR AALA202107133131Angle · damagedAIRCRAFT IN BASE MAINTENANCE: ELONGATED HOLES ON MAIN CABIN FLOOR SEAT TRACK CARRY THRU ANGLE LOCATED AT STA 887 AND LBL 24.75. REPAIRED PER EA 326152.SDR AALA202103239008Track · lack of lubeAIRCRAFT IN BASE MAINTENANCE: L2 WINDOW VERY DIFFICULT TO STOW FROM FULL AFT POSITION. LUBRICATED WINDOW TRACKS IAW AMM 56-12-11, OPS CHECK GOOD.SDR AALA202103239014Bracket · looseAIRCRAFT WAS NOT GROUNDED: SLIDE COVER GIRT BAR BRACKET IS LOOSE AT 4L DOOR. ADJUSTED GIRT BAR RETAINERS PER AMM 25-66-01.SDR AALA202103239006Girt Bar · stuckAIRCRAFT WAS NOT GROUNDED: FORWARD RIGHT SERVICE DOOR WILL NOT ARM, GIRT BAR STUCK. ADJUSTED GIRT BAR CLIPS PER AMM 25-66-00.SDR AALA202103239015Bracket · looseAIRCRAFT WAS NOT GROUNDED: FORWARD ENTRY GALLEY DOOR GIRT BAR BRACKET IS LOOSE RIGHT SIDE. TIGHTENED RIGHT SIDE GIRT BAR BRACKET OPERATIONS CHECKED NORMAL.SDR AALA202103239011Cover · unsecureAIRCRAFT WAS NOT GROUNDED: CEILING EXIT SIGN COVER BETWEEN SEAT ROWS 16 AND 17 DETACHED. RESECURED CEILING EXIT SIGN COVER BETWEEN SEAT ROWS 16 AND 17.SDR AALA202103239007Contact · dirtyAIRCRAFT IN BASE MAINTENANCE: BELOW AFT STATION SEATS LEFT SIDE OF AIRCRAFT FLASH LIGHTS INOPERATIVE. REMOVED AND CLEANED POGO CONTACTS ON BOTH AFT LEFT FLIGHT ATTENDANT EMERGENCY FLASHLIGHTS PER SOPM 20-30-03.SDR AALA202103229008Window · delaminatedAIRCRAFT WAS NOT GROUNDED: R1 WINDOW HAS DELAMINATION DAMAGE IN UPPER LH CORNER. PLEMENTAL REPORT: REPLACED R1 WINDOW WITH SERVICEABLE UNIT IAW B737 AMM 56-11-11 AND WORKCARD 08L21056004, LEAK AND OPS CHECK GOOD.SDR AALA202103239016Cap · looseAIRCRAFT WAS NOT GROUNDED: PLASTIC CAP CONTAINING ESCAPE PATH LIGHT NEEDS TO BE SECURED AT THE BOTTOM OF SEAT 20C. SECURED ESCAPE PATH LIGHT PLASTIC CAP AT 20C IAW CMM 25-23-67, OPS CHECK GOOD.SDR AALA202103229022Shroud · looseAIRCRAFT WAS NOT GROUNDED: ESCAPE PATH LIGHTING ASSEMBLY CAME LOOSE AT 17C. REPLACED EMERGENCY PATH LIGHT SHROUD AT 17C PER ESO61106.SDR AALA202103229025Washer · missingAIRCRAFT WAS NOT GROUNDED: PLASTIC WASHER MISSING ON RIGHT SIDE OF GIRT BAR ON 1R DOOR. INSTALLED NEW RELEASE STOP ASSEMBLY ON 1R DOOR GIRT BAR IAW AMM 25-66-01.SDR AALA202103229024Latch · out of adjustAIRCRAFT WAS NOT GROUNDED: FWD LAVATORY DOOR CATCHES THRESHOLD PLATE INFLIGHT, DOOR UNABLE TO BE OPENED FROM INSIDE. ADJUSTED FWD LAVATORY DOOR LATCH IAW AMM 20-50-11, OPS CHECK GOOD.SDR AALA202103319016Lamp · inoperativeAIRCRAFT WAS GROUNDED DUE TO FLIGHT SCHEDULE REDUCTION: LEFT HAND OVERWING FORWARD SLIDE EXTERIOR LIGHT INOPERATIVE. **SUPPLEMENTAL REPORT: RELAMPED LEFT FORWARD OVERWING EXIT LIGHT AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-04SDR AALA202103239012Door · out of adjustAIRCRAFT WAS GROUNDED: LEFT AFT LAVATORY DOOR LOCK IS DIFFICULT TO OPERATE. ADJUSTED LAVATORY DOOR IAW AARD 25-40-10. FUNCTIONAL CHECK GOOD.SDR AALA202103229021Battery Pack · dischargedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHT POWER SUPPLY BATTERY PACK INOPERATIVE. CHARGED BATTERY PACK IAW AMM 33-51-06, OPS CHECK GOOD.SDR AALA202103229026Floor Panel · damagedAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS FLOOR BY 2E AND 2F APPEARS TO BE DAMAGED. FLOOR MAKES A CRACKING SOUND UNDER FOOT. REPAIRED FLOOR PANEL PER AARD 53-00-00-6.SDR AALA202103199013Connector · damagedAIRCRAFT WAS GROUNDED: INDICATED AIRSPEED DISAGREE ON PRIMARY FLIGHT DISPLAY PASSING 16000-17000 FT AND DURING DESCENT, FLIGHT DECLARED EMERGENCY AND LANDED WITHOUT FURTHER INCIDENT. REPLACED CONNECTOR D644 WITH NEW IAW SWPM 20-60-00 AND REPLACED WINDOW/PITOTSDR AALA202103249011Cusp Web · crackedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN STA 948 LEFT CUSP WEB IS CRACKED. REMOVED AND REPLACED INTERCOSTAL WEB PER BAC DWG 147A8510 REVISION A AND EA 325867.SDR AALA202103199020Light · unsecureAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT ROW LIGHTING TRIM MISSING AT SEAT 21C. SECURED LIGHT ASSEMBLY IAW AMM 33-51-00, OPS CHECK GOOD.SDR AALA202103199018Cover · dislodgedAIRCRAFT WAS NOT GROUNDED: ESCAPE PATH LIGHTING COVER DISLODGED AT SEAT 20C. SECURED LIGHT COVER IAW AMM 33-51-11, OPS CHECK GOOD.SDR AALA202103199019Lens · unsecureAIRCRAFT WAS NOT GROUNDED: AFT LEFT SERVICE DOOR EMERGENCY EXIT SIGN FELL OFF. SECURED R4 CABIN DOOR EMERGENCY LIGHT LENS.SDR AALA202103199017Girt Bar · dirtyAIRCRAFT WAS NOT GROUNDED: FORWARD SERVICE DOOR 1R DOOR SLIDE DIFFICULT TO ARM AND DISARM. CLEANED AND LUBED FWD SERVICE DR 1R GIRT BAR LATCHES.SDR AALA202104079009Attach Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF ATTACH ANGLE IN FWD CARGO AT RH SIDEWALL AND AFT BULKHEAD, AT STA 500I BETWEEN STR 19R AND 25R, MEASURING L=1.5 IN, W=1.5IN, D=0.072 IN. REPLACED ANGLE WITH NEW IAW SRM 53-00-53-1A.SDR AALA202104019017Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO FLOOR STRUCTURE RIGHTHAND TRANSITION ANGLE LOCATED FROM BS 500A TO BS 500I AT RBL 26. REPLACED TRANSITION ANGLE PER SRM 53-00-53-2R.SDR AALA202104019018Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: FORWARD CARGO FLOOR STRUCTURE LEFT TRANSITION PANEL CORRODED FROM STA 480 TO STA 500. TRANSITION PANEL REPLACED AND SPLICED PER SRM 53-00-53-2R.SDR AALA202104019019Crease Beam · corrodedAIRCRAFT IN BASE MAINTENANCE: FOUND CORROSION ON CREASE ANGLE FROM STA 960 TO STA 1000 AND RBL48. REMOVED AND REPLACED CREASE ANGLE REF SRM 53-70-51.SDR AALA202103309016Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FOUND ON FLOOR BEAM STA 987, LEFT BUTT LINE 64. REMOVED CORROSION BY OVERSIZED DRILLING AND INSTALLED REINFORCING REPAIR PER EA 326386.SDR AALA202103249012Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF INTERCOSTAL BETWEEN STA 951 AND STA 967 AT LBL 24, MEASURING L=1.0 IN, W=1.0 IN, D=0.038 IN. REPLACED INTERCOSTAL WITH NEW IAW SRM 51-40-02.SDR AALA202103189012Fitting · leakingAIRCRAFT WAS GROUNDED: HYDRAULIC SYSTEM A QUANTITY DECREASED STEADILY AFTER TAKEOFF TO 65%, FLIGHT DIVERTED TO SJU. REPLACED FITTING ON #6 SPOILER INBD ACTUATOR IAW AMM 27-61-51, LEAK AND OPS CHECK GOOD.SDR AALA202103179011Indicator · unsecureAIRCRAFT WAS NOT GROUNDED: SLIDE PRESSURE INDICATOR COVER IS DAMAGED AND COULD PUNCTURE THE SLIDE ON FORWARD ENTRY DOOR. RESECURED FORWARD DOOR L1 PRESSURE INDICATOR PLASTIC.SDR AALA202103189014Relay · inoperativeAIRCRAFT WAS GROUNDED: DUAL AUTOPILOT FAILURE, FLIGHT RETURNED TO FIELD. REPLACED STABLIZER TRIM CONTROL RELAY R64 IAW FIM 22-13-00-810-818, OPS CHECK GOOD.SDR AALA202103159006Hinge · stickingAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR BINDS WHEN OPENED OR CLOSED. REMOVED AND REPLACED FORWARD LAVATORY DOOR HINGE PER AMM 52-00-00.SDR AALA202103199024Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF MAIN CABIN FLOORBEAM T CAP AT STA 947 AND LBL 26.5, MEASURING L=3.6 IN, W=1.2 IN, D=0.078 IN. REPLACED T CAP WITH NEW IAW SRM 53-70-51-2R-5.SDR AALA202103199023Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF MAIN CABIN FLOORBEAM T CAP AT STA 947 AND LBL 49.5, MEASURING L=4.0 IN, W=2.2 IN, D=0.08 IN. REPLACED T CAP WITH NEW IAW SRM 53-70-51-2R-5.SDR AALA202103199022Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF T CAP ON MAIN CABIN FLOORBEAM AT STA 947 BETWEEN RBL 54 AND LBL 54, MEASURING L=2.0 IN, W=2.2 IN, D=0.077 IN. REPLACED T CAP WITH NEW IAW SRM 53-70-51-2R -5.SDR AALA202103199025Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: FOUND CORROSION ON MAIN CABIN FLOOR BEAM FLANGE, FORWARD SIDE, AT STA 986.5 AND LBL 44.5 TO RBL 44.5 REMOVED CORROSION FOUND TO BE OUT OF LIMITS IAW B737NG 53-70-51-12. REMOVED AND REPLACED ENTIRE "T" CAP IAW B737NG SRM 53-70-51-2SDR AALA202103169006Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: FOUND CRACKED INTERCOSTAL BETWEEN STA 312 AND 328 AT LBL 46.25. REPLACED INTERCOSTAL PER SRM 51-00-05.SDR AALA202103159031Fastener · shearedAIRCRAFT IN BASE MAINTENANCE: L1 DOOR AFT GIRT BAR RETAINING HOOK HAS SHEARED FASTENER. REPLACED FASTENER IAW SRM B737 51-40-02.SDR AALA202103159024Cover · misalignedAIRCRAFT WAS NOT GROUNDED: REQUEST L1 DOOR SLIDE PACK BE INSPECTED FOR CORRECT INSTALLATION. INSPECTED L1 DOOR SLIDE PACK. FOUND DEPLOY CORD COVER MISS ALIGNED. SECURED COVER PER AMM 25-66-00.SDR AALA202103169005Floor Support · crackedAIRCRAFT WAS GROUNDED: CRACKED INTERCOSTAL FLOOR SUPPORT 1.2 INCH LONG TERMINATING AT NUTPLATE HOLE. INSTALLED NEW INTERCOSTAL PER AARD 51-00-05 AND BOEING DRAWING 141A5400 AND SRM 51-40-02-0G.SDR AALA202103169011Contact · out of positionAIRCRAFT IN BASE MAINTENANCE: EMERGENCY ESCAPE PATH LIGHTING INOPERATIVE AT SEATS 18-25ABC. RESEATED CONTACT #2 IN WIRE HARNESS CONNECTOR, OPS CHECK GOOD.SDR AALA202103169010Fuse · blownAIRCRAFT IN BASE MAINTENANCE: EMERGENCY ESCAPE PATH LIGHTING INOPERATIVE AT SEATS 8-14ABC. REPLACED FUSE WITH NEW AT POWER SUPPLY M1676, OPS CHECK GOOD.SDR AALA202103169009Fuse · blownAIRCRAFT IN BASE MAINTENANCE: R1 DOOR EXTERIOR SLIDE LIGHT INOPERATIVE. REPLACED FUSE WITH NEW AT POWER SUPPLY M2814, OPS CHECK GOOD.SDR AALA202103169008Fuse · blownAIRCRAFT IN BASE MAINTENANCE: R2 DOOR EXTERIOR SLIDE LIGHT INOPERATIVE. REPLACED FUSE WITH NEW AT POWER SUPPLY M1672, OPS CHECK GOOD.SDR AALA202103169004Seat Track · crackedAIRCRAFT IN BASE MAINTENANCE: FOUND 0.5 INCH CRACK ON CROWN BETWEEN SCALLOPS ON SEAT TRACK AT STA 847, WL 201 AND BL 24.75. PERFORMED SPLICE REPAIR REF SRM 53-00-52-2R-5.SDR AALA202103159039Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT FLASHLIGHTS NEED BATTERY REPLACED. REPLACED FLASHLIGHT BATTERY AT AFT RH INBOARD, AFT LH OUTBOARD (AALA202103159038), AND FWD LH OUTBOARD (AALA202103159020) IAW AMM 26-64-00, OPS CHECK GOOD.
Back to Boeing 737-823