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 AALA202303148917Unknown · unknownAIRCRAFT IN BASE MAINTENANCE: LEFT MAIN LANDING GEAR PICKLE FORK FRAME FITTING CRACK FOUND FROM FASTENER TO END OF FITTING. DIMENSIONS FORWARDED TO ENGINEERING. **SUPPLEMENTAL REPORT REQUIRED** (OPEN)SDR AALA202303132159Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND ENVIRONMENTAL CONTROL SYSTEM BAY VAPOR BARRIER ATTACH ANGLE LOCATED AT BS 663 AND LBL 5. REPLACED ANGLE PER SRM 57-10-10-2R-5.SDR AALA202303136735Hinge · stickingAIRCRAFT WAS NOT GROUNDED: LAVATORY E DOOR IS DIFFICULT TO OPEN AND CLOSE. LUBRICATED DOOR HINGE AND HANDLE.SDR AALA202303133844Hinge · stickingAIRCRAFT WAS NOT GROUNDED: LAVATORY D AFT LEFT DOOR VERY DIFFICULT TO OPEN AND CLOSE. CLEANED AND LUBRICATED DOOR HINGE. DOOR OPERATES NORMAL.SDR AALA202303131714Unknown · looseAIRCRAFT WAS NOT GROUNDED: 1L ENTRY DOOR GIRT BAR ATTACH CLIP IS LOOSE ON THE RIGHT SIDE. ADJUSTED L1 DOOR GIRT BAR RETAINER CLIP PER AMM 25-66-00.SDR AALA202303224189Intercostal · out of toleranceAIRCRAFT IN BASE MAINTENANCE: DEFORMED HOLE IN UPPER FLANGE OF INTERCOSTAL LOCATED AT 760 AND S25R. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202303212345Stiffener · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER STIFFENER LOCATED AT STABILIZER STA 92.70. REPLACED STIFFENER PER SRM 51-40-02-0G.SDR AALA202303140681Support Angle · crackedAIRCRAFT IN BASE MAINTENANCE: SUPPORT ANGLE CRACKED 2 INCHES OUTBOARD OF KEEL BEAM RIGHT SIDE STATION 663.5. REMOVED AND REPLACED CRACKED SUPPORT ANGLE.SDR AALA202303104114Flashlight · no testAIRCRAFT IN BASE MAINTENANCE: OUTBOARD FLASHLIGHT RIGHT AFT ATTENDANT STATION WILL NOT TEST. INSTALLED NEW FLASHLIGHT.SDR AALA202303106593Flashlight · no testAIRCRAFT IN BASE MAINTENANCE: OUTBOARD FLASHLIGHT LEFT AFT FIRST CLASS STATION WILL NOT TEST. INSTALLED NEW FLASHLIGHT.SDR AALA202303107040Flashlight · no testAIRCRAFT IN BASE MAINTENANCE: FORWARD FLIGHT ATTENDANT STATION FLASHLIGHT #1 WILL NOT TEST. REPLACED FLASHLIGHT PER AMM 25-64-00.SDR AALA202303109418Flashlight · no testAIRCRAFT IN BASE MAINTENANCE: FORWARD FLIGHT ATTENDANT STATION FLASHLIGHT #2 WILL NOT TEST. REPLACED FLASHLIGHT PER AMM 25-64-00.SDR AALA202303143801Baffle · deformedAIRCRAFT IN BASE MAINTENANCE: BAFFLE HAS ENLARGED HOLE LOCATED BETWEEN STA 500F AND 500H AND STR 24R. REMOVED AND REPLACED BAFFLE PER SRM.SDR AALA202303105354Window · unknownAIRCRAFT WAS GROUNDED: LEFT SIDE FLIGHT DECK SIDE WINDSHIELD CAUTION LIGHT ILLUMINATED IN CRUISE. ON DESCENT GREEN ON LIGHT FLASHES ON AND OFF. REMOVED AND REPLACED LEFT SIDE COCKPIT WINDOW NUMBER 2.SDR AALA202303102591Battery Pack · dischargedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING POWER SUPPLY M01671 BATTERY PACK IS DISCHARGED. REPLACED BATTERY PACK PER AMM 33-51-06. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202303100695Battery Pack · dischargedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING POWER SUPPLY M01676 BATTERY PACK IS DISCHARGED. REPLACED BATTERY PACK PER AMM 33-51-06. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202303109710Battery Pack · dischargedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING POWER SUPPLY M01670 BATTERY PACK IS DISCHARGED. REPLACED BATTERY PACK PER AMM 33-51-06. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202303102037Battery Pack · dischargedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING POWER SUPPLY M02816 BATTERY PACK IS DISCHARGED. REPLACED BATTERY PACK PER AMM 33-51-06. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202303101216Battery Pack · dischargedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING POWER SUPPLY M01675 BATTERY PACK IS DISCHARGED. REPLACED BATTERY PACK PER AMM 33-51-06. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202303107628Battery Pack · dischargedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING POWER SUPPLY M01673 BATTERY PACK IS DISCHARGED. REPLACED BATTERY PACK PER AMM 33-51-06. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202303101274Battery Pack · dischargedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING POWER SUPPLY M01672 BATTERY PACK IS DISCHARGED. REPLACED BATTERY PACK PER AMM 33-51-06. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202303101632Battery Pack · dischargedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING POWER SUPPLY M02335 BATTERY PACK IS DISCHARGED. REPLACED BATTERY PACK PER AMM 33-51-06. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202303101499Battery Pack · dischargedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING POWER SUPPLY M01695 BATTERY PACK IS DISCHARGED. REPLACED BATTERY PACK PER AMM 33-51-06. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202303103200Battery Pack · dischargedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING POWER SUPPLY M01694 BATTERY PACK IS DISCHARGED. REPLACED BATTERY PACK PER AMM 33-51-06. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202303099849Handle · out of adjustAIRCRAFT WAS NOT GROUNDED: AFT RIGHT LAVATORY DOOR HARD TO OPEN / CLOSE. ADJUSTED DOOR HANDLE AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202303090425Hinge Fitting · wornAIRCRAFT IN BASE MAINTENANCE: LEFT ELEVATOR NUMBER 4 HINGE FITTING HAS VERTICAL PLAY BUSHING HOLE NOT ROUND. LOCATED AT ELEVATOR STA 121.590 AND WATER LINE 246.1. REMOVED AND REPLACED NUMBER 4 HINGE FITTING.SDR AALA202303080316Slide · tornAIRCRAFT WAS GROUNDED: R1 SERVICE DOOR ESCAPE SLIDE GIRT TORN APPROXIMATELY 1 INCH LONG ON FORWARD. SIDE JUST BELOW GIRT BAR. INSTALLED NEW SLIDE ONTO R1 DOORSDR AALA202303086022None · looseAIRCRAFT WAS NOT GROUNDED: 1L CABIN DOOR GIRT BAR HOLDER CLIP LOOSE. ADJUSTED 1L CABIN DOOR GIRT BAR HOLDER CLIP.SDR AALA202303082430None · looseAIRCRAFT WAS NOT GROUNDED: R1 DOOR GIRT ON RIGHT SIDE IS LOOSE. ADJUSTED GIRT BAR CLIPS PER AMM 25-66-01.SDR AALA202303215282Transition Panel · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN AFT CARGO COMPARTMENT FLOOR STRUCTURE LEFT HAND TRANSITION PANEL LOCATED AT BS 727 + 10 INCHES AND LBL 20. REPLACED TRANSITION PANEL PER SRM 51-40-02-0G.SDR AALA202303141566Support · corrodedAIRCRAFT IN BASE MAINTENANCE: LAVATORY FLOOR SUPPORT CORRODED LOCATED AT STA 950. REMOVED AND REPLACED OUTBOARD LAVATORY SUPPORT.SDR AALA202303144973Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT LAVATORY FLOOR SUPPORT LOCATED AT BS 950. REPLACED FLOOR SUPPORT PER SRM 51-40-05.SDR AALA202303087654Pitot Head · faultyAIRCRAFT WAS GROUNDED: ON CLIMBOUT AT 12000 MSL, IAS DISAGREE FLAG SHOWED, ALSO ALTITUDE DISAGREE FLAGGED WITH ALTITUDE DIFFERENCE OF 400-500FT. FLIGHT DIVERTED TO SLC LANDING SAFELY. MAINTENANCE ACCOMPLISHED FIM TASK 31-62-00-810-876, FAULT ISOLATION FOR AIRSSDR AALA202303086372Pitot Head · faultyAIRCRAFT WAS GROUNDED: ON CLIMBOUT AT 12000 MSL, IAS DISAGREE FLAG SHOWED, ALSO ALTITUDE DISAGREE FLAGGED WITH ALTITUDE DIFFERENCE OF 400-500FT. FLIGHT DIVERTED TO SLC LANDING SAFELY. MAINTENANCE ACCOMPLISHED FIM TASK 31-62-00-810-876, FAULT ISOLATION FOR AIRSSDR AALA202303078113Sliding Window · delaminatedAIRCRAFT WAS GROUNDED: FLIGHT DECK COPILOT SLIDING WINDOW DELAMINATION. REPLACED WINDOW PER JOB CARD 08L21056002. ACCOMPLISHED SATISFACTORY CHECKS.SDR AALA202303212064Life Raft · low pressureAIRCRAFT IN BASE MAINTENANCE: LOW PRESSURE CEILING PANEL LIFE RAFT LOCATION BETWEEN ROW 21 TO ROW 23 AT PASSENGER CABIN. REPLACED CEILING PANEL LIFE RAFT.SDR AALA202303108146Frame · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN LANDING GEAR WHEEL WELL AFT FAIRING SUPPORT FRAME ASSEMBLY LOCATED AT BS 727 + 2 INCHES AND FROM BL 0 TO LBL 17. REPLACED FRAME ASSEMBLY PER SRM 51-40-02-0G.SDR AALA202303086201None · out of adjustAIRCRAFT WAS NOT GROUNDED: R1 DOOR GIRT BAR CLIPS ARE TOO TIGHT. ADJUSTED GIRT BAR CLIPS AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202303074396Sensor · noneAIRCRAFT WAS GROUNDED: UPON GEAR RETRACTION ON TAKE OFF GREEN NOSE GEAR REMAINS ILLUMINATED WITH RED NOSE GEAR INDIATION NORMAL FOR LANDING WITH GEAR HANDLE DOWN. FOUND S845 BAD REMOVED AND REPLACED S845 NOSE GEAR SENSOR.SDR AALA202303067521Door · stickingAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAV DOOR EXTREMELY DIFFICULT TO OPEN AND CLOSE. ADJUSTED AFT LEFT LAVATORY DOOR TRIM PER AMM 25-40-00.SDR AALA202303060397Window · scratchedAIRCRAFT IN BASE MAINTENANCE: CAPTAINÏ¿½S #3 WINDOW SCRATCHED AND DELAMINATED. REPLACED WINDOW PER AMM 56-11-21.SDR AALA202303065891Window · scratchedAIRCRAFT IN BASE MAINTENANCE: FIRST OFFICERÏ¿½S #3 WINDOW SCRATCHED AND DELAMINATED. REPLACED WINDOW PER AMM 56-11-21.SDR AALA202303060015Girt Bar · out of adjustAIRCRAFT WAS NOT GROUNDED: DOOR L1 GIRT BAR DIFFICULT TO ARM WITHOUT ADJUSTING SLIDE SKIRT. ADJUSTED AND LUBRICATED L1 DOOR GIRT BAR PER AMM 25-66-00.SDR AALA202303141659Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT TRANSITIONAL PANEL LOCATED AT STA 727H+12 TO 747. AND STR 25R. REMOVED AND REPLACED RIGHT TRANSITIONAL PANEL.SDR AALA202303072826None · inoperativeAIRCRAFT WAS GROUNDED: AT 1500 AGL FIRST OFFICER AIRSPEED DROPPED TO 80 KNOTS AND STICK SHAKER ACTUATED CAPTAIN AIRSPEED AND STANDBY AIRSPEED WHERE NORMAL. REMOVED AND REPLACED RIGHT PITOT AIR DATA MODULE.SDR AALA202303072258Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR LATCH GETS STUCK IN LOCKED POSITION INTERMITTENTLY. **SUPPLEMENTAL REPORT FOR AALA202303062258: ADJUSTED LAVATORY DOOR PER CMM 25-40-64. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.** (CLOSED)SDR AALA202303075816Intercostal · bentAIRCRAFT IN BASE MAINTENANCE: FORWARD CARGO COMPARTMENT FLOOR STRUCTURE INTERCOSTAL LOCATED FROM BS 500G TO BS 500H AT S26R IS BENT. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202303079784Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT FLOOR STRUCTURE INTERCOSTAL LOCATED FROM BS 500G TO BS 500H AT S26L. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202303073739Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR STRUCTURE RIGHT HAND TRANSITION PANEL LOCATED BETWEEN BS 727 AND BS 727C AT S25R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202303077758Rail · out of toleranceAIRCRAFT IN BASE MAINTENANCE: AFT CARGO COMPARTMENT CARGO SUPPORT RAIL LOCATED AT BS 790.5 AND RBL 7.5 HAS ELONGATED FASTENER HOLE. REPAIRED SUPPORT RAIL PER EA 342420.
Back to Boeing 737-823