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 SWAA071034Battery Pack · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND AFT CABIN EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA071014Rib · crackedDURING SCHEDULED 20Y CHECK, FOUND RT HORIZONTAL STAB L/E RIB CRACKED AT STA 101. REMOVED AND REPLACED L/E RIB PER SRM.SDR SWAA071013Floorbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM CORRODED AT BS 294, BL 0 TO RBL 12. REPAIRED FLOORBEAM PER SRM.SDR SWAA070994Torque Tube · corrodedDURING SCHEDULED 20Y CHECK, FOUND LEFT WING INBOARD MID FLAP OUTBOARD TORQUE TUBE CORRODED. REMOVED AND REPLACED TORQUE TUBE PER MM.SDR SWAA070993Torque Tube · corrodedDURING SCHEDULED 20Y CHECK, FOUND LEFT WING INBOARD MID FLAP INBOARD TORQUE TUBE CORRODED. REMOVED AND REPLACED TORQUE TUBE PER MM.SDR SWAA070924Skin · delaminatedDURING SCHEDULED 20Y CHECK, FOUND LEFT ELEVATOR TAB SKIN DELAMINATED AT UPPER SURFACE. REPAIRED SKIN PER SRM.SDR SWAA070925Shear Tie · corrodedDURING SCHEDULED 20Y CHECK, FOUND SHEAR TIE CORRODED AT BS 500C, STR 25L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA070909Stiffener · crackedDURING SCHEDULED 20Y CHECK, FOUND BULKHEAD STIFFENER CRACKED AT BS 1016, RBL 17, WL 209. REPAIRED STIFFENER PER SRM.SDR SWAA070899Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 685, STR 8L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070886Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500B, STR 2L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070888Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500C, STR 8L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070890Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500D, STR 3L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070891Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 559, STR 10L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070892Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 578, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070893Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 578, STR 9L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070894Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 2L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070895Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 9L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070896Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 639, STR 7L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070885Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 5L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070898Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 685, STR 7L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070887Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500C, STR 1. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070900Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 3L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070901Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070902Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 8L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070903Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 10L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070904Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 3L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070905Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 2L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070907Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 390, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070906Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070897Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 685, STR 3L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070889Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500D, STR 1. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070884Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 9R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070882Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 578, STR 11R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070883Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 11R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070910Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 727D, LBL 8. REPAIRED FRAME PER SRM.SDR SWAA070911Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 500B, STR 26L TO 27R. REPAIRED FRAME PER SRM.SDR SWAA070908Crease Beam · corrodedDURING SCHEDULED 20Y CHECK, FOUND CREASE BEAM WEB CORRODED AT 935, RBL 70. REMOVED AND REPLACED WEB PER SRM.SDR SWAA070842Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 559, STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070841Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 578, STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070840Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 578, STR 7R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070839Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 578, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070838Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 9R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070843Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 559, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070836Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 2R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070846Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 520, STR 8R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070835Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 639, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070834Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 685, STR 6R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070832Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 685, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070837Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 7R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070830Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.
Back to Boeing 737-3Q8