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 SWAA103645Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND SKIN CRACKED AT BS 800, STR 23L. REPAIRED SKIN PER SRM.SDR SWAA103644Slide · out of positionDURING SCHEDULED HC2 CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR SWAA103620Lens · brokenDURING SCHEDULED MV1 CHECK, FOUND R1 DOOR EMERGENCY EXIT LENS BROKEN. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA103569Pressure Panel · crackedDURING SCHEDULED 2HC1 CHECK, FOUND PRESSURE DECK WEB CRACKED AT BS 664.75, RBL 43. REPAIRED WEB PER SRM.SDR SWAA103568Skin · delaminatedDURING SCHEDULED 2HC2 CHECK, FOUND RT WING O/B NR 7 FLIGHT SPOILER UPPER SURFACE DELAMINATED. REMOVED AND REPLACED NR 7 SPOILER PER MM.SDR SWAA103530Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 757, STR 22L. REPAIRED SKIN PER SRM.SDR SWAA103529Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 757, STR 23L. REPAIRED SKIN PER SRM.SDR SWAA103528Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 803, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA103527Wedge · delaminatedDURING SCHEDULED 20Y CHECK, FOUND RT WING NR 6 SLAT I/B WEDGE DELAMINATED. REPAIRED WEDGE PER SRM.SDR SWAA103526Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND R2 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA103468Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 927, STR 25R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA103467Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 294, STR 13L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA103465Wedge · delaminatedDURING SCHEDULED 20Y CHECK, FOUND RT WING NR 5 SLAT O/B WEDGE DELAMINATED. REPAIRED WEDGE PER SRM.SDR SWAA103438Skin · crackedDURING SCHEDULED CV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 384, STR 15R. REPAIRED SKIN PER EA.SDR SWAA103410Housing · defectiveDURING SCHEDULED MV2 CHECK, FOUND FWD EEPLS INOP. REMOVED AND REPLACED BATTERY PACK HOUSING PER MM.SDR SWAA103409Connector · disconnectedDURING SCHEDULED MV2 CHECK, FOUND RT OVERWING LOWER EMERGENCY EXIT LIGHT INOP. CONNECTED CONNECTOR PER MM.SDR SWAA103367Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND SKIN CRACKED AT BS 941, STR 23R. REPAIRED SKIN PER SRM.SDR SWAA103366Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND SKIN CRACKED AT BS 972, STR 21L. REPAIRED SKIN PER SRM.SDR SWAA103365Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND SKIN CRACKED AT BS 761, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA103364Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND SKIN CRACKED AT BS 944, STR 23R. REPAIRED SKIN PER SRM.SDR SWAA103363Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND SKIN CRACKED AT BS 971, STR 21L. REPAIRED SKIN PER SRM.SDR SWAA103362Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND SKIN CRACKED AT BS 760, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA103339Strap · crackedDURING SCHEDULED SPV CHECK, FOUND AFT CARGO DOOR CUTOUT SUB-THRESHOLD STRAP CRACKED. REMOVED AND REPLACED STRAP PER SRM AND BAC DWG.SDR SWAA103326Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 482, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR SWAA103325Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 520, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR SWAA103241Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 482, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR SWAA103226Skin · crackedDURING SCHEDULED MV3 CHECK, FOUND SKIN CRACKED AT BS 780, STR 19L. REPAIRED SKIN PER EA.SDR SWAA103225Stringer · crackedDURING SCHEDULED MV3 CHECK, FOUND STRINGER CRACKED AT BS 370, STR 15R. REMOVED AND REPLACED STRINGER PER SRM.SDR SWAA103224Skin · crackedDURING SCHEDULED MV3 CHECK, FOUND SKIN CRACKED AT BS 376, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA103223Skin · crackedDURING SCHEDULED MV3 CHECK, FOUND SKIN CRACKED AT BS 770.5, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA103222Skin · crackedDURING SCHEDULED MV3 CHECK, FOUND SKIN CRACKED AT BS 761, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA103221Skin · crackedDURING SCHEDULED MV3 CHECK, FOUND SKIN CRACKED AT BS 754, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA103172Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 482A, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR SWAA103176Skin · puncturedDURING SCHEDULED MV2 CHECK, FOUND LT ELEVATOR UPPER SURFACE PUNCTURED. REMOVED AND REPLACED ELEVATOR PER MM.SDR SWAA103173Slide · looseL2 DOOR EMERGENCY EVAC SLIDE LOOSE. SECURED SLIDE PER MT.SDR SWAA103175Slide · low pressureDURING SCHEDULED MV2 CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE GAUGE PRESSURE LOW. REMOVED AND REPLACED SLIDE PER MT.SDR SWAA103174Slide · out of adjustL2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA103112Lens · looseR1 DOOR EMERGENCY EXIT LIGHT LENS LOOSE. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA103111Light · looseDURING SCHEDULED 20Y CHECK, FOUND RT OVERWING EMERGENCY EXIT LIGHT LOOSE. REMOVED AND REPLACED LIGHT PER MM.SDR SWAA103110Keelbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND RT KEEL BEAM CORRODED BETWEEN BS 718 TO BS 727. REPAIRED BEAM PER ER.SDR SWAA103109Lug · corrodedDURING SCHEDULED 20Y CHECK, FOUND LT PRIMARY VERTICAL FIN LUG FACES CORRODED. REPAIRED LUGS PER ER.SDR SWAA103108Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND LT HORIZONTAL STABILIZER LOWER SKIN CRACKED. REMOVED AND REPLACED STABILIZER PER MM.SDR SWAA103107Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED AT BS 854, STR 24L. REPAIRED SKIN PER ER.SDR SWAA103148Slide · out of positionL1 DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT, DID NOT DEPLOY. RE-INSTALLED SLIDE PER MT.SDR SWAA103114Light · delaminatedDURING SCHEDULED CV CHECK, FOUND EEPLS DELAMINATED AT AFT GALLEY ENTRANCE. REMOVED AND REPLACED EEPLS PER MM.SDR SWAA103113Slide · out of positionL1 DOOR EMERGENCY EVAC SLIDE FELL OUT, DID NOT DEPLOY. RE-INSTALLED SLIDE PER MT.SDR SWAA103086Floor Support · corrodedDURING SCHEDULED 20Y CHECK, FOUND FLOOR SUPPORT CORRODED AT BS 860, LBL 3. REPAIRED SUPPORT PER EA.SDR SWAA103085Floor Support · corrodedDURING SCHEDULED 20Y CHECK, FOUND FLOOR SUPPORT CORRODED AT BS 770, LBL 3. REPAIRED SUPPORT PER EA.SDR SWAA103084Floor Support · corrodedDURING SCHEDULED 20Y CHECK, FOUND FLOOR SUPPORT CORRODED AT BS 860, RBL 8. REPAIRED SUPPORT PER EA.SDR SWAA103083Floor Support · corrodedDURING SCHEDULED 20Y CHECK, FOUND FLOOR SUPPORT CORRODED AT BS 860, LBL 8. REPAIRED SUPPORT PER EA.
Back to Boeing 737-5H4