N646SW, cancelled Nov 20, 2017
Service difficulty reports · 356
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 = 'N646SW' AND deregistration_id = 'N646SW-2017-11-20' 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 = 'N646SW' AND deregistration_id = 'N646SW-2017-11-20' 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 SWAA2012061104842Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED BETWEEN BS 727B TO BS 727C. REMOVED AND REPLACED WEB IAW SRM AND DWG.SDR SWAA2012062005111Web · corrodedR2 DOOR WEB CORRODED ON BOTTOM OF WEB AT STA 967. REMOVED AND REPLACED WEB IAW BAC DWG & SRM.SDR SWAA2012061104805Bulkhead · crackedVERTICAL BEAM WEB CRACKED BETWEEN BS 178 TO BS 184, LBL 17. REPAIRED WEB IAW SRM.SDR SWAA2012062605331Floorbeam · corrodedFLOORBEAM CORRODED AT BS 986 UPPER FLANGE LOWER SIDE FLOORBOARD ATTACH HOLES. REPAIRED BEAM PER EA.SDR SWAA2012062605309Angle · crackedVERTICAL SUPPORT FRAME ANGLE CRACKED BS 178 TO BS 188, RBL 17.1. REPAIRED ANGLE IAW EA.SDR SWAA2012060604702Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED BETWEEN BS 727E TO BS 727D. REMOVED AND REPLACED WEB IAW SRM.SDR SWAA2012061204870Anchor Fitting · corrodedL1 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR ANCHOR PLATE CORRODED AT BS 346. REMOVED AND REPLACED BRACKET IAW SRM AND DWG.SDR SWAA2012060504676Rib · crackedLEFT WING O/B MID FLAP CENTER FOR FLAP AUX TRACK I/B RIB CRACKED. REMOVED AND REPLACED RIB PER SRM.SDR SWAA2012062005110Web · corrodedFLOOR WEB CORRODED BETWEEN STA 980 TO STA 1016. REMOVED AND REPLACED WEB IAW BAC DWG.SDR SWAA2012062005109Angle · corrodedR2 DOOR Z-ANGLE CORRODED BETWEEN STA 960 TO STA 1016. REMOVED AND REPLACED CHORD IAW BAC DWG.SDR SWAA2012060404585Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED AT BS 747. REMOVED AND REPLACED WEB IAW SRM.SDR SWAA2012060404584Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED AT BS 767. REMOVED AND REPLACED WEB IAW SRM.SDR SWAA2012060404583Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 727A, STR 25L. REMOVED AND REPLACED CLIP PER SRM AND BOEING DWG.SDR SWAA2012022701754Slide · out of positionR1 DOOR EMERGENCY ESCAPE SLIDE INADVERTANTLY FELL OUT OF CASE, DID NOT DEPLOY, STILL OPERATIONAL. RE-INSTALLED SLIDE PER MT.SDR SWAA20111215484Cover · missingDURING SCHEDULED HC1 CHECK FOUND, LT OVERHEAD EMERGENCY EXIT SIGN COVER MISSING AT ROW 2. REMOVED AND REPLACED COVER PER MM.SDR SWAA20111207344Panel · delaminatedLT WING NR 3 FLIGHT SPOILER PANEL DELAMINATED. REMOVED AND REPLACED SPOILER PANEL IAW MM.SDR SWAA118104Skin · crackedDURING SCHEDULED SPV CHECK, FOUND LT WING NR 2 SLAT LOWER L/E SKIN CRACKED. REPAIRED SKIN IAW SRM.SDR SWAA118103Skin · crackedDURING SCHEDULED SPV CHECK, FOUND RT WING NR 6 SLAT LOWER L/E SKIN CRACKED. REPAIRED SKIN IAW SRM.SDR SWAA111553Cover · brokenR1 DOOR EMERGENCY EXIT LIGHT COVER BROKEN. REMOVED AND REPLACED COVER PER MM.SDR SWAA111552Slide · out of positionR1 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR SWAA111059Holder · crackedDURING SCHEDULED 14Y CHECK, FOUND I/B EMERGENCY FLASHLIGHT HOLDER ON FWD LAV WALL CRACKED. REMOVED AND REPLACED HOLDER PER MM.SDR SWAA111058Shear Tie · corrodedDURING SCHEDULED 14Y CHECK, FOUND SHEAR TIE CORRODED AT BS 500A, BETWEEN STR 28L TO STR 28R. REPAIRED SHEAR TIE PER SRM.SDR SWAA111057Light · brokenDURING SCHEDULED 14Y CHECK, FOUND L1 GALLEY OVERHEAD EMERGENCY EXIT LIGHT BROKEN. REMOVED AND REPLACED LIGHT PER MM.SDR SWAA111056Shear Tie · corrodedDURING SCHEDULED 14Y CHECK, FOUND SHEAR TIE CORRODED AT BS 747, BETWEEN STR 26R TO STR 27R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA111055Skin · delaminatedDURING SCHEDULED 14Y CHECK, FOUND LT WING I/B FORE FLAP UPPER SURFACE DELAMINATED. REPAIRED FORE FLAP PER SRM.SDR SWAA111017Shear Tie · corrodedDURING SCHEDULED 14Y CHECK, FOUND SHEAR TIE CORRODED AT BS 787, BETWEEN STR 26R TO STR 27R. REPAIRED SHEAR TIE PER SRM.SDR SWAA111016Stringer Splice · crackedDURING SCHEDULED 14Y CHECK, FOUND STRINGER SPLICE CRACKED AT BS 908, STR 4L. REMOVED AND REPLACED SPLICE PER SRM.SDR SWAA110916Stringer Splice · crackedDURING SCHEDULED 14Y CHECK, FOUND STRINGER SPLICE CRACKED AT BS 907, STR 4R. REMOVED AND REPLACED SPLICE PER SRM.SDR SWAA110915Stringer Clip · crackedDURING SCHEDULED 14Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 7R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA110914Stringer Clip · crackedDURING SCHEDULED 14Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 7R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA110913Stringer Clip · crackedDURING SCHEDULED 14Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 7R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA110912Stringer Clip · crackedDURING SCHEDULED 14Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 7R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA110911Stringer Clip · crackedDURING SCHEDULED 14Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 5R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA110910Stringer Clip · crackedDURING SCHEDULED 14Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 4R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA110909Stringer Clip · crackedDURING SCHEDULED 14Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 639, STR 3R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA110908Stringer Clip · crackedDURING SCHEDULED 14Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 4R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA110907Stringer Clip · crackedDURING SCHEDULED 14Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 7L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA110906Stringer Clip · crackedDURING SCHEDULED 14Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA110905Stringer Clip · crackedDURING SCHEDULED 14Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 5L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA110904Stringer Clip · crackedDURING SCHEDULED 14Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 639, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA110903Stringer Clip · crackedDURING SCHEDULED 14Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA110902Stringer Clip · crackedDURING SCHEDULED 14Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500D, STR 8L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA110901Skin · delaminatedDURING SCHEDULED 14Y CHECK, FOUND RT WING I/B FORE FLAP UPPER SURFACE DELAMINATED. REPAIRED FORE FLAP PER SRM.SDR SWAA110837Keelbeam · corrodedDURING SCHEDULED 14Y CHECK, FOUND KEEL BEAM CORRODED AT BS 729E, STR 27R. REMOVED AND REPLACED BEAM PER SRM AND EA.SDR SWAA110722Keelbeam · corrodedDURING SCHEDULED 14Y CHECK, FOUND KEEL BEAM CORRODED AT BS 747, STR 27R. REMOVED AND REPLACED BEAM PER SRM.SDR SWAA110333Light · inoperativeDURING SCHEDULED MV1 CHECK, FOUND RT OVERHEAD EMERGENCY EXIT DOOR LIGHT INOP. RELAMPED PER MM.SDR SWAA107879Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 10L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA102666Battery · faultyDIVERSION / DECLARED EMERGENCY. DC FAIL LIGHTS (BOTH) ON IN FLIGHT ABOUT FL 330. REMOVED AND REPLACED MAIN A/C BATTERY AND BATTERY CHARGER PER MM.SDR SWAA101821Keelbeam · crackedDURING SCHEDULED HC2 CHECK, FOUND KEEL BEAM LOWER PANEL CRACKED AT BS 600. REPAIRED KEEL BEAM PANEL PER SRM.SDR SWAA101820Flap · delaminatedDURING SCHEDULED HC2 CHECK, FOUND LT WING T/E AFT FLAP DELAMINATED AT OUTBOARD EDGE. REMOVED AND REPLACED FLAP PER MM.
Back to N646SW, cancelled Nov 20, 2017