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 AALA202401194165Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR BEAM UPPER CHORD AT STA 986.5, RBL 40. REPAIRED CHORD PER SRM 53-70-51-2R-6 ALTERNATIVE 4.SDR AALA202312261095Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: COCKPIT ENTRY DOOR ONLY OPENS APPROX 70% OF FULL OPEN. LUBRICATED COCKPIT DOOR . PER 52-51-01-200-801 OPERATIONAL CHECK GOOD.SDR AALA202312262784Cable · disconnectedAIRCRAFT WAS GROUNDED: SOME EMERGENCY LIGHTS INOPERATIVE. FOUND AND RECONNECTED EMERGENCY LIGHT FEEDER CABLE UNDER SEAT 20B. PER WDM 33-51-22. OPERATIONAL CHECK GOOD.SDR AALA202312269859Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: EXTERNAL EMERGENCY LIGHT BELOW L2 DOOR IS INOPERATIVE. RELAMPED EXIT EMERGENCY LIGHT BELOW L2 DOOR. PER AMM 33-51-04. OPERATIONAL CHECK GOOD.SDR AALA202312296761Bracket · faultyAIRCRAFT WAS GROUNDED: FORWARD ENTRY DOOR L1 INDICATOR LIGHT STAYS ILLUMINATED WHEN CLOSED. **SUPPLEMENTAL REPORT FOR (AALA202312266761): REMOVE AND REPLACED BRACKET FOR L1 DOOR SENSOR. PER IPC 52-11-00-02. OPERATIONAL CHECK GOOD. **(CLOSED)OD. .SDR AALA202312265070Light · inoperativeAIRCRAFT WAS NOT GROUNDED: RIGHT HAND AFT OVERWING SLIDE EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED RIGHT HAND AFT OVERWING SLIDE EMERGENCY LAMP. PER AMM 33-51-04.SDR AALA202312261914Girt Bar · unsecureAIRCRAFT WAS NOT GROUNDED: AFT EMERGENCY, EXIT DOOR ON AIRCRAFT LEFT ONCE DISARM, SHOWING A PIECE OF PLASTIC HANGING OUT. RESECURED GIRT BAR ON AFT LEFT EXIT DOOR. PER AMM 25-66-01.SDR AALA202312266761Unknown · unknownAIRCRAFT WAS GROUNDED: FORWARD ENTRY DOOR L1 INDICATOR LIGHT STAYS ILLUMINATED WHEN CLOSED. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202312268235Unknown · unknownAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AFTER TAKEOFF THE STABILIZER TRIM SYSTEM FAILED MANUAL TRIM SYSTEM OPERATED NORMALLY. AIRCRAFT DIVERTED AND LANDED SAFELY AT DFW WITHOUT FURTHER INCIDENT. FOUND MAIN CUT OUT SWITCH AND AUTOPILOT CUT OUT SDR AALA202312266950Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR DIFFICULT TO OPEN AND CLOSE. LUBED DOOR FACING AND LATCH.SDR AALA202312263928Door · malfunctionedAIRCRAFT WAS NOT GROUNDED: #1 FLIGHT ATTENDANT REPORTS FORWARD LAVATORY DOOR HARD TO OPEN AND CLOSE. INSTALLED CLIPS DOOR.SDR AALA202312263756Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL AT BS 500C, LBL 64. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202312264663Screw · missingAIRCRAFT WAS GROUNDED: FORWARD ENTRY DOOR LIGHT CAME ON DURING TAKEOFF ROLL. FLIGHT ATTENDANT SAID HANDLE CAME UP. REPLACED MISSING WASHER AND SCREW THAT HOLDS THE GUIDE ARM LINK RADIUS. PER AMM 52-11-21. OPERATIONAL CHECK GOOD.SDR AALA202312260929Proximity Sensor · out of adjustAIRCRAFT WAS NOT GROUNDED: L1 DOOR ILLUMINATED DURING TAKE OFF ROLL. ADJUSTED L1 FORWARD PROXIMITY SWITCH TARGET. PER AMM 52-71-11. L1 DOOR INDICATION OPERATIONAL CHECK GOOD.SDR AALA202312268280Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR DIFFICULT TO OPEN FROM OUTSIDE. LUBRICATED FLIGHT DECK DOOR.SDR AALA202401160077Floor Support · damagedAIRCRAFT IN BASE MAINTENANCE: ELONGATED FASTENER HOLES IN FORWARD CARGO COMPARTMENT FLOOR STRUCTURE INTERCOSTAL FROM STA 500C TO STA 500D, S26L REPLACED INTERCOSTAL PER SRM 51-40-02-G.SDR AALA202401163466Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT FLOOR STRUCTURE INTERCOSTAL FROM STA 500 TO STA 500A, S26L. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202401166013Floor Support · damagedAIRCRAFT IN BASE MAINTENANCE: ELONGATED FASTENER HOLES IN FORWARD CARGO COMPARTMENT FLOOR STRUCTURE INTERCOSTAL FROM STA 500G TO STA 500H, S26R REPLACED INTERCOSTAL PER SRM 51-40-02-G.SDR AALA202401089479Panel · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FLOORBOARD SUPPORT BREAK ASSEMBLY AT STA 540, RBL 1. REPLACED BREAK ASSEMBLY PER AARD 51-00-05-1.SDR AALA202401037007Engine · vibrationAIRCRAFT WAS GROUNDED: NUMBER 2 ENGINE VIBE 1.1 AT 76% N1, ACCOMPANIED WITH HUD JITTER BETWEEN 75-78% N1. TACTILE VIBE FELT IN FLOORBOARD AT SAME 75-78% N1.**SUPPLEMENTAL REPORT FOR (AALA202312227007): CORRECTED ENGINE VIBRATION DISCREPANCY IN ACCORDANCE WITHSDR AALA202312222013Door · out of positionAIRCRAFT WAS NOT GROUNDED: LAVATORY D DOOR LATCH IS DIFFICULT TO LOCK AND UNLOCK. REPOSITIONED LAVATORY DOOR AT LAVATORY D DOOR. CHECK NORMAL. PER AMM 25-40-14.SDR AALA202312227007Unknown · unknownAIRCRAFT WAS GROUNDED: NUMBER 2 ENGINE VIBE 1.1 AT 76% N1, ACCOMPANIED WITH HUD JITTER BETWEEN 75-78% N1. TACTILE VIBE FELT IN FLOORBOARD AT SAME 75-78% N1.**SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202312227374Door · out of adjustAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR DIFFICULT TO OPERATE. REPLACED 3 MISSING SCREWS ON THE TOP DOOR TRIM AND ADJUSTED THE BOTTOM TRIM AS REQUIRES.SDR AALA202312227103Girt Bar · looseAIRCRAFT WAS NOT GROUNDED: GIRT BAR ON FORWARD SERVICE DOOR IS LOOSE. SECURED AS REQUIRED.SDR AALA202312220151Gust Lock · brokenAIRCRAFT WAS GROUNDED: UPON ARRIVAL OPENING CABIN DOOR, GUST LOCK WAS BROKEN. MAINTENANCE REPLACED FORWARD ENTRY DOOR LATCH PIN PER AMM 52-11-21 AND 52-11-00.SDR AALA202312221617Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 54.60. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202312227141Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 40.87. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202312220130Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 32.40. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202312220321Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 6.14. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202312223838Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 32.40. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202312222149Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 40.87. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202312220424Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 54.60. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202312223907Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 15.04. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202312228993Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 6.14. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202312223432Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 15.04. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202401167280Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION AROUND FASTENER HOLES ON AFT CARGO COMPARTMENT TRANSITION PANEL FROM STA 727A TO STA 727B PLUS 12 INCHES, S25L. INSTALLED SPLICE REPAIR PER SRM 53-00-53-2R-5.SDR AALA202401163766Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION AROUND FASTENER HOLES ON AFT CARGO COMPARTMENT FLOOR STRUCTURE TRANSITION PANEL FROM STA 727A TO STA 727G, S25R. INSTALLED SPLICE REPAIR PER SRM 53-00-53-2R-5.SDR AALA202401166174Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION AROUND FASTENER HOLES ON AFT CARGO COMPARTMENT FLOOR STRUCTURE TRANSITION PANEL FROM STA 727B PLUS 10 INCHES TO STA 727G PLUS 10 INCHES, S25L. INSTALLED SPLICE REPAIR PER SRM 53-00-53-2R-5.SDR AALA202401164218Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION AROUND FASTENER HOLES ON AFT CARGO COMPARTMENT FLOOR STRUCTURE TRANSITION PANEL FROM STA 727G PLUS 10 INCHES TO STA 727H PLUS 4 INCHES, S25L. INSTALLED SPLICE REPAIR PER SRM 53-00-53-2R-5.SDR AALA202401168129Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION AROUND FASTENER HOLES ON AFT CARGO COMPARTMENT FLOOR STRUCTURE TRANSITION PANEL FROM STA 727H PLUS 4 INCHES TO STA 822, S25L. INSTALLED SPLICE REPAIR PER SRM 53-00-53-2R-5.SDR AALA202401160161Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION AROUND FASTENER HOLES ON AFT CARGO COMPARTMENT FLOOR STRUCTURE TRANSITION PANEL FROM STA 727G PLUS 10 INCHES TO STA 767, S25R. INSTALLED SPLICE REPAIR PER SRM 53-00-53-2R-5.SDR AALA202312268045Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR SUPPORT INTERCOSTAL FROM BS 344 TO BS 360, LBL 13, WL 206. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202312268177Pressure Deck · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VERTICAL PRESSURE DECK WEB AT BS 663, FROM LBL 34 TO LBL 35.25. REPAIRED WEB PER SRM 57-10-10-2R-3 ALT 1.SDR AALA202312222631Fseu · inoperativeAIRCRAFT WAS GROUNDED: SFLAP EXTENDED ONLY TO 1 DEGREES WITH NORMAL SYSTEM AND 9 WITH ALTERNATE. MAINTENANCE REPLACED THE FSEU IAW 27-51-00-81.SDR AALA202312223319Tube · missingAIRCRAFT WAS NOT GROUNDED: R1 DOOR SLIDE GIRT BAR MISSING HEAT SHRINK TUBING. **SUPPLEMENTAL REPORT FOR AALA202312213319: APPLIED MISSING HEAT SHRINK TUBING TO GIRT BAR AT R1 DOOR PER AARD 25-66-00.** (CLOSED)SDR AALA202312213546Lock · stuckAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR IS JAMMED SHUT. RESET LEFT AFT LAVATORY DOOR LOCK PER AMM 25-45-15.SDR AALA202312211783Handle · detachedAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR HANDLE DETACHED. REPLACED DOOR HANDLE ON FORWARD LAVATORY DOOR PER CMM 25-48-48.SDR AALA202312213954Flap · out of adjustAIRCRAFT WAS GROUNDED: L1 DOOR WON'T ARM. REMOVED SLIDE FROM DOOR TO ADJUST GIRT BAR FLAP.SDR AALA202312215897Girt Bar · looseAIRCRAFT WAS GROUNDED: FORWARD ENTRY DOOR GIRT BAR IS LOOSE. SECURED GIRT BAR ATTACHMENT.SDR AALA202312213319Tube · missingAIRCRAFT WAS NOT GROUNDED: R1 DOOR SLIDE GIRT BAR MISSING HEAT SHRINK TUBING. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)
Back to Boeing 737-823