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 SWAA106270Stringer Clip · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CORRODED AT BS 794.3, STR 26R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA106217Bulkhead · crackedDURING SCHEDULED 24Y CHECK, FOUND BULKHEAD VERTICAL BEAM WEB CRACKED AT BS 178, RBL 5.7. REMOVED AND REPLACED WEB PER EA.SDR SWAA106216Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500D, STR 7L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA106215Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 259, STR 6L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA106214Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 460, BETWEEN STR 13R TO STR 14R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA106213Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 767, STR 27L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA106212Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 787, STR 27L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA106145Shear Tie · crackedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CRACKED AT BS 727C, BETWEEN STR 13L TO STR 14L. REPAIRED SHEAR TIE PER SRM.SDR SWAA106083Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 259, STR 8L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA106082Shear Tie · crackedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CRACKED AT BS 807, BETWEEN STR 27L TO STR 27R. R&R SHEAR TIE PER SRM.SDR SWAA105886Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 500D, BETWEEN STR 13L TO STR 14L. REPAIRED FRAME PER EA.SDR SWAA105885Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 807, BETWEEN STR 27L TO STR 27R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA105743Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 887, STR 1L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA105719Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727E, STR 5R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA105681Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 15R. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA105680Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 827, BETWEEN BBL 0 TO RBL 4. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA105701Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 807, STR 11R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA105630Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 1006, STR 13R. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA105629Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 1006, STR 12R. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA105628Shear Tie · crackedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE ANGLE CRACKED AT BS 303, STR 15L. REMOVED AND REPLACED ANGLE PER BAC DWG.SDR SWAA105627Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 9R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA105626Channel · crackedDURING SCHEDULED 24Y CHECK, FOUND SPLICE CHANNEL CRACKED AT BS 360, STR 15L. REMOVED AND REPLACED CHANNEL PER SRM AND BAC DWG.SDR SWAA105625Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 827, BETWEEN STR 26R TO STR 27R. REMOVED AND REPLACED SHEAR TIE PER BAC DWG.SDR SWAA105557Angle · crackedDURING SCHEDULED 24Y CHECK, FOUND VERTICAL FRAME ANGLE CRACKED AT BS 727B, LBL 45.5. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA105556Web · corrodedDURING SCHEDULED 24Y CHECK, FOUND WEB SUPPORT CORRODED BETWEEN BS 440 TO BS 500, RBL 22. REMOVED AND REPLACED WEB PER SRM AND BAC DWG.SDR SWAA105532Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 480, STR 1L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA105531Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 1L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA105530Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 11R. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA105529Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727, STR 11R. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA105528Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500B, STR 16R. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA105527Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 420, STR 28L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA105526Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 787, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME PER SWA EA.SDR SWAA105523Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 6R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA105522Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 827, STR 11L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA105499Attach Bracket · looseDURING SCHEDULED 24Y CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE GIRT BAR ATTACH BRACKETS LOOSE. REMOVED AND REPLACED BRACKETS PER SRM.SDR SWAA105381Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500A, STR 15L. REMOVED AND REPLACED CLIP PER BAC DWG.SDR SWAA105380Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500A, STR 14L. REMOVED AND REPLACED CLIP PER BAC DWG.SDR SWAA105347Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 4R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA105346Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 7R. REMOVED AND REPLACED CLIP PER SI.SDR SWAA105314Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727E, STR 4R. REPAIRED CLIP PER SRM.SDR SWAA105313Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 807, STR 4L. REPAIRED CLIP PER SRM.SDR SWAA105312Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 907, STR 10L. REPAIRED CLIP PER SRM.SDR SWAA105311Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500, STR 15L. REPAIRED CLIP PER SRM.SDR SWAA105310Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 360, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER EA.SDR SWAA105309Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STR 20L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA105291Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 887, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME PER ER AND EA.SDR SWAA105290Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 847, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME PER ER AND EA.SDR SWAA105276Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 727C, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME PER EA.SDR SWAA105275Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 767, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME PER
EA.SDR SWAA105214Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 4L. REMOVED AND REPLACED CLIP PER SRM.
Back to N699SW, cancelled Oct 30, 2013