N660SW, cancelled Sep 19, 2016
Service difficulty reports · 531
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 = 'N660SW' AND deregistration_id = 'N660SW-2016-09-19' 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 = 'N660SW' AND deregistration_id = 'N660SW-2016-09-19' 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 SWAA094329Light · corrodedDURING SCHEDULED 24Y CHECK, FOUND LT EEPLS LIGHT CORRODED AT ROW 2. REMOVED AND REPLACED EEPLS PER MM.SDR SWAA094325Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 670, BBL 0.07. REPAIRED BEAM PER EA.SDR SWAA094324Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 669, BBL 0.07. REPAIRED BEAM PER EA.SDR SWAA094323Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 668, BBL 0.07. REPAIRED BEAM PER EA.SDR SWAA094322Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR LOWER HINGE CUTOUT, BS 291, WL 233. REPAIRED SKIN PER SWA EA.SDR SWAA094321Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 706, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA094320Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 661, BL 0. REPAIRED BEAM PER EA.SDR SWAA094303Floorbeam · corrodedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM CORRODED AT BS 675, BBL 0.07. REPAIRED BEAM PER SWA EA.SDR SWAA094302Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR UPPER HINGE CUTOUT, BS 302, WL 234. REPAIRED SKIN PER SWA EA.SDR SWAA094301Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR UPPER HINGE CUTOUT, BS 305, WL 257. REPAIRED SKIN PER SWA EA.SDR SWAA094241Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND CENTER WING BOX FLOORBEAM CRACKED AT BS 727B, LBL 24.5. REPAIRED BEAM PER EA.SDR SWAA094080Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA094058Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 8L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094057Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 807, STR 8L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094029Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 807, STR 15L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094028Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 767, STR 15L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094027Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA094026Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 380, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA093983Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 727B, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA093964Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 847, STR 9R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA093963Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 827, STR 5R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA093915Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 907, STR 8L. REPAIRED CLIP PER SWA EA.SDR SWAA093914Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 847, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA093913Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 767, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA093912Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 727E, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA093911Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 597, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA093910Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 907, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA093909Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA093908Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 767, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA093907Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 727B, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA093831Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA091401Flashlight · inoperativeFWD O/B EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED FLASHLIGHT PER MM.SDR SWAA086730Skin · corrodedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CORRODED AT BS 500D, STR 27L. REPAIRED SKIN PER SRM.SDR SWAA086729Keelbeam · corrodedDURING SCHEDULED SPV CHECK, FOUND RT KEEL BEAM CORRODED AT BETWEEN 500D TO BS 520. REPAIRED BEAM PER SRM.SDR SWAA086642Stringer Clip · corrodedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CORRODED AT BS 500D, STR 27L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA086641Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 520, RBL 28. REPAIRED FRAME PER SRM.SDR SWAA086640Shear Tie · corrodedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO SHEAR TIE CORRODED AT BS 500C, BETWEEN STR 26L TO STR 25L. REPAIRED SHEAR TIE PER SRM.SDR SWAA086586Shear Tie · corrodedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CORRODED AT BS 500C, RBL 18. REPAIRED SHEAR TIE PER SRM.SDR SWAA086534Charger · inoperativeDURING SCHEDULED SPV CHECK, FOUND FWD LT OVER HEAD EMERGENCY EXIT LIGHT INOP. R&R BATTERY CHARGER PER MM.SDR SWAA085743Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 480, STR 17L. REPAIRED SKIN PER SRM.SDR SWAA085710Lens · looseFOUND RT EMERGENCY EXIT LIGHT LENS LOOSE. REPAIRED LENS PER SWA EA.SDR SWAA084683Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 892, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA083926Battery Pack · faultyDURING SCHEDULED MV2 CHECK, RT AFT CABIN EMERGENCY EXIT LIGHTS WILL NOT EXTINGUISH. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA082124Ballast · faultyCREW REPORTED VISIBLE SMOKE AND ELECTRICAL SMELL AT ROW 12 ABC. INSPECTED AND FOUND LIGHT BALLAST AT ROW 12 ABC CAUSE OF SMOKE. REMOVED AND REPLACED LIGHT BALLAST PER MM.SDR SWAA081976Hydraulic Line · kinkedAIRTURN BACK - INFLIGHT HYDRAULIC A-SYSTEM LOW PRESSURE LIGHT ILLUMINATED. REMOVED AND REPLACED SUPPLY HOSE TO A-SYSTEM RESERVOIR PER MM.SDR SWAA076007Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 792, STR 19L. REPAIRED SKIN PER SWA EA.SDR SWAA075486Light · inoperativeDURING SCHEDULED BRDG CHECK, FOUND L1 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA075477Fitting · wornDURING SCHEDULED BRDG CHECK, FOUND LT WING INBOARD GROUND SPOILER OUTBOARD ACTUATOR FITTING WORN. REPAIRED FITTING PER SWA EA.SDR SWAA075481Torque Tube · wornDURING SCHEDULED BRDG CHECK, RT ELEVATOR TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED TORQUE TUBE PER MM.SDR SWAA075482Bolt · wornDURING SCHEDULED BRDG CHECK, LT ELEVATOR TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED BUSHING AND BOLT PER MM.
Back to N660SW, cancelled Sep 19, 2016