N325SW, cancelled Mar 28, 2012
Service difficulty reports · 344
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 = 'N325SW' AND deregistration_id = 'N325SW-2012-03-28' 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 = 'N325SW' AND deregistration_id = 'N325SW-2012-03-28' 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 SWAA092583Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 847, AT STR 13L. REPAIRED FRAME PER SWA EA.SDR SWAA092564Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 787, BETWEEN STR 13R TO STR 14R, WL 233.5. REPAIRED FRAME PER SWA EA.SDR SWAA092563Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 662, RBL 24.5, WL 204. REPAIRED BEAM PER SWA EA.SDR SWAA092562Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 662, LBL 24.5, WL 204. REPAIRED BEAM PER SWA EA.SDR SWAA092549Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR UPPER HINGE CUTOUT BETWEEN BS 289.75 TO BS 304, BETWEEN WL 257 TO WL 262. REPAIRED SKIN PER SWA EA.SDR SWAA092497Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 380, STR 16L. REPAIRED FRAME PER SRM.SDR SWAA092472Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR LOWER HINGE CUTOUT BETWEEN BS 303 TO BS 304.5, BETWEEN WL 234 TO WL 238.2. REPAIRED SKIN PER SWA EA.SDR SWAA092471Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR LOWER HINGE CUTOUT BS 290.88, BETWEEN WL 232.88 TO WL 229. REPAIRED SKIN PER SWA EA.SDR SWAA086005Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 420, STR 16L. REPAIRED SKIN PER SRM.SDR SWAA086004Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 436, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA086003Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 426, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA086002Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500A, STR 17R. REPAIRED SKIN PER SRM.SDR SWAA085276Light · inoperativeDURING SCHEDULED 18Y CHECK, FOUND AFT EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT PER MM.SDR SWAA085111Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 405, STR 27L. REPAIRED SKIN PER SWA EA.SDR SWAA085000Hook · brokenL2 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR HOOK BROKEN. REMOVED AND REPLACED HOOK PER MT.SDR SWAA076385Battery · dischargedFWD CABIN EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA075811Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 259.5, BETWEEN STR 19L AND STR 23L. REPAIRED SKIN PER SRM.SDR SWAA075700Skin · crackedDURING SCHEDULED SPV CHECK, FOUND NR 1 ENGINE UPPER PYLON T-CROWN CRACKED. REPAIRED PYLON PER ER.SDR SWAA075411Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 932, STR 24R. REPAIRED SKIN PER SRM.SDR SWAA075410Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 440, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA074647Battery Pack · faultyMID CABIN EMERGENCY EXIT LIGHTS ILLUMINATED WITH SWITCH IN ARMED POSITION. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA073944Battery · faultyDURING SCHEDULED MV1 CHECK, MID CABIN EMERGENCY EXIT LIGHTS STAY ILLUMINATED WITH SWITCH IN ARMED POSITION. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA071908Fitting · corrodedDURING SCHEDULED 20Y CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR FITTING CORRODED. REMOVED AND REPLACED FITTING PER MM.SDR SWAA071907Fitting · corrodedDURING SCHEDULED 20Y CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR FITTING CORRODED. REMOVED AND REPLACED FITTING PER MM.SDR SWAA071906Fitting · corrodedDURING SCHEDULED 20Y CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR FITTING CORRODED. REMOVED AND REPLACED FITTING PER MM.SDR SWAA071909Fitting · corrodedDURING SCHEDULED 20Y CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR FITTING CORRODED. REMOVED AND REPLACED FITTING PER MM.SDR SWAA071904Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, STR 19L. REPAIRED FRAME PER SWA EA.SDR SWAA071905Door Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND L1 DOOR LOWER FRAME CRACKED AT LOWER FWD CORNER. REMOVED AND REPLACED L1 DOOR PER MM.SDR SWAA071813Intercostal · corrodedDURING SCHEDULED 20Y CHECK, FOUND INTERCOSTAL CORRODED AT BS 787 TO BS 794, STR 25R. REMOVED AND REPLACED INTERCOSTAL PER SRM.SDR SWAA071812Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 19L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA071721Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500B, STR 21R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA071723Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 620, STR 5R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA071722Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500D, STR 15R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA071724Stringer Splice · corrodedDURING SCHEDULED 20Y CHECK, FOUND STRINGER SPLICE CORRODED AT BS 907, STR 23R. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA071720Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 807, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071719Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071683Skin · corrodedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN BEAR STRAP CORRODED AT BS 789, STR 25R. REPAIRED SKIN PER SWA EA.SDR SWAA071675Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071674Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071682Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 887, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071681Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071680Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 847, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071679Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071676Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071678Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071677Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071673Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071659Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 700, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA071660Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 680, STR 6R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA071666Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, STR 19L. REPAIRED FRAME PER SWA EA.
Back to N325SW, cancelled Mar 28, 2012