N312SW, cancelled Oct 31, 2011
Service difficulty reports · 320
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 = 'N312SW' AND deregistration_id = 'N312SW-2011-10-31' 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 = 'N312SW' AND deregistration_id = 'N312SW-2011-10-31' 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 SWAA092454Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 5R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA092453Skin · delaminatedDURING SCHEDULED 24Y CHECK, FOUND RT WING O/B LEADING EDGE NR 4 SLAT UPPER SURFACE DELAMINATED. REPAIRED SKIN PER SRM.SDR SWAA092419Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 767, STR 16R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA092418Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500A, STR 16L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA091816Skin · crackedDURING SCHEDULED CV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500C, STR 19R. REPAIRED SKIN PER SWA EA.SDR SWAA091815Skin · crackedDURING SCHEDULED CV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 440, STR 25L. REPAIRED SKIN PER SWA EA.SDR SWAA091231Stringer · crackedDURING SCHEDULED SPECIAL VISIT CHECK, FOUND FUSELAGE STRINGER CRACKED AT BS 484, STR 16R. REPAIRED STRINGER PER SRM.SDR SWAA091230Shear Tie · crackedDURING SCHEDULED SPECIAL VISIT CHECK, FOUND FUSELAGE SHEAR TIE CRACKED AT BS 500A, BETWEEN STR 15R & 16R. REPAIRED SHEAR TIE PER SRM.SDR SWAA091229Skin · crackedDURING SCHEDULED SPECIAL VISIT CHECK, FOUND FUSELAGE SKIN SECTION CRACKED AT BS 430 TO BS 500A, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA090622Actuator · faultyDECLARED EMERGENCY. ON APPROACH SETTING TO FLAP 5 AIRCRAFT STARTED TO VIBRATE, VIBRATION FELT ON FLIGHT CONTROL, DECLARED EMERGENCY. REMOVED AND REPLACED NR 6 FLIGHT SPOILER ACTUATOR PER MM.SDR SWAA090395Cover · brokenDURING SCHEDULED MV1 CHECK, FOUND L1 DOOR EMERGENCY EXIT LIGHT COVER BROKEN. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA090350Cover · brokenL1 DOOR EMERGENCY EXIT LIGHT COVER BROKEN. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA090221Skin · crackedDURING SCHEDULED OTS CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR, LOWER HINGE CUTOUT. REPAIRED SKIN PER SWA EA.SDR SWAA087345Skin · crackedDURING SCHEDULED OTS CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 259, BELOW STR 9L. REPAIRED SKIN PER SWA EA.SDR SWAA087324Skin · crackedDURING SCHEDULED OTS CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SWA EA.SDR SWAA087323Skin · crackedDURING SCHEDULED OTS CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER SWA EA.SDR SWAA087265Skin · crackedDURING SCHEDULED OTS CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR LOWER HINGE DOUBLER. REMOVED AND REPLACED SKIN PER SRM.SDR SWAA087204Skin · corrodedDURING SCHEDULED OTS CHECK, FOUND FUSELAGE SKIN CORRODED AT BS 987, STR 27R. REPAIRED SKIN PER SWA EA.SDR SWAA087203Skin · corrodedDURING SCHEDULED OTS CHECK, FOUND FUSELAGE SKIN CORRODED AT BS 986, STR 24R. REPAIRED SKIN PER SWA EA.SDR SWAA087106Slat · delaminatedDURING SCHEDULED OTS CHECK, FOUND LT WING 2 SLAT OUTBOARD T/E DELAMINATED. REMOVED AND REPLACED SLAT PER SRM.SDR SWAA087105Battery · dischargedDURING SCHEDULED OTS CHECK, FOUND FWD EMERGENCY FLASHLIGHT I/B BATTERY INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA086959Slat · delaminatedDURING SCHEDULED HC2 CHECK, FOUND LT WING NR 2 SLAT O/B T/E DELAMINATED. REPAIRED SLAT PER SWA EA.SDR SWAA086925Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 691, STR 10L. REPAIRED SKIN PER SRM.SDR SWAA086924Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 490, STR 16L. REPAIRED SKIN PER SRM.SDR SWAA086923Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500, STR 16L. REPAIRED SKIN PER SRM.SDR SWAA086922Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 697, STR 10L. REPAIRED SKIN PER SRM.SDR SWAA085463Actuator · faultyDURING APPROACH LT MLG WOULD NOT INDICATE DOWN, RETRACTED GEAR, DID MANUAL EXTENSION GEAR DOWN, INDICATION NORMAL. REMOVED AND REPLACED MLG UPLOCK ACTUATOR AND PRIORITY MODULAR VALVE PER MM.SDR SWAA084626Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 322, STR 24R. REPAIRED SKIN PER SRM.SDR SWAA083571Slide · out of adjustR1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA083570Actuator · faultyDURING CLIMB RT MLG UNSAFE LIGHT ILLUMINATED. AFTER MOVING GEAR HANDLE TO OFF POSITION RT GEAR FELL OUT OF W/W. CYCLED GEAR, GEAR RETRACTED NORMAL INDICATIONS. REMOVED AND REPLACED RT MLG UPLOCK ACTUATOR PER MM.SDR SWAA082797Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 455, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA082675Skin · crackedDURING SCHEDULED OTS CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500, STR 15R. REPAIRED SKIN PER SWA EA.SDR SWAA081939Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 512, BETWEEN STR 16L AND STR 17L. REPAIRED SKIN PER EA.SDR SWAA081938Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND L1 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA081134Pump · failedAIR TURNBACK / DECLARED EMERGENCY. HYDRAULIC "A" SYSTEM FAILED IN FLIGHT. REMOVED AND REPLACED NR 1 ENGINE HYDRAULIC PUMP AND CASE DRAIN LINE PER MM.SDR SWAA080593Charger · faultyFWD CABIN EMERGENCY EXIT LIGHTS ILLUMINATED INTERMITTENTLY. REMOVED AND REPLACED BATTERY CHARGER PER MM.SDR SWAA080349Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 475, STR 16L. REPAIRED SKIN PER SRM.SDR SWAA080350Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 505B, STR 16L. REPAIRED SKIN PER SWA EA.SDR SWAA076436Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 460, STR 16R. REPAIRED SKIN PER SWA EA.SDR SWAA075956Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 639, STR 17L. REPAIRED FRAME PER ER.SDR SWAA075770Stringer Clip · crackedDURING SCHEDULED BRIDGE CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 1040, STR 13L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA075771Skin · crackedDURING SCHEDULED BRIDGE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 258, WL 181.5, LEFT SIDE. REPAIRED SKIN PER SRM.SDR SWAA075772Skin · crackedDURING SCHEDULED BRIDGE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 258, WL 170.5, LEFT SIDE. REPAIRED SKIN PER SRM.SDR SWAA075721Skin · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 678, STR 10L. REPAIRED SKIN PER SRM.SDR SWAA074112Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 400, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA073868Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA073867Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 344, STR 19R. REPAIRED SKIN PER SRM.SDR SWAA072366Skin · crackedDURING SCHEDULED PM CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 455, STR 16L. REPAIRED SKIN PER SRM.SDR SWAA072251Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 941, STR 23R. REPAIRED SKIN PER SRM.SDR SWAA072249Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 932, STR 25R. REPAIRED SKIN PER SRM.
Back to N312SW, cancelled Oct 31, 2011