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 SWAA113683Stringer · corrodedDURING SCHEDULED 26Y CHECK FOUND, STRINGER CORRODED BETWEEN BS 350-357, STR 24R. REPAIRED STRINGER PER SRM.SDR SWAA113682Cargo Track · corrodedDURING SCHEDULED 26Y CHECK FOUND, AFT CARGO RAIL CORRODED AT BS 859, LBL 3. REPAIRED RAIL PER EA.SDR SWAA113681Skin · crackedDURING SCHEDULED 26Y CHECK FOUND, SKIN CORRODED BETWEEN BS 727B+6 TO BS 727C+14, BETWEEN STR 23L TO STR 25L. REMOVED AND REPLACED SKIN PER SRM.SDR SWAA113680Floorbeam · crackedDURING SCHEDULED 26Y CHECK FOUND, LONGITUDINAL FLOORBEAM CRACKED AT BS 727B, LBL 45.5. REPAIRED BEAM PER ER.SDR SWAA113679Skin · delaminatedDURING SCHEDULED 26Y CHECK FOUND, LT WING NR 4 SPOILER LOWER SURFACE DELAMINATED. REMOVED AND REPLACED SPOILER PER MM.SDR SWAA113678Skin · crackedDURING SCHEDULED 26Y CHECK FOUND, SKIN CRACKED AT BS 373, STR 25L. REPAIRED SKIN PER SRM.SDR SWAA113677Skin · crackedDURING SCHEDULED 26Y CHECK FOUND, SKIN CRACKED AT BS 373, STR 26L. REPAIRED SKIN PER SRM.SDR SWAA113676Skin · crackedDURING SCHEDULED 26Y CHECK FOUND, SKIN CRACKED AT BS 357, STR 22R. REPAIRED SKIN PER SRM.SDR SWAA113675Skin · crackedDURING SCHEDULED 26Y CHECK FOUND, SKIN CRACKED AT BS 755, STR 22L. REPAIRED SKIN PER SRM.SDR SWAA111671Slide · out of positionDURING SCHEDULED OTS CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MT.SDR SWAA111670Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 514D, STR 16L. REPAIRED SKIN PER EA.SDR SWAA111815Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND CRACK IN FUSELAGE AT STA 500D +14, STR 16L, ONE INCH FROM UNDER SKIN DOUBLER. REPAIR SKIN PER SRM.SDR SWAA111538Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND SKIN CRACKED AT BS 887 + 13, STR 25L. REPAIRED SKIN PER SRM.SDR SWAA111447Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND R1 DOOR OUTER SKIN CORNER CRACKED AT BS 300, WL 274. REPAIRED SKIN PER SRM.SDR SWAA111446Lens · looseDURING SCHEDULED HC2 CHECK, FOUND OVERHEAD EMERGENCY EXIT LIGHT LENS LOOSE AT ROW 2. REMOVED AND REPLACED LENS PER MM.SDR SWAA111427Actuator · faultyAFTER LANDING GEAR RETRACTION ON TAKEOFF, RED LEFT GEAR LIGHT AND GREEN LEFT GEAR LIGHT REMAINED ILLUMINATED. RECYCLED GEAR RETRACTION IN UP AND OFF POSITION STILL SHOWED SAME LEFT GEAR LIGHTS AS BEFORE. REMOVED AND REPLACED LT MLG UPLOCK ACTUATOR PER MM.SDR SWAA111178Circuit Card · faultyLT MLG RED UNSAFE LIGHT INDICATION, RECYCLED GEAR AND LIGHT WENT OUT. GEAR EXTENDED NORMALLY. REMOVED AND REPLACED M986 PC CARD PER MM.SDR SWAA110953Stringer · crackedDURING SCHEDULED MV1 CHECK, FOUND STRINGER CRACKED AT BS 500C, STR 19R. REMOVED AND REPLACED STRINGER PER EA.SDR SWAA110952Battery Pack · dischargedDURING SCHEDULED MV1 CHECK, FOUND BATTERY PACK INOP AT ROW 17. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA110852Skin · crackedDURING SCHEDULED MV3 CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR UPPER HINGE CUTOUT AT LOWER AFT CORNER. REPAIRED SKIN PER SRM.SDR SWAA111060Skin · crackedDURING SCHEDULED MV3 CHECK, FOUND L2 DOOR LOWER GUIDE ARM CUTOUT CRACKED. REMOVED AND REPLACED L1 DOOR PER MM.SDR SWAA106970Flap · delaminatedDURING SCHEDULED SPV CHECK, FOUND LT WING I/B FORE FLAP DELAMINATED. REPAIRED FORE FLAP PER MM.SDR SWAA106950Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 500C, BETWEEN STR 20L TO STR 21L. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA106949Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 500D, BETWEEN STR 20R TO STR 21R. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA106948Skin · delaminatedDURING SCHEDULED SPV CHECK, FOUND LT WING I/B FORE FLAP UPPER SURFACE DELAMINATED. REPAIRED FORE FLAP PER SRM.SDR SWAA106947Skin · delaminatedDURING SCHEDULED SPV CHECK, FOUND RT WING I/B FORE FLAP UPPER SURFACE DELAMINATED. REPAIRED FORE FLAP PER SRM.SDR SWAA106946Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 734E, STR 19L. REMOVED AND REPLACED SKIN PER EA.SDR SWAA104819Compressor · stalledINFLIGHT SHUTDOWN/DIVERSION/DECLARED EMERGENCY. FL 330 CRUISE FLT - MULTIPLE COMPRESSOR STALL (LOUD BANGS) ENGINE GAUGES NR 1 FLUX. POWER IDLE COMPRESSOR STALL STOP. AT IDLE ENGINE SHUT ITSELF OFF. REMOVED AND REPLACED NR 1 ENGINE PER MT.SDR SWAA104293Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND SKIN CRACKED AT BS 518, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA104294Lens · crackedDURING SCHEDULED HC1 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE LENS CRACKED. REMOVED AND REPLACED LENS PER MM.SDR SWAA101712Sign · damagedDURING SCHEDULED MV2 CHECK, FOUND R2 DOOR LOWER CORNER EMERGENCY EXIT SIGN DAMAGED. REMOVED AND REPLACED SIGN PER MM.SDR SWAA100292Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND SKIN CRACKED AT BS 773, STR 18L. REPAIRED SKIN PER EA.SDR SWAA100291Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND SKIN CRACKED AT BS 786, STR 19L. REPAIRED SKIN PER EA.SDR SWAA100290Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND SKIN CRACKED AT BS 515D, STR 15L. REPAIRED SKIN PER EA.SDR SWAA098134Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND LT EMERGENCY EXIT LIGHT INOP. RELAMPED PER MM.SDR SWAA096567Control Rod · corrodedDURING SCHEDULED CV CHECK, FOUND RT ELEVATOR TAB CONTROL RODS CORRODED. REMOVED AND REPLACED ROD ASSY PER EA.SDR SWAA096566Control Rod · corrodedDURING SCHEDULED CV CHECK, FOUND LT ELEVATOR TAB CONTROL RODS CORRODED. REMOVED AND REPLACED ROD ASSY'S PER EA.SDR SWAA096565Light · crackedDURING SCHEDULED CV CHECK, FOUND LT OVERWING EMERGENCY EXIT LIGHT CRACKED AT ROW 2. REMOVED AND REPLACED LIGHT PER MM.SDR SWAA096564Light · crackedDURING SCHEDULED CV CHECK, FOUND RT EMERGENCY EXIT LIGHT CRACKED AT ROW 2. REMOVED AND REPLACED LIGHT PER MM.SDR SWAA095265Cover · missingR1 DOOR EMERGENCY EXIT COVER MISSING. INSTALLED COVER PER MM.SDR SWAA094706Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 980, STR 21L. REPAIRED SKIN PER ER.SDR SWAA094636Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 770, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA094635Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 760, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA094634Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 740E, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA094633Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 980, STR 21L. REPAIRED SKIN PER SRM.SDR SWAA094346Floorbeam · corrodedDURING SCHEDULED 24Y CHECK, FOUND CENTER WING BOX LONGITUDINAL FLOORBEAM CORRODED AT BS 670, BBL 0.07. REPAIRED BEAM PER EA.SDR SWAA094345Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR LOWER HINGE CUTOUT, BS 304, WL 239. REPAIRED SKIN PER EA.SDR SWAA094344Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 662, BBL 0.07. REPAIRED BEAM PER EA.SDR SWAA094343Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR LOWER HINGE CUTOUT, BS 304, WL 234. REPAIRED SKIN PER SRM.SDR SWAA094330Light · corrodedDURING SCHEDULED 24Y CHECK, FOUND RT EEPLS LIGHT CORRODED AT ROW 4. REMOVED AND REPLACED EEPLS PER MM.
Back to N660SW, cancelled Sep 19, 2016