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 AALA202109017486Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION MEASURING L=1.00 IN, W=1.25 IN, D=0.030 IN, ON FORWARD CARGO AREA RIGHT HAND SHIELD LOCATED FROM STA 492 TO STA 500A AT RBL 60. REPAIRED SHIELD PANEL PER SRM 51-10-02-OG.SDR AALA202108209648Skin · crackedAIRCRAFT WAS GROUNDED: RIGHT HORIZONTAL STABILIZER LOWER SKIN CRACKED AT STA 101.9 10.5 X 19.5. REPAIRED SKIN WITH FILLER AND DOUBLER PER SRM 55-10-01-2R.SDR AALA202108207886Retainer · missingAIRCRAFT WAS NOT GROUNDED: GIRT BAR PLASTIC WHITE RETAINING RING MISSING FROM LEFT AFT ENTRY DOOR. REMOVED AND REPLACED GIRT BAR AFT LIGHT DOOR AMM 25-66-01.SDR AALA202109144482Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION MEASURING L=1.00 IN, W=1.00 IN, D=0.005 IN, ON FLOOR WEB LOCATED AT STA 995 AND LBL 34. REPAIRED PER EA 330079.SDR AALA202109146685Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION MEASURING L=0.125 IN, W=0.125 IN, D=0.03 IN, AROUND FASTENER HOLE ON FLOOR BOARD SUPPORT LOCATED AT STA 995 AND LBL 34. REPLACED SUPPORT PER SRM 51-40-02.SDR AALA202109084575Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF LH TRANSITION PANEL IN FWD CARGO COMPARTMENT BETWEEN STA 506 AND STA 500I AT LBL 27, MEASURING L=3.0 IN, W=3.0 IN, D=0.015 IN. REPLACED TRANSITION PANEL WITH NEW IAW AARD 51-00-05-01, DRAWING 143A7500, AND SRM 53-00-5SDR AALA202109014277Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION MEASURING L=0.09 IN, W=0.075 IN, D=0.029 IN, ON FLOOR BEAM LOCATED AT STA 986.5 AND RBL 29 TO 34. REPAIRED PER EA 330093.SDR AALA202109014768Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION MEASURING L=1.50 IN, W=1.00 IN, D=0.040 IN, ON AFT CARGO AREA LEFT HAND TRANSITION PANEL LOCATED FROM STA 727E TO 727F AT S26L. REPLACED PANEL PER SRM 51-40-02.SDR AALA202108278913Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIB OF LH HORIZONTAL STABILIZER NEAR 3RD STIFFENER AT STA 166.30, MEASURING L=1.0 IN. ACCOMPLISHED PERMANENT REINFORCING REPAIR WITH NESTED ANGLES IAW SRM 55-10-09-2R-4.SDR AALA202108240015Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIB OF LH HORIZONTAL STABILIZER NEAR 3RD STIFFENER AT STA 166.30, MEASURING L=1.0 IN. ACCOMPLISHED PERMANENT REINFORCING REPAIR WITH NESTED ANGLES IAW SRM 55-10-09-2R.SDR AALA202108207016Stiffener · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN VERTICAL STIFFENER OF LH HORIZONTAL STABILIZER RIB AT STA 101.9, 18.0 IN AFT OF FRONT SPAR, MEASURING L=0.5 IN, W=0.003 IN, D=0.05 IN. ACCOMPLISHED PERMANENT REINFORCING DOUBLER REPAIR IAW SRM 55-10-09-2R-4.SDR AALA202108192270Hinge · dirtyAIRCRAFT WAS NOT GROUNDED: FIRST CLASS LAVATORY DOOR HARD TO OPEN. LUBRICATED FIRST CLASS LAVATORY DOOR HINGES CHECKS OK NO DEFECT NOTEDSDR AALA202108186120Bearing · missingAIRCRAFT WAS NOT GROUNDED: FIRST OFFICER'S SLIDE WINDOW MISSING BOTTOM FORWARD BEARING. INSTALLED BEARING PER AMM 56-12-00SDR AALA202108192531Wheel · vibrationAIRCRAFT WAS GROUNDED: SIGNIFICANT NOSE WHEEL SHIMMY FELT DURING TAKE OFF ROLL ABOVE 120K. AIR INTERRUPTED TO IAD. FLIGHT DID NOT DECLARE EMERGENCY AND WAS NOT OVERWEIGHT FOR LANDING. T/S IAW FIM 32-51-00-810-804. NO STRUCTURAL DAMAGE NOTED. PERFORMED PRECAUTISDR AALA202108194224Wheel · vibrationAIRCRAFT WAS GROUNDED: SIGNIFICANT NOSE WHEEL SHIMMY FELT DURING TAKE OFF ROLL ABOVE 120K. AIR INTERRUPTED TO IAD. FLIGHT DID NOT DECLARE EMERGENCY AND WAS NOT OVERWEIGHT FOR LANDING. T/S IAW FIM 32-51-00-810-804. NO STRUCTURAL DAMAGE NOTED. PERFORMED PRECAUTISDR AALA202108196969Wheel · vibrationAIRCRAFT WAS GROUNDED: SIGNIFICANT NOSE WHEEL SHIMMY FELT DURING TAKE OFF ROLL ABOVE 120K. AIR INTERRUPTED TO IAD. FLIGHT DID NOT DECLARE EMERGENCY AND WAS NOT OVERWEIGHT FOR LANDING. T/S IAW FIM 32-51-00-810-804. NO STRUCTURAL DAMAGE NOTED. PERFORMED PRECAUTISDR AALA202108195642Hinge · dirtyAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR DIFFICULT TO OPEN / CLOSE. DISCOVERED DEBRIS ON FLOOR AT LOWER DOOR PATH. DOOR HINGE STIFF AND SQUEAKING. CLEANED FLOOR AT BOTTOM OF DOOR. LUBRICATED DOOR HINGE FROM TOP TO BOTTOM.SDR AALA202108193025Latch · stickingAIRCRAFT WAS NOT GROUNDED: BOTH SLIDE LOCKS ON AFT LAVATORY DOORS DIFFICULT TO OPERATE. APPLIED LUBE TO RIGHT AFT LAVATORY DOOR LATCH PER AMM 12-20-00.SDR AALA202108184940Cover · detachedAIRCRAFT WAS NOT GROUNDED: SEAT 11ABC SEAT MOUNTED ESCAPE PATH LIGHT COVER WILL NOT STAY ATTACHED. SECURED EMERGENCY LIGHT COVER PER AMM 33-51-11.SDR AALA202108306730Control Unit · faultyAIRCRAFT WAS GROUNDED: SPEEDBRAKE ARMED LIGHT ILLUMINATED, BUT DOES NOT AUTO DEPLOY. **SUPPLEMENTAL REPORT: REPLACED ANTISKID AUTOBRAKE CONTROL UNIT IAW AMM 32-42-21, OPS CHECK GOOD.** (OPEN)SDR AALA202108200865Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LOWER SKIN OF RH HORIZONTAL STABILIZER AT STA 101.9, 37 IN AFT OF FWD SPAR, MEASURING L=1.125 IN, W=0.002 IN. ACCOMPLISHED PERMANENT REINFORCING DOUBLER REPAIR IAW SRM 55-10-01-2R.SDR AALA202108204377Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LOWER SKIN OF RH HORIZONTAL STABILIZER AT STA 129.50, 18 IN AFT OF FRONT SPAR, MEASURING L=1.125 IN, W=0.002 IN. ACCOMPLISHED PERMANENT REINFORCING DOUBLER REPAIR IAW SRM 55-10-01-2R-11.SDR AALA202108208865Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LOWER SKIN OF RH HORIZONTAL STABILIZER AT STA 175.5, 27 IN AFT OF FRONT SPAR, MEASURING L=0.75 IN, W=0.002 IN. ACCOMPLISHED PERMANENT REINFORCING DOUBLER REPAIR IAW SRM 55-10-01-2R.SDR AALA202108206730Speed Brake · faultedAIRCRAFT WAS NOT GROUNDED: SPEEDBRAKE ARMED LIGHT ILLUMINATED, BUT DOES NOT AUTO DEPLOY. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202108201976Skin · crackedAIRCRAFT IN BASE MAINTENANCE: LEFT HORIZONTAL STABILIZER LOWER SKIN CRACKED AT STA 147.90 APPROXIMATELY 32 INCHES AFT OF FORWARD SPAR. DAMAGED REMOVED, FILLER FABRICATED AND EXTERNAL DOUBLER INSTALLED PER SRM 55-10-01-2R-11.SDR AALA202108177477Light · detachedAIRCRAFT WAS NOT GROUNDED: EXIT LIGHT HANGING FROM BENEATH SEAT 26C. SECURED LIGHT PER AMM 33-51-14.SDR AALA202108178844Wire · exposedAIRCRAFT WAS GROUNDED: SEAT TRIM AT 22C IS DETACHED EXPOSING WIRING. SECURED SEAT TRIM. EMERGENCY LIGHTS TESTED NORMAL PER AMM 33-51-00.SDR AALA202108273643Keelbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CLIP ON KEEL BEAM LOWER LOWER SURFACE AT STA 549 AND LBL5. REPLACED CLIP WITH NEW IAW SRM 51-40-02.SDR AALA202108273018Keelbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CLIP ON KEEL BEAM LOWER LOWER SURFACE AT STA 549 AND RBL5. REPLACED CLIP WITH NEW IAW SRM 51-40-02.SDR AALA202108192108Window · crackedAIRCRAFT WAS GROUNDED: L1 WINDOW CRACKED IN NUMEROUS LOCATIONS IMMEDIATELY AFTER L1 OVERHEAT LIGHT ILLUMINATION. REPLACED L1 WINDOW WITH SERVICEABLE UNIT IAW WORKCARD 08C21156006.SDR AALA202108172711Pin · bindingAIRCRAFT WAS GROUNDED: FORWARD ENTRY DOOR IS VERY DIFFICULT TO OPEN. REPLACED DOOR GUIDE PIN PER AMM 52-11-21SDR AALA202108176954Light · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT ASSEMBLY FOR LOWER AISLE PATH DETACHED IN ROW 17ABC. SECURED LIGHT ASSEMBLY AS REQUIRED.SDR AALA202108175220Light · not seatedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT SIGN NEXT TO SEAT 17A IS BLINKING ON AND OFF CONTINUOUSLY. RESEATED LIGHT ASSEMBLY PER AMM 33-21-01.SDR AALA202108174945Wire · brokenAIRCRAFT WAS GROUNDED: EMERGENCY LIGHT AT SEAT 10C WIRE BROKEN. REPAIRED WIRE PER BOEING STANDARD WIRING PRACTICES MANUAL 20-30-12.SDR AALA202108167489Life Raft · low pressureAIRCRAFT WAS NOT GROUNDED: FIRST CLASS AFT CENTERLINE CEILING LIFE RAFT PRESSURE BELOW PS CHECK LIMITS. REPLACED LIFE RAFT WITH SERVICEABLE UNIT IAW AMM 25-64-00.SDR AALA202108168585Cover · detachedAIRCRAFT WAS NOT GROUNDED: EXIT SIGN COVER DETACHED AT SEAT 16A. REATTACHED SIGN COVER IAW AMM 33-51-01, OPS CHECK GOOD.SDR AALA202108167174Shroud · damagedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT SHROUD DAMAGED AT SEAT 25C. SECURED LIGHT SHROUD, OPS CHECK GOOD.SDR AALA202108188141Antenna · faultyAIRCRAFT WAS GROUNDED: LOSS OF AUTOPILOT, FLIGHT DECLARED EMERGENCY AND RETURNED TO FIELD. REPLACED #1 LOW RANGE RADIO ALTIMETER ANTENNA IAW AMM 34-33-00, OPS CHECK GOOD.SDR AALA202108186605Sensor · inoperativeAIRCRAFT WAS GROUNDED: LEADING EDGE SLAT INDICATION FAULT, FLIGHT DECLARED EMERGENCY AND DIVERTED TO SJU. REPLACED #4 SLAT RETRACT SENSOR WITH SERVICEABLE UNIT IAW AMM 27-88-11, OPS CHECK GOOD.SDR AALA202108180750Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: LEFT TRANSITION PANEL FROM STA 490-500C HAS AREAS OF CORROSION. REMOVED LEFT TRANSITION PANEL FROM 490 TO 500I PER 51-40-02.SDR AALA202108187125Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FOUND ON LEFT TRANSITION PANEL LOCATED BETWEEN STA 460 - 500, STR 25L. SPLICED IN NEW SECTION OF LEFT TRANSITION PANEL PER SRM 51-40-02-0G-0.SDR AALA202108180834Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION MEASURING L=1.175 IN, W=1.20 IN, D=0.035 IN, ON LEFT HAND TRANSITION PANEL. PANEL LOCATED BETWEEN STA 500C TO STA 500F AT LBL 25. REPLACED PANEL PER SRM 51-40-02.SDR AALA202108178591Clamp · out of adjustAIRCRAFT WAS NOT GROUNDED: LEFT AFT ENTRY DOOR GIRT BAR CLAMPS ON BOTTOM ARE TOO TIGHT AND DIFFICULT TO REMOVE GIRT BAR IN ORDER TO ARM DOOR. ADJUSTED CLIPS PER AMM 25-66-01.SDR AALA202108176726Clamp · out of adjustAIRCRAFT WAS NOT GROUNDED: RIGHT AFT ENTRY DOOR GIRT BAR CLAMPS ON BOTTOM ARE TOO TIGHT AND DIFFICULT TO REMOVE GIRT BAR IN ORDER TO ARM DOOR. ADJUSTED CLIPS PER AMM 25-66-01.SDR AALA202108169946Housing · brokenAIRCRAFT WAS GROUNDED: FOUND FLOOR LIGHT HOUSING PANEL AT 9ABC BROKEN. REPLACED HOUSING PER CMM 25-23-67.SDR AALA202108162880Lens · detachedAIRCRAFT WAS NOT GROUNDED: LENS FELL OFF OF EXIT IDENTIFIER AT GALLEY COMPARTMENT 571. REPLACED LIGHT PER AMM 33-51-01.SDR AALA202108165931Housing · looseAIRCRAFT WAS GROUNDED: ON PREFLIGHT, FLIGHT ATTENDANT FOUND FLOOR LIGHT AT 16C HANGING LOOSE. REPLACED HOUSING PER CMM 25-23-67.SDR AALA202108161758Door · out of adjustAIRCRAFT WAS NOT GROUNDED: CANNOT OPEN G2 GALLEY SIDEWALL EMERGENCY EQUIPMENT COMPARTMENT. ADJUSTED DOOR AS REQUIRED.SDR AALA202108165562Light · detachedAIRCRAFT WAS NOT GROUNDED: ROW 33ABC EXIT ROW EMERGENCY LIGHT IS DETACHED. SECURED LIGHT PER AMM 33-31-11.SDR AALA202108179539Sensor · faultyAIRCRAFT WAS NOT GROUNDED: ON TAKE OFF ROLL AFT MAIN CABIN ENTRANCE ILLUMINATED. LATER LIGHT EXTINGUISHED APPROXIMATELY 2000 MEAN SEA LEVEL FLIGHT ATTENDANT CHECKED HANDLE DOWN. REMOVED AND REPLACED L4 DOOR SENSOR PER AMM 52-71-11.
Back to Boeing 737-823