N335SW, cancelled Jan 3, 2018
Service difficulty reports · 389
Matched to this aircraft by N-number and event date, checked against the reported serial number, make and model. Newest first.
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 n_number = 'N335SW' AND deregistration_id = 'N335SW-2018-01-03' 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 n_number = 'N335SW' AND deregistration_id = 'N335SW-2018-01-03' 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 SWAA082429Floorbeam · crackedDURING SCHEDULED DAL CHECK, FOUND FLOORBEAM WEB CRACKED AT BS 707, RBL 24.82. REPAIRED WEB PER SWA EA.SDR SWAA082430Stringer Clip · crackedDURING SCHEDULED DAL CHECK, FOUND STRINGER CLIP CRACKED AT BS 294.5, STR 7L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA082377Floorbeam · crackedDURING SCHEDULED BRDG CHECK, FOUND FLOORBEAM CRACKED AT BS 667, LBL 24.75. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA082372Bulkhead · crackedDURING SCHEDULED BRDG CHECK, FOUND VERTICAL BEAM WEB CRACKED AT BS 178, RBL 5.7, WL 187. REPAIRED WEB PER SWA EA.SDR SWAA082373Floorbeam · crackedDURING SCHEDULED BRDG CHECK, FOUND FLOORBEAM CRACKED AT BS 665, LBL 24.75. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA082374Floorbeam · crackedDURING SCHEDULED BRDG CHECK, FOUND FLOORBEAM CRACKED AT BS 670, LBL 24.75. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA082375Floorbeam · crackedDURING SCHEDULED BRDG CHECK, FOUND FLOORBEAM CRACKED AT BS 665, RBL 24.50. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA082376Floorbeam · crackedDURING SCHEDULED BRDG CHECK, FOUND FLOORBEAM CRACKED AT BS 663, LBL 24.75. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA082341Crease Beam · crackedDURING SCHEDULED BRDG CHECK, FOUND CREASE BEAM WEB CRACKED BETWEEN BS 540 AND BS 560, STR 17R. REMOVED AND REPLACED CREASE BEAM WEB PER SWA EA.SDR SWAA082342Floorbeam · crackedDURING SCHEDULED BRDG CHECK, FOUND FLOORBEAM WEB CRACKED AT BS 708, RBL 24.82. REPAIRED WEB PER SWA EA.SDR SWAA082343Floorbeam · crackedDURING SCHEDULED BRDG CHECK, FOUND FLOORBEAM WEB CRACKED AT BS 709, RBL 24.82. REPAIRED WEB PER SWA EA.SDR SWAA082344Beltframe · crackedDURING SCHEDULED BRDG CHECK, FOUND BELTFRAME CRACKED AT BS 616, RBL 65. REPAIRED FRAME PER SRM.SDR SWAA082294Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 294.5, STR 10L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA082295Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 294.5, STR 8L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA082296Bulkhead · crackedDURING SCHEDULED BRDG CHECK, FOUND VERTICAL BEAM WEB CRACKED AT BS 178, LBL 17, WL 225. REPAIRED WEB PER SRM.SDR SWAA082293Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 787, STR 8R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA082297Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA082298Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA082236Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA082237Bulkhead · crackedDURING SCHEDULED BRDG CHECK, FOUND BULKHEAD WEB CRACKED AT BS 178, RBL 10, WL 234. REPAIRED WEB PER SRM.SDR SWAA082238Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 867, STR 8R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA082167Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 25L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA082168Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 5L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA082169Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 500D, STR 8L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA082170Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA082171Bulkhead · crackedDURING SCHEDULED BRDG CHECK, FOUND BULKHEAD WEB CRACKED AT BS 178, LBL 7 TO RBL 4.5, WL 198 TO WL 206. REPAIRED WEB PER SRM.SDR SWAA082119Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 500, STR 8L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA082068Stiffener · crackedDURING SCHEDULED BRDG CHECK, FOUND RADIAL STIFFENER CRACKED AT BS 1016, 6 0'CLOCK POSITION. REPAIRED STIFFENER PER BOEING DRAWING.SDR SWAA082066Crease Beam · corrodedDURING SCHEDULED BRDG CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 907 AND BS 927, STR 17L. REMOVED AND REPLACED WEB PER SRM.SDR SWAA082067Keelbeam · corrodedDURING SCHEDULED BRDG CHECK, FOUND KEEL BEAM CORRODED AT BS 540, RBL 6.50. REPAIRED KEEL BEAM PER SRM.SDR SWAA082065Stiffener · crackedDURING SCHEDULED BRDG CHECK, FOUND LONGITUDINAL FLOORBEAM VERTICAL STIFFENER CRACKED AT BS 639, LBL 46. REMOVED AND REPLACED STIFFENER PER SWA EA.SDR SWAA082064Stiffener · crackedDURING SCHEDULED BRDG CHECK, FOUND LONGITUDINAL FLOORBEAM VERTICAL STIFFENER CRACKED AT BS 639, RBL 46. REMOVED AND REPLACED STIFFENER PER SWA EA.SDR SWAA082063Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 21R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA082062Fitting · corrodedDURING SCHEDULED BRDG CHECK, FOUND LEFT HORIZONTAL STABILIZER CENTER SECTION FITTING BEARING HOUSING CORRODED. REPAIRED FITTING PER SWA EA.SDR SWAA082045Bulkhead · crackedDURING SCHEDULED BRDG CHECK, FOUND VERTICAL BEAM WEB CRACKED AT BS 178, RBL 17.1. REPAIRED WEB PER SRM.SDR SWAA082029Shear Tie · crackedDURING SCHEDULED BRDG CHECK, FOUND SHEAR TIE CRACKED AT BS 540, STR 28L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA081931Door Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND R1 DOOR CUTOUT LOWER FWD CORNER STUB FRAME CRACKED. REPAIRED FRAME PER SRM.SDR SWAA081864Frame · corrodedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 847, STR 27R. REPAIRED FRAME PER ACO.SDR SWAA080398Light · inoperativeDURING SCHEDULED SPV CHECK, FOUND R1 DOOR EMERGENCY EXIT EXTERIOR LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA080375Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 912, STR 24R. REPAIRED SKIN PER SRM.SDR SWAA071303Lens · crackedDURING SCHEDULED C2 CHECK, FOUND EMERGENCY EXIT LIGHT LENS CRACKED ABOVE AFT F/A'S SEAT. REMOVED AND REPLACED LIGHT LENS.SDR SWAA071298Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500C, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA071297Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500C, STR 19R. REPAIRED SKIN PER SRM.SDR SWAA071008Battery Pack · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND R1 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA065064Window · arcedR1 COCKPIT WINDOW ARCED AND CRACKED. REMOVED AND REPLACED R1 COCKPIT WINDOW ASSY AND HEAT CONTROLLER PER MM.SDR SWAA064994Lamp · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND R1 DOOR EMERGENCY EXIT EXTERIOR LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA064509Glowstrip · wornDURING SCHEDULED C1 CHECK, FOUND EEPLS PHOTOLUMINESCENT STRIP DAMAGED BETWEEN ROWS 6 AND 10. REMOVED AND REPLACED STRIP PER MM.SDR SWAA064153Slide · dislodgedL1 DOOR EMERGENCY EVAC SLIDE FELL OUT, DID NOT DEPLOY. INSTALLED EVAC SLIDE PER MM.SDR SWAA063815Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 374, STR 19R. REPAIRED SKIN PER SRM.SDR SWAA062958Light · crackedDURING SCHEDULED C4 CHECK, FOUND LOWER EMERGENCY EXIT LIGHT CRACKED AT R1 DOOR. REMOVED AND REPLACED LIGHT ASSY PER MM.
Back to N335SW, cancelled Jan 3, 2018