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 SWAA114282Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND T-CAP CORRODED AT BS 986, RBL 14. REPAIRED T-CAP PER SRM.SDR SWAA114281Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND T-CAP CORRODED AT BS 986, RBL 5. REPAIRED T-CAP PER SRM.SDR SWAA114280Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND T-CAP CORRODED AT BS 986, LBL 5. REPAIRED T-CAP PER SRM.SDR SWAA114239Skin · crackedDURING SCHEDULE SPV CHECK, FOUND SKIN CRACKED AT BS 787, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA114238Skin · crackedDURING SCHEDULE SPV CHECK, FOUND SKIN CRACKED AT BS 405, STR 17R. REPAIRED SKIN PER SRM.SDR SWAA114283Skin · crackedDURING SCHEDULED RON CHECK, FOUND RT HORIZONTAL STABILIZER CRACKED BETWEEN STA 105.7 TO STA 180. REPAIRED SKIN IAW EA.SDR SWAA114295Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 405, STR 17R. REPAIRED SKIN PER SRM.SDR SWAA114218Flap · delaminatedDURING SCHEDULED 20Y CHECK FOUND, LT WING FORE FLAP DELAMINATED. REMOVED AND REPLACED FORE FLAP PER EA.SDR SWAA114217Skin · corrodedDURING SCHEDULED 20Y CHECK FOUND, AFT CARGO COMPARTMENT SKIN CORRODED AT BS 818, BETWEEN STR 26R TO STR 27R. REPAIRED SKIN PER EO AND EA.SDR SWAA114216Skin · corrodedDURING SCHEDULED 20Y CHECK FOUND, AFT CARGO DOOR SKIN CRACKED BETWEEN BS 767 TO BS 794.3, BETWEEN STR 25R TO STR 26R. REPAIRED SKIN PER EA.SDR SWAA114215Aileron · delaminatedDURING SCHEDULED 20Y CHECK FOUND, LT WING AILERON DELAMINATED AT L/E LOWER AREA. REPAIRED AILERON PER EO SRM AND EA.SDR SWAA114214Skin · puncturedDURING SCHEDULED 20Y CHECK FOUND, LT WING FORE FLAP LOWER SKIN I/B PUNCTURED. REPAIRED FORE FLAP PER SRM.SDR SWAA114213Channel · corrodedDURING SCHEDULED 20Y CHECK FOUND, AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 727B+5, RBL 3.0. REPAIRED CHANNEL PER EA.SDR SWAA114191Web · crackedDURING SCHEDULED 20Y CHECK, FOUND WEB CRACKED AT BS 247, RBL 23. REPAIRED WEB PER ACO.SDR SWAA114190Web · crackedDURING SCHEDULED 20Y CHECK, FOUND WEB CRACKED AT BS 247, RBL 17. REPAIRED WEB PER ACO.SDR SWAA114189Shear Tie · corrodedDURING SCHEDULED 20Y CHECK, FOUND SHEAR TIE CORRODED AT BS 767, BETWEEN STR 26R TO STR 27R. REPAIRED SHEAR TIE PER SRM.SDR SWAA114188Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 285 TO BS 315, STR 6R TO STR 9R. REPAIRED SKIN PER EO.SDR SWAA114172Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR CUTOUT LOWER AFT CORNER. REPAIRED SKIN PER SRM.SDR SWAA114212Skin · crackedDURING SCHEDULED OTS CHECK FOUND, SKIN CRACKED AT BS 360+15, STR 15L. REPAIRED SKIN PER EA.SDR SWAA114153Shear Tie · corrodedDURING SCHEDULED 20Y CHECK, FOUND SHEAR TIE CORRODED AT BS 482A, BETWEEN STR 27R TO STR 28R. REPAIRED SHEAR TIE PER SRM.SDR SWAA114152Fitting · crackedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO COMPARTMENT FITTING CRACKED AT BS 727, STR 27L. REMOVED AND REPLACED FITTING PER SRM.SDR SWAA114151Lens · missingDURING SCHEDULED 20Y CHECK, FOUND RT OVERHEAD EMERGENCY EXIT BULLNOSE LIGHT LENS MISSING AT ROW 9. INSTALLED LENS PER MM.SDR SWAA114186Lens · missingDURING SCHEDULED MV1 CHECK, FOUND RT OVERHEAD EMERGENCY EXIT BULLNOSE LIGHT LENS MISSING AT ROW 7. INSTALLED LENS PER MM.SDR SWAA114174Hook · looseL1 DOOR EMERGENCY EVAC SLIDE GIRT BAR HOOK LOOSE. SECURED HOOK PER MM.SDR SWAA114125Skin · delaminatedDURING SCHEDULED 22Y CHECK, FOUND RT WING O/B AFT FLAP T/E DELAMINATED. REMOVED AND REPLACED SKIN PER MM.SDR SWAA114101Shear Tie · corrodedDURING SCHEDULED 20Y CHECK, FOUND SHEAR TIE CORRODED AT BS 482B, BETWEEN STR 27R TO STR 28R. REMOVED AND REPLACED SEHAR TIE PER SRM.SDR SWAA114128Stringer · corrodedDURING SCHEDULED OTS CHECK, FOUND STRINGER CORRODED BETWEEN BS 986 TO BS 1016, STR 25L. REMOVED AND REPLACED STRINGER SECTION PER SRM.SDR SWAA114127Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 927+6, STR 25L. REPAIRED SKIN PER EA.SDR SWAA114126Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 747+4, STR 19L. REPAIRED SKIN PER EA.SDR SWAA114082Channel · corrodedDURING SCHEDULED 20Y CHECK FOUND, AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 880, RBL 8.10. REPAIRED CHANNEL PER EA.SDR SWAA114081Frame · corrodedDURING SCHEDULED 20Y CHECK FOUND, FRAME CORRODED AT BS 827, BETWEEN STR 27R TO STR 27L. REPAIRED FRAME PER SRM.SDR SWAA114080Frame · corrodedDURING SCHEDULED 20Y CHECK FOUND, FRAME CORRODED AT BS 767, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME PER SRM.SDR SWAA114079Frame · corrodedDURING SCHEDULED 20Y CHECK FOUND, FRAME CORRODED AT BS 482A, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME PER SRM.SDR SWAA114078Frame · corrodedDURING SCHEDULED 20Y CHECK FOUND, FRAME CORRODED AT BS 482A, BETWEEN STR 27L TO STR 28L. REPAIRED FRAME PER SRM.SDR SWAA114077Frame · corrodedDURING SCHEDULED 20Y CHECK FOUND, FRAME CORRODED AT BS 482A, BETWEEN STR 27R TO STR 28R. REPAIRED FRAME PER SRM.SDR SWAA114076Frame · corrodedDURING SCHEDULED 20Y CHECK FOUND, FRAME CORRODED AT BS 482A, BETWEEN STR 28R TO STR 28L. REPAIRED FRAME PER SRM.SDR SWAA114075Channel · corrodedDURING SCHEDULED 20Y CHECK FOUND, AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 772, LBL 12.50. REPAIRED CHANNEL PER EA.SDR SWAA114074Stringer Splice · crackedDURING SCHEDULED 20Y CHECK FOUND, STRINGER SPLICE CRACKED AT BS 360, STR 6R. REMOVED AND REPLACED SPLICE PER SRM.SDR SWAA114100Stringer Clip · crackedDURING SCHEDULED OTS CHECK, FOUND STRINGER CLIP CRACKED AT BS 967, STR 24L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA114038Skin · delaminatedDURING SCHEDULED 20Y CHECK FOUND, LT WING AFT FLAP DELAMINATED ON O/B SIDE LOWER SKIN. REPAIRED AFT FLAP PER SRM.SDR SWAA114037Channel · corrodedDURING SCHEDULED 20Y CHECK FOUND, AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 727B+5, RBL 3. REPAIRED CHANNEL PER EA.SDR SWAA114036Channel · corrodedDURING SCHEDULED 20Y CHECK FOUND, AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 772, RBL 8.10. REPAIRED CHANNEL PER EA.SDR SWAA114035Channel · corrodedDURING SCHEDULED 20Y CHECK FOUND, AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 860, RBL 8.10. REPAIRED CHANNEL PER EA.SDR SWAA114034Channel · corrodedDURING SCHEDULED 20Y CHECK FOUND, AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 772, RBL 3. REPAIRED CHANNEL PER EA.SDR SWAA114033Channel · corrodedDURING SCHEDULED 20Y CHECK FOUND, AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 772, LBL 3. REPAIRED CHANNEL PER EA.SDR SWAA114032Channel · corrodedDURING SCHEDULED 20Y CHECK FOUND, AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 772, LBL 8.10. REPAIRED CHANNEL PER EA.SDR SWAA114031Channel · corrodedDURING SCHEDULED 20Y CHECK FOUND, AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 727B+5, RBL 8.10. REPAIRED CHANNEL PER EA.SDR SWAA114030Channel · corrodedDURING SCHEDULED 20Y CHECK FOUND, AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 727B+5, LBL 3. REPAIRED CHANNEL PER EA.SDR SWAA114029Channel · corrodedDURING SCHEDULED 20Y CHECK FOUND, AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 727B+5, LBL 8.10. REPAIRED CHANNEL PER EA.SDR SWAA114028Channel · corrodedDURING SCHEDULED 20Y CHECK FOUND, AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 860, LBL 3. REPAIRED CHANNEL PER EA.
Back to Boeing 737-5H4