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 AALA2023011807939Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR STRUCTURE LEFT HAND TRANSITION PANEL LOCATED FROM BS 727C + 10.5 INCHES TO BS 727F + 10 INCHES, AT S25L, AND LBL 21. REPAIRED TRANSITION PANEL PER SRM 53-00-53-2R PROCEDURE 6.SDR AALA202301066813Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 101.9, 37 INCHES AFT OF FORWARD SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202301063924Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 101.9, 28 INCHES AFT OF FORWARD SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202301036130Light · detachedAIRCRAFT WAS NOT GROUNDED: SEAT 29C EMERGENCY LIGHT DETACHED. REMOVED AND REPLACED ESCAPE PATH LIGHT ASSEMBLY AT SEAT 29C PER AMM 33-51-11.SDR AALA202301030114Girt Bar · looseAIRCRAFT WAS NOT GROUNDED: 1L CABIN DOOR SLIDE GIRT BAR CLIP LOOSE. ADJUSTED GIRT BAR CLIPS. GIRT BAR IS SECURED.SDR AALA202301038477Handle · bindingAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR DIFFICULT TO CLOSE. LUBRICATED FLIGHT DECK DOOR HANDLE.SDR AALA202301059115Smoke Detector · false activationAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY SMOKE DETECTOR AURAL AND VISUAL ALERT WITH LAVATORY UNOCCUPIED AND NO SMOKE PRESENT. **SUPPLEMENTAL REPORT FOR AALA202301039115: REPLACED AFT LAVATORY SMOKE DETECTOR PER AMM 26-14-01. ACCOMPLISHED SATISFACTORY OPERASDR AALA202301049758Audio Panel · smokeAIRCRAFT WAS GROUNDED: FLIGHT CREW REPORTED FUMES IN THE FLIGHT DECK CAUSED BY THE AUDIO SELECTOR PANEL. EMERGENCY WAS DECLARED FOR ARRIVAL TO DFW. FLIGHT LANDED WITHOUT ISSUE AND TAXIED TO THE GATE. REPLACED CAPTAINS AUDIO CONTROL PANEL.SDR AALA202301035034Mount · bindingAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR DIFFICULT TO OPEN. ADJUSTED DOOR TO HINGE MOUNTS.SDR AALA202301037768Retainer · looseAIRCRAFT WAS NOT GROUNDED: POST FLIGHT FLIGHT ATTENDANT REPORTS THAT AFT RIGHT DOOR GIRT BAR CLIP IS LOOSE ON THE DOOR ITSELF. REMOVED AND REPLACED GIRT BAR CLIP PER AMM 25-66-01.SDR AALA202301039115Smoke Detector · false activationAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY SMOKE DETECTOR AURAL AND VISUAL ALERT WITH LAVATORY UNOCCUPIED AND NO SMOKE PRESENT. (OPEN)SDR AALA202301036554Retainer · looseAIRCRAFT WAS NOT GROUNDED: DOOR 1R GIRT BAR IS LOOSE. ADJUSTED GIRT BAR RETAINER CLIP. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202301037491Door Latch · out of adjustAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR LATCH STICKS CLOSED. ADJUSTED AND LUBRICATED DOOR LATCH PER CMM 25-47-21.SDR AALA202301031147Retainer · looseAIRCRAFT WAS NOT GROUNDED: 1R DOOR GIRT BAR LOOSE IN THE CRADLE. ADJUSTED RETAINER CLIP PER AMM 25-66-00. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202302216171Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED BETWEEN BS 877 AND BS 885 AT RBL 26. REPLACED TRANSITION PANEL PER SRM 51-40-02-0G AND AARD 51-00-05-1.SDR AALA202302213737Strap · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT DOOR CHORD ATTACH STRAP LOCATED AT BS 790 AND RBL 20. REPLACED STRAP PER SRM 51-40-02-0G.SDR AALA202302103343Bracket · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FOUND ON HIGH FREQUENCY WIRING CONTAINMENT BOX. LOCATED AT STA 718 AND RIGHT BUTT LINE 30. REMOVED AND REPLACED BRACKET PER AARD.SDR AALA202302025155Bracket · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT MAIN LANDING GEAR WHEEL WELL SHELF BRACKET, FORWARD OF HYDRAULIC SYSTEM B RESERVOIR, LOCATED AT BS 665 AND RBL 54. REPLACED BRACKET PER SRM 53-050-00.SDR AALA202301110499Power Supply · inoperativeAIRCRAFT IN BASE MAINTENANCE: LEFT HAND AFT OVERWING EMERGENCY EXIT, EXIT SIGN INOPERATIVE. REPLACED EMERGENCY LIGHTING BATTERY PACK POWER SUPPLY ASSEMBLY M1695. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-06.SDR AALA202301049037Expansion Joint · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR PANEL LEFT HAND EXPANSION JOINT LOCATED AT BS 540, WL 208, AND LBL 3. REPLACED EXPANSION JOINT PER AARD 51-00-05-1.SDR AALA202301044112Expansion Joint · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR PANEL RIGHT HAND EXPANSION JOINT LOCATED AT BS 540, WL 208, AND RBL 3. REPLACED EXPANSION JOINT PER AARD 51-00-05-1.SDR AALA202212292647Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: AFT PRESSURE BULKHEAD HAS AREA OF LIGHT CORROSION LOCATED AT STA 1016 AND RIGHT BUTT LINE 35. REMOVED CORROSION BY MECHANICAL MEANS AND OUT OF SRM LIMITS. REMOVED AND REPLACED INTERCOSTALSDR AALA202212291749Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: UPON REMOVAL OF AFT BULKHEAD LOWER SEAL AT AFT PRESSURE BULKHEAD LOWER INTERCOSTAL ATTACHMENT FOUND TO BE CORRODED. REMOVED CORROSION BY MECHANICAL MEANS AND OUT OF SRM LIMITS. FABRICATED NEW INTERCOSTAL AND REPLACED.SDR AALA202212292322Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: UPON REMOVAL OF AFT BULKHEAD LOWER SEAL FOUND CORROSION AT AFT PRESSURE BULKHEAD LOWER INTERCOSTAL ATTACHMENT. REMOVED CORROSION BY MECHANICAL MEANS AND OUT OF SRM LIMITS. FABRICATED INTERCOSTAL PER BOEING AND REPLACED.SDR AALA202302215114Rail · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT CENTER BULKHEAD PANEL LOWER SUPPORT RAIL LOCATED AT BS 947.5 AND LBL 8. REPLACED RAIL PER SRM 51-40-02-0G.SDR AALA202302216783Transition Panel · damagedAIRCRAFT IN BASE MAINTENANCE: ELONGATED HOLES IN AFT CARGO COMPARTMENT FLOOR STRUCTURE RIGHT HAND TRANSITION PANEL LOCATED FROM BS 727E TO BS 727I AT S26R. SPLICE REPAIRED TRANSITION PANEL PER SRM 53-00-53-2R-5..SDR AALA202301177673None · noneAIRCRAFT IN BASE MAINTENANCE: DURING INSPECTION MAINTENANCE FOUND AN EXISTING UNDOCUMENTED FUSELAGE SKIN PANEL REPAIR LOCATED BETWEEN BS 500B AND BS 500C, AND BETWEEN S1R AND S3R. DOUBLER REPAIR INSPECTED PER SRM 53-00-01-2R PROCEDURE 3 REPAIR 3.SDR AALA202301115471Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT GALLEY RIGHT HAND MOUNT FLOOR SUPPORT INTERCOSTAL LOCATED AT BS 271.5 AND RBL 43. REPLACED INTERCOSTAL PER SRM 53-10-51-1A.SDR AALA202301107786Warning Unit · inoperativeAIRCRAFT WAS NOT GROUNDED: ON TAKEOFF ROLL THROUGH 500 FT, MASTER CAUTION AND FORWARD ENTRY DOOR LIGHT WAS INTERMITTENT, DOOR HANDLE VERIFIED DOWN, PRESSURIZATION NORMAL, FORWARD ENTRY LIGHT NEVER ILLUMINATED AFTER 500FT. REPLACED DOOR WARNING MODULE PER AMM SDR AALA202301109754Floor Support · elongatedAIRCRAFT IN BASE MAINTENANCE: ELONGATED FASTENER HOLES IN MAIN CABIN FLOOR SUPPORT LOCATED AT BS 967 AND RBL 16. REPLACED FLOOR SUPPORT PER SRM 51-40-05 AND DWG 140A9870.SDR AALA202301104882Floor Support · elongatedAIRCRAFT IN BASE MAINTENANCE: ELONGATED FASTENER HOLES IN MAIN CABIN FLOOR SUPPORT LOCATED AT BS 986 AND BL 0. REPLACED FLOOR SUPPORT PER SRM 51-40-05 AND DWG 1475700.SDR AALA202301057312Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 157.23, 23 INCHES AFT OF FORWARD SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202301042309Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 129.5, 9.5 INCHES AFT OF FORWARD SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202301045034Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 129.5, 18 INCHES AFT OR FORWARD AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202301032035Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FLOOR SUPPORT BREAK ASSEMBLY LOCATED AT BS 537.45 AND LBL 1. REPLACED FLOOR SUPPORT BREAK ASSEMBLY PER AARD 51-00-05-10.SDR AALA202212300351Sliding Window · out of adjustAIRCRAFT IN BASE MAINTENANCE: HEAVY FORCE NEEDED TO CLOSE FIRST OFFICER`S WINDOW. ADJUSTED AND PERFORMED FUNCTIONAL CHECK OR R2 WINDOW IAW AMM 56-12-11, HANDLE FORCES ARE WITHIN LIMITS.SDR AALA202212295374Hinge · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR GET STUCK CLOSED. LUBED AFT LEFT LAVATORY DOOR LATCH HINGE AND SLIDER DOOR.SDR AALA202212297786Master Caution · intermittentAIRCRAFT WAS NOT GROUNDED: ON TAKEOFF ROLL THROUGH 500 FT, MASTER CAUTION AND FORWARD ENTRY DOOR LIGHT WAS INTERMITTENT, DOOR HANDLE VERIFIED DOWN, PRESSURIZATION NORMAL, FORWARD ENTRY LIGHT NEVER ILLUMINATED AFTER 500FT. **SUPPLEMENTAL REPORT REQUIRED** (OPENSDR AALA202301113185Structure · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN CABIN RIGHT HAND CREASE BEAM INNER CHORD LOCATED FROM BS 295 TO BS 325 AT RBL 60. REPLACED CHORD PER SRM 53-10-15-1A.SDR AALA202301100111Idg · inoperativeAIRCRAFT WAS GROUNDED: AIRCRAFT DIVERTED TO MAF AFTER NUMBER 2 GENERATOR DROPPED OFFLINE FOLLOWED BY NUMBER 2 ENGINE DRIVE LIGHT. REMOVED AND REPLACED NUMBER 2 ENGINE INTEGRATED DRIVE GENERATOR IAW AMM 24-11-11.SDR AALA202301104010Engine · odorAIRCRAFT WAS GROUNDED: INTERMITTENT ODOR DURING FIRST 15 MIN OF FLIGHT STRONGEST IN FLIGHT DECK AND FORWARD CABIN QUICK REFERENCE HANDBOOK ODOR CHECKLIST TABLE CHARACTERISTICS MILD/MODERATE TRANSIENT CATEGORY (BURNING RUBBER SCENT). REMOVED AND REPLACED NUMBSDR AALA202301032607Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED LEFT HAND HORIZONTAL STABILIZER RIB VERTICAL STIFFENER LOWER END AT STABILIZER STATION 101.9, THIRD RIB OUTBOARD OF THE STABILZER ROOT. MAINTENANCE REPLACED RIB PER SRM 51-40-02.SDR AALA202301035538Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FLOOR SUPPORT BREAK ASSEMBLY LOCATED AT BS 537.45. REPLACED FLOOR SUPPORT BREAK ASSEMBLY PER AARD 51-00-05 REPAIR 1.SDR AALA202212290111Generator · faultedAIRCRAFT WAS GROUNDED: AIRCRAFT DIVERTED TO MAF AFTER NUMBER 2 GENERATOR DROPPED OFFLINE FOLLOWED BY NUMBER 2 ENGINE DRIVE LIGHT. OPENSDR AALA202212294010Cabin Air Sys · odorAIRCRAFT WAS GROUNDED: INTERMITTENT ODOR DURING FIRST 15 MIN OF FLIGHT STRONGEST IN FLIGHT DECK AND FORWARD CABIN QUICK REFERENCE HANDBOOK ODOR CHECKLIST TABLE CHARACTERISTICS MILD/MODERATE TRANSIENT CATEGORY (BURNING RUBBER SCENT). **SUPPLEMENTAL REPORT REQUISDR AALA202212287744Door · bindingAIRCRAFT WAS NOT GROUNDED, FLIGHT DECK DOOR DIFFICULT TO CLOSE. PERFORMED FAULT ISOLATION TASKS IAW FIM 52-50-00-810-802, FAULT CORRECTED.SDR AALA202212283833Screw · looseAIRCRAFT WAS NOT GROUNDED, FORWARD LAVATORY DOOR DIFFICULT TO OPEN. SECURED SEVERAL SCREWS IN FWD LAVATORY DOORWAY TRIM.SDR AALA202212289953Hinge · bindingAIRCRAFT WAS NOT GROUNDED, RT AFT LAVATORY DOOR IS DIFFICULT ON OPEN AND CLOSE. REPLACED LAVATORY DOOR HINGE IAW CMM 25-40-65.SDR AALA202212284243Track · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT ENTRY DOOR HINGES ARE NOISY AND DOOR IS DIFFICULT TO OPERATE. LUBRICATED ENTRY DOOR 4L HINGE TRACK IAW AMM 52-41-00.SDR AALA202301310611Lamp · inoperativeAIRCRAFT IN BASE MAINTENANCE: LEFT HAND FORWARD OVERWING EXTERIOR EMERGENCY LIGHT INOPERATIVE. RE-LAMPED LIGHT AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-04-960-801.
Back to Boeing 737-823