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 AALA202412195160Sign · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT PLACARD IN THE AISLE ADJACENT TO EMERGENCY EXIT FELL TO THE FLOOR ON TAKEOFF ROLL. RESECURED EMERGENCY EXIT SIGN COVER. PER AMM 33-51-01.SDR AALA202412199009Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: COCKPIT DOOR IS VERY DIFFICULT TO OPEN FROM OUTSIDE EVEN WITH FLIGHT DECK DOOR UNLOCKED. LUBRICATED COCKPIT DOOR. PER FIM 52-50-00-810-802. COCKPIT DOOR OPERTIONAL CHECK GOOD.SDR AALA202412195835Light · inoperativeAIRCRAFT WAS NOT GROUNDED: ROW 28C EMERGENCY LIGHTING INOPERATIVE. THE EMERGENCY LIGHT ON THE ROW 28 WAS ADJUSTED AND PERFORMED OPERTIONAL TEST GOOD. PER AMM 33-50-00.SDR AALA202412199744Megaphone · inoperativeAIRCRAFT WAS NOT GROUNDED: AFTER MEGAPHONE FOUND INOPERATIVE DURING PREFLIGHT. REMOVED AND REPLACED AFT MEGAPHONE.SDR AALA202501273986Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL BETWEEN STA 947.5 AND STA 967 AT LBL 24. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202501224395Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER CHORD (T-CAP) AT STA 947.5, LBL 24. REPLACED CHORD PER SRM 53-70-51-2R-5 ALTERNATIVE 2.SDR AALA202501225927Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR SUPPORT INTERCOSTAL AT STA 951 AND RBL 49. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202412247972Structure · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT ZEE ASSEMBLY BETWEEN STA 727I PLUS 6 INCHES AND STA 747 AT S25R. REPLACED ZEE ASSEMBLY PER AARD 51-00-05-1.SDR AALA202412246951Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT SHIELD FROM STA 767 TO STA 787 AT S25R. REPLACED SHIELD PER AARD 51-00-05-1.SDR AALA202412198234Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: FOUND EMERGENCY FLASH LIGHT BELOW AFT LEFT FLIGHT ATTENDANT SEAT INOPERATIVE. REMOVE AND REPLACED EMERGENCY FLASHLIGHT ASSEMBLY BELOW AFT LEFT FLIGHT ATTADNENT SEAT. PER AMM 25-60-00, LIGHT CHECK GOOD.SDR AALA202412181208A/C Pack · contaminatedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: FUMES SMELLED THROUGHOUT AIRCRAFT; AIRCRAFT RETURN TO GATE SAFELY AT LGA. PERFORMED J/C 08L00021001. COULD NOT DUPLICATE FUEL ODOR THROUGHOUT A/C. PERFORMED REMOVAL OF OIL CONTAMINATION FROM THE AIR CONDSDR AALA202412185640Hinge · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR IS DIFFICULT TO OPEN AND CLOSE. LUBED DOOR HINGE. OPERTIONAL CHECK GOOD. PER CMM 25-40-64.SDR AALA202412189703Vapor Barrier · debondedAIRCRAFT IN BASE MAINTENANCE: UPON REMOVAL OF SHEAR FITTINGS ON UPPER CENTER WINGBOX BETWEEN BS 540 AND BS 550, HAS VAPOR BARRIER DISBONDED. APPLIED PRIMER AND VAPOR BARRIER ON UPPER CENTER WING BOX BETWEEN BS 540 AND BS 550, MTERIAL THICKNESS WITHIN LIMITS. PSDR AALA202501249357Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR INTERCOSTAL AT STA 959, LBL 50. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202501227423Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR BEAM UPPER CHORD AT STA 986.5, LBL 43. REPAIRED CHORD PER SRM 53-70-51-2R-6 ALTERNATIVE 4.SDR AALA202501224374Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN CRASE ANGLE AT STA 994, RBL 45. REPAIRED ANGLE PER EA 360706.SDR AALA202501223393Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER CHORD (T-CAP) AT STA 947, FROM LBL 49 TO RBL 53. REPAIRED CHORD PER SRM 53-70-51-2R-5.SDR AALA202501228190Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT STA 959 AT RBL 50. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202501221730Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER CHORD (T-CAP) AT STA 947, LBL 5. REPAIRED CHORD PER SRM 53-70-51-2R-5.SDR AALA202501096743Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR BEAM UPPER CHORD (T-CAP) AT STA 986.5, LBL 43. REPAIRED CHORD PER SRM 53-70-51-2R-6 ALTERNATIVE 4.SDR AALA202412247148Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR SUPPORT INTERCOSTAL LOCATED FROM STA 380 TO STA 400 AT LBL 12. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202412249042Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL L BRACKET LOCATED FROM STA 380 TO STA 400 AT BL0 REPLACED L BRACKET PER SRM 53-00-02 AND AARD 51-00-05-1.SDR AALA202412167517Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND LBL 40.87. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202412164674Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND LBL 32.40. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202412160355Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND LBL 15.04. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202412166132Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND LBL 6.14. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202412166393Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND RBL 6.14. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202412164157Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND RBL 15.04. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202412165382Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND RBL 32.40. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202412168031Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND RBL 40.87. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202412164961Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND RBL 54.60. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202412169226Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND LBL 54.60. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202412162453Door Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: LAVATORY D LATCH IS HARD TO OPEN/UNLOCK. LUBE LAV D DOOR ROLLER BEARING AS REQUIRED.SDR AALA202412167274Screw · unsecureAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR DIFFICULT TO OPEN AND CLOSE. FOUND FORWARD LAVATORY DOOR BOTTOM PLATE SCREW LOOSE, RESECURED SCREW AS REQUIRED. OPERTIONAL CHECK GOOD.SDR AALA202412165467Light · dislodgedAIRCRAFT WAS NOT GROUNDED: OVER HEAD EMERGENCY LIGHT IN FIRST CLASS DISLODGED. RESECURED OVERHEAD EMERGENCY LIGHT IN FIRST CLASS.SDR AALA202412165246Tube · missingAIRCRAFT WAS NOT GROUNDED: RED HEAT SHRINK ON GIRT BAR AT DOOR L2 IS MISSING. INSTALLED RED HEAT SHRINK ON GIRT BAR AT DOOR L2. PER AARD 25-66-00-4.SDR AALA202412162238Fitting · wornAIRCRAFT IN BASE MAINTENANCE: CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 54.60 WORN. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202412165700Fitting · wornAIRCRAFT IN BASE MAINTENANCE: CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 54.60 WORN. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202412163504Fitting · wornAIRCRAFT IN BASE MAINTENANCE: CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 40.87 WORN. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202412160221Fitting · wornAIRCRAFT IN BASE MAINTENANCE: CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 32.40 WORN. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202412161866Fitting · wornAIRCRAFT IN BASE MAINTENANCE: CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 15.04 WORN. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202412160216First Aid Kit · wornAIRCRAFT IN BASE MAINTENANCE: CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 6.14 WORN. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202412165376Fitting · wornAIRCRAFT IN BASE MAINTENANCE: CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 6.14 WORN. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202412167910Fitting · wornAIRCRAFT IN BASE MAINTENANCE: CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 32.40 WORN. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202412160940Fitting · wornAIRCRAFT IN BASE MAINTENANCE: CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 40.87 WORN. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202412165045Fitting · wornAIRCRAFT IN BASE MAINTENANCE: CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 15.04 WORN. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202412191594Oil Cooler · contaminatedAIRCRAFT WAS GROUNDED: STRONG SMELL OF FUMES FROM PREFLIGHT TO LANDING. DEFINITELY IN THE FLIGHT DECK AND FLIGHT ATTENDANTS ALSO REPORTED IN THE CABIN. DURING TROUBLESHOOTING FOUND OVERALL APU AREA CONTAMINATED WITH OIL AND SOOT STAINED PRIMARILY IN THE OIL COSDR AALA202412163837Battery · faultedAIRCRAFT WAS NOT GROUNDED: NEED NEW FWD FA FLASHLIGHT. STATUS LIGHT FLASHING RED. REPLACED 1L DOOR JUMPSEAT FLASHLIGHT BATTERY.SDR AALA202412165687Door · stuckAIRCRAFT WAS NOT GROUNDED: LAV D BIFOLD DOOR VERY DIFFICULT TO OPEN. READJUSTED LAV D FOLDING DOOR.SDR AALA202412164242Sign · missingAIRCRAFT WAS NOT GROUNDED: ROW 17 A EMERGENCY ASSY EXIT LIGHT IDENTIFIER MISSING. INSTALLED NEW EXIT LIGHT ASSY.
Back to Boeing 737-823