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 AALA202004209009Power Supply · inoperativeAIRCRAFT NOT GROUNDED - RIGHT EXTERIOR EMERGENCY SLIDE LIGHT INOPERATIVE. RELAMPED, NO HELP. REMOVED AND REPLACED POWER SUPPY (M1671) PER AMM 33-51-06, OPERATIONAL CHECKS GOOD.SDR AALA202004289001Outflow Valve · faultyAIRCRAFT NOT GROUNDED: AT LEVEL OFF AT FL370. 15 MIN INTO FLIGHT, THE AUTO FAIL LT ILLUMINATED AND THE ALTN LT DIDNT ILLUMINATE. CABIN WAS DESENDING AT 2000 / MIN AND PSID WAS 8.5 WHEN ALTN SELECTED THE ALTN LT NEVER ILLUMINATED AND PRESS WAS NOT UNDER CONTROLSDR AALA2020042749011Seat Track · corrodedAIRCRAFT IN BASE MAINTENANCE: CABIN SEAT TRACK # 2 HAS PITTING AT STATION 380, LBL 28. REPLACED SEAT TRACK PER AARD 51-00-05 & EA # 304925.SDR AALA2020042439007Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON CABIN FLOOR ZEE ANGLE AT BS 990 AND LBL 32. REPLACED ZEE ANGLE PER AARD 51-00-05-1.SDR AALA202004209014Fuel Line · crackedAIRCRAFT WAS GROUNDED, FERRY FLT TO LAX: REF FIM 28-21-00-810-815 FOR UNWANTED FUEL TRANSFER CTR TO 2 TANK. WITH RIGHT CENTER PUMP ON, FUEL LEAKS INTO RIGHT TANK THROUGH DISCHARGE CHECK VALVE OF RT FWD OR RT AFT BOOST PUMP HOUSING. FOUND CRACKED FUEL LINE, RESDR AALA202004179008Fuse · blownAIRCRAFT IN BASE VISIT: G1 GALLEY EMER EXIT SIGN INOPERATIVE. REPLACED FUSE IN EMERGENCY POWER SUPPLY, P/N: B215-06, IAW AMM 33-51-06-960-804.SDR AALA202004179007Fuel Line · crackedAIRCRAFT GROUNDED: DURING CRUISE, NORM FUEL PANEL CONFIG FOR BURNING CENTER TANK, RT MN TANK QTY IND UP STEADILY. AT 10 LBS PER MINUTE, SHOWED UNUSUAL VALUES, FIRST 8.8, 8.9, & 9.0. HIGHEST OBSERVED WAS 9.1. AT RUNUP, RT MAIN QTY, TOTAL FUEL CONSUMPEDSDR AALA202004169011Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED RIGHT HAND MAIN LANDING GEAR WHEEL WELL VAPOR BARRIER 22 INCHES FROM THE CENTER LINE AND 8 INCHES FROM THE BOTTOM. REPAIRED VAPOR BARRIER PER AARD 57-10-10-9.SDR AALA2020041659008Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED RIGHT HAND MAIN LANDING GEAR WHEEL WELL VAPOR BARRIER ORIGINATING AT A FASTENER LOCATION APPROXIMATELY 5.0 INCHES ABOVE THE BOTTOM OF THE VAPOR BARRIER AT RBL 50. REPAIRED VAPOR BARRIER PER AARD 57-10-10-9 AND SRM 57-10-1SDR AALA2020042439003Pressure Deck · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CENTER WING SECTION REAR SPAR VERTICAL PRESSURE DECK WEB AT BS 663 AND RBL 45.64. REPAIRED VERTICAL PRESSURE DECK WEB PER SRM 57-10-10-2R-3.SDR AALA2020042439010Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CARGO COMPARTMENT BAFFLE CLIP AT BS 400 AND S17R. REPLACED BAFFLE CLIP PER SRM 51-40-02.SDR AALA2020042439004Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CABIN FLOOR INTERCOSTAL CRACKED BETWEEN BS 277 AND BS 294.5 AT RBL 2. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA2020042319005Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CARGO COMPARTMENT BAFFLE CLIP AT BS 500G AND S26R. REPLACED BAFFLE CLIP PER SRM 51-40-02.SDR AALA2020042219012Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARMTENT SHIELD BETWEEN BS 500 AND BS 500A AT S25R. REPLACED SHIELD PER AARD 51-00-05-1.SDR AALA2020042219010Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500 AND BS BS 500I AT S25R. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5 AND AARD 51-00-05.SDR AALA2020041429003Pressure Web · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED RIGHT HAND MAIN LANDING GEAR WHEEL WELL VERTICAL PRESSURE WEB AT BS 663.75 BETWEEN RBL 31.83 AND RBL 40 AT WL 200. REPAIRED PRESSURE WEB PER SRM 57-10-10 REPAIR 3.SDR AALA2020041429002Pressure Web · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED LEFT HAND MAIN LANDING GEAR WHEEL WELL VERTICAL PRESSURE WEB AT BS 663.75 BETWEEN LBL 31.83 AND LBL 40 AT WL 200. REPAIRED PRESSURE WEB PER SRM 57-10-10 REPAIR 3 AND EA 304988SDR AALA2020041219001Switch · faultyAIRCRAFT WAS GROUNDED: TAKEOFF CONFIG LIGHT ILLUMINATED ON TAKEOFF ROLL APPROX. 60 KTS. REJECTED AND RETURNED TO GATE. (AS THE NOSE WHEEL WAS COMING OFF THE GROUND ON TAKE,OFF ROLL- TAKE OFF CONFIG LIGHT ILLUMINATED AND AURAL WARNING ACTIVATED FOR APPROXIMATELSDR AALA2020050109013Window Post · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FLIGHT DECK FIRST OFFICERS R1 WINDOW CUT OUT UPPER OUTBOARD C-D WINDOW POST AT BS 219 AND S10R. REPAIRED WINDOW POST PER EA 304420 AND EA 304691.SDR AALA2020042439006Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON CABIN FLOOR ZEE ANGLE BETWEEN BS 991 AND BS 104 AT RBL 32. REPLACED ZEE ANGLE PER AARD 51-00-05-1.SDR AALA2020042219004Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CARGO COMPARTMENT BAFFLE CLIP AT BS 500H AND S25L.REPLACED CLIP PER AARD 51-00-05-1.SDR AALA2020042219003Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CARGO COMPARTMENT BAFFLE CLIP AT BS 500G AND S25L. REPLACED BAFFLE CLIP PER AARD 51-00-05-1.SDR AALA2020042219002Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CARGO COMPARTMENT BAFFLE CLIP AT BS 400 AND S25L. REPLACED BAFFLE CLIP PER AARD 51-00-05-1.SDR AALA202004109005Filter · cloggedAIRCRAFT WAS GROUNDED: DIVERTED TO DFW ACCOUNT LEFT ENGINE FUEL FILTER BYPASS ILLUMINATED ON,CLIMBOUT. ALL ENGINE INDICATIONS NORMAL. LIGHT WENT,OFF/ON TWICE IN FLIGHT. REMOVED AND REPLACED #1 ENG FUEL FILTER PER 73-11-02, RUN AND LEAK CHECK ACCOMPLISHED AS RESDR AALA2020050429004Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL AT BS 500I AND S25R. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R.SDR AALA2020050429003Threshold · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT DOOR CUT OUT THRESHOLD PAN BETWEEN BS 790 AND BS 847 AT RBL 25. REPLACED THRESHOLD PAN PER AARD 51-00-05.SDR AALA2020042439008Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON R2 DOOR CUT OUT LOWER CREASE ANGLE BETWEEN BS 862 AND BS 1006 AT RBL 52. REPLACED CREASE ANGLE PER AARD 51-00-05-1.SDR AALA2020042439005Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON CABIN FLOOR ZEE ANGLE AT BS 990 BETWEEN RBL 34 AND RBL 47. REPLACED ZEE ANGLE PER AARD 51-00-05-1.SDR AALA2020042439002Support Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON CABIN FLOOR SUPPORT ANGLE AT BS 1015 AND LBL 34. REPLACED SUPPORT ANGLE PER AARD 51-00-05-1.SDR AALA2020042319009Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT SHIELD BETWEEN BS 767 AND BS 790 AT S25R. REPLACED SHIELD PER AARD 51-00-05-1.SDR AALA2020042219011Retainer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT FALSE WALL RETAINER AT BS 500I AND S25L. REPLACED WALL RETAINER PER SRM 51-40-02.SDR AALA2020042219008Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 727A AND BS 840 AT S25L. REPAIRED TRANSITION PANEL PER SRM 53-00-53-2R.SDR AALA2020042219007Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 727A AND BS 767 AT S25R. REPAIRED TRANSITION PANEL PER AARD 51-00-05-1 AND SRM SRM 53-00-53-2R.SDR AALA2020042219006Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CARGO COMPARTMENT BAFFLE CLIP AT BS 500H AND S25L.REPLACED BAFFLE CLIP PER AARD 51-00-05-1.SDR AALA2020042219001Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CABIN FLOOR INTERCOSTAL AT BS 957 AND LBL 50. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA2020041499021Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CABIN FLOOR "Z" ANGLE BETWEEN BS 992 AND BS 1016 AT RBL 32. REPLACED ANGLE PER AARD 51-00-05-1.SDR AALA2020041309004Light · inoperativeAIRCRAFT NOT GROUNDED - SEAT MOUNTED RED EMERGENCY LIGHT AT POSITION 16C INOPERATIVE. REMOVED AND REPLACED SEAT MOUNTED RED EMERGENCY LIGHT PER AMM 33-51-11, OPERATIONAL CHECKS GOOD.SDR AALA202004099018Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CABIN FLOOR SUPPORT AT BS 951 AND LBL 24. REPLACED FLOOR SUPPORT PER AARD 51-00-05-1.SDR AALA2020040989012Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CARGO COMPARTMENT BAFFLE CLIP AT BS 500H AND S25R. REPLACED CLIP PER SRM 51-40-02 AND AARD 53-00-01-6.SDR AALA2020040989011Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CARGO COMPARTMENT BAFFLE CLIP AT BS 500H AND S25R. REPLACED CLIP PER SRM 51-40-02 AND AARD 53-00-01-6.SDR AALA2020040879005Handle · out of adjustAIRCRAFT WAS GROUNDED: RETURNED TO LAS, AFTER T/O FAS HEARD LOUD POP AND VIBRATION AND WHISTLE FROM R-1 DOOR. DESCRIPTION FROM FAS MADE IT SOUND LIKE SLIDE MAY HAVE BLOWN. FOUND EXT HANDLES OUT AFTER LANDING.UPON ARRIVAL FOUND L-1 EXIT DOOR HANDLE ASKEW RESEQSDR AALA2020040879006Conduit · faultyAIRCRAFT WAS GROUNDED: ON TAXI CONTINUOUS FUEL FLOW OUT OF RT WING FUEL VENT. INCIDENT OCCURRED ON TAXIWAY SHORT OF RUNWAY. MAINTENANCE TOWED AIRCRAFT BACK TO GATE. REMOVED AND REPLACED AND OPS CHECKED FLOAT SWITCH CONDUIT ASSY PER AMM 28-21-00-700-801.SDR AALA202004079004Ballast · faultyAIRCRAFT GROUNDED - SMOKE ODOR IN CABIN PASSING 12000 FEET; IT WAS A BURNING ELECTRICAL / BURNED POPCORN SMELL. ODOR PREVALENT IN ROWS 10-14 WITH A SLIGHT HAZE PRESENT. ACCOMPLISHED MCM 05-96-70 TO TROUBLESHOOT ODOR. FOUND FAULTY BALLAST FOR CEILING LIGHT AT RSDR AALA202004069016Feeder Cable · burnedAIRCRAFT WAS GROUNDED: FLIGHT REPORTED STRONG ODOR IN CABIN. APU WAS RUNNING. SHUT DOWN APU. FOUND APU GENERATOR T1 FEEDER CABLE WIRE BURNT AT GENERATOR. REPLACED CABLE. RAN ENGINE. NO ODOR NOTED. AC OK FOR SERVICE. SUPPLEMENTAL ACTION SECT 4: INSPECTED FEEDSDR AALA202004069017Motor · malfunctionedAIRCRAFT WAS GROUNDED: A/T CLICKED OFF DURING TAKE OFF ROLL. WAS ONLY ENGEAGED FOR 5 SECONDS OR LESS. TRIED BOTH FLIGHT F/D AND BOTH A/PS WITHOUT SUCCESS. REPLACED AUTO THROTTLE SERVO MOTOR 1 AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 22-31-9SDR AALA202004069022Slide · low pressureAIRCRAFT NOT GROUNDED: FOUND L2 SLIDE PRESSURE LOW. REMOVED AND REPLACED AFT LEFT (L2) SLIDE ASSY IAW MCM 25-94-12.SDR AALA2020041399003Expansion Joint · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED EXPANSION JOINT AT BS 540 BETWEEN BL 0 AND RBL 20. REPLACED EXPANSION JOINT PER AARD 51-00-05-1.SDR AALA2020041399002Expansion Joint · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED EXPANSION JOINT AT BS 540 BETWEEN BL 0 AND LBL 20. REPLACED EXPANSION JOINT PER AARD 51-00-05-1.SDR AALA2020040989008Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CABIN FLOOR SUPPORT AT BS 540 BETWEEN BL 0 AND LBL 24. REPLACED FLOOR SUPPORT PER SRM 51-40-02.SDR AALA2020040989006Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CABIN FLOOR SUPPORT AT BS 540 BETWEEN BL 0 AND RBL 24. REPLACED FLOOR SUPPORT PER SRM 51-40-02.
Back to Boeing 737-823