Boeing 737-3H4
Service difficulty reports · 52,340
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 = '7373H4' 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 = '7373H4' 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 SWAA2012092608021Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 807+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012092608020Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 887+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012092608019Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 867+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012092608018Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 827+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012092608017Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 807 +10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012092608016Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 480 +10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012092608015Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 420 +10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012092608014Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 400 +10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012092608013Skin · crackedLEFT FUSELAGE SKIN CRACKED BS 500C +10 UPPER FORWARD WINDOW CORNER CTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012092608012Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 500B +10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012092608011Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 500A +10 UPPER FORWARD WINDOW CORNER CRACKED. REPAIRED SKIN IAW SB.SDR SWAA2012092608010Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 500 +10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012092608009Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 460 +10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012092608008Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 500B+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012092608007Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 500A +10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012092608006Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 500 +10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW BOEING SB.SDR SWAA2012092608005Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 460 +10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012092608004Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 440 +10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW BAC SB.SDR SWAA2012092608003Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 400 +10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW BOEING SB.SDR SWAA2012092608002Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 380 +10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012092608001Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 500C +10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012092608000Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 500 +10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012092907942Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 767+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012092507952Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 787+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012092507951Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 767+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012092507950Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 767 +10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012092507949Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 480 +10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012092507948Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 460 +10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012092507947Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 827+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012092507946Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 767+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW BOEING SB.SDR SWAA2012092507945Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 867+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012092507944Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 847+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012092507943Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 787+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012092007811Door Frame · crackedAFT CARGO DOOR CUTOUT AFT FRAME CRACKED. REMOVED AND REPLACED FRAME IAW BAC DWG.SDR SWAA2012092007790Web · crackedWEB CRACKED BETWEEN BS 520 TO BS 540, BETWEEN STR 22R TO STR 24R. REMOVED AND REPLACED WEB IAW SRM & DWG.SDR SWAA2012091007449Actuator · leakingLEFT WING SPOILER OUTBOARD ACTUATOR LEAKED. REMOVED AND REPLACED SPOILER ACTUATOR PER MM.SDR SWAA2012090707430Slide · out of positionR1 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER M/M & MT.SDR SWAA2012090707429Slide · out of positionL1 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE FLAP PER M/M & MT.SDR SWAA2012090607403Trim Tab · delaminatedLEFT ELEVATOR TAB UNDER TAB MAST FAIRING DELAMINATED. REMOVED AND REPLACED TRIM TAB PER AMM.SDR SWAA2012101708585Bulkhead · corrodedLOWER BULKHEAD CHORD CORRODED AT BS 227.8, BETWEEN BL 0 TO LBL 5. REPAIRED CHORD IAW EA.SDR SWAA2012100908334Frame · dentedFUSELAGE FRAME DENTED AT BS 767, BETWEEN STR 24R - 25R. REPAIRED FRAME PER EA.SDR SWAA2012100908333Frame · dentedFUSELAGE FRAME DENTED AT BS 747, BETWEEN STR 24R - 25R. REPAIRED FRAME PER EA.SDR SWAA2012100508296Angle · crackedRIGHT VERTICAL STABILIZER LOWER FWD FITTING CHANNEL SPLICE ANGLE CRACKED. REMOVED AND REPLACED ANGLE IAW EA.SDR SWAA2012100408272Skin · crackedRIGHT HORIZONTAL STABILIZER LOWER SKIN CRACKED AT TRAILING EDGE. REPAIRED SKIN IAW REO AND EA.SDR SWAA2012100108091Crease Beam · corrodedRIGHT MAIN CABIN CREASE BEAM CORRODED BETWEEN BS 767 TO BS 787. REMOVED AND REPLACED WEB IAW MM, DWG AND SRM.SDR SWAA2012092007786Crease Beam · corrodedLEFT CREASE BEAM CORRODED BETWEEN BS 480 TO BS 500. REMOVED AND REPLACED BEAM IAW BAC DWG AND AMM.SDR SWAA2012091307571Stringer · crackedSTRINGER CRACKED BETWEEN BS 360 TO BS 390, STR 2L. REPAIRED STRINGER PER SRM.SDR SWAA2012090607391Skin · delaminatedLEFT WING NR 1 GROUND SPOILER UPPER SURFACE DELAMINATED. REMOVED AND REPLACED NR 1 SPOILER PER MM.SDR SWAA2012090507357Crease Beam · corrodedRIGHT MAIN CABIN CREASE BEAM CORRODED BETWEEN BS 440 TO BS 460. REMOVED AND REPLACED WEB ASSY IAW BAC DWG.SDR SWAA2012101208476Angle · corrodedZ-CHORD CORRODED AT BS 270, BL 0. REPAIRED "Z" SECTION PER EA.
Back to Boeing 737-3H4