N645SW, cancelled Nov 20, 2017
Service difficulty reports · 286
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 = 'N645SW' AND deregistration_id = 'N645SW-2017-11-20' 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 = 'N645SW' AND deregistration_id = 'N645SW-2017-11-20' 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 SWAA092271Keelbeam · corrodedDURING SCHEDULED 12Y CHECK, FOUND KEEL BEAM CORRODED AT BS 613, WL 148. REPAIRED BEAM PER SRM.SDR SWAA092144Stringer Clip · corrodedDURING SCHEDULED 12Y CHECK, FOUND STRINGER CLIP CORRODED AT BS 847, STR 26R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA092143Shear Tie · corrodedDURING SCHEDULED 12Y CHECK, FOUND SHEAR TIE CORRODED AT BS 500C, BETWEEN STR 28L TO STR 28R. REPAIRED SHEAR TIE PER SRM.SDR SWAA092142Shear Tie · corrodedDURING SCHEDULED 12Y CHECK, FOUND SHEAR TIE CORRODED AT BS 500B, BETWEEN STR 28L TO STR 28R. REPAIRED SHEAR TIE PER SRM.SDR SWAA092083Stringer Clip · crackedDURING SCHEDULED 12Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 18R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA085113Flap · delaminatedDURING SCHEDULED SPV CHECK, FOUND LT WING INBOARD FORE FLAP DELAMINATED. REPAIRED FLAP PER SRM.SDR SWAA084329Slide · out of positionL1 DOOR EMERGENCY EVAC SLIDE FELL OUT, DID NOT DEPLOY. INSTALLED EVAC SLIDE PER MM.SDR SWAA083162Slide · out of adjustR1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA082551Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND LT AFT FUSELAGE EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA082142Slide · out of adjustDURING SCHEDULED HC2 CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA082143Skin · delaminatedDURING SCHEDULED HC2 CHECK, FOUND RT WING INBOARD FOREFLAP UPPER SURFACE DELAMINATED. REMOVED AND REPLACED FLAP PER MM.SDR SWAA081859Flashlight · inoperativeFWD CABIN EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED FLASHLIGHT PER MM.SDR SWAA080598Lens · brokenR2 DOOR EMERGENCY EXIT LIGHT LENS BROKEN. REMOVED AND REPLACED LIGHT LENS PER MM.SDR SWAA075457Slide · out of adjustL2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA075022Flap · delaminatedDURING SCHEDULED HC1 CHECK, FOUND LEFT WING OUTBOARD T/E AFT FLAP DELAMINATED AT INBOARD END. REMOVED AND REPLACED FLAP PER MM.SDR SWAA073353Flashlight · inoperativeDURING SCHEDULED MV4 CHECK, FOUND FWD CABIN EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED FLASHLIGHT PER MM.SDR SWAA071726Torque Tube · corrodedDURING SCHEDULED 10Y CHECK, FOUND RIGHT WING INBOARD MID FLAP OUTBOARD TORQUE TUBE CORRODED. REMOVED AND REPLACED MID FLAP PER MM.SDR SWAA071725Torque Tube · corrodedDURING SCHEDULED 10Y CHECK, FOUND RIGHT WING INBOARD MID FLAP INBOARD TORQUE TUBE CORRODED. REMOVED AND REPLACED MID FLAP PER MM.SDR SWAA071525Skin · delaminatedDURING SCHEDULED 10Y CHECK, FOUND LEFT WING OUTBOARD T/E AFT FLAP DELAMINATED AT INBOARD LOWER SURFACE. REPAIRED FLAP PER SRM.SDR SWAA071484Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071483Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071485Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071488Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L AND STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071486Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071487Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L AND STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071482Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071481Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071480Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071489Vertical Beam · crackedDURING SCHEDULED 10Y CHECK, FOUND VERTICAL BEAM WEB CRACKED AT BS 184, RBL 17.1. REPAIRED WEB PER SRM.SDR SWAA071490Vertical Beam · crackedDURING SCHEDULED 10Y CHECK, FOUND VERTICAL BEAM WEB CRACKED AT BS 184, LBL 17.1. REPAIRED WEB PER SRM.SDR SWAA071461Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8R. REPAIRED FRAME PER SRM.SDR SWAA071460Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 616, STR 17L AND STR 17R. REPAIRED FRAME PER SRM.SDR SWAA071462Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SRM.SDR SWAA071370Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STR CLIP CRACKED AT BS 663, STR 10R. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA071372Attach Fitting · corrodedDURING SCHEDULED BRDG CHECK, L1 DOOR EVACUATION SLIDE GIRT BAR AFT FLOOR ATTACH FITTING CORRODED. REMOVED AND REPLACED AFT FITTING PER SRM.SDR SWAA071371Attach Fitting · corrodedDURING SCHEDULED BRDG CHECK, L1 DOOR EVACUATION SLIDE GIRT BAR FWD FLOOR ATTACH FITTING CORRODED. REMOVED AND REPLACED FWD FITTING PER SRM.SDR SWAA070237Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA070236Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA064443Controller · failedFIRST OFFICER NOTICED ARCHING ON FLIGHT DECK R2 WINDOW. REMOVED AND REPLACED WINDOW AND HEAT CONTROLLER PER MM.SDR SWAA063753Skin · delaminatedDURING SCHEDULED C4 CHECK, FOUND RT WING NR 5 L/E SLAT OUTBOARD T/E WEDGE DELAMINATED. REMOVED AND REPLACED NR 5 L/E SLAT PER MM.SDR SWAA063752Skin · crackedDURING SCHEDULED C4 CHECK, FOUND KEEL BEAM SKIN CRACKED AT BS 680 TO BS 716, RBL 1.5. REPAIRED SKIN PER SRM.SDR SWAA063751Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA062223Bolt · wornDURING SCHEDULED C3 CHECK, LT ELEVATOR CONTROL TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED OUTBOARD ELEVATOR TAB ROD END BOLT PER MM.SDR SWAA060193Slide · dislodgedL1 DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA053962Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT AFT CARGO DOOR CUTOUT, FWD FRAME NR 5 STOP FITTING. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA053961Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND BS 178 BLKHD SIDE CHORDS CRACKED AT WL 207. REMOVED AND REPLACED SIDE CHORDS PER SRM AND SWA ACO.SDR SWAA053209Light · brokenAFT GALLEY EMERGENCY EXIT LIGHT BROKEN. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA052917Slide · out of adjustL1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA052472Lens · missingDURING SCHEDULED C4 CHECK, FOUND EMERGENCY EXIT LIGHT LENS MISSING ABOVE ROW 2 DEF. INSTALLED LENS PER MM.SDR SWAA050338Lamp · inoperativeDURING SCHEDULED C2 CHECK, FOUND L2 DOOR LOWER EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER MM.
Back to N645SW, cancelled Nov 20, 2017