N328SW, cancelled Oct 26, 2017
Service difficulty reports · 281
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 = 'N328SW' AND deregistration_id = 'N328SW-2017-10-26' 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 = 'N328SW' AND deregistration_id = 'N328SW-2017-10-26' 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 SWAA072911Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT RIGHT BS 616, AT LOWER FASTENER ABOVE FUEL TANK. REPAIRED FRAME PER TYPICAL REPAIR MANUAL.SDR SWAA072912Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT LT BS 616, AT LOWER FASTENER ABOVE FUEL TANK. REPAIRED FRAME PER TYPICAL REPAIR MANUAL.SDR SWAA072914Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT RT BS 616, WL 202. REPAIRED FRAME PER TYPICAL REPAIR MANAUL.SDR SWAA072909Floorbeam · corrodedDURING SCHEDULED BRDG CHECK, FOUND FLOORBEAM UPPER TEE CAP CORRODED AT BS 312, BETWEEN LBL 56 AND RBL 56. REMOVED AND REPLACED FLOORBEAM TEE CAP PER SRM.SDR SWAA072856Hook · looseDURING SCHEDULED BRDG CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR HOOK LOOSE. SECURED HOOK PER SRM.SDR SWAA072859Floorbeam · corrodedDURING SCHEDULED BRDG CHECK, FOUND FLOORBEAM CORRODED AT BS 967, RBL 5. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA072858Floorbeam · corrodedDURING SCHEDULED BRDG CHECK, FOUND FLOORBEAM CORRODED AT BS 967, LBL 27. REPAIRED FLOORBEAM PER SRM.SDR SWAA072857Skin · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BETWEEN BS 427 AND BS 447, LBL 1. REPAIRED SKIN PER SWA EA.SDR SWAA072766Floorbeam · corrodedDURING SCHEDULED BRDG CHECK, FOUND FLOORBEAM CORRODED AT BS 294, BL 0. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA072764Skin · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 800, STR 18L. REPAIRED SKIN PER SWA EA.SDR SWAA072765Skin · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727D, STR 19L. REPAIRED SKIN PER SWA EA.SDR SWAA072754Floorbeam · corrodedDURING SCHEDULED BRDG CHECK, FOUND FLOORBEAM CORRODED AT BS 294, LBL 36 TO RBL 53. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA072403Slide · out of positionL1 DOOR EMERGENCY EVAC SLIDE FELL OUT, DID NOT DEPLOY. INSTALLED EVAC SLIDE PER MM.SDR SWAA071769Battery · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND FWD CABIN EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA071514Skin · crackedDURING SCHEDULED C3 CHECK, FOUND LEFT WING NR 2 L/E SLAT CRACKED AT INBOARD ACTUATOR. REPAIRED SLAT PER SWA EA.SDR SWAA071463Slide · dislodgedR1 DOOR EMERGENCY EVAC SLIDE FELL OUT, DID NOT DEPLOY. INSTALLED EVAC SLIDE PER MM.SDR SWAA071229Glowstrip · missingDURING SCHEDULED A2 CHECK, FOUND EEPLS PHOTOLUMINESCENT STRIP MISSING AT ROW 8 ABC TO ROW 10 ABC. INSTALLED STRIP PER MM.SDR SWAA064644Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 804, STR 18L. REPAIRED SKIN PER SWA EA.SDR SWAA064643Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 771, STR 18L. REPAIRED SKIN PER SWA EA.SDR SWAA063155Bolt · wornDURING SCHEDULED C1 CHECK, RT ELEVATOR TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED RT TAB NR 1 HINGE BOLT AND BUSHING PER MM.SDR SWAA062725Slide · out of adjustR2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA061662Structure · wornDURING SCHEDULED C4 CHECK, FOUND RT WING T/E OUTBOARD FORE FLAP WORN AT INBOARD END. REMOVED AND REPLACED FORE FLAP PER MM.SDR SWAA061650Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT FWD CARGO DOOR CUTOUT, AT UPPER NR 1 DOOR STOP FITTING. REPAIRED FRAME PER EA.SDR SWAA061649Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT FWD CARGO DOOR CUTOUT, AT NR 5 DOOR STOP FITTING. REPAIRED FRAME PER EA.SDR SWAA061537Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO DOOR CUTOUT AFT FRAME CRACKED AT UPPER INBOARD CORNER OF NR 5 STOP. REPAIRED FRAME SECTION PER EA.SDR SWAA061485Light · inoperativeDURING SCHEDULED SPV CHECK, FOUND L2 DOOR EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA061484Light · inoperativeDURING SCHEDULED SPV CHECK, FOUND R2 DOOR EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA061483Light · inoperativeDURING SCHEDULED SPV CHECK, FOUND MID CABIN LT OVERHEAD EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA053276Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND R1 DOOR EVACUATION SLIDE OUT OF ADJUST. REINSTALLED SLIDE ASSY PER MM.SDR SWAA052603Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 762.25, STR 19L. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA052602Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 750.5, STR 19L. REPAIRED SKIN PER SWA EA.SDR SWAA052253Wire · chafedDIVERSION/DECLARED EMERGENCY, A LARGE ELECTRIC SPARK OCCURRED IN COCKPIT OVERHEAD PANEL AND SHOWERED CENTER CONSOLE WITH SPARKLER LIKE FRAGMENTS. FOUND CHAFFED WIRE BUNDLE IN OVERHEAD PANEL, REPAIRED WIRE PER MM.SDR SWAA052027Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727E + 15, STR 18L. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA052030Door Frame · crackedDURING SCHEDULED C1 CHECK, FOUND AFT CARGO DOOR FWD FRAME CRACKED BETWEEN 2ND & 3RD STOP FITTING CUTOUT. REMOVED AND REPLACED AFT CARGO DOOR PER MM.SDR SWAA052029Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727E + 15, STR 18R. REPAIRED SKIN PER SRM.SDR SWAA052028Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727D + 15, STR 19R. REPAIRED SKIN PER SRM.SDR SWAA050974Lens · looseDURING SCHEDULED C4 CHECK, FOUND R1 DOOR EMERGENCY EXIT LOWER LIGHT LENS LOOSE. REMOVED AND REPLACED LIGHT ASSY.SDR SWAA043423Clip · looseDURING SCHEDULED 1/4D CHECK, FOUND L1 DOOR EVACUATION SLIDE GIRT BAR STOW HOOK CLIPS LOOSE. SECURED STOW HOOK CLIPS PER MM.SDR SWAA043422Keelbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE KEELBEAM CORRODED AT STR 28L, BETWEEN BS 500D AND BS 520. REPAIRED KEEL BEAM SECTION PER SRM.SDR SWAA043421Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR FWD LOWER CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA043420Skin · delaminatedDURING SCHEDULED 1/4D CHECK, FOUND RT WING INBOARD FORE FLAP DELAMINATED AT MID SPAR AREA. REMOVED FORE FLAP ASSY PER MM.SDR SWAA043392Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND R1 DOOR AFT FRAME CRACKED AROUND 3RD STOP FITTING. REPAIRED FRAME PER SRM.SDR SWAA043393Door Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND L1 DOOR AFT FRAME CRACKED AROUND 4TH STOP FITTING. REPAIRED FRAME PER SRM.SDR SWAA043391Pressure Panel · crackedDURING SCHEDULED 1/4D CHECK, FOUND BS 665 BEADED WEB CRACKED AT RBL 40. REPAIRED WEB PER SRM.SDR SWAA043390Bulkhead · crackedDURING SCHEDULED 1/4D CHECK, FOUND BS 1016 BULKHEAD WEB CRACKED AT DOME CAP, 2 O'CLOCK POSITION. REPAIRED WEB PER SWA EA.SDR SWAA043383Floorbeam · crackedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM UPPER CHORD AT BS 665, BL 0, CRACKED. REPAIRED CHORD PER EA.SDR SWAA043382Pressure Panel · crackedDURING SCHEDULED 1/4D CHECK, FOUND BEADED PRESSURE WEB AT BS 665, LBL 39.5, CRACKED. REPAIRED PRESSURE WEB PER EA.SDR SWAA043381Window Post · crackedDURING SCHEDULED 1/4D CHECK, FOUND CAPT'S NR 1 WINDOW UPPER OUTBOARD POST CRACKED. REPAIRED NR 1 WINDOW POST PER SRM.SDR SWAA043380Window Post · crackedDURING SCHEDULED 1/4D CHECK, FOUND F/O'S NR 1 WINDOW UPPER OUTBOARD POST CRACKED. REPAIRED NR 1 WINDOW POST PER SRM.SDR SWAA043375Floorbeam · crackedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM UPPER CHORD AT BS 663, BL 0, CRACKED. REPAIRED CHORD PER EA.
Back to N328SW, cancelled Oct 26, 2017