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 AALA202106239018Window · leakingAIRCRAFT WAS GROUNDED: LOUD SQUEAL FROM FLIGHT DECK WINDOWS WHILE CLIMBING FROM 3,700 THROUGH 10,000 FT, FLIGHT RETURNED TO FIELD. REPLACED L1 AND R1 (AALA202106239019) WINDOWS IAW WORKCARDS 08L21056003 AND 08L21056004, LEAK AND OPS CHECK GOOD.SDR AALA202106219028Slide · dislodgedAIRCRAFT WAS NOT GROUNDED: R1 DOOR SLIDE DISLODGED FROM BUSTLE. REINSTALLED R1 SLIDE BACK INTO COVER IAW AMM 25-66-01, OPS CHECK GOOD.SDR AALA202106219029Retainer · bindingAIRCRAFT WAS GROUNDED: 1R GIRT BAR HARD TO DISARM. ADJUSTED GIRT BAR RETAINERS AS REQUIRED ON DOOR 1R IAW AMM 25-66-00.SDR AALA202107135978Support Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN SUPPORT ANGLE AT 6L AND STA 663. REMOVED AND REPLACED THE DEFECTIVE ANGLE AND INSTALLED IDENTICAL, SERVICEABLE ANGLE.SDR AALA202106305888Support Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN SUPPORT ANGLE AT STA 663 ON LEFT SIDE OF KEEL BEAM. REMOVED AND REPLACED SUPPORT ANGLE REF SRM 57-10-10-2R-5.SDR AALA202106229008Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON INTERCOSTAL LOCATED AT STA 360 AND S28L. REPARIED PER AARD 51-20-01-1 AND EA 328108.SDR AALA202106219034Anti-Skid Valve · faultyAIRCRAFT WAS GROUNDED: ANTI-SKID INOPERATIVE LIGHT ILLUMINATED IN FLIGHT, FLIGHT DECLARED EMERGENCY AND RETURNED TO FIELD. REPLACED #4 ANTI-SKID VALVE IAW AMM 32-42-31, LEAK AND OPS CHECK GOOD.SDR AALA202106219023Cover · looseAIRCRAFT WAS NOT GROUNDED: L1 DOOR SLIDE COVER LOOSE. SECURED L1 DOOR SLIDE COVER IAW AMM 25-66-01.SDR AALA202106219022Light · looseAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT AT 28C HANGING FROM SIDE OF SEAT. RE INSTALLED EMERGENCY LIGHT AT SEAT 28C PER AMM 33-15-02.SDR AALA202106219016Quick Disconnect · disconnectedAIRCRAFT WAS GROUNDED: BRAKES #3 AND #4 FAILED ON LANDING. NO BRAKING ON RIGHT SIDE. FOUND #3 & #4 BRAKE QUICK DISCONNECTS, DISCONNECTED. REMOVED AND REPLACED #3 QUICK DISCONNECT BARREL. RECONNECTED #3 AND #4 BRAKE QUICK DISCONNECTS.SDR AALA202106219002Module · faultyAIRCRAFT WAS GROUNDED: AT APPROXIMATELY 10,000 FEET ENGINE 2 OVERHEAT LIGHT ILLUMINATED. ENGINE 1 FIRE LIGHT AND ENGINE 1 OVERHEAT DOES NOT TEST. RETURNED TO FIELD. REPLACED CHAFED HARNESS MW0325 (AALA202106189013) PER AMM 26-11-02 AND AMM 26-10-01. REPLACED SDR AALA202106189013Wire Harness · chafedAIRCRAFT WAS GROUNDED: AT APPROXIMATELY 10,000 FEET ENGINE 2 OVERHEAT LIGHT ILLUMINATED. ENGINE 1 FIRE LIGHT AND ENGINE 1 OVERHEAT DOES NOT TEST. RETURNED TO FIELD. **SUPPLEMENTAL REPORT: REPLACED CHAFED HARNESS MW0325 (AALA202106189013) PER AMM 26-11-02 AND ASDR AALA202106189019Retainer · looseAIRCRAFT WAS NOT GROUNDED: FWD SERVICE DOOR GIRT BAR CLIP LOOSE. SECURED CLIP IAW AMM 25-66-01, OPS CHECK GOOD.SDR AALA202106189018Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT MEGAPHONE WILL NOT FUNCTION. REPLACED BATTERY IN AFT MEGAPHONE IAW AMM 25-00-00, OPS CHECK GOOD.SDR AALA202106189017Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHTS NOT ARMED ANNUNCIATOR LIGHT NEEDS ONE BULB. RELAMPED EMERGENCY EXIT LIGHT ANNUNCIATOR.SDR AALA202106189015Smoke Detector · false activationAIRCRAFT WAS NOT GROUNDED: LAVATORY SMOKE LIGHT ILLUMINATED MOMENTARILY. FLIGHT ATTENDANT FOUND NO INDICATION OF SMOKE OR FIRE. REPLACED AFT LEFT LAVATORY SMOKE DETECTOR PER AMM 26-14-00.SDR AALA202106179016Switch · false activationAIRCRAFT WAS GROUNDED: REJECTED TAKEOFF AT 84 KTS DUE TO TAKEOFF CONFIGURATION WARNING. REPLACED SPEED BREAK TAKEOFF WARNING SWITCH PER AMM 31-51-03. ASDR AALA202106179015Windshield · delaminatedAIRCRAFT WAS NOT GROUNDED: BUBBLE IN FIRST OFFICERS R1 WINDSHIELD. MEASURES 0.5 BY 0.4 INCH, 7 INCHES FROM CENTER WINDOW EDGE AND 1.5 INCHES FROM LOWER WINDOW EDGE. DOES NOT IMPAIR VISIBILITY. **SUPPLEMENTAL REPORT: REPLACED WINDSHIELD PER TASK CARD 08L2105600SDR AALA202106189027Switch · faultedAIRCRAFT WAS GROUNDED: REJECTED TAKEOFF DUE TO TAKEOFF CONFIG WARNING FAULT 31-53007 ON PSEU. REPLACED SPEEDBRAKE WARNING SWITCH S651 WITH NEW IAW FIM 27-62-00-810-808, OPS CHECK GOOD.SDR AALA202106189023Switch · defectiveAIRCRAFT WAS GROUNDED: TAKE OFF CONFIG WARNING HORN AT TAKE OFF, TAKE OFF CONFIGURATION CHECKED GOOD. MAINTENANCE FOUND FAULT 31-53007 ON PSEU, SPEED BRAKE HANDLE UP. PER FIM 27-62-00-810-808. REPLACED SPEED BREAK WARNING SWITCH S651. OPERATIONAL CHECKED GOOD,SDR AALA202106189012Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: FOUND OVER WING EMERGENCY LIGHT, RIGHT WING FORWARD POSITION, INOPERATIVE. REPLACED EMERGENCY LIGHT LAMP AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-04.SDR AALA202106179023Sensor · looseAIRCRAFT WAS GROUNDED: REJECTED TAKEOFF AT 50 KTS FOR TAKEOFF CONFIG WARNING; L/E FLAPS TRANSIT LIGHT FLASHED AMBER THEN BACK TO L/E FLAPS EXTEND GREEN. TIGHTENED SENSOR S172 L/E FLAP 3 RETRACT IAW AMM 27-88-11-400-801, OPS CHECK GOOD.SDR AALA202106179022Sign · dislodgedAIRCRAFT WAS NOT GROUNDED: EXIT SIGN OVER RIGHT AFT DOOR IS HANGING. SECURED EXIT SIGN.SDR AALA202106179024Slide · exposedAIRCRAFT WAS NOT GROUNDED: AFT LEFT (4L) DOOR SLIDE MANUAL INFLATION HANDLE DANGLING/EXPOSED. RESECURED AFT SLIDE HANDLE PER AMM 25-66-00.SDR AALA202106179021Hook · looseAIRCRAFT WAS NOT GROUNDED: DOOR 1R GIRT BAR CLIP RIGHT SIDE LOOSE, DOES NOT HOLD BAR IN WELL. BENT RETAINER CLIP TO HOLD GIRT BAR, DOOR 1R PER AMM 25-66-01.SDR AALA202107131940Stiffener · damagedAIRCRAFT IN BASE MAINTENANCE: ON STIFFENER AT STA927 RBL 24.75 FOUND DAMAGE ON INCOMING VISUAL INSPECTION. REPLACED STIFFENER IAW B737-NG SRM 51-40-02.SDR AALA202107139710Stiffener · damagedAIRCRAFT IN BASE MAINTENANCE: STIFFENER AT STA LBL 24.75 FOUND DAMAGED ON INCOMING VISUAL INSPECTION. REPLACED STIFFENER IAW BAC DWG 147A5350 & B737-NG SRM 51-40-02.SDR AALA202106189030Light · missingAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT DAMAGED AND NOT SECURED AT SEAT 23C. REPLACED LIGHT ASSEMBLY WITH NEW IAW AMM 33-51-11, OPS CHECK GOOD.SDR AALA202106179029Bolt · missingAIRCRAFT WAS NOT GROUNDED: FOUND 2 BOLTS MISSING FROM 1L DOOR UPPER HINGE SUPPORT ASSEMBLY, DOOR DIFFICULT TO OPEN. INSTALLED 2EA BOLTS (SEE ALSO AALA202106179026) IAW IPC 52-11-11-01A, OPS CHECK GOOD.SDR AALA202106179026Bolt · missingAIRCRAFT WAS NOT GROUNDED: FOUND 2 BOLTS MISSING FROM 1L DOOR UPPER HINGE SUPPORT ASSEMBLY, DOOR DIFFICULT TO OPEN. INSTALLED 2EA BOLTS (SEE ALSO AALA202106179029) IAW IPC 52-11-11-01A, OPS CHECK GOOD.SDR AALA202106169008Girt Bar · seizedAIRCRAFT WAS NOT GROUNDED: R1 DOOR GIRT BAR IS TOO TIGHT. ADJUSTED AND LUBRICATED GIRT BAR IAW AMM 52-11-00, OPS CHECK GOOD.SDR AALA202107136121Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FOUND ON FLOOR BEAM AT STA 987, LEFT BUTT LINE 45. INSTALLED REPAIR PER EA NUMBER 328558 AND SRM 53-70-51-2R-6.SDR AALA202107134001Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: FORWARD CARGO RIGHT TRANSITION PANEL HAS CORROSION LOCATED AT 500F+6, STR L24 R. REPLACED CORRODED TRANSITION PANEL PER SRM 53-30-53-2R.SDR AALA202107136107Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FOUND ON TRANSITION PANEL LOCATED FROM 500C TO 500H, WATERLINE 360, BUTT LINE 540. INSTALLED ZEE ANGLE CHANNEL ASSEMBLY PER SRM 51-40-02.SDR AALA202107137655Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FOUND ON TRANSITION PANEL LOCATED AT 727G-767, BUTT LINE 44. REPLACED TRANSITION PANEL PER SRM 51-40-02.SDR AALA202107134717Transition Panel · corrodedAIRCRAFT WAS IN BASE MAINTENANCE: CORROSION FOUND ON TRANSITION PANEL LOCATED AT STA 727H, LEFT BUTT LINE 44. REPLACED TRANSITION PANEL PER SRM 51-40-02.SDR AALA202106306387Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: FORWARD CARGO RIGHT TRANSITION PANEL AT STA 500F AND 24R IS CORRODED. REPLACED TRANSITION PANEL REF SRM 53-30-53-2R.SDR AALA202106302365Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FLOOR BEAM LOCATED AT STA 987 AND LBL 45. REPAIRED FLOOR BEAM PER EA 328558 SRM 53-70-51-2R-6.SDR AALA202106189029O-Ring · leakingAIRCRAFT WAS GROUNDED: RH ENGINE OIL QUANTITY DECREASED BY 12 QUARTS INFLIGHT, FLIGHT DIVERTED TO PIT. REPLACED O-RING AT SCAVENGE OIL FILTER TRANSMITTER WITH NEW IAW AMM 79-21-07, LEAK AND OPS CHECK GOOD.SDR AALA202106189028Packing · leakingAIRCRAFT WAS GROUNDED: SYSTEM A HYDRAULIC FLUID LOSS, FLIGHT DECLARED EMERGENCY AND DIVERTED TO IAH. REPLACED PACKING AT PRESSURE SWITCH AND MODULE INTERFACE IAW AMM 29-31-12-401, LEAK AND OPS CHECK GOOD.SDR AALA202106159006Lamp · inoperativeAIRCRAFT IN BASE MAINTENANCE: R2 DOOR EXTERIOR EMERGENCY LIGHT NOT ILLUMINATING. RELAMPED R2 DOOR EXTERIOR EMERGENCY LIGHT IAW B737 AMM 33-51-04-960-801, OPS CHECK GOOD.SDR AALA202106159003Girt Bar · out of positionAIRCRAFT WAS NOT GROUNDED: GIRT BAR ON 1L FELL OUT DURING OPENING OF DOOR SLIDE PACK APPEARS LOW IN SLIDE CASING. REMOVED SLIDE 1L DOOR REATTACHED VELCRO REINSTALLED SLIDE PER AMM 25-66-01.SDR AALA202106159002Cover · crackedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN CEILING EXIT SIGN HOUSING ASSEMBLY HAS CRACKED COVERS. REPLACED COVERS.SDR AALA202106149014Wire Harness · faultedAIRCRAFT WAS GROUNDED: ENGINE 2 OVERHEAT INDICATION CLIMBING OUT OF 12000 MSL. REPLACED ENGINE 2 FIRE DETECTION HARNESS MW0326 PER AMM 26-11-00-710-801.SDR AALA202106149023Sign · missingAIRCRAFT WAS NOT GROUNDED: EXIT ROW 15 SEATS DEF EXIT SIGN COVER MISSING AND CLIPS ARE BROKEN. REPLACED EMERGENCY EXIT SIGN ASSEMBLY PER AMM 33-51-00.SDR AALA202106149022Light · dislodgedAIRCRAFT WAS NOT GROUNDED: EMERGENCY PATHWAY LIGHT HANGING OFF OF SEAT 31C. REINSTALLED LIGHT ASSEMBLY PER AMM 33-51-11.SDR AALA202106149017Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: LH AFT LAVATORY DOOR IS DIFFICULT TO OPEN AND CLOSE. LUBRICATED LH AFT LAVATORY DOOR IAW AMM 25-40-14, OPS CHECK GOOD.SDR AALA202106149025Relay · inoperativeAIRCRAFT WAS NOT GROUNDED: PRESSURIZATION PANEL AUTO FAIL AND ALTERNATE LIGHT ILLUMINATED WITH CONTROL SWITCH IN AUTO. FLIGHT DECLARED EMERGENCY. WAS NOT OVERWEIGHT FOR LANDING. REMOVED AND REPLACED RELAYS 556 (AALA202106149013), 557 (AALA202106149024), 558 PESDR AALA202106149024Relay · inoperativeAIRCRAFT WAS NOT GROUNDED: PRESSURIZATION PANEL AUTO FAIL AND ALTERNATE LIGHT ILLUMINATED WITH CONTROL SWITCH IN AUTO. FLIGHT DECLARED EMERGENCY. WAS NOT OVERWEIGHT FOR LANDING. REMOVED AND REPLACED RELAYS 556 (AALA202106149013), 557, 558(AALA202106149025) PERSDR AALA202106149018Hook · brokenAIRCRAFT WAS GROUNDED: SERVICE DOOR 1R GIRT BAR HAS FALLEN OUT OF ONE OF IT'S CLIPS WITH THE DOOR OPEN. REMOVED SLIDE PACK AND COVER PER AMM 25-66-01. REPAIRED RETAINER CLIP USING RIVETS AS REQUIRED. RE-INSTALLED SLIDE PACK AND COVER PER AMM 25-66-01. STOWED G
Back to Boeing 737-823