N699SW, cancelled Oct 30, 2013
Service difficulty reports · 338
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 = 'N699SW' AND deregistration_id = 'N699SW-2013-10-30' 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 = 'N699SW' AND deregistration_id = 'N699SW-2013-10-30' 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 SWAA105212Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 6L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA105211Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 787, STR 25L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA105194Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 639, STR 3L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA105193Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 707, STR 11L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA105192Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 827, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA105191Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500A, STR 16L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA105206Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500, STR 16L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA105129Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 10R. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA105128Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 827, STR 1L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA105127Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 847, STR 1L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA105126Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 440, STR 28L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA105125Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 787, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME PER EA.SDR SWAA105045Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 420, STR 23R. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA105044Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 500C, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME PER EA.SDR SWAA105043Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME PER EA.SDR SWAA104815Slide · out of positionL1 DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT, DID NOT DEPLOY. RE-INSTALLED SLIDE PER MM AND MT.SDR SWAA103234Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND SKIN CRACKED AT BS 309.5, STR 23R. REPAIRED SKIN PER SRM.SDR SWAA103233Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND SKIN CRACKED AT BS 943, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA103232Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND SKIN CRACKED AT BS 913, STR 25L. REPAIRED SKIN PER SRM.SDR SWAA102871Uplock Sensor · out of adjustAIR TURNBACK, UNSAFE GEAR INDICATION RT MLG AFTER TAKEOFF WITH GEAR HANDLE OFF. WITH GEAR HANDLE DOWN NORMAL INDICATIONS AND NORMAL LANDING WEIGHT. ADJUSTED RT UPLOCK SENSOR, TARGET AND GAP PER MM.SDR SWAA102710Circuit Card · faultyAIR TURNBACK - UNSAFE GEAR INDICATION RIGHT SIDE RIGHT AFTER TAKEOFF. ALL OTHER INDICATIONS NORMAL. LANDED WITHOUT INCIDENT. REMOVED AND REPLACED M982 PC CARD PER MM.SDR SWAA101907Outflow Valve · faultyDIVERSION / DECLARED EMERGENCY. EN ROUTE FL 320 CABIN PRESSURIZATION FAILURE. CABIN ALT 10,500 MANUAL FOCC CLOSED DC STABILIZED CABIN ALT 10,300. NO FURTHER DECREASE. REMOVED AND REPLACED OUTFLOW VALVE AND CABIN PRESSURE CONTROLLER PER MT.SDR SWAA100037Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED BETWEEN BS 314 TO BS 317, STR 25L. REPAIRED SKIN PER SRM.SDR SWAA097506Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND SKIN CRACKED AT BS 970, STR 21L. REPAIRED SKIN PER ER.SDR SWAA097505Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND SKIN CRACKED AT BS 931, STR 21R. REPAIRED SKIN PER ER.SDR SWAA097504Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND SKIN CRACKED AT BS 586, STR 10L. REPAIRED SKIN PER ER.SDR SWAA097498Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND SKIN CRACKED AT BS 305, STR 18R. REPAIRED SKIN PER ER.SDR SWAA097473Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 970, STR 21L. REPAIRED SKIN PER EA.SDR SWAA097472Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 931, STR 21R. REPAIRED SKIN PER EA.SDR SWAA097471Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 586, STR 10L. REPAIRED SKIN PER EA.SDR SWAA097470Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 305, STR 18R. REPAIRED SKIN PER ER.SDR SWAA097034Crease Beam · crackedDURING SCHEDULED SPV CHECK, FOUND CREASE BEAM CRACKED AT BS 312, LBL 60. REPAIRED BEAM PER SRM.SDR SWAA096975Floorbeam · crackedDURING SCHEDULED SPV CHECK, FOUND FLOORBEAM CRACKED AT BS 312, LBL 60. REPAIRED BEAM PER SRM.SDR SWAA096974Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 500D, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR SWAA096973Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND LT EMERGENCY EXIT SIDEWALL LIGHT INOP. RELAMPED PER MM.SDR SWAA095379Sign · missingRIGHT FWD OVERWING EMERGENCY EXIT SIGN MISSING. INSTALLED SIGN PER MM.SDR SWAA094218Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 514D TO BS 518D, STR 12L. REPAIRED SKIN PER SRM AND EA.SDR SWAA094219Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 515B TO BS 514D, STR 15L TO STR 16L. REPAIRED SKIN PER SRM AND EA.SDR SWAA094217Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 770 TO BS 780, STR 18L TO STR 19L. REPAIRED SKIN PER SRM AND EA.SDR SWAA093973Lens · missingRT EMERGENCY EXIT BULLNOSE LIGHT LENS MISSING. INSTALLED LENS PER MM.SDR SWAA093969Lens · missingRT EMERGENCY EXIT BULLNOSE LIGHT LENS MISSING. INSTALLED LENS PER MM.SDR SWAA093178Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND SKIN CRACKED AT BS 931, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA093177Slide · out of adjustDURING SCHEDULED HC1 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MT.SDR SWAA092390Flap · delaminatedDURING SCHEDULED MV2 CHECK, FOUND RT WING I/B FORE FLAP DELAMINATED. REMOVED AND REPLACED FORE FLAP PER MM.SDR SWAA091846Slide · out of positionL1 DOOR EMERGENCY EVACUATION SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MT.SDR SWAA090799Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND SKIN CRACKED AT BS 907, STR 24R. REPAIRED SKIN PER SRM.SDR SWAA090798Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND SKIN CRACKED AT BS 500D, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA090797Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND SKIN CRACKED AT BS 460, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA086739Slide · out of positionFOUND L1 DOOR SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR SWAA085082Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 765, STR 19R. REPAIRED SKIN PER EA.
Back to N699SW, cancelled Oct 30, 2013