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 AALA202510068691Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT RIGHT HAND INBOARD FLIGHT ATTENDANTS FLASHLIGHT INOPERATIVE. REMOVE AND REPLACED AFT RIGHT HAND INBOARD FLIGHT ATTENDANTS FLASHLIGHT BATTERY. PER AMM 25-64-00. OPERATIONAL CHECK GOOD.SDR AALA202510061881Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: BOTH OF THE FORWARD FLIGHT ATTENDANT SEAT FLASHLIGHTS NEED REPLACEMENT. REMOVE AND REPLACED 2EA BATTERY (AALA202510061881) (AALA202510062495) INSIDE OF THE EMERGENCY FLASHLIGHT. PER JOB CARD 08C20025008. OPERATIONAL CHECK GOOD.SDR AALA202510062495Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: BOTH OF THE FORWARD FLIGHT ATTENDANT SEAT FLASHLIGHTS NEED REPLACEMENT. REMOVE AND REPLACED 2EA BATTERY (AALA202510061881) (AALA202510062495) INSIDE OF THE EMERGENCY FLASHLIGHT. PER JOB CARD 08C20025008. OPERATIONAL CHECK GOOD.SDR AALA202510060482Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER UPPER ATTACH ANGLE INBOUND CHORD, IN RIGHT HAND ECS BAY AFT BULKHEAD LOCATED AT BS 663, FROM RBL 5 TO RBL 15. REPAIRED PER SRM 57-10-10-2R-5.SDR AALA202510295385Rod · excess playAIRCRAFT WAS NOT GROUNDED: LEFT WING, BETWEEN SPOILER NUMBER 5 AND 6, AFT OF AFT SPAR, INBOARD SIDE BOTH RODS HAVE EXCESSIVE PLAY. REMOVED AND REPLACED BEAM ASSEMBLY AT LEFT WING. PER B737NG SRM 51-40-02, SRM 51-40-05, SRM 51-20-01.SDR AALA202510237549Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT STA 312, LBL 43. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202510237031Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT STA 312, LBL 10. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202510201195Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE WEB AT BS 990, LBL 37. REPAIRED WEB PER EA 368782.SDR AALA202510139781Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 277 TO BS 294.5 AT RBL 2. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202510094717Bulkhead · crackedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND ECS BAY AFT BULKHEAD UPPER INBOARD CHORD CRACKED. REPAIRED RIGHT HAND ECS BAY AFT BULKHEAD UPPER INBOARD CHORD. PER B737 SRM 57-10-10-2R-5.SDR AALA202510078435Shield · corrodedAIRCRAFT WAS GROUNDED: CORROSION ON AFT CARGO COMPARTMENT SHIELD BETWEEN BS 767 AND BS 787 AT S25L. REPLACED SHIELD PER AARD 51-00-05-1.SDR AALA202510077974Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE BREAK ASSEMBLY PANEL AT BS 540, LBL 0. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-1.SDR AALA202510073392Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE BREAK ASSEMBLY PANEL AT BS 540, RBL 0. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-1.SDR AALA202510068509Light · dislodgedAIRCRAFT WAS NOT GROUNDED: EMERGENCY AISLE LIGHT AT ROW 20ABC DISLODGED. REMOVED AND REPLACED EMERGENCY ISLE LIGHT AT ROW 20ABC. PER AMM33-51-03. OPERATIONAL CHECK GOOD.SDR AALA202510060206Sign · dislodgedAIRCRAFT WAS NOT GROUNDED: EXIT SIGN COVER FELL OFF AT AFT RIGHT EXIT DOOR. INSTALLED EXIT SIGN COVER AT RIGHT REAR DOOR. PER MM 33-51-01.SDR AALA202510067416Light · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT A T SE8C INOPERATIVE. VERIFY EMERGENCY LIGHT AT 8C INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHT 8C EMEREMERGENCY ESCAPED PATH LIGHTING. PER AMM 33-51-00-710-801. OPERATIONAL CHECK GOOD.SDR AALA202510037416Light · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT AT SEEAT 8C INOPERATIVE. VERIFY EMERGENCY LIGHT AT 8C INOPERATIVE. (OPEN).SDR AALA202510039037Mechanism · out of adjustAIRCRAFT WAS NOT GROUNDED: R1 DOOR GIRT BAR LOOSE IN BRACKET RECEIVER RIGHT SIDE. AJUSTED GIRT BAR SECURITY CLIPS ON R1 DOOR. OPERATIONALCHECK GOOD. PER AMM 52-11-00.SDR AALA202510033716Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR IS DIFFICULT TO OPEN. CLEANED DEBRIS AND LUBED DOOR, OPERATIONAL CHECK GOOD.SDR AALA202510235097Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR BEAM UPPER CHORD (T-CAP) LOCATED AT BS 947.5, FROM LBL 51 TO LBL 53. REPAIRED CHORD PER SRM 53-70-51-2R-5 AND EA 368713.SDR AALA202510203273Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL BETWEEN BS 947.5 AND BS 967 AT LBL 51. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202510159445Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL BETWEEN BS 947 AND BS 967 AT RBL 25. REPLACED INTERCOSTAL PER SRM 53-70-51-1A.SDR AALA202510138998Frame Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN R1 DOOR SURROUND FORWARD STUB FRAME ANGLE AT BS 296. REPLACED ANGLE PER SRM 51-40-02SDR AALA202510139306Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT BS 950, RBL 25. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202510071405Window · scratchedAIRCRAFT IN BASE MAINTENANCE: CABIN FUSELAGE EXTERIOR WINDOW L-18 AT THE FORWARD EMERGENCY EXIT DOOR, THE WINDOW HAS SCRATCHES. REMOVED AND REPLACED WITH AIR WORTHY WINDOW. PER AMM 56-22-00-400-801.SDR AALA202510077018Window · scratchedAIRCRAFT IN BASE MAINTENANCE: CABIN FUSELAGE EXTERIOR WINDOW L-19 AT THE AFT EMERGENCY EXIT DOOR, THE WINDOW HAS SCRATCHES. REMOVED AND REPLACED AIRWORTHY WINDOW. PER AMM 56-22-00-400-801.SDR AALA202510060195Tube · missingAIRCRAFT WAS NOT GROUNDED: FORWARD SERVICE DOOR RIGHT SIDE OF GIRT BAR MISSING RED COVER. CONFIRMED RED HEAT SHRINK MISSING R1 GIRT BAR. INSTALLED HEAT SHRINK TUBING ON R1 SERVICE DOOR GIRT BAR. PER AARD 25-66-00-4.SDR AALA202510046556Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER UPPER ATTACH ANGLE, IN RIGHT HAND IN BOARD ECS BAY, LOCATED AT BS 663, FROM RBL 5 TO RBL 15. REPAIRED PER SRM 57-10-10-2R-5.SDR AALA202510046476Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER IN WHEEL WELL, AT STA 663, LBL 47. REPAIRED VAPOR BARRIER PER AARD 57-10-10-9 AND SRM 57-10-10-2R-2.SDR AALA202510044149Skin · corrodedAIRCRAFT WAS GROUNDED: CORROSION ON FUSELAGE SKIN AROUND LAVATORY VENT LOCATED AT BS 917, FROM S21L TO S22L. ACCOMPLISHED DOUBLER REPAIR TO SKIN PER SRM 53-70-01-2R-3.SDR AALA202510035477Landing Gear · faultedAIRCRAFT WAS GROUNDED: THE GEAR FAILED TO RETRACT AFTER TAKEOFF ALL RED DOOR LIGHTS AND GREEN GEAR LIGHTS WERE ILLUMINATED. WE RAN THE LANDING GEAR DISAGREE CHECK LIST TWICE THE GEAR RETRACTED WHEN THE FIRST OFFICER HELD THE MANUAL GEAR EXTENSION DOOR CLOSED.SDR AALA202510036411Liner · unsecureAIRCRAFT WAS NOT GROUNDED: FLAP OF MATERIAL HANGING FROM DOOR SLIDE PACK ON DOOR 2L. RESECURED L2 GIRT BAR FLAPPER. PER AMM 52-10-00.SDR AALA202510031366Door · jammedAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANTS REPORT THE LAVATORY DOOR ON AFT RIGHT SIDE JAMS AT TOP OF FRAME. APPLIED LUBRICANT TO AFT RIGHT HAND LAVATORY DOOR. OPERATIONALCHECK GOOD. PER AMM 20-30-21.SDR AALA202510037807Mechanism · out of adjustAIRCRAFT WAS NOT GROUNDED: GIRT BAR ON FORWARD ENTRY DOOR RED PLASTIC RIGHT SIDE IS DIFFICULT TO LOCK INTO PLACE. ADJUSTED GIRT BAR. ON L1 DOOR. CYCLED AND ARMED DOOR GIRT BAR OPERATIONAL CHECK GOOD.SDR AALA202510030195Cover · missingAIRCRAFT WAS NOT GROUNDED: FORWARD SERVICE DOOR RIGHT SIDE OF GIRT BAR MISSING RED COVER. CONFIRMED RED HEAT SHRINK MISSING R1 GIRT BAR. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202510033115Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR STICKS. ADJUSTED FORWARD LAVATORY DOOR. OPERATIONAL CHECKS GOOD.SDR AALA202510033480Latch · out of adjustAIRCRAFT WAS NOT GROUNDED: LATCH ON FORWARD LAVATORY DOOR STICKS MAKING DOOR DIFFICULT TO OPEN. ADJUSTED FORWARD LAVATORY DOOR HANDLE AND LATCH. PER MM 25-40-11.SDR AALA202510024810Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER SECTION REAR SPAR VAPOR BARRIER, IN LEFT WHEEL WELL, LOCATED AT BS 663, FROM LBL 24.92 TO LBL 31.83. REPAIRED VAPOR BARRIER PER SRM 57-10-10-2R-2 AND AARD 57-10-10-9.SDR AALA202510260057Cargo Track · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT AFT BULKHEAD LOWER LOBE RAIL ASSEMBLY AT BS 5001, RBL 25. INSTALLED REPAIR ANGLE PER SRM 51-40-02 AND EA 368853.SDR AALA202510232010Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE Z ANGLE AT STA 986 PLUS 6 INCHES, AT LBL 32. REPLACED ANGLE PER AARD 51-00-05-1.SDR AALA202510201127Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT SHIELD AT BS 440 RBL 24.5. REPLACED SHIELD PER AARD 51-00-05-1.SDR AALA202510202233Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR BEAM UPPER CHORD (T-CHORD) LOCATED AT BS 947, LBL 50. REPAIRED UPPER CHORD PER SRM 53-70-51-2R-5.SDR AALA202510204390Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT SHIELD FROM BS 498 TO BS 500 PLUS 14 INCHES, AT RBL 24. REPLACED SHIELD PER AARD 51-00-05-1.SDR AALA202510200949Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT DOOR THRESHOLD WEB FROM BS 456 TO BS 491 AT RBL 31. REPLACED WEB PER AARD 51-00-05-1.SDR AALA202510131540Skin · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO FUSELAGE LOWER SKIN AROUND DRAIN HOLE AT BS 727J, S27R. REPAIRED SKIN PER SRM 53-60-01-2 -R-4.SDR AALA202510131080Skin · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO FUSELAGE LOWER SKIN AROUND DRAIN HOLE AT BS 727L, BL 0. REPAIRED SKIN PER SRM 53-60-01-2 -R-4 AND EA 368857.SDR AALA202510131599Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER ATTACH ANGLE LOCATED AT BS 663.75 RBL 36. REPAIRED ANGLE PER SRM 57-10-10-2R-5.SDR AALA202510070029Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE BREAK ASSEMBLY PANEL AT BS 540, LBL 6. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-1.SDR AALA202510074803Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT BS 354, S17L, LBL 11. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202510020342Door · jammedAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS LAVATORY DOOR ON AFT RIGHT SIDE JAMS AT TOP OF FRAME. RETIGHT LOOSE SCREW AT AFT RIGHT SIDE LAVATORY DOOR TOP FRAME. PER AMM 25-40-00. OPERATIONAL CHECK GOOD.
Back to Boeing 737-823