N313SW, cancelled Sep 8, 2017
Service difficulty reports · 402
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 = 'N313SW' AND deregistration_id = 'N313SW-2017-09-08' 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 = 'N313SW' AND deregistration_id = 'N313SW-2017-09-08' 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 SWAA051101Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STRINGER CLIPS CRACKED AT BS 727C, STR 5L & STR 7L. REMOVED AND REPLACED CLIPS PER SRM.SDR SWAA051100Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 727B, STR 5L & STR 7L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA051099Shear Tie · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SHEAR TIE CRACKED AT BS 727B, BETWEEN STR 13L & STR 14L. REPAIRED SHEAR TIE PER SRM.SDR SWAA051107Shear Tie · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME SHEAR TIE CRACKED AT BS 500B, BETWEEN STR 15R & STR 16R. REPAIRED FRAME PER SRM.SDR SWAA051103Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 500A, STR 8L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA051095Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 715, BL 0, WL 204. REPAIRED BEAM PER SRM & EO.SDR SWAA051083Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 639, STR 3R & STR 4R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA051082Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 616, STR 4L & STR 5L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA051089Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 727A, STR 3L & STR 7L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA051088Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 727A, STR 6R & STR 7R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA051086Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 706, STR 8L & STR 9R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA051085Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 685, STR 4R TO STR 9R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA051094Stringer · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STRINGER CRACKED AT BS 380, STR 5L. REPAIRED STRINGER PER SRM.SDR SWAA051084Fitting · corrodedDURING SCHEDULED D-CHECK, FOUND LT & RT HORIZONTAL STAB FITTING LUG FACES CORRODED. REPAIRED LUG FACES PER SRM.SDR SWAA051081Floor Support · crackedDURING SCHEDULED D-CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 660, BL 0. REPAIRED BEAM PER PAE ER & SB.SDR SWAA051080Fitting · crackedDURING SCHEDULED D-CHECK, FOUND RIGHT MLG W/W FITTING CRACKED AT BS 715, RBL 68, WL 198. REMOVED AND REPLACED MLG FITTING PER SRM.SDR SWAA051093Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 380, STR 8L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA051092Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 500C, STR 9L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA051091Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, BETWEEN STR 8L & STR 9L. REPAIRED FRAME PER SRM.SDR SWAA051090Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, BETWEEN STR 8R & STR 9R. REPAIRED FRAME PER SRM.SDR SWAA051087Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 705, STR 7R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA051060Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 277, STR 10R & STR 14R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA051059Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 578, STR 5R TO STR 8R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA051058Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 597, STR 1R TO STR 8R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA051061Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME U-CHANNEL CRACKED AT BS 360, STR 14L. REPAIRED U-CHANNEL PER SRM.SDR SWAA051057Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND 2 EA FUSELAGE STRINGER CLIPS CRACKED AT BS 597, STR 8L & STR 9L. REMOVED AND REPLACED CLIPS PER SRM.SDR SWAA051056Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 578, STR 8L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA051055Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 662, RBL 25, WL 207. REPAIRED BEAM PER SB & PAE ER.SDR SWAA051054Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 294, STR 13L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA051053Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 616, RBL 65, WL 202. REPAIRED FRAME PER SRM.SDR SWAA051010Fitting · corrodedDURING SCHEDULED D-CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE, FWD & AFT GIRT BAR FLOOR FITTINGS CORRODED. REMOVED AND REPLACED FLOOR FITTINGS PER SRM.SDR SWAA051009Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND CORROSION ON CABIN FLOORBEAM UPPER CHORD AT BS 344, BETWEEN RBL 8 TO LBL 35. REPAIRED FLOORBEAM PER SRM.SDR SWAA051008Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND CORROSION ON CABIN FLOORBEAM UPPER CHORD AT BS 328, LBL 16. REPAIRED FLOORBEAM PER SRM.SDR SWAA043600Flashlight · ingestedFWD OUTBOARD EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED FLASHLIGHT PER MM.SDR SWAA043588Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN AT BS 375, STRINGER 19R, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA043587Bolt · wornDURING SCHEDULED C1 CHECK, LT AND RT ELEVATOR TABS FAILED FREE PLAY CHECK. REMOVED AND REPLACED RT AND LT INBOARD NR 1 TAB BOLTS PER MM.SDR SWAA042985Slide · dislodgedR1 DOOR EVAC SLIDE FELL OUT OF CONTAINER, DID NOT DEPLOY. REINSTALLED R1 DOOR EVAC SLIDE PER MM.SDR SWAA042777Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 940, STRINGER 21L, CRACKED. REPAIRED SKIN PER EA.SDR SWAA042573Actuator · leakingAIR TURNBACK, AIR RETURN TO DAL DUE TO LOSS OF A-SYSTEM HYDRAULIC FLUID AND PRESSURE. REMOVED AND REPLACED NR 6 INBOARD FLIGHT SPOILER ACTUATOR PER MM.SDR SWAA042503Beam · crackedDURING SCHEDULED C4 CHECK, FOUND FWD ENTRY DOOR WEB BEAM AT DOOR STOP, CRACKED. REMOVED AND REPLACED FWD ENTRY DOOR PER MM.SDR SWAA042497Hook · looseDURING SCHEDULED C4 CHECK, FOUND L1 & R1 DOOR EVAC SLIDES GIRT BAR HOOKS LOOSE. SECURED L1 & R1 DOOR EVAC SLIDES GIRT BAR HOOKS PER MM.SDR SWAA042363Actuator · leakingAIR TURNBACK. CLIMBING THRU 8500, HYDRAULIC -A- SYSTEM FAILURE. REMOVED AND REPLACED NR 6 SPOILER ACTUATOR O-RING PER MM.SDR SWAA041433Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN AT BS 747, STRINGER 19R, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA041432Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN AT BS 285, STRINGER 16L, CRACKED. REPAIRED SKIN PER EA.SDR SWAA040700Indicator · faultyF/O'S AIR SPEED IND C/B TRIPPED AND ACRID ODOR FOLLOWED. REMOVED AND REPLACED F/O'S MACH AIR SPEED IND PER MM.SDR SWAA040483Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 920, STRINGER 22L. REPAIRED SKIN PER SRM.SDR SWAA040465Strap · crackedDURING SCHEDULED C2 CHECK, FOUND L1 DOOR CUTOUT AT UPPER AND LOWER HINGE STRAPS CRACKED. REMOVED AND REPLACED STRAPS PER SRM.SDR SWAA040458Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 270, STRINGER 9L. REPAIRED SKIN PER SRM.SDR SWAA040457Lens · crackedDURING SCHEDULED C2 CHECK, FOUND FORWARD CABIN OVERHEAD EMERGENCY EXIT LIGHT LENS CRACKED. REMOVED AND REPLACED LIGHT LENS PER MM.SDR SWAA040391Lens · missingEMERGENCY EXIT LIGHT ON LT BULLNOSE MISSING LENS AT ROW 6 ABC. INSTALLED EMERGENCY EXIT LIGHT LENS PER MM.
Back to N313SW, cancelled Sep 8, 2017