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 SWAA101171Slide · out of positionDURING SCHEDULED MV2 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MT.SDR SWAA097357Skin Panel · crackedDURING SCHEDULED 2HC1 CHECK, FOUND NLG W/W RT SIDE PANEL 3103R CRACKED. REPAIRED SKIN PER EA.SDR SWAA096311Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 464, STR 26L. REPAIRED SKIN PER ER.SDR SWAA096310Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER ER.SDR SWAA096309Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER ER.SDR SWAA096308Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER ER.SDR SWAA096307Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 410, STR 26L. REPAIRED SKIN PER ER.SDR SWAA096268Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 924, BETWEEN STR 23R TO STR 24R. REPAIRED SKIN PER SRM.SDR SWAA096146Angle · crackedDURING SCHEDULED SPV CHECK, FOUND R1 DOOR UPPER HINGE CUTOUT INNER WEB ANGLE CRACKED AT BS 293, STR 11R. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA096055Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 908, STR 23R. REPAIRED SKIN PER SRM.SDR SWAA095853Axle · brokenDURING LANDING, NR 3 MLG WHEEL AXLE BROKE. REMOVED AND REPLACED RT MLG INNER CYLINDER ASSY PER MM.SDR SWAA093237Skin · delaminatedDURING SCHEDULED HC2 CHECK, FOUND RT WING I/B FOREFLAP UPPER SURFACE DELAMINATED. R&R FOREFLAP PER MM.SDR SWAA092930Lens · looseDURING SCHEDULED MV1 CHECK, FOUND LT OVERWING EMERGENCY EXIT LIGHT LENS LOOSE. SECURED LENS PER MM.SDR SWAA092879Lens · looseLT OVERWING EMERGENCY EXIT LIGHT LENS LOOSE. SECURED PER SWA EA.SDR SWAA092607Lens · missingLT OVERWING EMERGENCY EXIT LIGHT LENS MISSING. REPLACED LENS PER MM.SDR SWAA091524Slide · out of positionL1 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. ADJUSTED SLIDE PER MT.SDR SWAA086954Battery · dischargedFOUND FWD I/B EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA086940Battery · dischargedFOUND FWD I/B EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA086020Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 747, STR 19R. REPAIRED SKIN PER SRM.SDR SWAA085787Skin · crackedDURING SCHEDULED MV4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 380, STR 26L. REPAIRED SKIN PER SRM.SDR SWAA085786Skin · crackedDURING SCHEDULED MV4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 784, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA085785Skin · crackedDURING SCHEDULED MV4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 793, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA085784Skin · crackedDURING SCHEDULED MV4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 787, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA084595Lens · missingRIGHT OVERWING EMERGENCY EXIT LIGHT LENS MISSING. INSTALLED LENS PER MM.SDR SWAA082096Pushrod · corrodedDURING SCHEDULED BRDG CHECK, FOUND LT ELEVATOR TAB PUSH RODS CORRODED AT FWD END. REMOVED AND REPLACED PUSH RODS PER MM.SDR SWAA082097Lens · looseDURING SCHEDULED BRDG CHECK, FOUND BULL NOSE EMERGENCY EXIT LIGHT LENS LOOSE AT ROW 16 DEF. SECURED LENS PER MM.SDR SWAA081905Door Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND R2 DOOR CUTOUT FWD FRAME CRACKED AT BS 951, BETWEEN STR 10R AND STR 11R. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA081895Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 9R. REPAIRED FRAME PER SWA EA.SDR SWAA081862Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STR 28L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081861Stringer · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER 27L CRACKED AT BS 390. REPAIRED STRINGER PER SRM.SDR SWAA08860Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 277, STR 2R. REPAIRED FRAME PER SRM.SDR SWAA081807Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081806Beltframe · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE BELTFRAME CRACKED AT BS 663, STR 3L. REPAIRED BELTFRAME PER SRM.SDR SWAA081805Beltframe · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE BELTFRAME CRACKED AT BS 663, STR 2L. REPAIRED BELTFRAME PER SRM.SDR SWAA081804Beltframe · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE BELTFRAME CRACKED AT BS 663, STR 1. REPAIRED BELTFRAME PER SRM.SDR SWAA081772Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 277, STR 16R. REPAIRED FRAME PER SWA EA.SDR SWAA081773Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, STR 20R. REPAIRED FRAME PER SWA EA.SDR SWAA081755Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 9R. REPAIRED FRAME PER SWA EA.SDR SWAA081756Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 344, STR 9R. REPAIRED FRAME PER SWA EA.SDR SWAA081757Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 9R. REPAIRED FRAME PER SWA EA.SDR SWAA081758Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081759Stringer Splice · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER SPLICE CRACKED AT BS 663, STR 3L. REPAIRED STRINGER SPLICE PER SRM.SDR SWAA081677Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 847, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081678Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081679Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081680Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 807, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081681Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081668Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081665Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 5L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081664Stringer Splice · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER SPLICE CRACKED AT BS 360, STR 15L. REMOVED AND REPLACED STRINGER SPLICE PER SRM.
Back to N670SW, cancelled Jan 8, 2022