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 SWAA096313Door Frame · crackedDURING SCHEDULED 26Y CHECK, FOUND R2 DOOR FWD FRAME CRACKED. REPAIRED FRAME PER SRM.SDR SWAA096312Skin · crackedDURING SCHEDULED 26Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER AAR EA.SDR SWAA096271Skin · crackedDURING SCHEDULED 26Y CHECK, FOUND SKIN CRACKED A FWD LOWER CORNER OF R2 COCKPIT WINDOW CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA096194Slide · out of positionDURING SCHEDULED 26Y CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MT.SDR SWAA096181Cap · crackedDURING SCHEDULED 26Y CHECK, FOUND AFT PRESSURE BULKHEAD CENTER DOME CAP CRACKED. REPAIRED DOME CAP PER AAR EA.SDR SWAA096180Wedge · delaminatedDURING SCHEDULED 26Y CHECK, FOUND LT WING I/B MIDFLAP WEDGE DELAMINATED. REMOVED AND REPLACED WEDGE ASSY PER SRM.SDR SWAA096179Fitting · corrodedDURING SCHEDULED 26Y CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE GIRT BAR FWD FITTING CORRODED. REMOVED AND REPLACED FITTING PER MM.SDR SWAA096083Floorbeam · crackedDURING SCHEDULED 26Y CHECK, FOUND LONGITUDINAL FLOORBEAM CENTER WEB CRACKED BETWEEN BS 708 TO BS 712, LBL 0.07. REMOVED AND REPLACED WEB SECTION PER SI.SDR SWAA093291Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 251.6, STR 24L. REPAIRED SKIN PER ER.SDR SWAA093290Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED FWD AND AFT OF LOWER AFT R1 PAX WINDOW, BS 358. REPAIRED SKIN PER AAR EA.SDR SWAA093212Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 707.3, STR 10R. REPAIRED SKIN PER ER.SDR SWAA093211Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 251.6, STR 24L. REPAIRED SKIN PER ER.SDR SWAA093210Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 358, BETWEEN STR 10R TO STR 14R. REPAIRED SKIN PER ER.SDR SWAA093209Light · brokenDURING SCHEDULED SPV CHECK, FOUND L1 DOOR EMERGENCY EXIT LIGHT BROKEN. REMOVED AND REPLACED LIGHT PER SRM.SDR SWAA093208Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 344, STR 11R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA093207Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO DOOR LOWER FWD FRAME CRACKED. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA093206Slat · delaminatedDURING SCHEDULED SPV CHECK, FOUND LT WING NR 3 SLAT DELAMINATED. REMOVED AND REPLACED SLAT PER MM.SDR SWAA093205Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 707, STR 10R. REPAIRED SKIN PER ER.SDR SWAA093204Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 251.6, STR 24L. REPAIRED SKIN PER ER.SDR SWAA092870Hinge · brokenDURING SCHEDULED 2HC2 CHECK, FOUND RT WING NR 5 GROUND SPOILER O/B ACTUATOR HINGE BROKEN. REMOVED AND REPLACED SPOILER PER MM.SDR SWAA092865Slide · out of adjustDURING SCHEDULED 2HC2 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MT.SDR SWAA091045Rib · crackedDURING SCHEDULED 24Y CHECK, FOUND RT HORIZONTAL WING FLANGE RIB CRACKED AT WBL 135, BETWEEN STR 2R TO STR 3R. REPAIRED RIB PER ACO.SDR SWAA091033Battery Pack · dischargedDURING SCHEDULED 24Y CHECK, FOUND RT AFT EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA091032Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 727E, BETWEEN STR 27L TO STR 27R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA091031Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 747, BETWEEN STR 26L TO STR 27L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA091030Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 767, BETWEEN STR 27L TO STR 26L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA091029Keelbeam · corrodedDURING SCHEDULED 24Y CHECK, FOUND KEEL BEAM CORRODED AT BS 767, STR 27L. REPAIRED BEAM PER SRM.SDR SWAA091028Skin · corrodedDURING SCHEDULED 24Y CHECK, FOUND SKIN CORRODED AT BS 617, BETWEEN LBL 6 TO RBL 6. REPAIRED SKIN PER SRM.SDR SWAA091027Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 559, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER ER.SDR SWAA090997Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL BEAM WEB CRACKED BETWEEN BS 705 TO BS 711, LBL 24. REPAIRED BEAM PER ER.SDR SWAA090996Wire · damagedDURING SCHEDULED 24Y CHECK, FOUND RT OVERWING EMERGENCY EXIT LIGHT INOP. REPAIRED WIRE PER WDM.SDR SWAA090831Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 380, BETWEEN STR 13L TO STR 14L. REPAIRED FRAME PER ER.SDR SWAA090830Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 500A, BETWEEN STR 13L TO STR 14L. REPAIRED FRAME PER ER.SDR SWAA090829Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR UPPER HINGE CUTOUT, BS 292, WL 259. REPAIRED SKIN PER SRM.SDR SWAA090796Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 727B, RBL 45. REPAIRED BEAM PER SWA EA.SDR SWAA090779Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 747, BETWEEN STR 26L TO STR 27R. REPAIRED SHEAR TIE PER SRM.SDR SWAA090778Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 787, BETWEEN STR 27L TO STR 26L. REPAIRED SHEAR TIE PER SRM.SDR SWAA090777Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 380, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER SWA EA.SDR SWAA090776Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL BEAM CRACKED AT BS 727B, RBL 45. REPAIRED BEAM PER ER.SDR SWAA090775Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER ER.SDR SWAA090750Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 787, BETWEEN STR 27L TO 27R. REPAIRED SHEAR TIE PER SRM.SDR SWAA090749Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 827, BETWEEN STR 27L TO 27R. REPAIRED SHEAR TIE PER SRM.SDR SWAA090748Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 927, BETWEEN STR 27L TO 27R. REPAIRED SHEAR TIE PER SRM.SDR SWAA090690Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 747, BETWEEN STR 25R TO STR 26R. REPAIRED SHEAR TIE PER SRM.SDR SWAA090689Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 727D, BETWEEN STR 25L TO STR 26L. REPAIRED SHEAR TIE PER SRM.SDR SWAA090688Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 727E, BETWEEN STR 25L TO STR 26L. REPAIRED SHEAR TIE PER SRM.SDR SWAA090687Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 747, BETWEEN STR 26L TO STR 25L. REPAIRED SHEAR TIE PER SRM.SDR SWAA090686Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 767, BETWEEN STR 27R TO STR 26R. REPAIRED SHEAR TIE PER SRM.SDR SWAA090685Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 787, BETWEEN STR 27L TO STR 27R. REPAIRED SHEAR TIE PER SRM.SDR SWAA090684Stringer · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CORRODED AT BS 927, STR 25L. REPAIRED STRINGER PER SRM.
Back to N693SW, cancelled Dec 8, 2014