N670SW, cancelled Jan 8, 2022
Service difficulty reports · 454
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 = 'N670SW' AND deregistration_id = 'N670SW-2022-01-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 = 'N670SW' AND deregistration_id = 'N670SW-2022-01-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 SWAA081667Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081666Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 9L. REPAIRED FRAME PER SWA EA.SDR SWAA081669Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727E, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081619Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME PER SRM.SDR SWAA081618Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, STR 20R. REPAIRED FRAME PER SRM.SDR SWAA081617Skin · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BETWEEN BS 433 AND BS 448, LBL 3 AND RBL 2. REPAIRED SKIN PER SWA EA.SDR SWAA081471Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 335, STR 17L. REPAIRED FRAME PER SRM.SDR SWAA081420Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 11R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081421Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 328, STR 21L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081410Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 578, STR 11R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081409Floorbeam · corrodedDURING SCHEDULED BRDG CHECK, FOUND FLOORBEAM CORRODED AT BS 512A, RBL 14. REPAIRED BEAM PER SRM.SDR SWAA081411Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 663, STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081375Floorbeam · corrodedDURING SCHEDULED BRDG CHECK, FOUND FLOORBEAM CORRODED AT BS 344, LBL 1 TO LBL 9. REPAIRED FLOORBEAM PER SRM.SDR SWAA081374Floorbeam · corrodedDURING SCHEDULED BRDG CHECK, FOUND FLOORBEAM CORRODED AT BS 312, LBL 1. REPAIRED FLOORBEAM PER SRM.SDR SWAA081318Floorbeam · corrodedDURING SCHEDULED BRDG CHECK, FOUND FLOORBEAM CORRODED AT BS 328, RBL 29 TO RBL 42. REPAIRED FLOORBEAM PER SRM.SDR SWAA081265Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME INNER CHORD CRACKED AT RT BS 616. REPAIRED FRAME CHORD PER SRM.SDR SWAA081264Skin · crackedDURING SCHEDULED BRDG CHECK, FOUND RT HORIZONTAL STABILIZER LOWER SKIN CRACKED BETWEEN STA 66 AND STA 94. REPAIRED SKIN PER SRM.SDR SWAA081241Shear Tie · corrodedDURING SCHEDULED BRDG CHECK, FOUND SHEAR TIE CORRODED AT BS 500, RBL 4. REPAIRED SHEAR TIE PER SRM.SDR SWAA081242Beam · crackedDURING SCHEDULED BRDG CHECK, FOUND VERTICAL BEAM CRACKED AT BS 178, RBL 17, WL 182. REPAIRED BEAM PER SRM.SDR SWAA081218Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 344, STR 11R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081216Crease Beam · corrodedDURING SCHEDULED BRDG CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 400 AND BS 440, RBL 70. REMOVED AND REPLACED WEB PER SWA EA.SDR SWAA081217Floorbeam · corrodedDURING SCHEDULED BRDG CHECK, FOUND FLOORBEAM CORRODED AT BS 360, RBL 1. REPAIRED FLOORBEAM PER SRM.SDR SWAA081133Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 500C, STR 26L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080904Glowstrip · looseEEPLS PHOTOLUMINESCENT STRIP LOOSE AT ROW 1 DEF. SECURED STRIP PER MM.SDR SWAA080243Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 827, STR 26L. REPAIRED SHEAR TIE PER SRM.SDR SWAA080193Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 986, STR 18L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080110Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 887, STR 26R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA080109Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 747, STR 27R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA075903Glowstrip · crackedDURING SCHEDULED C2 CHECK, FOUND EEPLS PHOTOLUMINESCENT STRIP CRACKED AT ROW 1 DEF. REMOVED AND REPLACED STRIP PER MM.SDR SWAA075826Lamp · inoperativeDURING SCHEDULED MV1 CHECK, FOUND L2 DOOR EMERGENCY EXIT EXTERIOR LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA074037Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA074038Hinge Fitting · wornDURING SCHEDULED C1 CHECK, LT ELEVATOR TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED NR 1 TAB HINGE FITTING PER SWA EA.SDR SWAA073902Channel · crackedDURING SCHEDULED SPV CHECK, FOUND AFT CARGO DOOR FRAME UPPER U-CHANNEL CRACKED. REMOVED AND REPLACED U-CHANNEL PER SRM.SDR SWAA073877Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BS 413, LBL 3. REPAIRED SKIN PER SWA EA.SDR SWAA072372Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 504D, STR 14L. REPAIRED SKIN PER SWA EA.SDR SWAA072373Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 374, STR 26L. REPAIRED SKIN PER SWA EA.SDR SWAA071566Skin · crackedDURING SCHEDULED SV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 793, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA070815Skin · delaminatedDURING SCHEDULED MV1 CHECK, FOUND LEFT WING INBOARD MID FLAP OUTBOARD T/E DELAMINATED. REMOVED AND REPLACED MID FLAP PER MM.SDR SWAA063943Skin · delaminatedDURING SCHEDULED C2 CHECK, FOUND RT WING OUTBOARD T/E AFT FLAP DELAMINATED AT INBOARD LOWER SURFACE. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA063942Battery Pack · dischargedDURING SCHEDULED C2 CHECK, FOUND FWD CABIN EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA062580Light · brokenEMERGENCY EXIT LIGHT ASSY BROKEN AT FWD ENTRY DOOR. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA061407Light · looseEMERGENCY EXIT LIGHT ASSY LOOSE AT LT ROW 6. SECURED LIGHT ASSY PER MM.SDR SWAA061365Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO DOOR CUTOUT FWD FRAME CRACKED AT INBOARD CORNER. R&R FWD FRAME SECTION PER SRM.SDR SWAA061283Door Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT FWD CARGO DOOR CUTOUT, AFT FRAME NR 5 STOP FITTING. REPAIRED FRAME PER SRM.SDR SWAA061282Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT BS 348, STR 15L. REPAIRED FRAME PER SRM.SDR SWAA061226Web · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE WEB CRACKED AT BS 348, STR 16L. REPAIRED WEB ASSY PER SRM.SDR SWAA061201Splice · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE STRINGER SPLICE CRACKED AT BS 360, STR 4L. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA061153Skin · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN CRACKED AT BS 474, STR 7R. REPAIRED SKIN PER SRM.SDR SWAA061114Shear Tie · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SHEAR TIE CRACKED AT BS 360, BETWEEN STR 13L & STR 15L. R&R SHEAR TIE PER SRM.SDR SWAA060663Skin · delaminatedDURING SCHEDULED C4 CHECK, FOUND RIGHT WING NR 5 L/E SLAT DELAMINATED. REPAIRED SLAT PER SRM.
Back to N670SW, cancelled Jan 8, 2022