Boeing 737-3Q8
Service difficulty reports · 4,188
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 = '7373Q8' 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 = '7373Q8' 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 SWAA050570Splice · crackedDURING SCHEDULED D CHECK, FOUND STRINGER SPLICE CRACKED AT BS 907, BETWEEN STR 4L AND STR 4R. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA050574Shear Tie · corrodedDURING SCHEDULED D-CHECK, FOUND CORROSION ON SHEAR TIE AT BS 344, RBL 17. REPAIRED SHEAR TIE PER SRM.SDR SWAA050573Fitting · corrodedDURING SCHEDULED D-CHECK, FOUND CORROSION ON LT MLG LOWER STRUT FITTING. REMOVED AND REPLACED LT MLG LOWER STRUT FITTING PER MM.SDR SWAA050572Shear Tie · corrodedDURING SCHEDULED D-CHECK, FOUND CORROSION ON SHEAR TIE AT BS 907, BL 0, WL 160. REPAIRED SHEAR TIE PER SRM.SDR SWAA050571Frame · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED FRAME AT BS 807, STR 9L. REPAIRED FRAME PER SRM.SDR SWAA050560Stringer Clip · corrodedDURING SCHEDULED D-CHECK, FOUND CORROSION ON STRINGER CLIP AT BS 727E, STR 26R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA050548Stringer Clip · crackedDURING SCHEDULED D CHECK, FOUND CRACKED STRINGER CLIP AT BS 597, STR 8L AND 8R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA050546Stringer Clip · crackedDURING SCHEDULED D CHECK, FOUND CRACKED STRINGER CLIP AT BS 663, STR 10L AND 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA050541Stringer Clip · crackedDURING SCHEDULED D CHECK, FOUND STRINGER CLIP AT BS 727C, BETWEEN STR 2R AND 6R CRACKED. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA050539Stringer Clip · crackedDURING SCHEDULED D CHECK, FOUND STRINGER CLIP AT BS 727C,BETWEEN STR 5L AND 7L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA050551Crease Beam · crackedDURING SCHEDULED D-CHECK, FOUND CRACK AT LT CREASE BEAM WEB AT BS 375. REPAIRED BEAM WEB PER SRM.SDR SWAA050550Splice · crackedDURING SCHEDULED D-CHECK, FOUND CRACK AT STRINGER SPLICE, BS 663, STR 7L. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA050549Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED STRINGER CLIP AT BS 578, STR 11R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA050547Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED STRINGER CLIP AT BS 616, STR 8L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA050545Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED STRINGER CLIP AT BS 727A, STR 1. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA050544Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED STRINGER CLIP AT BS 727A, STR 6R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA050543Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED STRINGER CLIP AT BS 727B, STR 7R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA050542Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED STRINGER CLIP AT BS 727B, STR 8L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA050540Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED STRINGER CLIP AT BS 727C, STR 16L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA050538Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED STRINGER CLIP AT BS 727D, STR 6R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA050537Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND 3 EA CRACKED STRINGER CLIPS AT BS 727D, BETWEEN STR 4L AND 6L. REMOVED AND REPLACED STRINGER CLIPS PER SRM.SDR SWAA050536Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND 2 EA CRACKED STRINGER CLIPS AT BS 727E, BETWEEN STR 5L AND 7L. REMOVED AND REPLACED STRINGER CLIPS PER SRM.SDR SWAA050535Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED STRINGER CLIP AT BS 767, STR 16R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA050534Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND 2 EA CRACKED STRINGER CLIPS BETWEEN BS 767 AND BS 787 STR 11L. REMOVED AND REPLACED STRINGER CLIPS PER SRM.SDR SWAA050533Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED STRINGER CLIP AT BS 807, STR 16L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA050532Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME CRACKED AT BS 907, STR 9R. REPAIRED FRAME PER SRM.SDR SWAA050531Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME CRACKED AT BS 887, STR 9R. REPAIRED FRAME PER SRM.SDR SWAA050530Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME CRACKED AT BS 827, STR 9R. REPAIRED FRAME PER SRM.SDR SWAA050529Frame · crackedDURING SCHEDULED D-CHECK, FOUND BS 440 FRAME CRACKED AT STR 9L. REPAIRED FRAME PER SRM.SDR SWAA050528Light · inoperativeDURING SCHEDULED D-CHECK, FOUND R2 DOOR ESCAPE SLIDE LIGHT INOP. REMOVED AND REPLACED LIGHT HOUSING PER SRM.SDR SWAA050506Slide · dislodgedR1 DOOR EVAC SLIDE FELL OUT, DID NOT DEPLOY. REINSTALLED R1 DOOR EVAC SLIDE PER MM.SDR SWAA050513Beam · corrodedDURING SCHEDULED D-CHECK, FOUND LT MLG ATTACH BEAM CORRODED. REPAIRED ATTACH BEAM PER ER.SDR SWAA050512Skin · delaminatedDURING SCHEDULED D-CHECK, FOUND NR 3 L/E SLAT DELAMINATED. REPAIRED NR 3 L/E SLAT PER SRM.SDR SWAA050511Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM WEB FROM BS 360 TO BS 371, LBL 64, CORRODED. REMOVED AND REPLACED CREASE BEAM SECTION WEB PER SRM.SDR SWAA050509Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME AT BS 787, STR 9R CRACKED. REPAIRED FRAME SECTION PER SRM.SDR SWAA050505Spar · corrodedDURING SCHEDULED D-CHECK, FOUND VERTICAL FIN FWD AND AFT SPAR, RT AND LT CLEVIS LUGS, CORRODED. REPAIRED VERTICAL FIN PER ER.SDR SWAA050483Skin · wornDURING SPV, FOUND UPPER RT AND LT FUSELAGE SKIN FROM BS 860 TO BS 887, UNDER DORSAL FIN, WORN. REPAIRED SKIN PER ER.SDR SWAA050491Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 500D, STRINGER 4R, CRACKED. REPAIRED SKIN PER EA.SDR SWAA050490Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 482 + 2, STRINGER 10L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA050489Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 867, STRINGER 23R, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA050488Angle · crackedDURING SCHEDULED CHECK, FOUND NR 2 ENGINE UPPER PYLON ATTACH ANGLE, CRACKED. REMOVED AND REPLACED ATTACH ANGLE PER EA.SDR SWAA050487Skin · crackedDURING SCHEDULED C1 CHECK, FOUND 2 EACH FUSELAGE SKIN CRACKS FROM BS 756 TO BS 757, BETWEEN STRINGERS 21R AND 22R. REPAIRED SKIN SECTIONS PER SRM.SDR SWAA050465Structure · crackedDURING SCHEDULED D-CHECK, FOUND STRUCTURE CRACKED FROM BS 787 TO BS 847, STRINGER 8L. REPAIRED STRUCTURE SECTION PER SRM.SDR SWAA050475Spar · crackedDURING SCHEDULED D-CHECK, FOUND RT WING REAR SPAR UPPER CHORD AT STATION 223, CRACKED. REMOVED AND REPLACED REAR SPAR SECTION PER ER AND BAC DRAWING.SDR SWAA050474Spar · crackedDURING SCHEDULED D-CHECK, FOUND LT WING REAR SPAR AT STATION 285, 12 O'CLOCK POSITION, CRACKED. REMOVED AND REPLACED REAR SPAR SECTION PER ER AND BAC DRAWING.SDR SWAA050473Crease Beam · crackedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM WEB AT BS 638, CRACKED. REMOVED AND REPLACED CREASE BEAM WEB PER SRM.SDR SWAA050472Fitting · corrodedDURING SCHEDULED D-CHECK, FOUND RT MLG STABILIZER LINK FWD ATTACH FITTING, CORRODED. REMOVED AND REPLACED FWD FITTING PER SRM.SDR SWAA050471Fitting · corrodedDURING SCHEDULED D-CHECK, FOUND RT MLG BEAM STABILIZER LINK FITTING, CORRODED. REMOVED AND REPLACED FITTING PER SRM.SDR SWAA050470Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM INNER CHORD ANGLE AT BS 360, LBL 64, CORRODED. REMOVED AND REPLACED CREASE BEAM CHORD ANGLE PER SRM.SDR SWAA050469Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM UPPER CHORD AT BS 344, FROM LBL 7 TO RBL 9, CORRODED. REPAIRED CHORD PER SRM.
Back to Boeing 737-3Q8