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 SWAA117076Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED BETWEEN BS 747 TO BS 762, BETWEEN STR 23L TO STR 25L. REPAIRED SKIN IAW EA AND ER.SDR SWAA117075Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 22L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA117074Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 18L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA117073Web · crackedDURING SCHEDULED 22Y CHECK, FOUND WEB CRACKED AT BS 296.4, BETWEEN STR 7R TO STR 8R. REPAIRED WEB IAW EO AND EA.SDR SWAA117072Splice · crackedDURING SCHEDULED 22Y CHECK, FOUND BUTT SPLICE STRAP CRACKED AT BS 360, STR 4L. REMOVED AND REPLACED SPLICE STRAP IAW SRM AND DWG.SDR SWAA117071Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 16R. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA117070Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 16L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA117069Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 767, STR 16R. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA117068Frame · corrodedDURING SCHEDULED 22Y CHECK, FOUND AFT CARGO COMPARTMENT FRAME CORRODED AT BS 767, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME PER MM AND SRM.SDR SWAA117067Frame · corrodedDURING SCHEDULED 22Y CHECK, FOUND AFT CARGO COMPARTMENT FRAME CORRODED AT BS 807, BETWEEN STR 27L TO STR 26L. REPAIRED FRAME PER MM AND SRM.SDR SWAA117045Charger · inoperativeDURING SCHEDULED CV CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY CHARGER PER MM.SDR SWAA117018Stringer · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CRACKED BETWEEN BS 380 TO BS 400, STR 15R. REPAIRED STRNGER IAW SRM.SDR SWAA117017Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND SKIN CRACKED AT BS 380+14, STR 15L. REPAIRED SKIN IAW EO AND EA.SDR SWAA117016Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 16L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA116955Charger · inoperativeDURING SCHEDULED 22Y CHECK, FOUND LT EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY CHARGER ASSY IAW MM.SDR SWAA116956Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 947.5+12, STR 21L. REPAIRED SKIN IAW SRM.SDR SWAA116954Tab · delaminatedDURING SCHEDULED 22Y CHECK, FOUND RT ELEVATOR TAB DELAMINATED. REMOVED AND REPLACED TAB IAW MM.SDR SWAA116952Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 787, STR 25L. REPAIRED FRAME IAW EO AND EA.SDR SWAA116950Frame · corrodedDURING SCHEDULED 22Y CHECK, FOUND FRAME CORRODED AT BS 482A, BETWEEN STR 28R TO STR 28L. REPAIRED FRAME IAW EA.SDR SWAA116920Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 947.5, STR 25R. REPAIRED FRAME IAW EA.SDR SWAA116919Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 947.5, STR 20R. REPAIRED FRAME IAW EA.SDR SWAA116918Stringer Splice · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER SPLICE CRACKED AT BS 907+1.5, STR 4R. REMOVED AND REPLACED SPLICE IAW EO.SDR SWAA116917Stringer Splice · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER SPLICE CRACKED AT BS 907, STR 4R. REMOVED AND REPLACED SPLICE IAW EO.SDR SWAA116916Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 947, STR 25R. REPAIRED FRAME IAW EO AND EA.SDR SWAA116958Stringer Clip · crackedDURING SCHEDULED OTS CHECK, FOUND STRINGER CLIP CRACKED AT BS 986, STR 22L. REMOVED AND REPLACED CLIP IAW SRM.SDR SWAA116957Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 482B+15, STR 15R. REPAIRED SKIN IAW SRM.SDR SWAA116909Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND SKIN CRACKED BETWEEN BS 747+2 TO BS 747+15, BETWEEN STR 27L TO STR 27R.SDR SWAA116908Bulkhead · crackedDURING SCHEDULED 22Y CHECK, FOUND AFT PRESSURE BULKHEAD DOME WEB CRACKED AT BS 1016, STR 15R.SDR SWAA116907Bulkhead · crackedDURING SCHEDULED 22Y CHECK, FOUND AFT PRESSURE BULKHEAD DOME WEB CRACKED AT BS 1016, STR 7R. REPAIRED WEB IAW EO AND EA.SDR SWAA116906Bulkhead · crackedDURING SCHEDULED 22Y CHECK, FOUND AFT PRESSURE BULKHEAD DOME WEB CRACKED AT BS 1016, BL 0. REPAIRED WEB IAW EO AND EA.SDR SWAA116892Angle · crackedDURING SCHEDULED 22Y CHECK, FOUND FWD CARGO COMPARTMENT FAIL SAFE CHORD ANGLE CRACKED AT BS 460, STR 22L. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA116891Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 986.5, BETWEEN STR 2L TO STR 3L. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR SWAA116851Charger · inoperativeDURING SCHEDULED MV2 CHECK, FOUND EXTERIOR EMERGENCY EXIT LIGHT INOP AT R1 DOOR. REMOVED AND REPLACED BATTERY CHARGER PER MM.SDR SWAA116852Slide · out of adjustL1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MT.SDR SWAA116868Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 437.5, STR 17R. REPAIRED SKIN IAW SRM.SDR SWAA116756Light · inoperativeDURING SCHEDULED OTS CHECK, FOUND AFT OF L2 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT ASSY IAW SRM.SDR SWAA116755Attach Angle · damagedDURING SCHEUDLED RON CHECK, FOUND LONGITUDINAL ATTACHED ZEE HEAT DAMAGED AT BS 270. REMOVED AND REPLACED ZEE IAW EA AND AAR EA.SDR SWAA116754Crease Beam · damagedDURING SCHEDULED RON CHECK, FOUND RT CREASE BEAM WEB HEAT DAMAGED AT BS 277, STR 17R. REMOVED AND REPLACED WEB IAW EA AND AAR EA.SDR SWAA116753Frame · damagedDURING SCHEDULED RON CHECK, FOUND FRAME HEAT DAMAGED AT BS 277, BETWEEN STR 18R TO STR 19R. REMOVED AND REPLACED FRAME IAW EA.SDR SWAA116752Frame · damagedDURING SCHEDULED RON CHECK, FOUND FRAME I/B SPLICE CHORD HEAT DAMAGED AT BS 277, STR 18R. REMOVED AND REPLACED SPLICE CHORD IAW EA.SDR SWAA116751Frame · damagedDURING SCHEDULED RON CHECK, FOUND FRAME HEAT DAMAGED AT BS 277, BETWEEN STR 17R TO STR 19R. REMOVED AND REPLACED FRAME IAW EA.SDR SWAA116750Crease Beam · damagedDURING SCHEDULED RON CHECK, FOUND CREASE BEAM WEB HEAT DAMAGED BETWEEN BS 259 TO BS 277, STR 17R. REMOVED AND REPLACED WEB IAW EA AND EA.SDR SWAA116749Crease Beam · damagedDURING SCHEDULED RON CHECK, FOUND CREASE BEAM OUTER CHORD HEAT DAMAGED BETWEEN BS 259 TO BS 277, STR 17R. REMOVED AND REPLACED SECTION OF CHORD IAW EA AND EA.SDR SWAA116748Stringer · damagedDURING SCHEDULED RON CHECK, FOUND STRINGER HEAT DAMAGED BETWEEN BS 259 TO BS 277, STR 19R. REMOVED AND REPLACED STRINGER SECTION IAW EA AND AAR EA.SDR SWAA116747Stringer · damagedDURING SCHEDULED RON CHECK, FOUND STRINGER HEAT DAMAGED BETWEEN BS 259 TO BS 277, STR 18R. REMOVED AND REPLACED STRINGER SECTION IAW EA AND AAR EA.SDR SWAA116746Skin · damagedDURING SCHEDULED RON CHECK, FOUND SKIN HEAT DAMAGED ABOVE FWD LAV SERVICE PANEL. REPAIRED DOUBLE IAW EA AND EA.SDR SWAA116719Spoiler · delaminatedLT WING NR 2 FLIGHT SPOILER DELAMINATED. REMOVED AND REPLACED SPOILER PER MM.SDR SWAA116716Light · dischargedDURING SCHEDULED 22Y CHECK, LT EMERGENCY EXIT LIGHTS INOP. RELAMPED PER MM.SDR SWAA116715Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 947.5, STR 19L. REPAIRED FRAME IAW ER AND EA.SDR SWAA116714Light · inoperativeDURING SCHEDULED 22Y CHECK, RT EMERGENCY EXIT LIGHTS INOP. RELAMPED PER MM.
Back to Boeing 737-5H4