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 SWAA010383Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND EXTERNAL FUSELAGE SKIN CRACK AT BS 870, STR 23R. REPAIRED SKIN PER SRM.SDR SWAA010358Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT SVC DOOR CUTOUT, BS 294, WL 208. REPAIRED FRAME PER SRM.SDR SWAA010357Crease Beam · crackedDURING SCHEDULED 1/2D CHECK, FOUND CREASE BEAM WEB CRACKED AT LT SIDE, BS 616 TO BS 639. REPAIRED CREASE BEAM WEB PER SRM.SDR SWAA010341Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND 2 STRINGER CLIPS CRACKED AT BS 663, STRS 10R & 10L. REMOVED AND REPLACED STRINGER CLIPS PER SRM.SDR SWAA010337Bulkhead · crackedDURING SCHEDULED 1/2D CHECK, FOUND BS 178 BULKHEAD WEB CRACKED AT RBL 4.75, WL 202. REPAIRED BULKHEAD WEB PER SRM.SDR SWAA010327Bulkhead · crackedDURING SCHEDULED 1/2D CHECK, FOUND 3 BS 178 BULKHEAD WEB CRACKS AT WL 234, LBL 12, LBL 10 & RBL 10. REPAIRED BULKHEAD WEB PER SRM.SDR SWAA002171Skin · corrodedDURING SCHEDULED SPECIAL VISIT, FOUND SKIN BULGED AT BS 741, KEEL BEAM, LT. REPAIRED SKIN PER RA 1-353-2387.SDR SWAA002120Skin · crackedDURING SCHEDULED A1 CHECK, FOUND 3.5 FUSELAGE SKIN CRACK AT BS 750, STR 23R. REPAIRED SKIN PER SRM.SDR SWAA001609Light · inoperativeDURING SCHEDULED C4 CHECK, FOUND FWD SERVICE DOOR EMERGENCY LIGHT INOP. RELAMPED PER MM.SDR SWAA000164Line · contaminatedAIR TURNBACK, NR 1 ENG A-SYS HYD LOW PRESS LIGHT ILLUMINATED AND NLG WOULD NOT RETRACT. FOUND AIR TRAPPED ON NR 1 ENG HYD PUMP SUPPLY LINE WHICH WAS PREVIOUSLY REMOVED AND REPLACED BLED SYS. OPS CHECKED GOOD PER MM.SDR SWAA991502Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED, BS 767, STRINGER 19L. REPAIRED SKIN PER SRM.SDR SWAA991237Battery Charger · inopDURING SCHEDULED SERVICE CHECK, FOUND FWD ENTRY DOOR EVACUATION SLIDE EMERGENCY LIGHT INOP. REMOVED AND REPLACED FWD ENTRY DOOR SLIDE EMERGENCY LIGHT BATTERY CHARGER ASSY PER MM.SDR SWAA990779Light · looseEMERGENCY OVERHEAD EXIT LIGHT AT ROW 23 CAME LOOSE. RESECURED LIGHT ASSY PER MM.SDR SWAA981407Web · misdrilledDURING SCHEDULED TRANSITION CHECK, FOUND PREVIOUSLY PLUGED HOLE IN WEB AT BS 279 WL 192 LBL 16. REPAIRED PER BOEING MM.SDR SWAA981406Angle · damagedDURING SCHEDULED TRANSITION CHECK, FOUND ANGLE BS 1000, RBL 45, WL 208 HAS ELONGATED FASTENER HOLE. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981197Floorbeam · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED FLOORBEAM AT BS 312, RBL 7 TO 25 LBL 10 TO 12, WL 207 TO 208. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981086Bulkhead Panel · crackedDURING SCHEDULED SERVICE CHECK, FOUND CRACKED FWD CARGO BAY FWD BULKHEAD PANEL AT BS 380 RBL 12 WL 183. REPAIRED PER BOEING SRM.SDR SWAA981085Skin · dentedDURING SCHEDULED SERVICE CHECK, FOUND DENTED SKIN DOUBLER AT BS 371 TO 374 BETWEEN STR 22 AND 23 RT. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981084Shear Tie · crackedDURING SCHEDULED SERVICE CHECK, FOUND CRACKED SHEAR TIE AT BS 344 BETWEEN STR 20 AND 21 RT. REPAIRED PER BOEING SRM.SDR SWAA981083Seal · tornDURING SCHEDULED SERVICE CHECK, FOUND TORN LT MLG BEAM PANEL FWD BULB SEAL. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981082Skin · dentedDURING SCHEDULED SERVICE CHECK, FOUND DENTED SKIN JUST FWD AT BS 500B BETWEEN STR 20 AND 21 LT AND AT BS 764 TO 767, STR 21 TO 23. RT. REPAIRED PER BOEING SRM.SDR SWAA981019Skin · dentedDURING SCHEDULED TRAN CHECK, FOUND DENT BELOW AFT CARGO DOOR AT BS 806, STR 26 RT. REPAIRED PER BOEING SRM.SDR SWAA981009Skin · dentedDURING SCHEDULED TRAN CHECK, FOUND DENTED FUSELAGE EXTERIOR SKIN AT BS 310, STR 24R. REPAIRED PER BOEING SRM.SDR SWAA980953Bulkhead Web · crackedDURING SERVICE CHECK, FOUND CRACKED INDICATIONS AT BS 178 PRESSURE BULKHEAD WEB AT RBL 4.7, WL 201.5 TO 200.0 AND WL 198.4 TO 197.8. REPAIRED PER BOEING SRM.SDR SWAA980952Skin · gougedDURING SERVICE CHECK, FOUND GOUGED AREA, RIGHT HAND I/B FOREFLAP UPPER SURFACE 13 FROM I/B END. REPAIRED PER BOEING SRM.SDR SWAA980889Wedge · gougedDURING SERVICE CHECK, FOUND GOUGED R/W I/B MIDFLAP T/E WEDGE LOWER SURFACE AT I/B T/E CORNER. REPAIRED PER BOEING SRM.SDR SWAA980888Floorbeam · corrodedDURING SERVICE CHECK, FOUND CORRODED FLOORBEAM AT BS 328, RBL 12-40, WL 207-208. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980887Web · drilledDURING SERVICE CHECK, FOUND HORIZONTAL PRESSURE WEB HAS DRILL START ON LOWER SURFACE AT BS 669, LBL 23 AT MLG WHEEL WELL. REPAIRED PER BOEING SRM.SDR SWAA980886Bulkhead Web · crackedDURING SERVICE CHECK, FOUND CRACKED BS 178 PRESSURE BULKHEAD WEB AT LBL 4.7, WL 201.25 - 200.25 AND WL 198.7 - 197.5. REPAIRED PER BOEING SRM.SDR SWAA980885Skin · dentedDURING SERVICE CHECK, FOUND NUMEROUS SKIN DENTS AT BS 500+10- 500A BETWEEN STR 21 AND 22 RT. REPAIRED PER BOEING SRM.SDR SWAA980884Panel · crackedDURING SERVICE CHECK, FOUND CRACKED LT PYLON INBOARD SIDE, AT PANEL 5742, DOUBLER AT AFT EDGE OF PANEL CUTOUT. REMOVED AND REPLACED PER BOEING SRM.
Back to N660SW, cancelled Sep 19, 2016