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 AALA202108237833Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF FLOORBOARD SUPPORT CREASE ANGLE AT STA 322 AND RBL 56, MEASURING L=2.0 IN, W=1.0 IN, D=0.05 IN. REPLACED CREASE ANGLE WITH NEW IAW SRM 51-40-01-0G.SDR AALA202108205592Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FOUND ON LEFT TRANSITION PANEL LOCATED AT 727D - 815, ANS STR 25L. SPLICED IN NEW TRANSITION PANEL PER SRM 53-00-53-2R,SDR AALA202108209280Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: LEFT TRANSITION PANEL HAS CORROSION. REMOVED AND REPLACED LEFT TRANSITION PANEL LOCATED AT STA 767 - 847, STR 25L PER53-00-53-2R.SDR AALA202108208132Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FOUND ON LEFT TRANSITION PANEL LOCATED AT 727H-767, STR 25L. REMOVED AND REPLACED TRANSITION PANEL PER SRM 53-00-53-2R.SDR AALA202108118334Web · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WEB OF RH WING FIXED TRAILING EDGE AT WSTA 275. REPLACED WEB WITH NEW IAW B737NG SRM 51-40-02.SDR AALA202108113979Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF RH TRANSITION PANEL BETWEEN STA 727 AND STA 727H+5 AT STR 25R, MEASURING L=1.0 IN, W=2.0 IN, D=0.008 IN. REPLACED TRANSITION PANEL WITH NEW IAW SRM 53-00-53-2R.SDR AALA202108114803Baffle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF BAFFLE AT FASTENER HOLES BETWEEN STA 500G AND STA 500H AT STR 27L, MEASURING L=3.0 IN, W=1.0 IN, D=0.01 IN. REPLACED BAFFLE WITH NEW IAW AARD 51-00-05.SDR AALA202108117883Transducer · faultyAIRCRAFT WAS GROUNDED: SPEEDBRAKE WAS ARMED BUT DID NOT DEPLOY ON LANDING. **SUPPLEMENTAL REPORT: REPLACED MAIN LANDING GEAR #2 WHEEL AXLE SPEED TRANSDUCER IAW AMM 32-42-11, OPS CHECK GOOD.** (CLOSED)SDR AALA202108116395Angle · crackedAIRCRAFT IN BASE MAINTENANCE: BAFFLE CLIP LOCATED AT STA 500H AND S27L CRACKED. REPLACED BAFFLE CLIP PER DWG 143A7505 AND AARD 51-00-05.SDR AALA202108114542Angle · crackedAIRCRAFT IN BASE MAINTENANCE: BAFFLE CLIP LOCATED AT STA 500H AND S27L CRACKED. REPLACED BAFFLE CLIP PER DWG 143A7505 AND AARD 51-00-05.SDR AALA202108111706Angle · crackedAIRCRAFT IN BASE MAINTENANCE: BAFFLE CLIP LOCATED AT STA 500G AND S27L CRACKED. REPLACED BAFFLE CLIP PER DWG 143A7505 AND AARD 51-00-05.SDR AALA202108118618Baffle · damagedAIRCRAFT IN BASE MAINTENANCE: BAFFLE LOCATED BETWEEN STA 500E AND 500F AT S27L CRACKED. REPLACED BAFFLE PER DWG 143A7505 AND AARD 51-00-05.SDR AALA202108027883Speed Brake · inoperativeAIRCRAFT WAS GROUNDED: SPEEDBRAKE WAS ARMED BUT DID NOT DEPLOY ON LANDING. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202108025749Cover · looseAIRCRAFT WAS NOT GROUNDED: ESCAPE PATH LIGHT LOOSE AT SEAT 12C. SECURED LIGHT COVER IAW AMM 33-51-11, OPS CHECK GOOD.SDR AALA202108021219Cover · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT ABOVE SEAT 16A FELL OFF. REATTACHED LIGHT COVER, OPS CHECK GOOD.SDR AALA202108024287Light · missingAIRCRAFT WAS NOT GROUNDED: EXIT SIGN COVER MISSING AT SEAT 17A. INSTALLED NEW EMERGENCY LIGHT AT SEAT 17A IAW AMM 33-51-01-960-802, OPS CHECK GOOD.SDR AALA202108022546Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: FWD LAVATORY DOOR DIFFICULT TO OPEN. LUBRICATED LATCH IAW AMM 52-00-00, OPS CHECK GOOD.SDR AALA202108026949Megaphone · inoperativeAIRCRAFT WAS NOT GROUNDED: CABIN MEGAPHONE INOPERATIVE. REPLACED FWD MEGAPHONE WITH SERVICEABLE UNIT IAW AMM 25-64-00, OPS CHECK GOOD.SDR AALA202108020835Door · displacedAIRCRAFT WAS NOT GROUNDED: LH AFT LAVATORY DOOR DISPLACED FROM TRACK. REINSTALLED DOOR ON TRACK, OPS CHECK GOOD.SDR AALA202108022902Light · looseAIRCRAFT WAS NOT GROUNDED: ROW 19C EMERGENCY LIGHT LOOSE. SECURED EMERGENCY LIGHT PER AMM 33-51-11.SDR AALA202108021533Light · detachedAIRCRAFT WAS NOT GROUNDED: SEAT TRIM EMERGENCY LIGHT DETACHED. REATTACHED SEAT TRIM LIGHT PER AMM 25-22-00.SDR AALA202108026390Cover · unsecureAIRCRAFT WAS NOT GROUNDED: SEAT 10C EMERGENCY LIGHT COVER IS NOT SECURE. SECURED LIGHT COVER PER AMM 33-50-00SDR AALA202108101716Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN SKIN OF LOWER RH STABILIZER AT RH STAB STA 101 AND 11 IN FWD OF REAR SPAR, MEASURING L=0.75 IN, D=0.08 IN. ACCOMPLISHED PERMANENT REINFORCING DOUBLER REPAIR IAW SRM 55-10-01-R2-8.SDR AALA202108048844Light · looseAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHTING LOOSE AT SEAT 28C. SECURED EMERGENCY EXIT LIGHT AT SEAT 28C.SDR AALA202108037098Light · detachedAIRCRAFT WAS NOT GROUNDED: POWER OUTLET IN CEILING AFT OF EMERGENCY EXIT ROW DETACHED IN FLIGHT. SECURED CEILING EMERGENCY EXIT LIGHT.SDR AALA202108035323Sign · missingAIRCRAFT WAS NOT GROUNDED: EXIT SIGN COVER AFT LEFT DOOR MISSING. REPLACED EXIT SIGN IAW AMM 33-51-01.SDR AALA202108025775Cover · detachedAIRCRAFT WAS NOT GROUNDED: OVERWING EXIT LIGHT COVER DETACHED. REINSTALLED LIGHT COVER IAW AMM 33-51-01, OPS CHECK GOOD.SDR AALA202108022164Girt Bar · out of alignmentAIRCRAFT WAS NOT GROUNDED: R1 DOOR GIRT BAR REPORTED AS MISALIGNED AND DIFFICULT TO ARM/DISARM. REALIGNED R1 DOOR GIRT BAR BACK INTO ITS BRACKET. NO FAULTS NOTED OK FOR SERVICE PER AMM 25-66-00.SDR AALA202108028102Wire Harness · unsecureAIRCRAFT WAS NOT GROUNDED: PATHWAY LIGHTING UNDER SEAT 19C IS LOOSE. SECURED WIRING HOUSING HARNESS REMOVED TAPE OPERATIONS CHECK NORMAL PER AMM 33-51-00SDR AALA202108023665Sign · detachedAIRCRAFT WAS NOT GROUNDED: OVER WING EXIT ROW SIGN COVER DETACHED. REATTACHED OVER WING EXIT ROW SIGN AS REQUIRED PER AMM 33-50-00.SDR AALA202108025133Retainer · looseAIRCRAFT WAS NOT GROUNDED: AIRCRAFT RIGHT FORWARD DOOR GIRT BAR REPORTED AS LOOSE. ADJUSTED R1 DOOR GIRT BAR RETAINER CLIPS PER AMM 25-66-01-200-802SDR AALA202108026304Light · unsecureAIRCRAFT WAS NOT GROUNDED: EXIT LIGHT COVER NEEDS TO BE SECURED IN AFT GALLEY. REPLACED EMERGENCY EXIT LIGHT ASSEMBLY AT LEFT SIDE AFT GALLEY PER AMM 33-51-00.SDR AALA202108025930Retainer · looseAIRCRAFT WAS NOT GROUNDED: SERVICE DOOR SLIDE GIRT BAR CLIP LOOSE, LEFT CLIP. ADJUSTED TENSION ON GIRT BAR HOLDER CLIP.SDR AALA202108023968Bracket · stickingAIRCRAFT WAS NOT GROUNDED: LEFT AFT ENTRY DOOR GIRT BUSTLE BRACKET VERY TIGHT. ADJUSTED LEFT AFT GIRT BAR BRACKET OPERATIONS CHECKS GOOD PER AMM 25-61-00.SDR AALA202108176155Skin · crackedAIRCRAFT IN BASE MAINTENANCE: RIGHT HORIZONTAL STABILIZER SKIN LOWER SURFACE HAS A CRACK AT STA 138.7, RIGHT BUTT LINE 101. INSTALLED DOUBLER REPAIR PER SRM 55-10-01-2R.SDR AALA202108029609Pin · stickingAIRCRAFT WAS GROUNDED: L1 DOOR VERY HARD TO OPEN AND CLOSE. REMOVED AND REPLACED THE GLIDE ARM PIN, SCREW (AALA202108022992), AND KEY WASHER (AALA202108024872) ON THE LEFT FORWARD ENTRY DOOR GUIDE ARM PER AMM 52-11-21.SDR AALA202108022992Screw · stickingAIRCRAFT WAS GROUNDED: L1 DOOR VERY HARD TO OPEN AND CLOSE. REMOVED AND REPLACED THE GLIDE ARM PIN (AALA202108029609), SCREW, AND KEY WASHER (AALA202108024872) ON THE LEFT FORWARD ENTRY DOOR GUIDE ARM PER AMM 52-11-21.SDR AALA202108024872Washer · stickingAIRCRAFT WAS GROUNDED: L1 DOOR VERY HARD TO OPEN AND CLOSE. REMOVED AND REPLACED THE GLIDE ARM PIN (AALA202108029609), SCREW (AALA202108022992), AND KEY WASHER ON THE LEFT FORWARD ENTRY DOOR GUIDE ARM PER AMM 52-11-21.SDR AALA202107302468Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: RIGHT AFT LAVATORY LOCK DIFFICULT TO OPERATE. LUBRICATED DOOR LATCH.SDR AALA202107301344Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: FORWARD RIGHT MEGAPHONE DOES NOT WORK ON FLIGHT ATTENDANTS PREFLIGHT CHECK. REPLACED BATTERIES ON FORWARD RIGHT MEGAPHONE OPERATIONS CHECK GOOD.SDR AALA202108121953Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF FLOORBEAM AT STA 947 AND LBL 16, MEASURING L=32.0 IN, W=1.5 IN, D=0.053 IN. ACCOMPLISHED PERMANENT REINFORCING REPAIR OF FLOORBEAM WITH NESTED ANGLES IAW SRM 53-70-51-2R-5.SDR AALA202108126095Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF SHIELD BETWEEN STA 847 AND STA 867 AT RBL 25, MEASURING L=1.75 IN, W=1.5 IN, D=0.022 IN. REPLACED SHIELD WITH NEW IAW SRM 53-60-15.SDR AALA202108128900Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN INTERCOSTAL BETWEEN STA 328 AND STA 344 AT LBL 45, MEASURING L=1.0 IN, W=0.001 IN, D=0.04 IN. REPLACED INTERCOSTAL WITH NEW IAW AARD 51-00-05-1.SDR AALA202108124171Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN INTERCOSTAL BETWEEN STA 312 AND STA 328 AT RBL 30.5, MEASURING L=1.75 IN, W=0.001 IN, D=0.04 IN. REPLACED INTERCOSTAL WITH NEW IAW AARD 51-00-05-1.SDR AALA202108125356Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: BREAK ASSEMBLY PANEL LOCATED AT STA 540 AND RBL 2 TO RBL 22 CRACKED. REPLACED BREAK ASSEMBLY PANEL PER 51-10-20.SDR AALA202108122835Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: BREAK ASSEMBLY PANEL LOCATED AT STA 540 AND LBL 2 TO LBL 22 CRACKED. REPLACED BREAK ASSEMBLY PANEL PER 51-10-20.SDR AALA202108031870Window Frame · damagedAIRCRAFT IN BASE MAINTENANCE: REINFORCING MODIFICATION NEEDS TO BE INSTALLED ON RIGHT SIDE OF FIRST OFFICERS #1 OUTBOARD WINDOW FRAME. INSTALLED EXTERNAL DOUBLER REINFORCING MODIFICATION REF ECO 5319J023-008.SDR AALA202108025670Window Post · crackedAIRCRAFT IN BASE MAINTENANCE: LEFT SIDE CAPTAIN'S OUTBOARD WINDOW POST 1 HAS 3/4 INCH CRACK. INSTALLED EXTERNAL DOUBLER/TRIPLER REPAIR.SDR AALA202107304599Pressure Switch · faultedAIRCRAFT WAS GROUNDED: DURING CLIMB OUT ENGINE 1 LOW PRESSURE LIGHT ILLUMINATED. A SYSTEM PRESSURE NORMAL AND QUANTITY AT 72 PERCENT. AIRCRAFT RETURNED TO PHX. EMERGENCY WAS DECLARED. DURING GEAR EXTENSION A SYSTEM PRESSURE DROPPED EXCESSIVELY BUT RETURNED TO SDR AALA202107291427Slide · out of positionAIRCRAFT WAS NOT GROUNDED: SLIDE ON L2 DOOR SHOWING EXCESSIVE SLIDE MATERIAL FROM BOTTOM OF SLIDE BETWEEN GIRT BAR AND SLIDE ENCLOSURE. REPOSITIONED Z FOLD ON L2 DOOR SLIDE IAW AMM 25-66-01.
Back to Boeing 737-823