N671SW, cancelled Jan 3, 2013
Service difficulty reports · 308
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 = 'N671SW' AND deregistration_id = 'N671SW-2013-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 = 'N671SW' AND deregistration_id = 'N671SW-2013-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 SWAA083530Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 26L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083471Door Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND L1 DOOR LOWER FWD FRAME CRACKED AT FWD CORNER. REPAIRED FRAME PER SRM.SDR SWAA083486Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 20R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083470Slat · delaminatedDURING SCHEDULED 20Y CHECK, FOUND RIGHT WING NR 4 L/E SLAT INBOARD UPPER CORNER DELAMINATED. REPAIRED SLAT PER SRM.SDR SWAA083472Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 21R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083474Beam · crackedDURING SCHEDULED 20Y CHECK, FOUND VERTICAL BEAM WEB CRACKED AT BS 178, RBL 17. REPAIRED WEB PER SRM.SDR SWAA083473Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 21R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083338Stringer Clip · crackedDURING SCHEDULE 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500D, STR 26L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083315Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 22L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA082923Glowstrip · looseEEPLS LENS PHOTOLUMINESCENT STRIP LOOSE AT ROW 8 DEF. SECURED STRIP PER MM.SDR SWAA082840Lens · missingAFT CABIN EMERGENCY EXIT SIGN LENS MISSING. INSTALLED LENS PER MM.SDR SWAA081559Battery Pack · dischargedDURING SCHEDULED C4 CHECK, FOUND R1 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA081558Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN R1 DOOR CUTOUT UPPER FWD CORNER CRACKED. REPAIRED SKIN PER SWA EA.SDR SWAA081557Skin · delaminatedDURING SCHEDULED C4 CHECK, FOUND LT WING INBOARD FORE FLAP DELAMINATED ON UPPER SURFACE. REMOVED AND REPLACED FLAP PER MM.SDR SWAA081556Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA080038Skin · crackedDURING SCHEDULED A2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 767, STR 19R. REPAIRED SKIN PER SRM.SDR SWAA080037Skin · crackedDURING SCHEDULED A2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 520, STR 16L. REPAIRED SKIN PER SWA EA.SDR SWAA076481Skin · crackedDURING SCHEDULED A2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 520, STR 16L. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA076482Skin · crackedDURING SCHEDULED A2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 767, STR 19R. REPAIRED SKIN PER SRM.SDR SWAA076027Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA076029Light · crackedDURING SCHEDULED C3 CHECK, FOUND L1 DOOR EMERGENCY EXIT LIGHT ASSY CRACKED. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA076028Slat · crackedDURING SCHEDULED C3 CHECK, FOUND LT WING NR 1 L/E SLAT CRACKED AT INBOARD END. REPAIRED SLAT PER SWA EA.SDR SWAA075747Window · arcedL1 COCKPIT WINDOW ARCED IN FLIGHT. REMOVED AND REPLACED L1 COCKPIT WINDOW PER MM.SDR SWAA074977Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 739E, STR 18R. REPAIRED SKIN PER SRM.SDR SWAA074711Slide · out of adjustR1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA074659Slide · out of adjustR1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA074176Hinge · crackedDURING SCHEDULED C2 CHECK, FOUND RIGHT WING NR 5 GROUND SPOILER OUTBOARD HINGE CRACKED. REMOVED AND REPLACED NR 5 SPOILER PER MM.SDR SWAA072774Lens · missingRIGHT OVERWING EMERGENCY EXIT LIGHT LENS MISSING. INSTALLED LIGHT LENS PER MM.SDR SWAA072572Light · inoperativeDURING SCHEDULED SPV CHECK, FOUND R2 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA072573Light · inoperativeDURING SCHEDULED SPV CHECK, FOUND L2 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA072571Light · inoperativeDURING SCHEDULED SPV CHECK, FOUND R1 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA072569Stiffener · crackedDURING SCHEDULED SPV CHECK, FOUND RIGHT MLG W/W VERTICAL STIFFENER CRACKED AT BS 663, RBL 6.15. REMOVED AND REPLACED STIFFENER PER ACO.SDR SWAA072357Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA072244Slide · out of adjustR2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA071772Window · arcedFLIGHT DECK R2 WINDOW ARCHED AND CRACKED. REMOVED AND REPLACED WINDOW AND HEAT CONTROLLER PER MM.SDR SWAA071042Attach Fitting · brokenDURING SCHEDULED C4 CHECK, FOUND RIGHT ELEVATOR TAB CONTROL ATTACH POINT BROKEN. REMOVED AND REPLACED ELEVATOR TAB PER MM.SDR SWAA070542Control Rod · brokenDURING SCHEDULED C4 CHECK, FOUND RIGHT ELEVATOR TAB CONTROL ROD ATTACH POINT BROKEN. REMOVED AND REPLACED RIGHT ELEVATOR TAB PER MM.SDR SWAA070541Flap · delaminatedDURING SCHEDULED C4 CHECK, FOUND LEFT WING OUTBOARD T/E AFT FLAP DELAMINATED AT INBOARD T/E END. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA064114Skin · crackedDURING SCHEDULED C3 CHECK, FOUND LT WING NR 1 L/E SLAT LOWER T/E SKIN CRACKED. REPAIRED SLAT PER SWA EA.SDR SWAA064113Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 934, STR 25R. REPAIRED SKIN PER SWA EA.SDR SWAA063498Lens · brokenEMERGENCY EXIT SIGN LENS BROKEN AT ROW 11 DEF. REMOVED AND REPLACED SIGN LENS PER MM.SDR SWAA062987Lens · missingEMERGENCY EXIT SIGN LENS MISSING AT FWD CABIN. INSTALLED SIGN LENS PER MM.SDR SWAA062972Sign · missingRIGHT OVERWING EMERGENCY EXIT SIGN MISSING. INSTALLED SIGN PER MM.SDR SWAA062361Lamp · inoperativeDURING SCHEDULED MV1 CHECK, FOUND R1 DOOR EMERGENCY EXIT EXTERIOR LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA062024Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STR 16L CRACKED AT BS 360. REMOVED AND REPLACED STRINGER SECTION PER SRM.SDR SWAA061929Skin · delaminatedDURING SCHEDULED SPV CHECK, FOUND LT WING OUTBOARD T/E AFT FLAP DELAMINATED. REPAIRED T/E AFT FLAP PER SRM.SDR SWAA061915Stringer Splice · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER SPLICE CRACKED AT BS 360, STR 4L. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA061816Stringer Splice · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER SPLICE CRACKED AT BS 908, STR 4L. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA061802Bulkhead · crackedDURING SCHEDULED SPV CHECK, FOUND VERTICAL STIFFENER WEB CRACKED AT BULKHEAD BS 178, RBL 5.7. REPAIRED WEB PER SRM.SDR SWAA061801Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 360, STR 14R. REPAIRED SHEAR TIE PER SRM.
Back to N671SW, cancelled Jan 3, 2013