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 SWAA091832Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED BETWEEN BS 727 TO BS 727B, STR 14L. REPAIRED SKIN PER SWA EA.SDR SWAA087117Bulkhead · crackedDURING SCHEDULED 22Y CHECK, FOUND LT MLG WHEEL WELL CEILING PRESSURE DECK, FWD BULKHEAD, CRACKED AT BS 665, LBL 40. REPAIRED BULKHEAD PER AAR EA.SDR SWAA086467Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER AAR EA.SDR SWAA086543Light · wornDURING SCHEDULED HC2 CHECK, FOUND EMERGENCY LIGHT STRIP WORN BETWEEN ROW 8 TO ROW 13. REMOVED AND REPLACED STRIP PER MM.SDR SWAA086542Skin · delaminatedDURING SCHEDULED HC2 CHECK, FOUND LT WING NR 2 SLAT LOWER T/E WEDGE DELAMINATED. REMOVED AND REPLACED SLAT PER MM.SDR SWAA086449Fitting · crackedDURING SCHEDULED 22Y CHECK, FOUND RT WING NR 5 SPOILER FITTING CRACKED AT FWD ATTACH HOLE. REMOVED AND REPLACED FITTING PER SRM.SDR SWAA086431Battery Pack · dischargedDURING SCHEDULED 22Y CHECK, FOUND OVERWING EMERGENCY EXIT LIGHT LAMP INOP. REMOVED AND REPLACED BATTERY PACK PER WDM.SDR SWAA086411Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER AAR EA.SDR SWAA086303Mount · damagedDURING SCHEDULED 22Y CHECK, FOUND R2 DOOR GIRT BAR FLOOR MOUNT DAMAGED. REMOVED AND REPLACED MOUNT PER MM.SDR SWAA086267Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 20L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA086209Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER AAR EA.SDR SWAA086180Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 20L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA086179Stringer · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CRACKED AT BS 360, STR 15L. REMOVED AND REPLACED STRINGER PER SRM.SDR SWAA086166Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 573, STR 10L. REPAIRED SKIN PER SWA EA.SDR SWAA086165Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 593, STR 9R. REPAIRED SKIN PER SWA EA.SDR SWAA086094Shear Tie · crackedDURING SCHEDULED 22Y CHECK, FOUND SHEAR TIE CRACKED AT BS 277, STR 8L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA085979Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 887, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA085978Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA085977Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 847, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA085976Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA085975Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727E, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA085974Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA085973Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA085972Skin · delaminatedDURING SCHEDULED 22Y CHECK, FOUND RT WING NR 5 SLAT UPPER SURFACE DELAMINATED. REMOVED AND REPLACED SLAT PER MM.SDR SWAA085971Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA085970Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 887, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA085969Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 847, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA085968Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA085967Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 807, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA085966Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA085965Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA085964Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA085913Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 323, STR 20L. REPAIRED FRAME PER SRM.SDR SWAA085912Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 294, R1 DOOR MIDDLE CUTOUT. REPAIRED FRAME PER SRM.SDR SWAA085880Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 8L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA085674Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 277, STR 8R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA085597Stringer Clip · corrodedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CORRODED AT BS 335, STR 20L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA085596Stringer Clip · corrodedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CORRODED AT BS 328, STR 20L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA084828Skin · delaminatedDURING SCHEDULED MV1 CHECK, FOUND LT WING NR 1 SPOILER UPPER SURFACE DELAMINATED. REMOVED AND REPLACED SPOILER PER MM.SDR SWAA084270Skin · crackedDURING SCHEDULED MV3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 814, STR 18L. REPAIRED SKIN PER SWA EA.SDR SWAA084269Skin · crackedDURING SCHEDULED MV3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 847, STR 17L. REPAIRED SKIN PER SWA EA.SDR SWAA084268Skin · crackedDURING SCHEDULED MV3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 787, STR 18L. REPAIRED SKIN PER SWA EA.SDR SWAA082469Skin · crackedDURING SCHEDULED SPV CHECK, FOUND R1 DOOR SKIN CRACKED AFT OF WINDOW. REMOVED AND REPLACED DOOR PER MM.SDR SWAA082466Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BS 430, BL 0. REPAIRED SKIN PER EA.SDR SWAA082468Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED BS 394, STR 17R. REPAIRED SKIN PER EA.SDR SWAA082470Stringer · corrodedDURING SCHEDULED SPV CHECK, FOUND STRINGER 26R CORRODED AT BS 830 TO BS 840. REPAIRED STRINGER PER SRM.SDR SWAA082471Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 366, STR 26L. REPAIRED SKIN PER SRM.SDR SWAA082465Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BS 450, BL 0. REPAIRED SKIN PER EA.SDR SWAA082467Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED BS 503D, STR 16L. REPAIRED SKIN PER EA.SDR SWAA082348Light · inoperativeDURING SCHEDULED SPV CHECK, FOUND L1 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.
Back to N323SW, cancelled Jul 17, 2013