N689SW, cancelled Mar 16, 2018
Service difficulty reports · 360
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 = 'N689SW' AND deregistration_id = 'N689SW-2018-03-16' 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 = 'N689SW' AND deregistration_id = 'N689SW-2018-03-16' 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 SWAA098058Battery · dischargedAFT I/B FLASHLIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA097376Floor Support · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 727B, LBL 45.5. REPAIRED CHORD PER ER.SDR SWAA097375Floor Support · crackedDURING SCHEDULED 24Y CHECK, FOUND FLOOR SUPPORT WEB CRACKED BETWEEN BS 706 TO BS 713, RBL 24.5. REPAIRED WEB PER ER.SDR SWAA097132Battery Pack · dischargedDURING SCHEDULED 24Y CHECK, FOUND EMERGENCY EXIT LIGHT BATTERY PACKS INOP. REMOVED AND REPLACED BATTERY PACKS PER MM.SDR SWAA097131Strap · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME STRAP CRACKED AT BS 492, STR 18R TO STR 19R. REPAIRED FRAME PER SRM AND ER.SDR SWAA097130Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, STR 20R TO STR 21R. REPAIRED FRAME PER SRM AND ER.SDR SWAA097129Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 20L TO STR 21L. REPAIRED FRAME PER SRM AND ER.SDR SWAA097128Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, STR 20R TO STR 21R. REPAIRED FRAME PER SRM AND ER.SDR SWAA097127Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 663.75, STR 2R. REPAIRED FRAME PER SRM AND ER.SDR SWAA097126Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, STR 20R TO STR 21R. REPAIRED FRAME PER SRM AND ER.SDR SWAA097125Stringer · corrodedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE STRINGER CORRODED AT BS 460, STR 28R. REPAIRED STRINGER PER ER.SDR SWAA097124Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE LONGITUDINAL FLOORBEAM CRACKED AT BS 710 TO BS 714, BL 0. REPAIRED FLOORBEAM PER ER.SDR SWAA097123Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 859, STR 25L TO STR 26L. REPAIRED SKIN PER ER.SDR SWAA097122Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SKIN CRACKED GROUND AIR CONDITIONING DOOR CUTOUT. REPAIRED SKIN PER ER.SDR SWAA097121Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 515B, STR 8R. REPAIRED SKIN PER EA.SDR SWAA097120Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 525, STR 8R. REPAIRED SKIN PER ER.SDR SWAA097061Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 787, STR 26R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA097060Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 500D, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR SWAA097058Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 500D, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR SWAA097057Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 500C, BETWEEN STR 20R TO STR 21R. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA097056Stringer · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CRACKED AT BS 598, STR 15R. REMOVED AND REPLACED STRINGER PER SRM.SDR SWAA097055Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 5L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA097054Stringer · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CORRODED AT BS 420, STR 28L. REMOVED AND REPLACED STRINGER PER SRM.SDR SWAA097053Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 440, BETWEEN STR 26L TO STR 27L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA097052Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 440, BETWEEN STR 28L TO STR 28R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA097051Stringer Clip · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CORRODED AT BS 793, STR 26R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA097050Web · corrodedDURING SCHEDULED 24Y CHECK, FOUND AFT CARGO BAY BILGE WEB CORRODED AT BS 940, STR 26R. REMOVED AND REPLACED WEB PER DRAWING.SDR SWAA097049Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 907, BETWEEN STR 27L TO STR 27R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA097064Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SHEAR TIE FRAME CRACKED AT BS 867, STR 25L TO STR 26L. REPAIRED FRAME PER SRM.SDR SWAA096935Attach Angle · crackedDURING SCHEDULED 24Y CHECK, FOUND CREASE BEAM WEB ATTACH ANGLE CRACKED AT BS 559, STR 17R. REPAIRED ANGLE PER SRM.SDR SWAA096909Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 277, BETWEEN STR 11R TO STR 10R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA096898Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 15R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096897Door Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND AFT CARGO DOOR CUTOUT AFT FAME CRACKED AT BS 847, RBL 25. REPAIRED FRAME PER SRM.SDR SWAA096879Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 500, BETWEEN STR 27L TO STR 28R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA096878Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 500C, BETWEEN STR 28L TO STR 28R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA096877Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 460, STR 25L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096876Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 927, BETWEEN STR 25L TO STR 26L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA096847Stringer · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CRACKED AT BS 360, STR 5L. REPAIRED STRINGER PER SRM.SDR SWAA096846Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 927, BETWEEN STR 27L TO STR 27R. REPAIRED SHEAR TIE PER SRM.SDR SWAA096834Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 500, BETWEEN STR 27L TO STR 26L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA096833Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 500, BETWEEN STR 28R TO STR 28L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA096832Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 500, BETWEEN STR 27R TO STR 26R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA096831Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND FLOORBEAM WEB CRACKED AT BS 708, LBL 24.8. REPAIRED WEB PER ER.SDR SWAA096824Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727E, STR 16R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096823Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 520, STR 16L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096822Stringer · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CORRODED BS 1010, STR 27L. REPAIRED STRINGER PER SRM.SDR SWAA096821Stringer · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CORRODED BETWEEN BS 1006 TO BS 1010, STR 26R. REPAIRED STRINGER PER SRM.SDR SWAA096817Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 460, STR 16L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096816Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME WEB ANGLE CRACKED AT BS 640, STR 15L. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA096815Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 947, STR 26R. REMOVED AND REPLACED CLIP PER SRM.
Back to N689SW, cancelled Mar 16, 2018