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 SWAA111000Attach Fitting · corrodedDURING SCHEDULED 20Y CHECK, FOUND LT FAIL SAFE CHORD ATTACH FITTING CORRODED AT BS 1088. REPAIRED FITTING PER EA.SDR SWAA110999Attach Fitting · corrodedDURING SCHEDULED 20Y CHECK, FOUND RT FAIL-SAFE CHORD ATTACH FITTING CORRODED AT BS 1088. REPAIRED FITTING PER EA.SDR SWAA110996Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO COMPARTMENT FRAME CRACKED AT BS 482A, STR 22R. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA110994Rib · crackedDURING SCHEDULED 20Y CHECK, FOUND RT HORIZONTAL STABILIZER L/E CRACKED RIB AT STA 263.3. REMOVED AND REPLACED RIB PER SRM AND BAC DWG.SDR SWAA110993Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 22L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA110992Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 25L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA110930Strap · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN STRAP CRACKED BETWEEN BS 370 TO BS 395, BETWEEN STR 27R TO STR 27L. REMOVED AND REPLACED STRAP PER SRM AND BAC DWG.SDR SWAA110929Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 669, RBL 24.5. REPAIRED BEAM PER EA.SDR SWAA110888Lens · brokenDURING SCHEDULED 20Y CHECK, FOUND LT AFT EMERGENCY EXIT LIGHT LENS BROKEN. REMOVED AND REPLACED LENS PER MM.SDR SWAA110887Channel · corrodedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 790, RBL 3. REPAIRED CHANNEL PER EA.SDR SWAA110886Spar · crackedDURING SCHEDULED 20Y CHECK, FOUND LT WING CRACKED ON UPPER CHORD REAR SPAR RSS 223.14. REPAIRED SPAR PER EA.SDR SWAA110885Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED AT BS 367 STR 28R+8. REPAIRED SKIN EA.SDR SWAA110884Flap · delaminatedDURING SCHEDULED 20Y CHECK, FOUND RT WING I/B FORE FLAP DELAMINATED. REPAIRED FORE FLAP PER SRM.SDR SWAA110862Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 482A, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR SWAA110829Bracket · looseDURING SCHEDULED SPV CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE FWD ATTACHMENT BRACKET LOOSE. REMOVED AND REPLACED BRACKET PER SOPM.SDR SWAA110786Battery · dischargedDURING SCHEDULED RON CHECK, FOUND RT OVERHEAD EMERGENCY EXIT BULLNOSE LIGHT INOP AT ROW 1. RECHARGED BATTERY PER MM.SDR SWAA110785Battery · dischargedDURING SCHEDULED RON CHECK, FOUND R1 DOOR OVERHEAD EMERGENCY EXIT LIGHT INOP. RECHARGED BATTERY PER MM.SDR SWAA110787Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 927, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA110783Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 265.5, STR 17L. REPAIRED SKIN PER SRM.SDR SWAA110784Lens · brokenL1 DOOR LOWER EMERGENCY EXIT SIGN LENS BROKEN. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA110576Slat · delaminatedDURING SCHEDULED 20Y CHECK, FOUND LT WING NR 2 SLAT O/B EDGE DELAMINATED. REPAIRED SLAT PER SRM.SDR SWAA110575Stiffener · crackedDURING SCHEDULED 20Y CHECK, FOUND STIFFENER CRACKED AT BS 727, STR 27L. REMOVED AND REPLACED STIFFENER PER SRM AND BAC DWG.SDR SWAA110507Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND FRAME CORRODED AT BS 460, STR 26R. REPAIRED FRAME PER EA.SDR SWAA110451Flap · delaminatedDURING SCHEDULED 20Y CHECK, FOUND LT WING I/B FORE FLAP DELAMINATED. REPAIRED FORE FLAP PER SRM.SDR SWAA110393Stringer Splice · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER SPLICE CRACKED AT BS 363, STR 16L. REMOVED AND REPLACED SPLICE PER SRM.SDR SWAA110392Shear Tie · corrodedDURING SCHEDULED 20Y CHECK, FOUND SHEAR TIE CORRODED AT BS 482, BETWEEN STR 28R TO STR 28L. REPAIRED SHEAR TIE PER SRM.SDR SWAA110391Shear Tie · corrodedDURING SCHEDULED 20Y CHECK, FOUND SHEAR TIE CORRODED AT BS 482, BETWEEN STR 24R TO STR 28R. REPAIRED SHEAR TIE PER SRM.SDR SWAA110390Shear Tie · corrodedDURING SCHEDULED 20Y CHECK, FOUND SHEAR TIE CORRODED AT BS 482, BETWEEN STR 26R TO STR 27R. REPAIRED SHEAR TIE PER SRM.SDR SWAA110389Shear Tie · corrodedDURING SCHEDULED 20Y CHECK, FOUND SHEAR TIE CORRODED AT BS 360, BETWEEN STR 28L TO STR 28R. REPAIRED SHEAR TIE PER SRM.SDR SWAA110388Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED AT BS 282, BETWEEN STR 24R TO STR 25R. REPAIRED SKIN PER SRM.SDR SWAA110387Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED AT BS 787+18, STR 23L. REPAIRED SKIN PER SRM.SDR SWAA110386Support Channel · crackedDURING SCHEDULED 20Y CHECK, FOUND FWD CARGO COMPARTMENT SUPPORT CHANNEL CRACKED AT BS 460, STR 26R. REMOVED AND REPLACED CHANNEL PER SRM AND BAC DWG.SDR SWAA110385Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND FRAME CORRODED AT BS 482A, BETWEEN STR 28L TO STR 28R. REPAIRED FRAME PER SRM.SDR SWAA110384Keelbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND KEEL BEAM CORRODED AT BS 706, BETWEEN LBL 45.50 TO LBL 59.0. REPAIRED BEAM PER SRM AND BAC DWG.SDR SWAA110383Keelbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND KEEL BEAM CORRODED AT BS 482B, STR 28L. REPAIRED BEAM PER SRM AND BAC DWG.SDR SWAA110362Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND FRAME CORRODED AT BS 927, BETWEEN STR 25R TO STR 26R. REPAIRED FRAME PER SRM.SDR SWAA110361Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 947.5, STR 25R. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA110360Channel · corrodedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 751, RBL 3. REPAIRED CHANNEL PER EA.SDR SWAA110359Channel · corrodedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO COMPARTMENT CHANNEL CORRODED BETWEEN BS 732B TO BS 727C+25, LBL 3. REPAIRED CHANNEL PER EA.SDR SWAA110358Channel · corrodedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 772, RBL 8.10. REPAIRED CHANNEL PER EA.SDR SWAA110357Channel · corrodedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 772, LBL 3. REPAIRED CHANNEL PER EA.SDR SWAA110356Channel · corrodedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 772, LBL 8.10. REPAIRED CHANNEL PER EA.SDR SWAA110355Channel · corrodedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 772, LBL 12.50. REPAIRED CHANNEL PER EA.SDR SWAA110326Channel · corrodedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 860, RBL 8.10. REPAIRED CHANNEL PER EA.SDR SWAA110325Channel · corrodedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 860, LBL 8.10. REPAIRED CHANNEL PER EA.SDR SWAA110525Web · crackedDURING SCHEDULED 2HC1 CHECK, FOUND WING BOX RT UPPER I/B BEAM WEB CRACKED. REPAIRED WEB PER SRM.SDR SWAA110450Battery Pack · dischargedDURING SCHEDULED MV2 CHECK, FOUND FWD EMERGENCY EXIT LIGHT BATTERY PACK INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA110324Stringer Splice · crackedDURING SCHEDULED CV CHECK, FOUND STRINGER SPLICE CRACKED AT BS 360, STR 4R. REPAIRED SPLICE PER EA.SDR SWAA110323Skin · crackedDURING SCHEDULED CV CHECK, FOUND SKIN CRACKED AT BS 360, STR 3R. REPAIRED SKIN PER EA.SDR SWAA110328Slat · wornDURING SCHEDULED 2HC2 CHECK, FOUND RT WING NR 6 SLAT CAN LOWER SURFACE WORN. REMOVED AND REPLACED CAN PER MM.
Back to Boeing 737-5H4