N342SW, cancelled Oct 26, 2017
Service difficulty reports · 250
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 = 'N342SW' AND deregistration_id = 'N342SW-2017-10-26' 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 = 'N342SW' AND deregistration_id = 'N342SW-2017-10-26' 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 SWAA102473Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 729E, STR 19R. REPAIRED SKIN PER AAR EA.SDR SWAA102472Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 510D, STR 15L. REPAIRED SKIN PER AAR EA.SDR SWAA102290Skin · crackedDURING SCHEDULED CV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727D+2, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA102289Skin · crackedDURING SCHEDULED CV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 747+17, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA102288Skin · crackedDURING SCHEDULED CV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 787+12, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA102287Skin · crackedDURING SCHEDULED CV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727E+2, STR 19R. REPAIRED SKIN PER SRM.SDR SWAA102286Skin · crackedDURING SCHEDULED CV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500D+10, STR 15L. REPAIRED SKIN PER SRM.SDR SWAA100660Flap · delaminatedDURING SCHEDULED MV2 CHECK, FOUND RT WING O/B AFT FLAP DELAMINATED. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA097595Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 759, STR 18L. REPAIRED SKIN PER EA.SDR SWAA097594Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 803, STR 18L. REPAIRED SKIN PER EA.SDR SWAA094212Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA093229Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND AFT EMERGENCY EXIT SIGNS BULBS INOP. RELAMPED PER MM.SDR SWAA092296Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 934, STR 23R. REPAIRED SKIN PER SWA EA.SDR SWAA086977Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 420, LBL 3. REPAIRED SKIN PER SWA EA.SDR SWAA086976Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 430, RBL 2. REPAIRED SKIN PER SWA EA.SDR SWAA086916Bear Strap · corrodedDURING SCHEDULED 20Y CHECK, FOUND BEAR STRAP SKIN CORRODED AT BS 967, STR 27L. REPAIRED SKIN PER SRM.SDR SWAA086915Stringer · corrodedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CORRODED AT BS 967, STR 27L, LBL 3. REPAIRED STRINGER PER SRM.SDR SWAA086728Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND L1 DOOR SKIN CUTOUT CRACKED AT BS 305, BELOW WL 236. REPAIRED SKIN PER SWA EA.SDR SWAA086727Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 660, BL 0. REPAIRED BEAM PER SI.SDR SWAA086726Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT E/E EXHAUST PORT OPENING AT BS 379, LBL 2, STR 18R. REPAIRED SKIN PER SWA EA.SDR SWAA086585Beam · corrodedDURING SCHEDULED 20Y CHECK, FOUND LT KEEL BEAM CORRODED AT BS 545. REPAIRED BEAM PER SRM.SDR SWAA086578Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 291, STR 17R. REPAIRED FRAME PER SWA EA.SDR SWAA086567Keelbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LT KEEL BEAM CRACKED AT O/B EDGE, BS 541. REPAIRED BEAM PER SWA EA.SDR SWAA086566Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND L1 DOOR SKN CRACKED AT BS 305, WL 236. REPAIRED SKIN PER SWA EA.SDR SWAA086533Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS. 727D, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA086532Keelbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LT KEELBEAM CRACKED BETWEEN BS 500C TO BS 542. REPAIRED BEAM PER SRM.SDR SWAA086531Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS. 520, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA086530Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS. 500B, STR 8L. R&R CLIP PER SRM.SDR SWAA086264Keelbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND KEEL BEAM CORRODED BETWEEN BS 663 TO BS 727. REPAIRED BEAM PER SWA EA.SDR SWAA086263Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM CHORD CRACKED AT BS 665, BL 0. REPAIRED CHORD PER SI.SDR SWAA086262Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM CHORD CRACKED AT BS 667, BL 0. REPAIRED CHORD PER SI.SDR SWAA086261Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 480, STR 8R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA086260Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 727A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA086259Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 400, BETWEEN STR 9R TO STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086258Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 480, BETWEEN STR 9R TO STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086257Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 747, BETWEEN STR 9R TO STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086256Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 907, BETWEEN STR 9R TO STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086255Skin · corrodedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CORRODED AT BS 867, STR 26R. REPAIRED SKIN PER SWA EA.SDR SWAA086242Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, BETWEEN STR 9R TO STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086241Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, BETWEEN STR 9R TO STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086161Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR SWAA086160Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BETWEEN BS 294 TO BS 299, STR 18R. REPAIRED SKIN PER SWA EA.SDR SWAA086105Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM CHORD CRACKED AT BS 665, LBL 24. REPAIRED CHORD PER EA.SDR SWAA086104Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 380, STR 16R. REPAIRED FRAME PER SRM.SDR SWAA086091Floorbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM CHORD CRACKED AT BS 661, LBL 24. REPAIRED CHORD PER EA.SDR SWAA086090Floorbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM CHORD CRACKED AT BS 665, LBL 24. REPAIRED CHORD PER EA.SDR SWAA086089Floorbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM CHORD CRACKED AT BS 669, LBL 24. REPAIRED CHORD PER EA.SDR SWAA086088Floorbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM CHORD CORRODED AT BS 673, RBL 24. REPAIRED CHORD PER EA.SDR SWAA086028Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 739, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA082676Skin · crackedDURING SCHEDULED MV4 CHECK, FOUND FUSELAGE SKIN CRACKED AT AFT ENTRY DOOR CUTOUT LOWER AFT CORNER. REPAIRED SKIN PER SWA EA.
Back to N342SW, cancelled Oct 26, 2017