N323SW, cancelled Jul 17, 2013
Service difficulty reports · 396
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 = 'N323SW' AND deregistration_id = 'N323SW-2013-07-17' 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 = 'N323SW' AND deregistration_id = 'N323SW-2013-07-17' 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 SWAA106828Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 952, WL 254. REPAIRED FRAME PER SRM.SDR SWAA106827Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 727B, LBL 45.5. REPAIRED BEAM PER ER AND EA.SDR SWAA106826Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND SKIN CRACKED AT BS 952, STR 11L. REPAIRED SKIN PER SRM.SDR SWAA106825Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 20L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA106824Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 616, STR 17L. REPAIRED FRAME PER TI.SDR SWAA106823Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 11L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA106822Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 500B, BETWEEN STR 28L TO STR 28R. REPAIRED SHEAR TIE PER SRM.SDR SWAA106821Bulkhead · crackedDURING SCHEDULED 24Y CHECK, FOUND BULKHEAD CHORD CRACKED AT BS 540, BETWEEN STR 23R TO STR 24R. REPAIRED CHORD PER ER AND EA.SDR SWAA106755Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 480, BETWEEN STR 27R TO STR 28R. REPAIRED SHEAR TIE PER SRM.SDR SWAA106656Floor Support · corrodedDURING SCHEDULED 24Y CHECK, FOUND FLOOR SUPPORT CHANNEL CORRODED AT BS 758, LBL 8.10. REPAIRED CHANNEL PER EA.SDR SWAA106655Angle · crackedDURING SCHEDULED 24Y CHECK, FOUND VERTICAL ANGLE CRACKED AT BS 272B, BL 0. REMOVED AND REPLACED ANGLE PER SRM AND BAC DWG.SDR SWAA106654Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 847, BETWEEN STR 27L TO STR 27R. REPAIRED FRAME PER SRM.SDR SWAA106624Hinge Fitting · crackedDURING SCHEDULED 24Y CHECK, FOUND L2 DOOR UPPER HINGE LOWER FITTING CRACKED. REMOVED AND REPLACED FITTING PER SRM.SDR SWAA106623Angle · crackedDURING SCHEDULED 24Y CHECK, FOUND LT Z-ANGLE CRACKED AT STA 198.40. REMOVED AND REPLACED Z-ANGLE PER BAC DWG.SDR SWAA106622Stiffener · corrodedDURING SCHEDULED 24Y CHECK, FOUND HORIZONTAL STIFFENER CORRODED AT BS 550, BETWEEN LBL 6 TO RBL 6. REMOVED AND REPLACED STIFFENER PER SRM.SDR SWAA106621Floor Support · corrodedDURING SCHEDULED 24Y CHECK, FOUND FLOOR SUPPORT CHANNEL CORRODED AT BS 772, LBL 8.10. REPAIRED CHANNEL PER EA.SDR SWAA106620Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 767, STR 23L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA106619Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 5R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA106618Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 5L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA106617Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 787, STR 24R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA106616Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 787, STR 23R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA106615Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 787, STR 21R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA106614Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 807, STR 18L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA106613Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 827, STR 22L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA106612Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 795, STR 26R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA106611Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 927, STR 23L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA106610Splice · crackedDURING SCHEDULED 24Y CHECK, FOUND BULKHEAD CHORD SPLICE CRACKED AT BS 540, BETWEEN STR 21L TO STR 22L. REMOVED AND REPLACED SPLICE PER SRM AND BAC DWG.SDR SWAA106609Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 5R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA106608Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 303.9, STR 16L. REPAIRED FRAME PER SRM AND BAC DWG.SDR SWAA105568Mec · faultyINFLIGHT SHUTDOWN/ DECLARED EMERGENCY. UNUSUAL THROTTLE SPLITS & DIFFERING SPOOL UP TIMES. PMC'S OFF AT 32K WHEN THROTTLES PULLED TO IDLE, 2 COMPRESSOR STALLS AND LEFT ENGINE ROLLED BACK. REMOVED AND REPLACED MEC AND CIT SENSOR.SDR SWAA103425Hydraulic Line · leakingAIR TURNBACK, "A" SYSTEM QUANTITY DROPPED TO 1/4 RT MLG WOULD NOT LOCK UP. REMOVED AND REPLACED RT MLG ACTUATOR HYDRAULIC HOSE ASSY PER MM.SDR SWAA100557Web · corrodedDURING SCHEDULED SPV CHECK, FOUND WEB CORRODED AT BS 500D, STR 27R. REPAIRED WEB PER SRM.SDR SWAA100556Stringer · corrodedDURING SCHEDULED SPV CHECK, FOUND STRINGER CORRODED AT BS 500D, STR 27R. REPAIRED STRINGER PER SRM.SDR SWAA100473Skin · corrodedDURING SCHEDULED SPV CHECK, FOUND SKIN CORRODED AT BS 500B, STR 26L. REPAIRED SKIN PER ER.SDR SWAA100256Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 360, STR 20R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA100255Failsafe · corrodedDURING SCHEDULED SPV CHECK, FOUND FAIL-SAFE CHORD CORRODED AT BS 500D, STR 17R. REPAIRED CHORD PER SRM.SDR SWAA100254Window Frame · corrodedDURING SCHEDULED SPV CHECK, FOUND LT OVERWING EMERGENCY EXIT WINDOW FRAME CORRODED. REPAIRED FRAME PER SRM.SDR SWAA100253Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 500D, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR SWAA100311Crease Beam · corrodedDURING SCHEDULED SPV CHECK, FOUND LT CREASE BEAM CORRODED AT BS 917, STR 17L. REMOVED AND REPLACED WEB PER SRM.SDR SWAA100210Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 727E, BETWEEN STR 19L TO STR 20L. REMOVED AND REPLACED SHEAR TIE PER BAC DWG.SDR SWAA100209Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 500D, BETWEEN STR 19L TO STR 20L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA100207Shear Tie · corrodedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CORRODED AT BS 967, BETWEEN STR 27L TO STR 27R. REPAIRED SHEAR TIE PER SRM.SDR SWAA100197Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 793, STR 20L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA100196Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME WEB CRACKED AT BS 727B, STR 17L. REPAIRED FRAME PER BAC DWG AND SRM.SDR SWAA100122Shear Tie · corrodedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CORRODED AT BS 927, BETWEEN STR 25L TO STR 26L. REPAIRED SHEAR TIE PER SRM.SDR SWAA100069Stringer · corrodedDURING SCHEDULED SPV CHECK, FOUND STRINGER CORRODED BETWEEN BS 967 TO BS 987, STR 25R. REPAIRED STRINGER PER ACO.SDR SWAA100020Stringer · corrodedDURING SCHEDULED SPV CHECK, FOUND STRINGER CORRODED AT BS 967, STR 27L. REPAIRED STRINGER PER SRM.SDR SWAA098018Skin · corrodedDURING SCHEDULED SPV CHECK, FOUND SKIN CORRODED BETWEEN BS 957 TO BS 986, STR 25R. REPAIRED SKIN PER ACO.SDR SWAA098017Skin · corrodedDURING SCHEDULED SPV CHECK, FOUND SKIN CORRODED BETWEEN BS 909 TO BS 928, STR 25R. REPAIRED SKIN PER ACO.SDR SWAA098016Skin · corrodedDURING SCHEDULED SPV CHECK, FOUND SKIN CORRODED AT BS 947, STR 25R. REPAIRED SKIN PER ACO.
Back to N323SW, cancelled Jul 17, 2013