N333SW, cancelled Sep 18, 2017
Service difficulty reports · 328
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 = 'N333SW' AND deregistration_id = 'N333SW-2017-09-18' 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 = 'N333SW' AND deregistration_id = 'N333SW-2017-09-18' 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 SWAA094843Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER ER.SDR SWAA094842Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER ER.SDR SWAA094841Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER ER.SDR SWAA092743Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 750, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA092713Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 784, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA092712Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 760, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA092711Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED BETWEEN BS 730D TO BS 740E, BETWEEN STR 18L TO STR 19L. REPAIRED SKIN PER SRM.SDR SWAA092710Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 750, BETWEEN STR 18L TO STR 19L. REPAIRED SKIN PER SRM.SDR SWAA092426Light · inoperativeDURING SCHEDULED MV1 CHECK, FOUND RT OVERWING EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA092425Light · inoperativeDURING SCHEDULED MV1 CHECK, FOUND LT OVERWING EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA092400Light · inoperativeDURING SCHEDULED MV1 CHECK, FOUND RT OVERWING EMERGENCY EXIT LIGHT INOP. RELAMPED PER MM.SDR SWAA092399Light · inoperativeDURING SCHEDULED MV1 CHECK, FOUND LT OVERWING EMERGENCY EXIT LIGHT INOP. RELAMPED PER MM.SDR SWAA091557Light · inoperativeLOWER LT OVERWING EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA090024Lens · brokenDURING SCHEDULED MV2 CHECK, FOUND RT WING OVERWING EMERGENCY EXIT LENS BROKEN. REMOVED AND REPLACED LENS PER MM.SDR SWAA087327Battery · dischargedFWD GALLEY FLASHLIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA087023Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR UPPER FWD CUTOUT REVEAL. REPAIRED SKIN PER SRM.SDR SWAA087022Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND LT WING SKIN CRACKED AT FIXED L/E ABOVE SPRING DOOR. REPAIRED SKIN PER SRM.SDR SWAA084223Hinge · brokenRIGHT WING NR 5 GROUND SPOILER HINGE BROKEN. REMOVED AND REPLACED SPOILER PER MM.SDR SWAA084110Slide · low pressureL2 DOOR EMERGENCY EVAC SLIDE PRESSURE GAUGE INDICATED OUT OF LIMITS. R&R EVAC SLIDE PER MM.SDR SWAA082892Skin · delaminatedDURING SCHEDULED SPV CHECK, FOUND LT WING INBOARD FORE FLAP UPPER INBOARD SURFACE DELAMINATED. REPAIRED FLAP PER SRM.SDR SWAA082801Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 731E, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA081430Skin · crackedFUSELAGE SKIN CRACKED AT BS 797, STR 17L. REPAIRED SKIN PER SRM.SDR SWAA081139Fitting · wornDURING SCHEDULED CV CHECK, RT ELEVATOR TAB FAILED FREE PLAY CHECK. REPAIRED NR 1 TAB HINGE FITTING PER SWA EA.SDR SWAA075942Bolt · corrodedDURING SCHEDULED 8Y CHECK, FOUND RT WING NR 7 FLAP TRACK BOLT CORRODED. REPAIRED FLAP TRACK PER SWA EA.SDR SWAA075941Bearing · wornDURING SCHEDULED 8Y CHECK, RT ELEVATOR FAILED FREE PLAY CHECK. REMOVED AND REPLACED NR 1 HINGE BEARING PER MM.SDR SWAA075940Bearing · wornDURING SCHEDULED 8Y CHECK, LT ELEVATOR FAILED FREE PLAY CHECK. REMOVED AND REPLACED NR 1 HINGE BEARING PER MM.SDR SWAA075745Frame · crackedDURING SCHEDULED BRIDGE CHECK, FOUND AFT CARGO DOOR FWD LOWER FRAME CRACKED. REMOVED AND REPLACED AFT CARGO DOOR PER MM.SDR SWAA075717Skin · crackedDURING SCHEDULED BRDG CHECK, FOUND RT HORIZONTAL STABILIZER LOWER T/E SKIN CRACKED AT STA 179. REMOVED AND REPLACED HORIZONTAL STABILIZER PER MM.SDR SWAA075667Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 21L. REPAIRED FRAME PER SWA EA.SDR SWAA075661Skin · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BS 410, BL 0. REPAIRED SKIN PER SWA EA.SDR SWAA075663Skin · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE SKIN CRACKED AT FWD CARGO DOOR CUTOUT LOWER AFT CORNER. REPAIRED SKIN PER SWA EA.SDR SWAA075662Skin · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BS 430, STR 28L. REPAIRED SKIN PER SWA EA.SDR SWAA075641Shear Tie · crackedDURING SCHEDULED BRDG CHECK, FOUND SHEAR TIE CRACKED AT BS 727C, STR 14R. REPAIRED SHEAR TIE PER SRM.SDR SWAA075619Stringer · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER 15L CRACKED AT BS 360. REPAIRED STRINGER PER SRM.SDR SWAA075620Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 277, STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075621Stringer · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER 10R CRACKED AT BS 277. REPAIRED STRINGER PER SRM.SDR SWAA075622Skin · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 767, STR 14R. REPAIRED SKIN PER SWA EA.SDR SWAA075576Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 10L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075577Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 5L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075578Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 16L. REPAIRED FRAME PER SWA EA.SDR SWAA075579Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA075561Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075560Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 7R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075559Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 6L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075567Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA075563Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 520, STR 16R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075562Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 6R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075565Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 460, STR 16L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075566Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA075564Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 520, STR 15L. REMOVED AND REPLACED STRINGER CLIP PER SRM.
Back to N333SW, cancelled Sep 18, 2017