N314SW, cancelled May 18, 2012
Service difficulty reports · 412
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 = 'N314SW' AND deregistration_id = 'N314SW-2012-05-18' 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 = 'N314SW' AND deregistration_id = 'N314SW-2012-05-18' 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 SWAA083504Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 6L AND STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083498Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727E, STR 7R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083362Stiffener · crackedDURING SCHEDULED SPV CHECK, FOUND AFT PRESSURE BULKHEAD RADIAL STIFFENER CRACKED AT BS 1016, NR 19 POSITION. REMOVED AND REPLACED STIFFENER PER SRM.SDR SWAA083356Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 807, STR 13R. REPAIRED FRAME PER SWA EA.SDR SWAA083363Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 259, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA083361Stiffener · crackedDURING SCHEDULED SPV CHECK, FOUND AFT PRESSURE BULKHEAD RADIAL STIFFENER CRACKED AT BS 1016, NR 16 POSITION. REMOVED AND REPLACED STIFFENER PER SRM.SDR SWAA083360Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 23L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083359Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 500D, STR 7R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083357Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 13R. REPAIRED FRAME PER SWA EA.SDR SWAA083355Bulkhead · crackedDURING SCHEDULED SPV CHECK, FOUND AFT PRESSURE BULKHEAD WEB CRACKED AT BS 1016, STR 15L. REPAIRED WEB PER SRM.SDR SWAA083358Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 578, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083170Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STR 3L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083178Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 5L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083177Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 8L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083176Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 6L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083175Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 3L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083174Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 500C, STR 3L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083173Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 500B, STR 3L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083171Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 420, STR 3L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083169Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 9R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083168Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 639, STR 8R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083167Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083166Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 827, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083156Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083155Stringer · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER 14L CRACKED AT BS 727B. REPAIRED STRINGER PER SRM.SDR SWAA083172Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 440, STR 3L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA082935Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA082568Isolator · brokenABORTED TAKEOFF, NR 1 ENGINE STARTED TO SPOOL UP SLOWLY, HUNG UP AT 51% AND WOULD NOT ADVANCE. INSPECTED AND FOUND NR 1 ENGINE OUTBOARD FWD ISOLATOR END BROKEN. REMOVED AND REPLACED FWD T/R ISOLATOR PER MM.SDR SWAA081847Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 350, STR 16R. REPAIRED SKIN PER SWA EA.SDR SWAA081828Skin · crackedFUSELAGE SKIN CRACKED AT BS 500, STR 21R. REPAIRED SKIN PER SWA EA.SDR SWAA081137Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 515D, STR 15L. REPAIRED SKIN PER SWA EA.SDR SWAA081138Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500D, STR 16L. REPAIRED SKIN PER SWA EA.SDR SWAA081152Shear Tie · crackedDURING SCHEDULED MV1 CHECK, FOUND SHEAR TIE CRACKED AT BS 520, STR LBL 16. REPAIRED SHEAR TIE PER SRM.SDR SWAA081154Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 375, STR 15L. REPAIRED SKIN PER SWA EA.SDR SWAA081153Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727, STR 13R. REPAIRED SKIN PER SWA EA.SDR SWAA076223Lamp · inoperativeDURING SCHEDULED BRDG CHECK, FOUND RIGHT OVERWING EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA076222Lamp · inoperativeDURING SCHEDULED BRDG CHECK, FOUND R2 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA075957Light · crackedDURING SCHEDULED BRDG CHECK, FOUND L1 DOOR EMERGENCY EXIT LIGHT CRACKED. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA075958Light · crackedDURING SCHEDULED BRDG CHECK, FOUND R1 DOOR EMERGENCY EXIT LIGHT CRACKED. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA075959Fitting · looseDURING SCHEDULED BRDG CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR FITTING LOOSE. SECURED FITTING PER MM.SDR SWAA075316Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO DOOR CUTOUT FWD FRAME CRACKED AT NR 5 DOOR STOP. REPAIRED FRAME PER SRM.SDR SWAA075312Stringer · corrodedDURING SCHEDULED SPV CHECK, FOUND STRINGER 26L CORRODED AT BS 740A. REPAIRED STRINGER PER SRM.SDR SWAA075233Keelbeam · corrodedDURING SCHEDULED SPV CHECK, FOUND LT KEEL BEAM CORRODED BETWEEN BS 707 AND BS 727. REMOVED AND REPLACED KEEL BEAM PER SRM.SDR SWAA075149Slat · delaminatedDURING SCHEDULED SPV CHECK, FOUND RIGHT NR 5 L/E SLAT DELAMINATED AT OUTBOARD T/E. REPAIRED SLAT PER SRM.SDR SWAA075090Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO DOOR CUTOUT FWD FRAME CRACKED AT LOWER DOOR STOP. REMOVED AND REPLACED FRAME PER ACO.SDR SWAA075057Slat · crackedDURING SCHEDULED SPV CHECK, FOUND LEFT WING NR 2 L/E SLAT CRACKED AT OUTBOARD END. REPAIRED SLAT PER SRM.SDR SWAA074796Slide · dislodgedL1 DOOR EMERGENCY EVAC SLIDE FELL OUT, DID NOT DEPLOY. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA073909Skin · corrodedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CORRODED AT BS 490, STR 28R. REPAIRED SKIN PER SWA EA.SDR SWAA073908Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 791, STR 14R. REPAIRED SKIN PER SWA EA.SDR SWAA073907Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 750, STR 14L. REPAIRED SKIN PER SWA EA.
Back to N314SW, cancelled May 18, 2012