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 SWAA096452Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 482A, STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096451Fitting · looseDURING SCHEDULED 20Y CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR FITTING LOOSE. SECURED FITTING PER MM.SDR SWAA096417Light · missingDURING SCHEDULED 20Y CHECK, FOUND FWD GALLEY EMERGENCY EXIT LIGHT MISSING. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA096414Lug · corrodedDURING SCHEDULED 20Y CHECK, FOUND RT MLG BEAM STABILIZER BAR LUG FACES CORRODED. REMOVED AND REPLACED LUG PER MM.SDR SWAA096413Lug · corrodedDURING SCHEDULED 20Y CHECK, FOUND LT MLG BEAM STABILIZER BAR LUG FACES CORRODED. REMOVED AND REPLACED LUG PER MM.SDR SWAA096410Flap · delaminatedDURING SCHEDULED 20Y CHECK, FOUND LT WING I/B FORE FLAP DELAMINATED. REPAIRED FORE FLAP PER SRM.SDR SWAA096409Door Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND R1 DOOR UPPER STUB FRAME CRACKED. REMOVED AND REPLACED FRAME SECTION PER BAC DWG.SDR SWAA096391ALight · missingDURING SCHEDULED 20Y CHECK, FOUND FWD GALLEY EMERGENCY EXIT LIGHT MISSING. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA096388ALug · corrodedDURING SCHEDULED 20Y CHECK, FOUND RT MLG BEAM STABILIZER BAR LUG FACES CORRODED. REMOVED AND REPLACED LUG PER MM.SDR SWAA096387ALug · corrodedDURING SCHEDULED 20Y CHECK, FOUND LT MLG BEAM STABILIZER BAR LUG FACES CORRODED. REMOVED AND REPLACED LUG PER MM.SDR SWAA096384AFlap · delaminatedDURING SCHEDULED 20Y CHECK, FOUND LT WING I/B FORE FLAP DELAMINATED. REPAIRED FORE FLAP PER SRM.SDR SWAA096383AFrame · crackedDURING SCHEDULED 20Y CHECK, FOUND R1 DOOR UPPER STUB FRAME CRACKED. REMOVED AND REPLACED FRAME SECTION PER BAC DWG.SDR SWAA096433Mount · out of positionDURING SCHEDULED MV1 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR MOUNTS OUT OF POSITION. REPOSITIONED MOUNTS PER MM.SDR SWAA096390Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 947, RBL 23. REPAIRED FRAME PER SRM.SDR SWAA096388Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 987, STR 24L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096387Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER EA.SDR SWAA096386Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER EA.SDR SWAA096385Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER EA.SDR SWAA096364AFrame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 947, RBL 23. REPAIRED FRAME PER SRM.SDR SWAA096362AStringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 987, STR 24L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096361ASkin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER EA.SDR SWAA096360ASkin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER EA.SDR SWAA096359ASkin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER EA.SDR SWAA096351Flap · delaminatedDURING SCHEDULED 20Y CHECK, FOUND RT WING I/B FORE FLAP DELAMINATED. REMOVED AND REPLACED FORE FLAP PER MM.SDR SWAA096350Wedge · delaminatedDURING SCHEDULED 20Y CHECK, FOUND RT WING NR 3 SLAT I/B END T/E WEDGE DELAMINATED. REPAIRED WEDGE PER SRM.SDR SWAA096349Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED BETWEEN BS 821 TO BS 823, BETWEEN STR 1R TO STR 2R. REPAIRED SKIN PER SRM.SDR SWAA096348Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 8L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096347Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 9L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096346Shear Tie · corrodedDURING SCHEDULED 20Y CHECK, FOUND SHEAR TIE CORRODED AT BS 482B, STR 28R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA096345Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED AT BS 942, STR 24R. REPAIRED SKIN PER SRM.SDR SWAA096344Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED AT BS 932, STR 23R. REPAIRED SKIN PER SRM.SDR SWAA096343Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA096342Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 967, STR 19L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096341Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER EA.SDR SWAA096340Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER EA.SDR SWAA096339Light · corrodedDURING SCHEDULED 20Y CHECK, FOUND EEPLS CORRODED. REMOVED AND REPLACED EEPLS PER BAC DWG.SDR SWAA096337Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER EA.SDR SWAA096336Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER EA.SDR SWAA096306Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096305Light · inoperativeDURING SCHEDULED 20Y CHECK, FOUND RT OVERWING EMERGENCY EXIT SIDEWALL LIGHT INOP. REPAIRED LIGHT PER MM.SDR SWAA096304Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER AAR EA.SDR SWAA096303Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER AAR EA.SDR SWAA096302Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER AAR EA.SDR SWAA096301Stringer · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CRACKED AT BS 980, STR 21L. REPAIRED STRINGER PER SRM.SDR SWAA096300Skin · corrodedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE BELLY SKIN CORRODED AT BS 304, RBL 6. REPAIRED SKIN PER SRM.SDR SWAA096299Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 380, STR 8R. REPAIRED FRAME PER EA.SDR SWAA096298Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER EA.SDR SWAA096297Cable · out of positionDURING SCHEDULED 20Y CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE LATCH CABLE OUT OF POSITION. REPOSITIONED CABLE PER MM.SDR SWAA096296Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 727B, RBL 45.5. REPAIRED BEAM PER EA.SDR SWAA096295Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER EA.
Back to Boeing 737-5H4