N504SW, cancelled Oct 27, 2017
Service difficulty reports · 277
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 = 'N504SW' AND deregistration_id = 'N504SW-2017-10-27' 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 = 'N504SW' AND deregistration_id = 'N504SW-2017-10-27' 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 SWAA010413Structure · crackedDURING SCHEDULED C4 CHECK, FOUND AFT CARGO DOOR CRACKED INSIDE AT LOWER FWD CORNER ANGLE BRACKET, WEB SKIN AND FWD SIDE OF DOOR, INSIDE, LOWER SIDE STOP FITTING FASTENER. REMOVED AND REPLACED AFT CARGO DOOR PER MM.SDR SWA002780Slide · out of adjFWD SVC DOOR EMERGENCY EVAC SLIDE SLIDE ASSY OUT OF ADJUST. REPOSITIONED EVAC SLIDE ASSY PER MM.SDR SWAA002555Skin · crackedDURING SCHEDULED PM CHECK, FOUND FUSELAGE EXT SKIN CRACKED, BS 748-751, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA002121Cover · brokenDURING SCHEDULED C3 CHECK, FOUND EEPLS TRACK BROKEN AT ROW 8. REMOVED AND REPLACED TRACK COVER PER MM.SDR SWAA001870Light · looseFWD SECTION EEPLS TRACK ASSY LOOSE. INSTALLED EEPLS END-CAP ASSY PER MM.SDR SWAA001531Slide · dislodgedFWD ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER WHEN DOOR WAS OPENED. REINSTALLED SLIDE ASSY PER MM.SDR SWAA000082Sensor · erraticABORTED TAKEOFF, TAKEOFF WARNING SOUNDED. FLAPS, SPEED BRAKE, AND TRIM SET PROPERLY. CLEANED NR 1 AND NR 4 L/E FLAP EXTEND PROX SENSORS. OPS CK GOOD PER MM.SDR SWAA000028Frame · crackedDURING SCHEDULED D CHECK, FOUND BS 178 BULKHEAD LT AND RT SIDE CHORDS CRACKED, WL 207. REPAIRED PER SRM.SDR SWAA000027Bulkhead · crackedDURING SCHEDULED D CHECK, FOUND BS 178 BULKHEAD 3 EACH CRACKS, RBL1- LBL 6. REPAIRED BULKHEAD PER SRM.SDR SWAA992089Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM UPPER SURFACE CORRODED, BS 986, LBL 45 TO RBL 45. REPAIRED FLOORBEAM PER RE NR 99-6451.SDR SWAA992088Stringer · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER SPILCE 4L CRACKED, BS 907. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA992087Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED, BS 291, BETWEEN STRINGERS 12R-13R. REPAIRED FRAME PER SRM.SDR SWAA992064Clip · crackedDURING SCHEDULED D CHECK, FOUND STRINGER CLIP CRACKED, BS 312, STRINGER 18R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA992048Shear Tie · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE SHEAR TIE CRACKED, BS 967, STRINGER 6L. REPAIRED SHEAR TIE PER SRM.SDR SWAA992047Angle · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE INNER SKIN WEB ANGLES CRACKED, BS 291, BETWEEN STRINGERS 10R-12R. REMOVED AND REPLACED ANGLES PER SRM.SDR SWAA991897Slides · out of adjustDURING SCHEDULED SERVICE CHECK, FOUND BOTH ENTRY DOOR EVACUATION SLIDE GIRT ASSY'S EXTENDING OUT OF LIMITS. ADJUSTED SLIDE ASSY'S PER MM.SDR SWAA991199Light · out of trackEEPLS LIGHTS PULLED OUT OF TRACK. RE-INSTALLED LIGHTS PER MM.SDR SWAA990930Cover · brokenFWD ENTRY DOOR EMERGENCY EXIT LIGHT COVER BROKEN. REMOVED AND REPLACED COVER PER MM.SDR SWAA990549Slide · low pressureL2 DOOR SLIDE PRESSURE GAUGE IN RED. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA983088Frame · crackedDURING SCHEDULED C4 CHECK, FOUND FORWARD CARGO AFT DOORWAY FRAME AT UPPER CORNER CRACKED 1 INCH LONG. REPAIRED PER SWA RA 1-553-1949.SDR SWAA983087Frame · crackedDURING SCHEDULED C4 CHECK, FOUND FORWARD CARGO DOORWAY AFT FRAME UPPER CORNER CRACKED 1.5 INCH LONG. REPAIRED PER SWA RA 1-553-1949.SDR SWAA983071Frame · crackedDURING SCHEDULED CHECK, FOUND A 1 INCH CRACK IN AFT DOORWAY FRAME AT LOWER CORNER MOST I/B STOP. REPAIRED PER SWA RA 1-553-1949.SDR SWAA981909Slide · detachedDURING WALKAROUND CHECK, FOUND EMERGENCY ESCAPE SLIDE FELL OUT OF FIBERGLASS SHELL. F/A WAS UNABLE TO ATTACH GIRT BAR. REINSTALLED SLIDE PER BOEING MM.SDR SWAA981908Light · brokenDURING WALKAROUND CHECK, FOUND FWD ENTRY EMERGENCY EXIT LIGHT BROKEN. REMOVED AND REPLACED FWD ENTRY EMERGENCY EXIT LIGHT, OPS CKS OK PER BOEING MM.SDR SWAA981660Lights · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND TWO EMERGENCY LIGHTS INOP IN FLOOR TRACK ROW 10. REPAIRED PER BOEING SRM.SDR SWAA981054Slide · out of caseDURING WALKAROUND CHECK, FOUND LEFT FWD EMERGENCY SLIDE CAME OUT OF CONTAINER WHEN DOOR WAS SHUT FOR PUSH BACK. REINSTALLED SLIDE IN HARD CASE PER BOEING MM.SDR SWAA970517Skin · damagedDURING SCHEDULED A2 CHECK, FOUND NUMEROUS AREA OF LIGHTNING STRIKE DAMAGE AT LEFT FUSELAGE SKIN ALONG WINDOWS 4, 5 AND 7. REPAIRED PER BOEING SRM.
Back to N504SW, cancelled Oct 27, 2017