N332SW, cancelled Jan 3, 2018
Service difficulty reports · 293
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 = 'N332SW' AND deregistration_id = 'N332SW-2018-01-03' 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 = 'N332SW' AND deregistration_id = 'N332SW-2018-01-03' 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 SWAA080433Bracket · corrodedDURING SCHEDULED BRDG CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR BRACKET CORRODED. REMOVED AND REPLACED BRACKET PER SRM.SDR SWAA080401Crease Beam · corrodedDURING SCHEDULED BRDG CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 616 TO BS 639, RBL 70. REMOVED AND REPLACED WEB PER SRM.SDR SWAA080402Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 277, STR 16R. REPAIRED FRAME PER BOEING DRAWING.SDR SWAA080383Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 928, STR 12L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080384Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 928, STR 23L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080010Light · inoperativeDURING SCHEDULED SPV CHECK, FOUND R2 DOOR EMERGENCY EXIT EXTERIOR LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA080009Light · inoperativeDURING SCHEDULED SPV CHECK, FOUND L2 DOOR EMERGENCY EXIT EXTERIOR LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA076441Skin · crackedDURING SCHEDULED A1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 971, STR 21L. REPAIRED SKIN PER SWA EA.SDR SWAA076155Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 503D, STR 16R. REPAIRED SKIN PER SWA EA.SDR SWAA076100Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 503D, STR 16R. REPAIRED SKIN PER SWA EA.SDR SWAA075495Light · brokenL1 DOOR EMERGENCY EXIT SLIDE LIGHT BROKEN. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA075360Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA075361Bulkhead · crackedDURING SCHEDULED C1 CHECK, FOUND AFT PRESSURE BULKHEAD CRACKED AT BS 1016, STR 5R. REPAIRED BULKHEAD PER SRM.SDR SWAA073645Slide · dislodgedR2 DOOR EMERGENCY EVAC SLIDE FELL OUT, DID NOT DEPLOY. INSTALLED EVAC SLIDE PER MM.SDR SWAA073621Slide · dislodgedR2 DOOR EMERGENCY EVAC SLIDE FELL OUT, DID NOT DEPLOY. INSTALLED EVAC SLIDE PER MM.SDR SWAA073428Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500C, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA072831Battery Pack · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND FWD CABIN EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA071790Bulb · inoperativeDURING SCHEDULED C3 CHECK, FOUND LEFT OVERWING EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA071791Slide · low pressureDURING SCHEDULED C3 CHECK, R2 DOOR EMERGENCY EVAC SLIDE PRESSURE GAUGE INDICATED OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA070080Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 970, STR 22L. REPAIRED SKIN PER SWA EA.SDR SWAA065071Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 969, STR 22L. REPAIRED SKIN PER SWA EA.SDR SWAA064993Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 740, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA063997Battery Pack · dischargedDURING SCHEDULED SPV CHECK, FOUND AFT CABIN EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA063996Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND AFT CARGO DOOR CUTOUT FWD FRAME CRACKED AT NR 5 DOOR STOP. REMOVED AND REPLACED FRAME SECTION PER ACO.SDR SWAA063987Stringer Splice · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER SPLICE CRACKED AT BS 359, STR 16L. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA063986Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 21R. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA063333Pressure Panel · crackedDURING SCHEDULED C1 CHECK, FOUND NLG W/W CEILING PANEL CUTOUT CRACKED AT RIGHT BS 250 AND LEFT BS 250. REPAIRED CEILING PANEL CUTOUT PER SWA EA.SDR SWAA063316Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 770, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA063227Skin · crackedFOUND FUSELAGE SKIN CRACKED AT BS 504C, STR 15R. REPAIRED SKIN PER SWA EA.SDR SWAA063226Skin · crackedFOUND FUSELAGE SKIN CRACKED AT BS 513D, STR 15R. REPAIRED SKIN PER SWA EA.SDR SWAA062000Skin · crackedDURING SCHEDULED A2 CHECK, FOUND L1 DOOR SKIN CRACKED AT UPPER HINGE CUTOUT. REPAIRED SKIN PER SWA EA.SDR SWAA061262Slide · out of positionL1 DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA060821Slide · out of adjustR1 DOOR EVACUATION SLIDE OUT OF ADJUST. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA053338Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 947, BETWEEN STR 23L & STR 24L. REPAIRED SKIN PER SWA EA.SDR SWAA053337Skin · crackedDURING SCHEDULED C2 CHECK, FOUND NR 1 L/E SLAT SKIN CRACKED NEAR INBOARD END. REPAIRED SLAT PER SRM.SDR SWAA052673Line · chafedAIR TURNBACK/DECLARED EMERGENCY, LOST A-SYSTEM HYDRAULICS. REMOVED AND REPLACED A-SYSTEM HYDRAULIC SUPPLY LINE PER MM.SDR SWAA052672Line · leakingDIVERSION, LOST A-SYSTEM HYDRAULIC PRESSURE & FLUID. REMOVED AND REPLACED A-SYSTEM HYDRAULIC HEAT EXCHANGER LINE & HYDRAULIC CASE DRAIN FILTER PER MM.SDR SWAA052059Bushing · wornDURING SCHEDULED C1 CHECK, LT ELEVATOR TAB FAILED THE FREE PLAY CHECK. REMOVED AND REPLACED LT ELEVATOR TAB NR 1 HINGE BUSHING & HARDWARE PER MM.SDR SWAA052058Battery · inoperativeDURING SCHEDULED C1 CHECK, FOUND AFT CABIN EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA052049Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727D + 10, STR 19R. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA052048Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 777, STR 24R. REPAIRED SKIN PER SRM.SDR SWAA051960Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500C + 18, STR 13L. REPAIRED SKIN PER SWA EA.SDR SWAA051951Web · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE BEADED WEB CRACKED AT BS 664, RBL 40. REPAIRED WEB PER SRM.SDR SWAA051950Keelbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE KEELBEAM CORRODED AT BS 520, RBL 7. REPAIRED KEEL BEAM PER SRM.SDR SWAA051949Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR CUTOUT, FWD LOWER CORNER. REPAIRED SKIN PER SRM.SDR SWAA051923Stringer Clip · crackedDURING SCHEDULED 1/4D CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 25R & STR 26L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA051926Web · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE BEADED WEB CRACKED AT BS 664, LBL 33. REPAIRED WEB PER SRM.SDR SWAA051925Stringer Clip · crackedDURING SCHEDULED 1/4D CHECK, FOUND STRINGER CLIP CRACKED AT BS 827, STR 25L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA051924Stringer Clip · crackedDURING SCHEDULED 1/4D CHECK, FOUND STRINGER CLIP CRACKED AT BS 787, STR 24R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA051922Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SHEAR TIE CORRODED AT BS 500, BL 0. REPAIRED SHEAR TIE PER SRM.
Back to N332SW, cancelled Jan 3, 2018