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 SWAA095285Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM CHORD CRACKED BETWEEN BS 659.0 TO BS 673.75, LBL 24.5. REPAIRED CHORD PER EO.SDR SWAA095284Skin · corrodedDURING SCHEDULED 22Y CHECK, FOUND SKIN CORRODED AT BS 500, BETWEEN STR 28L TO STR 28R. REPAIRED SKIN PER EO.SDR SWAA095218Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND SKIN CRACKED AT BS 947, STR 4L. REPAIRED SKIN PER SRM.SDR SWAA095195Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 8L. REMOVED AND REPLACED CLIP PER SI.SDR SWAA095194Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED BETWEEN BS 705 TO BS 715, LBL 24.5. REPAIRED WEB PER EO.SDR SWAA095190Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM WEB CRACKED AT BS 327, RBL 30. REPAIRED WEB PER SRM.SDR SWAA095182Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 727E, BETWEEN STR 13L TO STR 14L. REPAIRED FRAME PER SWA EA.SDR SWAA095181Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND LT WING NR 2 SLAT L/E SKIN CRACKED. REPAIRED SKIN PER SRM.SDR SWAA095180Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 500A, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER EA.SDR SWAA095153Stringer · corrodedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CORRODED BETWEEN BS 480 TO BS 500A, STR 28L. REPAIRED STRINGER PER SRM.SDR SWAA095152Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED BETWEEN BS 710 TO BS 713, BBL 0. REPAIRED WEB PER SRM.SDR SWAA095151Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND SKIN CRACKED AT BS 927, STR 4R. REMOVED AND REPLACED SKIN PER SI.SDR SWAA095150Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 827, STR 4R. REMOVED AND REPLACED CLIP PER SI.SDR SWAA095149Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 787, STR 4R. REMOVED AND REPLACED CLIP PER SI.SDR SWAA095148Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727E, STR 4R. REMOVED AND REPLACED CLIP PER SI.SDR SWAA095147Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 4R. REMOVED AND REPLACED CLIP PER SI.SDR SWAA095146Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED BETWEEN BS 705 TO BS 715, RBL 24.5. REPAIRED WEB PER SI.SDR SWAA095145Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED BETWEEN BS 706 TO BS 713, BBL 0. REPAIRED WEB PER SI.SDR SWAA095102Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER.SDR SWAA095101Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 559, STR 8R. REPAIRED FRAME PER.SDR SWAA095100Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 520, STR 8R. REPAIRED FRAME PER.SDR SWAA095099Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 520, STR 8L. REPAIRED FRAME PER.SDR SWAA095098Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER.SDR SWAA094989Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 1121, STR 2L. REMOVED AND REPLACED CLIP PER BAC DWG.SDR SWAA094865Stringer Splice · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER SPLICE CRACKED AT BS 907, STR 4R. REMOVED AND REPLACED SPLICE PER SRM.SDR SWAA094864Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 16R. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA094863Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 807, STR 4R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094862Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094861Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094836Fitting · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER FITTING CRACKED AT BS 1016, STR 7L. REMOVED AND REPLACED FITTING PER SRM.SDR SWAA094835Stringer · corrodedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CORRODED BETWEEN BS 1016 TO BS 1088, STR 24L. REMOVED AND REPLACED STRINGER SECTION PER SRM.SDR SWAA094776Stringer · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CRACKED AT BS 380, STR 8R. REPAIRED STRINGER PER SRM.SDR SWAA094775Bulkhead · crackedDURING SCHEDULED 22Y CHECK, FOUND VERTICAL BEAM WEB CRACKED AT BS 178, LBL 5.7. REPAIRED WEB PER SRM.SDR SWAA094774Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 847, STR 4R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094773Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 807, STR 4R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094772Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 8R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094771Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094770Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094769Stringer · corrodedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CORRODED AT BS 1040, STR 24L. REPAIRED STRINGER PER SRM.SDR SWAA093315Skin · crackedFUSELAGE SKIN CRACKED AT BS 500B, STR 19R. REPAIRED SKIN PER SRM.SDR SWAA093224Skin · crackedDURING SCHEDULED MV4 CHECK, FOUND SKIN CRACKED AT BS 914, STR 25L. REPAIRED SKIN PER SRM.SDR SWAA093223Skin · crackedDURING SCHEDULED MV4 CHECK, FOUND SKIN CRACKED AT BS 500B, STR 19R. REPAIRED SKIN PER SRM.SDR SWAA093239Door Frame · crackedFWD CARGO DOOR FRAME CRACKED AT BS 500B, STR 19R. REPAIRED FRAME PER SRM.SDR SWAA092610Fan · faultyAIR TURBACK, SMOKE SMELL IN MAIN CABIN. AFTER TURNING THE A/C RECIRC FAN OFF, SMELL BEGAN TO DISSIPATE. REMOVED AND REPLACED A/C RECIRC FAN PER MM.SDR SWAA091882Circuit Card · faultyNOSE GEAR RED LIGHT REMAINED ON AFTER GEAR RETRACTION, CYCLED CIRCUIT BREAKER P6-2-C21 WITH NO EFFECT. CYCLED GEAR DOWN THEN UP AND INDICATIONS RETURNED TO NORMAL. REMOVED AND REPLACED M983 NLG RED LIGHT CARD PER MM.SDR SWAA091533Frame · crackedDURING SCHEDULED SPV CHECK, FOUND AFT CARGO AFT FRAME CLOSURE WEB CRACKED AT BS 847, RBL 38. REPAIRED WEB PER ACO.SDR SWAA091532Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND AFT CARGO DOOR CUTOUT FWD FRAME CRACKED. REPAIRED FRAME PER ACO.SDR SWAA090438Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER SWA EA.SDR SWAA090173Light · inoperativeDURING SCHEDULED MV1 CHECK, FOUND EEPLS LIGHT INOP AT R2 DOOR. RELAMPED LIGHT ASSY PER MM.SDR SWAA085036Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 812, STR 18L. REPAIRED SKIN PER SWA EA.
Back to N328SW, cancelled Oct 26, 2017