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 SWAA074908Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074906Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 767, STR 22L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074905Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 887, STR 25R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074904Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 440, STR 21L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074903Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STR 14L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074909Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 520, STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074915Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074914Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074913Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074875Stringer · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER 16L CRACKED AT BS 380. REPAIRED STRINGER PER SRM.SDR SWAA074878Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA074877Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482, STR 8L AND STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074881Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE STUB FRAME CRACKED AT BS 787, STR 16L. REPAIRED FRAME PER SRM.SDR SWAA074893Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 440, STR 21L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074892Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STR 14L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074874Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 927, STR 26R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074873Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 907, STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074876Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 685, STR 3L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074871Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 15L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074872Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 277, STR 15L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074880Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA074879Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA074862Slide · out of adjustDURING SCHEDULED BRDG CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA074860Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 277, STR 16R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074859Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 277, STR 11R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074858Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 947, STR 26R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074857Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 539, STR 28L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074861Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 18L. REPAIRED FRAME PER SRM.SDR SWAA074842Girt Bar · looseR1 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR HOOK MISSING FASTENER. INSTALLED MISSING FASTENER PER MM.SDR SWAA074840Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 277, STR 12R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074841Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 328, STR 20L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074820Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 3R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074819Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 344, STR 11R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074821Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 2R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074818Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 471, STR 17R. REPAIRED SKIN PER SRM.SDR SWAA074803Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 344, STR 11R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074806Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 2R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074805Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 3R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074804Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 294, STR 13R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074802Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 421, STR 17R. REPAIRED SKIN PER SRM.SDR SWAA074792Battery · inoperativeDURING SCHEDULED BRDG CHECK, FOUND FWD CABIN EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA074791Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482, STR 20L. REPAIRED FRAME PER SWA EA.SDR SWAA074793Attach Fitting · looseDURING SCHEDULED HC2 CHECK, FOUND RIGHT WING INBOARD GROUND SPOILER OUTBOARD ATTACH POINT LOOSE. REMOVED AND REPLACED SPOILER PER MM.SDR SWAA074775Bulkhead · crackedDURING SCHEDULED SPV CHECK, FOUND BULKHEAD WEB CRACKED AT BS 178, LBL 4.75. REPAIRED WEB PER SWA EA.SDR SWAA074755Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 934, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA074730Light · looseR1 DOOR EMERGENCY EXIT LIGHT ASSY LOOSE. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA074738Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482, STR 20L. REPAIRED FRAME PER SWA EA.SDR SWAA074729Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 747, STR 24L. REPAIRED SKIN PER SWA EA.SDR SWAA074715Battery · inoperativeDURING SCHEDULED BRDG CHECK, FOUND FWD CABIN EMERGENCY EXIT FLASHLIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA074683Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 787, STR 23L. REPAIRED SKIN PER SWA EA.
Back to Boeing 737-5H4