N660SW, cancelled Sep 19, 2016
Service difficulty reports · 531
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 = 'N660SW' AND deregistration_id = 'N660SW-2016-09-19' 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 = 'N660SW' AND deregistration_id = 'N660SW-2016-09-19' 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 SWAA075483Stringer · corrodedDURING SCHEDULED BRDG CHECK, FOUND STRINGER 21R CORRODED AT BS 360. REPAIRED STRINGER PER SRM.SDR SWAA075484Skin · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BS 410, STR 28L. REPAIRED SKIN PER SWA EA.SDR SWAA075485Skin · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BS 450, STR BL 0. REPAIRED SKIN PER SWA EA.SDR SWAA075478Tee Fitting · corrodedDURING SCHEDULED BRDG CHECK, FOUND BULKHEAD LOWER TEE CHORD CORRODED AT BS 227, LBL 10 TO RBL 10. REPAIRED CHORD PER SWA EA.SDR SWAA075401Battery · inoperativeDURING SCHEDULED BRDG CHECK, FOUND L1 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA075310Skin · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BS 410, STR 28L. REPAIRED SKIN PER SWA EA.SDR SWAA075311Skin · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BS 450, BL 0. REPAIRED SKIN PER SWA EA.SDR SWAA075271Flap Track · crackedDURING SCHEDULED BRDG CHECK, FOUND RT WING NR 7 FLAP TRACK CRACKED. REMOVED AND REPLACED FLAP TRACK PER SRM.SDR SWAA075270Flap Track · crackedDURING SCHEDULED BRDG CHECK, FOUND LT WING NR 2 FLAP TRACK CRACKED. REMOVED AND REPLACED FLAP TRACK PER SRM.SDR SWAA075232Tee Fitting · corrodedDURING SCHEDULED BRDG CHECK, FOUND BULKHEAD LOWER TEE CHORD CORRODED AT BS 227, BETWEEN LBL 10 AND RBL 10. REPAIRED TEE CHORD PER SWA EA.SDR SWAA075145Flap · delaminatedDURING SCHEDULED BRDG CHECK, FOUND LEFT WING INBOARD FOREFLAP DELAMINATED. REMOVED AND REPLACED FLAP PER MM.SDR SWAA075110Stringer · corrodedDURING SCHEDULED BRDG CHECK, FOUND STRINGER 21R CORRODED AT BS 360. REPAIRED STRINGER PER SRM.SDR SWAA075075Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 277, STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075042Skin · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 730E, STR 18R. REPAIRED SKIN PER SWA EA.SDR SWAA075028Slat · crackedDURING SCHEDULED BRDG CHECK, FOUND LT WING NR 2 L/E SLAT CRACKED OUTBOARD END. REPAIRED SLAT PER SRM.SDR SWAA075001Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRAKCED AT R2 DOOR UPPER HINGE CUTOUT AFT END. REPAIRED SKIN PER SRM.SDR SWAA074976Pressure Panel · crackedDURING SCHEDULED C1 CHECK, FOUND LNG W/W CEILING PANEL WEB CUTOUT CRACKED AT OUTBOARD END. REPAIRED WEB PER ACO.SDR SWAA074107Battery Pack · dischargedDURING SCHEDULED SERVICE CHECK, FOUND AFT CABIN EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA073052Skin · crackedDURING SCHEDULED C4 CHECK, FOUND RIGHT WING NR 6 L/E SLAT CRACKED AT FWD END. REPAIRED SLAT PER SWA EA.SDR SWAA073053Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 747, STR 19R. REPAIRED SKIN PER SWA EA.SDR SWAA072434Sign · brokenDURING SCHEDULED PM CHECK, FOUND RIGHT OVERWING EMERGENCY EXIT SIGN BROKEN. REMOVED AND REPLACED EXIT SIGN PER MM.SDR SWAA071428Window · arcedFLIGHT DECK R2 WINDOW ARCHED. REMOVED AND REPLACED R2 WINDOW PER MM.SDR SWAA070435Slide · inoperativeL1 DOOR EMERGENCY EVAC SLIDE INOP. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA070021Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 747, STR 21L. REPAIRED SKIN PER SWA EA.SDR SWAA065075Light · inoperativeDURING SCHEDULED MV1 CHECK, FOUND RIGHT OVERWING EMERGENCY EXIT SIDEWALL LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA064632Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 730E, STR 18R. REPAIRED SKIN PER SWA EA.SDR SWAA064631Skin · delaminatedDURING SCHEDULED C2 CHECK, FOUND LEFT WING INBOARD FOREFLAP DELAMINATED AT UPPER SURFACE. REMOVED AND REPLACED FOREFLAP PER MM.SDR SWAA064491Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT AFT GARGO DOOR AFT LOWER CUTOUT. REPAIRED SKIN PER ER.SDR SWAA064490Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT AFT GARGO DOOR FWD LOWER CUTOUT. REPAIRED SKIN PER ER.SDR SWAA064489Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE BELLY SKIN CRACKED AT RADIO ALT ANTENNA CUTOUT, BS 450. REPAIRED SKIN PER ER & BOEING SERVICE BULLETIN.SDR SWAA064465Failsafe · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME FAIL-SAFE CHORD CRACKED AT BS 440, STR 27R. REPAIRED CHORD PER SRM.SDR SWAA064326Slide · out of adjustDURING SCHEDULED SPV CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA062857Lamp · inoperativeDURING SCHEDULED C1 CHECK, FOUND EMERGENCY EXIT LIGHT INOP AT L2 DOOR. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA062789Hydraulic Line · leakingAIR TURN BACK, HYDRAULIC "B" SYSTEM FLUID LOSS. REMOVED AND REPLACED HYDRAULIC LINE AT "B" SYSTEM ACOUSTIC FILTER AND "B" SYSTEM RETURN FILTERS PER MM.SDR SWAA061841Slide · out of adjustFOUND R2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA061823Bulb · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND R2 DOOR EMERGENCY EXIT EXTERIOR LIGHT INOP. REMOVED AND REPLACED BULB PER MM.SDR SWAA061516Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR LOWER HINGE CUTOUT BEAR STRAP. REPAIRED SKIN PER SRM.SDR SWAA061515Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SWA EA.SDR SWAA061514Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA061152Charger · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND EMERGENCY EXIT LIGHT BATTERY CHARGER INOP AT BS 629. R&R BATTERY CHARGER PER MM.SDR SWAA060235Skin · delaminatedDURING SCHEDULED C3 CHECK, FOUND RIGHT WING INBOARD T/E FOREFLAP DELAMINATED. REMOVED AND REPLACED FOREFLAP PER MM.SDR SWAA060234Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 751, STR 19L. REPAIRED SKIN PER SWA EA.SDR SWAA060233Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 732D TO BS 742D, STR 20L TO STR 21L. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA060232Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 780, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA060231Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 837, STR 25L. REPAIRED SKIN PER SRM.SDR SWAA060230Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 747, STR 23R. REPAIRED SKIN PER SWA EA.SDR SWAA053008Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727D, STR 19L. REPAIRED SKIN PER SWA EA AND SRM.SDR SWAA052046Bulb · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND R2 DOOR EXTERNAL EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA051724Wire · chafedDIVERSION/DECLARED EMERGENCY. CABIN ALTITUDE HORN SOUNDED, PERFORMRED EMERGENCY PROCEDURE AND INITIATED EMERGENCY DESCENT. REPAIRED WIRING HARNESS ON BLEED VALVE PER WDM.SDR SWAA051639Floor Panel · crackedDURING SCHEDULED D-CHECK, FOUND 2 EA FUSELAGE FLOOR WEB CRACKS AT BS 188 TO BS 196, LEFT & RIGHT SIDE, WL 208. REMOVED AND REPLACED WEB SECTIONS PER SRM.
Back to N660SW, cancelled Sep 19, 2016