N693SW, cancelled Dec 8, 2014
Service difficulty reports · 443
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 = 'N693SW' AND deregistration_id = 'N693SW-2014-12-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 = 'N693SW' AND deregistration_id = 'N693SW-2014-12-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 SWAA062460Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 750, STR 18R. REPAIRED SKIN PER SWA EA.SDR SWAA062459Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 785, STR 19L. REPAIRED SKIN PER SWA EA.SDR SWAA062458Glowstrip · wornDURING SCHEDULED C3 CHECK, FOUND EEPLS PHOTOLUMINESCENT STRIP WORN AT ROW 8 ABC. REMOVED AND REPLACED EEPLS PHOTOLUMINESCENT STRIP PER MM.SDR SWAA061886Light · inoperativeDURING SCHEDULED MV1 CHECK, FOUND FWD ENTRY DOOR LOWER EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA061115Light · brokenL1 DOOR EMERGENCY EXIT LIGHT BROKEN. R&R SIGN ASSY PER WDM.SDR SWAA060094Bulb · inoperativeDURING SCHEDULED C1 CHECK, FOUND LT WING EXTERIOR EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT IAW MM.SDR SWAA053981Light · looseEEPLS TRACK LOOSE AT ROW 8 ABC. SECURED EEPLS PER MM.SDR SWAA053367Actuator · faultyRT MLG EXTENDED WITH GEAR HANDLE IN "OFF" POSITION. RECYCLED GEAR HANDLE-GEAR RETRACTED. REMOVED AND REPLACED RT MLG UPLOCK ACTUATOR PER MM.SDR SWAA053103Flashlight · activatedAFT GALLEY INBD EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED FLASHLIGHT PER MM.SDR SWAA053027Control Cable · brokenLT WING INBD T/E FLAP BOOM CABLE BROKEN. REMOVED AND REPLACED BOOM CABLES BC-3 AND BC-4 PER MM.SDR SWAA052988Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 767, STR 22L. REPAIRED SKIN PER SRM.SDR SWAA052987Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 806, STR 20L. REPAIRED SKIN PER SRM.SDR SWAA052939Charger · inoperativeDURING SCHEDULED RON CHECK, FOUND FWD CABIN SIDEWALL EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY CHARGER PER MM.SDR SWAA052389Wheel · separatedNR 1 MAIN TIRE RETREAD SEPARATED. FOUND LT INBD T/E FOREFLAP AND GROUND SPOILER DAMAGED. REMOVED AND REPLACED NR 1 MAIN TIRE/WHEEL ASSY, LT INBD T/E FOREFLAP AND GROUND SPOILER PER MM.SDR SWAA052182Slide · dischargedR2 DOOR EMERGENCY EVAC SLIDE PRESSURE INDICATING LOW. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA051857Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727E + 14, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA051776Frame · crackedDURING SCHEDULED C3 CHECK, FOUND FWD CARGO DOOR CUTOUT AFT FRAME CRACKED AT NR 2 STOP FITTING CUTOUT. REPAIRED FRAME PER SWA EA.SDR SWAA050657Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND CRACKED STUB FRAME AT BS 360, BETWEEN STR 14L & STR 15L. REMOVED AND REPLACED STUB FRAME PER SRM.SDR SWAA050656Keelbeam · corrodedDURING SCHEDULED SPECIAL VISIT, FOUND CORROSION ON LT FUSELAGE KEELBEAM AT BS 540. REPAIRED KEEL BEAM PER SRM & ER.SDR SWAA050648Stringer Clip · crackedDURING SCHEDULED SPECIAL VISIT, FOUND CRACKED STRINGER CLIP AT BS 787, STR 9R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA050647Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE BELT FRAME CRACKED AT BS 360, STR 14R. REPAIRED BELT FRAME PER SRM.SDR SWAA050624Stringer Clip · crackedDURING SCHEDULED SPECIAL VISIT, FOUND STRINGER CLIP CRACKED AT STR 9L, BS 500A. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA050623Stringer Clip · crackedDURING SCHEDULED SPECIAL VISIT, FOUND CRACKED STRINGER CLIP AT STR 9L, BS 400. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA050622Stringer Clip · crackedDURING SCHEDULED SPECIAL VISIT, FOUND CRACKED STRINGER CLIP AT BS 807, STR 9R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA050621Attach Angle · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME TO SKIN ATTACH ANGLE CRACKED AT BS 400, STR 14L. REPAIRED FUSELAGE ATTACH ANGLE PER SRM.SDR SWAA050605Stringer Clip · crackedDURING SCHEDULED SPECIAL VISIT, FOUND CRACKED STRINGER CLIP AT BS 807, STR 9R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA050563Fitting · crackedDURING SCHEDULED SPECIAL VISIT, FOUND R1 DOOR ESCAPE SLIDE GIRT BAR, AFT FLOOR FITTING CRACKED. REMOVED AND REPLACED R1 DOOR ESCAPE SLIDE FLOOR FITTING PER MM.SDR SWAA050326Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN AT BS 747, STRINGER 21R, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA050287Battery · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND FWD CABIN EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA043686Skin · crackedDURING SCHEDULED A2 CHECK, FOUND FUSELAGE SKIN AT BS 294.5 + 16, STRINGER 18R, CRACKED. REPAIRED SKIN PER EA.SDR SWAA043685Skin · crackedDURING SCHEDULED A2 CHECK, FOUND FUSELAGE SKIN AT BS 518, STRINGER 12R, CRACKED. REPAIRED SKIN PER EA.SDR SWAA043629Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 885, ABOVE STRINGER 24R, CRACKED. REPAIRED SKIN PER EA.SDR SWAA042768Battery · inoperativeDURING SCHEDULED A1 CHECK, FOUND RT FWD SIDEWALL EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA042633Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 767, STRINGER 20L, CRACKED. REPAIRED SKIN PER EA.SDR SWAA042614Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 767, STRINGER 20L, CRACKED. REPAIRED SKIN PER EA.SDR SWAA042184Lamp · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND R2 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA042183Battery · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND L1 & L2 & OVERWING EXIT LOWER EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED EMERGENCY LIGHTS BATTERY PER MM.SDR SWAA042176Stringer · corrodedDURING SCHEDULED SERVICE CHECK, FOUND STRINGER 26R, BS 500A, CORRODED. REPAIRED STRINGER PER SRM.SDR SWAA041398Keelbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND KEELBEAM CHORD AT BS 500D + 2, RBL 6, CORRODED. REPAIRED KEELBEAM CHORD PER EA.SDR SWAA041397Floorbeam · crackedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM AT BS 660, BL 0, CRACKED. REPAIRED FLOORBEAM PER EA.SDR SWAA041396Stringer Clip · corrodedDURING SCHEDULED 1/4D CHECK, FOUND STRINGER TIE CLIP AT BS 787, STRINGER 26R, CORRODED. REMOVED AND REPLACED STRINGER TIE CLIP PER SRM.SDR SWAA041399Doubler · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE DOUBLER AT BS 727D, BL 0, CORRODED. REMOVED AND REPLACED DOUBLER PER SRM.SDR SWAA041389Pressure Panel · crackedDURING SCHEDULED 1/4D CHECK, FOUND LT MLG BEADED PRESSURE WEB AT BS 664, LBL 39.5, CRACKED. REPAIRED PRESSURE WEB PER EA.SDR SWAA041373Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND R1 DOOR AFT FRAME CUTOUT AT UPPER STOP CRACKED. REPAIRED SKIN PER SRM.SDR SWAA041360Frame · corrodedDURING SCHEDULED 1/4D CHECK, BELT FRAME AT BS 827, RBL 9, CORRODED. REPAIRED BELT FRAME PER SRM.SDR SWAA041359Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM AT BS 727C + 7, LBL 8, CORRODED. REPAIRED FLOORBEAM PER EA.SDR SWAA041345Skin · delaminatedDURING SCHEDULED 1/4D CHECK, FOUND RT WING INBOARD FORE FLAP DELAMINATED. REPAIRED RT WING INBOARD FORE FLAP PER SRM.SDR SWAA041344Skin · delaminatedDURING SCHEDULED 1/4D CHECK, FOUND RT WING INBOARD AFT T/E FLAP DELAMINATED. REMOVED AND REPLACED INBOARD AFT FLAP PER MM.SDR SWAA041298Wedge · crackedDURING SCHEDULED 1/4D CHECK, FOUND RT WING INBOARD MID FLAP WEDGE, CRACKED. REPAIRED RT WING MID FLAP WEDGE PER SRM.SDR SWAA041297Keelbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND AFT CARGO KEELBEAM WEB AT BS 807 TO BS 827, RBL 7, CORRODED. REMOVED AND REPLACED KEEL BEAM WEB PER SRM.
Back to N693SW, cancelled Dec 8, 2014