N339SW, cancelled Feb 16, 2018
Service difficulty reports · 323
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 = 'N339SW' AND deregistration_id = 'N339SW-2018-02-16' 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 = 'N339SW' AND deregistration_id = 'N339SW-2018-02-16' 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 SWAA074086Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BS 410, RBL 5. REPAIRED SKIN PER EA.SDR SWAA073977Light · inoperativeDURING SCHEDULED SPV CHECK, FOUND L1 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA073955Light · inoperativeDURING SCHEDULED SPV CHECK, FOUND R2 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA073956Light · inoperativeDURING SCHEDULED SPV CHECK, FOUND RT OVERWING EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA073389Stringer Clip · crackedDURING SCHEDULED SERVICE CHECK, FOUND STRINGER CLIP CRACKED AT BS 520, STR 16R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073388Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 515D, STR 15R. REPAIRED SKIN PER SWA EA.SDR SWAA072691Slide · out of adjustR2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA072680Slide · out of adjustDURING SCHEDULED A2 CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA071603Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 924, STR 23L. REPAIRED SKIN PER SWA EA.SDR SWAA070377Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 550, STR 15R. REPAIRED SKIN PER SWA EA.SDR SWAA070376Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 540, STR 19R. REPAIRED SKIN PER SRM.SDR SWAA070375Attach Fitting · brokenDURING SCHEDULED C1 CHECK, FOUND LT WING NR 4 GROUND SPOILER OUTBOARD ACTUATOR ATTACH POINT BROKEN ON SPOILER SIDE. REMOVED AND REPLACED NR 4 SPOILER PER MM.SDR SWAA070374Flap · delaminatedDURING SCHEDULED C1 CHECK, FOUND LT WING OUTBOARD T/E AFT FLAP DELAMINATED AT T/E OUTBOARD END. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA064402Controller · failedFLIGHT COMPT L2 WINDOW ARCHED AT LOWER FWD CORNER. REMOVED AND REPLACED L2 WINDOW AND WINDOW HEAT CONTROLLER PER MM.SDR SWAA064361Lens · dislodgedL1 DOOR EMERGENCY EXIT LIGHT LENS FELL OFF. INSTALLED LIGHT LENS PER MM.SDR SWAA063920Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA063919Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA062243Glowstrip · wornDURING SCHEDULED C3 CHECK, FOUND EEPLS PHOTOLUMINESCENT STRIP WORN AT ROW 12 DEF TO ROW 14 DEF. REMOVED AND REPLACED PHOTOLUMINESCENT STRIP PER MM.SDR SWAA061033Bulb · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND L1 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA061010Cable Assy · misroutedDURING SCHEDULED C2 CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE LATCH CABLE ASSY MISROUTED. REROUTED CABLE ASSY PER MM.SDR SWAA060737Bulb · inoperativeDURING SCHEDULED 1/4D CHECK, FOUND EMERGENCY EXIT LIGHT INOP BETWEEN ROW 16 TO ROW 17. RELAMPED LIGHT PER MM.SDR SWAA060697Container · crackedDURING SCHEDULED 1/4D CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE CONTAINER CRACKED AT GIRT BAR RETAINING BRACKET. REMOVED AND REPLACED SLIDE CONTAINER PER MM.SDR SWAA060696Floorbeam · crackedDURING SCHEDULED 1/4D CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 663, BL 0. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA060695Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE BELT FRAME CRACKED AT BS 616, LBL 65. REPAIRED BELT FRAME PER SWA SRM.SDR SWAA060694Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500C, STR 21R. REPAIRED SKIN PER SWA EA.SDR SWAA060693Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500B, STR 21L. REPAIRED SKIN PER SWA EA.SDR SWAA060692Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR CUTOUT, FWD LOWER CORNER. REPAIRED SKIN PER SRM.SDR SWAA060691Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR CUTOUT, FWD LOWER CORNER. REPAIRED SKIN PER SRM.SDR SWAA060674Keelbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE KEEL BEAM CORRODED AT BS 500D, RBL 8. REPAIRED KEEL BEAM PER SRM.SDR SWAA060673Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, STR 21R. REPAIRED FRAME PER SWA EA & SRM.SDR SWAA060672Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 515D, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA060668Tab · delaminatedDURING SCHEDULED 1/4D CHECK, FOUND RT WING AILERON TAB DELAMINATED AT OUTBOARD END. REMOVED AND REPLACED TAB PER MM.SDR SWAA054081Battery Pack · inoperativeDURING SCHEDULED A1 CHECK, FOUND L1 DOOR INTERIOR & EXTERIOR EMERGENCY EXIT LIGHTS INOP. SECURED BATTERY PACK PER MM.SDR SWAA053826Bulb · inoperativeDURING SCHEDULED C1 CHECK, FOUND R2 DOOR LOWER EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT IAW MM.SDR SWAA052480Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 945.5, STR 25R. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA052423Hook · out of positionR2 DOOR EMERGENCY EVAC SLIDE GIRT BAR HOOKS OUT OF POSITION. REPOSITIONED HOOKS PER MM.SDR SWAA051365Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA051358Lock Ring · missingL1 DOOR WOULD NOT OPEN. INSTALLED UPPER GUIDE ARM LOCK RING PER MM.SDR SWAA050882Cable · misroutedDURING SCHEDULED RON CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE LATCH CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA042563Hook · looseR2 DOOR EVAC SLIDE GIRT BAR AFT DOOR HOOK LOOSE. SECURED AFT GIRT BAR HOOK PER MM.SDR SWAA042224Shear Tie · crackedDURING SPV, FOUND SHEAR TIE AT BS 360, STRINGER 14L, CRACKED. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA042189Hook · corrodedDURING SPV, FOUND R1 DOOR EVAC SLIDE GIRT BAR HOOKS, CORRODED. REMOVED AND REPLACED R1 DOOR EVAC SLIDE GIRT BAR HOOKS PER MM.SDR SWAA042136Shear Tie · crackedDURING SPV, FOUND SHEAR TIE AT BS 360, STRINGER 14R CRACKED. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA042135Splice · crackedDURING SPV, FOUND STRINGER SPLICE AT BS 360, STRINGER 4L CRACKED. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA042139Frame · crackedDURING SPV, FOUND FRAME AT BS 520, STRINGER 12L, CRACKED. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA042138Frame · crackedDURING SPV, FOUND FRAME AT BS 380, STRINGER 15R, STRINGER 16R, CRACKED. REPAIRED FRAME SECTIONS PER SRM.SDR SWAA042137Shear Tie · corrodedDURING SPV, FOUND SHEAR TIE AT BS 420, STRINGER 10R, CORRODED. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA042108Splice · crackedDURING SPV, FOUND STRINGER SPLICE AT BS 908, STRINGER 4L, CRACKED. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA042107Skin · crackedDURING SPV, FOUND BUTT STRAP AT BS 908, STRINGER 4R, CRACKED. REPAIRED STRAP PER SRM.SDR SWAA042109Shear Tie · crackedDURING SPV, FOUND SHEAR TIE AT BS 360, STRINGER 14R, CRACKED. REMOVED AND REPLACED SHEAR TIE PER SRM.
Back to N339SW, cancelled Feb 16, 2018