N670SW, cancelled Jan 8, 2022
Service difficulty reports · 454
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 = 'N670SW' AND deregistration_id = 'N670SW-2022-01-08' 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 = 'N670SW' AND deregistration_id = 'N670SW-2022-01-08' 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 SWAA060662Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 947.5, STR 23L. REPAIRED SKIN PER SWA EA.SDR SWAA052697Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR CUTOUT, FWD LOWER CORNER. REPAIRED SKIN PER SRM.SDR SWAA052696Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 303, L1 DOOR FWD LOWER STOP FITTING. REMOVED AND REPLACED STOP FITTING PER SRM.SDR SWAA052695Bulkhead · crackedDURING SCHEDULED 1/4D CHECK, FOUND BS 1016 BULKHEAD WEB CRACKED AT DOME CAP, 5 O'CLOCK POSITION. REPAIRED WEB PER SWA EA.SDR SWAA052694Floor Support · crackedDURING SCHEDULED 1/4D CHECK, FOUND LONGITUDINAL FLOOR SUPPORT CRACKED BETWEEN BS 660.5 TO BS 664, RBL 0.5, BL 0. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA052693Floor Support · crackedDURING SCHEDULED 1/4D CHECK, FOUND LONGITUDINAL FLOOR SUPPORT CRACKED BETWEEN BS 664 TO BS 668, RBL 24.75. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA052692Floorbeam · crackedDURING SCHEDULED 1/4D CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 664, LBL 24.75. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA052665Gusset · crackedDURING SCHEDULED 1/4D CHECK, FOUND R1 DOOR AFT LOWER GUSSET CRACKED. REMOVED AND REPLACED DOOR PER MM.SDR SWAA052649Angle · crackedDURING SCHEDULED 1/4D CHECK, FOUND BS 1016 AFT PRESSURE BLKHD Z-ANGLE CRACKED AT 6:30 O'CLOCK POSITION. REMOVED AND REPLACED Z-ANGLE PER SRM.SDR SWAA052214Window · looseDIVERSION, LOUD SQUEAL IN COCKPIT COMING FROM R1 WINDOW. RETORQUED COCKPIT R1 WINDOW PER MM.SDR SWAA052079Battery · inoperativeDURING SCHEDULED C2 CHECK, AFT CABIN EMERGENCY EXIT LIGHTS BATTERY FAILED TEST. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA052078Lens · looseDURING SCHEDULED C2 CHECK, FOUND BULLNOSE LIGHT LENS LOOSE AT ROW 21 ABC. SECURED LENS PER MM.SDR SWAA052077Skin · delaminatedDURING SCHEDULED C2 CHECK, FOUND RT WING OUTBOARD T/E AFT FLAP DELAMINATED. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA051495Skin · delaminatedDURING SCHEDULED RON CHECK, FOUND LT WING OUTBOARD T/E AFT FLAP DELAMINATED. REMOVED AND REPLACED FLAP PER MM.SDR SWAA051243Slide · out of adjustDURING SCHEDULED SERVICE CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA051049Battery Pack · dischargedDURING SCHEDULED SERVICE CHECK, FOUND AFT CABIN EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA050983Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727D, STR 19. REPAIRED SKIN PER SRM.SDR SWAA050981Skin · crackedDURING SCHEDULED C1 CHECK, FOUND LT HORIZONTAL STAB LOWER SKIN CRACKED AT INBOARD BALANCE BAY. REPAIRED SKIN PER SRM.SDR SWAA050980Skin · delaminatedDURING SCHEDULED C1 CHECK, FOUND RT WING OUTBOARD T/E FOREFLAP UPPER SURFACE DELAMINATED. REMOVED AND REPLACED FOREFLAP PER MM.SDR SWAA043640Lens · brokenDURING SCHEDULED C4 CHECK, FOUND BULLNOSE EMERGENCY EXIT LIGHT LENS AT ROW 11 ABC, BROKEN. REMOVED AND REPLACED LIGHT LENS PER MM.SDR SWAA043639Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND L1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED L1 DOOR EVAC SLIDE PER MM.SDR SWAA042326Angle · crackedDURING SCHEDULED C3 CHECK, FOUND ZEE ANGLE AT BS 664, RBL 31.83, CRACKED. REPAIRED ZEE ANGLE PER EA.SDR SWAA042318Lamp · inoperativeDURING SCHEDULED C3 CHECK, FOUND BULL NOSE EMERGENCY EXIT LIGHT AT ROW 21 ABC, INOP. RELAMPED LIGHT PER MM.SDR SWAA042283Slide · out of adjustL1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED L1 DOOR EVAC SLIDE PER MM.SDR SWAA041878Slide · out of limitsDURING SCHEDULED SERVICE CHECK, FOUND R2 DOOR EVAC SLIDE PRESSURE IND OUT OF LIMITS. REMOVED AND REPLACED R2 DOOR EVAC SLIDE PER MM.SDR SWAA041608Slide · deployedL1 DOOR EVAC SLIDE DEPLOYED. REMOVED AND REPLACED L1 DOOR EVAC SLIDE PER MM.SDR SWAA032482Fitting · corrodedDURING SCHEDULED SERVICE CHECK, FOUND BOTH LT AND RT MLG FWD WALKING BEAM HANGER FITTINGS CORRODED. REPAIRED FITTINGS PER SWA EA.SDR SWAA032338Slide · looseDURING SCHEDULED C4 CHECK, FOUND R2 DOOR EVACUATION SLIDE OUT OF ADJUST. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA031649Skin · delaminatedDURING SCHEDULED C3 CHECK, FOUND NR 3 FLIGHT SPOILER DELAMINATED. REMOVED AND REPLACED NR 3 FLIGHT SPOILER PER MM.SDR SWAA030994Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND AFT CARGO DOOR SKIN CRACKED AT AFT END OF HANDLE CUTOUT. REPAIRED SKIN PER SWA EA.SDR SWAA030985Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER TIE CLIPS CRACKED AT STR 10R, BS 597 & BS 578. REMOVED AND REPLACED STRINGER TIE CLIPS PER SRM.SDR SWAA030963Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B BELOW STR 20L. REPAIRED FUSELAGE FRAME PER SRM.SDR SWAA030943Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 616, BELOW STR 17L. REPAIRED FRAME PER SRM.SDR SWAA030746Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 942, STRINGER 24L. REPAIRED SKIN PER SRM.SDR SWAA030745Bulkhead · crackedDURING SCHEDULED C2 CHECK, FOUND BS 1016 BULKHEAD CRACKED BETWEEN 12 & 2 O'CLOCK POSITIONS. REPAIRED BULKHEAD PER SWA EA.SDR SWAA030725Slide · dislodgedFWD ENTRY DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT OF CONTAINER WHEN OPENING DOOR. REINSTALLED SLIDE PER MM.SDR SWAA023038Skin · crackedDURING SCHEDULED PM CHECK, FOUND FUSELAGE SKIN CRACKED (2 EA) AT STR 20L, BS 970 AND BS 980. REPAIRED SKIN PER SRM.SDR SWAA023022Skin · crackedDURING SCHEDULED C1 CHECK, FOUND AFT SVC DOOR OUTER SKIN CRACKED (2 EA) AT LOWER FWD CORNER ABOVE LOWER GATE. REMOVED AND REPLACED AFT SVC DOOR PER MM.SDR SWAA023021Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA021865Slide · unserviceableFWD ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA021863Slide · deployedFWD ENTRY DOOR EMERGENCY EVAC SLIDE INADVERTENLY DEPLOYED. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA021491Slide · unserviceableDURING SCHEDULED A2 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA020821Tab · wornDURING SCHEDULED A2 CHECK, SWA SI 11111-55, RT ELEVATOR TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED RT ELEVATOR TAB PER MM.SDR SWAA012563Slide · out of positionDURING SCHEDULED C4 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA011606Slide · out of positionDURING SCHEDULED C3 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EMERGENCY EVAC SLIDE PER MM.SDR SWAA011516Bearing · groovedDURING SCHEDULED SERVICE CHECK, FOUND GROOVED RT MLG TRUNNION BEARING. REMOVED AND REPLACED RT MLG TRUNNION BEARING PER MM.SDR SWAA011521Beam · wornDURING SCHEDULED SERVICE CHECK, FOUND RT MLG ACTUATOR CLEVIS BEAM ARM BUSHING WORN AND CORRODED. REMOVED AND REPLACED CLEVIS BEAM ARM PER MM.SDR SWAA010939Transmitter · malfunctionedDECLARED EMERGENCY, L/E & T/E FLAPS WOULD NOT EXTEND USING NORMAL METHOD. EXTENDED NORMALLY USING ALT FLAP SYSTEM. REMOVED AND REPLACED LT AND RT FLAP POS TRANSMITTERS PER MM. OPS CHECK NORMAL.SDR SWAA010915Indicator · malfunctionedDECLARED EMERGENCY, L/E AND T/E DEVICES WOULD NOT EXTEND. A AND B HYD SYSTEM NORMAL. EXTENDED FLAPS USING ALT FLAP SYSTEM. CLEANED FLAP POS IND AND OPERATED FLAPS PER MM AT HOU. REMOVED AND REPLACED FLAP POS INDICATOR FOR MX CONVENIENCE PER MM.SDR SWAA002533Slide · unserviceableDURING SCHEDULED 1/4D CHECK, FOUND AFT SERVICE DOOR EVAC SLIDE PRESSURE INDICATOR LOW. R&R SLIDE ASY PER MM.
Back to N670SW, cancelled Jan 8, 2022