N505SW, cancelled Oct 27, 2017
Service difficulty reports · 313
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 = 'N505SW' AND deregistration_id = 'N505SW-2017-10-27' 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 = 'N505SW' AND deregistration_id = 'N505SW-2017-10-27' 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 SWAA104283Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND SKIN CRACKED AT BS 432, STR 17R. REPAIRED SKIN PER EA.SDR SWAA102512Shear Tie · crackedDURING SCHEDULED OTS CHECK, FOUND SHEAR TIE CRACKED AT BS 887, BETWEEN STR 24R TO STR 25R. REPAIRED SHEAR TIE PER SRM.SDR SWAA102511Frame · crackedDURING SCHEDULED OTS CHECK, FOUND FRAME CRACKED AT BS 420, STR 1. REPAIRED FRAME PER SRM.SDR SWAA102510Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 488B, STR 16R. REPAIRED SKIN PER ER.SDR SWAA102509Doubler · crackedDURING SCHEDULED OTS CHECK, FOUND CRACK ON DOUBLER STRAP ON AFT CARGO DOOR OPENING AT LOWER EDGE. REMOVED AND REPLACED DOUBLER PER SRM.SDR SWAA102508Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 424, STR 0. REPAIRED SKIN PER SRM.SDR SWAA102507Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 923, STR 24R. REPAIRED SKIN PER SRM.SDR SWAA102506Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 893, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA102245Skin · crackedDURING SCHEDULED OTS CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 930, STR 21L. REPAIRED SKIN PER SRM.SDR SWAA101708Battery Pack · weakDURING SCHEDULED MV2 CHECK, FOUND L2 DOOR EMERGENCY EXIT LIGHT BATTERY VOLTAGE WEAK. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA101122Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 831, STR 17L. REPAIRED SKIN PER SRM.SDR SWAA100876Battery Pack · dischargedDURING SCHEDULED MV2 CHECK, FOUND EEPLS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA100875Battery Pack · dischargedDURING SCHEDULED MV2 CHECK, FOUND EXTERIOR EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA100874Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED BETWEEN BS 404 TO BS 408, STR 16R. REPAIRED SKIN PER EA.SDR SWAA097608Wire · arcedR1 COCKPIT WINDOW HEAT WIRES ARCED DURING FLIGHT. REMOVED AND REPLACED WINDOW PER MM.SDR SWAA097277Light · inoperativeDURING SCHEDULED MV3 CHECK, FOUND LT AFT EXTERNAL EMERGENCY LIGHT INOP. RELAMPED PER MM.SDR SWAA096512Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND L1 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOP. RELAMPED PER MM.SDR SWAA096305Light · inoperativeDURING SCHEDULED 20Y CHECK, FOUND RT OVERWING EMERGENCY EXIT SIDEWALL LIGHT INOP. REPAIRED LIGHT PER MM.SDR SWAA096304Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER AAR EA.SDR SWAA096303Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER AAR EA.SDR SWAA096302Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER AAR EA.SDR SWAA096277Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 887, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096263Fitting · corrodedDURING SCHEDULED 20Y CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE GIRT BAR BOTH FITTING SPACER PLATES CORRODED. REMOVED AND REPLACED FITTING ASSY PER MM.SDR SWAA096262Fitting · corrodedDURING SCHEDULED 20Y CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE GIRT BAR BOTH FITTING SPACER PLATES CORRODED. REMOVED AND REPLACED FITTING ASSY PER MM.SDR SWAA096261Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FWD CARGO DOOR AFT LOWER CORNER INNER CUTOUT SKIN CRACKED. REPAIRED SKIN PER SRM.SDR SWAA096260Keelbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND RT KEEL BEAM LOWER T-CHORD CORRODED AT BS 485B, STR 28R. REPAIRED BEAM PER SRM.SDR SWAA096259Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FWD CARGO DOOR AFT LOWER CORNER EDGE FRAME CRACKED. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA096121Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 947, STR 26L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096026Panel · looseDURING SCHEDULED 20Y CHECK, FOUND LOWER KEEL BEAM PANEL LOOSE BETWEEN BS 663 TO BS 727. REMOVED AND REPLACED PANEL PER EA.SDR SWAA095983Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 7L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096007Flap · delaminatedDURING SCHEDULED 20Y CHECK, FOUND LT WING I/B FORE FLAP DELAMINATED. REPAIRED FORE FLAP PER MT.SDR SWAA096003Keelbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LT KEEL BEAM CRACKED AT BS 711, LBL 5. REPAIRED BEAM PER SRM.SDR SWAA096002Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 767, STR 22L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096001Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 5R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096000Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 8L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095999Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 827, STR 8L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095998Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 4R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095997Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 4R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095996Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STR 3R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095995Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 559, STR 6L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095994Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 794, BETWEEN STR 25R TO STR 26R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095982Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 6L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095981Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 663, STR 10L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095980Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 5R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095864Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND NR 2 L/E SLAT LOWER SKIN CRACKED. REPAIRED SLAT SKIN PER SRM.SDR SWAA095823Stringer Clip · crackedDURING SCHEDULED 10Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, BETWEEN STR 25L TO STR 26L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095756Stringer · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CRACKED AT BS 440, STR 4L. REMOVED AND REPLACED STRINGER PER SRM.SDR SWAA095755Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 440, STR 1L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095706Wedge · delaminatedDURING SCHEDULED 20Y CHECK, FOUND LT WING NR 1 SLAT I/B WEDGE DELAMINATED. REPAIRED WEDGE PER SRM.SDR SWAA095683Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 8R. REMOVED AND REPLACED CLIP PER SRM.
Back to N505SW, cancelled Oct 27, 2017