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 SWAA092457Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 787, STR 17L. REPAIRED SKIN PER SRM.SDR SWAA091136Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND OVERWING EMERGENCY EXIT LIGHT INOP. RELAMPED PER MM.SDR SWAA091053Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 520, STR 15L. REPAIRED SKIN PER SWA EA.SDR SWAA086167Flap · delaminatedDURING SCHEDULED HC1 CHECK, FOUND LT WING O/B AFT FLAP DELAMINATED. REMOVED AND REPLACED FLAP PER MM.SDR SWAA085199Lens · missingDURING SCHEDULED MV1 CHECK, FOUND FWD EMERGENCY FLOOR LIGHT LENS MISSING. INSTALLED LENS PER MM.SDR SWAA083512Fuse · faultyON APPROACH INTO AUS T/E FLAPS INDICATED 30 DEGREES, NO L/E DEVICES DEPLOYED. CYCLED FLAPS, ON SECOND APPROACH NO L/E DEVICES. REMOVED AND REPLACED L/E HYDRAULIC FUSES PER MM.SDR SWAA083071Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 300, STR 19R. REPAIRED SKIN PER SRM.SDR SWAA082869Pressure Panel · crackedDURING SCHEDULED BRDG CHECK, FOUND BEADED PRESSURE WEB CRACKED AT BS 663, BETWEEN RBL 40 AND LBL 31. REPAIRED PRESSURE WEB PER SRM.SDR SWAA082792Stiffener · crackedDURING SCHEDULED BRDG CHECK, FOUND VERTICAL STIFFENER CRACKED AT BS 178, RBL 5.7, WL 185. REPAIRED STIFFENER PER SWA EA.SDR SWAA082739Door Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FWD SERVICE DOOR CUTOUT UPPER FWD CORNER STUB FRAME CRACKED AT UPPER STOP FITTING. REMOVED AND REPLACED STUB FRAME PER SRM.SDR SWAA082723Stringer · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER 3L CRACKED AT BS 663. REPAIRED STRINGER PER SRM.SDR SWAA082721Stringer · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER 2R CRACKED AT BS 663. REPAIRED STRINGER PER SRM.SDR SWAA082722Stringer · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER 2L CRACKED AT BS 663. REPAIRED STRINGER PER SRM.SDR SWAA082673Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 20R. REPAIRED FRAME PER SWA EA.SDR SWAA082672Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 328, STR 20R. REPAIRED FRAME PER SRM.SDR SWAA082645Stiffener · crackedDURING SCHEDULED BRDG CHECK, FOUND VERTICAL STIFFENER CRACKED AT BS 320, STR 21L. REMOVED AND REPLACED STIFFENER PER BOEING DRAWING.SDR SWAA082646Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 7R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA082647Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 707, STR 6R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA082648Stiffener · crackedDURING SCHEDULED BRDG CHECK, FOUND VERTICAL TEE CHORD CRACKED AT BS 178, LBL 5.7, WL 184. REPAIRED CHORD PER SRM.SDR SWAA082629Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA082600Bulkhead · corrodedDURING SCHEDULED BRDG CHECK, FOUND AFT PRESSURE BULKHEAD WEB CORRODED AT BS 1016, BL 0. REPAIRED WEB PER ACO.SDR SWAA082609Skin · crackedDURING SCHEDULED BRDG CHECK, FOUND AFT CARGO DOOR SKIN CRACKED AT DOOR HANDLE CUTOUT. REPAIRED SKIN PER SWA EA.SDR SWAA082610Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA082608Stringer · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER 8L CRACKED AT BS 500A. REPAIRED STRINGER PER SRM.SDR SWAA082607Stringer · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER 8L CRACKED AT BS 500B. REPAIRED STRINGER PER SRM.SDR SWAA082606Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA082605Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 663, STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA082604Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 500C, STR 8L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA082603Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 500B, STR 8L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA082602Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 500A, STR 8L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA082601Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 663, STR 10L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA082599Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 597, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA082598Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA082597Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA082596Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA082595Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA082594Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 707, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA082593Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 294.5, STR 3L. REPAIRED FRAME PER SWA EA.SDR SWAA082611Stiffener · crackedDURING SCHEDULED BRDG CHECK, FOUND CENTER FUEL TANK VERTICAL STIFFENER CRACKED AT STA 547, RBL 57. REMOVED AND REPLACED STIFFENER PER SRM.SDR SWAA082592Door Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FWD SERVICE DOOR CUTOUT AFT FRAME CRACKED AT LOWER DOOR STOP. REMOVED AND REPLACED FRAME PER BOEING DRAWING.SDR SWAA082525Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA082512Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA082513Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 312, STR 21L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA082514Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 328, STR 21L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA082515Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 335, STR 21L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA082461Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA082462Skin · damagedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE SKIN CREASED AT BS 787 TO BS 790, STR 27R. REPAIRED SKIN PER SRM.SDR SWAA082431Crease Beam · corrodedDURING SCHEDULED DAL CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 291 TO BS 332, STR 17R. REMOVED AND REPLACED WEB PER SRM.SDR SWAA082427Frame · corrodedDURING SCHEDULED DAL CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 940, STR 17R. REPAIRED FRAME PER SRM.SDR SWAA082428Frame · crackedDURING SCHEDULED DAL CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 16R. REPAIRED FRAME PER SWA EA.
Back to N335SW, cancelled Jan 3, 2018