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 AALA201910039006Seal · leakingAIRCRAFT WAS GROUNDED: REPORTS OF A LOUD SQUEAL AT LEFT AFT ENTRY DOOR. MAINTENANCE REMOVED LEFT AFT ENTRY DOOR SWEEPER SEAL IAW AMM 52-13-61, ACCOMPLISHED LEAK CHECK IAW AMM 52-09-00, NO LEAKS DETECTED.SDR AALA2019100759021Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CARGO COMPARTMENT BAFFLE BETWEEN BS 500B AND BS 500C AT LBL 24. REPLACED BAFFLE PER AARD 51-00-05-1.SDR AALA2019100759019Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT WET AREA FLOOR SUPPORT AT BS 951 BETWEEN LBL 18 AND LBL 23. REPLACED FLOOR SUPPORT PER SRM 51-40-02.SDR AALA2019100759017Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON INTERCOSTAL BETWEEN BS 947 AND BS 967 AT LBL 25. REPLACED INTERCOSTAL PER SRM 51-40-02.SDR AALA201910029002Light · brokenAIRCRAFT WAS NOT GROUNDED: SEAT 21D EMERGENCY LIGHT BROKEN. MAINTENANCE REPLACED EMERGENCY LIGHT PER AMM 33-51-11E.SDR AALA201910109014Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CARGO COMPARTMENT BAFFLE CLIP BETWEEN BS 500G AND BS 500H AT S25L. REPLACED CLIP PER AARD 51-00-05-1.SDR AALA201910089021Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CARGO COMPARTMENT BAFFLE CLIP BETWEEN BS 500I AND BS 500H AT RBL 24. REPLACED CLIP PER AARD 51-00-05-1.SDR AALA2019100759024Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CARGO COMPARTMENT BAFFLE CLIP BETWEEN BS 500F AND BS 500E AT S25L. REPLACED CLIP PER AARD 51-00-05.SDR AALA2019100759018Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FLOOR SUPPORT AT BS 951 BETWEEN LBL 26 AND LBL 49. REPLACED FLOOR SUPPORT PER SRM 51-40-02.SDR AALA201909309024Compressor · leakingAIRCRAFT WAS GROUNDED: PILOT REPORTS CABIN ODOR BEGAN AFTER TAKEOFF SEEMED TO DISSIPATE DURING CLIMB OUT AND AT CRUISE ODOR RETURNED PASSING THRU APPROXIMATELY 11000 FT, SEEMED STRONGER DESCRIBED AS DIRTY SOCK SOUR MILK SMELL. MAINTENANCE ACCOMPLISHED JOB CARDSDR AALA201910029028Pad · wornAIRCRAFT IN BASE MAINTENANCE: PREVIOUS STRAP REPAIR TO THE GROUND PNEUMATIC DOOR OUTBOARD LATCH PAD WORN AT BS 538 AND RBL 40.875. REPAIRED LATCH PAD PER SRM 57-10-13-2R-3 REPAIR 3.SDR AALA201909309013Terminal Block · burnedAIRCRAFT WAS GROUNDED: MAINTENANCE FOUND THE NOSE GEAR TAXI LIGHT TERMINAL BLOCK HAS BURNT PINS AT TB40. MAINTENANCE REPLACED TERMINAL BLOCK TB40 IAW SWPM 20-83-01. REWIRED IAW WDM 33-45-11 AND OPS CHECK NOSE TAXI LIGHT IAW AMM 33-45-01. OPS CHECK FOUND NORMALSDR AALA201909309019Drain Line · looseAIRCRAFT IN BASE VISIT: FO R2 HANDLE DIFFICULT TO OPEN AND CLOSE. WINDOW FUNCTIONS NORMALLY ONCE OPENED. MAINTENANCE REPORTS DRAIN TUBE AT FWD END OF R2 CUTOUT WAS LOOSE AND INTERFERED WITH WINDOW OPERATION. SECURED DRAIN TUBE AND RE-CHECKED WINDOW OPERATION ASDR AALA2019100759013Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CARGO COMPARTMENT BAFFLE CLIP AT BS 500F AND RBL 24. REPLACED CLIP PER AARD 51-00-05.SDR AALA2019100759012Baffle · crackedAIRCRAFT IN BASE MAINTENANCE, CRACKED FORWARD CARGO COMPARTMENT BAFFLE AT BS 500F AND RBL 24. REPLACED BAFFLE IAW 51-00-05-1.SDR AALA2019100759010Skin · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FUSELAGE SKIN AT BS 915 BETWEEN S21L AND S22L. REPAIRED SKIN PER EA 298639.SDR AALA2019100759009Skin · crackedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER LOWER SURFACE SKIN CRACKED AT STATION 111.10 AND RBL 38. REPAIRED SKIN PER SRM 55-10-01-2R.SDR AALA2019100759006Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED ANGLE AT BS 500I AND RBL 34. REPLACED THE ANGLE PER 51-00-05-1.SDR AALA2019100759003Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CARGO COMPARTMENT BAFFLE CLIP AT BS 500G AND RBL 25. REPLACED CLIP PER AARD 51-00-05-1.SDR AALA201910039049Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CABIN FLOOR SUPPORT CRACKED AT BS 540 AND RBL 2. REPLACED FLOOR SUPPORT IAW 51-00-05-1.SDR AALA201910039048Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CABIN FLOOR SUPPORT CRACKED AT BS 540 AND LBL 2. REPLACED FLOOR SUPPORT IAW 51-00-05-1.SDR AALA201909279006Door · out of adjustAIRCRAFT WAS GROUNDED: PILOT REPORTS LH AFT ENTRY DOOR HANDLE NOT STAYING DOWN IN LOCKED POSITION. MAINTENANCE ADJUSTED DOOR IAW AMM 52-13-00 & PERFORMED DOOR INDICATION CHECKS IAW AMM 52-71-11-820-801.SDR AALA201909279007Door · out of adjustAIRCRAFT WAS GROUNDED: PILOT REPORTS R1 ENTRY DOOR HANDLE NOT STAYING DOWN IN LOCKED POSITION. MAINTENANCE ADJUSTED DOOR IAW AMM 52-41-00 & PREFORMED DOOR INDICATION CHECKS IAW AMM 52-71-11-820-801.SDR AALA201909279008Door · out of adjustAIRCRAFT WAS GROUNDED: PILOT REPORTS R2 SRV DOOR HANDLE NOT STAYING DOWN IN LOCKED POSITION. MAINTENANCE ADJUSTED DOOR IAW AMM 52-13-00 & PERFORMED DOOR INDICATION CHECKS IAW AMM 52-71-11-820-801.SDR AALA2019100759014Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE, CORROSION ON INTERCOSTAL BETWEEN BS 947 AND BS 967 AT LBL 51. REPLACED INTERCOSTAL PER SRM 51-40-05.SDR AALA2019100759008Stringer Clip · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED STRINGER CLIP AT BS 500H AND S25L. REPLACED STRINGER CLIP PER AARD 51-00-05-01-6.SDR AALA2019100759007Stringer Clip · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED STRINGER CLIP AT BS 500I AND S25L. REPLACED STRINGER CLIP PER AARD 51-00-05-1.SDR AALA2019100759005Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CARGO COMPARTMENT BAFFLE AT BS 500G AND RBL 30. REPLACED BAFFLE PER EA 298578.SDR AALA201909269005Unknown · malfunctionedAIRCRAFT WAS GROUNDED: PILOT REPORTS AUTOTHROTTLES DISCONNECTED DURING TAKEOFF AND WOULD NOT REENGAGE DURING FLIGHT. MAINTENANCE ACCOMPLISHED A/T BITE AND INTERACTIVE TESTS IAW AMM 22-31-00. ALL PASSED, NO FAULTS NOTED. OK FOR SERVICE.SDR AALA2019100759004Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CARGO COMPARTMENT BAFFLE CLIP AT BS 500H AND LBL 25. REPLACED CLIP PER AARD 51-00-05-1.SDR AALA201909259011Rib · crackedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER RIB WEB STIFFENER CRACKED AT STATION 92.7. REPLACED RIB PER AARD 51-00-05-1.SDR AALA2019100759011Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE, CORROSION ON FLOOR SUPPORT AT BS 927 AND LBL 51. REPLACED FLOOR SUPPORT IAW SRM 53-70-51-2R-5.SDR AALA2019100292344Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED LEFT HAND HORIZONTAL STABILIZER RIB WEB ANGLE AT STATION 138.70. REPAIRED RIB WEB ANGLE PER SRM 55-10-09-2R-4.SDR AALA201909259021Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD WET AREA FLOOR INTERCOSTAL AT BS 335 AND LBL 46. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA201909249008Autothrottle Sys · malfunctionedAIRCRAFT NOT GROUNDED: AUTO THROTTLE UNCOMMANDED DISCONNECT WHILE IN CRUISE ON CAPTS SIDE. SWITCHED TO COPILOTS SIDE AUTOTHROTTLE SERVICEABLE. ***SUPPLEMENTAL INFORMATION SECTION 4: COULD NOT DUPLICATE GROUND. PERFORMED AUTOTHROTTLE BITE TEST PER FIM 22-31-00.SDR AALA201909249004Acm · seizedAIRCRAFT WAS GROUNDED: CREW REPORTED CABIN ODOR DURING FLIGHT, ELECTRICAL ARCING ODOR IN AFT GALLEY. BACK OF THROAT BURN. EYES WATERING. MAINTENANCE ACCOMPLISHED JOB CARD 05-96-70, REMOVED AND REPLACED THE LT ACM IAW AMM. OPS CHECK GOOD.SDR AALA201909249005Smoke Detector · false activationAIRCRAFT NOT GROUNDED: FWD LAV SMOKE DETECTOR ALERT, (FALSE). REMOVED AND REPLACED FWD LAVATORY SMOKE DETECTOR IAW AMM 26-14-01.SDR AALA201909249006Blower Motor · failedAIRCRAFT WAS GROUNDED: PILOT REPORTS OF FLUID/WATER WITH STRONG ODOR LEAKING FROM UNDER BOTH LAV DOORS. MAINTENANCE FOUND LAV BLOWER MOTOR C/B POPPED. REPLACED VACUUM BLOWER MOTOR IAW AMM 38-32-05. AND LAV TANK FLITERS IAW AMM 38-32-02. INSPECTED AFT LAVS, NO SDR AALA201909229006Beam · wornAIRCRAFT WAS GROUNDED: RIGHT HAND ECS BAY DOOR LANDING LOWER SUPPORT BEAM WORN THRU AT BS 545 AND RBL 40.875. REPAIRED SUPPORT BEAM PER SRM 57-10-13-2R-3.SDR AALA201910039047Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL SHIELD AT BS 488 AND RBL 24. REPLACED SHIELD PER AARD 51-00-05-1.SDR AALA201910029034Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT WET AREA FLOOR HALF MOON WEB AT BS 1018 AND RBL 32. REPAIRED WEB [ER EA 298611.SDR AALA201909259022Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT DOOR SILL WEB. REPAIRED DOOR SILL WEB PER SRM 51-10-02.SDR AALA201909259020Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORRWARD CARGO COMPARTMENT TRANSITION PANEL SIDE PLATE BETWEEN BS 400 AND BS 500I AT LBL 24. REPAIRED SIDE PLATE PER SRM 51-10-02.SDR AALA201909239019Impeller · defectiveAIRCRAFT WAS GROUNDED: FLIGHT AIR RETURNED TO MIA ON ACCOUNT OF POSSIBLE FUEL LEAK. EMERGENCY DECLARED. MAINTENANCE REMOVED AND REPLACED RH WING PROBES AND COMPENSATOR IAW AMM 28-41-21, ALSO WIRE HARNESS IAW AMM 28-41-44, NO LEAK FOUND. MAINTENANCE FOUND RT CTSDR AALA201909239038Deu · faultyAIRCRAFT NOT GROUNDED: PILOT REPORTS FOR APPROX 5 MINUTES IN FLIGHT, BOTH PILOT NDS AND LOWER DU WENT BLANK. NO PANEL SWITCHING CHANGED ANYTHING. COULD NOT DISPLAY HYD PRESSURES ON ANY DISPLAY. THERE WERE NO EEC LIGHTS. ON UPPER DU, ONLY N1 AND EGT WERE DISPLASDR AALA2019100229004Seat Track · damagedAIRCRAFT IN BASE MAINTENANCE: INBOARD SEAT TRACK HOLE FOR BREAK IS OVERSIZED AND OUT OF ROUND AT BS 537 AND RBL 24.82. REPAIRED SEAT TRACK PER EA 298469.SDR AALA2019100299003Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CARGO COMPARTMENT BAFFLE ATTACH ANGLE AT BS 500G AND LBL 25. REPLACED ATTACH ANGLE PER SRM 51-70-11.SDR AALA2019100219008Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CABIN FLOOR SUPPORT AT BS 540 AND RBL 2. REPLACED FLOOR SUPPORT PER SRM 51-10-02.SDR AALA2019100219007Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CABIN FLOOR SUPPORT AT BS 540 AND LBL 2. REPLACED FLOOR SUPPORT PER SRM 51-10-02.SDR AALA201909239028Indicator · unreliableAIRCRAFT WAS GROUNDED: PILOT REPORTS ON TAKEOFF DURING LDG GEAR RETRACTION BOTH ENG AND ELEC HYD SYS A LOW PRESSURE LTS ILLUMINATED WITH MASTER CAUTION FLT CONT & HYD ANNUNCIATED. MAINTENANCE REMOVED AND REPLACED A/B HYD SYSTEMS AIR PRESSURE GUAGE. REMOVED AND
Back to Boeing 737-823