Boeing 737-5H4
Service difficulty reports · 8,230
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 = '7375H4' 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 = '7375H4' 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 SWAA081982Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081981Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081988Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081979Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081989Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081978Fitting · corrodedDURING SCHEDULED BRDG CHECK, FOUND RIGHT WING NR 8 FLAP TRACK OUTBOARD FITTING CORRODED. REMOVED AND REPLACED FITTING PER SWA EA.SDR SWAA081947Slat · delaminatedDURING SCHEDULED 16Y CHECK, FOUND RIGHT WING NR 5 L/E SLAT DELAMINATED AT OUTBOARD END. REPAIRED SLAT PER SRM.SDR SWAA081915Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 277, STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081916Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 482, STR 10L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081914Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 663, STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081922Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L AND STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081926Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081927Floorbeam · crackedDURING SCHEDULED BRDG CHECK, FOUND FLOORBEAM WEB CRACKED AT BS 799, RBL 17. REMOVED AND REPLACED WEB PER SRM.SDR SWAA081923Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081924Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081925Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081902Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 344, STR 11R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081891Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 947, STR 27R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081875Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 3L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081876Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 344, STR 11R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081890Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 663, STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081889Stringer · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER 15R CRACKED AT BS 380. REPAIRED STRINGER PER SRM.SDR SWAA081888Stringer · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER 7L CRACKED AT BS 360. REPAIRED STRINGER PER SRM.SDR SWAA081887Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 11R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081896Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 1138, STR 13L. REPAIRED STRINGER CLIP PER SWA EA.SDR SWAA081856Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 944, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA081855Lens · crackedDURING SCHEDULED 16Y CHECK, FOUND R1 DOOR EMERGENCY EXIT LIGHT LENS CRACKED. REMOVED AND REPLACED LIGHT LENS PER MM.SDR SWAA081863Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 482, STR 16L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081823Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 944, STR 24L. REPAIRED SKIN PER SWA EA.SDR SWAA081824Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 941, STR 23R. REPAIRED SKIN PER SWA EA.SDR SWAA081822Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 420, STR 16L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081844Heat Exchanger · defectiveINFLIGHT SHUTDOWN / AIR TURNBACK / DECLARED EMERGENCY. NR 1 ENGINE OIL TEMP IN YELLOW BAND AFTER TAKEOFF, THEN TEMP WENT TO RED BAND. MAX OIL TEMP AT 190 DEGREES, SHUTDOWN ENGINE PER QRH. REMOVED AND REPLACED NR 1 ENGINE TEMP BULB AND FUEL OIL HEAT EXCHANGESDR SWAA081811Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 520, STR 16L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081812Shear Tie · corrodedDURING SCHEDULED BRDG CHECK, FOUND SHEAR TIE CORRODED AT BS 460, BL 0. REPAIRED SHEAR TIE PER SRM.SDR SWAA081810Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 482, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081809Pressure Panel · crackedDURING SCHEDULED BRDG CHECK, FOUND BEADED PRESSURE WEB CRACKED AT BS 663, LBL 31. REPAIRED WEB PER SRM.SDR SWAA081799Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 907, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA081800Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 787, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA081798Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 831, STR 15L. REPAIRED SKIN PER SWA EA.SDR SWAA081797Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 920, STR 24L AND STR 23L. REPAIRED SKIN PER SWA EA.SDR SWAA081774Skin · debondedDURING SCHEDULED BRDG CHECK, FOUND RT ELEVATOR UPPER SURFACE DISBONDED. REMOVED AND REPLACED ELEVATOR PER MM.SDR SWAA081723Stringer Splice · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER SPLICE CRACKED AT BS 360, STR 4L. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA081705Shear Tie · crackedDURING SCHEDULED 16Y CHECK, FOUND SHEAR TIE CRACKED AT BS 360, STR 14R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA081725Shear Tie · crackedDURING SCHEDULED 16Y CHECK, FOUND SHEAR TIE CRACKED AT BS 360, STR 14L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA081724Shear Tie · crackedDURING SCHEDULED 16Y CHECK, FOUND SHEAR TIE CRACKED AT BS 967, STR 6L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA081671Lens · looseLEFT OVERWING EMERGENCY EXIT LIGHT LENS LOOSE. SECURED LENS PER MM.SDR SWAA081682Flap · delaminatedDURING SCHEDULED BRDG CHECK, FOUND LT WING OUTBOARD T/E AFT FLAP DELAMINATED AT OUTBOARD END. REPAIRED FLAP PER SRM.SDR SWAA081662Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 908, STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081663Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 908, STR 10L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081643Skin · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BS 450, RBL 1.5. REPAIRED SKIN PER ER.
Back to Boeing 737-5H4