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 AALA202509025401Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT FLASHLIGHT BATTERY NEEDS REPLACING. REMOVE AND REPLACED AFT FLASHLIGHT, OPERATIONAL CHECK GOOD. PER AMM 25-64-00.SDR AALA202509270655Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL LOCATED AT BS 500, RBL 33. REPLACED TRANSITION PANEL PER SRM 51-40-02-0G.SDR AALA202509272454Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL LOCATED FROM BS 500B TO BS 500I AT LBL 26. REPLACED TRANSITION PANEL PER SRM 51-10-02.SDR AALA202509254859Bushing · corrodedAIRCRAFT IN BASE MAINTENANCE: RIGHT ELEVATOR TAB CONTROL MECHANISM LOWER HARDWARE HAS EVIDENCE OF SURFACE RUST. REMOVED AND INSTALLED 2EA (AALA202509250670) AND (AALA202509254859) RIGHT ELEVATOR TAB CONTROL MECHANISM AFT BUSHING, PER AMM 27-31-34. PERFORMED SASDR AALA202509250670Bushing · corrodedAIRCRAFT IN BASE MAINTENANCE: RIGHT ELEVATOR TAB CONTROL MECHANISM LOWER HARDWARE HAS EVIDENCE OF SURFACE RUST. REMOVED AND INSTALLED 2EA (AALA202509250670) AND (AALA202509254859) RIGHT ELEVATOR TAB CONTROL MECHANISM AFT BUSHING, PER AMM 27-31-34. PERFORMED SASDR AALA202509250585Rail · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO FORWARD CARGO COMPARTMENT AFT BULKHEAD LOWER RAIL ASSEMBLY LOCATED AT BS 500I. REPLACED RAIL ASSEMBLY PER SRM 51-40-02-0G.SDR AALA202509122824Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR STRUCTURE SHIELD ASSEMBLY LOCATED FROM BS 787 TO BS 807 AT S25R. REPLACED SHIELD ASSEMBLY PER AARD 51-00-05-1.SDR AALA202509055050Stop Pad · out of positionAIRCRAFT IN BASE MAINTENANCE: LEFT HAND AFT OVERWING EXIT DOOR, AFT UPPER STOP PAD ROTATED OUT OF POSITION. ROTATED LEFT HAND AFT OVERWING EXIT DOOR, AFT UPPER STOP PAD TO PROPER POSITION. PER AMM 52-22-00-820-801.SDR AALA202509056807Stop Pad · out of positionAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND FORWARD OVERWING EXIT DOOR, AFT UPPER STOP PAD ROTATED OUT OF POSITION. ROTATED RIGHT HAND FORWARD OVERWING EXIT AFT UPPER STOP PAD TO PROPER POSITION. PER AMM 52-22-00-820-801.SDR AALA202509055193Stop Pad · out of positionAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND AFT OVERWING EXIT DOOR, AFT UPPER STOP PAD ROTATED OUT OF POSITION. ROTATED RIGHT HAND AFT OVERWING EXIT AFT UPPER STOP PAD TO PROPER POSITION. PER AMM 52-22-00-820-801.SDR AALA202509053749Stop Pad · out of positionAIRCRAFT IN BASE MAINTENANCE: LEFT HAND FORWARD OVERWING EXIT DOOR, AFT UPPER STOP PAD ROTATED OUT OF POSITION. ROTATED LEFT HAND FORWARD OVERWING EXIT DOOR, AFT UPPER STOP PAD TO PROPER POSITION. PER AMM 52-22-00-820-801.SDR AALA202509056177Stop Pad · out of positionAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND FORWARD OVERWING EXIT DOOR, FORWARD UPPER STOP PAD ROTATED OUT OF POSITION. ROTATED RIGHT HAND FORWARD OVERWING EXIT FORWARD UPPER STOP PAD TO PROPER POSITION. PER AMM 52-22-00-820-801.SDR AALA202509048097Elec Connector · disconnectedAIRCRAFT IN BASE MAINTENANCE: SEAT 2AB EMERGENCY LIGHT INOPERATIVE. TROUBLESHOOTED ROW 2AB EMERGENCY LIGHTS, FOUND SWAPED CONNECTORS J1, J2, J3 AND J4 INSIDE THE SEAT. RECONNECTED ALL CONNECTORS, PER B737NG SWPM 20-61-28, PERFORMED SATISFACTORY OPERATIONAL CHESDR AALA202509022719Stop Pad · rotatedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND FORWARD OVERWING EMERGENCY EXIT DOOR LOWER FORWARD AND LOWER AFT BOTTOM STOP PADS ARE ROTATED. REPOSITIONED STOP PADS ON LEFT HAND FORWARD OVERWING EMERGENCY EXIT DOOR AT FORWARD (AALA202509026732) AND AFT (AALA202509022SDR AALA202509026732Stop Pad · rotatedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND FORWARD OVERWING EMERGENCY EXIT DOOR LOWER FORWARD AND LOWER AFT BOTTOM STOP PADS ARE ROTATED. REPOSITIONED STOP PADS ON LEFT HAND FORWARD OVERWING EMERGENCY EXIT DOOR AT FORWARD (AALA202509026732) AND AFT (AALA202509022SDR AALA202509022751Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY-D IS DIFFICULT TO LOCK AND UNLOCK. ADJUSTED AND LUBRICATED LAVATORY-D DOOR AND LOCK. PER AMM 25-40-00. OPERATIONAL CHECK GOOD.SDR AALA202509025536Float Valve · cloggedAIRCRAFT WAS GROUNDED: FLIGHT ATTENDANT REPORTS AIRCRAFT LEFT AFT JUMPSEAT HAS A LEAKING LIQUID THATSMELLS LIKE ROTTEN EGGSACCOMPLISHED JOB CARD 08L00021001 AND 08L10038003. DURING GALLEY FLOOR INSPECTION FOUND BOTH AFT DOOR SILLS CLOGGED AND BACKING UP EMITTISDR AALA202509026101Float Valve · cloggedAIRCRAFT WAS GROUNDED: FLIGHT ATTENDANT REPORTS AIRCRAFT LEFT AFT JUMPSEAT HAS A LEAKING LIQUID THATSMELLS LIKE ROTTEN EGGSACCOMPLISHED JOB CARD 08L00021001 AND 08L10038003. DURING GALLEY FLOOR INSPECTION FOUND BOTH AFT DOOR SILLS CLOGGED AND BACKING UP EMITTISDR AALA202509020636Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: NUMBER 1 FLIGHT ATTENDANT EMERGENCY FLASHLIGHT BATTERY IS DEAD. REMOVED AND REPLACED FORWARD EMERGENCY LIGHT.SDR AALA202509252958Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE, CORROSION ON PASSENGER CABIN FLOOR SUPPORT INTERCOSTAL IN AF OUTBOARD LAVATORY MOUNT LOCATED AT BS 950, LBL 51. REPLACED FLOOR SUPPORT IAW AARD 51-00-05-1.SDR AALA202509254420Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR SUPPORT, BS 951, RBL 33. REPLACED THE FLOOR SUPPORT IAW AARD 51-00-05-1.SDR AALA202509143428Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER CHORD (T-CAP) UNDER AFT LAVATORY INBOARD MOUNT LOCATED AT BS 947, LBL 22 . REPAIRED UPPER CHORD PER SRM 53-70-51-2R-5 AND EA 367975.SDR AALA202509029678Pump · leakingAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: INFLIGHT HYDRAULIC-A QUANTITY DECREASED FROM 90% TO 57% IN 2 HOURS, LOSING 1% EVERY 4-MIN. AIRCRAFT DIVERTED TO AND LANDED SAFELY AT ORD. FOUND HYDRAULIC LEAK FROM NUMBER 1 ENGINE DRIVEN HYDRAULIC PUMP PSDR AALA202509029544Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: THE DOOR TO THE FORWARD NUMBER LAVATORY 1 HARD TO OPEN. LUBRICATED FORWARD LAVATORY DOOR. PER AMM 52-50-00.SDR AALA202509021661Pressure Switch · inoperativeAIRCRAFT WAS GROUNDED: NUMBER 2 AFT FUEL PUMP IS TURNED OFF, LOW PRESSURE LIGHT DOES NOT ILLUMINATE. REMOVED AND REPLACED NUMBER 2 AFT FUEL PUMP PRESSURE SWITCH. PER AMM 28-42-11. OPERATIONAL CHECK GOOD.SDR AALA202509021042Light · detachedAIRCRAFT WAS NOT GROUNDED: 14C EMERGENCY LIGHT DETACHED FROM SIDE OF SEAT. REATTACHED EMERGENCY LIGHT IN ROW 14C. PER AMM 33-51-11. OPERATIONAL CHECK GOOD.SDR AALA202509021738Light · inoperativeAIRCRAFT WAS NOT GROUNDED: RIGHT HAND AFT FUSELAGE EMERGENCY LIGHT IS INOPERATIVE. REMOVED AND REPLACED RIGHT HAND AFT FUSELAGE EMERGENCY LIGHT. PER AMM 33-51-04. OPERATIONAL CHECK GOOD.SDR AALA202509193659Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL LOCATED FROM BS 500E TO BS 500F AT S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202509148301Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT SHIELD ASSEMBLY LOCATED FROM BS 767 TO BS 787 PLUS 4 INCHES, AT RBL 26. REPLACED SHIELD ASSEMBLY PER AARD 51-00-05-1.SDR AALA202509026395Indication Sys · no testAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: LEFT MAIN GEAR INDICATOR ON MAIN PANEL, AND BOTH LEFT AND RIGHT GEAR ON OVERHEAD WOULD NOT TEST IN FLIGHT. AIRCRAFT EMERGENCY LANDED SAFELY AT DFW. PERFORMED MASTER DIM AND TEST OPERATIONAL TEST, PER AMMSDR AALA202509023931Door · looseAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR DIFFICULT TO OPEN AND CLOSE IN FLIGHT AND ON THE GROUND. APPEARS TO BIND ON BOTTOM SILL ON SIDE OPPOSITE FROM HINGES. RESECURED LOOSE FASTENERS AT FORWARD LAVATORY DOOR SILL. PER AMM 25-40-11. OPERATIONAL CHECK SDR AALA202509024877Pressure Switch · cloggedAIRCRAFT WAS NOT GROUNDED: ENGINE 2 FILTER BYPASS LIGHT ILLUMINATED SHORTLY AFTER TAKEOFF. REPLACED NUMBER 2 ENGINE FUEL FILTER DIFFERENTIAL PRESSURE SWITCH (AALA202509024877), PER AMM 73-34-01. ALSO, REPLACED NUMBER 2 ENGINE FUEL FILTER (AALA202509023546). PESDR AALA202509023546Fuel Filter · cloggedAIRCRAFT WAS NOT GROUNDED: ENGINE 2 FILTER BYPASS LIGHT ILLUMINATED SHORTLY AFTER TAKEOFF. REPLACED NUMBER 2 ENGINE FUEL FILTER DIFFERENTIAL PRESSURE SWITCH (AALA202509024877), PER AMM 73-34-01. ALSO, REPLACED NUMBER 2 ENGINE FUEL FILTER (AALA202509023546). PESDR AALA202509024967Sliding Window · openAIRCRAFT WAS GROUNDED: CAPTAIN L2 SLIDING WINDOW DIFFICULT TO OPEN. ADJUSTED BEARING UPPER ROLLER, OPERATIONAL CHECK GOOD.SDR AALA202509147454Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER CHORD (T-CAP) UNDER AFT LAVATORY MOUNT LOCATED AT BS 947, LBL 24. REPAIRED UPPER CHORD PER SRM 53-70-51-2R-5SDR AALA202509149428Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL LOCATED FROM BS 727B TO BS 727F PLUS 10 INCHES, AT S26R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202509149752Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL LOCATED FROM BS 727G TO BS 767, AT S26R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202509094605Support Beam · damagedAIRCRAFT IN BASE MAINTENANCE: DAMAGED SUPPORT BEAM THAT CONNECTS FIXED TRAILING EDGE TO DEFLECTION RIB. COMPLETED SUPPORT BEAM REPAIR IAW SRM 57-51-02-2R -1SDR AALA202509051592Skin · crackedAIRCRAFT IN BASE MAINTENANCE: RIGHT SIDE OF FUSELAGE SKIN EXISTING REPAIR FILLER IS CRACKED AT BOTTOM OF EXTERNAL POWER PANEL CUT OUT. REPAIRED SKIN FILLER PER SRM 51-40-02, SRM 51-40-05 AND SRM 53-10-15-2R-4SDR AALA202508297581Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER AT STA 663.32, RBL 31.83. REPAIRED VAPOR BARRIER PER AARD 57-10-10-9.SDR AALA202508297859Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR STICKING. HARD TO OPEN AND CLOSE. FORWARD LAVATORY DOOR CHECKS GOOD ON GROUND. ADJUSTED AND CLEANED DEBRIS ON THRESHOLD STRIP.SDR AALA202508296310Life Vest · openAIRCRAFT WAS GROUNDED: 1 FLT DECK LIFE VEST OPENED. REMOVED AND REPLACED FLIGHT DECK LIFE VEST. PER AMM 25-64-00.SDR AALA202508292372Emer Equip · dislodgedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT SIGN FELL FROM CEILING OF THE AISLE BETWEEN ROWS 16 AND 17. REMOVED AND REPLACED EMERGENCY EXIT SIGN HOUSING BETWEEN ROWS 16 AND 17, PER CMM 33-24-03. OPERATIONAL CHECK GOOD, PER AMM 33-51-00.SDR AALA202508296857Light · detachedAIRCRAFT WAS NOT GROUNDED: THE EMERGENCY EXIT LIGHT BY SEAT 28C IS DETACHED. REPLACED THE EMERGENCY FLOOR LIGHT. PER AMM 33-51-11SDR AALA202508290419Slide · dislodgedAIRCRAFT WAS GROUNDED: R1 DOOR SLIDE BUSTLE LOOSE. RESECURED R1 DOOR BUSTLE. PERF AMM 25-66-01, OPERATIONAL CHECK GOOD.SDR AALA202508295668Indicator · false indicationAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: THE RIGHT FUEL INDICATOR WENT BLANK, FUEL INDICATION WAS NOT RELIABLE. AIRCRAFT DIVERTED TO AND LANDED SAFELY AT IAH. RESET FUEL QUANTITY COMPUTER. INDICATION RETURNED AND IS READING GOOD. PER FIM 28-4SDR AALA202509263767Handle · crackedAIRCRAFT IN BASE MAINTENANCE: R1 DOOR HANDLE CASTING WEB HAS CRACK . COMPLETE R1 DOOR ADJUSTMENT. PER AMM 52-41-00.SDR AALA202509174985Bearing · seizedAIRCRAFT IN BASE MAINTENANCE: R1 DOOR HAS SEIZED BEARING ON INSIDE HANDE ASSEMBLY. REMOVED AND REPLACED BEARING ON CAM PLATE. PER CMM 54-41-05SDR AALA202508299000Battery Pack · inoperativeAIRCRAFT WAS GROUNDED: LEFT AFT LAVATORY EMERGENCYLIGHT INOPERATIVE. REMOVED AND REPLACED EXIT LIGHT ASSEMBLY AT LAVATORY-D, BUT NO HELP. **SUPPLEMENTAL REPORT FOR (AALA202508289000): REPLACED LEFT LAVATORY EMERGENCY LIGHT BATTERY PACK. PER AMM 33-50-00. OPERASDR AALA202508286796Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: RIGHT HAND FORWARD EXTERIOR EMERGENCY EXIT DOOR LIGHTING INOPERATIVE. RELAMPED RIGHT HAND FORWARD EXTERIOR EMERGENCY EXIT DOOR LIGHTING. PER AMM 33-51-04.
Back to Boeing 737-823