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 AALA202108178711Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FLOOR BEAM LOCATED AT STA 986 AND RBL 43.5, MEASURING L=1.00 IN, W=1.00 IN, D=0.095 IN. REPAIRED PER SRM 53-00-51-2R-1 AND EA 329502.SDR AALA202108170739Pressure Deck · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING VERTICAL PRESSURE DECK WEB LOCATED AT STA 663.75 BETWEEN LBL 31.83 AND LBL 40. REPAIRED PER SRM 57-10-10-2R-3 ALT 1.SDR AALA202108164646Floorboard · looseAIRCRAFT WAS GROUNDED: LOOSE FLOORBOARD IN CENTER AISLE BETWEEN ROWS 2 AND 3. **SUPPLEMENTAL REPORT FOR AALA202107304646: FLOOR BOARD IN CENTER AISLE BETWEEN ROWS 2 AND 3 REMOVED AND REPLACED PER AMM 53-21-00.** (CLOSED)SDR AALA202108129659Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON TRANSITION PANEL LOCATED BETWEEN STA 767 AND STA 787 AT RBL 25. REPLACED TRANSITION PANEL PER SRM 51-40-02.SDR AALA202108128405Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON TRANSITION PANEL LOCATED BETWEEN STA 727G AND STA 767 AT RBL 25. REPAIRED PER SRM 53-60-01-2 DWG 146A7502 AND SRM 51-40-02 AND AARD 51-00-05.SDR AALA202108120092Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION IN AFT OUTBOARD GIRT BAR FASTENER HOLE ON FLOOR BEAM LOCATED AT STA 986.5 AT LBL 48. REPAIRED PER EA 329506 AND SRM 53-70-51-2R-6.SDR AALA202107304646Floorboard · looseAIRCRAFT WAS GROUNDED: LOOSE FLOORBOARD IN CENTER AISLE BETWEEN ROWS 2 AND 3. **SUPPLEMENTAL REPORT REQUIRED** (OPEN)SDR AALA202108121931Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT HAND TRANSITION PANEL LOCATED BETWEEN STA 500 AND STA 500I AT S23L, LBL 35. REPAIRED PANEL PER SRM 53-00-53-2R-5 AND SRM 51-40-02.SDR AALA202108103811Smoke Detector · false activationAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY SMOKE DETECTION WARNING ACTIVATED MOMENTARILY AFTER PASSENGER EXITED. NO ABNORMAL ODOR OR SMOKE OBSERVED. REPLACED LH AFT LAVATORY SMOKE DETECTOR WITH SERVICEABLE UNIT IAW AMM 26-14-01-000-802, OPS CHECK GOOD.** (CSDR AALA202107280620Girt Bar · looseAIRCRAFT WAS NOT GROUNDED: 1L DOOR BRACKETS THAT HOLD GIRT BAR WHEN NOT ARMED, RIGHT SIDE LOOSE. ADJUSTED AND SECURED L1 DOOR GIRT BAR BRACKET, OPERATIONS CHECK GOOD PER AMM 25-66-01.SDR AALA202107273336Light · brokenAIRCRAFT WAS NOT GROUNDED: SEAT 16C EMERGENCY ROW LIGHT BROKEN. INSTALLED EMERGENCY LIGHT IAW AMM 33-50-00.SDR AALA202107273811Smoke Detector · false activationAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY SMOKE DETECTION WARNING ACTIVATED MOMENTARILY AFTER PASSENGER EXITED. NO ABNORMAL ODOR OR SMOKE OBSERVED. (OPEN)SDR AALA202107270772Retainer · looseAIRCRAFT WAS NOT GROUNDED: LEFT REAR ENTRY DOOR GIRT BAR IS LOOSE IN ITS BRACKET. SECURED GIRT BAR RETAINER PER AMM 25-66-01.SDR AALA202107278179Slide · unsecureAIRCRAFT WAS GROUNDED: DOOR 2R SLIDE BUSTLE DOES NOT STAY SECURED TO DOOR. REPLACED SLIDE PER JOB CARD 08L22125001.SDR AALA202107275659Shear Pin · damagedAIRCRAFT WAS GROUNDED: L1 DOOR GUST LOCK DAMAGED. REPLACED SHEAR PIN ON GUIDE ARM PER AMM 52-22-21.SDR AALA202108097518Girt Bar · corrodedAIRCRAFT IN BASE MAINTENANCE: 1R DOOR SLIDE GIRT BAR HAS PITTING. REPLACED R1 DOOR SLIDE GIRT BAR WITH NEW IAW B737NG AMM 25-66-01-000-804, OPS CHECK GOOD.SDR AALA202108098238Girt Bar · frayedAIRCRAFT IN BASE MAINTENANCE: 2L DOOR SLIDE FORWARD GIRT IS FRAYING. REPLACED 2L DOOR SLIDE PACK WITH SERVICEABLE UNIT IAW B737NG AMM 25-66-01-000-801, OPS CHECK GOOD.SDR AALA202108062669Retainer · looseAIRCRAFT IN BASE MAINTENANCE: 1R DOOR SLIDE FWD GIRT BAR RETAINER CLIP IS LOOSE. REPLACED RETAINER CLIP WITH NEW IAW WORKCARD 08C20025031, OPS CHECK GOOD.SDR AALA202107282390Angle · crackedAIRCRAFT IN BASE MAINTENANCE: FORWARD RIGHT HAND CARGO AREA CRACKED BAFFLE CLIP LOCATED AT STA 500G AT S27R. REPLACED BAFFLE CLIP PER SRM 53-30-53-01 AARD 51-40-05.SDR AALA202107289501Angle · crackedAIRCRAFT IN BASE MAINTENANCE: FORWARD LEFT HAND CARGO AREA CRACKED BAFFLE CLIP LOCATED BETWEEN STA 500G AND 500H AT S27L. REPLACED BAFFLE CLIP PER AARD-51-00-05-1.SDR AALA202107266678Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR IS DIFFICULT TO OPEN AND CLOSE. ADJUSTED DOOR.SDR AALA202107263698Cover · dislodgedAIRCRAFT WAS NOT GROUNDED: SEAT 16C EMERGENCY EXIT LIGHT COVER DETACHED. RESECURED PER AMM 33-51-11.SDR AALA202107280893Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: BAFFLE CLIP CRACKED AT STR 27L AND 500G. REMOVED AND REPLACED BAFFLE CLIP REF BOEING DRAWING #143A7505-SHEET 108-110, SRM 53-30-53-01, AND AARD 51-40-05.SDR AALA202107284997Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: BAFFLE CLIP CRACKED AT STA 500H AND STR 27R. REMOVED AND REPLACED BAFFLE CLIP REF DRAWING #143A7505-SHEET 108-110, SRM 53-30-53-01 AND AARD 51-40-05.SDR AALA202107285173Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK FOUND ON BAFFLE CLIP LOCATED AT STA 500F, STR 27 R. REMOVED AND REPLACED BAFFLE CLIP PER BOEING DRAWING 143A7505.SDR AALA202107283325Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: FOUND CRACK ON BAFFLE CLIP LOCATED AT STA 500H AND STR 27L. REMOVED AND REPLACED BAFFLE CLIP PER BOEING DRAWING 142A7505/AA.SDR AALA202107280062Door · stickingAIRCRAFT WAS GROUNDED: DURING DOOR INSPECTION OF L1 FORWARD ENTRY DOOR INSIDE HANDLE WHEN OPENING CREATES A LOUD THUD SOUND AND POP. INSIDE AND OUTSIDE HANDLES DOES NOT OPERATE SMOOTHLY. REPAIRED L1 DOOR PER AMM 52-11-00 OPERATIONS CHECK GOOD.SDR AALA202107271207Window · scratchedAIRCRAFT WAS GROUNDED: L1 WINDOW SCRATCHED. REPLACED L1 WINDOW IAW WORKCARD 08L21056003.SDR AALA202107276249Girt Bar · looseAIRCRAFT WAS NOT GROUNDED: CABIN SERVICE DOOR GIRT BAR RH BRACKET VERY LOOSE, DETACHED ON LANDING. ADJUSTED R1 DOOR GIRT BAR IAW AMM 25-61-00, OPS CHECK GOOD.SDR AALA202107273757Guide · lack of lubeAIRCRAFT WAS NOT GROUNDED: R1 DOOR STICKING. LUBED ROLLER BEARING GUIDES IAW AMM 52-11-00, OPS CHECK GOOD.SDR AALA202107270979Lamp · inoperativeAIRCRAFT IN BASE MAINTENANCE: EMERGENCY EXIT SIGN ABOVE R2 DOOR HAS THREE LAMPS INOPERATIVE. REPLACED THREE LAMPS (SEE ALSO AALA202107270166, AALA202107279978) IAW AMM 33-51-01, OPS CHECK GOOD.SDR AALA202107270166Lamp · inoperativeAIRCRAFT IN BASE MAINTENANCE: EMERGENCY EXIT SIGN ABOVE R2 DOOR HAS THREE LAMPS INOPERATIVE. REPLACED THREE LAMPS (SEE ALSO AALA202107260979, AALA202107279978) IAW AMM 33-51-01, OPS CHECK GOOD.SDR AALA202107279978Lamp · inoperativeAIRCRAFT IN BASE MAINTENANCE: EMERGENCY EXIT SIGN ABOVE R2 DOOR HAS THREE LAMPS INOPERATIVE. REPLACED THREE LAMPS (SEE ALSO AALA202107260979, AALA202107270166) IAW AMM 33-51-01, OPS CHECK GOOD.SDR AALA202107276663Lamp · inoperativeAIRCRAFT IN BASE MAINTENANCE: L1 DOOR EMERGENCY EXIT SIGN HAS ONE LAMP INOPERATIVE. REPLACED LAMP IAW AMM 33-51-00, OPS CHECK GOOD.SDR AALA202107272337Cover · brokenAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT COVER BROKEN AT SEAT 9ABC. REPLACED SHROUD COVER PER CMM 25-23-67.SDR AALA202107261954Light · inoperativeAIRCRAFT IN BASE MAINTENANCE: ABOVE L1 DOOR 1 EMERGENCY EXIT ILLUMINATION LIGHT LAMP INOPERATIVE. REMOVED AND REPLACED L1 DOOR EMERGENCY EXIT LIGHT IAW AMM 33-51-01.SDR AALA202107265475Bulb · inoperativeAIRCRAFT IN BASE MAINTENANCE: EMERGENCY EXIT SIGN ABOVE L2 DOOR HAS 1 LAMP INOPERATIVE. REMOVED AND REPLACED EMERGENCY EXIT LIGHT BULBS ABOVE L2 DOOR IAW AMM 33-51-01.SDR AALA202107268261Light · detachedAIRCRAFT WAS NOT GROUNDED: AISLE EMERGENCY LIGHTING FIXTURE AT SEAT 27C IS DETACHED AND HANGING. RE-ATTACHED EMERGENCY LIGHT FIXTURE AT SEAT 27C IAW AMM 25-20-00,SDR AALA202107266615Bulb · inoperativeAIRCRAFT IN BASE MAINTENANCE: AIRCRAFT EMERGENCY EXIT SIGN AT 17ABC HAS 1 LAMP INOPERATIVE. REMOVED AND REPLACED EMERGENCY EXIT SIGN LIGHT BULB AT 17 ABC PER AMM 33-51-01.SDR AALA202107263132Girt Bar · stuckAIRCRAFT WAS NOT GROUNDED: 1R GIRT BAR DOES NOT SEAT PROPERLY IN 1R DOOR, NEEDS TO BE SERVICED FOR REPAIR. RE POSITIONED STUCK SLEEVE ON GIRT BAR 1R DOOR.SDR AALA202107262540Cover · missingAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTED 2R DOOR EMERGENCY EXIT LIGHT MISSING. REINSTALLED LIGHT COVER CHECKS GOOD.SDR AALA202107267857Bulb · inoperativeAIRCRAFT IN BASE MAINTENANCE: EMERGENCY EXIT SIGN AT SEAT 16ABC HAS 1 LAMP INOPERATIVE. REPLACED BULB PER AMM 33-51-01.SDR AALA202107262132Light · inoperativeAIRCRAFT IN BASE MAINTENANCE: EMERGENCY EXIT SIGN AT SEAT 16DEFC HAS 1 LAMP INOPERATIVE. REPLACED LIGHT PER AMM 33-51-01.SDR AALA202108100337Stiffener · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN VERTICAL STIFFENERS OF RH HORIZONTAL STABILIZER RIB AT RH HSTAB STA 92.7 AND 12" AFT, MEASURING L=1.25 IN, W=0.25 IN. ACCOMPLISHED PERMANENT REINFORCING DOUBLER REPAIR IAW SRM 55-10-09-R2-4.SDR AALA202107266979Retainer · looseAIRCRAFT WAS NOT GROUNDED: AFT GIRT BAR CLIP ON FWD SERVICE DOOR LOOSE. ADJUSTED GIRT BAR CLIP AS REQUIRED, OPS CHECK GOOD.SDR AALA202107260487Shroud · looseAIRCRAFT WAS NOT GROUNDED: EMERGENCY AISLE LIGHT IS HANGING BY ITS WIRES AT SEAT 20C. REMOVED AND REPLACED SHROUD IAW CMM 25-23-67.SDR AALA202107276237Seat Track · wornAIRCRAFT IN BASE MAINTENANCE: LEFT HAND OUTBOARD SEAT TRACK AT STA 500L + 15 AND LBL 45 WORN. REPLACED SEAT TRACK PER AARD 51-00-05 AND EA 329363.SDR AALA202107264283Lock · stickingAIRCRAFT WAS NOT GROUNDED: LH AFT LAVATORY DOOR LATCH STICKING. ADJUSTED DOOR LOCK IAW AMM 25-40-14, OPS CHECK GOOD.SDR AALA202107263374Shroud · looseAIRCRAFT WAS NOT GROUNDED: EMERGENCY AISLE LIGHT IS HANGING BY ITS WIRES AT SEAT 15C. REMOVED AND REPLACED SHROUD IAW CMM 25-23-67SDR AALA202107237634Shroud · damagedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT HOUSING DAMAGED AT 21C. INSTALLED NEW EMERGENCY EXIT LIGHT SHROUD AT ROW 21C.
Back to Boeing 737-823