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 AALA201906199022Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON INTERCOSTAL BETWEEN BS 294 AND BS 312 AT S23L. REPLACED INTERCOSTAL PER EA 294928 AND AARD 51-00-05-1.SDR AALA201906199021Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE, CORROSION ON INTERCOSTAL BETWEEN BS 294.5 AND BS 360 AT S23L. REPLACED INTERCOSTAL PER EA 294928 AND AARD 51-00-05-1.SDR AALA201906199020Shear Web · corrodedAIRCRAFT IN BASE MAINTENANCE, CORROSION ON SHEAR WEB BETWEEN BS 949 AND BS 986.5 BETWEEN RBL 35 AND RBL 45. REPLACED SHEAR WEB.SDR AALA201906199019Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON INTERCOSTAL BETWEEN BS 312 AND BS 325 AT S23L. REPLACED INTERCOSTAL PER EA 294928 AND AARD 51-00-05-1.SDR AALA201906199017Shear Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT WET AREA FLOOR SHEAR WEB BETWEEN BS 986.5 AND BS 992.8 AT RBL 45. REPAIRED SHEAR WEB PER EA 295213.SDR AALA2019061989018Shear Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT WET AREA FLOOR SHEAR WEB BETWEEN BS 986 AND BS 1016, BETWEEN LBL 10 AND RBL 10. REPAIRED SHEAR WEB PER EA 294419.SDR AALA2019061989017Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL BETWEEN BS 727 AND BS 767. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA2019062099002Sign · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT SIGN HANGING FROM CEILING MID CABIN. MAINTENANCE SECURED EMERGENCY EXIT SIGN FROM CEILING MID CABIN AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER 25-00-00 AWM.SDR AALA2019061989016Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT WET AREA FLOOR WEB BETWEEN BS 1019 AND BS 1028, BETWEEN RBL 5 AND RBL 11. REPAIRED FLOOR WEB PER EA 294419.SDR AALA2019061879001Pitot Tube · faultyAIRCRAFT WAS GROUNDED: PILOT REPORTS AIRSPEED DISAGREE / ALT DISAGREE CAUTIONS, AIRSPEED LOW WARNING IN FLIGHT FL 280, EEC (S) WENT TO ALTERNATE MODE. EVENTUALLY FO SIDE RETURNED TO NORMAL, FOLLOWED BY CA SIDE RETURNING TO NORMAL APPROX. 5 MIN LATER. ALL ENGSDR AALA2019061879010Brake Assy · chatteringAIRCRAFT WAS GROUNDED: PILOT REPORTS BRAKE CHATTERING DURING TAXI, SHAKING AIRCRAFT AT LOW SPEEDS, DIFFICULT TO STOP AIRCRAFT SMOOTHLY. MAINTENANCE REMOVED AND REPLACED THE NO. 3 AND 4 BRAKE ASSY. IAW AMM 32-41-41. PREFORMED TAXI CHECK, NO DEFECTS NOTED AT THISDR AALA201906189036Brake Assy · chatteringAIRCRAFT WAS GROUNDED: PILOT REPORTS BRAKE CHATTERING DURING TAXI, SHAKING AIRCRAFT AT LOW SPEEDS, DIFFICULT TO STOP AIRCRAFT SMOOTHLY. MAINTENANCE REMOVED AND REPLACED THE NR 3 AND 4 BRAKE ASSY. IAW AMM 32-41-41. PREFORMED TAXI CHECK, NO DEFECTS NOTED AT THISSDR AALA2019061879019Sign · detachedAIRCRAFT WAS NOT GROUNDED: EXIT SIGN LENS AT 15F FELL OFF IN FLIGHT DECK. MAINTENANCE REPLACED EXIT SIGN AT 15F PER AMM 33-50-51.SDR AALA201906189008Indicator · malfunctionedAIRCRAFT WAS NOT GROUNDED: ENROUTE AT 10,000 LBS, DISCREPANCY DEVELOPED BETWEEN TOTAL FUEL AND FMS FUEL. FLIGHT LANDED SAFELY WITHOUT FURTHER INCIDENT. MAINTENANCE ACCOMPLISHED MEASURING STICK CHECK PER AMM 12-11-07, STICKS AND QUANTITY INDICATOR AGREED. MAINTSDR AALA201906189011Control Rod · out of adjustAIRCRAFT WAS GROUNDED: HANDLE AT 2L AFT ENTRY DOOR POPPED UP ON THE TAKEOFF ROLL, CAUSING MASTER CAUTION AND LOW SPEED 30 KNOT REJECT. HANDLE DOWN WAS PLACED DOWN AND IT POPPED AGAIN AFTER LIFT OFF. MAINTENANCE ACCOMPLISHED DOOR SYSTEM TEST PER AMM 52-13-00-70SDR AALA201906179041Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON INTERCOSTAL BETWEEN BS 294.5 AND BS 312 AT S23L. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA2019061879002Warning Horn · false activationAIRCRAFT NOT GROUNDED: PILOT REPORTS LANDING GEAR WARNING HORN SOUNDED AND 3 LANDING GEAR RED LIGHTS ILLUMINATED AT 10,500 FEET, THROTTLES IDLE, FLAPS UP, 250KIAS. MAINTENANCE PERFORMED PSEU BITE TEST IAW FIM 32-04-00-810-801. NO FAULTS FOUND. PERFORMED RADIOSDR AALA2019061879003Outlet · burnedAIRCRAFT WAS GROUNDED: DURING DESCENT FLIGHT ATTENDANTS REPORTED A BURNING, ELECTRICAL SMELL BETWEEN ROWS 6 AND 13. SMELL LASTED A FEW MINUTES THEN DISSAPATED. MAINTENANCE ACCOMPLISHED ODOR CARD 05-96-70 AND FOUND A FEW BAD POWER PORTS. MAINTENANCE ALSO REPLACSDR AALA201906179044Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FLOOR SUPPORT AT BS 1014.75 AND LBL 31.5. REPLACED FLOOR SUPPORT PER AARD 51-00-05-1.SDR AALA201906179043Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FLOOR SUPPORT AT BS 993 BETWEEN LBL 33 AND LBL 45. REPLACED FLOOR SUPPORT PER AARD 51-00-05-1.SDR AALA201906179042Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FLOOR SUPPORT AT BS 993 BETWEEN RBL 33 AND RBL 46. REPLACED FLOOR SUPPORT PER AARD 51-00-05-1.SDR AALA2019061879023Apu · fireAIRCRAFT WAS GROUNDED: DURING APU START, THE APU SHUT DOWN ALL ELECTRICITY AND AIR. BATTERY WAS DISCHARDING AND RAMP PERSONNEL NOTED FLAMES COMING FROM OUTSIDE THE APU TAIL PIPE AREA. FLAMES WRAPPED AROUND EXHAUST AND FLAMES EXTINGUISHED, NO FIRE EXTINGUISHINGSDR AALA201906198032Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD WET AREA FLOOR BEAM AT BS 328 BETWEEN RBL 10 AND RBL 11. REPAIRED FLOOR BEAM PER EA 295255.SDR AALA201906179032Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL SHIELD BETWEEN BS 767 AND BS 787 AT RBL 21. REPLACED SHIELD PER AARD 51-00-05-1.SDR AALA201906179029Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND FLOOR BOARD INTERCOSTAL CRACKED BETWEEN BS 328 AND BS 344. REPLACED INTERCOSTAL PER AARD 53-00-05.SDR AALA2019061749004Indicator · false indicationAIRCRAFT WAS GROUNDED: PILOT DECLARED EMERGENCY ON ACCOUNT OF FUEL LEAK. FUEL LEAK LEFT TANK AFTER T.O. LEFT SIDE 2000 LBS LOW AFTER 22 MINUTES. EMERGENCY WAS DECLARED AND THEY WERE OVERWEIGHT FOR LANDING. FLIGHT LANDED WITHOUT INCIDENT. MAINTENANCE PERFORMED SDR AALA201906149007Windshield · crackedAIRCRAFT WAS GROUNDED: FIRST OFFICERS WINDSHIELD CRACKED IN FLIGHT. REPLACED WINSHIELD PER TASK CARD 56-94-04.SDR AALA201906149001Tire · failedAIRCRAFT WAS GROUNDED: PILOT REPORTS RIGHT MAIN INBOARD TIRE FAIL ON TOUCHDOWN. MAINTENANCE REPLACED # 3 MLG TIRE/WHEEL ASSY IAW AMM 32-45-11. OK FOR SVC.SDR AALA20190619031Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL BETWEEN BS 492 AND BS 500A. REPLACED TRANSITION PANEL PER AARD 51-00-05.SDR AALA20190619030Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO DOOR CUT OUT LOWER SILL WEB BETWEEN BS 444 AND BS 448, BETWEEN RBL 25 AND RBL 32. REPLACED WEB PER AARD 51-00-05.SDR AALA20190619029Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO DOOR CUT OUT LOWER SILL WEB BETWEEN BS 790 AND BS 847. REPLACED WEB PER AARD 51-00-05.SDR AALA20190619028Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT FLOOR SUPPORT AT BS 500I BETWEEN LBL 24 AND RBL 24. REPLACED FLOOR SUPPORT PER AARD 51-00-05-1.SDR AALA20190619027Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL BETWEEN BS 500A AND BS 500I AT S25R. REPLACED TRANSITION PANEL PER AARD 51-00-05.SDR AALA201906179040Bulkhead Web · crackedAIRCRAFT IN BASE MAINTENANCE: CENTER WING REAR SPAR LEFT HAND VERTICAL PRESSURE WEB CRACKED AT BS 663 AND LBL 33. REPAIRED PRESSURE WEB PER EA 294389.SDR AALA201906179031Transition Panel · corrodedAIRCRAFT IN BASE MAINTENENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL BETWEEN BS 727A AND BS 847. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA2019061439004Motor · bindingAIRCRAFT WAS GROUNDED: PILOT REPORTS AFTER LANDING, STAB TRIM JAMMED BOTH ELECTRIC AND MANUAL. MAINTENANCE REMOVED AND REPLACED STABILIZER TRIM MOTOR IAW AMM 27-41-71-400-801. ACCOMPLISHED ALL REQUIRED TESTS IAW AMM 27-41-700-801 AND 22-11-81-710-801. OPS CHECSDR AALA2019061439003Memory Device · smokeAIRCRAFT WAS GROUNDED: PILOT REPORTS SMOKE COMING FROM FIRST OFFICERS YOKE. MAINTENANCE ACCOMPLISHED CARD 05-96-70 AND FOUND F/OS CONTROL COLUMN MEMORY DEVICE AT FAULT. VISUALLY INSPECTED WIRES, FOUND OKAY. REPLACED F/OS CONTROL COLUMN DEVICE IAW AMM 33-11-00.SDR AALA201906149011Battery · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY FLASHLIGHT LOW ON POWER. MAINTENANCE REPLACED BATTERY ON FLASHLIGHT PER AMM 25-64-00.SDR AALA201906149016Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL BETWEEN BS 727 AND BS 767. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA20190619026Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON APU COMPARTMENT RIGHT HAND TUNNEL CLIP BETWEEN BS 1129 AND BS 1130. REPLACED CLIP PER AARD 51-00-05.SDR AALA20190619025Stiffener · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON APU COMPARTMENT WALL LEFT HAND LOWER FORWARD STIFFENER BETWEEN BS 1088 AND BS 1096. REPLACED STIFFENER PER AARD 51-00-05.SDR AALA20190619024Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: FORWARD WET AREA FLOOR INTERCOSTAL CRACKED BETWEEN BS 312 AND BS 328 AT LBL 45. REPLACED INTERCOSTAL PER SRM 51-40-02.SDR AALA2019061989023Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: FORWARD WET ARE FLOOR INTERCOSTAL CRACKED BETWEEN BS 328 AND BS 344 AT LBL 45. REPLACED INTERCOSTAL PER SRM 51-40-02.SDR AALA201906179039Strap · wornAIRCRAFT IN BASE MAINTENANCE: GROUND PNEUMATIC DOOR OUTBOARD LATCH STOP PAD IS WEARING INTO PREVIOUS STRAP CHORD REPAIR BETWEEN BS 540 AND BS 662. REPLACED CHORD PER AARD 51-00-05.SDR AALA201906179028Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND FLOOR BOARD INTERCOSTAL CRACKED BETWEEN BS 312 AND BS 328. REPLACED INTERCOSTAL PER AARD 53-00-05.SDR AALA2019061989022Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND TRANSITION PANEL BETWEEN BS 488.5 AND BS 500I AT S25L. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA2019061329003Drain · cloggedAIRCRAT WAS GROUNDED: FLIGHT ATTENDANTS REPORTED THERE WAS AN IRRITATING ODOR THAT HAD A FRUITY SMELL THAT GAVE THEM A HEADACHE ON TAKE OFF AND VERY PROMINENT ON LANDING. MAINTENANCE ACCOMPLISHED CARD 05-96-70 AS APPLICABLE. UPON INITIAL TROUBLESHOOTING FOUNDSDR AALA201906139002Bellcrank · failedAIRCRAFT WAS GROUNDED: PILOT REPORTS AT 1200FT AGL(R) ENGINE THRUST REDUCED TO 34% (L) 70%, (L) FF 2000 (R) FF 4000, AUTO-THROTTLE DISCONNECTED. (R) ENGINE CONTROL LIGHT ILLUMINATED (R) ENG STABILIZED. (R) ENG CONTROL REMAINED ILLUMINATED UNTIL SHUTDOWN. MAINSDR AALA201906139013Floor Panel · damagedAIRCRAFT WAS GROUNDED: MAIN CABIN FLOOR PANEL AT ROW 6 VERY SPONGY. REPAIRED FLOOR PANEL PER 53-00-00-6.SDR AALA2019061209001Pump · intermittentAIRCRAFT WAS GROUNDED: PILOT REPORTS LT FWD FUEL PUMP LO PRESSURE LT FLASHES SHORT FINAL AND STAYS ON DURING ROLLOUT. MAINTENANCE REPLACED THE LH FWD BOOST PUMP IAW AMM 28-22-41. LEAK AND OPS CHECK DOOD.
Back to Boeing 737-823