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 SWAA075523Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075532Stringer · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER 7L CRACKED AT BS 440. REPAIRED STRINGER PER SRM.SDR SWAA075531Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 500, STR 16L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075530Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 500D, STR 8L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075529Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 440, STR 7L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075528Pressure Panel · crackedDURING SCHEDULED BRDG CHECK, FOUND NLG W/W UPPER CEILING PANEL CRACKED AT RBL 7.75. REPAIRED PANEL PER ACO.SDR SWAA075527Pressure Panel · crackedDURING SCHEDULED BRDG CHECK, FOUND NLG W/W UPPER CEILING PANEL CRACKED AT LBL 7.75. REPAIRED PANEL PER ACO.SDR SWAA075526Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075525Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA075524Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 16R. REPAIRED FRAME PER SWA EA.SDR SWAA075487Skin · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 750, STR 14L. REPAIRED SKIN PER SWA EA.SDR SWAA075488Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075468Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075467Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075230Skin · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 451, STR 28L. REPAIRED SKIN PER SWA EA.SDR SWAA075231Skin · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 444, STR 28R. REPAIRED SKIN PER SWA EA.SDR SWAA075202Floorbeam · crackedDURING SCHEDULED BRDG CHECK, FOUND FLOORBEAM CRACKED AT BS 328, LBL 28. REPAIRED BEAM PER SRM.SDR SWAA075203Skin · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 444, STR 28R. REPAIRED SKIN PER SWA EA.SDR SWAA075147Floorbeam · corrodedDURING SCHEDULED BRDG CHECK, FOUND FLOORBEAM CORRODED AT BS 732 LBL 3. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA075148Crease Beam · corrodedDURING SCHEDULED BRDG CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 400 AND BS 420, LBL 70. REMOVED AND REPLACED WEB PER SRM.SDR SWAA075146Door Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND L1 DOOR FWD FRAME CRACKED AT SNUBBER CUTOUT. REMOVED AND REPLACED DOOR PER MM.SDR SWAA075076Bulkhead · crackedDURING SCHEDULED BRDG CHECK, FOUND AFT PRESSURE BULKHEAD WEB CRACKED AT BS 1016, STR 23L. REPAIRED WEB PER SRM.SDR SWAA075077Skin · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 727D AND BS 727E, STR 19R. REPAIRED SKIN PER SWA EA.SDR SWAA075056Crease Beam · corrodedDURING SCHEDULED BRDG CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 360 AND BS 380, RBL 70. REPAIRED WEB PER SRM.SDR SWAA075029Skin · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 312, STR 20R. REPAIRED SKIN PER SWA EA.SDR SWAA074721Slat · delaminatedDURING SCHEDULED C4 CHECK, FOUND RIGHT WING NR 5 L/E SLAT DELAMINATED AT T/E. REMOVED AND REPLACED SLAT PER MM.SDR SWAA074739Skin · delaminatedDURING SCHEDULED C4 CHECK, FOUND LEFT WING OUTBOARD T/E AFT FLAP DELAMINATED AT LOWER SURFACE. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA074720Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 750, STR 14L. REPAIRED SKIN PER SWA EA.SDR SWAA074542Slat · crackedDURING SCHEDULED A1 CHECK, FOUND RIGHT WING NR 4 L/E SLAT CRACKED AT OUTBOARD END. REPAIRED SLAT PER SWA EA.SDR SWAA074309Lens · looseBULLNOSE EMERGENCY EXIT LIGHT LENS LOOSE AT ROW 2 ABC. SECURED LENS PER MM.SDR SWAA072949Light · inoperativeDURING SCHEDULED C3 CHECK, FOUND BULLNOSE EMERGENCY EXIT LIGHT INOP AT ROW 15 DEF. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA072948Battery Pack · dischargedDURING SCHEDULED C3 CHECK, FOUND FWD CABIN EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PACK AND BATTERY CHARGER PER MM.SDR SWAA071241Structure · delaminatedDURING SCHEDULED C2 CHECK, FOUND LEFT WING INBOARD FORE FLAP DELAMINATED AT OUTBOARD END. REMOVED AND REPLACED FORE FLAP PER MM.SDR SWAA071149Battery Pack · dischargedDURING SCHEDULED SERVICE CHECK, FOUND AFT CABIN EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA064527Bear Strap · crackedDURING SCHEDULED C1 CHECK, FOUND L2 DOOR FUSELAGE SKIN BEAR STRAP CRACKED AT LOWER FWD CORNER. REPAIRED SKIN PER SWA EA.SDR SWAA064526Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500D, STR 16R. REPAIRED SKIN PER SWA EA.SDR SWAA064298Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 350, STR 16L. REMOVED AND REPLACED SHEAR TIE PER EA.SDR SWAA064285Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 294, STR 11L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA064284Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 295, STR 10L. REMOVED AND REPLACED SHEAR TIE PER EA.SDR SWAA064283Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT FWD SIDE OF RADIO ALTIMETER ANTENNA CUTOUT BS 450, BL 0. REPAIRED SKIN PER EA.SDR SWAA064282Switch · faultyDURING SCHEDULED SPV CHECK, EMERGENCY EXIT LIGHTS ILLUMINATED WITH SWITCH IN OFF POSITION. REMOVED AND REPLACED COCKPIT LIGHT SWITCH PER MM.SDR SWAA064281Lamp · inoperativeDURING SCHEDULED SPV CHECK, FOUND R2 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA064280Lamp · inoperativeDURING SCHEDULED SPV CHECK, FOUND L2 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA064279Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO DOOR CUTOUT AFT FRAME CRACKED AT NR 5 DOOR STOP. REMOVED AND REPLACED FRAME SECTION PER ACO.SDR SWAA064278Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO DOOR CUTOUT FWD FRAME CRACKED AT NR 5 DOOR STOP. REMOVED AND REPLACED FRAME SECTION PER ACO.SDR SWAA063927Slide · out of adjustR2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA063834Skin · crackedDURING SCHEDULED A1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 738D, STR 19R. REPAIRED SKIN PER SWA EA.SDR SWAA063702Slide · dislodgedL1 DOOR EMERGENCY EVAC SLIDE FELL OUT, DID NOT DEPLOY. INSTALLED EVAC SLIDE PER MM.SDR SWAA063514Pressure Panel · crackedDURING SCHEDULED A1 CHECK, FOUND NLG WW PRESSURE PANEL CRACKED AT RIGHT BS 259.5, WL 174. REPAIRED SKIN PER SWA EA.SDR SWAA063513Skin · crackedDURING SCHEDULED A1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 505C, STR 15R. REPAIRED SKIN PER SWA EA.
Back to N333SW, cancelled Sep 18, 2017