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 AALA202306076978Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: LEFT HAND OVERWING EMERGENCY LIGHT FORWARD SIDE INOPERATIVE. REMOVED AND REPLACED LAMP AT LEFT HAND OVERWING FORWARD SIDE EMERGENCY LIGHT.SDR AALA202306077301Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: R1 DOOR OUTER EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED EMERGENCY LAMP AT R1 DOOR OUTER SIDE.SDR AALA202306079117Unknown · wornAIRCRAFT IN BASE MAINTENANCE: WING CENTER SECTION LOWER SUPPORT BEAM LOWER CHORD WORN AT THE ESC DOOR (192DR OUTBOARD FORWARD LATCH AREA AT BS 545 AND RBL 40.875 AT WL 155. REPAIRED SUPPORT BEAM LOWER CHORD PER SRM 57-10-13-2R REPAIR 3.SDR AALA202306074817Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 101.90, 27 INCHES FORWARD OF AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202306164124Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER ATTACH ANGLE LOCATED AT BS 663.5 AND RBL 2. REPAIRED ANGLE PER SRM 57-10-10-2R-5SDR AALA202306121011Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER RIB ON THIRD STIFFENER FROM FRONT, LOCATED AT STABILIZER STA 147.90. REPAIRED RIB PER SRM 55-10-09-2R.SDR AALA202306075643Threshold · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR DIFFICULT TO OPEN. AJUSTED THRESHOLD PLATE PER CMM 25-44-49 .SDR AALA202306072851Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 138.70, 9 INCHES AFT OF FORWARD SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202306076777Channel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT Z CHANNEL LOCATED FROM BS 867 TO BS 947.5 AT S26R. REMOVED, FABRICATED, AND INSTALLED ZEE CHANNEL PER SRM 51-40-02-0G.SDR AALA202306071585Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FLOOR SUPPORT LOCATED AT BS 270 AND RBL 42. REPLACED FLOOR SUPPORT PER SRM 51-40-02-0G.SDR AALA202306071587Support Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON INTERCOSTAL SUPPORT FITTING LOCATED AT BS 270 AND RBL 42. REMOVED, FABRICATED, INSTALLED SUPPORT FITTING PER SRM 51-40-02-0G.SDR AALA202306075464Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOORBEAM LOCATED AT BS 986.5 AT LBL 64. REMOVED, FABRICATED, AND INSTALLED FLOORBEAM SECTION PER SRM 53-00-51-2R-1 PROCEDURE 1 REPAIR 1.SDR AALA202306077281Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN WALL SUPPORT LOCATED AT BS 992 FROM LBL 42 TO LBL 32. REPLACED SUPPORT PER SRM 51-40-02.SDR AALA202306070968Bulkhead · canningAIRCRAFT IN BASE MAINTENANCE: OIL CAN CONDITION IN AFT PRESSURE BULKHEAD LOCATED AT BS 1016 FROM S3R TO S5R. REPAIRED BULKHEAD PER SRM 53-80-08-2R-10.SDR AALA202306077678Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FLOOR SUPPORT LOCATED AT BS 540 AT BL 0. REMOVED AND REPLACED FLOOR SUPPORT PER SRM 51-40-02-0G.SDR AALA202306062234Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT RIGHT LOWER FLIGHT ATTENDANT FLASHLIGHT INOPERATIVE. REMOVED AND REPLACED AFT RIGHT LOWER FLIGHT ATTENDANT FLASHLIGHT.SDR AALA202306163492Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FLOOR BEAM AT GIRT BAR MOUNT HOLE LOCATED AT BS 986.5 AND LBL 43. REPAIRED FLOOR BEAM PER SRM 53-70-51-2R-6 TABLE 203 ALTERNATE REPAIR 3 AND EA 345405 .SDR AALA202306168061Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FLOOR BEAM GIRT BAR MOUNT HOLE LOCATED AT BS 986.5 AND RBL 43. REPAIRED FLOOR BEAM PER SRM 53-70-51-2R-6 TABLE 203 ALTERNATE REPAIR 3 AND E345405A .SDR AALA202306168635Unknown · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FLOOR BEAM UPPER CHORD UNDER AFT GALLEY TIE DOWN LOCATED AT BS 947 FROM LBL 50 TO LBL 52. REPAIRED FLOOR BEAM CHORD PER SRM 53-70-51-2R-5.SDR AALA202306074705Track · damagedAIRCRAFT WAS NOT GROUNDED: LAVATORY D DOOR HARD TO OPEN OR CLOSE. **SUPPLEMENTAL REPORT FOR AALA202306059468: REPLACED LAVATORY D UPPER DOOR TRIM (AALA202306059468) AND UPPER DOOR TRACK (AALA202306074705) PER CMM 25-40-64.** (CLOSED)SDR AALA202306079468Trim Panel · damagedAIRCRAFT WAS NOT GROUNDED: LAVATORY D DOOR HARD TO OPEN OR CLOSE. **SUPPLEMENTAL REPORT FOR AALA202306059468: REPLACED LAVATORY D UPPER DOOR TRIM (AALA202306059468) AND UPPER DOOR TRACK (AALA202306074705) PER CMM 25-40-64.** (CLOSED)SDR AALA202306077669Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 101.90, 18 INCHES FORWARD OF AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202306073461Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 175.50, 9 INCHES FORWARD OF AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202306062185Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOORBEAM LOCATED AT BS 947.5 AND RBL 25. REPAIRED FLOORBEAM PER EA 344623 AND SRM 53-70-51-2R-5.SDR AALA202306069076Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOORBEAM LOCATED AT BS 947.5 AND LBL 26. REPAIRED FLOORBEAM PER EA 344924 AND SRM 53-70-51-2R-5.SDR AALA202306051655Slide · out of positionAIRCRAFT WAS GROUNDED: SLIDE PACK 1L OUT OF POSITION. REINSTALLED 1L SLIIDE PACK.SDR AALA202306059468Unknown · unknownAIRCRAFT WAS NOT GROUNDED: LAVATORY D DOOR HARD TO OPEN OR CLOSE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED** (OPEN)SDR AALA202306050048Slide · malfunctionedAIRCRAFT WAS GROUNDED: EMERGENCY SLIDE PARTIALLY DEPLOYED ON ARRIVAL. REPLACED L1 DOOR ESCAPE SLIDE.SDR AALA202306055887Light · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT OVER THE STORAGE BIN AT SEAT 19C IS UNSECURED. REMOVED AND REPLACED EMERGENCY LIGHT AT SEAT 19C PER AMM 33-51-03.SDR AALA202306054756Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN CABIN WALL SUPPORT LOCATED FROM BS 986.5 TO BS 992 AT LBL 32. REPLACED WALL SUPPORT PER SRM 51-40-02-0G.SDR AALA202306056967Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN CABIN WALL SUPPORT LOCATED AT BS 992 FROM RBL 45 TO RBL 32. REPLACED WALL SUPPORT PER SRM 51-40-02-0G.SDR AALA202306051290Shear Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON SHEAR WEB LOCATED FROM BS 986.5 TO BS 990 AT LBL 32. REMOVED, FABRICATED, AND INSTALLED SHEAR WEB PER SRM 51-40-02-0G.SDR AALA202306059174Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN INTERCOSTAL LOCATED AT BS 1016 AND LBL 45. REMOVED, FABRICATED, AND INSTALLED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202306051538Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN INTERCOSTAL LOCATED AT BS 1030 AND LBL 26. REMOVED, FABRICATED, AND INSTALLED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202306054900Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR BEAM LOCATED AT BS 986.5 AND RBL 45. REMOVED, FABRICATED, AND INSTALLED FLOOR BEAM SECTION PER SRM 53-70-51-2R-4 REPAIR 4.SDR AALA202306211772Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FORWARD SHIELD LOCATED FROM BS 767 TO BS 793 AT S25R. REPLACED SHIELD PER AARD 51-00-05-1 AND DWG 146A8127.SDR AALA202306196134Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 500H TO BS 500I AT LBL 28. REPAIRED TRANSITION PANEL PER SRM 53-00-2R-6.SDR AALA202306189195Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 727J TO BS 767, AT S25L. REPAIRED TRANSITION PANEL PER SRM 53-00-53-2R.SDR AALA202306161417Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT SHIELD LOCATED FROM BS 767 TO BS 793 AT S25R. REPLACED TRANSITION SHIELD PER AARD 51-00-05-1.SDR AALA202306064949Starter · seizedAIRCRAFT WAS GROUNDED: AFTER PUSHBACK, ENGINE #1 START, N2 AT ZERO. START ABORTED. ON SECOND START ATTEMPT, ABORTED START AGAIN, ENGINE FIRE INDICATION. BOTH FIRE BOTTLES DISCHARGED. MAINTENANCE FOUND #1 ENGINE STARTER SEIZED CAUSING AN OVERHEAT AND FIRE INDICSDR AALA202306053377Screw · looseAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR DIFFICULT TO OPEN OR CLOSE. FOUND SEVERAL DOOR HINGE SCREWS LOOSE. TIGHTENED SCREWS PER AARD 25-40-10-10. LAVATORY DOOR OPENS AND CLOSES NORMALLY.SDR AALA202308213333Smoke Detector · false activationAIRCRAFT WAS NOT GROUNDED: DURING DESCENT SMOKE DETECTOR IN 1ST CLASS LAVATORY ACTIVATED; HOWEVER, NO SMOKE OR FIRE WAS PRESENT. SMOKE DETECTOR WAS RESET. **SUPPLEMENTAL REPORT FOR AALA202306053333: REPLACED LAVATORY SMOKE DETECTOR PER AMM 26-14-01-000-801. ACSDR AALA202306214452Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT DOOR THRESHOLD WEB LOCATED AT BS 440 AND WL 30. REPLACED THRESHOLD WEB PER AARD 51-00-05-1 AND DWG 143A8126.SDR AALA202306205620Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED FROM BS 500A TO BS 500G AT S25R. REPLACED TRANSITION PANEL PER SRM 51-40-02 AND SRM 53-00-53.SDR AALA202306196742Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 500G TO BS 500H AT LBL 28. REPAIRED TRANSITION PANEL PER SRM 53-00-2R-6.SDR AALA202306183857Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED FROM BS 400 TO BS 420 AT RBL 25. REPLACED TRANSITION PANEL PER DWG 143A7501, AARD 51-00-05-1, AND SRM 51-40-02.SDR AALA202306182961Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 500A TO BS 500F AT S26L. REPLACED TRANSITION PANEL PER DWG 143A7500, AARD 51-00-05-1, AND SRM 51-40-02.SDR AALA202306167018Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND TRANSITION SHIELD LOCATED FROM BS 420 TO BS 440 AT RBL 25. REPLACED TRANSITION SHIELD PER DWG 143A8126, AARD 51-00-05-1, AND SRM 51-40-02.SDR AALA202306160350Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND TRANSITION SHIELD LOCATED FROM BS 500 TO BS 500A AT RBL 25. REPLACED TRANSITION PANEL PER DWG 143A0080, AND AARD 51-00-05-1.SDR AALA202306161167Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED AT BS 500C PLUS 12 INCHES AND RBL 28. REPAIRED TRANSITION PANEL PER SRM 53-00-53-2R-6 AND SRM 51-40-02.
Back to Boeing 737-823