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 SWAA091958Shear Tie · crackedDURING SCHEDULED 22Y CHECK, FOUND SHEAR TIE CRACKED AT BS 277, BETWEEN STR 10R TO STR 11R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA091957Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED BS 277, STR 11R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA091956Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED BS 277, STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA091940Shear Tie · crackedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CRACKED AT BS 639, STR 17R. REPAIRED SHEAR TIE PER SRM.SDR SWAA091939Bear Strap · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE BEARSTRAP SKIN CRACKED AT L1 DOOR UPPER HINGE CUTOUT, BETWEEN BS 303 TO BS 304, BETWEEN BS WL 256 TO WL 258. REPAIRED SKIN PER AAR EA.SDR SWAA091938Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 663, LBL 24. REPAIRED BEAM PER AAR EA.SDR SWAA091937Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 344, STR 11R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA091936Crease Beam · crackedDURING SCHEDULED 24Y CHECK, FOUND RT CREASE BEAM WEB CRACKED BETWEEN BS 639 TO BS 664. REPAIRED BEAM PER SRM.SDR SWAA091935Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA091934Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND FLOORBEAM CRACKED AT BS 663, LBL 24. REPAIRED BEAM PER AAR EA.SDR SWAA091751Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND RADIO ALTIMETER BELLY SKIN CUTOUT CRACKED AT BS 410. REPAIRED SKIN PER BOEING SB AND EA.SDR SWAA091699Stringer · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CRACKED AT BS 359, STR 16L. REPAIRED STRINGER PER ACO.SDR SWAA091698Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED BETWEEN BS 663 TO BS 669, BBL 0. REPAIRED BEAM PER SRM.SDR SWAA091603Stringer · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CORRODED AT BS 540, STR 27R. REPAIRED STRINGER PER SRM.SDR SWAA091568Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND SKIN CRACKED AT E&E EQUIPT COMPT EXHAUST CUTOUT, BETWEEN BS 360 TO BS 380. REPAIRED SKIN PER SWA EA.SDR SWAA091567Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA091566Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA091565Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 360, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA091564Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA091563Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 886, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA091502Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 907, BETWEEN STR 25L TO STR 26L. REPAIRED SHEAR TIE PER SRM.SDR SWAA2012110909193Skin · crackedSKIN CRACKED AT BS 446, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA2012110909192Skin · crackedSKIN CRACKED AT BS 446, STR 16R. REPAIRED SKIN IAW EO AND EA.SDR SWAA091710Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 446, STR 16R. REPAIRED SKIN PER SWA EA.SDR SWAA091494Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM LOWER CHORD CRACKED AT BS 709, RBL 24. REPAIRED BEAM PER AAR EA.SDR SWAA091483Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 708, RBL 24. REPAIRED WEB PER AAR EA.SDR SWAA091468Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CHORD CRACKED AT BS 616, RBL 65. REPAIRED CHORD PER SRM.SDR SWAA091467Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 747, STR 27L. REPAIRED SHEAR TIE PER SRM.SDR SWAA091445Shear Tie · corrodedDURING SCHEDULED 14Y CHECK, FOUND SHEAR TIE CORRODED AT BS 827, STR 26R. REPAIRED SHEAR TIE PER SRM.SDR SWAA091444Shear Tie · corrodedDURING SCHEDULED 14Y CHECK, FOUND SHEAR TIE CORRODED AT BS 747, STR 27R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA091443Shear Tie · corrodedDURING SCHEDULED 14Y CHECK, FOUND SHEAR TIE CORRODED AT BS 727C, BETWEEN STR 27R TO STR 26R. REPAIRED SHEAR TIE PER SRM.SDR SWAA091439Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 767, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA091438Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 727D, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA091437Stringer · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CORRODED AT BS 787, STR 25L. REPAIRED STRINGER PER SRM.SDR SWAA091389Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 447, STR 16R. REPAIRED SKIN PER SWA EA.SDR SWAA091388Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 486, STR 16R. REPAIRED SKIN PER SWA EA.SDR SWAA091386Light · brokenDURING SCHEDULED MV2 CHECK, FOUND L1 DOOR EMERGENCY EXIT LIGHT BROKEN. REMOVED AND REPLACED LIGHT PER MM.SDR SWAA091297Wire · damagedDURING SCHEDULED HC2 CHECK, FOUND EMERGENCY EXIT LIGHT INOP AT ROW 19 DEF. REPAIRED LIGHT WIRES PER MM.SDR SWAA091296Shear Tie · corrodedDURING SCHEDULED HC2 CHECK, FOUND SHEAR TIE CORRODED AT BS 847, STR 27L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA091295Bear Strap · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE SKIN BEAR STRAP CRACKED AT L1 DOOR CUTOUT, BS 304.40, WL 261.63. REPAIRED SKIN PER ER.SDR SWAA091309Shear Tie · corrodedDURING SCHEDULED SPECIAL VISIT CHECK, FOUND SHEAR TIE CORRODED AT BS 847, STR 27L. REPAIRED SHEAR TIE PER SRM.SDR SWAA091270Skin · crackedDURING SCHEDULED SPECIAL VISIT CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 502, STR 18R. REPAIRED SKIN PER SRM.SDR SWAA091288Stringer · corrodedDURING SCHEDULED SPECIAL VISIT CHECK, FOUND CORRODED STRINGER 21R, BS 727D. REPAIRED STRINGER PER SRM.SDR SWAA091176Light · inoperativeDURING SCHEDULED SPV CHECK, FOUND R2 DOOR LOWER EMERGENCY EXIT LIGHT BULBS INOP. RELAMPED PER MM.SDR SWAA091175Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 887, STR 9L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA091174Crease Beam · corrodedDURING SCHEDULED 24Y CHECK, FOUND LT CREASE BEAM WEB CORRODED BETWEEN BS 747 TO BS 767. REPAIRED BEAM PER SRM.SDR SWAA091153Slat · delaminatedDURING SCHEDULED 24Y CHECK, FOUND LT WING NR 3 SLAT O/B EDGE DELAMINATED. REPAIRED SLAT PER MM.SDR SWAA091114Stringer · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CORRODED AT BS 827, STR 27R. REPAIRED STRINGER PER SRM.SDR SWAA091080Hook · looseR1 DOOR EMERGENCY EVAC SLIDE GIRT BAR FWD RETAINING HOOK LOOSE. SECURED HOOK PER MM.SDR SWAA091063Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 867 STR 1. REMOVED AND REPLACED CLIP PER SRM.
Back to Boeing 737-3Q8