N303SW, cancelled Oct 26, 2017
Service difficulty reports · 391
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 = 'N303SW' AND deregistration_id = 'N303SW-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 = 'N303SW' AND deregistration_id = 'N303SW-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 SWAA074279Hook · looseR1 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR HOOK LOOSE. REMOVED AND REPLACED GIRT BAR HOOK PER MM.SDR SWAA073581Skin · crackedDURING SCHEDULED RON, FOUND FUSELAGE SKIN CRACKED AT BS 790, STR 20L. REPAIRED SKIN PER SWA EA.SDR SWAA073582Skin · crackedDURING SCHEDULED RON, FOUND FUSELAGE SKIN CRACKED AT BS 770, STR 14L. REPAIRED SKIN PER SWA EA.SDR SWAA073580Skin · crackedDURING SCHEDULED RON, FOUND FUSELAGE SKIN CRACKED AT BS 927, STR 24L. REPAIRED SKIN PER SWA EA.SDR SWAA072830Slide · out of adjustR2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA072627Glowstrip · wornDURING SCHEDULED HC2 CHECK, FOUND EEPLS PHOTOLUMINESCENT STRIP WORN AT ROW 15 DEF. REMOVED AND REPLACED STRIP PER MM.SDR SWAA072628Slide · out of adjustDURING SCHEDULED HC2 CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA072631Stringer · crackedDURING SCHEDULED HC2 CHECK, FOUND STRINGER 23R CRACKED AT BS 337. REPAIRED STRINGER PER SWA EA.SDR SWAA072630Stringer · crackedDURING SCHEDULED HC2 CHECK, FOUND STRINGER 26R CRACKED AT BS 365. REPAIRED STRINGER PER SRM.SDR SWAA072629Light · crackedDURING SCHEDULED HC2 CHECK, FOUND L2 DOOR EMERGENCY EXIT LIGHT CRACKED. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA072632Skin · delaminatedDURING SCHEDULED HC2 CHECK, FOUND LEFT WING OUTBOARD T/E AFT FLAP DELAMINATED AT INBOARD END. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA072286Lens · brokenLEFT OVERWING EMERGENCY EXIT LIGHT LENS BROKEN. REMOVED AND REPLACED LIGHT LENS PER MM.SDR SWAA072212Lens · looseAFT CABIN EMERGENCY EXIT LIGHT LENS LOOSE. SECURED LENS PER MM.SDR SWAA071860Cable · out of rigON APPROACH TO LAX LOWERED LANDING GEAR, 3 GREEN AND 3 RED INDICATOR LIGHTS ILLUMINATED. EXTENDED LANDING GEAR MANUALLY, GEAR INDICATED SAFE. FOUND GEAR HANDLE CABLE OUT OF RIG. RIGGED GEAR HANDLE CABLE PER MM.SDR SWAA071703Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 839, STR 17L. REPAIRED SKIN PER SWA EA.SDR SWAA071701Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 854, STR 17L. REPAIRED SKIN PER SWA EA.SDR SWAA071700Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 834, STR 20L. REPAIRED SKIN PER SRM.SDR SWAA071702Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 772, STR 14L. REPAIRED SKIN PER SWA EA.SDR SWAA071227Tee Fitting · corrodedDURING SCHEDULED MV1 CHECK, FOUND OUTBOARD TEE CHORD CORRODED AT FWD HORIZONTAL FLANGE BS 227, LBL 3. REPAIRED CHORD PER SWA EA.SDR SWAA071226Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 690, STR 10L. REPAIRED SKIN PER SWA EA.SDR SWAA070468Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 967, STR 22L. REPAIRED SKIN PER SWA EA.SDR SWAA070358Lens · missingOVERHEAD EMERGENCY EXIT LIGHT LENS MISSING AT FWD CABIN. INSTALLED LIGHT LENS PER MM.SDR SWAA064883Module · overheatedDIVERSION, AFTER LEVEL OFF AT 30000, NOTICED STRONG ELECTRICAL ODOR BUT NO SMOKE. COMPLIED WITH QRH, SYSTEMS NORMAL. FOUND OVERHEAD SLAT INDICATION MODULE WITH BURNT SMELL AT LIGHT PLATE. REMOVED AND REPLACED INDICATION MODULE PER MM.SDR SWAA064504Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 502D, STR 16L. REPAIRED SKIN PER SWA EA.SDR SWAA064503Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 516C, STR 15L. REPAIRED SKIN PER SWA EA.SDR SWAA064148Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 316, STR 20R. REPAIRED SKIN PER SWA EA.SDR SWAA061774Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME AT FWD CARGO DOOR CUTOUT FWD WEB CRACKED, UPPER CORNER NR 5 DOOR STOP. REPAIRED FRAME WEB PER ER.SDR SWAA061696Skin · corrodedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CORRODED AT AFT CARGO DOOR CUTOUT LOWER AFT CORNER, BS 843, RBL 34. REPAIRED SKIN PER SRM.SDR SWAA061647Support · crackedDURING SCHEDULED SPV CHECK, FOUND L1 DOOR UPPER HINGE SUPPORT CRACKED. REPAIRED HINGE SUPPORT PER ER.SDR SWAA061646Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA061645Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT AFT CARGO DOOR CUTOUT, FWD LOWER CORNER. REPAIRED SKIN PER SRM.SDR SWAA061631Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CRACKED AT BS 501, STR 14R. REMOVED AND REPLACED STRINGER SECTION PER SRM.SDR SWAA061618Structure · crackedDURING SCHEDULED SPV CHECK, FOUND LT WING T/E FLAPS INBOARD FORE FLAP CRACKED. REPAIRED FORE FLAP PER SRM.SDR SWAA061617Bracket · corrodedDURING SCHEDULED SPV CHECK, FOUND L1 DOOR EMERGENCY EXIT EVAC SLIDE CORRODED AT AFT GIRT BAR BRACKET. REMOVED AND REPLACED AFT GIRT BAR BRACKET PER MM.SDR SWAA061606Bracket · crackedDURING SCHEDULED SPV CHECK, FOUND R2 DOOR EMERGENCY EXIT EVAC SLIDE FWD MOUNTING BRACKET CRACKED. REMOVED AND REPLACED FWD BRACKET PER SRM.SDR SWAA061605Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 277, STR 20R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA061561Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 967, ABOVE R2 DOOR. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA061560Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO DOOR UPPER FRAME CRACKED AT AFT HINGE UPPER BOLTS. REMOVED AND REPLACED FRAME SECTION PER SRM AND SB.SDR SWAA061525Hook · looseDURING SCHEDULED SPV CHECK, FOUND R2 DOOR EMERGENCY EXIT EVAC SLIDE AFT HOOK LOOSE. REMOVED AND REPLACED R2 DOOR EVAC SLIDE AFT HOOK PER MM.SDR SWAA061032Skin · delaminatedDURING SCHEDULED C2 CHECK, FOUND LT WING INBOARD T/E AFT FLAP DELAMINATED. REMOVED AND REPLACED FLAP PER MM.SDR SWAA061031Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 464, STR 17L. REPAIRED SKIN PER SWA EA.SDR SWAA061030Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500, STR 23R. REPAIRED SKIN PER SWA EA.SDR SWAA060596Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 932 TO BS 943, STR 22R TO STR 24R. REPAIRED SKIN PER SWA EA.SDR SWAA060595Skin · corrodedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN BULGED AT BS 517, STR 26R. REPAIRED SKIN PER SRM.SDR SWAA060594Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 582, STR 10R. REPAIRED SKIN PER SWA EA.SDR SWAA060593Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 700, STR 10L. REPAIRED SKIN PER SWA EA.SDR SWAA060587Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500, STR 26L. REPAIRED SKIN PER SRM.SDR SWAA060586Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 503A, STR 16L. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA060585Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 396, STR 15L. REPAIRED SKIN PER SWA EA.SDR SWAA060584Light · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND R2 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER MM.
Back to N303SW, cancelled Oct 26, 2017