N309SW, cancelled May 22, 2017
Service difficulty reports · 454
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 = 'N309SW' AND deregistration_id = 'N309SW-2017-05-22' 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 = 'N309SW' AND deregistration_id = 'N309SW-2017-05-22' 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 SWAA040475Floorbeam · crackedDURING SCHEDULED D CHECK, FOUND FLOORBEAMS CRACKED AT BS 727B, RBL 25, WL 208 AND BS 727B, LBL 45, WL 208. REPAIRED BEAMS PER ER.SDR SWAA040474Frame · crackedDURING SCHEDULED D CHECK, FOUND INBOARD FRAME CHORD CRACKED AT BS 616, RBL 65, WL 204. REPAIRED FRAME CHORD PER ER.SDR SWAA040450Bulkhead · corrodedDURING SCHEDULED D CHECK, FOUND CORROSION ON WEB AT BS 1016, FWD SIDE OF BULKHEAD. REPAIRED WEB ER.SDR SWAA040449Frame · crackedDURING SCHEDULED D CHECK, FOUND FRAMES CRACKED AT BS 867, BETWEEN STRINGERS 8L AND 9L, AND BS 907, BS 887, BS 867, BETWEEN STRINGERS 8R AND 9R. REPAIRED FRAMES PER ER.SDR SWAA040448Frame · crackedDURING SCHEDULED D CHECK, FOUND FRAME CRACKED AT BS 188, STRINGER 17R. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA040427Stringer Clip · crackedDURING SCHEDULED D CHECK, FOUND STRINGER CLIPS CRACKED AT BS 277, RBL 55, WL 250 AND BS 277, RBL 55, WL 254. REMOVED AND REPLACED STRINGER CLIPS PER SRM.SDR SWAA040418Stringer Clip · corrodedDURING SCHEDULED D CHECK, FOUND STRINGER TIE CLIP AT BS 807 STRINGER 26 R, CORRODED. REMOVED AND REPLACED STRINGER TIE CLIP PER SRM.SDR SWAA040417Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND SHEAR TIES CORRODED AT AFT CARGO COMPT BS 767, BL 0, BS 807, LBL 17. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA040416Stringer Clip · crackedDURING SCHEDULED D CHECK, FOUND STRINGER CLIP CRACKED AT BS 887 BETWEEN STRINGERS 20R AND STRINGER 21R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA040334Stringer Clip · crackedDURING SCHEDULED D CHECK, FOUND STRINGER CLIPS CRACKED AT BS 616, STRINGER 5R AND BS 907, STRINGER 4R. REMOVED AND REPLACED STRINGER CLIPS PER SRM.SDR SWAA040304Frame · crackedDURING SCHEDULED D CHECK, FOUND FRAME CRACKED AT BS 188, STRINGER 17L. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA040303Frame · crackedDURING SCHEDULED D CHECK, FOUND FRAME CRACKED AT BS 328, BETWEEN STRINGERS 20R AND 21R. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA040302Stiffener · corrodedDURING SCHEDULED D CHECK, FOUND STIFFENER CORRODED IN MAIN WHEEL WELL, BS 663 TO BS 676, RBL 27. REMOVED AND REPLACED STIFFENER SECTION PER SRM.SDR SWAA040295Skin · crackedDURING SCHEDULED D CHECK, FOUND E&E DOOR SKIN CRACKED NEAR AFT EDGE. REPAIRED DOOR SKIN PER SRM.SDR SWAA040269Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIPS CRACKED AT THE FOLLOWING BS 500D, STRINGER 8R, BS 520, STRINGER 8R, BS 578, STRINGER 8R, BS 597, STRINGERS 8R AND 7R, BS 616, STRINGERS 8R AND 8L. REMOVED AND REPLACED STRINGER CLIPS PER SRM.SDR SWAA040268Frame · crackedDURING SCHEDULED D CHECK, FOUND FRAME CRACKED AT BS 277, STRINGER 16 L. REPAIRED FRAME PER SRM.SDR SWAA040267Fitting · corrodedDURING SCHEDULED D CHECK, FOUND STRINGER END TIE CORRODED AT BS 365, STRINGER 28L. REPAIRED END TIE PER SRM.SDR SWAA040266Frame · crackedDURING SCHEDULED D CHECK, FOUND FRAME CRACKED AT BS 320, LBL 53, WL 181. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA040256Stringer · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER 5L CRACKED AT BS 380. REMOVED AND REPLACED CRACKED STRINGER PER SRM.SDR SWAA040255Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STRINGER 5L. REMOVED AND REPLACED CRACKED CLIP PER SRM.SDR SWAA040249Skin · crackedDURING SCHEDULED D-CHECK, FOUND CRACK IN EXTERNAL SKIN L1 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA040248Panel · damagedDURING SCHEDULED D-CHECK, FOUND FIRST OFFICERS EMERGENCY ESCAPE ROPE PANEL NOT OPENING. FOUND ROPE CAUGHT IN DOOR, REMOVED AND REPLACED ROPE PER MM.SDR SWAA032552Skin · crackedDURING SCHEDULED C3 CHECK, FOUND 2 EA FUSELAGE SKIN CRACKS, BS 797, STR 7L AND BS 500A, STR 17L. REPAIRED SKIN PER SRM.SDR SWAA032551Clip · looseDURING SCHEDULED C3 CHECK, FOUND R1 DOOR EVACUATION SLIDE GIRT BAR RESTRAIN CLIP LOOSE. SECURED CLIP PER MM.SDR SWAA031112Skin · crackedDURING SCHEDULED SPECIAL VISIT, FOUND PAX WINDOW CUTOUTS CRACKED AT RT WINDOWS NR 1, NR 4 AND NR 6. REPAIRED CUTOUT SKINS PER SRM.SDR SWAA031111Stringer · crackedDURING SCHEDULED SPECIAL VISIT, FOUND STRINGER CRACKED (2 EA) AT STR 11R, BS 390 AND BS 500A. REPAIRED STRINGER PER SRM.SDR SWAA031110Skin · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN CRACKED (2 EA) AT BS 520, BETWEEN STR 15R AND STR 16R, STR 16L BETWEEN BS 474 AND BS 477. REPAIRED SKIN PER SRM.SDR SWAA031093Skin · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN CRACK (2 EA ) AT STR 15R, BS 500C & BS 500D. REPAIRED SKIN PER SRM.SDR SWAA031015Stringer Clip · crackedDURING SCHEDULED SPECIAL VISIT, FOUND STRINGER TIE CLIPS CRACKED (2 EA) AT STR 8L, BS 380 & BS 400. REMOVED AND REPLACED STRINGER TIE CLIPS PER SRM.SDR SWAA030958Stringer Clip · crackedDURING SCHEDULED SPECIAL VISIT, FOUND STRINGER TIE CLIP CRACKED AT BS 787, STR 9R. REMOVED AND REPLACED STRINGER TIE CLIP PER SRM.SDR SWAA030740Battery Pack · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND SEVERAL EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA030460Skin · crackedDURING SCHEDULED RON, FOUND FUSELAGE SKIN CRACKED AT BS 500A, BETWEEN STR 16R AND STR 17R. REPAIRED SKIN PER SRM.SDR SWAA030010Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 440, STR 26L. REPAIRED SKIN PER SRM.SDR SWAA022743Skin · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN CRACKED AT BS 420, STR 10L. REPAIRED SKIN PER SRM.SDR SWAA022660Splice · crackedDURING SCHEDULED SPECIAL VISIT, FOUND STRINGER SPLICE CRACKED AT BS 360, STR 4L. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA022670Splice · crackedDURING SCHEDULED SPECIAL VISIT, FOUND STRINGER SPLICE CRACKED AT BS 908, STR 4L. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA022624Stringer Clip · crackedDURING SCHEDULED SPECIAL VISIT, FOUND STRINGER CLIPS CRACKED (3 EA) AT STR 4L AT BS 597 AND BS 616, STR 4R AT BS 559. REMOVED AND REPLACED STRINGER CLIPS PER SRM.SDR SWAA022100Skin · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN CRACKED AT BS 500C, STR 19R. REPAIRED SKIN PER SRM.SDR SWAA022099Skin · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN CRACKED (3 EA) AT STR 10L, BS 383, BS 494 AND BS 500 PLUS 15. REPAIRED SKIN PER SRM AND SWA EA.SDR SWAA022051Skin · crackedDURING WALK AROUND INSPECTION, FOUND FUSELAGE SKIN CRACKED AT BS 500C, STR 19R. REPAIRED SKIN PER SRM.SDR SWAA022030Skin · crackedDURING SCHEDULED BC3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 520, STR 10L. REPAIRED SKIN PER SRM.SDR SWAA021889Skin · crackedDURING SCHEDULED RON, FOUND FUSELAGE SKIN CRACKED AT BS 484, STR 16L. REPAIRED SKIN PER SRM.SDR SWAA021092Skin · crackedDURING SCHEDULED PM CHECK, FOUND FUSELAGE SKIN CRACKED (2 EA) AT STR 16R, BS'S 444 AND 466. REPAIRED SKIN PER SRM.SDR SWAA021091Skin · crackedDURING SCHEDULED PM CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 395, STR 15L. REPAIRED SKIN PER SRM.SDR SWAA021106Frame · crackedDURING SCHEDULED C2 CHECK, FOUND FRAME CRACKED AT FWD SVC DOOR UPPER HINGE CUTOUT. REPAIRED FRAME PER SWA RA.SDR SWAA020681Skin · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN CRACKED 3 INCHES AT BS 545, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA020351Window · crackedDURING SCHEDULED C1 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND VIEWING WINDOW CRACKED. REMOVED AND REPLACED WINDOW PER MM.SDR SWAA020350Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA020250Module · erraticLOWERED GEAR HANDLE AND NOSE GEAR DID NOT DROP. CYCLED HANDLE AND NOSE GEAR DROPPED. REMOVED AND REPLACED NOSE GEAR MODULE PER MM.SDR SWAA020041Actuator · faultyDURING GEAR EXTENSION, NOSE GEAR LIGHT REMAINED RED, WARNING HORN SOUNDED. PLACED LEVER UP AND GEAR RETRACTED. PLACED LEVER DOWN, THREE GREEN LIGHTS AND NORMAL LANDING. REMOVED AND REPLACED NOSE GEAR UPLOCK ACTUATOR AND ADJUSTED RT NLG DOOR PER MM.
Back to N309SW, cancelled May 22, 2017