N650SW, cancelled Nov 6, 2017
Service difficulty reports · 316
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 = 'N650SW' AND deregistration_id = 'N650SW-2017-11-06' 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 = 'N650SW' AND deregistration_id = 'N650SW-2017-11-06' 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 SWAA032361Skin · debondedDURING SCHEDULED C4 CHECK, FOUND RT WING INBD AFT T/E FLAP DISBONDED AT OUTBD END. REMOVED AND REPLACED FLAP PER MM.SDR SWAA031614Flap · delaminatedDURING SCHEDULED C3 CHECK, FOUND LT OUTBD AFT T/E FLAP DELAMINATED ON INBD EDGE. REMOVED AND REPLACED LT OUTBD AFT T/E FLAP PER MM.SDR SWAA031375Slide · dislodgedFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA030780Strut · corrodedDURING SCHEDULED SERVICE CHECK, FOUND LT MLG UPPER STRUT CORRODED. REMOVED AND REPLACED LEFT MLG OUTER CYLINDER PER MM.SDR SWAA030779Trunion Pin · corrodedDURING SCHEDULED SERVICE CHECK, FOUND BOTH LEFT AND RIGHT MLG TRUNNION PINS CORRODED. REMOVED AND REPLACED BOTH LT AND RT MLG TRUNNION PINS PER MM.SDR SWAA030043Light · inoperativeDURING SCHEDULED BC1 CHECK, FOUND OVERHEAD EMERGENCY EXIT LIGHT INOP NEAR FWD GALLEY. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA023002Flange · bentAFTER LANDING FWD ENTRY DOOR WOULD NOT OPEN. UNJAMMED FWD ENTRY DOOR, STRAIGHTEN OUT UPPER RT CORNER FLANGE AND REPAIRED SEAL PER MM.SDR SWAA021596Light · inoperativeDURING SCHEDULED PM CHECK, FOUND AFT ENTRY DOOR OVERHEAD EMERGENCY EXIT LIGHT INOP. RELAMPED EXIT LIGHT PER MM.SDR SWAA021224Shear Tie · crackedDURING SCHEDULED SERVICE CHECK, FOUND SHEAR TIE'S CRACKED (2 EA) BETWEEN STR'S 21R AND 22R AT BS'S 294.5 AND BS 277. REPAIRED SHEAR TIE'S PER SRM.SDR SWAA020284Bracket · looseDURING SCHEDULED C2 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR HOLDER LOOSE. SECURED GIRT BAR HOLDER PER MM.SDR SWAA020279Light · inoperativeDURING SCHEDULED C2 CHECK, FOUND EEPLS INOP AT ROW NR 7. RELAMPED EEPLS PER MM.SDR SWAA013334Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA012973Cover · brokenDURING SCHEDULED C1 CHECK, FOUND EEPLS COVERS BROKEN AT ROWS 14, 16 & 17. R&R EEPLS COVERS PER MM.SDR SWAA002685Wire · damagedDURING SCHEDULED SPECIAL VISIT, FOUND EEPLS INOP AT ROWS 12 TO 17. REPAIRED EEPLS WIRING PER MM.SDR SWAA000671Slide · dislodgedFWD ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER DURING DOOR OPENING. RE-INSTALLED SLIDE ASSY PER MM.SDR SWAA980419Tires · flatAFTER LANDING, FOUND NR 3 AND NR 4 WHEEL TIRES FLAT, WITH NR 3 WHEEL TIRE MISSING A 3 X 6 INCH PIECE OF TREAD. INSPECTED AND REPLACED NR 3 AND NR 4 WHEEL TIRE ASSY PER BOEING MM.
Back to N650SW, cancelled Nov 6, 2017