N351SW, cancelled Sep 8, 2017
Service difficulty reports · 332
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 = 'N351SW' AND deregistration_id = 'N351SW-2017-09-08' 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 = 'N351SW' AND deregistration_id = 'N351SW-2017-09-08' 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 SWAA110234Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727E, STR 5L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA110233Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 7L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA110232Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 2L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA110231Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 8L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA110230Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA110229Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 5L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA110228Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 6L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA110227Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 685, STR 7L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA110226Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 685, STR 6L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA110225Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 10L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA110224Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500D, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA110223Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500A, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA110222Flap · delaminatedDURING SCHEDULED 22Y CHECK, FOUND RT WING O/B AFT FLAP DELAMINATED. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA110221Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND LT WING NR 3 SLAT SKIN LOWER SURFACED CRACKED. REPAIRED SKIN PER SRM.SDR SWAA110152Shear Tie · corrodedDURING SCHEDULED 22Y CHECK, FOUND SHEAR TIE CORRODED AT BS 787, BBL 0. REPAIRED SHEAR TIE PER SRM.SDR SWAA110151Shear Tie · corrodedDURING SCHEDULED 22Y CHECK, FOUND SHEAR TIE CORRODED AT BS 500B, BETWEEN STR 28L TO STR 28R. REPAIRED SHEAR TIE PER SRM.SDR SWAA110068Shear Tie · corrodedDURING SCHEDULED 22Y CHECK, FOUND SHEAR TIE CORRODED AT BS 807, BETWEEN STR 26R TO STR 25R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA110067Shear Tie · corrodedDURING SCHEDULED 22Y CHECK, FOUND SHEAR TIE CORRODED AT BS 1040, BETWEEN STR 23L TO STR 24L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA110066Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND SKIN CRACKED AT BS 942, STR 22L. REPAIRED SKIN PER ER.SDR SWAA110117Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND SKIN CRACKED BETWEEN BS 800 TO BS 802, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA110116Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND SKIN CRACKED BETWEEN BS 750 TO BS 751, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA105760Skin · crackedDURING SCHEDULED CV CHECK, FOUND SKIN CRACKED AT BS 517D, STR 16L. REPAIRED SKIN PER SRM.SDR SWAA105759Slide · out of adjustDURING SCHEDULED CV CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA104562Lock · malfunctionedDIVERSION - COCKPIT LOCK FAIL LIGHT SMOKED AT ALTITUDE. REMOVED AND REPLACED LOCK ASSY PER MM.SDR SWAA103399Slat · delaminatedDURING SCHEDULED HC2 CHECK, FOUND LT WING NR 2 SLAT DELAMINATED. REMOVED AND REPLACED NR 2 SLAT PER MM.SDR SWAA103398Slide · out of positionDURING SCHEDULED HC2 CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MT.SDR SWAA103397Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR LOWER CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA103396Slat · delaminatedDURING SCHEDULED HC2 CHECK, FOUND RT WING NR 4 L/E SLAT I/B AFT CORNER DELAMINATED. REMOVED AND REPLACED SLAT PER MM.SDR SWAA103395Attach Fitting · damagedDURING SCHEDULED HC2 CHECK, FOUND R1 DOOR AFT SLIDE ATTACH PLATE DAMAGED. REMOVED AND REPLACED PLATE PER MM.SDR SWAA102981Battery · dischargedFWD RT EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA102861Slide · unserviceableL2 DOOR EMERGENCY EVAC SLIDE UNABLE TO READ PRESSURE INDICATOR. REMOVED AND REPLACED SLIDE PER MT.SDR SWAA102799Slide · out of positionL2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MT.SDR SWAA102230Slide · out of adjustL2 DOOR EVAC SLIDE OUT OF ADJUST. RE-ADJUSTED SLIDE PER MM.SDR SWAA102154Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 516C, STR 19R. REPAIRED SKIN PER SRM AND EA.SDR SWAA102153Slide · out of positionDURING SCHEDULED MV2 CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR SWAA101826Actuator · faultyDECLARED EMERGENCY / DIVERSION. AFTER T/O RT MLG UNSAFE RED LIGHT IND. REMOVED AND REPLACED RT MLG UPLOCK ACTUATOR PER MM.SDR SWAA101484Slide · out of positionL2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR SWAA100561Slide · out of positionL2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR SWAA100125Panel · faultyDURING CRUISE FLIGHT AT FL360 RIGHT PACK TRIPPED DURING CHECKLIST FOR THE PACK TRIP OFF, THE LEFT PACK TRIP LIGHT ILLUMINATED, THE CABIN CLIMBED RAPIDLY; DURING THE EMERGENCY DESCENT, BOTH PACKS RESET; MAINTAINED PRESSURIZATION AT 12,000 FT FOR ABOUT 25 MINUTESDR SWAA095649Slide · out of positionL2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR SWAA094942Light · looseEELS LOOSE AT EXIT. SECURED EEPLS PER MM.SDR SWAA092922Hinge Fitting · crackedDURING SCHEDULED 20Y CHECK, FOUND R1 DOOR UPPER HINGE CUTOUT CASTING CRACKED. REMOVED AND REPLACED HINGE CASTING PER SRM.SDR SWAA092837Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER SWA EA.SDR SWAA092836Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SWA EA.SDR SWAA092835Light · inoperativeDURING SCHEDULED 20Y CHECK, FOUND L2 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BULB PER MM.SDR SWAA092834Light · inoperativeDURING SCHEDULED 20Y CHECK, FOUND R2 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BULB PER MM.SDR SWAA092833Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED AT BS 816, STR 25R. REPAIRED SKIN PER SWA EA.SDR SWAA092696Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 291.5, WL 258 RT SIDE. REPAIRED FRAME PER SWA EA.SDR SWAA092565Strip · damagedDURING SCHEDULED 22Y CHECK, FOUND MID TO AFT CABIN EEPLS STRIP DAMAGED. REMOVED AND REPLACED EEPLS PER MM.SDR SWAA092526Door Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO DOOR LOWER FWD FRAME CRACKED. REMOVED AND REPLACED DOOR PER MM.
Back to N351SW, cancelled Sep 8, 2017