N328SW, cancelled Oct 26, 2017
Service difficulty reports · 281
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 = 'N328SW' AND deregistration_id = 'N328SW-2017-10-26' 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 = 'N328SW' AND deregistration_id = 'N328SW-2017-10-26' 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 SWAA084143Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE SKIN CRACKED AT FWD SERVICE DOOR CUTOUT FWD LOWER CORNER. REPAIRED SKIN PER SRM.SDR SWAA084142Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 930 AND BS 945, STR 25R AND STR 24R. REPAIRED SKIN PER SRM.SDR SWAA084141Skin · delaminatedDURING SCHEDULED HC2 CHECK, FOUND RIGHT WING INBOARD FORE FLAP OUTBOARD UPPER SURFACE DELAMINATED. REMOVED AND REPLACED FLAP PER MM.SDR SWAA084140Lens · crackedDURING SCHEDULED HC2 CHECK, FOUND BULLNOSE EMERGENCY EXIT LIGHT LENS CRACKED AT BS 11 ABC. REMOVED AND REPLACED LIGHT LENS PER MM.SDR SWAA084015Slide · out of adjustL1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA083572Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 371, STR 26L. REPAIRED SKIN PER SRM.SDR SWAA082490Stringer Clip · corrodedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CORRODED AT BS 807, STR 27R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080260Sign · looseRIGHT OVERWING EMERGENCY EXIT SIGN LOOSE. SECURED SIGN PER MM.SDR SWAA080205Spoiler · damagedDURING SCHEDULED MV2 CHECK, FOUND RT WING NR 5 GROUND SPOILER ATTACH LUG BROKEN. REMOVED AND REPLACED SPOILER PER MM.SDR SWAA076273Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 503D, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA076275Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 513B, STR 19R. REPAIRED SKIN PER SRM.SDR SWAA076274Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 934, STR 22R. REPAIRED SKIN PER SRM.SDR SWAA073578Mec · erraticDIVERSION / DECLARED EMERGENCY, NR 2 ENG N1 ROLLBACK IND. REMOVED AND REPLACED NR 2 ENG MEC.SDR SWAA073370Pressure Panel · crackedDURING SCHEDULED BRDG CHECK, FOUND LEFT NLG W/W PRESSURE WEB CRACKED AT BS 246, WL 170. REPAIRED PRESSURE WEB PER SWA EA.SDR SWAA073279Stiffener · crackedDURING SCHEDULED BRDG CHECK, FOUND VERTICAL STIFFENER CRACKED AT BS 727, LBL 19. REMOVED AND REPLACED VERTICAL STIFFENER PER SRM.SDR SWAA073259Floorbeam · corrodedDURING SCHEDULED BRDG CHECK, FOUND FLOORBEAM UPPER TEE CAP CORRODED AT BS 986.5, RBL 14 TO LBL 44. R&R FLOORBEAM UPPER TEE CAP PER SRM.SDR SWAA073221Floorbeam · corrodedDURING SCHEDULED BRDG CHECK, FOUND FLOORBEAM CORRODED AT BS 947.5, LBL 53 TO RBL 52. REPAIRED FLOOR BEAM PER SWA EA.SDR SWAA073222Floorbeam · corrodedDURING SCHEDULED BRDG CHECK, FOUND FLOOR BEAM CORRODED AT BS 328, LBL 56 TO RBL 56. REPAIRED FLOOR BEAM PER SWA EA.SDR SWAA073223Stringer Splice · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER SPLICE CRACKED AT BS 360, STR 15L. R&R STRINGER SPLICE PER SRM.SDR SWAA073175Stringer · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER 7L CRACKED AT BS 360. REPAIRED STRINGER PER SRM.SDR SWAA073179Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 344, STR 21L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073178Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 336, STR 21L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073177Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 328, STR 21L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073176Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 312, STR 21L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073172Floorbeam · corrodedDURING SCHEDULED BRDG CHECK, FOUND FLOORBEAM CORRODED AT BS BS 1016, RBL 40 TO LBL 40. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA073174Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 600, STR 13L. REPAIRED FRAME PER SWA EA.SDR SWAA073173Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND BELTFRAME CRACKED AT BS 277, STR 16L. REPAIRED FRAME PER SWA EA.SDR SWAA073098Beltframe · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE BELTFRAME CRACKED AT BS 360, STR 14L. REPAIRED BELTFRAME PER SRM.SDR SWAA073096Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 294, STR 11L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073101Tab · crackedDURING SCHEDULED BRDG CHECK, FOUND RT ELEVATOR TAB CRACKED AT LOWER HINGE CUTOUT. REMOVED AND REPLACED ELEVATOR TAB PER MM.SDR SWAA073095Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA073094Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, STR 20L. REPAIRED FRAME PER SWA EA.SDR SWAA073097Bulkhead · crackedDURING SCHEDULED BRDG CHECK, FOUND AFT PRESSURE BULKHEAD DOME CAP CRACKED AT BS 1016, STR 23R, RBL 1. REPAIRED DOME CAP PER SRM.SDR SWAA073102Structure · crackedDURING SCHEDULED BRDG CHECK, FOUND LEFT WING AILERON TAB DELAMINATED ON OUTBOARD T/E. REMOVED AND REPLACED AILERON TAB PER MM.SDR SWAA073100Pressure Panel · crackedDURING SCHEDULED BRDG CHECK, FOUND NLG LEFT PRESSURE WEB CRACKED AT BS 246, WL 170. REPAIRED PRESSURE WEB PER SWA EA.SDR SWAA073099Pressure Panel · crackedDURING SCHEDULED BRDG CHECK, FOUND NLG RIGHT PRESSURE WEB CRACKED AT BS 246, WL 170. REPAIRED PRESSURE WEB PER SWA EA.SDR SWAA073079Structure · crackedDURING SCHEDULED BRDG CHECK, FOUND FWD CARGO DOOR CRACKED AT LOWER DOOR STOP FITTING NEAR TEE BEAM. REPAIRED DOOR PER SRM.SDR SWAA073080Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA073004Stringer · corrodedDURING SCHEDULED BRDG CHECK, FOUND STRINGER 27L CORRODED AT BS 950. REPAIRED STRINGER PER SRM.SDR SWAA073007Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 663, STR 11R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073006Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 663, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073005Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 294, STR 21L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073003Crease Beam · corrodedDURING SCHEDULED BRDG CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 907 AND BS 927, STR 17L. REMOVED AND REPLACED CREASE BEAM WEB PER SRM.SDR SWAA073002Shear Tie · corrodedDURING SCHEDULED BRDG CHECK, FOUND SHEAR TIE CORRODED AT BS 927, STR 27R. REPAIRED SHEAR TIE PER SRM.SDR SWAA073001Floorbeam · corrodedDURING SCHEDULED BRDG CHECK, FOUND FLOORBEAM CHORD CORRODED AT BS 270 , BL 0. REMOVED AND REPLACED FLOORBEAM CHORD PER SRM.SDR SWAA072916Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 787, STR 24R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072908Skin · crackedDURING SCHEDULED BRDG CHECK, FOUND LEFT WING NR 2 L/E SLAT CRACKED AT OUTBOARD AUX TRACK. REPAIRED SLAT PER SRM.SDR SWAA072913Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 20L. REPAIRED FRAME PER SWA EA.SDR SWAA072910Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE STUB FRAME CRACKED AT RIGHT BS 639, ATTACH FITTING AT NR 4 SEAT TRACK. REMOVED AND REPLACED STUB FRAME PER SRM.SDR SWAA072915Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT LT BS 616, WL 202. REPAIRED FRAME PER TYPICAL REPAIR MANAUL.
Back to N328SW, cancelled Oct 26, 2017