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 AALA201909119032Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND TRANSITION PANEL AT FR 500C+10, RBL-20. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R.SDR AALA201909109015Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT HAND TRANSITION ANGLE, FORWARD CARGO FROM FR 460 TO FR 500I, S26L. REPLACED TRANSITION ANGLE PER SRM 53-00-53-2R.SDR AALA201908309031Smoke Warning · false activationAIRCRAFT NOT GROUNDED: PILOT REPORTS LAVATORY SMOKE LIGHT ON OVERHEAD PANEL CAME ON BRIEFLY. MAINTENANCE REPORTS RIGHT AFT LAV SMOKE DETECTOR OPS NORMAL IAW AMM 26-14-00.SDR AALA201908299034Wedge · delaminatedAIRCRAFT WAS GROUNDED: RIGHT WING INBOARD TRAILING EDGE FLAP OUTBOARD WEDGE DELAMINATED. REPAIRED RIGHT WING INBOARD TRAILING EDGE FLAP OUTBOARD WEDGE PER EA 297868.SDR AALA2019082989046Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FRAME FITTING BETWEEN BS 727D AND BS 727E, BETWEEN S8R AND S9R. REPAIRED FRAME PER EA 296947.SDR AALA201910029035Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT WET AREA FLOOR BEAM BOTTOM SIDE AT BS 986.5 AND RBL 4. REPAIRED FLOOR BEAM PER SRM 53-70-51-2R-4.SDR AALA201910029032Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT WET AREA FLOOR BEAM TOP SURFACE AT BS 986.5 BETWEEN BL 0 AND RBL 45. REPAIRED FLOOR BEAM PER SRM 53-70-51-2R-4 AND EA 298245.SDR AALA201910029031Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT WET AREA FLOOR SUPPORT ANGLE AT BS 991 AND RBL 32. REPLACED FLOOR SUPPORT ANGLE PER AARD 51-00-05-01.SDR AALA201910029026Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD WET AREA FLOOR INTERCOSTAL AT BS 328 AND RBL 30. REPLACED INTERCOSTAL PER SRM 51-40-02.SDR AALA201909259019Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON WEB AT BS 986.5 AND RBL 32. REPAIRED WEB PER EA 298200 AND AARD 51-00-05-1.SDR AALA201909239045Support Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT WET AREA FLOOR SUPPORT ANGLE AT BS 1016 AND RBL 32. REPLACED FLOOR SUPPORT ANGLE PER 51-00-05-01.SDR AALA201909199013Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT WET AREA FLOOR CREASE ANGLE BETWEEN BS 950 AND BS 993 AT S17L. REPLACED CREASE ANGLE PER 51-00-05-01 AND EA 298555.SDR AALA201909099047Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON CABIN FLOOR SUPPORT AT FR 951, LBL19. REPLACED FLOOR SUPPORT PER 51-00-05-1 AND DRAWING #147A5650.SDR AALA201909099043Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON CABIN FLOORBEAM AT FR 947.5, LBL13. REPAIRED FLOORBEAM PER SRM 53-00-51-2R AND 53-00-00-7.SDR AALA201909099055Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON CABIN FLOORBEAM AT FR 986.5, RBL-34. REPLACED FLOORBEAM PER SRM 53-70-51-2R-4 AND 51-00-05.SDR AALA201909099053Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON CABIN FLOORBEAM AT FR 947, LBL4. REPAIRED WITH ANGLES, STRAPS, AND FILLER PER SRM 53-00-51-2R, 51-00-05.SDR AALA201909049060Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED INTERCOSTAL AT FR 328, LBL32. REPLACED INTERCOSTAL PER DRAWING #141A5400.SDR AALA201908299026Computer · failedAIRCRAFT WAS GROUNDED: PILOT REPORTS AT CRUISE, CA PFD DATA DISAPPEARED WITH A LOW AIRSPEED AURAL WARNING. LEFT IRS ON DC MOMENTARY THEN ALIGN ANNUNCIATION, BOTH EECS ALTERNATE LEFT TRANSPONDER FAIL. B AUTOPILOT DISCONNECTED. LEFT IRS ON, POSITION PAGE OF FMC SDR AALA201908289019Windshield · looseAIRCRAFT WAS GROUNDED: PILOT REPORTS L-1 FORWARD WINDSHIELD HAS MASSIVE AIR LEAK IN UPPER LEFT CORNER. MAINTENANCE RE-TORQUED THE L1 WINDOW BOLTS IAW AMM 56-11-11-400-801. APPLIED AERODYNAMIC SMOOTHER SEALANT ON PRE-MOLDED SEAL IAW AMM 56-11-00-300-801. ACCOMPSDR AALA201908289035Battery · inoperativeAIRCRAFT NOT GROUNDED: L-1 DOOR O/B JUMP SEAT FLASHLIGHT LOW ON POWER. REMOVED AND REPLACED BATTERY ON FLASHLIGHT IAW AMM 25-64-00.SDR AALA201909179024Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT FLOOR SUPPORT AT BS 500I BETWEEN LBL 24 AND RBL 24. REPLACED FLOOR SUPPORT PER 51-00-05-01. **SUPPLEMENTAL REPORT: ENGINEERING REVIEWED THIS EVENT AND DETERMINED THE CORRECT LEVEL WAS LEVEL 1SDR AALA201909169044Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500A AND BS 500I AT RBL 23. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5. **SUPPLEMENTAL REPORT: ENGINEERING REVIEWED THIS EVENT AND DETERMINED THE CORRECT LEVESDR AALA201909119031Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT HAND TRANSITION PANEL BETWEEN BS 727 AND BS 847, S27L. REPLACED TRANSITION PANEL PER 51-00-05-1 AND PRINT 146A7510. **SUPPLEMENTAL REPORT: ENGINEERING REVIEWED THIS EVENT AND DETERMINED THE CORRECT LEVEL WAS LEVESDR AALA201909119030Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON UPPER LEFT HAND TRANSITION PANEL FROM BS 400 TO BS 500I, S25L, LBL24. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R, 51-00-05-1. **SUPPLEMENTAL REPORT: ENGINEERING REVIEWED THIS EVENT AND DETERMINED THE CORRECT LEVEL SDR AALA201909119029Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO RIGHT HAND TRANSITION PANEL FROM BS 500A TO BS 500I, S25R, RBL 24. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R 5. **SUPPLEMENTAL REPORT: ENGINEERING REVIEWED THIS EVENT AND DETERMINED THE CORRECT LEVELSDR AALA201909099068Threshold · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO DOOR CUT OUT LOWER THRESHOLD WEB BETWEEN BS 807 AND BS 847 AT S27R. REPLACED THRESHOLD WEB PER AARD 51-00-05-1. **SUPPLEMENTAL REPORT: ENGINEERING REVIEWED THIS EVENT AND DETERMINED THE CORRECT LEVEL WAS LEVSDR AALA201909099049Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND TRANSITION PANEL AFT CARGO FROM BS 884 TO BS 927, S27R. REPLACED TRANSITION PANEL PER SRM 53-00-53-1A-2. **SUPPLEMENTAL REPORT: ENGINEERING REVIEWED THIS EVENT AND DETERMINED THE CORRECT LEVEL WAS LEVEL 1 NSDR AALA201909099048Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND TRANSITION PANEL FROM BS 727 TO BS 767, S27R. REPLACED TRANSITION PANEL PER SRM 53-00-53-1A-2. **SUPPLEMENTAL REPORT: ENGINEERING REVIEWED THIS EVENT AND DETERMINED THE CORRECT LEVEL WAS LEVEL 1 NOT LEVEL 2SDR AALA201909049063Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT SHIELD BETWEEN BS 492 AND BS 500A AT RBL 23. REPLACED SHIELD PER 51-00-05 AND EA 297937. **SUPPLEMENTAL REPORT: ENGINEERING REVIEWED THIS EVENT AND DETERMINED THE CORRECT LEVEL WAS LEVEL 1 NOSDR AALA201910119020Skin · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON EXTRIOR FUSELAGE SKIN UNDER THE AFT CARGO COMPARTMENT DOOR CUT OUT SCUFF PLATE BETWEEN BS 792 AND BS 847 AT S25R. REMOVED CORROSION BY BLENDING PER INSTRUCTIONS OUTLINED IN EA 297947B.SDR AALA201909199014Support Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LOWER BULKHEAD SUPPORT ANGLE AT BS 947 BETWEEN LBL 9 AND RBL 20. REPLACED SUPPORT ANGLE PER 51-00-05-1.SDR AALA201909179023Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON R1 DOOR CUT OUT VERTICAL CREASE ANGLE BETWEEN BS 320 AND BS 333 AT S17R AND RBL 56. REPLACED CREASE ANGLE PER SRM 51-70-13.SDR AALA201909179020Support Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT FLOOR SUPPORT ANGLE AT BS 500I BETWEEN LBL 24 AND RBL 24. REPLACED FLOOR SUPPORT ANGLE PER SRM 51-40-02.SDR AALA201909119016Cargo Track · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT CARGO TRACK AT BS 792 BETWEEN S25R AND S26R. REPAIRED CARGO TRACK PER EA 298218.SDR AALA201909099050Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND TRANSITION SHIELD FROM FR 495 TO FR 500A, S-25R, RBL-24. REPLACED TRANSITION SHIELD PER 51-00-05-1 AND DRAWING 143A8150.SDR AALA201909099058Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT HAND TRANSITION PANEL FROM FR 470 TO FR 500I, S26L, LBL23. REPLACED TRANSITION PANEL PER SRM 53-00-53.SDR AALA201909049059Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON WEB FROM FR 470 TO FR 480, S-25R, LBL22. REPLACED WEB PER 51-00-05 AND DRAWING 143A8122Y10, SRM 51-40-05, SRM 51-40-08, SRM 51-40-02.SDR AALA201909049065Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON TRANSITION PANEL FROM FR 767 TO FR 787, RBL-20. REPLACED TRANSITION PANEL PER 51-00-05 AND DRAWING 146A8127.SDR AALA201908309020Strap · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON STRAP FROM FR 299 TO FR 323, S23L. REPAIRED STRAP IN BLEND AREA PER EA 297539.SDR AALA201908309019Strap · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON STRAP AT FR 346, S23L. REPAIRED STRAP IN BLEND AREA PER EA 297539.SDR AALA201908289018Exhaust Cone · contaminatedAIRCRAFT WAS GROUNDED: PILOT REPORTS AIRCRAFT BEHIND US REPORTED TAILPIPE FIRE ON LEFT ENGINE, NO FIRE INDICTIONS ON FLIGHT DECK. RAN QRC/QRH AND SHUT ENGINE DOWN. GROUND CREW REPORTED FIRE OUT. FIRE CHIEF REPORTED FIRE OUT. MAINTENANCE INSPECTED NO 1 ENGINE FSDR AALA201908289022Bulkhead Web · crackedAIRCRAFT WAS GROUNDED: RIGHT HAND MAIN LANDING GEAR WHEEL WELL VAPOR BARRIER CRACKED. REPAIRED VAPOR BARRIER PER AARD 57-10-10-9.SDR AALA201908279002Transfer Tube · leakingAIRCRAFT WAS GROUNDED: PILOT REPORTS AT GATE, FUEL INDICATED 8.42/ 6.48 /8.37. DURING CLIMB AND CRUISE W/ CENTER PUMPS ON, RIGHT TANK QUANTITY CLIMBED TO 8.70, LEFT STAYED AT 8.42. ONCE CENTER PUMPS TURNED OFF, FUEL ONLY BURNS FROM LEFT TANK UNTIL AN APPROXISDR AALA201908279004Fire Loop · faultyAIRCRAFT WAS GROUNDED: LEFT WING/BODY OVERHEAT ILLUMINATES WITH T/O POWER SET ON T/O ROLL, ABORT T/O 45 KTS. MAINTENANCE REPLACED FAULTY OVERHEAT LOOP M1761 IAW AMM 26-18-01. OPS CHECK NORMAL.SDR AALA2019120549037Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL ANGLE AT BS 727F AT RBL 21. REPLACED ANGLE PER AARD 51-00-05-1.SDR AALA201909119023Plate · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL SIDE PLATE AT BS 727I AND RBL 21. REPLACED SIDE PLATE PER 51-00-05-1.SDR AALA201909109014Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND TRANSITION ANGLE AT FR 753.5, RBL-21. REPLACED TRANSITION ANGLE PER SRM 53-00-53-2R, DRAWING #146A7502 AND AARD 51-00-05-1.SDR AALA201908279001Indication Sys · malfunctionedAIRCRAFT NOT GROUNDED: PILOT REPORTS FUEL QTY INDICATION ANOMOLY. AFTER CENTER TANKS EMPTIED RIGHT FUEL QTY DROPPED 600 LBS. X-FEEDED BACK TO BALANCE BEFORE TOP OF DESCENT. UPON LANDING RIGHT QTY INCREASED 600 LBS. MAINTENANCE ACCOMPLISHED BITE TEST IAW FIM 28SDR AALA2019082769021Window · delaminatedAIRCRAFT WAS GROUNDED: FLIGHT DECK R1 WINDOW DELAMINATED. REPLECED WINDOW PER TASK CARD 56-94-04.SDR AALA201908279007Flashlight · inoperativeAIRCRAFT NOT GROUNDED: EMERGENCY FLASHLIGHT WILL NOT TEST. UNDER F/A SEAT FWD INBD POSITION. REPLACED BATTERY PACK AND SEAL ON FWD INBD EMERGENCY FLASHLIGHT IAW AMM 25-64-00. OK FOR SERVICE.
Back to Boeing 737-823