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 SWAA2012091907742Charger · inoperativeOVERWING EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY CHARGER ASSY PER MM.SDR SWAA2012101808639Tie Clip · crackedTIE CLIP CRACKED AT BS 947.5, STR 25R. REPAIRED TIE CLIP IAW EA.SDR SWAA2012101508535Stringer · crackedSTRINGER CRACKED AT BS 867, STR 26R. REPAIRED STRINGER PER SRM.SDR SWAA2012100508298Shear Tie · corrodedSHEAR TIE CORRODED AT BS 747, BETWEEN STR 26L TO STR 27L. REPAIRED SHEAR TIE PER SRM.SDR SWAA2012092708060Tie Clip · crackedTIE CLIP CRACKED AT BS 727A, STR 26L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012092708058Tie Clip · crackedTIE CLIP CRACKED AT BS 867, STR 27R. REMOVED AND REPLACED TIE CLIP IAW SRM AND IAW SRM & DWG.SDR SWAA2012092407913Tie Clip · crackedTIE CLIP CRACKED AT BS 727A, STR 25L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012092407890Tie Clip · crackedTIE CLIP CRACKED AT BS 867, STR 27L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012092107859Coffeemaker · faultyFORWARD COFFEE POT HAD DISTINCT ELECTRICAL ODOR. TURNED OFF POT AND ODOR DISPERSED. REMOVED AND REPLACED COFFEEMAKER PER MM.SDR SWAA2012092107839Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 727A, BETWEEN STR 25L AND STR 26L. REMOVED AND REPLACED ANGLE IAW SRM & DWG.SDR SWAA2012092107838Tie Clip · crackedTIE CLIP CRACKED AT BS 927, STR 25R. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012092007785Skin · crackedSKIN CRACKED AT BS 336, STR 24R. REPAIRED SKIN IAW SRM.SDR SWAA2012091907782Floorbeam · crackedLONGITUDINAL FLOORBEAM CRACKED AT BS 713, BL 0. REPAIRED WEB PER SI & EA.SDR SWAA2012091907781Floorbeam · crackedLONGITUDINAL FLOORBEAM CRACKED AT BS 708, BL 0. REPAIRED WEB PER SI & EA.SDR SWAA2012091907780Floorbeam · crackedLONGITUDINAL FLOORBEAM CRACKED AT BS 709, BL 0. REPAIRED WEB PER SI & EA.SDR SWAA2012091907779Shear Tie · corrodedSHEAR TIE CORRODED AT BS 500C, BETWEEN STR 28LTO STR 27L. REPAIRED SHEAR TIE PER SRM.SDR SWAA2012091907758Window · arcedL1 COCKPIT WINDOW ARCED IN FLIGHT. REMOVED AND REPLACED L1 WINDOW PER AMM.SDR SWAA2012091807724Cover · brokenL1 DOOR LOWER EMERGENCY EXIT LIGHT COVER BROKEN. REMOVED AND REPLACED LIGHT ASSY IAW M/M.SDR SWAA2012092708061Angle · crackedLEFT KEEL BEAM ANGLE CRACKED AT BS 520+14. REMOVED AND REPLACED ANGLE IAW SRM & DWG.SDR SWAA2012092107841Web · crackedWEB CRACKED BETWEEN BS 500B TO BS 500C, BETWEEN STR 25R TO STR 26R. REMOVED AND REPLACED WEB IAW SRM AND DWG.SDR SWAA2012092107840Fitting · crackedCLIP CRACKED AT BS 380, STR 26L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA2012091807723Skin · crackedSKIN CRACKED AT BS 727E, STR 4R. REPAIRED SKIN PER EA.SDR SWAA2012091807722Skin · crackedSKIN CRACKED AT BS 787+7, BETWEEN STR 4 TO STR 10. REPAIRED SKIN PER EA.SDR SWAA2012092407891Web · crackedWEB CRACKED BETWEEN BS 400 TO BS 420, STR 26R. REMOVED AND REPLACED WEB IAW SRM AND DWG.SDR SWAA2012102908919Skin · crackedFUSELAGE SKIN CRACKED AT BS 520+5, STR 2R. REPAIRED SKIN IAW EA AND SRM.SDR SWAA2012102508840Floorbeam · crackedLONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 671, RBL 24.5. REPAIRED CHORD IAW EA AND EO.SDR SWAA2012092107834Skin · crackedR1 DOOR EXTERIOR SKIN CRACKED AT LOWER HINGE CUTOUT UPPER AFT CORNER. REMOVED AND REPLACED R1 DOOR IAW M/M.SDR SWAA2012092007816Shear Tie · crackedSHEAR TIE CORRODED AT BS 500C, BETWEEN STR 28R TO STR 28L. REPAIRED SHEAR TIE PER SRM.SDR SWAA2012092007815Gusset · crackedLONGITUDINAL FLOORBEAM UPPER CHORD LOWER SURFACE ATTACH STRAP CRACKED AT BS 727A+17, RBL 24.8. REMOVED AND REPLACED GUSSET PER SRM.SDR SWAA2012092007814Gusset · crackedLONGITUDINAL FLOORBEAM UPPER CHORD LOWER SURFACE ATTACH STRAP CRACKED AT BS 727A+18, RBL 24.8. REMOVED AND REPLACED GUSSET PER SRM.SDR SWAA2012092007813Gusset · crackedLONGITUDINAL FLOORBEAM UPPER CHORD LOWER SURFACE ATTACH STRAP CRACKED AT BS 727A+18, LBL 45.5. REMOVED AND REPLACED GUSSET PER SRM.SDR SWAA2012091707691Sign · brokenLEFT OVERWING EMERGENCY EXIT SIGN BROKEN. REMOVED AND REPLACED LENS PER MM.SDR SWAA2012100908336Skin · crackedFUSELAGE SKIN CRACKED AT BS 520+3, STRINGER 28L. REPAIRED SKIN PER SRM.SDR SWAA2012092507979Floorbeam · crackedLONGITUDINAL FLOORBEAM CRACKED AT BS 714, RBL 24.8. REPAIRED BEAM IAW EA.SDR SWAA2012092507978Floorbeam · crackedLONGITUDINAL FLOORBEAM CRACKED AT BS 710, LBL 24.8. REPAIRED BEAM IAW EA.SDR SWAA2012092507977Floorbeam · crackedLONGITUDINAL FLOORBEAM CRACKED AT BS 709, LBL 24.8. REPAIRED BEAM IAW EA.SDR SWAA2012092507939Tie Clip · crackedTIE CLIP CRACKED BETWEEN BS 500 TO BS 500A, STR 28L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012092107849Shear Tie · corrodedSHEAR TIE CORRODED AT BS 727E, BETWEEN STR 26L TO STR 27L. REPAIRED SHEAR TIE PER EA & ER.SDR SWAA2012091407620Skin · crackedSKIN CRACKED AT BS 747+4, STR 10R. REPAIRED SKIN PER EA.SDR SWAA2012100108151Keelbeam · crackedLEFT KEEL BEAM CRACKED BETWEEN BS 727 TO BS 663, LBL 6.5. REPAIRED KEEL BEAM IAW SRM.SDR SWAA2012092708051Stringer · corrodedSTRINGER CORRODED AT BS 1006+3, STR 27L. REPAIRED STRINGER IAW SRM.SDR SWAA2012092107844Gusset · crackedCENTER FUEL TANK FRONT SPAR GUSSET CRACKED AT AFT END, LBL 53.75. REMOVED AND REPLACED GUSSET PER SRM.SDR SWAA2012092007788Frame · crackedFRAME CRACKED AT BS 312 BETWEEN STR 24 TO STR 25R. REPAIRED FRAME IAW SRM.SDR SWAA2012092007787Frame · crackedFRAME CRACKED AT BS 312, BETWEEN STR 23 TO STR 24R. REPAIRED FRAME IAW SRM.SDR SWAA2012091407609Lug · brokenRIGHT WING NR 5 GROUND SPOILER LUGS BROKEN. REMOVED AND REPLACED NR 5 GROUND SPOILER PER AMM.SDR SWAA2012091907741Floorbeam · crackedLONGITUDINAL FLOORBEAM WEB CRACKED AT BS 707, LBL 24.8. REPAIRED WEB IAW SRM.SDR SWAA2012091907740Frame · corrodedFRAME CORRODED AT BS 500B, BETWEEN STR 28L TO STR 27L. REPAIRED FRAME IAW SRM.SDR SWAA2012091907739Frame · corrodedFRAME CORRODED AT BS 500B, BETWEEN STR 27L TO STR 26L. REPAIRED FRAME IAW SRM.SDR SWAA2012091907738Slat · delaminatedLEFT WING NR 2 SLAT O/B TRAILING EDGE DELAMINATED. REPAIRED SLAT PER SRM.SDR SWAA2012091407619Spindle · corrodedLEFT WING NR 2 FLAP CARRIAGE SPINDLE THERMAL COATING AND BASE METAL CORRODED. REMOVED AND REPLACED NR 2 SPINDLE FLAP CARRIAGE ASSY PER MT.
Back to Boeing 737-3H4