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 AALA202307192880Fitting · 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 AND SRM 51-40-02.SDR AALA202307197774Fitting · 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 AND SRM 51-40-02.SDR AALA202307193004Fitting · 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 AND SRM 51-40-02.SDR AALA202307199127Fitting · 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 AND SRM 51-40-02.SDR AALA202307199470Fitting · 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 AND SRM 51-40-02.SDR AALA202307193532Fitting · 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 AND SRM 51-40-02.SDR AALA202307191912Fitting · 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 AND SRM 51-40-02.SDR AALA202307184494Unknown · corrodedAIRCRAFT IN BASE MAINTENANCED: CORROSION ON L1 DOOR LOWER SILL CHORD LOCATED AT BS 318 AND LBL 59. REPLACED CHORD PER SRM 51-40-02,SDR AALA202307189791Seat Track · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT FLOOR RAIL ASSEMBLY LOCATED AT BS 500I AND FROM S25L TO S25R. REPLACED RAIL ASSEMBLY PER SRM 51-40-02-0G.SDR AALA202307267512Shade · stuckAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT WINDOW SHADE 16F WILL NOT OPEN. **SUPPLEMENTAL REPORT FOR AALA202307187512: REPLACED 16F WINDOW SHADE IAW AMM 25-21-12. ** (CLOSED)SDR AALA202307204522Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 500B TO BS 500I AT S25L. REPAIRED TRANSITION PANEL PER SRM 53-00-53-2R PROCEDURE 5 AND SRM 51-40-02-0G.SDR AALA202307190239Power Supply · inoperativeAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHT POWER SUPPLY M01670 INOPERATIVE. **SUPPLEMENTAL REPORT FOR AALA202307180239: REPLACED POWER SUPPLY PER AMM 33-51-06.** (CLOSED)SDR AALA202307194901Shade · stuckAIRCRAFT WAS NOT GROUNDED: EXIT ROW SEAT 16F WINDOW SHADE STUCK IN EXTENDED POSITION. RESEATED SHADE INTO TRACK PER AMM 25-21-12.SDR AALA202307180239Unknown · unknownAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHT POWER SUPPLY M01670 INOPERATIVE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202307189051Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: L1 DOOR FLASHLIGHT INOPERATIVE. REPLACED L1 DOOR FLASHLIGHT BATTERY.SDR AALA202307187512Unknown · unknownAIRCRAFT WAS NOT GROUNDED: WINDOW SHADE 16F WILL NOT OPEN. **SUPPLEMENTAL REPORT WILL BE SUBMITTED. ** (OPEN)SDR AALA202307186554Angle · crackedAIRCRAFT IN BASE MAINTENANCED: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER ATTACH ANGLE LOCATED AT BS 727, WL 171.5 AND RBL 12. REPAIRED ANGLE PER SRM 57-10-10-2R-5.SDR AALA202307184074Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK FUSELAGE SKIN SURROUND FOR EXTERNAL POWER ACCESS DOOR LOCATED FROM BS 229 TO BS 235 AND FROM S19R TO S20R. REPAIRED SKIN PER SRM 53-10-15-2R PROCEDURE 4 REPAIR 4.SDR AALA202307187886Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER ATTACH ANGLE LOCATED AT BS 663 AND S20L. REPAIRED ANGLE PER SRM 57-10-10-2R-5.SDR AALA202307170055Flashlight · missingAIRCRAFT WAS NOT GROUNDED: FORWARD GALLEY EMERGENCY FLASHLIGHT NOT INSTALLED. REMOVED AND REPLACED FORWARD GALLEY INBOARD FLASHLIGHT.SDR AALA202307185419Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON G1 GALLEY AREA FITTING LOCATED AT BS 277 AND RBL 41.80. REPLACED FITTING PER SRM 51-40-02.SDR AALA202307188385Support Strap · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON G1 GALLEY FLOOR SUPPORT STRAP LOCATED AT BS 260 AND RBL 41.50. REPLACED SUPPORT STRAP PER SRM 51-40-02.SDR AALA202307180132Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON G1 GALLEY FLOOR INTERCOSTAL LOCATED AT BS 290 AND RBL 41.80. REPLACED INTERCOSTAL PER SRM 51-40-02.SDR AALA202307186782Unknown · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LOWER SILL INNER CHORD LOCATED FROM BS 290 TO BS 315 AT RBL 59.5. REPLACED CHORD PER SRM 51-40-02.SDR AALA202307192474Shade · damagedAIRCRAFT WAS NOT GROUNDED: WINDOW SHADE DAMAGED ON RIGHT FORWARD OVER WING EMERGENCY EXIT DOOR. **SUPPLEMENTAL REPORT FOR AALA202307172474: REPLACED 16F SEAT WINDOW SHADE PER AMM 25-21-12.** (CLOSED)SDR AALA202307172474Unknown · unknownAIRCRAFT WAS NOT GROUNDED: WINDOW SHADE DAMAGED ON RIGHT FORWARD OVER WING EMERGENCY EXIT DOOR. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202307175212Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR DIFFICULT TO OPEN. CLEANED DEBRIS AND LUBRICATED DOOR.SDR AALA202307173338Light · disconnectedAIRCRAFT WAS NOT GROUNDED: FOUND EMERGENCY AISLE LIGHTS INOPERATIVE IN ROW 14 ABC. RE-CONNECTED EMERGENCY AISLE LIGHTS IAW AMM 33-51-03-960-805. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202307172199Light · disconnectedAIRCRAFT WAS NOT GROUNDED: FOUND EMERGENCY AISLE LIGHTS INOPERATIVE IN ROW 32 FED. RE-CONNECTED EMERGENCY AISLE LIGHTS IAW AMM 33-51-03-960-805. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202307218861Shade · damagedAIRCRAFT WAS NOT GROUNDED: 16F WINDOW SHADE CRUMPLED AND WILL NOT OPEN FULLY. **SUPPLEMENTAL REPORT FOR AALA20230717886: REPLACED WINDOW SHADE AT 16F PER M/M 25-21-12.** (CLOSED)SDR AALA202307187153Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RUDDER SKIN CONDUCTIVE FRAME LOCATED AT RUDDER STA 282. REPAIRED FRAME PER SRM 55-40-01-2R PROCEDURE 2 REPAIR 2.SDR AALA202307186690Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 101.90, 18 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202307180566Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 129.50, 26 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202307183760Panel · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN MAIN CABIN FLOORBOARD SUPPORT BREAK ASSEMBLY PANEL LOCATED AT BS 540 FROM LBL 1 TO LBL 21. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05.SDR AALA202307178861Unknown · unknownAIRCRAFT WAS NOT GROUNDED: 16F WINDOW SHADE CRUMPLED AND WILL NOT OPEN FULLY. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202307140902Bulb · not seatedAIRCRAFT WAS NOT GROUNDED: ROW 16 DEF EMERGENCY LIGHT IS INOPERATIVE. ADJUSTED/RESET BULB.SDR AALA202307188466Rib · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT HAND HORIZONTAL STABILIZER RIB LOCATED AFT OF REAR SPAR AT ELEVATOR STA 66.54. REPAIRED RIB PER EA 344844 AND SRM 51-40-02.SDR AALA202307184436Frame · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT SIDE OF FRAME LOCATED AT BS 947.5 BETWEEN S22R AND S23R. REPAIRED FRAME PER EA 345938 AND SRM 53-70-02-2R.SDR AALA202307182999Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR RIGHT HAND TRANSITION SHIELD LOCATED FROM BS 767 TO BS 787 AT S27R. REPLACED TRANSITION SHIELD PER AARD 51-00-05-1 R1.SDR AALA202307146009Sliding Window · out of adjustAIRCRAFT WAS NOT GROUNDED: L2 SLIDING WINDOW IS EXTREMELY DIFFICULT TO OPEN AND CLOSE. ADJUSTED L2 SLIDING WINDOW PER AMM 56-12-11.SDR AALA202307145368Tire · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED COMING INTO THE SCHEDULED DESTINATION OF ORD. #3 TIRE BLEW ON TAKEOFF FROM DCA. FLIGHT CONTINUED AND LANDED SAFELY AT ORD WITHOUT FURTHER INCIDENT. MAINTENANCE REPLACED #3 TIRE PER AMM 32-45-17.SDR AALA202307146513Threshold · out of adjustAIRCRAFT WAS NOT GROUNDED: RIGHT AFT LAVATORY DOOR DIFFICULT TO OPEN AND CLOSE. ADJUSTED RIGHT AFT LAVATORY BOTTOM DOOR THRESHOLD PER AMM 25-40-15.SDR AALA202307142829Shade · damagedAIRCRAFT WAS NOT GROUNDED: SEAT 17F EXIT ROW WINDOW SHADE DAMAGED. REMOVED AND REPLACED WINDOW SHADE AT SEAT 17F.SDR AALA202307131027Door · stuckAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR STICKS AT BOTTOM MAKING IT DIFFICULT TO OPEN AND CLOSE. ADJUSTED FORWARD LAVATORY DOOR PER CMM 25-45-46.SDR AALA202307139750Fitting · 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 AALA202307133712Fitting · 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 AALA202307133547Fitting · 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 AALA202307132723Fitting · 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 AALA202307125445Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: FORWARD MEGAPHONE INOPERATIVE. REPLACED BATTERY IN FORWARD MEGAPHONE.SDR AALA202307123933Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT MEGAPHONE INOPERATIVE. REPLACED BATTERY IN AFT MEGAPHONE.
Back to Boeing 737-823