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 AALA202105119006Latch · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD GALLEY CLOSET DOOR LATCH VERY DIFFICULT TO OPEN. PIN DOES NOT FULLY RETRACT. ADJUSTED LATCH.SDR AALA202105119002Cooling Fan · noisyAIRCRAFT WAS GROUNDED: FLIGHT ATTENDANT NOTICED FAINT DIRTY SOCK, BURNING RUBBER ODOR IN FIRST CLASS GALLEY AT CRUISE. ACCOMPLISHED JOB CARD 08L00021001. EXCESSIVE NOISE AND VIBRATION FROM EQUIPMENT COOLING NORMAL SUPPLY FAN M1322. REPLACED FAN PER AMM 21-27-0SDR AALA202105119014Angle · out of toleranceAIRCRAFT IN BASE MAINTENANCE: CARRY THROUGH ANGLE AT STA 887, RBL 24.75 HAS A PREVIOUSLY OVERSIZED HOLE. REMOVED ANGLE AND INSTALLED NEW ANGLE IAW BAC 146A5360 AND B737 NG SRM 51-40-02.SDR AALA202105109002Housing · looseAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT HOUSING UNSECURED AT SEAT 22C. SECURED HOUSING IAW AMM 33-51-11, OPS CHECK GOOD.SDR AALA202106019028Lens · brokenAIRCRAFT IN BASE MAINTENANCE: SIDEWALL PANEL L11 EMERGENCY EXIT LIGHT LENS HAS BROKEN TAB. REPLACED SIDEWALL L11 EMERGENCY EXIT LIGHT LENS ASSEMBLY IAW B737 AMM 33-51-01, OPS CHECK GOOD.SDR AALA202105099005Door · brokenAIRCRAFT WAS NOT GROUNDED: AFT LH LAVATORY DOOR IS DIFFICULT TO OPEN AND CLOSE. REPLACED LH AFT LAVATORY DOOR IAW AMM 25-40-14, OPS CHECK GOOD.SDR AALA202105099002Cover · looseAIRCRAFT WAS NOT GROUNDED: PLASTIC COVER ON RH AFT SLIDE LOOSE. SECURED COVER IAW AMM 20-30-11.SDR AALA202105099012Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: FORWARD BULKHEAD AT STA 663.75 FORWARD SIDE CENTER WING SECTION EXTERIOR LOWER SURFACE ATTACH ANGLE IS CRACKED AT FASTENER HOLE. REPAIRED ATTACH ANGLE IAW B737NG SRM 57-10-102R-5.SDR AALA202105099006Latch · out of adjustAIRCRAFT WAS NOT GROUNDED: RIGHT AFT LAVATORY DOOR DIFFICULT TO OPEN/CLOSE AND LOCK IN FLIGHT. RIGHT AFT LAVATORY DOOR LATCH ADJUSTED IAW AMM 25-00-00.SDR AALA202105099010Girt Bar · looseAIRCRAFT WAS NOT GROUNDED: FIRST CLASS GALLEY SERVICE DOOR GIRT BAR RETENTION CLIP ON THE DOOR IS LOOSE. BAR CAN EASILY FALL OUT. ADJUSTED AND SECURED R1 DOOR GIRT BAR ASSEMBLY PER AMM 25-66-00.SDR AALA202105099007Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR DIFFICULT TO OPEN/CLOSE AND LOCK IN FLIGHT. LEFT AFT LAVATORY DOOR LATCH ADJUSTED PER AMM 25-00-00.SDR AALA202105099004Light · unsecureAIRCRAFT WAS NOT GROUNDED: ESCAPE PATH LIGHTING ASSEMBLY AT SEAT 21C IS DETACHED. WIRES EXPOSED. REINSTALLED AND SECURED EMERGENCY LIGHT AS REQUIRED. LIGHT SECURED AND OK FOR SERVICESDR AALA202105099001Hydraulic System · false indicationAIRCRAFT WAS GROUNDED: IN FLIGHT A HYDRAULIC SYSTEM QUANTITY DROPPED FROM 78% TO 55% PRESSURE REMAINED AT 3000. ADDITIONALLY B HYDRAULIC SYSTEM QUANTITY DROPPED TO 81%. AIRCRAFT DIVERTED INTO PHX DUE TO LOW QUANTITIES OF HYDRAULIC FLUID. NO EMERGENCY DECLARED SDR AALA202105199020Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF RH FWD SHIELD IN AFT CARGO COMPARTMENT AT STA 787 AND STR 25R, MEASURING L=0.5 IN, W=0.5 IN, D=0.021 IN. REPLACED SHIELD WITH NEW IAW AARD 51-00-05--1A.SDR AALA202105189011Skin · dentedAIRCRAFT IN BASE MAINTENANCE: DENT IN FUSELAGE SKIN AT STA 913 AT STR 20R, MEASURING L=2.9 IN, W=3.7 IN, D=0.08 IN. ACCOMPLISHED PERMANENT REINFORCING DOUBLER REPAIR IAW EA# 327430 AND SRM 53-00-0-1-2R.SDR AALA202105189019Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FOUND ON TRANSITIONAL PANEL LOCATED AT STA 761 TO STA 847, LEFT BUTT LINE 20. REMOVED AND REPLACED LEFT TRANSITIONAL PANEL IN AFT CARGO AT STA 761 TO STA 847 PER SRM 53-00-53-2R.SDR AALA202105199019Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF KEEL BEAM TRUSS WEB UNDER PANEL 192F AT STA 650 AND BL 0, MEASURING L=3.0 IN, W=0.6 IN, D=0.019 IN. ACCOMPLISHED PERMANENT REINFORCING DOUBLER REPAIR IAW EA 327425 AND B737 NG SRM 51-10-02 AND 51-40-02.SDR AALA202105089021Sensor · out of adjustAIRCRAFT WAS NOT GROUNDED: ABORTED TAKEOFF AT 60KTS DUE TO DOOR INDICATION FAULT. ADJUSTED L1 DOOR SENSOR IAW AMM 52-71-11, OPS CHECK GOOD.SDR AALA202105089019Cover · missingAIRCRAFT WAS NOT GROUNDED: 29C FLOOR LEVEL EXT LIGHT COVER IS MISSING. REINSTALLED EMERGENCY FLOOR PROXIMITY LIGHT SHROUD PER AMM 33-51-11.SDR AALA202105079010Battery · inoperativeAIRCRAFT IN BASE MAINTENANCE: CUSTOMER WALK- FORWARD FLASHLIGHT ONBOARD SIDE NO TEST LIGHT. REMOVED AND REPLACED BATTERY PACK PER B737 NG AMM 25-64-00-900-806.SDR AALA202105089009Windshield · scratchedAIRCRAFT WAS GROUNDED: CAPTAIN'S L1 WINDSHIELD IS BADLY SCRATCHED AND IMPEDES VISION OUT WINDOW. REMOVED AND REPLACED WINDSHIELD WITH NEW I.A.W JOB CARD 08L21056003.SDR AALA202105089006Connector · mispinnedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHT L01505 INOPERATIVE. RE-PINNED CONNECTOR D11098 IAW WDM 33-51-13, OPS CHECK GOOD.SDR AALA202105089005Connector · mispinnedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHT L01503 INOPERATIVE. RE-PINNED CONNECTOR D11321 IAW WDM 33-51-12, OPS CHECK GOOD.SDR AALA202105069008Sealant · missingAIRCRAFT IN BASE MAINTENANCE: L2 DOOR GIRT BAR FITTING REQUIRES SEALANT. SEALED GIRT BAR FITTING IAW MPSM 07.01.SDR AALA202105069017Support Beam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LOWER CHORD OF LOWER SUPPORT BEAM AT STA 540 AND RBL 40.875, MEASURING L=5.25 IN, W=0.001 IN. ACCOMPLISHED PERMANENT REINFORCING FILLER AND STRAP REPAIR IAW EA 327390.SDR AALA202105069013Bulb · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHTS "NOT ARMED" LIGHT HAS ONE BULB BURNED OUT. RELAMPED, TEST OK, OK FOR SERVICE.SDR AALA202105069001Sliding Window · leakingAIRCRAFT WAS GROUNDED: FIRST OFFICER SLIDING WINDOW PRESENTED LOUD AIR NOISE SHORTLY AFTER TAKEOFF. CONFIRMED CLOSED LOUD NOISE/SQUEAL INTENSIFIED DURING CLIMBOUT. LEVELED OFF AT FL350 INSTEAD OF CONTINUING CLIMB. DIFFERENTIAL > 6.0 PSI EXTREME. CHECKED CLOSINSDR AALA202105189013Skin · damagedAIRCRAFT IN BASE MAINTENANCE: DAMAGE TO FUSELAGE SKIN AT STA 727I-7 AND STR 24L, MEASURING L=6.625 IN, W=3.5 IN, D=0.08 IN. ACCOMPLISHED PERMANENT REINFORCING EXTERNAL DOUBLER REPAIR IAW SRM 53-00-01-2R AND EA 327338.SDR AALA202105089004Connector · looseAIRCRAFT IN BASE MAINTENANCE: EMERGENCY PASSENGER LIGHTS INOPERATIVE AT SEATS 31-33ABC. SECURED CONNECTOR IAW WDM 33-51-22, OPS CHECK GOOD.SDR AALA202105059002Speed Brake · faultedAIRCRAFT WAS NOT GROUNDED: LOW SPEED REJECTED TAKE OFF AT 30 KNOTS DUE TO TAKE OFF CONFIGURATION WARNING AT THRUST APPLICATION ASSOCIATED WITH ILLUMINATION OF THE OVERHEAD PROXIMITY SENSOR ELECTRONIC UNIT LIGHT. ACCOMPLISHED PROXIMITY SENSOR ELECTRONIC UNIT TESDR AALA202105049014Bezel · brokenAIRCRAFT WAS GROUNDED: 16C EMERGENCY LIGHT LENS BEZEL BROKEN OFF SEAT. INSTALLED NEW EMERGENCY LIGHT BEZEL AT SEAT 16C IAW AMM 33-51-11.SDR AALA202105069028Anti-Ice Valve · cloggedAIRCRAFT WAS GROUNDED: REJECTED TAKEOFF DUE TO ANTI-ICE INDICATION ISSUE. UNCLOGGED RH ENGINE ANTI-ICE VALVE ORIFICE IAW AMM 30-21-11-100-801, OPS CHECK GOOD.SDR AALA202105069026Cover · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT COVERS DETACHED FROM SEATS 12C AND 26C. REPLACED LIGHT COVERS AT 12C (AALA202105049013) AND 26C IAW AMM 33-51-11, OPS CHECK GOOD.SDR AALA202105049013Cover · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT COVERS DETACHED FROM SEATS 12C AND 26C. REPLACED LIGHT COVERS AT 12C AND 26C (AALA202105069026) IAW AMM 33-51-11, OPS CHECK GOODSDR AALA202105049009Lens · missingAIRCRAFT WAS NOT GROUNDED: EMERGENCY AISLE LIGHT MISSING LENS ON BULL NOSE CEILING PANEL ABOVE SEAT 23DEF. REPLACED LIGHT LENS WITH NEW IAW AMM 33-51-03, OPS CHECK GOOD.SDR AALA202105049008Module · faultedAIRCRAFT WAS GROUNDED: CAPTAINS AIRSPEED UNRELIABLE DURING ICING CONDITIONS. 60 KNOTS VARIATION WITH AIRSPEED AURAL WARNING. EXITED ICING CONDITIONS AIRSPEED INDICATIONS RETURNED TO NORMAL AFTER 2 MINUTES, REPLACED WINDOW / PITOT HEAT MODULE PER AMM 30-41-41.SDR AALA202105049010Lens · missingAIRCRAFT WAS NOT GROUNDED: EMERGENCY AISLE LIGHT ON LOWERED AFT ENTRY CENTER CEILING PANEL IS MISSING LENS. REPLACED LENS ON AFT LOWER CEILING PANEL. CHECKS GOOD REF AMM 33-51-03.SDR AALA202105059009Heater · faultyAIRCRAFT WAS GROUNDED: AFTER TAKEOFF, BURNING RUBBER ODOR REPORTED IN AFT GALLEY. REPLACED AFT WATER HEATER IAW AMM 38-13-01, OPS CHECK GOOD.SDR AALA202105039007Gust Lock · lack of lubeAIRCRAFT WAS GROUNDED: FLIGHT ATTENDANT REPORTS FORWARD ENTRY DOOR GUST LOCK IS DIFFICULT TO RELEASE. LUBRICATED GUST LOCK AS REQUIRED.SDR AALA202105039001Smoke Detector · false indicationAIRCRAFT WAS NOT GROUNDED: LAVATORY E SMOKE DETECTOR SOUNDED FOR 15 SECONDS AND TURNED OFF. NO EVIDENCE OFSMOKE OR FUMES NOTED. NO INDICATIONS IN FLIGHT DECK. REPLACED SMOKE DETECTOR IN LAVATORY E IAW AMM 26-14-01.SDR AALA202105039005Girt Bar · out of adjustAIRCRAFT WAS NOT GROUNDED: VERY HARD TO INSTALL AND REMOVE GIRT BAR FROM RIGHT HAND CLIP ON 1R DOOR. OPENED AND ADJUSTED CLIP. OPERATIONS CHECK NORMAL.SDR AALA202105089001Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: FORWARD CARGO COMPARTMENT AFT LEFT FLOOR SUPPORT AT LBL 21.80 STA500G TO 500I IS CORRODED. REPAIRED FORWARD CARGO COMPARTMENT AFT L/H FLOOR PANEL SUPPORT IAW B737NG SRM 53-00-53-2R-5.SDR AALA202105029011Bulkhead Web · crackedAIRCRAFT IN BASE MAINTENANCE: 1.25 INCH LONG CRACK FOUND ON WEB BETWEEN LBL 31.83 AND LBL 40 ON LEFT SIDE OF WING CENTER SECTION KEEL BEAM. INSTALLED DOUBLER REPAIR PER B737NG SRM 57-10-10-2R REPAIR 4.SDR AALA202105039009Stop Pin · out of positionAIRCRAFT WAS GROUNDED: FWD ENTRY DOOR DIFFICULT TO OPEN/CLOSE AND LATCH. REPLACED LOWER FWD STOP PIN ON L1 DOOR IAW AMM 52-11-00, OPS CHECK GOOD.SDR AALA202105049018Stiffener · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIB STIFFENER OF RH HORIZONTAL STABILIZER AT STA 166.30, MEASURING L=3.0 IN. ACCOMPLISHED PERMANENT REINFORCING REPAIR WITH NESTED ANGLES IAW SRM 55-10-09-2R-4.SDR AALA202105049017Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LOWER SKIN OF RH HORIZONTAL STABILIZER AT STA 175.5, MEASURING L=3.0 IN. ACCOMPLISHED PERMANENT REINFORCING DOUBLER REPAIR IAW SRM 55-10-01-2R-11.SDR AALA202105049027Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: RIGHT TRANSITION PANEL BAFFLE CLIP CRACKED AT STA 500H AND STR 25R. INSTALLED RIGHT TRANSITION PANEL BAFFLE CLIP IAW AARD 51-00-05-01 AND SRM 51-40-02.SDR AALA2021050390004Floor Panel · crackedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN FLOOR STRUCTURE STA 540 2EA PANEL BREAKS FROM LBL25 TO RBL25 CRACKED. REMOVED AND REPLACED PANELS BREAK AT MAIN CABIN FLOOR STRUCTURE STA 540 FROM LBL25 TO RBL25 PER REF B737-NG SRM 51-40-02.SDR AALA202105019002Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: CABIN ENTRY DOOR DIFFICULT TO CLOSE. LUBRICATED DOOR (L1) PER FIM 52-10-00.SDR AALA202105049016Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LOWER SKIN OF LH HORIZONTAL STABILIZER AT STA 129.5, MEASURING L=1.5 IN. ACCOMPLISHED PERMANENT REINFORCING DOUBLER REPAIR IAW SRM 55-10-01-2R-11.
Back to Boeing 737-823