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 AALA202103319013Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN BRAKE ANGLE AT STA 537 BETWEEN RBL 2 AND RBL 22, MEASURING L=1.0 IN, W=0.002 IN, D=0.032 IN. REPLACED BRAKE ANGLE WITH NEW IAW AARD 51-05-05.SDR AALA202103299044Wire · exposedAIRCRAFT WAS NOT GROUNDED: SEAT 32C ELECTRICAL WIRE EXPOSED. SECURED EMERGENCY LIGHT FIXTURE, OPS CHECK GOOD.SDR AALA202103319019Switch · dirtyAIRCRAFT IN BASE MAINTENANCE: RT FWD OVERWING EMERGENCY EXIT DOOR WARNING SWITCH INOPERATIVE. CLEANED WARNING SWITCH IAW B737NG AMM 20-00-02, OPS CHECK GOOD.SDR AALA202104079013Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK FOUND ON LEFT HORIZONTAL STABILIZER RIB STATION 92.70. CRACK 3 INCHES LONG AND 0.001 INCHES WIDE. REPLACED RIB AT STATION 92.70 PER SRM 51-00-05-1.SDR AALA202104069027Skin · crackedAIRCRAFT IN BASE MAINTENANCE: FOUND CRACK ON LOWER SKIN OF RIGHT STABILIZER AT STA 101.9 AND BL 101.12. INSTALLED DOUBLER REPAIR ON LOWER SKIN OF HORIZONTAL STABILIZER IAW SRM 51-10-01-2R.SDR AALA202103299046Floor Panel · crackedAIRCRAFT IN BASE MAINTENANCE: FORWARD PIT FLOOR PANEL 120DF IS CRACKED. FABRICATED AND INSTALLED NEW FLOOR PANEL IAW B737-NG AMM 51-21-41 AND 51-21-72.SDR AALA202103299041Girt Bar · bindingAIRCRAFT WAS NOT GROUNDED: R1 GIRT BAR JAMMED AND WON'T ARM. INSTALLED GIRT BAR CORRECTLY IAW AMM 25-66-01, OPS CHECK GOOD.SDR AALA202103299037Bracket · looseAIRCRAFT WAS NOT GROUNDED: FWD GALLEY DOOR GIRT BAR BRACKET IS LOOSE. REPLACED ESCAPE PACK SLIDE IAW AMM 25-66-01.SDR AALA202103299028Window · delaminatedAIRCRAFT WAS GROUNDED: R1 WINDOW DELAMINATED. REPLACED R1 WINDOW WITH SERVICEABLE UNIT IAW WORK CARD 56-94-04.SDR AALA202103299042Door · obstructedAIRCRAFT WAS NOT GROUNDED: LAVATORY DOOR E DIFFICULT TO OPEN AND CLOSE, BOTTOM DRAGS ON FLOOR. REMOVED OBSTRUCTION FROM LAVATORY DOOR E.SDR AALA202103299035Door · stuckAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR WILL NOT OPEN. INSPECTED AND FOUND LATCHING PIN AT LOWER HINGE POINT OF DOOR GOES IN BACK OF THE THRESHOLD NOT ALLOWING THE DOOR TO COME OUT. OPENED LEFT AFT LAV DOOR IAW AMM 25-40-00.SDR AALA202103299043Housing · brokenAIRCRAFT WAS NOT GROUNDED: CONTRACT CABIN CLEANERS REPORTS SEAT 12ABC EMERGENCY PATH LIGHT BROKEN OFF. REMOVED AND REPLACED SEAT 12ABC ESCAPE PATH LIGHT HOUSING ASSEMBLY PER ESO 61101 CMM 25-23-67.SDR AALA202103299036Lens · unsecureAIRCRAFT WAS NOT GROUNDED: 16C EMERGENCY LIGHT FLOOR PATH ON ISLE SIDE OF SEAT FALLS OFF. RE SECURED 16C ESCAPE PATH LIGHT LENS COVER.SDR AALA202104159025Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORRODED AREA FOUND ON WEB LOCATED BETWEEN STA 787 AND STA 847. REPLACED WEB LOCATED BETWEEN STA 787 AND STA 847 PER AARD 51-00-05-1.SDR AALA202103299051Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: BOTH FLASHLIGHTS AT JUMPSEAT 4L ARE NOT OPERATIONAL. REPLACED BATTERY IN FLASHLIGHT #1 (AALA202103299034) AND FLASHLIGHT #2 AT JUMPSEAT 4L, OPS CHECK GOOD.SDR AALA202103299034Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: BOTH FLASHLIGHTS AT JUMPSEAT 4L ARE NOT OPERATIONAL. REPLACED BATTERY IN FLASHLIGHT #1 AND FLASHLIGHT #2 (AALA202103299051) AT JUMPSEAT 4L, OPS CHECK GOOD.SDR AALA202103299031Slide · wornAIRCRAFT IN BASE MAINTENANCE: BLACK VINYL ON R1 DOOR EMERGENCY ESCAPE SLIDE GIRT FOUND WORN. REPLACED R1 DOOR ESCAPE SLIDE PACK IAW B737-NG AMM 25-66-01-000-802.SDR AALA202103299032Motor · inoperativeAIRCRAFT WAS GROUNDED: CLIMBING THROUGH 16000, STABILIZER OUT OF TRIM LIGHT ILLUMINATED. RAN QUICK REFERENCE HANDBOOK AND DID NOT FIX. MANUAL TRIM BINDING. DECLARED EMERGENCY AND LANDED IN CANCUN. REMOVED AND INSTALLED STABILIZER TRIM MOTOR IAW AMM 27-41-71-40SDR AALA202103299047Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN FLOOR PANEL SUPPORT IS CRACKED AT STA 540, LEFT BUTT LINE 1. REMOVED AND REPLACED PANEL BREAK PER B-737-NG SRM 51-40-02.SDR AALA202104159027Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: FOUND CORROSION ON LEFT TRANSITION PANEL AT STA 727D TO 847. REPLACED TRANSITION PANEL IAW AARD 51-00-05-1.SDR AALA202104159028Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: FOUND CORRODED TRANSITION PANEL AT STA 727H+10 TO STA 767 AND RBL 23. REPLACED TRANSITION PANEL REF AARD 51-00-05-1 AND BOEING DRAWING #146A7500 AND SRM 53-00-53-2R.SDR AALA202104159024Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FOUND ON TRANSITION PANEL SHIELD ASSEMBLY LOCATED BETWEEN STA 767 AND 787. INSTALLED NEW TRANSITION PANEL SHIELD ASSEMBLY PER AARD 51-00-05.SDR AALA202104089027Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT AFT BULKHEAD LOWER CENTER FLOOR ANGLE AT BS 500I BETWEEN LBL 24 AND RBL 24. REMOVED CORROSION AND FOUND TO BE WITHIN LIMITS PER SRM 51-10-02.SDR AALA202104079016Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: FORWARD CARGO RIGHT SHIELD CORRODED FROM STA 492 TO 500A. REPLACED SHIELD IAW AARD 51-00-05-1.SDR AALA202104079015Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: FORWARD CARGO RIGH TRANSITION PANEL CORRODED FROM STA 500A TO 500I. INSTALLED RIGHT TRANSITION PANEL IAW SRM 53-00-53-2R-5.SDR AALA202104079014Attach Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: FORWARD CARGO BULKHEAD ATTACH ANGLE CORRODED AT STA 500I. REPLACED ATTACH ANGLE IN THE FORWARD CARGO BULKHEAD.SDR AALA202104079012Support Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON G4 GALLEY SUPPORT Z ANGLE LOCATED AT STA 993 LBL 43. REPLACED ANGLE PER AARD 51-00-05-1.SDR AALA202104079011Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED INTERCOSTAL LOCATED FROM STA 259 TO 360, LBL 11. REPLACED INTERCOSTAL PER SRM 51-10-02.SDR AALA202104019024Bracket · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF GIRT BAR BRACKET AT STA 344, WL 208, AND LBL59, MEASURING L=2.0 IN, W=2.0 IN, D=0.022 IN. REPLACED BRACKET WITH NEW IAW SRM 51-10-02.SDR AALA202104019020Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN INTERCOSTAL AT STA 324 AND LBL 45.6, MEASURING L=0.75 IN, D=0.04 IN. REPLACED INTERCOSTAL WITH NEW IAW AARD 51-00-05-1.SDR AALA202104019021Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED INTERCOSTAL AT BS 320 RBL 32. REPLACED INTERCOSTAL PER SRM 51-20-01.SDR AALA202104019022Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: FOUND INTERCOSTAL BETWEEN STA 259 AND STA 360 CRACKED. INSTALLED NEW INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202104019023Bracket · corrodedAIRCRAFT IN BASE MAINTENANCE: FOUND CORROSION ON GIRT BAR BRACKET AT STA 312, WL 208 AND LBL55, MEASURING 2 INCHES BY 2 INCHES. REPLACED GIRT BAR BRACKET IAW SRM 51-10-02.SDR AALA202103299026Smoke Detector · false activationAIRCRAFT WAS NOT GROUNDED: SMOKE LIGHT WENT OFF TWO TIMES IN AIRCRAFT RIGHT REAR LAVATORY. PASSENGER DENIED THAT HE WAS SMOKING. PERFORMED LAVATORY SMOKE DETECTION-SMOKE TEST IAW AMM 26-14-00-730-801.SDR AALA202103279014Connector · looseAIRCRAFT IN BASE MAINTENANCE: RH OVERWING FWD EMERGENCY EXIT LOWER LIGHT FAILS TO ILLUMINATE. RESEATED CONNECTOR IAW AMM 33-51-06, OPS CHECK GOOD.SDR AALA202103269012Light · damagedAIRCRAFT WAS NOT GROUNDED: ESCAPE PATH LIGHT DAMAGED AT 8C. SECURED ESCAPE PATH LIGHT ASSEMBLY AT 8C, OPERATIONS CHECK NORMAL PER AMM 33-51-11.SDR AALA202104219016Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON CABIN K WEB LOCATED BETWEEN STA 986 AND 993, BETWEEN RBL 30 AND RBL 35. REPLACED WEB PER AARD 51-00-05-1.SDR AALA202104219015Support Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON G4 GALLEY AREA SUPPORT Z ANGLE LOCATED AT STA 993 BETWEEN RBL 32 AND RBL 47. REPLACED ANGLE PER AARD 51-00-05-1, AND DWG 147A5700.SDR AALA202104219014Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON CABIN FLOOR BEAM LOCATED AT STA 986.5 RBL 43. REPAIRED PER EA 326601 AND SRM 53-00-51-2R-1.SDR AALA202104169004Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORRODED CREASE ANGLE LOCATED BETWEEN STA 947 AND 995 AT RBL 55. REPLACED CREASE ANGLE PER SRM 51-40-02 AND EA 326881.SDR AALA202104169003Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORRODED FLOOR BEAM LOCATED AT STA 986.5 RBL 45. REPAIRED FLOOR BEAM PER SRM 53-70-51-2R AND EA 326630.SDR AALA202104159013Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF CABIN FLOOR SUPPORT INTERCOSTAL BETWEEN STA 947 AND STA 967 BETWEEN RBL 50 AND RBL 53, MEASURING L=1.0 IN, W=1.0 IN, D=0.04 IN. REPLACED INTERCOSTAL WITH NEW IAW AARD 51-00-05.SDR AALA202104159012Channel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF Z-CHANNEL BETWEEN STA 991 AND STA 993 AT RBL 32, MEASURING L=0.05 IN, W=1.0 IN, D=0.16 IN. REPLACED Z-CHANNEL WITH NEW IAW AARD 51-00-05-1.SDR AALA202104159011Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF FLOORBEAM AT STA 946.5 AND RBL 6, MEASURING L=0.75 IN, W=0.75 IN, D=0.066 IN. ACCOMPLISHED PERMANENT REINFORCING REPAIR WITH NESTED ANGLES IAW SRM 53-70-51-2R-5.SDR AALA202104159026Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: FOUND CORRODED FLOOR BEAM LOCATED AT STA 986.5. REPAIRED FLOOR BEAM WITH REINFORCEMENT PER SRM 53-00-51-2R AND EA 326599.SDR AALA202103279013Fuse · blownAIRCRAFT IN BASE MAINTENANCE: RH SLIDE EMERGENCY LIGHT INOPERATIVE. REPLACED FUSE AT POWER SUPPLY M1671 IAW AMM 33-51-00, OPS CHECK GOOD.SDR AALA202103279012Fuse · blownAIRCRAFT IN BASE MAINTENANCE: EMERGENCY PROXIMITY LIGHT INOPERATIVE AT SEATS 1-4AB. REPLACED FUSE IN POWER SUPPLY M2816 IAW AMM 33-51-00, OPS CHECK GOOD.SDR AALA202103259013Strap · brokenAIRCRAFT WAS NOT GROUNDED: LOWER EMERGENCY EXIT PANEL ON FLIGHT DECK DOOR HAS A BROKEN STRAP. REINSTALLED LOWER EMERGENCY EXIT PANEL FLIGHT DECK DOOR STRAP IAW IPC 52-51-51, OPS CK GOOD.SDR AALA202103259005Bolt · damagedAIRCRAFT WAS NOT GROUNDED: R2 WINDOW DIFFICULT TO CLOSE, EXCESSIVE NOISE THROUGHOUT FLIGHT; PRESSURIZED NORMALLY. REPLACED SPECIAL BOLT TO R1 WINDOW ROLLER BEARING WITH NEW IAW AMM 56-12-11, OPS CHECK GOOD.SDR AALA202103259014Girt Bar · out of positionAIRCRAFT WAS NOT GROUNDED: GIRT BAR JAMMED RIGHT FORWARD DOOR. UNABLE TO ARM. FOUND GIRT BAR STUCK BEHIND HOLDING CLIP. REMOVED GIRT BAR AND INSTALLED CORRECTLY. OK FOR SERVICE PER AMM 25-66-00.
Back to Boeing 737-823