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 AALA202310023798Shear Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 40.87. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202310025659Shear Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 54.60. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202310025290Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: LIGHT BULB INOPERATIVE IN EMERGENCY EXIT LIGHTS ANNUNCIATOR. RELAMPED PER AMM 33-18-00.SDR AALA202310027032Slide · looseAIRCRAFT WAS NOT GROUNDED: R1 DOOR SLIDE PACK CAME LOOSE WHEN DOOR OPENED FOR CATERING. REINSTALLED R1 DOOR SLIDE PACK ASSEMBLY. PER GPM 18:01-15 AND AMM 25-66-01.SDR AALA202310061564Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL LOCATED FROM BS 727D TO BS 727C, RBL 25. REPLACED TRANSITION PANEL PER SRM 51-10-02.SDR AALA202310069847Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSISITON PANEL LOCATED AT BS 767, LBL 32. REPLACED TRANSITION PANEL PER AARD 51-00-05.SDR AALA202310054162Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER ATTACH ANGLE LOCATED AB BS 663.5, LEFT HAND SIDE 2 INCHES OUTBOARD OF KEEL BEAM. REPAIRED ANGLE PER 57-10-10-2R-5.SDR AALA202310050114Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED / MIS-DRILLED PASSENGER CABIN FLOOR SUPPORT BREAK ASSEMBLY LOCATED AT BS 540, FROM BL 0 TO RBL 23.5. REPLACED FLOOR SUPPORT BREAK ASSEMBLY PER AARD 51-00-05.SDR AALA202310030783Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT DOOR LOWER SILL WEB LOCATED FROM BS 440 TO BS 448, S25R. REPLACED DOOR SILL WEB PER SRM 51-40-02-0G.SDR AALA202310036918Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX AREA FLOOR SUPPORT BREAK ASSEMBLY PANEL LOCATED AT BS 540 AND RBL 2. REPLACED FLOOR SUPPORT BREAK ASSEMBLY PANEL PER SRM 51-10-02-0G.SDR AALA202310039818Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX AREA FLOOR SUPPORT BREAK ASSEMBLY PANEL LOCATED AT BS 540 AND LBL 2. REPLACED FLOOR SUPPORT BREAK ASSEMBLY PANEL PER SRM 51-10-02-0G.SDR AALA202309295291Container · odorAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING CLIMB FLIGHT ATTENDANT REPORTED ROTTEN EGG AND SULFUR SMELL IN AFT GALLEY. AIRCRAFT RETURN SAFELY TO CLE WITHOUT FURTHER INCIDENT. ACCOMPLISH JOB CARD 08L0002101 AND ISOLATED SMELL COMING FROM THESDR AALA202309289804Battery Pack · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT AT R-2 DOOR AND ESCAPE SLIDE LIGHT FAILED TEST. REPLACED EMERGENCY LIGHTING BATTERY PACK POWER SUPPLY M1672 PER MM 33-51-06. FUNCTIONAL CHECK GOOD.SDR AALA202311094580Bolt · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON BOLT OF FRONT SPAR FITTING RIGHT HAND SIDE AT VERTICAL STABILIZER. LOCATED AT STA 1016. REPLACED WITH IDENTICAL PART (PART NUMBER 170A1611-3). PER JOB CARD 08C32253004.SDR AALA202310252187Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 15.04. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202310259809Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 32.40. REPLACED SHEAR FITTING PER AARD 57-14-00 REPAIR 1.SDR AALA202310259347Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 40.87. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202310256733Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 54.60. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202310252458Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 6.14. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202310255652Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 15.04. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202310254011Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 32.40. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202310258472Fitting · crackedITEM WAS PREVIOUSLY SUBMITTED UNDER FAA OPERATOR CONTROL NUMBER AALA202310160302: AIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 40.87. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202310252949Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 54.60. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202310068061Floor Support · brokenAIRCRAFT IN BASE MAINTENANCE: BROKEN FLOOR SUPPORT BREAK ASSEMBLY PANEL LOCATED AT BS 540 LBL 0. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05.SDR AALA202310066833Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL LOCATED FROM BS 500A TO BS 500I, LBL 25. REPLACED TRANSITION PANEL PER AARD 51-00-05.SDR AALA202310059856Panel · brokenAIRCRAFT IN BASE MAINTENANCE: BROKEN PASSENGER CABIN FLOOR SUPPORT BREAK ASSEMBLY LOCATED AT BS 540, BL 0. REPLACED FLOOR SUPPORT BREAK ASSEMBLY PER AARD 51-00-05.SDR AALA202309292430Connector · unsecureAIRCRAFT IN BASE MAINTENANCE: LEFT HAND SIDE PASSENGER FLOOR PROXIMITY LIGHTING SEATS 21 THRU 26 ARE INOPERATIVE. RESECURED CONNECTOR D10716 PER WDM 33-51-22. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202309293201Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR DIFFICULT TO OPEN. CLEANED AND LUBRICATED FLIGHT DECK DOOR PER AMM 52-51-01.SDR AALA202309270728Cover · missingAIRCRAFT WAS NOT GROUNDED: DOOR 1R FORWARD GALLEY PLASTIC RED GIRT BAR PLASTIC COVER MISSING ON RIGHT SIDE. REPLACED RED PLASTIC COVER ON GIRT BAR AT DOOR 1R-FORWARD GALLEY. PER AMM 20-10-01.SDR AALA202309276218Girt Bar · lack of lubeAIRCRAFT WAS NOT GROUNDED: GIRT BAR IS DIFFICULT TO SET IN POSITION AND REMOVE AT DOOR R1. LUBRICATED GIRT BAR AS NEEDED.SDR AALA202309289020Guide Arm · wornAIRCRAFT WAS GROUNDED: FORWARD CABIN DOOR HANDLE VIBRATES OUT DURING TAKEOFF. **SUPPLEMENTAL REPORT FOR AALA202309279020: REMOVED AND REPLACED WORN GUIDE ARM ASSEMBLY PER AMM 52-11-21** (CLOSED)SDR AALA202309279020Unknown · unknownAIRCRAFT WAS GROUNDED: FORWARD CABIN DOOR HANDLE VIBRATES OUT OF POSITION ON TAKEOFF. FORWARD ENTRY DOOR LIGHT ILLUMINATES. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN).SDR AALA202309264692Engine · odorAIRCRAFT WAS GROUNDED: BURNING ODOR FUMES SMELL ON DECENT TO DFW ON FINAL. PERFORMED SMOKE ODOR FUME (SOF) TROUBLESHOT JOB CARD 08L00021001. FOUND NUMBER 1 ENGINE WITH BIRD STRIKE THROUGH CORE, CLEANED ENGINE, ODOR NOW GONE.SDR AALA202309267204Door · out of adjustAIRCRAFT WAS NOT GROUNDED: DOOR ON LAFT LAVAATORY IS DIFFICULT TO OPEN AND CLOSE. ADJUSTED DOOR.SDR AALA202309265761Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: COCKPIT DOOR IS VERY HARD TO OPEN WHEN UNLOCKED. LUBRICATED AND PERFORMED SATISFACTORY FUNCTIONAL CHECK PER AMM 52-51-00.SDR AALA202310137338Lug · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT HAND HORIZONTAL STABILIZER AFT SPAR LOWER TERMINAL FITTING (LUG) REPAIRED PER EA 348277 AND SRM 51-20-06SDR AALA202310064507Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION UPPER CHORD OF FLOORBEAM LOCATED AT BS 986.5, LBL 45. REPAIRED CHORD PER SRM 53-70-51-2R, REPAIR 6 ALTERNATIVE 4SDR AALA202309272567Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 6.14. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202309275750Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 15.04. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202309277563Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 54.60. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202309273938Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 40.87. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202309278022Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 32.40. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202309275971Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 54.60. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202309278773Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 32.40. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202309275691Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 40.87. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202309276364Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 15.04. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202309278932Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 6.14. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202309254093Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR DIFFICULT TO OPEN AND CLOSE IN FLIGHT. ADJUSTED UPPER DOOR MOLDING AT FORWARD LAVATORY. PER AARD 25-40-10. FUNCTIONAL CHECK GOOD.SDR AALA202310034058Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FLOOR BEAM UPPER CHORD LOCATED AT BS 927, RBL 51. REPAIRED FLOOR BEAM UPPER CHORD PER SRM 53-70-51-2R REPAIR 4 AND EA 347898.SDR AALA202309282563Heat Exchanger · odorAIRCRAFT WAS GROUNDED: ON DESCENT NOTICE HOT ODOR SMELL IN THE COCKPIT. ADDITIONALLY, WINDOWS FOGGED UP, AND LEFT PACK LIGHT ILLUMINATED AND TEMP WAS PEGGED AT 200 DEGREES. : MAINTENANCE REPLACED THE LEFT HAND PACK PRIMARY HEAT EXCHANGER (AALA202309262563), TH
Back to Boeing 737-823