N316SW, cancelled Sep 10, 2012
Service difficulty reports · 452
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 = 'N316SW' AND deregistration_id = 'N316SW-2012-09-10' 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 = 'N316SW' AND deregistration_id = 'N316SW-2012-09-10' 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 SWAA081166Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 512A, STR 16L. REPAIRED SKIN PER SWA EA.SDR SWAA080737Pin · not seatedAIR TURNBACK, RT MLG RED LIGHT DID NOT EXTINGUISH AFTER RAISING LANDING GEAR. RESEATED PIN 3 ON RT MLG UPLOCK SENSOR PER MM.SDR SWAA080738Fitting · crackedDURING SCHEDULED MV2 CHECK, FOUND LT WING NR 4 GROUND SPOILER INBOARD FITTING LUG CRACKED. REPAIRED FITTING PER SWA EA.SDR SWAA080417Light · inoperativeDURING SCHEDULED BRDG CHECK, FOUND L1 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA080418Light · inoperativeDURING SCHEDULED BRDG CHECK, FOUND R1 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA080404Skin · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BS 410, BL 0. REPAIRED SKIN PER EA.SDR SWAA080360Skin · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BS 390, BL 0. REPAIRED SKIN PER EA.SDR SWAA080259Stringer · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER 11R CRACKED AT BS 947. REPAIRED STRINGER PER SRM.SDR SWAA080258Rod · wornDURING SCHEDULED BRDG CHECK, LT ELEVATOR FAILED FREE PLAY CHECK. REMOVED AND REPLACED INPUT ROD PER MM.SDR SWAA080231Rod · wornDURING SCHEDULED BRDG CHECK, RT WING AILERON FAILED FREE PLAY CHECK. REMOVED AND REPLACED AILERON OUT PUT ROD PER MM.SDR SWAA074344Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT 347, STR 15R. REPAIRED SKIN PER SRM.SDR SWAA074308Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 350, STR 15R. REPAIRED SKIN PER SWA EA.SDR SWAA073740Skin · crackedDURING SCHEDULED A1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 272.5, STR 15L. REPAIRED SKIN PER SWA EA.SDR SWAA073413Slat · crackedDURING SCHEDULED C4 CHECK, FOUND LEFT WING NR 2 L/E SLAT CRACKED AT FWD INBOARD END. REPAIRED SLAT PER SWA EA.SDR SWAA073382Skin · crackedFUSELAGE SKIN CRACKED AT BS 520, STR 8L. REPAIRED SKIN PER SWA EA.SDR SWAA072813Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 757, STR 20L. REPAIRED SKIN PER SRM.SDR SWAA072811Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500B, STR 15R. REPAIRED SKIN PER SWA EA.SDR SWAA072810Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 751, STR 19L. REPAIRED SKIN PER SWA EA.SDR SWAA072812Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 764, STR 19L. REPAIRED SKIN PER SWA EA.SDR SWAA072729Spoiler · brokenDURING SCHEDULED A2 CHECK, FOUND LEFT WING NR 4 GROUND SPOILER OUTBOARD HINGE LUG BROKEN. REMOVED AND REPLACED SPOILER PER MM.SDR SWAA072413Slide · out of adjustL2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA071870Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 749.5, STR 18L. REPAIRED SKIN PER SWA EA.SDR SWAA071869Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 363, STR 8L. REPAIRED SKIN PER SRM.SDR SWAA064953Keelbeam · corrodedDURING SCHEDULED C2 CHECK, FOUND KEELBEAM CORRODED AT BS 500D LT SIDE. REPAIRED KEEL BEAM PER SRM.SDR SWAA064839Skin · crackedDURING SCHEDULED A2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727D, STR 14R. REPAIRED SKIN PER SWA EA.SDR SWAA064647Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 460, STR 16L. REPAIRED SKIN PER SWA EA.SDR SWAA064119Link · wornVIBRATION FELT DURING TAKEOFF AND LANDING. REMOVED AND REPLACED RT MLG UPPER AND LOWER TORSION LINKS PER MM.SDR SWAA063614Slide · out of adjustR2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA063314Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 942, STR 21R. REPAIRED SKIN PER SWA EA.SDR SWAA063164Slide · deployedL1 DOOR EMERGENCY EVAC SLIDE INADVERTENTLY DEPLOYED. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA062971Battery · inoperativeAFT CABIN EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED FLASHLIGHT BATTERY PER MM.SDR SWAA062258Slide · low pressureR2 DOOR EMERGENCY EVAC SLIDE INDICATED LOW PRESSURE. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA061784Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA061677Actuator · brokenDURING SCHEDULED A2 CHECK, FOUND LT WING NR 4 SPOILER, OUTBOARD ACTUATOR ROD BROKEN. REMOVED AND REPLACED SPOILER ACTUATOR PER MM.SDR SWAA061223Skin · crackedDURING SCHEDULED A2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 810, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA060946Slide · dislodgedL1 DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA060519Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 948, STR 23R. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA060419Skin · crackedDURING WALKAROUND INSP, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 500D TO BS 512D, STR 16L. REPAIRED SKIN PER SWA EA.SDR SWAA054034Slide · dislodgedL1 DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA053343Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 23R. REPAIRED FRAME PER SRM.SDR SWAA053342Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 847 AND AFT CARGO DOOR CUT OUT NR 5 STOP FITTING. REPAIRED FRAME PER BFG ER.SDR SWAA053336Rib · crackedDURING SCHEDULED D-CHECK, FOUND RIGHT WING RIB LOWER CHORD CRACKED AT WBL 135.5, BETWEEN STR 2 & STR 3. REPAIRED RIB PER BFG ER.SDR SWAA053335Bulkhead · crackedDURING SCHEDULED D-CHECK, FOUND BS 1016 BULKHEAD WEB CRACKED AT STR 7L. REPAIRED WEB PER BFG ER & SRM.SDR SWAA053350Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 492, FWD CARGO DOOR CUTOUT. REPAIRED FRAME PER SRM.SDR SWAA053324Stringer · corrodedDURING SCHEDULED D CHECK, FOUND FUSELAGE STR CORRODED AT BS 515, STR 26L. REPAIRED STR PER SRM.SDR SWAA053323Skin · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 515, STR 16L. REPAIRED SKIN PER BFG ER.SDR SWAA053309Floor Support · crackedDURING SCHEDULED D CHECK, FOUND LONGITUDINAL FLOOR SUPPORT CRACKED AT BS 706, RBL 25, WL 203. REPAIRED FLOOR SUPPORT PER BFG ER.SDR SWAA053275Attach Fitting · corrodedDURING SCHEDULED D CHECK, FOUND VERTICAL STAB ATTACH FITTING LUG FACES CORRODED. REPAIRED LUG FACES PER BFG ER.SDR SWAA053256Crease Beam · corrodedDURING SCHEDULED D CHECK, FOUND FUSELAGE CREASE BEAM WEB CORRODED BETWEEN BS 309 TO BS 349, LBL 55 TO LBL 61, WL. 208. REPAIRED WEB PER SRM.SDR SWAA053255Stringer Clip · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 294.5, STR 13L. REMOVED AND REPLACED CLIP PER SRM.
Back to N316SW, cancelled Sep 10, 2012